Note: Where available, the PDF/Word icon below is provided to view the complete and fully formatted document
Senate orders for production of documents—Health—Alcohol and drug treatment and rehabilitation services—Order agreed to on 7 September 2017—Drug and Alcohol Service Planning Model—Estimator tool for drug and alcohol treatment clinical resources for Australian population


Download PDF Download PDF

NATIONAL DA-CCP MODEL Estimator tool for Drug and Alcohol treatment clini cal resources for Australian population Calculates staff resource demand and costs + prescr iptions for period 2011-2031, for Alcohol and other drug treatments, ages 0 to 65+ Version DA-CCP National Reporting Model 2.4.1 Mar201 3.xlsm Population database Parameters Standard prevalence rates

Created 25/03/2013

27/03/2013

Blue tabs >> Contain instructions and jurisdiction selectors to alter database

Purple tabs >> Contain standard reports and custom r eport templates

Contents User tabs

Instructions Population Selector Wage Selector Prevalence selector Report 1

Prevalence and treatment rates by age category

Report 2

Summary of drug treatment resources - FTEs and bed s

Report 3

Summary of drug treatment resource costs

Report 4

Resource demand and cost by single drug type

Report 5

Bed, staff numbers and cost by bed type, by single drug

Report 6

Staff numbers and cost by setting/type and cost for single drug, years

Report 7

Number of staff by type working in CL / standalone packages

Report 8

Diagnostic tests and Prescription medicine cost and quantity

Report 9

Output selection for all care packages, by cost (he at map)

Report 10

Occasions of service (OOS) - one care package

Report 11

OTP care packages - activities sorted by cost

Report 12

OTP care packages - clinical staff FTE resources an d costs

Report 13

D&A Bed - clinical staff activities, sorted by gran d total cost

Report 14

Resource estimates - all drugs and ages (heat map)

Report 15

Bed separations - all drugs and ages

Custom report 1

Customisable pivot table

Custom report 2

Customisable pivot table

Custom report 3

Customisable pivot table

CP codes

Care package codes and full names

Australia (other states are selectable, but datab ase only holds one jurisdiction at a time)

Estimatortool

Summary Report 2a - Treatment resources - number of FTEs and beds Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction

Year 2011

Sum of TOTAL Column Labels

Row Labels Alcohol Amphetamine Benzodiazepine Cannabis Opioids All-child Grand Total

0-11mnths Summary Treatment popn + SBI + Standalone popn - - - - - 100 100

Resources for selected population Clinical Staff FTE - - - - - 0.15 0.15

1-11 Summary Treatment popn + SBI + Standalone popn - - - - - 9,769 9,769

Resources for selected population Clinical Staff FTE - - - - - 16.60 16.60

12-17 Summary Treatment popn + SBI + Standalone popn 39,010 2,193 320 20,593 675 - 62,791

Resources for selected population Clinical Staff FTE 119.9 64.6 1.8 79.9 74.1 - 340.3

Beds 31.2 23.1 - 24.9 32.8 - 112.0

18-64 Summary Treatment popn + SBI + Standalone popn 1,962,931 95,763 27,750 1,083,009 101,999 - 3,271,453

Resources for selected population Clinical Staff FTE 5,952.0 1,159.3 534.2 1,547.2 3,082.9 - 12,275.7

Beds 3,741.4 749.7 37.1 911.4 1,074.7 - 6,514.3

65+ Summary Treatment popn + SBI + Standalone popn 112,369 4,717 2,024 48,896 3,849 - 171,853

Resources for selected population Clinical Staff FTE 277.7 4.3 24.3 15.6 126.2 - 448.1

Beds 85.7 0.4 - 1.5 9.4 - 97.0

Summary of all ages Year 2011

Age (All)

Sum of TOTAL Column Labels

Row Labels Alcohol Amphetamine Benzodiazepine Cannabis Opioids All-child Grand Total

Summary Treatment population 339,680 27,214 25,048 91,698 86,684 - 570,322

Treatment popn + SBI + Standalone popn 2,114,310 102,672 30,094 1,152,498 106,523 9,870 3,515,967

Resources for selected population Clinical Staff FTE 6,350 1,228 560 1,643 3,283 17 13,081

Beds 3,858 773 37 938 1,117 - 6,723

Notes 1. Small numbers may display as '0.00'. Absolute zero will display as dash '-' 2. 'Selected population' refers to the total number of people in each age group in Australia 3. 'Treatment population' refers to the total number of persons diagnosed and requiring treatment, including Severe, Moderate, Mild only 4. SBI refers to Screening and Brief Intervention population. Standalone popn refers to a variety of services that are distributed across care packages 5. Total Clinical Staff FTE numbers includes all services for Mild, Moderate, Severe, Screening, Brief Intervention and Stand Alone items. 6. Projections apply to population only, with cost projection scaled to population projections. There is no inflation adjustment for the cost of clinical Staff FTEs, bed overheads, prescription medicines or diagnostic tests. Only years 2011-2026, 2031 are viewable 7. Diagnostic Testing and Prescription Medicine cannot be shown as 'resources' at this level as they contain incommensurate doses 8. FTE refers to Full Time Equivalent clinical staff. Resources refers to a count of FTEs and beds (annual estimated requirement)

©NSW Ministry of Health 2013.

Change Year only.

DA-CCP Model

Summary Report 4 - Resource demand and cost by single drug type Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction

Drug Alcohol

Year 2011

Values

Row Labels

Sum of TOTAL

Sum of SEVERE

Sum of At Risk - Screen, Brief Interv.

Sum of mild amb Sum of mod amb

Sum of mild-mod amb

12-17 1,761,692 136 23,856 2,452 2,029 -

Summary 1,761,528 - 23,850 2,449 2,010 -

Selected jurisdiction population 1,722,518 - - - - -

Treatment popn + SBI + Standalone popn 39,010 - 23,850 2,449 2,010 -

Resources for selected population 151 126 5 3 17 -

Clinical Staff FTE 120 95 5 3 17 -

Beds 31 31 - - - -

Cost for selected popn $mill 12.83 $ 9.98 $ 0.57 $ 0.34 $ 1.93 $ - $

Clinical Staff FTE 12.21 $ 9.36 $ 0.57 $ 0.34 $ 1.93 $ - $

Bed overheads 0.62 $ 0.62 $ - $ - $ - $ - $

18-64 16,086,977 9,370 1,515,852 120,330 99,237 -

Summary 16,076,528 - 1,515,492 120,187 98,661 -

Selected jurisdiction population 14,113,597 - - - - -

