search

HMIS / LSASampleCode

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

Step 10.5: both Sample Code and Spec: there is an issue for n.ExitDate is null (found by Flag 1338) #1190

Closed nataliesus closed 9 months ago

nataliesus commented 10 months ago

Hi @MollyMcEvilley ,

It looks like we need to update 10.5 for cases when n.ExitDate is null:

Because of Flag 1338 when lsa_HMISParticipation record is valid, n.ExitDate is null, but program is inserted into lsa_Calculated table for ReportRow = 906 as having "XXX client enrollments that are active during the report period and also overlap with a period of time in which the project was not identified as participating in HMIS" because of part.HMISParticipationStatusEndDate >= n.ExitDate condition.

Could you please take a look?

Thank you! Natalie

LaurenBianchi commented 10 months ago

Hello, Can we advocate for this to be added to the weebly site? Could be related to the current work on this ticket but we are getting reports of customers generating no data errors but having this flag thrown. Thank you for your time and insight!

nataliesus commented 9 months ago

Hi @MollyMcEvilley ,

Could you please update Spec in the current project and also on https://files.hudexchange.info/resources/documents/LSA-Programming-Specifications-2023.pdf to reflect the fix?

Thank you! Natalie