DW_TA_CANDIDATE_WORKER_ASG_F

Assignment details of the candidates after conversion to employee/contingent worker

Details

Module: Recruiting

Key Columns

ASSIGNMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ASSIGNMENT_ID NUMBER 38 0 True primary key of the table
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
ASSIGNMENT_NUMBER VARCHAR2 32 assignment number
PERSON_ID NUMBER 38 0 Person identifier
OFFER_ASG_ID NUMBER 38 0 Offer assignment identifier
ANCHOR_DATE DATE Greated of assignment start date and IED
ASSIGNMENT_TYPE VARCHAR2 32 assignment type (employee/contingent)
ASSIGNMENT_STATUS_TYPE_ID NUMBER 38 0 Assignment status type identifier
BUSINESS_UNIT_ID NUMBER 38 0 Business Unit Identifier
MANAGER_ID NUMBER 38 0 Manager identifier
JOB_ID NUMBER 38 0 Job identifier
GRADE_ID NUMBER 38 0 Grade identifier
LEGAL_EMPLOYER_ID NUMBER 38 0 Legal employer identifier
PERIOD_OF_SERVICE_ID NUMBER 38 0 Period of service identifier
LOCATION_ID NUMBER 38 0 Location identifier
POSITION_ID NUMBER 38 0 Position identifier