INT_PORTFOLIO_PERIOD_DAILY

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_PORTFOLIO_PERIOD_DAILY_V

Columns
# Name Data Type Length
1 OPENING_PERIOD_DIM_ID BIGINT 8
2 CLOSING_PERIOD_DIM_ID BIGINT 8
3 PIT_SRC CHARACTER VARYING(10) 10
4 PERIOD_TYPE_DIM_ID BIGINT 8
5 OPENING_PERIOD_DT TIMESTAMP 8
6 CLOSING_PERIOD_DT TIMESTAMP 8
7 ACCOUNT_DIM_ID BIGINT 8
8 OPENING_ACCOUNT_STATUS_DIM_ID BIGINT 8
9 CLOSING_ACCOUNT_STATUS_DIM_ID BIGINT 8
10 OPENING_ACCOUNT_STATUS_CODE CHARACTER VARYING(24) 24
11 CLOSING_ACCOUNT_STATUS_CODE CHARACTER VARYING(24) 24
12 DATE_OPEN TIMESTAMP 8
13 DATE_CLOSED TIMESTAMP 8
14 OPENING_BALANCE DOUBLE PRECISION 8
15 CLOSING_BALANCE DOUBLE PRECISION 8
16 DIFF_BALANCE DOUBLE PRECISION 8
17 OPENING_SOURCE_PRODUCT_CODE CHARACTER VARYING(104) 104
18 CLOSING_SOURCE_PRODUCT_CODE CHARACTER VARYING(104) 104
19 OPENING_BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
20 CLOSING_BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
21 OPENING_SOURCE_PRODUCT_DIM_ID BIGINT 8
22 CLOSING_SOURCE_PRODUCT_DIM_ID BIGINT 8
23 OPENING_PERS_INV_USAGE_DIM_ID BIGINT 8
24 CLOSING_PERS_INV_USAGE_DIM_ID BIGINT 8
25 OPENING_BRANCH_DIM_ID BIGINT 8
26 CLOSING_BRANCH_DIM_ID BIGINT 8
27 OPENING_COST_CENTRE_DIM_ID BIGINT 8
28 CLOSING_COST_CENTRE_DIM_ID BIGINT 8
29 CC_MOVEMENT CHARACTER VARYING(6) 6
30 OPENING_CC_MOVEMENT CHARACTER VARYING(6) 6
31 CLOSING_CC_MOVEMENT CHARACTER VARYING(6) 6
32 OPENING_GL_ACCOUNT_DIM_ID BIGINT 8
33 CLOSING_GL_ACCOUNT_DIM_ID BIGINT 8
34 OPENING_GL_BUSINESS_UNIT_DIM_ID BIGINT 8
35 CLOSING_GL_BUSINESS_UNIT_DIM_ID BIGINT 8
36 OPENING_GL_PRODUCT_DIM_ID BIGINT 8
37 CLOSING_GL_PRODUCT_DIM_ID BIGINT 8
38 GL_PRODUCT_MOVEMENT CHARACTER VARYING(6) 6
39 OPENING_GL_PRODUCT_MOVEMENT CHARACTER VARYING(6) 6
40 CLOSING_GL_PRODUCT_MOVEMENT CHARACTER VARYING(6) 6
41 OF_PRODUCT_MOVEMENT CHARACTER VARYING(6) 6
42 SOURCE_PRODUCT_DIM_ID_MOVEMENT CHARACTER VARYING(6) 6
43 PERS_INV_USAGE_DIM_ID_MOVEMENT CHARACTER VARYING(6) 6
44 SOURCE_PRODUCT_CODE_MOVEMENT CHARACTER VARYING(6) 6
45 OPENING_OF_ACCOUNT_SID BIGINT 8
46 CLOSING_OF_ACCOUNT_SID BIGINT 8
47 OPENING_OF_CATEGORY_SID BIGINT 8
48 CLOSING_OF_CATEGORY_SID BIGINT 8
49 OPENING_OF_COST_CENTRE_SID BIGINT 8
50 CLOSING_OF_COST_CENTRE_SID BIGINT 8
51 OPENING_OF_ENTITY_SID BIGINT 8
52 CLOSING_OF_ENTITY_SID BIGINT 8
53 OPENING_OF_INTERCOMPANY_SID BIGINT 8
54 CLOSING_OF_INTERCOMPANY_SID BIGINT 8
55 OPENING_OF_PRODUCT_SID BIGINT 8
56 CLOSING_OF_PRODUCT_SID BIGINT 8
57 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
58 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
59 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
60 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8