Date/Time of Define-XML document generation: 2021-06-03T19:32:34Z

Define-XML version: 2.0.0

Stylesheet version: 2018-11-21

Datasets

Datasets
DatasetDescriptionClass StructurePurposeKeysDocumentationLocation
DMDemographicsSPECIAL PURPOSEOne record per subjectTabulationSTUDYID, USUBJIDdm.xpt
EXExposureINTERVENTIONSOne record per constant dosing interval per subjectTabulationSTUDYID, USUBJID, EXTRT, EXSTDTCex.xpt
XBSequencing DataFINDINGSOne record per microbiology specimen finding per time point per visit per subjectTabulationSTUDYID, USUBJID, XBTESTCD, XBDTCxb.xpt

Go to the top of the Define-XML document


Demographics (DM)

DM (Demographics) - SPECIAL PURPOSE Location: dm.xpt
VariableLabel / DescriptionTypeRoleLength or Display FormatControlled Terms or ISO FormatOrigin / Source / Method / Comment
STUDYIDStudy IdentifiertextReq8
Protocol
DOMAINDomain AbbreviationtextReq2DOMAIN
  • • "DM" = "Demographics"
  • • "EX" = "Exposure"
  • • "XB" = "Microbiology Specimen"
Assigned

"DM"

USUBJIDUnique Subject IdentifiertextReq22
Derived
Concatenation of STUDYID, SITEID and SUBJID
SUBJIDSubject Identifier for the StudytextReq8
CRF

Annotated CRF [25 ]

RFSTDTCSubject Reference Start Date/TimedatetimeExpISO 8601
Derived
First date/time of study drug else Randomization date/time OR Enrollment date/time for subject.Null for screen failures.
RFENDTCSubject Reference End Date/TimedatetimeExpISO 8601
Derived
Maximum of Visit date/Maximum of disposition date, whichever is greater.Null for Screen Failures.
RFXSTDTCDate/Time of First Study TreatmentdatetimeExpISO 8601
Derived
First date/time of study drug exposure date
RFXENDTCDate/Time of Last Study TreatmentdatetimeExpISO 8601
Derived
Latest date/time of study drug exposure
RFICDTCDate/Time of Informed ConsentdatetimeExpISO 8601
Derived
Date/time of informed consent obtained
RFPENDTCDate/Time of End of ParticipationdatetimeExpISO 8601
Derived
Set to Date/time when subject ended participation in a trial.
DTHDTCDate/Time of DeathdatetimeExpISO 8601
Derived
Date/time of death when Disposition mentioned as 'DEATH'.
DTHFLSubject Death FlagtextExp1NY1
  • • "Y" = "Y"
Derived
Populate Death flag is 'Y' when Standardized Disposition Term is 'DEATH'
SITEIDStudy Site IdentifiertextReq4
Assigned

Rename SITEMNEMONIC as SITEID

INVIDInvestigator IdentifiertextPerm7
Assigned

Assigned from source database by merging on StudyID and SiteID

INVNAMInvestigator NametextPerm37
Assigned

Assigned from source database by merging on StudyID and SiteID

BRTHDTCDate/Time of BirthdatetimePermISO 8601
CRF

Annotated CRF [25 ]

AGEAgeintegerExp8
Derived
If AGEU=YEARS then AGE=int((Informed Consent date - birthdate)/365.25)
AGEUAge UnitstextExp5AGEU
  • • "YEARS" = "YEARS"
Assigned

Rename AGEU_001 as AGEU

SEXSextextReq1SEX
  • • "F" = "F"
  • • "M" = "M"
CRF

Annotated CRF [25 ]

RACERacetextExp41RACE

[7 Terms]

CRF

Annotated CRF [25 ]

ETHNICEthnicitytextPerm22ETHNIC
  • • "HISPANIC OR LATINO" = "HISPANIC OR LATINO"
  • • "NOT HISPANIC OR LATINO" = "NOT HISPANIC OR LATINO"
  • • "NOT REPORTED" = "NOT REPORTED"
CRF

Annotated CRF [25 ]

ARMCDPlanned Arm CodetextReq9
Assigned

Assigned from Trial Arms based on Randomization file.

ARMDescription of Planned ArmtextReq27
Assigned

Assigned from Trial Arms based on Randomization file.

ACTARMCDActual Arm CodetextReq1
Assigned

To be derived for submission from ADSL.

ACTARMDescription of Actual ArmtextReq1
Assigned

