[Partner submission] [Data Validation] Data Length Validation for UEI/TIN (in addition to data type validation, which already exists)

usdigitalresponse / arpa-reporter

Web app to aid government agencies in reporting on ARPA grants.

Apache License 2.0

3 stars 0 forks source link

[Partner submission] [Data Validation] Data Length Validation for UEI/TIN (in addition to data type validation, which already exists) #456

Closed usdr-grants closed 2 years ago

usdr-grants commented 2 years ago

Submitted Description: Some agencies are submitting UEIs that are not 12 digits, or TINs that are not 9 digits.

The UST Portal kicks back an error; would be nice if the agencies were forced to address these via data validation prior to our test upload in UST portal.

(Optional) Uploaded file - click to download: https://www.jotform.com/uploads/grants.dev/212695501572052/5341687838215378611/Capture13.PNG

ozzie-chung commented 2 years ago

Did some more digging for this one after I submitted...the TIN starts with a 0, and entering the full TIN with the 0 into the Excel form removes the 0 (field treated as a number).

mhuang-usdr commented 2 years ago

Closing as obsolete.