Versions Compared

Old Version 5

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.

...

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

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,

    • and confirm with 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?

    • if they want this integration or are OK without it (might be too complex to integrate).