{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["采集字段列表","新采集表"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"采集字段列表","index":0,"n_rows":171,"n_cols":3,"rows_kept":171,"merged":[[3,0,5,0],[5,2,5,7],[6,0,10,0],[11,2,11,12],[12,0,35,0],[14,2,14,3],[18,2,18,5],[36,0,39,0],[41,0,42,0],[43,0,45,0],[48,0,52,0],[53,0,58,0],[59,0,66,0],[67,0,75,0],[76,0,83,0],[84,0,88,0],[89,0,100,0],[101,0,105,0],[106,0,109,0],[110,0,111,0],[112,0,116,0],[117,0,118,0],[121,0,127,0],[128,0,131,0],[132,0,137,0],[138,0,146,0],[147,0,150,0],[152,0,156,0],[157,0,165,0],[166,0,170,0]],"flags":["formulas_cached_only"]}
["员工信息采集表"]
["第一部分    入行事件相关信息"]
["信息类型"]
[null,"员工编号"]
[null,"入行日期"]
[null,"入行原因","01、应届毕业生；02、归国留学生；03、金融同业；04、其他"]
["0001","职位名称"]
[null,"员工组"]
[null,"员工子组"]
[null,"人事子范围"]
[null,"考勤员"]
["9000","招聘渠道","01、网上招聘；02、其他媒体；03、现场校园招聘；04、现场社会招聘；05、猎头；06、员工推荐；07、自荐"]
["0002","姓名"]
[null,"曾用名"]
[null,"性别","1、男；2、女"]
[null,"出生日期"]
[null,"出生地"]
[null,"出生省份"]
[null,"婚姻状况","未婚、已婚、丧偶、离异、再婚、未知"]
[null,"结婚日期"]
[null,"子女数目"]
[null,"最高学历","01、博士研究生；11、硕士研究生；12、研究生班；13、党校研究生；21、第二学士学位班；22、大学本科；23、大普；24、党校本科；31、大专；32、党校大专；41、中专（职高）；42、高中；51、初中及以下"]
[null,"最高学历类型","1、全日制教育；2、业余学习"]
[null,"最高学位","02、博士；03、硕士；04、双学士；05、学士；06、无"]
[null,"身高（cm）"]
[null,"最高职称"]
[null,"血型"]
[null,"用工身份","1、干部；2、工人"]
[null,"本行是否有亲属","1、是；0、否"]
[null,"一事通ID"]
[null,"Notes ID"]
[null,"籍贯（省）"]
[null,"籍贯（市/县）"]
[null,"户口所在地"]
[null,"独子出生时间"]
[null,"是否领取独生子女证","1、是；0、否"]
["0041","Z1 参加工作时间 "]
[null,"ZA 首次参加社会保险时"]
[null,"ZB 参加当地社会保险时间"]
[null,"ZC 户口调入本市时间"]
["0185","身份证号"]
["0529","民族"]
[null,"政治面貌"]
["0006","家庭地址"]
[null,"邮政编码"]
[null,"电话号码"]
[]
["第二部分   其他入行信息"]
["0016","合同开始日期"]
[null,"合同结束日期"]
[null,"合同类型"]
[null,"试用/见习期（月）"]
[null,"合同编号"]
["0534","加入日期"]
[null,"政治面貌类型"]
[null,"参加单位"]
[null,"介绍人"]
[null,"党内任职"]
[null,"组织关系所在地","1、本行；2、外单位"]
["家庭成员","关系类型","1、配偶；2、子女；7、紧急联系人；8、其他相关人员；11、父亲；12、母亲；90、兄弟；91、姐妹；92入职担保人"]
[null,"姓名"]
[null,"性别","1、男；2、女"]
[null,"出生日期"]
[null,"出生地"]
[null,"工作单位"]
[null,"职位/岗位"]
[null,"民族"]
["0022","开始时间"]
[null,"结束时间"]
[null,"教育程度","01、博士研究生；11、硕士研究生；12、研究生班；13、党校研究生；21、第二学士学位班；22、大学本科；23、大普；24、党校本科；31大专；32、党校大专；41、中专（职高）；42、高中；51、初中及以下"]
[null,"学制类别","11、全日制教育毕业；12、全日制教育结业；13、全日制教育肄业；21、业余学习毕业；22、业余学习结业；23、业余学习肄业"]
[null,"学位","02、博士；03、硕士；04、双学士；05、学士；06、无"]
[null,"专业名称"]
[null,"学位名称"]
[null,"院/系"]
[null,"备注"]
["0023","开始时间"]
[null,"结束时间"]
[null,"工作单位"]
[null,"城市"]
[null,"行业","0001、招商银行内部；0002、银行业；0003、其他金融业；0004、信息技术和互联网；0006、贸易业；0007、服务业（旅游/酒店/餐饮）；0008、政府部门；9999、其他行业"]
[null,"职务"]
[null,"岗位名称"]
[null,"备注"]
["9001","职称取得时间"]
[null,"职称名称"]
[null,"职称等级","1、高级；2、中级；3、初级"]
[null,"授予单位"]
[null,"备注"]
["9003","培训开始时间"]
[null,"培训结束时间"]
[null,"培训类型","01、行内培训；02、行外培训；99、其他"]
[null,"行内培训级别","1、一级；2、二级；3、三级"]
[null,"培训名称"]
[null,"主办单位"]
[null,"培训教师"]
[null,"培训内容"]
[null,"培训考核结果"]
[null,"费用类型","1、公费；2、自费"]
[null,"培训地点"]
[null,"备注"]
["9004－1","奖惩类型","0001、奖励表彰"]
[null,"奖励时间"]
[null,"奖励表彰名称"]
[null,"授予单位"]
[null,"备注"]
["9004－2","奖惩类型","0002、处分"]
[null,"处分类型"]
[null,"决定处分单位"]
[null,"备注"]
["0185","证件类型"]
[null,"证件号码"]
["0535","开始时间"]
[null,"结束时间"]
[null,"名称"]
[null,"授予单位"]
[null,"承担角色"]
["9007","爱好和特长","1、文体；2、外语；3、写作；4、电脑；9、其他"]
[null,"水平"]
[]
["第三部分   其他信息（入行后产生的记录）"]
["9002","专业资格取得时间"]
[null,"专业资格类型","1、岗位资格证书；2、业务技能水平；99、其他"]
[null,"名称"]
[null,"评定单位"]
[null,"等级"]
[null,"成绩"]
[null,"备注"]
["9005","考核类型","0001、年度考核"]
[null,"考核年度"]
[null,"考核结论"]
[null,"考核单位"]
["9006","技术职务开始时间"]
[null,"技术职务结束时间"]
[null,"技术职务序列","B、客户经理序列"]
[null,"技术职务级别"]
[null,"考核情况"]
[null,"评定单位"]
["9009","任职开始时间"]
[null,"任职结束时间"]
[null,"行政职务名称"]
[null,"是否预定聘期"]
[null,"聘期"]
[null,"是否约定任职试用期"]
[null,"任职试用期"]
[null,"是否交流"]
[null,"交流类别","1、调动交流；2、挂职交流"]
["9008","入户时间"]
[null,"入户派出所"]
[null,"集体户口编号"]
[null,"内部页码编号"]
["9011"]
["9013","任职开始时间"]
[null,"任职结束时间"]
[null,"任职类型","0001、行内社团任职；0002、党团任职；0003、行外其他任职；0009、其他"]
[null,"任职职务"]
[null,"任职单位"]
["0533","档案编号"]
[null,"档案种类","A、干部档；B、工人档；C、离退档；D、死亡档"]
[null,"位置代码"]
[null,"地点"]
[null,"四角编号"]
[null,"档案调入时间"]
[null,"回执是否寄出"]
[null,"档案调入形式","1、机要通道；2、专人取；3、自带"]
[null,"是否核对档案"]
["0537","出国时间"]
[null,"回国时间"]
[null,"出国目的"]
[null,"国家/地区"]
[null,"访问单位"]

{"sheet":"新采集表","index":1,"n_rows":128,"n_cols":9,"rows_kept":128,"merged":[[1,0,1,8],[2,0,2,8],[3,1,3,2],[3,4,3,5],[3,6,3,7],[4,1,4,8],[5,0,6,0],[5,1,6,8],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,1,10,4],[11,0,11,1],[11,3,11,4],[11,5,11,7],[12,0,14,0],[12,1,14,8],[15,1,15,3],[15,5,15,8],[16,1,16,2],[16,4,16,5],[17,1,17,2],[17,4,17,5],[17,7,17,8],[18,3,18,4],[18,6,18,7],[19,0,19,1],[19,4,19,8],[20,1,20,2],[20,4,20,8],[21,1,21,2],[21,4,21,6],[22,0,22,8],[23,0,23,8],[24,0,24,1],[24,2,24,3],[24,4,24,5],[24,6,24,7],[25,0,25,1],[25,2,25,3],[25,4,25,5],[25,6,25,7],[26,0,26,8],[27,2,27,3],[27,5,27,6],[27,7,27,8],[28,2,28,3],[28,5,28,6],[28,7,28,8],[29,2,29,3],[29,5,29,6],[29,7,29,8],[30,0,30,8],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6],[36,5,36,6],[37,1,37,2],[37,3,37,4],[37,5,37,6],[38,1,38,2],[38,3,38,4],[38,5,38,6],[39,1,39,2],[39,3,39,4],[39,5,39,6],[40,1,40,2],[40,3,40,4],[40,5,40,6],[41,1,41,2],[41,3,41,4],[41,5,41,6],[42,1,42,2],[42,3,42,4],[42,5,42,6],[44,0,44,8],[52,0,52,8],[53,2,53,3],[54,2,54,3],[55,2,55,3],[56,2,56,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[63,0,63,8],[64,0,64,1],[64,2,64,3],[64,4,64,5],[64,6,64,7],[65,0,65,1],[65,2,65,3],[65,4,65,5],[65,6,65,7],[66,0,66,1],[66,2,66,3],[66,4,66,5],[66,6,66,7],[67,0,67,1],[67,2,67,3],[67,4,67,5],[67,6,67,7],[68,0,68,8],[72,0,72,8],[73,5,73,6],[73,7,73,8],[74,5,74,6],[74,7,74,8],[75,5,75,6],[75,7,75,8],[76,5,76,6],[76,7,76,8],[77,5,77,6],[77,7,77,8],[78,5,78,6],[78,7,78,8],[79,0,79,8],[80,1,80,3],[80,4,80,6],[80,7,80,8],[81,1,81,3],[81,4,81,6],[81,7,81,8],[82,1,82,3],[82,4,82,6],[82,7,82,8],[83,1,83,3],[83,4,83,6],[83,7,83,8],[84,0,84,8],[85,1,85,3],[85,4,85,6],[85,7,85,8],[86,1,86,3],[86,4,86,6],[86,7,86,8],[87,1,87,3],[87,4,87,6],[87,7,87,8],[88,0,88,8],[89,2,89,4],[89,5,89,6],[89,7,89,8],[90,2,90,4],[90,5,90,6],[90,7,90,8],[91,2,91,4],[91,5,91,6],[91,7,91,8],[92,2,92,4],[92,5,92,6],[92,7,92,8],[93,0,93,8],[94,0,94,3],[94,4,94,8],[95,0,95,3],[95,4,95,8],[96,0,96,3],[96,4,96,8],[97,0,97,8],[98,0,98,8],[99,0,99,1],[99,2,99,3],[99,5,99,6],[100,0,100,1],[100,2,100,3],[100,5,100,6],[101,0,101,1],[101,2,101,3],[101,5,101,6],[102,0,102,1],[102,2,102,3],[102,5,102,6],[103,0,103,8],[104,0,104,1],[104,2,104,3],[104,4,104,6],[104,7,104,8],[105,0,105,1],[105,2,105,3],[105,4,105,6],[105,7,105,8],[106,0,106,1],[106,2,106,3],[106,4,106,6],[106,7,106,8],[107,0,107,8],[108,2,108,3],[108,4,108,5],[108,7,108,8],[109,2,109,3],[109,4,109,5],[109,7,109,8],[110,2,110,3],[110,4,110,5],[110,7,110,8],[111,2,111,3],[111,4,111,5],[111,7,111,8],[112,0,112,8],[119,0,119,8],[120,2,120,3],[120,4,120,5],[120,6,120,8],[121,2,121,3],[121,4,121,5],[121,6,121,8],[122,2,122,3],[122,4,122,5],[122,6,122,8],[123,0,123,8],[124,7,124,8],[125,7,125,8],[126,0,126,8],[127,2,127,3],[127,5,127,8],[128,2,128,3],[128,5,128,8]],"flags":["formulas_cached_only"]}
["附件二"]
["员工信息采集表"]
["第一部分    人员基本信息"]
["员工编号",null,null,"所在部门",null,null,"入行日期"]
["入行原因"]
["招聘渠道"]
[]
["姓名",null,"曾用名",null,"性别",null,null,"出生日期"]
["出生省份",null,"出生地",null,"身高（cm）",null,null,"血型"]
["籍贯（省）",null,"籍贯（市/县）",null,"户口所在地"]
["婚姻状况",{"$nulls":4},"结婚日期",null,"子女数目"]
["独子出生时间",null,null,"是否领取独生子女证"]
["最高学历"]
[]
[]
["最高\n学历类型",{"$nulls":3},"最高学位"]
["用工身份",null,null,"最高职称"]
["本行是否\n有亲属",null,null,"一事通ID",null,null,"Notes ID"]
["参加工作时间 ",null,null,"首次参加社会保险时",null,null,"参加当地社会保险时间"]
["户口调入本市时间",null,null,"身份证号"]
["民族",null,null,"政治面貌"]
["电话号码",null,null,"家庭地址",{"$nulls":3},"邮政编码"]
["第二部分   其他入行信息"]
["合同信息"]
["合同开始日期",null,"合同结束日期",null,"合同类型",null,"试用/见习期（月）",null,"合同编号"]
[]
["政党信息"]
["加入日期","政治面貌\n类型","参加单位",null,"介绍人","党内任职",null,"组织关系所在地"]
[]
[]
["家庭/相关人员(担保人）信息"]
["关系类型","姓名","性别","出生日期","出生地","工作单位",null,"职位/岗位","民族"]
[]
[]
[]
[]
[]
["政治面貌","身份证号",null,"联系电话",null,"联系地址",null,"邮编","备注"]
[]
[]
[]
[]
[]
[]
["教育经历"]
["开始时间","结束时间","教育程度","学制类别","学位名称","专业名称","学校名称",null,"院/系"]
[]
[]
[]
[]
[]
[]
["工作经历"]
["开始时间","结束时间","工作单位",null,"城市","行业","职务","岗位名称","备注"]
{"$rows_empty":9}
["社会职称信息"]
["职称取得时间",null,"职称名称",null,"职称等级",null,"授予单位",null,"备注"]
[]
[]
[]
["行内培训履历"]
["培训\n开始时间","培训\n结束时间","行内培训级别","培训名称","主办单位","培训教师","培训内容","培训\n考核结果","培训地点"]
[]
[]
["行外培训履历"]
["培训\n开始时间","培训\n结束时间","培训名称","主办单位","培训教师","培训内容",null,"培训地点"]
[]
[]
[]
[]
[]
["奖励信息"]
["奖励时间","奖励表彰名称",null,null,"授予单位",null,null,"备注"]
[]
[]
[]
["处分信息"]
["处分时间","处分类型",null,null,"决定处分单位",null,null,"备注"]
[]
[]
["项目与成果信息"]
["开始时间","结束时间","名称",null,null,"授予单位",null,"承担角色"]
[]
[]
[]
["爱好及特长（外语、文体、爱好、特长等）"]
["爱好、特长",{"$nulls":3},"水  平"]
[]
[]
["第三部分    其他信息（入行后产生的信息）"]
["专业资格水平"]
["专业资格取得时间",null,"专业资格类型",null,"名称","评定单位",null,"等级","成绩"]
[]
[]
[]
["考核信息（年度考核）"]
["考核类型",null,"考核年度",null,"考核结论",null,null,"考核单位"]
[]
[]
["技术职务任免经历"]
["技术职务\n开始时间","技术职务\n结束时间","技术职务序列",null,"技术职务级别",null,"考核情况","评定单位"]
[]
[]
[]
["行政职务任免经历"]
["任职\n开始时间","任职\n结束时间","行政职务名称","是否\n约定聘期","聘期","是否约定\n任职试用期","任职试用期","是否交流","交流类别"]
[]
[]
[]
[]
[]
["其他任职经历"]
["任职\n开始时间","任职\n结束时间","任职类型",null,"任职职务",null,"任职单位"]
[]
[]
["人事档案信息"]
["档案编号","档案种类","地点","四角编号","档案调入时间","回执是否寄出","档案调入形式","是否核对档案"]
[]
["外事出国信息"]
["出国时间","回国时间","出国目的",null,"国家/地区","访问单位"]