Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

🌱 Materials Used

🎯 Bed Inventory Notes

Basic Info

  • Purpose of survey is to figure out how many beds within the HA are funded for each of the services/facility types offered, and which facilities these services are offered in.

  • Bed Info collected includes bed counts by facility, reported by each HA. Six HAs (including PHSA; excluding FNHA) report. The report also provides summaries of counts for each HA and provincial totals by facility type.

  • i.e. Survey date = June 30 and includes bed count from March 31 to June 30.

 

Mandatory Attributes

Attribute Name

Definition

Field Type

Values

Notes

Survey Category = SURV_CATEGORY

Dropdown

  • Community

  • Supported

  • Acute

  • Tertiary

  • Emergency Department (ED)

Submitting Body = SUBMIT_HA

Dropdown

  • 1 Interior Health (IHA)

  • 2 Fraser Health (FHA)

  • 3 Vancouver Coastal (VCH)

  • 4 Vancouver Island (VIHA)

  • 5 Northern Health (NHA)

  • 6 Provincial Health (PHSA)

  • 8 BC Housing

Physical Location HSDA = PHYS_HSDA

Dropdown

  • East Kootenay

  • 12 Kootenay Boundary

  • …

  • 52 Northern Interior

  • 53 Northeast

Physical Location = PHYS_HA

Dropdown

  • 1 Interior Health (IHA)

  • 2 Fraser Health (FHA)

  • 3 Vancouver Coastal (VCH)

  • 4 Vancouver Island (VIHA)

  • 5 Northern (NHA)

  • 9 Unknown HA

Enter 9 if confidentiality or other issues prevent the physical HA from being entered

Physical Location LHA = PHYS_LHA

The LHA of the physical location HSDA in which the facility is located

Dropdown

Physical Location CHSA = PHYS_CHSA

Dropdown

Dropdown

Dropdown

Dropdown

Dropdown

  • Facility Type = FAC_TYPE

  • Facility City = FAC_CITY

  • Number of Funded Beds/Units = BEDS

  • Number of Units Clustered = BEDS_CLSTRD

  • Notes = NOTE

  • Survey Year = SURV_YEAR

  • Survey Month = SURV_MNTH

  • Facility Name = FACILITY_NAME

    • Can be pre-populated from DSR as well.

    • Validation Rule: This attribute is mandatory if facility falls into following survey categories: community, acute, ED, or Tertiary. If facility is in Supported category, then facility name is optional.

  • Site ID = SITE_ID - Can this be pre-filled from DSR? Not all sites in the survey are registered in the DSR, but the goal is to have all sites reported on the bed survey registered in the DSR.

    • Note: Site_ID will have to be a TXT field, as hospitals include an H.

 

Workflow

  • HSIAR sends out template along with definitions doc.

  • Team within HSIAR prepares the survey template

 

Questions/Ideas

  • Do we know if there are any external systems that MHSU could potentially pull from?

    • Delivery Site Registry (DSR) contains a few data points. Need to figure out the workflow.

  • There are certain columns that are hidden within the spreadsheet but mentioned in the . Do we need to

  • On the reporting side, the business area may want to keep the . We could keep the survey category as an attribute (drop-down) in the form/data collection.

  • Timeline

    • Quarterly basis?

  • We have the template that is prepared by HSIAR/MoH, but are we able to get the template that is sent to HAs to fill out?

  • No labels