{"push_id":2987426102,"size":26,"distinct_size":1,"ref":"refs/heads/performance","head":"a4a5fab4e2b3eadc92ed00c2b77fe636a5f88f96","before":"fe673392ab04937d96b655b43f5c6cdc35b70f84","commits":[{"sha":"bbf13a0158ee625a927bdef2603640b74b601f49","author":{"name":"Elliot Anders","email":"fd1fa7585829f3669cbcc7f37f4dc18117e1cfba@greenriver.org"},"message":"Convert unicode hyphen to minus","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/bbf13a0158ee625a927bdef2603640b74b601f49"},{"sha":"a9586cbfb299d6f6f04fd66a5291781dcb9a6172","author":{"name":"Elliot Anders","email":"fd1fa7585829f3669cbcc7f37f4dc18117e1cfba@greenriver.org"},"message":"Merge branch 'master' into character-encoding-issues","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/a9586cbfb299d6f6f04fd66a5291781dcb9a6172"},{"sha":"8b23eb39fe8230c25bce7a8247ee0d512e72e301","author":{"name":"Elliot Anders","email":"fd1fa7585829f3669cbcc7f37f4dc18117e1cfba@greenriver.org"},"message":"Merge branch 'master' into character-encoding-issues","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/8b23eb39fe8230c25bce7a8247ee0d512e72e301"},{"sha":"5ea93f73db0c07ed148a91504a3618e7373f8bc3","author":{"name":"Elliot Anders","email":"fd1fa7585829f3669cbcc7f37f4dc18117e1cfba@greenriver.org"},"message":"Additional unprintable characters converted to dashes","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/5ea93f73db0c07ed148a91504a3618e7373f8bc3"},{"sha":"c570369c4c3ea3075a0ddfa2ca8a676dfb439a83","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\nCorrect set of tmp_Person.HHAdultAge in section 4.23 to pull from active_Household and not active_Enrollment","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/c570369c4c3ea3075a0ddfa2ca8a676dfb439a83"},{"sha":"04e4d0b4cb7f3b91e8f083640390b357880d61e0","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\nAlign code in section 4.37 Update ESTStatus and RRHStatus with specs / add join to sys_Time (issue #24 )","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/04e4d0b4cb7f3b91e8f083640390b357880d61e0"},{"sha":"48ef1a0ced201418dcb27ec961ab5ac7f9b95f5c","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\n4.38 Set SystemPath for LSAHousehold - use 'ESTStatus = 0' instead of 'ESDays <= 0 and THDays <= 0'  for SystemPath 4, 8, and 11 (no impact on output; modified for consistency with specs). (issue #23 and AAQ)","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/48ef1a0ced201418dcb27ec961ab5ac7f9b95f5c"},{"sha":"13b15ff56242b483538730f4489a7971f2a0e113","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\n4.28.d Set tmp_Household Destination for Each Project Group - populate EST/RRH/PSHDestination based on most recent EXIT from project group (and NOT exit for enrollment with most recent entry date)","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/13b15ff56242b483538730f4489a7971f2a0e113"},{"sha":"7696e93133af5e5c0f65e6f4752fcdf3f687d911","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\n4.64 Get Counts of People by Project Type and Personal Characteristics - exclude PopID 100, which is not required by specs (issue #8)","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/7696e93133af5e5c0f65e6f4752fcdf3f687d911"},{"sha":"6e466214c0555744f3eb2f001d154549cad06013","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\n4.32 Get Enrollments Relevant to Last Inactive Date and Other System Use Days - for active enrollments, use HHType as already calculated; otherwise, use HHType based on HH member age(s) at project entry. (Issue #26 originally submitted via AAQ.)","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/6e466214c0555744f3eb2f001d154549cad06013"},{"sha":"6856da4cc769ce43b0cba8f9ea03dc224a11c47c","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\n4.46 Get Other Enrollments Relevant to Exit Cohort System Path - use HHType as already calculated for StatEnrollmentID; otherwise, use HHType based on HH member age(s) at project entry from subquery. (issue #28)","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/6856da4cc769ce43b0cba8f9ea03dc224a11c47c"},{"sha":"edf8823287e42281bbb81e15f252c7a352a06956","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\n4.69 and 4.71 LengthOfStay1 and LengthOfStay3 -- add 'Data not collected' to list of values counted as data quality issues (issue #29).","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/edf8823287e42281bbb81e15f252c7a352a06956"},{"sha":"b1df92c5fb0e0ac5499dbebd7742ea630a998685","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\n4.73 Select Data for Export - correct setting PSHHousedDays to 3 for values in tmp_Household <= 90 days (was < 90) (issue #30)","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/b1df92c5fb0e0ac5499dbebd7742ea630a998685"},{"sha":"8edb8c233f3f1ae1b11d711320841bcc783e2d95","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\n4.44 Set tmp_Exit.HHAdultAge to -1 instead of NULL as default (no change to output -- there is a cleanup UPDATE statement later that sets NULL values to -1 -- but this is more consistent with the specs).","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/8edb8c233f3f1ae1b11d711320841bcc783e2d95"},{"sha":"f776bea7062cd2e44d293ac32260f8348f15faba","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\n4.53 Length of Time in RRH Projects - update WHERE clause for time in RRH not housed from 'where lh.RRHMoveIn > 0' to 'where lh.RRHStatus > 2.'  (Was omitting ReportRows 12 and 13 -- averages for households not placed in PH.) (issue #15)","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/f776bea7062cd2e44d293ac32260f8348f15faba"},{"sha":"1aaaf6893ca779bc452b1fff172d6c5b8278782e","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Align 4.27 RRH/PSHMoveIn status with specs\n\nFor households with multiple RRH/PSH enrollments, set status to prefer move-in in rpt period first, move-in prior to rpt period second, and no move-in last.","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/1aaaf6893ca779bc452b1fff172d6c5b8278782e"},{"sha":"6d8f625fffbd196ae9e06be33ffb780083e40fde","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.46 - fix potential sys_Enrollment primary key violations\n\n4.46 Get Other Enrollments Relevant to Exit Cohort System Path - add WHERE clause to filter insert to sys_Enrollment by requiring a match on HHType as determined by the subquery (as of EntryDate) to tmp_Exit.HHType (as of later of EntryDate/CohortStart) and/or a match to the EnrollmentID of the qualifying exit.","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/6d8f625fffbd196ae9e06be33ffb780083e40fde"},{"sha":"1d7f0145589d01cb061528bd84f0b0ab4fe4433a","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"ref_lsaValues correct column number","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/1d7f0145589d01cb061528bd84f0b0ab4fe4433a"},{"sha":"e7b9afe1f50f15bfc10b6d4119ad2822cd2551f4","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.32 - add HHType to WHERE clause for insert to sys_Enrollment\n\nFilter insert of inactive enrollments potentially relevant to SystemPath to sys_Enrollment by requiring a match on HHType as determined by the subquery (as of EntryDate) to tmp_Household.HHType (as of later of EntryDate/ReportStart).  No change to final output, but there's no point in inserting them and not counting them later because HHType doesn't match.","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/e7b9afe1f50f15bfc10b6d4119ad2822cd2551f4"},{"sha":"7e642bf3266e1c4475296449fe9a57e650fea6db","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.19 align to specs / 4.38 typos\n\n4.19 Change WHERE clause in UPDATE statement to identify people with missing CH data to align to specs (no change in output -- issue #33 ).  4.38 correct typo / fatal error of repeated alias ('lhh.lhh.RRHStatus')","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/7e642bf3266e1c4475296449fe9a57e650fea6db"}]}
{"actor":{"display_login":"eanders"}}