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
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top