All Reports

Modified 6/19/2008 to add the Time-Month and RT Ticket Requestor tables to the data model. Information about the types of transactions (e.g., create, comment, take) added to Request Tracker tickets and their values. One summary pivot and one detail Report with information about transaction creator, subject, description, values and status. Limits by Transaction Type, Queue Name, Ticket Status, and Fiscal Period.

Request Tracker

Request Tracker Reports

06/19/2008

Modified 6/19/2008 to add the Time-Month table to the data model. Information about Request Tracker tickets by queue and status. One summary pivot and one detail Report with information about ticket subject, status, dates created and resolved, ticket creator, creator's DLC, days to resolution. Limits by Queue name, Ticket Status, and Fiscal Period.

Request Tracker

Request Tracker Reports

06/19/2008

Information about Request tracker tickets by their custom fields and values. One summary pivot and one detail Report with information about ticket subject, dates created and resolved, ticket creator, ticket owner (assignee), days to resolution. Limits are Custom Field Name, Queue Name, and Ticket Created dates between.

Request Tracker

Request Tracker Reports

05/22/2008

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

Returns exempt staff whose effective 12 month salary is above a specified amount (cap). DLC's should provide OSP with a Cost Object to cover the portion of the salary that is above the cap, which cannot be charged to NIH-funded accounts. Note: There are three limits for the same sponsor. The sponsor must be selected three times to retrieve all related cost objects (master project, project, and cost sharing accounts).

Payroll

Appointment Related

04/28/2008

Returns exempt staff whose effective 12 month salary is above a specified amount (cap). DLC's should provide OSP with a Cost Object to cover the portion of the salary that is above the cap, which cannot be charged to NIH-funded accounts. Note: There are three limits for the same sponsor. The sponsor must be selected three times to retrieve all related cost objects (master project, project, and cost sharing accounts).

Payroll

Central Office Reports

04/28/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

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

This version of the SRS Vacation report is for those who do not have full HR Authorizations. MODIFIED 1/18/2008 to eliminate Senior Research Staff not eligible for exempt vacation. This report is to be used for reporting vacation for SRS research staff and postdocs to Payroll. It contains a pivot report intended for export to Excel so that vacation days can be entered into the last column and submitted to Payroll.

Payroll

Leave and Time

01/18/2008

MODIFIED 1/18/2008 to eliminate Senior Research Staff not eligible for exempt vacation. This report is to be used for reporting vacation for SRS research staff and postdocs to Payroll. It contains a pivot report intended for export to Excel so that vacation days can be entered into the last column and submitted to Payroll.

Payroll

Leave and Time

01/18/2008

This version of the SRS Vacation report is for those who do not have full HR Authorizations. MODIFIED 1/18/2008 to eliminate Senior Research Staff not eligible for exempt vacation. This report is to be used for reporting vacation for SRS research staff and postdocs to Payroll. It contains a pivot report intended for export to Excel so that vacation days can be entered into the last column and submitted to Payroll.

Human Resources

HR Leave Reports

01/18/2008

MODIFIED 1/18/2008 to eliminate Senior Research Staff not eligible for exempt vacation. This report is to be used for reporting vacation for SRS research staff and postdocs to Payroll. It contains a pivot report intended for export to Excel so that vacation days can be entered into the last column and submitted to Payroll.

Human Resources

HR Leave Reports

01/18/2008

MODIFIED 11/28/2007 to include additional wage types. For weekly paid students, shows students working more than 20 hours per week, sorted by Department and residency status.

Payroll

Student Reports

11/28/2007

MODIFIED 11/28/2007 to include additional wage types. For non-exempt staff, shows hours worked and payroll rate and amount for a selected time period. There are three reports, one showing all work hours, one showing premium hours only, and one showing students who worked over 20 hours.

Payroll

Leave and Time

11/28/2007

MODIFIED 11/28/2007 to include additional wage types. For non-exempt staff, shows hours worked for a selected time period. There are three reports, one showing all work hours, one showing premium hours only, and one showing students who worked over 20 hours.

Payroll

Leave and Time

11/28/2007

MODIFIED 11/28/2007 to include additional wage types. For weekly paid students, shows students working more than 20 hours per week, sorted by Department and residency status.

Payroll

Leave and Time

11/28/2007

