!!!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|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|AMTnn]| | 
|[DEFAULT_FTE]|Number(9)|[AMT5V4|AMTnn]| | 
|[FILLED_FTE]|Number(9)|[AMT5V4|AMTnn]| | 
|[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|AMTnn]| | 
|[HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| | 
|[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| | 
|[RATE_BASIS]|Varchar2(2)|[X_RATE_BASIS]| | 
|[POSTING_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| 
|[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]| | 


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