Assignment
Supported Dataview types
| 
                                 Employee Dataview  | 
                                 Business Structure Dataview  | 
|---|---|
| X | 
Columns
| 
                                 Label  | 
                                 Description  | 
                                 Key  | 
                                 Type  | 
|---|---|---|---|
| 
                                 Assignment custom date default  | 
                                 Assignment custom date default  | 
                                 CORE_ASSIGNMENT_CUSTOM_DATE_DEFAULT  | 
                                 Date  | 
| 
                                 Assignment custom date description  | 
                                 Assignment custom date description  | 
                                 CORE_ASSIGNMENT_CUSTOM_DATE_DESCRIPTION  | 
                                 String  | 
| 
                                 Assignment custom date name  | 
                                 Assignment custom date name  | 
                                 CORE_ASSIGNMENT_CUSTOM_DATE_NAME  | 
                                 String  | 
| 
                                 Assignment custom override date  | 
                                 Assignment custom override date  | 
                                 CORE_ASSIGNMENT_CUSTOM_OVERRIDE_DATE  | 
                                 Date  | 
| 
                                 Assignment custom text  | 
                                 Assignment custom text  | 
                                 CORE_ASSIGNMENT_CUSTOM_TEXT  | 
                                 String  | 
| 
                                 Assignment custom text  | 
                                 Assignment custom text  | 
                                 CORE_ASSIGNMENT_CUSTOM_TEXT  | 
                                 String  | 
| 
                                 Assignment employee job transfer expiration date  | 
                                 Expiration date for assignment employee job transfer set  | 
                                 CORE_ASSIGNMENT_EMPLOYEE_JOB_TRANSFER_EXPIRATION_DATE  | 
                                 Date  | 
| 
                                 Assignment employee job transfer set  | 
                                 Employee's job transfer set for assignment  | 
                                 CORE_ASSIGNMENT_EMPLOYEE_JOB_TRANSFER_SET  | 
                                 String  | 
| 
                                 Assignment employee job transfer set effective date  | 
                                 Effective date for assignment job transfer set  | 
                                 CORE_ASSIGNMENT_EMPLOYEE_JOB_TRANSFER_SET_EFFECTIVE_DATE  | 
                                 Date  | 
| 
                                 Assignment terms employment terms effective date  | 
                                 Schedule employment terms effective date for assignment  | 
                                 CORE_ASSIGNMENT_EMPLOYMENT_TERMS_EFFECTIVE_DATE  | 
                                 String  | 
| 
                                 Assignment terms employment terms expiration date  | 
                                 Schedule employment terms expiration date for assignment  | 
                                 CORE_ASSIGNMENT_EMPLOYMENT_TERMS_EXPIRATION_DATE  | 
                                 Date  | 
| 
                                 Assignment terms employment terms name  | 
                                 Schedule group assignment terms name for assignment  | 
                                 CORE_ASSIGNMENT_EMPLOYMENT_TERMS_NAME  | 
                                 Date  | 
| 
                                 Assignment external identifier  | 
                                 Assignment external identifier  | 
                                 CORE_ASSIGNMENT_EXTERNAL_ID  | 
                                 String  | 
| 
                                 Assignment hire date  | 
                                 Assignment hire date  | 
                                 CORE_ASSIGNMENT_HIRE_DATE  | 
                                 Date  | 
| 
                                 Assignment exempt indicator  | 
                                 Assignment exempt indicator  | 
                                 CORE_ASSIGNMENT_IS_EXEMPT  | 
                                 Boolean  | 
| 
                                 Assignment job  | 
                                 Job for assignment  | 
                                 CORE_ASSIGNMENT_JOB  | 
                                 String  | 
| 
                                 Assignment Cost Center  | 
                                 Cost Center for Assignment  | 
                                 CORE_ASSIGNMENT_JOB_COST_CENTER  | 
                                 String  | 
| 
                                 Assignment cost center effective date  | 
                                 Cost center effective date for assignment  | 
                                 CORE_ASSIGNMENT_JOB_COST_CENTER_EFFECTIVE_DATE  | 
                                 Date  | 
| 
                                 Assignment job cost center expiration date  | 
                                 Cost center expiration date for assignment  | 
                                 CORE_ASSIGNMENT_JOB_COST_CENTER_EXPIRATION_DATE  | 
                                 Date  | 
| 
                                 Assignment job cost center id  | 
                                 Cost center for assignment  | 
                                 CORE_ASSIGNMENT_JOB_COST_CENTER_ID  | 
                                 String  | 
| 
                                 Assignment job effective date  | 
                                 Effective date for assignment  | 
                                 CORE_ASSIGNMENT_JOB_EFFECTIVE_DATE  | 
                                 String  | 
| 
                                 Assignment job expiration date  | 
                                 Expiration date for assignment  | 
                                 CORE_ASSIGNMENT_JOB_EXPIRATION_DATE  | 
                                 Date  | 
| 
                                 Assignment labor category  | 
                                 Labor category for assignment  | 
                                 CORE_ASSIGNMENT_LABOR_ACCOUNT  | 
                                 String  | 
| 
                                 Assignment labor category effective date  | 
                                 Assignment labor category effective date  | 
                                 CORE_ASSIGNMENT_LABOR_ACCOUNT_EFFECTIVE_DATE  | 
                                 Date  | 
| 
                                 Assignment labor category expiration date  | 
                                 Assignment labor category expiration date  | 
                                 CORE_ASSIGNMENT_LABOR_ACCOUNT_EXPIRATION_DATE  | 
                                 String  | 
| 
                                 Assignment name  | 
                                 Assignment name  | 
                                 CORE_ASSIGNMENT_NAME  | 
                                 String  | 
