DW_TNL_TIMECARD_DAY_D (Preview)

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

Details

Module: Time and Labor

Key Columns

DAY_TM_REC_GRP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DAY_TM_REC_GRP_ID NUMBER 38 0 True Primary Key for Time card Day in Fusion Source.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
DAY_TM_REC_GRP_VERSION NUMBER 38 0 Day Time card version
RESOURCE_ID NUMBER 38 0 Resource Identifier- timecard is for Who DW_PERSON_D PERSON_ID
TM_REC_GRP_ID NUMBER 38 0 Time Card Identifier DW_TNL_TIMECARD_D TM_REC_GRP_ID
TM_REC_GRP_VERSION NUMBER 38 0 Time card version
START_TIME TIMESTAMP Start date and time for the time card
STOP_TIME TIMESTAMP Stop date and time for the time card
RESOURCE_TYPE VARCHAR2 32 Resource Type - Person
SUBRESOURCE_ID NUMBER 38 0 Assignment Identifier DW_WRKFRC_ASG_F ASSIGNMENT_ID
TIME_REPORTER_ID NUMBER 38 0 Time reporter Identifier DW_PERSON_D PERSON_ID
ENTERPRISE_ID NUMBER 38 0 Enterprise Identifier
GRP_TYPE_ID NUMBER 38 0 Group type Identifier 100 , 101
DATE_FROM TIMESTAMP Effective from date of Time card
DATE_TO TIMESTAMP Effective To date of Time card
LAYER_CODE VARCHAR2 32 Layer code - TIME_RPTD
COMMENT_TEXT VARCHAR2 999 Comment - for timecard
DELETE_FLAG VARCHAR2 16 Delete flag
LATEST_VERSION VARCHAR2 16 Latest Version of Time card