Reading recovery.gov I noticed this link
http://www.recovery.gov/files/Initial%20Recovery%20Act%20Implementing...
On page(s) 57 - 59 is the database field requirements for storing the
data required for reporting to recovery.gov.
As I was reading the document it read like the SPEC.
I'm going to start converting the field def to sql.
Read doc and let me know if you're interested in trying to create a
system that at least exports the data in required format.
from doc: preferred: Atom1.0 and RSS
Appendix 1 – Detailed Instructions on Transmitting Materials
This appendix currently includes transmission instructions for the
following information flows:
Major Communications (Section 2.2), Formula Block Grant Allocations
(Section 2.3), and
Weekly Reports (Section 2.4). Future guidance will include
instructions for the submission of
the reports required in sections 2.5 through 2.9.
For each of the near term reporting requirements (major
communications, formula block grant
allocations, weekly reports) agencies are required to provide a feed
(preferred: Atom 1.0,
acceptable: RSS) of the information so that content can be delivered
via subscription. Note that
the required information can be supplied in the feed or the feed can
point to a file at the agency
using the convention noted below. If an agency is immediately unable
to publish feeds, the
agency should post each near term information flow (major
communications, formula block
grant allocations, weekly reports) to a URL directory convention
suggested below:
www.agency.gov/recovery/year/month/date/reporttype. It is expected
that the information files
will be posted at the following URLs:
• Major Communications: www.HUD.gov/recovery/2009/02/16/comms
• Formula Block Grant Allocation: www.HUD.gov/recovery/2009/02/16/fbga
• Weekly Report: www.HUD.gov/recovery/2009/03/01/weekly
In addition to posting the files either via feed or the URL structure,
agencies are also required to
email the files to the following email address:
recoveryupda...@gsa.gov. Emails should have a
subject in the following format: Official Agency Abbreviation, Report
Type. For example:
• HUD, Major Communications
• HUD, Formula Block Grant Allocation
• HUD, Weekly Report #X
Note that the body of the email should include the appropriate
completed template as an
attachment and should include the name, title, and contact information
for the submitter.
Templates for these files can be found at https://max.omb.gov/community/x/doC2Dw.