Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST


Human Resources Reporting View Meta Data Reports

Target Reports:

Reporting ViewDescriptionKey & FrequencyRecommended Search Columns
BARGAINING_UNIT
Contains bargaining unit information related to an employee.One row per person per bargaining unit per effective date.PERSON_UID
BARGAINING_UNIT, RELATIONSHIP_STATUS
BARG_UNIT_SLOT
Uses data from the BARG_UNIT reporting view. Displays up to 3 sets of values based on the defined display rule(s) with an internal group of BARGAINING UNIT and a delivered or institution defined internal code. Delivered internal codes of PAYRBARG may be used independently by the institution.One row per person per profile code per bargaining unit rule.PERSON_UID, PROFILE_CODE, BARG_UNIT_RULE
ACTIVITY_DATE
BENEFICIARY_DEPENDENT
Contains employee beneficiary information.One row per person per beneficiary per sequence number per relationship.PERSON_UID
BENEFICIARY_SLOT
Uses data from the BENEFICIARY_DEPENDENT view, displays up to five sets of values pertaining to beneficiaries.One row per person per carrier.PERSON_UID, CARRIER
ACTIVITY_DATE
BENEFIT_DEDUCTION
Contains employee benefit deduction detail.One row per person per carrier per effective date.PERSON_UID, CARRIER, EFFECTIVE_DATE
CARRIER, STATUS
PERSON_UID, PAYROLL_DEDUCTION_YEAR, CARRIER
PAYROLL_DEDUCTION_YEAR
EMPLOYEE
Contains employee data for employees who have a current (not terminated) primary position type assignment recorded. Data for the primary assignment will include current salary, supervisor and leave details combining data from the Banner tables that store overridden data first and then position control data when no data is available.One row per person per primary position.PERSON_UID
HOME_ORGANIZATION_CHART, HOME_ORGANIZATION, PERSON_UID
CURRENT_HIRE_DATE
PERSON_UID, POSITION, JOB_SUFFIX, EFFECTIVE_DATE
POSITION, JOB_SUFFIX
POSITION_STATUS
REVIEW_TYPE
SUPERVISOR_UID
EMPLOYEE_EARNING_CY
Contains earnings information for the employee for the calendar year..One row per person per position per job suffix per calendar year per earnings.PERSON_UID, CALENDAR_YEAR, EMPLOYER, POSITION, SUFFIX, EARNINGS, MONTH
CALENDAR_YEAR, EARNINGS
EMPLOYEE_EARNING_FY
Contains earnings information for the employee for the fiscal year.One row per person per position per job suffix per employer per fiscal year per quarter per month per earnings.PERSON_UID, FISCAL_YEAR, EMPLOYER, POSITION, SUFFIX, EARNINGS, MONTH
CHART_OF_ACCOUNTS, FISCAL_YEAR
EMPLOYEE_POSITION
Contains assignment details for an employee's current and historical positions including salary, leave and supervisor details. Selecting person specific data and when not available position control data for the assignment. Note this reporting view will display both active and inactive employee assignments from the Assignment Repeating Table.One row per person per position per job suffix per effective date.PERSON_UID
PERSON_UID,POSITION,JOB_SUFFIX,EFFECTIVE_DATE
TIMESHEET_ORGANIZATION,POSITION,JOB_SUFFIX
PAY_CODE,POSITION,JOB_SUFFIX
POSITION
POSITION_STATUS
ASSIGNMENT_SALARY_GROUP
SUPERVISOR_UID
EMPL_EARN_CY_SLOT
Uses data from the EMPL_EARN_CY reporting view. Displays up to 8 sets of values based on the defined display rule(s) with an internal group of EARNING and a delivered or institution defined internal code. Delivered internal codes of PAYREARN may be used independently by the institution.One row per entity per profile code per calendar year per earning_rule.PERSON_UID,PROFILE_CODE,CALENDAR_YEAR,EARNING_RULE
ACTIVITY_DATE
FACULTY_APPOINTMENT_HISTORY
Provides historical information about faculty appointments.One row per person per action date.PERSON_UID, APPOINTMENT_ACTION_DATE
FACULTY_RANK_HISTORY
Provides historical information about faculty rankings.One row per person per action date.PERSON_UID, RANK_ACTION_DATE
FACULTY_SABBATICAL_HISTORY
Provides historical information about faculty sabbaticals.One row per person per action date.PERSON_UID, SABBATICAL_ACTION_DATE
FACULTY_TRACKING
Faculty Tracking contains a snapshot view of general faculty information combined with the most recent (if any) appointment, rank and sabbatical information.One row per person.PERSON_UID, APPOINTMENT_ACTION_DATE
PERSON_UID, RANK_ACTION_DATE
PERSON_UID, SABBATICAL_ACTION_DATE
FAMILY_MEDICAL_LEAVE_HISTORY
Provide detail information on each earnings code for persons with family medical leave. This detail will include the family medical leave reason, whether and when documentation has been received related person.one per person per family medical leave per earningsPERSON_UID, FMLA_BASE_ID, FMLA_USAGE_ID, FMLA_EARNING_ID
FMLA_BASE_ID
PERSON_UID, FMLA_YEAR
FMLA_BASE_ID, FMLA_USAGE_ID
FMLA_BASE_ID, FMLA_USAGE_ID, FMLA_BEGIN_DATE
FMLA_BASE_ID, FMLA_EARNING_ID, FMLA_BEGIN_DATE
FMLA_LEAVE_COMMENT
Contains text lines associated with the family medical leave base record for the employee.One row per person per family medical leave per commentPERSON_UID, FMLA_BASE_ID, FMLA_USAGE_ID, FMLA_COMMENT_ID
HR_APPLICATION
Contains application information for job applicants.One row per person per position applied per requisition number.PERSON_UID, REQUISITION_NUMBER, POSITION_APPLIED_FOR
APPLICATION_DATE
HR_APPLICATION_STATUS
Contains status for employment applications.One row per person per requisition number per sequence number per status per position applied for.PERSON_UID
STATUS, STATUS_DATE
HR_APPL_STAT_SLOT
Uses data from the HR_APPLICATION_STATUS view, displays up to 5 application status codes assigned to a requisition in order of descending status date.One row per person per requisition number.PERSON_UID, REQUISITION_NUMBER
ACTIVITY_DATE
HR_REQUISITION
Contains detailed information related to recruiting requisitions.One row per position per requisition number.REQUISITION_NUMBER, POSITION
REQUISITION_STATUS
INTERVIEW
Contains information pertaining to the scheduling and result of an interview for a position.One row per person per requisition number per interviewer per interview date per position applied for.PERSON_UID
INTERVIEW_SLOT
Uses data from the INTERVIEW view, displays up to 4 interviews assigned to a requisition in order of ascending interview time/date.One row per person per requisition number.PERSON_UID, REQUISITION_NUMBER
ACTIVITY_DATE
LABOR_COST_DISTRIBUTION
Contains all labor distribution information pertaining to an employee's positions.One row per person per position per job suffix per effective date.PERSON_UID, POSITION, JOB_SUFFIX
POSITION, JOB_SUFFIX
LEAVE_ACCRUAL
Contains leave accrual information specific to each payroll.One row per payroll identifier per calendar year per payroll number per leave per person or one row per payroll identifier per calendar year per payroll number per leave per position (depending on whether the value in mpt_leave_accrual_position_accrual_indicator = N or Y)CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, PERSON_UID
LEAVE_BALANCE
Contains leave balance information for the employee.One row per person per leave.PERSON_UID
LEAVE
LEAVE_BALANCE_SLOT
Uses data from the LEAVE_BALANCE reporting view. Displays up to 5 sets of values based on the defined display rule(s) with an internal group of LEAVE and a delivered or institution defined internal code. Delivered internal codes of PAYRLEAV may be used independently by the institution.One row per person per profile code per leave balance rule.PERSON_UID, PROFILE_CODE, LEAVE_BALANCE_RULE
ACTIVITY_DATE
MONTHLY_DEDUCTION
Contains monthly details regarding all employee deductions.One row per person per employer per payroll deduction month per payroll deduction year per carrier.PERSON_UID, PAYROLL_DEDUCTION_YEAR, CARRIER, PAYROLL_DEDUCTION_MONTH
PERSON_UID, PAYROLL_DEDUCTION_YEAR, EMPLOYER, CARRIER, PAYROLL_DEDUCTION_MONTH
PAYROLL_DEDUCTION_YEAR, PAYROLL_DEDUCTION_MONTH
MONTHLY_DEDUCT_SLOT
Uses data from the MONTHLY_DEDUCTION view, displays 12 months of employee and employer deductions from payroll and summarizes those amounts by quarter.One row per person per payroll deduction year per carrier.PERSON_UID, PAYROLL_DEDUCTION_YEAR, CARRIER
ACTIVITY_DATE
PAYROLL_ATTENDANCE
Contains attendance information pertaining to specific pay periods.One row per calendar year per payroll identifier per payroll number per person per position per suffix per effective date per earnings per attendance dateCALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, PERSON_UID, POSITION, JOB_SUFFIX, POSITION_BEGIN_DATE
PAYROLL_DEDUCTION
Contains payroll deduction information specific to each payroll.One row per payroll identifier per calendar year per payroll number per event sequence number per deduction per person.CALENDAR_YEAR,PAYROLL_IDENTIFIER,PAYROLL_NUMBER,EVENT_SEQUENCE_NUMBER,PERSON_UID
PERSON_UID,DEDUCTION
PAYROLL_DISTRIBUTION
Contains organization payroll distribution information specific to each payroll.Multiple rows per payroll identifier per calendar year per payroll number per event sequence number per person per transaction number.PERSON_UID,CARRIER
CARRIER,STATUS
CALENDAR_YEAR,PAYROLL_IDENTIFIER,PAYROLL_NUMBER,EVENT_SEQUENCE_NUMBER,PERSON_UID
CHART_OF_ACCOUNTS,ACCOUNT
CHART_OF_ACCOUNTS,ORGANIZATION_CODE
CHART_OF_ACCOUNTS,FUND
PERSON_UID,TAX_DEDUCTION
CATEGORY,TRANSACTION_DATE
POSITION
TAX_DEDUCTION,STATUS
CHART_OF_ACCOUNTS,PROGRAM
HOME_ORGANIZATION_CHART,HOME_ORGANIZATION,PERSON_UID
PERSON_UID,POSITION,JOB_SUFFIX
POSITION,JOB_SUFFIX
CHART_OF_ACCOUNTS,LOCATION
PAYROLL_DOCUMENT
Contains payroll document (check and direct deposit) information specific to each payroll.One row per payroll identifier per calendar year per payroll number per event sequence number per person. (In cases where a direct deposit is split amongst two or more accounts, a unique row would be created for each bank account number to which pay is deposited).CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, EVENT_SEQUENCE_NUMBER, PERSON_UID
PERSON_UID
PAYROLL_EARNING
Contains earnings information specific to each payroll.One row per payroll identifier per calendar year per payroll number per event sequence number per position per shift per earning per person.CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, EVENT_SEQUENCE_NUMBER, POSITION, JOB_SUFFIX, SHIFT_NUMBER, EARNINGS, PERSON_UID
PERSON_UID
PAYROLL_EMPLOYEE_POSITION
Contains payroll history and related job history information specific to each payroll.One row per payroll identifier per calendar year per payroll number per event sequence number per position per job suffix per shift number per person per position begin date per position end date.CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, PERSON_UID, EVENT_SEQUENCE_NUMBER
PERSON_UID, POSITION, JOB_SUFFIX, CALENDAR_YEAR
PAYROLL_LABOR_DIST_OVERRIDE
Contains labor distribution override information pertaining to specific pay periods.One row per calendar year per payroll identifier per payroll number per system generated indicator per person per event sequence number per position per job suffix per position begin date per earnings per shift number.CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, SYSTEM_GENERATED_IND, PERSON_UID, EVENT_SEQUENCE_NUMBER, POSITION, JOB_SUFFIX, POSITION_BEGIN_DATE
PAYROLL_POSITION_TIMESHEET
Contains payroll history, related job history and timesheet information specific to each payroll.One row per calendar year per payroll identifier per payroll number per system generated indicator per person per event sequence number per position per job suffix per position begin date per earnings per shift number per time entry period begin date.CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, PERSON_UID, EVENT_SEQUENCE_NUMBER
PERSON_UID, POSITION, JOB_SUFFIX, CALENDAR_YEAR
CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, PERSON_UID, POSITION, JOB_SUFFIX, EFFECTIVE_DATE, EARNINGS, EVENT_SEQUENCE_NUMBER
PAYROLL_TIMESHEET
Contains timesheet information pertaining to specific pay periods.One row per calendar year per payroll identifier per payroll number per system generated indicator per person per event sequence number per position per job suffix per position begin date per earnings per shift number per time entry period begin date.CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, PERSON_UID, POSITION, JOB_SUFFIX, EFFECTIVE_DATE, EARNINGS, EVENT_SEQUENCE_NUMBER
PERSONNEL_ACTION
Provides data for the person, transaction number and approval category when a personnel action is entered in the Banner temporary tables. Includes all personnel action header information with current status for applied and pending transactions.One row per person per PAF transaction numberPAF_TRANSACTION_NUMBER
PERSON_UID,PAF_TRANSACTION_NUMBER,PAF_APPROVAL_CATEGORY
PERSONNEL_ACTION_COMMENT
Contains text lines associated with the personnel action transaction number.One row per person per PAF transaction number per PAF comment sequence numberPERSON_UID,PAF_TRANSACTION_NUMBER,PAF_COMMENT_SEQUENCE_NUMBER
PERSONNEL_ACTION_EARNING
Provides the data details for the person, transaction number and approval type when the default earning codes are changed by the personnel action. Includes personnel actions with current status for applied and pending transactions.One row per person per PAF transaction number per approval type per position per suffix per earning code per effective date.PAF_TRANSACTION_NUMBER
PERSON_UID,PAF_TRANSACTION_NUMBER
PERSON_UID,PAF_TRANSACTION_NUMBER,POSITION,JOB_SUFFIX,EARNINGS
PERSONNEL_ACTION_GENERAL
Provides data for the person, transaction number and approval type when the change are to either the employee, biographical and/or job related records associated with personnel action. Includes personnel actions with current status for applied and pending transactions.One row per person per PAF transaction number per approval type per apply column.PAF_TRANSACTION_NUMBER
PERSON_UID,PAF_TRANSACTION_NUMBER
PERSON_UID,PAF_TRANSACTION_NUMBER,PAF_APPROVAL_TYPE,PAF_APPLY_COLUMN
PERSONNEL_ACTION_LABOR_DIST
Provides the data details for the person, transaction number and approval type when the labor distribution(s) are changed by the personnel action. Includes personnel actions with current status for applied and pending transactions. One row per person per PAF transaction number per approval type per position per suffix per labor distributionPAF_TRANSACTION_NUMBER
PERSON_UID,PAF_TRANSACTION_NUMBER
PERSON_UID,PAF_TRANSACTION_NUMBER,POSITION,JOB_SUFFIX
POSITION_BUDGET
Contains information pertaining to the funding of the position.One row per position per fiscal year per budgeted organization per budget per budget phase per effective date.FISCAL_YEAR, CHART_OF_ACCOUNTS
POSITION, FISCAL_YEAR, BUDGET, BUDGET_PHASE
POSITION, FISCAL_YEAR, BUDGETED_ORGANIZATION, BUDGET, BUDGET_PHASE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
POSITION_DEFINITION
Contains detailed information concerning available positions.One row per position.POSITION
POSITION_LABOR_DISTRIBUTION
Contains labor distribution information for the position.One row per position per labor distribution per fiscal year.POSITION, FISCAL_YEAR, BUDGET, BUDGET_PHASE
POSN_LABOR_DIST_SLOT
Uses data from the POSITION_LABOR_DISTRIBUTION view, displays up to ten sets of values pertaining to ledger accounts.One row per position per fiscal year.POSITION, BUDGET, BUDGET_PHASE, FISCAL_YEAR
ACTIVITY_DATE
REFERENCE
Contains contact information and related comments for the reference.One row per person per name.PERSON_UID
REFERENCE_SLOT
Uses data from the REFERENCE view, displays contact information for 3 references.One row per person.PERSON_UID
ACTIVITY_DATE
REVIEW
Contains information concerning employee performance reviews.One row per person per review type per review date.PERSON_UID
REVIEW_SLOT
Uses data from the REVIEW view, displays up to three sets of values pertaining to employee performance reviews.One row per person.PERSON_UID
ACTIVITY_DATE
TAX
Contains detailed employee tax information.One row per person per tax deduction per effective date.PERSON_UID
PERSON_UID, TAX_DEDUCTION, EFFECTIVE_DATE
YEARLY_DEDUCTION
Contains summarized payroll deduction information for each quarter and year-to-date (YTD).One row per person per year per carrier.PERSON_UID, PAYROLL_DEDUCTION_YEAR, CARRIER

