Workforce Assignments having no Supervisor
Module: Global Human Resources
ASSIGNMENT_ID, EFFECTIVE_START_DATE
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Assignment Identifier | ||
EFFECTIVE_START_DATE | DATE | True | Start date for Assignment Work measure | ||||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Source Record Identifier It is a unique combination of Assignment Assignment Identifier, Start Date | ||||
EFFECTIVE_END_DATE | DATE | End date for Assignment Work measure | |||||
WORKER_TYPE | VARCHAR2 | 32 | Indicates type of records- assignment , employment terms | DW_WORKER_TYPE_D_TL | WORKER_TYPE | ||
PERSON_ID | NUMBER | 38 | 0 | Person Identifier | DW_PERSON_D | PERSON_ID |