FCT_HOG_CRAI_ACCOUNT_EOD_LN_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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