SDW_TSDMF_TRSR_FIX_INCM_PIT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 TRSR_SECURITY_DIM_ID BIGINT 8
3 OF_GL_MKT_INCL_INT_ACR_DIM_ID BIGINT 8
4 OF_GL_INT_ACCRUED_DIM_ID BIGINT 8
5 OF_GL_UNAMORT_DIM_ID BIGINT 8
6 OF_GL_PNP_EXCL_UNAMORT_DIM_ID BIGINT 8
7 OF_GL_MARK_TO_MARKET_DIM_ID BIGINT 8
8 OF_GL_PNP_INCL_INT_ACR_DIM_ID BIGINT 8
9 OF_GL_ACCRUED_DISCNT_DIM_ID BIGINT 8
10 OPEN_PERIOD_DIM_ID BIGINT 8
11 MATURITY_PERIOD_DIM_ID BIGINT 8
12 INT_START_PERIOD_DIM_ID BIGINT 8
13 INT_END_PERIOD_DIM_ID BIGINT 8
14 ORIG_TERM_MATURITY_DIM_ID BIGINT 8
15 RSDL_TERM_MATURITY_DIM_ID BIGINT 8
16 GCIS_CUSTOMER_DIM_ID BIGINT 8
17 ISS_GCIS_CUSTOMER_DIM_ID BIGINT 8
18 CUSTOMER_DIM_ID BIGINT 8
19 ISS_CUSTOMER_DIM_ID BIGINT 8
20 CUST_CLASSIFIER_DIM_ID BIGINT 8
21 ISS_CUST_CLASSIFIER_DIM_ID BIGINT 8
22 CUSTOMER_ADDRESS_DIM_ID BIGINT 8
23 ISS_CUSTOMER_ADDRESS_DIM_ID BIGINT 8
24 COUNTERPARTY_TYPE_DIM_ID BIGINT 8
25 ISS_COUNTERPARTY_TYPE_DIM_ID BIGINT 8
26 ANZSIC_DIM_ID BIGINT 8
27 ISS_ANZSIC_DIM_ID BIGINT 8
28 SOURCE_CURRENCY_DIMENSION_ID BIGINT 8
29 CREDIT_CNVR_FCTR_DIM_ID BIGINT 8
30 SOURCE_PRODUCT_DIM_ID BIGINT 8
31 CUST_X_PROD_BNK_RLTNP_DIM_ID BIGINT 8
32 ISS_CUST_X_PD_BNK_RLTNP_DIM_ID BIGINT 8
33 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
34 PRINCIPAL_AMOUNT NUMERIC(23,8) 19
35 MARKET_VALUE NUMERIC(23,8) 19
36 BOOK_VALUE NUMERIC(23,8) 19
37 UNAMORT_AMOUNT NUMERIC(23,8) 19
38 MARK_TO_MARKET_AMOUNT NUMERIC(23,8) 19
39 INT_ACCRUED_AMOUNT NUMERIC(23,8) 19
40 ACCRUED_DISCNT_AMOUNT NUMERIC(23,8) 19
41 MARKET_VALUE_INCL_INT_ACR NUMERIC(23,8) 19
42 PRINCIPAL_AMT_EXCL_UNAMORT NUMERIC(23,8) 19
43 PRINCIPAL_AMOUNT_INCL_INT_ACR NUMERIC(23,8) 19
44 DEAL_DIM_ID BIGINT 8
45 OF_GL_PRINCIPAL_AMOUNT_DIM_ID BIGINT 8
46 OF_GL_INT_INCOME_MVMT_DIM_ID BIGINT 8
47 OF_GL_INT_EXPENSE_MVMT_DIM_ID BIGINT 8
48 OF_GL_INT_EXPN_MVMT_GNT_DIM_ID BIGINT 8
49 OF_GL_SHRT_TERM_FUNDING_DIM_ID BIGINT 8
50 OF_GL_LONG_TERM_FUNDING_DIM_ID BIGINT 8
51 INT_INCOME_MOVEMENT_MTD NUMERIC(23,8) 19
52 INT_EXPENSE_MOVEMENT_MTD NUMERIC(23,8) 19
53 INT_EXPENSE_MOVEMENT_GNT_MTD NUMERIC(23,8) 19
54 SHORT_TERM_FUNDING_MTD NUMERIC(23,8) 19
55 LONG_TERM_FUNDING_MTD NUMERIC(23,8) 19
56 PROFIT_AND_LOSS_SPLIT_RATIO NUMERIC(15,5) 19
57 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
58 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
59 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
60 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8