Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated VLM table structure

...

Definexmltable
Multipletrue
LevelDataset
PurposeAnalysis

Dataset NameLabel

Description

Class

Structure

Purpose

Keys

Class

Location

DocumentationLocation

ADSL

Subject-Level Analysis Dataset

SUBJECT LEVEL ANALYSIS DATASET

One record per subject.

AnalysisUSUBJIDSUBJECT LEVEL ANALYSIS DATASETADaMIGadsl.xptADSL.SAS
ADCVNTPCV EF and NT-proBNP Analysis

BASIC DATA STRUCTURE

One record per subject per analysis visit per parameter.AnalysisUSUBJID, AVISITN, PARAMN

BASIC DATA STRUCTURE

adcvntp.xpt

SAPAnalysis Dataset

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

adcvntp.xpt
ADCVCMRCV CMR Ejection Fraction Analysis 

BASIC DATA STRUCTURE

One record per subject per analysis visit per parameter.AnalysisUSUBJID, AVISITN, PARAMN

BASIC DATA STRUCTURE

Analysis Dataset

adcvcmr.xpt

SAP

ADSL

The ADSL contains subject characteristics and covariates that are important for analyses. Stratification variables can be created in the ADSL to subset the data. More than one SDTM dataset may be used as input to the ADSL. This is a simplified example ADSL dataset; the ADaMIG should be referenced for additional variables.

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

...

Definexmltable
DatasetADSL
LevelVariable
PurposeAnalysis
NameVariable
Variable NameVariable LabelTypeCodelist/Controlled Terms
/Format
Source
/Derivation/Comment
STUDYIDStudy Identifier
Char
text
Predecessor: DM.STUDYID
USUBJIDUnique Subject Identifier
Char
text
Predecessor: DM.USUBJID
BRTHDTDate of Birth
Num
integerdate9.

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 Age
Num
float
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.
AGEAge
Num
integer
Predecessor: DM.AGE
AGEUAge Units
Char
textYEARSPredecessor: DM.AGEU

SEX

Sex
Char
text(SEX)Predecessor: DM.SEX

RACE

Race
Num
text(RACE)Predecessor: DM.RACE
TRTSDTDate of First Exposure to Treatment
Num
integerdate9.Derived: Date portion of DM.RFSTDTC converted to numeric and displayed in a format such as date9.
RFICDT

Date of Informed Consent

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

Date of Death

Num
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

Char
textYPredecessor: DM.DTHFL
TRT01P

Planned Treatment for Period 01

Char
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

Char
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

Char

text

Y; N

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

ACEINHFL

ACE Inhibitor Medications Flag

Char

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

Num

float


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

WEIGHTSC

Weight (kg) at Screening

Num

float


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

BSASC

Body Surface Area at Screening

Num

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.

Dataset wrap
Showtrue
NameADSL
Dataset2
tableidadsl
RowSTUDYIDUSUBJIDBRTHDTAAGEAGEAGEUSEXRACETRTSDTRFICDTDTHDTDTHFLTRT01PITTFLACEINHFLHEIGHTSCWEIGHTSCBSASC
1DMD-EFLGEDMD-EF-01-10107FEB201012.312YEARSMBLACK OR AFRICAN AMERICAN16JUN202216JUN2022

Drug AYY119200.82
2DMD-EFLGEDMD-EF-01-10101MAY200814.114YEARSMASIAN13JUN202213JUN2022

Drug AYY115300.95
3DMD-EFLGEDMD-EF-01-10110JUL200319.019YEARSMNATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER

15JUL2022

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

15JUL2022

Drug BYN140451.30
4DMD-EFLGEDMD-EF-01-10115JAN199923.723YEARSMWHITE06SEP202206SEP202223NOV2023YDrug BYY132421.21

...

