All Reports

Reports on all absence types (vacation, sick leave, bereavement, jury duty, etc). There are three reports: One detailing all absence types for the selected month, a Summary report showing leave type and hours, and a Vacation Report showing details for Vacation and Fifth week vacation.

Human Resources

HR Leave Reports

07/03/2006

Reports on all absence types (vacation, sick leave, bereavement, jury duty, etc). There are three reports: One detailing all absence types for the selected month, a Summary report showing leave type and hours, and a Vacation Report showing details for Vacation and Fifth week vacation.

Payroll

Leave and Time

07/03/2006

For use by those who do not have full access to HR data: this report uses the Employee Basic table which does not contain any sensitive data. Reports on all absence types (vacation, sick leave, bereavement, jury duty, etc). There are three reports: One detailing all absence types for the selected month, a Summary report showing leave type and hours, and a Vacation Report showing details for Vacation and Fifth week vacation.

Human Resources

HR Leave Reports

08/21/2006

For use by those who do not have full access to HR data: this report uses the Employee Basic table which does not contain any sensitive data. Reports on all absence types (vacation, sick leave, bereavement, jury duty, etc). There are three reports: One detailing all absence types for the selected month, a Summary report showing leave type and hours, and a Vacation Report showing details for Vacation and Fifth week vacation.

Payroll

Leave and Time

08/21/2006

One part of four reports for instruction & unsponsored research.

Financial

Central

10/13/1999

One part of four reports for instruction & unsponsored research.

Financial

Central

10/13/1999

NOTE: Modified 12/31/2002 to enable users to run the query at any time without having to download a new version each quarter. This query was developed by CAO in cooperation with the Budget Office. It is designed to provide Administrative Units with the details behind the templates provided in October, 2001 for use in forecasting revenues and expenses. Users can select their "Budget Authorization Group" (or BAG) and run this query to see the cost centers and balances used in the template already provided. Alternately, the user can select a subset of their cost centers, so as to develop information for the template by "program", or other meaningful subset of the cost collectors in the BAG. Cost Collectors beginning with 1710000, where carryforward budgets are recorded, are excluded from this query in the Limits.

Financial

DLC Financial Management

12/31/2002

NOTE: Modified 12/31/2002 to enable users to run the query at any time without having to download a new version each quarter. This query was developed by CAO in cooperation with the Budget Office. It is designed to provide Administrative Units with the details behind the templates provided in October, 2001 for use in forecasting revenues and expenses. Users can select their "Budget Authorization Group" (or BAG) and run this query to see the cost centers and balances used in the template already provided. Alternately, the user can select a subset of their cost centers, so as to develop information for the template by "program", or other meaningful subset of the cost collectors in the BAG. Cost Collectors beginning with 1710000, where carryforward budgets are recorded, are excluded from this query in the Limits.

Financial

Central

12/31/2002

This report contains several pivots and charts showing headcount by employee category, ethnic origin, and gender.

Human Resources

Employee

09/26/2003

This report contains several pivots and charts showing headcount by employee category, ethnic origin, and gender. This report provides the same information as the Affirmative Action report, but can be processed by users who do not have access to sensitive personnel information in their departments (who have the "Limited" HR roles).

Human Resources

Employee

09/26/2003

This report contains two pivots and two charts. Pivots: 1. Title by Country with Gender Totals: 2. Race by Title with Totals: Displays a count of a department's current employees by country of citizenship, gender, and rank type. Charts: 1. Depicts the count of a department's current employees by country of citizenship and rank type. 2. Depicts the count of a department's current employees by country of citizenship and gender.

Human Resources

Historical Cyborg Reports

02/08/2000

This report generates a list of Fund Statuses for Monographs for all libraries for a fiscal year. It displays the Allocation Amount, Expenditures, % Spent, Actual Balance, Encumbrances, Free balance, % Free and the Capped Allocation Amounts (based on % max over commitment) with Subtotals and Totals. The report is arranged by Library and Fund. There are Pivot reports summarizing the same data. Corresponding reports are Amount to Encumber by Library and Library Fund Status (All Libraries).

Libraries

Collection Management

02/09/2004

