Versions Compared

Old Version 7

changes.mady.by.user Wagner Montes

Saved on

compared with

New Version 8

changes.mady.by.user Wagner Montes

Saved on

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

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

LTC Regular

52

# 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 Temp

53

# 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

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

Subtotal ~ in-scope 3.36 HPRD publicly funded beds

55

# 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

  • respite

56

# 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 life

57

# 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

58

# 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

59

# 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

  • other

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

Subtotal ~ out-of-scope publicly funded beds

61

# 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

62

# of beds & occupancy rate

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

Private beds located in separate wing/unit

63

# of beds & occupancy rate

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

Subtotal ~ private beds

64

# of beds & occupancy rate

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

Total Beds

65

# of beds & occupancy rate

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

LTC Regular

66

# of beds & occupancy rate

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

LTC Temp

67

# of beds & occupancy rate

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

Other ~ specify

68

# of beds & occupancy rate

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

Subtotal ~ in-scope 3.36 HPRD publicly funded beds

69

# of beds & occupancy rate

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

  • respite

70

# of beds & occupancy rate

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

  • end of life

71

# of beds & occupancy rate

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

  • convalescent

72

# of beds & occupancy rate

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

  • flex

73

# of beds & occupancy rate

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

  • other

74

# of beds & occupancy rate

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

75

# of beds & occupancy rate

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

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

76

# of beds & occupancy rate

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

Private beds located in separate wing/unit

77

# of beds & occupancy rate

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

Subtotal ~ private beds

78

# of beds & occupancy rate

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

Total Beds

79

# of beds & occupancy rate

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

LTC Regular

80

# of beds & occupancy rate

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

LTC Temp

81

# of beds & occupancy rate

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

Other ~ specify

82

# of beds & occupancy rate

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

83

# of beds & occupancy rate

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

  • respite

84

# of beds & occupancy rate

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

  • end of life

85

# of beds & occupancy rate

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

  • convalescent

86

# of beds & occupancy rate

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

  • flex

87

# of beds & occupancy rate

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

  • other

88

# of beds & occupancy rate

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

89

# of beds & occupancy rate

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

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

90

# of beds & occupancy rate

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

Private beds located in separate wing/unit

91

# of beds & occupancy rate

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

Subtotal ~ private beds

92

# of beds & occupancy rate

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

Total Beds

93

# of beds & occupancy rate

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

  1. In- scope 3.36 HPRD publicly funded beds

94

# of beds & occupancy rate

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

  1. Out of scope publicly funded bed

95

# of beds & occupancy rate

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

  1. Private Beds

96

# of beds & occupancy rate

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

Total beds and YTD occupied days

97

# of beds & occupancy rate

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

  1. In- scope 3.36 HPRD publicly funded beds

98

# of beds & occupancy rate

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

  1. Out of scope publicly funded bed

99

# of beds & occupancy rate

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

  1. Private Beds

100

# of beds & occupancy rate

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

Total beds and YTD occupied days

101

# of beds & occupancy rate

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

  1. In- scope 3.36 HPRD publicly funded beds

102

# of beds & occupancy rate

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

  1. Out of scope publicly funded bed

103

# of beds & occupancy rate

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

  1. Private Beds

104

# of beds & occupancy rate

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

Total beds and YTD occupied days

105

# of beds & occupancy rate

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

  1. In- scope 3.36 HPRD publicly funded beds

106

# of beds & occupancy rate

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

  1. Out of scope publicly funded bed

107

# of beds & occupancy rate

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

  1. Private Beds

108

# of beds & occupancy rate

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

Total beds and YTD occupied days

109

# 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

Time selection based on which quarter is being reported - needs Bonnie’s confirmation

110

# 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

111

# of beds & occupancy rate

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

Subtotal 

112

# 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- at April 1

Time selection based on which quarter is being reported - needs Bonnie’s confirmation

113

# 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- adjustments

114

# of beds & occupancy rate

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

Subtotal

115

# of beds & occupancy rate

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

3. Private Beds Field Name to be confirmed- at April 1

Time selection based on which quarter is being reported - needs Bonnie’s confirmation

116

# of beds & occupancy rate

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

3. Private Beds

Field Name to be confirmed

- adjustments

117

# of beds & occupancy rate

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

Subtotal

118

# of beds & occupancy rate

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

Total

119

# 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

Time selection based on which quarter is being reported - needs Bonnie’s confirmation

120

# of beds & occupancy rate

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

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

121

# of beds & occupancy rate

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

2. Out-of-scope publicly funded beds

122

# of beds & occupancy rate

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

2. Out-of-scope publicly funded beds

123

# of beds & occupancy rate

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

3. Private Beds

124

# of beds & occupancy rate

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

3. Private Beds

125

# 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

Time selection based on which quarter is being reported - needs Bonnie’s confirmation

126

# of beds & occupancy rate

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

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

127

# of beds & occupancy rate

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

2. Out-of-scope publicly funded beds

128

# of beds & occupancy rate

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

2. Out-of-scope publicly funded beds

129

# of beds & occupancy rate

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

3. Private Beds

130

# of beds & occupancy rate

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

3. Private Beds

131

# 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

132

# 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

133

# of beds & occupancy rate

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

2. Out-of-scope publicly funded beds

134

# of beds & occupancy rate

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

2. Out-of-scope publicly funded beds

135

# of beds & occupancy rate

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

3. Private Beds

136

# of beds & occupancy rate

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

3. Private Beds

137

# 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

138

# 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

139

# of beds & occupancy rate

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

Subtotal 

140

# 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

141

# 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

142