Treatment popn + SBI + Standalone popn 1,962,931 - 1,515,492 120,187 98,661 -

Resources for selected population 9,693 8,737 324 128 505 -

Clinical Staff FTE 5,952 4,995 324 128 505 -

Beds 3,741 3,741 - - - -

Cost for selected popn $mill 755.09 $ 633.75 $ 36.43 $ 14.45 $ 70.47 $ - $

Clinical Staff FTE 669.73 $ 548.39 $ 36.43 $ 14.45 $ 70.47 $ - $

Bed overheads 85.36 $ 85.36 $ - $ - $ - $ - $

65+ 3,231,795 347 77,932 5,950 4,907 -

Summary 3,231,395 - 77,913 5,943 4,879 -

Selected jurisdiction population 3,119,026 - - - - -

Treatment popn + SBI + Standalone popn 112,369 - 77,913 5,943 4,879 -

Resources for selected population 363 315 17 6 25 -

Clinical Staff FTE 278 230 17 6 25 -

Beds 86 86 - - - -

Cost for selected popn $mill 37.27 $ 31.20 $ 1.87 $ 0.71 $ 3.48 $ - $

Clinical Staff FTE 34.46 $ 28.38 $ 1.87 $ 0.71 $ 3.48 $ - $

Bed overheads 2.82 $ 2.82 $ - $ - $ - $ - $

Total clinical FTE resources - all ages 7,066.01 5,905.66 384.15 153.13 623.07 -

Element % share of total 100% 84% 5% 2% 9% 0%

Total cost - all ages $Mill 805.20 $ 674.93 $ 38.88 $ 15.50 $ 75.89 $ - $

Element % share of total 100% 83.8% 4.8% 1.9% 9.4% 0.0%

Notes 1. Diagnostic Testing and Prescription Medicine cannot be shown as 'resources' at this level as they contain incommensurate unit doses that cannot be counted meaningfully. 2. Staff FTE resources (total staff) and Bed resources (total beds) cannot be summed as they contain incommensurate data types 2. Mod amb is moderate ambulatory 3. Mild amb is mild ambulatory 4. Treatment population sum total persons does not include Harm Reduction, SBI or Stand-Alone items, e.g. CL-ED, CL-Obstets 5. SBI refers to At risk - Brief Intervention 6. Projections apply to population only and proportional costs. No inflation adjustment. Only years 2011-2026, 2031 are viewable. 7. Clinical staff annual hours can be calculated by multiplying the FTE numbers by 1171 for AMS, NAH and AOD. Or by 1374 for GPs.

©NSW Ministry of Health 2013.

Only change Drug and Year.

DA-CCP Model

Report 5 - Beds, staff numbers and cost by bed type, for single drug Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction

Drug (All)

Year 2011

Sum of TOTAL Column Labels

Resources for selected population Cost for selected popn $mill

Row Labels

Clinical Staff FTE Beds

Clinical Staff FTE

Bed

overheads

12-17 Detoxification DT 20.8 12.2 2.53 $ 0.82 $

DT-caretaker 3.2 0.36 $

Inpatient IN 0.4 0.2 0.06 $ 0.01 $

Residential Rehabilitation RR1 124.5 99.6 11.22 $ 1.34 $

RR2 6.3 0.54 $

RR-caretaker 7.5 0.62 $

18-64 Detoxification DT 271.2 828.9 38.34 $ 55.37 $

DT-caretaker 214.7 24.17 $

Inpatient IN 421.3 192.6 53.89 $ 12.82 $

Residential Rehabilitation RR1 2,646.8 5,308.0 241.93 $ 71.68 $

RR2 558.9 46.05 $

RR3 87.6 184.8 8.01 $ 2.50 $

RR-caretaker 469.2 38.66 $

65+ Detoxification DT 9.6 28.0 1.38 $ 1.87 $

DT-caretaker 7.2 0.82 $

Inpatient IN 15.9 7.3 2.04 $ 0.48 $

Residential Rehabilitation RR1 30.8 61.7 2.79 $ 0.83 $

RR2 4.3 0.35 $

RR-caretaker 4.9 0.41 $

Grand Total 4,905 6,723 474 148

Summary FTEs Beds FTE $millBed Ohead $mill

Detoxification 527 869.15 67.60 $ 58.05 $

Residential Rehabilitation 3,941 5,654.05 350.57 $ 76.36 $

Inpatient 438 200.09 55.98 $ 13.32 $

Notes 1. FTE equals Full Time Equivalent. Resources refers to a count of FTEs (annual requirement) 2. Beds numbers are sum of number of people in bed-based packages multiplied by ALOS and annual occupancy 3. GP refers to General Practitioner, AMS refers to Medical Specialist NAH refers to Nurses and Allied Health workers, AOD refers to Alcohol and Other Drug workers 4. Small numbers may display as '0.00'. Zero will display as dash '-' for resources. 5. Clinical staff total annual hours can be calculated by multiplying the FTE numbers by 1,171 (1,374 for GPs).

©NSW Ministry of Health 2013.

Only change Drug and Year.

DA-CCP Model

Report 5b - Bed numbers estimate by bed type

Year 2011

Sum of TOTAL Column Labels

Resources for selected population Grand Total

Beds

Row Labels Alcohol Amphetamine Benzodiazepine Cannabis Opioids

12-17 Detoxification DT 3.77 2.28 2.47 3.71 12.22

Inpatient IN 0.20 0.20

Residential Rehabilitation RR1 27.39 20.87 22.22 29.11 99.58

18-64 Detoxification DT 539.37 70.61 92.42 126.55 828.94

Inpatient IN 114.83 8.39 37.10 9.97 22.32 192.61

Residential Rehabilitation RR1 3,087.16 670.73 809.01 741.12 5,308.02

RR3 184.75 184.75

65+ Detoxification DT 23.93 0.36 0.39 3.31 27.99

Inpatient IN 7.28 7.28

Residential Rehabilitation RR1 54.48 0.01 1.15 6.06 61.70

Grand Total 3,858.20 773.25 37.10 937.81 1,116.93 6,723.30

Summary Detoxification 567.06 73.25 - 95.27 133.57 869.15

Residential Rehabilitation 3,169.03 691.61 - 832.37 961.04 5,654.05

Inpatient 122.11 8.39 37.10 10.17 22.32 200.09

Summary of bed total estimated requirements by years and bed type

Drug (All)

Age (All)

Sum of TOTAL Column Labels

Resources for selected population Grand Total Beds

