DBA Data[Home] [Help] [Dependency Information]

TABLE: BSC.BSC_SYS_PERIODS

Object Details
Object Name: BSC_SYS_PERIODS
Object Type: TABLE
Owner: BSC
FND Design Data: TableBSC.BSC_SYS_PERIODS
Subobject Name:
Status: VALID


BSC_SYS_PERIODS stores information about the periods by periodicity. Each row includes values that identify the particular period such as period id, start period, end period ,start date and end date.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_SYS_PERIODS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIODICITY_ID
ColumnYEAR
ColumnPERIOD_ID
Columns
Name Datatype Length Mandatory Comments
PERIODICITY_ID NUMBER (5) Yes Periodicity id
YEAR NUMBER (4) Yes Fiscal Year
PERIOD_ID NUMBER (5) Yes Period id
START_DATE DATE

Start date
END_DATE DATE

End date
START_PERIOD NUMBER (5)
Start period
END_PERIOD NUMBER (5)
End period
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
TIME_FK VARCHAR2 (200)
Time foreign key for DBI time dimension
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERIODICITY_ID
,      YEAR
,      PERIOD_ID
,      START_DATE
,      END_DATE
,      START_PERIOD
,      END_PERIOD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TIME_FK
FROM BSC.BSC_SYS_PERIODS;

Dependencies

[top of page]

BSC.BSC_SYS_PERIODS does not reference any database object

BSC.BSC_SYS_PERIODS is referenced by following:

SchemaAPPS
SynonymBSC_SYS_PERIODS