!!!Alias: RAP (P2K_RE_APPLICATIONS) Unique Keys: \\ Child Table: \\ Parent Table: \\ ERD: [ERD-RE30] \\ Applications !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[RPO_ID]|Number(10)|[ID]|Y|link to [P2K_RE_POSTINGS] |[RCA_ID]|Number(10)|[ID]|Y|link to [P2K_RE_CANDIDATES] |[DEN_ID]|Number(10)|[ID]|Y|link to [P2K_CM_ENTITIES] |[RST_ID]|Number(10)|[ID]|Y|link to [P2K_RE_RECRUITING_STAGES] |[EAS_ID]|Number(10)|[ID]| |link to [P2K_HR_ASSIGNMENTS] |[SWSS_ID]|Number(10)|[ID]| |link to [P2K_SA_WAGE_SCALE_STEPS] |[APPLICATION_CODE]|Varchar2(16)|[CODE]|Y| |[APPLICATION_STATUS]|Varchar2(2)|[X_APPLICATION_STATUS]|Y| |[APPLICATION_STAGE]|Varchar2(2)|[X_APPLICATION_STAGE]|Y| |[APPLICATION_OPENED]|Date()|[DATE]|Y| |[APPLICATION_CLOSED]|Date()|[DATE]| | |[APPROVED]|Varchar2(1)|[TOGGLE]| | |[APPLICATION_RATING]|Varchar2(2)|[X_APPLICATION_RATING]| | |[OFFERED_DATE]|Date()|[DATE]| | |[RESPONSE_DATE]|Date()|[DATE]| | |[RESPONSE_INDICATION]|Varchar2(2)|[X_RESPONSE_INDICATION]| | |[REASON_FOR_REJECTION]|Varchar2(2)|[X_REASON_FOR_REJECTION]| | |[REASON_FOR_DECLINE]|Varchar2(2)|[X_REASON_FOR_DECLINE]| | |[ASSIGNMENT_START_DATE]|Date()|[DATE]| | |[ASSIGNMENT_END_DATE]|Date()|[DATE]| | |[ASSIGNMENT_TITLE]|Varchar2(50)|[DESCRIPTION]| | |[FTE]|Number(9)|[AMT5V4|AMTnn]| | |[HOURS_PER_DAY]|Number(9)|[AMT5V4|AMTnn]| | |[HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| | |[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| | |[RATE_BASIS]|Varchar2(2)|[X_RATE_BASIS]| | |[SCALE_OVERRIDDEN]|Varchar2(1)|[TOGGLE]| | |[APPLICATION_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[SALARY_FROM]|Number(18)|[AMT12V6|AMTnn]| | |[SALARY_TO]|Number(18)|[AMT12V6|AMTnn]| | |[REFERENCE_SOURCE]|Varchar2(2)|[X_REFERENCE_SOURCE]| | |[MOTIVATION_TO_APPLY]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | User Fields: Allowed\\ Audit Logging: Allowed\\ [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.P2K_RE_APPLICATIONS] [{InsertPage page='Internal.P2K_RE_APPLICATIONS' default='Click to create a new discussion page'}] }]