Row Labels Detoxification Inpatient

Residential Rehabilitation

2011 869 200 5,654 6,723

2012 879 202 5,716 6,797

2013 890 205 5,782 6,877

2014 901 208 5,848 6,956

2015 911 210 5,911 7,032

2016 921 212 5,973 7,107

2021 970 224 6,271 7,465

2031 1,063 245 6,840 8,149

©NSW Ministry of Health 2013.

Only change Drug and year.

DA-CCP Model

Report 6a - Staff numbers by setting/type and cost, selected years Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction

Drug (All)

Age (All)

Sum of TOTAL Column Labels

Row Labels 2011 2016 2021 2026 2031

Clinical Staff FTE Resources for selected population 13,081.0 13,852.7 14,582.1 15,276.3 15,986.5 Ambulatory NAH 5,596 5,937 6,257 6,563 6,877

AOD 1,632 1,727 1,818 1,904 1,992

AMS 508 541 572 602 632

GP 439 467 492 516 541

Detoxification NAH 484 512 540 565 592

AMS 43 45 48 50 52

Inpatient NAH 403 428 450 472 494

AMS 35 37 39 40 42

Residential Rehabilitation NAH 19 19 20 21 22

AOD 3,791 4,002 4,202 4,390 4,583

AMS 0 0 0 0 0

GP 131 139 146 152 159

Cost for selected popn $mill 1,515.69 $ 1,606.23 $ 1,691.65 $ 1,773.06 $ 1,856.30 $ Ambulatory NAH 630.13 $ 668.43 $ 704.47 $ 738.98 $ 774.29 $

AOD 134.44 $ 142.29 $ 149.78 $ 156.90 $ 164.15 $

AMS 156.12 $ 166.19 $ 175.66 $ 184.78 $ 194.04 $

GP 120.85 $ 128.33 $ 135.26 $ 141.88 $ 148.66 $

Detoxification NAH 54.51 $ 57.68 $ 60.75 $ 63.67 $ 66.63 $

AMS 13.09 $ 13.87 $ 14.61 $ 15.32 $ 16.04 $

Inpatient NAH 45.39 $ 48.16 $ 50.72 $ 53.15 $ 55.66 $

AMS 10.60 $ 11.24 $ 11.84 $ 12.41 $ 12.99 $

Residential Rehabilitation NAH 2.09 $ 2.13 $ 2.25 $ 2.38 $ 2.48 $

AOD 312.37 $ 329.77 $ 346.25 $ 361.76 $ 377.68 $

AMS 0.03 $ 0.03 $ 0.03 $ 0.03 $ 0.03 $

GP 36.09 $ 38.12 $ 40.02 $ 41.80 $ 43.64 $

Notes 1. FTE equals Full Time Equivalent. Resources refers to a count of FTEs (annual requirement) 2. GP refers to General Practitioner AMS refers to Medical Specialist NAH refers to Nurses and Allied Health workers AOD refers to Alcohol and Other Drug workers 3. Time series cost projections are based on population growth. Inflation is not factored. 4. Clinical staff annual hours can be calculated by multiplying the FTE numbers by 1171 (1374 for GPs). 5. Excludes staff for Harm Reduction. Includes staff for standalone items.

©NSW Ministry of Health 2013.

DA-CCP Model

Only change Drug (single drug only) and Age.

Report 6b - Staff numbers by type, per 100k and per popn selection Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction

Drug (All)

Age (All)

Sum of TOTAL Column Labels

Row Labels 2011 2016 2021 2026 2031

Resources per 100k population 122.50 122.51 122.51 122.51 122.51

Clinical Staff FTE NAH 62.24 62.24 62.24 62.24 62.25

AOD 50.23 50.23 50.23 50.23 50.23

AMS 5.31 5.31 5.31 5.31 5.31

GP 4.74 4.74 4.74 4.74 4.74

Resources for selected population 13,081 13,853 14,582 15,276 15,986

Clinical Staff FTE NAH 6,502 6,896 7,267 7,622 7,985

AOD 5,422 5,729 6,020 6,294 6,576

AMS 586 623 658 692 727

GP 571 605 637 668 699

Notes 1. FTE equals Full Time Equivalent. Resources refers to a count of FTEs (annual requirement) 2. GP refers to General Practitioner AMS refers to Medical Specialist NAH refers to Nurses and Allied Health workers AOD refers to Alcohol and Other Drug workers 3. Time series cost projections are based on population growth. Inflation is not factored. 4. Clinical staff annual hours can be calculated by multiplying the FTE numbers by 1171 (1374 for GPs). 5. Resource estimate excludes staff for Harm Reduction; includes staff for Screening, brief intervention and standalone items.

©NSW Ministry of Health 2013.

Only change Drug and Age.

DA-CCP Model

Report 8 - Count and costs for diagnostic tests and prescription medicine Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction

Drug Alcohol

Age 18-64

Year 2011

Values

Row Labels Sum of TOTAL Sum of SEVERE

Sum of mild amb Sum of mod amb

Sum of mild-mod amb

Resources for selected population 88,729,380 51,188,832 - 37,540,548 -

Diagnostic Testing resource 223,763 223,763 - - -

Test Urinary Drug Screen 61,861 61,861 - - -

Urea, Electrolytes, Creatine 53,968 53,968 - - -

Full Blood Examination 53,968 53,968 - - -

Liver Function Tests 53,968 53,968 - - -

Prescription Medicine resource 88,505,617 50,965,068 - 37,540,548 -

Dose Thiamine for relapse prevention 37,703,833 19,698,182 - 18,005,651 -

Naltrexone 22,312,405 11,657,006 - 10,655,399 -

Acamprosate calcium 11,156,203 5,828,503 - 5,327,699 -

Disulfiram 7,437,468 3,885,669 - 3,551,800 -

Thiamine for withdrawal meds 4,745,599 4,745,599 - - -

Tobacco Interventions: 21mg patch 3,551,800 3,551,800 - - -

Tobacco Interventions: Buproprion 907,682 907,682 - - -

Diazepam - 5mg counted as per dose 641,297 641,297 - - -

Tobacco Interventions: Varencline 49,331 49,331 - - -

Cost for selected popn $mill 157.07 $ 89.81 $ - $ 67.27 $ - $

Diagnostic Testing 4.34 $ 4.34 $ - $ - $ - $

Test Urinary Drug Screen 1.50 $ 1.50 $ - $ - $ - $

Urea, Electrolytes, Creatine 0.96 $ 0.96 $ - $ - $ - $

