# DW_CMP_APPROVAL_D_TL

This table contains information about code, name, and description for the CMP_CWB_APPROVAL related codes

## Details

Module: Compensation

## Key Columns

LANGUAGE, APPROVAL_CODE, APPROVAL_CODE_TYPE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
APPROVAL_CODE_TYPE | VARCHAR2 | 128 |  | True | Code type. It is specific to functionality. |  |
APPROVAL_CODE | VARCHAR2 | 128 |  | True | Code. |  |
LANGUAGE | VARCHAR2 | 64 |  | True | Translation language. |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of code type and code. |  |
APPROVAL_NAME | VARCHAR2 | 128 |  |  | Business name or value of the code. |  |
APPROVAL_DESCRIPTION | VARCHAR2 | 256 |  |  | Code description. |  |

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