FCT_OBP_ACCOUNT_BALANCE_PIT_TD

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_ACCOUNT_BALANCE_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 DEPOSIT_STATUS_DIM_ID BIGINT 8
18 OF_COST_CENTRE_SID BIGINT 8
19 OF_ENTITY_SID BIGINT 8
20 OF_PRODUCT_SID BIGINT 8
21 OF_ACCOUNT_SID BIGINT 8
22 OF_CATEGORY_SID BIGINT 8
23 OF_INTERCOMPANY_SID BIGINT 8
24 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
25 INSERT_RUN_AUDIT_ID INTEGER 4
26 UPDATE_RUN_AUDIT_ID INTEGER 4
27 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
28 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
29 DEPOSIT_NUMBER DOUBLE PRECISION 8
30 VALUE_DATE TIMESTAMP 8
31 PRODUCT_HOLDING_NUMBER CHARACTER VARYING(40) 40
32 SOURCE_PRODUCT_CODE CHARACTER VARYING(61) 61
33 BUSINESS_DEVELOPMENT_MANAGER CHARACTER VARYING(254) 254
34 GL_BUSINESS_UNIT INTEGER 4
35 GL_PRODUCT CHARACTER VARYING(24) 24
36 GL_ACCOUNT CHARACTER VARYING(6) 6
37 COST_CENTRE_CODE CHARACTER VARYING(150) 150
38 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
39 ACCOUNT_STATUS_CODE CHARACTER VARYING(40) 40
40 DEPOSIT_STATUS_CODE CHARACTER VARYING(40) 40
41 OF_COST_CENTRE_CODE CHARACTER VARYING(240) 240
42 OF_ENTITY_CODE CHARACTER VARYING(150) 150
43 OF_PRODUCT_CODE CHARACTER VARYING(240) 240
44 OF_ACCOUNT_CODE CHARACTER VARYING(240) 240
45 OF_CATEGORY_CODE CHARACTER VARYING(240) 240
46 OF_INTERCOMPANY_CODE CHARACTER VARYING(240) 240
47 CREDIT_INT_RATE DOUBLE PRECISION 8
48 MATURITY_DATE TIMESTAMP 8
49 NEXT_INT_PAYOUT_DATE TIMESTAMP 8
50 TERM_MONTHS DOUBLE PRECISION 8
51 BROKER_ID CHARACTER VARYING(1) 1
52 CURRENT_BALANCE DOUBLE PRECISION 8
53 CAPTIAL_BALANCE NUMERIC(1,0) 19
54 BALANCE DOUBLE PRECISION 8
55 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
56 INTEREST_RATE_TYPE CHARACTER VARYING(5) 5
57 INBA_AMOUNT DOUBLE PRECISION 8
58 INT_EXPENSE_ACCRUED_CTD DOUBLE PRECISION 8
59 INT_EXPENSE_MOVEMENT_MTD DOUBLE PRECISION 8
60 INT_EXPENSE_TOTAL_MTD DOUBLE PRECISION 8
61 TERM_DEP_ACT_INT_EXP_ACR_CTD DOUBLE PRECISION 8
62 RENEWAL_COUNTER DOUBLE PRECISION 8
63 PRINCIPAL_AMT DOUBLE PRECISION 8
64 MATURITY_AMT DOUBLE PRECISION 8
65 CLOSEOUT_AMT DOUBLE PRECISION 8
66 UNCOLLECTED_PRINCIPAL_AMT DOUBLE PRECISION 8
67 UNCOLLECTED_INT_AMT DOUBLE PRECISION 8
68 UNCLAIMED_PRINCIPAL_AMT DOUBLE PRECISION 8
69 UNCLAIMED_INT_AMT DOUBLE PRECISION 8
70 INT_WITHHELD_AMT DOUBLE PRECISION 8
71 TOTAL_INT_WITHHELD_AMT DOUBLE PRECISION 8
72 PRINCIPAL_DUE_AMT DOUBLE PRECISION 8
73 INT_DUE_AMT DOUBLE PRECISION 8
74 LIEN_PRINCIPAL_AMT DOUBLE PRECISION 8
75 LIEN_INTEREST_AMT DOUBLE PRECISION 8
76 OLDEST_ARREARS_GRADING_CODE INTEGER 4
77 UNDRAWN_AMOUNT INTEGER 4
78 INT_INCOME_ACCRUED_CTD DOUBLE PRECISION 8
79 INT_INCOME_MOVEMENT_MTD NUMERIC(1,0) 19
80 INT_INCOME_TOTAL_MTD NUMERIC(1,0) 19
81 DEBIT_INT_RATE DOUBLE PRECISION 8
82 AVAILABLE_REDRAW_BALANCE INTEGER 4
83 OFFSET_FACILITY_BALANCE DOUBLE PRECISION 8
84 UNEARNED_INT_MTD DOUBLE PRECISION 8
85 DRAWN_AMOUNT_LTD DOUBLE PRECISION 8
86 UNAPPLIED_FUND_AMOUNT DOUBLE PRECISION 8
87 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
88 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
89 CDC_COMMIT_TIMESTAMP DATE 4
90 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
91 PRODUCT_CODE CHARACTER VARYING(30) 30
92 OFFER_ID CHARACTER VARYING(30) 30
93 BASE_RATE DOUBLE PRECISION 8
94 ACCT_UDM_RATE DOUBLE PRECISION 8
95 CR_INT_EXP_ACCR_CTD DOUBLE PRECISION 8
96 ACCR_STAT_AMT_ACCR_MTD DOUBLE PRECISION 8
97 TOTAL_GUARANTEE_VALUE NUMERIC(1,0) 19
98 AVERAGE_MONTHLY_BALANCE NUMERIC(1,0) 19
99 TOTAL_UNRECOVERED_COSTS NUMERIC(1,0) 19
100 ARREARS_0_1_MONTH_AMOUNT NUMERIC(1,0) 19
101 ARREARS_1_2_MONTH_AMOUNT NUMERIC(1,0) 19
102 ARREARS_2_3_MONTH_AMOUNT NUMERIC(1,0) 19
103 ARREARS_3_4_MONTH_AMOUNT NUMERIC(1,0) 19
104 ARREARS_4_5_MONTH_AMOUNT NUMERIC(1,0) 19
105 ARREARS_5_6_MONTH_AMOUNT NUMERIC(1,0) 19
106 ARREARS_6_PLUS_MONTH_AMOUNT NUMERIC(1,0) 19
107 TOTAL_ARREARS_AMOUNT DOUBLE PRECISION 8
108 PRINCIPLE_LIMIT DOUBLE PRECISION 8