费用分摊
2025-02-17 15:33:00 0 举报费用分摊
作者其他创作
大纲/内容
更新载体金额
费用分摊
carrierAmount = c.curPremium * c.exchangeRate;carrierAmountInitial = c.curPremiumInitial * c.exchangeRate;
开始
传统打标
删除
清除
ExpenseAmortizationItemWriter
AGGREGATION_EXPENSE_OFFSET
载体汇总
获取费用
新增
间接理赔费用
AmortizationBackJobListener
摊销规则
ExpenseApplicationServiceImpl
DELETE FROM i17_orig_expense_offset WHERE valuation_date = #{valuationDate};
冲销生成：offsetList
费用与规则匹配
载体汇总金额
载体最终金额计算： 载体占比（单个载体险种金额/全部载体险种金额）* 待摊费用（根据险种匹配）+ 载体占比（单个载体险种金额/全部载体险种金额）* 待摊费用（根据0000匹配）
N
打标维度
迭代摊销载体：c
-- 正常分摊金额汇总UPDATE i17_mid_mat_amortization_carrier SET amortization_maintenance_cost = SUM(${offsetList.amount_initial})WHERE amortization_status_initial = 1;
通过match_type与subject_code匹配
打标费用类型
ExpenseAmortizationJobListener
打标规则
费用摊回已触发
ExpenseTaggedJobListener
UPDATE i17_expense_amortization_statSETamount = amount / #{duration} WHERE valuation_date = #{valuationDate}
打标
费用摊回
I17OrigExpenseOffset
汇总维度
更新金额
是否为空？
write
measurment_expense_type
费用类型
Mat|Acq|Ulae
amortization_spec
分摊口径
PRODUCT|CLAIM
amortization_value
分摊取值
险种|*
amortization_carrier
分摊载体
Ep|WpCurr|
segment4
科目
载体金额
mapping
获取费用数据打标规则
afterJob
API
插入
subList
DELETE FROM i17_expense_amortization_statWHERE valuation_date = #{valuationDate}
invokeAmortizationJob
EXPENSE_TAGGED
I17ExpenseAmortizationResult
传统打标根据打标规则打标，不赘述
层级验证：精算
载体最终金额计算： 载体占比（(1+单个载体险种金额)/2/全部载体险种金额）* 待摊费用（根据险种匹配）+ 载体占比（(1+单个载体险种金额)/2/全部载体险种金额）* 待摊费用（根据0000匹配）
beforeJob
summaryList
算法为处理器 & subjectCode != '651105'
Y
amortizationBack
i17_set_expense_measurement_mapping
费用数据
carrierAmount = c.curEarnedPremium * c.exchangeRate;carrierAmountInitial = c.curEarnedPremiumInitial * c.exchangeRate;
结束
AcqAmortizationHandler
待摊费用聚合
re_allo_indi=N
生成维持费用冲销数据
后缀
中文
值解析
详细解释
*_indi
算法
1: 表达式2: 处理器
*_handler
处理器
Java类名
通过Java类打标
*_expression
表达式
打标值
直接取值
*_field_code
回写字段名
经费表字段
将在此字段打标
费用已标记
/v1/dataIntegration/expenseTagged入参：projectId=评估ID
SettledClaimExpenseItemWritter
// 根据查询结果将原记录拆分为多条measurment_expense_type = p_expense_type; // 费用类型amount = proportion * 原amount;// 金额amount_orig = 原amount;// 原金额split_flag = 'C';// 拆分标识amount_mid = 0;// 中间变量金额// 插入经费表，覆盖原记录
-- 正常分摊金额汇总UPDATE i17_mid_acq_amortization_carrier SET amortization_acquisition_cost = SUM(${offsetList.amount_initial})WHERE amortization_status_initial = 1;
carrierAmount = c.settledAmount * c.exchangeRate;carrierAmountInitial = c.settledAmountInitial * c.exchangeRate;
摊销载体
invokeTaggedJob
SELECT * FROM i17_mid_acqcost_amortization_carrier WHERE valuation_date = '${valuationDate}' AND is_deleted = 'N' AND business_type = 1-- 摊销金额为正参与分摊AND cur_premium_initial 0;
SELECT * FROM i17_mid_ulae_amortization_carrier WHERE valuation_date = '${valuationDate}' AND is_deleted = 'N' AND business_type = 1;
UlaeAmortizationHandler
ExpenseOrigOffsetItemWriter
代码位置
SELECT operation_type FROM i17_valuation_operation WHERE id = #{project};
MatAmortizationHandler
生成获取费用冲销数据
statList
AGGREGATION_EXPENSE_OFFSET_INVOKED
业务无关冲销记录
载体类型
segment7
条款
险种
department
部门
business_type
业务类型
UPDATE i17_expense_amortization_statSET amount = amount / #{duration} WHERE valuation_date = #{valuationDate}
ExpenseSplitItemWriter
DELETE FROM i17_mid_expense_aggregateWHERE valuation_date = #{valuationDate};
待摊费用汇总
DataIntegrationController
DELETE FROM i17_expense_amortization_result WHERE valuation_date = #{valuationDate};
expenseTagged
SELECT * FROM i17_mid_mat_amortization_carrier WHERE valuation_date = '${valuationDate}' AND is_deleted = 'N' AND business_type = 1-- 摊销金额为正参与分摊AND cur_earned_premium_initial 0;
费用已摊回
DELETE FROM i17_expense_amortization_subjectWHERE valuation_date = #{valuationDate}
product
生成间接理赔费用冲销数据
前缀
expense_type_*
amortization_spec_*
amortization_value_*
amortization_carrier_*
ExpenseTaggedItemWriter
维持费用
0 条评论
下一页
