INF_CV_APPLICATIONS
Back to current versionRestore this version

Alias: IVRAP#

(INF_CV_APPLICATIONS)
Applications

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
ENTITY_CODEVarchar2(16)CODEY
APPLICATION_CODEVarchar2(16)CODEY
CANDIDATE_CODEVarchar2(16)CODEY
POSTING_CODEVarchar2(16)CODEY
APPLICATION_STATUSVarchar2(30)VARCHAR30Y
APPLICATION_STAGEVarchar2(30)VARCHAR30Y
APPLICATION_OPENEDDate()DATEY
JOB_PROFILE_CODEVarchar2(16)CODEY
STAGE_SEQUENCENumber(5)NUMBER5Y
UNIT_CODEVarchar2(16)CODE
SCALE_CODEVarchar2(16)CODE
STEP_CODEVarchar2(16)CODE
PERSON_CODEVarchar2(16)CODE
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
HIRE_DATEDate()DATE
ASSIGNMENT_CODEVarchar2(16)CODE
ASSIGNMENT_START_DATEDate()DATE
APPLICATION_CLOSEDDate()DATE
APPLICATION_RATINGVarchar2(30)VARCHAR30
APPROVEDVarchar2(4)VARCHAR4
OFFERED_DATEDate()DATE
RESPONSE_DATEDate()DATE
RESPONSE_INDICATIONVarchar2(2)VARCHAR30
REASON_FOR_REJECTIONVarchar2(30)VARCHAR30
REASON_FOR_DECLINEVarchar2(30)VARCHAR30
ASSIGNMENT_END_DATEDate()DATE
ASSIGNMENT_TITLEVarchar2(50)DESCRIPTION
FTENumber(9)AMT5V4
HOURS_PER_DAYNumber(9)AMT5V4
HOURS_PER_WEEKNumber(9)AMT5V4
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(30)VARCHAR30
SCALE_OVERRIDDENVarchar2(4)VARCHAR4
SALARY_FROMNumber(18)AMT12V6
SALARY_TONumber(18)AMT12V6
REFERENCE_SOURCEVarchar2(30)VARCHAR30
MOTIVATION_TO_APPLYVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30

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