statschoice.com

Copyright @ www.statschoice.com

EXAMPLE_NUM ROW_DESCRIPTION STUDYID DOMAIN USUBJID MBSEQ MBREFID MBLNKID MBTESTCD MBTEST MBORRES MBSTRESC MBNAM MBSPEC MBLOC MBMETHOD VISITNUM VISIT MBDTC
IG33_MB_MB_001 ABC MB ABC-001-002 1 SPEC01 1 MCORGIDN Microbial Organism Identification ENTEROCOCCUS FAECALIS ENTEROCOCCUS FAECALIS CENTRAL LAB ABC FLUID SKIN MICROBIAL CULTURE, SOLID 1 VISIT 1 2005-07-21T08:00
IG33_MB_MB_001 ABC MB ABC-001-002 2 SPEC01 2 MCORGIDN Microbial Organism Identification ENTEROCOCCUS FAECALIS ENTEROCOCCUS FAECALIS LOCAL LAB XYZ FLUID SKIN MICROBIAL CULTURE, SOLID 1 VISIT 1 2005-07-21T08:00

Copyright @ www.statschoice.com

EXAMPLE_NUM ROW_DESCRIPTION STUDYID DOMAIN USUBJID MBSEQ MBREFID MBTESTCD MBTEST MBTSTDTL MBORRES MBSTRESC MBLOC MBMETHOD VISITNUM VISIT MBDTC
IG33_MB_MB_002 ABC MB ABC-001-001 1 SP01 GMNCOC Gram Negative Cocci DETECTION PRESENT PRESENT LUNG GRAM STAIN 1 VISIT 1 2005-06-19T08:00
IG33_MB_MB_002 ABC MB ABC-001-001 2 SP01 GMNCOC Gram Negative Cocci CELL COUNT 2+ FEW LUNG GRAM STAIN 1 VISIT 1 2005-06-19T08:00
IG33_MB_MB_002 ABC MB ABC-001-001 3 SP01 GMNROD Gram Negative Rods DETECTION PRESENT PRESENT LUNG GRAM STAIN 1 VISIT 1 2005-06-19T08:00
IG33_MB_MB_002 ABC MB ABC-001-001 4 SP01 GMNROD Gram Negative Rods CELL COUNT 2+ FEW LUNG GRAM STAIN 1 VISIT 1 2005-06-19T08:00
IG33_MB_MB_002 ABC MB ABC-001-001 5 SP01 MCORGIDN Microbial Organism Identification STREPTOCOCCUS PNEUMONIAE STREPTOCOCCUS PNEUMONIAE LUNG MICROBIAL CULTURE, SOLID 1 VISIT 1 2005-06-19T08:00
IG33_MB_MB_002 ABC MB ABC-001-001 6 SP01 MCORGIDN Microbial Organism Identification KLEBSIELLA PNEUMONIAE KLEBSIELLA PNEUMONIAE LUNG MICROBIAL CULTURE, SOLID 1 VISIT 1 2005-06-19T08:00
IG33_MB_MB_002 ABC MB ABC-001-001 7 SP02 MCORGIDN Microbial Organism Identification KLEBSIELLA PNEUMONIAE KLEBSIELLA PNEUMONIAE LUNG MICROBIAL CULTURE, SOLID 2 VISIT 2 2005-06-26T08:00
IG33_MB_MB_002 ABC MB ABC-001-001 8 SP03 MCORGIDN Microbial Organism Identification NO GROWTH NO GROWTH LUNG MICROBIAL CULTURE, SOLID 3 VISIT 3 2005-07-06T08:00

Copyright @ www.statschoice.com

EXAMPLE_NUM ROW_DESCRIPTION STUDYID DOMAIN USUBJID SPDEVID MBSEQ MBGRPID MBLNKID MBREFID MBTESTCD MBTEST MBTSTDTL MBORRES MBORRESU MBSTRESC MBSTRESN MBSTRESU MBLOC MBSPCCND MBMETHOD VISITNUM VISIT MBDTC
IG33_MB_MB_003 ABC MB ABC-01-101 1 1 100.1 AFB Acid-Fast Bacilli DETECTION PRESENT PRESENT STOMACH CONCENTRATED ZIEHL NEELSEN ACID FAST STAIN 1 WEEK 1 2011-01-17T06:00
IG33_MB_MB_003 ABC MB ABC-01-101 2 1 100.1 AFB Acid-Fast Bacilli CELL COUNT 3+ 3+ STOMACH CONCENTRATED ZIEHL NEELSEN ACID FAST STAIN 1 WEEK 1 2011-01-17T06:00
IG33_MB_MB_003 ABC MB ABC-01-101 ABC765 3 100.2 MTBCMPLX Mycobacterium Tuberculosis Complex DETECTION PRESENT PRESENT STOMACH NUCLEIC ACID AMPLIFICATION TEST 1 WEEK 1 2011-01-17T06:00
IG33_MB_MB_003 ABC MB ABC-01-101 4 2 1 100.3 MTB Mycobacterium tuberculosis DETECTION PRESENT PRESENT STOMACH MICROBIAL CULTURE, SOLID 1 WEEK 1 2011-01-17T06:00
IG33_MB_MB_003 ABC MB ABC-01-101 5 2 1 100.3 MTB Mycobacterium tuberculosis COLONY COUNT 147 CFU 14700 14700 CFU/mL STOMACH MICROBIAL CULTURE, SOLID 1 WEEK 1 2011-01-17T06:00
IG33_MB_MB_003 ABC MB ABC-01-101 6 2 1 100.3 MTB Mycobacterium tuberculosis COLONY COUNT 2+ 2+ STOMACH MICROBIAL CULTURE, SOLID 1 WEEK 1 2011-01-17T06:00

