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 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 | | |