**Contract Health Services (Outpatient) Report 3A - By Area and ASUFAC**
Page: 1

**Visits By Male, Female, Diagnosis, And Age Groups** Date: 05/14/2003

Report Run Date: 05/14/2003

AREA: 12 XXXXX 10/01/2001

FACILITY: 123456 XXXXXXXX through

09/30/2002

A G E G R O U P S

TOTAL 0-27 28 days 1-4 5-9 10-14 15-19 20-24 25-44 45-64 65+ Unk

# D I A G N O S I S VISITS Days 11 mos. yrs yrs yrs yrs yrs yrs yrs yrs yrs

067 INFECTIVE DISEASE

Male Visits 1 1

Female Visits 1 1

TOTAL 2 1 1

**TOTAL INFECTIOUS AND PARASITIC DISEASES (001-067)**

Male Visits 3 1 1 1

Female Visits 6 3 1 2

TOTAL 9 1 3 2 3

070 MALIGNANT NEOPLASM

Male Visits 36 17 19

Female Visits 32 4 12 16

TOTAL 68 4 29 35

071 BENIGN NEOPLASM

Male Visits 10 1 5 4

Female Visits 2 1 1

TOTAL 12 1 6 5

**071 NEOPLASMS (070-071)**

Male Visits 46 1 22 23

Female Visits 34 4 13 17

TOTAL 80 1 4 35 40

**XXXXX FACILITY TOTAL:**

**Male Visits 2 0 0 0 0 1 0 0 0 1 0 0**

**Female Visits 0 0 0 0 0 0 0 0 0 0 0 0**

**TOTAL 2 0 0 0 0 1 0 0 0 1 0 0**

819 PREVENTIVE HEALTH SERVICE

Male Visits 186 7 43 17 19 14 53 20 13

Female Visits 329 8 34 29 47 24 114 61 12

TOTAL 515 15 77 46 66 38 167 81 25

819 SUPPLEMENTAL (817-999)

Male Visits 186 7 43 17 19 14 53 20 13

Female Visits 329 8 34 29 47 24 114 61 12

TOTAL 515 15 77 46 66 38 167 81 25

**XXXXX HLTH C FACILITY TOTAL:**

**Male Visits 186 0 0 7 43 17 19 14 53 20 13 0**

**Female Visits 329 0 0 8 34 29 47 24 114 61 12 0**

**TOTAL 515 0 0 15 77 46 66 38 167 81 25 0**

Contract Health Service **(OUTPATIENT)** **Report 3A** - By Area and
ASUFAC Visits By Male, Female, Diagnosis, And Age Groups

**[FIELDS from CHSOUT: Calculations PCC CHS368 FI]{.underline}**

region_code X X\*\* X\*\*

date of service X X X

area X X\*\* X\*\*

service_unit X X\*\* X\*\* facility X X\* X\*

sex X X X

age Date of service - date_of_birth (in days i.g.1275)

Date of service - date of birth / 365.25 (years i.e. 3.5)

dx1_recode X X X

*count(\*)* dx_code Count(\*) (count all dx codes i.e add one to the
counter)

\* Authorizing facility

\*\* Based on authorizing facility

## FIELDS from the REFERENCE TABLE:

area_name

service_unit_name

short_fac_name

## name *(i.e. Strep Throat)*

recode_class, *(i.e. last 3 digits of recode_name 067)*

recode_name *(i.e. INFECTIOUS AND PARASITIC DISEASES (001-067)*

## RESTRICTIONS:

work load report = \'Y\' (workload by asufac (apc/outpatient by loe))

post cutoff flag is null (records received after the official cutoff
date)

This report is based on visits by gender and their diagnosis by age
groups from birth to 65 and over. The diagnoses are based on data entry
inputs. This particular report is based on RECODES - [primary dx1
recode]{.underline}). It is then broken down by APC class recode - see
sample of report. Total is given for each grouping class and
Facility/ASUFAC and Area total at the end of the report.

ASUFAC vs. LOE (Location of encounter); LOE is not given in CHS638 and
CHSFI exports, so with the direction of HQE all CHS reports are based on
ASUFAC ONLY.

**[Problem areas:]{.underline}**

-   INP (Inpatient recodes) vs. APC recodes. We have seen some incorrect
    coding of recodes where we could have recodes that are INPATIENT
    recodes. In this case we take a look at the ICD9 code and link that
    ICD9-code to the correct apc recode.

-   NULL or BLANK SPACES in the dx1-9_recodes.

-   Grouping for "ALL DISEASES MALE GENITALIA (400-440) has miscoding of
    Females for this group but then again, the following codes could
    very well be of both genders?

1.  Recode 411-CHRONIC RENAL FAILURE is NOT necessarily a male recode.
    Could be of either gender.

