OBP24_HST_FLX_LN_ACCT_ADDN_DETLS_H

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

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