5.4.6.gkjydata.sql 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101
  1. delete from GK_BASIC_JSJY_JYR_RY_ZS;
  2. --人员证书
  3. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  4. values ('B9E493D9949241B78575D0FFE83DE1A9', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '危货申报上岗资格证书', '(苏港)危岗证字第131713号', null, '10-10月-16 02.41.36.000000 下午', '90016', null, '5000000439', '320281198904040268', 'Y', 'N', null);
  5. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  6. values ('D330D6A920F94B3691E35E136854EE59', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '企业负责人', '141320207B0379', null, '26-11月-15 12.00.00.000000 上午', '90016', null, '5000000134', '32021919671225351X', 'Y', 'N', null);
  7. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  8. values ('8D14B1EE498C4EB4B41594534F5A386E', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全管理员证书', '第150320208B0038号', null, '19-3月 -16 12.00.00.000000 上午', '90016', null, '5000000741', '320219198309212768', 'Y', 'N', null);
  9. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  10. values ('DDB034BA6E6D4CF9BC156565A944798A', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全资格证书', '081320216E0045', null, '30-4月 -16 12.00.00.000000 上午', '90016', null, '5000000002', '32041119791106314X', 'Y', 'N', null);
  11. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  12. values ('D41DDC74E5234BA2B6AE2FC28810F55A', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全资格证书', '081320215E0045', null, '30-4月 -16 12.00.00.000000 上午', '90016', null, '5000000003', '320222196411103698', 'Y', 'N', null);
  13. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  14. values ('185822CA6F4744EF80F4F865A4031D12', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全资格证书', '130320207E0001', null, '30-4月 -16 12.00.00.000000 上午', '90016', null, '5000000004', '320222198002033691', 'Y', 'N', null);
  15. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  16. values ('D15D4BF34FA34504868215BBB5C3AA23', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '危货码头负责人', '(苏港)危岗证字第132390号', null, '29-5月 -18 03.18.56.000000 下午', '90016', null, '5000000120', '320219196004134771', 'Y', 'N', null);
  17. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  18. values ('3707D78E36334DB5ADA356B0ECDDC3D2', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全管理员', '第141320208B0061号', null, '19-3月 -16 12.00.00.000000 上午', '90016', null, '5000000122', '320219198302042516', 'Y', 'N', null);
  19. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  20. values ('024D5EE4CB3242F0B173DFB9966DA176', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全管理员', '第141320208B0059号', null, '19-3月 -16 12.00.00.000000 上午', '90016', null, '5000000123', '320219197607044550', 'Y', 'N', null);
  21. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  22. values ('E1FEA13A4C90444BA078A41BC107A61F', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全管理员', '第141320208B0016号', null, '19-3月 -16 12.00.00.000000 上午', '90016', null, '5000000124', '320219196004134771', 'Y', 'N', null);
  23. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  24. values ('A2F1D0F0233941BA968BAA8D5DF50E94', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全资格证书', '130320208E0004', null, '30-4月 -16 12.00.00.000000 上午', '90016', null, '5000000001', '34212519820704537X', 'Y', 'N', null);
  25. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  26. values ('668E0D8D096440EA95A1BDC7D8BBE1E5', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '上岗资格证书', '(苏港)危岗证字第130423号', null, null, '90016', null, '5000000763', '320222196404202276', 'Y', 'N', null);
  27. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  28. values ('F39A7CBAD98040D09A7758450381A85B', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '压力容器证', '320219196606070000', null, '28-5月 -19 02.02.35.000000 下午', '90016', null, '5000000110', '320219196606070000', 'Y', 'N', null);
  29. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  30. values ('1931CFAF9F2B4903B5FFDF3AC23B47F1', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '上岗资格证书', '(苏港)危岗证字第132369号', null, null, '90016', null, '5000000761', '32022219680629226X', 'Y', 'N', null);
  31. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  32. values ('8DB6B8F58F3F47E88038103A39D42842', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '危险货物运输岸上现场管理人员', '(XC)危岗证字第20126号', null, null, '90016', null, '5000000762', '320222196404202276', 'Y', 'N', null);
  33. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  34. values ('FCFF83EFE5E54E278CE060BC1EF1D17F', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '主要负责人', '150320207B0041', null, '19-3月 -16 12.00.00.000000 上午', '90016', null, '5000000764', '320219198112223295', 'Y', 'N', null);
  35. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  36. values ('249C5C6597E74498AF275F9A14A8AA63', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '管理员', '150320208B0029', null, '19-3月 -16 12.00.00.000000 上午', '90016', null, '5000000765', '320682199008216272', 'Y', 'N', null);
  37. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  38. values ('6676BA17B51948B88956DBC32598A0D3', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '上岗资格证书', '(苏港)危岗证字第132416号', null, '29-5月 -17 01.59.08.000000 下午', '90016', null, '5000000187', '320219197909240776', 'Y', 'N', null);
  39. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  40. values ('352A7AB1F1724C0AA36E7F25300F88FF', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '上岗资格证书', '(苏港)危岗证字第132417号', null, '29-5月 -17 01.53.13.000000 下午', '90016', null, '5000000188', '320281199402040772', 'Y', 'N', null);
  41. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  42. values ('E9A1B9C2D0CD465091CCD557A98B3E55', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '上岗资格证书', '(苏港)危岗证字第132415号', null, '29-5月 -17 01.55.53.000000 下午', '90016', null, '5000000189', '32021919700620079X', 'Y', 'N', null);
  43. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  44. values ('41686D2BAB8D4AB680132E5A19EB40AD', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '上岗资格证书', '(苏港)危岗证字第132414号', null, '29-5月 -17 01.57.42.000000 下午', '90016', null, '5000000190', '320981198712295731', 'Y', 'N', null);
  45. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  46. values ('79EE68FC0D81447ABE0B2092AF34B4A9', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '特种设备作业人员', '320219198612203530', null, '24-9月 -17 02.01.07.000000 下午', '90016', null, '5000000191', '320219198612203530', 'Y', 'N', null);
  47. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  48. values ('68BD5B60475843A087B7760EBBA29378', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全资格证书', '081320207E0112', null, '31-3月 -16 12.00.00.000000 上午', '90016', null, '5000000026', '320204197711190350', 'Y', 'N', null);
  49. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  50. values ('D1A84CDCD3B74317837FFBA56BCF33C5', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全资格证书', '081320215E0080', null, '31-3月 -16 12.00.00.000000 上午', '90016', null, '5000000032', '320204197711190350', 'Y', 'N', null);
  51. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  52. values ('41D01FE6E48743E38B841E1FC402E747', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全管理员', '141320208B0057', null, '19-3月 -16 12.00.00.000000 上午', '90016', null, '5000000147', '320219198102170791', 'Y', 'N', null);
  53. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  54. values ('57FBD2B2C56E44A6B164DD5F88576A79', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '危险货物岸上管理人员', '(苏港)危岗证字第130693号', null, null, '90016', null, '5000000148', '320219198102170791', 'Y', 'N', null);
  55. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  56. values ('42A8273E483C42FC839EC52C57D06145', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '港口危险货物岸上管理人员', '(苏港)危岗证字第132405号', null, null, '90016', null, '5000000139', '32021919671225351X', 'Y', 'N', null);
  57. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  58. values ('7AEB7EDF7B6F4F84ABE2A75860E71A5D', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全管理员', '141320208B0058', null, '19-3月 -16 12.00.00.000000 上午', '90016', null, '5000000142', '320219195709123293', 'Y', 'N', null);
  59. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  60. values ('F71A9A50DF2A4E6F8EBE77EA4224B3DD', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '危险货物岸上管理人员', 'XC危岗证字第18352号', null, null, '90016', null, '5000000143', '320219195709123293', 'Y', 'N', null);
  61. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  62. values ('CD74F189FC0C460CAA7AE0272FD2AB29', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '安全管理员', '141320208B0094', null, '02-4月 -16 12.00.00.000000 上午', '90016', null, '5000000144', '321283197908162421', 'Y', 'N', null);
  63. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  64. values ('36690615D8074893A5E41A73E74B4A67', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '港口设施保安员', 'F2014113156', null, '27-11月-17 04.52.30.000000 下午', '90016', null, '5000000145', '321283197908162421', 'Y', 'N', null);
  65. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  66. values ('78CB25C0BBEF4002AC4B81FD6F8877FB', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '危险货物岸上管理员', 'XC危岗证字第20079号', null, null, '90016', null, '5000000146', '321283197908162421', 'Y', 'N', null);
  67. insert into GK_BASIC_JSJY_JYR_RY_ZS (ID, CREATE_USER, CREATE_DATE_TIME, UPDATE_USER, UPDATE_DATE_TIME, RECORD_STATUS, ZSMC, ZSBH, FZBM, YXQ, SZD, RYID, AQID, SFZH, SFTB, TBZT, ZSZL)
  68. values ('79ADC29B925D455AB16E23007C55EE1F', 'aq', '27-11月-15 04.18.37.235000 下午', 'aq', '27-11月-15 04.18.37.235000 下午', 1, '港口设施保安主管', 'F08124347', null, '22-3月 -15 04.10.33.000000 下午', '90016', null, '5000000089', '32021919671225351X', 'Y', 'N', null);