Alias: IVRASE#

(INF_CV_ASSESSMENTEVENTS)

Assessment Events

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.
ASSESSMENT_CODEVarchar2(16)Y
PERSON_CODEVarchar2(16)
CANDIDATE_CODEVarchar2(16)Y
ASSESSMENT_EVENT_STATUSVarchar2(30)Y
ASSESSMENT_DATE_TIMEDate()Y
LOCATION_CODEVarchar2(16)
ENTITY_CODEVarchar2(16)
EMPLOYMENT_TYPEVarchar2(30)
HIRE_DATEDate()
ASSIGNMENT_CODEVarchar2(16)
ASSIGNMENT_START_DATEDate()
CONTACT_FIRST_NAMEVarchar2(50) Used to identify and then link to the contact for the Assessment Event
CONTACT_LAST_NAMEVarchar2(50) Used to identify and then link to the contact for the Assessment Event
RELATIONVarchar2(30)
EMPLOYERVarchar2(50)
USER_NAMEVarchar2(30)
JOB_PROFILE_CODEVarchar2(16)
STAGE_SEQUENCENumber(5)
STEP_SEQUENCENumber(5)
ASSESSMENT_RATINGVarchar2(30)
ASSESSMENT_POINTSNumber(5)
ASSESSMENT_BONUS_POINTSNumber(5)
ASSESSMENT_BONUS_REASON_TEXTVarchar2(4000)
APPLICATION_CODEVarchar2(16)
POSTING_CODEVarchar2(16)
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.


Notes #

Click to create a new notes page