Docstoc

System Information Travel Basis Data

Document Sample
System Information Travel Basis Data Powered By Docstoc
					                                                                                                     State of Wisconsin                                                                     Updated: June 9, 2006

                                                                                       Integrated Business Information System (IBIS)
                                                                                            Subsystem Survey - AP 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)
    115 CREP Database               uploads payment transactions to wismart                  NO            n/a              Yes     Visual Basic contained
                                                                                                                                    within Microsoft access
    145 EAS                         Enterprise Accounting System                            Yes         SunGard              No     Don't Know                  EAS Receives Wismart
                                                                                                                                                                Date
    145 FIMMAS                      Life Insurance Management System                        Yes         FIMMAS              No      APPX                        Sends Check Writing
                                                                                                                                                                Information
    145 PCF Assessment System       Keeps track of provider accounts, fees/pymts.            NO           N/A               Yes     ProC - Oracle Forms &       Does not interface with
                                                                                                                                    Reports                     Wismart
    145 Pinsoft                     Property Insurance Accounting System                    Yes         Pinsoft             No      Windows based               Minimally through
                                                                                                                                                                Access/Excel
                                                                                                                                                                downloads
    245 N/A                         Agency does not have AP subsystems.
    285 N/A                         Agency does not have AP subsystems interfacing
                                    with WiSMART.
    320 Environmental               The Environmental Improvement Fund Database              No           N/A               Yes     Access Visual Basic         No formal interface.
        Improvement Fund            processes semi-monthly loan disbursements. The
        Database                    Access Database system formats P1's for tranfer to
                                    WiSMART. The system currently uses the
                                    Attachmate WiSMART interface. The interface is
                                    being converted to Host on Demand.
    370 Aids in Lieu of Taxes       Municipalities are reimbursed for lost property tax      No                             Yes     Cobol, SAS, JCL             IL
        (70.113) (P1s)              on land removed from tax rolls due to state
                                    ownership (DNR). Data is generated from the
                                    Lands and Facilities sub-system to create P1
                                    transactions.
    370 Aids in Lieu of Taxes       Municipalities are reimbursed for lost property tax      No                             Yes     Cobol, SAS, JCL             IJ
        (70.114) (P1s)              on land removed from tax rolls due to state
                                    ownership (DNR). Data is generated from the
                                    Lands and Facilities sub-system to create P1
                                    transactions.
    370 Aircraft Chargebacks        DNR distributes charges to appropriate sub-              No                             Yes     Cobol, SAS, JCL             IA
        (SBs)                       programs for use of aircraft. Logs are entered by a
                                    data entry services. A Forestry sub-system
                                    generates the data to create SB transactions.

    370 Automated License           There is a bi-weekly bank sweep from the                 No                             Yes     Unix, Cobol, SAS, JCL       IW
        Issuance System (ALIS)      lockboxes for DNR's On Line License System. JR
        (JRs)                       transactions are created to do the distribution from
                                    the clearing account to the appropriate revenue
                                    accounts. JR transactions are interfaced to
                                    WiSMART.
    370 Cashier Lockbox             Remittance sheets for the sale of goods and              No                             Yes     Cobol, SAS, JCL                                    87
        Remittances (CRs)           services are entered by a data entry service. CR
                                    transactions are interfaced to WiSMART. (Note:
                                    This interface hasn't been used since FY2004. The
                                    current process is to upload $0 CRs which is noted
                                    on the Macros and Upload Utilities worksheet.)

    370 Community Assistance        DNR's CAOS generates P1 transactions to pay              No                             Yes     Oracle DB, PL/SQL, Unix,    IC
        Oracle System (CAOS)        municipalities for grants.                                                                      Cobol, SAS, JCL
        (P1s)
    370 Cost Accounting - Fringe    DNR's Cost Accounting System (CARS) generates            No                             Yes     Oracle DB, SQL, Developer   IB
        Assignment (JVs)            JV transactions to prorate fringe benefit costs over                                            Forms/Reports, PL/SQL,
                                    the direct labor activities for each sub-program by                                             Unix, DBMS_JOB
                                    pay period according to the appropriate funding
                                    sources.
    370 Cost Accounting - Labor     DNR's Cost Accounting System (CARS) generates            No                             Yes     Oracle DB, SQL, Developer   II
        Allocations Assignment      JV transactions to prorate allocable labor costs to                                             Forms/Reports, PL/SQL,
        (JVs)                       direct activities by sub-program. Costs are moved                                               Unix, DBMS_JOB
                                    from a primary appropriation to the appropriate
                                    funding sources.

          7a0341c9-e32d-4b3b-9d53-89ee86ee6df5.xls                                                      Updated 6/13/2006                                                                                 1 of 11
                                                                                                        State of Wisconsin                                                                Updated: June 9, 2006

                                                                                          Integrated Business Information System (IBIS)
                                                                                               Subsystem Survey - AP 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)
    370 Cost Accounting - Labor     DNR's Cost Accounting System (CARS) generates             No                              Yes     Oracle DB, SQL, Developer    IN
        Assignment (JVs)            JV transactions to prorate labor costs over the                                                   Forms/Reports, PL/SQL,
                                    direct labor activities for each sub-program. Costs                                               Unix, DBMS_JOB
                                    are moved from a primary appropriation to the
                                    appropriate funding sources.

    370 Cost Accounting - Salary    DNR's Cost Accounting system (CARS) generates JV          No                              Yes      Oracle DB, SQL, Developer   IT
        Transfer (JVs)              transactions to transfer labor costs to projects.                                                  Forms/Reports, PL/SQL,
                                                                                                                                       Unix, DBMS_JOB
    370 Cost Accounting - Supplies DNR's Cost Accounting System (CARS) generates              No                              Yes      Oracle DB, SQL, Developer   IK
        & Services Allocation      JV transactions to prorate allocable Supplies &                                                     Forms/Reports, PL/SQL,
        Assignment (JVs)           services costs to direct activities by sub-program.                                                 Unix, DBMS_JOB
                                   Costs are moved from a primary appropriation to
                                   the appropriate funding sources.

    370 Cost Accounting - Supplies DNR's Cost Accounting System (CARS) generates              No                              Yes      Oracle DB, SQL, Developer   IG
        & Services Assignment      JV transactions to prorate supplies and services                                                    Forms/Reports, PL/SQL,
        (JVs)                      costs over the direct labor activities for each sub-                                                Unix, DBMS_JOB
                                   program. Costs are moved from a primary
                                   appropriation to the appropriate funding sources.

    370 Employee Automated          The TRIPS web application captures travel and             No                              Yes      Oracle DB, SQL, Visual    IZ
        Expenditure                 other expenses from employee entered                                                               InterDev - ASP, PL/SQL,
        Reimbursement System        information. This system produces the data that                                                    Unix, Java Script, HTML,
        (TRIPS) (TLs)               creates the TL transactions that interface with the                                                DBMS_JOB, Cobol, SAS, JCL
                                    Central Payroll System and WiSMART.
    370 Hunting Ground Leases       Payments made to landowners where property is             No                              Yes      Cobol, SAS, JCL             IP
        (P1s)                       not posted to allow hunting. Data is generated
                                    from the Lands and Facilities sub-system to create
                                    P1 transactions.
    370 IT Billings (SBs)           The Bureau of Technology Services incurs agency           No                              Yes      Cobol, SAS, JCL             IM
                                    costs for technology services. Chargebacks are
                                    generated to bill all agency users from a
                                    Technology Services sub-system. SB transactions
                                    are interfaced to WiSMART.
    370 Landfill Closure (P1s)      Townships are reimbursed for closing dumps. Data          No                              Yes      Cobol, SAS, JCL             IQ
                                    is generated from the Community Assistance sub-
                                    system to create P1 transactions. (Note: FY2003
                                    is the last year data was generated from this
                                    system.)
    370 Licensing Lockbox           JRs are created to do the distribution from the           No                              Yes      Unix, Cobol, SAS, JCL                         80
        Revenue Transfer (JRs)      clearing account to the appropriate revenue
                                    accounts for General Hunting & Fishing Licenses;
                                    Boat, Snowmobile & ATV renewals; Boat,
                                    Snowmobile & ATV registrations. Lockboxes are
                                    1810, 6301, 7010. Data is entered by a data entry
                                    services. The Licensing sub-system is updated and
                                    JR transactions are interfaced to WiSMART.

    370 MFL / FCL / CFL TOWN        Townships are reimbursed for taxes on private land        No                              Yes      Cobol, SAS, JCL             IF
        AID (P1s)                   removed from the tax rolls and enrolled in Manages
                                    Forests, Forest Crop or County Forest. Data is
                                    generated from Forestry sub-system to create P1
                                    transactions.
    370 MFL Yield Tax Refund        As timber is cleared from managed forest lands, tax       No                              Yes      Cobol, SAS, JCL             IY
        (P1s)                       is paid by owners to townships and DNR. Data is
                                    generated by the Forestry sub-system to create P1
                                    transactions.




          7a0341c9-e32d-4b3b-9d53-89ee86ee6df5.xls                                                        Updated 6/13/2006                                                                             2 of 11
                                                                                                     State of Wisconsin                                                                            Updated: June 9, 2006

                                                                                       Integrated Business Information System (IBIS)
                                                                                            Subsystem Survey - AP 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)
    370 Recycling (P1s)             Responsible units or municipalities apply for             No                                   Yes     Cobol, SAS, JCL        IS
                                    monetary awards for recycling. Data is generated
                                    by the Community Assistance sub-system to create
                                    P1 transactions.
    370 Vehicles / Fleet            Administrative and Field Services administers the            No                                 Yes   Cobol, SAS, JCL         IV
        Chargebacks (SBs)           acquisition, maintenance and usage charges for all
                                    pool vehicles. Costs are recovered through the
                                    chargebacks to pool (cars, trucks, heavy
                                    equipment, trailers) vehicles. The sub-system
                                    generates the data to create the SB transactions
                                    that are interfaced to WiSMART.
    410 CACU ( ICS will Replace)    Tracks Offender funds due for Court Ordered                  No            1980s                YES   Mainframe to become     Mainframe Tape
                                    Restitution and other Obligations. System creates                                                     Server Based when ICS
                                    weekly Special "P" Series Check Write Tape (3000
                                    checks) - WiSMART MW - Clearing Appropriation
                                    985
    410 FMS                         Tracks invoice payments and interfaces P1               Yes but          MSA (1982)             YES   Mainframe               Mainframe
                                    transactions to WiSMART                                 Modified
                                                                                            by DHFS
                                                                                              Staff
    410 Platinum                    Waupun Central Warehouse Accounting System;               YES        Platinum 2004              NO    Server                  N/A
                                    manual interface to FMS
    410 PROTEUS (RFP completed      Badger State Industries Accounting System -          Yes but               1990s                YES   Server                  N/A
        for replacement 2005)       manual Voucher Interface to FMS                     Modified
                                                                                         by DOC
                                                                                        Contract
                                                                                         ed Staff
    410 WITS (ICS will Replace)     Inmate Banking System - Funds held in Trust not      Yes but               1990s                YES   Server                  N/A
                                    on State Books - Not Appropriated                   Modified
                                                                                         by DOC
                                                                                        Contract
                                                                                         ed Staff
    435 CARS                        Calculates and tracks payments for Local Assistance No                                    Yes         COBOL, SAS              CN, CM                 Uploads MW documents to WISMART
                                    and Aids to Organization contracts.                                                                                                                  through bridge. Actual payments are
                                                                                                                                                                                         created through specialized check
                                                                                                                                                                                         writer, ACH transactions, and LGIP
                                                                                                                                                                                         transactions.

    435 DDB                         Calculates and tracks CEFIS and MER payments.           No                                Yes         COBOL                   HS                     Uploads MW documents to WISMART
                                                                                                                                                                                         through bridge. Actual payments are
                                                                                                                                                                                         created through specialized check
                                                                                                                                                                                         writer.
    435 FMS                         DHFS accounting system.                                 Yes        MSA                    Greatly     COBOL                   HS                     Uploads P1 documents to WISMART
                                                                                                                              Modified                                                   through bridge. Checks are created
                                                                                                                                                                                         through WISMART.
    435 WISACWIS                    Calculates and tracks foster care and adoption          No                                Yes         JAVA                    HS                     Uploads MW documents to WISMART
                                    assistance payments.                                                                                                                                 through bridge. Actual payments are
                                                                                                                                                                                         created through specialized check
                                                                                                                                                                                         writer and ACH transactions.

    445 1099 Process                This system takes information from WiSMART's                 No                                 Yes   Visual Basic, Cobal     Interface from
                                    1099 process and CARES payments and                                                                                           WISMART, Rapids
                                    summarizes information together prior to creating
                                    paper and electronic 1099's.
    445 Ameritech Details           Provides management statistics on centrex phone              Yes    Ameritech Details           No                            None
                                    usage including total completed calls and average-
                                    calls-per-day statistics, busy analysis, call summary
                                    and call detail.
    445 BPS                         Benefit Claim System - UI - creates check transition         No                                 Yes                           None - MW done
                                    file for all UI claims - interfaces to FIRSTAR for                                                                            manually on WISMART
                                    processing (print and mail checks)                                                                                            for checkwriters

          7a0341c9-e32d-4b3b-9d53-89ee86ee6df5.xls                                                             Updated 6/13/2006                                                                                 3 of 11
                                                                                                   State of Wisconsin                                                                      Updated: June 9, 2006

                                                                                     Integrated Business Information System (IBIS)
                                                                                          Subsystem Survey - AP 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)
    445 BudWEB                     This system allows for creation and tracking on the      No                             Yes     Visual Basic, Oracle, PLSQL  Interface from TED,
                                   operating budget for DWD                                                                                                     Interface to WISARD
   445 CAL                         Cost Allocation System - This allocates all costs        No                             Yes      Visual Basic, Oracle, PLSQL Interface to TED,
                                   charged to overhead, Fringe benefits, Program                                                                                Interface from
                                   Revenue for General Administration, and FICR.                                                                                WISMART
                                   This interfaces to TED to create JR/JV
   445 CARES                       Aid tracking and disbursement system. There are          No                             Yes      Visual Basic, Cobal          None - MW done
                                   multiple CARES checkwriters…Child Care Checks,                                                                                manually on WISMART
                                   Child Care ACH, Daily, W-2 First Run, W-2 Second                                                                              for checkwriters
                                   Run, W-2 Benefits, W-2 Vendor, and W-C Delayed

   445 CORE                        Central Office Reporting - DWS - Grant Processing       Yes          CORE                No      FoxPro                       P1 - 13, WiSARD,
                                   system for sub-recipients of state and federal                                                                                FrontPage for Website
                                   funds. This sends flat file to WISMART w/ ACH                                                                                 nightly publication, MW
                                   information which is also manually keyed as a MW                                                                              mannually done on
                                   daily. This also records and processes spreadsheet                                                                            WISMART for ACH
                                   uploads from counties detailing expenditures. All
                                   information tracked in CORE is manually entered
                                   into WISMART directly, or interfaced through TED's
                                   spreadsheet upload.

   445 EPTA                        Enterprise Payroll Time and Attendance - This is         No                             Yes      Visual Basic, Oracle, PLSQL Interface to TD/PRS
                                   now under DOA - use to enter time and distribution
                                   codes for all employees and billable contractors.

   445 FORMS                      UW Forms sends us an electronic file with detailed        No                             Yes      Visual Basic                 Interface to TED
                                  information as to what was purchased, purchaser
                                  info, and account coding. We then use this
                                  information to create JR/JV to be sent to TED for
                                  formatting, validating, and batching for posting in
                                  WISMART
   445 Great Plains               General Ledger software interface with SUITES.           Yes       Great Plains           No                                   None
                                  Replaced by ILEAI400098.
   445 GSB (DWD process to pay DWD General Service Billing process - An electronic          No                             Yes      Cobal                        Interface to TED
       DOA General Services Bill) file is received monthly from DOA's General
                                  Services Billing System that holds detail of account
                                  coding for Fleet, phone, print, and mail billings.
                                  This process also uses the master tasks in TED and
                                  interfaces to TED to create JV/JR to clear out the
                                  clearing accounts on monthly basis

   445 Infotech                    This is an electronic file we receive from DOA by        No                             Yes      Visual Basic                 Interface to TED
                                   job name. This file is used to bill out all infotech
                                   costs back to benefiting programs. This process
                                   uses Ted for master tasks and interfaces to create
                                   JR/JV's to clear the clearing accounts
   445 IRIS                        Integrated Rehabilitation Information Sytem - DVR-       No                             Yes      Visual Basic, Oracle         Interface to Rapids,
                                   is the DVR case management system. This                                                                                       RAPWeb, and WISARD
                                   connects with RAPIDS, RAPWEB, WISMART, and
                                   WISARD.
   445 ITPP                        IT Project Planning - ASD- This software allows          No                             Yes      Visual Basic, Oracle, PLSQL Interface to TED,
                                   project managers to enter project budgets by                                                                                 WISARD
                                   master task and phase. This interfaces to PTAWEB,
                                   WISARD and TED




         7a0341c9-e32d-4b3b-9d53-89ee86ee6df5.xls                                                      Updated 6/13/2006                                                                                 4 of 11
                                                                                                    State of Wisconsin                                                                   Updated: June 9, 2006

                                                                                      Integrated Business Information System (IBIS)
                                                                                           Subsystem Survey - AP 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)
    445 KIDS                       Kids Information Data System – Child support              No                             Yes     Visual Basic, Cobal        None - MW done
                                   tracking and disbursement system used by DWS,                                                                               manually on WISMART
                                   Bureau of Child Support. Collections are received                                                                           for checkwriters
                                   and posted directly to KIDS by the child support
                                   CR&D vendor, currently ACS. Collections are
                                   reported by the CR&D vendor to DWD daily and
                                   posted to WiSMART with a CR transaction. KIDS
                                   then determines the payee based on child support
                                   case information and produces check write tapes.
                                   The largest check write tape which disburses most
                                   child support payments is created daily and is used
                                   by a sub-contractor, currently Laser Tech, to create
                                   child and family support checks. KIDS also
                                   produces a check write tape for EOG (excess over
                                   grant) payments which is interfaced to DOA. All
                                   check write disbursements are posted to WiSMART
                                   with MW transactions
   445 LSIS                        Labor Standards Information System - ER - this            No                             Yes                                Interface to TED
                                   system tracks and calculates payment to
                                   employees through E/R. This then goes to a check
                                   writer that interfaces to TED. There is also an
                                   interface from WISMART to EIEP, showing deposits
                                   made by employers.
   445 Meter Mail                  Meter Mail tracks all offsite mail meters, the            No                             Yes    Visual Basic                Interface to TED
                                   postage used, and postage remaining. This
                                   interfaces with TED to create JR/JV to clear clearing
                                   accounts.
   445 PAL                         Procurement Account Log - PAL downloads PCARD             No                             Yes    Visual Basic                Interface to TED,
                                   statements from WISMART, and emails cardholders                                                                             WISMART, HRS system
                                   when statements are downloaded. Cardholders                                                                                 for supervisory
                                   then log into PAL and code their purchases and                                                                              hierarchy for automatic
                                   complete descriptions of what was purchased. This                                                                           emails
                                   routes to their supervisor for approval, once
                                   approved this interfaces with TED creating JR/JV to
                                   be sent and posted to WISMART

   445 Postage                     This is an electronic file we upload from the Pitney      No                             Yes    Visual Basic                Interface to TED
                                   Bowes Mail system. This tracks postage by task
                                   code. This process uses TED for master tasks, and
                                   interfaces to create JR/JV to clear clearing accounts

   445 Printing Supplement         Contract Printing Supplement - interfaces to              No        Info Path            Yes                                Interface to Rapids
                                   RAPIDS
   445 Rap Web                     RAPWEB is a web-based RAPIDS application used             No                             Yes    Visual Basic, Oracle, PLSQL Interface to TED,
                                   by DVR. This application connects to the IRIS                                                                               WISARD and IRIS
                                   system (Real-time) to ensure business rules are
                                   followed when creating orders and direct pays.

   445 RAPIDS                      This is our procurement and Accounts Payable              No                             Yes    Visual Basic, Oracle, PLSQL Interface to TED
                                   system. The following documents are created in
                                   RAPIDS: Blanket Orders/Releases, Third Party
                                   Orders/Releases, Direct Charge, Purchase Orders,
                                   Printing and Quick Copy. RAPIDS generates
                                   financial transactions (PO, P1's, TL) and sends the
                                   information to TED to be formatted, edited, and
                                   batched to send to WISMART for posting. RAPIDS
                                   also receives a nightly download from WISMART
                                   listing the check number and date that P1's are
                                   paid.


         7a0341c9-e32d-4b3b-9d53-89ee86ee6df5.xls                                                       Updated 6/13/2006                                                                              5 of 11
                                                                                                      State of Wisconsin                                                                        Updated: June 9, 2006

                                                                                        Integrated Business Information System (IBIS)
                                                                                             Subsystem Survey - AP 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)
    445 RAPIDS - TAA                This part of RAPIDS allows tracking of TAA                 No                             Yes     Visual Basic, Oracle, PLSQL,   Interface to TED,
                                    participants and amounts paid. There is also                                                                                     WiSARD
                                    functionality to keep the TAA participants SS #
                                    confidential by sending our agency number on the
                                    posted transaction, yet tracking payments received
                                    by participant in RAPIDS
    445 RAPIDS - Vendor File        This part of RAPIDS stores all vendor information.         No                             Yes      Visual Basic, Oracle, PLSQL Interface to RAPIDS,
                                    This file is much larger than the WISMART vendors                                                                              IRIS
                                    DWD uses in WISMART, as all TAA and DVR
                                    participants are included in this vendor file, but not
                                    WiSMART's for confidentiality. This connects to the
                                    IRIS system and stores DVR's case numbers. This
                                    is used to look up case status information real-time
                                    from the IRIS system for information and
                                    processing rules

    445 RMS                         Random Moment Sampling Software - ASD - This is           Yes          RMS                 No                                    Interface to CORE
                                    used to email workers and collect statistical
                                    information on what employees worked on. This
                                    interfaces to the CORE system to allocate overhead
                                    expenditures
    445 Tax and Accounting          UI - gathers and summarizes accounting                     No                             Yes                                  None - MW done
        System                      information for UI general fund (businesses paying                                                                             manually on WISMART
                                    UI and claimants receiving payments                                                                                            for checkwriters
    445 TD/PRS                      Time Distribution/Program Revenue Services - ASD -         No                             Yes      Visual Basic, Oracle, PLSQL Interface to TED,
                                    This is an automated process that clears payroll                                                                               Interface from
                                    dollars from clearing account to benefiting funding                                                                            WISMART, EPTA
                                    sources and bills out PRS costs to benefiting
                                    funding sources
    445 TED                         Transaction Editor: All transactions interfaced from       No                             Yes      Visual Basic, Oracle PLSQL, FM - WI
                                    DWD to WISMART go through TED. Ted creates                                                         Oracle, Windows Batch files JR - 15
                                    documents from electronic files, validates codes,                                                                              JV - WD
                                    allows users to edit docs as needed, and then                                                                                  PO - 17                P1
                                    batches and sends to WISMART on a nightly basis.                                                                               - 13                  TL -
                                    TED also downloads all posted documents from                                                                                   T2
                                    WISMART and compares them to documents sent
                                    from TED and highlights any variances identified.
                                    TED downloads WiSMART's master files on a nightly
                                    basis, and interfaces FM's and FAIT entries to
                                    WISMART daily. TED interfaces PO, P1, TL, JR, JV,
                                    and FM's to WISMART.
    445 Tivoli                      This is our Asset tracking system                         Yes          Tivoli              No                                    Interface to WISARD
    445 W/C A/R                     Generates invoices for Uninsured Employers Fund &         Yes          FARS                No      Cobal                         Manual entries done on
                                    Work Injury Supplemental, these transactions are                                                                                 WISMART in summary
                                    not interfaced to WISMART, but a manual summary
                                    JV is done at month end to recognize billings. Cash
                                    Receipts are entered into WISMART and W/C A/R

    445 W/C Children's & Second     System calculated and initiates additional monthly         No                             Yes      VB.Net, Guard FTP, Cobal      Interface to TED
        Injury                      Workers Comp payments. Interfaces to TED
                                    through two automated check writers: 2nd Injury
                                    and Childrens Death Benefit




          7a0341c9-e32d-4b3b-9d53-89ee86ee6df5.xls                                                        Updated 6/13/2006                                                                                   6 of 11
                                                                                                  State of Wisconsin                                                                         Updated: June 9, 2006

                                                                                    Integrated Business Information System (IBIS)
                                                                                         Subsystem Survey - AP 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)
    445 WISARD                      WiSMART's Accounting and Reporting Data               No                                Yes     Cobal, Informatica, VB.NET,   Interface from TED and
                                    Warehouse. WISARD is DWD's sole financial                                                       Windows Batch Files           WISMART, RAPIDS and
                                    reporting tool. WISARD interfaces to WISMART,                                                                                 CORe
                                    ARS, TED, PTA, BUDWEb, IRIS, RAPIDS, TIVOLI,
                                    and CORe. WISARD downloads both programmatic
                                    and financial information on a nightly basis.
                                    WISARD allows nightly updating and posting
                                    reports directly to the internet. WISARD also
                                    allows both ad hoc and canned reporting

   465 JR/JV Upload                 Uses an excel spreadsheet to upload data directly                   Access
                                    into WiSMART through a Macro
   465 Multi-Payee System           Generates payments to multiple vendors with the                     Access
                                    same coding and interfaces P1 documents to
                                    WiSMART
   465 Tuition Grant System         Tracks Tuition Grant Reimbursments to National                      Access
                                    Guard Members and interfaces P1 documents to
                                    WiSMART
   465 Warehouse System             Tracks inventory and produces payment transfers                     Access
                                    from the various locations. Interfaces PV
                                    documents to WiSMART
   485 WARS                         Downloads WISMART data for reporting P1 and           No       Access Database          Yes      Access Database
                                    other WISMART Transactions for the agency
   505 General Services Bill paid   GSB payments for WISMART interface agencies are       No        Modeled after           Yes      CICS, Cobol                  Interface ID: GS
       on SB's                      loaded to WISMART for processing                               WISMART journal
                                                                                                      vouchers
   505 Purchase Plus (used by       Web based system to enter, edit, and track            No                                Yes      SQL, ASP, and others
       agencies 115, 143, 255,      requisitions and approve purchase orders and
       410, 432, 475, 505, 510,     enter, edit and track vendor payments. System
       525, 540, 545, 566 and       interfaces PO and P1 transacations to WISMART.
       585)                         Payments include both direct charges and purchase
                                    order payments.
   505 Risk Management STARS        Tracks property, liability and workers compensation Yes, but   STARS, purchased         No       Not sure, C Sharp?           Interface ID: E2
       (Statistical Tracking &      claims for State Risk Management program and        modified    from Marsh USA
       Reporting System)            interfaces P1's to WISMART
   505 WHEAP (Wisconsin Home        Tracks contract costs for local contracts for WI      No                                Yes      HTML, XML, VBscript,         Interface ID's: 19 for
       Energy Assistance            Home Energy and interfaces both regular P1's and                                                 Javascript, VB 6.0 DLL's     regular P1's; 20 for EFT
       Program)                     electronic fund transfer P1's to WISMART.                                                                                     P1's
                                    (System also tracks benefit payments for recipients
                                    of the WHEAP program and provides data for
                                    manual entry of manual warrants to WISMART.)

   505 WISWAP                       Tracks weatherization contract performance and        No                                Yes      HTML, VBscript, Javascript, Interfaced through
                                    costs for the Weatherization Program. Allows                                                     ASP (Classic)               Purchase Plus to
                                    contractors/grantees to enter payment requests                                                                               WISMART
                                    which are uploaded to Purchase Plus.
   510 N/A                          Agency uses Purchase Plus. Agency does not have
                                    additional AP subsystems.
   515 Accumulated Sick Leave       Calculate expenses for unfunded retirement            no                                Yes      Mainframe                    Keeps information for
       Conversion Program           liabilities on annuitant sick leave balances                                                                                  Cr/Jr/Jv creation to
                                                                                                                                                                  expense
   515 Benefit Payment System       Pays Annuitants Monthly-Special Check Writing         no                                Yes      Java                         Testing Presently
   515 Health Insurance             Pay State Health insurance providers                  no                                yes      Java, Cobol                  Payment information
       Complaint System (HICS)                                                                                                                                    keyed into Wismart
   515 Helmsman                     ETF General Ledger on Calendar Year Basis             yes       FRX ( Microsoft          no                                   Keeps information on
                                                                                                       Product)                                                   A/P for General Ledger
                                                                                                                                                                  information
   515 Milwaukee Retirement         To reimburse MRS for payments to annuitants from      yes           Excel                                                     Payment information
       System                       funds from SWIB                                                                                                               keyed into Wismart



         7a0341c9-e32d-4b3b-9d53-89ee86ee6df5.xls                                                       Updated 6/13/2006                                                                                  7 of 11
                                                                                                     State of Wisconsin                                                                             Updated: June 9, 2006

                                                                                       Integrated Business Information System (IBIS)
                                                                                            Subsystem Survey - AP 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)
    515 SCS Payments                Pays Single Cash Sums to beneficiaries, separated        yes           Paradox                                               Payment information
                                    employees, etc. bi monthly. To be converted to                                                                               keyed into Wismart
                                    JAVA shortly.
    550                             Electronic billing function for private bar assigned
                                    attorneys to bill for the services provided to SPD
        eOPD                        clients                                                  No              N/A               Yes     VB.Net                    Please see Macros & Upload Utilities tab
    575 N/A                         Agency does not have AP subsystems.
    585 Unclaimed Property          Tracks unclaimed property receipts and payments         Yes        UPS2000 from             No     Borland's Delphi          to be identified
                                                                                                     Wagers & Associates,
                                                                                                            Inc.
