INT_HOG_EFS_ACCOUNT_EOD_LN_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_DIM_ID BIGINT 8
2 ACCOUNT_NUMBER CHARACTER VARYING(24) 24
3 ACCOUNT_ID_NUMBER CHARACTER VARYING(27) 27
4 MIGRATION_STATUS CHARACTER VARYING(8) 8
5 SHORT_NAME CHARACTER VARYING(25) 25
6 SRVC_BR INTEGER 4
7 ACCT_STATUS CHARACTER VARYING(3) 3
8 DT_OPENED DATE 4
9 DT_CLOSED CHARACTER VARYING(10) 10
10 DT_ORIG_MAT CHARACTER VARYING(10) 10
11 DT_CURR_MAT CHARACTER VARYING(10) 10
12 MATURED_LOAN_FLAG CHARACTER VARYING(1) 1
13 MORTGAGE_INSURANCE_FLAG CHARACTER VARYING(1) 1
14 MORTGAGE_INSURANCE_PROVIDER CHARACTER VARYING(35) 35
15 KEY_COID INTEGER 4
16 LOW_DOC_IND CHARACTER VARYING(1) 1
17 BROKER_CD CHARACTER VARYING(5) 5
18 ACCRED_BRKR_CDE CHARACTER VARYING(7) 7
19 KEY_PROD CHARACTER VARYING(3) 3
20 SUB_PRDCT_CD CHARACTER VARYING(3) 3
21 LOAN_PUR CHARACTER VARYING(3) 3
22 LOAN_SUB_PUR CHARACTER VARYING(2) 2
23 PROP_RHT CHARACTER VARYING(1) 1
24 AMT_ORIG_LOAN NUMERIC(16,2) 19
25 DC_LOAN_TRM INTEGER 4
26 DT_1ST_ADV CHARACTER VARYING(10) 10
27 COST_CENTER INTEGER 4
28 CAP_RATE_END_DATE CHARACTER VARYING(10) 10
29 REDRAW_PRODUCT_OPTION_FLAG CHARACTER VARYING(1) 1
30 LINKED_OFFSET_ACCOUNT_FLAG CHARACTER VARYING(1) 1
31 RATE_CHG_FREQ CHARACTER VARYING(2) 2
32 INTEREST_RATE_TYPE CHARACTER VARYING(2) 2
33 FV_FLAG CHARACTER VARYING(1) 1
34 BILL_TYPE CHARACTER VARYING(3) 3
35 LOAN_REPAYMENT_TYPE CHARACTER VARYING(3) 3
36 COLL_CALC_LTV DOUBLE PRECISION 8
37 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
38 SOURCE_SYSTEM_GROUP CHARACTER VARYING(3) 3
39 OF_ENTITY_CODE CHARACTER VARYING(100) 100
40 DST_SEGMENT1 CHARACTER VARYING(240) 240
41 OF_PRODUCT_CODE CHARACTER VARYING(150) 150
42 OF_PRINCIPAL_ACCOUNT_CODE CHARACTER VARYING(100) 100
43 OF_PRINCIPAL_CATEGORY_CODE CHARACTER VARYING(100) 100
44 OF_INT_ACCRUED_ACCOUNT_CODE CHARACTER VARYING(100) 100
45 OF_INT_ACCRUED_CATEGORY_CODE CHARACTER VARYING(100) 100
46 OF_INT_INCOME_ACCOUNT_CODE CHARACTER VARYING(100) 100
47 OF_INT_INCOME_CATEGORY_CODE CHARACTER VARYING(100) 100
48 CLMS_BORR_ID CHARACTER VARYING(50) 50
49 DIVISION_CODE CHARACTER VARYING(5) 5
50 SOURCE_PRODUCT_DIM_ID BIGINT 8
51 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
52 LOAN_PURPOSE_DIM_ID BIGINT 8
53 BILL_TYPE_DIM_ID BIGINT 8
54 MIGRATED_DATE TIMESTAMP 8
55 EFFECTIVE_START_DATE TIMESTAMP 8
56 EFFECTIVE_END_DATE TIMESTAMP 8