This report generates a list of Fund Statuses for Monographs for a library for a fiscal year. It displays the Allocation Amount, Expenditures, % Spent, Actual Balance, Encumbrances, Free balance, % Free and the Capped Allocation Amounts (based on % max over commitment) with Subtotals and Totals. The report is arranged by Fund. A corresponding report is Fund Status by Library.

Libraries

Collection Management

02/09/2004

For a user specified cost object or cost objects, shows percent of salary distributed to cost objects by DLC, personnel subarea, person, start and end date within a current fiscal year. Does not show dollars.

Payroll

Appointment Related

10/17/2006

For a specified Org Unit, shows percent of salary distributed to cost objects by DLC, personnel subarea, person, start and end date within a current fiscal year. Does not show dollars.

Payroll

Appointment Related

10/17/2006

The total and average loan debt of a student graduating from MIT by term. This query contains two reports. The first report shows the total amount and the average amount of loans by degree within a department. The second shows the total loan amount for each student by degree within a department.

Student

Financial Aid

03/23/2000

This query contains summary and detail reports about degrees (PhD, MNG, MBA, SM, SB, etc.) awarded to students for specific academic years.

Student

Student Degree

07/03/2003

For a GL Account or group of GL Accounts, this report shows the actual amount spent sorted by GL Account for any given fiscal period.

Financial

Monthly Statement

05/22/2000

Revised 11/19/2003 to correct a bug in the script that refreshes the available values in the School/Area list of choices. This report shows the current Base/Non-base budget and FYTD actuals by Cost Collector. Data is sorted by Profit Center and Admin Flag/Admin Flag type. It also shows the Budget vs FYTD actuals variance and the percent of budget used.

Financial

DLC Financial Management

11/19/2003

Revised 11/19/2003 to correct a bug in the script that refreshes the available values in the School/Area list of choices. This report shows the current Base/Non-base budget and FYTD actuals by Cost Collector. Data is sorted by Profit Center and Admin Flag/Admin Flag type. It also shows the Budget vs FYTD actuals variance and the percent of budget used.

Financial

Central

11/19/2003

This report shows all Pool A endowment accounts and their current market values. This information is useful in donor relations and by departments for budget purposes. Departments can review unit changes as they occur, & with up-to-date unit balances, they can project expected income on the units for the next fiscal year.

Financial

DLC Financial Management

04/12/1999

This report shows all Pool A endowment accounts and their current market values. This information is useful in donor relations and by departments for budget purposes. Departments can review unit changes as they occur, & with up-to-date unit balances, they can project expected income on the units for the next fiscal year.

Financial

Central

04/12/1999

An audit/control report that lets the user select the criterion (calls costing more than $25 etc) to view certain types of itemized calls.

Financial

Telephone

08/28/2003

An audit/control report that lets the user select the criterion (calls costing more than $25 etc) to view certain types of itemized calls.

Financial

Review and Control Procedures

08/28/2003

An audit/control report that lets the user select the criterion (calls lasting more than 20 minutes, etc) to view certain types of itemized calls.

Financial

Telephone

08/28/2003

An audit/control report that lets the user select the criterion (calls lasting more than 20 minutes, etc) to view certain types of itemized calls.

Financial

Review and Control Procedures

08/28/2003

For Campus weekly employees, shows pay distribution by cost collector category type (general, funds, research). Weekly paid students and Lincoln weekly employees are excluded.

Payroll

Central Office Reports

07/13/2006

This report gives information about credit card holders in your department, including monthly and transactional spending limits and contact information for cardholders and verifiers.

Financial

Credit Card

09/01/2000

Revised 5/9/2008.
For a selected Fiscal Year and Department/s, this query shows chair appointment data. There are two pivot reports: (1) chair appointment data by the PC of the Chair Cost Collector ("Vacant" will be displayed for the period for which the Chair Cost Collector is without a chair holder), and (2) chair appointment data by the HR department of the chair holder. These reports can be run for fiscal years beginning with FY2003.

Human Resources

Appointment

05/09/2008

Shows activity in Pool A Fund Accounts during closing. Displays a balance as of the end of period 12; the aggregate of any activity in each of periods 13, 14, 15, and 16; and the final balance for the end of the fiscal year. Variables for selection are Profit Center and Fiscal Year.

Financial

Closing

06/15/1999

