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

Banner Operational Data Store
Reporting View Target: HR_APPLICATION

Description Contains application information for job applicants.
Key & Frequency One row per person per position applied per requisition number.
Recommended Search Columns PERSON_UID, REQUISITION_NUMBER, POSITION_APPLIED_FOR
APPLICATION_DATE

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

PABAPPL

PABAPPL_DATE

APPROVAL_DATE Approval Date Date the position requisition was approved. DATE

PABREQU

PABREQU_APPR_DATE

CERTIFICATION_COUNT Certification Count Count of applicant certifications. NUMBER

FUNCTION

MPKFUNC.F_COUNT_CERTIFICATION

CONTRACT_GROUP Contract Group Specifies the EEO Contract Group to which the employees in this employee class belong. Used for EEO reporting. VARCHAR2(63)

PTRECLS

PTRECLS_EEOG_CODE

CONTRACT_GROUP_DESC Contract Group Description Contract group description. VARCHAR2(255)

PTVEEOG

PTVEEOG_DESC

DESIRED_HOURLY Desired Hourly Hourly rate applicant desires. NUMBER

PABAPPL

PABAPPL_DESIRED_HOURLY

DESIRED_SALARY Desired Salary Annual salary applicant desires. NUMBER

PABAPPL

PABAPPL_DESIRED_SALARY

EMPLOYEE_CLASS Employee Class Employee class code. Organizes position information consistent with employee groupings. At the employee level, used to help determine controls for benefits, leave, payroll and self-service rules. VARCHAR2(63)

NBBPOSN

NBBPOSN_ECLS_CODE

EMPLOYEE_CLASS_LONG_DESC Employee Class Long Description Employee class long description. VARCHAR2(255)

PTRECLS

PTRECLS_LONG_DESC

EMPLOYEE_CLASS_SHORT_DESC Employee Class Short Description Employee class short description. VARCHAR2(255)

PTRECLS

PTRECLS_SHORT_DESC

EMPLOYEE_SKILL Employee Skill EEO skill code associated with this applicant. VARCHAR2(63)

PABAPPL

PABAPPL_ESKL_CODE

EMPLOYEE_SKILL_DESC Employee Skill Description EEO skill code description. VARCHAR2(255)

PTVESKL

PTVESKL_DESC

EMPLOYMENT_HISTORY_COUNT Employment History Count Employment count. NUMBER

FUNCTION

MPKFUNC.F_COUNT_PAST_EMPL

FULLTIME_PARTTIME_IND Fulltime Parttime Indicator Indicates whether the applicant wishes to work part time of full-time. VARCHAR2(1)

PABAPPL

PABAPPL_FULL_PART_IND

HR_APPLICATION_STATUS_COUNT Hr Application Status Count Count of HR applicant statuses. NUMBER

FUNCTION

MPKFUNC.F_COUNT_HR_APPL_STAT

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INTERVIEW_COUNT Interview Count Count of the number of people interviewing this applicant. NUMBER

FUNCTION

MPKFUNC.F_COUNT_INTERVIEW

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

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PAID_RELOCATION_IND Paid Relocation Indicator Indicates if relocation assistance is available. VARCHAR2(1)

PABREQU

PABREQU_RELOC_IND

PERSON_UID Person UID System generated, unique, internal identification number assigned to this person. NUMBER

PABAPPL

PABAPPL_PIDM

POSITION_APPLIED_FOR Position Applied For Position number associated with the requisition to which this applicant has applied. VARCHAR2(6)

PABAPPL

PABAPPL_POSN

POSITION_APPLIED_FOR_TITLE Position Applied For Title Title or description of a position to which a candidate has applied. VARCHAR2(255)

NBBPOSN

NBBPOSN_TITLE

POSITION_CLASS Position Class Position class associated with this applicant entry. VARCHAR2(63)

PABAPPL

PABAPPL_PCLS_CODE

POSITION_CLASS_DESC Position Class Description Position class description or title. Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position. VARCHAR2(255)

NTRPCLS

NTRPCLS_DESC

POSITION_CLOSE_DATE Position Close Date Date the application for the position is closed. DATE

PABREQU

PABREQU_CLOSE_DATE

POSITION_HIRE_DATE Position Hire Date Projected date of hire for this position. DATE

PABREQU

PABREQU_HIRE_DATE

POSITION_OPEN_DATE Position Open Date Date the application for the position is opened. DATE

PABREQU

PABREQU_OPEN_DATE

POSITION_POSTING_DATE Position Posting Date Date the position is posted. DATE

PABREQU

PABREQU_POST_DATE

POSITION_VACANCY_DATE Position Vacancy Date Date the position is vacated. DATE

PABREQU

PABREQU_VACY_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

REFERENCE_COUNT Reference Count Count of the references given for this HR application by this person. NUMBER

FUNCTION

MPKFUNC.F_COUNT_REFERENCE

REQUISITION_NUMBER Requisition Number Requisition number to which the applicant has applied. VARCHAR2(10)

PABAPPL

PABAPPL_REQ_NO

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

PABREQU

PABREQU_REQS_CODE

SKILL_COUNT Skill Count Count of applicant skills. NUMBER

FUNCTION

MPKFUNC.F_COUNT_SKILL

SOURCE Source Source where applicant found out about job opening. VARCHAR2(63)

PABAPPL

PABAPPL_ASRC_CODE

SOURCE_DESC Source Description Job opening source description. VARCHAR2(255)

PTVASRC

PTVASRC_DESC

STATUS_DISPOSITION Status Disposition Status disposition. VARCHAR2(63)

FUNCTION

F_DISPOSITION_IND

STATUS_DISPOSITION_DESC Status Disposition Description Deciphers applicant status disposition as hired, under consideration, no longer under consideration. VARCHAR2(255)

CALCULATION

DECODE(F_DISPOSITION_IND,'H','HIRED','N','NO LONGER CONSIDERED','U','UNDER CONSIDERATION')

TITLE Title Position title. VARCHAR2(255)

NBBPOSN

NBBPOSN_TITLE



Ver: 9.2