IRT also maintains a reporting database that extracts and integrates data from Oracle Financials, EDW, PeopleSoft, SPIDERS, FAMIS, hospital systems, other School of Medicine applications and industry-wide benchmark data sources.
Using this set of integrated data, IRT generates and distributes analytical and operational reports to the Dean’s Office staff based on a fixed schedule or by request.
Additionally, there is a series of reports available in ReportMart1 that the business community can access and run on a self-service basis.
Please submit a Request a Consultation for the following:
Scheduled Standard Reporting: Fixed Schedule
| Scheduled Recurring Reports - Generated and Distributed by IRT | ||
|---|---|---|
| Rpt # | Name / Description | Frequency |
| 1 | Roster of SoM staff, faculty, and students | Weekly |
| 2 | Actual salary expenditures for faculty by account (PTA) | Monthly |
| 3 | HAP - Housing Assistance Program - expenditures for faculty | Monthly |
| 4 | EPS (Educational Progam Services)-Supported faculty salary expenditures by PTA | Monthly |
| 5 | Faculty Leave Referential Integrity report - approved leaves and actual leave account expenditures for active faculty | Monthly |
| 6 | Faculty Appointment Referential Integrity report - appointment date inconsistencies | Monthly |
| 7 | Fund Reserves | Quarterly |
| 8 | Faculty Hires and Departures within a specified timeframe | BiAnnual |
| 9 | Five year history of approved salaries for faculty by salary category (base, variable, supplement) | Annual |
| 10 | Faculty Profile support - includes actual and approved salaries, research expenditures, demographic data, clinic rvus, and market data. | Annual |
| 11 | Clinic Salaries and Bonuses - for faculty and staff paid from designated-clinical accounts. | Annual |
| 12 | History of sponsored Research expenditures by PI and PTA - including faculty demographics | Annual |
| 13 | Space Costing Model and Research Space Utilization reports with detail by PI | Annual |
| 14 | Course Enrollments including student counts by program/plan and instructor demographics | Annual |
| 15 | Active faculty IDs and email addresses with primary appointment deparment org for OPACS (conflict of interest) | Annual |
| 16 | Summary of SoM and SHC space for Inter-entity Agreement support | Annual |
Please submit a Request a Consultation for the following
For additional information about Report Mart1 go to http://reportmart1.stanford.edu (authorization required)
| ReportMart1 Reports | |
|---|---|
| Folder Name | Report Name / Number |
| Med Faculty Events | Dept Faculty Roster (PS_MED001) |
| Faculty Appointments (PS_MED002) | |
| Indiv faculty Roster (PS_MED003) | |
| SoM Ad Hoc Reporting (PS_MED011) | |
| School of Medicine DSS | FIM Space by Room Type Category (PS_MED018) |
| Space Inventory and Faculty (PS_MED015) | |
| Faculty Salary Letters (PS_MED016) | |
| Med Admissions | Med Admissions Summary Rep (PS_MED004) |
| Grad Admissions | Biosciences Admissions Summary (PS_GRA008) |
| SR Med | MD Candidates - Multiple Degree Programs (PS_MED006) |
| Med Tuition Roster (PS_MED007) | |
| Medical Student Roster (PS_MED008) | |
| School of Med Clerkships (PS_MED009) | |
| SoM Graduating Students (PS_MED010) | |
IRT Confluence Wikis