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

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

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)