原始摘要 JSON
{
"action": "hrms_22f35a_feishu_position_mapping_readiness_v1",
"ok": true,
"tables": {
"feishu_org_users_cache": {
"exists": true,
"columns": [
"id",
"run_id",
"user_key",
"feishu_user_id",
"open_id",
"union_id",
"open_id_hash",
"union_id_hash",
"name",
"enterprise_email",
"enterprise_email_hash",
"mobile",
"mobile_hash",
"department_ids",
"status",
"is_activated",
"is_resigned",
"is_exited",
"is_frozen",
"join_time",
"raw_payload",
"created_at"
]
},
"positions": {
"exists": true,
"columns": [
"id",
"position_id",
"position_name",
"title",
"role_family",
"management_level",
"position_type",
"department_id",
"position_status",
"created_at",
"updated_at"
]
},
"employees": {
"exists": true,
"columns": [
"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"
]
},
"feishu_employee_import_staging": {
"exists": true,
"columns": [
"staging_id",
"run_id",
"feishu_user_key",
"feishu_user_name",
"feishu_user_id_preview",
"feishu_open_id_preview",
"feishu_union_id_preview",
"feishu_email_preview",
"feishu_mobile_preview",
"feishu_email_hash",
"feishu_mobile_hash",
"feishu_open_id_hash",
"feishu_union_id_hash",
"department_ids",
"feishu_status",
"suggested_action",
"suggested_employee_id",
"suggested_employee_name",
"match_confidence",
"match_reason",
"review_status",
"review_reason",
"source_payload",
"created_at",
"updated_at",
"reviewed_by",
"reviewed_at",
"resolved_hrms_department_id",
"resolved_hrms_department_name",
"resolved_hrms_team_id",
"org_resolution_status",
"org_resolution_source",
"org_resolution_payload",
"org_resolved_at"
]
}
},
"summary": {
"feishu_user_count": 23,
"feishu_job_title_non_empty_count": 0,
"feishu_job_title_empty_count": 23,
"feishu_job_title_non_empty_ratio": 0.0,
"hrms_position_count": 8,
"employee_total": 9,
"employee_p001_count": 2,
"employee_p001_ratio": 0.2222
},
"feishu_job_title_preview": [
{
"name": "万林",
"user_key_preview": "ou_b66b5...",
"enterprise_email_preview": "li***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-73a618b39ae49d40e5d6205cd497e3f4"
]
},
{
"name": "刘桂芳",
"user_key_preview": "ou_f51b4...",
"enterprise_email_preview": "la***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-4c4072c16d13a035f176e92e8dda1432"
]
},
{
"name": "刘苑飞",
"user_key_preview": "ou_1e4f0...",
"enterprise_email_preview": "ha***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-4c4072c16d13a035f176e92e8dda1432"
]
},
{
"name": "吕莎",
"user_key_preview": "ou_e52c1...",
"enterprise_email_preview": "al***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-f4a6199db131e6fe2729b88c9ec9d721"
]
},
{
"name": "周盈伶",
"user_key_preview": "ou_7e6bf...",
"enterprise_email_preview": "ly***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-5b866a8699bbe11c8fd3faa917656a42"
]
},
{
"name": "姚鑫",
"user_key_preview": "ou_87ff3...",
"enterprise_email_preview": "an***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0"
]
},
{
"name": "张琴亚",
"user_key_preview": "ou_a9b1a...",
"enterprise_email_preview": "am***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-8fc3457189726570419c25baa872790e"
]
},
{
"name": "张筱",
"user_key_preview": "ou_b35c6...",
"enterprise_email_preview": "ri***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-afc934ff3480fe0d395ecdd34147e0d5"
]
},
{
"name": "李嘉英",
"user_key_preview": "ou_6cc48...",
"enterprise_email_preview": "ja***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-f92bf5510fd8d7c3ec24faba96107ab4"
]
},
{
"name": "李颖",
"user_key_preview": "ou_93a05...",
"enterprise_email_preview": "av***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-40b7b0ac9fe5bd2f70527d0ce44ac8f2"
]
},
{
"name": "杨娅",
"user_key_preview": "ou_eb432...",
"enterprise_email_preview": "el***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-607aa25eba0e1e9519318804bdb1f8ee"
]
},
{
"name": "林晓峰",
"user_key_preview": "ou_f65ee...",
"enterprise_email_preview": "fe***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-77e32d1bbed856d869695428234ac471"
]
},
{
"name": "王金龙",
"user_key_preview": "ou_431ac...",
"enterprise_email_preview": "le***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-40b7b0ac9fe5bd2f70527d0ce44ac8f2"
]
},
{
"name": "白皓予",
"user_key_preview": "ou_56e45...",
"enterprise_email_preview": "ki***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-c76e19c3e3506b864dac41e2bf164f65"
]
},
{
"name": "白红梅",
"user_key_preview": "ou_ebf38...",
"enterprise_email_preview": "ma***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-afc934ff3480fe0d395ecdd34147e0d5"
]
},
{
"name": "葛方坤",
"user_key_preview": "ou_37794...",
"enterprise_email_preview": "fi***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-afc934ff3480fe0d395ecdd34147e0d5"
]
},
{
"name": "袁帆",
"user_key_preview": "ou_aec92...",
"enterprise_email_preview": "fr***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-5b866a8699bbe11c8fd3faa917656a42"
]
},
{
"name": "覃兴",
"user_key_preview": "ou_ae610...",
"enterprise_email_preview": "za***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-73a618b39ae49d40e5d6205cd497e3f4"
]
},
{
"name": "覃子连",
"user_key_preview": "ou_9cd37...",
"enterprise_email_preview": "li***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-f92bf5510fd8d7c3ec24faba96107ab4"
]
},
{
"name": "蹇博",
"user_key_preview": "ou_2b8e3...",
"enterprise_email_preview": "ja***@cheerpals.com",
"job_title": "",
"employee_type": "",
"department_ids": [
"0",
"od-177e730c7b2104fced6c1d37e66ceb92",
"od-55859e10fd2004aebe3ec4720a556b55"
]
}
],
"job_title_distribution": [
{
"job_title": "<EMPTY>",
"count": 23
}
],
"employee_type_distribution": [
{
"employee_type": "<EMPTY>",
"count": 23
}
],
"hrms_positions": [
{
"position_id": "P001",
"position_name": null,
"role_family": "business_management",
"position_status": "active"
},
{
"position_id": "P002",
"position_name": null,
"role_family": "platform_operation_management",
"position_status": "active"
},
{
"position_id": "P003",
"position_name": null,
"role_family": "growth_management",
"position_status": "active"
},
{
"position_id": "P004",
"position_name": null,
"role_family": "supply_chain_management",
"position_status": "active"
},
{
"position_id": "P005",
"position_name": null,
"role_family": "platform_operation",
"position_status": "active"
},
{
"position_id": "P006",
"position_name": null,
"role_family": "growth_marketing",
"position_status": "active"
},
{
"position_id": "P007",
"position_name": null,
"role_family": "supply_chain_procurement",
"position_status": "active"
},
{
"position_id": "P008",
"position_name": null,
"role_family": "content_operation",
"position_status": "active"
}
],
"employee_position_distribution": [
{
"position_id": "P001",
"count": 2
},
{
"position_id": "P002",
"count": 1
},
{
"position_id": "P003",
"count": 1
},
{
"position_id": "P004",
"count": 1
},
{
"position_id": "P005",
"count": 1
},
{
"position_id": "P006",
"count": 1
},
{
"position_id": "P007",
"count": 1
},
{
"position_id": "P008",
"count": 1
}
],
"recommendation": {
"decision": "do_not_build_job_title_auto_mapping_yet",
"reason": "Feishu job_title is empty for all cached users. Auto mapping from job_title to HRMS position would be meaningless.",
"next": "Build HRMS position master staging / manual position taxonomy first, keep P001 as temporary placeholder, and later connect Feishu People job/position fields if available."
}
}