Versions Compared

Old Version 2

changes.mady.by.user Miranda Stewart

Saved on

compared with

New Version 3

changes.mady.by.user Miranda Stewart

Saved on

Key

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

...

Mandatory Attributes

Attribute Name

Definition

Field Type

Values

Notes

Survey Category = SURV_CATEGORY

Dropdown with 5 options

  • Community

  • Supported

  • Acute

  • Tertiary

  • Emergency Department (ED)

Submitting Body = SUBMIT_HA

Dropdown with 7 options:

  • 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 with 6 options

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