征信修复
2025-12-30 14:17:48 0 举报
AI智能生成
征信修复
作者其他创作
大纲/内容
统计符合条件的用户筛选条件
融担
从上报表统计, 全额垫付时间在2020-01-01(含)至2025-12-31(含)之间, 且催收开户金额大于500元, 小于等于10000元的没有追偿结清的订单
全量报送数据
select
a.guarantee_id as guarantee_id, --- 标的
min(b.loan_uid) as uid, --- uid
max(a.repay_balance * b.proportion/100) as repay_balance, --- 催收余额(分)
min(date(a.report_date)) as rpt_date, --- 首次报送日期(全额代偿时间)
sum(a.rpt_date_code='20') as has_close --- 该笔标的是否结清
from collection_msg a
inner join collection b
on a.guarantee_id=b.guarantee_id
group by 1
order by 3 desc
a.guarantee_id as guarantee_id, --- 标的
min(b.loan_uid) as uid, --- uid
max(a.repay_balance * b.proportion/100) as repay_balance, --- 催收余额(分)
min(date(a.report_date)) as rpt_date, --- 首次报送日期(全额代偿时间)
sum(a.rpt_date_code='20') as has_close --- 该笔标的是否结清
from collection_msg a
inner join collection b
on a.guarantee_id=b.guarantee_id
group by 1
order by 3 desc
按需求筛选条件
1. rpt_date>=2020-01-01 and rpt_date<2026-01-01
2. repay_balance <= 10000*100
3. has_close=0
小贷
子主题
剔除存在多笔标的,但是其中一笔不符合的用户。
融担
从上报表统计, 全额垫付时间在2020-01-01(含)至2025-12-31(含)之间, 且催收开户金额大于500元的催收数据中, 去除含有结清的uid数据,去除开户金额大于10000元的uid数据
全量报送数据
select
a.guarantee_id as guarantee_id, --- 标的
min(b.loan_uid) as uid, --- uid
max(a.repay_balance * b.proportion/100) as repay_balance, --- 催收余额(分)
min(date(a.report_date)) as rpt_date, --- 首次报送日期(全额代偿时间)
sum(a.rpt_date_code='20') as has_close --- 该笔标的是否结清
from collection_msg a
inner join collection b
on a.guarantee_id=b.guarantee_id
group by 1
order by 3 desc
a.guarantee_id as guarantee_id, --- 标的
min(b.loan_uid) as uid, --- uid
max(a.repay_balance * b.proportion/100) as repay_balance, --- 催收余额(分)
min(date(a.report_date)) as rpt_date, --- 首次报送日期(全额代偿时间)
sum(a.rpt_date_code='20') as has_close --- 该笔标的是否结清
from collection_msg a
inner join collection b
on a.guarantee_id=b.guarantee_id
group by 1
order by 3 desc
按需求筛选条件
1. rpt_date>=2020-01-01 and rpt_date<2026-01-01
2. 剔除has_close=1的uid数据或者repay_balance > 10000*100的uid数据
小贷
筛选由于宽限期导致暂时未在征信报告上显示逾期的客户
融担
从融担业务实时表统计, 全额垫付时间在2020-01-01(含)至2025-12-31(含)之间, 且催收开户金额大于500元, 小于等于10000元的没有追偿结清的订单, 展示的时候
小贷
0 条评论
下一页