FCT_CLM_CRAI_ACCOUNT_EOD_LN_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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