Epic: Validation improvements 1

[jadudm]

From walking the instructions and help desk tickets, we've identified additional improvements to the validations. These are easier/possible now that we have a new intake validation framework in front of the schemas.

Tasks

Preview Give feedback

1. [INTAKE]: Add a Validation Check for the sum calculations in Federal Awards Workbook. #2509
   3 of 3
   eng +1
   
2. Check Workbook Version #2514
   eng +1
   
3. [INTAKE]: If Q is N, R must be blank #2506
   eng +1
   
4. [INTAKE]: Handling of loan balances - integers #2504
   eng +1
   
5. [INTAKE]: Mistake in loan guarantee validation #2503
   eng +1
   
6. [INTAKE]: Add RD and U validations to new workbook vals #2501
   eng +1
   
7. [INTAKE]: Unique check on passthroguh name/id number #2505
   eng +1
   
8. [INTAKE]: Assert all dollar amounts are integers #2507
   eng +1
   
9. Add Validation check for Number of Passthrough Names/Ids #2523
   eng +1
   
10. 2499 activate wrap text in workbook #2518
    eng +1
    
11. [INTAKE] Improve validations on audit findings workbook #2553
    0 of 6
    eng +1
    
12. [INTAKE] Notes to SEFA improvements #2552
    2 of 2
    eng +1
    
13. [INTAKE] Add Transform to Reprocess All Hidden Columns in FederalsAwards #2562
    eng +1
    
14. Workbook validation improvement: Spaces in T3 #2460
    eng +1
    
15. Add validation check for prior references pattern #2625
    eng +1
    
16. [INTAKE] Add transform for cfda_key #2567
    eng +1
    
17. Add Validation Check for All Required Fields #2717
    6 of 6
    eng +1
    
18. Consolidate General Information Schema Validation #2819
    eng +1
    
19. Update Help Link in AdditionalEins Template #2877
    eng +1
    
20. Update Cluster Name Validation Rule to Allow N/A #3077
    eng +1
    
21. Allow Zero Loan Balance when Loan is Guaranteed #3095
    eng +1
    
22. Update Logic to Prevent Exception 500 in Case of Unknown Mal-formed Named Ranges #2792
    eng +1