DW_TNL_TIMEENTRY_F (Preview)

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

Details

Module: Time and Labor

Key Columns

TM_REC_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TM_REC_ID NUMBER 38 0 True Primary Key for Time Entry in Fusion Source.    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier    
TM_REC_VERSION NUMBER 38 0   Version of Time entry    
ORIG_TM_REC_ID NUMBER       Reported Time Entry Identifer    
ORIG_TM_REC_VERSION NUMBER       Reported Time entry Version    
ENTERPRISE_ID NUMBER 38 0   Enterprise Identifier    
RESOURCE_ID NUMBER 38 0   Resource Identifier- time entry is for Who DW_PERSON_D PERSON_ID
START_TIME TIMESTAMP       Start date and time for the time entry    
STOP_TIME TIMESTAMP       Stop date and time for the time entry    
MEASURE NUMBER       no. of hours    
UNIT_OF_MEASURE VARCHAR2 32     Uom of the measure    
TM_REC_TYPE VARCHAR2 32     Time record type - Range/measure    
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
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    

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