BTI DSC 1.pdf

Document Sample
BTI DSC 1.pdf Powered By Docstoc
					            BTI Data Standards
             Catalogue Ver 1.0


                              July 2003




BTI Data Standards Catalogue Version 1.0   1
   To unlock the knowledge in the organisation and add real value

                   Underpinning the future strategy of BTI
                     Co-ordinated by BTI’s Data Team
                      Drawn from a range of sources
                        Enhancing inter-operability
                         A Foundation for success
                         A Cross-system resource
                          A Toolkit for the Future




BTI Data Standards Catalogue Version 1.0                     2
                                    Document History

Version    Date          Author           Date Approved       Description
0.6        30/09/2002 Peter Rowan                             Draft for discussion on 4/10/02
                         Lorna Brown
0.7        24/10/2002 Peter Rowan                             Reviewed and amended
                         Lorna Brown
0.6.4      14/03/2003    Lorna Brown                          Amended
0.7        27/3/2003     Peter Rowan                          Internal BTI Amendments
0.8        9/4/2003      Peter Rowan                          Internal BTI Amendments
0.8.1      15/4/2003     Peter Rowan                          For consultation
                         Nigel Nichols
1.0        16/7/2003     Peter Rowan                          Amended following consultation
                         Nigel Nichols                        Amendments are explained in
                                                              detail in the BTI Data Standards
                                                              Catalogue Results of Consultation
                                                              document.


                                  Related Documents

          Title           Version        Date Agreed           Author              Location

BTI Data Standards       1.0                              Nigel Nichols       D03/226504
Change Control
Document

BTI Data Entry           0.9.5                            Nigel Nichols       D03/361073
Standards

BTI Data Standards       1.0                              Nigel Nichols       D03/353309
Catalogue Results of
Consultation

BTI Logical Data Model   0.4                              Adrian Bibby        D03/373369

                                                          Peter Rowan

BTI Meta Data Model      0.4                              Adrian Bibby        D03/373366

BTI 34 Sectors Mapped    1.0                              Nigel Nichols       D03/372926
to 5 digit SIC codes

Meta Tag document for    0.1                              Nigel Nichols       D03/373043
BTI 34 Sectors Derived
from SIC



BTI Data Standards Catalogue Version 1.0                                                  3
Table of Contents
  Introduction ...................................................................................................................................7
  Executive Summary .......................................................................................................................7
  Objective .......................................................................................................................................7
  Scope ...........................................................................................................................................7
  Approach and Method ....................................................................................................................8
  Change Control..............................................................................................................................8
  Data Protection Act ........................................................................................................................8
  Freedom Of Information .................................................................................................................9
Section 1 - Data Items Definitions ........................................................................10
  Address_Line .............................................................................................................................. 11
  Address_String_Nat_Lan.............................................................................................................. 12
  Address_Type ............................................................................................................................. 13
  Address_Verify_Flag .................................................................................................................... 14
  BTI_Registration_Num ................................................................................................................. 15
  BTI_Sector_Id.............................................................................................................................. 16
  BTI_Sector_Name ....................................................................................................................... 17
  Bus_Cat_DB_Name ..................................................................................................................... 19
  Bus_Cat_Lookup_Code ............................................................................................................... 20
  Business_Status_Code ................................................................................................................ 21
  Companies_House_Ref_Number .................................................................................................. 23
  Contact_Nationality ...................................................................................................................... 25
  Contact_Type .............................................................................................................................. 32
  Continent_Id................................................................................................................................ 33
  Continent_Name .......................................................................................................................... 35
  Database_Name .......................................................................................................................... 37
  Database_Source_Code .............................................................................................................. 38
  Database_Type ........................................................................................................................... 39
  DPA_Change_Date...................................................................................................................... 40
  DPA_Ext_Marketing ..................................................................................................................... 42
  DPA_Int_Marketing...................................................................................................................... 43
  DPA_Oversea_Transfer ............................................................................................................... 44
  Email........................................................................................................................................... 45
  Employees .................................................................................................................................. 46
  Employees_Year ......................................................................................................................... 47
  English_Region............................................................................................................................ 48
  Extension_Number....................................................................................................................... 50
  Export_Experience_Level ............................................................................................................. 51
  Export_Market_Type .................................................................................................................... 53
  Export_Turnover .......................................................................................................................... 55
  Export_Turnover_Year ................................................................................................................. 56
  Fax ............................................................................................................................................. 57
  Geographic_Region_Id................................................................................................................. 59
  Geographic_Region_Name .......................................................................................................... 61
  Holding_Parent_Org_Name.......................................................................................................... 63
  HQ_Country ................................................................................................................................ 64
  HS_Code .................................................................................................................................... 65
  HS_Code_Description .................................................................................................................. 66
  Invest_Experience_Level.............................................................................................................. 67
  ISO_Alpha2_Code ....................................................................................................................... 68
  ISO_Country_Code ...................................................................................................................... 69
  Job_Department .......................................................................................................................... 71
  Job_Title ..................................................................................................................................... 72
  Language .................................................................................................................................... 73
  Last_Validated ............................................................................................................................. 79


BTI Data Standards Catalogue Version 1.0                                                                                            4
  Mail_Bar_Code ............................................................................................................................ 80
  Mail_Sort_Code........................................................................................................................... 81
  Market_Desc ............................................................................................................................... 82
  Market_Id .................................................................................................................................... 89
  Mobile ......................................................................................................................................... 96
  Name_Nat_Lan............................................................................................................................ 97
  Org_Abbr_Name_Alias ................................................................................................................. 98
  Org_Business_Type..................................................................................................................... 99
  Org_Level_Market_Unit.............................................................................................................. 101
  Org_Level_Sector_Unit .............................................................................................................. 103
  Org_Location_Flag..................................................................................................................... 105
  Org_Product_Description ........................................................................................................... 106
  Organisation_Description ........................................................................................................... 107
  Organisation_Name ................................................................................................................... 108
  Organisation_Name_Nat_Lan ..................................................................................................... 109
  Person_ Gender ........................................................................................................................ 110
  Person_Family_Name ................................................................................................................ 112
  Person_First_Given_Name......................................................................................................... 113
  Person_Name_Suffix ................................................................................................................. 114
  Person_Name_Suffix_Nat_Lan................................................................................................... 115
  Person_Second_Given_Name .................................................................................................... 116
  Person_Title .............................................................................................................................. 117
  Person_Title_Nat_Lan................................................................................................................ 118
  Political_Economic_Grouping_Id................................................................................................. 119
  Political_Economic_Grouping_Name........................................................................................... 121
  Postcode ................................................................................................................................... 123
  Postcode_Eq_Nat_Lan............................................................................................................... 125
  Preferred_Channel..................................................................................................................... 126
  Profile_Date............................................................................................................................... 127
  Referral_Channel....................................................................................................................... 128
  Referred_By .............................................................................................................................. 130
  Region_Type ............................................................................................................................. 131
  Regulatory_Country ................................................................................................................... 132
  Sector_Description..................................................................................................................... 133
  Sector_Sub_Description............................................................................................................. 134
  SIC_80 ...................................................................................................................................... 135
  SIC_Major ................................................................................................................................. 136
  SIC_Minor ................................................................................................................................. 137
  Tag_Text_Lookup...................................................................................................................... 138
  Telephone_Number ................................................................................................................... 139
  Telex ......................................................................................................................................... 141
  Temp_Address_Until.................................................................................................................. 142
  Turnover.................................................................................................................................... 143
  Turnover_Year........................................................................................................................... 144
  UK_Internal_Code ..................................................................................................................... 145
  UK_SIC_92 ............................................................................................................................... 147
  URL .......................................................................................................................................... 148
  VAT_Number............................................................................................................................. 149
  Verification_Date ....................................................................................................................... 151
  Walk_Sort_Code........................................................................................................................ 152
  Year_Established....................................................................................................................... 153
  Years_Trading ........................................................................................................................... 154
Section 2 - Audit Attributes ....................................................................................155
Section 3 - Example Data Containers .............................................................156
  Address ....................................................................................................................................... 156
  Address_Type................................................................................................................................ 156
  Bti_Sector..................................................................................................................................... 156

BTI Data Standards Catalogue Version 1.0                                                                                           5
 Bti_Sector_Tag_Lookup .................................................................................................................... 157
 Communication_Channel ................................................................................................................... 157
 Contact_Address ............................................................................................................................ 157
 Contact_Language .......................................................................................................................... 157
 Contact_Nationality .......................................................................................................................... 157
 Contact_Org.................................................................................................................................. 157
 Contact_Personal_Details .................................................................................................................. 157
 Contact_Type ................................................................................................................................ 158
 Database_Source............................................................................................................................ 158
 Export_Experience_Level .................................................................................................................. 158
 Export_Market_Type ........................................................................................................................ 158
 Gender ........................................................................................................................................ 158
 HS_Code ..................................................................................................................................... 158
 Market_Country .............................................................................................................................. 158
 Org_Address ................................................................................................................................. 158
 Org_Bti_Sector............................................................................................................................... 158
 Org_Business_Type......................................................................................................................... 159
 Org_HS_Code ............................................................................................................................... 159
 Org_Markets ................................................................................................................................. 159
 Org_Sectors .................................................................................................................................. 159
 Organisation.................................................................................................................................. 159
 Organisation_Profile......................................................................................................................... 159
 Region ........................................................................................................................................ 160
 Region_Country.............................................................................................................................. 160
 Title ............................................................................................................................................ 160
 Uk_SIC_Code ................................................................................................................................ 160
Appendix A: Matching BTI Sectors to SIC codes.......................................161
Appendix B: Continents, Geographic Regions and Markets ..................162




BTI Data Standards Catalogue Version 1.0                                                                                             6
                                         Introduction

Executive Summary

Objective
The purpose of a British Trade International (BTI) Data Standards catalogue and the
associated change control process is to provide a means by which common data can be
standardised with the following benefits

   •   maintenance and design of existing systems is faster for all common elements and
       therefore costs less

   •   interchange of common data between systems is defined and simplified so that
       integration across systems costs less and data can be combined to create added value

   •   non database systems (usually web based systems) can use common formats for their
       data (using xml schema) so that the interchange of data across websites is defined

   •   Allow a set of generic data entry standards to be produced

The overall intent is to facilitate the process of joined-up organisation meeting with government
wide e-GIF standards.

Scope
This document is a component of the BTI Data Library along with documents such as the BTI
Logical Data Model.

It is part of a process to agree a common set of data elements, data types and data element
containers (which in database terms would become database tables) for BTI and associated
Department of Trade and Industry (DTI) and Foreign and Commonwealth Office (FCO)
systems and websites that provide services to UK businesses (from sole trader to large
company). BTI Systems such as Customer First, OMIS; FCO systems such as Contacts 5.1
(6.0); the Small Business Service (SBS) National Client Database; and the various systems in
the Business Links are direct candidates for this process. Databases supporting InvestUK
services and such services as the UK Suppliers Database are slightly different in providing
services to non-UK customers, with the issue that UK standards would have to be extended to
be multi-country standards making the problem more complex.

Each system will have a core set of data elements which are common and a set of elements
that are specific to their specialised use. This document is a mechanism by which that common
set can be agreed. It is making no attempt to standardise the elements that are specialised to a
given systems in-process model. The document will present a case for a core set that may
well be widened or narrowed via the discussion, review and agreement mechanism for the
document. The intent is to get the balance right between simplifying design and allowing
necessary freedom to design as necessary for fit for purpose.

This volume will cover the following areas of data:

UK business – Organisation, Definition and Classification

BTI Data Standards Catalogue Version 1.0                                              7
Business Contact - Business and Personal Data

Business Product Classification – SIC Code and BTI Sectors

Referential Data – e.g., Countries, Regions, Markets, Sector definitions, Salutations,
Nationality, Language.

and thus aid the interchange of data between internal and external systems

It is envisaged that Part 2 of the catalogue will be published in due course to further reflect the
Logical Data Model and cover BTI’s services and transactions.

Approach and Method
Definitions of data elements take into account wherever known existing UK and ISO standards
and build on the e-GIF framework Government Data Standards Catalogues (GDSC) Volumes 1
to 3, using similar formats and definitions of data. This catalogue takes these standards
further.

   •   The Government e-GIF data catalogues standardise data type and data elements. This
       document will extend the e    -GIF standards to those used in trade and investment
       systems and will also arrange common elements into data containers such as
       organisation, contact etc. as a starting point for data flow.



All data elements, containers etc., are notated in the same format as the Government Data
Standards Catalogue.

Change Control
It is intended to have a annual review process for this catalogue. This is published in ‘BTI Data
Standards Change Control Document’.

Data Protection Act
British Trade International has a Data Protection policy which is published on its public
websites.

http://www.invest.uk.com/privacypolicy.cfm


http://www.tradepartners.gov.uk/privacy_policy/privacy_policy/privacy/privacy.shtml

There is also a BTI staff guidance document ‘A Practical Guide to the Data Protection Act 1998
for British Trade International Staff’.

DPA fields have been incorporated into this catalogue where appropriate.




BTI Data Standards Catalogue Version 1.0                                               8
Freedom Of Information
Although the Freedom of Information Act will not become fully operational until January 2005,
the spirit of Open Government promoted by the Act is already being followed by British Trade
International under the Code of Practice on Access to Government Information.

BTI has also produced a Publication Scheme as required by the Act, and there is a ‘Quick
Guide for DTI Staff’ covering the Act, the Code and the Scheme.
http://www.tradepartners.gov.uk/publication_scheme/overview/introduction/introduction.shtml

Compliance

The standards herein are intended to be compliant with ISO/IEC 11179



Catalogue Owner
The owner of this Catalogue is British Trade International. Information relating to the catalogue
and BTI data sources and ownership should be directed to:

Nigel Nichols

BTI Data Manager
Kingsgate House (Bay 145)
66-74 Victoria Street
London
SW1E 6SW
Tel: 020 7215 2406

e-mail: nigel.nichols@dti.gsi.gov.uk




BTI Data Standards Catalogue Version 1.0                                             9
                        Section 1 - Data Items Definitions


