2000 VSD Data Dictionary 

Vaccine Safety Datalink Project 
Table of Contents

2000 VSD Data Dictionary ..................................................................................................................................................

Constant File (Youth and Adult cohorts)...................................................................................................................Enroll File (Youth and Adult cohorts).......................................................................................................................Vaccine File (Youth and Adult cohorts)....................................................................................................................INPT (Inpatient) File (Youth and Adult cohorts) ......................................................................................................OUPPT (Outpatient) File (Youth and Adult [specified dxcodes only - see attached Adultoutptcodes.xls MS ExcHmobirth (HMO Birth) File (Youth cohort) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Mort (Mortality) File (Youth and Adult cohort combined).......................................................................................

Attachments..........................................................................................................................................................................

I - Non-Standard ICD-9 Codes ..................................................................................................................................II - ICD-9 Code Conventions.....................................................................................................................................

Page 2 of 34 2 
Key Variable 

Type 

(Length) Format Label Valid Values 

Y STUDYID C(8) Randomized Recoded to C(8) with numeric values 

Y CDCSITE C(1) Randomized HMO 

Site 

Recoded to C(1) with numeric values: YOUTH: ‘1’ ‘2’ ‘3’ ‘4’ ‘5’ ‘6’ ‘7’ ‘8’ ADULT: ‘1’ ‘2’ ‘3’ 

2000 VSD Data Dictionary 

Vaccine Safety Datalink Project 

TABLE 1: CONSTANT File 

Page 3 of 34 
Key Variable 

Type 

(Length) Format Label Valid Values 

BRTHDATE N(4) mmddyy10. Date of Birth SAS date 

. = Unknown 

SEX C(1) 

‘F’ = Female ‘M’ = Male ‘ ’ = Unknown 

Notes: 

1. STUDYID has been recoded from the original values to a character field with numeric values but remain

2a. The Youth cohort consists of 8 sites 

2b. The Adult cohort consists of 3 sites- people born on or before December 31, 1982, and having at least on

while aged 18 and older. 

2c. For at least one HMO’s, if the actual day of birth is unknown a default value of the first of the month is as

membership database. 

General file description: 

This file has a single record for each VSD study member who has ever been enrolled in the study. Each STUDYshould have at least one ENROLL record. 

Page 4 of 34 4 
2000 VSD Data Dictionary 

Vaccine Safety Datalink Project 

TABLE 2: ENROLL File 

Key Variable 

Type 

(Length) Format Label Valid Values 

Y STUDYID C(8) Randomized Recoded to C(8) with numeric values Y CDCSITE C(1) Randomized HMO 

Site 

Recoded to C(1) with numeric valuesYOUTH: ‘1’ ‘2’ ‘3’ ‘4’ ‘5’ ‘6’ ‘7’ ‘8’ ADULT: ‘1’ ‘2’ ‘3’ 

Page 5 of 34 5 
Key Variable 

Type 

(Length) Format Label Valid Values 

Y STRTDATE N(4) mmddyy10. LLDB Start Date Beginning of study or study enrollme

after beginning of study) - SAS date 

STOPDATE N(4) mmddyy10. LLDB Stop Date Drop date or last day of cycle’s collec

period - SAS Date 

Notes: 1. STUDYID has been recoded from the original values to a character field with numeric values but remains unique 2a. If enrolled in HMO before VSD study began, STRTDATE is HMO’s VSD study start date: 

Youth cohort: GHC & NCK* = 3/1/1991, HAP & NWK = 1/1/1991, SCK = 10/1/1992, and KPC = 1/1/1

*NCK’s child data (age < 7): STRTDATE is the day facility began collecting immunization data. NCK’s adolescent data (aged 7-17): STRTDATE = 4/19/1993. Adult cohort: GHC, NCK, & NWK = 1/1/1995. 

2b. If enrolled (not birth) in HMO after VSD study began, STRTDATE is: 

(1) GHC & HAP - actual enrollment day. (2) KPC - first of the next month. (3) NCK - 3/1/91 - 4/18/1993: 

(a) enrolled before facility was on-line - the day facility began collection immunization data. (b) enrolled after facility was on-line - first date of immunization or well-care visit in VSD stuNCK - 4/19/1993 through present: after two months of contiguous membership, the 15th day of th

(4) NWK - first day of enrollment month. (5) SCK - actual enrollment day. 

2c. If birth in HMO after VSD study began, STRTDATE is: 

(1) GHC - actual enrollment day. If enrollment day<DOB, then STRTDATE=DOB. (2) HAP - if born and enrolled within 60 days in HAP, then STRTDATE=DOB. (3) KPC - STRTDATE=DOB. (4) NCK - 3/1/1991 - 4/18/1993: first date of immunization or visit in on-line VSD study clinic. 

4/19/1993 through present: DOB. If conflicting DOBs exist, the earliest available date of STRTDATE. Note: For some STUDYIDs, this may cause enrollment STRTDATEs to ocDOBs are usually corrected over time. 

(5) NWK - DOB if enrollment day is within 93 days of DOB and mother was HMO eligible. (6) SCK - DOB if enrollment day is within 31 days of DOB. 

3a. If active in HMO at end of cycle’s collection period, STOPDATE is the last day of the cycle (e.g., 2000 [

Page 6 of 34 6 
12/31/2000). 

3b. If transfer (NCK) - date participant has event at a non-VSD study clinic. 3c. If terminated prior to last day of the cycle: 

(1) GHC, HAP, & SCK - actual HMO termination date. (2) NCK - 3/1/1991 - 4/18/1993: last day of termination month. 

4/19/1993- present: after two months of contiguous non-membership, STOPDATE is set tprior to the two-month non-enrollment period. 

(2) KPC & NWK - last day of termination month. 

3d. If aged out of Youth cohort, STOPDATE is: 

(1) All HMOs: day before the eighteenth birthday. 

3e. If deceased, STOPDATE is the definite or approximate date of death. If an approximate date of death is 

more accurate data becomes available. 

General file description: 

This file has a single record for each HMO enrollment episode that a VSD study member has during the study coperiods should not overlap and consecutive enrollment periods should be combined into one enrollment period. ENROLL file should have one record in the CONSTANT file. Note: Data outside a VSD study member’s enroll

considered complete. 

Page 7 of 34 7 
2000 VSD Data Dictionary 

Vaccine Safety Datalink Project 

TABLE 3: VACCINE File 

Key Variable 

Type 

(Length) Format Label Valid Values 

Y STUDYID C(8) Randomized Recoded to C(8) with numeric valueY CDCSITE C(1) Randomized HMO Site Recoded to C(1) with numeric value

YOUTH: ‘1’ ‘2’ ‘3’ ‘4’ ‘5’ ‘6’ ‘7’ ‘8’ ADULT: ‘1’ ‘2’ ‘3’ 

Y VACDATE N(4) mmddyy10. Date of Vaccine 

Administration 

SAS date . = Unknown 

Page 8 of 34 8 
Key Variable 

Type 

(Length) Format Label Valid Values 

Y VAC C(3) Vaccine Administered ‘54' = Adenovirus, type 4 

‘55' = Adenovirus, type 7 ‘82' = Adenovirus, NOS ‘24' = Anthrax ‘19' = BCG (Bacillus Calmette-Gue‘27' = Botulinum antitoxin ‘26' = Cholera ‘29' = CMVIG (cytomegalovirus IGintravenous) ‘56' = Dengue fever ‘12' = Diphtheria antitoxin ‘28' = DT (peds) (diphtheria/tetanus‘20' = DTaP (DTacellP) ‘50' = DTaP-Hib (DTacellP w/Hib) ‘DHB’ = DtaP-HepB (DTacellP w/H‘01' = DTP (diphtheria/tetanus/pertu‘22' = DTP-Hib (DTP w/Hib) ‘102' = DTP-Hib-HepB ‘57' = Hantavirus ‘52' = Hep A, adult ‘83' = Hep A, ped/adol, 2 dose ‘84' = Hep A, ped/adol, 3 dose ‘31' = Hep A, pediatric, NOS ‘85' = Hep A, NOS ‘30' = HBIG (hepatitis B IG) ‘08' = Hep B, adolescent or pediatri‘42' = Hep B, adolescent/high risk i

Key Variable 

Type 

(Length) Format Label Valid Values 

Page 9 of 34 9 
Y VAC (contd) C(3) Vaccine Administered ‘43' = Hep B, adult 

‘44' = Hep B, dialysis ‘45' = Hep B, NOS ‘58' = Hep C ‘59' = Hep E ‘60' = Herpes simplex 2 ‘46' = Hib (PRP-D) ‘47' = Hib (HbOC) ‘48' = Hib (PRP-T) ‘49' = Hib (PRP-OMP) ‘17' = Hib, NOS ‘HBP’ = Hib polysaccharide ‘51' = Hib-Hep B ‘61' = HIV (human immunodeficien‘62' = HPV (human papilloma) ‘86' = IG (intramuscular) ‘87' = IGIV (intravenous) ‘14' = IG, NOS ‘15' = Influenza, split ‘16' = Influenza, whole ‘88' = Influenza, NOS ‘10' = IPV (poliovirus, inactivated) ‘02' = OPV (poliovirus, live, oral) ‘89' = Polio, NOS ‘39' = Japanese encephalitis ‘63' = Junin virus ‘64' = Leishmaniasis ‘65' = Leprosy ‘66' = Lyme disease ‘03' = MMR (measles/mumps/rubel‘94' = MMR-V (MMR with varicell‘04' = M/R (measles/rubella) ‘67' = Malaria 

Key Variable 

Type 

(Length) Format Label Valid Values 

Page 10 of 34 10 
Y VAC (contd) C(3) Vaccine Administered ‘05' = Measles 

‘MM’ = Measles/Mumps ‘RU’ = Measles/Rubeola (Attenuva‘68' = Melanoma ‘32' = Meningococcal ‘103' = Meningococcal C conjugate ‘07' = Mumps ‘69' = Parainfluenza-3 ‘11' = Pertussis ‘23' = Plague ‘33' = Pneumococcal ‘100' = Pneumococcal conjugate vapolyvalent ‘70' = Q fever ‘18' = Rabies, intramuscular injectio‘40' = Rabies, intradermal injction ‘90' = Rabies, NOS ‘72' = Rheumatic fever ‘73' = Rift Valley Fever ‘34' = RIG (rabies IG) ‘74' = Rotavirus ‘71' = RSV-IGIV (respiratory syncyvirus IG, intravenous) ‘93' = RSV-MAb (respiratory syncy virus monoclonal antibody  [palivizumab], intramuscular) ‘06' = Rubella ‘38' = Rubella/Mumps ‘75' = Smallpox ‘76' = Staphylococcus bacterio lysat‘09' = Td (adult) (tetanus/diphtheria‘25' = Typhoid, oral 

Key Variable 

Type 

(Length) Format Label Valid Values 

Page 11 of 34 11 
VAC (contd) C(3) Vaccine Administered ‘35' = Tetanus toxoid 

‘77' = Tick-borne encephalitis ‘13' = tetanus immune globulin ‘78' = Tularemia ‘41' = Typhoid, parenteral ‘53' = Typhoid, parenteral, AKD (U military) ‘101' = Typhoid Vi capsular polysaccharide vaccine  ‘91' = Typhoid, NOS ‘Unn’ = Combination vaccine ‘79' = Vaccinia immune globulin ‘21' = Varicella ‘81' = VEE, inactivated (Venezuelaequine encephalitis, inactivated) ‘80' = VEE, live ‘92' = VEE, NOS ‘36' = VZIG (varicella zoster IG) ‘Xnn’ = NCK experimental, vaccine still blinded ‘Ynn’ = SCK experimental, vaccine still blinded ‘Znn’ = KPC experimental, vaccine still blinded ‘37' = Yellow fever ‘999' = Unknown 

Key Variable 

Type 

(Length) Format Label Valid Values 

Page 12 of 34 12 
FACILITY C(3) Randomized Facility ID 

Code 

Specific facility code where vaccine given ‘U’ = Unavailable (HMO can not prthis variable) ‘ ’ = Unknown 

SITE C(2) Site of Vaccine 

Introduction 

‘IN’ = Intranasal ‘IV’ = Intravenous ‘LA’ = Left arm ‘LD’ = Left deltoid ‘LG’ = Left upper outside quad ‘LL’ = Left lateral thigh ‘LT’ = Left anterior thigh ‘LU’ = Left thigh, unknown positio‘LV’ = Left gluteus ‘PO’ = Oral ‘RA’ = Right arm ‘RD’ = Right deltoid ‘RG’ = Right upper outside quad ‘RL’ = Right lateral thigh ‘RT’ = Right anterior thigh ‘RU’ = Right thigh, unknown positi‘RV’ = Right gluteus ‘UA’ = Unknown arm, left or right ‘UD’ = Unknown deltoid, left or rig‘UT’ = Unknown thigh, left or right ‘U ‘ = Unavailable ‘ ’ = Unknown 

Key Variable 

Type 

(Length) Format Label Valid Values 

Page 13 of 34 13 
MFR C(3) Vaccine Manufacturer ‘LED’ = Lederle 

‘MA ’ = Massachusetts Public HealBiologic Laboratories ‘MBL’ = Massachusetts Biologic  Laboratories (formerly Massachusetts Public Health Biologic Laboratories) ‘MED’ = MedImmune, Inc. ‘MIL’ = Miles ‘MIP’ = Bioport Corporation (formeMichigan Biologic Products Institute) ‘MSD’ = Merck & Co., Inc. ‘NAB’ = NABI (formerly North  American Biologicals, Inc‘VS1' = National Institute/Agency  International Development ‘VS2' = National Institute of Health ‘NYB’ = New York Blood Center ‘NAV’ = North American Vaccine, I‘NOV’ = Novartis Pharmaceutical C‘OTC’ = Organon Teknika Corpora‘ORT’ = Ortho-Clinical Diagnostic  Systems, Inc. (formerly Or Diagnostic Systems, Inc.) ‘PD ’ = Parke-Davis (formerly ParkDavis) ‘PMC’ = Aventis Pasteur Inc. (form

Key Variable 

Type 

(Length) Format Label Valid Values 

Page 14 of 34 14 
MFR (contd) C(3) Vaccine manufacturer 

Pasteur Merieux Connaught; includes Connaught Laboratories and Pasteur Merieux) ‘PRX’ = Praxis Biologics ‘PWJ’ = Powerject Pharmaceutic(includes Celltech Medeva Vaccines and Evans Medical Limited) ‘SCL’ = Sclavo, Inc. ‘VS3' = SmithKline French ‘SI ’ = Swiss Serum and Vaccine I‘SKB’ = GlaxoSmithKline (formerl SmithKline Beecham; incl SmithKline Beecham & G Wellcome) ‘VS4' = UCLA (SCK exp) ‘USA’ = United States Army MedicResearch & Materiel  Command ‘WA ’ = Wyeth-Ayerst ‘WAL’ = Wyeth Ayerst (includes WLederle Vaccines and Pediatrics, Wyeth LaboratLederle Laboratories, & Praxis Biologics) ‘OTH’ = Other ‘ UNK’= Unknown 

LOT C(15) Vaccine Lot Number alphanumerics, left-justified 

no spaces, slashes, or dashes ‘ ’ = Unknown 

Key Variable 

Type 

(Length) Format Label Valid Values 

Page 15 of 34 15 
VACSOURC C(1) Location Where Vaccine 

Was Administered 

‘A’ = Vaccinated at a HMO affiliate  partnership facility 

‘B’ = Vaccinated at HMO before  immunization system automa

clinic ‘I’ = Vaccinated within the HMO ‘O’ = Vaccinated outside the HMO ‘U’ = Unavailable ‘ ’ = Unknown 

Notes: 

1a. Youth cohort: All Youth Studyids’ VACDATEs which fall on or between the VSD Youth Study Start Da

participant’s 18th birthday, or the Cycle’s Stop Date (whichever is earlier) will be submitted. 

Note: Data outside of enrollment intervals should not be considered complete for Youth cohort. 

1b. Adult cohort: All Adult Studyids’ VACDATEs which fall on or between the VSD Adult Study Start Date 

will be submitted, except data prior to the Studyid’s 18th birthday. 

Note: Data outside of enrollment intervals should not be considered complete for Adult cohort. 

2. Health Level 7 (HL7) Standard Code Set CVX -- Vaccines Administered is maintained by the Centers fo

Prevention. For further information on the CVX code set, see http://www.cdc.gov/NIP/Registry/cvx.p

names are in bold. 

3. NOS = not otherwise specified. Avoid using NOS codes except to record historical records that lack the 

cases where charts/automated systems do not capture the indicated specificity. 

4. This vaccine value, ‘Unn’, represents a combination vaccine where the exact vaccine combination is unkn

components are known. For example: ‘U01' would be a combination of D, T and P along with other, unkoccur mostly because of historical and/or non-HMO vaccines with illegible handwriting. 

5. The vaccine values, ‘Xnn’, ‘Ynn’, and ‘Znn’, represent experimental vaccines being tested by NCK, SCK

each unique experimental vaccine, ‘nn’ should be replaced by a unique numeric value (e.g., X01, Y01). 

6. Records with missing VACs should be included. These records should be validated to ensure that the vac

can not be obtained through other avenues. 

7. Health Level 7 (HL7) Standard Code Set MVX – Manufacturers of Vaccines is maintained by the Center

Prevention. For further information on the MVX code set, see http://www.cdc.gov/NIP/Registry/mvx.p

codes that have been through mergers, etc., are in italics. New manufacturer codes and names are in bold

8. The MFR variable should be coded with the HL7 MVX value who manufactured the vaccine. For examp

prior to Praxis Biologics merger with Wyeth-Ayerst, should be coded as ‘PRX’. 

9. If combination vaccine, enter the container’s lot number. 

Page 16 of 34 16 
10. Format LOT variable as follows: alphanumerics, left-justified with no spaces, slashes, or dashes between 

or dose-unit information attached (e.g., EJN123). 

General file description: 

This file contains a single record for each vaccine administered during the study collection period. Records with included if documentation exists that a vaccine was administered on a specific date, but the vaccine administered 

STUDYID in the VACCINE file should have one record in the CONSTANT file and one or more records in the outside of enrollment intervals should not be considered complete. 

Page 17 of 34 17 
2000 VSD Data Dictionary 

Vaccine Safety Datalink Project 

TABLE 4: INPT (Inpatient) File 

Key Variable 

Type 

(Length) Format Label Valid Values 

Y STUDYID C(8) Randomized Recoded to C(8) with numeric values Y CDCSITE C(1) Randomized HMO 

Site 

Recoded to C(1) with numeric valuesYOUTH: ‘1’ ‘2’ ‘3’ ‘4’ ‘5’ ‘6’ ‘7’ ‘8’ ADULT: ‘1’ ‘2’ ‘3’ 

Page 18 of 34 18 
Key Variable 

Type 

(Length) Format Label Valid Values 

Y CAREDATE N(4) mmddyy10. Date of Admission SAS date 

. = Unknown 

DURATION N(3) Length of Stay NN = Length of stay 

.U = Unavailable . = Unknown 

Y DXCODE C(6) ICD-9 Code ICD-9 code (No decimal) 

‘ ’ = Unknown 

Y DXTYPE C(2) Setting ‘BP’ = Birth hosp primary DX 

‘BS’ = Birth hosp secondary DX 

‘BN’ = Birth hosp, DX designation N‘HP’ = Hosp primary DX ‘HS’ = Hosp secondary DX ‘HN’ = Hosp, DX designation N/A ‘ ’ = Unknown 

Y FACILITY C(3) Randomized Facility 

ID Code 

Specific facility code where outcome occurred ‘N’ = Not applicable ‘U’ = Unavailable (HMO can not prothis 

variable) ‘ ’ = Unknown 

Page 19 of 34 19 
Key Variable 

Type 

(Length) Format Label Valid Values 

Y LOCATION C(1) In/Outside HMO ‘A’= HMO affiliated or partnership f

‘I’ = Inside HMO ‘O’= Outside HMO ‘R’= Referral ‘U’= Unavailable ‘ ’= Unknown 

Notes: 

1a. Youth cohort: All Youth Studyids’ CAREDATEs which fall on or between the VSD Youth St

day prior to a participant’s 18th birthday, or the Cycle’s Stop Date (whichever is earlier) will be 

hospital history (formerly a stand alone file, HOSPDXHX, for GHC, NCK, NWK and SCK) w(INPATIENT) file and extend back to 1/1/1984 for GHC, NCK, and NWK, 6/1/1984 for SCK, 1/1/1990 for HAP. 

Note: Data outside of enrollment intervals should not be considered complete for Youth 

1b. Adult cohort: All Adult Studyids’ CAREDATEs which fall on or between the VSD Adult Stud

Stop Date will be submitted. Adult cohort hospital history (formerly a stand alone file, HOSPDNWK) will be appended to the INPT (INPATIENT) file and extend back to 1/1/1990 for GHC, 

Note: Data outside of enrollment intervals should not be considered complete for Adul

2. DURATION = Hospital discharge date - admission date. DURATION will be zero for hospita

admission and discharge date. 

3a. Codes should be left justified and not contain decimals. Codes below 100.nnn should have lead

Code Convention’ attachment. 

3b. Records with missing DXCODEs should be included. These records should be validated to ens

indeed missing and can not be obtained through other avenues. 

3c. 

 Marshfield Clinic data included ICD9 "procedure" codes along with the ICD9 diagnosis codes. 

should not be included in the data submission. ICD9 procedure codes are 2 digit codes (before 16.84 or 08.4) specifying procedures and were intended to be used by hospitals. Marshfield addprocedure codes. Hence, the code “07889” as it appears in the VSD Cycle Data File may actuaICD9 diagnosis code 078.89 or incorrectly the ICD9 procedure code 78.89. This problem shouanalyzing Marshfield Cycle 2000 Data Files using DXCODEs below 100.nnn. 

4a. DXTYPE = 'BP' should be assigned when the DXCODE has the first three digits of V30 - V39

Associated records for the same admission would use ‘BS’. If the infant was readmitted/exami

Page 20 of 34 20 
or on a different day, then that re-admittance/examination should be coded differently; probably 

to the actual setting. 

4b. If Birth hospitalization or Hospitalization, and a distinction between primary/secondary diagno

‘BN’ or ‘HN’, respectively. 

5. The Adult cohort contains only HP, HS, and HN DXTYPEs. 

General file description: 

This file contains a single record for each diagnosis assigned during a hospitalization during the study collection missing DXCODEs should be included if documentation exists that an INPT encounter occurred on a specific da

missing. Hospital history prior to the study collection period is also included. If a VSD study member has two ooccurring on the same day for the same dxcode, but occurring in different facilities or for different durations, eacsubmitted. Excluded (rule-out) diagnoses should not be included in this file. Each STUDYID in the INPT file s

CONSTANT file and one or more records in the ENROLL file. Note: Data outside of enrollment intervals shoulcomplete. 

Page 21 of 34 21 
2000 VSD Data Dictionary 

Vaccine Safety Datalink Project

 TABLE 5: OUTPT (Outpatient) File 

Key Variable 

Type 

(Length) Format Label Valid Values 

Y STUDYID C(8) Randomized Recoded to C(8) with numeric values Y CDCSITE C(1) Randomized HMO 

Site 

Recoded to C(1) with numeric values: YOUTH: ‘1’ ‘2’ ‘3’ ‘4’ ‘5’ ‘6’ ‘7’ ‘8’ ADULT: ‘1’ ‘2’ ‘3’ 

Page 22 of 34 22 
Key Variable 

Type 

(Length) Format Label Valid Values 

Y CAREDATE N(4) mmddyy10. Date of Visit SAS date 

. = Unknown 

Y DEPT C(3) Department See Attachment VI for coding Y DXCODE C(6) ICD-9 Code ICD-9 code (No decimal) 

‘ ’ = Unknown 

Y DXTYPE C(2) Setting ‘CP’ = Clinic visit primary DX 

‘CS’ = Clinic visit secondary DX ‘CF’ = Clinic follow-up visit DX ‘CN’ = Clinic visit, DX designation N‘EP’ = Emergency room primary DX ‘ES’ = Emergency room secondary DX ‘EF’ = Emergency room follow-up vis‘EN’ = Emergency room, DX designa‘UP’ = Urgent care visit primary DX ‘US’ = Urgent care visit secondary DX ‘UF’ = Urgent care follow-up visit DX ‘UN’ = Urgent care visit, DX designat‘ ’ = Unknown 

Page 23 of 34 23 
Key Variable 

Type 

(Length) Format Label Valid Values 

Y FACILITY C(3) Randomized Facility Specific facility code where outcome o

ID Code ‘N’ = Not applicable 

‘U’ = Unavailable (HMO can not provariable) ‘ ’ = Unknown 

Y LOCATION C(1) In/Outside HMO ‘A’ = HMO affiliated or partnership fa

‘I’ = Inside HMO ‘O’ = Outside HMO ‘R’ = Referral ‘U’ = Unavailable ‘ ’ = Unknown 

RULEOUT C(1) Rule-out DX ‘R’ = Rule-out code 

‘ ’ = No rule-out code assigned ‘U’ = Unavailable 

Notes: 

1a. The OUTPT file is submitted for the Youth and Adult cohorts; however, for the Adult cohort it is limited 

Autoimmune Disease, Chickenpox (052.*) and Herpes Zoster (053.*) ICD-9-CM codes. (See Adult Outp

1b. Youth cohort: All Youth Studyids’ CAREDATEs which fall on or between the VSD Youth Study Start D

a participant’s 18th birthday, or the Cycle’s Stop Date (whichever is earlier) will be submitted. 

Note: Data outside of enrollment intervals should not be considered complete for Youth cohort. 

1c. Adult cohort: All Adult Studyids’ CAREDATEs which fall on or between the VSD Adult Study Start D

Date, and have the pre-specified ICD-9-CM codes, will be submitted. Note: Data outside of enrollment intervals should not be considered complete for Adult cohort. 

2a. Codes should be left justified and not contain decimals. Codes below 100.nnn should have leading zeroes

Convention’ attachment. 

2b. Marshfield Clinic data included ICD9 "procedure" codes along with the ICD9 diagnosis codes. ICD( "pro

included in the data submission. ICD9 procedure codes are 2 digit codes (before the decimal place such aprocedures and were intended to be used by hospitals. Marshfield added a leading zero to the procedure c“07889” as it appears in the VSD Cycle Data File may actually correctly represent the ICD9 diagnosis co

Page 24 of 34 24 
ICD9 procedure code 78.89. This problem should be considered when analyzing Marshfield Cycle 2000 D

below 100.nnn. 

3a. If ER, Urgent Care, or Clinic ‘follow-up’ visit diagnoses, code ‘EF’, ‘UF’, or ‘CF’, respectively. This co

occurrences of follow-up visits, but will be utilized when possible. 

3b. If Emergency Room, Urgent Care, or Clinic visit and a distinction between primary/secondary diagnoses 

‘UN’, or ‘CN’, respectively. 

4. Rule-out codes are used with ER, Urgent Care visits, and/or Clinic visits only. Rule-out indicates that the 

investigation and the investigation is being done to ‘rule-out’ the ICD-9 diagnoses code. 

General file description: 

Youth: This file contains a single record for each diagnosis assigned during an emergency room, urgent care, or collection period. If a VSD study member has two or more visits occurring on the same day for the same dxcode

facilities or departments, each record should be submitted. Each STUDYID in the OUTPT file should have one file and one or more records in the ENROLL file. Note: Data outside of enrollment intervals should not be consiAdult: This file contains a single record for pre-specified high-risk influenza, autoimmune disease, herpes zosterassigned during an emergency room, urgent care, or clinic visit during the study collection period. If a VSD studvisits occurring on the same day for the same dxcode, but occurring in different facilities or departments, each reEach STUDYID in the OUTPT file should have one record in the CONSTANT file and one or more records in thoutside of enrollment intervals should not be considered complete. 

Page 25 of 34 25 
2000 VSD Data Dictionary 

Vaccine Safety Datalink Project 

TABLE 6: HMOBIRTH File 

Key Variable 

Type 

(Length) Format Label Valid Values 

Y STUDYID C(8) Randomized Recoded to C(8) with numeric values Y CDCSITE C(1) Randomized HMO 

Site 

Recoded to C(1) with numeric values: YOUTH: 

‘1’ ‘2’ ‘3’ ‘4’ ‘5’ ‘6’ ‘7’ ‘8’ ADULT: ‘1’ ‘2’ ‘3’ 

MOMID C(8) Randomized Mother’s 

VSD ID Number 

Recoded to C98) with numeric 

Page 26 of 34 26 
Key Variable 

Type 

(Length) Format Label Valid Values 

FACILITY C(3) Facility ID Code Specific facility code where birth occurre

‘U’ = Unavailable (HMO can not providvariable) ‘ ’ = Unknown 

GESTAGE N(3) Gestational Age NN = Gestational Age in Weeks 

.U = Unavailable (HMO can not provide variable) . = Unknown 

CHLDWGHT N(4) Child’s Birth Weight NNNN = Birth Weight in grams 

.U = Unavailable (HMO can not provide variable) . = Unknown 

APGAR1 C(2) One Min Apgar ‘00' - ‘10' = 1 minute APGAR score 

‘U’ = Unavailable (HMO can not provide variable) ‘ ’ = Unknown 

APGAR5 C(2) Five Min Apgar ‘00' - ‘10' = 5 minute APGAR score 

‘U’ = Unavailable (HMO can not provide variable) ‘ ’ = Unknown 

WHITE C(1) ‘1' = White BLACK C(1) ‘1' = Black ASIAN C(1) ‘1' = Asian HAWAIIAN C(1) Hawaiian or Other 

Pacific Islander 

‘1' = Hawaiian or Other Pacific Islander 

Page 27 of 34 27 
Key Variable 

Type 

(Length) Format Label Valid Values 

NATAMER C(1) Native American or 

Aleutian 

‘1' = Native American or Aleutian 

OTHER C(1) Other Race ‘1' = Other Race HISPANIC C(1) ‘1' = Hispanic CHLDSTE C(2) Randomized Child’s 

Birth State 

Child’s birth state FIPS code ‘U’ = Unavailable (HMO can not provide variable) ‘ ’ = Unknown 

CHLDCNTY C(3) Randomized Child’s 

Birth County 

Child’s birth county FIPS code ‘U’ = Unavailable (HMO can not provide variable) ‘ ’ = Unknown 

M_DOB N(4) mmddyy10. Mother’s Date of Birth SAS date 

.U = Unavailable (HMO can not provide variable) . = Unknown 

Notes: 

1. STUDYID has been recoded from the original values to a character field with numeric values but remain

participants. 

2. This file consists of infants born in HMO’s hospitals or contract facilities and are members of the VSD st

are born on or after HMO’s VSD study start date are included (GHC & NCK = 3/1/1991, HAP = 1/1/1991/1/1991 and SCK = 10/1/1992). HMOs which match to state birth certificate files may have data on infastudy start date as well as those born outside their HMO’s hospitals or contract facilities. 

3. For those HMOs who participate in the Adult cohort (GHC, NCK, and NWK), the birth mother’s STUDY4. Complete each race/ethnicity category that applies. 

Page 28 of 34 28 
General file description: 

This file contains a single record for each Youth cohort member born in HMOs’ hospitals or contract hospitals dperiod. For sites choosing to match to their respective state birth certificate files, data on infants born in non-HM

study collection period, may also be included. Each STUDYID in the HMOBIRTH file should have one record 

one or more records in the ENROLL file. 

Page 29 of 34 29 
2000 VSD Data Dictionary 

Vaccine Safety Datalink Project 

TABLE 7: MORT (Mortality) File 

Key Variable 

Type 

(Length) Format Label Valid Values 

Y STUDYID C(8) Randomized Recoded to C(8) with numeric values Y CDCSITE C(1) Randomized HMO 

Site 

Recoded to C(1) with numeric values: 

YOUTH: ‘1’ ‘2’ ‘3’ ‘4’ ‘5’ ‘6’ ‘7’ ‘8’ ADULT: ‘1’ ‘2’ ‘3’ 

DXCODE C(6) Underlying Cause of 

Death 

ICD-10 (No decimal) ‘ ’ = Unknown 

Page 30 of 34 30 
Key Variable 

Type 

(Length) Format Label Valid Values 

DTHDATE N(4) mmddyy10. Date of Death SAS date 

. = Unknown 

APPROX C(1) Approximate Death 

Date 

‘Y’ = Yes ‘N’ = No ‘ ’ = Unknown 

Notes: 

1. All known deaths should be submitted, regardless of date or age (i.e., even if they are after the STUDYID

Cycle’s Stop Date). Ensure that the STUDYID also appears in either the Youth or Adult cohort’s CONSfiles; if not, please update these files accordingly. 

2a. Codes should be left justified and not contain decimals. Codes below 100.nnn should have leading zeroe2b. Records with missing DXCODEs should be included. These records should be updated as the informatio2c. The source of the underlying cause of death (DXCODE) will be the state death file; otherwise it will be le

DXCODEs will be updated as more accurate data becomes available. ICD-10 was implemented in the Uof 01/01/1999. 

3. Indicates whether death date is definite death date or approximate. Approximate death dates will be upda

becomes available. 

General file description: 

This file contains a single record for each known death among VSD youth and adult cohort members. If known, study collection period or after a VSD cohort members ages out, are also included. Each STUDYID in the MOR

record in the youth and/or adult CONSTANT file and one or more records in the respective cohort(s) ENROLL f

Page 31 of 34 31 
 

 

 

 

 

 

Attachment I
 

Non-Standard ICD-9 Codes
 

Vaccine Safety Datalink Project 

ICD-9 Codes Definition 

780.3F Febrile Seizure 

X00002 Post Surgical Complications 

X00003 MRI 

X00005 HEP Lock, IV Medication, PIC Line 

X00006 Transfusion 

X00007 Hickman Cath. 

X00008 CT Pre-OP 

X00009 EEG 

X00010 Renal Scan 

X00014 Swelling 

X00015 Incision Drainage 

X00016 Other Continued Treatment 

X00017 Other Pre-OP 

X00018 Cardiac Monitoring 

X00019 Deceased 

X00098 Diagnosis Not Clear 

Page 32 of 34 

Revised: November 14, 2003 V2 

32 
 

 

 

 

Attachment II
 

ICD-9 Code Conventions
 

Vaccine Safety Datalink Project 

The VSD study uses ICD-9 codes to represent diagnoses assigned to children during different health care 

encounters. There are different methods of assigning these codes but the following conventions should be used 

when submitting ICD-9 coded data to CDC. 

1.	 Variable type and length. The ICD-9 variable should be a character variable with a length of 

six (6). 

2.	 First letter. The first character should one of the following: 

A.	 One of the digits 0-9 followed by another digit (0-9) 

B.	 The letter ‘V’ followed by a digit (0-8) 

C.	 The letter ‘E’ followed by a digit (8 or 9) 

D.	 The letter ‘M’ followed by a digit (8 or 9) 

At times, HMOs may have local codes to depict special conditions, e.g., X123. Any use of these codes 

should have accompanying written documentation explaining what these codes are (included in 

Attachment I). 

3.	 Decimals. The decimal in numeric and V codes should not be included as part of the code. 

It is implied that the decimal will occur after the following places: 

A.	 Numeric codes -- after the 3rd digit 

B.	 ‘V’ codes -- after the 3rd character (V plus two digits, then decimal) 

C.	 ‘E’ codes -- after the 4th character (E plus three digits, then decimal) 

D.	 ‘M’ codes -- uses a slash after the 5th character (M plus four digits then slash followed 

by a digit representing the behavior) 

4.	 Alignment. All codes are to be left justified. 

5.	 Leading zeroes. Leading zeroes are added to numeric ICD-9 codes so that the implied 

decimal would appear after the third position. 

A.	 Numeric codes that are less than 100. should have one or two leading zeroes added before the 

first digit so the decimal would occur after the third digit.

 1) 123.1 will have no zeroes added => ‘1231'

 2) 23.5 will have one zero added => ‘0235'

 3) 3.5 will have two zeroes added => ‘0035' 

B.	 No leading zeroes are added to ‘V’, ‘E’ or ‘M’ codes. 

Note: Because E codes use three digits after the leading E, the implied decimal will appear one 

position to the right of the implied decimal of numeric and V codes. 

Page 33 of 34 33 

Revised: November 14, 2003 V2 
 

 

6. Trailing zeroes. Trailing zeroes should not be added after the implied decimal unless they 

are part of the code. 

Example: 234. => ‘234' and not ‘2340' or ‘23400' 

7.	 Non-standard ICD-9 codes. Any code that is not found in the ICD-9 code book should be 

explained in writing anytime they are used. These usually take one of two forms: 

A. Trailing codes used to explain a code, e.g., F added at the end of a seizure code to 

indicate that it is febrile; and 

B.	 Local codes that are adopted by individual HMOs (included in Attachment I). 

Page 34 of 34 34 

Revised: November 14, 2003 V2