Version: 24.1.0.707
About this document
Data items that list a Table Name and Table Column are derived from the UltiPro tables. Data items that list an expression in the Calculation column are not stored in the UltiPro database, but are derived from UltiPro fields. Every data item will have either 1) information in the Table Name and Table Column, or 2) information in the Calculation column, but not both.
Data items with a role named in the Restrictions column are subject to field level security. Users assigned to the role named in the Restrictions column are not able to view the data item in a report.
Note: Click on a column heading to sort the list.
Item Name | Description | Path | Data Type | Table Name | Table Column | Calculation | Restrictions |
---|---|---|---|---|---|---|---|
Bonus Applied Exception Count | The count of all "Bonus Applied" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Bonus Applied Exception Count] | int64 | ||||
Break Out Of Sequence Exception Count | The count of all "Break Out Of Sequence" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Break Out Of Sequence Exception Count] | int64 | ||||
Cancelled Deduction Exception Count | The count of all "Cancelled Deduction" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Cancelled Deduction Exception Count] | int64 | ||||
Early In Exception Count | The count of all "Early In" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Early In Exception Count] | int64 | ||||
Early Out Exception Count | The count of all "Early Out" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Early Out Exception Count] | int64 | ||||
Excused Absence Exception Count | The count of all "Excused Absence" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Excused Absence Exception Count] | int64 | ||||
Holiday Scheduled Violation Exception Count | The count of all "Holiday Scheduled Violation" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Holiday Scheduled Violation Exception Count] | int64 | ||||
Late In Exception Count | The count of all "Late In" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Late In Exception Count] | int64 | ||||
Late Out Exception Count | The count of all "Late Out" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Late Out Exception Count] | int64 | ||||
Long Break Exception Count | The count of all "Long Break" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Long Break Exception Count] | int64 | ||||
Long Shift Exception Count | The count of all "Long Shift" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Long Shift Exception Count] | int64 | ||||
Long Total Break Exception Count | The count of all "Long Total Break" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Long Total Break Exception Count] | int64 | ||||
Minimum Days Active Exception Count | The count of all "Minimum Days Active" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Minimum Days Active Exception Count] | int64 | ||||
Minimum Days Employed Exception Count | The count of all "Minimum Days Employed" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Minimum Days Employed Exception Count] | int64 | ||||
Missed In Punch Exception Count | The count of all "Missed In Punch" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Missed In Punch Exception Count] | int64 | ||||
Missed Out Punch Exception Count | The count of all "Missed Out Punch" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Missed Out Punch Exception Count] | int64 | ||||
Short Break Exception Count | The count of all "Short Break" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Short Break Exception Count] | int64 | ||||
Short Shift Exception Count | The count of all "Short Shift" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Short Shift Exception Count] | int64 | ||||
Short Total Break Exception Count | The count of all "Short Total Break" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Short Total Break Exception Count] | int64 | ||||
Unexcused Absence Exception Count | The count of all "Unexcused Absence" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Unexcused Absence Exception Count] | int64 | ||||
Unscheduled Exception Count | The count of all "Unscheduled" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Unscheduled Exception Count] | int64 | ||||
Very Early In Exception Count | The count of all "Very Early In" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Very Early In Exception Count] | int64 | ||||
Very Late Out Exception Count | The count of all "Very Late Out" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Counts].[Very Late Out Exception Count] | int64 | ||||
Unreviewed Bonus Applied Exception Count | The count of all unreviewed "Bonus Applied" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Bonus Applied Exception Count] | int64 | ||||
Unreviewed Early In Exception Count | The count of all unreviewed "Early In" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Early In Exception Count] | int64 | ||||
Unreviewed Early Out Exception Count | The count of all unreviewed "Early Out" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Early Out Exception Count] | int64 | ||||
Unreviewed Late In Exception Count | The count of all unreviewed "Late In" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Late In Exception Count] | int64 | ||||
Unreviewed Late Out Exception Count | The count of all unreviewed "Late Out" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Late Out Exception Count] | int64 | ||||
Unreviewed Long Break Exception Count | The count of all unreviewed "Long Break" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Long Break Exception Count] | int64 | ||||
Unreviewed Long Shift Exception Count | The count of all unreviewed "Long Shift" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Long Shift Exception Count] | int64 | ||||
Unreviewed Long Total Break Exception Count | The count of all unreviewed "Long Total Break" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Long Total Break Exception Count] | int64 | ||||
Unreviewed Short Break Exception Count | The count of all unreviewed "Short Break" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Short Break Exception Count] | int64 | ||||
Unreviewed Short Shift Exception Count | The count of all unreviewed "Short Shift" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Short Shift Exception Count] | int64 | ||||
Unreviewed Short Total Break Exception Count | The count of all unreviewed "Short Total Break" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Short Total Break Exception Count] | int64 | ||||
Unreviewed Unscheduled Exception Count | The count of all unreviewed "Unscheduled" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Unscheduled Exception Count] | int64 | ||||
Unreviewed Very Early In Exception Count | The count of all unreviewed "Very Early In" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Very Early In Exception Count] | int64 | ||||
Unreviewed Very Late Out Exception Count | The count of all unreviewed "Very Late Out" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Very Late Out Exception Count] | int64 | ||||
Unreviewed Break Out Of Sequence Exception Count | The count of all unreviewed "Break Out Of Sequence" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Unreviewed Exception Counts].[Unreviewed Break Out Of Sequence Exception Count] | int64 | ||||
Early In Over Limit Hours | The duration, in hours, the in punch is over the defined "Early In" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Early In Over Limit Hours] | float64 | ||||
Early In Exception Hours | The duration, in hours, of all "Early In" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Early In Exception Hours] | float64 | ||||
Early Out Over Limit Hours | The duration, in hours, the in punch is over the defined "Early Out" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Early Out Over Limit Hours] | float64 | ||||
Early Out Exception Hours | The duration, in hours, of all "Early Out" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Early Out Exception Hours] | float64 | ||||
Excused Absence Exception Hours | The duration, in hours, of all "Excused Absence" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Excused Absence Exception Hours] | float64 | ||||
Late In Over Limit Hours | The duration, in hours, the in punch is over the defined "Late In" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Late In Over Limit Hours] | float64 | ||||
Late In Exception Hours | The duration, in hours, of all "Late In" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Late In Exception Hours] | float64 | ||||
Late Out Over Limit Hours | The duration, in hours, the in punch is over the defined "Late Out" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Late Out Over Limit Hours] | float64 | ||||
Late Out Exception Hours | The duration, in hours, of all "Late Out" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Late Out Exception Hours] | float64 | ||||
Long Break Over Limit Hours | The duration, in hours, the in punch is over the defined "Long Break" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Long Break Over Limit Hours] | float64 | ||||
Long Break Exception Hours | The duration, in hours, of all "Long Break" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Long Break Exception Hours] | float64 | ||||
Long Shift Over Limit Hours | The duration, in hours, the in punch is over the defined "Long Shift" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Long Shift Over Limit Hours] | float64 | ||||
Long Shift Exception Hours | The duration, in hours, of all "Long Shift" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Long Shift Exception Hours] | float64 | ||||
Long Total Break Over Limit Hours | The duration, in hours, the in punch is over the defined "Long Total Break" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Long Total Break Over Limit Hours] | float64 | ||||
Long Total Break Exception Hours | The duration, in hours, of all "Long Total Break" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Long Total Break Exception Hours] | float64 | ||||
Short Break Over Limit Hours | The duration, in hours, the in punch is over the defined "Short Break" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Short Break Over Limit Hours] | float64 | ||||
Short Break Exception Hours | The duration, in hours, of all "Short Break" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Short Break Exception Hours] | float64 | ||||
Short Shift Over Limit Hours | The duration, in hours, the in punch is over the defined "Short Shift" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Short Shift Over Limit Hours] | float64 | ||||
Short Shift Exception Hours | The duration, in hours, of all "Short Shift" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Short Shift Exception Hours] | float64 | ||||
Short Total Break Over Limit Hours | The duration, in hours, the in punch is over the defined "Short Total Break" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Short Total Break Over Limit Hours] | float64 | ||||
Short Total Break Exception Hours | The duration, in hours, of all "Short Total Break" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Short Total Break Exception Hours] | float64 | ||||
Unexcused Absence Exception Hours | The duration, in hours, of all "Unexcused Absence" exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Unexcused Absence Exception Hours] | float64 | ||||
Very Early In Over Limit Hours | The duration, in hours, the in punch is over the defined "Very Early In" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Very Early In Over Limit Hours] | float64 | ||||
Very Early In Exception Hours | The duration, in hours, of all "Very Early In" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Very Early In Exception Hours] | float64 | ||||
Very Late Out Over Limit Hours | The duration, in hours, the in punch is over the defined "Very Late Out" threshold. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Very Late Out Over Limit Hours] | float64 | ||||
Very Late Out Exception Hours | The duration, in hours, of all "Very Late Out" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Hours].[Very Late Out Exception Hours] | float64 | ||||
Early In Violation Cost | The computed cost of all "Early In" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Costs].[Early In Violation Cost] | float64 | ||||
Late Out Violation Cost | The computed cost of all "Late Out" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Costs].[Late Out Violation Cost] | float64 | ||||
Short Break Over Limit Cost | The computed cost of all "Short Break" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Costs].[Short Break Over Limit Cost] | float64 | ||||
Short Total Break Over Limit Cost | The computed cost of all "Short Total Break" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Costs].[Short Total Break Over Limit Cost] | float64 | ||||
Very Early In Violation Cost | The computed cost of all "Very Early In" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Costs].[Very Early In Violation Cost] | float64 | ||||
Very Late Out Violation Cost | The computed cost of all "Very Late Out" exceptions. Includes both reviewed and unreviewed exceptions. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Exception Counts, Hours & Costs].[Total Exception Costs].[Very Late Out Violation Cost] | float64 | ||||
Current Forecast Volume (Driver 1) | The current forecast volume for the volume driver identified as "Driver 1". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 1)] | float64 | ||||
Current Forecast Volume (Driver 2) | The current forecast volume for the volume driver identified as "Driver 2". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 2)] | float64 | ||||
Current Forecast Volume (Driver 3) | The current forecast volume for the volume driver identified as "Driver 3". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 3)] | float64 | ||||
Current Forecast Volume (Driver 4) | The current forecast volume for the volume driver identified as "Driver 4". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 4)] | float64 | ||||
Current Forecast Volume (Driver 5) | The current forecast volume for the volume driver identified as "Driver 5". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 5)] | float64 | ||||
Current Forecast Volume (Driver 6) | The current forecast volume for the volume driver identified as "Driver 6". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 6)] | float64 | ||||
Current Forecast Volume (Driver 7) | The current forecast volume for the volume driver identified as "Driver 7". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 7)] | float64 | ||||
Current Forecast Volume (Driver 8) | The current forecast volume for the volume driver identified as "Driver 8". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 8)] | float64 | ||||
Current Forecast Volume (Driver 9) | The current forecast volume for the volume driver identified as "Driver 9". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 9)] | float64 | ||||
Current Forecast Volume (Driver 10) | The current forecast volume for the volume driver identified as "Driver 10". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 10)] | float64 | ||||
Current Forecast Volume (Driver 11) | The current forecast volume for the volume driver identified as "Driver 11". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 11)] | float64 | ||||
Current Forecast Volume (Driver 12) | The current forecast volume for the volume driver identified as "Driver 12". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 12)] | float64 | ||||
Current Forecast Volume (Driver 13) | The current forecast volume for the volume driver identified as "Driver 13". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 13)] | float64 | ||||
Current Forecast Volume (Driver 14) | The current forecast volume for the volume driver identified as "Driver 14". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 14)] | float64 | ||||
Current Forecast Volume (Driver 15) | The current forecast volume for the volume driver identified as "Driver 15". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 15)] | float64 | ||||
Current Forecast Volume (Driver 16) | The current forecast volume for the volume driver identified as "Driver 16". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 16)] | float64 | ||||
Current Forecast Volume (Driver 17) | The current forecast volume for the volume driver identified as "Driver 17". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 17)] | float64 | ||||
Current Forecast Volume (Driver 18) | The current forecast volume for the volume driver identified as "Driver 18". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 18)] | float64 | ||||
Current Forecast Volume (Driver 19) | The current forecast volume for the volume driver identified as "Driver 19". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 19)] | float64 | ||||
Current Forecast Volume (Driver 20) | The current forecast volume for the volume driver identified as "Driver 20". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 20)] | float64 | ||||
Current Forecast Volume (Driver 21) | The current forecast volume for the volume driver identified as "Driver 21". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 21)] | float64 | ||||
Current Forecast Volume (Driver 22) | The current forecast volume for the volume driver identified as "Driver 22". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 22)] | float64 | ||||
Current Forecast Volume (Driver 23) | The current forecast volume for the volume driver identified as "Driver 23". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 23)] | float64 | ||||
Current Forecast Volume (Driver 24) | The current forecast volume for the volume driver identified as "Driver 24". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 24)] | float64 | ||||
Current Forecast Volume (Driver 25) | The current forecast volume for the volume driver identified as "Driver 25". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume (Current)].[Current Forecast Volume (Driver 25)] | float64 | ||||
Generated Forecast Volume (Driver 1) | The generated forecast volume for the volume driver identified as "Driver 1". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 1)] | float64 | ||||
Generated Forecast Volume (Driver 2) | The generated forecast volume for the volume driver identified as "Driver 2". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 2)] | float64 | ||||
Generated Forecast Volume (Driver 3) | The generated forecast volume for the volume driver identified as "Driver 3". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 3)] | float64 | ||||
Generated Forecast Volume (Driver 4) | The generated forecast volume for the volume driver identified as "Driver 4". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 4)] | float64 | ||||
Generated Forecast Volume (Driver 5) | The generated forecast volume for the volume driver identified as "Driver 5". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 5)] | float64 | ||||
Generated Forecast Volume (Driver 6) | The generated forecast volume for the volume driver identified as "Driver 6". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 6)] | float64 | ||||
Generated Forecast Volume (Driver 7) | The generated forecast volume for the volume driver identified as "Driver 7". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 7)] | float64 | ||||
Generated Forecast Volume (Driver 8) | The generated forecast volume for the volume driver identified as "Driver 8". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 8)] | float64 | ||||
Generated Forecast Volume (Driver 9) | The generated forecast volume for the volume driver identified as "Driver 9". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 9)] | float64 | ||||
Generated Forecast Volume (Driver 10) | The generated forecast volume for the volume driver identified as "Driver 10". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 10)] | float64 | ||||
Generated Forecast Volume (Driver 11) | The generated forecast volume for the volume driver identified as "Driver 11". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 11)] | float64 | ||||
Generated Forecast Volume (Driver 12) | The generated forecast volume for the volume driver identified as "Driver 12". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 12)] | float64 | ||||
Generated Forecast Volume (Driver 13) | The generated forecast volume for the volume driver identified as "Driver 13". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 13)] | float64 | ||||
Generated Forecast Volume (Driver 14) | The generated forecast volume for the volume driver identified as "Driver 14". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 14)] | float64 | ||||
Generated Forecast Volume (Driver 15) | The generated forecast volume for the volume driver identified as "Driver 15". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 15)] | float64 | ||||
Generated Forecast Volume (Driver 16) | The generated forecast volume for the volume driver identified as "Driver 16". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 16)] | float64 | ||||
Generated Forecast Volume (Driver 17) | The generated forecast volume for the volume driver identified as "Driver 17". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 17)] | float64 | ||||
Generated Forecast Volume (Driver 18) | The generated forecast volume for the volume driver identified as "Driver 18". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 18)] | float64 | ||||
Generated Forecast Volume (Driver 19) | The generated forecast volume for the volume driver identified as "Driver 19". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 19)] | float64 | ||||
Generated Forecast Volume (Driver 20) | The generated forecast volume for the volume driver identified as "Driver 20". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 20)] | float64 | ||||
Generated Forecast Volume (Driver 21) | The generated forecast volume for the volume driver identified as "Driver 21". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 21)] | float64 | ||||
Generated Forecast Volume (Driver 22) | The generated forecast volume for the volume driver identified as "Driver 22". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 22)] | float64 | ||||
Generated Forecast Volume (Driver 23) | The generated forecast volume for the volume driver identified as "Driver 23". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 23)] | float64 | ||||
Generated Forecast Volume (Driver 24) | The generated forecast volume for the volume driver identified as "Driver 24". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 24)] | float64 | ||||
Generated Forecast Volume (Driver 25) | The generated forecast volume for the volume driver identified as "Driver 25". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Volume].[Forecast Volume(Generated)].[Generated Forecast Volume (Driver 25)] | float64 | ||||
Birth Date | The employee's date of birth. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Birth Date] | date | dimPeople | Person_birthDate | ||
City | The city in the employee's address. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[City] | characterLength16 | dimPeople | Person_city | ||
Contact Details | The employee's contact details | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Contact Details] | characterLength16 | dimPeople | Person_contactData | ||
Country | The country in the employee's address. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Country] | characterLength16 | dimPeople | Person_country | ||
Custom Field 1 | Provides the employee's assigned value for Custom Field 1. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 1] | characterLength16 | dimPeople | Person_CustomText1 | ||
Custom Field 2 | Provides the employee's assigned value for Custom Field 2. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 2] | characterLength16 | dimPeople | Person_CustomText2 | ||
Custom Field 3 | Provides the employee's assigned value for Custom Field 3. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 3] | characterLength16 | dimPeople | Person_CustomText3 | ||
Custom Field 4 | Provides the employee's assigned value for Custom Field 4. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 4] | characterLength16 | dimPeople | Person_CustomText4 | ||
Custom Field 5 | Provides the employee's assigned value for Custom Field 5. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 5] | characterLength16 | dimPeople | Person_CustomText5 | ||
Custom Field 6 | Provides the employee's assigned value for Custom Field 6. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 6] | characterLength16 | dimPeople | Person_CustomText6 | ||
Custom Field 7 | Provides the employee's assigned value for Custom Field 7. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 7] | characterLength16 | dimPeople | Person_CustomText7 | ||
Custom Field 8 | Provides the employee's assigned value for Custom Field 8. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 8] | characterLength16 | dimPeople | Person_CustomText8 | ||
Custom Field 9 | Provides the employee's assigned value for Custom Field 9. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 9] | characterLength16 | dimPeople | Person_CustomText9 | ||
Custom Field 10 | Provides the employee's assigned value for Custom Field 10. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 10] | characterLength16 | dimPeople | Person_CustomText10 | ||
Custom Field 11 | Provides the employee's assigned value for Custom Field 11. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 11] | characterLength16 | dimPeople | Person_CustomText11 | ||
Custom Field 12 | Provides the employee's assigned value for Custom Field 12. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 12] | characterLength16 | dimPeople | Person_CustomText12 | ||
Custom Field 13 | Provides the employee's assigned value for Custom Field 13. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 13] | characterLength16 | dimPeople | Person_CustomText13 | ||
Custom Field 14 | Provides the employee's assigned value for Custom Field 14. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 14] | characterLength16 | dimPeople | Person_CustomText14 | ||
Custom Field 15 | Provides the employee's assigned value for Custom Field 15. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 15] | characterLength16 | dimPeople | Person_CustomText15 | ||
Custom Field 16 | Provides the employee's assigned value for Custom Field 16. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 16] | characterLength16 | dimPeople | Person_CustomText16 | ||
Custom Field 17 | Provides the employee's assigned value for Custom Field 17. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 17] | characterLength16 | dimPeople | Person_CustomText17 | ||
Custom Field 18 | Provides the employee's assigned value for Custom Field 18. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 18] | characterLength16 | dimPeople | Person_CustomText18 | ||
Custom Field 19 | Provides the employee's assigned value for Custom Field 19. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 19] | characterLength16 | dimPeople | Person_CustomText19 | ||
Custom Field 20 | Provides the employee's assigned value for Custom Field 20. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 20] | characterLength16 | dimPeople | Person_CustomText20 | ||
Custom Field 21 | Provides the employee's assigned value for Custom Field 21. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 21] | characterLength16 | dimPeople | Person_CustomText21 | ||
Custom Field 22 | Provides the employee's assigned value for Custom Field 22. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 22] | characterLength16 | dimPeople | Person_CustomText22 | ||
Custom Field 23 | Provides the employee's assigned value for Custom Field 23. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 23] | characterLength16 | dimPeople | Person_CustomText23 | ||
Custom Field 24 | Provides the employee's assigned value for Custom Field 24. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 24] | characterLength16 | dimPeople | Person_CustomText24 | ||
Custom Field 25 | Provides the employee's assigned value for Custom Field 25. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 25] | characterLength16 | dimPeople | Person_CustomText25 | ||
Custom Field 26 | Provides the employee's assigned value for Custom Field 26. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 26] | characterLength16 | dimPeople | Person_CustomText26 | ||
Custom Field 27 | Provides the employee's assigned value for Custom Field 27. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 27] | characterLength16 | dimPeople | Person_CustomText27 | ||
Custom Field 28 | Provides the employee's assigned value for Custom Field 28. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 28] | characterLength16 | dimPeople | Person_CustomText28 | ||
Custom Field 29 | Provides the employee's assigned value for Custom Field 29. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 29] | characterLength16 | dimPeople | Person_CustomText29 | ||
Custom Field 30 | Provides the employee's assigned value for Custom Field 30. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Custom Field 30] | characterLength16 | dimPeople | Person_CustomText30 | ||
Employee ID | The employee's identifier as defined in the employee's person record. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Employee ID] | characterLength16 | dimPeople | Person_PersonNumber | ||
Employee Full Name | The employee's full name provided as Last Name, First Name. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Employee Full Name] | characterLength16 | dimPeople | Person_FullName | ||
Employee Indicator | Indicates if the employee has the 'Employee' role assigned. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Employee Indicator] | characterLength16 | cast(Database Layer.dimPeople.Person_IsEmployeeSwt as varchar(5)) | |||
Employment Status | The employee's current Employment Status (Active, Inactive, Terminated). | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Employment Status] | characterLength16 | dimPeople | Person_employmentStatus | ||
Employment Terms | The name of the Employment Terms assigned to the employee. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Employment Terms] | characterLength16 | dimPeople | Person_EmploymentTerm | ||
Expected Daily Hours | The employee's expected daily hours | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Expected Daily Hours] | float64 | dimPeople | Person_ExpectedDailyHours | ||
Full Time Equivalency Percentage | The percent of hours used for accruals calculations. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Full Time Equivalency Percentage] | float64 | dimPeople | Person_FullTimeEquivalencyPercent | ||
Full Time Hours | The number of hours that define "Full Time" for accruals calculations. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Full Time Hours] | float64 | dimPeople | Person_fullTimeStandardHoursQuantity | ||
Hire Date | The employee's hire date. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Hire Date] | date | dimPeople | Person_HireDate | ||
Hourly Wage Rate | Provides the employee's hourly wage rate | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Hourly Wage Rate] | float64 | dimPeople | Person_HourlyRate | ||
Manager Indicator | Indicates if the employee has the 'Manager' role assigned. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Manager Indicator] | characterLength16 | cast(Database Layer.dimPeople.Person_IsManagerSwt, varchar(5)) | |||
Person System ID | The employee's unique identifier as generated by the application. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Person System ID] | int64 | dimPeople | Person_personId | ||
Primary Labor Category (Full Path) | The employee's assigned primary labor category with all assigned entries. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Primary Labor Category (Full Path)] | characterLength16 | dimPeople | Person_PrimaryLaborCategory | ||
Primary Labor Category (Level 1) | The employee's assigned labor category entry identified as "Level 1". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Primary Labor Category (Level 1)] | characterLength16 | dimPeople | Person_PrimaryLaborEntryName1 | ||
Primary Labor Category (Level 2) | The employee's assigned labor category entry identified as "Level 2". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Primary Labor Category (Level 2)] | characterLength16 | dimPeople | Person_PrimaryLaborEntryName2 | ||
Primary Labor Category (Level 3) | The employee's assigned labor category entry identified as "Level 3". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Primary Labor Category (Level 3)] | characterLength16 | dimPeople | Person_PrimaryLaborEntryName3 | ||
Primary Labor Category (Level 4) | The employee's assigned labor category entry identified as "Level 4". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Primary Labor Category (Level 4)] | characterLength16 | dimPeople | Person_PrimaryLaborEntryName4 | ||
Primary Labor Category (Level 5) | The employee's assigned labor category entry identified as "Level 5". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Primary Labor Category (Level 5)] | characterLength16 | dimPeople | Person_PrimaryLaborEntryName5 | ||
Primary Labor Category (Level 6) | The employee's assigned labor category entry identified as "Level 6". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Primary Labor Category (Level 6)] | characterLength16 | dimPeople | Person_PrimaryLaborEntryName6 | ||
Primary Location ID | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Primary Location ID] | int64 | dimPeople | BusPri_primaryOrgId | |||
Primary Location (Path) | The employee's assigned primary location provided as the complete hierarchical path. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Primary Location (Path)] | characterLength16 | dimPeople | Person_primaryOrgPathTxt | ||
Seniority Date | The employee's seniority date. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Seniority Date] | date | dimPeople | Person_SeniorityDate | ||
Shift Code | The employee's shift code | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Shift Code] | characterLength16 | dimPeople | Person_shiftCode | ||
State | The state in the employee's address. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[State] | characterLength16 | dimPeople | Person_state | ||
Supervisor Employee ID | The employee ID of the employee's supervisor. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Supervisor Employee ID] | characterLength16 | dimPeople | Person_SupervisorPersonNumber | ||
Supervisor Full Name | The full name of the employee's supervisor. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Supervisor Full Name] | characterLength16 | dimPeople | Person_SupervisorFullName | ||
Time Entry Method | The employee's assigned Time Entry Method (Hourly View, Project View, Time Stamp, Time Stamp & Hourly View). | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Time Entry Method] | characterLength16 | dimPeople | Person_timeEntryType | ||
Worker Type | The Worker Type value assigned to the employee (ex. Part Time, Full Time). | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Worker Type] | characterLength16 | dimPeople | Person_WorkerType | ||
Zip Code | The zip code in the employee's address. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Employee].[Zip Code] | characterLength16 | dimPeople | Person_zipCode | ||
Forecast Category Description | The description of the forecast category. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Forecast Category Description] | characterLength16 | dimBusinessStructure | Bus_orgBreak0Desc | ||
Forecast Category Name | The name of the forecast category. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Forecast Category Name] | characterLength16 | dimBusinessStructure | Bus_orgBreak0 | ||
Job Description | The description of the job as defined in the Business Structure. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Job Description] | characterLength16 | dimBusinessStructure | Bus_orgBreak1Desc | ||
Job Name | The name of the job as defined in the Business Structure. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Job Name] | characterLength16 | dimBusinessStructure | Bus_orgBreak1 | ||
Location Category | The location's category as defined by the associated location type. The possible values are "Site", "Department" or NULL. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Category] | characterLength16 | dimBusinessStructure | Bus_orgLocationCategory | ||
Location Context Name | The context name of the location as defined in the Business Structure. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Context Name] | characterLength16 | dimBusinessStructure | Bus_orgContextName | ||
Location Description | The description of the location as defined in the Business Structure. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description] | characterLength16 | dimBusinessStructure | Bus_orgDescription | ||
Location Description (Type 2) | The description of the location in the business structure hierarchy identified as "Type 2". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 2)] | characterLength16 | dimBusinessStructure | Bus_orgBreak2Desc | ||
Location Description (Type 3) | The description of the location in the business structure hierarchy identified as "Type 3". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 3)] | characterLength16 | dimBusinessStructure | Bus_orgBreak3Desc | ||
Location Description (Type 4) | The description of the location in the business structure hierarchy identified as "Type 4". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 4)] | characterLength16 | dimBusinessStructure | Bus_orgBreak4Desc | ||
Location Description (Type 5) | The description of the location in the business structure hierarchy identified as "Type 5". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 5)] | characterLength16 | dimBusinessStructure | Bus_orgBreak5Desc | ||
Location Description (Type 6) | The description of the location in the business structure hierarchy identified as "Type 6". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 6)] | characterLength16 | dimBusinessStructure | Bus_orgBreak6Desc | ||
Location Description (Type 7) | The description of the location in the business structure hierarchy identified as "Type 7". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 7)] | characterLength16 | dimBusinessStructure | Bus_orgBreak7Desc | ||
Location Description (Type 8) | The description of the location in the business structure hierarchy identified as "Type 8". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 8)] | characterLength16 | dimBusinessStructure | Bus_orgBreak8Desc | ||
Location Description (Type 9) | The description of the location in the business structure hierarchy identified as "Type 9". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 9)] | characterLength16 | dimBusinessStructure | Bus_orgBreak9Desc | ||
Location Description (Type 10) | The description of the location in the business structure hierarchy identified as "Type 10". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 10)] | characterLength16 | dimBusinessStructure | Bus_orgBreak10Desc | ||
Location Description (Type 11) | The description of the location in the business structure hierarchy identified as "Type 11". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 11)] | characterLength16 | dimBusinessStructure | Bus_orgBreak11Desc | ||
Location Description (Type 12) | The description of the location in the business structure hierarchy identified as "Type 12". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 12)] | characterLength16 | dimBusinessStructure | Bus_orgBreak12Desc | ||
Location Description (Type 13) | The description of the location in the business structure hierarchy identified as "Type 13". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 13)] | characterLength16 | dimBusinessStructure | Bus_orgBreak13Desc | ||
Location Description (Type 14) | The description of the location in the business structure hierarchy identified as "Type 14". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 14)] | characterLength16 | dimBusinessStructure | Bus_orgBreak14Desc | ||
Location Description (Type 15) | The description of the location in the business structure hierarchy identified as "Type 15". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 15)] | characterLength16 | dimBusinessStructure | Bus_orgBreak15Desc | ||
Location Description (Type 16) | The description of the location in the business structure hierarchy identified as "Type 16". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 16)] | characterLength16 | dimBusinessStructure | Bus_orgBreak16Desc | ||
Location Description (Type 17) | The description of the location in the business structure hierarchy identified as "Type 17". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 17)] | characterLength16 | dimBusinessStructure | Bus_orgBreak17Desc | ||
Location Description (Type 18) | The description of the location in the business structure hierarchy identified as "Type 18". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 18)] | characterLength16 | dimBusinessStructure | Bus_orgBreak18Desc | ||
Location Description (Type 19) | The description of the location in the business structure hierarchy identified as "Type 19". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 19)] | characterLength16 | dimBusinessStructure | Bus_orgBreak19Desc | ||
Location Description (Type 20) | The description of the location in the business structure hierarchy identified as "Type 20". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 20)] | characterLength16 | dimBusinessStructure | Bus_orgBreak20Desc | ||
Location Description (Type 21) | The description of the location in the business structure hierarchy identified as "Type 21". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 21)] | characterLength16 | dimBusinessStructure | Bus_orgBreak21Desc | ||
Location Description (Type 22) | The description of the location in the business structure hierarchy identified as "Type 22". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 22)] | characterLength16 | dimBusinessStructure | Bus_orgBreak22Desc | ||
Location Description (Type 23) | The description of the location in the business structure hierarchy identified as "Type 23". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 23)] | characterLength16 | dimBusinessStructure | Bus_orgBreak23Desc | ||
Location Description (Type 24) | The description of the location in the business structure hierarchy identified as "Type 24". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 24)] | characterLength16 | dimBusinessStructure | Bus_orgBreak24Desc | ||
Location Description (Type 25) | The description of the location in the business structure hierarchy identified as "Type 25". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Description (Type 25)] | characterLength16 | dimBusinessStructure | Bus_orgBreak25Desc | ||
Location Effective Date | The effective date of the location as defined in the Business Structure. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Effective Date] | date | dimBusinessStructure | Bus_orgEffectiveDate | ||
Location Expiration Date | The expiration date of the location as defined in the Business Structure. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Expiration Date] | date | dimBusinessStructure | Bus_orgExpirationDate | ||
Location Full Name | The full name of the location as defined in the Business Structure. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Full Name] | characterLength16 | dimBusinessStructure | Bus_orgFullName | ||
Location Full Path | The full organizational path of the location in the Business Structure. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Full Path] | characterLength16 | dimBusinessStructure | Bus_orgPathTxt | ||
Location ID | The unique identifier associated with a location in the Business Structure. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location ID] | int64 | dimBusinessStructure | Bus_orgId | ||
Location Name | The name of the location as defined in the Business Structure. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name] | characterLength16 | dimBusinessStructure | Bus_orgName | ||
Location Name (Type 2) | The name of the location in the business structure hierarchy identified as "Type 2". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 2)] | characterLength16 | dimBusinessStructure | Bus_orgBreak2 | ||
Location Name (Type 3) | The name of the location in the business structure hierarchy identified as "Type 3". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 3)] | characterLength16 | dimBusinessStructure | Bus_orgBreak3 | ||
Location Name (Type 4) | The name of the location in the business structure hierarchy identified as "Type 4". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 4)] | characterLength16 | dimBusinessStructure | Bus_orgBreak4 | ||
Location Name (Type 5) | The name of the location in the business structure hierarchy identified as "Type 5". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 5)] | characterLength16 | dimBusinessStructure | Bus_orgBreak5 | ||
Location Name (Type 6) | The name of the location in the business structure hierarchy identified as "Type 6". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 6)] | characterLength16 | dimBusinessStructure | Bus_orgBreak6 | ||
Location Name (Type 7) | The name of the location in the business structure hierarchy identified as "Type 7". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 7)] | characterLength16 | dimBusinessStructure | Bus_orgBreak7 | ||
Location Name (Type 8) | The name of the location in the business structure hierarchy identified as "Type 8". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 8)] | characterLength16 | dimBusinessStructure | Bus_orgBreak8 | ||
Location Name (Type 9) | The name of the location in the business structure hierarchy identified as "Type 9". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 9)] | characterLength16 | dimBusinessStructure | Bus_orgBreak9 | ||
Location Name (Type 10) | The name of the location in the business structure hierarchy identified as "Type 10". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 10)] | characterLength16 | dimBusinessStructure | Bus_orgBreak10 | ||
Location Name (Type 11) | The name of the location in the business structure hierarchy identified as "Type 11". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 11)] | characterLength16 | dimBusinessStructure | Bus_orgBreak11 | ||
Location Name (Type 12) | The name of the location in the business structure hierarchy identified as "Type 12". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 12)] | characterLength16 | dimBusinessStructure | Bus_orgBreak12 | ||
Location Name (Type 13) | The name of the location in the business structure hierarchy identified as "Type 13". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 13)] | characterLength16 | dimBusinessStructure | Bus_orgBreak13 | ||
Location Name (Type 14) | The name of the location in the business structure hierarchy identified as "Type 14". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 14)] | characterLength16 | dimBusinessStructure | Bus_orgBreak14 | ||
Location Name (Type 15) | The name of the location in the business structure hierarchy identified as "Type 15". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 15)] | characterLength16 | dimBusinessStructure | Bus_orgBreak15 | ||
Location Name (Type 16) | The name of the location in the business structure hierarchy identified as "Type 16". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 16)] | characterLength16 | dimBusinessStructure | Bus_orgBreak16 | ||
Location Name (Type 17) | The name of the location in the business structure hierarchy identified as "Type 17". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 17)] | characterLength16 | dimBusinessStructure | Bus_orgBreak17 | ||
Location Name (Type 18) | The name of the location in the business structure hierarchy identified as "Type 18". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 18)] | characterLength16 | dimBusinessStructure | Bus_orgBreak18 | ||
Location Name (Type 19) | The name of the location in the business structure hierarchy identified as "Type 19". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 19)] | characterLength16 | dimBusinessStructure | Bus_orgBreak19 | ||
Location Name (Type 20) | The name of the location in the business structure hierarchy identified as "Type 20". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 20)] | characterLength16 | dimBusinessStructure | Bus_orgBreak20 | ||
Location Name (Type 21) | The name of the location in the business structure hierarchy identified as "Type 21". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 21)] | characterLength16 | dimBusinessStructure | Bus_orgBreak21 | ||
Location Name (Type 22) | The name of the location in the business structure hierarchy identified as "Type 22". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 22)] | characterLength16 | dimBusinessStructure | Bus_orgBreak22 | ||
Location Name (Type 23) | The name of the location in the business structure hierarchy identified as "Type 23". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 23)] | characterLength16 | dimBusinessStructure | Bus_orgBreak23 | ||
Location Name (Type 24) | The name of the location in the business structure hierarchy identified as "Type 24". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 24)] | characterLength16 | dimBusinessStructure | Bus_orgBreak24 | ||
Location Name (Type 25) | The name of the location in the business structure hierarchy identified as "Type 25". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Name (Type 25)] | characterLength16 | dimBusinessStructure | Bus_orgBreak25 | ||
Location Type ID | The unique identifier of the location's associated location type. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Type ID] | int64 | dimBusinessStructure | Bus_orgTypeId | ||
Location Type | The name of the location's associated location type. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Worked/Scheduled)].[Location Type] | characterLength16 | dimBusinessStructure | Bus_orgTypeName | ||
Primary Location Description | The description of the employee's assigned primary location. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Description] | characterLength16 | dimPeople | BusPri_primaryOrgDescription | ||
Primary Location Full Name | The full name of the employee's assigned primary location. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Full Name] | characterLength16 | dimPeople | BusPri_primaryOrgFullName | ||
Primary Location Name | The name of the employee's assigned primary location. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name] | characterLength16 | dimPeople | BusPri_PrimaryOrgName | ||
Primary Location Name (Type 0) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 0". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 0)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak0 | ||
Primary Location Name (Type 1) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 1". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 1)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak1 | ||
Primary Location Name (Type 2) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 2". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 2)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak2 | ||
Primary Location Name (Type 3) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 3". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 3)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak3 | ||
Primary Location Name (Type 4) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 4". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 4)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak4 | ||
Primary Location Name (Type 5) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 5". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 5)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak5 | ||
Primary Location Name (Type 6) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 6". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 6)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak6 | ||
Primary Location Name (Type 7) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 7". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 7)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak7 | ||
Primary Location Name (Type 8) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 8". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 8)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak8 | ||
Primary Location Name (Type 9) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 9". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 9)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak9 | ||
Primary Location Name (Type 10) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 10". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 10)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak10 | ||
Primary Location Name (Type 11) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 11". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 11)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak11 | ||
Primary Location Name (Type 12) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 12". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 12)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak12 | ||
Primary Location Name (Type 13) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 13". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 13)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak13 | ||
Primary Location Name (Type 14) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 14". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 14)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak14 | ||
Primary Location Name (Type 15) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 15". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 15)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak15 | ||
Primary Location Name (Type 16) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 16". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 16)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak16 | ||
Primary Location Name (Type 17) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 17". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 17)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak17 | ||
Primary Location Name (Type 18) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 18". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 18)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak18 | ||
Primary Location Name (Type 19) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 19". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 19)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak19 | ||
Primary Location Name (Type 20) | The name of the employee's assigned primary location in the business structure hierarchy identified as "Type 20". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Business Structure (Primary)].[Primary Location Name (Type 20)] | characterLength16 | dimPeople | BusPri_primaryOrgBreak20 | ||
Labor Category (Level 1) | The labor category entry identified as "Level 1" associated with a transaction. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category (Level 1)] | characterLength16 | ||||
Labor Category (Level 2) | The labor category entry identified as "Level 2" associated with a transaction. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category (Level 2)] | characterLength16 | ||||
Labor Category (Level 3) | The labor category entry identified as "Level 3" associated with a transaction. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category (Level 3)] | characterLength16 | ||||
Labor Category (Level 4) | The labor category entry identified as "Level 4" associated with a transaction. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category (Level 4)] | characterLength16 | ||||
Labor Category (Level 5) | The labor category entry identified as "Level 5" associated with a transaction. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category (Level 5)] | characterLength16 | ||||
Labor Category (Level 6) | The labor category entry identified as "Level 6" associated with a transaction. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category (Level 6)] | characterLength16 | ||||
Labor Category Desc (Level 1) | Labor Category 1 entry description associated with transaction | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category Desc (Level 1)] | characterLength16 | ||||
Labor Category Desc (Level 2) | Labor Category 2 entry description associated with transaction | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category Desc (Level 2)] | characterLength16 | ||||
Labor Category Desc (Level 3) | Labor Category 3 entry description associated with transaction | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category Desc (Level 3)] | characterLength16 | ||||
Labor Category Desc (Level 4) | Labor Category 4 entry description associated with transaction | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category Desc (Level 4)] | characterLength16 | ||||
Labor Category Desc (Level 5) | Labor Category 5 entry description associated with transaction | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category Desc (Level 5)] | characterLength16 | ||||
Labor Category Desc (Level 6) | Labor Category 6 entry description associated with transaction | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category].[Labor Category Desc (Level 6)] | characterLength16 | ||||
Cost Center | Contains the Cost Center description associated with a transaction | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Labor Category Cost Center].[Cost Center] | characterLength16 | ||||
Core Indicator | Indicates if the paycode is classified as "Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Paycode].[Core Indicator] | characterLength16 | cast(Database Layer.dimPayCode.PC_isCoreSwt as varchar(5)) | |||
OT Net Down Indicator | Indicates if the paycode is classified as "OT Net Down". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Paycode].[OT Net Down Indicator] | characterLength16 | cast(Database Layer.dimPayCode.PC_isOTNetDownSwt as varchar(5)) | |||
Paid Indicator | Indicates if the paycode is classified as "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Paycode].[Paid Indicator] | characterLength16 | cast(Database Layer.dimPayCode.PC_isPaidSwt as varchar(5)) | |||
Paycode Category | The category of the paycode. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Paycode].[Paycode Category] | characterLength16 | dimPayCode | PC_payCategory | ||
Paycode ID | The unique identifier of the paycode. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Paycode].[Paycode ID] | int64 | dimPayCode | PC_payCodeId | ||
Paycode Name | The name of the paycode. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Paycode].[Paycode Name] | characterLength16 | dimPayCode | PC_payCodeName | ||
Paycode Short Name | The short name of the paycode. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Paycode].[Paycode Short Name] | characterLength16 | dimPayCode | PC_payCodeShortName | ||
Paycode Type | The type of the paycode. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Paycode].[Paycode Type] | characterLength16 | dimPayCode | PC_payCodeType | ||
Productive Indicator | Indicates if the paycode is classified as "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Paycode].[Productive Indicator] | characterLength16 | cast(Database Layer.dimPayCode.PC_isProductiveSwt as varchar(5)) | |||
Training Indicator | Indicates if the paycode is classified as "Training". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Paycode].[Training Indicator] | characterLength16 | cast(Database Layer.dimPayCode.PC_isTrainingSwt as varchar(5)) | |||
Date | The date of a transaction. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Date] | date | dimDate | Date_partitionDate | ||
Day of Month Number | The numeric value of the day of the month. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Day of Month Number] | int64 | dimDate | Date_dayOfMoNbr | ||
Day of Quarter Number | The numeric value of the day of the quarter. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Day of Quarter Number] | int64 | dimDate | Date_dayOfQtrNbr | ||
Day of Week Name | The name of the day of the week (Monday, Tuesday, etc.) | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Day of Week Name] | characterLength16 | dimDate | Date_dayNam | ||
Day of Week Number | The numeric value of the day of week (1-7). | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Day of Week Number] | int64 | dimDate | Date_dayOfWkNbr | ||
Day of Year Number | The numeric value of the day of the year. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Day of Year Number] | int64 | dimDate | Date_dayOfYrNbr | ||
Fiscal Day of Month Number | The numeric value of the day of the month based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Day of Month Number] | int64 | dimDate | Date_FsclDayOfMoNbr | ||
Fiscal Day of Quarter Number | The numeric value of the day of the quarter based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Day of Quarter Number] | int64 | dimDate | Date_FsclDayOfQtrNbr | ||
Fiscal Day of Week Number | The numeric value of the day of week based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Day of Week Number] | int64 | dimDate | Date_FsclDayOfWkNbr | ||
Fiscal Day of Year Number | The numeric value of the day of the year based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Day of Year Number] | int64 | dimDate | Date_FsclDayOfYrNbr | ||
Fiscal Last Day of Month Indicator | Indicates if the date of the transaction is the last day of the month based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Last Day of Month Indicator] | characterLength16 | cast(Database Layer.dimDate.Date_FsclLastDayOfMoSwt as varchar(5)) | |||
Fiscal Last Day of Quarter Indicator | Indicates if the date of the transaction is the last day of the quarter based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Last Day of Quarter Indicator] | characterLength16 | cast(Database Layer.dimDate.Date_FsclLastDayOfQtrSwt as varchar(5)) | |||
Fiscal Last Day of Week Indicator | Indicates if the date of the transaction is the last day of the week based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Last Day of Week Indicator] | characterLength16 | cast(Database Layer.dimDate.Date_FsclLastDayOfWkSwt as varchar(5)) | |||
Fiscal Last Day of Year Indicator | Indicates if the date of the transaction is the last day of the year based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Last Day of Year Indicator] | characterLength16 | cast(Database Layer.dimDate.Date_FsclLastDayOfYrSwt as varchar(5)) | |||
Fiscal Month Name | The name of the month based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Month Name] | characterLength16 | dimDate | Date_FsclMoNam | ||
Fiscal Month of Year Number | The numeric value of the month of the year based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Month of Year Number] | int64 | dimDate | Date_FsclMoOfYrNbr | ||
Fiscal Quarter Name | The name of the quarter based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Quarter Name] | characterLength16 | dimDate | Date_FsclQtrNam | ||
Fiscal Quarter of year Number | The numeric value of the quarter of the year based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Quarter of year Number] | int64 | dimDate | Date_FsclQtrOfYrNbr | ||
Fiscal Week of Year Number | The numeric value of the week of the year based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Week of Year Number] | int64 | dimDate | Date_FsclWkOfYrNbr | ||
Fiscal Year Month Number | The numeric value of the year and month based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Year Month Number] | characterLength16 | dimDate | Date_FsclYrMoNbr | ||
Fiscal Year Number | The year number based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Fiscal Year Number] | int64 | dimDate | Date_FsclYrNbr | ||
Last Day of Month Indicator | Indicates if the date of the transaction is the last day of the month. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Last Day of Month Indicator] | characterLength16 | cast(Database Layer.dimDate.Date_lastDayOfMoSwt as varchar(5)) | |||
Last Day of Quarter Indicator | Indicates if the date of the transaction is the last day of the quarter. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Last Day of Quarter Indicator] | characterLength16 | cast(Database Layer.dimDate.Date_lastDayOfQtrSwt as varchar(5)) | |||
Last Day of Week Indicator | Indicates if the date of the transaction is the last day of the week. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Last Day of Week Indicator] | characterLength16 | cast(Database Layer.dimDate.Date_lastDayOfWkSwt as varchar(5)) | |||
Last Day of Year Indicator | Indicates if the date of the transaction is the last day of the year. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Last Day of Year Indicator] | characterLength16 | cast(Database Layer.dimDate.Date_lastDayOFYrSwt as varchar(5)) | |||
Month Name | The name of the month. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Month Name] | characterLength16 | dimDate | Date_moNam | ||
Month of Year Number | The numeric value of the month of the year. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Month of Year Number] | int64 | dimDate | Date_moOfYrNbr | ||
Quarter Name | The name of the quarter. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Quarter Name] | characterLength16 | dimDate | Date_qtrNam | ||
Quarter of Year Number | The numeric value of the quarter of the year. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Quarter of Year Number] | int64 | dimDate | Date_qtrOfYrNbr | ||
Week of Year Number | The numeric value of the week of the year. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Week of Year Number] | int64 | dimDate | Date_wkOfYrNbr | ||
Weekend Indicator | Indicates if the date of the transaction is a weekend day. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Weekend Indicator] | characterLength16 | cast(Database Layer.dimDate.Date_wkEndSwt as varchar(5)) | |||
Year Month Number | The numeric value of the year and month. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Year Month Number] | int64 | dimDate | Date_yrMoNbr | ||
Year Number | The year number. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Date].[Year Number] | int64 | dimDate | Date_yrNbr | ||
Date | The date of a transaction - available for the last 15 Pay Periods only. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Pay Period].[Date] | date | dimPayPeriod | partitionDate | ||
Pay Period Start Date | The start date of the associated pay period - available for the last 15 Pay Periods only. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Pay Period].[Pay Period Start Date] | date | dimPayPeriod | PP_startDate | ||
Pay Period End Date | The end date of the associated pay period - available for the last 15 Pay Periods only. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Pay Period].[Pay Period End Date] | date | dimPayPeriod | PP_endDate | ||
Pay Period Name | The name of the associated pay period - available for the last 15 Pay Periods only. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Pay Period].[Pay Period Name] | characterLength16 | dimPayPeriod | PP_payPeriod | ||
Pay Period Offset | A numeric value indicating the sequential order of pay periods in relation to the current pay period - available for the last 15 Pay Periods only. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Pay Period].[Pay Period Offset] | int64 | dimPayPeriod | PP_payPeriodOffset | ||
Person System ID | The employee's unique identifier as generated by the application - available for the last 15 Pay Periods only. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Pay Period].[Person System ID] | int64 | dimPayPeriod | personId | ||
Current Month | A symbolic time period that represents the current month. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Current Month] | characterLength16 | cast( Database Layer.dimDate.stp_CurrentMonth as varchar(5)) | |||
Current Quarter | A symbolic time period that represents the current quarter. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Current Quarter] | characterLength16 | cast(Database Layer.dimDate.stp_CurrentQuarter as varchar(5)) | |||
Current Week | A symbolic time period that represents the current week. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Current Week] | characterLength16 | cast(Database Layer.dimDate.stp_CurrentWeek as varchar(5)) | |||
Current Year | A symbolic time period that represents the current year. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Current Year] | characterLength16 | cast(Database Layer.dimDate.stp_CurrentYear as varchar(5)) | |||
Fiscal Current Month | A symbolic time period that represents the current month based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Current Month] | characterLength16 | cast(Database Layer.dimDate.stp_FsclCurrentMonth as varchar(5)) | |||
Fiscal Current Quarter | A symbolic time period that represents the current quarter based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Current Quarter] | characterLength16 | cast(Database Layer.dimDate.stp_FsclCurrentQuarter as varchar(5)) | |||
Fiscal Current Week | A symbolic time period that represents the current week based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Current Week] | characterLength16 | cast(Database Layer.dimDate.stp_FsclCurrentWeek as varchar(5)) | |||
Fiscal Current Year | A symbolic time period that represents the current year based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Current Year] | characterLength16 | cast(Database Layer.dimDate.stp_FsclCurrentYear as varchar(5)) | |||
Fiscal Last 13 Weeks | A symbolic time period that represents the previous 13 weeks based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Last 13 Weeks] | characterLength16 | cast(Database Layer.dimDate.stp_FsclLast13Weeks as varchar(5)) | |||
Fiscal Last 6 Months to Date | A symbolic time period that represents the last 6 months to date based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Last 6 Months to Date] | characterLength16 | cast(Database Layer.dimDate.stp_FsclLast6MTD as varchar(5)) | |||
Fiscal Last 8 Weeks | A symbolic time period that represents the last 8 weeks based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Last 8 Weeks] | characterLength16 | cast(Database Layer.dimDate.stp_FsclLast8Weeks as varchar(5)) | |||
Fiscal Last Month | A symbolic time period that represents the previous month based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Last Month] | characterLength16 | cast(Database Layer.dimDate.stp_FsclLastMonth as varchar(5)) | |||
Fiscal Last Quarter | A symbolic time period that represents the previous quarter based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Last Quarter] | characterLength16 | cast(Database Layer.dimDate.stp_FsclLastQuarter as varchar(5)) | |||
Fiscal Last Week | A symbolic time period that represents the last week based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Last Week] | characterLength16 | cast(Database Layer.dimDate.stp_FsclLastWeek as varchar(5)) | |||
Fiscal Last Year | A symbolic time period that represents the previous year based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Last Year] | characterLength16 | cast(Database Layer.dimDate.stp_FsclLastYear as varchar(5)) | |||
Fiscal Month before Last | A symbolic time period that represents the month before the previous month based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Month before Last] | characterLength16 | cast(Database Layer.dimDate.stp_FsclMonthBeforeLast as varchar(5)) | |||
Fiscal Month to Date | A symbolic time period that represents the current year to date based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Month to Date] | characterLength16 | cast(Database Layer.dimDate.stp_FsclMTD as varchar(5)) | |||
Fiscal Next Month | A symbolic time period that represents the next month based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Next Month] | characterLength16 | cast(Database Layer.dimDate.stp_FsclNextMonth as varchar(5)) | |||
Fiscal Next Quarter | A symbolic time period that represents the next quarter based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Next Quarter] | characterLength16 | cast(Database Layer.dimDate.stp_FsclNextQuarter as varchar(5)) | |||
Fiscal Next Week | A symbolic time period that represents the next week based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Next Week] | characterLength16 | cast(Database Layer.dimDate.stp_FsclNextWeek as varchar(5)) | |||
Fiscal Quarter to Date | A symbolic time period that represents the current year to date based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Quarter to Date] | characterLength16 | cast(Database Layer.dimDate.stp_FsclQTD as varchar(5)) | |||
Fiscal Three Weeks Out | A symbolic time period that represents three weeks from from the current date based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Three Weeks Out] | characterLength16 | cast(Database Layer.dimDate.stp_FsclThreeWeeksOut as varchar(5)) | |||
Fiscal Two Weeks Out | A symbolic time period that represents two weeks from from the current date based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Two Weeks Out] | characterLength16 | cast(Database Layer.dimDate.stp_FsclTwoWeeksOut as varchar(5)) | |||
Fiscal Week to Date | A symbolic time period that represents the current week to date based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Week to Date] | characterLength16 | cast(Database Layer.dimDate.stp_FsclWTD as varchar(5)) | |||
Fiscal Year to Date | A symbolic time period that represents the current year to date based on your fiscal calendar. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Fiscal Year to Date] | characterLength16 | cast(Database Layer.dimDate.stp_FsclYTD as varchar(5)) | |||
Last 13 Weeks | A symbolic time period that represents the previous 13 weeks. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Last 13 Weeks] | characterLength16 | cast(Database Layer.dimDate.stp_Last13Weeks as varchar(5)) | |||
Last 30 Days | A symbolic time period that represents the previous 30 days. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Last 30 Days] | characterLength16 | cast(Database Layer.dimDate.stp_Last30Days as varchar(5)) | |||
Last 6 Months to Date | A symbolic time period that represents the last 6 months to date. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Last 6 Months to Date] | characterLength16 | cast(Database Layer.dimDate.stp_Last6MTD as varchar(5)) | |||
Last 8 Weeks | A symbolic time period that represents the last 8 weeks. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Last 8 Weeks] | characterLength16 | cast(Database Layer.dimDate.stp_Last8Weeks as varchar(5)) | |||
Last Month | A symbolic time period that represents the previous month. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Last Month] | characterLength16 | cast(Database Layer.dimDate.stp_LastMonth as varchar(5)) | |||
Last Quarter | A symbolic time period that represents the previous quarter. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Last Quarter] | characterLength16 | cast(Database Layer.dimDate.stp_LastQuarter as varchar(5)) | |||
Last Week | A symbolic time period that represents the last week. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Last Week] | characterLength16 | cast(Database Layer.dimDate.stp_LastWeek as varchar(5)) | |||
Last Year | A symbolic time period that represents the previous year. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Last Year] | characterLength16 | cast(Database Layer.dimDate.stp_LastYear as varchar(5)) | |||
Month before Last | A symbolic time period that represents the month before the previous month. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Month before Last] | characterLength16 | cast(Database Layer.dimDate.stp_MonthBeforeLast as varchar(5)) | |||
Month to Date | A symbolic time period that represents the current year to date. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Month to Date] | characterLength16 | cast(Database Layer.dimDate.stp_MTD as varchar(5)) | |||
Next Month | A symbolic time period that represents the next month. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Next Month] | characterLength16 | cast(Database Layer.dimDate.stp_NextMonth as varchar(5)) | |||
Next Quarter | A symbolic time period that represents the next quarter. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Next Quarter] | characterLength16 | cast(Database Layer.dimDate.stp_NextQuarter as varchar(5)) | |||
Next Week | A symbolic time period that represents the next week. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Next Week] | characterLength16 | cast(Database Layer.dimDate.stp_NextWeek as varchar(5)) | |||
Quarter to Date | A symbolic time period that represents the current year to date. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Quarter to Date] | characterLength16 | cast(Database Layer.dimDate.stp_QTD as varchar(5)) | |||
Reference Date | The date for which the symbolic time period data is populated. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Reference Date] | date | dimCalendarStps | refDate | ||
Symbolic Time Period Dates | The date which falls in each symbolic time period for every reference date | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Symbolic Time Period Dates] | date | dimCalendarStps | stpDates | ||
Symbolic Time Period Name | The name of the symbolic time period. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Symbolic Time Period Name] | characterLength16 | dimCalendarStps | STPName | ||
Symbolic Time Period System Name | The database name of the symbolic time period. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Symbolic Time Period System Name] | characterLength16 | dimCalendarStps | STP | ||
Three Weeks Out | A symbolic time period that represents three weeks from from the current date. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Three Weeks Out] | characterLength16 | cast(Database Layer.dimDate.stp_ThreeWeeksOut as varchar(5)) | |||
Today | A symbolic time period that represents the current day. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Today] | characterLength16 | cast(Database Layer.dimDate.stp_Today as varchar(5)) | |||
Two Weeks Out | A symbolic time period that represents two weeks from from the current date. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Two Weeks Out] | characterLength16 | cast(Database Layer.dimDate.stp_TwoWeeksOut as varchar(5)) | |||
Week to Date | A symbolic time period that represents the current week to date. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Week to Date] | characterLength16 | cast(Database Layer.dimDate.stp_WTD as varchar(5)) | |||
Year to Date | A symbolic time period that represents the current year to date. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Year to Date] | characterLength16 | cast(Database Layer.dimDate.stp_YTD as varchar(5)) | |||
Yesterday | A symbolic time period that represents the previous day. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Day Summary Dimensions].[Symbolic Time Periods].[Yesterday] | characterLength16 | cast(Database Layer.dimDate.stp_Yesterday as varchar(5)) | |||
Actual Absence Hours (Paid) | All actual hours classified as "Absence" and "Paid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Absence Hours (Paid)] | float64 | ||||
Actual Absence Hours (Unpaid) | All actual hours classified as "Absence" and "Unpaid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Absence Hours (Unpaid)] | float64 | ||||
Actual Call Back Hours | All actual hours classified as "Call Back". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Call Back Hours] | float64 | ||||
Actual Core Hours | All actual hours classified as "Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Core Hours] | float64 | ||||
Actual Extended Absence Hours (Paid) | All actual hours classified as "Extended Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Extended Absence Hours (Paid)] | float64 | ||||
Actual Hours | All actual hours, including both paid hours and unpaid hours. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Hours] | float64 | ||||
Actual Extended Absence Hours (Unpaid) | All actual hours classified as "Unplanned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Extended Absence Hours (Unpaid)] | float64 | ||||
Actual Hours (Paid) | All actual hours classified as "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Hours (Paid)] | float64 | ||||
Actual Meal Penalty Hours | All actual hours related to meal penalties. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Meal Penalty Hours] | float64 | ||||
Actual Non Core Hours | All actual hours classified as "Non-Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Non Core Hours] | float64 | ||||
Actual On-Call Hours | All actual hours classified as "On-Call". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual On-Call Hours] | float64 | ||||
Actual Other Hours | All actual hours classified as "Other". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Other Hours] | float64 | ||||
Actual Overtime Hours | All actual hours classified as "Overtime". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Overtime Hours] | float64 | ||||
Actual Paid Holiday Hours | All actual hours related to paid holidays. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Paid Holiday Hours] | float64 | ||||
Actual Planned Absence Hours (Paid) | All actual hours classified as "Planned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Planned Absence Hours (Paid)] | float64 | ||||
Actual Planned Absence Hours (Unpaid) | All actual hours classified as "Planned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Planned Absence Hours (Unpaid)] | float64 | ||||
Actual Productive Hours | All actual hours classified as "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Productive Hours] | float64 | ||||
Actual Regular Hours | All actual hours classified as "Regular". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Regular Hours] | float64 | ||||
Actual Training Non-Productive Hours | All actual hours classified as "Training" and "Non-Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Training Non-Productive Hours] | float64 | ||||
Actual Training Productive Hours | All actual hours classified as "Training" and "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Training Productive Hours] | float64 | ||||
Actual Unplanned Absence Hours (Paid) | All actual hours classified as "Unplanned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Unplanned Absence Hours (Paid)] | float64 | ||||
Actual Unplanned Absence Hours (Unpaid) | All actual hours classified as "Unplanned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Hours].[Actual Unplanned Absence Hours (Unpaid)] | float64 | ||||
Projected Absence Hours (Paid) | All projected hours classified as "Absence" and "Paid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Absence Hours (Paid)] | float64 | ||||
Projected Absence Hours (Unpaid) | All projected hours classified as "Absence" and "Unpaid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Absence Hours (Unpaid)] | float64 | ||||
Projected Call Back Hours | All projected hours classified as "Call Back". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Call Back Hours] | float64 | ||||
Projected Core Hours | All projected hours classified as "Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Core Hours] | float64 | ||||
Projected Extended Absence Hours (Paid) | All projected hours classified as "Extended Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Extended Absence Hours (Paid)] | float64 | ||||
Projected Extended Absence Hours (Unpaid) | All projected hours classified as "Unplanned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Extended Absence Hours (Unpaid)] | float64 | ||||
Projected Hours | All actual hours, including both paid hours and unpaid hours. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Hours] | float64 | ||||
Projected Hours (Paid) | All projected hours classified as "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Hours (Paid)] | float64 | ||||
Projected Meal Penalty Hours | All projected hours related to meal penalties. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Meal Penalty Hours] | float64 | ||||
Projected Non Core Hours | All projected hours classified as "Non-Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Non Core Hours] | float64 | ||||
Projected On-Call Hours | All projected hours classified as "On-Call". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected On-Call Hours] | float64 | ||||
Projected Other Hours | All projected hours classified as "Other". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Other Hours] | float64 | ||||
Projected Overtime Hours | All projected hours classified as "Overtime". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Overtime Hours] | float64 | ||||
Projected Paid Holiday Hours | All projected hours related to paid holidays. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Paid Holiday Hours] | float64 | ||||
Projected Planned Absence Hours (Paid) | All projected hours classified as "Planned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Planned Absence Hours (Paid)] | float64 | ||||
Projected Planned Absence Hours (Unpaid) | All projected hours classified as "Planned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Planned Absence Hours (Unpaid)] | float64 | ||||
Projected Productive Hours | All projected hours classified as "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Productive Hours] | float64 | ||||
Projected Regular Hours | All projected hours classified as "Regular". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Regular Hours] | float64 | ||||
Projected Training Non-Productive Hours | All projected hours classified as "Training" and "Non-Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Training Non-Productive Hours] | float64 | ||||
Projected Training Productive Hours | All projected hours classified as "Training" and "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Training Productive Hours] | float64 | ||||
Projected Unplanned Absence Hours (Paid) | All projected hours classified as "Unplanned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Unplanned Absence Hours (Paid)] | float64 | ||||
Projected Unplanned Absence Hours (Unpaid) | All projected hours classified as "Unplanned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Hours].[Projected Unplanned Absence Hours (Unpaid)] | float64 | ||||
Scheduled Absence Hours (Paid) | All scheduled hours classified as "Absence" and "Paid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Absence Hours (Paid)] | float64 | ||||
Scheduled Absence Hours (Unpaid) | All scheduled hours classified as "Absence" and "Unpaid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Absence Hours (Unpaid)] | float64 | ||||
Scheduled Call Back Hours | All scheduled hours classified as "Call Back". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Call Back Hours] | float64 | ||||
Scheduled Core Hours | All scheduled hours classified as "Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Core Hours] | float64 | ||||
Scheduled Extended Absence Hours (Paid) | All scheduled hours classified as "Extended Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Extended Absence Hours (Paid)] | float64 | ||||
Scheduled Extended Absence Hours (Unpaid) | All scheduled hours classified as "Unplanned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Extended Absence Hours (Unpaid)] | float64 | ||||
Scheduled Hours | All scheduled hours, including both paid hours and unpaid hours. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Hours] | float64 | ||||
Scheduled Hours (Paid) | All scheduled hours classified as "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Hours (Paid)] | float64 | ||||
Scheduled Meal Penalty Hours | All scheduled hours related to meal penalties. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Meal Penalty Hours] | float64 | ||||
Scheduled Non-Core Hours | All scheduled hours classified as "Non-Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Non-Core Hours] | float64 | ||||
Scheduled On-Call Hours | All scheduled hours classified as "On-Call". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled On-Call Hours] | float64 | ||||
Scheduled Other Hours | All scheduled hours classified as "Other". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Other Hours] | float64 | ||||
Scheduled Overtime Hours | All scheduled hours classified as "Overtime". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Overtime Hours] | float64 | ||||
Scheduled Paid Holiday Hours | All scheduled hours related to paid holidays. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Paid Holiday Hours] | float64 | ||||
Scheduled Planned Absence Hours (Paid) | All scheduled hours classified as "Planned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Planned Absence Hours (Paid)] | float64 | ||||
Scheduled Planned Absence Hours (Unpaid) | All scheduled hours classified as "Planned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Planned Absence Hours (Unpaid)] | float64 | ||||
Scheduled Productive Hours | All scheduled hours classified as "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Productive Hours] | float64 | ||||
Scheduled Regular Hours | All scheduled hours classified as "Regular". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Regular Hours] | float64 | ||||
Scheduled Training Non-Productive Hours | All scheduled hours classified as "Training" and "Non-Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Training Non-Productive Hours] | float64 | ||||
Scheduled Training Productive Hours | All scheduled hours classified as "Training" and "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Training Productive Hours] | float64 | ||||
Scheduled Unplanned Absence Hours (Paid) | All scheduled hours classified as "Unplanned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Unplanned Absence Hours (Paid)] | float64 | ||||
Scheduled Unplanned Absence Hours (Unpaid) | All scheduled hours classified as "Unplanned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Hours].[Scheduled Unplanned Absence Hours (Unpaid)] | float64 | ||||
Actual All Wages | All actual wages. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual All Wages] | float64 | ||||
Actual Call Back Wages | All actual wages classified as "Call Back". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Call Back Wages] | float64 | ||||
Actual Core Wages | All actual wages classified as "Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Core Wages] | float64 | ||||
Actual Meal Penalty Wages | All actual wages related to meal penalties. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Meal Penalty Wages] | float64 | ||||
Actual Non Core Wages | All actual wages classified as "Non-Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Non Core Wages] | float64 | ||||
Actual On-Call Wages | All actual wages classified as "On-Call". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual On-Call Wages] | float64 | ||||
Actual Other Wages | All actual wages classified as "Other". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Other Wages] | float64 | ||||
Actual Overtime Wages | All actual wages classified as "Overtime". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Overtime Wages] | float64 | ||||
Actual Paid Absence Wages | All actual wages classified as "Absence" and "Paid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Paid Absence Wages] | float64 | ||||
Actual Paid Extended Absence Wages | All actual wages classified as "Extended Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Paid Extended Absence Wages] | float64 | ||||
Actual Paid Holiday Wages | All actual wages related to paid holidays. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Paid Holiday Wages] | float64 | ||||
Actual Paid Planned Absence Wages | All actual wages classified as "Planned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Paid Planned Absence Wages] | float64 | ||||
Actual Paid Unplanned Absence Wages | All actual wages classified as "Unplanned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Paid Unplanned Absence Wages] | float64 | ||||
Actual Paid Wages | All actual wages classified as "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Paid Wages] | float64 | ||||
Actual Productive Wages | All actual wages classified as "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Productive Wages] | float64 | ||||
Actual Regular Wages | All actual wages classified as "Regular". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Regular Wages] | float64 | ||||
Actual Training Non-Productive Wages | All actual wages classified as "Training" and "Non-Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Training Non-Productive Wages] | float64 | ||||
Actual Training Productive Wages | All actual wages classified as "Training" and "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Training Productive Wages] | float64 | ||||
Actual Unpaid Absence Wages | All actual wages classified as "Absence" and "Unpaid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Unpaid Absence Wages] | float64 | ||||
Actual Unpaid Extended Absence Wages | All actual wages classified as "Extended Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Unpaid Extended Absence Wages] | float64 | ||||
Actual Unpaid Planned Absence Wages | All actual wages classified as "Planned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Unpaid Planned Absence Wages] | float64 | ||||
Actual Unpaid Unplanned Absence Wages | All actual wages classified as "Unplanned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Wages].[Actual Unpaid Unplanned Absence Wages] | float64 | ||||
Projected All Wages | All projected wages. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected All Wages] | float64 | ||||
Projected Call Back Wages | All projected wages classified as "Call Back". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Call Back Wages] | float64 | ||||
Projected Core Wages | All projected wages classified as "Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Core Wages] | float64 | ||||
Projected Meal Penalty Wages | All projected wages related to meal penalties. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Meal Penalty Wages] | float64 | ||||
Projected Non Core Wages | All projected wages classified as "Non-Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Non Core Wages] | float64 | ||||
Projected On-Call Wages | All projected wages classified as "On-Call". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected On-Call Wages] | float64 | ||||
Projected Other Wages | All projected wages classified as "Other". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Other Wages] | float64 | ||||
Projected Overtime Wages | All projected wages classified as "Overtime". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Overtime Wages] | float64 | ||||
Projected Paid Absence Wages | All projected wages classified as "Absence" and "Paid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Paid Absence Wages] | float64 | ||||
Projected Paid Extended Absence Wages | All projected wages classified as "Extended Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Paid Extended Absence Wages] | float64 | ||||
Projected Paid Holiday Wages | All projected wages related to paid holidays. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Paid Holiday Wages] | float64 | ||||
Projected Paid Planned Absence Wages | All projected wages classified as "Planned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Paid Planned Absence Wages] | float64 | ||||
Projected Paid Unplanned Absence Wages | All projected wages classified as "Unplanned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Paid Unplanned Absence Wages] | float64 | ||||
Projected Paid Wages | All projected wages classified as "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Paid Wages] | float64 | ||||
Projected Productive Wages | All projected wages classified as "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Productive Wages] | float64 | ||||
Projected Regular Wages | All projected wages classified as "Regular". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Regular Wages] | float64 | ||||
Projected Training Non-Productive Wages | All projected wages classified as "Training" and "Non-Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Training Non-Productive Wages] | float64 | ||||
Projected Training Productive Wages | All projected wages classified as "Training" and "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Training Productive Wages] | float64 | ||||
Projected Unpaid Absence Wages | All projected wages classified as "Absence" and "Unpaid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Unpaid Absence Wages] | float64 | ||||
Projected Unpaid Extended Absence Wages | All projected wages classified as "Extended Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Unpaid Extended Absence Wages] | float64 | ||||
Projected Unpaid Planned Absence Wages | All projected wages classified as "Planned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Unpaid Planned Absence Wages] | float64 | ||||
Projected Unpaid Unplanned Absence Wages | All projected wages classified as "Unplanned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Projected Wages].[Projected Unpaid Unplanned Absence Wages] | float64 | ||||
Scheduled All Wages | All scheduled wages. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled All Wages] | float64 | ||||
Scheduled Call Back Wages | All scheduled wages classified as "Call Back". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Call Back Wages] | float64 | ||||
Scheduled Core Wages | All scheduled wages classified as "Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Core Wages] | float64 | ||||
Scheduled Meal Penalty Wages | All scheduled wages related to meal penalties. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Meal Penalty Wages] | float64 | ||||
Scheduled Non Core Wages | All scheduled wages classified as "Non-Core". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Non Core Wages] | float64 | ||||
Scheduled On-Call Wages | All scheduled wages classified as "On-Call". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled On-Call Wages] | float64 | ||||
Scheduled Other Wages | All scheduled wages classified as "Other". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Other Wages] | float64 | ||||
Scheduled Overtime Wages | All scheduled wages classified as "Overtime". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Overtime Wages] | float64 | ||||
Scheduled Paid Absence Wages | All scheduled wages classified as "Absence" and "Paid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Paid Absence Wages] | float64 | ||||
Scheduled Paid Extended Absence Wages | All scheduled wages classified as "Extended Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Paid Extended Absence Wages] | float64 | ||||
Scheduled Paid Holiday Wages | All scheduled wages related to paid holidays. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Paid Holiday Wages] | float64 | ||||
Scheduled Paid Planned Absence Wages | All scheduled wages classified as "Planned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Paid Planned Absence Wages] | float64 | ||||
Scheduled Paid Unplanned Absence Wages | All scheduled wages classified as "Unplanned Absence" and "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Paid Unplanned Absence Wages] | float64 | ||||
Scheduled Paid Wages | All scheduled wages classified as "Paid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Paid Wages] | float64 | ||||
Scheduled Productive Wages | All scheduled wages classified as "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Productive Wages] | float64 | ||||
Scheduled Regular Wages | All scheduled wages classified as "Regular". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Regular Wages] | float64 | ||||
Scheduled Training Non-Productive Wages | All scheduled wages classified as "Training" and "Non-Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Training Non-Productive Wages] | float64 | ||||
Scheduled Training Productive Wages | All scheduled wages classified as "Training" and "Productive". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Training Productive Wages] | float64 | ||||
Scheduled Unpaid Absence Wages | All scheduled wages classified as "Absence" and "Unpaid", including planned, unplanned and extended absences. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Unpaid Absence Wages] | float64 | ||||
Scheduled Unpaid Extended Absence Wages | All scheduled wages classified as "Extended Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Unpaid Extended Absence Wages] | float64 | ||||
Scheduled Unpaid Planned Absence Wages | All scheduled wages classified as "Planned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Unpaid Planned Absence Wages] | float64 | ||||
Scheduled Unpaid Unplanned Absence Wages | All scheduled wages classified as "Unplanned Absence" and "Unpaid". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Wages].[Scheduled Unpaid Unplanned Absence Wages] | float64 | ||||
Total In Punch Count | The count of all in punches. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Punch Counts].[Total In Punch Count] | int64 | ||||
Total Out Punch Count | The count of all out punches. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Punch Counts].[Total Out Punch Count] | int64 | ||||
Employee Count (Active) | The total number of employees that currently have an Employment Status of 'Active'. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Employee Counts].[Employee Count (Active)] | int64 | ||||
Employee Count (Actual Paid) | The total number of employees that have actual paid hours during the selected time period. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Employee Counts].[Employee Count (Actual Paid)] | int64 | ||||
Employee Count (Actual Productive) | The total number of employees that have actual productive hours during the selected time period. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Employee Counts].[Employee Count (Actual Productive)] | int64 | ||||
Employee Count (Scheduled Productive) | The total number of employees that have scheduled productive hours during the selected time period. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Employee Counts].[Employee Count (Scheduled Productive)] | int64 | ||||
Scheduled Not Worked Hours | All hours that were scheduled but not worked by employees. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Schedule Adherence].[Scheduled Not Worked Hours] | float64 | ||||
Worked And Scheduled Hours | All hours that were scheduled and worked by employees. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Schedule Adherence].[Worked And Scheduled Hours] | float64 | ||||
Worked Not Scheduled Hours | All hours that were not scheduled but were worked by employees. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Schedule Adherence].[Worked Not Scheduled Hours] | float64 | ||||
Current Scheduled Shifts | The count of all currently scheduled shifts, including open shifts. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Scheduled Shift Counts].[Current Scheduled Shifts] | int64 | ||||
Retro Schedule Edits | The number of times a scheduled shift was modified, added or deleted after the day of the shift. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Schedule Edit Counts].[Retro Schedule Edits] | characterLength16 | ||||
Schedule Edits (After Posting) | The number of times the schedule has been changed after the scheduled was posted. Changes include modified shifts, added shifts and deleted shifts. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Schedule Edit Counts].[Schedule Edits (After Posting)] | characterLength16 | ||||
Schedule Edits (Before Posting) | The number of times the schedule has been changed before the scheduled was posted. Changes include modified shifts, added shifts and deleted shifts. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Schedule Edit Counts].[Schedule Edits (Before Posting)] | characterLength16 | ||||
Scheduled Shift Edits | The number of times the schedule has been changed. Changes include modified shifts, added shifts and deleted shifts. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Schedule Edit Counts].[Scheduled Shift Edits] | characterLength16 | ||||
Scheduled Shift Notice Period Violations | The number of schedule changes where the change violated the defined notification period. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Schedule Edit Counts].[Scheduled Shift Notice Period Violations] | characterLength16 | ||||
Scheduled Shifts Added | The number of scheduled shifts added after the schedule has been generated. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Schedule Edit Counts].[Scheduled Shifts Added] | characterLength16 | ||||
Scheduled Shifts Deleted | The number of scheduled shifts deleted after the schedule has been generated. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Schedule Edit Counts].[Scheduled Shifts Deleted] | characterLength16 | ||||
Scheduled Shifts Modified | The number of scheduled shifts modified after the schedule has been generated. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Schedule Edit Counts].[Scheduled Shifts Modified] | characterLength16 | ||||
Open Shift Count | The total number of open shifts in the schedule. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Open Shift Counts & Hours].[Open Shift Count] | int64 | ||||
Open Shift Hours | The total number of hours related to open shifts in the schedule. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Open Shift Counts & Hours].[Open Shift Hours] | float64 | ||||
Forecast Labor Adjusted Hours | The edited forecasted labor as expressed in hours. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Labor].[Forecast Labor Adjusted Hours] | float64 | ||||
Forecast Labor Generated Hours | The generated forecasted labor as expressed in hours. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Labor].[Forecast Labor Generated Hours] | float64 | ||||
Earned Labor Hours | The earned labor as expressed in hours. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Labor].[Earned Labor Hours] | float64 | ||||
Forecast Labor Raw Hours | The raw forecasted labor as expressed in hours. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Labor].[Forecast Labor Raw Hours] | float64 | ||||
Forecast Labor Unallocated Hours | The unallocated forecasted labor as expressed in hours. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Forecast Labor].[Forecast Labor Unallocated Hours] | float64 | ||||
Actual Volume (Driver 1) | The actual volume for the volume driver identified as "Driver 1". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 1)] | float64 | ||||
Actual Volume (Driver 2) | The actual volume for the volume driver identified as "Driver 2". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 2)] | float64 | ||||
Actual Volume (Driver 3) | The actual volume for the volume driver identified as "Driver 3". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 3)] | float64 | ||||
Actual Volume (Driver 4) | The actual volume for the volume driver identified as "Driver 4". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 4)] | float64 | ||||
Actual Volume (Driver 5) | The actual volume for the volume driver identified as "Driver 5". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 5)] | float64 | ||||
Actual Volume (Driver 6) | The actual volume for the volume driver identified as "Driver 6". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 6)] | float64 | ||||
Actual Volume (Driver 7) | The actual volume for the volume driver identified as "Driver 7". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 7)] | float64 | ||||
Actual Volume (Driver 8) | The actual volume for the volume driver identified as "Driver 8". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 8)] | float64 | ||||
Actual Volume (Driver 9) | The actual volume for the volume driver identified as "Driver 9". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 9)] | float64 | ||||
Actual Volume (Driver 10) | The actual volume for the volume driver identified as "Driver 10". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 10)] | float64 | ||||
Actual Volume (Driver 11) | The actual volume for the volume driver identified as "Driver 11". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 11)] | float64 | ||||
Actual Volume (Driver 12) | The actual volume for the volume driver identified as "Driver 12". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 12)] | float64 | ||||
Actual Volume (Driver 13) | The actual volume for the volume driver identified as "Driver 13". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 13)] | float64 | ||||
Actual Volume (Driver 14) | The actual volume for the volume driver identified as "Driver 14". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 14)] | float64 | ||||
Actual Volume (Driver 15) | The actual volume for the volume driver identified as "Driver 15". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 15)] | float64 | ||||
Actual Volume (Driver 16) | The actual volume for the volume driver identified as "Driver 16". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 16)] | float64 | ||||
Actual Volume (Driver 17) | The actual volume for the volume driver identified as "Driver 17". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 17)] | float64 | ||||
Actual Volume (Driver 18) | The actual volume for the volume driver identified as "Driver 18". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 18)] | float64 | ||||
Actual Volume (Driver 19) | The actual volume for the volume driver identified as "Driver 19". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 19)] | float64 | ||||
Actual Volume (Driver 20) | The actual volume for the volume driver identified as "Driver 20". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 20)] | float64 | ||||
Actual Volume (Driver 21) | The actual volume for the volume driver identified as "Driver 21". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 21)] | float64 | ||||
Actual Volume (Driver 22) | The actual volume for the volume driver identified as "Driver 22". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 22)] | float64 | ||||
Actual Volume (Driver 23) | The actual volume for the volume driver identified as "Driver 23". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 23)] | float64 | ||||
Actual Volume (Driver 24) | The actual volume for the volume driver identified as "Driver 24". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 24)] | float64 | ||||
Actual Volume (Driver 25) | The actual volume for the volume driver identified as "Driver 25". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Actual Volume].[Actual Volume (Driver 25)] | float64 | ||||
Budget Volume (Driver 1) | The budget volume for the volume driver identified as "Driver 1". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 1)] | float64 | ||||
Budget Volume (Driver 2) | The budget volume for the volume driver identified as "Driver 2". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 2)] | float64 | ||||
Budget Volume (Driver 3) | The budget volume for the volume driver identified as "Driver 3". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 3)] | float64 | ||||
Budget Volume (Driver 4) | The budget volume for the volume driver identified as "Driver 4". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 4)] | float64 | ||||
Budget Volume (Driver 5) | The budget volume for the volume driver identified as "Driver 5". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 5)] | float64 | ||||
Budget Volume (Driver 6) | The budget volume for the volume driver identified as "Driver 6". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 6)] | float64 | ||||
Budget Volume (Driver 7) | The budget volume for the volume driver identified as "Driver 7". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 7)] | float64 | ||||
Budget Volume (Driver 8) | The budget volume for the volume driver identified as "Driver 8". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 8)] | float64 | ||||
Budget Volume (Driver 9) | The budget volume for the volume driver identified as "Driver 9". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 9)] | float64 | ||||
Budget Volume (Driver 10) | The budget volume for the volume driver identified as "Driver 10". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 10)] | float64 | ||||
Budget Volume (Driver 11) | The budget volume for the volume driver identified as "Driver 11". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 11)] | float64 | ||||
Budget Volume (Driver 12) | The budget volume for the volume driver identified as "Driver 12". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 12)] | float64 | ||||
Budget Volume (Driver 13) | The budget volume for the volume driver identified as "Driver 13". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 13)] | float64 | ||||
Budget Volume (Driver 14) | The budget volume for the volume driver identified as "Driver 14". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 14)] | float64 | ||||
Budget Volume (Driver 15) | The budget volume for the volume driver identified as "Driver 15". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 15)] | float64 | ||||
Budget Volume (Driver 16) | The budget volume for the volume driver identified as "Driver 16". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 16)] | float64 | ||||
Budget Volume (Driver 17) | The budget volume for the volume driver identified as "Driver 17". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 17)] | float64 | ||||
Budget Volume (Driver 18) | The budget volume for the volume driver identified as "Driver 18". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 18)] | float64 | ||||
Budget Volume (Driver 19) | The budget volume for the volume driver identified as "Driver 19". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 19)] | float64 | ||||
Budget Volume (Driver 20) | The budget volume for the volume driver identified as "Driver 20". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 20)] | float64 | ||||
Budget Volume (Driver 21) | The budget volume for the volume driver identified as "Driver 21". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 21)] | float64 | ||||
Budget Volume (Driver 22) | The budget volume for the volume driver identified as "Driver 22". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 22)] | float64 | ||||
Budget Volume (Driver 23) | The budget volume for the volume driver identified as "Driver 23". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 23)] | float64 | ||||
Budget Volume (Driver 24) | The budget volume for the volume driver identified as "Driver 24". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 24)] | float64 | ||||
Budget Volume (Driver 25) | The budget volume for the volume driver identified as "Driver 25". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Volume].[Budget Volume (Driver 25)] | float64 | ||||
Budget Labor Hours | The budgeted labor hours for a specific organizational entity. | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Budget Labor].[Budget Labor Hours] | float64 | ||||
Actual Volume (Custom Driver 1) | The actual volume for the custom volume driver identified as "Custom Driver 1". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 1)] | float64 | ||||
Actual Volume (Custom Driver 2) | The actual volume for the custom volume driver identified as "Custom Driver 2". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 2)] | float64 | ||||
Actual Volume (Custom Driver 3) | The actual volume for the custom volume driver identified as "Custom Driver 3". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 3)] | float64 | ||||
Actual Volume (Custom Driver 4) | The actual volume for the custom volume driver identified as "Custom Driver 4". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 4)] | float64 | ||||
Actual Volume (Custom Driver 5) | The actual volume for the custom volume driver identified as "Custom Driver 5". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 5)] | float64 | ||||
Actual Volume (Custom Driver 6) | The actual volume for the custom volume driver identified as "Custom Driver 6". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 6)] | float64 | ||||
Actual Volume (Custom Driver 7) | The actual volume for the custom volume driver identified as "Custom Driver 7". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 7)] | float64 | ||||
Actual Volume (Custom Driver 8) | The actual volume for the custom volume driver identified as "Custom Driver 8". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 8)] | float64 | ||||
Actual Volume (Custom Driver 9) | The actual volume for the custom volume driver identified as "Custom Driver 9". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 9)] | float64 | ||||
Actual Volume (Custom Driver 10) | The actual volume for the custom volume driver identified as "Custom Driver 10". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 10)] | float64 | ||||
Actual Volume (Custom Driver 11) | The actual volume for the custom volume driver identified as "Custom Driver 11". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 11)] | float64 | ||||
Actual Volume (Custom Driver 12) | The actual volume for the custom volume driver identified as "Custom Driver 12". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 12)] | float64 | ||||
Actual Volume (Custom Driver 13) | The actual volume for the custom volume driver identified as "Custom Driver 13". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 13)] | float64 | ||||
Actual Volume (Custom Driver 14) | The actual volume for the custom volume driver identified as "Custom Driver 14". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 14)] | float64 | ||||
Actual Volume (Custom Driver 15) | The actual volume for the custom volume driver identified as "Custom Driver 15". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 15)] | float64 | ||||
Actual Volume (Custom Driver 16) | The actual volume for the custom volume driver identified as "Custom Driver 16". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 16)] | float64 | ||||
Actual Volume (Custom Driver 17) | The actual volume for the custom volume driver identified as "Custom Driver 17". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 17)] | float64 | ||||
Actual Volume (Custom Driver 18) | The actual volume for the custom volume driver identified as "Custom Driver 18". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 18)] | float64 | ||||
Actual Volume (Custom Driver 19) | The actual volume for the custom volume driver identified as "Custom Driver 19". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 19)] | float64 | ||||
Actual Volume (Custom Driver 20) | The actual volume for the custom volume driver identified as "Custom Driver 20". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 20)] | float64 | ||||
Actual Volume (Custom Driver 21) | The actual volume for the custom volume driver identified as "Custom Driver 21". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 21)] | float64 | ||||
Actual Volume (Custom Driver 22) | The actual volume for the custom volume driver identified as "Custom Driver 22". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 22)] | float64 | ||||
Actual Volume (Custom Driver 23) | The actual volume for the custom volume driver identified as "Custom Driver 23". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 23)] | float64 | ||||
Actual Volume (Custom Driver 24) | The actual volume for the custom volume driver identified as "Custom Driver 24". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 24)] | float64 | ||||
Actual Volume (Custom Driver 25) | The actual volume for the custom volume driver identified as "Custom Driver 25". | [Presentation Layer].[Time and Labor Analysis].[Day Summary].[Custom Labor Drivers].[Actual Volume (Custom Driver 25)] | float64 | ||||
personId | The employee's person ID | [Presentation Layer].[Security Data Attr].[Security Data Attributes].[personId] | int64 | secOrgMatrix | personId | ||
emailAddress | The employee's email address | [Presentation Layer].[Security Data Attr].[Security Data Attributes].[emailAddress] | characterLength16 | secOrgMatrix | emailAddress | ||
employeeGroupId | The employee group id | [Presentation Layer].[Security Data Attr].[Security Data Attributes].[employeeGroupId] | int64 | secOrgMatrix | employeeGroupId | ||
employeeGroupName | The employee group name | [Presentation Layer].[Security Data Attr].[Security Data Attributes].[employeeGroupName] | characterLength16 | secOrgMatrix | employeeGroupName | ||
locationSetName | Employee's Location set name | [Presentation Layer].[Security Data Attr].[Security Data Attributes].[locationSetName] | characterLength16 | secOrgMatrix | locationSetName | ||
orgId | Org id detail to which employee belong to. | [Presentation Layer].[Security Data Attr].[Security Data Attributes].[orgId] | int64 | secOrgMatrix | orgId | ||
proExternalId | The employee's unique identifier as generated by the application. | [Presentation Layer].[Security Data Attr].[Security Data Attributes].[proExternalId] | characterLength16 | secOrgMatrix | proExternalId | ||
updateDtm | Employee's Updated Date. | [Presentation Layer].[Security Data Attr].[Security Data Attributes].[updateDtm] | dateTime | secOrgMatrix | updateDtm | ||
Available Balance (Amt) | Balance or remaining amount as of the partition date | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Available Balance (Amt)] | float64 | ||||
Available Balance (Days) | Balance or remainig days as of the partition date. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Available Balance (Days)] | float64 | ||||
Available Balance (Hours) | Balance or remaining hours as of the partition date | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Available Balance (Hours)] | float64 | ||||
Current Probationary Balance (Amt) | Accrued balances amounts for Probation type accrual code. Balances in Amounts | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Current Probationary Balance (Amt)] | float64 | ||||
Current Probationary Balance (Days) | Accrued balances Days for Probation type accrual code. Balances in Days | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Current Probationary Balance (Days)] | float64 | ||||
Current Probationary Balance (Hours) | Accrued balances hours for Probation type accrual code. Balances in Hours | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Current Probationary Balance (Hours)] | float64 | ||||
Current Vested Balance (Amt) | Vested Balance Amount as of the partitionDate. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Current Vested Balance (Amt)] | float64 | ||||
Current Vested Balance (Days) | Vested refers to balances earned or otherwise accrued. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Current Vested Balance (Days)] | float64 | ||||
Current Vested Balance (Hours) | Vested Balance Hours as of the partitionDate. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Current Vested Balance (Hours)] | float64 | ||||
Earned to Date (Amt) | The amount earned as of the partitionDate. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Earned to Date (Amt)] | float64 | ||||
Earned to Date (Days) | The number of days earned as of the partitionDate. If using an accrual policy which involves for example accruing vacation for every day or hour worked, then earned will be the days of vacation accrued as of the partitionDate | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Earned to Date (Days)] | float64 | ||||
Earned to Date (Hours) | The number of hours earned as of the partitionDate | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Earned to Date (Hours)] | float64 | ||||
Pending Grants (Amt) | Amounts which will accrue after the partitionDate. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Pending Grants (Amt)] | float64 | ||||
Pending Grants (Days) | Days which will accrue after the partitionDate. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Pending Grants (Days)] | float64 | ||||
Pending Grants (Hours) | Hours which will accrue after the partitionDate. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Pending Grants (Hours)] | float64 | ||||
Planned Takings (Amt) | Amounts scheduled to be taken or used after the current partition date. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Planned Takings (Amt)] | float64 | ||||
Planned Takings (Days) | Days already taken or used as of the current partition date. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Planned Takings (Days)] | float64 | ||||
Planned Takings (Hours) | Hours scheduled to be taken or used after the current partition date. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Planned Takings (Hours)] | float64 | ||||
Taken to Date (Amt) | Amounts already taken or used as of the current partition date. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Taken to Date (Amt)] | float64 | ||||
Taken to Date (Days) | Days already taken or used as of the current partition date | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Taken to Date (Days)] | float64 | ||||
Taken to Date (Hours) | Hours already taken or used as of the current partition date. | [Presentation Layer].[Accrual Balances Summary].[Summary Metrics].[Taken to Date (Hours)] | float64 | ||||
Accrual Code Editview(Y/N) | A Boolean indicator of whether or not an accrual code is ediview. | [Presentation Layer].[Accrual Balances Summary].[Accrual Code Information].[Accrual Code Editview(Y/N)] | boolean | ||||
Accrual Code Id | The ID of an accrual code. | [Presentation Layer].[Accrual Balances Summary].[Accrual Code Information].[Accrual Code Id] | int64 | ||||
Accrual Code Name | The name of an accrual code. | [Presentation Layer].[Accrual Balances Summary].[Accrual Code Information].[Accrual Code Name] | characterLength16 | ||||
Accrual Code Name(Short) | The short name of an accrual code. | [Presentation Layer].[Accrual Balances Summary].[Accrual Code Information].[Accrual Code Name(Short)] | characterLength16 | ||||
Accrual Hours Perday(Seconds) | The hours per day (in seconds) associated with an accrual code. | [Presentation Layer].[Accrual Balances Summary].[Accrual Code Information].[Accrual Hours Perday(Seconds)] | int64 | ||||
Accrual Type ID | The ID of an accrual code type. | [Presentation Layer].[Accrual Balances Summary].[Accrual Code Information].[Accrual Type ID] | int64 | ||||
Accrual Type Name | The name of an accrual code type. | [Presentation Layer].[Accrual Balances Summary].[Accrual Code Information].[Accrual Type Name] | characterLength16 | ||||
Birth date | Birth date | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Birth date] | date | ||||
City | City | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[City] | characterLength16 | ||||
Cost Center Name | Cost Center Name | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Cost Center Name] | characterLength16 | ||||
Contact information | Contact information | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Contact information] | characterLength16 | ||||
Country | Country | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Country] | characterLength16 | ||||
Person_CustomText1 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText1] | characterLength16 | ||||
Person_CustomText2 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText2] | characterLength16 | ||||
Person_CustomText3 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText3] | characterLength16 | ||||
Person_CustomText4 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText4] | characterLength16 | ||||
Person_CustomText5 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText5] | characterLength16 | ||||
Person_CustomText6 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText6] | characterLength16 | ||||
Person_CustomText7 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText7] | characterLength16 | ||||
Person_CustomText8 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText8] | characterLength16 | ||||
Person_CustomText9 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText9] | characterLength16 | ||||
Person_CustomText10 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText10] | characterLength16 | ||||
Person_CustomText11 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText11] | characterLength16 | ||||
Person_CustomText12 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText12] | characterLength16 | ||||
Person_CustomText13 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText13] | characterLength16 | ||||
Person_CustomText14 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText14] | characterLength16 | ||||
Person_CustomText15 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText15] | characterLength16 | ||||
Person_CustomText16 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText16] | characterLength16 | ||||
Person_CustomText17 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText17] | characterLength16 | ||||
Person_CustomText18 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText18] | characterLength16 | ||||
Person_CustomText19 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText19] | characterLength16 | ||||
Person_CustomText20 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText20] | characterLength16 | ||||
Person_CustomText21 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText21] | characterLength16 | ||||
Person_CustomText22 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText22] | characterLength16 | ||||
Person_CustomText23 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText23] | characterLength16 | ||||
Person_CustomText24 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText24] | characterLength16 | ||||
Person_CustomText25 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText25] | characterLength16 | ||||
Person_CustomText26 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText26] | characterLength16 | ||||
Person_CustomText27 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText27] | characterLength16 | ||||
Person_CustomText28 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText28] | characterLength16 | ||||
Person_CustomText29 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText29] | characterLength16 | ||||
Person_CustomText30 | Custom Text | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person_CustomText30] | characterLength16 | ||||
Employee(Y/N) | Boolean indicator whether or not this person is a employee | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Employee(Y/N)] | boolean | ||||
Employment Term | Employment Term | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Employment Term] | characterLength16 | ||||
Employment Status | Employment Status | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Employment Status] | characterLength16 | ||||
Expected Daily Hours | Expected Daily Hours | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Expected Daily Hours] | float64 | ||||
FT Standard Hours Qty | FT Standard Hours Qty | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[FT Standard Hours Qty] | float64 | ||||
FTE Percent | FTE Percent | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[FTE Percent] | float64 | ||||
Full Name | Full Name | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Full Name] | characterLength16 | ||||
Hire Date | Hire Date | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Hire Date] | date | ||||
Hourly Rate | Hourly Rate | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Hourly Rate] | float64 | ||||
Manager(Y/N) | Boolean indicator whether or not this person is a manager | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Manager(Y/N)] | boolean | ||||
Person ID | Person ID | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person ID] | int64 | ||||
Person Number | Person Number | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Person Number] | characterLength16 | ||||
Primary Labor Category | Primary Labor Category | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Labor Category] | characterLength16 | ||||
Primary Labor Category (Level 1) | Primary Labor Entry Name 1 | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Labor Category (Level 1)] | characterLength16 | ||||
Primary Labor Category (Level 2) | Primary Labor Entry Name 2 | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Labor Category (Level 2)] | characterLength16 | ||||
Primary Labor Category (Level 3) | Primary Labor Entry Name 3 | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Labor Category (Level 3)] | characterLength16 | ||||
Primary Labor Category (Level 4) | Primary Labor Entry Name 4 | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Labor Category (Level 4)] | characterLength16 | ||||
Primary Labor Category (Level 5) | Primary Labor Entry Name 5 | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Labor Category (Level 5)] | characterLength16 | ||||
Primary Labor Category (Level 6) | Primary Labor Entry Name 6 | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Labor Category (Level 6)] | characterLength16 | ||||
Primary Location Description | Description of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Description] | characterLength16 | ||||
Primary Location Name (Type 0) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 0)] | characterLength16 | ||||
Primary Location Name (Type 1) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 1)] | characterLength16 | ||||
Primary Location Name (Type 2) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 2)] | characterLength16 | ||||
Primary Location Name (Type 3) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 3)] | characterLength16 | ||||
Primary Location Name (Type 4) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 4)] | characterLength16 | ||||
Primary Location Name (Type 5) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 5)] | characterLength16 | ||||
Primary Location Name (Type 6) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 6)] | characterLength16 | ||||
Primary Location Name (Type 7) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 7)] | characterLength16 | ||||
Primary Location Name (Type 8) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 8)] | characterLength16 | ||||
Primary Location Name (Type 9) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 9)] | characterLength16 | ||||
Primary Location Name (Type 10) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 10)] | characterLength16 | ||||
Primary Location Name (Type 11) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 11)] | characterLength16 | ||||
Primary Location Name (Type 12) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 12)] | characterLength16 | ||||
Primary Location Name (Type 13) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 13)] | characterLength16 | ||||
Primary Location Name (Type 14) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 14)] | characterLength16 | ||||
Primary Location Name (Type 15) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 15)] | characterLength16 | ||||
Primary Location Name (Type 16) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 16)] | characterLength16 | ||||
Primary Location Name (Type 17) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 17)] | characterLength16 | ||||
Primary Location Name (Type 18) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 18)] | characterLength16 | ||||
Primary Location Name (Type 19) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 19)] | characterLength16 | ||||
Primary Location Name (Type 20) | Name of Business Structure Location based on Location type mappings in Data Hub configuration. | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Location Name (Type 20)] | characterLength16 | ||||
Primary Org Id | Primary Org Id | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Org Id] | int64 | ||||
Primary Org Full Name | Primary Org Full Name | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Org Full Name] | characterLength16 | ||||
Primary Org Name | Primary Org Name | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Org Name] | characterLength16 | ||||
Primary Org Path | Primary Org Path | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Primary Org Path] | characterLength16 | ||||
Seniority Date | Seniority Date | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Seniority Date] | date | ||||
Shift Code | Shift Code | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Shift Code] | characterLength16 | ||||
State | State | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[State] | characterLength16 | ||||
Supervisor Person Number | Supervisor Person Number | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Supervisor Person Number] | characterLength16 | ||||
Supervisor Name | Supervisor Name | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Supervisor Name] | characterLength16 | ||||
Time entry type | Time entry type | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Time entry type] | characterLength16 | ||||
Worker Type | Worker Type | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Worker Type] | characterLength16 | ||||
Zip Code | Zip Code | [Presentation Layer].[Accrual Balances Summary].[Person Attributes (Person)].[Zip Code] | characterLength16 | ||||
Currency Display Preference | a string value that contains that is used in where clause which shows the results in the desired currency | [Presentation Layer].[Accrual Balances Summary].[Currency Attributes].[Currency Display Preference] | characterLength16 | ||||
Date Balance as of Date | Accrual Balance as of Date | [Presentation Layer].[Accrual Balances Summary].[Date Attributes (CalendarDate)].[Date Balance as of Date] | date | ||||
UTC date/time stamp | The UTC date/time stamp of when the row was inserted or updated in BigQuery | [Presentation Layer].[Accrual Balances Summary].[Date Attributes (CalendarDate)].[UTC date/time stamp] | dateTime |