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.


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