有的, sql如下:
select
prd_code as 信保产品代码
,prd_name as 信保产品
,risk_code as 保险产品代码
,risk_name as 保险产品
,assets_no as 资产方代码
,assets_name as 资产方
,item_code as 项目代码
,item_name as 项目
,rule_group_code as 规则组代码
,rule_group_name as 规则组
,datasource_code as 数据源名称
,datasource_name as 数据源
,rule_code as 规则代码
,rule_name as 规则
,reject_reason as 拒绝原因
,quantity_datasource_call_d as 当日数据源调用量
,quantity_datasource_call_m as 当月数据源调用量
,quantity_datasource_call_y as 当年数据源调用量
,quantity_call_suc_d as 当日数据源调用成功量
,quantity_call_suc_m as 当月数据源调用成功量
,quantity_call_suc_y as 当年数据源调用成功量
,quantity_trig_d as 当日规则触发量
,quantity_trig_m as 当月规则触发量
,quantity_trig_y as 当年规则触发量
,num_null_value_d as 当日空值数
,num_null_value_m as 当月空值数
,num_null_value_y as 当年空值数
,quantity_rule_d as 当日规则触发总量
,quantity_rule_m as 当月规则触发总量
,quantity_rule_y as 当年规则触发总量
,quantity_module_call_d as 当日模型调用量
,quantity_module_call_m as 当月模型调用量
,quantity_module_call_y as 当年模型调用量
,quantity_module_success_d as 当日模型调用成功量
,quantity_module_success_m as 当月模型调用成功量
,quantity_module_success_y as 当年模型调用成功量
,quantity_refuse_sig_d as '当日拒绝理由触发量-单理由'
,quantity_refuse_sig_m as '当月拒绝理由触发量-单理由'
,quantity_refuse_sig_y as '当年拒绝理由触发量-单理由'
,quantity_refuse_mul_d as '当日拒绝理由触发量-多理由'
,quantity_refuse_mul_m as '当月拒绝理由触发量-多理由'
,quantity_refuse_mul_y as '当年拒绝理由触发量-多理由'
,num_order_risk_d as 当日风控进件量
,num_order_risk_m as 当月风控进件量
,num_order_risk_y as 当年风控进件量
,report_date as 查询日期
from ccic_xbmis.dm_risk_model
--增加权限
join ccic_xbmis.dim_user_auth dua
on dua.user_id = ?{_USER_} and dua.if_admin = 1
or dua.user_id = ?{_USER_} and dua.table_name = 'DM_RISK_MODEL' and dua.if_query_table = 1 and dua.if_3117 = 1 |