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