20170618_-_2017-N-66799_-_Tables_1-4.pdf

Table 1. Hepatitis test results (submitted quarterly)

SAS variable label SAS variable name Variable type Variable length Variable values/ranges Required field Validation/QC Description/comments

Patient ID Patient_id Character 15 Alphanumeric code Yes Not missing Unique patient identifier

Patient month and year of birth DOB Numeric 6 01/1920-current Yes No dates before 01/1920 or other invalid dates 2 digit month and 4 digit year

Patient age at time of test Age Numeric 3 0-100 Yes 0 < Patient_age < 100

1 = male

2 = female

9 = unknown

Patient race Race Numeric 1

1 = white

2 = BlackAA

3 = AI/AN

4= Asian

5 = NH/PI

9 = unknown

Patient ethnicity Ethnic Numeric 1

0 = not Hispanic

1 = Hispanic

9 = unknown

Patient payer/insurance Insur Numeric 1

1 = self/patient

2 = private/commercial

3 = Medicare

4 = Medicaid

5 = Account

Yes Not missing

Medicare and Medicaid categories include fee for service and managed care plans; dual

Medicaid/Medicare classified as Medicaid;

test billed directly to account classified as account

Patient city Patcity Character 30 Yes City of patient residence

Patient state Patstate Character 2 2-letter state abbreviation Yes No invalid state abbreviations State of patient residence

Patient 5 digit zip code Patzip Numeric 5 Yes No invalid zip code 5-digit zipcode of patient residence

Account ID AcctID Character 15 Alphanumeric code Yes Not missing Unique identifier of account associated with ordering provider

Account name Acctname Character 75 Yes Not missing Name of account

Account city Acctcity Character 30 Yes City of account

Account state Acctstate Character 2 State abbreviation Yes No invalid state abbreviations State of account

Account zip code Acctzip Numeric 5 Yes No invalid zip code 5-digit zipcode of account

Account type Acctype Numeric 1

1= FQHC/CHC

2 = Other outpatient

3 = Inpatient

4 = Emergency Room

5 = Corrections

6 = Dialysis center

7 = Nursing home

8 = SSP

National Provider Identifier NPI Character 30 Yes Not missing National Provider Identifier

Unique Accession Identifer ACCN Numeric 10 10 digit number. Unique accession identifier.

PATIENT INFO

ACCOUNT AND PROVIDER INFO

Patient sex Sex Numeric 1 Yes Resolve multiple sex (select most commonly recorded)

SAS variable label SAS variable name Variable type Variable length Variable values/ranges Required field Validation/QC Description/comments

Date of Service DOS Numeric 8 mmddyyyy Yes No invalid dates (01/01/2011 earliest date) Date test performed

Type of virus Virus Character 1

A = hepatitis A

B = hepatitis B

C = hepatitis C

E = hepatitis E

Yes

Hepatitis A Antibody IgM

Hepatitis A Antibody Total

Hepatitis B Core Antibody IgM

Hepatitis B Core Antibody Total

Hepatitis B DNA Qualitative

Hepatitis B DNA Quantitative

Hepatitis B Surface Antibody

Qualitative

Hepatitis B Surface Antibody

Quantitative

Hepatitis B Surface Antigen

Confirmation

Hepatitis B Surface Antigen Screen test

Hepatitis B e Antibody

Hepatitis B e Antigen

HBsAb Quant HBIG Assessment

Hepatitis B genotype

Hepatitis C RIBA

Hepatitis C RNA Quantitative

Hepatitis C RNA Qualitative

Hepatitis C Antibody

Hepatitis C genotype

Hepatitis C IL28B

Resistance associated HCV variant*

Hepatitis E Antibody, IgG

Hepatitis E Antibody, IgM

Assay name Assay Character 20 Yes Not missing Name of commercial assay

Raw test result Raw_result Character 15 Yes Not missing

The result stated here will be “as is” derived from the record. It may be numeric or in letters or a combination of both.

Interpreted test result Result Numeric 1

1 = positive

2 = negative

3 = indeterminate

Yes Not missing Work with CDC to develop algorithm

Result Units units Character 15

COPIES/ML

IU/ML

LOG IU/ML

S:CO

Yes Not missing Units must be consistent within test type

Diagnosis code ICD Character 90 String Yes Valid ICD-9 and ICD-10 codes Up to 10 diagnosis codes associated with hepatitis test

