Get documents about "Original Excel Spreadsheet - Excel
Shared by: liuqingyan
-
Stats
- views:
- 81
- posted:
- 7/26/2011
- language:
- English
- pages:
- 10
Document Sample
Count of College, School or Office
College, School or Office Total
Academic HR 3
Alumni Association 5
Architecture and Urban Planning 5
Arts and Sciences 21
Business School 1
Business Services 4
C&C 20
Capital Projects Office 11
Dentistry 1
Education 2
Educational Outreach 2
Engineering 73
Facilities Services 18
Financial Management 110
Forest Resources 1
Graduate School 6
Health Sciences 10
Human Resources 22
Information School 5
Intercollegiate Athletics 3
Language Learning Center 1
Law School 7
Nursing School 10
Ocean & Fishery Sciences 1
Office of Educational Partnerships 1
Office of External Affairs 2
Office of Global Affairs 1
Office of Minority Affairs 2
Office of Research 3
Planning & Budgeting 6
Public Affairs 2
Public Health 1
School of Medicine 12
Social Work 1
SOM 160
Student Affairs 46
Undergraduate Education 2
University Libraries 3
UW Bothell 27
UW Tacoma 13
UWMC 1
(blank)
Grand Total 625
SOM
Who supports the system (who provides modifications, corrects problems, Who is the business owner (dept responsible for managing the day to day
System-name ID Tag source-file Organization College, School or Office Division Provides campus-wide service? TIER Shadow Sys? System-Type Status Developed-by develops new features?) Who-Operates-System operation of the system) description-function Contact-Person contact-person-email number-of-users System Documentation Location Data Dictionary Location How to request access to the system Vendor-Name Hardware Platform Operating System Database software Language Development Environment User Interface
1099 MISC System OIM OIM Inventory 1 C&C/OIM C&C/OIM Financial Management Accounts Payable Windows Windows Informix MS Access MS Access Fat client
2006-4-2- Outlook client,
ISFutures_Inventory- calendar system; College of Arts & IMAP client,
A&S Dean's Office Mail Server 948 a.xls Provost Arts and Sciences Dean - A&S No 2 mail server Communications, Infrastructure & Middleware Production Sciences Dean's Office College of Arts & Sciences Dean's Office mail service, shared scheduling system Bart Hamilton 75 server Web
Windows Server 2003 MS Exchange Server 2003 client
Systems management server for large
collection of distributed data systems under the
management of the Office of the Registrar.
Office of the Registrar, Tracks users, domains, security, etc. of
Academic Data Management enterprise system Office of the Registrar, Academic Data enterprise systems (UWSDB, Resource 25,
management db 549 tmildon Provost Student Affairs University Registrar No 2 ASTRA? Access to Information, Reporting & Business Intelligence Production Academic Data Management Management Office of the Registrar, Academic Data Management DARwin, others) 15 Server Windows MS Access
Multi-dimensional OLAP data cubes for flexible
academic data analytics. Cubes in production:
Enrollment, Admissions Applications,
Admissions Applicants. Cubes under Cognos
ITRSG needs development: Student Financial Aid, http://depts.washington.edu Upfront,
assessment Departmental Recruitment and Retention. http://ucs.admin.washington.edu/dw /reptreq/datawarehousedefi http://depts.washington.edu/reptreq/for Homegrown, Cognos
Academic Data Warehouse 478 appendices.doc Provost Student Affairs University Registrar Yes 1 Access to Information, Reporting & Business Intelligence Production C&C DWP C&C DWP University Registrar (Academic Data Management) These com Andrew Hummel 100 p/technicalinfo/techinfo.aspx nitions.htm ms/academic-dw-access-request.pdf Cognos Server Windows Server SQL Server Powerplay
2006-4-2- Database/reporting tool to generate Board of
Academic HR Report Database (Board of Regents ISFutures_Inventory- Regents Agenda and Provost Personnel Action
Report) 972 a.xls Provost Academic HR Academic HR No 2 HR & Payroll Other Academic HR Academic HR Academic HR reports. Contains shared lookup tables. Brandon Whitehead 8 Windows Windows MS Access MS Access
Metadata repository for UWSDB, SDB, SDW,
and other student data OLTP and OLAP http://depts.washington.edu/reptreq/
Academic Meta Database 471 tmildon Provost Student Affairs University Registrar Yes 1 Access to Information, Reporting & Business Intelligence Production College of Engineering College of Engineering University Registrar (Academic Data Management) systems Andrew Hummel datawarehousedefinitions.htm na na homegrown server Oracle
Academic Personnel Records 5 systems inventory.xls Provost Academic HR Academic HR No 2 HR & Payroll Development Department Academic HR Academic HR HR system of record for academic personnel
Tracks students enrolled in Law School,
queries SDB for class enrollment, assigns
exam IDs (student take exams anonymously),
Academic Records Management 137 systems inventory.xls Provost Law School Law School No 2 SDB Students, Teaching & Learning prints exam instructions.
Through the use of student ID card readers and
integration with SDB, system restrices lab
access to students enrolled in appropriate
Access Control (CSE Computer Labs) 475 ENG Provost Engineering Engineering No 2 key control Facilities, Transportation & Space courses.
Internal dbs used by SFS. Money is deposited
to US Bank. SFS downloads a report from US
Bank to reconcile and determine how much to
ACH Database 289 systems inventory.xls Executive Vice President Financial Management Student Fiscal Services No 3 Finance & Budget Production Department SFS SFS money to transfer to Bank of America. Peggy Fitzwater
Internal dbs used by SFS. Vendor express -
SFS records money deposited at Bank of
America then uses the ACH spreadsheet to
sort and distribute the appropriate amounts to
ACH Spreadsheet 290 systems inventory.xls
2006-4-2- Executive Vice President Financial Management Student Fiscal Services No 3 Finance & Budget the scholarship dbs, invoice dbs, or tuition. Peggy Fitzwater
ISFutures_Inventory- UW Bothell Network Provide Active directory infrastructure and DNS UW Bothell Network
Active Directory 961 a.xls UW Bothell Chancellor UW Bothell UW Bothell Information Systems Yes 1 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Information Systems for UW Bothell. Operations 1200 server Windows Server SQL Server N/A
University Registrar University Registrar Very large collection of custom databases
(Academic Data (Academic Data designed to meet ad hoc and recurring MS Access,
Ad Hoc Client Databases 473 tmildon Provost Student Affairs University Registrar Yes 1 Access to Information, Reporting & Business Intelligence Production Management) Management) University Registrar (Academic Data Management) information needs of clients on and off campus. Andrew Hummel 15 http://depts.washington.edu/reptreq homegrown Windows Server
server (venus.datamgmt.reg.washington.edu) MS Access, SQL ServerSQL Server
ISFutures_Inventory- Display who provides administrative support to http://norfolk.cs.washington.edu/htbi
admin assistant list 1118 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 3 HR & Payroll Production CSE CS Lab CSE Business Office which faculty Scott Rose rose@cs 10 n-php/admin/AdminAssistants.php Unix postgresql
Report of SOM ICR from
Richard Meeks - Mar tylbrian@u.washington.
Admin office 712 2006.xl Provost SOM SOM - Psychiatry No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar adioso@u.washington.
ADMIN001 586 2006.xl Provost SOM SOM - Genome Sciences No 6 SOM Production Role: SO edu
Web-based service for applicants to view their
Admission Application Status Inquiry OIM OIM Inventory 1 C&C/OIM C&C/OIM Undergraduate Admissions admission application status Windows Windows DMS II Jscript, ASP Vis Studio Web
Permits current and transfer students to apply
for admissions to any number of CoE
departments. Pre-populates form with SDB
info where available; calculates prerequisite
fulfillments based on SDB and entered data.
Admissions Application 121 ENG systems inventory.xls
2006-4-2- Provost Engineering Engineering No 2 SDB Students, Teaching & Learning Provides advisor interface for reviewin
ISFutures_Inventory- Computing & Media Windows
Admissions/Student Services system 982 a.xls Executive Vice President Social Work Social Work No 2 SDB Students, Teaching & Learning Production N/A Services Student Services Track student progress and courses. Roberta Aldrich 15 Server Windows Server MS Access platform
Database of applicants to the school
Law School Computing Tracks student applicants and their status,
Admit-M 139 systems inventory.xls Provost Law School Law School No 2 SDB Students, Teaching & Learning Production Services Law School Admissions imports LSAT information from Law Services. Kathy Swinehart 3 LSAC
Report of SOM ICR from
Richard Meeks - Mar
Advance (SOM) 725 2006.xl Provost SOM SOM - Urology No 6 SOM Production Role: SO eos@u.washington.edu
Records information about the UW's
relationships with its alumni and donors, and
makes the information available to UW staff in http://www.adis.washington
Vice President Development & order for the UW to maintain and strengthen https://devar.washington.edu/depart .edu/policies/Glossary/Aglo PowerBuilder
Advance C/S OIM OIM Inventory Alumni Relations Development & Alumni Relations Advancement Services Yes 1 Access to Information, Reporting & Business Intelligence Production Vendor SunGard BSR C&C/OIM C&C/OIM Advancement Services those relationships. Walt Dryfoos 500 ments/im/Advance/advance.asp ssary.htm SunGard Windows Windows Sybase 12.5 8.X PowerBuilder Enterprise Fat client
Advance Database OIM OIM Inventory 1 C&C/OIM C&C/OIM Development Office Sybase 12.5 Database Backend SyBase AIX AIX ASE 12.5 T-SQL vi, ksh, SQLAnywhere NA
Various programs used to maintain Advance
Advance Nightly Processing OIM OIM Inventory 1 C&C/OIM C&C/OIM Development Office system AIX AIX ASE 12.5 Perl vi NA
Data warehouse aspect of Development and Shawn Drew, Director,
Advance Reporting (ARC) 14 OIM OIM Inventory Provost Alumni Association Development & Alumni Relations Yes 1 Access to Information, Reporting & Business Intelligence Production C&C OIM and C&C OIM and C&C Development Alumni Relations' Advance system. Information Management
Advance/Mainframe Interface OIM OIM Inventory 1 C&C/OIM C&C/OIM Development Office Various programs used to access mainframe UnisysMCP UnisysMCP DMSII COBOL SURE NA
Advance biographic/degree info sent to MyUW
Advance/MyUW OIM OIM Inventory 1 C&C/OIM C&C/OIM Development Office system AIX AIX ASE 12.5 Perl vi NA
Advance/PersonReg OIM OIM Inventory 1 C&C/OIM C&C/OIM Development Office Advance id type info sent to PersonReg II team AIX AIX ASE 12.5 Perl vi NA
<0> What type of data? => LOAN
DEFERRMENT INFO <0> Size/volume of data?
=> SMALL <0> Data used for? => TRACKING
APT LOAN DEFERRMENTS <0> Update freq?
tbl-financial- => MONTHLY <0> How used/purpose? => .
management-decision- Data source: PAPER FORMS COMPLETED BY
Advanced professional training 522 support-inventor Executive Vice President Financial Management Student Fiscal Services No 3 Students, Teaching & Learning STUDENTS Pam Luther NEBULA MS Access
Report of SOM ICR from
Richard Meeks - Mar sreynold@u.washingto
Advanced system 608 2006.xl Provost SOM SOM - Medical History & Ethics No 6 SOM Production Role: SO n.edu
Report of SOM ICR from
Richard Meeks - Mar cabal@u.washington.e
Advanced Test 691 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO du
Report of SOM ICR from
Richard Meeks - Mar dherr@u.washington.e
ADVANCED VAPSHCS METABOLISM COMPUTER 646 2006.xl Provost SOM SOM - Medicine - Metabolism & Endocrinology No 6 SOM Production Role: SO du
Report of SOM ICR from
Richard Meeks - Mar tpineda@u.washington.
Advanced workstations 653 2006.xl Provost SOM SOM - Medicine - Nephrology No 6 SOM Production Role: SO edu
Web-based self-service entry of employee
ethnicity, birthdate, gender, military, disability ASP/SQL/Jscri
Affirmative Action 22 OIM OIM Inventory Provost Office of Minority Affairs Equal Opportunity Yes 1 HR & Payroll Production C&C C&C/OIM C&C/OIM EEO status, and central admin of this data. NT NT SQL Server pt Visual Studio 6.0 Web
Report of SOM ICR from
Richard Meeks - Mar myrnai@u.washington.
Allergy Advanced workstations 614 2006.xl Provost SOM SOM - Medicine - Allergy & Infectious Disease No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar myrnai@u.washington.
Allergy Moderate workstations 615 2006.xl Provost SOM SOM - Medicine - Allergy & Infectious Disease No 6 SOM Production Role: SO edu
2006-4-2- Altiris
ISFutures_Inventory- UW Bothell Network Workstation imaging, management and UW Bothell Network Deployment
Altiris (Mithra, Mitty) 968 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems No 2 Imaging Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Information Systems software deployment Operations 20 server Windows Server SQL Server Server
ISFutures_Inventory- Directory of CSE alumni, with email and web http://www.cs.washington.edu/info/a
alumni directory 1134 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 HR & Payroll Production CSE CS Lab CSE External Relations forwarding Scott Rose rose@cs 250 lumni/services.html Unix postgresql
Report of SOM ICR from
Richard Meeks - Mar jims@u.washington.ed
AMC 720 2006.xl Provost SOM SOM - Rehabilitation Medicine No 6 SOM Production Role: SO u
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
AMCAS DB 567 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
This is parimarily a web server that also
2006-4-2- handles the department intranet. It runs a
ISFutures_Inventory- database that is used by staff, faculty, and
an.me.washington.edu 936 ENG a.xls Provost Engineering Mechanical Engineering No 5 Access to Information, Reporting & Business Intelligence Production Mechanical Engineering Mechanical Engineering Mechanical Engineering students for a wide range of purposes. Brennon Church 200 www.me.washington.edu/myme server FreeBSD MySQL PHP/Apache
Animal Record System 35 systems inventory.xls Provost Health Sciences Primate Center No 3 Research & Grant
OIM Inventory, systems
Animal Use Protocol Application (eSirius) 28 OIM inventory.xls Provost Health Sciences Animal Care No 4 Research & Grant Development Vendor C&C HS eSirius is scheduled for completion 6/06
<0> What type of data? => Annual Report data
generated by C & C <0> Size/volume of data?
=> 20 mb <0> Data used for? => Creating the
tbl-financial- UW Annual report, Federal reporting and
management-decision- reconcilation <0> Update freq? => Annual. Data Mary Jo Hershly, GCA
Annual report information 503 support-inventor Executive Vice President Financial Management GCA No 2 Finance & Budget is updated for each close (Months 1 Systems Development Nebula file server ERGO, MS Access
This is our online application system. Every
student who applies to the college must use it.
It is also used by most faculty and area support
2006-4-2- in the application process and for tracking
ISFutures_Inventory- College of Education student progress. It's as a data source for https://depts.washington.edu/educ/ticke IIS/ASP and
Application Database (College of Education) 927 a.xls Provost Education College of Education Technology Center No 2 SDB Students, Teaching & Learning Production College of Education Technology Center College of Education Student Services analysis (what type of ca Don Ankney 1000 None exists None exists tdb/ Server Windows 2000 Server SQL Server Access
Used to (a) track application materials received
from each applicant, as well as the status of the
application in the review process; (b) create
reports of applicant information, including area
of study, number of applicants, and contact info
Application Processing Documents 151 systems inventory.xls Provost Nursing School Nursing School No 2 SDB Students, Teaching & Learning for focal ar
Applied Physics Lab Cost Accounting System (TIME) 161 systems inventory.xls
2006-4-2- Provost Ocean & Fishery Sciences Ocean & Fishery Sciences No 2 Finance & Budget Production C&C C&C APL
ISFutures_Inventory- UW Bothell Network UW Bothell Network
Apson 955 a.xls
2006-4-2- UW Tacoma Chancellor UW Bothell UW Bothell IAS No 2 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell IAS Hosts academic application information Operations 40 server Windows Server N/A Gliem
ISFutures_Inventory- UW Bothell Network UW Bothell Network
Ares 956 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Library No 2 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Library Provides the ERes application for library users Operations 1200 server Windows Server SQL Server Web interface
Access front
tbl-2006-3-29- Student Services new and existing student end, SQL
Aspire 165 ISFuture_Inventory-a-xls Provost Evans School of Public Affairs Evans School Computing No 2 SDB Access to Information, Reporting & Business Intelligence Production Evans School Computing Evans School Computing Student Services tracking system Kole Kantner 10 Pentium 3 Server Windows 2000 SQL Server 2000 backend
<0> What type of data? => Equipment
information update on pending assets <0>
Size/volume of data? => 200 to 400 9 fields
tbl-financial- each <0> Data used for? => Update Oasis with
management-decision- equipment information to approve assets <0>
Asset Control Sheets 491 support-inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory No 2 Finance & Budget Update freq? => Daily <0> How used/purpose? Martin Crabb Nebula G :drove MS Access
Enterprise-level application authorization
infrastructure.
Enables distributed authorization for:
Access to systems (such as SAGE, OWLS, etc.)
Actions (update, inquiry, etc.)
Access restrictions (budgets, organization http://www.washington.edu/computi
ASTRA 191 systems inventory.xls
2006-4-2- Vice President C&C C&C C&C Yes 1 Communications, Infrastructure & Middleware Production C&C C&C C&C codes, dollar limits, etc.) ng/astra/
ISFutures_Inventory- UW Bothell Network UW Bothell Network
Astraea (IS File Server) 957 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems No 5 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Information Systems File server for Technical staff Operations 20 server Windows Server N/A N/A
Athletics Ticketing System 39 systems inventory.xls Provost Intercollegiate Athletics Intercollegiate Athletics No 2 Finance & Budget Production Vendor ICA ICA
Report of SOM ICR from
Richard Meeks - Mar raison@u.washington.e
atlas.mullins.microbiol.washington.edu 661 2006.xl
2006-4-2- Provost SOM SOM - Microbiology No 6 SOM Production Role: SO du
ISFutures_Inventory- UW Bothell Information UW Bothell Network
Atly (Backup Exec) 958 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems No 5 Communications, Infrastructure & Middleware Production N/A Systems UW Bothell Information Systems Backup server for UW Bothell network servers. Operations 5 server Windows Server SQL Server Backup Exec
Record OPUS, ESS transactions and PERM
AuditDB OIM OIM Inventory 1 C&C/OIM C&C/OIM info mainframe (keynes.u.washington.edu) COBOL
AutoCad 1213 FAMS Inventory.xls Executive Vice President Capital Projects Office Capital Projects No 4 Facilities, Transportation & Space vendor CAD
Development space for www.washington.edu
web developers.
See:
http://www.washington.edu/webinfo/hosts.html :
===
You may develop for the www.washington.edu
environment from the following clusters:
bank.u
Administrative web application developers. http://www.washington.edu/webguid
bank 1227 tmildon Vice President C&C C&C Nebula No 5 Communications, Infrastructure & Middleware Production s es/guidelines/start.html
<0> What type of data? => Financial
transactions <0> Size/volume of data? => 5 mb
<0> Data used for? =>
http://www.washington.edu/admin/finmgmt/sfs/
tbl-financial- cash/eft.html#unclaimed <0> Update freq? => Evelyn A Jagoring (Bank
Bank Reconciliation - Database for tracking management-decision- Weekly <0> How used/purpose? => Reconciliation), GCA http://www.washington.edu/admin/fi
Unclaimed Incoming Wires and ACH 506 support-inventor Executive Vice President Financial Management GCA No 2 Finance & Budget http://gcaserver.finance.washin Systems Development nmgmt/sfs/cash/eft.html#unclaimed GCA Server SQL Server/Access/HTML
<0> What type of data? => FAS TC 30 and TC35
on GL 1150, 1165, 1175 & 1197. BofA and US
Bank data <0> Size/volume of data? => <0>
tbl-financial- Data used for? => matching bank transactions
management-decision- to FAS transactions (cash receipts, Evelyn Jagoring, Joseph
Bank reconciliation (Fin Acctg) 502 support-inventor Executive Vice President Financial Management Financial Accounting No 2 Finance & Budget checks,deposits, wire transfers, efts, etc. Frost access ERGO, MS Access, MS Excel
Report of SOM ICR from
Richard Meeks - Mar liseq@u.washington.ed
Becker Lab 670 2006.xl Provost SOM SOM - Neurology No 6 SOM Production Role: SO u
Report of SOM ICR from
Richard Meeks - Mar ppearson@u.washingt
Biochemistry Advanced 100% N/A 563 2006.xl Provost SOM SOM - Biochemistry No 6 SOM Production Role: SO on.edu
BioSafety Cabinets 1205 FAMS Inventory.xls
2006-4-2- Provost Health Sciences Environmental Health and Safety No 3 Facilities/Transportation and Space in-house Locations/Certificatons
ISFutures_Inventory- UW Bothell Network
Blackboard (Tonga, Chalk) 977 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems Yes 1 Students, Teaching & Learning Development N/A Operations UW Bothell Information Systems Provides web interface for Blackboard LMS
Blackboard is the main CMS used at UW UW Bothell Web Services 1200 server Red Hat Linux Oracle Blackboard
tbl-2006-3-29- Tacoma to support online teaching and
Blackboard Course Management System (CMS) 893 ISFuture_Inventory-a-xls UW Tacoma Chancellor UW Tacoma UW Tacoma - Information Technology Yes 1 Students, Teaching & Learning Production Keiji Oka Darcy Janzen learning. Patrick Pow 2000 Blackboard
Report of SOM ICR from
Richard Meeks - Mar bwarren@u.washington
Bloedel Advanced 683 2006.xl Provost SOM SOM - Otolaryngology No 6 SOM Production Role: SO .edu
Used to track student data (name/number/focal
area/status/ supervisory committee) and the
details of their projected course plans
(quarter/year/course/names/numbers/credits/c
BNHS Course Planning 158 systems inventory.xls
2006-4-2- Provost Nursing School Nursing School No 2 SDB Students, Teaching & Learning ompletion) for the purpose of course planning.
ISFutures_Inventory- UW Bothell Network UW Bothell Network
Boeing 960 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems No 2 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Information Systems Licensing server for 3rd party application. Operations 30 workstation Windows Server N/A Licensing
Provide domain, DNS, email, network, and
other services on uwb.edu. Example:
user@uwb.edu email addresses (Bothell
Campus users have both uwb.edu and
washington.edu email addresses).
Bothell Information he authoritative name servers for 'uwb.edu' are: http://www.uwb.edu/infosys/netops/ntre
Bothell domain services 1216 tmildon UW Tacoma Chancellor UW Bothell UW Bothell No 5 Communications, Infrastructure & Middleware Production Bothell Information Systems Systems Bothell Information Systems DNS1.uwb.edu Michael Stocke mstocke@uwb.edu http://www.uwb.edu/infosys/ quest.html homegrown
Used to implement salary increases. Salary
revision system uses information from budget
system and HEPPS to match budget and
position/salary information. Enter salary
OIM Inventory, systems increase information and then updates budget Linda Barrett, Director,
Budget - Salary Revision System 65 OIM inventory.xls
2006-4-2- Provost Planning & Budgeting Planning & Budgeting Yes 1 HR & Payroll Production C&C C&C P&B system with salary increases for central Budget Operations
ISFutures_Inventory- Shadow copy of every Budget & Expediture
Budget & Expenditure Tracking System 934 a.xls Provost Arts and Sciences Dean - A&S No 2 FIN/FinDesktop Finance & Budget Production Dean - A&S Dean - A&S Dean - A&S transaction for the College Robert Blum 1 server Windows Oracle MS Access
tbl-2006-3-29- Worksheets for unit budget & finance
Budget / Financial Worksheets 851 ISFuture_Inventory-a-xls Provost Architecture and Urban Planning Architecture and Urban Planning No 2 FIN/FinDesktop Finance & Budget maintenance and reporting. 40 MS Excel
<0> What type of data? => <0> Size/volume of
data? => 50 mb <0> Data used for? =>
Tracking the status of Fiscal reports and budget
tbl-financial- closing <0> Update freq? => Daily <0> How
management-decision- used/purpose? => Serve Fiscal Report/Closing GCA Systems
Budget followup for Fiscal Reports and closings 509 support-inventor Executive Vice President Financial Management GCA No 2 Finance & Budget Followup application (MS Access) Development Compaq Proliant ML350 server SQL Server
<0> What type of data? => Budget and Financial
information <0> Size/volume of data? => 5 mb
<0> Data used for? => Used to print Checklist,
tbl-financial- Letters, and JVs for Budget revisions such as a
management-decision- New Awards, Award Supplements, and Budget GCA Systems
Budget revision Reporting 508 support-inventor Executive Vice President Financial Management GCA Yes 1 Finance & Budget renwals. Printing the repo Development Nebula MS Access
ISFutures_Inventory- http://norfolk.cs.washington.edu/dire
Building directory/kiosk 1136 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Facilities, Space & Equipment Production CSE CS Lab CS Lab Graphical touchscreen building directory Dan Boren boren@cs 1000 ctory/ Windows postgresql
ISFutures_Inventory- Manage user requests for dealing with building http://rtfm.cs.washington.edu/cgi-
Building problem tracking 1137 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Facilities, Space & Equipment Production CSE CS Lab CSE Facilities issues Erik Lundberg lundberg@cs 800 bin/wreq/?list-active-4 Unix flat-file (wreq)
Bulk Email 207 systems inventory.xls Vice President C&C C&C C&C: Infrastructure No 5 Communications, Infrastructure & Middleware Production C&C C&C C&C
C&C Training Registration OIM OIM Inventory 1 C&C/OIM C&C/OIM C&C Training Course registration web for C&C unix unix Informix Java Web
Employee travel planning and reimbursement ASP, Java
Visual Studio 6.0
C&C Travel OIM OIM Inventory 2 C&C/OIM C&C/OIM CCBF request windows 2k3 windows 2k3 SQLServer 2000 (J++) Web
D:\Docstoc\Working\pdf\2c08cb85-d9bf-4007-a741-bfedcadde02b.xls
SOM
Who supports the system (who provides modifications, corrects problems, Who is the business owner (dept responsible for managing the day to day
System-name ID Tag source-file Organization College, School or Office Division Provides campus-wide service? TIER Shadow Sys? System-Type Status Developed-by develops new features?) Who-Operates-System operation of the system) description-function Contact-Person contact-person-email number-of-users System Documentation Location Data Dictionary Location How to request access to the system Vendor-Name Hardware Platform Operating System Database software Language Development Environment User Interface
Campus Automated Access Management
System - system to allow key card access to Paul Smith, Technology Windows Windows MS Access MS Access MS Access Fat client
CAAMS - Campus Automated Access Management buildings. In the future it will include proximity Officer / Michael
System 211 OIM OIM Inventory Executive Vice President Facilities Services Maintenance & Operations Yes 1 Facilities, Transportation & Space Production Vendor C&C/OIM C&C Facilities Services / C&C cards. Hernandez 1
Informix 4GL /
C&C unix unix Informix Informix 4GL NA
CAAMS ID Card Info OIM OIM Inventory 1 C&C/OIM C&C/OIM CAAMS ID Card download DB
CacTrack OIM OIM Inventory 1 C&C/OIM C&C/OIM CCBF C&C employee hourly time reporting windows 2k3 windows 2k3 SQLServer 2000 C#, ASP.NET Visual Studio 2003 Web
External system that is managed by Campus
Partners, the loan service for Perkins, Health
Professions, and all long term campus based
Vendor - Campus loans. SFS uploads and downloads loan
Campus Partners 291 systems inventory.xls Executive Vice President Financial Management Student Fiscal Services No 2 Finance & Budget Production Vendor - Campus Partners Partners Vendor - Campus Partners information to/from Campus Partners Peggy Fitzwater
tbl-2006-3-29- This is the card key access to our labs and
Card Key System 896 ISFuture_Inventory-a-xls UW Tacoma Chancellor UW Tacoma UW Tacoma No 2 key control Facilities, Transportation & Space Production Facilities, UW Tacoma Campus Safety, UW Tacoma secured rooms. Darren Bailey 300 Secure Perfect
Track student career coaches, student visits,
career seeking notes, and student placement
Career Services Mgmt 135 systems inventory.xls Provost Law School Law School No 2 SDB Students, Teaching & Learning status.
Transfer credit applicability. DARS-based Web
OIM Inventory, ITRSG service for use by community college students Proprietry
needs assessment to understand the applicability of their vendor
CAS 453 OIM appendices.doc Provost Student Affairs University Registrar Yes 1 Students, Teaching & Learning Production C&C/OIM C&C/OIM Undergraduate Admissions coursework toward UW degree programs Windows Windows SQL Server software Web
Admin-system integrated, Web-based tools in
support of teaching, learning and administrative
efforts all over campus. Tools include:
-E-submit: File turn-in areas
-Epost: Message boards
-Group Manager: Participant groups
Catalyst Tools 20 systems inventory.xls Provost Office of Educational Partnerships Yes
Educational Partnerships & Learning Technologies 1 Communications, Infrastructure & Middleware Production Department EPLT EPLT -Peer Review: Collaborative for http://catalyst.washington.edu/ http://catalyst.washington.edu/webtools homegrown
Report of SOM ICR from
Richard Meeks - Mar cabal@u.washington.e
Centrally Managed - Advanced Security Required 692 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO du
Report of SOM ICR from
Richard Meeks - Mar padams@u.washingto
Centrally Managed Advanced 693 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO n.edu
Report of SOM ICR from
Richard Meeks - Mar liseq@u.washington.ed
Chamberlain Lab 671 2006.xl
2006-4-2- Provost SOM SOM - Neurology No 6 SOM Production Role: SO u
ISFutures_Inventory- UW Bothell Network Website and call tracking system for Campus UW Bothell Network
Channel 981 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Campus Media Center No 2 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Campus Media Center Media Center Operations 30 server Red Hat Linux MySQL N/A
Chemical Waste 1207 FAMS Inventory.xls Provost Health Sciences Environmental Health and Safety No 2 Facilities/Transportation and Space in-house Track Chemical Waste Collections
Report of SOM ICR from
Richard Meeks - Mar dachris@u.washington.
CHI 694 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar mkortas@u.washington
Child Health Institute 695 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO .edu
Report of SOM ICR from
Richard Meeks - Mar chlam@u.washington.e
Chlamydia Laboratory 616 2006.xl Provost SOM SOM - Medicine - Allergy & Infectious Disease No 6 SOM Production Role: SO du
Report of SOM ICR from
Richard Meeks - Mar esaldan@u.washington
CHRMC- KUO 713 2006.xl Provost SOM SOM - Psychiatry No 6 SOM Production Role: SO .edu
<0> What type of data? => Lists all class codes
in use at UW <0> Size/volume of data? => 796
records, 4 fields each <0> Data used for? =>
tbl-financial- Creating print reports of list for users <0>
management-decision- Update freq? => Seldom <0> How
Class Codes 498 support-inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory No 2 Access to Information, Reporting & Business Intelligence used/purpose? => Provides info to departm Heidi Gustafson Nebula G: drive MS Access
Present UW class enrollment data augmented
with CSE data to instructors; support keycard
ISFutures_Inventory- access, support MSDNAA program. Uses http://norfolk.cs.washington.edu/htbi
class enrollment tool 1100 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Students, Teaching & Learning Production CSE CS Lab CS Lab UWSDB shadow and local data Scott Rose rose@cs 80 n-post/course-list Unix postgresql
Used to maintain data on clinical faculty, many
of whom are current and former UW SoN
students, not tracked by the UW, generating
Clinical Faculty DB 156 systems inventory.xls
2006-4-2- Provost Nursing School Nursing School No 2 Clinical information for review of appointment, etc.
ISFutures_Inventory- UW Bothell Network
Clio (Web DB Server) 975 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Web Services No 5 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Web Services Database back end for web content UW Bothell Web Services 10 server Red Hat Linux MySQL Perl, Mason
<0> What type of data? => Closing equipment
data/ neg and positive <0> Size/volume of data?
=> 692 Neg, 314 Positive 9 fields each <0>
tbl-financial- Data used for? => Creating records of closeing
management-decision- reports for federal and agency awards <0>
Closing Reports 489 support-inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory No 2 Finance & Budget Update freq? => weekly <0> How Crabb/Wall Nebula G: drive MS Access
<0> What type of data? => Tracking tool for
cluster purchases <0> Size/volume of data? =>
38 records to date, 6 fields each <0> Data used
tbl-financial- for? => Making sure clusters are not ordered
management-decision- improperly <0> Update freq? => Monthly <0>
Clusters 488 support-inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory No 2 Finance & Budget How used/purpose? => Provides Heidi Gustafson Nebula G: drive MS Access
Direst loan and Pell Grant files sent to and Unisys MCP, Unisys MCP,
COD XML import and export OIM OIM Inventory
2006-4-2- 1 C&C/OIM C&C/OIM Financial Aid received from US Dept of Ed Windows Windows DMS II, SQL Server COBOL, XML NA
ISFutures_Inventory- College of Engineering College of Engineering Track women and minority students in the
COE-DASS 947 ENG a.xls Provost Engineering College of Engineering Deans office No 2 SDB Students, Teaching & Learning Production Computing Computing College of Engineering Deans office College of Engineering. Carmen Sidbury 5 Dell PowerEdge 2600 Unix MS Access MS Access
2006-4-2- Web based reporting. BARs, BSRs, http://www.washington.edu/
ISFutures_Inventory- College of Engineering College of Engineering projections, Budget Revisions, PCA, http://data.engr.washington.edu/pls/ admin/pb/home/financial-
COE-FIN 941 ENG a.xls
2006-4-2- Provost Engineering College of Engineering Computing No 2 FIN Finance & Budget Production Computing Computing College of Engineering Computing Direct/Indirect, Outstanding Encumbrances David Fray 60 fin/ db.html Unix
Compaq Proliant ML370 Oracle Oracle Portal
ISFutures_Inventory- College of Engineering College of Engineering Web based purchasing and distribution of UW http://support.engr.washington.edu/
COE-MathDB 944 ENG a.xls
2006-4-2- Provost Engineering College of Engineering Computing No 2 PAS Other Production Computing Computing College of Engineering Computing site licensed software. David Fray 500 matlab/math_purchase_start.htm Dell file server M
Windows NT 4.0 server S Access Microsoft ASP
ISFutures_Inventory- College of Engineering College of Engineering Personnel database, to track faculty and staff in
COE-Pafbase 943 ENG a.xls
2006-4-2- Provost Engineering College of Engineering Computing No 2 HRMIS HR & Payroll Production Computing Computing College of Engineering HR office College. David Fray 5 none none none Dell PowerEdge 2600 Unix MS Access MS Access
ISFutures_Inventory- College of Engineering College of Engineering Track Scholarship/Fellowship applications and
COE-Scholarships/Fellowships 946 ENG a.xls
2006-4-2- Provost Engineering College of Engineering Deans office No 2 Finance & Budget Production Computing Computing College of Engineering Deans office awards in the College of Engineering Cynthia Bush 5 server Unix MS Access MS Access
ISFutures_Inventory- College of Engineering College of Engineering Web based reporting. Enrollments, http://data.engr.washington.edu/pls/
COE-SDB 942 ENG a.xls Provost Engineering College of Engineering Computing No 2 SDB Students, Teaching & Learning Production Computing Computing College of Engineering Computing admissions, degrees granted, CC transfers David Fray 30 portal30/url/page/SDB_Reports/ Unix
Compaq Proliant ML370 Oracle Oracle Portal
2006-4-2- Web based undergraduate admissions
ISFutures_Inventory- College of Engineering College of Engineering application to College of Engineering
COE-Undergraduate Admissions 945 ENG a.xls Provost Engineering College of Engineering Computing No 2 SDB Students, Teaching & Learning Production Computing Computing College of Engineering Deans office departments. Web based reports for advisors. Mary Cook 500 server Unix MySQL PHP
Report of SOM ICR from
Richard Meeks - Mar mpepin@u.washington.
Collagen Diagnostic Lab 687 2006.xl Provost SOM SOM - Pathology No 6 SOM Production Role: SO edu
ISFutures_Inventory- Track and offer information on colloquia and http://www.cs.washington.edu/htbin-
Colloquia system 1107 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Students, Teaching & Learning Production CSE CS Lab CSE Business Office other talks, including abstracts Scott Rose rose@cs hundreds post/mvis/mvis/Colloquia Unix postgresql
from-joe-kittleson-
Combined Fund Drive 921 20060330.xls Executive Vice President Human Resources Benefits Yes 1 HR & Payroll
Commencement dbs 554 Provost Student Affairs University Registrar No 4 Students, Teaching & Learning
Compliance Assistant (Compliance Reporting Web based system used to track athletes
System) 40 systems inventory.xls Provost Intercollegiate Athletics Intercollegiate Athletics No 2 Students, Teaching & Learning Production NCAA NCAA compliance requirements and eligibility.
Report of SOM ICR from
Richard Meeks - Mar colbyh2@u.washington.
compmed.washington.edu 566 2006.xl Provost SOM SOM - Comparative Medicine No 6 SOM Production Role: SO edu
Internal dbs that impacts other department.
SFS receives a Bank of America report with
departments credit card and direct deposit
merchant numbers and deposit amounts. The
report is used to create a CT to submit to FAS
Computing Data Management Database 292 systems inventory.xls Executive Vice President Financial Management Student Fiscal Services No 2 FIN Finance & Budget Production Department SFS SFS and distribute the money to the ap Peggy Fitzwater
Report of SOM ICR from
Richard Meeks - Mar pchance@u.washingto
Core Genetics 696 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO n.edu
Cost Recovery Information System (CRIS) 282 systems inventory.xls Executive Vice President Financial Management MAA Yes 1 Finance & Budget Production Vendor MAA MAA Same vendor as Facility Service's FME
ISFutures_Inventory- http://norfolk.cs.washington.edu/htbi
course computing 1104 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Students, Teaching & Learning Production CSE CS Lab CS Lab Manage course computing resource requests Scott Rose rose@cs 45 n-post/education/cr/cr.cgi Unix postgresql
Used to track course data, both SoN-specific
(focal areas of registered students, dept, topic)
and generic (quarter, year, term, fee, budget #,
budget name, meeting dates, bldg, room #,
room characteristics, prefix, faculty, course
Course DB 157 systems inventory.xls Provost Nursing School Nursing School No 2 SDB Students, Teaching & Learning coordinator, TA, secti
http://norfolk.cs.washington.edu/htbi
n-
ISFutures_Inventory- Support class scheduling by soliciting post/education/projection/projection
course projection 1101 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Students, Teaching & Learning Production CSE CS Lab CSE Advising Office enrollment plans from undergrads.
Tracks student course requests, assigns Scott Rose rose@cs 5 .cgi Unix postgresql
course add codes, manages wait lists (most
law courses for 2nd and 3rd years require an
add code). Students submit requests and
check for add codes and wait list status on
Course Requests 138 systems inventory.xls Provost Law School Law School No 2 SDB Students, Teaching & Learning Web.
Report of SOM ICR from
Richard Meeks - Mar xueqiao@u.washington
CPC 618 2006.xl Provost SOM SOM - Medicine - Cardiology No 6 SOM Production Role: SO .edu
ITAC proposal submitted for future
CPO Project Tracking System (UW Project Tracker) 186 systems inventory.xls Executive Vice President Capital Projects Office Capital Projects Yes 1 Facilities, Transportation & Space Production Department CPO CPO enhancements proprietary
Output Management (Formatting/Archiving of vendor
Create!Form / Create!Archive OIM OIM Inventory 1 C&C/OIM C&C/OIM Financial Management (Grant & Contract Accounting - GCA) invoices, etc.) Windows 2000 Windows 2000 SQL Server software proprietary Web
UW departments who do not process their own
credit card pymts send SFS the transaction
information (payor name, cc number, and dollar
amount) for processing. SFS runs the credit
card and enters the information in an access
Credit Card Database 293 systems inventory.xls Executive Vice President Financial Management Student Fiscal Services No 2 FIN Finance & Budget Production Department SFS SFS database. A CT file is created Peggy Fitzwater
<0> What type of data? => <0> Size/volume of
data? => Between 378 and 500+ MB depending
tbl-financial- on the model <0> Data used for? => F&A
management-decision- proposal <0> Update freq? => Each proposal
CRIS 515 support-inventor Executive Vice President Financial Management MAA No 4 Finance & Budget <0> How used/purpose? => Laurent Anstett Nebula FoxPro
Report of SOM ICR from
Richard Meeks - Mar ryeh@u.washington.ed
CROHN.medicine.washington.edu 624 2006.xl Provost SOM SOM - Medicine - Gastroenterology No 6 SOM Production Role: SO u
Report of SOM ICR from
Richard Meeks - Mar klwinter@u.washington.
CRRC Advanced Security 647 2006.xl Provost SOM SOM - Medicine - Metabolism & Endocrinology No 6 SOM Production Role: SO edu
Paul Smith, Technology
Crystal Enterprise 212 systems inventory.xls Executive Vice President Facilities Services Facilities Services No 5 Communications, Infrastructure & Middleware Production Vendor FS FS Makes FME reports available via web interface. Officer
Permit applicants to PhD or PMP program to
submit department supplemental application
as part of the online application to the Graduate
CSE Graduate Application 126 ENG systems inventory.xls Provost Engineering Engineering No 2 SDB Students, Teaching & Learning School
Used by CSE undergraduates to apply for
CSE Scholarship Application 128 ENG systems inventory.xls Provost Engineering Engineering No 3 Students, Teaching & Learning departmental scholarships.
Tracking and management of student progress
for academic advisors. There are thee
components; undergrad, grad, and PMP
CSE Student Tracking Database 127 ENG systems inventory.xls Provost Engineering Engineering No 2 SDB Students, Teaching & Learning students
Report of SOM ICR from
Richard Meeks - Mar mcunning@u.washingt
CunninghamLab 697 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO on.edu
tbl-2006-3-29-
Curriculum Planning Database 884 ISFuture_Inventory-a-xls Provost Arts and Sciences Sociology No 3 Students, Teaching & Learning Production Sociology Sociology Sociology Used for planning courses to be offered Kevin Mihata 2 Windows PC Windows XP Pro SP2 MS Access MS Access
Office of the University Office of the University Track approval process of program and course
Curriculum tracking dbs 555 tmildon Provost Student Affairs University Registrar No 2 SDB Students, Teaching & Learning Registrar Registrar Office of the University Registrar curricula
Report of SOM ICR from
Richard Meeks - Mar bolson@u.washington.
CVRTC Servers 621 2006.xl Provost SOM SOM - Medicine - Clinical Research Center No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar
Dale Lab 627 2006.xl Provost SOM SOM - Medicine - General Internal Medicine No 6 SOM Production Role: SO j2@u.washington.edu
The authoritative name servers for
'dante.u.washington.edu' are:
dnsload1.cac.washington.edu 140.142.1.21
dnsload2.cac.washington.edu 140.142.2.21
dante.u.washington.edu:
SOA (Start of Authority):
origin = dnsload1.cac.washington.edu
Dante; Student Email and Web Publishing 1224 tmildon Vice President C&C C&C C&C: Infrastructure No 5 Communications, Infrastructure & Middleware
Job Class, UBU, etc table maintenance for
DAPP OIM OIM Inventory Executive Vice President Human Resources Human Resources Yes 1 HR & Payroll Production C&C/OIM C&C/OIM HR HR/Payroll. 4 NT NT SQL Server ASP.NET C# Visual Studio .NET Web
<0> What type of data? => Daily count of Daily
Activity Report volume <0> Size/volume of data?
=> 1955 records to date, 6 fields each <0> Data
tbl-financial- used for? => Volume tracking tool <0> Update
management-decision- freq? => Daily <0> How used/purpose? =>
DARs 496 support-inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory No 2 Finance & Budget Tracking volumes Heidi Gustafson 200 Nebula G: drive MS Access
Degree Audit table maintenance - Windows fat
client. SDB-dependent system in support of
OIM Inventory, ITRSG Degree Audit and Transfer Articulation. DARS Proprietry
needs assessment infrastructure is used on Bothell, Tacoma and vendor
DARS/DARWIN 454 OIM appendices.doc Provost Student Affairs University Registrar Yes 1 Students, Teaching & Learning Production Vendor C&C/OIM C&C/OIM Registrar Seattle Campuses. 200 Windows Windows SQL Server software Fat client
data cleansing db - SDB address imports 558 Vice President C&C C&C C&C: Infrastructure No 5 Communications, Infrastructure & Middleware
data cleansing db - sdb other 559 Vice President C&C C&C C&C: Infrastructure No 5 Communications, Infrastructure & Middleware
<0> What type of data? => TUITION PAYMENTS,
CHECKS TO STUDENTS, ADJUSTMENTS TO
STUDENT ACCOUNTS <0> Size/volume of
data? => < 50,000 RECORDS <0> Data used
tbl-financial- for? => RECONCILING STUDENT ACCOUNTS
management-decision- AND BANK ACCOUNT, DASHBOARD
Data Control 525 support-inventor Executive Vice President Financial Management Student Fiscal Services Yes 1 SDB Access to Information, Reporting & Business Intelligence METRICS, CONTROL <0> Update freq? = Peggy Fitzwater NEBULA MS Access
Data Exchange 1215 FAMS Inventory.xls Executive Vice President Capital Projects Office Capital Projects No 4 Communications, Infrastructure & Middleware Interdepartmental Data exchange
Track recurring and ad hoc institutional
Office of the University Office of the University research requests sent from clients on and off
Registrar, Academic Data Registrar, Academic Data campus to the Office of the Registrar, Academic
Data Management Job Tracking db 548 tmildon Provost Student Affairs University Registrar Yes 1 Communications, Infrastructure & Middleware Production Management Management Office of the University Registrar, Academic Data Management Data Management. 25 N/A N/A N/A NT Server Windows Server MS Access
new decision support groups forming for http://ucs.admin.washington.edu/dw
Data Warehouse Infrastructure 208 systems inventory.xls Vice President C&C C&C C&C: Infrastructure Yes 1 Access to Information, Reporting & Business Intelligence Production C&C DWP C&C DWP Data Owners for HR, Finance and Student Student, Financial and HR to manage data p/
<0> What type of data? => Budget Number
information <0> Size/volume of data? => 5 mb
<0> Data used for? => For Assigning the next
tbl-financial- available Budgets Number. <0> Update freq?
management-decision- => Daily <0> How used/purpose? => . Data GCA Systems
Database for tracking GCA Budget Number re-use 507 support-inventor Executive Vice President Financial Management GCA No 2 Finance & Budget source: Data is unique to database. It i Development Nebula MS Access
Stand alone student tracking database for use
University Registrar, in the Emergency Operations Center (EOC)
DCON (disaster student contact/locator database) 469 tmildon Provost Student Affairs University Registrar Yes 1 Students, Teaching & Learning Production Academic Data Management University Registrar University Registrar during a level three emergency. 30 homegrown WinXP MS
PC (dedicated emergency center Dell notebooks) Access MS Access
Automation infrastructure for population,
Office of the University Office of the University publication, and securing of DCON emergency
dcon automation 557 tmildon Provost Student Affairs University Registrar No 5 Students, Teaching & Learning Production Registrar Registrar Office of the University Registrar db (see DCON). 15 N/A N/A N/A server Windows Server vba
Office of the University Office of the University
Dean's Letters db 547 tmildon
2006-4-2- Provost Student Affairs University Registrar No 2 Students, Teaching & Learning Production Registrar Registrar Office of the University Registrar Produce annual and quarterly Dean's Letters 5
ISFutures_Inventory- Shadow bookkeeping for Deans Office Reserve
Deans Reserve Account Tracking System 932 a.xls Provost Arts and Sciences Dean - A&S No 2 FIN Finance & Budget Production Dean - A&S Dean - A&S Dean - A&S Budgets Robert Blum 6 server Windows MS Access MS Access
Patient Accounting & Billing System. System is
also used by University of Missouri - Kansas
Dental Clinical Management System (CMS) 116 systems inventory.xls Provost Dentistry Dentistry No 2 Clinical Production Robert (Bob) Grove SoD SoD City Dr. Glass or Jean Garber
<0> What type of data? => CRDIT CARD
TRANSACTIONS WHERE SFS PROCESSES
TRANSACTIONS ON BEHALF OF
DEPARTMENTS <0> Size/volume of data? =>
SMALL <0> Data used for? => RECORD
tbl-financial- TRANSACTIONS, BILL DEPARTMENTS FOR
management-decision- SERVICE, CREATE CTS <0> Update freq? =>
DEPARTMENT CREDIT CARDS 523 support-inventor Executive Vice President Financial Management Student Fiscal Services No 2 Finance & Budget 3-5 TIME Peggy Fitzwater NEBULA MS Access
<0> What type of data? => DEPARTMENTS
DIRECT DEPOSIT CASH AND CHECKS <0>
Size/volume of data? => SMALL <0> Data used
for? => CREATES CTS NFOR DIRECT
tbl-financial- DEPOSITS AND REPORTS TO DEPARTMENTS
management-decision- <0> Update freq? => DAILY <0> How
DEPARTMENT DIRECT DEPOSIT- AUTO CT 529 support-inventor Executive Vice President Financial Management Student Fiscal Services No 2 Finance & Budget used/purpose? => Peggy Fitzwater NEBULA MS Access
Report of SOM ICR from
Richard Meeks - Mar alance@u.washington.
Department Surgery System 723 2006.xl Provost SOM SOM - Surgery No 6 SOM Production Role: SO edu
D:\Docstoc\Working\pdf\2c08cb85-d9bf-4007-a741-bfedcadde02b.xls
SOM
Who supports the system (who provides modifications, corrects problems, Who is the business owner (dept responsible for managing the day to day
System-name ID Tag source-file Organization College, School or Office Division Provides campus-wide service? TIER Shadow Sys? System-Type Status Developed-by develops new features?) Who-Operates-System operation of the system) description-function Contact-Person contact-person-email number-of-users System Documentation Location Data Dictionary Location How to request access to the system Vendor-Name Hardware Platform Operating System Database software Language Development Environment User Interface
Web-based service for departmental staff to
extract course and student info. Data is
extracted from UWSDB. Examples - Class lists
OIM Inventory, ITRSG for department’s courses. Time Schedule
needs assessment information for courses. Students enrolled in a
Departmental Information Web Service (Deptinfo) 429 OIM appendices.doc Provost Student Affairs University Registrar Yes 1 Access to Information, Reporting & Business Intelligence Production C&C C&C/OIM C&C/OIM University Registrar department’s degree programs. homegrown Windows Windows DMS II Jscript, ASP Vis Studio Web
Report of SOM ICR from
Richard Meeks - Mar rhjorten@u.washington.
Dermatology Research Center 622 2006.xl Provost SOM SOM - Medicine - Dermatology No 6 SOM Production Role: SO edu
Development Alumni 141 systems inventory.xls Provost Law School Law School No 2 Access to Information, Reporting & Business Intelligence Tracks alumni for Development.
Report of SOM ICR from
Richard Meeks - Mar lovcor@u.washington.e
Diabetes Endocrinology Research Center High 648 2006.xl Provost SOM SOM - Medicine - Metabolism & Endocrinology No 6 SOM Production Role: SO du
Anne Eskridge, Property Informix 4GL /
OIM Inventory, systems Transportation Services and Transport Services unix unix Informix Informix 4GL Fat Client
DB
Dial-A-Ride Administration 222 OIM inventory.xls Executive Vice President Facilities Services Transportation Services Yes 1 Facilities, Transportation & Space Production C&C C&C/OIM C&C/OIM Dial-A-Ride management Manager
Report of SOM ICR from
Richard Meeks - Mar hdichek@u.washington
Dichek lab 698 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO .edu
This image database is developed in
tbl-2006-3-29- FileMakerPro to support environmental science
Digital Images Data 901 ISFuture_Inventory-a-xls UW Tacoma Chancellor UW Tacoma UW Tacoma No 3 Students, Teaching & Learning Development CTLT, UW Tacoma CTLT, UW Tacoma teaching. David Secord 10
<0> What type of data? => FOR UNITS NOT
USING AUTOMATIC CTS, CASH AND CHECK
DEPOSITS <0> Size/volume of data? =>
MEDIUM <0> Data used for? => INPUTTING
tbl-financial- CTS INTO FIN, DASHBOARD METRICS <0>
management-decision- Update freq? => 3-5 TIMES/WEEK <0> How
Direct Deposit 530 support-inventor Executive Vice President Financial Management Student Fiscal Services Yes 1 FIN Finance & Budget used/purpose? => Peggy Fitzwater NEBULA MS Excel
Report of SOM ICR from
Richard Meeks - Mar juliek@u.washington.e
Division Office Systems Advanced 649 2006.xl Provost SOM SOM - Medicine - Metabolism & Endocrinology No 6 SOM Production Role: SO du
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
DOM-1032 Administrative Data 568 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
DOM-Backup 569 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
DOM-CME 570 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
DOM-Core Services 571 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
DOM-Desktop 572 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
DOM-File Services 573 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
DOM-GMETbs 574 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
DOM-Laptop 575 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
DOM-Mail 576 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
DOM-OMSA 577 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar dlange@u.washington.
DOM-Printing 578 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO edu
ISFutures_Inventory-
Donations DB 1152 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 3 Access to Information, Reporting & Business Intelligence Production CSE CSE Business Office CSE Business Office Track equipment donations Chris Cunnington chris@cs 3 Windows MS Excel
Departmental Payroll/Personnel mainframe
DPP OIM OIM Inventory 1 C&C/OIM C&C/OIM Payroll driver A-SERIES A-SERIES DMSII COBOL/DFDS SURE/Pgm's Workbench NA
Report of SOM ICR from
Richard Meeks - Mar liseq@u.washington.ed
Dr Zabetian VAMC Neurology 666 2006.xl Provost SOM SOM - Neurology No 6 SOM Production Role: SO u
Dept of Retirement Systems - edit/update of
data, interfaces with Olympia DRS. The
Department of Retirement Systems has
systems that generate actvities and impact in
UW information and systems and that are used
OIM Inventory, from-joe- daily by Benefits personnel for retirement plan
kittleson-20060330.xls, administration. This is part of the UW's
DRS Systems 920 258 OIM systems inventory.xls Executive Vice President Human Resources Benefits Yes 1 HR & Payroll C&C/OIM C&C/OIM Benefits "system" for state retirement management. NT NT SQL Server ASP/J++ Com Visual Studio 6.0 Web
tbl-2006-3-29- Computer Services, UW Computer Services, UW This is a web based database, based on SIS of
Dual Enrollment Database 898 ISFuture_Inventory-a-xls UW Tacoma Chancellor UW Tacoma UW Tacoma - Information Technology Yes 1 Students, Teaching & Learning Development Tacoma Tacoma Admission Office and Registrar Office, UW Tacoma UW Tacoma Eric Elkins 20
tbl-2006-3-29- Acts as a shadow database for tracking
Economics Budget Database 867 ISFuture_Inventory-a-xls Provost Arts and Sciences Economics No 2 FIN/FinDesktop Finance & Budget Production Economics Economics Economics department budgets. Michael Goldblatt 3 Windows PC Windows XP Pro SP2 MS Access MS Access
tbl-2006-3-29-
Economics Inventory Database 878 ISFuture_Inventory-a-xls Provost Arts and Sciences Economics No 2 OASIS Access to Information, Reporting & Business Intelligence Production Economics Economics Economics Track equipment inventory for the department. Michael Goldblatt 4 Windows PC Windows XP Pro SP2 MS Access MS Access
OIM Inventory, systems
Educational Outreach System (EOS) 17 OIM inventory.xls Provost Educational Outreach Educational Outreach Yes 1 Students, Teaching & Learning Production C&C C&C/OIM C&C Vice Provost for Continuing Education Student information system for UWEO 160 Windows Windows SQL Server Jscript, ASP Vis Studio Web
<0> What type of data? => LOAN PAYMENTS
MADE TO 3RD PARTY BILLING SERVICE <0>
Size/volume of data? => SMALL <0> Data used
tbl-financial- for? => CREATE CTS (AUTOMATIC) <0>
management-decision- Update freq? => DAILY <0> How
EFG (CAMPUS PARTNERS) 537 support-inventor Executive Vice President Financial Management Student Fiscal Services No 3 Finance & Budget used/purpose? => Peggy Fitzwater NEBULA MS Access
<0> What type of data? => <0> Size/volume of
data? => Between 378 and 500+ MB depending
tbl-financial- on the model <0> Data used for? => Recharge
management-decision- Center <0> Update freq? => Every quarter <0>
EIO 511 support-inventor Executive Vice President Financial Management MAA No 3 Finance & Budget How used/purpose? => Laurent Anstett Nebula FoxPro
Web based system allows advisors access to
detailed student information. Allows advisers
OIM Inventory, systems to view and add notes to individual student
Electronic Advising Records System (EARS) 104 OIM inventory.xls Provost Undergraduate Education Undergraduate Education Yes 1 SDB Students, Teaching & Learning Production C&C C&C/OIM C&C Undergrad Education, University Registrar advising records David Sayrs homegrown Windows Windows DMS II, SQL Server C#, ASP.NET Vis Studio .NET Web
Allows depts to set up UWNetID prior to entry in
OIM Inventory, Opus. Used to grant email access to a new
ISFutures_Inventory- employees to get UW NetIDs, creates a
Email Access 1199 OIM template_0421.xls Executive Vice President Financial Management Payroll Yes 1 HR & Payroll Production C&C/OIM C&C/OIM Payroll skeletal record in HEPPS Ginny Montgomery 100s NT NT SQL Server ASP/DFDS Visual Studio 6.0 Web
Report of SOM ICR from
Richard Meeks - Mar kevinuw@u.washington
eMedicine UWMC 679 2006.xl Provost SOM SOM - Orthopaedics and Sports Medicine No 6 SOM Production Role: SO .edu
Looks up an employee based on Employee ID,
Employee Search OIM OIM Inventory 1 C&C/OIM C&C/OIM SSN, or Name. Returns quick results. NT NT SQL Server ASP/SQL Visual Studio 6.0 Web
OIM Inventory, systems confidential site for employees to view personal ASP.NET/DFD
Employee Self-Service 259 OIM inventory.xls Executive Vice President Human Resources Human Resources Yes 1 HR & Payroll Production C&C C&C/OIM C&C/OIM Benefits/Payroll financial and benefits information. NT NT SQL Server, DMSII S Visual Studio .NET Web
<0> What type of data? => Detail of
endowments; individual endowments, history of
purchases(costs), units, costs, market value,
tbl-financial- and income distributions. Over 20 years of
management-decision- history. <0> Size/volume of data? => 93
Endowment database 543 support-inventor Executive Vice President Financial Management Treasury No 2 Finance & Budget megabytes <0> Data used for? => reports to Ping Tan nebula MS Access
Historical and common integrated information
from multiple central systems for strategic SQL Server SQL Queries,
analytical reporting purposes (Includes Eolian 2000, DTS, Programmed
Enterprise Data Warehouse OIM OIM Inventory 1 C&C/OIM C&C/OIM Multiple, HR, Financial Mgmt, Student Affairs, etc. & Kirk servers) windows windows SQL Server SSIS Visual Studio 6.0 Data Feeds
Cognos
Enterprise Data Warehouse - Cognos Upfront Web Business Intelligence platform for building and Impromptu, Web, SQL
Portal OIM OIM Inventory 1 C&C/OIM C&C/OIM Multiple, HR, Financial Mgmt, Student Affairs, etc. publishing enterprise reports and OLAP cubes windows windows SQL Server Powerplay 7.1 Cognos 7.1 Queries
Enterprise Data Warehouse - Exploration Data
Warehouse (XDW) 468 tmildon Provost Student Affairs University Registrar Yes 1 Access to Information, Reporting & Business Intelligence Production C&C DWP C&C DWP Data Owners for HR, Finance and Student
SQL Server SQL Queries,
Integrated information from multiple central 2005, DTS, Programmed
Enterprise Data Warehouse - Operational Data Store OIM OIM Inventory 1 C&C/OIM C&C/OIM Multiple, HR, Financial Mgmt, Student Affairs, etc. systems for operational reporting purposes windows windows SQL Server SSIS Visual Studio 6.0 Data Feeds
proprietary vdr
software +
Windows 2003; Windows 2003; Java, XML
(Some servers still (Some servers still (AML),
W2K, e.g. ARwww1 W2K, e.g. ARwww1 Javascript,
OIM Inventory, systems eProcurement approval routing (Ariba Buyer (8.2.2) + ARwww2 (8.2.2) + ARwww2 WebLogic 7.0,
eProcurement 179 OIM inventory.xls Executive Vice President Business Services Business Services: Purchasing & Stores Yes 1 Finance & Budget Production Vendor C&C/OIM C&C/OIM Business Services (Purchasing & Stores) 8.2.2) (8.1) (8.1) SQL Server IIS proprietary/ VSS Web
Informix 4GL /
Equipment Insurance / Risk Management Version Financial Management Office of Risk Management unix, windows unix, windows Informix Informix 4GL Fat client
OIM OIM Inventory 1 C&C/OIM C&C/OIM Office of Risk Management, Online, campus- DB
OIM Inventory, systems wide system to allow entry, review, reporting,
inventory.xls,tbl-financial- and renewal of property insurance for ASP, VBScript,
Financial Management windows windows Informix Visual Studio 6.0 Web
management-decision- equipment either owned or leased by the JavaScript
Equipment Insurance System 286 OIM support-inventor Executive Vice President Financial Management Risk Management Yes 1 Finance & Budget Production C&C C&C/OIM C&C department. Terry Taft Harter
tbl-2006-3-29- Web-based inventory system for locally-tracked
Equipment Inventory 855 ISFuture_Inventory-a-xls Provost Architecture and Urban Planning Architecture and Urban Planning No 2 OASIS Access to Information, Reporting & Business Intelligence inventorial and non-inventorial equipment. 20 MySQL PHP
ISFutures_Inventory- http://reserve.cs.washington.edu/eq
Equipment Lending system 1141 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Facilities, Space & Equipment Production CSE CS Lab CS Lab Reserve laptops, cameras, other equipment. Scott Rose rose@cs hundreds uip/ Unix postgresql
C&C Business & Finance and Customer Care Monthly, telecom Equipment billing;
Equipment(Telecom) billing OIM OIM Inventory 1 C&C/OIM C&C/OIM telephones, modems, ethernet unix unix Informix Informix 4GL vi-Informix 4GL / CVS
3 separate but integrated web front ends
sharing a common back end database. Used
ERA (Electronic Research Administration) aka, Sage, to manage research proposals and clinical ASP.NET, C#,
Office of Research and the Office of Sponsored Programs windows windows SQL Visual Studio .NET Web
Spaerc & eApprovals JavaScript
trials, review and approval on campus and
OIM OIM Inventory 1 C&C/OIM C&C/OIM central office administration of proposals and
tbl-2006-3-29- Computer Services, UW awards. online teacing material reservation
This is the
E-Reserve 899 ISFuture_Inventory-a-xls UW Tacoma Chancellor UW Tacoma UW Tacoma - Libraries Yes 1 Students, Teaching & Learning Production Tacoma Library, UW Tacoma system, along with the one in UW Seattle. Charles Lord 2200 Docutek
Events Management System 48 systems inventory.xls
2006-4-2- Provost Office of External Affairs Media Relations and Communications No 4 Facilities, Transportation & Space
ISFutures_Inventory- UW Bothell Network UW Bothell Network
Exchange cluster (Atropos/Clotho) 959 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems No 4 Communications, Infrastructure & Middleware Development N/A Operations UW Bothell Information Systems Future home of Exchange 2003 for the campus Operations 5 server Windows Server SQL Server Exchange
ISFutures_Inventory- http://norfolk.cs.washington.edu/htbi
exit survey 1133 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 HR & Payroll Production CSE CS Lab CSE Advising Undergraduate exit survey Scott Rose rose@cs 125 n-post/education/exit/exit.cgi Unix postgresql
Eye/Face Wash 1204 FAMS Inventory.xls Provost Health Sciences Environmental Health and Safety No 3 Facilities/Transportation and Space in-house Locations
http://norfolk.cs.washington.edu/htbi
n-
ISFutures_Inventory- Management and tracking of people, rooms, php/cseoffice/mgmt_facilities/peopl
facilities management 1135 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Facilities, Space & Equipment Production CSE CS Lab CSE Facilities phones and keys by facilities coordinators. Dan Boren boren@cs 3 e.php Unix postgresql
Vendor package maintains information about
funded and chargeable work done on campus
by Facilities Services. Packaged software. Inter- proprietary
Facilities Services departmental system designed for asset and Windows XP Windows XP SQL Server vendor proprietary Fat client
facilities management system. (UW properties, software
facilities, buildings. Also tracks work orders
OIM Inventory, systems performed on assets, time, cost, material, etc.
Facilities Management Enterprise (FME) 213 OIM inventory.xls Executive Vice President Facilities Services Facilities Services Yes 1 Finance & Budget Production Vendor - Maximums C&C/OIM C&C/OIM Interfaces with FAS to bill clients. Tracks
Application still under development. Proprietary
software. Will be a new version of FME that is
OIM Inventory, systems entirely web based. It will replace FME and Paul Smith, Technology
FacilityMax 214 OIM inventory.xls Executive Vice President Facilities Services Facilities Services Yes 1 Finance & Budget Development Vendor - Maximus C&C FS FSWORKS. Officer
Faculty bio information. This system is currently
used to track the following information:
Facutly Tenure
Faculty % Tenure
Faculty Terminal Degree (supports last 3
degrees)
Interest Area
Academic Home Department Budget Number
OIM Inventory, systems (designed to match the appointing department
Faculty Biographic 6 OIM inventory.xls Provost Academic HR Academic HR Yes 1 HR & Payroll Production AHR & C&C C&C/OIM C&C/OIM Academic HR budget nu Rhonda Forman 500 NT NT SQL Server ASP/DFDS Visual Studio 6.0 Web
Used to create reports for surveys and track
APT decisions, including tracking the number of
graduate student thesis & dissertation
Faculty DB 1 154 systems inventory.xls Provost Nursing School Nursing School No 2 Students, Teaching & Learning committees chaired.
Used to by students seeking info on SoN
faculty: member of UW Graduate Faculty,
department, faculty contact information, FAAN
status, current research, photograph, COS CV,
Faculty DB 2 155 systems inventory.xls Provost Nursing School Nursing School No 2 Students, Teaching & Learning CV highlights, etc.
ISFutures_Inventory-
Faculty Evaluation 1121 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 HR & Payroll Development CSE CS Lab CSE Business Office Manage annual faculty evaluations Scott Rose rose@cs 50 Unix postgresql
tbl-2006-3-29-
Faculty Grade Worksheets 852 ISFuture_Inventory-a-xls
2006-4-2- Provost Architecture and Urban Planning Architecture and Urban Planning No 2 SDB Students, Teaching & Learning Grade worksheets for faculty use. 100 MS Excel
ISFutures_Inventory-
Faculty Personnel 933 a.xls Provost Arts and Sciences Dean - A&S No 2 Acad HR HR & Payroll Production Dean - A&S Dean - A&S Dean - A&S Shadow Faculty Appointment Database Robert Blum 10 server Windows MS Access MS Access
tbl-2006-3-29-
Faculty personnel actions database 886 ISFuture_Inventory-a-xls Provost Arts and Sciences Sociology No 2 Acad HR Access to Information, Reporting & Business Intelligence Production Sociology Sociology Sociology track faculty personnel actions Michele Conrad 1 Windows PC Windows XP Pro SP2 MS Access MS Access
ISFutures_Inventory- http://norfolk.cs.washington.edu/recr
faculty recruiting 1115 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 HR & Payroll Production CSE CS Lab CSE Faculty Manage CSE faculty recruiting Scott Rose rose@cs hundreds uit Unix postgresql
Inquiry tool for faculty to determine if they qualify
for the special salary increase and/or lump
Faculty Settlement OIM OIM Inventory 1 C&C/OIM C&C/OIM AHR sum payment. NT NT SQL Server ASP.NET/SQL Visual Studio .NET Web
Entry of vacation or absences by faculty and
ISFutures_Inventory- staff. Display a calendar showing these for all
faculty/staff away tracking 1119 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 OWLS HR & Payroll Production CSE CS Lab CSE Business Office users Dan Boren boren@cs 100 http://www.cs.washington.edu/away Unix postgresql
did they make
ISFutures_Inventory- their own UW Display database driven directory of faculty and http://norfolk.cs.washington.edu/htbi
faculty/staff online directory 1117 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 4 Directory? HR & Payroll Production CSE CS Lab CS Lab staff contact information Dan Boren boren@cs 1000? n-php/cseoffice/facstaff/ Unix postgresql
Report of SOM ICR from
Richard Meeks - Mar hbarr@u.washington.e
FADU login server 714 2006.xl Provost SOM SOM - Psychiatry No 6 SOM Production Role: SO du
Collect and store faculty activity data for each
tbl-2006-3-29- year, including publications, courses taught,
FAR Database (Faculty Activity Reports) 881 ISFuture_Inventory-a-xls Provost Arts and Sciences Sociology No 2 Acad HR Access to Information, Reporting & Business Intelligence Production Sociology Sociology Sociology university service, committees served on, etc. Michael Goldblatt 35 Server Windows 2000 Server MS Access MS Access
Daily updates, monthly, annual, and biennial
processes. Up-to-date Budget Activity (BAR)
reports, Budget Status Reports, budget lists,
and descriptive information about budgets and http://www.washington.edu/admin/a http://www.washington.edu/admin/admi
FAS OIM OIM Inventory Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM FM financial coding. dminsystems/FIN/ nsystems/forms/access.pdf homegrown Unisys MCP Unisys MCP DMS II COBOL SURE NA
FAS - AFRS OIM OIM Inventory Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM GAO FAS system process Unisys MCP Unisys MCP DMS II COBOL SURE NA
FAS - Budget/Student/Purchasing/Salary Savings
interface OIM OIM Inventory Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM GAO FAS system process Unisys MCP Unisys MCP DMS II COBOL SURE NA
FAS - Payroll load OIM OIM Inventory Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM APL - HEPPS FAS system process Unisys MCP Unisys MCP DMS II COBOL SURE NA
FAS - PCA OIM OIM Inventory Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM GAO - APL FAS system process Unisys MCP Unisys MCP DMS II COBOL SURE green screen
FAS - Special Annual and Biennium process OIM OIM Inventory Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM GAO FAS system process Unisys MCP Unisys MCP DMS II COBOL SURE NA
FAS - TIME online and batch OIM OIM Inventory Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM APL FAS system process Unisys MCP Unisys MCP DMS II COBOL SURE green screen
Unisys MCP, Unisys MCP,
FAS / FDI Web page and Batch OIM OIM Inventory Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM GAO - FDI FAS system process Windows Windows DMS II COBOL SURE NA
OIM Inventory,systems
FAS, OFIS, MIS online and batch 240, 241 OIM inventory.xls Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM GAO - APL - BGT Online access to FAS data. Unisys MCP Unisys MCP DMS II COBOL SURE green screen
COBOL,
FAST downloads OIM OIM Inventory Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM GAO Transaction downloads from FAS system. Unisys MCP Unisys MCP DMS II ERGO SURE green screen
FASTRANS OIM OIM Inventory Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM GAO Transaction uploads to FAS system. AIX AIX NA Perl green screen
paper, green
FEC batch & online OIM OIM Inventory 1 C&C/OIM C&C/OIM MAA Faculty Effort Certification Unisys MCP Unisys MCP DMS II COBOL SURE screen
<0> What type of data? => <0> Size/volume of
tbl-financial- data? => 264KB <0> Data used for? => FECs
management-decision- <0> Update freq? => <0> How used/purpose?
FECADMIN 513 support-inventor Executive Vice President Financial Management MAA No 3 Finance & Budget => Laurent Anstett Nebula MS Access
<0> What type of data? => <0> Size/volume of
tbl-financial- data? => 26.7MB <0> Data used for? => FECs
management-decision- <0> Update freq? => Quarterly <0> How
FECDATA 512 support-inventor Executive Vice President Financial Management MAA Yes 1 Finance & Budget used/purpose? => Laurent Anstett Nebula MS Access
Report of SOM ICR from
Richard Meeks - Mar hbarr@u.washington.e
Fetal Alcohol and Drug Paul Connor Advanced 715 2006.xl Provost SOM SOM - Psychiatry No 6 SOM Production Role: SO du
Report of SOM ICR from
Richard Meeks - Mar hbarr@u.washington.e
Fetal Alcohol and Drug Tracing database 716 2006.xl Provost SOM SOM - Psychiatry No 6 SOM Production Role: SO du
FGR (Faculty Grade Report) processing dbs 556 Provost Student Affairs University Registrar No 4 no info Students, Teaching & Learning
<0> What type of data? => Field Advance
Transactions Records for Last 3 Years <0>
Size/volume of data? => 556 KB <0> Data used
tbl-financial- for? => Dashboard, Auditing Dept, Our Own
management-decision- Internal Processes <0> Update freq? => Daily Tom Phillips/Cathy
Field Advances 481 support-inventor
2006-4-2- Executive Vice President Financial Management Financial Services No 3 Access to Information, Reporting & Business Intelligence <0> How used/purpose? => . Data source: Sleipnes Network MS Access
ISFutures_Inventory- UW Bothell Network
Fiji (Intranet Server) 979 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems No 5 Communications, Infrastructure & Middleware Development N/A Operations UW Bothell Information Systems Provide UW Bothell Intranet UW Bothell Web Services 20 server Red Hat Linux MySQL Perl, Mason
D:\Docstoc\Working\pdf\2c08cb85-d9bf-4007-a741-bfedcadde02b.xls
SOM
Who supports the system (who provides modifications, corrects problems, Who is the business owner (dept responsible for managing the day to day
System-name ID Tag source-file
2006-4-2- Organization College, School or Office Division Provides campus-wide service? TIER Shadow Sys? System-Type Status Developed-by develops new features?) Who-Operates-System operation of the system) description-function Contact-Person contact-person-email number-of-users System Documentation Location Data Dictionary Location How to request access to the system Vendor-Name Hardware Platform Operating System Database software Language Development Environment User Interface
ISFutures_Inventory- UW Bothell Information UW Bothell Network
File Server (Mercury, Hermes) 965 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Network Operations No 5 Communications, Infrastructure & Middleware Production N/A Systems UW Bothell Network Operations Primary file servers for all bothell users. Operations 1200 server Windows Server N/A N/A
Report of SOM ICR from
Richard Meeks - Mar ashep@u.washington.e
Filemaker server 590 2006.xl Provost SOM SOM - Laboratory Medicine No 6 SOM Production Role: SO du
http://www.washington.edu/admin/a http://www.washington.edu/admin/admi
FIN OIM OIM Inventory Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C/OIM C&C/OIM FM Online access to FAS data. dminsystems/FIN/ nsystems/forms/access.pdf homegrown Unisys MCP Unisys MCP DMS II COBOL SURE green screen
<0> What type of data? => <0> Size/volume of
data? => 31.8MB <0> Data used for? => Create
a report to monitor salary cap cost sharing <0>
tbl-financial- Update freq? => Every year or daily when
management-decision- developping new functionality <0> How
Final Report 514 support-inventor Executive Vice President Financial Management MAA No 3 Finance & Budget used/purpose? => To determine which Laurent Anstett Nebula MS Access
C#, ASP.NET,
Financial Aid Inquiry OIM OIM Inventory 1 C&C/OIM C&C/OIM Office of Student Financial Aid Web-based service for Financial Aid Office staff Windows Windows DMS II Jscript Vis Studio Web
OIM Inventory, systems
Financial Desktop - My Financial.Desktop 239 OIM inventory.xls Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Production C&C C&C FM Windows Windows SQL Server ASP.NET C# Visual Studio 6.0 Web
OIM Inventory, tbl-2006-3-
29-ISFuture_Inventory-a- Budget tracking -- application still under
Financial Desktop - Online Transactions Application 237 OIM xls Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Development C&C C&C Financial Management development. 5 Windows Windows SQL Server ASP.NET C# Visual Studio 6.0 Web
OIM Inventory, systems
Financial Desktop - Project Cost Accounting 238 OIM inventory.xls Executive Vice President Financial Management Financial Accounting Yes 1 Finance & Budget Development C&C C&C FM application still under development. Windows Windows SQL Server ASP.NET C# Visual Studio 6.0 Web
Financial Meta Database 477 Executive Vice President Financial Management Financial Accounting No 4 Finance & Budget
Financial Reporting - Bank Reconcilliation OIM OIM Inventory 1 C&C/OIM C&C/OIM Financial Accounting Reconciles bank statements to UW accounts Windows Windows MS Access MS Access MS Access Fat client
Job Request scheduling + parameters via web
FinParams OIM OIM Inventory 2 C&C/OIM C&C/OIM for FIN, BGT, GABS, FEC, SRS applications Windows Windows DMS II (apecs) Jscript Visual Studio 6.0 Web
Report of SOM ICR from
Richard Meeks - Mar ccbishop@u.washingto
FirstClass Email System 583 2006.xl Provost SOM SOM - Family Medicine No 6 SOM Production Role: SO n.edu
Report of SOM ICR from
Richard Meeks - Mar akukuk@u.washington.
Fluffy Server 604 2006.xl
2006-4-2- Provost SOM SOM - MEDEX Northwest No 6 SOM Production Role: SO edu
ISFutures_Inventory- UW Bothell Network Web interface for requesting, dispatching and UW Bothell Network
FM1 962 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Physical Plant Yes 1 Facilities, Transportation & Space Production N/A Operations UW Bothell Physical Plant reporting physical plant work orders. Operations 500 server Windows Server SQL Server FM1
Synchronize FME data with other University Windows 2003 Windows 2003
FME batch interfaces OIM OIM Inventory 1 C&C/OIM C&C/OIM Facilities Services Systems Server Server SQL Server C# Visual Studio .NET NA
Tracks budget expenditures for Evans School
and associated research centers. It allows for
tbl-2006-3-29- sufficient detail and necessary reports that
FndDB (Evans School) 863 ISFuture_Inventory-a-xls Provost Evans School of Public Affairs Evans School Financial No 2 FIN Finance & Budget Production Evans School Computing Evans Computing Evans Fiscal Office central UW systems cannot provide. Kole Kantner 8 Server Windows MS Access MS Access
Food Management System 96 systems inventory.xls Provost Student Affairs Housing & Food Services No 2 Finance & Budget Production Vendor HFS HFS Used to manage contacts, process
applications, scholarships, committees,
programs of study, and produce letters and
Forest Resources db (MS Access) 130 systems inventory.xls Provost Forest Resources Forest Resources No 2 SDB Students, Teaching & Learning reports.
<0> What type of data? => Financial information
based on Form of Payment <0> Size/volume of
tbl-financial- data? => 10 mb <0> Data used for? =>
management-decision- Reconciling Form of Payments <0> Update GCA CR3 team, GCA
Form of Payment reconcilation 504 support-inventor
2006-4-2- Executive Vice President Financial Management GCA No 3 Finance & Budget freq? => <0> How used/purpose? => Systems Development Nebula file server ERGO (comma delimited file), MS Access
ISFutures_Inventory- College of Education https://depts.washington.edu/educ/ticke
Fox Pro 928 a.xls Provost Education College of Education Dean's Office No 2 FIN Finance & Budget Production Technology Center College of Education Dean's Office This is a financial tracking/reporting database Scott Macklin 4 None exists None exists tdb/ It lives on a file share FoxPro v2.6
Windows 2003 Server/Windows XP FoxPro v2.6
Report of SOM ICR from
Richard Meeks - Mar ashep@u.washington.e
Freezerworks 591 2006.xl Provost SOM SOM - Laboratory Medicine No 6 SOM Production Role: SO du
Report of SOM ICR from
Richard Meeks - Mar nidus@u.washington.e
fs.nb.engr.washington.edu 564 2006.xl Provost SOM SOM - Bioengineering No 6 SOM Production Role: SO du
Windows 2003 Windows 2003 ASPX, C#,
SQL Server Visual Studio .NET
FS_Billing OIM OIM Inventory 1 C&C/OIM C&C/OIM Facilities Services Monthly billing for FME Server Server JavaScript Web
Windows 2003 Windows 2003 ASPX, C#,
SQL Server Visual Studio .NET
FS_ProcessManagement OIM OIM Inventory 1 C&C/OIM C&C/OIM C&C UI to manage scheduled tasks Server Server JavaScript Web
OIM Inventory, ITRSG International Student Tracking (SEVIS Proprietry
Student and Exchange Visitor Information System needs assessment compliance) fsaAtlas. Tracks international vendor
(SEVIS), fsaAtlas 449 OIM appendices.doc Provost Office of Global Affairs International Services Office Yes 1 Students, Teaching & Learning Production Vendor C&C/OIM C&C/OIM International Services Office (ISO) students Windows Windows SQL Server software Web
User interface to FME. Allows anyone with
UWNetID to enter work orders in system, Windows 2003 Windows 2003 C#, ASPX,
Facilities Services monitor progress and status. Linked to GARP / SQL Server Vis Studio.NET Web
Server Server Javascript
OIM Inventory, systems Ariba for approval routing; Ariba uses ASTRA to Paul Smith, Technology
FS-WORKS facilities work order request system 219 OIM inventory.xls Executive Vice President Facilities Services Maintenance & Operations Yes 1 Communications, Infrastructure & Middleware Production C&C C&C/OIM C&C/OIM manage approval graphs. Officer
Fume hoods 1206 FAMS Inventory.xls Provost Health Sciences Environmental Health and Safety No 3 Facilities/Transportation and Space in-house Locations/Testing
GABS batch & online OIM OIM Inventory 1 C&C/OIM C&C/OIM Grant & Contract Accounting Grant & Contract Budgeting Unisys MCP Unisys MCP DMS II COBOL SURE green screen
Report of SOM ICR from
Richard Meeks - Mar liseq@u.washington.ed
Garden lab 673 2006.xl Provost SOM SOM - Neurology No 6 SOM Production Role: SO u
Report of SOM ICR from
GCRC domain (managed by Pathology Computer Richard Meeks - Mar kfleming@u.washingto
Support) 579 2006.xl Provost SOM SOM - Dean's Office No 6 SOM Production Role: SO n.edu
General Ledger 54 systems inventory.xls Provost School of Medicine Medical Affairs No 4 MCIS Finance & Budget Production MCIS MCIS
Report of SOM ICR from
Richard Meeks - Mar joee@u.washington.ed
genetests 699 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO u
Report of SOM ICR from
Richard Meeks - Mar bpagon@u.washington.
GeneTests production network 700 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar clarknl@u.washington.
gigantea.gs.washington.edu 587 2006.xl Provost SOM SOM - Genome Sciences No 6 SOM Production Role: SO edu
Tracking accurate time and billing for residents
GMETABS (Graduate Medical Education Time and tbl-2006-3-29- and fellows, for medicare billing compliance
Billing System) 909 ISFuture_Inventory-a-xls Provost School of Medicine Medical Affairs No 6 Finance & Budget purposes. 80
ISFutures_Inventory- Management and tracking of student and http://norfolk.cs.washington.edu/htbi
grad advising management 1128 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 SDB HR & Payroll Production CSE CS Lab CSE Advising applicant data by academic advisors Dan Boren boren@cs 2 n-php/advising/grad/index.php Unix postgresql
Entry and management of course grades from
ISFutures_Inventory- course staff. Permit student review of grades http://norfolk.cs.washington.edu/htbi
grades db 1106 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 SDB Students, Teaching & Learning Production CSE CS Lab CS Lab using CSE channel on MyUW. Dan Boren boren@cs n-php/boren/grades/index.php
500 students, 20 staff (per quarter) Unix SQL Server
Used to accept & track MLIS Admissions
Graduate Application 133 systems inventory.xls Provost Information School Information School No 2 SDB Students, Teaching & Learning Applications.
Used by benefits to manage the deductions
and contributions for the Graduate Appointee
from-joe-kittleson- Insurance Program which are processed
Graduate Appointee Insurance system 917 20060330.xls Executive Vice President Human Resources Benefits Yes 1 HR & Payroll through HEPPS.
OIM Inventory, ITRSG Web search tool for UW degree recipients.
needs assessment Allows outsiders to search for people who have
Graduate Directory 460 OIM appendices.doc Provost Student Affairs University Registrar Yes 1 Students, Teaching & Learning Production C&C C&C/OIM C&C/OIM University Registrar received UW degrees homegrown Windows Windows SQL Server asp Vis Studio Web
<0> What type of data? => award
numbers/PI/budget numbers/sponsors <0>
Size/volume of data? => 11,754 to date, 7 fields
tbl-financial- each <0> Data used for? => Budget information
management-decision- and award information for closing reports <0>
Grand7 Budgets 490 support-inventor
2006-4-2- Executive Vice President Financial Management Financial Accounting: Equipment Inventory No 2 Finance & Budget Update freq? => monthly <0> How used/purpos Crabb/Wall Nebula G: drive MS Access
ISFutures_Inventory-
Grant & Contract Tracking System 935 a.xls Provost Arts and Sciences Dean - A&S No 2 Research Research & Grant Production Dean - A&S Dean - A&S Dean - A&S Track grant submissions and awards Robert Blum 6 server Windows MS Access MS Access
Tracks all funded grants in the School of
Nursing and related details, including PI, award
amount, funding source, title of project, etc.,
which often support/fund graduate students in
the School of Nursing. One touch button within
Grant DB 149 systems inventory.xls Provost Nursing School Nursing School No 2 Research Research & Grant Access db uploads selec
tbl-2006-3-29- contains info on grants & human subjects
Grants & human subjects review database 887 ISFuture_Inventory-a-xls Provost Arts and Sciences Sociology No 2 Research Research & Grant Production Sociology Sociology Sociology applications processed in the department. Michele Conrad 1 Windows PC Windows XP Pro SP2 MS Access MS Access
ISFutures_Inventory-
grants database 1113 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Research Research & Grant Production CSE CS Lab CSE Business Office Manage grant proposals and awards Erik Lundberg lundberg@cs 2 Windows MS Access
Great Plains 188 systems inventory.xls Executive Vice President Capital Projects Office Capital Projects No 4 Finance & Budget Production Vendor CPO CPO
Great Plains (Microsoft SQL) 1209 FAMS Inventory.xls Executive Vice President Capital Projects Office Capital Projects No 4 Finance & Budget vendor Accounting SQL Server
UW high performance grid computing resource.
Boinc is the term we use to talk about the
program, but it's actually the mechanism that
allows HFS computers to participate in a UW
tbl-2006-3-29- Biogenome project called Rosetta@home.
Grid computing 890 ISFuture_Inventory-a-xls Provost Student Affairs Housing & Food Services No 5 Communications, Infrastructure & Middleware Production R@H hopes to cure several diseases, Ethan Owens (HFS) eko@u.washington.edu http://boinc.bakerlab.org/rosetta/ http://hfs.washington.edu/boinc/
ISFutures_Inventory- http://www.cs.washington.edu/lab/G
grpadmin 1142 ENG CSE-20060407.xls
2006-4-2- Provost Engineering Computer Science and Engineering No 3 Communications, Infrastructure & Middleware Production CSE CS Lab CS Lab Manage Unix group membership, by users Scott Rose rose@cs 100 rpAdmin/ Unix postgresql
ISFutures_Inventory- UW Bothell Network UW Bothell Network
Hades 963 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems No 5 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Information Systems Primary Exchange server for UW Bothell Operations 500 server Windows Server SQL Server Exchange
Prepare purchase request information with a
related vendor table, and then be able to track
Hardware and software acquisition and inventory tbl-2006-3-29- Language Learning and modify hardware and software assets and
management 865 ISFuture_Inventory-a-xls Provost Language Learning Center Language Learning Center No 4 Other Production Language Learning Center Center Language Learning Center generate reports and queries on them. Bob Majors 20 Workgroup server. Mac OS X. FileMaker Server 7 (may go to 8 and to Server Adva
Medical, Dental, Life, LTD are managed
through the HCA's systems as well as HEPPS.
Benefits Office personnel enter data into an
external state system that is fed to the UW as
from-joe-kittleson- billing files that become deduction and
HCA System 919 20060330.xls Executive Vice President Human Resources Benefits Yes 1 HR & Payroll contributions in payroll. This is part
Core payroll system. Payroll Activity Form and
Personal Data Form information, paycheck
detail and histories, hourly accumulations for
student and temporary workers, and job
classification tables.
OIM Inventory, tbl-2006-3-
29-ISFuture_Inventory-a- Mainframe legacy system that stores all http://www.washington.edu/admin/a http://www.washington.edu/admin/admi
HEPPS 267 OIM xls Executive Vice President Financial Management Payroll No 1 HR & Payroll Production C&C Administrative Systems C&C/OIM C&C/OIM Payroll/HR payroll/HR related information to ensu Ginny Montgomery 100s dminsystems/INTRO/ nsystems/forms/access.pdf homegrown Unisys MCP Unisys MCP DMS II COBOL/DFDS SURE/Pgm's Workbench green screen
HEPPS Check Register 268 OIM systems inventory.xls
2006-4-2- Executive Vice President Financial Management Payroll Yes 1 HR & Payroll Production C&C C&C Payroll
ISFutures_Inventory- UW Bothell Information Provides print queues for all IS supported UW Bothell Network
Hera (Print server) 964 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Network Operations No 5 Communications, Infrastructure & Middleware N/A Systems UW Bothell Network Operations printers Operations 1200 server Windows Server N/A N/A
Report of SOM ICR from
Richard Meeks - Mar anderm@u.washington
HMC Endocrinology Advanced Systems 650 2006.xl Provost SOM SOM - Medicine - Metabolism & Endocrinology No 6 SOM Production Role: SO .edu
The authoritative name servers for
'homer.u.washington.edu' are:
dnsload2.cac.washington.edu 140.142.2.21
dnsload1.cac.washington.edu 140.142.1.21
homer.u.washington.edu:
SOA (Start of Authority):
origin = dnsload1.cac.washington.edu
Homer: Faculty & Staff Email and Web Publishing 1223 tmildon Vice President C&C C&C C&C: Infrastructure No 5 Communications, Infrastructure & Middleware
Maintain information about CSE computing
ISFutures_Inventory- equipment; also, of user requests for network http://norfolk.cs.washington.edu/htbi
hostrec 1139 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 3 Facilities, Space & Equipment Production CSE CS Lab CS Lab access Scott Rose rose@cs 20 n-post/lab/hr.cgi Unix postgresql
Measures, metrics, scorecards for HFS data-
Housing and Food Services Business Intelligence 1230 Provost Student Affairs Housing & Food Services No 5 no listing on web Access to Information, Reporting & Business Intelligence Production driven management.
HR Admin OIM OIM Inventory 1 C&C/OIM C&C/OIM HR Human Resource Administration NT NT SQL DTS Package SQL DTS Environment NA
Role based information access and entry for
from-joe-kittleson- HR employees through a web portal service
HR Intranet Portal server 924 20060330.xls Executive Vice President Human Resources HRIS No 5 HR & Payroll running within Nebula. 150
Limited access information management,
from-joe-kittleson- analysis and reporting services to support HR
HR Reporting and Analysis servers 923 20060330.xls Executive Vice President Human Resources HRIS No 2 HRMIS HR & Payroll activities including negotiaitons. 6
Report of SOM ICR from
Richard Meeks - Mar ryeh@u.washington.ed
hsb1214568fel3.medicine.washington.edu 625 2006.xl Provost SOM SOM - Medicine - Gastroenterology No 6 SOM Production Role: SO u
Husky Card System 93 systems inventory.xls Provost Student Affairs Housing & Food Services Yes 1 Finance & Budget Production Vendor HFS HFS
All UW students that are currently enrolled in a
matriculated degree program may register to
access HuskyJobs, an online Job Listing
ITRSG needs Service. Hundreds of job listings are posted
assessment each month with the majority located in the
HuskyJobs 438 appendices.doc Provost Student Affairs Center for Career Services Yes 1 Students, Teaching & Learning Production vendor Pacific Northwest. Once registere
Coordinate with Transportation Services -
ID card - Smart Card 98 systems inventory.xls
2006-4-2- Provost Student Affairs Housing & Food Services Yes 1 Students, Teaching & Learning Development Department HFS HFS Regional Transit Smart Card/U-PASS
ISFutures_Inventory- Interlibrary loan request, tracking, and
Illiad (Duwamish) 949 a.xls Provost University Libraries Library Yes 1 Students, Teaching & Learning Production Libraries IT Services Interlibrary Loan fulfillment. Bill Jordan 5000 http://www.lib.washington.edu/uworld/ Atlas Systems intel-based server Windows 2000 SQL Server, IIS/ASP
MS Access,
DTS, ActiveX
IMA File Downloads Recreational Sports Recreational Sports unix, windows unix, windows Informix, SQL Server MS Access, DTS, ? NA
scripting, Unix,
OIM OIM Inventory 1 C&C/OIM C&C/OIM scp
Risk score n/a - application still under
development. Will allow SFS to scan loan
Imagesource document imaging system 294 systems inventory.xls Executive Vice President Financial Management Student Fiscal Services Yes 1 Finance & Budget Development Vendor C&C SFS documents. Scheduled implementation 2006 Peggy Fitzwater
Imagesource invoice imaging system 249 systems inventory.xls Executive Vice President Financial Management Financial Services: Payables Yes 1 Finance & Budget Production Vendor C&C AP
Report of SOM ICR from
Richard Meeks - Mar barblov@u.washington.
Immunology Labs 589 2006.xl Provost SOM SOM - Immunology No 6 SOM Production Role: SO edu
Indirect Cost Recovery 283 systems inventory.xls Executive Vice President Financial Management MAA No 1 Finance & Budget Production C&C C&C FM/GCA
Report of SOM ICR from
Richard Meeks - Mar andync@u.washington.
Individual Workstations With PHI 561 2006.xl Provost SOM SOM - Anesthesiology No 6 SOM Production Role: SO edu
ISFutures_Inventory- Maintain archival records of dept industrial
Industrial Affiliates Archive 1150 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 3 Access to Information, Reporting & Business Intelligence Production CSE CSE External Relations CSE External Relations affiliates Scott Dakins sjdakins@cs 1 Windows MS Access
ISFutures_Inventory-
Industrial Affiliates DB 1149 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 3 Access to Information, Reporting & Business Intelligence Production CSE CSE External Relations CSE External Relations Track departmental industrial affiliates Scott Dakins sjdakins@cs 1 Windows ACT 2005
Management of metadata about engineering Java, ASP
documents; also document storage on VBScript, XML,
filesystem. Used by records center. Building / Windows 2003 Windows 2003 SOAP, XSLT,
Engineering Services & Facilities Records SQL Server proprietary Web
engineering drawings (ex. AutoCAD Server Server C, C++,
Innovator (Engineering document management OIM Inventory, systems documents) online and available to anyone with Paul Smith, Technology JavaScript,
system) 215 OIM inventory.xls Executive Vice President Facilities Services Facilities Services Yes 1 Facilities, Transportation & Space Production Vendor C&C/OIM C&C/OIM UWNetID Officer XTML
Used (a) for targeted recruiting to our graduate
programs (individualized follow-up with people
considering applying to the School of Nursing);
(b) for providing reports/evidence for training
grant proposals wherein the PI must
Inquiry DB 150 systems inventory.xls Provost Nursing School Nursing School No 2 SDB Students, Teaching & Learning demonstrate demandwarehouse purchasing
Manage the Telecom for the
and inventory; service requests for install and
Service Delivery & Support-Technical Services / C&C Business & Finance / Customer repair; timesheets for time&material
Installer application OIM OIM Inventory 1 C&C/OIM C&C/OIM Care accounting. unix unix Informix Informix 4GL vi-Informix 4GL / CVS
A program to collect and summarize student
ITRSG needs ratings of instruction at the postsecondary level.
assessment Office of Educational Office of Educational OMR (optical mark recognition) and online http://www.washington.edu/oea/serv
Instructional Assessment System (IAS) 462 appendices.doc Provost Undergraduate Education Office of Educational Assessment Yes 1 Students, Teaching & Learning Production Assessment Assessment Office of Educational Assessment services available. ices/course_eval/index.html
Web-based service for instructor description of
OIM Inventory, ITRSG class learning goals, method of instruction, etc.
needs assessment Expanded instructor-specific class description C+, ASP,
Instructor Class Descriptions 459 OIM appendices.doc Provost Student Affairs University Registrar Yes 1 Students, Teaching & Learning Production C&C C&C/OIM C&C/OIM University Registrar information Robert Jansson Windows Windows Informix Jscript Vis Studio Web
<0> What type of data? => Register/track staff
training activity <0> Size/volume of data? =>
1699 records to date, 16 fields each <0> Data
tbl-financial- used for? => Ensure proper training/give credit
management-decision- for training <0> Update freq? => Monthly <0>
Inventory Classes 487 support-inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory No 3 HR & Payroll How used/purpose? => Ke Heidi Gustafson Nebula G: drive MS Access
UW departments generate their own invoice
and sends a copy to SFS. SFS enters the
invoice in the invoice dbs. Customers send
pymts to SFS, which SFS then enters pymts in
invoice dbs, create CT and post pymt to
Invoice Database 295 systems inventory.xls Executive Vice President Financial Management Student Fiscal Services Yes 1 Finance & Budget Production Department SFS SFS department budget. Within the next year, Peggy Fitzwater
<0> What type of data? => INVOICE
RECEIVABLE SUBMITTED BY DEPARTMENTS
<0> Size/volume of data? => LARGE <0> Data
tbl-financial- used for? => PROCESS PAYMENTS; CREATE
management-decision- CTS <0> Update freq? => DAILY <0> How
INVOICES 531 support-inventor Executive Vice President Financial Management Student Fiscal Services Yes 1 Finance & Budget used/purpose? => Peggy Fitzwater NEBULA FoxPro
IPEDS db 552 Provost Student Affairs University Registrar No 4 Access to Information, Reporting & Business Intelligence
<0> What type of data? => record of all W-2s for
UW employees, forms 1042-s (NRA
employees, stipend recipients, forms 1099-R
tbl-financial- (UW retirees receiving comp from HEPPS -
management-decision- supplementary payments) <0> Size/volume of Heather Norberg-
IRS Tax Form database 517 support-inventor Executive Vice President Financial Management Payroll Yes 1 HR & Payroll data? => 4 years w-2- about 200,000 records, 2 Stewart/Shawna Litterski C&C server SQL Server
Support iSchool budget financial analysis,
reconciliation and reporting. The databases
serve several functions that the central systems
can not provide, They enable reporting by
tbl-2006-3-29- project coding (called "Project Cost
iSchool Financial Databases 859 ISFuture_Inventory-a-xls Provost Information School Information School No 2 FIN Finance & Budget Production Accounting" in the central s Mary Clark 3 Windows MS Access
D:\Docstoc\Working\pdf\2c08cb85-d9bf-4007-a741-bfedcadde02b.xls
SOM
Who supports the system (who provides modifications, corrects problems, Who is the business owner (dept responsible for managing the day to day
System-name ID Tag source-file Organization College, School or Office Division Provides campus-wide service? TIER Shadow Sys? System-Type Status Developed-by develops new features?) Who-Operates-System operation of the system) description-function Contact-Person contact-person-email number-of-users System Documentation Location Data Dictionary Location How to request access to the system Vendor-Name Hardware Platform Operating System Database software Language Development Environment User Interface
Online application system for students applying
to our MLIS, MSIM, and Ph.D. programs.
Connects with the Graduate School online
application system. Includes administrative
tbl-2006-3-29- interfaces for students so they can check their
iSchool Graduate Application System 857 ISFuture_Inventory-a-xls Provost Information School Information School No 2 SDB Students, Teaching & Learning Production iSchool IT iSchool IT iSchool Student Services application status after applying Scott Barker 10 Windows Server SQL Server .NET
Provides an online application for students
applying to our undergraduate Bachelor of
Science in Informatics program. Includes
tbl-2006-3-29- administrative interfaces for both students and
iSchool Informatics Application System 858 ISFuture_Inventory-a-xls Provost Information School Information School No 2 SDB Students, Teaching & Learning Production iSchool IT iSchool IT iSchool Student Services student services staff. Scott Barker 5 Windows Server SQL Server .NET
tbl-2006-3-29- FootPrint is the UW Tacoma Help Desk
IT Help 895 ISFuture_Inventory-a-xls UW Tacoma Chancellor UW Tacoma UW Tacoma - Information Technology Yes 1 Access to Information, Reporting & Business Intelligence Production Computer Services Computer Services System. Forrest Tyree 2300 Unipress
ASP.NET
ITL OIM OIM Inventory 1 C&C/OIM C&C/OIM Payroll Integrated Time & Leave (online timesheet) NT NT DMS II & Sql Server C#/DFDS Visual Studio .NET Web
Report of SOM ICR from
Richard Meeks - Mar
JARDINE-LAB 562 2006.xl Provost SOM SOM - Anesthesiology No 6 SOM Production Role: SO dsj@u.washington.edu proprietary vdr
software
(Stores: JDE
OneWorld XE;
GRIP: JDE
ERP 8 -->
EnterpriseOne Web
Stores (purchase/sales orders/picklists/ 8.12) + (+ fat client, until
warehouse ops/inventory control/ invoicing) + Windows 2003 Windows 2003 WebSphere move to
(GCA) Grant Receivables Implementation Proj (Stores) / Windows (Stores) / Windows 4.0 (-->6.0), EnterpriseOne
JDE/Stores + JDE/GRIP 505,279 OIM OIM Inventory Executive Vice President Financial Management GCA,MAA Yes 1 Finance & Budget Production Vendor C&C/OIM C&C/OIM Purchasing & Stores + GCA (incl sponsor invoicing, AR, EDI) 2000 (GRIP) 2000 (GRIP) SQL Server IIS proprietary (JDE) 8.12)
from-joe-kittleson-
Job Class location tool 916 20060330.xls Executive Vice President Human Resources Compensation No 2 HR HR & Payroll
JP Morgan Chase (department central travel 254 systems inventory.xls Executive Vice President Financial Management Financial Services: Travel Yes 1 Finance & Budget
JP Morgan Chase (individual charge card) 255 systems inventory.xls Executive Vice President Financial Management Financial Services: Travel Yes 1 Finance & Budget Production Vendor/C&C
JP Morgan Chase (procurement card) 252 systems inventory.xls Executive Vice President Financial Management Financial Services: Procurement Card Yes 1 Finance & Budget Production Vendor/C&C
Report of SOM ICR from
Richard Meeks - Mar hearsey@u.washington
Katze Lab Unix Servers 662 2006.xl Provost SOM SOM - Microbiology No 6 SOM Production Role: SO .edu
Report of SOM ICR from
Richard Meeks - Mar ellenc@u.washington.e
KCLIP 657 2006.xl
2006-4-2- Provost SOM SOM - Medicine - Pulmonary & Critical Care No 6 SOM Production Role: SO du Key and
ISFutures_Inventory- UW Bothell Network UW Bothell Network License
Keyserver (Legba, Kshadow) 966 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems No 2 Access to Information, Reporting & Business Intelligence Production N/A Operations UW Bothell Information Systems Sassafras keyserver and FlexLM licensing Operations 5 server Windows Server SQL Server server
Report of SOM ICR from
Richard Meeks - Mar ashep@u.washington.e
Labmed instrument pcs and macs 594 2006.xl Provost SOM SOM - Laboratory Medicine No 6 SOM Production Role: SO du
Report of SOM ICR from
Richard Meeks - Mar ashep@u.washington.e
Labmed Windows domain controllers and servers 595 2006.xl Provost SOM SOM - Laboratory Medicine No 6 SOM Production Role: SO du
This is used by Computer Services, CTLT and
tbl-2006-3-29- Media Services in UW Tacoma to check out
Laptop Checkout System 903 ISFuture_Inventory-a-xls UW Tacoma Chancellor UW Tacoma UW Tacoma No 2 Students, Teaching & Learning Development Computer Services Chan Mom CTLT, Computer Services, Media Services, UW Tacoma laptops to students. Eric Elkins 15
Time card data entry and validation for FME Windows 2003 Windows 2003 ASPX, C#,
LATTE Facilities Services SQL Server Visual Studio .NET Web
OIM OIM Inventory 1 C&C/OIM C&C/OIM application Server Server JavaScript
Leave and time tracking enterprise. Web
based interface into FME. Used for payroll staff
LATTE (Time Collection System) 216 systems inventory.xls Executive Vice President Facilities Services Facilities Services Yes 1 OWLS HR & Payroll Production C&C C&C FS to track employees time.
Processes that maintain an interface database
which feeds data to UW Medicine WMS
Lawson Transfer interface OIM OIM Inventory 1 C&C/OIM C&C/OIM UW Medicine processes NT NT SQL Server NA
Report of SOM ICR from
Richard Meeks - Mar ashep@u.washington.e
LDMS 596 2006.xl
2006-4-2- Provost SOM SOM - Laboratory Medicine No 6 SOM Production Role: SO du
ISFutures_Inventory- UW Bothell Network UW Bothell Network
Legion (VMWare Server) 978 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems No 5 Communications, Infrastructure & Middleware Development N/A Operations UW Bothell Information Systems Testing environment Operations 20 server Red Hat Linux N/A VMWare
Report of SOM ICR from
Richard Meeks - Mar hearsey@u.washington
Linux Servers 663 2006.xl Provost SOM SOM - Microbiology No 6 SOM Production Role: SO .edu
Report of SOM ICR from
Linux Systems - Pathology Computer Support Richard Meeks - Mar kfleming@u.washingto
Managed 688 2006.xl Provost SOM SOM - Pathology No 6 SOM Production Role: SO n.edu
Authorization of Uwats, Callingcards, Toll
C&C Business & Finance and Customer Care associated with campus budgets -- for the
Long Distance authorization OIM OIM Inventory 1 C&C/OIM C&C/OIM Long Distance billing. unix unix Informix Informix 4GL vi-Informix 4GL / CVS
Monthly, Call detail billing of long distance calls
C&C Business & Finance and Customer Care (call details from pbx and outside vendors) COBOL /
Long Distance billing OIM OIM Inventory 1 C&C/OIM C&C/OIM (authorizations from our fortune LD Auth) Unisys MCP; Unix Unisys MCP; Unix DMS II / Informix Informix 4GL SURE / vi-Informix 4gl / CVS
Report of SOM ICR from
Richard Meeks - Mar ryeh@u.washington.ed
LT1230936ROCY.medicine.washington.edu 626 2006.xl
2006-4-2- Provost SOM SOM - Medicine - Gastroenterology No 6 SOM Production Role: SO u
ISFutures_Inventory- UW Bothell Network Exchange mail bridgehead and webmail UW Bothell Network
Mail Exchange (Lachesis, Styx) 967 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems Yes 1 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Information Systems server. Operations 500 server Windows Server SQL Server Exchange
2006-4-2- Postfix, SPAM
ISFutures_Inventory- UW Bothell Network SPAM and Virus filtering for UWB.edu domain UW Bothell Network assassin, ISC
Mail Gateway (Alecto, Alectoo, DHCP) 976 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems Yes 1 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Information Systems mail and Campus DHCP. Operations 5 server Red Hat Linux MySQL DHCPD
<0> What type of data? => Departmental
contact information <0> Size/volume of data?
=> 1293 records, 27 fields each <0> Data used
tbl-financial- for? => State mandated; contacting correct
management-decision- personnel <0> Update freq? => Daily <0> How
MailInfo 501 support-inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory No 2 Communications, Infrastructure & Middleware used/purpose? => Problem solving and m Heidi Gustafson Nebula G: drive MS Access
<0> What type of data? => contact information
on potential investment managers; records of
meetings with potential managers <0>
tbl-financial- Size/volume of data? => very small but growing
management-decision- <0> Data used for? => record of meetings with
Manager research/meeting database 540 support-inventor Executive Vice President Financial Management Treasury No 2 Finance & Budget potential managers, decision makin Cathy Billings nebula MS Access
Report of SOM ICR from
Richard Meeks - Mar liseq@u.washington.ed
Marra Lab 667 2006.xl Provost SOM SOM - Neurology No 6 SOM Production Role: SO u
2006-4-2- Web-based master's degree request, used by
ISFutures_Inventory- 2,500 master's degree candidates per year.
master's degree request 939 a.xls Provost Graduate School Graduate School Yes 1 Students, Teaching & Learning Production Graduate School Graduate School Graduate School Also includes petition to the Dean. John Drew 2500 student's are required to use UW NetID Windows Server 2003 SQL Server 2000
Web farm, SQL Database clusters ASP.NET
Materials Mgmt (Purchasing) System 56 systems inventory.xls Provost School of Medicine Medical Affairs No 6 PAS Finance & Budget Production MCIS MCIS
This is an image database system developed
tbl-2006-3-29- by James Madison University to support James Madison
MDID (Madison Digital Image Database) 904 ISFuture_Inventory-a-xls
2006-4-2- UW Tacoma Chancellor UW Tacoma UW Tacoma Yes 1 Students, Teaching & Learning Development Computer Services CTLT teaching and learning. Beckie Etheridge 10 University
ISFutures_Inventory- UW Bothell Network Providing digital resources from a web interface UW Bothell Network MDID, IIS Web
MDID (Mona, NewLouvre) 969 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Visual Resources No 2 Students, Teaching & Learning Production N/A Operations UW Bothell Visual Resources using the MDID application. Operations 1200 server Windows Server SQL Server server
Report of SOM ICR from
Richard Meeks - Mar svick2@u.washington.e
MEBI Servers 607 2006.xl Provost SOM SOM - Medical Education & Biomedical Informatics o
N 6 SOM Production Role: SO du
Report of SOM ICR from
Richard Meeks - Mar sdyantis@u.washingto
MedGen - CHDD Clinic 641 2006.xl Provost SOM SOM - Medicine - Medical Genetics No 6 SOM Production Role: SO n.edu
Report of SOM ICR from
Richard Meeks - Mar sdyantis@u.washingto
MedGen - Jarvik Lab System 642 2006.xl Provost SOM SOM - Medicine - Medical Genetics No 6 SOM Production Role: SO n.edu
Report of SOM ICR from
Richard Meeks - Mar sdyantis@u.washingto
MedGen Admin Systems 643 2006.xl Provost SOM SOM - Medicine - Medical Genetics No 6 SOM Production Role: SO n.edu
Report of SOM ICR from
Richard Meeks - Mar sdyantis@u.washingto
MedGen Raskind Lab 644 2006.xl Provost SOM SOM - Medicine - Medical Genetics No 6 SOM Production Role: SO n.edu
Report of SOM ICR from
Richard Meeks - Mar sdyantis@u.washingto
Medical Genetics Division 645 2006.xl Provost SOM SOM - Medicine - Medical Genetics No 6 SOM Production Role: SO n.edu
Report of SOM ICR from
Richard Meeks - Mar kcorning@u.washingto
Medicine Residency Advanced 100% N/A 659 2006.xl Provost SOM SOM - Medicine - Residency No 6 SOM Production Role: SO n.edu
tbl-2006-3-29- This is the calandaring/ scheduling system
MeetingMaker 894 ISFuture_Inventory-a-xls UW Tacoma Chancellor UW Tacoma UW Tacoma Yes 1 Calendar system Access to Information, Reporting & Business Intelligence Production used at UW Tacoma Forrest Tyree 180 People Cube
Track contact info, office hours and keys
tbl-2006-3-29- checked out to members and affiliates of the
Members & Affiliates 882 ISFuture_Inventory-a-xls Provost Arts and Sciences Sociology No 2 Access to Information, Reporting & Business Intelligence Production Sociology Sociology Sociology department. Michele Conrad 4 Windows PC Windows XP Pro SP2 MS Access MS Access
<0> What type of data? => CREDIT CARD
REVENUE FOR DEPARTMENTS USING
CREDIT CARDS <0> Size/volume of data? =>
SMALL (28,000 RECORDS) <0> Data used for?
tbl-financial- => CREATE CTS FOR DEPARTMENTS'
management-decision- REVENUE FROM CREDIT CARD SALES <0>
MERCHANT CREDIT CARDS 524 support-inventor
2006-4-2- Executive Vice President Financial Management Student Fiscal Services No 2 Credit Cards Finance & Budget Update freq? => DAILY <0> How used/pur Peggy Fitzwater NEBULA MS Access
ISFutures_Inventory- UW Bothell Network Provide infrastructure and teaching support UW Bothell Network
Metis (CSS File Server) 980 a.xls UW Tacoma Chancellor UW Bothell UW Bothell CSS No 5 Students, Teaching & Learning Production N/A Operations UW Bothell CSS services for the CSS program Operations 100 server Red Hat Linux N/A N/A
<0> What type of data? => Metrics on RSTs and
NRA documents used in dashboard <0>
Size/volume of data? => 2+ years, but small db
tbl-financial- <0> Data used for? => Operational Dashboard
Metrics used by Payroll Department to populate management-decision- <0> Update freq? => Every pay period (semi-
departmental operational dashboard. 516 support-inventor Executive Vice President Financial Management Payroll No 3 Access to Information, Reporting & Business Intelligence monthly) <0> How used/purpose? => Opera Heather Norberg-Stewart Nebula MS Access
Variety of scripts supporting a variety of
Misc UNIX Shell and PERL scripts OIM OIM Inventory 1 C&C/OIM C&C/OIM processes NA
Report of SOM ICR from
Richard Meeks - Mar ashep@u.washington.e
Misys Lab Info System 597 2006.xl Provost SOM SOM - Laboratory Medicine No 6 SOM Production Role: SO du
Report of SOM ICR from
Richard Meeks - Mar liseq@u.washington.ed
Moeller Lab 668 2006.xl Provost SOM SOM - Neurology No 6 SOM Production Role: SO u
tbl-2006-3-29- Computer Services, UW This is an open source CMS to support online
Moodle CMS 897 ISFuture_Inventory-a-xls UW Tacoma Chancellor UW Tacoma UW Tacoma No 2 Students, Teaching & Learning Development Tacoma CTLT, UW Tacoma teaching and learning. Patrick Pow 100 Open source
Report of SOM ICR from
Richard Meeks - Mar akukuk@u.washington.
Morsmordre Server (XServe) 605 2006.xl Provost SOM SOM - MEDEX Northwest No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar smoskow@u.washingt
moskowitz lab 701 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO on.edu
Informix 4GL /
Transportation Services unix unix Informix Informix 4GL Fat Client
Motor Pool Administration OIM OIM Inventory 1 C&C/OIM C&C/OIM Motor Pool management DB
OIM Inventory, systems ASP
Transportation Services unix, windows unix, windows Informix Visual Studio 6.0 Web
Motor Pool System 223 OIM inventory.xls Executive Vice President Facilities Services Transportation Services Yes 1 Facilities, Transportation & Space Production C&C C&C/OIM C&C/OIM Web based system to reserve cars. David Carr, Manager JavaScript
Informix 4GL /
Transportation Services unix unix Informix Informix 4GL Fat Client
Moving Services Administration OIM OIM Inventory 1 C&C/OIM C&C/OIM Moving Services management DB
Moving Web Request OIM OIM Inventory 1 C&C/OIM C&C/OIM Transportation Services Moving Services requests unix, windows unix, windows Informix ASP Visual Studio 6.0 Web
ISFutures_Inventory-
MSDNAA 1148 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 C&C Communications, Infrastructure & Middleware Production e-academy.com CS Lab CS Lab Provide MS software to CSE students Erik Lundberg lundberg@cs 800 ? ?
MSO is an administrative tracking system used
in support of a very complex credentialing
tbl-2006-3-29- UW Medicine IT Services, process for all SOM faculty, which includes all
MSO (Morrisey, Credentialing Database) 911 ISFuture_Inventory-a-xls Provost SOM Office of Medical Staff Appointments (OMSA) Yes 1 HRMIS SOM Production SOM IT OMSA of the clinical staff for UW Medicine. 80 Morrisey
OIM Inventory, FAMS C#, ASPX,
Inventory.xls, systems Chemical Inventory/MSDS - hazardous Windows Windows SQL Server Vis Studio.NET Web
Javascript
MyChem (Lab Safety System) 32, 1202 OIM inventory.xls Provost Health Sciences Environmental Health And Safety Yes 1 Facilities/Transportation and Space Production C&C C&C/OIM C&C/OIM EHS materials tracking
MyGradProgram - Graduate admissions and student Administration of graduate admissions, student
tracking 24 systems inventory.xls Provost Graduate School Graduate School Yes 1 Students, Teaching & Learning Production Department Grad School Grad School records, degrees, and graduate faculty.
Coordinates administration of graduate
education between the Graduate School and
academic units. Includes admissions, student
2006-4-2- records, degree requests, funding requests,
ISFutures_Inventory- doctoral committees, Graduate Faculty, student http://mgp.grad.washington. ASP.NET/C#,
MyGradProgram Department View 435 a.xls Provost Graduate School Graduate School Yes 1 Students, Teaching & Learning Production Graduate School Graduate School Graduate School assessment data, and targeted communi Julia Carlson 600 http://mgp.grad.washington.edu edu http://mgp.grad.washington.edu Windows Server
web server farm, clustered SQL servers SQL Server 2000 ASP/VBScript
tbl-2006-3-29- The MGP Student View provides personalized
MyGradProgram Student View 861 ISFuture_Inventory-a-xls Provost Graduate School Graduate School Yes 1 Students, Teaching & Learning Development Graduate School Graduate School Graduate School content as a dynamic channel in MyUW John Drew 10000 Windows Server
Database cluster, web farm SQL Server IIS, .NET C#
Allows undergraduates to apply to the
Sociology major online. Will eventually offer
tbl-2006-3-29- other information to students as they progress MS Access
MySoc 880 ISFuture_Inventory-a-xls Provost Arts and Sciences Sociology No 2 SDB Students, Teaching & Learning Production Sociology Sociology Sociology through the major. Michael Goldblatt 500 Server Windows 2000 Server SQL Server and Webpage
ITRSG needs Web portal presentation of many services and Oren Sreebny, Director
assessment business data elements; integrated with SDB Client Services and
MyUW 450 appendices.doc Vice President C&C C&C C&C: Architecture & System Engineering Yes 1 Access to Information, Reporting & Business Intelligence Production C&C C&C C&C and other admin systems. Learning Technologies
Web-based service providing student and
instructor schedules for MyUW portal dynamic
MyUW Dynamic Content OIM OIM Inventory 1 C&C/OIM C&C/OIM Registrar channels Windows Windows DMS II, SQL Server Jscript, ASP Vis Studio Web
ASP, Java
C&C Visual Studio 6.0 Web
MyUW.net (UWISP) OIM OIM Inventory 1 C&C/OIM C&C/OIM UW's ISP windows 2k3 windows 2k3 SQLServer 2000 (J++)
OIM Inventory, ITRSG
needs assessment Web based class management services for
MyUWClass class management 458 OIM appendices.doc Provost Student Affairs University Registrar Yes 1 Students, Teaching & Learning Production C&C C&C/OIM C&C/OIM Student Affairs, Enrollment Services-Registrar faculty Windows Windows DMS II, SQL Server Jscript, ASP VI Web
OIM Inventory, systems
MyUWEOClass 18 OIM inventory.xls Provost Educational Outreach Educational Outreach Yes 1 Communications, Infrastructure & Middleware Production C&C C&C/OIM C&C/OIM Vice Provost for Continuing Education Web-based course management Windows Windows SQL Server Jscript, ASP Vis Studio Web
2006-4-2- Web-based minority graduate student
ISFutures_Inventory- recruitment tool used by over 50 major http://www.grad.washington.edu/na http://www.grad.washington http://www.grad.washington.edu/namee
National and Wester Name Exchange 940 a.xls Provost Graduate School Graduate School Yes 1 Students, Teaching & Learning Production Graduate School Graduate School Graduate School universities in the U.S. John Drew 5000 meexch/national .edu/nameexch/national xch/national Windows Server
Web farm, SQL Database clusters SQL Server 2000 ASP
NCAA - ICA dbs 553 Intercollegiate Athletics Intercollegiate Athletics Intercollegiate Athletics No 2 Access to Information, Reporting & Business Intelligence
Report of SOM ICR from
Richard Meeks - Mar ccbishop@u.washingto
NCI Group Microsoft SQL 2000 Server 584 2006.xl Provost SOM SOM - Family Medicine No 6 SOM Production Role: SO n.edu
Enterprise-class domain, network, security,
backup, desktop support services.
The authoritative name servers for
'nebula2.washington.edu' are:
cork.nebula2.washington.edu 140.142.3.135
owl.nebula2.washington.edu 140.142.3.73
Nebula 1217 tmildon Vice President C&C C&C C&C Yes 1 Communications, Infrastructure & Middleware Production C&C C&C C&C nebula2.washington.edu: http://www.washington.edu/nebula/
Report of SOM ICR from
Richard Meeks - Mar
NEONATAL2, PTH_TPS_NT 702 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO tps@u.washington.edu
Report of SOM ICR from
Richard Meeks - Mar tpineda@u.washington.
Nephrology Backup server 654 2006.xl Provost SOM SOM - Medicine - Nephrology No 6 SOM Production Role: SO edu
(faculty)
http://www.cs.washington.edu/htbin-
post/admin/newhire.cgi/www/admin
/newhires
(staff)
http://www.cs.washington.edu/admi
n/NewStaffMemberChecklist.doc
Track all the things that need to be done by a (visitor)
ISFutures_Inventory- set of people when someone comes to or http://www.cs.washington.edu/htbin-
new-hire/separation checklists 1116 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 HR & Payroll Production CSE CS Lab CSE Business Office leaves the department Scott Rose rose@cs 10 post/admin/checklist.cgi/www/adm Unix storable
<0> What type of data? => Equip.-coded trans.
that don't belong on OASIS <0> Size/volume of
data? => 344 records (last full yrs.), 5-10 fields
tbl-financial- ea. <0> Data used for? => Reconciliation of
management-decision- OASIS to FAS <0> Update freq? => Weekly <0>
Non-Inventorials 494 support-inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory No 2 Finance & Budget How used/purpose? => Rec Mark Centuori Nebula G: drive MS Access
When SFS receives a NSF from the bank they
enter the check in the NSF dbs, create a JV to
Non-sufficient Funds Database 296 systems inventory.xls Executive Vice President Financial Management Student Fiscal Services No 2 Finance & Budget Production Department SFS SFS take money out of the department budget. Peggy Fitzwater
<0> What type of data? => NSF CHECKS AND
ELECTRONIC PAYMENTS <0> Size/volume of
data? => MEDIUM <0> Data used for? =>
MONITOR NSF PAYMENTS, CREATE JV'S TO
tbl-financial- CHARGE DEPT BUDGETS <0> Update freq?
management-decision- => 2-3 TIMES/WEEK <0> How used/purpose?
NSF RETURNED ITEMS 528 support-inventor Executive Vice President Financial Management Student Fiscal Services No 2 Finance & Budget => Peggy Fitzwater NEBULA MS Access
Report of SOM ICR from
Richard Meeks - Mar gstry@u.washington.ed
NWLRL 651 2006.xl Provost SOM SOM - Medicine - Metabolism & Endocrinology No 6 SOM Production Role: SO u
Management of fixed assets, State approved
asset database <0> Size/volume of data? =>
OIM Inventory, tbl- 62,984 records to date, 67+ fields each <0>
financial-management- Data used for? => Inventories; space survey;
decision-support- indirect cost survey, more <0> Update freq? => Informix 4GL,
OASIS (Online Assets Information System) 499 OIM inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory Yes 1 Facilities, Transportation & Space Production C&C C&C/OIM C&C/OIM Equipment Inventory Office Daily <0> How used/purpose? => Stat Gustafson/Benson unix unix Informix Perl, ace Informix 4GL Web
D:\Docstoc\Working\pdf\2c08cb85-d9bf-4007-a741-bfedcadde02b.xls
SOM
Who supports the system (who provides modifications, corrects problems, Who is the business owner (dept responsible for managing the day to day
System-name ID Tag source-file Organization College, School or Office Division Provides campus-wide service? TIER Shadow Sys? System-Type Status Developed-by develops new features?) Who-Operates-System operation of the system) description-function Contact-Person contact-person-email number-of-users System Documentation Location Data Dictionary Location How to request access to the system Vendor-Name Hardware Platform Operating System Database software Language Development Environment User Interface
<0> What type of data? => Tracks current and
deleted OASIS users <0> Size/volume of data?
=> 867 records to date, 7 fields each <0> Data
tbl-financial- used for? => Track current and deleted users,
management-decision- contact users <0> Update freq? => Monthly <0>
OASIS Users 484 support-inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory Yes 1 Communications, Infrastructure & Middleware How used/purpose? => Allow Heidi Gustafson Nebula G: drive MS Access
Report of SOM ICR from
Richard Meeks - Mar alarson@u.washington.
OBGYN-A 676 2006.xl Provost SOM SOM - Obstetrics & Gynecology No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar
OBGYN-PL 677 2006.xl Provost SOM SOM - Obstetrics & Gynecology No 6 SOM Production Role: SO ytcs@u.washington.edu
Used to scan loan documents. Imagesource
being replaced by document imaging system will replace ODIN in
ODIN document imaging system 297 systems inventory.xls Executive Vice President Financial Management Student Fiscal Services No 2 Imagesource Finance & Budget Production C&C C&C SFS 2006 local support of analytics and student
Provide Peggy Fitzwater
relationship management using UWSDB
Office of Minority Affairs ad hoc databases 474 tmildon Provost Office of Minority Affairs Office of Minority Affairs No 2 SDB Students, Teaching & Learning Production Office of Minority Affairs Office of Minority Affairs Office of Minority Affairs queries
ITRSG needs
assessment
OIS Instructor Database 456 appendices.doc Provost Planning & Budgeting Office of Institutional Studies No 4 Production
Online Accident Reporting Systems (OARS) 33 systems inventory.xls Provost Health Sciences Environmental Health And Safety Yes 1 HR & Payroll Production Department EHS EHS
Online App and Review 125 ENG systems inventory.xls Provost Engineering Engineering No 2 SDB Students, Teaching & Learning
Online Emergency Management Tool 174 systems inventory.xls Executive Vice President Business Services Business Services: Emergency Management Yes 1 Facilities, Transportation & Space Development Vendor C&C BS/EM Web EOC will be in production later this year…
ISFutures_Inventory- Online supplemental application for graduate https://norfolk.cs.washington.edu/ht
online grad application 1125 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 SDB HR & Payroll Production CSE CS Lab CSE Advising study Dan Boren boren@cs 1000/year bin-php/app/grad/index.php Unix postgresql
Provide online access to current and past
ISFutures_Inventory- Distance Learning lectures, colloquia and http://www.cs.washington.edu/educ
On-Line Multimedia Service 1109 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Students, Teaching & Learning Production CSE CS Lab CS Lab research talks. Fred Videon fred@cs Thousands ation/dl/course_index.html Windows, Unix Web/Windows Media Server
We are in the process of designing three online
course submission forms, including new
course application, course change application
tbl-2006-3-29- Computer Services, UW and DL course application for UW Tacoma
Online New Course Submission Form 902 ISFuture_Inventory-a-xls UW Tacoma Chancellor UW Tacoma UW Tacoma No 2 Curriculum Students, Teaching & Learning Development Computer Services Tacoma Curriculum Committee, UW Tacoma Curriculum Committee. 130
ISFutures_Inventory- Online supplemental application for graduate https://pmp.cs.washington.edu/htbi
online PMP application 1126 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 SDB HR & Payroll Production CSE CS Lab CSE Advising study-- PMP program Dan Boren boren@cs 50/quarter n-php/app/grad/index.php Unix postgresql
ISFutures_Inventory- Student directories, with opt-in for dept/public http://norfolk.cs.washington.edu/htbi
online student directories 1132 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 UWDirectory HR & Payroll Production CSE CS Lab CS Lab access Dan Boren boren@cs 600 n-php/cseoffice/ugrad/ Unix postgresql
Online Time Reporting System 269 systems inventory.xls Executive Vice President Financial Management Payroll Yes 1 HR & Payroll Production C&C C&C Payroll Report Exception and Positive Time Reporting Ginny Montgomery hundreds Server
ITRSG needs Undergraduate
Online Undergaduate Admissions Application assessment Admissions, University
(CollegeNET) 446 appendices.doc Provost Student Affairs University Registrar Yes 1 Students, Teaching & Learning Production vendor Registrar Undergraduate Admissions, University Registrar Web Application for undergraduate applicants CollegeNET
Integrated library system that provides catalog
access, order/acquisitions, bibliographic Innovative
OPAC Libraries Catalog System 106 systems inventory.xls Provost University Libraries Library- IT Services Yes 1 Students, Teaching & Learning Production Innovative Interfaces Inc. C&C UW Libraries control, and circulation functions. Bill Jordan 70000 http://catalog.lib.washington.edu Interfaces server AIX proprietary db and application
Payroll entry
Web front end to HEPPS.
OIM Inventory, tbl-2006-3- Web based application for campus user to
29-ISFuture_Inventory-a- update Payroll information that resides in
OPUS (Online Payroll Update System) 270 OIM xls Executive Vice President Financial Management Payroll Yes 1 HR & Payroll Production C&C C&C/OIM C&C/OIM Payroll HEPPS. Ginny Montgomery 1000 NT NT DMS II/SQL ASP/DFDS Visual Studio 6.0 Web
UW campus calendaring service, currently
integrated with Nebula service. Expaning to
Oracle Calendar 205 systems inventory.xls Vice President C&C C&C C&C: Infrastructure Yes 1 Communications, Infrastructure & Middleware Production C&C C&C C&C non-Nebula offices as well.
ORCA 52 systems inventory.xls Provost School of Medicine Medical Affairs Yes 1 Finance & Budget Development Vendor MCIS MCIS
Report of SOM ICR from
Richard Meeks - Mar burdett@u.washington.
Orthopaedics Servers 680 2006.xl Provost SOM SOM - Orthopaedics and Sports Medicine No 6 SOM Production Role: SO edu
Report of SOM ICR from
Richard Meeks - Mar kkarb@u.washington.e
Orthopaedics Workstations 681 2006.xl
2006-4-2- Provost SOM SOM - Orthopaedics and Sports Medicine No 6 SOM Production Role: SO du
ISFutures_Inventory- UW Bothell Network Provides monitoring and reporting for servers UW Bothell Network
Orwell (Nagios) 973 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Information Systems No 5 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Information Systems and network performance Operations 5 server Red Hat Linux MySQL N/A
Report of SOM ICR from
Richard Meeks - Mar rooster@u.washington.
Otolarngology faculty/staff 684 2006.xl Provost SOM SOM - Otolaryngology No 6 SOM Production Role: SO edu
ISFutures_Inventory- Departmental outreach, newsletter recipients,
Outreach DB 1151 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Access to Information, Reporting & Business Intelligence Production CSE CSE External Relations CSE External Relations etc. Scott Dakins sjdakins@cs 1 Windows MS Access
Over award Database 298 systems inventory.xls Executive Vice President Financial Management Student Fiscal Services No 2 Finance & Budget Production Department SFS SFS To track repayment of over awards. Peggy Fitzwater
<0> What type of data? => RECORDS OF
FINANCIAL AWARD
OVERAWARDS/OVERPAYMENTS <0>
Size/volume of data? => SMALL <0> Data used
for? => MONITOR OVER
tbl-financial- AWARD/OVERPAYMENT RECEIVABLES <0>
management-decision- Update freq? => WEEKLY <0> How
OVERAWARDS 532 support-inventor Executive Vice President Financial Management Student Fiscal Services No 2 Students, Teaching & Learning used/purpose? => Frannie Gladney NEBULA MS Access
<0> What type of data? => Detail record of
payroll overpayments by UW employees <0>
Size/volume of data? => 1 year of data, <1,000
tbl-financial- records <0> Data used for? => Collection of
management-decision- overpayment, records of ops sent to collections,
Overpayment data base 518 support-inventor Executive Vice President Financial Management Payroll No 2 HR & Payroll statistics of occurrences, rec Heather Norberg-Stewart Nebula MS Access
ISFutures_Inventory- Tracking the repayment process of
Overpayment Database 1194 template_0421.xls Executive Vice President Financial Management Payroll No 2 HR & Payroll Production Payroll Payroll Payroll Overpayments made employees Heather Norberg Stewart 3 Nebula server Windows MS Access Access
The authoritative name servers for
'ovid.u.washington.edu' are:
dnsload1.cac.washington.edu 140.142.1.21
dnsload2.cac.washington.edu 140.142.2.21
ovid.u.washington.edu:
SOA (Start of Authority):
origin = dnsload1.cac.washington.edu
Ovid: Web Development Environment for Homer 1222 tmildon Vice President C&C C&C C&C: Infrastructure No 5 Communications, Infrastructure & Middleware m
Leave tracking system that departmental
OIM Inventory, tbl-2006-3- timekeepers use to track leave accrual and use
29-ISFuture_Inventory-a- for classified and professional staff. Online 220 ASP/J++
OWLS (Online Work/Leave System) 261 OIM xls Executive Vice President Human Resources Human Resources Yes 1 HR & Payroll Production C&C C&C/OIM C&C/OIM HR form. NT NT SQL Server Com/DFDS Visual Studio 6.0 Web
Report of SOM ICR from
Richard Meeks - Mar pricer@u.washington.e
P & O Curriculum Macs 722 2006.xl Provost SOM SOM - Rehabilitation Medicine No 6 SOM Production Role: SO du
P3 1212 FAMS Inventory.xls Executive Vice President Capital Projects Office Capital Projects No 4 Communications, Infrastructure & Middleware vendor Scheduling
Monthly, billing for Pager equipment and usage
C&C Business & Finance and Customer Care
Pager billing OIM OIM Inventory
2006-4-2- 1 C&C/OIM C&C/OIM (must reconcile with outside vendor's invoice) unix unix Informix Informix 4GL vi-Informix 4GL / CVS
ISFutures_Inventory- UW Bothell Network Public Safety and physical plant databases for UW Bothell Network
Pan (IRIMS) 954 a.xls UW Tacoma Chancellor UW Bothell UW Bothell Public Safety No 2 Communications, Infrastructure & Middleware Production N/A Operations UW Bothell Public Safety logging and dispatch Operations 10 server Windows Server SQL Server N/A
Instructor posts course papers to be read by
ISFutures_Inventory- class; students submit online reviews and read http://norfolk.cs.washington.edu/htbi
Paper Review 1111 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Students, Teaching & Learning Production CSE CS Lab CS Lab those of their classmates Dan Boren boren@cs 20 n-php/faculty/paperset/index.php Unix postgresql
Web-based service that allows anonymous
Parents OIM OIM Inventory 1 C&C/OIM C&C/OIM Student Fiscal Services users to pay tuition by credit card. Windows Windows DMS II, SQL Server ASP, Jscript Vis Studio Web
Parking Annual Review OIM OIM Inventory 1 C&C/OIM C&C/OIM Transportation Services Parking permit annual review process unix, windows unix, windows Informix ASP Visual Studio 6.0 Web
Parking Services system. Integrator of
separate systems. Issues extended permits Informix 4GL /
Transportation Services (year, quarter, etc.), Data from gatehouse unix unix Informix Informix 4GL Fat Client
DB
OIM Inventory, systems system, violation system and motor pool Rick Anglin, Software
Parking System 224 OIM inventory.xls Executive Vice President Facilities Services Transportation Services Yes 1 Facilities, Transportation & Space Production C&C, Vendor C&C/OIM C&C/OIM system automatically interfaces to Wheels. Engineer I, C&C
Packaged software (also used by UCLA).
Operates gate arms, permits, and revenue Bob Johnson, Parking
Parking System McGann Gatehouse System 225 systems inventory.xls Executive Vice President Facilities Services Transportation Services Yes 1 Facilities, Transportation & Space collected at gate. management, Mobile
Parking violations Technology Officer
devices used to issue parking violations. Data Informix 4GL /
OIM Inventory, systems UW PD is then uploaded to main system records Rick Anglin, Software unix unix Informix Informix 4GL Fat Client
DB
Parking Violation System 226 OIM inventory.xls Executive Vice President Facilities Services Transportation Services Yes 1 Facilities, Transportation & Space Production C&C C&C/OIM C&C/OIM database. Engineer I, C&C
Core purchasing and accounts payable
OIM Inventory, tbl-2006-3- system. An online requisition entry and inquiry
29-ISFuture_Inventory-a- Purchasing & Stores; Accounts Payable / Accounting Operations; UW system, for ordering from vendors off campus, http://www.washington.edu/admin/a http://www.washington.edu/admin/admi
PAS 178 OIM xls Executive Vice President Business Services Business Services: Purchasing & Stores Yes 1 Finance & Budget Production C&C Administrative Systems C&C/OIM C&C/OIM Departments reimbursements, and order/payment inquiries. dminsystems/PAS/ nsystems/forms/access.pdf homegrown Unisys MCP Unisys MCP DMS II COBOL SURE green screen
External inbound interfaces for Libraries, Law
PAS (AP Interfaces) OIM OIM Inventory 1 C&C/OIM C&C/OIM Financial Management (Accounts Payable) Lib, HFS,MCS, VPS, Stores, Procard Unisys MCP; Unix Unisys MCP; Unix DMS II COBOL, C SURE/ CVS green screen
OIM Inventory, systems COBOL, C,
PAS - Document Logging 248 OIM inventory.xls Executive Vice President Financial Management Financial Services: Payables No 1 Finance & Budget Production C&C C&C/OIM C&C/OIM Financial Management (Accounts Payable) PAS - logging of vendor invoices Unisys MCP; Unix Unisys MCP; Unix DMS II tcl/tk SURE/ CVS Fat client
PAS - PASTRANS OIM OIM Inventory 1 C&C/OIM C&C/OIM Financial Management (Accounts Payable) Inbound interface Unisys MCP; Unix Unisys MCP; Unix DMS II COBOL SURE NA
COBOL, perl,
PAS - Positive Pay OIM OIM Inventory 1 1 C&C/OIM C&C/OIM Financial Management (Accounts Payable) Outbound interface to Bank of America Unisys MCP; Unix Unisys MCP; Unix DMS II pgp SURE green screen
Reconciliation
via JPMC
website;
Interface Load
processing via
PAS green
PAS - Procurement Card/Travel Card OIM OIM Inventory 1 C&C/OIM C&C/OIM Financial Management (ProCurement Card) Inbound interface (JPMorgan Chase) Unisys MCP Unisys MCP DMS II COBOL SURE screens
<0> What type of data? => Selected PAS fields
on Paid invoices from 9/2001 to present <0>
Size/volume of data? => 960MB <0> Data used
tbl-financial- for? => Dashboard, Public Records Requests,
management-decision- Data Mining, Outreach, Ad-Hoc <0> Update
PAS info db (Tom's DB of PAS) 479 support-inventor Executive Vice President Financial Management Financial Services No 2 Access to Information, Reporting & Business Intelligence freq? => monthly <0> How used/purpos Tom Phillips Network MS Access
Report of SOM ICR from
Richard Meeks - Mar mdmiddle@u.washingt
Pathology.pathology.washington.edu domain 689 2006.xl Provost SOM SOM - Pathology No 6 SOM Production Role: SO on.edu
runs on mainframe that is operated by C&C.
Patient Billing System 57 systems inventory.xls Provost School of Medicine Medical Affairs No 6 Finance & Budget Production MCIS MCIS Application developers reside at MCIS
<0> What type of data? => Payment (Manual
Pmts) last 6 months <0> Size/volume of data?
=> 36 MB <0> Data used for? => Auditing Dept,
tbl-financial- Our Own Internal Processes <0> Update freq?
management-decision- => Daily <0> How used/purpose? => . Data
Payman 483 support-inventor Executive Vice President Financial Management Financial Services No 2 Finance & Budget source: Manual Entry Donna Andreason Network MS Access
PCHEES db 551 Provost Student Affairs University Registrar No 4 Students, Teaching & Learning
Report of SOM ICR from
Richard Meeks - Mar jwright@u.washington.
Pediatric Residency Web Site 703 2006.xl Provost SOM SOM - Pediatrics No 6 SOM Production Role: SO edu
PEPP 53 systems inventory.xls Provost School of Medicine Medical Affairs No 6 Finance & Budget Development Vendor MCIS MCIS
Report of SOM ICR from
Richard Meeks - Mar rooster@u.washington.
Perkel Lab 685 2006.xl Provost SOM SOM - Otolaryngology No 6 SOM Production Role: SO edu
PERMS OIM OIM Inventory 1 C&C/OIM C&C/OIM Payroll Post Entry Review Messages NT NT SQL Server ASP.NET Visual Studio .NET NA
N/A -- Stores student's data from submitted
tbl-2006-3-29- Data Management/Office student's petitions for processing and ruling on
Petitions (Hardship peitions) 866 ISFuture_Inventory-a-xls Provost Student Affairs University Registrar No 3 Students, Teaching & Learning Production Data Management/Registrar of the Registrar Registrar petitions. Colin McDonell 4 Server Windows MS Access MS Access
Petro Vend 227 systems inventory.xls Executive Vice President Facilities Services Transportation Services No 2 Facilities, Transportation & Space Production Vendor Motor pool Motor pool Tracks gasoline David Carr, Manager
<0> What type of data? => Petty Cash
Transactions Records for Last 3 Years <0>
Size/volume of data? => 10.9 MB <0> Data
used for? => Dashboard, Auditing Dept, Our
tbl-financial- Own Internal Processes <0> Update freq? =>
management-decision- Daily <0> How used/purpose? => . Data Tom Phillips/Cathy
Petty Cash 480 support-inventor Executive Vice President Financial Management Financial Services No 2 Finance & Budget source: Ma Sleipnes Network MS Access
Report of SOM ICR from
Richard Meeks - Mar crysbis@u.washington.
Pharmacology - Admin Workstations 710 2006.xl Provost SOM SOM - Pharmacology No 6 SOM Production Role: SO edu
tbl-2006-3-29- Tracks applicants to the Philosophy Graduate
Philosophy Graduate Applicant Database 856 ISFuture_Inventory-a-xls Provost Arts and Sciences Philosophy No 3 SDB Students, Teaching & Learning Other Developed by Bob Blum Program Barbara Mack 1
<0> What type of data? => Annual log of
inventory activity <0> Size/volume of data? =>
962 records (2005), 13 fields each <0> Data
used for? => Compliance tracking tool <0>
tbl-financial- Update freq? => Weekly <0> How
management-decision- used/purpose? => Track department
Physical Inventories 495 support-inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory Yes 1 Finance & Budget compliance. Data Heidi Gustafson Nebula G: drive MS Access
ISFutures_Inventory- http://norfolk.cs.washington.edu/htbi
Physical inventory system 1140 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 OASIS Facilities, Space & Equipment Production CSE CS Lab CS Lab Manage biannual inventory of capital equipment Scott Rose rose@cs 2 n-post/lab/assets.cgi Unix postgresql
System serves a variety of administrative,
teaching/learning, and research purposes.
Provides
data for departmental web page.
Also runs a postgresql backend for a web
based faculty
Physics departmental database 560 Provost Arts and Sciences Physics No 2 Finance & Budget Production application procedure. SQL Server Enterprise
Report of SOM ICR from
Richard Meeks - Mar crysbis@u.washington.
PI Faculty - Research Computers 711 2006.xl Provost SOM SOM - Pharmacology No 6 SOM Production Role: SO edu
Pine 206 systems inventory.xls
2006-4-2- Vice President C&C C&C C&C: Infrastructure Yes 1 Communications, Infrastructure & Middleware Production C&C C&C C&C http://www.washington.edu/
ISFutures_Inventory- Data for policy analysis: Fiscal, Student, http://www.washington.edu/admin/p admin/pb/home/opb- http://www.washington.edu/admin/pb/h
Planning & Budgeting Database 931 a.xls Provost Planning & Budgeting Office of Institutional Studies Yes 1 Access to Information, Reporting & Business Intelligence Production OIS OIS OIS-P&B Teaching, Space, Staff, Personnel, B&E Phil Hoffman 100 b/home/opb-db.htm db.htm ome/opb-db.htm server Windows Oracle MS Access
This system is a combination database and
data warehouse with information about space
management, faculty workforce profile,
2006-4-2- institutional studies data as well as data that is http://www.washington.edu/
ISFutures_Inventory- extracted, transformed and loaded directly from http://www.washington.edu/admin/p admin/pb/home/opb-
Planning and Budgeting Data Warehouse 971 a.xls Provost Planning & Budgeting Planning & Budgeting Yes 1 Finance & Budget Production Planning and Budgeting Planning and Budgeting Planning and Budgeting HEPPS. Robert Pearson 200 b/home/opb-glossary.htm glossary.htm
ISFutures_Inventory- Management and tracking of student and http://norfolk.cs.washington.edu/htbi
pmp advising management 1129 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 SDB HR & Payroll Production CSE CS Lab CSE Advising applicant data by academic advisors Dan Boren boren@cs 1 n-php/advising/pmp/index.php Unix postgresql
ISFutures_Inventory- Track colloquia viewing and reports by PMP https://www4.cs.washington.edu/ssl-
PMP Colloquia Report tracking 1110 ENG CSE-20060407.xls Provost Engineering Computer Science and Engineering No 2 Students, Teaching & Learning Production CSE CS Lab CSE Advising Office students for credit. Fred Videon fred@cs php/colloq_reporting/summary.php
about 80 students/qtr Unix postgresql
Report of SOM ICR from
Richard Meeks - Mar liseq@u.washington.ed
Poolos Lab 674 2006.xl Provost SOM SOM - Neurology No 6 SOM Production Role: SO u
Used to facilitate placement of graduate
Preceptor Clinical Site DB 152 systems inventory.xls Provost Nursing School Nursing School No 2 Clinical students in clinical sites/track
<0> What type of data? => RECORDS OF
PRIMARY CARE LOANS TO STUDENTS <0>
Size/volume of data? => SMA <0> Data used
tbl-financial- for? => MONITOR LOAN DOCUMENTS <0>
management-decision- Update freq? => ANNUAL <0> How
PRIMARY CARE LOANS 533 support-inventor Executive Vice President Financial Management Student Fiscal Services No 2 Students, Teaching & Learning used/purpose? => Pam Luther ACCESS
<0> What type of data? => Tracks inventorial
Procard exceptions <0> Size/volume of data?
=> 168 records to date, 19 fields each <0> Data
tbl-financial- used for? => Track/locate department
management-decision- complaince on Procard exceptions <0> Update
ProCard 486 support-inventor Executive Vice President Financial Management Financial Accounting: Equipment Inventory No 2 Finance & Budget freq? => Weekly <0> How used/purpose? Centuori/Gustafson Nebula G: drive MS Access
Tracks Retro Salary Transfers (RSTs), reasons
for RSTs, non-resident alien I9 forms and
generates letters when incorrect, used to track