SELECT p.mrn, e.encounter_id,
       e.discharge_date
FROM   encounters e
JOIN   patients p ON p.id = e.patient_id
WHERE  e.discharge_date > NOW() - '7d'
  AND  e.status = 'closed';

MSH|^~\&|EPIC|A|LAB|A|202607181530
    ||ORU^R01|MSG0001|P|2.5
PID|1||MRN12345||Doe^Jane||19850614|F
OBR|1||L-0042|CBC^Complete Blood Count
OBX|1|NM|WBC^White Blood Count||6.8|k/uL

{
  "resourceType": "Patient",
  "identifier": [{
    "system": "urn:mrn",
    "value":  "MRN12345"
  }],
  "name": [{ "family": "Doe" }]
}

# normalize inbound HL7 ? FHIR
def to_fhir(msg):
    pid = msg['PID'][3][0]
    return {
        'resourceType': 'Patient',
        'identifier': [{'value': pid}],
    }

ISA*00*  *00*  *ZZ*SENDER *ZZ*RECV
GS*HC*SENDER*RECV*20260718*1530
ST*837*0001*005010X222A1
CLM*CLAIM0001*185.00***11:B:1
HI*ABK:J449

// route ADT^A04 to FHIR bridge
if (msg['MSH']['MSH.9']['MSH.9.2']
      .toString() === 'A04') {
    router.routeMessage('fhir-bridge', msg);
    logger.info('routed A04 ?');
}

# pull immunization records from state IIS
async def pull_vxu(pid):
    async with httpx.AsyncClient() as c:
        r = await c.post(IIS_URL,
              data={'pid': pid})
    return hl7.parse(r.text)

<ClinicalDocument xmlns="urn:hl7-org:v3">
  <code code="34133-9"
        codeSystem="2.16.840.1.113883.6.1"
        displayName="CCD"/>
  <recordTarget>...</recordTarget>
</ClinicalDocument>

SELECT p.mrn, e.encounter_id,
       e.discharge_date
FROM   encounters e
JOIN   patients p ON p.id = e.patient_id
WHERE  e.discharge_date > NOW() - '7d'
  AND  e.status = 'closed';

MSH|^~\&|EPIC|A|LAB|A|202607181530
    ||ORU^R01|MSG0001|P|2.5
PID|1||MRN12345||Doe^Jane||19850614|F
OBR|1||L-0042|CBC^Complete Blood Count
OBX|1|NM|WBC^White Blood Count||6.8|k/uL

{
  "resourceType": "Patient",
  "identifier": [{
    "system": "urn:mrn",
    "value":  "MRN12345"
  }],
  "name": [{ "family": "Doe" }]
}

# normalize inbound HL7 ? FHIR
def to_fhir(msg):
    pid = msg['PID'][3][0]
    return {
        'resourceType': 'Patient',
        'identifier': [{'value': pid}],
    }