DW_CMP_SAL_BASIS_DET_METHOD_D_TL (Preview)
This table requires activation of Salary Basis functional area. This table contains information about code, name, and description for the ORA_CMP_SAL_BASIS_DET_METHOD related codes
Details
Module: Compensation
Key Columns
SAL_BASIS_DET_CODE, SAL_BASIS_DET_CODE_TYPE, LANGUAGE
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| SAL_BASIS_DET_CODE_TYPE | VARCHAR2 | 128 | True | Code type. It is specific to functionality. | |||
| SAL_BASIS_DET_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. | ||||
| SAL_BASIS_DET_NAME | VARCHAR2 | 128 | Business name or value of the code. | ||||
| SAL_BASIS_DET_DESCRIPTION | VARCHAR2 | 256 | Code description. |