DW_WRKFRC_ASG_NO_SUP_D

Workforce Assignments having no Supervisor

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_START_DATE, ASSIGNMENT_ID

Columns

Columns
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

Copyright © 2019, 2022, Oracle and/or its affiliates.