MODIFIED 11/28/2007 to include additional wage types. For weekly paid students, shows students working more than 20 hours per week, sorted by Department and residency status.

Payroll

Central Office Reports

11/28/2007

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

A report to enable DLCs to audit vacation credits to ensure that they have been applied to the correct cost objects. There are two queries in this document: YOU MUST USE THE PROCESS ALL COMMAND (or remember to process both queries in top to bottom order) in order to get the correct results.

Payroll

Leave and Time

09/11/2007

Intended for use by DLC Financial Administrators. Similar to the Visitor Parking report for the central Parking Office but omits the reports sorted by Department and Parking Lot. Contains two queries. Thie first is built on a Visitor Parking Detail star and is intended to provide visitor parking statistics, with a pivot report sorted by date, status, and parking lot including visitor name and the name of the department contact. The second is built on a Financial Detail star and provides the detailed information about visitor parking charges on monthly statements, sorted by closed and open items. Users may process either query separately or use the "Process All" command to process both.

Financial

Visitor Parking

09/04/2007

Intended for use by Facilities and the Parking Office. Contains two queries. Thie first is built on a Visitor Parking Detail star and is intended to provide visitor parking statistics, with three pivot reports, one sorted by department, one sorted by date, status, and parking lot, and one sorted by parking lot and date. The second is built on a Financial Detail star and provides the detailed information about visitor parking charges on monthly statements, sorted by closed and open items. Users may process either query separately or use the "Process All" command to process both.

Financial

Visitor Parking

09/04/2007

**NEW VERSION 9/4/2007 to adjust for new fiscal year.** For a DLC, displays Coeus IDC data for all research WBS elements that may incur F&A U/R (excluding training grants and Federal "Fixed Rate" competitive segments). This report will assist administrators in determining the source of funding for F&A U/R. Please see "F&A Underrecovery on Research WBS Elements" at http://web.mit.edu/sapr3/docs/webdocs/finop/ur/foURprocess.html for further documentation on the Research F&A Underrecovery reports.

Financial

DLC Financial Management

09/04/2007

**NEW VERSION 9/4/2007 to adjust for new fiscal year.** For a DLC, displays Coeus IDC data for all research WBS elements that may incur F&A U/R (excluding training grants and Federal "Fixed Rate" competitive segments). This report will assist administrators in determining the source of funding for F&A U/R. Please see "F&A Underrecovery on Research WBS Elements" at http://web.mit.edu/sapr3/docs/webdocs/finop/ur/foURprocess.html for further documentation on the Research F&A Underrecovery reports.

Financial

Research Administration

09/04/2007

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

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

Ten Payroll reports behind an easy to use dashboard. Includes the SANDI, DINDI, monthly and FYTD Dacca Reports, the Payroll Distribution Matrix, the Distribution by Person, the Quarterly Dacca Reconciliation & Certification reports, and the SRS Vacation Report for Payroll. Users may choose to process by Fiscal Period, Fiscal Quarter, or Fiscal Year; by Person, Profit Center, HR Org Unit, or by Profit Center and HR Org Unit to see all employees and all transfer-ins.

Payroll

DACCA

05/31/2007

Ten Payroll reports behind an easy to use dashboard. Includes the SANDI, DINDI, monthly and FYTD Dacca Reports, the Payroll Distribution Matrix, the Distribution by Person, the Quarterly Dacca Reconciliation & Certification reports, and the SRS Vacation Report for Payroll. Users may choose to process by Fiscal Period, Fiscal Quarter, or Fiscal Year; by Person, Profit Center, HR Org Unit, or by Profit Center and HR Org Unit to see all employees and all transfer-ins.

Payroll

DINDI / SANDI

05/31/2007

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

Modified 5/24/2007 for the revised and simplified certification process. Intended to help DLC Administrators with the Quarterly Dacca Reconciliation and Certification process. TheQuarterly Dacca now shows all activity in the quarter being certified.

Payroll

DACCA

05/24/2007

Modified 5/21/2007 to add the Time-Month table to enable users to limit on Fiscal Year if desired. Provides statistics, by Profit Center, on the number of sponsored research proposals submitted and awarded. Several reports showing both summary and detail information by PI, Sponsor, or Type (Organized Research, Predoctoral Fellowship, Postdoctoral Fellowship, Instruction & Department Research, and Other).

Financial

Research Administration

05/21/2007

