Access Database Application Software by aux33989

VIEWS: 0 PAGES: 18

More Info
									                    DEFINITIONS for INVENTORY of DEPARTMENTAL APPLICATIONS
                                        (purchased & in-house developed)
Criteria to be on the list:  If the system is out-of-service the back-log of data will be entered into the
                             system when service is regained because it related to business resumption or
                             is viewed as mission critical.

                                The application requires IT skills/resources to support it.

   If either of these statements hold true the application/system should be put on the inventory list. We also
            agreed that purchased as-well-as in-house developed applications should be considered.

Business Area                   Describes the department that is responsible for supporting the
                                application/system. Example: Accounting

Name of the System              Acronym/title    Example: FAS (Fixed Asset System)

Brief Description               In 50 words or less describe the function/service the system provides.

Data                            Is the app dependent on information from other sources (ie. routine download
                                of name/address info from a mainframe file, import a file of checks cleared
                                from the bank, etc.) If yes, describe.

Underlying Software             What language is the software written in?

Hardware Platform               What OS does the software run on?

Workstation/Server              Who administers and supports the server the software runs on? (Department
Administration                  Name, MI, PUCC, etc.)

Production Date                 Date the application/system was originally put in production. If it's not known
                                when the app/system was put into production indicate "prior to 19xx".

Software Cost                   Describes the total cost of the application including any hardware costs
                                incurred. Include the end user effort that was expended in design discussions,
                                Q/A, testing, conversion, etc.
                                If developed in house, try to break down the number of hours it took to develop
                                the system. Multiply the hours by the rate for each person (developer, end
                                user, advisory/steering group, etc.) If you're guessing, use an "Est." in front of
                                the figure.
                                Leave blank if you have no idea of the cost (ex. application was developed
                                over 10 years ago and no info available as to development cost)

# FTE to Support System         This would include the total fte to administer, maintain and train.

Accessibility                   Is the application used by multiple departments?

Approx. Number of Users         Your best guess.

Anticipated Frequency of
Upgrades                        For Example: Every 6 Months

This Document Last              The date the inventory for this application is updated. Thus the first time you
Updated                         create the inventory for the application, indicate the current date. If you update
                                the inventory 3 months from now, for the 3rd application listed, then for that
                                inventory item you would change the date to the updated date.


