!!!Alias: [IVRASE] (INF_CV_ASSESSMENTEVENTS) \\ Assessment Events !!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. |[ASSESSMENT_CODE]|Varchar2(16)|Y| |[PERSON_CODE]|Varchar2(16)| | |[CANDIDATE_CODE]|Varchar2(16)|Y| |[ASSESSMENT_EVENT_STATUS]|Varchar2(30)|Y| |[ASSESSMENT_DATE_TIME]|Date()|Y| |[LOCATION_CODE]|Varchar2(16)| | |[ENTITY_CODE]|Varchar2(16)| | |[EMPLOYMENT_TYPE]|Varchar2(30)| | |[HIRE_DATE]|Date()| | |[ASSIGNMENT_CODE]|Varchar2(16)| | |[ASSIGNMENT_START_DATE]|Date()| | |[CONTACT_FIRST_NAME|FIRST_NAME]|Varchar2(50)| | Used to identify and then link to the contact for the [Assessment Event|P2K_RE_ASSESSMENT_EVENTS] |[CONTACT_LAST_NAME|LAST_NAME]|Varchar2(50)| | Used to identify and then link to the contact for the [Assessment Event|P2K_RE_ASSESSMENT_EVENTS] |[RELATION]|Varchar2(30)| | |[EMPLOYER]|Varchar2(50)| | |[USER_NAME]|Varchar2(30)| | |[JOB_PROFILE_CODE]|Varchar2(16)| | |[STAGE_SEQUENCE]|Number(5)| | |[STEP_SEQUENCE]|Number(5)| | |[ASSESSMENT_RATING]|Varchar2(30)| | |[ASSESSMENT_POINTS]|Number(5)| | |[ASSESSMENT_BONUS_POINTS]|Number(5)| | |[ASSESSMENT_BONUS_REASON_TEXT]|Varchar2(4000)| | |[APPLICATION_CODE]|Varchar2(16)| | |[POSTING_CODE]|Varchar2(16)| | |[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. ---- ![Notes|Edit:Internal.INF_CV_ASSESSMENTEVENTS] [{InsertPage page='Internal.INF_CV_ASSESSMENTEVENTS' default='Click to create a new notes page'}]