Several reports showing Procurement Card spending by Merchant, Cost Object, Cardholder, Verifier.

Financial

Credit Card

04/26/2007

REVISED 4/26/2007 to add several new reports. Report to review Swept Credit Card Charges, including nine reports by cardholder, cost object, Profit Center, Vendor, and a report showing posted vs. swept charges.

Financial

Credit Card

04/26/2007

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

MODIFIED 4/19/2007 to identify and group Transfer-ins. This is the Data Warehouse version of the classic SANDI (Staff Apppointments and Distribution) form. There are two formatted reports, one sorted alphabetically by person and one sorted by personnel subarea, then by person. In addition there are two Pivot reports for export for use with another application, one with the apopintment, or "rules" data, and one with the distribution actuals. IMPORTANT: This document has three queries: you must use the "Process All" command or process each query in sequence in order to retrieve correct results.

Payroll

DINDI / SANDI

04/19/2007

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

MODIFIED 3/30/2007 to fix an issue with percent distributions. Similar to the classic payroll DINDI, but for use by Time Sheet Administrators who need to report only on hourly paid students. There are three reports: one sorted by person just like the classic DINDI, one sorted by Cost Object and person, and one sorted by Cost Object, GL Account, and person. In addition, there is a pivot for export for use with other applications.

Payroll

Student Reports

03/30/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

MODIFIED 3/30/2007 to fix an issue with percent distributions. Similar to the classic payroll DINDI, but for use by Time Sheet Administrators who need to report only on hourly paid students. There are three reports: one sorted by person just like the classic DINDI, one sorted by Cost Object and person, and one sorted by Cost Object, GL Account, and person. In addition, there is a pivot for export for use with other applications.

Payroll

DINDI / SANDI

03/30/2007

MODIFIED 3/30/2007 to fix an issue with percent distributions. This is the Data Warehouse version of the classic DINDI (Salary Expense Analysis by Individual). There are three reports: one sorted by person just like the classic DINDI, one sorted by Cost Object and person, and one sorted by Cost Object, GL Account, and person. In addition, there is a pivot for export for use with other applications.

Payroll

DINDI / SANDI

03/30/2007

Revised 3/13/2007 to add two additional queries. Three queries, to report (1) by department, (2) by person, or (3) by cost object, each with three report tabs: a summary matrix, a detailed matrix, and a "burn rate" report with distribution date view only. Pivots show payroll expense by cost object and person, in a matrix format, with the period the person worked on one axis and the period the charge posted financially on the other axis. It can be used BOTH to review the person's distribution by period, no matter when it was financially posted, to see that they were distributed correctly and that the work was within the period of the cost object, and also to see what detail was financially posted in what period. This report will tie to both the employee's distribution by period, and to the SAP summary statement.

Payroll

DACCA

03/13/2007

Revised 3/13/2007 to add two additional queries. Three queries, to report (1) by department, (2) by person, or (3) by cost object, each with three report tabs: a summary matrix, a detailed matrix, and a "burn rate" report with distribution date view only. Pivots show payroll expense by cost object and person, in a matrix format, with the period the person worked on one axis and the period the charge posted financially on the other axis. It can be used BOTH to review the person's distribution by period, no matter when it was financially posted, to see that they were distributed correctly and that the work was within the period of the cost object, and also to see what detail was financially posted in what period. This report will tie to both the employee's distribution by period, and to the SAP summary statement.

Payroll

DINDI / SANDI

03/13/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 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

Revised 2/16/2007 to correct a summing problem with the arrears. This report is for the use of central areas only. It enables each central area making payroll deductions (e.g., Credit Union, Parking, etc) to report on the deductions made by that area. There are several reports: a detail report, a summary report (total deductions by exempt / non-exempt), a report by person, and a pivot report. This version is for those deductions that do not have rolling balances.

Payroll

Internal Provider Reports

02/16/2007

Revised 2/16/2007 to correct a summing problem with the arrears. This report is for the use of central areas only. It enables each central area making payroll deductions (e.g., Credit Union, Parking, etc) to report on the deductions made by that area. There are several reports: a detail report, a summary report (total deductions by exempt / non-exempt), a report by person, and a pivot report. This version includes requested deduction amount and remaining balance for those deductions with rolling balances.

Payroll

Internal Provider Reports

02/16/2007

