失业保险统计指标指示共22页.docx
《失业保险统计指标指示共22页.docx》由会员分享,可在线阅读,更多相关《失业保险统计指标指示共22页.docx(15页珍藏版)》请在冰豆网上搜索。
![失业保险统计指标指示共22页.docx](https://file1.bdocx.com/fileroot1/2023-1/10/e16e54d8-9f16-446f-a36e-f075337acaad/e16e54d8-9f16-446f-a36e-f075337acaad1.gif)
失业保险统计指标指示共22页
数据集编号:
001
数据集名称:
阿城参保人数
select(selectcount(aac001)fromhrbsysimis_ac.ac01whereaac031='1')+
(selectcount(aac001)fromhrbsysimis_ac.jc10whereajc340='1')
fromdual
数据集编号:
002
数据集名称:
阿城工资额
selectROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),
'1',
DECODE(b.AAB020,
'120',
a.AAB430,
'142',
a.AAB430,
'140',
a.AAB430,
0),
0))/200,
2),--集体企业
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),
'1',
DECODE(SUBSTR(b.AAB020,1,1),
'2',
a.AAB430,
'3',
a.AAB430,
0),
0))/200,
2),--三资
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),
'1',
DECODE(SUBSTR(b.AAB020,1,2),
'17',
a.AAB430,
'3',
a.AAB430,
0),
0))/200,
2),--私营
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),'2',a.AAB430,0))/200,
2)--事业
fromhrbsysimis_ac.ab48a,hrbsysimis_ac.ab01b
wherea.aab001=b.aab001
anda.aae002>=操作所属开始结算期
anda.aae002<=操作所属结束结算期
数据集编号:
003
数据集名称:
阿城国有企业覆盖情况
select(SELECTSUM(DECODE(SUBSTR(AAB019,1,1),
'1',
DECODE(AAB020,
'100',
1,
'110',
1,
'141',
1,
'143',
1,
'151',
1,
0),
0))--国有企业
Fromhrbsysimis_ac.ab01b,
(SELECT*FROMhrbsysimis_ac.AC01WHEREAAC031='1')a
Whereb.aab001=a.aab001)+
(SELECTSUM(DECODE(SUBSTR(a.AAB019,1,1),
'1',
DECODE(a.AAB020,
'100',
1,
'110',
1,
'141',
1,
'143',
1,
'151',
1,
0),
0))--国有企业
Fromhrbsysimis_ac.ab01b,
(SELECT*FROMhrbsysimis_ac.jc14whereaae002=统计当前月)a
Whereb.aab001=a.aab001)
fromdual
数据集编号:
004
数据集名称:
阿城集体企业覆盖情况
select(SELECTSUM(DECODE(SUBSTR(AAB019,1,1),
'1',
DECODE(AAB020,'120',1,'142',1,'140',1,0),
0))--集体企业
Fromhrbsysimis_ac.ab01b,
(SELECT*FROMhrbsysimis_ac.AC01WHEREAAC031='1')a
Whereb.aab001=a.aab001)+(SELECTSUM(DECODE(SUBSTR(a.AAB019,1,1),
'1',
DECODE(a.AAB020,'120',1,'142',1,'140',1,0),
0))--集体企业
Fromhrbsysimis_ac.ab01b,
(SELECT*FROMhrbsysimis_ac.jc14whereaae002=[统计当前月])a
Whereb.aab001=a.aab001)fromdual
数据集编号:
005
数据集名称:
阿城三资企业覆盖情况
select(SELECTSUM(DECODE(SUBSTR(AAB019,1,1),
'1',
DECODE(SUBSTR(AAB020,1,1),'2',1,'3',1,0),
0))--三资企业
Fromhrbsysimis_ac.ab01b,
(SELECT*FROMhrbsysimis_ac.AC01WHEREAAC031='1')a
Whereb.aab001=a.aab001)+
(SELECTSUM(DECODE(SUBSTR(a.AAB019,1,1),
'1',
DECODE(SUBSTR(a.AAB020,1,1),'2',1,'3',1,0),
0))--三资企业
Fromhrbsysimis_ac.ab01b,
(SELECT*FROMhrbsysimis_ac.jc14whereaae002=统计当前月)a
Whereb.aab001=a.aab001)
fromdual
数据集编号:
006
数据集名称:
阿城事业单位覆盖情况
select(SELECTSUM(DECODE(SUBSTR(AAB019,1,1),'2',1,0))--事业
Fromhrbsysimis_ac.ab01b,
(SELECT*FROMhrbsysimis_ac.AC01WHEREAAC031='1')a
Whereb.aab001=a.aab001)+
(SELECTSUM(DECODE(SUBSTR(A.AAB019,1,1),'2',1,0))--事业
Fromhrbsysimis_ac.ab01b,
(SELECT*FROMhrbsysimis_ac.jc14whereaae002=统计当前月)a
Whereb.aab001=a.aab001)
fromdual
数据集编号:
007
数据集名称:
阿城工资总额情况
selectROUND(SUM(AAC040)/10000,2),--总计
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),'1',DECODE(b.AAB020,'100',a.aac040,'110',a.aac040,'141',a.aac040,'143',a.AAC040,'151',a.AAC040,0),0))/10000,2),--国有企业
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),'1',DECODE(b.AAB020,'120',a.AAC040,'142',a.AAC040,'140',a.AAC040,0),0))/10000,2),--集体企业
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),'1',DECODE(SUBSTR(b.AAB020,1,1),'2',a.AAC040,'3',a.AAC040,0),0))/10000,2),--三资
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),'1',DECODE(SUBSTR(b.AAB020,1,2),'17',a.AAC040,'3',a.AAC040,0),0))/10000,2),--私营
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),'2',a.AAC040,0))/10000,2)--事业
fromhrbsysimis_ac.ac04a,hrbsysimis_ac.ab01b
wherea.aab001=b.aab001
anda.aae042isnull
数据集编号:
008
数据集名称:
阿城国有企业领取待遇情况
selectcount(distinctaac001)
fromhrbsysimis_ac.jc10a,hrbsysimis_ac.ab01b
wherea.aab001=b.aab001
andb.aab019='10'
andb.aab020='110'
andto_char(a.ajc100,'yyyymm')=失业保险金统计条件
数据集编号:
009
数据集名称:
阿城实际缴费情况
selectcase
whenROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),
'1',
DECODE(b.AAB020,
'120',
a.AAB430,
'142',
a.AAB430,
'140',
a.AAB430,
0),
0))/10000,
2)isnullthen
0
else
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),
'1',
DECODE(b.AAB020,
'120',
a.AAB430,
'142',
a.AAB430,
'140',
a.AAB430,
0),
0))/10000,
2)
end,--集体企业
case
whenROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),
'1',
DECODE(SUBSTR(b.AAB020,1,1),
'2',
a.AAB430,
'3',
a.AAB430,
0),
0))/10000,
2)isnullthen
0
else
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),
'1',
DECODE(SUBSTR(b.AAB020,1,1),
'2',
a.AAB430,
'3',
a.AAB430,
0),
0))/10000,
2)
end,--三资
case
whenROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),
'1',
DECODE(SUBSTR(b.AAB020,1,2),
'17',
a.AAB430,
'3',
a.AAB430,
0),
0))/10000,
2)isnullthen
0
else
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),
'1',
DECODE(SUBSTR(b.AAB020,1,2),
'17',
a.AAB430,
'3',
a.AAB430,
0),
0))/10000,
2)
end,--私营
case
whenROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),'2',a.AAB430,0))/
10000,
2)isnullthen
0
else
ROUND(SUM(DECODE(SUBSTR(b.AAB019,1,1),'2',a.AAB430,0))/
10000,
2)
end--事业
fromhrbsysimis_ac.ab48a,hrbsysimis_ac.ab01b
wherea.aab001=b.aab001
anda.aae002>=操作所属开始结算期
anda.aae002<=操作所属结束结算期
数据集编号:
010
数据集名称:
阿城女性领取待遇情况
selectcount(a.aac001)
fromhrbsysimis_ac.jc14a,hrbsysimis_ac.ac01b
wherea.aac001=b.aac001
andB.AAC004='2'
anda.aae002=失业保险金统计条件
数据集编号:
011
数据集名称:
阿城企业职工领取待遇情况
selectcount(aac001)
fromhrbsysimis_ac.jc10a,hrbsysimis_ac.ab01b
wherea.aab001=b.aab001
andb.aab019='10'
Anda.ajc340='1'
andto_char(a.ajc100,'yyyymm')=[失业保险金统计条件]
数据集编号:
012
数据集名称:
哈尔滨按月实际缴费情况(包括地税征收和经办机构自收)
SELECT--实缴AAB190
ROUND(SUM(AAB190)/10000,2)
FROMAB13
WHEREBKB025='1'
ANDto_char(AAE036,'yyyy')=to_char(SYSDATE,'yyyy')
GROUPBYto_char(AAE036,'yyyymm')
数据集编号:
013
数据集名称:
哈尔滨待遇核定情况
selectc.aaa103经济类型,count(a.aac001)人数
fromhrbsysimis.jc10a,hrbsysimis.ab01b,hrbsysimis.aa10c
wherea.aab001=b.aab001
andc.aaa102=b.aab020
andto_char(a.aae036,'yyyymm')>=新系统开始日期
andto_char(a.aae036,'yyyymm')<=新系统结束日期
ANDC.AAA100='AAB020'
groupbyc.aaa103
orderbycount(a.aac001)desc
数据集编号:
014
数据集名称:
呼兰区待遇核定情况
selectb.aab001单位编号,
b.aab004单位名称,
a.aac003姓名,
a.aac002身份证号码,
a.aac001个人编号,
a.aac007个人参保时间,
c.ajc097视同缴费月数
fromhrbsysimis.ac01a,hrbsysimis.ab01b,hrbsysimis.jc10c
wherea.aac001=c.aac001
andc.aab001=b.aab001
andc.ajc340='1'
andb.aab301='230111'
andto_char(c.aae036,'yyyymm')>=[新系统开始日期]
andto_char(c.aae036,'yyyymm')<=[新系统结束日期]
数据集编号:
015
数据集名称:
呼兰区待遇核定人数情况
selectcount(a.aac001)||'人'
fromhrbsysimis.ac01a,hrbsysimis.ab01b,hrbsysimis.jc10c
wherea.aac001=c.aac001
andc.aab001=b.aab001
andc.ajc340='1'
andb.aab301='230111'
andto_char(c.aae036,'yyyymm')>=[新系统开始日期]
andto_char(c.aae036,'yyyymm')<=[新系统结束日期]
数据集编号:
016
数据集名称:
哈尔滨稽核科人员发布陈欠计划情况
SELECTround(SUM(aab156)/10000,2)
FROMab08
WHEREaae143IN('02','15','18','19')
ANDaae011IN('武淑杰','张雪华','许玮')
andsubstr(aae002,1,4)=to_char(sysdate,'yyyy')
GROUPBYaae002
数据集编号:
017
数据集名称:
哈尔滨稽核科人员实收陈欠计划情况
SELECTround(SUM(aab210)/10000,2)FROMab08
WHEREaae143IN('02','15','18','19')
ANDaae011IN('武淑杰','张雪华','许玮')
andsubstr(aae002,1,4)=to_char(sysdate,'yyyy')
GROUPBYaae002
数据集编号:
018
数据集名称:
哈尔滨企业陈欠计划发布情况
SELECTround(SUM(a.aab156)/10000,2)陈欠计划数
FROMab08a,ab01b
WHEREa.aab001=b.aab001
ANDb.aab019='10'
ANDa.aab033='2'
ANDa.aae143='19'
ANDa.aab166='1'
ANDsubstr(a.AAE002,1,4)=to_char(SYSDATE,'yyyy')
GROUPBYa.AAE002
数据集编号:
019
数据集名称:
哈尔滨企业陈欠计划经办机构自收发布情况
SELECTround(SUM(a.aab156)/10000,2)陈欠计划数
FROMab08a,ab01b
WHEREa.aab001=b.aab001
ANDb.aab019='10'
ANDa.aab033='3'
ANDa.aae143='19'
ANDa.aab166='1'
ANDsubstr(a.AAE002,1,4)=to_char(SYSDATE,'yyyy')
GROUPBYa.AAE002
数据集编号:
020
数据集名称:
哈尔滨企业陈欠计划实收情况
SELECTround(SUM(a.aab210)/10000,2)陈欠计划数
FROMab08a,ab01b
WHEREa.aab001=b.aab001
ANDb.aab019='10'
ANDa.aab033='2'
ANDa.aae143='19'
ANDa.aab166='1'
ANDsubstr(a.AAE002,1,4)=to_char(SYSDATE,'yyyy')
GROUPBYa.AAE002
数据集编号:
021
数据集名称:
哈尔滨企业陈欠计划经办机构自收实收情况
SELECTround(SUM(a.aab210)/10000,2)陈欠计划数
FROMab08a,ab01b
WHEREa.aab001=b.aab001
ANDb.aab019='10'
ANDa.aab033='3'
ANDa.aae143='19'
ANDa.aab166='1'
ANDsubstr(a.AAE002,1,4)=to_char(SYSDATE,'yyyy')
GROUPBYa.AAE002
数据集编号:
022
数据集名称:
哈尔滨企业地税计划报盘情况
SELECTround(SUM(a.aab156)/10000,2)计划数
FROMab08a,ab01b
WHEREa.aab001=b.aab001
anda.aab033='2'
andb.aab019='10'
ANDa.aab166='1'
ANDsubstr(a.AAE002,1,4)=to_char(SYSDATE,'yyyy')
GROUPBYa.AAE002
数据集编号:
023
数据集名称:
哈尔滨企业经办机构自收计划发布情况
SELECTround(SUM(a.aab156)/10000,2)计划数
FROMab08a,ab01b
WHEREa.aab001=b.aab001
anda.aab033='3'
andb.aab019='10'
ANDa.aab166='1'
ANDsubstr(a.AAE002,1,4)=to_char(SYSDATE,'yyyy')
GROUPBYa.AAE002
数据集编号:
024
数据集名称:
哈尔滨企业计划实收情况(包括地税征收和经办机构自收)
SELECTround(SUM(a.aab210)/10000,2)实收计划数
FROMab08a,ab01b
WHEREa.aab001=b.aab001
anda.aab033='2'
andb.aab019='10'
ANDa.aab166='1'
ANDsubstr(a.AAE002,1,4)=to_char(SYSDATE,'yyyy')
GROUPBYa.AAE002
数据集编号:
025
数据集名称:
哈尔滨企业经办机构自收计划实收情况
SELECTround(SUM(a.aab210)/10000,2)实收计划数
FROMab08a,ab01b
WHEREa.aab001=b.aab001
anda.aab033='3'
andb.aab019='10'
ANDa.aab166='1'
ANDsubstr(a.AAE002,1,4)=to_char(SYSDATE,'yyyy')
GROUPBYa.AAE002
数据集编号:
026
数据集名称:
哈尔滨事业单位陈欠计划发布情况(包括地税征收和经办机构自收)
SELECTround(SUM(a.aab156)/10000,2)陈欠计划数
FROMab08a,ab01b
WHEREa.aab001=b.aab001
ANDb.aab019in(20,21,22,23)
ANDa.aab033='2'
ANDa.aae143='19'
ANDa.aab166