!!!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]| |
|[PREFERENCE_SEQUENCE]|Number(5)|[NUMBER5]| |
[QUALIFIED]  

!![Derived Fields|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|Edit:Internal.P2K_RE_APPLICATIONS] 	
[{InsertPage page='Internal.P2K_RE_APPLICATIONS' default='Click to create a new notes page'}]