For the following Sample Data files, there are fields that are missing values when compared to the sample SQL (run against the "DataLab - 2024 Zips 2023-11-09" data set). In each case, the Sample Data field is empty, while the same field for sample SQL result is populated.
tlsaHousehold
RRHSOStatus
RRHSOMoveIn
tlsaPerson
RRHSOAgeMin
RRHSOAgeMax
HHTypeRRHSONoMI
HHTypeRRHSOMI
HHTypeES
HHTypeSH
HHTypeTH
HIV
SMI
SUD
tlsaEnrollment (the following was only present for one record, EnrollmentID 836523)
For the following Sample Data files, there are fields that are missing values when compared to the sample SQL (run against the "DataLab - 2024 Zips 2023-11-09" data set). In each case, the Sample Data field is empty, while the same field for sample SQL result is populated.
tlsaHousehold
tlsaPerson
tlsaEnrollment (the following was only present for one record, EnrollmentID 836523)