research questions: source data (JAAMS and Prism)

[bsweger]

Sprint 1 research questions about the actual source data files:

1. Would it be possible to get Prism text files that have quoted data?
2. The following tables were referenced in the SBA-->DATA Act mapping doc but weren't included in the data we got. Could we have extracts of these too?
   • Prism: docaddr (mapped to awarding office name)
   • Prism: vendor2 (mapped to recipient type)
   • JAAMS: find_flex_values_vl (mapped to funding office)
3. We might have mis-matched years in JAAMS and Prism. The Prism sql (data/prism/joins.txt) is grabbing records with a status date between 10/10/2014 and 10/1/2015 (i.e., FY 2015). Not sure if that's the code used to generate our sample data, but mismatched fiscal years could explain why we only matched a single award.

[bsweger]

Addressed most of this on a call this morning. We confirmed that the Prism data reflected a different year than the JAAMS data (we tested this theory by running a new test file while on the call). SBA will send a new set of Prism data that contains FY 2014 data. They'll also quote it, and we've requested the docaddr and vendor2 tables.

Left to do: ask for the JAAMS find_flex_values_vl table.

[bsweger]

Update:

• the new, quoted files from Prism work great and we're able to match the awards
• don't need vendor2 anymore: no longer in the mapping document
• don't need find_flex_values_vl: no longer in the mapping document
• got docaddr in the latest round of Prism data

That closes everything here.