INF_CV_RANGES
Back to current versionRestore this version

Alias: IVSRG#

(INF_CV_RANGES)
Salary Range Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
RANGE_CODEVarchar2(16)CODEY
RANGE_METHODVarchar2(30)VARCHAR30Y
DESCRIPTIONVarchar2(50)DESCRIPTION
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRY
CHANGE_CODEVarchar2(16)CODE
MATRIX_CODEVarchar2(16)CODE
MATRIX_START_DATEDate()DATE
RATE_BASISVarchar2(30)VARCHAR30Y
RANGE_MINIMUMNumber(18)AMT12V6
RANGE_MIDPOINTNumber(18)AMT12V6
RANGE_MAXIMUMNumber(18)AMT12V6
BASE_AMOUNTNumber(18)AMT12V6
DOLLAR_PER_POINTNumber(18)AMT12V6
MAXIMUM_PERCENTNumber(5)PERCENT
MINIMUM_PERCENTNumber(5)PERCENT
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30