OBP24_FLX_SH_PRIN_SCHED_PERIOD_CFG

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SCHEDULE_ID CHARACTER VARYING(16) 16
2 SCHEDULE_CODE CHARACTER VARYING(40) 40
3 SCHEDULE_TYPE_NAME CHARACTER VARYING(120) 120
4 STAGE_NUM BIGINT 8
5 STAGE_NAME CHARACTER VARYING(120) 120
6 STAGE_START_DATE TIMESTAMP 8
7 STAGE_END_DATE TIMESTAMP 8
8 PRINCIPAL_REPAYMENT_AMT DOUBLE PRECISION 8
9 STAGE_TERM BIGINT 8
10 CAPITALIZED_ARREARS_AMT DOUBLE PRECISION 8
11 ROLLOVER_INTEREST_AMT DOUBLE PRECISION 8
12 INSTALLMENT_AMT DOUBLE PRECISION 8
13 FIRST_INSTALLMENT_DATE TIMESTAMP 8
14 INSTALLMENT_NUM BIGINT 8
15 INSTALLMENT_FREQUENCY CHARACTER VARYING(30) 30
16 CALENDER_PLAN_ID BIGINT 8
17 INTEREST_RULE_ID BIGINT 8
18 INTEREST_RATE_ID BIGINT 8
19 INTEREST_AMT DOUBLE PRECISION 8
20 FIRST_INTEREST_CHARGE_DATE TIMESTAMP 8
21 INTEREST_FREQUENCY CHARACTER VARYING(30) 30
22 INTEREST_REPAYMENTS_NUM BIGINT 8
23 SERVICE_CHARGE_CODE CHARACTER VARYING(20) 20
24 SERVICE_CHARGE_AMT DOUBLE PRECISION 8
25 FIRST_SERVICE_CHARGE_DATE TIMESTAMP 8
26 CHARGE_FREQUENCY BIGINT 8
27 CHARGE_NUM BIGINT 8
28 PENALTY_RULE_ID BIGINT 8
29 PENALTY_RATE_ID BIGINT 8
30 PENALTY_FREQUENCY CHARACTER VARYING(30) 30
31 PPF_RULE_ID BIGINT 8
32 PPF_RATE_ID BIGINT 8
33 EFS_RULE_ID BIGINT 8
34 EFS_RATE_ID BIGINT 8
35 INTEREST_COMPOUNDING_FREQUENCY CHARACTER VARYING(30) 30
36 FIRST_COMPOUNDING_DATE TIMESTAMP 8
37 REST_PERIOD_FREQUENCY CHARACTER VARYING(30) 30
38 FIRST_REST_PERIOD_DATE TIMESTAMP 8
39 PENALTY_COMPOUNDING_FREQUENCY CHARACTER VARYING(30) 30
40 ARREAR_COMPOUNDING_FREQUENCY CHARACTER VARYING(30) 30
41 END_PERIOD_TREATMENT_CODE CHARACTER VARYING(30) 30
42 COA_RULE_CODE BIGINT 8
43 COA_FREQUENCY BIGINT 8
44 YEAR_BASE_TYPE_CODE BIGINT 8
45 YEAR_BASE_FOR_INTEREST BIGINT 8
46 YEAR_BASE_FOR_FEE BIGINT 8
47 INTEREST_CAP_FRQ CHARACTER VARYING(30) 30
48 FIRST_INTEREST_CAP_DATE TIMESTAMP 8
49 FEE_CAP_FRQ CHARACTER VARYING(30) 30
50 FIRST_FEE_CAP_DATE TIMESTAMP 8
51 OBJECT_STATUS CHARACTER(1) 1
52 MAKER_NAME CHARACTER VARYING(36) 36
53 CHECKER_NAME CHARACTER VARYING(36) 36
54 LAST_UPDATE_DATE TIMESTAMP 8
55 OBJECT_VERSION_NUMBER BIGINT 8
56 MINIMUM_DUE_PLAN_ID BIGINT 8
57 BILLING_GRACE_DAYS BIGINT 8
58 TERM_VALIDATION_RULE_CODE BIGINT 8
59 BILLING_GRACE_CYCLE BIGINT 8
60 INSTALLEMNT_DATE_DAY_PART_NUM BIGINT 8
61 CURRENCY_CODE CHARACTER VARYING(3) 3
62 INSTALLMENT_RULE_ID CHARACTER VARYING(40) 40
63 PERIODIC_FEE_TREATMENT_TYPE CHARACTER VARYING(30) 30
64 DOMAIN_OBJECT_EXTN CHARACTER VARYING(100) 100
65 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
66 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
67 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
68 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8