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)