SLN_FEES

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SLN_FEES_HIID BIGINT 8
2 ACTION_CODE CHARACTER(1) 1
3 FEE_CODE CHARACTER VARYING(3) 3
4 FEE_DESCRIPTION CHARACTER VARYING(60) 60
5 BANKING_TYPE CHARACTER VARYING(50) 50
6 FEE_TYPE CHARACTER VARYING(15) 15
7 SYSTEM CHARACTER VARYING(20) 20
8 EXISTING_LOAN_CODE CHARACTER VARYING(6) 6
9 NEW_LOAN_FINANCED_CODE CHARACTER VARYING(3) 3
10 NEW_LOAN_NON_FINANCED_CODE CHARACTER VARYING(3) 3
11 LOANS_WAIVER_FINANCED CHARACTER VARYING(5) 5
12 LOANS_WAIVER_NON_FINANCED CHARACTER VARYING(5) 5
13 DEPOSIT_NO CHARACTER VARYING(3) 3
14 DEPOSIT_CHARGE_CODE CHARACTER VARYING(4) 4
15 DEPOSIT_REFUND_CODE CHARACTER VARYING(4) 4
16 DEPOSIT_REBATE_CODE CHARACTER VARYING(4) 4
17 DEPOSIT_REBATE_REVERSAL_CODE CHARACTER VARYING(4) 4
18 CLMS_CODE CHARACTER VARYING(10) 10
19 SCHEDULED_FEE NUMERIC(13,2) 19
20 DELTA_TYPE CHARACTER VARYING(1) 1
21 EFFECTIVE_STRT_DT TIMESTAMP 8
22 EFFECTIVE_END_DT TIMESTAMP 8
23 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
24 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
25 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
26 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8