F:\USERS\ACCOUNT\DATA\SYSTEMS\FINMGR\DCM\DPTAPINV\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls                  11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory   2 of 18                  11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Picture Taker 5

  Brief Description                                PictureTaker is used to thoroughly and safely remove or reinstall software.

  Data                                             No

  Underlying Software                              Unknown

  Hardware Platform                                Any Windows OS

  Workstation/Server                               MI
  Administration

  Production Date                                  prior to 1999 for 1.52 and Spring 2000 for 3.0

  Software Cost                                    EST - $6200.00 to $7200.00
                                                   Note: ITaP has taken over licensing of this software

  # FTE to Support System

  Accessibility                                    No

  Approx. Number of Users                          5

  Anticipated Frequency of                         Annually
  Upgrades

  This Document Last                               9/21/2001
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory      3 of 18                                          11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Ghost 8.0

  Brief Description                                From the Symantec Ghost console, zone staff can remotely clone multiple
                                                   workstations and then quickly configure critical workstation data such as
                                                   TCP/IP settings and machine, workgroup, and domain names.

  Data                                             HR/FIN Zone

  Underlying Software                              DOS

  Hardware Platform                                Any Windows OS

  Workstation/Server                               HR/FIN Zone
  Administration

  Production Date                                  Prior to 1999

  Software Cost                                    EST - $4,700 to $5,700 Maintainance cost is $1.45/workstation/year

  # FTE to Support System

  Accessibility                                    No

  Approx. Number of Users                          5

  Anticipated Frequency of                         Annually
  Upgrades

  This Document Last                               1/5/2007
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory      4 of 18                                          11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Zone Database

  Brief Description                                It is used to track software licenses and to push software to users.

  Data                                             Yes - routine downloads are performed each time information is undated in the
                                                   database. This software is used to run Brio queries for computer rollouts, etc.


  Underlying Software                              Visual Basics 6.0

  Hardware Platform                                Windows NT/2000/XP

  Workstation/Server                               HR/FIN Zone
  Administration

  Production Date                                  Jul-00

  Software Cost                                    EST - $18,000 to $25,000

  # FTE to Support System

  Accessibility                                    No

  Approx. Number of Users                          6

  Anticipated Frequency of                         This is updated several times per day based on updates to the database.
  Upgrades

  This Document Last                               9/21/2001
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory      5 of 18                                            11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Business Forms Used at Purdue University

  Brief Description                                Website displaying Business Forms that are used at Purdue University.
                                                   http://wwwdev2.itap.purdue.edu/tirwin/Business_Forms/ (Test Site)

  Data                                             Information is stored in an Access database and uses ColdFusion to display
                                                   the results on the Website.

  Underlying Software                              HTML, PDF, Excel, Word, Access, ColdFusion

  Hardware Platform                                ColdFusion Web Server

  Workstation/Server                               ITaP Web Services
  Administration

  Production Date                                  Testing began 12/11/03. Not is production yet.

  Software Cost

  # FTE to Support System

  Accessibility                                    Used by many departments in Business Services and other Administrative
                                                   departments

  Approx. Number of Users                          Many

  Anticipated Frequency of
  Upgrades

  This Document Last                               12/29/2003
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory      6 of 18                                       11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Business Services Index

  Brief Description                                Website displaying a listing of web pages within Business Services.
                                                   http://wwwdev2.itap.purdue.edu/tirwin/Business_Index/ (Test Site)

  Data                                             Information is stored in an Access database and uses ColdFusion to display
                                                   the results on the Website.

  Underlying Software                              HTML, PDF, Excel, Word, Access, ColdFusion

  Hardware Platform                                ColdFusion Web Server

  Workstation/Server                               ITaP Web Services
  Administration

  Production Date                                  Testing began 12/17/03. Not is production yet.

  Software Cost

  # FTE to Support System

  Accessibility                                    Used by many departments in Business Services and other Administrative
                                                   departments

  Approx. Number of Users                          Many

  Anticipated Frequency of
  Upgrades

  This Document Last                               12/29/2003
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory      7 of 18                                           11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Business at Purdue (In development)

  Brief Description                                A university web site that contains information on business related services.


  Data                                             Information used in Business at Purdue is details on policies, procedures,
                                                   processes and forms.

  Underlying Software                              Not known

  Hardware Platform                                Not known

  Workstation/Server                               Not known
  Administration

  Production Date                                  Target Winter 2004

  Software Cost                                    Not known

  # FTE to Support System                          Not known

  Accessibility                                    All staff at purdue.

  Approx. Number of Users                          Many

  Anticipated Frequency of                         Quarterly updates on content, annual updates on hardware or software.
  Upgrades

  This Document Last                               2/1/2004
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory         8 of 18                                        11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Legislative Expenditure Report

  Brief Description                                Expenditure III parts A and B seperating Executive Admin into Executive
                                                   Admin and Other Admin just like the IPEDS reports.

  Data                                             Information is stored in S:\bs.\...\Operations\Recurring Jobs\Legislative
                                                   Request\2001\
                                                   LegIII_JMB_Revision_Nov2002_ModDec18.sas

  Underlying Software                              SAS

  Hardware Platform                                Mainframe

  Workstation/Server                               None
  Administration

  Production Date                                  Fall each year

  Software Cost

  # FTE to Support System

  Accessibility                                    Report generated and sent to the state house.

  Approx. Number of Users

  Anticipated Frequency of                         Annual
  Upgrades

  This Document Last                               2/1/2004
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory       9 of 18                                           11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Resource Assignment Database (To begin in spring 2004)

  Brief Description                                Ability to track staff and their FTE commitment to projects.

  Data                                             Will track staff, projects and their time commitment.

  Underlying Software                              Not known

  Hardware Platform                                Not known

  Workstation/Server                               Not known
  Administration

  Production Date                                  Not known

  Software Cost

  # FTE to Support System

  Accessibility                                    Will be used by the Business Services Directors

  Approx. Number of Users                          10

  Anticipated Frequency of
  Upgrades

  This Document Last                               2/1/2004
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory      10 of 18                                   11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Westwood New Hire Database (in development)

  Brief Description                                A web/access database application to track, schedule, invite and monitor
                                                   RSVP on new hire staff for the annual visit to Westwood.

  Data                                             The annual load each year will come from the HR data.

  Underlying Software                              Not known

  Hardware Platform                                ColdFusion Web Server

  Workstation/Server                               ITaP Web Services
  Administration

  Production Date                                  Summer 2004

  Software Cost                                    Not known

  # FTE to Support System

  Accessibility                                    Used by the President's office and the areas representative.

  Approx. Number of Users                          30

  Anticipated Frequency of                         Annually.
  Upgrades

  This Document Last                               2/1/2004
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory     11 of 18                                         11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Form 100 and Production issues

  Brief Description                                Access database that tracks BS request for services and production issues.


  Data                                             Contains all Request for Services that go to ITaP and collects the production
                                                   issues that arise.

  Underlying Software                              Access database

  Hardware Platform                                 Workstations

  Workstation/Server                               Zone
  Administration

  Production Date                                  3-Jan

  Software Cost                                    Not known

  # FTE to Support System                          minimal

  Accessibility                                    Used by BS areas to complete Request for Services and document production
                                                   system issues.

  Approx. Number of Users                          20

  Anticipated Frequency of                         annually.
  Upgrades

  This Document Last                               2/1/2004
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory     12 of 18                                          11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Year End Balance Carry Forward Web Application

  Brief Description                                Website that is used at budget time to track the balance carry forward.

  Data                                             Data comes from the budget system.

  Underlying Software                              SAS, HTML

  Hardware Platform                                Web Server

  Workstation/Server                               ITaP Web Services
  Administration

  Production Date                                  Spring 2000?

  Software Cost                                    Not known

  # FTE to Support System                          Not known

  Accessibility                                    Used by business office during budget forward.

  Approx. Number of Users                          60

  Anticipated Frequency of                         Annually
  Upgrades

  This Document Last                               2/1/2004
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory     13 of 18                                          11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Active Directory Admin Pack

  Brief Description                                Allows administration of 2000/2003 Active Directory

  Data                                             User and computer attributes, password resets, etc.

  Underlying Software                              Unknown

  Hardware Platform                                Windows 2000/XP compatible

  Workstation/Server                               Platform Services
  Administration

  Production Date                                  Aug-04

  Software Cost                                    Free

  # FTE to Support System                          Not known

  Accessibility                                    No

  Approx. Number of Users                          5

  Anticipated Frequency of                         At Network OS upgrade
  Upgrades

  This Document Last                               1/19/2006
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory      14 of 18                          11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Hyena 5.7

  Brief Description                                Allows management of AD Group policies

  Data                                             Remote workstation services, attributes, etc.

  Underlying Software                              Unknown

  Hardware Platform                                Windows 2000/XP compatible

  Workstation/Server                               No
  Administration

  Production Date                                  2000

  Software Cost                                    $85 per upgrade

  # FTE to Support System                          Not known

  Accessibility                                    No

  Approx. Number of Users                          5

  Anticipated Frequency of                         Annually
  Upgrades

  This Document Last                               12/6/2004
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory     15 of 18                     11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Group Policy Administration Tools

  Brief Description                                Software that allows you to remotly manage services, the registry, local user
                                                   accounts,etc.

  Data                                             Business Services Group Policies for Workstation behavior, settings, and
                                                   security

  Underlying Software                              Unknown

  Hardware Platform                                Windows XP

  Workstation/Server                               Platform Services
  Administration

  Production Date                                  4-Aug

  Software Cost                                    Free

  # FTE to Support System                          Not known

  Accessibility                                    No

  Approx. Number of Users                          5

  Anticipated Frequency of                         At network OS upgrade
  Upgrades

  This Document Last                               1/19/2006
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory      16 of 18                                         11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               Windows Server Update Services

  Brief Description                                Microsoft® Windows Server® Update Services 3.0 (WSUS 3.0) enables
                                                   information technology administrators to deploy the latest Microsoft product
                                                   updates to computers running Microsoft Windows Server 2003, Microsoft
                                                   Windows® XP with Service Pack 1, and Windows 2000 with Service Pack 4
                                                   operating systems. By using WSUS, administrators can fully manage the
                                                   distribution of updates that are released through Microsoft Update to
                                                   computers in their network.

  Data                                             Data is received from Microsoft Corporation

  Underlying Software                              Unknown

  Hardware Platform                                Windows Server 2003

  Workstation/Server                               HR/Financial Zone
  Administration

  Production Date                                  Oct-06

  Software Cost                                    Free

  # FTE to Support System                          Not known

  Accessibility                                    No

  Approx. Number of Users                          5

  Anticipated Frequency of                         Annually
  Upgrades

  This Document Last                               1/5/2006
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory      17 of 18                                        11/18/2010
                                                 Departmental Application Inventory




                                                   INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                          (purchased & in-house developed)
                                                         Business Services Computing

  Business Area                                    BSC

  Name of the System                               AIS Acronyms

  Brief Description                                The AIS Acronyms web site is a listing of all Purdue University Acronyms and
                                                   their meanings?

  Data                                             Data is contributed by Business Services staff using an online submission
                                                   form.

  Underlying Software                              ColdFusion

  Hardware Platform                                Workstations

  Workstation/Server                               HR/Financial Zone
  Administration

  Production Date                                  Feb-05

  Software Cost                                    Free

  # FTE to Support System                          Unknown

  Accessibility                                    Yes

  Approx. Number of Users                          Unknown

  Anticipated Frequency of                         Unknown
  Upgrades

  This Document Last                               4/6/2007
  Updated




Administration\327c8386-dbfa-4797-ba8e-db87d0ddf95e.xls\Inventory      18 of 18                                        11/18/2010

								
To top