Technical Specifications For MPS ORIGINAL File Formats
 


Output Format

The MPS ORIGINAL file will contain name and address as well as information detailing the action to be taken - whether to remove the individual, include the individual in certain mailings etc.

There are two data file formats - Fixed format and Ascii Comma Delimited.

The file layouts are illustrated below.
 
Position Length Content
1 1 R = remove this person from your mailings
X = deceased person, remove this record from your mailing list
I = this person has requested inclusion in mailings provided they fall into one of the selected interest categories
2 - 9 8 Date of request DDMMCCYY
10 - 17 8 Inclusions - Interest Categories (*this field is left-justified)
A = has requested Category A (Home)
B = has requested Category B (Leisure)
C = has requested Category C (Clothing)
D = has requested Category D (Financial)
E = has requested Category E (Sport)
F = has requested Category F (Travel)
G = has requested Category G (Children)
H = has requested Category H (Community Service)
18 - 23 6 Available for new categories I to N in the future
24 - 27 4 Prefix
28 - 30 3 Initials
31 - 51 21 Surname
52 - 55 4 Suffix
56 - 87 32 Address Line 1
88 - 119 32 Address Line 2
120 - 151 32 Address Line 3
152 - 176 25 Town
177 - 196 20 County
197 - 204 8 Postcode
205 - 206 2 DPS (Delivery Point Suffix)
 
The above record format pertains to the Fixed format data file. The Ascii comma separated format will follow the sequence above with the maximum length indicated by the 'Length' column. Each field in the CSV format will be 'text qualified' with double quotes (")