SDW_TSDMF_TRSR_DERIV_PIT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DEAL_DIM_ID BIGINT 8
2 TRSR_INSTRUMENT_DIM_ID BIGINT 8
3 PERIOD_DIM_ID BIGINT 8
4 SOURCE_PRODUCT_DIM_ID BIGINT 8
5 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
6 ORIG_TERM_MATURITY_DIM_ID BIGINT 8
7 RSDL_TERM_MATURITY_DIM_ID BIGINT 8
8 SOURCE_CURRENCY_DIMENSION_ID BIGINT 8
9 GCIS_CUSTOMER_DIM_ID BIGINT 8
10 CUSTOMER_DIM_ID BIGINT 8
11 CUSTOMER_ADDRESS_DIM_ID BIGINT 8
12 CUST_CLASSIFIER_DIM_ID BIGINT 8
13 ANZSIC_DIM_ID BIGINT 8
14 COUNTERPARTY_TYPE_DIM_ID BIGINT 8
15 OPEN_PERIOD_DIM_ID BIGINT 8
16 ESTIMATED_CLOSE_PERIOD_DIM_ID BIGINT 8
17 REVERSE_PERIOD_DIM_ID BIGINT 8
18 SETTLED_PERIOD_DIM_ID BIGINT 8
19 INT_START_PERIOD_DIM_ID BIGINT 8
20 INT_END_PERIOD_DIM_ID BIGINT 8
21 RATE_FIX_PERIOD_DIM_ID BIGINT 8
22 EXERCISED_PERIOD_DIM_ID BIGINT 8
23 OF_GL_MARK_TO_MARKET_DIM_ID BIGINT 8
24 OF_GL_UNAMORT_SETTLED_DIM_ID BIGINT 8
25 OF_GL_UNREALISED_PL_DIM_ID BIGINT 8
26 OF_GL_REALISED_PL_DIM_ID BIGINT 8
27 OF_GL_INT_ACCRUED_DIM_ID BIGINT 8
28 OF_GL_INT_PAID_RECEIVED_DIM_ID BIGINT 8
29 OF_GL_PREMIUM_DIM_ID BIGINT 8
30 CREDIT_CNVR_FCTR_DIM_ID BIGINT 8
31 NOTIONAL_AMOUNT NUMERIC(23,8) 19
32 MARK_TO_MARKET_AMOUNT NUMERIC(23,8) 19
33 UNAMORTISED_SETTLED_AMOUNT NUMERIC(23,8) 19
34 UNREALISED_PL_AMOUNT NUMERIC(23,8) 19
35 REALISED_PL_AMOUNT NUMERIC(23,8) 19
36 INT_ACCRUED NUMERIC(23,8) 19
37 INT_PAID_RECEIVED NUMERIC(23,8) 19
38 MARK_TO_MARKET_EXCL_INT_ACR NUMERIC(23,8) 19
39 DIRTY_MARK_TO_MARKET_AMOUNT NUMERIC(23,8) 19
40 PREMIUM_AMOUNT NUMERIC(23,8) 19
41 MARK_TO_MARKET_INCL_PREMIUM NUMERIC(23,8) 19
42 CUST_X_PROD_BNK_RLTNP_DIM_ID BIGINT 8
43 INT_ACCRUED_MVMT_MTD NUMERIC(23,8) 19
44 OF_GL_AMRZ_TMT_FEE_DIM_ID BIGINT 8
45 OF_GL_AMRZ_FEE_MVMT_DIM_ID BIGINT 8
46 OF_GL_ACCRETION_FEE_DIM_ID BIGINT 8
47 ACCRETION_FEE_MVMT_MTD NUMERIC(23,8) 19
48 AMRZ_FEE_MVMT_MTD NUMERIC(23,8) 19
49 AMRZ_TERMINATION_FEE_AMOUNT NUMERIC(23,8) 19
50 BALANCING_ADJUSTMENT_AMOUNT NUMERIC(23,8) 19
51 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
52 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
53 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
54 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8