{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["证书信息表","审核结果信息表","能源绩效信息表"],"not_rendered":{"external_links":1,"defined_names":8},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"证书信息表","index":0,"n_rows":8,"n_cols":69,"rows_kept":8,"merged":[[1,0,3,0],[4,0,6,0]],"flags":["formulas_cached_only"]}
["103010","字段名称","RZJG_ID","RZJG_KEY_ID","ORG_NAME","ORG_NAME_EN","ORG_O_NAME","ORG_CODE","BEL_INDUSTRY","ORG_COUNTRY","ORG_DISTRICT","ORG_ADDRESS","ORG_PHONE","LEGAL_PEOPLE","ORG_REG_ASSETS","REG_ASSETS_CURR","ORG_PEOP_NUM","RELA_PEOP_NUM","FIRST_CERT_DATE","CERT_NUMBER","AUTH_PROJ_CODE","BUSI_SCOP_CODE","AUTH_PROJ_CODEDEC","IS_MULTI_SCENE","PLACE_NAME_ADD","BUSI_COVER_SCOP","QMS_COVERAGE","ORG_EN_BORDER","APPR_AC_CODE","A_AUTH_TIMES","SUSE_TIMES","APPR_S_DATE","APPR_E_DATE","CHK_PD_NUM","IS_COMB","CHK_P_LIST","APP_ASS_DATE","AWARD_DATE","CERTI_E_DATE","CERTI_STATUS","PAUSE_CAUSE","PAUSE_S_DATE","PAUSE_E_DATE","CANCEL_CAUSE","CANCEL_DATE","IS_C_CERTI","M_CERTI_NUM","CHG_DATE","CHG_TYP_CODE","IS_CHG_CERTI","EXCHANGE_DATE","EXCHANGE_CAUSE","O_AWARD_JG","O_CERTI_NUM","REGISTATION_NUM","ACC_SYMBOL","RISK_PARAM","ATTACHMENTS","REPORT_TYPE","REMARK","IS_OVERFLOW","AUDIT_PLAN_NO","OVERFLOW_CAUSE","PLAN_START","PROGRAM_FILENO","BASE_PD_NUM","FYYP_PRO_CLASSFY_CODE","FETCH_S_DATE","FETCH_E_DATE"]
["管理体系及服务认证信息上报数据模版","字段含义","1、认证机构批准号","2、实施审核的认证机构分支机构名称","3、获证组织名称（主要名称）","4、获证组织名称（其他名称）","5、获证组织原名","6、获证组织的统一社会信用代码","7、获证组织所属国民经济行业","8、获证组织注册地址所在国家地区代码","9、获证组织注册地址所在行政区划代码","10、获证组织注册地址","11、获证组织联系电话","12、获证组织法定代表人","13、获证组织注册资本","14、获证组织注册资本币种","15、获证组织员工数","16、获证组织体系覆盖的员工数","17、初次获证日期","18、认证证书号","19、认证项目分类代码","20、认证业务范围所属CNAS分类代码","21、认证依据","22、是否覆盖多场所","23、认证覆盖的场所名称及地址","24、认证覆盖的业务活动范围","25、EC9000证书对应的QMS覆盖范围","26、获证组织能源管理体系边界","27、认证审核活动代码","28、再认证次数","29、监督次数","30、审核开始日期","31、审核截止日期","32、审核人日数","33、结合审核类型","34、认证决定人员名单","35、认证决定日期","36、颁证日期","37、证书截止日期","38、证书状态","39、暂停原因","40、暂停开始时间","41、暂停截止时间","42、注销/撤销原因","43、注销/撤销时间","44、是否是子证书","45、主认证证书号","46、变更日期","47、变更类别代码","48、是否换证","49、换证日期","50、换证原因","51、原颁证机构批准号","52、原获认证的认证证书号","53、证书使用的认可号","54、证书使用的认可标志代码","55、风险系数","56、认证证书附件文件名","57、上报类型","58、备注","59、是否超期审核项目","60、审核方案编号","61、超期原因","62、策划审核的开始日期","63、程序文件编号","64、基础人日数","65、防疫产品分类代码","取数开始日期","取数截止日期"]
[null,"数据类型","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","NUMBER","VARCHAR2","NUMBER","NUMBER","DATE","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","NUMBER","NUMBER","DATE","DATE","NUMBER","VARCHAR2","VARCHAR2","DATE","DATE","DATE","VARCHAR2","VARCHAR2","DATE","DATE","VARCHAR2","DATE","VARCHAR2","VARCHAR2","DATE","VARCHAR2","VARCHAR2","DATE","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","DATE","VARCHAR2","NUMBER","VARCHAR2","Date","Date"]
[null,"最大长度（字符）",30,300,"300",300,300,20,100,3,6,450,100,50,"(12,4)",2,10,10,null,50,10,300,500,2,2000,2000,2000,2000,4,4,2,null,null,"（3,3）",2,100,{"$nulls":3},4,100,null,null,100,null,2,50,null,100,2,null,2,20,50,100,100,2,100,"2","4000",2,100,10,null,100,"6,3","500"]
["证书信息表","填表说明","认监委颁发的认证机构批准号","填写实施审核活动的认证机构分支机构名称，如没有分支机构则填写认证机构名称","填写认证证书上打印的获证组织名称","当获证组织有多个名称，如英文名称等可以填写","当获证组织更名时为必填项","填写中国境内地区（国家地区代码为156）获证组织的18位统一社会信用代码。当国家代码为999时，获证组织的统一社会信用代码不用填写。统一社会信用代码查询网址https://www.cods.org.cn/","参照GB/T 4754-2017《国民经济行业分类代码》，只能填写一个4位代码，不能填写多个","按《世界各国和地区名称代码》中的3位数字码填写。没有统一社会信用代码的中国境内组织，国家代码填写999","当获证组织注册地址所在国家地区代码为中国大陆、香港、澳门、台湾时，行政区域应依据《地区行政区划代码》填写；否则此项为空","按注册地址、通讯地址、实际经营地址顺序（最多填3个地址，三者一致的填写一个）用全角分号分隔","填写获证组织的联系电话","如果无法定代表人则填写企业负责人","8位整数，4位小数，单位：万元（政府部门等如果没有注册资本，则填0）","填写常见币种代码，参照《货币类型代码》填写，若代码表中不存在，则应折算为人民币填写","获证组织所有员工数","体系覆盖的组织员工数","认证机构确认的获证组织该项认证的首次获证日期，填写格式为YYYY-MM-DD","自动转化成大写、去除所有空格后入库；统一查询系统证书号可以输入大、小写及空格作为查询条件（系统自动去空格、转大写后进行查询）","按CNCA规定的《认证项目分类代码》填写","根据《CNAS业务范围代码》填写认证项目分类代码对应的业务范围代码；如没有对应代码则为空。有多个业务范围代码时，用全角分号分隔；当“证书使用的认可标志代码”包含“01”（CNAS标志）时，必填","必填","参照《是非选项代码》","填写有法律证明文件的场所，多场所用全角分号分隔。当一张证书覆盖多个分支机构的，可以通过该字段来描述，填写不下时填写“详见附件”，上传附件填报详细内容","与认证证书表述一致","当“认证项目分类代码”前5位为“A0102”（EC9000）时，此项必填；否则应为空值","当“认证项目分类代码”前5位为“A0901”（EnMS）时，此项必填；否则应为空值","必填，参照《认证审核活动代码》填写；只填写主要认证审核活动代码（单项）","带cnas标识证书必填，填写当前处于第几次再认证；其他选填","带cnas标识证书必填，填写当前处于本认证周期的第几次监督；其他选填","如果本次上报认证审核活动代码不为“05变更”，则填报审核活动一阶段的审核开始日期；格式：YYYY-MM-DD","如果本次上报认证审核活动代码不为“05变更”，则填报审核活动二阶段的审核截止日期；格式：YYYY-MM-DD","认证审核活动代码不为“05变更”时必填，该领域考虑了增/减因素和结合审核等情况后，最终实施的实际审核人天数（不包括文审）","必填；参照《结合审核类型》码表填写","必须填写批准本次认证活动评价结论的人员姓名（如批准变更、暂停等），如为多人用全角分号分隔","必填，格式YYYY-MM-DD","必填，颁证日期小于等于上报日期，格式为YYYY-MM-DD","必填，格式为YYYY-MM-DD；如果是子证书，则其截止日期<=主证书的截止日期；当“证书状态”为“01有效”时，证书截止日期应≥当前日期。","必填，按照《证书状态分类代码》填写","当“证书状态”为“02暂停”时，必填，参照《管理体系证书暂停原因代码》填写。可填多值，之间用全角分号分隔表示，否则应为空值","当“证书状态”为“02暂停”时，必填；格式YYYY-MM-DD","当“证书状态”为“02暂停”时，必填；格式YYYY-MM-DD","当“证书状态”为“03撤销”或者“04注销”时，必填，参照《管理体系证书注销/撤销原因代码》填写；否则应为空值","当“证书状态”为“03撤销”或者“04注销”时，必填，格式YYYY-MM-DD","必填，参照《是非选项代码》填写","当“是否子证书”为“是”，此项必填；否则应为空值","当“变更类别代码”不为空时，此项必填，格式YYYY-MM-DD；否则应为空值","当“上报类型”为“05证书状态变化”或者“认证审核活动代码”为“05变更”时应依据《证书变更类别》填写，多值之间采用全角分号分隔；否则选填","参照《是非选项代码》填写","当“上报类型”为“02换发证书”时，此项必填且小等于上报日期，格式YYYY-MM-DD；否则应为空值","当“上报类型”为“02换发证书”时，此项必填，参照《换证原因代码》填写，只允许填写主要原因（单项）；否则应为空值","当“上报类型”为“02换发证书”时，此项必须填写原颁证的认证机构批准号；否则应为空值","当“上报类型”为“02换发证书”时，此项必须填写原证书号；否则应为空值","指打印在认证证书上与认可标志一起使用的认可机构给认证机构颁发的认可证书编号，多值之间用全角分号分隔","依据《认可标志分类代码》填写，未获得认可不用填写；使用多个认可标志时，用全角分号分隔","带CNAS认可标志的质量、环境、职业健康安全、信息安全管理体系认证此项为必填项。当涉及多个业务范围代码时，仅填写最高风险级别，参照《风险级别代码》填写；其他情况不用填写","填写附件压缩包中与该认证证书号对应的文件名称（带后缀），多个文件名称使用全角分号分隔；如果此处填写了文件名，则必须在附件压缩包中包含该文件；如无附件应为空值","必填；按《上报类型代码表》填写本次证书信息上报的类型","根据需要填写备注内容","当使用CNAS标志时必填；参照《是非选项代码》填写","当“是否超期审核项目”字段为“1”时必填，填写认证机构对该项目的审核方案编号","当“是否超期审核项目”字段为“1”时必填，参照《超期审核原因代码》填写（01季节生产；02企业无在建项目；03企业未按约定付款；04企业改革（重组）尚未结束；05其它）。可填多值之间用全角分号分隔表示","当“是否超期审核项目”字段为“1”时必填，根据认证机构监督再认证管理程序规定，策划本项目实施审核的开始日期（不是实际审核日期），格式：YYYY-MM-DD","当“是否超期审核项目”字段为“1”时必填，认证机构有关监督再认证管理的程序文件编号","填写该领域按照CNAS-CC105《确定管理体系审核时间（QMS、EMS和OHSMS）》的附表中相对应的基础人日数","当获证企业生产的产品为防疫用品时，按照《防疫产品分类代码表》填写，多个代码之间用全角分号；分隔\n","仅用于机构自助提醒，上报平台不使用","仅用于机构自助提醒，上报平台不使用"]
[null,"校验级别",1,1,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,0,1,1,1,"1",0,1,1,1,1,1,1,1]
[null,"是否公开","是","否","是","否","否","是","否","是","是","是","否","否","否","否","否","是","是","是","是","否","是","是","是","是","是","是","是","是","是","否","否","否","否","否","否","是","是","是","否","是","是","否","是","否","是","是","是","否","是","否","否","否","否","是","否","是","否","否","否","否","否","否","否","否","否"]
["从C8元格开始填写上报信息",null,"CNCA-R-2019-523","世纪科环检验认证（北京）有限公司","重庆博而达办公设备有限公司","","","91500102MA618YGD3A","5199","156","500102","重庆市涪陵区新妙镇适园村适园路5社1-1；重庆市九龙坡区二郎火炬大道99号千叶大厦1栋18-3；重庆市九龙坡区二郎火炬大道99号千叶大厦1栋18-3","13508348796","徐俊峰","1080","01","15","15","2023-08-17","52323E000014R0S","A0201","29.10.05","GB/T 24001-2016/ISO 14001:2015标准要求","0","","钢制家具（手动密集架、智能密集架、书架、货架、文件柜、更衣柜、公寓床）的销售所涉及场所的相关环境管理活动",null,null,"05",{"$nulls":5},"01","王琳","2023-08-17","2023-08-17","2026-08-16","01",{"$nulls":3},"","","0","","2024-11-03","0197","0","","","","","","99",null,null,"05","","0","","","","","2.5"]

