DW_TNL_TIMECARD_HEADER_D (Preview)
This table requires activation of Time and Labor functional area. Holds Time Card header details
Details
Module: Time and Labor
Key Columns
TM_HEADER_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| TM_HEADER_ID | NUMBER | 38 | 0 | True | Primary Key for Time card Header in Fusion Source. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Unique Source Record Identifier | ||||
| ENTERPRISE_ID | NUMBER | 38 | 0 | Enterprise Identifier | |||
| RESOURCE_ID | NUMBER | 38 | 0 | Resource Identifier- timecard is for Who | DW_PERSON_D | PERSON_ID | |
| TCLAYST_ID | NUMBER | 38 | 0 | Layout Set Identifier | DW_TNL_TIME_LAYOUT_SET_D | ||
| START_DATE | DATE | Start date for the time card | |||||
| END_DATE | DATE | Stop date for the time card | |||||
| OBJECT_TYPE | VARCHAR2 | 256 | Object type - Timecard, Schedule, etc | ||||
| TIME_BLDG_BLK_ID | NUMBER | 38 | 0 | Time Card Identifier | DW_TNL_TIMECARD_D | TM_REC_GRP_ID | |
| TIME_BLDG_BLK_VERSION | NUMBER | 38 | 0 | Time card version Identifier | DW_TNL_TIMECARD_D | TM_REC_GRP_VERSION |