干部结论验证表结构审批准备

{
  "ok": true,
  "current_gate": "FORMAL_CADRE_CONCLUSION_SCHEMA_APPLY_GATE",
  "previous_gate": "FORMAL_CADRE_CONCLUSION_SCHEMA_GATE",
  "reason": "当前没有安全的干部结论 / Talent Review 结论持久化表，不能写入 validation record。",
  "recommended_table": "cadre_conclusion_validations",
  "database_write": false,
  "create_table_executed": false,
  "detected_conclusion_tables": [],
  "source_tables": {
    "assessment_results": [
      "id",
      "result_id",
      "assignment_id",
      "template_id",
      "assessment_type",
      "review_cycle_id",
      "target_employee_id",
      "evaluator_employee_id",
      "evaluator_role",
      "dimension_scores",
      "total_score",
      "risk_flags",
      "algorithm_input_mapping",
      "result_status",
      "generated_at"
    ],
    "audit_logs": [
      "id",
      "audit_id",
      "user_id",
      "employee_id",
      "role_id",
      "action_type",
      "object_type",
      "object_id",
      "field_key",
      "permission_result",
      "before_value",
      "after_value",
      "request_id",
      "ip_address",
      "device_id",
      "created_at",
      "audit_note"
    ],
    "employee_assessment_profiles": [
      "id",
      "profile_id",
      "employee_id",
      "review_cycle_id",
      "competency_summary",
      "potential_summary",
      "values_summary",
      "assessment_360_summary",
      "all_risk_flags",
      "latest_result_ids",
      "algorithm_output_id",
      "profile_generated_at",
      "updated_at"
    ],
    "employees": [
      "id",
      "employee_id",
      "employee_name",
      "employee_no",
      "email",
      "mobile",
      "feishu_open_id",
      "feishu_union_id",
      "department_id",
      "team_id",
      "position_id",
      "manager_employee_id",
      "management_level",
      "role_family",
      "employee_status",
      "employment_type",
      "hire_date",
      "probation_status",
      "probation_end_date",
      "review_cycle_id",
      "raw_payload",
      "created_at",
      "updated_at"
    ],
    "permission_subjects": [
      "id",
      "subject_id",
      "subject_type",
      "user_id",
      "employee_id",
      "role_id",
      "department_id",
      "team_id",
      "hrbp_scope_ids",
      "reviewer_scope_ids",
      "reporting_scope_type",
      "subject_status"
    ],
    "talent_algorithm_outputs": [
      "id",
      "algorithm_output_id",
      "employee_id",
      "review_cycle_id",
      "algorithm_run_id",
      "capability_score",
      "potential_score",
      "performance_score",
      "values_score",
      "base_talent_score",
      "final_talent_score",
      "key_person_calibration_adjustment",
      "one_vote_veto",
      "final_talent_decision",
      "recommended_action",
      "algorithm_explanation",
      "decision_payload",
      "created_at"
    ]
  },
  "next_approval_statement_template": "确认执行 FORMAL_CADRE_CONCLUSION_SCHEMA-APPLY-1：创建 validation-only 表 cadre_conclusion_validations；不写干部结论记录、不生成正式结论、不反写飞书。",
  "generated_at": "2026-05-18T08:27:35.303554+00:00"
}