HCIF Framework- ICD9 data load- 26 seconds per insert.
A developer working with the Healthcare Industry Framework (HCIF) v7.6SP2 has encountered a performance problem whereby the developer attempts to load International Classification of Diseases type 9 (ICD9) entries into their HCIF framework database. Specifically, the developer observes load times in excess of 36 hours when attempting to load the ICD9 updates (17,553 records).
No error messages are observed on screen. Error messages related to the load ARE observed in the PRPC logfile.
2014-12-16 00:01:54,917 [j2ee14_ws,maxpri=10]] [ STANDARD] [ TCW_s2-2:01.01.01] (HG_MilVet_TCW_TCMM_Work.Action) ERROR - Agent to progress MVP on activity IntakeFlowProgress: Work item at resumeFLOW status=
2014-12-16 00:01:55,124 [j2ee14_ws,maxpri=10]] [ STANDARD] [ TCW_s2-2:01.01.01] (HG_MilVet_TCW_TCMM_Work.Action) ERROR - Agent to progress MVP on activity IntakeFlowProgress: Work item status=
Steps to Reproduce
To reproduce this issue, the customer is executing the following procedure:
a) select the ICD9 option from the customer “To Do” list.
b) At the “ICD9 Codes” browser window, the administrator then selects the EDIT IN EXCEL button.
c) Excel will start, and the workstation waits appr 90 seconds for the 17,553 existing instances to load into Excel
d) Administrator then deletes the contents of the Pega spreadsheet
e) Administrator then copies/pastes the updates from the obtained spreadsheet into the Pega spreadsheet
f) Administrator then commits the changes to the spreadsheet
g) Administrator then waits appr 2 days for the update to complete.
The root cause of this problem is software use/operation error. Specifically, the administrator is following the wrong procedure to update the ICD9 codes in the HCIF database.
The explanation for this behavior is as follows:
The correct procedure to update the codes is found in the HealthCare Industry Framework PDF documentation included in the Framework Distribution kit. The correct procedure is:
- The business has a subscription with a health care data provider to obtain their ICD9 updates data file. This data file can be delivered in several formats. Pega documentation provided in EMAIL details which file formats can be loaded into your HCIF 7.6SP2 framework.
- The Correct Procedure to load this data is to use the Load Sample Codes procedure on page 29 of the HC_Common_Codes_business_Use_Case_Guide_v2.2.pdf. This document is provided from the PDN to the customer.
This procedure should take only about 10 minutes to load the data file.