OBP24_HST_FLX_SH_SCHEDULE_PERIOD
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_HST_FLX_SH_SCHEDULE_PERIOD
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | SCHEDULE_CODE | CHARACTER VARYING(40) | 40 |
| 2 | SCHEDULE_TYPE_NAME | CHARACTER VARYING(120) | 120 |
| 3 | STAGE_NUM | BIGINT | 8 |
| 4 | STAGE_NAME | CHARACTER VARYING(120) | 120 |
| 5 | STAGE_START_DATE | TIMESTAMP | 8 |
| 6 | STAGE_END_DATE | TIMESTAMP | 8 |
| 7 | PRINCIPAL_REPAYMENT_AMT | DOUBLE PRECISION | 8 |
| 8 | STAGE_TERM | BIGINT | 8 |
| 9 | CAPITALIZED_ARREARS_AMT | DOUBLE PRECISION | 8 |
| 10 | ROLLOVER_INTEREST_AMT | DOUBLE PRECISION | 8 |
| 11 | INSTALLMENT_RULE_ID | CHARACTER VARYING(40) | 40 |
| 12 | INSTALLMENT_AMT | DOUBLE PRECISION | 8 |
| 13 | FIRST_INSTALLMENT_DATE | TIMESTAMP | 8 |
| 14 | INSTALLMENT_NUM | BIGINT | 8 |
| 15 | INSTALLMENT_FREQ | CHARACTER VARYING(30) | 30 |
| 16 | CALENDER_PLAN_ID | BIGINT | 8 |
| 17 | INTEREST_AMT | DOUBLE PRECISION | 8 |
| 18 | FIRST_INTEREST_CHARGE_DATE | TIMESTAMP | 8 |
| 19 | INTEREST_FREQ | CHARACTER VARYING(30) | 30 |
| 20 | INTEREST_REPAYMENTS_NUM | BIGINT | 8 |
| 21 | SERVICE_CHARGE_CODE | CHARACTER VARYING(20) | 20 |
| 22 | SERVICE_CHARGE_AMT | DOUBLE PRECISION | 8 |
| 23 | FIRST_SERVICE_CHARGE_DATE | TIMESTAMP | 8 |
| 24 | CHARGE_FREQ | BIGINT | 8 |
| 25 | CHARGE_NUM | BIGINT | 8 |
| 26 | PENALTY_FREQ | CHARACTER VARYING(30) | 30 |
| 27 | INTEREST_FREQ_COMP | CHARACTER VARYING(30) | 30 |
| 28 | FIRST_COMP_DATE | TIMESTAMP | 8 |
| 29 | INTEREST_FREQ_REST | CHARACTER VARYING(30) | 30 |
| 30 | FIRST_REST_PERIOD_DATE | TIMESTAMP | 8 |
| 31 | PENALTY_FREQ_COMP | CHARACTER VARYING(30) | 30 |
| 32 | ARREAR_COMP_FREQ | CHARACTER VARYING(30) | 30 |
| 33 | END_PERIOD_TREATMENT_CODE | CHARACTER VARYING(30) | 30 |
| 34 | COA_RULE_CODE | BIGINT | 8 |
| 35 | COA_FREQ | BIGINT | 8 |
| 36 | YEAR_BASE_TYPE_CODE | BIGINT | 8 |
| 37 | YEAR_BASE_FOR_INTEREST | BIGINT | 8 |
| 38 | YEAR_BASE_FOR_FEE | BIGINT | 8 |
| 39 | INTEREST_CAP_FRQ | CHARACTER VARYING(30) | 30 |
| 40 | FIRST_INTEREST_CAP_DATE | TIMESTAMP | 8 |
| 41 | FEE_CAP_FRQ | CHARACTER VARYING(30) | 30 |
| 42 | FIRST_FEE_CAP_DATE | TIMESTAMP | 8 |
| 43 | MIN_DUE_PLAN_ID | BIGINT | 8 |
| 44 | BILLING_GRACE_DAYS | BIGINT | 8 |
| 45 | TERM_VALIDATION_RULE_CODE | BIGINT | 8 |
| 46 | BILLING_GRACE_CYCLE | BIGINT | 8 |
| 47 | INSTALLMENT_DATE_DAY_PART_NUM | BIGINT | 8 |
| 48 | CURRENCY_CODE | CHARACTER VARYING(3) | 3 |
| 49 | PERIODIC_FEE_TREATMENT_TYPE | CHARACTER VARYING(30) | 30 |
| 50 | AMOUNT_TYPE | CHARACTER VARYING(40) | 40 |
| 51 | SCHEDULE_ID | CHARACTER VARYING(40) | 40 |
| 52 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 53 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 54 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 55 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |