22F-35A Readiness

飞书 job_title / HRMS position 映射准备度

本页用于判断是否可以直接基于飞书 job_title 自动生成岗位映射。当前只读,不修改 positions / employees。

HRMS Portal 员工 FDEP 归属预览

摘要

飞书用户
23
job_title 非空
0
job_title 为空
23
HRMS岗位数
8
P001员工数
2

建议判断

do_not_build_job_title_auto_mapping_yet

飞书 job_title 分布

job_title人数
<EMPTY>23

飞书用户岗位字段预览

姓名邮箱job_titleemployee_type
万林 li***@cheerpals.com
刘桂芳 la***@cheerpals.com
刘苑飞 ha***@cheerpals.com
吕莎 al***@cheerpals.com
周盈伶 ly***@cheerpals.com
姚鑫 an***@cheerpals.com
张琴亚 am***@cheerpals.com
张筱 ri***@cheerpals.com
李嘉英 ja***@cheerpals.com
李颖 av***@cheerpals.com
杨娅 el***@cheerpals.com
林晓峰 fe***@cheerpals.com
王金龙 le***@cheerpals.com
白皓予 ki***@cheerpals.com
白红梅 ma***@cheerpals.com
葛方坤 fi***@cheerpals.com
袁帆 fr***@cheerpals.com
覃兴 za***@cheerpals.com
覃子连 li***@cheerpals.com
蹇博 ja***@cheerpals.com

HRMS positions 当前选项

position_id岗位名层级序列/族状态
P001business_managementactive
P002platform_operation_managementactive
P003growth_managementactive
P004supply_chain_managementactive
P005platform_operationactive
P006growth_marketingactive
P007supply_chain_procurementactive
P008content_operationactive

employees position_id 分布

position_id员工数
P0012
P0021
P0031
P0041
P0051
P0061
P0071
P0081

原始摘要 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."
  }
}