866/867 Capital Accounting Debt     Debt service payments for fixed rate General             No              N/A               Yes     Access Visual Basic       No formal interface.
        Service Database            Obligation Bonds and variable rate General
                                    Obligation paper are formatted in the Access
                                    database and transferred to WiSMART in
                                    Attachmate. The P1 transfers will be move into the
                                    CPA Information System in FY06.
866/867 CPA Information System      Capital Project Accounting Information System.           No              N/A               Yes     Visual Basic/SQL Server   No formal interface.
                                    Uses table and transaction data downloaded from
                                    WiSMART on a daily basis. Interfaces with the
                                    Division of State Facilities' WisBuild system for
                                    contract payment data. Pre-audits payment
                                    requests and formats P1 transactions which are
                                    transfered to WiSMART through Host On Demand.

866/867 Master Lease Database       The Master Lease Program requires semi-annual            No              N/A               Yes     Access Visual Basic       No formal interface.
                                    payments. The database is used to format
                                    payment transactions for all state agencies and
                                    format the P1's for transfer to WiSMART. The
                                    system currently uses the Attachmate WiSMART
                                    interface. The interface is being converted to Host
                                    On Demand.




          7a0341c9-e32d-4b3b-9d53-89ee86ee6df5.xls                                                         Updated 6/13/2006                                                                                      8 of 11
                                                              State of Wisconsin                                            Updated: June 9, 2006

                                                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
   115 WiSMART                    P1, TL, PV, MP macros                               excel                           yes     from excel to wismart
                                                                                                                              - upload
   143 WiSMART                    P1, TL, PV macros                                   Microsoft Excel 2003            yes     from excel to wismart
                                                                                                                              - upload
   370 HOD 0$ CR Uploader         CR data is keyed into spreadsheet and then          Microsoft Excel 2003, VBA       yes     Transfers CR data to
                                  transferred to WiSMART using VBA                                                            HOD Screen using
                                                                                                                              OLE Automation
   370 HOD CR Uploader            CR data is keyed into spreadsheet and then          Microsoft Excel 2003, VBA       yes     Transfers CR data to
                                  transferred to WiSMART using VBA                                                            HOD Screen using
                                                                                                                              OLE Automation
   370 HOD JR Uploader            JR data is keyed into spreadsheet and then          Microsoft Excel 2003, VBA       yes     Transfers JR data to
                                  transferred to WiSMART using VBA                                                            HOD Screen using
                                                                                                                              OLE Automation
   370 HOD JV Uploader            JV data is keyed into spreadsheet and then          Microsoft Excel 2003, VBA       yes     Transfers JV data to
                                  transferred to WiSMART using VBA                                                            HOD Screen using
                                                                                                                              OLE Automation
   370 HOD MP Uploader            MP data is keyed into spreadsheet and then          Microsoft Excel 2003, VBA       yes     Transfers MP data to
                                  transferred to WiSMART using VBA                                                            HOD Screen using
                                                                                                                              OLE Automation
   370 HOD P1 Uploader            P1 data is keyed into spreadsheet and then          Microsoft Excel 2003, VBA       yes     Transfers P1 data to
                                  transferred to WiSMART using VBA                                                            HOD Screen using
                                                                                                                              OLE Automation
   370 Smarterm 0$ CR Uploader CR data is keyed into spreadsheet and then             Microsoft Excel 2003, VBA       yes     Transfers CR data to
                               transferred to WiSMART using VBA                                                               Smarterm Screen
                                                                                                                              using OLE Automation

   370 Smarterm CR Uploader       CR data is keyed into spreadsheet and then          Microsoft Excel 2003, VBA       yes      Transfers CR data to
                                  transferred to WiSMART using VBA                                                             Smarterm Screen
                                                                                                                               using OLE Automation

   370 Smarterm JR Uploader       JR data is keyed into spreadsheet and then          Microsoft Excel 2003, VBA       yes      Transfers JR data to
                                  transferred to WiSMART using VBA                                                             Smarterm Screen
                                                                                                                               using OLE Automation

   370 Smarterm JV Uploader       JV data is keyed into spreadsheet and then          Microsoft Excel 2003, VBA       yes      Transfers JV data to
                                  transferred to WiSMART using VBA                                                             Smarterm Screen
                                                                                                                               using OLE Automation




     7a0341c9-e32d-4b3b-9d53-89ee86ee6df5.xls                     Updated 6/13/2006                                                       9 of 11
                                                              State of Wisconsin                                               Updated: June 9, 2006

                                                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
   370 Smarterm P1 Uploader       P1 data is keyed into spreadsheet and then          Microsoft Excel 2003, VBA        yes     Transfers P1 data to
                                  transferred to WiSMART using VBA                                                             Smarterm Screen
                                                                                                                               using OLE Automation

   435 EDS Weekly Voucher         Inputs P1 transaction to WISMART suspense file.     Microsoft Excel 2003, Host   Yes            Transfers P1 data to
                                                                                      On Demand (HOD)                             WISMART suspense
                                                                                                                                  file using an Excel
                                                                                                                                  spreadsheet to create
                                                                                                                                  an HOD macro

   435 Monthly GSB and Infotech Takes mainframe files generated by DOA and            TSO, PC-SAS, mainframe       Yes            Uploads P1 data to
       Payments to DOA          processes them to create P1 documents for             SAS, HOD                                    WISMART through
                                payment                                                                                           bridge.
   435 Multiple Payee Vouchers  Processes miscellaneous multiple payee vouchers       Microsoft Excel 2003, PC-    Yes            Uploads MW
                                such as AIDS/HIV Drug Reimbursement, Health           SAS, mainframe SAS, TSO                     documents to
                                Insurance Premium Subsidies, DDB Medical                                                          WISMART through
                                Consultants, Tuberculosis Drug Reimbursement,                                                     bridge. Actual
                                Refund of License payments.                                                                       payments are created
                                                                                                                                  through specialized
                                                                                                                                  check writer.

   445 Premisise Worksheets       Users track premisise information and associated    Excel                              Yes      Transfer account
                                  billing codes and save the information in RAPIDS                                                coding to RAPIDS for
                                  (A/P system) for use in coding invoices when                                                    premisis. RAPIDS
                                  received.                                                                                       then uses this
                                                                                                                                  information when
                                                                                                                                  creating P1's
   445 Spreadsheet Upload         This allows users to enter or copy and paste JR and Excel                              Yes      Transfer JV, JR to TED
                                  JV's into excel and upload them into TED to be                                                  to interface to
                                  formated, batched, and interfaced to WiSMART                                                    WISMART for posting

   445 Travel Database          Standalone database with rates and forms built-in.
                                Allows completion of travel vouchers with electronic
                                routing. These are then keyed into RAPIDS to
                                generate TL's
   485 JR/JV Upload Spreadsheet Transfers JR/JV data from spreadsheet to WISMART Miscrosoft Access 97                    Yes      Transfers JR/JV data
                                                                                                                                  to Attachmate Screen
                                                                                                                                  using OLE
                                                                                                                                  Automation


     7a0341c9-e32d-4b3b-9d53-89ee86ee6df5.xls                     Updated 6/13/2006                                                        10 of 11
                                                              State of Wisconsin                                           Updated: June 9, 2006

                                                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
   485 P1 Upload Spreadsheet       Transfers P1 data from spreadsheet to WISMART      Miscrosoft Access 97          Yes     Transfers P1 data to
                                                                                                                            Attachmate Screen
                                                                                                                            using OLE
                                                                                                                            Automation
   485 PV Upload Spreadsheet       Transfers PV data from spreadsheet to WISMART      Miscrosoft Access 97          Yes     Transfers PV data to
                                                                                                                            Attachmate Screen
                                                                                                                            using OLE
                                                                                                                            Automation
   505 P1 Macro Upload             Processes multi-line payment of invoices as a P1 on Excel                        Yes     Uploads P1 data
                                   WISMART                                                                                  through Host on
                                                                                                                            Demand
   505 SB Macro Upload             Processes agency payment of inter/intra agency     Excel                         Yes     Uploads SB data
                                   invoice                                                                                  through Host on
                                                                                                                            Demand
   510 N/A                         Agency does not use Macros or Uploads
   550 Assigned Council Division   Formats batch files of payment vouchers to         eOPD -- ACD Batch              Yes      File transfer via Host
       Batch Processing            WISMART P1 standard. The resulting file is                                                 On Demand
                                   uploaded to WISMART via Host On Demand
   585 Wagers - UPS2000            Processes unclaimed property claims and uploads    UPS2000 Unclaimed           One of 35   Transfers P1 data
                                   into WiSMART as P1 documents.                      Property Management       States Wagers
                                                                                      System, using Microsoft    & Associates
                                                                                      SQL Server and Crystal      contracts
                                                                                      Reports                        with.




     7a0341c9-e32d-4b3b-9d53-89ee86ee6df5.xls                     Updated 6/13/2006                                                    11 of 11

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:8/17/2011
language:English
pages:11
Description: System Information Travel Basis Data document sample