# of beds & occupancy rate

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

Subtotal

143

# of beds & occupancy rate

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

3. Private Beds

Field Name to be confirmed

144

# of beds & occupancy rate

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

3. Private Beds

Field Name to be confirmed

145

# of beds & occupancy rate

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

Subtotal

146

# of beds & occupancy rate

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

Total

147

# of beds & occupancy rate

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

April 

148

# of beds & occupancy rate

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

May

149

# of beds & occupancy rate

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

June

150

# of beds & occupancy rate

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

Subtotal ~ Q1

151

# of beds & occupancy rate

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

July

152

# of beds & occupancy rate

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

August

153

# of beds & occupancy rate

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

September

154

# of beds & occupancy rate

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

Subtotal ~ Q2

155

# of beds & occupancy rate

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

October

156

# of beds & occupancy rate

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

November

157

# of beds & occupancy rate

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

December

158

# of beds & occupancy rate

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

Subtotal ~ Q3

159

# of beds & occupancy rate

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

January

160

# of beds & occupancy rate

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

February

161

# of beds & occupancy rate

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

March 

162

# of beds & occupancy rate

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

Subtotal ~ Q4

163

# of beds & occupancy rate

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

Total

164

# of beds & occupancy rate

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

April 

165

# of beds & occupancy rate

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

May

166

# of beds & occupancy rate

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

June

167

# of beds & occupancy rate

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

Subtotal ~ Q1

168

# of beds & occupancy rate

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

July

169

# of beds & occupancy rate

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

August

170

# of beds & occupancy rate

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

September

171

# of beds & occupancy rate

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

Subtotal ~ Q2

172

# of beds & occupancy rate

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

October

173

# of beds & occupancy rate

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

November

174

# of beds & occupancy rate

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

December

175

# of beds & occupancy rate

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

Subtotal ~ Q3

176

# of beds & occupancy rate

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

January

177

# of beds & occupancy rate

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

February

178

# of beds & occupancy rate

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

March 

179

# of beds & occupancy rate

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

Subtotal ~ Q4

180

# of beds & occupancy rate

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

Total

181

# of beds & occupancy rate

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

April 

182

# of beds & occupancy rate

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

May

183

# of beds & occupancy rate

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

June

184

# of beds & occupancy rate

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

Subtotal ~ Q1

185

# of beds & occupancy rate

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

July

186

# of beds & occupancy rate

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

August

187

# of beds & occupancy rate

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

September

188

# of beds & occupancy rate

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

Subtotal ~ Q2

189

# of beds & occupancy rate

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

October

190

# of beds & occupancy rate

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

November

191

# of beds & occupancy rate

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

December

192

# of beds & occupancy rate

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

Subtotal ~ Q3

193

# of beds & occupancy rate

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

January

194

# of beds & occupancy rate

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

February

195

# of beds & occupancy rate

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

March 

196

# of beds & occupancy rate

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

Subtotal ~ Q4

197

# of beds & occupancy rate

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

Total

198

# of beds & occupancy rate

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

April 

199

# of beds & occupancy rate

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

May

200

# of beds & occupancy rate

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

June

201

# of beds & occupancy rate

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

Subtotal ~ Q1

202

# of beds & occupancy rate

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

July

203

# of beds & occupancy rate

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

August

204

# of beds & occupancy rate

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

September

205

# of beds & occupancy rate

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

Subtotal ~ Q2

206

# of beds & occupancy rate

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

October

207

# of beds & occupancy rate

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

November

208

# of beds & occupancy rate

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

December

209

# of beds & occupancy rate

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

Subtotal ~ Q3

210

# of beds & occupancy rate

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

January

211

# of beds & occupancy rate

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

February

212

# of beds & occupancy rate

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

March 

213

# of beds & occupancy rate

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

Subtotal ~ Q4

214

# of beds & occupancy rate

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

Total

215

# 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

216

# 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

217

# 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

218

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of beds

In-scope 3.36 HPRD publicly funded beds - at April

219

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of beds

In-scope 3.36 HPRD publicly funded beds - adjustment

220

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of beds

Total

221

# of beds & occupancy rate

Forecast ~ bed days maximum days / Start

In-scope 3.36 HPRD publicly funded beds - at April

222

# of beds & occupancy rate

Forecast ~ bed days maximum days / Start

In-scope 3.36 HPRD publicly funded beds - adjustment

223

# of beds & occupancy rate

Forecast ~ bed days maximum days / End

In-scope 3.36 HPRD publicly funded beds - at April

224

# of beds & occupancy rate

Forecast ~ bed days maximum days / End

In-scope 3.36 HPRD publicly funded beds - adjustment

225

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of days

In-scope 3.36 HPRD publicly funded beds - at April

226

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of days

In-scope 3.36 HPRD publicly funded beds - adjustment

227

# of beds & occupancy rate

Forecast ~ bed days maximum days / Max. Days

In-scope 3.36 HPRD publicly funded beds - at April

228

# of beds & occupancy rate

Forecast ~ bed days maximum days / Max. Days

In-scope 3.36 HPRD publicly funded beds - adjustment

229

# of beds & occupancy rate

Forecast ~ bed days maximum days / Max. Days

Total

230

# of beds & occupancy rate

Forecast ~ resident days / Forecast

YTD resident days = 

231

# of beds & occupancy rate

Forecast ~ resident days / Forecast

# of days for last qtr ending =

232

# of beds & occupancy rate

Forecast ~ resident days / Forecast

# of days for the fiscal year =

233

# of beds & occupancy rate

Forecast ~ resident days / Forecast

Forecast

234

235

236

237

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