Versions Compared

Key

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

...

Dataset wrap
NameADMH
Dataset2

STUDYID

USUBJIDASTDTAENDT
ASTDYAENDYCMSTDTCCMENDTC

AOCCFL

AOCCPFL
AOCC01FL
AOCCSFL
PREFL
TRTP
ONTRTFL
TRTA
FUPFLTRTP
SAFFL
CMTRT
RANDFL
CMDECOD
TRTSDT
CMDOSE
TRTEDT
CMDOSTXT
MHTERM
CMDOSU
MHDECOD
CMCLAS
MHCAT
CMSEQ
MHBODSYS
ABC123
MHSTDTC
ABC12301001
MHENDTC
01JAN2004
MHSEQ
01JAN2004112004-01-012004-01-01
A1232001

YYY
Y
Product AProduct AY
ASPIRINacetylsalicylic acid100mgANALGESICS1ABC123ABC1230100102JAN200402JAN2004222004-01-02
2004-01-02
Y
Y


ASTHMA
ASPIRINacetylsalicylic acid100mgANALGESICS2ABC123ABC1230100103JAN200403JAN2004332004-01-032004-01-03
AsthmaGENERAL MEDICAL HISTORYRespiratory system disorders2003
1
A1232001


YY
ASPIRINacetylsalicylic acid100
mgANALGESICS3ABC123ABC1230100107JAN200407JAN2004772004-01-072004-01-07


YY
ASPIRIN


FREQUENT HEADACHES
acetylsalicylic acid100mgANALGESICS4ABC123ABC1230100107JAN200407JAN2004772004-01-072004-01-07YYASPIRINacetylsalicylic acid100mgANALGESICS5ABC123ABC1230100109JAN200409JAN2004992004-01-092004-01-09YYASPIRINacetylsalicylic acid100mgANALGESICS6ABC123ABC123010022004
HeadacheGENERAL MEDICAL HISTORYCentral and peripheral nervous system disorders2004-07
2
A123200115JUL200531AUG2005
YY

YY
Y


BROKEN LEG
YYDIOVANvalsartan20mgANTIHYPERTENSIVES1ABC123ABC123010022004-01YYYYYYZOLOFTsertraline50mgPSYCHOANALEPTICS2ABC123ABC1230100209JAN200410JUN20049102004-01-092004-06-10YYYYYASTELINazelastine2 sprays in each nostril-137 mcgmcgNASAL PREPARATIONS3
Bone fractureGENERAL MEDICAL HISTORYMusculoskeletal system disorders2005-07-152005-08-313
ABC123ABC1230100301JAN200412004-01-01YYYYYYYASPIRINacetylsalicylic acid100mgANALGESICS1
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



...