{"sheet":"审核结果信息表","index":1,"n_rows":7,"n_cols":16,"rows_kept":7,"merged":[[1,0,3,0],[4,0,6,0]],"flags":["formulas_cached_only"]}
["103011","字段名称","RZJG_ID","CERT_NUMBER","APPR_STAGE","APPR_S_DATE","APPR_E_DATE","FULL_NAME","IDENTITY_CODE","ID_CODE","APPR_M_ROLE","QUA_CODE","APT_CERTI_NUM","IS_PROF_M","IS_SPECIAL","OBSERVER_FLAG"]
["管理体系及服务认证信息上报数据模版","字段含义","1、认证机构批准号","2、认证证书号","3、认证审核阶段代码","4、审核开始日期","5、审核截止日期","6、审核组成员姓名","7、身份证件类型代码","8、身份证件号码","9、审核组成员角色代码","10、审核组成员资格类型代码","11、审核组成员资质注册号","12、是否专业审核员","13、是否专职人员","14、见证人标识"]
[null,"数据类型","VARCHAR2","VARCHAR2","VARCHAR2","DATE","DATE","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2"]
[null,"最大长度（字符）","30","50","4",null,null,"20","2","30","2","2","20","2","2",2]
["审核结果信息表","填表说明","必填；认监委颁发的认证机构批准号","必填；与证书信息表中证书号一致","必填；参照《认证审核阶段代码》填写","必填；格式：YYYY-MM-DD hh:mm:ss 每个审核阶段按每个审核员填写","必填；格式：YYYY-MM-DD hh:mm:ss 每个审核阶段按每个审核员填写","必填；只能填写1个人","必填；参照《从业人员证件类型代码》填写","必填","必填；参照《审核组成员角色代码》填写","必填；参照《资格类型代码》填写","必填；审核员/审查员应填写CCAA的注册号；技术专家填写本机构的人员编号。","必填；参照《是非选项代码》","必填；参照《是非选项代码》","参照《见证人标识代码》，可以为空值"]
[null,"校验级别",1,null,"1","1","1","1","1","1","1","1","1","1","1","1"]
[null,"是否公开","是","是","是","否","否","是","否","否","否","是","是","否","否","否"]