Liver Function Tests 0.96 $ 0.96 $ - $ - $ - $

Full Blood Examination 0.92 $ 0.92 $ - $ - $ - $

Prescription Medicine 152.73 $ 85.46 $ - $ 67.27 $ - $

Dose Naltrexone 100.85 $ 52.69 $ - $ 48.16 $ - $

Acamprosate calcium 20.75 $ 10.84 $ - $ 9.91 $ - $

Disulfiram 14.73 $ 7.69 $ - $ 7.03 $ - $

Tobacco Interventions: 21mg patch 8.74 $ 8.74 $ - $ - $ - $

Thiamine for relapse prevention 5 2 - 2 -

Tobacco Interventions: Buproprion 2 2 - - -

Thiamine for withdrawal meds 0.76 $ 0.76 $ - $ - $ - $

Diazepam - 5mg counted as per dose 0.51 $ 0.51 $ - $ - $ - $

Tobacco Interventions: Varencline 0 0 - - -

Notes 1. "Resources" refers to total number of doses or tablets for all persons per year 2. Prescription medicine sum of resources is not shown as it contains incommensurate medicine types and doses 3. Diagnostic Testing is shown with slightly different labelling for quantities and for costs 4. Prescription Medicine is shown with slightly different labelling for quantities (resources) and for costs 5. Small numbers may display as '0.00'. Zero will display as dash '-'

©NSW Ministry of Health 2013.

DA-CCP Model

Only change Drug, (single drug only), Age, and Year (single year only).

Report 9 - Output selection for all care packages, by cost Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction

Drug Alcohol

Age 18-64

Year 2011

Estimate Type Prescription Medicine

Level 1 Cost for selected popn $mill

Share of total cost >>> 0.50% 0.33% 13.59% 66.03% 2.96% 9.64% 5.72% 0.07% 1.16%

Column Labels

Values

Thiamine for withdrawal meds

Diazepam - 5mg counted as per dose Acamprosate

calcium Naltrexone

Thiamine for relapse prevention Disulfiram

Tobacco

Interventions : 21mg patch

Tobacco Interventions : Varencline

Tobacco Interventions : Buproprion

Sum of TOTAL 0.76 0.51 20.75 100.85 4.52 14.73 8.74 0.10 1.77

Sum of SEVERE 0.76 0.51 10.84 52.69 2.36 7.69 8.74 0.10 1.77

Sum of At Risk - Screen, Brief Interv. - - - - - - - - -

Sum of mild amb - - - - - - - - -

Sum of mod amb - - 10 48 2 7 - - -

Sum of mild-mod amb - - - - - - - - -

Sum of sev_12m amb psi stnd - - - - - - 1.05 0.01 0.21

Sum of sev_12m amb psi w_med_stnd - - 2 12 1 2 1 0 0

Sum of sev_12m amb psi cmplx - - - - - - 0.48 0.01 0.10

Sum of sev_12m amb psi w_med_cmplx - - 1 5 0 1 0 0 0

Sum of sev_12m amb otp stnd - - - - - - - - -

Sum of sev_12m amb otp cmplx - - - - - - - - -

Sum of sev_12m amb rehab nrr_dp 0.01 0.01 - - - - 0.09 0.00 0.02

Sum of sev_12m amb wdm hb_stnd 0.06 0.04 - - - - 0.42 0.00 0.08

Sum of sev_12m amb wdm op_stnd 0.16 0.11 - - - - 1.22 0.01 0.25

Sum of sev_12m amb wdm op_w_med_stnd 0 0 1 5 0 1 0 0 0

Sum of sev_12m amb wdm op_w_med_cmplx 0 0 2 10 0 1 1 0 0

Sum of sev_12m amb wdm c_out - - - - - - - - -

Sum of sev_12m amb wdm c_out_pc - - - - - - - - -

Sum of sev_12m amb wdm op_cmplx - - - - - - - - -

Sum of sev_12m bb_res wdm w_med_stnd 0 0 2 11 1 2 1 0 0

Sum of sev_12m bb_res wdm w_med_cmplx 0 0 1 5 0 1 0 0 0

Sum of sev_12m bb_res wdm stnd - - - - - - - - -

Sum of sev_12m bb_res wdm cmplx - - - - - - - - -

Sum of sev_12m bb_res rehab rr_8 0.03 0.02 - - - - 0.22 0.00 0.04

Sum of sev_12m bb_res rehab rr_13 0.04 0.02 - - - - 0.26 0.00 0.05

Sum of sev_12m bb_res rehab rr_26 0.03 0.02 - - - - 0.22 0.00 0.04

Sum of sev_12m bb_res rehab rr_18 - - - - - - - - -

Sum of sev_12m bb_res rehab rr_26_mtar - - - - - - - - -

Sum of sev_12m bb_res rehab rr_26_rtod - - - - - - - - -

Sum of sev_12m bb_res rehab rr_mtar - - - - - - - - -

Sum of sev_12m bb_spcl_Paed NAS - - - - - - - - -

Sum of sev_12m bb_spcl_d&a wdm da_bed 0.07 0.04 1.11 5.39 0.24 0.79 0.49 0.01 0.10

Sum of sev_12m bb_spcl_d&a wdm c_inpt - - - - - - - - -

Sum of sev_12m bb_spcl_d&a wdm c_inpt_pc - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl ccei_1to11mnths - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl ccei_1to11yrs - - - - - - - - -

Sum of sev_sal amb info_ed - - - - - - - - -

Sum of sev_sal amb cl_ed stnd - - - - - - - - -

Sum of sev_sal amb cl_ed cmplx - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl gen_co_morbid - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl gen_int - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl gen_ls - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl gen_withdr - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl mh_co_morbid - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl mh_int - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl mh_ls - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl mh_withdr - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl obs - - - - - - - - -

Sum of sev_sal bb_non_spcl_d&a cl racf - - - - - - - - -

Notes 1. Small numbers may display as '0.00'. Zero will display as dash '-' 2. Care package codes and descriptions are found at tab 'CP codes'

©NSW Ministry of Health 2013.

DA-CCP Model

Only change Drug (single drug only), Age and Year (single year only).

Avoid change to Estimate type and Level 1

Report 10 - Occasions Of Service (OOS) - one care package (2012) Data on service for a single person for one year - derived from 'Data' worksheet, not 'Database' with multiple years Prevalence rates and population data are not relevant to this table

Drug Opioids

Age 18-64

OOS

Sum of sev_12m amb otp stnd

Estimate Type Activity Name

Activity Staff Activity Duration Total

