Alias: RPO#

(P2K_RE_POSTINGS)

Unique Keys: Entity (DEN_ID) + POSTING_CODE

ERD: ERD-RE20

Postings for new positions in the organization.

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
DEN_ID	Number(10)	ID	Y	link to P2K_CM_ENTITIES
EAS_ID	Number(10)	ID	Y	manager link to P2K_HR_ASSIGNMENTS
RPO_ID	Number(10)	ID		link to P2K_RE_POSTINGS
DJB_ID	Number(10)	ID		link to P2K_CM_JOBS
DPS_ID	Number(10)	ID		link to P2K_CM_POSITIONS
DDP_ID	Number(10)	ID		link to P2K_CM_DEPARTMENTS
DGR_ID	Number(10)	ID		link to P2K_CM_GROUPS
DUN_ID	Number(10)	ID		link to P2K_CM_UNITS
DLN_ID	Number(10)	ID		link to P2K_CM_LOCATIONS
SWS_ID	Number(10)	ID		link to P2K_SA_WAGE_SCALES
SSR_ID	Number(10)	ID		link to P2K_SA_SALARY_RANGES
DWR_ID	Number(10)	ID		link to P2K_CM_WORK_RULES
RJP_ID	Number(10)	ID	Y	link to P2K_RE_JOB_PROFILES
POSTING_CODE	Varchar2(16)	CODE	Y
POSTING_TITLE	Varchar2(50)	DESCRIPTION	Y
POSTING_STATUS	Varchar2(2)	X_POSTING_STATUS	Y
POSTING_SOURCE	Varchar2(2)	X_POSTING_SOURCE
POSTING_TYPE	Varchar2(2)	X_POSTING_TYPE	Y
POSTING_CATEGORY	Varchar2(2)	X_POSTING_CATEGORY
POSTING_PRIORITY	Varchar2(2)	X_POSTING_PRIORITY
REQUIRED_FTE	Number(9)	AMT5V4
DEFAULT_FTE	Number(9)	AMT5V4
FILLED_FTE	Number(9)	AMT5V4
REQUISITION_DATE	Date()	DATE
INTERNAL_POSTING_OPENED	Date()	DATE
GENERAL_POSTING_OPENED	Date()	DATE
POSTING_CLOSED	Date()	DATE
POSTING_FILLED	Date()	DATE
EMPLOYMENT_TYPE	Varchar2(2)	X_EMPLOYMENT_TYPE
GROUP_TYPE	Varchar2(2)	X_GROUP_TYPE
RESPONSIBILITY_LEVEL	Varchar2(2)	X_RESPONSIBILITY_LEVEL
LANGUAGE_CLASS	Varchar2(2)	X_LANGUAGE_CLASS
WCB_CLASS	Varchar2(2)	X_WCB_CLASS
WORK_TYPE	Varchar2(2)	X_WORK_TYPE
ASSIGNMENT_START_DATE	Date()	DATE
ASSIGNMENT_END_DATE	Date()	DATE
HOURS_PER_DAY	Number(9)	AMT5V4
HOURS_PER_WEEK	Number(9)	AMT5V4
WAGE_RATE	Number(18)	AMT12V6
RATE_BASIS	Varchar2(2)	X_RATE_BASIS
POSTING_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
RRE_ID	Number(10)	ID		link to P2K_RE_RECRUITERS
APPROVED	Varchar2(1)	TOGGLE
WEB_ADDRESS	Varchar2(200)	URL
BID_STATUS	Varchar2(2)	X_BID_STATUS
EAS_ID_INCUMBENT	Number(10)	ID	Y	link to P2K_HR_ASSIGNMENTS

Derived Fields#

Column Name
DRV_APPLICATIONS
DRV_APPROVAL_BAR
DRV_CANCELED_APP
DRV_CANDIDATE_LOGIN
DRV_CHECK_APPLICATION
DRV_NEW_APP
DRV_POSTING_PRIORITY
DRV_TIME_LEFT

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page