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 Contact Person 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 Dan Dwyer Vice President for Financial Affairs and University Controller ADW Accounting Data Warehouse Edit View 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 Vicky Mikula EMN Emergency Mass Notification Edit View 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 Jane VanDerzee Vice President, Facilities Services FIKFSDM Facilities Inventory DM Edit View 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 Jeff Christen EDW CU Person Edit View 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 Seth Brahler Vice President, Human Resources HRPY Human Resources and Payroll Datamart Edit View 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 Jeff Christen Vice President, Planning and Budget IDW Institutional Intelligence Data Warehouse Edit View 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 Dan Dwyer Vice President for Financial Affairs and University Controller KDW Kuali Data Warehouse Edit View 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 Paul Davis RADM Research Administration Data Mart -- mostly frozen 7/2019 Edit View 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 Jeffrey Silber OSPWH Office of Sponsored Programs Warehouse -- Frozen 7/2019 Edit View 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 Lisa Clark SADW Student Data Mart (People Soft) Edit View 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 Don Sevey SAVAT Student value added tables Edit View 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 Demian Cummings Kathryn Boor GRADAID Grad Aid Edit View 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 Kelley Yeomans Vice President, Facilities Services EBS_DM EBS - Utility Billing Edit View 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 Kelley Yeomans Vice President, Facilities Services MAXIMO_DM Maximo Edit View 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 Mark Wheeler Vice President, Planning and Budget Budget Legacy Budget Edit View 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
2020-02-03 Human Ecology Randi Rainbow N/A Admissions Database Edit View Student 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 Depatments Tableau, ColdFusion Reports, Custom Web App TBD As Needed CIT - Server Farm CHE IT N/A N/A
2020-02-03
2020-02-07 Human Ecology Randi Rainbow N/A Blackbooks Edit View Financial Data|HR|Student 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 Tableau, ColdFusion Reports, Custom Web App TBD Monthly, Quarterly, Yearly and as needed Human Ecology CHE IT N/A N/A
2020-02-07
2023-10-17 Human Ecology Randi Rainbow Vice President, Planning and Budget N/A Budget Database Edit View Financial Data|Planning and Budget Financial, Budget and local data entered by CHE/Brooks Finance & Budget office used for administrative reporting Financial, Budget and local data entered by CHE/Brooks Finance & Budget office used for administrative reporting CHE administration and departments Tableau, ColdFusion Reports, MS Access TBD Monthly, Quarterly, Yearly and as needed Human Ecology CHE IT N/A N/A
2020-02-07
2023-10-17 Human Ecology Randi Rainbow FAR Faculty Annual Report - Deprecated Edit View HR|Sponsored Research|Other Faculty reported data on yearly activities (research, publications, outreach, teaching, etc.) Faculty reported data on yearly activities (research, publications, outreach, teaching, etc.) CHE administration and departments Tableau, ColdFusion Reports, Custom Web App TBD Faculty can enter data on a daily basis Human Ecology CHE IT N/A N/A
2020-02-10
2020-02-10 Human Ecology Randi Rainbow N/A HR Local Database Edit View HR|Other HR and local data entered by CHE Human Resource office used for administrative reporting HR and local data entered by CHE Human Resource office used for administrative reporting CHE administration and departments ColdFusion Reports, Custom Web App TBD Nightly Human Ecology CHE IT N/A N/A
2020-02-10
2023-10-17 Human Ecology Randi Rainbow N/A Student Data Edit View Student Student data used for administrative and department reporting Student data used for administrative and department reporting CHE administration and departments ColdFusion Reports, Custom Web App TBD Nightly Human Ecology CHE IT N/A N/A
2020-02-11
2023-11-06 Agriculture and Life Sciences Velvet Monroe Vice President, Financial Affairs; Vice President, Human Resources;Sr Vice Provo KDW CALSDW Edit View 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 Kelley Sullivan Vice President, Student and Academic Services DUST CALS - DUST Edit View 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 Manuel Calimlim CISIS CISIS Edit View 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 Manuel Calimlim COECIS ITSG FDS COECIS Annual_Reporting Edit View 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 Manuel Calimlim COECIS ITSG Finance COECIS Finance Edit View 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 Manuel Calimlim COECIS ITSG Student Budget Model COECIS Student Budget Model Edit View 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 Seth Brahler VP HR Workday HCM Workday HCM Edit View 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 Seth Brahler VP HR Workday AIS Workday AIS (Academic Information System) Edit View 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 Seth Brahler VP Finance Workday Payroll Workday Payroll Edit View 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 Cynthia Sedlacek Vice President for Financial Affairs and University Controller AS - KFS Budget (currently frozen with move to Longview) Edit View 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 Cynthia Sedlacek Vice President, Planning and Budget AS - Longview AS - Longview Edit View 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 Cynthia Sedlacek AS - Faculty Salaries and Promotion Reviews AS - Faculty Salaries and Promotion Reviews Edit View 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 Donna Lynch-Cunningham AS - SIP Edit View 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 Adrienne Clay AS - Chairs Edit View 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 Cynthia Sedlacek AS - Committee Elections Edit View 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 Cynthia Sedlacek AS - Annual Report Edit View 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 Cynthia Sedlacek AS - Workday AS - Workday Edit View 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 Duncan Bell AS - DUST Edit View 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 Frank Strickland Rachel Bean MARS AS - MARS Edit View 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 Cynthia Sedlacek AS - Distribution Database Edit View 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 Frank Strickland AS - OLGAA Edit View 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 Frank Strickland AS - OAR Edit View 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 Frank Strickland AS - Data.Arts Edit View 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 Cynthia Sedlacek AS - Course Review Edit View 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 Debra Morey AS - EPC/AIHB election Edit View 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 Cynthia Sedlacek AS - Course Evals Edit View 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 Adrienne Clay AS - Faculty Meeting Edit View 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 Cynthia Sedlacek AS - College Committee Elections Edit View 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 Donna Newton AS - First-Year Writing Seminars Edit View 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 Pat Hine AS - Chemistry Labs Waiting List Edit View 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 Pat Hine AS - Chemistry Grading Edit View 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 Cynthia Sedlacek Decommissioned Decommissioned AS - Brio Hyperion Reporting Edit View 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 Cynthia Sedlacek Base Budget DB AS - Base Budget DB Edit View 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 Cynthia Sedlacek HR, Registrar, Alumni, Finance Colleges, Libraries, CIS and Research KPI Edit View 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 Paul Davis Sr Vice Provost of RA Cornell Research Metrics Edit View 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 Paul Davis Director of ORIA ORIA KPI Edit View 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 Paul Davis Director of RAIS RAIS Project Tracker -- Retired Edit View 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 Lisa Stensland Vice President for Alumni Affairs and Development iModules CU Connect Edit View 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 Lisa Stensland AAD AVP Administration iModules iModules Edit View 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 Lisa Stensland AAD AVP Administration CRDM Alumni CRDM Edit View 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 Norah Selig Vice President for Alumni Affairs and Development VAS AAD Value Added Space Edit View 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 Heather Wells AAD AVP Administration CUVolunteer CU Volunteer Edit View 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 Lisa Stensland AAD AVP Administration Stewardship Database Donor Relations Stewardship Database Edit View 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 Lisa Stensland AAD AVP Administration Trustrite Trustrite Edit View 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 Lisa Stensland AAD AVP Administration GiftWrap GiftWrap Edit View 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 Lisa Stensland Vice President for Alumni Affairs and Development GPS / doCUments GPS / doCUments Edit View 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 Marin Clarkberg IRP All Personnel 2002 to NOW Edit View 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 Marin Clarkberg IRP Academic Factbook Custom Extract Edit View 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 Marin Clarkberg IRP Class Size Edit View 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 Marin Clarkberg Rooms with enrollment Edit View 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 Marin Clarkberg IRP Degrees Conferred 2002 to Now Edit View 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 Marin Clarkberg IRP Enrollment 2002 to NOW Edit View 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 Marin Clarkberg IRP UTDP Edit View 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 Marin Clarkberg IRP UG Graduation 1988 on Edit View 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 Marin Clarkberg IRP 1869 on Edit View 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 Marin Clarkberg IRP IRP Survey Results (various) Edit View 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 Marin Clarkberg IRP Admiss Fall 08 on Edit View 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 Marin Clarkberg IRP Faculty 1982 to now Edit View 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 Marin Clarkberg IRP PAIDS Plus Edit View 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 Marin Clarkberg IRP AAUDE fles Edit View 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 Marin Clarkberg IRP AAUP files Edit View 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 Marin Clarkberg IRP Academic Insights Edit View 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 Marin Clarkberg IRP Academic Analytics Edit View 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 Marin Clarkberg IRP Runzheimer - Cost of Living Edit View 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 Marin Clarkberg IRP APDB AER extracts Edit View 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 Marin Clarkberg IRP Campus Housing file Edit View 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 Marin Clarkberg IRP Greek Life Participation Edit View 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 Marin Clarkberg IRP Enrollment snaps (Fall and Spring) Edit View 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 Marin Clarkberg IRP Promotions/Hires/Terms Edit View 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 Marin Clarkberg IRP Student/Faculty Ratios Edit View 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 Marin Clarkberg IRP Daily Admissions snaps Edit View 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 Marin Clarkberg IRP Admissions July File Edit View 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 Marin Clarkberg IRP Bundy Files Edit View 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 Jonathan Burdick Admissions Self Service Edit View Other Admissions self service Admissions self service TBD N/A
2020-02-11
2020-02-10 Facilities Kelley Yeomans Vice President, Facilities Services Maximo_DM2 Maximo2 Edit View 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 Tami Hastings Vice President for Financial Affairs and University Controller Concur Concur Travel and Expense System Edit View 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 Dan Dwyer Vice President for Financial Affairs and University Controller Travel Legacy Travel System Edit View 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 Manuel Calimlim GUMBI Group User Management and Billing Edit View 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 Manuel Calimlim CMSX Course Management System Edit View 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 Manuel Calimlim Tech Emergency Alerts Edit View 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 Manuel Calimlim acalog db acalog db Edit View 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 Manuel Calimlim Engineering Petitions Edit View 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 Manuel Calimlim COECIS ITSG Freshman scheduling Freshman scheduling Edit View 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 Manuel Calimlim COECIS ITSG Frosh-Fall Frosh-Fall (FileMaker) Edit View 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 Manuel Calimlim COECIS ITSG Student Library COE Student Library Edit View 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 Manuel Calimlim MSE GRA Database Edit View 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 Manuel Calimlim CIS Affiliations Applications Edit View 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 Manuel Calimlim CS UnderGrad DB Edit View 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 Manuel Calimlim COECIS ITSG CoeCISCheckList CIS Degree Audit Checklists Edit View 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 Manuel Calimlim COECIS ITSG ta_hiring CIS TA Hiring Edit View 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 Manuel Calimlim COECIS ITSG BOOM BOOM Research Projects Edit View 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 Manuel Calimlim IS Majors Edit View 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 Manuel Calimlim CS Incoming Affiliations Edit View 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 Manuel Calimlim COECIS ITSG cis_room_requests CIS Space Inventory Edit View 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 Manuel Calimlim CS Course Prereq Reporting Edit View 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 Manuel Calimlim COECIS ITSG cis_meng_projects CIS MEng Projects Edit View 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 Manuel Calimlim COECIS ITSG DAR Door Access Request database Edit View 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 Manuel Calimlim wass COECIS Web Appointment Scheduling System Edit View 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 Manuel Calimlim ECE Majors Edit View 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 Manuel Calimlim COECIS ITSG FrozenFiles Undergrad DB FrozenFiles Undergrad DB Edit View 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 Manuel Calimlim COECIS ITSG Grade Slips Grade Slips Edit View 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 Manuel Calimlim COECIS ITSG MEng Students Library MEng Students Library Edit View 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 Manuel Calimlim COECIS ITSG UNAFL 2-2 COECIS Unaffiliated 2-2s Edit View 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 Manuel Calimlim MSE Accounts DB Edit View 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 Manuel Calimlim MSE MS/MEng Students Edit View 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 Manuel Calimlim COECIS ITSG Contact Hours Contact Hours Edit View 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 Manuel Calimlim Engineering Leaves Edit View 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 Manuel Calimlim MAE Datamart Edit View 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 Manuel Calimlim MEng Projects Edit View 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 Manuel Calimlim MEng Survey Results Edit View 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 Manuel Calimlim COECIS ITSG TA Eval TA Eval Edit View 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 Manuel Calimlim COECIS ITSG AEW Evals Academic Excellence Workshop Evals Edit View 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 Manuel Calimlim COE Student Project Funding Edit View 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 Manuel Calimlim Cornell Directory Edit View 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 Manuel Calimlim COECIS ITSG Course Eval Course Eval Edit View 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 Manuel Calimlim COECIS ITSG ENDM ENDM Edit View 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 Manuel Calimlim Coop Offers Edit View 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 Manuel Calimlim COECIS ITSG ENGRG 1050 ENGRG 1050 Edit View 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 Manuel Calimlim Kayako helpdesk Edit View 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 Manuel Calimlim COECIS ITSG ugResearch Ugrad research project tracking Edit View 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 Andre Hafner AAPFM AAP Filemaker Edit View 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 Rosane Mordt AAPAI AAP Activity Insight Edit View 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 Rosane Mordt AAPSE AAP Smart Evals Edit View 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 Mike Barre Vice President, Human Resources CALS Admin org (Salesforce) CALS Admin Org on Salesforce Edit View 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 Manuel Calimlim asst_dean_funding COE asst_dean_funding Edit View 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 Manuel Calimlim COECIS ITSG Frosh Advisors Frosh Advisors Edit View 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 Manuel Calimlim COECIS ITSG PEAS PEAS Edit View 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 Manuel Calimlim COECIS ITSG EN_Forms EN Forms Edit View 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 Manuel Calimlim COECIS ITSG EN_Surveys EN Surveys Edit View 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 Manuel Calimlim COECIS ITSG FacultyAdvisors Faculty Advisors Edit View 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 Manuel Calimlim COECIS ITSG FROSH Response FROSH Response Edit View 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 Manuel Calimlim COECIS ITSG hrsc_hiring_form COECIS Onboarding Edit View 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 Manuel Calimlim interviews COE interviews Edit View 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 Manuel Calimlim mailman Mailman Edit View 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 Manuel Calimlim COECIS ITSG SIP Salary Improvement Program Edit View 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 Manuel Calimlim COECIS ITSG WorkdayData COECIS WorkdayData Edit View 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 Manuel Calimlim CS UnderGrad DB Edit View 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 Manuel Calimlim IS Minors DB Edit View 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 Manuel Calimlim CIS AAD Prospects Edit View 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 Manuel Calimlim CASPAC Edit View 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 Manuel Calimlim CBE GRA Database Edit View Financial Data|Student Financial and Student data Chemical and Biomolecular Engineering grad student tracking TBD N/A
2020-10-24
2020-02-18 Veterinary Medicine Ronald Seccia VetView Edit View Financial Data|Health|Other Millions No
2020-02-18
2024-02-22 Industrial and Labor Relations Dan Elswit Rebecca Hann N/A ILR Outreach Workshop Registration Data Edit View 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 Dan Elswit TBD IT and Facilities Asset inventory IT and Facilities Asset inventory Edit View 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 Dan Elswit Rebecca Hann CourseEvals Course Evaluations Edit View 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 Dan Elswit Rebecca Hann EXPLORE EXPLORE Edit View 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 Dan Elswit Rebecca Hann Watermark Watermark Insights Edit View 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 Dan Elswit Rebecca Hann CIPD Credit Internship Program data Edit View 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 Dan Elswit Rebecca Hann EMS EMS (Event management System) Edit View 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 Dan Elswit This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. This solution is deprecated and can be deleted. Edit View 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 Dan Elswit Rebecca Hann N/A ILR student contact data Edit View 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 Debbi Kruszewski-Warner MBA Admissions Edit View 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 Debbi Kruszewski-Warner Academic Planning Edit View 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 Debbi Kruszewski-Warner External Relations CRM Edit View Alumni|Other Corporate, Career Management, C&I, Alumni Track interactions and engagement with corporate partners TBD N/A
2020-02-20
2020-02-21 SC Johnson College of Business Debbi Kruszewski-Warner Activity Insight Edit View Other Faculty Stores faculty information TBD TRA
2020-02-20
2020-02-21 SC Johnson College of Business Debbi Kruszewski-Warner Career Management CRM Edit View 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 Debbi Kruszewski-Warner MBA Admissions Applicant Yield Event Registration Edit View 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 Debbi Kruszewski-Warner Cvent Edit View Other Event information Event Management TBD TRA
2020-02-20
2020-02-21 SC Johnson College of Business Debbi Kruszewski-Warner Campus Groups Edit View Student Student activity data Student Club management and calendar TBD TRA
2020-02-20
2020-02-21 SC Johnson College of Business Debbi Kruszewski-Warner GradLeaders Edit View Student|Other Student, corporate Recruitment and career services TBD TRA
2020-02-20
2020-02-21 SC Johnson College of Business Debbi Kruszewski-Warner 12Twenty Edit View 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 Debbi Kruszewski-Warner Pardot Edit View Other Data is housed in Salesforce. Marketing and Lead/Gen TBD TRA
2020-02-20
2020-02-21 SC Johnson College of Business Debbi Kruszewski-Warner Budget Entry Form Edit View Planning and Budget Budget Staff enter budget information for use by Finance TBD N/A
2020-02-20
2020-02-21 SC Johnson College of Business Debbi Kruszewski-Warner Linvio Event Management Edit View 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
2020-02-21 SC Johnson College of Business Debbi Kruszewski-Warner Student Services System Edit View Student Student Dyson, Johnson, SHA, Baker degree audits, course evals, course directories, graduation application, practice credits, petition form, scholarship survey, transfer credit form TBD N/A
2020-02-20
2023-03-29 SC Johnson College of Business Dave DeHaan ERS (Employee Request System) Edit View HR Employee position descriptions, proposed compensation, rationale for need, etc. Submit and track requests for new staff, promotions, band changes, etc. 223 records as of 3/29/2023 N/A
2020-02-20
2020-02-20 Debbi Kruszewski-Warner Faculty Profiles Edit View Other Faculty Faculty profile pages on the college web sites TBD N/A
2020-02-20
2020-02-20 Debbi Kruszewski-Warner Student Employment System Edit View Student Student Student employment appointment system for the college TBD N/A
2020-02-20
2020-02-20 Debbi Kruszewski-Warner SHA Course scheduling web tool Edit View 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 Paul Weber Registrar database Edit View 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 Paul Weber Finance database Edit View 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 Paul Weber Inventory data Edit View 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 Paul Weber Audio Visual Inventory Edit View 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 Greg Delisle Elaine Westbrooks RMC-Camera-Collector RMC Camera Collector Edit View 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 Sharon Beltaine Elaine Westbrooks CULLDP CULLDP Edit View 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 Debra Howell Elaine Westbrooks FOLIO FOLIO Edit View 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 Pete Stergion Elaine Westbrooks LibInsight LibInsight Edit View 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 Paul Weber Admissions data Edit View 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 Mary Garin ILR Grad Students Edit View 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 Schimenti Rebecca Hann Transfers Transfer Evaluation Database Edit View 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 Manuel Calimlim Axiom Edit View 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 Manuel Calimlim Tech Campus DailyCheck Edit View 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 Manuel Calimlim ExpertPower Edit View 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 Manuel Calimlim Bacnet BMS Edit View 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 Dan Elswit Rebecca hann Licenses Software license tracking system Edit View 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 Dan Elswit Rebecca Hann Grad Leads Graduate Program Marketing Data Edit View 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 Dan Elswit Rebecca Hann N/A Outreach Program Leads Edit View 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 Paul Davis RASS Datamart Edit View 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 Stacy Clementson CNF User COVID Vaccination Verification Log Edit View 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 David Botsch CORAL Edit View 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 Ron Olson CNF Workforce Development Survey Edit View 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 Melanie-Claire Mallison CNF REU Interns Edit View 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 Melanie-Claire Mallison CNF Corporate Contact List Edit View 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 Melanie-Claire Mallison CNF Marketing Contacts Edit View 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 Melanie-Claire Mallison CNF NSF Contact Marketing List Edit View 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 Dan Elswit Rebecca Hann Course Banking Faculty Course Banking data Edit View 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 Kevin Mannella Kathryn Boor NA CollegeNet/ApplyWeb - admissions data Edit View 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 Cynthia Sedlacek Academic Leaves Academic Leaves Edit View 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 James Vanee BRC LIMS Edit View 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 Mike Barre Salary Certification System (ECS) Edit View 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 Pete Stergion Elaine Westbrooks SenSource SenSource Door Counter Edit View 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 Graham Dobson ApplyWeb CollegeNET Edit View 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 Graham Dobson SCE Student System Edit View 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 Graham Dobson Certificates Edit View 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 Mitch Wiedemann On-line Enrollment (OES) Edit View 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 Graham Dobson Student/Faculty Portal Edit View 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 Mitch Wiedemann Web Content Management System Edit View 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 Mitch Wiedemann Prospector Edit View 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 Graham Dobson Precollege Self Service Edit View 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 Graham Dobson Course Budget System (CBS) Edit View 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 Graham Dobson Course Proposal System (CPS) Edit View 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 Graham Dobson Course Evaluations Edit View 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 Graham Dobson Role Manager Edit View 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 Prabhakaran Nagarajan eCornell: Potential Students CRM Edit View 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 Prabhakaran Nagarajan eCornell: Student Information System Edit View 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 Prabhakaran Nagarajan eCornell: Canvas Edit View 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 Prabhakaran Nagarajan eCornell: Surveys Edit View 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 Lisa Bushlow AlumnIQ Edit View 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 Matt Carcella Brightcrowd Edit View 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 Ashley Budd Campus Sonar Edit View 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 Diane Pierce CR_Ack (Gift Acknowledgments) Edit View 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 Jon Gregory Crowdfunding (a.k.a. Scalefunder) Edit View 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 Nicole Cook Digital Engagement Center (was CampusCall) Edit View 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 Nicole Cook donorCentrics Edit View Alumni Benchmarking data Benchmarking data N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Andrew Gossen Evertrue Edit View 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 Michael O'Neill Forumm Edit View Alumni Event hosting and attendance, alumni engagement Online event hosting N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Ian Garrett FreeWill Edit View 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 Sarah Robinson GetThru Edit View Alumni Alumni engagement through text messaging Texting service N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Diane Pierce Gift Processing System (GPS) Edit View 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 Wendy Fuller Joint Records Processing (JRP) Edit View 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 Jon Gregory Giving Day Edit View 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 Michael O'Neill Maestro Edit View 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 Sonja Kelly PBC Guru Edit View Alumni Alumni outreach and engagement Alumni book club N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Tim Olivieri Prospect Capacity Edit View 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 Tim Olivieri RelSci Edit View Alumni Alumni demographics Relationship mapping N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Lin Xue Reunion Crediting Edit View 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 Lin Xue Reunion Postcards App Edit View 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 Casey Lucier Social Tables Edit View 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 Andrew Gossen Social Toaster Edit View 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 Michael O'Neill Sprout Social Edit View 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 Ashley Budd ThankView Edit View Alumni Alumni engagement Personalized thank you videos N/A N/A
2023-02-28
2023-02-28 Alumni Affairs and Development Carrie Corbin Trust Portal Edit View 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 Tim Olivieri Windfall Edit View 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 Heather Wells Yes Elections Edit View 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 Kaitlyn Ruhf Otter.ai Edit View 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 Diane Pierce AlumniFinder Edit View 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 Michael O'Neill Flickr Edit View 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 Tony Damiani Edit View 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
2023-03-29 SC Johnson College of Business Dave DeHaan BERT (Business Expense Request Tracker) Edit View Financial Data|Planning and Budget Financial Data: Cost of what is being purchased. Planning and Budget: Contracts, Statements of Need, other details validating a need for purchase. College level approval of purchases. 14,592 records as of 3/29/2023 Is this question asking about a TRA or something else?
2023-03-29
2023-03-31 SC Johnson College of Business Dave DeHaan TIPS database (Hotel Gratuities) Edit View Student Tip $ amount data for tipped students and staff in the Statler Hotel. Tips & tip-out tracking for tipped staff in the Statler Hotel TBD N/A
2023-03-31
2023-03-31 SC Johnson College of Business Dave DeHaan Johnson School Class Agents Edit View Alumni|Student Names and $ amounts given, shown on public website alumni and student fund raising information. TBD N/A
2023-03-31
2023-04-09 Student and Academic Services Don Sevey Dining Data Edit View 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 Don Sevey Local address for campus housing Edit View 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 Seth Brahler CULearn Edit View Other Course completions Cornell's staff learning management system TBD CIT
2023-09-12
2023-11-27 Student and Academic Services Don Sevey Dan Sweeney Customer records Customer records Edit View 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
2023-10-17 Human Ecology David Hiner Student Petition Data Edit View Student 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 request, 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. TBD N/A
2023-10-17
2023-10-17 Human Ecology David Hiner Faculty KFS Account Review Edit View Financial Data 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. TBD N/A
2023-10-17
2023-10-25 Continuing Education and Summer Sessions Graham Dobson Vice President, Human Resources Annual Review Sign Off SCE Annual Review Sign Off for Staff Edit View 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 J.P. Brannan TBD TDX TeamDynamix Edit View 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 Todd Maniscalco Student Data Commitee (See https://policy.cornell.edu/policy-library/data-stewar Canvas Canvas Edit View 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 Don Sevey Ryan Lombardi POS data Point of Sale data Edit View 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 Dee Zajac Dan Sweeney Guardian Student Data Guardian Student Data Edit View 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 Dee Zajac Dan Sweeney Guardian Employee Data Guardian Employee Data Edit View 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 Veronica Aguirre Don Sevey CampusGroups.com Campus Groups Edit View 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 Jane McClellan Dan Sweeney JE Inbound KFS JE Inbound to NetSuite Edit View 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 Jane McClellan Dan Sweeney NS-IDM-001 Identity Management Job Edit View 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 Jane McClellan Dan Sweeney NS-PS-001 Course Enrollment Data Edit View 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 Jane McClellan Dan Sweeney NS-PS-002 Course List Data Edit View 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 Jane McClellan Dan Sweeney SCL Axiom SCL Axiom Edit View 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 Jane McClellan Dan Sweeney Avatax Avatax Edit View 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 Jane McClellan Dan Sweeney CAMP Billing CAMP Billing Edit View 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 Jane McClellan Dan Sweeney NetSuite CornellCard NetSuite CornellCard Edit View 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 Jane McClellan Dan Sweeney Payroll Deduction CRS Payroll Deduction Edit View 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 Jane McClellan Dan Sweeney NetSuite ERP NetSuite Edit View 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 Don Sevey Ryan Lombardi CS Gold data Meal Plan data Edit View 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 Don Sevey Ryan Lombardi GET data GET data Edit View 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 Daniel Longaker Ryan Lombardi CH Leadership Dashboard Data Cornell Health Utilization Data Edit View 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 Manuel Calimlim COECIS ITSG FroshFall (MSSQL Server) FroshFall (MSSQL Server) Edit View 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 Manuel Calimlim COECIS ITSG Dean's List Dean's List Edit View 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 Manuel Calimlim COECIS ITSG FUINC FUINC Edit View 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 Manuel Calimlim COECIS ITSG ad_data Active Directory Data Edit View 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 Manuel Calimlim COECIS ITSG EPICC Awards EPICC Awards Edit View 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 Paul Davis Vice President for Research and Innovation College Research Metrics College Research Metrics Edit View 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 Paul Davis Vice President for Research and Innovation KFS Integration into RASS KFS Integration into RASS Edit View 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 Paul Davis Vice President for Research and Innovation Workday Integration into RASS Workday Integration into RASS Edit View 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 Paul Davis Vice President for Research and Innovation LDAP Directory Integration into RASS LDAP Directory Integration into RASS Edit View 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