To be derived for submission from ADSL.

COUNTRYCountrytextReq3ISO3166(CL.ISO3166)

ISO3166

Assigned

Assigned from source database by merging on StudyID and SiteID

Go to the top of the Define-XML document


Exposure (EX)

EX (Exposure) - INTERVENTIONS Location: ex.xpt
VariableLabel / DescriptionTypeRoleLength or Display FormatControlled Terms or ISO FormatOrigin / Source / Method / Comment
STUDYIDStudy IdentifiertextReq8
Protocol
DOMAINDomain AbbreviationtextReq2DOMAIN
  • • "DM" = "Demographics"
  • • "EX" = "Exposure"
  • • "XB" = "Microbiology Specimen"
Assigned

"EX"

USUBJIDUnique Subject IdentifiertextReq22
Derived
DM.USUBJID
EXSEQSequence NumberintegerReq8
Derived
Sequential number identifying records within each USUBJID in the domain.
EXLNKIDLink IDtextPerm34
Derived
Concatenate Link Group ID, Location and Laterality when Link Group ID is present
EXLNKGRPLink Group IDtextPerm13
Derived
Related vaccination number to assist with Reactogenicity assessment
EXTRTName of TreatmenttextReq8
CRF

Annotated CRF [106 108 ]

EXCATCategory of TreatmenttextPerm23Category of Treatment
  • • "INVESTIGATIONAL PRODUCT" = "INVESTIGATIONAL PRODUCT"
Assigned
EXSCATSubcategory of TreatmenttextPerm11Subcategory of Treatment
  • • "VACCINATION" = "VACCINATION"
Assigned
EXDOSEDoseintegerExp8
CRF

Annotated CRF [106 108 ]

EXDOSUDose UnitstextExp7EXDOSU
  • • "mcg" = "Microgram"
  • • "SYRINGE" = "SYRINGE"
  • • "mL" = "Milliliter"
  • • "ug" = "Microgram"
CRF

Annotated CRF [106 108 ]

EXDOSFRMDose FormtextExp9FRM
  • • "INJECTION" = "INJECTION"
CRF

Annotated CRF [106 108 ]

EXROUTERoute of AdministrationtextPerm13ROUTE

[14 Terms]

CRF

Annotated CRF [106 108 ]

EXLOCLocation of Dose AdministrationtextPerm14LOC

[12 Terms]

CRF

Annotated CRF [106 108 ]

EXLATLateralitytextPerm5Laterality
  • • "LEFT" = "LEFT"
  • • "RIGHT" = "RIGHT"
CRF

Annotated CRF [106 108 ]

EXADJReason for Dose AdjustmenttextPerm40EXADJ

[7 Terms]

CRF

Annotated CRF [106 108 ]

VISITNUMVisit NumberintegerPerm8
Assigned

Assigned from source database. Note:If Unplanned visits exist, VISIT is set to Null and VISITNUM is re-sequenced as nearest previous scheduled visit incremented by 0.001 for each unplanned visit between two scheduled visits.

VISITVisit NametextPerm21
Assigned

Assigned from source database. Note:If Unplanned visits exist, VISIT is set to Null and VISITNUM is re-sequenced as nearest previous scheduled visit incremented by 0.001 for each unplanned visit between two scheduled visits.

EPOCHEpochtextPerm11EPOCH

[6 Terms]

Derived
--DTC element will be used to determine EPOCH value. If --DTC element is partial and Null then EPOCH will be NULL.
EXSTDTCStart Date/Time of TreatmentdatetimeExpISO 8601
CRF

Annotated CRF [106 108 ]

EXENDTCEnd Date/Time of TreatmentdatetimeExpISO 8601
CRF

Annotated CRF [106 108 ]

EXSTDYStudy Day of Start of TreatmentintegerPerm8
Derived
Sequential number identifying records within each USUBJID in the domain.
EXENDYStudy Day of End of TreatmentintegerPerm8
Derived
Study day of end of event relative to the sponsor-defined RFSTDTC. --ENDY= (date portion of --ENDTC) - (date portion of DM.RFSTDTC) + 1 where --ENDTC is on or after DM.RFSTDTC; Else --ENDY = (date portion of --ENDTC) - (date portion of DM.RFSTDTC)
EXTPTREFTime Point ReferencetextPerm13TPTREF
  • • "VACCINATION 1" = "VACCINATION 1"
  • • "VACCINATION 2" = "VACCINATION 2"
  • • "VACCINATION 3" = "VACCINATION 3"
  • • "VACCINATION 4" = "VACCINATION 4"
  • • "UNPLANNED VACCINATION" = "UNPLANNED VACCINATION"
