Alias: IVSSC#
The INF_CV_SCALES table is used to import salary scales and steps into the software data structures. Wage scales, defined by unit, are the schedules of wage and salary rates for an organization. Scales have at least one and may have multiple steps. Wage scale steps define the increments within the wage scale and stepping sequence of the steps.Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | ||
| ENTITY_CODE | Varchar2(16) | CODE | Y | |
| UNIT_CODE | Varchar2(16) | CODE | Y | |
| SCALE_CODE | Varchar2(16) | CODE | Y | |
| SCALE_DESCRIPTION | Varchar2(50) | DESCRIPTION | ||
| RATE_MATRIX_CODE | Varchar2(16) | CODE | ||
| WAGE_STEP_RULE_CODE | Varchar2(16) | CODE | ||
| STEP_CODE | Varchar2(16) | CODE | ||
| STEP_SEQUENCE | Number(5) | NUMBER5 | ||
| EFFECTIVE | Date() | EFFECTIVE | ||
| EXPIRY | Date() | EXPIRY | ||
| CHANGE_CODE | Varchar2(16) | CODE | ||
| RATE_BASIS | Varchar2(30) | VARCHAR30 | ||
| SCALE_RATE | Number(18) | AMT12V6 | ||
| CELL_NUMBER | Number(5) | NUMBER5 | ||
| CREATE_DATE | Date() | DATE | ||
| CREATE_USER | Varchar2(30) | VARCHAR30 | ||
| CHANGE_DATE | Date() | DATE | ||
| CHANGE_USER | Varchar2(30) | VARCHAR30 |
