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 |
