Excel Reports from Business Managers by mly16547

VIEWS: 9 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\780e0f48-2104-4d8d-9bb7-d0cd0f1ef79a.xls                    2/3/2011
                                                Departmental Application Inventory




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




780e0f48-2104-4d8d-9bb7-d0cd0f1ef79a.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




780e0f48-2104-4d8d-9bb7-d0cd0f1ef79a.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




780e0f48-2104-4d8d-9bb7-d0cd0f1ef79a.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




780e0f48-2104-4d8d-9bb7-d0cd0f1ef79a.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




780e0f48-2104-4d8d-9bb7-d0cd0f1ef79a.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




780e0f48-2104-4d8d-9bb7-d0cd0f1ef79a.xls\Inventory                       7 of 7                                           2/3/2011

								
To top