!!!Alias: IVRJP (INF_CV_JOBPROFILES) \\ Job Profiles !!Table Columns \\ ||Column name||Data Type / Size||Mand.||Notes |[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded. |[ENTITY_CODE]|Varchar2(16)|Y| |[JOB_PROFILE_CODE]|Varchar2(16)|Y| |[JOB_PROFILE_TITLE]|Varchar2(50)|Y| |[JOB_PROFILE_STATUS]|Varchar2(30)|Y| |[JOB_PROFILE_TYPE]|Varchar2(30)| | |[JOB_CATEGORY]|Varchar2(30)| | |[LAST_REVIEW_DATE]|Date()| | |[PROFILE_IN_USE]|Varchar2(4)| | |[AUTO_POSTING]|Varchar2(4)| | |[AUTO_APPLICATION]|Varchar2(4)| | |[AUTO_LOOK_BACK_DAYS]|Number(5)| | |[STAGE_SEQUENCE]|Number(5)| | |[STAGE_DESCRIPTION]|Varchar2(50)| | |[STEP_SEQUENCE]|Number(5)| | |[ASSESSMENT_CODE]|Varchar2(16)| | |[STEP_DESCRIPTION]|Varchar2(50)| | |[WEIGHTING]|Number(5)| | |[DESIRED_POINTS]|Number(5)| | |[ESSENTIAL_POINTS]|Number(5)| | |[CREATE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CREATE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.