Wiki: P 2 K_RE_APPLICATIONS

Alias: RAP#

(P2K_RE_APPLICATIONS)

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

Applications

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)	NUMBER5

User Fields: Allowed
Audit Logging: Allowed

Click to create a new notes page