As an SBA user, I need to have the complex data validations in the web app.

[yehk]

Acceptance Criteria:

• [ ] Incorporate the current complex data validations from the current data elements guidance into the web app.
• [ ] Document how to add or change validations for handoff.

[drewleety]

Will address questions with Christina Ho in Kristina Yeh's absence week of 10/26.

[micahsaul]

As we’ve explored this story, we’ve discovered several important issues:

1) The original conception of "complex validations" involved validating data across the multiple submitted files. This has evolved over time, and the current complex validations all require validating against one of two external sources - namely, GTAS and OMB Circular A-11.

2) With the four separate file uploads, this external validation is actually easier technically, as it doesn't require cross-file rollup. Each validation requires data that lives in a single file.

3) However, there is no programmatic way to access GTAS data currently. A simple, proof-of-concept commandline tool has been written to perform Rule 6, but this involves hardcoded data. To query the GTAS spreadsheet we received would require reimplementation of the existing rules for aggregating GL accounts. Is this in scope for the broker?

4) Finally, it's worth noting that these types of validations (excluding the OMB circular) are inherently external validations, and can not be encoded in the schema.

[yehk]

Close due to separate story on implementing validation exist.