Panel History Flat File Examples

the following flat files examples are provided in this section hdr example docid\ eduzsy xldiygaixrshyt dtl (detail) examples docid\ eduzsy xldiygaixrshyt dtl example from pharmacy feed docid\ eduzsy xldiygaixrshyt dtl example from pbm/payer care feed docid\ eduzsy xldiygaixrshyt dtl example from patient not found docid\ eduzsy xldiygaixrshyt dtl example from approved with notes docid\ eduzsy xldiygaixrshyt dtl example of patients with more than 300 medications docid\ eduzsy xldiygaixrshyt trl example docid\ eduzsy xldiygaixrshyt hdr (header) example the following fields are used in the hdr (header) example record type | version | sender id | sender password | receiver id | transmission control number | transmission date | transmission time | transmission file type | field not in use | extract date | usage indicator | patient population id | field not in use | look back period in months | data source type | request start date | request end date hdr (header) example hdr|3 0|d00000000112201|password01|s00000000000003|upmldbrbwc|20241210|08544974|pma| |20241210|t|highrisk| |12|fil|20240603|20241210 dtl (detail) examples the following fields are applicable for the examples in this section detail record type | recordsequencenumber | messageid | senttime | status | note | prescriber npi | prescriber name | patientid | patient last name | patient first name | patient date of birth | patient gender | patient postal code | effective date | expiration date | consent | drugdescription | product code | product code qualifier | strength | drug db coded | drug db code qualifier | form code | form source code | strength source code | strength code | dea schedule | quantitydispensed | codelistqualifier | unit source code | potencyunitcode | dayssupply | directions | refillsvalue | refillsqualifier | substitutions | writtendate | lastfilleddate | solddate | priorauthqualifier | priorauthvalue | ncpdpid | npi | storename | storeaddress line 1 | storeaddress line 2 | city | state | zip | pharmacyphone | pharmacyfaxnumber | npi | dea | state license number | prescriber last name | prescribermiddlename | prescriber first name | prescribernameprefix | prescribernamesuffix | prescriber address line 1 | prescriber address line 2 | city | state | zip | placelocation qualifier | prescriberphone | prescriberfax number | history source qualifier | history source fill number | prescription number | source description | reference id value | reference id qualifier | electronic rx ref number | electronic prescription order number | patientprimaryphonenumber | plancode | paymentcode | bin | pcn | groupid | cardholdernumber | sexassignedatbirth | diagnosisdetails | ndc from pharmacy feed from pharmacy feed dtl|24|12345678 12345543 1234567603128|2020 08 22t22 00 04 361z|approved||1234567899|health and hospital corp|593431|ron|shan|87654321|f|60111|12390822|32100822|y|sertraline 25mg tablets|65862001234|nd|||||||||90|87|ac|c64933|90|tk 1 t po qd|0|rem|0|20191106|20191106|20191106|||1235221|1982610457|walgreens|6123 s 100th st||oak town|az|60456|7086365615||1316251176|md3140326|209007922|rylo|n|mars|||1234 s circle ave||tempe|az|601234915||7737355555|7737354321|p2|00|4321277|walgreens|1235221|3558474261|3971342601962144678|9995551212|||||||||| dtl|28|12345678 12345543 1234567603128|2020 08 22t22 00 04 361z|approved||1234567899|health and hospital corp|593431|ron|shan|87654321|f|60111|12390822|32100822|y|sertraline 50mg tablets|65862001205|nd|||||||||90|87|ac|c64933|90||0|rem|0|20191104|20191104|20191106|||1235221|1982610457|walgreens|6123 s 100th st||oak town|az|60456|1234365615||1710103333|mt1532135|209009999|tuc|jane|laurens|||8124 s circle ave ||tempe|az|60123||7737354321|8888858297|p2|00|1487914|walgreens|1235221|3558474261|3971342601962144678|9995551212|||||||||| from pbm/payer care feed from pharmacy feed dtl|1|12345678 12345543 1234567603128|2020 08 22t22 00 04 09z|approved||1234567899|health and hospital corp|12355|amanda|dirp a|19841024|m|60459|20190822|20200822|y|amox/k clav tab 875 125|12344047801|nd||||c43243||||c38046|20|87|ac|c48321|10|||rem|0|20190922|20190922||||1234257|1407894645|good drug #0021|5555 n ridge||oak tree|az|60123|7085996321||1234719675||||||||||||||||py|00|000007085555||p00000000012345|||||||||| dtl|2|12345678 12345543 1234567603128|2020 08 22t22 00 04 09z|approved||1234567899|health and hospital corp|12355|amanda|dirp a|19841024|m|60459|20190822|20200822|y|azithromycin 250 mg tabs|5432078751|nd|250|||c43243||||c38046|6|87|ac|c48542|5|||rem|0|20190906|20190906||||1408257|1407898888|good drug #0021|5555 n ridge||oak tree|az|60123|1234996300|1234773117|||walt||amit|||||||||1234786865||py|00|000007088321||p00000000012345|||||||||| patient not found patient not found dtl|1|3112345678 12345543 1234567603128|2020 08 22t22 00 03 191z|approved|patient not found |1234567899|health and hospital corp|1234775|anthony|akadious|43211003|m|60123|20190822|20200822|y||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| approved with notes approved with notes dtl|30|12345678 12345543 1234567603128|2020 08 22t22 00 03 896z|approved|although a patient record was found, no medications were available |1234567899|health and hospital corp|1234555|alhadi|meen|12340322|f|12377|43210822|20200822|y||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| dtl|2818|14290519 14484513 1598647191736|2020 08 28t20 40 02 472z|approved|a processing error occurred no medication history was returned |1511111189|health holdings,llc|61pa|ton|will|19400314|m|33411|20190828|20190830|y|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| dtl|39447|14290483 14484513 1598647136790|2020 08 28t20 38 57 492z|approved|patient not found |1561111189|health holdings, llc|5 12|monte|rich|19980129|m|24139|20190828|20200828|y|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| dtl|320|14290491 14484513 1598647137743|2020 08 28t20 39 06 637z|approved|not all medication history sources were accessible at this time |151111189|health holdings, llc|6 1bao|addo|ing|19400314|m|33411|20190828|20200828|y|halobetasol propionate 0 5 mg/ml topical cream|45802012932|nd|0 5|977990|scd|c91187|||||75|87|ac|c28253|29||||0|20200729|20200729||||||||||||||||||||||||||||||py||||p00000000012345|||||||||| patients with more than 300 medications the first 300 medications of a patient will have the same messageid and the additional medications will be in a different messageid patients with more than 300 medications dtl|300|14290489 14484513 1598647137503|2020 08 28t20 38 59 429z|approved||1561111189|health holdings, llc|6 1a|addington|winston|19400314|m|33411|20190828|20200828|y|alendronic acid 70 mg oral tablet|16252060144|nd|70|904431|scd|c43243|||||4|87|ac|c48542|28||||0|20190830|20190830||||||||||||||||||||||||||||||py|||pbmx|t00000000022648|||||||||| dtl|301|14290489 14484513 1598647181195|2020 08 28t20 39 42 396z|approved||1561111189|health holdings, llc|6 1a|addington|winston|19400314|m|33411|20190828|20190830|y|12 hr cetirizine hcl 5 mg / pseudoephedrine hcl 120 mg er oral tablet|45802072153|nd|5 120|1014571|scd|c42927|||||12|87|ac|c48542|6||||0|20190830|20190830||||4222154|1235468844|brooklyn @ gates pharmacy|92 gates ave||brooklyn|ny|11238|3474251221||||||||||||||||||p2||||4222154|||||||||| trl (trailer) example the following fields are used in the trl (trailer) example record type | processed record count | medication count | medsfrompbm count (py) | medsfrompharmacy count (p2) | patient found | somedrugsreturned | no meds available | patient not found processing error | morethan300meds trl (trailer) example trl|39455|39430|21956|17474|123|39|0|1|24|0