Skip to content

Latest commit

 

History

History
98 lines (65 loc) · 8.86 KB

DAIMS-v1.1.md

File metadata and controls

98 lines (65 loc) · 8.86 KB
published permalink layout filename title page
true
/DAIMS-v1.1/
article
DAIMS-v1.1.md
DATA Act Information Model Schema v1.1
DAIMS-v1.1

The Latest

September 22, 2017: Treasury released the DATA Act Overview and Architecture documents. Please submit any questions or feedback to Community{:target="_blank"}.

DATA Act Information Model Schema v1.1

Released June 30, 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. Office of Management and Budget (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.1 is a minor update to transition financial assistance reporting to the DATA Act Broker, to better align with another federal government source system, and to provide clarifications for improved usability. DAIMS v1.1 will be implemented in production in fall 2017.

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.

DAIMS includes:
  • Overview and Architecture – provides an overview of the data standard and its architecture.
  • 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.
  • Domain Values - include permissible values for a sub-set of the DAIMS data elements.
  • Terse Labels - provide shortened versions of data element names.
  • DAIMS Diagrams – display visual representations of how the data elements from the RSS and IDD fit together in context.
  • Online Data Dictionary – contains a comprehensive list of data elements with definitions and some associated metadata.
  • XBRL Schema Files – provide a machine-readable version of the data standards that include accounting-related and award-related content.

Overview and Architecture

The DAIMS Overview{:target="_blank"} describes the scope and value of the data standard. The DAIMS Architecture details the data standard conceptual model, specifications, and schema management. The DAIMS architecture is designed to meet the needs of the business users and technical systems. It serves as the foundation for the DAIMS data standard. It is extensible through domain, component, element, and metadata. Additional descriptive content on the DAIMS architecture will be released as necessary. Please submit any questions or feedback to Community{:target="_blank"}.

Information Flow

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 twice-monthly basis and added the quarterly reporting of financial data in May 2017. This updated model shows how the data flows from the agency financial and awards systems to the public website and will be implemented in fall 2017.

Reporting Submission Specification (RSS)

The RSS provides details 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

Download the RSS v1.1

Interface Definition Document (IDD)

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 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

Download the IDD v1.1

Domain Values

The domain values include permissible values for a sub-set of the DAIMS data elements.

Terse Label

The terse labels provide shortened versions of data element names.

DAIMS Diagrams

The diagrams are visual representations of how the different data elements are related. They show the groupings of elements and attributes.

Online Data Dictionary

The [Data Dictionary v1.1]({{ site.baseurl }}/dictionary-v1.1/){:target="_blank"} is a comprehensive list of data elements with definitions and some associated metadata.

XBRL Schema and Data Files

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 June 30, 2017)

Data Definition Standards

The Federal Funding Accountability and Transparency Act (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"}.