DIM_BDW_TSDMD_PERIOD

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
2 LOAD_STATUS_FLAG CHARACTER VARYING(2) 2
3 INSERT_RUN_AUDIT_ID BIGINT 8
4 UPDATE_RUN_AUDIT_ID BIGINT 8
5 PERIOD_DT CHARACTER VARYING(10) 10
6 WEEK_START_ID BIGINT 8
7 WEEK_END_ID BIGINT 8
8 MONTH_START_ID BIGINT 8
9 MONTH_END_ID BIGINT 8
10 QUARTER_START_ID BIGINT 8
11 QUARTER_END_ID BIGINT 8
12 FINANCIAL_START_ID BIGINT 8
13 FINANCIAL_END_ID BIGINT 8
14 DAY_OF_MONTH BIGINT 8
15 DAY_OF_QUARTER BIGINT 8
16 DAY_OF_CALENDAR_YEAR BIGINT 8
17 DAY_OF_FINANCIAL_YEAR BIGINT 8
18 DAYS_IN_MONTH BIGINT 8
19 DAYS_IN_QUARTER BIGINT 8
20 DAYS_IN_CALENDAR_YEAR BIGINT 8
21 DAYS_IN_FINANCIAL_YEAR BIGINT 8
22 CALENDAR_WEEK_NUMBER BIGINT 8
23 FINANCIAL_WEEK_NUMBER BIGINT 8
24 CALENDAR_MONTH_NUMBER BIGINT 8
25 FINANCIAL_MONTH_NUMBER BIGINT 8
26 CALENDAR_QUARTER_NUMBER CHARACTER VARYING(18) 18
27 FINANCIAL_QUARTER_NUMBER BIGINT 8
28 CALENDAR_YEAR_NUMBER BIGINT 8
29 FINANCIAL_YEAR_NUMBERC BIGINT 8
30 DAY_NAME CHARACTER VARYING(9) 9
31 MONTH_NAME CHARACTER VARYING(9) 9
32 PUBLIC_HOLIDAY_IN_QLD CHARACTER VARYING(1) 1
33 PUBLIC_HOLIDAY_IN_NSW CHARACTER VARYING(1) 1
34 PUBLIC_HOLIDAY_IN_VIC CHARACTER VARYING(1) 1
35 PUBLIC_HOLIDAY_IN_TAS CHARACTER VARYING(1) 1
36 PUBLIC_HOLIDAY_IN_SA CHARACTER VARYING(1) 1
37 PUBLIC_HOLIDAY_IN_NT CHARACTER VARYING(1) 1
38 PUBLIC_HOLIDAY_IN_WA CHARACTER VARYING(1) 1
39 WEEKEND_FLAG CHARACTER VARYING(1) 1
40 MONTH_END_FLAG CHARACTER VARYING(1) 1
41 WEEK_START_DT CHARACTER VARYING(10) 10
42 WEEK_END_DT CHARACTER VARYING(10) 10
43 MONTH_START_DT CHARACTER VARYING(10) 10
44 MONTH_END_DT CHARACTER VARYING(10) 10
45 QUARTER_START_DT CHARACTER VARYING(10) 10
46 QUARTER_END_DT CHARACTER VARYING(10) 10
47 FINANCIAL_START_DT CHARACTER VARYING(10) 10
48 FINANCIAL_END_DT CHARACTER VARYING(10) 10
49 FINANCIAL_YEAR_END_FLAG CHARACTER VARYING(1) 1
50 QUARTER_END_FLAG CHARACTER VARYING(1) 1