Keysets

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