Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

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
REQUISITION_STATUS

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACCEPTING_APPLICANTS_IND Accepting Applicants Indicator 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 Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPLICATION_DATE Application Date Application submission date. DATE

PABREQU

PABREQU_APPL_DATE

APPROVAL_DATE Approval Date Date the position requisition was approved. DATE

PABREQU

PABREQU_APPR_DATE

CLOSE_DATE Close Date Date the application for the position is closed. DATE

PABREQU

PABREQU_CLOSE_DATE

FULL_OR_PART_TIME 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 Full Or Part Time Description Employment status description. VARCHAR2(255)

NA

NA

HIRE_DATE Hire Date Projected date of hire for this position. DATE

PABREQU

PABREQU_HIRE_DATE

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

NA

NA

MINIMUM_DEGREE_LEVEL_DESC Minimum Degree Level Description Minimum degree level description. VARCHAR2(255)

NA

NA

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

NA

NA

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

NA

NA

OPEN_DATE Open Date Date the application for the position is opened. DATE

PABREQU

PABREQU_OPEN_DATE

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

PABREQU

PABREQU_POSN

POSTING_DATE Posting Date Date the position is posted. DATE

PABREQU

PABREQU_POST_DATE

PROCESS_GROUP 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 Requisition number of the position. VARCHAR2(63)

PABREQU

PABREQU_REQ_NO

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

PABREQU

PABREQU_REQS_CODE

REQUISITION_STATUS_DESC Requisition Status Description Requisition status description. VARCHAR2(255)

PTRREQS

PTRREQS_DESC

VACANCY_DATE Vacancy Date Date the position vacates. DATE

PABREQU

PABREQU_VACY_DATE



Ver: 9.2