Shows activity in Pool A Fund Accounts during closing. Displays a balance as of the end of period 12; the aggregate of any activity in each of periods 13, 14, 15, and 16; and the final balance for the end of the fiscal year. Variables for selection are Profit Center and Fiscal Year.

Financial

DLC Financial Management

06/15/1999

Shows activity in Pool A Fund Accounts during closing. Displays a balance as of the end of period 12; the aggregate of any activity in each of periods 13, 14, 15, and 16; and the final balance for the end of the fiscal year. Variables for selection are Profit Center and Fiscal Year.

Financial

Central

06/15/1999

Report showing historical commitments for a cost collector as of a user-specified date in the past. Criteria are Cost Collector Id and Calendar Date.

Financial

Commitments

03/14/2000

Lists all open commitments, including blanket orders, by Cost Collector.

Financial

Commitments

09/24/1999

Lists all open commitments by Cost Collector. Does not include blanket orders.

Financial

Commitments

09/24/1999

MODIFIED 5/25/3007 to limit by Profit Center. This is the Data Warehouse version of the classic paper DACCA (Consolidated Salary Expense Analysis) report. There are two versions of the classic DACCA, one with page breaks by cost object for distribution to supervisors. There is also a report sorted by sponsor for sponsored cost objects only, and there is a pivot for export for use with other applications. This report is intended to be run monthly.

Payroll

DACCA

05/25/2007

Gives default cost collector assignments for a profit center; showing how telephone charges should be applied.

Financial

Telephone

08/28/2003

For a Profit Center, reports on balances for all cost collectors. Two detail tabs are used; one sorts by supervisor (Supervisor Report), the other sorts by Cost Collector Type (Cost Center, Internal Order, and WBS Element/Project).

Financial

Cost Collector

04/02/2001

For a Profit Center, reports on balances for all cost collectors. Two detail tabs are used; one sorts by supervisor (Supervisor Report), the other sorts by Cost Collector Type (Cost Center, Internal Order, and WBS Element/Project).

Financial

DLC Financial Management

04/02/2001

For a profit center or a profit center range, this query returns the period 12 balance for each cost collector, the activity in each of the closing periods (13, 14, 15, and 16), and the final balance in that cost collector. Settlement activity is excluded. This query does not include research cost collectors. For Fund Accounts in Pool A, only expendable balances are shown. The final fiscal year totals and the final cumulative totals are shown in separate detail reports.

Financial

DLC Financial Management

06/15/1999

Selects and displays information for individual cost collectors. Each cost collector's information appears on one screen.

Financial

Cost Collector

03/24/1999

Shows the available total, expenditures to date, total commitment amount, and availabl balance for cost collectors (Internal Orders and WBS Elements) that have an expiration date of less than 120 days from the present.

Training

Training

04/14/1999

Selects and displays parent account and all children accounts, both open and closed.

Financial

Cost Collector

03/24/1999

Selects and displays all open cost collectors for entire profit centers. Includes two sort orders: by cost collector type and cost collector ID and by Supervisor, cost collector type and cost collector ID. Also contains a section specifically for downloading and exporting to another application.

Financial

Cost Collector

07/19/1999

Selects and displays all open cost collectors for entire profit centers. Includes two sort orders: by cost collector type and cost collector ID and by Supervisor, cost collector type and cost collector ID. Also contains a section specifically for downloading and exporting to another application.

Financial

DLC Financial Management

07/19/1999

Selects and displays all open cost collectors for entire profit centers. Includes two sort orders: by cost collector type and cost collector ID and by Supervisor, cost collector type and cost collector ID.

Training

Training

03/24/1999

Selects and displays open cost collectors by supervisor.

Financial

Cost Collector

03/24/1999

Selects and displays open cost collectors by supervisor.

Financial

Research Administration

03/24/1999

Two views of cost object changes with an easy to use EIS interface. (1) Displays changes on an individual cost object over the life of the cost object. Fields available are: Authorized Total, Supervisor, Addressee,Term Code, Start-End Dates, Costing Sheet, Key, Profit Center and Expiration Date. (2) Displays changes to DLC cost objects over a specified time period. Fields available are: Costing Sheet, Key, Authorized Total, Term Code, and Term Dates.

Financial

DLC Financial Management

05/03/2004

