search

HMIS / LSASampleCode

Longitudinal System Analysis (LSA) Sample Code and Documentation
22 stars 10 forks source link

Upload was rejected because of ID 1300 #1165

Closed nataliesus closed 10 months ago

nataliesus commented 10 months ago

Hi @MollyMcEvilley ,

Test upload was rejected with next errors: image

Test data: image

Please notice both tlsa_HHID (hhid) and tlsa_Enrollment (n) have:

Programmed logic:

  1. household is included in lsa_Calculated as ReportRow = 4 because RRHPSHPreMoveInDays > 0
  2. to be included in lsa_Calculated for ReportRow = [53, 54, 55], n.AHAR = 1 condition must be true. But our single enrollment in the household has n.AHAR = 0, and, as a result, cannot be reported for ReportRow = [53, 54, 55].

Could you please take a look? Is it an issue in the upload validation rules? Please notice this issue is not reported in flags, instead, it stoppes the upload process with "failed" resolution.

Best regards, Natalie

MollyMcEvilley commented 10 months ago

Notes:

4 --> 53 4 --> 54 4 --> 55 4 is avg days homeless before move-in to RRH/PSH regardless of whether or not they moved in 53, 54, and 55 are counts of people in residence.

It is possible to have row 4 without 53, 54, and 55.

MollyMcEvilley commented 10 months ago

Ref #1171

JulesABrown commented 10 months ago

We agree and have put in a ticket to fix the issue. We will notify you when the fix is made.

JulesABrown commented 10 months ago

Updated on sandbox - please check.