INF_CV_ASSESSMENTEVENTS
Back to current versionRestore this version

Alias: IVRASE#

(INF_CV_ASSESSMENTEVENTS)
Assessment Events

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ASSESSMENT_CODEVarchar2(16)CODEY
PERSON_CODEVarchar2(16)CODE
CANDIDATE_CODEVarchar2(16)CODEY
ASSESSMENT_EVENT_STATUSVarchar2(30)VARCHAR30Y
ASSESSMENT_DATE_TIMEDate()TIMESTAMPY
LOCATION_CODEVarchar2(16)CODE
ENTITY_CODEVarchar2(16)CODE
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
ASSIGNMENT_CODEVarchar2(16)CODE
ASSIGNMENT_START_DATEDate()DATE
CONTACT_FIRST_NAMEVarchar2(50)VARCHAR50
CONTACT_LAST_NAMEVarchar2(50)VARCHAR50
RELATIONVarchar2(30)VARCHAR30
EMPLOYERVarchar2(50)VARCHAR50
USER_NAMEVarchar2(30)VARCHAR30
JOB_PROFILE_CODEVarchar2(16)CODE
STAGE_SEQUENCENumber(5)NUMBER5
STEP_SEQUENCENumber(5)NUMBER5
ASSESSMENT_RATINGVarchar2(30)VARCHAR30
ASSESSMENT_POINTSNumber(5)NUMBER5
ASSESSMENT_BONUS_POINTSNumber(5)NUMBER5
ASSESSMENT_BONUS_REASON_TEXTVarchar2(4000)VARCHAR4000
APPLICATION_CODEVarchar2(16)CODE
POSTING_CODEVarchar2(16)CODE
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30