Patient Origin/Market Share (Pivot Profile)–Inpatient, Emergency Department, and Ambulatory Surgery

These Excel pivot tables identify where a facility’s patients come from (Patient Origin) and where patients from a specific area go to (Market Share) for hospital inpatient, emergency department, and ambulatory surgery treatment. The Patient Origin Report shows the ZIP codes of origin (based on a selected facility or facility county) and the Market Share Report lists the destination facilities (based on a selected patient ZIP code or patient county). Note: Physician-owned ambulatory surgery clinics do not report their data to HCAI and, therefore, are not included here.

These Excel pivot tables identify where a facility’s patients come from (Patient Origin) and where patients from a specific area go to (Market Share) for hospital inpatient, emergency department, and ambulatory surgery treatment. The Patient Origin Report shows the ZIP codes of origin (based on a selected facility or facility county) and the Market Share Report lists the destination facilities (based on a selected patient ZIP code or patient county). Note: Physician-owned ambulatory surgery clinics do not report their data to HCAI and, therefore, are not included here.

These Excel pivot tables identify where a facility’s patients come from (Patient Origin) and where patients from a specific area go to (Market Share) for hospital inpatient, emergency department, and ambulatory surgery treatment. The Patient Origin Report shows the ZIP codes of origin (based on a selected facility or facility county) and the Market Share Report lists the destination facilities (based on a selected patient ZIP code or patient county). Note: Physician-owned ambulatory surgery clinics do not report their data to HCAI and, therefore, are not included here.

These Excel pivot tables identify where a facility’s patients come from (Patient Origin) and where patients from a specific area go to (Market Share) for hospital inpatient, emergency department, and ambulatory surgery treatment. The Patient Origin Report shows the ZIP codes of origin (based on a selected facility or facility county) and the Market Share Report lists the destination facilities (based on a selected patient ZIP code or patient county). Note: Physician-owned ambulatory surgery clinics do not report their data to HCAI and, therefore, are not included here.

These Excel pivot tables identify where a facility’s patients come from (Patient Origin) and where patients from a specific area go to (Market Share) for hospital inpatient, emergency department, and ambulatory surgery treatment. The Patient Origin Report shows the ZIP codes of origin (based on a selected facility or facility county) and the Market Share Report lists the destination facilities (based on a selected patient ZIP code or patient county). Note: Physician-owned ambulatory surgery clinics do not report their data to HCAI and, therefore, are not included here.

These Excel pivot tables identify where a facility’s patients come from (Patient Origin) and where patients from a specific area go to (Market Share) for hospital inpatient, emergency department, and ambulatory surgery treatment. The Patient Origin Report shows the ZIP codes of origin (based on a selected facility or facility county) and the Market Share Report lists the destination facilities (based on a selected patient ZIP code or patient county). Note: Physician-owned ambulatory surgery clinics do not report their data to HCAI and, therefore, are not included here.