DIM_MOTOR_HOME_ACTIVITY_FINALISED_DATE_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 FINALISED_DATE_KEY INTEGER 4
2 FINALISED_DATE_YEAR INTEGER 4
3 FINALISED_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
4 FINALISED_DATE_QUARTER INTEGER 4
5 FINALISED_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
6 FINALISED_DATE_MONTH INTEGER 4
7 FINALISED_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
8 FINALISED_DATE_DAY INTEGER 4
9 FINALISED_DATE_DAY_LABEL CHARACTER VARYING(13) 13
10 FINALISED_DATE_FIN_YEAR INTEGER 4
11 FINALISED_DATE_FIN_YEAR_LABEL CHARACTER VARYING(13) 13
12 FINALISED_DATE_FIN_QUARTER INTEGER 4
13 FINALISED_DATE_FIN_QUARTER_LABEL CHARACTER VARYING(13) 13
14 FINALISED_DATE_FIN_MONTH INTEGER 4
15 FINALISED_DATE_FIN_MONTH_LABEL CHARACTER VARYING(13) 13
16 FINALISED_DATE_FIN_DAY INTEGER 4
17 FINALISED_DATE_FIN_DAY_LABEL CHARACTER VARYING(13) 13
18 FINALISED_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
19 FINALISED_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
20 FINALISED_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
21 FINALISED_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18