The following Data Items are generic items that can be used multiple times in a model or a set
of data containers. For example, Market_ID can be used for market_country,
regulatory_country or any case where a country type is needed.

In addition the e-gif XML standards for interchange between Government system specify
Unicode and UTF 8 as character set for interchange. These character sets support the large
majority if not all national characters. All the data items on the following pages are better
implemented and held as Unicode (and as such will work both for UK and non-UK language
characters).




BTI Data Standards Catalogue Version 1.0                                           10
                                     Address_Line


Data Element                                Address_Line

Is Part Of                                  BS3777

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Address_Line
                               Type and length of address line used both in UK and
Description
                               non UK addresses
Business Format                Max Length 100 characters
Element Type and example
                               Data Item - Varchar2(100)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    UK addresses can be verified against PAF Products
Value
DefaultValue
Owner                          BSI
Based On                       BS 3777
Verification
Comments                       GDSC Ver 2
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                       11
                            Address_String_Nat_Lan


Data Element                               Address_String_Nat_Lan

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Address_String_Nat_Lan

Description                    Total Address string in any UNICODE Language
Business Format                Max Length 500 National characters
Element Type and example
                               Data Item - Varchar2(500)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner
Based On
Verification
                               It is presumed that English will be used in BTI's
                               systems, both in the UK and overseas. However, the
Comments                       Nat_Lan data items allow for local in-country mail
                               addressing, and the recording of business cards in
                               local character sets.
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                      12
                                     Address_Type


Data Element                               Address_Type

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Address_Type

Description                    Temporary, Alternate, Main
Business Format                Max length 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    values as below
Value                          temporary, alternate, main
DefaultValue                   main
Owner                          BTI
Based On
Verification
Comments                       ‘main’ is an authorised contact or business address
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        13
                               Address_Verify_Flag


Data Element                                 Address_Verify_Flag

Is Part Of

Has Parts

Version                                      1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Address_Verify_Flag

Description                    Is this address a valid postal address
Business Format                exactly 1 char
Element Type and example
                               Data Item - Char(1)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    only Y or N
Value                          Y or N
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                14
                              BTI_Registration_Num


Data Element                               BTI_R egistration_Num

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           BTI_Registration_Num

Description                    BTI Portal Registration Number
Business Format                Max Length 25
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments                       Format as yet undefined
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                           15
                                     BTI_Sector_Id


Data Element                               BTI_Se ctor_Id

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           BTI_Sector_Id
                               Numeric Sector ID (not necessarily maintained by
Description
                               BTI)
Business Format                Max Length 25
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Only the numbers 1 to 34
Value                          1 to 34
DefaultValue
Owner                          BTI
Based On
Verification
Comments                       Numeric format may not be maintained
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                          16
                                 BTI_Sector_Name


Data Element                               BTI_Sector_Name

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           BTI_Sector_Name

Description                    Business sector description
Business Format                Max 80 Chars
Element Type and example
                               Data Item - Varchar2(80)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    A valid Sector name in BTI_SECTOR lookup table
                               1. AEROSPACE (CIVIL)
                               2. AGRICULTURE, HORTICULTURE & FISHERIES
                               3. AIRPORTS
                               4. AUTOMOTIVE
                               5. BIOTECHNOLOGY & PHARMACEUTICALS
                               6. BUSINESS (& CONSUMER) SERVICES
                               7. CHEMICALS
Value
                               8. CLOTHING, FOOTWEAR & FASHION
                               9. COMMUNICATIONS
                               10. CONSTRUCTION
                               11. CREATIVE & MEDIA
                               12. EDUCATION & TRAINING
                               13. ELECTRONICS & IT HARDWARE
                               14. ENVIRONMENT


BTI Data Standards Catalogue Version 1.0                                    17
                               15. FINANCIAL SERVICES
                               16. FIRE, POLICE & SECURITY
                               17. FOOD & DRINK
                               18. GIFTWARE, JEWELLERY & TABLEWARE
                               19. HEALTHCARE & MEDICAL
                               20. HOUSEHOLD GOODS, FURNITURE &
                               FURNISHINGS
                               21. LEISURE & TOURISM
                               22. MARINE
                               23. MECHANICAL ELECTRICAL & PROCESS
                               ENGINEERING
                               24. .METALLURGICAL PROCESS PLANT
                               25. METALS & MINERALS
                               26. MINING
                               27. OIL & GAS
                               28. PORTS & LOGISTICS
                               29. POWER
                               30. RAILWAYS
                               31. SOFTWARE & COMPUTER SERVICES
                               BUSINESS TO BUSINESS (B2B)
                               32. SPORTS & LEISURE INFRASTRUCTURE
                               33. TEXTILES, INTERIOR TEXTILES & CARPETS
                               34. WATER
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                              18
                                Bus_Cat_DB_Name


Data Element                               Bus_Cat_DB_Name

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Bus_Cat_DB_Name
                               The name of the catalogue lookup owner that is
Description
                               providing the organisation profile.
Business Format                Max Length 25 Chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue                   D and B
Owner                          BTI
Based On
Verification
Comments                       Dun & Bradstreet Company Register (D&B)
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        19
                             Bus_Cat_Lookup_Code


Data Element                                Bus_Cat_Lookup_Code

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Bus_Cat_Lookup_Code
                               Local business catalogue lookup (usually Dun &
Description
                               Bradstreet number)
                               Max Length 25 - if DUNS_NUMBER max length is 11
Business Format
                               numbers
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    If D & B is 11 numbers
Value
DefaultValue
Owner                          BTI
Based On                       If DUNS_NUMBER as GDSC Vol 3
Verification
                               The D&B “D-U-N-S Number” is a unique 11 digit
                               identification sequence, which provides unique
Comments
                               identifiers of single business entities, while linking
                               corporate family structures together.
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                                20
                             Business_Status_Code


Data Element                               Business_Status_Code

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Business_Status_Code
                               Legal status of company as defined by Companies
Description
                               House
Business Format                Max Length 10
Element Type and example
                               Data Item - Varchar2(10)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Values provided by Companies House
Value                          Trading, Dormant, Insolvent, Dissolved
DefaultValue                   Trading
Owner                          Companies House
Based On
Verification
                               Trading applies to a company that is trading and is a
                               legal entity.
                               Dormant applies to company that has ‘no significant
                               accounting transactions’ during a financial year.
Comments
                               Insolvent applies to a company that may be on its way
                               to being dissolved.
                               Dissolved status applies to companies that have
                               ceased to exist as a legal entity.

BTI Data Standards Catalogue Version 1.0                                       21
                               SBS use an extended list and it is mapped to BTI
                               values as follows:-
                               BTI / Companies Hse        SBS

                                                          Pre-start up
                                                          Startup
                               Trading                    Established
                               Dormant                    Dormant
                               Insolvent                  Ceased
                               Dissolved                  Ceased


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                          22
                       Companies_House_Ref_Number


Data Element                                Companies_House_Ref_Number

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Companies_House_Ref_Number
                               A unique reference number allocated by the Registrar
                               of Companies to a UK limited liability company or
Description
                               unlimited company or the branch of a foreign
                               company at the time of first registration.
Business Format                Max Length 8
Element Type and example
                               Data Item - Varchar2(8)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
                               First two characters must be either two alpha
                               characters in the range OO, AC, FC, GE, GN, GS, IC,
                               IP, LP, NA, NF, NI, NL, NO, NP, NR, NZ, OC, RC,
Validations
                               SA, SC, SF, SI, SL, SO, SP, SR, SZ, ZC, or R
                               followed by a numeric. Up to 6 characters must be
                               numeric.
Value
DefaultValue
Owner                          Companies House
Based On                       GDSC Vol 3
Verification
Comments


BTI Data Standards Catalogue Version 1.0                                       23
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0   24
                                Contact_Nationality


Data Element                                Contact_Nationality

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Contact_Nationality
                               Nationality of contact – term for describing a citizen of a
Description
                               country.
Business Format                Max Len 25
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Is the value in the Nationality Look up table
                               Afghan
                               Albanian
                               Algerian
                               American (United States)
                               Andorran
                               Angolan
                               Anguillan
Value
                               Antiguan
                               Argentine
                               Armenian
                               Aruban
                               Australian
                               Austrian
                               Azerbaijani

BTI Data Standards Catalogue Version 1.0                                           25
                               Bahamian
                               Bahraini
                               Bangladeshi
                               Barbadian
                               Barbudan
                               Belarusian
                               Belgian
                               Belizean
                               Beninese
                               Bermudan
                               Bhutanese
                               Bolivian
                               Bosnian
                               Brazilian
                               British
                               British Virgin Islander
                               Bruneian
                               Bulgarian
                               Burkinan
                               Burmese
                               Burundian
                               Cambodian
                               Cameroonian
                               Canadian
                               Cape Verdean
                               Caymanian
                               Central African Republic
                               Chadian
                               Channel Islander
                               Chilean
                               Chinese
                               Christmas Islander
                               Cocos Islander
                               Colombian
                               Comoran
                               Congolese
                               Cook Islander
                               Costa Rican
                               Croatian
                               Cuban
                               Cypriot
                               Czech

BTI Data Standards Catalogue Version 1.0                  26
                               Danish
                               Djiboutian
                               Dominican
                               Dutch
                               Dutch Antillean
                               East Timorese
                               Ecuadorean
                               Egyptian
                               Emirati (Citizen of the UAE)
                               Equatorial Guinean
                               Eritrean
                               Estonian
                               Ethiopian
                               Falkland Islander
                               Faroese
                               Fijian
                               Finnish
                               French
                               French Guianese
                               French Polynesian
                               Gabonese
                               Gambian
                               Georgian
                               German
                               Ghanaian
                               Gibraltarian
                               Greek
                               Greenlander
                               Grenadian
                               Guadeloupian
                               Guamanian
                               Guatemalan
                               Guinea-Bissau
                               Guyanese
                               Haitian
                               Honduran
                               Hungarian
                               Icelandic
                               Indian
                               Indonesian
                               Iranian
                               Iraqi

BTI Data Standards Catalogue Version 1.0                      27
                               Irish
                               Israeli
                               Italian
                               Ivorian
                               Jamaican
                               Japanese
                               Jordanian
                               Kazakh
                               Kenyan
                               Kiribati
                               Kittitian
                               Kuwaiti
                               Kyrgyz
                               Laotian
                               Latvian
                               Lebanese
                               Lesotho
                               Liberian
                               Libyan
                               Liechtenstein
                               Lithuanian
                               Luxembourger
                               Macedonian
                               Mahorais
                               Malagasy
                               Malawian
                               Malaysian
                               Maldivian
                               Malian
                               Maltese
                               Manx
                               Marshall Islander
                               Martiniquais
                               Mauritanian
                               Mauritian
                               Mexican
                               Micronesian
                               Moldovan
                               Monegasque
                               Mongolian
                               Montenegrin
                               Montserratian

BTI Data Standards Catalogue Version 1.0           28
                               Moroccan
                               Mozambican
                               Namibian
                               Nationalist Chinese (Taiwan)
                               Nauruan
                               Nepalese
                               Nevisian
                               New Caledonian
                               New Zealander
                               Nicaraguan
                               Nigerian
                               Nigerien
                               Niuean
                               Ni-Vanuatu
                               Norfolk Islander
                               North Korean
                               Norwegian
                               Omani
                               Pakistani
                               Palauan
                               Palestanian
                               Panamanian
                               Papua New Guinean
                               Paraguayan
                               Peruvian
                               Philippine
                               Pitcairn Islander
                               Polish
                               Portuguese
                               Puerto Rican
                               Qatari
                               Reunionese
                               Romanian
                               Russian
                               Rwandan
                               Sahrawi
                               Salvadorean
                               Sammarinese
                               Samoan
                               Sao Tomean
                               Saudi Arabian
                               Senegalese

BTI Data Standards Catalogue Version 1.0                      29
                               Serbian
                               Seychellois
                               Sierra Leonean
                               Singaporean
                               Slovak
                               Slovenian
                               Solomon Islander
                               Somali
                               South African
                               South Korean
                               Spanish
                               Sri Lankan
                               St Helenian
                               St Lucian
                               St Vincentian
                               Sudanese
                               Surinamer
                               Swazi
                               Swedish
                               Swiss
                               Syrian
                               Tajik
                               Tanzanian
                               Thai
                               Tobagan
                               Togolese
                               Tokelauan
                               Tongan
                               Trinidadian
                               Tunisian
                               Turkish
                               Turkmen
                               Turks & Caicos Islander
                               Tuvaluan
                               Ugandan
                               Ukrainian
                               Uruguayan
                               Uzbek
                               Vatican Citizen
                               Venezuelan
                               Vietnamese
                               Vincentian

BTI Data Standards Catalogue Version 1.0                 30
                               Virgin Islander
                               Wallis and Futuna Islander
                               Yemeni
                               Zambian
                               Zimbabwean


DefaultValue
Owner                          FCO (Global Issues Research Group)
Based On
Verification
                               The Global Issues Research Group (GIRG) of the Research
                               Analysts in the FCO is responsible, in consultation with the
                               appropriate political department, for co-ordinating
                               information and giving rulings on geographical names and
                               titles of States, and for informing Government Departments
                               and other interested bodies of any change. The GIRG also
Comments                       provides FCO representation on the inter-departmental
                               Permanent Committee on Geographical Names (PCGN).
                               Where there is not an existing ruling on nationality for a
                               particular market, BTI will seek advice from FCO.
                               The CIA Factbook provides an alternative online source.
                               http://www.cia.gov/cia/publications/factbook/fields/2110.html


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                         31
                                     Contact_Type


Data Element                               Contact_Type

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Contact_Type

Description                    employee, agent, consultant, student, misdirect
Business Format                Max Length 10
Element Type and example
                               Data Item - Varchar2(10)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Is the value in the Contact_Type Look up table
Value                          employee, agent, consultant, individual, student
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                          32
                                     Continent_Id


Data Element                                Continent_Id

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Continent_Id

Description                    Location name.
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does this value exist in Region lookup table
                               Africa
                               Americas
                               Antarctica
