...
As it can be observed in the previous figures, in 2019 and 2010 the openIMIS system has allowed the submission of more then 10’000 claims per day (respectively more then 20’000 medication items and more then 30’000 activity definition items per day). This illustrates also the need for an AI categorization step which can support the HIB reviewers.
Steps | Code and results | Table name | #row | #cols | memory (MB) | Remarks |
Color labels | Selection of fields in tables | |||||
Concatenation of tables | ||||||
1 | tblClaims | 5 965 605 | 20 | 910.28 | Selection of 20 columns (of 46) | |
tblClaimAdmins | 913 | 5 | 0.03 |
| ||
tblClaims + tblClaimsAdmins | 5 953 640 | 24 | 1 135.57 | Concatenation of the previous two tables, merged on ClaimAdminID column; 11965 claims have NULL value for the ClaimAdminId | ||
2 | tblInsurees + tblFamilies + tblLocations | 3 790 789 | 25 | 751.96 | Selection of columns | |
Step1 + tblInsurees + tblFamilies + tblLocations | 5 953 640 | 48 | 2 225.71 | Concatenation of the previous two tables, merged on InsureeID column | ||
3 | tblHFs + tblLocations | 780 | 10 | 0.07 |
| |
Step2 + tblHFs + tblLocations | 5 953 640 | 57 | 2 634.51 | Concatenation of the previous two tables, merged on HFID column | ||
4 | tblDiagnosis | 1 959 | 5 | 0.07 |
| |
Step3 + tblDiagnosis | 5 953 640 | 61 | 2 816.21 | Concatenation of the previous two tables, merged on HFID column | ||
5 | tblClaimItems | 12 414 014 | 17 | 1 610.09 | Selection of 16 columns (of 30) and added a column ‘ItemServiceType’ =’Medication’ | |
tblItems | 1 528 | 12 | 0.14 | Selection of 9 columns (of 15) and added a column ItemLevel = ‘M’ | ||
tblClaimItem + tblItems | 12 414 014 | 28 | 2 746.63 | Concatenation of the previous two tables, merged on ItemID column | ||
6 | Step5 + Step4 | 12 371 992 | 82 | 7 834.44 | Concatenation of the previous two tables, merged on ClaimID column; 42022 entities were excluded in the concatenation process as they corresponded to claims with null ClaimAdminID | |
7 | tblClaimServices | 16 655 364 | 17 | 2 160.20 | Selection of 16 columns (of 30) and added a column ‘ItemServiceType’ =’Activity definition’ | |
tblServices | 1 868 | 12 | 0.17 | Selection of 10 columns (of 16) | ||
tblClaimServices + tblServices | 16 655 364 | 28 | 3 685.04 | Concatenation of the previous two tables, merged on ClaimID column; | ||
8 | Step7 + Step4 | 16 600 273 | 82 | 10 511.95 | Concatenation of the previous two tables, merged on ClaimID column; 55091 entities were excluded in the concatenation process as they corresponded to claims with null ClaimAdminID | |
9 | Step6 + Step8 | 28 972 265 | 82 | 18 125.35 | Appended datasets | |
...