!!!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.