Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This is an example of the ADMH dataset and associated metadata. This is just an example and does not mean to indicate that ADMH must be used as the dataset name, nor are the parameters described necessarily those that would be used in a particular study.   

Dataset wrap
Nameadmh
Dataset2
tableidadmh
RowSTUDYIDUSUBJIDMHTERMMHDECODMHBODSYSASTDTAENDT

AOCCFL

AOCCPFLAOCCSFLTRTPTRTASAFFLRANDFLTRTSDTTRTEDTMHCATMHSTDTCMHENDTCMHENRTPTMHENTPTMHSEQ
1A1232001ASTHMAAsthmaRespiratory system disorders

YYYPlaceboPlaceboYY

GENERAL MEDICAL HISTORY2003
ONGOING2021-01-021
2A1232001FREQUENT HEADACHESHeadacheCentral and peripheral nervous system disorders


YYPlaceboPlaceboYY

GENERAL MEDICAL HISTORY2004-07
ONGOING2021-01-022
3A1232001BROKEN LEGBone fractureMusculoskeletal system disorders15JUL200531AUG2005
YYPlaceboPlaceboYY

GENERAL MEDICAL HISTORY2005-07-152005-08-31

3
Definexmltable
LevelDataset
PurposeAnalysis
NameADMH
DatasetDescriptionClassStructurePurposeKeysLocationDocumentation
ADMHMedical History Analysis DatasetOCCDSone record per subject per eventAnalysisUSUBJID, MHTERMADMH.xptADMH.SAS/SAP
Definexmltable
DatasetADMH
LevelVariable
PurposeAnalysis
NameADMH
Variable NameVariable LabelTypeCodelist/Controlled TermsCoreNotes

STUDYID

Study Identifier

...

text
Req

...

MH.STUDYID

...

USUBJIDUnique Subject Identifier

...

text
Req

...

MH.USUBJID
MHTERMReported Term for the Medical Historytext
ReqMH.MHTERM
MHDECODDictionary-Derived Termtext
CondMH.MHDECOD
MHBODSYSBody System or Organ Classtext
CondMH.MHBODSYS

...

ASTDTAnalysis Start Date

...

integer
Cond

...

Convert MH.MHSTDTC from character ISO8601 format to numeric date format

...

AENDTAnalysis End Date

...

integer
Cond

...

Convert MH.MHENDTC from character ISO8601 format to numeric date format

...

...

AOCCFL1st Occurrence within Subject Flag

...

textYPerm

...

...

Sort the data in the required order and flag the first

...

for each subject.
AOCCPFL1st Occurrence of Preferred Term Flag

...

textYPerm

...

Sort the data in the required order and flag the first

...

record for each MHDECOD for each subject.
AOCCSFL1st Occurrence of SOC Flag

...

textYPerm

...

Sort the data in the required order and flag the first

...

record for each body system for each subject.
TRTPPlanned

...

Product

...

textProduct A;Product B

...

CondADSL.

...

TRT01P
TRTAActual

...

Product

...

textProduct A;Product BCondADSL.TRT01A
SAFFLSafety Population Flag

...

textY;NCond

...

ADSL.SAFFL
RANDFLRandomized Population Flag

...

textY;NCondADSL.RANDFL
TRTSDTDate of First Exposure to

...

Product

...

integer
PermADSL.TRTSDT
TRTEDTDate of Last Exposure to

...

Product

...

integer
PermADSL.TRTEDT

...

MHCATCategory for Medical Historytext
PermMH.MHCAT
MHSTDTCStart Date/Time of Medical History Eventtext
PermMH.MHSTDTC
MHENDTCEnd Date/Time of Medical History Eventtext
PermMH.MHENDTC
MHENRTPTEnd Relative to Reference Time Pointtext
PermMH.MHENRTPT
MHENTPTEnd Reference Time Pointtext
PermMH.MHENTPT

...

MHSEQSequence Number

...

integer
PermMH.MHSEQ