IRS intends to award Purchase Order for Compliance Data Warehouse support to Translate Program Requirements

Re: Solicitation Number: TIRNO-19-Q-72687

“The Internal Revenue Service (IRS) intends to award a purchase order for support to Translate Program Requirements for Three Data Extracts to Run and Produce Output from the IRS Compliance Data Warehouse (CDW).”

“The Statistics of Income (SOI) currently arranges for data file extracts based on returns posted to the IRS Business Master File (BMF). These extracts have as their data source the IRS Business Returns Transaction File (BRTF). SOI is planning to change the data source to the IRS Compliance Data Warehouse (CDW) for improved management of resources devoted to these extracts. The CDW is a data repository for the population of returns posted and is maintained by the Data Management Division (DMD) of Research, Applied Analytics, and Statistics (RAAS). It pulls in data from the BRTF but assigns different nomenclature, such that a data variable shall have one name on the BRTF and a different one on the CDW. This data repository consists of a vast number of database tables, which requires a…”

“ … Write programming code using SQL, SAS or the R programming language to produce data files from the CDW for each of the three subject extracts. Existing program requirements packages (PRP) used to document the current process for extracting the data directly from the BRTF shall be used, as the current programs are written in Assembler Language. As part of the programming code, it shall be necessary to determine and incorporate the correct variable names on the CDW for each extract. It shall also be necessary to incorporate the correct programmatic processes to link different data variables among different CDW database tables to achieve the correct results. For any cases in which programmatic requirements are unclear in the PRPs, consult with designated SOI staff to help determine correct course of action. Once all code is written and in consultation with SOI staff, determine the Business Master File (BMF) posting cycles for which the programs written in SQL, SAS or R for each of the three extracts referred to II A. and II B. shall be run from the CDW. Run the code and extract resulting output for agreed upon posting cycles into a file for review. In consultation with SOI staff, compare results from same cycle extracts previously run directly from the BRTF to extracts run from the CDW in II D. Identify and determine causes for differences. Determine course of action to produce correct results and adjust new programming code as needed. Repeat runs from the CDW to produce correct results. Document any changes needed to the respective PRPs resulting from the comparison and course of action in II E and provide to SOI. Scope of work needed for the remaining two extracts will be determined by SOI.”

Read more here.


This topic contains 0 replies, has 1 voice, and was last updated by  Jackie Gilbert 1 year, 8 months ago.

  • Author
  • #75529

    Replies viewable by members only


You must be logged in to reply to this topic.


Questions?. Send us an email and we'll get back to you, asap.


©2021 MileMarker10, LLC all rights reserved | Community and Member Guidelines | Privacy Policy | About G2Xchange FedCiv

Opportunities. Starting Points.

About our Data

The Vault is a listing of expiring contracts, task orders, etc. within a certain set of parameters, to include:

  • Have an initial total estimated contract value of $10 million or above
  • Federal Civilian Only – DHS, Transportation, Justice, Labor, Interior, Commerce, Energy, State, and Treasury Actions
  • NAICS codes include: 511210, 518210, 519130, 519190, 541511,
    541513, 541519, 541611, 541618,
    541690, 541720, 541990
  • Were modified within the last 12 calendar months
  • The data represented is based on information provided by the government

Who has access? Please note that ALL G2Xchange FedCiv Members will receive access to all basic and much of the advanced data. G2Xchange FedCiv Corporate Members will receive access to ALL Vault content (basic and advanced).

Feedback/Suggestions? Contact us at and let us know what you think. 

G2Xchange FedCiv

Log in with your credentials for G2Xchange FedCiv

Forgot your details?