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

...

The report data is organized in three colored sections besides the facility information:

  • Detail each section

Bonnie’s notes:

Quarterly Reporting

...

  • wage costs

  • benefits including:

    • employer paid benefits

    • shift differentials and premiums (ie, remote site)

    • vacation, statutory holidays

    • sick time

    • overtime

    • severance

    • retiring allowances

    • other paid leave (ie, orientation, education, etc)

    • purchased labour cost and meal allowances

...

Index

...

Table

...

Session

...

Field Name

...

Excel position or Column

...

Field Type

int/ float / string

...

Calculated Field

(specify formula/calculation)

...

Dependencies (Internal Sources)

...

Notes

...

1

...

Facility Information

...

Facility Information

...

Facility Name

...

2

...

Facility Information

...

Facility Information

...

Address

...

3

...

Facility Information

...

Facility Information

...

City

...

4

...

Facility Information

...

Facility Information

...

Postal Code

...

5

...

Facility Information

...

Facility Information

...

Telephone

...

6

...

Facility Information

...

Facility Information

...

FAX

...

7

...

Facility Information

...

Facility Information

...

Facility's website Address

...

8

...

Facility Information

...

Facility Information

...

Site ID #

...

9

...

Facility Information

...

Facility Information

...

Program Type 

...

10

...

Facility Information

...

Facility Information

...

Ownership Type

...

11

...

Facility Information

...

Facility Information

...

Legislation

...

12

...

Facility Information

...

Facility Information

...

Accreditation Body

...

13

...

Facility Information

...

Facility Information

...

Accreditation Date

...

14

...

Facility Information

...

Facility Information

...

Accreditation Expiry Date

...

15

...

Facility Information

...

Facility Information

...

Health Authority

...

16

...

Facility Information

...

Facility Information

...

Local Health Authoriy

...

17

...

Facility Information

...

Owner Information

...

Site ID #

...

18

...

Facility Information

...

Owner Information

...

Program Type 

...

19

...

Facility Information

...

Owner Information

...

Ownership Type

...

20

...

Facility Information

...

Owner Information

...

Legislation

...

21

...

Facility Information

...

Owner Information

...

Accreditation Body

...

22

...

Facility Information

...

Owner Information

...

Accreditation Date

...

23

...

Facility Information

...

Owner Information

...

Accreditation Expiry Date

...

24

...

Facility Information

...

Owner Information

...

Health Authority

...

25

...

Facility Information

...

Owner Information

...

Local Health Authority

...

26

...

Facility Information

...

Operator Information

...

Operator Name   

...

27

...

Facility Information

...

Operator Information

...

Address

...

28

...

Facility Information

...

Operator Information

...

City

...

29

...

Facility Information

...

Operator Information

...

Postal Code

...

30

...

Facility Information

...

Operator Information

...

Telephone

...

31

...

Facility Information

...

Operator Information

...

FAX

...

32

...

Facility Information

...

Operator Information

...

(Contact) Name

...

33

...

Facility Information

...

Operator Information

...

(Contact) Position

...

34

...

Facility Information

...

Operator Information

...

(Contact) Telephone

...

35

...

Facility Information

...

Operator Information

...

(Contact) E-mail Address

...

36

...

Facility Information

...

Preparer Contact Information

...

Name

...

37

...

Facility Information

...

Preparer Contact Information

...

Position

...

38

...

Facility Information

...

Preparer Contact Information

...

Telephone

...

39

...

Facility Information

...

Preparer Contact Information

...

E-mail Address

...

40

...

Facility Information

...

Preparer Contact Information

...

Fax

...

41

...

Facility Information

...

CFO or VP Finance Contact Information

...

Name

...

42

...

Facility Information

...

CFO or VP Finance Contact Information

...

Position

...

43

...

Facility Information

...

CFO or VP Finance Contact Information

...

Telephone

...

44

...

Facility Information

...

CFO or VP Finance Contact Information

...

E-mail Address

...

45

...

Facility Information

...

CFO or VP Finance Contact Information

...

Fax

...

46

...

Facility Information

...

Auditor's Contact Information

...

Audit Firm

...

47

...

Facility Information

...

Auditor's Contact Information

...

(Contact) Name

...

48

...

Facility Information

...

Auditor's Contact Information

...

(Contact) Position

...

49

...

Facility Information

...

Auditor's Contact Information

...

(Contact) Telephone

...

50

...

Facility Information

...

Auditor's Contact Information

...

(Contact) E-mail Address

...

51

...

# of beds & occupancy rate

...

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

...

In-Scope 3.36 HPRD Publicly Funded Beds

...

52

...

# of beds & occupancy rate

...

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

...

LTC Regular

...

53

...

# of beds & occupancy rate

...

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

...

LTC Temp

...

54

...

# of beds & occupancy rate

...

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

...

Other ~ specify

...

55

...

# of beds & occupancy rate

...

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

...

Subtotal ~ in-scope 3.36 HPRD publicly funded beds

...

56

...

# of beds & occupancy rate

...

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

...

Out of Scope Publicly Funded Beds

...

57

...

# of beds & occupancy rate

...

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

...

Short Stay Beds

...

58

...

# of beds & occupancy rate

...

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

...

  • respite

...

59

...

# of beds & occupancy rate

...

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

...

  • end of life

...

60

...

# of beds & occupancy rate

...

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

...

  • convalescent

...

61

...

# of beds & occupancy rate

...

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

...

  • flex

...

62

...

# of beds & occupancy rate

...

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

...

  • other

...

63

...

# of beds & occupancy rate

...

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

...

Subtotal ~ out-of-scope publicly funded beds

...

64

...

# of beds & occupancy rate

...

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

...

Private Beds

...

65

...

# of beds & occupancy rate

...

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

...

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

...

66

...

# of beds & occupancy rate

...

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

...

Private beds located in separate wing/unit

...

67

...

# of beds & occupancy rate

...

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

...

Subtotal ~ private beds

...

68

...

# of beds & occupancy rate

...

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

...

Total Beds

...

69

...

# of beds & occupancy rate

...

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

...

In-Scope 3.36 HPRD Publicly Funded Beds

...

70

...

# of beds & occupancy rate

...

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

...

LTC Regular

...

71

...

# of beds & occupancy rate

...

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

...

LTC Temp

...

72

...

# of beds & occupancy rate

...

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

...

Other ~ specify

...

73

...

# of beds & occupancy rate

...

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

...

Subtotal ~ in-scope 3.36 HPRD publicly funded beds

...

74

...

# of beds & occupancy rate

...

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

...

Out of Scope Publicly Funded Beds

...

75

...

# of beds & occupancy rate

...

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

...

Short Stay Beds

...

76

...

# of beds & occupancy rate

...

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

...

  • respite

...

77

...

# of beds & occupancy rate

...

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

...

  • end of life

...

78

...

# of beds & occupancy rate

...

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

...

  • convalescent

...

79

...

# of beds & occupancy rate

...

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

...

  • flex

...

80

...

# of beds & occupancy rate

...

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

...

  • other

...

81

...

# of beds & occupancy rate

...

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

...

Subtotal ~ out-of-scope publicly funded beds

...

82

...

# of beds & occupancy rate

...

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

...

Private Beds

...

83

...

# of beds & occupancy rate

...

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

...

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

...

84

...

# of beds & occupancy rate

...

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

...

Private beds located in separate wing/unit

...

85

...

# of beds & occupancy rate

...

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

...

Subtotal ~ private beds

...

86

...

# of beds & occupancy rate

...

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

...

Total Beds

...

87

...

# of beds & occupancy rate

...

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

...

In-Scope 3.36 HPRD Publicly Funded Beds

...

88

...

# of beds & occupancy rate

...

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

...

LTC Regular

...

89

...

# of beds & occupancy rate

...

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

...

LTC Temp

...

90

...

# of beds & occupancy rate

...

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

...

Other ~ specify

...

91

...

# of beds & occupancy rate

...

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

...

Subtotal ~ in-scope 3.36 HPRD publicly funded beds

...

92

...

# of beds & occupancy rate

...

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

...

Out of Scope Publicly Funded Beds

...

93

...

# of beds & occupancy rate

...

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

...

Short Stay Beds

...

94

...

# of beds & occupancy rate

...

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

...

  • respite

...

95

...

# of beds & occupancy rate

...

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

...

  • end of life

...

96

...

# of beds & occupancy rate

...

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

...

  • convalescent

...

97

...

# of beds & occupancy rate

...

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

...

  • flex

...

98

...

# of beds & occupancy rate

...

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

...

  • other

...

99

...

# of beds & occupancy rate

...

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

...

Subtotal ~ out-of-scope publicly funded beds

...

100

...

# of beds & occupancy rate

...

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

...

Private Beds

...

101

...

# of beds & occupancy rate

...

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

...

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

...

102

...

# of beds & occupancy rate

...

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

...

Private beds located in separate wing/unit

...

103

...

# of beds & occupancy rate

...

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

...

Subtotal ~ private beds

...

104

...

# of beds & occupancy rate

...

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

...

Total Beds

...

105

...

# of beds & occupancy rate

...

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

...

  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 / Approved 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

...

# 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

...

  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

...

  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

...

  1. Private Beds

...

112

...

# of beds & occupancy rate

...

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

...

Total beds and YTD occupied days

...

113

...

# of beds & occupancy rate

...

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

...

  1. In- scope 3.36 HPRD publicly funded beds

...

114

...

# of beds & occupancy rate

...

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

...

  1. Out of scope publicly funded bed

...

115

...

# of beds & occupancy rate

...

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

...

  1. Private Beds

...

116

...

# of beds & occupancy rate

...

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

...

Total beds and YTD occupied days

...

117

...

# of beds & occupancy rate

...

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

...

  1. In- scope 3.36 HPRD publicly funded beds

...

118

...

# of beds & occupancy rate

...

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

...

  1. Out of scope publicly funded bed

...

119

...

# of beds & occupancy rate

...

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

...

  1. Private Beds

...

120

...

# of beds & occupancy rate

...

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

...

Total beds and YTD occupied days

...

121

...

# of beds & occupancy rate

...

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

...

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

...

122

...

# of beds & occupancy rate

...

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

...

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

...

123

...

# of beds & occupancy rate

...

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

...

Subtotal 

...

124

...

# of beds & occupancy rate

...

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

...

2. Out-of-scope publicly funded beds

...

Field Name to be confirmed

...

125

...

# of beds & occupancy rate

...

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

...

2. Out-of-scope publicly funded beds

...

Field Name to be confirmed

...

126

...

# of beds & occupancy rate

...

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

...

Subtotal

...

127

...

# of beds & occupancy rate

...

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

...

3. Private Beds

...

Field Name to be confirmed

...

128

...

# of beds & occupancy rate

...

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

...

3. Private Beds

...

Field Name to be confirmed

...

129

...

# of beds & occupancy rate

...

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

...

Subtotal

...

130

...

# of beds & occupancy rate

...

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

...

Total

...

131

...

# of beds & occupancy rate

...

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

...

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

...

132

...

# of beds & occupancy rate

...

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

...

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

...

133

...

# of beds & occupancy rate

...

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

...

2. Out-of-scope publicly funded beds

...

134

...

# of beds & occupancy rate

...

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

...

2. Out-of-scope publicly funded beds

...

135

...

# of beds & occupancy rate

...

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

...

3. Private Beds

...

136

...

# of beds & occupancy rate

...

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

...

3. Private Beds

...

137

...

# of beds & occupancy rate

...

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

...

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

...

138

...

# of beds & occupancy rate

...

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

...

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

...

139

...

# of beds & occupancy rate

...

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

...

2. Out-of-scope publicly funded beds

...

140

...

# of beds & occupancy rate

...

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

...

2. Out-of-scope publicly funded beds

...

141

...

# of beds & occupancy rate

...

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

...

3. Private Beds

...

142

...

# of beds & occupancy rate

...

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

...

3. Private Beds

...

143

...

# of beds & occupancy rate

...

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

...

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

...

144

...

# of beds & occupancy rate

...

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

...

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

...

145

...

# of beds & occupancy rate

...

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

...

2. Out-of-scope publicly funded beds

...

146

...

# of beds & occupancy rate

...

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

...

2. Out-of-scope publicly funded beds

...

147

...

# of beds & occupancy rate

...

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

...

3. Private Beds

...

148

...

# of beds & occupancy rate

...

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

...

3. Private Beds

...

149

...

# of beds & occupancy rate

...

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

...

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

...

150

...

# of beds & occupancy rate

...

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

...

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

...

151

...

# of beds & occupancy rate

...

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

...

Subtotal 

...

152

...

# of beds & occupancy rate

...

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

...

2. Out-of-scope publicly funded beds

...

Field Name to be confirmed

...

153

...

# of beds & occupancy rate

...

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

...

2. Out-of-scope publicly funded beds

...

Field Name to be confirmed

...

154

...

# of beds & occupancy rate

...

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

...

Subtotal

...

155

...

# of beds & occupancy rate

...

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

...

3. Private Beds

...

Field Name to be confirmed

...

156

...

# of beds & occupancy rate

...

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

...

3. Private Beds

...

Field Name to be confirmed

...

157

...

# of beds & occupancy rate

...

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

...

Subtotal

...

158

...

# of beds & occupancy rate

...

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

...

Total

...

159

...

# of beds & occupancy rate

...

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

...

April 

...

160

...

# of beds & occupancy rate

...

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

...

May

...

161

...

# of beds & occupancy rate

...

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

...

June

...

162

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q1

...

163

...

# of beds & occupancy rate

...

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

...

July

...

164

...

# of beds & occupancy rate

...

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

...

August

...

165

...

# of beds & occupancy rate

...

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

...

September

...

166

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q2

...

167

...

# of beds & occupancy rate

...

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

...

October

...

168

...

# of beds & occupancy rate

...

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

...

November

...

169

...

# of beds & occupancy rate

...

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

...

December

...

170

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q3

...

171

...

# of beds & occupancy rate

...

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

...

January

...

172

...

# of beds & occupancy rate

...

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

...

February

...

173

...

# of beds & occupancy rate

...

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

...

March 

...

174

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q4

...

175

...

# of beds & occupancy rate

...

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

...

Total

...

176

...

# of beds & occupancy rate

...

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

...

April 

...

177

...

# of beds & occupancy rate

...

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

...

May

...

178

...

# of beds & occupancy rate

...

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

...

June

...

179

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q1

...

180

...

# of beds & occupancy rate

...

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

...

July

...

181

...

# of beds & occupancy rate

...

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

...

August

...

182

...

# of beds & occupancy rate

...

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

...

September

...

183

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q2

...

184

...

# of beds & occupancy rate

...

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

...

October

...

185

...

# of beds & occupancy rate

...

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

...

November

...

186

...

# of beds & occupancy rate

...

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

...

December

...

187

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q3

...

188

...

# of beds & occupancy rate

...

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

...

January

...

189

...

# of beds & occupancy rate

...

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

...

February

...

190

...

# of beds & occupancy rate

...

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

...

March 

...

191

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q4

...

192

...

# of beds & occupancy rate

...

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

...

Total

...

193

...

# of beds & occupancy rate

...

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

...

April 

...

194

...

# of beds & occupancy rate

...

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

...

May

...

195

...

# of beds & occupancy rate

...

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

...

June

...

196

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q1

...

197

...

# of beds & occupancy rate

...

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

...

July

...

198

...

# of beds & occupancy rate

...

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

...

August

...

199

...

# of beds & occupancy rate

...

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

...

September

...

200

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q2

...

201

...

# of beds & occupancy rate

...

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

...

October

...

202

...

# of beds & occupancy rate

...

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

...

November

...

203

...

# of beds & occupancy rate

...

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

...

December

...

204

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q3

...

205

...

# of beds & occupancy rate

...

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

...

January

...

206

...

# of beds & occupancy rate

...

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

...

February

...

207

...

# of beds & occupancy rate

...

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

...

March 

...

208

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q4

...

209

...

# of beds & occupancy rate

...

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

...

Total

...

210

...

# of beds & occupancy rate

...

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

...

April 

...

211

...

# of beds & occupancy rate

...

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

...

May

...

212

...

# of beds & occupancy rate

...

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

...

June

...

213

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q1

...

214

...

# of beds & occupancy rate

...

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

...

July

...

215

...

# of beds & occupancy rate

...

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

...

August

...

216

...

# of beds & occupancy rate

...

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

...

September

...

217

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q2

...

218

...

# of beds & occupancy rate

...

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

...

October

...

219

...

# of beds & occupancy rate

...

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

...

November

...

220

...

# of beds & occupancy rate

...

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

...

December

...

221

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q3

...

222

...

# of beds & occupancy rate

...

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

...

January

...

223

...

# of beds & occupancy rate

...

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

...

February

...

224

...

# of beds & occupancy rate

...

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

...

March 

...

225

...

# of beds & occupancy rate

...

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

...

Subtotal ~ Q4

...

226

...

# of beds & occupancy rate

...

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

...

Total

...

227

...

# of beds & occupancy rate

...

Forecast Bed Days & Resident Days for in-scope 3.36 HPRD publicly funded beds (for 3.36 HPRD reporting) / Bed Types / # of Beds

...

1. In scope 3.36 HPRD publicly funded beds

...

228

...

# of beds & occupancy rate

...

Forecast Bed Days & Resident Days for in-scope 3.36 HPRD publicly funded beds (for 3.36 HPRD reporting) / Bed Types / Bed days Maximum Days

...

1. In scope 3.36 HPRD publicly funded beds

...

229

...

# of beds & occupancy rate

...

Forecast Bed Days & Resident Days for in-scope 3.36 HPRD publicly funded beds (for 3.36 HPRD reporting) / Bed Types / Resident Days

...

1. In scope 3.36 HPRD publicly funded beds

...

230

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / # of beds

...

In-scope 3.36 HPRD publicly funded beds - at April

...

231

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / # of beds

...

In-scope 3.36 HPRD publicly funded beds - adjustment

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / # of beds

...

Total

...

232

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / Start

...

In-scope 3.36 HPRD publicly funded beds - at April

...

233

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / Start

...

In-scope 3.36 HPRD publicly funded beds - adjustment

...

234

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / End

...

In-scope 3.36 HPRD publicly funded beds - at April

...

235

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / End

...

In-scope 3.36 HPRD publicly funded beds - adjustment

...

236

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / # of days

...

In-scope 3.36 HPRD publicly funded beds - at April

...

237

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / # of days

...

In-scope 3.36 HPRD publicly funded beds - adjustment

...

238

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / Max. Days

...

In-scope 3.36 HPRD publicly funded beds - at April

...

239

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / Max. Days

...

In-scope 3.36 HPRD publicly funded beds - adjustment

...

240

...

# of beds & occupancy rate

...

Forecast ~ bed days maximum days / Max. Days

...

Total

...

241

...

# of beds & occupancy rate

...

Forecast ~ resident days / Forecast

...

YTD resident days = 

...

242

...

# of beds & occupancy rate

...

Forecast ~ resident days / Forecast

...

# of days for last qtr ending =

...

243

...

# of beds & occupancy rate

...

Forecast ~ resident days / Forecast

...

# of days for the fiscal year =

...

244

...

# of beds & occupancy rate

...

Forecast ~ resident days / Forecast

...

Forecast

...

245

...

246

...

247

...

248

...

249

...

250

...

251

...

252

...

253

...

254

...

255

...

256

...

257

...

258

...

259

...

260

...

261

...

262

...

263

...

264

...

265

...

266

...

267

...

268

...

269

...

270

...

271

...

272

...

273

...

274

...

275

...

276

...

277

...

278

...

279

...

280

...

281

...

282

...

283

...

284

...

285

...

286

...

287

...

288

...

289

...

290

...

291

...

292

...

293

...

294

...

295

...

296

...

297

...

298

...

299

...

300

...

301

...

302

...

303

...

304

...

305

...

306

...

307

...

308

...

309

...

310

...

311

...

312

...

313

...

314

...

315

...

316

...

317

...

318

...

319

...

320

...

321

...

322

...

323

...

324

...

325

...

326

...

327

...

328

...

329

...

330

...

331

...

332

...

333

...

334

...

335

...

336

...

337

...

338

...

339

...

340

...

341

...

342

...

343

...

344

...

345

...

346

...

347

...

348

...

349

...

350

...

351

...

352

...

353

...

354

...

355

...

356

...

357

...

358

...

359

...

360

...

361

...

362

...

363

...

364

...

365

...

366

...

367

...

368

...

369

...

370

...

371

...

372

...

373

...

374

...

375

...

376

...

377

...

378

...

379

...

380

...

381

...

382

...

383

...

384

...

385

...

386

...

387

...

388

...

389

...

390

...

391

...

392

...

393

...

394

...

395

...

396

...

397

...

398

...

399

...

400

...

401

...

402

...

403

...

404

...

405

...

406

...

407

...

408

...

409

...

410

...

411

...

412

...

413

...

414

...

415

...

416

...

417

...

418

...

419

...

420

...

421

...

422

...

423

...

424

...

425

...

426

...

427

...

428

...

429

...

430

...

431

...

432

...

433

...