Alias: IVRJP#

(INF_CV_JOBPROFILES)
Job Profiles

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)Y
JOB_PROFILE_CODEVarchar2(16)Y
JOB_PROFILE_TITLEVarchar2(50)Y
JOB_PROFILE_STATUSVarchar2(30)Y
JOB_PROFILE_TYPEVarchar2(30)
JOB_CATEGORYVarchar2(30)
LAST_REVIEW_DATEDate()
PROFILE_IN_USEVarchar2(4)
AUTO_POSTINGVarchar2(4)
AUTO_APPLICATIONVarchar2(4)
AUTO_LOOK_BACK_DAYSNumber(5)
STAGE_SEQUENCENumber(5)
STAGE_DESCRIPTIONVarchar2(50)
STEP_SEQUENCENumber(5)
ASSESSMENT_CODEVarchar2(16)
STEP_DESCRIPTIONVarchar2(50)
WEIGHTINGNumber(5)
DESIRED_POINTSNumber(5)
ESSENTIAL_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.