XLS《人员基本信息维护》

"单位社保号:","单位名称:","重庆市参加社会保险人员基础信息变更表" "填写说明校验结果","个人编号","证件号码","姓名","性别","民族","出生日期","首次参加工作日期","工种","个人身份","户口性质","出生地","政治面貌","文化程度","户口所在地","户口行政区划","居住地性质","职业技术等级","行政级别","联系电话","联系地址","邮政编码","家庭住址","特殊工种名称","离退休日期","健康状况","劳动模范","部门编码","企业内部序号" ,"等于10位数字","标准的身份证号码(15位或18位)","≤10个汉字","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","正确的日期格式,如:1980-01-01","正确的日期格式,如:1980-01-01","≤10个汉字(1个汉字等于2个字符)","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","≤50个汉字(1个汉字等于2个字符)","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","≤50个字符)","≤12个字符)","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","≤20个字符)","≤50个汉字(1个汉字等于2个字符)","必须是6位数字","≤50个汉字(1个汉字等于2个字符)","选中单元格,点击按钮,从下拉列表中选择","日期格式:YYYY-MM-DD例如1980-01-01","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","必须是8位数字","≤8个字符)" "个人社会保障号","证件号码","证件种类","姓名","性别","民族","出生日期","出生地","首次参加工作日期","个人身份","政治面貌","文化程度","户口性质","户口所在地","户口行政区划","居住地性质","从业形态","职业技术等级","行政级别","联系电话","联系地址","邮政编码","家庭住址","特殊工种名称","离退休日期","健康状况","劳动模范","部门(二级单位)编码","工种","企业内部序号","养老保险参保时间","失业保险参保时间","医疗保险参保时间","工伤保险参保时间","生育保险参保时间" "等于10位数字","标准的身份证号码(15位或18位)","选中单元格,点击按钮,从下拉列表中选择","≤10个汉字","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","日期格式:YYYYMMDD例如1980101","≤50个汉字(1个汉字等于2个字符)","日期格式:YYYYMMDD例如198011","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","≤12个字符)","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","≤20个字符)","≤50个汉字(1个汉字等于2个字符)","必须是6位数字","≤50个汉字(1个汉字等于2个字符)","选中单元格,点击按钮,从下拉列表中选择","日期格式:YYYYMMDD例如1980101","选中单元格,点击按钮,从下拉列表中选择","选中单元格,点击按钮,从下拉列表中选择","必须是8位数字","≤10个汉字(1个汉字等于2个字符)","≤8个字符)","日期格式:YYYYMMDD例如1980101","日期格式:YYYYMMDD例如1980101","日期格式:YYYYMMDD例如1980101","日期格式:YYYYMMDD例如1980101","日期格式:YYYYMMDD例如1980101" "

一、出现以下情况系统将报错" "

1、标题被修改",,

,,

,,

"

2、列被删改",,

,,

,,

"

3、红色必填项未填写",,

,,

,,

"

4、代码值被修改",,

,,

,,

"

二、录入数据不符合以下规则",,

,,

,,

"

1、公民身份号码应正确,第一代身份证必须为15位编码,第二代身份证为18位编码",,

,,

,,

"

2、根据有效身份证号码自动生成出生日期和性别",,

,,

,,

"①编码为15位的第一代身份证" "出生日期标注在7至12位;

出生年为

7、8位;

出生月为

9、10位必须在01至12之间;

" "出生日为

11、12位必须在01至31之间.

",,

,,

"性别代码标注在第15位,奇数代表男性偶数代表女性." "②编码为18位的第二代身份证" "出生日期标注在7至13位;

出生年为7至9位;

出生月为

10、11位必须在01至12之间;

" "出生日为

12、13位必须在01至31之间." "性别代码标注在第17位,奇数代表男性偶数代表女性." "

3、日期校验:" "出生日期不能大于首次参加工作日期" "出生日期不能大于各险种参保时间" "首次参加工作日期不能大于各险种参保时间" "各险种参保时间不能大于系统时间" "出生日期、首次参加工作日期、离退休日期等不能大于系统时间" "

4、邮政编码必须是6位数字" "

5、工资必须大于零,并且是整数" "

6、个人社会保障号必须是10位数字"