CORP_DIM_DATE

Database

SDSNZS01_RDM

Schema

CDCPADM_RDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DATE_KEY INTEGER 4
2 CALENDAR_DATE DATE 4
3 CAL_DATE INTEGER 4
4 CAL_YEAR INTEGER 4
5 CAL_YEAR_LABEL CHARACTER VARYING(13) 13
6 CAL_QUARTER INTEGER 4
7 CAL_QUARTER_LABEL CHARACTER VARYING(13) 13
8 CAL_MONTH INTEGER 4
9 CAL_MONTH_LABEL CHARACTER VARYING(13) 13
10 CAL_DAY INTEGER 4
11 CAL_DAY_LABEL CHARACTER VARYING(13) 13
12 FIN_YEAR INTEGER 4
13 FIN_YEAR_LABEL CHARACTER VARYING(13) 13
14 FIN_QUARTER INTEGER 4
15 FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
16 FIN_MONTH INTEGER 4
17 FIN_MONTH_LABEL CHARACTER VARYING(13) 13
18 FIN_DAY INTEGER 4
19 FIN_DAY_LABEL CHARACTER VARYING(13) 13
20 DAY_OF_WEEK BIGINT 8
21 DAY_OF_WEEK_LABEL CHARACTER VARYING(13) 13
22 IS_EOW_SUN CHARACTER(1) 1
23 IS_EOW_FRI CHARACTER(1) 1
24 IS_EOM CHARACTER(1) 1
25 FIRST_DATE_OF_YEAR DATE 4
26 LAST_DATE_OF_YEAR DATE 4
27 WEEK_OF_YEAR INTEGER 4
28 DAYS_IN_YEAR INTEGER 4
29 FIRST_DATE_OF_QUARTER DATE 4
30 LAST_DATE_OF_QUARTER DATE 4
31 DAYS_IN_QUARTER INTEGER 4
32 FIRST_DATE_OF_MONTH DATE 4
33 LAST_DATE_OF_MONTH DATE 4
34 DAYS_IN_MONTH INTEGER 4
35 IS_AU_NATIONAL_HOLIDAY CHARACTER(1) 1
36 IS_NZ_NATIONAL_HOLIDAY CHARACTER(1) 1
37 NZ_NATIONAL_HOLIDAY_TITLE CHARACTER VARYING(200) 200
38 IS_ACT_HOLIDAY CHARACTER(1) 1
39 ACT_HOLIDAY_TITLE CHARACTER VARYING(200) 200
40 IS_NSW_HOLIDAY CHARACTER(1) 1
41 NSW_HOLIDAY_TITLE CHARACTER VARYING(200) 200
42 IS_NT_HOLIDAY CHARACTER(1) 1
43 NT_HOLIDAY_TITLE CHARACTER VARYING(200) 200
44 IS_QLD_HOLIDAY CHARACTER(1) 1
45 QLD_HOLIDAY_TITLE CHARACTER VARYING(200) 200
46 IS_SA_HOLIDAY CHARACTER(1) 1
47 SA_HOLIDAY_TITLE CHARACTER VARYING(200) 200
48 IS_TAS_HOLIDAY CHARACTER(1) 1
49 TAS_HOLIDAY_TITLE CHARACTER VARYING(200) 200
50 IS_VIC_HOLIDAY CHARACTER(1) 1
51 VIC_HOLIDAY_TITLE CHARACTER VARYING(200) 200
52 IS_WA_HOLIDAY CHARACTER(1) 1
53 WA_HOLIDAY_TITLE CHARACTER VARYING(200) 200