SQL on FHIR
2.1.0-pre - release
SQL on FHIR
2.1.0-pre - release
SQL on FHIR - Local Development build (v2.1.0-pre) built by the FHIR (HL7® FHIR® Standard) Build Tools. See the Directory of published versions
| draft |
Generated Narrative: ViewDefinition EncounterFlat
This view acts on the Encounter resource for version R4 to produce a table named "encounter_flat".
The table contains the following columns:
| Name | Fhir Type | SQL Type | Collection | Notes |
|---|---|---|---|---|
| id | string | String | ||
| status | string | String | ||
| patient_id | string | String | ||
| service_org_id | string | String | ||
| period_start | dateTime | DateTime | ||
| period_end | dateTime | DateTime | ||
| EpisodeOfCareId | string | String | ||
| type_sys | uri | String | This column is not defined as a collection, but the path statement 'system' might return multiple values for the column 'type_sys' for some inputs | |
| type_code | string | String | This column is not defined as a collection, but the path statement 'code' might return multiple values for the column 'type_code' for some inputs | |
| practitioner_id | string | String | ||
| location_id | string | String |
Selection Rules:
| Item | Coll | Type | Description |
|---|---|---|---|
  encounter_flat | Encounter | ||
  Select | |||
  id | getResourceKey() | ||
| status | status | ||
| patient_id | subject.getReferenceKey(Patient) | ||
| service_org_id | serviceProvider.getReferenceKey(Organization) | ||
| period_start | period.start | ||
| period_end | period.end | ||
 EpisodeOfCareId | episodeOfCare.getReferenceKey(EpisodeOfCare) | ||
| Select | for each type.coding, or null | ||
| type_sys | system | ||
| type_code | code | ||
| Select | for each participant, or null | ||
| practitioner_id | individual.getReferenceKey(Practitioner) | ||
| Select | for each location, or null | ||
 location_id | location.getReferenceKey(Location) |