{"push_id":3078387975,"size":21,"distinct_size":1,"ref":"refs/heads/gr-release","head":"5f10889d37c8d4384c253f8ff9999171a988e7ff","before":"9e1e4a20f558473f85ac17b36808e5a991081c0e","commits":[{"sha":"429e11ace4957a56baea40dba34191e35524a9e8","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.69 and 4.71 DQ for 3.917 fields\n\nCorrect identification of circumstances under which DateToStreetESSH, TimesHomelessPastThreeYears, and MonthsHomelessPastThreeYears are required for collection.  Note that THE SAMPLE CODE FOR THESE THREE FIELDS IS NOT CONSISTENT WITH THE SPECS because the specs are wrong about when they are required.  For FY2018, the HDX will ignore DQ values for these fields.","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/429e11ace4957a56baea40dba34191e35524a9e8"},{"sha":"a73c01cc91b3e36838d61b9286531319b2e9ad0a","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.7 ExitDate criteria for active HouseholdID\n\nissue #34","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/a73c01cc91b3e36838d61b9286531319b2e9ad0a"},{"sha":"e737802c0e6b2a605b91d4156a5a79272fa7be0d","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.7 ExitDate criteria for active HouseholdID\n\nissue #34 -- correction to add parentheses to last commit","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/e737802c0e6b2a605b91d4156a5a79272fa7be0d"},{"sha":"91f87ddeedcb81b9846ddb593045000906b20caa","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"INSERT to lsa_refValues Report56 & 57\n\ncorrect textValues for intValues 56 and 57 (textValues were swapped","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/91f87ddeedcb81b9846ddb593045000906b20caa"},{"sha":"f62f8db29dd2db99c5a19a62a34cedc5f5f6884d","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update Values tab\n\nAdd YHDP (43) as a valid option for Funder.Funder and correct textValues for LSACalculated.ReportRow values 56 and 57 (were swapped).","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/f62f8db29dd2db99c5a19a62a34cedc5f5f6884d"},{"sha":"fdc950eed670ac62dad9cccf8f6d4b8a3bb0a45d","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.68 correct lsa_Calculated ReportRow value\n\nReportRow value in 4.68 Get Counts of Bed Nights in Report Period by Project Type/Personal Char was 56 / corrected to 57.","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/fdc950eed670ac62dad9cccf8f6d4b8a3bb0a45d"},{"sha":"b7570a5facbfbc5ad7569976d414aa80fbe4154f","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.40 LSAExit from ReportCoC\n\nupdate 4.40 so that only exits where the household was located in ReportCoC (issue #60 )","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/b7570a5facbfbc5ad7569976d414aa80fbe4154f"},{"sha":"a0d0403d5e107b69eea4ddfa11393a55c047ea36","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.43 Set ReturnTime for Exit Cohort Households\n\nHH must be in ReportCoC at entry in order for a later enrollment to be considered a return (correct to align with specs).","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/a0d0403d5e107b69eea4ddfa11393a55c047ea36"},{"sha":"8f118d647ebc8d7b87c10d53650c9a0ac1bd73bf","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Revert \"4.43 Set ReturnTime for Exit Cohort Households\"\n\nThis reverts commit a0d0403d5e107b69eea4ddfa11393a55c047ea36.","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/8f118d647ebc8d7b87c10d53650c9a0ac1bd73bf"},{"sha":"a6b83c438b4208281dff791bbed657f3f7b69538","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.43 Set ReturnTime for Exit Cohorts\n\nAlign with specs -- HH must be located in ReportCoC at entry for later enrollment to count as a return.  Add requirement that EnrollmentCoC record for return reflects location at entry.  (Issue #60)","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/a6b83c438b4208281dff791bbed657f3f7b69538"},{"sha":"0f7991cacfd07043e114f0467c4462c51957907d","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.45 optional change to CoC criteria\n\nAlign criteria for EnrollmentCoC with business logic defined by the specs for tmp_Household.Stat.  The specs fail to mention EnrollmentCoC at all in relation to Stat for exit cohort households, so this update is completely optional for vendors, but it is consistent with the intent.","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/0f7991cacfd07043e114f0467c4462c51957907d"},{"sha":"dd65b22a6dd077e56a8d6ead04ed80218dcdd3b3","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Revert \"4.45 optional change to CoC criteria\"\n\nThis reverts commit 0f7991cacfd07043e114f0467c4462c51957907d.","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/dd65b22a6dd077e56a8d6ead04ed80218dcdd3b3"},{"sha":"e17e6b18e1dc8d44c243b408f2fdc1d0adacaadb","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"Update LSASampleCode.sql\n\nAlign criteria for EnrollmentCoC with business logic defined by the specs for tmp_Household.Stat.  The specs fail to mention EnrollmentCoC at all in relation to Stat for exit cohort households, so this update is completely optional for vendors, but it is consistent with the intent. (issue #60)","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/e17e6b18e1dc8d44c243b408f2fdc1d0adacaadb"},{"sha":"896bf1f19b51a6faaa4deacb9f46e5ba34999370","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.35 Other3917Days Count\n\nCorrection to eliminate DateToStreetESSH values that would result in a count of -1 days. (issue #54)","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/896bf1f19b51a6faaa4deacb9f46e5ba34999370"},{"sha":"9fddad6b726696235600ac283d4541c369f94c28","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"FINAL - Word version","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/9fddad6b726696235600ac283d4541c369f94c28"},{"sha":"5fb8aa36d96bb3fa8f8d329ee0ad8bb539eb9db1","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"FINAL - PDF version","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/5fb8aa36d96bb3fa8f8d329ee0ad8bb539eb9db1"},{"sha":"c7dca2e17b728d6e9fed2b30e174dec9f1cd88a7","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.11 .12 and .13 - move SET of 3 tmp_Person columns\n\nTo align with the specs, making the changes to the code listed below. (issue #35)\n\n- Move SET of **HoHAdult** and **Age** from section 4.11 to 4.12 (no change to intermediate or final output)\n- Move SET of **LastActive** from section 4.11 to 4.13 (change to intermediate output only -- LastActive  will no longer be set for non-HoH children).","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/c7dca2e17b728d6e9fed2b30e174dec9f1cd88a7"},{"sha":"b605dc821854f11e4ded27e67c75f24e4452fdcd","author":{"name":"Molly McEvilley","email":"4181eecbd7a755d19fdf73887c54837cbecf63fd@squarepegdata.com"},"message":"4.19 fix typo in 2nd UPDATE WHERE clause\n\n(issue #36)","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/b605dc821854f11e4ded27e67c75f24e4452fdcd"},{"sha":"db8f149f43e4241e29923e56d0540d09165d2285","author":{"name":"Elliot Anders","email":"fd1fa7585829f3669cbcc7f37f4dc18117e1cfba@greenriver.org"},"message":"Merge remote-tracking branch 'upstream/master'","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/db8f149f43e4241e29923e56d0540d09165d2285"},{"sha":"cc3aa951e4bc39fb5247decac94a5908c5b3f84d","author":{"name":"Elliot Anders","email":"fd1fa7585829f3669cbcc7f37f4dc18117e1cfba@greenriver.org"},"message":"Merge branch 'master' into performance","distinct":false,"url":"https://api.github.com/repos/greenriver/LSASampleCode/commits/cc3aa951e4bc39fb5247decac94a5908c5b3f84d"}]}
{"actor":{"display_login":"eanders"}}