FCT_BNK_PORTFOLIO_PIT_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

Portfolio Point in Time data for all accounts in CBP, Hogan & CLMS. Primary Balance table

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 ACCOUNT_DIM_ID BIGINT 8
3 CQR_DIM_ID BIGINT 8
4 SR_DIM_ID BIGINT 8
5 CRC_DIM_ID BIGINT 8
6 SOURCE_PRODUCT_DIM_ID BIGINT 8
7 CLMS_DIVISION_DIM_ID BIGINT 8
8 BDM_DIM_ID BIGINT 8
9 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
10 GL_PRODUCT_DIM_ID BIGINT 8
11 GL_ACCOUNT_DIM_ID BIGINT 8
12 COST_CENTRE_DIM_ID BIGINT 8
13 BRANCH_DIM_ID BIGINT 8
14 CLMS_GROUP_DIM_ID BIGINT 8
15 BORROWER_DIM_ID BIGINT 8
16 ACCOUNT_STATUS_DIM_ID BIGINT 8
17 INSERT_RUN_AUDIT_ID INTEGER 4
18 UPDATE_RUN_AUDIT_ID INTEGER 4
19 CURRENT_BALANCE NUMERIC(14,2) 19
20 CAPTIAL_BALANCE NUMERIC(14,2) 19
21 BALANCE NUMERIC(37,2) 19
22 TOTAL_GUARANTEE_VALUE NUMERIC(38,2) 19
23 AVERAGE_MONTHLY_BALANCE NUMERIC(14,2) 19
24 TOTAL_UNRECOVERED_COSTS NUMERIC(14,2) 19
25 ARREARS_0_1_MONTH_AMOUNT NUMERIC(14,2) 19
26 ARREARS_1_2_MONTH_AMOUNT NUMERIC(14,2) 19
27 ARREARS_2_3_MONTH_AMOUNT NUMERIC(14,2) 19
28 ARREARS_3_4_MONTH_AMOUNT NUMERIC(14,2) 19
29 ARREARS_4_5_MONTH_AMOUNT NUMERIC(14,2) 19
30 ARREARS_5_6_MONTH_AMOUNT NUMERIC(14,2) 19
31 ARREARS_6_PLUS_MONTH_AMOUNT NUMERIC(14,2) 19
32 TOTAL_ARREARS_AMOUNT DOUBLE PRECISION 8
33 OLDEST_ARREARS_GRADING_CODE INTEGER 4
34 PRINCIPLE_LIMIT DOUBLE PRECISION 8
35 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
36 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
37 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
38 OF_COST_CENTRE_SID BIGINT 8
39 OF_ENTITY_SID BIGINT 8
40 OF_ACCOUNT_SID BIGINT 8
41 OF_CATEGORY_SID BIGINT 8
42 OF_PRODUCT_SID BIGINT 8
43 OF_INTERCOMPANY_SID BIGINT 8
44 UNDRAWN_AMOUNT DOUBLE PRECISION 8
45 INT_INCOME_ACCRUED_CTD DOUBLE PRECISION 8
46 INT_INCOME_MOVEMENT_MTD NUMERIC(23,8) 19
47 INT_INCOME_TOTAL_MTD NUMERIC(23,8) 19
48 INT_EXPENSE_ACCRUED_CTD NUMERIC(23,8) 19
49 INT_EXPENSE_MOVEMENT_MTD NUMERIC(23,8) 19
50 INT_EXPENSE_TOTAL_MTD NUMERIC(23,8) 19
51 INBA_AMOUNT NUMERIC(14,2) 19
52 DEBIT_INT_RATE DOUBLE PRECISION 8
53 CREDIT_INT_RATE NUMERIC(8,5) 19
54 AVAILABLE_REDRAW_BALANCE DOUBLE PRECISION 8
55 OFFSET_FACILITY_BALANCE DOUBLE PRECISION 8
56 UNEARNED_INT_MTD DOUBLE PRECISION 8
57 DRAWN_AMOUNT_LTD DOUBLE PRECISION 8
58 UNAPPLIED_FUND_AMOUNT DOUBLE PRECISION 8
59 TERM_DEP_ACT_INT_EXP_ACR_CTD NUMERIC(14,2) 19
60 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
61 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
62 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
63 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
64 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8