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 This column is for Oracle Internal use only. 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