HOPS Data Dictionary - Attach 4.pdf

Attachment 4

Data Variables transmitted to CDC

PATIENT DEMOGRAPHICS - PTDTL

Name Type Size Description

ACTIVDT1 Date 8 First active date

ACTIVDT2 Date 8 Second active date

ACTIVDT3 Date 8 Third active date

ADEFDX Text 6 AIDS defining dx

AIDSDATE Date 8 AIDS dx date

BRK_IN_CARE Numeric 8 Break in care (days)

CONSENTDT Date 8 date of consent

CONSENTED Text 1 consent signed,y/n

DIAGLOC Text 6 HIV diagnosis location

DRUGR Text 6 PT_DRUGRTE

ETHNIC Text 6 Ethnicity (ETH)

FVISIT Date 8 First office visit

HISTOBSDT Date 8 start of complete historical observation

HIVDATE Date 8 Date of HIV dx

HRNID Text 9 Patient id

HRNID_ORIG Text 9 Patient identifier at original site

INACTIVDT1 Date 8 First inactive date

INACTIVDT2 Date 8 Second inactive date

INACTIVDT3 Date 8 Third inactive date

LCONTACT Date 8 Last contact with MD

LOWWGT Numeric 8 Lowest adult weight

LVISIT Date 8 Last office or hosp visit

NBIRTHS Numeric 8 Number of births

NPREG Numeric 8 Number of pregnancies

OPT_AR1 Date 8 Pre-QA date of first ARV use

OPTPAYT2 Text 6 Pre-QA secondary payer

OPTPAYTY Text 6 Pre-QA primary payer

PPAYFLAG Numeric 8 Change made to pt_payty

PRIMARYCARE Text 1 Pt receives primary care at this site

PT_AIDS1 Date 8 Pre-QA AIDS diagnosis date

PT_AIDSD Text 6 Pre-QA AIDS defining dx code(DXC)

PT_ALCOH Text 10 Alcohol use(at time of entry)

PT_AR1 Date 8 Date of first AR use

PT_CIGPD Text 8 Cigarettes per day

PT_DOB Date 8 Patient date of birth,mm/dd/yy

PT_DRINK Text 6 Number of drinks per week (code DRK)

PT_DRUGR Text 1 Route of illicit drug use( code RTE)

PT_EDUC Text 6 Education level(code EDU)

PT_EMPST Text 6 Employment status(code EMS)

PT_HGTNO Numeric 8 normal height (in inches)

PT_HIVDX Date 8 Pre-QA HIV diagnosis date

PT_PAYN2 Text 50 Payer name,secondary

PT_PAYNA Text 50 Payer name,primary

PT_PAYT2 Text 6 Secondary payer type (code PAY)

PT_PAYTY Text 6 Payment type(code PAY)

PT_RACE Text 6 Patient race (code RAC)

PT_RISK1 Text 6 Primary risk behaviors (code=RSK)

PT_RISK2 Text 6 Secondary risk behaviors (code=RSK)

PT_SEX Text 1 Patient sex at birth

PT_STATC Text 6 Patient status (code PTS)

PT_STATD Date 8 Date patient status changed,mm/dd/yy

PT_WGTNO Numeric 8 Patient normal weight(lbs)

PT_YRSQU Numeric 8 Number of years since quitting smoking

PT_YRSSM Numeric 8 Number of years smoked

RACE Text 18 Summary race variable including ethnicity

RETURNDT Date 8 Date patient returned to active status

RSN_NO_AR Text 48 Reason for no first ARV dt

SEXCURR Text 1 Current gender

SITEID Text 4 Clinic identifier

SMOKEHX Text 10 Smoking history

SUBABUSE Text 10 History of substance abuse

VXB4BRK Date 8 Last visit before break in care

DIAGNOSIS DETAIL – DXDTL_A

Name Type Size Description

DX_CODE Text 6 Diagnosis code(DXC)

DX_EDATE Date 8 Diagnosis end date,mm/dd/yy

DX_HOSP Text 1 Patient hospitalized,y/n/u

DX_OTHDE Text 50 Description for other diagnosis

DX_PRE_V Text 3 Diagnosis,presumptive or verified,y/v/u

DX_SDATE Date 8 Diagnosis start date,mm/dd/yy

HRNID Text 9 Patient id

HRNID_ORIG Text 9 Patient identifier at original site

ODX_CODE Text 6 Pre-QA Diagnosis code

ODXEDATE Date 8 Pre-QA diagnosis end date

ODXSDATE Date 8 Pre-QA diagnosis start date

SITEID Text 4 Clinic identifier

TREATMENT DETAIL – TXDTL_B

ADHERENCE Text 32 Adherence to drug

ALLDOSE Text 134 Treatment dosage(uppercase)

ALLDOSE2 Text 58 Treatment dosage (after QA)

BLIND_PLACEBO Text 1 Drug in blinded or placebo trial

