Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Human Resources Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: HR_REQUISITION

Description Contains detailed information related to recruiting requisitions.
Key & Frequency One row per position per requisition number.
Recommended Search Columns REQUISITION_NUMBER, POSITION

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(63)

PTRREQS

PTRREQS_ACCEPT_APPL_IND

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

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

NA

NA

FULL_OR_PART_TIME_DESC Employment status description. VARCHAR2(255)

NA

NA

HIRE_DATE Projected date of hire for this position. DATE

PABREQU

PABREQU_HIRE_DATE

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

NA

NA

MINIMUM_DEGREE_LEVEL_DESC Minimum degree level description. VARCHAR2(255)

NA

NA

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

NA

NA

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

NA

NA

OPEN_DATE Date the application for the position is opened. DATE

PABREQU

PABREQU_OPEN_DATE

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

PABREQU

PABREQU_POSN

POSTING_DATE Date the position is posted. DATE

PABREQU

PABREQU_POST_DATE

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

NA

NA

REQUISITION_NUMBER Requisition number of the position. VARCHAR2(63)

PABREQU

PABREQU_REQ_NO

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

PABREQU

PABREQU_REQS_CODE

REQUISITION_STATUS_DESC Requisition status description. VARCHAR2(255)

PTRREQS

PTRREQS_DESC

VACANCY_DATE Date the position vacates. DATE

PABREQU

PABREQU_VACY_DATE



Ver: 8.0