VT_PUF_FIELD_PROPERTIES

(1)

*Use for Vermont Inpatient, Outpatient and Emergency Department Tables

Name Description Type Length CODE TABLE

HOSPITAL_NUMBER HOSPITAL_NUMBER integer 4 YES

ADMISSION_TYPE ADMISSION_TYPE integer 1 YES

ADMISSION_SOURCE ADMISSION_SOURCE integer 2 YES

AGE_GROUP Age Group integer 2 YES

ZIP_CODE_GROUP Most Zip code groups are the first 3 digits of the ZIP code, ZIP codes between 05800 and 05999 are grouped

into "058-059" text 7 YES

SEX SEX integer 1 YES

DISCHARGE_STATUS DISCHARGE_STATUS integer 2 YES

PRINCIPAL_PAYMENT_SOURCE PRINCIPAL_PAYMENT_SOURCE integer 2 YES

TOTAL_CHARGES TOTAL_CHARGES decimal 11 NO

SCU_DAYS NUMBER OF DAYS IN SPECIAL

CARE UNIT, Includes all CCU, ICU &

other SCU integer 2 NO

DRG DIAGNOSIS RELATED GROUP integer 3 YES

MDC MAJOR DIAGNOSTIC CATEGORY integer 2 YES

DX1 PRINCIPAL_DIAGNOSIS text 5 ICD-9-CM

DX2 SECOND_DIAGNOSIS text 5 ICD-9-CM

DX3 THIRD_DIAGNOSIS text 5 ICD-9-CM

DX4 FOURTH_DIAGNOSIS text 5 ICD-9-CM

DX5 FIFTH_DIAGNOSIS text 5 ICD-9-CM

DX6 SIXTH_DIAGNOSIS text 5 ICD-9-CM

DX7 SEVENTH_DIAGNOSIS text 5 ICD-9-CM

DX8 EIGHTH_DIAGNOSIS text 5 ICD-9-CM

DX9 NINTH_DIAGNOSIS text 5 ICD-9-CM

DX10 TENTH_DIAGNOSIS text 5 ICD-9-CM

DX11 11th Diagnosis Text 5 ICD-9-CM

PX1 Principal Procedure Text 4 ICD-9-CM

PX2 Second Procedure Text 4 ICD-9-CM

PX3 Third Procedure Text 4 ICD-9-CM

PX4 Fourth Procedure Text 4 ICD-9-CM

PX5 Fifth Procedure Text 4 ICD-9-CM

PX6 Sixth Procedure Text 4 ICD-9-CM

PX7 Seventh Procedure Text 4 ICD-9-CM

PX8 Eighth Procedure Text 4 ICD-9-CM

PX9 Ninth Procedure Text 4 ICD-9-CM

PX10 Tenth Procedure Text 4 ICD-9-CM

PX11 11th Procedure Text 4 ICD-9-CM

(2)

E-code E-code Text 5 ICD-9-CM

HSA4 HOSPITAL_SERVICE_AREA or HSA4.

Note: Hospital Service Areas were redefined in June 2004. HSA values in the 2003 dataset cannot be compared to HSA values in earlier public use datasets. See HSA_Definition for more

information. integer 2 YES

PATIENT DAYS (DISCHARGE DATE minus

ADMISSION DATE) 1 if discharged on date of admission or on day after admission Length of stay greater than

255 days was recoded to 255. integer 5 NO

SAME DAY FLAG SAME DAY FLAG integer 1 YES

DRG_GROUPER_VERSION

Version Number corresponding with

effective discharges within a date range integer 2 YES

CCSDX CCS DIAGNOSIS (DX) GROUP

http://www.hcup-us.ahrq.gov/toolssoftware/ccs/ccs.jsp integer 4 YES

CCSDXGRP CCS DX HIGH LEVEL GROUP integer 2 YES

CCSPX CCS PROCEDURE (PX) GROUP integer 3 YES

CCSPXGRP CCS PX HIGH LEVEL GROUP integer 2 YES

