ins_dm.sql

公务员工资系统软件工程文档及源代码——JAVA编写（包括整个分析设计代码实现全过程）

--所属行业
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','A00','农、林、牧、渔、业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','A01','农业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','A02','林业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','A03','畜牧业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','A04','渔业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','A05','农、林、牧、渔服务业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','B00','采掘业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','B06','煤炭开采和洗选业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','B07','石油和天然气开采业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','B08','黑色金属矿采选业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','B09','有色金属矿采选业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','B10','非金属矿采选业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','B11','其它采矿业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C00','制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C13','农副食品加工业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C14','食品制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C15','饮料制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C16','烟草制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C17','纺织业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C18','纺织服装、鞋、帽制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C19','皮革、毛皮、羽毛（绒）及其制品业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C20','木材加工及木、竹、藤、棕、草制品');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C21','家具制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C22','造纸及纸制品业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C23','印刷业、记录媒介的复制');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C24','文教体育用品制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C25','石油加工及炼焦业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C26','化学原料及化学制品制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C27','医药制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C28','化学纤维制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C29','橡胶制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C30','塑料制品业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C31','非金属矿物制品业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C32','黑色金属冶炼及压延加工业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C33','有色金属冶炼及压延加工业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C34','金属制品业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C35','通用设备制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C36','专用设备制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C37','交通运输设备制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C39','电气机械及器材制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C40','通用设备、计算机及其他电子设备制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C41','仪器、仪表及文化、办公用机械制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C42','工艺品及其他制造业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','C43','废弃资源和废旧材料回收加工业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','D00','电力、煤气及水的生产和供应业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','D44','电力、热力的生产和供应业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','D45','燃气生产和供应业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','D46','水的生产和供应业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','E00','建筑业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','E47','房屋和土木工程建筑业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','E48','建筑安装业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','E49','建筑装饰业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','E50','其他建筑业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','F00','交通运输、仓储和邮政业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','F51','铁路运输业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','F52','道路运输业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','F53','城市公共交通业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','F54','水上运输业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','F55','航空运输业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','F56','管道运输业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','F57','装卸搬运和其他运输服务业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','F58','仓储业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','F59','邮政业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','G00','信息传输、计算机服务和软件业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','G60','电信和其他信息传输服务业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','G61','计算机服务业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','G62','软件业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','H00','批发和零售业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','H63','批发业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','H65','零售业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','I00','住宿和餐饮业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','I66','住宿业（旅馆业）');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','I67','餐饮业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','J00','金融业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','J68','银行业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','J69','证券业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','J70','保险业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','J71','其他金融活动');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','K00','房地产业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','K72','房地产业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','L00','租赁和商务服务业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','L73','租赁业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','L74','商务服务业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','M00','科学研究、技术服务和地质勘查业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','M75','研究与试验发展');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','M76','专业技术服务业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','M77','科技交流和推广服务业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','M78','地质勘查业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','N00','水利、环境和公共设施管理业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','N79','水利管理业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','N80','环境管理业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','N81','公共设施管理业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','O00','居民服务和其他服务业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','O82','居民服务业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','O83','其他服务业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','P00','教育');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','P84','教育');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','Q00','卫生、社会保障和社会福利业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','Q85','卫生');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','Q86','社会保障业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','Q87','社会福利业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','R00','文化、体育和娱乐业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','R88','新闻出版业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','R89','广播、电视、电影和音像业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','R90','文化艺术业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','R91','体育');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','R92','娱乐业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','S00','公共管理和社会组织');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','S93','中国共产党机关');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','S94','国家机构');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','S95','人民政协和民主党派');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','S96','群众团体、社会团体和宗教组织');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','S97','基层群众自治组织');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','T00','国际组织');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1004','T98','国际组织');


--单位类型
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1005','01','有限责任公司');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1005','02','股份有限公司');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1005','03','其他');


--单位减少原因
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1006','01','倒闭');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1006','02','兼并');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1006','03','破产');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1006','04','转出');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1006','05','其他');


--单位要求改的字段
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','dwmc','单位名称');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','dwxz','单位性质');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','swdjz','税务登记证号');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','dwfrm','单位法人码');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','sjdwmc','上级单位名称');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','sbdjh','社会保险登记号');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','yyzzh','营业执照号');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','dbr','法定代表人');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','bzhm','法定代表人身份证号');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','dbrzw','代表人职务');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','dblxdh','代表人联系电话');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','lzlxr','劳资办联系人');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','lzdh','劳资办电话');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','clrq','成立日期');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','yyqrq','营业起日期');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','yyzrq','营业截至日期');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','zczj','注册资金');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','zcdz','注册地址');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','zcqx','注册地所在区县');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','zcjd','注册地所在街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','jydz','经营地址');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','jyqx','经营地所在区县');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','jyjd','经营地所在街道');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','jyyzbm','经营地邮政编码');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','jyfw','经营范围');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','sshy','所属行业');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('1007','dwlx','单位类型');

/*****************
B02,执法检查信息部分代码
*****************/


--检查途径
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2001','01','群众举报');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2001','02','主动巡查');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2001','03','专项检查');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2001','04','年检');


--工时制度
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2002','01','标准工时');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2002','02','综合工时');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2002','03','不定时  ');


--专项检查名称
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2003','01','社会保险');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2003','02','劳动合同');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2003','03','擅自招用外来劳动力');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2003','04','拖欠工资');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2003','05','最低工资支付');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2003','06','职业中介');
INSERT INTO DM_MX(DMM,DM,MC) VALUES('2003','07','招用童工');
INSERT INTO DM_MX(DMM,DM,MC) VAL