DW_TNL_STATUS_DEF_D (Preview)

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

Details

Module: Time and Labor

Key Columns

TIME_STATUS_DEF_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
TIME_STATUS_DEF_ID NUMBER 38 0 True Status definitionIdentifier    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Unique Source Record Identifier with status id    
ENTERPRISE_ID NUMBER 38 0   Enterprise Identifier    
MODULE_ID VARCHAR2 64     Module Identifier    
TIME_STATUS_TYPE VARCHAR2 32     Status Type    
TIME_CONSUMER_SET_ID NUMBER 38 0   Time consumer set Identifier    
SCOPE VARCHAR2 32     scope    
REPOSITORY_TYPE VARCHAR2 64     Repository type like Group or Record    
VALUE_IF_TRUE VARCHAR2 32     value in case of true    
VALUE_IF_FALSE VARCHAR2 32     value in case of false    
VALUE_DERIVED_FLAG VARCHAR2 32     derived flag    
STATUS_DEFCD VARCHAR2 32     status definition cd    
TRUE_VALUE NUMBER 38 0   True value    
FALSE_VALUE NUMBER 38 0   Flase value    
ALLOWABLE_VALUES VARCHAR2 32     Allowable values    
DEFINITION_CODE VARCHAR2 64     Definition code    

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