Time in mins or tests/doses

Diagnostic Testing Urinary Drug Screen #N/A 1 7 7

Urea, Electrolytes, Creatine #N/A 1 2 2

Full Blood Examination #N/A 1 2 2

Liver Function Tests #N/A 1 2 2

Prescription Medicine Methadone for OST program (dose age 18+) #N/A 1 183 183

Buprenorphine-naloxone for OST program - 8mg (age 18+) #N/A 1 146 146

Buprenorphine for OST program - 8mg (age 18+) #N/A 1 37 37

Tobacco Interventions: 21mg patch #N/A 1 36 36

Tobacco Interventions: Buproprion #N/A 1 9 9

Dosing methadone or buprenorphine or buprenorphine naloxone #N/A 1 1 1

Tobacco Interventions: Varencline #N/A 1 1 1

Clinical Staff FTE Case management (Maintenance) NAH 30 12 360

Medical reviews by doctor -GP for OST program GP 30 11 341

UDS / UDS per year NAH 20 7 140

1:1 psychosocial intervention/family/supporter NAH 60 6 360

Liaison with prescriber NAH 10 6 60

Medical reviews by doctor -AMS for OST program AMS 30 5 139

Case conference AOD 40 -

NAH 15 1 15

30 3 90

Case management (week 2 to 4) / Case Management NAH 30 3 90

Staff time to review Varencline or Buproprion or NRT patches for OST program AMS 1 1 1

GP 2 1 2

Transfer of care/ discharge / care coordination AOD 30 -

NAH 30 2 60

Referral (pharmacy, clinical psychology, counselling) NAH 15 2 30

Induction dosing reviews by pharmacist NAH 5 2 10

Staff time to deliver the tobacco intervention/person AOD 24 1 24

Intake NAH 15 1 15

Diagnostic testing (incl routine bloods, FBC, U & E, LFT) NAH 30 1 30

Assessment by doctor -GP for OST program GP 43 1 43

Assessment AOD 60 -

NAH 30 -

40 -

50 -

60 1 60

75 -

Bloods per year NAH 30 1 30

Assessment by case manager NAH 60 1 60

Assertive follow up - phone call AOD 10 1 10

Assessment by doctor -AMS for OST program AMS 17 1 17

Pharmacy initiation by pharmacist NAH 30 1 30

Referral NAH 30 1 30

Notes 1. Occasions of service refers to single person activities per care package. There is no population for this table 2. Data is implicitly 2012, as this is the main year of activity analysis. 3. Activity duration refers to minutes for clinical staff and to unit tests/doses for diagnostics and prescription medicines 4. A maximum of 1 page is displayed

©NSW Ministry of Health 2013.

DA-CCP Model

Choose single drug and single age

*See instructions for changing CP selection

Report 11 - Care packages - activities sorted by cost Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction

Note: sort order for this Pivot is based on 'otp standard'. For other options, Right click in cell B14/Sort/More sort options

Drug Opioids

Age 18-64

Year 2011

342.04 $ 164.93 $ Level 1 Values Cost for selected popn $mill

Activity Name Estimate Type Activity Staff

Sum of sev_12m amb otp stnd

Sum of sev_12m amb otp cmplx

Dosing methadone or buprenorphine or buprenorphine naloxone Prescription Medicine N/A 74.20 $ 31.80 $ Buprenorphine-naloxone for OST program - 8mg (age 18+) Prescription Medicine N/A 56.31 $ 24.13 $ Medical reviews by doctor -GP for OST program Clinical Staff FTE GP 46.35 $ 19.86 $

Medical reviews by doctor -AMS for OST program Clinical Staff FTE AMS 24.80 $ 10.63 $

Case management (Maintenance) Clinical Staff FTE NAH 23.52 $ 10.08 $

1:1 psychosocial intervention/family/supporter Clinical Staff FTE NAH 23.52 $ 20.16 $

Buprenorphine for OST program - 8mg (age 18+) Prescription Medicine N/A 12.97 $ 5.56 $ UDS / UDS per year Clinical Staff FTE NAH 9.15 $ 3.92 $

Urinary Drug Screen Diagnostic Testing N/A 6.92 $ 2.97 $

Case conference Clinical Staff FTE NAH 6.86 $ 3.36 $

AOD - $ - $

Case management (week 2 to 4) / Case Management Clinical Staff FTE NAH 5.88 $ 2.52 $

Assessment by doctor -GP for OST program Clinical Staff FTE GP 5.85 $ 2.51 $

Methadone for OST program (dose age 18+) Prescription Medicine N/A 4.92 $ 2.11 $

Assessment by case manager Clinical Staff FTE NAH 3.92 $ 1.68 $

Transfer of care/ discharge / care coordination Clinical Staff FTE NAH 3.92 $ 3.36 $

AOD - $ - $

Assessment Clinical Staff FTE NAH 3.92 $ 3.36 $

AOD - $ - $

Liaison with prescriber Clinical Staff FTE NAH 3.92 $ 3.36 $

Tobacco Interventions: 21mg patch Prescription Medicine N/A 3.61 $ 1.55 $

Assessment by doctor -AMS for OST program Clinical Staff FTE AMS 3.03 $ 1.30 $

Referral Clinical Staff FTE NAH 1.96 $ 0.84 $

Pharmacy initiation by pharmacist Clinical Staff FTE NAH 1.96 $ 0.84 $

Diagnostic testing (incl routine bloods, FBC, U & E, LFT) Clinical Staff FTE NAH 1.96 $ 0.84 $

Bloods per year Clinical Staff FTE NAH 1.96 $ 0.84 $

Referral (pharmacy, clinical psychology, counselling) Clinical Staff FTE NAH 1.96 $ 0.84 $

Urea, Electrolytes, Creatine Diagnostic Testing N/A 1.45 $ 0.62 $

Liver Function Tests Diagnostic Testing N/A 1.45 $ 0.62 $

Full Blood Examination Diagnostic Testing N/A 1.39 $ 0.60 $

Staff time to deliver the tobacco intervention/person Clinical Staff FTE AOD 1.15 $ 0.49 $

Intake Clinical Staff FTE NAH 0.98 $ 0.84 $

Tobacco Interventions: Buproprion Prescription Medicine N/A 0.73 $ 0.31 $

Induction dosing reviews by pharmacist Clinical Staff FTE NAH 0.65 $ 0.28 $

Assertive follow up - phone call Clinical Staff FTE AOD 0.48 $ 0.20 $