2.  Recode 420-DISEASE OF URINARY SYSTEM could also be of either gender.

3.  Recode 400-URINARY TRACT INFECTION again either gender.

4.  Recode 410-NEPHRITIS again either gender.

5.  See last page for "Questions about Recode Responsibilities.

**[Source of Data:]{.underline}**

-   Area database, CHSOUT table

-   Reference Tables

    1.  chsout

    2.  r_apc_recode_class

    3.  r_apc_codes

    4.  r_area

    5.  r_service_unit

> 6\. r_facility

**[Conclusion:]{.underline}**

-   Annual report that totals ALL CHSOUT (Contract Health Service
    Outpatient) care visits (i.e. Indian and non-Indian Outpatient
    visits to a NON-IHS facility ONLY) by dx1_recode diagnosis, female
    or male, and age groups.

-   Report maybe grouped by Area, Service Unit, Facility, or ASUFAC with
    a designated region. Within a designated region, the following
    should be true based on input and restrictions for each particular
    report:

End of report

Yes Yes Yes Yes Yes

No No No

DO NOT include DO NOT include DO NOT include

record in request record in request record in request

Yes Yes

**Do the areas require this 3A report based on the information stated
below...RECODES?**

> \-\-\-\--Original Message\-\-\-\--
>
> **From:** Gowan, Patricia
>
> **Sent:** Thursday, May 15, 2003 2:45 PM
>
> **To:** Toya, Albert (ITSC); Herrera, Joseph (ITSC)
>
> **Cc:** Cadman, Yolinda (ITSC); Leach, Diane
>
> **Subject:** RE: Question about Recode Responsibilities
>
> I agree with Al. There is no longer a need for APC recodes as the APC
> Form that was superceded by PCC forms is obsolete. IHS should rely on
> ICD-9 and CPT codes for coding, billing and reimbursement purposes.
> The two coding systems are also approved nomenclature by HIPAA.
>
> Pat
>
> \-\-\-\--Original Message\-\-\-\--
>
> **From:** Toya, Albert (ITSC)
>
> **Sent:** Thursday, May 15, 2003 1:35 PM
>
> **To:** Herrera, Joseph (ITSC)
>
> **Cc:** Cadman, Yolinda (ITSC); Leach, Diane; Gowan, Patricia
>
> **Subject:** RE: Question about Recode Responsibilities
>
> This issue has been in discussion for some time. The discussion is to
> do away with APC/ICD Recodes.
>
> The designing of APC recodes was to accommodate the old APC-Ambulatory
> Patient Care Report form and these particular forms became obsolete
> sometime ago. Superceded by PCC Data Entry software and the PCC forms
> which allows ICD coders to use the most current ICD-9 codes for both
> Outpatient and Inpatient.
>
> Plus, if ICD recode are to be used, it defeats the purpose of
> requiring ICD-9 coders to be accurate. Because when these codes are
> recoded with ICD recode, the accurate ICD-9 codes becomes inaccurate
> immediately.
>
> And for these reasons, we haven\'t distributed any ICD Recodes for the
> past several years or more. Only, the most current ICD-9 codes from
> AMA American Medical Association are distributed now a days.
>
> Do you know who is responsible for the ICD/recode updates?
>
> \- Patricia Gowan is Acting Health Records Consultant.
>
> \- I have been doing the ICD-9 updates after Irene Edmonds retired.

Hope this will help.

**Cumulative Monthly Statistical Report**

**Report 3G - Contract Health Services - INPATIENT** Page: 1

**Hospitalization (WORKLOAD) Services by ASUFAC** 10/01/2002 Date:
5/15/03

**(restricted by provider type)** through Data Date: 05/05/2003

09/30/2003

Area: 12 XXXXXX

Service Unit: 1234 XXXXX

Facility: 123456 XXXXXXXX

HOSPITAL TYPE DISCHARGES\* DAYS ALOS

01 HOSPITAL - GM&S ADULT/PEDS 30 107 3.6

03 HOSPITAL - PSYCHIATRIC 2 11 5.5

FACILITY TOTAL 32 118 3.7

HOSPITAL TYPE DISCHARGES\* DAYS ALOS

01 HOSPITAL - GM&S ADULT/PED 23 56 2.4

01 HOSPITAL - GM&S NEWBORNS 6 12 2.0

FACILITY TOTAL 29 68 2.3

AREA TOTAL 93 359 3.9

\* THE FIGURES IN THIS COLUMN REPRESENT ONLY

THOSE DISCHARGES FOR WHICH ALL OF THE INFORMATION

REQUIRED TO PRODUCE THE TABLE WERE PRESENT ON THE

