Jalur khusus ISCA SDM. Database yang diterima hanya vericoac_sdm. Education tetap di vericoac_portalacademy.
Pilih baris/tabel yang benar. Link report akan membawa source_table dan source_id agar report tidak kosong.
| DB | Table | Score | Rows | Sample | Action | Columns |
|---|---|---|---|---|---|---|
| vericoac_sdm | sdm_assessment_reports | 173 | 3 | - / ID: 3 | Open ISCA SDM | id, client_id, client_name, client_code, client_type, person_name, position_name, department, assessment_title, assessment_date, pdf_file, pdf_path, iq_score, aq_score, eq_score, mbti_type, disc_type, mdst_type, fit_percentage, overall_score ... |
| vericoac_sdm | sdm_exact_standard_result_imports | 165 | 346 | Zana, S.Pd. / ID: 2 | Open ISCA SDM | id, batch, segment, institution, participant_code, participant_name, position_name, unit_department, mbti_type, disc_profile, aq_score, eq_score, iq_score, msdt_style, raw_json, header_count, missing_headers, governance_case_id, imported_at, record_status ... |
| vericoac_sdm | sdm_company_pdf_assessments | 141 | 3 | Budiman Examplus / ID: 1 | Open ISCA SDM | id, client_id, company_name, assessment_title, participant_name, participant_role, department, original_filename, stored_filename, file_path, file_size, mime_type, assessment_summary, strength_area, development_area, iq_score, eq_score, aq_score, overall_score, score_category ... |
| vericoac_sdm | sdm_pdf_result_reports | 141 | 4 | - / ID: 1 | Open ISCA SDM | id, client_id, segment, company_name, participant_name, position_name, assessment_date, pdf_filename, pdf_path, raw_text, extraction_status, iq_score, eq_score, aq_score, overall_score, profile_summary, strength_area, development_area, risk_area, recommendation ... |
| vericoac_sdm | sdm_306090_participant_snapshot | 126 | 350 | Tsaniyah Anzani,S.Kom / ID: 1 | Open ISCA SDM | id, participant_key, source_table, source_id, participant_name, institution_raw, institution_standard, jenjang, position_name, mbti, disc, msdt, aq, eq, iq, fit_estimate, primary_cluster, priority_level, generated_at |
| vericoac_sdm | sdm_bulk_assessment_results | 126 | 0 | Open ISCA SDM | id, upload_batch, segment, client_name, organization_name, unit_department, participant_code, participant_name, gender, birth_place, birth_date, position_target, assessment_date, reviewer, source_file_name, job_fit_teacher_percent, job_fit_developer_percent, overall_job_fit_percent, fit_status_auto, recommended_role ... | |
| vericoac_sdm | sdm_integrated_assessment_reports | 117 | 2 | Sartika Inayah / ID: 1 | Open ISCA SDM | id, segment, company_name, participant_name, position_name, assessment_date, pdf_filename, pdf_path, raw_text, extracted_json, report_json, overall_index, status, created_at, updated_at |
| vericoac_sdm | sdm_deleted_result_archive | 111 | 21 | - / ID: 1 | Open ISCA SDM | id, result_id, action_type, batch_name, client_name, source_file, reason, record_snapshot, deleted_by, created_at |
| vericoac_sdm | sdm_integrated_direction_reports | 100 | 2 | Sartika Inayah / ID: 1 | Open ISCA SDM | id, segment, client_name, participant_name, position_name, assessment_date, pdf_filename, pdf_path, raw_text, upload_status, extract_status, engine_status, engine_json, executive_summary, strength_area, development_area, direction_recommendation, action_30, action_60, action_90 ... |
| vericoac_sdm | sdm_final_pdf_readable_reports | 92 | 2 | Sartika Inayah / ID: 1 | Open ISCA SDM | id, segment, client_name, client_id, participant_name, participant_code, position_name, department_class, assessment_date, pdf_filename, pdf_path, source_type, batch_name, batch_status, workflow_status, approval_status, csv_filename, raw_text, canonical_text, field_map_json ... |
| vericoac_sdm | sdm_assessment_participants | 87 | 374 | Bandarsyah, SE / ID: 1 | Open ISCA SDM | id, batch_name, segment, client_name, client_id, participant_name, participant_code, department_class, position_name, email, phone, assessment_type, assessment_date, assessment_status, user_account_status, source_filename, created_at, updated_at, english_cefr_level, english_cambridge_exam ... |
| vericoac_sdm | sdm_306090_generated | 84 | 2928 | Tsaniyah Anzani,S.Kom / ID: 1 | Open ISCA SDM | id, source_table, source_key, participant_name, institution, jenjang, position_title, cluster_code, phase, action_title, action_item, kpi, priority, status, raw_snapshot, generated_at |
| vericoac_sdm | sdm_participant_result_links | 71 | 200 | Ridho Ade Juniarta / ID: 18 | Open ISCA SDM | id, participant_source_table, participant_source_id, exact_import_id, match_method, match_score, participant_name, result_name, institution_name, created_at, updated_at |
| vericoac_sdm | sdm_participants | 62 | 1 | Employee Demo One / ID: 1 | Open ISCA SDM | id, company_id, participant_code, participant_type, full_name, email, phone, gender, birth_date, department, position_applied, current_position, employment_status, status, created_at, segment, nickname, birth_place, address, national_id ... |
| vericoac_sdm | sdm_generated_action_plans | 60 | 347 | Meriyana, S.I.Kom / ID: 1 | Open ISCA SDM | id, case_id, participant_id, segment, participant_name, client_name, position_target, recommended_role, job_fit_percent, fit_status, risk_level, main_strengths, main_risks, auto_decision_status, generated_by, created_at, updated_at, bulk_result_id, exact_import_id, participant_code ... |
| vericoac_sdm | sdm_client_participants | 54 | 186 | Bandarsyah, SE / ID: 1 | Open ISCA SDM | id, client_id, participant_code, source_no, participant_type, full_name, nickname, position_title, class_name, unit_name, email, phone, assessment_type, status_data, notes, data_complete, active_status, imported_batch_id, created_at, updated_at |
| vericoac_sdm | sdm_clients | 54 | 3 | - / ID: 1 | Open ISCA SDM | id, segment, client_code, client_type, client_name, legal_name, address, client_status, city, pic_name, pic_position, pic_email, pic_phone, package_name, start_date, end_date, status, notes, created_at, updated_at ... |
| vericoac_sdm | sdm_manual_result_link_log | 53 | 1 | - / ID: 1 | Open ISCA SDM | id, participant_source_table, participant_source_id, exact_import_id, candidate_score, action_note, created_by, created_at |
| vericoac_sdm | sdm_performance_controls | 52 | 0 | Open ISCA SDM | id, segment, company_id, participant_id, period_label, kpi_score, discipline_score, task_score, communication_score, culture_score, total_score, risk_level, recommendation, created_at | |
| vericoac_sdm | sdm_batch_participants | 46 | 1 | - / ID: 1 | Open ISCA SDM | id, batch_id, participant_id, status, created_at |
| vericoac_sdm | sdm_duplicate_participant_action_log | 46 | 4 | - / ID: 1 | Open ISCA SDM | id, source_table, source_id, action_type, duplicate_key, old_snapshot, new_snapshot, reason, created_by, created_at |
| vericoac_sdm | sdm_participant_import_batches | 46 | 3 | - / ID: 1 | Open ISCA SDM | id, client_id, import_name, source_file, total_rows, imported_rows, updated_rows, skipped_rows, import_notes, created_at |
| vericoac_sdm | sdm_participant_user_links | 46 | 0 | Open ISCA SDM | id, participant_table, participant_id, user_table, user_id, match_method, match_score, participant_name, username, email, client_name, created_at | |
| vericoac_sdm | sdm_user_participant_links | 46 | 0 | Open ISCA SDM | id, participant_source_table, participant_source_id, user_source_table, user_source_id, match_method, participant_name, user_name, client_name, sdm_category, created_at | |
| vericoac_sdm | sdm_assessment_import_logs | 45 | 0 | Open ISCA SDM | id, client_id, file_name, status, message, created_at | |
| vericoac_sdm | sdm_assessment_types | 45 | 5 | - / ID: 1 | Open ISCA SDM | id, type_code, type_name, description, status |
| vericoac_sdm | sdm_csv_assessment_batches | 45 | 1 | - / ID: 1 | Open ISCA SDM | id, segment, batch_name, client_name, batch_status, workflow_status, approval_status, notes, created_at, updated_at |
| vericoac_sdm | sdm_exact_standard_result_values | 45 | 46976 | - / ID: 1 | Open ISCA SDM | id, import_id, header_index, header_name, header_key, cell_value, created_at |
| vericoac_sdm | sdm_company_pdf_evidences | 44 | 6 | - / ID: 1 | Open ISCA SDM | id, client_id, company_name, employee_name, employee_role, department, evidence_module, evidence_title, original_filename, stored_filename, file_path, file_size, mime_type, analysis_summary, strength_area, concern_area, score, score_category, decision_rule, recommendation ... |
| vericoac_sdm | sdm_governance_action_cases | 44 | 353 | Meriyana, S.I.Kom / ID: 1 | Open ISCA SDM | id, participant_id, segment, organization_id, client_name, participant_name, participant_code, position_name, fit_score, fit_status, priority_level, summary_strengths, summary_risks, decision_status, supervisor_name, reviewer_name, start_date, target_date, status, created_at ... |
| vericoac_sdm | sdm_performance_records | 44 | 2 | - / ID: 1 | Open ISCA SDM | id, segment, client_id, client_name, person_name, role_title, unit_name, performance_period, indicator_1, indicator_2, indicator_3, indicator_4, indicator_5, indicator_6, overall_score, performance_category, decision_rule, top_strength, improvement_area, evidence_text ... |
| vericoac_sdm | sdm_reports | 44 | 0 | Open ISCA SDM | id, participant_id, batch_id, session_id, report_type, summary, strength, development_area, risk_area, recommendation, report_file, created_at | |
| vericoac_sdm | sdm_training_recommendations | 44 | 0 | Open ISCA SDM | id, company_id, participant_id, department, recommendation_type, training_title, priority_level, reason, status, created_at | |
| vericoac_sdm | modules | 40 | 12 | Kesiapan Kepemimpinan / ID: 1 | Open ISCA SDM | id, code, name, name_en, assessment_sources, kpi_domain, active |
| vericoac_sdm | sdm_csv_user_accounts | 36 | 0 | Open ISCA SDM | id, report_id, segment, client_name, batch_name, department_class, participant_code, participant_name, username, initial_password, password_hash, user_role, user_status, created_at, updated_at | |
| vericoac_sdm | sdm_dimension_scores | 36 | 0 | Open ISCA SDM | id, session_id, participant_id, dimension_code, raw_score, max_score, percentage_score, interpretation, recommendation, created_at | |
| vericoac_sdm | sdm_intake_user_accounts | 36 | 375 | Bandarsyah, SE / ID: 1 | Open ISCA SDM | id, intake_id, segment, client_name, batch_name, department_class, participant_code, participant_name, username, initial_password, password_hash, user_role, user_status, created_at, updated_at |
| vericoac_sdm | sdm_standard_library | 36 | 12 | - / ID: 1 | Open ISCA SDM | id, segment, module_key, standard_title, version_no, standard_content, scoring_model, evidence_requirement, decision_rule, output_report, is_verico_standard, status, created_at, updated_at |
| vericoac_sdm | sdm_test_sessions | 36 | 0 | Open ISCA SDM | id, participant_id, batch_id, assessment_type, start_time, end_time, status, total_score, percentage_score, result_level, recommendation_status, created_at | |
| vericoac_sdm | sdm_306090_action_plan | 28 | 2748 | - / ID: 1 | Open ISCA SDM | id, participant_key, source_table, institution_standard, jenjang, phase, cluster_code, cluster_name, action_category, action_item, kpi, owner_role, status, generated_at |
| vericoac_sdm | sdm_development_plans | 28 | 0 | Open ISCA SDM | id, segment, company_id, participant_id, focus_area, training_title, coaching_focus, period_start, period_end, status, progress_note, created_at | |
| vericoac_sdm | sdm_generated_action_items | 28 | 3128 | - / ID: 1 | Open ISCA SDM | id, plan_id, phase_label, action_area, action_title, action_detail, owner_role, metric_name, evidence_required, priority_level, status, created_at, decision_rule, due_day, updated_at |
| vericoac_sdm | sdm_governance_action_items | 28 | 36 | - / ID: 1 | Open ISCA SDM | id, case_id, phase_label, item_title, item_description, metric_name, owner_role, due_date, status, score, evidence_required, created_at, updated_at |
| vericoac_sdm | sdm_governance_content_library | 28 | 12 | - / ID: 1 | Open ISCA SDM | id, segment, module, title_id, title_en, positioning_id, positioning_en, flow_id, flow_en, checklist_id, checklist_en, scoring_id, scoring_en, decision_id, decision_en, evidence_id, evidence_en, report_id, report_en, client_value_id ... |
| vericoac_sdm | sdm_governance_decisions | 28 | 0 | Open ISCA SDM | id, case_id, decision_status, decision_reason, final_recommendation, next_review_date, decided_by, created_at | |
| vericoac_sdm | sdm_growth_action_plans | 28 | 1049 | Ismi Haromiah, S.Pd / ID: 1 | Open ISCA SDM | id, case_id, client_name, participant_name, participant_code, phase, action_title, action_detail, owner_role, due_date, status, created_at, updated_at |
| vericoac_sdm | sdm_growth_cases | 28 | 350 | Ismi Haromiah, S.Pd / ID: 1 | Open ISCA SDM | id, client_name, participant_name, participant_code, source_result_id, case_title, category, priority, decision_status, fit_score, status, notes, created_at, updated_at |
| vericoac_sdm | sdm_growth_evidence | 28 | 0 | Open ISCA SDM | id, case_id, plan_id, client_name, participant_name, evidence_title, evidence_note, evidence_link, status, created_at | |
| vericoac_sdm | sdm_mbti_library | 28 | 0 | Open ISCA SDM | id, mbti_type, mbti_title, source_name, file_name, file_path, raw_text, extracted_summary, detection_source, status, created_at, updated_at | |
| vericoac_sdm | sdm_onboarding_checklists | 28 | 0 | Open ISCA SDM | id, segment, company_id, participant_id, checklist_item, is_done, due_date, completed_at, notes, created_at | |
| vericoac_sdm | sdm_order_respondents | 28 | 0 | Open ISCA SDM | id, order_id, participant_code, job_title, full_name, nickname, class_division, email, phone, data_status, assessment_type, notes, created_at | |
| vericoac_sdm | sdm_orders | 28 | 0 | Open ISCA SDM | id, order_code, company_id, package_name, assessment_purpose, total_participants, order_status, preferred_date, notes, order_date, created_at, segment | |
| vericoac_sdm | sdm_probation_reviews | 28 | 0 | Open ISCA SDM | id, segment, company_id, participant_id, review_day, review_date, attendance_score, attitude_score, performance_score, teamwork_score, integrity_score, overall_score, decision, notes, created_at | |
| vericoac_sdm | sdm_questions | 28 | 120 | - / ID: 1 | Open ISCA SDM | id, assessment_type_code, dimension_code, question_text, option_a, option_b, option_c, option_d, option_e, score_a, score_b, score_c, score_d, score_e, status, created_at |
| vericoac_sdm | sdm_recruitment_pipeline | 28 | 0 | Open ISCA SDM | id, segment, company_id, candidate_name, position_title, stage, assessment_status, interview_status, validation_status, final_decision, owner_name, notes, created_at, updated_at | |
| vericoac_sdm | sdm_users | 28 | 4 | Verico Admin / ID: 1 | Open ISCA SDM | id, company_id, participant_id, name, email, password, role, status, last_login, created_at |
| vericoac_sdm | verico_sj_assessments | 25 | 390 | - / ID: 1 | Open ISCA SDM | id, student_code, assessment_type, result_label, source_table, source_id, raw_json, created_at, updated_at |
| vericoac_sdm | sdm_306090_clusters | 20 | 7 | - / ID: | Open ISCA SDM | cluster_code, title, description, priority_order, is_active |
| vericoac_sdm | sdm_306090_generate_log | 20 | 2 | - / ID: 1 | Open ISCA SDM | id, source_table, total_rows, total_generated, notes, created_at |
| vericoac_sdm | sdm_306090_institution_map | 20 | 7 | - / ID: 1 | Open ISCA SDM | id, raw_institution, standard_institution, created_at |
| vericoac_sdm | sdm_306090_rules | 20 | 21 | - / ID: 1 | Open ISCA SDM | id, cluster_code, phase, action_title, action_item, kpi, priority, is_active |
| vericoac_sdm | sdm_306090_settings | 20 | 13 | - / ID: 1 | Open ISCA SDM | id, setting_key, setting_value, updated_at |
| vericoac_sdm | sdm_activity_logs | 20 | 0 | Open ISCA SDM | id, user_id, activity_type, description, ip_address, created_at | |
| vericoac_sdm | sdm_answers | 20 | 0 | Open ISCA SDM | id, session_id, question_id, selected_option, score, created_at | |
| vericoac_sdm | sdm_batches | 20 | 1 | - / ID: 1 | Open ISCA SDM | id, batch_code, company_id, order_id, batch_name, assessment_type, start_date, end_date, status, created_by, created_at, segment |
| vericoac_sdm | sdm_client_access | 20 | 2 | - / ID: 5 | Open ISCA SDM | id, client_id, user_name, user_email, access_role, access_status, notes, created_at |
| vericoac_sdm | sdm_client_readiness_notes | 20 | 0 | Open ISCA SDM | id, segment, client_id, module_key, readiness_note, implementation_status, owner_name, target_date, updated_by, created_at, updated_at | |
| vericoac_sdm | sdm_client_standard_uploads | 20 | 0 | Open ISCA SDM | id, standard_id, segment, module_key, client_id, client_name, document_title, internal_note, uploaded_filename, uploaded_path, file_size, status, created_by, created_at, updated_at | |
| vericoac_sdm | sdm_disabled_records_archive | 20 | 47 | - / ID: 1 | Open ISCA SDM | id, source_table, source_id, action_type, reason, record_snapshot, created_by, created_at |
| vericoac_sdm | sdm_governance_content | 20 | 82 | - / ID: 1 | Open ISCA SDM | id, segment, module_key, item_code, title, description, category, score_min, score_max, role_view, role_upload, role_review, role_approve, role_decide, order_no, is_active, created_at |
| vericoac_sdm | sdm_governance_evidence_uploads | 20 | 0 | Open ISCA SDM | id, case_id, item_id, evidence_title, evidence_type, evidence_note, file_path, status, reviewed_by, created_at, updated_at | |
| vericoac_sdm | sdm_governance_items | 20 | 0 | Open ISCA SDM | id, segment, module, client_name, person_name, title, status, score, notes, created_by, created_at, due_date, decision, evidence_text, action_plan, updated_at, module_detail, client_id, client_type | |
| vericoac_sdm | sdm_governance_supervisor_reviews | 20 | 0 | Open ISCA SDM | id, case_id, review_week, reviewer_name, punctuality, accuracy, consistency, service_communication, emotional_control, document_order, task_completion, score_average, comment, next_instruction, created_at | |
| vericoac_sdm | sdm_growth_action_evidence_log | 20 | 3303 | - / ID: 51810 | Open ISCA SDM | id, plan_id, item_id, phase_label, evidence_title, evidence_note, evidence_status, review_score, reviewer_name, created_at, updated_at |
| vericoac_sdm | sdm_ip_activity_logs | 20 | 316 | - / ID: 1 | Open ISCA SDM | id, event_type, event_detail, user_identity, ip_address, user_agent, page_url, created_at |
| vericoac_sdm | sdm_jenjang_assignments | 20 | 367 | - / ID: 1 | Open ISCA SDM | id, exact_import_id, assigned_jenjang, assigned_unit, assigned_class, note, assigned_by, created_at, updated_at |
| vericoac_sdm | sdm_order_details | 20 | 0 | Open ISCA SDM | id, order_id, institution_type, filling_date, output_report, implementation_mode, location_platform, verico_pic, priority, technical_scope, data_note, created_at | |
| vericoac_sdm | sdm_organizations | 20 | 5 | - / ID: 1 | Open ISCA SDM | id, parent_id, organization_code, organization_name, organization_type, segment, status, created_at, updated_at |
| vericoac_sdm | sdm_safe_reset_log | 20 | 0 | Open ISCA SDM | id, reset_filter, reset_scope, selected_ids_count, archived_count, deleted_count, cleaned_links, cleaned_manual_links, cleaned_plans, cleaned_items, cleaned_evidence, cleaned_reminders, note, created_by, created_at | |
| vericoac_sdm | sdm_school_master_uploads | 20 | 0 | Open ISCA SDM | id, school_id, batch_id, original_filename, total_rows, inserted_rows, skipped_rows, error_rows, uploaded_by, created_at, notes | |
| vericoac_sdm | sdm_sop_documents | 20 | 9 | - / ID: 1 | Open ISCA SDM | id, segment, sop_category, title, description, status, created_at |
| vericoac_sdm | sdm_standard_template_headers | 20 | 128 | - / ID: 1 | Open ISCA SDM | id, header_index, header_name, header_key, is_active, created_at |
| vericoac_sdm | sdm_sync_log | 20 | 11 | - / ID: 1 | Open ISCA SDM | id, sync_key, sync_title, sync_note, created_at |
| vericoac_sdm | sdm_tenant_users | 20 | 6 | Verico Global Soution / ID: 1 | Open ISCA SDM | id, organization_id, full_name, username, email, password_hash, initial_password, role_key, status, last_login_at, created_at, updated_at |
| vericoac_sdm | sdm_ui_feature_visibility | 20 | 9 | - / ID: 1 | Open ISCA SDM | id, page_key, feature_key, feature_label, is_enabled, sort_order, updated_at |
| vericoac_sdm | sdm_value_assets | 20 | 5 | - / ID: 1 | Open ISCA SDM | id, asset_name, asset_type, asset_description, protection_level, created_at |
| vericoac_sdm | employees | 16 | 0 | Open ISCA SDM | id, employee_code, name, position, unit_name, supervisor_user_id, coach_user_id, assessment_date, baseline_score, active, created_at |