FCT_HLG_EFS_ACCOUNT_EOM_LN_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
2 ACCOUNT_CREATION_DATE TIMESTAMP 8
3 ACCOUNT_EFS_DIM_ID BIGINT 8
4 ACCOUNT_GL_CLOSURE_DATE TIMESTAMP 8
5 ACCOUNT_GL_OPENING_DATE TIMESTAMP 8
6 ACCOUNT_ID_NUMBER CHARACTER VARYING(24) 24
7 ACCOUNT_NUMBER CHARACTER VARYING(24) 24
8 APPLICATION_FACILITY_EFS_DIM_ID CHARACTER VARYING(26) 26
9 ACCOUNT_OPENING_DATE TIMESTAMP 8
10 ACCOUNT_STATUS_CODE CHARACTER VARYING(50) 50
11 ACCOUNT_TITLE CHARACTER VARYING(300) 300
12 ACCREDITED_BROKER_CODE CHARACTER VARYING(9) 9
13 APPROVED_AMOUNT NUMERIC(15,2) 19
14 ARRANGEMENT_ID CHARACTER VARYING(40) 40
15 BANK_CODE CHARACTER VARYING(10) 10
16 BASE_RATE NUMERIC(8,5) 19
17 BILL_TYPE_DIM_ID BIGINT 8
18 BROKER_ID CHARACTER VARYING(20) 20
19 COMPANY_CODE CHARACTER VARYING(5) 5
20 COST_CENTRE_CODE CHARACTER VARYING(150) 150
21 CURRENCY_CODE CHARACTER VARYING(3) 3
22 CURRENT_INTEREST_RATE NUMERIC(10,4) 19
23 EFFECTIVE_START_DATE TIMESTAMP 8
24 EFFECTIVE_END_DATE TIMESTAMP 8
25 FACILITY_ID CHARACTER VARYING(40) 40
26 FIRST_DISBURSEMENT_DATE TIMESTAMP 8
27 FIRST_HOME_BUYER_FLAG CHARACTER VARYING(1) 1
28 FIXED_PERIOD_END_DATE TIMESTAMP 8
29 FIXED_TERM_MONTHS INTEGER 4
30 FV_FLAG CHARACTER VARYING(1) 1
31 INTEREST_RATE_TERM CHARACTER VARYING(10) 10
32 INTEREST_RATE_TYPE CHARACTER VARYING(5) 5
33 IS_CURRENT CHARACTER VARYING(1) 1
34 LOAN_PURPOSE CHARACTER VARYING(100) 100
35 LOAN_PURPOSE_DIM_ID BIGINT 8
36 LOAN_REPAYMENT_TYPE CHARACTER VARYING(22) 22
37 LOAN_SUB_PURPOSE CHARACTER VARYING(100) 100
38 LOAN_TO_VALUE_RATIO NUMERIC(17,2) 19
39 LOWDOC_FLAG CHARACTER VARYING(1) 1
40 MARGIN_RATE NUMERIC(8,5) 19
41 MATURED_LOAN_FLAG CHARACTER VARYING(1) 1
42 MATURITY_DATE TIMESTAMP 8
43 MIGRATION_STATUS CHARACTER VARYING(8) 8
44 MORTGAGE_INSURANCE_FLAG CHARACTER VARYING(1) 1
45 MORTGAGE_INSURANCE_PROVIDER CHARACTER VARYING(80) 80
46 OF_COST_CENTRE_CODE CHARACTER VARYING(150) 150
47 OF_COST_CENTRE_DIM_ID CHARACTER VARYING(150) 150
48 OF_ENTITY_CODE CHARACTER VARYING(150) 150
49 OF_ENTITY_DIM_ID CHARACTER VARYING(150) 150
50 OF_INBA_ACCOUNT_CODE CHARACTER VARYING(150) 150
51 OF_INBA_ACCOUNT_DIM_ID CHARACTER VARYING(150) 150
52 OF_INBA_CATEGORY_CODE CHARACTER VARYING(150) 150
53 OF_INBA_CATEGORY_DIM_ID CHARACTER VARYING(150) 150
54 OF_INT_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(150) 150
55 OF_INT_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(150) 150
56 OF_INT_ACCRUED_CATEGORY_CODE CHARACTER VARYING(150) 150
57 OF_INT_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(150) 150
58 OF_INT_EXPENSE_ACCOUNT_CODE CHARACTER VARYING(150) 150
59 OF_INT_EXPENSE_ACCOUNT_DIM_ID CHARACTER VARYING(150) 150
60 OF_INT_EXPENSE_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(150) 150
61 OF_INT_EXPENSE_ACCRUED_ACCOUNT_DIM_ID CHARACTER VARYING(150) 150
62 OF_INT_EXPENSE_ACCRUED_CATEGORY_CODE CHARACTER VARYING(150) 150
63 OF_INT_EXPENSE_ACCRUED_CATEGORY_DIM_ID CHARACTER VARYING(150) 150
64 OF_INT_EXPENSE_CATEGORY_CODE CHARACTER VARYING(150) 150
65 OF_INT_EXPENSE_CATEGORY_DIM_ID CHARACTER VARYING(150) 150
66 OF_INT_INCOME_ACCOUNT_CODE CHARACTER VARYING(150) 150
67 OF_INT_INCOME_ACCOUNT_DIM_ID CHARACTER VARYING(150) 150
68 OF_INT_INCOME_CATEGORY_CODE CHARACTER VARYING(150) 150
69 OF_INT_INCOME_CATEGORY_DIM_ID CHARACTER VARYING(150) 150
70 OF_PRINCIPAL_ACCOUNT_CODE CHARACTER VARYING(150) 150
71 OF_PRINCIPAL_ACCOUNT_DIM_ID CHARACTER VARYING(150) 150
72 OF_PRINCIPAL_CATEGORY_CODE CHARACTER VARYING(150) 150
73 OF_PRINCIPAL_CATEGORY_DIM_ID CHARACTER VARYING(150) 150
74 OF_PRODUCT_CODE CHARACTER VARYING(150) 150
75 OF_PRODUCT_DIM_ID CHARACTER VARYING(150) 150
76 ORIGINAL_MATURITY_DATE TIMESTAMP 8
77 OWNER_OCCUPIED CHARACTER VARYING(14) 14
78 PERS_INV_USAGE_TYPE_DIM_ID CHARACTER VARYING(30) 30
79 PRODUCT_CLASS CHARACTER VARYING(2) 2
80 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
81 PRODUCT_ID CHARACTER VARYING(30) 30
82 PRODUCT_SUB_CODE CHARACTER VARYING(30) 30
83 REDRAW_PRODUCT_OPTION_FLAG CHARACTER VARYING(1) 1
84 REQUESTED_AMOUNT NUMERIC(15,2) 19
85 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
86 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
87 SOURCE_PRODUCT_DIM_ID BIGINT 8
88 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
89 SOURCE_SYSTEM_GROUP CHARACTER VARYING(3) 3
90 TERM_MONTHS NUMERIC(19,0) 19