OBP24_HST_FLX_LN_ACCT_ADDN_DETLS_B

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_OBP_HST_FLX_LN_ACCT_ADDN_DETLS_B

Columns
# Name Data Type Length
1 ACCOUNT_ID CHARACTER VARYING(40) 40
2 CURRENCY_CODE CHARACTER VARYING(3) 3
3 EFFECTIVE_FROM_DATE TIMESTAMP 8
4 LTV_RATIO DOUBLE PRECISION 8
5 INITIAL_RATE_TYPE_CODE CHARACTER VARYING(22) 22
6 FIXED_RATE_TERM_MONTHS BIGINT 8
7 VARIABLE_RATE_TERM_MONTHS BIGINT 8
8 OFFER_LETTER_DATE TIMESTAMP 8
9 FIXED_PERIOD_END_DATE TIMESTAMP 8
10 APPLICATION_ID CHARACTER VARYING(50) 50
11 AGREEMENT_DATE TIMESTAMP 8
12 LAST_PAYMENT_AMT DOUBLE PRECISION 8
13 IS_ACCOUNT_DELINQUENT CHARACTER(1) 1
14 DELINQUENCY_START_DATE TIMESTAMP 8
15 DELINQUENCY_UPDATE_DATE TIMESTAMP 8
16 REASON_FOR_DELINQUENCY CHARACTER VARYING(100) 100
17 IS_ACCOUNT_IN_COLLECTION CHARACTER(1) 1
18 COLLECTION_START_DATE TIMESTAMP 8
19 PRIMARY_REASON_FOR_COLLN CHARACTER VARYING(100) 100
20 SECONDARY_REASON_FOR_COLLN CHARACTER VARYING(100) 100
21 IS_ACCOUNT_IN_HARDSHIP CHARACTER(1) 1
22 HARDSHIP_RELIEF_START_DATE TIMESTAMP 8
23 HARDSHIP_RELIEF_END_DATE TIMESTAMP 8
24 ARRANGEMENT_ID CHARACTER VARYING(40) 40
25 IS_RATE_LOCK_PURCHASED CHARACTER(1) 1
26 CONTRACTED_DATE TIMESTAMP 8
27 SCHEDULE_SIMULATION_ID CHARACTER VARYING(16) 16
28 IOA_PERIOD_START_DATE TIMESTAMP 8
29 ELAPSED_FIXED_RATE_TERM_MONTHS BIGINT 8
30 TOTAL_INT_ONLY_MONTHS BIGINT 8
31 INSURANCE_QUOTE_ID CHARACTER VARYING(50) 50
32 PREMIUM_AMOUNT DOUBLE PRECISION 8
33 AMT_REDRAWN_TILL_DATE DOUBLE PRECISION 8
34 AMT_REDRAWN_TILL_PERIOD DOUBLE PRECISION 8
35 LAST_REDRAW_DATE TIMESTAMP 8
36 AUTO_CLOSURE_RETRY_DATE TIMESTAMP 8
37 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
38 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8