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