Patient File Load Examples
The following flat files examples are provided in this section:
- Patient File Enrollment Load ExamplePatient File Enrollment Load Example
- Patient File Unenrollment Load ExamplePatient File Unenrollment Load Example
- Patient Response File ExamplePatient Response File Example
- Patient File Load Error ExamplesPatient File Load Error Examples
- Header Information – Invalid Participant IDHeader Information – Invalid Participant ID
- Detail Information Patient File – File Loaded with ErrorDetail Information Patient File – File Loaded with Error
- Detail Information Patient File – Multiple ErrorsDetail Information Patient File – Multiple Errors
Patient File Enrollment Load Example
The following is an example of a Patient File Load that was successfully processed.
HDR|2.0|T00000000012345|PASSWORD|S00000000000006|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
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|
PAT|4|72.7.2.7272510|43726207|Bell|Catherine|Marcia|||6245 572nd Street||Gholson|WY|82010|19800527|F|199999999|20180908|
PAT|5|72.7.2.7272510|27335157|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 File Unenrollment Load Example
The following is an example of a UNR Patient File Load that was successfully processed.
HDR|2.0|T00000004654294|PASSWORD94|S00000000000006|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|2.0|T00000000012345|S00000000000006|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:
- Invalid Sender ID, does not match the Customer ID
- Invalid Participant Password (Customer Password)
Example:
HDR|2.0|T00000000099999|PASSING|S00000000000006|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|2.0|T00000000099999|S00000000000006|bda2d0fb-f3d2-4d6b-be58-46a2d5255dfb|20181218|23020861|PMA|TRS8804|20181217|00110102|T|03|Invalid HDR and / or TRL. File not loaded.
SDT|1||||E|118The Sender Password provided in the fileload is different than the password provided in the customer activation form.
SDT|1||||E|116|The Sender ID T00000000012345 provided in the header does not match the customer ID T00000000099999 in the activation form.
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:
Record 2 is missing the Date of Birth
Example:
HDR|2.0|T00000000012345|PASSWORD|S00000000000006|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||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|2.0|T00000000012345|S00000000000006|8cb0906a-330d-4bc2-83b4-0459ae87bb46|20181217|09030947|PMA|TRS8804|20181217|00110102|T|02|File loaded with errors.
SDT|3|2|72.7.2.7272510|6756367|E|107|Required column birthDate missing.
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:
- Record 1 has an invalid NPI
- Record 2 is missing the NPI
- Record 3 has an invalid end monitoring date
- Record 4 has an invalid name character count
- Record 5 is missing the Patient Id
Example:
HDR|2.0|T00000000012345|PASSWORD|S00000000000006|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|9999999999|20180908|PMAControlledSubstance,PMANewPrescriber
PNM|2|72.7.2.7272510|6756367|Crandall|Max||MR||382 115th Road SE||Comal|SC|29929|19521101|M||20180908|
PNM|3|72.7.2.7272510|80289003|Valdez|J|Pickle|||2590 388th LN||West Orange|AR|72944|20120316|M|1932400116|202108254|
PMA|4|72.7.2.7272510|75519318|Va|J|P|||2590 388th LN||West Orange|AR|72944|20120316|M|1932400116|20211899|
PMA|5|72.7.2.7272510||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|2.0|T00000000012345|S00000000000006|e61d1e43-a6c2-42e4-a7d8-36c99f7ff9bc|20181219|01022815|PMA|TRS8804|20181217|00110102|T|02|File loaded with errors.
SDT|2|1|72.7.2.7272510|57919598|E|109|Invalid NPI value: 9999999999.
SDT|3|2|72.7.2.7272510|6756367|E|107|Required column npi missing.
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.
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.
SDT|6|5|72.7.2.7272510||E|107|Required column patientId missing.
STR|10|5|5|5