Revised 2/16/2007 to correct a summing problem with the arrears. This report is for the use of central areas only. It enables each central area making payroll deductions (e.g., Credit Union, Parking, etc) to report on the deductions made by that area. There are several reports: a detail report, a summary report (total deductions by exempt / non-exempt), a report by person, and a pivot report. This version is for those deductions that do not have rolling balances.

Payroll

Central Office Reports

02/16/2007

Revised 2/16/2007 to correct a summing problem with the arrears. This report is for the use of central areas only. It enables each central area making payroll deductions (e.g., Credit Union, Parking, etc) to report on the deductions made by that area. There are several reports: a detail report, a summary report (total deductions by exempt / non-exempt), a report by person, and a pivot report. This version includes requested deduction amount and remaining balance for those deductions with rolling balances.

Payroll

Central Office Reports

02/16/2007

This report shows fiscal year to date salary distribution for monthly paid graduate students. There are two reports, one by person and one by cost object, and two pivots, one sorted by student and cost object, one by student and GL Account.

Payroll

Student Reports

01/31/2007

This report shows fiscal year to date salary distribution for monthly paid graduate students. There are two reports, one by person and one by cost object, and two pivots, one sorted by student and cost object, one by student and GL Account.

Payroll

DACCA

01/31/2007

This report shows fiscal year to date salary distribution for monthly paid graduate students. There are two reports, one by person and one by cost object, and two pivots, one sorted by student and cost object, one by student and GL Account.

Payroll

DINDI / SANDI

01/31/2007

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

Intended to help DLC administrators with the Quarterly Dacca Certification process. Includes two pivot reports: (1) Shows all cost collectors by Supervisor and cost object, with name of certifier and date certified -- columns are blank if the cost object has not yet been certified. (2) A similar pivot but showing only the cost objects that have not yet been certified.

Payroll

DACCA

12/08/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

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

This report is identical to the Research Expense by Sponsor & Agreement Type History but can be used for the current fiscal year. It shows a Department's fiscal year research expenditures by Sponsor category, broken down by type (Grant, Contract). There are four tabs: (1) Department Summary by DIRECT sponsor, (2) Research Volume by Supervisor and DIRECT Sponsor, (3) Department Summary by PRIMARY Sponsor, (4) Research volume by Supervisor and PRIMARY Sponsor. This is similar to the Brown Book Section VI and VII reports.

Financial

Research Administration

10/12/2006

REVISED 10/12/2006 to include reports by Primary Sponsor as well as Direct Sponsor This report is identical to the Research Expense by Sponsor & Agreement Type Current but should be used for closed fiscal years. It shows a Department's fiscal year research expenditures by Sponsor category, broken down by type (Grant, Contract). There are four tabs: (1) Department Summary by DIRECT sponsor, (2) Research Volume by Supervisor and DIRECT Sponsor, (3) Department Summary by PRIMARY Sponsor, (4) Research volume by Supervisor and PRIMARY Sponsor. This is similar to the Brown Book Section VI and VII reports.

Financial

Research Administration

10/12/2006

This report is identical to the Research Expense by Sponsor & Agreement Type History but can be used for the current fiscal year. It shows a Department's fiscal year research expenditures by Sponsor category, broken down by type (Grant, Contract). There are four tabs: (1) Department Summary by DIRECT sponsor, (2) Research Volume by Supervisor and DIRECT Sponsor, (3) Department Summary by PRIMARY Sponsor, (4) Research volume by Supervisor and PRIMARY Sponsor. This is similar to the Brown Book Section VI and VII reports.

Financial

Closing

10/12/2006

REVISED 10/12/2006 to include reports by Primary Sponsor as well as Direct Sponsor This report is identical to the Research Expense by Sponsor & Agreement Type Current but should be used for closed fiscal years. It shows a Department's fiscal year research expenditures by Sponsor category, broken down by type (Grant, Contract). There are four tabs: (1) Department Summary by DIRECT sponsor, (2) Research Volume by Supervisor and DIRECT Sponsor, (3) Department Summary by PRIMARY Sponsor, (4) Research volume by Supervisor and PRIMARY Sponsor. This is similar to the Brown Book Section VI and VII reports.

Financial

Closing

10/12/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

