Docstoc

Contracted Software Developer

Document Sample
Contracted Software Developer Powered By Docstoc
					                                                                                                                                            State of Wisconsin
                                                                                                                              Integrated Business Information System (IBIS)
                                                                                                                                Subsystem Survey - Allocation Sub-Systems




                                                                                                                                                                        WiSMART Interface
                                                                                                                              Homegrown                                 (Included
                                                                                                    Off the   Software Name    (included                                Interfaces to FMS or
Agency System Name                      Brief Description of Function                                Shelf     If Purchased   contracted) Programming Language          DOT systems)
    507 N/A                             Agency does not have sub systems
    575 N/A                             Agency does not have sub systems
                                        Every transaction gets split to Federal
                                        appropriations, Local appropriations and State
       Project Appropriation            appropriations of a project based on particpating
   395 Allocation Process (FAP)         percentages and limits.                                       No                          Yes    COBOL

                                        This process summarizes the effect of several
                                        processes and interfaces to WiSMART as a Batch of
                                        JVs: Time and Travel (and associated Fringe
                                        Benefit) cross charging to end cost centers. Moves
                                        Computer costs to the end cost centers. Records
                                        the effects of machine generated and manual JVs
   395   Distributions                  initiated in DOT's system.                                    No                          Yes    COBOL
   395   Time Off With Pay              Applies TOWP rates to Projects                                No                          Yes    COBOL
   395   Fringe Benefits                Applies FB rates to Projects                                  No                          Yes    COBOL
   395   Proratable                     Applies Proratable rates to Projects                          No                          Yes    COBOL
                                        Summarizes charges to SPES Projects and makes
       Preliminary Engineering          billable entries to the appropriate billing and offset
   395 (SPES)                           projects                                                      No                          Yes    COBOL
                                        Extracts General Services Billing information and
                                        assigns the appropriate project based on user
                                        defined fields and object code based on a PFR to
   395 General Services Billing         object code table                                             No                          Yes    SAS
                                        Extracts Pcard Billing information and assigns the
                                        appropriate project based on a Pcard number to
   395 Pcard Billing                    Project Number table                                          No                          Yes    SAS
                                        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
                                        for each sub-program by fiscal month. JVs are
         Cost Accounting - Fringe       generated to transfer costs based on a funding                                                   Oracle DB, SQL, Developer
         Allocation and Assignment      assignment from a primary appropriation to the                                                   Forms/Reports, PL/SQL, Unix,
   370 (JVs)                            appropriate funding source(s) for the activity.               No                          Yes    DBMS_JOB                       IB
                                        Supply and Service transactions are copied from
                                        WiSMART into a data warehouse at the DNR. DNR's Cost
                                        Accounting System (CARS) allocates general
                                        adminstrative/basic program service supply costs based
                                        on the direct labor activity dollars for each sub-program
                                        by fiscal month. JVs are generated to transfer costs
         Cost Accounting - Supplies &   based on a funding assignment from a primary                                                     Oracle DB, SQL, Developer
         Services Allocation and        appropriation to the appropriate funding source(s) for                                           Forms/Reports, PL/SQL, Unix,
   370 Assignment(JVs)                  the activity.                                                 No                          Yes    DBMS_JOB                       IK
                                        Allocable labor costs from the DNR's Cost Accounting
                                        System (CARS) Labor Distribution process are prorated
                                        over direct labor activity dollars by sub-program by
                                        fiscal month. JVs are generated to transfer costs based
         Cost Accounting - Labor        on a funding assignment process from a primary                                                   Oracle DB, SQL, Developer
         Allocation and Assignment      appropriation to the appropriate funding source(s) for                                           Forms/Reports, PL/SQL, Unix,
   370 (JVs)                            the activity.                                                 No                          Yes    DBMS_JOB                       II
                                        The DNR downloads supply and service transactions into
                                        a data warehouse. DNR's Cost Accounting System
                                        (CARS) generates JVs that transfer costs based on a
                                        funding assignment process from a primary                                                        Oracle DB, SQL, Developer
         Cost Accounting - Supplies &   appropriation to the appropriate funding source(s) for                                           Forms/Reports, PL/SQL, Unix,
   370 Services Assignment (JVs)        that activity.                                                No                          Yes    DBMS_JOB                       IG
                                   DNR's Cost Accounting System (CARS) allocates labor
                                   dollars to the activities on the employees time report.
       Cost Accounting - Labor     These labor dollars are moved from a primary                                                          Oracle DB, SQL, Developer
       Distribution and Assignment appropriation to the appropriate funding sources(s)                                                   Forms/Reports, PL/SQL, Unix,
   370 (JVs)                       based on the funding assignment process.                           No                          Yes    DBMS_JOB                       IN
                                   DNR's Cost Accounting system (CARS) generates JV                                                      Oracle DB, SQL, Developer
       Cost Accounting - Salary    transactions to transfer labor costs to development and                                               Forms/Reports, PL/SQL, Unix,
   370 Transfer (JVs)              gift and donation projects.                                        No                          Yes    DBMS_JOB                       IT
   143 N/A                              Agency does not have sub systems
   410 N/A                              Agency does not have sub systems

                                        WiSMART's Accounting and Reporting Data Warehouse.
                                        WISARD is DWD's sole financial reporting tool. WISARD                                                                           Interface from TED and
                                        interfaces to WISMART, ARS, TED, PTA, BUDWEb, IRIS,                                                                             WISMART, RAPIDS and
                                        RAPIDS, TIVOLI, ITPP, PAL, HRS, PAL, and CORe.                                                   Cobol, Informatica, VB.NET,    CORe. Interface to
   445 WISARD                           WISARD downloads both programmatic and financial              No                          Yes    Windows Batch Files            Budget, CAL
                                        Cost Allocation System - This allocates all costs charged
                                        to overhead, Fringe benefits, Program Revenue for                                                                               Interface to TED,
                                        General Administration, and FICR. This interfaces to TED                                                                        Interface from WISMART,
   445 CAL                              to create JR/JV                                               No                          Yes    Visual Basic, Oracle, PLSQL    WISARD




               c2a1e4fe-0585-4d78-be61-2727c6fab9b5.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
       Multiple:
       Federal Time Distribution                                                                                              Transfers JR/JV data
       Dept & Div Overhead                                                                                                    to Host on Demand
       Federal Space Rent          Spreads cost through allocaiton percents and                                               Session via EXCEL
   505 Indirect                    uploads JR/JV to WiSMART                            Microsoft Excel              Yes       macro uploader
       Multiple billings:                                                                                                     Transfers SB data to
       SCO                                                                                                                    Host on Demand
       Risk                        Spreads cost through allocation percents and                                               Session via EXCEL
   505 Procurement                 uploads SB to WiSMART                               Microsoft Excel              Yes       macro uploader
                                                                                                                              Transfers JV data to
                                                                                                                              Host On Demand
                                   Spreads labor and fringe costs by reported activity.                                       Session using OLE
   485 Excel Worksheet              Enters into excel sheet that uploads JV to WiSMART Miscrosoft Excel             Yes       Automation




     c2a1e4fe-0585-4d78-be61-2727c6fab9b5.xls                                                                                          2 of 2

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:8/16/2011
language:English
pages:2
Description: Contracted Software Developer document sample