Get documents about "Visual Basic 2005 - Checks Email Format - Excel
Description
Visual Basic 2005 - Checks Email Format document sample
Document Sample
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.
2b0689ae-329a-4d92-91f3-b47a43a0be44.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.
2b0689ae-329a-4d92-91f3-b47a43a0be44.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
2b0689ae-329a-4d92-91f3-b47a43a0be44.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
2b0689ae-329a-4d92-91f3-b47a43a0be44.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.
2b0689ae-329a-4d92-91f3-b47a43a0be44.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
2b0689ae-329a-4d92-91f3-b47a43a0be44.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
2b0689ae-329a-4d92-91f3-b47a43a0be44.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.
2b0689ae-329a-4d92-91f3-b47a43a0be44.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
2b0689ae-329a-4d92-91f3-b47a43a0be44.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
2b0689ae-329a-4d92-91f3-b47a43a0be44.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.
2b0689ae-329a-4d92-91f3-b47a43a0be44.xls Updated 6/13/2006 11 of 11
Related docs
