Calendar Dim Columns

The Calendar Dimensions table provides Walmart calendar Date, month, and week details.

The following provides Calendar Dimensions column details, in alphabetical order.

Technical Name	Business Name	Data Type	Primary Key	Sensitive Metrics	DSS Mapping
cal_day_alpha_nbr	Calendar Day Alpha Number	String	-	-	Calendar Day Alpha Number
cal_dt	Calendar Date	Date	Y	-	Calendar Date
cal_dt_end_ts	Calendar Date End Time	String	-	-	Calendar Date End Time
cal_dt_start_ts	Calendar Date Start Time	String	-	-	Calendar Date Start Time
cal_full_yr_nbr	Calendar Full Year Number	Short	-	-	Calendar Full Year Number
cal_half_cnt	Calendar Half Year Count	Short	-	-	Calendar Half Year Count
cal_half_yr_nbr	Calendar Half Year Number	Short	-	-	Calendar Half Year Number
cal_half_yr_nm	Calendar Half Year Name	String	-	-	Calendar Half Year Name
cal_mth_abbr	Calendar Month Abbreviation	String	-	-	Calendar Month Abbreviation
cal_mth_alpha_nbr	Calendar Month Alpha Number	String	-	-	Calendar Month Alpha Number
cal_mth_cnt	Calendar Month Count	Integer	-	-	Calendar Month Count
cal_mth_desc	Calendar Month Description	String	-	-	Calendar Month Description
cal_mth_nbr	Calendar Month Number	Integer	-	-	Calendar Month Number
cal_qtr_cnt	Calculated Quarter Count	Integer	-	-	Calculated Quarter Count
cal_qtr_desc	Calendar Quarter Description	String	-	-	Calendar Quarter Description
cal_qtr_nbr	Calculated Quarter Number	Short	-	-	Calculated Quarter Number
cal_wk_cnt	Calendar Week Count	Integer	-	-	Calendar Week Count
cal_wk_day_abbr	Calendar Weekday Abbreviated	String	-	-	Calendar Weekday Abbreviated
cal_wk_day_nbr	Calendar Weekday Number	Short	-	-	Calendar Weekday Number
cal_wk_day_nm	Calendar Day of the Week Name	String	-	-	Calendar Day of the Week Name
cal_wk_nbr	Calendar Week Number	Integer	-	-	Calendar Week Number
cal_wk_nm	Calendar Week Name	String	-	-	Calendar Week Name
cal_yr_nm	Calendar Year Name	String	-	-	Calendar Year Name
date_desc	Date Description	String	-	-	Date Description
day_cnt	Day Count	Integer	-	-	Day Count
fiscal_full_yr_nbr	Fiscal Full Year Number	Short	-	-	Fiscal Full Year Number
fiscal_half_cnt	Fiscal Half Count	Short	-	-	Fiscal Half Count
fiscal_half_yr_nbr	Fiscal Half Year Number	Integer	-	-	Fiscal Half Year Number
fiscal_half_yr_nm	Fiscal Half Year Name	String	-	-	Fiscal Half Year Name
fiscal_mth_abbr	Fiscal Month Abbreviation	String	-	-	Fiscal Month Abbreviation
fiscal_mth_alpha_nbr	Fiscal Month Alpha Number	String	-	-	Fiscal Month Alpha Number
fiscal_mth_cnt	Fiscal Month Count	Integer	-	-	Fiscal Month Count
fiscal_mth_nbr	Fiscal Month Number	Short	-	-	Fiscal Month Number
fiscal_mth_nm	Fiscal Month Name	String	-	-	Fiscal Month Name
fiscal_qtr_cnt	Fiscal Quarter Count	Integer	-	-	Fiscal Quarter Count
fiscal_qtr_nbr	Fiscal Quarter Number	Short	-	-	Fiscal Quarter Number
fiscal_qtr_nm	Fiscal Quarter Name	String	-	-	Fiscal Quarter Name
fiscal_yr_nm	Fiscal Year Name	String	-	-	Fiscal Year Name
geo_region_cd	Geographic Region Code	String	Y	-	Geographic Region Code
julian_dt	Julian Date	Integer	-	-	Julian Date
ly_cal_dt	Last Year Calendar Date	Date	-	-	Last Year Calendar Date
ly_comp_visit_dt	Last Year Compare Visit Date	Date	-	-	Last Year Compare Visit Date
ly_comp_yr_wk_nbr	Last Year Compare Year Week Number	Integer	-	-	Last Year Compare Year Week Number
wm_epoc_half_cnt	Walmart EPOC Half Count	Short	-	-	Walmart EPOC Half Count
wm_full_yr_nbr	Walmart Full Year Number	Short	-	-	Walmart Full Year Number
wm_half_yr_nbr	Walmart Half Year Number	Short	-	-	Walmart Half Year Number
wm_half_yr_nm	Walmart Half Year Name	String	-	-	Walmart Half Year Name
wm_mth_abbr	Walmart Month Abbreviation	String	-	-	Walmart Month Abbreviation
wm_mth_alpha_nbr	Walmart Month Alpha Number	String	-	-	Walmart Month Alpha Number
wm_mth_cnt	Walmart Month Count	Integer	-	-	Walmart Month Count
wm_mth_nbr	Walmart Month Number	Short	-	-	Walmart Month Number
wm_mth_nm	Walmart Month Name	String	-	-	Walmart Month Name
wm_qtr_nbr	Walmart Quarter Number	Short	-	-	Walmart Quarter Number
wm_qtr_nm	Walmart Quarter Name	String	-	-	Walmart Quarter Name
wm_refer_qtr_cnt	Walmart Refer Quarter Count	Integer	-	-	Walmart Refer Quarter Count
wm_wk_cnt	Walmart Week Count	Integer	-	-	Walmart Week Count
wm_wk_day_nbr	Walmart Weekday Number	Short	-	-	Walmart Weekday Number
wm_wk_nbr	Walmart Week Number	Short	-	-	Walmart Week Number
wm_wk_nm	Walmart Week Name	String	-	-	Walmart Week Name
wm_yr_desc	Walmart Year Description	String	-	-	Walmart Year Description
wm_yr_wk_nbr	Walmart Year Week Number	Integer	-	-	Walmart Year Week Number