Versions Compared

Key

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

...

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 Birthintegerdate9.

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

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-5
 

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 Treatmentintegerdate9.Derived: Date portion of DM.RFSTDTC converted to numeric and displayed in a format such as date9.
RFICDT

Date of Informed Consent

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

Date of Death

integerdate9.

Derived: Date portion of DM.DTHDT

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-6
converted to numeric and displayed in a format such as date9.

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.

...

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-8

In this example, variables BASE, CHG, PCHG, and CHGCAT1 were added to facilitate analyses of the efficacy endpoints.



Definexmltable
DatasetADCVNTP
LevelValueVariable
PurposeAnalysis
NameAVALVariable
Variable NameWhereVariable LabelTypeOriginCodelist/Controlled TermsSource/Derivation/Comment
AVALPARAMCD in ("LVEF_C", "RVEF_C")floatPredecessorCV.CVSTRESN
AVALPARAMCD = "BNPPRONT"floatPredecessorLB.LBSTRESN where LB.LBTESTCD = "BNPPRONT"
Definexmltable
DatasetADCVNTP
LevelValue
PurposeAnalysis
NameCHGCAT1
STUDYIDStudy Identifiertext
Predecessor: CV.STUDYID
USUBJIDUnique Subject Identifiertext
Predecessor: CV.USUBJID
BRTHDTDate of Birthintegerdate9.Predecessor: ADSL.BRTHDT
AAGEAnalysis Agefloat
Predecessor: ADSL.AAGE
AGEUAge Unittext

Predecessor: ADSL.AGEU

SEX

Sextext(SEX)

Predecessor: ADSL.SEX

VariableWhereTypeOriginDerivation/Comment
CHGCAT1PARAMCD in ("LVEF_C", "RVEF_C")textDerived

Categorize the value of CHGCAT1 as follows: If CHG >= 5.00 THEN CHGCAT1 = "Decline >=5%".

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-9

Else if CHG not missing and CHG < 5.00 THEN CHGCAT1 = "Decline <5%"

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-10

CHGCAT1PARAMCD = "BNPPRONT"textDerived

Categorize the value of CHCAT1 as follows: "Increase >100 ng/L"; "Increase <=100 ng/L"; "No increase"

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-11

Definexmltable
DatasetADCVNTP
LevelVariable
PurposeAnalysis
NameVariable

16

RACE

Racetext(RACE)Predecessor: ADSL.RACE
TRTSDT

Date of First Exposure to Treatment

integerdate9Predecessor: 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 Dateintegerdate9.Date portion of CV.CVDTC or LB.LBDTC converted to numeric and displayed in a format such as date9. 
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


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

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-12

SRCSEQSource Sequence Numberinteger


Predecessor:

CV.CVSEQ

LB.LBSEQ

Set to the SDTM domain sequence number that relates to the analysis value.

In this example, variables BASE, CHG, PCHG, and CHGCAT1 were added to facilitate analyses of the efficacy endpoints. the variables SRCDOM, SRCVAR, and SRCSEQ provide traceability to the combined source datasets. Thes tables below represent parameter value level lists for applicable variables.

Definexmltable
DatasetADCVNTP
LevelValue
PurposeAnalysis
NameAVAL
VariableWhereTypeOriginDerivation/Comment
AVALPARAMCD in ("LVEF_C", "RVEF_C")floatPredecessorCV.CVSTRESN
AVALPARAMCD = "BNPPRONT"floatPredecessorLB.LBSTRESN where LB.LBTESTCD = "BNPPRONT"
Definexmltable
DatasetADCVNTP
LevelValue
PurposeAnalysis
NameCHGCAT1



Predecessor: ADSL.AGEU

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

Predecessor:

CV.CVSEQ

LB.LBSEQ

Set to the SDTM domain sequence number that relates to the analysis value.
VariableWhereTypeOriginDerivation/Comment
CHGCAT1PARAMCD in ("LVEF_C", "RVEF_C")textDerived

Categorize the value of CHGCAT1 as follows: If CHG >= 5.00 THEN CHGCAT1 = "Decline >=5%".

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-9

Else if CHG GT 0 and CHG < 5.00 THEN CHGCAT1 = "Decline <5%"

Else if CHG <0 then CHGCAT1 = No Decline.

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-10

CHGCAT1PARAMCD = "BNPPRONT"textDerived
Variable NameVariable LabelTypeCodelist/Controlled TermsSource/Derivation/Comment
STUDYIDStudy IdentifiertextPredecessor: CV.STUDYIDUSUBJIDUnique Subject IdentifiertextPredecessor: CV.USUBJID
BRTHDTDate of Birthintegerdate9.Predecessor: ADSL.BRTHDT
AAGEAnalysis AgefloatPredecessor: ADSL.AAGEAGEUAge Unittext

SEX

Sextext(SEX)

Predecessor: ADSL.SEX

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-16

RACE

Racetext(RACE)Predecessor: ADSL.RACE
TRTSDT

Date of First Exposure to Treatment

integerdate9Predecessor: 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 Dateintegerdate9.Date portion of CV.CVDTC or LB.LBDTC converted to numeric and displayed in a format such as date9. 
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 BaselinefloatDerived: Compute CHG = AVAL - BASE for that record. Only compute for post-baseline records.PCHGPercent Change from BaselinefloatDerived: Compute PCHG = (CHG / BASE) * 100. Only compute for post-baseline records.
CHGCAT1Change from Baseline Category 1text

Decline >=5%; Decline <5%; Increase GT 100 ng/L

See Parameter Value Metadata
SRCDOMSource Datatext

CV; LB

Assigned:

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

SRCVARSource Variabletext

Categorize the value of CHCAT1 as follows: "Increase >100 ng/L"; "Increase <=100 ng/L"; "No increase"

Jira
showSummaryfalse
serverIssue Tracker (JIRA)
serverId85506ce4-3cb3-3d91-85ee-f633aaaf4a45
keyTAUGDMDCIS-

SRCSEQSource Sequence Numberinteger

11



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


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 116MAY2022Y74


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


LBLBTESTCD1
4DMD-EFLGEDMD-EF-01-10112.3YEARSMBLACK OR AFRICAN AMERICANDrug ADrug AY132321.08YLeft Ventricular Ejection Fraction, Cal (%)LVEF_C160Visit 6 (1 Year)6VISIT 606APR2023
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 606APR2023
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 606APR2023
408602,150Increase >100 ng/LLBLBTESTCD2

...