Revised 12/21/05. For a selected master project number, produces a form for DLC administrator to enter changes to the cost sharing plan for submission to and entry by OSP into Coeus.

Financial

DLC Financial Management

12/21/2005

Revised 12/21/2005 By master project number, displays all of a DLC's cost sharing commitments made as a condition of the award.

Financial

DLC Financial Management

12/21/2005

Modified 1/9/2006 to simplify reporting for DLCs with multiple Profit Centers. Current and Pending Support information from Coeus. User may report by Profit Center and/or by Investigator. Four pivot reports, Active support by Type (Organized Research, Pre- or Post-doctoral support, other), Active Support by PI, Pending support by Type, Pending support by PI, and one detailed Current and Pending Support by PI. NOTE: This document contains three queries, one for Current Support, one for Pending Support, and one to Combine the two. Use the "Process All" command to retrieve all data. The Current and Pending Support queries may also be processed separately.

Financial

Research Administration

01/09/2006

Displays a list of DACCAs for a fiscal year for a DLC. It can be used to determine which months should have DACCAs so that a DLC knows whether it has verified a complete set for the auditors. It has three views: by month; by supervisor and cost object; by supervisor and GL account.

Financial

DLC Financial Management

11/14/2003

***REVISED 8/14/2007***The electronic version of the MIT Faculty and Staff Directory, for Department HR Administrator use only. This document now includes the Invalid Address report (previously a stand-alone report) and a Directory Override report in addition to the Department Directory report and a Correction Form for Distribution.

Human Resources

DLC Employee Directory

08/14/2007

For a cost collector or group of cost collectors, this report shows the actual amount spent sorted by GL Account for any given month. It includes: Pivot Report: Actual Amount by GL Account; Detail Report: Document Date, Document Number, Purchase Order Number, Reference Document Number, Description; Document Type, Vendor and Actual Amount sorted by GL Account.

Training

Training

06/02/1999

An easy to use dashboard with multiple reports enabling analysis of DLC spending by Vendor, GL Account, Partner / non-Partner,ProCard and ProCard Merchant.

Financial

Procurement

04/25/2007

This report provides a simple departmental directory report listing employees as of a user-specified date. There are two reports, one sorted by employee name and one sorted by HR Area and Subarea by name, including job title, room number, telephone extension and e-mail address.

Human Resources

Employee

09/14/2004

NOTE: Do not use this query if you do not hold the Department Head reporting role, normally given only to AOs (FOs with additional approval); you will not receive the correct data. For Admin Flag FC, this query finds all supervisors linked to a specified DLC by at least one cost object, and finds all cost objects supervised by those supervisors.

Financial

DLC Financial Management

04/23/2008

NOTE: Do not use this query if you do not hold the Department Head reporting role, normally given only to AOs (FOs with additional approval); you will not receive the correct data. For Admin Flag FC and a specified fiscal period, this query finds all supervisors linked to a specified DLC by at least one cost object, and finds all cost objects supervised by those supervisors. There is one report sorted by Supervisor and Profit Center, showing Available Total, Current Month, FYTD, and Cumulative Expenses, and Unexpended Balance for each Cost Object.

Financial

DLC Financial Management

04/23/2008

One part of four reports for instruction & unsponsored research.

Financial

Central

10/13/1999

For a cost collector or group of cost collectors, this report shows the actual amount spent sorted by GL Account for any given month. It includes: Pivot Report: Actual Amount by GL Account; Detail Report: Document Date, Document Number, Purchase Order Number, Reference Document Number, Description; Document Type, Vendor and Actual Amount sorted by GL Account.

Financial

Monthly Statement

06/02/1999

For a cost collector or group of cost collectors, this report shows the actual amount spent sorted by GL Account for any given month. It includes: Pivot Report: Actual Amount by GL Account; Detail Report: Document Date, Document Number, Purchase Order Number, Reference Document Number, Description; Document Type, Vendor and Actual Amount sorted by GL Account.

Financial

Research Administration

06/02/1999

Revised 5/4/2006 This query contains reports that track Emergency Incidents and Injury Incidents at MIT via calls to the Operations Center. The Summary reports capture the basic data of the incident including date/time, location, description and status. The Details reports captures all of the basic data of the incident plus the details of any investigations or after-action reviews. NOTE: Mac users need to first download the PC version of the dashboard report, then open it using Citrix. See the Citrix instructions page at http://web.mit.edu/warehouse/citrix.html for information about setting up Citrix.