Definexmltable
DatasetADCVNTP
LevelValue
PurposeAnalysis
OIDAVAL
DatasetVariableWhereTypeOriginDerivation/Comment
ADCVNTPAVALPARAMCD in ("LVEF_C", "RVEF_C")
Num
floatPredecessor
Set to
Predecessor:  CV.CVSTRESN 
ADCVNTPAVALPARAMCD = "BNPPRONT"
Num
floatPredecessor
Set to
Predecessor:  LB.LBSTRESN where LB.LBTESTCD = "BNPPRONT"
ADCVNTPCHGCAT1PARAMCD in ("LVEF_C", "RVEF_C")text
Char

Derived: 

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

ADCVNTPCHGCAT1PARAMCD = "BNPPRONT"
Char
text

Derived:

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
Variable NameVariable LabelTypeCodelist/Controlled Terms
/Format
Source
/Derivation/Comment
STUDYIDStudy Identifier
Char
text
Predecessor: CV.STUDYID
USUBJIDUnique Subject Identifier
Char
text
Predecessor: CV.USUBJID
BRTHDTDate of Birth
Num
integer
Date9
date9.Predecessor: ADSL.BRTHDT
AAGEAnalysis Age
Num
float
Predecessor: ADSL.AAGE
AGEUAge Unit
Char
text
YEARS


Predecessor: ADSL.AGEU

SEX

Sex
Char
text(SEX)

Predecessor: ADSL.SEX

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

RACE

Race
Num
text(RACE)Predecessor: ADSL.RACE
TRTSDT

Date of First Exposure to Treatment

Num
integerdate9Predecessor: ADSL.TRTSDT
TRT01P

Planned Treatment for Period 01

Char
textDrug A; Drug BPredecessor: ADSL.TRT01P
TRT01A

Actual Treatment for Period 01

Char
textDrug A; Drug BPredecessor: ADSL.TRT01A

ITTFL

Intent-To-Treat Population Flag

Char

text

Y; N

Predecessor: ADSL.ITTFL

HEIGHT

Height (cm)

Num

float


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

WEIGHT

Weight (kg)

Num

float


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

BSABody Surface Area (m2)
Num
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

Char

text

Y; N

Predecessor: ADSL.,ACEINHFL
PARAMParameter
Char
text

Left Ventricular Ejection Fraction, Cal (%);

Right Ventricular Ejection Fraction, Cal (%);

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

Predecessor:

CV.CVTEST

LB.LBTEST

PARAMCDParameter Code
Char
text

LVEF_C;

RVEF_C;

BNPPRONT

Predecessor:

CV.CVTESTCD

LB.LBTESTCD

PARAMNParameter (N)
Num
integer

1; 2; 3;

Assigned:

Number PARAMCD as follows:

LVEF_C = "1"

RVEF_C = "2"

BNPPRONT = "3"

AVALAnalysis Value
Num
float

See Parameter Value Metadata

AVISITAnalysis Visit
Char
text

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)
Num
integer1; 6

Predecessor:

CV.VISITNUM

LB.VISITNUM

VISITVisit
Num
integer

VISIT 1; VISIT 6

Predecessor:

CV.VISIT

LB.VISIT

ADTAnalysis Date
Num
integerdate9.Date portion of CV.CVDTC or LB.LBDTC converted to numeric and displayed in a format such as date9. 
ABLFLBaseline Record Flag
Char
textY

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

BASEBaseline Value
Num
float

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 Baseline
Num
float
Derived: Compute CHG = AVAL - BASE for that record. Only compute for post-baseline records.
PCHGPercent Change from Baseline
Num
float
Derived: Compute PCHG = (CHG / BASE) * 100. Only compute for post-baseline records.
CHGCAT1Change from Baseline Category 1
Char
text

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

See Parameter Value Metadata
SRCDOMSource Data
Char
text

CV; LB

Assigned:

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

SRCVARSource Variable
Char
text


Assigned: Set to the SDTM variable that

relates to

relates to the analysis value.

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

SRCSEQSource Sequence Numberinteger
Num


Predecessor:

CV.CVSEQ

LB.LBSEQ

Set to the SDTM domain sequence number that relates to the analysis value.
Dataset wrap
Showtrue
Nameadcvntp
Dataset2
tableidadcvntp
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

...