Payroll Report to show Gross to Net details by person for a specified payroll period. There are two queries: one for standard gross to net showing deductions with three pivot reports, Detail by Person, Gross to Net Detail, and a Gross to Net Amount verification check. The second query allows the user to select a specific wage type like "component of gross," with a pivot report by person and wage type.

Payroll

Central Office Reports

09/08/2006

MODIFIED 9/87/2006. Payroll Office report to list payroll garnishments; there are two reports, one by area and person, and one by wage type, area, person.

Payroll

Central Office Reports

09/08/2006

Same as the New Hire Review query, but for people with limited HR access. This report returns a list of new Administrative Staff and Support Staff hires in your department based on user-specified dates. It calculates the 4th, 5th, and 6th month anniversary dates to enable planning the New Hire Review process.

Human Resources

Employee

09/08/2006

Same as the Transfers, Retirements and Terminations query, but for people with limited HR access. This query returns lists of Transfers, Retirements and Terminations within a user-specified time frame. There is a separate report for each action type listing the person's name, department, effective date of action, and e-mail address.

Human Resources

Employee

09/08/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

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

This query shows a list of subjects and the responsible faculty for the subject, by academic term and Course.

Student

Subject Enrollment

08/04/2006

This query is for use by those who do not have access to full financial data for positions. It is the same as the Positions with Time Groups report except that it does not show the budgeted dollars for positions. It shows how many positions you have in your department, for a date to be specified by the user. There are several pivot reports showing positions sorted by HR area (academic, non academic) and subarea (faculty, administrative, support, etc.), and by Position Status (vacant, filled, pending, etc.).

Payroll

Appointment Related

07/25/2006

This query is for use by those who do not have access to full financial data for positions. It is the same as the Positions with Time Groups report except that it does not show the budgeted dollars for positions. It shows how many positions you have in your department, for a date to be specified by the user. There are several pivot reports showing positions sorted by HR area (academic, non academic) and subarea (faculty, administrative, support, etc.), and by Position Status (vacant, filled, pending, etc.).

Human Resources

Positions

07/25/2006

REVISED 7/20/2006 to include students in the reports. This query shows how many positions you have in your department, for a date to be specified by the user. There are several pivot reports showing positions sorted by HR area (academic,non academic) and subarea (faculty, administrative, support, etc.) and by Position Status (vacant, filled, pending, etc.).

Payroll

Appointment Related

07/20/2006

REVISED 7/20/2006 to include students in the reports. This query shows how many positions you have in your department, for a date to be specified by the user. There are several pivot reports showing positions sorted by HR area (academic,non academic) and subarea (faculty, administrative, support, etc.) and by Position Status (vacant, filled, pending, etc.).

Human Resources

Positions

07/20/2006

One report summarizing total hours worked by all weekly employees during a calendar year, broken down by Personnel Area (Campus, Lincoln, Tech Review) and Employee/Student Type (Support Staff, Service Staff, UROP, etc.) Data for this report begins with Week 27 of Calendar Year 2006; no history was loaded into SAP.

Payroll

Central Office Reports

07/14/2006

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

Revised 7/7/2006 to use a new view, HR Appt Action Detail instead of HR Appt Tx Detail. to retrieve all actions for people who have more than one personnel action effective on the same date.There are two reports, Salary History by Person and Salary History by Personnel Area and Job Title. The reports show Appointment Start Date, Transaction Start and End Date, Percent Effort, Personnel Action type, Salary amount, Salary amount change and Salary percent change. IMPORTANT NOTE: No history was loaded into SAP HR. Therefore the history available in this report begins from September 2003 forward. For earlier history, you must use the Salary History report in the "Historical Cyborg Reports" section of the HR reports.

Human Resources

Appointment

07/07/2006

One report showing headcount and total dollars paid, by Gl Account, for Graduate Student Staff. Fellowships are excluded.

Payroll

Student Reports

07/05/2006

One report showing headcount and total dollars paid, by Gl Account, for Graduate Student Staff. Fellowships are excluded.

Payroll

Central Office Reports

07/05/2006

Shows the percent distribution of salaries to Cost Object Type (Research, Fund, General, Auxiliary, Other) by DLC and person for a user-selected month. There are two reports, one with a single row per person, and one with a detailed breakdown by distribution dates and cost object.

Payroll

Distribution

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

