Available Reports in the Business Intelligence System

(1)

Number Subject Area Audience Report Title Description Report Prompts Report Folder Location Role(s) with Access FIN025 Accounts Payable Central Conflict of Interest-FIN025

Comparison report of vendor information with MSU employee information

Can Select by Employee/Vendor Type including by Tax ID/SSN, address, name, and exact match.

Public Folders > Finance Folder > Central Finance Reports > AP -

Accounts Payable BI-FIN-AP-Central

FIN027

Accounts

Payable Central

Non-MSU Leases and Rental-FIN027

Lists non-MSU leases or rentals which are located in the Corporate Limits of the City of East Lansing

Delivery Campus Code, Delivery City Name, Delivery State, Item Type, PO Status Code, Object Code, PO Current Indicator

FIN031

Accounts

Payable University

Payment History by Line

Item-FIN031 Payment history by purchase order line item

Purchase Order Number, Filter for Purchase Orders that Are current

Public Folders > Finance Folder > University Finance Reports > AP -

Accounts Payable BI-FIN-AP-University

FIN033

Accounts

Payable Central

Check Register

Summary-FIN033 Check register for each check run

Beginning Check Date, Ending Check Date, Batch ID

FIN034

Accounts

Payable Central

Credit Memo Aging Report-FIN034

Pending credit memos by days over the due

date and current status Credit Memo Processor Name

FIN036

Accounts

Payable Central

Disbursement Voucher Payments-FIN036

Disbursement voucher payments by vendor type

The Beginning Date and Ending Date range for Disbursement Vouchers Paid by Vendor Type

FIN037

Accounts

Payable Central

AP Match Report-FIN037

Comparison report used to verify data from paper invoices, credit memos and stores checkin documents entered into KFS

Starting Date and Ending Date Range for the time period that invoices were entered into the system, Invoice Initiator, Document status

FIN038

Accounts

Payable Central MACHA Report-FIN038

Consolidated report of direct deposits (ACH payments) for a given date range

Starting Date and Ending Date range for direct deposits (ACH Payments) , Distribution Type Code

(2)

FIN039

Accounts

Payable Central

PREQ Status Exception Report-FIN039

Invoices excluded from extraction to the PDP by the Auto Approve Exclude and the Negative Payment Request Approval maintenance documents

There is no Prompt Page. However, these items are passed: Payment Extracted Date, Payment Status Code, Item Type Code

FIN040

Accounts

Payable Central

PREQ Status Report-FIN040

Invoices showing Vendor information, due dates, net dollar amounts that are available

for extraction Initiator ID and Name

FIN041

Accounts

Payable Central

Invoice Reject

Report-FIN041 List of rejected invoices

Begin Date and End Date of Processed Invoices to find rejected invoices, Processor ID and Name

FIN042

Accounts

Payable Central

Auditor Transaction Activity-FIN042

Measures the AP metrics associated with Auditors, such as discounts and late payments

Payment Request Starting and Stop Dates, Processor Names and IDs

FIN043

Accounts

Payable Central

Check Register Detail-FIN043

All checks written, ordered by check number, for a specified reporting period

Check/Advice Start and Stop Payment Dates for the date range desired.

FIN044

Accounts

Payable University

Payments By Payee-FIN044

Voucher payments by payee name that have been made during a selected time period

Payment Beginning and Ending Dates, Voucher Type, Amount

Paid, Organization, Account, Payee

Public Folders > Finance Folder > University Finance Reports > AP -

Accounts Payable BI-FIN-AP-University

FIN062

Accounts

Payable Central

Invoice Summary by Dollar Range -FIN062

Count of invoices within a dollar range for a specified date range

Date range of payments made starting with a Payment Start Date and a Payment Stop Date, Processor Name

FIN063

Accounts

Payable Central

Invoice Payment Discount-FIN063

Summary of the number of discounted transactions by Pmt Terms Percent.

Payment Range with Payment Start Date and Payment Stop Date for discounts received on payments made

(3)

FIN064

Accounts

Payable Central

Payment Summary by Aging Range-FIN064

Count of invoices by Aging Range for a specified period

Invoices Paid within a specified date range using Payment Range with Payment Start Date and Payment Stop Date

FIN065

Accounts

Payable Central

Disbursement Summary by Dollar Range-FIN065

Count of checks by dollar range for a specified time period

Payment Range with Payment Start Date, Payment Stop Date

FIN084

Accounts

Payable Central

1099 PREQ Wire Transfers-FIN084

Identify all wire transfer and foreign drafts processed on a PREQ for the purposes Date

FIN096

Accounts

Payable University

Disbursement Voucher eDoc Detail-FIN096

This report provides the Disbursement Voucher details such as Disbursement Voucher Initiator, Payment Information, Accounting Lines, Contact Information and Special Handling.

This report will be the target report and is required to displayed, when drilled through from the other other Finance reports such as

Operating Statement-FIN049. Create date, Document Nbr

FIN098

Accounts

Payable Central

1099 DV Person Payments-FIN098

1099 reportable DV payments made to a person through finance system

Date, Object Code, Object Level Code, Object Type Code

FIN099

Accounts

Payable Central

1099 DV Vendor Payments-FIN099

Payments made via check or ACH to a vendor using a DV doc.

FIN100

Accounts

Payable Central

1099 DV Vendor Wire Transfers-FIN100

Payments made to vendors via wire or foreign draft on a DV doc.

(4)

FIN101

Accounts

Payable Central

1099 PREQ Vendor Payments-FIN101

Payments to vendors via check or ACH using PREQ

