Alias: IVSMX#

(INF_CV_MATRICES)

The INF_CV_MATRICES table is used to import salary review matrices into the software data structures.

Tables loaded:

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
ENTITY_CODEVarchar2(16)YValidation: Must be a valid entity code already defined on P2K_CM_ENTITIES.
MATRIX_CODEVarchar2(16)Y
MATRIX_START_DATEDate()YValidation: Must be a valid date
MATRIX_END_DATEDate() Validation: Must be a valid date
DESCRIPTIONVarchar2(50)
OVERALL_RATINGVarchar2(30)YValidation: Must be one of the fixed lexicon values from X_OVERALL_RATING
LOW_COMPA_RATIONumber(5)Y
HIGH_COMPA_RATIONumber(5)Y
MINIMUM_PERCENTNumber(5)
MAXIMUM_PERCENTNumber(5)
RECOMMENDED_PERCENTNumber(5)
COMPA_RATIO_LIMITNumber(5)
AUTO_APPROVALVarchar2(4) Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N” , “NO” or “0”. All other values will translate to True.
MAXIMUM_POINTSNumber(5)
MINIMUM_POINTSNumber(5)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.