Definexmltable
DatasetADCVCMR
LevelVariable
PurposeAnalysis
NameVariable
Variable NameVariable LabelTypeCodelist/Controlled Terms
/Format
Source
/Derivation/Comment
STUDYIDStudy Identifier
Char
text

Predecessor: ADCVNTP.STUDYID

USUBJIDUnique Subject Identifier
Char
text

Predecessor: ADCVNTP.USUBJID

BRTHDTDate of Birth
Num
integerdate9.

Predecessor: ADCVNTP.BRTHDT

AAGEAnalysis Age
Num
float

Predecessor: ADCVNTP.AAGE

AGEUAge Unit
Char
textYEARS
ADCVNTPL

Predecessor: ADCVNTP.AGEU

SEX

Sex
Char
text(SEX)
ADCVNTPL

Predecessor: ADCVNTP.SEX

RACE

Race
Num
text(RACE)
ADCVNTPL

Predecessor: ADCVNTP.RACE

TRTSDT

Date of First Exposure to Treatment

Numdate9.Predecessor: ADCVNTP.TRTSDT
TRT01P

Planned Treatment for Period 01

Char
textDrug A; Drug BPredecessor: ADCVNTP.TRT01P

ITTFL

Intent-To-Treat Population Flag

Char

text

Y; N

Predecessor: ADCVNTP.ITTFL

BSABody Surface Area (m2)
Num
float


Predecessor: ADCVNTP.BSA

ACEINHFL

ACE Inhibitor Medications Flag

Char

text

Y; N

Predecessor: ADCVNTP.ACEINHFL

BNPPRONT

Num


integer


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

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

PARAMParameter
Char
text

Left Ventricular Ejection Fraction, Cal (%);

Right Ventricular Ejection Fraction, Cal (%)

Predecessor: ADCVNTP.PARAM

PARAMCDParameter Code
Char
text

LVEF_C;

RVEF_C

Predecessor: ADCVNTP.PARAMCD

PARAMNParameter (N)
Num
integer


Predecessor: ADCVNTP.PARAMN

AVALAnalysis Value
Num
f;oat

Predecessor: ADCVNTP.AVAL

AVISITAnalysis Visit
Char
text

Visit 1 (Baseline);

Visit 6 (1 Year)

Predecessor: ADCVNTP.AVISIT

AVISITNAnalysis Visit (N)
Num
integer1; 6

Predecessor: ADCVNTP.AVISITN

ADTAnalysis Date
Num
floatdate9.Predecessor: ADCVNTP.ADT
ABLFLBaseline Record Flag
Char
textYPredecessor: ADCVNTP.ABLFL
BASEBaseline Value
Num
float
Predecessor: ADCVNTP.BASE
CHGChange from Baseline
Num
float
Predecessor: ADCVNTP.CHG
PCHGPercent Change from Baseline
Num
float
Predecessor: ADCVNTP.PCHG
CHGCAT1Change from Baseline Category 1
Char
text

Decline >=5.0%;

Decline <5.0%;

Increase >100 ng/L

Predecessor: ADCVNTP.CHGCAT1
Dataset wrap
Showtrue
Nameadcvcmr
Dataset2
tableidadcvcmr
RowSTUDYIDUSUBJIDBRTHDTTRT01PAAGEAGUSEXRACETRT01AITTFLBSAACEINHFLBNPPRONTPARAMPARAMCDPARAMNAVALAVISITAVISITNADTABLFLBASECHGPCHGCHGCAT1
1DMD-EFLGEDMD-EF-01-10107FEB2010Drug A12.3YEARSMBLACK OR AFRICAN AMERICANDrug AY0.82Y40Left Ventricular Ejection Fraction, Cal (%)LVEF_C170Visit 1 (Baseline)116MAY2022Y70


2DMD-EFLGEDMD-EF-01-10107FEB2010Drug A12.3YEARSMBLACK OR AFRICAN AMERICANDrug AY0.82Y40Right Ventricular Ejection Fraction, Cal (%)RVEF_C275Visit 1 (Baseline)116MAY2022Y75


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

...