表用途
validation only只承载 pre-go-live validation 干部结论验证记录。
干部结论验证表 Schema Apply 结果
validation-only 表 cadre_conclusion_validations 已创建/确认存在；当前没有写入干部结论记录。
Schema 状态
已创建/确认validation-only 表已可用。
业务记录
未写入没有干部结论 validation record。
下一 Gate
FORMAL_CADRE_CONCLUSION_VALIDATION_APPLY_GATE下一步可回到单条验证 Apply。
禁止动作
禁止不生成正式干部结论、不做人事动作、不反写飞书。
数据安全
未修改formal result、algorithm output、profile refresh 均未修改。
下一步
下一闸门可回到单条干部结论 validation apply。
下一步批准语句
确认执行 FORMAL_CADRE_CONCLUSION_APPLY-PREGO-1：基于 FD0BB4C10 生成 exactly one pre-go-live validation 干部结论验证记录；business_effective=false，不反写飞书，不做人事动作。
技术明细
{
"ok": true,
"current_gate": "FORMAL_CADRE_CONCLUSION_VALIDATION_APPLY_GATE",
"backup_dir": null,
"schema_apply": "committed",
"table": "cadre_conclusion_validations",
"created_or_confirmed_table": true,
"business_record_written": false,
"formal_cadre_conclusion_generated": false,
"feishu_writeback": false,
"prechecks": {
"table_absent_or_compatible": true,
"formal_assessment_result_exists": true,
"formal_algorithm_output_exists": true,
"profile_refresh_exists": true,
"no_assessment_results_change_needed": true,
"no_algorithm_outputs_change_needed": true,
"no_profile_refresh_change_needed": true,
"no_permission_rule_change_needed": true,
"no_feishu_needed": true,
"no_backend_reload_needed": true
},
"postchecks": {
"table_exists": true,
"fields_exist": true,
"defaults_validation_only": true,
"no_conclusion_record_written": true,
"assessment_results_unchanged": true,
"algorithm_outputs_unchanged": true,
"profile_refresh_unchanged": true,
"employees_departments_positions_unchanged": true,
"permission_rule_counts_unchanged": true,
"no_feishu_writeback": true,
"audit_written_or_existing": true
},
"columns": {
"conclusion_id": {
"type": "text",
"default": null,
"nullable": "NO"
},
"employee_id": {
"type": "text",
"default": null,
"nullable": "NO"
},
"subject_id": {
"type": "text",
"default": null,
"nullable": "YES"
},
"source_assessment_result_id": {
"type": "text",
"default": null,
"nullable": "NO"
},
"source_algorithm_result_id": {
"type": "text",
"default": null,
"nullable": "NO"
},
"source_profile_refresh_id": {
"type": "text",
"default": null,
"nullable": "NO"
},
"conclusion_status": {
"type": "text",
"default": "'pre_go_live_validation'::text",
"nullable": "NO"
},
"conclusion_payload": {
"type": "jsonb",
"default": "'{}'::jsonb",
"nullable": "YES"
},
"conclusion_summary_preview": {
"type": "text",
"default": null,
"nullable": "YES"
},
"talent_review_level_preview": {
"type": "text",
"default": null,
"nullable": "YES"
},
"nine_box_position": {
"type": "text",
"default": null,
"nullable": "YES"
},
"talent_tags": {
"type": "jsonb",
"default": "'[]'::jsonb",
"nullable": "YES"
},
"risk_flags": {
"type": "jsonb",
"default": "'[]'::jsonb",
"nullable": "YES"
},
"recommended_actions_preview": {
"type": "jsonb",
"default": "'[]'::jsonb",
"nullable": "YES"
},
"input_gaps": {
"type": "jsonb",
"default": "'[]'::jsonb",
"nullable": "YES"
},
"pre_go_live_validation": {
"type": "boolean",
"default": "true",
"nullable": "YES"
},
"business_effective": {
"type": "boolean",
"default": "false",
"nullable": "YES"
},
"not_for_people_action": {
"type": "boolean",
"default": "true",
"nullable": "YES"
},
"not_for_feishu_writeback": {
"type": "boolean",
"default": "true",
"nullable": "YES"
},
"data_reset_required_before_go_live": {
"type": "boolean",
"default": "true",
"nullable": "YES"
},
"audit_id": {
"type": "text",
"default": null,
"nullable": "YES"
},
"rollback_ref": {
"type": "text",
"default": null,
"nullable": "YES"
},
"created_by": {
"type": "text",
"default": null,
"nullable": "YES"
},
"created_at": {
"type": "timestamp with time zone",
"default": "now()",
"nullable": "YES"
},
"updated_at": {
"type": "timestamp with time zone",
"default": "now()",
"nullable": "YES"
}
},
"generated_at": "2026-05-18T08:33:06.221989+00:00"
}