P 2 K_RE_APPLICATIONS
Back to current versionRestore this version

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

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

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