This table requires activation of Time and Labor functional area. Holds Time Card details
Module: Time and Labor
TM_REC_GRP_ID
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 | 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 |
Copyright © 2019, 2022, Oracle and/or its affiliates.