{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":[" 金地管理项目开发人天"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":" 金地管理项目开发人天","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[12,1,20,1],[12,4,15,4],[17,2,18,2],[1,5,4,5],[17,4,18,4],[25,1,27,1],[12,5,20,5],[21,5,22,5],[5,2,6,2],[5,4,6,4],[4,1,11,1],[21,1,23,1],[1,1,3,1],[1,4,3,4],[8,2,11,2],[8,4,11,4],[12,2,15,2]]}
["序号","模块","子模块","客户化功能点","客户化功能点关键业务说明","补充","人天"]
[{"$f":"ROW()-1","v":1},"shr基础数据对接","人员","新增shr人员同步接口","s-HR组织架构、岗位和人员信息同步到OA。 s-HR提供输出接口给OA调用。","不做了",7]
[{"$f":"ROW()-1","v":2},null,"组织","新增shr组织同步接口",null,null,7]
[3,null,"岗位","新增shr岗位同步接口",null,null,7]
[4,"人事单据对接","调动单","新增调动单生成接口","从OA发起调动申请，审批通过后，写入到s-HR，生成调动单。",null,8]
[5,null,"转正单","新增转正单生成接口","从OA发起调动申请，审批通过后，写入到s-HR，生成转正单。 提供接口检测非试用期员工不允许提交转正单",null,7]
[6,null,null,"新增员工状态校验接口",null,null,7]
[7,null,"离职单","新增离职单生成接口","从OA发起调动申请，审批通过后，写入到s-HR，生成离职单",null,7]
[8,null,"合同","新增合同新签接口","1、合同新签流程在OA审批通过后，在s-HR生成新签合同记录。\n2、合同续签流程在OA审批通过后，在s-HR生成续签合同记录。\n3、合同变更，终止流程在OA审批通过后，在s-HR生成变更，终止合同记录。",null,7]
[9,null,null,"新增合同续签接口",null,null,7]
[10,null,null,"新增合同变更接口",null,null,7]
[11,null,null,"新增合同工终止接口",null,null,7]
[12,"假期考勤单据对接","请假单","新增获取假期类型接口","1、假期类型，假期额度接口给oa调用。\n2、根据请假开始和结束时长获取请假天数。\n3、请假单oa审批通过后，写入到s-HR，生成请假单","不做了",7]
[13,null,null,"新增获取假期额度接口",null,null,7]
[14,null,null,"新增获取请假天数接口",null,null,7]
[15,null,null,"新增请假单生成接口",null,null,7]
[16,null,"签卡单","新增签卡单生成接口","在OA审批通过签卡单后，写入到s-HR，生成签卡单",null,7]
[17,null,"加班单","新增加班时间校验接口","1、提供接口给oa,判断加班填写时间是否正确（工作日时段不能允许填写）。\n2、在OA审批通过加班单后，写入到s-HR，生成加班单",null,7]
[18,null,null,"新增加班单生成接口",null,null,7]
[19,null,"出差单","新增出差单生成接口","在OA审批通过出差单后，写入到s-HR，生成出差单",null,7]
[20,null,"打卡记录对接","新增打卡记录写入接口","从考勤平台取打卡记录到s-HR",null,7]
[21,"薪酬单据对接","定薪单","新增定薪单生成接口","在OA审批通过后，写入到s-HR，生成定薪单","Oa系统定调薪单流程中薪酬项目存在附件中，不便于接口对接，沟通讨论后，确定定调薪流程在shr上走。不做了",7]
[22,null,"调薪单","新增调薪单生成接口","在OA审批通过后，写入到s-HR，生成调薪单",null,7]
[23,null,"薪酬查询","新增指定员工和月份的薪酬查询接口","1、创建薪酬OSF查询接口。\n2、查询指定员工、月份的基本工资。\n3、查询员工指定月份，十二个月以内的实际发放工资。\n4、整理数据格式，返回薪酬数据","对接oa移动端",7]
[24,"激励奖金前端\n数据收集提报","新增单据\"项目奖金核算表\"",null,"1、项目负责人填报奖金核算数据，提交至项目奖金核算表。\n2、单据可以新增，编辑，删除，导出，导入。\n3、单据需要有状态字段（提交、审核），针对每个项目负责人填报的数据进行审核，审核后项目负责人不能修改。如确实需要修改，则需要反审核。\n4、通过固定规则固化的项目激励奖金，参照线下表格设计表单，通过线下整理奖金数据导入。\n5、台账可查看，可按奖金发生期间、项目名称等条件进行过滤查询。\n",null,45]
[25,"绩效开发",null,"排序功能-正态分布","将组织绩效结果导入系统，系统根据组织绩效的结果使用正态分布规则批量修改员工个人考核结果。","新增开发内容",15]
[26,null,null,"绩效评估流程批量修改评估人","当系统里的人员发生变动，系统不要实时同步人员信息到绩效评估流程，而是通知HR用户“是否需要修改绩效评估流程的评估人”，如果修改则支持批量改动","新增开发内容"]
[27,null,null,"拓展人员考核",null,"新增开发内容",15]
[{"$nulls":6},{"$f":"SUM(G2:G28)","v":237}]