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 the ones that would be used in a particular study.   

Dataset wrap
NameADMH
Dataset2

STUDYID

USUBJIDASTDTAENDTASTDYAENDYCMSTDTCCMENDTCAOCCFLAOCCPFLAOCC01FLPREFLONTRTFLFUPFLTRTPSAFFLCMTRTCMDECODCMDOSECMDOSTXTCMDOSUCMCLASCMSEQ
ABC123ABC1230100101JAN200401JAN2004112004-01-012004-01-01YYY

Y


Product AYASPIRINacetylsalicylic acid100
mgANALGESICS1
ABC123ABC1230100102JAN200402JAN2004222004-01-022004-01-02



Y

YASPIRINacetylsalicylic acid100
mgANALGESICS2
ABC123ABC1230100103JAN200403JAN2004332004-01-032004-01-03



Y

YASPIRINacetylsalicylic acid100
mgANALGESICS3
ABC123ABC1230100107JAN200407JAN2004772004-01-072004-01-07



Y

YASPIRINacetylsalicylic acid100
mgANALGESICS4
ABC123ABC1230100107JAN200407JAN2004772004-01-072004-01-07



Y

YASPIRINacetylsalicylic acid100
mgANALGESICS5
ABC123ABC1230100109JAN200409JAN2004992004-01-092004-01-09



Y

YASPIRINacetylsalicylic acid100
mgANALGESICS6
ABC123ABC12301002



2004
YYYYYY
YDIOVANvalsartan20
mgANTIHYPERTENSIVES1
ABC123ABC12301002



2004-01

YYYYY
YZOLOFTsertraline50
mgPSYCHOANALEPTICS2
ABC123ABC1230100209JAN200410JUN20049102004-01-092004-06-10
YY
YY
YASTELINazelastine
2 sprays in each nostril-137 mcgmcgNASAL PREPARATIONS3
ABC123ABC1230100301JAN2004
1
2004-01-01
YYYYYY
YASPIRINacetylsalicylic acid100
mgANALGESICS1
Definexmltable
LevelDataset
PurposeAnalysis
NameADMH
DatasetDescriptionClassStructurePurposeKeysLocationDocumentation
ADCM


Analysis
ADMH.xptADMH.SAS/SAP
Definexmltable
DatasetADMH
LevelVariable
PurposeAnalysis
Variable NameVariable LabelTypeCodelist/Controlled TermsCoreNotes

STUDYID

Study Identifiertext
ReqMH.STUDYID
USUBJIDUnique Subject Identifiertext
ReqMH.USUBJID
ASTDTAnalysis Start Dateinteger
Cond

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

AENDTAnalysis End Dateinteger
CondConvert MH.MHENDTC from character ISO8601 format to numeric date format
AOCCFL1st Occurrence within Subject FlagtextYPermSort the data in the required order and flag the first for each subject.
AOCCPFL1st Occurrence of Preferred Term FlagtextYPermSort the data in the required order and flag the first record for each MHDECOD for each subject.
AOCCSFL1st Occurrence of SOC FlagtextYPermSort the data in the required order and flag the first record for each body system for each subject.
TRTPPlanned TreatmenttextProduct A;Product BCondADSL.TRT01P
TRTAActual TreatmenttextProduct A;Product BCondADSL.TRT01A
SAFFLSafety Population FlagtextY;NCondADSL.SAFFL
RANDFLRandomized Population FlagtextY;NCondADSL.RANDFL
TRTSDTDate of First Exposure to Treatmentinteger
PermADSL.TRTSDT
TRTEDTDate of Last Exposure to Treatmentinteger
PermADSL.TRTEDT
MHTERMReported Term for the Medical Historytext
ReqMH.MHTERM
MHDECODDictionary-Derived Termtext
CondMH.MHDECOD
MHCATCategory for Medical Historytext
PermMH.MHCAT
MHBODSYSBody System or Organ Classtext
CondMH.MHBODSYS
MHSTDTCStart Date/Time of Medical History Eventtext
PermMH.MHSTDTC
MHENDTCEnd Date/Time of Medical History Eventtext
PermMH.MHENDTC
MHSEQSequence Numberinteger
PermMH.MHSEQ



...