Configure PE filtering
If a customer wants to make their own rules for filtering PE checks (DFS and CMI are doing this)
1) Turn on NJP tablecode PER_FILTER.
This will cause the night job to call K3S_5MOD/K3S_X210CL
2) Edit K3S_X210CL to call your new, custom program to filter.
3) Create your new custom RPGLE program to do the filtering. This program should be compiled activation group *YES This program will need to read K_PRODUCT and clear PR_ENDPER to filter out a PE check
4) Optional consideration:
Write any filtered products to K_PRODFLT Important Note: K_PRODFLT will contain 1 record for every product with PR_ENDPERS <> *blanks AND 1 record for every product filtered by our custom program. Essentially every product that gets filtered by the custom program will have 2 records in K_PRODFLT (one with PT_EXCEPTN = 0 and one with PT_EXCEPTN = 9)
5) Monitor the next period end! These queries were used at CMI to validate the results:
Number of product filtered out: select count(*) as count from k3s_5dta.k_product where pr_endpers <> pr_endper and pr_altsrce = 0 and pr_tempory = 0 and pr_deltcnt = 0
PE checks total (filtered + unfiltered): select count(*) as count from k3s_5dta.k_product where pr_endpers <> ‘ ‘ and pr_altsrce = 0 and pr_tempory = 0 and pr_deltcnt = 0
Total remaining PE checks total (filtered removed): select count(*) as count from k3s_5dta.k_product where pr_endper <> ‘ ‘ and pr_altsrce = 0 and pr_tempory = 0 and pr_deltcnt = 0
Confirm no PE5s filtered that were above the threshold: select pr_svceprv from k3s_5dta.k_product where pr_endper <> pr_endpers and pr_svceprv < 95
Total filtered in K_PRODFLT: select count(*) from k3s_5dta.k_prodflt where pt_exceptn = ‘9’
Total PE checks in K_PRODFLT: select count(*) as count from k3s_5dta.k_prodflt where pt_exceptn = 0
Number of PE checks that made it into the PE batches select sum(pb_prodsel) as total from k3s_5dta.k_prodseb where pb_requser = ‘PER_ENDING’ and pb_birth = ‘2022-09-09’
