Excel Reports from Managers by mly16547

VIEWS: 12 PAGES: 7

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. download
                               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. If developed in house, try to break down the number of hours it took
                               to develop the system and multiply it by $25 (guess on my part). If you're
                               guessing, use a "Est." in front of the figure. Leave blank if no idea.

# 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\dd054241-43ea-4b27-bcfb-662727a76aa1.xls                   2/3/2011
                                               Departmental Application Inventory




                                                 INVENTORY OF DEPARTMENTAL APPLICATIONS
                                                        (purchased & in-house developed)
                                                              Payroll




dd054241-43ea-4b27-bcfb-662727a76aa1.xls\Inventory              2 of 7                     2/3/2011
                                               Departmental Application Inventory




  Business Area                                  Disbursements - Payroll

  Name of the System                             Biweekly Held Checks

  Brief Description                              This database receives a file transferred from the mainframe from the payroll
                                                 files. Excel reports are created that are sent to Business Managers explaining
                                                 held checks. It also prints reports on checks that have been released that
                                                 were previously held.

  Data                                           imports held check information file

  Underlying Software                            Microsoft ACCESS

  Hardware Platform                              PC/Windows OS

  Workstation/Server                             HRFin Zone
  Administration

  Production Date                                1991

  Software Cost                                  developed in-house

  # FTE to Support System                        no planned support

  Accessibility                                  Only used by Payroll Office

  Approx. Number of Users                        4

  Anticipated Frequency of                       none planned
  Upgrades

  This Document Last                             9/24/2001
  Updated




dd054241-43ea-4b27-bcfb-662727a76aa1.xls\Inventory                    3 of 7                                            2/3/2011
                                               Departmental Application Inventory




  Business Area                                  Disbursements - Payroll

  Name of the System                             Monthly Held Checks

  Brief Description                              This database receives a file transferred from the mainframe from the payroll
                                                 files. Excel reports are created that are sent to Business Managers explaining
                                                 held checks. It also prints reports on checks that have been released that
                                                 were previously held.

  Data                                           imports held check information file

  Underlying Software                            Microsoft ACCESS

  Hardware Platform                              PC/Windows OS

  Workstation/Server                             HRFin Zone
  Administration

  Production Date                                1991

  Software Cost                                  developed in-house

  # FTE to Support System                        no planned support

  Accessibility                                  Only used by Payroll Office

  Approx. Number of Users                        4

  Anticipated Frequency of                       none planned
  Upgrades

  This Document Last                             9/24/2001
  Updated




dd054241-43ea-4b27-bcfb-662727a76aa1.xls\Inventory                    4 of 7                                            2/3/2011
                                               Departmental Application Inventory




  Business Area                                  Disbursements - Payroll

  Name of the System                             Special Checks

  Brief Description                              This application creates special checks based on all the gross and net data
                                                 that is entered by staff. Reports are printed daily listing the positive pay
                                                 transactions given to Debbie Wert in Accounting.

  Data                                           keyed by Payroll clerk

  Underlying Software                            Microsoft ACCESS

  Hardware Platform                              PC/Windows OS

  Workstation/Server                             HRFin Zone
  Administration

  Production Date                                1987

  Software Cost                                  developed in-house

  # FTE to Support System                        no planned support

  Accessibility                                  Only used by Payroll Office

  Approx. Number of Users                        4

  Anticipated Frequency of                       none planned
  Upgrades

  This Document Last                             9/24/2001
  Updated




dd054241-43ea-4b27-bcfb-662727a76aa1.xls\Inventory                    5 of 7                                             2/3/2011
                                               Departmental Application Inventory




  Business Area                                  Disbursements - Payroll

  Name of the System                             Wage Attachments

  Brief Description                              This application tracks the wage deductions made as a result of court
                                                 orders(child support, garnishments, bankruptcy, etc.)

  Data                                           keyed

  Underlying Software                            Microsoft ACCESS

  Hardware Platform                              PC/Windows OS

  Workstation/Server                             HRFin Zone
  Administration

  Production Date                                Dec-01

  Software Cost                                  developed in-house

  # FTE to Support System                        no planned support

  Accessibility                                  Only used by Payroll Office

  Approx. Number of Users                        4

  Anticipated Frequency of                       none planned
  Upgrades

  This Document Last                             9/24/2001
  Updated




dd054241-43ea-4b27-bcfb-662727a76aa1.xls\Inventory                    6 of 7                                             2/3/2011
                                               Departmental Application Inventory




  Business Area                                  Disbursements - Payroll

  Name of the System                             Disbursements - Payroll Website

  Brief Description                              Website for Payroll & International Employee information.

  Data

  Underlying Software                            HTML, PDF, Excel, Word

  Hardware Platform                              HPUX Unix

  Workstation/Server                             MI Web Services
  Administration

  Production Date

  Software Cost

  # FTE to Support System

  Accessibility                                  Most pages are accessible world wide. The web site is used by most
                                                 Business Offices, Regional Campus staff and others.

  Approx. Number of Users                        Many

  Anticipated Frequency of
  Upgrades

  This Document Last                             10/12/2001
  Updated




dd054241-43ea-4b27-bcfb-662727a76aa1.xls\Inventory                   7 of 7                                           2/3/2011

								
To top