Bed Occupancy

Instructions & Definitions

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

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

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

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

 

 


 

Year-to-Date (YTD) Number of Resident Days

 

 

Index

Bed Type

Data

Field Type

int/ float / string

Calculated Field

(specify formula/calculation)

Notes

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

 

 

 

 


 

Detail for YTD Maximum Days

 

 

Index

Bed Type

Data

Field Type

int/ float / string

Calculated Field

(specify formula/calculation)

Notes

Index

Bed Type

Data

Field Type

int/ float / string

Calculated Field

(specify formula/calculation)

Notes

1

1 - In- scope 3.36 HPRD publicly funded beds - At April 1

Approved Number of Beds

int

Pre-populated with HCC bed inventory

 

2

1 - In- scope 3.36 HPRD publicly funded beds - At April 1

Start

 

Operator input

 

3

1 - In- scope 3.36 HPRD publicly funded beds - At April 1

End

 

Operator input

 

4

1 - In- scope 3.36 HPRD publicly funded beds - At April 1

Number of Days

 

 

 

5

1 - In- scope 3.36 HPRD publicly funded beds - At April 1

YTD Maximum

 

 

 

6

1 - In- scope 3.36 HPRD publicly funded beds - Adjustments

Approved Number of Beds

 

Pre-populated with HCC bed inventory

Check with Bonnie if this field is supposed to be added “as needed”

7

1 - In- scope 3.36 HPRD publicly funded beds - Adjustments

Start

 

Operator input

Check with Bonnie if this field is supposed to be added “as needed”

8

1 - In- scope 3.36 HPRD publicly funded beds - Adjustments

End

 

Operator input

Check with Bonnie if this field is supposed to be added “as needed”

9

1 - In- scope 3.36 HPRD publicly funded beds - Adjustments

Number of Days

 

 

Check with Bonnie if this field is supposed to be added “as needed”

10

1 - In- scope 3.36 HPRD publicly funded beds - Adjustments

YTD Maximum

 

 

Check with Bonnie if this field is supposed to be added “as needed”

11

Subtotal (1 - In- scope 3.36 HPRD publicly funded beds)

Approved Number of Beds

 

 

 

12

Subtotal (1 - In- scope 3.36 HPRD publicly funded beds)

YTD Maximum

 

 

 

13

2 - Out of scope publicly funded bed - At April 1

Approved Number of Beds

 

Pre-populated with HCC bed inventory

 

14

2 - Out of scope publicly funded bed - At April 1

Start

 

Operator input

 

15

2 - Out of scope publicly funded bed - At April 1

End

 

Operator input

 

16

2 - Out of scope publicly funded bed - At April 1

Number of Days

 

 

 

17

2 - Out of scope publicly funded bed - At April 1

YTD Maximum

 

 

 

18

2 - Out of scope publicly funded bed - Adjustments

Approved Number of Beds

 

Pre-populated with HCC bed inventory

Check with Bonnie if this field is supposed to be added “as needed”

19

2 - Out of scope publicly funded bed - Adjustments

Start

 

Operator input

Check with Bonnie if this field is supposed to be added “as needed”

20

2 - Out of scope publicly funded bed - Adjustments

End

 

Operator input

Check with Bonnie if this field is supposed to be added “as needed”

21

2 - Out of scope publicly funded bed - Adjustments

Number of Days

 

 

Check with Bonnie if this field is supposed to be added “as needed”

22

2 - Out of scope publicly funded bed - Adjustments

YTD Maximum

 

 

Check with Bonnie if this field is supposed to be added “as needed”

23

Subtotal (2 - Out of scope publicly funded bed)

Approved Number of Beds

 

 

 

24

Subtotal (2 - Out of scope publicly funded bed)

YTD Maximum

 

 

 

25

3 - Private Beds - At April 1

Approved Number of Beds

 

Pre-populated with HCC bed inventory

 

26

3 - Private Beds - At April 1

Start

 

Operator input

 

27

3 - Private Beds - At April 1

End

 

Operator input

 

28

3 - Private Beds - At April 1

Number of Days

 

 

 

29

3 - Private Beds - At April 1

YTD Maximum

 

 

 

30

3 - Private Beds - Adjustments

Approved Number of Beds

 

Pre-populated with HCC bed inventory

Check with Bonnie if this field is supposed to be added “as needed”

31

3 - Private Beds - Adjustments

Start

 

Operator input

Check with Bonnie if this field is supposed to be added “as needed”

32

3 - Private Beds - Adjustments

End

 

Operator input

Check with Bonnie if this field is supposed to be added “as needed”

33

3 - Private Beds - Adjustments

Number of Days

 

 

Check with Bonnie if this field is supposed to be added “as needed”

34

3 - Private Beds - Adjustments

YTD Maximum

 

 

Check with Bonnie if this field is supposed to be added “as needed”

35

Subtotal (3 - Private Beds)

Approved Number of Beds

 

 

 

36

Subtotal (3 - Private Beds)

YTD Maximum

 

 

 

37

Total

Approved Number of Beds

 

 

 

38

Total

YTD Maximum

 

 

 

 

 


 

Detail for YTD Occupied Days

 

 

Index

Monthly Activity (Period)

Data

Field Type

int/ float / string

Calculated Field

(specify formula/calculation)

Notes

Index

Monthly Activity (Period)

Data

Field Type

int/ float / string

Calculated Field

(specify formula/calculation)

Notes

1

 

 

 

Pre-populated with HCC bed inventory

 

 

 

 

 

 

 

Index

Sheet

Table

Session

Field Name

Excel position or Column

Field Type

int/ float / string

Calculated Field

(specify formula/calculation)

Dependencies (Internal Sources)

Notes

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