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