INF_CV_JOBPROFILES
Back to current versionRestore this version

Alias: IVRJP#

(INF_CV_JOBPROFILES)
Job Profiles

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
JOB_PROFILE_CODEVarchar2(16)CODEY
JOB_PROFILE_TITLEVarchar2(50)VARCHAR50Y
JOB_PROFILE_STATUSVarchar2(30)VARCHAR30Y
JOB_PROFILE_TYPEVarchar2(30)VARCHAR30
JOB_CATEGORYVarchar2(30)VARCHAR30
LAST_REVIEW_DATEDate()DATE
PROFILE_IN_USEVarchar2(4)VARCHAR4
AUTO_POSTINGVarchar2(4)VARCHAR4
AUTO_APPLICATIONVarchar2(4)VARCHAR4
AUTO_LOOK_BACK_DAYSNumber(5)NUMBER5
STAGE_SEQUENCENumber(5)NUMBER5
STAGE_DESCRIPTIONVarchar2(50)DESCRIPTION
STEP_SEQUENCENumber(5)NUMBER5
ASSESSMENT_CODEVarchar2(16)CODE
STEP_DESCRIPTIONVarchar2(50)DESCRIPTION
WEIGHTINGNumber(5)NUMBER5
DESIRED_POINTSNumber(5)NUMBER5
ESSENTIAL_POINTSNumber(5)NUMBER5
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30