-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathaccount_detail.yaml
118 lines (109 loc) · 5.31 KB
/
account_detail.yaml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
#全局设置
config:
lib: modin
yyyymmdd: '20190525'
workdir: /home/zhch/myjb
outdir: ${workdir}/output/${yyyymmdd}
dbconfig: ./database.ini
relationdata: ${workdir}/contract_no_3.csv
mayi_2: J1010100100000000004_2
mayi_3: J1010100100000000004_3
accounting:
path: ${workdir}/accounting/${yyyymmdd}
datafile: accounting
checkfile: check_accounting
loan_detail:
path: ${workdir}/loan/${yyyymmdd}
datafile: loan_detail
checkfile: check_loan_detail
columns_types: {'contract_no': 'object', 'fund_seq_no': 'object', 'prod_code': 'category', 'name': 'object',
'cert_type': 'category', 'cert_no': 'object', 'loan_status': 'category',
'loan_use': 'category', 'use_area': 'category', 'apply_date': 'object',
'encash_date': 'object', 'currency': 'category', 'encash_amt': 'int32',
'start_date': 'category', 'end_date': 'category', 'total_terms': 'category',
'repay_mode': 'category', 'grace_day': 'category', 'rate_type': 'category',
'day_rate': 'category', 'prin_repay_frequency': 'category',
'int_repay_frequency': 'category', 'guarantee_type': 'category',
'credit_no': 'object', 'encash_acct_type': 'category', 'encash_acct_no': 'object',
'repay_acct_type': 'category', 'repay_acct_no': 'object', 'apply_no': 'object'}
groupby: [prod_code]
agg_cols: ['encash_amt']
action: aggregate_detail
repay_plan:
path: ${workdir}/loan/${yyyymmdd}
datafile: repay_plan
checkfile: check_repay_plan
columns_types: {'contract_no': 'category', 'term_no': 'category',
'start_date': 'category', 'end_date': 'category',
'prin_amt': 'int32', 'int_amt': 'int32'}
groupby: [prod_code]
agg_cols: ['prin_amt', 'int_amt']
action: aggregate_detail
loan_calc:
path: ${workdir}/calc/${yyyymmdd}
datafile: loan_calc
checkfile: check_loan_calc
columns_types: {'contract_no': 'object', 'calc_date': 'category',
'accrued_status': 'category', 'prin_bal': 'int32', 'ovd_prin_bal': 'int32',
'ovd_int_bal': 'int32', 'real_rate': 'float64', 'pnlt_rate': 'float64',
'int_amt': 'int32', 'ovd_prin_pnlt_amt': 'int32', 'ovd_int_pnlt_amt': 'int32'}
groupby: [prod_code]
# groupby:
agg_cols: ['int_amt', 'ovd_prin_pnlt_amt', 'ovd_int_pnlt_amt']
action: aggregate_detail
arg_status_change:
path: ${workdir}/change/${yyyymmdd}
datafile: arg_status_change
checkfile: check_arg_status_change
columns_types: {'contract_no': 'object', 'settle_date': 'category',
'seq_no': 'object', 'event_code': 'category', 'before_status': 'category',
'after_status': 'category', 'prin_amt': 'int32', 'int_amt': 'int32',
'ovd_prin_pnlt_amt': 'int32', 'ovd_int_pnlt_amt': 'int32'}
groupby: [prod_code, event_code]
agg_cols: ['prin_amt', 'int_amt', 'ovd_prin_pnlt_amt', 'ovd_int_pnlt_amt']
action: aggregate_detail
# use modin for empty dataframe raise error to_csv()
exempt_loan_detail:
path: ${workdir}/exempt/${yyyymmdd}
datafile: exempt_loan_detail
checkfile: check_exempt_loan_detail
columns_types:
groupby: [prod_code]
agg_cols: ['exempt_int_amt', 'exempt_ovd_int_amt']
action: aggregate_detail
loan_init:
path: ${workdir}/init/${yyyymmdd}
datafile: loan_init
checkfile: check_loan_init
columns_types: {'contract_no': 'object', 'settle_date': 'category',
'status': 'category', 'clear_date': 'category', 'asset_class': 'category',
'accrued_status': 'category', 'next_repay_date': 'category',
'unclear_terms': 'category', 'ovd_terms': 'category',
'prin_ovd_days': 'category', 'int_ovd_days': 'category',
'prin_bal': 'int32', 'ovd_prin_bal': 'int32', 'int_bal': 'int32',
'ovd_int_bal': 'int32', 'ovd_prin_pnlt_bal': 'int32', 'ovd_int_pnlt_bal': 'int32'}
repay_loan_detail:
path: ${workdir}/repay/${yyyymmdd}
datafile: repay_loan_detail
checkfile: check_repay_loan_detail
columns_types: {'contract_no': 'object', 'seq_no': 'object', 'fee_no': 'object',
'withdraw_no': 'object', 'repay_type': 'category', 'repay_date': 'category',
'curr_prin_bal': 'int32', 'curr_ovd_prin_bal': 'int32',
'curr_int_bal': 'int32', 'curr_ovd_int_bal': 'int32',
'curr_ovd_prin_pnlt_bal': 'int32', 'curr_ovd_int_pnlt_bal': 'int32',
'repay_amt': 'int32', 'paid_prin_amt': 'int32', 'paid_ovd_prin_amt': 'int32',
'paid_int_amt': 'int32', 'paid_ovd_int_amt': 'int32',
'paid_ovd_prin_pnlt_amt': 'int32', 'paid_ovd_int_pnlt_amt': 'int32', 'fee_amt': 'int32'}
groupby: [prod_code]
agg_cols: ['paid_prin_amt', 'paid_ovd_prin_amt', 'paid_int_amt',
'paid_ovd_int_amt', 'paid_ovd_prin_pnlt_amt', 'paid_ovd_int_pnlt_amt', 'fee_amt']
action: aggregate_detail
instmnt_init:
path: ${workdir}/init/${yyyymmdd}
datafile: instmnt_init
checkfile: check_instmnt_init
columns_types: {'contract_no': 'category', 'settle_date': 'category', 'term_no': 'category',
'start_date': 'category', 'end_date': 'category', 'status': 'category', 'clear_date': 'category',
'prin_ovd_date': 'category', 'int_ovd_date': 'category', 'prin_ovd_days': 'category',
'int_ovd_days': 'category',
'prin_bal': 'int32', 'int_bal': 'int32', 'ovd_prin_pnlt_bal': 'int32', 'ovd_int_pnlt_bal': 'int32'}