--- title: Panel History Flat File Examples slug: medhistory-populations-file/guide/panel-history-flat-file-examples docTags: createdAt: 2026-06-10T15:14:54.593Z --- 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 :::CodeblockTabs HDR (Header) Example ```xml 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 :::CodeblockTabs From Pharmacy Feed ```xml 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 :::CodeblockTabs From Pharmacy Feed ```xml 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 :::CodeblockTabs Patient Not Found ```xml 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 :::CodeblockTabs Approved with Notes ```xml 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. :::CodeblockTabs Patients with More than 300 Medications ```xml 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 :::CodeblockTabs TRL (Trailer) Example ```xml TRL|39455|39430|21956|17474|123|39|0|1|24|0 ``` :::