HIC Module: Inventory x SQL

[LaurenBianchi]

Hi, @MollyMcEvilley !
Started this discussion thread in hopes of prepping for HIC and learning more about how the LSA is imported into the HIC Module (let me know if this is better as an 'issue' for tracking purposes).

Our example case is as follows:
We have a community with a program that has 18 totals beds and these beds are Chronic Veteran Beds.

I have reviewed the uploaded LSA file for the community and the Inventory file reports 18 total beds; 18 CH Vet beds which aligns with the data in our system.

I have reviewed their HIC upload (and it has been reported that there were no manual edits for this project) and it displays Year-Round AO Beds = 18; Year-Round AO Beds - Chronic = 0; Year-Round AO Beds - Veteran = 18 and this appears to be a discrepancy based on the TA response where it was flagged we would expect to see "18 beds listed under the "Beds - Chronic" and "Beds - Veterans" categories in HDX". This is causing a few flags for them on the LSA side.

Trying to identify if there's a lift I can do for training for the customer/how the 18 CH Vet Beds only counted in the veteran column.