Value                          Asia
                               Europe
                               Oceania


DefaultValue
Owner                          BTI
Based On
Verification

Comments                       Continents are the highest level of geographic
                               grouping of markets. The following site maintained by

BTI Data Standards Catalogue Version 1.0                                        33
                               the UN Statistics Division offers the neatest
                               hierarchical view of the geographic regions of the
                               world and is the one used as a starting point by BTI.
                               http://unstats.un.org/unsd/methods/m49/m49regin.htm
                               Refer to Appendix B for details of the hierarchy of
                               Continents, Geographic Regions and Markets


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                       34
                                  Continent_Name


Data Element                                Continent_Name

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Continent_Name

Description                    Long Region Name
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does this value exist in Region lookup table
                               Africa
                               Americas
                               Antarctica
Value                          Asia
                               Europe
                               Oceania


DefaultValue
Owner                          BTI
Based On
Verification
Comments


BTI Data Standards Catalogue Version 1.0                                      35
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0   36
                                  Database_Name


Data Element                               Database_Name

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Database_Name

Description                    Originating system database source of row data
Business Format                Max Length 100
Element Type and example
                               Data Item - Varchar2(100)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Is the value in the database name table
                               examples are CustomerFirst, ClientFirst, Contacts5,
Value
                               SBS, DUNS
DefaultValue
Owner
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        37
                             Database_Source_Code


Data Element                               Database_Source_Code

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Database_Source_Code

Description                    A code for source database
Business Format                Max Length 25
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Is the value in the database name table
Value                          examples are CF,CLF,C5,SBS,DUNS
DefaultValue
Owner
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                 38
                                   Database_Type


Data Element                               Database_Type

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Database_Type
                               Technical Type of Database e.g. Oracle, Access, SQL
Description
                               Server, DB2
Business Format                Max Length 25
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Is the value in the database name table
Value                          examples are Oracle, Access, DB2, Sql Server, File
DefaultValue
Owner
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                      39
                                DPA_Change_Date


Data Element                               DPA_Change_Date

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           DPA_Change_Date
                               Date personal details were recorded for Data
Description
                               Protection Act purposes
                               UK date format,10 characters in the format
Business Format
                               DD/MM/CCYY
Element Type and example
                               Data Item - Date
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
                               1. Values less than 10 in the day , month or year
                               elements, should be entered with a zero in the first
                               position
Validations                    2. Days must not be greater than 30 for the months
                               April, June, September and November.
                               3. Days must not be greater than 28 in February
                               except when 29 is allowed for a leap year.
                               CCYY should be a number
Value                          MM in range 01-12
                               DD in range 01-31
DefaultValue
Owner
Based On
Verification


BTI Data Standards Catalogue Version 1.0                                         40
                               For interchange between systems the standard UK
                               date is transformed into XML Schema Part 2: Data
Comments
                               types WC3 Recommendations 02 May 2001 format
                               CCYY-MM-DD
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                     41
                                DPA_Ext_Marketing


Data Element                                DPA_Ext_Marketing

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           DPA_Ext_Marketing
                               Permission to pass personal contact details to
Description
                               external service providers
Business Format                exactly 1 char or null
Element Type and example
                               Data Item - Char(1)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    only Y or N or Null
Value                          Y or N or Null
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        42
                                DPA_Int_Marketing


Data Element                                DPA_Int_Marketing

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           DPA_Int_Marketing
                               Permission to pass personal contact details to internal
Description
                               service providers
Business Format                exactly 1 char or null
Element Type and example
                               Data Item - Char(1)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    only Y or N or Null
Value                          Y or N or Null
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                         43
                             DPA_Oversea_Transfer


Data Element                                DPA_Oversea_Transfer

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           DPA_Oversea_Transfer
                               Permission to transfer personal contact details
Description
                               outside the European Economic Area (EEA)
Business Format                exactly 1 char or null
Element Type and example
                               Data Item - Char(1)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    only Y or N or Null
Value                          Y or N or Null
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                         44
                                           Email


Data Element                                Email

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Email

Description                    Work e-mail address.
Business Format                as GDSC V2 Max 254
Element Type and example
                               Data Item - Varchar2(254)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
                               Locally interpreted string followed by the at-sign
                               character - “@” ASCII value 64 – followed by an
Validations                    Internet domain. The locally interpreted string is
                               either a quoted-string or a dot-atom. Enfolding white
                               space around the “@” sign should not be stored.
Value
DefaultValue
Owner                          IETF
Based On                       GDSC Vol 3
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                         45
                                       Employees


Data Element                               Employees

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Employees

Description                    Number of employees within organisation
Business Format                an unsigned integer
Element Type and example
                               Data Item - Number
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Must be an unsigned number
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                 46
                                  Employees_Year


Data Element                               Employees_Year

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Employees_Year

Description                    Year for Numbers of employees
Business Format                Max 4 numbers in the format CCYY
Element Type and example
                               Data Item - Number(4)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    must be 4 integers greater than 1900
Value                          CCYY must be a valid year number
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                              47
                                  English_Region


Data Eleme nt                              English_Region

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           English_Region
                               Regions of England as defined by the Regional
Description
                               Development Agencies Act 1998
Business Format                Max 25 characters
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
                               North East, North West, Yorkshire & The Humber,
                               East Midlands, West Midlands, East of England,
Value                          London, South East, South West


DefaultValue
Owner                          DTI
Based On
Verification
                               North East -
                               (Durham, Northumberland, Gateshead, Newcastle
Comments                       upon Tyne, North Tyneside, South Tyneside,
                               Sunderland, Darlington, Hartlepool, Middlesbrough,
                               Redcar, Cleveland, Stockton-on-Tees)


BTI Data Standards Catalogue Version 1.0                                       48
                               North West -
                               (Cheshire, Cumbria, Lancashire, Bolton, Bury,
                               Knowsley, Liverpool, Manchester, Oldham, Rochdale,
                               St. Helens, Salford, Sefton, Stockport, Tameside,
                               Trafford, Wigan, Wirral, Blackburn, Darwen,
                               Blackpool, Halton, Warrington)
                               Yorkshire & The Humber -
                               (North Yorkshire, Barnsley, Bradford, Calderdale,
                               Doncaster, Kirklees, Leeds, Rotherham, Sheffield,
                               Wakefield, East Riding of Yorkshire, Kingston upon
                               Hull, North East Lincolnshire, North Lincolnshire and
                               York)
                               East Midlands -
                               (Derbyshire, Leicestershire, Lincolnshire,
                               Northamptonshire, Nottinghamshire, Derby, Leicester,
                               Nottingham, Rutland)
                               West Midlands -
                               (Shropshire, Staffordshire, Warwickshire &
                               Worcestershire, Birmingham, Coventry, Dudley,
                               Sandwell, Solihull, Walsall, Wolverhampton,
                               Herefordshire, Stoke-on-Trent, Telford and Wrekin)
                               East of England -
                               (Bedfordshire, Cambridgeshire, Essex, Hertfordshire,
                               Norfolk, Suffolk, Luton, Peterborough, Southend-on-
                               Sea, Thurrock)
                               London -
                               (Greater London)
                               South East -
                               (Buckinghamshire, East Sussex, Hampshire, Isle of
                               Wight, Kent, Oxfordshire, Surrey, West Sussex,
                               Bracknell Forest, Brighton & Hove, Rochester,
                               Gillingham, Chatham, Milton Keynes, Portsmouth,
                               Reading, Slough, Southampton, West Berkshire,
                               Windsor & Maidenhead, Wokingham)
                               South West -
                               (Cornwall, Devon, Dorset, Gloucestershire,
                               Somerset,, Wiltshire, Bath, North East Somerset,
                               Bournemouth, Bristol, North Somerset, Plymouth,
                               Poole, South Gloucestershire, Swindon, Torbay, The
                               Isles of Scilly)


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                       49
                                Extension_Number


Data Element                               Extension_Number

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Extension_Number

Description                    Telephone Extension Number
Business Format                Max 10 Characters
Element Type and example
                               Data Item - Varchar2(10)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
                               Allows telephone extension numbers to be stored
Comments
                               separately.
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                         50
                            Export_Experience_Level


Data Element                                Export_Experience_Level

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Export_Experience_Level

Description                    Export experience level of UK Businesses
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
                               Is the value in the Export Experience Level lookup
Validations
                               table
Value                          Current, Potential, Not Applicable
DefaultValue
Owner                          BTI
Based On
Verification
                               A current exporter is an existing exporter looking to
                               proactively increase export activity.
                               A potential exporter is a UK business with no direct
Comments                       proactive exports within the last 12 months and is
                               looking to start.
                               See also Export_Market_Types




BTI Data Standards Catalogue Version 1.0                                          51
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0   52
                               Export_Market_Type


Data Element                               Export_Market_Type

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Export_Market_Type
                               Outcome based assistance received from BTI as
Description                    discussed below. Extension of Export Experience
                               Level.
Business Format                Max Length 15
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Is the value in the export_market_type lookup table
Value                          New Exporter, New to Market
DefaultValue
Owner                          BTI
Based On
Verification
                               New Exporter is a Potential Exporter (see
                               Export_Experience_Level) who has received their first
                               significant order as a result of ITT assistance.
Comments
                               New to Market is a Current Exporter (see
                               Export_Experience_Level) who has not exported to
                               the market within the last 12 months and had no

BTI Data Standards Catalogue Version 1.0                                        53
                               established representation within that market.
                               Counted once a significant order has been received.
                               New Exporters cannot be included in this category.

                               These values feed into BTI’s PSA targets
                               Consideration will need to be given at design stage to
                               include facility for entering the actual market/s
                               involved.


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                         54
                                  Export_Turnover


Data Element                               Export_Turnover

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Export_Turnover

Description                    Export Turnover in Sterling
Business Format                an unsigned integer
Element Type and example
                               Data Item - Number
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    must be an unsigned integer
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        55
                              Export_Turnover_Year


Data Element                               Export_Turnover_Year

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Export_Turnover_Year

Description                    Year for Export Turnover
Business Format                4 numbers in the format CCYY
Element Type and example
                               Data Item - Number(4)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    must be 4 integers greater than 1900
Value                          CCYY must be a valid year number
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                              56
                                           Fax


Data Element                                Fax

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Fax

Description                    Work fax number.
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Should be only numbers
Value
DefaultValue
Owner                          BTI
Based On
Verification
                               Further consideration will be given to a standard
                               approach to the handling of international faxes, but in
                               the meantime only the local telephone code should be
                               held. Including the area code, but excluding the
Comments                       International dialling code.
                               e.g. 02072152406 for a telephone number in London,
                               UK
                               or 0396521670 for a telephone number in Melbourne,
                               Australia.

BTI Data Standards Catalogue Version 1.0                                         57
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0   58
                              Geographic_Region_Id


Data Element                               Geographic_Region_Id

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Geographic_Region_Id

Description                    Location name.
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does this value exist in Region lookup table
                               Australia-New Zealand
                               Baltics
                               Caribbean
                               Caucasus
                               Central Africa
                               Central America
                               Central Asia
Value
                               Central Europe
                               East Africa
                               Eastern Europe
                               Far East
                               Melanesia
                               Micronesia
                               Middle East


BTI Data Standards Catalogue Version 1.0                                      59
                               Near East
                               Nordics
                               North Africa
                               North America
                               Northern Europe
                               Polynesia
                               South America
                               South Asia
                               South East Asia
                               Southern Africa
                               Southern Europe
                               West Africa
                               Western Europe


DefaultValue
Owner                          BTI
Based On
Verification
                               Geographic grouping of markets. Refer to Appendix
Comments                       B for details of the hierarchy of Continents,
                               Geographic Regions and Markets
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                     60
                           Geographic_Region_Name


Data Element                               Geographic_Region_Name

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Geographic_Region_Name

Description                    Long Region Name
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does this value exist in Region lookup table
                               Australia-New Zealand
                               Baltics
                               Caribbean
                               Caucasus
                               Central Africa
                               Central America
                               Central Asia
Value
                               Central Europe
                               East Africa
                               Eastern Europe
                               Far East
                               Melanesia
                               Micronesia
                               Middle East


BTI Data Standards Catalogue Version 1.0                                      61
                               Near East
                               Nordics
                               North Africa
                               North America
                               Northern Europe
                               Polynesia
                               South America
                               South Asia
                               South East Asia
                               Southern Africa
                               Southern Europe
                               West Africa
                               Western Europe


DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0         62
                           Holding_Parent_Org_Name


Data Element                               Holding_Parent_Org_Name

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Holding_Parent_Org_Name

Description                    Parent Organisation name
Business Format                Max Length 100 chars
Element Type and example
                               Data Item - Varchar2(100)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                             63
                                     HQ_Country


Data Element                               HQ_Country

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           HQ_Country

Description                    Country of Organisation's HQ
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Must be a valid BS EN Country
Value
DefaultValue
Owner                          BTI
Based On                       ISO Country or Market
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        64
                                       HS_Code


Data Element                               HS_Code

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           HS_Code

Description                    HMCE Harmonised System (WCE) Customs Codes
Business Format                up to 6 numbers
Element Type and example
                               Data Item - Number(6)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Is the value in the HS_CODE lookup table
Value                          Only the values in the HS_CODE lookup table
DefaultValue
Owner                          HMCE
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                     65
                              HS_Code_Description


Data Element                               HS_Code_Description

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           HS_Code_Description

Description                    HMCE Harmonised System (WCE) Customs Codes
Business Format                Max Length 200
Element Type and example
                               Data Item - Varchar2(200)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Is the value in the HS_CODE lookup table
Value                          Only the values in the HS_CODE lookup table
DefaultValue
Owner                          HMCE
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                     66
                            Invest_Experience_Level


Data Element                                Invest_Experience_Level

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Invest_Experience_Level

Description                    Investment experience level of organisation
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
                               Is the value in the Invest Experience Level lookup
Validations
                               table
Value                          Current, Potential, Not Applicable
DefaultValue
Owner                          BTI
Based On
Verification
                               A current investor is an overseas organisation which
                               has established a subsidiary in the UK.

