Date/Time of Define-XML document generation: 2020-10-21T15:46:19Z

Define-XML version: 2.0.0

Stylesheet version: 2018-11-21

Datasets

Datasets
DatasetDescriptionClass StructurePurposeKeysDocumentationLocation
ADSLSubject-Level Analysis DatasetSUBJECT LEVEL ANALYSIS DATASETOne record per subjectAnalysisSTUDYID, USUBJIDadsl.xpt
ADFACEVDReactogenicity Findings Analysis DatasetBASIC DATA STRUCTUREOne record per subject per analysis parameter per analysis timepointAnalysisSTUDYID, USUBJID, ADT, ADTM, PARCAT1, PARAMNadfacevd.xpt
ADLBLaboratory Analysis DatasetBASIC DATA STRUCTUREOne record per subject per analysis parameter per analysis timepointAnalysisSTUDYID, USUBJID, PARAMCD, AVISITN, ASEQadlb.xpt
ADVAImmunogenicity Analysis DatasetBASIC DATA STRUCTUREOne record per subject per analysis parameter per analysis timepointAnalysisSTUDYID, USUBJID, PARAMCD, AVISITNadva.xpt
ADVSVital Signs Analysis DatasetBASIC DATA STRUCTUREOne record per subject per analysis parameter per analysis timepointAnalysisSTUDYID, USUBJID, PARAMCD, AVISITN, ADTMadvs.xpt
ADAEAdverse Events Analysis DatasetOCCURRENCE DATA STRUCTUREOne record per subject per adverse event per event start dateAnalysisSTUDYID, USUBJID, AEDECOD, ASTDT, AESEQadae.xpt
ADCEVDReactogenicity Analysis DatasetOCCURRENCE DATA STRUCTUREOne record per subject per clinical event per analysis timepoint per vaccination period (identified by traceability variable CESEQ)AnalysisSTUDYID, USUBJID, ACAT1, CETERM, ASTDT, CESEQadcevd.xpt

Go to the top of the Define-XML document


Subject-Level Analysis Dataset (ADSL)

ADSL (Subject-Level Analysis Dataset) - SUBJECT LEVEL ANALYSIS DATASET Location: adsl.xpt
VariableLabel / DescriptionTypeLength or Display FormatControlled Terms or ISO FormatOrigin / Source / Method / Comment
STUDYIDStudy Identifiertext9
Predecessor: DM.STUDYID
USUBJIDUnique Subject Identifiertext21
Predecessor: DM.USUBJID
SUBJIDSubject Identifier for the Studytext5
Predecessor: DM.SUBJID
SUBJIDNSubject Identifier for the Study (N)integer8
Derived
DM.SUBJID as numeric value.
SITEIDStudy Site Identifiertext12Study Site Identifier
  • • "CRS Berlin"
  • • "CRS Mannheim"
Predecessor: DM.SITEID
INVIDInvestigator Identifiertext2
Predecessor: DM.INVID
INVNAMInvestigator Nametext13Investigator Name
  • • "Armin Schultz"
Predecessor: DM.INVNAM
AGEAgeinteger8
Predecessor: DM.AGE
AGEUAge Unitstext5Age Unit
  • • "YEARS" = "Year"
Predecessor: DM.AGEU
AGE_MAdd. Months to Age in years (months)integer8
Predecessor: SUPPDM.QVAL where QNAM='AGE_M'
AAGEAnalysis Agefloat8
Derived
Set to AGE when AGE_M is missing (i.e. no additional months are specified to be added to age). Otherwise, set to the AGE + AGE_M / 12, rounded to the nearest hundredth.
SEXSextext1Sex
  • • "M" = "Male"
  • • "F" = "Female"
Predecessor: DM.SEX
SEXNSex (N)integer8
Assigned

1 when SEX = 'M'; 2 when SEX = 'F'.

RACERacetext25Race

[9 Terms]

Predecessor: DM.RACE
RACENRace (N)integer8
Assigned

1 when RACE = 'AMERICAN INDIAN OR ALASKA NATIVE'; 2 when RACE = 'ASIAN'; 3 when RACE = 'BLACK OR AFRICAN AMERICAN'; 4 when RACE = 'NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER'; 5 when RACE = 'WHITE'; 6 when RACE = 'NOT REPORTED'; 7 when RACE = 'UNKNOWN'; 8 when RACE = 'OTHER'; 9 when RACE = 'MULTIPLE'.

RACEOTHRace Othertext1
Predecessor: SUPPDM.QVAL where QNAM='RACEOTH'
RACE1Race 1text1
Predecessor: SUPPDM.QVAL where QNAM='RACE1'
RACE2Race 2text1
Predecessor: SUPPDM.QVAL where QNAM='RACE2'
ETHNICEthnicitytext22Ethnic Group
  • • "HISPANIC OR LATINO"
  • • "NOT HISPANIC OR LATINO"
  • • "NOT REPORTED"
  • • "UNKNOWN"
Predecessor: DM.ETHNIC
ETHNICNEthnicity (N)integer8
Assigned

1 when ETHNIC = 'HISPANIC OR LATINO'; 2 when ETHNIC = 'NOT HISPANIC OR LATINO'; 3 when ETHNIC = 'NOT REPORTED'; 4 when ETHNIC = 'UNKNOWN'.

HEIGHTHeight [cm]float8
Derived
VS.VSSTRESN where VS.VSTESTCD = 'HEIGHT' and VS.VSBLFL = 'Y'.
WEIGHTWeight [kg]float8
Derived
VS.VSSTRESN where VS.VSTESTCD = 'WEIGHT' and VS.VSBLFL = 'Y'.
BMIBMI [kg/m2]float8
Derived
VS.VSSTRESN where VS.VSTESTCD = 'BMI' and VS.VSBLFL = 'Y'.
SCRFLScreened Population Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' when RFICDTM is not missing; 'N', otherwise.
SCRFNScreened Population Flag (N)integer8
Assigned

0 when corresponding -FL variable is 'N'; 1 when corresponding -FL variable is 'Y'.

EXSCR1Reason 1 for Exclusion Screened Settext1
Derived
Always null, since screen failures not included in this data cut.
SAFFLSafety Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
'Y' when subject has received prime vaccination (when record exists in EC with EC.ECOCCUR = 'Y' and EC.VISITNUM = 2 for given subject). 'N', otherwise.
SAFFNSafety Population Flag (N)integer8
Assigned

0 when corresponding -FL variable is 'N'; 1 when corresponding -FL variable is 'Y'.

EXSAF1Reason 1 for Exclusion Safety Settext1
Derived
Always null, since no patients are excluded from the safety population (i.e. all have received the prime vaccination) in this data cut.
SAFBFLSafety Boost Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
'Y' when subject has received boost vaccination (when record exists in EC with EC.ECOCCUR = 'Y' and EC.VISITNUM = 6 for given subject). 'N', otherwise.
SAFBFNSafety Boost Population Flag (N)integer8
Assigned

0 when corresponding -FL variable is 'N'; 1 when corresponding -FL variable is 'Y'.

EXSAFB1Reason 1 for Exclusion Safety Boost Settext40Reason 1 for Exclusion Safety Boost Set
  • • "Subject did not receive two doses of IMP"
Derived
'Subject did not receive two doses of IMP' when SAFBFL = 'N'.
IMMFLImmunogenicity Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
'Y' when subject is in the Safety Population (SAFFL = 'Y') and has evaluable post-baseline Neutralizing Titer results (when record exists in IS for given subject with IS.VISITNUM > 2 and non-missing IS.ISORRES for IS.ISTESTCD of 'C2NGNT50' or 'C2NGNT90'). 'N', otherwise.
IMMFNImmunogenicity Population Flag (N)integer8
Assigned

0 when corresponding -FL variable is 'N'; 1 when corresponding -FL variable is 'Y'.

EXIMM1Reason for Exclusion Immunogenicity Settext99Reason for Exclusion Immunogenicity Set
  • • "Subject did not receive one dose of IMP or did not have one post-baseline immunogenicity assessment"
Derived
'Subject did not receive one dose of IMP or did not have one post-baseline immunogenicity assessment' when IMMFL = 'N'.
PPROTFLPer-Protocol Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
'Y' when subject is in the Immunogenicity Population (IMMFL = 'Y') and has not had a protocol violation (no record exists in DV for given subject). 'N', otherwise.
PPROTFNPer-Protocol Population Flag (N)integer8
Assigned

0 when corresponding -FL variable is 'N'; 1 when corresponding -FL variable is 'Y'.

EXPPROT1Reason 1 for Exclusion Per-Protocol Settext81Reason 1 for Exclusion Per-Protocol Set
  • • "Subject is not included in the immunogenicity set or had major protocol deviation"
Derived
'Subject is not included in the immunogenicity set or had major protocol deviation' when PPROTFL = 'N'.
CP7FLPrime + 7 Days Completers Settext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' when subject is in the Safety Population (SAFFL = 'Y') and has completed at least 7 days of follow-up after receiving the prime vaccination (either EOSDT is populated and PRIMDT + 7 is less than EOSDT or PRIMDT + 7 is less than or equal to the data cutoff date of 13AUG2020). 'N', otherwise.
CP7FNPrime + 7 Days Completers Set (N)integer8
Assigned

0 when corresponding -FL variable is 'N'; 1 when corresponding -FL variable is 'Y'.

CPBP28FLPrime to Boost or Prime +28 D. Comp. Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
'Y' when subject is in the Safety Boost Population (SAFBFL = 'Y') or is in the Safety Population (SAFFL = 'Y') and has completed at least 28 days of follow-up after receiving the prime vaccination (either EOSDT is populated and PRIMDT + 28 is less than EOSDT or PRIMDT + 28 is less than or equal to the data cutoff date of 13AUG2020). 'N', otherwise.
CPBP28FNPri. to Bo. or Pri. +28 D. Comp. Set (N)integer8
Assigned

0 when corresponding -FL variable is 'N'; 1 when corresponding -FL variable is 'Y'.

CB7FLBoost + 7 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
'Y' when subject is in the Safety Boost Population (SAFBFL = 'Y') and has completed at least 7 days of follow-up after receiving the boost vaccination (either EOSDT is populated and BOIMDT + 7 is less than EOSDT or BOIMDT + 7 is less than or equal to the data cutoff date of 13AUG2020). 'N', otherwise.
CB7FNBoost + 7 Days Completers Set (N)integer8
Assigned

0 when corresponding -FL variable is 'N'; 1 when corresponding -FL variable is 'Y'.

CB28FLBoost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
'Y' when subject is in the Safety Boost Population (SAFBFL = 'Y') and has completed at least 28 days of follow-up after receiving the boost vaccination (either EOSDT is populated and BOIMDT + 28 is less than EOSDT or BOIMDT + 28 is less than or equal to the data cutoff date of 13AUG2020). 'N', otherwise.
CB28FNBoost + 28 Days Completers Set (N)integer8
Assigned

0 when corresponding -FL variable is 'N'; 1 when corresponding -FL variable is 'Y'.

CPB28FLPrime or Boost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
'Y' when subject is in the Prime to Boost or Prime +28 D. Comp. Population (CPBP28FL = 'Y') and has either (a) not received a boost vaccination (SAFBFL = 'N') or (b) is in the Boost + 28 Days Completers Population (CB28FL = 'Y'). 'N', otherwise.
CPB28FNPrime or Boost + 28 Days Comp. Set (N)integer8
Assigned

0 when corresponding -FL variable is 'N'; 1 when corresponding -FL variable is 'Y'.

COMPLFLCompleters Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
'Y' when EOSSTT = 'COMPLETED'. 'N', otherwise.
COMPLFNCompleters Population Flag (N)integer8
Assigned

0 when corresponding -FL variable is 'N'; 1 when corresponding -FL variable is 'Y'.

COHORTCohorttext8Cohort

[7 Terms]

Predecessor: SUPPDS.QVAL where QNAM='COHORT'
COHORTNCohort (N)integer8
Assigned

Numeric value following 'Cohort ' in COHORT variable.

GROUPGrouptext12Group
  • • "B (BNT162b1)"
  • • "C (BNT162b2)"
Predecessor: SUPPDS.QVAL where QNAM='GROUP'
GROUPNGroup (N)integer8
Assigned

2 when GROUP = 'B (BNT162b1)'; 3 when GROUP = 'C (BNT162b2)'.

ARMDescription of Planned Armtext14Description of Planned Arm

[12 Terms]

Predecessor: DM.ARM
ACTARMDescription of Actual Armtext14Description of Actual Arm

[12 Terms]

Predecessor: DM.ACTARM
TRT01PPlanned Treatment for Period 01text5Planned Treatment for Period 01

[7 Terms]

Derived
Set to the dosing information provided in DM.ARM, updating the unit value from 'ug' to 'µg'. [Ex: '10 µg' when DM.ARM = 'BNT162b1 10 ug']
TRT01PNPlanned Treatment for Period 01 (N)integer8
Derived
Set to the dose level in TRT01P multiplied by 100. [Ex: 1000 when TRT01P = '10 µg']
TRT01AActual Treatment for Period 01text5Actual Treatment for Period 01

[7 Terms]

Derived
Set to the dosing information provided in DM.ACTARM, updating the unit value from 'ug' to 'µg'. [Ex: '10 µg' when DM.ACTARM = 'BNT162b1 10 ug']
TRT01ANActual Treatment for Period 01 (N)integer8
Derived
Set to the dose level in TRT01A multiplied by 100. [Ex: 1000 when TRT01A = '10 µg']
TRTSDTDate of First Exposure to TreatmentintegerDATE9
Derived
Date part of corresponding -DTM variable.
TRTSTMTime of First Exposure to TreatmentintegerTIME5
Derived
Time part of corresponding -DTM variable.
TRTSDTMDatetime of First Exposure to TreatmentintegerDATETIME19
Derived
DM.RFXSTDTC as SAS datetime.
TRTEDTDate of Last Exposure to TreatmentintegerDATE9
Derived
Date part of corresponding -DTM variable.
TRTETMTime of Last Exposure to TreatmentintegerTIME5
Derived
Time part of corresponding -DTM variable.
TRTEDTMDatetime of Last Exposure to TreatmentintegerDATETIME19
Derived
DM.RFXENDTC as SAS datetime.
RFICDTDate of Informed ConsentintegerDATE9
Derived
Date part of corresponding -DTM variable.
RFICTMTime of Informed ConsentintegerTIME5
Derived
Time part of corresponding -DTM variable.
RFICDTMDatetime of Informed ConsentintegerDATETIME19
Derived
DM.RFICDTC as SAS datetime.
SCRDTDate of ScreeningintegerDATE9
Derived
Date part of DM.RFICDTC as SAS date.
ALLOCDTDate of AllocationintegerDATE9
Derived
Date part of corresponding -DTM variable.
ALLOCTMTime of AllocationintegerTIME5
Derived
Time part of corresponding -DTM variable.
ALLOCDTMDatetime of AllocationintegerDATETIME19
Derived
DS.DSSTDTC as SAS datetime, selecting record where DS.DSDECOD = 'ALLOCATED'.
LVDTDate of Last VisitintegerDATE9
Derived
When subject has completed the trial (i.e. EOSSTT = ' COMPLETED'), set to date part of DS.DSSTDTC as SAS date, selecting record where DS.DSSCAT = 'END OF TRIAL. When subject discontinued prematurely (i.e. EOSSTT = 'DISCONTINUED'), set to date part of Date of last visit/contact (SUPPDS.QVAL where QNAM = 'LASTCONT') as SAS date.
EOSSTTEnd of Study Statustext12End of Study Status
  • • "COMPLETED"
  • • "DISCONTINUED"
Derived
'COMPLETED' when DS.DSDECOD = 'COMPLETED' on record with DS.DSSCAT = 'END OF TRIAL' for given subject. Otherwise, 'DISCONTINUED' when EOSDT is not null.
EOSDTEnd of Study DateintegerDATE9
Derived
Date part of DS.DSSTDTC as SAS date, selecting record where DS.DSSCAT = 'END OF TRIAL'.
EOFUDTEnd of Follow-up DateintegerDATE9
Derived
Date part of DS.DSSTDTC as SAS date, selecting record where DS.DSSCAT = 'END OF FOLLOW-UP'.
DCSREASReason for Discontinuation from Studytext21Reason for Discontinuation from Study
  • • "Adverse Event"
  • • "Other"
  • • "Protocol Deviation"
  • • "Withdrawal By Subject"
Derived
Populated when EOSSTT = 'DISCONTINUED'. Set to DS.DSDECOD in proper case, selecting record where DS.DSSCAT = 'END OF TRIAL'.
DCSREASPReason Spec for Discont from Studytext22Reason Spec for Discont from Study
  • • "Adverse Event"
  • • "Due To Private Reason."
  • • "Protocol Deviation"
  • • "Withdrawal By Subject"
Derived
Populated when EOSSTT = 'DISCONTINUED'. Set to DS.DSTERM in proper case, selecting record where DS.DSSCAT = 'END OF TRIAL'.
DTHFLSubject Death Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: DM.DTHFL
DTHDTDate of DeathintegerDATE9
Derived
Date part of DM.DTHDTC as SAS date.
PRIMDTDate of Prime ImmunizationintegerDATE9
Derived
Date part of corresponding -DTM variable.
PRIMTMTime of Prime ImmunizationintegerTIME5
Derived
Time part of corresponding -DTM variable.
PRIMDTMDatetime of Prime ImmunizationintegerDATETIME19
Derived
EC.ECSTDTC as SAS datetime, selecting record where EC.ECOCCUR = 'Y' and VISITNUM = 2.
BOIMDTDate of Boost ImmunizationintegerDATE9
Derived
Date part of corresponding -DTM variable.
BOIMTMTime of Boost ImmunizationintegerTIME5
Derived
Time part of corresponding -DTM variable.
BOIMDTMDatetime of Boost ImmunizationintegerDATETIME19
Derived
EC.ECSTDTC as SAS datetime, selecting record where EC.ECOCCUR = 'Y' and EC.VISITNUM = 6.
DSEPRELIEpi/Pandemic Related Indicatortext1No Yes Response (No Only)
  • • "N" = "No"
Predecessor: SUPPDS.QVAL where QNAM='DSEPRELI'
PREV_TSNPrevious TSNstext11Previous TSNs

[15 Terms]

Predecessor: SUPPDS.QVAL where QNAM='PREV_TSN'
FIRICDTDate of first Informed ConsentintegerDATE9
Derived
Date part of DS.DSSTDTC as SAS date, selecting record where DS.DSDECOD = 'FIRST INFORMED CONSENT OBTAINED'.
ICR1DTDate of Informed Consent Reconsented 1integerDATE9
Derived
Date part of corresponding -DTM variable.
ICR1TMTime of Informed Consent Reconsented 1integerTIME5
Derived
Time part of corresponding -DTM variable.
ICR1DTMDatetime of Informed Consent Recons. 1integerDATETIME19
Derived
DS.DSSTDTC as SAS datetime, selecting record(s) where DS.DSDECOD = 'INFORMED CONSENT RECONSENTED'. If multiple records exist for a given subject, the 1st record when sorted by DS.DSSTDTC is selected for populating ICR1DTM.
ICR2DTDate of Informed Consent Reconsented 2integerDATE9
Derived
Date part of corresponding -DTM variable.
ICR2TMTime of Informed Consent Reconsented 2integerTIME5
Derived
Time part of corresponding -DTM variable.
ICR2DTMDatetime of Informed Consent Recons. 2integerDATETIME19
Derived
DS.DSSTDTC as SAS datetime, selecting records where DS.DSDECOD = 'INFORMED CONSENT RECONSENTED'. The 2nd record when sorted by DS.DSSTDTC is selected for populating ICR2DTM.
ICR3DTDate of Informed Consent Reconsented 3integerDATE9
Derived
Date part of corresponding -DTM variable.
ICR3TMTime of Informed Consent Reconsented 3integerTIME5
Derived
Time part of corresponding -DTM variable.
ICR3DTMDatetime of Informed Consent Recons. 3integerDATETIME19
Derived
DS.DSSTDTC as SAS datetime, selecting records where DS.DSDECOD = 'INFORMED CONSENT RECONSENTED'. The 3rd record when sorted by DS.DSSTDTC is selected for populating ICR3DTM.
PROTVER1First Protocol Version signedtext16First Protocol Version signed
  • • "3.0, 17 Apr 2020"
  • • "5.0, 26 MAY 2020"
  • • "7.0, 26 JUN 2020"
Derived
SUPPDS.QNAM where QVAL = 'PROTVERS'. If multiple records exist for a given subject, the 1st record when sorted by DS.DSSTDTC on the associated parent record is selected for populating PROTVER1.
PROTVER2Second Protocol Version signedtext16Second Protocol Version signed
  • • "5.0, 26 MAY 2020"
  • • "7.0, 26 JUN 2020"
  • • "8.0, 21 JUL 2020"
Derived
SUPPDS.QNAM where QVAL = 'PROTVERS'. The 2nd record when sorted by DS.DSSTDTC on the associated parent record is selected for populating PROTVER2.
PROTVER3Third Protocol Version signedtext16Third Protocol Version signed
  • • "7.0, 26 JUN 2020"
  • • "8.0, 21 JUL 2020"
Derived
SUPPDS.QNAM where QVAL = 'PROTVERS'. The 3rd record when sorted by DS.DSSTDTC on the associated parent record is selected for populating PROTVER3.
PROTVER4Fourth Protocol Version signedtext16Fourth Protocol Version signed
  • • "8.0, 21 JUL 2020"
Derived
SUPPDS.QNAM where QVAL = 'PROTVERS'. The 4th record when sorted by DS.DSSTDTC on the associated parent record is selected for populating PROTVER4.

Go to the top of the Define-XML document


Reactogenicity Findings Analysis Dataset (ADFACEVD)

ADFACEVD (Reactogenicity Findings Analysis Dataset) - BASIC DATA STRUCTURE Location: adfacevd.xpt
VariableWhere ConditionLabel / DescriptionTypeLength or Display FormatControlled Terms or ISO FormatOrigin / Source / Method / Comment
STUDYIDStudy Identifiertext9
Predecessor: ADSL.STUDYID
USUBJIDUnique Subject Identifiertext21
Predecessor: ADSL.USUBJID
SUBJIDSubject Identifier for the Studytext5
Predecessor: ADSL.SUBJID
SUBJIDNSubject Identifier for the Study (N)integer8
Predecessor: ADSL.SUBJIDN
COHORTCohorttext8Cohort

[7 Terms]

Predecessor: ADSL.COHORT
COHORTNCohort (N)integer8
Predecessor: ADSL.COHORTN
GROUPGrouptext12Group
  • • "B (BNT162b1)"
  • • "C (BNT162b2)"
Predecessor: ADSL.GROUP
GROUPNGroup (N)integer8
Predecessor: ADSL.GROUPN
TRTPPlanned Treatmenttext5Planned Treatment

[7 Terms]

Predecessor: ADSL.TRT01P
TRTPNPlanned Treatment (N)integer8
Predecessor: ADSL.TRT01PN
TRTAActual Treatmenttext5Actual Treatment

[7 Terms]

Predecessor: ADSL.TRT01A
TRTANActual Treatment (N)integer8
Predecessor: ADSL.TRT01AN
ADTAnalysis DateintegerDATE9
Derived
Null when PARAMCD begins with 'DUR'. Otherwise, date part of FADTC as SAS date when SRCDOM = 'FA' and date part of VSDTC as SAS date when SRCDOM = 'VS'.
ADTMAnalysis DatetimeintegerDATETIME19
Derived
Null when PARAMCD begins with 'DUR'. Otherwise, FADTC as SAS datetime when SRCDOM = 'FA' and VSDTC as SAS datetime when SRCDOM = 'VS'.
ADYAnalysis Relative Dayinteger8
Derived
Analysis date relative to treatment start: ADT - TRTSDT + 1, when ADT is on or after TRTSDT; ADT - TRTSDT, when ADT is before TRTSDT.
ASTDTAnalysis Start DateintegerDATE9
Derived
Populated only for records with PARAMCD values beginning with 'DUR'. Set to earliest date/time at which a given type of reactogenicity event occurred (i.e. the value of ADT on the first record meeting criteria for the given PARAM value, when sorted by USUBJID, ADY, and PARAMN).
ASTDYAnalysis Start Relative Dayinteger8
Derived
Analysis start date relative to treatment start: ASTDT - TRTSDT + 1, when ASTDT is on or after TRTSDT; ASTDT - TRTSDT, when ASTDT is before TRTSDT.
AENDTAnalysis End DateintegerDATE9
Derived
Populated only for records with PARAMCD values beginning with 'DUR'. Set to latest date/time at which a given type of reactogenicity event occurred (i.e. the value of ADT on the last record meeting criteria for the given PARAM value, when sorted by USUBJID, ADY, and PARAMN).
AENDYAnalysis End Relative Dayinteger8
Derived
Analysis end date relative to treatment start: AENDT - TRTSDT + 1, when AENDT is on or after TRTSDT; AENDT - TRTSDT, when AENDT is before TRTSDT.
FADTCDate/Time of CollectionpartialDatetimeISO 8601
Predecessor: FA.FADTC
VSDTCDate/Time of MeasurementspartialDatetimeISO 8601
Predecessor: VS.VSDTC
ATPTAnalysis Timepointtext6
Derived
FATPT in proper case when SRCDOM = 'FA', and VSTPT in proper case when SRCDOM = 'VS'. (Ex. 'Day 3').
ATPTNAnalysis Timepoint (N)integer8
Assigned

Integer following 'Day ' in ATPT.

FATPTPlanned Time Point Nametext6
Predecessor: FA.FATPT
VSTPTPlanned Time Point Nametext1
Predecessor: VS.VSTPT
ATPTREFAnalysis Timepoint Referencetext5Analysis Timepoint Reference in ADCEVD
  • • "Boost"
  • • "Prime"
Derived
'Prime' when FATPTREF or VSTPTREF = 'PRIME VACCINATION'; 'Boost' when FATPTREF or VSTPTREF = 'BOOST VACCINATION'.
FATPTREFTime Point Referencetext17Time Point Reference in ADFACEVD
  • • "BOOST VACCINATION"
  • • "PRIME VACCINATION"
Predecessor: FA.FATPTREF
VSTPTREFTime Point Referencetext17Time Point Reference in ADFACEVD
  • • "BOOST VACCINATION"
  • • "PRIME VACCINATION"
Predecessor: VS.VSTPTREF
PARAMVLMParametertext66
SRCVAR = "FASTRESC" and
FATESTCD = "OCCUR"
Parameter for FACE occurrence recordstext49Parameter for FACE occurrence record in ADFACEVD

[14 Terms]

Derived
Concatenation of FACE.FAOBJ (selecting just the text following a slash '/' or dash '-', when applicable, and adding ' at injection site' for Pain and Tenderness records) and FATEST in proper case. (Ex: FAOBJ = 'Injection site reaction - Pain' --> PARAM = 'Pain at injection site occurrence indicator'). [Note that occurrence records from FACE (where FATESTCD = 'OCCUR') are included in ADFACEVD only if FAEVAL = 'STUDY SUBJECT' and FASTAT is null ('NOT DONE' records are excluded).]
SRCVAR = "FASTRESC" and
FATESTCD = "SEV"
Parameter for FACE severity/intensity recordstext47Parameter for FACE severity record in ADFACEVD

[14 Terms]

Derived
Concatenation of FACE.FAOBJ (selecting just the text following a slash '/' or dash '-', when applicable, and adding ' at injection site' for Pain and Tenderness records) and FATEST in proper case. (Ex: FAOBJ = 'Injection site reaction - Pain' --> PARAM = 'Pain at injection site severity/intensity'). [Note that severity records from FACE (where FATESTCD = 'SEV') are included in ADFACEVD only if FAEVAL = 'STUDY SUBJECT' and FASTRESC is not 'NONE'.]
SRCVAR = "VSSTRESN"Parameter for VS occurrence and severity/intensity recordstext26Parameter for VS record in ADFACEVD
  • • "Fever occurrence indicator"
  • • "Fever severity/intensity"
Assigned

Set to 'Fever occurrence indicator'. When the VSSTRESN value indicates a fever occurred (i.e. VSSTRESN is 38.0 or higher) an additional record exists with PARAM set to 'Fever severity/intensity'. [Note that records from VS are included in ADFACEVD only if VSCAT = 'REACTOGENICITY' and VSSTAT is null ('NOT DONE' records are excluded).]

SRCVAR IN (
"FADY",
"VSDY"
) and
AVALCAT1 = ""
Parameter for time to first occurrence recordstext40Parameter for Time to 1st occurrence record in ADFACEVD
  • • "Time to first local or systemic reaction"
  • • "Time to first local reaction"
  • • "Time to first systemic reaction"
Assigned

For each subject having any reactogenicity occurrence records (with PARAM value ending with 'occurrence indicator' and AVALC = 'Y'), an additional record exists with PARAM set to 'Time to first local or systemic reaction'. For each subject having any local reaction occurrence records (with PARAM value ending with 'occurrence indicator' and AVALC = 'Y' and PARCAT1 = 'local'), an additional record exists with PARAM set to 'Time to first local reaction'. For each subject having any systemic reaction occurrence records (with PARAM value ending with 'occurrence indicator' and AVALC = 'Y' and PARCAT1 = 'systemic'), an additional record exists with PARAM set to 'Time to first systemic reaction'. Traceability variables for these additional records are obtained from the first record meeting the criteria for the given PARAM value, when sorted by USUBJID, ADY, and PARAMN (i.e. the earliest event).

SRCVAR IN (
"FADY",
"VSDY"
) and
AVALCAT1 = "grade >= 3"
Parameter for time to first grade>=3 occurrence recordstext56Parameter for Time to 1st grade>=3 occurrence record in ADFACEVD
  • • "Time to first local or systemic reaction with grade >= 3"
  • • "Time to first local reaction with grade >= 3"
  • • "Time to first systemic reaction with grade >= 3"
Assigned

For each subject having any reactogenicity severity records with grade >= 3 (with PARAM value ending with 'severity/intensity' and AVALCAT1 = 'grade >= 3'), an additional record exists with PARAM set to 'Time to first local or systemic reaction with grade >= 3'. For each subject having any local reaction severity records with grade >= 3 (with PARAM value ending with 'severity/intensity' and PARCAT1 = 'local' and AVALCAT1 = 'grade >= 3'), an additional record exists with PARAM set to 'Time to first local reaction with grade >= 3'. For each subject having any systemic reaction severity records with grade >= 3 (with PARAM values ending with 'severity/intensity' and PARCAT1 = 'systemic' and AVALCAT1 = 'grade >= 3'), an additional record exists with PARAM set to 'Time to first systemic reaction with grade >= 3'. Traceability variables for these additional records are obtained from the first record meeting the criteria for the given PARAM value, when sorted by USUBJID, ADY, and PARAMN (i.e. the earliest event).

SRCVAR = "" and
AVALCAT1 = ""
Parameter for time from first to last occurrence recordstext50Parameter for Time from 1st to last occurrence record in ADFACEVD
  • • "Time from first to last local or systemic reaction"
  • • "Time from first to last local reaction"
  • • "Time from first to last systemic reaction"
Assigned

For each subject having any reactogenicity occurrence records (with PARAM value ending with 'occurrence indicator' and AVALC = 'Y'), an additional derived record exists with PARAM set to 'Time from first to last local or systemic reaction'. For each subject having any local reaction occurrence records (with PARAM value ending with 'occurrence indicator' and AVALC = 'Y' and PARCAT1 = 'local'), an additional derived record exists with PARAM set to 'Time from first to last local reaction'. For each subject having any systemic reaction occurrence records (with PARAM value ending with 'occurrence indicator' and AVALC = 'Y' and PARCAT1 = 'systemic'), an additional derived record exists with PARAM set to 'Time from first to last systemic reaction'. Traceability variables for these additional records are obtained from the last record meeting the criteria for the given PARAM value, when sorted by USUBJID, ADY, and PARAMN (i.e. the latest event).

SRCVAR = "" and
AVALCAT1 = "grade >= 3"
Parameter for time from first to last grade>=3 occurrence recordstext66Parameter for Time from 1st to last grade>=3 occurrence record in ADFACEVD
  • • "Time from first to last local or systemic reaction with grade >= 3"
  • • "Time from first to last local reaction with grade >= 3"
  • • "Time from first to last systemic reaction with grade >= 3"
Assigned

For each subject having any reactogenicity severity records with grade >= 3 (with PARAM value ending with 'severity/intensity' and AVALCAT1 = 'grade >= 3'), an additional derived record exists with PARAM set to 'Time from first to last local or systemic reaction with grade >= 3'. For each subject having any local reaction severity records with grade >= 3 (with PARAM value ending with 'severity/intensity' and PARCAT1 = 'local' and AVALCAT1 = 'grade >= 3'), an additional derived record exists with PARAM set to 'Time from first to last local reaction with grade >= 3'. For each subject having any systemic reaction severity records with grade >= 3 (with PARAM values ending with 'severity/intensity' and PARCAT1 = 'systemic' and AVALCAT1 = 'grade >= 3'), an additional derived record exists with PARAM set to 'Time from first to last systemic reaction with grade >= 3'. Traceability variables for these additional records are obtained from the last record meeting the criteria for the given PARAM value, when sorted by USUBJID, ADY, and PARAMN (i.e. the latest event).

PARAMCDParameter Codetext8Parameter Code in ADFACEVD

[42 Terms]

Assigned

See Controlled Terminology for mapping from PARAM (Decode) to PARAMCD (Code).

PARAMNParameter (N)integer8Parameter (N) in ADFACEVD

[42 Terms]

Assigned

See Controlled Terminology for mapping from PARAM (Decode) to PARAMN (Code).

FAOBJObject of the Observationtext45Object of the Observation in ADFACEVD

[14 Terms]

Predecessor: FA.FAOBJ
FATESTFindings About Test Nametext20Findings About Test Name in ADFACEVD
  • • "Occurrence Indicator"
  • • "Severity/Intensity"
Predecessor: FA.FATEST
FATESTCDFindings About Test Short Nametext5Findings About Test Short Name in ADFACEVD
  • • "OCCUR"
  • • "SEV"
Predecessor: FA.FATESTCD
VSTESTVital Signs Test Nametext11Vital Signs Test Name in ADFACEVD
  • • "Temperature"
Predecessor: VS.VSTEST
VSTESTCDVital Signs Test Short Nametext4Vital Signs Test Short Name in ADFACEVD
  • • "TEMP"
Predecessor: VS.VSTESTCD
PARCAT1Parameter Category 1text8Parameter Category 1 in ADFACEVD
  • • "local"
  • • "systemic"
Derived
Null for records containing information about both local and systemic reactions (when PARAMCD is 'TTEFAR', 'TTEFAR3', 'DURAR', or 'DURAR3'). Otherwise, 'local' when FASCAT = 'ADMINISTRATION SITE', and 'systemic' when FASCAT = 'SYSTEMIC' or SRCDOM = 'VS'.
FASCATSubcategory for Findings Abouttext19Subcategory for Findings About in ADFACEVD
  • • "ADMINISTRATION SITE"
  • • "SYSTEMIC"
Predecessor: FA.FASCAT
AVALVLMAnalysis Valueinteger8

Null for occurrence indicator records (when PARAMCD begins with 'OC').

PARAMCD IN (
"SEVARTHR" (Arthralgia severity/intensity),
"SEVCHIL" (Chills severity/intensity),
"SEVDIAR" (Diarrhea severity/intensity),
"SEVFATI" (Fatigue severity/intensity),
"SEVFEVER" (Fever severity/intensity),
"SEVHEAD" (Headache severity/intensity),
"SEVLOA" (Loss of Appetite severity/intensity),
"SEVMALAI" (Malaise severity/intensity),
"SEVMYALG" (Myalgia severity/intensity),
"SEVNAUS" (Nausea severity/intensity),
"SEVPIS" (Pain at injection site severity/intensity),
"SEVREDN" (Redness severity/intensity),
"SEVSWEL" (Swelling severity/intensity),
"SEVTIS" (Tenderness at injection site severity/intensity),
"SEVVOMI" (Vomiting severity/intensity)
)
Analysis Value for severity/intensity recordsinteger1
Derived
1 when AVALC = 'Mild'; 2 when AVALC = 'Moderate'; 3 when AVALC = 'Severe'; 4 when AVALC = 'Potentially life threatening'.
PARAMCD IN (
"TTEFAR" (Time to first local or systemic reaction),
"TTEFAR3" (Time to first local or systemic reaction with grade >= 3),
"TTEFLR" (Time to first local reaction),
"TTEFLR3" (Time to first local reaction with grade >= 3),
"TTEFSR" (Time to first systemic reaction),
"TTEFSR3" (Time to first systemic reaction with grade >= 3)
)
Analysis Value for time to first reaction recordsinteger2
Predecessor: ADFACEVD.ADY
PARAMCD IN (
"DURAR" (Time from first to last local or systemic reaction),
"DURAR3" (Time from first to last local or systemic reaction with grade >= 3),
"DURLR" (Time from first to last local reaction),
"DURLR3" (Time from first to last local reaction with grade >= 3),
"DURSR" (Time from first to last systemic reaction),
"DURSR3" (Time from first to last systemic reaction with grade >= 3)
)
Analysis Value for time from first to last reaction recordsinteger2
Derived
Number of days between first and last report of reaction for given subject and reaction category: ADFACEVD.AENDY - ADFACEVD.AESTDY + 1.
AVALCVLMAnalysis Value (C)text8

Null for time to first reaction and time from first to last reaction records (when PARAMCD begins with 'TTEF' or 'DUR').

SRCVAR = "FASTRESC" and
FATESTCD = "OCCUR"
Analysis Value (C) for FACE occurrence recordstext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: FACE.FASTRESC
SRCVAR = "FASTRESC" and
FATESTCD = "SEV"
Analysis Value (C) for FACE severity/intensity recordstext8Analysis Value (C) for severity/intensity records in ADFACEVD
  • • "Mild"
  • • "Moderate"
  • • "Severe"
  • • "Potentially Life Threatening"
Derived
FASTRESC in proper case.
PARAMCD = "OCFEVER" (Fever occurrence indicator)Analysis Value (C) for Fever occurrence recordstext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
'Y' when VSSTRESN >= 38.0; 'N', otherwise.
PARAMCD = "SEVFEVER" (Fever severity/intensity)Analysis Value (C) for Fever severity/intensity recordstext8Analysis Value (C) for severity/intensity records in ADFACEVD
  • • "Mild"
  • • "Moderate"
  • • "Severe"
  • • "Potentially Life Threatening"
Derived
'Mild' when 38.0 <= VSSTRESN <= 38.4; 'Moderate' when 38.4 < VSSTRESN <= 38.9; 'Severe' when 38.9 < VSSTRESN <= 40.0; 'Potentially life threatening' when 40.0 < VSSTRESN.
FASTRESCCharacter Result/Finding in Std Formattext8Character Result/Finding in Std Format in ADFACEVD

[6 Terms]

Predecessor: FA.FASTRESC
VSSTRESNNumeric Result/Finding in Standard Unitsfloat4
Predecessor: VS.VSSTRESN
AVALCAT1VLMAnalysis Value Category 1text10
PARAMCD IN (
"SEVARTHR" (Arthralgia severity/intensity),
"SEVCHIL" (Chills severity/intensity),
"SEVDIAR" (Diarrhea severity/intensity),
"SEVFATI" (Fatigue severity/intensity),
"SEVFEVER" (Fever severity/intensity),
"SEVHEAD" (Headache severity/intensity),
"SEVLOA" (Loss of Appetite severity/intensity),
"SEVMALAI" (Malaise severity/intensity),
"SEVMYALG" (Myalgia severity/intensity),
"SEVNAUS" (Nausea severity/intensity),
"SEVPIS" (Pain at injection site severity/intensity),
"SEVREDN" (Redness severity/intensity),
"SEVSWEL" (Swelling severity/intensity),
"SEVTIS" (Tenderness at injection site severity/intensity),
"SEVVOMI" (Vomiting severity/intensity)
)
Analysis Value Category 1 for severity/intensity recordstext10Analysis Value Category 1 for severity/intensity records in ADFACEVD
  • • "grade < 3"
  • • "grade >= 3"
Derived
'grade < 3' when AVAL < 3; 'grade >= 3' when AVAL >= 3.
PARAMCD IN (
"TTEFAR3" (Time to first local or systemic reaction with grade >= 3),
"TTEFLR3" (Time to first local reaction with grade >= 3),
"TTEFSR3" (Time to first systemic reaction with grade >= 3),
"DURAR3" (Time from first to last local or systemic reaction with grade >= 3),
"DURLR3" (Time from first to last local reaction with grade >= 3),
"DURSR3" (Time from first to last systemic reaction with grade >= 3)
)
Analysis Value Category 1 for time to first or time from first to last grade >= 3 occurrence recordstext10Analysis Value Category 1 for time to first or time from first to last grade >= 3 occurrence records in ADFACEVD
  • • "grade >= 3"
Predecessor: ADFACEVD.PARCAT1
SRCDOMSource Datatext2Source Data in ADFACEVD
  • • "FA"
  • • "VS"
Assigned

'FA' for records from SDTM FACE domain; 'VS' for records from SDTM VS domain.

SRCVARSource Variabletext8Source Variable in ADFACEVD
  • • "FASTRESC"
  • • "VSSTRESN"
  • • "FADY"
  • • "VSDY"
Assigned

'FASTRESC' for original records and 'FADY' for generated time to first occurrence records from SDTM FACE domain. 'VSSTRESN' for original records and 'VSDY' for generated time to first occurrence records from SDTM VS domain.

SRCSEQVLMSource Sequence Numberinteger8
SRCDOM = "FA"Source Sequence Numberinteger8
Predecessor: FA.FASEQ
SRCDOM = "VS"Source Sequence Numberinteger8
Predecessor: VS.VSSEQ
FALNKIDLink IDtext83
Predecessor: FA.FALNKID
FALNKGRPLink Group IDtext77
Predecessor: FA.FALNKGRP
VSLNKIDLink IDtext37
Predecessor: VS.VSLNKID
VSLNKGRPLink Group IDtext37
Predecessor: VS.VSLNKGRP
AGEAgeinteger8
Predecessor: ADSL.AGE
AGEUAge Unitstext5Age Unit
  • • "YEARS" = "Year"
Predecessor: ADSL.AGEU
SEXSextext1Sex
  • • "M" = "Male"
  • • "F" = "Female"
Predecessor: ADSL.SEX
SEXNSex (N)integer8
Predecessor: ADSL.SEXN
RACERacetext25Race

[9 Terms]

Predecessor: ADSL.RACE
RACENRace (N)integer8
Predecessor: ADSL.RACEN
SCRFLScreened Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SCRFL
SCRFNScreened Population Flag (N)integer8
Predecessor: ADSL.SCRFN
SAFFLSafety Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SAFFL
SAFFNSafety Population Flag (N)integer8
Predecessor: ADSL.SAFFN
SAFBFLSafety Boost Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SAFBFL
SAFBFNSafety Boost Population Flag (N)integer8
Predecessor: ADSL.SAFBFN
IMMFLImmunogenicity Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.IMMFL
IMMFNImmunogenicity Population Flag (N)integer8
Predecessor: ADSL.IMMFN
PPROTFLPer-Protocol Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.PPROTFL
PPROTFNPer-Protocol Population Flag (N)integer8
Predecessor: ADSL.PPROTFN
CP7FLPrime + 7 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CP7FL
CP7FNPrime + 7 Days Completers Set (N)integer8
Predecessor: ADSL.CP7FN
CPBP28FLPrime to Boost or Prime +28 D. Comp. Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CPBP28FL
CPBP28FNPri. to Bo. or Pri. +28 D. Comp. Set (N)integer8
Predecessor: ADSL.CPBP28FN
CB7FLBoost + 7 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CB7FL
CB7FNBoost + 7 Days Completers Set (N)integer8
Predecessor: ADSL.CB7FN
CB28FLBoost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CB28FL
CB28FNBoost + 28 Days Completers Set (N)integer8
Predecessor: ADSL.CB28FN
CPB28FLPrime or Boost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CPB28FL
CPB28FNPrime or Boost + 28 Days Comp. Set (N)integer8
Predecessor: ADSL.CPB28FN
COMPLFLCompleters Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.COMPLFL
COMPLFNCompleters Population Flag (N)integer8
Predecessor: ADSL.COMPLFN
TRTSDTDate of First Exposure to TreatmentintegerDATE9
Predecessor: ADSL.TRTSDT
TRTSDTMDatetime of First Exposure to TreatmentintegerDATETIME19
Predecessor: ADSL.TRTSDTM
TRTSTMTime of First Exposure to TreatmentintegerTIME5
Predecessor: ADSL.TRTSTM
TRTEDTDate of Last Exposure to TreatmentintegerDATE9
Predecessor: ADSL.TRTEDT
TRTEDTMDatetime of Last Exposure to TreatmentintegerDATETIME19
Predecessor: ADSL.TRTEDTM
TRTETMTime of Last Exposure to TreatmentintegerTIME5
Predecessor: ADSL.TRTETM
ALLOCDTDate of AllocationintegerDATE9
Predecessor: ADSL.ALLOCDT
ALLOCTMTime of AllocationintegerTIME5
Predecessor: ADSL.ALLOCTM
ALLOCDTMDatetime of AllocationintegerDATETIME19
Predecessor: ADSL.ALLOCDTM
PRIMDTDate of Prime ImmunizationintegerDATE9
Predecessor: ADSL.PRIMDT
PRIMTMTime of Prime ImmunizationintegerTIME5
Predecessor: ADSL.PRIMTM
PRIMDTMDatetime of Prime ImmunizationintegerDATETIME19
Predecessor: ADSL.PRIMDTM
BOIMDTDate of Boost ImmunizationintegerDATE9
Predecessor: ADSL.BOIMDT
BOIMTMTime of Boost ImmunizationintegerTIME5
Predecessor: ADSL.BOIMTM
BOIMDTMDatetime of Boost ImmunizationintegerDATETIME19
Predecessor: ADSL.BOIMDTM

Go to the top of the Define-XML document


Laboratory Analysis Dataset (ADLB)

ADLB (Laboratory Analysis Dataset) - BASIC DATA STRUCTURE Location: adlb.xpt
VariableWhere ConditionLabel / DescriptionTypeLength or Display FormatControlled Terms or ISO FormatOrigin / Source / Method / Comment
STUDYIDStudy Identifiertext9
Predecessor: ADSL.STUDYID
USUBJIDUnique Subject Identifiertext21
Predecessor: ADSL.USUBJID
SUBJIDSubject Identifier for the Studytext5
Predecessor: ADSL.SUBJID
SUBJIDNSubject Identifier for the Study (N)integer8
Predecessor: ADSL.SUBJIDN
COHORTCohorttext8Cohort

[7 Terms]

Predecessor: ADSL.COHORT
COHORTNCohort (N)integer8
Predecessor: ADSL.COHORTN
GROUPGrouptext12Group
  • • "B (BNT162b1)"
  • • "C (BNT162b2)"
Predecessor: ADSL.GROUP
GROUPNGroup (N)integer8
Predecessor: ADSL.GROUPN
TRTPPlanned Treatmenttext5Planned Treatment

[7 Terms]

Predecessor: ADSL.TRT01P
TRTPNPlanned Treatment (N)integer8
Predecessor: ADSL.TRT01PN
TRTAActual Treatmenttext5Actual Treatment

[7 Terms]

Predecessor: ADSL.TRT01A
TRTANActual Treatment (N)integer8
Predecessor: ADSL.TRT01AN
LBSEQSequence Numberinteger8
Predecessor: LB.LBSEQ
ASEQAnalysis Sequence Numberinteger8
Derived
Sort by USUBJID,PARAMCD, AVISITN. Assign sequential numbers starting with 1 for each subject.
PARAMParametertext48
Derived
PARAM=strip(LB.LBTEST)<||"("||strip(LB.LBSPEC)||")"||>"["||strip(LB.LBSTRESU)||"]" if same lab test is done in 2 or more categories then LB.LBSPEC is included. If not, just the LB.LBTEST and LB.LBSTRESU are used to assign PARAM. If LB.LBSTRESU is missing for a given test, LB.LBORRESU has been used.
PARAMCDParameter Codetext8
Derived
LB.LBTESTCD||<suffix as needed>, if same lab test is done in 2 or more categories or has different specimen type then suffix is updated with "B" "BS" "U" "UD" "UM". B for Blood, BS for Blood Serum, U for Urine, UD for Urine and Dipstick method, UM for Urine and Microscopy method. Adjust PARAMCD accordingly.
PARAMNParameter (N)integer8
Derived
=1 for PARAMCD='ALT' 1 ; =2 for PARAMCD='ALB';=3 for PARAMCD='ALP'; =4 for PARAMCD='AMPHET'; =5 for PARAMCD='AMYLASE'; =6 for PARAMCD='ANISO'; =7 for PARAMCD='AST'; =8 for PARAMCD='BACT'; =9 for PARAMCD='BARB'; =10 for PARAMCD='BASOB'; =13 for PARAMCD='BASOBS'; =14 for PARAMCD='BASOLEB'; =15 for PARAMCD='BASOLEBS'; =16 for PARAMCD='BNZDZPN'; =17 for PARAMCD='BILIS'; =18 for PARAMCD='BILIU'; =19 for PARAMCD='CRP'; =20 for PARAMCD='CA';=21 for PARAMCD='CANNAB'; =22 for PARAMCD='CASTS'; =23 for PARAMCD='HCG'; =24 for PARAMCD='COCAINE'; =25 for PARAMCD='CK'; =26 for PARAMCD='CREAT'; =27 for PARAMCD='CRYSTALS'; =28 for PARAMCD='EOSB'; =31 for PARAMCD='EOSBS'; =32 for PARAMCD='EOSLEB'; =33 for PARAMCD='EOSLEBS'; =34 for PARAMCD='EPIC'; =35 for PARAMCD='MCHC'; =36 for PARAMCD='MCH'; =37 for PARAMCD='MCV'; =38 for PARAMCD='RBCB'; =39 for PARAMCD='RBCU'; =40 for PARAMCD='ETHANOL'; =43 for PARAMCD='FERRITIN'; =44 for PARAMCD='FSH'; =45 for PARAMCD='GGT'; =46 for PARAMCD='GLUCB'; =47 for PARAMCD='GLUCU'; =49 for PARAMCD='HCT'; =50 for PARAMCD='HGBB'; =51 for PARAMCD='HGBU'; =52 for PARAMCD='KETONES'; =53 for PARAMCD='WBCB'; =54 for PARAMCD='WBCUD'; =55 for PARAMCD='WBCUM'; =56 for PARAMCD='LIPASET'; =57 for PARAMCD='LYMB'; =60 for PARAMCD='LYMBS'; =61 for PARAMCD='LYMATLE'; =62 for PARAMCD='LYMLEB'; =63 for PARAMCD='LYMLEBS'; =64 for PARAMCD='METHDN'; =65 for PARAMCD='METHAMPH'; =66 for PARAMCD='MICROCY'; =67 for PARAMCD='MONOB'; =70 for PARAMCD='MONOBS'; =71 for PARAMCD='MONOLEB'; =72 for PARAMCD='MONOLEBS'; =73 for PARAMCD='MYCY'; =74 for PARAMCD='NEUTB'; =77 for PARAMCD='NEUTBS'; =78 for PARAMCD='NEUTLEB'; =79 for PARAMCD='NEUTLEBS'; =80 for PARAMCD='NITRITE'; =81 for PARAMCD='OPIATE'; =82 for PARAMCD='PH'; =83 for PARAMCD='PCP'; =84 for PARAMCD='PLAT'; =85 for PARAMCD='POIKILO'; =86 for PARAMCD='K'; =87 for PARAMCD='PROT'; =88 for PARAMCD='EPIROCE'; =89 for PARAMCD='SMDGCELE'; =90 for PARAMCD='SODIUM'; =91 for PARAMCD='SPGRAV'; =92 for PARAMCD='TRCYANDP'; =93 for PARAMCD='UREAN' ; =94 for PARAMCD='UROBIL'; =95 for PARAMCD='YEAST';
PARCAT1Parameter Category 1text10Parameter Category 1
  • • "Chemistry"
  • • "Hematology"
  • • "Urinalysis"
Derived
LB.LBCAT
PARCAT1NParameter Category 1 (N)integer8
Derived
Numeric Code of PARCAT1, CHEMISTRY=1; HEMATOLOGY=2 ; URINALYSIS=3;
PARCAT2Parameter Category 2text13Parameter Category 2
  • • "Drug of Abuse"
  • • "Pregnancy"
Derived
LB.LBSCAT
PARCAT2NParameter Category 2 (N)integer8
Derived
Numeric Code of PARCAT2, DRUG OF ABUSE=1; PREGNANCY=2
LBSPECSpecimen Typetext11Specimen Type
  • • "BLOOD" = "Blood"
  • • "BLOOD SMEAR" = "BLOOD SMEAR"
  • • "EXPIRED AIR" = "Expired Air"
  • • "SERUM" = "Serum"
  • • "URINE" = "Urine"
