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)

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation