Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Instructions & Definitions

Purpose ~ this section captures the YTD approved # of beds and occupied days.

Table - YTD Number of Resident Days ~ the data is pre-populated from tables "Details for YTD Maximum Days" and "Details for YTD Occupied Days"

Table - Details for YTD Maximum Days
i. The approved # of beds is pre-populated and based on the bed inventory data collection.
ii. Enter the start and end date for when the beds are available. Formulas have been embedded to
calculate the # of days and YTD maximum the beds are available for the start to end period.

Table - Details for YTD Occupied Days
i. For the 3 bed types, enter the # of days the beds are occupied by a client by month.

Index

Bed Type

Data

Field Type

int/ float / string

Calculated Field

(specify formula/calculation)

Notes

1

1 - In- scope 3.36 HPRD publicly funded beds

Approved Number of Beds

int

Pre-populated with HCC bed inventory

2

1 - In- scope 3.36 HPRD publicly funded beds

YTD Maximum Days

int

Pre-populated with HCC bed inventory

3

1 - In- scope 3.36 HPRD publicly funded beds

YTD Occupied Days

int

Pre-populated with HCC bed inventory

4

1 - In- scope 3.36 HPRD publicly funded beds

Percentage Occupied

Percentage

5

2 - Out of scope publicly funded bed

Approved Number of Beds

int

Pre-populated with HCC bed inventory

6

2 - Out of scope publicly funded bed

YTD Maximum Days

int

Pre-populated with HCC bed inventory

7

2 - Out of scope publicly funded bed

YTD Occupied Days

int

Pre-populated with HCC bed inventory

8

2 - Out of scope publicly funded bed

Percentage Occupied

Percentage

9

3 - Private Beds

Approved Number of Beds

int

Pre-populated with HCC bed inventory

10

3 - Private Beds

YTD Maximum Days

int

Pre-populated with HCC bed inventory

11

3 - Private Beds

YTD Occupied Days

int

Pre-populated with HCC bed inventory

12

3 - Private Beds

Percentage Occupied

Percentage

13

Total number beds and YTD occupied days

Approved Number of Beds

int

Check with Bonnie if this is calculated

14

Total number beds and YTD occupied days

YTD Maximum Days

int

Check with Bonnie if this is calculated

15

Total number beds and YTD occupied days

YTD Occupied Days

int

Check with Bonnie if this is calculated

16

Total number beds and YTD occupied days

Percentage Occupied

Percentage

Index

Sheet

Table

Session

Field Name

Excel position or Column

Field Type

int/ float / string

Calculated Field

(specify formula/calculation)

Dependencies (Internal Sources)

Notes

43

bed occupancy

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

1. In- scope 3.36 HPRD publicly funded beds

C18

44

bed occupancy

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

2. Out of scope publicly funded bed

C19

45

bed occupancy

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

3. Private Beds

C20

46

bed occupancy

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

Total beds and YTD occupied days

C22

47

bed occupancy

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

  1. In- scope 3.36 HPRD publicly funded beds

D18

48

bed occupancy

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

  1. Out of scope publicly funded bed

D19

49

bed occupancy

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

  1. Private Beds

D20

50

bed occupancy

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

Total beds and YTD occupied days

D22

51

bed occupancy

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

  1. In- scope 3.36 HPRD publicly funded beds

E18

52

bed occupancy

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

  1. Out of scope publicly funded bed

E19

53

bed occupancy

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

  1. Private Beds

E20

54

bed occupancy

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

Total beds and YTD occupied days

E22

55

bed occupancy

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

  1. In- scope 3.36 HPRD publicly funded beds

F18

56

bed occupancy

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

  1. Out of scope publicly funded bed

F19

57

bed occupancy

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

  1. Private Beds

F20

58

bed occupancy

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

Total beds and YTD occupied days

F22

59

# of beds & occupancy rate

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

  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

60

# 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

61

# of beds & occupancy rate

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

