[Home] [Help] [Dependency Information]
Object Name: | BSC_SYS_PERIODICITIES |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_SYS_PERIODICITIES |
Subobject Name: | |
Status: | VALID |
BSC_SYS_PERIODICITIES stores information about the system periodicity. Each row includes values that identify the particular periodicity such as number of periods, number of subperiods and the column names in the data tables.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_SYS_PERIODICITIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PERIODICITY_ID |
BSC_SYS_PERIODICITIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CALENDAR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIODICITY_ID | NUMBER | (5) | Yes | Periodicity Id |
NUM_OF_PERIODS | NUMBER | (5) | Yes | Number of periods by periodicity option |
SOURCE | VARCHAR2 | (200) | All the periodicity id sources, Each periodicity id is separated by "," | |
NUM_OF_SUBPERIODS | NUMBER | (5) | Yes | Number of sub-periods by periodicity option |
PERIOD_COL_NAME | VARCHAR2 | (15) | Period column name in input table | |
SUBPERIOD_COL_NAME | VARCHAR2 | (15) | Sub-Period column name in input table | |
YEARLY_FLAG | NUMBER | (1) | Flag that indicates if it is a yearly periodicity | |
EDW_FLAG | NUMBER | (1) | Flag that indicates if the periodicity is EDW | |
CALENDAR_ID | NUMBER | Calendar identifier when the Periodicity is EDW | ||
EDW_PERIODICITY_ID | NUMBER | EDW periodicity identifier | ||
CUSTOM_CODE | NUMBER | (1) | Custom code . 1=from daily periodicity, 2 =from predefined periodicity | |
DB_COLUMN_NAME | VARCHAR2 | (30) | Column name in BSC_DBs tables | |
PERIODICITY_TYPE | NUMBER | (3) | Periodicity type . 1=Annually,2=Semi anual, 3 =Quarterly,4=Bi-montly,5=Monthly,7 =week,9=Daily | |
PERIOD_TYPE_ID | NUMBER | Period type identifier | ||
RECORD_TYPE_ID | VARCHAR2 | (4000) | Record identifier types | |
XTD_PATTERN | VARCHAR2 | (4000) | XTD Pattern | |
SHORT_NAME | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT PERIODICITY_ID
, NUM_OF_PERIODS
, SOURCE
, NUM_OF_SUBPERIODS
, PERIOD_COL_NAME
, SUBPERIOD_COL_NAME
, YEARLY_FLAG
, EDW_FLAG
, CALENDAR_ID
, EDW_PERIODICITY_ID
, CUSTOM_CODE
, DB_COLUMN_NAME
, PERIODICITY_TYPE
, PERIOD_TYPE_ID
, RECORD_TYPE_ID
, XTD_PATTERN
, SHORT_NAME
FROM BSC.BSC_SYS_PERIODICITIES;
BSC.BSC_SYS_PERIODICITIES does not reference any database object
BSC.BSC_SYS_PERIODICITIES is referenced by following:
|
|
|