DOSES_MISSED Text 15 Doses missed

DXCODE1 Text 6 Reason for taking drug 1

DXCODE2 Text 6 Reason for taking drug 2

DXCODE3 Text 6 Reason for taking drug 3

DXOTHDE1 Text 50 Further detail for reason #1

DXOTHDE2 Text 50 Further detail for reason #2

DXOTHDE3 Text 50 Further detail for reason #3

HRNID Text 9 Patient id

HRNID_ORIG Text 9 Patient identifier at original site

IMPUTEND Date 8 Imputed end date when open (lvisit+90)

MISSDOSE_TIME Text 15 Timeframe for missed doses

OTX_CODE Text 6 Pre-QA trt code for other trt (chged in QA)

OTXEDATE Date 8 Pre-QA trt end date (chged in QA)

QADDOSE Numeric 4 Calculated daily dose after QA

QASIG1 Text 20 Dose quantity (after QA)

QASIG2 Text 20 Dose frequency (after QA)

QASIG3 Text 20 Additional dose instructions

QASTRNG Numeric 4 Dose strength(after QA)

QAUNITS Text 30 Dose units (after QA)

QTYOTH Text 35 Description of sig1 not coded

SITEID Text 4 Clinic identifier

T02FLAG Text 12 T02FLAG

TRIAL Numeric 3 Clinical trial trt(1=y)

TX_CODE Text 6 Treatment code(TXC)

TX_DISC1 Text 6 Reason 2 for discontinuing trt(TXS)

TX_DISC2 Text 6 Reason 3 for discontinuing trt(TXS)

TX_DISC3 Text 6 Reason 4 for discontinuing trt(TXS)

TX_DISC4 Text 6 Reason 5 for discontinuing trt(TXS)

TX_DISCN Text 6 Reason 1 for discontinuing trt(TXS)

TX_EDATE Date 8 Treatment end date,mm/dd/yy

TX_FORM Text 6 Form of trt(code TFM)

TX_OTHDE Text 50 Other description of trt

TX_ROUTE Text 6 Route of administration(code TRT)

TX_SDATE Date 8 Treatment start date,mm/dd/yy

TX_SIG1 Text 6 Dose quantity (pre QA)

TX_SIG2 Text 6 Dose frequency (pre QA)

TX_SIG3 Text 100 Additional dose instructions

TX_STRNG Numeric 8 Dose strength(pre QA)

TX_UNITS Text 6 Dose units (pre QA)

UNITSOTH Text 35 Other description of units

DIAGNOSIS/TREATMENT LINK - DXTX_B

DX_CODE Text 6 Diagnosis code(DXC)

HRNID Text 9 Patient id

HRNID_ORIG Text 9 Patient identifier at original site

SITEID Text 4 Clinic identifier

TX_CODE Text 6 Treatment code(TXC)

TX_SDATE Date 8 Treatment start date,mm/dd/yy

CLINICAL TRIAL MEDICATION DETAIL – TRIALMEDS

ADHERENCE Text 32 Adherence to drug ALLDOSE Text 134 Treatment dosage(uppercase) ALLDOSE2 Text 58 Treatment dosage (after QA) BLIND_PLACEBO Text 1 Drug in blinded or placebo trial DOSES_MISSED Text 15 Doses missed DRUGTYPE Text 3 Drug type DXCODE1 Text 6 Reason for taking drug 1 DXCODE2 Text 6 Reason for taking drug 2 DXCODE3 Text 6 Reason for taking drug 3 DXOTHDE1 Text 50 Further detail for reason #1 DXOTHDE2 Text 50 Further detail for reason #2 DXOTHDE3 Text 50 Further detail for reason #3 HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site MISSDOSE_TIME Text 15 Timeframe for missed doses OTX_CODE Text 6 Pre-QA trt code for other trt (chged in QA) OTXEDATE Date 8 Pre-QA trt end date (chged in QA) PT_STATC Text 6 PT_STATC QADDOSE Numeric 4 Calculated daily dose after QA QASIG1 Text 20 Dose quantity (after QA) QASIG2 Text 20 Dose frequency (after QA)

QASIG3 Text 20 Additional dose instructions QASTRNG Numeric 4 Dose strength(after QA) QAUNITS Text 30 Dose units (after QA) QTYOTH Text 35 Description of sig1 not coded SITEID Text 4 Clinic identifier T02FLAG Text 12 T02FLAG TRIAL Numeric 3 Clinical trial trt(1=y) TX_CODE Text 6 Treatment code(TXC) TX_DISC1 Text 6 Reason 2 for discontinuing trt(TXS) TX_DISC2 Text 6 Reason 3 for discontinuing trt(TXS) TX_DISC3 Text 6 Reason 4 for discontinuing trt(TXS) TX_DISC4 Text 6 Reason 5 for discontinuing trt(TXS) TX_DISCN Text 6 Reason 1 for discontinuing trt(TXS) TX_EDATE Date 8 Treatment end date,mm/dd/yy TX_FORM Text 6 Form of trt(code TFM) TX_OTHDE Text 50 Other description of trt TX_ROUTE Text 6 Route of administration(code TRT) TX_SDATE Date 8 Treatment start date,mm/dd/yy TX_SIG1 Text 6 Dose quantity (pre QA) TX_SIG2 Text 6 Dose frequency (pre QA) TX_SIG3 Text 100 Additional dose instructions TX_STRNG Numeric 8 Dose strength(pre QA)

