DIM_SDW_TSLND_FACILITY_TYP3

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
2 ARRANGEMENT_ID CHARACTER VARYING(20) 20
3 ORIG_CREATION_DT TIMESTAMP 8
4 ORIG_PERIOD_DIM_ID BIGINT 8
5 ORIG_LOAN_ACCOUNT CHARACTER VARYING(20) 20
6 ORIG_DT_LOAN_ACCOUNT TIMESTAMP 8
7 ORIG_LOAN_TERM_MONTHS NUMERIC(38,0) 19
8 ORIG_DT_LOAN_TERM_MONTHS TIMESTAMP 8
9 ORIG_INT_ONLY_LOAN_TERM NUMERIC(38,0) 19
10 ORIG_DT_INT_ONLY_LOAN_TERM TIMESTAMP 8
11 ORIG_ADD_LOAN_FLAG CHARACTER VARYING(1) 1
12 ORIG_DT_ADD_LOAN_FLAG TIMESTAMP 8
13 ORIG_LVR NUMERIC(8,3) 19
14 ORIG_DT_LVR TIMESTAMP 8
15 ORIG_ACTUAL_INTEREST_RATE NUMERIC(6,3) 19
16 ORIG_DT_ACTUAL_INTEREST_RATE TIMESTAMP 8
17 ORIG_PRODUCT_INTEREST_RATE NUMERIC(6,3) 19
18 ORIG_DT_PRODUCT_INTEREST_RATE TIMESTAMP 8
19 ORIG_BORROWED_EQUITY_TYPE CHARACTER VARYING(24) 24
20 ORIG_DT_BORROWED_EQUITY_TYPE TIMESTAMP 8
21 ORIG_PAYMENT_TYPE CHARACTER VARYING(24) 24
22 ORIG_DT_PAYMENT_TYPE TIMESTAMP 8
23 ORIG_INT_CAP_FLAG CHARACTER VARYING(1) 1
24 ORIG_DT_INT_CAP_FLAG TIMESTAMP 8
25 ORIG_PROGRESSIVE_DRAW_FLAG CHARACTER VARYING(1) 1
26 ORIG_DT_PROGRESSIVE_DRAW_FLAG TIMESTAMP 8
27 ORIG_CC_CURR_CRD_AR_STATUS CHARACTER VARYING(40) 40
28 ORIG_DT_CC_CURR_CRD_AR_STATUS TIMESTAMP 8
29 ORIG_CC_AR_DECLINED_REASON CHARACTER VARYING(3) 3
30 ORIG_DT_CC_AR_DECLINED_REASON TIMESTAMP 8
31 ORIG_SETTLEMENT_DT TIMESTAMP 8
32 ORIG_DT_SETTLEMENT_DT TIMESTAMP 8
33 ORIG_FINANCE_DT TIMESTAMP 8
34 ORIG_DT_FINANCE_DT TIMESTAMP 8
35 ORIG_LOAN_TYPE CHARACTER VARYING(60) 60
36 ORIG_DT_LOAN_TYPE TIMESTAMP 8
37 ORIG_LOAN_USE CHARACTER VARYING(60) 60
38 ORIG_DT_LOAN_USE TIMESTAMP 8
39 ORIG_PURPOSE_CODE CHARACTER VARYING(60) 60
40 ORIG_DT_PURPOSE_CODE TIMESTAMP 8
41 ORIG_SUB_PURPOSE_CODE CHARACTER VARYING(60) 60
42 ORIG_DT_SUB_PURPOSE_CODE TIMESTAMP 8
43 ORIG_LOAN_AMOUNT NUMERIC(14,2) 19
44 ORIG_DT_LOAN_AMOUNT TIMESTAMP 8
45 ORIG_TOTAL_FUNDING_AMOUNT NUMERIC(14,2) 19
46 ORIG_DT_TOTAL_FUNDING_AMOUNT TIMESTAMP 8
47 ORIG_BORROWER_CONTRIBUTION NUMERIC(14,2) 19
48 ORIG_DT_BORROWER_CONTRIBUTION TIMESTAMP 8
49 CURR_PERIOD_DIM_ID BIGINT 8
50 CURR_LOAN_ACCOUNT CHARACTER VARYING(20) 20
51 CURR_DT_LOAN_ACCOUNT TIMESTAMP 8
52 CURR_LOAN_TERM_MONTHS NUMERIC(38,0) 19
53 CURR_DT_LOAN_TERM_MONTHS TIMESTAMP 8
54 CURR_INT_ONLY_LOAN_TERM NUMERIC(38,0) 19
55 CURR_DT_INT_ONLY_LOAN_TERM TIMESTAMP 8
56 CURR_ADD_LOAN_FLAG CHARACTER VARYING(1) 1
57 CURR_DT_ADD_LOAN_FLAG TIMESTAMP 8
58 CURR_LVR NUMERIC(8,3) 19
59 CURR_DT_LVR TIMESTAMP 8
60 CURR_ACTUAL_INTEREST_RATE NUMERIC(6,3) 19
61 CURR_DT_ACTUAL_INTEREST_RATE TIMESTAMP 8
62 CURR_PRODUCT_INTEREST_RATE NUMERIC(6,3) 19
63 CURR_DT_PRODUCT_INTEREST_RATE TIMESTAMP 8
64 CURR_BORROWED_EQUITY_TYPE CHARACTER VARYING(24) 24
65 CURR_DT_BORROWED_EQUITY_TYPE TIMESTAMP 8
66 CURR_PAYMENT_TYPE CHARACTER VARYING(24) 24
67 CURR_DT_PAYMENT_TYPE TIMESTAMP 8
68 CURR_INT_CAP_FLAG CHARACTER VARYING(1) 1
69 CURR_DT_INT_CAP_FLAG TIMESTAMP 8
70 CURR_PROGRESSIVE_DRAW_FLAG CHARACTER VARYING(1) 1
71 CURR_DT_PROGRESSIVE_DRAW_FLAG TIMESTAMP 8
72 CURR_CC_CURR_CRD_AR_STATUS CHARACTER VARYING(40) 40
73 CURR_DT_CC_CURR_CRD_AR_STATUS TIMESTAMP 8
74 CURR_CC_AR_DECLINED_REASON CHARACTER VARYING(3) 3
75 CURR_DT_CC_AR_DECLINED_REASON TIMESTAMP 8
76 CURR_SETTLEMENT_DT TIMESTAMP 8
77 CURR_DT_SETTLEMENT_DT TIMESTAMP 8
78 CURR_FINANCE_DT TIMESTAMP 8
79 CURR_DT_FINANCE_DT TIMESTAMP 8
80 CURR_LOAN_TYPE CHARACTER VARYING(60) 60
81 CURR_DT_LOAN_TYPE TIMESTAMP 8
82 CURR_LOAN_USE CHARACTER VARYING(60) 60
83 CURR_DT_LOAN_USE TIMESTAMP 8
84 CURR_PURPOSE_CODE CHARACTER VARYING(60) 60
85 CURR_DT_PURPOSE_CODE TIMESTAMP 8
86 CURR_SUB_PURPOSE_CODE CHARACTER VARYING(60) 60
87 CURR_DT_SUB_PURPOSE_CODE TIMESTAMP 8
88 CURR_LOAN_AMOUNT NUMERIC(14,2) 19
89 CURR_DT_LOAN_AMOUNT TIMESTAMP 8
90 CURR_TOTAL_FUNDING_AMOUNT NUMERIC(14,2) 19
91 CURR_DT_TOTAL_FUNDING_AMOUNT TIMESTAMP 8
92 CURR_BORROWER_CONTRIBUTION NUMERIC(14,2) 19
93 CURR_DT_BORROWER_CONTRIBUTION TIMESTAMP 8
94 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
95 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
96 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
97 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8