Raw data (Media 27)

The data supplied is split into 3 files. Data in each file has a relationship to the others.

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

The first .dta file below contains only the basic project information, all detail is found in other files.

Company File Specification in ASCII Format
Name Type Length Description
Ptno Number 9 Project id. This identity stays with the project throughout its lifetime.
Date String 10 Report date. Equal to system date at time of generation.
Title String 80 Project title. Brief description of project.
Site0 String 40 Project site address. This field is currently not in use. Reserved for
future use.
Site1 String 40 Project site address.
Site2 String 40 Project site address.
Site3 String 40 Project site address.
Site4 String 40 Project site address.
Country String 40 Project site address.
Pcode String 8 Postal code of project site.
Phone String 32 Site telephone number. This field is currently not in use. Reserved for
future use.
Geocode String 10 Geographical code for project site.
County String 40 County.
Council String 40 Council.
Geo2 String 10 Secondary geographical coding for site.
Value String 16 Project valuation. Low boundary.
Value2 String 16 Project valuation. High boundary.
Currency String 8 Currency of valuation.
Area String 16 Construction area in square metres.
Category String 60 Construction categories. Multiple codes are possible. Codes are
separated by comma.
Stage Number 2 Stage coding.
Stage_txt String 20 Stage en-clair.
Devtype Number 2 Development type coding.
Devtype_txt String 20 Development type en-clair.
Close String 10 Nearest tender closing date. Used when applicable.
Cntrct Number 2 Contract type.
Cstart String 10 Contract start date.
Strt_p Number 2 Start date precision.
Finish String 10 Contract finish date.
Fnsh_p Number 2 Finish date precision.
Period Number 4 Length of works.
Ssiz String 16 Company postal code.
Ground String 16 Plan area in square metres.
Structs Number 4 Number of structures [non-housing].
Units Number 4 Number of housing units.
Storeys Number 4 Number of storeys [above ground].
Below Number 4 Number of storeys [below ground].
Parking Number 4 Car parking spaces.
Materials String 500 Project elements. Multiple codes are possible. Codes are separated by
a comma.
Movedate String 10 Project move date [Business Moves only].
Movedate_p Number 2 Move date precision [Business Moves only].
Units Number 4 Move type [Business Moves only].

The .dtb file contains portions of project textual detail.

Company File Specification in ASCII Format
Name Type Length Description
Ptno Number 9 Project id. Refers to ptno in the dta file.
Type Number 1 Text type tag. 1 for details text, 2 for status text.
Line Number 3 Line number. Each line in the report is numbered to aid proper
regeneration.
Text String 80 Text line of report. Although not all 80 positions are used they are
reserved for future use.

The .dtc contains factor information e.g. owners, architects, contractors and others. Although this is already part of the formatted report in the .dtb file, the contents in this file are formatted to allow further processing.

Company File Specification in ASCII Format
Name Type Length Description
Ptno Number 9 Project id. Refers to ptno in the dta file.
Factor Number 4 Factor coding.
Factor_txt String 20 Factor coding en-clair.
Cyno Number 9 Company id. This identity stays constant across multiple use of the
same address, thus allowing de-duplication for mailing purposes.
Sequence Number 2 Sequence within report.
Design String 20 Designation/salutation for contact person.
Title String 24 Title for contact person.
Fname String 20 First name for contact person.
Lname String 40 Family name for contact person.
Suffix String 8 Reserved for future use.
Name String 40 Company name.
Name2 String 40 Company name [extended].
Addr0 String 40 Company address.Currently not in use. Reserved for future use.
Addr1 String 40 Company address.
Addr2 String 40 Company address.
Addr3 String 40 Company address.
Addr4 String 40 Company address.
Country String 40 Company address.
Pcode String 8 Postal code.
Phone String 32 Telephone number.
Fax Number 32 Telefax number.
Geocode String 10 Geographical coding.
Geo2 Number 10 Secondary geographical coding.
Value String 16 Value of role.
Narrative String 120 Narrative of role.
Startdate Number 10 Start date of role.
Startdate_p Number 2 Start date precision of role.

The entity-relationships are as follows.