Process Address Changes Screen (PACS)

Purpose: Use this screen to process address changes when the ACS Tape or the MBS Tape tables are already loaded with address change information.

For more information: See Loading Address Updates for background.

How to display this screen: Enter PACS in the Fast path field at the top of any menu, or select Process Address Changes from a menu.

Field

Description

Process deliverable addresses only

Indicates whether to process only those names and addresses identified as deliverable.

Valid values are:

Selected = Process only deliverable addresses

Unselected = (default): Process all received records, including those identified as undeliverable.

When processing the records for non-deliverable addresses, the system updates the values in the Mail and Rent fields to unselected. This ensures that you do not send any more catalogs to this address or sell the customer's name to another company.

Change date

The date when the address changes become effective.

The system compares this date against the change date in the Customer Sold To table. If the change date you specify here is:

• later than the change date in the Sold To Customer table: the system applies the name and address change

• earlier than the change date in the Customer Sold To table: the system does not apply the name and address change; instead, the system creates a record in the MBS Address Change table for you to review. Use the Work with Unchanged Customers Screen (MBSF).

Numeric, 6 positions (in user date format); required.

Input file type

Indicates where the address changes are located.

Valid values are:

ACS = The system checks the ACS Tape table for address changes.

MBS = The system checks the MBS Tape table.

Alphanumeric, 3 positions; required.

Completing this screen: Complete each field as indicated above and select Submit to submit address updates. See Process Overview for more information.

MBS and ACS Table Formats

Purpose: This table describes the format of the MBS and ACS Tape tables. The Process Address Changes Screen (PACS) and MBS and ACS Table Formats require tables in one of the formats described below.

 

MBS Tape table (CSMBST)

ACS Tape table (CSACST)

 

Field

Position (From-To)

Length

Position (From-To)

Length

Valid values

Customer #

 

 

17-25

9

 

First name

1-20

20

64-78

15

If the ACS move type (position 39) is set to B (business), then positions 44-87 are not parsed into name components, but are treated as a single 41-character business name field.

Last name

21-40

20

44-63

20

Prefix code

41

1

79-81

3

The MBS format uses a single-position code, whereas the ACS format uses the literal value.

1 = MR

2 = MRS

3 = MIS

4 = DR

5 = REV

6 = SR

7 = MS

8 = FR

9 = CO

* = MR & MRS

& = DR & MRS

Suffix code

42

1

85-87

3

The MBS format uses a single-position code, whereas the ACS format uses the literal value.

A = JR

B = SR

C = MD

D = DDS

E = II

F = III

Address 1

43-72

30

118-177

60

The components of the ACS old address field are parsed as follows:

Field/Position/Size

Primary No./118-127/10

Pre-directional/128-129/2

Street name/130-157/28

Street suffix/158-161/4

Post-directional/162-163/2

Unit designator/164-167/4

Secondary no./168-177/10

If the literal APT, #, SUITE, STE, or UNIT displays after the street address, the system moves this information from Address line 1 to the Apartment field, retaining the literal and any text that follows it. Example: If the street address is 123 MAIN ST SUITE 15, the street address is 123 MAIN ST and the apartment is SUITE 15.

Address 2

73-102

30

City

103-122

20

178-205

28

The first 20 positions of the ACS city maps to the MBS city code.

Filler

123-127

5

 

 

 

State

128-129

2

206-207

2

 

Zip

130-134

5

208-212

5

 

Zip+4

135-138

4

 

 

ACS does not provide old ZIP+4.

Filler

139-150

12

 

 

 

Dwelling code

151

1

40

1

Valid MBS codes:

U = Unknown

S = Single

B = Business

A = Multi with Apartment

M = Multi, with no Apartment. The ACS record does not have a matching field, but a code may derive from the ACS Move type. Valid move types:

- F = Family move (equals U in MBS layout)

- I = Individual move (equals U in MBS layout)

- B = Business (equals B in MBS layout)

Filler

152-158

7

 

 

 

Priority

159-161

3

 

 

No matching ACS field.

Key

162-169

8

 

 

No matching ACS field.

Multi-buyer Code

170

1

 

 

No matching ACS field.

Filler

171-185

