Normalised ASCII (Media 59)

This is a normalised form of the project information, which closely matches the internal structure of Trackbase. Note that some fields are reserved for future use.

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.
Extref String 41 External reference, e.g. town planning reference number.
Date String 8 Report date. Equal to system date at time of generation.
Title String 80 Project title. Brief description of project.
Value String 12 Project valuation.
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.
Geo2 String 10 Secondary geographical coding for site.
Area String 12 Total floor area in square meters.
Close String 8 Tender closing date. Used when applicable.
Cstart String 8 Project start date. Used when applicable.
Units Number 4 Number of units.
Storeys Number 4 Number of storeys.
Ptstatus Number 4 Project status coding.
Ptdesc Memo - Description of project.
Reportdate String 8 Reserved for future use.
Cntrct Number 4 Contract type.
Usage Number 4 Usage type.
Cstart2 String 8 Reserved for future use.
Strt_p Number 4 Start date precision.
Finish String 8 Construction completion date.
Finish_p Number 4 Finish date precision.
Period Number 4 Construction duration in months.
Volume Number 4 Volume of project (for reservoirs etc).
Ssiz Number 4 Site area.
Ground Number 4 Ground floor area.
Value2 String 12 Project valuation (upper boundary).
Crncy Number 4 Value currency.
Valsts Number 4 Value accuracy.
Structs Number 4 Number of structures.
Below Number 4 Number of storeys below ground level.
Parking Number 4 Number of parking spaces.
Rptr Number 4 Reserved for future use.
Agent Number 4 Reserved for future use.
Srce Number 4 Reserved for future use.
Dl String 1 Reserved for future use.
Block String 1 Reserved for future use.
Clang String 10 Reserved for future use.
Svstage Number 4 Reserved for future use.
Svcat Number 4 Reserved for future use.
Svclose String 8 Reserved for future use.
Pttype Number 4 Reserved for future use.
Country2 String 60 Reserved for future use.
Gridreference String 32 Grid reference.
Linear Number 4 Reserved for future use.
Closetm String 8 Reserved for future use.
Close_p Number 4 Reserved for future use.
Intref String 41 Reserved for future use.
Movedate String 8 Date of move. Populated for Business Moves only.
Movedate_p Number 4 Move date precision. Populated for Business Moves only.
Movetype String 4 Move type coding.
Dummy0 String 50 Reserved for future use.
Dummy1 String 8 Reserved for future use.
Dummy2 Number 20 Reserved for future use.

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.
Phone String 32 Phone number.
Fax String 32 Fax number.
Geocode String 10 Geographical code.
Geo2 String 10 Secondary geographical coding.
Status Number 4 Type of company.
Ud String 8 Date company updated.
Subsid_of Number 9 Parent company id.
Suserid Number 2 Reserved for future use.
Reportdate String 8 Reserved for future use.
Email String 60 Company email address.
Telex String 32 Telex number.
Empl Number 4 Number of employees code.
Turn Number 4 Turnover code.
Status Number 4 Company status.
Lang Number 4 Language.
Estd String 8 Date company established.
Mail Number 4 Reserved for future use.
Rptr Number 4 Reserved for future use.
Srce Number 4 Reserved for future use.
Cytype Number 4 Reserved for future use.
Mnemo String 1 Reserved for future use.
Dl String 1 Reserved for future use.
Country2 String 60 Reserved for future use.
Scrpad0 String 80 Reserved for future use.
Scrpad1 String 80 Reserved for future use.
Url String 60 Company URL.
Dummy1 String 8 Reserved for future use.
Dummy2 Number 20 Reserved for future use.

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 String 9 Company id.
Role Number 9 Role code.
Nocy Number 4 Care of code.
Ud String 8 Date row updated.
Deldate String 8 Reserved for future use.
Rd 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 Start date precision.

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.
Lname String 40 Last name.
Fname String 40 First name.
Design String 30 Designation.
Title String 40 Title.
Phone String 32 Phone number.
Ud String 8 Date row updated.
Pnemail String 60 Email address.
Jobfnc Number 4 Reserved for future use.
Dl String 1 Reserved for future use.
Dummy0 String 80 Reserved for future use.
Dummy1 String 8 Reserved for future use.
Dummy2 Number 20 Reserved for future use.

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.

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.
Day String 8 Date entered.

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.

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.
Dummy String 10 Reserved for future use.
Seqno Number 4 Sequence number.
Catunits Number 8 Reserved for future use.

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.

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.
Dummy String 10 Reserved for future use.
Matrtxt String 60 Reserved for future use.
Quantity Number 8 Reserved for future use.
Unit String 10 Reserved for future use.

The entity-relationships are as follows.