Follow-up for Flag 783 (0 beds in flag but there are beds)

[nataliesus]

Hi @kiadso ,

It is follow-up for #859 that was closed 2 days ago because the issue was reported as resolved on Test and Prod.

Unfortunately, it is still actual for us. Upload made on 12/14/2021: https://testing.hudhdx2.info/dataset/1378/warning

Inventory.csv does have 2 inventory records for [HMIS Project ID] = 785

Please advise.

Thank you!
Natalie

[eanders]

We are also seeing this flag where there are valid inventory records for the projects in the report range. Is it possible the issue is having multiple valid inventory records for the same date range? Ours look very similar to @nataliesus's in that there are two records for each time period.

[nataliesus]

Just in case, there are 2 inventory records on the same period, but with different HouseholdTypes (which is quite important, I think).

[eanders]

Same here, 1 and 3, same as yours.

[cywiseman]

We continue to see this cropping up where there are valid BUI records. Is there any update on the status of this one?

[kiadso]

Hi Candice- this one and the other ones that are not closed yet are coded but not pushed to production. Once I have confirmation the fixes have been pushed to production, I will close this (and the other) issues. We're working to get those pushed as soon as possible. It will be no later than tomorrow. Thanks!

[kiadso]

This fix has been pushed to production. Please re-open if you are still seeing these. Thanks everyone!

[eanders]

As a note for future folks with this issue. If your BedInventory count looks correct in your exported CSV, but the lsa_Inventory file contains zero in the BedInventory column, it may be because that is a calculated column based on the sum of the bed types.

CHVetBedInventory + YouthVetBedInventory + VetBedInventory
  + CHYouthBedInventory + YouthBedInventory + CHBedInventory
  + OtherBedInventory

There's a note in the code describing this.

LSASampleCode/02 LSA Output Tables.sql

Lines 133 to 147 in 93b94cd

	-- xInventory (e.g., CHVetBedInventory, etc.) columns for which the HMIS CSV permits
	-- NULL values are mandatory for the LSA and created here as NOT NULL.
	-- BedInventory MUST be equal to the sum of values in xInventory columns. It is set up
	-- here as a computed column, which is permissible.
	create table lsa_Inventory(
	InventoryID nvarchar(32) not NULL,
	ProjectID nvarchar(32) not NULL,
	CoCCode nvarchar(6) not NULL,
	HouseholdType int not NULL,
	[Availability] int,
	UnitInventory int not NULL,
	BedInventory
	as CHVetBedInventory + YouthVetBedInventory + VetBedInventory
	+ CHYouthBedInventory + YouthBedInventory + CHBedInventory
	+ OtherBedInventory,