DIM_MOTOR_HOME_ACTIVITY_LOSS_DATE_V

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 LOSS_DATE_KEY INTEGER 4
2 LOSS_DATE_YEAR INTEGER 4
3 LOSS_DATE_YEAR_LABEL CHARACTER VARYING(13) 13
4 LOSS_DATE_QUARTER INTEGER 4
5 LOSS_DATE_QUARTER_LABEL CHARACTER VARYING(13) 13
6 LOSS_DATE_MONTH INTEGER 4
7 LOSS_DATE_MONTH_LABEL CHARACTER VARYING(13) 13
8 LOSS_DATE_DAY INTEGER 4
9 LOSS_DATE_DAY_LABEL CHARACTER VARYING(13) 13
10 LOSS_DATE_CURRENT_MONTH CHARACTER VARYING(8) 8
11 LOSS_DATE_CURRENT_MONTH_FLAG CHARACTER VARYING(18) 18
12 LOSS_DATE_PREVIOUS_MONTH CHARACTER VARYING(8) 8
13 LOSS_DATE_PREVIOUS_MONTH_FLAG CHARACTER VARYING(18) 18