Source Reports:

CALCULATION
FUNCTION
NA
NBBFISC
NBBPOSN
NBRBJOB
NBRCLSH
NBRJFTE
NBRJLBD
NBRJOBS
NBRPLBD
NBRPTOT
NHRDIST
NOBTRAN
NORCMNT
NORTBLD
NORTERN
NORTLBD
NORTRAN
NTRPCLS
NTRSALB
NTRSGRP
NTVACAT
NTVAPTY
NTVDOTT
NTVJOBP
NTVPFOC
NTVWKSH
PABAPPL
PABREQU
PARAPIN
PARAPST
PARPDEG
PDRBCOV
PDRBDED
PDRBENE
PDRDEDN
PEBEMPL
PERAPPT
PERBARG
PERBFAC
PERBFML
PERCFML
PERDTOT
PEREFML
PERFMLA
PERJLEV
PERJTOT
PERLEAV
PERRANK
PERREVW
PERSABB
PHRACCR
PHRATND
PHRDEDN
PHRDOCM
PHREARN
PHRELBD
PHRHIST
PHRHOUR
PHRJACR
PHRJOBS
PPRCERT
PPREXPE
PPRREFE
PPRSKIL
PTRBCAT
PTRBDCA
PTRBDPL
PTRBREL
PTRCALN
PTRDFPR
PTREARN
PTRECLS
PTREMPR
PTRESOC
PTRFTYP
PTRJBLN
PTRJCRE
PTRLREA
PTRPGRP
PTRPICT
PTRRANK
PTRREQS
PTRSHFT
PTRTENR
PTRTREA
PTRWKPR
PTVASRC
PTVASSN
PTVBARG
PTVDISP
PTVECIP
PTVEEOG
PTVEFUN
PTVEGRP
PTVESKL
PTVFMST
PTVFREA
PTVLCAT
PTVLGCD
PTVNRSI
PTVORGN
PTVPCAT
PTVREVT
PTVSBTY
PTVSHCD
PTVSTGR
PTVWKCP
PXRFSTA


Ver: 9.1