当前位置:网站首页>金融零售图谱-交易流水预警图谱
金融零售图谱-交易流水预警图谱
2022-04-21 09:54:00 【**码上人生**】
交易流水预警图谱方案介绍
1 业务场景
针对每日新增手机银行及网银交易流水中交易设备与员工设备关联的流水进行甄别,并对符合特定规则的交易流水进行预警提示。
2 业务规则
2.1 图数据库
需建立员工近一年交易使用超过3次的设备信息库,具体要求如下:
- 统计近一年发生过网银交易和手机银行交易的员工账户。
- 根据每笔网银交易和手机银行交易时间匹配该员工对应的设备信息,如mac地址,dfp,imei信息。
- 当mac地址,dfp,imei,分别出现超过3次,则记录该员工及该设备信息分别入库。
- 流程见下图,每日日终更新该数据库。
- 次数及时间可以根据需求调整,ETL加工调整实现T+1更新

2.2 接口判断逻辑
每日筛选新增符合以下所有条件的交易流水:
- 交易金额>=500
- 交易转出账户非员工(及员工配偶)账户
- 交易方式是通过手机银行或者网银
- 设备信息mac地址,dfp,imei中任一一个命中员工近一年交易使用超过3次的设备信息库<
版权声明
本文为[**码上人生**]所创,转载请带上原文链接,感谢
https://blog.csdn.net/qq_16365849/article/details/124302725
边栏推荐
- Question brushing record (leetcode)
- You are using pip version 20.2.3; however, version 22.0.4 is available. You should consider
- CANoe:Vector Tool Platform是什么
- 【概率论与数理统计】1.4 条件概率
- When uniapp encounters rolling penetration, a clever solution~
- Using pycharm to load the QRC resource file in pyside2
- My life of Honker Security Commando
- [Netty ]自己实现一个redis客户端难吗?
- [daily question 1] stone jumping -- dynamic programming
- Redis deployment and use
猜你喜欢
随机推荐
【总结】1296- 总结 12 个常见移动端 H5 与 Hybrid 开发问题
CommDGI: Community detection oriented deep graph infomax 2020 CIKM
[excel function] count function | countif function | countifs function
广州期货交易所的产品有哪些呢?
利用已有的标签文件生成训练集和验证集(YOLO)
比 Navicat 还要好用、功能更强大的工具!
Add pjax to the website without refresh and uninterrupted page change music
ROS与MATLAB网络连接
Advanced C language - dynamic memory management
Interview question of a small factory: what is false awakening?
Fudan University - University of Washington EMBA Alumni: Turning "her power" into "our power"
【愚公系列】2022年04月 微信小程序-地图的使用之线聚合
One trick is to solve the servlet of servlet [dispatcher servlet] Init() threw an exception
-bash: /home/lylg/bin/kf.sh: /bin/bash^M: bad interpreter: No such file or directory
Aruco and opencv
Japanese brother's open source "self abuse artifact" exploded overnight: use the handle to control his face, take the code and bear the consequences
[hand in hand to prepare you for the electric game] use the timer interrupt to change the PWM duty cycle
Is synchronized really heavy?
2022 refrigeration and air conditioning equipment operation test question simulation test question bank and answers
【无标题】定时的



![SQL题集[(2)]](/img/cb/2b8dda83cbd610065632109f26ff21.png)





