Normalised ASCII plus (Media 69)

This is an enhancement of the normalised Media 59 format.

All files are in comma-separated format, strings are enclosed in double quotes. Records are separated by new-line. All date-types have the format ‘YYYYMMDD’.

The .pt file contains the project information as follows.

Company File Specification in ASCII Format
Name Type Length Description
Ptno Number 9 Project id. This identity stays with the project throughout its lifetime.
Firstreported Date 8 The first date Barbour ABI reported this project
Lastreported Date 8 The latest date Barbour ABI reported on this project
Rd Date 8 Date research entered the project
Ud Date 8 Date research last update the project
Appdate Date 8 Date of planning application
Extref String 41 External reference, e.g. town planning reference number.
Title String 80 Project title. Brief description of project.
Site1 String 80 Project site address 1.
Site2 String 80 Project site address 2.
Site3 String 80 Project site address 3.
Site4 String 80 Project site address 4.
Pcode String 10 Project postal code.
Country String 60 Country of project.
Geocode String 10 Geographical code for project site. Lookup: GEOCODE
Geo2 String 10 Secondary geographical coding for site. Lookup: GEO2
Gridreference String 32 Grid reference
Easting String 10 Easting of grid reference (not part of standard service)
Northing String 10 Northing of grid reference (not part of standard service)
Confidence String 10 Confidence of grid reference (not part of standard service)
Area Number 6 Total floor area in square meters.
Area_txt String 32 Area for display purposes
Units Number 6 Number of units.
Units_txt String 32 Units for display purposes
Storeys Number 4 Number of storeys.
Storeys_txt String 32 Storeys for display purposes
Below Number 4 Number of storeys below ground level.
Below_txt String 32 Below for display purpsoes
Volume String 12 Volume of project (for reservoirs etc).
Volume_txt String 32 Volume for display purposes
Ssiz String 12 Site area.
Ssiz_txt String 32 Ssiz for display purposes
Ground Number 12 Ground floor area.
Ground_txt String 32 Ground for display purposes
Structs Number 6 Number of structures.
Structs_txt String 32 Structs for display purposes
Parking Number 6 Number of parking spaces
Parking_txt String 32 Parking for display purposes
Linear Number 12 Length of project (e.g. roads)
Linear_txt String 32 Linear for display purposes
Crncy String 4 Value currency.
Value Number 12 Project valuation
Value_txt String 12 Value for display purposes
Value2 Number 12 Project valuation (upper boundary).
Value2_txt String 12 Value2 for display purposes
Valsts Number 2 Value accuracy. Lookup: VALSTS
Startdate Date 8 Construction start date.
Startdate_p Number 2 Accuracy of start date. Lookup: DPREC
Startdate_txt String 32 Start date for display purposes
Finishdate Date 8 Construction completion date
Finishdate_p Number 2 Accuracy of completion date. Lookup: DPREC
Finishdate_txt String 32 Finishdate for display purposes
Closedate Date 8 Tender closing date
Closedate_p Number 2 Accuracy of closing date. Lookup: DPREC
Closedate_txt String 32 Closedate for display purposes
Period Number 4 Length of works (months)
Ptstatus Number 4 Project status
Ptgroup Number 4 Grouping of major projects. Lookup: PTGROUP
Cntrct Number 4 Contract type. Lookup: CNTRCT
Usage Number 4 Usage type. Lookup: USAGE
Status Memo   Status of project
Scheme Memo   Project scheme
Materials Memo   Materials involved in project
Activity Memo   Activities
Stages String 100 Project stage for display purposes
Categories String 500 Categories for display purposes
Devtypes String 100 Development types for display purposes

The .cy file contains the company information as follows.