TX_UNITS Text 6 Dose units (pre QA)

UNITSOTH Text 35 Other description of units

PAST MEDICATION DETAIL – PASTMEDS

HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site SITEID Text 4 Clinic identifier TX_CODE Text 6 Treatment code(TXC) TX_EDATE Date 8 Treatment end date mm/dd/yy TX_OTHDE Text 50 Other description of trt

PROPHYLAXIS DETAIL – PX

DOSE Text 35 Prophylaxis dose HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site PX_CODE Text 6 Prophlaxis code (TXC) PX_DISCN Text 6 Reason for discontinuing px PX_EDATE Date 8 Date px ended,mm/dd/yyyy PX_EXPDT Date 8 Px expiration date PX_OTHDE Text 50 Other px description PX_SDATE Date 8 Px start date,mm/dd/yyyy PX_TYPE Text 7 Px type: drug or vaccine

SEQ_BOOSTER Text 30 Sequence or booster of px SITEID Text 4 Clinic identifier TARGETDX1 Text 6 1st target DX for prophylaxis TARGETDX2 Text 6 2nd target DX for prophylaxis TARGETDX3 Text 6 3rd target DX for prophylaxis TARGETOTH Text 40 target DX for px, description

ANTIRETROVIRAL REGIMEN DETAIL (COMBINATION DRUGS AS IS) – ARREG

ANYTOX Numeric 4 One or more ARs ended due to toxicity ARCLASS Text 50 Regimen by ARV Class CCR Numeric 3 Total CCR5 inhibitors used EI Numeric 3 Total entry inhibitors used ENH Numeric 3 Total enhancers used ENREG Date 8 End date of regimen FI Numeric 3 Total fusion inhibitors used HAART Numeric 8 HAART regimen HRNID Text 9 Patient id INT Numeric 3 Total integrase inhibitors used NARTI Numeric 3 Total NRTIs used NNRTI Numeric 3 Total NNRTIs used OTHER Numeric 3 Oth/unknown class of AR PI Numeric 3 Total PIs used REG Text 200 AR regimen (text desc) REGIMEN Text 74 AR regimen (trt matrix) REGNO Numeric 8 Regimen sequence (line of therapy) SITEID Text 9 Clinic identifier STREG Date 8 Start date of regimen SUMAR Numeric 8 Number of ARVs in regimen TRIAL Numeric 3 All/part of regimen incl in clin trial TRTFAIL Numeric 4 One of more ARs ended due to trt failure

ANTIRETROVIRAL REGIMEN DETAIL (COMBINATION DRUGS SPLIT INTO

COMPONENT DRUGS) – ARREGV2

Name Type Size Description

ANYTOX Numeric 4 One or more ARs ended due to toxicity ARCLASS Text 50 Regimen by ARV Class CCR Numeric 3 Total CCR5 inhibitors used EI Numeric 3 Total entry inhibitors used ENH Numeric 3 Total enhancers used ENREG Date 8 End of regimen FI Numeric 3 Total fusion inhibitors used HAART Numeric 8 HAART regimen HRNID Text 9 Patient id INT Numeric 3 Total integrase inhibitors used NARTI Numeric 3 Total NRTIs used

NNRTI Numeric 3 Total NNRTIs used OTHER Numeric 3 Oth/unknown class of AR PI Numeric 3 Total PIs used REG Text 200 arregv2 regimen (reg desc) REGIMEN Text 74 ar regimen (reg matrix) REGNO Numeric 8 regimen sequence (line of therapy) SITEID Text 9 Clinic identifier STREG Date 8 start date of regimen SUMAR Numeric 8 Number of ARVs in regimen TRIAL Numeric 3 All/part of regimen incl in clin trial TRTFAIL Numeric 4 One of more ARs ended due to trt failure

LAB RESULTS - LRDTL

C4_CODE Text 10 Lab template name

GFR Numeric 8 Glomerular Filtration Rate (MDRD calculation) HRNID Text 9 Patient id

HRNID_ORIG Text 9 Patient identifier at original site

LC_CODE Text 6 Lab result code (LXC)

LR_COMM Text 50 Lab comment

LR_HIGHV Numeric 8 High normal value (lab specific)

LR_LOWVA Numeric 8 Low normal value (lab specific)

