FCT_OBP_ACCOUNT_BALANCE_PIT_CS

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_ACCOUNT_BALANCE_PIT_CS_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_PRODUCT_SID BIGINT 8
20 OF_ACCOUNT_SID BIGINT 8
21 OF_CATEGORY_SID BIGINT 8
22 OF_INTERCOMPANY_SID BIGINT 8
23 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
24 INSERT_RUN_AUDIT_ID INTEGER 4
25 UPDATE_RUN_AUDIT_ID INTEGER 4
26 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
27 SOURCE_PRODUCT_CODE CHARACTER VARYING(71) 71
28 CURRENT_BALANCE CHARACTER VARYING(1) 1
29 CAPTIAL_BALANCE CHARACTER VARYING(1) 1
30 BALANCE DOUBLE PRECISION 8
31 ALT_AC_CREDIT_INT DOUBLE PRECISION 8
32 ALT_AC_DEBIT_INT DOUBLE PRECISION 8
33 TOTAL_GUARANTEE_VALUE CHARACTER VARYING(1) 1
34 AVERAGE_MONTHLY_BALANCE CHARACTER VARYING(1) 1
35 TOTAL_UNRECOVERED_COSTS CHARACTER VARYING(1) 1
36 ARREARS_0_1_MONTH_AMOUNT CHARACTER VARYING(1) 1
37 ARREARS_1_2_MONTH_AMOUNT CHARACTER VARYING(1) 1
38 ARREARS_2_3_MONTH_AMOUNT CHARACTER VARYING(1) 1
39 ARREARS_3_4_MONTH_AMOUNT CHARACTER VARYING(1) 1
40 ARREARS_4_5_MONTH_AMOUNT CHARACTER VARYING(1) 1
41 ARREARS_5_6_MONTH_AMOUNT CHARACTER VARYING(1) 1
42 ARREARS_6_PLUS_MONTH_AMOUNT CHARACTER VARYING(1) 1
43 TOTAL_ARREARS_AMOUNT CHARACTER VARYING(1) 1
44 OLDEST_ARREARS_GRADING_CODE CHARACTER VARYING(1) 1
45 PRINCIPLE_LIMIT CHARACTER VARYING(1) 1
46 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
47 INTEREST_RATE_TYPE CHARACTER VARYING(5) 5
48 UNDRAWN_AMOUNT DOUBLE PRECISION 8
49 INT_INCOME_ACCRUED_CTD DOUBLE PRECISION 8
50 INT_INCOME_MOVEMENT_MTD DOUBLE PRECISION 8
51 INT_INCOME_TOTAL_MTD DOUBLE PRECISION 8
52 INT_EXPENSE_ACCRUED_CTD DOUBLE PRECISION 8
53 INT_EXPENSE_MOVEMENT_MTD DOUBLE PRECISION 8
54 INT_EXPENSE_TOTAL_MTD DOUBLE PRECISION 8
55 INBA_AMOUNT CHARACTER VARYING(1) 1
56 DB_INT_PAY_CYCLE_CD CHARACTER VARYING(10) 10
57 DB_AMT_INT_ACC_CTD DOUBLE PRECISION 8
58 INT_PAY_CYCLE_CD CHARACTER VARYING(10) 10
59 DEBIT_INT_RATE DOUBLE PRECISION 8
60 CREDIT_INT_RATE DOUBLE PRECISION 8
61 AVAILABLE_REDRAW_BALANCE CHARACTER VARYING(1) 1
62 OFFSET_FACILITY_BALANCE CHARACTER VARYING(1) 1
63 UNEARNED_INT_MTD CHARACTER VARYING(1) 1
64 DRAWN_AMOUNT_LTD CHARACTER VARYING(1) 1
65 UNAPPLIED_FUND_AMOUNT CHARACTER VARYING(1) 1
66 TERM_DEP_ACT_INT_EXP_ACR_CTD CHARACTER VARYING(1) 1
67 PRODUCT_CODE CHARACTER VARYING(30) 30
68 OFFER_ID CHARACTER VARYING(40) 40
69 APPLN_REQ_TYPE CHARACTER VARYING(1) 1
70 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
71 PRODUCT_HOLDING_NUMBER CHARACTER VARYING(40) 40
72 BUSINESS_DEVELOPMENT_MANAGER CHARACTER VARYING(40) 40
73 GL_BUSINESS_UNIT INTEGER 4
74 GL_PRODUCT CHARACTER VARYING(24) 24
75 GL_ACCOUNT CHARACTER VARYING(6) 6
76 COST_CENTRE_CODE CHARACTER VARYING(150) 150
77 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
78 ACCOUNT_STATUS_CODE CHARACTER VARYING(20) 20
79 OF_COST_CENTRE_CODE CHARACTER VARYING(240) 240
80 OF_ENTITY_CODE CHARACTER VARYING(150) 150
81 OF_PRODUCT_CODE CHARACTER VARYING(240) 240
82 OF_ACCOUNT_CODE CHARACTER VARYING(240) 240
83 OF_CATEGORY_CODE CHARACTER VARYING(240) 240
84 OF_INTERCOMPANY_CODE CHARACTER VARYING(240) 240
85 PRODUCT_GROUP_CODE CHARACTER VARYING(20) 20
86 CURRENT_BALANCE_EFFECTIVE_DATE TIMESTAMP 8
87 CURRENT_CLEAR_AMOUNT DOUBLE PRECISION 8
88 FUTURE_CLEAR_AMOUNT DOUBLE PRECISION 8
89 CURRENT_UNCLEAR_AMOUNT DOUBLE PRECISION 8
90 FUTURE_UNCLEAR_AMOUNT DOUBLE PRECISION 8
91 CURRENT_UTILIZED_OVERDRAFT_AMOUNT DOUBLE PRECISION 8
92 FUTURE_UTILIZED_OVERDRAFT_AMOUNT DOUBLE PRECISION 8
93 CURRENT_OVERLINE_AMOUNT DOUBLE PRECISION 8
94 FUTURE_OVERLINE_AMOUNT DOUBLE PRECISION 8
95 CURRENT_TEMP_OVERDRAFT_AMOUNT DOUBLE PRECISION 8
96 FUTURE_TEMP_OVERDRAFT_AMOUNT DOUBLE PRECISION 8
97 CURRENT_TD_LIEN_AMOUNT DOUBLE PRECISION 8
98 FUTURE_TD_LIEN_AMOUNT DOUBLE PRECISION 8
99 CURRENT_UTILIZED_AUF_LIMIT_AMOUNT DOUBLE PRECISION 8
100 FUTURE_UTILIZED_AUF_LIMIT_AMOUNT DOUBLE PRECISION 8
101 TEMP_EXCESS_UTILIZED_AMT DOUBLE PRECISION 8
102 FUTURE_TEMPORARY_EXCESS_AMT DOUBLE PRECISION 8
103 CURRENT_USER_HOLD_AMOUNT DOUBLE PRECISION 8
104 CURRENT_SYSTEM_HOLD_AMOUNT DOUBLE PRECISION 8
105 PERIODIC_FEE_AMOUNT DOUBLE PRECISION 8
106 CURRENT_ARR_INTEREST_TODAY DOUBLE PRECISION 8
107 CURRENT_ARR_FEES_TODAY DOUBLE PRECISION 8
108 CURRENT_ARR_PRINC_TODAY DOUBLE PRECISION 8
109 OD_LIMIT_AMOUNT DOUBLE PRECISION 8
110 CURR_AUF_LIMIT_AMT DOUBLE PRECISION 8
111 CURR_OD_LIMIT_AMT DOUBLE PRECISION 8
112 CURR_TE_LIMIT_AMT DOUBLE PRECISION 8
113 TOTAL_OFFSET_CLEAR_AMOUNT DOUBLE PRECISION 8
114 TOTAL_OFFSET_UNCLEAR_AMOUNT DOUBLE PRECISION 8
115 OD_INT_RATE DOUBLE PRECISION 8
116 TOD_INT_RATE DOUBLE PRECISION 8
117 AUF_INT_RATE DOUBLE PRECISION 8
118 OL_INT_RATE DOUBLE PRECISION 8
119 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
120 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
121 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
122 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
123 PARTY_CODE CHARACTER VARYING(40) 40