Copyright @ www.statschoice.com

EXAMPLE_NUM ROW_DESCRIPTION STUDYID DOMAIN USUBJID MBSEQ MBREFID MBGPRID MBTESTCD MBTEST MBTSTDTL MBORRES MBORRESU MBSTRESC MBTRESN MBSTRESU MBSPEC MBLOC MBMETHOD VISITNUM VISIT MBDTC MBENDTC
IG33_MB_MB_004 ABC MB ABC-01-601 1 600 1 MTB Mycobacterium tuberculosis DETECTION PRESENT PRESENT SPUTUM LUNG MICROBIAL CULTURE, SOLID 5 WEEK 5 2011-03-01T22:00 2011-03-02T06:00
IG33_MB_MB_004 ABC MB ABC-01-601 2 600 1 MTB Mycobacterium tuberculosis COLONY COUNT 87 CFU/mL 87 87 CFU/mL SPUTUM LUNG MICROBIAL CULTURE, SOLID 5 WEEK 5 2011-03-01T22:00 2011-03-02T06:00

Copyright @ www.statschoice.com

EXAMPLE_NUM ROW_DESCRIPTION STUDYID RDOMAIN USUBJID IDVAR IDVARVAL QNAM QLABEL QVAL QORIG
IG33_MB_SUPPMB_002 ABC MB ABC-01-101 MBTSTDTL CELL COUNT MBQSCAL Quantification Scale CDC semi-quantitative score for gram staining CRF
IG33_MB_SUPPMB_002 ABC MB ABC-01-101 MBTSTDTL CELL COUNT MBRRSTYP Reported Result Scale Type ORDINAL CRF

Copyright @ www.statschoice.com

EXAMPLE_NUM ROW_DESCRIPTION STUDYID RDOMAIN USUBJID IDVAR IDVARVAL QNAM QLABEL QVAL QORIG
IG33_MB_SUPPMB_003 ABC MB ABC-01-101 MBSEQ 2 MBQSCAL Quantification Scale Smear Quantification: Centers for Disease Control Method for Carbol Fuchsin Staining (1000X) eDT
IG33_MB_SUPPMB_003 ABC MB ABC-01-101 MBSEQ 3 MBMICERT Microbial Identification Certainty DEFINITIVE eDT
IG33_MB_SUPPMB_003 ABC MB ABC-01-101 MBSEQ 4 MBMICERT Microbial Identification Certainty PRESUMPTIVE eDT
IG33_MB_SUPPMB_003 ABC MB ABC-01-101 MBREFID 100.3 MBMEDTYP Medium Type MIDDLEBROOK 7H10 AGAR eDT
IG33_MB_SUPPMB_003 ABC MB ABC-01-101 MBSEQ 6 MBQSCAL Quantification Scale Solid Media Result: Centers for Disease Control (CDC) Quantification Scale eDT
IG33_MB_SUPPMB_003 ABC MB ABC-01-101 MBSEQ 5 MBDILFCT Dilution Factor 10^-2 eDT
IG33_MB_SUPPMB_003 ABC MB ABC-01-101 MBSEQ 2 MBRRSTYP Reported Result Scale Type ORDINAL eDT
IG33_MB_SUPPMB_003 ABC MB ABC-01-101 MBSEQ 5 MBRRSTYP Reported Result Scale Type QUANTITATIVE eDT
IG33_MB_SUPPMB_003 ABC MB ABC-01-101 MBSEQ 6 MBRRSTYP Reported Result Scale Type ORDINAL eDT

Copyright @ www.statschoice.com

EXAMPLE_NUM ROW_DESCRIPTION STUDYID RDOMAIN USUBJID IDVAR IDVARVAL QNAM QLABEL QVAL QORIG
IG33_MB_SUPPMB_004 ABC MB ABC-01-601 MBSEQ 1 MBCNMIND Culture Contamination Indicator Y eDT
IG33_MB_SUPPMB_004 ABC MB ABC-01-601 MBSEQ 2 MBCNMIND Culture Contamination Indicator Y eDT
IG33_MB_SUPPMB_004 ABC MB ABC-01-601 MBSEQ 2 MBRRSTYP Reported Result Scale Type QUANTITATIVE eDT