Accounting Life Insurance Transactions by bqy69086

VIEWS: 17 PAGES: 11

More Info
									                                                                                                      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
                                                                                                                                     Reports                     with 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.

          8dc1a47f-0ef7-4b7d-a753-92c5aeaf443e.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              No                              Yes      Oracle DB, SQL, Developer   IT
        Transfer (JVs)               JV transactions to transfer labor costs to projects.                                                Forms/Reports, PL/SQL,
                                                                                                                                         Unix, DBMS_JOB
    370 Cost Accounting -            DNR's Cost Accounting System (CARS) generates              No                              Yes      Oracle DB, SQL, Developer   IK
        Supplies & Services          JV transactions to prorate allocable Supplies &                                                     Forms/Reports, PL/SQL,
        Allocation Assignment        services costs to direct activities by sub-program.                                                 Unix, DBMS_JOB
        (JVs)                        Costs are moved from a primary appropriation to
                                     the appropriate funding sources.

    370 Cost Accounting -            DNR's Cost Accounting System (CARS) generates              No                              Yes      Oracle DB, SQL, Developer   IG
        Supplies & Services          JV transactions to prorate supplies and services                                                    Forms/Reports, PL/SQL,
        Assignment (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.                No                              Yes      Cobol, SAS, JCL             IQ
                                     Data 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              No                              Yes      Cobol, SAS, JCL             IF
        AID (P1s)                    land 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,            No                              Yes      Cobol, SAS, JCL             IY
        (P1s)                        tax is paid by owners to townships and DNR. Data
                                     is generated by the Forestry sub-system to create
                                     P1 transactions.




          8dc1a47f-0ef7-4b7d-a753-92c5aeaf443e.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             No                                 Yes         COBOL, SAS              CN, CM                 Uploads MW documents to WISMART
                                     Assistance 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.


          8dc1a47f-0ef7-4b7d-a753-92c5aeaf443e.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 BPS                         Benefit Claim System - UI - creates check                No                              Yes                               None - MW done
                                    transition file for all UI claims - interfaces to                                                                          manually on WISMART
                                    FIRSTAR for processing (print and mail checks)                                                                             for checkwriters

   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,
                                    information which is also manually keyed as a MW                                                                           MW mannually done
                                    daily. This also records and processes spreadsheet                                                                         on 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                      No                             Yes    Cobal                       Interface to TED
       DOA General Services Bill) electronic 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


         8dc1a47f-0ef7-4b7d-a753-92c5aeaf443e.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                                                                                         WISMART, HRS
                                    cardholders when statements are downloaded.                                                                                 system for supervisory
                                    Cardholders then log into PAL and code their                                                                                hierarchy for
                                    purchases and complete descriptions of what was                                                                             automatic emails
                                    purchased. This 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.


         8dc1a47f-0ef7-4b7d-a753-92c5aeaf443e.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               Yes         RMS                 No                                    Interface to CORE
                                     is 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            No                             Yes      Visual Basic, Oracle PLSQL, FM - WI
                                     from DWD to WISMART go through TED. Ted                                                            Oracle, Windows Batch files JR - 15
                                     creates documents from electronic files, validates                                                                             JV - WD
                                     codes, allows users to edit docs as needed, and                                                                                PO - 17
                                     then batches and sends to WISMART on a nightly                                                                                 P1 - 13
                                     basis. TED also downloads all posted documents                                                                                 TL - T2
                                     from 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
                                     & Work Injury Supplemental, these transactions                                                                                   on WISMART in
                                     are not interfaced to WISMART, but a manual                                                                                      summary
                                     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




          8dc1a47f-0ef7-4b7d-a753-92c5aeaf443e.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,       Interface from TED
                                    Warehouse. WISARD is DWD's sole financial                                                       VB.NET, Windows Batch     and WISMART,
                                    reporting tool. WISARD interfaces to WISMART,                                                   Files                     RAPIDS and 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              Yes, but   STARS, purchased         No     Not sure, C Sharp?         Interface ID: E2
       (Statistical Tracking &      compensation claims for State Risk Management       modified    from Marsh USA
       Reporting System)            program and 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
       Program)                     electronic fund transfer P1's to WISMART.                                                                                 EFT 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           yes            Excel                                                Payment information
       System                       from funds from SWIB                                                                                                      keyed into Wismart


         8dc1a47f-0ef7-4b7d-a753-92c5aeaf443e.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.




          8dc1a47f-0ef7-4b7d-a753-92c5aeaf443e.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


     8dc1a47f-0ef7-4b7d-a753-92c5aeaf443e.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 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

   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
                                   JV's into excel and upload them into TED to be                                                     TED 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

     8dc1a47f-0ef7-4b7d-a753-92c5aeaf443e.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 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

    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
                                                                                       System, using Microsoft    Wagers &
                                                                                       SQL Server and Crystal     Associates
                                                                                       Reports                    contracts
                                                                                                                     with.




      8dc1a47f-0ef7-4b7d-a753-92c5aeaf443e.xls                     Updated 6/13/2006                                                   11 of 11

								
To top