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 (range 1-4), for example:

2


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices