| Display Name | Column Name | Comments |
| Calendar Date | CALENDARDATE | The calendar date for this row. |
| Calendar Day In Week | CALDAYINWEEK | The day in the week. Format DDD. Example: mon, tue, wed. |
| Calendar Day In Week Number | CALDAYINWEEKNO | The day number in the week. 1-7 where Sunday is day 1. |
| Calendar Day In Month | CALDAYINMONTH | The day in the month 1-31. |
| Calendar Day In Year | CALDAYINYEAR | The day in the year 1-366. |
| Calendar Week In Year | CALWEEKINYEAR | The week in the year 0-53. |
| Calendar Month Number | CALMONTHNO | The calendar month number 1-12. |
| Calendar Month | CALMONTH | The calendar month representation. Format YYYYMM. Example: 200206. |
| Calendar Month Name | CALMONTHNAME | The calendar month name. Format MON. Examples: jan, feb, mar. |
| Calendar Quarter Number | CALQUARTERNO | The calendar quarter number 1-4. |
| Calendar Quarter | CALQUARTER | The calendar quarter representation. Format YYYYQQ. Example 200204. |
| Calendar Year | CALYEAR | The calendar year. Format YYYY |
| Financial Date | FINANCIALDATE | The financial date. Same as calendar date. |
| Financial Day In Week | FINDAYINWEEK | The financial day in the week. Format DDD. Example: mon,tue,wed. |
| FinancialDay In Week Number | FINDAYINWEEKNO | Day number in the current financial week. |
| Financial Day In Month | FINDAYINMONTH | Financial day in the month. Normally the same as calendar day in the month, unless the financial period starts mid calendar month. |
| Financial Day In Year | FINDAYINYEAR | Financial day in the year. Number of days since the start of the financial year. |
| Financial Week In Month | FINWEEKINMONTH | Financial week in the financial month. |
| Financial Week In Year | FINWEEKINYEAR | Financial week in the financial year. Number of weeks since the start of the financial year |
| Financial Month Number | FINMONTHNO | Financial month number. Format MM. Examples: 1,2,3. |
| Financial Month | FINMONTH | Financial month representation. Fromat YYYYMM. Examples: 200101, 200102. |
| Financial Month Name | FINMONTHNAME | Financial month. Format MON. Examples: jan, feb, mar. |
| Financial Period | FINPERIOD | Financial period. Format (YYYY-MM) MON-YYYY. Example: (2001-02) Feb-2002. |
| Financial Quarter Number | FINQUARTERNO | Financial quarter number (1-4). |
| Financial Quarter | FINQUARTER | Financial quarter representation. Format YYYYQQ. Example: 198901. |
| Financial Year | FINYEAR | Financial year. Format YYYY. |
| Current Calendar Day | CURRENTCALDAY | Flag to indicate the current day. Normally set to the last day information was updated in the data warehouse. |
| Current Calendar Week | CURRENTCALWEEK | Flag to indicate the current week. Set as per current_cal_day. |
| Current Calendar Month | CURRENTCALMONTH | Flag to indicate the current month. Set as per current_cal_day. |
| Current Calendar Year | CURRENTCALYEAR | Flag to indicate the current year. Set as per current_cal_day. |
| Current Calendar Month To Date | CURRENTCALMTD | Flag to indicate days in the current month to date. Set as per current_cal_day. |
| Current Calendar Year To Date | CURRENTCALYTD | Flag to indicate days in the current year to date. Set as per current_cal_day. |
| Moving Calendar Year | MOVINGCALYEAR | Flag to indicate days that constitute a full year counting back from the current day. Set as per current_cal_day. |
| Current Financial Day | CURRENTFINDAY | Flag to indicate the current financial day. Normally set to the last financial day information was updated in the data warehouse. |
| Current Financial Week | CURRENTFINWEEK | Flag to indicate the current financial week. Set as per current_fin_day. |
| Current Financial Month | CURRENTFINMONTH | Flag to indicate the current financial month. Set as per current_fin_day. |
| Current Financial Quarter | CURRENTFINQUARTER | Flag to indicate the current financial quarter. Set as per current_fin_day. |
| Current Financial Year | CURRENTFINYEAR | Flag to indicate the current financial year. Set as per current_fin_day. |
| Current Financial Month To Date | CURRENTFINMTD | Flag to indicate days in the current financial month to date. Set as per current_fin_day. |
| Current Financial Year To Date | CURRENTFINYTD | Flag to indicate days in the current financial year to date. Set as per current_fin_day. |
| Moving Financial Quarter | MOVINGFINQUARTER | Flag to indicate days that constitute a quarter counting back from the current financial day. Set as per current_fin_day. |
| Moving Financial Year | MOVINGFINYEAR | Flag to indicate days that constitute a financial year counting back from the current financial day. Set as per current_fin_day. |
| Week Day Flag | WEEKDAYFLAG | Flag to indicate if a week day Y=week day N=week end. |
| Week End Flag | WEEKENDFLAG | Flag to indicate a week end day. Y=week end, N=week day. |
| Holiday Flag | HOLIDAYFLAG | Flag to indicate that the day in question is a holiday. Y=holiday, N=normal. |
| Holiday Description | HOLIDAYDESC | Description of the holiday when a holiday. |
| Trading Day Flag | TRADINGDAYFLAG | Flag to indicate a trading day. Y=trading, N=non trading. |
| Trading Days In Month | TRADINGDAYSINMTH | Number of trading days in this calendar month. |
| Trading Days So Far | TRADINGDAYSSOFAR | Number of trading days in the month so far. |
| DSS Create Time | DSSCREATETIME | Date/time that this record was inserted in the data warehouse |
| DSS Update Time | DSSUPDATETIME | Date/time that this record was updated in the data warehouse |