Treatment Dispensed and Returned

Illustrates Domains

DA
EC
EX

Illustrates Variables

DAGRPID
DACAT
DASTRESU
ECTRT
EPOCH
EXTRT


Content

The following example shows subjects who applied a lotion once per day, for a blinded study. The treatment was supplied as identical single-use containers, each of which held 1 day's worth of medication. The sponsor collected drug accountability and exposure information at each visit. The drug accountability data collected were represented in the DA domain and the collected exposure information in the EC domain. In this example, the volume remaining in the opened containers was not required to be collected.

da.xpt
Row 1:

Shows that at the first visit on day 1, 15 containers of study product were dispensed to the subject.

Row 2:Shows that at the second visit on day 15, 1 container of unopened study product was returned by the subject.
Row 3:Shows that at the second visit on day 15, 14 containers of opened study product were returned by the subject.
Row 4:

Shows that at the second visit on day 15, 15 additional containers of study product were dispensed to the subject.

Row 5:Shows that at the third visit on day 30, 2 containers of unopened study product were returned by the subject.
Row 6:Shows that at the third visit on day 30, 13 containers of opened study product were returned by the subject.

da.xpt

RowSTUDYIDDOMAINUSUBJIDDASEQDAGRPIDDATESTCDDATESTDACATDAORRESDAORRESUDASTRESCDASTRESNDASTRESU

VISITNUM

DADTCDADY
1PS012DA10111DISPAMTDispensed AmountStudy Product15CONTAINER1515

CONTAINER

12012-05-011
2PS012DA10121RETAMTReturned AmountUnopened Study Product1CONTAINER11CONTAINER22012-05-1515
3PS012DA10131RETAMTReturned AmountOpened Study Product14CONTAINER1414CONTAINER22012-05-1515
4PS012DA10142DISPAMTDispensed AmountStudy Product15CONTAINER1515

CONTAINER

22012-05-1515
5PS012DA10152RETAMTReturned AmountUnopened Study Product2CONTAINER22CONTAINER32012-05-3030
6PS012DA10162RETAMTReturned AmountOpened Study Product13CONTAINER1313CONTAINER32012-05-3030

The sponsor used a CRF that was designed as a log form to collect exposure information. This data was then represented in the EC domain. The record qualifier ECOCCUR was used to represent whether an application occurred. An ECOCCUR value of "N" indicates an application was not applied, not given, or missed.

ec.xpt
Row 1:Shows consecutive daily treatment applications.
Row 2:Shows that subject 101 missed a day of application, represented as ECOCCUR="N".
Row 3:Shows that subject 101 resumed applying the treatment on day 12 (ECOCCUR="Y") and finished the treatment on day 15.
Rows 4-8:Show the daily treatment applications for subject 102, including missed days.

ec.xpt

RowSTUDYIDDOMAINUSUBJIDECSEQECTRTECPRESPECOCCURECDOSEECDOSUECDOSFRMECDOSFRQEPOCHECSTDTCECENDTCECSTDYECENDY
1PS012EC1011Study DrugYY1APPLICATIONLOTIONQDTREATMENT2012-05-012012-05-10110
2PS012EC1012Study DrugYN
APPLICATIONLOTIONQDTREATMENT2012-05-112012-05-111111
3PS012EC1013Study DrugYY1APPLICATIONLOTIONQDTREATMENT2012-05-122012-05-151215
4PS012EC1021Study DrugYY1APPLICATIONLOTIONQDTREATMENT2012-06-012012-06-0818
5PS012EC1022Study DrugYN
APPLICATIONLOTIONQDTREATMENT2012-06-092012-06-0999
6PS012EC1023Study DrugYY1APPLICATIONLOTIONQDTREATMENT2012-06-102012-06-121012
7PS012EC1024Study DrugYN
APPLICATIONLOTIONQDTREATMENT2012-06-132012-06-131313
8PS012EC1025Study DrugYY1APPLICATIONLOTIONQDTREATMENT2012-06-142012-06-151415

The Exposure (EX) domain is a derived dataset where the data reflects the protocol-specified unit per study treatment based on the collected data (dispensing and exposure) and additional input from the protocol and randomization data. In this example, the containers have either 0.25 mg/g of drug X or 0.5 mg/g of drug Y. Because the weight of the tubes returned was not collected, the sponsor reported the dosage using application units. The concentration of the lotion was represented in EXPSTRG and EXPSTRGU. The sponsor used an ADaM dataset to provide more information on exposure; a study-specific algorithm was used to estimate exposure based on the number of used containers. This algorithm provided rules for exposure estimation when the drug accountability data were incomplete or missing. An example ADaM exposure dataset is provided in Section 7, Analysis Data.    

ex.xpt
Rows 1-2:Show the exposure for subject 101. This subject did not apply any drug on day 11. The dataset does not contain information on medications not taken, not given, or missed.
Rows 3-5:Show the exposure for subject 102. This subject did not apply any drug on days 9 and 13.

ex.xpt

RowSTUDYIDDOMAINUSUBJIDEXSEQEXTRTEXDOSEEXDOSUEXDOSFRMEXDOSFRQEXPSTRGEXPSTRGUEPOCHEXSTDTCEXENDTCEXSTDYEXENDY
1PS012EX1011Drug X1APPLICATIONLOTIONQD0.25mg/gTREATMENT2012-05-012012-05-10110
2PS012EX1012Drug X1APPLICATIONLOTIONQD0.25mg/gTREATMENT2012-05-122012-05-151215
3PS012EX1021Drug Y1APPLICATIONLOTIONQD0.50mg/gTREATMENT2012-06-012012-06-0818
4PS012EX1022Drug Y1APPLICATIONLOTIONQD0.50mg/gTREATMENT2012-06-102012-06-121012
5PS012EX1023Drug Y1APPLICATIONLOTIONQD0.50mg/gTREATMENT2012-05-142012-05-151415