Shows the percent distribution of salaries to Cost Object Type (Research, Fund, General, Auxiliary, Other) by DLC and person for a user-selected month. There are two reports, one with a single row per person, and one with a detailed breakdown by distribution dates and cost object.

Payroll

Central Office 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.

Human Resources

HR Leave Reports

07/03/2006

This report is used by Benefits Accounting to track current In Period and Year to Date deductions for the 457b and catchup tax deferred annuities.

Payroll

Central Office Reports

06/27/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

Revised 5/9/2006. This report provides the same information as the Headcount EFT 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). There are two pivot reports, one using current percent effort and one using original FTE percent effort.

Human Resources

Employee

05/09/2006

Revised 5/9/2006. Displays the job title, employee's full name, percent effort, headcount, and EFT sorted by job code and rank type. There are two pivot reports, one using current percent effort and one using original FTE percent effort.

Human Resources

Employee

05/09/2006

REVISED 5/9/2006.This report returns a list of new Administrative Staff and Support Staff hires in your department based on user-specified dates. It calculates the 4th, 5th, and 6th month anniversary dates to enable planning the New Hire Review process.

Human Resources

Employee

05/09/2006

Revised 5/9/2006. This report replaces the Rank II Termination report. Rank Lists do not exist in SAP HR data; the Employee Type "Other Academic Group" is the closest equivalent to the old Rank II grouping. The report lists all Other Academic Group appointments with termination dates equal or less than the limit date set by the user. The report will assist DLCs in managing termination forms for Other Academic employees.

Human Resources

Appointment

05/09/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

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 3/3/2006. Users should download and use this new version. This report helps you to obtain the SAP Postion Data that allows you to complete the Position Roster that will become the baseline salary budget for the new fiscal year. Please contact your Budget Officer for further information.

Human Resources

Positions

03/03/2006

Revised 3/3/2006. This purpose of this report is to help DLC administrators review the Position Title, Job Title and Directory Override Title for the employees in their department. There is one report sorted by Department Name and Personnel Subarea, showing Name, Position ID, Position Title, Position Title Long, MIT Job Code, Job Title, and Directory Title.

Human Resources

Positions

03/03/2006

Revised 3/3/2006 . Position Management report to assist Administrative Units with position headcount reporting. There are two date limits in this query: users should enter the same date in each limit box. This report was created with the Person Employee Limited table and the Hr Position Limited Detail table for use by those who do not have access to sensitive employee data or full access to financial data. It does not contain salaries.

Human Resources

Positions

03/03/2006

REVISED 3/3/2006. This position report contains Position Number and Title, MIT Job Code, and Position Status for filled and vacant positions in a department for a date to be specified by the user (reminder: data in the warehouse is as of the day before, so users wanting the most current position information should enter "yesterday's" date in both date boxes). This simple query may be helpful for administrators trying to identify position numbers in order to complete HR forms. IMPORTANT: This query document contains two separate queries. To retrive all data, users should use the "PROCESS ALL" option from the Process button drop down list rather than simply hitting the "Process" button.

Human Resources

Positions

03/03/2006

REVISED 3/3/2006. Users should download and use this new version. This report helps you to obtain the SAP Postion Data that allows you to complete the Position Roster that will become the baseline salary budget for the new fiscal year. Please contact your Budget Officer for further information.

Financial

DLC Financial Management

03/03/2006

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

Allows user to compare SARA substance amounts for two SARA report years. There are two pivot reports. One compares amounts of all substances, flagging those substances and rooms where the amount has increased by 10% or more from the previous year, or is a new substance for a room in the most recent year. The other shows only those substances and rooms where the amount has increased by 10% or more from the previous year, or is a new substance for a room in the most recent year.

EHS

EHS Central Office Reports

01/13/2006

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

REVISED 12/30/2005 to show only transfers into the selected DLC, but not transfers within the same DLC. This query returns lists of Transfers, Retirements and Terminations within a user-specified time frame. There is a separate report for each action type listing the person's name, department, effective date of action, and e-mail address.

Human Resources

Employee

12/30/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

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

This query is for use by authorized administrators. The query will return a list of all students in a selected term enrolled in a selected Department (Grad Course 1, Grad Course 2, or Grad Course 3), grouped by program and amount of tuition assessed. There are two formatted reports, one summarizing the number of students at each level of tuition assessed, and a detailed report listing each student.

Student

Graduate Award

11/21/2005