The ARF_TIME_MONTH table stores the month part of an instant. There is one row for each month in each year of interest for reporting.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | varchar | 40 | No | Identifier; primary key. |
YEAR_ID | varchar | 40 | No | Foreign key to ARF_TIME_YEAR.ID column. |
QTR_ID | varchar | 40 | No | Foreign key to ARF_TIME_QTR.ID column. |
MOY_ID | varchar | 40 | No | Foreign key to ARF_CAL_MOY.ID column. |
MONTH_OF_YEAR | tinyint | No | Integer between 1 and 12, the number of the month within a year. | |
MONTH_TIMESTAMP | timestamp | No | A timestamp representing the beginning of the month. |