FCT_HOG_EFS_ACCOUNT_EOD_LN_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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