This table requires activation of Time and Labor functional area. It stores time entry status
Module: Time and Labor
TIME_STATUS_DEF_ID
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.