
insert into ANALYSE_STATISTICS_MAIN (ID, STATISTICSNAME, SDESC, TABLEID, TIMESTYPE, PLANARTABLE, PLANARFIELD, CPLANARFIELD, WHEREVALUE, EXCELTEMPLATE, PLANARFIELDNAME, WISMATCH, CJOIN, ISUNIT, SINPUTTYPE, SINPUTPAGE, ISAGV, ISSUM, ISSHOWTYPE, SHOWLINK, TIMETEMPLATE, CODETABLE, TBUTTON, ISNUMBER, ADDFIELD, DCODE)
values ('00000001', '按学历和年龄情况统计表', '按学历和年龄情况统计表', 'YS_HQ_PERSON', '1', 'YS_CODE_XL', 'CODE', 'XL', null, null, 'NAME', '0', '1', '0', '1', null, '0', '1', '1', null, '00000001.htm', null, null, ' ', null, null);

insert into ANALYSE_STATISTICS_MAIN (ID, STATISTICSNAME, SDESC, TABLEID, TIMESTYPE, PLANARTABLE, PLANARFIELD, CPLANARFIELD, WHEREVALUE, EXCELTEMPLATE, PLANARFIELDNAME, WISMATCH, CJOIN, ISUNIT, SINPUTTYPE, SINPUTPAGE, ISAGV, ISSUM, ISSHOWTYPE, SHOWLINK, TIMETEMPLATE, CODETABLE, TBUTTON, ISNUMBER, ADDFIELD, DCODE)
values ('00000002', '按部门及年龄情况统计表', '按部门及年龄情况统计表', 'YS_HQ_PERSON', '1', 'BPIP_UNIT', 'UNITID', 'DEPT', null, null, 'UNITNAME', '0', '1', '0', '1', null, '0', '1', '1', null, '00000002.htm', null, null, '1', null, null);





insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000001', '00000001', 'C01', '人数', 'COUNT(ID)', 1, '0', 'FIELD2', null, null, 0, '01', 'YS_HQ_PERSON', 'XL', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000002', '00000001', 'C02', '22岁以下', 'COUNT(YS_HQ_PERSON.ID)', 1, '0', 'FIELD3', '[YS_HQ_PERSON.NL]<22', null, 0, '02', 'YS_HQ_PERSON', 'XL', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000003', '00000001', 'C03', '22-25', 'count(ID)', 1, '0', 'FIELD4', '[YS_HQ_PERSON.NL]>=22 AND [YS_HQ_PERSON.NL]<=25', null, 0, '03', 'YS_HQ_PERSON', 'XL', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000004', '00000001', 'C04', '26-30', 'count(ID)', 1, '0', 'FIELD5', '[YS_HQ_PERSON.NL]>=26 AND [YS_HQ_PERSON.NL]<=30', null, 0, '04', 'YS_HQ_PERSON', 'XL', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000005', '00000001', 'C05', '31-40', 'count(ID)', 1, '0', 'FIELD6', '[YS_HQ_PERSON.NL]>=31 AND [YS_HQ_PERSON.NL]<=40', null, 0, '05', 'YS_HQ_PERSON', 'XL', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000006', '00000001', 'C06', '41-50', 'count(ID)', 1, '0', 'FIELD7', '[YS_HQ_PERSON.NL]>=41 AND [YS_HQ_PERSON.NL]<=50', null, 0, '06', 'YS_HQ_PERSON', 'XL', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000007', '00000001', 'C07', '50以上', 'count(ID)', 1, '0', 'FIELD8', '[YS_HQ_PERSON.NL]>=50', null, 0, '07', 'YS_HQ_PERSON', 'XL', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000008', '00000002', 'C01', '人数', 'COUNT(ID)', 1, '0', 'FIELD2', null, null, 0, '01', 'YS_HQ_PERSON', 'DEPT', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000009', '00000002', 'C02', '22岁以下', 'COUNT(YS_HQ_PERSON.ID)', 1, '0', 'FIELD3', '[YS_HQ_PERSON.NL]<22', null, 0, '02', 'YS_HQ_PERSON', 'DEPT', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000010', '00000002', 'C03', '22-25', 'count(ID)', 1, '0', 'FIELD4', '[YS_HQ_PERSON.NL]>=22 AND [YS_HQ_PERSON.NL]<=25', null, 0, '03', 'YS_HQ_PERSON', 'DEPT', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000011', '00000002', 'C04', '26-30', 'count(ID)', 1, '0', 'FIELD5', '[YS_HQ_PERSON.NL]>=26 AND [YS_HQ_PERSON.NL]<=30', null, 0, '04', 'YS_HQ_PERSON', 'DEPT', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000012', '00000002', 'C05', '31-40', 'count(ID)', 1, '0', 'FIELD6', '[YS_HQ_PERSON.NL]>=31 AND [YS_HQ_PERSON.NL]<=40', null, 0, '05', 'YS_HQ_PERSON', 'DEPT', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000013', '00000002', 'C06', '41-50', 'count(ID)', 1, '0', 'FIELD7', '[YS_HQ_PERSON.NL]>=41 AND [YS_HQ_PERSON.NL]<=50', null, 0, '06', 'YS_HQ_PERSON', 'DEPT', '1', null);

insert into ANALYSE_STATISTICS_CFIELD (ID, FID, SFIELDNAME, SFIELDSHOWNAME, EXPRESSIONS, DISTINCTION, ISSHOW, SAVEFIELD, EXPRESSIONSWHERE, ADDSIGN, RADIXPOINT, SHOWCODE, TABLEID, CPLANARFIELD, CJOIN, CPLANARESPECIAL)
values ('000000000014', '00000002', 'C07', '50以上', 'count(ID)', 1, '0', 'FIELD8', '[YS_HQ_PERSON.NL]>=50', null, 0, '07', 'YS_HQ_PERSON', 'DEPT', '1', null);










