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 |