Patient File Load Examples

the following flat files examples are provided in this section patient file enrollment load example docid\ gjiodrskv1uj7lzy4y4if patient file unenrollment load example docid\ gjiodrskv1uj7lzy4y4if patient response file example docid\ gjiodrskv1uj7lzy4y4if patient file load error examples docid\ gjiodrskv1uj7lzy4y4if patient file load error example header information – invalid participant id docid\ gjiodrskv1uj7lzy4y4if patient file load error example detail information patient file – file loaded with error docid\ gjiodrskv1uj7lzy4y4if patient file load error example detail information patient file – multiple errors docid\ gjiodrskv1uj7lzy4y4if patient file enrollment load example the following is an example of a patient file load that was successfully processed hdr|3 0|t00000000012345|password|s00000000000003|trs8804|20181217|00110102|pma|u|20181217|t|highrisk||12||20240101|20241231 pma|1|72 7 2 7272510|58861323 |jones|robert|jonathan|mr |ii|123 street avenue|unit#41|jacksonville|co|55123|20060701|m|1234567893|20231231|pmanewrx,pmarefill|2025550147 pnm|2|72 7 2 7272510|6756367|crandall|max||mr||382 115th road se||comal|sc|29929|19521101|m|199999999|20180908||| pnm|3|72 7 2 7272510|56800669|mann|adam||dr ||1926 800th st||collingsworth|ne|68178|19700515|m|199999999|20180908||3125550893| pat|4|72 7 2 7272510|43726207|bell|catherine|marcia|||6245 572nd street||gholson|wy|82010|19800527|f|199999999|20180908||4155552764|urn\ oid 72 7 2 7272510 pat|5|72 7 2 7272510|27335157|rogers|steven|||phd|3539 salmon lane e||williamson|nd|58102|19541109|m|199999999|20180908|||urn\ oid 72 7 2 7272510 pma|6|72 7 2 7272510|96067214|flash|dale|||md|8896 arthur lane||pleasanton|gu|96919|19540707|m|199999999|20180908|||urn\ oid 72 7 2 7272510 pma|7|72 7 2 7272510|58861323|kelley|carrie||||1879 madison st||yorktown|pr|00601|20100301|f|199999999|20180908|||urn\ oid 72 7 2 7272510 pma|8|72 7 2 7272510|75519315|kyle|selina||||2048 642nd avenue ne||schleicher|oh|44322|19690326|f|199999999|20180908|pmafirstfillnotpickedup|6465554821|urn\ oid 72 7 2 7272510 pma|9|72 7 2 7272510|90718490|scott|allan|||ii|7017 walleye ave||randall|md|21401|20020409|m|199999999|20180908|||urn\ oid 72 7 2 7272510 pma|10|72 7 2 7272510|80289001|grayson|dick|robin|||5946 90th lane nw||north cleveland|or|97420|20081203|m|199999999|20180908|||urn\ oid 72 7 2 7272510 trl|10 patient file unenrollment load example the following is an example of a unr patient file load that was successfully processed hdr|3 0|t00000004654294|password94|s00000000000003|trnsm030|20170307|10110102|pma|u|20170228|t|pat|| unr|1|pma|20210901 trl|1 patient response file example the following is an example of a patient response file that is sent from surescripts to the customer shd|3 0|t00000000012345|s00000000000003|27cbc136 16c1 489e 84c8 f1e56cd22e9d|20181217|07024411|pma|trs8804|20181217|00110102|t|01|file loaded correctly str|10|0|10|0 patient file load error examples header information – invalid participant id patient file load the patient file load example below contains an error in the header in this example no records were loaded the error has been color coded as follows \<font color="#ca8a04"> invalid sender id, does not match the customer id \</font> \<font color="#2166ae"> invalid participant password (customer password) \</font> example hdr|3 0|t00000000099999| \<font color="#2166ae"> passing \</font> |s00000000000003|trs8804|20181217|00110102|pma|u|20181217|t|highrisk|| pma|1|72 7 2 7272510|57919598|austin|steve||mr||1152 winding ln||trinidad|nj|07101|20021103|m|199999999|20180908| pnm|2|72 7 2 7272510|6756367|crandall|max||mr||382 115th road se||comal|sc|29929|19521101|m|199999999|20180908| trl|2 patient response file the patient response file example below shows an example of an error that will be sent in response to a patient file load that includes errors in the header (e g , invalid participant id, invalid participant password) example shd|3 0|t00000000099999|s00000000000003|bda2d0fb f3d2 4d6b be58 46a2d5255dfb|20181218|23020861|pma|trs8804|20181217|00110102|t|03|invalid hdr and / or trl file not loaded \<font color="#2166ae"> sdt|1||||e|118the sender password provided in the fileload is different than the password provided in the customer activation form \</font> \<font color="#ca8a04"> sdt|1||||e|116|the sender id t00000000012345 provided in the header does not match the customer id t00000000099999 in the activation form \</font> sdt|2|1|72 7 2 7272510|57919598|e|101|no valid contract for record type pma exists sdt|3|2|72 7 2 7272510|6756367|e|101|no valid contract for record type pnm exists str|2|2|0|4 detail information patient file – file loaded with error patient file load in the patient file load example below, record #2 did not include the birthdate column, which is a required field the data in the error has been color coded as follows \<font color="#ca8a04"> record 2 is missing the date of birth \</font> example hdr|3 0|t00000000012345|password|s00000000000003|trs8804|20181217|00110102|pma|u|20181217|t|highrisk||12||20240101|20241231 pma|1|72 7 2 7272510|57919598|austin|steve||mr||1152 winding ln||trinidad|nj|07101|20021103|m|199999999|20180908| pnm|2|72 7 2 7272510|6756367|crandall|max||mr||382 115th road se||comal|sc|29929 \<font color="#ca8a04"> || \</font> m|199999999|20180908| trl|2 patient response file the patient response file example below shows an example of an error that will be sent in response to a patient file load that did not include a required field (e g , date of birth) example shd|3 0|t00000000012345|s00000000000003|8cb0906a 330d 4bc2 83b4 0459ae87bb46|20181217|09030947|pma|trs8804|20181217|00110102|t|02|file loaded with errors \<font color="#ca8a04"> sdt|3|2|72 7 2 7272510|6756367|e|107|required column birthdate missing \</font> str|2|1|1|1 detail information patient file – multiple errors patient file load the patient file load example below contains multiple errors in the detail information patient file the errors have been color coded as follows \<font color="#ca8a04"> record 1 has an invalid npi \</font> \<font color="#b91c1c"> record 2 is missing the npi \</font> \<font color="#15803d"> record 3 has an invalid end monitoring date \</font> \<font color="#ec4899"> record 4 has an invalid name character count \</font> \<font color="#4338ca"> record 5 is missing the patient id \</font> example hdr|3 0|t00000000012345|password|s00000000000003|trs8804|20181217|00110102|pma|u|20181217|t|highrisk||12||20240101|20241231 pma|1|72 7 2 7272510|57919598|austin|steve||mr||1152 winding ln||trinidad|nj|07101|20021103|m| \<font color="#ca8a04"> 9999999999 \</font> |20180908|pmacontrolledsubstance,pmanewprescriber|| pnm|2|72 7 2 7272510|6756367|crandall|max||mr||382 115th road se||comal|sc|29929|19521101|m \<font color="#b91c1c"> || \</font> 20180908||| pnm|3|72 7 2 7272510|80289003|valdez|j|pickle|||2590 388th ln||west orange|ar|72944|20120316|m|1932400116| \<font color="#15803d"> 202108254 \</font> ||| pma|4|72 7 2 7272510|75519318 \<font color="#ec4899"> |va|j|p \</font> |||2590 388th ln||west orange|ar|72944|20120316|m|1932400116|20211899||| pma|5|72 7 2 7272510 \<font color="#4338ca"> || \</font> rogers|steven|||phd|3539 salmon lane e||williamson|nd|58102|19541109|m|199999999|20180908||| pma|6|72 7 2 7272510|96067214|flash|dale|||md|8896 arthur lane||pleasanton|gu|96919|19540707|m|199999999|20180908||| pma|7|72 7 2 7272510|58861323|kelley|carrie||||1879 madison st||yorktown|pr|00601|20100301|f|199999999|20180908||| pma|8|72 7 2 7272510|75519315|kyle|selina||||2048 642nd avenue ne||schleicher|oh|44322|19690326|f|199999999|20180908||| pma|9|72 7 2 7272510|90718490|scott|allan|||ii|7017 walleye ave||randall|md|21401|20020409|m|199999999|20180908||| pma|10|72 7 2 7272510|80289001|grayson|dick|robin|||5946 90th lane nw||north cleveland|or|97420|20081203|m|199999999|20180908||| trl|10 patient response file the patient response file example below shows an example of an error that will be sent in response to a patient file load that contains multiple errors example shd|3 0|t00000000012345|s00000000000003|e61d1e43 a6c2 42e4 a7d8 36c99f7ff9bc|20181219|01022815|pma|trs8804|20181217|00110102|t|02|file loaded with errors \<font color="#ca8a04"> sdt|2|1|72 7 2 7272510|57919598|e|109|invalid npi value 9999999999 \</font> \<font color="#b91c1c"> sdt|3|2|72 7 2 7272510|6756367|e|107|required column npi missing \</font> \<font color="#15803d"> sdt|4|3|72 7 2 7272510|56800669|e|110|invalid format for date field end monitoring date expected 8 digits in the ccyymmdd format actual 20210825 \</font> \<font color="#ec4899"> sdt|5|4|72 7 2 7272510|43726207|e|127|two of a person's names (last name, first name, middle name) must have 2 or more characters \</font> \<font color="#4338ca"> sdt|6|5|72 7 2 7272510||e|107|required column patientid missing \</font> str|10|5|5|5