Comments
                               A potential investor is a company actively looking to
                               expand beyond their home market.


Publication Date               16/07/03


BTI Data Standards Catalogue Version 1.0                                            67
                                 ISO_Alpha2_Code


Data Element                               ISO_Alpha2_Code

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           ISO_Alpha2_Code

Description
Business Format                Max Length 2
Element Type and example
                               Data Item - Char(2)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Against values below
                               http://www.iso.org/iso/en/prods-
Value                          services/iso3166ma/02iso-3166-code-lists/list-
                               en1.html
DefaultValue                   GB
Owner                          ISO
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        68
                                ISO_Country_Code


Data Element                               ISO_Country_Code

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           ISO_Country_Code

Description                    Valid countries and dependencies as export market
Business Format                Max Length 3
Element Type and example
                               Data Item - Char(3)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Against values below
Value                          http://unstats.un.org/unsd/methods/m49/m49alpha.htm
DefaultValue                   GBR
Owner                          ISO
Based On
Verification
                               ISO 3166 Alpha –3 Code.
                               ISO pages link through to the above URL for the UN
                               Statistics Division. And it is the most comprehensive
                               online source for Alpha 3 codes. However, further
Comments                       investigation is necessary as there are discrepancies
                               in terms of the countries listed, between the URL
                               above and the following page on the ISO’s own site
                               which provides Alpha-2 codes.


BTI Data Standards Catalogue Version 1.0                                        69
                               http://www.iso.org/iso/en/prods-
                               services/iso3166ma/02iso-3166-code-lists/list-
                               en1.html

                               BTI are contacting ISO for clarification.


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        70
                                  Job_Department


Data Element                               Job_Department

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Job_Department

Description                    Department for Contact in Organisation
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                71
                                       Job_Title


Data Element                                Job_Title

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Job_Title

Description                    Current position held in organisation (e.g. Director).
Business Format                Max 100 Chars
Element Type and example
                               Data Item - Varchar2(100)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                           72
                                       Language


Data Element                               Language

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Language

Description                    Language
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does the language appear in the ISO 639-1 list?
                               Abkhazian
                               Afar
                               Afrikaans
                               Akan
                               Albanian
                               Amharic
                               Arabic
Value
                               Aragonese
                               Armenian
                               Assamese
                               Auxiliary Language Association
                               Avaric
                               Avestan
                               Aymara


BTI Data Standards Catalogue Version 1.0                                         73
                               Azerbaijani
                               Bambara
                               Bashkir
                               Basque
                               Belarusian
                               Bengali
                               Bihari
                               Bislama
                               Bosnian
                               Breton
                               Bulgarian
                               Burmese
                               Catalan
                               Chamorro
                               Chechen
                               Chewa
                               Chinese
                               Chuvash
                               Cornish
                               Corsican
                               Cree
                               Croatian
                               Czech
                               Danish
                               Divehi
                               Dutch
                               Dzongkha
                               English
                               Esperanto
                               Estonian
                               Ewe
                               Faroese
                               Fijian
                               Finnish
                               Flemish
                               French
                               Frisian
                               Fulah
                               Gaelic
                               Gallegan
                               Ganda
                               Georgian

