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

EmployeeOrganizationDayOrganizational JobPaycodeLabor Category
X

Relationship

One-to-One

One-to-Many
X