Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated all dates to yymmdd10.

...

Definexmltable
DatasetADSL
LevelVariable
PurposeAnalysis
NameVariable
Variable NameVariable LabelTypeCodelist/Controlled TermsSource/Derivation/Comment
STUDYIDStudy Identifiertext
Predecessor: DM.STUDYID
USUBJIDUnique Subject Identifiertext
Predecessor: DM.USUBJID
BRTHDTDate of Birthintegerdate9yymmdd10.

Derived: Date portion of DM.BRTHDTC converted to numeric and displayed in a format, such as date9yymmdd10. 

AAGEAnalysis Agefloat
Derived: Age as screening, computed by DM.RFICDTC - BRTHDTC as continuous variable. Note that some countries do not allow capturing date of birth, so this could be computed by capturing age in years and months on a CRF.
AGEAgeinteger
Predecessor: DM.AGE
AGEUAge UnitstextYEARSPredecessor: DM.AGEU

SEX

Sextext(SEX)Predecessor: DM.SEX

RACE

Racetext(RACE)Predecessor: DM.RACE
TRTSDTDate of First Exposure to Treatmentintegerdate9yymmdd10.Derived: Date portion of DM.RFSTDTC converted to numeric and displayed in a format such as date9yymmdd10.
RFICDT

Date of Informed Consent

integerdate9yymmdd10.Derived: Date portion of DM.RFICDTC converted to numeric and displayed in a format such as date9yymmdd10.
DTHDT

Date of Death

integerdate9yymmdd10.

Derived: Date portion of DM.DTHDT converted to numeric and displayed in a format such as date9yymmdd10.

DTHFL

Subject Death
Flag

textYPredecessor: DM.DTHFL
TRT01P

Planned Treatment for Period 01

textDrug A; Drug B

Predecessor: DM.ARM.

May be changed to lower case or more descriptive term for use in tables and listings.

TRT01A

Actual Treatment for Period 01

textDrug A; Drug B

Predecessor: DM.ACTARM.

Note: Actual treatment matches planned treatment unless there is a reason subject does not take planned drug.

ITTFL

Intent-To-Treat Population Flag

text

Y; N

Derived: Derive the intent-to-treat population as per the protocol and SAP.

ACEINHFL

ACE Inhibitor Medications Flag

text

Y; N

Derived: Select a list of ACE inhibitor medications from concomitant medications (CM) domain as per SAP or protocol. Set to "Y" if these medications were taken during the study, and "N" if they are absent. Can be used to subset or to exclude the population who took ACE inhibitors.

HEIGHTSC

Height (cm) at Screening

float


Predecessor: Set to VS.VSSTRESN where VS.VSTESTCD = "HEIGHT" and VISITNUM= 1 (or screening visit).

WEIGHTSC

Weight (kg) at Screening

float


Predecessor: Set to VS.VSSTRESN where VS.VSTESTCD = "WEIGHT" and VISITNUM = 1 (or screening visit).

BSASC

Body Surface Area at Screening

float


Derived: Select where VISITNUM = 1 (or screening visit). Compute from HEIGHT and WEIGHT, using the Du Bois method. BSA = 0.007184 × W0.425 × H0.725

There are multiple methods for calculating BSA (e.g., Du Bois, Mosteller, Haycock, Gehan & George, Boyd, Fujimoto, Takahira, Schlich); the study protocol should describe which to use.

13JUN2022
Dataset wrap
Showtrue
NameADSL
16JUN2022
Dataset2
tableidadsl
RowSTUDYIDUSUBJIDBRTHDTAAGEAGEAGEUSEXRACETRTSDTRFICDTDTHDTDTHFLTRT01PITTFLACEINHFLHEIGHTSCWEIGHTSCBSASC
1DMD-EFLGEDMD-EF-01-101
07FEB2010
2010-02-0712.312YEARSMBLACK OR AFRICAN AMERICAN
16JUN2022
2022-06-162022-06-16

Drug AYY119200.82
2DMD-EFLGEDMD-EF-01-101
01MAY2008

2008-05-01

14.114YEARSMASIAN
13JUN2022

