Compustat items can be qualified by a set of secondary keys. This collection of secondary keys and values create a keyset that assigns a numeric code and mnemonic tag to each unique collection. Each keyset represents different output series. When multiple keysets are available for a particular data item, users can specify both the item and keyset to identify the series of interest or simply use the default preset combination that is most commonly used.
For example, the data item SALE has secondary keys for industry format, data format, population source, and consolidation level. A different value of company sales may be available for any combination of these keys. One keyset may represent originally reported sales. Another may represent the final restated sales from a later filing.
Keyset
Tag
Keyset Components
Keyset Description
All Keysets use a Domestic POPSRC and use some form of standardized data in their DATAFMT presentation
0
Null Keyset, no variations using secondary keys
Indexes
1
STD
DATAFMT = STD INDFMT = INDL CONSOL = C POPSRC = D
Industrial Format, Consolidated Information, Standardized Presentation
2
SUMM
DATAFMT = SUMM_STD INDFMT = INDL CONSOL = C POPSRC = D
Industrial Format, Consolidated Information, Standardized Summary Data from the Latest Annual Filing
3
PRES
DATAFMT = PRE_AMENDSS INDFMT = INDL CONSOL = C POPSRC = D
Industrial Format, Consolidated Information, Standardized Summary Data Collected prior to Company Amendment
4
FS
DATAFMT = STD INDFMT = FS CONSOL = C POPSRC = D
Financial Services Format, Consolidated Information, Standardized Presentation
5
PFO
DATAFMT = STD INDFMT = INDL CONSOL = R POPSRC = D
Industrial Format, Pro Forma Reporting, Standardized Presentation
6
PFAS
CONSOL = P POPSRC = D
Pre FASB Reporting
7
SFAS
DATAFMT = STD INDFMT = INDL CONSOL = P POPSRC = D
Industrial Format, Pre-FASB Reporting, Standardized Presentation
8
PRE
DATAFMT = PRE_AMENDS INDFMT = INDL CONSOL = C POPSRC = D
Industrial Format, Consolidated Information, Standardized Data Collected from the Latest Annual Filing
9
CONSOL=C DATAFMT=STD INDFMT=BANK POPSRC=D
Bank Format, Consolidated Information, Standardized Presentation, Rank 1
10
PDIV
DATAFMT = STD INDFMT = INDL CONSOL = D POPSRC = D
Industrial Format, Pre-Divestiture Reporting, Standardized Presentation
11
DOM
POPSRC = D
Domestic
12
SUPF
DATAFMT = SUMM_STD INDFMT = INDL CONSOL = P POPSRC = D
Industrial Format, Pre-FASB Reporting, Standardized Summary Data from the Latest Annual Filing
14
STD1
DATAFMT = STD INDFMT = INDL CONSOL = C POPSRC = D RANK = 1
Industrial Format, Consolidated Information, Standardized Presentation, Rank 1
15
FSFO
DATAFMT = STD INDFMT = FS CONSOL = R POPSRC = D
Financial Services Format, Pro-Forma Reporting, Standardized Presentation
16
FS1
DATAFMT = STD INDFMT = FS CONSOL = C POPSRC = D RANK = 1
Financial Services Format, Consolidated Information, Standardized Presentation, Rank 1
17
FS2
DATAFMT = STD INDFMT = FS CONSOL = C POPSRC = D RANK = 2
Financial Services Format, Consolidated Information, Standardized Presentation, Rank 2
18
SUFS
DATAFMT = SUMM_STD INDFMT = INDL CONSOL = R POPSRC = D
Industrial Format, Pro-Forma Reporting, Standardized Summary Data from the Latest Annual Filing
19
PDI1
DATAFMT = STD INDFMT = INDL CONSOL = D POPSRC = D RANK = 1
Industrial Format, Pre-Divestiture Reporting, Standardized Presentation, Rank 1
20
PFA1
DATAFMT = STD INDFMT = INDL CONSOL = P POPSRC = D RANK = 1
Industrial Format, Pre-FASB Reporting, Standardized Presentation, Rank 1
21
SUPD
DATAFMT = SUMM_STD INDFMT = INDL CONSOL = D POPSRC = D
Industrial Format, Pre-Divestiture Reporting, Standardized Summary Data from the Latest Annual Filing
22
FS3
DATAFMT = STD INDFMT = FS CONSOL = C POPSRC = D RANK = 3
Financial Services Format, Consolidated Information, Standardized Presentation, Rank 3
23
PDI2
DATAFMT = STD INDFMT = INDL CONSOL = D POPSRC = D RANK = 2
Industrial Format, Consolidated Information, Standardized Presentation, Rank 2
24
CONS
CONSOL = C POPSRC = D
Consolidated Information
25
STD2
DATAFMT = STD INDFMT = INDL CONSOL = C POPSRC = D RANK = 2
Industrial Format, Consolidated Information, Standardized Presentation, Rank 2
26
STD3
DATAFMT = STD INDFMT = INDL CONSOL = C POPSRC = D RANK = 3
Industrial Format, Consolidated Information, Standardized Presentation, Rank 3
27
STD4
DATAFMT = STD INDFMT = INDL CONSOL = C POPSRC = D RANK = 4
Industrial Format, Consolidated Information, Standardized Presentation, Rank 4
28
STD5
DATAFMT = STD INDFMT = INDL CONSOL = C POPSRC = D RANK = 5
Industrial Format, Consolidated Information, Standardized Presentation, Rank 5
29
PFA2
DATAFMT = STD INDFMT = INDL CONSOL = P POPSRC = D RANK = 2
Industrial Format, Pre-FASB Reporting, Standardized Presentation, Rank 2
30
PFA3
DATAFMT = STD INDFMT = INDL CONSOL = P POPSRC = D RANK = 3
Industrial Format, Pre-FASB Reporting, Standardized Presentation, Rank 3
31
CUSD
CFFLAG = C POPSRC = D MKT_CURCD = USD
Calendar Based Reporting in US Dollars
32
FUSD
CFFLAG = F POPSRC = D MKT_CURCD = USD
Fiscal Based Reporting in US Dollars
33
CCAD
CFFLAG = C POPSRC = D MKT_CURCD = CAD
Calendar Based Reporting in Canadian Dollars
34
FCAD
CFFLAG = F POPSRC = D MKT_CURCD = CAD
Fiscal Based Reporting in Canadian Dollars
35
PFA4
DATAFMT = STD INDFMT = INDL CONSOL = P POPSRC = D RANK = 4
Industrial Format, Pre-FASB Reporting, Standardized Presentation, Rank 4
36
PFO2
DATAFMT = STD INDFMT = INDL CONSOL = R POPSRC = D RANK = 2
Industrial Format, Pro-Forma Reporting, Standardized Presentation, Rank 2
37
PFO1
DATAFMT = STD INDFMT = INDL CONSOL = R POPSRC = D RANK = 1
Industrial Format, Pro-Forma Reporting, Standardized Presentation, Rank 1
38
PRE1
DATAFMT = PRE_AMENDS INDFMT = INDL CONSOL = C POPSRC = D RANK = 1
Industrial Format, Consolidated Information, Standardized Data Collected before Company Amendment, Rank 1
39
FFO1
DATAFMT = STD INDFMT = FS CONSOL = R POPSRC = D RANK = 1
Financial Services Format, Pro-Forma Reporting, Standardized Presentation, Rank 1
40
FS4
DATAFMT = STD INDFMT = FS CONSOL = C RANK = 4
Financial Services Format, Consolidated Information, Standardized Presentation, Rank 4
41
GICS
INDTYPE = GICS
Industry Code Type GICS
42
CONSOL=C DATAFMT=AVG_STD INDFMT=BANK POPSRC=D
Bank Format, Consolidated Information, Average Standardized Presentation, Rank 1
43
FORD
CONSOL = R POPSRC = D
Pro-Forma Reporting
44
BSTD
DATAFMT = STD INDFMT = BANK CONSOL = C POPSRC = D
Bank Format, Consolidated Information, Standardized Presentation
45
BSUMM
DATAFMT = SUMM_STD INDFMT = BANK CONSOL = C POPSRC = D
Bank Format, Consolidated Information, Standardized Summary Data from the Latest Annual Filing
46
BPFO
DATAFMT = STD INDFMT = BANK CONSOL = R POPSRC = D
Bank Format, Pro-Forma Reporting, Standard Presentation
47
BASTD
DATAFMT = AVG_STD INDFMT = BANK CONSOL = C POPSRC = D
Bank Format, Consolidated Information, Average Standardized Presentation
48
BASUMM
DATAFMT = AVG_SUMM_STD INDFMT = BANK CONSOL = C POPSRC = D
Bank Format, Consolidated Information, Average Standardized Summary Presentation from the Latest Annual Filing
49
BAPFO
DATAFMT = AVG_STD INDFMT = BANK CONSOL = R POPSRC = D
Bank Format, Pro-Forma Reporting, Average Standardized Presentation
2100
BSTD
DATAFMT = STD INDFMT = INDL POPSRC = D CONSOL = C
Bank Format, Consolidated Information, Standardized Presentation
2101
BSUMM
DATAFMT = STD INDFMT = INDL POPSRC = D CONSOL = C
Bank Format, Consolidated Information, Standardized Summary Data from the Latest Annual Filing
2102
BSTD1
DATAFMT = STD INDFMT = INDL POPSRC = D CONSOL = C
Bank Format, Consolidated Information, Standardized Presentation, Rank 1
2103
BSTD2
DATAFMT = STD INDFMT = INDL POPSRC = D CONSOL = C
Bank Format, Consolidated Information, Standardized Presentation, Rank 2
2120
BASTD
DATAFMT = STD INDFMT = INDL POPSRC = D CONSOL = C
Bank Format, Consolidated Information, Average Standardized Presentation
2121
BASUMM
DATAFMT = STD INDFMT = INDL POPSRC = D CONSOL = C
Bank Format, Consolidated Information, Average Standardized Summary Presentation from the Latest Annual Filing
2122
BASTD1
DATAFMT = STD INDFMT = INDL POPSRC = D CONSOL = C
Bank Format, Consolidated Information, Average Standardized Presentation, Rank 1
2123
BASTD2
DATAFMT = STD INDFMT = INDL POPSRC = D CONSOL = C
Bank Format, Consolidated Information, Average Standardized Presentation, Rank 2
2140
BPFO
DATAFMT = STD INDFMT = INDL POPSRC = D CONSOL = C
Bank Format, Pro-Forma Reporting, Standard Presentation
2160
BAPFO
DATAFMT = STD INDFMT = INDL POPSRC = D CONSOL = C
Bank Format, Pro-Forma Reporting, Average Standardized Presentation
Compustat items can be qualified by a set of secondary keys. This collection of secondary keys and values create a keyset that assigns a numeric code and mnemonic tag to each unique collection. Each keyset represents different output series. When multiple keysets are available for a particular data item, users can specify both the item and keyset to identify the series of interest or simply use the default preset combination that is most commonly used.
For example, the data item SALE has secondary keys for industry format, data format, population source, and consolidation level. A different value of company sales may be available for any combination of these keys. One keyset may represent originally reported sales. Another may represent the final restated sales from a later filing.
All Keysets use a Domestic POPSRC and use some form of standardized data in their DATAFMT presentation