s.sql

行业应急系统 包括: 应急系统（待遇核发） 发放系统 开发环境:Delphi5 (sp1)+ Oracle 8.05 MultiExport是一个可以将数据按指定字段倒出

INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(1,1,'RYID',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(3,1,'单位名称',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(4,1,'姓名',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(5,1,'社会保障号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(6,1,'性别',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''XB'' ORDER BY DM','String    ','','','',
'')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(7,1,'出生时间',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(8,1,'参加工作时间',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(9,1,'参保时间',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(10,1,'用工形式',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''YGXS'' ORDER BY DM','String    ','',
'','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(11,1,'人员状态',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''RYZT'' ORDER BY DM','String    ','',
'','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(12,1,'业务终结标志',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''TRYJBXX_YWZT'' ORDER BY DM',
'String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(2,1,'HY',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(401,4,'提供生存证明日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(700,7,'CGDJSB_RYID',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(402,4,'视同缴费年限',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(403,4,'开始缴费时间',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(404,4,'93年标准工资',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(701,7,'申报日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(405,4,'93年前个人缴费总额',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(406,4,'缴费年限',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(407,4,'职务级别',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''ZW'' ORDER BY DM','String    ','',
'','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(408,4,'职称',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''ZC'' ORDER BY DM','String    ','','',
'','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(409,4,'离退类别',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''LTLB'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(410,4,'离退休时间',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(411,4,'离退休原因',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''LTXYY'' ORDER BY DM',
'String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(412,4,'离退休前基本工资',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(413,4,'特别津贴',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(414,4,'教护龄津贴',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(415,4,'提前退休月数',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(416,4,'高空和重体力工种月数',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(702,7,'结算月份',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(703,7,'备注',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(704,7,'审核意见',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(705,7,'经办人',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(706,7,'经办日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(707,7,'审核人',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(708,7,'审核日期',1,'','Date      ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(200,2,'社保机构代码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(710,7,'姓名',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(711,7,'社会保障号',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(712,7,'RYJBXX_RYID',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(713,7,'单位代码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(714,7,'单位名称',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(715,7,'RYJBXX_DWID',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(400,4,'人员ID',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(417,4,'井下和高低温工种月数',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(418,4,'有毒有害工种月数',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(419,4,'特殊贡献奖励',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''TSGX'' ORDER BY DM',
'String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(420,4,'计划生育',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''JHSY'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(421,4,'离休油贴',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''LXYT'' ORDER BY DM','String    ',
'','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(422,4,'临时生活补贴',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''LSBT'' ORDER BY DM',
'String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(423,4,'89年级差',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(424,4,'特殊岗位加发比例',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(425,4,'归侨增加比例',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(426,4,'是否参加85工改',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''GG_85'' ORDER BY DM',
'String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(427,4,'是否参加93工改',1,'SELECT dmmc as Value FROM tDMB WHERE zdbz=''GG_93'' ORDER BY DM',
'String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(428,4,'97年底前特殊工种月数',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(429,4,'护理费',1,'','Number    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(300,3,'DWID',0,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(301,3,'单位代码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(302,3,'单位名称',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(303,3,'组织结构代码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(304,3,'税务登记代码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(305,3,'工商登记代码',1,'','String    ','','','','')
/
INSERT INTO tSYSField
(ID,TABLEID,FIELDNAME,VISIBLE,CONDITION,TYPE,COMMENTS,TABLENAME,JOINCOND,ALIASTABLE)
VALUES 
(306,3,'保险登记代码',1,'','String    ','','','','')