Staff time to review Varencline or Buproprion or NRT patches for OST program Clinical Staff FTE AMS 0.12 $ 0.05 $ GP 0.23 $ 0.10 $

Tobacco Interventions: Varencline Prescription Medicine N/A 0.04 $ 0.02 $

Pre employment training (assume 1 staff: 1 participant) Clinical Staff FTE AOD - $ - $

Admission time which includes orientation, check / search. Clinical Staff FTE AOD - $ - $

Referral / transfer of care / follow up Clinical Staff FTE NAH - $ - $

AOD - $ - $

Clinical care by nursing / allied health staff Clinical Staff FTE NAH - $ - $

Buprenorphine for withdrawal management - 8mg Prescription Medicine N/A - $ - $

(blank) Bed overheads Bed - $ - $

Dosing - cessation or transfer -discharge tasks (40 min) Clinical Staff FTE AOD - $ - $

Complex case conference Clinical Staff FTE NAH - $ - $

Dosing - cessation or transfer - exiting / completion Clinical Staff FTE AOD - $ - $

Overnight and weekend component Clinical Staff FTE NAH - $ - $

AOD - $ - $

Nurse / consultation liaison Clinical Staff FTE NAH - $ - $

Notes 1. Six Care Package columns can be added in total 2. GP refers to General Practitioner, AMS refers to Medical Specialist NAH refers to Nurses and Allied Health workers, AOD refers to Alcohol and Other Drug workers

©NSW Ministry of Health 2013.

DA-CCP Model

Only change Drug (single drug only), Age (single year only).

*See instruction for changing Care Package

Report 12a - OTP care packages - clinical staff FTE resources and costs Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction

Drug Opioids

Year 2011

Column Labels

Row Labels

Sum of sev_12m amb otp stnd

Sum of sev_12m amb otp cmplx

Sum of sev_12m amb otp stnd

Sum of sev_12m amb otp cmplx

Sum of sev_12m amb otp stnd

Sum of sev_12m amb otp cmplx

Resources for selected population Clinical Staff FTE - 6.0 1,154.4 657.6 - 111.7

Ambulatory - 6.0 1,154.4 657.6 - 111.7

NAH - 4.4 853.0 528.4 - 91.8

AOD - 0.4 19.7 8.5 - 1.3

AMS - 0.4 91.0 39.0 - 6.0

GP - 0.8 190.6 81.7 - 12.6

Cost for selected popn $mill Clinical Staff FTE - $ 0.88 $ 178.04 $ 94.64 $ - $ 15.77 $

Ambulatory - $ 0.88 $ 178.04 $ 94.64 $ - $ 15.77 $

NAH - $ 0.50 $ 96.04 $ 59.50 $ - $ 10.33 $

AOD - $ 0.03 $ 1.63 $ 0.70 $ - $ 0.11 $

AMS - $ 0.12 $ 27.95 $ 11.98 $ - $ 1.85 $

GP - $ 0.23 $ 52.42 $ 22.47 $ - $ 3.48 $

Resources per 100k population Clinical Staff FTE - 0.4 8.2 4.7 - 3.6

Ambulatory - 0.4 8.2 4.7 - 3.6

NAH - 0.3 6.0 3.7 - 2.9

AOD - 0.0 0.1 0.1 - 0.0

AMS - 0.0 0.6 0.3 - 0.2

GP - 0.0 1.4 0.6 - 0.4

Costs per 100k population $mill Clinical Staff FTE - $ 0.05 $ 1.26 $ 0.67 $ - $ 0.51 $

Ambulatory - $ 0.05 $ 1.26 $ 0.67 $ - $ 0.51 $

NAH - $ 0.03 $ 0.68 $ 0.42 $ - $ 0.33 $

AOD - $ 0.00 $ 0.01 $ 0.00 $ - $ 0.00 $

AMS - $ 0.01 $ 0.20 $ 0.08 $ - $ 0.06 $

GP - $ 0.01 $ 0.37 $ 0.16 $ - $ 0.11 $

Notes 1. Small numbers may display as '0.00'. Zero will display as dash '-' 2. GP refers to General Practitioner, AMS refers to Medical Specialist NAH refers to Nurses and Allied Health workers, AOD refers to Alcohol and Other Drug workers

©NSW Ministry of Health 2013.

12-17 18-64 65+

DA-CCP Model

Change Dru g (single drug only) and Year (single year only)

Report 12b - Opioid treatment programs - resources and costs

Drug Opioids

Age (All)

Year 2011

Column Labels Staff

Row Labels (blank) Bed NAH AOD AMS GP total

Summary Treatment population Sum of sev_12m amb otp stnd 40,768 Sum of sev_12m amb otp cmplx 20,271

Sum of sev_12m bb_res rehab rr_26_mtar 166 Sum of sev_12m bb_res rehab rr_26_rtod 166 Resources for selected population Clinical Staff FTE

Sum of sev_12m amb otp stnd 853 20 91 191 1,154

Sum of sev_12m amb otp cmplx 625 10 45 95 775

Sum of sev_12m bb_res rehab rr_26_mtar 3 57 0 2 62

Sum of sev_12m bb_res rehab rr_26_rtod 5 58 0 2 65

Beds -

Sum of sev_12m amb otp stnd - -

Sum of sev_12m amb otp cmplx -

Sum of sev_12m bb_res rehab rr_26_mtar 71 Sum of sev_12m bb_res rehab rr_26_rtod 121 Cost for selected popn $mill Clinical Staff FTE

Sum of sev_12m amb otp stnd 96.04 $ 1.63 $ 27.95 $ 52.42 $ 178.04 $

Sum of sev_12m amb otp cmplx 70.33 $ 0.84 $ 13.95 $ 26.17 $ 111.29 $

Sum of sev_12m bb_res rehab rr_26_mtar 0.39 $ 4.70 $ 0.07 $ 0.46 $ 5.62 $

Sum of sev_12m bb_res rehab rr_26_rtod 0.52 $ 4.79 $ 0.07 $ 0.46 $ 5.84 $

Bed overheads Sum of sev_12m amb otp stnd - $

Sum of sev_12m amb otp cmplx - $

Sum of sev_12m bb_res rehab rr_26_mtar 1.15 $ Sum of sev_12m bb_res rehab rr_26_rtod 1.83 $

Summary Total treatment population 61,372 Clinical Staff resources 1,485.7 145.0 136.9 289.1 2,056.8

Bed resources (number) 192.1

Clinical Staff costs $mill 167.28 $ 11.95 $ 42.04 $ 79.51 $ 300.79 $

Bed overhead costs $mill 2.99 $

