XLS《填报要求》

"序号","填报说明", "1","系统环境要求:操作系统:windows2000或以上版本;

编辑软件:excel2000或以上版本", "2","变更类型填写范围说明:12代表续保21代表退保(退保只适用于死亡人员和调外地人员)22代表停保(适用于辞职或与单位解除劳动关系的人员)99代表二级单位变更25代表在职转退休", "3","与工资有关的数据录入格式一律为数字,保留两位小数","示例:"上年月平均工资"为:1590.

53" "4","二级单位变更只针对存在二级单位(分支机构)的单位操作,其他单位填空", "5","录入数据时请务必按照字段顺序要求录,否则会造成数据混乱和错误", "6","禁止使用下列符号:/", "7","基础数据中不允许不可见的字符", "8","性别、人员状态、医疗人员类别、参保状态、变更类型","必须从下拉列表框中选择" "9","续保报盘人员工资不可为空,且必须大于0", "10","认真校对人员信息,导入系统不予更改", "11","变更类型约束条件说明:如果变更类型是停保,那么只有是正常参保的人员才可以进行报盘业务,并且只修改参保状态其他信息不按照报盘内容保存;

如果变更类型是退保,只有正常参保或暂停参保人员才可以进行报盘业务,并且只修改参保状态其他信息不按照报盘内容保存;

如果变更类型是续保,那么只有是暂停参保的人员才可以进行报盘业务,并且根据填报工资修改缴费基数;

如果是其他单位人员续保到本公司,那么需要该人员所有险种都已暂停参保后才可以,并根据新公司是否存在二级单位信息同步变更二级单位信息;

如果变更类型是二级单位变更,那么只有存在二级单位的信息才能进行报盘业务;

如果变更类型是在职转退休,那么人员状态必须是在职,并且是正常参保人员,否则不能正确通过审核." "12","保存数据时一定要保证最后选择的工作页是《变更》才能有效导入" "13","加入变更日期一项,如果需要调整变更日期在此处修改,但不可以早于单位参保时间,晚于当前时间,续保时不能早于上次停保时间,停、退保和在职转退休时变更日期不可早于个人首次参保时间." "14","具体录入方式参照《样例》工作页所示" "序号","个人编号","单位编号","公民身份号码","姓名","性别","人员状态","医疗人员类别","参保状态","工资","二级单位编号","变更日期","变更类型" "1","100XXXXX","100XXX","220201XXXXXXXXXXXX","样例人员A","男","在职","在职","正常参保","2400",,

"07-06-14","22" "2","100XXXXX","100XXX","220201XXXXXXXXXXXX","样例人员B","男","在职","在职","暂停参保","1500.33125",,

"07-06-14","12" "序号","个人编号","单位编号","公民身份号码","姓名","性别","人员状态","医疗人员类别","参保状态","工资","二级单位编号","变更日期","变更类型"