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
HOURS_PER_DAY	Number(9)	AMT5V4
HOURS_PER_WEEK	Number(9)	AMT5V4
WAGE_RATE	Number(18)	AMT12V6
RATE_BASIS	Varchar2(2)	X_RATE_BASIS
SCALE_OVERRIDDEN	Varchar2(1)	TOGGLE
APPLICATION_TEXT	Varchar2(4000)	VARCHAR4000
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
SALARY_FROM	Number(18)	AMT12V6
SALARY_TO	Number(18)	AMT12V6
REFERENCE_SOURCE	Varchar2(2)	X_REFERENCE_SOURCE
MOTIVATION_TO_APPLY	Varchar2(4000)	VARCHAR4000
PREFERENCE_SEQUENCE	Number(5)	NUMBERn
QUALIFIED	Varchar2(1)	X_YES_NO
AWARD_STATUS	Varchar2(2)	X_AWARD_STATUS
AWARD_DATE	Date()	DATE
DCR_ID	Number(10)	ID		link to P2K_CM_CHANGE_REASONS
DES_ID	Number(10)	ID		link to P2K_CM_EMPLOYMENT_STATUSES

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