| published | permalink | layout | filename | title | page | redirect_from |
|---|---|---|---|---|---|---|
true |
/data-model/ |
article |
data-model.md |
Data Model |
data-model |
/data-exchange-standard/ |
June 30, 2017: Treasury released the DATA Act Information Model Schema (DAIMS) v1.1. DAIMS v1.1 is a minor update of the schema and will be implemented in fall 2017. Find out more information at DAIMS v1.1.
Updated January 5th, 2017 -- A core requirement of the DATA Act is the development of government-wide data standards to ensure the reporting of reliable, consistent federal spending data for public use. OMB and Treasury finalized the data definition standards and Treasury used the data definition standards to develop the initial draft of the DATA Act data exchange standard or Schema in May 2015. Treasury collected public input and feedback from federal agencies and implemented an agile development methodology to create the DATA Act Information Model Schema (DAIMS) v1.0. DAIMS v1.01 contains minor technical modifications to better align with other federal government source systems. These changes do not impact the data submissions that agencies make to the DATA Act Broker. Federal agencies can view the changes at the DATA Act Broker help page for more information.
DAIMS gives an overall view of the hundreds of distinct data elements used to tell the story of how federal dollars are spent. It includes artifacts that provide technical guidance for federal agencies about what data to report to Treasury including the authoritative sources of the data elements and the submission format. The DAIMS also provides clarity on how the public can better understand the inherent complexity of the data.
- Information Flow – provides an overview of the reporting timeframes and sources of the data included in the DAIMS across the federal enterprise.
- Reporting Submission Specification (RSS) – includes a listing of the data elements with specific instructions for federal agencies to submit content in the appropriate format. The RSS is a human-readable version of the data standard.
- Interface Definition Document (IDD) – contains a listing of the elements, with supporting metadata to understand what data will be pulled from government-wide systems for procurement and from agency financial assistance systems. The IDD is a human-readable version of the data standard for the award related content.
- DAIMS Diagrams – visual representations of how the data elements from the RSS and IDD fit together in context.
- Online Data Dictionary – a comprehensive list of data elements with definitions and some associated metadata.
- XBRL Schema Files – machine-readable version of the data standard that includes accounting-related and award-related content.
The Information Flow provides an overview of the sources of the data included in the DAIMS and how the data will be submitted to the DATA Act Broker. Treasury will maintain the current cadence for reporting federal awards on a daily and bi-weekly basis and add the quarterly reporting in May 2017. This model shows how the data flows from the agency financial and awards systems to reach the public website.
The RSS provides detail on what data needs to be submitted from an agency’s financial system. The RSS contains prescriptive guidance to report appropriations account, object class, program activity, and award financial data. The award financial data contains instructions to link the data between the financial systems and the award systems using the award identification number. The RSS includes information about optional/required data, field length, and other metadata to ensure data quality. The RSS documents contain the specific instructions a federal agency will need to submit data.
The RSS includes three files that the agencies will submit to Treasury’s Broker:
- File A – Appropriations Account Detail
- File B – Object Class and Program Activity Detail
- File C – Award Financial Detail
Federal agencies can view more information about the RSS on MAX{:target="_blank"}.
The Interface Definition Document (IDD) provides an overview of the award specific data elements and explains how the data will be reported or collected. Some data elements will be pulled from government-wide intermediary systems for procurement data, recipient attributes and sub award information. The IDD also includes data elements submitted by agency systems for financial assistance awards.
The IDD is based on the Data Model (DAIMS) v1.01 and features the elements related to:
- File D1 – Award and Awardee Attributes (Procurement)
- File D2 – Award and Awardee Attributes (Financial Assistance)
- File E – Additional Awardee Attributes
- File F – Sub-award Attributes
Federal agencies can view more information about the IDD on MAX{:target="_blank"}.
The diagrams are visual representations of how the different data elements are related. They show the groupings of elements and attributes.
The [Data Dictionary]({{ site.baseurl }}/dictionary/){:target="_blank"} is a comprehensive list of data elements with definitions and some associated metadata.
A data standard contains both a human-readable version of the standard and a machine-readable version of the standard. The XBRL Schema files are the machine-readable version of the DATA Act standard.
Zipped Schema Files with Release Notes (Updated on May 31, 2017)
Zipped Instance Documents with Data for Fiscal Year 2017 Quarter 2 (January to March 2017)
Zipped Instance Documents with Data for Fiscal Year 2017 Quarter 3 (April to June 2017)
The FFATA and DATA Act outline the required information for federal spending transparency reporting. These requirements were translated into core data definition standards that were standardized with feedback from the federal community and external stakeholders. The finalized definitions and background information for these elements are available on the [Data Elements Page]({{ site.baseurl }}/data-elements/){:target="_blank"}.