EHS

EHS DLC Reports

05/04/2006

Revised 5/4/2006 This query contains reports that track Emergency Incidents and Injury Incidents at MIT via calls to the Operations Center. The Summary reports capture the basic data of the incident including date/time, location, description and status. The Details reports captures all of the basic data of the incident plus the details of any investigations or after-action reviews. NOTE: Mac users need to first download the PC version of the dashboard report, then open it using Citrix. See the Citrix instructions page at http://web.mit.edu/warehouse/citrix.html for information about setting up Citrix.

EHS

EHS Central Office Reports

05/04/2006

Reports on EHS Inspections with an easy to use dashboard to provide information for the DLC and Cycle to be specified by the user: Inspection All Status itemizes status of inspections. Findings by Question & PI details findings, showing finding rooms, status, action type (recommended or corrective) and assignee. Inspection Summary gives summary metrics for inspections, ratings, findings and actions. In addition, there is a pivot report on Inspections All Status for export to Microsoft Excel.

EHS

EHS DLC Reports

10/03/2006

Modified 5/11/2006. Several reports on PI Space Registration and SARA Reporting data, with an easy to use dashboard. The reports are grouped in 5 categories: Summary, People, Space, Hazards & Substances, and SARA reporting. There are 2 different Summary reports for reviewing information across the People, Space, and Hazards & Substances categories. There are also 4 People, 4 Space, 3 Hazards & Substances, and 3 SARA reports. The Hazards & Substances reports include an easy to use checklist that quicky identifies all of the hazards in every roomset. The SARA reports are used for tracking the current year SARA submittals. NOTE: Mac users need to first download the PC version of the dashboard report, then open it using Citrix. See the Citrix instructions page at http://web.mit.edu/warehouse/citrix.html for information about setting up Citrix.

EHS

EHS DLC Reports

05/11/2006

Reports on EHS Training Reconciliation with an easy to use dashboard to provide information for the DLC and PI to be specified by the user: Trainees in active/new status only; PI Reconciler; Trainee Current Statuses; Trainee Length in New Status; Trainee All Statuses and dates of statuses. In addition, all reports are pivot reports for export to Microsoft Excel. NOTE: Mac users need to first download the PC version of the dashboard report, then open it using Citrix. See the Citrix instructions page at http://web.mit.edu/warehouse/citrix.html for information about setting up Citrix.

EHS

EHS DLC Reports

09/26/2007

Revised 6/1/2007. Several reports on training data, with an easy to use dashboard. There are two groups of reports, one for most recently completed training and one group of aging reports. The reports on most recently completed training are sorted (1) by DLC, PI, Trainee, (2) by DLC, Trainee, and (3) by Course, Trainee. There are three aging reports, one for courses expiring in 7 days, one for courses expiring in 30 days, and one for courses already expired. Those expiring in 7 days are also included in the 30 day report. An aging report will be blank if there is nobody who meets the expiration criteria. NOTE: Mac users need to first download the PC version of the dashboard report, then open it using Citrix. See the Citrix instructions page at http://web.mit.edu/warehouse/citrix.html for information about setting up Citrix.

EHS

EHS DLC Reports

06/01/2007

Modified 3/18/2005 to widen the phone number column and text wrap other columns in the report. Displays full name, title, office address, office phone and email information for the selected department name.

General

Employee Directory

03/18/2005

Modified 2/15/2006 to show only employees with missing information. This report includes information that employees maintain using Employee Self Service. Data includes office and home address, emergency contact, ethnic origin and e-mail address. There is one formatted report which includes completion statistics and a summary of missing information that allows authorized administrators to follow-up with employees about using ESS to maintain their information, or to maintain information for their employees using the Employee tab on SAPweb.

Human Resources

Employee

02/15/2006

This report will enable you to review appointments that have already expired, or will expire within a certain timeframe.

Training

Training

08/26/2003

Revised 4/6/2007 at the request of HR to exclude student employees. This report returns people in your department whose appointments have expired, or will expire within a user specified time frame. Faculty in Administration and Institute Professors are excluded from the report. The report shows name, department, job title, Salary, and appointment end date.