{"sheet":"能源绩效信息表","index":2,"n_rows":7,"n_cols":14,"rows_kept":7,"merged":[[1,0,3,0],[4,0,6,0]],"flags":["formulas_cached_only"]}
["103012","字段名称","RZJG_ID","CERT_NUMBER","CYCLE_IDENTIFY","EN_S_DATE","EN_E_DATE","OUT_VALUE","INTEG_EN","P_PRO_NAME","P_PRO_OUT","P_PRO_UNIT","P_PRO_UNIT_DES","P_PRO_EN_EI"]
["管理体系及服务认证信息上报数据模版","字段含义","1、认证机构批准号","2、认证证书号","3、报送周期标识","4、能耗统计开始日期","5、能耗统计截止日期","6、审核统计期间工业总产值","7、审核统计期间综合能耗","8、审核统计期间第Pi种产品名称","9、审核统计期间第Pi种产品产量","10、第PI种产品单位","11、第PI种产品单位说明","12、审核对应Pi种产品的综合能耗Ei"]
[null,"数据类型","VARCHAR2","VARCHAR2","VARCHAR2","DATE","DATE","NUMBER","NUMBER","VARCHAR2","NUMBER","VARCHAR2","VARCHAR2","NUMBER"]
[null,"最大长度（字符）",30,50,2,null,null,"10,4","20,4",50,"10,4",2,10,"20,4"]
["能源绩效信息表","填表说明","认监委颁发的认证机构批准号","与证书信息表中证书号一致","必填；参照《报送周期标识代码》填写，01---认证前能耗信息02---本次审核统计期间能耗信息。如果认证审核活动代码前两位为“01初审”），必须同时上报认证前（01）能耗信息和本次审核统计期间（02）能耗信息；否则，只能上报本次审核统计期间能耗信息（02）。\n","格式：YYYY-MM-DD","格式：YYYY-MM-DD","单位：万元。可以精确到小数点后4位。","单位：吨标准煤。可以精确到小数点后4位。",null,"如建筑行业，此项填写总建筑面积。可以精确到小数点后4位。","参照《产品产量单位代码》填写","当“第PI种产品单位”为“99其他”时，此项必填","如建筑行业，此项填写单耗/平方米，对应Pi种综合能耗累计值应等于年综合能耗。"]
[null,"校验级别",1,"1","1","1","1","1","1","1","1","1","1","1"]
[null,"是否公开","否","否","否","否","否","否","否","否","否","否","否","否"]