INF_CV_APPLICATIONS
Back to current versionRestore this version

Alias: IVRAP#

(INF_CV_APPLICATIONS)
Applications

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10)
ENTITY_CODEVarchar2(16)Y
APPLICATION_CODEVarchar2(16)Y
CANDIDATE_CODEVarchar2(16)Y
POSTING_CODEVarchar2(16)Y
APPLICATION_STATUSVarchar2(30)Y
APPLICATION_STAGEVarchar2(30)Y
APPLICATION_OPENEDDate()Y
JOB_PROFILE_CODEVarchar2(16)Y
STAGE_SEQUENCENumber(5)Y
UNIT_CODEVarchar2(16)
SCALE_CODEVarchar2(16)
STEP_CODEVarchar2(16)
PERSON_CODEVarchar2(16)
EMPLOYMENT_TYPEVarchar2(30)
HIRE_DATEDate()
ASSIGNMENT_CODEVarchar2(16)
ASSIGNMENT_START_DATEDate()
APPLICATION_CLOSEDDate()
APPLICATION_RATINGVarchar2(30)
APPROVEDVarchar2(4)
OFFERED_DATEDate()
RESPONSE_DATEDate()
RESPONSE_INDICATIONVarchar2(2)
REASON_FOR_REJECTIONVarchar2(30)
REASON_FOR_DECLINEVarchar2(30)
ASSIGNMENT_END_DATEDate()
ASSIGNMENT_TITLEVarchar2(50)
FTENumber(9)
HOURS_PER_DAYNumber(9)
HOURS_PER_WEEKNumber(9)
WAGE_RATENumber(18)
RATE_BASISVarchar2(30)
SCALE_OVERRIDDENVarchar2(4)
SALARY_FROMNumber(18)
SALARY_TONumber(18)
REFERENCE_SOURCEVarchar2(30)
MOTIVATION_TO_APPLYVarchar2(4000)
CREATE_DATEDate()
CREATE_USERVarchar2(30)
CHANGE_DATEDate()
CHANGE_USERVarchar2(30)