• Guides and Training Manuals

IDIS Online Appendix D Data Extract File Layouts

Date Published: July 2016

Description

Integrated Disbursement and Information System (IDIS) users with reporting privileges are allowed to download data-called data extracts-from IDIS database tables. There are seventeen categories of data that users can extract data; these categories include financial data for the Community Development Block Grant (CDBG), HOME Investment Partnerships (HOME), Housing Opportunities for Persons With AIDS (HOPWA), and Emergency Solutions Grants (ESG) Programs. Users can extract data by selecting the Data Downloads link, which appears under the Utilities option in IDIS.

This appendix provides:

• Instructions for requesting a data download.
• An alphabetical listing of the data extract files and the associated IDIS database tables. This listing also includes a brief description of the download data.
• A key to the layout structure of a data extract file.
• For each data category, a section that provides information to assist you in translating file names previously downloaded in legacy IDIS and where that data can be now found. The categories are described in the same order that they appear on the Data Downloads screen.

Note: This IDIS resource may not reflect grant based accounting requirements which HUD is implementing beginning with FY 2015 formula allocations. HUD has updated IDIS to phase out the first-in-first-out (FIFO) accounting methodology. These changes to IDIS ensure that formula funds are both committed and disbursed on a grant-specific basis, instead of using the FIFO (oldest money disbursed first) method that has been used for the CDBG, HOME, and HOPWA Programs to date. Grant funds are already committed and disbursed on a grant-specific basis for the ESG Program in IDIS. Funds from pre-2015 grants will continue to be committed and disbursed using the FIFO method.

Learn about grant based accounting requirements.

Resource Links

• IDIS Online Appendix D Data Extract File Layouts (PDF)