Predecessor: LB.LBSPEC
AVALVLMAnalysis Valuefloat8
PARAMCD = "ALB"Albumin [g/L]integer2
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "ALP"Alkaline Phosphatase [U/L]float3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "ALT"Alanine Aminotransferase [U/L]float3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "AMYLASE"Amylase [U/L]integer3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "AST"Aspartate Aminotransferase [U/L]float3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "BASOB"Basophils (Blood) [10^9/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "BASOLEB"Basophils/Leukocytes (Blood) [%]float3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "BILIS"Bilirubin (Serum) [umol/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "CA"Calcium [mmol/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "CREAT"Creatinine [umol/L]float5
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "CRP"C Reactive Protein [mg/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "EOSB"Eosinophils (Blood) [10^9/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "EOSLEB"Eosinophils/Leukocytes (Blood) [%]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "FERRITIN"Ferritin [ug/L]float5
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "GGT"Gamma Glutamyl Transferase [U/L]integer3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "GLUCB"Glucose (Blood) [mmol/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "HCT"Hematocrit [L/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "HGBB"Hemoglobin (Blood) [mmol/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "HGBU"Hemoglobin (Urine) [10^6/L]integer3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "K"Potassium [mmol/L]float3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "LIPASET"Lipase [U/L]integer3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "LYMB"Lymphocytes (Blood) [10^9/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "LYMLEB"Lymphocytes/Leukocytes (Blood) [%]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "MONOB"Monocytes (Blood) [10^9/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "MONOLEB"Monocytes/Leukocytes (Blood) [%]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "NEUTB"Neutrophils (Blood) [10^9/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "NEUTLEB"Neutrophils/Leukocytes (Blood) [%]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "PH"pHfloat3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "PLAT"Platelets [10^9/L]integer3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "PROT"Protein [mg/L]integer4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "RBCB"Erythrocytes (Blood) [10^12/L]float3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "SODIUM"Sodium [mmol/L]integer3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "SPGRAV"Specific Gravityfloat5
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "UREAN"Urea Nitrogen [mmol/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "WBCB"Leukocytes (Blood) [10^9/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "WBCUD"Leukocytes (Urine - Dipstick) [10^6/L]float6
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "BILIU"Bilirubin (Urine) [umol/L]integer2
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "KETONES"Ketones [mmol/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "UROBIL"Urobilinogen [umol/L]integer2
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "FSH"Follicle Stimulating Hormone [IU/L]float5
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "MCH"Ery. Mean Corpuscular Hemoglobin [fmol]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "MCHC"Ery. Mean Corpuscular HGB Concentration [mmol/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "MCV"Ery. Mean Corpuscular Volume [fL]float5
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "CK"Creatine Kinase [U/L]integer3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "BASOBS"Basophils (Blood Smear) [10^9/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "BASOLEBS"Basophils/Leukocytes (Blood Smear) [%]integer1
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "EOSBS"Eosinophils (Blood Smear) [10^9/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "EOSLEBS"Eosinophils/Leukocytes (Blood Smear) [%]integer1
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "LYMATLE"Lymphocytes Atypical/Leukocytes [%]integer2
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "LYMBS"Lymphocytes (Blood Smear) [10^9/L]float3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "LYMLEBS"Lymphocytes/Leukocytes (Blood Smear) [%]integer2
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "MONOBS"Monocytes (Blood Smear) [10^9/L]float4
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "MONOLEBS"Monocytes/Leukocytes (Blood Smear) [%]integer2
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "NEUTBS"Neutrophils (Blood Smear) [10^9/L]float3
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "NEUTLEBS"Neutrophils/Leukocytes (Blood Smear) [%]integer2
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "SMDGCELE"Smudge Cells/Leukocytes [%]integer2
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
PARAMCD = "MYCY"Myelocytes [%]integer1
Derived
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
AVALCVLMAnalysis Value (C)text50
PARCAT2 = "Drug of Abuse"Drug of Abuse Categorytext8Negative/Positive Result
  • • "negative" = "No"
  • • "positive" = "Yes"
Predecessor: LB.LBSTRESC
PARAMCD = "ALB"Albumin [g/L]text2
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "ALP"Alkaline Phosphatase [U/L]text3
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "ALT"Alanine Aminotransferase [U/L]text3
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "AMYLASE"Amylase [U/L]text3
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "AST"Aspartate Aminotransferase [U/L]text3
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "BACT"Bacteria [/HPF]text14Analysis Value (C)

[7 Terms]

Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "BASOB"Basophils (Blood) [10^9/L]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "BASOLEB"Basophils/Leukocytes (Blood) [%]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "BILIS"Bilirubin (Serum) [umol/L]text4
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "BILIU"Bilirubin (Urine) [umol/L]text8Analysis Value (C)
  • • "17.0"
  • • "negative"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "CA"Calcium [mmol/L]text5
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "CASTS"Casts [/HPF]text14Analysis Value (C)
  • • "negative"
  • • "positive"
  • • "not detectable"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "CREAT"Creatinine [umol/L]text5
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "CRP"C Reactive Protein [mg/L]text4
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "CRYSTALS"Crystals [/HPF]text14Analysis Value (C)
  • • "negative"
  • • "positive"
  • • "not detectable"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "EOSB"Eosinophils (Blood) [10^9/L]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "EOSLEB"Eosinophils/Leukocytes (Blood) [%]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "EPIC"Epithelial Cells [/HPF]text14Analysis Value (C)

[9 Terms]

Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "EPIROCE"Round Epithelial Cells [/HPF]text14Analysis Value (C)
  • • "0-2"
  • • "negative"
  • • "not detectable"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "FERRITIN"Ferritin [ug/L]text5
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "GGT"Gamma Glutamyl Transferase [U/L]text3
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "GLUCB"Glucose (Blood) [mmol/L]text4
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "GLUCU"Glucose (Urine)text8Negative/Positive Result
  • • "negative" = "No"
  • • "positive" = "Yes"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "HCG"Choriogonadotropin Betatext8Negative/Positive Result
  • • "negative" = "No"
  • • "positive" = "Yes"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "HCT"Hematocrit [L/L]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "HGBB"Hemoglobin (Blood) [mmol/L]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "HGBU"Hemoglobin (Urine) [10^6/L]text8Analysis Value (C)

[6 Terms]

Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "K"Potassium [mmol/L]text50
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "KETONES"Ketones [mmol/L]text8Analysis Value (C)
  • • "0.5"
  • • "1.5"
  • • "5.0"
  • • "15.0"
  • • "negative"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "LIPASET"Lipase [U/L]text3
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "LYMB"Lymphocytes (Blood) [10^9/L]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "LYMLEB"Lymphocytes/Leukocytes (Blood) [%]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "MONOB"Monocytes (Blood) [10^9/L]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "MONOLEB"Monocytes/Leukocytes (Blood) [%]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "NEUTB"Neutrophils (Blood) [10^9/L]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "NEUTLEB"Neutrophils/Leukocytes (Blood) [%]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "NITRITE"Nitritetext8Negative/Positive Result
  • • "negative" = "No"
  • • "positive" = "Yes"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "PH"pHtext3
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "PLAT"Platelets [10^9/L]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "PROT"Protein [mg/L]text8Analysis Value (C)
  • • "250"
  • • "750"
  • • "1500"
  • • "5000"
  • • "negative"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "RBCB"Erythrocytes (Blood) [10^12/L]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "RBCU"Erythrocytes (Urine) [/HPF]text14Analysis Value (C)

[8 Terms]

Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "SODIUM"Sodium [mmol/L]text3
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "SPGRAV"Specific Gravitytext5
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "UREAN"Urea Nitrogen [mmol/L]text4
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "UROBIL"Urobilinogen [umol/L]text6Analysis Value (C)
  • • "17"
  • • "68"
  • • "normal"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "WBCB"Leukocytes (Blood) [10^9/L]text10
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "WBCUD"Leukocytes (Urine - Dipstick) [10^6/L]text8Analysis Value (C)
  • • "25"
  • • "100"
  • • "500"
  • • "negative"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "WBCUM"Leukocytes (Urine - Microscopy) [/HPF]text14Analysis Value (C)

[8 Terms]

Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "FSH"Follicle Stimulating Hormone [IU/L]text5
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "MCH"Ery. Mean Corpuscular Hemoglobin [fmol]text4
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "MCHC"Ery. Mean Corpuscular HGB Concentration [mmol/L]text4
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "MCV"Ery. Mean Corpuscular Volume [fL]text5
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "CK"Creatine Kinase [U/L]text3
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "BASOBS"Basophils (Blood Smear) [10^9/L]text4
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "BASOLEBS"Basophils/Leukocytes (Blood Smear) [%]text1
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "EOSBS"Eosinophils (Blood Smear) [10^9/L]text4
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "EOSLEBS"Eosinophils/Leukocytes (Blood Smear) [%]text1
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "LYMATLE"Lymphocytes Atypical/Leukocytes [%]text2
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "LYMBS"Lymphocytes (Blood Smear) [10^9/L]text3
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "LYMLEBS"Lymphocytes/Leukocytes (Blood Smear) [%]text2
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "MONOBS"Monocytes (Blood Smear) [10^9/L]text4
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "MONOLEBS"Monocytes/Leukocytes (Blood Smear) [%]text2
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "NEUTBS"Neutrophils (Blood Smear) [10^9/L]text3
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "NEUTLEBS"Neutrophils/Leukocytes (Blood Smear) [%]text2
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "POIKILO"Poikilocytestext3Analysis Value (C)
  • • "+"
  • • "++"
  • • "+++"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "SMDGCELE"Smudge Cells/Leukocytes [%]text2
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "ANISO"Anisocytestext2Analysis Value (C)
  • • "+"
  • • "++"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "YEAST"Yeast Cells [/HPF]text3Analysis Value (C)
  • • "(+)"
  • • "++"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "MICROCY"Microcytestext2Analysis Value (C)
  • • "+"
  • • "++"
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
PARAMCD = "MYCY"Myelocytes [%]text1
Derived
Character of AVAL. if AVAL=. then LB.LBSTRESC.
LBCLSIGClinically Significanttext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: SUPPLB.QVAL where QNAM='LBCLSIG'
LBCLSIGNClinically Significant (N)integer8
Derived
numeric of LB.LBCLSIG, Y=1, N=0
ABLFLBaseline Record Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
ABLFL='Y' for last non-missing AVAL/AVALC when Analysis date (ADLB.ADT) is on/before treatment start (ADLB.TRTSDT).
BASEBaseline Valuefloat8
Derived
BASE=AVAL, when ABLFL="Y"
BASECBaseline Value (C)text50Baseline Value (C)

[15 Terms]

Derived
Character of BASE
CHGChange from Baselinefloat8
Derived
When AVAL and BASE are non-missing CHG = AVAL - BASE. if AVAL=0 & BASE=0 then CHG=.
PCHGPercent Change from Baselinefloat8
Derived
PCHG = ((AVAL - BASE)/BASE)*100 when AVAL and BASE are not missing.
ANRINDAnalysis Reference Range Indicatortext8Analysis Reference Range Indicator
  • • "Low"
  • • "Normal"
  • • "High"
  • • "Abnormal"
  • • "Missing"
Derived
Derived based on AVAL, ANRHI, ANRLO. For Urinalysis NEGATIVE, NORMAL are considered Normal, anything other than above are ABNORMAL. NOT DETECTABLE, INVALID VALUE are considered as MISSING. If AVAL/AVALC is missing or AVALC=+, for categories other than URINALYSIS, or (ANRHI and ANRLO) are missing but LBCLSIG is non-missing then for URINALYSIS ANRIND="Abnormal", For other categories, ANRIND="HIGH".
ANRINDNAnalysis Reference Range Indicator (N)integer8
Derived
Numeric Code of ANRIND, LOW=1, NORMAL=2, HIGH=3, ABNORMAL=4, MISSING=5
BNRINDBaseline Reference Range Indicatortext8Baseline Reference Range Indicator
  • • "Low"
  • • "Normal"
  • • "High"
  • • "Abnormal"
  • • "Missing"
Derived
BNRIND=ANRIND, when ABLFL='Y'
BNRINDNBaseline Reference Range Indicator (N)integer8
Derived
Numeric Code of BNRIND, LOW=1, NORMAL=2, HIGH=3, ABNORMAL=4, MISSING=5
ANRLOAnalysis Normal Range Lower Limitfloat8
Derived
ADLB.ANRLO=LB.LBSTNRLO. if LB.LBSTNRLO=. and LB.LBSTNRC has values as "X-Y", where X,Y are numeric variables, then X is ADLB.ANRLO.
ANRLOCAnalysis Normal Range Lower Limit (C)text5
Derived
Character of ANRLO
ANRHIAnalysis Normal Range Upper Limitfloat8
Derived
ANRHI=LB.LBSTNRHI. if LB.LBSTNRHI=. and LB.LBSTNRC has values as "X-Y", where X,Y are numeric variables, then Y is ANRHI.
ANRHICAnalysis Normal Range Upper Limit (C)text5
Derived
Character of ANRHI. If LB.LBSTNRLO is missing and LB.LBSTNRHI is non-missing then ANRHIC is shown as "<LB.LBSTNRHI+1"
NABCSNormal/Abnormal/CStext17Normal/Abnormal/CS
  • • "Abnormal (not CS)"
  • • "CS abnormal"
  • • "Missing"
  • • "Normal"
Derived
if ANRIND=abnormal and LB.LBCLSIG="Y" then NABCS= "CS Abnormal"; if ANRIND is abnormal and LB.LBCLSIG="N" then NABCS="Abnormal (not CS)"; if ANRIND is normal then NABCS="Normal"; if ANRIND=. Then NABCS="Missing" ;
NABCSNNormal/Abnormal/CS (N)integer8
Derived
Numeric Code of NABCS, Missing=1, CS abnormal=2, abnormal (not CS)=3, Normal=4
DTYPEDerivation Typetext8Derivation Type
  • • "HALF LLOQ" = "HALF LLOQ"
  • • "HALFLLOQ" = "HALFLLOQ"
Derived
Is populated for additional imputed records where LBSTRESN=. And LBSTRESC is like "<x". AVAL for these records will be 0.5*X and DTYPE="HALFLLOQ" . X is a numeric variable.
WPBFLWorst Post-Baseline Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
WPBFL=Y for the first occurance of each abnormality for a given PARAM and USUBJID. if there is no abnormality for a given parameter and subject then first post-baseline visit is flagged as 'Y'
ANL01FLAnalysis Flag 01text1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
ANL01FL='Y' for all scheduled visits and for records with DTYPE="HALFLLOQ". For records where LB.LBSTRESN=. And LB.LBSTRESC is like "<x", where x is numeric variable, ANL01FL=NULL. if ANRIND is derived based on LB.LBCLSIG then those records must be excluded from the analysis. i.e., ANLxxFL flags will be NULL. If the lab test has been performed on less than 3 subjects then those tests(PARAMs) must be excluded from the analysis. i.e., ANLxxFL flags will be NULL.
ANL02FLAnalysis Flag 02text1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
ANL02FL='Y' when DTYPE=NULL. if ANRIND is derived based on LBCLSIG then those records must be excluded from the analysis. i.e., ANLxxFL flags will be NULL. If the lab test has been performed on less than 3 subjects then those tests(PARAMs) must be excluded from the analysis. i.e., ANLxxFL flags will be NULL.
UNSVFLUnscheduled Visit Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
if LB.VISIT contains "Unscheduled" then UNSVFL="Y"; else UNSVFL=' ';
POBLFLPost-Baseline Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
POBLFL='Y' when ADTM>TRTSDTM, if ADTM=. Then use ADT/TRTSDT.
LBSTATCompletion Statustext20
Predecessor: LB.LBSTAT
LBREASNDReason Test Not Donetext200
Predecessor: LB.LBREASND
LBNAMVendor Nametext44Vendor Name
  • • "CRS CLINICAL RESEARCH SERVICES BERLIN GMBH"
  • • "CRS CLINICAL RESEARCH SERVICES MANNHEIM GMBH"
  • • "MLM"
Predecessor: LB.LBNAM
LBMETHODMethod of Test or Examinationtext36Method of Test or Examination

[10 Terms]

Predecessor: LB.LBMETHOD
LBFASTFasting Statustext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: LB.LBFAST
LBORRES1Identification for Resulttext24Identification for Result

[13 Terms]

Predecessor: SUPPLB.QVAL where QNAM='LBORRES1'
LBORRES2Second Identification for Resulttext21Second Identification for Result
  • • "Calcium Oxalates: ++"
  • • "Calcium Oxalates: +++"
Predecessor: SUPPLB.QVAL where QNAM='LBORRES2'
LBLOINC1LOINC Code for Identificationtext7LOINC Code for Identification
  • • "5782-8"
  • • "58436-7"
Predecessor: SUPPLB.QVAL where QNAM='LBLOINC1'
LBLOINC2LOINC Code for second Identificationtext6LOINC Code for second Identification
  • • "5782-8"
Predecessor: SUPPLB.QVAL where QNAM='LBLOINC2'
RBBReport Blood Counttext21Report Blood Count
  • • "cells damaged"
  • • "crenated erythrocytes"
Predecessor: SUPPLB.QVAL where QNAM='RBB'
RBB2Report Blood Count 2text21Report Blood Count 2
  • • "crenated erythrocytes"
  • • "some crenated cells"
Predecessor: SUPPLB.QVAL where QNAM='RBB2'
LBDTCDate/Time of Specimen CollectionpartialDatetimeISO 8601
Predecessor: LB.LBDTC
ADTAnalysis DateintegerDATE9
Derived
Date part of ADTM.
ATMAnalysis TimeintegerTIME5
Derived
Time part of ADTM.
ADTMAnalysis DatetimeintegerDATETIME19
Derived
LB.LBDTC as SAS datetime.
LBDYStudy Day of Specimen Collectioninteger8
Predecessor: LB.LBDY
ADYAnalysis Relative Dayinteger8
Predecessor: LB.LBDY
AVISITAnalysis Visittext26ADLB Analysis Visit

[13 Terms]

Derived
"If LB.VISIT=Visit 0 (Day -30 to 0) then AVISIT= Day -30 to 0 If LB.VISIT=Visit 1 (Day 1) then AVISIT= Day 1 If LB.VISIT=Visit 2 (Day 2) then AVISIT= Day 2 If LB.VISIT=Visit 3 (Day 8) then AVISIT= Day 8 If LB.VISIT=Visit 4 / Dosing (Day 22) then AVISIT= Day 22 If LB.VISIT=Visit 5 (Day 29) then AVISIT= Day 29 If LB.VISIT=Visit 7 / EoT Visit (Day 50) then AVISIT= Day 50 If LB.VISIT=Unscheduled 1.01 then AVISIT=Unscheduled Day -30 to 0 If LB.VISIT=Unscheduled 5.01 then AVISIT=Unscheduled Day 8 If LB.VISIT=Unscheduled 6.01 then AVISIT=Unscheduled Day 22 If LB.VISIT=Unscheduled 7.01 then AVISIT=Unscheduled Day 29 If LB.VISIT=Unscheduled 8.01 then AVISIT=Unscheduled Day 43 If LB.VISIT=Unscheduled 9.01 then AVISIT=Unscheduled Day 50
AVISITNAnalysis Visit (N)integer8
Derived
"If LB.VISIT=Visit 0 (Day -30 to 0) then AVISITN= 1 If LB.VISIT=Visit 1 (Day 1) then AVISITN= 2 If LB.VISIT=Visit 2 (Day 2) then AVISITN= 3 If LB.VISIT=Visit 3 (Day 8) then AVISITN= 5 If LB.VISIT=Visit 4 / Dosing (Day 22) then AVISITN= 6 If LB.VISIT=Visit 5 (Day 29) then AVISITN= 7 If LB.VISIT=Visit 7 / EoT Visit (Day 50) then AVISITN= 9 If LB.VISIT=Unscheduled 1.01 then AVISITN= 1.01 If LB.VISIT=Unscheduled 5.01 then AVISITN= 5.01 If LB.VISIT=Unscheduled 6.01 then AVISITN= 6.01 If LB.VISIT=Unscheduled 7.01 then AVISITN= 7.01 If LB.VISIT=Unscheduled 8.01 then AVISITN= 8.01 If LB.VISIT=Unscheduled 9.01 then AVISITN= 9.01
VISITVisit Nametext28Visit Name

[13 Terms]

Predecessor: LB.VISIT
VISITNUMVisit Numberfloat8
Predecessor: LB.VISITNUM
EPOCHEpochtext9Epoch
  • • "BASELINE" = "Baseline Epoch"
  • • "FOLLOW-UP" = "Clinical Study Follow-up"
  • • "SCREENING" = "Trial Screening"
  • • "TREATMENT" = "Treatment Epoch"
Predecessor: LB.EPOCH
COMMENT1Comments 1text97Comments 1

[15 Terms]

Derived
Comments are captured from CO domain. There will be each COMMENT<x> variable for each records in CO for a given subject. CO.COVAL is ADLB.COMMENT<x>, and corresponding CO.COEVAL is ADLB.COMEVAL<x>
COMEVAL1Comments 1 Evaluatortext12Comments 1 Evaluator
  • • "INVESTIGATOR"
  • • "LABORATORY"
Derived
Evaluator for COMMENT1 is COMEVAL1.
COMMENT2Comments 2text17Comments 2
  • • "Controlled result"
Derived
Comments are captured from CO domain. There will be each COMMENT<x> variable for each records in CO for a given subject. CO.COVAL is ADLB.COMMENT<x>, and corresponding CO.COEVAL is ADLB.COMEVAL<x>
COMEVAL2Comments 2 Evaluatortext10Comments 2 Evaluator
  • • "LABORATORY"
Derived
Evaluator for COMMENT2 is COMEVAL2.
AGEAgeinteger8
Predecessor: ADSL.AGE
AGEUAge Unitstext5Age Unit
  • • "YEARS" = "Year"
Predecessor: ADSL.AGEU
SEXSextext1Sex
  • • "M" = "Male"
  • • "F" = "Female"
Predecessor: ADSL.SEX
SEXNSex (N)integer8
Predecessor: ADSL.SEXN
RACERacetext25Race

[9 Terms]

Predecessor: ADSL.RACE
RACENRace (N)integer8
Predecessor: ADSL.RACEN
SCRFLScreened Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SCRFL
SCRFNScreened Population Flag (N)integer8
Predecessor: ADSL.SCRFN
SAFFLSafety Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SAFFL
SAFFNSafety Population Flag (N)integer8
Predecessor: ADSL.SAFFN
SAFBFLSafety Boost Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SAFBFL
SAFBFNSafety Boost Population Flag (N)integer8
Predecessor: ADSL.SAFBFN
IMMFLImmunogenicity Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.IMMFL
IMMFNImmunogenicity Population Flag (N)integer8
Predecessor: ADSL.IMMFN
PPROTFLPer-Protocol Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.PPROTFL
PPROTFNPer-Protocol Population Flag (N)integer8
Predecessor: ADSL.PPROTFN
EXPPROT1Reason 1 for Exclusion Per-Protocol Settext81Reason 1 for Exclusion Per-Protocol Set
  • • "Subject is not included in the immunogenicity set or had major protocol deviation"
Predecessor: ADSL.EXPPROT1
CP7FLPrime + 7 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CP7FL
CP7FNPrime + 7 Days Completers Set (N)integer8
Predecessor: ADSL.CP7FN
CPBP28FLPrime to Boost or Prime +28 D. Comp. Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CPBP28FL
CPBP28FNPri. to Bo. or Pri. +28 D. Comp. Set (N)integer8
Predecessor: ADSL.CPBP28FN
CB7FLBoost + 7 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CB7FL
CB7FNBoost + 7 Days Completers Set (N)integer8
Predecessor: ADSL.CB7FN
CB28FLBoost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CB28FL
CB28FNBoost + 28 Days Completers Set (N)integer8
Predecessor: ADSL.CB28FN
CPB28FLPrime or Boost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CPB28FL
CPB28FNPrime or Boost + 28 Days Comp. Set (N)integer8
Predecessor: ADSL.CPB28FN
COMPLFLCompleters Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.COMPLFL
COMPLFNCompleters Population Flag (N)integer8
Predecessor: ADSL.COMPLFN
TRTSDTDate of First Exposure to TreatmentintegerDATE9
Predecessor: ADSL.TRTSDT
TRTSTMTime of First Exposure to TreatmentintegerTIME5
Predecessor: ADSL.TRTSTM
TRTSDTMDatetime of First Exposure to TreatmentintegerDATETIME19
Predecessor: ADSL.TRTSDTM
TRTEDTDate of Last Exposure to TreatmentintegerDATE9
Predecessor: ADSL.TRTEDT
TRTETMTime of Last Exposure to TreatmentintegerTIME5
Predecessor: ADSL.TRTETM
TRTEDTMDatetime of Last Exposure to TreatmentintegerDATETIME19
Predecessor: ADSL.TRTEDTM
ALLOCDTDate of AllocationintegerDATE9
Predecessor: ADSL.ALLOCDT
ALLOCTMTime of AllocationintegerTIME5
Predecessor: ADSL.ALLOCTM
ALLOCDTMDatetime of AllocationintegerDATETIME19
Predecessor: ADSL.ALLOCDTM
SRCDOMSource Datatext2ADLBSource Data
  • • "LB"
Derived
LB.DOMAIN
SRCVARSource Variabletext7ADLBSource Variable
  • • "LBORRES"
Assigned

Set to 'LBORRES'.

SRCSEQSource Sequence Numberinteger8
Derived
LB.LBSEQ

Go to the top of the Define-XML document


Immunogenicity Analysis Dataset (ADVA)

ADVA (Immunogenicity Analysis Dataset) - BASIC DATA STRUCTURE Location: adva.xpt
VariableWhere ConditionLabel / DescriptionTypeLength or Display FormatControlled Terms or ISO FormatOrigin / Source / Method / Comment
STUDYIDStudy Identifiertext9
Predecessor: ADSL.STUDYID
USUBJIDUnique Subject Identifiertext21
Predecessor: ADSL.USUBJID
SUBJIDSubject Identifier for the Studytext5
Predecessor: ADSL.SUBJID
SITEIDStudy Site Identifiertext12Study Site Identifier
  • • "CRS Berlin"
  • • "CRS Mannheim"
Predecessor: ADSL.SITEID
TRTPPlanned Treatmenttext5Planned Treatment

[7 Terms]

Predecessor: ADSL.TRT01P
TRTPNPlanned Treatment (N)integer8
Predecessor: ADSL.TRT01PN
TRTAActual Treatmenttext5Actual Treatment

[7 Terms]

Predecessor: ADSL.TRT01A
TRTANActual Treatment (N)integer8
Predecessor: ADSL.TRT01AN
ADTAnalysis DateintegerDATE9
Derived
ADT = date part of IS.ISDTC
ADTMAnalysis DatetimeintegerDATETIME19
Derived
numeric value of IS.ISDTC
ATMAnalysis TimeintegerTIME5
Derived
ATM = time part of IS.ISDTC
ADYAnalysis Relative Dayinteger8
Derived
Analysis date relative to treatment start: ADT - TRTSDT + 1, when ADT is on or after TRTSDT; ADT - TRTSDT, when ADT is before TRTSDT.
AVISITAnalysis Visittext28ADVA Analysis Visit

[8 Terms]

Derived
AVISIT=IS.VISIT
AVISITNAnalysis Visit (N)float8
Assigned

Numeric analysis visit per windowing meta file or numeric cycle number based on g_ADVA_visit_cycles parameter.

PARAMVLMParametertext48
PARAMCD IN (
"C19S1IGG" (COVID-19 S1 IgG (U/mL)),
"C19RBDIG" (COVID-19 RBD IgG (U/mL))
)
COVID-19 Parameterstext23ADVA Parameter (COVID-19)
  • • "COVID-19 RBD IgG (U/mL)"
  • • "COVID-19 S1 IgG (U/mL)"
Derived
Concatenation of IS.ISTEST and IS.ISSTRESU in parentheses.
PARAMCD IN (
"C2NGNT50" (SARS-CoV-2 Serum Neutralizing Titer 50),
"C2NGNT90" (SARS-CoV-2 Serum Neutralizing Titer 90)
)
Neutralizing Titer Parameterstext38ADVA Parameter (Neutralizing Titer)
  • • "SARS-CoV-2 Serum Neutralizing Titer 50"
  • • "SARS-CoV-2 Serum Neutralizing Titer 90"
Predecessor: IS.ISTEST
PARAMCD IN (
"FRC19RBD" (COVID-19 RBD IgG Fold Rise),
"FRC19S1I" (COVID-19 S1 IgG Fold Rise),
"FRC2NT50" (SARS-CoV-2 Serum Neutralizing Titer 50 Fold Rise),
"FRC2NT90" (SARS-CoV-2 Serum Neutralizing Titer 90 Fold Rise)
)
Fold Rise Parameterstext48ADVA Parameter (Fold Rise)
  • • "COVID-19 RBD IgG Fold Rise"
  • • "COVID-19 S1 IgG Fold Rise"
  • • "SARS-CoV-2 Serum Neutralizing Titer 50 Fold Rise"
  • • "SARS-CoV-2 Serum Neutralizing Titer 90 Fold Rise"
Assigned

'COVID-19 RBD IgG Fold Rise' when record created from original record having PARAMCD='C19RBDIG'; 'COVID-19 S1 IgG Fold Rise' when record created from original record having PARAMCD='C19S1GG'; 'SARS-CoV-2 Serum Neutralizing Titer 50 Fold Rise' when record created from original record having PARAMCD='C2NGNT50'; 'SARS-CoV-2 Serum Neutralizing Titer 90 Fold Rise' when record created from original record having PARAMCD='C2NGNT90'.

PARAMCDParameter Codetext8ADVA Parameter Code

[8 Terms]

Assigned

Assigned values as IS.ISTESTCD for PARAMN=1,2,3,4 and assigned 'FRC19RBD' for 'COVID-19 RBD IgG Fold Rise' , 'FRC19S1I' for 'COVID-19 S1 IgG Fold Rise' , 'FRC2NT50' for 'SARS-CoV-2 Serum Neutralizing Titer 50 Fold Rise', 'FRC2NT90' for 'SARS-CoV-2 Serum Neutralizing Titer 90 Fold Rise'

PARAMNParameter (N)integer8
Assigned

Assign: 1 when paramcd="C19RBDIG" 2 when paramcd="C19S1IGG" 3 when paramcd="C2NGNT50" 4 when paramcd="C2NGNT90" 5 when paramcd="FRC19RBD" 6 when paramcd="'FRC19S1I" 7 when paramcd="FRC2NT50" 8 when paramcd="FRC2NT90"

PARCAT1Parameter Category 1text14Parameter Category 1
  • • "IMMUNOGENICITY"
Predecessor: IS.ISCAT
AVALVLMAnalysis Valuefloat15
PARAMCD = "C19RBDIG" (COVID-19 RBD IgG (U/mL))COVID-19 RBD IgG (U/mL)float10
Derived
if ISSTRESC equal to "BLQ" then set AVAL to 0.5*ISLLOQ; else set to IS.ISSTRESN. For paramn 5,6,7,8; Create new row for post baseline records of paramn 1,2,3,4 with their non-missing aval and base. for paramcd="FRC19RBD" subset if paramn=1 then aval eq aval/base. for paramcd="'FRC19S1I" subset if paramn=2 then aval eq aval/base. for paramcd="FRC2NT50" subset if paramn=3 then aval eq aval/base. for paramcd="FRC2NT90" subset if paramn=4 then aval eq aval/base.
PARAMCD = "C19S1IGG" (COVID-19 S1 IgG (U/mL))COVID-19 S1 IgG (U/mL)float11
Derived
if ISSTRESC equal to "BLQ" then set AVAL to 0.5*ISLLOQ; else set to IS.ISSTRESN. For paramn 5,6,7,8; Create new row for post baseline records of paramn 1,2,3,4 with their non-missing aval and base. for paramcd="FRC19RBD" subset if paramn=1 then aval eq aval/base. for paramcd="'FRC19S1I" subset if paramn=2 then aval eq aval/base. for paramcd="FRC2NT50" subset if paramn=3 then aval eq aval/base. for paramcd="FRC2NT90" subset if paramn=4 then aval eq aval/base.
PARAMCD = "C2NGNT50" (SARS-CoV-2 Serum Neutralizing Titer 50)SARS-CoV-2 Serum Neutralizing Titer 50float12
Derived
if ISSTRESC equal to "BLQ" then set AVAL to 0.5*ISLLOQ; else set to IS.ISSTRESN. For paramn 5,6,7,8; Create new row for post baseline records of paramn 1,2,3,4 with their non-missing aval and base. for paramcd="FRC19RBD" subset if paramn=1 then aval eq aval/base. for paramcd="'FRC19S1I" subset if paramn=2 then aval eq aval/base. for paramcd="FRC2NT50" subset if paramn=3 then aval eq aval/base. for paramcd="FRC2NT90" subset if paramn=4 then aval eq aval/base.
PARAMCD = "C2NGNT90" (SARS-CoV-2 Serum Neutralizing Titer 90)SARS-CoV-2 Serum Neutralizing Titer 90float12
Derived
if ISSTRESC equal to "BLQ" then set AVAL to 0.5*ISLLOQ; else set to IS.ISSTRESN. For paramn 5,6,7,8; Create new row for post baseline records of paramn 1,2,3,4 with their non-missing aval and base. for paramcd="FRC19RBD" subset if paramn=1 then aval eq aval/base. for paramcd="'FRC19S1I" subset if paramn=2 then aval eq aval/base. for paramcd="FRC2NT50" subset if paramn=3 then aval eq aval/base. for paramcd="FRC2NT90" subset if paramn=4 then aval eq aval/base.
PARAMCD = "FRC19RBD" (COVID-19 RBD IgG Fold Rise)COVID-19 RBD IgG Fold Risefloat14
Derived
if ISSTRESC equal to "BLQ" then set AVAL to 0.5*ISLLOQ; else set to IS.ISSTRESN. For paramn 5,6,7,8; Create new row for post baseline records of paramn 1,2,3,4 with their non-missing aval and base. for paramcd="FRC19RBD" subset if paramn=1 then aval eq aval/base. for paramcd="'FRC19S1I" subset if paramn=2 then aval eq aval/base. for paramcd="FRC2NT50" subset if paramn=3 then aval eq aval/base. for paramcd="FRC2NT90" subset if paramn=4 then aval eq aval/base.
PARAMCD = "FRC19S1I" (COVID-19 S1 IgG Fold Rise)COVID-19 S1 IgG Fold Risefloat15
Derived
if ISSTRESC equal to "BLQ" then set AVAL to 0.5*ISLLOQ; else set to IS.ISSTRESN. For paramn 5,6,7,8; Create new row for post baseline records of paramn 1,2,3,4 with their non-missing aval and base. for paramcd="FRC19RBD" subset if paramn=1 then aval eq aval/base. for paramcd="'FRC19S1I" subset if paramn=2 then aval eq aval/base. for paramcd="FRC2NT50" subset if paramn=3 then aval eq aval/base. for paramcd="FRC2NT90" subset if paramn=4 then aval eq aval/base.
PARAMCD = "FRC2NT50" (SARS-CoV-2 Serum Neutralizing Titer 50 Fold Rise)SARS-CoV-2 Serum Neutralizing Titer 50 Fold Risefloat11
Derived
if ISSTRESC equal to "BLQ" then set AVAL to 0.5*ISLLOQ; else set to IS.ISSTRESN. For paramn 5,6,7,8; Create new row for post baseline records of paramn 1,2,3,4 with their non-missing aval and base. for paramcd="FRC19RBD" subset if paramn=1 then aval eq aval/base. for paramcd="'FRC19S1I" subset if paramn=2 then aval eq aval/base. for paramcd="FRC2NT50" subset if paramn=3 then aval eq aval/base. for paramcd="FRC2NT90" subset if paramn=4 then aval eq aval/base.
PARAMCD = "FRC2NT90" (SARS-CoV-2 Serum Neutralizing Titer 90 Fold Rise)SARS-CoV-2 Serum Neutralizing Titer 90 Fold Risefloat11
Derived
if ISSTRESC equal to "BLQ" then set AVAL to 0.5*ISLLOQ; else set to IS.ISSTRESN. For paramn 5,6,7,8; Create new row for post baseline records of paramn 1,2,3,4 with their non-missing aval and base. for paramcd="FRC19RBD" subset if paramn=1 then aval eq aval/base. for paramcd="'FRC19S1I" subset if paramn=2 then aval eq aval/base. for paramcd="FRC2NT50" subset if paramn=3 then aval eq aval/base. for paramcd="FRC2NT90" subset if paramn=4 then aval eq aval/base.
AVALCAnalysis Value (C)text12
Derived
Derived as character value of AVAL.
BASEBaseline Valuefloat8
Derived
ADVA.AVAL from the record with ABLFL="Y" for this USUBJID/PARAM
CHGChange from Baselinefloat8
Derived
If AVAL not missing and BASE not missing then CHG=AVAL-BASE. This is calculated only for post-baseline records.
PCHGPercent Change from Baselinefloat8
Derived
For Post baseline records, if AVAL NOT missing and BASE not missing then set it to ((AVAL-BASE)/BASE)*100
CRIT1Analysis Criterion 1text14Analysis Criterion 1
  • • "Seroconversion"
Derived
Derived as 'Seroconversion' for the post baseline records of ADVA.paramn 1, 2, 3, 4
CRIT1FLCriterion 1 Evaluation Result Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
Derived for post baseline records of ADVA.paramn (1, 2, 3, 4); CRIT1FL='Y' when aval/base>=4; else CRIT1FL='N'
CRIT1FNCriterion 1 Evaluation Result Flag (N)integer8
Assigned

0 when CRIT1FL = 'N'; 1 when CRIT1FL = 'Y'.

DTYPEDerivation Typetext9Derivation Type
  • • "HALF LLOQ" = "HALF LLOQ"
  • • "HALFLLOQ" = "HALFLLOQ"
Derived
Derived as 'HALF LLOQ' for records IS.ISSTRESC='BLQ'
ABLFLBaseline Record Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' for a valid result (AVAL ne .) and last non missing records value before or on the first day of treatment
ISLLOQLower Limit of Quantitationfloat8
Predecessor: IS.ISLLOQ
SAFFLSafety Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SAFFL
SAFFNSafety Population Flag (N)integer8
Predecessor: ADSL.SAFFN
IMMFLImmunogenicity Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.IMMFL
IMMFNImmunogenicity Population Flag (N)integer8
Predecessor: ADSL.IMMFN
EXIMM1Reason for Exclusion Immunogenicity Settext1
Predecessor: ADSL.EXIMM1
PPROTFLPer-Protocol Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.PPROTFL
PPROTFNPer-Protocol Population Flag (N)integer8
Predecessor: ADSL.PPROTFN
EXPPROT1Reason 1 for Exclusion Per-Protocol Settext81Reason 1 for Exclusion Per-Protocol Set
  • • "Subject is not included in the immunogenicity set or had major protocol deviation"
Predecessor: ADSL.EXPPROT1
COHORTCohorttext8Cohort

[7 Terms]

Predecessor: ADSL.COHORT
COHORTNCohort (N)integer8
Predecessor: ADSL.COHORTN
GROUPGrouptext12Group
  • • "B (BNT162b1)"
  • • "C (BNT162b2)"
Predecessor: ADSL.GROUP
GROUPNGroup (N)integer8
Predecessor: ADSL.GROUPN
SRCDOMSource Datatext2ADVASource Data
  • • "IS"
Assigned

Set to "IS" if DTYPE not eq "HALF LLOQ" and paramn not eq 5,6,7,8

SRCVARSource Variabletext8ADVASource Variable
  • • "ISSTRESC"
Assigned

Set to "ISSTRESC" if DTYPE not eq "HALF LLOQ" and paramn not eq 5,6,7,8

SRCSEQSource Sequence Numberinteger8
Assigned

Assigned as IS.ISSEQ if DTYPE not eq "HALF LLOQ" and paramn not eq 5,6,7,8

AGEAgeinteger8
Predecessor: ADSL.AGE
AGEUAge Unitstext5Age Unit
  • • "YEARS" = "Year"
Predecessor: ADSL.AGEU
AGEGR1Pooled Age Group 1text11Age Group 1
  • • "18 - 55 Yrs"
Derived
Derived as '18 - 55 Yrs' If ADSL.AGE greater than or equal to 18 and ADSL.AGE less than or equal to 55
AGEGR1NPooled Age Group 1 (N)integer8
Assigned

1 when AGEGR1 = '18 - 55'.

SEXSextext1Sex
  • • "M" = "Male"
  • • "F" = "Female"
Predecessor: ADSL.SEX
SEXNSex (N)integer8
Predecessor: ADSL.SEXN
TRTEDTDate of Last Exposure to TreatmentintegerDATE9
Predecessor: ADSL.TRTEDT
TRTEDTMDatetime of Last Exposure to TreatmentintegerDATETIME19
Predecessor: ADSL.TRTEDTM
TRTSDTDate of First Exposure to TreatmentintegerDATE9
Predecessor: ADSL.TRTSDT
TRTSDTMDatetime of First Exposure to TreatmentintegerDATETIME19
Predecessor: ADSL.TRTSDTM
ARMDescription of Planned Armtext14Description of Planned Arm

[12 Terms]

Predecessor: ADSL.ARM
ACTARMDescription of Actual Armtext14Description of Planned Arm

[12 Terms]

Predecessor: ADSL.ACTARM
BOIMDTDate of Boost ImmunizationintegerDATE9
Predecessor: ADSL.BOIMDT
BOIMDTMDatetime of Boost ImmunizationintegerDATETIME19
Predecessor: ADSL.BOIMDTM
BOIMTMTime of Boost ImmunizationintegerTIME5
Predecessor: ADSL.BOIMTM
PRIMDTDate of Prime ImmunizationintegerDATE9
Predecessor: ADSL.PRIMDT
PRIMDTMDatetime of Prime ImmunizationintegerDATETIME19
Predecessor: ADSL.PRIMDTM
PRIMTMTime of Prime ImmunizationintegerTIME5
Predecessor: ADSL.PRIMTM

Go to the top of the Define-XML document


Vital Signs Analysis Dataset (ADVS)

ADVS (Vital Signs Analysis Dataset) - BASIC DATA STRUCTURE Location: advs.xpt
VariableWhere ConditionLabel / DescriptionTypeLength or Display FormatControlled Terms or ISO FormatOrigin / Source / Method / Comment
STUDYIDStudy Identifiertext9
Predecessor: ADSL.STUDYID
USUBJIDUnique Subject Identifiertext21
Predecessor: ADSL.USUBJID
SUBJIDSubject Identifier for the Studytext5
Predecessor: ADSL.SUBJID
SUBJIDNSubject Identifier for the Study (N)integer8
Predecessor: ADSL.SUBJIDN
COHORTCohorttext8Cohort

[7 Terms]

Predecessor: ADSL.COHORT
COHORTNCohort (N)integer8
Predecessor: ADSL.COHORTN
GROUPGrouptext12Group
  • • "B (BNT162b1)"
  • • "C (BNT162b2)"
Predecessor: ADSL.GROUP
GROUPNGroup (N)integer8
Predecessor: ADSL.GROUPN
TRTPPlanned Treatmenttext5Planned Treatment

[7 Terms]

Predecessor: ADSL.TRT01P
TRTPNPlanned Treatment (N)integer8
Predecessor: ADSL.TRT01PN
TRTAActual Treatmenttext5Actual Treatment

[7 Terms]

Predecessor: ADSL.TRT01A
TRTANActual Treatment (N)integer8
Predecessor: ADSL.TRT01AN
VSSEQSequence Numberinteger8
Predecessor: VS.VSSEQ
ASEQAnalysis Sequence Numberinteger8
Derived
sort the data by USUBJID,PARAMN,AVISITN,ADTM. Assign the sequential numbers starting with 1 for each subject.
PARAMParametertext32ADVS Parameter

[9 Terms]

Derived
VS.VSTEST || VS.VSORRESU
PARAMCDParameter Codetext6ADVS Parameter Code

[9 Terms]

Derived
VS.VSTESTCD
PARAMNParameter (N)integer8
Derived
1 if paramcd='BMI'; 2 if paramcd = 'DIABP'; 3 if paramcd='HEIGHT' ;4 if paramcd='PULSE'; 5 if paramcd='RESP'; 6 if paramcd='SYSBP'; 7 if paramcd='TEMP'; 8 if paramcd='TEMPR'; 9 if paramcd='WEIGHT'
PARCAT1Parameter Category 1text14Parameter Category 1
  • • "Reactogenicity"
Derived
VS.VSCAT
PARCAT1NParameter Category 1 (N)integer8
Derived
1 if parcat1='Reactogenicity'
PARCAT2Parameter Category 2text8Parameter Category 2
  • • "Systemic"
Derived
VS.VSSCAT
PARCAT2NParameter Category 2 (N)integer8
Derived
1 if parcat2='Systemic'
VSPOSVital Signs Position of Subjecttext6Vital Signs Position of Subject
  • • "SUPINE"
Predecessor: VS.VSPOS
AVALVLMAnalysis Valuefloat8
Derived
VS.VSSTRESN
PARAMCD = "BMI" (Body Mass Index [kg/m2])Body Mass Index [kg/m2]float4
Derived
VS.VSSTRESN
PARAMCD = "DIABP" (Diastolic Blood Pressure [mmHg])Diastolic Blood Pressure [mmHg]integer3
Derived
VS.VSSTRESN
PARAMCD = "HEIGHT" (Height [cm])Height [cm]integer3
Derived
VS.VSSTRESN
PARAMCD = "PULSE" (Pulse Rate [beats/min])Pulse Rate [beats/min]integer3
Derived
VS.VSSTRESN
PARAMCD = "RESP" (Respiratory Rate [breaths/min])Respiratory Rate [breaths/min]integer2
Derived
VS.VSSTRESN
PARAMCD = "SYSBP" (Systolic Blood Pressure [mmHg])Systolic Blood Pressure [mmHg]integer3
Derived
VS.VSSTRESN
PARAMCD = "TEMP" (Temperature [C])Temperature [C]float4
Derived
VS.VSSTRESN
PARAMCD = "TEMPR" (Temperature (Reactogenicity) [C])Temperature (Reactogenicity) [C]float4
Derived
VS.VSSTRESN
PARAMCD = "WEIGHT" (Weight [kg])Weight [kg]float5
Derived
VS.VSSTRESN
AVALCVLMAnalysis Value (C)text5
Derived
VS.VSSTRESC
PARAMCD = "BMI" (Body Mass Index [kg/m2])Body Mass Index [kg/m2]text4
Derived
VS.VSSTRESC
PARAMCD = "DIABP" (Diastolic Blood Pressure [mmHg])Diastolic Blood Pressure [mmHg]text3
Derived
VS.VSSTRESC
PARAMCD = "HEIGHT" (Height [cm])Height [cm]text3
Derived
VS.VSSTRESC
PARAMCD = "PULSE" (Pulse Rate [beats/min])Pulse Rate [beats/min]text3
Derived
VS.VSSTRESC
PARAMCD = "RESP" (Respiratory Rate [breaths/min])Respiratory Rate [breaths/min]text2
Derived
VS.VSSTRESC
PARAMCD = "SYSBP" (Systolic Blood Pressure [mmHg])Systolic Blood Pressure [mmHg]text3
Derived
VS.VSSTRESC
PARAMCD = "TEMP" (Temperature [C])Temperature [C]text4
Derived
VS.VSSTRESC
PARAMCD = "TEMPR" (Temperature (Reactogenicity) [C])Temperature (Reactogenicity) [C]text4
Derived
VS.VSSTRESC
PARAMCD = "WEIGHT" (Weight [kg])Weight [kg]text5
Derived
VS.VSSTRESC
VSCLSIGClinically Significanttext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: SUPPVS.QVAL where QNAM='VSCLSIG'
VSCLSIGNClinically Significant (N)integer8
Derived
1 if VSCLSIG='Y'; 0 if VSCLSIG='N', missing otherwise
ABLFLBaseline Record Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
[Protocol/SAP] Baseline record for each SUBJID/PERIOD/PARAM as defined in the protocol
BASEBaseline Valuefloat8
Derived
ADVS.AVAL, where ADVS.USUBJID=USUBJID and ADVS.APERIOD=APERIOD and ADVS.PARAM=PARAM and ADVS.ABLFL="Y"
BASECBaseline Value (C)text5
Derived
ADVS.AVALC, where ADVS.USUBJID=USUBJID and ADVS.APERIOD=APERIOD and ADVS.PARAM=PARAM and ADVS.ABLFL="Y"
CHGChange from Baselinefloat8
Derived
CHG = AVAL - BASE
PCHGPercent Change from Baselinefloat8
Derived
PCHG = ((AVAL - BASE)/BASE)*100
ANRINDAnalysis Reference Range Indicatortext8Analysis Reference Range Indicator
  • • "Abnormal"
  • • "Normal"
Derived
If non-missing AVAL is greater than ANRHI or less than ANRLO then ANRIND=Abnormal. If ANRLO is missing then only ANRHI is used to determine abnormality. If non-missing AVAL is within ANRLO and ANRHI then ANRIND=Normal.
BNRINDBaseline Reference Range Indicatortext8Baseline Reference Range Indicator
  • • "Abnormal"
  • • "Normal"
Derived
If non-missing BASE is greater than ANRHI or less than ANRLO then ANRIND=Abnormal. If ANRLO is missing then only ANRHI is used to determine abnormality. If non-missing BASE is within ANRLO and ANRHI then ANRIND=Normal.
ANRLOAnalysis Normal Range Lower Limitfloat8
Derived
50 if paramn=4 ; 8 if paramn=5 ; 90 if paramn=6 ; 35.5 if paramn=7
ANRHIAnalysis Normal Range Upper Limitfloat8
Derived
90 if paramn=2; 100 if paramn=4; 20 if paramn=5 ; 140 if paramn=6 ; 37.5 if paramn=7
NABCSNormal/Abnormal/CStext17Normal/Abnormal/CS
  • • "Missing"
  • • "CS abnormal"
  • • "Abnormal (not CS)"
  • • "Normal"
  • • "Normal (not CS)"
Derived
If abnormality is clinically significant then NABCS='CS Abnormal' ; If abnormality is not clinically significant then NABCS='Abnormal (not CS)' ; if no abnormality then NABCS=Normal ; if there is abnormality and clinically significance information is not present then NABCS=Missing.
NABCSNNormal/Abnormal/CS (N)integer8
Derived
1 if NABCS = 'Missing'; 2 if NABCS = 'CS Abnormal'; 3 if NABCS = 'Abnormal (not CS); 4 if NABCS = 'Normal’
ANL01FLAnalysis Flag 01text1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
[Protocol/SAP] "Y" for the selected record within each SUBJID/PERIOD/PARAM/AVISIT as determined by the protocol
ANL02FLAnalysis Flag 02text1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
"Y" when TRTSDT/TRTSTM < ADTM < TRTEDT/TRTETM
UNSVFLUnscheduled Visit Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
Y' if index(AVISIT,'Unscheduled') > 0
POBLFLPost-Baseline Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
Y' if ADTM ne . and ADTM>TRTSDTM. if ADTM=. and ADT>TRTSDT then POBLFL="Y";
VSSTATCompletion Statustext8Completion Status
  • • "NOT DONE"
Predecessor: VS.VSSTAT
VSREASNDReason Test Not Donetext200
Predecessor: VS.VSREASND
VSLOCLocation of Vital Signs Measurementtext11Location of Vital Signs Measurement
  • • "ARM" = "Arm"
  • • "ORAL CAVITY" = "Oral Cavity"
Predecessor: VS.VSLOC
VSLATLateralitytext5Laterality
  • • "LEFT" = "Left"
  • • "RIGHT" = "Right"
Predecessor: VS.VSLAT
VSDTCDate/Time of MeasurementspartialDatetimeISO 8601
Predecessor: VS.VSDTC
ADTAnalysis DatefloatDATE9
Derived
ADT = date part of VS.VSDTC
ATMAnalysis TimefloatTIME5
Derived
ATM = time part of VS.VSDTC
ADTMAnalysis DatetimefloatDATETIME19
Derived
numeric value of VS.VSDTC
VSDYStudy Day of Vital Signsinteger8
Predecessor: VS.VSDY
ADYAnalysis Relative Dayinteger8
Derived
Analysis date relative to treatment start: ADT - TRTSDT + 1, when ADT is on or after TRTSDT; ADT - TRTSDT, when ADT is before TRTSDT.
VSTPTPlanned Time Point Nametext7Planned Time Point Name
  • • "1 hour"
  • • "3 hours"
  • • "6 hours"
  • • "Predose"
Predecessor: VS.VSTPT
VSTPTNUMPlanned Time Point Name (N)float8
Predecessor: VS.VSTPTNUM
ATPTAnalysis Timepointtext7ADVS Analysis Timepoint
  • • "1 hour"
  • • "3 hours"
  • • "6 hours"
  • • "Predose"
Derived
VS.VSTPT
ATPTNAnalysis Timepoint (N)float8
Derived
0 if VS.VSTPT= "predose" ; 1 if VS.VSTPT= "1 hour" ; 3 if VS.VSTPT= "3 hours" ; 6 if VS.VSTPT= "6 hours".
VSTPTREFTime Point Referencetext17Time Point Reference
  • • "BOOST VACCINATION"
  • • "PRIME VACCINATION"
Predecessor: VS.VSTPTREF
ATPTREFAnalysis Timepoint Referencetext12Analysis Timepoint Reference
  • • "Boost Dosing"
  • • "Prime Dosing"
Derived
VS.VSTPTREF
VSRFTDTCDate/Time of Reference Time PointpartialDatetimeISO 8601
Predecessor: VS.VSRFTDTC
AVISITAnalysis Visittext26ADVS Analysis Visit

[14 Terms]

Derived
If VS.VISIT=Visit 0 (Day -30 to 0) then AVISIT= Day -30 to 0 ; If VS.VISIT=Visit 1 (Day 1) then AVISIT= Day 1 ; If VS.VISIT=Visit 2 (Day 2) then AVISIT= Day 2 ; If VS.VISIT=Visit 3 (Day 8) then AVISIT= Day 8 ; If VS.VISIT=Visit 4 / Dosing (Day 22) then AVISIT= Day 22 ; If VS.VISIT=Visit 5 (Day 29) then AVISIT= Day 29 ; If VS.VISIT=Visit 6 (Day 43) then AVISIT= Day 43 ; If VS.VISIT=Visit 7 / EoT Visit (Day 50) then AVISIT= Day 50 ; If VS.VISIT=Visit 8 / FU Visit (Day 85) then AVISIT= Day 85 ; If VS.VISIT=Visit 9 / FU Visit (Day 184) then AVISIT= Day 184 ; If VS.VISIT=Unschduled 1.01 then AVISIT=Unschduled 1 Day -30 to 0 ; If VS.VISIT=Unschduled 2.01 then AVISIT=Unschduled 1 Day 1 ; If VS.VISIT=Unschduled 3.01 then AVISIT=Unschduled 1 Day 2 ; If VS.VISIT=Unschduled 5.01 then AVISIT=Unschduled 1 Day 8 ; If VS.VISIT=Unschduled 6.01 then AVISIT=Unschduled 1 Day 22 ; If VS.VISIT=Unschduled 7.01 then AVISIT=Unschduled 1 Day 29 ; If VS.VISIT=Unschduled 8.01 then AVISIT=Unschduled 1 Day 43 ; If VS.VISIT=Unschduled 9.01 then AVISIT=Unschduled 1 Day 50 ;
AVISITNAnalysis Visit (N)float8
Derived
If VS.VISIT=Visit 0 (Day -30 to 0) then AVISITN= 1; If VS.VISIT=Visit 1 (Day 1) then AVISITN= 2; If VS.VISIT=Visit 2 (Day 2) then AVISITN= 3; If VS.VISIT=Visit 3 (Day 8) then AVISITN= 5; If VS.VISIT=Visit 4 / Dosing (Day 22) then AVISITN= 6; If VS.VISIT=Visit 5 (Day 29) then AVISITN= 7; If VS.VISIT=Visit 6 (Day 43) then AVISITN= 8; If VS.VISIT=Visit 7 / EoT Visit (Day 50) then AVISITN= 9; If VS.VISIT=Visit 8 / FU Visit (Day 85) then AVISITN=10; If VS.VISIT=Visit 9 / FU Visit (Day 184) then AVISITN=11; If VS.VISIT=Unschduled 1.01 then AVISITN= 1.01 ; If VS.VISIT=Unschduled 2.01 then AVISITN=2.01; If VS.VISIT=Unschduled 3.01 then AVISITN=3.01; If VS.VISIT=Unschduled 5.01 then AVISITN= 5.01 ; If VS.VISIT=Unschduled 6.01 then AVISITN= 6.01 ; If VS.VISIT=Unschduled 7.01 then AVISITN= 7.01 ; If VS.VISIT=Unschduled 8.01 then AVISITN= 8.01 ; If VS.VISIT=Unschduled 9.01 then AVISITN= 9.01 ;
VISITVisit Nametext28Visit Name

[14 Terms]

Predecessor: VS.VISIT
VISITNUMVisit Numberfloat8
Predecessor: VS.VISITNUM
EPOCHEpochtext9Epoch
  • • "BASELINE" = "Baseline Epoch"
  • • "FOLLOW-UP" = "Clinical Study Follow-up"
  • • "SCREENING" = "Trial Screening"
  • • "TREATMENT" = "Treatment Epoch"
Predecessor: VS.EPOCH
AGEAgeinteger8
Predecessor: ADSL.AGE
AGEUAge Unitstext5Age Unit
  • • "YEARS" = "Year"
Predecessor: ADSL.AGEU
SEXSextext1Sex
  • • "M" = "Male"
  • • "F" = "Female"
Predecessor: ADSL.SEX
SEXNSex (N)integer8
Predecessor: ADSL.SEXN
RACERacetext25Race

[9 Terms]

Predecessor: ADSL.RACE
RACENRace (N)integer8
Predecessor: ADSL.RACEN
SCRFLScreened Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SCRFL
SCRFNScreened Population Flag (N)integer8
Predecessor: ADSL.SCRFN
SAFFLSafety Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SAFFL
SAFFNSafety Population Flag (N)integer8
Predecessor: ADSL.SAFFN
SAFBFLSafety Boost Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SAFBFL
SAFBFNSafety Boost Population Flag (N)integer8
Predecessor: ADSL.SAFBFN
IMMFLImmunogenicity Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.IMMFL
IMMFNImmunogenicity Population Flag (N)integer8
Predecessor: ADSL.IMMFN
PPROTFLPer-Protocol Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.PPROTFL
PPROTFNPer-Protocol Population Flag (N)integer8
Predecessor: ADSL.PPROTFN
EXPPROT1Reason 1 for Exclusion Per-Protocol Settext81Reason 1 for Exclusion Per-Protocol Set
  • • "Subject is not included in the immunogenicity set or had major protocol deviation"
Predecessor: ADSL.EXPPROT1
CP7FLPrime + 7 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CP7FL
CP7FNPrime + 7 Days Completers Set (N)integer8
Predecessor: ADSL.CP7FN
CPBP28FLPrime to Boost or Prime +28 D. Comp. Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CPBP28FL
CPBP28FNPri. to Bo. or Pri. +28 D. Comp. Set (N)integer8
Predecessor: ADSL.CPBP28FN
CB7FLBoost + 7 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CB7FL
CB7FNBoost + 7 Days Completers Set (N)integer8
Predecessor: ADSL.CB7FN
CB28FLBoost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CB28FL
CB28FNBoost + 28 Days Completers Set (N)integer8
Predecessor: ADSL.CB28FN
CPB28FLPrime or Boost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CPB28FL
CPB28FNPrime or Boost + 28 Days Comp. Set (N)integer8
Predecessor: ADSL.CPB28FN
COMPLFLCompleters Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.COMPLFL
COMPLFNCompleters Population Flag (N)integer8
Predecessor: ADSL.COMPLFN
TRTSDTDate of First Exposure to TreatmentfloatDATE9
Predecessor: ADSL.TRTSDT
TRTSTMTime of First Exposure to TreatmentfloatTIME5
Predecessor: ADSL.TRTSTM
TRTSDTMDatetime of First Exposure to TreatmentfloatDATETIME19
Predecessor: ADSL.TRTSDTM
TRTEDTDate of Last Exposure to TreatmentfloatDATE9
Predecessor: ADSL.TRTEDT
TRTETMTime of Last Exposure to TreatmentfloatTIME5
Predecessor: ADSL.TRTETM
TRTEDTMDatetime of Last Exposure to TreatmentintegerDATETIME19
Predecessor: ADSL.TRTEDTM
ALLOCDTDate of AllocationintegerDATE9
Predecessor: ADSL.ALLOCDT
ALLOCTMTime of AllocationintegerTIME5
Predecessor: ADSL.ALLOCTM
ALLOCDTMDatetime of AllocationintegerDATETIME19
Predecessor: ADSL.ALLOCDTM
SRCDOMSource Datatext2ADVSSource Data
  • • "VS"
Derived
VS.DOMAIN
SRCVARSource Variabletext7ADVSSource Variable
  • • "VSORRES"
Assigned

"VSORRES"

SRCSEQSource Sequence Numberinteger8
Derived
VS.VSSEQ

Go to the top of the Define-XML document


Adverse Events Analysis Dataset (ADAE)

ADAE (Adverse Events Analysis Dataset) - OCCURRENCE DATA STRUCTURE Location: adae.xpt
VariableLabel / DescriptionTypeLength or Display FormatControlled Terms or ISO FormatOrigin / Source / Method / Comment
STUDYIDStudy Identifiertext9
Predecessor: ADSL.STUDYID
USUBJIDUnique Subject Identifiertext21
Predecessor: ADSL.USUBJID
SUBJIDSubject Identifier for the Studytext5
Predecessor: ADSL.SUBJID
SUBJIDNSubject Identifier for the Study (N)integer8
Predecessor: ADSL.SUBJIDN
COHORTCohorttext8Cohort

[7 Terms]

Predecessor: ADSL.COHORT
COHORTNCohort (N)integer8
Predecessor: ADSL.COHORTN
GROUPGrouptext12Group
  • • "B (BNT162b1)"
  • • "C (BNT162b2)"
Predecessor: ADSL.GROUP
GROUPNGroup (N)integer8
Predecessor: ADSL.GROUPN
TRTPPlanned Treatmenttext5Planned Treatment

[7 Terms]

Predecessor: ADSL.TRT01P
TRTPNPlanned Treatment (N)integer8
Predecessor: ADSL.TRT01PN
TRTAActual Treatmenttext5Actual Treatment

[7 Terms]

Predecessor: ADSL.TRT01A
TRTANActual Treatment (N)integer8
Predecessor: ADSL.TRT01AN
AESEQSequence Numberinteger8
Predecessor: AE.AESEQ
AEGRPIDGroup IDtext1
Predecessor: AE.AEGRPID
AESPIDSponsor-Defined Identifiertext2
Predecessor: AE.AESPID
AETERMReported Term for the Adverse Eventtext145
Predecessor: AE.AETERM
AEMODIFYModified Reported Termtext32
Predecessor: AE.AEMODIFY
AELLTLowest Level Termtext32Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AELLT
AELLTCDLowest Level Term Codeinteger8Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AELLTCD
AEDECODDictionary-Derived Termtext35Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AEDECOD
AEPTCDPreferred Term Codeinteger8Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AEPTCD
AEHLTHigh Level Termtext64Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AEHLT
AEHLTCDHigh Level Term Codeinteger8Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AEHLTCD
AEHLGTHigh Level Group Termtext58Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AEHLGT
AEHLGTCDHigh Level Group Term Codeinteger8Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AEHLGTCD
AECATCategory for Adverse Eventtext7Category for Adverse Event
  • • "GENERAL"
  • • "SPECIAL INTEREST"
Predecessor: AE.AECAT
AEBODSYSBody System or Organ Classtext52Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AEBODSYS
AEBDSYCDBody System or Organ Class Codeinteger8Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AEBDSYCD
AESOCPrimary System Organ Classtext52Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AESOC
AESOCCDPrimary System Organ Class Codeinteger8Medical Dictionary for Regulatory Activities

MedDRA 23.0

Predecessor: AE.AESOCCD
AESEVSeverity/Intensitytext8Severity/Intensity Scale for AE
  • • "MILD" = "Mild Adverse Event"
  • • "MODERATE" = "Moderate Adverse Event"
  • • "SEVERE" = "Severe Adverse Event"
Predecessor: AE.AESEV
AETOXGRStandard Toxicity Gradetext8Standard Toxicity Grade in Adverse Events
  • • "MILD"
  • • "MODERATE"
  • • "SEVERE"
  • • "POTENTIALLY LIFE THREATENING"
Predecessor: AE.AETOXGR
ASEVAnalysis Severity/Intensitytext8Analysis Severity/Intensity of Adverse Events
  • • "Mild"
  • • "Moderate"
  • • "Severe"
  • • "Potentially Life Threatening"
Derived
Propcase(AE.AESEV) when AE.AESEV not missing ; else Propcase(AE.AETOXGR) when AE.AETOXGR is not missing. ASEV= ' ' when both AE.AESEV and AE.AETOXGR missing.
ASEVNAnalysis Severity/Intensity (N)integer8
Assigned

1 when ASEV = 'Mild', 2 when ASEV = 'Moderate', 3 when ASEV = 'Severe', 4 when ASEV = 'Potentially life threatening'.

AESERSerious Eventtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: AE.AESER
AESERNSerious Event (N)integer8
Assigned

0 when AESER = 'N'; 1 when AESER = 'Y'.

AEACNAction Taken with Study Treatmenttext16Action Taken with Study Treatment

[6 Terms]

Predecessor: AE.AEACN
AACNAnalysis Action Taken with Study Trtmnttext16Analysis Action Taken with Study Trtmnt

[6 Terms]

Derived
Propcase(AE.AEACN) when AE.AEACN not missing.
AACNNAnalysis Action Taken with Trtmnt (N)integer8
Assigned

1 when AEACN = 'DOSE NOT CHANGED'; 2 when AEACN = 'DOSE REDUCED'; 3 when AEACN = 'DRUG INTERRUPTED'; 4 when AEACN = 'DRUG WITHDRAWN'; 5 when AEACN = 'NOT APPLICABLE'; 6 when AEACN = 'UNKNOWN'.

AERELCausalitytext11Causality
  • • "NOT RELATED"
  • • "RELATED"
Predecessor: AE.AEREL
ARELAnalysis Causalitytext11Analysis Causality
  • • "Not Related"
  • • "Related"
Derived
Propcase (AE.AEREL) when AE.AEREL not missing.
ARELNAnalysis Causality (N)integer8
Assigned

1 when AREL = 'Not Related'; 4 when AREL = 'Related'.

AEOUTOutcome of Adverse Eventtext20Outcome of Event in AE

[6 Terms]

Predecessor: AE.AEOUT
AOUTAnalysis Outcome of Adverse Eventtext20Analysis Outcome of Adverse Event

[6 Terms]

Derived
Propcase(AE.AEOUT) when AE.AEOUT not missing.
AOUTNAnalysis Outcome of Adverse Event (N)integer8
Assigned

1 when AEOUT = 'NOT RECOVERED/NOT RESOLVED'; 2 when AEOUT = 'RECOVERED/RESOLVED'; 3 when AEOUT = 'RECOVERED/RESOLVED WITH SEQUELAE'; 4 when AEOUT = 'RECOVERING/RESOLVING'; 5 when AEOUT = 'FATAL'; 6 when AEOUT = 'UNKNOWN'.

AESCONGCongenital Anomaly or Birth Defecttext1
Predecessor: AE.AESCONG
AESDISABPersist or Signif Disability/Incapacitytext1
Predecessor: AE.AESDISAB
AESDTHResults in Deathtext1
Predecessor: AE.AESDTH
AESHOSPRequires or Prolongs Hospitalizationtext1
Predecessor: AE.AESHOSP
AESLIFEIs Life Threateningtext1
Predecessor: AE.AESLIFE
AESMIEOther Medically Important Serious Eventtext1
Predecessor: AE.AESMIE
AECONTRTConcomitant or Additional Trtmnt Giventext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: AE.AECONTRT
AETRTEMTreatment Emergent Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: SUPPAE.QVAL where QNAM='AETRTEM'
AEDLTDose limiting Toxicitytext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: SUPPAE.QVAL where QNAM='AEDLT'
AEEPRELIEpi/Pandemic Related Indicatortext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: SUPPAE.QVAL where QNAM='AEEPRELI'
AEEMRELTreatment emergent related AEtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
If TRTEMFL='Y' and upcase(arel)='RELATED' then AEEMREL='Y'; else AEEMREL='N'.
AEEMSTreatment emergent severe AEtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
If TRTEMFL='Y' and asevn in (3,4) then AEEMS='Y'; else AEEMS='N'.
AEEMSRELTreatment emergent severe related AEtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
If TRTEMFL='Y' and asevn in (3,4) and upcase(arel)='RELATED' then AEEMSREL='Y'; else AEEMSREL='N'.
AEEMSERSerious treatment emergent AEtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
If TRTEMFL='Y' and aeser='Y' then AEEMSER='Y'; else AEEMSER='N'.
AEEMSERRSerious treatment emergent related AEtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Derived
If TRTEMFL='Y' and aeser='Y' and upcase(arel)='RELATED' then AEEMSERR='Y'; else AEEMSERR='N'.
PTDIAFLPreferred Term based on diary entrytext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
if (AE.AEDECOD in ('Abdominal pain', ' Abdominal pain lower', ' Arthralgia', 'Chills', 'Decreased appetite', 'Diarrhoea', 'Discomfort', 'Fatigue', ' Feeling hot', 'Gastrointestinal disorder', 'Headache', 'Hot flush', 'Influenza like illness', 'Injection site discomfort', 'Injection site erythema', 'Injection site hypersensitivity', 'Injection site pain', 'Injection site paraesthesia', 'Injection site reaction', 'Injection site swelling', 'Malaise', 'Muscle tightness', 'Myalgia', 'Nausea', ' Pyrexia' , 'Vomiting', 'Axillary pain', 'Body temperature increased', 'C-reactive protein increased', 'Dizziness', 'Head discomfort', 'Injection site discolouration', 'Injection site hypoaesthesia', 'Neck pain' ) and ((AENDT - ASTDT)+ 1)<=7) then PTDIAFL='Y'.
AESTDTCStart Date/Time of Adverse EventpartialDatetimeISO 8601
Predecessor: AE.AESTDTC
ASTDTAnalysis Start DateintegerDATE9
Derived
Date part of ASTDTM.
ASTTMAnalysis Start TimeintegerTIME5
Derived
Time part of ASTDTM.
ASTDTMAnalysis Start Date/TimeintegerDATETIME19
Derived
AE.AESTDTC as SAS datetime.
AEENDTCEnd Date/Time of Adverse EventpartialDatetimeISO 8601
Predecessor: AE.AEENDTC
AENDTAnalysis End DateintegerDATE9
Derived
Date part of AENDTM.
AENTMAnalysis End TimeintegerTIME5
Derived
Time part of AENDTM.
AENDTMAnalysis End Date/TimeintegerDATETIME19
Derived
AE.AEENDTC as SAS datetime.
AESTDYStudy Day of Start of Adverse Eventinteger8
Predecessor: AE.AESTDY
ASTDYAnalysis Start Relative Dayinteger8
Derived
Analysis start date relative to treatment start: ASTDT - TRTSDT + 1, when ASTDT is on or after TRTSDT; ASTDT - TRTSDT, when ASTDT is before TRTSDT.
AEENDYStudy Day of End of Adverse Eventinteger8
Predecessor: AE.AEENDY
AENDYAnalysis End Relative Dayinteger8
Derived
if AENDT >=PRIMDT then AENDY=(AENDT - PRIMDT)+1; else if AENDT <PRIMDT then AENDY=AENDT - PRIMDT.
ADURNAnalysis Duration (N)float12
Derived
When AENDTM and ASTDTM not missing then ADURN=(AENDTM-ASTDTM)/(60*60).
ADURUAnalysis Duration Unitstext5Analysis Duration Units
  • • "DAYS" = "Day"
  • • "hours" = "hours"
Derived
When ADURN not missing ADURU='hours'.
LSTDDDays since last doseinteger8
Derived
When BOIMDT not missing: if ASTDT < BOIMDT then LSTDD=ASTDT-PRIMDT +1; else if ASTDT >= BOIMDT then LSTDD=ASTDT-BOIMDT+1; When BOIMDT missing: if ASTDT >= PRIMDT then LSTDD=ASTDT-PRIMDT +1.
AEENRTPTEnd Relative to Reference Time Pointtext1
Predecessor: AE.AEENRTPT
AEENTPTEnd Reference Time Pointtext1
Predecessor: AE.AEENTPT
TRTEMFLTreatment Emergent Analysis Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
*if not missing Adverse start date/time and AE start date/time >= first immunization date/time and AE start date/time <= (last immunization date/time + 28 days), then TRTEMFL='Y'; *if missing Adverse start time and AE start date >= first immunization date and AE start date <= (last immunization date + 28 days), then TRTEMFL='Y'; *if not missing Adverse start date/time and AE start date/time > (last immunization date/time + 28 days) but assessed as related to IMP by investigator then TRTEMFL='Y'; *if missing Adverse start time and AE start date > (last immunization date + 28 days) but assessed as related to IMP by investigator then TRTEMFL='Y'; *if AE present before immunization and worsened after first immunization, then TRTEMFL='Y'; *if missing AE date or time and AE cannot be determined TEAE from the above set rules, then TRTEMFL='Y';
TMINT1FLTime Interval 1 Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
AE is Treatment-Emergent: if ASTDTM >= PRIMDTM and (PRIMDTM <= ASTDTM <= (PRIMDTM + 7 days)) then TMINT1FL='Y'; if ASTDTM < PRIMDTM and Adverse Event worsened after Prime immunization then TMINT1FL='Y'; if AE time missing and Date not missing and (PRIMDT <= ASTDT <= (PRIMDT + 7)) then TMINT1FL='Y'; if missing AE Date/or time and AE cannot be determined with above set rules, then TMINT1FL='Y';
TMINT2FLTime Interval 2 Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
AE is Treatment-Emergent: Identify the minimum of duration - ((Prime to Boost) or (28 days from Prime) - whatever comes first. When Boost is missing, duration is 28 days from Prime. if duration < 28 then: (Prime to Boost contribution) if not missing AE start date/time and PRIMDTM <= ASTDTM <= BOIMDTM then TMINT2FL='Y'; if not missing AE start date/time and ASTDTM < PRIMDTM and Adverse Event worsened after Prime immunization then TMINT2FL='Y'; if missing AE start time and PRIMDT <= ASTDT <= BOIMDT then TMINT2FL='Y'; if missing AE start time and ASTDT < PRIMDT and Adverse Event worsened after Prime immunization then TMINT2FL='Y'; if duration = 28 then: (28 days from prime contribution) if not missing AE start date/time and PRIMDTM <= ASTDTM <= (PRIMDTM + 28 days) then TMINT2FL='Y'; if not missing AE start date/time and ASTDTM < PRIMDTM and Adverse Event worsened after Prime immunization then TMINT2FL='Y'; if missing AE start time and PRIMDT <= ASTDT <= (PRIMDT + 28) then TMINT2FL='Y'; if missing AE start time and ASTDT < PRIMDT and Adverse Event worsened after Prime immunization then TMINT2FL='Y'; if missing AE Date/or time and AE cannot be determined with above set rules, then TMINT2FL='Y';
TMINT3FLTime Interval 3 Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
AE is Treatment-Emergent: if ASTDTM >= BOIMDTM and (BOIMDTM <= ASTDTM <= (BOIMDTM + 7 days)) then TMINT3FL='Y'; if ASTDTM < BOIMDTM and Adverse Event worsened after boost immunization then TMINT3FL='Y'; if AE time missing and Date not missing and Boost immunization date not missing and (BOIMDT <= ASTDT <= (BOIMDT + 7)) then TMINT3FL='Y'; if missing AE Date/or time and AE cannot be determined with above set rules, then TMINT3FL='Y';
TMINT4FLTime Interval 4 Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
AE is Treatment-Emergent: if ASTDTM >= BOIMDTM and (BOIMDTM <= ASTDTM <= (BOIMDTM + 28 days)) then TMINT4FL='Y'; if ASTDTM < BOIMDTM and Adverse Event worsened after boost immunization then TMINT4FL='Y'; if AE time missing and Date not missing and Boost immunization date not missing and (BOIMDT <= ASTDT <= (BOIMDT + 28)) then TMINT4FL='Y'; if missing AE Date/or time and AE cannot be determined with above set rules, then TMINT4FL='Y';
TMINT5FLTime Interval 5 Flagtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
AE is Treatment-Emergent: if not missing AE Date/time, Prime/Boost immunization date/time and ASTDTM >= PRIMDTM and (PRIMDTM <= ASTDTM <= (BOIMDTM + 28 days)) then TMINT5FL='Y'; if not missing AE Date/time, Prime/Boost immunization date/time and ASTDTM < PRIMDTM and Adverse Event worsened on/after prime immunization and before/on (boost immunizaqtion + 28 days) then TMINT5FL='Y'; if not missing AE and Prime immunization date/time and boost date/time missing and ASTDTM >= PRIMDTM and (PRIMDTM <= ASTDTM <= (PRIMDTM + 28 days)) then TMINT5FL='Y'; if missing AE time and AE date available and ASTDT >= PRIMDT and (PRIMDT <= ASTDT <= (BOIMDT + 28)) then TMINT5FL='Y'; if missing AE time and AE date available and boost immunization missing and ASTDT >= PRIMDT and (PRIMDT <= ASTDT <= (PRIMDT + 28)) then TMINT5FL='Y'; if missing AE Date/or time and AE cannot be determined with above set rules, then TMINT5FL='Y';
EPOCHEpochtext9Epoch
  • • "BASELINE" = "Baseline Epoch"
  • • "FOLLOW-UP" = "Clinical Study Follow-up"
  • • "SCREENING" = "Trial Screening"
  • • "TREATMENT" = "Treatment Epoch"
Predecessor: AE.EPOCH
AGEAgeinteger8
Predecessor: ADSL.AGE
AGEUAge Unitstext5Age Unit
  • • "YEARS" = "Year"
Predecessor: ADSL.AGEU
SEXSextext1Sex
  • • "M" = "Male"
  • • "F" = "Female"
Predecessor: ADSL.SEX
SEXNSex (N)integer8
Predecessor: ADSL.SEXN
RACERacetext25Race

[9 Terms]

Predecessor: ADSL.RACE
RACENRace (N)integer8
Predecessor: ADSL.RACEN
SCRFLScreened Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SCRFL
SCRFNScreened Population Flag (N)integer8
Predecessor: ADSL.SCRFN
SAFFLSafety Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SAFFL
SAFFNSafety Population Flag (N)integer8
Predecessor: ADSL.SAFFN
SAFBFLSafety Boost Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SAFBFL
SAFBFNSafety Boost Population Flag (N)integer8
Predecessor: ADSL.SAFBFN
IMMFLImmunogenicity Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.IMMFL
IMMFNImmunogenicity Population Flag (N)integer8
Predecessor: ADSL.IMMFN
PPROTFLPer-Protocol Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.PPROTFL
PPROTFNPer-Protocol Population Flag (N)integer8
Predecessor: ADSL.PPROTFN
CP7FLPrime + 7 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CP7FL
CP7FNPrime + 7 Days Completers Set (N)integer8
Predecessor: ADSL.CP7FN
CPBP28FLPrime to Boost or Prime +28 D. Comp. Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CPBP28FL
CPBP28FNPri. to Bo. or Pri. +28 D. Comp. Set (N)integer8
Predecessor: ADSL.CPBP28FN
CB7FLBoost + 7 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CB7FL
CB7FNBoost + 7 Days Completers Set (N)integer8
Predecessor: ADSL.CB7FN
CB28FLBoost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CB28FL
CB28FNBoost + 28 Days Completers Set (N)integer8
Predecessor: ADSL.CB28FN
CPB28FLPrime or Boost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CPB28FL
CPB28FNPrime or Boost + 28 Days Comp. Set (N)integer8
Predecessor: ADSL.CPB28FN
COMPLFLCompleters Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.COMPLFL
COMPLFNCompleters Population Flag (N)integer8
Predecessor: ADSL.COMPLFN
TRTSDTDate of First Exposure to TreatmentintegerDATE9
Predecessor: ADSL.TRTSDT
TRTSTMTime of First Exposure to TreatmentintegerTIME5
Predecessor: ADSL.TRTSTM
TRTSDTMDatetime of First Exposure to TreatmentintegerDATETIME19
Predecessor: ADSL.TRTSDTM
TRTEDTDate of Last Exposure to TreatmentintegerDATE9
Predecessor: ADSL.TRTEDT
TRTETMTime of Last Exposure to TreatmentintegerTIME5
Predecessor: ADSL.TRTETM
TRTEDTMDatetime of Last Exposure to TreatmentintegerDATETIME19
Predecessor: ADSL.TRTEDTM
PRIMDTDate of Prime ImmunizationintegerDATE9
Predecessor: ADSL.PRIMDT
PRIMTMTime of Prime ImmunizationintegerTIME5
Predecessor: ADSL.PRIMTM
PRIMDTMDatetime of Prime ImmunizationintegerDATETIME19
Predecessor: ADSL.PRIMDTM
BOIMDTDate of Boost ImmunizationintegerDATE9
Predecessor: ADSL.BOIMDT
BOIMTMTime of Boost ImmunizationintegerTIME5
Predecessor: ADSL.BOIMTM
BOIMDTMDatetime of Boost ImmunizationintegerDATETIME19
Predecessor: ADSL.BOIMDTM
ALLOCDTDate of AllocationintegerDATE9
Predecessor: ADSL.ALLOCDT
ALLOCTMTime of AllocationintegerTIME5
Predecessor: ADSL.ALLOCTM
ALLOCDTMDatetime of AllocationintegerDATETIME19
Predecessor: ADSL.ALLOCDTM

Go to the top of the Define-XML document


Reactogenicity Analysis Dataset (ADCEVD)

ADCEVD (Reactogenicity Analysis Dataset) - OCCURRENCE DATA STRUCTURE Location: adcevd.xpt
VariableLabel / DescriptionTypeLength or Display FormatControlled Terms or ISO FormatOrigin / Source / Method / Comment
STUDYIDStudy Identifiertext9
Predecessor: ADSL.STUDYID
USUBJIDUnique Subject Identifiertext21
Predecessor: ADSL.USUBJID
SUBJIDSubject Identifier for the Studytext5
Predecessor: ADSL.SUBJID
SUBJIDNSubject Identifier for the Study (N)integer8
Predecessor: ADSL.SUBJIDN
COHORTCohorttext8Cohort

[7 Terms]

Predecessor: ADSL.COHORT
COHORTNCohort (N)integer8
Predecessor: ADSL.COHORTN
GROUPGrouptext12Group
  • • "B (BNT162b1)"
  • • "C (BNT162b2)"
Predecessor: ADSL.GROUP
GROUPNGroup (N)integer8
Predecessor: ADSL.GROUPN
TRTPPlanned Treatmenttext5Planned Treatment

[7 Terms]

Predecessor: ADSL.TRT01P
TRTPNPlanned Treatment (N)integer8
Predecessor: ADSL.TRT01PN
TRTAActual Treatmenttext5Actual Treatment

[7 Terms]

Predecessor: ADSL.TRT01A
TRTANActual Treatment (N)integer8
Predecessor: ADSL.TRT01AN
CESEQSequence Numberinteger8
Predecessor: CE.CESEQ
CEGRPIDGroup IDtext37Group ID in ADCEVD
  • • "BOOST VACCINATION-ADMINISTRATION SITE"
  • • "BOOST VACCINATION-SYSTEMIC"
  • • "PRIME VACCINATION-ADMINISTRATION SITE"
  • • "PRIME VACCINATION-SYSTEMIC"
Predecessor: CE.CEGRPID
CETERMReported Term for the Clinical Eventtext45Reported Term for the Clinical Event in ADCEVD

[15 Terms]

Predecessor: CE.CETERM
CEDECODDictionary-Derived Termtext23
Predecessor: CE.CEDECOD
CEBODSYSBody System or Organ Classtext52
Predecessor: CE.CEBODSYS
CEBDSYCDBody System or Organ Class Codeinteger8
Predecessor: CE.CEBDSYCD
CELLTLowest Level Termtext25
Predecessor: CE.CELLT
CELLTCDLowest Level Term Codeinteger8
Predecessor: CE.CELLTCD
CEPTCDPreferred Term Codeinteger8
Predecessor: CE.CEPTCD
CECATCategory for Clinical Eventtext14Category for Clinical Event in ADCEVD
  • • "REACTOGENICITY"
Predecessor: CE.CECAT
CESCATSubcategory for Clinical Eventtext19Subcategory for Clinical Event in ADCEVD
  • • "ADMINISTRATION SITE"
  • • "SYSTEMIC"
Predecessor: CE.CESCAT
ACAT1Analysis Category 1text8Analysis Category 1 in ADCEVD
  • • "local"
  • • "systemic"
Derived
'local' when CESCAT = 'ADMINISTRATION SITE'; 'systemic' when CESCAT = 'SYSTEMIC'.
CESTDTCStart Date/Time of Clinical EventdateISO 8601
Predecessor: CE.CESTDTC
ASTDTAnalysis Start DateintegerDATE9
Derived
Date part of CESTDTC as SAS date.
CEENDTCEnd Date/Time of Clinical EventdateISO 8601
Predecessor: CE.CEENDTC
AENDTAnalysis End DateintegerDATE9
Derived
Date part of CEENDTC as SAS date.
ASTDYAnalysis Start Relative Dayinteger8
Predecessor: CESTDY
CESTDYStudy Day of Start of Observationinteger8
Predecessor: CE.CESTDY
AENDYAnalysis End Relative Dayinteger8
Predecessor: CEENDY
CEENDYStudy Day of End of Observationinteger8
Predecessor: CE.CEENDY
ADURNAnalysis Duration (N)integer8
Derived
The numeric portion of CEDUR (following 'P').
ADURUAnalysis Duration Unitstext4Analysis Duration Units
  • • "DAYS" = "Day"
  • • "hours" = "hours"
Derived
'DAYS' when CEDUR ends with 'D'.

Assigned as "DAYS"

CEDURDurationdurationDatetimeISO 8601
Predecessor: CE.CEDUR
CEENRTPTEnd Relative to Reference Time Pointtext7End Relative to Reference Time Point in ADCEVD
  • • "ONGOING"
Predecessor: CE.CEENRTPT
CEENTPTEnd Reference Time Pointtext5End Reference Time Point in ADCEVD
  • • "DAY 7"
Predecessor: CE.CEENTPT
ATPTAnalysis Timepointtext5Analysis Timepoint in ADCEVD
  • • "DAY 7"
Derived
Same as CETPT.
ATPTNAnalysis Timepoint (N)integer8
Assigned

7 when ATPT = 'DAY 7'.

CETPTPlanned Time Point Nametext5Planned Time Point Name in ADCEVD
  • • "DAY 7"
Predecessor: CE.CETPT
ATPTREFAnalysis Timepoint Referencetext5Analysis Timepoint Reference in ADCEVD
  • • "Boost"
  • • "Prime"
Derived
'Prime' when CETPTREF = 'PRIME VACCINATION'; 'Boost' when CETPTREF = 'BOOST VACCINATION'.
CETPTREFTime Point Referencetext17Time Point Reference in ADCEVD
  • • "PRIME VACCINATION"
  • • "BOOST VACCINATION"
Predecessor: CE.CETPTREF
CEOCCURClinical Event Occurrencetext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: CE.CEOCCUR
CEPRESPClinical Event Pre-Specifiedtext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Predecessor: CE.CEPRESP
AOCCLRFL1st Occurrence Local Reactiontext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record for given USUBJID when sorted by ASTDT and CETERM having CEOCCUR = 'Y' and ACAT1 = 'local'.
AOCCL3FL1st Occur Gr>=3 Local Reactiontext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'local' and SEVGR1 = 'grade >= 3'.
AOCCLPFL1st Occurrence Local Reaction-Primetext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'local' and ATPTREF = 'Prime'.
AOCCXPFL1st Occur Gr>=3 Local Reaction-Primetext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'local' and SEVGR1 = 'grade >= 3' and ATPTREF = 'Prime'.
AOCCLBFL1st Occurrence Local Reaction-Boosttext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'local' and ATPTREF = 'Boost'.
AOCCXBFL1st Occur Gr>=3 Local Reaction-Boosttext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'local' and SEVGR1 = 'grade >= 3' and ATPTREF = 'Boost'.
AOCCSRFL1st Occurrence Systemic Reactiontext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic'.
AOCCS3FL1st Occur Gr>=3 Systemic Reactiontext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic' and SEVGR1 = 'grade >= 3'.
AOCCSPFL1st Occurrence Systemic Reaction-Primetext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic' and ATPTREF = 'Prime'.
AOCCYPFL1st Occur Gr>=3 Systemic Reaction-Primetext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic' and SEVGR1 = 'grade >= 3' and ATPTREF = 'Prime'.
AOCCSBFL1st Occurrence Systemic Reaction-Boosttext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic' and ATPTREF = 'Boost'.
AOCCYBFL1st Occur Gr>=3 Systemic Reaction-Boosttext1No Yes Response (Yes Only)
  • • "Y" = "Yes"
Derived
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic' and SEVGR1 = 'grade >= 3' and ATPTREF = 'Boost'.
ASEVAnalysis Severity/Intensitytext8Analysis Severity/Intensity of Clinical Events in ADCEVD
  • • "Mild"
  • • "Moderate"
  • • "Severe"
  • • "Potentially Life Threatening"
Derived
CESEV in proper case.
ASEVNAnalysis Severity/Intensity (N)integer8
Assigned

1 when ASEV = 'Mild', 2 when ASEV = 'Moderate', 3 when ASEV = 'Severe', 4 when ASEV = 'Potentially life threatening'.

CESEVSeverity/Intensitytext8Severity Response in ADCEVD
  • • "MILD"
  • • "MODERATE"
  • • "SEVERE"
  • • "POTENTIALLY LIFE THREATENING"
Predecessor: CE.CESEV
SEVGR1Pooled Severity Group 1text10Pooled Severity Group 1 in ADCEVD
  • • "grade < 3"
  • • "grade >= 3"
Derived
'grade < 3' when ASEVN is not missing and less than 3 (Mild or Moderate); 'grade >= 3' when ASEVN is greater than or equal to 3 (Severe or Potentially Life Threatening).
SEVGR1NPooled Severity Group 1 (N)integer8
Assigned

1 when SEVGR1 = 'grade < 3', 2 when SEVGR1 = 'grade >= 3'.

AGEAgeinteger8
Predecessor: ADSL.AGE
AGEUAge Unitstext5Age Unit
  • • "YEARS" = "Year"
Predecessor: ADSL.AGEU
SEXSextext1Sex
  • • "M" = "Male"
  • • "F" = "Female"
Predecessor: ADSL.SEX
SEXNSex (N)integer8
Predecessor: ADSL.SEXN
RACERacetext25Race

[9 Terms]

Predecessor: ADSL.RACE
RACENRace (N)integer8
Predecessor: ADSL.RACEN
SCRFLScreened Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SCRFL
SCRFNScreened Population Flag (N)integer8
Predecessor: ADSL.SCRFN
SAFFLSafety Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SAFFL
SAFFNSafety Population Flag (N)integer8
Predecessor: ADSL.SAFFN
SAFBFLSafety Boost Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.SAFBFL
SAFBFNSafety Boost Population Flag (N)integer8
Predecessor: ADSL.SAFBFN
IMMFLImmunogenicity Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.IMMFL
IMMFNImmunogenicity Population Flag (N)integer8
Predecessor: ADSL.IMMFN
PPROTFLPer-Protocol Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.PPROTFL
PPROTFNPer-Protocol Population Flag (N)integer8
Predecessor: ADSL.PPROTFN
CP7FLPrime + 7 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CP7FL
CP7FNPrime + 7 Days Completers Set (N)integer8
Predecessor: ADSL.CP7FN
CPBP28FLPrime to Boost or Prime +28 D. Comp. Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CPBP28FL
CPBP28FNPri. to Bo. or Pri. +28 D. Comp. Set (N)integer8
Predecessor: ADSL.CPBP28FN
CB7FLBoost + 7 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CB7FL
CB7FNBoost + 7 Days Completers Set (N)integer8
Predecessor: ADSL.CB7FN
CB28FLBoost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CB28FL
CB28FNBoost + 28 Days Completers Set (N)integer8
Predecessor: ADSL.CB28FN
CPB28FLPrime or Boost + 28 Days Completers Settext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.CPB28FL
CPB28FNPrime or Boost + 28 Days Comp. Set (N)integer8
Predecessor: ADSL.CPB28FN
COMPLFLCompleters Population Flagtext1No Yes Response
  • • "N" = "No"
  • • "Y" = "Yes"
Predecessor: ADSL.COMPLFL
COMPLFNCompleters Population Flag (N)integer8
Predecessor: ADSL.COMPLFN
TRTSDTDate of First Exposure to TreatmentintegerDATE9
Predecessor: ADSL.TRTSDT
TRTSDTMDatetime of First Exposure to TreatmentintegerDATETIME19
Predecessor: ADSL.TRTSDTM
TRTSTMTime of First Exposure to TreatmentintegerTIME5
Predecessor: ADSL.TRTSTM
TRTEDTDate of Last Exposure to TreatmentintegerDATE9
Predecessor: ADSL.TRTEDT
TRTEDTMDatetime of Last Exposure to TreatmentintegerDATETIME19
Predecessor: ADSL.TRTEDTM
TRTETMTime of Last Exposure to TreatmentintegerTIME5
Predecessor: ADSL.TRTETM
ALLOCDTDate of AllocationintegerDATE9
Predecessor: ADSL.ALLOCDT
ALLOCTMTime of AllocationintegerTIME5
Predecessor: ADSL.ALLOCTM
ALLOCDTMDatetime of AllocationintegerDATETIME19
Predecessor: ADSL.ALLOCDTM
PRIMDTDate of Prime ImmunizationintegerDATE9
Predecessor: ADSL.PRIMDT
PRIMTMTime of Prime ImmunizationintegerTIME5
Predecessor: ADSL.PRIMTM
PRIMDTMDatetime of Prime ImmunizationintegerDATETIME19
Predecessor: ADSL.PRIMDTM
BOIMDTDate of Boost ImmunizationintegerDATE9
Predecessor: ADSL.BOIMDT
BOIMTMTime of Boost ImmunizationintegerTIME5
Predecessor: ADSL.BOIMTM
BOIMDTMDatetime of Boost ImmunizationintegerDATETIME19
Predecessor: ADSL.BOIMDTM

Go to the top of the Define-XML document


CodeLists

Description of Actual Arm
Permitted Value (Code)
BNT162b1 1 ug
BNT162b1 3 ug
BNT162b1 10 ug
BNT162b1 20 ug
BNT162b1 30 ug
BNT162b1 50 ug
BNT162b1 60 ug
BNT162b2 1 ug
BNT162b2 3 ug
BNT162b2 10 ug
BNT162b2 20 ug
BNT162b2 30 ug
Analysis Action Taken with Study Trtmnt
Permitted Value (Code)
Dose Not Changed
Dose Reduced
Drug Interrupted
Drug Withdrawn
Not Applicable
Unknown
Action Taken with Study Treatment [C66767]
Permitted Value (Code)Display Value (Decode)
DOSE NOT CHANGED [C49504]Dose Not Changed
DOSE REDUCED [C49505]Dose Reduced
DRUG INTERRUPTED [C49501]Drug Interrupted
DRUG WITHDRAWN [C49502]Drug Withdrawn
NOT APPLICABLE [C48660]Not Applicable
UNKNOWN [C17998]Unknown
Category for Adverse Event
Permitted Value (Code)
GENERAL
SPECIAL INTEREST
Outcome of Event in AE [C66768]
Permitted Value (Code)Display Value (Decode)
NOT RECOVERED/NOT RESOLVED [C49494]Not Recovered or Not Resolved
RECOVERED/RESOLVED [C49498]Recovered or Resolved
RECOVERED/RESOLVED WITH SEQUELAE [C49495]Recovered or Resolved with Sequelae
RECOVERING/RESOLVING [C49496]Recovering or Resolving
FATAL [C48275]Death Related to Adverse Event
UNKNOWN [C17998]Unknown
Causality
Permitted Value (Code)
NOT RELATED
RELATED
Severity/Intensity Scale for AE [C66769]
Permitted Value (Code)Display Value (Decode)
MILD [C41338]Mild Adverse Event
MODERATE [C41339]Moderate Adverse Event
SEVERE [C41340]Severe Adverse Event
Standard Toxicity Grade in Adverse Events
Permitted Value (Code)
MILD
MODERATE
SEVERE
POTENTIALLY LIFE THREATENING
Analysis Outcome of Adverse Event
Permitted Value (Code)
Not Recovered/Not Resolved
Recovered/Resolved
Recovered/Resolved With Sequelae
Recovering/Resolving
Fatal
Unknown
Analysis Causality
Permitted Value (Code)
Not Related
Related
Analysis Severity/Intensity of Adverse Events
Permitted Value (Code)
Mild
Moderate
Severe
Potentially Life Threatening
Analysis Category 1 in ADCEVD
Permitted Value (Code)
local
systemic
Analysis Severity/Intensity of Clinical Events in ADCEVD
Permitted Value (Code)
Mild
Moderate
Severe
Potentially Life Threatening
Analysis Timepoint in ADCEVD
Permitted Value (Code)
DAY 7
Analysis Timepoint Reference in ADCEVD
Permitted Value (Code)
Boost
Prime
Category for Clinical Event in ADCEVD
Permitted Value (Code)
REACTOGENICITY
End Relative to Reference Time Point in ADCEVD
Permitted Value (Code)
ONGOING
End Reference Time Point in ADCEVD
Permitted Value (Code)
DAY 7
Group ID in ADCEVD
Permitted Value (Code)
BOOST VACCINATION-ADMINISTRATION SITE
BOOST VACCINATION-SYSTEMIC
PRIME VACCINATION-ADMINISTRATION SITE
PRIME VACCINATION-SYSTEMIC
Subcategory for Clinical Event in ADCEVD
Permitted Value (Code)
ADMINISTRATION SITE
SYSTEMIC
Severity Response in ADCEVD [C165643]
Permitted Value (Code)
MILD [C70666]
MODERATE [C61376]
SEVERE [C70667]
POTENTIALLY LIFE THREATENING [*]

* Extended Value

Reported Term for the Clinical Event in ADCEVD
Permitted Value (Code)
Injection site reaction - Pain
Injection site reaction - Tenderness
Injection site reaction - Erythema/Redness
Injection site reaction - Induration/Swelling
Nausea
Vomiting
Diarrhea
Headache
Fatigue
Myalgia
Arthralgia
Chills
Loss of Appetite
Malaise
Fever
Planned Time Point Name in ADCEVD
Permitted Value (Code)
DAY 7
Time Point Reference in ADCEVD
Permitted Value (Code)
PRIME VACCINATION
BOOST VACCINATION
Pooled Severity Group 1 in ADCEVD
Permitted Value (Code)
grade < 3
grade >= 3
Analysis Timepoint Reference in ADCEVD
Permitted Value (Code)
Boost
Prime
Analysis Value (C) for severity/intensity records in ADFACEVD
Permitted Value (Code)
Mild
Moderate
Severe
Potentially Life Threatening
Analysis Value Category 1 for severity/intensity records in ADFACEVD
Permitted Value (Code)
grade < 3
grade >= 3
Analysis Value Category 1 for time to first or time from first to last grade >= 3 occurrence records in ADFACEVD
Permitted Value (Code)
grade >= 3
Object of the Observation in ADFACEVD
Permitted Value (Code)
Arthralgia
Chills
Diarrhea
Fatigue
Headache
Injection site reaction - Erythema/Redness
Injection site reaction - Induration/Swelling
Injection site reaction - Pain
Injection site reaction - Tenderness
Loss of Appetite
Malaise
Myalgia
Nausea
Vomiting
Subcategory for Findings About in ADFACEVD
Permitted Value (Code)
ADMINISTRATION SITE
SYSTEMIC
Character Result/Finding in Std Format in ADFACEVD
Permitted Value (Code)
N
Y
MILD
MODERATE
SEVERE
POTENTIALLY LIFE THREATENING
Findings About Test Name in ADFACEVD
Permitted Value (Code)
Occurrence Indicator
Severity/Intensity
Findings About Test Short Name in ADFACEVD
Permitted Value (Code)
OCCUR
SEV
Time Point Reference in ADFACEVD
Permitted Value (Code)
BOOST VACCINATION
PRIME VACCINATION
Parameter for Time from 1st to last grade>=3 occurrence record in ADFACEVD
Permitted Value (Code)
Time from first to last local or systemic reaction with grade >= 3
Time from first to last local reaction with grade >= 3
Time from first to last systemic reaction with grade >= 3
Parameter for Time from 1st to last occurrence record in ADFACEVD
Permitted Value (Code)
Time from first to last local or systemic reaction
Time from first to last local reaction
Time from first to last systemic reaction
Parameter for FACE occurrence record in ADFACEVD
Permitted Value (Code)
Pain at injection site occurrence indicator
Tenderness at injection site occurrence indicator
Redness occurrence indicator
Swelling occurrence indicator
Nausea occurrence indicator
Vomiting occurrence indicator
Diarrhea occurrence indicator
Headache occurrence indicator
Fatigue occurrence indicator
Myalgia occurrence indicator
Arthralgia occurrence indicator
Chills occurrence indicator
Loss of Appetite occurrence indicator
Malaise occurrence indicator
Parameter for FACE severity record in ADFACEVD
Permitted Value (Code)
Pain at injection site severity/intensity
Tenderness at injection site severity/intensity
Redness severity/intensity
Swelling severity/intensity
Nausea severity/intensity
Vomiting severity/intensity
Diarrhea severity/intensity
Headache severity/intensity
Fatigue severity/intensity
Myalgia severity/intensity
Arthralgia severity/intensity
Chills severity/intensity
Loss of Appetite severity/intensity
Malaise severity/intensity
Parameter for Time to 1st grade>=3 occurrence record in ADFACEVD
Permitted Value (Code)
Time to first local or systemic reaction with grade >= 3
Time to first local reaction with grade >= 3
Time to first systemic reaction with grade >= 3
Parameter for Time to 1st occurrence record in ADFACEVD
Permitted Value (Code)
Time to first local or systemic reaction
Time to first local reaction
Time to first systemic reaction
Parameter for VS record in ADFACEVD
Permitted Value (Code)
Fever occurrence indicator
Fever severity/intensity
Parameter Code in ADFACEVD
Permitted Value (Code)Display Value (Decode)
TTEFARTime to first local or systemic reaction
TTEFAR3Time to first local or systemic reaction with grade >= 3
DURARTime from first to last local or systemic reaction
DURAR3Time from first to last local or systemic reaction with grade >= 3
TTEFLRTime to first local reaction
TTEFLR3Time to first local reaction with grade >= 3
DURLRTime from first to last local reaction
DURLR3Time from first to last local reaction with grade >= 3
TTEFSRTime to first systemic reaction
TTEFSR3Time to first systemic reaction with grade >= 3
DURSRTime from first to last systemic reaction
DURSR3Time from first to last systemic reaction with grade >= 3
OCPISPain at injection site occurrence indicator
SEVPISPain at injection site severity/intensity
OCTISTenderness at injection site occurrence indicator
SEVTISTenderness at injection site severity/intensity
OCISRRedness occurrence indicator
SEVREDNRedness severity/intensity
OCINSSwelling occurrence indicator
SEVSWELSwelling severity/intensity
OCNAUSNausea occurrence indicator
SEVNAUSNausea severity/intensity
OCVOMIVomiting occurrence indicator
SEVVOMIVomiting severity/intensity
OCDIARDiarrhea occurrence indicator
SEVDIARDiarrhea severity/intensity
OCHEADHeadache occurrence indicator
SEVHEADHeadache severity/intensity
OCFATIGFatigue occurrence indicator
SEVFATIFatigue severity/intensity
OCMYALGMyalgia occurrence indicator
SEVMYALGMyalgia severity/intensity
OCARTHRArthralgia occurrence indicator
SEVARTHRArthralgia severity/intensity
OCCHILLSChills occurrence indicator
SEVCHILChills severity/intensity
OCLOALoss of Appetite occurrence indicator
SEVLOALoss of Appetite severity/intensity
OCMALAIMalaise occurrence indicator
SEVMALAIMalaise severity/intensity
OCFEVERFever occurrence indicator
SEVFEVERFever severity/intensity
Parameter (N) in ADFACEVD
Permitted Value (Code)Display Value (Decode)
1Time to first local or systemic reaction
2Time to first local or systemic reaction with grade >= 3
3Time from first to last local or systemic reaction
4Time from first to last local or systemic reaction with grade >= 3
11Time to first local reaction
12Time to first local reaction with grade >= 3
13Time from first to last local reaction
14Time from first to last local reaction with grade >= 3
21Time to first systemic reaction
22Time to first systemic reaction with grade >= 3
23Time from first to last systemic reaction
24Time from first to last systemic reaction with grade >= 3
100Pain at injection site occurrence indicator
101Pain at injection site severity/intensity
105Tenderness at injection site occurrence indicator
106Tenderness at injection site severity/intensity
110Redness occurrence indicator
111Redness severity/intensity
115Swelling occurrence indicator
116Swelling severity/intensity
200Nausea occurrence indicator
201Nausea severity/intensity
205Vomiting occurrence indicator
206Vomiting severity/intensity
210Diarrhea occurrence indicator
211Diarrhea severity/intensity
215Headache occurrence indicator
216Headache severity/intensity
220Fatigue occurrence indicator
221Fatigue severity/intensity
225Myalgia occurrence indicator
226Myalgia severity/intensity
230Arthralgia occurrence indicator
231Arthralgia severity/intensity
235Chills occurrence indicator
236Chills severity/intensity
240Loss of Appetite occurrence indicator
241Loss of Appetite severity/intensity
245Malaise occurrence indicator
246Malaise severity/intensity
250Fever occurrence indicator
251Fever severity/intensity
Parameter Category 1 in ADFACEVD
Permitted Value (Code)
local
systemic
Vital Signs Test Name in ADFACEVD [C67153]
Permitted Value (Code)
Temperature [C25206]
Vital Signs Test Short Name in ADFACEVD
Permitted Value (Code)
TEMP
Time Point Reference in ADFACEVD
Permitted Value (Code)
BOOST VACCINATION
PRIME VACCINATION
Source Data in ADFACEVD
Permitted Value (Code)
FA
VS
Source Variable in ADFACEVD
Permitted Value (Code)
FASTRESC
VSSTRESN
FADY
VSDY
Analysis Reference Range Indicator
Permitted Value (Code)
Low
Normal
High
Abnormal
Missing
Baseline Value (C)
Permitted Value (Code)
(+)
+
++
+++
0-2
11-20
21-50
3-6
7-10
massive
negative
normal
not detectable
positive
potassium very high. please send a fresh specimen.
Baseline Reference Range Indicator
Permitted Value (Code)
Low
Normal
High
Abnormal
Missing
Comments 1 Evaluator
Permitted Value (Code)
INVESTIGATOR
LABORATORY
Comments 2 Evaluator
Permitted Value (Code)
LABORATORY
Comments 1
Permitted Value (Code)
Control V1
Controlled result
Controlled result Suspicion of incorrect sampling, result implausible.
Material older than 3 days. Deviations are to be expected.
PD effect
Probable difficulties by blood drwaning
control
menses
nearly before start of mensis, fluor albus
not fasted
presumably reactive (this group summarises e.g. irritated lymphocytes, virocytes, Pfeiffer cells)
sample hemolytic, interference by hemolysis expected
singular isolated increase
suspected of given no midstream urine
volunteer had an infected tooth
Comments 2
Permitted Value (Code)
Controlled result
LOINC Code for Identification
Permitted Value (Code)
5782-8
58436-7
LOINC Code for second Identification
Permitted Value (Code)
5782-8
Method of Test or Examination [C85492]
Permitted Value (Code)Display Value (Decode)
CALCULATION [C54125]Calculation
COLORIMETRY [C111096]Colorimetry
DIPSTICK [C106516]Dipstick
ELECTROCHEMILUMINESCENCE IMMUNOASSAY [C111194]Electrochemiluminescence Immunoassay
FLOW CYTOMETRY [C16585]Flow Cytometry
JAFFE REACTION [C120694]Jaffe Reaction
MICROSCOPY [C16853]Microscopy
PHOTOMETRY [C65109]Photometry
POTENTIOMETRY [*]POTENTIOMETRY
TURBIDIMETRY [C111328]Turbidimetry

* Extended Value

Vendor Name
Permitted Value (Code)
CRS CLINICAL RESEARCH SERVICES BERLIN GMBH
CRS CLINICAL RESEARCH SERVICES MANNHEIM GMBH
MLM
Identification for Result
Permitted Value (Code)
Amorph Crystals: +
Amorph Crystals: ++
Amorph Crystals: +++
Calcium Oxalates: (+)
Calcium Oxalates: +
Calcium Oxalates: ++
Calcium Oxalates: +++
amorph crystals: +++
amorph crystals: massive
hyalinic cylinders: (+)
urate: +
urate: +++
urate: massive
Second Identification for Result
Permitted Value (Code)
Calcium Oxalates: ++
Calcium Oxalates: +++
Specimen Type [C78734]
Permitted Value (Code)Display Value (Decode)
BLOOD [C12434]Blood
BLOOD SMEAR [*]BLOOD SMEAR
EXPIRED AIR [C78741]Expired Air
SERUM [C13325]Serum
URINE [C13283]Urine

* Extended Value

Normal/Abnormal/CS
Permitted Value (Code)
Abnormal (not CS)
CS abnormal
Missing
Normal
Parameter Category 1
Permitted Value (Code)
Chemistry
Hematology
Urinalysis
Parameter Category 2
Permitted Value (Code)
Drug of Abuse
Pregnancy
Report Blood Count
Permitted Value (Code)
cells damaged
crenated erythrocytes
Report Blood Count 2
Permitted Value (Code)
crenated erythrocytes
some crenated cells
Visit Name
Permitted Value (Code)
Unscheduled 1.01
Unscheduled 5.01
Unscheduled 6.01
Unscheduled 7.01
Unscheduled 8.01
Unscheduled 9.01
Visit 0 (Day -30 to 0)
Visit 1 (Day 1)
Visit 2 (Day 2)
Visit 3 (Day 8)
Visit 4 / Dosing (Day 22)
Visit 5 (Day 29)
Visit 7 / EoT Visit (Day 50)
ADLB Analysis Visit
Permitted Value (Code)
Day -30 to 0
Day 1
Day 2
Day 22
Day 29
Day 50
Day 8
Unscheduled 1 Day -30 to 0
Unscheduled 1 Day 22
Unscheduled 1 Day 29
Unscheduled 1 Day 43
Unscheduled 1 Day 50
Unscheduled 1 Day 8
ADLBSource Data
Permitted Value (Code)
LB
ADLBSource Variable
Permitted Value (Code)
LBORRES
Cohort
Permitted Value (Code)
Cohort 1
Cohort 2
Cohort 3
Cohort 4
Cohort 5
Cohort 6
Cohort 7
Reason for Discontinuation from Study
Permitted Value (Code)
Adverse Event
Other
Protocol Deviation
Withdrawal By Subject
Reason Spec for Discont from Study
Permitted Value (Code)
Adverse Event
Due To Private Reason.
Protocol Deviation
Withdrawal By Subject
Reason for Exclusion Immunogenicity Set
Permitted Value (Code)
Subject did not receive one dose of IMP or did not have one post-baseline immunogenicity assessment
Reason 1 for Exclusion Per-Protocol Set
Permitted Value (Code)
Subject is not included in the immunogenicity set or had major protocol deviation
Reason 1 for Exclusion Safety Boost Set
Permitted Value (Code)
Subject did not receive two doses of IMP
Group
Permitted Value (Code)
B (BNT162b1)
C (BNT162b2)
Investigator Name
Permitted Value (Code)
Armin Schultz
Previous TSNs
Permitted Value (Code)
276-01-0035
276-01-0120
276-02-0019
276-02-0059
276-02-0064
276-02-0067
276-02-0084
276-02-0086
276-02-0093
276-02-0096
276-02-0097
276-02-0098
276-02-0123
276-02-0124
276-02-100
First Protocol Version signed
Permitted Value (Code)
3.0, 17 Apr 2020
5.0, 26 MAY 2020
7.0, 26 JUN 2020
Second Protocol Version signed
Permitted Value (Code)
5.0, 26 MAY 2020
7.0, 26 JUN 2020
8.0, 21 JUL 2020
Third Protocol Version signed
Permitted Value (Code)
7.0, 26 JUN 2020
8.0, 21 JUL 2020
Fourth Protocol Version signed
Permitted Value (Code)
8.0, 21 JUL 2020
Study Site Identifier
Permitted Value (Code)
CRS Berlin
CRS Mannheim
Analysis Duration Units [C71620]
Permitted Value (Code)Display Value (Decode)
DAYS [C25301]Day
hours [*]hours

* Extended Value

Age Group 1
Permitted Value (Code)
18 - 55 Yrs
Analysis Criterion 1
Permitted Value (Code)
Seroconversion
Parameter Category 1
Permitted Value (Code)
IMMUNOGENICITY
ADVA Analysis Visit
Permitted Value (Code)
Unscheduled 5.01
Unscheduled 9.01
Visit 1 (Day 1)
Visit 3 (Day 8)
Visit 4 / Dosing (Day 22)
Visit 5 (Day 29)
Visit 6 (Day 43)
Visit 7 / EoT Visit (Day 50)
ADVA Parameter Code
Permitted Value (Code)Display Value (Decode)
C19RBDIGCOVID-19 RBD IgG (U/mL)
C19S1IGGCOVID-19 S1 IgG (U/mL)
C2NGNT50SARS-CoV-2 Serum Neutralizing Titer 50
C2NGNT90SARS-CoV-2 Serum Neutralizing Titer 90
FRC19RBDCOVID-19 RBD IgG Fold Rise
FRC19S1ICOVID-19 S1 IgG Fold Rise
FRC2NT50SARS-CoV-2 Serum Neutralizing Titer 50 Fold Rise
FRC2NT90SARS-CoV-2 Serum Neutralizing Titer 90 Fold Rise
ADVA Parameter (COVID-19)
Permitted Value (Code)
COVID-19 RBD IgG (U/mL)
COVID-19 S1 IgG (U/mL)
ADVA Parameter (Neutralizing Titer)
Permitted Value (Code)
SARS-CoV-2 Serum Neutralizing Titer 50
SARS-CoV-2 Serum Neutralizing Titer 90
ADVA Parameter (Fold Rise)
Permitted Value (Code)
COVID-19 RBD IgG Fold Rise
COVID-19 S1 IgG Fold Rise
SARS-CoV-2 Serum Neutralizing Titer 50 Fold Rise
SARS-CoV-2 Serum Neutralizing Titer 90 Fold Rise
ADVASource Data
Permitted Value (Code)
IS
ADVASource Variable
Permitted Value (Code)
ISSTRESC
Analysis Reference Range Indicator
Permitted Value (Code)
Abnormal
Normal
Analysis Timepoint Reference
Permitted Value (Code)
Boost Dosing
Prime Dosing
Baseline Reference Range Indicator
Permitted Value (Code)
Abnormal
Normal
Normal/Abnormal/CS
Permitted Value (Code)
Missing
CS abnormal
Abnormal (not CS)
Normal
Normal (not CS)
Parameter Category 1
Permitted Value (Code)
Reactogenicity
Parameter Category 2
Permitted Value (Code)
Systemic
Visit Name
Permitted Value (Code)
Unscheduled 1.01
Unscheduled 2.01
Unscheduled 3.01
Unscheduled 5.01
Unscheduled 9.01
Visit 0 (Day -30 to 0)
Visit 1 (Day 1)
Visit 2 (Day 2)
Visit 3 (Day 8)
Visit 4 / Dosing (Day 22)
Visit 5 (Day 29)
Visit 6 (Day 43)
Visit 7 / EoT Visit (Day 50)
Visit 8 / FU Visit (Day 85)
Laterality [C99073]
Permitted Value (Code)Display Value (Decode)
LEFT [C25229]Left
RIGHT [C25228]Right
Location of Vital Signs Measurement [C74456]
Permitted Value (Code)Display Value (Decode)
ARM [C32141]Arm
ORAL CAVITY [C12421]Oral Cavity
Vital Signs Position of Subject
Permitted Value (Code)
SUPINE
Completion Status
Permitted Value (Code)
NOT DONE
Planned Time Point Name
Permitted Value (Code)
1 hour
3 hours
6 hours
Predose
Time Point Reference
Permitted Value (Code)
BOOST VACCINATION
PRIME VACCINATION
ADVS Analysis Timepoint
Permitted Value (Code)
1 hour
3 hours
6 hours
Predose
ADVS Analysis Visit
Permitted Value (Code)
Day -30 to 0
Day 1
Day 2
Day 22
Day 29
Day 43
Day 50
Day 8
Day 85
Unscheduled 1 Day -30 to 0
Unscheduled 1 Day 1
Unscheduled 1 Day 2
Unscheduled 1 Day 50
Unscheduled 1 Day 8
ADVS Parameter
Permitted Value (Code)
Body Mass Index [kg/m2]
Diastolic Blood Pressure [mmHg]
Height [cm]
Pulse Rate [beats/min]
Respiratory Rate [breaths/min]
Systolic Blood Pressure [mmHg]
Temperature [C]
Temperature (Reactogenicity) [C]
Weight [kg]
ADVS Parameter Code
Permitted Value (Code)Display Value (Decode)
BMIBody Mass Index [kg/m2]
DIABPDiastolic Blood Pressure [mmHg]
HEIGHTHeight [cm]
PULSEPulse Rate [beats/min]
RESPRespiratory Rate [breaths/min]
SYSBPSystolic Blood Pressure [mmHg]
TEMPTemperature [C]
TEMPRTemperature (Reactogenicity) [C]
WEIGHTWeight [kg]
ADVSSource Data
Permitted Value (Code)
VS
ADVSSource Variable
Permitted Value (Code)
VSORRES
Age Unit [C66781]
Permitted Value (Code)Display Value (Decode)
YEARS [C29848]Year
Analysis Value (C)
Permitted Value (Code)
+
++
Description of Planned Arm
Permitted Value (Code)
BNT162b1 1 ug
BNT162b1 10 ug
BNT162b1 20 ug
BNT162b1 3 ug
BNT162b1 30 ug
BNT162b1 50 ug
BNT162b1 60 ug
BNT162b2 1 ug
BNT162b2 10 ug
BNT162b2 20 ug
BNT162b2 3 ug
BNT162b2 30 ug
Analysis Value (C)
Permitted Value (Code)
(+)
+
++
+++
massive
negative
not detectable
Analysis Value (C)
Permitted Value (Code)
17.0
negative
Analysis Value (C)
Permitted Value (Code)
negative
positive
not detectable
Derivation Type [C81224]
Permitted Value (Code)Display Value (Decode)
HALF LLOQ [*]HALF LLOQ
HALFLLOQ [C170546]HALFLLOQ

* Extended Value

End of Study Status
Permitted Value (Code)
COMPLETED
DISCONTINUED
Analysis Value (C)
Permitted Value (Code)
0-2
negative
not detectable
Analysis Value (C)
Permitted Value (Code)
0-2
3-6
7-10
11-20
21-50
>50
massive
negative
not detectable
Epoch [C99079]
Permitted Value (Code)Display Value (Decode)
BASELINE [C125938]Baseline Epoch
FOLLOW-UP [C99158]Clinical Study Follow-up
SCREENING [C48262]Trial Screening
TREATMENT [C101526]Treatment Epoch
Analysis Value (C)
Permitted Value (Code)
0-2
3-6
7-10
11-20
21-50
massive
negative
not detectable
Ethnic Group [C66790]
Permitted Value (Code)
HISPANIC OR LATINO [C17459]
NOT HISPANIC OR LATINO [C41222]
NOT REPORTED [C43234]
UNKNOWN [C17998]
Analysis Value (C)
Permitted Value (Code)
10
25
50
150
250
negative
Analysis Value (C)
Permitted Value (Code)
0.5
1.5
5.0
15.0
negative
Analysis Value (C)
Permitted Value (Code)
25
100
500
negative
No Yes Response (No Only) [C66742]
Permitted Value (Code)Display Value (Decode)
N [C49487]No
Negative/Positive Result
Permitted Value (Code)Display Value (Decode)
negative [C49487]No
positive [C49488]Yes
No Yes Response [C66742]
Permitted Value (Code)Display Value (Decode)
N [C49487]No
Y [C49488]Yes
Analysis Value (C)
Permitted Value (Code)
+
++
+++
Analysis Value (C)
Permitted Value (Code)
250
750
1500
5000
negative
Race [C74457]
Permitted Value (Code)
AMERICAN INDIAN OR ALASKA NATIVE [C41259]
ASIAN [C41260]
BLACK OR AFRICAN AMERICAN [C16352]
NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER [C41219]
WHITE [C41261]
NOT REPORTED [C43234]
UNKNOWN [C17998]
OTHER [*]
MULTIPLE [*]

* Extended Value

Sex [C66731]
Permitted Value (Code)Display Value (Decode)
M [C20197]Male
F [C16576]Female
Actual Treatment for Period 01
Permitted Value (Code)
1 µg
10 µg
20 µg
3 µg
30 µg
50 µg
60 µg
Planned Treatment for Period 01
Permitted Value (Code)
1 µg
10 µg
20 µg
3 µg
30 µg
50 µg
60 µg
Actual Treatment
Permitted Value (Code)
1 µg
3 µg
10 µg
20 µg
30 µg
50 µg
60 µg
Planned Treatment
Permitted Value (Code)
1 µg
3 µg
10 µg
20 µg
30 µg
50 µg
60 µg
Analysis Value (C)
Permitted Value (Code)
17
68
normal
No Yes Response (Yes Only) [C66742]
Permitted Value (Code)Display Value (Decode)
Y [C49488]Yes
Analysis Value (C)
Permitted Value (Code)
(+)
++

Go to the top of the Define-XML document


External Dictionaries

External Dictionaries
Reference NameExternal DictionaryDictionary Version
Medical Dictionary for Regulatory ActivitiesMedDRA23.0

Go to the top of the Define-XML document


Methods

Methods
MethodTypeDescription
Algorithm: ADAE.AACNComputation
Propcase(AE.AEACN) when AE.AEACN not missing.
Algorithm: ADAE.ADURNComputation
When AENDTM and ASTDTM not missing then ADURN=(AENDTM-ASTDTM)/(60*60).
Algorithm: ADAE.ADURUComputation
When ADURN not missing ADURU='hours'.
Algorithm: ADAE.AEEMRELComputation
If TRTEMFL='Y' and upcase(arel)='RELATED' then AEEMREL='Y'; else AEEMREL='N'.
Algorithm: ADAE.AEEMSComputation
If TRTEMFL='Y' and asevn in (3,4) then AEEMS='Y'; else AEEMS='N'.
Algorithm: ADAE.AEEMSERComputation
If TRTEMFL='Y' and aeser='Y' then AEEMSER='Y'; else AEEMSER='N'.
Algorithm: ADAE.AEEMSERRComputation
If TRTEMFL='Y' and aeser='Y' and upcase(arel)='RELATED' then AEEMSERR='Y'; else AEEMSERR='N'.
Algorithm: ADAE.AEEMSRELComputation
If TRTEMFL='Y' and asevn in (3,4) and upcase(arel)='RELATED' then AEEMSREL='Y'; else AEEMSREL='N'.
Algorithm: ADAE.AENDTComputation
Date part of AENDTM.
Algorithm: ADAE.AENDTMComputation
AE.AEENDTC as SAS datetime.
Algorithm: ADAE.AENDYComputation
if AENDT >=PRIMDT then AENDY=(AENDT - PRIMDT)+1; else if AENDT <PRIMDT then AENDY=AENDT - PRIMDT.
Algorithm: ADAE.AENTMComputation
Time part of AENDTM.
Algorithm: ADAE.AOUTComputation
Propcase(AE.AEOUT) when AE.AEOUT not missing.
Algorithm: ADAE.ARELComputation
Propcase (AE.AEREL) when AE.AEREL not missing.
Algorithm: ADAE.ASEVComputation
Propcase(AE.AESEV) when AE.AESEV not missing ; else Propcase(AE.AETOXGR) when AE.AETOXGR is not missing. ASEV= ' ' when both AE.AESEV and AE.AETOXGR missing.
Algorithm: ADAE.ASTDTComputation
Date part of ASTDTM.
Algorithm: ADAE.ASTDTMComputation
AE.AESTDTC as SAS datetime.
Algorithm: ADAE.ASTTMComputation
Time part of ASTDTM.
Algorithm: ADAE.LSTDDComputation
When BOIMDT not missing: if ASTDT < BOIMDT then LSTDD=ASTDT-PRIMDT +1; else if ASTDT >= BOIMDT then LSTDD=ASTDT-BOIMDT+1; When BOIMDT missing: if ASTDT >= PRIMDT then LSTDD=ASTDT-PRIMDT +1.
Algorithm: ADAE.PTDIAFLComputation
if (AE.AEDECOD in ('Abdominal pain', ' Abdominal pain lower', ' Arthralgia', 'Chills', 'Decreased appetite', 'Diarrhoea', 'Discomfort', 'Fatigue', ' Feeling hot', 'Gastrointestinal disorder', 'Headache', 'Hot flush', 'Influenza like illness', 'Injection site discomfort', 'Injection site erythema', 'Injection site hypersensitivity', 'Injection site pain', 'Injection site paraesthesia', 'Injection site reaction', 'Injection site swelling', 'Malaise', 'Muscle tightness', 'Myalgia', 'Nausea', ' Pyrexia' , 'Vomiting', 'Axillary pain', 'Body temperature increased', 'C-reactive protein increased', 'Dizziness', 'Head discomfort', 'Injection site discolouration', 'Injection site hypoaesthesia', 'Neck pain' ) and ((AENDT - ASTDT)+ 1)<=7) then PTDIAFL='Y'.
Algorithm: ADAE.TMINT1FLComputation
AE is Treatment-Emergent: if ASTDTM >= PRIMDTM and (PRIMDTM <= ASTDTM <= (PRIMDTM + 7 days)) then TMINT1FL='Y'; if ASTDTM < PRIMDTM and Adverse Event worsened after Prime immunization then TMINT1FL='Y'; if AE time missing and Date not missing and (PRIMDT <= ASTDT <= (PRIMDT + 7)) then TMINT1FL='Y'; if missing AE Date/or time and AE cannot be determined with above set rules, then TMINT1FL='Y';
Algorithm: ADAE.TMINT2FLComputation
AE is Treatment-Emergent: Identify the minimum of duration - ((Prime to Boost) or (28 days from Prime) - whatever comes first. When Boost is missing, duration is 28 days from Prime. if duration < 28 then: (Prime to Boost contribution) if not missing AE start date/time and PRIMDTM <= ASTDTM <= BOIMDTM then TMINT2FL='Y'; if not missing AE start date/time and ASTDTM < PRIMDTM and Adverse Event worsened after Prime immunization then TMINT2FL='Y'; if missing AE start time and PRIMDT <= ASTDT <= BOIMDT then TMINT2FL='Y'; if missing AE start time and ASTDT < PRIMDT and Adverse Event worsened after Prime immunization then TMINT2FL='Y'; if duration = 28 then: (28 days from prime contribution) if not missing AE start date/time and PRIMDTM <= ASTDTM <= (PRIMDTM + 28 days) then TMINT2FL='Y'; if not missing AE start date/time and ASTDTM < PRIMDTM and Adverse Event worsened after Prime immunization then TMINT2FL='Y'; if missing AE start time and PRIMDT <= ASTDT <= (PRIMDT + 28) then TMINT2FL='Y'; if missing AE start time and ASTDT < PRIMDT and Adverse Event worsened after Prime immunization then TMINT2FL='Y'; if missing AE Date/or time and AE cannot be determined with above set rules, then TMINT2FL='Y';
Algorithm: ADAE.TMINT3FLComputation
AE is Treatment-Emergent: if ASTDTM >= BOIMDTM and (BOIMDTM <= ASTDTM <= (BOIMDTM + 7 days)) then TMINT3FL='Y'; if ASTDTM < BOIMDTM and Adverse Event worsened after boost immunization then TMINT3FL='Y'; if AE time missing and Date not missing and Boost immunization date not missing and (BOIMDT <= ASTDT <= (BOIMDT + 7)) then TMINT3FL='Y'; if missing AE Date/or time and AE cannot be determined with above set rules, then TMINT3FL='Y';
Algorithm: ADAE.TMINT4FLComputation
AE is Treatment-Emergent: if ASTDTM >= BOIMDTM and (BOIMDTM <= ASTDTM <= (BOIMDTM + 28 days)) then TMINT4FL='Y'; if ASTDTM < BOIMDTM and Adverse Event worsened after boost immunization then TMINT4FL='Y'; if AE time missing and Date not missing and Boost immunization date not missing and (BOIMDT <= ASTDT <= (BOIMDT + 28)) then TMINT4FL='Y'; if missing AE Date/or time and AE cannot be determined with above set rules, then TMINT4FL='Y';
Algorithm: ADAE.TMINT5FLComputation
AE is Treatment-Emergent: if not missing AE Date/time, Prime/Boost immunization date/time and ASTDTM >= PRIMDTM and (PRIMDTM <= ASTDTM <= (BOIMDTM + 28 days)) then TMINT5FL='Y'; if not missing AE Date/time, Prime/Boost immunization date/time and ASTDTM < PRIMDTM and Adverse Event worsened on/after prime immunization and before/on (boost immunizaqtion + 28 days) then TMINT5FL='Y'; if not missing AE and Prime immunization date/time and boost date/time missing and ASTDTM >= PRIMDTM and (PRIMDTM <= ASTDTM <= (PRIMDTM + 28 days)) then TMINT5FL='Y'; if missing AE time and AE date available and ASTDT >= PRIMDT and (PRIMDT <= ASTDT <= (BOIMDT + 28)) then TMINT5FL='Y'; if missing AE time and AE date available and boost immunization missing and ASTDT >= PRIMDT and (PRIMDT <= ASTDT <= (PRIMDT + 28)) then TMINT5FL='Y'; if missing AE Date/or time and AE cannot be determined with above set rules, then TMINT5FL='Y';
Algorithm: ADAE.TRTEMFLComputation
*if not missing Adverse start date/time and AE start date/time >= first immunization date/time and AE start date/time <= (last immunization date/time + 28 days), then TRTEMFL='Y'; *if missing Adverse start time and AE start date >= first immunization date and AE start date <= (last immunization date + 28 days), then TRTEMFL='Y'; *if not missing Adverse start date/time and AE start date/time > (last immunization date/time + 28 days) but assessed as related to IMP by investigator then TRTEMFL='Y'; *if missing Adverse start time and AE start date > (last immunization date + 28 days) but assessed as related to IMP by investigator then TRTEMFL='Y'; *if AE present before immunization and worsened after first immunization, then TRTEMFL='Y'; *if missing AE date or time and AE cannot be determined TEAE from the above set rules, then TRTEMFL='Y';
Algorithm: ADCEVD.ACAT1Computation
'local' when CESCAT = 'ADMINISTRATION SITE'; 'systemic' when CESCAT = 'SYSTEMIC'.
Algorithm: ADCEVD.ADURNComputation
The numeric portion of CEDUR (following 'P').
Algorithm: ADCEVD.ADURUComputation
'DAYS' when CEDUR ends with 'D'.
Algorithm: ADCEVD.AENDTComputation
Date part of CEENDTC as SAS date.
Algorithm: ADCEVD.AOCCL3FLComputation
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'local' and SEVGR1 = 'grade >= 3'.
Algorithm: ADCEVD.AOCCLBFLComputation
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'local' and ATPTREF = 'Boost'.
Algorithm: ADCEVD.AOCCLPFLComputation
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'local' and ATPTREF = 'Prime'.
Algorithm: ADCEVD.AOCCLRFLComputation
'Y' if first record for given USUBJID when sorted by ASTDT and CETERM having CEOCCUR = 'Y' and ACAT1 = 'local'.
Algorithm: ADCEVD.AOCCS3FLComputation
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic' and SEVGR1 = 'grade >= 3'.
Algorithm: ADCEVD.AOCCSBFLComputation
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic' and ATPTREF = 'Boost'.
Algorithm: ADCEVD.AOCCSPFLComputation
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic' and ATPTREF = 'Prime'.
Algorithm: ADCEVD.AOCCSRFLComputation
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic'.
Algorithm: ADCEVD.AOCCXBFLComputation
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'local' and SEVGR1 = 'grade >= 3' and ATPTREF = 'Boost'.
Algorithm: ADCEVD.AOCCXPFLComputation
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'local' and SEVGR1 = 'grade >= 3' and ATPTREF = 'Prime'.
Algorithm: ADCEVD.AOCCYBFLComputation
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic' and SEVGR1 = 'grade >= 3' and ATPTREF = 'Boost'.
Algorithm: ADCEVD.AOCCYPFLComputation
'Y' if first record when sorted by ASTDT and CETERM for given USUBJID having CEOCCUR = 'Y' and ACAT1 = 'systemic' and SEVGR1 = 'grade >= 3' and ATPTREF = 'Prime'.
Algorithm: ADCEVD.ASEVComputation
CESEV in proper case.
Algorithm: ADCEVD.ASTDTComputation
Date part of CESTDTC as SAS date.
Algorithm: ADCEVD.ATPTComputation
Same as CETPT.
Algorithm: ADCEVD.ATPTREFComputation
'Prime' when CETPTREF = 'PRIME VACCINATION'; 'Boost' when CETPTREF = 'BOOST VACCINATION'.
Algorithm: ADCEVD.SEVGR1Computation
'grade < 3' when ASEVN is not missing and less than 3 (Mild or Moderate); 'grade >= 3' when ASEVN is greater than or equal to 3 (Severe or Potentially Life Threatening).
Algorithm: ADFACEVD.ADTComputation
Null when PARAMCD begins with 'DUR'. Otherwise, date part of FADTC as SAS date when SRCDOM = 'FA' and date part of VSDTC as SAS date when SRCDOM = 'VS'.
Algorithm: ADFACEVD.ADTMComputation
Null when PARAMCD begins with 'DUR'. Otherwise, FADTC as SAS datetime when SRCDOM = 'FA' and VSDTC as SAS datetime when SRCDOM = 'VS'.
Algorithm: ADFACEVD.AENDTComputation
Populated only for records with PARAMCD values beginning with 'DUR'. Set to latest date/time at which a given type of reactogenicity event occurred (i.e. the value of ADT on the last record meeting criteria for the given PARAM value, when sorted by USUBJID, ADY, and PARAMN).
Algorithm: ADFACEVD.ASTDTComputation
Populated only for records with PARAMCD values beginning with 'DUR'. Set to earliest date/time at which a given type of reactogenicity event occurred (i.e. the value of ADT on the first record meeting criteria for the given PARAM value, when sorted by USUBJID, ADY, and PARAMN).
Algorithm: ADFACEVD.ATPTComputation
FATPT in proper case when SRCDOM = 'FA', and VSTPT in proper case when SRCDOM = 'VS'. (Ex. 'Day 3').
Algorithm: ADFACEVD.ATPTREFComputation
'Prime' when FATPTREF or VSTPTREF = 'PRIME VACCINATION'; 'Boost' when FATPTREF or VSTPTREF = 'BOOST VACCINATION'.
Algorithm: ADFACEVD.AVALCAT1Computation
'grade < 3' when AVAL < 3; 'grade >= 3' when AVAL >= 3.
Algorithm: ADFACEVD.AVALC for severity/intensity parameters when SRCDOM = 'FA'Computation
FASTRESC in proper case.
Algorithm: ADFACEVD.AVALC when SRCDOM = 'VS' and PARAMCD = 'OCFEVER'Computation
'Y' when VSSTRESN >= 38.0; 'N', otherwise.
Algorithm: ADFACEVD.AVALC when SRCDOM = 'VS' and PARAMCD = 'SEVFEVER'Computation
'Mild' when 38.0 <= VSSTRESN <= 38.4; 'Moderate' when 38.4 < VSSTRESN <= 38.9; 'Severe' when 38.9 < VSSTRESN <= 40.0; 'Potentially life threatening' when 40.0 < VSSTRESN.
Algorithm: ADFACEVD.AVAL for time from first to last reaction recordsComputation
Number of days between first and last report of reaction for given subject and reaction category: ADFACEVD.AENDY - ADFACEVD.AESTDY + 1.
Algorithm: ADFACEVD.AVAL for severity/intensity recordsComputation
1 when AVALC = 'Mild'; 2 when AVALC = 'Moderate'; 3 when AVALC = 'Severe'; 4 when AVALC = 'Potentially life threatening'.
Algorithm: ADFACEVD.PARAM when FATESTCD = 'OCCUR'Computation
Concatenation of FACE.FAOBJ (selecting just the text following a slash '/' or dash '-', when applicable, and adding ' at injection site' for Pain and Tenderness records) and FATEST in proper case. (Ex: FAOBJ = 'Injection site reaction - Pain' --> PARAM = 'Pain at injection site occurrence indicator'). [Note that occurrence records from FACE (where FATESTCD = 'OCCUR') are included in ADFACEVD only if FAEVAL = 'STUDY SUBJECT' and FASTAT is null ('NOT DONE' records are excluded).]
Algorithm: ADFACEVD.PARAM when FATESTCD = 'SEV'Computation
Concatenation of FACE.FAOBJ (selecting just the text following a slash '/' or dash '-', when applicable, and adding ' at injection site' for Pain and Tenderness records) and FATEST in proper case. (Ex: FAOBJ = 'Injection site reaction - Pain' --> PARAM = 'Pain at injection site severity/intensity'). [Note that severity records from FACE (where FATESTCD = 'SEV') are included in ADFACEVD only if FAEVAL = 'STUDY SUBJECT' and FASTRESC is not 'NONE'.]
Algorithm: ADFACEVD.PARCAT1Computation
Null for records containing information about both local and systemic reactions (when PARAMCD is 'TTEFAR', 'TTEFAR3', 'DURAR', or 'DURAR3'). Otherwise, 'local' when FASCAT = 'ADMINISTRATION SITE', and 'systemic' when FASCAT = 'SYSTEMIC' or SRCDOM = 'VS'.
Algorithm: ADLB.ABLFLComputation
ABLFL='Y' for last non-missing AVAL/AVALC when Analysis date (ADLB.ADT) is on/before treatment start (ADLB.TRTSDT).
Algorithm: ADLB.ADTComputation
Date part of ADTM.
Algorithm: ADLB.ADTMComputation
LB.LBDTC as SAS datetime.
Algorithm: ADLB.ANL01FLComputation
ANL01FL='Y' for all scheduled visits and for records with DTYPE="HALFLLOQ". For records where LB.LBSTRESN=. And LB.LBSTRESC is like "<x", where x is numeric variable, ANL01FL=NULL. if ANRIND is derived based on LB.LBCLSIG then those records must be excluded from the analysis. i.e., ANLxxFL flags will be NULL. If the lab test has been performed on less than 3 subjects then those tests(PARAMs) must be excluded from the analysis. i.e., ANLxxFL flags will be NULL.
Algorithm: ADLB.ANL02FLComputation
ANL02FL='Y' when DTYPE=NULL. if ANRIND is derived based on LBCLSIG then those records must be excluded from the analysis. i.e., ANLxxFL flags will be NULL. If the lab test has been performed on less than 3 subjects then those tests(PARAMs) must be excluded from the analysis. i.e., ANLxxFL flags will be NULL.
Algorithm: ADLB.ANRHIComputation
ANRHI=LB.LBSTNRHI. if LB.LBSTNRHI=. and LB.LBSTNRC has values as "X-Y", where X,Y are numeric variables, then Y is ANRHI.
Algorithm: ADLB.ANRHICComputation
Character of ANRHI. If LB.LBSTNRLO is missing and LB.LBSTNRHI is non-missing then ANRHIC is shown as "<LB.LBSTNRHI+1"
Algorithm: ADLB.ANRINDComputation
Derived based on AVAL, ANRHI, ANRLO. For Urinalysis NEGATIVE, NORMAL are considered Normal, anything other than above are ABNORMAL. NOT DETECTABLE, INVALID VALUE are considered as MISSING. If AVAL/AVALC is missing or AVALC=+, for categories other than URINALYSIS, or (ANRHI and ANRLO) are missing but LBCLSIG is non-missing then for URINALYSIS ANRIND="Abnormal", For other categories, ANRIND="HIGH".
Algorithm: ADLB.ANRINDNComputation
Numeric Code of ANRIND, LOW=1, NORMAL=2, HIGH=3, ABNORMAL=4, MISSING=5
Algorithm: ADLB.ANRLOComputation
ADLB.ANRLO=LB.LBSTNRLO. if LB.LBSTNRLO=. and LB.LBSTNRC has values as "X-Y", where X,Y are numeric variables, then X is ADLB.ANRLO.
Algorithm: ADLB.ANRLOCComputation
Character of ANRLO
Algorithm: ADLB.ASEQComputation
Sort by USUBJID,PARAMCD, AVISITN. Assign sequential numbers starting with 1 for each subject.
Algorithm: ADLB.ATMComputation
Time part of ADTM.
Algorithm: ADLB.AVALComputation
LB.LBSTRESN, records needs to be added where LB.LBSTRESN=. And LB.LBSTRESC is like "<x". AVAL for these records will be 0.5*X and dtype="HALFLLOQ", X is a numeric variable. if LB.LBORRES captures continous results and LB.LBSTRESN is missing then AVAL=LB.LBORRES.
Algorithm: ADLB.AVALCComputation
Character of AVAL. if AVAL=. then LB.LBSTRESC.
Algorithm: ADLB.AVISITComputation
"If LB.VISIT=Visit 0 (Day -30 to 0) then AVISIT= Day -30 to 0 If LB.VISIT=Visit 1 (Day 1) then AVISIT= Day 1 If LB.VISIT=Visit 2 (Day 2) then AVISIT= Day 2 If LB.VISIT=Visit 3 (Day 8) then AVISIT= Day 8 If LB.VISIT=Visit 4 / Dosing (Day 22) then AVISIT= Day 22 If LB.VISIT=Visit 5 (Day 29) then AVISIT= Day 29 If LB.VISIT=Visit 7 / EoT Visit (Day 50) then AVISIT= Day 50 If LB.VISIT=Unscheduled 1.01 then AVISIT=Unscheduled Day -30 to 0 If LB.VISIT=Unscheduled 5.01 then AVISIT=Unscheduled Day 8 If LB.VISIT=Unscheduled 6.01 then AVISIT=Unscheduled Day 22 If LB.VISIT=Unscheduled 7.01 then AVISIT=Unscheduled Day 29 If LB.VISIT=Unscheduled 8.01 then AVISIT=Unscheduled Day 43 If LB.VISIT=Unscheduled 9.01 then AVISIT=Unscheduled Day 50
Algorithm: ADLB.AVISITNComputation
"If LB.VISIT=Visit 0 (Day -30 to 0) then AVISITN= 1 If LB.VISIT=Visit 1 (Day 1) then AVISITN= 2 If LB.VISIT=Visit 2 (Day 2) then AVISITN= 3 If LB.VISIT=Visit 3 (Day 8) then AVISITN= 5 If LB.VISIT=Visit 4 / Dosing (Day 22) then AVISITN= 6 If LB.VISIT=Visit 5 (Day 29) then AVISITN= 7 If LB.VISIT=Visit 7 / EoT Visit (Day 50) then AVISITN= 9 If LB.VISIT=Unscheduled 1.01 then AVISITN= 1.01 If LB.VISIT=Unscheduled 5.01 then AVISITN= 5.01 If LB.VISIT=Unscheduled 6.01 then AVISITN= 6.01 If LB.VISIT=Unscheduled 7.01 then AVISITN= 7.01 If LB.VISIT=Unscheduled 8.01 then AVISITN= 8.01 If LB.VISIT=Unscheduled 9.01 then AVISITN= 9.01
Algorithm: ADLB.BASEComputation
BASE=AVAL, when ABLFL="Y"
Algorithm: ADLB.BASECComputation
Character of BASE
Algorithm: ADLB.BNRINDComputation
BNRIND=ANRIND, when ABLFL='Y'
Algorithm: ADLB.BNRINDNComputation
Numeric Code of BNRIND, LOW=1, NORMAL=2, HIGH=3, ABNORMAL=4, MISSING=5
Algorithm: ADLB.CHGComputation
When AVAL and BASE are non-missing CHG = AVAL - BASE. if AVAL=0 & BASE=0 then CHG=.
Algorithm: ADLB.COMEVAL1Computation
Evaluator for COMMENT1 is COMEVAL1.
Algorithm: ADLB.COMEVAL2Computation
Evaluator for COMMENT2 is COMEVAL2.
Algorithm: ADLB.COMMENT1Computation
Comments are captured from CO domain. There will be each COMMENT<x> variable for each records in CO for a given subject. CO.COVAL is ADLB.COMMENT<x>, and corresponding CO.COEVAL is ADLB.COMEVAL<x>
Algorithm: ADLB.COMMENT2Computation
Comments are captured from CO domain. There will be each COMMENT<x> variable for each records in CO for a given subject. CO.COVAL is ADLB.COMMENT<x>, and corresponding CO.COEVAL is ADLB.COMEVAL<x>
Algorithm: ADLB.DTYPEComputation
Is populated for additional imputed records where LBSTRESN=. And LBSTRESC is like "<x". AVAL for these records will be 0.5*X and DTYPE="HALFLLOQ" . X is a numeric variable.
Algorithm: ADLB.LBCLSIGNComputation
numeric of LB.LBCLSIG, Y=1, N=0
Algorithm: ADLB.NABCSComputation
if ANRIND=abnormal and LB.LBCLSIG="Y" then NABCS= "CS Abnormal"; if ANRIND is abnormal and LB.LBCLSIG="N" then NABCS="Abnormal (not CS)"; if ANRIND is normal then NABCS="Normal"; if ANRIND=. Then NABCS="Missing" ;
Algorithm: ADLB.NABCSNComputation
Numeric Code of NABCS, Missing=1, CS abnormal=2, abnormal (not CS)=3, Normal=4
Algorithm: ADLB.PARAMComputation
PARAM=strip(LB.LBTEST)<||"("||strip(LB.LBSPEC)||")"||>"["||strip(LB.LBSTRESU)||"]" if same lab test is done in 2 or more categories then LB.LBSPEC is included. If not, just the LB.LBTEST and LB.LBSTRESU are used to assign PARAM. If LB.LBSTRESU is missing for a given test, LB.LBORRESU has been used.
Algorithm: ADLB.PARAMCDComputation
LB.LBTESTCD||<suffix as needed>, if same lab test is done in 2 or more categories or has different specimen type then suffix is updated with "B" "BS" "U" "UD" "UM". B for Blood, BS for Blood Serum, U for Urine, UD for Urine and Dipstick method, UM for Urine and Microscopy method. Adjust PARAMCD accordingly.
Algorithm: ADLB.PARAMNComputation
=1 for PARAMCD='ALT' 1 ; =2 for PARAMCD='ALB';=3 for PARAMCD='ALP'; =4 for PARAMCD='AMPHET'; =5 for PARAMCD='AMYLASE'; =6 for PARAMCD='ANISO'; =7 for PARAMCD='AST'; =8 for PARAMCD='BACT'; =9 for PARAMCD='BARB'; =10 for PARAMCD='BASOB'; =13 for PARAMCD='BASOBS'; =14 for PARAMCD='BASOLEB'; =15 for PARAMCD='BASOLEBS'; =16 for PARAMCD='BNZDZPN'; =17 for PARAMCD='BILIS'; =18 for PARAMCD='BILIU'; =19 for PARAMCD='CRP'; =20 for PARAMCD='CA';=21 for PARAMCD='CANNAB'; =22 for PARAMCD='CASTS'; =23 for PARAMCD='HCG'; =24 for PARAMCD='COCAINE'; =25 for PARAMCD='CK'; =26 for PARAMCD='CREAT'; =27 for PARAMCD='CRYSTALS'; =28 for PARAMCD='EOSB'; =31 for PARAMCD='EOSBS'; =32 for PARAMCD='EOSLEB'; =33 for PARAMCD='EOSLEBS'; =34 for PARAMCD='EPIC'; =35 for PARAMCD='MCHC'; =36 for PARAMCD='MCH'; =37 for PARAMCD='MCV'; =38 for PARAMCD='RBCB'; =39 for PARAMCD='RBCU'; =40 for PARAMCD='ETHANOL'; =43 for PARAMCD='FERRITIN'; =44 for PARAMCD='FSH'; =45 for PARAMCD='GGT'; =46 for PARAMCD='GLUCB'; =47 for PARAMCD='GLUCU'; =49 for PARAMCD='HCT'; =50 for PARAMCD='HGBB'; =51 for PARAMCD='HGBU'; =52 for PARAMCD='KETONES'; =53 for PARAMCD='WBCB'; =54 for PARAMCD='WBCUD'; =55 for PARAMCD='WBCUM'; =56 for PARAMCD='LIPASET'; =57 for PARAMCD='LYMB'; =60 for PARAMCD='LYMBS'; =61 for PARAMCD='LYMATLE'; =62 for PARAMCD='LYMLEB'; =63 for PARAMCD='LYMLEBS'; =64 for PARAMCD='METHDN'; =65 for PARAMCD='METHAMPH'; =66 for PARAMCD='MICROCY'; =67 for PARAMCD='MONOB'; =70 for PARAMCD='MONOBS'; =71 for PARAMCD='MONOLEB'; =72 for PARAMCD='MONOLEBS'; =73 for PARAMCD='MYCY'; =74 for PARAMCD='NEUTB'; =77 for PARAMCD='NEUTBS'; =78 for PARAMCD='NEUTLEB'; =79 for PARAMCD='NEUTLEBS'; =80 for PARAMCD='NITRITE'; =81 for PARAMCD='OPIATE'; =82 for PARAMCD='PH'; =83 for PARAMCD='PCP'; =84 for PARAMCD='PLAT'; =85 for PARAMCD='POIKILO'; =86 for PARAMCD='K'; =87 for PARAMCD='PROT'; =88 for PARAMCD='EPIROCE'; =89 for PARAMCD='SMDGCELE'; =90 for PARAMCD='SODIUM'; =91 for PARAMCD='SPGRAV'; =92 for PARAMCD='TRCYANDP'; =93 for PARAMCD='UREAN' ; =94 for PARAMCD='UROBIL'; =95 for PARAMCD='YEAST';
Algorithm: ADLB.PARCAT1Computation
LB.LBCAT
Algorithm: ADLB.PARCAT1NComputation
Numeric Code of PARCAT1, CHEMISTRY=1; HEMATOLOGY=2 ; URINALYSIS=3;
Algorithm: ADLB.PARCAT2Computation
LB.LBSCAT
Algorithm: ADLB.PARCAT2NComputation
Numeric Code of PARCAT2, DRUG OF ABUSE=1; PREGNANCY=2
Algorithm: ADLB.PCHGComputation
PCHG = ((AVAL - BASE)/BASE)*100 when AVAL and BASE are not missing.
Algorithm: ADLB.POBLFLComputation
POBLFL='Y' when ADTM>TRTSDTM, if ADTM=. Then use ADT/TRTSDT.
Algorithm: ADLB.SRCDOMComputation
LB.DOMAIN
Algorithm: ADLB.SRCSEQComputation
LB.LBSEQ
Algorithm: ADLB.UNSVFLComputation
if LB.VISIT contains "Unscheduled" then UNSVFL="Y"; else UNSVFL=' ';
Algorithm: ADLB.WPBFLComputation
WPBFL=Y for the first occurance of each abnormality for a given PARAM and USUBJID. if there is no abnormality for a given parameter and subject then first post-baseline visit is flagged as 'Y'
Algorithm: ADSL.AAGEComputation
Set to AGE when AGE_M is missing (i.e. no additional months are specified to be added to age). Otherwise, set to the AGE + AGE_M / 12, rounded to the nearest hundredth.
Algorithm: ADSL.ALLOCDTMComputation
DS.DSSTDTC as SAS datetime, selecting record where DS.DSDECOD = 'ALLOCATED'.
Algorithm: ADSL.BMIComputation
VS.VSSTRESN where VS.VSTESTCD = 'BMI' and VS.VSBLFL = 'Y'.
Algorithm: ADSL.BOIMDTMComputation
EC.ECSTDTC as SAS datetime, selecting record where EC.ECOCCUR = 'Y' and EC.VISITNUM = 6.
Algorithm: ADSL.CB28FLComputation
'Y' when subject is in the Safety Boost Population (SAFBFL = 'Y') and has completed at least 28 days of follow-up after receiving the boost vaccination (either EOSDT is populated and BOIMDT + 28 is less than EOSDT or BOIMDT + 28 is less than or equal to the data cutoff date of 13AUG2020). 'N', otherwise.
Algorithm: ADSL.CB7FLComputation
'Y' when subject is in the Safety Boost Population (SAFBFL = 'Y') and has completed at least 7 days of follow-up after receiving the boost vaccination (either EOSDT is populated and BOIMDT + 7 is less than EOSDT or BOIMDT + 7 is less than or equal to the data cutoff date of 13AUG2020). 'N', otherwise.
Algorithm: ADSL.COMPLFLComputation
'Y' when EOSSTT = 'COMPLETED'. 'N', otherwise.
Algorithm: ADSL.CP7FLComputation
'Y' when subject is in the Safety Population (SAFFL = 'Y') and has completed at least 7 days of follow-up after receiving the prime vaccination (either EOSDT is populated and PRIMDT + 7 is less than EOSDT or PRIMDT + 7 is less than or equal to the data cutoff date of 13AUG2020). 'N', otherwise.
Algorithm: ADSL.CPB28FLComputation
'Y' when subject is in the Prime to Boost or Prime +28 D. Comp. Population (CPBP28FL = 'Y') and has either (a) not received a boost vaccination (SAFBFL = 'N') or (b) is in the Boost + 28 Days Completers Population (CB28FL = 'Y'). 'N', otherwise.
Algorithm: ADSL.CPBP28FLComputation
'Y' when subject is in the Safety Boost Population (SAFBFL = 'Y') or is in the Safety Population (SAFFL = 'Y') and has completed at least 28 days of follow-up after receiving the prime vaccination (either EOSDT is populated and PRIMDT + 28 is less than EOSDT or PRIMDT + 28 is less than or equal to the data cutoff date of 13AUG2020). 'N', otherwise.
Algorithm: ADSL.DCSREASComputation
Populated when EOSSTT = 'DISCONTINUED'. Set to DS.DSDECOD in proper case, selecting record where DS.DSSCAT = 'END OF TRIAL'.
Algorithm: ADSL.DCSREASPComputation
Populated when EOSSTT = 'DISCONTINUED'. Set to DS.DSTERM in proper case, selecting record where DS.DSSCAT = 'END OF TRIAL'.
Algorithm: ADSL.DTHDTComputation
Date part of DM.DTHDTC as SAS date.
Algorithm: ADSL.EOFUDTComputation
Date part of DS.DSSTDTC as SAS date, selecting record where DS.DSSCAT = 'END OF FOLLOW-UP'.
Algorithm: ADSL.EOSDTComputation
Date part of DS.DSSTDTC as SAS date, selecting record where DS.DSSCAT = 'END OF TRIAL'.
Algorithm: ADSL.EOSSTTComputation
'COMPLETED' when DS.DSDECOD = 'COMPLETED' on record with DS.DSSCAT = 'END OF TRIAL' for given subject. Otherwise, 'DISCONTINUED' when EOSDT is not null.
Algorithm: ADSL.EXIMM1Computation
'Subject did not receive one dose of IMP or did not have one post-baseline immunogenicity assessment' when IMMFL = 'N'.
Algorithm: ADSL.EXPPROT1Computation
'Subject is not included in the immunogenicity set or had major protocol deviation' when PPROTFL = 'N'.
Algorithm: ADSL.EXSAF1Computation
Always null, since no patients are excluded from the safety population (i.e. all have received the prime vaccination) in this data cut.
Algorithm: ADSL.EXSAFB1Computation
'Subject did not receive two doses of IMP' when SAFBFL = 'N'.
Algorithm: ADSL.EXSCR1Computation
Always null, since screen failures not included in this data cut.
Algorithm: ADSL.FIRICDTComputation
Date part of DS.DSSTDTC as SAS date, selecting record where DS.DSDECOD = 'FIRST INFORMED CONSENT OBTAINED'.
Algorithm: ADSL.HEIGHTComputation
VS.VSSTRESN where VS.VSTESTCD = 'HEIGHT' and VS.VSBLFL = 'Y'.
Algorithm: ADSL.ICR1DTMComputation
DS.DSSTDTC as SAS datetime, selecting record(s) where DS.DSDECOD = 'INFORMED CONSENT RECONSENTED'. If multiple records exist for a given subject, the 1st record when sorted by DS.DSSTDTC is selected for populating ICR1DTM.
Algorithm: ADSL.ICR2DTMComputation
DS.DSSTDTC as SAS datetime, selecting records where DS.DSDECOD = 'INFORMED CONSENT RECONSENTED'. The 2nd record when sorted by DS.DSSTDTC is selected for populating ICR2DTM.
Algorithm: ADSL.ICR3DTMComputation
DS.DSSTDTC as SAS datetime, selecting records where DS.DSDECOD = 'INFORMED CONSENT RECONSENTED'. The 3rd record when sorted by DS.DSSTDTC is selected for populating ICR3DTM.
Algorithm: ADSL.IMMFLComputation
'Y' when subject is in the Safety Population (SAFFL = 'Y') and has evaluable post-baseline Neutralizing Titer results (when record exists in IS for given subject with IS.VISITNUM > 2 and non-missing IS.ISORRES for IS.ISTESTCD of 'C2NGNT50' or 'C2NGNT90'). 'N', otherwise.
Algorithm: ADSL.LVDTComputation
When subject has completed the trial (i.e. EOSSTT = ' COMPLETED'), set to date part of DS.DSSTDTC as SAS date, selecting record where DS.DSSCAT = 'END OF TRIAL. When subject discontinued prematurely (i.e. EOSSTT = 'DISCONTINUED'), set to date part of Date of last visit/contact (SUPPDS.QVAL where QNAM = 'LASTCONT') as SAS date.
Algorithm: ADSL.PPROTFLComputation
'Y' when subject is in the Immunogenicity Population (IMMFL = 'Y') and has not had a protocol violation (no record exists in DV for given subject). 'N', otherwise.
Algorithm: ADSL.PRIMDTMComputation
EC.ECSTDTC as SAS datetime, selecting record where EC.ECOCCUR = 'Y' and VISITNUM = 2.
Algorithm: ADSL.PROTVER1Computation
SUPPDS.QNAM where QVAL = 'PROTVERS'. If multiple records exist for a given subject, the 1st record when sorted by DS.DSSTDTC on the associated parent record is selected for populating PROTVER1.
Algorithm: ADSL.PROTVER2Computation
SUPPDS.QNAM where QVAL = 'PROTVERS'. The 2nd record when sorted by DS.DSSTDTC on the associated parent record is selected for populating PROTVER2.
Algorithm: ADSL.PROTVER3Computation
SUPPDS.QNAM where QVAL = 'PROTVERS'. The 3rd record when sorted by DS.DSSTDTC on the associated parent record is selected for populating PROTVER3.
Algorithm: ADSL.PROTVER4Computation
SUPPDS.QNAM where QVAL = 'PROTVERS'. The 4th record when sorted by DS.DSSTDTC on the associated parent record is selected for populating PROTVER4.
Algorithm: ADSL.RFICDTMComputation
DM.RFICDTC as SAS datetime.
Algorithm: ADSL.SAFBFLComputation
'Y' when subject has received boost vaccination (when record exists in EC with EC.ECOCCUR = 'Y' and EC.VISITNUM = 6 for given subject). 'N', otherwise.
Algorithm: ADSL.SAFFLComputation
'Y' when subject has received prime vaccination (when record exists in EC with EC.ECOCCUR = 'Y' and EC.VISITNUM = 2 for given subject). 'N', otherwise.
Algorithm: ADSL.SCRDTComputation
Date part of DM.RFICDTC as SAS date.
Algorithm: ADSL.SCRFLComputation
'Y' when RFICDTM is not missing; 'N', otherwise.
Algorithm: ADSL.SUBJIDNComputation
DM.SUBJID as numeric value.
Algorithm: ADSL.TRT01AComputation
Set to the dosing information provided in DM.ACTARM, updating the unit value from 'ug' to 'µg'. [Ex: '10 µg' when DM.ACTARM = 'BNT162b1 10 ug']
Algorithm: ADSL.TRT01ANComputation
Set to the dose level in TRT01A multiplied by 100. [Ex: 1000 when TRT01A = '10 µg']
Algorithm: ADSL.TRT01PComputation
Set to the dosing information provided in DM.ARM, updating the unit value from 'ug' to 'µg'. [Ex: '10 µg' when DM.ARM = 'BNT162b1 10 ug']
Algorithm: ADSL.TRT01PNComputation
Set to the dose level in TRT01P multiplied by 100. [Ex: 1000 when TRT01P = '10 µg']
Algorithm: ADSL.TRTEDTMComputation
DM.RFXENDTC as SAS datetime.
Algorithm: ADSL.TRTSDTMComputation
DM.RFXSTDTC as SAS datetime.
Algorithm: ADSL.WEIGHTComputation
VS.VSSTRESN where VS.VSTESTCD = 'WEIGHT' and VS.VSBLFL = 'Y'.
Algorithm: ADVA.ABLFLComputation
'Y' for a valid result (AVAL ne .) and last non missing records value before or on the first day of treatment
Algorithm: ADVA.ADTComputation
ADT = date part of IS.ISDTC
Algorithm: ADVA.ADTMComputation
numeric value of IS.ISDTC
Algorithm: ADVA.AGEGR1Computation
Derived as '18 - 55 Yrs' If ADSL.AGE greater than or equal to 18 and ADSL.AGE less than or equal to 55
Algorithm: ADVA.ATMComputation
ATM = time part of IS.ISDTC
Algorithm: ADVA.AVALComputation
if ISSTRESC equal to "BLQ" then set AVAL to 0.5*ISLLOQ; else set to IS.ISSTRESN. For paramn 5,6,7,8; Create new row for post baseline records of paramn 1,2,3,4 with their non-missing aval and base. for paramcd="FRC19RBD" subset if paramn=1 then aval eq aval/base. for paramcd="'FRC19S1I" subset if paramn=2 then aval eq aval/base. for paramcd="FRC2NT50" subset if paramn=3 then aval eq aval/base. for paramcd="FRC2NT90" subset if paramn=4 then aval eq aval/base.
Algorithm: ADVA.AVALCComputation
Derived as character value of AVAL.
Algorithm: ADVA.AVISITComputation
AVISIT=IS.VISIT
Algorithm: ADVA.BASEComputation
ADVA.AVAL from the record with ABLFL="Y" for this USUBJID/PARAM
Algorithm: ADVA.CHGComputation
If AVAL not missing and BASE not missing then CHG=AVAL-BASE. This is calculated only for post-baseline records.
Algorithm: ADVA.CRIT1Computation
Derived as 'Seroconversion' for the post baseline records of ADVA.paramn 1, 2, 3, 4
Algorithm: ADVA.CRIT1FLComputation
Derived for post baseline records of ADVA.paramn (1, 2, 3, 4); CRIT1FL='Y' when aval/base>=4; else CRIT1FL='N'
Algorithm: ADVA.DTYPEComputation
Derived as 'HALF LLOQ' for records IS.ISSTRESC='BLQ'
Algorithm: ADVA.PARAM for COVID-19 recordsComputation
Concatenation of IS.ISTEST and IS.ISSTRESU in parentheses.
Algorithm: ADVA.PCHGComputation
For Post baseline records, if AVAL NOT missing and BASE not missing then set it to ((AVAL-BASE)/BASE)*100
Algorithm: ADVS.ABLFLComputation
[Protocol/SAP] Baseline record for each SUBJID/PERIOD/PARAM as defined in the protocol
Algorithm: ADVS.ADTComputation
ADT = date part of VS.VSDTC
Algorithm: ADVS.ADTMComputation
numeric value of VS.VSDTC
Algorithm: ADVS.ANL01FLComputation
[Protocol/SAP] "Y" for the selected record within each SUBJID/PERIOD/PARAM/AVISIT as determined by the protocol
Algorithm: ADVS.ANL02FLComputation
"Y" when TRTSDT/TRTSTM < ADTM < TRTEDT/TRTETM
Algorithm: ADVS.ANRHIComputation
90 if paramn=2; 100 if paramn=4; 20 if paramn=5 ; 140 if paramn=6 ; 37.5 if paramn=7
Algorithm: ADVS.ANRINDComputation
If non-missing AVAL is greater than ANRHI or less than ANRLO then ANRIND=Abnormal. If ANRLO is missing then only ANRHI is used to determine abnormality. If non-missing AVAL is within ANRLO and ANRHI then ANRIND=Normal.
Algorithm: ADVS.ANRLOComputation
50 if paramn=4 ; 8 if paramn=5 ; 90 if paramn=6 ; 35.5 if paramn=7
Algorithm: ADVS.ASEQComputation
sort the data by USUBJID,PARAMN,AVISITN,ADTM. Assign the sequential numbers starting with 1 for each subject.
Algorithm: ADVS.ATMComputation
ATM = time part of VS.VSDTC
Algorithm: ADVS.ATPTComputation
VS.VSTPT
Algorithm: ADVS.ATPTNComputation
0 if VS.VSTPT= "predose" ; 1 if VS.VSTPT= "1 hour" ; 3 if VS.VSTPT= "3 hours" ; 6 if VS.VSTPT= "6 hours".
Algorithm: ADVS.ATPTREFComputation
VS.VSTPTREF
Algorithm: ADVS.AVALComputation
VS.VSSTRESN
Algorithm: ADVS.AVALCComputation
VS.VSSTRESC
Algorithm: ADVS.AVISITComputation
If VS.VISIT=Visit 0 (Day -30 to 0) then AVISIT= Day -30 to 0 ; If VS.VISIT=Visit 1 (Day 1) then AVISIT= Day 1 ; If VS.VISIT=Visit 2 (Day 2) then AVISIT= Day 2 ; If VS.VISIT=Visit 3 (Day 8) then AVISIT= Day 8 ; If VS.VISIT=Visit 4 / Dosing (Day 22) then AVISIT= Day 22 ; If VS.VISIT=Visit 5 (Day 29) then AVISIT= Day 29 ; If VS.VISIT=Visit 6 (Day 43) then AVISIT= Day 43 ; If VS.VISIT=Visit 7 / EoT Visit (Day 50) then AVISIT= Day 50 ; If VS.VISIT=Visit 8 / FU Visit (Day 85) then AVISIT= Day 85 ; If VS.VISIT=Visit 9 / FU Visit (Day 184) then AVISIT= Day 184 ; If VS.VISIT=Unschduled 1.01 then AVISIT=Unschduled 1 Day -30 to 0 ; If VS.VISIT=Unschduled 2.01 then AVISIT=Unschduled 1 Day 1 ; If VS.VISIT=Unschduled 3.01 then AVISIT=Unschduled 1 Day 2 ; If VS.VISIT=Unschduled 5.01 then AVISIT=Unschduled 1 Day 8 ; If VS.VISIT=Unschduled 6.01 then AVISIT=Unschduled 1 Day 22 ; If VS.VISIT=Unschduled 7.01 then AVISIT=Unschduled 1 Day 29 ; If VS.VISIT=Unschduled 8.01 then AVISIT=Unschduled 1 Day 43 ; If VS.VISIT=Unschduled 9.01 then AVISIT=Unschduled 1 Day 50 ;
Algorithm: ADVS.AVISITNComputation
If VS.VISIT=Visit 0 (Day -30 to 0) then AVISITN= 1; If VS.VISIT=Visit 1 (Day 1) then AVISITN= 2; If VS.VISIT=Visit 2 (Day 2) then AVISITN= 3; If VS.VISIT=Visit 3 (Day 8) then AVISITN= 5; If VS.VISIT=Visit 4 / Dosing (Day 22) then AVISITN= 6; If VS.VISIT=Visit 5 (Day 29) then AVISITN= 7; If VS.VISIT=Visit 6 (Day 43) then AVISITN= 8; If VS.VISIT=Visit 7 / EoT Visit (Day 50) then AVISITN= 9; If VS.VISIT=Visit 8 / FU Visit (Day 85) then AVISITN=10; If VS.VISIT=Visit 9 / FU Visit (Day 184) then AVISITN=11; If VS.VISIT=Unschduled 1.01 then AVISITN= 1.01 ; If VS.VISIT=Unschduled 2.01 then AVISITN=2.01; If VS.VISIT=Unschduled 3.01 then AVISITN=3.01; If VS.VISIT=Unschduled 5.01 then AVISITN= 5.01 ; If VS.VISIT=Unschduled 6.01 then AVISITN= 6.01 ; If VS.VISIT=Unschduled 7.01 then AVISITN= 7.01 ; If VS.VISIT=Unschduled 8.01 then AVISITN= 8.01 ; If VS.VISIT=Unschduled 9.01 then AVISITN= 9.01 ;
Algorithm: ADVS.BASEComputation
ADVS.AVAL, where ADVS.USUBJID=USUBJID and ADVS.APERIOD=APERIOD and ADVS.PARAM=PARAM and ADVS.ABLFL="Y"
Algorithm: ADVS.BASECComputation
ADVS.AVALC, where ADVS.USUBJID=USUBJID and ADVS.APERIOD=APERIOD and ADVS.PARAM=PARAM and ADVS.ABLFL="Y"
Algorithm: ADVS.BNRINDComputation
If non-missing BASE is greater than ANRHI or less than ANRLO then ANRIND=Abnormal. If ANRLO is missing then only ANRHI is used to determine abnormality. If non-missing BASE is within ANRLO and ANRHI then ANRIND=Normal.
Algorithm: ADVS.CHGComputation
CHG = AVAL - BASE
Algorithm: ADVS.NABCSComputation
If abnormality is clinically significant then NABCS='CS Abnormal' ; If abnormality is not clinically significant then NABCS='Abnormal (not CS)' ; if no abnormality then NABCS=Normal ; if there is abnormality and clinically significance information is not present then NABCS=Missing.
Algorithm: ADVS.NABCSNComputation
1 if NABCS = 'Missing'; 2 if NABCS = 'CS Abnormal'; 3 if NABCS = 'Abnormal (not CS); 4 if NABCS = 'Normal’
Algorithm: ADVS.PARAMComputation
VS.VSTEST || VS.VSORRESU
Algorithm: ADVS.PARAMCDComputation
VS.VSTESTCD
Algorithm: ADVS.PARAMNComputation
1 if paramcd='BMI'; 2 if paramcd = 'DIABP'; 3 if paramcd='HEIGHT' ;4 if paramcd='PULSE'; 5 if paramcd='RESP'; 6 if paramcd='SYSBP'; 7 if paramcd='TEMP'; 8 if paramcd='TEMPR'; 9 if paramcd='WEIGHT'
Algorithm: ADVS.PARCAT1Computation
VS.VSCAT
Algorithm: ADVS.PARCAT1NComputation
1 if parcat1='Reactogenicity'
Algorithm: ADVS.PARCAT2Computation
VS.VSSCAT
Algorithm: ADVS.PARCAT2NComputation
1 if parcat2='Systemic'
Algorithm: ADVS.PCHGComputation
PCHG = ((AVAL - BASE)/BASE)*100
Algorithm: ADVS.POBLFLComputation
Y' if ADTM ne . and ADTM>TRTSDTM. if ADTM=. and ADT>TRTSDT then POBLFL="Y";
Algorithm: ADVS.SRCDOMComputation
VS.DOMAIN
Algorithm: ADVS.SRCSEQComputation
VS.VSSEQ
Algorithm: ADVS.UNSVFLComputation
Y' if index(AVISIT,'Unscheduled') > 0
Algorithm: ADVS.VSCLSIGNComputation
1 if VSCLSIG='Y'; 0 if VSCLSIG='N', missing otherwise
Algorithm: ADYComputation
Analysis date relative to treatment start: ADT - TRTSDT + 1, when ADT is on or after TRTSDT; ADT - TRTSDT, when ADT is before TRTSDT.
Algorithm: AENDYComputation
Analysis end date relative to treatment start: AENDT - TRTSDT + 1, when AENDT is on or after TRTSDT; AENDT - TRTSDT, when AENDT is before TRTSDT.
Algorithm: ASTDYComputation
Analysis start date relative to treatment start: ASTDT - TRTSDT + 1, when ASTDT is on or after TRTSDT; ASTDT - TRTSDT, when ASTDT is before TRTSDT.
Algorithm: -DTComputation
Date part of corresponding -DTM variable.
Algorithm: -TMComputation
Time part of corresponding -DTM variable.

Go to the top of the Define-XML document