2022-06-13

2022-06-13

Drug AYY115300.95
3DMD-EFLGEDMD-EF-01-101
10JUL2003
2003-07-1019.019YEARSMNATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER

15JUL2022

15JUL2022

2022-07-15

2022-07-15

Drug BYN140451.30
4DMD-EFLGEDMD-EF-01-101
15JAN1999
1999-01-1523.723YEARSMWHITE
06SEP202206SEP202223NOV2023

2022-09-06

2022-09-06

2023-11-23

YDrug BYY132421.21

ADEFNTP

The ADEFNTP includes tests pertinent to analyses. The records from CV (CVTESTCD = "LVEF_C" and "RVEF_C") and the records from LB (LBTESTCD = "BNPPRONT") were selected. Many lab draws may occur throughout the year, but only those linked to a specific visit were included. By subsetting the LB dataset by LBLNKID not missing, laboratory data that aligns with CV data can be filtered out and sorted using USUBJID and VISIT. If LBLNKID is not available or the LB dataset does not contain VISIT, a windowing strategy could be used to select the laboratory draw closest to that visit using date of lab draw (LB.LBDTC.).

...

Definexmltable
DatasetADEFNTP
LevelVariable
PurposeAnalysis
NameVariable
Variable NameVariable LabelTypeCodelist/Controlled TermsSource/Derivation/Comment
STUDYIDStudy Identifiertext
Predecessor: CV.STUDYID
USUBJIDUnique Subject Identifiertext
Predecessor: CV.USUBJID
BRTHDTDate of Birthintegerdate9yymmdd10.Predecessor: ADSL.BRTHDT
AAGEAnalysis Agefloat
Predecessor: ADSL.AAGE
AGEUAge Unittext

Predecessor: ADSL.AGEU

SEX

Sextext(SEX)

Predecessor: ADSL.SEX

RACE

Racetext(RACE)Predecessor: ADSL.RACE
TRTSDT

Date of First Exposure to Treatment

integerdate9yymmdd10.Predecessor: ADSL.TRTSDT
TRT01P

Planned Treatment for Period 01

textDrug A; Drug BPredecessor: ADSL.TRT01P
TRT01A

Actual Treatment for Period 01

textDrug A; Drug BPredecessor: ADSL.TRT01A

ITTFL

Intent-To-Treat Population Flag

text

Y; N

Predecessor: ADSL.ITTFL

HEIGHT

Height (cm)

float


Set to VS.VSSTRESN where VS.VSTEST = "HEIGHT" by visit.

WEIGHT

Weight (kg)

float


Set to VS.VSSTRESN where VS.VSTEST = "WEIGHT" by visit.

BSABody Surface Area (m2)float


Derived:

Compute from HEIGHT and WEIGHT at each visit, using the Du Bois method. BSA = 0.007184 × W0.425 × H0.725

There are multiple methods for calculating BSA; the study protocol should describe which to use.

ACEINHFL

ACE Inhibitor Medications Flag

text

Y; N

Predecessor: ADSL.ACEINHFL
PARAMParametertext

Left Ventricular Ejection Fraction, Cal (%);

Right Ventricular Ejection Fraction, Cal (%);

N-Terminal ProB-type Natriuretic Peptide (ng/L)

Predecessor:

CV.CVTEST

LB.LBTEST

PARAMCDParameter Codetext

LVEF_C;

RVEF_C;

BNPPRONT

Predecessor:

CV.CVTESTCD

LB.LBTESTCD

PARAMNParameter (N)integer

1; 2; 3

Assigned:

Number PARAMCD as follows:

LVEF_C = "1"

RVEF_C = "2"

BNPPRONT = "3"

AVALAnalysis Valuefloat

See Parameter Value Metadata

AVISITAnalysis Visittext

Visit 1 (Baseline); Visit 6 (1 Year)

If CV.VISIT = "VISIT 1" then AVISIT = "Visit 1 (Baseline)".

If CV.VISIT = "VISIT 6" then AVISIT = "Visit 6 (1 Year)".

AVISITNAnalysis Visit (N)integer1; 6

