The ARF_TIME_WEEK table stores the week part of an instant. There is one row for each week 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.

WEEK_OF_YEAR

tinyint

No

Integer between 1 and 53, the number of the week within the year.

WEEK_TIMESTAMP

timestamp

No

A timestamp representing the beginning of the week.


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