Description
Hi please view the following requirements to complete this assignment on SPSS software. Thank you.The deadline is March 26, 2024.This practice set asks you to recode three variables and compute one new variable. You will need to download the SPSS files attached below (if you have not already saved them to your computer) to complete the assignment. Copy the frequencies for the variables you recode and all the logs into the Word document containing the questions. These datasets and recoded variables will be used in the SPSS practice sets in later Modules 11 and 12.I recommend that you save these SPSS datasets (.sav files) to your computer to use them later; if you don’t save the files, you will need to complete the recodes again.
Unformatted Attachment Preview
PH 307
SPSS Recode and Compute Practice Set
This practice set asks you to recode three variables and compute one new variable. The
recoded variables should all be numeric, and the values must be labeled. Copy the
frequencies for the recoded variables (Questions 1 -3) and all the logs into this document.
Question 1 – Use the Satisfaction_Trust Survey Data.sav file.
Recode “q10” (Doctor Acts in Patient’s Best Interest) into two categories: “Does not act in best
interest” (codes 1-3) through “Acts in best interest” (codes 4-5).
Question 2 – Use the Satisfaction_Trust Survey Data.sav file.
Recode “q4” (Satisfaction with Health Plan) into two categories: “Not satisfied/Somewhat
satisfied” (codes 1-3) through “Satisfied/Very satisfied” (codes 4-5).
Question 3 – Use the Practice SPSS Data.sav file.
Recode TYPE_CNTRL into two categories: Nonprofit and investor. Investor – Corp., Investor –
Indiv., and Investor – Ptnr. should be recoded into “Investor.” All other types should be
included in “Nonprofit.”
Question 4 – Use the Practice SPSS Data.sav file.
Create the variable ALOS (Average Length of Stay). You will need to use the OSHPD Hospital
Quarterly Financial and Utilization Data Files Documentation to find the formula. You only need
to paste the log for this question.
1
STATE OF CALIFORNIA
OFFICE OF STATEWIDE HEALTH PLANNING AND DEVELOPMENT
DOCUMENTATION FOR
HOSPITAL QUARTERLY FINANCIAL
AND UTILIZATION DATA FILES
ON OSHPD WEB-SITE
For Calendar Quarters Ended In
2015 and After
January 2016
Office of Statewide Health Planning and Development
Quarterly Data File Labels
Quarters Ended 2015 and After
Data Item
Item
No.
Col.
Ref.
1
2
3
4
5
6
A
B
C
D
E
F
7
8
9
10
11
12
13
14
15
16
17
G
H
I
J
K
L
M
N
O
P
Q
18
19
20
R
S
T
21
22
23
24
25
26
27
28
29
30
31
32
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
January 2016
2015 and After
Column Label
Quarterly Report Information
OSHPD Facility No.
Facility DBA Name
Report Period Year_Quarter
Report Period Begin Date
Report Period End Date
Current Operating Status
General Hospital Information
County Number
Health Service Area
Health Facility Planning Area
Type of Control
Type of Hospital
Teaching or Small/Rural Hospital
Phone Number
Street Address
City
Zip Code
Chief Executive Officer
Utilization Data
Licensed Beds
Available Beds
Staffed Beds
Hospital Discharges
Medicare – Traditional
Medicare – Managed Care
Medi-Cal – Traditional
Medi-Cal – Managed Care
County Indigent Programs – Traditional
County Indigent Programs – Managed Care
Other Third Parties – Traditional
Other Third Parties – Managed Care
Other Indigent
Other Payers (new)
Total Hospital Discharges
Long-term Care (LTC) Discharges
Line
Number
Source
FAC_NO
FAC_NAME
YEAR_QTR
BEG_DATE
END_DATE
OP_STATUS
COUNTY
HSA
HFPA
TYPE_CNTRL
TYPE_HOSP
TEACH_RURL
PHONE
ADDRESS
CITY
ZIP_CODE
CEO
LIC_BEDS
AVL_BEDS
STF_BEDS
25
30
35
DIS_MCAR
DIS_MCAR_MC
DIS_MCAL
DIS_MCAL_MC
DIS_CNTY
DIS_CNTY_MC
DIS_THRD
DIS_THRD_MC
DIS_INDGNT
DIS_OTH
DIS_TOT
DIS_LTC
50
55
60
65
70
75
80
85
90
95
100
105
Quarterly_Labels_2015 After.xls
Office of Statewide Health Planning and Development
Quarterly Data File Labels
Quarters Ended 2015 and After
Data Item
Item
No.
Col.
Ref.
33
34
35
36
37
38
39
40
41
42
43
44
AG
AH
AI
AJ
AK
AL
AM
AN
AO
AP
AQ
AR
45
46
47
48
49
50
51
52
53
54
55
AS
AT
AU
AV
AW
AX
AY
AZ
BA
BB
BC
56
57
58
59
60
61
62
63
64
65
66
BD
BE
BF
BG
BH
BI
BJ
BK
BL
BM
BN
January 2016
2015 and After
Column Label
Patient (Census) Days
Medicare – Traditional
Medicare – Managed Care
Medi-Cal – Traditional
Medi-Cal – Managed Care
County Indigent Programs – Traditional
County Indigent Programs – Managed Care
Other Third Parties – Traditional
Other Third Parties – Managed Care
Other Indigent
Other Payers (new)
Total Patient (Census) Days
Long-term Care (LTC) Patient (Census) Days
Outpatient Visits
Medicare – Traditional
Medicare – Managed Care
Medi-Cal – Traditional
Medi-Cal – Managed Care
County Indigent Programs – Traditional
County Indigent Programs – Managed Care
Other Third Parties – Traditional
Other Third Parties – Managed Care
Other Indigent
Other Payers (new)
Total Outpatient Visits
Gross Inpatient Revenue
Medicare – Traditional
Medicare – Managed Care
Medi-Cal – Traditional
Medi-Cal – Managed Care
County Indigent Programs – Traditional
County Indigent Programs – Managed Care
Other Third Parties – Traditional
Other Third Parties – Managed Care
Other Indigent
Other Payers (new)
Total Gross Inpatient Revenue
Line
Number
Source
DAY_MCAR
DAY_MCAR_MC
DAY_MCAL
DAY_MCAL_MC
DAY_CNTY
DAY_CNTY_MC
DAY_THRD
DAY_THRD_MC
DAY_INDGNT
DAY_OTH
DAY_TOT
DAY_LTC
150
155
160
165
170
175
180
185
190
195
200
205
VIS_MCAR
VIS_MCAR_MC
VIS_MCAL
VIS_MCAL_MC
VIS_CNTY
VIS_CNTY_MC
VIS_THRD
VIS_THRD_MC
VIS_INDGNT
VIS_OTH
VIS_TOT
250
255
260
265
270
275
280
285
290
295
300
GRIP_MCAR
GRIP_MCAR_MC
GRIP_MCAL
GRIP_MCAL_MC
GRIP_CNTY
GRIP_CNTY_MC
GRIP_THRD
GRIP_THRD_MC
GRIP_INDGNT
GRIP_OTH
GRIP_TOT
350
355
360
365
370
375
380
385
390
395
400
Quarterly_Labels_2015 After.xls
Office of Statewide Health Planning and Development
Quarterly Data File Labels
Quarters Ended 2015 and After
Data Item
Item
No.
Col.
Ref.
67
68
69
70
71
72
73
74
75
76
77
BO
BP
BQ
BR
BS
BT
BU
BV
BW
BX
BY
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
Gross Outpatient Revenue
Medicare – Traditional
Medicare – Managed Care
Medi-Cal – Traditional
Medi-Cal – Managed Care
County Indigent Programs – Traditional
County Indigent Programs – Managed Care
Other Third Parties – Traditional
Other Third Parties – Managed Care
Other Indigent
Other Payers (new)
Total Gross Outpatient Revenue
Deductions from Revenue
BZ Provision for Bad Debts
CA Medicare – Traditional Contractual Adjustments
CB Medicare – Managed Care Contractual Adjustments
CC Medi-Cal – Traditional Contractual Adjustments
CD Medi-Cal – Managed Care Contractual Adjustments
CE Dispro Share Payments for Medi-Cal Patient Days (SB 855)
CF County Indigent Programs – Traditional Contractual Adj
CG County Indigent Programs – Managed Care Contractual Adj
CH Other Third Parties – Traditional Contractual Adjustments
CI Other Third Parties – Managed Care Contractual Adj
CJ Charity – Hill-Burton
CK Charity – Other
CL Restricted Donations and Subsidies for Indigent Care
CM Teaching Allowance
CN Clinical Teaching Support
CO Other Adjustments and Allowances
CP Total Deductions from Revenue (new)
Capitation Premium Revenue
CQ Capitation Premium Revenue – Medicare
CR Capitation Premium Revenue – Medi-Cal
CS Capitation Premium Revenue – County Indigent Programs
CT Capitation Premium Revenue – Other Third Parties
CU Total Capitation Premium Revenue
January 2016
2015 and After
Column Label
Line
Number
Source
GROP_MCAR
GROP_MCAR_MC
GROP_MCAL
GROP_MCAL_MC
GROP_CNTY
GROP_CNTY_MC
GROP_THRD
GROP_THRD_MC
GROP_INDGNT
GROP_OTH
GROP_TOT
450
455
460
465
470
475
480
485
490
495
500
BAD_DEBT
CADJ_MCAR
CADJ_MCAR_MC
CADJ_MCAL
CADJ_MCAL_MC
DISP_855
CADJ_CNTY
CADJ_CNTY_MC
CADJ_THRD
CADJ_THRD_MC
CHAR_HB
CHAR_OTH
SUB_INDGNT
TCH_ALLOW
TCH_SUPP
DED_OTH
DED_TOT
545
550
555
560
565
566
570
575
580
585
590
595
600
605
610
615
620
CAP_MCAR
CAP_MCAL
CAP_CNTY
CAP_THRD
CAP_TOT
650
660
670
680
700
Quarterly_Labels_2015 After.xls
Office of Statewide Health Planning and Development
Quarterly Data File Labels
Quarters Ended 2015 and After
Data Item
Item
No.
Col.
Ref.
100
101
102
103
104
105
106
107
108
109
110
CV
CW
CX
CY
CZ
DA
DB
DC
DD
DE
DF
2015 and After
Column Label
122
123
124
Net Patient Revenue
Medicare – Traditional
NET_MCAR
Medicare – Managed Care
NET_MCAR_MC
Medi-Cal – Traditional
NET_MCAL
Medi-Cal – Managed Care
NET_MCAL_MC
County Indigent Programs – Traditional
NET_CNTY
County Indigent Programs – Managed Care
NET_CNTY_MC
Other Third Parties – Traditional
NET_THRD
Other Third Parties – Managed Care
NET_THRD_MC
Other Indigent
NET_INDGNT
Other Payers (new)
NET_OTH
Total Net Patient Revenue
NET_TOT
Other Revenue and Expense Data
DG Other Operating Revenue
OTH_OP_REV
DH Total Operating Expenses
TOT_OP_EXP
DI Physician Professional Component Expenses (PPC)
PHY_COMP
DJ Nonoperating Revenue Net of Nonoperating Expenses
NONOP_REV
Purchased Inpatient Services
DK Discharges
DIS_PIPS
DL Patient Days
DAY_PIPS
DM Expenses
EXP_PIPS
Purchased Outpatient Services
DN Expenses
EXP_POPS
Other Financial Data Items
DO Total Capital Expenditures
CAP_EXP
DP Fixed Assets Net of Accumulated Depreciation
FIX_ASSETS
DQ Dispro. Share Funds Transferred to Related Public Entity DISP_TRNFR
Covered California (optional)
DIS_TOT_CC
DR Total Discharges
PAT_DAY_TOT_CC
DS Total Patient Days
TOT_OUT_VIS_CC
DT Total Outpatient Visits
125
126
127
DU Total Gross Inpatient Revenue
DV Total Gross Outpatient Revenue
DW Total Contractual Adjustments
128
129
130
DX
DY
DZ
119
120
121
DO
DP
DQ
111
112
113
114
115
116
117
118
119
120
121
January 2016
Total Other Deductions
Total Capitation Premium Revenue
Total Net Patient Revenue
Quality Assurance Fee Program (QAF)
Total Capital Expenditures
Fixed Assets Net of Accumulated Depreciation
Dispro. Share Funds Transferred to Related Public Entity
Line
Number
Source
750
755
760
765
770
775
780
785
790
795
800
810
830
835
840
850
855
860
870
880
885
900
1000
1005
1010
GROS_INPAT_REV_CC
GROS_OUTPAT_REV_CC
CONTR_ADJ_CC
OTHR_DEDUCT_CC
CAP_PREM_REV_CC
NET_PAT_REV_CC
1015
1020
1025
CAP_EXP
FIX_ASSETS
DISP_TRNFR
880
885
900
1030
1035
1040
Quarterly_Labels_2015 After.xls
CALCULATIONS AND FORMULAS FOR OSHPD QUARTERLY REPORTS
QUARTERS ENDED 2015 AND AFTER
Utilization Calculations
Formulas
Average Length of Stay (ALOS)
Patient Days Total (Line No. 200) ÷ Discharges
Total (Line No. 100)
Note: To calculate ALOS by payer category, see
table below.
Average Length of Stay (excluding LTC)
[Patient Days Total (Line No. 200) – Patient Days
Long-term Care (Line No. 205)] ÷ [Discharges Total
(Line No. 100) – Discharges Long-term Care (Line
No. 105)]
Licensed Bed Occupancy Rate
Patient Days Total (Line No. 200) ÷ (Licensed Beds
(Line No. 25) x Days in Report Period)
Days in Report Period is Report Period End Date
(END_DATE) minus Report Period Begin Date
(BEG_DATE) plus one.
Available Bed Occupancy Rate
Patient Days Total (Line No. 200) ÷ (Available Beds
(Line No. 30) x Days in Report Period)
Staffed Bed Occupancy Rate
Patient Days Total (Line No. 200) ÷ (Staffed Beds
(Line No. 35) x Days in Report Period)
Occupied Beds (Average Daily Census)
Licensed Beds (Line No. 25) x “Licensed Bed
Occupancy Rate”
Adjusted Patient Days
[(Gross Inpatient Revenue Total (Line No.
400) + Gross Outpatient Revenue Total (Line No.
500)) ÷ Gross Inpatient Revenue Total (Line No.
400)] x Patient Days Total (Line No. 200)
Calculations by Payer Category
ALOS
Medicare – Traditional
Medicare – Managed Care
Medi-Cal – Traditional
Medi-Cal – Managed Care
Co. Indigent Prog. – Traditional
Co. Indigent Prog. – Managed Care
Other Third Parties – Traditional
Other Third Parties – Managed Care
Other Indigent
Other Payers
L150 ÷ L50
L155 ÷ L55
L160 ÷ L60
L165 ÷ L65
L170 ÷ L70
L175 ÷ L75
L180 ÷ L80
L185 ÷ L85
L190 ÷ L90
L195 ÷ L95
Gross I/P Rev
Per Day
L350 ÷ L150
L355 ÷ L155
L360 ÷ L160
L365 ÷ L165
L370 ÷ L170
L375 ÷ L175
L380 ÷ L180
L385 ÷ L185
L390 ÷ L190
L395 ÷ L195
Gross I/P Rev
per Discharge
L350 ÷ L50
L355 ÷ L55
L360 ÷ L60
L365 ÷ L65
L370 ÷ L70
L375 ÷ L75
L380 ÷ L80
L385 ÷ L85
L390 ÷ L90
L395 ÷ L95
Gross O/P
Rev Per Visit
L450 ÷ L250
L455 ÷ L255
L460 ÷ L260
L465 ÷ L265
L470 ÷ L270
L475 ÷ L275
L480 ÷ L280
L485 ÷ L285
L490 ÷ L290
L495 ÷ L295
January 2016
CALCULATIONS AND FORMULAS FOR OSHPD QUARTERLY REPORTS
QUARTERS ENDED 2015 AND AFTER
Financial Calculations
Formulas
Gross Inpatient Revenue Per Discharge
Gross Inpatient Revenue Total (Line No. 400) ÷
Discharges Total (Line No. 100)
Gross Inpatient Revenue Per Day
Gross Inpatient Revenue Total (Line No. 400) ÷
Patient Days Total (Line No. 200)
Gross Outpatient Revenue Per Visit
Gross Outpatient Revenue Total (Line No. 500) ÷
Outpatient Visits Total (Line No. 300)
Note: To compute these amounts by payer
category, use the formulas on the previous page.
Net Inpatient Revenue (est.)
[Gross Inpatient Revenue Total (Line No. 400) ÷
(Gross Inpatient Revenue Total (Line No. 400) +
Gross Outpatient Revenue Total (Line No. 500))] x
Net Patient Revenue Total (Line No. 800)
Net Inpatient Revenue by Payer (est.)
You can calculate Net Inpatient Revenue by payer
category by substituting payer detail (Line Nos.
350-395, 450-495, and 750-795) for “Total”.
Net Outpatient Revenue (est.)
[Gross Outpatient Revenue Total (Line No. 500) ÷
(Gross Inpatient Revenue Total (Line No. 400) +
Gross Outpatient Revenue Total (Line No. 500))] x
Net Patient Revenue Total (Line No. 800)
Net Outpatient Revenue by Payer (est.)
You can calculate Net Outpatient Revenue by
payer category by substituting payer detail (Line
Nos. 350-395, 450-495, and 750-795) for “Total”.
Note: You can divide “Net Inpatient Revenue” by
Patient Days and/or Discharges, and “Net
Outpatient Revenue” by Outpatient Visits to
calculate the average amount collected per
day/discharge/visit. You can perform this
calculation in “Total” or for each payer category.
Inpatient Operating Expenses (est.)
[Gross Inpatient Revenue Total (Line No. 400) ÷
(Gross Inpatient Revenue Total (Line No. 400) +
Gross Outpatient Revenue Total (Line No. 500))] x
Total Operating Expenses (Line No. 830)
Outpatient Operating Expenses (est.)
[Gross Outpatient Revenue Total (Line No. 500) ÷
(Gross Inpatient Revenue Total (Line No. 400) +
Gross Outpatient Revenue Total (Line No. 500))] x
Total Operating Expenses (Line No. 830)
Note: You can divide “Inpatient Operating
Expenses” by Patient Days and/or Discharges, and
“Outpatient Operating Expenses” by Outpatient
Visits to estimate the average cost per
day/discharge/visit.
January 2016
CALCULATIONS AND FORMULAS FOR OSHPD QUARTERLY REPORTS
QUARTERS ENDED 2015 AND AFTER
Financial Calculations
Formulas
Pre-tax Net Income (Loss)
Net Patient Revenue Total (Line No. 800) + Other
Operating Revenue (Line No. 810) – Total
Operating Expenses (Line No. 830) + Net
Nonoperating Revenue and Expenses (Line No.
840)
Operating Margin
(“Net from Operations” ÷ “Total Operating
Revenue”) x 100
“Net from Operations” equals Net Patient Revenue
Total (Line No. 800) + Other Operating Revenue
(Line No. 810) – Total Operating Expenses (Line
No. 830)
“Total Operating Revenue” equals Net Patient
Revenue Total (Line No. 800) + Other Operating
Revenue (Line No. 810)
Total Margin
(“Pre-tax Net Income” ÷ “Total Operating Revenue”)
x 100
“Pre-tax Net Income” and “Total Operating
Revenue” are defined above.
Cost-to-Charge Ratio
[Total Operating Expenses (Line No. 830) – Other
Operating Revenue (Line No. 810)] ÷ [Gross
Inpatient Revenue Total (Line No. 400) + Gross
Outpatient Revenue Total (Line No. 500)]
Percent of Gross Revenue Collected
[Net Patient Revenue Total (Line No. 800) ÷ (Gross
Inpatient Revenue Total (Line No. 400) + Gross
Outpatient Revenue Total (Line No. 500))] x 100
Note on Disproportionate Share Payments and Transfers
Disproportionate Share Payments for Medi-Cal Patient Days (SB 855) (Line No. 566) includes the gross
amount of SB 855 Disproportionate Share (DSH) payments received. Disproportionate Share Funds
Transferred to a Related Public Entity (Line No. 900) is an optional reporting item that is applicable
to county, district, and the University of California hospitals, and reflects DSH payments that a
hospital transfers back to a related entity. As a result, you may want to adjust certain financial data,
such as Total Deductions from Revenue (Line No. 620) and Net Patient Revenue (Line No. 800), to
account for such transfers. Because reporting a DSH Transfer (Line No. 900) is optional, a “zero” could
mean that no DSH transfers were made or that the hospital elected to leave the field blank.
January 2016
CALCULATIONS AND FORMULAS FOR OSHPD QUARTERLY REPORTS
QUARTERS ENDED 2015 AND AFTER
Uncompensated Care
When analyzing “Uncompensated Care”, you must first define it. The most common definition for
“Uncompensated Care” is the sum of Bad Debts (Line No. 545) and Charity – Other (Line No. 595).
However, this definition does not reflect OSHPD’s unique database and reporting requirements. Below
are some issues to consider:
•
You should use the data associated with the County Indigent Programs (CIP) payer category. This
payer category was established with the passage of California’s Tobacco Tax legislation, and
includes those indigent patients who are the responsibility of a county. Prior to this legislation,
these indigent patients were classified as Other payers and uncollectible amounts were reported as
Charity – Other. These write-offs now appear as CIP Contractual Adjustments.
Keep in mind that CIP Gross Patient Revenue (Line Nos. 370, 375, 470 and 475) measures the
volume of services provided, while CIP Contractual Adjustments (Line Nos. 570 and 575) reflects
the amount of uncollectible charges.
•
If you want to include non-county indigent patients in your analysis, you need to include the Other
Indigent payer category. This category relates to indigent patients who are NOT the responsibility
of a county. The data for Other Indigent was formerly reported in Other Payers.
•
Some data users may want to include Teaching Allowances (Line No. 605) in their analysis. This
amount is reported only by the University of California hospitals, and reflects write-offs for services
provided to indigent patients who benefit the hospital’s medical education programs.
•
Lastly, if you want to use Charity – Other net of any related compensation, you should subtract
Restricted Donations and Subsidies for Indigent Care (Line No. 600) from Charity – Other. As
defined, Provision for Bad Debts (Line No. 545) is reported net of Bad Debt Recoveries.
January 2016
Office of Statewide Health Planning and Development
Glossary for Quarterly Financial and Utilization Report Data File
Quarters Ended 2015 and After
Data Item
AVAILABLE BEDS
CAPITAL EXPENDITURES
CAPITATION PREMIUM REVENUE
CAPITATION PREMIUM REVENUE COUNTY INDIGENT PROGRAMS
CAPITATION PREMIUM REVENUE – MEDICAL
CAPITATION PREMIUM REVENUE MEDICARE
CAPITATION PREMIUM REVENUE – OTHER
THIRD PARTIES
CHARITY – HILL-BURTON
CHARITY – OTHER
CHIEF EXECUTIVE OFFICER
CITY
CLINICAL TEACHING SUPPORT
CONTRACTUAL ADJUSTMENTS
COUNTY INDIGENT PROGRAMS MANAGED CARE
January 2016
Definition
The average daily complement of beds (excluding nursery bassinets) physically existing and actually available
for overnight use, regardless of staffing levels. Excludes beds placed in suspense or in nursing units converted
to non-patient care uses which cannot be placed into service within 24 hours.
The dollar value of all additions to property, plant and equipment, including amounts which have the effect of
increasing the capacity, efficiency, life-span, or economy of the operation of an existing capital asset. Includes
additions to construction-in-process.
The total amount of capitated revenue received (per member per month payments) for patients enrolled in
managed care health plans. For 2000, Capitation Premium Revenue is reported separately from Deductions
from Revenue, but still included in Net Patient Revenue.
See Capitation Premium Revenue.
See Capitation Premium Revenue.
See Capitation Premium Revenue.
See Capitation Premium Revenue.
Charity care provided by hospitals to satisfy obligations related to the federal Hill-Burton Program. On some
OSHPD products, Charity – Hill-Burton is combined with Other Adjustments and Allowances.
The difference between gross patient revenue (based on full established charges) for services rendered to
patients who are unable to pay for all or part of the services provided, and the amount paid by or on behalf of
the patient. Includes charity care provided by non-county hospitals to indigent patients who are not the
responsibility of the county.
The Chief Executive Officer (CEO) of the hospital, or the person in charge of day-to-day operations of the
hospital.
The city in which the hospital is located.
Unique to the University of California Hospitals, Clinical Teaching Support funds cover the cost of treating
certain cases that provide educational benefit as well as the exploration of current medical technology and
techniques. Patients are typically unable to pay for all or part of these services. These funds are not
considered compensation for bad debts. Also known as CTS funds.
The difference between billings at full established rates and amounts received or receivable from third-party
payers under formal contract agreements. See Payer Category.
The County Indigent Programs – Managed Care category includes indigent patients covered under Welfare and
Institutions Code Section 17000 and are covered by a managed care plan funded by a county. This category
was previously reported in the Other Third Parties category.
1
Quarterly_Glossary_2015 After.xls
Office of Statewide Health Planning and Development
Glossary for Quarterly Financial and Utilization Report Data File
Quarters Ended 2015 and After
Data Item
Definition
COUNTY INDIGENT PROGRAMS TRADITIONAL
The County Indigent Programs – Traditional category includes indigent patients covered under Welfare and
Institution Code Section 17000 and was previously reported in the County Indigent Programs category. Also
included are patients paid for in whole or in part by the County Medical Services Program (CMSP), California
Health Care for Indigent Program (CHIP or tobacco tax funds), and other funding sources whether or not a bill
is rendered. This category also includes indigent patients who are provided care in county hospitals, or in
certain non county hospitals where no county-operated hospital exists, whether or not a bill is rendered.
COUNTY NUMBER
The County in which the hospital is located. There are 58 counties in California. Please note that no hospitals
are located in the County of Alpine.
The difference between gross patient revenue (charges based at full established rates) and amounts received
from patients or third-party payers for services performed. Includes contractual adjustments, charity care,
provisions for bad debts, and other adjustments and allowances which reduce gross patient revenue.
Capitation premium revenue is reported separately from deductions from revenue. Each deduction from
revenue category is defined separately in this glossary.
A discharge is the formal release of a formally admitted inpatient from the hospital, including deaths at the
hospital. Also counted is the transfer (discharge) of an inpatient from one type of care (Acute Care, Psychiatric
Care, Chemical Dependency Care, Rehabilitation Care, Long-Term Care, and Residential Care) to another type
of care within the hospital. Excludes nursery discharges; service discharges, which are transfers within a type
of care; and purchased inpatient discharges. See Payer Category.
The amount of Medi-Cal disproportionate share payments provided by SB 855 and/or SB 1255, SB 1732,
and/or Graduate Medical Education that were transferred from the hospital to a related public entity. Only
county, district, and University of California hospitals will report this item. This is an optional data field on the
Quarterly Report..
Supplemental payments received by hospitals serving a high percentage of Medi-Cal and other low income
patients. Authorized under Senate Bill 855 (Chapter 279,1991) these payments are funded from
intergovernmental transfers from public agencies (counties, hospital districts, and the University of California
system ) to the State and from federal matching funds.
The facility Doing Business As (DBA) name
Net fixed assets are the historical cost of land, plus the cost of land improvements, building and improvements,
leasehold improvements, equipment, and construction-in-progress, less accumulated depreciation and
amortization.
Total inpatient charges at the hospital’s full established rates for daily hospital services, inpatient ambulatory
services, and inpatient ancillary services before deductions from revenue are applied. See Payer Category.
DEDUCTIONS FROM REVENUE
DISCHARGES
DISPROPORTIONATE SHARE FUNDS
TRANSFERRED TO RELATED PUBLIC
ENTITY
DISPROPORTIONATE SHARE PAYMENTS
FOR MEDI-CAL PATIENT DAYS (SB 855)
FACILITY DBA NAME
FIXED ASSETS (Net of Accumulated
Depreciation)
GROSS INPATIENT REVENUE
GROSS OUTPATIENT REVENUE
January 2016
Total outpatient charges at the hospital’s full established rates for outpatient ambulatory and outpatient ancillary
services rendered and goods sold. See Payer Category.
2
Quarterly_Glossary_2015 After.xls
Office of Statewide Health Planning and Development
Glossary for Quarterly Financial and Utilization Report Data File
Quarters Ended 2015 and After
Data Item
Definition
HEALTH FACILITY PLANNING AREA (HFPA) A numeric code denoting the Health Facility Planing Area (HFPA) in which the hospital is located. The HFPA is
a geographic subdivision of a Health Service Area (HSA) and is defined by OSHPD for evaluating existing and
required hospitals and services.
A numeric code denoting the HSA in which the hospital is located. The HSA’s geographic area, consisting of
HEALTH SERVICE AREA (HSA)
one or more contiguous counties, is designated by the Federal Department of Health and Human Services for
health planning on a regional basis. There are 14 HSAs in California.
HOSPITAL DISCHARGES
See Discharges.
The number of licensed beds (excluding beds placed in suspense and nursery bassinets) stated on the hospital
LICENSED BEDS
license at the end of the reporting period.
The formal release of a formally admitted LTC patient from the hospital, including deaths at the hospital. Also
LONG-TERM CARE (LTC) DISCHARGES
counted is the transfer (discharge) of a LTC patient to another type of care. (See Discharges for more
information.) On the Quarterly Report, this is an optional data field.
Hospitals which provide skilled nursing care, intermediate care, sub acute care, and other long-term care
LONG-TERM CARE (LTC) PATIENT DAYS
services are encouraged to report this item. Also included are patient days of skilled nursing care provided in
swing beds. This is an optional data field on the Quarterly Report.
Managed care patients are patients enrolled in a managed care plan to receive health care from providers on a
MANAGED CARE
pre-negotiated or per diem basis, usually involving utilization review (includes Health Maintenance Organizations
(HMO), Health Maintenance Organizations with Point-of-Service option (POS) Preferred Provider Organizations
(PPO), Exclusive Provider Organizations (EPO), Exclusive Provider Organizations with Point-of- Service
option, etc.).
The Medi-Cal Managed Care category includes patients covered by a managed care plan funded by Medi-Cal
MEDI-CAL – MANAGED CARE
and was previously reported in the Other Third Parties category. See Managed Care.
The Medi-Cal-Traditional category includes patients who are qualified as needy under state laws and was
MEDI-CAL – TRADITIONAL
previously reported in the Medi-Cal category.
The Medicare – Managed Care category includes patients who are qualified as needy under state laws and was
MEDICARE – MANAGED CARE
previously reported in the Medi-Cal category. See Managed Care.
The Medicare – Traditional category includes patients covered under the Social Security Amendments of 1965
MEDICARE – TRADITIONAL
and was previously reported in the Medicare category. These patients are primarily the aged and needy.
NET PATIENT REVENUE
NON-OPERATING REVENUE NET OF NONOPERATING EXPENSES
OPERATING STATUS (CURRENT)
January 2016
Gross patient revenue less deductions from revenue. This amount is more comparable than gross patient
revenue because it indicates the actual amount received from patients and third party payers. Includes
disproportionate share payments (before any transfers to related entities) and capitation premium revenue.
See Payer Category.
If non-operating expenses are greater than non-operating revenue, the amount is entered as a negative number
(with brackets). Non operating items are those revenue and expenses that do not related directly tot he
provision of health care services.
Indicates whether a hospital is open or closed at the end of the quarter.
3
Quarterly_Glossary_2015 After.xls
Office of Statewide Health Planning and Development
Glossary for Quarterly Financial and Utilization Report Data File
Quarters Ended 2015 and After
Data Item
OSHPD FACILITY NO.
OTHER ADJUSTMENTS AND
ALLOWANCES
OTHER INDIGENT
OTHER OPERATING REVENUE
OTHER PAYERS
OTHER THIRD PARTIES- MANAGED CARE
OTHER THIRD PARTIES-TRADITIONAL
OUTPATIENT VISITS
PATIENT (CENSUS) DAYS
January 2016
Definition
A nine-digit hospital identification number assigned by OSHPD for reporting purposes. OSHPD facility numbers
are typically based on a facility’s operating license.
Includes policy discounts, administrative adjustments, and other deductions from revenue that are not included
elsewhere.
The Other Indigent category includes indigent patients who are being provided charity care by the hospital and
U.C. teaching hospital patients who are provided care with Support for Clinical Teaching funds. It excludes
patients who are recorded in the Count Indigent Programs category. This category was previously reported the
Other Payers category.
Revenue generated by health care operations from non-patient care services to patients and others. Examples
include non-patient food sales, refunds and rebates, supplies sold to non-patients, and Medical Records
abstract sales. Does not include interest income.
The Other Payers category includes all patients who do not belong in the other categories, such as those
designated as self-pay.
The Other Third Parties – Managed Care category includes patients covered by managed care plans other than
those funded by Medicare, Medi-Cal, or a county; and was previously reported in the Other Third Parties
category. Patients enrolled in the Healthy Families program are reported here. See Managed Care.
The Other Third Parties – Traditional category includes all other forms of health coverage excluding managed
care plans. Examples include Short-Doyle, CHAMPUS, IRCA/SLIAG, California Children’s Services, indemnity
plans, fee-for-service plans, and Workers’ Compensation. This category was previously reported in the Other
Third Parties category.
A visit is an appearance of an outpatient in the hospital for ambulatory services or the appearance of a private
referred outpatient in the hospital for ancillary services. In both instances, the patient is typically treated and
released the same day, and is not formally admitted as an inpatient, even though occasional overnight stays
may occur. Included are outpatient emergency room visits, outpatient clinic visits, referred ancillary service
visits, home health contact, and day care days, where the outpatient is treated and released the same day.
Also included are outpatient chemical dependency visits, hospice outpatient visits, and adult day health care
visits. See Payer Category.
The number of census days that all formally admitted inpatients spent in the hospital during the reporting
period. Patient days include the day of admission, but not the day of discharge. If both admission and
discharge occur on the same day, one patient day is counted. Nursery days and purchased inpatient days are
excluded. See Payer Category.
4
Quarterly_Glossary_2015 After.xls
Office of Statewide Health Planning and Development
Glossary for Quarterly Financial and Utilization Report Data File
Quarters Ended 2015 and After
Data Item
Definition
PAYER CATEGORY
Annual and Quarterly Reports include financial and utilization data by payer category, which is defined as the
third-party or individual who is responsible for the predominant portion of a patient’s bill. For 2000 Annual and
Quarterly Reports, the Office has established 10 payer categories: Medicare – Traditional, Medicare – Managed
Care, Medi-Cal – Traditional, Medi-Cal – Managed Care, County Indigent Programs – Traditional, County
Indigent Programs – Managed Care, Other Third Parties – Traditional, Other Third Parties – Managed Care,
Other Indigent, and Other Payers. Definitions of these payer categories are included in thie glossary.
PHONE NUMBER
PHYSICIAN PROFESSIONAL COMPONENT
(PPC) EXPENSES
The main business phone number of the hospital.
Expense included in the physicians’ total compensation. This includes all amounts paid or to be paid to hospital
based physicians and residents for patient care and recorded as an expense of the hospital for the reporting
period. PPC expenses are an optional reporting item on Quarterly Reports.
Accounts receivable which are determined to be uncollectible due to the patient’s unwillingness to pay and are
charged as a credit loss against gross patien