SOURCE DOCUMENT (ADMISSION AND DISCHARGE DATE,

PROVIDER CODE/TYPE. End of report

*Cost was removed from report..*

Contract Health Service **(INPATIENT)** **Report 3G** -- Hospitalization
(WORKLOAD) Service by ASUFAC:Cumulative Monthly Statistical Report

**[FIELDS from CHSINP TABLE: Calculations PCC CHS368 FI]{.underline}**

region_code X X\*\* X\*\*

area X X\*\* X\*\*

service_unit X X\*\* X\*\*

asufac X X\* X\*

date_of_birth X X X

provider_code X

provider_type X X

t_days (total admission days) X X X

age admission_date -- date_of_bith / 365.25

discharge_date X X X

admission_date X X X

\* CHS638 & CHSFI sends authorizing facility

## FIELDS from the REFERENCE TABLE:

chs_prov_type_code

service_unit_name

area_name

short_fac_name

table_type

## RESTRICTIONS:

work load report = \'Y\' *(workload by asufac (apc/inpatient by loe))*

work load report = 'Y' *(from r_chs_prov_type table***)**

post cutoff flag is null *(records received after the official cutoff
date-this usually is a factor near end of fiscal year)*

table_type = 'I' *(incidates Inpatient)*

3G Inpatient report is based on hospitalization (WORKLOAD ONLY) services
restricted by Inpatient **table type** of '**I**' (Inpatient). Anything
(i.e. 'A', Blanks, and Nulls) other then '**I**' is not listed in this
report. Total discharges, total admission days and total average length
of stay (ALOS) is listed for each valid hospital type. **Valid**
hospital types are: **BOLD** indicates what is reflected on this report.
Table: r_chs_prov_type

PROVIDER TABLE WORKLOAD

[TYPE PROVIDER NAME TYPE REPORTABLE]{.underline}

01 HOSPITAL - GM&S A Y

**01 HOSPITAL - GM&S I Y**

02 HOSPITAL - TB N

**03 HOSPITAL - PSYCHIATRIC I Y**

**04 NURSING HOME I Y**

05 PHYSICIAN A Y

06 OPTOMETRIST A Y

07 DENTIST A Y

08 NURSE OR HOME HEALTH SERVICE N

09 LABORATORY N

10 ORTHOPEDIC APPLIANCE CO. N

11 OPTICAL CO. N

12 PHARMACY A Y

13 TRANSPORTATION N

14 MORTUARY N

15 X-RAY N

16 ALL OTHER A Y

17 CHIROPRACTOR A Y

18 NHSC - PNP (NATIONAL HEALTH SERVICE CORPS) A Y

19 NHSC - CNW (NATIONAL HEALTH SERVICE CORPS) A Y

ASUFAC vs. LOE (Location of encounter); LOE is not given in CHS638 AND
CHSFI exports, so with the direction of HQE all CHS reports are based on
ASUFAC ONLY.

**[Problem areas]{.underline}**:

-   Open for discussion

**[Source of Data:]{.underline}**

-   Area database, CHSINP table

-   Reference Tables

    1.  chsinp

    2.  r_chs_prov_type

    3.  r_area

    4.  r_service_unit

    5.  r_facility

**[Conclusion:]{.underline}**

-   Cumulative report that totals ALL CHSINP (Contract Health Service
    Inpatient) care visits (i.e. Inpatient visits to a NON-IHS facility)
    by hospitalization-workload.

-   Report is grouped by Area, Service Unit and Provider Code Type
    within a designated region, the following should be true based on
    input and restrictions for each particular report

Yes Yes Yes Yes Yes Yes Yes Yes Yes

No No No

DO NOT include DO NOT include DO NOT include

record in request record in request record in request

Yes Yes Yes

No

DO NOT include in report

DO NOT include No Yes Yes

in report

**Cumulative Monthly Statistical Report**

**Report 3G - Contract Health Services - OUTPATIENT**

**Services by ASUFAC** 10/01/2002

**(restricted by provider type)** through

09/30/2003

Area: 12 XXXXXXX

Service Unit: 1234 XXXXXX

Facility: 123456 XXXXXXXXXXXX

TYPE OF NUMBER OF

OUTPATIENT OUTPATIENT

SERVICES VISITS

MD (01) 1

MD (05) 170

OD (06) 1

FACILITY (ASUFAC) TOTAL 172

*Cost was removed from reports.*

Contract Health Service **(OUTPATIENT)** **Report 3G** -- Services
(workload) by ASUFAC (restricted by provider type)

**[FIELDS from CHSOUT TABLE: Calculations PCC CHS368 FI]{.underline}**

region_code X X\*\* X\*\*

area X X\*\* X\*\*

service_unit X X\*\* X\*\*

asufac X X\* X\*

date_of_birth X X X

provider_code X

provider_type X X

date_of_service date_of_service -- date_of_birth X X X

\* Authorizing facility

\*\* Based on authorizing facility

## FIELDS from the REFERENCE TABLE:

chs_prov_type_code

table_type

service_unit_name

area_name

short_fac_name

## RESTRICTIONS:

work load report = \'Y\' *(workload by asufac (apc/OUTPATIENT by loe))*

work load report = 'Y' *(from r_chs_prov_type table***)**

post cutoff flag is null *(records received after the official cutoff
date-this usually is a factor near end of fiscal year)*

table_type = 'A' *(incidates OUTPATIENT)*

3G OUTPATIENT report is based on WORKLOAD Services ONLY- restricted by
**table type** of 'A' (Ambulatory). Anything (i.e. 'I', Blanks, and
Nulls) other then 'A' is not listed in this report. Types of outpatient
services render and number of outpatient visits; **valid** chsout
provider types are: **BOLD** indicates what is reflected on this report.
Table: r_chs_prov_type

PROVIDER TABLE WORKLOAD

[TYPE PROVIDER NAME TYPE REPORTABLE]{.underline}

**01 HOSPITAL - GM&S A Y**

01 HOSPITAL - GM&S I Y

02 HOSPITAL - TB N

03 HOSPITAL - PSYCHIATRIC I Y

04 NURSING HOME I Y

**05 PHYSICIAN A Y**

**06 OPTOMETRIST A Y**

**07 DENTIST A Y**

08 NURSE OR HOME HEALTH SERVICE N

09 LABORATORY N

10 ORTHOPEDIC APPLIANCE CO. N

11 OPTICAL CO. N

**12 PHARMACY A Y**

13 TRANSPORTATION N

14 MORTUARY N

15 X-RAY N

**16 ALL OTHER A Y**

##  17 CHIROPRACTOR A Y

**18 NHSC - PNP (NATIONAL HEALTH SERVICE CORPS) A Y**

**19 NHSC - CNW (NATIONAL HEALTH SERVICE CORPS) A Y**

ASUFAC vs. LOE (Location of encounter); LOE is not given in CHS638 or
CHSFI exports, so with the direction of HQE all CHS reports are based on
ASUFAC ONLY.

**[Problem areas:]{.underline}**

-   Open for discussion

**[Modifications:]{.underline}**

-   This report can be modified and replace the MD (01) to it's original
    provider name "01 Hospital -- GM&S"

**[Source of Data:]{.underline}**

-   Area database, CHSOUT table

-   Reference Tables

    1.  CHSOUT

    2.  r_chs_prov_type

    3.  r_area

    4.  r_service_unit

    5.  r_facility

**[Conclusion:]{.underline}**

-   Report totals ALL CHSOUT (Contract Health Service OUTPATIENT) care
    visits (i.e. OUTPATIENT visits to a NON-IHS facility) by
    service-workload.

Report is grouped by Area, Service Unit, ASUFAC and Provider Code Type
within a designated region, the following should be true based on input
and restrictions for each particular report:

Yes Yes Yes Yes Yes Yes Yes Yes Yes

No No No

DO NOT include DO NOT include DO NOT include

record in request record in request record in request

Yes Yes Yes Yes Yes

No No No

DO NOT include in report DO NOT include in report DO NOT include in
report

**Report 3H - Contract Health Service Inpatient** Page: 1

Date: 5/16/03

**Number of Discharges And Hospital Days**

**By External Cause Of Current Injury, By Age Groups** Report Run Date:
5/16/03

10/01/2001

AREA: 12 XXXXXX thru

SERVICE UNIT: 1234 XXXXX 09/30/2002

TOTAL A G E D I S T R I B U T I O N

DISH.

ALL AGES 0-27 28 DAYS 1 - 4 5 - 9 10 - 14 15 - 19 20 - 24 25 - 44 45 -
64 65+

EXTERNAL CAUSE OF CURRENT INJURY NO. ALOS YEARS 11 MOS. YEARS YEARS
YEARS YEARS YEARS YEARS YEARS YEARS UNKN

E- 812

. 0 MV COLLISION NOS-DRIVER 1 5.0 1

TOTAL E- 812 1 5.0 1

E- 828

. 2 RIDDEN ANIMAL ACC-RIDER 1 2.0 1

TOTAL E- 828 1 2.0 1

E- 878

. 1 ABN REACT-ARTIF IMPLANT 1 2.0 1

. 8 ABN REACT-SURG PROC NEC 1 3.0 1

TOTAL E- 878 2 2.5 1 1

E- 880

. 9 FALL ON STAIR/STEP NEC 1 1.0 1

TOTAL E- 880 1 1.0 1

E- 884

. 4 FALL FROM BED 2 2.5 1 1

TOTAL E- 884 2 2.5 1 1

E- 905

. 2 SCORPION STING 1 1.0 1

TOTAL E- 905 1 1.0 1

E- 988

. 9 UNDETERMIN CIRCUMST NOS 37 4.9 1 1 3 1 12 15 4

TOTAL E- 988 37 4.9 1 1 3 1 12 15 4

E- 989

. LATE EFF INJ-UNDET CIRC 1 8.0 1

TOTAL E- 989 1 8.0 1

**SERVICE UNIT TOTAL** **49** **4.5** **0** **2** **2** **2** **3**
**1** **13** **19** **7** **0**

**GRAND TOTAL EXTERNAL CAUSE OF** **49** **4.5** **0** **0** **2** **2**
**2** **3** **1** **13** **19** **7** **0**

**INJURY**

End of report

Contract Health Service **(INPATIENT)** **Report 3H** -- Number of
Discharges And Hospital Days By External Cause of Current Injury, By Age
Groups

**[FIELDS from CHSINP TABLE: Calculations PCC CHS368 FI]{.underline}**

region_code X X\*\* X\*\*

area X X\*\* X\*\*

service_unit X X\*\* X\*\*

asufac X X\* X\*

date_of_birth discharge_date -- date_of_birth

discharge_date discharge_date -- date_of_birth / 365.25

admission_date X X X

t_days total admission days

cause_of_injury1 X X X

\* Authorizing facility

\*\* Based on authorizing facility

## FIELDS from the REFERENCE TABLE:

service_unit_name

area_name

short_fac_name

icd9_ext_injury

## RESTRICTIONS:

work load report = \'Y\' *(workload by asufac (apc/OUTPATIENT by loe))*

post cutoff flag is null *(records received after the official cutoff
date-this usually is a factor near end of fiscal year)*

cause_of_injury1 is between '800' and '999' or 'E800' and 'E999'

ASUFAC vs. LOE (Location of Encounter); LOE is not given in CHS638 or
CHSFI exports. so with the direction of HQE all CHS reports are based on
ASUFAC ONLY.

3H INPATIENT report is based external cause of injury codes; there is
1081 external injury codes -- below is a list of injury codes.

**[Problem areas:]{.underline}**

-   Some records have the 'E' (i.e. 'E8010') and without the 'E' (i.e.
    '8010'). The 'E' will be represented on the report.

**[External Codes:]{.underline}**

8000 RR COLLISION NOS-EMPLOY

8010 RR COLL W OTH OBJ-EMPLOY

8020 RR ACC W DERAIL-EMPLOYEE

8030 RR ACC W EXPLOSION-EMPL

8040 FALL ON/FROM TRAIN-EMPL

8050 HIT BY TRAIN-EMPLOYEE

8060 RR ACC NEC-EMPLOYEE

8070 RR ACCIDENT NOS-EMPLOYEE

8100 MV-TRAIN COLL-DRIVER

8110 REENTRANT MV COLL-DRIVER

8120 MV COLLISION NOS-DRIVER

8130 MV-OTH VEH COLL-DRIVER

8140 MV COLL W PEDEST-DRIVER

8150 MV COLL W OTH OBJ-DRIVER

8160 LOSS CONTROL MV ACC-DRIV

8170 MV ACC BOARD/ALIGHT-DRIV

8180 MV TRAFF ACC NEC-DRIVER

8190 TRAFFIC ACC NOS-DRIVER

8200 SNOW VEH ACC-DRIVER

8210 OTH OFF-ROAD MV ACC-DRIV

8220 OTH COLL W MOV OBJ-DRIV

8230 OTH COLL STNDNG OBJ-DRIV

8240 N-TRAF BOARD/ALIGHT-DRIV

9677 CHLD/ADLT ABUS BY RELATI

9678 CHLD/ADLT ABU BY NON-REL

9679 CHILD ABUSE NOS

984 UNDETERM CIRC-SUBMERSION

9850 UNDETERMIN CIRC-HANDGUN

986 UNDET CIRC-CUT INSTRUMNT

9870 UNDET CIRC-FALL RESIDENC

9880 UNDETERM CIRC-MOVING OBJ

9889 UNDETERMIN CIRCUMST NOS

989 LATE EFF INJ-UNDET CIRC

9900 WAR INJ:GASOLINE BOMB

9910 WAR INJ:RUBBER BULLET

992 WAR INJ:MARINE EXPLOS

9970 WAR INJURY:LASERS

998 WAR INJ:POST WAR OPERAT

999 LATE EFF OF WAR INJURY

**[Source of Data:]{.underline}**

-   Area database, CHSINP table (IRCSRV2)

-   Reference Tables (IRCSRV2)

    1.  CHSINP

    2.  r_icd9_ext_injury

    3.  r_area

    4.  r_service_unit

    5.  r_facility

**[Conclusion:]{.underline}**

-   Report totals ALL CHSINP(Contract Health Service INPATIENT) current
    injury visits (i.e. INPATIENT visits to a NON-IHS facility).

-   Report is grouped by Area, Service Unit, and Cause of Injury within
    a designated region, the following should be true based on input and
    restrictions for each particular report:

Yes Yes Yes Yes Yes Yes Yes Yes Yes

No No No

DO NOT include DO NOT include DO NOT include

record in request record in request record in request

Yes Yes Yes Yes

No

DO NOT include in report DO NOT include in report

Yes

### Contract Health Services (Inpatient) Report 3I - By ASUFAC 

### Hospital Discharges, Days and Average Length of Stay 

**By Admission Diagnosis Recode, And Age Group** 10/01/2001 Page: 1
through Date: 5/16/03

09/30/2002 Report Run Date: 05/16/2003

Area: 12 XXXXXXX

Facility: 123456 XXXXXXXXXXX

A G E D I S T R I B U T I O N

INPATIENT Total 0-27 28 days 1-4 5-9 10-14 15-19 20-24 25-44 45-64 65+
Unk

RECODE ADMISSION DIAGNOSIS ALL AGES Days 11 mos. yrs yrs yrs yrs yrs yrs
yrs yrs Age

BLANK NO RECODE NAME

DISCH 1 1

DAYS 3 3

ALOS 3.0 3.0

COST \$2,557.50

TOTAL NO RECODE NAME

DISCH 1 1

DAYS 3 3

ALOS 3.0 3.0

COST \$2,557.50

014 STREPTOCOC SORE THROAT

DISCH 1 1

DAYS 1 1

ALOS 1.0 1.0

COST \$99.00

015 NO RECODE NAME

DISCH 1 1

DAYS 1 1

ALOS 1.0 1.0

COST \$5,785.79

TOTAL INFECTIOUS AND PARASITIC DISEASES (002-046)

DISCH 2 1 1

DAYS 2 1 1

ALOS 1.0 1.0 1.0

COST \$5,884.79

FACILITY TOTAL ADMISSION DIAGNOSIS

DISC 164 3 5 7 21 11 34 55 28

DAYS 860 12 5 29 147 36 164 312 155

ALOS 5.2 4.0 1.0 4.1 7.0 3.3 4.8 5.7 5.5

COST \$408,964.79

*Cost will be removed from report due to accounting purposes.*

Contract Health Service **(INPATIENT)** **Report 3I** -- Hospital
Discharges, Days and Average length of Stay By Admission Diagnosis
Recode, And Age Groups

**[FIELDS from CHSINP: Calculations PCC CHS368 FI]{.underline}**

region_code X X\*\* X\*\*

area X X\*\* X\*

service_unit X X\*\* X\*

asufac X X\* X\*

date_of_birth X X X

t_days (total admission days) X X X

age admission_date -- date_of_bith / 365.25

dx1_recode X X X

\* Authorizing facility

\*\* Based on authorizing facility

## FIELDS from the REFERENCE TABLE:

inp_code

inp_name

inp_recode_name

inp_recode_class

service_unit_name

area_name

short_fac_name

table_type

## RESTRICTIONS:

work load report = \'Y\' *(workload by asufac (apc/inpatient by loe))*

post cutoff flag is null *(records received after the official cutoff
date-this usually is a factor near end of fiscal year)*

3I Inpatient report is based on hospitalization services. Total
discharges, days and total average length of stay is listed given for
each age group.

ASUFAC vs. LOE (Location of encounter); LOE is not given in CHS638 or
CHSFI exports, so with the direction of HQE all CHS reports are based on
[ASUFAC ONLY]{.underline}.

**[Problem areas]{.underline}**:

-   Open for discussion

**[Source of Data:]{.underline}**

-   Area database, CHSINP table (IRCSRV2)

-   Reference Tables (IRCSRV2)

    1.  chsinp

    2.  r_inp_recode

    3.  r_inp_recode_class

    4.  r_area

    5.  r_service_unit

    6.  r_facility

**[Conclusion:]{.underline}**

 Report totals ALL CHSINP (Contract Health Service Inpatient) hospital

discharges, days, average length of stay by admission diagnosis RECODE

and age groups.

 Report is grouped by Area, ASUFAC and Recode within a designated

region/ASUFAC, the following should be true based on input and
restrictions

for each particular report:

Yes Yes Yes Yes Yes Yes Yes Yes Yes

No No No

DO NOT include DO NOT include DO NOT include

record in request record in request record in request

DO NOT include

NO record in request

Yes Yes Yes

DO NOT include No Yes Yes Yes

in report

No

DO NOT include

record in request

10/01/2001

**On Request 67** through Page: 1

**CHO Visits by Primary Care Provider by Community of Residence**
09/30/2002 Date: 6/12/03

Report Run Date: 02/25/2003

AREA: 12 XXXXXX

FACILITY: 123456 XXXXXXX

TOTAL

C O M M U N I T Y VISITS PRIMARY CARE PROVIDER

STATE: 12 ANYWHERE USA

COUNTY: 12 ANYWHERE USA

123 ANYWHERE USA 3 PEDIATRIC NURSE PRACTITIONER

COUNT TOTAL 3

STATE TOTAL 3

XXXXXX F A C I L T Y T O T A L: 3

End of report

Contract Health Service **(OUTPATIENT)** **Report 67** -- CHO Visits by
Primary Care Provider by Community of Residence

**[FIELDS from CHSOUT: Calculations PCC CHS368 FI]{.underline}**

region_code X X\*\* X\*\*

area X X\*\* X\*\*

service_unit X X\*\* X\*\*

asufac X X\* X\*

date_of_service X X X

reside_state_cd X X X

reside_countu_cd X X X

reside_comm_cd X X X

provider_code

\* Authorizing facility

\*\* Based on authorizing facility

## FIELDS from the REFERENCE TABLE:

state_code

county_code

community_code

provider_code

provider_name

service_unit_name

area_name

short_fac_name

table_type

## RESTRICTIONS:

prm_prov_flag = 'Y' (valid workload from the r_provider_codes table...
see below)

work load report = \'Y\' *(workload by asufac (apc/inpatient by loe))*

post cutoff flag is null *(records received after the official cutoff
date-this usually is a factor near end of fiscal year)*

or67 Outpatient report is based on primary care provider services -
total visits by where the patient lives.

ASUFAC vs. LOE (Location of encounter); LOE is not given in CHS638 or
CHSFI exports, so with the direction of HQE all CHS reports are based on
[ASUFAC ONLY]{.underline}.

  ------------ ---------------------------------- ------------ ------------
  **PROVIDER   **PROVIDER NAME**                  **PRM PROV   **WORK LOAD
  CODE**                                          FL**         REPORT**

  **00**       **MD**                             **Y**        **Y**

  01           CLINIC RN                          N            Y

  02           ENVIRONMENTAL HEALTH               N            Y

  03           HEALTH AIDE                        N            Y

  04           HEALTH EDUCATOR                    N            Y

  05           LICENSED PRACTICAL NURSE           N            Y

  06           MEDICAL SOCIAL WORKER              N            Y

  07           NUTRITIONIST                       N            Y

  08           OPTOMETRIST                        N            Y

  09           PHARMACIST                         N            Y

  10           PHYSICAL THERAPIST                 N            Y

  **11**       **PHYSICIAN ASSISTANT**            **Y**        **Y**

  12           PSYCHOLOGIST                       N            Y

  13           PUBLIC HEALTH NURSE                N            Y

  14           SCHOOL NURSE                       N            Y

  15           OTHER                              N            Y

  **16**       **PEDIATRIC NURSE PRACTITIONER**   **Y**        **Y**

  **17**       **NURSE MIDWIFE**                  **Y**        **Y**

  **18**       **CONTRACT PHYSICIAN**             **Y**        **Y**

  19           MENTAL HEALTH                      N            Y

  20           MEDICAL STUDENT                    N            Y

  **21**       **NURSE PRACTITIONER**             **Y**        **Y**

  22           NURSE ASSISTANT                    N            Y

  23           LABORATORY TECHNICIAN              N            Y

  24           CONTRACT OPTOMETRIST               N            Y

  **25**       **CONTRACT PODIATRIST**            **Y**        **Y**

  26           INHALATION THERAPIST               N            Y

  27           STUDENT NURSES                     N            Y

  28           AUDIOLOGIST                        N            Y

  29           DIETITIAN                          N            Y

  30           PHARMACY PRACTITIONERS             N            Y

  31           OPTOMETRIC ASSISTANT               N            Y

  32           CONTRACT PUBLIC HEALTH NURSE       N            Y

  **33**       **PODIATRIST**                     **Y**        **Y**

  34           TRIBAL/CONTRACT NUTRITIONIST       N            Y

  35           OUTREACH WORKER                    N            Y

  36           EYE CARE SPECIALIST                N            Y

  37           FAMILY PLANNING COUNSELOR          N            Y

  38           EMT/PARAMEDIC                      N            Y

  39           SPEECH THERAPIST                   N            Y

  40           AMBULANCE DRIVER                   N            Y

  **41**       **CONTRACT OB/GYN**                **Y**        **Y**

  42           SPEECH/LANGUAGE PATH               N            Y

  43           AUDIOMETRIC TECHNICIAN             N            Y

  **44**       **TRIBAL PHYSICIAN**               **Y**        **Y**

  **45**       **OSTEOPATHIC MEDICINE**           **Y**        **Y**

  46           DENTAL HYGIENIST                   N            Y

  47           CRNA                               N            Y

  48           ALCOHOLISM/SUB ABUSE COUNSELOR     N            Y

  **49**       **CONTRACT PSYCHIATRIST**          **Y**        **Y**

  50           CONTRACT PSYCHOLOGIST              N            Y

  51           PAPAGO NUTRITION PROGRAM           N            Y

  52           DENTIST                            N            Y

  53           COMMUNITY HEALTH REPRESENTATIVE    N            Y

  54           DENTAL ASSISTANT (PRENATAL)        N            Y

  55           DISEASE CONTROL PROGRAM            N            Y

  56           HEALTH RECORDS                     N            N

  57           ADMINISTRATIVE                     N            N

  58           SPEECH THER-DISCONTINUE            N            N

  59           XRAY TECHNICIAN                    N            Y

  60           DENTAL ASSISTANT                   N            Y

  61           DENTAL LAB                         N            Y

  62           LICENSED MEDICAL SOCIAL WORKER     N            Y

  63           CONTRACT SOCIAL WORKER             N            Y

  **64**       **NEPHROLOGIST**                   **Y**        **Y**

  65           OPTOMETRY STUDENT                  N            Y

  66           CASE MANAGERS                      N            Y

  67           CLINICAL PHARMACY SPECIALIST       N            Y

  **68**       **EMERGENCY ROOM PHYSICIAN**       **Y**        **Y**

  **69**       **CHIROPRACTOR**                   **Y**        **Y**

  **70**       **CARDIOLOGIST**                   **Y**        **Y**

  **71**       **INTERNAL MEDICINE**              **Y**        **Y**

  **72**       **OB/GYN**                         **Y**        **Y**

  **73**       **ORTHOPEDIST**                    **Y**        **Y**

  **74**       **OTOLARYNGOL**                    **Y**        **Y**

  **75**       **PEDIATRICIAN**                   **Y**        **Y**

  **76**       **RADIOLOGIST**                    **Y**        **Y**

  **77**       **SURGEON**                        **Y**        **Y**

  **78**       **UROLOGIST**                      **Y**        **Y**

  **79**       **OPHTHALMOLOGIST**                **Y**        **Y**

  **80**       **FAMILY PRACTICE**                **Y**        **Y**

  **81**       **PSYCHIATRIST**                   **Y**        **Y**

  **82**       **ANESTHESIOLOGIST**               **Y**        **Y**

  **83**       **PATHOLOGIST**                    **Y**        **Y**

  **84**       **PEDORTHIST**                     **Y**        **Y**

  **85**       **NEUROLOGIST**                    **Y**        **Y**

  **86**       **DERMATOLOGIST**                  **Y**        **Y**

  87           ULTRASOUND TECHNICIAN              N            Y

  88           CODING/DATA ENTRY                  N            N

  89           AUDIOLOGY HEALTH TECHNICIAN        N            Y

  90           OCCUPATIONAL THERAPIST             N            Y

  91           PHN DRIVER/INTERPRETER             N            N

  92           PSYCHOTHERAPIST                    N            Y

  93           TRADITIONAL MEDICINE PRACTITIONER  N            Y

  94           MENTAL HEALTH (BA/BS ONLY)         N            Y

  95           MENTAL HEALTH (MASTER ONLY)        N            Y

  96           FAMILY THERAPIST                   N            Y

  97           NUTRITION TECHNICIAN               N            Y

  98           FOOD SERVICE SUPERVISOR            N            N

  99           DIETETIC TECHNICIAN                N            Y

  **A1**       **SPORTS MEDICINE PHYSICIAN**      **Y**        **Y**

  A2           MEDICAL TECHNOLOGIST               N            Y

  A3           NATUROPATH DOCTOR                  Y            N

  A4           NATUROPATH PHYSICIAN               Y            N

  A5           ACUPUNCTURIST                      Y            N

  A6           IN SCHOOL THERAPIST                N            N

  A7           DOMESTIC VIOLENCE COUNSELOR        N            N
  ------------ ---------------------------------- ------------ ------------

**[Source of Data:]{.underline}**

-   Area database, CHSOUT table

-   Reference Tables

    1.  chsout

    2.  r_provider_codes

    3.  r_state_code

    4.  r_county_code

    5.  r_community_code

    6.  r_area

    7.  r_service_unit

    8.  r_facility

**[Conclusion:]{.underline}**

-   Report totals ALL CHSOUT (Contract Health Service Outpatient)
    County, State and Facility totals per primary care provider.

Yes Yes Yes Yes Yes Yes Yes Yes Yes

No No No

DO NOT include DO NOT include DO NOT include

record in request record in request record in request

Yes Yes Yes

DO NOT include

record in request