Question about hp1 logic in Step 3.3.1

HMIS / LSASampleCode

Longitudinal System Analysis (LSA) Sample Code and Documentation

22 stars 10 forks source link

Question about hp1 logic in Step 3.3.1 #1323

Closed evaripatis closed 3 weeks ago

evaripatis commented 3 weeks ago

I may be missing something, but wouldn't the hp1 logic (see screenshot) reduce your tlsa_HHID data to only records associated with a single project? Are we truly grabbing the top 1 HMISParticipationID, or is this really supposed to be the top 1 according to a certain grouping?

evaripatis commented 3 weeks ago

This excerpt, from Step 3.3 in the specifications document, makes it seem like it should be the top 1 HMISParticipationID per ProjectID.

nataliesus commented 3 weeks ago

Hi @evaripatis ,

Just in case, isn't hp1.ProjectID = hoh.ProjectID what you are looking for?

Best regards, Natalie

evaripatis commented 3 weeks ago

Hey @nataliesus, I appreciate that, thanks! I think I was expecting to see something like that outside of the sub-query, which is likely why I missed it.

This ticket can be closed.