Procedure code CPT Character 90 String Yes Valid Current Procedural

Terminology code Up to 10 CPT codes on the date of service

LOINC Code LOINC Character 90 String Yes Valid LOINC code

OB Panel OB_panel Numeric 1

1 = Yes

2 = No

9 = unknown

Yes Whether the Hepatitis tests was ordered together with or part of the OB panel

Pregnancy code ICD_preg Character 90 String Yes Valid ICD-9 and ICD-10 codes Pregnancy specific codes associated with

DOS

Not missing

HEPATITIS TEST

Test name Test Character 60 Yes

Table 2. Liver staging tests (submitted annually)

SAS variable label SAS variable name Variable type Variable length Variable values/ranges Required field Validation/QC Description/comments

Patient ID Patient_id Character 15 Alphanumeric code Yes Not missing Unique patient identifier

Patient payer/insurance Insur_Fib Numeric 1

1 = self/patient

2 = private/commercial

3 = Medicare

4 = Medicaid

5 = Account

Yes Not missing

Medicare and Medicaid categories include fee for service and managed care plans; dual

Medicaid/Medicare classified as

Medicaid; test billed directly to account classified as account

Account ID AcctID_Fib Character 15 Alphanumeric code Yes Not missing Unique identifier of account associated with ordering provider

Account name Acctname_Fib Character 75 Yes Not missing Name of account

Account city Acctcity_Fib Character 30 Yes City of account

Account state Acctstate_Fib Character 2 State abbreviation Yes No invalid state abbreviations State of account

Account zip code Acctzip_Fib Numeric 5 Yes No invalid zip code 5-digit zipcode of account

Account type Acctype_Fib Numeric 1

1= FQHC/CHC

2 = Other outpatient

3 = Inpatient

4 = Emergency Room

5 = Corrections

6 = Dialysis center

7 = Nursing home

8 = SSP

National Provider

Identifier NPI_Fib Character 30 Yes Not missing National Provider Identifier

Unique Accession

Identifer ACCN_Fib Numeric 10

10 digit number. Unique accession identifier.

Date of service DOS_Fib Numeric 8 mmddyyyy Yes No invalid dates

(01/01/2011 earliest date) Date test performed

ALT result ALT Numeric Yes U/L

AST result AST Numeric Yes U/L

Platelet count Platelet Numeric Yes thousands/mm3

Name of liver staging test FIB_name Character 20 Yes E.g., FibroTest, FibroSure, Hepascore

Fibrosis score FIB_score Numeric 5 Yes Calculated score based on liver staging test

Fibrosis stage FIB_stage Character 20 Yes Interpreted disease stage from fibrosis score

Procedure code CPT_Fib Character 90\ Yes Valid CPT code Up to 10 CPT codes associated with date of service

LOINC Code LOINC_Fib Character 90 Yes Valid LOINC code

PATIENT INFO

ACCOUNT AND PROVIDER INFO

LIVER DISEASE EVALUATION

Table 3. Diagnosis and pregnancy codes (submitted annually)

SAS variable label SAS variable name Variable type Variable length Variable values/ranges Required field Validation/QC Description/comments

Patient ID Patient_id Character 15 Alphanumeric code Yes Not missing Unique patient identifier

Date of Service DOS_long Numeric 8 mmddyyyy Yes No invalid dates Date test performed

Diagnosis code ICD_long Character 90 String Yes Valid ICD-9 and ICD-10 codes Up to 10 diagnosis codes associated with DOS

Pregnancy code ICD_preg_long Character 90 String Yes Valid ICD-9 and ICD-10 codes Pregnancy specific codes associated with DOS

PATIENT INFO

Example aggregate data tables (submitted quarterly and annually) Table 4. Number of unique persons with at least one record by state and year of birth

Table 5. Number of unique persons with at least one record by state and provider specialty

State of residence <1924 1925 1926 … 2014 2015 2016 <1924 1925 1926 … 2014 2015 2016 <19241925 1926 … 2014 2015 2016 <19241925 1926 … 2014 2015 2016 <1924 ## 1926 … 2014 2015 2016

Alabama

Alaska

Arizona

Arkansas

Wyoming

Patient birth year

Q1 2011Total 2011

Patient birth year

Q2 2011

Patient birth year

Q3 2011

Patient birth year

Q4 2011

Patient birth year