| 
                                 Assignment order effective date  | 
                                 Effective date for assignment order  | 
                                 CORE_ASSIGNMENT_ORDER_EFFECTIVE_DATE  | 
                                 Date  | 
| 
                                 Assignment order expiration date  | 
                                 Expiration date for assignment order  | 
                                 CORE_ASSIGNMENT_ORDER_EXPIRATION_DATE  | 
                                 Date  | 
| 
                                 Assignment order primary indicator  | 
                                 Order's primary indicator for assignment  | 
                                 CORE_ASSIGNMENT_ORDER_IS_PRIMARY  | 
                                 Boolean  | 
| 
                                 Assignment order number  | 
                                 Order number for assignment  | 
                                 CORE_ASSIGNMENT_ORDER_NUMBER  | 
                                 String  | 
| 
                                 Apply PFS on Holidays for assignment  | 
                                 Pay from schedule on holidays is applied to the assignment  | 
                                 CORE_ASSIGNMENT_PAY_FROM_SCHEDULE_ASSIGNMENT_APPLY_PFS_ON_HOLIDAY  | 
                                 Boolean  | 
| 
                                 Assignment pay from schedule effective date  | 
                                 Pay from schedule effective date for assignment  | 
                                 CORE_ASSIGNMENT_PAY_FROM_SCHEDULE_ASSIGNMENT_EFFECTIVE_DATE  | 
                                 Date  | 
| 
                                 Assignment pay from schedule expiration date  | 
                                 Pay from schedule expiration date for assignment  | 
                                 CORE_ASSIGNMENT_PAY_FROM_SCHEDULE_ASSIGNMENT_EXPIRATION_DATE  | 
                                 String  | 
| 
                                 Assignment pay from schedule override pay rule  | 
                                 Pay from schedule override pay rule for assignment  | 
                                 CORE_ASSIGNMENT_PAY_FROM_SCHEDULE_ASSIGNMENT_OVERRIDE_PAY_RULE  | 
                                 Boolean  | 
| 
                                 Assignment pay from schedule pay edits  | 
                                 Pay from schedule pay edits for assignment  | 
                                 CORE_ASSIGNMENT_PAY_FROM_SCHEDULE_ASSIGNMENT_PAY_EDITS_FROM_SCHEDULE  | 
                                 Boolean  | 
| 
                                 Assignment pay shift from schedule  | 
                                 Pay shift from schedule for assignment  | 
                                 CORE_ASSIGNMENT_PAY_FROM_SCHEDULE_ASSIGNMENT_PAY_SHIFT_FROM_SCHEDULE  | 
                                 Boolean  | 
| 
                                 Assignment pay from schedule paycode tag  | 
                                 Pay from schedule paycode tag for assignment  | 
                                 CORE_ASSIGNMENT_PAY_FROM_SCHEDULE_ASSIGNMENT_PAYCODE_TAG  | 
                                 String  | 
| 
                                 Assignment identifier  | 
                                 Assignment identifier  | 
                                 CORE_ASSIGNMENT_POSITION_ID  | 
                                 String  | 
| 
                                 Assignment status effective date  | 
                                 Effective date for assignment status type  | 
                                 CORE_ASSIGNMENT_POSITION_STATUS_EFFECTIVE_DATE  | 
                                 Date  | 
| 
                                 Assignment status expiration date  | 
                                 Expiration date for assignment status type  | 
                                 CORE_ASSIGNMENT_POSITION_STATUS_EXPIRATION_DATE  | 
                                 Date  | 
| 
                                 Assignment status type  | 
                                 Type for assignment status type  | 
                                 CORE_ASSIGNMENT_POSITION_STATUS_TYPE  | 
                                 String  | 
| 
                                 Assignment primary location description  | 
                                 Assignment primary location description  | 
                                 CORE_ASSIGNMENT_PRIMARY_LOCATION_DESCRIPTION  | 
                                 String  | 
| 
                                 Assignment primary location full name  | 
                                 Assignment primary location full name  | 
                                 CORE_ASSIGNMENT_PRIMARY_LOCATION_FULLNAME  | 
                                 String  | 
| 
                                 Assignment primary location name  | 
                                 Assignment primary location name  | 
                                 CORE_ASSIGNMENT_PRIMARY_LOCATION_NAME  | 
                                 String  | 
| 
                                 Assignment schedule group effective date  | 
                                 Schedule group assignment effective date for assignment  | 
                                 CORE_ASSIGNMENT_SCHEDULE_GROUP_ASSIGNMENT_EFFECTIVE_DATE  | 
                                 Date  | 
| 
                                 Assignment schedule group expiration date  | 
                                 Schedule group assignment expiration date for assignment  | 
                                 CORE_ASSIGNMENT_SCHEDULE_GROUP_ASSIGNMENT_EXPIRATION_DATE  | 
                                 Date  | 
| 
                                 Assignment schedule group name  | 
                                 Schedule group assignment name for assignment  | 
                                 CORE_ASSIGNMENT_SCHEDULE_GROUP_ASSIGNMENT_NAME  | 
                                 String  | 
| 
                                 Assignment seniority date  | 
                                 Assignment seniority date  | 
                                 CORE_ASSIGNMENT_SENIORITY_DATE  | 
                                 Date  | 
| 
                                 Shift template profile  | 
                                 Shift template profile  | 
                                 CORE_ASSIGNMENT_SHIFT_TEMPLATE_PROFILE  | 
                                 String  | 
| 
                                 Supervisor's full name  | 
                                 Supervisor's full name  | 
                                 CORE_ASSIGNMENT_SUPERVISOR_FULL_NAME  | 
                                 String  | 
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category | 
|---|---|---|---|---|---|
| X | 
Relationship
| 
                                 One-to-One  | One-to-Many | 
|---|---|
| X | 
