# DW_TNL_STATUS_D (Preview)

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

## Details

Module: Time and Labor

## Key Columns

STATUS_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
STATUS_ID | NUMBER | 38 | 0 | True | Status Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier with status id |  |
ENTERPRISE_ID | NUMBER |  |  |  | Enterprise Identifier |  |
MODULE_ID | VARCHAR2 | 64 |  |  | Module Identifier |  |
RESOURCE_ID | NUMBER | 38 | 0 |  | Resource Identifier |  |
TIME_BUILDINGBLOCK_ID | NUMBER | 38 | 0 |  | Time Building block Identifier |  |
TIME_BUILDINGBLOCK_VERSION | NUMBER | 38 | 0 |  | Time Building block version |  |
DATE_FROM | TIMESTAMP |  |  |  | Start Date |  |
DATE_TO | TIMESTAMP |  |  |  | End Date |  |
TIME_STATUS_DEF_ID | NUMBER | 38 | 0 |  | Status Definition identifier |  |
STATUS_VALUE | VARCHAR2 | 32 |  |  | Status value |  |

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