define a csv structure for the download

[bpdesigns]

User story

As a \<type of user>, I want \<a goal> so that \<benefit>.

Acceptance criteria

• [ ]
• [ ]
• [ ]

Outstanding questions

• (if applicable)

Implementation notes

(if applicable)

[bpdesigns]

lets use these data columns: (top > down list representing left to right placement)

• [ ] Auditee name

• [ ] AUDITYEAR

• [ ] Fiscal year end date

• [ ] Audit accepted date

• [ ] Cog/oversight agency

• [ ] Questioned costs

• [ ] Repeat Findings (repeat the above row data for each finding in an audit)

• [ ] Findings #

• [ ] CFDA awards

• [ ] Finding text (from form)

• [ ] Finding text (from pdf)

• [ ] Corrective action plan (from form)

• [ ] Corrective action plan (from pdf) (the below will repeat across rows for multiple findings)

• [ ] Auditee EIN number

• [ ] Auditee DUNS number

• [ ] DBKEY

• [ ] Auditee contact information (see below for specifics)

• [ ] STREET1

• [ ] STREET2

• [ ] CITY

• [ ] STATE

• [ ] ZIPCODE

• [ ] AUDITEECONTACT

• [ ] AUDITEETITLE

• [ ] AUDITEEPHONE

• [ ] AUDITEEFAX

• [ ] AUDITEEEMAIL

• [ ] AUDITEEDATESIGNED

• [ ] Auditor contact information (see below for specifics)

• [ ] CPAFIRMNAME

• [ ] AUDITOR_EIN

• [ ] CPASTREET1

• [ ] CPASTREET2

• [ ] CPACITY

• [ ] CPASTATE

• [ ] CPAZIPCODE

• [ ] CPACONTACT

• [ ] CPATITLE

• [ ] CPAPHONE

• [ ] CPAFAX

• [ ] CPAEMAIL

• [ ] CPADATESIGNED

(and just to cover all the bases lets add these at the end - they can be found in the "CFDA INFO" and "GENERAL INFO" tabs)

• [ ] SP_FRAMEWORK
• [ ] SP_FRAMEWORK_REQUIRED
• [ ] TYPEREPORT_SP_FRAMEWORK
• [ ] GOINGCONCERN
• [ ] REPORTABLECONDITION/SIGNIFICANTDEFICIENCY
• [ ] MATERIALWEAKNESS
• [ ] MATERIALNONCOMPLIANCE
• [ ] Notes Content (“content” column in NOTES tab )

[bpdesigns]

For now - in these columns "Finding text (from pdf)" and "Corrective action plan (from pdf)" lets write. "Visit https://github.com/18F/FAC-Distiller/tree/master/distiller/extraction/ to run the extraction process. Automated pdf extraction to come if prototype is expanded."