Accounts Payable Central AP

FIN103

Accounts

Payable Central

Disbursement Voucher eDoc Detail-FIN103

This is the Central AP version of the

Disbursement Voucher eDoc Detail-FIN096 report.

FIN106

Accounts

Payable Central

Vendor Address-Tax Reporting-FIN106

Vendor address for 1099 reporting.

Search for first tax address, if null, use remit to address, if null, use PO address.

Vender header ID, Vendor parent name

FIN108

Accounts

Payable Central

DV Pending Wires Action List-FIN108

Workflow report to list pending

disbursement voucher wires that need to be

paid. None

Finance Folder > Central Finance

Report s> AP - Accounts Payable BI-FIN-AP-Central

FIN109

Accounts

Payable Central

DV Priorities List-FIN109

Workflow report to list pending

disbursement voucher entries of multiple payment type codes that are at a priority status. Data selected from the

KREW_ACTN_ITM_V view.

Responsibility Node, Payment Reason, Document Total Amount limit.

Finance Folder>Central Finance

Reports>AP - Accounts Payable BI-FIN-AP-Central

FIN117 Accounts Payable Central Internal Billing Verification Report-FIN117

Internal Billing Verification Report-FIN117. Interdepartmental charges enroute that need accounting auditor's approval and/or review. Report includes: Doument Header Identifier, Doument Header Title, Initiator Last Name & First Name, MSUEDW Create Date (labeled as 'Date') and a blank notes field for auditor use.

Report prompts on detail report page to sort by 1-Initiator Name or 2-Date and Last Name (prompt is located on report page).

(5)

FIN120

Accounts

Payable Central DI Priorities List-FIN120

DI Priorities List-FIN120. Lists Distribution of Income and Expense charges to be

verified by Accounting Office Auditors. User is prompted for sort order preference (last modified date or Initiator Name) on prompt page. Report Includes: Document Header Identifier, Document Header Title Information, Initiator Last Name & First Name, MSUEDW Create Date (labeled as 'Date' and works as last approved date) and a blank notes field for auditor use.

Report prompts for Auditor node (Central Reviewer or Fiscal Officer), Sort order (MSUEDW Create Date or Initiator Name), Approver's Last Name

FIN122

Accounts

Payable Central

Accounting Ad Hoc Priorities-FIN122

Accounting Ad Hoc Priorities - FIN122. Lists eDocs Ad Hoc'd to accounting auditors. User is prompted for sort order preference (last modified date or Approver Name) on prompt page. Report Includes: Document Header Identifier, Document Header Title, MSUEDW Create Date (labeled as 'Date' and works as last approved date), Approver Last & First Name and MSUNetID, Ad Hoc Routed by MSUNetID, Document Type, Initiator Last Name & First Name, and a blank notes field for auditor use.

Report prompts for Sort order (MSUEDW Create Date

or Accounting Auditor/Approver Name)

(6)

FIN124

Accounts

Payable Central

Accounting Auditor Action Metrics-FIN124

Crosstab report contains action metrics on auditors for a selected time period. Report prompts for date range of actions performed, eDoc types, action types, and accounting auditors to be included in Metric analysis. Totals are calculated for action types and for each auditor.

Crosstab Report Includes crosstab node members: Auditor Full Name & Action Name, count(Action Name) as measure, and Total Actions per Approver, as well as Total for each type of action.

Action Date Range, Doc Types, Action Type, Approver

FIN125

Accounts

Payable Central

Accounting Auditor Action Detail-FIN125

Detail Listing of Accounting Financial Transactions by Date Range, EDoc Type, Action Type, and Approver

Action Date Range, Doc Types, Action type, Approver

AAR001 Admin Asst University

Position Roster by Primary Reports to Organization Prototype - AAR001

Position Roster by Primary Reports to

Organization MAU, Department, Employee type

Public Folders > Administrators

Assistant Folder (Prototype) BI-AAR-University

Individual Profile Report - AAR002

Summary of information as reflected in a number of data base sources including human resources, CLIFMS (link, professional accomplishments, effort distribution), contracts and grants

Person ID (if running as a stand-alone rather than drill-through)

AAR003 Admin Asst Central

Sensitive Roster – AAR003

Position Roster by Primary Reports to Organization including sensitive/restricted information

MAU, Department, Full Name, Employee type, Employee Sub-Group, Sub-Categories

Public Folders > Administrators Assistant Folder

(7)

UNTF Roster by Primary Reports to Organization or by Name Prototype-AAR005

Internal Billing Action List-FIN117. Internal Billing eDocs enroute that need accounting auditor's approval and/or review. Report includes MSUEDW Create Date, Doument Header Title, Doument Header

Identifier, Action Request Annotation Text, Initiator Name, and a blank notes field.

Display only the portion of the Department within a specific MAU, Display the Department within all MAUs it exists, Display org code and org name of one or more orgs, Last Name, First, Name

CLIFMS - Extended Section Link Data-AAR006

Information about courses by person linked to the course in CLIFMS

Employee Category, Term Code, Display only the portion of the Department within a specific MAU, Display the Department within all MAUs it exists, Display org code and org name of one or more orgs

Appointments-Fixed Term-AAR007

Roster of individuals with a fixed term appointment

Employee Type, Assignment End Date, Display only the portion of the Department within a specific

MAU, Display the Department within all MAUs it exists, Display org code and org name of one or more orgs

Probationary Review and Tenure Dates–AAR008

Roster of current employees who are on

probation Employee Type, MAU, Department

Sabbatical Leave Dates–AAR009

Roster of all faculty that shows if they have