Assigned

Related vaccination number to assist with Reactogenicity assessment

Go to the top of the Define-XML document


Sequencing Data (XB)

XB (Sequencing Data) - FINDINGS Location: xb.xpt
VariableLabel / DescriptionTypeRoleLength or Display FormatControlled Terms or ISO FormatOrigin / Source / Method / Comment
STUDYIDStudy IdentifiertextReq8
Protocol
DOMAINDomain AbbreviationtextReq2DOMAIN
  • • "DM" = "Demographics"
  • • "EX" = "Exposure"
  • • "XB" = "Microbiology Specimen"
Assigned

"XB"

USUBJIDUnique Subject IdentifiertextReq22
Derived
Unique subject identifier derived usingCOMP.USUBJID
SPDEVIDSponsor Device IdentifiertextPerm45
Assigned

Set to missing

XBSEQSequence NumberintegerReq8
Derived
Sequence Number derived using COMP.SEQ
XBGRPIDGroup IDtextExp1
Assigned

Set to missing

XBREFIDReference IDtextPerm10
eDT
XBTESTCDMicrobiology Test or Finding Short NametextReq8Microbiology Specimen Test Code
  • • "WGSCLINE" = "SARS CoV2 lineage phylogenetic analysis"
Assigned
XBTESTMicrobiology Test or Finding NametextReq40Microbiology Specimen Test Name
  • • "SARS CoV2 lineage phylogenetic analysis"
Assigned
XBCATCategory for Microbiology FindingtextPerm25Category for Microbiology Finding
  • • "VIROLOGY"
Assigned
XBORRESResult or Finding in Original UnitstextExp9
eDT
XBSTRESCCharacter Result/Finding in Std FormattextExp13
Assigned
IF XBORRES is IND then Assign INDETERMINATE, else set to value to XBORRES
XBRESCATResult CategorytextExp1
Assigned

Set to missing

XBSTATCompletion StatustextPerm8ND
  • • "NOT DONE" = "NOT DONE"
Assigned
Assign NOT DONE for records with missing XBORRES
XBSPECSpecimen TypetextPerm22Specimen Type in Microbiology Specimen
  • • "NASAL_SWAB"
  • • "NASAL_SWAB_SELF"
CRF

Annotated CRF [87 ]

XBLOCSpecimen Collection LocationtextPerm1
Assigned

Set to missing

XBMETHODMethod of Test or ExaminationtextExp24Method of Test or Examination in Microbiology Specimen
  • • "Next generation sequence"
Assigned
XBBLFLBaseline FlagtextPerm1NY1
  • • "Y" = "Y"
Derived
Last non-missing value on or before DM.RFSTDTC is flagged as Y COMM.BLFL
VISITNUMVisit NumberintegerExp8
Assigned

Assigned from source database. Note:If Unplanned visits exist, VISIT is set to Null and VISITNUM is re-sequenced as nearest previous scheduled visit incremented by 0.01 for each unplanned visit between two scheduled visits

VISITVisit NametextPerm21
Assigned

Assigned from source database. Note:If Unplanned visits exist, VISIT is set to Null and VISITNUM is re-sequenced as nearest previous scheduled visit incremented by 0.01 for each unplanned visit between two scheduled visits

EPOCHEpochtextPerm11EPOCH

[6 Terms]

Derived
Epoch derivation using COMP.EPOCH
XBDTCDate/Time of Specimen CollectiondatetimeExpISO 8601
CRF

Annotated CRF [87 ]

XBDYStudy Day of MB Specimen CollectionintegerPerm8
Derived
DY derivation using COMP.DY

Go to the top of the Define-XML document


CodeLists

AGEU [C66781]
Permitted Value (Code)Display Value (Decode)
YEARS [C29848]YEARS
DOMAIN [C66734]
Permitted Value (Code)Display Value (Decode)
DM [C49572]Demographics
EX [C49587]Exposure
XB [*]Microbiology Specimen

* Extended Value

