FCT_OBP_PORTFOLIO_PIT_TD

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_PORTFOLIO_PIT_TD_V

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