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     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    

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