Training Detail Table

 

At the end of the analysis, a Training Detail Table is created in SQL (among other SQL generated tables) to show the results at a granular level of detail. If a Detail Key was selected for one of the fields, the Training Detail Table will be output at the level of the Detail Key. If no field is designated as the Detail Key, the Training Detail Table is created at the lowest level of granularity created by the columns in the analysis.

 

Table Name: OutputPrefix_Final_Detail

 

Training Detail Table Layout:

 

Field Name

Data Type

Explanation

KeyID

data type of the Detail Key

The Detail Key for each record

Exposure

float

The amount of Exposure for each record

Actual_Target

float

The amount of Target  for each record

Model_Target

float

The Modeled Target for each record

Modified_Target

float

The Modified Target for each record (this includes Curve Modification)

value_characteristic1

data type of the characteristic

The value that characteristic 1 takes for each record

factor_characteristic1

float

The modeled factor for characteristic 1, as of the final iteration

value_characteristic2

data type of the characteristic

The value that characteristic 2 takes for each record

factor_characteristic2

float

The modeled factor for characteristic 2, as of the final iteration

...

 

 

...

 

 

 

A set of value and factor outputs are created for each of the characteristics used in the analysis.