Versions Compared

Key

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

View file
nameweb-tool - data collection - Bonnie - 2022_07_25.xlsx

...

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

Address3

Facility Information

Facility Information

City4

Facility Information

Facility Information

Postal Code

5

Facility Information

Facility Information

Telephone

6

Facility Information

Facility Information

FAX7

Facility Information

Facility Information

Facility's website Address8

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 Date14

Facility Information

Facility Information

Accreditation Expiry Date

15

Facility Information

Facility Information

Health Authority16

Facility Information

Facility Information

Local Health Authoriy17

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 Date24

Facility Information

Owner Information

Health Authority25

Facility Information

Owner Information

Local Health Authority

26

Facility Information

Operator Information

Operator Name   

27

Facility Facility Information

Operator Information

Address28

Facility Information

Operator Information

City

29

Facility Information

Operator Information

Postal Code

30

Facility Information

Operator Information

Telephone31

Facility Information

Operator Information

FAX32

Facility Information

Operator Information

(Contact) Name33

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

Position38

Facility Information

Preparer Contact Information

Telephone39

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 Address45

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) Position49

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/ At April 1

LTC Regular

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / At April 1

LTC RegularTemp

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 / In-Scope 3.36 HPRD Publicly Funded Beds / At April 1

Other ~ specify

55

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / In-Scope 3.36 HPRD Publicly Funded Beds / At April 1

Subtotal ~ in-scope 3.36 HPRD publicly funded beds56

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1 Out of Scope Publicly Funded Beds 57/ Short Stay Beds / At April 1

  • respite

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / At April 1

Short Stay Beds

58
  • end of life

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1

  • respite

59Out of Scope Publicly Funded Beds / Short Stay Beds / At April 1

  • convalescent

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / At April 1

  • end of lifeflex

60

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / At April 1

  • convalescent

61
  • other

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / At April 1

  • flex

62

Subtotal ~ out-of-scope publicly funded beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / At April 1

  • other

63

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1

Subtotal ~ out-ofPrivate beds co-located with in-scope publicly funded beds

64

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / At April 1

Private Beds

65

beds located in separate wing/unit

# of beds & occupancy rate

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

66Subtotal ~ private beds

# 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

Total Beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1

Subtotal ~ private beds

68In-Scope 3.36 HPRD Publicly Funded Beds / Adjustment

LTC Regular

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / At April 1

Total Beds

69In-Scope 3.36 HPRD Publicly Funded Beds / Adjustment

LTC Temp

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment In-Scope 3.36 HPRD Publicly Funded Beds / Adjustment

70Other ~ specify

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment

LTC Regular

71In-Scope 3.36 HPRD Publicly Funded Beds / Adjustment

Subtotal ~ in-scope 3.36 HPRD publicly funded beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / Adjustment

LTC Temp

72
  • respite

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment

Other ~ specify

73Out of Scope Publicly Funded Beds / Short Stay Beds / Adjustment

  • end of life

# 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

Out of Scope Publicly Funded Beds / Short Stay Beds / Adjustment

  • convalescent

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment Out of Scope Publicly Funded Beds / Short Stay Beds / Adjustment75

  • flex

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / AdjustmentOut of Scope Publicly Funded Beds / Short Stay Beds / Adjustment76

  • other

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment

  • respite

77

# of beds Out of Scope Publicly Funded Beds / Short Stay Beds / Adjustment

Subtotal ~ out-of-scope publicly funded beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / Adjustment

  • end of life

78

Private beds co-located with in-scope publicly funded beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / Adjustment

  • convalescent

79

Private beds located in separate wing/unit

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / Adjustment

  • flex

80

Subtotal ~ private beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment

other

Total Beds

81

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment

Subtotal ~ out-of-scope publicly funded beds

82In-Scope 3.36 HPRD Publicly Funded Beds / Revised

LTC Regular

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment

Private Beds

83In-Scope 3.36 HPRD Publicly Funded Beds / Revised

LTC Temp

# 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

84In-Scope 3.36 HPRD Publicly Funded Beds / Revised

Other ~ specify

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment

Private beds located in separate wing/unit

85

In-Scope 3.36 HPRD Publicly Funded Beds / Revised

Subtotal ~ in-scope 3.36 HPRD publicly funded beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment

Subtotal ~ private beds

86Out of Scope Publicly Funded Beds / Short Stay Beds / Revised

  • respite

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Adjustment

