COVID19

Correction

Correction plan for invalid entered data in EXP.T_CVD19_LTRMRES.

In sequence the following steps will be taken in order to correct the data :

• step 1 : load into STG.T_CVD19_CTRA_LTRMRES_UPD all invalid but corrected data for CD_RESULT_FLAG1, loaded until now correction :

 each value in CD_RESULT_FLAG1 that does not exist in the list of valid values below 

( 'RFLTR0001', 'RFLTR0002', 'RFLTR0003', '260408008', '260405006' ) and that contains

 a Corona test prescription code value ( PRXMATCH('/[0-9a-f]{16}/i',CD_RESULT_FLAG1 )

• this value will be copied to TX_PRESCR_CODE
• CD_RESULT_FLAG1 itself will be put to blank

• step 2 : correction of the existing COVID19 code to do the append in EXP.T_CVD19_LTRMRES

      of all incoming data that will be sent in the future

      ( combination of STG.T_CVD19_CTRA_LTRMRES_C and

      STG.T_CVD19_CTRA_LTRMRES_UPD )

• step 3A : based on a one-time update script to be developed : delete all records in

EXP.T_CVD19_LTRMRES that were already loaded in the past and of which the key

( ID_T_CVD19_CTRA_LTRMRES ) exists in STG.T_CVD19_CTRA_LTRMRES_UPD

• step 3B : based on a one-time update script to be developed : append all records of step 3A to EXP.T_CVD19_LTRMRES, after correction of the invalid values

      remark : after discussion with Andreas, each other invalid value for CD_RESULT_FLAG1 ( like

      ‘undefined’, datetime value, … ) will not be corrected

• percentage of invalid values to be corrected :

15217 ( on a total of 78326 records with filled CD_RESULT_FLAG1

in EXP.T_CVD19_LTRMRES ) = 19,4 %

This percentage is not the one that is asked: how many records of the EXP table will be ‘updated’: 15217 of 22569164 = 0.067%

• percentage of invalid values not to be corrected :

5961 ( on a total of 78326 records with filled CD_RESULT_FLAG1

in EXP.T_CVD19_LTRMRES) = 7,6 %

This percentage is not the one that is asked: how many records of the EXP table will NOT be ‘updated’: 5961 of 22569164 = 0.026%