BTI Data Standards Catalogue Version 1.0     74
                               German
                               Gikuyu
                               Greek
                               Greenlandic
                               Guarani
                               Gujarati
                               Haitian
                               Hausa
                               Hebrew
                               Herero
                               Hindi
                               Hiri Motu
                               Hungarian
                               Icelandic
                               Ido
                               Igbo
                               Indonesian
                               Interlingua (International
                               Interlingue
                               Inuktitut
                               Inupiaq
                               Irish
                               Italian
                               Japanese
                               Javanese
                               Kannada
                               Kanuri
                               Kashmiri
                               Kazakh
                               Khmer
                               Kinyarwanda
                               Kirghiz
                               Komi
                               Kongo
                               Korean
                               Kurdish
                               Lao
                               Latin
                               Latvian
                               Limburgan
                               Lingala
                               Lithuanian

BTI Data Standards Catalogue Version 1.0                    75
                               Luba-Katanga
                               Luxembourgish
                               Macedonian
                               Malagasy
                               Malay
                               Malayalam
                               Maltese
                               Manx
                               Maori
                               Marathi
                               Marshallese
                               Moldavian
                               Mongolian
                               Nauru
                               Navajo
                               Ndebele, North
                               Ndebele, South
                               Ndonga
                               Nepali
                               Northern Sami
                               Norwegian
                               Norwegian Bokmål
                               Nynorsk
                               Ojibwa
                               Oriya
                               Oromo
                               Ossetian
                               Pali
                               Panjabi
                               Persian
                               Polish
                               Portuguese
                               Provençal
                               Pushto
                               Quechua
                               Raeto-Romance
                               Romanian
                               Rundi
                               Russian
                               Samoan
                               Sango
                               Sanskrit

BTI Data Standards Catalogue Version 1.0          76
                               Sardinian
                               Serbian
                               Shona
                               Sichuan Yi
                               Sindhi
                               Sinhalese
                               Slavonic
                               Slovak
                               Slovenian
                               Somali
                               Sotho, Southern
                               Spanish
                               Sundanese
                               Swahili
                               Swati
                               Swedish
                               Tagalog
                               Tahitian
                               Tajik
                               Tamil
                               Tatar
                               Telugu
                               Thai
                               Tibetan
                               Tigrinya
                               Tonga (Tonga Islands)
                               Tsonga
                               Tswana
                               Turkish
                               Turkmen
                               Twi
                               Uighur
                               Ukrainian
                               Urdu
                               Uzbek
                               Venda
                               Vietnamese
                               Volapük
                               Walloon
                               Welsh
                               Wolof
                               Xhosa

BTI Data Standards Catalogue Version 1.0               77
                               Yiddish
                               Yoruba
                               Zhuang
                               Zulu


DefaultValue
Owner                          Library of Congress
Based On
Verification
                               Source: ISO 639-1
                               http://www.loc.gov/standards/iso639-2/englangn.html

                               ISO 639-1, the two-character code, was devised
                               primarily for use in terminology and includes
                               identifiers for most of the major languages of the
Comments                       world that are not only most frequently represented in
                               the total body of the world's literature, but that are
                               also among the most developed languages of the
                               world, having specialized vocabulary and terminology.
                               ISO 639-1 includes identifiers for a subset of the
                               languages covered by ISO 639-2 (which are
                               represented by a 3 character code).


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        78
                                     Last_Validated


Data Element                               Last_Validated

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Last_Validated

Description                    Date record was last validated.
Business Format                UK Format date
Element Type and example
                               Data Item - Date
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    UK Date Format
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                         79
                                   Mail_Bar_Code


Data Element                                 Mail_Bar_Code

Is Part Of

Has Parts

Version                                      1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Mail_Bar_Code

Description                    Used for Bulk Mailings
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          Post Office
Based On                       PAF
Verification
                               Source part of PAF Standard (Postcode Addressable
Comments
                               Format
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                    80
                                  Mail_Sort_Code


Data Element                                 Mail_Sort_Code

Is Part Of

Has Parts

Version                                      1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Mail_Sort_Code

Description                    Used for Bulk Mailings
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(5)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          Post Office
Based On                       PAF
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        81
                                    Market_Desc


Data Element                               Market_Desc

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Market_Desc

Description                    Long Market Name
Business Format                Max 100 Chars
Element Type and example
                               Data Item - Varchar2(100)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does this value exist in Markets lookup
                               The Islamic State of Afghanistan
                               The Republic of Albania
                               The People's Democratic Republic of Algeria
                               Territory of American Samoa
                               The Principality of Andorra
                               The Republic of Angola
                               Anguilla
Value
                               Antarctica
                               Antigua and Barbuda
                               The Argentine Republic
                               The Republic of Armenia
                               Aruba
                               The Commonwealth of Australia
                               The Republic of Austria


BTI Data Standards Catalogue Version 1.0                                     82
                               The Republic of Azerbaijan
                               The Commonwealth of The Bahamas
                               The Kingdom of Bahrain
                               The People's Republic of Bangladesh
                               Barbados
                               The Republic of Belarus
                               The Kingdom of Belgium
                               Belize
                               The Republic of Benin
                               Bermuda
                               The Kingdom of Bhutan
                               The Republic of Bolivia
                               Bosnia and Herzegovina
                               The Republic of Botswana
                               Bouvet Island
                               The Federative Republic of Brazil
                               British Indian Ocean Territory
                               The British Virgin Islands
                               Brunei Darussalam
                               The Republic of Bulgaria
                               Burkina Faso
                               The Union of Myanmar
                               The Republic of Burundi
                               The Kingdom of Cambodia
                               The Republic of Cameroon
                               Canada
                               The Republic of Cape Verde
                               Cayman Islands
                               The Central African Republic
                               The Republic of Chad
                               The Republic of Chile
                               The People's Republic of China
                               Territory of Christmas Island
                               Territory of Cacos (Keeling) Island
                               The Republic of Colombia
                               The Union of the Comoros
                               The Democratic Republic of Congo
                               The Republic of Congo
                               Cook Islands
                               The Republic of Costa Rica
                               The Republic of Croatia
                               The Republic of Cuba

BTI Data Standards Catalogue Version 1.0                             83
                               The Republic of Cyprus
                               The Czech Republic
                               The Kingdom of Denmark
                               The Republic of Djibouti
                               The Commonwealth of Dominica
                               The Dominican Republic
                               Democratic Republic of Timor-Leste
                               The Republic of Ecuador
                               The Arab Republic of Egypt
                               The Republic of El Salvador
                               The Republic of Equatorial Guinea
                               The State of Eritrea
                               The Republic of Estonia
                               The Federal Democratic Republic of Ethiopia
                               Falkland Islands
                               Faroe Islands
                               The Republic of the Fiji Islands
                               The Republic of Finland
                               The French Republic
                               Department of Guiana
                               Territory of French Polynesia
                               Territory of the French Southern and Antarctic Lands
                               The Gabonese Republic
                               The Republic of The Gambia
                               Georgia
                               The Federal Republic of Germany
                               The Republic of Ghana
                               Gibraltar
                               The Hellenic Republic
                               Greenland
                               Grenada
                               Department of Guadeloupe
                               Territory of Guam
                               The Republic of Guatemala
                               The Republic of Guinea
                               The Republic of Guinea Bissau
                               The Co-operative Republic of Guyana
                               The Republic of Haiti
                               Territory of Heard Island and McDonald Islands
                               The Holy See (State of the Vatican City)
                               The Republic of Honduras
                               Hong Kong Special Administrative Region

BTI Data Standards Catalogue Version 1.0                                        84
                               The Republic of Hungary
                               The Republic of Iceland
                               The Republic of India
                               The Republic of Indonesia
                               The Islamic Republic of Iran
                               The Republic of Iraq
                               Ireland
                               The State of Israel
                               The Italian Republic
                               The Republic of Cote d'Ivoire
                               Jamaica
                               Japan
                               The Hashemite Kingdom of Jordan
                               The Republic of Kazakhstan
                               The Republic of Kenya
                               The Republic of Kiribati
                               The Democratic People's Republic of Korea
                               The Republic of Korea
                               The State of Kuwait
                               The Kyrgyz Republic
                               The Lao People's Democratic Republic
                               The Republic of Latvia
                               The Lebanese Republic
                               The Kingdom of Lesotho
                               The Republic of Liberia
                               The Great Socialist People's Libyan Arab Jamahiriya
                               The Principality of Liechtenstein
                               The Republic of Lithuania
                               The Grand Duchy of Luxembourg
                               Macao Special Administrative Region of China
                               The Former Yugoslav Republic of Macedonia
                               The Republic of Madagascar
                               The Republic of Malawi
                               Malaysia
                               The Republic of Maldives
                               The Republic of Mali
                               The Republic of Malta
                               The Republic of the Marshall Islands
                               Department of Martinique
                               The Islamic Republic of Mauritania
                               The Republic of Mauritius
                               Territorial Collectivity of Mayotte

BTI Data Standards Catalogue Version 1.0                                       85
                               The United Mexican States
                               The Federated States of Micronesia
                               The Republic of Moldova
                               The Principality of Monaco
                               Mongolia
                               Montserrat
                               The Kingdom of Morocco
                               The Republic of Mozambique
                               The Republic of Namibia
                               The Republic of Nauru
                               The Kingdom of Nepal
                               The Kingdom of the Netherlands
                               Netherlands Antilles
                               Territory of New Caledonia and Dependencies
                               New Zealand
                               The Republic of Nicaragua
                               The Republic of Niger
                               The Federal Republic of Nigeria
                               Republic of Niue
                               Territory of Norfolk Island
                               Commonwealth of the Northern Mariana Islands
                               The Kingdom of Norway
                               The Sultanate of Oman
                               The Islamic Republic of Pakistan
                               The Republic of Palau
                               The Republic of Panama
                               The Independent State of Papua New Guinea
                               The Republic of Paraguay
                               The Republic of Peru
                               The Republic of the Philippines
                               Pitcairn, Henderson, Ducie and Oeno Islands
                               The Republic of Poland
                               The Portuguese Republic
                               Commonwealth of Puerto Rico
                               The State of Qatar
                               Department of Reunion
                               Romania
                               The Russian Federation
                               The Rwandese Republic
                               The Independent State of Samoa
                               The Republic of San Marino
                               The Democratic Republic of Sao Tome and Principe

BTI Data Standards Catalogue Version 1.0                                    86
                               The Kingdom of Saudi Arabia
                               The Republic of Senegal
                               Serbia and Montenegro
                               The Republic of Seychelles
                               The Republic of Sierra Leone
                               The Republic of Singapore
                               The Slovak Republic
                               The Republic of Slovenia
                               Solomon Islands
                               The Somali Democratic Republic
                               The Republic of South Africa
                               South Georgia and the South Sandwich Islands
                               The Kingdom of Spain
                               The Democratic Socialist Republic of Sri Lanka
                               Saint Helena
                               The Federation of Saint Christopher and Nevis
                               Saint Lucia
                               Territorial Collectivity of Saint Pierre and Miquelon
                               Saint Vincent and the Grenadines
                               The Republic of the Sudan
                               The Republic of Suriname
                               Svalbard and Jan Mayen
                               The Kingdom of Swaziland
                               The Kingdom of Sweden
                               The Swiss Confederation
                               The Syrian Arab Republic
                               The Republic of China
                               The Republic of Tajikistan
                               The United Republic of Tanzania
                               The Kingdom of Thailand
                               The Togolese Republic
                               Tokelau
                               The Kingdom of Tonga
                               The Republic of Trinidad and Tobago
                               The Tunisian Republic
                               The Republic of Turkey
                               Turkmenistan
                               Turks and Caicos Islands
                               Tuvalu
                               The Republic of Uganda
                               Ukraine
                               The United Arab Emirates

BTI Data Standards Catalogue Version 1.0                                           87
                               The United Kingdom of Great Britain and Northern
                               Ireland
                               The United States of America
                               United States Minor Outlying Islands
                               The Oriental Republic of Uruguay
                               The Republic of Uzbekistan
                               The Republic of Vanuatu
                               The Bolivarian Republic of Venezuela
                               The Socialist Republic of Vietnam
                               The United States Virgin Islands
                               Territory of Wallis and Futuna
                               The Occupied Territories
                               Western Sahara
                               The Republic of Yemen
                               The Republic of Zambia
                               The Republic of Zimbabwe


DefaultValue
Owner                          BTI
Based On
Verification
                               BTI has adopted the 239 markets listed on the
                               following site maintained by the ISO.
                               http://www.iso.org/iso/en/prods-
                               services/iso3166ma/02iso-3166-code-lists/list-
                               en1.html
                               This has the advantage of ensuring that all BTI
                               markets can be matched to ISO Alpha-2 and Alpha-3
Comments                       codes. These could in turn be matched to country
                               coded top-level internet domains, and international
                               dialling codes as necessary.
                               However, BTI defers to the FCO, and in particular the
                               Global Information Research Group (GIRG) in terms
                               of the names which should be used to refer to these
                               countries.


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        88
                                       Market_Id


Data Element                               Market_Id

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Market_Id

Description                    Short Market Name
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does this value exist in Markets lookup
                               Afghanistan
                               Albania
                               Algeria
                               American Samoa
                               Andorra
                               Angola
                               Anguilla
Value
                               Antarctica
                               Antigua and Barbuda
                               Argentina
                               Armenia
                               Aruba
                               Australia
                               Austria


BTI Data Standards Catalogue Version 1.0                                 89
                               Azerbaijan
                               Bahamas
                               Bahrain
                               Bangladesh
                               Barbados
                               Belarus
                               Belgium
                               Belize
                               Benin
                               Bermuda
                               Bhutan
                               Bolivia
                               Bosnia and Herzegovina
                               Botswana
                               Bouvet Island
                               Brazil
                               British Indian Ocean Territory
                               British Virgin Islands
                               Brunei
                               Bulgaria
                               Burkina Faso
                               Burma
                               Burundi
                               Cambodia
                               Cameroon
                               Canada
                               Cape Verde
                               Cayman Islands
                               Central African Republic
                               Chad
                               Chile
                               China
                               Christmas Island
                               Cocos (Keeling) Islands
                               Colombia
                               Comoros
                               Congo (Democratic Republic)
                               Congo Republic
                               Cook Islands
                               Costa Rica
                               Croatia
                               Cuba

BTI Data Standards Catalogue Version 1.0                        90
                               Cyprus
                               Czech Republic
                               Denmark
                               Djibouti
                               Dominica
                               Dominican Republic
                               East Timor
                               Ecuador
                               Egypt
                               El Salvador
                               Equatorial Guinea
                               Eritrea
                               Estonia
                               Ethiopia
                               Falkland Islands
                               Faroe Islands
                               Fiji
                               Finland
                               France
                               French Guiana
                               French Polynesia
                               French Southern Territories
                               Gabon
                               Gambia
                               Georgia
                               Germany
                               Ghana
                               Gibraltar
                               Greece
                               Greenland
                               Grenada
                               Guadeloupe
                               Guam
                               Guatemala
                               Guinea
                               Guinea-Bissau
                               Guyana
                               Haiti
                               Heard Island & McDonald Island
                               Holy See (Vatican City)
                               Honduras
                               Hong Kong

BTI Data Standards Catalogue Version 1.0                        91
                               Hungary
                               Iceland
                               India
                               Indonesia
                               Iran
                               Iraq
                               Ireland
                               Israel
                               Italy
                               Ivory Coast
                               Jamaica
                               Japan
                               Jordan
                               Kazakhstan
                               Kenya
                               Kiribati
                               Korea (North)
                               Korea (South)
                               Kuwait
                               Kyrgyzstan
                               Laos
                               Latvia
                               Lebanon
                               Lesotho
                               Liberia
                               Libya
                               Liechtenstein
                               Lithuania
                               Luxembourg
                               Macao
                               Macedonia
                               Madagascar
                               Malawi
                               Malaysia
                               Maldives
                               Mali
                               Malta
                               Marshall Islands
                               Martinique
                               Mauritania
                               Mauritius
                               Mayotte

BTI Data Standards Catalogue Version 1.0          92
                               Mexico
                               Micronesia
                               Moldova
                               Monaco
                               Mongolia
                               Montserrat
                               Morocco
                               Mozambique
                               Namibia
                               Nauru
                               Nepal
                               Netherlands
                               Netherlands Antilles
                               New Caledonia
                               New Zealand
                               Nicaragua
                               Niger
                               Nigeria
                               Niue
                               Norfolk Island
                               Northern Mariana Islands
                               Norway
                               Oman
                               Pakistan
                               Palau
                               Panama
                               Papua New Guinea
                               Paraguay
                               Peru
                               Philippines
                               Pitcairn
                               Poland
                               Portugal
                               Puerto Rico
                               Qatar
                               Reunion
                               Romania
                               Russia
                               Rwanda
                               Samoa
                               San Marino
                               Sao Tome and Principe

BTI Data Standards Catalogue Version 1.0                  93
                               Saudi Arabia
                               Senegal
                               Serbia and Montenegro
                               Seychelles
                               Sierra Leone
                               Singapore
                               Slovakia
                               Slovenia
                               Solomon Islands
                               Somalia
                               South Africa
                               South Georgia and South Sandwich Islands
                               Spain
                               Sri Lanka
                               St Helena
                               St Kitts and Nevis
                               St Lucia
                               St Pierre & Miquelon
                               St Vincent
                               Sudan
                               Surinam
                               Svalbard and Jan Mayen Islands
                               Swaziland
                               Sweden
                               Switzerland
                               Syria
                               Taiwan
                               Tajikistan
                               Tanzania
                               Thailand
                               Togo
                               Tokelau
                               Tonga
                               Trinidad and Tobago
                               Tunisia
                               Turkey
                               Turkmenistan
                               Turks and Caicos Islands
                               Tuvalu
                               Uganda
                               Ukraine
                               United Arab Emirates

BTI Data Standards Catalogue Version 1.0                                  94
                               United Kingdom
                               United States
                               United States Minor Outlying Islands
                               Uruguay
                               Uzbekistan
                               Vanuatu
                               Venezuela
                               Vietnam
                               Virgin Islands (US)
                               Wallis & Futuna
                               West Bank & Gaza
                               Western Sahara
                               Yemen
                               Zambia
                               Zimbabwe


DefaultValue
Owner                          BTI
Based On
Verification
                               BTI has adopted the 239 markets listed on the
                               following site maintained by the ISO.
                               http://www.iso.org/iso/en/prods-
                               services/iso3166ma/02iso-3166-code-lists/list-
                               en1.html
                               This has the advantage of ensuring that all BTI
                               markets can be matched to ISO Alpha-2 and Alpha-3
Comments                       codes. These could in turn be matched to country
                               coded top-level internet domains, and international
                               dialling codes as necessary.
                               However, BTI defers to the FCO, and in particular the
                               Global Information Research Group (GIRG) in terms
                               of the names which should be used to refer to these
                               countries.


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        95
                                           Mobile


Data Element                                Mobile

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Mobile

Description                    Work mobile telephone number.
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Numbers Only
Value
DefaultValue
Owner
Based On                       As GDSC Vol 2 Tel no
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        96
                                   Name_Nat_Lan


Data Element                                Name_Nat_Lan

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Name_Nat_Lan
                               Full name (first, middle and family name) in national
Description
                               language characters
Business Format                Max 150 National Chars
Element Type and example
                               Data Item - Nvarchar2(150)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner
Based On
Verification
Comments                       For local in-country mail addressing
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                          97
                              Org_Abbr_Name_Alias


Data Element                               Org_Abbr_Name_Alias

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Org_Abbr_Name_Alias

Description                    Short, Alias, or Local Organisation Name
Business Format                Max 100 Chars
Element Type and example
                               Data Item - Varchar2(100)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                  98
                               Org_Business_Type


Data Element                               Org_Business_Type

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Org_Busine ss_Type
                               UK Company, Sole Trader, Intermediary, OGD,
Description
                               Charity
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does this value exist in Org_business_type lookup
                               UK Company, Sole Trader, Foreign Company,
Value
                               Intermediary, OGD, Charity
DefaultValue
Owner                          BTI
Based On
Verification



                               SBS                                     BTI
Comments
                               Sole Trader                           Sole Trader
                               Partnership                           UK Company
                               Company – limited by shares           UK Company

BTI Data Standards Catalogue Version 1.0                                       99
                               Company – limited by guarantee       UK Company
                               Unlimited company                    UK Company
                               Public limited company                UK Company
                               Cooperative                          UK Company
                               Charity/not for gain                 Charity
                                                                Foreign Company
                                                                     OGD
                                                                     Intermediary


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                   100
                             Org_Level_Market_Unit


Data Element                               Org_Level_Market_Unit

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Org_Level_Market_Unit
                               BTI International Trade and Development Group
Description                    (ITDG) organisation code e.g. ITDG3a or FCO for
                               Overseas Territories Department
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Is the value in the Markets Lookup table
                               Only the values in the Markets Lookup table
                               ITDG1a
                               ITDG1b
                               ITDG1c
                               ITDG2a
                               ITDG2b
Value                          ITDG2c
                               ITDG2d
                               ITDG2e
                               ITDG3a
                               ITDG3b
                               ITDG3c
                               ITDG4a


BTI Data Standards Catalogue Version 1.0                                     101
                               ITDG4b
                               FCO


DefaultValue
Owner                          BTI
Based On
Verification
                               This is not intended to reflect the entire structure of
Comments                       ITDG, but only those parts of it which deal with
                               specific markets.
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                           102
                             Org_Level_Sector_Unit


Data Element                               Org_Level_Sector_Unit

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Org_Level_Sector_Unit
                               BTI organisation code responsible for one of the 34
Description                    sectors, normally part of International Sectors Group
                               (ISG) e.g. ISG5a
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does this exist in BTI_Sector Lookup
                               ISG1a
                               ISG1b
                               ISG1c
                               ISG1d
                               ISG1e
                               ISG1f
Value                          ISG2a
                               ISG2b
                               ISG2d
                               ISG2e
                               ISG2f
                               ISG3b
                               ISG3c


BTI Data Standards Catalogue Version 1.0                                        103
                               ISG5
                               ISG5h
                               ISG5i
                               ISG5j
                               ITDG1
                               IATC


DefaultValue
Owner                          BTI
Based On
Verification
                               This is not intended to reflect the entire structure of
                               ISG, but only those parts of it which deal with specific
                               sectors. Nor is it intended to reflect where a sector
Comments                       has been subdivided. In two cases, the responsible
                               sections are not actually formal components of ISG.
                               (IATC = International Agriculture Technology
                               College).
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                         104
                                Org_Location_Flag


Data Element                               Org_Location_Flag

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Org_Location_Flag

Description                    UK (Default), Non UK
Business Format                Max 10 Chars
Element Type and example
                               Data Item - Varchar2(10)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    UK or Non_UK
Value                          UK or Non_UK
DefaultValue                   UK
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        105
                            Org_Product_Description


Data Element                               Org_Product_Description

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Org_Product_Description

Description                    Customers own Product Description
Business Format                Max 1000 Chars
Element Type and example
                               Data Item - Varchar2(1000)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                             106
                            Organisation_Description


Data Element                               Organisation_Description

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Organisation_Description

Description                    Customer Provided description of their company
Business Format                Max 254 Chars
Element Type and example
                               Data Item - Varchar(254)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        107
                                Organisation_Name


Data Element                               Organisation_Name

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Organisation_Name

Description                    Name of organisation
Business Format                Max 100 Chars
Element Type and example
                               Data Item - Varchar2(100)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        108
                         Organisation_Name_Nat_Lan


Data Element                               Organisation_Name_Nat_Lan

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Organisation_Name_Nat_Lan
                               Name of organisation in national language
Description
                               (UNICODE) characters
Business Format                Max 200 Chars
Element Type and example
                               Data Item - Nvarchar2(200)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner
Based On
Verification
Comments                       For local in-country mail addressing
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                   109
                                  Person_ Gender


Data Element                                Person_ Gender

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Person_ Gender

Description                    A person's gender
Business Format                1 numeric
Element Type and example
                               Data Item - Number(1)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Must be 0,1,2,9
                               0 = Not Known
                               1 = Male
Value                          2 = Female
                               9 = Not Specified


DefaultValue
Owner                          BTI
Based On                       GDSC Vol 3
Verification
                               Amended from Version 0.8.1 to reflect changes in
                               GDSC.
Comments
                               ‘9’ ‘Not Specified’ means indeterminate, i.e. unable to
                               be classified as either male or female.


BTI Data Standards Catalogue Version 1.0                                         110
                               ‘0’ ‘Not Known’ means that the gender of the person
                               has not been recorded.


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                      111
                              Person_Family_Name


Data Element                                Person_Family_Name

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Person_Family_Name
                               That part of a person’s name (commonly referred to
Description                    as surname or last name) that is used to describe
                               their family, clan, tribal group or marital association
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                          112
                           Person_First_Given_Name


Data Element                               Person_First_Given_Name

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Person_First_Given_Name

Description                    The forename or given name of a person
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                113
                               Person_Name_Suffix


Data Element                               Person_Name_Suffix

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Person_Name_Suffix
                               A textual suffix that may be added to the end of a
Description                    person's name, for example, OBE, MBE, BSc, JP,
                               GM.
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
                               1. The first character of each occurrence must be A -
                               Z.
Validations                    2. Consecutive spaces are not allowed.
                               3. Each occurrence must be separated by a space


Value
DefaultValue
Owner
Based On
Verification
Comments
Publication Date               16/07/03


BTI Data Standards Catalogue Version 1.0                                       114
                         Person_Name_Suffix_Nat_Lan


Data Element                               Person_Name_Suffix_Nat_Lan

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Person_Name_Suffix_Nat_Lan

Description                    Person Suffix in National Language characters
Business Format                Max 40 Chars
Element Type and example
                               Data Item - Nvarchar2(40)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner
Based On
Verification
Comments                       For local in-country mail addressing
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                       115
                         Person_Second_Given_Name


Data Element                               Person_Second_Given_Name

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Person_Second_Given_Name

Description                    second name of contact.
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                              116
                                     Person_Title


Data Element                               Person_Title

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Person_Title

Description                    Contact Salutation as GDSC Vol 2
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                          117
                              Person_Title_Nat_Lan


Data Element                               Person_Title_Nat_Lan

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Person_Title_Nat_Lan

Description                    Salutation in national language characters
Business Format                Max 50 National Language Characters
Element Type and example
                               Data Item - Nvarchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                    118
                       Political_Economic_Grouping_Id


Data Element                               Political_Economic_Grouping_Id

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Political_Economic_Grouping_Id

Description                    Location name.
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does this value exist in Region lookup table
                               AMU
                               Andean Community
                               APEC
                               ASEAN
                               Benelux
                               CARICOM
                               COMESA
Value
                               EAC
                               ECOWAS
                               EEA
                               EFTA
                               EU
                               GCC
                               MERCOSAUR


BTI Data Standards Catalogue Version 1.0                                      119
                               NAFTA
                               NATO
                               OECD
                               SADC


DefaultValue
Owner                          BTI
Based On
Verification
                               This is a list of those Political-Economic Groupings,
                               such as Trade Blocs, which BTI has initially identified
                               as being of interest to its needs.
                               There is no single authoritative and comprehensive
                               source which covers all such groupings and lists their
Comments
                               membership. It is recommended that, for purposes of
                               maintenance, the web sites of the bodies or
                               organisations should be considered as the
                               authoritative source.


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        120
                     Political_Economic_Grouping_Name


Data Element                               Political_Economic_Grouping_Name

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Political_Economic_Grouping_Name

Description                    Long Region Name
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does this value exist in Region lookup table
                               Arab Maghreb Union
                               Andean Community of Nations
                               Association of South East Asian Nations
                               Benelux Economic Union
                               Caribbean Community and Common Market
                               Common Market for Eastern and Southern Africa
                               East African Community
Value                          Economic Community of West African States
                               European Economic Area
                               European Free Trade Association
                               European Union
                               Gulf Co-operation Council
                               Southern Cone Common Market
                               North American Free Trade Association
                               Organisation for Economic Co-operation and

BTI Data Standards Catalogue Version 1.0                                      121
                               Development
                               Southern African Development Community


DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                122
                                       Postcode


Data Element                                Postcode

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Postcode

Description                    Postcode as GDSC Vol 2
Business Format                Max 25 Chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
                               verify against the following formats:
                               AN NAA
                               ANN NAA
Validations                    AAN NAA
                               AANN NAA
                               ANA NAA
                               AANA NAA
                               The letters Q, V and X are not used in the first
                               position.
                               1. The letters I, J and Z are not used in the second
                               position.
Value                          2. The only letters to appear in the third position are
                               A, B,C,D,E,F,G,H,J,K,S,T,U and W.
                               3. The only letters to appear in the fourth position are
                               A, B,E,H,M,N,P,R,V,W,X, and Y.
                               4. The second half of the Postcode is always
                               consistent, numeric, alpha, alpha format and the

BTI Data Standards Catalogue Version 1.0                                          123
                               letters C,I,K,M,O and V are never used.
                               5. GIR 0AA is a Postcode that was issued historically
                               and does not confirm to current rules but is still in use.
DefaultValue
Owner                          PAF
Based On                       GDSC Vol 2
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                           124
                              Postcode_Eq_Nat_Lan


Data Element                               Postcode_Eq_Nat_Lan

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Postcode_Eq_Nat_Lan
                               National Postcode Equivalent in national language
Description
                               (UNICODE) characters
Business Format                Max 40 National language characters
Element Type and example
                               Data Item - Nvarchar2(40)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner
Based On
Verification
Comments                       For local in-country mail addressing
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                      125
                                Preferred_Channel


Data Element                                Preferred_Channel

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Preferred_Channel

Description                    Email (default), Letter, Telex, Portal, Fax
Business Format                Max 10 Chars
Element Type and example
                               Data Item - Varchar2(10)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does this value exist in Preferred Channel Lookup
Value                          Email, Fax, Letter, Telex, Telephone, Portal, Fax
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                       126
                                       Profile_Date


Data Element                               Profile_Date

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Profile_Date

Description                    Date look up profile was taken
Business Format                UK Format date
Element Type and example
                               Data Item - Date
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    UK Format Date
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        127
                                 Referral_Channel


Data Element                                Referral_Channel

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Referral_Channel
                               Channel that contact was referred by - e.g. email,
Description                    portal, magazine, mail shot, add, service provider,
                               organised event
Business Format                Max 25 Chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
                               email, BTI Website, SBS Webs ite, Other Website,
Value                          Magazine, Press advertisement, Press article, Mail
                               shot, Organised event, Personal reference, Other
DefaultValue
Owner                          BTI
Based On
Verification
                               SBS use the following:
                               SBS Website
Comments                       Other Website
                               Personal reference
                               Press article

BTI Data Standards Catalogue Version 1.0                                        128
                               Press advertisement
                               Television
                               Magazine
                               Trade or Professional Journal
                               Other


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                       129
                                     Referred_By


Data Element                               Referred_By

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Referred_By

Description                    Person or Service Provider
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        130
                                     Region_Type


Data Element                               Region_Type

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Region_Type
                               The nature of a grouping of markets: Continent,
Description
                               Geographical Region, Political-Economic Grouping
Business Format                Max 10 Chars
Element Type and example
                               Data Item - Varchar2(10)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
                               Continent, Geographical Region, Political Economic
Value
                               Grouping
DefaultValue
Owner                          BTI
Based On
Verification
                               Refer back to the appropriate page for details of each
                               of these data items. Refer to Appendix B for details
Comments
                               of the hierarchy of Continents, Geographic Regions
                               and Markets
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                        131
                               Regulatory_Country


Data Element                               Regulatory_Country

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Regulatory_Country
                               Regulatory Country e.g. United Kingdom for St
Description
                               Helena
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Must be a valid BS EN (ISO) 3166 Country
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                       132
                                Sector_Description


Data Element                               Sector_Description

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data           Value

Name                Sector_Description

Description         SIC 92 Description
Business Format     Max 200 Chars
Element Type and
example Oracle      Data Item - Varchar2(200)
Type
XML Schema          BTI XML Schema 1 when produced
Validations         A valid sector description Code in ONS’s list of SIC Code descriptions
                    Full details of this code, its uses and a full list of codes and their
Value               meanings can be found at
                    http://www.statistics.gov.uk/themes/compendia_reference/articles/sic.asp
DefaultValue
Owner               ONS
Based On
Verification
Comments
Publication Date    16/07/03




BTI Data Standards Catalogue Version 1.0                                       133
                               Sector_Sub_Description


Data Element                               Sector_Sub_Description

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data           Value

Name                Sector_Sub_Description

Description         Multiple possible sub descriptions for a given SIC 92 Code
Business Format     Max 200 Chars
Element Type and
example Oracle      Data Item - Varchar2(200)
Type
XML Schema          BTI XML Schema 1 when produced
Validations         A valid SIC Code in ONS’s list of SIC Codes
                    Full details of this code, its uses and a full list of codes and their
Value               meanings can be found at
                    http://www.statistics.gov.uk/themes/compendia_reference/articles/sic.asp
DefaultValue
Owner               ONS
Based On
Verification
Comments
Publication Date    16/07/03




BTI Data Standards Catalogue Version 1.0                                         134
                                           SIC_80


Data Element                                  SIC_80

Is Part Of

Has Parts

Version                                       1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data           Value

Name                SIC_80

Description         SIC 80 Code
Business Format     Max 4 numbers
Element Type and
example Oracle      Data Item - Varchar2(4)
Type
XML Schema          BTI XML Schema 1 when produced
Validations         A valid SIC Code in ONS’s list of SIC Codes
                    Full details of this code, its uses and a full list of codes and their
Value               meanings can be found at
                    http://www.statistics.gov.uk/themes/compendia_reference/articles/sic.asp
DefaultValue
Owner               ONS
Based On
Verification
Comments
Publication Date    16/07/03




BTI Data Standards Catalogue Version 1.0                                      135
                                       SIC_Major


Data Element                                  SIC_Major

Is Part Of

Has Parts

Version                                       1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data           Value

Name                SIC_Major

Description         first 4 characters of sic 92 code without the slash
Business Format     4 numbers
Element Type and
example Oracle      Data Item - Varchar2(4)
Type
XML Schema          BTI XML Schema 1 when produced
Validations         A valid SIC Code in ONS’s list of SIC Codes
                    Full details of this code, its uses and a full list of codes and their
Value               meanings can be found at
                    http://www.statistics.gov.uk/themes/compendia_reference/articles/sic.asp
DefaultValue
Owner               ONS
Based On
Verification
Comments
Publication Date    16/07/03




BTI Data Standards Catalogue Version 1.0                                      136
                                      SIC_Minor


Data Element                                  SIC_Minor

Is Part Of

Has Parts

Version                                       1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data           Value

Name                SIC_Minor

Description         5th numeric character or 0
Business Format     1 number
Element Type and
example Oracle      Data Item - Varchar2(1)
Type
XML Schema          BTI XML Schema 1 when produced
Validations         A valid SIC Code in ONS’s list of SIC Codes
                    Full details of this code, its uses and a full list of codes and their
Value               meanings can be found at
                    http://www.statistics.gov.uk/themes/compendia_reference/articles/sic.asp
DefaultValue
Owner               ONS
Based On
Verification
Comments
Publication Date    16/07/03




BTI Data Standards Catalogue Version 1.0                                      137
                                 Tag_Text_Lookup


Data Element                               Tag_Text_Lookup

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Tag_Text_Lookup

Description                    Tag Text used for pointing to Sector
Business Format                Max 100 Chars
Element Type and example
                               Data Item - Varchar2(100)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Does the text exist in BTI_SECTOR_TAG_LOOKUP
Value                          Does the text exist in BTI_SECTOR_TAG_LOOKUP
DefaultValue
Owner                          BTI
Based On
Verification
Comments                       See Appendix A
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                               138
                                Telephone_Number


Data Element                                Telephone_Number

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Telephone_Number
                               Local country telephone number including in-country
Description
                               area code.
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Only numbers no spaces
Value
DefaultValue
Owner                          BTI
Based On
Verification
                               Further consideration will be given to a standard
                               approach to the handling of international calls, but in
                               the meantime only the local telephone code should be
                               held. Including the area code, but excluding the
Comments                       International dialling code.
                               e.g. 02072152406 for a telephone number in London,
                               UK
                               or 0396521670 for a telephone number in Melbourne,

BTI Data Standards Catalogue Version 1.0                                        139
                               Australia.


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0    140
                                           Telex


Data Element                                Telex

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Telex

Description                    Telex Number
Business Format                Max 50 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Only numbers
Value
DefaultValue
Owner                          GDSC
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        141
                               Temp_Address_Until


Data Element                               Temp_Address_Until

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Temp_Address_Until

Description                    Date temp address is valid to
Business Format                UK Format date
Element Type and example
                               Data Item - Date
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    UK Format Date
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        142
                                       Turnover


Data Element                               Turnover

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Turnover

Description                    Turnover of company in sterling
Business Format                unsigned integer num Sterling
Element Type and example
                               Data Item - Number
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    must be an unsigned integer
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                         143
                                     Turnover_Year


Data Element                               Turnover_Year

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Turnover_Year

Description                    Year to which Turnover relates
Business Format                Max 4 integer numbers
Element Type and example
                               Data Item - Number(4)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    must be 4 integers greater than 1900
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                              144
                                 UK_Internal_Code


Data Element                               UK_Internal_Code

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           UK_Internal_Code
                               A unique code representing a constituent internal part
Description                    of the United Kingdom of Great Britain and Northern
                               Ireland
Business Format                Max 2 Numbers
Element Type and example
                               Data Item - Number (2)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
                               1 England
                               2 Scotland
                               3 Wales
                               4 Northern Ireland
                               5 Isle of Man
Value                          6 Guernsey
                               7 Sark
                               8 Jersey
                               9 Alderney
                               10 Channel Islands


DefaultValue



BTI Data Standards Catalogue Version 1.0                                       145
Owner                          OeE
Based On                       As GDSC Vol 3
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0       146
                                      UK_SIC_92


Data Element                                  UK_SIC_92

Is Part Of

Has Parts

Version                                       1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data           Value

Name                UK_SIC_92

Description         Standard Industry Classification 1992 version
Business Format     5 Numbers (If only 4 are quoted add trailing 0)
Element Type and
example Oracle      Data Item - Varchar2(5)
Type
XML Schema          BTI XML Schema 1 when produced
                    A valid SIC Code in ONS’s list of SIC Codes (Only the numbers no
Validations
                    slashes /)
                    Full details of this code, its uses and a full list of codes and their
Value               meanings can be found at
                    http://www.statistics.gov.uk/themes/compendia_reference/articles/sic.asp
DefaultValue
Owner               BTI
Based On
Verification
Comments
Publication Date    16/07/03




BTI Data Standards Catalogue Version 1.0                                      147
                                           URL


Data Element                                 URL

Is Part Of

Has Parts

Version                                      1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           URL

Description                    Web address
Business Format                Max 254 Chars
Element Type and example
                               Data Item - Varchar2(50)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
                               must contain a prefix e.g http:// or ftp:// or https:// or
Validations
                               www as source standard
Value
DefaultValue
Owner                          IETF
Based On
Verification
Comments                       http://www.w3.org/Addressing/URL/URL_TOC.html
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                             148
                                    VAT_Number


Data Element                                VAT_Number

Is Part Of

Has Parts

Version                                     1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           VAT_Number

Description                    Vat Number
Business Format                UK Vat Code must be 9 characters as per GDSC
Element Type and example
                               Data Item - Varchar2(14)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
                               UK VAT Code Must be 9 characters. Modulus97 can
Validations
                               be used to validate the check digits (last two digits).
Value
DefaultValue
Owner                          BTI (HMCE for UK VAT numbers)
Based On
Verification
                               Version 0.8.1 of the catalogue drew upon the GDSC
                               to stipulate the criteria for UK VAT numbers.
                               However, BTI needs to be able to handle international
Comments                       VAT numbers. Following input from FCO and
                               consultation with HMCE the field length has been
                               increased from 9 to 14 characters. It is anticipated
                               that this will be sufficient to handle the varying formats
                               of European Countries, including the preceding ISO


BTI Data Standards Catalogue Version 1.0                                          149
                               Alpha-2 code.
                               e.g.
                               ATVxxxxxxxx
                               BE/AC/Bx/xxxx
                               DExxxxxxxxxx
                               DKxxxxxxxxx
                               Fixxxxxxxxxxxx
                               FRxxxxxExxxx
                               (Where x represents the numeric character).


Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                     150
                                 Verification_Date


Data Element                               Verification_Date

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Verification_Date
                               Date information was last verified with the customer
Description
                               via a letter, email or call
Business Format                UK Format date
Element Type and example
                               Data Item - Date
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value                          Always less than or equal to today.
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                       151
                                  Walk_Sort_Code


Data Element                               Walk_Sort_Code

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Walk_Sort_Code

Description                    Used for Bulk Mailings
Business Format                Max 25 chars
Element Type and example
                               Data Item - Varchar2(25)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations
Value
DefaultValue
Owner                          BTI
Based On                       PAF
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        152
                                 Year_Established


Data Element                               Year_Established

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Year_Established

Description                    Year established
Business Format                Max 4 Numbers
Element Type and example
                               Data Item - Number(4)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Must be 4 numbers
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments                       Perhaps greater than 1900
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                        153
                                     Years_Trading


Data Element                               Years_Trading

Is Part Of

Has Parts

Version                                    1.0

Status

Previous Versions

Later Versions

Date Agreed

Meta Data                      Value

Name                           Years_Trading

Description                    Years Trading
Business Format                Max 3 numbers
Element Type and example
                               Data Item - Number(3)
Oracle Type
XML Schema                     BTI XML Schema 1 when produced
Validations                    Must be unsigned integer less than 999
Value
DefaultValue
Owner                          BTI
Based On
Verification
Comments
Publication Date               16/07/03




BTI Data Standards Catalogue Version 1.0                                154
                        Section 2 - Audit Attributes

Audit attributes should be added to all containers and tables as follows: -

LAST_UPDATED          this is a date / time stamp of the last time the row was inserted
or updated

UPDATED_BY            varchar2 (25). This is the system user or the process that
inserted or updated the row

These attributes will aid audit and enable a delta feed of all that is new or changed
since a date, to be easily produced to better enable synchronisation of data between
systems.




BTI Data Standards Catalogue Version 1.0                                           155
                   Section 3 - Example Data Containers
The intention for this section is to provide useful standardised data structures that
cover key elements of trade relationships. These example data structures give a
starting point for standardised design of BTI and related systems that deal with
Organisation, their Contacts their Products and their classification and the referential
data that are needed to describe and define the trade and investment process, such
as Countries and Sectors.

These core data structures are a starting point from which specialised non-
standardised attributes can be added to deal with the extra functions that many
systems will have.



Data Containers (documented as Oracle tables)

Table Name            Table Description
                      Contact Or Organisation Addresses
       Address
                      Column Name                            Column Is PK     Refer to Data Item
                      Address_Id                             Yes
                      Address_Type                           No               Address_Type
                      Address_String_Nat_Lan                 No               Address_String_Nat_Lan
                      Temp_Address_Until                     No               Temp_Address_Until
                      Address_Verify_Flag                    No               Address_Verify_Flag
                      Address_Line_1                         No               Address_Line
                      Address_Line_2                         No               Address_Line
                      Address_Line_3                         No               Address_Line
                      Address_Line_4                         No               Address_Line
                      Address_Line_5                         No               Address_Line
                      Address_Line_6_Town _ City             No               Address_Line
                      Postcode                               No               Postcode
                      Postcode_Eq_Nat_Lan                                     Postcode_Eq_Nat_Lan
                      UK_Internal_Code                       No               UK_Internal_Code
                      Country                                No               Market_Id
                      Mail_Sort_Code                         No               Mail_Sort_Code
                      Mail_Bar_Code                          No               Mail_Bar_Code
                      Walk_Sort_Code                         No               Walk_Sort_Code
                      English_Region                         No               English_Region
                      Types Of Address
    Address_Type
                      Column Name                              Column Is PK   Refer to Data Item
                      Address_Type                             Yes            Address_Type
                      Organisation / Project Business Sectors.
      Bti_Sector
                      Column Name                            Column Is PK     Refer to Data Item
                      Bti_Sector_Id                          Yes              Bti_Sector_Id
                      Bti_Sector_Name                        No               Bti_Sector_Name
                      Org_Level_Sector_Unit                  No               Org_Level_Sector_Unit
                      Sector_Unit_Contact_Name               No
                      Sector_Unit_Contact_Phone              No               Telephone_No
                      Sector_Unit_Contact_Email              No               Email
                      Sector_Unit_Contact_Fax                No               Fax




BTI Data Standards Catalogue Version 1.0                                                           156
Table Name                 Table Description
                           Textual Metatag Lookups To Point To A
Bti_Sector_Tag_Lookup      Sector
                           Column Name                               Column Is PK   Refer to Data Item
                           Bti_Sector_Id                             Yes            Bti_Sector_Id
                           Tag_Text_Lookup                           Yes            Tag_Text_Lookup
                           Preferred Reply Channel
Communication_Channel
                           Column Name                               Column Is PK   Refer to Data Item
                           Preferred_Channel                         Yes            Preferred_Channel
                           Cross Table Between Contact_Org And
    Contact_Address        Address
                           Column Name                               Column Is PK   Refer to Data Item
                           Contact_Org_Id                            Yes
                           Address_Id                                Yes
                           Contact Languages.
   Contact_Language
                           Column Name                               Column Is PK   Refer to Data Item
                           Language                                  Yes            Language
                           Contact Nationalities.
  Contact_Nationality
                           Column Name                               Column Is PK   Refer to Data Item
                           Contact_Nationality                       Yes            Contact_Nationality
                           Individual Contacts Details That May Be
      Contact_Org          Associated With An Organisation.
                           Column Name                               Column Is PK   Refer to Data Item
                           Contact_Org_Id                            Yes
                           Contact_Id                                No
                           Organisation_Id                           No
                           Contact_Type                              No             Contact_Type
                           Job_Title                                 No             Job_Title
                           Job_Department                            No             Job_Department
                           Telno                                     No             Telephone_No
                           Mobile                                    No             Mobile
                           Fax                                       No             Fax
                           Email                                     No             Email
                           Telex                                     No             Telex
                           Url                                       No             Url
                           Preferred_Language                        No             Language
                           Created_By                                No
                           Database_Source_Code                      No             Database_Source_Code
                           Preferred_Channel                         No             Preferred_Channel
                           Referred_By                               No             Referred_By
                           Referral_Channel                          No             Referral_Channel
                           Market_Country                            No             Market_id
                           Last_Validated                            No             Last_Validated
                           Contacts Names And Personal Details
Contact_Personal_Details
                           Column Name                               Column Is PK   Refer to Data Item
                           Contact_Id                                Yes
                           Person_First_Given_Name                   No             Person_First_Given_Name
                           Person_Second_Given_Name                  No             Person_Second_Given_Name
                           Person_Family_Name                        No             Person_Family_Name
                           Person_Name_Nat_Lan                                      Person_Name_Nat_Lan
                           Person_Title                              No             Person_Title
                           Person_Title_Nat_Lan                                     Person_Title_Nat_Lan
                           Person_Name_Suffix                        No             Person_Name_Suffix
                           Person_Name_Suffix_Nat_Lan                               Person_Name_Suffix_Nat_Lan


BTI Data Standards Catalogue Version 1.0                                                                  157
Table Name               Table Description
                         Person_Gender                          No             Person_Gender
                         Contact_Nationality                    No             Nationality
                         DPA_Int_Marketing                      No             DPA_Int_Marketing
                         DPA_Ext_Marketing                      No             DPA_Ext_Marketing
                         DPA_Oversea_Transfer                   No             DPA_Oversea_Transfer
                         DPA_Change_Date                        No             DPA_Change_Date
                         Type Of Contact
     Contact_Type
                         Column Name                            Column Is PK   Refer to Data Item
                         Contact_Type                           Yes            Contact_Type


                         Contacts And CRM Database Codes
   Database_Source       And Details
                         Column Name                            Column Is PK   Refer to Data Item
                         Database_Source_Code                   Yes            Database_Source_Code


                        Database_Type                           No             Database_Type
                        Database_Name                           No             Database_Name
                        Export Experience Level Of
Export_Experience_Level Organisation
                         Column Name                            Column Is PK   Refer to Data Item
                         Export_Experience_Level                Yes            Export_Experience_Level
                         Current, Intended
  Export_Market_Type
                         Column Name                            Column Is PK   Refer to Data Item
                         Export_Market_Type                     Yes            Export_Market_Type
                         Gender
        Gender
                         Column Name                            Column Is PK   Refer to Data Item
                         Person_Gender                          Yes            Person_Gender
                         Customs And Excise HS Codes
       HS_Code
                         Column Name                            Column Is PK   Refer to Data Item
                         HS_Code                                YES            HS_Code
                         HS_Code_Description                    No             HS_Code_Description
                         Markets E.G., Export Countries
    Market_Country
                         Column Name                            Column Is PK   Refer to Data Item
                         Market_Id                              Yes            Market_Id
                         Market_Desc                            No             Market_Desc
                         Regulatory_Country                     No             Regulatory_Country
                         ISO_Alpha2_Code                        No             ISO_Alpha2_Code
                         ISO_Country_Code                       No             ISO_Country_Code
                         Market_Unit_Contact_Name               No
                         Market_Unit_Contact_Phone              No             Telephone_No
                         Market_Unit_Contact_Email              No             Email
                         Market_Unit_Contact_Fax                No             Fax
                         Int_Group_Org_Code                     No             Int_Group_Org_Code
                         Cross Table Between Organisation And
     Org_Address         Its Address_Ids
                         Column Name                            Column Is PK   Refer to Data Item
                         Organisation_Id                        Yes
                         Address_Id                             Yes
                         Sectors That An Organisation Is
    Org_Bti_Sector       Involved In Or Is Planning An
                         Involvement
                         Column Name                            Column Is PK   Refer to Data Item


BTI Data Standards Catalogue Version 1.0                                                            158
Table Name               Table Description
                         Organisation_Id                           Yes
                         Bti_Sector_Id                             Yes            Bti_Sector_id
                         Business Type. E.G., Organisation, Sole
  Org_Business_Type      Trader, Charity, Intermediary, OGD,
                         Foreign Company
                         Column Name                               Column Is PK   Refer to Data Item
                         Org_Business_Type                         Yes            Org_Business_Type
                         HS_CODES That An Organisation Is
     Org_HS_Code         Involved In Exporting
                         Column Name                               Column Is PK
                         Organisation_Id                           Yes
                         Hs_Code                                   Yes            Hs_Code
                         Export Markets That An Organisation Is
     Org_Markets         Involved In Or Is Considering
                         Column Name                               Column Is PK   Refer to Data Item
                         Organisation_Id                           Yes
                         Export_Market_Type                        Yes            Export_Market_Type
                         Market_Id                                 Yes            Market_Id

      Org_Sectors
                         Column Name                               Column Is PK   Refer to Data Item
                         Organisation_Id                           Yes
                         Uk_Sic_92                                 Yes            Uk_Sic_92
                         Details Of Organisations.
     Organisation
                         Column Name                               Column Is PK   Refer to Data Item
                         Organisation_Id                           Yes
                         Organisation_Name                         No             Organisation_Name
                         Organisation_Name_Nat_Lan                                Organisation_Name_Nat_Lan
                         Org_Abbr_Name_Alias                       No             Org_Abbr_Name_Alias
                         Org_Business_Type                         No             Org_Business_Type
                         Export_Experience_Level                   No             Export_Experience_Level
                         Business_Status_Code                      No             Business_Status_Code
                         Organisation_Description                  No             Organisation_Description
                         Bti_Registration_Num                      No             Bti_Registration_Num
                         Verification_Date                         No             Verification_Date
                         Org_Product_Description                   No             Org_Product_Description
                         Database_Source_Code                      No             Database_Source_Code
                         Bus_Cat_Lookup_Code                       No             Bus_Cat_Lookup_Code
                         Bus_Cat_Db_Name                           No             Bus_Cat_Db_Name
                         Companies_House_Ref_Number                No             Companies_House_Ref_Number
                         Vat_Number                                No             Vat_Number
                         Org_Url                                   No             URL
                         Org_Location_Flag                         No             Org_Location_Flag
                         Organisation Financial And Descriptive
  Organisation_Profile   Information That Is Valid When The
                         Profile Is Retrieved Often From An On-
                         Line Source Such As D & B
                         Column Name                               Column Is PK   Refer to Data Item
                         Organisation_Id                           Yes
                         Holding_Parent_Org_Name                   No             Holding_Parent_Org_Name
                         Year_Established                          No             Year_Established
                         Years_Trading                             No             Years_Trading
                         Employees                                 No             Employees
                         Employees_Year                            No             Employees_Year
                         Turnover                                  No             Turnover
                         Turnover_Year                             No             Turnover_Year
                         Export_Turnover                           No             Export_Turnover
                         Export_Turnover_Year                      No             Export_Turnover_Year


BTI Data Standards Catalogue Version 1.0                                                               159
Table Name           Table Description
                     Bus_Cat_Db_Name                       No             Bus_Cat_Db_Name
                     Bus_Cat_Lookup_Code                   No             Bus_Cat_Lookup_Code
                     Profile_Date                          No             Profile_Date
                     HQ_Country                            No             HQ_Country


                     Continents, Geographical Regions,
        Region       Political-Economic Grouping
                     Column Name                           Column Is PK   Refer to Data Item
                     Region_Id                             Yes            Depending upon the Region_Type,
                                                                          see the appropriate data Item:
                                                                          Continent_Id,
                                                                          Geographic_Region_Id,
                                                                          Political_Economic_Grouping_Id for
                                                                          details and values.
                     Region_Name                           No             Depending upon the Region_Type,
                                                                          see the appropriate data Item:
                                                                          Continent_Name,
                                                                          Geographic_Region_Name, I
                                                                          Political_Economic_Grouping
                                                                          _Name for details and values.
                     Region_Type                           No             Region_Type
                     Markets Within Regions
    Region_Country
                     Column Name                           Column Is PK   Refer to Data Item
                     Market_Id                             Yes            Market_Id
                     Region_Id                             Yes            Depending upon the Region_Type,
                                                                          see the appropriate data Item:
                                                                          Continent_Id,
                                                                          Geographic_Region_Id,
                                                                          Political_Econcomic_Grouping_Id
                                                                          for details and values.
                     Contact Salutation
         Title
                     Column Name                           Column Is PK   Refer to Data Item
                     Person_Title                          Yes            Person_Title
                     Uk Standard Industry Classification
     Uk_SIC_Code     Codes
                     Column Name                           Column Is PK   Refer to Data Item
                     Uk_SIC_92                             Yes            Uk_SIC_92
                     SIC_80                                No             SIC_80
                     Sector_Description                    No             Sector_Description
                     SIC_Major                             No             SIC_Major
                     SIC_Minor                             No             SIC_Minor




BTI Data Standards Catalogue Version 1.0                                                       160
Appendix A: Matching BTI Sectors to SIC codes

This is available on demand as a separate document. (BTI 34 Sectors Mapped to 5
digit SIC codes. Matrix Ref: D03/372926)

The 34 BTI Sectors have been matched to SIC codes, on the basis that the 5 digit
level is recognised as the best set available which provides a reasonably detailed
representation of UK industry.

Metatag Document
SIC codes are sometimes seen as failing to adequately reflect high technology and
some of the creative industries. Therefore, an enhanced version of the document is
in the process of being produced as a metadata resource for Tag Text lookup for BTI.
In this case, where it was felt that there was a gap and that BTI required a term
should be present: such as bluetooth, or nanotechnology, it was added in the most
appropriate location. Some terms were borrowed from the North American Industry
Classification System (NAICS).

http://www.census.gov/epcd/www/naics.html

This document (Meta Tag Document for BTI 34 Sectors Derived from SIC Version
0.1. Matrix Ref: D03/373043) will also be available on request.




BTI Data Standards Catalogue Version 1.0                                         161
Appendix B: Continents, Geographic Regions and Markets
There is no internationally recognised standard for geographical regions of the world.

Governments, Businesses, Institutions, and Organisations invariably group countries
together into regions according to their own business needs and/or world view, but
ambiguity as to which countries fit within which regions is often evident in those areas
where regions blur and overlap.

   •   Mexico, for example, could be viewed as either being within North America or
       within Central America.

   •   Afghanistan could be viewed as being within Central Asia or South Asia.


The following site maintained by the UN Statistics Division offers the neatest
hierarchical view of the geographic regions of the world and is the one used as a
starting point by BTI.

http://unstats.un.org/unsd/methods/m49/m49regin.htm

However, it is open to challenge on a number of points:

   •   Taiwan is omitted from the list
   •   Cyprus is considered to be a part of Western Asia
   •   It omits some territories included in the ISO 3166 standard (remote island
       groups such as the Cocos Islands)
   •   It includes territories which are treated as UK Regions within this catalogue
       and the GDSC. Such as the Channel Islands.

Thus, BTI have deviated from the UN definitions in a number of cases.

In the absence of a truly authoritative standard, BTI accepts geographic groupings
will often be open to challenge, however, this appendix groups all of the markets
listed in the Catalogue into the Continents and Geographic Regions listed in the
Catalogue.




BTI Data Standards Catalogue Version 1.0                                            162
Africa

The UN definition of those countries which constitute Africa (including island groups in the Atlantic and Indian Oceans) has been accepted.
However, there have been deviations from the UN standard in respect of the Geographic Regions, according to BTI’s need.
               1                        2                         3                             4                     5
North Africa             West Africa             Central Africa                   East Africa       Southern Africa

Algeria                  Benin                   Cameroon                         Burundi           Angola
Egypt                    Burkina Faso            Central African Republic         Comoros           Botswana
Libya                    Cape Verde              Chad                             Djibouti          Lesotho
Mauritania               Gambia                  Congo (Democratic Republic)      Eritrea           Mozambique
Morocco                  Ghana                   Congo Republic                   Ethiopia          Namibia
Tunisia                  Guinea                  Equatorial Guinea                Kenya             South Africa
Western Sahara           Guinea-Bissau           Gabon                            Madagascar        Swaziland
                         Ivory Coast             Sao Tome & Principe              Malawi            Zimbabwe
                         Liberia                                                  Mauritius
                         Mali                                                     Mayotte
                         Niger                                                    Reunion
                         Nigeria                                                  Rwanda
                         Senegal                                                  Seychelles
                         Sierra Leone                                             Somalia
                         St Helena                                                Sudan
                         Togo                                                     Tanzania
                                                                                  Uganda
                                                                                  Zambia

1
    UN “Northern Africa” definition plus Mauritania, and omitting Sudan.
2
    UN “Western Africa” definition, omitting Mauritania.
3
    UN “Middle Africa” definition omitting Angola.
4
    UN “Eastern Africa” definition omitting Mozambique and Zimbabwe, and adding Sudan.
5
    UN “Southern Africa” definition plus Angola, Mozambique and Zimbabwe.




BTI Data Standards Catalogue Version 1.0                                                 163
Americas

The UN definition of those countries which constitute the Americas has been accepted with the addition of US Minor Outlying Islands .
                 6                                             7                                       8                          9
North America                                     Caribbean                          Central America           South America

Bermuda                                           Anguilla                           Belize                    Argentina
Canada                                            Antigua and Barbuda                Costa Rica                Bolivia
Greenland                                         Aruba                              El Salvador               Brazil
Mexico                                            Bahamas                            Guatemala                 Chile
Saint Pierre & Miquelon                           Barbados                           Honduras                  Colombia
United States                                     British Virgin Islands             Nicaragua                 Ecuador
United States Minor Outlying Islands              Cayman Islands                     Panama                    Falkland Islands
                                                  Cuba                                                         French Guiana
                                                  Dominica                                                     Guyana
                                                  Dominican Republic                                           Paraguay
                                                  Grenada                                                      Peru
                                                  Guadeloupe                                                   Suriname
                                                  Haiti                                                        Uruguay
                                                  Jamaica                                                      Venezuela
                                                  Martinique
                                                  Montserrat
                                                  Netherlands Antilles
                                                  Puerto Rico
                                                  St Kitts & Nevis


6
    UN “Northern America” definition with the addition of Mexico and US Minor Outlying Islands (Midway etc.)
7
    As per UN “Caribbean” definition.
8
    As per UN “Central America” definition less Mexico.
9
    As per UN “South America” definition.




BTI Data Standards Catalogue Version 1.0                                                   164
                                           St Lucia
                                           St Vincent
                                           Trinidad & Tobago
                                           Turks and Caicos Islands
                                           Virgin Islands (US)




BTI Data Standards Catalogue Version 1.0                              165
Antarctica

This is a BTI definition, covering the Antarctic continent as well as providing a “nesting” for isolated, albeit ISO recognised, island groups in the
South Atlantic and Southern Oceans.

Antarctica
Bouvet Island
French Southern Territories
Heard Island & McDonald Islands
South Georgia & the South Sandwich Islands




BTI Data Standards Catalogue Version 1.0                                             166
Asia

BTI makes a number of deviations from the UN definition of Asia.

The three Caucasus states: Armenia, Azerbaijan, and Georgia, together with Cyprus and Turkey are all considered by BTI to be part of Europe,
rather than Asia. Taiwan had been omitted from the UN definition and is included within the BTI definition, as is British Indian Ocean Territory
(in order to place it within a specific region). The UN sub-regions were not found to be particularly well-suited to BTI needs and so the UN’s
“South-central Asia” and “Western Asia” have been ignored in favour of the first four sub-regions below.
               10                       11                     12                          13                     14                               15
Central Asia             Middle East               Near East                 South Asia                Far East                  South East Asia

Kazakhstan               Bahrain                   Israel                    Afghanistan               China                     Brunei
Kyrgyzstan               Iran                      Jordan                    Bangladesh                Hong Kong                 Burma
Tajikistan               Iraq                      Lebanon                   Bhutan                    Japan                     Cambodia
Turkmenistan             Kuwait                    Syria                     British Indian Ocean      Korea (North)             East Timor
                                                                             Territory
Uzbekistan               Oman                      West Bank & Gaza          India                     Korea (South)             Indonesia
                         Qatar                                               Maldives                  Macao                     Laos
                         Saudi Arabia                                        Nepal                     Mongolia                  Malaysia
                         United Arab Emirates                                Pakistan                  Taiwan                    Philippines
                         Yemen                                               Sri Lanka                                           Singapore
                                                                                                                                 Thailand
                                                                                                                                 Vietnam



10
   Central Asia is a term which is accorded varying definitions. The UN does not use it. In this case BTI defines it as the five former Soviet Republics.
11
   Similarly, Middle East is a term which varies in its scope according to particular sensibilities. In this case BTI defines it as the Arabian Peninsula plus Iran,
Iraq and Kuwait.
12
   Near East is another rather nebulous term, and is sometimes used interchangeably with “The Levant”.
13
   Existing BTI definition plus British Indian Ocean Territory.
14
   UN “Eastern Asia” definition with the addition of Taiwan.
15
   As per UN “South-eastern Asia” definition.




BTI Data Standards Catalogue Version 1.0                                                        167
Europe

BTI accepts the UN definition of Europe, but makes the following additions (which the UN had defined as lying within Asia): Armenia,
Azerbaijan, Georgia, Cyprus, Turkey. The Channel Islands and Isle of Man are omitted, because BTI, and the GDSC, consider them to be part
of the United Kingdom.
                   16                          17                           18                      19
Eastern Europe               Northern Europe            Southern Europe           Western Europe

Armenia                      Denmark                    Albania                   Austria
Azerbaijan                   Estonia                    Andorra                   Belgium
Belarus                      Faroe Islands              Bosnia & Herzegovina      France
Bulgaria                     Finland                    Croatia                   Germany
Czech Republic               Iceland                    Cyprus                    Liechtenstein
Georgia                      Ireland                    Gibraltar                 Luxembourg
Hungary                      Latvia                     Greece                    Monaco
Moldova                      Lithuania                  Holy See (Vatican City)   Netherlands
Poland                       Norway                     Italy                     Switzerland
Romania                      Svalbard & Jan Mayen       Macedonia
Russia                       Sweden                     Malta
Slovakia                     United Kingdom             Portugal
Ukraine                                                 San Marino
                                                        Serbia & Montenegro
                                                        Slovenia
                                                        Spain
                                                        Turkey



16
     UN “Eastern Europe” definition with the addition of Armenia, Azerbaijan and Georgia.
17
     UN “Northern Europe” definition less Channel islands and Isle of Man, which are considered to be part of the UK.
18
     UN “Southern Europe” definition with the addition of Cyprus and Turkey.
19
     As per UN “Western Europe” definition.




BTI Data Standards Catalogue Version 1.0                                                    168
Oceania

BTI accepts the UN Oceania definition, but makes the additions of Christmas Island and Cocos Islands, both of which are in the Indian Ocean
but are administered by Australia.
                          20                     21                        22                        23
Australia-New Zealand                Melanesia                Micronesia                 Polynesia

Australia                            Fiji                     Guam                       American Samoa
Christmas Island                     New Caledonia            Kiribati                   Cook Islands
Cocos (Keeling) Islands              Papua New Guinea         Marshall Islands           French Polynesia
New Zealand                          Solomon Islands          Micronesia                 Niue
Norfolk Island                       Vanuatu                  Nauru                      Pitcairn
                                                              Northern Mariana Islands   Samoa
                                                              Palau                      Tokelau
                                                                                         Tonga
                                                                                         Tuvalu
                                                                                         Wallis and Futuna




20
     UN “Australia and New Zealand” definition with the addition of Christmas Island and Cocos Islands.
21
     As per UN “Melanesia” definition.
22
     As per UN “Micronesia” definition.
23
     As per UN “Polynesia” definition.




BTI Data Standards Catalogue Version 1.0                                                    169
Additional Definitions

Additional regions which might be useful for future database construction.

Nordics                 Baltic States            Caucasus

Denmark                 Estonia                  Armenia
Faroe Islands           Latvia                   Azerbaijan
Finland                 Lithuania                Georgia
Iceland
Norway
Svalbard & Jan Mayen
Sweden




BTI Data Standards Catalogue Version 1.0                                     170

				
DOCUMENT INFO
sushaifj sushaifj http://
About