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


Human Resources Composite View Meta Data Reports

Target Reports:

Composite ViewDescription
AN_EMPLOYEE_POSITION
Source composite view contains data on each position or assignment held by the employee.
AN_FISCAL_YEAR
Source composite view contains all fiscal years that have current data.
AN_JOB_FTE_TRACKING
Source composite view contains job related full-time equivalency (FTE) information for an employee within a position.
AN_LABOR_COST_DISTRIBUTION
Source composite view contains the accounting details for the labor distribution associated with an employee in a position or assignment.
AN_PAYROLL_DISTRIBUTION
Contains organization payroll distribution information specific to each payroll.
AN_POSITION_BUDGET
Source composite view contains budget funding information for specific positions.
AN_POSITION_DEFINITION
Source composite view contains details associated with a position whether posted or filled.
AN_POSITION_LABOR_DISTRIBUTION
Source composite view contains the accounting details for the labor distribution associated with a position.
AN_SALARY_RATE
Source composite view contains salary table information for specified salary groups.
AN_SUPERVISOR
Provides information about employees' supervisors.
AN_VALIDATION
Source composite view contains a number of the source systems' validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse.
AP_BARGAINING_UNIT
Source composite view contains bargaining unit information relating to an employee.
AP_BENEFICIARY_DEPENDENT
Source composite view contains beneficiary and benefit information for an employee.
AP_BENEFIT_DEDUCTION
Source composite view contains benefit and deduction information for an employee. Data includes information on benefits and deductions, coverage options and begin and end dates. The view returns one row per person per benefit.
AP_CERTIFICATION
Source composite view contains certification information relating to an employee.
AP_EARNING_TOTALS_CY
Source composite view contains earnings total information relating to an employee for a calendar year.
AP_EARNING_TOTALS_FY
Source composite view contains earnings total information relating to an employee for a fiscal year.
AP_EMPLOYEE
Source composite view contains basic information pertaining to employees. Data includes status, employee class, home organization, leave and benefits categories, etc. The view returns one row per person.
AP_EMPLOYEE_EARNING_CY
Source composite view contains pay earnings and hours information for an employee by calendar year.
AP_EMPLOYEE_EARNING_FY
Source composite view contains pay earnings and hours information for an employee by fiscal year.
AP_FACULTY_APPOINTMENT_HISTORY
Provides historical information about faculty appointments.
AP_FACULTY_RANK_HISTORY
Provides historical information about faculty rankings.
AP_FACULTY_SABBATICAL_HISTORY
Provides historical information about faculty sabbaticals.One row per person per action date.
AP_HR_APPLICATION
Source composite view contains application information for persons that are applying for a position at the institution. Data includes information pertaining to requisition number, position, class, application date, skill, source, etc. The view returns one row per position applied for.
AP_HR_APPLICATION_STATUS
Source composite view contains status information for applicants.
AP_HR_REQUISITION
Source composite view contains information pertaining to an HR Requisition.
AP_INTERVIEW
Source composite view contains application interview information for persons that are applying for a position at the institution.
AP_LEAVE_ACCRUAL
Contains leave accrual information specific to each payroll.
AP_LEAVE_BALANCE
Source composite view contains leave balance information relating to an employee.
AP_MONTHLY_DEDUCTION
Source composite view contains deduction information relating to an employee.
AP_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
AP_PAYROLL_DEDUCTION
Contains payroll deduction information specific to each payroll.
AP_PAYROLL_DOCUMENT
Contains payroll document (check and direct deposit) information specific to each payroll.
AP_PAYROLL_EARNING
Contains earnings information specific to each payroll.
AP_PAYROLL_EMPLOYEE_POSITION
Contains payroll history and related job history information specific to each payroll.
AP_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.
AP_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.
AP_REFERENCE
Source composite view contains references information for an employee or person applying for a position at the institution.
AP_REVIEW
Source composite view contains information pertaining to employee performance reviews.
AP_TAX
Source composite view contains tax deduction information for an employee. Data includes information pertaining to the tax deduction, deduction amounts, Canadian deduction amounts, filing status, exemptions and deduction options.
AP_VALIDATION
Source composite view contains a number of the source systems' validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse.
AP_YEARLY_DEDUCTION
Contains summarized payroll deduction information for each quarter and year-to-date (YTD).

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