YEAR OF DISCHARGE For 2000 and later, full data year (1999

and prior was 2 digits) integer 4 NO

RECORD NUMBER RECORD NUMBER integer 6 NO

ERFLAG had an associated Emergency Room

revenue record integer 1 YES

PATIENT_TYPE Inpatient, Outpatient or Emergency

Dept. text 1 YES

(3)

HOSPITAL_NUMBER

HOSP_NO Hospital Number Integer 4 No

HOSP_DESC Hospital Name Text 42 No

ADMISSION_TYPE

ADMIN_TYPE_NO Admission Type Number Integer 1 No

ADMIN_TYPE_DESC Admission Type Description Text 25 No

ADMISSION_SOURCE

ADMIN_SRC_NO Admission Source Number Integer 2 No

ADMIN_SRC_DESC Admission Source Description Text 44 No AGE_GROUP

AGE_GRP_NO Age Group Number Integer 2 No

AGE_GRP_DESC Age Group Range Text 11 No

ZIP_CODE_GROUP

ZIP_GRP_NO Zip Code Number Text 7 No

ZIP_GRP_DESC Zip Code Description Text 27 No

SEX

SEX_NO Sex Number Integer 1 No

SEX_DESC Sex Description Text 7 No

DISCHARGE_STATUS

DISCH_NO Discharge Number Integer 2 No

DISCH_DESC Discharge Description Text 44 No

PRINCIPAL_PAYMENT_SOURCE

PRINC_PAY_SRC_NO Principal Payment Source Number Integer 2 No PRINC_PAY_SRC_DESC Principal Payment Source Description Text 22 No DRG

DRG_NO Diagnosis Related Group Number Integer 3 No

MDC_NO Major Diagnostic Category Number Integer 2 No

DRG_DESC Diagnosis Related Group Description Text 65 No DRG_M_S Diagnosis Group Medical or Surgical Text 1 Yes MDC

MDC_NO Major Diagnostic Category Number Integer 2 No

MDC_CAT_NAME Major Diagnostic Category Description Text 40 No

(4)

HSA4

HSA4_NO Home Service Area 4 Number Integer 2 No

HSA4_DESC Home Service Area For Description 16 No

SAME DAY FLAG

SAME_DAY_NO Same Day Number Integer 1 No

SAME_DAY_DESC Discharged the same day or not Text 45 No DRG_GROUPER_VERSION

VERSION_NUM Number of Version Integer 2 No

VERSION_RANGE Date Range of the Version Text No

CCSDX

CCSDX CCS Diagnostic Code Integer 4 No

CCSDX_SING_LVL_LBL CCS Diagnostic Single Level Lablel Text 115 No CCSDXGRP

CCSDX CCS Diagnostic Code Integer 4 No

CCSGRP CCS Diagnostic Group Number Integer 2 No

CCSGRPLBL CCS Diagnostic Group Label Text 50 No

CCSPX

CCSPX CCS Procedure Code Integer 3 No

CCSPX_SING_LVL_LBL CCS Procedure Single Level Label Text 92 No CCSPXGRP

CCSPX CCS Procedure Code Integer 3 No

CCSPXGRP CCS Procedure Group Integer 2 No

CCSPXGRPLBL CCS Procedure Group Label 46 No

ERFLAG

ERFLAG_NO Emergency Room Flag Number Integer 1 No

ERFLAG_DESC ER Flag Description Text 46 No

PATIENT_TYPE

PAT_TYPE_NO Patient Type Number Integer 1 No

PAT_TYPE_DESC Patient Type Description Text 120 No

(5)

DRG_M_S

DRG_M_S Diagnosis Related Group Medical or Surgery Letter Text 1 No DRG_M_S_DESC Diagnosis Related Group Medical or Surgery Description Text 8 No HSA_TOWNS

HSA4_NO Home Service Area 4 Number Integer 2

CTC County Town Code Integer 4

COUNTY County Name Text 10

TOWN_NAME Town Name Text 23