Subtotal 

62

# of beds & occupancy rate

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

  1. Out-of-scope publicly funded beds - at April 1

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

63

# of beds & occupancy rate

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

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

64

# of beds & occupancy rate

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

Subtotal

65

# of beds & occupancy rate

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

  1. Private Beds - at April 1

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

66

# of beds & occupancy rate

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

  1. Private Beds - adjustments

67

# of beds & occupancy rate

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

Subtotal

68

# of beds & occupancy rate

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

Total

69

# of beds & occupancy rate

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

  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

70

# of beds & occupancy rate

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

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

71

# of beds & occupancy rate

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

  1. Out-of-scope publicly funded beds

72

# of beds & occupancy rate

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

  1. Out-of-scope publicly funded beds

73

# of beds & occupancy rate

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

  1. Private Beds

74

# of beds & occupancy rate

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

  1. Private Beds

75

# 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

76

# of beds & occupancy rate

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

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

77

# of beds & occupancy rate

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

  1. Out-of-scope publicly funded beds

78

# of beds & occupancy rate

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

  1. Out-of-scope publicly funded beds

79

# of beds & occupancy rate

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

  1. Private Beds

80

# of beds & occupancy rate

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

  1. Private Beds

81

# 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

82

# 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

83

# of beds & occupancy rate

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

  1. Out-of-scope publicly funded beds

84

# of beds & occupancy rate

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

  1. Out-of-scope publicly funded beds

85

# of beds & occupancy rate

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

  1. Private Beds

86

# of beds & occupancy rate

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

  1. Private Beds

87

# 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

88

# 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

89

# of beds & occupancy rate

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

Subtotal 

90

# of beds & occupancy rate

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

  1. Out-of-scope publicly funded beds

Field Name to be confirmed

91

# of beds & occupancy rate

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

  1. Out-of-scope publicly funded beds

Field Name to be confirmed

92

# of beds & occupancy rate

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

Subtotal

93

# of beds & occupancy rate

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

  1. Private Beds

Field Name to be confirmed

94

# of beds & occupancy rate

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

  1. Private Beds

Field Name to be confirmed

95

# of beds & occupancy rate

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

Subtotal

96

# of beds & occupancy rate

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

Total

97

# of beds & occupancy rate

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

April 

98

# of beds & occupancy rate

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

May

99

# of beds & occupancy rate

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

June

100

# of beds & occupancy rate

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

Subtotal ~ Q1

101

# of beds & occupancy rate

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

July

102

# of beds & occupancy rate

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

August

103

# of beds & occupancy rate

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

September

104

# of beds & occupancy rate

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

Subtotal ~ Q2

105

# of beds & occupancy rate

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

October

106

# of beds & occupancy rate

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

November

107

# of beds & occupancy rate

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

December

108

# of beds & occupancy rate

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

Subtotal ~ Q3

109

# of beds & occupancy rate

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

January

110

# of beds & occupancy rate

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

February

111

# of beds & occupancy rate

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

March 

112

# of beds & occupancy rate

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

Subtotal ~ Q4

113

# of beds & occupancy rate

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

Total

114

# of beds & occupancy rate

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

April 

115

# of beds & occupancy rate

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

May

116

# of beds & occupancy rate

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

June

117

# of beds & occupancy rate

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

Subtotal ~ Q1

118

# of beds & occupancy rate

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

July

119

# of beds & occupancy rate

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

August

120

# of beds & occupancy rate

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

September

121

# of beds & occupancy rate

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

Subtotal ~ Q2

122

# of beds & occupancy rate

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

October

123

# of beds & occupancy rate

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

November

124

# of beds & occupancy rate

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

December

125

# of beds & occupancy rate

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

Subtotal ~ Q3

126

# of beds & occupancy rate

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

January

127

# of beds & occupancy rate

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

February

128

# of beds & occupancy rate

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

March 

129

# of beds & occupancy rate

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

