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
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.ACTIVITY_DATE
PERSON_UID, PROFILE_CODE, BARG_UNIT_RULE
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, PAYROLL_DEDUCTION_YEAR, CARRIER
PERSON_UID, CARRIER, EFFECTIVE_DATE
EMPLOYEE
Contains current employee data.One row per person.PERSON_UID
HOME_ORGANIZATION_CHART, HOME_ORGANIZATION, PERSON_UID
CURRENT_HIRE_DATE
PERSON_UID, POSITION, JOB_SUFFIX, EFFECTIVE_DATE
POSITION, JOB_SUFFIX
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
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
EMPLOYEE_POSITION
Contains assignment details for an employee's current and historical positions.One row per person per position per job suffix per effective date.PERSON_UID,POSITION,SUFFIX
SALARY_GROUP
PERSON_UID,POSITION,JOB_SUFFIX,EFFECTIVE_DATE
TIMESHEET_ORGANIZATION,POSITION,JOB_SUFFIX
PAY_CODE,POSITION,JOB_SUFFIX
POSITION
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 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 informationOne row per person.PERSON_UID, APPOINTMENT_ACTION_DATE
PERSON_UID, RANK_ACTION_DATE
PERSON_UID, SABBATICAL_ACTION_DATE
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
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
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
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
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
PERSON_UID
LEAVE_BALANCE
Contains leave balance information for the employee.One row per person per leave.PERSON_UID
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
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 specic 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 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.One row per payroll identifier per calendar year per payroll number per event sequence number per person per transaction number.CHART_OF_ACCOUNTS, ACCOUNT
CHART_OF_ACCOUNTS, FUND
CHART_OF_ACCOUNTS, LOCATION
CHART_OF_ACCOUNTS, ORGANIZATION_CODE
CHART_OF_ACCOUNTS, PROGRAM
PERSON_UID
HOME_ORGANIZATION_CHART, HOME_ORGANIZATION, PERSON_UID
PERSON_UID, POSITION, JOB_SUFFIX
POSITION, JOB_SUFFIX
PERSON_UID, CARRIER
CATEGORY, TRANSACTION_DATE
CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, EVENT_SEQUENCE_NUMBER, PERSON_UID
PERSON_UID, TAX_DEDUCTION
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 depositied).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.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 specic 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.
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.
PAYROLL_TIMESHEET
Contains timesheet information pertaining to specic 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.
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:

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


Ver: 8.0