Table of Contents
SCALE INTERFACE FILE#
The Scale Interface File screen is used to import salary scales and steps into the software data structures.
Scale Interface File data is maintained on the INF_CV_SCALES table.
- ID
- This field identifies the scale record within the data base.
| ENTITY_CODE | Varchar2(16) | Y | Validation: Must be a valid entity code defined on P2K_CM_ENTITIES. |
| UNIT_CODE | Varchar2(16) | Y | Validation: Must be a valid unit code defined on P2K_CM_UNITS. |
| SCALE_CODE | Varchar2(16) | Y | Validation: Must be a unique scale code for the unit specified. |
| SCALE_DESCRIPTION | Varchar2(50) | ||
| RATE_MATRIX_CODE | Varchar2(16) | ||
| WAGE_STEP_RULE_CODE | Varchar2(16) | ||
| STEP_CODE | Varchar2(16) | Validation: Must be a unique step code for the scale specified. | |
| STEP_SEQUENCE | Number(5) | ||
| EFFECTIVE | Date() | Validation: Must be a valid date format. Suggestion: If you are not loading multiple date-effective records for the same scale/step code, then populate this field with a constant ‘01-Jan-0001’ which represents the beginning of time. | |
| EXPIRY | Date() | Validation: Must be a valid date format, with a date after the effective date. Suggestion: If you are not loading multiple date-effective records for the same scale/step code, then populate this field with a constant ‘31-Dec-3999’ which represents the end of time. | |
| CHANGE_CODE | Varchar2(16) | Validation: The Change Code provided must be defined on P2K_CM_CHANGE_REASONS | |
| RATE_BASIS | Varchar2(30) | Validation: If provided, must be one of the fixed lexicon values from X_RATE_BASIS | |
| SCALE_RATE | Number(18) | ||
| CELL_NUMBER | Number(5) |