Company File Specification in ASCII Format
Name Type Length Description
Cyno Number 9 Company id.
Cyname String 100 Company name.
Addr1 String 60 Address line 1.
Addr2 String 60 Address line 2.
Addr3 String 60 Address line 3.
Addr4 String 60 Address line 4.
Pcode String 10 Postal code.
Country String 60 Country.
Geocode String 10 Geographical code. Lookup: GEOCODE
Addr2Geo2 String 10 Secondary geographical coding. Lookup: GEO2
Rd String 8 Date company entered.
Ud String 8 Date company updated.
Subsid_of Number 9 Parent company id.
Phone String 32 Phone number.
Fax String 32 Fax number.
Email String 60 Company email address.
Telex String 32 Telex number.
Url String 60 Company URL
Empl Number 4 Number of employees code. Lookup: EMPL
Turn Number 4 Turnover code. Lookup: TURN
Status Number 4 Company status.
Lang Number 4 Language.
Estd String 8 Date company established.

The .re file contains the role information as follows.

Company File Specification in ASCII Format
Name Type Length Description
Reno Number 9 Role id.
Ptno Number 9 Project id.
Cyno Number 9 Company id.
Role Number 9 Role code. Lookup: ROLE
Nocy Number 4 Care of code.
Rd String 8 Date row created..
Ud String 8 Date row updated.
Value String 17 Value of subcontract.
Narrative String 120 Description of subcontract.
Startdate String 8 Start date of subcontract.
Startdate_p Number 4 Accuracy of start date. Lookup: DPREC
Startdate_txt String 32 Startdate for display purposes

The .pn file contains the person information as follows.

Company File Specification in ASCII Format
Name Type Length Description
Pnno Number 9 Person id.
Cyno Number 9 Company id.
Design String 30 Designation (e.g Mr/Mrs)
Fname String 40 First name.
Lname String 40 Last name.
Title String 40 Title.
Phone String 32 Phone number
Mobile String 32 Mobile number
Email String 60 Email address.
Rd String 8 Date row created
Ud Number 8 Date row updated.

The .cn file contains the contact references as follows.

Company File Specification in ASCII Format
Name Type Length Description
Reno Number 9 Role id.
Pnno Number 9 Person id.

The .cc file contains the SIC codes as follows.

Company File Specification in ASCII Format
Name Type Length Description
Cyno Number 9 Company id.
Class Number 10 Classification. Lookup: CLASS

The .ps file contains the project stages as follows.

Company File Specification in ASCII Format
Name Type Length Description
Ptno Number 9 Project id.
Stage Number 4 Stage of the project. Lookup: STAGE
Day String 8 Date entered.

The .sh file contains the history of project stages. This is as follows.

Company File Specification in ASCII Format
Name Type Length Description
Ptno Number 9 Project id.
Stage Number 4 Stage of the project. Lookup: STAGE
Day String 8 Date project entered this stage

The .pd file contains the development types as follows.

Company File Specification in ASCII Format
Name Type Length Description
Ptno Number 9 Project id.
Devtype Number 4 Type of development. Lookup: DEVTYPE

The .pc file contains the project categories as follows.

Company File Specification in ASCII Format
Name Type Length Description
Ptno Number 9 Project id.
Cat Number 4 Category code. Lookup: CAT
Seqno Number 4 Sequence number.
Catunits Number 8 Units for categories.

The .ba file contains the project activities as follows.

Company File Specification in ASCII Format
Name Type Length Description
Ptno Number 9 Project id.
Class Number 4 Activity code. Lookup: CLASS

The .ml file contains the project materials as follows.

Company File Specification in ASCII Format
Name Type Length Description
Ptno Number 9 Project id.
Material String 10 Material code. Lookup: MATERIAL
Matrtxt String 60 Reserved for future use.
Quantity Number 8 Reserved for future use.
Unit String 10 Reserved for future use.

The .cs file contains the coded values that appear in this data set. All values are supplied for each domain, even if you do not subscribe to all. The table is as follows.

Company File Specification in ASCII Format
Name Type Length Description
Domain String 32 Domain / Lookup
Code String 10 Code.
Parent String 10 Parent of code, if applicable
Text String 60 Label associated with code

The entity-relationships are as follows.