Human Resources

Appointment

04/06/2007

A report to look up activity on one five digit MIT extension.

Financial

Telephone

08/28/2003

This query retreives the detail information of the credit results generated from external test scores (eg. Advanced Placement, GCE A-Level, Transfer Credit, International Baccalaureate). It contains a Detail by Student pivot report which shows the credit results generated for each of the student. The credit result record includes items such as the generated credit subject code and the units, the applied credit subject code and the units, the registration subject code and the units. There are also summary counts by Generated, Applied, and Registered credit tresults. Limits (search criteria) of the query are: entrance term code, credit result category (e.g. A-Level, Advanced Placement, Transfer Credit, International Baccalaureate), and Generated Credit Subject Code (eg. '5' for Chemistry, '8' for Physics, '18' for Mathematics).

Student

External Test Scores and Credit Results

06/07/2004

This query retrieves the detail information of the credit results and the test scores that are associated with the credit results. Limits (search criteria) of the query are: entrance term code, credit result category (e.g. A-Level, Advanced Placement, Transfer Credit, International Baccalaureate), and Generated Credit Subject Code (eg. '5' for Chemistry, '8' for Physics, '18' for Mathematics). One report groups the detail information by generated credit subject and another report groups the information by student. Items displayed in the reports include: Full name and MIT ID of the student, generated and applied subject information (with subject code, subject number, and number of units), apply credit message, the credit result category and name, and the test category, test code, and test description.

Student

External Test Scores and Credit Results

06/07/2004

This query retreives the detail information of the external test scores which include the test code, test component code, test description, test score value, and the test taken month and year. The limits of the selection are: entrance term, test category, and test description. In addition to a Detail by Student pivot report, the query also includes a summary section of number of test scores by test category (eg. AP, A-Level, Transfer Credit) and test.

Student

External Test Scores and Credit Results

06/07/2004

This report captures FSA (Flexible Spending Account) activity (health care and Dependent Care) during the request period; payroll updates accordingly.

Human Resources

CAO HR Benefits Reports

05/02/2005

Modified 2/23/2007 to correct inflated percentages for graduate students. Two queries. One brings back the FYTD Payroll (e-Dacca) distribution for a selected fiscal year and person: there is a summary pivot by month, and a detail report. The other brings back the Appointment distribution information for the selected person, displayed in a pivot report. You may process either query or use the "Process All" command to retrieve results in both queries.

Payroll

DINDI / SANDI

02/23/2007

Modified 2/23/2007 to correct inflated percentages for graduate students. Two queries. One brings back the FYTD Payroll (e-Dacca) distribution for a selected fiscal year and person: there is a summary pivot by month, and a detail report. The other brings back the Appointment distribution information for the selected person, displayed in a pivot report. You may process either query or use the "Process All" command to retrieve results in both queries.

Payroll

DACCA

02/23/2007

MODIFIED 3/30/2007 to fix an issue with percent distributions. This report enables you to report on current fiscal year to date DACCA data. There are three reports, one by Cost Object, one by Month, Cost Object and GL Account, both with time periods in descending order, and one by person; there is one quarterly report pivot by person NOTE: This query will not have data from the legacy payroll system. Historical data will accumulate from SAP Payroll go-live, Fiscal Year 2007.

Payroll

DACCA

03/30/2007

This report (used for billing) captures PostDoc Fellows who have requsted enrollment and/or continued enrollment in health and/or dental. Payroll/BAO will need to bill the fellows directly.

Human Resources

CAO HR Benefits Reports

05/02/2005

For a profit center or a profit center range, this query shows the fiscal year and cumulative activity for research projects (WBS Elements greater than 5000000). Settlement activity is excluded. Selection is for profit center and fiscal year. Closing periods are not shown because there is no activity on research accounts after period 12.

Financial

Closing

06/15/1999

For a profit center or a profit center range, this query shows the fiscal year and cumulative activity for research projects (WBS Elements greater than 5000000). Settlement activity is excluded. Selection is for profit center and fiscal year. Closing periods are not shown because there is no activity on research accounts after period 12.

Financial

Research Administration

06/15/1999

