For each DKA event, the relevant data collected on the study CRFs were represented in the AE dataset. The records with AETERM = "Diabetic Ketoacidosis" are the trial disease milestones previously defined in the TM dataset. These AE records include the MIDS variable with the value "DKA(n)". Because these are records for disease milestones rather than associated records, the variables RELMIDS and MIDSDTC are not needed. The variables AESTDTC and AESPID, corresponding with the AE record number from the CRF, were used by the sponsor to determine the chronological order of the events. The severity of the DKA event was based on the set of criteria used by the investigator. The name of the set of criteria used was collected on the CRF and is recorded in the NSV AESSEVCN. The severity criteria are used to standardize the assessment of DKA severity by investigators. The NSV AESTDSEV is used to represent the severity of the each DKA as determined by the set of criteria represented in the . The use of these NSVs is being discussed and may be changed. Note that the permissible variable, AESEV, is included, but it is blank for all DKA events.
In this study, the sponsor also collected whether cerebral edema occurred with the DKA event. Because the AE dataset only contains information on events that have occurred, the sponsor created an FAAE dataset to represent the information collected on the example CRF regarding the occurrence of cerebral edema. Any cerebral edema that occurred was represented in the AE dataset. The severity of any cerebral edema was represented in AESEV.
Note that:
- In this example, the sponsor did not represent the information on whether a DKA occurred.
- Some expected variables in the AE domain (e.g., AELLT, AEPTCD, AEHLT) have not been shown in the example to save space. Refer to the SDTMIG for examples of how to use these expected variables.
The AEACNDEV variable was used to represent any actions taken with a device with respect to an adverse event; the NSV AERLDEV was used to represent the relationship of the adverse event to a device. If a single device was evaluated with respect to the adverse event, the evaluated device is identified by the value of the SPDEVID variable. When more than 1 device was evaluated with respect to the adverse event, both the AEACNDEV variable and the AERLDEV NSV were assigned the value "MULTIPLE" and the associated data for each question for each device provided using the FAAE dataset. In this case, each evaluated device is identified by the value of the SPDEVID variable in the FAAE dataset and the SPDEVID variable in the AE dataset is blank.
ae.xpt
Row 1: | Shows that a DKA event occurred for subject 001. This AE was pre-specified (AEPRESP="Y"). The MIDS variable populated with "DKA1" indicates that this is the first on-study DKA event. AESPID is the record number of this AE collected on the AE CRF. |
---|
Row 2: | Shows the second DKA event for subject 001. This subject was re-educated on the use of their diabetic devices (AEACNOTH); this was not considered to be an action with the device, as no changes were made to the instruction manuals for the devices. MIDS is assigned to "DKA2" to indicate this is the second event. |
---|
Rows 3, 5: | Show the first on-study DKA events for subjects 012 and 014, respectively. MIDS is assigned to "DKA1" for both these events. The SPDEVID variable is blank, the AEACNDEV variable is populated with "NONE", and the NSV AERLDEV is populated with "NOT RELATED" because the investigator indicated on the CRF that there was no relationship or action taken with any device. The devices in use at the time of the event are represented in the DX domain. |
---|
Row 4: | Shows the second DKA event data for subject 012. Only 1 device, the "Automated Insulin Delivery System" identified in the SPDEVID variable, was evaluated with respect to this event. The action taken with the device ("CHANGED TO AUTOMATIC INSULIN DELIVERY MODE") is recorded in the AEACNDEV variable; the NSV AERLDEV indicates that there was a possible relationship with the device. Details of changes to device settings may be represented in the Device In Use (DU) domain. |
---|
Row 6: | Shows the cerebral edema adverse event associated with the first on-study DKA event data for subject 014. This record was collected using the regular study AE CRF, which also allowed for evaluation of devices with respect to each AE. |
---|
ae.xpt
Row | STUDYID | DOMAIN | USUBJID | SPDEVID | AESEQ | AESPID | AETERM | AEDECOD | AEPRESP | AESER | AESEV | AEACN | AEACNOTH | AEACNDEV | AEREL | AEOUT | AESHOSP | AECONTRT | AESTDTC | AEENDTC | AESTDY | MIDS |
| AERLDEV | AESTDSEV | AESSEVCN |
---|
1 | T001 | AE | 001 |
| 1 | AE0007 | Diabetic ketoacidosis | Diabetic ketoacidosis | Y | Y |
| DOSE NOT CHANGED |
| MULTIPLE | NOT RELATED | RECOVERED/RESOLVED | Y | Y | 2013-09-01 | 2013-09-07 | 27 | DKA1 |
| MULTIPLE | MILD | ADA Version x |
---|
2 | T001 | AE | 001 |
| 2 | AE0049 | Diabetic ketoacidosis | Diabetic ketoacidosis | Y | Y |
| DOSE INCREASED | RE-EDUCATION ON DEVICE USE | MULTIPLE | NOT RELATED | RECOVERED/RESOLVED WITH SEQUELAE | Y | Y | 2014-10-24 | 2014-11-03 | 445 | DKA2 |
| MULTIPLE | SEVERE | ADA Version x |
---|
3 | T001 | AE | 012 |
| 1 | AE0034 | Diabetic ketoacidosis | Diabetic ketoacidosis | Y | Y |
| DOSE NOT CHANGED |
| NONE | NOT RELATED | RECOVERED/RESOLVED | Y | Y | 2015-05-09 | 2015-05-11 | 26 | DKA1 |
| NOT RELATED | MODERATE | ISPD Version x |
---|
4 | T001 | AE | 012 | Automated Insulin Delivery System | 2 | AE0042 | Diabetic ketoacidosis | Diabetic ketoacidosis | Y | Y |
| DOSE INCREASED |
| CHANGED TO AUTOMATIC INSULIN DELIVERY MODE | NOT RELATED | RECOVERED/RESOLVED | Y | Y | 2016-03-19 | 2016-03-21 | 341 | DKA2 |
| POSSIBLY RELATED | MILD | ISPD Version x |
---|
5 | T001 | AE | 014 |
| 1 | AE0067 | Diabetic ketoacidosis | Diabetic ketoacidosis | Y | Y |
| DOSE NOT CHANGED |
| NONE | NOT RELATED | RECOVERED/RESOLVED | Y | Y | 2015-08-14 | 2015-08-19 | 39 | DKA1 |
| NOT RELATED | SEVERE | ISPD Version x |
---|
6 | T001 | AE | 014 |
| 2 | AE0070 | Cerebral edema | Cerebral edema | Y | Y | MILD | DOSE NOT CHANGED |
| NONE | NOT RELATED | RECOVERED/RESOLVED |
|
| 2015-08-15 | 2015-08-19 | 40 | DKA1 |
| NOT RELATED |
|
|
---|
AE NSV Metadata
The FA domain was used to represent information for both of the following:
- The actions taken and relationships with multiple devices with respect to individual DKA events. For these records, the value of the FATESTCD variable is "RLDEV" or "ACNDEV" and the SPDEVID variable identifies the device that was evaluated for action taken or relationship with the DKA event.
- The occurrence of the pre-specified adverse event, cerebral edema, in association with each DKA event. For these records, the value of the FATESTCD variable is "OCCUR". The pre-specified adverse event is identified in the FAOBJ variable and the value of the FAORRES variable indicates whether or not the adverse event occurred. (More guidance on the representation of pre-specified adverse events can be found in the SDTMIG.) The SPDEVID variable is blank on these records because the occurrence of cerebral edema was not associated with any device.
For all records, the MIDS variable was used to associate the information with a particular DKA event. The RELMIDS variable is populated with a textual description of the temporal relationship between the observation and the disease milestone named in MIDS. Note that controlled vocabulary has not yet been developed for RELMIDS. In this example, the sponsor elected to populate RELMIDS as "ENTIRE EVENT" to reflect that the sponsor evaluated the observation of interest throughout the DKA event. Sponsors may use more specific textual terms to reflect the relationship if needed (e.g., BEFORE, AFTER, DURING).
The FALNKID variable was included in the dataset and populated for the device evaluation records (where FATESTCD is "RLDEV" or "ACNDEV") so that the collected relationships between multiple device evaluations and specific AE records could be represented in the same way for both DKA events and regular adverse events. The FALNKID variable is not populated on the cerebral edema occurrence records (where FATESTCD = "OCCUR") because the sponsor considered the MIDS-defined association with the DKA event to be sufficient. If the MIDS variable had not been used in the study, the collected relationships between the DKA event record in the AE dataset, the cerebral edema occurrence record in the FA dataset, and (when present) the cerebral edema adverse event record in AE would be represented using RELREC.
A contingent visit was assigned based on the specific DKA event occurrence for each subject. The VISITNUM variable was assigned the appropriate contingency visit number.
faae.xpt
Rows 1-2: | Show the results of the evaluations of the "Electronic Insulin Pump" device with respect to the subject's first on-study DKA event. |
---|
Rows 3-4: | Show the results of the evaluations of the "Real-Time Continuous Glucose Monitor" device with respect to the subject's first on-study DKA event. |
---|
Rows 5, 10-13: | Show whether the subject experienced a cerebral edema adverse event that was associated with the DKA event identified in the variable MIDS. |
---|
Rows 6-7: | Show the results of the evaluations of the "Electronic Insulin Pump" device with respect to the subject's second on-study DKA event. |
---|
Rows 8-9: | Show the results of the evaluations of the "Real-Time Continuous Glucose Monitor" device with respect to the subject's second on-study DKA event. |
---|
faae.xpt
Row | STUDYID | DOMAIN | USUBJID | SPDEVID | FASEQ | FALNKID | FATESTCD | FATEST | FAOBJ | FAORRES | FASTRESC | VISITNUM | VISIT | MIDS | RELMIDS | MIDSDTC |
---|
1 | T001 | FA | 001 | Electronic Insulin Pump | 1 | AE0007 | | Relationship to Device | Diabetic ketoacidosis | NOT RELATED | NOT RELATED | 99.1 | DKA CONTINGENT VISIT 1 | DKA1 | ENTIRE EVENT | 2013-09-01 |
---|
2 | T001 | FA | 001 | Electronic Insulin Pump | 2 | AE0007 | | Actions Taken with Device | Diabetic ketoacidosis | NONE | NONE | 99.1 | DKA CONTINGENT VISIT 1 | DKA1 | ENTIRE EVENT | 2013-09-01 |
---|
3 | T001 | FA | 001 | Real-Time Continuous Glucose Monitor | 3 | AE0007 | | Relationship to Device | Diabetic ketoacidosis | NOT RELATED | NOT RELATED | 99.1 | DKA CONTINGENT VISIT 1 | DKA1 | ENTIRE EVENT | 2013-09-01 |
---|
4 | T001 | FA | 001 | Real-Time Continuous Glucose Monitor | 4 | AE0007 | | Actions Taken with Device | Diabetic ketoacidosis | NONE | NONE | 99.1 | DKA CONTINGENT VISIT 1 | DKA1 | ENTIRE EVENT | 2013-09-01 |
---|
5 | T001 | FA | 001 |
| 5 |
| OCCUR | Occurrence Indicator | Cerebral edema | | N | 99.1 | DKA CONTINGENT VISIT 1 | DKA1 | ENTIRE EVENT | 2013-09-01 |
---|
6 | T001 | FA | 001 | Electronic Insulin Pump | 6 | AE0049 | RLDEV | Relationship to Device | Diabetic ketoacidosis | NOT RELATED | NOT RELATED | 99.2 | DKA CONTINGENT VISIT 2 | DKA2 | ENTIRE EVENT | 2014-10-24 |
---|
7 | T001 | FA | 001 | Electronic Insulin Pump | 7 | AE0049 | | Actions Taken with Device | Diabetic ketoacidosis | CATHETER REPLACED | COMPONENT REPLACED | 99.2 | DKA CONTINGENT VISIT 2 | DKA2 | ENTIRE EVENT | 2014-10-24 |
---|
8 | T001 | FA | 001 | Real-Time Continuous Glucose Monitor | 8 | AE0049 | RLDEV | Relationship to Device | Diabetic ketoacidosis | NOT RELATED | NOT RELATED | 99.2 | DKA CONTINGENT VISIT 2 | DKA2 | ENTIRE EVENT | 2014-10-24 |
---|
9 | T001 | FA | 001 | Real-Time Continuous Glucose Monitor | 9 | AE0049 | ACNDEV | Actions Taken with Device | Diabetic ketoacidosis | REPLACED SENSOR | COMPONENT REPLACED | 99.2 | DKA CONTINGENT VISIT 2 | DKA2 | ENTIRE EVENT | 2014-10-24 |
---|
10 | T001 | FA | 001 |
| 10 |
| OCCUR | Occurrence Indicator | Cerebral edema | N | N | 99.2 | DKA CONTINGENT VISIT 2 | DKA2 | ENTIRE EVENT | 2014-10-24 |
---|
11 | T001 | FA | 012 |
| 1 |
| OCCUR | Occurrence Indicator | Cerebral edema | N | N | 99.1 | DKA CONTINGENT VISIT 1 | DKA1 | ENTIRE EVENT | 2015-05-09 |
---|
12 | T001 | FA | 012 |
| 2 |
| OCCUR | Occurrence Indicator | Cerebral edema | N | N | 99.2 | DKA CONTINGENT VISIT 2 | DKA2 | ENTIRE EVENT | 2016-03-19 |
---|
13 | T001 | FA | 014 |
| 1 |
| OCCUR | Occurrence Indicator | Cerebral edema | Y | Y | 99.1 | DKA CONTINGENT VISIT 1 | DKA1 | ENTIRE EVENT | 2015-08-14 |
---|
The RELREC dataset is used to store relationships between the different SDTM datasets. The disease milestone timing variable, MIDS, provides a way to link records associated with a disease milestone without the need for additional linking via RELREC.
This RELREC table shows the relationship of the records in FAAE to the AE domain.
relrec.xpt
relrec.xpt
Row | STUDYID | RDOMAIN | USUBJID | IDVAR | IDVARVAL | RELTYPE | RELID |
---|
1 | T001 | AE |
| AESPID |
| ONE | 1 |
---|
2 | T001 | FAAE |
| |
| MANY | 1 |
---|