FCT_OBP_EFS_ACCOUNT_EOD_LN_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Synonyms

SDSNZP02_BANK..EFS_FCT_OBP_EFS_ACCOUNT_EOD_LN_INSIGHT

SDSNZP02_BANK..UBAR_FCT_OBP_EFS_ACCOUNT_EOD_LN_INSIGHT

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