EPOCH [C99079]
Permitted Value (Code)Display Value (Decode)
FOLLOW-UP [C99158]FOLLOW-UP
SCREENING [C48262]SCREENING
VACCINATION [*]VACCINATION
REPEAT SCREENING 1 [*]REPEAT SCREENING 1
OPEN LABEL FOLLOW-UP [*]OPEN LABEL FOLLOW-UP
OPEN LABEL TREATMENT [C102256]OPEN LABEL TREATMENT

* Extended Value

ETHNIC [C66790]
Permitted Value (Code)Display Value (Decode)
HISPANIC OR LATINO [C17459]HISPANIC OR LATINO
NOT HISPANIC OR LATINO [C41222]NOT HISPANIC OR LATINO
NOT REPORTED [C43234]NOT REPORTED
EXADJ
Permitted Value (Code)Display Value (Decode)
ADVERSE EVENT(S)ADVERSE EVENT(S)
ANTICIPATED NON-STUDY VACCINATIONANTICIPATED NON-STUDY VACCINATION
FEVER OR ACUTE ILLNESSFEVER OR ACUTE ILLNESS
MULTIPLEMULTIPLE
OTHER SPECIFYOTHER SPECIFY
RECENT NON-STUDY VACCINATIONRECENT NON-STUDY VACCINATION
RECENT SYSTEMIC CORTICOSTEROID TREATMENTRECENT SYSTEMIC CORTICOSTEROID TREATMENT
Category of Treatment
Permitted Value (Code)Display Value (Decode)
INVESTIGATIONAL PRODUCTINVESTIGATIONAL PRODUCT
EXDOSU [C71620]
Permitted Value (Code)Display Value (Decode)
mcg [*]Microgram
SYRINGE [C48540]SYRINGE
mL [C28254]Milliliter
ug [C48152]Microgram

* Extended Value

Subcategory of Treatment
Permitted Value (Code)Display Value (Decode)
VACCINATIONVACCINATION
FRM [C66726]
Permitted Value (Code)Display Value (Decode)
INJECTION [C42946]INJECTION
Laterality [C99073]
Permitted Value (Code)Display Value (Decode)
LEFT [C25229]LEFT
RIGHT [C25228]RIGHT
LOC [C74456]
Permitted Value (Code)Display Value (Decode)
AXILLA [C12674]AXILLA
CHEST [C25389]CHEST
DELTOID MUSCLE [C32446]DELTOID MUSCLE
EAR [C12394]EAR
FOREHEAD [C89803]FOREHEAD
HEAD [C12419]HEAD
LOWER RESPIRATORY SYSTEM [C33012]LOWER RESPIRATORY SYSTEM
NASAL CAVITY [C12424]NASAL CAVITY
NASOPHARYNX [C12423]NASOPHARYNX
ORAL CAVITY [C12421]ORAL CAVITY
OTHER [*]OTHER
THROAT [C54272]THROAT

* Extended Value

ND [C66789]
Permitted Value (Code)Display Value (Decode)
NOT DONE [C49484]NOT DONE
NY1 [C66742]
Permitted Value (Code)Display Value (Decode)
Y [C49488]Y
RACE [C74457]
Permitted Value (Code)Display Value (Decode)
AMERICAN INDIAN OR ALASKA NATIVE [C41259]AMERICAN INDIAN OR ALASKA NATIVE
ASIAN [C41260]ASIAN
BLACK OR AFRICAN AMERICAN [C16352]BLACK OR AFRICAN AMERICAN
MULTIPLE [*]MULTIPLE
NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER [C41219]NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER
NOT REPORTED [C43234]NOT REPORTED
WHITE [C41261]WHITE

* Extended Value

ROUTE [C66729]
Permitted Value (Code)Display Value (Decode)
AURICULAR (OTIC) [C38192]AURICULAR (OTIC)
CUTANEOUS [C38675]CUTANEOUS
INTRA-ARTICULAR [C38223]INTRA-ARTICULAR
INTRADERMAL [C38238]INTRADERMAL
INTRAMUSCULAR [C28161]INTRAMUSCULAR
INTRAUTERINE [C38272]INTRAUTERINE
INTRAVENOUS [C38276]INTRAVENOUS
NASAL [C38284]NASAL
OPHTHALMIC [C38287]OPHTHALMIC
ORAL [C38288]ORAL
RESPIRATORY (INHALATION) [C38216]RESPIRATORY (INHALATION)
SUBCUTANEOUS [C38299]SUBCUTANEOUS
TOPICAL [C38304]TOPICAL
VAGINAL [C38313]VAGINAL
SEX [C66731]
Permitted Value (Code)Display Value (Decode)
F [C16576]F
M [C20197]M
TPTREF
Permitted Value (Code)Display Value (Decode)
VACCINATION 1VACCINATION 1
VACCINATION 2VACCINATION 2
VACCINATION 3VACCINATION 3
VACCINATION 4VACCINATION 4
UNPLANNED VACCINATIONUNPLANNED VACCINATION
Category for Microbiology Finding
Permitted Value (Code)
VIROLOGY
Method of Test or Examination in Microbiology Specimen [C85492]
Permitted Value (Code)
Next generation sequence [*]

