| View file | ||
|---|---|---|
|
Background
The original sample Excel workbook provided by Bonnie included 12 sheets that require data entry.
...
The report data is organized in three colored sections besides the facility information:
Detail each section
Bonnie’s notes:
Quarterly Reporting
There is a calculator tool on bw - notes sheet. Below is a fixed example:
...
Q1 | ~ ie, April 1 to June 30 |
Q2 | ~ ie, April 1 ro Sept. 30 |
Q3 | ~ ie, April 1 to Dec. 31 |
Q4 | ~ ie, April 1/x0 to March 31/x1 |
Worked Hours Definition
Worked Hours - hours actually worked by an employee and/or contract service provider (productive time) including:
...
non-paid hours
unworked hours earned, taken or paid for or in-lieu of:
-statutory holidaysannual 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.
...
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
...
Index
...
Table
...
Session
...
Field Name
...
Excel position or Column
...
Field Type
int/ float / string
...
Calculated Field
(specify formula/calculation)
...
Dependencies (Internal Sources)
...
Notes
...
1
...
Facility Information
...
Facility Information
...
Facility Name
...
2
...
Facility Information
...
Facility Information
...
Address
...
3
...
Facility Information
...
Facility Information
...
City
...
4
...
Facility Information
...
Facility Information
...
Postal Code
...
5
...
Facility Information
...
Facility Information
...
Telephone
...
6
...
Facility Information
...
Facility Information
...
FAX
...
7
...
Facility Information
...
Facility Information
...
Facility's website Address
...
8
...
Facility Information
...
Facility Information
...
Site ID #
...
9
...
Facility Information
...
Facility Information
...
Program Type
...
10
...
Facility Information
...
Facility Information
...
Ownership Type
...
11
...
Facility Information
...
Facility Information
...
Legislation
...
12
...
Facility Information
...
Facility Information
...
Accreditation Body
...
13
...
Facility Information
...
Facility Information
...
Accreditation Date
...
14
...
Facility Information
...
Facility Information
...
Accreditation Expiry Date
...
15
...
Facility Information
...
Facility Information
...
Health Authority
...
16
...
Facility Information
...
Facility Information
...
Local Health Authoriy
...
17
...
Facility Information
...
Owner Information
...
Site ID #
...
18
...
Facility Information
...
Owner Information
...
Program Type
...
19
...
Facility Information
...
Owner Information
...
Ownership Type
...
20
...
Facility Information
...
Owner Information
...
Legislation
...
21
...
Facility Information
...
Owner Information
...
Accreditation Body
...
22
...
Facility Information
...
Owner Information
...
Accreditation Date
...
23
...
Facility Information
...
Owner Information
...
Accreditation Expiry Date
...
24
...
Facility Information
...
Owner Information
...
Health Authority
...
25
...
Facility Information
...
Owner Information
...
Local Health Authority
...
26
...
Facility Information
...
Operator Information
...
Operator Name
...
27
...
Facility Information
...
Operator Information
...
Address
...
28
...
Facility Information
...
Operator Information
...
City
...
29
...
Facility Information
...
Operator Information
...
Postal Code
...
30
...
Facility Information
...
Operator Information
...
Telephone
...
31
...
Facility Information
...
Operator Information
...
FAX
...
32
...
Facility Information
...
Operator Information
...
(Contact) Name
...
33
...
Facility Information
...
Operator Information
...
(Contact) Position
...
34
...
Facility Information
...
Operator Information
...
(Contact) Telephone
...
35
...
Facility Information
...
Operator Information
...
(Contact) E-mail Address
...
36
...
Facility Information
...
Preparer Contact Information
...
Name
...
37
...
Facility Information
...
Preparer Contact Information
...
Position
...
38
...
Facility Information
...
Preparer Contact Information
...
Telephone
...
39
...
Facility Information
...
Preparer Contact Information
...
E-mail Address
...
40
...
Facility Information
...
Preparer Contact Information
...
Fax
...
41
...
Facility Information
...
CFO or VP Finance Contact Information
...
Name
...
42
...
Facility Information
...
CFO or VP Finance Contact Information
...
Position
...
43
...
Facility Information
...
CFO or VP Finance Contact Information
...
Telephone
...
44
...
Facility Information
...
CFO or VP Finance Contact Information
...
E-mail Address
...
45
...
Facility Information
...
CFO or VP Finance Contact Information
...
Fax
...
46
...
Facility Information
...
Auditor's Contact Information
...
Audit Firm
...
47
...
Facility Information
...
Auditor's Contact Information
...
(Contact) Name
...
48
...
Facility Information
...
Auditor's Contact Information
...
(Contact) Position
...
49
...
Facility Information
...
Auditor's Contact Information
...
(Contact) Telephone
...
50
...
Facility Information
...
Auditor's Contact Information
...
(Contact) E-mail Address
...
51
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
In-Scope 3.36 HPRD Publicly Funded Beds
...
52
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
LTC Regular
...
53
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
LTC Temp
...
54
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
Other ~ specify
...
55
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
Subtotal ~ in-scope 3.36 HPRD publicly funded beds
...
56
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
Out of Scope Publicly Funded Beds
...
57
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
Short Stay Beds
...
58
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
respite
...
59
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
end of life
...
60
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
convalescent
...
61
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
flex
...
62
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
other
...
63
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
Subtotal ~ out-of-scope publicly funded beds
...
64
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
Private Beds
...
65
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
Private beds co-located with in-scope publicly funded beds
...
66
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
Private beds located in separate wing/unit
...
67
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
Subtotal ~ private beds
...
68
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
...
Total Beds
...
69
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
In-Scope 3.36 HPRD Publicly Funded Beds
...
70
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
LTC Regular
...
71
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
LTC Temp
...
72
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
Other ~ specify
...
73
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
Subtotal ~ in-scope 3.36 HPRD publicly funded beds
...
74
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
Out of Scope Publicly Funded Beds
...
75
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
Short Stay Beds
...
76
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
respite
...
77
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
end of life
...
78
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
convalescent
...
79
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
flex
...
80
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
other
...
81
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
Subtotal ~ out-of-scope publicly funded beds
...
82
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
Private Beds
...
83
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
Private beds co-located with in-scope publicly funded beds
...
84
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
Private beds located in separate wing/unit
...
85
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
Subtotal ~ private beds
...
86
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
...
Total Beds
...
87
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
In-Scope 3.36 HPRD Publicly Funded Beds
...
88
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
LTC Regular
...
89
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
LTC Temp
...
90
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
Other ~ specify
...
91
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
Subtotal ~ in-scope 3.36 HPRD publicly funded beds
...
92
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
Out of Scope Publicly Funded Beds
...
93
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
Short Stay Beds
...
94
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
respite
...
95
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
end of life
...
96
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
convalescent
...
97
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
flex
...
98
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
other
...
99
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
Subtotal ~ out-of-scope publicly funded beds
...
100
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
Private Beds
...
101
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
Private beds co-located with in-scope publicly funded beds
...
102
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
Private beds located in separate wing/unit
...
103
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
Subtotal ~ private beds
...
104
...
# of beds & occupancy rate
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
...
Total Beds
...
105
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds
...
In- scope 3.36 HPRD publicly funded beds
...
106
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds
...
Out of scope publicly funded bed
...
107
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds
...
Private Beds
...
108
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds
...
Total beds and YTD occupied days
...
109
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days
...
In- scope 3.36 HPRD publicly funded beds
...
110
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days
...
Out of scope publicly funded bed
...
111
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days
...
Private Beds
...
112
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days
...
Total beds and YTD occupied days
...
113
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days
...
In- scope 3.36 HPRD publicly funded beds
...
114
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days
...
Out of scope publicly funded bed
...
115
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days
...
Private Beds
...
116
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days
...
Total beds and YTD occupied days
...
117
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied
...
In- scope 3.36 HPRD publicly funded beds
...
118
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied
...
Out of scope publicly funded bed
...
119
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied
...
Private Beds
...
120
...
# of beds & occupancy rate
...
Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied
...
Total beds and YTD occupied days
...
121
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds
...
1. In-scope 3.36 HPRD publicly funded beds - at April 1
...
122
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds
...
1. In-scope 3.36 HPRD publicly funded beds - adjustments
...
123
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds
...
Subtotal
...
124
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds
...
2. Out-of-scope publicly funded beds
...
Field Name to be confirmed
...
125
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds
...
2. Out-of-scope publicly funded beds
...
Field Name to be confirmed
...
126
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds
...
Subtotal
...
127
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds
...
3. Private Beds
...
Field Name to be confirmed
...
128
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds
...
3. Private Beds
...
Field Name to be confirmed
...
129
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds
...
Subtotal
...
130
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds
...
Total
...
131
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / Start
...
1. In-scope 3.36 HPRD publicly funded beds - at April 1
...
132
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / Start
...
1. In-scope 3.36 HPRD publicly funded beds - adjustments
...
133
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / Start
...
2. Out-of-scope publicly funded beds
...
134
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / Start
...
2. Out-of-scope publicly funded beds
...
135
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / Start
...
3. Private Beds
...
136
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / Start
...
3. Private Beds
...
137
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / End
...
1. In-scope 3.36 HPRD publicly funded beds - at April 1
...
138
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / End
...
1. In-scope 3.36 HPRD publicly funded beds - adjustments
...
139
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / End
...
2. Out-of-scope publicly funded beds
...
140
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / End
...
2. Out-of-scope publicly funded beds
...
141
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / End
...
3. Private Beds
...
142
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / End
...
3. Private Beds
...
143
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of days
...
1. In-scope 3.36 HPRD publicly funded beds - at April 1
...
144
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of days
...
1. In-scope 3.36 HPRD publicly funded beds - adjustments
...
145
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of days
...
2. Out-of-scope publicly funded beds
...
146
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of days
...
2. Out-of-scope publicly funded beds
...
147
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of days
...
3. Private Beds
...
148
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / # of days
...
3. Private Beds
...
149
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum
...
1. In-scope 3.36 HPRD publicly funded beds - at April 1
...
150
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum
...
1. In-scope 3.36 HPRD publicly funded beds - adjustments
...
151
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum
...
Subtotal
...
152
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum
...
2. Out-of-scope publicly funded beds
...
Field Name to be confirmed
...
153
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum
...
2. Out-of-scope publicly funded beds
...
Field Name to be confirmed
...
154
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum
...
Subtotal
...
155
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum
...
3. Private Beds
...
Field Name to be confirmed
...
156
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum
...
3. Private Beds
...
Field Name to be confirmed
...
157
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum
...
Subtotal
...
158
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum
...
Total
...
159
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
April
...
160
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
May
...
161
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
June
...
162
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
Subtotal ~ Q1
...
163
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
July
...
164
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
August
...
165
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
September
...
166
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
Subtotal ~ Q2
...
167
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
October
...
168
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
November
...
169
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
December
...
170
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
Subtotal ~ Q3
...
171
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
January
...
172
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
February
...
173
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
March
...
174
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
Subtotal ~ Q4
...
175
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds
...
Total
...
176
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
April
...
177
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
May
...
178
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
June
...
179
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
Subtotal ~ Q1
...
180
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
July
...
181
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
August
...
182
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
September
...
183
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
Subtotal ~ Q2
...
184
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
October
...
185
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
November
...
186
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
December
...
187
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
Subtotal ~ Q3
...
188
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
January
...
189
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
February
...
190
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
March
...
191
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
Subtotal ~ Q4
...
192
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds
...
Total
...
193
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
April
...
194
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
May
...
195
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
June
...
196
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
Subtotal ~ Q1
...
197
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
July
...
198
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
August
...
199
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
September
...
200
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
Subtotal ~ Q2
...
201
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
October
...
202
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
November
...
203
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
December
...
204
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
Subtotal ~ Q3
...
205
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
January
...
206
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
February
...
207
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
March
...
208
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
Subtotal ~ Q4
...
209
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds
...
Total
...
210
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
April
...
211
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
May
...
212
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
June
...
213
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
Subtotal ~ Q1
...
214
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
July
...
215
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
August
...
216
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
September
...
217
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
Subtotal ~ Q2
...
218
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
October
...
219
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
November
...
220
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
December
...
221
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
Subtotal ~ Q3
...
222
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
January
...
223
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
February
...
224
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
March
...
225
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
Subtotal ~ Q4
...
226
...
# of beds & occupancy rate
...
Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days
...
Total
...
227
...
# of beds & occupancy rate
...
Forecast Bed Days & Resident Days for in-scope 3.36 HPRD publicly funded beds (for 3.36 HPRD reporting) / Bed Types / # of Beds
...
1. In scope 3.36 HPRD publicly funded beds
...
228
...
# of beds & occupancy rate
...
Forecast Bed Days & Resident Days for in-scope 3.36 HPRD publicly funded beds (for 3.36 HPRD reporting) / Bed Types / Bed days Maximum Days
...
1. In scope 3.36 HPRD publicly funded beds
...
229
...
# of beds & occupancy rate
...
Forecast Bed Days & Resident Days for in-scope 3.36 HPRD publicly funded beds (for 3.36 HPRD reporting) / Bed Types / Resident Days
...
1. In scope 3.36 HPRD publicly funded beds
...
230
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / # of beds
...
In-scope 3.36 HPRD publicly funded beds - at April
...
231
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / # of beds
...
In-scope 3.36 HPRD publicly funded beds - adjustment
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / # of beds
...
Total
...
232
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / Start
...
In-scope 3.36 HPRD publicly funded beds - at April
...
233
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / Start
...
In-scope 3.36 HPRD publicly funded beds - adjustment
...
234
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / End
...
In-scope 3.36 HPRD publicly funded beds - at April
...
235
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / End
...
In-scope 3.36 HPRD publicly funded beds - adjustment
...
236
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / # of days
...
In-scope 3.36 HPRD publicly funded beds - at April
...
237
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / # of days
...
In-scope 3.36 HPRD publicly funded beds - adjustment
...
238
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / Max. Days
...
In-scope 3.36 HPRD publicly funded beds - at April
...
239
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / Max. Days
...
In-scope 3.36 HPRD publicly funded beds - adjustment
...
240
...
# of beds & occupancy rate
...
Forecast ~ bed days maximum days / Max. Days
...
Total
...
241
...
# of beds & occupancy rate
...
Forecast ~ resident days / Forecast
...
YTD resident days =
...
242
...
# of beds & occupancy rate
...
Forecast ~ resident days / Forecast
...
# of days for last qtr ending =
...
243
...
# of beds & occupancy rate
...
Forecast ~ resident days / Forecast
...
# of days for the fiscal year =
...
244
...
# of beds & occupancy rate
...
Forecast ~ resident days / Forecast
...
Forecast
...
245
...
246
...
247
...
248
...
249
...
250
...
251
...
252
...
253
...
254
...
255
...
256
...
257
...
258
...
259
...
260
...
261
...
262
...
263
...
264
...
265
...
266
...
267
...
268
...
269
...
270
...
271
...
272
...
273
...
274
...
275
...
276
...
277
...
278
...
279
...
280
...
281
...
282
...
283
...
284
...
285
...
286
...
287
...
288
...
289
...
290
...
291
...
292
...
293
...
294
...
295
...
296
...
297
...
298
...
299
...
300
...
301
...
302
...
303
...
304
...
305
...
306
...
307
...
308
...
309
...
310
...
311
...
312
...
313
...
314
...
315
...
316
...
317
...
318
...
319
...
320
...
321
...
322
...
323
...
324
...
325
...
326
...
327
...
328
...
329
...
330
...
331
...
332
...
333
...
334
...
335
...
336
...
337
...
338
...
339
...
340
...
341
...
342
...
343
...
344
...
345
...
346
...
347
...
348
...
349
...
350
...
351
...
352
...
353
...
354
...
355
...
356
...
357
...
358
...
359
...
360
...
361
...
362
...
363
...
364
...
365
...
366
...
367
...
368
...
369
...
370
...
371
...
372
...
373
...
374
...
375
...
376
...
377
...
378
...
379
...
380
...
381
...
382
...
383
...
384
...
385
...
386
...
387
...
388
...
389
...
390
...
391
...
392
...
393
...
394
...
395
...
396
...
397
...
398
...
399
...
400
...
401
...
402
...
403
...
404
...
405
...
406
...
407
...
408
...
409
...
410
...
411
...
412
...
413
...
414
...
415
...
416
...
417
...
418
...
419
...
420
...
421
...
422
...
423
...
424
...
425
...
426
...
427
...
428
...
429
...
430
...
431
...
432
...
433
...