DW_TNL_STATUS_D (Preview)

This table requires activation of Time and Labor functional area. It stores time entry status

Details

Module: Time and Labor

Key Columns

STATUS_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
STATUS_ID NUMBER 38 0 True Status Identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier with status id
ENTERPRISE_ID NUMBER Enterprise Identifier
MODULE_ID VARCHAR2 64 Module Identifier
RESOURCE_ID NUMBER 38 0 Resource Identifier
TIME_BUILDINGBLOCK_ID NUMBER 38 0 Time Building block Identifier
TIME_BUILDINGBLOCK_VERSION NUMBER 38 0 Time Building block version
DATE_FROM TIMESTAMP Start Date
DATE_TO TIMESTAMP End Date
TIME_STATUS_DEF_ID NUMBER 38 0 Status Definition identifier
STATUS_VALUE VARCHAR2 32 Status value