Quick Links
Connect with Us
Need Help? Have a Question?

DCDR Data Dictionary

DCDR Data Dictionary

Data Elements

The following are data elements currently contained within the DCDR. If you would like to request for any new data elements, please fill out the DCDR enhancement request.

Data is refreshed monthly at the end of the month.

Data ListStart DateData Elements Available
Allergy List
(Patient Level)
2010-01-01Both Orca & Epic Allergy List (Query Instructions)
Demographics
(Patient Level)
2010-01-01
*1994-01-01 (for certain Dx and Labs)
Age
Gender
Language
Marital Status
Race
Religion
Vital Status
Distance from HMC
Diagnosis2004-01-01
*1994-01-01
ICD9 Diagnoses from unbilled facilities bills and charges, Epic order summary for UWPN encounters
*HIV 042* and 043* Dx Only
Coded discharge Dx can be queried separately (See instruction on how to query)
Disposition2010-01-01Inpatient Discharge Disposition
Epic Problem List
(Patient Level)
2010-01-01ICD9 Epic Problem List (See instruction on how to query)
Infectious Disease Classification2010-01-01Culture Description (for positive results only from micro labs)
Specimen Description (for positive results only from micro labs)
ID Note Presence
Susceptibility (OXA only)
Immunization
(Patient Level)
2010-01-01Epic - any immunization associated with a patient
Orca - immunization given (clinical event) to a patient
Labs
(Note that lab codes are specific to one test)
Hover over the acronym with your mouse to see the full description
2010-01-01
*1994-01-01
Blood Gases
  • Arterial Blood Gas (HCO3, OSAT, PCO2, PH, PO2, WHCT)
  • Specimen Information (FIO2, PEEP, RXO2, SPDESC)
Chemistry
  • Blood Electrolytes (BUN, CA, CL, CO2, CRE, GFRA, GFRB, GLU, IGAP, K, MG, NA, P, WGLU, WGLUHM, WGLUUW, WINCA, WK, WNA)
  • Cardiac Studies (CK, CKMACR, MYO)
  • Endocrine (A1C, A1CRPD, ACTH, CORT, DHEAS, EDOL, FSH, IPTH, LH, MN, NMN, PG, PRL, RCALC, RDSRNR, T3, T4, TEST, TESTF, TGAB, TGN, TSH)
  • Enzymes (ALASE, LD, RANGCE, RTPMT)
  • Lipids (CHOL, CHRAT, HDL, LDL, NONHDL, TRIG, URIC)
  • Liver Studies (AGR, ALB, ALK, ALT, AST, BIL, BILD, GLOB, TP)
  • Miscellaneous Chemistries (VITD2, VITD3, VITDT)
Drugs/Tox
  • Other Drugs (MMA)
  • Toxicology - Nonblood (UAMTQL, UAMTQL, UASAQL, UBNZQL, UBRBQL, UCOCQL, UETOH, UMDNQL, UOPIQL, UOXCQL, UPCPQL, UTHCQL, UTRIQL, UTYLQL)
Hematology/Coagulation
  • CBC (HB, HCT, MCH, MCHC, MCV, PLT, RBC, RDWCV, WBC)
  • Coagulation (FIBCL, HIPA, LUPINH, PROINR, PROPAT, PTTPAT, RSRHD, RSRLD, TTPAT)
  • Hematopathology Markers*(CD4A, CD4P, DFCNT)
  • Special Hematology (ESR, FE, FER, FOLAT, G6PD, TIBCD, TRSATD, TRSF, VIT12)
  • WBC Differential (BASO, BASOP, BLST, BLSTP, CCNT, EOS, EOSP, IMG, IMGP, LYMPH, LYMPHP, META, METAP, MONOC, MONOCP, MYEL, MYELP, NRBCA, NRBCP, PROM, PROMP, TNEUT, TNEUTP, UNCLS, UNCLSP)