Total Beds

87/ Out of Scope Publicly Funded Beds / Short Stay Beds / Revised

  • end of life

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / RevisedIn-Scope 3.36 HPRD Out of Scope Publicly Funded Beds 88/ Short Stay Beds / Revised

  • convalescent

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / RevisedLTC Regular

  • flex

89

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Out of Scope Publicly Funded Beds / Short Stay Beds / RevisedLTC Temp

  • other

90

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised

Other ~ specify

91

Out of Scope Publicly Funded Beds / Short Stay Beds / Revised

Subtotal ~ out-of-scope publicly funded beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / Revised

Subtotal ~ Private beds co-located with in-scope 3.36 HPRD publicly funded beds92

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised

Out of Scope Publicly Funded Beds

93

Private Beds / Revised

Private beds located in separate wing/unit

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Private Beds / Revised

Short Stay Beds

94Subtotal ~ private beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised

respite

Total Beds

95

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised

  • end of life

96

- Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds

  1. In- scope 3.36 HPRD publicly funded beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised

  • convalescent

97- Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds

  1. Out of scope publicly funded bed

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised

  • flex

98- Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds

  1. Private Beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised

  • other

99- Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds

Total beds and YTD occupied days

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / RevisedSubtotal ~ out-of-scope - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days

  1. In- scope 3.36 HPRD publicly funded beds

100

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised

Private Beds

101- Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days

  1. Out of scope publicly funded bed

# 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- Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days

  1. Private Beds

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised

Private beds located in separate wing/unit

103- Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days

Total beds and YTD occupied days

# of beds & occupancy rate

Data Collection ~ Bed Inventory / # of beds in the facility / Budget / Revised

Subtotal ~ private beds

104

- Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Occupied Days

  1. In- scope 3.36 HPRD publicly funded beds

# 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-- Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds

  1. In- scope 3.36 HPRD publicly funded beds

106YTD Occupied Days

  1. Out of scope publicly funded bed

# of beds & occupancy rate

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved YTD Occupied Days

  1. Private Beds

  1. Out of scope publicly funded bed

107

# of beds & occupancy rate

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / Approved Beds

  1. Private Beds

108

YTD Occupied Days

Total beds and YTD occupied days

# 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

% Occupied

  1. 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% Occupied

  1. 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% Occupied

  1. Private Beds

112

# of beds & occupancy rate

Data Collection - Year-to-Date (YTD) Resident Bed Days / Bed Types / YTD Maximum Days% Occupied

Total beds and YTD occupied days

113

# of beds & occupancy rate

Data Collection - Year-to-Date (YTD) Resident Bed Details for YTD Maximum Days / Bed Types / YTD Occupied DaysType / # of Beds

1. In-scope 3.36 HPRD publicly funded beds

114- at April 1

# of beds & occupancy rate

Data Collection - Year-to-Date (YTD) Resident Bed Details for YTD Maximum Days / Bed Types / YTD Occupied Days

  1. Out of scope publicly funded bed

115

Type / # of Beds

1. In-scope 3.36 HPRD publicly funded beds - adjustments

# of beds & occupancy rate

Data Collection - Year-to-Date (YTD) Resident Bed Details for YTD Maximum Days / Bed Types / YTD Occupied Days

Private

Type / # of Beds

116Subtotal 

# of beds & occupancy rate

Data Collection - Year-to-Date (YTD) Resident Bed Details for YTD Maximum Days / Bed Types / YTD Occupied Days

Total beds and YTD occupied days

117Type / # of Beds

2. Out-of-scope publicly funded beds

Field Name to be confirmed

# of beds & occupancy rate

Data Collection - Year-to-Date (YTD) Resident Bed Details for YTD Maximum Days / Bed Types / % Occupied

In- scope 3.36 HPRD

Type / # of Beds

2. Out-of-scope publicly funded beds

118Field Name to be confirmed

# of beds & occupancy rate

Data Collection - Year-to-Date (YTD) Resident Bed Details for YTD Maximum Days / Bed Types / % Occupied

  1. Out of scope publicly funded bed

119Type / # of Beds

Subtotal

# of beds & occupancy rate

Data Collection - Year-to-Date (YTD) Resident Bed Details for YTD Maximum Days / Bed Types / % OccupiedType / # of Beds

3. Private Beds120

Field Name to be confirmed

# of beds & occupancy rate

Data Collection - Year-to-Date (YTD) Resident Bed Details for YTD Maximum Days / Bed Types / % Occupied

