Versions Compared

Old Version 3

changes.mady.by.user Miranda Stewart

Saved on

compared with

New Version Current

changes.mady.by.user Miranda Stewart

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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.

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

...

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_CHSADropdown

Dropdown

Dropdown

Dropdown

Dropdown

Facility Type = FAC_TYPE

Dropdown

Facility City = FAC_CITY

Dropdown

Number of Funded Beds/Units = BEDS

Dropdown

Number of Units Clustered = BEDS_CLSTRD

Dropdown

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

  1. HSIAR sends out survey template along with definitions

...

  1. /specification documentation

  2. All six HAs send their completed versions of the template

  3. MHSUA (HSIAR) prepares the survey

...

  2. ?

 

Questions/Ideas

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

    • Delivery Site Registry (DSR) contains a few data points (i.e. Site_ID and Facility_Name). 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?

    • and confirm with the business area if they want this integration or are OK without it (might be too complex to integrate).