SKKK Product Scope Cleaner

v109 Canonical Lock: SKKK ISCA count = verico_isca_exact_result_v75 only.

Final Master Route Preview Apply Clean BCM/EduSpark SKKK

Rule final SKKK:
ISCA canonical table: verico_isca_exact_result_v75 = source of truth.
Bridge / MBTI / master / mapping tables are support tables and ignored from SKKK count.
BCM & EduSpark SKKK must be 0 / not shown.

BCM / EduSpark Cleanup Applied

Table	Product	SKKK Count Before	Matched Wrong SKKK	Restored to POS	Cleared SKKK	Total Updated
`verico_bcm_dual_results_v46` score 175	bcm	0	0	0	0	0
`verico_bcm_upload_skipped_v46` score 150	bcm	0	0	0	0	0
`verico_bcm_eduspark_extract_state_v32` score 145	eduspark	0	0	0	0	0
`verico_bcm_compare_result_v43` score 130	bcm	0	0	0	0	0
`verico_bcm_dual_result_bridge_v47` score 130	bcm	0	0	0	0	0
`verico_bcm_dual_results_v45` score 130	bcm	0	0	0	0	0
`verico_bcm_education_result_bridge_v32` score 130	bcm	0	0	0	0	0
`verico_bcm_education_result_bridge_v33` score 130	bcm	0	0	0	0	0
`verico_eduspark_active_result_v66` score 130	eduspark	0	0	0	0	0
`verico_eduspark_clean_result_v69` score 130	eduspark	0	0	0	0	0
`verico_eduspark_education_result_bridge_v32` score 130	eduspark	0	0	0	0	0
`verico_eduspark_existing_result_bridge_v37` score 130	eduspark	0	0	0	0	0
`verico_bcm_student_tracker_v60` score 105	bcm	0	0	0	0	0
`verico_eduspark_upload_bridge_v52` score 105	eduspark	0	0	0	0	0

Clean complete. Total updated: 0. ISCA not touched.

ISCA SKKK Canonical Check

Table	SKKK Count	Status
`verico_isca_exact_result_v75`	160	CANONICAL / used for SKKK ISCA

Ignored ISCA Support Tables

Table	Detected SKKK Count	Status
`verico_isca_resume_total_v79`	0	Ignored support table, not used for SKKK report count
`verico_isca_education_result_bridge`	2578	Ignored support table, not used for SKKK report count
`verico_isca_education_result_bridge_v27`	2988	Ignored support table, not used for SKKK report count
`verico_isca_resume_total_v78`	0	Ignored support table, not used for SKKK report count
`isca360_questions`	0	Ignored support table, not used for SKKK report count
`isca360_users`	0	Ignored support table, not used for SKKK report count
`isca_study_abroad_university_map`	0	Ignored support table, not used for SKKK report count
`verico_isca_mbti_auto_v31`	143	Ignored support table, not used for SKKK report count
`verico_isca_mbti_master_v30`	0	Ignored support table, not used for SKKK report count
`verico_isca_mbti_merge_v29`	0	Ignored support table, not used for SKKK report count
`verico_isca_mbti_override`	0	Ignored support table, not used for SKKK report count

DB Diagnostic

Config path	Status	Info
`/portal/config/db.php`	connected	DB vericoac_portalacademy / user vericoac_portaluser