Total beds and YTD occupied days

121Type / # of Beds

3. Private Beds

Field Name to be confirmed

# 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

Subtotal

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds1. In

Total

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / Start

1. In-scope 3.36 HPRD publicly funded beds - adjustmentsat April 1

123

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

Subtotal 

124

Start

1. In-scope 3.36 HPRD publicly funded beds - adjustments

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of BedsStart

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 BedsStart

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

Start

3. Private Beds

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of BedsStart

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

End

1. In-scope 3.36 HPRD publicly funded beds - at April 1

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

Subtotal

130End

1. In-scope 3.36 HPRD publicly funded beds - adjustments

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of Beds

Total

131

End

2. Out-of-scope publicly funded beds

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / StartEnd

12. InOut-of-scope 3.36 HPRD publicly funded beds - at April 1

132

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / StartEnd

1. In-scope 3. 36 HPRD publicly funded beds - adjustments

133

Private Beds

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / StartEnd

2. Out-of-scope publicly funded beds

134

3. Private Beds

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / Start# of days

21. OutIn-of-scope 3.36 HPRD publicly funded beds 135- at April 1

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / Start

3. Private Beds

136

# of days

1. In-scope 3.36 HPRD publicly funded beds - adjustments

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / Start# of days

3. Private Beds

137

2. Out-of-scope publicly funded beds

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / End# of days

12. InOut-of-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 days

3. Private Beds

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / End# of days

2. Out-of-scope publicly funded beds

140

3. Private Beds

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / EndYTD Maximum

21. OutIn-of-scope 3.36 HPRD publicly funded beds - at April 1

141

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / End

3. Private Beds

142

YTD Maximum

1. In-scope 3.36 HPRD publicly funded beds - adjustments

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / End

3. Private Beds

143YTD Maximum

Subtotal 

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of days1. In-scope 3.36 HPRD YTD Maximum

2. Out-of-scope publicly funded beds - at April 1144

Field Name to be confirmed

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of days1. In-scope 3.36 HPRD YTD Maximum

2. Out-of-scope publicly funded beds - adjustments

145

Field Name to be confirmed

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of days

2. Out-of-scope publicly funded beds

146

YTD Maximum

Subtotal

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of days

2. Out-of-scope publicly funded beds

147YTD Maximum

3. Private Beds

Field Name to be confirmed

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of daysYTD Maximum

3. Private Beds148

Field Name to be confirmed

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Days / Bed Type / # of days

3. Private Beds

149YTD Maximum

Subtotal

# 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

Total

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

April 

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Occupied Days / Bed Type / YTD Maximum1. Monthly Activity / In-scope Scope 3.36 HPRD publicly funded beds - adjustments151Publicly Funded Beds

May

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Occupied Days / Bed Type / YTD Maximum

Subtotal 

152

Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

June

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Occupied Days / Bed Type / YTD Maximum

2. Out-of-scope publicly funded beds

Field Name to be confirmed

153

Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

Subtotal ~ Q1

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Occupied Days / Bed Type / YTD Maximum

2. Out-of-scope publicly funded beds

Field Name to be confirmed

154Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

July

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Occupied Days / Bed Type / YTD Maximum

Subtotal

155Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

August

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Occupied Days / Bed Type / YTD Maximum

3. Private Beds

Field Name to be confirmed

156

Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

September

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Occupied Days / Bed Type / YTD Maximum

3. Private Beds

Field Name to be confirmed

157Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

Subtotal ~ Q2

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Occupied Days / Bed Type / YTD Maximum

Subtotal

158

Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

October

# of beds & occupancy rate

Data Collection - Details for YTD Maximum Occupied Days / Bed Type / YTD Maximum

Total

159Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

November

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

April 

160December

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

MaySubtotal ~ Q3

161

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

JuneJanuary

162

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

Subtotal ~ Q1

163February

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

JulyMarch 

164

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

AugustSubtotal ~ Q4

165

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Funded Beds

SeptemberTotal

166

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Out of Scope Publicly Funded Beds

Subtotal ~ Q2April 

167

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Out of Scope Publicly Funded Beds

October

168May

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Out of Scope Publicly Funded Beds

NovemberJune

169

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Publicly Out of Scope Publicly Funded Beds

DecemberSubtotal ~ Q1

170

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Out of Scope Publicly Funded Beds

Subtotal ~ Q3July

171

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Out of Scope Publicly Funded Beds

