Delivery Report File and Field Details

a targeted messaging delivery report is sent to the customer after the submitted file has been processed and the targeted messages have been sent this file contains the records from the targeted messaging file with additional columns that indicate delivery method of each record(s) electronic, fax or mail corresponding message id of delivered messages outcome of address validation for mail delivery other processing errors, when applicable the targeted messaging delivery report will be written to the customer’s ftp account in a folder named from surescripts or other appropriate folder per the customer’s ftp setup file name and format the targeted messaging delivery report file name will be based on the original targeted messaging file name appended with a period (“ ”), followed by a unique processing id, and then rsp this single file will then be added to a compressed archive file the name of the archive file will be the delivery report file name appended with gz example original file name pnlacme2025122101 txt delivery report file name pnlacme2025122101 1235413425555 rsp compressed delivery report file name pnlacme2025122101 1235413425555 rsp gz note each field in the targeted messaging delivery report is delimited by the pipe ( | ) character each line in the file is separated using the line feed ( lf ) character field codes and descriptions throughout the targeted messaging delivery report there are some fields with coding information made available for additional processing and reconciliation by the system which generated the original submission file these fields should be evaluated upon receipt, to determine whether additional follow up is needed or if the outreach made by targeted messaging was sufficient for customers’ needs load status the load status – field 14 in headers – indicates the overall file loading and processing outcome this is different from the individual record status and errors code description 01 the file was loaded and processed no errors were encountered during processing 02 the file was loaded and processed errors were encountered during processing individual records should be reviewed for outcome and to determine further need for processing by the customer 03 the file contained errors and was unable to complete loading individual records will not be included in this delivery report file 04 an error occurred during processing, unrelated to the structure of the file the file can be resubmitted contact surescripts customer support if the issue persists delivery method the delivery method – field 2 in records – indicates if, and how, a message was delivered there are five different codes that may appear, depending on the implementation and information included in the submission file successful delivery code description e this code indicates that the message was delivered electronically using direct messaging f this code indicates that the message was delivered to the fax number indicated in field 3 – delivery fax number the fax will be a pdf of the fax version of the template indicated in the original submission file p this code indicates that the message was delivered to the mailing address indicated in fields 4 8 the printed letter will be a pdf of the mail version of the template indicated in the original submission file note successful message delivery does not preclude errors occurring for a given record delivery status is indicative of the overall message, which may include multiple records refer to combining records to form messages docid\ fqiv18cmwm q0xgvy0m9l for more information about how records are grouped into messages failed delivery code description n this code indicates that the message was created, but no successful delivery was recorded see the error code and error description fields in the delivery report for more information x this code indicates that the record could not be formed into a message for delivery see the error code and error description fields in the delivery report for more information address processing summary the address processing summary – field 9 in records – reflects the outcome of the address normalization and validation process that occurred for a list of possible outcomes, refer to the table found here melissadata address errors https //docs melissa com/cloud api/property/result codes html#address error error codes and descriptions during the validation and processing of a targeted messaging file, there are opportunities for a wide variety of errors to occur the tables below explain what error codes and descriptions may appear in the delivery report file, as well as where in the processing the error can occur please note that pnl refers to standard targeted messaging file and record validation level errors code description explanation 2001 mandatory pnl field is not present or is invalid a field required by the file schema was not provided in the submission file 2003 pnl template not found the template file was not found for a given message recheck the spelling of the template or contact your implementation specialist 3001 pnl could not be delivered by electronic transmission, fax, or postal mail the primary care provider address is not deliverable the record was formed into a message, but that message couldn’t be delivered 3002 max rows on template exceeded row not delivered the message was sent but this record was not included in the supporting evidence due to space limitations found on the template used ensure that the supporting evidence included in files aligns with template limits established during implementation note this error is only applicable for fax and mail messages 9000 an unexpected processing exception occurred the system encountered an unexpected problem during processing of the record note if an error rate of more than 10% occurs, all records that didn’t encounter a more specific error will receive this error 9001 error sending pnl message a message was formed and delivery was attempted however, the message was ultimately unable to be delivered this could be due to ehr systems rejecting the message, invalid/undeliverable fax numbers or an invalid mailing address 9002 system timed out when sending pnl message the message was sent electronically but an acceptance message was not received from the destination ehr system note this error will only occur if the system could not attempt sending the messaging using a different method