This table stores quarter information for an instant. There is one row for each quarter of 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. |
QOY_ID | varchar | 40 | No | Foreign key to ARF_CAL_QOY.ID column. |
QTR_TIMESTAMP | timestamp | No | A timestamp representing the beginning of the quarter. By default this is midnight (Coordinated Universal Time) on 1 January, 1 April, 1 July, and 1 October of each year. | |
QTR_OF_YEAR | tinyint | No | The number of the quarter within a year, for example: 2 |