LR_RESUL Numeric 8 Lab result

LR_RESUL_CHAR Text 11 Lab result, text format

LR_UNITS Text 8 Lab result units

OR_ODATE Date 8 Order date,mm/dd/yy

CD4 LAB DETAIL – ALLCD4

CD4 Numeric 4 CD4 count CD4DATE Date 8 CD4 count date,mm/dd/yy CD4PCT Numeric 4 CD4 % HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site LR_UNITS Text 8 Lab result units

CD8 LAB DETAIL – ALLCD8

CD8 Numeric 4 CD8 count CD8DATE Date 8 CD8 count date,mm/dd/yy

CD8PCT Numeric 4 CD8 % HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site LR_UNITS Text 8 Lab result units

HIV VIRAL LOAD LAB DETAIL – ALLVB

HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site LOWLIM Numeric 8 Lower limit for VB detection SITEID Text 4 Clinic identifier VBDATE Date 8 Viral burden test date VBTEST Text 10 Viral burden test performed VLOAD Numeric 4 Viral burden (1=undetectable)

ANION DETAIL – ANION

ANION Numeric 8 anion gap BICARB Numeric 8 bicarbonate CHLOR Numeric 8 chloride HRNID Text 9 Patient id OR_ODATE Date 8 Order date,mm/dd/yy SITEID Text 9 Clinic identifier SODIUM Numeric 8 serum sodium

GENOTYPE DETAIL – GENOTYPE

ABC Text 2 Abacavir Resistance ADEQUATE_SPECIMEN Text 1 Whether specimen adequate APV Text 2 APV Resistance ATV Text 2 ATV Resistance CLADES Text 6 Clades Other Than B COMMENT Text 25 Comment D4T Text 2 D4T Resistance DDC Text 2 ddC Resistance DDI Text 2 ddi Resistance DLV Text 2 Delavirdine Resistance DRV Text 2 DRV Resistance DTG Text 2 DTG Resistance EFV Text 2 Efavirenz Resistance ETR Text 2 Etravirine Resistance FAPV Text 2 FOS-APV Resistance FI102S Text 6 Mutation, Site 102, FI FI115S Text 6 Mutation, Site 115, FI

FI116S Text 6 Mutation, Site 116, FI FI11S Text 6 Mutation, Site 11, FI FI122S Text 6 Mutation, Site 122, FI FI126S Text 6 Mutation, Site 126, FI FI130S Text 6 Mutation, Site 130, FI FI133S Text 6 Mutation, Site 133, FI FI136S Text 6 Mutation, Site 136, FI FI138S Text 6 Mutation, Site 138, FI FI143S Text 6 Mutation, Site 143, FI FI148S Text 6 Mutation, Site 148, FI FI155S Text 6 Mutation, Site 155, FI FI169S Text 6 Mutation, Site 169, FI FI192S Text 6 Mutation, Site 192, FI FI24S Text 6 Mutation, Site 24, FI FI278S Text 6 Mutation, Site 278, FI FI33S Text 6 Mutation, Site 33, FI FI36S Text 6 Mutation, Site 36, FI FI37S Text 6 Mutation, Site 37, FI FI38S Text 6 Mutation, Site 38, FI FI39S Text 6 Mutation, Site 39, FI FI40S Text 6 Mutation, Site 40, FI FI42S Text 6 Mutation, Site 42, FI FI43S Text 6 Mutation, Site 43, FI FI44S Text 6 Mutation, Site 44, FI FI45S Text 6 Mutation, Site 45, FI FI73S Text 6 Mutation, Site 73, FI FI75S Text 6 Mutation, Site 75, FI FTC Text 2 Emtriva Resistance HRNID Text 9 Patient ID HRNID_ORIG Text 9 Patient identifier at original site IDV Text 2 IDV Resistance INCL_SILENT Text 1 silent mutations entered INHCOMMENT Text 25 Comment on oth inhibitor subform LPVR Text 2 Boosted LPV Resistance MVC Text 2 MVC Resistance NA102S Text 6 Mutation, Site 102, NRTI NA115S Text 6 Mutation, Site 115, NRTI NA116S Text 6 Mutation, Site 116, NRTI NA118S Text 6 Mutation, Site 118, NRTI NA135S Text 6 Mutation, Site 135, NRTI NA14S Text 6 Mutation, Site 14, NRTI NA151S Text 6 Mutation, Site 151, NRTI NA162S Text 6 Mutation, Site 162, NRTI NA169S Text 6 Mutation, Site 169, NRTI NA184S Text 6 Mutation, Site 184, NRTI NA189S Text 6 Mutation, Site 189, NRTI NA200S Text 6 Mutation, Site 200, NRTI NA203S Text 6 Mutation, Site 203, NRTI

