ROWORDER | VARIABLE_NAME | VARIABLE_LABEL | TYPE | GENERAL_COMMENT |
---|---|---|---|---|
001 | STUDYID | Study Identifier | IS.STUDYID | |
002 | USUBJID | Unique Subject Identifier | IS.USUBJID | |
003 | ISSEQ | Sequence Number | IS.ISSEQ | |
004 | ADT | Analysis Date | Populate using IS.ISDTC | |
005 | ADY | Analysis Relative Day | Populate using ADSL.TRTSDT and ADIS.ADT. If ADT is on or after treatment start date then populate as the difference between ADT and TRTSDT and add one to the difference. Else if ADT is before TRTSDT then populate as the difference between ADT and TRTSDT. | |
006 | VISITNUM | Visit Number | IS.VISITNUM | |
007 | VISIT | Visit Name | IS.VISIT | |
008 | AVISIT | Analysis Visit | Part 1: Populate as 'Screening' when ADY <=-1. Populate as 'Visit 1' when 1<= ADY <=1. Populate as 'Visit 2' when 7<= ADY <=9. Populate as 'Visit 3' when 25<= ADY <=33. Populate as 'Visit 4' when 78<= ADY <=92. Populate as 'Visit 5' when 166<= ADY <=194. Populate as 'Visit 6' when 351<= ADY <=379. Part 2: Populate as 'Baseline' on the record where ABLFL is 'Y'. |
|
009 | AVISITN | Analysis Visit (N) | Part 1: Populate as -1 when AVISIT='Screening'. Populate as 1 when AVISIT='Visit 1'. Populate as 2 when AVISIT='Visit 2'. Populate as 3 when AVISIT='Visit 3'. Populate as 4 when AVISIT='Visit 4'. Populate as 5 when AVISIT='Visit 5'. Populate as 6 when AVISIT='Visit 6'. Part 2: Populate as 0 on the record where ABLFL is 'Y'. |
|
010 | PARAM | Parameter | Populate as 'Titer (GCE/ml)' when PARAMCD='TITER'. |
|
011 | PARAMCD | Parameter Code | For the source records: set to ISTESTCD |
|
012 | PARAMN | Parameter (N) | Populate as 1 when PARAMCD='TITER'. |
|
013 | AVAL | Analysis Value | A. For the source records: Set to ISSTRESN |
|
014 | BASE | Baseline Value | Populate using ADIS.AVAL on the record where ADIS.ABLFL="Y" of each parameter and subject on all records that subject and parameter. | |
015 | CHG | Change from Baseline | Populate as the difference between ADIS.AVAL and ADIS.BASE on postbaseline records (ADIS.ANL02FL="Y"). | |
016 | R2BASE | Ratio to Baseline | On postbaseline records (ANL02FL="Y") where PARAMCD="TITER": Populate with the ratio of AVAL to BASE (AVAL/BASE). Round the ratio to two decimal places. |
|
017 | CRIT1 | Analysis Criterion 1 | Populate as "Seroresponse - Titer >=200" on records where PARAMCD="TITER". | |
018 | CRIT1FL | Criterion 1 Evaluation Result Flag | On records where PARAMCD="TITER": Populate as "Y" when AVAL>=200. Else if AVAL is not null, then populate as "N". |
|
019 | CRIT2 | Analysis Criterion 2 | Populate as "Seroconversion - > 4 fold increase from baseline" on records where PARAMCD="TITER". | |
020 | CRIT2FL | Criterion 2 Evaluation Result Flag | On postbaseline records (ANL02FL="Y") where PARAMCD="TITER": Populate as "Y" when R2BASE > 4. Else if R2BASE is not null then populate as "N". |
|
021 | AWTARGET | Analysis Window Target | Populate as null when AVISIT='Screening'. Populate as 1 when AVISIT='Visit 1'. Populate as 8 when AVISIT='Visit 2'. Populate as 29 when AVISIT='Visit 3'. Populate as 85 when AVISIT='Visit 4'. Populate as 180 when AVISIT='Visit 5'. Populate as 365 when AVISIT='Visit 6'. |
|
022 | AWTDIFF | Analysis Window Diff from Target | Populate as the absolute difference between AWTARGET and ADY | |
023 | AWLO | Analysis Window Beginning Timepoint | Populate as null when AVISIT='Screening'. Populate as 1 when AVISIT='Visit 1'. Populate as 7 when AVISIT='Visit 2'. Populate as 25 when AVISIT='Visit 3'. Populate as 78 when AVISIT='Visit 4'. Populate as 166 when AVISIT='Visit 5'. Populate as 351 when AVISIT='Visit 6'. |
|
024 | AWHI | Analysis Window Ending Timepoint | Populate as -1 when AVISIT='Screening'. Populate as 1 when AVISIT='Visit 1'. Populate as 9 when AVISIT='Visit 2'. Populate as 33 when AVISIT='Visit 3'. Populate as 92 when AVISIT='Visit 4'. Populate as 194 when AVISIT='Visit 5'. Populate as 379 when AVISIT='Visit 6'. |
|
025 | AWU | Analysis Window Unit | Populate as "DAYS" when AVISIT is not null. | |
026 | ABLFL | Baseline Record Flag | Populate as "Y" on the latest record with non-missing result on or prior to treatment start date (ADSL.TRTSDT) for each subject and parameter. | |
027 | ANL01FL | Analysis Flag 01 | Populate as "Y" on the records which is closet to the target day within each analysis visit (ADIS.AVISIT) per subject and parameter. If there exists multiple records which are equally close to the target day, choose the latest record. | |
028 | ANL02FL | Analysis Flag 02 | Populate as "Y" on postbaseline records (ADIS.ADT>ADSL.TRTSDT). |