had a sabbatical leave since December 2000 MAU, Department, Full Name

AAR010 Admin Asst University Leave History–AAR010

Leave history (since December 2000) for any

current employee MAU, Department, Full Name

(8)

AAR011 Admin Asst University MSU Email–AAR011

MSU Email of current employees (MSU NetID email only)

Employee Type, Job Category, MAU, Department, Organization, Full Name

Current Roster

Salary–AAR012 FTE, FTE Salary, and job title for employees

Employee Type, MAU, Department, Organization, Full Name

CLIFMS Effort –

AAR013 CLIFMS Effort None

CLIFMS - Professional Accomplishments- AAR014

AAR014 provides CLIFMS Professional Accomplishments data for Faculty and Grad Assistants by term None

Public Folders > Administrators Assistant Folder (Prototype)

BGT001 Budget University

Salary Distribution-BGT001

Fiscal Year salary distribution data for active employees

Fiscal Period Begin Date, Organization Code and Name

Public Folders > Budget Folder >

University Budget Reports BI-BGT-University

BGT003 Budget Central

Enterprise Structure Salary Distribution

Enterprise Structure Salary Distribution-BGT003, Enterprise Structure Data for active employees during the fiscal year

encompassing the date entered. Date, Organization

Central Budget Reports BI-BGT-Central

BGT004 Budget Central

Faculty and Academic Staff Raise File Extract

Extract salary information from BI for Cognos Planning, to be loaded into Cognos Planning for faculty and academic staff raise

process. Date, Organization Code

Central Budget Reports BI-BGT-Central

FIN050

Capital Asset

Management University Asset Additions-FIN050

List of asset additions for a specified time period and organization.

Date Range for First and Last Disposal Dates, Organization Code and Name

Public Folders > Finance Folder > University Finance Reports > CAM

(9)

FIN051

Capital Asset

Management University

Asset Retirements-FIN051

All disposed assets for a specified time period

Date Range for Time Period of the Report. The dates reflect the starting and ending date for assets disposed from inventory. Organization Code, Account Number.

- Capital Asset Management BI-FIN-CAM-University

FIN052 Capital Asset Management University Capital Asset Maintenance Changes-FIN052

Asset reclassifications for a given time period.

The Date Range covers a period of time during which assets were put into Inventory but need to be reclassified.

FIN053

Capital Asset

Management Central

KFS Building Report-FIN053

Comparison Report of KFS CAMS building

data and OOI building data Building Code, Building Name

Public Folders > Finance Folder > Central Finance Reports > CAM -

Capital Asset Management BI-FIN-CAM-Central

FIN054

Capital Asset

Asset Cost Adjustments-FIN054

Asset cost adjustments for a given time period

Transaction Start and Stop Date for reconciling Asset Adjustments

FIN055 Capital Asset Management Central Depreciation Expense Accounts Comparison Report-FIN055

Compares Asset Depreciation by Period to the General Ledger Batch Depreciation.

Comparison of Depreciation Expense by Fiscal Year and Fiscal Year Period in the General Ledger to the Asset Register

FIN056

Capital Asset

Management Central

General ledger and Asset Register Balance to Asset Type-FIN056

Compares Asset Register for Asset Value to the Amount in the General Ledger

Beginning and Ending Posting Date to compare the Asset Register to the General Ledger Asset Value

FIN057

Capital Asset

Management Central

Cost CIP Reserve Report-FIN057

Cost detail of CIP assets and totals by asset

type No Prompts are used for this report.

(10)

FIN059

Capital Asset

Management University Asset Inventory-FIN059

All inventoried assets and their statuses within a department by organization

Date Range including start and stop date for the inventory report, Asset Status, Organization Code,

Organization Name

FIN060 Capital Asset Management Central Cost Clearing Reconciliation Report-FIN060

Report of clearing account transaction activity. Report will provide an aging of the transactions as well as detail and summary information for construction in progress (CIP) accounts by organization, account and object code

Posting Start and End Date for controlled Assets Using Type Code 59999

FIN061

Capital Asset

Untagged Asset Aging Report-FIN061

Listing of assets without tag numbers assigned, grouped by number of days since creation

Start Date or Earliest Date and Stop Date or Latest Date of when the Asset was created but not tagged, Asset Status, Organization Code, Organization Name

FIN001

Chart of

Accounts University

KFS Organizational

Hierarchy-FIN001 Hierarchy of organizations within KFS

MAU Responsibility Center, Organization

Public Folders > Finance Folder > University Finance Reports > CA -

Chart of Accounts BI-FIN-CA-University

FIN002

Chart of

Accounts University

Fiscal Officer Account Delegates-FIN002

List of account delegates by account, org code, document type

Mau Responsibility Center,

Organization, Account, Fiscal Officer, Delegate

FIN003

Chart of

Accounts University

Accounts by

Organization-FIN003 List of accounts by organization

Organization Code, Organization Name, Account Number, Account Name

FIN005

Chart of

Accounts Central

Account Maintenance Table Changes-FIN005

Exception report to monitor changes made to the account maintenance tables on a daily basis

A Date Range when documents were created resulting in a Start and Stop Date, Document Type Code

Public Folders > Finance Folder > Central Finance Reports > CA -

(11)

FIN006

Chart of

Accounts University

Sub-Accounts by

Organization-FIN006 List of sub accounts by organization

Organization Code, Organization Name

FIN007

Chart of

Accounts University

Sub-Object Codes by

Organization-FIN007 List of sub object codes by organization

FIN008

Chart of

Accounts University

Project Codes by

