ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
FOCUS 1.3 Data Model
2
Last Updated: 2025/11/18This spreadsheet describes every column described in the data model of FOCUS 1.3.
For more information, please visit the FOCUS website and/or the FOCUS GitHub repository.
3
4
ColumnDescription
5
VersionThe FOCUS version in which this column was introduced.
6
DatasetThe dataset of the column.
7
Display NameThe English-readable name of the column.
8
Column IDThe identifier of the column (essentially the display name with spaces removed and casing applied).
9
CategoryThe subject area of the column (typically used for describing FOCUS, not for practitioner analysis).
10
SpecificationA link to the working_draft branch of the FOCUS GitHub repo that defines the column.
11
RequirementsA link to the working_draft branch of the FOCUS GitHub repo that defines the normative requirements that the column shall fulfill.
12
Column TypeDenotes whether the column describes a Metric (i.e., numeric value), Dimension (i.e., string or date that describes a Metric), or both (i.e., JSON Object column that contains both metrics and dimensions).
13
Feature LevelDenotes whether the column is Mandatory (i.e., must be included in the dataset), Conditional (i.e., must be included under certain conditions), or Recommended (i.e., should be included, but not strictly necessary).
14
ConditionDenotes the condition by which the column must/should be included in the dataset.
15
DeprecatedDenotes whether the column has been deprecated in the spec (two such columns in FOCUS 1.3).
16
Allows NullsDenotes whether the column has been removed from the spec (no such columns in FOCUS 1.3).
17
Data TypeDenotes the logical data type (i.e., String, Decimal, Date/Time, or JSON).
18
Value FormatDenotes the format of the values contained in the column.
19
Allowed ValuesFor relevant columns, denotes the full list of values allowed to be used.
20
DescriptionA long-form description of the column.
21
22
23
24
25
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