FCT_BNK_UDM_RATE_CHANGE

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

INSNZP05_BANK..FCT_BNK_UDM_RATE_CHANGE_INSIGHT

Columns
# Name Data Type Length
1 PRODUCT_GROUP CHARACTER VARYING(14) 14
2 ACCOUNT_TITLE CHARACTER VARYING(300) 300
3 ACCOUNT_OPENING_DATE TIMESTAMP 8
4 ACCOUNT_ID CHARACTER VARYING(128) 128
5 RATE_TYPE_CODE CHARACTER VARYING(30) 30
6 CUSTOMER_INTEREST_RATE DOUBLE PRECISION 8
7 PRIOR_CUSTOMER_INTEREST_RATE DOUBLE PRECISION 8
8 ACCT_UDM_RATE NUMERIC(8,2) 19
9 PRIOR_ACCT_UDM_RATE NUMERIC(8,2) 19
10 BASE_RATE NUMERIC(8,2) 19
11 UDM_REASON_CODE CHARACTER VARYING(200) 200
12 UDM_REASON_DESCRIPTION CHARACTER VARYING(120) 120
13 LAST_UPDATED_BY CHARACTER VARYING(254) 254
14 LAST_UPDATED_DATE TIMESTAMP 8
15 APPROVED_BY CHARACTER VARYING(254) 254
16 APPROVED_BY_NAME CHARACTER VARYING(254) 254
17 APPLN_REQ_TYPE CHARACTER VARYING(5) 5
18 BRANCH CHARACTER VARYING(105) 105
19 REGION CHARACTER VARYING(240) 240
20 CURRENT_PRODUCT CHARACTER VARYING(65) 65
21 CURRENT_OFFER CHARACTER VARYING(30) 30
22 PREVIOUS_PRODUCT CHARACTER VARYING(65) 65
23 PREVIOUS_OFFER CHARACTER VARYING(30) 30
24 PREVIOUS_LOAN_REPAYMENT_TYPE CHARACTER VARYING(128) 128
25 PREVIOUS_LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
26 LOAN_PURPOSE CHARACTER VARYING(40) 40
27 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
28 LOAN_SUB_PURPOSE CHARACTER VARYING(10) 10
29 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
30 OWNER_OCCUPIED CHARACTER VARYING(14) 14
31 LOAN_REPAYMENT_TYPE CHARACTER VARYING(128) 128
32 ORIGINATION_CHANNEL CHARACTER VARYING(30) 30
33 CURRENT_LOAN_BALANCE NUMERIC(37,2) 19
34 EFFECTIVE_START_DATE TIMESTAMP 8
35 EFFECTIVE_END_DATE DATE 4
36 EMPLOYEE_NUMBER CHARACTER VARYING(50) 50
37 REPORTING_NAME CHARACTER VARYING(255) 255
38 POSITION_TITLE CHARACTER VARYING(256) 256
39 DIVISION_NAME CHARACTER VARYING(100) 100
40 DEPARTMENT_NAME CHARACTER VARYING(100) 100
41 TEAM_NAME CHARACTER VARYING(100) 100