Display Name | Column Name | Comments |
Calendar Date | CALENDAR_DATE | The calendar date for this row. |
Cal Day In Week | CAL_DAY_IN_WEEK | The day in the week. Format DDD. Example: mon, tue, wed. |
Cal Day In Week No | CAL_DAY_IN_WEEK_NO | The day number in the week. 1-7 where Sunday is day 1. |
Cal Day In Month | CAL_DAY_IN_MONTH | The day in the month 1-31. |
Cal Day In Year | CAL_DAY_IN_YEAR | The day in the year 1-366. |
Cal Week In Year | CAL_WEEK_IN_YEAR | The week in the year 0-53. |
Cal Month No | CAL_MONTH_NO | The calendar month number 1-12. |
Cal Month | CAL_MONTH | The calendar month representation. Format YYYYMM. Example: 200206. |
Cal Month Name | CAL_MONTH_NAME | The calendar month name. Format MON. Examples: jan, feb, mar. |
Cal Quarter No | CAL_QUARTER_NO | The calendar quarter number 1-4. |
Cal Quarter | CAL_QUARTER | The calendar quarter representation. Format YYYYQQ. Example 200204. |
Cal Year | CAL_YEAR | The calendar year. Format YYYY |
Financial Date | FINANCIAL_DATE | The financial date. Same as calendar date. |
Fin Day In Week | FIN_DAY_IN_WEEK | The financial day in the week. Format DDD. Example: mon,tue,wed. |
Fin Day In Week No | FIN_DAY_IN_WEEK_NO | Day number in the current financial week. |
Fin Day In Month | FIN_DAY_IN_MONTH | Financial day in the month. Normally the same as calendar day in the month, unless the financial period starts mid calendar month. |
Fin Day In Year | FIN_DAY_IN_YEAR | Financial day in the year. Number of days since the start of the financial year. |
Fin Week In Month | FIN_WEEK_IN_MONTH | Financial week in the financial month. |
Fin Week In Year | FIN_WEEK_IN_YEAR | Financial week in the financial year. Number of weeks since the start of the financial year |
Fin Month No | FIN_MONTH_NO | Financial month number. Format MM. Examples: 1,2,3. |
Fin Month | FIN_MONTH | Financial month representation. Fromat YYYYMM. Examples: 200101, 200102. |
Fin Month Name | FIN_MONTH_NAME | Financial month. Format MON. Examples: jan, feb, mar. |
Fin Period | FIN_PERIOD | Financial period. Format (YYYY-MM) MON-YYYY. Example: (2001-02) Feb-2002. |
Fin Quarter No | FIN_QUARTER_NO | Financial quarter number (1-4). |
Fin Quarter | FIN_QUARTER | Financial quarter representation. Format YYYYQQ. Example: 198901. |
Fin Year | FIN_YEAR | Financial year. Format YYYY. |
Current Cal Day | CURRENT_CAL_DAY | Flag to indicate the current day. Normally set to the last day information was updated in the data warehouse. |
Current Cal Week | CURRENT_CAL_WEEK | Flag to indicate the current week. Set as per current_cal_day. |
Current Cal Month | CURRENT_CAL_MONTH | Flag to indicate the current month. Set as per current_cal_day. |
Current Cal Year | CURRENT_CAL_YEAR | Flag to indicate the current year. Set as per current_cal_day. |
Current Cal Mtd | CURRENT_CAL_MTD | Flag to indicate days in the current month to date. Set as per current_cal_day. |
Current Cal Ytd | CURRENT_CAL_YTD | Flag to indicate days in the current year to date. Set as per current_cal_day. |
Moving Cal Year | MOVING_CAL_YEAR | Flag to indicate days that constitute a full year counting back from the current day. Set as per current_cal_day. |
Current Fin Day | CURRENT_FIN_DAY | Flag to indicate the current financial day. Normally set to the last financial day information was updated in the data warehouse. |
Current Fin Week | CURRENT_FIN_WEEK | Flag to indicate the current financial week. Set as per current_fin_day. |
Current Fin Month | CURRENT_FIN_MONTH | Flag to indicate the current financial month. Set as per current_fin_day. |
Current Fin Quarter | CURRENT_FIN_QUARTER | Flag to indicate the current financial quarter. Set as per current_fin_day. |
Current Fin Year | CURRENT_FIN_YEAR | Flag to indicate the current financial year. Set as per current_fin_day. |
Current Fin Mtd | CURRENT_FIN_MTD | Flag to indicate days in the current financial month to date. Set as per current_fin_day. |
Current Fin Ytd | CURRENT_FIN_YTD | Flag to indicate days in the current financial year to date. Set as per current_fin_day. |
Moving Fin Quarter | MOVING_FIN_QUARTER | Flag to indicate days that constitute a quarter counting back from the current financial day. Set as per current_fin_day. |
Moving Fin Year | MOVING_FIN_YEAR | 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 | WEEK_DAY_FLAG | Flag to indicate if a week day Y=week day N=week end. |
Week End Flag | WEEK_END_FLAG | Flag to indicate a week end day. Y=week end, N=week day. |
Holiday Flag | HOLIDAY_FLAG | Flag to indicate that the day in question is a holiday. Y=holiday, N=normal. |
Holiday Desc | HOLIDAY_DESC | Description of the holiday when a holiday. |
Trading Day Flag | TRADING_DAY_FLAG | Flag to indicate a trading day. Y=trading, N=non trading. |
Trading Days In Mth | TRADING_DAYS_IN_MTH | Number of trading days in this calendar month. |
Trading Days So Far | TRADING_DAYS_SO_FAR | Number of trading days in the month so far. |