FQL is a query language that allows you to retrieve, filter and project data from any data source containing FHIR Resources. It brings the power of three existing languages together: SQL, JSON and FhirPath. It allows you to create tables and is useful for gaining insight and perform quality control.
Snapshot 17 - Revision History
Profile Updates
EpisodeOfCare
Corrected validation for Service First Contact Date and Referral Received Date comparison. A data type mismatch between
dateTimeanddatecould cause valid same-day records to fail when First Contact Date contained a time component. The comparison now correctly supports validation betweendateTimeanddatevalues.Updated constraint description to reflect the implemented business rule. The description now reads "on or after" (greater than or equal to), consistent with the validation logic and permitting same-day first contact.
Corrected validation for the constraint comparing Service Enrollment Date (
period.start) and Service Initiation Date. A precision mismatch betweendateTimeanddatecould cause valid records to be incorrectly rejected. The comparison now correctly supports validation betweendateTimeanddatevalues.Updated validation to require at least one of Service Enrollment Date or Service Initiation Date when EpisodeOfCare status is active.
Patient
- Updated
Patient.communication:officialLanguagefrom conditional mandatory to optional. The associated validation rule was removed, allowing records to be submitted without an Official Language value while maintaining compatibility with existing implementations.
Terminology Updates
SNOMED Terminology
Trauma: SNOMED code updated from 417746004 to 773760007; display updated to "Traumatic event".
Problematic substance use: SNOMED code updated from 66214007 to 1306692000; display updated to "Harmful pattern of substance use (disorder)".
Alcohol dependence and Dependent drug abuse:
- Removed SNOMED codes 66590003 and 6525002.
- Replaced with "Substance use disorder (disorder)" (1306691007).
Observation
- Removed the Arrive in Canada code table. HSPs must now submit the year only (YYYY format) for this field. Code table values are no longer accepted.
ServiceRequest
- Updated Outbound Referral Source display values to align with the Data Dictionary:
- Code 22: "Community Mental Health Agency - Child Program" → "Community Org - Child Mental Health Program"
- Code OCIRP: "Community and Social Services Program" → "Other Community Institution/Residential Program"
- Code 24: "Social Service Agency - Child Program" → "Social Service Org - Child Program"
Canonical claims
This package contains canonicals that conflict with another package or project.
| There are no valid canonical claims defined. |
| Name | Version | Release date | ||
|---|---|---|---|---|
| hl7.fhir.r4.core | 4.0.1 | |||