_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  |