FHIR resources:
Fields mapping:
OpenIMIS field | DB type | FHIR field | Description | Note | STPH |
PolicyID | PK | Identifier | |||
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. | |||
StartDate | date | period | |||
EffectiveDate | date | The FHIR representation doesn't contain this type of value. If needed we can consider adding the FHIR extension. | |||
ExpiryDate | date | period | |||
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 | ok | |
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.actor | |
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. | ||
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. | |||
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. |
Note:
- The contract field could be use to map the Insurance Products to the Policies