!!!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 grouping
!!Table 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|VARCHARnn]|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|VARCHARnn]|Y|
|[RANGE_MINIMUM]|Number(18)|[AMT12V6|AMTnn]| |
|[RANGE_MIDPOINT]|Number(18)|[AMT12V6|AMTnn]| |
|[RANGE_MAXIMUM]|Number(18)|[AMT12V6|AMTnn]| |
|[BASE_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[DOLLAR_PER_POINT]|Number(18)|[AMT12V6|AMTnn]| |
|[MAXIMUM_PERCENT]|Number(5)|[PERCENT]| |
|[MINIMUM_PERCENT]|Number(5)|[PERCENT]| |
|[CREATE_DATE]|Date()|[DATE]| |
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CHANGE_DATE]|Date()|[DATE]| |
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |