FCT_BNK_OSX_T_TRN_LOAN_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ENTITY NATIONAL CHARACTER VARYING(12) 12
2 DEAL_ID NATIONAL CHARACTER VARYING(40) 40
3 START_VALIDITY_DATE DATE 4
4 END_VALIDITY_DATE DATE 4
5 CUSTOMER_NR NATIONAL CHARACTER VARYING(30) 30
6 PROFIT_CENTRE NATIONAL CHARACTER VARYING(12) 12
7 BOOK_CODE NATIONAL CHARACTER VARYING(12) 12
8 MEASUREMENT_CATEGORY NATIONAL CHARACTER VARYING(6) 6
9 IFRS_CLASS NATIONAL CHARACTER VARYING(6) 6
10 ELECTION_TYPE NATIONAL CHARACTER VARYING(4) 4
11 IS_HELD_FOR_SALE INTEGER 4
12 RECORD_ID NATIONAL CHARACTER VARYING(1) 1
13 SOURCE_SYSTEM NATIONAL CHARACTER VARYING(40) 40
14 DEAL_TYPE NATIONAL CHARACTER VARYING(30) 30
15 DEAL_SUBTYPE NATIONAL CHARACTER VARYING(30) 30
16 DEAL_DATE TIMESTAMP 8
17 VALUE_DATE TIMESTAMP 8
18 MATURITY_DATE TIMESTAMP 8
19 REVERSAL_DATE TIMESTAMP 8
20 CURRENCY NATIONAL CHARACTER VARYING(3) 3
21 PRINCIPAL_AMOUNT NUMERIC(25,8) 19
22 RESIDUAL_AMOUNT NUMERIC(25,8) 19
23 RATE_VARIABILITY NATIONAL CHARACTER VARYING(10) 10
24 INTEREST_RATE NUMERIC(15,8) 19
25 BASE_RATE NUMERIC(15,8) 19
26 SPREAD NUMERIC(15,8) 19
27 REFERENCE_INTEREST_CODE NATIONAL CHARACTER VARYING(12) 12
28 REFERENCE_INTEREST_TYPE NATIONAL CHARACTER VARYING(10) 10
29 MARGIN NUMERIC(25,8) 19
30 NEXT_REPAYMENT_DATE TIMESTAMP 8
31 REPAYMENT_FREQ NATIONAL CHARACTER VARYING(1) 1
32 REPAYMENT_DAY_NR INTEGER 4
33 LOCAL_INDUSTRY_CODE NATIONAL CHARACTER VARYING(12) 12
34 COUNTRY_OF_RISK NATIONAL CHARACTER VARYING(3) 3
35 ACCOUNT_OFFICER NATIONAL CHARACTER VARYING(20) 20
36 ROLLOVER_DATE TIMESTAMP 8
37 NEXT_ROLLOVER_DATE TIMESTAMP 8
38 ROLLOVER_FREQ NATIONAL CHARACTER VARYING(1) 1
39 ROLLOVER_DAY_NR INTEGER 4
40 INTEREST_BASIS INTEGER 4
41 INTEREST_PAYMENT_FREQ NATIONAL CHARACTER VARYING(1) 1
42 TOTAL_INTEREST NUMERIC(25,8) 19
43 NEXT_INTEREST_PAY_DATE TIMESTAMP 8
44 INTEREST_BASE_DATE TIMESTAMP 8
45 FUNDING_RATE NUMERIC(15,8) 19
46 MATCHED_OPPORTUNITY_RATE NUMERIC(15,8) 19
47 ACCR_FUNDING_AMOUNT NUMERIC(25,8) 19
48 FUNDING_CENTRE NATIONAL CHARACTER VARYING(12) 12
49 RELATED_DEAL_ID NATIONAL CHARACTER VARYING(40) 40
50 ORIGINAL_ENTRY_DATE TIMESTAMP 8
51 SETTLEMENT_CURRENCY NATIONAL CHARACTER VARYING(3) 3
52 IN_CURRENCY NATIONAL CHARACTER VARYING(3) 3
53 IS_SUBORDINATED INTEGER 4
54 REST_PERIOD NATIONAL CHARACTER VARYING(20) 20
55 NEXT_REST_DATE TIMESTAMP 8
56 IS_INTEREST_SETTLED_ON_LAST_CAPITAL_PAYMENT INTEGER 4
57 IS_PRINCIPAL_PAYMENT_AT_COB INTEGER 4
58 DISCOUNT_CURVE NATIONAL CHARACTER VARYING(20) 20
59 DISCOUNT_CONSTANT_SPREAD NUMERIC(25,8) 19
60 DISCOUNT_SPREAD_CURVE NATIONAL CHARACTER VARYING(20) 20
61 AVERAGE_BALANCE NUMERIC(25,8) 19
62 CASHFLOW_PATTERN_CODE NATIONAL CHARACTER VARYING(20) 20
63 PURPOSE NATIONAL CHARACTER VARYING(50) 50
64 SERVICING_BANK NATIONAL CHARACTER VARYING(30) 30
65 IS_SERVICED_ONLY INTEGER 4
66 IS_SECURED INTEGER 4
67 IS_SECURITISED INTEGER 4
68 BUSINESS_UNIT NATIONAL CHARACTER VARYING(5) 5
69 SYNDICATION_ROLE NATIONAL CHARACTER VARYING(20) 20
70 IS_GOVERNMENT_GUARANTEED INTEGER 4
71 ELIGIBLE_CENTRAL_BANK_SET_ID INTEGER 4
72 RESTRUCTURE_TYPE NATIONAL CHARACTER VARYING(5) 5
73 RESTRUCTURE_DATE TIMESTAMP 8
74 IS_IN_PROBATION INTEGER 4
75 DEPOSIT_GUARANTEE_SCHEME_CODE NATIONAL CHARACTER VARYING(20) 20
76 CALENDAR NATIONAL CHARACTER VARYING(10) 10
77 STRIKE_PRICE NUMERIC(15,8) 19
78 CAP_RATE NUMERIC(15,8) 19
79 FLOOR_RATE NUMERIC(15,8) 19
80 PD_CURVE_CODE NATIONAL CHARACTER VARYING(20) 20
81 LGD_CURVE_CODE NATIONAL CHARACTER VARYING(20) 20
82 VOLATILITY_SURFACE_CODE NATIONAL CHARACTER VARYING(20) 20
83 SYNDICATION_ID NATIONAL CHARACTER VARYING(40) 40
84 FAIR_VALUE_HIERARCHY INTEGER 4
85 NR_OF_DAYS_NOTICE INTEGER 4
86 NOTICE_DATE TIMESTAMP 8
87 NEXT_REPRICING_DATE TIMESTAMP 8
88 CHAR_CUST_ELEMENT1 NATIONAL CHARACTER VARYING(40) 40
89 CHAR_CUST_ELEMENT2 NATIONAL CHARACTER VARYING(40) 40
90 CHAR_CUST_ELEMENT3 NATIONAL CHARACTER VARYING(40) 40
91 CHAR_CUST_ELEMENT4 NATIONAL CHARACTER VARYING(40) 40
92 CHAR_CUST_ELEMENT5 NATIONAL CHARACTER VARYING(40) 40
93 NUM_CUST_ELEMENT1 NUMERIC(25,8) 19
94 NUM_CUST_ELEMENT2 NUMERIC(25,8) 19
95 NUM_CUST_ELEMENT3 NUMERIC(25,8) 19
96 NUM_CUST_ELEMENT4 NUMERIC(25,8) 19
97 NUM_CUST_ELEMENT5 NUMERIC(25,8) 19
98 LAST_MODIFIED TIMESTAMP 8
99 MODIFIED_BY NATIONAL CHARACTER VARYING(255) 255