| Reporting View | Description | Key & Frequency | Recommended 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 | | |