XLS《导入模板完整表》

"预申请信息导入模板" "模板使用说明:1.

姓名和身份证号码为必填项,且身份证号使用18位的二代身份证号.2.若导入学生身份证号与系统中已有身份证号重复,导入信息将覆盖系统中已有信息.3.导入的数据中不能存在相同的身份证号码,否则会出现导入出错的情况.4.详细地址信息无需填写所在省、市、县,直接填写乡镇、街道、门牌号等具体信息即可.5.高校名称必须是全称:玉溪师范学院.6.行政区划代码(即户籍地代码、家庭住址代码的填写内容详见《行政区划代码表》.7.研究生贷款年限和申请学年之和不能超过入学年份之后的10年,本科或专科贷款年限和申请学年之和不能超过毕业时期之后的10年.8.所有填写内容不要含空格和特殊字符,数字、字母和符号使用半角输入.9.若导入信息中数据项填写不符合要求,则该数据项不导入.10.模板格式不能改变,示例无需删除,直接从序号[1]填写即可. "序号","基本信息"通讯信息",,

,,

,,

"就学信息"联系人信息",,

,,

,"共同借款人信息"申请信息",,

,"*姓名","*身份证号","民族[1]","户口性质[1]","毕业中学","户籍地代码[1]","户籍详细地址(乡镇、街道等)","QQ号","手机","家庭住址代码[1]","家庭详细地址(乡镇、街道等)","邮政编码","家庭联系电话","高校名称[1]","院系名称","专业名称","学历[1]","专业科类别[1]","入学年份","学制","姓名","身份证号","工作单位","联系电话","手机","姓名","身份证号","与学生关系[1]","家庭住址代码[1]","家庭详细地址(乡镇、街道等)","邮政编码","家庭电话","手机","申请金额","贷款期限","申请原因[1]" ,"T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","T13","T14","T15","T16","T17","T18","T19","T20","T21","T22","T23","T24","T25","T26","T27","T28","T29","T30","T31","T32","T33","T34","T35","T36" "例","王某","620422199001010013","汉族","农业户口","会宁一中","620422","丁沟乡梁庄村咀头社68号","15426854","13511111111","620422","丁沟乡梁庄村咀头社68号","730700","94311111111","玉溪师范学院","文学院","汉语言文学","本科","文学","2009","4","李某","620422197801010039","在家务农","93422222222","13811111111","王某某","620422196201010057","父亲","620422","丁沟乡梁庄村咀头社68号","730700","93433333333","13911111111","6000","10","劳动力少,无稳定收入" "1" "2" "3" "4" "5" "6" "7" "8" "9" "10" "11" "12" "13" "14" "15" "16" "17" "18" "19" "20" "21" "22"