Copy of Visual FoxPro Module Inventory.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- ANF - Fox Pro Migration
- Solicitation number
- BD-27-1003-1003C-1003L-132040
- Issued by
- Massachusetts
About this file
This file is a Visual FoxPro Module Inventory document detailing legacy software components used by the Commonwealth of Massachusetts for state budgeting and financial management operations. The inventory catalogs approximately 200+ Visual FoxPro program modules organized by functional category, including data population for web systems, tax expenditure budgeting, capital queries, spending plan preparation, full-time equivalent (FTE) tracking, EASI data population, earmark processing, accounting system XML loads, and various SQL table population functions. The modules support critical state financial operations spanning legislative budget submissions, capital project tracking, cash flow analysis, grant management, and integration with the state's main accounting system (MBA). This inventory appears to be part of the ANF (Accounting and Budgeting System Modernization) Fox Pro Migration contract, which aims to modernize or replace the aging Visual FoxPro-based financial systems currently in use.
The document serves as a baseline reference for understanding the scope and complexity of systems requiring migration or modernization. With modules distributed across multiple functional domains and numerous interdependencies, the migration effort would require comprehensive understanding of each program's purpose, dependencies, and current data flows. The inventory indicates significant technical debt in maintaining Visual FoxPro code for contemporary state financial operations, suggesting the modernization initiative addresses both system obsolescence and the need to transition legacy functionality to more current technology platforms while preserving critical budgeting and accounting workflows.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| qr86_26.txt | TXT text file | |
| AF IT RFQ - FoxPro Module Replacement - Open.docx | DOCX document | |
| Copy of QRCAP1.xlsx | XLSX spreadsheet | |
| Copy of x86_26.xlsx | XLSX spreadsheet | |
| x86_26.DBF | DBF file | |
| qrcap1.DBF | DBF file |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| NAME | PRGNAME |
| Data Population for Web | MAKE_TAX |
| Data Population for Web | DRILL2B |
| Data Population for Web | DRILL25 |
| Data Population for Web | MAKEHIER |
| Data Population for Web | ORGCH1 |
| Data Population for Web | ORGTBL |
| Data Population for Web | POPCOMM5 |
| Data Population for Web | QR_FTE3B |
| Data Population for Web | POPSQLH7 |
| Data Population for Web | JAMIE_H1 |
| Data Population for Web | JSON1 |
| Data Population for Web | TRUSTNOT |
| Data Population for Web | ZZSUB1 |
| Data Population for Web | PUTOS0 |
| Data Population for Web | PUTOS1 |
| Data Population for Web | PUTOS2 |
| Tax Expenditure Budget | TAX_UP1 |
| Tax Expenditure Budget | TAX25C |
| Files for the Legislature | SPENDWM |
| Files for the Legislature | SUBWM |
| Files for the Legislature | REVWM |
| Capital Queries | QRCAP1 |
| Capital Queries | QRCAP2B |
| Capital Queries | CAPALL1 |
| Capital Queries | CAPSP25 |
| Capital Queries | CAPST26 |
| Capital Queries | DEAUTH26 |
| Capital Queries | LOOKCAP3 |
| Capital Queries | M_MP0 |
| Capital Queries | PAT_CAP |
| Capital Queries | POP_PLAN |
| Capital Queries | POPCP0 |
| Capital Queries | POPTASK1 |
| Capital Queries | QR86_26 |
| Capital Queries | QRCAP1A |
| Capital Queries | QRCAP2 |
| Capital Queries | QRCAP2C |
| Capital Queries | QRCAP4 |
| Capital Queries | QRCAP_26 |
| Capital Queries | QRCAP_Z |
| Capital Queries | QRMAYA1 |
| Capital Queries | CAPST1C |
| Capital Queries | QR_CAP3 |
| PATS Files | CHK_PAT |
| Preparation for Spending Plans | WORK1 |
| Preparation for Spending Plans | AUTOCB4 |
| Preparation for Spending Plans | POPGGS26 |
| Preparation for Spending Plans | SP_COPY0 |
| Preparation for Spending Plans | AGREE26A |
| Preparation for Spending Plans | COPY26 |
| Preparation for Spending Plans | DBAAX26A |
| Preparation for Spending Plans | DBAAXCH1 |
| Preparation for Spending Plans | POPCAL |
| Preparation for Spending Plans | POPSAL |
| Preparation for Spending Plans | POPSTP26 |
| Preparation for Spending Plans | POPWAH22 |
| Preparation for Spending Plans | POPWAH32 |
| Preparation for Spending Plans | TURN0_IB |
| Loading Data into MBA | QR_TRF3 |
| Loading Data into MBA | MBA_FTE0 |
| Old Foxpro Queries | QR_PS1 |
| Old Foxpro Queries | QRNM1B |
| Old Foxpro Queries | QRTRUST5 |
| Old Foxpro Queries | APP26 |
| Old Foxpro Queries | ASTAPR |
| Old Foxpro Queries | AUTOFIX6 |
| Old Foxpro Queries | AUTOTS26 |
| Old Foxpro Queries | BGT3B |
| Old Foxpro Queries | CFDA26 |
| Old Foxpro Queries | CHILD19 |
| Old Foxpro Queries | CONTACT5 |
| Old Foxpro Queries | DANNY2 |
| Old Foxpro Queries | EA_SP0 |
| Old Foxpro Queries | EXPENDA |
| Old Foxpro Queries | FEDLIST |
| Old Foxpro Queries | GETMBA1 |
| Old Foxpro Queries | LCM1 |
| Old Foxpro Queries | LEG_REV |
| Old Foxpro Queries | M_UP26 |
| Old Foxpro Queries | MM17A |
| Old Foxpro Queries | NMRL26 |
| Old Foxpro Queries | POPCH1 |
| Old Foxpro Queries | POPCHILD |
| Old Foxpro Queries | POPH1T26 |
| Old Foxpro Queries | POPJOBS |
| Old Foxpro Queries | POPWAH1 |
| Old Foxpro Queries | POPWAH2 |
| Old Foxpro Queries | QR_ARRA1 |
| Old Foxpro Queries | QR_ENC2 |
| Old Foxpro Queries | QR_JOB0 |
| Old Foxpro Queries | QR_JOB1 |
| Old Foxpro Queries | QR_PROG1 |
| Old Foxpro Queries | QR_PROG2 |
| Old Foxpro Queries | QR_REV0 |
| Old Foxpro Queries | QR_REV3 |
| Old Foxpro Queries | QR_REV5 |
| Old Foxpro Queries | QRBGTS0 |
| Old Foxpro Queries | QRBGTS6 |
| Old Foxpro Queries | QREXP0 |
| Old Foxpro Queries | QRF_ALL |
| Old Foxpro Queries | QRFED1 |
| Old Foxpro Queries | QRNM1A |
| Old Foxpro Queries | QRY1 |
| Old Foxpro Queries | QRY2 |
| Old Foxpro Queries | R_ACT26A |
| Old Foxpro Queries | R_ACT26B |
| Old Foxpro Queries | SH_REV0 |
| Old Foxpro Queries | SP_FED1 |
| Old Foxpro Queries | SP_FED2 |
| Old Foxpro Queries | TR_EXP |
| Old Foxpro Queries | BGCN1 |
| Old Foxpro Queries | CCM3 |
| Old Foxpro Queries | CHK_H1 |
| Old Foxpro Queries | DUMP1 |
| Old Foxpro Queries | EAR5YR |
| Old Foxpro Queries | GETOS0 |
| Old Foxpro Queries | GRANT2A |
| Old Foxpro Queries | QCGAA26 |
| Old Foxpro Queries | QR_BGTS1 |
| Old Foxpro Queries | QR_WM1 |
| Old Foxpro Queries | CTR_CHK |
| Old Foxpro Queries | RETREV1 |
| Old Foxpro Queries | UNROLL25 |
| Cash Flow | CASHBB26 |
| Cash Flow | CF1_26 |
| Cash Flow | CF2_26 |
| Cash Flow | CF1R_26 |
| Cash Flow | QRCF0 |
| Cash Flow | QRCF1 |
| Cash Flow | QRCF2 |
| FTE Tracker Population | DBZONE1 |
| FTE Tracker Population | DBZONE1B |
| FTE Tracker Population | DBZONE2 |
| FTE Tracker Population | POPFTE9B |
| FTE Tracker Population | FTECAP0 |
| FTE Tracker Population | FIXJOBS |
| FTE Tracker Population | WAH_SWFB |
| FTE Tracker Population | FTECAP |
| EASI Data Population | EASIAUTO |
| EASI Data Population | EASIBI26 |
| EASI Data Population | EASIC2 |
| EASI Data Population | EASIDEP |
| EASI Data Population | EASI26 |
| EASI Data Population | POPSP26 |
| EASI Data Population | EASISP_2 |
| EASI Data Population | EASISQL |
| EASI Data Population | EASISQL2 |
| EASI Data Population | EASISU26 |
| EASI Data Population | EASISUPP |
| EASI Data Population | QR_EASI1 |
| Update Analyst List | ATUP1 |
| Update Analyst List | EAR_ANT1 |
| Update Analyst List | ANTFED1 |
| Update Analyst List | ANTLIST1 |
| Update Analyst List | GETOSANT |
| Earmark Population | EARPOP1 |
| Earmark Population | EAR27A |
| Earmark Population | POPEAR2A |
| Earmark Population | POPEAR2B |
| Fix Chart of Accounts | FIX_H1D |
| Capital - CIP and Other Capital Work | JSON2 |
| Capital - CIP and Other Capital Work | CAP_POP6 |
| Accounting System XML Loads | LOADM8 |
| Accounting System XML Loads | XML1A |
| Accounting System XML Loads | ALLOT26 |
| Accounting System XML Loads | CBTA26 |
| Accounting System XML Loads | FIX0 |
| Accounting System XML Loads | SUPP26A |
| Accounting System XML Loads | H1LOAD26 |
| Accounting System XML Loads | POPAPP0 |
| Accounting System XML Loads | POPAPP0B |
| Accounting System XML Loads | POPAPP0F |
| Accounting System XML Loads | POPAPPC |
| Accounting System XML Loads | POPTS26 |
| Accounting System XML Loads | QRTS26 |
| Accounting System XML Loads | QRTS26A |
| Accounting System XML Loads | QRTS26B |
| Accounting System XML Loads | XML2 |
| Accounting System XML Loads | XML2B |
| MBA Loads | MBA_TRF |
| MBA Loads | SPEND9C |
| MBA Loads | ACCT_ANT |
| MBA Loads | CUT26A |
| MBA Loads | NON26MNT |
| MBA Loads | NON26POP |
| MBA Loads | PAR26A |
| MBA Loads | PAR26D |
| MBA Loads | POPMBA2 |
| MBA Loads | SMARTSUP |
| Populate Various SQL tables | WORKFLOW |
| Populate Various SQL tables | ADDFUND |
| Populate Various SQL tables | ADDSUPP |
| Populate Various SQL tables | CONTR1 |
| Populate Various SQL tables | QRLATE1 |
| Populate Various SQL tables | PUTOS3 |
| Populate Various SQL tables | SHACT26 |
| Populate Various SQL tables | SQLSPL26 |
| Populate Various SQL tables | TRUSTPOP |
| Populate Various SQL tables | LOADCASE |
File details come from the government source that posted it. Updated .