_ALL¶
Table Description: _ALL
2.0 Data Dictionary¶
Table Constraints: PATNO
, VISIT_ID
ITM_NAME |
DSCR |
ITM_TYPE |
DSCR_1.0 |
ITM_TYPE_1.0 |
---|---|---|---|---|
REC_ID |
Record ID |
UUID |
Record ID |
NUMBER |
CNO |
Site Number |
NUMBER |
Center Number |
CHAR |
PATNO |
Participant ID |
NUMBER |
Patient Number |
CHAR |
EVENT_ID |
Visit ID |
TEXT |
Event Name |
CHAR |
INFODT |
Assessment Date |
DATE |
Event Date |
DATE |
PAG_NAME |
Page Name |
TEXT |
Page Name |
CHAR |
ORIG_ENTRY |
Date of original data entry |
DATE |
Date of original data entry |
DATE |
LAST_UPDATE |
Date of most recent update to record |
DATE |
Date of most recent update to record |
DATE |
QUERY |
Any open/pending queries on this record |
BOOLEAN |
Any open/pending queries on this record |
NUMBER |
2.0 Code Book¶
ITM_NAME |
CODE |
DECODE_2.0 |
DECODE_1.0 |
---|---|---|---|
EVENT_ID |
0 |
Not Completed |
|
EVENT_ID |
AV1 |
Unscheduled Telephone AV-133 |
|
EVENT_ID |
AV133 |
AV-133 |
|
EVENT_ID |
AV133TC |
AV-133 Telephone Follow up |
|
EVENT_ID |
AV2 |
Unscheduled Telephone AV-133 |
|
EVENT_ID |
AV3 |
Unscheduled Telephone AV-133 |
|
EVENT_ID |
AV4 |
Unscheduled Telephone AV-133 |
|
EVENT_ID |
BL |
Baseline |
Baseline |
EVENT_ID |
CONSENT |
Consent |
|
EVENT_ID |
CTCCONLY |
CTCCONLY |
|
EVENT_ID |
FLORBET |
Florbetaben Imaging |
|
EVENT_ID |
FLORBETC |
Florbetaben Telephone Call |
|
EVENT_ID |
FNL |
Final Visit |
|
EVENT_ID |
GMU |
Genetic Testing |
|
EVENT_ID |
LOG |
Logs |
|
EVENT_ID |
P102 |
Phone Visit (Month 102) |
|
EVENT_ID |
P114 |
Phone Visit (Month 114) |
|
EVENT_ID |
P126 |
Phone Visit (Month 126) |
|
EVENT_ID |
P138 |
Phone Visit (Month 138) |
|
EVENT_ID |
P150 |
Phone Visit (Month 150) |
|
EVENT_ID |
P78 |
Phone Visit (Month 78) |
|
EVENT_ID |
P90 |
Phone Visit (Month 90) |
|
EVENT_ID |
PW |
Premature Withdrawal |
|
EVENT_ID |
R01 |
Remote Visit 01 (Month 6) |
|
EVENT_ID |
R04 |
Remote Visit 04 (Month 18) |
|
EVENT_ID |
R06 |
Remote Visit 06 (Month 30) |
|
EVENT_ID |
R08 |
Remote Visit 08 (Month 42) |
|
EVENT_ID |
R10 |
Remote Visit 10 (Month 54) |
|
EVENT_ID |
R12 |
Remote Visit 12 (Month 66) |
|
EVENT_ID |
R13 |
Remote Visit 13 (Month 78) |
|
EVENT_ID |
R14 |
Remote Visit 14 (Month 90) |
|
EVENT_ID |
R15 |
Remote Visit 15 (Month 102) |
|
EVENT_ID |
R16 |
Remote Visit 16 (Month 114) |
|
EVENT_ID |
R17 |
Remote Visit 17 (Month 126) |
|
EVENT_ID |
R18 |
Remote Visit 18 (Month 138) |
|
EVENT_ID |
R19 |
Remote Visit 19 (Month 150) |
|
EVENT_ID |
RANDOM |
Randomize |
|
EVENT_ID |
RS1 |
Re-Screen |
|
EVENT_ID |
SC |
Screening |
Screening Visit |
EVENT_ID |
SCBL |
Screening/Baseline Combined |
|
EVENT_ID |
SKINBIO |
Skin Biopsy |
|
EVENT_ID |
SKINBITC |
Skin Biopsy Telephone Call |
|
EVENT_ID |
ST |
Symptomatic Therapy |
|
EVENT_ID |
STC |
Symptomatic Therapy Telephone Call |
|
EVENT_ID |
T06 |
Telephone Contact (Month 6) |
|
EVENT_ID |
T108 |
Telephone Contact |
|
EVENT_ID |
T12 |
Telephone Contact (Month 12) |
|
EVENT_ID |
T132 |
Telephone Contact |
|
EVENT_ID |
T15 |
Telephone Contact (Month 15) |
|
EVENT_ID |
T156 |
Telephone Contact |
|
EVENT_ID |
T17 |
Telephone Contact |
|
EVENT_ID |
T18 |
Telephone Contact (Month 18) |
|
EVENT_ID |
T19 |
Telephone Contact |
|
EVENT_ID |
T21 |
Telephone Contact (Month 21) |
|
EVENT_ID |
T24 |
Telephone Contact (Month 24) |
|
EVENT_ID |
T27 |
Telephone Contact (Month 27) |
|
EVENT_ID |
T30 |
Telephone Contact (Month 30) |
|
EVENT_ID |
T33 |
Telephone Contact (Month 33) |
|
EVENT_ID |
T36 |
Telephone Contact (Month 36) |
|
EVENT_ID |
T39 |
Telephone Contact (Month 39) |
|
EVENT_ID |
T42 |
Telephone Contact (Month 42) |
|
EVENT_ID |
T45 |
Telephone Contact (Month 45) |
|
EVENT_ID |
T48 |
Telephone Contact (Month 48) |
|
EVENT_ID |
T51 |
Telephone Contact (Month 51) |
|
EVENT_ID |
T54 |
Telephone Contact (Month 54) |
|
EVENT_ID |
T57 |
Telephone Contact (Month 57) |
|
EVENT_ID |
T60 |
Telephone Contact (Month 60) |
|
EVENT_ID |
T72 |
Telephone Contact (Month 72) |
|
EVENT_ID |
T84 |
Telephone Contact |
|
EVENT_ID |
T96 |
Telephone Contact (Month 96) |
|
EVENT_ID |
TAPFNL |
TAP Final |
|
EVENT_ID |
TBL |
Telephone Contact (BL) |
|
EVENT_ID |
TDB |
Digital Biomarker Telephone Followup |
|
EVENT_ID |
TSC |
Telephone Contact (SC) |
|
EVENT_ID |
U01 |
Unscheduled Visit 01 |
|
EVENT_ID |
U02 |
Unscheduled Visit 02 |
|
EVENT_ID |
U03 |
Unscheduled Visit 03 |
|
EVENT_ID |
U04 |
Unscheduled Visit 04 |
|
EVENT_ID |
U05 |
Unscheduled Visit 05 |
|
EVENT_ID |
U06 |
Unscheduled Visit 06 |
|
EVENT_ID |
UP1 |
Unscheduled Telephone Contact |
|
EVENT_ID |
UP2 |
Unscheduled Telephone Contact |
|
EVENT_ID |
UP3 |
Unscheduled Telephone Contact |
|
EVENT_ID |
UT1 |
Unscheduled T1 DATSCAN F/U |
|
EVENT_ID |
UT2 |
Unscheduled T2 DATSCAN F/U |
|
EVENT_ID |
V01 |
Visit 01 (Month 3) |
Visit 01 (Month 3) |
EVENT_ID |
V02 |
Visit 02 (Month 6) |
Visit 02 (Month 6) |
EVENT_ID |
V03 |
Visit 03 (Month 9) |
Visit 03 (Month 9) |
EVENT_ID |
V04 |
Visit 04 (Month 12) |
Visit 04 (Month 12) |
EVENT_ID |
V05 |
Visit 05 (Month 18) |
Visit 05 (Month 18) |
EVENT_ID |
V06 |
Visit 06 (Month 24) |
Visit 06 (Month 24) |
EVENT_ID |
V07 |
Visit 07 (Month 30) |
Visit 07 (Month 30) |
EVENT_ID |
V08 |
Visit 08 (Month 36) |
Visit 08 (Month 36) |
EVENT_ID |
V09 |
Visit 09 (Month 42) |
Visit 09 (Month 42) |
EVENT_ID |
V10 |
Visit 10 (Month 48) |
Visit 10 (Month 48) |
EVENT_ID |
V11 |
Visit 11 (Month 54) |
Visit 11 (Month 54) |
EVENT_ID |
V12 |
Visit 12 (Month 60) |
Visit 12 (Month 60) |
EVENT_ID |
V13 |
Visit 13 (Month 72) |
Visit 13 (Month 72) |
EVENT_ID |
V14 |
Visit 14 (Month 84) |
Visit 14 (Month 84) |
EVENT_ID |
V15 |
Visit 15 (Month 96) |
Visit 15 (Month 96) |
EVENT_ID |
V16 |
Visit 16 (Month 108) |
Visit 16 (Month 108) |
EVENT_ID |
V17 |
Visit 17 (Month 120) |
Visit 17 (Month 120) |
EVENT_ID |
V18 |
Visit 18 (Month 132) |
Visit 18 (Month 132) |
EVENT_ID |
V19 |
Visit 19 (Month 144) |
Visit 19 (Month 144) |
EVENT_ID |
V20 |
Visit 20 (Month 156) |
Visit 20 (Month 156) |
EVENT_ID |
X01 |
Transfer Event |
|
EVENT_ID |
X02 |
Transfer Event |
|
EVENT_ID |
X03 |
Transfer Event |
|
QUERY |
0 |
No |
|
QUERY |
1 |
Yes |
Missing Columns¶
ITM_NAME |
DSCR_1.0 |
---|---|
F_STATUS |
Data status: Verified, Secured or Locked |
SITE_APRV |
Date site approved the data |