Organization-FIN008 List of project codes by organization

FIN071

Chart of

Accounts University Object Code List-FIN071

List of object codes grouped by

consolidation and level code for a given

fiscal year. Fiscal Year

FIN072

Chart of

Accounts University

Subaccounts by Account and Organization-FIN072

Listing of Sub-Accounts by Organization

and Account. Organization Code and Name

FIN073

Chart of

Accounts University

Sub Object Codes Account and

Organization-FIN073

Sub-Object Codes by Account and

Organization. Organization Code and Name

FIN074

Chart of

Accounts University

Project List with

Attributes-FIN074 Listing of Projects with Attributes. No Prompts are used for this report.

FIN081

Chart of

Accounts University

KFS Organizational Hierarchy Reports to Org-FIN081

Hierarchy of organizations within KFS, Reports to Org

Organization Beginning Date Range, Chart Code, Organization Code & Name

FIN012

Contracts and

Grants University

Account Summary – Contract & Grant Accounts-FIN012

Summary of obligated award amount vs expenses for a contract and grant account

Organization Code, Organization Name, Account Number, Account Name

Public Folders > Finance Folder > University Finance Reports > CG -

(12)

FIN068

Contracts and

Grants University

Budget to Actuals Statement – Contract & Grant Accounts-FIN068

Summary of budget, current expenses, expenditures inception to date, open encumbrances and remaining balance for sponsored accounts.

Fiscal Year, Fiscal Year Period, Organization(s), Account(s)

Contracts and Grants BI-FIN-CG-University

FIN094

Contracts and

Grants University

Account Statement with Pending Entries – Contract & Grant Accounts-FIN094

Summary of budget, current expenses, expenditures inception to date, open encumbrances, pending entries and remaining balanceAccount Statement with Pending Entries

Fiscal Year, Fiscal Year Period, Organization(s), Account Status, Account(s), Sub Account(s), Principal Investigator(s), Account Fiscal Officer(s), Report Output, Include Transaction Detail for Fiscal Period

FIN104

Contracts and

Grants University

Budget to Actuals Statement – Contract & Grant Accounts - Fiscal Period Range-FIN104

Summary of budget, current expenses, expenditures inception to date, open encumbrances and remaining balance for sponsored accounts by Fiscal Period Range.

Fiscal Year, Fiscal Year Period, Organization(s), Account(s)

FIN107

Contracts and

Grants University

Account Summary - C & G Accounts - Date Range

This report is a newer version of Account Summary - Contract & Grant Accounts-FIN012, but this report should have a date range prompt to select. Contracts and Grants Account Summary by Transaction Posting Date Range. Any transactions posted between the date range will be captured.

Transaction Posting Date Range, Account Status, Organization Code, Account Number and Principal Investigator.

FIN112

Contracts and

Grants Central

Contract & Grant Accounts by

Organization-FIN112 Listing of Contract and Grant Accounts.

Public Folders > Finance Folder > University Finance Reports > CG - Contracts and Grants

(13)

FIN116

Contracts and

Grants University

Contract & Grant Accounts Activity Statement-FIN116

Detail listing of actual and budget transactions, account budget balance summary, object code summary and open encumbrances by fiscal period.

Fiscal Year, Fiscal Period, Accounting Categories, Account Status, MAU Responsibility Center and

Organization, Accounts, Sub-Accounts, Account Fiscal Officers

FIN009 General Ledger Central Overdraft Report-FIN009 List of overdrawn accounts by fund type Fiscal Year, Chart Code, Fund Group

Public Folders > Finance Folder > University Finance Reports > GL -

General Ledger BI-FIN-GL-University

FIN013 General Ledger Central

Trial Balance Report-FIN013

Report which mirrors the Trial Balance report that comes directly from the Kuali

Financial System Fiscal Year, Chart Code

Public Folders > Finance Folder > Central Finance Reports > GL -

General Ledger BI-FIN-GL-Central

FIN014 General Ledger University

Non Check Disbursement Report-FIN014

Non-check disbursements for a specified time period

Transaction Post Starting and Ending Dates, Organization Code,

Organization Name, Account Number

Internal Credit Card Vendor Maintenance Summary-FIN015

List of internal department's which accept credit card payment with the default income and expense GL string

Campus Vendors Who Accept Credit Cards, (Example: Union Store, Vet Clinic, etc.), Credit Card Type (Example: Visa, MasterCard, etc.)

Encumbrance Activity Report-FIN026

Encumbrance activity by specified organization, account and time period

Beginning and Ending Transaction Posting Dates, Organization Code, Organization Name, Account Number, Account Name, Include Closed Encumbrances?,

(14)

Detail Transaction Report-FIN045

Actual, transfer and budget transactions posted to the general ledger for a given period of time.

Transactions posted to the general ledger by user specified start and end posting dates, Organization, Account. Project Code, Sub Account, Basic Accounting Category

Cash Reconciliation Report-FIN046

Detail listing of cash affecting general ledger transactions, account summaries, and open encumbrances by fiscal period

Fiscal Year, Monthly Accounting Period in the Fiscal Year,

Organization, Account

MAU Account Summary Report-FIN047

Summary of account activity by category (assets, liabilities, revenues, transfers, expenses), budget to actuals and cash balance by fiscal period

Fiscal Year, Monthly Accounting Period, MAU Responsibility Center, Account, Fund Group

Budget Variance Report-FIN048

Budget, actuals, encumbrances, remaining balance, and variance for a specified account & fiscal year

Fiscal Year, Chart Code, Organization Code, Fund Group, Account