NA207S Text 6 Mutation, Site 207, NRTI NA208S Text 6 Mutation, Site 208, NRTI NA210S Text 6 Mutation, Site 210, NRTI NA211S Text 6 Mutation, Site 211, NRTI NA214S Text 6 Mutation, Site 214, NRTI NA215S Text 6 Mutation, Site 215, NRTI NA219S Text 6 Mutation, Site 219, NRTI NA221S Text 6 Mutation, Site 221, NRTI NA228S Text 6 Mutation, Site 228, NRTI NA238S Text 6 Mutation, Site 238, NRTI NA277S Text 6 Mutation, Site 277, NRTI NA286S Text 6 Mutation, Site 286, NRTI NA293S Text 6 Mutation, Site 293, NRTI NA312S Text 6 Mutation, Site 312, NRTI NA333S Text 6 Mutation, Site 333, NRTI NA351S Text 6 Mutation, Site 351, NRTI NA386S Text 6 Mutation, Site 386, NRTI NA41S Text 6 Mutation, Site 41, NRTI NA43S Text 6 Mutation, Site 43, NRTI NA44S Text 6 Mutation, Site 44, NRTI NA62S Text 6 Mutation, Site 62, NRTI NA65S Text 6 Mutation, Site 65, NRTI NA67S Text 6 Mutation, Site 67, NRTI NA69INSS Text 6 Mutation, Site 69inss, NRTI NA69S Text 6 Mutation, Site 69, NRTI NA70S Text 6 Mutation, Site 70, NRTI NA74S Text 6 Mutation, Site 74, NRTI NA75S Text 6 Mutation, Site 75, NRTI NA77S Text 6 Mutation, Site 77, NRTI NA98S Text 6 Mutation, Site 98, NRTI NACOMMENT Text 25 Comment on NRTI subform NFV Text 2 Nelfinavir Resistance NN100S Text 6 Mutation, Site 100, NNRTI NN101S Text 6 Mutation, Site 101, NNRTI NN102S Text 6 Mutation, Site 102, NNRTI NN103S Text 6 Mutation, Site 103, NNRTI NN105S Text 6 Mutation, Site 105, NNRTI NN106S Text 6 Mutation, Site 106, NNRTI NN108S Text 6 Mutation, Site 108, NNRTI NN125S Text 6 Mutation, Site 108, NNRTI NN135S Text 6 Mutation, Site 135, NNRTI NN138S Text 6 Mutation, Site 138, NNRTI NN179S Text 6 Mutation, Site 179, NNRTI NN181S Text 6 Mutation, Site 181, NNRTI NN188S Text 6 Mutation, Site 188, NNRTI NN189S Text 6 Mutation, Site 189, NNRTI NN190S Text 6 Mutation, Site 190, NNRTI NN203S Text 6 Mutation, Site 203, NNRTI

NN208S Text 6 Mutation, Site 208, NNRTI NN211S Text 6 Mutation, Site 211, NNRTI NN214S Text 6 Mutation, Site 214, NNRTI NN221S Text 6 Mutation, Site 221, NNRTI NN225S Text 6 Mutation, Site 225, NNRTI NN227S Text 6 Mutation, Site 227, NNRTI NN228S Text 6 Mutation, Site 228, NNRTI NN230S Text 6 Mutation, Site 230, NNRTI NN236S Text 6 Mutation, Site 236, NNRTI NN238S Text 6 Mutation, Site 238, NNRTI NN245S Text 6 Mutation, Site 245, NNRTI NN312S Text 6 Mutation, Site 312, NNRTI NN318S Text 6 Mutation, Site 318, NNRTI NN333S Text 6 Mutation, Site 333, NNRTI NN43S Text 6 Mutation, Site 43, NNRTI NN90S Text 6 Mutation, Site 90, NNRTI NN96S Text 6 Mutation, Site 96, NNRTI NN98S Text 6 Mutation, Site 98, NNRTI NNCOMMENT Text 25 Comment on NNRTI subform NVP Text 2 Nevirapine Resistance OR_ODATE Date 8 Specimen Collection Date OTHER Text 50 Lab Test/Vendor PI10S Text 6 Mutation, Site 10, PI PI11S Text 6 Mutation, Site 11, PI PI13S Text 6 Mutation, Site 13, PI PI15S Text 6 Mutation, Site 15, PI PI16S Text 6 Mutation, Site 16, PI PI20S Text 6 Mutation, Site 20, PI PI23S Text 6 Mutation, Site 23, PI PI24S Text 6 Mutation, Site 24, PI PI30S Text 6 Mutation, Site 30, PI PI32S Text 6 Mutation, Site 32, PI PI33S Text 6 Mutation, Site 33, PI PI34S Text 6 Mutation, Site 34, PI PI35S Text 6 Mutation, Site 35, PI PI36S Text 6 Mutation, Site 36, PI PI37S Text 6 Mutation, Site 37, PI PI39S Text 6 Mutation, Site 39, PI PI41S Text 6 Mutation, Site 41, PI PI42S Text 6 Mutation, Site 42, PI PI43S Text 6 Mutation, Site 43, PI PI46S Text 6 Mutation, Site 46, PI PI47S Text 6 Mutation, Site 47, PI PI48S Text 6 Mutation, Site 48, PI PI50S Text 6 Mutation, Site 50, PI PI53S Text 6 Mutation, Site 53, PI PI54S Text 6 Mutation, Site 54, PI PI57S Text 6 Mutation, Site 57, PI

