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 |
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation