Alias: IVSRG#
The INF_CV_RANGES table is used to import salary ranges and range rules into the software data structures. Salary ranges define the minimum and maximum salary or wage values that an organization considers appropriate for a job groupingTable Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | ||
| ENTITY_CODE | Varchar2(16) | CODE | Y | |
| RANGE_CODE | Varchar2(16) | CODE | Y | |
| RANGE_METHOD | Varchar2(30) | VARCHAR30 | Y | |
| DESCRIPTION | Varchar2(50) | DESCRIPTION | ||
| EFFECTIVE | Date() | EFFECTIVE | Y | |
| EXPIRY | Date() | EXPIRY | ||
| CHANGE_CODE | Varchar2(16) | CODE | ||
| MATRIX_CODE | Varchar2(16) | CODE | ||
| MATRIX_START_DATE | Date() | DATE | ||
| RATE_BASIS | Varchar2(30) | VARCHAR30 | Y | |
| RANGE_MINIMUM | Number(18) | AMT12V6 | ||
| RANGE_MIDPOINT | Number(18) | AMT12V6 | ||
| RANGE_MAXIMUM | Number(18) | AMT12V6 | ||
| BASE_AMOUNT | Number(18) | AMT12V6 | ||
| DOLLAR_PER_POINT | Number(18) | AMT12V6 | ||
| MAXIMUM_PERCENT | Number(5) | PERCENT | ||
| MINIMUM_PERCENT | Number(5) | PERCENT | ||
| 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