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

NAMEPRGNAME
Data Population for WebMAKE_TAX
Data Population for WebDRILL2B
Data Population for WebDRILL25
Data Population for WebMAKEHIER
Data Population for WebORGCH1
Data Population for WebORGTBL
Data Population for WebPOPCOMM5
Data Population for WebQR_FTE3B
Data Population for WebPOPSQLH7
Data Population for WebJAMIE_H1
Data Population for WebJSON1
Data Population for WebTRUSTNOT
Data Population for WebZZSUB1
Data Population for WebPUTOS0
Data Population for WebPUTOS1
Data Population for WebPUTOS2
Tax Expenditure BudgetTAX_UP1
Tax Expenditure BudgetTAX25C
Files for the LegislatureSPENDWM
Files for the LegislatureSUBWM
Files for the LegislatureREVWM
Capital QueriesQRCAP1
Capital QueriesQRCAP2B
Capital QueriesCAPALL1
Capital QueriesCAPSP25
Capital QueriesCAPST26
Capital QueriesDEAUTH26
Capital QueriesLOOKCAP3
Capital QueriesM_MP0
Capital QueriesPAT_CAP
Capital QueriesPOP_PLAN
Capital QueriesPOPCP0
Capital QueriesPOPTASK1
Capital QueriesQR86_26
Capital QueriesQRCAP1A
Capital QueriesQRCAP2
Capital QueriesQRCAP2C
Capital QueriesQRCAP4
Capital QueriesQRCAP_26
Capital QueriesQRCAP_Z
Capital QueriesQRMAYA1
Capital QueriesCAPST1C
Capital QueriesQR_CAP3
PATS FilesCHK_PAT
Preparation for Spending PlansWORK1
Preparation for Spending PlansAUTOCB4
Preparation for Spending PlansPOPGGS26
Preparation for Spending PlansSP_COPY0
Preparation for Spending PlansAGREE26A
Preparation for Spending PlansCOPY26
Preparation for Spending PlansDBAAX26A
Preparation for Spending PlansDBAAXCH1
Preparation for Spending PlansPOPCAL
Preparation for Spending PlansPOPSAL
Preparation for Spending PlansPOPSTP26
Preparation for Spending PlansPOPWAH22
Preparation for Spending PlansPOPWAH32
Preparation for Spending PlansTURN0_IB
Loading Data into MBAQR_TRF3
Loading Data into MBAMBA_FTE0
Old Foxpro QueriesQR_PS1
Old Foxpro QueriesQRNM1B
Old Foxpro QueriesQRTRUST5
Old Foxpro QueriesAPP26
Old Foxpro QueriesASTAPR
Old Foxpro QueriesAUTOFIX6
Old Foxpro QueriesAUTOTS26
Old Foxpro QueriesBGT3B
Old Foxpro QueriesCFDA26
Old Foxpro QueriesCHILD19
Old Foxpro QueriesCONTACT5
Old Foxpro QueriesDANNY2
Old Foxpro QueriesEA_SP0
Old Foxpro QueriesEXPENDA
Old Foxpro QueriesFEDLIST
Old Foxpro QueriesGETMBA1
Old Foxpro QueriesLCM1
Old Foxpro QueriesLEG_REV
Old Foxpro QueriesM_UP26
Old Foxpro QueriesMM17A
Old Foxpro QueriesNMRL26
Old Foxpro QueriesPOPCH1
Old Foxpro QueriesPOPCHILD
Old Foxpro QueriesPOPH1T26
Old Foxpro QueriesPOPJOBS
Old Foxpro QueriesPOPWAH1
Old Foxpro QueriesPOPWAH2
Old Foxpro QueriesQR_ARRA1
Old Foxpro QueriesQR_ENC2
Old Foxpro QueriesQR_JOB0
Old Foxpro QueriesQR_JOB1
Old Foxpro QueriesQR_PROG1
Old Foxpro QueriesQR_PROG2
Old Foxpro QueriesQR_REV0
Old Foxpro QueriesQR_REV3
Old Foxpro QueriesQR_REV5
Old Foxpro QueriesQRBGTS0
Old Foxpro QueriesQRBGTS6
Old Foxpro QueriesQREXP0
Old Foxpro QueriesQRF_ALL
Old Foxpro QueriesQRFED1
Old Foxpro QueriesQRNM1A
Old Foxpro QueriesQRY1
Old Foxpro QueriesQRY2
Old Foxpro QueriesR_ACT26A
Old Foxpro QueriesR_ACT26B
Old Foxpro QueriesSH_REV0
Old Foxpro QueriesSP_FED1
Old Foxpro QueriesSP_FED2
Old Foxpro QueriesTR_EXP
Old Foxpro QueriesBGCN1
Old Foxpro QueriesCCM3
Old Foxpro QueriesCHK_H1
Old Foxpro QueriesDUMP1
Old Foxpro QueriesEAR5YR
Old Foxpro QueriesGETOS0
Old Foxpro QueriesGRANT2A
Old Foxpro QueriesQCGAA26
Old Foxpro QueriesQR_BGTS1
Old Foxpro QueriesQR_WM1
Old Foxpro QueriesCTR_CHK
Old Foxpro QueriesRETREV1
Old Foxpro QueriesUNROLL25
Cash FlowCASHBB26
Cash FlowCF1_26
Cash FlowCF2_26
Cash FlowCF1R_26
Cash FlowQRCF0
Cash FlowQRCF1
Cash FlowQRCF2
FTE Tracker PopulationDBZONE1
FTE Tracker PopulationDBZONE1B
FTE Tracker PopulationDBZONE2
FTE Tracker PopulationPOPFTE9B
FTE Tracker PopulationFTECAP0
FTE Tracker PopulationFIXJOBS
FTE Tracker PopulationWAH_SWFB
FTE Tracker PopulationFTECAP
EASI Data PopulationEASIAUTO
EASI Data PopulationEASIBI26
EASI Data PopulationEASIC2
EASI Data PopulationEASIDEP
EASI Data PopulationEASI26
EASI Data PopulationPOPSP26
EASI Data PopulationEASISP_2
EASI Data PopulationEASISQL
EASI Data PopulationEASISQL2
EASI Data PopulationEASISU26
EASI Data PopulationEASISUPP
EASI Data PopulationQR_EASI1
Update Analyst ListATUP1
Update Analyst ListEAR_ANT1
Update Analyst ListANTFED1
Update Analyst ListANTLIST1
Update Analyst ListGETOSANT
Earmark PopulationEARPOP1
Earmark PopulationEAR27A
Earmark PopulationPOPEAR2A
Earmark PopulationPOPEAR2B
Fix Chart of AccountsFIX_H1D
Capital - CIP and Other Capital WorkJSON2
Capital - CIP and Other Capital WorkCAP_POP6
Accounting System XML LoadsLOADM8
Accounting System XML LoadsXML1A
Accounting System XML LoadsALLOT26
Accounting System XML LoadsCBTA26
Accounting System XML LoadsFIX0
Accounting System XML LoadsSUPP26A
Accounting System XML LoadsH1LOAD26
Accounting System XML LoadsPOPAPP0
Accounting System XML LoadsPOPAPP0B
Accounting System XML LoadsPOPAPP0F
Accounting System XML LoadsPOPAPPC
Accounting System XML LoadsPOPTS26
Accounting System XML LoadsQRTS26
Accounting System XML LoadsQRTS26A
Accounting System XML LoadsQRTS26B
Accounting System XML LoadsXML2
Accounting System XML LoadsXML2B
MBA LoadsMBA_TRF
MBA LoadsSPEND9C
MBA LoadsACCT_ANT
MBA LoadsCUT26A
MBA LoadsNON26MNT
MBA LoadsNON26POP
MBA LoadsPAR26A
MBA LoadsPAR26D
MBA LoadsPOPMBA2
MBA LoadsSMARTSUP
Populate Various SQL tablesWORKFLOW
Populate Various SQL tablesADDFUND
Populate Various SQL tablesADDSUPP
Populate Various SQL tablesCONTR1
Populate Various SQL tablesQRLATE1
Populate Various SQL tablesPUTOS3
Populate Various SQL tablesSHACT26
Populate Various SQL tablesSQLSPL26
Populate Various SQL tablesTRUSTPOP
Populate Various SQL tablesLOADCASE

File details come from the government source that posted it. Updated .