Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

SIC Codes

VIEWS: 8 PAGES: 4

									                                                                                                               Database Definition for the Broadband Demand Database




                                                                                                                                                                        Data
    Section                                               Title                                                    Description                                          Type       Length      Mandatory             Validation

                                                    Contact Name         Name of Person we should contact                                                                Char         50          Yes
                               1: Contact Details



                                                    Job Title            Job Title (if you represent a Company or Organisation)                                          Char         50          No
                                                    email                email Address                                                                                   Char         50          No       Must contain @ and .
                                                                                                                                                                                                           Digits, Spaces, Brackets and
                                                    Telephone            Telephone Number                                                                                Char         50          Yes      Hyphens only
                                                                                                                                                                                                           Digits, Spaces, Brackets and
                                                    Mobile               Mobile Telephone Number                                                                         Char         50          No       Hyphens only
                                                    Name                 Name of Business or Organisation (if applicable)                                                Char         50          Yes      None
               Organisation or




                                                    Address1             First Line of Address                                                                           Char         50          Yes      None
               2: Company,

               Individual's




                                                    Address2             Second Line of Address                                                                          Char         50          No       None
                                                    Post Town            Postal Town                                                                                     Char         50          Yes      Cross Check against Postcode
               Details




                                                    County               County                                                                                          Char         50          No       Cross Check against Postcode
                                                    Postcode             Postcode                                                                                        Char          8          Yes      Must be a valid UK Postcode
   Information
   Business




                                                                                                                                                                                                           One from Drop Down List (See
                                                    SIC Section          Standard Industrial Classification - Section                                                    Char         50          Yes      "SIC Codes" below)
   3:




                                                    Employees            Approx number of employees                                                                     Integer

4: Reasons for
Requirements                                        Reasons              Please describe why you are looking to improve your data/voice services.                      Free Text   Unlimited      No

                                                                                                                                                                          long                             Auto-incrementing identity
Primary Key                                         Request ID           (Not shown on web page)                                                                        Integer                   Yes      column

5: Number of                                        No of Installation
Installations                                       Addresses            At how many different addresses would you like to have equipment installed?                    Integer                   Yes




ab8f2818-1a5d-4dd7-8402-e5103a7f4b37.xlsSummary                                                                                     Page 1 of 4                                                                                         REV O
                                                                                                                                                                                                Database Definition for the Broadband Demand Database




                                                                                                                                                                                                                                                                  Data
   Section                                                                                                                                    Title                                                 Description                                                   Type       Length   Mandatory              Validation
                                                                                                                                                                                               The following section to be repeated for each installation address.
                                                                                                                                                          Tick the box if the installation is at the address above, otherwise enter the installation address                                      If ticked then following fields to
                                                                                                                                       Same As Above      below.                                                                                                 Boolean        1        Yes      be left blank.
                                                                                                                                       Address1           First Line of Address                                                                                    Char        50        Yes      None
      6: First Installation




                                                                                                                                       Address2           Second Line of Address                                                                                   Char        50        No       None
                                                                                                                                       Post Town          Postal Town                                                                                              Char        50        Yes      Cross Check against Postcode
      Address




                                                                                                                                       County             County                                                                                                   Char        50        No       Cross Check against Postcode
                                                                                                                                       Postcode           Postcode                                                                                                 Char         8        Yes      Must be a valid UK Postcode

                                                                                                                                                       Quantity of PSTN Telephone Lines, and Company providing each.
                                                                                                                                                       (Public Switched Telephone Network). Traditional analogue lines used for phones, faxes and
            7: Existing Services (this section to be repeated for each installation address)




                                                                                                                                       Analogue (PSTN)
                                                                                                                                                       modems.                                                                                                    Integer,
                                                                                                                                                                                                                                                                    Char                 Yes
                                                                                                                                                       Quantity of ISDN and Company providing each.
                                                                                                                                                       ISDN (Integrated Services Digital Network) is a digital line made up of 2 digital channels each
                                                                                                                                                       with a capacity to send at a speed of 64kbps. These channels can be used separately or in
                                                                                                                                       ISDN Basic Rate
                                                                                               7a: (All Customers)




                                                                                                                                                       conjunction to achieve a speed of 128kbps, e.g. BT Home Highway is an ISDN Basic Rate
                                                                                                                                                       Service                                                                                                    Integer,
                                                                                                                                                                                                                                                                    Char                 Yes
                                                                                                                                                          Quantity of Cable Company connections
                                                                                                                                                          Cable companies provide Cable TV, Internet and Telephony Services through a cable to your
                                                                                                                                       Cable Co.
                                                                                                                                                          location.                                                                                               Integer,
                                                                                                                                                                                                                                                                    Char                 Yes
                                                                                                                                                          Quantity of ADSL Lines and Company providing each.
                                                                                                                                                          ADSL stands for Asymmetric Digital Subscriber Line. It moves data more quickly from exchange
                                                                                                                                                          to customer than from customer to exchange. So it is particularly suitable for applications where
                                                                                                                                       ADSL               customers expect to receive more data than they transmit. ADSL operates over a normal
                                                                                                                                                          telephone line and the signal is carried by two ADS modems - one in the end user's premises
                                                                                                                                                          and one in the local exchange.                                                                          Integer,
                                                                                                                                                                                                                                                                    Char                 Yes
                                                                                                                                                          Quantity of ISDN Primary Rate Connections and Company providing each.
                                                                                               7b: (Businesses / Organisations Only)




                                                                                                                                       ISDN Primary       Using this service up to 30 channels (lines) can be delivered to a customer's premises. This can
                                                                                                                                       Rate               then be used for connection to a Private Exchange (PUB) or to a data device.                            Integer,
                                                                                                                                                                                                                                                                    Char                 Yes
                                                                                                                                                          Quantity of Leased Lines and Company providing each.
                                                                                                                                                          Leased Lines circuits are leased for a fixed tariff and are available in a range of different speeds,
                                                                                                                                       Leased Line
                                                                                                                                                          from 2.4kbit/s to 1,024kbit/s.                                                                          Integer,
                                                                                                                                                                                                                                                                    Char                 Yes
                                                                                                                                                          Quantity of Private Circuits and Company providing each.
                                                                                                                                       Private Ccts       Private Circuits may be used for voice or data. They may be 2 or 4 wire.                                Integer,
                                                                                                                                                                                                                                                                    Char                 Yes
                                                                                                                                                          Quantity of Satellite Transceivers and Company providing each.
                                                                                                                                       Satellite Services Satellite services are used for data, usually in remote areas.                                          Integer,
                                                                                                                                                                                                                                                                    Char                 Yes




