P 2 K_RE_POSTINGS
Back to current versionRestore this version

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 nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DEN_IDNumber(10)IDYlink to P2K_CM_ENTITIES
EAS_IDNumber(10)IDYlink to P2K_HR_ASSIGNMENTS
RPO_IDNumber(10)ID link to P2K_RE_POSTINGS
DJB_IDNumber(10)ID link to P2K_CM_JOBS
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS
DDP_IDNumber(10)ID link to P2K_CM_DEPARTMENTS
DGR_IDNumber(10)ID link to P2K_CM_GROUPS
DUN_IDNumber(10)ID link to P2K_CM_UNITS
DLN_IDNumber(10)ID link to P2K_CM_LOCATIONS
SWS_IDNumber(10)ID link to P2K_SA_WAGE_SCALES
SSR_IDNumber(10)ID link to P2K_SA_SALARY_RANGES
DWR_IDNumber(10)ID link to P2K_CM_WORK_RULES
RJP_IDNumber(10)IDYlink to P2K_RE_JOB_PROFILES
POSTING_CODEVarchar2(16)CODEY
POSTING_TITLEVarchar2(50)DESCRIPTIONY
POSTING_STATUSVarchar2(2)X_POSTING_STATUSY
POSTING_SOURCEVarchar2(2)X_POSTING_SOURCE
POSTING_TYPEVarchar2(2)X_POSTING_TYPEY
POSTING_CATEGORYVarchar2(2)X_POSTING_CATEGORY
POSTING_PRIORITYVarchar2(2)X_POSTING_PRIORITY
REQUIRED_FTENumber(9)AMT5V4
DEFAULT_FTENumber(9)AMT5V4
FILLED_FTENumber(9)AMT5V4
REQUISITION_DATEDate()DATE
INTERNAL_POSTING_OPENEDDate()DATE
GENERAL_POSTING_OPENEDDate()DATE
POSTING_CLOSEDDate()DATE
POSTING_FILLEDDate()DATE
EMPLOYMENT_TYPEVarchar2(2)X_EMPLOYMENT_TYPE
GROUP_TYPEVarchar2(2)X_GROUP_TYPE
RESPONSIBILITY_LEVELVarchar2(2)X_RESPONSIBILITY_LEVEL
LANGUAGE_CLASSVarchar2(2)X_LANGUAGE_CLASS
WCB_CLASSVarchar2(2)X_WCB_CLASS
WORK_TYPEVarchar2(2)X_WORK_TYPE
ASSIGNMENT_START_DATEDate()DATE
ASSIGNMENT_END_DATEDate()DATE
HOURS_PER_DAYNumber(9)AMT5V4
HOURS_PER_WEEKNumber(9)AMT5V4
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(2)X_RATE_BASIS
POSTING_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
RRE_IDNumber(10)ID link to P2K_RE_RECRUITERS
APPROVEDVarchar2(1)TOGGLE
WEB_ADDRESSVarchar2(200)URL
BID_STATUSVarchar2(2)X_BID_STATUS

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation