ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
This spreadsheet is intended to function as a data dictionary providing metadata for tables contained in the All of Us Research Program Raw Data Repository (RDR). The data dictionary documents all available fields and details tables, fields, and values available in the RDR (with some values supressed to protect PPI). A brief description of each tab is given below.
Note that this data dictionary is still a work in progress.
3
4
5
6
7
8
9
18
19
20
Change LogDetails any changes made to the RDR Data Dictionary tab.
21
RDR Data DictionaryDetails all tables and fields (columns), including their data type, a brief description, their unique values, the meaning of their values (e.g., UNSET = 0), as well as any relevant key.
22
RDR Internal OnlyContains tables/fields marked as RDR Internal are for internal RDR team's use only - not to be used for analytics. This tab may contain fewer Descriptions since it is for RDR Internal use only.
23
Key_QuestionnaireDetails questionnaire_id, display value, and short value for questionnaire related tables and fields. See RDR Data Dictionary column Key for which fields this applies to.
24
Key_SiteDetails site_id, site_name, and google_group for all sites for which we have data in the RDR. See RDR Data Dictionary column Key for which fields this applies to.
25
Key_HPODetails hpo_id, name, and display_name for all HPOs for which we have data in the RDR. See RDR Data Dictionary column Key for which fields this applies to.
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108