ab8f2818-1a5d-4dd7-8402-e5103a7f4b37.xlsSummary                                                                                                                                                                          Page 2 of 4                                                                                           REV O
                                                                                                              Database Definition for the Broadband Demand Database




                                                                                                                                                                             Data
   Section                                                   Title                                                Description                                                Type       Length      Mandatory            Validation

                                                                         Total Bandwidth Required (including existing provision)                                                                                Drop Down list containing:
                  (These sections to be repeated for
   Requirements




                                                                         We will advise you of the options available to upgrade or combine your existing services (if you                                       128kbs, 512kbs, 1Mbps, 2Mbps,
                      each installation address.)
   Installation




                                                       Bandwidth         have any). We will investigate what is offered by all the Telecommunication companies able to                                          5Mbps, 10Mbps, 20Mbps,
   Address




                                                                         deliver services to this location.                                                                                                     50Mbps, 100Mbps, 200Mbps,
   at First




                                                                                                                                                                              Char         50          Yes      500Mbps, 1Gbps
                                                       Voice Lines       Total No. of Voice Telephone Lines (including existing provision)                                   Integer                   Yes

                                                       Internet          Internet                                                                                           Boolean                    yes
   all that
   Usage


   apply)
   (Tick




                                                       Point to Point    Point to Point (e.g. Office to HQ)                                                                 Boolean                    yes
                                                       Private Network   A Private Network of three or more connections                                                     Boolean                    yes

Other                                                  Other
Requirements                                           Requirements      Please describe any other requirements you may have.                                               Free Text   Unlimited      No




ab8f2818-1a5d-4dd7-8402-e5103a7f4b37.xlsSummary                                                                                      Page 3 of 4                                                                                        REV O
                                                                                                              Database Definition for the Broadband Demand Database




The UK Standard Industrial Classification of Economic Activities (UK SIC(92)) is used to classify business establishments and other statistical units by the type of economic
activities in which they are engaged. Alphabetical and numerical lists of typical economic activities showing the UK SIC(92) class or subclass to which Companies and
Organisations should be classified, are below. Website users should select one from this list.

                                              SIC Sections, Subsections and Descriptions
A Agriculture, hunting and forestry
B Fishing
CA Mining and quarrying of energy producing materials
CB Mining and quarrying except energy producing materials
DA Manufacture of food products, beverages and tobacco
DB Manufacture of textiles and textile products
DC Manufacture of leather and leather products
DD Manufacture of wood and wood products
DE Manufacture of pulp, paper and paper products; publishing and printing
DF Manufacture of coke, refined petroleum products and nuclear fuel
DG Manufacture of chemicals, chemical products and man-made fibres
DH Manufacture of rubber and plastic products
DI Manufacture of other non-metallic mineral products
DJ Manufacture of basic metals and fabricated metal products
DO Manufacture of machinery and equipment not elsewhere classified
DL Manufacture of electrical and optical equipment
DM Manufacture of transport equipment
DEN Manufacturing not elsewhere classified
E Electricity, gas and water supply
F Construction
G Wholesale and retail trade; repair of motor vehicles, motorcycles and personal and household goods
H Hotels and restaurants
I Transport, storage and communication
J Financial intermediation
K Real estate, renting and business activities
L Public administration and defence; compulsory social security
M Education
N Health and social work
O Other community, social and personal service activities
P Private households with employed persons
Q Extra-territorial organisations and bodies


                                                                                                                                                                                           Quantity
                                                                                                                                                                                           of
                                                                                                                                                                                           Leased
                                                                                                                                                                                           Lines
                                                                                                                                                                                           and
                                                                                                                                                                                           Company
                                                                                                                                                                                           providing
                                                                                                                                                                                           each.
                                                                                                                                                                                           Leased
                                                                                                                                                                                           Lines
                                                                                                                                                                                           circuits
                                                                                                                                                                                           are
                                                                                                                                                                                           leased for
                                                                                                                                                                                           a fixed
                                                                                                                                                                                           tariff and
                                                                                                                                                                                           are
                                                                                                                                                                                           available
                                                                                                                                                                                           in a range
                                                                                                                                                                                           of
                                                                                                                                                                                           different
                                                                                                                                                                                           speeds,
                                                                                                                                                                                           from
                                                                                                                                                                                           2.4kbit/s
                                                                                                                                                                                           to
                                                                                                                                                                                           1,024kbit/
                                                                                                                                                                                           s.

                                                                                                                                                                                Private Ccts




ab8f2818-1a5d-4dd7-8402-e5103a7f4b37.xlsSIC Codes                                                                                    Page 4 of 4                                                        REV O

								
To top