Alias: RAP#

Unique Keys: _
Child Table:
_
Parent Table: _

Applications

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
RPO_IDNumber(10)IDYlink to P2K_RE_POSTINGS
RCA_IDNumber(10)IDYlink to P2K_RE_CANDIDATES
DEN_IDNumber(10)IDYlink to P2K_CM_ENTITIES
RST_IDNumber(10)IDYlink to P2K_RE_RECRUITING_STAGES
EAS_IDNumber(10)ID link to P2K_HR_ASSIGNMENTS
SWSS_IDNumber(10)ID link to P2K_SA_WAGE_SCALE_STEPS
APPLICATION_CODEVarchar2(16)CODEY
APPLICATION_STATUSVarchar2(2)X_APPLICATION_STATUSY
APPLICATION_STAGEVarchar2(2)X_APPLICATION_STAGEY
APPLICATION_OPENEDDate()DATEY
APPLICATION_CLOSEDDate()DATE
APPROVEDVarchar2(1)TOGGLE
APPLICATION_RATINGVarchar2(2)X_APPLICATION_RATING
OFFERED_DATEDate()DATE
RESPONSE_DATEDate()DATE
RESPONSE_INDICATIONVarchar2(2)X_RESPONSE_INDICATION
REASON_FOR_REJECTIONVarchar2(2)X_REASON_FOR_REJECTION
REASON_FOR_DECLINEVarchar2(2)X_REASON_FOR_DECLINE
ASSIGNMENT_START_DATEDate()DATE
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(2)X_RATE_BASIS
SCALE_OVERRIDDENVarchar2(1)TOGGLE
APPLICATION_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
SALARY_FROMNumber(18)AMT12V6
SALARY_TONumber(18)AMT12V6
REFERENCE_SOURCEVarchar2(2)X_REFERENCE_SOURCE
MOTIVATION_TO_APPLYVarchar2(4000)VARCHAR4000

User Fields: Allowed
Audit Logging: Allowed