Filetype Excel XLSX | Posted on 10 Aug 2022 | 3 years ago
Authentication
digital resources
152x Filetype XLSX File size 0.04 MB Source: it.cornell.edu
Sheet 1: Notes
| Units included in Admin Data Stores worksheet |
| CIT |
| Human Ecology |
| CALS |
| CIS/COE |
| HR |
| A&S |
| RAIS |
| Grad |
| AA&D |
| IRP |
| Familiar Name | Abbreviation | Data Store Business Name | Functional Areas | Data Steward or delegate if known | Source Data From | Audience | Internal Point of Contact | Data Set - Summary | Data Scope | Maintained By | Housed By | To Request Access | Access Methods | Database Technology | Model | Data Currency | Security - Role Based | Security - Row Level | Metadata Available? | Table and Column Attributes Available? | BI Solutions |
| Admissions Self Service | ADMSS | ADMSS PROD | Admissions Office | SAS VP | Student DM | Prospective student via the admissions acceptance website. | This is simply a copy of the admissions_ss table from the student datamart to a 24X7 availability database since a 24x7 website accesses this table. | Current term student admissions status information | ODAA | CIT | Integration data store, no direct access | N/A | Oracle | Denormalized (relational) | M-F Complete refresh | N/A | NO | NO | NO | NO | |
| Accounting Data Warehouse | ADW | ADW PROD | Finance - General Ledger | CIO DFA VP | GL system | Financial Administrators, PI s, Account Managers | Frozen snapshot of pre-Kuali KFS financial data mart | All Financial Orgs, All Financial Accounts | ODAA | CIT | http://www.dfa.cornell.edu/accounting/tools/financialinfo/ | Hyperion Portal reports / direct connect accounts | Oracle | Denormalized (relational) | Frozen as of the Kuali KFS go live. | YES | YES by account range | NO | NO | Hyperion Dashboards | |
| Emergency Mass Notification | EMN | EMN PROD | Campus Community | PeopleSoft | EMS Service, CU Police Department | Notification information for all persons related to Cornell. | All interested Cornell individuals | ODAA | CIT | Integration data store, no direct access | No direct connect access available. Used as staging for EMS service | Oracle | Denormalized (relational) | M-Sat Complete refresh | NO | NO | NO | NO | NO | ||
| Facilities Inventory DM | FIKFSDM | FIKFSDM 11G PROD | Infrastructure, Properties and Planning (IPP) fka Facilities | Infrastructure, Properties and Planning (IPP) fka Facilities - Jane VanDerzee | KDW, FSPROD(spaceinkfs) | Facilities | Facilities inventory attributes | Ithaca campus | ODAA | CIT | Infrastructure, Properties and Planning (IPP) fka Facilities - Jane VanDerzee | Oracle | Dimensional | M-Sat Current year refresh | NA | YES | NO | NO | OBIEE Answers and Dashboards | ||
| CU Connect | HARRIS | HARRIS 11G PROD | Alumni Affairs & Development | AA&D VP | PeopleSoft, Harris, directory | PeopleSoft & Harris | Alumni demographics | alumni | ODAA | CIT | Integration data store, no direct access | Via application only | Oracle | Denormalized (relational) | daily Incremental | NA | NA | NO | NO | NO | |
| CU Person | EDW | EDW PROD | Campus Community, HR | HR VP | PeopleSoft, directory, APDB | Kuali Cynergy Application | Common person demographic attributes | All interested Cornell individuals | ODAA | CIT | Access not available outside Cynergy application at this time. | Cynergy Application | Oracle | Denormalized (relational) | M-F Complete refresh | role based | Proposed column level | NO | NO | NO | |
| Human Resources and Payroll | HRPY | HRPY 11G PROD | Human Resources | HR VP | PeopleSoft, APDB | HR and HR managers | Pre-WorkDay HR and Payroll mart | CUNIV - All department | ODAA | CIT | https://infoaccess.adminapps.cornell.edu/hrda | Hyperion Portal reports / direct connect accounts | Oracle | Denormalized (relational) | frozen as of WorkDay go live (4/1/2013) | YES | Yes by department | NO | NO | Hyperion Dashboards | |
|
|
IDW | I2 IDW PROD | Several but lead is Div of Budget and Planning | May be N/A | PS HR, Workday, Dining, flat file upload | BOTs and Senior Leadership | headcount, dining, athletics, Gannett | University wide, aggregate data | ODAA | CIT | N/A | Dashboard only at this time. | Oracle | Dimensional | Monthly, quarterly, annual depending on metric | Manual - all or nothing access | No | Yes | Yes | Institutional Intelligence Dashboards | |
| Kuali Data Warehouse | KDW | KFS DM PROD | Division of Financial Affairs | CIO DFA VP | Kuali Financial Systems, RA, Workday, PeopleSoft, LongView | Financial Administrators, PI s, Account Managers | Financial, Research Financial and Labor Financial | All Financial Orgs, All Financial Accounts | ODAA | CIT | https://confluence.cornell.edu/display/kfsidr/Dashboard+-+Data+Access+and+Annual+Certification | Dashboards OR Direct Connect accounts | Oracle | Dimensional | Updated 5X per week (Mon night - Fri night). More often if month end falls on the weekend. | Yes, based on Staff Accounting, Labor Org and PI | Based on KFS Account Manager and PI | Yes. Source and target mapping, business descriptions. | Yes, via KFS Financial Reference Guide Dashboard | KFS Dashboards, Web Fin 2 | |
| Research Administration Data Mart | RADM | RADM PROD | Research Administration | Sr Vice Provost of RA | EZRA, COI | Research Administrators, PI s | Research grant data and compliance data | Cornell | ODAA | CIT | TBD | OBIEE or direct connect | Oracle | Dimensional | Updated 5X per week (Mon night - Fri night) | YES | YES | Source to Target mappings, business descriptions | Yes | RA Dashboards | |
| Office of Sponsored Programs Warehouse | OSPWH | OSPWH 11G PROD | Research Administration | Sr Vice Provost of RA | EZRA | Research Administrators, PI s, College Analysts | Research grant data | Cornell | ODAA | CIT | http://www.research.cornell.edu/RAIS/SponsDW/Access/index.htm | Sponsor Portal / direct connect accounts | Oracle | Denormalized (relational) | M-F Complete refresh | YES | YES | NO | NO | Sponsored Portal / Hyperion Reports | |
| Student Data Mart (People Soft) | SADW | SA 11G PROD | Student and Academic Services | SAS VP | PeopleSoft Student | Campus Analysts, Colleges, SAS, Admissions Office, Financial Aid Office, Bursar Office, Student Records. | Student Records, Admissions, Financial Aid, Student Financials | ALL | ODAA | CIT | https://infoaccess.adminapps.cornell.edu/sda/portal.do | Hyperion Portal reports / direct connect accounts | Oracle | Dimensional | M-F Complete refresh, current 3 years for large fact tables | Yes | column based | Yes | Yes | Hyperion Dashboards | |
| Student value added tables | SAVAT | SADW RPT 11G PROD | Student and Academic Services | SAS VP | SADW | Campus analysts, Colleges. | aggregates and other value add datasets based off student data mart | ALL | ODAA | CIT | https://infoaccess.adminapps.cornell.edu/sda/portal.do | Direct connect accounts | Oracle | Denormalized (relational) | M-F Complete refresh | Yes | NO | NO | NO | NO | |
| Grad Aid | GRADAID | Grad Aid 11G PROD | Graduate School Data Solutions | Graduate School Data Solutions | Student DM, KDW | Graduate School | biographic/demographic data; degree awarded info; academic advisor data; academic program and plan; funding sources and primary support categorization (uisng PS finanical aid, labor and bursar data); OSP account attributes; graduate fields attributes and graduate field mapping to academic plans | Graduate students | Graduate School Data Solutions | CIT | https://infoaccess.adminapps.cornell.edu/sda/portal.do | Direct connect accounts | Oracle | Denormalized (relational) | M-F Complete refresh | Yes | No | dashboard level; some metadata available in the "algorithm" (it documents the creation of some of the tables) | NO | robust set of Tableau dashboards/reports via Data Solutions portal | |
| EBS - Utility Billing | EBS_DM | DBS Prod | Infrastructure, Properties and Planning (IPP) fka Facilities | Mike Baker | EBS | College financial representatives | Detailed utility meter information / billing (electricity, steam, water,etc) | Cornell wide | Infrastructure, Properties and Planning (IPP) fka Facilities | CIT | https://computing.fs.cornell.edu:8450/fsit/tickets/default.cfm | OBIEE only | Oracle | Dimensional | M-F Complete refresh | Yes | No | dashboard level only | NO | OBIEE Answers and Dashboards | |
| Maximo | MAXIMO_DM | Maximo Prod | Infrastructure, Properties and Planning (IPP) fka Facilities | Mike Baker | Maximo | College financial representatives, Facilities professionals across campus | Facilities compliance, maintenance, and project work. | Ithaca and Geneva Campuses | Infrastructure, Properties and Planning (IPP) fka Facilities | CIT | https://computing.fs.cornell.edu:8450/fsit/tickets/default.cfm | OBIEE only | Oracle | Dimensional | M-F Complete refresh | Yes | No | dashboard level only | NO | OBIEE Answers and Dashboards | |
| Alumni | CRDM | CR 11G Prod | Alumni Affairs & Development | Tilly Garnett | PeopleSoft | Alumni Office | Alumni demographics, gift tracking | Cornell - Ithaca | ODAA | CIT | N/A | Direct connect accounts & Alumni applications | Oracle | Dimensional | M-F Complete refresh | YES | No | YES | YES | Hyperion Reports, Tableau, custom web apps | |
| Legacy Budget | Budget | Budget Prod | Division of Budget and Planning | VP, Division of Budget and Planning | CPBS | Division of Budget and Planning | Budget Workforce Planning | Cornell wide | ODAA | CIT | N/A | direct connect accounts | Oracle | Denormalized (relational) | Frozen | YES | YES - account and department driven by CPBS | YES | YES | Brio Reports | |
| Admissions Database | N/A | Admissions | Admissions | CHE Admissions Office | PeopleSoft and locally collected | CHE Admissions Office and College Depatments | PeopleSoft Adminssions data and local data entered by CHE admissions office | College wide | CHE IT | Human Ecology | N/A | Web application/reports | MSSQL Server 2008R2 | Denormalized (relational) | As Needed | Yes | Yes - Department | No | No | Tableau, ColdFusion Reports, Custom Web App | |
| Blackbooks | N/A | Blackbooks | Finance & Budget | CHE Finance & Budget Office | PeopleSoft, KFS, Workday and locally collected | CHE administration and departments | Financial, HR, Student and locally collected data used for administrative reporting | College wide | CHE IT | Human Ecology | N/A | Web application/reports | MSSQL Server 2008R2 | Denormalized (relational) | Monthly, Quarterly, Yearly and as needed | Yes | Yes - Department | No | No | Tableau, ColdFusion Reports, Custom Web App | |
| Budget Database | N/A | Budget | Finance & Budget | CHE Finance & Budget Office | KFS, Longview, Workday and locally collected | CHE administration and departments | Financial, Budget and local data entered by CHE Finance & Budget office used for administrative reporting | College wide | CHE IT | Human Ecology | N/A | Web application/reports | MSSQL Server 2008R2 | Denormalized (relational) | Monthly, Quarterly, Yearly and as needed | Yes | Yes - Department | No | No | Tableau, ColdFusion Reports, MS Access | |
| Faculty Annual Report | FAR | FAR | Academics | Associate Dean for Research and Outreach | Self reported by faculty | CHE administration and departments | Faculty reported data on yearly activities (research, publications, outreach, teaching, etc.) | College wide | CHE IT | Human Ecology | N/A | Web application/reports | MSSQL Server 2008R2 | Denormalized (relational) | Faculty can enter data on a daily basis | Yes | Yes - Department | No | No | Tableau, ColdFusion Reports, Custom Web App | |
| HR Local Database | N/A | HR_Local | HR | CHE Human Resources Office | Workday and locally collected | CHE administration and departments | HR and local data entered by CHE Human Resource office used for administrative reporting | College wide | CHE IT | Human Ecology | N/A | Web application/reports | MSSQL Server 2008R2 | Denormalized (relational) | Nightly | Yes | Yes - Department | No | No | ColdFusion Reports, Custom Web App | |
| Student Data | N/A | Students | Registrar | CHE Registrar Office | PeopleSoft Student & Admissions | CHE administration and departments | Student data used for administrative and department reporting | College wide | CHE IT | Human Ecology | N/A | Web application/reports | MSSQL Server 2008R2 | Denormalized (relational) | Nightly | Yes | Yes - Department | No | No | ColdFusion Reports, Custom Web App | |
| Admin FTE | APP_ADMIN_FTE_PROD | CAL OFA and Academic Programs | CALS OIT | KFS, WD, ADW, HRPY | CALS Academic Programs, HR | VLS | Data and calculations for use in FTE Metrics reports | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | |||||||||
| Annual Report | APP_ANNUAL_REPORT_PRODSITE | Administration | CALS OIT | Web Application (Visual Basic) | Admin | VLS | Annual Report Application | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server); Visual Studio | Crystal Reports | |||||||||
| Authorization | APP_AUTHORIZATION_PRODSITE | OIT Internal | CALS OIT | OIT Generated | Used by applications for user authorization by account structure, application and role | MAP/EAG | Users, roles and permissions | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | ||||||||||
| Billing | APP_BILLING_REGISTRY2_PROD | Financial tracking | CALS OIT | Web Application (Python) | Farms and greenhouses, Researchers, Business Service Center | EAG | R&B resource | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | In App | |||||||||
| Commitment Tracking System | CTS | APP_CTS_PRODSITE | Budgeting | CALS OIT | Web Application (Python) | Admin | MAP | Commitment Tracking System: Manages how commitments are made for faculty and staff for endowment funds. | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | ||||||||
| Efficiency | APP_EFFICIENCY_PRODSITE | Faculty Activity | CALS OIT | Activity Insight | Sr. Assoc. Deans | VLS | Reporting and calculations based on Activity Insight data | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | |||||||||
| Endowment Tracking System | ETS | APP_ETS_PRODSITE | Budgeting | CALS OIT | Web Application (Python) | Admin | MAP | Endowment Tracking System: Managing the endowment accounts and their asignment to operating accounts. | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | ||||||||
| Geneva Grants | APP_GENEVAGRANTS_PROD | Research | CALS OIT | Web Application (Python) | Geneva | MAP | Geneva Grant applications | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | In App | |||||||||
| OEH Workshops | APP_OEH_WORKSHOP | Administration | CALS OIT | Web Application (Python) | OEH | EAG | OEH workshop registration application | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | In App | |||||||||
| Office of Finance and Administration (OFA) Web site | OFA Website | APP_OFA_FRONTEND_PRODSITE | Administration | CALS OIT | Web Application (Python) | OFA | MAP | OFA Web Site | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | ||||||||
| Geneva Pesticide Application System | GPAS | APP_PESTAPPSYS_PRODSITE | Administration/Reporting | CALS OIT | Web Application (Python) | Geneva Farms, Researchers | EAG | Geneva Pesticide Application System | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | In App | ||||||||
| Plant Growth Facility Application | PGFA | APP_PGF_PROD | Administration | CALS OIT | Web Application (Python) | Farms and greenhouses, Researchers | MAP/EAG | PGF (Plant Growth Facilities) | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | In App | ||||||||
| APP_REPORTING | OIT Internal | CALS OIT | Web Application (Python) | Tableau security | VLS | All data source in one DB; Security tables for CTS and Tableau Needs clean up | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | ||||||||||
| Reservations & Billing | RnB | APP_RNB_PROD | Financial tracking | CALS OIT | Web Application (Python) | Farms and greenhouses, Researchers, Business Service Center | EAG | Reservations and Billing: Manage requests, invoicing and approval for farm greenhouse work | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | In App | ||||||||
| Salary Improvement Process | SIP | APP_SIP_CALS | HR - Payroll | CALS OIT | Web Application (Python) | Admin | EFB | Salary Improvement Process Application | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | In App | ||||||||
| APP_SIT_REGISTRY2_PROD | Administration | CALS OIT | Web Application (Python) | Farms and greenhouses | EAG | R&B application resource | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | |||||||||||
| HR Term Notice | TNS | APP_TERMNOTICE_PROD | HR - Payroll | CALS OIT | Web Application (Python) | CALS HR | EAG | HR Term Notice 2 Application | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | In App | ||||||||
| APP_UNITRAK_PROD | Administration | CALS OIT | Web Application (Python) | Farms and greenhouses | EAG | Unitrack application (pre-R&B) | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | |||||||||||
| DOMAIN_CALSDATA | Administration | CALS OIT | Web Application (Python) | CALS Budget Office | VLS | Contains tables that are still being used by the Budget Office. | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | ||||||||||
| Course | Course | DOMAIN_COURSE | Student Course Data | CALS OIT | CALS SADW Extract | OIT | VLS | Contains credit hours, instructors, course information and student information | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | ||||||||
| Domain HR | Domain HR | DOMAIN_HR_v2 | HR | CALS OIT | CIT HRPY (mirror) | CALS Reporting | MAP/VLS | HR data (pre-WD) for reporting | CALS | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | |||||||
| Domain KDW | KDW | DOMAIN_KDW_v2 | HR | CALS OIT | STAGING_KDW_2 | CALS Reporting | MAP/VLS | KDW for apps and reporting | CALS, A&S | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | |||||||
| Sponsored | Sponsored | DOMAIN_OSP | Research | CALS OIT | STAGING_OSP (CALS Dev/Test Server) | VLS | Sponsored Projects data for reporting and applications | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | |||||||||
| Domain SADW | SADW | DOMAIN_SADW | Student and Course Data | CALS OIT | CIT SADW (mirror) | CALS Reporting | VLS | Student data for reporting | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | ||||||||
| Domain WorkDay | WD | DOMAIN_WORKDAY | CALS OIT | STAGING_WORKDAY | CALS Reporting | MAP/VLS | Workday for apps and reporting | CALS | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | ||||||||
| Domain WorkDay | WD | DOMAIN_WORKDAY_v2 | HR | CALS OIT | STAGING_WORKDAY | CALS Reporting | MAP/VLS | Workday for apps and reporting (new version) | CALS | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | |||||||
| REPORTING_BLOCK_GRANT | Administration | CALS OIT | CALS Budget Office | VLS | Block grant data for reporting | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Prod server) | Tableau | |||||||||||
| ACTIVITY_INSIGHT_SOURCE_DATA | Faculty Activity | CALS OIT | Activity Insight | Dataset for annual load to AI | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Dev/Test server) | |||||||||||||
| AG_DUST | Student Services | CALS Academic Programs | Application (Foxpro, Visual C#) | Academic programs; Students, staff, advisors, OIT….etc | STI | Many uses for the CALS student services group | CALS Academic Programs | CALS | CALS Academic Programs | MS SQL 2008R2 (Dev/Test server) | Crystal Reports | ||||||||||
| ADW (legacy) | ADW | STAGING_ADW_v2 | HR | CALS OIT | ADW | MAP/VLS | Mirror of ADW raw data | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Dev/Test server) | ||||||||||
| HR (legacy) | HR | STAGING_HRPY_v2 | HR | CALS OIT | Peoplesoft HR | Conversion to DOMAIN for use in apps and reporting | MAP/VLS | Mirror of HR (pre-WD) raw data | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Dev/Test server) | |||||||||
| KDW | KDW | STAGING_KDW_v2 | Finance | CALS OIT | KDW | Conversion to DOMAIN for use in apps and reporting | MAP/VLS | Mirror of KDW raw data | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Dev/Test server) | |||||||||
| OSP | OSP | STAGING_OSP | Research | CALS OIT | Conversion to DOMAIN for use in apps and reporting | VLS/MAP | Mirror of sponsored Projects | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Dev/Test server) | ||||||||||
| SADW | SADW | STAGING_SADW | Student and Course Data | CALS OIT | Conversion to DOMAIN for use in apps and reporting | VLS/MAP | Mirror of Student DB raw data | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Dev/Test server) | ||||||||||
| Workday | WD | STAGING_WORKDAY | HR | CALS OIT | Workday Web Service | Conversion to DOMAIN for use in apps and reporting | MAP/VLS | Webservice calls to populate from Workday | CALS OIT | CALS | CALS OIT | MS SQL 2008R2 (Dev/Test server) | |||||||||
| PAD | PAD | PADPROD | Administration/Reporting | CALS OIT | Web Application (Python) | Farms, Researchers | EAG | Pesticide Application Database | CALS OIT | CALS | CALS OIT | Oracle (Prod Server) | In App | ||||||||
| CISIS | CIS Information System | CISIS DB | CIS Deans Office, CIS departments | Pat Musa | PeopleSoft, KDW | CIS Deans Office, CIS departments | aggregates accounting, budget and grad student data | CIS accounts and students only | COECIS ITSG | COECIS ITSG | N/A | Direct connect accounts | MS SQL Server | Denormalized (relational) | Refreshed daily | Yes | NO | NO | NO | NO | |
| Committee for Academic Standards, Petitions, Actions and Credits | CASPAC | CASPAC db | COE Advising | Associate Dean of Undergrad Education, College of Engineering | PeopleSoft | COE Advising | academic actions for undergrad students in the College of Engineering | Engineering undergrads only | COECIS ITSG | COECIS ITSG | N/A | Direct connect accounts | FileMaker | Denormalized (relational) | Frozen after academic action process is complete for a given semester | Yes | NO | YES | YES | NO | |
| Engineering Petitions | ENGR db | ENGR db | COE Advising | Associate Dean of Undergrad Education, College of Engineering | PeopleSoft | COE Advising | academic petitions by undergrad College of Engineering students | Engineering undergrads only | COECIS ITSG | COECIS ITSG | N/A | Direct connect accounts | FileMaker | Denormalized (relational) | Frozen after academic action process is complete for a given semester | Yes | NO | YES | YES | NO | |
| Student Budget Model | n/a | Budget Model Students | COE & CIS finance offices | Associate Deans of administration, COE and CIS | PeopleSoft SADW | COE & CIS finance offices | student class enrollments, class data, and instructor data from SADW | all class enrollments | COECIS ITSG | COECIS ITSG | N/A | Tableau, Hyperion | MS SQL Server | Denormalized (relational) | end of week 6 data, Spring and Fall semesters | Yes | NO | NO | YES | Tableau, Hyperion | |
| SEM | SEM | SEM | COE undergrad Advising | Associate Dean of Undergrad Education, College of Engineering | List of students from PeopleSoft SADW | COE undergrad Advising, Diversity Programs in Engineering | advisor meeting notes about meetings between COE advisors and students | COE students and students interested in Engineering | COECIS ITSG | COECIS ITSG | N/A | Direct connect accounts | MS Access | proprietary | always current | Yes | NO | NO | NO | NO | |
| Workday HCM | Workday HCM | N/A | HR | VP HR | Workday | HR professionals, finance and managers | HR data including position, incumbent and bio/demo data | Cornell | HR | Workday | hrpayrollsupport@cornell.edu. | UI, Web services or Batch extracts | Workday | N/A | Live | YES | YES | NO | NO | Workday Reports | |
| Workday AIS | Workday AIS | N/A | Academic | VP HR | Workday | HR professionals | Academic appointment data | Cornell | HR | Workday | hrpayrollsupport@cornell.edu. | UI, Web services or Batch extracts | Workday | N/A | Live | YES | YES | NO | NO | Workday Reports | |
| Workday Payroll | Workday Payroll | N/A | Payroll | VP Finance | Workday | Payroll | Check data, deductions, taxes | Cornell | Payroll | Workday | hrpayrollsupport@cornell.edu. | UI, Web services or Batch extracts | Workday | N/A | Live | YES | YES | NO | NO | Workday Reports | |
| AS - KFS Budget (currently frozen with move to Longview) | Finance - General Ledger | KDWPROD | College and Dept finance staff | GL Tables and KFS Budget Tables | CAS | C Sedlacek | Moving to CIT VM with work performed by CAS | Maureen Quartararo | Reporting Tools | SQL Server | Relational | Week nights during budget cycle and as needed there after | No | Yes by Dept | No | Brio and Tableau | |||||
| AS - Longview | Budget | Longview reports | College and Dept finance staff | Position Reporting, Report Cost Allocations, Export Budget Data, Report Line Item Details, and budget trend data crossing CPBS (adding), KFS, and Longview | CAS | C Sedlacek | Moving to CIT VM with work performed by CAS | Maureen Quartararo | Reporting Tools | SQL Server | Relational | Week nights during budget cycle and as needed there after | No | Yes by Dept | No | Brio and Tableau | |||||
| AS - Faculty Salaries and Promotion Reviews | HR | Local FileMaker Base Budget DB | College | Locally maintained DB showing trend in faculty salaries, including bio/demo data, time in rank, time since degree, highest degree, modified title date, etc. Anticipated promotion reviews are also performed here. Bio/demo data was fed from APDB, but now currently maintained locally. | CAS | C Sedlacek | Moving to CIT VM with work performed by CAS | C Sedlacek | Reporting Tools | SQL Server | Relational | Annual and as needed | No | Yes to College users only | No | Tableau | |||||
| AS - SIP | HR/Budget | PS HR, Workday PAIDS Report and PAIDS funding, Longview Budget data and locally entered data by the departments | College and Dept Managers/Chairs | Locally developed system that allows for the collection and reporting on Salary Improvement Process data. | CAS | C Sedlacek and Tu Tran | CAS | Sara Bloxsom | Application and reporting tools | SQL Server | Relational | Annual | Yes | Yes by Dept | No | ColdFusion, Brio and Tableau | |||||
| AS - Chairs | College | Local system for capturing this data | College and Dept Managers/Chairs | Chairs handbook, meetings, news, Department Ars (annual reports) and CVs | CAS | Tu Tran | CAS | K Gemmell | Application and reporting tools | SQL Server | Relational | N/A | Yes | Yes by Dept | No | ColdFusion and Tableau | |||||
| AS - Committee Elections | College | Local system for capturing this data | College and Dept Managers/Chairs | Faculty serving on University and College Committees | CAS | Tu Tran | CAS | K Gemmell | Application and reporting tools | SQL Server | Relational | N/A | Yes | Yes by CAS faculty and lecturers | No | ColdFusion | |||||
| AS - Annual Report | College | PS HR, PS Student, Workday, OSP, College Committees | College and Dept Managers/Chairs and staff | Annual compilations of faculty workloads including HR, course, TAs, Research, and faculty entered data (e.g. Research overview, personal statements, 3 most important things accomplished, etc.) | CAS | C Sedlacek and Tu Tran | CAS | C Sedlacek | Application and reporting tools | SQL Server | Relational | Annual | Yes | Yes by Dept | No | ColdFusion, Brio and Tableau | |||||
| AS - Workday | HR | Workday Report and Workday special requests | College | Workday person and position wsdl | CAS | C Sedlacek | Moving to CIT VM with work performed by CAS | C Sedlacek | Reporting Tools | SQL Server | Relational | Monthly | No | Yes College Level Users | No | Brio | |||||
| AS - DUST | Student | PS Student | College | DUST holds data from OUR for reporting and tracks data that OUR has not traditionally provided. Action Codes, Majors (past two), Activity Codes, Advisor Notes, and sub-application data are all data that OUR does not track (or has not at some point tracked.) | CAS | Frank Strickland | Moving to CIT VM with work performed by CAS | Brenda Lind | FoxPro 7 | SQL Server | Relational | Tuesday - Saturdays | Yes | Yes | No | ColdFusion and Visual Fox Pro which are being depricated in favor of CF | |||||
| AS - MARS | Student | PS Student | College | COI, Dean's List, Over/Under Reports, assigning of faculty advisors | CAS | Frank Strickland | Moving to CIT VM with work performed by CAS | ColdFusion | Access, SQL Server | Relational | Tuesday - Saturdays | Yes | Yes | No | ColdFusion | ||||||
| AS - Distribution Database | Student | download from PS via Access, Hand entered augmentation, reloaded to DUST via Access | College | Keeps track of what courses fill which distribution categories. | CAS | Frank Strickland | Hosted in CIT VM with work performed by CAS | Brenda Lind | FileMaker | FileMaker Server | Relational | ad hoc | No | No | No | FileMaker | |||||
| AS - OLGAA | Student | PS Student and locally entered data | Most colleges and departments | On-line grade adjustment application | Most colleges | Frank Strickland | Moving to CIT VM with work performed by CAS | College Registrars | ColdFusion | SQL Server | Relational | Tuesday - Saturdays | Yes | Yes | No | ColdFusion | |||||
| AS - OAR | Student Admissions | PS Student | College | OAR is a joint project between the colleges of Arts, CALS, Engineering, ILR, and AAP. The system provides custom reports and data entry for application data. PeopleSoft has limited real-time query capabilities so some of the above colleges need to track accept status in OAR to be able to generate on-the-fly numbers. The system is currently under development. OAR is replace Folders in the Arts College (and Engineering). | CAS, CALS, EN, ILR, and SHA | Frank Strickland | Moving to CIT VM with work performed by CAS | Brenda Lind | ColdFusion, DreamWeaver | SQL Server | Relational | Tuesday - Saturdays | Yes | Yes | No | ColdFusion | |||||
| AS - Data.Arts | Student | PS and locally maintained data | College, Department, Faculty, Students | Application to graduate, major certification, major advisor form, MARS report, EPC election | Mostly CAS but some reports specifically for AAP | Frank Strickland | Moving to CIT VM with work performed by CAS | Brenda Lind | ColdFusion | SQL Server | Relational | Tuesday - Saturdays | Yes | Yes | No | ColdFusion | |||||
| AS - Course Review | Locally entered by departments | College and Departments | Allows departments to propose new courses | CAS | Frank Strickland | Moving to CIT VM with work performed by CAS | Deb Morey | ColdFusion | SQL Server | Relational | ad hoc | Yes | Yes | No | ColdFusion | ||||||
| AS - EPC/AIHB election | Student | Applications by A&S students | College | Educational Policy Committee elections | CAS | Frank Strickland | Moving to CIT VM with work performed by CAS | Brenda Lind | ColdFusion | SQL Server | Relational | Annual | Yes | No | No | ColdFusion | |||||
| AS - Course Evals | Student | PS and local data | College | On-line course evals | CAS, CALS, HEC, ILR, EN, and PE | Frank Strickland | Moving to CIT VM with work performed by CAS | Frank Strickland, Mike Hammer, Chuck Hunt, Sue Irvine, Caroline Hecht | ColdFusion | SQL Server | Relational | Semester | Yes | Yes | No | ColdFusion | |||||
| AS - Faculty Meeting | Faculty | Data entered and managed by Dean's Executive Assistant | College | Faculty can propose motions and discussion topics. The proposed motions will go to the College Agenda Committee. Once approved, faculty can discuss and vote on it. | CAS | Frank Strickland | Moving to CIT VM with work performed by CAS | K Gemmell | ColdFusion | SQL Server | Relational | ad hoc | Yes | Yes | No | ColdFusion | |||||
| AS - College Committee Elections | Faculty | Data entered and managed by Dean's Executive Assistant | College | College Committee Elections | CAS | Frank Strickland | Moving to CIT VM with work performed by CAS | Dean's Executive Assistant | ColdFusion | SQL Server | Relational | Annual | Yes | Yes | No | ColdFusion | |||||
| AS - First-Year Writing Seminars | Student | PS and data entered by the Freshman Writing Seminar | College | Balloting for FWS classes | All FWSs | Frank Strickland | Moving to CIT VM with work performed by CAS | Bruce Roebal | ColdFusion | SQL Server | Relational | Before each semester begins | Yes | Yes | No | ColdFusion | |||||
| AS - Machine Inventory | Inventory | Locally entered data | College | Used to keep track of AS-DEANS office machines | CAS | Frank Strickland | Moving to CIT VM with work performed by CAS | Frank Strickland | ColdFusion | SQL Server | Relational | ad hoc | No | No | No | ColdFusion | |||||
| AS - Chemistry Labs Waiting List | Student | CCI | CHEM | Used to manage wait lists for chem labs | CHEM | Frank Strickland | Moving to CIT VM with work performed by CAS | Pat Hine | ColdFusion | SQL Server | Relational | PS data pulled Tuesday - Saturdays and students enter their preferences; similar to AS - Freshman Writing Seminar System | Yes | Yes | No | ColdFusion | |||||
| AS - Chemistry Grading | Student | PS and locally entered | CHEM | Used to track and disseminate grades for Chemistry courses | CHEM | Frank Strickland | FileMaker on VM and Moving to CIT VM with all work performed by CAS | Pat Hine | FileMaker and ColdFusion | SQL Server and FileMaker | Relational | ad hoc | Yes | Yes | No | ColdFusion and FileMaker | |||||
| AS - P Cards | Finance | Locally entered | CAS | Allows departments to send their Pcard recipts to BSC staff | CAS | Frank Strickland | Moving to CIT VM with work performed by CAS | Stacey Coil | ColdFusion | SQL Server | Relational | ad hoc | Yes | Yes | No | ColdFusion | |||||
| AS - Brio Hyperion Reporting | Multiple functional areas | CIT Oracle warehouses, KPI warehouse, and CAS warehouses | Colleges/Units | Brio iServer Reporting Server hosting reports across functional areas | All colleges/units | Cindy Sedlacek | CIT VM with work performed by CAS | Cindy Sedlacek | Brio iServer | Predominantly SQL Server and Oracle | Relational and multi-dimensional | Depends on the source warehouse | Yes | Yes | No | NA | Brio iServer | ||||
| AS - Base Budget DB | HR and Budget | Locally entered data | Colleges/Units | Combination of HR appointments and bio/demo data along with associated budget data | CAS | Cindy Sedlacek | CAS | Cindy Sedlacek | FileMaker and ColdFusion | FileMaker and SQL Server | Relational | Current | No | No | No | Yes | FileMaker and Tableau | ||||
| KPI | Colleges, Libraries, CIS and Research | HR, Finance, Student, Gifts | PS HR, APDB, Workday AIS, Workday HCM, SADM, CUDM, Gifts, KFS, Research, Endowments | Colleges/Units (including CIS and Libraries) and Research Administration | Data across multiple functional areas which allow for metric and mashup reporting across those functional areas that assist college executive teams in decision making | Colleges, Libraries, CIS and Research | KPI Team (Cindy Sedlacek, Kevin Murphy, and Chuck Hunt) | In a CIT VM with work performed by CHE and CAS | College Business Officers | ColdFusion | SQL Server | Relational | In general monthly with the exception of some of the Student data which is refreshed more frequently | Yes | Yes | Yes | Yes | Tableau | |||
| Cornell Research Metrics | OPVR Metrics | Research Administration | Sr Vice Provost of RA | EZRA, KDW | Dean's, Provosts, President | Research proposal, award, and expenditure metrics over time. Facts: expenditures, accounts. Dimensions: College, department, sponsor, Time (back to 2006 for expenditures, otherwise 2009) | Cornell | Research Administration Information Services (RAIS) | Research Administration Information Services (RAIS) | TBD, email rad-help@cornell.edu | Tableau reports at metrics.research.cornell.edu | MS SQL Server | Denormalized (relational) | Every month | No | No | Yes | Yes | metrics.research.cornell.edu | ||
| ORIA KPI | ORIA KPI | Research Compliance Administration | Director of ORIA | IRB (Coeus), IBC, COI, IACUC (eSerius) | ORIA leadership, Research Division leadership | Various Key performance Indicators | Cornell | Research Administration Information Services (RAIS) | Research Administration Information Services (RAIS) | No access given outside research division | Spreadsheet | Soon to be MS SQL server | Denormalized (relational) | Monthly | No | No | No | No | No | ||
| RAIS Project Tracker | RAIS Project Tracker | Research IT Administration | Director of RAIS | RAIS Project Tracker (Filemaker Database) | RAIS Director and Staff | Project Metrics: project list, business value, estimate, status, workers/roles, effort, worker slot plans, project asset links, etc. | RAIS IT Staff | Research Administration Information Services (RAIS) | Research Administration Information Services (RAIS) | No access given outside RAIS | Tableau reports | Filemaker, MS SQL Server | Denormalized (relational) | Every 4 hours | No | No | No | ? | Tableau reports | ||
|
|
HARRIS | HARRIS 11G PROD | Alumni Affairs & Development | AAD AVP Administration | PeopleSoft, iModules, CRDM | AAD | ODAA | Alumni demographics | Alumni | ODAA | CIT | Integration data store, no direct access | Via application only | Oracle | Denormalized (relational) | daily Incremental | NA | NA | NO | NO | NO |
| iModules | iModules | iModules | Alumni Affairs & Development | AAD AVP Administration | CRDM | AAD | AAD ITSG | Alumni demographics, constituent engagement data | Cornell (Ithaca, Tech) - alumni, parents, friends, faculty, staff, student, org, other engaged parties | iModules | iModules | AAD ITSG | Via web application only | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |
| Alumni CRDM | CRDM | CR 11G Prod | Alumni Affairs & Development | AAD AVP Administration | PeopleSoft | AAD | ODAA | Constituent demographics, gift data, engagement data | Cornell (Ithaca, Tech) - alumni, parents, friends, faculty, staff, student, org, other engaged parties | ODAA | CIT | N/A | Direct connect accounts & Alumni applications | Oracle | Dimensional | M-F Complete refresh | YES | No | YES | YES | Hyperion Reports, Tableau, custom web apps |
| AAD Value Added Space | VAS | Value Added Space | Alumni Affairs & Development | AAD AVP Administration | CRDM, 3rd party sources | AAD | AAD Consulting Services | Survey data, real estate info, goal data, endowment data from CRDM | Survey data, real estate info, goal data, endowment data from CRDM | AAD Consulting Services | CIT | N/A | Direct connect, Tableau, web applications | Oracle | Relational | As Needed | Yes | No | No | No | Brio, Tableau, SQL Developer |
| CUVolunteer | CUVolunteer | CUVolunteer | Alumni Affairs & Development | AAD AVP Administration | GiveGab CUVolunteer | AAD | AAD ITSG | Alumni volunteer interests and engagements | Alumni, other engaged parties | GiveGab | AWS by GiveGab | N/A | Web query, ODBC, web application | Postgres | Relational | Real-time (transactional system) | Yes | No | No | No - proprietary | Tableau, Brio |
| Donor Relations Stewardship Database | Stewardship Database | Stewardship Database | Alumni Affairs & Development | AAD AVP Administration | CRDM, SADM, KFS | AAD | AAD Consulting Services | Endowment reporting linking donors, scholarship recipients, and associated financial information | Donors | AAD Consulting Services | CIT | N/A | Application only/web application | Filemaker | proprietary | As Needed | No | No | No | No | Filemaker |
| Trustrite | Trustrite | Trustrite | Alumni Affairs & Development | AAD AVP Administration | Alumni Affairs and Development | AAD Trusts and Estates | AAD ITSG | Trust data | Trust data | Fi-Tek, Inc. | Fi-Tek, Inc. | N/A | Application only | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system |
| GiftWrap | GiftWrap | GiftWrap | Alumni Affairs & Development | AAD AVP Administration | Alumni Affairs and Development | AAD Trusts and Estates | AAD ITSG | Planned gifts | Planned gift | PG Calc | PG Calc | N/A | Application only | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system |
| doCUments | doCUments | doCUments | Alumni Affairs & Development | AAD AVP Administration | Gifts donation | AAD Advancement Services | AAD ITSG | Gift source data | Donor gift source | CIT | CIT | AAD ITSG | Web application | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system | Unknown - 3rd party system |
| All Personnel 2002 to NOW | IRP | IRP | PS PAIDS, PAIDS plus, KFS | Factbook plus | IRP | All personnel (non-student/non temp) Snapped Nov 1 each year | All personnel (non-student/non temp), salary distribution from PAIDS/KFS | IRP | IPR | Reports public, data IRP | Tableau | Flat file/Tableau extract | Nov 1 every yr | some | some | Tableau | |||||
| Acad FB Custom Extract | IRP | IRP | APDB appended with Workday data | Factbook plus | IRP | All academics in APDB and Workday (snapped 3+ times/yr) | All academics | IRP | IRP | Reports public, data IRP | Tableau | Tableau extract | 3/times yr (plus as needed) | some | some | Tableau | |||||
| Class Size | IRP | IRP | SADM | Executives | IRP | All classes, all components, snapped at end of six week of term SP/FA (Spring 09 to now) | All classes and enrollments | IRP | IRP | IRP | Tableau | Tableau extract/Flat file | Every F/S at 6th wk of term | some | some | Tableau | |||||
| Rooms with enrollment | IRP | IRP | SADM, R25, PS, SADM, Facilities Inventory | Executives | IRP/Registrar | Classroom study Fall 2015 (maybe continuing) | All classrooms with classes and enrollments (Central Cornell) | IRP/Registrar | IRP | Space Planning | Tableau | Oracle tables | End of 7th week of term | some | some | Tableau | |||||
| Degrees Conferred 2002 to Now | IRP | IRP | Bundy Files | Factbook plus | IRP | Degrees awarded 2002 to now; merged from Bundy Files | All degrees, all students | IRP | IRP | Reports public, data IRP | Tableau | Flat file | Yearly | some | some | Tableau | |||||
| Enrollment 2002 to NOW | IRP | IRP | Enrollment snaps | Factbook plus | IRP | Student enrollment snapped at 6th week of Fall term: merged | All students enrolled in good standing | IRP | IRP | Reports public, data IRP | Tableau | Flat file | Every Fall term at 6th week | some | some | Tableau | |||||
| UTDP | IRP | IRP | SADM | Budget Officers plus | IRP | All classes, snapped at end of six week of term SP/FA (Spring 09 to now) UG Only | All classes and enrollments | IRP | IRP | IRP, Budget | Tableau | Flat file | Every F/S at 6th wk of term | some | some | Tableau | |||||
| UG Graduation 1988 on | IRP | IRP | Legacy SDM/SADM | Factbook plus | IRP | UG Graduation & Retention | All UG students, all terms, graduations | IRP | IRP | Reports public, data IRP | Tableau | Flat file | Several times/yr | some | some | Tableau | |||||
| 1869 on | IRP | IRP | Trustee minutes/Legacy SDM/ Enrollment 2002 to now. | Factbook plus | IRP | Student enrollment 1869 to now | All enrollments, summarized data | IRP | IRP | Reports public, data IRP | Tableau | Flat file | Every Fall term at 6th week | some | some | Tableau | |||||
| Survey Results (various) | IRP | IRP | Survey research | Factbook plus | IRP | 50+ survey result sets | student, faculty, parent, employees survey results- manay years | IRP | IRP | access not granted | Tableau/ SPSS | Flat file | various | some | some | Tableau | |||||
| Admiss Fall 08 on | IRP | IRP | SADM | Factbook plus | IRP | Admissions July file merged | UG Applicants | IRP | IRP | IRP | Tableau | Flat file | Every July | some | some | Tableau | |||||
| Faculty 1982 to now | IRP | IRP | APDB, Workday | Executives | IRP | Faculty as of Nov 1 each year | Faculty (Acting and Clinical included) Limited variables. | IRP | IRP | IRP | Tableau | Flat file | Nov 1, every year | some | some | Tableau | |||||
| PAIDS Plus | IRP | IRP | Workday w/ SPSS syntax | Factbook, Executives, plus | IRP | Nov 1, or as needed. All Personnel | All personnel | IRP | IRP | IRP | SPSS | Flat file | Nov 1, or as needed. | some | some | SPSS, Excel | |||||
| AAUDE fles | IRP | IRP | AAUDE modified w/SPSS syntax | Executives | IRP | Peer comparisions from AAUDE | Faculty | IRP | IRP | access not granted | SPSS | Flat file | As needed | some | some | SPSS | |||||
| AAUP files | IRP | IRP | AAUP salary data w/SPSS syntax | Executives | IRP | Peer comparisions from AAU | Faculty | IRP | IRP | access not granted | SPSS | Flat file | As needed | some | some | SPSS | |||||
| Academic Insights | IRP | IRP | US News | Executives | IRP | Peer Comparisons | IRP | IRP | IRP | Flat file | As needed | some | some | ||||||||
| Academic Analytics | IRP | IRP | Academic Analytics | Executives | IRP | Peer Comparisons | Periodic downloads | IRP | IRP | IRP | Academic Analytics | Flat file | As needed | some | some | ||||||
| Runzheimer - Cost of Living | IRP | IRP | Runzheimer | none | IRP | Peer Comparisions - Cost of Living | Cost of living by University (Area) | IRP | IRP | IRP | Excel | Flat file | As needed | some | some | Excel | |||||
| APDB AER extracts | IRP | IRP | APDB | Executives | IRP | Extracts from APDB (Feb 1 and Nov1) | IRP | IRP | IRP | SPSS | Flat file | Feb 1 and Nov 1 until Workday | some | some | |||||||
| Campus Housing file | IRP | IRP | Campus Life | Executives | IRP | Used to identify housing for Surveys | All students every term | IRP | IRP | Campus Life | Excel | Flat file | Every term | some | some | ||||||
| Greek Life Participation | IRP | IRP | Frat & Sorority Affairs | Executives | IRP | Used to identify participation for Surveys | All students every term | IRP | IRP | Campus Life | Excel | Flat file | Every term | some | some | ||||||
| Enrollment snaps (Fall and Spring) | IRP | IRP | legacy SDM, SADM with value added | Factbook, external and internal reporting | IRP | Files from 1988 on. At sixth week of term and end of term. | All students every term | IRP | IRP | Reports public, data IRP | SPSS/ Excel | Flat file | Every F/S at 6th wk of term | some | some | ||||||
| Promotions/Hires/Terms | IRP | IRP | Workday with SPSS syntax | Executives and external reporting | IRP | Personnel | All personnel | IRP | IRP | IRP | SPSS | Flat file | Ads needed | some | some | ||||||
| Student/Faculty Ratios | IRP | IRP | legacy data/ Workday, SADM | Executives | IRP | IRP | IRP | Tableau | Flat file | Fall term | some | some | Tableau | ||||||||
| Daily Admissions snaps | IRP | IRP | SADM w SPSS syntax | Executives | IRP | Daily or weekly snaps. 2008 on. | UG Admissions | IRP | IRP | IRP | SPSS | Flat file | Daily or Weekly | some | some | SPSS | |||||
| Admissions July File | IRP | IRP | SADM w SPSS syntax | Executives, Factbook | IRP | Official yearly UG admissions reporting file. (1995 on) Addl files from 1987 - 1995 are available. | UG Admissions | IRP | IRP | IRP | SPSS | Flat file | Mid July | some | some | SPSS | |||||
| Bundy Files | IRP | IRP | Legacy SDM, SADM | Official External reporting (to NYS) | IRP | File for every year, 1982 on. Degrees Granted. | Degrees Granted by academic yr | IRP | IRP | IRP | Excel | Flat File | After end of academic yr | some | some |
no reviews yet
Please Login to review.