JanuaryAugust

172

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Out of Scope Publicly Funded Beds

February

173September

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Out of Scope Publicly Funded Beds

March Subtotal ~ Q2

174

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Out of Scope Publicly Funded Beds

Subtotal ~ Q4October

175

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / In-Scope 3.36 HPRD Out of Scope Publicly Funded Beds

Total

176November

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

April December

177

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

May

178Subtotal ~ Q3

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

JuneJanuary

179

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

Subtotal ~ Q1February

180

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

July

181March 

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

AugustSubtotal ~ Q4

182

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

SeptemberTotal

183

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Private Beds

Subtotal ~ Q2April 

184

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Private Beds

October

185May

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Private Beds

November

186June

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Private Beds

December

187Subtotal ~ Q1

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Beds

Subtotal ~ Q3

188

Private Beds

July

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Private Beds

JanuaryAugust

189

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Private Beds

FebruarySeptember

190

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Private Beds

March Subtotal ~ Q2

191

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Private Beds

Subtotal ~ Q4October

192

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Out of Scope Publicly Funded Private Beds

Total

193November

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

April 

194December

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

MaySubtotal ~ Q3

195

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

JuneJanuary

196

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

Subtotal ~ Q1February

197

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

July

198March 

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

AugustSubtotal ~ Q4

199

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

September

200Total

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

Subtotal ~ Q2

201

Total Days

April 

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private BedsTotal Days

OctoberMay

202

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

November

203Total Days

June

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

December

204

Total Days

Subtotal ~ Q1

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

Subtotal ~ Q3

205Total Days

July

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

January

206Total Days

August

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private BedsTotal Days

FebruarySeptember

207

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

March 

208

Total Days

Subtotal ~ Q2

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds

Subtotal ~ Q4

209

Total Days

October

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Private Beds Total Days

210November

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

April December

211

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

May

212Subtotal ~ Q3

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

JuneJanuary

213

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

Subtotal ~ Q1February

214

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

July

215March 

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

August

216Subtotal ~ Q4

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

SeptemberTotal

217

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

Subtotal ~ Q2

218

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

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

October

219

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

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

November

220

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

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

December

221

Forecast ~ bed days maximum days / # of beds

In-scope 3.36 HPRD publicly funded beds - at April

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

Subtotal ~ Q3

222

Forecast ~ bed days maximum days / # of beds

In-scope 3.36 HPRD publicly funded beds - adjustment

# of beds & occupancy rate

Data Collection - Details for YTD Occupied Days / Monthly Activity / Total Days

January

223

Forecast ~ bed days maximum days / # 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

Forecast ~ bed days maximum days / Start

In-scope 3.36 HPRD publicly funded beds - at April

# 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

Forecast ~ bed days maximum days / Start

In-scope 3.36 HPRD publicly funded beds - adjustment

# of beds & occupancy rate

Forecast Bed Days & Resident Days for in~ bed days maximum days / End

In-scope 3.36 HPRD publicly funded beds (for 3.36 HPRD reporting) / Bed Types / # of Beds 1. In - at April

# of beds & occupancy rate

Forecast ~ bed days maximum days / End

In-scope 3.36 HPRD publicly funded beds - adjustment

228

# of beds & occupancy rate

Forecast Bed Days & Resident Days for in~ bed days maximum days / # of days

In-scope 3.36 HPRD publicly funded beds (for 3.36 HPRD reporting) / Bed Types / Bed days Maximum Days 1. In - at April

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of days

In-scope 3.36 HPRD publicly funded beds 229- adjustment

# 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 ~ bed days maximum days / Max. Days

In-scope 3.36 HPRD publicly funded beds 230- at April

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of bedsMax. Days

In-scope 3.36 HPRD publicly funded beds - at Apriladjustment

231

# of beds & occupancy rate

Forecast ~ bed days maximum days / Max. Days

Total

# of beds In-scope 3.36 HPRD publicly funded beds - adjustment& occupancy rate

Forecast ~ resident days / Forecast

YTD resident days = 

# of beds & occupancy rate

Forecast ~ bed resident days maximum days / Forecast

# of beds

Total

232

days for last qtr ending =

# of beds & occupancy rate

Forecast ~ bed days maximum resident days / Start

In-scope 3.36 HPRD publicly funded beds - at April

233

Forecast

# of days for the fiscal year =

# of beds & occupancy rate

Forecast ~ bed resident 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

434Forecast

Forecast