15

 

 

 

Zip Level

186-188

3

 

 

No matching ACS field.

Carrier Route

191-194

4

 

 

No matching ACS field.

NCOA Indicator

195

1

37

1

F = Family Move

I = Individual Move

B = Business (ACS code)

If F or I, new address at position 491

Filler

196-198

3

 

 

 

Zap Indicator

199

1

1

1

Valid MBS codes:

X = Undeliverable

Z = Zip Change

If Z, new zip at position 130

If ACS position 38 is set to one of the following values, then this is a “Nixie” record (undeliverable) and the MBS Zap indicator are loaded with a value of X:

 

 

 

 

 

A = attempted, not known

B = returned for better address

C = not deliverable as addressed

D = outside delivery limits

E = in dispute

G = PO box closed

I = insufficient address

K = moved, left no address

L = illegible

M = no mail receptacle

 

 

 

 

 

N = no such number

P = returned for postage

Q = not deliverable as addressed

R = refused

S = no such street

U = unclaimed

V = vacant

W = temporarily away

X = no such office

 

 

 

 

 

The MBS table will not contain COA records reflecting changes only to the ZIP code. A postal customer would not submit a COA form if the zip code changed but he/she did not move, so there would be no COA request to trigger a record in this table.

Note: The first record on the ACS Tape table has an H in this field, indicating that this is a header record and should not be used.

Tier Code

200

1

 

 

No matching ACS field.

Filler

201-233

33

 

 

 

Old Zip Code

234-238

5

208-212

5

 

NCOA Move Date

239-242

4

33-36

4

 

Filler

243-275

33

 

 

 

DT Dwelling Code

276

1

 

 

No matching ACS field.

Old DMT Dwelling Code

277

1

 

 

No matching ACS field.

Old Finalist Dwelling Code

278

1

 

 

No matching ACS field.

Filler

279-364

86

 

 

 

Address Reverse Indicator

365

1

 

 

No matching ACS field.

Filler

366-381

16

 

 

 

String

382-383

2

 

 

No matching ACS field.

Standard Addr1

384-413

30

 

 

No matching ACS field.

Standard Addr2

414-443

30

 

 

No matching ACS field.

Standard City

444-456

13

 

 

No matching ACS field.

Standard State

457-458

2

 

 

No matching ACS field.

Filler

459-478

20

 

 

 

Delivery Point Barcode

479-481

3

342-344

3

 

Filler

482-490

9

 

 

 

New Addr1

491-520

30

244-303

60

The components of the ACS new address field are parsed as follows:

Field/Position/Size

Primary No./244-253/10

Pre-directional/254-255/2

Street name/256-283/28

Street suffix/284-287/4

Post-directional/288-289/2

Unit designator/290-293/4

Secondary no./294-303/10

New Addr2

521-550

30

 

 

New City

551-565

15

304-328

25

 

New State

566-567

2

332-333

2

 

New 9-digit Zip

568-576

9

334-343

10

 

New Carrier Route

577-580

4

 

 

No matching ACS field.

Move Type

581

1

39

1

I = Individual Move

F = Family Move

C = Company Move

B = Business Move

Undeliverable Type

582

1

38

1

C = Not Deliverable

G = Box Closed

K = Moved, Left No Address

F = Moved to Foreign Address

Z = Invalid Postal Record

F = Moved to foreign address

If ' ', zip code or address change

 

 

 

 

 

If ACS position 38 is set to one of the following values, then this is a “Nixie” record (undeliverable), and the MBS Zap indicator will be loaded with a value of X:

A = attempted, not known

B = returned for better address

C = not deliverable as addressed

D = outside delivery limits

E = in dispute

G = PO box closed

 

 

 

 

 

I = insufficient address

K = moved, left no address

L = illegible

M = no mail receptacle

N = no such number

P = returned for postage

Q = not deliverable as addressed

R = refused

S = no such street

U = unclaimed

V = vacant

W = temporarily away

X = no such office

Filler

583-592

 

 

 

 

Customer code

593-601

9

17-25

9

 

 

602-772

 

 

 

Not used by Order Management System.

CSAPP_D OMSCS 19.0 December 2019 OHC