officeoffinancialmanagement.docVIP

Office of Financial Management Information Services Division Agency Financial Reporting System ADDS (AFRS Data Distribution System) User Documentation November 2006  Table of Contents Introduction What Is ADDS? AU- 1 ADDS Documentation AU- 1 Agency Infrastructure Agency Infrastructure AU- 1 ADDS Database Overview of ADDS Tables AU- 3 ADDS Database Size AU- 3 How to get ADDS AU- 3 How to get ADDS Tables AU- 4  What Is ADDS? ADDS (AFRS Data Distribution System) is AFRS data in a data architecture for flexible agency reporting. ADDS is extracted AFRS data (financial and text) that is converted on the mainframe to a relational format design and delivered to an output file at DIS. Each agency downloads the ADDS data for use in a relational database. The ADDS data in a relational database enables each agency to query and/or report on its detail and/or summary financial information. Each agency is responsible for placing the ADDS data into an appropriate RDBMS (Relational Database Management System), for providing customer query tools, data security and integrity, training and for database optimization to meet their individual reporting needs. OFM provides the data in a relational format, consultative services on implementing a download, SQL schema for building the relational tables, and training and documentation on understanding key AFRS concepts and the ADDS data and data structure. ADDS Documentation This document is one of a set of three, each of which fills a different need: ADDS User Documentation (this document) -- gives a general overview of ADDS and guidance in the implementation of ADDS. ADDS Data Definitions -- defines the tables, relationships and data elements used in ADDS. ADDS Technical Documentation -- covers technical information to assist the Information Systems personnel set up databases and download the ADDS data. Agency Infrastru