Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OPA CYCLES Table


View exposing OPA disclosure-cycle reference data including cycle number, reporting-period start and end dates, cycle status, open and close dates, and inverse cycle number.


Field Name

Description

Data Type

Length

CLOSE_DATE

Date associated with close.

DATE

INVERSE_CYCLE_NUMBER

Inverse cycle number associated with the record.

NUMBER

OPA_CYCLE_NUMBER

Opa cycle number associated with the record.

NUMBER

OPA_CYCLE_STATUS

Opa cycle status associated with the record.

VARCHAR2

1

OPEN_DATE

Date associated with open.

DATE

PERIOD_END_DATE

Date associated with period end.

DATE

PERIOD_START_DATE

Date associated with period start.

DATE

UPDATE_TIMESTAMP

Timestamp associated with update.

DATE

UPDATE_USER

Update user associated with the record.

VARCHAR2

8