Background
The original sample Excel workbook provided by Bonnie included 12 sheets that require data entry.
The copy available above 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 | 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 |
| |||||
59 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1 |
| |||||
60 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1 |
| |||||
61 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1 |
| |||||
62 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1 |
| |||||
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 |
| |||||
77 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment |
| |||||
78 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment |
| |||||
79 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment |
| |||||
80 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment |
| |||||
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 |
| |||||
95 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised |
| |||||
96 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised |
| |||||
97 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised |
| |||||
98 | # of beds & occupancy rate | Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised |
| |||||
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 |
| |||||
106 | # of beds & occupancy rate | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds |
| |||||
107 | # of beds & occupancy rate | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved 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 |
| |||||
110 | # of beds & occupancy rate | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days |
| |||||
111 | # of beds & occupancy rate | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days |
| |||||
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 |
| |||||
114 | # of beds & occupancy rate | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days |
| |||||
115 | # of beds & occupancy rate | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days |
| |||||
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 |
| |||||
118 | # of beds & occupancy rate | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied |
| |||||
119 | # of beds & occupancy rate | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied |
| |||||
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 | |||||
232 | # of beds & occupancy rate | Forecast ~ bed days maximum days / Start | ||||||
233 | # of beds & occupancy rate | Forecast ~ bed days maximum days / Start | ||||||
234 | # of beds & occupancy rate | Forecast ~ bed days maximum days / End | ||||||
235 | # of beds & occupancy rate | Forecast ~ bed days maximum days / End | ||||||
236 | # of beds & occupancy rate | Forecast ~ bed days maximum days / # of days | ||||||
237 | # of beds & occupancy rate | Forecast ~ bed days maximum days / # of days | ||||||
238 | ||||||||
239 | ||||||||
240 | ||||||||
241 | ||||||||
242 | ||||||||
243 | ||||||||
244 | ||||||||
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 | ||||||||
434 |