PI58S Text 6 Mutation, Site 58, PI PI60S Text 6 Mutation, Site 60, PI PI62S Text 6 Mutation, Site 62, PI PI63S Text 6 Mutation, Site 63, PI PI64S Text 6 Mutation, Site 64, PI PI65S Text 6 Mutation, Site 65, PI PI69S Text 6 Mutation, Site 69, PI PI71S Text 6 Mutation, Site 71, PI PI73S Text 6 Mutation, Site 73, PI PI74S Text 6 Mutation, Site 74, PI PI76S Text 6 Mutation, Site 76, PI PI77S Text 6 Mutation, Site 77, PI PI79S Text 6 Mutation, Site 79, PI PI81S Text 6 Mutation, Site 81, PI PI82S Text 6 Mutation, Site 82, PI PI83S Text 6 Mutation, Site 83, PI PI84S Text 6 Mutation, Site 84, PI PI85S Text 6 Mutation, Site 85, PI PI88S Text 6 Mutation, Site 88, PI PI89S Text 6 Mutation, Site 89, PI PI8S Text 6 Mutation, Site 8, PI PI90S Text 6 Mutation, Site 90, PI PI91S Text 6 Mutation, Site 91, PI PI93S Text 6 Mutation, Site 93, PI PICOMMENT Text 25 Comment on PI subform RTG Text 2 RTG Resistance RTV Text 2 Ritonavir Resistance SITEID Text 4 Clinic identifier SQV Text 2 SQV Resistance T20 Text 2 T20 Resistance TC Text 2 3TC Resistance TDF Text 2 Tenofovir Resistance TPV Text 2 TPV Resistance VENDOR Text 20 Lab Test/Vendor ZDV Text 2 ZDV Resistance

ARV RESISTANCE DETAIL – RESISTMUT

FIRES Numeric 3 Mutation assoc with resistance to inhibitors HRNID Text 9 Patient ID IASALL Numeric 3 Major, minor and revertants per IAS IASMAJ Numeric 3 Major mutation per IAS MUTPOINT Text 5 Mutation point (with wild type prefix) MUTPT2 Text 5 Mutation point (without wild type prefix) NARES Numeric 3 Mutation assoc with resistance to NRTIs NNRES Numeric 3 Mutation assoc with resistance to NNRTIs OR_ODATE Date 8 Specimen Collection Date

PIRES Numeric 3 Mutation assoc with resistance to PIs SITEID Text 4 Clinic identifier STANALL Numeric 3 Mutation per Stanford STANMAJ Numeric 3 Major mutation per Stanford

PHENOTYPE DETAIL – PHENTYPE

ABC Text 2 Abacavir Resistance ABCFCHG Text 35 Fold Change, Abacavir ADEQUATE_SPECIMEN Text 1 Whether specimen was adequate APV Text 2 APV Resistance APVFCHG Text 35 Fold Change, APV APVR Text 2 Boosted APV APVRFCHG Text 35 Fold Change, Boosted APV ATV Text 2 ATV Resistance ATVFCHG Text 35 Fold Change, ATV ATVR Text 2 Boosted ATV ATVRFCHG Text 35 Fold Change, Boosted ATV COMMENT Text 255 Comment D4T Text 2 D4T Resistance D4TFCHG Text 35 Fold Change, D4T DDC Text 2 ddC Resistance DDCFCHG Text 35 Fold Change, ddC DDI Text 2 ddi Resistance DDIFCHG Text 35 Fold Change, ddi DLV Text 2 Delavirdine Resistance DLVFCHG Text 35 Fold Change, Delavirdine DRVR Text 2 Boosted DRV Resistance DRVRFCHG Text 35 Fold Change, Boosted DRV DTG Text 2 Dolutegravir Resistance DTGFCHG Text 35 Fold Change, Dolutegravir EFV Text 2 Efavirenz Resistance EFVFCHG Text 35 Fold Change, Efavirenz ETR Text 2 Etravirine Resistance ETRFCHG Text 35 Fold Change, Etravirine FAPV Text 2 FOS-APV Resistance FAPVFCHG Text 35 Fold Change, FOS-APV FAPVR Text 2 Boosted FOS-APV FAPVRFCHG Text 35 Fold Change, Boosted FOS-APV FTC Text 2 Emtriva Resistance FTCFCHG Text 35 Fold Change, Emtriva HRNID Text 9 Patient ID HRNID_ORIG Text 9 Patient identifier at original site IDV Text 2 IDV Resistance IDVFCHG Text 35 Fold Change, IDV IDVR Text 2 Boosted IDV IDVRFCHG Text 35 Fold Change, Boosted IDV

