# 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, 2025, Oracle and/or its affiliates.