Business
Solutions
Government
Online Database Service
Database
Updates
The Central Government Database is updated 3-4 times per year, and
the Local Government Database is updated 10-12 times per year (that
includes major and minor updates). The update procedure consists
of one to one contact, information supplied by government employees
themselves, monitoring of official publications, and other internal
methods which we have developed over the past 7 years. All other
databases are updated are intervals from 2-3 times per year.
Availability
of Updates
The Government Online Database is usually supplied on either CD
or DVD. Previously, updates were sent to clients via email, however
emailing clients has recently become impractical due to the size
of the updates (which may be from 10-25 Megabytes). As of 17 April
2008, a new means of delivering updates has been developed – that
of a direct download from the Government Online website. Clients
can enter their username and password to access the download page,
and save databases in either Access or Excel to their personal computers
or workstations. The download section is available at www.government-online.net/databaseupdates.asp.
Database
Structure
2
main tables are utilised: Organisation and Employee. The address
details are in the Organisation table and the individual contact
details are in the Employee table. A third table combining both
Organisation and Employee details into a single table is also included,
for those that prefer to work with one file only.
Organisation Table Fields
Organisation ID
Organisation Name
Address
Town/City
County
Region
Country
Post Code
Telephone
Fax
Website
Email
Source
Secure
Most of the fields are self-explanatory. The Organisation ID is
a static number assigned to a particular address of a particular
organisation. Since one organisation may have several offices with
separate addresses different Organisation IDs are assigned to ensure
that it is possible to identify each one on an individual basis.
The Region field is determined by the government region in which
it is based. The Telephone, Fax and Email fields are listed for
the organisation, and are usually for the reception of central administrative
point of the public body. The Source Field defines the type of organisation
(whether, Central, Local or Regional Government, for instance) and
the Secure Field relates is a technical field for displaying the
database on the Government Online Secure Site.
Employee
Table Fields
Employee ID
Organisation
Position
Title
First Name
Last Name
Telephone
Fax
Email
Notes
Organisation ID
Secure
Category
Source
As
with the Organisation Table, most of the fields are self-explanatory.
The Position field is for the job title, and the Title field is
for the salutation (Mr, Ms, Mrs or Dr, for instance). Telephone,
Fax and Email fields will be individually or departmentally defined,
according to available information. The Category field is occupied
by the Category Description given to it. The Category Field is assigned
to all new databases – it is where an additional descriptive title
is entered to help accurately refine databases searches: Example
categories include Chief Executive, IT and E-Government, Human Resources.
More information on database categories can be found
here.
Next:
Formats
of the Government Online Database
|
