RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Operational Data Store
Composite View Target: AP_HR_REQUISITION

Description Source composite view contains information pertaining to an HR Requisition.

Target Column Business Definition Database Data Type Source Name Source Column
ACCEPTING_APPLICANTS_IND Indicates whether applicants may be added or no new applicants can be added to the requisition. VARCHAR2(1)

PTRREQS

PTRREQS_ACCEPT_APPL_IND

APPLICATION_DATE Application submission date. DATE

PABREQU

PABREQU_APPL_DATE

APPROVAL_DATE Date the position requisition was approved. DATE

PABREQU

PABREQU_APPR_DATE

CLOSE_DATE Date the application for the position is closed. DATE

PABREQU

PABREQU_CLOSE_DATE

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

FULL_OR_PART_TIME Identifies if the requisition is for a full-time or part-time employment. VARCHAR2(0)

PTRECLS

PTRECLS_INTERNAL_FT_PT_IND

FULL_OR_PART_TIME_DESC Employment status description. VARCHAR2(0)

NA

NA

HIRE_DATE Projected date of hire for this position. DATE

PABREQU

PABREQU_HIRE_DATE

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

MINIMUM_DEGREE_LEVEL Minimum degree level required by the requisition. VARCHAR2(0)

PARPDEG

PARPDEG_DEGC_CODE

MINIMUM_DEGREE_LEVEL_DESC Minimum degree level description. VARCHAR2(0)

NA

NA

OPEN_DATE Date the application for the position opens. DATE

PABREQU

PABREQU_OPEN_DATE

POSITION Position number associated with this requisition. VARCHAR2(6)

PABREQU

PABREQU_POSN

POSTING_DATE Date the position is posted. DATE

PABREQU

PABREQU_POST_DATE

REQUISITION_NUMBER Requisition number of the position. VARCHAR2(10)

PABREQU

PABREQU_REQ_NO

REQUISITION_STATUS Status of the requisition (open, filled, etc.). VARCHAR2(2)

PABREQU

PABREQU_REQS_CODE

REQUISITION_STATUS_DESC Status description of the requisition. VARCHAR2(30)

PTRREQS

PTRREQS_DESC

VACANCY_DATE Date the position vacates. DATE

PABREQU

PABREQU_VACY_DATE

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 3.1