INHCOMMENT Text 255 Comment on oth inhibitor subform LPVR Text 2 Boosted LPV Resistance LPVRFCHG Text 35 Fold Change, Boosted LPV MVC Text 2 MVC Resistance MVCFCHG Text 35 Fold Change, MVC NACOMMENT Text 255 Comment on NRTI subform NFV Text 2 Nelfinavir Resistance NFVFCHG Text 35 Fold Change, Nelfinavir NNCOMMENT Text 255 Comment on NNRTI subform NVP Text 2 Nevirapine Resistance NVPFCHG Text 35 Fold Change, Nevirapine OR_ODATE Date 8 Specimen Collection Date OTHER Text 50 Lab Test/Vendor PICOMMENT Text 255 Comment on PI subform REPCAP Text 9 Replication Capacity RTG Text 2 RTG Resistance RTGFCHG Text 35 Fold Change, RTG RTV Text 2 Ritonavir Resistance RTVFCHG Text 35 Fold Change, Ritonavir SITEID Text 4 Clinic identifier SQV Text 2 SQV Resistance SQVFCHG Text 35 Fold Change, SQV SQVR Text 2 Boosted SQV SQVRFCHG Text 35 Fold Change, Boosted SQV T20 Text 2 T20 Resistance T20FCHG Text 35 Fold Change, T20 TC Text 2 3TC Resistance TCFCHG Text 35 Fold Change, 3TC TDF Text 2 Tenofovir Resistance TDFFCHG Text 35 Fold Change, Tenofovir TPV Text 2 TPV Resistance TPVFCHG Text 35 Fold Change, TPV TPVR Text 2 Boosted TPV TPVRFCHG Text 35 Fold Change, Boosted TPV TROPISM Text 10 Tropism VENDOR Text 20 Lab Test/Vendor ZDV Text 2 ZDV Resistance ZDVFCHG Text 35 Fold Change, ZDV

TROFILE DETAIL – TROFILE

ADEQUATE_SPECIMEN Text 1 Whether specimen was adequate ANTAGONIST Text 3 Activity of CCR5 Antagonist Anticpated HRNID Text 9 Patient ID HRNID_ORIG Text 9 Patient identifier at original site OPTIONS Text 10 Type Test OR_ODATE Date 8 Order Date

RESULT Text 7 Tropotype Result

SYMPTOM DETAIL - SXDTL

HRNID Text 9 Patient id

HRNID_ORIG Text 9 Patient identifier at original site

SITEID Text 4 Clinic identifier

SX_CODE Text 6 Symptom code(SXC)

SX_EDATE Date 8 Symptom end date,mm/dd/yy

SX_OTHDE Text 50 Other symptom description

SX_SDATE Date 8 Symptom start date,mm/dd/yy

ENCOUNTER DETAIL - VXDTL

BMI Numeric 8 Body Mass Index

HRNID Text 9 Patient id

HRNID_ORIG Text 9 Patient identifier at original site

OVXPAYT2 Text 6 Pre-QA secondary payer

OVXPAYTY Text 6 Pre-QA primary payer

SITEID Text 4 Clinic identifier

VPAYFLAG Numeric 8 QA flag: Payor type was recoded

VX_BPDIA Numeric 8 Diastolic blood pressure

VX_BPSYS Numeric 8 Systolic blood pressure

VX_DATE Date 8 Visit date,mm/dd/yy

VX_HEIGH Numeric 8 Pt hgt(inches) at visit (10=unk)

VX_KARN Numeric 8 Karnofsky score (optional)

VX_PAYN2 Text 50 Secondary payer name, at visit

VX_PAYNA Text 50 Primary payer name at visit

VX_PAYT2 Text 6 Secondary payor at visit (code PAY)

VX_PAYTY Text 6 Primary payor at visit (code PAY)

VX_PULSE Numeric 8 Pulse

VX_RESP Numeric 8 Respiratory rate VX_TEMP Numeric 8 Temperature VX_TYPE Text 6 Visit type (code VXC)

VX_WEIGH Numeric 8 Patient weight (lbs) at visit

NO-SHOW VISIT DETAIL –NOSHOW

HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site SITEID Text 4 Clinic identifier VX_DATE Date 8 Visit date,mm/dd/yy VX_TYPE Text 6 Visit type (code VXC)

SUMMARY PAYOR HISTORY DETAIL – PAYHXSUM2

FINALPAYGRP Text 10 Pay group identified >= 75% of the time up to the given date HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site NUMPAYGRP Numeric 8 Number of pay groups identified up to the given date (Public, Private, ClinStudy, Other/unk) PAYGRP Text 10 Pay group on the date

