FCT_BNK_EFS_ACCOUNT_EOD_LN_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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