School Code Stamp v102 Applied

DB: vericoac_portalacademy
Config: /home/vericoac/public_html/portal/student/verico_education_config.php

Stamp selesai. Data tidak dihapus.

Tables Checked

Table	Added Column	School	school_code	Prefix	Matched	Updated
`verico_bcm_dual_results_v46` score 165		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_isca_resume_total_v79` score 165		Wellington Intelligence School	WIS	STWIS	120	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_exact_resume_total_results_v74` score 135		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_bcm_upload_skipped_v46` score 130		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_bcm_compare_result_v43` score 125		Wellington Intelligence School	WIS	STWIS	9	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_bcm_dual_results_v45` score 125		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_eduspark_active_result_v66` score 125		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_eduspark_clean_result_v69` score 125		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_isca_education_result_bridge_v27` score 125		Wellington Intelligence School	WIS	STWIS	4347	0
		SKKK Medan	SKKKMDN	STSKKK	2988	0
`verico_isca_exact_result_v75` score 125		Wellington Intelligence School	WIS	STWIS	2	2
		SKKK Medan	SKKKMDN	STSKKK	160	1
`verico_isca_resume_total_v78` score 125		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_bcm_eduspark_extract_state_v32` score 120		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_bcm_dual_result_bridge_v47` score 110		Wellington Intelligence School	WIS	STWIS	9	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_bcm_education_result_bridge_v32` score 110		Wellington Intelligence School	WIS	STWIS	36	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_bcm_education_result_bridge_v33` score 110		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_eduspark_education_result_bridge_v32` score 110		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_eduspark_existing_result_bridge_v37` score 110		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_isca_education_result_bridge` score 110		Wellington Intelligence School	WIS	STWIS	4000	0
		SKKK Medan	SKKKMDN	STSKKK	2578	0
`verico_eduspark_upload_bridge_v52` score 105		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_exact_clean_results_v70` score 95		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_exact_clean_upload_v65` score 95		Wellington Intelligence School	WIS	STWIS	1	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_exact_result_v73` score 95		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_product_result_index` score 95		Wellington Intelligence School	WIS	STWIS	243	0
		SKKK Medan	SKKKMDN	STSKKK	251	0
`verico_student_result_upload_v61` score 95		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`isca360_questions` score 90		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`isca360_users` score 90		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`isca_study_abroad_university_map` score 90		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_bcm_student_tracker_v60` score 90		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_isca_mbti_auto_v31` score 90		Wellington Intelligence School	WIS	STWIS	121	0
		SKKK Medan	SKKKMDN	STSKKK	143	0
`verico_isca_mbti_master_v30` score 90		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_isca_mbti_merge_v29` score 90		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_isca_mbti_override` score 90		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_assessment_upload_rows` score 75		Wellington Intelligence School	WIS	STWIS	1936	0
		SKKK Medan	SKKKMDN	STSKKK	1472	0
`verico_student_assessment_bridge` score 75		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_student_journey_report_bridge_v35` score 75		Wellington Intelligence School	WIS	STWIS	1353	0
		SKKK Medan	SKKKMDN	STSKKK	437	0
`bs160_sessions` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`bs3_sessions` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`companies` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`products` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`questions` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`schools` score 60		Wellington Intelligence School	WIS	STWIS	1	0
		SKKK Medan	SKKKMDN	STSKKK	1	0
`sdm_assessment_participants` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`sdm_batches` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`sdm_clients` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`sdm_orders` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`sdm_participants` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`students` score 60		Wellington Intelligence School	WIS	STWIS	122	0
		SKKK Medan	SKKKMDN	STSKKK	159	0
`user_profiles` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vegi_area_map` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vegi_children` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_access_users_v99` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	1	0
`verico_auth_users_v116` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_class_master_v103` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_feature_master` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_product_canonical_table_v109` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_school_accounts_v81`	ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'SKKKMDN' for key 'school_code'
`verico_school_code_master_v102` score 60		Wellington Intelligence School	WIS	STWIS	1	0
		SKKK Medan	SKKKMDN	STSKKK	1	0
`verico_school_master_v103` score 60		Wellington Intelligence School	WIS	STWIS	1	0
		SKKK Medan	SKKKMDN	STSKKK	1	0
`verico_school_product_access_v105` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	3	0
`verico_school_product_access_v106` score 60		Wellington Intelligence School	WIS	STWIS	6	0
		SKKK Medan	SKKKMDN	STSKKK	6	0
`verico_school_product_access_v81` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_schools_v116` score 60		Wellington Intelligence School	WIS	STWIS	1	0
		SKKK Medan	SKKKMDN	STSKKK	1	0
`verico_student_assignment_v103` score 60		Wellington Intelligence School	WIS	STWIS	120	0
		SKKK Medan	SKKKMDN	STSKKK	160	0
`verico_student_tracker_action_v64` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_student_tracker_v61` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_student_users_v82` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_teacher_master_v103` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_user_profiles` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`verico_weekly_tracker_summary` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vmc_bundles` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vmc_major_map` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vmc_modules` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vmc_packages` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vmc_participants` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vmc_sd6_area_map` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vmc_students` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vmc_users` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vpb_260913121203_vmc_bundles` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vpb_260913121203_vmc_major_map` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vpb_260913121203_vmc_modules` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vpb_260913121203_vmc_students` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0
`vpb_260913121203_vmc_users` score 60		Wellington Intelligence School	WIS	STWIS	0	0
		SKKK Medan	SKKKMDN	STSKKK	0	0

Standard yang dipakai

School	school_code	school_key	school_prefix
Wellington Intelligence School	WIS	wellington	STWIS
SKKK Medan	SKKKMDN	skkk_mdn	STSKKK