Report showing the process status (complete or not complete) of payroll, facilities, costing sheets and monthly settlements for any calendar period.

Financial

Processing Status

09/02/1999

***NEW VERSION 11/14/2003*** Report for review and control procedures. Allows user to review and report, from one screen, on a variety of transactions (credit card, payroll exceptions, purchase orders, revenue, and others) by profit center, supervisor, or individual cost collector for a chosen fiscal period.

NOTE: The BrioQuery 6.6 version of this document combines BOTH the Financial Review and Control Procedures Report template and the Signoff Form. Revised 11/14/2003 to include all Partner Vendors when the Partner Vendor button is selected, and to include all document types when "All Transactions" is selected.

Financial

Review and Control Procedures

11/14/2003

***REVISED 11/19/2001*** This report shows a Department's Research Expenditures by Sponsor for a selected number of Fiscal Years (data is available from FY1997 forward).

Financial

Closing

11/19/2001

***REVISED 11/19/2001*** This report shows a Department's Research Expenditures by Sponsor for a selected number of Fiscal Years (data is available from FY1997 forward).

Financial

Research Administration

11/19/2001

***REVISED 2/19/2002***This report shows a Department's Research Expenditures by Sponsor and GL Account for a selected Fiscal Year.

Financial

Closing

02/19/2002

***REVISED 2/19/2002***This report shows a Department's Research Expenditures by Sponsor and GL Account for a selected Fiscal Year.

Financial

Research Administration

02/19/2002

This report shows to fiscal year to date activity and budget in all cost centers (general), and the fund balances, fiscal year to date activity, and budget for all sponsored and non-sponsored funds for Departments. The "Administrative Flag" is also shown -- a new field which describes whether the cost object us under the control of the department.

Financial

DLC Financial Management

10/02/2000

NOTE: REPORT REVISED 4/19/2002: the original version did not return fund cost collectors that did not have a Fund Description; the revised template will return fund cost objects with and without Fund Descriptions. This report shows Principal and Expendable cumulative and FYTD amounts for invested funds. It includes Pool Units and a Description of the fund's purpose. There are two report tabs: (1) a pivot sorted by Funding Class Description, Pool Code and Cost Collector ID, and (2) a Detail report sorted by Fiscal Period and Pool Code.

Financial

DLC Financial Management

04/19/2002

NOTE: REPORT REVISED 4/19/2002: the original version did not return fund cost collectors that did not have a Fund Description; the revised template will return fund cost objects with and without Fund Descriptions. This report shows Principal and Expendable cumulative and FYTD amounts for invested funds. It includes Pool Units and a Description of the fund's purpose. There are two report tabs: (1) a pivot sorted by Funding Class Description, Pool Code and Cost Collector ID, and (2) a Detail report sorted by Fiscal Period and Pool Code.

Financial

Central

04/19/2002

For invested funds, shows Pool Code, Pool Units, Treasurer's Report code, Fund Description, Fund Restriction and cumulative and FYTD amounts. One report sorted by Funding Class Description and three pivots, Fund Description, Fund Restriction, Fund Master Data.

Financial

DLC Financial Management

01/31/2007

This report generates a list of Fund Statuses for all libraries for a fiscal year. It displays the Allocation Amount, Expenditures, % Spent, Actual Balance, Encumbrances, Free balance and % Free with Subtotals and Totals. One report is arranged by Budget Group, Source and Library. Another report is arranged by Library, Budget Group and Source. There are two Pivots summarizing the same data. Corresponding reports are "Fund Status by Library" and "Amount to Encumber by Library."

Libraries

Collection Management

02/09/2004

This report generates a list of Fund Statuses for a library for a fiscal year. It displays the Allocation Amount, Expenditures, % Spent, Actual Balance, Encumbrances, Free balance and % Free with Subtotals and Totals. The report is arranged by Budget Group. There is a Pivot report summarizing the same data. Corresponding reports are "Fund Status (All Libraries)" showing similar data for all libraries and "Amount to Encumber by Library."

Libraries

Collection Management

02/09/2004

