FHIR resource:
Fields mapping:
| OpenIMIS field | DB type | FHIR field | Description | Note |
| HfID | int | Identifier | ||
| HFCode | nvarchar(8) | Identifier | ||
| HFName | nvarchar(100) | name | ||
| LegalForm | FK(tblLegalForms) | G: Government C: Charity D: District organization P: Private organization | The FHIR Location object don't contains that kind of information. If this information is valuable for external systems then we can add FHIR extension (if needed). | |
| HFLevel | char(1) | type | C - health center H - hospital D - dispensary | |
| HFSublevel | FK(tblHFSublevel) | I: Integrated R: Reference N: No Sublevel | The FHIR Location object don't contains that kind of information. If this information is valuable for external systems then we can add FHIR extension (if needed). | |
| HFAddress | nvarchar(100) | Address | ||
| LocationId | FK(tblLocations) | partOf - Reference(Location) | The FHIR Location will be used to represent the tblHF and tblLocations. The FHIR location.mode field can be used to distinguish between those object. | |
| Phone | nvarchar(50) | telecom | ||
| Fax | nvarchar(50) | telecom | ||
| nvarchar(50) | telecom | |||
| HFCareType | char(1) | I - In-Patient O - Out-Patient B - both | The FHIR Location object don't contains that kind of information. If this information is valuable for external systems then we can add FHIR extension (if needed). | |
| PLServiceID | FK(tblPLServices) | If needed we can add the FHIR extension, try to use the "Location.endpoint" to represent this field or try to use the FHIR HealthcareService. | ||
| PLItemID | FK(tblPLItems) | As above. | ||
| AccCode | nvarchar(25) | Account Code | I'm not sure if this information should be available for external systems. If needed we can add this information to the "location.description" or we can add the FHIR extension. | |
| OffLine | bit | I'm not sure but this is probably used to determine the source of row (offline/online app). Probably information isn't valuable for external systems. | ||
| ValidityFrom | datetime | Audit information. More information can be found here (on page 113): https://github.com/openimis/openimis_docs/blob/master/specs/Web%20application%20-%20Functional%20Design%20Specification.pdf | This information are valuable for OpenIMIS but I probably not required by external systems. | |
| ValidityTo | datetime | |||
| LegacyID | int | |||
| AuditUserID | int | |||
| RowID | timestamp | I'm not sure but this is probably some unique value used to distinguish database rows. Probably not useful for external systems. |
Note:
- the tblHF has relation with tblHFCatchment, the information from tblHFCatchment can be added as FHIR extensions (if needed)