SDW_TSDMF_TRSR_DEP_LOANS_PIT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 DEAL_DIM_ID BIGINT 8
3 TRSR_ACCOUNT_DIM_ID BIGINT 8
4 SOURCE_PRODUCT_DIM_ID BIGINT 8
5 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
6 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
7 ORIG_TERM_MATURITY_DIM_ID BIGINT 8
8 RSDL_TERM_MATURITY_DIM_ID BIGINT 8
9 SOURCE_CURRENCY_DIMENSION_ID BIGINT 8
10 GCIS_CUSTOMER_DIM_ID BIGINT 8
11 CUSTOMER_DIM_ID BIGINT 8
12 CUST_CLASSIFIER_DIM_ID BIGINT 8
13 ANZSIC_DIM_ID BIGINT 8
14 CUSTOMER_ADDRESS_DIM_ID BIGINT 8
15 COUNTERPARTY_TYPE_DIM_ID BIGINT 8
16 OF_GL_INT_ACCRUED_DIM_ID NUMERIC(19,0) 19
17 OF_GL_PRINCIPAL_AMOUNT_DIM_ID NUMERIC(19,0) 19
18 OPEN_PERIOD_DIM_ID BIGINT 8
19 ESTIMATED_CLOSE_PERIOD_DIM_ID BIGINT 8
20 REVERSE_PERIOD_DIM_ID BIGINT 8
21 INT_START_PERIOD_DIM_ID BIGINT 8
22 INT_END_PERIOD_DIM_ID BIGINT 8
23 CREDIT_CNVR_FCTR_DIM_ID BIGINT 8
24 CUST_X_PROD_BNK_RLTNP_DIM_ID BIGINT 8
25 PRINCIPAL_AMOUNT NUMERIC(23,8) 19
26 INT_ACCRUED_AMOUNT NUMERIC(23,8) 19
27 INTEREST_RATE_DIM_ID BIGINT 8
28 MATERIALITY_DIM_ID BIGINT 8
29 OF_GL_INT_INCOME_MVMT_DIM_ID BIGINT 8
30 OF_GL_INT_EXPENSE_MVMT_DIM_ID BIGINT 8
31 INT_INCOME_MOVEMENT_MTD NUMERIC(23,8) 19
32 INT_EXPENSE_MOVEMENT_MTD NUMERIC(23,8) 19
33 PROFIT_AND_LOSS_SPLIT_RATIO NUMERIC(23,8) 19
34 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
35 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
36 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
37 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8