Introduction View
DJI Mapping File View
File Formats View
Appendix A: Country/Region Codes Table View
Appendix B: Sector and Industry Group Definitions View
Sector and Industry Group Definitions View
Guide to Industry Group Codes: Alphabetical by Group Name View
Guide to Industry Group Codes: Alphabetical by Code View
Alphabetical Guide to Sector and Industry Codes View
Table 1: Universe Mapping File Layout View
Table 2: Country/Region Code Identifiers View
Table 3: Guide to Industry Group Names View
Table 4: Guide to Industry Group Codes Sample View
Table 5: Alphabetical Guide to Sector and Industry Codes View
|
Date |
Author |
Rev. Level |
Changes |
|
08/20/01 |
M.Jassmann |
4.0 |
Original Specification |
This document describes the Dow Jones Indexes (DJI) universe mapping file. The mapping file provides a correlation between the DJI market sector/industry group codes and all the components that Dow Jones Indexes considers potential DJI components.
DJI mapping file is a tab separated text file.
DJI data file naming convention is as follows:
The first two characters indicate the type of data contained in the file:
un -- file contains all components tracked by Dow Jones Indexes.
us -- file contains all U.S. components tracked by Dow Jones Indexes.
The next three characters indicate whether or not the CUSIP field is populated:
_n_ -- file does not contain CUSIP.
_a_ -- file does contain CUSIP.
The remaining characters represent the file relevance date in the date format: MMDD.
The file name date stamp represents the last effective trading date, i.e.,
if the file is generated past midnight, it will retain the previous day's date.
DJI mapping file is a tab delimited text file that contains a collection of
data records delimited by "CRLF". This structure allows easy parsing
and provides a simple way to import data into a spreadsheet or database.
Records in the DJI data files are a contiguous collection of variable length
fields. The fields are delimited by a tab. Each record is related to a
particular component.
Fields in the DJI data files are ASCII representations for numeric,
character (alphanumeric), date, and text data. A zero length field will be used
if a particular field's data is not applicable in the record.
Character (alphanumeric) fields are not case sensitive. The character field may include digits and spaces.
This section provides the file format for the DJI mapping file.
This file contains internal identifiers, external identifiers, country data, component name and market sector/industry group codes. The file name is "un_a_[MMDD].txt".
|
Field Name |
Type |
Max Width |
|
instr_id |
Char. |
12 |
|
pre_max |
Char. |
2 |
|
root_max |
Char. |
12 |
|
sedol |
Char. |
12 |
|
cusip |
Char. |
12 |
|
isin |
Char. |
15 |
|
country |
Char. |
20 |
|
cntry_code |
Char. |
2 |
|
name |
Char. |
100 |
|
economic sector |
Char. |
3 |
|
market sector |
Char. |
3 |
|
indgrp |
Char. |
3 |
|
subgrp |
Char. |
3 |
instr_id - Unique internal Dow Jones Indexes Identifier for each component.
pre_max - An internal exchange identifier code.
root_max - An internal ticker symbol.
sedol - The Stock Exchange Daily Official List identification code.
cusip - The Committee on Uniform Securities Identification Procedures identification code.
country - The proper name of the country from which the component has been taken.
cntry_code - A two letter internal country identifier. The first letter gives the region and the second letter usually corresponds to the first letter of the country, e.g.: United States = AA and Japan = PJ. A list of these identifiers is in Appendix A.
name - The component company name.
economic sector - A 3-letter economic sector code.
market sector - A 3-letter market sector code.
indgrp - The industry group.
subgrp - The sub-industry group.
Table 2: Country/Region Code Identifiers
|
Country |
CNTRY_CODE |
|
USA |
AA |
|
BRAZIL |
AB |
|
CANADA |
AC |
|
MEXICO |
AM |
|
CHILE |
AS |
|
VENEZUELA |
AV |
|
AUSTRIA |
EA |
|
GREAT BRITAIN |
EB |
|
DENMARK |
ED |
|
SPAIN |
EE |
|
FRANCE |
EF |
|
GERMANY |
EG |
|
NETHERLANDS |
EH |
|
ITALY |
EI |
|
SOUTH AFRICA |
EJ |
|
NORWAY |
EK |
|
PORTUGAL |
EL |
|
BELGIUM |
EM |
|
FINLAND |
EO |
|
IRELAND |
EP |
|
GREECE |
ER |
|
SWEDEN |
ES |
|
SWITZERLAND |
EY |
|
AUSTRALIA |
PA |
|
THAILAND |
PB |
|
HONG KONG |
PH |
|
INDONESIA |
PI |
|
JAPAN |
PJ |
|
SOUTH KOREA |
PK |
|
MALAYSIA |
PM |
|
PHILIPPINES |
PP |
|
SINGAPORE |
PS |
|
TAIWAN |
PT |
|
NEW ZEALAND |
PZ |
|
AMERICAS |
A1 |
|
LATIN AMERICA |
A3 |
|
LATIN AMERICA (Excluding: Mexico) |
A4 |
|
EUROPE/AFRICA |
E0 |
|
EUROPE/AFRICA (Excluding: S.A.) |
E1 |
|
EUROPE/AFRICA (Excluding: U.K. & S.A.) |
E2 |
|
EUROPE (NORDIC) |
E3 |
|
PACIFIC REGION |
P1 |
|
PACIFIC (Excluding: JAPAN) |
P2 |
|
PACIFIC (SOUTH ASIA) |
P3 |
|
WORLD |
W1 |
|
WORLD (Excluding: U.S.) |
W2 |
The securities comprising the Dow Jones Global Indexes are categorized into nine economic sectors. These sectors are divided into industry groups. Some industry groups are further subdivided into one or two levels of subgroups. Sector and industry group/sub-group titles, codes, and definitions are provided here.
Table
3: Alphabetical by Group Code
|
Group Code |
Group Name |
|
ADV |
Advertising |
|
AIF |
Air Freight |
|
AIR |
Airlines |
|
ALU |
Aluminum |
|
ARO |
Aerospace |
|
ATO |
Automobiles |
|
AUP |
Auto Parts |
|
AUT |
Automobile |
|
BAK |
Banks |
|
BAS |
Basic Resources |
|
BLD |
Building Materials |
|
BNK |
Banks |
|
BRD |
Broadcasting |
|
BSC |
Basic Materials |
|
BTC |
Biotechnology |
|
CAR |
Automobiles |
|
CGS |
Cyclical Goods & Services |
|
CHC |
Chemicals, Commodity |
|
CHE |
Chemicals |
|
CHM |
Chemicals |
|
CHS |
Chemicals, Specialty |
|
CLO |
Clothing/Fabrics |
|
CMT |
Communications Technology |
|
CNO |
Casinos |
|
CNS |
Construction |
|
COA |
Coal |
|
CON |
Heavy Construction |
|
COS |
Cosmetics |
|
CPR |
Computers |
|
CSE |
Consumer Electronics |
|
CSV |
Consumer Services |
|
CTR |
Containers & Packaging |
|
CTS |
Wireless Communications |
|
CYC |
Consumer, Cyclical |
|
DOW |
Country/Region Rollup |
|
DRG |
Pharmaceuticals |
|
DRL |
Oil Drilling |
|
DST |
Distillers & Brewers |
|
ELC |
Electric Utilities |
|
ELQ |
Electric Components & Equipment |
|
ENE |
Energy |
|
ENG |
Energy |
|
ENT |
Entertainment & Leisure |
|
EQS |
Oilfield Equipment & Services |
|
FAB |
Food & Beverage |
|
FAC |
Factory Equipment |
|
FDR |
Food Retailers & Wholesalers |
|
FIN |
Financial |
|
FIS |
Diversified Financial |
|
FOB |
Food & Beverage |
|
FOD |
Food Products |
|
FOR |
Forest Products |
|
FOT |
Footwear |
|
FRP |
Forest Products & Paper |
|
FTR |
Furnishings |
|
FTS |
Fixed Line Communications |
|
FVS |
Financial Services |
|
GAS |
Gas Utilities |
|
HCA |
Healthcare |
|
HCR |
Healthcare |
|
HEA |
Healthcare Providers |
|
HEQ |
Technology, Hardware & Equipment |
|
HMF |
Home Construction & Furnishings |
|
HOM |
Home Construction |
|
HOU |
Household Products |
|
HPD |
Household Products, Durable |
|
HPN |
Household Products, Non-Durable |
|
ICS |
Industrial Services |
|
IDD |
Industrial, Diversified |
|
IDE |
Industrial Equipment |
|
IDM |
Construction & Materials |
|
IDU |
Industrial |
|
IGS |
Industrial Goods & Services |
|
INF |
Insurance, Full Line |
|
INL |
Insurance, Life |
|
INN |
Insurance |
|
INP |
Insurance, Property/Casualty |
|
INS |
Insurance |
|
ITC |
Advanced Industrial Equipment |
|
LDT |
Land Transportation Equipment |
|
LOD |
Lodging |
|
MAC |
Heavy Machinery |
|
MAR |
Marine Transport |
|
MDI |
Media |
|
MDS |
Medical Supplies |
|
MDV |
Advanced Medical Devices |
|
MED |
Media |
|
MET |
Mining & Metals |
|
MNG |
Mining, Diversified |
|
MOV |
Entertainment |
|
MTC |
Medical Products |
|
NCG |
Non-cyclical Goods & Services |
|
NCY |
Consumer, Non-Cyclical |
|
OFF |
Office Equipment |
|
OIL |
Oil Companies, Major |
|
OIS |
Oil Companies, Secondary |
|
ONF |
Non-Ferrous Metals (ex Aluminum) |
|
ONG |
Oil & Gas |
|
OTS |
Retailers, Specialty (ex Drug & Apparel) |
|
PAP |
Paper Products |
|
PBT |
Pharmaceuticals & Biotechnology |
|
PCS |
Precious Metals |
|
PIP |
Pipelines |
|
PLN |
Agriculture |
|
POL |
Pollution Control |
|
PUB |
Publishing |
|
RAI |
Railroads |
|
REA |
Real Estate |
|
REQ |
Recreational Products & Services |
|
RES |
Restaurants |
|
RET |
Retail |
|
RTB |
Retailers, Broadline |
|
RTD |
Retailers, Drug-based |
|
RTS |
Retail |
|
SAL |
Savings & Loan |
|
SAP |
Retailers, Apparel |
|
SCR |
Securities Brokers |
|
SEM |
Semiconductors |
|
SFI |
Specialty Finance |
|
SFT |
Soft Drinks |
|
SHP |
Shipbuilding |
|
SOF |
Technology, Software |
|
STL |
Steel |
|
SVC |
General Industrial Services |
|
TEC |
Technology |
|
TEL |
Telecommunications |
|
TEX |
Textiles & Apparel |
|
THE |
Technology |
|
TIR |
Tires |
|
TLS |
Telecommunications |
|
TMF |
Toys |
|
TOB |
Tobacco |
|
TRA |
Industrial Transportation |
|
TRK |
Trucking |
|
TRQ |
Transportation Equipment |
|
TRV |
Travel |
|
UTI |
Utilities |
|
UTS |
Utilities |
|
WAT |
Water Utilities |
Table
4: Alphabetical by Group Name
|
Group Name |
Group Code |
|
Advanced Industrial Equipment |
ITC |
|
Advanced Medical Devices |
MDV |
|
Advertising |
ADV |
|
Aerospace |
ARO |
|
Agriculture |
PLN |
|
Air Freight |
AIF |
|
Airlines |
AIR |
|
Aluminum |
ALU |
|
Auto Parts |
AUP |
|
Automobile |
AUT |
|
Automobiles |
ATO |
|
Automobiles |
CAR |
|
Banks |
BAK |
|
Banks |
BNK |
|
Basic Materials |
BSC |
|
Basic Resources |
BAS |
|
Biotechnology |
BTC |
|
Broadcasting |
BRD |
|
Building Materials |
BLD |
|
Casinos |
CNO |
|
Chemicals |
CHE |
|
Chemicals |
CHM |
|
Chemicals, Commodity |
CHC |
|
Chemicals, Specialty |
CHS |
|
Clothing/Fabrics |
CLO |
|
Coal |
COA |
|
Communications Technology |
CMT |
|
Computers |
CPR |
|
Construction |
CNS |
|
Construction & Materials |
IDM |
|
Consumer Electronics |
CSE |
|
Consumer Services |
CSV |
|
Consumer, Cyclical |
CYC |
|
Consumer, Non-Cyclical |
NCY |
|
Containers & Packaging |
CTR |
|
Cosmetics |
COS |
|
Country/Region Rollup |
DOW |
|
Cyclical Goods & Services |
CGS |
|
Distillers & Brewers |
DST |
|
Diversified Financial |
FIS |
|
Electric Components & Equipment |
ELQ |
|
Electric Utilities |
ELC |
|
Energy |
ENE |
|
Energy |
ENG |
|
Entertainment |
MOV |
|
Entertainment & Leisure |
ENT |
|
Factory Equipment |
FAC |
|
Financial |
FIN |
|
Financial Services |
FVS |
|
Fixed Line Communications |
FTS |
|
Food & Beverage |
FAB |
|
Food & Beverage |
FOB |
|
Food Products |
FOD |
|
Food Retailers & Wholesalers |
FDR |
|
Footwear |
FOT |
|
Forest Products |
FOR |
|
Forest Products & Paper |
FRP |
|
Furnishings |
FTR |
|
Gas Utilities |
GAS |
|
General Industrial Services |
SVC |
|
Healthcare |
HCR |
|
Healthcare |
HCA |
|
Healthcare Providers |
HEA |
|
Heavy Construction |
CON |
|
Heavy Machinery |
MAC |
|
Home Construction |
HOM |
|
Home Construction & Furnishings |
HMF |
|
Household Products |
HOU |
|
Household Products, Durable |
HPD |
|
Household Products, Non-Durable |
HPN |
|
Industrial |
IDU |
|
Industrial Equipment |
IDE |
|
Industrial Goods & Services |
IGS |
|
Industrial Services |
ICS |
|
Industrial Transportation |
TRA |
|
Industrial, Diversified |
IDD |
|
Insurance |
INS |
|
Insurance |
INN |
|
Insurance, Full Line |
INF |
|
Insurance, Life |
INL |
|
Insurance, Property/Casualty |
INP |
|
Land Transportation Equipment |
LDT |
|
Lodging |
LOD |
|
Marine Transport |
MAR |
|
Media |
MED |
|
Media |
MDI |
|
Medical Products |
MTC |
|
Medical Supplies |
MDS |
|
Mining & Metals |
MET |
|
Mining, Diversified |
MNG |
|
Non-cyclical Goods & Services |
NCG |
|
Non-Ferrous Metals (ex Aluminum) |
ONF |
|
Office Equipment |
OFF |
|
Oil & Gas |
ONG |
|
Oil Companies, Major |
OIL |
|
Oil Companies, Secondary |
OIS |
|
Oil Drilling |
DRL |
|
Oilfield Equipment & Services |
EQS |
|
Paper Products |
PAP |
|
Pharmaceuticals |
DRG |
|
Pharmaceuticals & Biotechnology |
PBT |
|
Pipelines |
PIP |
|
Pollution Control |
POL |
|
Precious Metals |
PCS |
|
Publishing |
PUB |
|
Railroads |
RAI |
|
Real Estate |
REA |
|
Recreational Products & Services |
REQ |
|
Restaurants |
RES |
|
Retail |
RET |
|
Retail |
RTS |
|
Retailers, Apparel |
SAP |
|
Retailers, Broadline |
RTB |
|
Retailers, Drug-based |
RTD |
|
Retailers, Specialty (ex Drug & Apparel) |
OTS |
|
Savings & Loan |
SAL |
|
Securities Brokers |
SCR |
|
Semiconductors |
SEM |
|
Shipbuilding |
SHP |
|
Soft Drinks |
SFT |
|
Specialty Finance |
SFI |
|
Steel |
STL |
|
Technology |
TEC |
|
Technology |
THE |
|
Technology, Hardware & Equipment |
HEQ |
|
Technology, Software |
SOF |
|
Telecommunications |
TEL |
|
Telecommunications |
TLS |
|
Textiles & Apparel |
TEX |
|
Tires |
TIR |
|
Tobacco |
TOB |
|
Toys |
TMF |
|
Transportation Equipment |
TRQ |
|
Travel |
TRV |
|
Trucking |
TRK |
|
Utilities |
UTI |
|
Utilities |
UTS |
|
Water Utilities |
WAT |
|
Wireless Communications |
CTS |
Economic Sectors
|
Market Sectors
|
Industry Groups
|
Sub-Groups |
||||
|
BSC |
Basic
Materials [BSC] |
CHE |
Chemicals
[CHE] |
CHM |
Chemicals [CHM] |
CHC |
Chemicals-Commodity [CHC] |
|
CHS |
Chemicals-Specialty [CHS] |
||||||
|
BAS |
Basic
Resources [BAS] |
MET |
Mining
& Metals [MET] |
MNG |
Mining, Diversified [MNG] |
||
|
ALU |
Aluminum [ALU] |
||||||
|
ONF |
Non-Ferrous Metals [ONF] |
||||||
|
PCS |
Precious Metals [PCS] |
||||||
|
STL |
Steel [STL] |
||||||
|
FRP |
Forest
Products & Paper [FRP] |
FOR |
Forest Products [FOR] |
||||
|
PAP |
Paper Products [PAP] |
||||||
|
CYC |
Consumer,
Cyclical [CYC] |
ATO |
Automobiles
[ATO] |
CAR |
Automobiles [CAR] |
AUT |
Automobile [AUT] |
|
TIR |
Tires [TIR] |
||||||
|
AUP |
Auto Parts [AUP] |
||||||
|
CGS |
Cyclical
Goods & Services [CGS] |
ENT |
Entertainment
& Leisure [ENT] |
CNO |
Casinos [CNO] |
||
|
MOV |
Entertainment [MOV] |
||||||
|
REQ |
Recreation Products & Services [REQ] |
||||||
|
TMF |
Toys [TMF] |
||||||
|
RES |
Restaurants [RES] |
||||||
|
CSE |
Consumer Electronics [CSE] |
||||||
|
TRV |
Travel
[TRV] |
AIR |
Airlines [AIR] |
||||
|
LOD |
Lodging [LOD] |
||||||
|
HMF |
Home Construction & Furnishings [HMF] |
HOM |
Home Construction [HOM] |
||||
|
FTR |
Furnishings [FTR] |
||||||
|
TEX |
Textiles
& Apparel [TEX] |
FOT |
Footwear [FOT] |
||||
|
CLO |
Clothing/Fabrics [CLO] |
||||||
|
RET |
Retail
[RET] |
RTS |
Retail [RTS] |
RTB |
Retailers, Broadline [RTB] |
||
|
SAP |
Retailers, Apparel [SAP] |
||||||
|
RTD |
Retailers, Drug-based [RTD] |
||||||
|
OTS |
Retailers, Specialty [OTS] |
||||||
|
MDI |
Media
[MDI] |
MED |
Media [MED] |
ADV |
Advertising [ADV] |
||
|
BRD |
Broadcasting [BRD] |
||||||
|
PUB |
Publishing [PUB] |
||||||
|
ENE |
Energy
[ENE] |
ENG |
Energy
[ENG] |
OAG |
Oil & Gas [OAG] |
DRL |
Oil Drilling [DRL] |
|
EQS |
Oilfield Equipment & Services [EQS] |
||||||
|
OIL |
Oil Companies, Major [OIL] |
||||||
|
OIS |
Oil Companies, Secondary [OIS] |
||||||
|
PIP |
Pipelines [PIP] |
||||||
|
COA |
Coal [COA] |
|
|||||
|
FIN |
Financial
[FIN] |
BAK |
Banks
[BAK] |
BNK |
Banks [BNK] |
|
|
|
INN |
Insurance
[INN] |
INS |
Insurance [INS] |
INF |
Insurance, Full Line [INF] |
||
|
INL |
Insurance, Life [INL] |
||||||
|
INP |
Insurance, Property/Casualty [INP] |
||||||
|
FVS |
Financial
Services [FVS] |
REA |
Real
Estate [REA] |
|
|||
|
SFI |
Specialty
Finance [SFI] |
FIS |
Diversified Financial [FIS] |
||||
|
SCR |
Securities Brokers [SCR] |
||||||
|
SAL |
Savings & Loan [SAL] |
||||||
|
HCR |
Healthcare
[HCR] |
HCA |
Healthcare
[HCA] |
MTC |
Medical
Products [MTC] |
MDS |
Medical Supplies [MDS] |
|
MDV |
Advanced Medical Devices [MDV] |
||||||
|
PBT |
Pharmaceutical
& Biotechnology [PBT] |
DRG |
Pharmaceuticals [DRG] |
||||
|
BTC |
Biotechnology [BTC] |
||||||
|
HEA |
Healthcare Providers [HEA] |
|
|||||
|
IDU |
Industrial
[IDU] |
CNS |
Construction
[CNS] |
IDM |
Construction and Materials [IDM] |
CON |
Heavy Construction [CON] |
|
BLD |
Building Materials [BLD] |
||||||
|
IGS |
Industrial
Goods & Services [IGS] |
IDE |
Industrial
Equipment [IDE] |
ITC |
Advanced Industrial Equipment [ITC] |
||
|
ELQ |
Electric Components & Equipment [ELQ] |
||||||
|
FAC |
Factory Equipment [FAC] |
||||||
|
MAC |
Heavy Machinery [MAC] |
||||||
|
SVC |
General Industrial Services [SVC] |
POL |
Pollution Control [POL] |
||||
|
ICS |
Industrial Services [ICS] |
||||||
|
CTR |
Containers & Packaging [CTR] |
|
|||||
|
IDD |
Industrial, Diversified [IDD] |
||||||
|
TRA |
Industrial
Transportation [TRA] |
MAR |
Marine Transport [MAR] |
||||
|
RAI |
Railroads [RAI] |
||||||
|
TRK |
Trucking [TRK] |
||||||
|
AIF |
Air Freight [AIF] |
||||||
|
ARO |
Aerospace [ARO] |
|
|||||
|
TRQ |
Transportation Equipment [TRQ] |
LDT |
Land Transportation Equipment [LDT] |
||||
|
SHP |
Shipbuilding [SHP] |
||||||
|
NCY |
Consumer,
Non-Cyclical [NCY] |
FOB |
Food
& Beverage [FOB] |
FAB |
Food & Beverage Makers [FAB] |
PLN |
Agriculture [PLN] |
|
DST |
Distillers & Brewers [DST] |
||||||
|
SFT |
Soft Drinks [SFT] |
||||||
|
FOD |
Food [FOD] |
||||||
|
NCG |
Non-cyclical
Goods & Services [NCG] |
TOB |
Tobacco [TOB] |
|
|||
|
CSV |
Consumer Services [CSV] |
||||||
|
FDR |
Food Retailers & Wholesalers [FDR] |
||||||
|
HOU |
Household Products [HOU] |
HPD |
Household Products Durable [HPD] |
||||
|
HPN |
Household Products Non-Durable [HPN] |
||||||
|
COS |
Cosmetics [COS] |
|
|||||
|
TEC |
Technology
[TEC] |
THE |
Technology
[THE] |
HEQ |
Technology, Hardware and Equipment [HEQ] |
CMT |
Communications Technology [CMT] |
|
CPR |
Computers [CPR] |
||||||
|
OFF |
Office Equipment [OFF] |
||||||
|
SEM |
Semiconductors [SEM] |
||||||
|
SOF |
Technology, Software [SOF] |
|
|||||
|
TLS |
Telecommunications
[TLS] |
TEL |
Telecommunications
[TEL] |
FTS |
Fixed Line Communications [FTS] |
|
|
|
CTS |
Wireless Communications [CTS] |
||||||
|
UTI |
Utilities
[UTI] |
UTS |
Utilities
[UTS] |
ELC |
Electric Utilities [ELC] |
||
|
GAS |
Gas Utilities [GAS] |
||||||
|
WAT |
Water Utilities [WAT] |
||||||
|
10 |
18 |
40 |
70 |
||||