Description of Pacifecon CSV File Fields

Field Name

Type

Size

Description

project_id

Text

14

(xxxxx) - The Project ID is a unique identifier.
 

progress_description

Text

50

The progress of the Project (see below for Progress Explanations).
 

init_description

Text

50

Indicates whether the project is new or updated.
 

type_description

Text

50

Denotes the type of project (see below for Types of Projects).
 

categories_description

Text

100

The Code Field is used to separate the projects into different categories or Industry Groups(Specialised Reports). The codes are two letters and multiple codes are separated by spaces. Eg: CA AA BB DA (see Specialised Report Codings  for a full list).
 

estimatedval_value

Text

50

This is our best ESTIMATE based on available information and not all projects have this estimate provided.
 

sort

Text

50

The Name of the Project
 

prde

Text

55

This Field is a short Project Description. It is one or two key words describing what the project is about. Eg: PRISON, RETAIL MALL, OIL REFINERY.
 

cost

Text

50

This field holds the cost of the project. If disclosed.
 

floors

Text

50

Number of Floors.
 

psize

Text

15

Floor Size (square metres).
 

area_description

Text

50

Contains the Region/Area the Project is in.
 

commdate

Text

50

Our best ESTIMATE of when the project will start. Usually Month Year
 

site

Text

55

The town the project is in – eg: Tauranga, or if it is in a main centre-it is the Suburb, City- eg: Mt Roskill, AKL.
 

street

Text

85

The Street the project is in.
 

publ

Text

5

Publication (xx/yy) – Publication number is the number issue followed by the last 2 digits of the year.  Eg:  07/06 means Issue 7 in 2006. 
 

publdate

Date

This is the date the project was entered or updated in our system
 

description

Memo

Here the Project details are entered.
 

startdetail

Text

255

Extra details used to estimate start date. 
 

tenderdate

Date

Closing date for tenders if known.
 

LRdetails

Text

50

Is the last issue the project was reported.
 

UpdateNum

Text

50

How many times the project has been updated.
 

Developer

Text

85

This field contains the Name of the Developer. Then contact details - contact_name, tele, fax, email, address1, address2, address3. address4 where they available.
 

Contractor

Text

55

This field contains the Name of the Contractor. Then what type of contractor they are along with contact details-  contact, position, ddi, email, address1, address2, address3, address4.