# HL7 Allergy Shot Module Integration

**URL:** <https://community.open-emr.org/t/hl7-allergy-shot-module-integration/25266>\
**Category:** Third Party Solutions and Add-Ons\
**Created:** [April 9, 2025, 4:32pm UTC](https://community.open-emr.org/t/hl7-allergy-shot-module-integration/25266 "2025-04-09T16:32:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hopeful](https://community.open-emr.org/letter_avatar_proxy/v4/letter/h/ce7236/32.png) [@Hopeful](https://community.open-emr.org/u/Hopeful)\
**Post date:** [April 9, 2025, 4:32pm UTC](https://community.open-emr.org/t/hl7-allergy-shot-module-integration/25266/1 "2025-04-09T16:32:58Z")

</div>

Needing HL7 integration specs for Allergy Shot Module. Anything currently available? Has anyone done this?

---

<div class="post-metadata">

**Author:** ![Qiaben](https://community.open-emr.org/user_avatar/community.open-emr.org/qiaben/32/21612_2.png) [@Qiaben](https://community.open-emr.org/u/Qiaben)\
**Post date:** [April 10, 2025, 11:50am UTC](https://community.open-emr.org/t/hl7-allergy-shot-module-integration/25266/2 "2025-04-10T11:50:10Z")

</div>

In OpenEMR, when a user selects the “Payment Date” or “Invoice Date” option—especially in reports, billing, or EOB/ERA processing screens—the system uses specific database fields. Let’s break down the typical behavior and how these dates are mapped:

Shape

🧾 1. “Payment Date” Option – Which Date Is Used?

When you select “Payment Date” in reports or billing filters:

✅ Likely Field Used:

From EOB/ERA:  
→ deposit\_date (from the ar\_session table or manual\_batch in case of manual entry)

From Payments (Patient/Insurance):  
→ Could also be referencing check\_date or post\_to\_date, depending on module and report.

✅ Most common behavior in OpenEMR:

ERA/EOB payments: → Uses deposit\_date (i.e., the day funds were deposited/recorded in the system).

Manual payments: → Sometimes post\_to\_date is used if explicitly entered during payment posting.

Shape

📄 2. “Invoice Date” Option – Which Date Is Used?

When you select “Invoice Date”, it’s often meant to filter or tag the billing date associated with services rendered.

✅ Likely Field Used:

date from the form\_encounter or billing table. → This represents the Date of Service (DOS) or the date the charge was created.

💡 Important Notes:

OpenEMR does not always use the term “Invoice Date” internally — this might be used interchangeably in custom reports or third-party billing modules.

If you’re running a report from Fees → Billing or Reports → Financial, and select “Invoice Date,” it’s usually tied to the encounter date (form\_encounter.date) or billing.date (procedure date).

Shape

✅ Summary

Option

Common Field(s) Used

Table

Notes

Payment Date

deposit\_date, post\_to\_date

ar\_session, manual\_batch, insurance\_data

For EOB/ERA, it’s usually deposit\_date

Invoice Date

date (encounter/procedure date)

form\_encounter, billing

Typically DOS or charge entry date

Shape

If you’re customizing or debugging, you can check the SQL queries inside:

interface/billing/billing\_report.php

library/parse\_era.php

interface/reports/collections\_report.php

Let me know where exactly you’re seeing these options, and I can give you the exact query/field used in that module or form!  
If you face any problem, You can [access our experts](https://qiaben.com/qiaben-free-emr-support/)