SDW_TSDSD_PERIOD_WEEK

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..UBAR_SDW_TSDSD_PERIOD_WEEK

SDSNZP05_BANK..CBP_SDW_TSDSD_PERIOD_WEEK

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 WEEK_START_ID BIGINT 8
3 WEEK_END_ID BIGINT 8
4 FINANCIAL_START_ID BIGINT 8
5 FINANCIAL_END_ID BIGINT 8
6 DAY_OF_CALENDAR_YEAR INTEGER 4
7 DAY_OF_FINANCIAL_YEAR INTEGER 4
8 DAYS_IN_CALENDAR_YEAR INTEGER 4
9 DAYS_IN_FINANCIAL_YEAR INTEGER 4
10 CALENDAR_WEEK_NUMBER INTEGER 4
11 FINANCIAL_WEEK_NUMBER INTEGER 4
12 CALENDAR_YEAR_NUMBER INTEGER 4
13 FINANCIAL_YEAR_NUMBER INTEGER 4
14 DAY_NAME CHARACTER VARYING(9) 9
15 MONTH_NAME CHARACTER VARYING(9) 9
16 MONTH_END_FLAG CHARACTER VARYING(1) 1
17 WEEK_START_DT TIMESTAMP 8
18 WEEK_END_DT TIMESTAMP 8
19 FINANCIAL_START_DT TIMESTAMP 8
20 FINANCIAL_END_DT TIMESTAMP 8
21 FINANCIAL_YEAR_END_FLAG CHARACTER VARYING(1) 1
22 QUARTER_END_FLAG CHARACTER VARYING(1) 1
23 FINANCIAL_YEAR_SPAN CHARACTER VARYING(7) 7
24 FINANCIAL_WEEK_YEAR CHARACTER VARYING(6) 6
25 CURRENT_WEEK_INDICATOR CHARACTER VARYING(1) 1
26 PREVIOUS_WEEK_INDICATOR CHARACTER VARYING(1) 1
27 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
28 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
29 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
30 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8