DE (Germany) Base Data Fields - trillium_discovery - trillium_quality - 17.2

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:56:48.630530

This table lists the base data fields for Germany.

Field

Description

STREET_NAME_CAPS

Street name in upper case

STREET_NAME_UL

Street name in mixed case

LOW_NUMB

House number range start

HIGH_NUMB

House number range end

PARITY

Code identifying the side or sides of a street for which a given address range is applicable:

B=Both sides of street

E=Even side (even-numbered addresses in range)

O=Odd side (odd numbered addresses in range)

STR_POST_CODE

Street Level Postal Code

GROSS_ORG_NAME

Organization Name

PLZ_DEST_NAME_CAPS

City name displayed in upper case

PLZ_SING_MULT

Indicates single or multiple post codes.

1=City with single post code

2=City with multiple post codes requiring street/PO box level lookup

PLZ_POST_CODE

City Level Postal Code

ALORT

Sort key for initial table build

HAS_GROSS

Organization flag

HAS_PLZ (Y or N)

Postal flag used in table build

HAS_STR (Y or N)

Street flag used in table build

HAS_POB (Y or N)

Post Office Box used in table build

HAS_SNG (Y or N)

Flag indicating only single postal code

LSA_POST_CODE

Large scale addresses post code