RETURN TO 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
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
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
AP_FACULTY_RANK_HISTORY
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
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_DEDUCTION
AP_PAYROLL_EMPLOYEE_POSITION
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.

Source Reports:

NBBFISC
NBBPOSN
NBRBJOB
NBRCLSH
NBRJFTE
NBRJLBD
NBRJOBS
NBRPLBD
NBRPTOT
NHRDIST
NTRPCLS
NTRSALB
PABAPPL
PABREQU
PARAPIN
PARAPST
PARPDEG
PDRBCOV
PDRBDED
PDRBENE
PDRDEDN
PEBEMPL
PEBFACD
PERAPPT
PERBARG
PERBFAC
PERDTOT
PERJLEV
PERJTOT
PERLEAV
PERRANK
PERREVW
PERSABB
PHRACCR
PHRDEDN
PHRDOCM
PHREARN
PHRHIST
PHRJACR
PHRJOBS
PPRCERT
PPREXPE
PPRREFE
PPRSKIL
PTRBDCA
PTRBDPL
PTRCALN
PTREARN
PTRECLS
PTRFTYP
PTRLREA
PTRRANK
PTRREQS
PTRSHFT
PTRTENR
PTVDISP
PTVESKL
PTVORGN
PTVREVT
PTVSBTY
PXRFSTA


Ver: 3.1