|
-
- create table ods_GGZD
- (
- ZDID varchar2(32) ,
- ZDLX varchar2(32) ,
- ZDLXMC varchar2(64) ,
- DM varchar2(10),
- MC varchar2(64)
- );
- alter table ods_GGZD add constraint ods_GGZD_ZDID primary key (ZDID);
-
-
- INSERT INTO ods_GGZD VALUES ('046216277b024b9a82011aa4e518c431','syxxdm','双优学校代码','1','国家双优学校');
- INSERT INTO ods_GGZD VALUES ('2d2b8a07b3ec4b228b76b6110cb9d90f','syxxdm','双优学校代码','2','省级双优学校');
- INSERT INTO ods_GGZD VALUES ('2b168dad832e45f391df605608493170','syxxdm','双优学校代码','0','否');
- INSERT INTO ods_GGZD VALUES ('f3b9667e270942578ea68e38e40ade30','cydm','产业代码','1','第一产业');
- INSERT INTO ods_GGZD VALUES ('19f66f6f96d04232a5dd39ef786aacdd','cydm','产业代码','2','第二产业');
- INSERT INTO ods_GGZD VALUES ('f51b71edc5164bdf81b95cc8ac954f38','cydm','产业代码','3','第三产业');
- INSERT INTO ods_GGZD VALUES ('8e061316e87c4f439096ca468db1ab9b','dwxzdm','单位性质代码','10','机关');
- INSERT INTO ods_GGZD VALUES ('fa2fe7ea9a3b414d84b1ba76e47d5393','dwxzdm','单位性质代码','11','省级以上党政机关');
- INSERT INTO ods_GGZD VALUES ('1d8ae87ee9e240ce9d015c08df59f855','dwxzdm','单位性质代码','12','省级以下党政机关');
- INSERT INTO ods_GGZD VALUES ('564ad50bd8a74263ac0259abb42def15','dwxzdm','单位性质代码','20','事业单位');
- INSERT INTO ods_GGZD VALUES ('d72a729d52564d1e8bc3a08640f45721','dwxzdm','单位性质代码','21','科研设计单位');
- INSERT INTO ods_GGZD VALUES ('e1b86b912c1a43c59db59f9a1b9be884','dwxzdm','单位性质代码','22','高等学校');
- INSERT INTO ods_GGZD VALUES ('1156bd673402407dac3a0ec857288339','dwxzdm','单位性质代码','23','其他教育单位');
- INSERT INTO ods_GGZD VALUES ('c14ff329ade8413584a2417802b85414','dwxzdm','单位性质代码','24','医疗卫生单位');
- INSERT INTO ods_GGZD VALUES ('4f92aaa01e4b4db880295d91173c33af','dwxzdm','单位性质代码','25','体育文化单位');
- INSERT INTO ods_GGZD VALUES ('2a4950875d65408cacf9d2222c2a367d','dwxzdm','单位性质代码','29','其他事业单位');
- INSERT INTO ods_GGZD VALUES ('b050fade65984504adc09c3e3757e803','dwxzdm','单位性质代码','30','企业');
- INSERT INTO ods_GGZD VALUES ('c34dc50c7c22420991b2299342eb9122','dwxzdm','单位性质代码','31','国有企业');
- INSERT INTO ods_GGZD VALUES ('f11c81b3093f473893821595e529ec2a','dwxzdm','单位性质代码','32','中外合资企业');
- INSERT INTO ods_GGZD VALUES ('f2427ddbd44b4c63ab9ed38af3819316','dwxzdm','单位性质代码','33','民营(私营)企业');
- INSERT INTO ods_GGZD VALUES ('cfac54ba07ca4f5ea4f99805e3d42d74','dwxzdm','单位性质代码','34','外资企业');
- INSERT INTO ods_GGZD VALUES ('4170258247754872a4039d82cfa12a44','dwxzdm','单位性质代码','35','集体企业');
- INSERT INTO ods_GGZD VALUES ('4b9bea57bb8f43888ca0a22304ecbea6','dwxzdm','单位性质代码','39','其他企业');
- INSERT INTO ods_GGZD VALUES ('ac5dbea5303a4e0998699a732731428f','dwxzdm','单位性质代码','40','部队');
- INSERT INTO ods_GGZD VALUES ('0f596d09e04b4f7ea261045dde1d2be4','dwxzdm','单位性质代码','50','社会组织机构');
- INSERT INTO ods_GGZD VALUES ('b2eec166c35b4c2e82f46d32550f86fa','dwxzdm','单位性质代码','60','国际组织机构');
- INSERT INTO ods_GGZD VALUES ('cc232d19c4764d5899ea3669c8ac81db','dwxzdm','单位性质代码','70','国防科工机构');
- INSERT INTO ods_GGZD VALUES ('6754a55aa35c4de5a5838d021d42c9d4','dwxzdm','单位性质代码','80','财政金融机构');
- INSERT INTO ods_GGZD VALUES ('90075869029a48948813cdfb7dabcb39','dwxzdm','单位性质代码','99','其他');
- INSERT INTO ods_GGZD VALUES ('ba2880adeb4f4700a3c58a51a6b53596','zcbmjbdm','支持部门级别代码','1','国家级');
- INSERT INTO ods_GGZD VALUES ('17197c2cc3ea4515935b8d4cc185c544','zcbmjbdm','支持部门级别代码','2','省级');
- INSERT INTO ods_GGZD VALUES ('79e26f197f28420d841237b092afb75c','zcbmjbdm','支持部门级别代码','3','地市级');
- INSERT INTO ods_GGZD VALUES ('7614d8a6f1d74768a91b187acb81bf5d','zcbmjbdm','支持部门级别代码','0','其他');
- INSERT INTO ods_GGZD VALUES ('1a79ee80cab04bcf84a9bc873b049c1e','xxjdlbdm','实训基地类别代码','1','校内实训教学基地');
- INSERT INTO ods_GGZD VALUES ('b05fd0ea03f246ad832c9f36bf5646c1','xxjdlbdm','实训基地类别代码','2','虚拟仿真实训基地');
- INSERT INTO ods_GGZD VALUES ('61a60ee594874dc1bbfce603ea7371ad','xxjdlbdm','实训基地类别代码','3','校中厂');
- INSERT INTO ods_GGZD VALUES ('8ce04f6dd68f4bbda393555917fa11e5','xxjdlbdm','实训基地类别代码','4','开放实训基地');
- INSERT INTO ods_GGZD VALUES ('bf880df9cac0478f88fc9c0560f85807','xxjdlbdm','实训基地类别代码','0','其它');
- INSERT INTO ods_GGZD VALUES ('c8ba61d634904e59b25c6c8634bdc90c','xxlbdm','学校类别代码','361','调整后中等职业学校');
- INSERT INTO ods_GGZD VALUES ('38025ae70e02436b92d4f2e46172ef1c','xxlbdm','学校类别代码','362','中等技术学校');
- INSERT INTO ods_GGZD VALUES ('cd4d524421094b8e87081628042e8120','xxlbdm','学校类别代码','363','中等师范学校');
- INSERT INTO ods_GGZD VALUES ('644d7f90fbfc49dca722f6571ac37eb8','xxlbdm','学校类别代码','364','成人中等专业学校');
- INSERT INTO ods_GGZD VALUES ('1c835ae5e1f54d0f867056fdd4064240','xxlbdm','学校类别代码','365','职业高中学校');
- INSERT INTO ods_GGZD VALUES ('eb6ff2b7bf3d4fa68bf7158b898cae00','xxlbdm','学校类别代码','366','技工学校');
- INSERT INTO ods_GGZD VALUES ('b1c2b90e38324d6ab56100e2ba96b469','xxlbdm','学校类别代码','368','附设中职班');
- INSERT INTO ods_GGZD VALUES ('7b4f00997ba348d0b5bb424599573f09','xxlbdm','学校类别代码','369','其他中职机构');
- INSERT INTO ods_GGZD VALUES ('75ec9d4f746a478db26d3fc0ae25a23f','xxjbzxzdm','学校举办者性质代码','811','省级教育部门');
- INSERT INTO ods_GGZD VALUES ('6efb0c1176514094b0d12ac1e8655414','xxjbzxzdm','学校举办者性质代码','812','省级其他部门(党政机关)');
- INSERT INTO ods_GGZD VALUES ('66377361280d475eb117fc355bec3dd7','xxjbzxzdm','学校举办者性质代码','821','地级教育部门');
- INSERT INTO ods_GGZD VALUES ('efa9a5efa08043d1b395600961e577e4','xxjbzxzdm','学校举办者性质代码','822','地级其他部门(党政机关)');
- INSERT INTO ods_GGZD VALUES ('261750e4ebed402abe1d52f3673b92da','xxjbzxzdm','学校举办者性质代码','831','县级教育部门');
- INSERT INTO ods_GGZD VALUES ('1acb1c02def4441598b1988b89a9cde9','xxjbzxzdm','学校举办者性质代码','832','县级其他部门(党政机关)');
- INSERT INTO ods_GGZD VALUES ('fff4f01704384321a27e093369f11903','xxjbzxzdm','学校举办者性质代码','891','地方企业');
- INSERT INTO ods_GGZD VALUES ('8a23e95b68a749dfae5de28d4b51dffb','xxjbzxzdm','学校举办者性质代码','999','民办');
- INSERT INTO ods_GGZD VALUES ('86fb930752ce492b915878ad14594114','kcfldm','课程分类代码','1','公共基础课');
- INSERT INTO ods_GGZD VALUES ('35fe018db8e842119b41ff6705deb9a8','kcfldm','课程分类代码','2','专业核心课');
- INSERT INTO ods_GGZD VALUES ('1fcfaf184a104ca3a80955d28150bcfe','kcfldm','课程分类代码','3','专业基础课');
- INSERT INTO ods_GGZD VALUES ('2a31e470444f48a4999d230e7deb9bc7','kcfldm','课程分类代码','4','军训');
- INSERT INTO ods_GGZD VALUES ('d603df8e6a774c00ab66b4282034f6f1','kcfldm','课程分类代码','5','社会实践');
- INSERT INTO ods_GGZD VALUES ('f9c6117939a04de4b6968e5045ad2b3f','kcfldm','课程分类代码','6','综合实训');
- INSERT INTO ods_GGZD VALUES ('62c853b9b14b454a960c552745862f53','kcfldm','课程分类代码','7','认知实习');
- INSERT INTO ods_GGZD VALUES ('eb0d8dad87ad4e638a7d6b973b009860','kcfldm','课程分类代码','8','岗位实习');
- INSERT INTO ods_GGZD VALUES ('1321f936508b4faa99c0b77d4a975f86','kclbdm','课程类别代码','1','A 类(纯理论课)');
- INSERT INTO ods_GGZD VALUES ('3ae72f70c10343ec8ba0e9e066bd4649','kclbdm','课程类别代码','2','B 类((理论+实践)课');
- INSERT INTO ods_GGZD VALUES ('634c82da121d476eafce6547f8433e3b','kclbdm','课程类别代码','3','C 类(纯实践课)');
- INSERT INTO ods_GGZD VALUES ('205efd14f20a42d8b5513b17a9bf34b1','kcxzdm','课程性质代码','1','公共课');
- INSERT INTO ods_GGZD VALUES ('cfc124b683ef478ea6f71324dd251883','kcxzdm','课程性质代码','2','专业课');
- INSERT INTO ods_GGZD VALUES ('db6d2446b21644099cce55b5cc96ad4e','kcsxdm','课程属性代码','1','必修课');
- INSERT INTO ods_GGZD VALUES ('951a9da2b94f428a8da4951aaed0c380','kcsxdm','课程属性代码','2','选修课');
- INSERT INTO ods_GGZD VALUES ('ee9b437925e4421babaf7d81b3d69b99','xklbdm','学科类别代码','14','思想政治');
- INSERT INTO ods_GGZD VALUES ('7cb28bb8c80c46f1bd8f9d5cf0e366c1','xklbdm','学科类别代码','21','语文');
- INSERT INTO ods_GGZD VALUES ('8ec9c0b5c66140739430ab22c312adbe','xklbdm','学科类别代码','15','历史');
- INSERT INTO ods_GGZD VALUES ('f0e69430b8f54c1ca22c1ef05fdf860a','xklbdm','学科类别代码','22','数学');
- INSERT INTO ods_GGZD VALUES ('b51cb3cc45894c3ab13fc52cd2ec8624','xklbdm','学科类别代码','36','信息技术');
- INSERT INTO ods_GGZD VALUES ('af4a77aa0c2849f4973b59c535bb589a','xklbdm','学科类别代码','33','艺术');
- INSERT INTO ods_GGZD VALUES ('cc09511ff7fd4e5380384b89882e2869','xklbdm','学科类别代码','34','音乐');
- INSERT INTO ods_GGZD VALUES ('bc31330b75e84b298c5d017d4246fd80','xklbdm','学科类别代码','35','美术');
- INSERT INTO ods_GGZD VALUES ('3fee8061567a4344b9c876c1f46e3f04','xklbdm','学科类别代码','32','体育与健康');
- INSERT INTO ods_GGZD VALUES ('354c220d2d2b4b3a96cc7f72cdc122d6','xklbdm','学科类别代码','40','外语');
- INSERT INTO ods_GGZD VALUES ('509c2a5932f14427bc81aec0ff1a0b64','xklbdm','学科类别代码','27','地理');
- INSERT INTO ods_GGZD VALUES ('477376ae7d5447b0b87b5488885680f0','xklbdm','学科类别代码','24','物理');
- INSERT INTO ods_GGZD VALUES ('051085ebf15b4fe4bd93ea08a90a79f9','xklbdm','学科类别代码','25','化学');
- INSERT INTO ods_GGZD VALUES ('93e6ad5ba65440328579d13950566071','xklbdm','学科类别代码','26','生物');
- INSERT INTO ods_GGZD VALUES ('4873dbf5f9ed4cdab414c6fcb2efed22','xklbdm','学科类别代码','62','劳动与技术');
- INSERT INTO ods_GGZD VALUES ('e7b5b044fa674be98f9450bd230d7798','xklbdm','学科类别代码','63','研究性学习活动(综合实践活动)');
- INSERT INTO ods_GGZD VALUES ('3b9a8ce274c849618a22ecf9314c7541','xklbdm','学科类别代码','65','社区服务(综合实践活动)');
- INSERT INTO ods_GGZD VALUES ('9a5c99cc7eab4e02b389b7e6b7928edb','xklbdm','学科类别代码','66','社会实践(综合实践活动)');
- INSERT INTO ods_GGZD VALUES ('ad746f5f87264278b0d22b710161712f','xklbdm','学科类别代码','37','通用技术');
- INSERT INTO ods_GGZD VALUES ('a5ce39522f5d4bd7acc28a0cde63bfbe','xklbdm','学科类别代码','10000','农林牧渔类');
- INSERT INTO ods_GGZD VALUES ('4c8c8d8ff3c943369031626efd374e9f','xklbdm','学科类别代码','20000','资源环境类');
- INSERT INTO ods_GGZD VALUES ('5356d4ec148e432e978f2d3157992abc','xklbdm','学科类别代码','30000','能源与新能源类');
- INSERT INTO ods_GGZD VALUES ('2a32b10be9da44b6ae6a5470cc77d95f','xklbdm','学科类别代码','40000','土木水利类');
- INSERT INTO ods_GGZD VALUES ('b897baea50ee450e9ba6f80b49916595','xklbdm','学科类别代码','50000','加工制造类');
- INSERT INTO ods_GGZD VALUES ('960f32cfa4504a459c472617db5db136','xklbdm','学科类别代码','60000','石油化工类');
- INSERT INTO ods_GGZD VALUES ('12c926ea157944d18a979fc2b0321513','xklbdm','学科类别代码','70000','轻纺食品类');
- INSERT INTO ods_GGZD VALUES ('53d107b2c4e54f0ba159767f3769201b','xklbdm','学科类别代码','80000','交通运输类');
- INSERT INTO ods_GGZD VALUES ('6c9b017033fd4b7ebfc133e4eb1cac80','xklbdm','学科类别代码','90000','信息技术类');
- INSERT INTO ods_GGZD VALUES ('612cd6f81cc440c9ad0c80aaca38f151','xklbdm','学科类别代码','100000','医药卫生类');
- INSERT INTO ods_GGZD VALUES ('6aa161e3c7424fa59998c6766712ab52','xklbdm','学科类别代码','110000','休闲保健类');
- INSERT INTO ods_GGZD VALUES ('3bb73efcc7a24bb2866107ccb73e2ae8','xklbdm','学科类别代码','120000','财经商贸类');
- INSERT INTO ods_GGZD VALUES ('fde86dc3d5f84baf94ff84d8181759ed','xklbdm','学科类别代码','130000','旅游服务类');
- INSERT INTO ods_GGZD VALUES ('988997b4b9db4e2f9b739eb0601cf128','xklbdm','学科类别代码','140000','文化艺术类');
- INSERT INTO ods_GGZD VALUES ('3d3fa655a8c845958957d6a721311ccf','xklbdm','学科类别代码','150000','体育与健身');
- INSERT INTO ods_GGZD VALUES ('fd32267731fa44b68df6d7496d1c6869','xklbdm','学科类别代码','160000','教育类');
- INSERT INTO ods_GGZD VALUES ('28945d401ebf41b7985961976602cd20','xklbdm','学科类别代码','170000','司法服务类');
- INSERT INTO ods_GGZD VALUES ('af59cc83e1e64b82918de630b3c860ea','xklbdm','学科类别代码','180000','公共管理与服务类');
- INSERT INTO ods_GGZD VALUES ('042973aea6ef43f98022d59252e93549','jcxzdm','教材性质代码','1','国家统编教材');
- INSERT INTO ods_GGZD VALUES ('319f399dba414256b8889566440d9837','jcxzdm','教材性质代码','2','国家规划教材');
- INSERT INTO ods_GGZD VALUES ('5932dad2414f40ba8a2ce17f90e46edb','jcxzdm','教材性质代码','3','省级规划教材');
- INSERT INTO ods_GGZD VALUES ('172c81f6f8684bef8ee25cd6c3dfe9c5','jcxzdm','教材性质代码','4','校企合编教材');
- INSERT INTO ods_GGZD VALUES ('2815654770694747a678d44f791bb39b','jcxzdm','教材性质代码','5','自编教材');
- INSERT INTO ods_GGZD VALUES ('9d390aa37daf4c37976495f4bb65eb28','jcxzdm','教材性质代码','6','讲义');
- INSERT INTO ods_GGZD VALUES ('434865d08e724dc4933d3c1d871bc051','jcxzdm','教材性质代码','0','其他');
- INSERT INTO ods_GGZD VALUES ('21096c499dac4b228beb05d494a8c404','jcsyccdm','教材适用层次代码','1','中职');
- INSERT INTO ods_GGZD VALUES ('ff48cd379aaa4e0787ed03cbc9c8b9ee','jcsyccdm','教材适用层次代码','2','专科');
- INSERT INTO ods_GGZD VALUES ('de838468986b484fbb9cee63e4d24988','jcsyccdm','教材适用层次代码','3','职业本科');
- INSERT INTO ods_GGZD VALUES ('6f0e0c1e9cac471fa55924c1449b8595','jcsyccdm','教材适用层次代码','0','其他');
- INSERT INTO ods_GGZD VALUES ('34a3894bb9c649a6868f70ba284c5525','jchjqkdm','教材获奖情况代码','1','首届国家教材建设奖优秀教材特等奖');
- INSERT INTO ods_GGZD VALUES ('c8dcc55441354520894fa3dc337c590a','jchjqkdm','教材获奖情况代码','2','首届国家教材建设奖优秀教材一等奖');
- INSERT INTO ods_GGZD VALUES ('d20564155a454990b69c2dde3fcc47a7','jchjqkdm','教材获奖情况代码','3','首届国家教材建设奖优秀教材二等奖');
- INSERT INTO ods_GGZD VALUES ('52e5a4670cc942cab909d66078228b5d','jchjqkdm','教材获奖情况代码','0','其他');
- INSERT INTO ods_GGZD VALUES ('fcbed3d447ad431d976fab81c29d69e7','sxlbdm','实习类别代码','1','认知实习');
- INSERT INTO ods_GGZD VALUES ('1649691c6cb340529b060c867ca958f6','sxlbdm','实习类别代码','2','岗位实习');
- INSERT INTO ods_GGZD VALUES ('8a0457e3d1cf49e08919a9c95a1d0fa9','sxlbdm','实习类别代码','0','其他');
- INSERT INTO ods_GGZD VALUES ('46e050252022439d953a85a2c0ada595','sxqxdm','实习去向代码','1','省内');
- INSERT INTO ods_GGZD VALUES ('fb738ce7a84d442680649b8d836d7f9f','sxqxdm','实习去向代码','2','省外');
- INSERT INTO ods_GGZD VALUES ('c4fa3f4d3657464499a495efea7fdcd5','sxqxdm','实习去向代码','3','境外');
- INSERT INTO ods_GGZD VALUES ('4869e2ae11f943769a7a65dff32291e5','sxdwlydm','实习单位来源代码','1','统一安排');
- INSERT INTO ods_GGZD VALUES ('0155ad0413be4eb1b01f5ad22325f404','sxdwlydm','实习单位来源代码','2','学校推荐');
- INSERT INTO ods_GGZD VALUES ('906f47fb33cf4089af5cd30b33f892a0','sxdwlydm','实习单位来源代码','3','自主选择');
- INSERT INTO ods_GGZD VALUES ('065317c3e8e9436d87fd08f7285031fc','sxcslxdm','实习场所类型代码','1','校内实习实训基地');
- INSERT INTO ods_GGZD VALUES ('22892fbe35f74d6fae4fee5dfe30e2ba','sxcslxdm','实习场所类型代码','2','校外实习实训基地');
- INSERT INTO ods_GGZD VALUES ('594b9da8d79d4b5792a03ab78c41e1ab','zxapdm','住宿安排代码','1','实习单位统一安排');
- INSERT INTO ods_GGZD VALUES ('a91999e1cbf44ecab465ef7576e6bd35','zxapdm','住宿安排代码','2','学校统一安排');
- INSERT INTO ods_GGZD VALUES ('f187be5e005748509a0e361ff7815a39','zxapdm','住宿安排代码','3','学生自主安排');
- INSERT INTO ods_GGZD VALUES ('9659c1ee26ab42d383669fe79557ae95','zydkcddm','专业对口程度代码','1','基本对口');
- INSERT INTO ods_GGZD VALUES ('a612b0fd960148dcb1cbc46b14d8d32d','zydkcddm','专业对口程度代码','2','对口');
- INSERT INTO ods_GGZD VALUES ('73a591fa5ad54c348848a9cbf1906686','zydkcddm','专业对口程度代码','0','专业不对口');
- INSERT INTO ods_GGZD VALUES ('8247b192fd504be18c3443ef1b31c8af','bxgmzldm','购买保险种类代码','1','学生实习责任保险');
- INSERT INTO ods_GGZD VALUES ('740b857e69334824ad4f50a1f0598034','bxgmzldm','购买保险种类代码','2','意外险');
- INSERT INTO ods_GGZD VALUES ('b9a81c2ca41e42df93921a4c544a9d22','bxgmzldm','购买保险种类代码','3','其他保险');
- INSERT INTO ods_GGZD VALUES ('98c396ae712b49c0a914c0f790c3b96b','bxgmzldm','购买保险种类代码','0','未购买');
- INSERT INTO ods_GGZD VALUES ('b7664d22632e43c09040ed79eafa9418','bxgmfdm','保险购买方代码','1','学校');
- INSERT INTO ods_GGZD VALUES ('90841272bd5e4d73b3075bb85e15692f','bxgmfdm','保险购买方代码','2','企业');
- INSERT INTO ods_GGZD VALUES ('4ec11e8139324223b85ebfbe8607d24b','bxgmfdm','保险购买方代码','0','其他');
- INSERT INTO ods_GGZD VALUES ('d375ab6325554ad4a9ba46834f991a25','zbdwjbdm','主办单位级别代码','1','国际级');
- INSERT INTO ods_GGZD VALUES ('21c4c747e704432aaf930164dbf087a5','zbdwjbdm','主办单位级别代码','2','国家级');
- INSERT INTO ods_GGZD VALUES ('971884bf2bb94fea8159a0e579235057','zbdwjbdm','主办单位级别代码','3','省部级');
- INSERT INTO ods_GGZD VALUES ('36cf398955024ce68ad6c1bebe429898','zbdwjbdm','主办单位级别代码','4','地市级');
- INSERT INTO ods_GGZD VALUES ('859acf5d14ae48c2a93bb856d4d6aa5c','zbdwjbdm','主办单位级别代码','5','区县级');
- INSERT INTO ods_GGZD VALUES ('bb9be6c320144e478c924401f33376c3','zbdwjbdm','主办单位级别代码','6','校级');
- INSERT INTO ods_GGZD VALUES ('2353f402054d4b9e9f6ece758502fb03','zbdwjbdm','主办单位级别代码','0','其他');
- INSERT INTO ods_GGZD VALUES ('ddaf419cf42a4c8db6414cf44960de03','dyhdlxdm','德育活动类型代码','1','讲座报告');
- INSERT INTO ods_GGZD VALUES ('123351425e0347bda86e7a766ba61b48','dyhdlxdm','德育活动类型代码','2','征文演讲');
- INSERT INTO ods_GGZD VALUES ('81f9925b5ba04823a74cc9cea22a1ec1','dyhdlxdm','德育活动类型代码','3','文艺表演');
- INSERT INTO ods_GGZD VALUES ('2f32f72b13d34977ab4ab8940316de76','dyhdlxdm','德育活动类型代码','4','参观走访');
- INSERT INTO ods_GGZD VALUES ('a6ad08a4021544a7ab4da6d6d7c5f170','dyhdlxdm','德育活动类型代码','5','志愿服务');
- INSERT INTO ods_GGZD VALUES ('57f502f43826450c93e6eed024cfd6a0','dyhdlxdm','德育活动类型代码','6','社会实践');
- INSERT INTO ods_GGZD VALUES ('43f39822015245bb93cf5a2707762221','dyhdlxdm','德育活动类型代码','7','分享交流');
- INSERT INTO ods_GGZD VALUES ('7716c08bd8a64dec87a7f1918d69ab2d','dyhdlxdm','德育活动类型代码','0','其他');
- INSERT INTO ods_GGZD VALUES ('6124f79db29b4e62a64d78fae1a02a58','dyhdztdm','德育活动主题代码','1','习近平新时代中国特色社会主义思想教育');
- INSERT INTO ods_GGZD VALUES ('6311ec046e5b41aa9bcdeca3ec804400','dyhdztdm','德育活动主题代码','2','“四史”教育');
- INSERT INTO ods_GGZD VALUES ('1548da20c7814b39b0b7c5d9f04776ed','dyhdztdm','德育活动主题代码','3','社会主义核心价值观教 育');
- INSERT INTO ods_GGZD VALUES ('4228d7d63e424838a63c72255002dd45','dyhdztdm','德育活动主题代码','4','爱国主义教育');
- INSERT INTO ods_GGZD VALUES ('83580753066043969097b0e1033b549a','dyhdztdm','德育活动主题代码','5','中华优秀传统文化教育');
- INSERT INTO ods_GGZD VALUES ('6b05b7f39e3d4449958b0ae7b8df48df','dyhdztdm','德育活动主题代码','6','法治教育');
- INSERT INTO ods_GGZD VALUES ('1ab8728347cf42cf8fa3d1359200615d','dyhdztdm','德育活动主题代码','7','国家安全教育');
- INSERT INTO ods_GGZD VALUES ('c135a3edcee04d14878b7f782e32dac0','dyhdztdm','德育活动主题代码','8','劳动教育');
- INSERT INTO ods_GGZD VALUES ('80ce4926c5b14ecf9026609fba803e6c','dyhdztdm','德育活动主题代码','9','健康教育');
- INSERT INTO ods_GGZD VALUES ('e4d8fda6492545f7a82093debbd17a3b','dyhdztdm','德育活动主题代码','10','职业生涯教育');
- INSERT INTO ods_GGZD VALUES ('bfd8d50a4556493e8b4f085e7fea0858','dyhdztdm','德育活动主题代码','0','其他');
- INSERT INTO ods_GGZD VALUES ('851da205b6f54e929a34271e27ba49e2','sthdlxdm','社团活动类型代码','1','公益服务');
- INSERT INTO ods_GGZD VALUES ('6c098f04d50a4e30843110db7e3125b8','sthdlxdm','社团活动类型代码','2','科学技术');
- INSERT INTO ods_GGZD VALUES ('34c58284f03b458fa50237b7c1f3ce71','sthdlxdm','社团活动类型代码','3','理论学习');
- INSERT INTO ods_GGZD VALUES ('2e22f37be5464d75bcffecece1161ced','sthdlxdm','社团活动类型代码','4','文艺体育');
- INSERT INTO ods_GGZD VALUES ('7f18e01a1f754ba2be500f2a2139901c','sthdlxdm','社团活动类型代码','5','其他');
- INSERT INTO ods_GGZD VALUES ('32170891051f4f5fa29840105a580156','dnldrzwdm','党内领导人员职务代码','1','书记');
- INSERT INTO ods_GGZD VALUES ('e576ca3516864d199ff9600c100a76c2','dnldrzwdm','党内领导人员职务代码','2','副书记');
- INSERT INTO ods_GGZD VALUES ('463f3d9ad89d4c0187934a3461cf98dd','dnldrzwdm','党内领导人员职务代码','3','组织委员');
- INSERT INTO ods_GGZD VALUES ('279fecd700914a0092820efe6a7cc8d6','dnldrzwdm','党内领导人员职务代码','4','宣传委员');
- INSERT INTO ods_GGZD VALUES ('3dc177bb15114986b411036bc4e05c99','dnldrzwdm','党内领导人员职务代码','5','纪检委员');
- INSERT INTO ods_GGZD VALUES ('e0dd3bf14fca417b8487168f002d0ffc','dnldrzwdm','党内领导人员职务代码','6','青年委员');
- INSERT INTO ods_GGZD VALUES ('f75edb17954444aea55d79790ffd5a5a','dnldrzwdm','党内领导人员职务代码','7','统战委员');
- INSERT INTO ods_GGZD VALUES ('be3d574817ab46eebff97bc20da12d7f','dnldrzwdm','党内领导人员职务代码','8','保密委员');
- INSERT INTO ods_GGZD VALUES ('12cf007bcba04aceb44aeab73949e7d5','dnldrzwdm','党内领导人员职务代码','9','妇女委员');
- INSERT INTO ods_GGZD VALUES ('077f55e0ba80421e976755afa9a8e558','dnldrzwdm','党内领导人员职务代码','10','其他');
- INSERT INTO ods_GGZD VALUES ('8e19413a59c34223aa29133954b4a10e','xdylxdm','新党员类型代码','1','教职工');
- INSERT INTO ods_GGZD VALUES ('e9b7e38b21654f958073d88357de8b98','xdylxdm','新党员类型代码','2','学生');
- INSERT INTO ods_GGZD VALUES ('2b371cac0c564c0c84397e398aaccd8a','xdylxdm','新党员类型代码','3','其他');
- INSERT INTO ods_GGZD VALUES ('6fea6d38d3484642834666ca25719d3b','xdyfzztdm','新党员发展状态代码','1','积极分子');
- INSERT INTO ods_GGZD VALUES ('915b6d30072b4602a62e00ccb23cd6a5','xdyfzztdm','新党员发展状态代码','2','预备党员');
- INSERT INTO ods_GGZD VALUES ('7e2e073dda6e4c05abc7ff338763b36e','xdyfzztdm','新党员发展状态代码','3','正式党员');
- INSERT INTO ods_GGZD VALUES ('32c077928a164b85838a4480600eddae','dygbxxpxzytjztdm','党员干部学习培训主要途径和载体代码','1','实践活动');
- INSERT INTO ods_GGZD VALUES ('ef4f7c7f64fc415f9e4ce65fa3855b8a','dygbxxpxzytjztdm','党员干部学习培训主要途径和载体代码','2','会议');
- INSERT INTO ods_GGZD VALUES ('918556a92f3545568a6311c9d6ef1c14','dygbxxpxzytjztdm','党员干部学习培训主要途径和载体代码','3','讲座报告');
- INSERT INTO ods_GGZD VALUES ('dedc9632ec7449719f355e979703c8c5','dygbxxpxzytjztdm','党员干部学习培训主要途径和载体代码','4','学校定期集中学习');
- INSERT INTO ods_GGZD VALUES ('12774670603e411c8ea15142f97fe58f','dygbxxpxzytjztdm','党员干部学习培训主要途径和载体代码','5','支部定期集中学习');
- INSERT INTO ods_GGZD VALUES ('c961bef4c9114166a907834171d34d15','dygbxxpxzytjztdm','党员干部学习培训主要途径和载体代码','6','微信 QQ');
- INSERT INTO ods_GGZD VALUES ('20b87bd4c8b64112beb6eb80688a1934','dygbxxpxzytjztdm','党员干部学习培训主要途径和载体代码','7','移动端培训平台');
- INSERT INTO ods_GGZD VALUES ('07aadf5f67054bd48b77db0865350fc8','dygbxxpxzytjztdm','党员干部学习培训主要途径和载体代码','8','分发图书资料');
- INSERT INTO ods_GGZD VALUES ('c704efa44a11434c949e666aedcb7f68','dygbxxpxzytjztdm','党员干部学习培训主要途径和载体代码','9','个人学习');
- INSERT INTO ods_GGZD VALUES ('5f4042e863a94272b24877ec15f92639','dygbxxpxzytjztdm','党员干部学习培训主要途径和载体代码','10','在线教育网站');
- INSERT INTO ods_GGZD VALUES ('3be3c4785e6846edbb3445b20703da87','dygbxxpxzytjztdm','党员干部学习培训主要途径和载体代码','11','参观学习');
- INSERT INTO ods_GGZD VALUES ('df91354eed1c48ebafa2df145394291f','dygbxxpxnrdm','党员干部学习培训内容代码','1','党的理论');
- INSERT INTO ods_GGZD VALUES ('0a0466ba82dc4f2586e93eb689eb3b69','dygbxxpxnrdm','党员干部学习培训内容代码','2','相关政策 文件');
- INSERT INTO ods_GGZD VALUES ('819f7a21003e4084868b57549e1e6d68','dygbxxpxnrdm','党员干部学习培训内容代码','3','党规党纪 及国家法律法规');
- INSERT INTO ods_GGZD VALUES ('25395e3adb96446ea6c425c7b2f42671','dygbxxpxnrdm','党员干部学习培训内容代码','4','教育教学 业务');
- INSERT INTO ods_GGZD VALUES ('f3c6f7b526ba4284962ef415e1074d7b','dygbxxpxnrdm','党员干部学习培训内容代码','5','学校管理');
- INSERT INTO ods_GGZD VALUES ('ca2ba3a6cdca46edb59d0e0df1acc787','dygbxxpxnrdm','党员干部学习培训内容代码','6','文化建设');
- INSERT INTO ods_GGZD VALUES ('2853872c57854e6a9fbbd7a47b7a15be','dygbxxpxnrdm','党员干部学习培训内容代码','7','经济方面');
- INSERT INTO ods_GGZD VALUES ('f8af9d0dfa114d57839ea203fea88128','dygbxxpxnrdm','党员干部学习培训内容代码','8','互联网与 新媒体方面');
- INSERT INTO ods_GGZD VALUES ('f17b54a1ae5a451e9d9930d16a30f59c','dygbxxpxnrdm','党员干部学习培训内容代码','9','心理健康');
- INSERT INTO ods_GGZD VALUES ('ca2fe1320a154b83b54c81f6dfb2affe','dygbxxpxnrdm','党员干部学习培训内容代码','10','师德师风');
- INSERT INTO ods_GGZD VALUES ('f8bff7dd70ff4aa5a29828de6a6ca0bd','dygbxxpxnrdm','党员干部学习培训内容代码','11','其他');
- INSERT INTO ods_GGZD VALUES ('c2273566c01d408c9da4ce5f9b2d3046','djhdxsdm','党建活动形式代码','1','实践活动');
- INSERT INTO ods_GGZD VALUES ('3b2c29d6423448b89461ab7202b28eeb','djhdxsdm','党建活动形式代码','2','会议');
- INSERT INTO ods_GGZD VALUES ('eab044ecbffc4a36b2a8e90b479ef308','djhdxsdm','党建活动形式代码','3','讲座报告');
- INSERT INTO ods_GGZD VALUES ('e54a300ef45d4fb6929beed0e8cd5bc2','djhdxsdm','党建活动形式代码','4','学校定期集中学习');
- INSERT INTO ods_GGZD VALUES ('c46f78ed07934ffcadae1cde3fc4ddfc','djhdxsdm','党建活动形式代码','5','支部定期集中学习');
- INSERT INTO ods_GGZD VALUES ('8f3f4b65cd4049839845c1b90df71b5e','djhdxsdm','党建活动形式代码','6','微信 QQ');
- INSERT INTO ods_GGZD VALUES ('a6d785c9b3f54b77a18ca444581a2c68','djhdxsdm','党建活动形式代码','7','移动端培训平台');
- INSERT INTO ods_GGZD VALUES ('2b474d0ee3014fefa9f4ba89f1b1b84b','djhdxsdm','党建活动形式代码','8','分发图书资料');
- INSERT INTO ods_GGZD VALUES ('1b05d987d91c48089b45c1be46460c10','djhdxsdm','党建活动形式代码','9','个人学习');
- INSERT INTO ods_GGZD VALUES ('d1ff95f30dbe485bb7a26fcc57f29838','djhdxsdm','党建活动形式代码','10','在线教育网站/参观学 习');
- INSERT INTO ods_GGZD VALUES ('6f4436bb414743df9bfb2f6b57545288','djhdxsdm','党建活动形式代码','11','参观学习');
- INSERT INTO ods_GGZD VALUES ('5bc1235b06d0464aaa14d33ae33a1429','ztdrhdnrdm','主题党日活动内容代码','1','尚未开展主题党 日活动');
- INSERT INTO ods_GGZD VALUES ('1a4a2a73bed94439a9d6325f0e323458','ztdrhdnrdm','主题党日活动内容代码','2','党内评议');
- INSERT INTO ods_GGZD VALUES ('dabb2aeee2204bc380f7be9d73e91eaf','ztdrhdnrdm','主题党日活动内容代码','3','温暖关爱');
- INSERT INTO ods_GGZD VALUES ('3c65ed659e9b4d66aa331e93070568c6','ztdrhdnrdm','主题党日活动内容代码','4','学习交流');
- INSERT INTO ods_GGZD VALUES ('7358825e65db47c9ae5bd462c624d5d8','ztdrhdnrdm','主题党日活动内容代码','5','民主议事');
- INSERT INTO ods_GGZD VALUES ('64f4f68392694bb6a86de12d91e78b16','ztdrhdnrdm','主题党日活动内容代码','6','建言献策');
- INSERT INTO ods_GGZD VALUES ('a140325c205943d6af71d03dfa1e58ce','ztdrhdnrdm','主题党日活动内容代码','7','志愿服务');
- INSERT INTO ods_GGZD VALUES ('12f5a1a3321749a192a46824b7a4463c','ztdrhdnrdm','主题党日活动内容代码','8','外出参观');
- INSERT INTO ods_GGZD VALUES ('e5868fa3245246678181ff5fd9c6f3d9','ztdrhdnrdm','主题党日活动内容代码','9','研究业务');
- INSERT INTO ods_GGZD VALUES ('c555813a95954878aae5cf9840d610ab','ztdrhdnrdm','主题党日活动内容代码','10','其他');
- INSERT INTO ods_GGZD VALUES ('84469941b1fc4394a74c998b16aa79fb','wjylxdm','未就业类型代码','1','待就业');
- INSERT INTO ods_GGZD VALUES ('fa418f72cee84efa9915ef436e9d7afd','wjylxdm','未就业类型代码','2','不就业拟升学');
- INSERT INTO ods_GGZD VALUES ('5f53c2f23efc41a3bd9976a443cf2bdb','wjylxdm','未就业类型代码','3','其他暂不就业');
- INSERT INTO ods_GGZD VALUES ('4f738e07658c4c7e891baa90b1d6c9d9','sxjyhydm','实习/就业行业代码','A','农林牧渔业');
- INSERT INTO ods_GGZD VALUES ('7aa0676ab2b94722badf0c62e6eab9b3','sxjyhydm','实习/就业行业代码','B','采矿业');
- INSERT INTO ods_GGZD VALUES ('3205fffe6706434fbc12cd7f611d504c','sxjyhydm','实习/就业行业代码','C','制造业');
- INSERT INTO ods_GGZD VALUES ('cf2fab8778f24c6aa738b443330d744a','sxjyhydm','实习/就业行业代码','D','电力、热力、燃气及水生产和供应业');
- INSERT INTO ods_GGZD VALUES ('7a136e3c3e6846819ca8a3433dda7dd9','sxjyhydm','实习/就业行业代码','E','建筑业');
- INSERT INTO ods_GGZD VALUES ('1bd0b4527d544612a2b65a4199071e09','sxjyhydm','实习/就业行业代码','F','批发和零售业');
- INSERT INTO ods_GGZD VALUES ('55e86b0d88c8442299bc620b6d2ffab3','sxjyhydm','实习/就业行业代码','G','交通运输、仓储和邮政业');
- INSERT INTO ods_GGZD VALUES ('8819d852b0b048a19adc068692626931','sxjyhydm','实习/就业行业代码','H','住宿和餐饮业');
- INSERT INTO ods_GGZD VALUES ('9879d7644223449ea4fa48b7e16475c2','sxjyhydm','实习/就业行业代码','I','信息传输、软件和信息技术服务业');
- INSERT INTO ods_GGZD VALUES ('7b6c70361aad4c058f7e0bcd7162462e','sxjyhydm','实习/就业行业代码','J','金融业');
- INSERT INTO ods_GGZD VALUES ('b7f932c5ad8d4b22835284271d8acca4','sxjyhydm','实习/就业行业代码','K','房地产业');
- INSERT INTO ods_GGZD VALUES ('ddb6e124c72a4b48ab8d6a35f02efea0','sxjyhydm','实习/就业行业代码','L','租赁和商务服务业');
- INSERT INTO ods_GGZD VALUES ('b18c45167fd74ec9b870abd530d39a6f','sxjyhydm','实习/就业行业代码','M','科学研究和技术服务业');
- INSERT INTO ods_GGZD VALUES ('fe284ca688594873b234b266eab3868b','sxjyhydm','实习/就业行业代码','N','水利、环境和公共设施管理业');
- INSERT INTO ods_GGZD VALUES ('f122aec8d60d4336884845f3eecfde01','sxjyhydm','实习/就业行业代码','O','居民服务、修理和其他服务业');
- INSERT INTO ods_GGZD VALUES ('ce121b266c10483d884969bf18837af8','sxjyhydm','实习/就业行业代码','P','教育');
- INSERT INTO ods_GGZD VALUES ('9dff0e11b8c94b2988ecaca5e2a79d6a','sxjyhydm','实习/就业行业代码','Q','卫生和社会工作');
- INSERT INTO ods_GGZD VALUES ('bba6b51becb749e5990c4beb04fc5a04','sxjyhydm','实习/就业行业代码','R','文化、体育和娱乐业');
- INSERT INTO ods_GGZD VALUES ('f2dbb38a5e904b24915df6d32bad3be2','sxjyhydm','实习/就业行业代码','S','公共管理、社会保障和社会组织');
- INSERT INTO ods_GGZD VALUES ('8f4a21598d4448279eea40cba0933ee6','sxjyhydm','实习/就业行业代码','T','国际组织');
- INSERT INTO ods_GGZD VALUES ('6f9278057dab4167b17981fbb816489f','sxjyhydm','实习/就业行业代码','0','其他');
- INSERT INTO ods_GGZD VALUES ('44566bca80934bfcad19895dacd7f7e9','jydwgmdm','就业单位规模代码','1','特大型');
- INSERT INTO ods_GGZD VALUES ('84732039970246e1beed8a6fbae21347','jydwgmdm','就业单位规模代码','2','大型');
- INSERT INTO ods_GGZD VALUES ('3abdec7521ee4cefae53c513e10854d4','jydwgmdm','就业单位规模代码','3','中型');
- INSERT INTO ods_GGZD VALUES ('227b0d73b70d4839abe9fc9bc9e92f14','jydwgmdm','就业单位规模代码','4','小型');
- INSERT INTO ods_GGZD VALUES ('0d7e0c06762d438db69147867b840d57','jydwgmdm','就业单位规模代码','5','微型');
- INSERT INTO ods_GGZD VALUES ('c83ae6d2c0fa44bbab40f97765653c96','jyqddm','就业渠道代码','1','学校推荐');
- INSERT INTO ods_GGZD VALUES ('380b2a5ea50540f0a612ebd5bbc58586','jyqddm','就业渠道代码','2','中介介绍');
- INSERT INTO ods_GGZD VALUES ('98462bfe1fae48ec96b0c0ee11586501','jyqddm','就业渠道代码','0','其他');
- INSERT INTO ods_GGZD VALUES ('cd1f49fc9a414391910dad9ef9f9a407','htqdqkdm','合同签订情况代码','1','未签');
- INSERT INTO ods_GGZD VALUES ('03a65b5cb4d2414f8a654f2fb0ed5cf0','htqdqkdm','合同签订情况代码','2','1 年及以内');
- INSERT INTO ods_GGZD VALUES ('d5805977286e422d87367efd7ae5faf5','htqdqkdm','合同签订情况代码','3','1-2(含)年');
- INSERT INTO ods_GGZD VALUES ('fe4812f01da84639adb452ed821f7d35','htqdqkdm','合同签订情况代码','4','2-3(含)年');
- INSERT INTO ods_GGZD VALUES ('a52a4c45e5e6438cbb10f97dc5aeac37','htqdqkdm','合同签订情况代码','5','3 年以上');
- INSERT INTO ods_GGZD VALUES ('6cfd733a4ce2483a8da9007b11e99f49','shbxqkdm','社会保险情况代码','1','三险');
- INSERT INTO ods_GGZD VALUES ('fb0e7caa91b34759b6e3c33da5292ab4','shbxqkdm','社会保险情况代码','2','五险');
- INSERT INTO ods_GGZD VALUES ('77b2bb5cc6614ec2b54d811d28e8273d','shbxqkdm','社会保险情况代码','3','三险一金');
- INSERT INTO ods_GGZD VALUES ('1f18fb2117ce495dbb70771d90ae636c','shbxqkdm','社会保险情况代码','4','五险一金');
- INSERT INTO ods_GGZD VALUES ('72fe120fe7ce4974ae5e55e40e7ded0c','shbxqkdm','社会保险情况代码','0','没有社保');
- INSERT INTO ods_GGZD VALUES ('39561fa1a2714f36b7c4755ce41c7249','sxqddm','升学渠道代码','1','贯通培养');
- INSERT INTO ods_GGZD VALUES ('68d22c1d15234a038517138f9260c097','sxqddm','升学渠道代码','2','五年一贯制培养');
- INSERT INTO ods_GGZD VALUES ('6d98083030734ee0b2612c12f36ca2bb','sxqddm','升学渠道代码','3','职教高考');
- INSERT INTO ods_GGZD VALUES ('324982dedaff4e1b842032f033b37eb6','sxqddm','升学渠道代码','4','普通高考');
- INSERT INTO ods_GGZD VALUES ('5153c62826d447ff9e9f92b10242b447','sxqddm','升学渠道代码','5','出国升学');
- INSERT INTO ods_GGZD VALUES ('f373b8b2c69e48f2a09da83a7545dddc','sxccdm','升学层次代码','1','专科');
- INSERT INTO ods_GGZD VALUES ('cc7d9793551a4e558933226f4556cdfa','sxccdm','升学层次代码','2','职业本科');
- INSERT INTO ods_GGZD VALUES ('da87f5cf6eae4a82883a047b8e45b415','sxccdm','升学层次代码','3','普通本科');
- INSERT INTO ods_GGZD VALUES ('ace480f5ecbd4435bf69d585a26c8475','sxccdm','升学层次代码','4','硕士');
- INSERT INTO ods_GGZD VALUES ('186fff859b9849579134ee79124f33b0','sxccdm','升学层次代码','5','其他');
-
- INSERT INTO ods_GGZD VALUES ('1863ff859b9849779134ee79124f33b0','hzxyqsztdm','合作协议签署状态','1','签署');
- INSERT INTO ods_GGZD VALUES ('1864ff85fb9849579134ee79124f33b0','hzxyqsztdm','合作协议签署状态','2','续签');
- INSERT INTO ods_GGZD VALUES ('1865ff859b9649579134ee79124f33b0','hzxyqsztdm','合作协议签署状态','3','未签');
-
-
- INSERT INTO ods_GGZD VALUES ('1865ff859b96495798965e79124f33b0','hzztdm','合作状态','1','正常');
- INSERT INTO ods_GGZD VALUES ('1865f1253b9649579134ee79124f33b0','hzztdm','合作状态','0','终止');
-
-
- INSERT INTO ods_GGZD VALUES ('1865f1253b964957958777ff124f33b0','sfbm','是/否','0','否');
- INSERT INTO ods_GGZD VALUES ('1865f1253b964957958777fb124f33b0','sfbm','是/否','1','是');
-
- INSERT INTO ods_GGZD VALUES ('1865f1253b964957958fjdsfkj1f33b0','zybm','正常/异常','0','异常');
- INSERT INTO ods_GGZD VALUES ('1865f1253b964957958fjdsfkj2f33b0','zybm','正常/异常','1','正常');
|