Alias: RAP#

(P2K_RE_APPLICATIONS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-RE30


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
PREFERENCE_SEQUENCENumber(5)NUMBER5
QUALIFIED

Derived Fields#

Column Name
DRV_APPROVAL_BAR
DRV_ASSIGNMENT_END_DATE
DRV_ASSIGNMENT_START_DATE
DRV_CURRENT_STEP
DRV_HOURS_PER_DAY
DRV_HOURS_PER_WEEK
DRV_LAST_ASSESSMENT
DRV_NEW_ASSIGNMENT
DRV_RATE_BASIS
DRV_TOTAL_POINTS
DRV_WAGE_RATE

User Fields: Allowed
Audit Logging: Allowed

Notes #

Click to create a new notes page
This particular version was published on 26-Nov-2021 10:22 by jmyers.Top