Project Tracking Excel - Excel by few24802

VIEWS: 218 PAGES: 2

Project Tracking Excel document sample

More Info
									                                                                                                                                                                       State of Wisconsin
                                                                                                                                                         Integrated Business Information System (IBIS)
                                                                                                                                                       Subsystem Survey - Project Accounting Sub-Systems




                                                                                                                                                                               WiSMART Interface
                                                                                                                               Homegrown                                       (Included Interfaces
                                                                                                 Off the    Software Name       (included                                      to FMS or DOT
Agency    System Name                Brief Description of Function                                Shelf      If Purchased      contracted) Programming Language                systems)
    245   Excel                      Used for project tracking
    507   N/A                        Agency does not use sub systems
    575   N/A                        Agency does not use sub systems
                                     Wismart Data is downloaded. Project data is
                                     downloaded to/ from WiSMART. Expenditures and
    866 Access                       receipting is transferred to Wismart.                         Yes      Microsoft Access       Yes         Visual Basic/Microsoft Access Screen coordinates are translated to from/ to WiSMART.
                                     Wismart Data is downloaded. Project data is
                                     downloaded to/ from WiSMART. Expenditures and
    866 CPA Information System       receipting is transferred to Wismart.                         No        Sequel Server         Yes                                     Screen coordinates
                                                                                                                                               Structured English Query Language ("SEQUEL") are translated to from/ to WiSMART.
                                     All transactions recorded at a Project level. From
                                     the resulting Audit Transaction file, some
                                     transactions are summarized without Project and
                                     interfaced to WiSMART as a JV. A file of valid
                                     project numbers is sent to DOA as General Service
        Financial Operating          Billing PFR Use Codes which are used for mainframe                                                                                        To WiSMART Interface
        System (FOS) (a project      computer charges. (DOT does not send project IDs                                                                                          ID = DF and to General
    395 accounting system)           to WiSMART from any system)                                   No                              Yes         COBOL                           Services Billing
        Financial Integrated
        Improvement
        Programming System                                                                                                                                                     To FOS (interface
    395 (FIIPS)                      Interfaces Project related data to FOS                         No                             Yes         JAVA                            program is COBOL)
                                                                                                 Yes with                                                                      To EAPS (interface
                                                                                                 customiz                                                                      program is COBOL;
    395 TIPS (purchasing System) Interfaces Project level transactions to EAPS                     ation         AGPS          Customization                                   data is a flat file)
                                                                                                                                                                               To FOS (interface
        Encumbrance/Accounts                                                                                                                                                   program is COBOL;
    395 Payable System               Interfaces Project level transactions to FOS                  No                              Yes         COBOL                           data is a flat file)
                                                                                                                                                                               To EAPS and FOS
                                                                                                                                                                               (interface program is
                                     Interfaces Project level transactions to EAPS and                                                                                         COBOL; data is a flat
    395 Time and Travel System       FOS                                                           No                              Yes         COBOL                           file)
                                                                                                                                                                               To EAPS and FOS
                                                                                                                                                                               (interface program is
        TEAL (new Time and           Interfaces Project level transactions to EAPS and                                                                                         COBOL; data is a flat
    395 Travel System)               FOS                                                           No                              Yes         JAVA                            file)
                                                                                                                                                                               To FOS and LRS
                                                                                                                                                                               (interface program is
                                     Interfaces Project level transactions to FOS, LRS                                                                                         COBOL; data is a flat
    395 Receipts System              and MRS                                                       No                              Yes         Smalltalk                       file)
                                                                                                                                                                               To FOS (interface
                                                                                                                                                                               program is COBOL;
    395 Journal Voucher System       Interfaces Project level transactions to FOS                  No                              Yes         COBOL                           data is a flat file)
                                                                                                                                                                               To FOS (interface
                                                                                                                                                                               program is COBOL;
    395 Service Centers              Interfaces Project level transactions to FOS                  No                              Yes         COBOL or SAS                    data is a flat file)
                                                                                                                                                                               To FOS (interface
                                     Interfaces Project level transactions to FOS (Pcard,                                                                                      program is COBOL;
    395 Automated JVs                Payroll, GS Bill)                                             No                              Yes         SAS                             data is a flat file)
                                                                                                                                                                               To Receipts (interface
        Local Revenue System                                                                                                                                                   program is COBOL;
    395 (LRS)                        Interfaces Project level transactions to Receipts             No                              Yes         COBOL                           data is a flat file)
                                                                                                                                                                               To FOS and Receipts
                                                                                                                                                                               (interface program is
        Miscellaneous Receivables    Interfaces Project level transactions to FOS and                                                                                          COBOL; data is a flat
    395 System (MRS)                 Receipts                                                      No                              Yes         MS Access                       file)
                                     Interfaces to FHWA using mainframe batch FTP
    395 FHWA Electronic Bill         process                                                       No                              Yes         COBOL                           To FHWA
    395 Aeronautics Bill             Manually keyed online using Federal system
                                     DNR's Cost Accounting system (CARS) generates JV                                                          Oracle DB, SQL, Developer
        Cost Accounting - Salary     transactions to transfer labor costs to development                                                       Forms/Reports, PL/SQL, Unix,
    370 Transfer (JVs)               projects and gift & donation projects.                        No                               Yes        DBMS_JOB                     IT
                                     Fringe transactions are copied from WiSMART into a data
                                     warehouse at the DNR. DNR's Cost Accounting System
                                     (CARS) prorates fringe benefit costs (grouped by
                                     permanent or LTE) over the direct labor activity dollars                                                  Oracle DB, SQL, Developer
          Cost Accounting - Fringe   for each sub-program by fiscal month. We create                                                           Forms/Reports, PL/SQL, Unix, Manual JVs (on-line or
    370 Allocation (JVs)             manual JVs to transfer the fringe to the project codes.       No                               Yes        DBMS_JOB                     macro uploader)
                                     Although this isn't an interface to WiSMART, I have
                                     included it to show that we rely on the daily download of
                                     data from WiSMART to provide more detailed
                                     information for our management staff reporting on
        Financial Information        project codes. Queries/reports with inception-to-date                                                     Oracle DB, SQL, PL/SQL, Unix,
        Reference System (FIRS)      information on all development, acquisition, gift &                                                       Crontab, SQL Loader,
        Data Transfer/Data           donations projects is available on The DNR Project                                                        ControlM, JCL, SAS,           Data download from
    370 Warehouse                    Financial Information System (PFIS) web page.                 No                               Yes        DBMS_JOB                      WiSMART files
                                     Project tables (AGPR, PRBL) downloaded from
    485 Project Databases            Wismart to produce reports                                    No                              Yes         Visual Basic/Microsoft Access
    143 N/A                          Agency does not use sub systems
    410 N/A                          Agency does not use sub systems
                                     IT Project Planning - ASD- This software allows
                                     project managers to enter project budgets by
                                     master task and phase. This interfaces to PTAWEB,                                                                                     Interface to TED,
    445 ITPP                         WISARD and TED                                                No                              Yes         Visual Basic, Oracle, PLSQL WISARD, EPTA
                                                                                                                                                                           FM - WI
                                     Transaction Editor: All transactions interfaced from                                                                                  JR - 15
                                     DWD to WISMART go through TED. Ted creates                                                                                            JV - WD
                                     documents from electronic files, validates codes,                                                                                     PO - 17             P1 -
                                     allows users to edit docs as needed, and then                                                                                         13                TL -
                                     batches and sends to WISMART on a nightly basis.                                                          Visual Basic, Oracle PLSQL, T2 Interface to
    445 TED                          TED also do                                                   No                              Yes         Oracle, Windows Batch files WISARD
    445 Grants Database              Keeps track of all grants processed by DWD                    No                              Yes         Access




                  908049a7-91cd-4b95-ac4b-67e0a18c5763.xls                                                                                                                                                                            1 of 2
                                                              State of Wisconsin
                                                Integrated Business Information System (IBIS)
                                                Subsystem Survey - Macros and Upload Utilities
                                                                                                                 Homegrown
                                                                                                                  (included
Agency   System or File Name                Brief Description of Function              Software Application      contracted)     Transfer Method
                                                                                                                               Transfer project
                                                                                                                               budget information
                                                                                                                               via OLE
                                                                                                                               Automation(screen
   866 Access database            Translates data to screen coordinates in WiSMART   Microsft Access                 Yes       scraping).
                                                                                                                               Transfer project
                                                                                                                               budget information
                                                                                                                               via OLE
                                                                                                                               Automation(screen
   866 CPA Information System     Translates data to screen coordinates in WiSMART   Sequel Server                   Yes       scraping).
                                  JV data is keyed into spreadsheet and then
                                  transferred to WiSMART using VBA                                                             Transfers JV data to
                                                                                                                               Smarterm Screen
   370 Smarterm JV Uploader                                                          Microsoft Excel 2003, VBA       yes       using OLE Automation
                                  JV data is keyed into spreadsheet and then                                                   Transfers JV data to
                                  transferred to WiSMART using VBA                                                             HOD Screen using
   370 HOD JV Uploader                                                               Microsoft Excel 2003, VBA       yes       OLE Automation
   485 Excel Spreadsheet          JV upload Macro                                    Miscrosoft Excel                Yes       Visual Basic Macro




     908049a7-91cd-4b95-ac4b-67e0a18c5763.xls                                                                                          2 of 2

								
To top