Closed brentreeves75 closed 5 years ago
@brentreeves75 how does this look?
Fixed! Can not test the ETL functionality at this time. Could confirm that at UAT?
@KCI-Ablowers I think this will just be ETL'd to a text field. I don't know if there are any requirements or relationships in this field. Can you validate that hypothesis against the data reviewer rules and also the documentation?
Alright, I put this back as a text field called SAMPLE_SHA_STR_NO
with a length of 11, matching _SHA_STRNO. For good measure, I added a regex constraint to restrict entries to valid structure numbers only ^(\d{7})(.)(\d{3})$
.
Since the NPDES.INSPECTION field called SAMPLE_STR_ID
is a 42 char "Guid as a string", the ETL will need to translate the structure number to its structure ID. @johnshiu
🚀 ✅ fixed in Survey123 form release 2.1. Please delete and redownload the Survey to see the latest changes.
Need to have the functionality to enter the structure number where the sample was taken (Sample Structure Number); then during ETL the STRUCTURE_ID is populated in the field in the INSPECTION table in the QC version.