DW_TNL_TIMECARD_HEADER_D (Preview)

This table requires activation of Time and Labor functional area. Holds Time Card header details

Details

Module: Time and Labor

Key Columns

TM_HEADER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TM_HEADER_ID NUMBER 38 0 True Primary Key for Time card Header in Fusion Source.    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier    
ENTERPRISE_ID NUMBER 38 0   Enterprise Identifier    
RESOURCE_ID NUMBER 38 0   Resource Identifier- timecard is for Who DW_PERSON_D PERSON_ID
TCLAYST_ID NUMBER 38 0   Layout Set Identifier DW_TNL_TIME_LAYOUT_SET_D  
START_DATE DATE       Start date for the time card    
END_DATE DATE       Stop date for the time card    
OBJECT_TYPE VARCHAR2 256     Object type - Timecard, Schedule, etc    
TIME_BLDG_BLK_ID NUMBER 38 0   Time Card Identifier DW_TNL_TIMECARD_D TM_REC_GRP_ID
TIME_BLDG_BLK_VERSION NUMBER 38 0   Time card version Identifier DW_TNL_TIMECARD_D TM_REC_GRP_VERSION

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