FCT_OBP_LOAN_PH_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

OBP Customer Layer Loan Account detils - replaced by FCT_BNK_FATCA_LOAN_PRODUCT_INSIGHT

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_LOAN_PH

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 PRODUCT_HOLDING_NUMBER CHARACTER VARYING(128) 128
3 ACCOUNT_NUMBER CHARACTER VARYING(128) 128
4 BANK_CODE CHARACTER VARYING(10) 10
5 PRODUCT_ID CHARACTER VARYING(30) 30
6 PRODUCT_DESCRIPTION CHARACTER VARYING(120) 120
7 OFFER_ID CHARACTER VARYING(30) 30
8 OFFER_DESCRIPTION CHARACTER VARYING(120) 120
9 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
10 SOURCE_PRODUCT_DESCRIPTION CHARACTER VARYING(358) 358
11 BRAND_CODE CHARACTER VARYING(3) 3
12 BANKING_TYPE CHARACTER VARYING(6) 6
13 APPLICATION_CHANNEL CHARACTER VARYING(10) 10
14 APPLICATION_CHANNEL_SOURCE CHARACTER VARYING(8) 8
15 APPLICATION_CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
16 APPROVED_AMOUNT DOUBLE PRECISION 8
17 SUBMISSION_ID CHARACTER VARYING(50) 50
18 APPLICATION_ID CHARACTER VARYING(50) 50
19 APPLICATION_SUBMISSION_DATE TIMESTAMP 8
20 BORROWING_ENTITY_ID CHARACTER VARYING(16) 16
21 PRIMARY_OBP_PARTY_ID CHARACTER VARYING(40) 40
22 ACCOUNT_TITLE CHARACTER VARYING(300) 300
23 FV_FLAG CHARACTER VARYING(1) 1
24 INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
25 COST_CENTRE_CODE CHARACTER VARYING(150) 150
26 APPROVER_ID CHARACTER VARYING(40) 40
27 DEPARTMENT CHARACTER VARYING(240) 240
28 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
29 MATURITY_DATE TIMESTAMP 8
30 ADD_LOAN_DATE TIMESTAMP 8
31 ACCOUNT_OPENING_DATE TIMESTAMP 8
32 LOAN_PURPOSE CHARACTER VARYING(40) 40
33 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
34 LOAN_SUB_PURPOSE CHARACTER VARYING(10) 10
35 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
36 ACCOUNT_STATUS_CODE CHARACTER VARYING(50) 50
37 ACCOUNT_STATUS_DESC CHARACTER VARYING(256) 256
38 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
39 APPLICATION_BRANCH CHARACTER VARYING(10) 10
40 APPLICATION_BRANCH_NAME CHARACTER VARYING(105) 105
41 STAFF_ACCOUNT_FLAG CHARACTER(1) 1
42 TERM_MONTHS BIGINT 8
43 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
44 OWNER_OCCUPIED CHARACTER VARYING(14) 14
45 CREDIT_RISK_RATING_CODE CHARACTER VARYING(40) 40
46 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
47 SERVICE_BRANCH_NAME CHARACTER VARYING(105) 105
48 APPROVAL_DATE TIMESTAMP 8
49 BROKER_ID CHARACTER VARYING(20) 20
50 LOAN_TO_VALUE_RATIO DOUBLE PRECISION 8
51 OFFER_SWAP_INDICATOR CHARACTER VARYING(1) 1
52 NEW_OFFER_ID CHARACTER VARYING(30) 30
53 OFFER_SWAP_DATE TIMESTAMP 8
54 FIRST_DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
55 PRINCIPAL_OFFSET_ALLOWED_FLAG CHARACTER(1) 1
56 MOBILE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
57 INTERNET_BANKING_ALLOWED_FLAG CHARACTER(1) 1
58 PHONE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
59 REDRAW_ALLOWED_FLAG CHARACTER(1) 1
60 ACCELERATED_PAYMENT_ALLOWED_FLAG CHARACTER(1) 1
61 BUNDLE_REFERENCE_ID CHARACTER VARYING(40) 40
62 BUNDLE_NAME CHARACTER VARYING(40) 40
63 PAYOUT_REASON_CODE CHARACTER VARYING(401) 401
64 FIRST_DISBURSEMENT_DATE TIMESTAMP 8
65 CURRENT_INTEREST_RATE DOUBLE PRECISION 8
66 RATE_START_DATE TIMESTAMP 8
67 RATE_END_DATE TIMESTAMP 8
68 BILL_FREQUENCY CHARACTER VARYING(30) 30
69 NEXT_DUE_AMT DOUBLE PRECISION 8
70 SCHEDULE_CODE CHARACTER VARYING(40) 40
71 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
72 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
73 CHANGE_END_OF_DAY_DATE DATE 4
74 IS_EOD_RECORD CHARACTER VARYING(1) 1
75 IS_CURRENT CHARACTER VARYING(1) 1
76 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
77 CDC_RECORD_TYPE CHARACTER VARYING(16) 16