Technical Information Oscar data can be supplied in formats suitable for all known database uses, including Excel/Access, dBase and SQL variants; it is available either by e-mail or on disk. 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 - please click here). Field Types / Field Names and Descriptions. |
||
|
Contact Data |
TITLE |
|
INITIALS |
||
FIRST NAME |
||
LAST NAME |
||
FOA |
Form of Address - Mr Smith, Sir John, etc |
|
JOB_TITLE | Job Title of the contact |
|
ORG |
Name of Organisation |
|
DEPARTMENT | ||
AD1 |
Address line 1 |
|
AD2 |
Address line 2 |
|
AD3 |
Address Line 3 |
|
TOWN |
Postal Town |
|
POSTCODE |
||
REGION |
Economic Planning Region |
|
TELEPHONE |
In the format 01544-340323 |
|
FAX |
In the format 01544-340000 |
|
WEBSITE |
||
SENIORITY |
Level of Management of the contact within the organisation |
|
|
Functional Data |
ALL_CATS |
Functional Field - Combination of 15 individual specific category fields - not used for Schools/GP Surgeries |
ALL_SECTS |
Functional Field - Combination of 15 more general functional fields - not used for Schools/GP Surgeries |
|
|
Organisation Data |
DATA_TYPE |
General Area of the Government - Local/Regional/Central Government/NHS etc |
ORG_TYPE |
Specific Type of Organisation - NHS Trust/PCT/London Borough etc |
|
LEGAL STATUS |
Used for Further Categorisation of Organisation Types - Especially for Central Government and NHS Trusts |
|
EMPLOYEES |
Number of Employees employed across the organisation |
|
Local Government Only |
POP_SERVED |
The number of people served by the organisation |
Housing Associations Only |
NAME OF GROUP |
Many Housing Associations are managed in Groups - this field covers the Group Name |
NUMBER OF UNITS |
This relates to the number of Houses/Units owned/managed by each Housing Association. |
|
Schools Only |
PUPIL ROLL |
The number of Pupils attending the School |
PARENT ORGANISATION |
LEA Organisation Code - Schools are currently the only organisations with this link up |
|
FUNDING STATUS |
Splitting Schools by State/Private |
|
URN |
Contact Unique Record Number |
|
ORGURN |
Organisational Unique Record Number |
|