Operating Statement-FIN049

Detail listing of actual and budget

transactions, account summaries and open encumbrances by fiscal period.

Fiscal Year, Monthly Fiscal Accounting Period, Organization Codes and Names, Account Numbers and Names

Detail Transaction Extract -FIN067

All transactions with accounting string attributes that have posted to KFS within a user specified date range. Designed to enable end user extract from Cognos BI.

Project Codes, Account Number, Account Name, Organization Code, Organization Name, Beginning and Ending General Ledger Transaction Posting Date, Basic Accounting Category Code, Sub Account

(15)

MAU Account Summary Extract-FIN070

MAU Account Summary Extract-FIN070, Summary extract of account activity by category (assets, liabilities, revenues, transfers, expenses), budget to actuals and cash balance by fiscal period.

Fiscal Year, Fiscal Year Period, MAU Responsibility Center, Account, Fund Group

Budget to Actuals Statement-FIN075

Summary of budget, expenses,

encumbrances, actuals and variance by fiscal period

Fiscal Year, Fiscal Period,

Organization Code & Name, Account Number & Name

MAU Sub Account Summary-FIN087

This is a summary report by sub accounts to display the income and expenses and pending entries.

Fiscal Year, Fiscal Period, MAU Responsibility Center, Account, Sub-Account

Public Folders > Finance Folder > GL - General Ledger > Standard

Reports > MSUEDW Reports BI-FIN-GL-University

Salary Encumbrance Extract-FIN090

Report designed to enable salary

encumbrance information to be exported to Excel so that end users can further slice & dice data according to individual business requirements.

Encumbrance As Of Date Range, Responsibility Center>Organization, Account, Sub-Account, Employee Name

Public Folders > HR-Payroll Folder > University HR-Payroll Reports > PY - Payroll > Labor Distribution

BI-HRP-PY-University- Restricted-Labor-Distribution

Account Balance - FIN091

Report similar to MAU Acct Summary but only would include either the budget or cash balance column based on the sub fund of the account selected. Business purpose: To give users one amount that indicates the balance of a given account.

Fiscal Year, Fiscal Period, MAU Responsibility Center, Account, Organization (on report page)

Project Activity Statement-FIN092

Create a version of FIN049 to summarize, group, total by project codes

Fiscal Year, Fiscal Period, Accounting Category Code, Project Code, MAU Responsibility Center and

Organization Code.

(16)

Open and Closed Encumbrances-FIN095

Open and/or closed encumbrances by specified organization, account and time period, with encumbrance document number.

Transaction Date, Open and Close Encumbrance Status, MAU and Organization, Account

Account Activity Statement-FIN097

Detail listing of actual, budget and pending transactions, account summaries and open encumbrances by Fiscal period.

Finance Document User Approvals-FIN102

List approvals made by MSU NetID for specific Doc Type and Date range. Initially requested by Cashier department which allows them to balance Cash Receipt deposits in KFS against those accepted into OneStep cashiering system. Will be engineering so that it can be used broadly across campus.

Approval Date Range, Doc Types, Approver's Last Name

MAU Account Summary YTD Extract by Use Code-FIN105

Summary extract of year to date account activity by object code, category (assets, liabilities, revenues, transfers, expenses) and use code, including budget balances before encumbrances.

Fiscal Year, Fiscal Period, Account Status, Fund Group, MAU

Responsiblity Center, Account Number

Cash Account Activity Statement-FIN110

Designated and Cash Accounts Detail listing of actual and budget transactions, Account summaries and open encumbrances by fiscal period. This is a customized report for the Cash Accounts.

Organization, Account, Sub-Account, Account Fiscal Officers

Budget Account Activity

Detail listing of actual and budget transactions, account budget balance summary, object code summary and open

Organization, Accounts,

Sub-Public Folders > Finance Folder > University Finance Reports > GL -

(17)

Operating Statement by Sub Account-FIN113

Operating statement with a page break on sub-account.

Fiscal Year, Fiscal Period, Accounting Categories, Account Status, MAU Responsibility Center, Organizations, Accounts, Sub-Accounts, Account Fiscal Officers

Object Code

Summary-FIN114 Object Code Summary.

Operating Statement-Fiscal Period Range-FIN115

Detail listing of actual and budget

transactions, account summaries and open encumbrances by fiscal period range. Operating Statement reports are used for business purpose to track the expenses, income, available balance, cash balance, transaction details and used for audit. This version of the Operating Statement will allow an individual to run the report by a fiscal period range.

Fiscal Year, Period Range, Accounting Categories, Account Status, MAU Responsibility Center, Organizations, Accounts, Sub-Accounts, Account Fiscal Officers

Detail Transaction Extract with Pending Entries-FIN118

Extract listing of all actual and pending transactions to the general ledger by a user specified fiscal year and fiscal period.

Fiscal Year, Fiscal Period, MAU and Organization, Organization, Account, Sub-Account, Project, Fiscal Officer, Principal Investigator

Auto Non Check Disbursement Report-FIN121

The Auto Non Check Disbursement Report is a scheduled report that lists non check disbursement transactions for the previous day's business. This report is modeled after FIN014- Non Check Disbursement Report, but omits the prompt page and defaults to the previous business day. None

(18)

FIN085

Materials

Stores Billing

Statement-FIN085 Order Date, Organization, Account

Public Folders > Finance Folder > University Reports > MM -

Materiels Management BI-FIN-MM-University

FIN086

Materials

Stores Billing Statement-FIN086

Statement of stores charges on internal

billing documents with some order details Transaction Posting Date, Account