Notes 1. FTE equals Full Time Equivalent. Resources refers to a count of FTEs (annual requirement) 2. Beds are sum of number of people in bed-based packages multiplied by ALOS and annual occupancy 3. GP refers to General Practitioner AMS refers to Medical Specialist NAH refers to Nurses and Allied Health workers AOD refers to Alcohol and Other Drug workers 4. Small numbers may display as '0.00'. Zero will display as dash '-' for resources. 5. Clinical staff annual hours can be calculated by multiplying the FTE numbers by 1171 (1374 for GPs). 6. Treatment population is total persons requiring treatment including Severe, mild, moderate only

©NSW Ministry of Health 2013.

Only change Age, Year.

DA-CCP Model

Report 13 - D&A Bed - clinical staff activities sorted by grand total cost Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction

Cost for selected popn $mill Year 2011

Drug (All)

Estimate Type Clinical Staff FTE

Level 1 Cost for selected popn $mill

Sum of sev_12m bb_spcl_d&a wdm da_bed Age

Activity Name 12-17 18-64 65+ 1-11 0-11mnths Grand Total

Clinical care by nursing / allied health staff 0.05 $ 35.28 $ 35.32 $

Clinical care by medical staff 0.01 $ 8.24 $ 8.25 $

Medical Review with prescribing 6.52 $ 6.52 $

Psychosocial intervention / counselling 1:1 5.31 $ 5.31 $

Case conference 0.00 $ 2.56 $ 0.12 $ 2.68 $

Assessment or Intake 2.39 $ 2.39 $

1:1 psychosocial intervention/family/supporter 0.01 $ 1.88 $ - $ 1.90 $

Transfer / referral / co-ordination of care / follow up / discharge 1.86 $ 1.86 $

Inpatient care by nurse 1.65 $ 1.65 $

Case management / case management implementation / support 0.00 $ 1.58 $ 0.07 $ 1.65 $

Medical Assessment or Consultation 1.45 $ 0.11 $ 1.56 $

Case management / case management assessment 0.00 $ 1.05 $ 0.05 $ 1.11 $

Assessment 0.00 $ 0.70 $ - $ 0.70 $

Family / carer engagement 0.00 $ 0.53 $ 0.02 $ 0.55 $

Medical Review and prescribing - $ 0.49 $ 0.49 $

Discharge / referral / transfer of care / follow up 0.00 $ 0.46 $ 0.02 $ 0.48 $

Transfer of care/ discharge / care coordination 0.00 $ 0.45 $ - $ 0.45 $

Group counselling (assume 1 staff and 8 participants) - $ 0.40 $ - $ 0.40 $

Inpatient care by doctor 0.38 $ 0.38 $

Psychosocial intervention 1:1 - $ - $ 0.30 $ 0.30 $

Assessment / screening and orientation 0.27 $ 0.27 $

Staff time to deliver the tobacco intervention/person - $ 0.21 $ 0.01 $ 0.22 $

Screening or Assessment or Intake 0.18 $ 0.18 $

Staff time to review and prescribe Varencline or Buproprion or NRT patches 0.17 $ 0.01 $ 0.18 $

Group sessions - (Assume 1 x staff for 8 participants) 0.00 $ 0.14 $ - $ 0.14 $

Transfer / referral of care / follow up / care coordination 0.14 $ 0.14 $

Screening / brief assessment and orientation 0.00 $ 0.09 $ - $ 0.09 $

Intake 0.00 $ 0.09 $ - $ 0.09 $

Complex case conference 0.00 $ 0.09 $ - $ 0.09 $

Bloods / diagnostic testing - $ 0.09 $ 0.01 $ 0.09 $

Assertive follow up - phone call 0.00 $ 0.09 $ 0.00 $ 0.09 $

Referral / transfer of care / follow up - $ 0.07 $ - $ 0.07 $

Referral / transfer of care / care co-ordination 0.00 $ 0.03 $ 0.03 $

Group sessions - (Assume 1 x staff for 8 participants) - $ 0.02 $ 0.02 $

Staff time to prescribe Varencline or Buproprion or NRT patches 0.0 - 0.0

Tobacco intervention (brief intervention only) 0.0 0.0

Complimentary educational group (assume 2 staff & 10 participants) 0.0 0.0

Medical liaison with another provider - $ - $ - $ - $

Information and activity - - - -

Screening - -

Discharge planning - $ - $ - $

Notes 1. A maximum of 1 page is displayed ©NSW Ministry of Health 2013.

DA-CCP Model

Choose single year and drug only.

Report 14 - Resource estimates - all drugs and ages (heat map) Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction Year 2011 Estimate Type Beds

Level 1 Resources for selected population

Percentage share of total >>> 0.5% 55.6% 1.3% 0.3% 11. 2% 0.0% 0.6% 0.4% 13.6% 0.0% 0.5% 16.0% 0.1%

Column Labels

Benzodiaze

Total

Values

12-17

18-64

65+

12-17

18-64

65+

18-64

12-17

18-64

65+

12-17

18-64

65+

Sum of TOTAL 31 3,741 86 23 750 0 37 25 911 2 33 1,075 9 6,723

Sum of At Risk - Screen, Brief Interv. - - - - - - - - - - - - - -

Sum of mild amb - - - - - - - - - - - - - -

Sum of mod amb - - - - - - - - - - - - - -

Sum of mild-mod amb - - - - - - - - - - - - - -

Sum of sev_12m amb psi stnd - - - - - - - - - - - - - -

Sum of sev_12m amb psi w_med_stnd - - - - - - - - - - - - - -

Sum of sev_12m amb psi cmplx - - - - - - - - - - - - - -

Sum of sev_12m amb psi w_med_cmplx - - - - - - - - - - - - - -

Sum of sev_12m amb otp stnd - - - - - - - - - - - - - -

Sum of sev_12m amb otp cmplx - - - - - - - - - - - - - -

Sum of sev_12m amb rehab nrr_dp - - - - - - - - - - - - - -

Sum of sev_12m amb wdm hb_stnd - - - - - - - - - - - - - -

Sum of sev_12m amb wdm op_stnd - - - - - - - - - - - - - -

Sum of sev_12m amb wdm op_w_med_stnd - - - - - - - - - - - - - -

Sum of sev_12m amb wdm op_w_med_cmplx - - - - - - - - - - - - - -

Sum of sev_12m amb wdm c_out - - - - - - - - - - - - - -

Sum of sev_12m amb wdm c_out_pc - - - - - - - - - - - - - -

