...

...

...

Background

The original sample Excel workbook provided by Bonnie included x sheets:12 sheets that require data entry.

The copy available above contains _is an sample Q3 report submitted by VIHA.

The report data is organized in three colored sections besides the facility information:

• Detail each section

...

Index

...

Table

...

Field Name

...

Excel position or Column

...

Field Type

int/ float / string

...

Calculated Field

(specify formula/calculation)

...

Dependencies (Internal Sources)

...

Bonnie’s notes:

Quarterly Reporting

There is a calculator tool on bw - notes sheet. Below is a fixed example:

Quarter Ending

Worked Hours Definition

Worked Hours - hours actually worked by an employee and/or contract service provider (productive time) including:

• regular worked hours

• statutory holiday hours worked

• overtime hours worked

• call back hours worked

• relief hours worked

• "coffee" break

• meal break - 30 minute break included where RN is working without professional back-up, ie, "on-call"

Worked hours do not include:

• non-paid hours

• unworked hours earned, taken or paid for or in-lieu of:
  -statutory holidays

• annual vacation

• sick time

• any other purpose

• staff development/education/orientation

• "premium" (the list below is not intended to be exhaustive), such as payments based on hours for working:

• an overtime hour

• a named or statutory holiday

• shift differential premium for working an evening, night or weekend shift

• on-call premium/stand-by pay

Direct Care Worked Hours

Direct Care Worked Hours are a subset of worked hours (as defined above) and include only the hours worked by staff or contracted service providers (including RN, RPN, LPN, Care Aides and Allied Care) in the direct delivery of services to residents.

Direct care consists of one-to-one/first level of care interactions with residents (ie, hands-on patient care) and other clinical related interactions (eg, with family members and physicians) and includes care coordination, assessment, planning and delivery/treatment.

Allied care includes both professional and non-professional direct care providers. Pastoral care and volunteer coordinators are not considered to be direct allied care providers. The criteria to apply to distinguish between what is categorized as professional vs non-professional is whether or not the profession has a regulatory college in BC (ie, those with a regulatory college in BC are categorized as professional).

Examples of allied professional and non-professional direct care providers are as follows:

Allied Care - Professional Care:

• occupational therapist

• physio therapist

• dietician

• social worker

• speech language therapist

Allied Care - Non-Professional Care:

• recreation therapist and recreation co-ordinator (if performing similar function to a recreation therapist)

• rehab assistant

• activity worker

• respiratory therapist

• music/art therapist (if engaged in recreation activities with residents as an activity worker would be)

Direct care worked hours do not include hours worked by nurses who are administrators or provide clinical support, volunteers and positions paid for by donations or grants. In addition, tasks performed by care aides such as plating food, setting up the dining room for a meal or cleaning up after a meal, light housekeeping, and other laundry duties are also excluded.

Non-Direct Care Worked Hours - Out of Scope
Non-direct care worked hours consists of support or secondary resident care in which interactions with residents are not primarily focused on the care or care plan for the resident (eg, laundering the linens or preparation, cooking and plating of meals).

Cost of Direct Care Worked Hours - cost for both productive and non-productive direct care hours and include:

• wage costs

• benefits including:

  • employer paid benefits

  • shift differentials and premiums (ie, remote site)

  • vacation, statutory holidays

  • sick time

  • overtime

  • severance

  • retiring allowances

  • other paid leave (ie, orientation, education, etc)

  • purchased labour cost and meal allowances