Burt Address Manager

Note: Burt requires a separate license fee. Contact the Newscycle Support Center for details.

Targeted Marketing address information can be exported for the Burt Address Manager application. A file map, “BurtMgr”, is used to export address data from Targeted Marketing. This file map has a usage of “TM”.

The entry discount and presort discount are exported to the carrier route (CR) file. Two Business Rules in the Route Services section to allow the entry of this information:

• What entry discount code should be exported to Burt?

• What presort discount code should be exported to Burt?

Note: Contact Naviga Support for assistance in setting up conversion programs.

The Burt Address Manager format is given in the following table.

Burt Address Manager Format

Burt Column	Circ Value	Type	Length	Comment
AX_ID	Address ID	Float (decimal)
ADDR_KEY	Blank	Char	15
ADDRESS_TYPE	Dwelling types mapped to H, A or B in the conversion program.	Char	1	H=Home A=Apt B=Business
CARR_RTE	Address PO Route	Char	4	Postal Carrier Route
WALK_SEQUENCE	PO Route Sequence	Integer
ZIP_CODE	Address Zip	Char	5
ZIP_PLUS4	Zip Extension	Char	4
DPC	Blank	Char	2
STREET_NUMBER	Address House Number	Char	10
APARTMENT_NUMBER	Address Unit Number	Char	10	Unit type is not exported
BUILDING_NUMBER	Address Building	Char	10
STREET_NAME	Address Predirectional + Street Name+ Street Type+ Postdirectional	Char	50
CITY	Address City	Char	50
STATE	Address State	Char	2
LONGITUDE	Address Longitude	Char	11
LATITUDE	Address Latitude	Char	11
CENSUS_BLK	Blank	Char	20
TAP_HD_SUN	Carrier Route ID	Char	10	Burt Ad Route, Sunday
TAP_HD_DLY	Blank	Char	10	Burt Ad Route, Daily
SUB_HD_SUN	Y or N, based on whether occupant’s delivery schedule includes Sunday. This is determined by a conversion program.	Char	1	Y if Sunday subscriber; else N
SUB_HD_DLY	Same as field above, but for daily delivery. This is determined by a conversion program.	Char	1	Y if Daily subscriber; else N
TMC_TYPE	Blank	Char	1	Blank, optional
TMC_PROD	First character of TM product ID	Char	1	Blank, optional
TMC_EDITN	Blank	Char	4	Blank, optional
TMC_ZONE	5-digit Zip	Char	10	Primary Order Entry - Selection (Zip + directional)
SUB_ZIP	Blank	Char	1	Blank, optional
TMC_TG	Blank	Char	2	Blank, optional
TMC_ENTRY	Blank	Char	1	Blank, optional
SI_PRIZM	Blank	Char	2	Prizm demographic code
SI_1	Demographic answer (must modify to select demographic)	Char	2	User-defined selective
SI_2	Blank	Char	2	User-defined selective
Note: SI_2 - SI_15 can be changed to add additional demographics.
SI_3	Blank	Char	2	User-defined selective
SI_4	Blank	Char	2	User-defined selective
SI_5	Blank	Char	2	User-defined selective
SI_6	Blank	Char	2	User-defined selective
SI_7	Blank	Char	2	User-defined selective
SI_8	Blank	Char	2	User-defined selective
SI_9	Blank	Char	2	User-defined selective
SI_10	Blank	Char	2	User-defined selective
SI_11	Blank	Char	2	User-defined selective
SI_12	Blank	Char	2	User-defined selective
SI_13	Blank	Char	2	User-defined selective
SI_14	Blank	Char	2	User-defined selective
SI_15	Blank	Char	2	User-defined selective
Version	0 (zero)	Small int		Use to group address lists by effective date. Set to 0.