VX_DATE Date 8 Visit date,mm/dd/yy

ACTIVE PATIENTS BY YEAR DETAIL - ACTPTS

HRNID Text 9 Patient id

HRNID_ORIG Text 9 Patient identifier at original site

SITEID Text 4 Clinic identifier

ACT1994 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT1995 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT1996 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT1997 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT1998 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT1999 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2000 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2001 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2002 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2003 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2004 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2005 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2006 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2007 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2008 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2009 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2010 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2011 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2012 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2013 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2014 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

ACT2015 Numeric 8 Indicator of patient active in the calendar year with a visit recorded

HOSPITALIZATION DETAIL – ALLHOSP

CARSTAT Text 8 Acute/chronic cardiac problem DXDESC Text 50 addtl diagnosis detail HDD_CODE Text 6 Reason for hospitalization HOSPADM Date 8 Hospital admission date HOSPDSCH Date 8 Hospital discharge date HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site LIVSTAT Text 8 Acute/chronic liver problem RENSTAT Text 8 Acute/chronic renal problem

SOURCE Text 6 Source of data

CAUSE OF DEATH DETAIL – CODDXGRP

AIDS Numeric 8 AIDS is primary and/or secondary COD COD Text 9 whether COD primary or secondary CODE Text 6 COD diagnosis code

DXGRP Text 18 diagnostic grouping of COD HRNID Text 9 Patient id PRIMAIDS Numeric 8 AIDS is a primary COD PRIMDX Text 200 primary COD provided in text SECAIDS Numeric 8 AIDS is a secondary COD SECDX Numeric 200 secondary COD provided in text

DEATH DETAIL – DTHDATA

CSRCCHT Text 1 Chart a source for cod dx CSRCCLIN Text 1 Clinician a source for cod dx CSRCDCT Text 1 Death cert. a source for cod dx CSRCHOSP Text 1 Hospital chart a source for cod dx CSRCOTSP Text 100 Specification of other source for cod dx DEATHDT Date 8 Death date HOSPDTH Numeric 1 Whether pt hospitalized at death HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site MPCHT Text 1 Chart source for other med. conditions MPCLIN Text 1 Clinician source for other med. conditions MPDCT Text 1 Death cert. for other med. conditions MPHOSP Text 1 Hospital chart for other med. conditions MPOTHSP Text 100 Specification of other source for med.cond.

MPROB1 Text 6 Medical condition #1 at death MPROB2 Text 6 Medical condition #2 at death MPROB3 Text 6 Medical condition #3 at death MPROB4 Text 6 Medical condition #4 at death MPROB5 Text 6 Medical condition #5 at death MPROB6 Text 6 Medical condition #6 at death PCAUSE1 Text 6 Primary cause of death #1 PCAUSE2 Text 6 Primary cause of death #2 PCAUSE3 Text 6 Primary cause of death #3 PCAUSE4 Text 6 Primary cause of death #4 POTHER Text 200 Primary cause of death, other SCAUSE1 Text 6 Secondary cause of death #1 SCAUSE2 Text 6 Secondary cause of death #2 SCAUSE3 Text 6 Secondary cause of death #3 SCAUSE4 Text 6 Secondary cause of death #4

SOTHER Text 200 Secondary cause of death, other

RISK DETAIL – RISK

BIRD Text 4 Bird as pet CANCHX Text 1 Family hx of cancer CARDIOHX Text 1 Family hx of CVD

CAT Text 4 Cat as pet CHEWTOB Text 10 Whether chews tobacco COCAINE Text 10 Cocaine use CRYSMETH Text 10 Crystal meth use DIABHX Text 1 Family hx of diabetes DOG Text 4 Dog as pet DRINKSOTH Text 30 Other description of # drinks ECSTACY Text 10 Ecstacy use HEROIN Text 10 Heroin use HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site IVDRUGUSE Text 10 IV drug use LSD Text 10 LSD use MARIJUANA Text 10 Marijuana use OTHDESC Text 30 Description of other substance abuse OTHERPET Text 30 Other pet OTHERSUB Text 30 Other substance abuse PT_ALCOH Text 10 Alcohol use(at time of entry) PT_CIGPD Text 8 Cigarettes per day PT_DRINK Text 6 Number of drinks per week (code DRK) SITEID Text 4 Clinic identifier SMOKEFRQOTH Text 30 Other desc of smoking frequency SMOKEHX Text 10 Smoking history STROKEHX Text 1 Family hx of stroke SUBABUSE Text 10 Recreational drug use TYPESMOKE Text 10 Type of smoking WADSDAILY Numeric 8 Wads per day

TRAVEL DETAIL – TRAVEL

COUNTRY Text 40 Country HRNID Text 9 Patient id HRNID_ORIG Text 9 Patient identifier at original site