Technical Structure of Data

Oscar data can be supplied in formats suitable for all known databases/spreadsheets, including Excel, Access, dBase and SQL
variants; it is available either by e-mail, on disk or to download through the website. Additional delivery methods are available, please
contact us to discuss further.
Information can also be provided in printed format or on self-adhesive labels as required.

The following technical breakdown of the Oscar database gives details of all the available fields of information (additional fields are provided
for specific organisation types - eg number of Pupils for Schools / Number of GP's within GP Surgeries etc - these depend on the data ordered)

Field Names and Descriptions.

Public Sector Data ContactURN Unique number for each contact
  OrgURN Unique Number for each organisation
SiteURN Unique Number for each site within each organisation
OldOscarContactURN (for users of Oscar data pre January 2011)
OldOscarOrgURN (for users of Oscar data pre January 2011)
OldKeystrokeURN (for users of Keystroke data pre January 2011)
Old KeystrokeOrgURN (for users of Keystroke data pre January 2011)
Title Title of the contact - Mr/Mrs/Ms
Initials  
FirstName  
LastName  
Salutation Form of Address - Mr Smith, Sir John, etc
JobTitle Job Title of the contact
Org Name of Organisation
MainSite Indicates if the person is located at the HQ/Main Site for the organisation
Dept The name of the internal department which the contacts works in
Add1 Address line 1
Add2 Address line 2
Add3 Address line 3
Add4 Address line 4
Town Postal Town
County Postal County
Region Economic Planning Region - eg London / South East / Eastern
Postcode  
ContactPhone The direct number for the contact (if not available the main telephone number)
ContactFax The direct fax number for the contact
ContactEmail The e-mail address of the contact
MainPhone The main telephone/switchboard number for the organisation
MainFax The main fax number for the organisation
MainEmail The main e-mail address for the organisation
Seniority Level of Management of the contact within the organisation
AllCategories Functional Field - Combination of the specific functional category fields (eg Network management)
DataTypes General area of the Government - Local/Regional/Central Government/NHS etc
OrgTypes1 Specific type of Organisation - eg NHS Trust / Local Authority
Org Type 2 Used for Further Categorisation of Organisation Types - eg Acute Trust / Metropolitan Council 
NumEmployees Number of Employees employed across the organisation
AnnualSpend The spend of the organisation, shown in millions.
  URL Website Address for the Organisation
OrgNotes Useful information we find about the organisation - forthcoming changes/mergers etc