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.