Non-Blood
  • Body Fluid Cell Counts (FBASO, FEOS, FLYM, FMAC, FMAME, FNEUT, FNUCC, FRBC, FUNC)
  • Body Fluid Results (FMEF, FMEP)
  • CSF Results(CANEU, CEG, CIGG, CIND, CTP, RCANGI)
Other
  • Autoimmune (ACARA, ACARG, ACARM, ACHROM, AJO, ALKMA, AMITO, AMPOC, AMPOL, ANABIO, ANASC, ANCAIF, APR3C, APR3L, ARNP, ASCL70, ASM, ASMA, ASMRNP, ASSA, ASSB, ATPO, ATTGA, ATTGG, B2GP, B2GPM, CCP, DNAEL, ICFP, ICSP, RACHGN, RACHRM, RAGNA1, RAMPHS, RANN1, RANN2, RANN3, RCCN, RCCPQ, RCRMP, RF, RNVGCK, RPCA1, RPCA2, RPCATR, RSRAR, RSTMA)
  • Immunology (C1, C3, C4, CH50L, CRFB, CRFB10, CRFG, CRFG10, CRYO, CRYO10, EA1, EA2, EALB, EB, EG, ETP, HSCRP, IGA, IGE, IGG, IGM, KFLC, KLR, LFLC)
  • Miscellaneous Other (QFTBAG, QFTBMTQFTBNL)
  • Oncology (BHCG, CEA, PSA)
Urine Tests
  • Timed Urine Tests (CREINT, CREPT, CREPU, CRETV, ICREPU, MALPM, MALPT, MALPU, MALRA, PCRAT, PCRINT, PCRTV, TPINT, TPPT, TPPU, TPTV, URIINT, URIPT, URIPU, URITV)
  • Urin Analysis (UAMOR, UBACT, UBILQL, UCLA, UCOL, UGLUQ, UKET, UMACCM, UMUCS, UNIT, UOCULT, UOVFB, UPH, URBC, URTEPI, USPG, UTPQL, UTRCH, UURBIL, UWBC, UWEST, UYEAST)
  • Urin Other (ELINT, ELTV)
Virology/Serology
  • Hepatitis Detection and Monitoring (BCAB, BSAB, HA, HAGM, HBAG, HCABR, IUAB)
    - Herpes Group - Serology/Molecular DX (EBVQNR/EBQNR, EBVLOG/EBLOG, EBVIGG, EBVIGM, EBVNA)
  • HIV Detection and Monitoring* (HQRR, HQRTR, HRRSLT, HRTRES, HURTR)
  • HIV Genotypic Resistance Testing* (Only Integrase(HVGINM)-92,143,148,155 and RT Mutations(HVGTRM)-65,103,138,181,184,188,190 )
  • Serology (RHISAR, MONO)
Medications2010-01-01Inpatient and Outpatient Medications ordered (both Epic and Orca)**
- Searchable by generic ingredient or VA drug class
**Those that do not specifically map to Epic/Orca catalogs and to a generic drug code might not be queriable
Procedures2010-01-01CPT and ICD9 procedure codes from unbilled facilities bills and charges
Note that many inpatient procedures are billed ICD9 (not CPT)
Outpatient procedure orders from Epic
Transplant2010-01-01Transplant related ICD9 Diagnoses from unbilled facilities bills and charges, Epic order summary for UWPN encounters
Coded discharge Dx can be queried separately (See instruction on how to query)
Visit Details2010-01-01
*1994-01-01 (for certain Dx and Labs)
Age at visit
Institution (HMC, UWMC, UWPN)
Outpatient clinics (Warning: Long query time, please be patient)
Visit Type (ED, IP, OP)
Vitals2010-01-01Vitals from Orca and Epic  (BP, BMI, Height, Weight, Pulse, Temperature)
Contact Us / Request Services

Contact Us / Request Services

Cite ITHSThe Institute is supported by grants UL1 TR002319, KL2 TR002317, and TL1 TR002318 from the NIH National Center for Advancing Translational Sciences through the Clinical and Translational Science Awards Program (CTSA).

Please help us continue to support your research by citing our grant number(s) in publications we supported.