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

Copyright © 2019, 2022, Oracle and/or its affiliates.