External Address Mapping

Retrieval of address details from the Find Person Address Details form, ENRF3032, requires the mapping of the address details provided by the external party to a Callista Address Type format. This mapping must be set up in the EXT_ADDR_MAP table.

EXT_ADDR_MAP Table

This table has the following columns:

COLUMN NAME	DESCRIPTION
ADDR_TYPE	Contains the address type of the address stored in Callista
ADDRESS_FIELD	Identifies the field in the PERSON_ADDR table the external address element maps to
EXT_ADDR_ELEMENT	The address element from the external system
CONCAT_ORDER	Where more than one external address element is mapped to a Callista address field, the concatenation order number determines the order in which the external address element is written to the Callista address field
PREFIX	When an external address element is returned the prefix symbol is concatenated to the startof the external address element
SUFFIX	When an external address element is returned the suffix symbol is concatenated to the end of the external address element.

Example Set Up

ADDRESS TYPE	CALLISTA ADDRESS FIELD	EXTERNAL ADDRESS ELEMENT	CONCATENATION ORDER	PREFIX SYMBOL	SUFFIX SYMBOL
POSTAL	Address Line 1	Street Number 1	1
POSTAL	Address Line 1	Street Number 2	2	-
POSTAL	Address Line 1	Street Name	3
POSTAL	Address Line 1	Street Type	4
POSTAL	Address Line 2	Suburb	1
POSTAL	Address Line 3	State	1
POSTAL	Postcode	Postcode	1

With this example set up, for External address elements of:

Street Number 1 = 18

Street Number 2 = 22

Street Name = 'SMITH'

Street Type = STREET

Suburb = LONGREACH

State = QLD

Postcode = 4730

The resulting person postal address in ENRF3030 would be:

Address line 1 = 18 - 22 SMITH STREET

Address line 2 = LONGREACH

Address line 3 = QLD

Address line 4 = 4730

Note that a single space will be inserted between concatenated fields and between prefixes/suffixes and fields.

Last Modified on 9 September, 2005