Skip to main content

Administrative Data Store Registry

All Cornell staff can view ADSR summary data and may view detailed attributes by selecting the View button for that entry. Designated ADSR Unit Delegates can add new entries by selecting Add New Data Store and can edit existing entries by selecting the Edit button.

Update Date Operating Unit Data Steward Abbreviation Familiar Name Actions Data Set Business Name Type of Data Source Data From Data Provenance Data Scope Data Usage Narrative Audience Access Methods BI Solutions Size Metrics Data Currency Housed By Maintained By High Risk Data To Request Access Database Technology Data Model Metadata Security - Role Based Security - Row Level Table and Column Attributes Available IT Security Review
2022-10-18 Financial Affairs Vice President for Financial Affairs and University Controller ADW Accounting Data Warehouse N/A Financial Data Frozen snapshot of pre-Kuali KFS financial data mart Frozen snapshot of pre-Kuali KFS financial data mart Financial Administrators, PI s, Account Managers Hyperion Dashboards TBD Frozen as of the Kuali KFS go live. CIT ODAA http://www.dfa.cornell.edu/accounting/tools/financialinfo/ N/A
2020-02-03
2022-10-18 Information Technologies EMN Emergency Mass Notification N/A HR|Student Notification information for all persons related to Cornell. Notification information for all persons related to Cornell. EMS Service, CU Police Department NO TBD M-Sat Complete refresh AWS ODAA account ODAA Integration data store, no direct access N/A
2020-02-10
2020-02-10 Facilities Vice President, Facilities Services FIKFSDM Facilities Inventory DM N/A Facilities Facilities inventory attributes Facilities inventory attributes Facilities OBIEE Answers and Dashboards TBD M-Sat Current year refresh CIT ODAA Facilities and Campus Services - Jane VanDerzee N/A
2020-02-10
2020-02-11 Information Technologies EDW CU Person N/A Financial Data|HR|IT Data sourced from Workday, PS and KFS Common person demographic attributes used by warehouses and select campus applications Kuali Cynergy Application NO TBD M-F Complete refresh AWS ODAA account ODAA Access not available outside Cynergy application at this time. N/A
2020-02-07
2023-09-12 Human Resources Vice President, Human Resources HRPY Human Resources and Payroll Datamart N/A Financial Data|HR|Student Pre-WorkDay HR and Payroll datamart Pre-WorkDay HR and Payroll datamart HR and HR managers Hyperion Dashboards TBD frozen as of WorkDay go live (4/1/2013) AWS ODAA account ODAA https://infoaccess.adminapps.cornell.edu/hrda N/A
2020-02-10
2020-02-10 Information Technologies Vice President, Planning and Budget IDW Institutional Intelligence Data Warehouse N/A Financial Data|Health|HR|Student|Other headcount, dining, athletics, Gannett headcount, dining, athletics, Gannett BOTs and Senior Leadership Institutional Intelligence Dashboards TBD Monthly, quarterly, annual depending on metric AWS ODAA account ODAA N/A N/A
2020-02-10
2020-02-10 Financial Affairs Vice President for Financial Affairs and University Controller KDW Kuali Data Warehouse N/A Financial Data Financial, Research Financial and Labor Financial Financial, Research Financial and Labor Financial Financial Administrators, PI s, Account Managers KFS OBIEE Dashboards, Web Fin 2 TBD Updated 5X per week (Mon night - Fri night). More often if month end falls on the weekend. AWS ODAA account ODAA https://confluence.cornell.edu/display/kfsidr/Direct+Connect+Agreement_Procedures_Roles+and+Responsibilities N/A
2020-02-10
2021-09-10 Research RADM Research Administration Data Mart -- mostly frozen 7/2019 N/A Sponsored Research Sponsored project data and compliance data sourced mostly from the now retired EZRA research administration system. Primarily for reporting, no longer used. Use the RASS Datamart instead. Research Administrators, PI s RA Dashboards TBD Updated 5X per week (Mon night - Fri night) AWS ODAA account ODAA TBD N/A
2020-02-11
2021-09-10 Research OSPWH Office of Sponsored Programs Warehouse -- Frozen 7/2019 N/A Sponsored Research Research grant data Research grant data Research Administrators, PI s, College Analysts Sponsored Portal / Hyperion Reports TBD M-F Complete refresh AWS ODAA account ODAA http://www.research.cornell.edu/RAIS/SponsDW/Access/index.htm N/A
2020-02-10
2022-03-30 Student and Academic Services SADW Student Data Mart (People Soft) N/A Financial Data|Student Student Records, Admissions, Financial Aid, Student Financials Student Records, Admissions, Financial Aid, Student Financials Campus Analysts, Colleges, SAS, Admissions Office, Financial Aid Office, Bursar Office, Student Records. Hyperion Dashboards TBD M-F Complete refresh, current 3 years for large fact tables AWS ODAA account ODAA https://infoaccess.adminapps.cornell.edu/sda/portal.do N/A
2020-02-11
2020-02-11 Student and Academic Services SAVAT Student value added tables N/A Student|Other Aggregates and adds other value add datasets based off student data mart aggregates and adds other value add datasets based off student data mart Campus analysts, Colleges. NO TBD M-F Complete refresh AWS ODAA account ODAA https://infoaccess.adminapps.cornell.edu/sda/portal.do N/A
2020-02-11
2023-11-08 Graduate School Kathryn Boor GRADAID Grad Aid N/A Grad Aid Sponsored Research|Student TBD TBD OSP and SADM 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 School Web communications only. robust set of Tableau dashboards/reports via Data Solutions portal TBD M-F Complete refresh AWS ODAA account Graduate School Data Solutions no https://infoaccess.adminapps.cornell.edu/sda/portal.do TBD TBD no no no no N/A
2023-11-08
2020-02-10 Facilities Vice President, Facilities Services EBS_DM EBS - Utility Billing N/A Facilities|Financial Data Detailed utility meter information / billing (electricity, steam, water,etc) Detailed utility meter information / billing (electricity, steam, water,etc) College financial representatives OBIEE Answers and Dashboards TBD M-F Complete refresh AWS ODAA account Infrastructure, Properties and Planning (IPP) fka Facilities https://computing.fs.cornell.edu:8450/fsit/tickets/default.cfm N/A
2020-02-10
2020-02-10 Facilities Vice President, Facilities Services MAXIMO_DM Maximo N/A Facilities Facilities compliance, maintenance, and project work. Facilities compliance, maintenance, and project work. College financial representatives, Facilities professionals across campus OBIEE Answers and Dashboards TBD M-F Complete refresh AWS ODAA account Infrastructure, Properties and Planning (IPP) fka Facilities https://computing.fs.cornell.edu:8450/fsit/tickets/default.cfm N/A
2020-02-10
2020-02-10 Planning and Budget Vice President, Planning and Budget Budget Legacy Budget N/A Planning and Budget Budget Workforce Planning - legacy Budget Workforce Planning - legacy Division of Budget and Planning Brio Reports TBD Frozen AWS ODAA account ODAA N/A N/A
2020-02-10
2024-04-10 Human Ecology Rachel Dunifon N/A Admissions Database N/A Admissions Student SADW PeopleSoft Admissions data and local data entered by CHE admissions office PeopleSoft Admissions data and local data entered by CHE admissions office CHE Admissions Office and College Departments SQL, Custom App, Tableau Tableau, ColdFusion, Custom Web App TBD Daily CIT - Server Farm CHE IT N/A MSSQL Denormalized no no no N/A
2024-04-10
2024-04-10 Human Ecology Rachel Dunifon N/A Blackbooks N/A College Blackbooks Financial Data|HR|Student SADW, KDW, RASS Financial, HR, Student and locally collected data used for administrative reporting Financial, HR, Student and locally collected data used for administrative reporting CHE administration and departments SQL, Tableau Tableau, Custom Web App TBD Monthly, Quarterly, Yearly and as needed Human Ecology CHE IT no N/A SQL Server Denormalized no yes yes no N/A
2024-04-10
2024-04-10 Human Ecology Rachel Dunifon N/A Budget Database N/A Budget Database Financial Data|Planning and Budget KDW, Local Financial, Budget and local data entered by CHEFinance & Budget office used for administrative reporting Financial, Budget and local data entered by CHEFinance & Budget office used for administrative reporting CHE administration and departments SQL, Tableau, MS Access Tableau, MS Access TBD Monthly, Quarterly, Yearly and as needed Human Ecology CHE IT no N/A SQL Server, MS Access Denormalized no yes yes no N/A
2024-04-10
2024-04-10 Human Ecology Rachel Dunifon Faculty Annual Statistics Faculty Annual Statistics N/A Faculty Annual Statistics Financial Data|HR|Sponsored Research|Student SADW, KDW, RASS Data included Direct Reports, Advising Students, Class Enrollments, UG credit hours taught, accounts, OSP Awards and Proposals, and course evaluation data. Statistical data used to aid in the yearly faculty review process. CHE administration and departments SQL, Tableau Tableau TBD Daily Human Ecology CHE IT no drh222 SQL Server Denormalized no yes yes no N/A
2024-04-10
2024-04-10 Human Ecology Rachel Dunifon N/A HR Local Database N/A Workday HR Data HR|Other Workday Workday data for Active Jobs, AIS, PAIDS, and Workday Actions. HR and local data entered by CHE Human Resource office used for administrative reporting CHE administration and departments Tableau, Custom Apps, SQL ColdFusion, Tableau, Custom Web App TBD Nightly Human Ecology CHE IT no N/A SQL Server Denormalized no no no no N/A
2024-04-10
2024-04-10 Human Ecology Rachel Dunifon N/A Student N/A Student Student SADW Peoplesoft student data used for administrative and department reporting Student data used for administrative and department reporting CHE administration and departments SQL, Tableau, Custom Apps SQL, Tableau, Custom Apps TBD Nightly Human Ecology CHE IT no N/A SQL Server Denormalized no yes no no N/A
2024-04-10
2023-11-06 Agriculture and Life Sciences Vice President, Financial Affairs; Vice President, Human Resources;Sr Vice Provo KDW CALSDW N/A CALSDW Facilities|Financial Data|HR|Planning and Budget|Sponsored Research|Student KDW, SADW, RASS, Workday Brought over to our system intact and as is. For CALS internal use in reporting and applications. Access is audited annually For CALS internal use in reporting and applications. Access is audited annually OIT internal Tableau reports and administrative applications. Tableau TBD nightly, weekly and monthly depending on the table CALS CALS OIT no CALS OIT MS SQL relational no no no yes N/A
2023-11-06
2023-11-06 Agriculture and Life Sciences Vice President, Student and Academic Services DUST CALS - DUST N/A DUST Student SADW Loaded nightly from our copy of the central SADW Many uses for the CALS student services group Many uses for the CALS student services group Academic programs; Students, staff, advisors, OIT….etc DUST UI Crystal Reports TBD daily CALS CALS Academic Programs no CALS Academic Programs MS SQL Relational no no no no N/A
2023-11-06
2023-01-26 Computer and Information Sciences CISIS CISIS N/A Financial Data|HR|Planning and Budget|Sponsored Research|Student Account financials including transactions, forecasting, balances, etc. Pre- and post-award information. Grad student database including biodata, contact info, committee members, appointments, etc. Employee database including salaries and planned encumbrances. Budget and forecasting reports for CIS sponsored and non-sponsored accounts. Pre- and post-award management for sponsored research. Grad student reports and appointment tracking. Effort certification for faculty. CIS Deans, Finance, Faculty, and staff TBD Refreshed daily COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-04-13
2024-02-05 Engineering COECIS ITSG FDS COECIS Annual_Reporting N/A Faculty Data Summary HR|Sponsored Research|Student SADW, Course Evaluations, Research Expenditures data frm BSC, HR data frm ENG HR SQL/BI tools used to extract desired fields to flat file, SQL scripts perform data transformations as needed, imported into local MSSQL Server database COECIS Faculty annual reports on teaching volume and research expenditures Not used directly by other systems. Consumed by Engineering Administration. Department academic and admin directors PDF Reports generated by Hyperion Hyperion BRIO 1.7 GB, 1.2M records Once a year for annual reports COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes no no yes N/A
2024-02-05
2024-02-05 Engineering COECIS ITSG Finance COECIS Finance N/A Finance Financial Data|Planning and Budget KDW KDW COECIS Local finance database of budgets and actuals with customized reports COECIS Local finance database of budgets and actuals with customized reports COE Advising Hyperion BRIO Hyperion BRIO 4700 MB Monthly COECIS ITSG COECIS ITSG COECIS ITSG MSSQL Server Relational no no no no N/A
2024-02-05
2024-02-26 Engineering COECIS ITSG Student Budget Model COECIS Student Budget Model N/A Student Budget Model Student SADW SQL/BI tools used to extract desired fields to flat file, SQL scripts perform data transformations as needed, imported into local MSSQL Server database Student class enrollments, class data, and instructor data from SADM "Professional Masters" Tableau reports and dashboards consumed by CIS admins COE & CIS finance offices Tableau Tableau, Hyperion 10.4 GB, 17.6M records end of week 6 data, Spring and Fall semesters COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-02-26
2023-09-12 Human Resources VP HR Workday HCM Workday HCM N/A Financial Data|HR|Student Workday HR data including position, incumbent and bio/demo data, talent, recruiting HR professionals, finance and managers Workday Reports N/A Live Workday HR hrpayrollsupport@cornell.edu. PwC via CIT, 2022
2022-06-15
2022-10-18 Human Resources VP HR Workday AIS Workday AIS (Academic Information System) N/A HR Workday Academic appointment data HR professionals Workday Reports TBD Live Workday HR hrpayrollsupport@cornell.edu. N/A
2020-02-11
2022-10-18 Human Resources VP Finance Workday Payroll Workday Payroll N/A Financial Data|HR|Student Workday Check data, deductions, taxes Payroll Workday Reports TBD Live Workday Payroll hrpayrollsupport@cornell.edu. N/A
2020-02-11
2020-02-05 Arts and Sciences Vice President for Financial Affairs and University Controller AS - KFS Budget (currently frozen with move to Longview) N/A Financial Data|Planning and Budget GL Tables and KFS Budget Tables GL Tables and KFS Budget Tables College and Dept finance staff Brio and Tableau TBD Week nights during budget cycle and as needed there after Moving to CIT VM with work performed by CAS C Sedlacek Maureen Quartararo N/A
2020-02-05
2023-10-18 Arts and Sciences Vice President, Planning and Budget AS - Longview AS - Longview N/A AS - Longview Financial Data|Planning and Budget Longview Warehouse Longview Warehouse Arts & Sciences Financial and Budget data Position Reporting, Report Cost Allocations, Export Budget Data, Report Line Item Details, and budget trend data crossing CPBS (adding), KFS, and Longview College and Dept finance staff Oracle, MSSQL and Tableau Tableau TBD Week nights during budget cycle and as needed there after CIT VM with work performed by CAS C Sedlacek no Rob VanBrunt Oracle, MSSQL Relational no no yes no N/A
2023-10-18
2023-10-18 Arts and Sciences Cynthia Sedlacek AS - Faculty Salaries and Promotion Reviews AS - Faculty Salaries and Promotion Reviews N/A AS - Faculty Salaries and Promotion Reviews HR Local Base Budget DB Local Base Budget DB Locally maintained 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. College MSSQL and Tableau Tableau TBD Annual and as needed CIT VM with work performed by CAS C Sedlacek no C Sedlacek MSSQL, Tableau Relational no no yes no N/A
2023-10-18
2022-10-17 Arts and Sciences AS - SIP N/A Financial Data|HR|Planning and Budget PS, HR Worday PAIDS report and PAID funding, Longview Budget data and local data entered by the departments. Locally developed system that allows for the collection and reporting on Salary Improvement Process data. College and Dept Managers/Chairs ColdFusion, Brio and Tableau TBD Annual CAS C Sedlacek and Tu Tran Sara Bloxsom N/A
2020-02-07
2022-10-17 Arts and Sciences AS - Chairs N/A HR Chairs handbook, meetings, news, Department ARs (annual reports) and CVs Chairs handbook, meetings, news, Department ARs (annual reports) and CVs College and Dept Managers/Chairs ColdFusion and Tableau TBD N/A CAS Tu Tran K Gemmell N/A
2020-02-03
2020-02-05 Arts and Sciences AS - Committee Elections N/A HR Faculty serving on University and College Committees Faculty serving on University and College Committees College and Dept Managers/Chairs ColdFusion TBD N/A CAS Tu Tran K Gemmell N/A
2020-02-05
2020-02-05 Arts and Sciences AS - Annual Report N/A HR PS Student, Workday, OSP and college committee data 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.) College and Dept Managers/Chairs and staff ColdFusion, Brio and Tableau TBD Annual CAS C Sedlacek and Tu Tran C Sedlacek N/A
2020-02-03
2023-10-18 Arts and Sciences Cynthia Sedlacek AS - Workday AS - Workday N/A AS - Workday HR Workday Workday Workday person and position wsdl Workday person and position wsdl College Tableau Tableau TBD Monthly Moving to CIT VM with work performed by CAS C Sedlacek C Sedlacek MSSQL and Tableau Relational no no yes no N/A
2023-10-18
2022-10-17 Arts and Sciences AS - DUST N/A Student PeopleSoft data from OUR augemented by local data and history 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.) College ColdFusion and Visual Fox Pro which are being depricated in favor of CF TBD Tuesday - Saturdays Moving to CIT VM with work performed by CAS Frank Strickland Brenda Lind N/A
2020-02-05
2023-11-08 Arts and Sciences Rachel Bean MARS AS - MARS N/A AS - MARS HR|Student People Soft Student and A&S College Data Tracking of incoming matriculants Tracking of incoming matriculants College Web based ColdFusion 35,000 rows Tuesday - Saturdays CIT VM with work performed by CAS Frank Strickland no Deb Morey MS SQL Normalized no yes yes yes N/A
2023-11-08
2022-10-17 Arts and Sciences AS - Distribution Database N/A Student PeopleSoft plus local data, reloaded into DUST Keeps track of what courses fill which distribution categories. College FileMaker TBD ad hoc Hosted in CIT VM with work performed by CAS Frank Strickland Brenda Lind N/A
2020-02-05
2020-02-07 Arts and Sciences AS - OLGAA N/A Student On-line grade adjustment application On-line grade adjustment application Most colleges and departments ColdFusion TBD Tuesday - Saturdays Moving to CIT VM with work performed by CAS Frank Strickland College Registrars N/A
2020-02-07
2020-02-06 Arts and Sciences AS - OAR N/A Student OAR is a joint project between the colleges of Arts, CALS, Engineering, ILR. The system provides custom reports and data entry for application data. PS has limited real-time query capabilities so some colleges need to track accept status in OAR to be able to generate on-the-fly numbers. Colleges. A&S, CALS, ILR, ENGR, SHA ColdFusion TBD Tuesday - Saturdays CIT VM with work performed by CAS Dani Rotach - A&S Computer Support Duncan Bell N/A
2020-02-06
2020-02-05 Arts and Sciences AS - Data.Arts N/A Student Created from PeopleSoft and locally maintained data Application to graduate, major certification, major advisor form, MARS report, EPC election College, Department, Faculty, Students ColdFusion TBD Tuesday - Saturdays CIT VM with work performed by CAS Dani Rotach - A&S Computer Support Duncan Bell N/A
2020-02-05
2020-02-05 Arts and Sciences AS - Course Review N/A Other Allows departments to propose new courses Allows departments to propose new courses College and Departments ColdFusion TBD ad hoc Moving to CIT VM with work performed by CAS Frank Strickland Deb Morey N/A
2020-02-05
2022-10-17 Arts and Sciences AS - EPC/AIHB election N/A Student Educational Policy Committee elections Educational Policy Committee elections College ColdFusion TBD Annual Moving to CIT VM with work performed by CAS Frank Strickland Brenda Lind N/A
2020-02-05
2020-02-05 Arts and Sciences AS - Course Evals N/A Student PeopleSoft and local data On-line course evals College ColdFusion TBD Semester Moving to CIT VM with work performed by CAS Frank Strickland Frank Strickland, Mike Hammer, Chuck Hunt, Sue Irvine, Caroline Hecht N/A
2020-02-05
2022-11-18 Arts and Sciences AS - Faculty Meeting N/A HR Locally maintained 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. College ColdFusion TBD ad hoc Moving to CIT VM with work performed by CAS Frank Strickland K Gemmell N/A
2020-02-05
2020-02-05 Arts and Sciences AS - College Committee Elections N/A HR College Committee Elections College Committee Elections College ColdFusion TBD Annual Moving to CIT VM with work performed by CAS Frank Strickland Dean's Executive Assistant N/A
2020-02-05
2022-11-18 Arts and Sciences AS - First-Year Writing Seminars N/A Student Balloting for First Writing Seminar classes Balloting for First Writing Seminar classes College ColdFusion TBD Before each semester begins Moving to CIT VM with work performed by CAS Frank Strickland Bruce Roebal N/A
2020-02-05
2020-02-03 Arts and Sciences AS - Chemistry Labs Waiting List N/A Student Used to manage wait lists for chem labs Used to manage wait lists for chem labs CHEM ColdFusion TBD PS data pulled Tuesday - Saturdays and students enter their preferences; similar to AS - Freshman Writing Seminar System Moving to CIT VM with work performed by CAS Frank Strickland Pat Hine N/A
2020-02-03
2020-02-03 Arts and Sciences AS - Chemistry Grading N/A Student Used to track and disseminate grades for Chemistry courses Used to track and disseminate grades for Chemistry courses CHEM ColdFusion and FileMaker TBD ad hoc FileMaker on VM and Moving to CIT VM with all work performed by CAS Frank Strickland Pat Hine N/A
2020-02-03
2023-10-18 Arts and Sciences Decommissioned Decommissioned AS - Brio Hyperion Reporting N/A Decommissioned Financial Data KFS This server was decomissioned Brio Reporting Server hosting reports across multiple functional areas Brio Reporting Server hosting reports across multiple functional areas Colleges/Units Decommissioned Brio iServer TBD Depends on the source warehouse CIT VM with work performed by CAS Cindy Sedlacek no Cindy Sedlacek Decommissioned Decommissioned no no yes no N/A
2023-10-18
2023-10-18 Arts and Sciences Cynthia Sedlacek Base Budget DB AS - Base Budget DB N/A AS - Base Budget DB HR|Planning and Budget Locally entered Not applicable Combination of HR appointments and bio/demo data along with associated budget data Combination of HR appointments and bio/demo data along with associated budget data Colleges/Units Application logins FileMaker and Tableau TBD Current CAS Cindy Sedlacek no Cindy Sedlacek FileMaker Relational no no yes no N/A
2023-10-18
2023-10-18 Arts and Sciences HR, Registrar, Alumni, Finance Colleges, Libraries, CIS and Research KPI N/A KPI Alumni|Financial Data|HR|Student Workday, SADMPROD, CRDMPROD Workday, SADMPROD, CRDMPROD Data across multiple functional areas which allow for metric and mashup reporting across those functional areas that assist college executive teams in decision making 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/Units (including CIS and Libraries) and Research Administration Oracle, MSSQL and Tableau Tableau TBD In general monthly with the exception of some of the Student data which is refreshed more frequently In a CIT VM with work performed by CAS Cynthia Sedlacek and Gary Chaika no College Business Officers MSSQL Relational no no yes no N/A
2023-10-18
2020-02-07 Research Sr Vice Provost of RA Cornell Research Metrics N/A Financial Data|HR|Sponsored Research Sponsored Research, Financial and unit/departmental Research proposal, award, and expenditure metrics over time. Facts: expenditures, accounts. Dimensions: College, department, sponsor, Time (back to 2006 for expenditures, otherwise 2009) Dean's, Provosts, President metrics.research.cornell.edu TBD Every month Research Administration Information Services (RAIS) Research Administration Information Services (RAIS) TBD, email rad-help@cornell.edu N/A
2020-02-07
2020-02-10 Research Director of ORIA ORIA KPI N/A Sponsored Research Various Key performance Indicators Various Key performance Indicators ORIA leadership, Research Division leadership No TBD Monthly Research Administration Information Services (RAIS) Research Administration Information Services (RAIS) No access given outside research division N/A
2020-02-10
2021-09-10 Research Director of RAIS RAIS Project Tracker -- Retired N/A Sponsored Research Project Metrics: project list, business value, estimate, status, workers/roles, effort, worker slot plans, project asset links, etc. Project Metrics: project list, business value, estimate, status, workers/roles, effort, worker slot plans, project asset links, etc. RAIS Director and Staff Tableau reports TBD Every 4 hours Research Administration Information Services (RAIS) Research Administration Information Services (RAIS) No access given outside RAIS N/A
2020-02-11
2020-02-07 Alumni Affairs and Development Vice President for Alumni Affairs and Development iModules CU Connect N/A Alumni Sourced from PS CRDM and iModules Alumni demographics AAD NO TBD daily Incremental AWS ODAA account ODAA Integration data store, no direct access N/A
2020-02-07
2020-02-10 Alumni Affairs and Development AAD AVP Administration iModules iModules N/A Alumni Alumni demographics, constituent engagement data Alumni demographics, constituent engagement data AAD N/A TBD N/A iModules iModules AAD ITSG N/A
2020-02-10
2020-02-11 Alumni Affairs and Development AAD AVP Administration CRDM Alumni CRDM N/A Alumni PeopleSoft CRDM Constituent demographics, gift data, engagement data AAD Hyperion Reports, Tableau, custom web apps TBD M-F Complete refresh CIT ODAA N/A N/A
2020-02-11
2020-02-03 Alumni Affairs and Development Vice President for Alumni Affairs and Development VAS AAD Value Added Space N/A Alumni|Facilities|Planning and Budget Survey data, real estate info, goal data, endowment data from CRDM Survey data, real estate info, goal data, endowment data from CRDM AAD Brio, Tableau, SQL Developer TBD As Needed CIT AAD Consulting Services N/A N/A
2020-01-31
2023-02-28 Alumni Affairs and Development AAD AVP Administration CUVolunteer CU Volunteer N/A Alumni Data housed by GiveGab at AWS Alumni volunteer interests and engagements Match alumni volunteers with volunteer opportunities that align with their skills and interests AAD Tableau, Brio TBD Real-time (transactional system) AWS by GiveGab GiveGab N/A N/A
2020-02-07
2020-02-10 Alumni Affairs and Development AAD AVP Administration Stewardship Database Donor Relations Stewardship Database N/A Alumni|Financial Data Endowment reporting linking donors, scholarship recipients, and associated financial information Endowment reporting linking donors, scholarship recipients, and associated financial information AAD Filemaker TBD As Needed CIT AAD Consulting Services N/A N/A
2020-02-10
2020-02-11 Alumni Affairs and Development AAD AVP Administration Trustrite Trustrite N/A Alumni|Financial Data Trust data Trust data AAD Trusts and Estates Unknown - 3rd party system TBD Unknown - 3rd party system Fi-Tek, Inc. Fi-Tek, Inc. N/A N/A
2020-02-11
2020-02-10 Alumni Affairs and Development AAD AVP Administration GiftWrap GiftWrap N/A Alumni Planned gifts Planned gifts AAD Trusts and Estates Unknown - 3rd party system TBD Unknown - 3rd party system PG Calc PG Calc N/A N/A
2020-02-10
2020-02-10 Alumni Affairs and Development Vice President for Alumni Affairs and Development GPS / doCUments GPS / doCUments N/A Alumni Donor gift source data Donor gift source data AAD Advancement Services Unknown - 3rd party system TBD Daily CIT CIT AAD ITSG N/A
2020-02-10
2020-02-03 Planning and Budget IRP All Personnel 2002 to NOW N/A HR All personnel (non-student/non temp) Snapped Nov 1 each year All personnel (non-student/non temp) Snapped Nov 1 each year Factbook plus Tableau TBD Nov 1 every yr IPR IRP Reports public, data IRP N/A
2020-02-03
2020-02-03 Planning and Budget IRP Academic Factbook Custom Extract N/A HR All academics in APDB and Workday (snapped 3+ times/yr) All academics in APDB and Workday (snapped 3+ times/yr) Factbook plus Tableau TBD 3/times yr (plus as needed) IRP IRP Reports public, data IRP N/A
2020-02-03
2020-02-07 Planning and Budget IRP Class Size N/A Student Sourced from SADM All classes, all components, snapped at end of six week of term SP/FA (Spring 09 to now) Executives Tableau TBD Every F/S at 6th wk of term IRP IRP IRP N/A
2020-02-07
2020-02-11 Planning and Budget Rooms with enrollment N/A Facilities|Student|Other PS student data mart, R25, Facilities inventory Classroom study Fall 2015 (maybe continuing) Executives Tableau TBD End of 7th week of term IRP IRP/Registrar Space Planning N/A
2020-02-11
2020-02-07 Planning and Budget IRP Degrees Conferred 2002 to Now N/A Student Sourced from SADM. Merged with Bundy files. Degrees awarded 2002 to now; merged from Bundy Files Factbook plus Tableau TBD Yearly IRP IRP Reports public, data IRP N/A
2020-02-07
2020-02-10 Planning and Budget IRP Enrollment 2002 to NOW N/A Student Student enrollment snapped at 6th week of Fall term: merged Student enrollment snapped at 6th week of Fall term: merged Factbook plus Tableau TBD Every Fall term at 6th week IRP IRP Reports public, data IRP N/A
2020-02-10
2020-02-11 Planning and Budget IRP UTDP N/A Student Sourced from SADM All classes, snapped at end of six week of term SP/FA (Spring 09 to now) UG Only Budget Officers plus Tableau TBD Every F/S at 6th wk of term IRP IRP IRP, Budget N/A
2020-02-11
2020-02-11 Planning and Budget IRP UG Graduation 1988 on N/A Student Legacy SDM and SADM UG Graduation & Retention Factbook plus Tableau TBD Several times/yr IRP IRP Reports public, data IRP N/A
2020-02-11
2020-01-30 Planning and Budget IRP 1869 on N/A Student Student enrollment 1869 to now Student enrollment 1869 to now Factbook plus Tableau 5 MB Every Fall term at 6th week IRP IRP Reports public, data IRP N/A
2020-01-30
2020-02-11 Planning and Budget IRP IRP Survey Results (various) N/A Other Student, faculty, parent, employee survey results across many years 50+ survey result sets. Student, faculty, parent, employee survey results across many years. Factbook plus Tableau TBD various IRP IRP access not granted N/A
2020-02-11
2020-02-03 Planning and Budget IRP Admiss Fall 08 on N/A Student Admissions July file merged Admissions July file merged Factbook plus Tableau TBD Every July IRP IRP IRP N/A
2020-02-03
2020-02-10 Planning and Budget IRP Faculty 1982 to now N/A HR Faculty as of Nov 1 each year Faculty as of Nov 1 each year Executives Tableau TBD Nov 1, every year IRP IRP IRP N/A
2020-02-10
2020-02-10 Planning and Budget IRP PAIDS Plus N/A HR All Personnel Nov 1, or as needed. All Personnel Nov 1, or as needed. Factbook, Executives, plus SPSS, Excel TBD Nov 1, or as needed. IRP IRP IRP N/A
2020-02-10
2020-02-03 Planning and Budget IRP AAUDE fles N/A Other Peer comparisons from AAUDE https://aaude.associationsonline.com/site_home.cfm Peer comparisions from AAUDE https://aaude.associationsonline.com/site_home.cfm Executives SPSS TBD As needed IRP IRP access not granted N/A
2020-02-03
2020-02-03 Planning and Budget IRP AAUP files N/A Other Peer comparisions from AAU https://aausports.org/ Peer comparisions from AAU https://aausports.org/ Executives SPSS TBD As needed IRP IRP access not granted N/A
2020-02-03
2020-02-03 Planning and Budget IRP Academic Insights N/A Other Peer comparisons via US News and World Reports Peer comparisons via US News and World Reports Executives TBD As needed IRP IRP IRP N/A
2020-02-03
2020-02-03 Planning and Budget IRP Academic Analytics N/A HR Peer Comparisions https://academicanalytics.com/ Peer Comparisons https://academicanalytics.com/ Executives TBD As needed IRP IRP IRP N/A
2020-02-03
2020-02-11 Planning and Budget IRP Runzheimer - Cost of Living N/A Financial Data Peer Comparisions - Cost of Living Peer Comparisions - Cost of Living none Excel TBD As needed IRP IRP IRP N/A
2020-02-11
2020-02-03 Planning and Budget IRP APDB AER extracts N/A HR Extracts from Academic Personnel Database (Feb 1 and Nov1) Extracts from Academic Personnel Database (Feb 1 and Nov1) Executives TBD Feb 1 and Nov 1 until Workday IRP IRP IRP N/A
2020-02-03
2020-02-07 Planning and Budget IRP Campus Housing file N/A Student Sourced from SaCL Used to identify housing for Surveys. All students every term. Executives TBD Every term IRP IRP Campus Life N/A
2020-02-07
2020-02-10 Planning and Budget IRP Greek Life Participation N/A Student|Other Used to identify participation for Surveys Used to identify participation for Surveys Executives TBD Every term IRP IRP Campus Life N/A
2020-02-10
2020-02-10 Planning and Budget IRP Enrollment snaps (Fall and Spring) N/A Student Files from 1988 on. At sixth week of term and end of term. Files from 1988 on. At sixth week of term and end of term. Factbook, external and internal reporting TBD Every F/S at 6th wk of term IRP IRP Reports public, data IRP N/A
2020-02-10
2020-02-11 Planning and Budget IRP Promotions/Hires/Terms N/A HR All personnel - promotions, hires and term positions All personnel - promotions, hires and term positions Executives and external reporting TBD Ads needed IRP IRP IRP N/A
2020-02-11
2020-02-11 Planning and Budget IRP Student/Faculty Ratios N/A HR|Student Legacy data plus Workday HR and SADM Prepared for executive review Executives Tableau TBD Fall term IRP IRP IRP N/A
2020-02-11
2020-02-07 Planning and Budget IRP Daily Admissions snaps N/A Student Data sourced from SADM Daily or weekly snaps. 2008 on. Executives SPSS TBD Daily or Weekly IRP IRP IRP N/A
2020-02-07
2020-02-03 Planning and Budget IRP Admissions July File N/A Student Official yearly UG admissions reporting file. (1995 on) Addl files from 1987 - Official yearly UG admissions reporting file. (1995 on) Addl files from 1987 - 1995 are available. Executives, Factbook SPSS TBD Mid July IRP IRP IRP N/A
2020-02-03
2020-02-07 Planning and Budget IRP Bundy Files N/A Student Legacy Student Datamart and SADM Official External reporting to NYS. File for every year, 1982 on. Degrees Granted. Official External reporting (to NYS) TBD After end of academic yr IRP IRP IRP N/A
2020-02-07
2020-02-11 Provost Admissions Self Service N/A Other Admissions self service Admissions self service TBD N/A
2020-02-11
2020-02-10 Facilities Vice President, Facilities Services Maximo_DM2 Maximo2 N/A Facilities Facilities compliance, maintenance, and project work. Facilities compliance, maintenance, and project work. College financial representatives, Facilities professionals across campus OBIEE Answers and Dashboards TBD M-F Complete refresh AWS ODAA account CIT https://computing.fs.cornell.edu/8450/fsit/tickets/default.cfm N/A
2020-02-10
2020-02-07 Financial Affairs Vice President for Financial Affairs and University Controller Concur Concur Travel and Expense System N/A Financial Data Concur provides access via web services as well as a data warehouse. University travel information via Concur. Concur provides access via web services as well as a data warehouse. Cornell administrators responsible for monitoring travel activity and expense Cognos TBD Real time for web services. Nightly for Cognos DW Financial Information Services Financial Information Services mailto:concur-support@cornell.edu N/A
2020-02-07
2022-10-18 Financial Affairs Vice President for Financial Affairs and University Controller Travel Legacy Travel System N/A Financial Data Legacy travel data from 2004 to 2019. Legacy travel data from 2004 to 2019. This system was replaced by Concur through a staged rollout from 2017 to 2019. Limited access by reporting experts. About 375,000 trip expense reports Real time CIT CIT mailto:kfs-support@cornell.edu N/A
2020-02-10
2023-01-26 Computer and Information Sciences GUMBI Group User Management and Billing N/A Other Tracks CS account information for billing purposes Tracks CS account information for billing purposes CIS Dean TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-04-13
2023-01-26 Computer and Information Sciences CMSX Course Management System N/A Student Course management database including student enrollments and grades. Enrollment info may be downloaded from SADM. Local course management system used by CIS as a replacement for Canvas CIS faculty and students TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-05-12
2022-11-07 NYC Tech Tech Emergency Alerts N/A HR|Student Name, email, cell phone information pulled from Workday and the student datamart based on Tech campus location. Contact info for Tech community to receive emergency alerts from security and facilities teams at Tech. Tech faculty, staff, students TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2020-12-22
2023-01-26 Engineering acalog db acalog db N/A Student Copy of Courses of study in local SQL Server for college websites Copy of Courses of study in local SQL Server for college websites Engineering and CIS students TBD Nightly COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-04-13
2023-01-26 Engineering Engineering Petitions N/A Student Student petitions; majors, netids, visa status, CUID, course Student petitions; majors, netids, visa status, CUID, course Engineering Advising TBD Frozen after academic action process is complete for a given semester COECIS ITSG COECIS ITSG COECIS ITSG N/A
2020-10-22
2024-02-06 Engineering COECIS ITSG Freshman scheduling Freshman scheduling N/A Freshman scheduling Student SADW, web application, FileMaker SQL/BI tools used to extract desired fields to flat files, imported to FileMaker Freshmen student names, IDs, classes, advisors Collects incoming student data from web application and SADW to assist in creation of first term schedules Engineering Advising, Admissions, and Registrar FileMaker applications, Frosh web application N/A 1.8 MB, 800 records Once a year, late June COECIS ITSG COECIS ITSG COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-02-06
2024-02-07 Engineering COECIS ITSG Frosh-Fall Frosh-Fall (FileMaker) N/A Frosh-Fall Student SADW, Engineering Admissions, web application SQL/BI tools used to extract desired fields to flat files, imported into MS SQL Server and FIleMaker Incoming Freshmen student names, IDs, classes, advisors, major interests, AP test scores Math diagnostic exam, Student Advising Profile App, New Student Checklist website, Frosh FileMaker databases Engineering Advising, Admissions, and Registrar, plus CALS BEE Student Services FileMaker applications, Frosh web application N/A 170 MB, 10k records Weekly in spring/summer COECIS ITSG COECIS ITSG no COECIS ITSG FileMaker Relational yes yes no yes N/A
2024-02-07
2024-02-26 Engineering COECIS ITSG Student Library COE Student Library N/A Student Library Student SADW SQL/BI tools used to extract desired fields to flat file, various transformations made via Foxpro script, imported into FileMaker database on FileMaker server Eng UG Student Library; names, status, class, major, gender, GPA, IDs, contact information Multiple local databases and applications use as a student-lookup database, e.g. frosh, advisors, etc. Engineering student services, Engineering dept admins FileMaker client or FileMaker web application N/A 37 MB, 17k records Weekly COECIS ITSG COECIS ITSG no COECIS ITSG FileMaker Relational yes yes no yes N/A
2024-02-26
2023-01-26 Engineering MSE GRA Database N/A Student Multiple DBs; grad names, IDs, advisors, majors, status, photo, tuition Multiple DBs; grad names, IDs, advisors, majors, status, photo, tuition MSE staff TBD COECIS ITSG MSE COECIS ITSG N/A
2020-11-04
2023-01-26 Computer and Information Sciences CIS Affiliations Applications N/A Student Database of students applying to affiliate with CIS majors including Names, CUID, NetID, Major, courses, interests, college, contact info, etc. - Sourced from SADM and local CIS applications CIS undergrad coordinators review applications and approve students to affiliate with the major. CIS undergrad coordinators and students applying to affiliate with a major TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2020-11-04
2023-01-27 Computer and Information Sciences CS UnderGrad DB N/A Student Sourced from SADM and local data. CS student names, GPA, majors, advisors, status, contact info, photos, etc. CS undergrad coordinator TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2020-11-02
2024-01-02 Computer and Information Sciences COECIS ITSG CoeCISCheckList CIS Degree Audit Checklists N/A CISCheckList Student SADW SADW CS/IS degree progress using student transcripts including enrollments and grades CIS undergrad advisors prepare degree audit checklists and share them with the student majors and their advisors. CS/IS undergrad advisors, faculty advisors and majors application role access n/a 1430 MB daily COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server, FileMaker Relational no yes no no N/A
2024-01-02
2024-01-02 Computer and Information Sciences COECIS ITSG ta_hiring CIS TA Hiring N/A ta_hiring Student application user form entries Student contact info + grades in some courses CIS undergrad students applying for a TA position for CIS courses CIS students, faculty, staff Application role access n/a 51 MB when application is running COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational no yes no no N/A
2024-01-02
2024-01-02 Computer and Information Sciences COECIS ITSG BOOM BOOM Research Projects N/A BOOM Student application user form entries BOOM student presenter contact info and their resumes. The databases maintained are boom, boom_dev BOOM student presenter contact info and their resumes BOOM student presenters Web application; MSSQL Server Studio n/a 13 MB every day when application is running COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational no yes no no N/A
2024-01-02
2023-01-26 Computer and Information Sciences IS Majors N/A Student Student Names, NetID, EmplID, college, major, class, expected grad term, photos Student Names, NetID, EmplID, college, major, class, expected grad term, photos IS undergrad coordinator TBD COECIS ITSG IS COECIS ITSG N/A
2020-11-04
2023-01-26 Computer and Information Sciences CS Incoming Affiliations N/A Student CS student names, GPA, advisors, status, contact info, demographics, etc. CIS student services need to tracking new affiliated students with the CIS majors. CS undergrad coordinator TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2020-11-04
2024-01-02 Computer and Information Sciences COECIS ITSG cis_room_requests CIS Space Inventory N/A cis_room_requests Facilities|Financial Data application user form entries Security card access system, space inventory, CISIS Account distributions by person (faculty, staff, students) for each CIS room CIS Dean Users assigned as admins n/a TBD not getting updated COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational no yes no no N/A
2024-01-02
2023-01-26 Computer and Information Sciences CS Course Prereq Reporting N/A Student Student grades and courses Student majors and grades for fulfilling CS course pre-requisites. CS staff and faculty TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-07-02
2024-01-02 Computer and Information Sciences COECIS ITSG cis_meng_projects CIS MEng Projects N/A cis_meng_projects Student application user form entries Local data CIS faculty and MEng students working on CIS MEng Projects CIS MEng students and faculty with MEng projects application role access n/a 11 MB when application is running COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational no yes no no N/A
2024-01-02
2024-02-06 Engineering COECIS ITSG DAR Door Access Request database N/A DAR Facilities|HR|Student Faculty, staff, student fill out requests to access rooms in Engineering user form entries Faculty, staff, student fill out requests to access rooms in Engineering Faculty, staff, student fill out requests to access rooms in Engineering People who need to request access to rooms in Engineering N/A N/A 144 MB when application is running COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-02-06
2023-01-26 Engineering wass COECIS Web Appointment Scheduling System N/A Student|Other Engineering students schedule meetings with Career Services Engineering students schedule meetings with Career Services Engineering students and Career Services staff TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-05-12
2023-01-27 Engineering ECE Majors N/A Student ECE UG names, CUIDs, gender, ethnicity, citizenship, class, major ECE UG names, CUIDs, gender, ethnicity, citizenship, class, major ECE undergrad staff TBD COECIS ITSG ECE COECIS ITSG N/A
2020-10-22
2024-02-07 Engineering COECIS ITSG FrozenFiles Undergrad DB FrozenFiles Undergrad DB N/A FrozenFiles Undergrad DB Student SADW Table within ENDM database. SQL/BI tools used to extract desired fields to flat files, imported into MS SQL Server. UG Name, college, major, ID, visa, diversity, advisors UG Name, college, major, ID, visa, diversity, advisors Engineering Registrar MSSQL Server Mgmt Studio, Hyperion Hyperion BRIO 250 MB, 180k records Week 6 of Fall, Spring COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-02-07
2024-02-07 Engineering COECIS ITSG Grade Slips Grade Slips N/A Grade Slips Student SADW SQL/BI tools used to extract desired fields to flat files, imported to FileMaker Student names, courses, grades, advisors, class FileMaker application Engineering Registrar, Engineering dept admins FileMaker application N/A 39 MB, 24k records End of Fall, Spring COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-02-07
2024-02-20 Engineering COECIS ITSG MEng Students Library MEng Students Library N/A MEng Students Library Student SADW SQL/BI tools used to extract desired fields to flat files, imported to FileMaker MEng/MPS student names, IDsterm, degree, major, diversity, credits, addresses FileMaker application Engineering Registrar, MEng administrators FileMaker application N/A 24MB, 12k records Daily Tues-Sat COECIS ITSG COECIS ITSG no COECIS ITSG FileMaker Relational yes yes no no N/A
2024-02-20
2024-02-05 Engineering COECIS ITSG UNAFL 2-2 COECIS Unaffiliated 2-2s N/A Unaffiliated 2-2 Database Student SADW SQL/BI tools used to extract desired fields to flat file, imported into FileMaker database on FileMaker server COECIS sophomores (second years) without majors COECIS sophomores (second years) without majors Engineering Advising FileMaker client or FileMaker web application n/a <1 MB, <500 records 1-3 times in fall and spring, or upon request COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-02-05
2023-01-27 Engineering MSE Accounts DB N/A Financial Data|Student MSE Grad names, accounting info MSE Grad names, accounting info MSE grad office TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2020-11-02
2023-01-26 Engineering MSE MS/MEng Students N/A Student MSE MS/MEng student names, IDs, advisors, majors, citizenship, ethnicity, status MSE MS/MEng student names, IDs, advisors, majors, citizenship, ethnicity, status MSE staff TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2020-11-04
2024-02-05 Engineering COECIS ITSG Contact Hours Contact Hours N/A Contact Hours Student|Other Deprecated Contact Hours FileMaker database; Faculty Data Summary SQL/BI tools used to extract desired fields to flat file, SQL scripts perform data transformations as needed, imported into local MSSQL Server database Sourced from SADM and local data Course enrollments and credit hours Engineering Finance Deprecated Contact Hours FileMaker database, no longer actively used. Data now a N/A 300 MB, 763k records Annually, beginning of the CY COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes no no yes N/A
2024-02-05
2023-01-26 Engineering Engineering Leaves N/A Student Student contact info while on leave Student contact info while on leave Engineering Registrar TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-07-02
2023-01-26 Engineering MAE Datamart N/A Student MAE grad students including biodata and appointment tracking MAE (Mechanical and Aerospace Engineering) grad students including biodata and appointment tracking MAE staff TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2020-11-01
2023-01-26 Engineering MEng Projects N/A Student CoE students working on CoE Meng Projects with faculty CoE students working on CoE Meng Projects with faculty Engineering faculty and MEng students TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-07-02
2023-01-26 Engineering MEng Survey Results N/A Alumni|Student MEng alumni survey data including starting salaries MEng alumni survey data including starting salaries Engineering MEng TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-07-02
2024-02-20 Engineering COECIS ITSG TA Eval TA Eval N/A TA Eval Student SADW, web application SQL/BI tools used to extract desired fields to flat files, imported to MSSQL Server TA Names, NetID, Student enrollments, diversity, citizenship for CoE classes TA Names, NetID, Student enrollments, diversity, citizenship for CoE classes Students taking Engineering courses Web Application N/A 1.5 MB, 1.8 million records Spring and fall COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-02-20
2024-01-02 Engineering COECIS ITSG AEW Evals Academic Excellence Workshop Evals N/A AEW Student SADW, LDAP SQL/BI tools used to extract desired fields to flat file, imported into local MSSQL Server database AEW TA evals; AEW enrollments. The database maintained are AEWMTEval AEWMTEval_dev AEW TA evals; AEW enrollments Students taking AEW classes Web application; MSSQL Server Studio n/a 73 MB; 70k records Mid-semester, both fall and spring COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-01-02
2023-01-26 Engineering COE Student Project Funding N/A Student COE Student names and contacts for requesting project funding COE Student names and contacts for requesting project funding Engineering dean TBD COECIS ITSG COECIS ITSG N/A
2021-04-13
2023-01-26 Engineering Cornell Directory N/A Student Engineering students in LDAP Local SQL DB of LDAP directory including student names, emails, emplids, etc. IT Service group TBD Daily COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-04-13
2024-02-06 Engineering COECIS ITSG Course Eval Course Eval N/A Course Eval Student|Other SADW SQL/BI tools used to extract desired fields to flat file, various transformations made via Foxpro script, imported into FileMaker database on FileMaker server Sourced from SADM and local data Course Eval questions and answers; enrollments, names, netids, college, diversity ELI and students taking Engineering classes Web application N/A 200 MB, 50k records Each end-of-term course eval season. COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-02-06
2024-02-06 Engineering COECIS ITSG ENDM ENDM N/A ENDM; Frozen Files (in part) Student Student FM Library, BI Tools SQL/BI tools used to extract desired fields to flat file, SQL scripts perform data transformations as needed, imported into local MSSQL Server database Frozen files (MEng, UG); grad student netids, majors; MEng student info; Foxpro scripts use some ENDM tables as lookup tables for Student FM Database load. Used by for data delivery, and by Engineering Registrar. Local IT staff, Engineering Registrar N/A Hyperion Brio 1.5 GB, 1.2M records Week 6 in Fall and Spring COECIS ITSG COECIS ITSG COECIS ITSG MSSQL Server Relational yes no no yes N/A
2024-02-06
2023-01-26 Engineering Coop Offers N/A Student Tracking students who do a co-op (job) Tracking students who do a co-op (job) Engineering Career Services TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-04-13
2024-02-06 Engineering COECIS ITSG ENGRG 1050 ENGRG 1050 N/A ENGRG 1050 Surveys Student SADW, Peer Advisor lists from Eng Advising SQL/BI tools used to extract desired fields to flat files, imported into Qualtrics ENGRG 1050 enrollments ENGRG 1050 enrollments Engineering Student Services Qualtrics N/A 70 kb, 1000 records Once a year, late November COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational no yes no no N/A
2024-02-06
2023-01-26 Computer and Information Sciences Kayako helpdesk N/A HR|Student Ticket system reporting include names, emails, affiliation for faculty, students Ticket system reporting CoE/CIS/Tech community TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-05-12
2024-02-20 Engineering COECIS ITSG ugResearch Ugrad research project tracking N/A Ugrad research project tracking Student Application User form entries Ugrad research project tracking Ugrad research project tracking Engineering Learning Initiatives N/A N/A 110 MB When application is running COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational no yes yes no N/A
2024-02-20
2020-02-03 Architecture, Art, and Planning AAPFM AAP Filemaker N/A Student Names, NetID, EmplID, college, major, class, expected grad term, emplr address Names, NetID, EmplID, college, major, class, expected grad term, emplr address AAP Staff None TBD daily CIT AAP IT Solutions N/A N/A
2020-02-03
2020-02-03 Architecture, Art, and Planning AAPAI AAP Activity Insight N/A HR Faculty tracking, publications, honors, degrees, classes taught, evaluations Faculty tracking, publications, honors, degrees, classes taught, evaluations AAP Faculty, Staff, and Administration None TBD dailty Digital Measures Rosane Mordt N/A N/A
2020-02-03
2020-02-03 Architecture, Art, and Planning AAPSE AAP Smart Evals N/A Student Course evaluations Course evaluations Students, Faculty, Administration None N/A real time GAP Technologies, Inc. Rosane Mordt N/A N/A
2020-02-03
2023-11-06 Agriculture and Life Sciences Vice President, Human Resources CALS Admin org (Salesforce) CALS Admin Org on Salesforce N/A CALS Admin org (Salesforce) HR|Student|Other SADW, Workday Data is loaded nightly from our local copy of SADW and Workday feeds. Employees/Grad Student records are updated from Workday, SADW, and CollegeNet. Used by CALS Dean's office, CALS OPPEL, CALS Dairy Extension, CALS Graduate FRS, CALS HR CALS Dean's office; CALS OPPEL, CALS Dairy Extension, CALS Graduate FRS, CALS HR Salesforce UI Salesforce Reports TBD Nightly Salesforce CALS OIT no CALS OIT Salesforce n/a no yes no no N/A
2023-11-06
2023-01-27 Engineering asst_dean_funding COE asst_dean_funding N/A Financial Data|Student CoE to provide project funding for engineering related activities for students. The databases maintained are asst_dean_funding asst_dean_funding_dev CoE to provide project funding for engineering related activities for students Engineering Students, Dean TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-04-13
2024-02-07 Engineering COECIS ITSG Frosh Advisors Frosh Advisors N/A Frosh Advisors Student SADW, web application, FileMaker SQL/BI tools used to extract desired fields to flat files, imported to FileMaker Used by Advising and Registrar to split incoming Frosh into certain COE classes Frosh FileMaker databases Engineering Registrar and Advising FileMaker applications N/A 2 MB, 500 records Annually, spring COECIS ITSG COECIS ITSG no COECIS ITSG FileMaker Relational yes yes no yes N/A
2024-02-07
2024-02-20 Engineering COECIS ITSG PEAS PEAS N/A Pre-Enroll Approval System Student SADW, web application SQL/BI tools used to extract desired fields to flat files, imported to MSSQL Server PEAS data (advising); freshmen names, CUIDs, majors, contact info PEAS data (advising); freshmen names, CUIDs, majors, contact info EN Registrar Web Application N/A 12 MB, 900 records Right before spring and fall pre-enroll COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes yes yes N/A
2024-02-20
2024-02-06 Engineering COECIS ITSG EN_Forms EN Forms N/A EN_Forms Other Application User form entries Various entry forms for small EN, ITSG projects Various entry forms for small EN, ITSG projects Students, faculty, staff N/A N/A 18 MB When application is running COECIS ITSG COECIS ITSG COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-02-06
2024-02-06 Engineering COECIS ITSG EN_Surveys EN Surveys N/A EN_Surveys Other Application Data attestation submissions, other small surveys data Data attestation submissions, other small surveys data Data attestation submissions, other small surveys data Students, faculty, staff N/A N/A 60 MB When application is running COECIS ITSG COECIS ITSG COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-02-06
2024-02-06 Engineering COECIS ITSG FacultyAdvisors Faculty Advisors N/A Faculty Advisors Student SADW SQL/BI tools used to extract desired fields to flat files, imported to FileMaker Record per Faculty Advisor, including archived versions of records. Updated automatically daily. Student look-up FileMaker databases Engineering Advising, Registrar FileMaker applications N/A 5 MB, 4k records Daily COECIS ITSG COECIS ITSG no COECIS ITSG FileMaker Relational yes yes no yes N/A
2024-02-06
2024-02-07 Engineering COECIS ITSG FROSH Response FROSH Response N/A FROSH Response Student SADW, web application, FileMaker SQL/BI tools used to extract desired fields to flat files, imported into MS SQL Server and FIleMaker. Remaining data entered into web application by students. Stores student-entered data from the SAP (Student Advising Profile) web form. Frosh FileMaker databases, SAP web application Engineering Advising, Registrar Web application, FileMaker application N/A 11 MB, 10k records Ongoing in the spring COECIS ITSG COECIS ITSG no COECIS ITSG FileMaker Relational yes yes no yes N/A
2024-02-07
2024-02-05 Engineering COECIS ITSG hrsc_hiring_form COECIS Onboarding N/A hrsc_hiring_form HR Application User Form Entries New hires/extensions positions in EN/CIS/TECH New hires/extensions positions in EN/CIS/TECH HR, Unit Staff n/a n/a 15 MB When application is running COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational no yes no no N/A
2024-02-05
2023-01-26 Engineering interviews COE interviews N/A Other Drupal site for scheduling interviews in Engineering Drupal site for scheduling interviews in Engineering Students who need to reserve rooms for Interview in Engineering TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-05-12
2023-01-26 Computer and Information Sciences mailman Mailman N/A HR|Student Names and emails for faculty, staff and student mailing lists Faculty, staff and student mailing lists CS, IS, ECE faculty and staff TBD Every hour COECIS ITSG COECIS ITSG COECIS ITSG N/A
2021-04-13
2024-02-20 Engineering COECIS ITSG SIP Salary Improvement Program N/A SIP HR Workday Workday Workday COECIS Employee salary increases HR, Finance, Dean N/A N/A 65 MB Once a year COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no no N/A
2024-02-20
2024-02-05 Engineering COECIS ITSG WorkdayData COECIS WorkdayData N/A WorkdayData HR Workday Workday Workday Download of workday data for all our units for use in various projects CoE, CIS, Tech staff n/a n/a 1860 MB Daily COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes N/A
2024-02-05
2023-01-26 Computer and Information Sciences CS UnderGrad DB N/A Student Locally entered CS student names, college, CUID, gender, GPA, advisor, diversity, major, class, CS undergrad coordinator TBD COECIS ITSG COECIS ITSG COECIS ITSG N/A
2020-11-02
2023-01-26 Computer and Information Sciences IS Minors DB N/A Student IS minor student info IS minor student info IS undergrad coordinator TBD COECIS ITSG IS staff COECIS ITSG N/A
2020-11-02
2023-01-27 Computer and Information Sciences CIS AAD Prospects N/A Alumni CIS Alumni information stored within our local Filemaker server CIS AAD Staff track CIS alumni CIS AAD staff TBD COECIS ITSG CIS AAD staff COECIS ITSG N/A
2020-11-02
2023-01-27 Engineering CASPAC N/A Student Sourced from SADM. The databases we maintain are CASPAC Grades Pull CASPAC_FA12 CASPAC_FA13 CASPAC_FA14 CASPAC_FA15 CASPAC_FA16 CASPAC_FA17 CASPAC_FA18 CASPAC_FA19 CASPAC_FA20 CASPAC_FA21 CASPAC_FA22 CASPAC_SP12 CASPAC_SP13 CASPAC_SP14 CASPAC_SP15 CASPAC_SP16 CASPAC_SP17 CASPAC_SP18 CASPAC_SP19 CASPAC_SP20 CASPAC_SP21 CASPAC_SP22 Committee for Academic Standards, Petitions, Actions and Credits Engineering Advising. Name, course, GPA, academic status, CUID, NetID, major, class, grades TBD N/A
2020-11-02
2023-01-26 Engineering CBE GRA Database N/A Financial Data|Student Financial and Student data Chemical and Biomolecular Engineering grad student tracking TBD N/A
2020-10-24
2024-06-28 Veterinary Medicine Francois Elvinger (fe65) VetView VetView N/A VetView Other VetView All Animal Health Diagnostic Center data. AHDC and clients Application, API QuickSight, Tableau Millions Continuously AWS VMIT no vmithelpdesk@cornell.edu PostGreSQL Relational no yes no no No
2024-06-28
2024-02-22 Industrial and Labor Relations Rebecca Hann N/A ILR Outreach Workshop Registration Data N/A N/A Financial Data|Planning and Budget|Other N/A ILR Outreach program data. Customer contacts, their associated companies, course and class information, participant data, information related to offered certificates, financial transactions, location information, evaluations, leads and opportunities. This resides in a Salesforce org that supports the operations of the ILR Outreach business which offers hundreds of workshops per year out of our New York City and Ithaca conference centers, as well as online. Used to manage classes and participants, generate invoices, correspondence, class rosters, name badges, and other documents via automated mail merge, reports in order to meet state reporting requirements, reconcile accounts, export financial data to Kuali, and engage in opportunity tracking and marketing. System is also related to our Drupal-based workshop registration front-end. ILR Outreach employees, Marketing, Fiscal, Dean's Office Salesforce UI, Excel, Tableau Tableau 16,000+ contacts, 19,000 participants in 319 unique courses. ~400mb Very frequently, changes occur daily. Salesforce ILR Administrative Applications no https://tdx.cornell.edu/TDClient/82/Portal/Requests/TicketRequests/NewForm?ID=nD Salesforce Relational yes yes yes yes ITSO has reviewed portions of this system but not in its entirety.
2024-02-22
2023-10-27 Industrial and Labor Relations TBD IT and Facilities Asset inventory IT and Facilities Asset inventory N/A IT and Facilities Asset inventory Facilities|IT|Planning and Budget|Other All data is hand-entered by ILR IT staff. Nothing is sourced from systems of record. List of IT assets (computers, media and AV equipment), small amount of Facilities assets (not comprehensive), their value, ownership, and replacement schedule. This is part of a custom SharePoint app used for planning budgets and replacement schedules, and as an inventory management tool. Also tracks disposed equipment. IT and administrative management in the Dean's Office SharePoint N/A Less than 5,000 records Constantly as situations change in IT. SharePoint ILR Technical Services and Administrative Applications no Internal to ILRTS and ILR Dean's Office only. Contact the ILR Director of IT SharePoint Relational yes yes no yes No
2023-10-27
2024-02-22 Industrial and Labor Relations Rebecca Hann CourseEvals Course Evaluations N/A Course Evaluation Data Student|Other Arts & Sciences database system (which comes from the student Datamart) Arts & Sciences takes care of this on their side. Student evaluations of faculty and classes. Contains class, course, and instructor data, as well as student names and email addresses. Based on and connected to the Arts & Sciences CourseEvals system. Used by students to evaluate classes and faculty. Anonymized reports are provided to faculty and the Dean's Office to aid in faculty evaluations and tenure discussions. Students (filing out the forms), faculty, Dean's office. Legacy Cold Fusion forms, Excel N/A 21mb Twice per semester. SQL Servers in the CIT server farm (A&S and ILR) and Media3 for ColdFusion. Arts & Sciences IT and ILR Administrative Applications. no https://tdx.cornell.edu/TDClient/82/Portal/Requests/TicketRequests/NewForm?ID=nD SQL Servers Relational yes yes no yes Not that I'm aware of (A&S may have done something)
2024-02-22
2024-02-22 Industrial and Labor Relations Rebecca Hann EXPLORE EXPLORE N/A EXPLORE Internships Student|Other N/A N/A CRM built in Filemaker includes company descriptions and contact information and contact information for ILR students who participate in the program. We anticipate that this system will move to a centralized opportunity marketplace sometime in the relatively near future. This is used to match up ILR students with companies that provide one or both of two specific types of internships, one specifically for freshmen and the other for any students who wish to do an internship over the winter intersession. ILR students, ILR Office of Career Services Internal - Filemaker, external - Drupal N/A Small, in the hundreds. Activity occurs during a period of 1-2 months, in the fall Filemaker Server in CIT server farm ILR Administrative Applications no https://tdx.cornell.edu/TDClient/82/Portal/Requests/TicketRequests/NewForm?ID=nD Filemaker Relational no yes no yes No
2024-02-22
2024-02-22 Industrial and Labor Relations Rebecca Hann Watermark Watermark Insights N/A Faculty activities Sponsored Research|Other Sponsored research database RASS, Outreach activity data from ILR Salesforce. Automated feed of select ILR-specific sponsored research data from RASS. Manual imports from ILR Salesforce once/yr. Faculty activity data including their teaching, publications, research activities, aggregated course evaluations, and goal-based activities that come in from ILR's Outreach Salesforce org. There is also a feed from the Office of Sponsored Programs to capture any relevant data from their database for individual faculty members. Used in evaluating faculty and tenure discussions. Also populates web sites with faculty information automatically. Faculty, Outreach program staff, Dean's Office Activity Insight UI. N/A 7.8mb, data on over 140 faculty and some staff, past and present in ILR. The window for updates is about 2 months in the spring Cloud - Activity Insight ILR Dean's Office and Administrative Applications no https://tdx.cornell.edu/TDClient/82/Portal/Requests/TicketRequests/NewForm?ID=nD Activity Insight proprietary Unknown no no yes no ITSO may have reviewed in the past, unclear
2024-02-22
2024-02-23 Industrial and Labor Relations Rebecca Hann CIPD Credit Internship Program data N/A Credit Internship Program data Student|Other Sudent datamart Contact data for new students participating in the internship is acquired via a Microsoft integration services package. ILR student contact information from the data mart, form submissions, and tracking data related to where they are in the application process. Information about companies and related contacts, and the nature of the internships that they offer for ILR students. SharePoint application that allows students to view internship opportunities, then apply for internships by filling out forms. Reporting for staff allows tracking of which students are at which point in the application process. Following an internship students can fill out an evaluation about their experience. ILR students who participate in the program and program admins. SharePoint N/A ~355 internships, ~360 students/internship pairings Student contact data is updated daily, other data as needed in the fall. Cornell SharePoint ILR Administrative Applications no ILR Credit Internship Program: https://www.ilr.cornell.edu/current-students/cred Cornell SharePoint lists Relational no yes no yes No
2024-02-23
2024-02-23 Industrial and Labor Relations Rebecca Hann EMS EMS (Event management System) N/A EMS (Event management System) Facilities|Financial Data|IT|Other N/A N/A Data about ILR Conference Center facilities and services in Ithaca and NYC. Financial data pertaining to orders for Conference Center services. Customer contact information and purchase history. List of IT, AV services, and catering related to conference rooms. Service management system for the ILR Conference Center provides staff with a tool to manage and fulfil requests for use of the facilities. Conference Center staff, Dean's Office. EMS proprietary app N/A ~25mb, over 7,000 events, 12,000 transactions, 3,800 contacts As needed. Conference Centers are in regular use. SQL Server in CIT Server Farm. ILR Technology Services and Administrative Applications no https://tdx.cornell.edu/TDClient/82/Portal/Requests/TicketRequests/NewForm?ID=nD SQL Server Relational no yes no yes No
2024-02-23
2024-02-23 Industrial and Labor Relations This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. N/A This solution is deprecated and can be deleted. Other This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. no This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. no no no no No
2024-02-23
2024-02-23 Industrial and Labor Relations Rebecca Hann N/A ILR student contact data N/A ILR student contact data Student Peoplesoft Microsoft integration solution package. ILR Students from 2015 to the present, contact information, emplid, and demographic information from the datamart. SharePoint list only shared with 4 individuals in Student Services plus two SharePoint site administrators. Used to allow students to apply to the Credit Internship Program so that forms can fill in automatically with their information, and to facilitate reporting by the program administrators. Also used to provide the CU Police with IDs of students allowed through doors protected by the door security system. We anticipate that the need for this system will be gone within a year, as this program will likely move into the central Salesforce student opportunity market, once that has matured. Credit Internship program is the only one left that uses this. No direct access. N/A ~3500 records Daily SQL Server in the CIT server farm ILR Administrative Applications no https://tdx.cornell.edu/TDClient/82/Portal/Requests/TicketRequests/NewForm?ID=nD SQL Server Relational no yes no yes Discussions with ITSO around this occurred in 2015 when it was implemented.
2024-02-23
2020-02-21 SC Johnson College of Business MBA Admissions N/A Student|Other Prospective student information Admissions Application for MBA, EMBA, and Tsinghua Students TBD N/A
2020-02-20
2020-02-21 SC Johnson College of Business Academic Planning N/A Other Courses, Faculty Plan academic curriculum and assign faculty for college programs TBD N/A
2020-02-20
2020-02-21 SC Johnson College of Business External Relations CRM N/A Alumni|Other Corporate, Career Management, C&I, Alumni Track interactions and engagement with corporate partners TBD N/A
2020-02-20
2024-08-23 SC Johnson College of Business N/A Watermark Faculty Success Watermark Faculty Success (formerly Activity Insight) N/A Faculty data Other No applications or databases. Data comes from College Faculty Affairs and faculty. Course Evaluation data is an exception. Most data doesn't come from any system of record. Course Evaluation data does come from those systems. Faculty information used for public faculty profiles on the web, as well as for faculty reviews. Stores faculty information. Used by Academic Affairs. Faculty Profiles are public. Non-public data is is used by Academic Affairs. HTTPS for public web profiles. Cornell NetID and password for non-public access. N/A TBD as needed / when it changes Watermark https://support.watermarkinsights.com/hc/en-us/categories/4409237050523-Faculty-Success SC Johnson College of Business - Faculty Affairs no Faculty Affairs unknown Denormalized (relational) yes no yes yes TRA
2024-08-23
2020-02-21 SC Johnson College of Business Career Management CRM N/A Student Student, Company Both the MBA and Undergrad and Masters Career Management Offices use Salesforce to record student advising notes as well as interactions with corporate partners using mostly Salesforce core functionality. TBD N/A
2020-02-20
2020-02-20 MBA Admissions Applicant Yield Event Registration N/A Other Prospective students Allows accepted applicants to register for a special yield event. TBD N/A
2020-02-20
2020-02-21 SC Johnson College of Business Cvent N/A Other Event information Event Management TBD TRA
2020-02-20
2020-02-21 SC Johnson College of Business Campus Groups N/A Student Student activity data Student Club management and calendar TBD TRA
2020-02-20
2020-02-21 SC Johnson College of Business GradLeaders N/A Student|Other Student, corporate Recruitment and career services TBD TRA
2020-02-20
2020-02-21 SC Johnson College of Business 12Twenty N/A Employment Provides students with a self service system to report employment outcomes TBD TRA
2020-02-20
2020-02-21 SC Johnson College of Business Pardot N/A Other Data is housed in Salesforce. Marketing and Lead/Gen TBD TRA
2020-02-20
2024-08-23 SC Johnson College of Business Vice President, Financial Affairs Budget Web Form Budget Web Form N/A This is an application not a data set Planning and Budget Kuali Data Warehouse Budget data. 4 years of College data from the KDW and current/projected data entered from budget owners. Budget Owners enter budget information for use by Finance. Finance staff, Budget Owners Web application secured by NetID Tableau TBD Once per day AWS SC Johnson College of Business IT - Web Applications Team & Salesforce Development Team no College Finance Team PostgreSQL Relational no no yes no N/A
2024-08-23
2020-02-21 SC Johnson College of Business Linvio Event Management N/A Other Event participants Managed app on Salesforce that provides staff with event management functionality. Attendees are also able to register for events. TBD TRA
2020-02-20
2024-08-23 SC Johnson College of Business Student Data Committee Student Services System Student Services System N/A This is a system, not a data set Student PeopleSoft Student Datamart Student Dyson, Johnson, SHA, Baker degree audits, course evals, course directories, graduation application, practice credits, petition form, scholarship survey, transfer credit form Student Services Web application secured by NetID none TBD updated every weekday from the PeopleSoft Student Datamart AWS SC Johnson College IT Web Applications Team no N/A PostgreSQL Relational no yes no no N/A
2024-08-23
2024-08-23 SC Johnson College of Business Vice President, Human Resources ERS ERS (Employee Request System) N/A N/A HR WorkDay Some basic information like Name and NetID is sourced from WorkDay Submit and track requests for new staff, promotions, band changes, etc. Approvals/Denials. Employee position descriptions, proposed compensation, rationale for need, etc. The system helps HR and hiring managers to navigate the process and approvals for hiring different positions. All history is retained in the application. No other system consumes this data. College Human Resources uses the data to make hiring decisions. College Human Resources College employees access the system using their Cornell NetID and password. N/A 894 records as of 8/23/2024 as new requests are submitted AWS SC Johnson College IT Web Applications Team no limited to College employees PostgreSQL Relational no yes yes no N/A
2024-08-23
2020-02-20 Faculty Profiles N/A Other Faculty Faculty profile pages on the college web sites TBD N/A
2020-02-20
2020-02-20 Student Employment System N/A Student Student Student employment appointment system for the college TBD N/A
2020-02-20
2020-02-20 SHA Course scheduling web tool N/A Student|Other Student, courses The Course Scheduling web tool is used 3 times a year to schedule/pre-enroll SHA Undergrads into Freshman and Sophomore Core Classes using a set of business rules provided by the SHA Student Services department. TBD N/A
2020-02-20
2020-03-12 Law School Registrar database N/A Student Local Law School registrar database Used for curriculum planning, class scheduling, pre-registration, lottery, add/drop, MPR, Degree audit, grading, etc. 4509.88 MB NA
2020-02-21
2020-03-12 Law School Finance database N/A Financial Data|Planning and Budget Law School budget and finance data. Law School budget and finance Data used by the Dean of Administration and Finance to provide reports to the Dean of the Law School. Pulled from KDWPROD. 1289.56 MB NA
2020-02-21
2020-03-12 Law School Inventory data N/A Network Data|Other Inventory DB, Excel spreadsheet. Track desktop systems, monitors, and other computer equipment within the Law School 1000 records NA
2020-02-21
2020-02-21 Law School Audio Visual Inventory N/A Network Data|Other Audio Visual Inventory Used to track AV equipment within the Law School. Excel spreadsheet in Box. TBA NA
2020-02-21
2023-10-19 Libraries Elaine Westbrooks RMC-Camera-Collector RMC Camera Collector N/A RMC-Camera-Collector Video Surveillence CUPD Access Control System CUPD Access Control System to Amazon S3 AWS S3 bucket with video files from surveillance cameras in Rare and Manuscript Collections MP4 video files are provided by CUPD from their camera system and backed up to low-cost archive for long term storage. Information about the camera location and recording date/time are contained in the filename. CUPD; identified RMC administration staff Download from S3 and view in video application n/a ~11 GB per day since Feb 1, 2020 Every weekday Amazon S3 CUL-IT / CUPD no dlh19@cornell.edu none none no yes no no n/a
2023-10-19
2023-10-23 Libraries Elaine Westbrooks CULLDP CULLDP N/A FOLIO IT|Other FOLIO Direct connect through our vendor, EBSCO, from FOLIO to LDP AWS EC2 instance with a 40 GB Postgres database hosted by EBSCO in RDS Data warehouse receiving nightly data loads from CUL FOLIO Library staff dBeaver, Tableau dBeaver, Tableau 40GB Nightly Cloud, EBSCO EBSCO / CUL FOLIO Operations Team no dlh19@cornell.edu PostgreSQL Denormalized relational yes yes no yes n/a
2023-10-23
2023-10-23 Libraries Elaine Westbrooks FOLIO FOLIO N/A FOLIO Other FOLIO n/a Open Source Postgres Database hosted by EBSCO on AWS in RDS and EC2 Library Management System, LDP, OPAC Library staff OPAC, web interface n/a 8 Tb Real time Cloud, EBSCO EBSCO / CUL FOLIO Operations Team no dlh19@cornell.edu PostgreSQL Relational no yes no no Yes - Steve Edgar
2023-10-23
2023-10-23 Libraries Elaine Westbrooks LibInsight LibInsight N/A LibInsight Other Cloud, SpringShare Cloud interface Patron Request Tracker knowledgebase and statistics on patron requests Library staff Web Interface n/a 6GB Real time Cloud, SpringShare SpringShare / CUL Desktop Services no dlh19@cornell.edu none none no yes no no n/a
2023-10-23
2020-03-12 Law School Admissions data N/A Student Information about applicants Law School applicant data. Mostly derived from ACES, a common law school application and CRM system used by most US law schools. Developed by the Law School Admissions Council (LSAC). Two databases: 148.38 MB and 145.69 MB NA
2020-03-12
2020-07-17 Industrial and Labor Relations ILR Grad Students N/A Alumni|Student|Other ILR grad student contact and demographic info, degree, committee chair, funding overview (not $, but schedule), thesis/dissertation info, notes on activities immediately following graduation. Used by ILR Grad office to track grad progress and be able to interact knowledgeably with the students when they request assistance from the office. From Mary: We use it to help track our students and note important information either not captured elsewhere or not easily accessible (concentration, changes to concentration, faculty mentor, work experience, date of exams, etc). We also use it to pull lists for ourselves or others as requested (i.e., “Can I have a list of all 2nd year MILRs straight from undergrad with a concentration in HRO?”). 568 records Filemaker has been reviewed. Not the specific database.
2020-07-17
2024-02-23 Industrial and Labor Relations Rebecca Hann Transfers Transfer Evaluation Database N/A Transfer Evaluation Database Student|Other N/A N/A Courses, Hours, Transfer credits, Distribution, Electives, approvals for transfer students related to ILR. From Jenn: The transfer evaluation database allows us a place to log the classwork a new transfer student has taken and how it will be used to fulfill ILR curriculum requirements. We send a .pdf copy to the student so they know how their credits are transferring and we use it as a guide with adding the course details to their student record in Peoplesoft. We also use it to track whether a student has submitted their final transcript and AP Scores. ILR Office of the Registrar Filemaker N/A ~1,000 records As needed Filemaker Server in the CIT server farm ILR Administrative Applications no ILR Office of the Registrar Filemaker Relational no yes no yes Unknown
2024-02-23
2022-11-07 NYC Tech Axiom N/A Financial Data|Planning and Budget Financial forecasting data Financial tool used for long-range forecasting at Cornell Tech TBD n/a
2020-12-22
2023-01-27 NYC Tech Tech Campus DailyCheck N/A HR|Student Contact info for Cornell Tech people (students, faculty, staff). Databases maintained are ctech_daily_check ctech_daily_check_dev. DailyCheck for the Tech Campus TBD N/A
2021-07-02
2022-11-07 NYC Tech ExpertPower N/A Facilities Power meter data from the Tech Campus buildings Reporting on power usage across various buildings at the Tech Campus TBD N/A
2020-12-22
2022-11-07 NYC Tech Bacnet BMS N/A Facilities Building control databases tracking various buildings systems like the shades, lighting, heating, etc. Building control databases tracking various buildings systems like the shades, lighting, heating, etc. TBD N/A
2020-12-22
2024-02-22 Industrial and Labor Relations Rebecca hann Licenses Software license tracking system N/A Software license tracking system IT|Planning and Budget|Other N/A N/A SharePoint app that includes software name, vendor, data types involved, renewal information, budget information, key people involved in managing and renewing software. This was created to manage purchasing more efficiently and help navigate the SofN/TRA/WA process. It includes tracking fields and notifications for key people to help avoid lapsed renewals. IT staff, Fiscal SharePoint N/A < 100 records As needed on a regular basis as software is renewed. Cornell Office365 SharePoint ILR Administrative Applications no https://tdx.cornell.edu/TDClient/82/Portal/Requests/TicketRequests/NewForm?ID=nD SharePoint list Relational no yes no yes No review done. It is on the Office365 SharePoint platform.
2024-02-22
2024-02-23 Industrial and Labor Relations Rebecca Hann Grad Leads Graduate Program Marketing Data N/A Graduate Program Marketing Data Other CollegeNet CollegeNet exports select data, Drupal collects the export and imports it into Salesforce. Leads data in Salesforce for our the ILR MILR, EMHRM, and MPS programs. Contact info, demographic data, tracking fields for marketing. There is also an integration with CollegeNet to synchronize that data to Salesforce. Used by the ILR Grad Office and Marketing in nurturing these Leads toward applying for the programs. Leads come in via Marketing landing pages, conferences and events, and applicants in CollegeNet. ILR Graduate program administrators and ILR Marketing Salesforce Excel, Tableau, Salesforce Analytics Starting at about 10,000 existing Leads as of 2nd half of 2021. Daily as needed Salesforce ILR Administrative Applications no ILR Office of Graduate Programs: https://www.ilr.cornell.edu/programs/graduate-d Salesforce Relational yes yes yes yes No
2024-02-23
2024-02-23 Industrial and Labor Relations Rebecca Hann N/A Outreach Program Leads N/A Outreach Program Leads Other N/A N/A Contact info (mostly name and email) in Salesforce of Leads related to the ILR Outreach programs. Leads come in via ILR Marketing landing pages and registrants in some classes, and are categorized and associated with appropriate interests. This puts them onto marketing "journeys" facilitated by a marketing automation solution. ILR Marketing Salesforce Excel, Tableau, Salesforce Analytics About 47,000 as of Q1 2024 As needed, generally daily Salesforce ILR Administrative Applications no https://tdx.cornell.edu/TDClient/82/Portal/Requests/TicketRequests/NewForm?ID=nD Salesforce Relational yes yes yes yes No
2024-02-23
2021-09-10 Research RASS Datamart N/A Sponsored Research Sponsored project proposal and award data (from RASS) and some annual research expenditures data (from KFS). Contains data for active projects going back to 6/30/2013. Primarily used for reporting and feeding a few value added systems. Roughly 24K research projects in 2021 Managed by CIT's ODAA unit
2021-09-10
2021-11-04 Research CNF User COVID Vaccination Verification Log N/A Health CNF User and equipment maintenance personnel database/spreadsheet in Sharepoint which includes verification date, netid/guestid, name, reason for CNF visit, type of proof, who cleared the user/personnel, testing date and type. As well as a second sheet with space for date, event name, # of attendees. CNF external users and equipment maintenance personnel must show proof of vaccination status, an exemption. or a valid negative test to be allowed in CNF lab facilities. We will not store the proof but only note that it was shown and visually confirmed. Several hundred annually. Not reviewed
2021-11-04
2021-11-04 Research CORAL N/A Financial Data|Student|Other Postgresql database storing CNF user, PI, account reps, and vendor contact information and academic status optionally gender, ethnicity and race; research project topic, state, country, instutition and department; KFS or pseudo account number to charge and billing contact information; user equipment, supplies, and lab entry usage records CORAL is the CNF Lab Info Management system which records usage on and charges for lab, supply, and equipment usage, tracks equipment maintenance and status, allows equipment usage reservations thousands Not reviewed
2021-11-04
2021-11-04 Research CNF Workforce Development Survey N/A Other CNF user date that includes 1. First and last name 2. Preferred email address 3. What is your highest degree earned? 4. What field of study was your degree earned? 5. Current place of employment: Company Name or Institution 6. Current job position 7. Have you continued your career in a STEM field? This data is hoped to be used to show that people that have been trained in our facility have continued their career in a STEM field 3251 people were surveyed and 235 people responded IRB Review Board
2021-09-15
2021-12-09 Research CNF REU Interns N/A Student|Other master excel spreadsheet of all the CNF / NNUN / NNIN / iREU / iREG interns since 1997. Lives on staff member's MAC computer. Removed all street addresses from the master file and as the file name implies, only kept the state and zip code . Column s include year, REU program, program site, intern name, school zip and state, home zip and state, intern email and cell, gender, race, citizenship status, stipend, program dates, project title, project PI, project mentor, project REU coordinator name, phone, and email, intern institution, field of study, intern advisor name and email, class, graduation date, intern career plans, how the REU intern found the program. We use the list for all kinds of demographic information, "where are they now" collection, tracking NSF Fellowship winners, Goldwater Scholarship winners, poster winners, marriages, babies, jobs, deaths, etc. 1410 entries in the 1.3 MB file Not reviewed
2021-12-09
2021-12-10 Research CNF Corporate Contact List N/A Other Excel spreadsheet on staff member's Mac which includes corporation name and contact info and sponsorship history. Corporate Contacts that we use specifically for soliciting corporate sponsorships for the CNF Annual Meeting. All the information has been gathered from past annual meetings, vendor business cards, company updates that they send, and CNF staff updates that they send. 175 entries in the 48 KB file Not reviewed
2021-12-10
2021-12-10 Research CNF Marketing Contacts N/A Other Excel spreadsheet with contact info including name, phone number, and address, and company. Master excel spreadsheet of all the non-CNF PI/USER community who we want to keep informed of CNF events. The folks on this list include all our Cornell contacts who are not already part of the CNF user community -- Alumni Affairs, Cornell Chronicle, department deans and chairs, Engineering Admissions, etc. It also includes ex-CNF Users who would like to keep in touch, and all the corporate contacts. Finally it includes people who have contacted me asking to receive the CNF newsletter and or research accomplishments 585 entries in the 111 KB file Not reviewed
2021-12-10
2021-12-10 Research CNF NSF Contact Marketing List N/A Other Excel spreadsheet containing name, corporation, title/department, and adress/email info. Master excel spreadsheet of all our contacts at the National Science Foundation. This spreadsheet is specifically and only for keeping updated on the appropriate people at NSF who should receive our newsletter and research accomplishments, and any CNF REU Program publications. 18 entries in 15 KB file Not reviewed
2021-12-10
2024-02-22 Industrial and Labor Relations Rebecca Hann Course Banking Faculty Course Banking data N/A Faculty Course Banking data Planning and Budget|Other Peoplesoft for ILR course list Manual export/import twice/yearly. ILR courses, Academic Services, Teaching Activities, Obligation History, and Credits Spent History. ILR faculty are allowed to "bank" credits, which map roughly to effort. They can teach more than their obligated amount in a year and bank credits that can be spent at a future time in exchange for non-teaching time. Data calculated and stored in ILR's Salesforce. Dean's Office, faculty Salesforce, export to Excel N/A About 5,000 records over 10 years The majority of changes occur once per semester, in the middle of the semester. Cloud - Salesforce ILR Dean's Office and Administrative Applications no https://tdx.cornell.edu/TDClient/82/Portal/Requests/TicketRequests/NewForm?ID=nD Salesforce Relational yes yes yes yes Salesforce has been assessed by ITSO
2024-02-22
2023-11-08 Graduate School Kathryn Boor NA CollegeNet/ApplyWeb - admissions data N/A CollegeNet/ApplyWeb - admissions data Student NA NA Prospective and admitted student data is captured and stored on CollegeNet servers; data includes demographic data, academic records for submitting candidates, and passport/visa information for international students. graduate admissions decisions Graduate school admissions office and graduate fields across campus (100+). Web communications only. NA >10,000 Daily CollegeNET Inc. (cloud based) Graduate School no TBD TBD TBD yes yes yes yes audit compliance review - spring 2022
2023-11-08
2023-10-18 Arts and Sciences Cynthia Sedlacek Academic Leaves Academic Leaves N/A Academic Leaves HR Workday and local adjustment data Workday and local adjustment data Anticipated Next Eligible Sabbatic and Study Leaves for Faculty Across the University For Department Chairs and Managers to easily view the next eligible sabbatic and study leave for faculty in their department. Dept Chairs, Managers, and Unit HR Staff Tableau Tableau 2500 Once per month Hosted CIT VM and run by A&S Cynthia Sedlacek and Gary Chaika no Unit HR Staff MSSQL and Tableau Relational no no yes no Reviewed as Part of KPI
2023-10-18
2022-10-17 Research BRC LIMS N/A Financial Data|Other Database of all customers (internal and external), orders and processing for our scientific service facilities. metadata about services varies significantly among services. BRC LIMS supports the operation of our core facilities by providing customer ordering, billing and operational/workflow support for our labs. Payment cards are handled separately (not in this or any internal system and under all PCI-DSS related policy). 1000s of customers, 10X1000s order/sample metadata engaged with audit on security and privacy 2015
2022-10-17
2022-11-08 Agriculture and Life Sciences Salary Certification System (ECS) N/A Financial Data|HR App uses data from FIN: account; HR: employee, position; Salary Certification System (ECS), formerly Effort Cert System - allows review and approval of sponsored salaries TBD N/A
2022-10-19
2023-10-23 Libraries Elaine Westbrooks SenSource SenSource Door Counter N/A SenSource Other Cloud, SenSource Web interface Anonymous patron traffic Building usage to track space utilization Library Facilities Staff Web Interface n/a 500 Gb Real time Cloud, SenSource SenSource / CUL Desktop Services no jfl65@cornell.edu none none no yes no no No
2023-10-23
2022-11-15 Continuing Education and Summer Sessions ApplyWeb CollegeNET N/A Student|Other Admission Data including applicant biographical,, school, transcript, etc. Passport information, Emergency Contact, and Class choices. Application Fee amount. Data sent to SCE Student System Collect student application to Precollege. Enforce Editing and business rules. Builds a PDF of application and a batches up application into file that imported into SCE Student System. Collect application payment. Collects passport/visa information for international students. Passport information. TBD NA
2022-11-15
2022-11-15 Continuing Education and Summer Sessions SCE Student System N/A Financial Data|HR|Student|Other Sourced from SCE entered data, SADM, LDAP, CollegeNET, LDAP, SCE Course Proposal System (CPS), and SCE Course Budget System (CBS). Sends student data to PeopleSoft, Course Class Interface (CCI), SCE Public Web Instance, Health Services, and Campus Life for housing details. The SCE Student System is used to manage registrations and fees for various programs like the SCE Precollege program and all non-credit programs, including executive and professional programs.   This system acts as the admission, enrollment and billing system for SCE programs such as Precollege and Pre-Law.  This system is the database of record for executive and professional programs.  The application feeds credit course and class data to Course Class Interface (CCI) to be entered into PeopleSoft for credit courses. This is the source database used to publish courses to SCE public website. Contains rates, billing data, generates payroll information, source for account receivables, supports financial reconciliation for receivables. Supports budget management for both credit and non-credit TBD ITSO reviewed implementation at AWS adoption
2020-11-25
2022-11-15 Continuing Education and Summer Sessions Certificates N/A Other Trainers/instructor, class enrolled and participant information and includes bio demo, class, certificate to be issued. Database of permanent record of non-credit certificates issued. Print and reprint certificates, billing reports, manages trainers and certificate holders information, and generate trainer and certificates letters and certificates. TBD ITSO reviewed implementation at AWS adoption
2020-11-25
2022-11-16 Continuing Education and Summer Sessions On-line Enrollment (OES) N/A Student|Other Student enters bio data class choice, LDAP, SCE Student Systems Oracle RDS, WWW MySQL RDS Gather information from non-matriculated Cornell students and/or to enroll them in CE credit or non-credit programs. Securely process credit card charges and collect program fees for Professional Programs. E-mail notifications are generated to appropriate individuals. TBD ITSO reviewed implementation at AWS adoption
2020-11-25
2022-11-15 Continuing Education and Summer Sessions Student/Faculty Portal N/A Student|Other Class lists Self service for faculty to obtain Summer and Winter Photo ID class list, Excel compatible list, e-mail list of students, Class List TBD ITSO reviewed implementation at AWS adoption
2020-11-25
2022-11-16 Continuing Education and Summer Sessions Web Content Management System N/A Other Web content Editing of web content. Editing program descriptions stored in database, Editing of academic calendar. Manages Photos and copyright data. Manages Web questionnaires. Controls content work flow TBD ITSO reviewed implementation at AWS adoption
2022-11-16
2022-11-16 Continuing Education and Summer Sessions Prospector N/A Other Prospects email address, names and addresses. Manages print and e-mail contact lists. Provides ability for recipients to opt out of mailings. TBD ITSO reviewed implementation at AWS adoption
2020-11-25
2022-11-16 Continuing Education and Summer Sessions Precollege Self Service N/A Financial Data|Student|Other Authentication via Shiboth via CollegeNET Apply We login, data sourced from SCE Student System Provides prospective students their admission decision and checklists online and includes: admission forms status, forms status for attendees, confirm attendance and see scholarship information. Allows participants to generate, view, and pay charges securely. TBD ITSO reviewed implementation at AWS adoption
2020-11-25
2022-11-16 Continuing Education and Summer Sessions Course Budget System (CBS) N/A Financial Data|HR Data entry from SCE and Academic Departments, SADM, SCE Student Systems Oracle RDS, and LDAP Self-service for departments to enter instructors and assign them to courses. Entry of other course expenses for each course budget. Assign instructor costs, Provides work-flow for approving budgets and instructors. TBD ITSO reviewed implementation at AWS adoption
2020-11-25
2022-11-16 Continuing Education and Summer Sessions Course Proposal System (CPS) N/A Other Entry by SCE and Academic Departments, SADM, SCE Student Systems Oracle RDS, and LDAP. Allows departments to propose courses on-line for Winter and Summer Sessions. Collects Faculty assignments. Verifies Course information. Provides work flow ensures appropriate. Provides prior years enrollments history. approvals are done. Notifies department of approval and status of offerings. TBD ITSO reviewed implementation at AWS adoption
2020-11-25
2022-11-16 Continuing Education and Summer Sessions Course Evaluations N/A Student|Other Entry by students, SCE Student Systems, and Oracle RDS. Links faculty and student to correct classes. Present Evaluation Statistic on completion. Lottery function to award prize for completions. Automates notification via e-mail of pending evaluations. Allows department and faculty to read the appropriate evaluations. Controls the timing of when an evaluation can be done. TBD ITSO reviewed implementation at AWS adoption
2020-11-25
2022-11-16 Continuing Education and Summer Sessions Role Manager N/A Other Sourced from SCE and Academic Departments entered data, LDAP, SCE Student Systems Oracle RDS Self-service for department to manage access via role assignments to Course Proposal System, Course Budgets Systems and Evaluation System TBD ITSO reviewed implementation at AWS adoption
2020-11-25
2023-02-06 Provost eCornell: Potential Students CRM N/A Student|Other Student details for CRM purposes: First Name, Last Name, email address. Optionally, company the student works for (to determine if there are any applicable group discount rates) eCornell uses Salesforce and Pardot as the primary CRM/Marketing automation tool to reach potential students, inform them about the programs eCornell offers, possible start dates, certification paths, upcoming info sessions etc. 2,000,000 N/A
2023-02-06
2023-02-06 Provost eCornell: Student Information System N/A Student Student Information System that includes name, email. Optional data that can be provided by the user: address, employer information. The SIS system holds the details for student purchases (of eCornell courses and certificates), course registration and completion data 500000 N/A
2023-02-06
2023-02-06 Provost eCornell: Canvas N/A Student eCornell uses its own instance of Canvas as a Learning Management System, and has student's name, email and course registration/completion information Students consume courses on canvas, so canvas has the student's name, email, course registration, completion and details of any activities performed as part of completing the course. 500000 N/A
2023-02-06
2023-02-06 Provost eCornell: Surveys N/A Student|Other Student Name, email address Upon completion of an eCornell course, students are prompted to complete a course satisfaction survey. The survey records the students name and email address 150000 N/A
2023-02-06
2023-02-28 Alumni Affairs and Development AlumnIQ N/A Alumni Event registration system for Reunion, CAU, TCAM, CALC Capture event registrations, attendance, and payments 1000 N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Brightcrowd N/A Alumni Alumni profiles for use in creating class yearbooks Engagement and connection with Alumni, data capture, self reported data from alumni N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Campus Sonar N/A Alumni Social media audience analysis - consulting engagement plus dashboard Engagement analysis N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development CR_Ack (Gift Acknowledgments) N/A Alumni|Financial Data Alumni addresses, names, employment, giving history and amounts Generates gift acknowledgment letters N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Crowdfunding (a.k.a. Scalefunder) N/A Alumni|Financial Data Alumni engagement data, payment information Online donation system that accepts gifts to support student-led projects N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Digital Engagement Center (was CampusCall) N/A Alumni Alumni addresses, phone numbers, engagement Enables student phone-a-thon for dialing and pledge recording N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development donorCentrics N/A Alumni Benchmarking data Benchmarking data N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Evertrue N/A Alumni Alumni engagement and interest data Join constituent data with constituent activity on our social media properties to gain insight to their interests N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Forumm N/A Alumni Event hosting and attendance, alumni engagement Online event hosting N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development FreeWill N/A Alumni|Financial Data Alumni engagement, giving data, estate planning Qualified charitable distribution calculator and web site N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development GetThru N/A Alumni Alumni engagement through text messaging Texting service N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Gift Processing System (GPS) N/A Alumni|Financial Data Alumni names, addresses, giving data. Database and processing program to add new gift data to PeopleSoft Receives gifts from various sources in electronic format, presents them to the gift processing team so they can be reviewed and processed, then submitted to PeopleSoft. N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Joint Records Processing (JRP) N/A Alumni Alumni names and address matching process Takes as input a list of constituent IDs, matches them up with spouses, returns information about them that is used for addressing mailings N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Giving Day N/A Alumni|Financial Data Websites, Alumni engagement, payment submissions Online donation system that accepts gifts on Giving Day N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Maestro N/A Alumni Alumni engagement and event data tracking https://live.alumni.cornell.edu Provides additional features to support our Livestreams, like SSO to track viewers, and popups to link to donation pages. N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development PBC Guru N/A Alumni Alumni outreach and engagement Alumni book club N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Prospect Capacity N/A Alumni Alumni financial data, engagement, giving capacity Tool for IGOs to assess their prospects N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development RelSci N/A Alumni Alumni demographics Relationship mapping N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Reunion Crediting N/A Alumni Consolidated and aggregate giving data from Alumni based from individual gifts Track and report on gifts from various classes for Reunion fundraising N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Reunion Postcards App N/A Alumni Alumni engagement and outreach The legacy (refreshed) app to send 1-on-1 digital postcards to class mates to invite them to Reunion. N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Social Tables N/A Alumni Alumni engagement and outreach, event data Seat assignments for large events N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Social Toaster N/A Alumni Alumni engagement Allow alumni "social media ambassadors" to "spread the word" and communicate Cornell messaging through their social media channels N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Sprout Social N/A Alumni Alumni engagement Social publishing and listening tool to stay abreast of social media chatter about Cornell N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development ThankView N/A Alumni Alumni engagement Personalized thank you videos N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Trust Portal N/A Alumni|Financial Data Alumni names, addresses, giving data, financials Security gifts processing (we enter assets, update information when sold) N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Windfall N/A Alumni|Health Alumni financial, names, addresses, Wealth-screening integration with Evertrue N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Yes Elections N/A Alumni Alumni engagement Election system for annual Alumni Trustee Election (CATN) N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Otter.ai N/A Alumni Alumni engagement meeting assistant that records audio, writes notes, automatically captures slides, and generates summaries. N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development AlumniFinder N/A Alumni Alumni demographic updates AAD Advancement Services is responsible for managing the biographical information about our constituents and occasionally needs to look up additional information about a person to confirm whether they are already affiliated with Cornell and in our database in order to prevent duplicate records from being created. AlumniFinder provides that database for looking up information like name variations, address history, contact information, DOB/DOD and other known relatives. N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Flickr N/A Alumni Alumni names, images We use Flickr as a means to allow alumni to look through the photos of big events (Reunion, CALC, Homecoming, etc.). It's also a convenient service for us to use that allows us to embed photo albums to their respective event pages on the alumni website. N/A N/A
2023-02-28
2023-03-13 Information Technologies Tony Damiani N/A Other certified desktop - information about managed desktops and there compliance condition used by support teams and IT managers to maintain certified desktop. several million rows tbd
2023-03-13
2024-08-23 SC Johnson College of Business Vice President, Financial Affairs BERT BERT (Business Expense Request Tracker) N/A N/A Financial Data entered by staff of the SC Johnson College of Business Data is not sourced from any system of record. Financial Data: Cost of what is being purchased. College level approval of purchases. College Finance staff The application is accessed using a Cornell NetID and password N/A 30,024 records as of 8/23/2023 As users submit new requests AWS SC Johnson College IT Web Applications Team no Only accessibly by SC Johnson College employees PostgreSQL Relational no yes yes no Is this question asking about a TRA or something else?
2024-08-23
2024-08-23 SC Johnson College of Business Vice President, Financial Affairs , Vice President, Human Resources TIPS TIPS database (Hotel Gratuities) N/A N/A Financial Data|HR Some data like Name, NetID and EMPLID is sourced from WorkDay. Some Tip information is sourced from the Hotel Micros system. Name, NetID and EMPLID is sourced from WorkDay and pulled into the system. Some Tip information is pulled in from the Hotel Micros system (some is hand entered). Tip $ amount data for tipped students and staff in the Statler Hotel. Tips & tip-out tracking for tipped staff in the Statler Hotel. The system is used by HR & Payroll staff to provide Tip amounts to central for inclusion in paychecks, etc. College HR & Payroll staff Cornell NetID and password. N/A TBD Bi-weekly for payroll. AWS SC Johnson College IT Web Applications Team no Only accessible by certain College HR & Payroll staff PostgreSQL Relational no no no no N/A
2024-08-23
2024-08-27 SC Johnson College of Business Vice President, Alumni Affairs and Development Class Agents Johnson School Class Agents N/A N/A Alumni Data for this application is pulled from the PeopleSoft Contributor Relations datamart Daily cron job pulls donor names and gift amounts from PeopleSoft CR datamart. Names shown on public website https://apps.business.cornell.edu/classagents by class year and grouped by giving category - "$499 & under", "$500-$999" , etc. alumni and other donor fund raising information. Public HTTPS Johnson School website N/A TBD daily AWS SC Johnson College IT Web Applications Team no Public PostgreSQL Relational no no no no N/A
2024-08-27
2023-04-09 Student and Academic Services Dining Data N/A Student|Other Dining sales transactions which includes: name, Cornell ID (if applicable), mealplan #, date, dining location Data is used for dining operations. Keeps track of card swipes for declining meal plan balances. 800 GB IT Security Office
2023-04-09
2023-04-10 Student and Academic Services Local address for campus housing N/A Student Local address for student housing Student database from StarRez Housing system, contains name, NETID, class year, class major, ethnicity, local campus address for students using Cornell Housing 300 GB IT Security Office
2023-04-09
2023-09-12 Human Resources CULearn N/A Other Course completions Cornell's staff learning management system TBD CIT
2023-09-12
2023-11-27 Student and Academic Services Dan Sweeney Customer records Customer records N/A NetSuite Cornell Store transactions Alumni|Student|Other Student, Faculty, Staff, Alumni have the ability to create accounts in NetSuite Student, Faculty, Staff, Alumni and General Public data records depicting a sales transaction of merchandise from the Cornell Store. Course material is also stored in this system The data is used for product fulfillment and retail operations. Product inventory and sales financial data is maintained. Cornell Retail Services select staff, Cornell affiliated user (individual accts) Cornell affiliates via CU web login, CRS staff by role based access OBIEE 25GB daily or as transactions are recorded to individual accounts Oracle Cloud Services Cornell Retail Services no https://ssit.scl.cornell.edu Oracle Denormalized yes no yes unknown
2023-11-27
2024-04-10 Human Ecology Rachel Dunifon N/A Student Petition Data N/A Student Petition Data Student|Other SADW, Local Student petition data surrounding requests for Change of Major, Add/Drop Enrollments, Special Studies, TA forms, General Petitions, Curriculum Waiver/Substitution, Over 18 Credits, Withdraw from a course, In-Absentia Form, Cross-listed course change requests, Request to Graduate Early, and Graduation Application. Used to process student record changes initiated by the student for the registrar office to take action on. CHE administration and departments Frevvo, Tableau Frevvo, Tableau TBD Daily Human Ecology CHE IT no drh222 SQL Server Denormalized no yes yes no N/A
2024-04-10
2024-04-10 Human Ecology Rachel Dunifon Faculty KFS Account Review Faculty KFS Account Review N/A Faculty KFS Account Review Financial Data|Other KDW Data collected here is faculty's acknowledgement they have reviewed their KFS open account activities on a bi-monthly basis. Data collected is account activity information from KFS data warehouse and faculty's netid and date of acknowledgement. Data collected here is faculty's acknowledgement they have reviewed their KFS open account activities on a bi-monthly basis. Data collected is account activity information from KFS data warehouse and faculty's netid and date of acknowledgement. CHE administration and departments SQL, Tableau Tableau TBD Monthly Human Ecology CHE IT no drh222 SQL Server Denormalized no yes yes no N/A
2024-04-10
2023-10-25 Continuing Education and Summer Sessions Vice President, Human Resources Annual Review Sign Off SCE Annual Review Sign Off for Staff N/A N/A HR LDAP Staff netids sourced from MySQL Staff Database and LDAP,  Confidentiality agreements, Annual Review Checklist Document stored in Oracle RDS. Allows SCE Staff to electronically sign an Annual Confidentiality Agreement, Acknowledgement of policies and preforming a confidential data review. SCE HR and adminatrive Staff Web Applicaiton n/a 1000 Yearly cloud SCE IT no SCE HR Oracle and MySQL Relational
2023-10-25
2023-10-30 Information Technologies TBD TDX TeamDynamix N/A Service Management Suite / TeamDynamix HR|Student Enterprise Directory, Facilities TBA Since the installation of this system, multiple units in the university have used it for customer server requests, it service management, and project management. The system includes a listing of all Cornell users, their NetIDs, and if applicable emplids (CU ID#) and work locations. Cornell Information Technologies, College/Unit IT Service Groups, Office of University Registrar, Financial Aid and Student Employment, Grad Admissions, college/unit Facilities departments, DFS, etc. IT and Non-IT Staff or Contractors working for Cornell University Web application https://tdx.cornell.edu/ Tableau Over 1,000,000 Customer request tickets and growing. ~536,000 Cornell people. Ongoing/live cloud - TeamDynamix Cornell Information Technologies no https://tdx.cornell.edu/TDClient/39/Portal/Requests/TicketRequests/NewForm?ID=ne MSSQL TBD yes yes no
2023-10-30
2023-10-30 Information Technologies Student Data Commitee (See https://policy.cornell.edu/policy-library/data-stewar Canvas Canvas N/A Learning Management System (Academic) Student Peoplesoft Online course content and course work. https://teaching.cornell.edu/course-management-canvas students, faculty, instructors Web application https://login.canvas.cornell.edu/ Canvas Analytics Records for Cornell courses and students Ongoing/Live cloud - Canvas Cornell Information Technologies, Center for Teaching Excellence no TBD TBD TBD yes yes yes
2023-10-30
2023-11-21 Student and Academic Services Ryan Lombardi POS data Point of Sale data N/A Oracle Micros Simphony 2 data Financial Data|Other Micros Simphony 2, CS Gold Data is generated as sales are entered into the Micros POS devices. Sales involving meal plans verify a student's meal plan against CS Gold, bringing back some details such as their balances. 3 years of transaction data stored in the Oracle cloud, and 7 years of data stored locally in case of an audit. Oracle Simphony includes a platform for reporting on the data (Reporting & Analtyics), and data is also extracted to populate a number of custom reports in OAS. Cornell Dining & SCL Business Service Center OAS, Simphony 2 interfaces (e.g., Micros POS, R&A, EMC) OAS Massive Real-time Oracle Cloud Oracle no Contact Cornell Dining Oracle NA
2023-11-21
2023-11-28 Student and Academic Services Dan Sweeney Guardian Student Data Guardian Student Data N/A Campus Kaizen Guardian Conduct System Student Data Student Peoplesoft Daily query of Peoplesoft for the required student data. Data is transformed to comply with the vendor defined contents, field names and formatting. Data is sent via SFTP to vendor specified location and imported into the Guardian application. This data set contains student demographic, class schedule and personal data derived from Peoplesoft. E.g., The Guardian Conduct System imports the data set. The imported demographic data is utilized by the "Audience" to create cases and record investigative information in response to submitted incident reports. DOS, SCLDS, Office of Institutional Equity and TIX, CUPD, Housing office Cornell staff log in through SSO Reports are derived through the Campus Kaizen Guardian Application and exported 25GB Daily Campus Kaizen cloud Collaboration of all the listed "Audience" departments no https://ssit.scl.cornell.edu TBD TBD yes yes no yes
2023-11-28
2023-11-28 Student and Academic Services Dan Sweeney Guardian Employee Data Guardian Employee Data N/A Campus Kaizen Guardian Conduct System Employee Data HR Workday Daily query of Workday for the required employee data. Data is transformed to comply with the vendor defined contents, field names and formatting. Data is sent via SFTP to vendor specified location and imported into the Guardian application. The data set includes demographic and personal data derived from Workday. E.g., name, address, gender, citizenship, employee status, date of separation. The Guardian Conduct System imports the data set. The imported demographic data is utilized by the "Audience" to create cases and record investigative information in response to submitted incident reports. DOS, SCLDS, Office of Institutional Equity and TIX, CUPD, Housing office Cornell staff log in through SSO Reports are derived through the Campus Kaizen Guardian Application and exported 25GB Daily Campus Kaizen cloud Collaboration of all the listed "Audience" departments no https://ssit.scl.cornell.edu TBD TBD yes yes no yes
2023-11-28
2023-11-28 Student and Academic Services Don Sevey CampusGroups.com Campus Groups N/A Student HR|Student Workday and PeopleSoft via CUPerson Mainly database connections with a few rest calls to Workday; CUPerson is a summary of PeopleSoft data Using it to maintain the user record in CampusGroups. Entire University Vendor web application N/A 45,000 Every weekday Local staging database and pushed to the vendor, CG CIT/OODA, Integrations no N/A Oracle Relational no yes yes no
2023-11-28
2023-12-04 Student and Academic Services Dan Sweeney JE Inbound KFS JE Inbound to NetSuite N/A KFS Journal Entry Inbound to NetSuite Financial Data KFS Journal Entries for Cornell Retail Services (CRS) are picked up from a file provided by KFS and imported into NetSuite Externalid,COA Account Number,Transaction Debit Amount,Transaction Credit Amount,Location,Department/Channel,eDoc#,Transaction Line Description,Date,KFS Flag,Posting Period Journal entry data fed into NetSuite from KFS. NetSuite ERP is the system of record for CRS, Journal entries are reviewed and approved in NetSuite prior to closing the financial period. Financial transaction staff User name (netid) and password allows for role-based data access Queries can be exported to Excel, Csv, PDF 10GB Daily Oracle Cloud Services SSIT maintains the integration between KFS and NetSuite no https://ssit.scl.cornell.edu Oracle RDMS yes yes no yes
2023-12-04
2023-12-04 Student and Academic Services Dan Sweeney NS-IDM-001 Identity Management Job N/A Identity Management Feed to NetSuite Alumni|HR|Student LDAP query Incremental or Full LDAP query via API to NetSuite provides (Active) person information to create customer records in NetSuite ERP. NetSuite ERP customer attributes, e.g., First Name, Last Name, NetID, CUID. Data provides Cornell affiliated persons to maintain a personal account in NetSuite ERP. Account information provides transactional data, shipping preferences and addresses. Cornell Retail Services select staff, Cornell affiliated user (individual accts) Cornell staff log in through SSO Queries can be exported to Excel, CSV, PDF 25GB Daily Oracle Cloud Services SSIT maintains the integration between IDM and NetSuite no https://ssit.scl.cornell.edu Oracle RDMS yes yes no yes
2023-12-04
2023-12-05 Student and Academic Services Dan Sweeney NS-PS-001 Course Enrollment Data N/A Course Enrollment Data Student Peoplesoft Term specific course enrollment data. PS job #09-06-05. PROD CTRL SFTP file to SSIT managed server. Student course enrollment data for the current term. There is some overlap of terms during the academic year. Data is imported via API to NerSuite ERP. Cornell Retail Services provides the data to VitalSource, a digital academic materials provider. Cornell Retail Services select staff, Students Cornell staff with the appropriate role log in to NetSuite ERP. VS Bookshelf. VitalSource Bookshelf and Canvas 25GB Twice daily Oracle Cloud Services, VitalSource cloud services Cornell Retail Services Academic Materials no https://ssit.scl.cornell.edu Oracle RDMS yes yes no yes
2023-12-05
2023-12-05 Student and Academic Services Dan Sweeney NS-PS-002 Course List Data N/A Course List Data Student Peoplesoft Term specific course data from PS Job #09-06-05 PROD CTRL SFTP data to SSIT managed server. Data is imported into NetSuite ERP Term specific course data. There is some term overlap during the academic year. Course data is merged with course enrollment data in NetSuite ERP. Data is exported to VitalSource, a digital academic materials provider. VitalSource provides data to students as a booklist and through a feed to Canvas. Cornell Retail Services select staff, Students Cornell staff with the appropriate role log in to NetSuite ERP. VS Bookshelf. VitalSource Bookshelf and Canvas 25GB Twice daily Oracle Cloud Services Cornell Retail Services Academic Materials no https://ssit.scl.cornell.edu Oracle RDMS yes yes no yes
2023-12-05
2023-12-19 Student and Academic Services Dan Sweeney SCL Axiom SCL Axiom N/A SCL Axiom Financial Data|HR Workday Payroll, KDW Chart of Accounts, Transactional data from NetSuite ERP Data pulled from KDW and stored in 3 tables om SSITPAWS. KDW tables exist as schema iin the ICC_Axiom db. Scheduler on a CIS server controls the data movement to the Axiom Cloud. KDW Chart of Accounts (Budget), Workday Position and Payroll, Cornell Retail Services transactional data Data used by SCL Business Operations and Finance to create and manage annual departmental budgets within SCL and for Strategic Planning SCL OVP Office, SCL Departmental Finance Managers Cornell staff log in through SSO Reports can be created via the Axiom report writing tool, and exported via .csv 10GB Daily SCL AWS instance, Axiom Cloud SSIT, CIT Integrations no https://ssit.scl.cornell.edu MYSQL TBD yes yes no yes
2023-12-19
2023-12-19 Student and Academic Services Dan Sweeney Avatax Avatax N/A NetSuite Avatax Financial Data NetSuite ERP Avatax provides tax calculation and compliance for ERP and eCommerce transactions generated by Cornell Retail Services. Avatax is integrated with NetSuite ERP. Transactions and tax calculations data since 7/2018 are stored. Financial Transaction Center Cornell Retail Services Financial Transaction Center Cornell Retail Services Cornell staff with the appropriate role log in to NetSuite ERP. VS Bookshelf. Queries can be exported to Excel, CSV, PDF 25GB Real time Oracle Cloud Services Cornell Retail Services no https://ssit.scl.cornell.edu Oracle TBD yes yes no yes
2023-12-19
2023-12-19 Student and Academic Services Dan Sweeney CAMP Billing CAMP Billing N/A CAMP Bursar Billing Student Peoplesoft, NetSuite ERP Students (term active) enrolled are billed the fee for the term through the SCL Bursar Billing tool which promotes the billing to the Bursar. Cornell Academic Materials Program, student billing information for the current term. Cornell Retail Services Office of the Bursar SSIT (SCL Bursar Billing Tool) Cornell Retail Services select staff, SSIT CRS staff by role based access to NetSuite, Admin access Bursar Billing Tool. OBIEE 25GB Each Term SCL database, Oracle Cloud (NetSuite ERP) SSIT maintains the Bursar Billing Tool no https://ssit.scl.cornell.edu TBD TBD yes yes no yes
2023-12-19
2023-12-19 Student and Academic Services Dan Sweeney NetSuite CornellCard NetSuite CornellCard N/A NetSuite CornellCard Student NetSuite ERP, eCommerce and Point-of-Sale Student CornellCard transactions from The Cornell Store(s). Data is sent to CS Gold. CS Gold is the system of record for CornellCard transactions. Student CornellCard transactions generated from purchases. Data is used for CornellCard billing. Cornell Retail Services select staff, SSIT, FTC staff Cornell staff with the appropriate role log in to NetSuite ERP or CS Gold OBIEE 25GB Daily SCL database, Oracle Cloud (NetSuite ERP) SSIT no https://ssit.scl.cornell.edu TBD TBD yes yes no yes
2023-12-19
2023-12-19 Student and Academic Services Dan Sweeney Payroll Deduction CRS Payroll Deduction N/A CRS Payroll Deduction Program HR NetSuite ERP recorded purchases Employee purchases of computer hardware are transacted in NetSuite, then shared with Payroll for payroll deduction payments. Employees can have one active contract for payroll deduction at a time. Cornell Retail Services, FTC and Payroll Cornell Retail Services, FTC and Payroll Cornell staff by role based access to NetSuite. Payroll Stagg Queries can be exported to Excel, Csv, PDF 5GB Daily SCL AWS instance, Oracle Cloud SSIT, FTC, Cornell Retail Services no https://ssit.scl.cornell.edu TBD TBD yes yes no yes
2023-12-19
2023-12-19 Student and Academic Services Dan Sweeney NetSuite ERP NetSuite N/A NetSuite Financial Data|Student|Other IDM, KFS, NSPOS, ECommerce System of Record for Cornell Retail Services; point-of-sale, eCommerce, departmental website. Purchase transactions, vendor orders, purchasing and billing, (physical) inventory, shipping, warehouse management. Manage the businesses of Cornell Retail Services Cornell Retail Services select staff, FTC staff Cornell staff with the appropriate role log in to NetSuite ERP. Queries can be exported to Excel, CSV, PDF 25GB Real time Oracle Cloud Services Cornell Retail Services, SSIT no https://ssit.scl.cornell.edu Oracle RDMS yes yes no yes
2023-12-19
2023-12-21 Student and Academic Services Ryan Lombardi CS Gold data Meal Plan data N/A CS Gold data Financial Data|Student|Other Micros Simphony 2, GET, PeopleSoft Patron accounts are created in CS Gold via data from PeopleSoft (e.g., NetID, billing status, etc.). Meal Plans are created and managed in CS Gold and applied to patrons. Need to verify. Used for financial auditing and comparisons with Simphony 2 (POS) and GET by folks in Dining and the Business Service Center. Also used for troubleshooting meal plan issues by SSIT and Dining, and reporting on plan usage. Cornell Dining, Service Centers, SSIT & SCL Business Service Center OAS, CS Gold Web Admin OAS Massive Real-time On-prem, Ithaca SSIT no Contact SSIT Need to verify NA
2023-12-21
2024-01-02 Student and Academic Services Ryan Lombardi GET data GET data N/A GET data Financial Data|Student|Other CS Gold, user input GET receives data from CS Gold for patron information and payment tenders. CS Gold receives information from PeopleSoft to create patrons. Need to verify. Used for financial auditing and comparisons with Simphony 2 (POS) and GET by folks in Dining and the Business Service Center. Cornell Dining, Service Centers, SSIT GET Admin NA Massive Real-time Vendor hosted (CBORD) Dining & SSIT no Contact Dining Need to verify NA
2024-01-02
2024-01-19 Student and Academic Services Ryan Lombardi CH Leadership Dashboard Data Cornell Health Utilization Data N/A Cornell Health Utilization Data Alumni|HR|Student Workday and PeopleSoft via Point and Click EHR. Dashboard data is sourced from Point and Click and filtered/organized/transformed by CIT processes for display. Seven years of Cornell Health service utilization data Used for Tableau Dashboard visual display of Cornell Health Service utilization data. Accessible by Cornell Health Leadership Team Accessible only by Cornell Health staff, specifically the leadership team. IP Restricted Access to Tableau Web Application Tableau 180,000 Records Updated nightly Cloud - Cornell AWS Environment CIT yes Access only granted to Cornell Health staff. Approval by Snr. Director Required SQL Relational no yes no yes
2024-01-19
2024-02-20 Engineering COECIS ITSG FroshFall (MSSQL Server) FroshFall (MSSQL Server) N/A FroshFall (MSSQL Server) Student SADW, Engineering Admissions, web application SQL/BI tools used to extract desired fields to flat files, imported into MS SQL Server and FileMaker Incoming Freshmen student names, IDs, math diagnostic data, advising profile data Student Advising Profile App, New Student Checklist website, Frosh FileMaker databases Engineering Advising, Admissions, and Registrar, plus CALS BEE Student Services FileMaker applications, Frosh web application N/A 33 MB, 36k records Ongoing in the spring COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes
2024-02-20
2024-02-20 Engineering COECIS ITSG Dean's List Dean's List N/A Dean's List Student SADW SQL/BI tools used to extract desired fields to flat files, imported to FileMaker Holds one semester's GPAs and names of Engineering undergrads who made Dean's list. FileMaker application EN Registrar FileMaker application N/A 10.6 MB, 27k records End of Spring and Fall terms COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes
2024-02-20
2024-02-20 Engineering COECIS ITSG FUINC FUINC N/A Fail/Unsatisfactory/Incomplete Database Student SADW SQL/BI tools used to extract desired fields to flat files, imported to FileMaker Holds one semester's enrollments and data for Engineering undergrad students who received F/U/INC grades. FileMaker application EN Registrar FileMaker application N/A 600 KB, 600 records End of Spring and Fall terms. No longer updated. COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational yes yes no yes
2024-02-20
2024-02-20 Engineering COECIS ITSG ad_data Active Directory Data N/A ITSG_security HR|IT AD, Workday, LDAP, application AD, Workday, LDAP, application Active Directory data maintenance Review and manage AD access ITSG team Application N/A 345 MB When application is running COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational no yes yes no
2024-02-20
2024-02-20 Engineering COECIS ITSG EPICC Awards EPICC Awards N/A EPICC Awards Other Application User form entries Engineering employees EPICC award system Nominations, review. and award process Cornell Application N/A 80 MB When application is running COECIS ITSG COECIS ITSG no COECIS ITSG MSSQL Server Relational no yes yes no
2024-02-20
2024-03-15 Research Vice President for Research and Innovation College Research Metrics College Research Metrics N/A Research proposals, expenditures, invention, and faculty data Financial Data|Sponsored Research RASS, KFS, Workday, Sophia Proposal data (RASS) Datamart. Research Expenditures from Ithaca and WCM campuses Invention disclosure data is from CTL Sophia Faculty data reflects IRP provided Faculty from Workday Annual data suitable for trending back to FY 2018 and can be tied to individual faculty, accounts or sponsored projects. Research metrics are used for the research & scholarship dashboard provided to the deans. Data set is also delivered to colleges and departments for research activity reporting. Deans, colleges and central units needing to report on research activity Data is delivered in a spreadsheet via a box folder Tableau and Excel about 300K records Data is updated every fiscal year cornell.box.com Research Administration Information Services (RAIS) no rais-help@cornell.edu Excel Excel worksheets yes no no yes
2024-03-15
2024-03-15 Research Vice President for Research and Innovation KFS Integration into RASS KFS Integration into RASS N/A KFS Integration into RASS Financial Data|Health KFS KDW tables: CA_ORG_DM, CA_OBJECT_CODE_DM, PROJECT_ACCOUNTANT are extracted into staging database and read by RASS nightly All Org, object code, and project accountant data extracted and loaded into RASS RASS consumes the data This is an integration into the Research Administration Support System The RASS system consumes the data from the staging database N/A about 300K records Nightly Oracle Database in AWS Research Administration Information Services (RAIS) no N/A Oracle N/A yes no no yes
2024-03-15
2024-03-15 Research Vice President for Research and Innovation Workday Integration into RASS Workday Integration into RASS N/A Workday Integration into RASS HR Workday Employee and position data is copied from Workday, combined with Directory rows and some calculated columns and consumed by RASS nightly All current employees and positions RASS consumes the data This is an integration into the Research Administration Support System The RASS system consumes the data from the staging database N/A 60,000 records Nightly Oracle Database in AWS Research Administration Information Services (RAIS) no N/A Oracle N/A yes no no yes
2024-03-15
2024-03-15 Research Vice President for Research and Innovation LDAP Directory Integration into RASS LDAP Directory Integration into RASS N/A LDAP Directory Integration into RASS HR|Student Campus LDAP Directory Directory information about students, employees, affiliates, and retirees are extracted from LDAP, stored in a staging database, combined with Workday rows and some calculated columns and consumed by RASS nightly Currently active Cornell affiliates (not alumni) RASS consumes the data This is an integration into the Research Administration Support System The RASS system consumes the data from the staging database N/A 50,000 records Nightly Oracle Database in AWS Research Administration Information Services (RAIS) no N/A Oracle N/A yes no no yes
2024-03-15
2024-03-27 Research OVPR and Student Data Committee CNF NEMO CNF NEMO N/A CNF NEMO Sponsored Research|Student|Other RS2, NextGen Dynamic Forms RS2 card swipe data via RS2 API. NextGen user and prorject proposal form data via manual entry. Active CNF users and projects since 2009. Data is consumed by CNF users and staff and usage data is imported into Quickbooks. CNF users and staff Web interface and API na thousands when the CNF labs are open and operating prod on premise in Duffield and Phillips; test in AWS VM; EZBackup CNF no NA PostgreSQL Relational no yes no no
2024-03-27
2024-03-27 Research VP Financial Affairs, OVPR, Student Data Committee CNF Quickbooks CNF Quickbooks N/A CNF Quickbooks Financial Data|Sponsored Research|Other CNF NEMO and KFS Usage data and "customers" are exported from NEMO to CNF Quickbooks. KFS Account Numbers or billing information is provided by lab users, PIs, or department/company account representatives. Starting with the January 2024 billing cycle None CNF users and staff Web interface and Email na thousands monthly Cloud CNF no NA Quickbooks underlying whatever Quickbooks underlying whatever yes yes no no
2024-03-27
2024-04-10 Human Ecology Rachel Dunifon Administrative Data Administrative Data N/A Administrative Data Financial Data|HR|Other Workday, Local Data Data collected for HR and administrative actions. This data includes information collected for Flex Work Agreements, Request to Hire, Student Request to Hire, and classroom satisfaction. Used for administrative actions, workflows, and processing. CHE administration and departments Frevvo, Tableau, SQL Frevvo, Tableau TBD Daily Human Ecology CHE IT no drh222 SQL Server Denormalized no yes yes no
2024-04-10
2024-04-10 Human Ecology Rachel Dunifon Course Evaluation Data Course Evaluation Data N/A Course Evaluation Data Student SADW, Local Course Evaluation Data for each semester with numeric and open text responses Used for faculty tenure packages, course reviews, faculty annual reviews, and student satisfaction. CHE Administration and Academic Departments SQL, Tableau, Custom Apps Tableau TBD By Semester Human Ecology CHE IT no drh222 SQL Server Denormalized no no no no
2024-04-10
2024-04-10 Brooks School of Public Policy Colleen Barry N/A Admissions Database N/A Admissions Student SADW PeopleSoft Admissions data and local data entered by CHE admissions office PeopleSoft Admissions data and local data entered by CHE admissions office Brooks Admissions Office and College Departments SQL, Custom App, Tableau Tableau, ColdFusion, Custom Web App TBD Nightly Human Ecology CHE IT no drh222 SQL Server Denormalized no no no no
2024-04-10
2024-04-10 Brooks School of Public Policy Colleen Barry N/A Blackbooks N/A College Blackbooks Financial Data|HR|Student SADW, KDW, RASS Financial, HR, Student and locally collected data used for administrative reporting Financial, HR, Student and locally collected data used for administrative reporting Brooks administration and departments SQL, Tableau Tableau, Custom Web App TBD Monthly, Quarterly, Yearly and as needed Human Ecology CHE IT no drh222 SQL Server Denormalized no yes yes no
2024-04-10
2024-04-10 Brooks School of Public Policy Colleen Barry N/A Budget Database N/A Budget Database Financial Data|Planning and Budget KDW, Local Financial, Budget and local data entered by Brooks Finance & Budget office used for administrative reporting Financial, Budget and local data entered by Brooks Finance & Budget office used for administrative reporting Brooks administration and departments SQL, Tableau, MS Access Tableau, MS Access TBD Monthly, Quarterly, Yearly and as needed Human Ecology CHE IT no drh222 SQL Server, MS Access Denormalized no yes yes no
2024-04-10
2024-04-10 Brooks School of Public Policy Colleen Barry Faculty Annual Statistics Faculty Annual Statistics N/A Faculty Annual Statistics Financial Data|HR|Sponsored Research|Student SADW, KDW, RASS Data included Direct Reports, Advising Students, Class Enrollments, UG credit hours taught, accounts, OSP Awards and Proposals, and course evaluation data. Statistical data used to aid in the yearly faculty review process. Brooks administration and departments SQL, Tableau Tableau TBD Monthly Human Ecology CHE IT no drh222 SQL Server Denormalized no yes yes no
2024-04-10
2024-04-10 Brooks School of Public Policy Colleen Barry N/A HR Local Database N/A Workday HR Data HR|Other Workday Workday data for Active Jobs, AIS, PAIDS, and Workday Actions. HR and local data entered by CHE Human Resource office used for administrative reporting Brooks administration and departments Tableau, Custom Apps, SQL ColdFusion, Tableau, Custom Web App TBD Nightly Human Ecology CHE IT no drh222 SQL Server Denormalized no yes yes no
2024-04-10
2024-04-10 Brooks School of Public Policy Colleen Barry N/A Student N/A Student Student SADW Peoplesoft student data used for administrative and department reporting Student data used for administrative and department reporting Brooks administration and departments SQL, Tableau, Custom Apps SQL, Tableau, Custom Apps TBD Nightly Human Ecology CHE IT no drh222 SQL Server Denormalized no yes no no
2024-04-10
2024-04-10 Brooks School of Public Policy Colleen Barry N/A Student Petition Data N/A Student Petition Data Student|Other SADW, Local Student petition data surrounding requests for Change of Major, Add/Drop Enrollments, Special Studies, TA forms, General Petitions, Curriculum Waiver/Substitution, Over 18 Credits, Withdraw from a course, In-Absentia Form, Cross-listed course change requests, Request to Graduate Early, and Graduation Application. Used to process student record changes initiated by the student for the registrar office to take action on. Brooks administration and departments Frevvo, Tableau Tableau TBD Daily Human Ecology CHE IT no drh222 SQL Server Denormalized no yes yes no
2024-04-10
2024-04-10 Brooks School of Public Policy Colleen Barry Faculty KFS Account Review Faculty KFS Account Review N/A Faculty KFS Account Review Financial Data|Other KDW Data collected here is faculty's acknowledgement they have reviewed their KFS open account activities on a bi-monthly basis. Data collected is account activity information from KFS data warehouse and faculty's netid and date of acknowledgement. Data collected here is faculty's acknowledgement they have reviewed their KFS open account activities on a bi-monthly basis. Data collected is account activity information from KFS data warehouse and faculty's netid and date of acknowledgement. Brooks administration and departments SQL, Tableau Tableau TBD Monthly Human Ecology CHE IT no drh222 SQL Server Denormalized no yes yes no
2024-04-10
2024-04-10 Brooks School of Public Policy Colleen Barry Administrative Data Administrative Data N/A Administrative Data Financial Data|HR|Other Workday, Local Data Data collected for HR and administrative actions. This data includes information collected for Flex Work Agreements, Request to Hire, Student Request to Hire, and classroom satisfaction. Used for administrative actions, workflows, and processing. CHE administration and departments Frevvo, Tableau, SQL Frevvo, Tableau TBD Daily Human Ecology CHE IT no drh222 SQL Server Denormalized no yes yes no
2024-04-10
2024-04-10 Brooks School of Public Policy Colleen Barry Course Evaluation Data Course Evaluation Data N/A Course Evaluation Data Student SADW, Local Course Evaluation Data for each semester with numeric and open text responses Used for faculty tenure packages, course reviews, faculty annual reviews, and student satisfaction. Brooks Administration and Academic Departments SQL, Tableau, Custom Apps Tableau TBD By Semester Human Ecology CHE IT no drh222 SQL Server Denormalized no yes yes no
2024-04-10
2024-06-28 Veterinary Medicine Meg Thompson ezyVet ezyVet N/A ezyVet Other ezyVet All CUHA data CUHA Web, DMS CVM Data Lake Millions Continuously Cloud - ezyVet ezyVet no vmithelpdesk@cornell.edu MySQL Relational no yes no no
2024-06-28
2024-07-16 Veterinary Medicine Marta Castelhano (mgc27) Biobank Biobank N/A Biobank Other Biobank Biobank is the system of record for tissue and blood samples. All biobank data Biobank and researchers Vet Medicine reserachers Tableau, OpenSearch, QuickSight, Custom Application Tableau, QuickSight 31K animals Daily AWS VMIT no https://www.vet.cornell.edu/departments-centers-and-institutes/cornell-veterinary-biobank PostGreSQL and OpenSearch Relational no no no no
2024-07-16
2024-07-25 Veterinary Medicine Jen Mailey (jam333) CVM Admissions CVM Admissions N/A CVM Admissions Financial Data|Student Peoplesoft, Veterinary Medical College Applicatio Service (VMCAS) Cornell Peoplesoft for student data, VMCAS is a centralized industry service for Veterinary Medicine college applications Several years history CVM Admissions, Peoplesoft CVM Admissions, Faculty Web Tableau, QuickSight, MS Access 10,0000 Annually Cloud, AWS VMIT no vmithelpdesk@cornell.edu MS SQL Server Relational no no no no
2024-07-25