DW_CMP_AFFECT_OVERALL_SALARY_TL (Preview)
This table requires activation of Salary Basis functional area. This table contains information about code, name, and description for the ORA_CMP_AFFECT_OVERALL_SALARY related codes
Details
Module: Compensation
Key Columns
AFFECT_OVERALL_SALARY_CODE, LANGUAGE
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| AFFECT_OVERALL_SALARY_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. | ||||
| AFFECT_OVERALL_SALARY_NAME | VARCHAR2 | 128 | Business name or value of the code. | ||||
| AFFECT_OVERALL_SALARY_DESCRIPTION | VARCHAR2 | 256 | Code description. |