Sum of sev_12m amb wdm op_cmplx - - - - - - - - - - - - - -

Sum of sev_12m bb_res wdm w_med_stnd 1 254 14 - - - - - - - - - - 270

Sum of sev_12m bb_res wdm w_med_cmplx 1 111 6 1 26 0 - - - - - - - 145

Sum of sev_12m bb_res wdm stnd - - - - - - - 1 38 0 - 46 - 85

Sum of sev_12m bb_res wdm cmplx - - - - - - - - - - 2 20 3 24

Sum of sev_12m bb_res rehab rr_8 - 552 10 - - - - - - - - 186 7 755

Sum of sev_12m bb_res rehab rr_13 - 1,036 25 - 716 0 - - 863 1 - 495 - 3,137

Sum of sev_12m bb_res rehab rr_26 - 1,673 23 - - - - - - - - 113 - 1,809

Sum of sev_12m bb_res rehab rr_18 29 - - 22 - - - 24 - - 31 - - 107

Sum of sev_12m bb_res rehab rr_26_mtar - - - - - - - - - - - 71 - 71

Sum of sev_12m bb_res rehab rr_26_rtod - - - - - - - - - - - 121 - 121

Sum of sev_12m bb_res rehab rr_mtar - - - - - - - - - - - - - -

Sum of sev_12m bb_spcl_Paed NAS - - - - - - - - - - - - - -

Sum of sev_12m bb_spcl_d&a wdm da_bed - 115 7 - 8 - - 0 10 - - 22 - 163

Sum of sev_12m bb_spcl_d&a wdm c_inpt - - - - - - 5 - - - - - - 5

Sum of sev_12m bb_spcl_d&a wdm c_inpt_pc - - - - - - 32 - - - - - - 32

Notes 1. "Resources" refers to total number of beds, FTE persons, doses or tablets for all persons 2. Small numbers may display as '0.00'. Zero will display as dash '-'

3. Care package codes and descriptions are found at tab 'CP codes' 4. Standalone items are not shown in the 'Values' list of pivot table

©NSW Ministry of Health 2013.

Alcohol

Amphetamine

Cannabis

Opioids

DA-CCP Model

Only change Year.

Report 15 - Bed separations - all drugs and ages (he at map) Australia is the selected population jurisdiction; Australia is the selected wage jurisdiction Year 2011 Level 2 Separations

Level 1 Resources for selected population

Percentage share of total >>> 0.5% 56.4% 2.2% 0.3% 10. 0% 0.0% 2.1% 0.4% 12.6% 0.0% 0.5% 14.8% 0.2%

Column Labels

Benzodiaze

Total

Values

12-17

18-64

65+

12-17

18-64

65+

18-64

12-17

18-64

65+

12-17

18-64

65+

Sum of TOTAL 352 43,312 1,651 241 7,679 24 1,592 271 9,700 24 360 11,398 180 76,787

Sum of At Risk - Screen, Brief Interv. - - - - - - - - - - - - - -

Sum of mild amb - - - - - - - - - - - - - -

Sum of mod amb - - - - - - - - - - - - - -

Sum of mild-mod amb - - - - - - - - - - - - - -

Sum of sev_12m amb psi stnd - - - - - - - - - - - - - -

Sum of sev_12m amb psi w_med_stnd - - - - - - - - - - - - - -

Sum of sev_12m amb psi cmplx - - - - - - - - - - - - - -

Sum of sev_12m amb psi w_med_cmplx - - - - - - - - - - - - - -

Sum of sev_12m amb otp stnd - - - - - - - - - - - - - -

Sum of sev_12m amb otp cmplx - - - - - - - - - - - - - -

Sum of sev_12m amb rehab nrr_dp - - - - - - - - - - - - - -

Sum of sev_12m amb wdm hb_stnd - - - - - - - - - - - - - -

Sum of sev_12m amb wdm op_stnd - - - - - - - - - - - - - -

Sum of sev_12m amb wdm op_w_med_stnd - - - - - - - - - - - - - -

Sum of sev_12m amb wdm op_w_med_cmplx - - - - - - - - - - - - - -

Sum of sev_12m amb wdm c_out - - - - - - - - - - - - - -

Sum of sev_12m amb wdm c_out_pc - - - - - - - - - - - - - -

Sum of sev_12m amb wdm op_cmplx - - - - - - - - - - - - - -

Sum of sev_12m bb_res wdm w_med_stnd 40 11,543 644 - - - - - - - - - - 12,228

Sum of sev_12m bb_res wdm w_med_cmplx 40 5,032 293 34 1,159 13 - - - - - - - 6,570

Sum of sev_12m bb_res wdm stnd - - - - - - - 39 1,726 14 - 2,080 - 3,859

Sum of sev_12m bb_res wdm cmplx - - - - - - - - - - 72 915 120 1,107

Sum of sev_12m bb_res rehab rr_8 - 4,933 88 - - - - - - - - 1,664 60 6,745

Sum of sev_12m bb_res rehab rr_13 - 8,879 212 - 6,134 12 - - 7,398 10 - 4,243 - 26,889

Sum of sev_12m bb_res rehab rr_26 - 7,400 102 - - - - - - - - 499 - 8,001

Sum of sev_12m bb_res rehab rr_18 271 - - 207 - - - 220 - - 288 - - 987

Sum of sev_12m bb_res rehab rr_26_mtar - - - - - - - - - - - 499 - 499

Sum of sev_12m bb_res rehab rr_26_rtod - - - - - - - - - - - 499 - 499

Sum of sev_12m bb_res rehab rr_mtar - - - - - - - - - - - - - -

Sum of sev_12m bb_spcl_Paed NAS - - - - - - - - - - - - - -

Sum of sev_12m bb_spcl_d&a wdm da_bed - 5,525 312 - 386 - - 13 575 - - 998 - 7,810

Sum of sev_12m bb_spcl_d&a wdm c_inpt - - - - - - 212 - - - - - - 212

Sum of sev_12m bb_spcl_d&a wdm c_inpt_pc - - - - - - 1,380 - - - - - - 1,380

Notes 1. "Resources" (if selected) refers to total numbe r of beds, FTE persons, doses or tablets for all pe rsons 2. Small numbers may display as '0.00'. Zero will display as dash '-'

3. Care package codes and descriptions are found at tab 'CP codes' 4. Standalone items are not shown in the 'Values' list of pivot table

©NSW Ministry of Health 2013.

Alcohol

Amphetamine

Cannabis

Opioids

DA-CCP Model

Only change Year (single year only).