INT_PERIOD_GROWTH_IN_PORTFOLIO

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_PERIOD_GROWTH_IN_PORTFOLIO_V

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 PERIOD_TYPE_DIM_ID BIGINT 8
3 ACCOUNT_DIM_ID BIGINT 8
4 SOURCE_PRODUCT_DIM_ID BIGINT 8
5 BRANCH_DIM_ID BIGINT 8
6 ACCOUNT_STATUS_DIM_ID BIGINT 8
7 SOURCE_PRODUCT_CODE CHARACTER VARYING(71) 71
8 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
9 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
10 SALES_MEASURES_DIM_ID BIGINT 8
11 CPR_MEASURES_DIM_ID BIGINT 8
12 SOURCE_PRODUCT_LVLS_DIM_ID BIGINT 8
13 PERS_INV_USG_TP_SUMM_DIM_ID BIGINT 8
14 OF_COST_CENTRE_SID BIGINT 8
15 OF_ENTITY_SID BIGINT 8
16 OF_ACCOUNT_SID BIGINT 8
17 OF_CATEGORY_SID BIGINT 8
18 OF_PRODUCT_SID BIGINT 8
19 OF_INTERCOMPANY_SID BIGINT 8
20 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
21 GL_PRODUCT_DIM_ID BIGINT 8
22 GL_ACCOUNT_DIM_ID BIGINT 8
23 COST_CENTRE_DIM_ID BIGINT 8
24 SALES_MEASURE_CODE CHARACTER VARYING(19) 19
25 SALES_MEASURE_SUB_CODE CHARACTER VARYING(1) 1
26 PORTFOLIO_BALANCE DOUBLE PRECISION 8
27 PORTFOLIO_COUNT INTEGER 4
28 START_WEEK_BALANCE DOUBLE PRECISION 8
29 START_MONTH_BALANCE DOUBLE PRECISION 8
30 START_QUARTER_BALANCE DOUBLE PRECISION 8
31 START_FINYR_BALANCE DOUBLE PRECISION 8
32 GROWTH_WEEK_BALANCE DOUBLE PRECISION 8
33 GROWTH_WEEK_COUNT INTEGER 4
34 GROWTH_MONTH_BALANCE DOUBLE PRECISION 8
35 GROWTH_MONTH_COUNT INTEGER 4
36 GROWTH_QUARTER_BALANCE DOUBLE PRECISION 8
37 GROWTH_QUARTER_COUNT INTEGER 4
38 GROWTH_FINYR_BALANCE DOUBLE PRECISION 8
39 GROWTH_FINYR_COUNT INTEGER 4
40 PIT_SRC CHARACTER VARYING(10) 10
41 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
42 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
43 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
44 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8