Go To View:  RETURN TO BANNER ODS META DATA 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
REQUISITION_STATUS

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACCEPTING_APPLICANTS_IND Indicates whether applicants may be added or no new applicants can be added to the requisition.    

PTRREQS

PTRREQS_ACCEPT_APPL_IND

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

NA

NA

 
APPLICATION_DATE Application submission date.    

PABREQU

PABREQU_APPL_DATE

 
APPROVAL_DATE Date the position requisition was approved.    

PABREQU

PABREQU_APPR_DATE

 
CLOSE_DATE Date the application for the position is closed.    

PABREQU

PABREQU_CLOSE_DATE

 
FULL_OR_PART_TIME Identifies if the requisition is for a full-time or part-time employment.    

NA

NA

 
FULL_OR_PART_TIME_DESC Employment status description.    

NA

NA

 
HIRE_DATE Projected date of hire for this position.    

PABREQU

PABREQU_HIRE_DATE

 
MINIMUM_DEGREE_LEVEL Minimum degree level required by the requisition.    

NA

NA

 
MINIMUM_DEGREE_LEVEL_DESC Minimum degree level description.    

NA

NA

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

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
OPEN_DATE Date the application for the position is opened.    

PABREQU

PABREQU_OPEN_DATE

 
POSITION Position number associated with this requisition.    

PABREQU

PABREQU_POSN

 
POSTING_DATE Date the position is posted.    

PABREQU

PABREQU_POST_DATE

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

NA

NA

 
REQUISITION_NUMBER Requisition number of the position.    

PABREQU

PABREQU_REQ_NO

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

PABREQU

PABREQU_REQS_CODE

 
REQUISITION_STATUS_DESC Requisition status description.    

PTRREQS

PTRREQS_DESC

 
VACANCY_DATE Date the position vacates.    

PABREQU

PABREQU_VACY_DATE

 


Ver: 8.3