Versions Compared

Key

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

...

Definexmltable
Multipletrue
ExtraUser Notes
DatasetADAPCH
LevelVariable
PurposeAnalysis

Variable Name

Variable Label

Type

Controlled Terms

Source

Derivation

User Notes

STUDYID

Study Identifier

Char


RS.STUDYID



USUBJID

Unique Subject Identifier

Char


RS.USUBJID



SITEIDSite Identifier Char 
ADSL.SITEID 

RSSEQ

Sequence Number

Num


RS.RSSEQ


RSSEQ is included to provide traceability back to SDTM.
ASEQAnalysis Sequence NumberNum


After sorting by key variables, renumber all the records from 1 to n within a subject.Provides a sequence number to derived rows which are not present in RSSEQ.

ITTFL

Intent-to-Treat Population Flag

Char

“Y”, “N”

ADSL.ITTFL


Conditional; must include at least 1 population flag.

TRTP

Planned Treatment

Char

"DRUG A + SOC", "SOC"



Derivation should be defined by sponsor according to analysis needs.   

Conditional; should include at least 1 treatment variable (e.g., TRTP, TRTA, TRTSEQP, TRT01P).

PARAM

Parameter

Char

APCH1TN, APCH1PN

RS.RSTEST for responses to individual questions copied from SDTM.

Set PARAM to "APCH1-A: Total Acute Physiology Score - Analysis" for the derived total acute physiology score. Set PARAM to "APCH1-Total APACHE II Score - Analysis" for the derived total score.

PARAMCDParameter Code Char

APCH1TC, APCH1PC

RS.RSTESTCD for responses to individual questions copied from SDTM.

Set PARAMCD to "APCH1TPS" for the derived total acute physiology score and "APCH1TS" for the derived total score.

PARAMN

Parameter Number

Num

Number of the item in the order it appears on the form; assign a higher value to the derived total score record.

 


See Parameter Value Level List - ADAPCH table.


PARAMCDParameter Code Char



See Parameter Value Level List - ADAPCH table.


PARAMN

Parameter Number

Num



Number of the item in the order it appears on the form; assign a higher value to the derived total score record.

PARCAT1

Parameter Category 1

Char

"APACHE II

PARCAT1

Parameter Category 1

Char

"APACHE II"


Set to RS.RSCAT for records that come directly from SDTM and "APACHE II" for any derived records such as total scores.

VISIT

Visit Name

Char


RS.VISIT


RS.VISIT included for traceability.

VISITNUM

Visit Number

Num


RS.VISITNUM


RS.VISITNUM included for traceability.

AVISIT

Analysis Visit

Char




AVISIT represents the analysis visit for the record. Refer to the SAP for additional details.

AVISITN

Analysis Visit (N)

Num



A numeric representation of AVISIT. 

RSDTC

Date/Time of Finding

Char


RS.RSDTC


RS.RSDTC included for traceability.

ADT

Analysis Date

Num



Date portion of RS.RSDTC converted to numeric and displayed in a format such as DATE9.

For derived total score records where PARAMCD in("APCH1TPS" "APCH1TS"), this information will be copied from the individual records that comprise that instrument.


ADY

Analysis Relative Day

Num



ADT-ADSL.TRTSDT+1 if ADT≥TRTSDT; else, ADT-ADSL.TRTSDT if ADT<TRTSDT.This derivation is for example only.

RSORRES

Finding in Original Units

Char


RS.RSORRES



RSORRESU

Original Units

Char


RS.RSORRESU



AVAL

Analysis Value

Num



See Parameter Value Level List - ADAPCH table.

DTYPE

Derivation Type

Char

"WOC"




ABLFL

Baseline Record Flag

Char

“Y”


Set ABLFL="Y" on the record defined as the baseline value. This flag will only be populated on the derived acute physiology and APACHE II total score records (PARAMCD in("APCH1TPS" "APCH1TS")) in this example.
COUNTRYCountryChar
ADSL.COUNTRY

Permissible if needed for analysis. Generally represented using ISO 3166-1 Alpha-3. Note that regulatory agency specific requirements (e.g., US FDA) may require other terminologies; in such cases, follow regulatory requirements.    

REGION1

Geographic Region 1

Char


ADSL.REGION1


Permissible if needed for analysis.

REGION1N

Geographic Region 1 (N)

Num


ADSL.REGION1N


Permissible if needed for analysis.

...

Definexmltable
ExtraUser Notes
DatasetADAPCH
LevelValue
PurposeAnalysis
NameAVAL

Variable

Where

Type

Controlled Terms

Source

Derivation

User Notes

AVAL

PARAMCD NOT IN ("APCH1TPS" (APCH1-A: Total Acute Physiology Score - Analysis), "APCH1TS" (APCH1-Total APACHE II Score - Analysis))

Num



Set AVAL=RS.RSSTRESN.The analysis value is the result copied from SDTM.

AVAL

PARAMCD EQ "APCH1TPS" (APCH1-A: Total Acute Physiology Score - Analysis)

Num



The sum of RS.RSSTRESN for RS.RSTESTCD in ("APCH101"-"APCH112") if no questions are missing. Note that one out of the following two items: RSTESTCD="APCH105A" or "APCH105B" must be answered or RSTESTCD="APCH106A" or "APCH106B" but not both.

The expectation is that issues with conditional branching are fixed in SDTM RS.

AVAL

PARAMCD EQ "APCH1TS" (APCH1-Total APACHE II Score - Analysis)

Num



The sum of RS.RSSTRESN for RS.RSTESTCD in ("APCH101"-"APCH112") and "APCH114", "APCH115" if no questions are missing. Note that one out of the following two items: RSTESTCD="APCH105A" or "APCH105B" must be answered or RSTESTCD="APCH106A" or "APCH106B" but not both.

If a subject dies on or before Day 15, they are assigned the highest observed APACHE II score of any of the subjects at any time during the trial for their Total APACHE II Score at Day 15 (Day of Discharge).

The assignment of the highest observed APACHE II score is for illustration purposes only and not meant as a recommendation.

PARAMCD

PARAMCD NOT IN ("APCH1TPS" (APCH1-A: Total Acute Physiology Score - Analysis), "APCH1TS" (APCH1-Total APACHE II Score - Analysis))

Char

APCH1TC


See CDISC Controlled Terminology for Clinical Classification Test Codes. RS.RSTESTCD for responses to individual questions copied from SDTM.


PARAMCD

PARAMCD IN ("APCH1TPS" (APCH1-A: Total Acute Physiology Score - Analysis), "APCH1TS" (APCH1-Total APACHE II Score - Analysis))

Char

APCH1PC


See CDISC Controlled Terminology for Parameter Codes.


PARAM

PARAMCD NOT IN ("APCH1TPS" (APCH1-A: Total Acute Physiology Score - Analysis), "APCH1TS" (APCH1-Total APACHE II Score - Analysis))

Char

APCH1TN


See CDISC Controlled Terminology for Clinical Classification Test Names. RS.RSTEST for responses to individual questions copied from SDTM.


PARAM

PARAMCD IN ("APCH1TPS" (APCH1-A: Total Acute Physiology Score - Analysis), "APCH1TS" (APCH1-Total APACHE II Score - Analysis))

Char

APCH1PN


See CDISC Controlled Terminology for Parameter Names.


6.3   Example Analysis Dataset 

...