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