CA (Canada) Base Data Fields - trillium_discovery - trillium_quality - 17.1

Inline Quality and Discovery

Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Inline Quality and Discovery

This table lists the base data fields for Canada.

Field

Description

STREET_NAME

Original street name or street name from the directory when a match was possible.

STREET_TYPE

Ave., Rd., etc. (Appropriate abbreviations used.)

STREET_DIR

N=North/Nord S=South/Sud

E=East/Est W=West

O=Ouest NE=North East/Nord-est

NW=North West NO=Nord-Ouest

SE=South East/Sud-est SW=South West

SO=South Ouest

ADDR_PARITY

Identifies the side or sides of a street for which a given range is applicable.

 

For street, highrise, firm and multi-carrier records: B=Both sides of street, E=Even side of street (even-numbered addresses in the range), O=Odd side of street (odd numbered addresses in range).

HSNO_LOW

Starting house number

HSNO_HIGH

Ending house number

APT_NUM_LOW

Starting Suite number

APT_NUM_HIGH

Ending Suite number

BOX_NUMB_LOW

Starting Box number

BOX_NUMB_HIGH

Ending Box number

ROUTE_TYPE

RR=Rural Route

SS=Suburban Service

MR=Mobile Route

GD=General Delivery

ROUTE_NUM

Number that identifies a rural route, suburban service or mobile route delivery mode.

MISC_DATA

Miscellaneous Data

POSTAL_CODE

Original post code from the input record.

COUNTY

County Name

PTWN_NAME

Post Town Name

INSTALL_NAME

Delivery Installation Name

INSTALL_TYPE

Category of Delivery Installation:

 

BDP=Bureau De Post CC=Concession Commerciale

CDO=Commercial Dealership Outlet CMC=Community Mail Center

CPC=Centre Postal Communautaire CSP=Comptoir Service Postal

LCD=Letter Carrier Depot PDF=Poste Des Facteurs

PO=Post Office RPO=Retail Post Outlet

STN=Station SUCC=Succursale

INSTALL_QUAL

When more than one delivery installation serves and is described by the Delivery Installation Name, the qualifier name uniquely identifies the delivery installation.

ADDR_TYPE

1=Civic (street) address format

2=Delivery installation (station) address format

3=Lock Box Address

4=Route Service Address

5=General Delivery Address

A=Building Name

B=Large Volume Receiver Name (Street)

C=Government Name (Street)

D=Large Volume Receiver Name (Lock Box)

E=Government Name (Lock Box)

F=General Delivery Name

REC_TYPE

1=Street address record

2=Street served by route record

3=Lock box address record

4=Route service address record

5=General delivery address record

A=Building name record

B=Large volume receiver name (Street) record

C=Government name (Street) record

D=Large volume receiver name (Lock box) record

E=Government name (Lock box) record

F=General delivery name record

MORE_THAN_ONE_INSTALL_PC

Multiple installations ( Y or N)