Alias: IVSMX#

(INF_CV_MATRICES)
Salary Matrix Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
MATRIX_CODEVarchar2(16)CODEY
MATRIX_START_DATEDate()DATEY
MATRIX_END_DATEDate()DATE
DESCRIPTIONVarchar2(50)DESCRIPTION
OVERALL_RATINGVarchar2(30)VARCHAR30Y
LOW_COMPA_RATIONumber(5)PERCENTY
HIGH_COMPA_RATIONumber(5)PERCENTY
MINIMUM_PERCENTNumber(5)PERCENT
MAXIMUM_PERCENTNumber(5)PERCENT
RECOMMENDED_PERCENTNumber(5)PERCENT
COMPA_RATIO_LIMITNumber(5)PERCENT
AUTO_APPROVALVarchar2(4)VARCHAR4
MAXIMUM_POINTSNumber(5)NUMBER5
MINIMUM_POINTSNumber(5)NUMBER5
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30