Predecessor:

CV.VISITNUM

LB.VISITNUM

VISITVisitinteger

VISIT 1; VISIT 6

Predecessor:

CV.VISIT

LB.VISIT

ADTAnalysis Dateintegerdate9yymmdd10.Date portion of CV.CVDTC or LB.LBDTC converted to numeric and displayed in a format such as date9yymmdd10
ABLFLBaseline Record FlagtextY

Derived: If CV.VISIT = "VISIT 1" then ABLFL = "Y".

BASEBaseline Valuefloat

Derived: Set BASE to AVAL from the record for that subject and parameter where ABLFL = "Y".

Populate BASE for additional visits by merging the value of BASE in the baseline record by USUBJID and PARAMCD.

CHGChange from Baselinefloat
Derived: Compute CHG = AVAL - BASE for that record. Only compute for post-baseline records.
PCHGPercent Change from Baselinefloat
Derived: Compute PCHG = (CHG / BASE) * 100. Only compute for post-baseline records.
CHGCAT1Change from Baseline Category 1text

Decline >=5%; Decline <5%; No decline

See Parameter Value Metadata
SRCDOMSource Datatext

CV; LB

Assigned: Set to the SDTM domain name that relates to the analysis value.

SRCVARSource Variabletext

CVSTRESN; LBSTRESN

Assigned: Set to the SDTM variable that relates to the analysis value.

SRCSEQSource Sequence Numberinteger


Predecessor: Set to the SDTM domain sequence number that relates to the analysis value, CV.CVSEQ or LB.LBSEQ.

...

Dataset wrap
Showtrue
NameADEFNTP
Dataset2
tableidadefntp
RowSTUDYIDUSUBJIDAAGEAGEUSEXRACETRT01PTRT01AITTFLHEIGHTWEIGHTBSAACEINHFLPARAMPARAMCDPARAMNAVALAVISITAVISITNVISITADTABLFLBASECHGPCHGCHGCAT1SRCDOMSRCVARSRCSEQ
1DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY119200.82YLeft Ventricular Ejection Fraction, Cal (%)LVEF_C167Visit 1 (Baseline)1VISIT 116MAY20222022-05-16Y67


CVCVTESTCD
Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-13
3
2DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY119200.82YRight Ventricular Ejection Fraction, Cal (%)RVEF_C274Visit 1 (Baseline)1VISIT 116MAY20222022-05-16Y74


CVCVTESTCD7
3DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY119200.82YN-Terminal ProB-type Natriuretic Peptide (ng/L)BNPPRONT340Visit 1 (Baseline)1VISIT 116MAY20222022-05-16Y40


LBLBTESTCD1
4DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY132321.08YLeft Ventricular Ejection Fraction, Cal (%)LVEF_C160Visit 6 (1 Year)6VISIT 606APR20232023-04-23
67-7-10.447761Decline >=5.0%CVCVTESTCD11
5DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY132321.08YRight Ventricular Ejection Fraction, Cal (%)RVEF_C261Visit 6 (1 Year)6VISIT 606APR20232023-04-23
74-13-17.567568Decline >=5.0%CVCVTESTCD15
6DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY132321.08Y

N-Terminal ProB-type Natriuretic Peptide (ng/L)

BNPPRONT3900Visit 6 (1 Year)6VISIT 606APR20232023-04-23
408602,150Increase >100 ng/LLBLBTESTCD2

...

Definexmltable
DatasetADEFMRI
LevelVariable
PurposeAnalysis
NameVariable
Variable NameVariable LabelTypeCodelist/Controlled TermsSource/Derivation/Comment
STUDYIDStudy Identifiertext

Predecessor: ADEFNTP.STUDYID

USUBJIDUnique Subject Identifiertext

Predecessor: ADEFNTP.USUBJID

BRTHDTDate of Birthintegerdate9yymmdd10.

Predecessor: ADEFNTP.BRTHDT

AAGEAnalysis Agefloat

Predecessor: ADEFNTP.AAGE

AGEUAge UnittextYEARS

Predecessor: ADEFNTP.AGEU

SEX

