FCT_OBP_PORTFOLIO_PIT_MIGRATED_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 ACCOUNT_DIM_ID BIGINT 8
3 PERIOD_TYPE_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(104) 104
8 BALANCE_SHEET_INDICATOR CHARACTER VARYING(5) 5
9 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
10 OF_COST_CENTRE_SID BIGINT 8
11 OF_ENTITY_SID BIGINT 8
12 OF_ACCOUNT_SID BIGINT 8
13 OF_CATEGORY_SID BIGINT 8
14 OF_PRODUCT_SID BIGINT 8
15 OF_INTERCOMPANY_SID BIGINT 8
16 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
17 GL_PRODUCT_DIM_ID BIGINT 8
18 GL_ACCOUNT_DIM_ID BIGINT 8
19 COST_CENTRE_DIM_ID BIGINT 8
20 BALANCE NUMERIC(14,2) 19
21 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
22 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8