DW_TNL_TIMECARD_D (Preview)

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

Details

Module: Time and Labor

Key Columns

TM_REC_GRP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TM_REC_GRP_ID NUMBER 38 0 True Primary Key for Time card in Fusion Source.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
TM_REC_GRP_VERSION NUMBER 38 0 Version of Time card
ORIG_TM_REC_GRP_ID NUMBER Reported Time Card identifer
ORIG_TM_REC_GRP_VERSION NUMBER Reported Time card Version
RESOURCE_ID NUMBER 38 0 Resource Identifier- timecard is for Who DW_PERSON_D PERSON_ID
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, ABSENCES
COMMENT_TEXT VARCHAR2 999 Comment - for timecard
DELETE_FLAG VARCHAR2 16 Delete flag
LATEST_VERSION VARCHAR2 16 Latest Version of Time card