* Extended Value

Specimen Type in Microbiology Specimen [C78734]
Permitted Value (Code)
NASAL_SWAB [*]
NASAL_SWAB_SELF [*]

* Extended Value

Microbiology Specimen Test Name [C120528]
Permitted Value (Code)
SARS CoV2 lineage phylogenetic analysis [*]

* Extended Value

Microbiology Specimen Test Code [C120527]
Permitted Value (Code)Display Value (Decode)
WGSCLINE [*]SARS CoV2 lineage phylogenetic analysis

* Extended Value

Go to the top of the Define-XML document


External Dictionaries

External Dictionaries
Reference NameExternal DictionaryDictionary Version
ISO3166(CL.ISO3166)ISO3166
MedDRAMedDRA23.1
National Drug File - Reference TerminologyNDF-RT2020-03-02
Systematized Nomenclature of MedicineSNOMED2020-03-01
Unique Ingredient IdentifierUNII2020-01-12
WHO DDWHO DD202003
Medications DictionaryWHODDGLOBALB3Mar20

Go to the top of the Define-XML document


Methods

Methods
MethodTypeDescription
DM.DM.AGEComputation
If AGEU=YEARS then AGE=int((Informed Consent date - birthdate)/365.25)
DM.DM.DTHDTCComputation
Date/time of death when Disposition mentioned as 'DEATH'.
DM.DM.DTHFLComputation
Populate Death flag is 'Y' when Standardized Disposition Term is 'DEATH'
DM.DM.RFENDTCComputation
Maximum of Visit date/Maximum of disposition date, whichever is greater.Null for Screen Failures.
DM.DM.RFICDTCComputation
Date/time of informed consent obtained
DM.DM.RFPENDTCComputation
Set to Date/time when subject ended participation in a trial.
DM.DM.RFSTDTCComputation
First date/time of study drug else Randomization date/time OR Enrollment date/time for subject.Null for screen failures.
DM.DM.RFXENDTCComputation
Latest date/time of study drug exposure
DM.DM.RFXSTDTCComputation
First date/time of study drug exposure date
DM.DM.USUBJIDComputation
Concatenation of STUDYID, SITEID and SUBJID
EX.EC.EPOCHComputation
--DTC element will be used to determine EPOCH value. If --DTC element is partial and Null then EPOCH will be NULL.
EX.EC.EXENDYComputation
Study day of end of event relative to the sponsor-defined RFSTDTC. --ENDY= (date portion of --ENDTC) - (date portion of DM.RFSTDTC) + 1 where --ENDTC is on or after DM.RFSTDTC; Else --ENDY = (date portion of --ENDTC) - (date portion of DM.RFSTDTC)
EX.EC.EXLNKGRPComputation
Related vaccination number to assist with Reactogenicity assessment
EX.EC.EXLNKIDComputation
Concatenate Link Group ID, Location and Laterality when Link Group ID is present
EX.EC.EXSEQComputation
Sequential number identifying records within each USUBJID in the domain.
EX.EC.EXSTDYComputation
Sequential number identifying records within each USUBJID in the domain.
EX.EC.USUBJIDComputation
DM.USUBJID
XB.EPOCHComputation
Epoch derivation using COMP.EPOCH
XB.USUBJIDComputation
Unique subject identifier derived usingCOMP.USUBJID
XB.XBBLFLComputation
Last non-missing value on or before DM.RFSTDTC is flagged as Y COMM.BLFL
XB.XBDYComputation
DY derivation using COMP.DY
XB.XBSEQComputation
Sequence Number derived using COMP.SEQ
XB.XBSTATComputation
Assign NOT DONE for records with missing XBORRES
XB.XBSTRESCComputation
IF XBORRES is IND then Assign INDETERMINATE, else set to value to XBORRES

Go to the top of the Define-XML document