...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Index
...
Sheet
...
Table
...
Session
...
Field Name
...
Excel position or Column
...
Field Type
int/ float / string
...
Calculated Field
(specify formula/calculation)
...
Dependencies (Internal Sources)
...
Notes
...
1
...
bed inventory
...
Data Collection ~ Bed Inventory
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / At April 1
...
LTC Regular
...
C20
...
2
...
bed inventory
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / At April 1
...
LTC Temp
...
C21
...
3
...
bed inventory
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / At April 1
...
Other ~ specify
...
C22
...
4
...
bed inventory
...
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / At April 1
...
Instructions & Definitions
Purpose ~ this section captures the YTD approved # of beds and occupied days.
Table - YTD Number of Resident Days ~ the data is pre-populated from tables "Details for YTD Maximum Days" and "Details for YTD Occupied Days"
Table - Details for YTD Maximum Days
i. The approved # of beds is pre-populated and based on the bed inventory data collection.
ii. Enter the start and end date for when the beds are available. Formulas have been embedded to
calculate the # of days and YTD maximum the beds are available for the start to end period.
Table - Details for YTD Occupied Days
i. For the 3 bed types, enter the # of days the beds are occupied by a client by month.
...
Year-to-Date (YTD) Number of Resident Days
Index | Bed Type | Data | Field Type int/ float / string | Calculated Field (specify formula/calculation) | Notes |
|---|---|---|---|---|---|
1 | 1 - In- scope 3.36 HPRD publicly funded beds | Approved Number of Beds | int | Pre-populated with HCC bed inventory | |
2 | 1 - In- scope 3.36 HPRD publicly funded beds |
YTD Maximum Days |
int | Pre-populated with HCC bed inventory |
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / At April 1
respite
C27
6
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / At April 1
end of life
C28
7
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / At April 1
convalescent
C29
8
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / At April 1
flex
C30
9
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / At April 1
other
C31
10
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / At April 1
Subtotal ~ out-of-scope publicly funded beds
C32
11
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / At April 1
Private beds co-located with in-scope publicly funded beds
C35
12
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / At April 1
Private beds located in separate wing/unit
C36
13
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / At April 1
Subtotal ~ private beds
C37
14
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1
Total Beds
C39
15
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / Adjustment
LTC Regular
D20
16
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / Adjustment
LTC Temp
D21
17
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / Adjustment
Other ~ specify
D22
18
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / Adjustment
3 | 1 - In- scope 3.36 HPRD publicly funded beds | YTD Occupied Days | int | Pre-populated with HCC bed inventory | |
4 | 1 - In- scope 3.36 HPRD publicly funded beds | Percentage Occupied | Percentage | ||
5 | 2 - Out of scope publicly funded bed | Approved Number of Beds | int | Pre-populated with HCC bed inventory | |
6 | 2 - Out of scope publicly funded bed | YTD Maximum Days | int | Pre-populated with HCC bed inventory | |
7 | 2 - Out of scope publicly funded bed | YTD Occupied Days | int | Pre-populated with HCC bed inventory | |
8 | 2 - Out of scope publicly funded bed | Percentage Occupied | Percentage | ||
9 | 3 - Private Beds | Approved Number of Beds | int | Pre-populated with HCC bed inventory | |
10 | 3 - Private Beds | YTD Maximum Days | int | Pre-populated with HCC bed inventory | |
11 | 3 - Private Beds | YTD Occupied Days | int | Pre-populated with HCC bed inventory | |
12 | 3 - Private Beds | Percentage Occupied | Percentage | ||
13 | Total number beds and YTD occupied days | Approved Number of Beds | int | Check with Bonnie if this is calculated | |
14 | Total number beds and YTD occupied days | YTD Maximum Days | int | Check with Bonnie if this is calculated | |
15 | Total number beds and YTD occupied days | YTD Occupied Days | int | Check with Bonnie if this is calculated | |
16 | Total number beds and YTD occupied days | Percentage Occupied | Percentage |
...
Detail for YTD Maximum Days
Index | Bed Type | Data | Field Type int/ float / string | Calculated Field (specify formula/calculation) | Notes |
|---|---|---|---|---|---|
1 | 1 - In- scope 3.36 HPRD publicly funded beds - At April 1 | Approved Number of Beds | int | Pre-populated with HCC bed inventory | |
2 | 1 - In- scope 3.36 HPRD publicly funded beds - At April 1 | Start | Operator input | ||
3 | 1 - In- scope 3.36 HPRD publicly funded beds - At April 1 | End | Operator input | ||
4 | 1 - In- scope 3.36 HPRD publicly funded beds - At April 1 | Number of Days | |||
5 | 1 - In- scope 3.36 HPRD publicly funded beds - At April 1 | YTD Maximum | |||
6 | 1 - In- scope 3.36 HPRD publicly funded beds |
D23
19
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Adjustment
respite
D27
20
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Adjustment
end of life
D28
21
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Adjustment
convalescent
D29
22
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Adjustment
flex
D30
23
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Adjustment
other
D31
24
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Adjustment
Subtotal ~ out-of-scope publicly funded beds
D32
25
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / Adjustment
Private beds co-located with in-scope publicly funded beds
D35
26
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / Adjustment
Private beds located in separate wing/unit
D36
27
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / Adjustment
Subtotal ~ private beds
D37
28
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment
Total Beds
D39
29
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / Revised
LTC Regular
E20
30
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / Revised
LTC Temp
E21
31
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / Revised
Other ~ specify
E22
32
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / Revised
Subtotal ~ in-scope 3.36 HPRD publicly funded beds
E23
33
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Revised
respite
E27
34
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Revised
end of life
E28
35
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Revised
convalescent
E29
36
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Revised
flex
E30
37
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Revised
other
E31
38
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Revised
Subtotal ~ out-of-scope publicly funded beds
E32
39
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / Revised
Private beds co-located with in-scope publicly funded beds
E35
40
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / Revised
Private beds located in separate wing/unit
E36
41
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / Revised
Subtotal ~ private beds
E37
42
bed inventory
Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised
Total Beds
- Adjustments | Approved Number of Beds | Pre-populated with HCC bed inventory | Check with Bonnie if this field is supposed to be added “as needed” | ||
7 | 1 - In- scope 3.36 HPRD publicly funded beds - Adjustments | Start | Operator input | Check with Bonnie if this field is supposed to be added “as needed” | |
8 | 1 - In- scope 3.36 HPRD publicly funded beds - Adjustments | End | Operator input | Check with Bonnie if this field is supposed to be added “as needed” | |
9 | 1 - In- scope 3.36 HPRD publicly funded beds - Adjustments | Number of Days | Check with Bonnie if this field is supposed to be added “as needed” | ||
10 | 1 - In- scope 3.36 HPRD publicly funded beds - Adjustments | YTD Maximum | Check with Bonnie if this field is supposed to be added “as needed” | ||
11 | Subtotal (1 - In- scope 3.36 HPRD publicly funded beds) | Approved Number of Beds | |||
12 | Subtotal (1 - In- scope 3.36 HPRD publicly funded beds) | YTD Maximum | |||
13 | 2 - Out of scope publicly funded bed - At April 1 | Approved Number of Beds | Pre-populated with HCC bed inventory | ||
14 | 2 - Out of scope publicly funded bed - At April 1 | Start | Operator input | ||
15 | 2 - Out of scope publicly funded bed - At April 1 | End | Operator input | ||
16 | 2 - Out of scope publicly funded bed - At April 1 | Number of Days | |||
17 | 2 - Out of scope publicly funded bed - At April 1 | YTD Maximum | |||
18 | 2 - Out of scope publicly funded bed - Adjustments | Approved Number of Beds | Pre-populated with HCC bed inventory | Check with Bonnie if this field is supposed to be added “as needed” | |
19 | 2 - Out of scope publicly funded bed - Adjustments | Start | Operator input | Check with Bonnie if this field is supposed to be added “as needed” | |
20 | 2 - Out of scope publicly funded bed - Adjustments | End | Operator input | Check with Bonnie if this field is supposed to be added “as needed” | |
21 | 2 - Out of scope publicly funded bed - Adjustments | Number of Days | Check with Bonnie if this field is supposed to be added “as needed” | ||
22 | 2 - Out of scope publicly funded bed - Adjustments | YTD Maximum | Check with Bonnie if this field is supposed to be added “as needed” | ||
23 | Subtotal (2 - Out of scope publicly funded bed) | Approved Number of Beds | |||
24 | Subtotal (2 - Out of scope publicly funded bed) | YTD Maximum | |||
25 | 3 - Private Beds - At April 1 | Approved Number of Beds | Pre-populated with HCC bed inventory | ||
26 | 3 - Private Beds - At April 1 | Start | Operator input | ||
27 | 3 - Private Beds - At April 1 | End | Operator input | ||
28 | 3 - Private Beds - At April 1 | Number of Days | |||
29 | 3 - Private Beds - At April 1 | YTD Maximum | |||
30 | 3 - Private Beds - Adjustments | Approved Number of Beds | Pre-populated with HCC bed inventory | Check with Bonnie if this field is supposed to be added “as needed” | |
31 | 3 - Private Beds - Adjustments | Start | Operator input | Check with Bonnie if this field is supposed to be added “as needed” | |
32 | 3 - Private Beds - Adjustments | End | Operator input | Check with Bonnie if this field is supposed to be added “as needed” | |
33 | 3 - Private Beds - Adjustments | Number of Days | Check with Bonnie if this field is supposed to be added “as needed” | ||
34 | 3 - Private Beds - Adjustments | YTD Maximum | Check with Bonnie if this field is supposed to be added “as needed” | ||
35 | Subtotal (3 - Private Beds) | Approved Number of Beds | |||
36 | Subtotal (3 - Private Beds) | YTD Maximum | |||
37 | Total | Approved Number of Beds | |||
38 | Total | YTD Maximum |
...
Detail for YTD Occupied Days
Index | Monthly Activity (Period) | Data | Field Type int/ float / string | Calculated Field (specify formula/calculation) | Notes |
|---|---|---|---|---|---|
1 | Pre-populated with HCC bed inventory |
Index | Sheet | Table | Session | Field Name | Excel position or Column | Field Type int/ float / string | Calculated Field (specify formula/calculation) | Dependencies (Internal Sources) | Notes |
|---|---|---|---|---|---|---|---|---|---|
43 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds | 1. In- scope 3.36 HPRD publicly funded beds | C18 | |||||
44 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds | 2. Out of scope publicly funded bed | C19 | |||||
45 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds | 3. Private Beds | C20 | |||||
46 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds | Total beds and YTD occupied days | C22 | |||||
47 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days |
| D18 | |||||
48 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days |
| D19 | |||||
49 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days |
| D20 | |||||
50 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days | Total beds and YTD occupied days | D22 | |||||
51 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days |
| E18 | |||||
52 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days |
| E19 | |||||
53 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days |
| E20 | |||||
54 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days | Total beds and YTD occupied days | E22 | |||||
55 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied |
| F18 | |||||
56 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied |
| F19 | |||||
57 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied |
| F20 | |||||
58 | bed occupancy | Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / % Occupied | Total beds and YTD occupied days | F22 | |||||
59 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds |
| Time selection based on which quarter is being reported - needs Bonnie’s confirmation | |||||
60 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds |
| ||||||
61 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds | Subtotal | ||||||
62 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds |
| Time selection based on which quarter is being reported - needs Bonnie’s confirmation | |||||
63 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds |
| ||||||
64 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds | Subtotal | ||||||
65 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds |
| Time selection based on which quarter is being reported - needs Bonnie’s confirmation | |||||
66 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds |
| ||||||
67 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds | Subtotal | ||||||
68 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds | Total | ||||||
69 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / Start |
| Time selection based on which quarter is being reported - needs Bonnie’s confirmation | |||||
70 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / Start |
| ||||||
71 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / Start |
| ||||||
72 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / Start |
| ||||||
73 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / Start |
| ||||||
74 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / Start |
| ||||||
75 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / End |
| Time selection based on which quarter is being reported - needs Bonnie’s confirmation | |||||
76 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / End |
| ||||||
77 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / End |
| ||||||
78 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / End |
| ||||||
79 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / End |
| ||||||
80 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / End |
| ||||||
81 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of days |
| ||||||
82 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of days |
| ||||||
83 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of days |
| ||||||
84 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of days |
| ||||||
85 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of days |
| ||||||
86 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / # of days |
| ||||||
87 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum |
| ||||||
88 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum |
| ||||||
89 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum | Subtotal | ||||||
90 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum |
| Field Name to be confirmed | |||||
91 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum |
| Field Name to be confirmed | |||||
92 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum | Subtotal | ||||||
93 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum |
| Field Name to be confirmed | |||||
94 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum |
| Field Name to be confirmed | |||||
95 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum | Subtotal | ||||||
96 | # of beds & occupancy rate | Data Collection - Details for YTD Maximum Days / Bed Type / YTD Maximum | Total | ||||||
97 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | April | ||||||
98 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | May | ||||||
99 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | June | ||||||
100 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | Subtotal ~ Q1 | ||||||
101 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | July | ||||||
102 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | August | ||||||
103 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | September | ||||||
104 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | Subtotal ~ Q2 | ||||||
105 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | October | ||||||
106 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | November | ||||||
107 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | December | ||||||
108 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | Subtotal ~ Q3 | ||||||
109 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | January | ||||||
110 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | February | ||||||
111 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | March | ||||||
112 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | Subtotal ~ Q4 | ||||||
113 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds | Total | ||||||
114 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | April | ||||||
115 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | May | ||||||
116 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | June | ||||||
117 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | Subtotal ~ Q1 | ||||||
118 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | July | ||||||
119 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | August | ||||||
120 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | September | ||||||
121 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | Subtotal ~ Q2 | ||||||
122 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | October | ||||||
123 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | November | ||||||
124 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | December | ||||||
125 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | Subtotal ~ Q3 | ||||||
126 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | January | ||||||
127 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | February | ||||||
128 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | March | ||||||
129 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | Subtotal ~ Q4 | ||||||
130 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds | Total | ||||||
131 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | April | ||||||
132 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | May | ||||||
133 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | June | ||||||
134 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | Subtotal ~ Q1 | ||||||
135 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | July | ||||||
136 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | August | ||||||
137 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | September | ||||||
138 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | Subtotal ~ Q2 | ||||||
139 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | October | ||||||
140 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | November | ||||||
141 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | December | ||||||
142 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | Subtotal ~ Q3 | ||||||
143 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | January | ||||||
144 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | February | ||||||
145 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | March | ||||||
146 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | Subtotal ~ Q4 | ||||||
147 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds | Total | ||||||
148 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | April | ||||||
149 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | May | ||||||
150 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | June | ||||||
151 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | Subtotal ~ Q1 | ||||||
152 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | July | ||||||
153 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | August | ||||||
154 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | September | ||||||
155 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | Subtotal ~ Q2 | ||||||
156 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | October | ||||||
157 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | November | ||||||
158 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | December | ||||||
159 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | Subtotal ~ Q3 | ||||||
160 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | January | ||||||
161 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | February | ||||||
162 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | March | ||||||
163 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | Subtotal ~ Q4 | ||||||
164 | # of beds & occupancy rate | Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days | Total | ||||||
165 | # 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 |
| ||||||
166 | # 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 |
| ||||||
167 | # 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 |
| ||||||
168 | # of beds & occupancy rate | Forecast ~ bed days maximum days / # of beds | In-scope 3.36 HPRD publicly funded beds - at April | ||||||
169 | # of beds & occupancy rate | Forecast ~ bed days maximum days / # of beds | In-scope 3.36 HPRD publicly funded beds - adjustment | ||||||
170 | # of beds & occupancy rate | Forecast ~ bed days maximum days / # of beds | Total | ||||||
171 | # of beds & occupancy rate | Forecast ~ bed days maximum days / Start | In-scope 3.36 HPRD publicly funded beds - at April | ||||||
172 | # of beds & occupancy rate | Forecast ~ bed days maximum days / Start | In-scope 3.36 HPRD publicly funded beds - adjustment | ||||||
173 | # of beds & occupancy rate | Forecast ~ bed days maximum days / End | In-scope 3.36 HPRD publicly funded beds - at April | ||||||
174 | # of beds & occupancy rate | Forecast ~ bed days maximum days / End | In-scope 3.36 HPRD publicly funded beds - adjustment | ||||||
175 | # of beds & occupancy rate | Forecast ~ bed days maximum days / # of days | In-scope 3.36 HPRD publicly funded beds - at April | ||||||
176 | # of beds & occupancy rate | Forecast ~ bed days maximum days / # of days | In-scope 3.36 HPRD publicly funded beds - adjustment | ||||||
177 | # of beds & occupancy rate | Forecast ~ bed days maximum days / Max. Days | In-scope 3.36 HPRD publicly funded beds - at April | ||||||
178 | # of beds & occupancy rate | Forecast ~ bed days maximum days / Max. Days | In-scope 3.36 HPRD publicly funded beds - adjustment | ||||||
179 | # of beds & occupancy rate | Forecast ~ bed days maximum days / Max. Days | Total | ||||||
180 | # of beds & occupancy rate | Forecast ~ resident days / Forecast | YTD resident days = | ||||||
181 | # of beds & occupancy rate | Forecast ~ resident days / Forecast | # of days for last qtr ending = | ||||||
182 | # of beds & occupancy rate | Forecast ~ resident days / Forecast | # of days for the fiscal year = | ||||||
183 | # of beds & occupancy rate | Forecast ~ resident days / Forecast | Forecast |