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 | |