FHIR resources:
Fields mapping:
| OpenIMIS field | DB type | FHIR field | Description | Note | STPH |
| PolicyID | PK | Identifier | Use only PolicyUUID | ||
| PolicyUUID | UniqueIdentifier | Identifier | Added | ||
| FamilyID | FK(tblFamilies) | policyHolder | FHIR coverage has a direct connection with the patient. We can consider using the head of the family as a representative of the group or we can try to use the FHIR Group Resource (but first we must verify if we can add a reference to the Group instead of Patient). https://hl7.org/fhir/2018May/group.html We can also consider using the subscriberId and put there code of the family head. | OK | |
| EnrollDate | date | The FHIR representation doesn't contain this type of value. If needed we can consider adding the FHIR extension. | Extension | ||
| StartDate | date | period | OK | ||
| EffectiveDate | date | The FHIR representation doesn't contain this type of value. If needed we can consider adding the FHIR extension. | Extension | ||
| ExpiryDate | date | period | OK | ||
| PolicyStatus | tinyint | status | Default: 1 1 - Idle 2 - active 4 - suspended 8 - Expired | There are some differences between the Policy and FHIR statuses. List of FHIR coverage statuses: 1) active 2) cancelled 3) draft 4) entered-in-error | ok |
| PolicyValue | decimal | contract.valuedItem.net | The FHIR representation doesn't contain this type of value. If needed we can consider adding the FHIR extension. | ||
| ProdID | FK(tblProduct) | grouping | The FHIR representation doesn't contain exactly the same type of value. The coverage classifications can be contained in the "grouping" field and we can join it with a product using grouping.plan. See example: https://hl7.org/fhir/STU3/coverage-example.json.html | okI would suggest to check Contract entity => Coverage.contract | |
| OfficerID | FK(tblOfficer) | contract.agent.actor | The FHIR representation doesn't contain this type of value. If needed we can consider adding the FHIR extension. | contract.agent.actorsubscriber | |
| PolicyStage | char(1) | Default: N N - New Policy R - Renewed Policy | The FHIR representation doesn't contain this type of value. If needed we can consider adding the FHIR extension. | ||
| 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. | Internal field | |
| 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. | Internal field | ||
| isOffline | int | 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. | Internal field |
Note:
- The contract field could be use to map the Insurance Products to the Policies