Versions Compared

Key

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

User Story Description:
Anchor
top
top

As a BA, I want to draft the CHEFS form Bed Inventory Data for the MHSUA business area.

Current Workflow :

  1. MHSUA sends pre-populated templates to 6 health authorities with their respective HA facility info, and a separate one for BC Housing.

    1. Snapshot dates = June 30, Sept 30, Dec 31, and Mar 31. Survey templates are posted to SP for end-users to access on the first business day of June, Sept, Dec and Mar. Submissions are due two weeks after Snapshot date.

  2. HAs complete template with various data spreadsheets from previous survey

    • Health authorities are expected to complete all attributes for a new record

    • Health authorities are expected to update any attributes that have changed since the previous survey

    • If an HA were funding the same number of beds, of the same facility types, in the same facilities as their previous survey, they could simply rename the template file and submit. Though it is more likely that the occupancy attributes (numbers) for some of the facility types have likely changed.

    • If an HA opens a new facility sometime between the current survey ‘snapshot’ date (example: September 30, 2022) and the previous ‘snapshot’ date (example: June 30, 2022), they would create a new record (row) in the current survey (example: September 30, 2022). (There is not a process that is external from the template for reporting newly opened beds, of a given facility type, in a new or existing facility.)

      • This would include all of the fields, such as facility name, facility type, facility address, number of beds, etc.

      • More generally, even if a facility is not “a new facility”, if new beds of a different facility type than was reported for the previous period for that facility are opened, a new record is created for those beds. It is beds of different facility types, reported at the facility level, that are summarized in our reporting.

Business Rationale:

  • Purpose of this 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 of the six HAs. The report also provides summaries of counts for each HA and provincial totals by facility type.

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

Dependencies:

[List potential dependencies with other User Stories or Tasks]

#

Task or User Story

Type of Dependency

 

 

 

 

 

 

 

 

Technical Details:

top page

View file
nameRMS 2822 MHSU Bed Inventory (3 VCHA) for 2022-06-30 (template).xlsx

What we need to know/receive:

  • a copy of the template that is sent to BC Housing in order to see which attributes differ from the HAs' template

Conditionals

Business Rationale/Value (Need the form to allow for the following use cases)

Potential Solution(s)

  • “If HAs are funding the same numbers of beds, of the same facility types, in the same facilities, as in the previous survey, they could simply rename the template file and submit it.”

  • Checkbox on facility info tab that states: “if information has not changed from previous submission, please “

  • explore workflow of the user experience

    • Does it make sense to organize it by tabs?

Attributes

  • Complexities around survey category, as facilities can sometimes belong to more than one category (i.e. The Royal Jubilee Hospital reports Acute Care Inpatient Treatment Beds for Adults, Acute Care Inpatient Treatment Beds for Geriatric patients, Acute Care Psychiatric Intensive Care Unit (PICU) beds,  and Acute Care Short-term Assessment Unit beds in the “Acute” category. It also reports secure rooms and quiet rooms in the “ED” category. It also reports Tertiary Inpatient (Geriatric) beds in the “Tertiary” category).

    • Will need to define the various combinations of forms

      • community + supported, community + acute, community + tertiary, community + ED, etc.

  • conditionals when surv_category = community and the following fields:

Facility Info

Beds Data

  • Number of Funded Beds/Units

    • Number of Available Beds/Units

    • Change Reason

    • Funding Initiative

Occupancy Info

Questions

  • Do we need to include the “criteria for identifying mental health bed/unit types” as part of (info) piece? If so, could display the table on a tab before the form?

Acceptance Criteria:

top page

[List the Acceptance Criteria]

#

Description

Notes

1

Though the facility info requested/captured is the same for all six HAs, the drop-down options for certain fields are specific to each respective HA.

If we don’t want to create a separate form for each HA, must add conditionals between fields.

ie. if Physical Location HA = 1 Interior; then

Physical Location HSDA = 11 East Kootenay; and options listed for Physical Location LHA will be:

  • 111 Fernie

  • 112 Cranbrook

  • 113 Kimberley

  • 114 Windermere

  • 115 Creston

  • 116 Golden

2

All consequent forms should be pre-populated from previous (most recent) survey submission.

 

3

Some fields are mandatory based on survey category. ie. if in Community category, field is mandatory. If not, then field remains optional.

 

4

 

5

 

 

Prototype/Mockups

top page

Provide high fidelity prototype or mockup

Out of Scope:

top page

Contact(s):

top page

Table of Contents

Table of Contents
minLevel1
maxLevel7