Sextext(SEX)

Predecessor: ADEFNTP.SEX

RACE

Racetext(RACE)

Predecessor: ADEFNTP.RACE

TRTSDT

Date of First Exposure to Treatment

Numdate9yymmdd10.Predecessor: ADEFNTP.TRTSDT
TRT01P

Planned Treatment for Period 01

textDrug A; Drug BPredecessor: ADEFNTP.TRT01P

ITTFL

Intent-To-Treat Population Flag

text

Y; N

Predecessor: ADEFNTP.ITTFL

BSABody Surface Area (m2)float


Predecessor: ADEFNTP.BSA

ACEINHFL

ACE Inhibitor Medications Flag

text

Y; N

Predecessor: ADEFNTP.ACEINHFL

BNPPRONT


integer


Derived: BNPPRONT = AVAL where PARAMCD =  ADEFNTP.BNPPRONT, and merge by USUBJID and AVISITN.

Note: There are many ways to add this including transposing the data.

PARAMParametertext

Left Ventricular Ejection Fraction, Cal (%);

Right Ventricular Ejection Fraction, Cal (%)

Predecessor: ADEFNTP.PARAM

PARAMCDParameter Codetext

LVEF_C;

RVEF_C

Predecessor: ADEFNTP.PARAMCD

PARAMNParameter (N)integer


Predecessor: ADEFNTP.PARAMN

AVALAnalysis Valuefloat

Predecessor: ADEFNTP.AVAL

AVISITAnalysis Visittext

Visit 1 (Baseline);

Visit 6 (1 Year)

Predecessor: ADEFNTP.AVISIT

AVISITNAnalysis Visit (N)integer1; 6

Predecessor: ADEFNTP.AVISITN

ADTAnalysis Datefloatdate9yymmdd10.Predecessor: ADEFNTP.ADT
ABLFLBaseline Record FlagtextYPredecessor: ADEFNTP.ABLFL
BASEBaseline Valuefloat
Predecessor: ADEFNTP.BASE
CHGChange from Baselinefloat
Predecessor: ADEFNTP.CHG
PCHGPercent Change from Baselinefloat
Predecessor: ADEFNTP.PCHG
CHGCAT1Change from Baseline Category 1text

Decline >=5.0%;

Decline <5.0%;

Increase >100 ng/L

Predecessor: ADEFNTP.CHGCAT1
Dataset wrap
Showtrue
Nameadefmri
Dataset2
tableidadefmri
RowSTUDYIDUSUBJIDBRTHDTTRT01PAAGEAGUSEXRACETRT01AITTFLBSAACEINHFLBNPPRONTPARAMPARAMCDPARAMNAVALAVISITAVISITNADTABLFLBASECHGPCHGCHGCAT1
1DMD-EFLGEDMD-EF-01-10107FEB20102010-02-07Drug A12.3YEARSMBLACK OR AFRICAN AMERICANDrug AY0.82Y40Left Ventricular Ejection Fraction, Cal (%)LVEF_C170Visit 1 (Baseline)116MAY20222022-05-16Y70


2DMD-EFLGEDMD-EF-01-10107FEB20102010-02-07Drug A12.3YEARSMBLACK OR AFRICAN AMERICANDrug AY0.82Y40Right Ventricular Ejection Fraction, Cal (%)RVEF_C275Visit 1 (Baseline)116MAY20222022-05-16Y75


3DMD-EFLGEDMD-EF-01-10107FEB20102010-02-07Drug A12.3YEARSMBLACK OR AFRICAN AMERICANDrug AY1.08Y900Left Ventricular Ejection Fraction, Cal (%)LVEF_C165Visit 6 (1 Year)606APR20232023-04-23
70-5-10.447761Decline >=5.0%
4DMD-EFLGEDMD-EF-01-10107FEB20102010-02-07Drug A12.3YEARSMBLACK OR AFRICAN AMERICANDrug AY1.08Y900Right Ventricular Ejection Fraction, Cal (%)RVEF_C270Visit 6 (1 Year)606APR20232023-04-23
75-5-17.567568Decline >=5.0%

...