| Home |
 |
The file layout on the following pages defines the extract file you can download for incorporation into an in-house customer service/inquiry application. A sample of the extract file appears in Appendix C, Troubleshooting Guide.
| Tracking Data (quote and comma-delimited fixed length text strings, LRECL=280) | |||||
| Record Positions |
Field Name |
Size/ Format |
Description |
Example |
Content Rules and Limitations |
|---|---|---|---|---|---|
| 001 | Delimiter | X(1) | Quote delimiter. | " | " |
| 002-023 | Package Identification Code (PIC) | X(22) |
Barcoded label number used to
track the package.
2 alphas - EA 8 digits - sequential number 1 digit - check digit 2 alphas - US |
EA123456782US
__ |
The label numbers must be
from the series of label numbers
provided from the USPS.
This number must be unique for 6 months. Refer to Appendix F for barcode specifications. For Express Mail use the 13-digit numbers provided by USPS; left justify with trailing spaces. |
| 024-026 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 027-048 | Electronic File Number | X(22) | Electronic File Number of the electronic file that included the mailpiece with this Package Identification Code (PIC). Uniquely identifies the electronic file for a given customer for at least 6 months. | GS1-128 |
Taken from Header Record position 004-025. |
| 049-051 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 052-060 | Mailer ID | 9(9) | Mailer ID Number unique to this mailer obtained from USPS. | 941233312 | Numeric value only |
| 061-063 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 064-083 | Mailer Name | X(20) | Mailer name associated with Mailer ID. | ABC Company | Alphanumeric |
| 084-086 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 087-091 | Destination ZIP | 9(5) | Destination ZIP as given by Electronic File. | 33511 | Taken from Detail Record 1 position 027-031. |
| 092-094 | Delimiter | X(3) | Quote, comma, quote delimiter | "," | "," |
| 095-098 | Destination ZIP+4 | X(4) | Destination ZIP+4 as given by Electronic File. | 1857 | Taken from Detail Record 1 position 032-035. |
| 099-101 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 102-106 | Scanning Facility ZIP | 9(5) | If scanning event, 5-digit ZIP Code of facility. If manifest event, entry facility ZIP Code. | 21201 | Valid ZIP Code |
| 107-109 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 110-140 | Scanning Facility Name | X(31) |
Name of postal facility or
city/state where event
happened:
- For MA event (see Event Code in Appendix E), it is the entry facility. - For 01/02 (delivered/attempted), it is the destination city/state. - For anything else, it is the city/state of the postal facility where the event happened. |
blank |
Alphanumeric.
Further defined for city/state event: 28 characters for city, 1 for comma, 2 for state alpha abbreviation. |
| 141-143 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 144-145 | Event Code | X(2) | Code for tracking event. | 01 | See Appendix E for current listing of Event Codes. |
| 146-148 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 149-188 | Event Name | X(40) | Name of tracking event corresponding to event code. | Delivered | Alphanumeric—see Event Code in Appendix E. |
| 189-191 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 192-199 | Event Date | 9(8) | Date of tracking event. |
1998-03-01 Entered as: 19980301 |
YYYYMMDD numeric. Leading zeroes given. |
| 200-202 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 203-206 | Event Time | 9(4) | Time of tracking event. |
13:15 Entered as: 1315 |
HH:MM
Military format and time must be valid. Numeric values (0-9) only. |
| 207-209 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 210-218 | Mailer ID | 9(9) | Client Mailer ID | 941233312 | Taken from Detail Record 1 position 122–130. |
| 219-221 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 222-251 | Customer Reference No. | X(30) | Customer's internal reference number. | 1223ABC | Alphanumeric values. Customer defined. |
| 252-254 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 255-256 | Destination Country Code | X(2) | Code for Destination Country. | GB | Valid Country Code |
| 257-259 | Delimiter | X(3) | Quote, comma, quote delimiter. | "," | "," |
| 260-279 | Recipient Name | X(20) | Name of Recipient. | J DOE | First initial, space, last name |
| 280 | Delimiter | X(1) | Quote delimiter. | " | " |
| 281-282 | Carriage Return Line Feed | X(2) | End-of-record indicator. | blank |
Not a data field. Hex values:
Carriage return = X'0D' Line Feed = X'0A' |