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 (availability
depends on
licensing options)
Field Names and Descriptions.
| Public Sector Management Data | ContactURN | Unique number for each contact |
| (including PSX format) | OrgURN | Unique Number for each organisation |
| SiteURN | Unique Number for each site within each organisation | |
| OldContactURN | (for users of Oscar data pre August 2009) | |
| OldOrgURN | (for users of Oscar data pre August 2009) | |
| 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) - not used for Schools/GP Surgeries | |
| AllSectors | Functional Field - Combination of the broad functional category fields (eg IT/Computing)- not used for Schools/GP Surgeries | |
| DataTypes | General area of the Government - Local/Regional/Central Government/NHS etc | |
| OrgTypes | Specific type of Organisation - eg NHS Trust / Local Authority | |
| LegalStatus | Used for Further Categorisation of Organisation Types - eg Acute Trust / Metropolitan Council | |
| NumEmployees | Number of Employees employed across the organisation | |
| PopServed | The number of people served by the organisation - primarily used for Local Government | |
| GroupName | Many Housing Associations are managed in Groups - this field shows the Group Name - Housing Associations only | |
| GroupStructure | Shows if the organisation is a Parent within the Group or a subsidiary/partnership - Housing Associations only | |
| NumUnits | Shows the number of Houses/Units owned/managed by the organisation - Local Authorities/Housing Associations only | |
| AnnualSpend | The spend of the organisation, shown in millions. | |
| OrgNotes | Useful information we find about the organisation - forthcoming changes/mergers etc | |
| Schools Data Only | Pupil Roll | The number of Pupils attending the School |
| Parent LEA | LEA Organisation Code - Shows the parent Local Authority | |
| Funding Status | Splitting Schools by State/Private | |
| GP Data Only | Parent PCT | Shows the parent Primary Care Trust |
| Number of Partners | Number of GP Partners within the Practice. |