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