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