Finance>University

folder>MM-Materials Management BI-FIN-MM-University

OOI001 OOI Central

Organization Contact Information-OOI001

Organization contact information including department payroll address and phone number

MAU and Department, Department Code and Name, Organization Code

and Name Public Folders > OOI BI-OOI-University

OOI002 OOI Central

MAU and Department Name with Organization Code Using All OOI Organization Structures - OOI002

Provides MAU and Department info for all Organization codes in all structure types

MAU, Department, and Structure Type, Department Code and Name,

Organization Code and Name Public Folders > OOI BI-OOI-University

OOI003 OOI Central

MAU and Department Name with Organization Code Using OOI HR Structure for Legacy System Security-OOI003

Provides MAU and Department info for only the HR structure type to aid in assigning security

MAU and Department, Department Code and Name, Organization Code

and Name Public Folders > OOI BI-OOI-University

HRP006

Org Mgmt/ Personnel

Admin University

Actual & Structural Departments List-HRP006

List of actual and structural departments within SAP

Organization, Bidding To Organization

Public Folders > HR-Payroll Folder > University HR-Payroll Reports > OMPA - Organizational

Management/Personnel

(19)

HRP008 Org Mgmt/ Personnel Admin Central Employee Listing-Restricted-HRP008

New employees by union including home and work address, phone, start date, and birth date

Action Date Start and Stop Range for New Employees Hired during the data range, Personnel Area(s), Personnel Sub Area(s), Employee Group(s), Employee Sub Group(s), Job Title(s), Action Type and Reason, Home Address Type

Public Folders > Human Resource / Payroll Folder > University Human Resource / Payroll Reports > OMPA - Organizational Management/Personnel Administration > Restricted HRSDS BI-HRP-OMPA- University-Restricted-HRSDS HRP017 Org Mgmt/ Personnel Admin Central Monthly Department of Labor Reports-Personnel Actions-HRP017

List of personnel actions for the Department of Labor

Date Range for Action Start Dates for job openings and labor turnover reports, Employee Type

Public Folders > Human Resource / Payroll Folder > Central Human Resources/Payroll Reports > OMPA - Organizational Management/Personnel Administration HRP-OM-Central BI-HRP-PA-Central HRP022 Org Mgmt/ Personnel Admin Central Academic Special Elections list-HRP022

Possible nominations for academic special elections

"Must be Active as of" Date, Positions to Include, Specialists to Exclude

Public Folders > Human Resource / Payroll Folder > Central Human Resources/Payroll Reports > OMPA - Organizational Management/Personnel Administration HRP-OM-Central BI-HRP-PA-Central HRP023 Org Mgmt/ Personnel Admin Central

Deans, Chairs and Directors Review Date Listing-HRP023

Deans, Chairs and Directors with dates for

reviews No prompts

Public Folders > Human Resource / Payroll Folder > Central Human Resources/Payroll Reports > OMPA - Organizational Management/Personnel Administration HRP-OM-Central BI-HRP-PA-Central

(20)

HRP024

Org Mgmt/ Personnel

Admin Central

No Pay Mass Update-HRP024

Non-paid faculty appointments used to update reappointments, changes in rank and terminations

Primary Assignment End Date, Reappoint and Change Categories for Personnel Areas, Personnel Subareas, Employee Groups, Employee

Subgroups, Employment Status, Action Type, Action Reason,

Promotion and Tenure Dean's List-HRP028

Promotion and tenure actions grouped by

college and action No Prompts

Promotion and Tenure List of Actions for Board Agenda-HRP029

Promotion and tenure actions including the

award of tenure No prompts

Promotion and Tenure List of Actions for Board of Trustees-HRP030

Promotion and tenure actions for the Board of Trustees excluding those acquiring tenure

with the tenure system action No prompts

(21)

HRP031

Org Mgmt/ Personnel

Admin Central

Promotion and Tenure Provost Memo-HRP031

Faculty with tenure system actions for non-reappointments, extensions, delays and

resignation/terminations No prompts

Union Seniority Reports Sorted by Payscale-HRP039

Provides information on employees within bargaining units

The Start and Stop Source Date Range for Union Employees, Personnel Sub Area, Pay Scale Levels, Organization Code and Name

Board Packet - Leaves (Sabbatical and Other)-HRP040

Leaves of sabbatical or other (military, no pay, full pay, half pay) that were entered for the period selected.

Date Range for Source Update Start Date and Source Update End Date for Leaves taken during the reporting period

Board Packet - Transfers and Assignment Changes-HRP042

Transfers and Assignment Changes for the period selected

Transfers and Assignment Changes entered into the HR/Payroll System for the time period selected. Date Range for Source Update Date.

(22)

HRP052

Org Mgmt/ Personnel

Admin Central

Union Seniority Reports Sorted by Level 4 Organization-HRP052

Provides information on employees within bargaining units

The Start and Stop Source Date Range for Union Employees, Personnel Sub Area, Pay Scale Levels, Organization Code and Name

Public Folders > Human Resource / Payroll Folder > Central Human Resources/Payroll Reports > OMPA - Organizational Management/Personnel Administration HRP-OM-Central BI-HRP-PA-Central HRP053 Org Mgmt/ Personnel Admin University Employee Listing-HRP053

List of all active employees in an organization with start date, address and phone number unless restricted.

As of Date Prompt, Organization Code and Name, Person Name, Personnel Areas, Personnel Sub Area, Employee Sub Areas, employee Groups, Employee Sub Groups.

