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