HMIS LSASampleCode issues

HMIS / LSASampleCode

Longitudinal System Analysis (LSA) Sample Code and Documentation

22 stars 10 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Flag 808: Geography Type Alignment

#1350 LaurenBianchi opened 19 hours ago
0
Race Case Found in Step 6.5.1

#1349 evaripatis opened 4 days ago
0
Flag 783-1.69: unknown "in_error2" parameter

#1348 nataliesus opened 4 days ago
0
Section 3.3: Effective ExitDate: difference between the Spec and the Sample Code

#1347 nataliesus opened 4 days ago
0
Section 10.5 - difference between Sample Code and Spec

#1346 nataliesus opened 4 days ago
1
Flags list is not generated

#1345 nataliesus closed 4 days ago
3
New LSA/HIC outputs

#1344 nataliesus closed 4 days ago
0
Sample Code (3.6.3 and 3.6.4): Exit1HHType and Exit2HHType issues

#1343 nataliesus closed 5 days ago
2
Sample Code: step 3.6.3 was renamed as step 3.6.4

#1342 nataliesus closed 5 days ago
0
Sample Code (3.6.2): ActiveHHType rewritten query

#1341 nataliesus closed 5 days ago
1
06 LSAHousehold.sql: hhid.Active = 1 condition was removed

#1340 nataliesus closed 5 days ago
1
06 LSAHousehold.sql: a condition to not execute for LSAScope = 3 is missing

#1339 nataliesus closed 1 week ago
0
Follow-up for #1327: Spec (3.3): Effective Exit Date = null condition in not listed for ProjectType = 1

#1338 nataliesus closed 5 days ago
0
03_02 to 03_06 - LEAST and GREATEST are not supported in versions of SQL Server prior to 2022

#1337 MollyMcEvilley closed 1 week ago
0
3.6 Household Types (tlsa_HHID Exit1HHType and Exit2HHType

#1336 MollyMcEvilley closed 1 week ago
0
Sample Code 3.4.1: issue after changes made under #1326

#1335 nataliesus closed 1 week ago
1
Follow-up for #1330 (Section 10.2: OperatingEndDate restriction for ReportRow 902)

#1334 nataliesus closed 5 days ago
0
Flags List: never generated

#1333 nataliesus closed 1 week ago
4
CRITICAL: follow-up for #1324 (Questions about MoveInDate values)

#1332 nataliesus closed 2 weeks ago
0
Spec: sections 6.2, 7.4, 7.5, 7.7, 7.8: formatting issue

#1331 nataliesus closed 1 week ago
1
Section 10.2: OperatingEndDate restriction for ReportRow 902

#1330 nataliesus closed 2 weeks ago
0
Follow-up for #1311: question if we do not need ProjectCoC.CoCCode = ReportCoC restriction in 3.3.1

#1329 nataliesus closed 2 weeks ago
1
Spec 3.3: missing relevant data reference

#1328 nataliesus closed 1 week ago
0
Spec (3.3.1): Effective Exit Date for ProjectType = 1

#1327 nataliesus closed 1 week ago
2
Sample Code (3.3.1): pEnd calculation

#1326 nataliesus closed 2 weeks ago
1
Sample Code (3.3.1): ExitDate on either OperatingEnd or HMISEnd

#1325 nataliesus closed 2 weeks ago
1
Questions about MoveInDate values

#1324 evaripatis closed 2 weeks ago
4
Question about hp1 logic in Step 3.3.1

#1323 evaripatis closed 3 weeks ago
3
Section 3.3.1: Effective Exit Date for ProjectType = 1

#1322 nataliesus closed 3 weeks ago
0
LSA Report Error - Wrong CoC Upload - PLS DELETE THIS ONE

#1321 TanyaPieterse closed 3 weeks ago
1
LSA Upload Error - HHFleeingDV

#1320 TanyaPieterse closed 2 weeks ago
7
Sample Code (Step 3.3.1): BedNightDates

#1319 nataliesus closed 3 weeks ago
0
Section 3.3.1: Effective Exit Date

#1318 nataliesus closed 5 days ago
1
Section 3.3.1: Effective Move-In Date issue

#1317 nataliesus closed 3 weeks ago
1
Spec (Section 3.3.1): a discrepancy in the logic for EntryDate

#1316 nataliesus closed 3 weeks ago
0
Spec (section 3.3.1): question about removed table aliases

#1315 nataliesus opened 1 month ago
0
Sample Code (Step 3.3.1): HMISParticipationStatusEndDate > LookbackDate condition is missing

#1314 nataliesus closed 3 weeks ago
0
Spec (Section 3.3.1): HMISParticipationStatusStartDate <= ReportEnd is not listed

#1313 nataliesus closed 3 weeks ago
1
Step 3.3.1: hx.ExitDate = rpt.LookbackDate case

#1312 nataliesus closed 3 weeks ago
1
Step 3.3.1: ProjectCoC.CoCCode = ReportCoC condition question

#1311 nataliesus closed 3 weeks ago
1
Sample Code: Step 10.5: different results comparing with the Spec

#1310 nataliesus closed 3 weeks ago
1
CRITICAL: Sample HMIS Data.zip: Disabilities.csv: InformationDate must be the same as Exit.ExitDate for the following DisabilitiesID: XXX with Data Collection Stage = 3

#1309 nataliesus closed 3 weeks ago
1
Follow-up for #1283: Follow-up for #1256: Spec (7.9): HHFleeingDV

#1308 nataliesus closed 3 weeks ago
1
Follow-up for #1279: Spec (4.3): Inventory.csv

#1307 nataliesus closed 1 week ago
2
Sample Code (Step 9.6): HoH EntryDate <= ReportStart is missing

#1306 nataliesus closed 1 week ago
0
Spec (section 10.5): conditions are different from the Sample Code

#1305 nataliesus closed 1 week ago
2
Sample Code: step 9.6

#1304 nataliesus closed 1 month ago
1
Spec: possible formatting issue

#1303 nataliesus closed 1 month ago
1
Sample Code: 04_01 Get Project Records.sql

#1302 nataliesus closed 1 month ago
1
Spec: 4.1 Get Project.csv requires an update for LSAScope = 3 (HIC)

#1301 nataliesus closed 1 month ago
1