SDW_TSDSD_PERIOD_MAT_TERM_DEP

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..UBAR_SDW_TSDSD_PERIOD_MAT_TERM_DEP

SDSNZP05_BANK..CBP_SDW_TSDSD_PERIOD_MAT_TERM_DEP

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 MONTH_START_ID BIGINT 8
3 MONTH_END_ID BIGINT 8
4 QUARTER_START_ID BIGINT 8
5 QUARTER_END_ID BIGINT 8
6 FINANCIAL_START_ID BIGINT 8
7 FINANCIAL_END_ID BIGINT 8
8 DAY_OF_CALENDAR_YEAR NUMERIC(38,0) 19
9 DAY_OF_FINANCIAL_YEAR NUMERIC(38,0) 19
10 DAYS_IN_MONTH NUMERIC(38,0) 19
11 DAYS_IN_QUARTER NUMERIC(38,0) 19
12 DAYS_IN_CALENDAR_YEAR NUMERIC(38,0) 19
13 DAYS_IN_FINANCIAL_YEAR NUMERIC(38,0) 19
14 CALENDAR_MONTH_NUMBER NUMERIC(38,0) 19
15 FINANCIAL_MONTH_NUMBER NUMERIC(38,0) 19
16 CALENDAR_QUARTER_NUMBER CHARACTER VARYING(18) 18
17 FINANCIAL_QUARTER_NUMBER NUMERIC(38,0) 19
18 CALENDAR_YEAR_NUMBER NUMERIC(38,0) 19
19 FINANCIAL_YEAR_NUMBER NUMERIC(38,0) 19
20 MONTH_NAME CHARACTER VARYING(9) 9
21 MONTH_START_DT TIMESTAMP 8
22 MONTH_END_DT TIMESTAMP 8
23 QUARTER_START_DT TIMESTAMP 8
24 QUARTER_END_DT TIMESTAMP 8
25 FINANCIAL_START_DT TIMESTAMP 8
26 FINANCIAL_END_DT TIMESTAMP 8
27 FINANCIAL_YEAR_END_FLAG CHARACTER VARYING(1) 1
28 QUARTER_END_FLAG CHARACTER VARYING(1) 1
29 FINANCIAL_YEAR_SPAN CHARACTER VARYING(7) 7
30 FINANCIAL_MONTH_YEAR CHARACTER VARYING(6) 6
31 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
32 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
33 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
34 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8