Subtotal ~ Q4

130

# of beds & occupancy rate

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

Total

131

# of beds & occupancy rate

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

April 

132

# of beds & occupancy rate

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

May

133

# of beds & occupancy rate

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

June

134

# of beds & occupancy rate

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

Subtotal ~ Q1

135

# of beds & occupancy rate

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

July

136

# of beds & occupancy rate

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

August

137

# of beds & occupancy rate

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

September

138

# of beds & occupancy rate

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

Subtotal ~ Q2

139

# of beds & occupancy rate

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

October

140

# of beds & occupancy rate

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

November

141

# of beds & occupancy rate

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

December

142

# of beds & occupancy rate

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

Subtotal ~ Q3

143

# of beds & occupancy rate

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

January

144

# of beds & occupancy rate

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

February

145

# of beds & occupancy rate

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

March 

146

# of beds & occupancy rate

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

Subtotal ~ Q4

147

# of beds & occupancy rate

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

Total

148

# of beds & occupancy rate

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

April 

149

# of beds & occupancy rate

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

May

150

# of beds & occupancy rate

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

June

151

# of beds & occupancy rate

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

Subtotal ~ Q1

152

# of beds & occupancy rate

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

July

153

# of beds & occupancy rate

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

August

154

# of beds & occupancy rate

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

September

155

# of beds & occupancy rate

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

Subtotal ~ Q2

156

# of beds & occupancy rate

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

October

157

# of beds & occupancy rate

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

November

158

# of beds & occupancy rate

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

December

159

# of beds & occupancy rate

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

Subtotal ~ Q3

160

# of beds & occupancy rate

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

January

161

# of beds & occupancy rate

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

February

162

# of beds & occupancy rate

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

March 

163

# of beds & occupancy rate

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

Subtotal ~ Q4

164

# of beds & occupancy rate

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

Total

165

# of beds & occupancy rate

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

  1. In scope 3.36 HPRD publicly funded beds

166

# of beds & occupancy rate

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

  1. In scope 3.36 HPRD publicly funded beds

167

# of beds & occupancy rate

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

  1. In scope 3.36 HPRD publicly funded beds

168

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of beds

In-scope 3.36 HPRD publicly funded beds - at April

169

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of beds

In-scope 3.36 HPRD publicly funded beds - adjustment

170

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of beds

Total

171

# of beds & occupancy rate

Forecast ~ bed days maximum days / Start

In-scope 3.36 HPRD publicly funded beds - at April

172

# of beds & occupancy rate

Forecast ~ bed days maximum days / Start

In-scope 3.36 HPRD publicly funded beds - adjustment

173

# of beds & occupancy rate

Forecast ~ bed days maximum days / End

In-scope 3.36 HPRD publicly funded beds - at April

174

# of beds & occupancy rate

Forecast ~ bed days maximum days / End

In-scope 3.36 HPRD publicly funded beds - adjustment

175

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of days

In-scope 3.36 HPRD publicly funded beds - at April

176

# of beds & occupancy rate

Forecast ~ bed days maximum days / # of days

In-scope 3.36 HPRD publicly funded beds - adjustment

177

# of beds & occupancy rate

Forecast ~ bed days maximum days / Max. Days

In-scope 3.36 HPRD publicly funded beds - at April

178

# of beds & occupancy rate

Forecast ~ bed days maximum days / Max. Days

In-scope 3.36 HPRD publicly funded beds - adjustment

179

# of beds & occupancy rate

Forecast ~ bed days maximum days / Max. Days

Total

180

# of beds & occupancy rate

Forecast ~ resident days / Forecast

YTD resident days = 

181

# of beds & occupancy rate

Forecast ~ resident days / Forecast

# of days for last qtr ending =

182

# of beds & occupancy rate

Forecast ~ resident days / Forecast

# of days for the fiscal year =

183

# of beds & occupancy rate

Forecast ~ resident days / Forecast

Forecast

  • No labels