Revised 7/7/2004 to show Transfers correctly. Shows current pool units, beginning balance, gifts and other revenues, transfers, expenses, other charges, and ending balance by cost collector. Principal and expendable are shown in separate detail reports. Allows for selection by profit center and fiscal period and year. Includes internal orders and WBS in Fund range. A pivot tab shows the columns of the report in greater detail. For example, "expenses" can be broken down into salaries and wages, employee benefits, other direct expenses, indirect expenses, and drafts. This report was modified 6/1/2001 to exclude settlements, so that beginning balances will now match the SAP funds analysis report.

Financial

DLC Financial Management

10/14/2004

Revised 7/7/2004 to show Transfers correctly. Shows current pool units, beginning balance, gifts and other revenues, transfers, expenses, other charges, and ending balance by cost collector. Principal and expendable are shown in separate detail reports. Allows for selection by profit center and fiscal period and year. Includes internal orders and WBS in Fund range. A pivot tab shows the columns of the report in greater detail. For example, "expenses" can be broken down into salaries and wages, employee benefits, other direct expenses, indirect expenses, and drafts. This report was modified 6/1/2001 to exclude settlements, so that beginning balances will now match the SAP funds analysis report.

Financial

Central

10/14/2004

Shows cumulative expenses, cumulative revenues, and authorized totals by PI for a specific profit center or a group of profit centers. The definition of Funds Available is: the authorized total for all sponsored cost collectors, and cumulative revenues for non-sponsored cost collectors. "Funds Available" is calculated and compared to cumulative expenditures plus current commitments.

Financial

DLC Financial Management

01/25/2001

Shows cumulative expenses, cumulative revenues, and authorized totals by PI for a specific profit center or a group of profit centers. The definition of Funds Available is: the authorized total for all sponsored cost collectors, and cumulative revenues for non-sponsored cost collectors. "Funds Available" is calculated and compared to cumulative expenditures plus current commitments.

Financial

Central

01/25/2001

***REVISED 8/11/2004 (reports re-formatted to fit on one page)***For a selected FY and DLC, this query groups FYTD expenses by "Sources," "Uses," and "Transfers." For Sources, credit amounts are shown as positive; for Uses and Transfers, debit amounts are shown as positive. The Ending Balances are calculated: Total Sources less Total Uses less Total Transfers. This report can be run for fiscal years beginning with FY2000. When run for the current fiscal year, information is as of the latest closed month; data is loaded on the 10th of each month. There are five report tabs: a pivot and a detail report for funds controlled by the Department Head; the same two reports with Faculty Controlled funds also shown; the fifth report shows the admin flag, category code, pool code and supervisor for all cost collectors in the DLC.

Financial

DLC Financial Management

08/11/2004

***REVISED 8/11/2004 (reports re-formatted to fit on one page)***For a selected FY and DLC, this query groups FYTD expenses by "Sources," "Uses," and "Transfers." For Sources, credit amounts are shown as positive; for Uses and Transfers, debit amounts are shown as positive. The Ending Balances are calculated: Total Sources less Total Uses less Total Transfers. This report can be run for fiscal years beginning with FY2000. When run for the current fiscal year, information is as of the latest closed month; data is loaded on the 10th of each month. There are five report tabs: a pivot and a detail report for funds controlled by the Department Head; the same two reports with Faculty Controlled funds also shown; the fifth report shows the admin flag, category code, pool code and supervisor for all cost collectors in the DLC.

Financial

Central

08/11/2004

For a selected FY and DLC, this query displays by cost collector the Funds FYTD expenses by "Sources," "Uses," and "Transfers." For Sources, credit amounts are shown as positive; for Uses and Transfers, debit amounts are shown as positive. The Ending Balances are calculated: Total Sources less Total Uses less Total Transfers. This report can be run for fiscal years beginning with FY2000. When run for the current fiscal year, information is as of the latest closed month; data is loaded on the 10th of each month.

Financial

DLC Financial Management

12/18/2003

For a selected FY and DLC, this query displays by cost collector the Pool A FYTD expenses by "Sources," "Uses," and "Transfers." For Sources, credit amounts are shown as positive; for Uses and Transfers, debit amounts are shown as positive. The Ending Balances are calculated: Total Sources less Total Uses less Total Transfers. This report can be run for fiscal years beginning with FY2000. When run for the current fiscal year, information is as of the latest closed month; data is loaded on the 10th of each month.

Financial

DLC Financial Management

12/18/2003