search

HMIS / LSASampleCode

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

Sample SQL Quick Fix: Incorrect Step Number in 8.3 #1204

Closed evaripatis closed 10 months ago

evaripatis commented 10 months ago

The Step value for the following should be 8.3.48, not 8.3.58.

    insert into tlsa_AveragePops (PopID, Cohort, HoHID, HHType, Step)
    select distinct 46, ex.Cohort, ex.HoHID, ex.HHType, '8.3.58'
    from tlsa_Exit ex
    where ex.HHParent = 1 and ex.HHType = 3