Public Folders > Human Resource / Payroll Folder > University Human Resource / Payroll Reports > OMPA - Organizational Management/Personnel Administration BI-HRP-OM-University BI-HRP-PA-University HRP055 Org Mgmt/ Personnel Admin Central

Union Seniority Report Extract-HRP055

Provides information on employees within bargaining units formatted to extract to Excel

Date in and "As Of Date", Pay scale Levels, Personnel Areas, Personnel Subarea, Employee Groups, Employee Subgroups, Organization Code and Name

Public Folders > Human Resource / Payroll Folder > Central Human Resources/Payroll Reports > OMPA - Organizational Management/Personnel Administration HRP-OM-Central BI-HRP-PA-Central HRP057 Org Mgmt/ Personnel Admin University Enterprise Structure-HRP057

List of enterprise structure elements (Personnel Area, Personnel Subarea, Employee Group, Employee Subgroup) and

their relationships to each other No prompts

Public Folders > Human Resource / Payroll Folder > University Human Resource / Payroll Reports > OMPA - Organizational Management/Personnel Administration

BI-HRP-OM-University BI-HRP-PA-University

(23)

HRP058

Org Mgmt/ Personnel

Admin University

Faculty/Academic Staff and Support Staff Listing-HRP058

List of Faculty/Academic Staff and Support Staff with addresses and other attributes

As of Date, Organization Code & Name, Person Name, Personnel Areas, Personnel Sub Areas, Employee Groups, Employee Sub Groups

Public Folders > Human Resource / Payroll Folder > University Human Resource / Payroll Reports > OMPA - Organizational Management/Personnel Administration BI-HRP-OM-University BI-HRP-PA-University HRP060 Org Mgmt/ Personnel Admin University

Student Employee and Graduate Assistant Listing-HRP060

List of student employees and graduate assistants with additional attributes, such as hourly rate, fund, KFS sub account, funding org and weighing percentage

As of Date (required), Organization (optional), Name (Optional)

Public Folders > HR-Payroll Folder > University HR-Payroll Reports > OMPA - Organizational Management/Personnel Administration BI-HRP-PA-University HRP064 Org Mgmt/ Personnel Admin University

Active Employee Listing with All Assignments-HRP064

As per DSR 447, the user has requested a new version of Active Employee Listing with addition of muliptle assignments and remove the permanent residence details and add the work email address. This new version is possible but needs more analysis on the Support staff concurrent assignments and Faculty and Academic Staff additional assignments. So, there is a significant amount of development work in this new report.

As of Date, Organization, Person Name

Management/Personnel

(24)

HRP065

Org Mgmt/ Personnel

Admin University Job and Position Listing

As per the Data Service Request number 675, the Job Code and Job Title needs to be listed as a separate report. The analysis should be made to optionally include the position (as well as include optionally Organization and MAU). User has requested a reference report which lists all job codes and the associated title to be used for completing adobe forms in SAP.

User Information: Denise Barnstead Department: College of Engineering

Job Title, Position Title and Organzaiton Unit. And Display Position Title? (Value prompt for column disply).

Public Folders > HR-Payroll Folder > University HR-Payroll Reports > OMPA - Organizational Management/Personnel Administration BI-HRP-OM-University HRP066 Org Mgmt/ Personnel Admin University Faculty/Academic Staff and Support Staff Listing Extract-HRP066

Extract List of Faculty/Academic Staff and Support Staff with addresses and other attributes

As of Date, Organization Code & Name, Person Name, Personnel Areas, Personnel Sub Areas, Employee Groups, Employee Sub Groups

Public Folders > Human Resource / Payroll Folder > University Human Resource / Payroll Reports > OMPA - Organizational Management/Personnel Administration BI-HRP-OM-University BI-HRP-PA-University HRP069 Org Mgmt/ Personnel Admin University

Student Employee and Graduate Assistant Listing Extract-HRP069

Extract list of active student employees and graduate assistants with additional attributes.

As of Date, Employee Subgroups, Organizations and Person Names.

Management/Personnel Administration

BI-HRP-OM-University BI-HRP-PA-University

(25)

HRP018 Payroll University

Labor Distribution Report -HRP018

Reconciliation report for employee salary and fringe benefits expenditures charged to KFS accounts and to support effort

validation for restricted accounts per federal guidelines

Work Study Employment Report-HRP036

Work study eligible student employment information by unit including work study balances

Start and End Date Range for Payroll Periods, Organization Code and Name, Funds Number

Public Folders > Human Resource / Payroll Folder > University Human Resource / Payroll Reports > OMPA - Organizational Management/Personnel Administration > Restricted HR Admin All BI-HRP-OMPA- University-Restricted-HR--Admin-All HRP037 Payroll University

Work Study Cumulative Earnings-HRP037

Work study eligible student employment information including pay period and cumulative data for hours paid (total and work study), account charges (departmental and work study), authorized work study amount and balances

Pay Date Start and End Range, Work Study Type

Public Folders > Human Resource / Payroll Folder > University Human Resource / Payroll Reports > OMPA - Organizational Management/Personnel Administration > Restricted HR Admin All BI-HRP-OMPA- University-Restricted-HR-Admin-All HRP038 Payroll University

Work Study Split Report-HRP038

Summary of work study eligible student employment information including cost distribution account, work study account, work study percentage, and work study

amount. Pay Date Start and End Range

Public Folders > Human Resource / Payroll Folder > University Human Resource / Payroll Reports > OMPA - Organizational Management/Personnel Administration > Restricted HR Admin All BI-HRP-OMPA- University-Restricted-HR-Admin-All

(26)

Labor Distribution by Person-HRP062

