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 Definition Database Data Type Source Name Source Column Local Source Local Target
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

NO

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

NA

NA

NO

NO
APPLICATION_DATE Application submission date. DATE

PABREQU

PABREQU_APPL_DATE

NO

NO
APPROVAL_DATE Date the position requisition was approved. DATE

PABREQU

PABREQU_APPR_DATE

NO

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

PABREQU

PABREQU_CLOSE_DATE

NO

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

NA

NA

NO

NO
FULL_OR_PART_TIME_DESC Employment status description. VARCHAR2(255)

NA

NA

NO

NO
HIRE_DATE Projected date of hire for this position. DATE

PABREQU

PABREQU_HIRE_DATE

NO

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

NA

NA

NO

NO
MINIMUM_DEGREE_LEVEL_DESC Minimum degree level description. VARCHAR2(255)

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

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

PABREQU

PABREQU_OPEN_DATE

NO

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

PABREQU

PABREQU_POSN

NO

NO
POSTING_DATE Date the position is posted. DATE

PABREQU

PABREQU_POST_DATE

NO

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

NA

NA

NO

NO
REQUISITION_NUMBER Requisition number of the position. VARCHAR2(63)

PABREQU

PABREQU_REQ_NO

NO

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

PABREQU

PABREQU_REQS_CODE

NO

NO
REQUISITION_STATUS_DESC Requisition status description. VARCHAR2(255)

PTRREQS

PTRREQS_DESC

NO

NO
VACANCY_DATE Date the position vacates. DATE

PABREQU

PABREQU_VACY_DATE

NO

NO


Ver: 9.2