search

HMIS / LSASampleCode

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

Step 7.4.2: LastActive question #762

Closed nataliesus closed 3 years ago

nataliesus commented 3 years ago

Hi @MollyMcEvilley ,

Here is a part of spec: image

1. What exactly fields are hidden by "chronic homelessness"? Are they all tlsa_ExitHoHAdult fields? If yes, then it makes sense that you use step 7.4.1. But if "chronic homelessness" is CHStart only, then it is not correct to apply ex.HHChronic is null in step 7.4.2. Please advise.

1. From the spec it is not obvious from which table EntryDate, ExitDate, and MoveInDate should be used. We have them in both tlsa_HHID and tlsa_Enrollment. Sample Code uses tlsa_HHID table, but this table is not listed in Source section (Spec). Also, EntryDate is not in Source section at all.

Please advise.

Thank you! Natalie

MollyMcEvilley commented 3 years ago

7.4.1 - HHChronic = 0 is set based on tlsa_HHID entry/exit/move-in dates. I added tlsa_HHID to the list of Source tables and clarified this in the specs.
image 7.4.2 - For the HHChronic = 0 records in tlsa_Exit, we don't need to go through any of the CH determination process in 7-5-7.8, so it's appropriate to exclude them ('WHERE es.HHChronic is NULL') in 7.4.2.

(Commit forthcoming.)

MollyMcEvilley commented 3 years ago

This update / clarification has been committed and is in the current version of the specs... I failed to note that the commit closes this issue. image