Labor distribution details by person; Reconciliation report for employee salary and fringe benefits expenditures charged to finance accounts. Provides detailed payroll information for a person by a chosen time period and is summarized by

account/subaccount and earnings or fringe totals.

BI-HRP-PY-University- Restricted-Labor-Distribution HRP063 Payroll University Labor Distribution by Payroll Fund-HRP063

Labor Distribution by Payroll Fund-HRP063; Labor distribution details by payroll fund; Reconciliation report for employee salary and fringe benefits expenditures charged to payroll funds. Provides detailed payroll information for a payroll fund to show the personnel costs and where their actual earnings and fringes were charged. Pay Date, Account Number, Sub-Account Number, object code, Employee Sub-group, Person ID, Person Name, Account; Earnings, Fringes, For Period End date; Source: MSUEDW

Pay Date, Funding Organization, Person Name, Payroll Fund

Public Folders > HR-Payroll Folder > University HR-Payroll Reports > PY - Payroll > Labor Distribution and Payroll Encumbrances

BI-HRP-PY-University- Restricted-Labor-Distribution HRP068 Payroll University Labor Distribution Report Extract-HRP068

This report provides the extract version of the Labor Distribution report including all the available fields.

Should be same as FIN067. Document Post Date Range, Funding

Organization, Acct, Sub -Acct, Project, Person Name, Finance/HR Doc Nbr, Fiscal Officer, Principal Investigator.

Public Folders > HR-Payroll Folder > University HR-Payroll Reports > PY - Payroll > Labor Distribution and Payroll Encumbrances

(27)

FIN088

Payroll

Encumbrance University

Salary Encumbrance Detail-FIN088

Report showing salary encumbrance detail by pay period for accounting string elements. Expect drill through capability from FIN049 Operating Statement to match line item in Operating Statement, however report should also run independently and prompt on account, person and organization.

Group and Total Field; Encumbrance As Of Date Range, Responsibility Center>Organization; Account; Org Doc Nbr, Person

BI-HRP-PY-University- Restricted-Labor-Distribution FIN089 Payroll Encumbrance University Salary Encubrance Summary-FIN089

Report listing salary encumbrances by account and object code, with totals by account, organization and responsibility center.

Group and Total Field, Encumbrance As Of Date Range, Responsibility Center>Organization, Account, Org Doc Nbr

FIN016 Purchasing Central

Debarred Restricted

Vendors-FIN016 List of debarred and restricted vendors No prompt required.

Public Folders > Finance Folder > Central Finance Reports > PUR-

Purchasing BI-FIN-PUR-Central

FIN017 Purchasing University

Pcard Transaction Data Extract-FIN017

Pcard transaction data extract by transaction posting date, org and account. Default date range if nothing is chosen is prior cycle.

Pcard Transaction Posting Start and Stop Dates, Organization, Account.

Public Folders > Finance Folder > University Finance Reports > PUR-

Purchasing BI-FIN-PUR-University

Purchasing Card Statement Cardholder-FIN018

Purchasing card transactions by cardholder for a specified time period from the KFS Pcard eDoc

Date Range (generally the 25th of the month to the 24th of the next month) for Pcard reconciliation, Cardholder Name, Last Four Digits of the Card Number.

Purchasing> BI-FIN-PUR-University

Purchasing Card Transaction Detail-FIN019

Purchasing card transactions for a specified purchasing card or cards

Beginning and Ending Pcard Transaction Posting Dates, Fiscal Officer Name, Cardholder Names

Purchasing Card Transaction Summary-FIN021

Summary of purchasing card transactions for a specific period of time

Start and Stop date of the Pcard transaction period.

(28)

Requisition Aging Report Pending Approval Over 72 Hours-FIN022

Requisitions that have been pending

approval for more than 72 hours by initiator Initiator Name

Vendor Diversity Report-FIN023

Payments to vendors by specified timeframe and diversity category

PO Finalized Date Range with Start and Stop Dates, Diversity Code, Vendor Active and Inactive Diversity Codes, States, and Zip Codes,

Vendor Contracts-FIN024

All contracts with specified vendor across university

Start and Stop Vendor Contract Date Range, Vendor Names and Numbers

Contract Manager Activity Report-FIN028

Purchase orders by contract manager (buyer)

with the associated status PO Status

Contractual Services Report-FIN029

Professional services contracts (PSC) and purchase orders totaling $10,000 or greater

PO Order Create Date Range, Filtering for PSC Indicator, Object Code, Amount Filtered for PO's Greater Than $9,999, and PO Status Code

Financial Analysis Equipment Lease Report-FIN030

Purchasing report to supply purchase information of new leases at a prescribed dollar threshold.

Purchase Order Date Range, Contract Amount, Object Code = 6496

Purchasing Card Settlement Report-FIN032

Summary Pcard transaction data for a given date range

Pcard starting and ending date to create a date range.

Purchasing Card

Statement Fiscal

Officer-Purchasing card transactions by cardholder for a specified time period from the KFS

Beginning and Ending Transaction Posting Dates, Fiscal Officer Name, Cardholder Names, Default Account

(29)

Purchase Orders by

Organization-FIN080 Purchase Orders by Organization

Start and End Date Range for Purchase Order Create Dates, Organization(s)

Purchasing Card Ledger Reconciliation-FIN119

Purchasing card transactions by cardholder for a specified time period from the KFS Pcard eDoc - matches with Operating Statement

Date Range (generally the 25th of the month to the 24th of the next month) for Pcard reconciliation, Cardholder Name, Last Four Digits of the Card Number.