Labor Category
The Labor Category entity provides the data columns necessary to understand the labor category entries and cost center associated with a worked or scheduled transaction for an employee. Labor Categories may be used to describe what an employee has worked on, such as a project or a contract. The provided data columns allow the user to create Dataviews that show the labor categories in which an employee worked or was scheduled to work.
Supported Dataview types
| Employee Dataview | Business Structure Dataview |
|---|---|
| X |
Data granularity
Not applicable. Labor Category is a core entity and provides only dimensional data.
Columns
| Label | Description | Key |
|---|---|---|
|
Cost Center Description |
Cost Center Description |
CORE_COSTCENTER_DESCRIPTION |
|
Cost Center Name |
Cost Center Name |
CORE_COSTCENTER |
|
Labor Category Level 1 Entry Description |
Labor Category Level 1 Entry Description |
CORE_LVL1_LABOR_CATEGORY_ENTRY_DESCRIPTION |
|
Labor Category Level 1 Entry Name |
Labor Category Level 1 Entry Name |
CORE_LVL1_LABOR_CATEGORY_ENTRY |
|
Labor Category Level 1 Name |
Labor Category Level 1 Name |
CORE_LVL1_LABOR_CATEGORY |
|
Labor Category Level 1 TeleTime IP Alias |
Retrieves and displays the numerical data from the TeleTime IP Alias field from within the Labor Category Entry |
CORE_LVL1_LABOR_CATEGORY_TELETIME_IP_ALIAS |
|
Labor Category Level 2 Entry Description |
Labor Category Level 2 Entry Description |
CORE_LVL2_LABOR_CATEGORY_ENTRY_DESCRIPTION |
|
Labor Category Level 2 Entry Name |
Labor Category Level 2 Entry Name |
CORE_LVL2_LABOR_CATEGORY_ENTRY |
|
Labor Category Level 2 Name |
Labor Category Level 2 Name |
CORE_LVL2_LABOR_CATEGORY |
|
Labor Category Level 2 TeleTime IP Alias |
Retrieves and displays the numerical data from the TeleTime IP Alias field from within the Labor Category Entry |
CORE_LVL2_LABOR_CATEGORY_TELETIME_IP_ALIAS |
|
Labor Category Level 3 Entry Description |
Retrieves and displays the numerical data from the TeleTime IP Alias field from within the Labor Category Entry |
CORE_LVL3_LABOR_CATEGORY_ENTRY_DESCRIPTION |
|
Labor Category Level 3 Entry Name |
Labor Category Level 3 Entry Name |
CORE_LVL3_LABOR_CATEGORY_ENTRY |
|
Labor Category Level 3 Name |
Labor Category Level 3 Name |
CORE_LVL3_LABOR_CATEGORY |
|
Labor Category Level 3 TeleTime IP Alias |
Retrieves and displays the numerical data from the TeleTime IP Alias field from within the Labor Category Entry |
CORE_LVL3_LABOR_CATEGORY_TELETIME_IP_ALIAS |
|
Labor Category Level 4 Entry Description |
Labor Category Level 4 Entry Description |
CORE_LVL4_LABOR_CATEGORY_ENTRY_DESCRIPTION |
|
Labor Category Level 4 Entry Name |
Labor Category Level 4 Entry Name |
CORE_LVL4_LABOR_CATEGORY_ENTRY |
|
Labor Category Level 4 Name |
Labor Category Level 4 Name |
CORE_LVL4_LABOR_CATEGORY |
|
Labor Category Level 5 Entry Description |
Labor Category Level 5 Entry Description |
CORE_LVL5_LABOR_CATEGORY_ENTRY_DESCRIPTION |
|
Labor Category Level 5 Entry Name |
Labor Category Level 5 Entry Name |
CORE_LVL5_LABOR_CATEGORY_ENTRY |
|
Labor Category Level 5 Name |
Labor Category Level 5 Name |
CORE_LVL5_LABOR_CATEGORY |
|
Labor Category Level 5 TeleTime IP Alias |
Retrieves and displays the numerical data from the TeleTime IP Alias field from within the Labor Category Entry |
CORE_LVL4_LABOR_CATEGORY_TELETIME_IP_ALIAS |
|
Labor Category Level 5 TeleTime IP Alias |
Retrieves and displays the numerical data from the TeleTime IP Alias field from within the Labor Category Entry |
CORE_LVL5_LABOR_CATEGORY_TELETIME_IP_ALIAS |
|
Labor Category Level 6 Entry Description |
Labor Category Level 6 Entry Description |
CORE_LVL6_LABOR_CATEGORY_ENTRY_DESCRIPTION |
|
Labor Category Level 6 Entry Name |
Labor Category Level 6 Entry Name |
CORE_LVL6_LABOR_CATEGORY_ENTRY |
|
Labor Category Level 6 Name |
Labor Category Level 6 Name |
CORE_LVL6_LABOR_CATEGORY |
|
Labor Category Level 6 TeleTime IP Alias |
Retrieves and displays the numerical data from the TeleTime IP Alias field from within the Labor Category Entry |
CORE_LVL6_LABOR_CATEGORY_TELETIME_IP_ALIAS |
|
Labor Category Name (Path) |
Labor Category Name (Path) |
CORE_LABOR_CATEGORY_FULLPATH |
Related entities
- Actual Totals Corrections Only
- Actual Totals Exclude Corrections
- Actual Totals Include Corrections
- Paycode Edit
- Paycode Edit Comments
- Projected Totals Corrections Only
- Projected Totals Exclude Corrections
- Projected Totals Include Corrections
- Scheduled Totals
- Timecard Transactions
- Worked Span
- Worked Span In Punch
- Worked Span Out Punch
Additional information
The Business Structure is the place that defines the hierarchy of locations where employees perform work (such as State, Department, and Job). Labor Category entries capture data that is not part of the hierarchical structure —typically what is worked on.
For example, consider the following four Labor Categories as defined to describe work that was performed or scheduled:
Labor Category 1: Crew – Team 1, Team 2, Team 3
Labor Category 2: Route – Northeast, Southwest, City Center
Labor Category 3: Shift – Days, Afternoons, Nights
Labor Category 4: Vehicle – P-203, M-111, V-125
To identify which shift a particular employee worked or was scheduled for, you would look at data related to Labor Category 3.
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
|---|---|---|---|---|---|
| X | X |
Relationship
| One-to-One | One-to-Many |
|---|---|
| X |