Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - BSC Tables and Views

TABLE - BSC.BSC_APPS_USERS
TABLE - BSC.BSC_BIS_MEASURES_DATA
TABLE - BSC.BSC_COLOR_RANGES
TABLE - BSC.BSC_COLOR_TYPE_PROPS
TABLE - BSC.BSC_CURRENT_SESSIONS
TABLE - BSC.BSC_DB_CALCULATIONS
TABLE - BSC.BSC_DB_CALENDAR
TABLE - BSC.BSC_DB_LOADER_CONTROL
TABLE - BSC.BSC_DB_MEASURE_COLS_TL
TABLE - BSC.BSC_DB_MEASURE_GROUPS_TL
TABLE - BSC.BSC_DB_PROCESS_CONTROL
TABLE - BSC.BSC_DB_RESERVED_WORDS
TABLE - BSC.BSC_DB_TABLES
TABLE - BSC.BSC_DB_TABLES_COLS
TABLE - BSC.BSC_DB_TABLES_DISPLAY
TABLE - BSC.BSC_DB_TABLES_RELS
TABLE - BSC.BSC_DB_TABLES_RELS_DISPLAY
TABLE - BSC.BSC_DB_VALIDATION
TABLE - BSC.BSC_DB_WEEK_MAPS
TABLE - BSC.BSC_EDW_CALENDAR_TYPE_TL
TABLE - BSC.BSC_EDW_PERIODS_TL
TABLE - BSC.BSC_INSTALL_LOGS
TABLE - BSC.BSC_KPIS_B
TABLE - BSC.BSC_KPIS_TL
TABLE - BSC.BSC_KPI_ANALYSIS_GROUPS
TABLE - BSC.BSC_KPI_ANALYSIS_MEASURES_B
TABLE - BSC.BSC_KPI_ANALYSIS_MEASURES_TL
TABLE - BSC.BSC_KPI_ANALYSIS_OPTIONS_B
TABLE - BSC.BSC_KPI_ANALYSIS_OPTIONS_TL
TABLE - BSC.BSC_KPI_ANALYSIS_OPT_USER
TABLE - BSC.BSC_KPI_CALCULATIONS
TABLE - BSC.BSC_KPI_CALCULATIONS_USER
TABLE - BSC.BSC_KPI_CAUSE_EFFECT_RELS
TABLE - BSC.BSC_KPI_COMMENTS
TABLE - BSC.BSC_KPI_DATA_TABLES
TABLE - BSC.BSC_KPI_DEFAULTS_B
TABLE - BSC.BSC_KPI_DEFAULTS_TL
TABLE - BSC.BSC_KPI_DIM_GROUPS
TABLE - BSC.BSC_KPI_DIM_LEVELS_B
TABLE - BSC.BSC_KPI_DIM_LEVELS_TL
TABLE - BSC.BSC_KPI_DIM_LEVELS_USER
TABLE - BSC.BSC_KPI_DIM_LEVEL_PROPERTIES
TABLE - BSC.BSC_KPI_DIM_SETS_TL
TABLE - BSC.BSC_KPI_GRAPHS
TABLE - BSC.BSC_KPI_MEASURE_PROPS
TABLE - BSC.BSC_KPI_MEASURE_WEIGHTS
TABLE - BSC.BSC_KPI_MM_CONTROLS
TABLE - BSC.BSC_KPI_PERIODICITIES
TABLE - BSC.BSC_KPI_PERIODICITIES_USER
TABLE - BSC.BSC_KPI_PROPERTIES
TABLE - BSC.BSC_KPI_SERIES_COLORS
TABLE - BSC.BSC_KPI_SHELL_CMDS_TL
TABLE - BSC.BSC_KPI_SHELL_CMDS_USER
TABLE - BSC.BSC_KPI_SUBTITLES_TL
TABLE - BSC.BSC_KPI_TREE_NODES_B
TABLE - BSC.BSC_KPI_TREE_NODES_TL
TABLE - BSC.BSC_MESSAGE_LOGS
TABLE - BSC.BSC_MIG_SRC_SYS_DETAILS
TABLE - BSC.BSC_OBJECT_LOCKS
TABLE - BSC.BSC_OBJECT_LOCK_USERS
TABLE - BSC.BSC_OLAP_OBJECT
TABLE - BSC.BSC_OLAP_OBJECT_RELATION
TABLE - BSC.BSC_REPORTING_CALENDAR
TABLE - BSC.BSC_RESPONSIBILITY
TABLE - BSC.BSC_RESPONSIBILITY_TL
TABLE - BSC.BSC_RPT_KEYS
TABLE - BSC.BSC_SYS_BENCHMARKS_B
TABLE - BSC.BSC_SYS_BENCHMARKS_TL
TABLE - BSC.BSC_SYS_BM_GROUPS
TABLE - BSC.BSC_SYS_CALCULATIONS
TABLE - BSC.BSC_SYS_CALENDARS_B
TABLE - BSC.BSC_SYS_CALENDARS_TL
TABLE - BSC.BSC_SYS_COLORS_B
TABLE - BSC.BSC_SYS_COLORS_TL
TABLE - BSC.BSC_SYS_COM_DIM_LEVELS
TABLE - BSC.BSC_SYS_DATASETS_B
TABLE - BSC.BSC_SYS_DATASETS_TL
TABLE - BSC.BSC_SYS_DATASET_CALC
TABLE - BSC.BSC_SYS_DIM_GROUPS_TL
TABLE - BSC.BSC_SYS_DIM_LEVELS_B
TABLE - BSC.BSC_SYS_DIM_LEVELS_BY_GROUP
TABLE - BSC.BSC_SYS_DIM_LEVELS_TL
TABLE - BSC.BSC_SYS_DIM_LEVEL_COLS
TABLE - BSC.BSC_SYS_DIM_LEVEL_RELS
TABLE - BSC.BSC_SYS_FILES
TABLE - BSC.BSC_SYS_FILTERS
TABLE - BSC.BSC_SYS_FILTERS_VIEWS
TABLE - BSC.BSC_SYS_FORMATS
TABLE - BSC.BSC_SYS_IMAGES
TABLE - BSC.BSC_SYS_IMAGES_MAP_TL
TABLE - BSC.BSC_SYS_INIT
TABLE - BSC.BSC_SYS_KPI_COLORS
TABLE - BSC.BSC_SYS_LABELS_B
TABLE - BSC.BSC_SYS_LABELS_TL
TABLE - BSC.BSC_SYS_LINES
TABLE - BSC.BSC_SYS_MEASURES
TABLE - BSC.BSC_SYS_MM_CONTROLS_TL
TABLE - BSC.BSC_SYS_OBJECTIVE_COLORS
TABLE - BSC.BSC_SYS_PERIODICITIES
TABLE - BSC.BSC_SYS_PERIODICITIES_TL
TABLE - BSC.BSC_SYS_PERIODS
TABLE - BSC.BSC_SYS_PERIODS_TL
TABLE - BSC.BSC_SYS_SERIES_COLORS
TABLE - BSC.BSC_SYS_USER_OPTIONS
TABLE - BSC.BSC_TABS_B
TABLE - BSC.BSC_TABS_TL
TABLE - BSC.BSC_TAB_CSF_B
TABLE - BSC.BSC_TAB_CSF_TL
TABLE - BSC.BSC_TAB_INDICATORS
TABLE - BSC.BSC_TAB_IND_GROUPS_B
TABLE - BSC.BSC_TAB_IND_GROUPS_TL
TABLE - BSC.BSC_TAB_VIEWS_B
TABLE - BSC.BSC_TAB_VIEWS_TL
TABLE - BSC.BSC_TAB_VIEW_KPI_TL
TABLE - BSC.BSC_TAB_VIEW_LABELS_B
TABLE - BSC.BSC_TAB_VIEW_LABELS_TL
TABLE - BSC.BSC_TMP_BIG_IN_COND
TABLE - BSC.BSC_TMP_OPT_UI_KPIS
TABLE - BSC.BSC_TMP_OPT_UI_LEVELS
TABLE - BSC.BSC_UI_COLOR_SCHEMES
TABLE - BSC.BSC_UI_COLOR_USER
TABLE - BSC.BSC_UPGRADE_TASK
TABLE - BSC.BSC_USERS
TABLE - BSC.BSC_USER_INFO
TABLE - BSC.BSC_USER_KPIGRAPH_PLUGS
TABLE - BSC.BSC_USER_KPILIST_KPIS
TABLE - BSC.BSC_USER_KPILIST_PLUGS
TABLE - BSC.BSC_USER_KPI_ACCESS
TABLE - BSC.BSC_USER_LIST_ACCESS
TABLE - BSC.BSC_USER_PARAMETERS_B
TABLE - BSC.BSC_USER_PARAMETERS_TL
TABLE - BSC.BSC_USER_RESPONSIBILITY
TABLE - BSC.BSC_USER_TAB_ACCESS
VIEW - APPS.BSC_APPS_USERS_V
VIEW - APPS.BSC_BIS_DIM_LEVELS_V
VIEW - APPS.BSC_DB_BASIC_DIM_SETS_V
VIEW - APPS.BSC_DB_COLOR_AO_DEFAULTS_V
VIEW - APPS.BSC_DB_COLOR_KPI_DEFAULTS_V
VIEW - APPS.BSC_DB_COLOR_KPI_V
VIEW - APPS.BSC_DB_COLOR_MEASURES_V
VIEW - APPS.BSC_DB_DATASET_DIM_SETS_V
VIEW - APPS.BSC_DB_MEASURE_BY_DIM_SET_V
VIEW - APPS.BSC_DB_MEASURE_COLS_VL
VIEW - APPS.BSC_DB_MEASURE_GROUPS_VL
VIEW - APPS.BSC_EDW_CALENDAR_TYPE_VL
VIEW - APPS.BSC_KPIS_VL
VIEW - APPS.BSC_KPI_ANALYSIS_MEASURES_VL
VIEW - APPS.BSC_KPI_ANALYSIS_OPTIONS_VL
VIEW - APPS.BSC_KPI_DATA_TABLES_V
VIEW - APPS.BSC_KPI_DEFAULTS_VL
VIEW - APPS.BSC_KPI_DIM_LEVELS_VL
VIEW - APPS.BSC_KPI_DIM_SETS_VL
VIEW - APPS.BSC_KPI_SHELL_CMDS_VL
VIEW - APPS.BSC_KPI_SUBTITLES_VL
VIEW - APPS.BSC_KPI_TREE_NODES_VL
VIEW - APPS.BSC_LOOKUPS
VIEW - APPS.BSC_MESSAGES
VIEW - APPS.BSC_OAF_ANALYSYS_OPT_COMB_V
VIEW - APPS.BSC_OAF_DIM_LEVELS_V
VIEW - APPS.BSC_OPTS_PMF_MEAS_V
VIEW - APPS.BSC_PMF_MEAS_V
VIEW - APPS.BSC_RESPONSIBILITY_VL
VIEW - APPS.BSC_SYS_BENCHMARKS_VL
VIEW - APPS.BSC_SYS_CALENDARS_VL
VIEW - APPS.BSC_SYS_COLORS_VL
VIEW - APPS.BSC_SYS_DATASETS_VL
VIEW - APPS.BSC_SYS_DIM_GROUPS_VL
VIEW - APPS.BSC_SYS_DIM_LEVELS_VL
VIEW - APPS.BSC_SYS_DIM_LEVEL_RELS_V
VIEW - APPS.BSC_SYS_IMAGES_MAP_VL
VIEW - APPS.BSC_SYS_LABELS_VL
VIEW - APPS.BSC_SYS_MM_CONTROLS_VL
VIEW - APPS.BSC_SYS_PERIODICITIES_VL
VIEW - APPS.BSC_SYS_PERIODS_VL
VIEW - APPS.BSC_TABS_VL
VIEW - APPS.BSC_TAB_CSF_VL
VIEW - APPS.BSC_TAB_IND_GROUPS_VL
VIEW - APPS.BSC_TAB_IND_V
VIEW - APPS.BSC_TAB_VIEWS_VL
VIEW - APPS.BSC_TAB_VIEW_KPI_VL
VIEW - APPS.BSC_TAB_VIEW_LABELS_VL
VIEW - APPS.BSC_USER_PARAMETERS_VL
VIEW - APPS.BSC_USER_RESPONSIBILITY_V

Table: BSC_APPS_USERS

Description: BSC Users
Primary Key: BSC_APPS_USERS_PK
  1. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_APPS_USERS.USER_ID BSC_USERS
Comments

BSC_APPS_USERS stores information about BSC users. Each row includes the User Name, full name and email address. It is used for Personal Mode.

Indexes
Index Type Tablespace Column
BSC_APPS_USERS_U1 UNIQUE APPS_TS_TX_IDX USER_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y User identifier
USER_NAME VARCHAR2 (100) Y User name
FULL_NAME VARCHAR2 (240)
User full name
ENCRYPTED_USER_PASSWORD VARCHAR2 (100) Y Encrypted password
EMAIL_ADDRESS VARCHAR2 (240)
Email address
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_APPS_USERS does not reference any database object

BSC.BSC_APPS_USERS is referenced by following:

APPS
SYNONYM - BSC_APPS_USERS

[top of page]

Table: BSC_BIS_MEASURES_DATA

Description: BSC/PMF measure Actual and Target
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BSC_BIS_MEASURES_DATA_U1 UNIQUE APPS_TS_TX_IDX USER_ID
RESPONSIBILITY_ID
INDICATOR
ANALYSIS_OPTION0
ANALYSIS_OPTION1
ANALYSIS_OPTION2
SERIES_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y
RESPONSIBILITY_ID NUMBER (15) Y
INDICATOR NUMBER (5) Y
ANALYSIS_OPTION0 NUMBER (3) Y
ANALYSIS_OPTION1 NUMBER (3) Y
ANALYSIS_OPTION2 NUMBER (3) Y
SERIES_ID NUMBER (3) Y
CACHING_KEY VARCHAR2 (200)
ACTUAL_DATA NUMBER

BUDGET_DATA NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

BSC.BSC_BIS_MEASURES_DATA does not reference any database object

BSC.BSC_BIS_MEASURES_DATA is referenced by following:

APPS
SYNONYM - BSC_BIS_MEASURES_DATA

[top of page]

Table: BSC_COLOR_RANGES

Description: Table to store the color tresholds/ranges
Comments
Table to store the color tresholds/ranges
Indexes
Index Type Tablespace Column
BSC_COLOR_RANGES_U1 UNIQUE APPS_TS_TX_IDX COLOR_RANGE_ID
COLOR_RANGE_SEQUENCE
Columns
Name Datatype Length Mandatory Comments
COLOR_RANGE_ID NUMBER
Y Color Range Id
COLOR_RANGE_SEQUENCE NUMBER
Y Sequence to identify a threshold within a color range
LOW NUMBER

Lower Range Value
HIGH NUMBER

Higher Range Value
COLOR_ID NUMBER (8)
Color Id for the color range

[top of page]

BSC.BSC_COLOR_RANGES does not reference any database object

BSC.BSC_COLOR_RANGES is referenced by following:

APPS
SYNONYM - BSC_COLOR_RANGES

[top of page]

Table: BSC_COLOR_TYPE_PROPS

Description: This table stores the Color Ranges for the KPI Measures and Objectives. We kept this separate so as to allow multiple threshold ranges for the same KPI Measure (or Objective) for different color types. For Simulation Objective, KPI_MEASURE_
Comments
This table stores the Color Ranges for the KPI Measures and Objectives. We kept this separate so as to allow multiple threshold ranges for the same KPI Measure (or Objective) for different color types. For WA calculation for the Objective, KPI_MEASURE_ID will be NULL.
Indexes
Index Type Tablespace Column
BSC_COLOR_TYPE_PROPS_N1 NONUNIQUE APPS_TS_TX_IDX INDICATOR
BSC_COLOR_TYPE_PROPS_N2 NONUNIQUE APPS_TS_TX_IDX KPI_MEASURE_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Objective Id
KPI_MEASURE_ID NUMBER

KPI Measure Id
COLOR_TYPE VARCHAR2 (30)
Indicates the type of color calculations for a KPI. Can have any values of: PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
COLOR_RANGE_ID NUMBER

The Color Range Id for the KPI and the Objective.
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER (15) Y Created By
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATED_BY NUMBER (15) Y Last Updated By
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login
PROPERTY_VALUE NUMBER

Generic column to be used in conjunction with Indicator and KPI Measure Id for storing any property.

[top of page]

BSC.BSC_COLOR_TYPE_PROPS does not reference any database object

BSC.BSC_COLOR_TYPE_PROPS is referenced by following:

APPS
SYNONYM - BSC_COLOR_TYPE_PROPS

[top of page]

Table: BSC_CURRENT_SESSIONS

Description: Current BSC sessions
Comments

BSC_CURRENT_SESSIONS stores information about Current BSC sessions.It ckecks if System is lock by other users.

Indexes
Index Type Tablespace Column
BSC_CURRENT_SESSIONS_N1 NONUNIQUE APPS_TS_TX_IDX PROGRAM_ID
SESSION_ID
USER_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y Session identifier
PROGRAM_ID NUMBER
Y Program identifier
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
USER_ID NUMBER (15)
User identifier
ICX_SESSION_ID NUMBER

Session identifier

[top of page]

BSC.BSC_CURRENT_SESSIONS does not reference any database object

BSC.BSC_CURRENT_SESSIONS is referenced by following:

APPS
SYNONYM - BSC_CURRENT_SESSIONS

[top of page]

Table: BSC_DB_CALCULATIONS

Description: Calculation configuration by table
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_CALCULATIONS.TABLE_NAME BSC_DB_TABLES
Comments

BSC_DB_CALCULATIONS stores information about configuration of calculations by table. Each row includes table name, calculation type and parameters.

Indexes
Index Type Tablespace Column
BSC_DB_CALCULATIONS_N1 NONUNIQUE APPS_TS_TX_IDX TABLE_NAME
CALCULATION_TYPE
BSC_DB_CALCULATIONS_N2 NONUNIQUE APPS_TS_TX_IDX CALCULATION_TYPE
PARAMETER1
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (30) Y Table name
CALCULATION_TYPE NUMBER (1) Y Calculation type
PARAMETER1 VARCHAR2 (250)
Parameter 1
PARAMETER2 VARCHAR2 (250)
Parameter 2
PARAMETER3 VARCHAR2 (250)
Parameter 3
PARAMETER4 VARCHAR2 (250)
Parameter 4
PARAMETER5 VARCHAR2 (250)
Parameter 5
PARAMETER6 VARCHAR2 (250)
Parameter 6
PARAMETER7 VARCHAR2 (250)
Parameter 7
PARAMETER8 VARCHAR2 (250)
Parameter 8
PARAMETER9 VARCHAR2 (250)
Parameter 9
PARAMETER10 VARCHAR2 (250)
Parameter 10

[top of page]

BSC.BSC_DB_CALCULATIONS does not reference any database object

BSC.BSC_DB_CALCULATIONS is referenced by following:

APPS
SYNONYM - BSC_DB_CALCULATIONS

[top of page]

Table: BSC_DB_CALENDAR

Description: Calendar information
Comments

BSC_DB_CALENDAR stores information about calendar. Each row includes a calendar day which is identified by calendar Year, calendar month and calendar day.

Indexes
Index Type Tablespace Column
BSC_DB_CALENDAR_N1 NONUNIQUE APPS_TS_TX_IDX CALENDAR_ID
CALENDAR_YEAR
CALENDAR_MONTH
CALENDAR_DAY
YEAR
SEMESTER
QUARTER
BIMESTER
MONTH
WEEK52
WEEK4
DAY365
DAY30
Columns
Name Datatype Length Mandatory Comments
CALENDAR_YEAR NUMBER (5) Y Calendar year
CALENDAR_MONTH NUMBER (3) Y Calendar month
CALENDAR_DAY NUMBER (3) Y Calendar day
YEAR NUMBER (5) Y Year
SEMESTER NUMBER (3) Y Semester
QUARTER NUMBER (3) Y Quarter
BIMESTER NUMBER (3) Y Bimester
MONTH NUMBER (3) Y Month
WEEK52 NUMBER (3) Y Week at Year to date
WEEK4 NUMBER (3) Y Week at Month to date
DAY365 NUMBER (3) Y Day at Year to date
DAY30 NUMBER (3) Y Day at Month to date
HOLYDAY_FLAG NUMBER (1)
Holiday Flag. 1= yes, 0 no
WORKDAY_FLAG NUMBER (1)
Workday Flag. 1= yes, 0 no
CALENDAR_ID NUMBER
Y Calendar id
CUSTOM_1 NUMBER (3)
Custom Periodicity
CUSTOM_2 NUMBER (3)
Custom Periodicity 2
CUSTOM_3 NUMBER (3)
Custom Periodicity 3
CUSTOM_4 NUMBER (3)
Custom Periodicity 4
CUSTOM_5 NUMBER (3)
Custom Periodicity 5
CUSTOM_6 NUMBER (3)
Custom Periodicity 6
CUSTOM_7 NUMBER (3)
Custom Periodicity 7
CUSTOM_8 NUMBER (3)
Custom Periodicity 8
CUSTOM_9 NUMBER (3)
Custom Periodicity 9
CUSTOM_10 NUMBER (3)
Custom Periodicity 10
CUSTOM_11 NUMBER (3)
Custom Periodicity 11
CUSTOM_12 NUMBER (3)
Custom Periodicity 12
CUSTOM_13 NUMBER (3)
Custom Periodicity 13
CUSTOM_14 NUMBER (3)
Custom Periodicity 14
CUSTOM_15 NUMBER (3)
Custom Periodicity 15
CUSTOM_16 NUMBER (3)
Custom Periodicity 16
CUSTOM_17 NUMBER (3)
Custom Periodicity 17
CUSTOM_18 NUMBER (3)
Custom Periodicity 18
CUSTOM_19 NUMBER (3)
Custom Periodicity 19
CUSTOM_20 NUMBER (3)
Custom Periodicity 20

[top of page]

BSC.BSC_DB_CALENDAR does not reference any database object

BSC.BSC_DB_CALENDAR is referenced by following:

APPS
SYNONYM - BSC_DB_CALENDAR

[top of page]

Table: BSC_DB_LOADER_CONTROL

Description: Loader control information
Primary Key: BSC_DB_LOADER_CONTROL_PK
  1. INPUT_TABLE_NAME
  2. PROCESS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_LOADER_CONTROL.INPUT_TABLE_NAME BSC_DB_TABLES
Comments

BSC_DB_LOADER_CONTROL stores information about loader process.

Indexes
Index Type Tablespace Column
BSC_DB_LOADER_CONTROL_U1 UNIQUE APPS_TS_TX_IDX PROCESS_ID
INPUT_TABLE_NAME
Columns
Name Datatype Length Mandatory Comments
PROCESS_ID NUMBER
Y Process identifier
INPUT_TABLE_NAME VARCHAR2 (30) Y Input table name
STATUS VARCHAR2 (1)
Process status
ERROR_CODE VARCHAR2 (25)
Error code
STAGE VARCHAR2 (1)
Stage
LAST_STAGE_FLAG NUMBER (1)
Last executed stage

[top of page]

BSC.BSC_DB_LOADER_CONTROL does not reference any database object

BSC.BSC_DB_LOADER_CONTROL is referenced by following:

APPS
SYNONYM - BSC_DB_LOADER_CONTROL

[top of page]

Table: BSC_DB_MEASURE_COLS_TL

Description: Measure columns information
Primary Key: BSC_DB_MEASURE_COLS_TL_PK
  1. MEASURE_COL
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID BSC_DB_MEASURE_GROUPS_TL
Comments

BSC_DB_MEASURE_COLS_TL stores information about measure columns.

Indexes
Index Type Tablespace Column
BSC_DB_MEASURE_COLS_TL_U1 UNIQUE APPS_TS_TX_IDX MEASURE_COL
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
MEASURE_COL VARCHAR2 (30) Y Measure column
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
HELP VARCHAR2 (150) Y Measure column description (Max 50 chars)
MEASURE_GROUP_ID NUMBER (5) Y Measure group identifier
PROJECTION_ID NUMBER (3) Y Projection identifier
MEASURE_TYPE NUMBER (3)
Measure Type: 1=Normal, 2=Balance Measure

[top of page]

BSC.BSC_DB_MEASURE_COLS_TL does not reference any database object

BSC.BSC_DB_MEASURE_COLS_TL is referenced by following:

APPS
SYNONYM - BSC_DB_MEASURE_COLS_TL

[top of page]

Table: BSC_DB_MEASURE_GROUPS_TL

Description: Measure groups information
Primary Key: BSC_DB_MEASURE_GROUPS_TL_PK
  1. MEASURE_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_DB_MEASURE_COLS_TL.MEASURE_GROUP_ID BSC_DB_MEASURE_GROUPS_TL
Comments

BSC_DB_MEASURE_COLS_TL stores information about measure groups.

Indexes
Index Type Tablespace Column
BSC_DB_MEASURE_GROUPS_TL_U1 UNIQUE APPS_TS_TX_IDX MEASURE_GROUP_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
MEASURE_GROUP_ID NUMBER (5) Y Measure group identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
HELP VARCHAR2 (150) Y Measure group description (Max 50 chars)
SHORT_NAME VARCHAR2 (30)
Short name

[top of page]

BSC.BSC_DB_MEASURE_GROUPS_TL does not reference any database object

BSC.BSC_DB_MEASURE_GROUPS_TL is referenced by following:

APPS
SYNONYM - BSC_DB_MEASURE_GROUPS_TL

[top of page]

Table: BSC_DB_PROCESS_CONTROL

Description: Process control information
Primary Key: BSC_DB_PROCESS_CONTROL_PK
  1. PROCESS_ID
Comments

BSC_DB_PROCESS_CONTROL stores information about process.

Indexes
Index Type Tablespace Column
BSC_DB_PROCESS_CONTROL_U1 UNIQUE APPS_TS_TX_IDX PROCESS_ID
Columns
Name Datatype Length Mandatory Comments
PROCESS_ID NUMBER
Y Process identifier
PROCESS_NAME VARCHAR2 (1) Y Process name
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
STATUS VARCHAR2 (1)
Process status
LOG_FILE_LOCATION VARCHAR2 (500)
Log file location
START_TIME DATE

Start time
END_TIME DATE

End time
DESCRIPTION VARCHAR2 (250)
Input Table Names

[top of page]

BSC.BSC_DB_PROCESS_CONTROL does not reference any database object

BSC.BSC_DB_PROCESS_CONTROL is referenced by following:

APPS
SYNONYM - BSC_DB_PROCESS_CONTROL

[top of page]

Table: BSC_DB_RESERVED_WORDS

Description: Reserved words
Primary Key: BSC_DB_RESERVED_WORDS_PK
  1. TYPE
  2. WORD
Comments

BSC_DB_RESERVED_WORDS stores all the reserved words that cannot be used as column name ,table name , dataset name , measure name, etc.

Indexes
Index Type Tablespace Column
BSC_DB_RESERVED_WORDS_U1 UNIQUE APPS_TS_SEED TYPE
WORD
Columns
Name Datatype Length Mandatory Comments
TYPE NUMBER (3) Y Type 1 = Function, 2 =Operator
WORD VARCHAR2 (60) Y Reserved word

[top of page]

BSC.BSC_DB_RESERVED_WORDS does not reference any database object

BSC.BSC_DB_RESERVED_WORDS is referenced by following:

APPS
SYNONYM - BSC_DB_RESERVED_WORDS

[top of page]

Table: BSC_DB_TABLES

Description: Data tables information
Primary Key: BSC_DB_TABLES_PK
  1. TABLE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_TABLES.PERIODICITY_ID BSC_SYS_PERIODICITIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_DB_CALCULATIONS.TABLE_NAME BSC_DB_TABLES
BSC_DB_LOADER_CONTROL.INPUT_TABLE_NAME BSC_DB_TABLES
BSC_DB_TABLES_COLS.TABLE_NAME BSC_DB_TABLES
BSC_DB_TABLES_RELS.TABLE_NAME BSC_DB_TABLES
BSC_DB_TABLES_RELS.SOURCE_TABLE_NAME BSC_DB_TABLES
BSC_KPI_DATA_TABLES.TABLE_NAME BSC_DB_TABLES
Comments

BSC_DB_TABLES stores information about data tables. Each row includes table name, table type such as input table or system table, table periodicity and current period.

Indexes
Index Type Tablespace Column
BSC_DB_TABLES_U1 UNIQUE APPS_TS_TX_IDX TABLE_NAME
BSC_DB_TABLES_N1 NONUNIQUE APPS_TS_TX_IDX PERIODICITY_ID
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (30) Y Table name
TABLE_TYPE NUMBER (1) Y Table type
PERIODICITY_ID NUMBER (5) Y Periodicity identifier
GENERATION_TYPE NUMBER (3)
1= Default
PROJECT_FLAG NUMBER (1)
Projection Flag 1= Yes, 0 = No
NUM_OF_YEARS NUMBER (3)
Number of years
PREVIOUS_YEARS NUMBER (3)
Number of previous years
SOURCE_DATA_TYPE NUMBER (3)
Data source type 0=Database, 1=Text File, 2=Excel
SOURCE_FILE_NAME VARCHAR2 (500)
File name
CURRENT_PERIOD NUMBER (5)
Current update period
CURRENT_SUBPERIOD NUMBER (3)
Current update sub period
SOURCE_FILE_DATE DATE

File date
EDW_FLAG NUMBER (1)
Flag that indicates if the table is EDW
TARGET_FLAG NUMBER (1)
Target Flag
PROPERTIES VARCHAR2 (4000)

[top of page]

BSC.BSC_DB_TABLES does not reference any database object

BSC.BSC_DB_TABLES is referenced by following:

APPS
SYNONYM - BSC_DB_TABLES

[top of page]

Table: BSC_DB_TABLES_COLS

Description: Data table columns information
Primary Key: BSC_DB_TABLES_COLS_PK
  1. COLUMN_NAME
  2. TABLE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_TABLES_COLS.TABLE_NAME BSC_DB_TABLES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_DB_VALIDATION.INPUT_TABLE_NAME
BSC_DB_VALIDATION.COLUMN_NAME 		BSC_DB_TABLES_COLS
Comments

BSC_DB_TABLES_COLS stores information about data table columns. Each row includes table name, colunm type, column name and projection identifier.

Indexes
Index Type Tablespace Column
BSC_DB_TABLES_COLS_U1 UNIQUE APPS_TS_TX_IDX TABLE_NAME
COLUMN_TYPE
COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (30) Y Table name
COLUMN_TYPE VARCHAR2 (1) Y Column type
COLUMN_NAME VARCHAR2 (30) Y Column name
PROJECTION_ID NUMBER (3)
Projection identifier
SOURCE_COLUMN VARCHAR2 (30)
Source Column
SOURCE_FORMULA VARCHAR2 (4000)
Formula source column
SOURCE VARCHAR2 (100)

[top of page]

BSC.BSC_DB_TABLES_COLS does not reference any database object

BSC.BSC_DB_TABLES_COLS is referenced by following:

APPS
SYNONYM - BSC_DB_TABLES_COLS

[top of page]

Table: BSC_DB_TABLES_DISPLAY

Description: BSC_DB_TABLES_DISPLAY Stores information about data tables, to improve performance and used in UI.
Comments

BSC DB Tables Display

Indexes
Index Type Tablespace Column
BSC_DB_TABLES_DISPLAY_U1 UNIQUE APPS_TS_TX_IDX TABLE_NAME_DISPLAY
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME_DISPLAY VARCHAR2 (30)
Table Name Display
TABLE_TYPE NUMBER (1)
Table Type
DISPLAY_TYPE VARCHAR2 (50)
Display Type
PHYSICAL_TYPE VARCHAR2 (50)
Physical Type

[top of page]

BSC.BSC_DB_TABLES_DISPLAY does not reference any database object

BSC.BSC_DB_TABLES_DISPLAY is referenced by following:

APPS
SYNONYM - BSC_DB_TABLES_DISPLAY

[top of page]

Table: BSC_DB_TABLES_RELS

Description: Table relationships information
Primary Key: BSC_DB_TABLES_RELS_PK
  1. SOURCE_TABLE_NAME
  2. TABLE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_TABLES_RELS.TABLE_NAME BSC_DB_TABLES
BSC_DB_TABLES_RELS.SOURCE_TABLE_NAME BSC_DB_TABLES
Comments

BSC_DB_TABLES_RELS stores information about relationships between data tables.

Indexes
Index Type Tablespace Column
BSC_DB_TABLES_RELS_U1 UNIQUE APPS_TS_TX_IDX TABLE_NAME
SOURCE_TABLE_NAME
BSC_DB_TABLES_RELS_U2 UNIQUE APPS_TS_TX_IDX SOURCE_TABLE_NAME
TABLE_NAME
BSC_DB_TABLES_RELS_N2 NONUNIQUE APPS_TS_TX_IDX SYS_NC00004$
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME VARCHAR2 (30) Y Table name
SOURCE_TABLE_NAME VARCHAR2 (30) Y Source table name
RELATION_TYPE NUMBER (1)
Relation Type

[top of page]

BSC.BSC_DB_TABLES_RELS does not reference any database object

BSC.BSC_DB_TABLES_RELS is referenced by following:

APPS
SYNONYM - BSC_DB_TABLES_RELS

[top of page]

Table: BSC_DB_TABLES_RELS_DISPLAY

Description: BSC_DB_TABLES_RELS_DISPLAY stores information about Relationship between data tables, to improve performance and used in UI.
Comments

BSC DB Tables Rels Display

Indexes
Index Type Tablespace Column
BSC_DB_TABLES_RELS_DISPLAY_U1 UNIQUE APPS_TS_TX_IDX SOURCE_TABLE_NAME_DISPLAY
TABLE_NAME_DISPLAY
BSC_DB_TABLES_RELS_DISPLAY_U2 UNIQUE APPS_TS_TX_IDX TABLE_NAME_DISPLAY
SOURCE_TABLE_NAME_DISPLAY
Columns
Name Datatype Length Mandatory Comments
TABLE_NAME_DISPLAY VARCHAR2 (30)
Table Name Display
SOURCE_TABLE_NAME_DISPLAY VARCHAR2 (30)
Source Table Name
RELATION_TYPE NUMBER (1)
Relation Type

[top of page]

BSC.BSC_DB_TABLES_RELS_DISPLAY does not reference any database object

BSC.BSC_DB_TABLES_RELS_DISPLAY is referenced by following:

APPS
SYNONYM - BSC_DB_TABLES_RELS_DISPLAY

[top of page]

Table: BSC_DB_VALIDATION

Description: Log of the input table validation error
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_DB_VALIDATION.INPUT_TABLE_NAME
BSC_DB_VALIDATION.COLUMN_NAME 		BSC_DB_TABLES_COLS
Comments

BSC_DB_VALIDATION stores information about the input table validation errors.

Indexes
Index Type Tablespace Column
BSC_DB_VALIDATION_N1 NONUNIQUE APPS_TS_TX_IDX INPUT_TABLE_NAME
Columns
Name Datatype Length Mandatory Comments
INPUT_TABLE_NAME VARCHAR2 (30) Y Input table
COLUMN_NAME VARCHAR2 (250)
Column name
INVALID_CODE VARCHAR2 (250)
Invalid code

[top of page]

BSC.BSC_DB_VALIDATION does not reference any database object

BSC.BSC_DB_VALIDATION is referenced by following:

APPS
SYNONYM - BSC_DB_VALIDATION

[top of page]

Table: BSC_DB_WEEK_MAPS

Description: Mapping information between week 4 and week 54
Comments

BSC_DB_WEEK_MAPS stores information about mapping between week 4 and week 54.

Columns
Name Datatype Length Mandatory Comments
YEAR NUMBER (5) Y Year
MONTH NUMBER (3) Y Month
WEEK NUMBER (3) Y Week at Month to Date
WEEK52 NUMBER (3) Y Week at Year to Date
CALENDAR_ID NUMBER

Calendar id

[top of page]

BSC.BSC_DB_WEEK_MAPS does not reference any database object

BSC.BSC_DB_WEEK_MAPS is referenced by following:

APPS
SYNONYM - BSC_DB_WEEK_MAPS

[top of page]

Table: BSC_EDW_CALENDAR_TYPE_TL

Description: EDW translated calendar type information
Primary Key: BSC_EDW_CALENDAR_TYPE_TL_PK
  1. EDW_CALENDAR_TYPE_ID
  2. LANGUAGE
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BSC_EDW_CALENDAR_TYPE_TL_U1 UNIQUE APPS_TS_ARCHIVE EDW_CALENDAR_TYPE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
EDW_CALENDAR_TYPE_ID NUMBER
Y EDW calendar type identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (150)
Calendar Type name
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_EDW_CALENDAR_TYPE_TL does not reference any database object

BSC.BSC_EDW_CALENDAR_TYPE_TL is referenced by following:

APPS
SYNONYM - BSC_EDW_CALENDAR_TYPE_TL

[top of page]

Table: BSC_EDW_PERIODS_TL

Description: EDW period by periodicity information
Primary Key: BSC_EDW_PERIODS_TL_PK
  1. LANGUAGE
  2. PERIOD_ID
  3. YEAR
  4. PERIODICITY_ID
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BSC_EDW_PERIODS_TL_U1 UNIQUE APPS_TS_ARCHIVE YEAR
PERIODICITY_ID
PERIOD_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
YEAR NUMBER (4) Y Year
PERIODICITY_ID NUMBER (5) Y Periodicity identifier
PERIOD_ID NUMBER (5) Y Period identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (90)
Period name
SHORT_NAME VARCHAR2 (45)
Period Short Name

[top of page]

BSC.BSC_EDW_PERIODS_TL does not reference any database object

BSC.BSC_EDW_PERIODS_TL is referenced by following:

APPS
SYNONYM - BSC_EDW_PERIODS_TL

[top of page]

Table: BSC_INSTALL_LOGS

Description: Install log for personal Mode
Comments

BSC_INSTALL_LOGS stores information about installation log for personal mode.

Columns
Name Datatype Length Mandatory Comments
CODE NUMBER (3)
Code
MESSAGE VARCHAR2 (2000)
Message
LAST_UPDATE_DATE DATE

Standard Who column

[top of page]

BSC.BSC_INSTALL_LOGS does not reference any database object

BSC.BSC_INSTALL_LOGS is referenced by following:

APPS
SYNONYM - BSC_INSTALL_LOGS

[top of page]

Table: BSC_KPIS_B

Description: Key performance indicator information
Primary Key: BSC_KPIS_B_PK
  1. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPIS_B.PERIODICITY_ID BSC_SYS_PERIODICITIES
BSC_KPIS_B.SOURCE_INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPIS_B.SOURCE_INDICATOR BSC_KPIS_B
BSC_KPIS_TL.INDICATOR BSC_KPIS_B
BSC_KPI_ANALYSIS_GROUPS.INDICATOR BSC_KPIS_B
BSC_KPI_ANALYSIS_MEASURES_B.INDICATOR BSC_KPIS_B
BSC_KPI_CALCULATIONS.INDICATOR BSC_KPIS_B
BSC_KPI_CAUSE_EFFECT_RELS.CAUSE_INDICATOR BSC_KPIS_B
BSC_KPI_CAUSE_EFFECT_RELS.EFFECT_INDICATOR BSC_KPIS_B
BSC_KPI_COMMENTS.INDICATOR BSC_KPIS_B
BSC_KPI_DIM_SETS_TL.INDICATOR BSC_KPIS_B
BSC_KPI_MM_CONTROLS.INDICATOR BSC_KPIS_B
BSC_KPI_PERIODICITIES.INDICATOR BSC_KPIS_B
BSC_KPI_PROPERTIES.INDICATOR BSC_KPIS_B
BSC_KPI_SHELL_CMDS_TL.INDICATOR BSC_KPIS_B
BSC_KPI_SUBTITLES_TL.INDICATOR BSC_KPIS_B
BSC_KPI_TREE_NODES_B.INDICATOR BSC_KPIS_B
BSC_TAB_INDICATORS.INDICATOR BSC_KPIS_B
Comments

BSC_KPIS_B stores information about indicators. Each row includes values that identify a particular kpi such as indicator code, indicator type, prototype flag, and prototype color.

Indexes
Index Type Tablespace Column
BSC_KPIS_B_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
BSC_KPIS_B_N1 NONUNIQUE APPS_TS_TX_IDX CSF_ID
BSC_KPIS_B_N2 NONUNIQUE APPS_TS_TX_IDX IND_GROUP_ID
BSC_KPIS_B_N3 NONUNIQUE APPS_TS_TX_IDX PERIODICITY_ID
BSC_KPIS_B_N4 NONUNIQUE APPS_TS_TX_IDX BM_GROUP_ID
BSC_KPIS_B_N5 NONUNIQUE APPS_TS_TX_IDX PROTOTYPE_FLAG
BSC_KPIS_B_N6 NONUNIQUE APPS_TS_TX_IDX SHORT_NAME
BSC_KPIS_B_N7 NONUNIQUE APPS_TS_TX_IDX COLOR_ROLLUP_TYPE
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
CSF_ID NUMBER (3) Y Critical Sucess Factor identifier
IND_GROUP_ID NUMBER (5) Y Indicator group identifier
DISP_ORDER NUMBER (3) Y Order when it is displayed inside of CSF
PROTOTYPE_FLAG NUMBER (3) Y Prototype flag
INDICATOR_TYPE NUMBER (3) Y Indicator type
CONFIG_TYPE NUMBER (3) Y Indicator configuration
PERIODICITY_ID NUMBER (5) Y Default periodicity
BM_GROUP_ID NUMBER (3) Y Benchmark group identifier
APPLY_COLOR_FLAG NUMBER (3) Y Apply color flag
PROTOTYPE_COLOR VARCHAR2 (1)
Prototype color
SHARE_FLAG NUMBER (3) Y Share indicator flag
SOURCE_INDICATOR NUMBER (5)
Master indicator code
PUBLISH_FLAG NUMBER (3)
Flag that indicates if the indicator is showed by iviewer
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
EDW_FLAG NUMBER (1)
Flag that indicates if the kpi is EDW
CALENDAR_ID NUMBER

Calendar Identifier
SHORT_NAME VARCHAR2 (30)
Short name
PROTOTYPE_COLOR_ID NUMBER (8)
Prototype Color for the Objective
COLOR_ROLLUP_TYPE VARCHAR2 (30)
Defines the rollup type for the Objective from the underlying KPI Measures. Valid values are: WORST, BEST, MOST_FREQUENT, WEIGHTED_AVERAGE, DEFAULT_KPI
WEIGHTED_COLOR_METHOD NUMBER

Color Method for Weighted Average calculations for the Objective. Can be either: 1- INCREASING_GOOD 2- DECREASING_GOOD 3- WITHIN_RANGE 4 - FLEXIBLE
PROTOTYPE_TREND_ID NUMBER

Prototype Trend Id for the Objective

[top of page]

BSC.BSC_KPIS_B does not reference any database object

BSC.BSC_KPIS_B is referenced by following:

APPS
SYNONYM - BSC_KPIS_B

[top of page]

Table: BSC_KPIS_TL

Description: Translated Key performance indicator information
Primary Key: BSC_KPIS_TL_PK
  1. INDICATOR
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPIS_TL.INDICATOR BSC_KPIS_B
Comments

BSC_KPIS_TL stores translated information about indicators. Each row includes the name and the help of the indicator.

Indexes
Index Type Tablespace Column
BSC_KPIS_TL_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (150) Y Indicator name
HELP VARCHAR2 (150) Y Indicator help

[top of page]

BSC.BSC_KPIS_TL does not reference any database object

BSC.BSC_KPIS_TL is referenced by following:

APPS
SYNONYM - BSC_KPIS_TL

[top of page]

Table: BSC_KPI_ANALYSIS_GROUPS

Description: Analysis groups information
Primary Key: BSC_KPI_ANALYSIS_GROUPS_PK
  1. ANALYSIS_GROUP_ID
  2. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_GROUPS.INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPTIONS_B.INDICATOR
BSC_KPI_ANALYSIS_OPTIONS_B.ANALYSIS_GROUP_ID 		BSC_KPI_ANALYSIS_GROUPS
Comments

BSC_KPI_ANALYSIS_GROUP stores information about analysis groups by indicator. Each row includes values that identify a particular analysis group such as indicator code, analysis group identifier and number of analysis options.

Indexes
Index Type Tablespace Column
BSC_KPI_ANALYSIS_GROUPS_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
ANALYSIS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
ANALYSIS_GROUP_ID NUMBER (3) Y Analysis group identifier
NUM_OF_OPTIONS NUMBER (3) Y Number of analysis options
DEPENDENCY_FLAG NUMBER (3) Y Dependency flag
PARENT_ANALYSIS_ID NUMBER (3) Y Analysis parent group identifier
CHANGE_DIM_SET NUMBER (3)
If it will change dimension set
DEFAULT_VALUE NUMBER (3) Y Analysis option default
SHORT_NAME VARCHAR2 (30)
Short name

[top of page]

BSC.BSC_KPI_ANALYSIS_GROUPS does not reference any database object

BSC.BSC_KPI_ANALYSIS_GROUPS is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_GROUPS

[top of page]

Table: BSC_KPI_ANALYSIS_MEASURES_B

Description: Analysis measures information
Primary Key: BSC_KPI_ANALYSIS_MEASURES_B_PK
  1. ANALYSIS_OPTION0
  2. ANALYSIS_OPTION1
  3. INDICATOR
  4. SERIES_ID
  5. ANALYSIS_OPTION2
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_MEASURES_B.INDICATOR BSC_KPIS_B
BSC_KPI_ANALYSIS_MEASURES_B.DATASET_ID BSC_SYS_DATASETS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION2
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION0
BSC_KPI_ANALYSIS_MEASURES_TL.SERIES_ID
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION1
BSC_KPI_ANALYSIS_MEASURES_TL.INDICATOR 		BSC_KPI_ANALYSIS_MEASURES_B
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION2
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION0
BSC_KPI_SERIES_COLORS.SERIES_ID
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION1
BSC_KPI_SERIES_COLORS.INDICATOR 		BSC_KPI_ANALYSIS_MEASURES_B
Comments

BSC_KPI_ANALYSIS_MEASURES_B stores information about analysis measures by indicator. Each row includes values that identify a particular analysis measure such as indicator code, analysis options, series identifier, dataset identifier and default value.

Indexes
Index Type Tablespace Column
BSC_KPI_ANALYSIS_MEASURES_B_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
ANALYSIS_OPTION0
ANALYSIS_OPTION1
ANALYSIS_OPTION2
SERIES_ID
BSC_KPI_ANALYSIS_MEASURES_B_U2 UNIQUE APPS_TS_TX_IDX KPI_MEASURE_ID
BSC_KPI_ANALYSIS_MEASURES_B_N1 NONUNIQUE APPS_TS_TX_IDX DATASET_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
ANALYSIS_OPTION0 NUMBER (3) Y Analysis option for analysis group 0
ANALYSIS_OPTION1 NUMBER (3) Y Analysis option for analysis group 1
ANALYSIS_OPTION2 NUMBER (3) Y Analysis option for analysis group 2
SERIES_ID NUMBER (3) Y Series identifier
DATASET_ID NUMBER (5) Y Dataset identifier
AXIS NUMBER (3) Y Axis 1= Left , 2 = Rigth
SERIES_TYPE NUMBER (3) Y Series type
STACK_SERIES_ID NUMBER (3)
Base series identifier to stack
BM_FLAG NUMBER (3) Y If benchmark applies
BUDGET_FLAG NUMBER (3) Y If budget applies
DEFAULT_VALUE NUMBER (3) Y Preselected by default
SERIES_COLOR NUMBER (11) Y Series color
BM_COLOR NUMBER (11) Y Benchmark color
PROTOTYPE_FLAG NUMBER (3)
Base series identifier to stack
KPI_MEASURE_ID NUMBER

Unique key for the KPI Measure. Stands for the combination of AO1, AO2, AO3 and Data Series

[top of page]

BSC.BSC_KPI_ANALYSIS_MEASURES_B does not reference any database object

BSC.BSC_KPI_ANALYSIS_MEASURES_B is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_B

[top of page]

Table: BSC_KPI_ANALYSIS_MEASURES_TL

Description: Translated analysis measures information
Primary Key: BSC_KPI_ANALYSIS_MEASURESTL_PK
  1. ANALYSIS_OPTION0
  2. ANALYSIS_OPTION1
  3. INDICATOR
  4. SERIES_ID
  5. LANGUAGE
  6. ANALYSIS_OPTION2
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION2
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION0
BSC_KPI_ANALYSIS_MEASURES_TL.SERIES_ID
BSC_KPI_ANALYSIS_MEASURES_TL.ANALYSIS_OPTION1
BSC_KPI_ANALYSIS_MEASURES_TL.INDICATOR 		BSC_KPI_ANALYSIS_MEASURES_B
Comments

BSC_KPI_ANALYSIS_MEASURES_TL stores translated information about analysis measures. Each row includes the data series name and the data series help .

Indexes
Index Type Tablespace Column
BSC_KPI_ANALYSIS_MEASURESTL_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
ANALYSIS_OPTION0
ANALYSIS_OPTION1
ANALYSIS_OPTION2
SERIES_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
ANALYSIS_OPTION0 NUMBER (3) Y Analysis option for analysis group 0
ANALYSIS_OPTION1 NUMBER (3) Y Analysis option for analysis group 1
ANALYSIS_OPTION2 NUMBER (3) Y Analysis option for analysis group 2
SERIES_ID NUMBER (3) Y Series identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (255) Y Data series name (Max 20 chars)
HELP VARCHAR2 (1024) Y Data series help (Max 80 chars)

[top of page]

BSC.BSC_KPI_ANALYSIS_MEASURES_TL does not reference any database object

BSC.BSC_KPI_ANALYSIS_MEASURES_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_TL

[top of page]

Table: BSC_KPI_ANALYSIS_OPTIONS_B

Description: Analysis options information
Primary Key: BSC_KPI_ANALYSIS_OPTIONS_B_PK
  1. ANALYSIS_GROUP_ID
  2. OPTION_ID
  3. INDICATOR
  4. GRANDPARENT_OPTION_ID
  5. PARENT_OPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPTIONS_B.INDICATOR
BSC_KPI_ANALYSIS_OPTIONS_B.ANALYSIS_GROUP_ID 		BSC_KPI_ANALYSIS_GROUPS
BSC_KPI_ANALYSIS_OPTIONS_B.DIM_SET_ID
BSC_KPI_ANALYSIS_OPTIONS_B.INDICATOR 		BSC_KPI_DIM_SETS_TL
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPTIONS_TL.OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.PARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.GRANDPARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.INDICATOR
BSC_KPI_ANALYSIS_OPTIONS_TL.ANALYSIS_GROUP_ID 		BSC_KPI_ANALYSIS_OPTIONS_B
BSC_KPI_ANALYSIS_OPT_USER.OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.PARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.GRANDPARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.INDICATOR
BSC_KPI_ANALYSIS_OPT_USER.ANALYSIS_GROUP_ID 		BSC_KPI_ANALYSIS_OPTIONS_B
Comments

BSC_KPI_ANALYSIS_OPTIONS_B stores information about analysis options by indicator. Each row includes values that identify a particular analysis option such as indicator code, analysis group , analysis option, dimension set and default value.

Indexes
Index Type Tablespace Column
BSC_KPI_ANALYSIS_OPTIONS_B_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
ANALYSIS_GROUP_ID
OPTION_ID
PARENT_OPTION_ID
GRANDPARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_B_N1 NONUNIQUE APPS_TS_TX_IDX DIM_SET_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
ANALYSIS_GROUP_ID NUMBER (3) Y Analysis group identifier
OPTION_ID NUMBER (3) Y Analysis option identifier
PARENT_OPTION_ID NUMBER (3) Y Analysis parent option identifier
GRANDPARENT_OPTION_ID NUMBER (3) Y Analysis grand parent option identifier
DIM_SET_ID NUMBER (3) Y Dimension set identifier
USER_LEVEL0 NUMBER (3)
Visibility status for design level 0
USER_LEVEL1 NUMBER (3)
Visibility status for design level 1
USER_LEVEL1_DEFAULT NUMBER (3)
Visibility default status for design level 1
USER_LEVEL2 NUMBER (3)
Visibility status for design level 2
USER_LEVEL2_DEFAULT NUMBER (3)
Visibility default status for design level 2
SHORT_NAME VARCHAR2 (30)
Short name

[top of page]

BSC.BSC_KPI_ANALYSIS_OPTIONS_B does not reference any database object

BSC.BSC_KPI_ANALYSIS_OPTIONS_B is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_B

[top of page]

Table: BSC_KPI_ANALYSIS_OPTIONS_TL

Description: Translated analysis options information
Primary Key: BSC_KPI_ANALYSIS_OPTIONS_TL_PK
  1. ANALYSIS_GROUP_ID
  2. INDICATOR
  3. GRANDPARENT_OPTION_ID
  4. LANGUAGE
  5. PARENT_OPTION_ID
  6. OPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPTIONS_TL.OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.PARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.GRANDPARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPTIONS_TL.INDICATOR
BSC_KPI_ANALYSIS_OPTIONS_TL.ANALYSIS_GROUP_ID 		BSC_KPI_ANALYSIS_OPTIONS_B
Comments

BSC_KPI_ANALYSIS_OPTIONS_TL stores translated information about analysis options. Each row includes the analysis option name and analysis option help.

Indexes
Index Type Tablespace Column
BSC_KPI_ANALYSIS_OPTIONS_TL_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
ANALYSIS_GROUP_ID
OPTION_ID
PARENT_OPTION_ID
GRANDPARENT_OPTION_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
ANALYSIS_GROUP_ID NUMBER (3) Y Analysis group identifier
OPTION_ID NUMBER (3) Y Analysis option identifier
PARENT_OPTION_ID NUMBER (3) Y Analysis parent option identifier
GRANDPARENT_OPTION_ID NUMBER (3) Y Analysis grand parent option identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (255) Y Analysis option name (Max 25 chars)
HELP VARCHAR2 (1024) Y Analysis option help (Max 80 chars)

[top of page]

BSC.BSC_KPI_ANALYSIS_OPTIONS_TL does not reference any database object

BSC.BSC_KPI_ANALYSIS_OPTIONS_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_TL

[top of page]

Table: BSC_KPI_ANALYSIS_OPT_USER

Description: Analysis options information by user
Primary Key: BSC_KPI_ANALYSIS_OPT_USER_PK
  1. ANALYSIS_GROUP_ID
  2. OPTION_ID
  3. PARENT_OPTION_ID
  4. INDICATOR
  5. GRANDPARENT_OPTION_ID
  6. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPT_USER.USER_ID BSC_USERS
BSC_KPI_ANALYSIS_OPT_USER.OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.PARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.GRANDPARENT_OPTION_ID
BSC_KPI_ANALYSIS_OPT_USER.INDICATOR
BSC_KPI_ANALYSIS_OPT_USER.ANALYSIS_GROUP_ID 		BSC_KPI_ANALYSIS_OPTIONS_B
Comments

BSC_KPI_ANALYSIS_OPT_USER stores customized information about analysis options by user such as display flag.

Indexes
Index Type Tablespace Column
BSC_KPI_ANALYSIS_OPT_USER_U1 UNIQUE APPS_TS_TX_IDX USER_ID
INDICATOR
ANALYSIS_GROUP_ID
OPTION_ID
PARENT_OPTION_ID
GRANDPARENT_OPTION_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y User identifier
INDICATOR NUMBER (5) Y Indicator code
ANALYSIS_GROUP_ID NUMBER (3) Y Analysis group identifier
OPTION_ID NUMBER (3) Y Analysis option identifier
PARENT_OPTION_ID NUMBER (3) Y Analysis parent option identifier
GRANDPARENT_OPTION_ID NUMBER (3) Y Analysis grand parent option identifier
DISPLAY_FLAG NUMBER (3) Y Visible status
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_KPI_ANALYSIS_OPT_USER does not reference any database object

BSC.BSC_KPI_ANALYSIS_OPT_USER is referenced by following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_OPT_USER

[top of page]

Table: BSC_KPI_CALCULATIONS

Description: Calculations information
Primary Key: BSC_KPI_CALCULATIONS_PK
  1. CALCULATION_ID
  2. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_CALCULATIONS.INDICATOR BSC_KPIS_B
BSC_KPI_CALCULATIONS.CALCULATION_ID BSC_SYS_CALCULATIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_CALCULATIONS_USER.INDICATOR
BSC_KPI_CALCULATIONS_USER.CALCULATION_ID 		BSC_KPI_CALCULATIONS
Comments

BSC_KPI_CALCULATIONS stores information about which calculations apply for each indicator.

Indexes
Index Type Tablespace Column
BSC_KPI_CALCULATIONS_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
CALCULATION_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y indicator code
CALCULATION_ID NUMBER (5) Y Calculation identifier
USER_LEVEL0 NUMBER (3)
Visibility status for design level 0
USER_LEVEL1 NUMBER (3)
Visibility status for design level 1
USER_LEVEL1_DEFAULT NUMBER (3)
Visibility default status for design level 1
USER_LEVEL2 NUMBER (3)
Visibility status for design level 2
USER_LEVEL2_DEFAULT NUMBER (3)
Visibility default status for design level 2
DEFAULT_VALUE NUMBER (3) Y Pre selected by default

[top of page]

BSC.BSC_KPI_CALCULATIONS does not reference any database object

BSC.BSC_KPI_CALCULATIONS is referenced by following:

APPS
SYNONYM - BSC_KPI_CALCULATIONS

[top of page]

Table: BSC_KPI_CALCULATIONS_USER

Description: Calculations information by user
Primary Key: BSC_KPI_CALCULATIONS_USER_PK
  1. CALCULATION_ID
  2. USER_ID
  3. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_CALCULATIONS_USER.USER_ID BSC_USERS
BSC_KPI_CALCULATIONS_USER.INDICATOR
BSC_KPI_CALCULATIONS_USER.CALCULATION_ID 		BSC_KPI_CALCULATIONS
Comments

BSC_KPI_CALCULATIONS_USER stores customized information about calculation by user such as display flag.

Indexes
Index Type Tablespace Column
BSC_KPI_CALCULATIONS_USER_U1 UNIQUE APPS_TS_TX_IDX USER_ID
INDICATOR
CALCULATION_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y User identifier
INDICATOR NUMBER (5) Y indicator code
CALCULATION_ID NUMBER (5) Y Calculation identifier
DISPLAY_FLAG NUMBER (3) Y Visible status
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_KPI_CALCULATIONS_USER does not reference any database object

BSC.BSC_KPI_CALCULATIONS_USER is referenced by following:

APPS
SYNONYM - BSC_KPI_CALCULATIONS_USER

[top of page]

Table: BSC_KPI_CAUSE_EFFECT_RELS

Description: Indicator cause & effect relationships
Primary Key: BSC_KPI_CAUSE_EFFECT_RELS_PK
  1. CAUSE_INDICATOR
  2. EFFECT_INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_CAUSE_EFFECT_RELS.CAUSE_INDICATOR BSC_KPIS_B
BSC_KPI_CAUSE_EFFECT_RELS.EFFECT_INDICATOR BSC_KPIS_B
Comments

BSC_KPI_CAUSE_EFFECT_RELS stores information about indicator cause & effect relationships.

Indexes
Index Type Tablespace Column
BSC_KPI_CAUSE_EFFECT_RELS_N1 NONUNIQUE APPS_TS_TX_IDX EFFECT_INDICATOR
EFFECT_LEVEL
BSC_KPI_CAUSE_EFFECT_RELS_N2 NONUNIQUE APPS_TS_TX_IDX CAUSE_INDICATOR
CAUSE_LEVEL
Columns
Name Datatype Length Mandatory Comments
CAUSE_INDICATOR NUMBER (5) Y Cause indicator code
EFFECT_INDICATOR NUMBER (5) Y Effect indicator code
CAUSE_LEVEL VARCHAR2 (10)
Cause Level. It could be KPI or DATASET
EFFECT_LEVEL VARCHAR2 (10)
Effect Level. It could be KPI or DATASET

[top of page]

BSC.BSC_KPI_CAUSE_EFFECT_RELS does not reference any database object

BSC.BSC_KPI_CAUSE_EFFECT_RELS is referenced by following:

APPS
SYNONYM - BSC_KPI_CAUSE_EFFECT_RELS

[top of page]

Table: BSC_KPI_COMMENTS

Description: Indicator comments
Primary Key: BSC_KPI_COMMENTS_PK
  1. CREATED_BY
  2. CREATION_DATE
  3. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_COMMENTS.INDICATOR BSC_KPIS_B
BSC_KPI_COMMENTS.PERIODICITY_ID
BSC_KPI_COMMENTS.PERIOD_ID
BSC_KPI_COMMENTS.YEAR 		BSC_SYS_PERIODS_TL
Comments

BSC_KPI_COMMENTS stores information about user comments per indicator. User can comment on this indicator on specific year, sepecific periodicity and specific period.

Indexes
Index Type Tablespace Column
BSC_KPI_COMMENTS_U2 UNIQUE APPS_TS_TX_IDX COMMENT_ID
BSC_KPI_COMMENTS_U1 NONUNIQUE APPS_TS_TX_IDX INDICATOR
LAST_UPDATE_DATE
LAST_UPDATED_BY
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
YEAR NUMBER (5)
Year
PERIODICITY_ID NUMBER (5)
Periodicity identifier
PERIOD_ID NUMBER (5)
Period identifier
TREND_FLAG NUMBER (3)
Performance quality
COMMENT_TEXT VARCHAR2 (4000)
User's comment body
COMMENT_TYPE NUMBER (3) Y Comment's type
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Y Standard Who column
COMMENT_SUBJECT VARCHAR2 (1000)
Subject's comment body
COMMENT_ID NUMBER
Y Comment Identifier
COLOR_FLAG NUMBER (3)
Color Flag for Assessment

[top of page]

BSC.BSC_KPI_COMMENTS does not reference any database object

BSC.BSC_KPI_COMMENTS is referenced by following:

APPS
SYNONYM - BSC_KPI_COMMENTS

[top of page]

Table: BSC_KPI_DATA_TABLES

Description: Data table information
Primary Key: BSC_KPI_DATA_TABLES_PK
  1. DIM_SET_ID
  2. PERIODICITY_ID
  3. LEVEL_COMB
  4. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DATA_TABLES.INDICATOR
BSC_KPI_DATA_TABLES.PERIODICITY_ID 		BSC_KPI_PERIODICITIES
BSC_KPI_DATA_TABLES.TABLE_NAME BSC_DB_TABLES
BSC_KPI_DATA_TABLES.DIM_SET_ID
BSC_KPI_DATA_TABLES.INDICATOR 		BSC_KPI_DIM_SETS_TL
Comments

BSC_KPI_DATA_TABLES stores information about data table configuration by indicator.

Indexes
Index Type Tablespace Column
BSC_KPI_DATA_TABLES_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
PERIODICITY_ID
DIM_SET_ID
LEVEL_COMB
BSC_KPI_DATA_TABLES_N1 NONUNIQUE APPS_TS_TX_IDX TABLE_NAME
BSC_KPI_DATA_TABLES_N2 NONUNIQUE APPS_TS_TX_IDX MV_NAME
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
PERIODICITY_ID NUMBER (5) Y Periodicity identifier
DIM_SET_ID NUMBER (3) Y Dimensiot set identifier
LEVEL_COMB VARCHAR2 (30) Y Dimension level combination. Each character (?,0,1) represents a dimension level.
TABLE_NAME VARCHAR2 (30)
System data table name
FILTER_CONDITION VARCHAR2 (240)
Condition. Each dimension level is represented as D<#>
MV_NAME VARCHAR2 (30)
It stores the MV name to be used by KPI
PROJECTION_SOURCE NUMBER

Projection source
DATA_SOURCE VARCHAR2 (10)
It stores data source
SQL_STMT VARCHAR2 (4000)
It stores Sql Statement to be used by KPI
PROJECTION_DATA VARCHAR2 (30)
Projection data

[top of page]

BSC.BSC_KPI_DATA_TABLES does not reference any database object

BSC.BSC_KPI_DATA_TABLES is referenced by following:

APPS
SYNONYM - BSC_KPI_DATA_TABLES

[top of page]

Table: BSC_KPI_DEFAULTS_B

Description: Indicator data for information box
Primary Key: BSC_KPI_DEFAULTS_B_PK
  1. INDICATOR
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DEFAULTS_B.TAB_ID
BSC_KPI_DEFAULTS_B.INDICATOR 		BSC_TAB_INDICATORS
BSC_KPI_DEFAULTS_B.DIM_SET_ID
BSC_KPI_DEFAULTS_B.INDICATOR 		BSC_KPI_DIM_SETS_TL
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DEFAULTS_TL.INDICATOR
BSC_KPI_DEFAULTS_TL.TAB_ID 		BSC_KPI_DEFAULTS_B
Comments

BSC_KPI_DEFAULTS_B stores information about indicator data for information box.

Indexes
Index Type Tablespace Column
BSC_KPI_DEFAULTS_B_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
INDICATOR
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
INDICATOR NUMBER (5) Y Indicator code
FORMAT_MASK VARCHAR2 (20)
Format mask to show the data ($,# or %)
COLOR_METHOD NUMBER (3)
Color method identifier
COLOR_LEVEL1 NUMBER (3)
Color level 1
COLOR_LEVEL2 NUMBER (3)
Color level 2
COLOR_LEVEL3 NUMBER (3)
Color level 3
COLOR_LEVEL4 NUMBER (3)
Color level 4
DIM_SET_ID NUMBER (5)
Dimension set identifier
DIM_LEVEL1_VALUE VARCHAR2 (400)
Default dimension level 1 code value
DIM_LEVEL2_VALUE VARCHAR2 (400)
Default dimension level 2 code value
DIM_LEVEL3_VALUE VARCHAR2 (400)
Default dimension level 3 code value
DIM_LEVEL4_VALUE VARCHAR2 (400)
Default dimension level 4 code value
DIM_LEVEL5_VALUE VARCHAR2 (400)
Default dimension level 5 code value
DIM_LEVEL6_VALUE VARCHAR2 (400)
Default dimension level 6 code value
DIM_LEVEL7_VALUE VARCHAR2 (400)
Default dimension level 7 code value
DIM_LEVEL8_VALUE VARCHAR2 (400)
Default dimension level 8 code value
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
MEASURE_SOURCE VARCHAR2 (10)
Measure Source

[top of page]

BSC.BSC_KPI_DEFAULTS_B does not reference any database object

BSC.BSC_KPI_DEFAULTS_B is referenced by following:

APPS
SYNONYM - BSC_KPI_DEFAULTS_B

[top of page]

Table: BSC_KPI_DEFAULTS_TL

Description: Indicator translated data for information box
Primary Key: BSC_KPI_DEFAULTS_TL_PK
  1. INDICATOR
  2. TAB_ID
  3. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DEFAULTS_TL.INDICATOR
BSC_KPI_DEFAULTS_TL.TAB_ID 		BSC_KPI_DEFAULTS_B
Comments

BSC_KPI_DEFAULTS_B stores translated information about indicator for information box.

Indexes
Index Type Tablespace Column
BSC_KPI_DEFAULTS_TL_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
INDICATOR
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
INDICATOR NUMBER (5) Y Indicator code
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
ANALYSIS_OPTION0_NAME VARCHAR2 (255)
Default option name for analysis group 0 (max 30 chars)
ANALYSIS_OPTION1_NAME VARCHAR2 (255)
Default option name for analysis group 1 (max 30 chars)
ANALYSIS_OPTION2_NAME VARCHAR2 (255)
Default option name for analysis group 2 (max 30 chars)
PERIOD_NAME VARCHAR2 (90)
Actual period name
SERIES_NAME VARCHAR2 (255)
Default series name
DIM_LEVEL1_NAME VARCHAR2 (255)
Dimension level 1 name (max 80 chars)
DIM_LEVEL2_NAME VARCHAR2 (255)
Dimension level 2 name (max 80 chars)
DIM_LEVEL3_NAME VARCHAR2 (255)
Dimension level 3 name (max 80 chars)
DIM_LEVEL4_NAME VARCHAR2 (255)
Dimension level 4 name (max 80 chars)
DIM_LEVEL5_NAME VARCHAR2 (255)
Dimension level 5 name (max 80 chars)
DIM_LEVEL6_NAME VARCHAR2 (255)
Dimension level 6 name (max 80 chars)
DIM_LEVEL7_NAME VARCHAR2 (255)
Dimension level 7 name (max 80 chars)
DIM_LEVEL8_NAME VARCHAR2 (255)
Dimension level 8 name (max 80 chars)
DIM_LEVEL1_TEXT VARCHAR2 (240)
Dimension level 1 text value (max 80 chars)
DIM_LEVEL2_TEXT VARCHAR2 (240)
Dimension level 2 text value (max 80 chars)
DIM_LEVEL3_TEXT VARCHAR2 (240)
Dimension level 3 text value (max 80 chars)
DIM_LEVEL4_TEXT VARCHAR2 (240)
Dimension level 4 text value (max 80 chars)
DIM_LEVEL5_TEXT VARCHAR2 (240)
Dimension level 5 text value (max 80 chars)
DIM_LEVEL6_TEXT VARCHAR2 (240)
Dimension level 6 text value (max 80 chars)
DIM_LEVEL7_TEXT VARCHAR2 (240)
Dimension level 7 text value (max 80 chars)
DIM_LEVEL8_TEXT VARCHAR2 (240)
Dimension level 8 text value (max 80 chars)

[top of page]

BSC.BSC_KPI_DEFAULTS_TL does not reference any database object

BSC.BSC_KPI_DEFAULTS_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_DEFAULTS_TL

[top of page]

Table: BSC_KPI_DIM_GROUPS

Description: Dimension groups information
Primary Key: BSC_KPI_DIM_GROUPS_PK
  1. DIM_GROUP_ID
  2. DIM_SET_ID
  3. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_GROUPS.DIM_SET_ID
BSC_KPI_DIM_GROUPS.INDICATOR 		BSC_KPI_DIM_SETS_TL
BSC_KPI_DIM_GROUPS.DIM_GROUP_ID BSC_SYS_DIM_GROUPS_TL
Comments

BSC_KPI_DIM_GROUPS stores information about dimension groups.

Indexes
Index Type Tablespace Column
BSC_KPI_DIM_GROUPS_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
DIM_SET_ID
DIM_GROUP_ID
BSC_KPI_DIM_GROUPS_N1 NONUNIQUE APPS_TS_TX_IDX DIM_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
DIM_SET_ID NUMBER (3) Y Dimension set identifier
DIM_GROUP_ID NUMBER (5) Y Dimension group identifier
DIM_GROUP_INDEX NUMBER (3) Y Dimension group index

[top of page]

BSC.BSC_KPI_DIM_GROUPS does not reference any database object

BSC.BSC_KPI_DIM_GROUPS is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_GROUPS

[top of page]

Table: BSC_KPI_DIM_LEVELS_B

Description: Dimension levels information
Primary Key: BSC_KPI_DIM_LEVELS_B_PK
  1. DIM_LEVEL_INDEX
  2. DIM_SET_ID
  3. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVELS_B.DIM_SET_ID
BSC_KPI_DIM_LEVELS_B.INDICATOR 		BSC_KPI_DIM_SETS_TL
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVELS_TL.DIM_LEVEL_INDEX
BSC_KPI_DIM_LEVELS_TL.INDICATOR
BSC_KPI_DIM_LEVELS_TL.DIM_SET_ID 		BSC_KPI_DIM_LEVELS_B
BSC_KPI_DIM_LEVELS_USER.DIM_LEVEL_INDEX
BSC_KPI_DIM_LEVELS_USER.INDICATOR
BSC_KPI_DIM_LEVELS_USER.DIM_SET_ID 		BSC_KPI_DIM_LEVELS_B
Comments

BSC_KPI_DIM_LEVELS_B stores information about dimension levels by indicator. Each row includes values that identify a particular dimension level such as indicator code, dimension set, dimension level, dimension table, dimension view, position, status and default value.

Indexes
Index Type Tablespace Column
BSC_KPI_DIM_LEVELS_B_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
DIM_SET_ID
DIM_LEVEL_INDEX
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
DIM_SET_ID NUMBER (3) Y Dimension set identifier
DIM_LEVEL_INDEX NUMBER (3) Y Dimension level index
LEVEL_TABLE_NAME VARCHAR2 (30) Y Table name
LEVEL_VIEW_NAME VARCHAR2 (30)
Table or filter view name
FILTER_COLUMN VARCHAR2 (30)
The column to use for filter condition
FILTER_VALUE NUMBER (5)
The value to use for filter condition
DEFAULT_VALUE VARCHAR2 (2)
Option Default : 'T'= by total, 'C'= by comparison
DEFAULT_TYPE NUMBER (5)
How to handle default_value when dimension set is changed
VALUE_ORDER_BY NUMBER (5) Y Dimension level values order
COMP_ORDER_BY NUMBER (5) Y Graph item order
LEVEL_PK_COL VARCHAR2 (30) Y Level primary key column
PARENT_LEVEL_INDEX NUMBER (3)
Parent level index
PARENT_LEVEL_REL VARCHAR2 (30)
Parent level field
TABLE_RELATION VARCHAR2 (30)
Relation mxn tabel name
PARENT_LEVEL_INDEX2 NUMBER (3)
Second parent level index
PARENT_LEVEL_REL2 VARCHAR2 (30)
Second parent level field
STATUS NUMBER (3) Y 2= Normal, 0=Invisible, 1= Disable
PARENT_IN_TOTAL NUMBER (3)
Behavior when dimension parent is in TOTAL
POSITION NUMBER (3) Y 0= Normal, 1= top-corner, 2= hide
TOTAL0 NUMBER (3)
If the code 0 in DB
LEVEL_DISPLAY NUMBER (3)
To disable other level index
NO_ITEMS NUMBER (1)
If there are not items the drill will be disabled
DEFAULT_KEY_VALUE VARCHAR2 (400)
Default key value item
USER_LEVEL0 NUMBER (3)
Visibility status for level 0
USER_LEVEL1 NUMBER (3)
Visibility status for level 1
USER_LEVEL1_DEFAULT NUMBER (3)
Visibility default status for level 1
USER_LEVEL2 NUMBER (3)
Visibility status for level 2
USER_LEVEL2_DEFAULT NUMBER (3)
Visibility default status for level 2
TARGET_LEVEL NUMBER (1)
Target Level

[top of page]

BSC.BSC_KPI_DIM_LEVELS_B does not reference any database object

BSC.BSC_KPI_DIM_LEVELS_B is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_LEVELS_B

[top of page]

Table: BSC_KPI_DIM_LEVELS_TL

Description: Translated dimension levels information
Primary Key: BSC_KPI_DIM_LEVELS_TL_PK
  1. DIM_LEVEL_INDEX
  2. DIM_SET_ID
  3. LANGUAGE
  4. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVELS_TL.DIM_LEVEL_INDEX
BSC_KPI_DIM_LEVELS_TL.INDICATOR
BSC_KPI_DIM_LEVELS_TL.DIM_SET_ID 		BSC_KPI_DIM_LEVELS_B
Comments

BSC_KPI_DIM_LEVELS_TL stores translated information about dimension levesl.

Indexes
Index Type Tablespace Column
BSC_KPI_DIM_LEVELS_TL_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
DIM_SET_ID
DIM_LEVEL_INDEX
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
DIM_SET_ID NUMBER (3) Y Dimension set identifier
DIM_LEVEL_INDEX NUMBER (3) Y Dimension level index
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (255) Y Dimension level name (max 30 chars)
HELP VARCHAR2 (1024) Y Dimension level help (max 80 chars)
TOTAL_DISP_NAME VARCHAR2 (45)
Caption for TOTAL item (max 15 chars)
COMP_DISP_NAME VARCHAR2 (45)
Caption for COMPARISON item (max 15 chars)

[top of page]

BSC.BSC_KPI_DIM_LEVELS_TL does not reference any database object

BSC.BSC_KPI_DIM_LEVELS_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_LEVELS_TL

[top of page]

Table: BSC_KPI_DIM_LEVELS_USER

Description: Dimension levels information by user
Primary Key: BSC_KPI_DIM_LEVELS_USER_PK
  1. DIM_LEVEL_INDEX
  2. DIM_SET_ID
  3. INDICATOR
  4. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVELS_USER.USER_ID BSC_USERS
BSC_KPI_DIM_LEVELS_USER.DIM_LEVEL_INDEX
BSC_KPI_DIM_LEVELS_USER.INDICATOR
BSC_KPI_DIM_LEVELS_USER.DIM_SET_ID 		BSC_KPI_DIM_LEVELS_B
Comments

BSC_KPI_DIM_LEVELS_USER stores information about dimension levels by user.

Indexes
Index Type Tablespace Column
BSC_KPI_DIM_LEVELS_USER_U1 UNIQUE APPS_TS_TX_IDX USER_ID
INDICATOR
DIM_SET_ID
DIM_LEVEL_INDEX
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y User identifier
INDICATOR NUMBER (5) Y Indicator code
DIM_SET_ID NUMBER (3) Y Dimension set identifier
DIM_LEVEL_INDEX NUMBER (3) Y Dimension level index
DISPLAY_FLAG NUMBER (3) Y Visible status
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_KPI_DIM_LEVELS_USER does not reference any database object

BSC.BSC_KPI_DIM_LEVELS_USER is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_LEVELS_USER

[top of page]

Table: BSC_KPI_DIM_LEVEL_PROPERTIES

Description: Dimension levels properties
Primary Key: BSC_KPI_DIM_LEVEL_PROPERTI_PK
  1. DIM_LEVEL_ID
  2. INDICATOR
  3. DIM_SET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVEL_PROPERTIES.DIM_SET_ID
BSC_KPI_DIM_LEVEL_PROPERTIES.INDICATOR 		BSC_KPI_DIM_SETS_TL
BSC_KPI_DIM_LEVEL_PROPERTIES.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
Comments

BSC_KPI_DIM_LEVEL_PROPERTIES stores information about dimension level properties.

Indexes
Index Type Tablespace Column
BSC_KPI_DIM_LEVEL_PROPERTI_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
DIM_SET_ID
DIM_LEVEL_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
DIM_SET_ID NUMBER (3) Y Dimension set identifier
DIM_LEVEL_ID NUMBER (5) Y Dimension level identifier
POSITION NUMBER (3) Y 0= Normal, 1= top-corner, 2= hide
TOTAL0 NUMBER (3)
If there is a code zero in DB
LEVEL_DISPLAY NUMBER (3)
To disable other dimension level index
DEFAULT_KEY_VALUE VARCHAR2 (400)
Default key value item
USER_LEVEL0 NUMBER (3)
Visibility status for level 0
USER_LEVEL1 NUMBER (3)
Visibility status for level 1
USER_LEVEL1_DEFAULT NUMBER (3)
Visibility default status for level 1
USER_LEVEL2 NUMBER (3)
Visibility status for level 2
USER_LEVEL2_DEFAULT NUMBER (3)
Visibility default status for level 2
TARGET_LEVEL NUMBER (1)
Target Level

[top of page]

BSC.BSC_KPI_DIM_LEVEL_PROPERTIES does not reference any database object

BSC.BSC_KPI_DIM_LEVEL_PROPERTIES is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_LEVEL_PROPERTIES

[top of page]

Table: BSC_KPI_DIM_SETS_TL

Description: Dimension sets information
Primary Key: BSC_KPI_DIM_SETS_TL_PK
  1. DIM_SET_ID
  2. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_SETS_TL.INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_OPTIONS_B.DIM_SET_ID
BSC_KPI_ANALYSIS_OPTIONS_B.INDICATOR 		BSC_KPI_DIM_SETS_TL
BSC_KPI_DATA_TABLES.DIM_SET_ID
BSC_KPI_DATA_TABLES.INDICATOR 		BSC_KPI_DIM_SETS_TL
BSC_KPI_DEFAULTS_B.DIM_SET_ID
BSC_KPI_DEFAULTS_B.INDICATOR 		BSC_KPI_DIM_SETS_TL
BSC_KPI_DIM_GROUPS.DIM_SET_ID
BSC_KPI_DIM_GROUPS.INDICATOR 		BSC_KPI_DIM_SETS_TL
BSC_KPI_DIM_LEVELS_B.DIM_SET_ID
BSC_KPI_DIM_LEVELS_B.INDICATOR 		BSC_KPI_DIM_SETS_TL
BSC_KPI_DIM_LEVEL_PROPERTIES.DIM_SET_ID
BSC_KPI_DIM_LEVEL_PROPERTIES.INDICATOR 		BSC_KPI_DIM_SETS_TL
Comments

BSC_KPI_DIM_SETS_TL stores translated information about dimension sets.

Indexes
Index Type Tablespace Column
BSC_KPI_DIM_SETS_TL_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
DIM_SET_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
DIM_SET_ID NUMBER (3) Y Dimension set identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (60) Y Dimension set name (Max 20 chars)
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SHORT_NAME VARCHAR2 (30)
Short name

[top of page]

BSC.BSC_KPI_DIM_SETS_TL does not reference any database object

BSC.BSC_KPI_DIM_SETS_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_DIM_SETS_TL

[top of page]

Table: BSC_KPI_GRAPHS

Description: Indicator graph files for portlet
Primary Key: BSC_KPI_GRAPHS_PK
  1. RESPONSIBILITY_ID
  2. INDICATOR
Comments

BSC_KPI_GRAPH stores information about the indicator graph that are used by portlet.

Indexes
Index Type Tablespace Column
BSC_KPI_GRAPHS_U1 UNIQUE APPS_TS_TX_IDX RESPONSIBILITY_ID
INDICATOR
Columns
Name Datatype Length Mandatory Comments
RESPONSIBILITY_ID NUMBER (15) Y Responsibility identifier
INDICATOR NUMBER (5) Y Indicator Code
GRAPH_KEY VARCHAR2 (100) Y Graph key
IMAGE_ID NUMBER (15) Y image identifier
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_KPI_GRAPHS does not reference any database object

BSC.BSC_KPI_GRAPHS is referenced by following:

APPS
SYNONYM - BSC_KPI_GRAPHS

[top of page]

Table: BSC_KPI_MEASURE_PROPS

Description: Table to store KPI Measure Properties
Comments
Table to store KPI Measure Properties
Indexes
Index Type Tablespace Column
BSC_KPI_MEASURE_PROPS_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
KPI_MEASURE_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Objective Id
KPI_MEASURE_ID NUMBER
Y KPI Measure Id. Stands for the combination of AO1, AO2, AO3 and Data Series in BSC_KPI_ANALYSIS_MEASURES_B
PROTOTYPE_COLOR_ID NUMBER (8)
Color Id for prototype state
PROTOTYPE_TREND_ID NUMBER

Trend Id for prototype state
COLOR_BY_TOTAL NUMBER (1)
Denotes the color by total flag. Valid values are: 1 - Total (All dimension object values) 0 - Comparison (by dimension object values)
DISABLE_COLOR VARCHAR2 (1)
Value can be T or F, NULL represents F
DISABLE_TREND VARCHAR2 (1)
Value can be T or F, NULL represents F
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER (15) Y Created By
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATED_BY NUMBER (15) Y Last Updated By
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login
APPLY_COLOR_FLAG NUMBER (1)
This flag signifies whether there exists Plan as a benchmark for color calculation. If 0, we will put GRAY as the color. This flag is being moved from Objective to KPI level.
DEFAULT_CALCULATION NUMBER

Default Calculation Id
TYPE VARCHAR2 (30)
Type of KPI. For Weighted Average KPI, the value is CDS_PERF

[top of page]

BSC.BSC_KPI_MEASURE_PROPS does not reference any database object

BSC.BSC_KPI_MEASURE_PROPS is referenced by following:

APPS
SYNONYM - BSC_KPI_MEASURE_PROPS

[top of page]

Table: BSC_KPI_MEASURE_WEIGHTS

Description: Table to store weights of the KPI Measure. Same KPI can have more than one weight if this KPI belongs to more than one Weighted Average KPI; or, there can be possible multiple weights for a KPI for different dimension object combination in
Comments
Table to store weights of the KPI Measure. Same KPI can have more than one weight if this KPI belongs to more than one Weighted Average KPI; or, there can be possible multiple weights for a KPI for different dimension object combination in future.
Indexes
Index Type Tablespace Column
BSC_KPI_MEASURE_WEIGHTS_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
KPI_MEASURE_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Objective Id
KPI_MEASURE_ID NUMBER
Y Kpi Measure Id
WEIGHT NUMBER

Weight of the Kpi Measure
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER (15) Y Created By
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATED_BY NUMBER (15) Y Last Updated By
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login

[top of page]

BSC.BSC_KPI_MEASURE_WEIGHTS does not reference any database object

BSC.BSC_KPI_MEASURE_WEIGHTS is referenced by following:

APPS
SYNONYM - BSC_KPI_MEASURE_WEIGHTS

[top of page]

Table: BSC_KPI_MM_CONTROLS

Description: Multimedia control remote information
Primary Key: BSC_KPI_MM_CONTROLS_PK
  1. BUTTON_ID
  2. INDICATOR
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_MM_CONTROLS.INDICATOR BSC_KPIS_B
BSC_KPI_MM_CONTROLS.BUTTON_ID BSC_SYS_MM_CONTROLS_TL
Comments

BSC_KPI_MM_CONTROLS stores information about the multimedia control remote properties.

Indexes
Index Type Tablespace Column
BSC_KPI_MM_CONTROLS_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
BUTTON_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
BUTTON_ID NUMBER (5) Y Button identifier
COMMAND VARCHAR2 (320)
Command

[top of page]

BSC.BSC_KPI_MM_CONTROLS does not reference any database object

BSC.BSC_KPI_MM_CONTROLS is referenced by following:

APPS
SYNONYM - BSC_KPI_MM_CONTROLS

[top of page]

Table: BSC_KPI_PERIODICITIES

Description: Indicator periodicity information
Primary Key: BSC_KPI_PERIODICITIES_PK
  1. INDICATOR
  2. PERIODICITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_PERIODICITIES.INDICATOR BSC_KPIS_B
BSC_KPI_PERIODICITIES.PERIODICITY_ID BSC_SYS_PERIODICITIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DATA_TABLES.INDICATOR
BSC_KPI_DATA_TABLES.PERIODICITY_ID 		BSC_KPI_PERIODICITIES
BSC_KPI_PERIODICITIES_USER.INDICATOR
BSC_KPI_PERIODICITIES_USER.PERIODICITY_ID 		BSC_KPI_PERIODICITIES
Comments

BSC_KPI_PERIODICITIES stores information about periodicity by indicator.

Indexes
Index Type Tablespace Column
BSC_KPI_PERIODICITIES_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
PERIODICITY_ID
BSC_KPI_PERIODICITIES_N1 NONUNIQUE APPS_TS_TX_IDX PERIODICITY_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
PERIODICITY_ID NUMBER (5) Y Periodicity identifier
DISPLAY_ORDER NUMBER (3) Y Periodicity order
PREVIOUS_YEARS NUMBER (3) Y Number of previous years for annual periodicity
NUM_OF_YEARS NUMBER (3) Y Number of years for annual periodicity
VIEWPORT_FLAG NUMBER (5) Y Enabled period view
VIEWPORT_DEFAULT_SIZE NUMBER (5) Y Period view size
USER_LEVEL0 NUMBER (3)
Visibility status for level 0
USER_LEVEL1 NUMBER (3)
Visibility status for level 1
USER_LEVEL1_DEFAULT NUMBER (3)
Visibility status for level 1
USER_LEVEL2 NUMBER (3)
Visibility status for level 2
USER_LEVEL2_DEFAULT NUMBER (3)
Visibility status for level 2
CURRENT_PERIOD NUMBER (5) Y Current period
LAST_UPDATE_DATE DATE
Y Update date
TARGET_LEVEL NUMBER (1)
Target Level

[top of page]

BSC.BSC_KPI_PERIODICITIES does not reference any database object

BSC.BSC_KPI_PERIODICITIES is referenced by following:

APPS
SYNONYM - BSC_KPI_PERIODICITIES

[top of page]

Table: BSC_KPI_PERIODICITIES_USER

Description: Indicator periodicity information by user
Primary Key: BSC_KPI_PERIODICITIES_USER_PK
  1. INDICATOR
  2. PERIODICITY_ID
  3. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_PERIODICITIES_USER.USER_ID BSC_USERS
BSC_KPI_PERIODICITIES_USER.INDICATOR
BSC_KPI_PERIODICITIES_USER.PERIODICITY_ID 		BSC_KPI_PERIODICITIES
Comments

BSC_KPI_PERIODICITIES_USER stores customized information about periodicity by indicator.

Indexes
Index Type Tablespace Column
BSC_KPI_PERIODICITIES_USER_U1 UNIQUE APPS_TS_TX_IDX USER_ID
INDICATOR
PERIODICITY_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y User identifier
INDICATOR NUMBER (5) Y Indicator code
PERIODICITY_ID NUMBER (5) Y Periodicity identifier
DISPLAY_ORDER NUMBER (3) Y Order displayed
DISPLAY_FLAG NUMBER (3) Y Visible status
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_KPI_PERIODICITIES_USER does not reference any database object

BSC.BSC_KPI_PERIODICITIES_USER is referenced by following:

APPS
SYNONYM - BSC_KPI_PERIODICITIES_USER

[top of page]

Table: BSC_KPI_PROPERTIES

Description: Indicator properties information
Primary Key: BSC_KPI_PROPERTIES_PK
  1. INDICATOR
  2. PROPERTY_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_PROPERTIES.INDICATOR BSC_KPIS_B
Comments

BSC_KPI_PROPERTIES stores information about global indicator properties .

Indexes
Index Type Tablespace Column
BSC_KPI_PROPERTIES_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
PROPERTY_CODE
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
PROPERTY_CODE VARCHAR2 (20) Y Property code
PROPERTY_VALUE NUMBER (5) Y Property value
SECONDARY_VALUE VARCHAR2 (1000)
Secondary property value

[top of page]

BSC.BSC_KPI_PROPERTIES does not reference any database object

BSC.BSC_KPI_PROPERTIES is referenced by following:

APPS
SYNONYM - BSC_KPI_PROPERTIES

[top of page]

Table: BSC_KPI_SERIES_COLORS

Description: Series and benchmark color by dataseries
Primary Key: BSC_KPI_SERIES_COLORS_PK
  1. ANALYSIS_OPTION0
  2. ANALYSIS_OPTION1
  3. BM_ID
  4. INDICATOR
  5. SERIES_ID
  6. ANALYSIS_OPTION2
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION2
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION0
BSC_KPI_SERIES_COLORS.SERIES_ID
BSC_KPI_SERIES_COLORS.ANALYSIS_OPTION1
BSC_KPI_SERIES_COLORS.INDICATOR 		BSC_KPI_ANALYSIS_MEASURES_B
BSC_KPI_SERIES_COLORS.BM_ID BSC_SYS_BENCHMARKS_B
Comments

BSC_KPI_SERIES_COLORS stores information about series color and benchmark color for each data series by analysis option.

Indexes
Index Type Tablespace Column
BSC_KPI_SERIES_COLORS_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
ANALYSIS_OPTION0
ANALYSIS_OPTION1
ANALYSIS_OPTION2
SERIES_ID
BM_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
ANALYSIS_OPTION0 NUMBER (3) Y Analysis option in analysis group 0
ANALYSIS_OPTION1 NUMBER (3) Y Analysis option in analysis group 1
ANALYSIS_OPTION2 NUMBER (3) Y Analysis option in analysis group 2
SERIES_ID NUMBER (3) Y Series identifier
BM_ID NUMBER (3) Y Benchmark identifier
COLOR NUMBER (11) Y Color

[top of page]

BSC.BSC_KPI_SERIES_COLORS does not reference any database object

BSC.BSC_KPI_SERIES_COLORS is referenced by following:

APPS
SYNONYM - BSC_KPI_SERIES_COLORS

[top of page]

Table: BSC_KPI_SHELL_CMDS_TL

Description: Links command information
Primary Key: BSC_KPI_SHELL_CMDS_TL_PK
  1. INDICATOR
  2. SHELL_CMD_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_SHELL_CMDS_TL.INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_SHELL_CMDS_USER.INDICATOR
BSC_KPI_SHELL_CMDS_USER.SHELL_CMD_ID 		BSC_KPI_SHELL_CMDS_TL
Comments

BSC_KPI_SHELL_CMDS_TL stores information about links command configuration by indicator to launch other applications from BSC.

Indexes
Index Type Tablespace Column
BSC_KPI_SHELL_CMDS_TL_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
SHELL_CMD_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
SHELL_CMD_ID NUMBER (3) Y Links command identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (150) Y Links command name (max 50 chars)
COMMAND VARCHAR2 (320)
Command

[top of page]

BSC.BSC_KPI_SHELL_CMDS_TL does not reference any database object

BSC.BSC_KPI_SHELL_CMDS_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_SHELL_CMDS_TL

[top of page]

Table: BSC_KPI_SHELL_CMDS_USER

Description: Links command information by user
Primary Key: BSC_KPI_SHELL_CMDS_USER_PK
  1. INDICATOR
  2. SHELL_CMD_ID
  3. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_SHELL_CMDS_USER.USER_ID BSC_USERS
BSC_KPI_SHELL_CMDS_USER.INDICATOR
BSC_KPI_SHELL_CMDS_USER.SHELL_CMD_ID 		BSC_KPI_SHELL_CMDS_TL
Comments

BSC_KPI_SHELL_CMDS_TL stores customized information about Links command configuration by indicator to launch other applications from BSC.

Indexes
Index Type Tablespace Column
BSC_KPI_SHELL_CMDS_USER_U1 UNIQUE APPS_TS_TX_IDX USER_ID
INDICATOR
SHELL_CMD_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y User identifier
INDICATOR NUMBER (5) Y Indicator code
SHELL_CMD_ID NUMBER (3) Y Links command identifier
COMMAND VARCHAR2 (320) Y Command
NAME VARCHAR2 (50) Y Links command name (max 50 chars)
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_KPI_SHELL_CMDS_USER does not reference any database object

BSC.BSC_KPI_SHELL_CMDS_USER is referenced by following:

APPS
SYNONYM - BSC_KPI_SHELL_CMDS_USER

[top of page]

Table: BSC_KPI_SUBTITLES_TL

Description: Indicator sub titles information
Primary Key: BSC_KPI_SUBTITLES_TL_PK
  1. ANALYSIS_OPTION0
  2. ANALYSIS_OPTION1
  3. CALC_COMB
  4. LANGUAGE
  5. INDICATOR
  6. ANALYSIS_OPTION2
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_SUBTITLES_TL.INDICATOR BSC_KPIS_B
Comments

BSC_KPI_SUBTITLES_TL stores information about sub-titles by indicator.

Indexes
Index Type Tablespace Column
BSC_KPI_SUBTITLES_TL_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
CALC_COMB
ANALYSIS_OPTION0
ANALYSIS_OPTION1
ANALYSIS_OPTION2
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
CALC_COMB NUMBER (3) Y Calculation identier combination
ANALYSIS_OPTION0 NUMBER (3) Y Analysis option in analysis group 0
ANALYSIS_OPTION1 NUMBER (3) Y Analysis option in analysis group 1
ANALYSIS_OPTION2 NUMBER (3) Y Analysis option in analysis group 2
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
SUBTITLE VARCHAR2 (240) Y Indicator subtitle (max 80 chars)

[top of page]

BSC.BSC_KPI_SUBTITLES_TL does not reference any database object

BSC.BSC_KPI_SUBTITLES_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_SUBTITLES_TL

[top of page]

Table: BSC_KPI_TREE_NODES_B

Description: Simulation tree nodes information
Primary Key: BSC_KPI_TREE_NODES_B_PK
  1. INDICATOR
  2. NODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_TREE_NODES_B.INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_TREE_NODES_TL.INDICATOR
BSC_KPI_TREE_NODES_TL.NODE_ID 		BSC_KPI_TREE_NODES_B
Comments

BSC_KPI_TREE_NODES_B stores information about simulation tree nodes by indicator.

Indexes
Index Type Tablespace Column
BSC_KPI_TREE_NODES_B_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
NODE_ID
BSC_KPI_TREE_NODES_B_N1 NONUNIQUE APPS_TS_TX_IDX FORMAT_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
NODE_ID NUMBER (5) Y Tree node identifier
SIMULATE_FLAG NUMBER (3) Y Simulation flag
FORMAT_ID NUMBER (3) Y Number format Identifier
COLOR_FLAG NUMBER (3) Y Node color flag
COLOR_METHOD NUMBER (3) Y Color method identifier
NAVIGATES_TO_TREND NUMBER (3) Y If Navigation to trend is enabled
TOP_POSITION NUMBER (5) Y Position -TOP
LEFT_POSITION NUMBER (5) Y Position -LEFT
WIDTH NUMBER (5) Y Position -WIDTH
HEIGHT NUMBER (5) Y Position -HEIGTH
AUTOSCALE_FLAG NUMBER (1)
Flag that indicates if the scale of the graph will be automatic or not

[top of page]

BSC.BSC_KPI_TREE_NODES_B does not reference any database object

BSC.BSC_KPI_TREE_NODES_B is referenced by following:

APPS
SYNONYM - BSC_KPI_TREE_NODES_B

[top of page]

Table: BSC_KPI_TREE_NODES_TL

Description: Translated simulation tree nodes information
Primary Key: BSC_KPI_TREE_NODES_TL_PK
  1. INDICATOR
  2. LANGUAGE
  3. NODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_KPI_TREE_NODES_TL.INDICATOR
BSC_KPI_TREE_NODES_TL.NODE_ID 		BSC_KPI_TREE_NODES_B
Comments

BSC_KPI_TREE_NODES_B stores translated information about simulation tree nodes by indicator.

Indexes
Index Type Tablespace Column
BSC_KPI_TREE_NODES_TL_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
NODE_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code
NODE_ID NUMBER (5) Y Tree node identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (75) Y Tree node name
HELP VARCHAR2 (240) Y Tree node help
Y_AXIS_TITLE VARCHAR2 (90)
Y axis title (max 30 chars)

[top of page]

BSC.BSC_KPI_TREE_NODES_TL does not reference any database object

BSC.BSC_KPI_TREE_NODES_TL is referenced by following:

APPS
SYNONYM - BSC_KPI_TREE_NODES_TL

[top of page]

Table: BSC_MESSAGE_LOGS

Description: Errors/log messages information
Comments

BSC_MESSAGE_LOGS stores information about the error messages or log messages generated by the BSC pls package.

Indexes
Index Type Tablespace Column
BSC_MESSAGE_LOGS_N1 NONUNIQUE APPS_TS_INTERFACE LAST_UPDATE_LOGIN
Columns
Name Datatype Length Mandatory Comments
SOURCE VARCHAR2 (80) Y Function name that generates the message
TYPE NUMBER (3) Y Message type. 0 = fatal error, 1= error, 2= warning, 3=information, 4= debug messages
MESSAGE VARCHAR2 (2000) Y Message text
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_MESSAGE_LOGS does not reference any database object

BSC.BSC_MESSAGE_LOGS is referenced by following:

APPS
SYNONYM - BSC_MESSAGE_LOGS

[top of page]

Table: BSC_MIG_SRC_SYS_DETAILS

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (30)
HOST_NAME VARCHAR2 (30)
DB_LINK_NAME VARCHAR2 (128)
DB_LINK_DESC VARCHAR2 (255)
SID VARCHAR2 (30)
PORT_NO NUMBER

[top of page]

BSC.BSC_MIG_SRC_SYS_DETAILS does not reference any database object

BSC.BSC_MIG_SRC_SYS_DETAILS is referenced by following:

APPS
SYNONYM - BSC_MIG_SRC_SYS_DETAILS

[top of page]

Table: BSC_OBJECT_LOCKS

Description:
Comments
Indexes
Index Type Tablespace Column
BSC_OBJECT_LOCKS_U1 UNIQUE APPS_TS_TX_IDX OBJECT_TYPE
OBJECT_KEY
LOCK_TYPE
Columns
Name Datatype Length Mandatory Comments
OBJECT_KEY VARCHAR2 (500) Y
OBJECT_TYPE VARCHAR2 (50) Y
LOCK_TYPE VARCHAR2 (8) Y
LAST_SAVE_TIME DATE

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
SESSION_ID NUMBER

[top of page]

BSC.BSC_OBJECT_LOCKS does not reference any database object

BSC.BSC_OBJECT_LOCKS is referenced by following:

APPS
SYNONYM - BSC_OBJECT_LOCKS

[top of page]

Table: BSC_OBJECT_LOCK_USERS

Description:
Comments
Indexes
Index Type Tablespace Column
BSC_OBJECT_LOCK_USERS_U1 UNIQUE APPS_TS_TX_IDX OBJECT_TYPE
OBJECT_KEY
USER_TYPE
Columns
Name Datatype Length Mandatory Comments
OBJECT_KEY VARCHAR2 (500) Y
OBJECT_TYPE VARCHAR2 (50) Y
USER_TYPE VARCHAR2 (8) Y
PROGRAM_ID NUMBER

USER_ID NUMBER (15)
MACHINE VARCHAR2 (64)
TERMINAL VARCHAR2 (30)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

BSC.BSC_OBJECT_LOCK_USERS does not reference any database object

BSC.BSC_OBJECT_LOCK_USERS is referenced by following:

APPS
SYNONYM - BSC_OBJECT_LOCK_USERS

[top of page]

Table: BSC_OLAP_OBJECT

Description:
Comments
Indexes
Index Type Tablespace Column
BSC_OLAP_OBJECT_N1 NONUNIQUE APPS_TS_TX_IDX OBJECT
OBJECT_TYPE
CONTEXT
BSC_OLAP_OBJECT_N2 NONUNIQUE APPS_TS_TX_IDX PARENT_OBJECT
PARENT_OBJECT_TYPE
CONTEXT
Columns
Name Datatype Length Mandatory Comments
OBJECT VARCHAR2 (800)
OBJECT_TYPE VARCHAR2 (100)
CONTEXT VARCHAR2 (100)
PARENT_OBJECT VARCHAR2 (800)
PARENT_OBJECT_TYPE VARCHAR2 (100)
OLAP_OBJECT VARCHAR2 (400)
OLAP_OBJECT_TYPE VARCHAR2 (100)
PROPERTY1 VARCHAR2 (4000)
PROPERTY2 VARCHAR2 (4000)
PROPERTY3 VARCHAR2 (4000)
PROPERTY4 VARCHAR2 (4000)
PROPERTY5 VARCHAR2 (4000)
PROPERTY6 VARCHAR2 (4000)
PROPERTY7 VARCHAR2 (4000)
PROPERTY8 VARCHAR2 (4000)
PROPERTY9 VARCHAR2 (4000)
PROPERTY10 VARCHAR2 (4000)
OPERATION_FLAG VARCHAR2 (40)
CREATION_DATE DATE

LAST_UPDATE_DATE DATE

CREATED_BY NUMBER

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

[top of page]

BSC.BSC_OLAP_OBJECT does not reference any database object

BSC.BSC_OLAP_OBJECT is referenced by following:

APPS
SYNONYM - BSC_OLAP_OBJECT

[top of page]

Table: BSC_OLAP_OBJECT_RELATION

Description:
Comments
Indexes
Index Type Tablespace Column
BSC_OLAP_OBJECT_RELATION_N1 NONUNIQUE APPS_TS_TX_IDX PARENT_OBJECT
PARENT_OBJECT_TYPE
CONTEXT
BSC_OLAP_OBJECT_RELATION_N2 NONUNIQUE APPS_TS_TX_IDX OBJECT
OBJECT_TYPE
CONTEXT
Columns
Name Datatype Length Mandatory Comments
PARENT_OBJECT VARCHAR2 (800)
PARENT_OBJECT_TYPE VARCHAR2 (100)
OBJECT VARCHAR2 (800)
OBJECT_TYPE VARCHAR2 (100)
CONTEXT VARCHAR2 (100)
RELATION_TYPE VARCHAR2 (100)
RELATION_OBJECT VARCHAR2 (400)
RELATION_OBJECT_TYPE VARCHAR2 (100)
PROPERTY1 VARCHAR2 (4000)
PROPERTY2 VARCHAR2 (4000)
PROPERTY3 VARCHAR2 (4000)
PROPERTY4 VARCHAR2 (4000)
PROPERTY5 VARCHAR2 (4000)
PROPERTY6 VARCHAR2 (4000)
PROPERTY7 VARCHAR2 (4000)
PROPERTY8 VARCHAR2 (4000)
PROPERTY9 VARCHAR2 (4000)
PROPERTY10 VARCHAR2 (4000)
CREATION_DATE DATE

LAST_UPDATE_DATE DATE

CREATED_BY NUMBER

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

[top of page]

BSC.BSC_OLAP_OBJECT_RELATION does not reference any database object

BSC.BSC_OLAP_OBJECT_RELATION is referenced by following:

APPS
SYNONYM - BSC_OLAP_OBJECT_RELATION

[top of page]

Table: BSC_REPORTING_CALENDAR

Description:
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes
Index Type Tablespace Column
BSC_REPORTING_CALENDAR_N1 NONUNIQUE REPORT_DATE
HIERARCHY
CALENDAR_ID
Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER

Calendar Identifier
CALENDAR_TYPE VARCHAR2 (200)
Calendar Type
REPORT_DATE DATE

Report Date
PERIOD NUMBER

Period
YEAR NUMBER

Year
PERIOD_TYPE_ID NUMBER

Period type identifier
PERIODICITY_ID NUMBER

Periodicity Identifier
RECORD_TYPE_ID NUMBER

Record identifier type
HIERARCHY VARCHAR2 (200)
Hierarchy
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
DAY_COUNT NUMBER

Day count
ROLLING_FLAG VARCHAR2 (40)
Rolling flag

[top of page]

BSC.BSC_REPORTING_CALENDAR does not reference any database object

BSC.BSC_REPORTING_CALENDAR is referenced by following:

APPS
SYNONYM - BSC_REPORTING_CALENDAR

[top of page]

Table: BSC_RESPONSIBILITY

Description: Responsibilities information
Primary Key: BSC_RESPONSIBILITY_PK
  1. RESPONSIBILITY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_RESPONSIBILITY_TL.RESPONSIBILITY_ID BSC_RESPONSIBILITY
BSC_USER_RESPONSIBILITY.RESPONSIBILITY_ID BSC_RESPONSIBILITY
BSC_USER_TAB_ACCESS.RESPONSIBILITY_ID BSC_RESPONSIBILITY
Comments

BSC_RESPONSIBILITY stores information about BSC responsibilities such as responsibility identifier, Application identifier, responsibility name, etc.

Indexes
Index Type Tablespace Column
BSC_RESPONSIBILITY_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
RESPONSIBILITY_ID
BSC_RESPONSIBILITY_U2 UNIQUE APPS_TS_TX_IDX RESPONSIBILITY_KEY
APPLICATION_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y Application identifier
RESPONSIBILITY_ID NUMBER (15) Y Responsibility identifier
RESPONSIBILITY_NAME VARCHAR2 (100)
Responsibility name
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DATA_GROUP_APPLICATION_ID NUMBER (15) Y Data group application identifier
DATA_GROUP_ID NUMBER (15) Y Data group identifier
FORM_APPLICATION_ID NUMBER (15)
Form application identifier
FORM_ID NUMBER (15)
Form identifier
MENU_APPLICATION_ID NUMBER (15)
Menu application identifier
MENU_ID NUMBER (15) Y Menu identifier
RO_ORACLE_ID_ACCESS_FLAG VARCHAR2 (1)
Ro Oracle identifier access flag
TERM_SECURITY_ENABLED_FLAG VARCHAR2 (1)
Term security enabled flag
START_DATE DATE
Y Start date
END_DATE DATE

End date
DESCRIPTION VARCHAR2 (240)
Description
GROUP_APPLICATION_ID NUMBER (15)
Group application identifier
REQUEST_GROUP_ID NUMBER (15)
Request group identifier
VERSION VARCHAR2 (1)
Version
WEB_HOST_NAME VARCHAR2 (80)
Web host name
WEB_AGENT_NAME VARCHAR2 (80)
Web agent name
RESPONSIBILITY_KEY VARCHAR2 (30) Y Responsibilty key

[top of page]

BSC.BSC_RESPONSIBILITY does not reference any database object

BSC.BSC_RESPONSIBILITY is referenced by following:

APPS
SYNONYM - BSC_RESPONSIBILITY

[top of page]

Table: BSC_RESPONSIBILITY_TL

Description: Translated BSC responsibilities information.
Primary Key: BSC_RESPONSIBILITY_TL_PK
  1. APPLICATION_ID
  2. LANGUAGE
  3. RESPONSIBILITY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_RESPONSIBILITY_TL.RESPONSIBILITY_ID BSC_RESPONSIBILITY
Comments

BSC_RESPONSIBILITY stores translated information about BSC responsibilities.

Indexes
Index Type Tablespace Column
BSC_RESPONSIBILITY_TL_U1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
RESPONSIBILITY_ID
LANGUAGE
BSC_RESPONSIBILITY_TL_U2 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
RESPONSIBILITY_NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Y Application identifier
RESPONSIBILITY_ID NUMBER
Y Responsibility identifier
LANGUAGE VARCHAR2 (30) Y Language code
RESPONSIBILITY_NAME VARCHAR2 (100) Y Responsibility name
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DESCRIPTION VARCHAR2 (240)
Description
TRANSLATED VARCHAR2 (1)
Translated
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.

[top of page]

BSC.BSC_RESPONSIBILITY_TL does not reference any database object

BSC.BSC_RESPONSIBILITY_TL is referenced by following:

APPS
SYNONYM - BSC_RESPONSIBILITY_TL

[top of page]

Table: BSC_RPT_KEYS

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER

REPORT_DATE DATE

XTD_PERIOD NUMBER

XTD_YEAR NUMBER

XTD_PERIODICITY NUMBER

PERIOD NUMBER

YEAR NUMBER

PERIOD_TYPE_ID NUMBER

PERIODICITY_ID NUMBER

PERIOD_FLAG NUMBER

DAY_COUNT NUMBER

ROLLING_FLAG VARCHAR2 (40)
LAST_UPDATE_DATE DATE

[top of page]

BSC.BSC_RPT_KEYS does not reference any database object

BSC.BSC_RPT_KEYS is referenced by following:

APPS
SYNONYM - BSC_RPT_KEYS

[top of page]

Table: BSC_SYS_BENCHMARKS_B

Description: Benchmarks information
Primary Key: BSC_SYS_BENCHMARKS_B_PK
  1. BM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_BENCHMARKS_B.PERIODICITY_ID BSC_SYS_PERIODICITIES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_SERIES_COLORS.BM_ID BSC_SYS_BENCHMARKS_B
BSC_SYS_BENCHMARKS_TL.BM_ID BSC_SYS_BENCHMARKS_B
BSC_SYS_BM_GROUPS.BM_ID BSC_SYS_BENCHMARKS_B
Comments

BSC_SYS_BENCHMARKS_B stores information about benchmarks by system such as benchmark identifier and data type.

Indexes
Index Type Tablespace Column
BSC_SYS_BENCHMARKS_B_U1 UNIQUE APPS_TS_TX_IDX BM_ID
BSC_SYS_BENCHMARKS_B_N1 NONUNIQUE APPS_TS_TX_IDX PERIODICITY_ID
Columns
Name Datatype Length Mandatory Comments
BM_ID NUMBER (3) Y Benchmark identifier
COLOR NUMBER (11) Y Benchmark color
DATA_TYPE NUMBER (3) Y Data type in system date tables
SOURCE_TYPE NUMBER (3) Y Default =0, 1 to set the benchmark data in a different system data table
PERIODICITY_ID NUMBER (5)
Periodicity identifier
NO_DISPLAY_FLAG NUMBER (3)
To hide the benchmark
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

BSC.BSC_SYS_BENCHMARKS_B does not reference any database object

BSC.BSC_SYS_BENCHMARKS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_BENCHMARKS_B

[top of page]

Table: BSC_SYS_BENCHMARKS_TL

Description: Translated benchmarks information
Primary Key: BSC_SYS_BENCHMARKS_TL_PK
  1. BM_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_BENCHMARKS_TL.BM_ID BSC_SYS_BENCHMARKS_B
Comments

BSC_SYS_BENCHMARKS_B stores translated information about benchmarks by system.

Indexes
Index Type Tablespace Column
BSC_SYS_BENCHMARKS_TL_U1 UNIQUE APPS_TS_TX_IDX BM_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
BM_ID NUMBER (3) Y Benchmark identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (60) Y Benchmark name

[top of page]

BSC.BSC_SYS_BENCHMARKS_TL does not reference any database object

BSC.BSC_SYS_BENCHMARKS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_BENCHMARKS_TL

[top of page]

Table: BSC_SYS_BM_GROUPS

Description: Benchmark groups information
Primary Key: BSC_SYS_BM_GROUPS_PK
  1. BM_GROUP_ID
  2. BM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_BM_GROUPS.BM_ID BSC_SYS_BENCHMARKS_B
Comments

BSC_SYS_BM_GROUPS stores information about benchmarks groups by system such as benchmark group identifier and benchmark identifier .

Indexes
Index Type Tablespace Column
BSC_SYS_BM_GROUPS_U1 UNIQUE APPS_TS_TX_IDX BM_GROUP_ID
BM_ID
BSC_SYS_BM_GROUPS_N1 NONUNIQUE APPS_TS_TX_IDX BM_ID
Columns
Name Datatype Length Mandatory Comments
BM_GROUP_ID NUMBER (3) Y benchmark group identifier
BM_ID NUMBER (3) Y benchmark identifier

[top of page]

BSC.BSC_SYS_BM_GROUPS does not reference any database object

BSC.BSC_SYS_BM_GROUPS is referenced by following:

APPS
SYNONYM - BSC_SYS_BM_GROUPS

[top of page]

Table: BSC_SYS_CALCULATIONS

Description: System calculations
Primary Key: BSC_SYS_CALCULATIONS_PK
  1. CALCULATION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_CALCULATIONS.CALCULATION_ID BSC_SYS_CALCULATIONS
BSC_SYS_DATASET_CALC.DISABLED_CALC_ID BSC_SYS_CALCULATIONS
Comments

BSC_SYS_CALCULATIONS stores the supported calculations.

Indexes
Index Type Tablespace Column
BSC_SYS_CALCULATIONS_U1 UNIQUE APPS_TS_SEED CALCULATION_ID
Columns
Name Datatype Length Mandatory Comments
CALCULATION_ID NUMBER (5) Y Calculation Id
DEFAULT_VALUE NUMBER (3)
Default Value (0=False,1 = True)

[top of page]

BSC.BSC_SYS_CALCULATIONS does not reference any database object

BSC.BSC_SYS_CALCULATIONS is referenced by following:

APPS
SYNONYM - BSC_SYS_CALCULATIONS

[top of page]

Table: BSC_SYS_CALENDARS_B

Description: Calendar information
Primary Key: BSC_SYS_CALENDARS_B_PK
  1. CALENDAR_ID
Comments

BSC_SYS_CALENDAR S_B stores information about calendars. Each row includes calendar id, the fiscal year,Edw calendar id, Edw calendar type id and etc..

Indexes
Index Type Tablespace Column
BSC_SYS_CALENDARS_B_U1 UNIQUE APPS_TS_TX_IDX CALENDAR_ID
Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER
Y Calendar identifier
EDW_FLAG NUMBER (1) Y EDW identifier
EDW_CALENDAR_ID NUMBER

EDW Calendar identifier
EDW_CALENDAR_TYPE_ID NUMBER

EDW Calendar type identifier
FISCAL_YEAR NUMBER (4) Y Fiscal year of the current calendar
FISCAL_CHANGE NUMBER (1) Y Flag to indicates that fiscal year had changed
RANGE_YR_MOD NUMBER (1) Y Flag to indicates that range of years had changed
CURRENT_YEAR NUMBER (4)
Current calendar year
START_MONTH NUMBER (2)
Start Calendar Month
START_DAY NUMBER (3)
Start Calendar day
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SHORT_NAME VARCHAR2 (30)

[top of page]

BSC.BSC_SYS_CALENDARS_B does not reference any database object

BSC.BSC_SYS_CALENDARS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_CALENDARS_B

[top of page]

Table: BSC_SYS_CALENDARS_TL

Description: Translated calendar information
Primary Key: BSC_SYS_CALENDARS_TL_PK
  1. CALENDAR_ID
  2. LANGUAGE
Comments

BSC_SYS_CALENDARS_TL stores translated information about calendars.

Indexes
Index Type Tablespace Column
BSC_SYS_CALENDARS_TL_U1 UNIQUE APPS_TS_TX_IDX CALENDAR_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER
Y calendar identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (150)
Calendar Name (max 50 chars)
HELP VARCHAR2 (240)
Calendar Name (max 80 chars)
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_SYS_CALENDARS_TL does not reference any database object

BSC.BSC_SYS_CALENDARS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_CALENDARS_TL

[top of page]

Table: BSC_SYS_COLORS_B

Description: Table to store all colors and related properties, mainly used for the Performance Bands.
Comments
Table to store all colors and related properties, mainly used for the Performance Bands.
Indexes
Index Type Tablespace Column
BSC_SYS_COLORS_B_U1 UNIQUE APPS_TS_TX_IDX COLOR_ID
BSC_SYS_COLORS_B_U2 UNIQUE APPS_TS_TX_IDX SHORT_NAME
BSC_SYS_COLORS_B_U3 UNIQUE APPS_TS_TX_IDX PERF_SEQUENCE
Columns
Name Datatype Length Mandatory Comments
COLOR_ID NUMBER (8) Y Color Id
SHORT_NAME VARCHAR2 (30) Y Short Name
PERF_SEQUENCE NUMBER (2)
Denotes the significance of the color w.r.t. color calculations
COLOR NUMBER (10)
System level value
USER_COLOR NUMBER (10)
User customized value
FORECAST_COLOR NUMBER (10)
System level value for Forecast color
USER_FORECAST_COLOR NUMBER (10)
User customized value for Forecast color
NUMERIC_EQUIVALENT NUMBER (6)
Numeric equivalent to be used in Weighted Average calculations
USER_NUMERIC_EQUIVALENT NUMBER (6)
User customized value
USER_IMAGE_ID NUMBER (15)
Image icon for the color
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER (15) Y Creation By
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATED_BY NUMBER (15) Y Last Updated By
LAST_UPDATE_LOGIN NUMBER (15)
Last Updated Login

[top of page]

BSC.BSC_SYS_COLORS_B does not reference any database object

BSC.BSC_SYS_COLORS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_COLORS_B

[top of page]

Table: BSC_SYS_COLORS_TL

Description: Translation table for colors
Comments
Translation table for colors
Indexes
Index Type Tablespace Column
BSC_SYS_COLORS_TL_U1 UNIQUE APPS_TS_TX_IDX COLOR_ID
LANGUAGE
BSC_SYS_COLORS_TL_N1 NONUNIQUE APPS_TS_TX_IDX NAME
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
COLOR_ID NUMBER (8) Y Color Id
NAME VARCHAR2 (120)
System level color name
DESCRIPTION VARCHAR2 (240)
System level color description
LANGUAGE VARCHAR2 (4)
Language
SOURCE_LANG VARCHAR2 (4)
Source language
CREATION_DATE DATE
Y Creation Date
CREATED_BY NUMBER (15) Y Created By
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATED_BY NUMBER (15) Y Last Updated By
LAST_UPDATE_LOGIN NUMBER (15)
Last Updated Login
PROTOTYPE_LABEL VARCHAR2 (120)
Label for the color in prototype mode

[top of page]

BSC.BSC_SYS_COLORS_TL does not reference any database object

BSC.BSC_SYS_COLORS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_COLORS_TL

[top of page]

Table: BSC_SYS_COM_DIM_LEVELS

Description: Common dimension levels information
Primary Key: BSC_SYS_COM_DIM_LEVELS_PK
  1. DIM_LEVEL_INDEX
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_COM_DIM_LEVELS.TAB_ID BSC_TABS_B
BSC_SYS_COM_DIM_LEVELS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_COM_DIM_LEVELS.PARENT_DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
Comments

BSC_SYS_COM_DIM_LEVELS stores information about the common dimension levels by tab.
Each row includes values that identify the dimension level in the list button such as tab identifier,
dimension level index and identifier.

Indexes
Index Type Tablespace Column
BSC_SYS_COM_DIM_LEVELS_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
DIM_LEVEL_INDEX
BSC_SYS_COM_DIM_LEVELS_N1 NONUNIQUE APPS_TS_TX_IDX DIM_LEVEL_ID
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
DIM_LEVEL_INDEX NUMBER (3) Y Dimension level index
DIM_LEVEL_ID NUMBER (5) Y Dimension level identifier
PARENT_LEVEL_INDEX NUMBER (3)
Parent dimension level index
PARENT_DIM_LEVEL_ID NUMBER (5)
Parent dimension level identifier

[top of page]

BSC.BSC_SYS_COM_DIM_LEVELS does not reference any database object

BSC.BSC_SYS_COM_DIM_LEVELS is referenced by following:

APPS
SYNONYM - BSC_SYS_COM_DIM_LEVELS

[top of page]

Table: BSC_SYS_DATASETS_B

Description: Datasets information
Primary Key: BSC_SYS_DATASETS_B_PK
  1. DATASET_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DATASETS_B.MEASURE_ID1 BSC_SYS_MEASURES
BSC_SYS_DATASETS_B.MEASURE_ID2 BSC_SYS_MEASURES
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_ANALYSIS_MEASURES_B.DATASET_ID BSC_SYS_DATASETS_B
BSC_SYS_DATASETS_TL.DATASET_ID BSC_SYS_DATASETS_B
BSC_SYS_DATASET_CALC.DATASET_ID BSC_SYS_DATASETS_B
Comments

BSC_SYS_DATASETS_B stores information about datasets at system level such as dataset identifier, measure identifier, format identifier, color method and projection flag.

Indexes
Index Type Tablespace Column
BSC_SYS_DATASETS_B_U1 UNIQUE APPS_TS_TX_IDX DATASET_ID
BSC_SYS_DATASETS_B_N1 NONUNIQUE APPS_TS_TX_IDX MEASURE_ID1
BSC_SYS_DATASETS_B_N2 NONUNIQUE APPS_TS_TX_IDX MEASURE_ID2
BSC_SYS_DATASETS_B_N3 NONUNIQUE APPS_TS_TX_IDX FORMAT_ID
Columns
Name Datatype Length Mandatory Comments
DATASET_ID NUMBER (5) Y Dataset identifier
MEASURE_ID1 NUMBER (5) Y Measure identifier
OPERATION VARCHAR2 (3)
Operation between measures (+,/,*,..)
MEASURE_ID2 NUMBER (5)
Measure identifier
FORMAT_ID NUMBER (3) Y Format identifier
COLOR_METHOD NUMBER (3) Y Color method
PROJECTION_FLAG NUMBER (3)
Projection Flag
EDW_FLAG NUMBER (1)
Flag that indicates if the Dataset is EDW
AUTOSCALE_FLAG NUMBER (1)
Flag that indicates if the scale of the graph will be automatic or not
SOURCE VARCHAR2 (10)
Source
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_SYS_DATASETS_B does not reference any database object

BSC.BSC_SYS_DATASETS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_DATASETS_B

[top of page]

Table: BSC_SYS_DATASETS_TL

Description: Translated datasets information
Primary Key: BSC_SYS_DATASETS_TL_PK
  1. DATASET_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DATASETS_TL.DATASET_ID BSC_SYS_DATASETS_B
Comments

BSC_SYS_DATASETS_TL stores translated information about datasets at the system level such as dataset identifier, dataset name and dataset help.

Indexes
Index Type Tablespace Column
BSC_SYS_DATASETS_TL_U1 UNIQUE APPS_TS_TX_IDX DATASET_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
DATASET_ID NUMBER (5) Y Dataset identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (255) Y Dataset name (max 20 chars)
HELP VARCHAR2 (1024) Y Dataset help (max 80 chars)
Y_AXIS_TITLE VARCHAR2 (90)
Y axis title (max 30 chars)

[top of page]

BSC.BSC_SYS_DATASETS_TL does not reference any database object

BSC.BSC_SYS_DATASETS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_DATASETS_TL

[top of page]

Table: BSC_SYS_DATASET_CALC

Description: Disabled calculations information per dataset
Primary Key: BSC_SYS_DATASET_CALC_PK
  1. DATASET_ID
  2. DISABLED_CALC_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DATASET_CALC.DATASET_ID BSC_SYS_DATASETS_B
BSC_SYS_DATASET_CALC.DISABLED_CALC_ID BSC_SYS_CALCULATIONS
Comments

BSC_SYS_DATASET_CAL stores information about which calculations are disabled by dataset.

Indexes
Index Type Tablespace Column
BSC_SYS_DATASET_CALC_U1 UNIQUE APPS_TS_TX_IDX DATASET_ID
DISABLED_CALC_ID
Columns
Name Datatype Length Mandatory Comments
DATASET_ID NUMBER (5) Y Dataset identifier
DISABLED_CALC_ID NUMBER (5) Y Disabled calculation identifier

[top of page]

BSC.BSC_SYS_DATASET_CALC does not reference any database object

BSC.BSC_SYS_DATASET_CALC is referenced by following:

APPS
SYNONYM - BSC_SYS_DATASET_CALC

[top of page]

Table: BSC_SYS_DIM_GROUPS_TL

Description: Translated dimension groups information
Primary Key: BSC_SYS_DIM_GROUPS_TL_PK
  1. DIM_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_GROUPS.DIM_GROUP_ID BSC_SYS_DIM_GROUPS_TL
BSC_SYS_DIM_LEVELS_BY_GROUP.DIM_GROUP_ID BSC_SYS_DIM_GROUPS_TL
Comments

BSC_SYS_DIM_GROUPS_TL stores translated information about the dimension groups such as dimension group identifier and dimension group name.

Indexes
Index Type Tablespace Column
BSC_SYS_DIM_GROUPS_TL_U1 UNIQUE APPS_TS_TX_IDX DIM_GROUP_ID
LANGUAGE
BSC_SYS_DIM_GROUPS_TL_N1 NONUNIQUE APPS_TS_TX_IDX SHORT_NAME
Columns
Name Datatype Length Mandatory Comments
DIM_GROUP_ID NUMBER (5) Y Dimension group identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (255) Y Dimension group name
SHORT_NAME VARCHAR2 (30)
Short name
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_SYS_DIM_GROUPS_TL does not reference any database object

BSC.BSC_SYS_DIM_GROUPS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_GROUPS_TL

[top of page]

Table: BSC_SYS_DIM_LEVELS_B

Description: Dimension levels information
Primary Key: BSC_SYS_DIM_LEVELS_B_PK
  1. DIM_LEVEL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DIM_LEVEL_PROPERTIES.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_COM_DIM_LEVELS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_COM_DIM_LEVELS.PARENT_DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVELS_TL.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVELS_BY_GROUP.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVEL_COLS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVEL_RELS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVEL_RELS.PARENT_DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_FILTERS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_FILTERS_VIEWS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
Comments

BSC_SYS_DIM_LEVELS_B stores information about the dimension levels such as dimension level identifier, dimension level table name, dimension table primary key and abbreviation.

Indexes
Index Type Tablespace Column
BSC_SYS_DIM_LEVELS_B_U1 UNIQUE APPS_TS_TX_IDX DIM_LEVEL_ID
BSC_SYS_DIM_LEVELS_B_N1 NONUNIQUE APPS_TS_TX_IDX LEVEL_TABLE_NAME
BSC_SYS_DIM_LEVELS_B_N2 NONUNIQUE APPS_TS_TX_IDX SOURCE
SHORT_NAME
BSC_SYS_DIM_LEVELS_B_N3 NONUNIQUE APPS_TS_TX_IDX LEVEL_PK_COL
BSC_SYS_DIM_LEVELS_B_N4 NONUNIQUE APPS_TS_TX_IDX SHORT_NAME
Columns
Name Datatype Length Mandatory Comments
DIM_LEVEL_ID NUMBER (5) Y Dimension level identifier
LEVEL_TABLE_NAME VARCHAR2 (30) Y Dimension level table name
TABLE_TYPE NUMBER (3) Y Table type, 0=normal, 1= system table
LEVEL_PK_COL VARCHAR2 (30) Y Primary key column name
ABBREVIATION VARCHAR2 (24) Y Abbreviation to generate dump values
VALUE_ORDER_BY NUMBER (5) Y Level values order
COMP_ORDER_BY NUMBER (5) Y Graph item order
CUSTOM_GROUP NUMBER (5) Y To handle custom groups
USER_KEY_SIZE NUMBER (3) Y CODE_USER size
DISP_KEY_SIZE NUMBER (5) Y NAME size
EDW_FLAG NUMBER (1)
Flag that indicates if the dimension level is EDW
EDW_DIM_ID NUMBER

EDW dimension identifier
EDW_DIM_LEVEL_ID NUMBER

EDW dimension level identifier
EDW_DIM_LEVEL_NAME VARCHAR2 (255)
EDW dimension level name
LEVEL_VIEW_NAME VARCHAR2 (30)
Dimension level view name
SHORT_NAME VARCHAR2 (30)
Short name
SOURCE VARCHAR2 (10)
Source
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_SYS_DIM_LEVELS_B does not reference any database object

BSC.BSC_SYS_DIM_LEVELS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_LEVELS_B

[top of page]

Table: BSC_SYS_DIM_LEVELS_BY_GROUP

Description: Dimension levels by dimension group
Primary Key: BSC_SYS_DIM_LEVELS_BY_GROUP_PK
  1. DIM_LEVEL_ID
  2. DIM_GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DIM_LEVELS_BY_GROUP.DIM_GROUP_ID BSC_SYS_DIM_GROUPS_TL
BSC_SYS_DIM_LEVELS_BY_GROUP.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
Comments

BSC_SYS_DIM_LEVELS_BY_GROUP stores information about the dimension groups
such as dimension group identifier and dimension level identifier. Some of the dimension level properties are set at this level for instance total and comparison flag.

Indexes
Index Type Tablespace Column
BSC_SYS_DIM_LEVELS_BY_GROUP_U1 UNIQUE APPS_TS_TX_IDX DIM_GROUP_ID
DIM_LEVEL_ID
Columns
Name Datatype Length Mandatory Comments
DIM_GROUP_ID NUMBER (5) Y Dimension group identifier
DIM_LEVEL_ID NUMBER (5) Y Dimension level identifier
DIM_LEVEL_INDEX NUMBER (3) Y Dimension level index
TOTAL_FLAG NUMBER (1) Y Flag to indicate if the TOTAL item applies
COMPARISON_FLAG NUMBER (1) Y Flag to indicate if the COMPARISON item applies
FILTER_COLUMN VARCHAR2 (30)
The column to use in condition
FILTER_VALUE NUMBER

The filter value for condition
DEFAULT_VALUE VARCHAR2 (2)
Option Default , 'T'= by total, 'C'= by comparison
DEFAULT_TYPE NUMBER (5)
How to handle default_value, when dimension set is changed
PARENT_IN_TOTAL NUMBER (3)
Behavior when dimension parent is in TOTAL
NO_ITEMS NUMBER (1)
If there are not items the drill will be disabled
WHERE_CLAUSE VARCHAR2 (4000)
where clause statement

[top of page]

BSC.BSC_SYS_DIM_LEVELS_BY_GROUP does not reference any database object

BSC.BSC_SYS_DIM_LEVELS_BY_GROUP is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_LEVELS_BY_GROUP

[top of page]

Table: BSC_SYS_DIM_LEVELS_TL

Description: Translated dimension levels information
Primary Key: BSC_SYS_DIM_LEVELS_TL_PK
  1. DIM_LEVEL_ID
  2. LANGUAGE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DIM_LEVELS_TL.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
Comments

BSC_SYS_DIM_LEVELS_TL stores translated information about the dimension levels such as dimension level identifier and dimension level name.

Indexes
Index Type Tablespace Column
BSC_SYS_DIM_LEVELS_TL_U1 UNIQUE APPS_TS_TX_IDX DIM_LEVEL_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
DIM_LEVEL_ID NUMBER (5) Y Dimension level identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (255) Y Dimension level name
HELP VARCHAR2 (1024) Y Dimension level help
TOTAL_DISP_NAME VARCHAR2 (45)
Caption for TOTAL item
COMP_DISP_NAME VARCHAR2 (45)
Caption for COMPARISON item

[top of page]

BSC.BSC_SYS_DIM_LEVELS_TL does not reference any database object

BSC.BSC_SYS_DIM_LEVELS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_LEVELS_TL

[top of page]

Table: BSC_SYS_DIM_LEVEL_COLS

Description: Dimension levels table structure
Primary Key: BSC_SYS_DIM_LEVEL_COLS_PK
  1. COLUMN_NAME
  2. DIM_LEVEL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DIM_LEVEL_COLS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
Comments

BSC_SYS_DIM_LEVEL_COLS stores information about the dimension levels and table structure such as dimension level identifier, column name and column type.

Indexes
Index Type Tablespace Column
BSC_SYS_DIM_LEVEL_COLS_U1 UNIQUE APPS_TS_TX_IDX DIM_LEVEL_ID
COLUMN_NAME
Columns
Name Datatype Length Mandatory Comments
DIM_LEVEL_ID NUMBER (5) Y Dimension level identifier
COLUMN_NAME VARCHAR2 (30) Y Column name
COLUMN_TYPE VARCHAR2 (1) Y Column type

[top of page]

BSC.BSC_SYS_DIM_LEVEL_COLS does not reference any database object

BSC.BSC_SYS_DIM_LEVEL_COLS is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_LEVEL_COLS

[top of page]

Table: BSC_SYS_DIM_LEVEL_RELS

Description: Dimension levels relationships
Primary Key: BSC_SYS_DIM_LEVEL_RELS_PK
  1. DIM_LEVEL_ID
  2. PARENT_DIM_LEVEL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_DIM_LEVEL_RELS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
BSC_SYS_DIM_LEVEL_RELS.PARENT_DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
Comments

BSC_SYS_DIM_LEVELS_RELS stores information about the relationships between dimension levels
such as dimension level identifier, parent dimension level identifier and realtionship type.

Indexes
Index Type Tablespace Column
BSC_SYS_DIM_LEVEL_RELS_U1 UNIQUE APPS_TS_TX_IDX DIM_LEVEL_ID
PARENT_DIM_LEVEL_ID
BSC_SYS_DIM_LEVEL_RELS_N1 NONUNIQUE APPS_TS_TX_IDX RELATION_COL
Columns
Name Datatype Length Mandatory Comments
DIM_LEVEL_ID NUMBER (5) Y Dimension level identifier
RELATION_COL VARCHAR2 (50)
Relation field
PARENT_DIM_LEVEL_ID NUMBER (5) Y Parent dimension level identifier
RELATION_TYPE NUMBER (15) Y Relation Type, 1= 1xn, 2 = nxm
DIRECT_RELATION NUMBER (3)
Direct relationship flag
DATA_SOURCE_TYPE VARCHAR2 (30)
Data source type
DATA_SOURCE VARCHAR2 (240)
Data source

[top of page]

BSC.BSC_SYS_DIM_LEVEL_RELS does not reference any database object

BSC.BSC_SYS_DIM_LEVEL_RELS is referenced by following:

APPS
SYNONYM - BSC_SYS_DIM_LEVEL_RELS

[top of page]

Table: BSC_SYS_FILES

Description: Files information
Primary Key: BSC_SYS_FILES_PK
  1. FILE_INDEX
  2. FILE_TYPE
  3. INDICATOR
Comments

BSC_SYS_FILES stores information about the binary files that are used by BSC at system and indicator level such as logo bitmap file and formula one file.

Indexes
Index Type Tablespace Column
BSC_SYS_FILES_U1 UNIQUE APPS_TS_TX_IDX INDICATOR
FILE_TYPE
FILE_INDEX
SYS_IL0000082254C00010$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y Indicator code or 0 for system level
FILE_TYPE VARCHAR2 (20) Y File type
FILE_INDEX NUMBER (3) Y File Index
FILE_NAME VARCHAR2 (35)
File name
DESCRIPTION VARCHAR2 (100)
File description
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
FILE_BODY BLOB (4000) Y Binary file

[top of page]

BSC.BSC_SYS_FILES does not reference any database object

BSC.BSC_SYS_FILES is referenced by following:

APPS
SYNONYM - BSC_SYS_FILES

[top of page]

Table: BSC_SYS_FILTERS

Description: Filter information
Primary Key: BSC_SYS_FILTERS_PK
  1. DIM_LEVEL_ID
  2. SOURCE_CODE
  3. SOURCE_TYPE
  4. DIM_LEVEL_VALUE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_FILTERS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
Comments

BSC_SYS_FILTERS stores information about filter definition such as dimension level identifier and dimension level value. The SOURCE_TYPE and SOURCE_CODE columns are used to define the filter level at System, Tab or indicator level. At this moment the filter is only at TAB level.

Indexes
Index Type Tablespace Column
BSC_SYS_FILTERS_U1 UNIQUE APPS_TS_TX_IDX SOURCE_TYPE
SOURCE_CODE
DIM_LEVEL_ID
DIM_LEVEL_VALUE
Columns
Name Datatype Length Mandatory Comments
SOURCE_TYPE NUMBER (3) Y Source type
SOURCE_CODE NUMBER (5) Y Source code. Tab identifier or indicator code
DIM_LEVEL_ID NUMBER (5) Y Dimension level identifier
DIM_LEVEL_VALUE VARCHAR2 (400) Y Dimension level value

[top of page]

BSC.BSC_SYS_FILTERS does not reference any database object

BSC.BSC_SYS_FILTERS is referenced by following:

APPS
SYNONYM - BSC_SYS_FILTERS

[top of page]

Table: BSC_SYS_FILTERS_VIEWS

Description: Filter views information
Primary Key: BSC_SYS_FILTERS_VIEWS_PK
  1. DIM_LEVEL_ID
  2. SOURCE_TYPE
  3. SOURCE_CODE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_FILTERS_VIEWS.DIM_LEVEL_ID BSC_SYS_DIM_LEVELS_B
Comments

BSC_SYS_FILTERS_VIEWS stores information about filter views such as dimension level identifier, dimension level table name and dimension level view name.

Indexes
Index Type Tablespace Column
BSC_SYS_FILTERS_VIEWS_U1 UNIQUE APPS_TS_TX_IDX SOURCE_TYPE
SOURCE_CODE
DIM_LEVEL_ID
Columns
Name Datatype Length Mandatory Comments
SOURCE_TYPE NUMBER (3) Y Source type
SOURCE_CODE NUMBER (5) Y Source code. Tab identifier or indicator code
DIM_LEVEL_ID NUMBER (5) Y Dimension level identifier
LEVEL_TABLE_NAME VARCHAR2 (30) Y Dimension level table name
LEVEL_VIEW_NAME VARCHAR2 (30) Y Dimension level view name

[top of page]

BSC.BSC_SYS_FILTERS_VIEWS does not reference any database object

BSC.BSC_SYS_FILTERS_VIEWS is referenced by following:

APPS
SYNONYM - BSC_SYS_FILTERS_VIEWS

[top of page]

Table: BSC_SYS_FORMATS

Description: Number format
Primary Key: BSC_SYS_FORMATS_PK
  1. FORMAT_ID
Comments

BSC_SYS_FORMATS stores information about number formats as percent, currency and decimal format.

Indexes
Index Type Tablespace Column
BSC_SYS_FORMATS_U1 UNIQUE APPS_TS_SEED FORMAT_ID
Columns
Name Datatype Length Mandatory Comments
FORMAT_ID NUMBER (3) Y Format identifier
NAME VARCHAR2 (10) Y Format name
FORMAT VARCHAR2 (15) Y Number format (#,%,$)

[top of page]

BSC.BSC_SYS_FORMATS does not reference any database object

BSC.BSC_SYS_FORMATS is referenced by following:

APPS
SYNONYM - BSC_SYS_FORMATS

[top of page]

Table: BSC_SYS_IMAGES

Description: Images files information
Primary Key: BSC_SYS_IMAGES_PK
  1. IMAGE_ID
Comments

BSC_SYS_IMAGES stores information about the binary image files that are used by BSC.

Indexes
Index Type Tablespace Column
BSC_SYS_IMAGES_U1 UNIQUE APPS_TS_TX_IDX IMAGE_ID
SYS_IL0000163982C00004$$ UNIQUE APPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
IMAGE_ID NUMBER (15) Y Image identifier
FILE_NAME VARCHAR2 (90) Y File Name
DESCRIPTION VARCHAR2 (150)
File Description
FILE_BODY BLOB (4000) Y Binary File
WIDTH NUMBER (5) Y Position -WIDTH
HEIGHT NUMBER (5) Y Position -HEIGHT
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
MIME_TYPE VARCHAR2 (240)

[top of page]

BSC.BSC_SYS_IMAGES does not reference any database object

BSC.BSC_SYS_IMAGES is referenced by following:

APPS
SYNONYM - BSC_SYS_IMAGES

[top of page]

Table: BSC_SYS_IMAGES_MAP_TL

Description: Image map information
Primary Key: BSC_SYS_IMAGES_MAP_TL_PK
  1. SOURCE_TYPE
  2. LANGUAGE
  3. TYPE
  4. SOURCE_CODE
Comments

BSC_SYS_IMAGES_MAP_TL stores information about the relation between BSC levels, such as system or tab level, and image files.

Indexes
Index Type Tablespace Column
BSC_SYS_IMAGES_MAP_TL_U1 UNIQUE APPS_TS_TX_IDX SOURCE_TYPE
SOURCE_CODE
TYPE
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SOURCE_TYPE NUMBER (3) Y Source Type
SOURCE_CODE NUMBER (5) Y Source Code
TYPE NUMBER (15) Y Tab view id if SOURCE_TYPE=1
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
IMAGE_ID NUMBER (15) Y Image identifier
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_SYS_IMAGES_MAP_TL does not reference any database object

BSC.BSC_SYS_IMAGES_MAP_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_IMAGES_MAP_TL

[top of page]

Table: BSC_SYS_INIT

Description: System Properties
Primary Key: BSC_SYS_INIT_PK
  1. PROPERTY_CODE
Comments

BSC_SYS_INIT stores system properties

Indexes
Index Type Tablespace Column
BSC_SYS_INIT_U1 UNIQUE APPS_TS_TX_IDX PROPERTY_CODE
Columns
Name Datatype Length Mandatory Comments
PROPERTY_CODE VARCHAR2 (15) Y Property code
PROPERTY_VALUE VARCHAR2 (90)
Property value
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_SYS_INIT does not reference any database object

BSC.BSC_SYS_INIT is referenced by following:

APPS
SYNONYM - BSC_SYS_INIT

[top of page]

Table: BSC_SYS_KPI_COLORS

Description: Kpi color by tab
Primary Key: BSC_SYS_KPI_COLORS_PK
  1. DIM_LEVEL3
  2. DIM_LEVEL7
  3. DIM_LEVEL2
  4. DIM_LEVEL1
  5. TAB_ID
  6. PERIOD_ID
  7. INDICATOR
  8. DIM_LEVEL8
  9. DIM_LEVEL6
  10. DIM_LEVEL4
  11. DIM_LEVEL5
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_KPI_COLORS.TAB_ID
BSC_SYS_KPI_COLORS.INDICATOR 		BSC_TAB_INDICATORS
Comments

BSC_SYS_KPI_COLORS stores kpi color by tab. Each row includes values that identify the particular indicator information in the tab such as color, actual data, budget data, trend flag by tab and dimension level in the List Button.

Indexes
Index Type Tablespace Column
BSC_SYS_KPI_COLORS_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
INDICATOR
KPI_MEASURE_ID
DIM_LEVEL1
DIM_LEVEL2
DIM_LEVEL3
DIM_LEVEL4
DIM_LEVEL5
DIM_LEVEL6
DIM_LEVEL7
DIM_LEVEL8
PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
INDICATOR NUMBER (5) Y Indicator code
DIM_LEVEL1 VARCHAR2 (400) Y Dimension level 1
DIM_LEVEL2 VARCHAR2 (400) Y Dimension level 2
DIM_LEVEL3 VARCHAR2 (400) Y Dimension level 3
DIM_LEVEL4 VARCHAR2 (400) Y Dimension level 4
DIM_LEVEL5 VARCHAR2 (400) Y Dimension level 5
DIM_LEVEL6 VARCHAR2 (400) Y Dimension level 6
DIM_LEVEL7 VARCHAR2 (400) Y Dimension level 7
DIM_LEVEL8 VARCHAR2 (400) Y Dimension level 8
PERIOD_ID NUMBER (5) Y Period identifier
KPI_COLOR NUMBER (11) Y Indicator color
USER_COLOR NUMBER (11) Y Customize color
ACTUAL_DATA NUMBER

Actual data
BUDGET_DATA NUMBER

Budget data
TREND_FLAG NUMBER (1)
Trend Flag
KPI_TREND NUMBER

Trend Id of the KPI Measure
KPI_MEASURE_ID NUMBER

KPI Measure Id

[top of page]

BSC.BSC_SYS_KPI_COLORS does not reference any database object

BSC.BSC_SYS_KPI_COLORS is referenced by following:

APPS
SYNONYM - BSC_SYS_KPI_COLORS

[top of page]

Table: BSC_SYS_LABELS_B

Description: Labels information
Primary Key: BSC_SYS_LABELS_B_PK
  1. LABEL_ID
  2. SOURCE_TYPE
  3. SOURCE_CODE
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_SYS_LABELS_TL.SOURCE_CODE
BSC_SYS_LABELS_TL.SOURCE_TYPE
BSC_SYS_LABELS_TL.LABEL_ID 		BSC_SYS_LABELS_B
Comments

BSC_SYS_LABELS_B stores information about labels for tabs and simulation tree indicators.

Indexes
Index Type Tablespace Column
BSC_SYS_LABELS_B_U1 UNIQUE APPS_TS_TX_IDX SOURCE_TYPE
SOURCE_CODE
LABEL_ID
Columns
Name Datatype Length Mandatory Comments
SOURCE_TYPE NUMBER (3) Y Source type
SOURCE_CODE NUMBER (5) Y Source code. Tab identifier or indicator code
LABEL_ID NUMBER (3) Y Label identifier
LEFT_POSITION NUMBER (5)
Position -LEFT
TOP_POSITION NUMBER (5)
Position -TOP
FONT_SIZE NUMBER (5)
Font size
FONT_STYLE NUMBER (5)
Font style

[top of page]

BSC.BSC_SYS_LABELS_B does not reference any database object

BSC.BSC_SYS_LABELS_B is referenced by following:

APPS
SYNONYM - BSC_SYS_LABELS_B

[top of page]

Table: BSC_SYS_LABELS_TL

Description: Translated label information
Primary Key: BSC_SYS_LABELS_TL_PK
  1. LABEL_ID
  2. LANGUAGE
  3. SOURCE_CODE
  4. SOURCE_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_SYS_LABELS_TL.SOURCE_CODE
BSC_SYS_LABELS_TL.SOURCE_TYPE
BSC_SYS_LABELS_TL.LABEL_ID 		BSC_SYS_LABELS_B
Comments

BSC_SYS_LABELS_TL stores translated information about labels for tabs and simulation tree indicators.

Indexes
Index Type Tablespace Column
BSC_SYS_LABELS_TL_U1 UNIQUE APPS_TS_TX_IDX SOURCE_TYPE
SOURCE_CODE
LABEL_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
SOURCE_TYPE NUMBER (3) Y Source type
SOURCE_CODE NUMBER (5) Y Source code. Tab identifier or indicator type
LABEL_ID NUMBER (3) Y Label identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (150) Y Label text

[top of page]

BSC.BSC_SYS_LABELS_TL does not reference any database object

BSC.BSC_SYS_LABELS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_LABELS_TL

[top of page]

Table: BSC_SYS_LINES

Description: Lines information
Primary Key: BSC_SYS_LINES_PK
  1. LINE_ID
  2. LINE_TYPE
  3. SOURCE_CODE
  4. SOURCE_TYPE
Comments

BSC_SYS_LINES stores information about lines for tabs and simulation tree indicators.

Indexes
Index Type Tablespace Column
BSC_SYS_LINES_U1 UNIQUE APPS_TS_TX_IDX SOURCE_TYPE
SOURCE_CODE
LINE_TYPE
LINE_ID
Columns
Name Datatype Length Mandatory Comments
SOURCE_TYPE NUMBER (3) Y Source type
SOURCE_CODE NUMBER (5) Y Source code. Tab identifier or indicator type
LINE_TYPE VARCHAR2 (2) Y Line type
LINE_ID NUMBER (3) Y Line identifier
LEFT_POSITION NUMBER (5)
Position -LEFT
TOP_POSITION NUMBER (5)
Position -TOP
LENGTH NUMBER (5)
Position -LENGTH
ARROW VARCHAR2 (1)
Arrow type

[top of page]

BSC.BSC_SYS_LINES does not reference any database object

BSC.BSC_SYS_LINES is referenced by following:

APPS
SYNONYM - BSC_SYS_LINES

[top of page]

Table: BSC_SYS_MEASURES

Description: Measure information
Primary Key: BSC_SYS_MEASURES_PK
  1. MEASURE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_SYS_DATASETS_B.MEASURE_ID1 BSC_SYS_MEASURES
BSC_SYS_DATASETS_B.MEASURE_ID2 BSC_SYS_MEASURES
Comments

BSC_SYS_MEASURES stores information about measures such as measure identifier, measure column, operation and random limit data for prototype mode.

Indexes
Index Type Tablespace Column
BSC_SYS_MEASURES_U1 UNIQUE APPS_TS_TX_IDX MEASURE_ID
BSC_SYS_MEASURES_N1 NONUNIQUE APPS_TS_TX_IDX MEASURE_COL
Columns
Name Datatype Length Mandatory Comments
MEASURE_ID NUMBER (5) Y Measure identifier
MEASURE_COL VARCHAR2 (320) Y Measure column
OPERATION VARCHAR2 (5) Y Measure operation (SUM,AVG,MIN,..)
TYPE NUMBER (3) Y Measure type
MIN_ACTUAL_VALUE NUMBER

Random -Minimum Value
MAX_ACTUAL_VALUE NUMBER

Random -Maximum Value
MIN_BUDGET_VALUE NUMBER

Random -Minimum Budget Value
MAX_BUDGET_VALUE NUMBER

Random -Maximum budget Value
RANDOM_STYLE NUMBER (3)
Random style
EDW_FLAG NUMBER (1)
Flag that indicates if the measure is EDW
EDW_FACT_ID NUMBER

EDW fact table identifier
EDW_MEAS_ID NUMBER

EDW measure identifier
S_COLOR_FORMULA VARCHAR2 (4000)
Simulation Tree color formula
SHORT_NAME VARCHAR2 (30)
Short name
SOURCE VARCHAR2 (10)
Source
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_SYS_MEASURES does not reference any database object

BSC.BSC_SYS_MEASURES is referenced by following:

APPS
SYNONYM - BSC_SYS_MEASURES

[top of page]

Table: BSC_SYS_MM_CONTROLS_TL

Description: Translated multimedia remote control information
Primary Key: BSC_SYS_MM_CONTROLS_TL_PK
  1. BUTTON_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_MM_CONTROLS.BUTTON_ID BSC_SYS_MM_CONTROLS_TL
Comments

BSC_SYS_MM_CONTROL_TL stores translated information about multimedia remote control properties.

Indexes
Index Type Tablespace Column
BSC_SYS_MM_CONTROLS_TL_U1 UNIQUE APPS_TS_TX_IDX BUTTON_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
BUTTON_ID NUMBER (5) Y Button identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (150) Y Button name (max 50 chars)
HELP VARCHAR2 (240) Y Button help (max 80 chars)
COMMAND VARCHAR2 (320)
Command

[top of page]

BSC.BSC_SYS_MM_CONTROLS_TL does not reference any database object

BSC.BSC_SYS_MM_CONTROLS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_MM_CONTROLS_TL

[top of page]

Table: BSC_SYS_OBJECTIVE_COLORS

Description: Table to store the color of the Objectives
Comments
Table to store the color of the Objectives
Indexes
Index Type Tablespace Column
BSC_SYS_OBJECTIVE_COLORS_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
INDICATOR
DIM_LEVEL1
DIM_LEVEL2
DIM_LEVEL3
DIM_LEVEL4
DIM_LEVEL5
DIM_LEVEL6
DIM_LEVEL7
DIM_LEVEL8
PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Scorecard Id
INDICATOR NUMBER (5) Y Objective Id
DIM_LEVEL1 VARCHAR2 (400) Y Dimension Level1 Value
DIM_LEVEL2 VARCHAR2 (400) Y Dimension Level2 Value
DIM_LEVEL3 VARCHAR2 (400) Y Dimension Level3 Value
DIM_LEVEL4 VARCHAR2 (400) Y Dimension Level4 Value
DIM_LEVEL5 VARCHAR2 (400) Y Dimension Level5 Value
DIM_LEVEL6 VARCHAR2 (400) Y Dimension Level6 Value
DIM_LEVEL7 VARCHAR2 (400) Y Dimension Level7 Value
DIM_LEVEL8 VARCHAR2 (400) Y Dimension Level8 Value
PERIOD_ID NUMBER (5) Y Period Id
OBJ_COLOR NUMBER (8) Y Color of the Objective
OBJ_TREND NUMBER

Trend Id of the Objective
DRIVING_KPI_MEASURE_ID NUMBER

The KPI Measure Id based on which Objective color is derived.

[top of page]

BSC.BSC_SYS_OBJECTIVE_COLORS does not reference any database object

BSC.BSC_SYS_OBJECTIVE_COLORS is referenced by following:

APPS
SYNONYM - BSC_SYS_OBJECTIVE_COLORS

[top of page]

Table: BSC_SYS_PERIODICITIES

Description: Periodicity information
Primary Key: BSC_SYS_PERIODICITIES_PK
  1. PERIODICITY_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_DB_TABLES.PERIODICITY_ID BSC_SYS_PERIODICITIES
BSC_KPIS_B.PERIODICITY_ID BSC_SYS_PERIODICITIES
BSC_KPI_PERIODICITIES.PERIODICITY_ID BSC_SYS_PERIODICITIES
BSC_SYS_BENCHMARKS_B.PERIODICITY_ID BSC_SYS_PERIODICITIES
Comments

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.

Indexes
Index Type Tablespace Column
BSC_SYS_PERIODICITIES_U1 UNIQUE APPS_TS_TX_IDX PERIODICITY_ID
BSC_SYS_PERIODICITIES_N1 NONUNIQUE APPS_TS_TX_IDX CALENDAR_ID
Columns
Name Datatype Length Mandatory Comments
PERIODICITY_ID NUMBER (5) Y Periodicity Id
NUM_OF_PERIODS NUMBER (5) Y 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) Y 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)

[top of page]

BSC.BSC_SYS_PERIODICITIES does not reference any database object

BSC.BSC_SYS_PERIODICITIES is referenced by following:

APPS
SYNONYM - BSC_SYS_PERIODICITIES

[top of page]

Table: BSC_SYS_PERIODICITIES_TL

Description: translated periodicity information
Primary Key: BSC_SYS_PERIODICITIES_TL_PK
  1. PERIODICITY_ID
  2. LANGUAGE
Comments

BSC_SYS_PERIODICITIES_TL stores translated information about periodicity.

Indexes
Index Type Tablespace Column
BSC_SYS_PERIODICITIES_TL_U1 UNIQUE APPS_TS_TX_IDX PERIODICITY_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PERIODICITY_ID NUMBER (5) Y Periodicity id
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (150)
Periodicity name (Max 50 Characters)
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_SYS_PERIODICITIES_TL does not reference any database object

BSC.BSC_SYS_PERIODICITIES_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_PERIODICITIES_TL

[top of page]

Table: BSC_SYS_PERIODS

Description: Periods information
Primary Key: BSC_SYS_PERIODS_PK
  1. PERIODICITY_ID
  2. PERIOD_ID
  3. YEAR
Comments

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.

Indexes
Index Type Tablespace Column
BSC_SYS_PERIODS_U1 UNIQUE APPS_TS_TX_IDX PERIODICITY_ID
YEAR
PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
PERIODICITY_ID NUMBER (5) Y Periodicity id
YEAR NUMBER (4) Y Fiscal Year
PERIOD_ID NUMBER (5) Y 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) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
TIME_FK VARCHAR2 (200)
Time foreign key for DBI time dimension

[top of page]

BSC.BSC_SYS_PERIODS does not reference any database object

BSC.BSC_SYS_PERIODS is referenced by following:

APPS
SYNONYM - BSC_SYS_PERIODS

[top of page]

Table: BSC_SYS_PERIODS_TL

Description: Translated Period information
Primary Key: BSC_SYS_PERIODS_TL_PK
  1. YEAR
  2. PERIODICITY_ID
  3. PERIOD_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_COMMENTS.PERIODICITY_ID
BSC_KPI_COMMENTS.PERIOD_ID
BSC_KPI_COMMENTS.YEAR 		BSC_SYS_PERIODS_TL
Comments

BSC_SYS_PERIODS_TL stores translated information about the periods. Each row includes values that identify the particular period such as year,periodicity identifier, period identifier, name and short name.

Indexes
Index Type Tablespace Column
BSC_SYS_PERIODS_TL_U1 UNIQUE APPS_TS_TX_IDX YEAR
PERIODICITY_ID
PERIOD_ID
MONTH
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
YEAR NUMBER (4) Y Year
PERIODICITY_ID NUMBER (5) Y Periodicity id
PERIOD_ID NUMBER (5) Y Period id
MONTH NUMBER (5) Y Month for PERIODICITY_ID = 8 or 10. MONTH =1 for Other periodicities
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (90)
Period name (Max 30 Characters)
SHORT_NAME VARCHAR2 (45)
Period short Name (Max 15Characters)

[top of page]

BSC.BSC_SYS_PERIODS_TL does not reference any database object

BSC.BSC_SYS_PERIODS_TL is referenced by following:

APPS
SYNONYM - BSC_SYS_PERIODS_TL

[top of page]

Table: BSC_SYS_SERIES_COLORS

Description: Series colors information
Primary Key: BSC_SYS_SERIES_COLORS_PK
  1. SERIES_ID
Comments

BSC_SYS_SERIES_COLORS stores the color for each series.

Indexes
Index Type Tablespace Column
BSC_SYS_SERIES_COLORS_U1 UNIQUE APPS_TS_TX_IDX SERIES_ID
Columns
Name Datatype Length Mandatory Comments
SERIES_ID NUMBER (3) Y Series Id
SERIES_COLOR NUMBER (11) Y Series color
BM_COLOR NUMBER (11) Y Series color for Benchmark

[top of page]

BSC.BSC_SYS_SERIES_COLORS does not reference any database object

BSC.BSC_SYS_SERIES_COLORS is referenced by following:

APPS
SYNONYM - BSC_SYS_SERIES_COLORS

[top of page]

Table: BSC_SYS_USER_OPTIONS

Description: User options information
Primary Key: BSC_SYS_USER_OPTIONS_PK
  1. SOURCE_CODE
  2. USER_OPT_ID
  3. SOURCE_TYPE
Comments

BSC_SYS_USER_OPTIONS stores information about user options. The user option could be defined at system, tab or indicator level.

Indexes
Index Type Tablespace Column
BSC_SYS_USER_OPTIONS_U1 UNIQUE APPS_TS_TX_IDX SOURCE_TYPE
SOURCE_CODE
USER_OPT_ID
Columns
Name Datatype Length Mandatory Comments
SOURCE_TYPE NUMBER (3) Y Source type
SOURCE_CODE NUMBER (5) Y Source code. Tab identifier or indicator code
USER_OPT_ID NUMBER (3) Y User option identifier
ENABLED_FLAG NUMBER (3)
To enable the button
DISPLAY_FLAG NUMBER (3)
To display or not

[top of page]

BSC.BSC_SYS_USER_OPTIONS does not reference any database object

BSC.BSC_SYS_USER_OPTIONS is referenced by following:

APPS
SYNONYM - BSC_SYS_USER_OPTIONS

[top of page]

Table: BSC_TABS_B

Description: Tabs information
Primary Key: BSC_TABS_B_PK
  1. TAB_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_SYS_COM_DIM_LEVELS.TAB_ID BSC_TABS_B
BSC_TABS_TL.TAB_ID BSC_TABS_B
BSC_TAB_CSF_B.TAB_ID BSC_TABS_B
BSC_TAB_VIEWS_B.TAB_ID BSC_TABS_B
BSC_USER_LIST_ACCESS.TAB_ID BSC_TABS_B
BSC_USER_TAB_ACCESS.TAB_ID BSC_TABS_B
Comments

BSC_TABS_B stores information about tab such as tab identifier, indicator model flag, default model and zoom factor.

Indexes
Index Type Tablespace Column
BSC_TABS_B_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
BSC_TABS_B_N1 NONUNIQUE APPS_TS_TX_IDX SHORT_NAME
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
KPI_MODEL NUMBER (1)
Indicator Group model flag
BSC_MODEL NUMBER (1)
BSC model flag
CROSS_MODEL NUMBER (1)
Cross model flag
DEFAULT_MODEL NUMBER (15)
Default model
ZOOM_FACTOR NUMBER

Zoom factor for BSC model
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
TAB_INDEX NUMBER (5)
Tab Index
PARENT_TAB_ID NUMBER (5)
Parent Tab identifier
OWNER_ID NUMBER (15)
Owner id
SHORT_NAME VARCHAR2 (30)
Short name

[top of page]

BSC.BSC_TABS_B does not reference any database object

BSC.BSC_TABS_B is referenced by following:

APPS
SYNONYM - BSC_TABS_B

[top of page]

Table: BSC_TABS_TL

Description: Translated tabs information
Primary Key: BSC_TABS_TL_PK
  1. LANGUAGE
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TABS_TL.TAB_ID BSC_TABS_B
Comments

BSC_TABS_TL stores translated information about tabs such as tab identifier, name and help.

Indexes
Index Type Tablespace Column
BSC_TABS_TL_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (105) Y Tab name (max 35 chars)
HELP VARCHAR2 (240)
Tab help (max 80 chars)
ADDITIONAL_INFO VARCHAR2 (150)
Tab help (max 50 chars)

[top of page]

BSC.BSC_TABS_TL does not reference any database object

BSC.BSC_TABS_TL is referenced by following:

APPS
SYNONYM - BSC_TABS_TL

[top of page]

Table: BSC_TAB_CSF_B

Description: Critical success factor information
Primary Key: BSC_TAB_CSF_B_PK
  1. CSF_ID
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_CSF_B.TAB_ID BSC_TABS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_TAB_CSF_TL.CSF_ID
BSC_TAB_CSF_TL.TAB_ID 		BSC_TAB_CSF_B
BSC_TAB_IND_GROUPS_B.CSF_ID
BSC_TAB_IND_GROUPS_B.TAB_ID 		BSC_TAB_CSF_B
Comments

BSC_TABS_CSF_B stores information about critical success factor(CSF) by tab such as tab identifier, CSF identifier and intermediate flag.

Indexes
Index Type Tablespace Column
BSC_TAB_CSF_B_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
CSF_ID
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
CSF_ID NUMBER (3) Y Critical success factor identifier
CSF_TYPE NUMBER (5)
Group panel type
INTERMEDIATE_FLAG NUMBER (1) Y Intermediate flag

[top of page]

BSC.BSC_TAB_CSF_B does not reference any database object

BSC.BSC_TAB_CSF_B is referenced by following:

APPS
SYNONYM - BSC_TAB_CSF_B

[top of page]

Table: BSC_TAB_CSF_TL

Description: Translated critical success factor information
Primary Key: BSC_TAB_CSF_TL_PK
  1. CSF_ID
  2. LANGUAGE
  3. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_CSF_TL.CSF_ID
BSC_TAB_CSF_TL.TAB_ID 		BSC_TAB_CSF_B
Comments

BSC_TABS_CSF_TL stores translated information about critical success factor by tab such as tab identifier, CSF identifier, name and help.

Indexes
Index Type Tablespace Column
BSC_TAB_CSF_TL_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
CSF_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
CSF_ID NUMBER (3) Y Critical success factor identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (90)
Critical success factor name (max 30 chars)
HELP VARCHAR2 (240)
Critical success factor help (max 80 chars)

[top of page]

BSC.BSC_TAB_CSF_TL does not reference any database object

BSC.BSC_TAB_CSF_TL is referenced by following:

APPS
SYNONYM - BSC_TAB_CSF_TL

[top of page]

Table: BSC_TAB_INDICATORS

Description: Indicator by tab information
Primary Key: BSC_TAB_INDICATORS_PK
  1. INDICATOR
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_INDICATORS.INDICATOR BSC_KPIS_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_KPI_DEFAULTS_B.TAB_ID
BSC_KPI_DEFAULTS_B.INDICATOR 		BSC_TAB_INDICATORS
BSC_SYS_KPI_COLORS.TAB_ID
BSC_SYS_KPI_COLORS.INDICATOR 		BSC_TAB_INDICATORS
Comments

BSC_TAB_INDICATOR stores information about relationships between tab and indicator besides some indicator properties for BSC model panel.

Indexes
Index Type Tablespace Column
BSC_TAB_INDICATORS_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
INDICATOR
BSC_TAB_INDICATORS_N1 NONUNIQUE APPS_TS_TX_IDX INDICATOR
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
INDICATOR NUMBER (5) Y Indicator code
BSC_MODEL_FLAG NUMBER (3)
BSC model flag
LEFT_POSITION NUMBER (5)
Position -LEFT
TOP_POSITION NUMBER (5)
Position -TOP
WIDTH NUMBER (5)
Position -WITHD
HEIGHT NUMBER (5)
Position -HEIGHT
BACKCOLOR NUMBER (3)
Indicator panel color in BSC model

[top of page]

BSC.BSC_TAB_INDICATORS does not reference any database object

BSC.BSC_TAB_INDICATORS is referenced by following:

APPS
SYNONYM - BSC_TAB_INDICATORS

[top of page]

Table: BSC_TAB_IND_GROUPS_B

Description: Indicator groups information
Primary Key: BSC_TAB_IND_GROUPS_B_PK
  1. CSF_ID
  2. IND_GROUP_ID
  3. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_IND_GROUPS_B.CSF_ID
BSC_TAB_IND_GROUPS_B.TAB_ID 		BSC_TAB_CSF_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_TAB_IND_GROUPS_TL.CSF_ID
BSC_TAB_IND_GROUPS_TL.IND_GROUP_ID
BSC_TAB_IND_GROUPS_TL.TAB_ID 		BSC_TAB_IND_GROUPS_B
Comments

BSC_TAB_IND_GROUPS_B stores information about indicator groups by tab and critical success factor(CSF) such as tab identifier, CSF identifier, group type and position.

Indexes
Index Type Tablespace Column
BSC_TAB_IND_GROUPS_B_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
CSF_ID
IND_GROUP_ID
BSC_TAB_IND_GROUPS_B_N1 NONUNIQUE APPS_TS_TX_IDX SHORT_NAME
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
CSF_ID NUMBER (3) Y Critical success factor identifier
IND_GROUP_ID NUMBER (5) Y Indicator group identifier
GROUP_TYPE NUMBER (3)
Group type
NAME_POSITION NUMBER (3)
Name position
NAME_JUSTIFICATION NUMBER (3)
Name justification
LEFT_POSITION NUMBER (5)
Position -LEFT
TOP_POSITION NUMBER (5)
Position -TOP
WIDTH NUMBER (5)
Position -WITHD
HEIGHT NUMBER (5)
Position -HEIGHT
SHORT_NAME VARCHAR2 (30)
Short name

[top of page]

BSC.BSC_TAB_IND_GROUPS_B does not reference any database object

BSC.BSC_TAB_IND_GROUPS_B is referenced by following:

APPS
SYNONYM - BSC_TAB_IND_GROUPS_B

[top of page]

Table: BSC_TAB_IND_GROUPS_TL

Description: Translated Indicator groups information
Primary Key: BSC_TAB_IND_GROUPS_TL_PK
  1. CSF_ID
  2. LANGUAGE
  3. TAB_ID
  4. IND_GROUP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_IND_GROUPS_TL.CSF_ID
BSC_TAB_IND_GROUPS_TL.IND_GROUP_ID
BSC_TAB_IND_GROUPS_TL.TAB_ID 		BSC_TAB_IND_GROUPS_B
Comments

BSC_TAB_IND_GROUPS_TL stores translated information about indicator groups by tab and critical success factor(CSF) such as tab identifier, CSF identifier, name and help.

Indexes
Index Type Tablespace Column
BSC_TAB_IND_GROUPS_TL_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
CSF_ID
IND_GROUP_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
CSF_ID NUMBER (3) Y Critical success factor identifier
IND_GROUP_ID NUMBER (5) Y Indicator group identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (150)
Indicator group name (max 50 chars)
HELP VARCHAR2 (240)
Indicator group help (max 80 chars)

[top of page]

BSC.BSC_TAB_IND_GROUPS_TL does not reference any database object

BSC.BSC_TAB_IND_GROUPS_TL is referenced by following:

APPS
SYNONYM - BSC_TAB_IND_GROUPS_TL

[top of page]

Table: BSC_TAB_VIEWS_B

Description: Tab Views information
Primary Key: BSC_TAB_VIEWS_B_PK
  1. TAB_ID
  2. TAB_VIEW_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_TAB_VIEWS_B.TAB_ID BSC_TABS_B
Comments

BSC_TAB_VIEWS_B stores information about tab views by tab such as tab identifier, tab view identifier and enabled flag.

Indexes
Index Type Tablespace Column
BSC_TAB_VIEWS_B_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
TAB_VIEW_ID
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
TAB_VIEW_ID NUMBER (15) Y Tab View identifier
ENABLED_FLAG NUMBER (1) Y Enabled flag
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_TAB_VIEWS_B does not reference any database object

BSC.BSC_TAB_VIEWS_B is referenced by following:

APPS
SYNONYM - BSC_TAB_VIEWS_B

[top of page]

Table: BSC_TAB_VIEWS_TL

Description: Translated Tab Views information
Primary Key: BSC_TAB_VIEWS_TL_PK
  1. TAB_ID
  2. TAB_VIEW_ID
  3. LANGUAGE
Comments

BSC_TAB_VIEWS_TL stores translated information about tab views by tab such as tab identifier, tab view identifier, name and help.

Indexes
Index Type Tablespace Column
BSC_TAB_VIEWS_TL_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
TAB_VIEW_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
TAB_VIEW_ID NUMBER (15) Y Tab View identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
NAME VARCHAR2 (105) Y Tab View name (max 35 chars)
HELP VARCHAR2 (240)
Tab View help (max 80 chars)
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_TAB_VIEWS_TL does not reference any database object

BSC.BSC_TAB_VIEWS_TL is referenced by following:

APPS
SYNONYM - BSC_TAB_VIEWS_TL

[top of page]

Table: BSC_TAB_VIEW_KPI_TL

Description: Translated Indicator by Tab View information
Primary Key: BSC_TAB_VIEW_KPI_TL_PK
  1. TAB_ID
  2. TAB_VIEW_ID
  3. LANGUAGE
  4. INDICATOR
Comments

BSC_TAB_VIEW_KPI_TL stores information about relationships between tab view and indicator besides some indicator properties for Custom view.

Indexes
Index Type Tablespace Column
BSC_TAB_VIEW_KPI_TL_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
TAB_VIEW_ID
INDICATOR
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
TAB_VIEW_ID NUMBER (15) Y Tab View identifier
INDICATOR NUMBER (5) Y Indicator code
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
TEXT_FLAG NUMBER (1) Y Text Flag
LEFT_POSITION NUMBER (5)
Position -LEFT
TOP_POSITION NUMBER (5)
Position -TOP
WIDTH NUMBER (5)
Position -WIDTH
HEIGHT NUMBER (5)
Position -HEIGHT
FONT_SIZE NUMBER (5)
Font Size
FONT_STYLE NUMBER (5)
Font Style
FONT_COLOR NUMBER

Font Color
COLOR_LEFT_POSITION NUMBER (5)
Color Position -LEFT
COLOR_TOP_POSITION NUMBER (5)
Color Position -TOP
COLOR_WIDTH NUMBER (5)
Color Position -WIDTH
COLOR_HEIGHT NUMBER (5)
Color Position -HEIGHT
COLOR_SIZE NUMBER (5)
Color size
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_TAB_VIEW_KPI_TL does not reference any database object

BSC.BSC_TAB_VIEW_KPI_TL is referenced by following:

APPS
SYNONYM - BSC_TAB_VIEW_KPI_TL

[top of page]

Table: BSC_TAB_VIEW_LABELS_B

Description: Tab View information
Primary Key: BSC_TAB_VIEW_LABELS_B_PK
  1. TAB_ID
  2. TAB_VIEW_ID
  3. LABEL_ID
Comments

BSC_TAB_VIEW_LABELS_B stores information about relationships between tab view and labels besides some label properties for Custom view.

Indexes
Index Type Tablespace Column
BSC_TAB_VIEW_LABELS_B_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
TAB_VIEW_ID
LABEL_ID
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
TAB_VIEW_ID NUMBER (15) Y Tab View identifier
LABEL_ID NUMBER (15) Y Label identifier
LABEL_TYPE NUMBER (2) Y Label Type, 0=Normal Label, 1=Tab View Link , 2=App Menu
LINK_ID NUMBER

Link id holds Tab view Id or App Menu Id , depending on label Type
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
FUNCTION_ID NUMBER

[top of page]

BSC.BSC_TAB_VIEW_LABELS_B does not reference any database object

BSC.BSC_TAB_VIEW_LABELS_B is referenced by following:

APPS
SYNONYM - BSC_TAB_VIEW_LABELS_B

[top of page]

Table: BSC_TAB_VIEW_LABELS_TL

Description: Translated Labels by Tab View information
Primary Key: BSC_TAB_VIEW_LABELS_TL_PK
  1. TAB_ID
  2. TAB_VIEW_ID
  3. LABEL_ID
  4. LANGUAGE
Comments

BSC_TAB_VIEW_LABELS_TL stores information about relationships between tab view and labels besides some label properties for Custom view.

Indexes
Index Type Tablespace Column
BSC_TAB_VIEW_LABELS_TL_U1 UNIQUE APPS_TS_TX_IDX TAB_ID
TAB_VIEW_ID
LABEL_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
TAB_VIEW_ID NUMBER (15) Y Tab View identifier
LABEL_ID NUMBER (15) Y Label identifier
LANGUAGE VARCHAR2 (4) Y Language code
SOURCE_LANG VARCHAR2 (4) Y The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
TEXT_FLAG NUMBER (1) Y Text Flag
NAME VARCHAR2 (150)
Label name (max 50 chars)
LEFT_POSITION NUMBER (5)
Position -LEFT
TOP_POSITION NUMBER (5)
Position -TOP
WIDTH NUMBER (5)
Position -WIDTH
HEIGHT NUMBER (5)
Position -HEIGHT
FONT_SIZE NUMBER (5)
Font Size
FONT_STYLE NUMBER (5)
Font Style
FONT_COLOR NUMBER

Font Color
URL VARCHAR2 (320)
URL string
CREATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
NOTE VARCHAR2 (3000)
Note used by Launch Pad

[top of page]

BSC.BSC_TAB_VIEW_LABELS_TL does not reference any database object

BSC.BSC_TAB_VIEW_LABELS_TL is referenced by following:

APPS
SYNONYM - BSC_TAB_VIEW_LABELS_TL

[top of page]

Table: BSC_TMP_BIG_IN_COND

Description: Temporary table used to store information about temporary variables
Comments

Stores Big Condition

Indexes
Index Type Tablespace Column
BSC_TMP_BIG_IN_COND_N1 NONUNIQUE APPS_TS_INTERFACE SESSION_ID
VARIABLE_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER

Session ID
VARIABLE_ID NUMBER

Variable ID
VALUE_N NUMBER

Value N
VALUE_V VARCHAR2 (2000)
Value V

[top of page]

BSC.BSC_TMP_BIG_IN_COND does not reference any database object

BSC.BSC_TMP_BIG_IN_COND is referenced by following:

APPS
SYNONYM - BSC_TMP_BIG_IN_COND

[top of page]

Table: BSC_TMP_OPT_UI_KPIS

Description: Temporary table used to store KPI information, to improve performance
Comments

BSC TMP OPT UI KPIS

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER

Indicator
PROTOTYPE_FLAG NUMBER

Prototype flag
PROCESS_ID NUMBER

specifies the Process identifier.

[top of page]

BSC.BSC_TMP_OPT_UI_KPIS does not reference any database object

BSC.BSC_TMP_OPT_UI_KPIS is referenced by following:

APPS
SYNONYM - BSC_TMP_OPT_UI_KPIS

[top of page]

Table: BSC_TMP_OPT_UI_LEVELS

Description: Temporary table used to store Dimension Sets, to improve performance
Comments

BSC TMP OPT UI LEVELS

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER

Indicator
DIM_SET_ID NUMBER

Dim set Id
DIM_DISPLAY_ORDER NUMBER

Dimension display order
LEVEL_DISPLAY_ORDER NUMBER

Level display order
LEVEL_TABLE_NAME VARCHAR2 (100)
Level table name
LEVEL_DISPLAY_NAME VARCHAR2 (300)
Level Display name
TARGET_LEVEL NUMBER

Target Level

[top of page]

BSC.BSC_TMP_OPT_UI_LEVELS does not reference any database object

BSC.BSC_TMP_OPT_UI_LEVELS is referenced by following:

APPS
SYNONYM - BSC_TMP_OPT_UI_LEVELS

[top of page]

Table: BSC_UI_COLOR_SCHEMES

Description: Scheme information
Primary Key: BSC_UI_COLOR_SCHEMES_PK
  1. SCHEME_CODE
Comments

BSC_UI_COLOR_SCHEMES stores information about schemes used to set different UI. Each scheme contains information such as scheme code, background color and foreground color. The column naming convetion are :
FR = Foreground color
FT = Font color
BG = Background color

Indexes
Index Type Tablespace Column
BSC_UI_COLOR_SCHEMES_U1 UNIQUE APPS_TS_SEED SCHEME_CODE
Columns
Name Datatype Length Mandatory Comments
SCHEME_CODE VARCHAR2 (30) Y Scheme code
DEFAULT_FLAG VARCHAR2 (1) Y Default flag
PANEL_BG NUMBER
Y Panel background color
PANEL_FG NUMBER
Y Panel foreground color
PANE_BG NUMBER
Y Panel background color
PANE_FG NUMBER
Y Panel foreground color
TITLE_BG NUMBER
Y Title background color
TITLE_FG NUMBER
Y Title foreground color
CONTROL_BG NUMBER
Y Control background color such as drop down
CONTROL_FG NUMBER
Y Control foreground color such as drop down
DISPLAY_BG NUMBER
Y Display panel background color
DISPLAY_FG NUMBER
Y Display panel foreground color
TAB1_BG NUMBER
Y Tab panel background color for KPI model
TAB2_BG NUMBER
Y Tab panel background color for BSC model
GROUP_BG NUMBER
Y Kpi group box background color
BASE_P_BG NUMBER
Y Base panel background color
TEXT_FG NUMBER
Y Font color

[top of page]

BSC.BSC_UI_COLOR_SCHEMES does not reference any database object

BSC.BSC_UI_COLOR_SCHEMES is referenced by following:

APPS
SYNONYM - BSC_UI_COLOR_SCHEMES

[top of page]

Table: BSC_UI_COLOR_USER

Description: Customized scheme information
Primary Key: BSC_UI_COLOR_USER_PK
  1. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_UI_COLOR_USER.USER_ID BSC_USERS
Comments

BSC_UI_COLOR_USER stores customized information about schemes such as user identifier, background color and foreground color. The column naming convetion are :
FR = Foreground color
FT = Font color
BG = Background color

Indexes
Index Type Tablespace Column
BSC_UI_COLOR_USER_U1 UNIQUE APPS_TS_SEED USER_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y User identifier
PANEL_BG NUMBER
Y Panel background color
PANEL_FG NUMBER
Y Panel foreground color
PANE_BG NUMBER
Y Panel background color
PANE_FG NUMBER
Y Panel foreground color
TITLE_BG NUMBER
Y Title background color
TITLE_FG NUMBER
Y Title foreground color
CONTROL_BG NUMBER
Y Control background color such as drop down
CONTROL_FG NUMBER
Y Control foreground color such as drop down
DISPLAY_BG NUMBER
Y Display panel foreground color
DISPLAY_FG NUMBER
Y Display panel foreground color
TAB1_BG NUMBER
Y Tab panel background color for KPI model
TAB2_BG NUMBER
Y Tab panel background color for BSC model
GROUP_BG NUMBER
Y Kpi group box background color
BASE_P_BG NUMBER
Y Base panel background color
TEXT_FG NUMBER
Y Font color

[top of page]

BSC.BSC_UI_COLOR_USER does not reference any database object

BSC.BSC_UI_COLOR_USER is referenced by following:

APPS
SYNONYM - BSC_UI_COLOR_USER

[top of page]

Table: BSC_UPGRADE_TASK

Description: Migration process task information
Comments

BSC_UPGRADE_TASK stores information about all the task to perform during the migration process.

Columns
Name Datatype Length Mandatory Comments
TASK_ID NUMBER (3) Y Task identifier
OBJ_NAME VARCHAR2 (30) Y Database object name
ACTION VARCHAR2 (30) Y Create,drop,delete,insert,update
STATUS VARCHAR2 (1) Y Task Status. (P)ending,(C)omplete, (F)ail
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_UPGRADE_TASK does not reference any database object

BSC.BSC_UPGRADE_TASK is referenced by following:

APPS
SYNONYM - BSC_UPGRADE_TASK

[top of page]

Table: BSC_USERS

Description: User information
Primary Key: BSC_USERS_PK
  1. USER_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
BSC_APPS_USERS.USER_ID BSC_USERS
BSC_KPI_ANALYSIS_OPT_USER.USER_ID BSC_USERS
BSC_KPI_CALCULATIONS_USER.USER_ID BSC_USERS
BSC_KPI_DIM_LEVELS_USER.USER_ID BSC_USERS
BSC_KPI_PERIODICITIES_USER.USER_ID BSC_USERS
BSC_KPI_SHELL_CMDS_USER.USER_ID BSC_USERS
BSC_UI_COLOR_USER.USER_ID BSC_USERS
BSC_USER_INFO.USER_ID BSC_USERS
BSC_USER_RESPONSIBILITY.USER_ID BSC_USERS
Comments

BSC_USERS stores information about users.

Indexes
Index Type Tablespace Column
BSC_USERS_U1 UNIQUE APPS_TS_TX_IDX USER_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y User identifier
USER_NAME VARCHAR2 (100)
User name
FULL_NAME VARCHAR2 (100)
User's full name
ENCRYPTED_USER_PASSWORD VARCHAR2 (100)
Encrypted user password
USER_TYPE NUMBER (1)
User type
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
EMPLOYEE_ID VARCHAR2 (30)
Employee identifier
START_DATE DATE

Start date
END_DATE DATE

End date
EMAIL_ADDRESS VARCHAR2 (240)
Email address
DESCRIPTION VARCHAR2 (240)
Description
ENCRYPTED_EMAIL_PASSWORD VARCHAR2 (100)
Encrypted Email password
EMAIL_HOSTNAME VARCHAR2 (100)
Email host name
EMAIL_PROTOCOL VARCHAR2 (30)
Email protocol
SMTP_HOSTNAME VARCHAR2 (30)
SMTP host name
AUTOLOGON_FLAG NUMBER (3)
Auto logon flag

[top of page]

BSC.BSC_USERS does not reference any database object

BSC.BSC_USERS is referenced by following:

APPS
SYNONYM - BSC_USERS

[top of page]

Table: BSC_USER_INFO

Description: Connection information
Primary Key: BSC_USER_INFO_PK
  1. SID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_USER_INFO.USER_ID BSC_USERS
Comments

BSC_USER_INFO stores information about connection. It is used by security package in personal mode.

Indexes
Index Type Tablespace Column
BSC_USER_INFO_U1 UNIQUE APPS_TS_TX_IDX SID
Columns
Name Datatype Length Mandatory Comments
SID NUMBER
Y Session identifier
USER_ID NUMBER (15) Y User identifier
USER_NAME VARCHAR2 (100) Y User name
USER_PWD VARCHAR2 (100) Y User password
USER_TYPE NUMBER (1) Y User type
OBSC_UN VARCHAR2 (100) Y OBSC scheme name
OBSC_PWD VARCHAR2 (100) Y OBSC scheme password
UBSC_UN VARCHAR2 (100) Y UBSC scheme name
UBSC_PWD VARCHAR2 (100) Y UBSC scheme password

[top of page]

BSC.BSC_USER_INFO does not reference any database object

BSC.BSC_USER_INFO is referenced by following:

APPS
SYNONYM - BSC_USER_INFO

[top of page]

Table: BSC_USER_KPIGRAPH_PLUGS

Description: Portlet information by user
Primary Key: BSC_USER_KPIGRAPH_PLUGS_PK
  1. USER_ID
  2. PLUG_ID
Comments

BSC_USER_KPIGRAPH_PLUGS stores information about portlet configuration.

Indexes
Index Type Tablespace Column
BSC_USER_KPIGRAPH_PLUGS_U1 UNIQUE APPS_TS_TX_IDX USER_ID
PLUG_ID
BSC_USER_KPIGRAPH_PLUGS_N1 NONUNIQUE APPS_TS_TX_IDX PLUG_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y User identifier
PLUG_ID NUMBER (20) Y Plug identifier
RESPONSIBILITY_ID NUMBER (15) Y Responsibility identifier
INDICATOR NUMBER (5) Y Indicator identifier
PARAMETER_STRING VARCHAR2 (2000)
Parameter string
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REFERENCE_PATH VARCHAR2 (100)
Refence path used for OAFW portlet

[top of page]

BSC.BSC_USER_KPIGRAPH_PLUGS does not reference any database object

BSC.BSC_USER_KPIGRAPH_PLUGS is referenced by following:

APPS
SYNONYM - BSC_USER_KPIGRAPH_PLUGS

[top of page]

Table: BSC_USER_KPILIST_KPIS

Description: Portlet information by user
Primary Key: BSC_USER_KPILIST_KPIS_PK
  1. PLUG_ID
  2. PARAM_LIST_ID
Comments

BSC_USER_KPILIST_KPIS stores information about portlet configuration.

Indexes
Index Type Tablespace Column
BSC_USER_KPILIST_KPIS_U1 UNIQUE APPS_TS_TX_IDX PLUG_ID
PARAM_LIST_ID
Columns
Name Datatype Length Mandatory Comments
PLUG_ID NUMBER (20) Y Plug identifier
PARAM_LIST_ID NUMBER
Y Parameter List Identifier
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_USER_KPILIST_KPIS does not reference any database object

BSC.BSC_USER_KPILIST_KPIS is referenced by following:

APPS
SYNONYM - BSC_USER_KPILIST_KPIS

[top of page]

Table: BSC_USER_KPILIST_PLUGS

Description: Portlet information by user
Primary Key: BSC_USER_KPILIST_PLUGS_PK
  1. PLUG_ID
Comments

BSC_USER_KPILIST_PLUGS stores information about portlet configuration.

Indexes
Index Type Tablespace Column
BSC_USER_KPILIST_PLUGS_U1 UNIQUE APPS_TS_TX_IDX PLUG_ID
Columns
Name Datatype Length Mandatory Comments
PLUG_ID NUMBER (20) Y Plug identifier
DETAILS_FLAG NUMBER (1) Y Details Flag
GROUP_FLAG NUMBER (1) Y Group Flag
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REFERENCE_PATH VARCHAR2 (100)
Refence path used for OAFW portlet
KPI_MEASURE_DETAILS_FLAG NUMBER (1)
Flag to show KPI Measures' details in the List of Objectives Portlet

[top of page]

BSC.BSC_USER_KPILIST_PLUGS does not reference any database object

BSC.BSC_USER_KPILIST_PLUGS is referenced by following:

APPS
SYNONYM - BSC_USER_KPILIST_PLUGS

[top of page]

Table: BSC_USER_KPI_ACCESS

Description: Indicator permissions
Primary Key: BSC_USER_KPI_ACCESS_PK
  1. INDICATOR
  2. RESPONSIBILITY_ID
Comments

BSC_USER_KPI_ACCESS stores information about indicator permissions by user.

Indexes
Index Type Tablespace Column
BSC_USER_KPI_ACCESS_U1 UNIQUE APPS_TS_TX_IDX RESPONSIBILITY_ID
INDICATOR
Columns
Name Datatype Length Mandatory Comments
RESPONSIBILITY_ID NUMBER (15) Y Responsibility identifier
INDICATOR NUMBER (5) Y Indicator code
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
START_DATE DATE

Start date
END_DATE DATE

End date

[top of page]

BSC.BSC_USER_KPI_ACCESS does not reference any database object

BSC.BSC_USER_KPI_ACCESS is referenced by following:

APPS
SYNONYM - BSC_USER_KPI_ACCESS

[top of page]

Table: BSC_USER_LIST_ACCESS

Description: List button permissions
Primary Key: BSC_USER_LIST_ACCESS_PK
  1. DIM_LEVEL_INDEX
  2. RESPONSIBILITY_ID
  3. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_USER_LIST_ACCESS.TAB_ID BSC_TABS_B
Comments

BSC_USER_LISTI_ACCESS stores information about dimension list button permissions by user.

Indexes
Index Type Tablespace Column
BSC_USER_LIST_ACCESS_U1 UNIQUE APPS_TS_TX_IDX RESPONSIBILITY_ID
TAB_ID
DIM_LEVEL_INDEX
Columns
Name Datatype Length Mandatory Comments
RESPONSIBILITY_ID NUMBER (15) Y Responsibility identifier
TAB_ID NUMBER (5) Y Tab identifier
DIM_LEVEL_INDEX NUMBER (5) Y Dimension level index
DIM_LEVEL_VALUE VARCHAR2 (400) Y Dimension level value
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_USER_LIST_ACCESS does not reference any database object

BSC.BSC_USER_LIST_ACCESS is referenced by following:

APPS
SYNONYM - BSC_USER_LIST_ACCESS

[top of page]

Table: BSC_USER_PARAMETERS_B

Description: Indicator data for information box
Primary Key: BSC_USER_PARAMETERS_B_PK
  1. PARAM_LIST_ID
Comments

BSC_USER_PARAMETERS_B stores information about parameter for portlet information.

Indexes
Index Type Tablespace Column
BSC_USER_PARAMETERS_B_U1 UNIQUE APPS_TS_TX_IDX PARAM_LIST_ID
BSC_USER_PARAMETERS_B_U2 NONUNIQUE APPS_TS_TX_IDX APPLICATION_ID
INDICATOR
VIEW_TYPE
Columns
Name Datatype Length Mandatory Comments
PARAM_LIST_ID NUMBER
Y Parameter List identifier
APPLICATION_ID NUMBER (5) Y Application Identifier
INDICATOR NUMBER
Y Indicator code
VIEW_TYPE NUMBER (1)
View Typw
VALID_FLAG NUMBER (1) Y Valid Flag
ANALYSIS_MEASURES VARCHAR2 (80)
Analysis measures
DIMENSION1 VARCHAR2 (80)
Dimension 1
DIMENSION2 VARCHAR2 (80)
Dimension 2
DIMENSION3 VARCHAR2 (80)
Dimension 3
DIMENSION4 VARCHAR2 (80)
Dimension 4
DIMENSION5 VARCHAR2 (80)
Dimension 5
DIMENSION6 VARCHAR2 (80)
Dimension 6
DIMENSION7 VARCHAR2 (80)
Dimension 7
DIMENSION8 VARCHAR2 (80)
Dimension 8
DIMENSION9 VARCHAR2 (80)
Dimension 9
DIMENSION10 VARCHAR2 (80)
Dimension 10
TIME_PERIOD VARCHAR2 (80)
Time period
DATA_SERIES VARCHAR2 (80)
Data series
CALCULATIONS VARCHAR2 (80)
Calculations
BENCHMARKS VARCHAR2 (80)
Benchmarks
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_USER_PARAMETERS_B does not reference any database object

BSC.BSC_USER_PARAMETERS_B is referenced by following:

APPS
SYNONYM - BSC_USER_PARAMETERS_B

[top of page]

Table: BSC_USER_PARAMETERS_TL

Description: Indicator data for information box
Primary Key: BSC_USER_PARAMETERS_TL_PK
  1. LANGUAGE
  2. PARAM_LIST_ID
Comments

BSC_USER_PARAMETERS_TL stores information about parameter for portlet information.

Indexes
Index Type Tablespace Column
BSC_USER_PARAMETERS_TL_U1 UNIQUE APPS_TS_TX_IDX PARAM_LIST_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
PARAM_LIST_ID NUMBER
Y Parameter List identifier
LANGUAGE VARCHAR2 (4) Y Language Code
SOURCE_LANG VARCHAR2 (4) Y Source Language
TITLE VARCHAR2 (100)
Title
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

BSC.BSC_USER_PARAMETERS_TL does not reference any database object

BSC.BSC_USER_PARAMETERS_TL is referenced by following:

APPS
SYNONYM - BSC_USER_PARAMETERS_TL

[top of page]

Table: BSC_USER_RESPONSIBILITY

Description: Responsibility associated to user
Primary Key: BSC_USER_RESPONSIBILITY_PK
  1. RESPONSIBILITY_ID
  2. USER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_USER_RESPONSIBILITY.RESPONSIBILITY_ID BSC_RESPONSIBILITY
BSC_USER_RESPONSIBILITY.USER_ID BSC_USERS
Comments

BSC_USER_RESPONSIBILITY stores information about the relation between user and responsibility.

Indexes
Index Type Tablespace Column
BSC_USER_RESPONSIBILITY_U1 UNIQUE APPS_TS_TX_IDX USER_ID
RESPONSIBILITY_ID
Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y User identifier
RESPONSIBILITY_ID NUMBER (15) Y Responsibility identifier

[top of page]

BSC.BSC_USER_RESPONSIBILITY does not reference any database object

BSC.BSC_USER_RESPONSIBILITY is referenced by following:

APPS
SYNONYM - BSC_USER_RESPONSIBILITY

[top of page]

Table: BSC_USER_TAB_ACCESS

Description: Tab permissions
Primary Key: BSC_USER_TAB_ACCESS_PK
  1. RESPONSIBILITY_ID
  2. TAB_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
BSC_USER_TAB_ACCESS.RESPONSIBILITY_ID BSC_RESPONSIBILITY
BSC_USER_TAB_ACCESS.TAB_ID BSC_TABS_B
Comments

BSC_USER_TAB_ACCESS stores information about tab permissions by user.

Indexes
Index Type Tablespace Column
BSC_USER_TAB_ACCESS_U1 UNIQUE APPS_TS_TX_IDX RESPONSIBILITY_ID
TAB_ID
BSC_USER_TAB_ACCESS_N1 NONUNIQUE APPS_TS_TX_IDX TAB_ID
RESPONSIBILITY_ID
START_DATE
END_DATE
Columns
Name Datatype Length Mandatory Comments
RESPONSIBILITY_ID NUMBER (15) Y Responsibility identifier
TAB_ID NUMBER (5) Y Tab identifier
CREATION_DATE DATE
Y Standard Who column
CREATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_DATE DATE
Y Standard Who column
LAST_UPDATED_BY NUMBER (15) Y Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
START_DATE DATE
Y Start date
END_DATE DATE

End date

[top of page]

BSC.BSC_USER_TAB_ACCESS does not reference any database object

BSC.BSC_USER_TAB_ACCESS is referenced by following:

APPS
SYNONYM - BSC_USER_TAB_ACCESS

[top of page]

View: BSC_APPS_USERS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y
USER_NAME VARCHAR2 (100) Y
FULL_NAME VARCHAR2 (4000)
ENCRYPTED_USER_PASSWORD VARCHAR2 (100) Y
EMAIL_ADDRESS VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
BSC_VALID_FLAG NUMBER

[top of page]

APPS.BSC_APPS_USERS_V references the following:

APPS
PACKAGE - BSC_APPS
SYNONYM - FND_USER
APPS.BSC_APPS_USERS_V is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_LOCKS_PUB
PACKAGE BODY - BSC_LOCKS_PUB
PACKAGE BODY - BSC_LOCKS_PVT

[top of page]

View: BSC_BIS_DIM_LEVELS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DIM_LEVEL_ID NUMBER (5) Y
NAME VARCHAR2 (255) Y
SHORT_NAME VARCHAR2 (30) Y
DIMENSION_ID NUMBER
Y
LEVEL_VIEW_NAME VARCHAR2 (34)
BSC_LEVEL_VIEW_NAME VARCHAR2 (30)
BSC_SOURCE VARCHAR2 (10)
SOURCE VARCHAR2 (30) Y
IMPORTED_FLAG NUMBER

[top of page]

APPS.BSC_BIS_DIM_LEVELS_V references the following:

APPS
VIEW - BIS_LEVELS_VL
SYNONYM - BSC_SYS_DIM_LEVELS_B
APPS.BSC_BIS_DIM_LEVELS_V is referenced by following:

APPS
VIEW - BSC_OAF_DIM_LEVELS_V

[top of page]

View: BSC_DB_BASIC_DIM_SETS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
A0 NUMBER (3) Y
A1 NUMBER (3) Y
A2 NUMBER (3) Y
SERIES_ID NUMBER (3) Y
DIM_SET_ID NUMBER (3)
DATASET_ID NUMBER (5) Y

[top of page]

APPS.BSC_DB_BASIC_DIM_SETS_V references the following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_GROUPS
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_B
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_B
APPS.BSC_DB_BASIC_DIM_SETS_V is referenced by following:

APPS
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
VIEW - BSC_DB_DATASET_DIM_SETS_V

[top of page]

View: BSC_DB_COLOR_AO_DEFAULTS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
A0_DEFAULT NUMBER (3) Y
A1_DEFAULT NUMBER

A2_DEFAULT NUMBER

[top of page]

APPS.BSC_DB_COLOR_AO_DEFAULTS_V references the following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_GROUPS
APPS.BSC_DB_COLOR_AO_DEFAULTS_V is referenced by following:

APPS
PACKAGE BODY - BSC_ANALYSIS_OPTION_PVT
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_WRAPPER_PVT
PACKAGE BODY - BSC_COLOR_CALC_UTIL
VIEW - BSC_DB_COLOR_KPI_DEFAULTS_V
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_KPI_COLOR_PROPERTIES_PUB
PACKAGE BODY - BSC_KPI_PUB
PACKAGE BODY - BSC_KPI_SERIES_PUB
PACKAGE BODY - BSC_OAF_VIEWS_PVT
PACKAGE BODY - BSC_OBJ_ANALYSIS_OPTIONS_PUB

[top of page]

View: BSC_DB_COLOR_KPI_DEFAULTS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5)
SERIES_ID NUMBER (3)
DIM_SET_ID NUMBER

DATASET_ID NUMBER (5)

[top of page]

APPS.BSC_DB_COLOR_KPI_DEFAULTS_V references the following:

APPS
VIEW - BSC_DB_COLOR_AO_DEFAULTS_V
VIEW - BSC_DB_DATASET_DIM_SETS_V
APPS.BSC_DB_COLOR_KPI_DEFAULTS_V is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_MEASURE_PUB
VIEW - BSC_DB_COLOR_KPI_V
VIEW - BSC_DB_COLOR_MEASURES_V

[top of page]

View: BSC_DB_COLOR_KPI_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y
INDICATOR NUMBER (5) Y
PERIODICITY_ID NUMBER (5) Y
COMP_LEVEL_NAME VARCHAR2 (255)
COMP_LEVEL_PK_COL VARCHAR2 (30)
DIM_SET_ID NUMBER

YTD_FLAG NUMBER

[top of page]

APPS.BSC_DB_COLOR_KPI_V references the following:

APPS
VIEW - BSC_DB_COLOR_KPI_DEFAULTS_V
SYNONYM - BSC_KPIS_B
SYNONYM - BSC_KPI_CALCULATIONS
VIEW - BSC_KPI_DIM_LEVELS_VL
SYNONYM - BSC_TAB_INDICATORS
APPS.BSC_DB_COLOR_KPI_V is referenced by following:

APPS
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_MO_HELPER_PKG

[top of page]

View: BSC_DB_COLOR_MEASURES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5)
INDICATOR NUMBER (5)
MEASURE_FORMULA VARCHAR2 (4000)
COLOR_METHOD NUMBER (3)
FORMAT_ID NUMBER (3)

[top of page]

APPS.BSC_DB_COLOR_MEASURES_V references the following:

APPS
PACKAGE - BSC_APPS
VIEW - BSC_DB_COLOR_KPI_DEFAULTS_V
SYNONYM - BSC_KPIS_B
SYNONYM - BSC_KPI_PROPERTIES
SYNONYM - BSC_KPI_TREE_NODES_B
SYNONYM - BSC_SYS_DATASETS_B
SYNONYM - BSC_SYS_MEASURES
SYNONYM - BSC_TAB_INDICATORS
APPS.BSC_DB_COLOR_MEASURES_V is referenced by following:

APPS
PACKAGE BODY - BSC_UPDATE_COLOR

[top of page]

View: BSC_DB_DATASET_DIM_SETS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
A0 NUMBER (3) Y
A1 NUMBER (3) Y
A2 NUMBER (3) Y
SERIES_ID NUMBER (3) Y
DIM_SET_ID NUMBER

DATASET_ID NUMBER (5) Y
DEFAULT_VALUE NUMBER (3) Y
KPI_MEASURE_ID NUMBER

Unique key for the KPI Measure. Stands for the combination of AO1, AO2, AO3 and Data Series

[top of page]

APPS.BSC_DB_DATASET_DIM_SETS_V references the following:

APPS
VIEW - BSC_DB_BASIC_DIM_SETS_V
VIEW - BSC_KPI_ANALYSIS_MEASURES_VL
APPS.BSC_DB_DATASET_DIM_SETS_V is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_DIMENSION_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_WRAPPER_PVT
PACKAGE BODY - BSC_COLOR_CALC_UTIL
PACKAGE BODY - BSC_DBGEN_BSC_READER
VIEW - BSC_DB_COLOR_KPI_DEFAULTS_V
VIEW - BSC_DB_MEASURE_BY_DIM_SET_V
PACKAGE BODY - BSC_KPI_SERIES_PUB
PACKAGE BODY - BSC_LOCKS_PVT
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MO_INDICATOR_PKG
PACKAGE BODY - BSC_OBJ_ANALYSIS_OPTIONS_PUB
PACKAGE BODY - BSC_UPDATE_UTIL

[top of page]

View: BSC_DB_MEASURE_BY_DIM_SET_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5)
DIM_SET_ID NUMBER

MEASURE_ID NUMBER (5)

[top of page]

APPS.BSC_DB_MEASURE_BY_DIM_SET_V references the following:

APPS
VIEW - BSC_DB_DATASET_DIM_SETS_V
VIEW - BSC_SYS_DATASETS_VL
APPS.BSC_DB_MEASURE_BY_DIM_SET_V is referenced by following:

APPS
PACKAGE BODY - BSC_DBGEN_BSC_READER
PACKAGE BODY - BSC_MO_INDICATOR_PKG

[top of page]

View: BSC_DB_MEASURE_COLS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_DB_MEASURE_COLS_VL is a view of the translated, language specific values from BSC_DB_MEASURE_COLS_TL. BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
MEASURE_COL VARCHAR2 (30) Y
HELP VARCHAR2 (150) Y
MEASURE_GROUP_ID NUMBER (5) Y
PROJECTION_ID NUMBER (3) Y
MEASURE_TYPE NUMBER (3)

[top of page]

APPS.BSC_DB_MEASURE_COLS_VL references the following:

APPS
SYNONYM - BSC_DB_MEASURE_COLS_TL
APPS.BSC_DB_MEASURE_COLS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIA_WRAPPER
PACKAGE BODY - BSC_BIS_CUSTOM_KPI_UTIL_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_CALCULATIONS_PUB
PACKAGE BODY - BSC_DATASETS_PVT
PACKAGE BODY - BSC_DBGEN_BSC_READER
PACKAGE BODY - BSC_MO_HELPER_PKG
PACKAGE BODY - BSC_MO_INPUT_TABLE_PKG
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_UPDATE_CALC
PACKAGE BODY - BSC_UPDATE_UTIL
PACKAGE BODY - BSC_UPGRADES

[top of page]

View: BSC_DB_MEASURE_GROUPS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_DB_MEASURE_GROUPS_VL is a view of the translated, language specific values from BSC_DB_MEASURE_GROUPS_TL. BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
MEASURE_GROUP_ID NUMBER (5) Y
HELP VARCHAR2 (150) Y
SHORT_NAME VARCHAR2 (30)
Short name

[top of page]

APPS.BSC_DB_MEASURE_GROUPS_VL references the following:

APPS
SYNONYM - BSC_DB_MEASURE_GROUPS_TL
APPS.BSC_DB_MEASURE_GROUPS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB

[top of page]

View: BSC_EDW_CALENDAR_TYPE_VL

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

MultiLingual view (a language resolved view of the data.)

BSC_EDW_CALENDAR_TYPE_VL is a view that joins the translated, language specific values from BSC_EWD_CALENDAR_TYPE_TL with the non-displayed data from BSC_EDW_CALENDAR(EDW_CALENDAR_TYPE_ID) . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
EDW_CALENDAR_TYPE_ID NUMBER
Y
NAME VARCHAR2 (150)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.BSC_EDW_CALENDAR_TYPE_VL references the following:

APPS
SYNONYM - BSC_EDW_CALENDAR_TYPE_TL
APPS.BSC_EDW_CALENDAR_TYPE_VL is referenced by following:

APPS
PACKAGE BODY - BSC_UPDATE_UTIL

[top of page]

View: BSC_KPIS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_KPIS_VL is a view that joins the translated, language specific values from BSC_KPIS_TL with the non-displayed data from BSC_KPIS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
NAME VARCHAR2 (150) Y
HELP VARCHAR2 (150) Y
CSF_ID NUMBER (3) Y
IND_GROUP_ID NUMBER (5) Y
DISP_ORDER NUMBER (3) Y
PROTOTYPE_FLAG NUMBER (3) Y
INDICATOR_TYPE NUMBER (3) Y
CONFIG_TYPE NUMBER (3) Y
PERIODICITY_ID NUMBER (5) Y
BM_GROUP_ID NUMBER (3) Y
APPLY_COLOR_FLAG NUMBER (3) Y
PROTOTYPE_COLOR VARCHAR2 (1)
SHARE_FLAG NUMBER (3) Y
SOURCE_INDICATOR NUMBER (5)
PUBLISH_FLAG NUMBER

EDW_FLAG NUMBER (1)
CALENDAR_ID NUMBER

FISCAL_YEAR NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
SHORT_NAME VARCHAR2 (30)
Short name
PROTOTYPE_COLOR_ID NUMBER (8)
Prototype Color for the Objective
COLOR_ROLLUP_TYPE VARCHAR2 (30)
Defines the rollup type for the Objective from the underlying KPI Measures. Valid values are: WORST, BEST, MOST_FREQUENT, WEIGHTED_AVERAGE, DEFAULT_KPI
WEIGHTED_COLOR_METHOD NUMBER

Color Method for Weighted Average calculations for the Objective. Can be either: 1- INCREASING_GOOD 2- DECREASING_GOOD 3- WITHIN_RANGE 4 - FLEXIBLE
PROTOTYPE_TREND_ID NUMBER

[top of page]

APPS.BSC_KPIS_VL references the following:

APPS
SYNONYM - BSC_KPIS_B
SYNONYM - BSC_KPIS_TL
SYNONYM - BSC_SYS_CALENDARS_B
APPS.BSC_KPIS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_ANALYSIS_OPTION_PUB
PACKAGE BODY - BSC_ANALYSIS_OPTION_PVT
PACKAGE BODY - BSC_BIS_DIMENSION_PUB
PACKAGE BODY - BSC_BIS_DIM_OBJ_PUB
PACKAGE BODY - BSC_BIS_DIM_REL_PUB
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_BSC_ADAPTER
PACKAGE BODY - BSC_CALENDAR_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_DATASETS_PVT
PACKAGE BODY - BSC_DBGEN_BSC_READER
PACKAGE BODY - BSC_DBGEN_METADATA_READER
PACKAGE BODY - BSC_DBGEN_UTILS
PACKAGE BODY - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_KPI_PVT
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_METADATA_OPTIMIZER_PKG
PACKAGE - BSC_METADATA_OPTIMIZER_PKG
PACKAGE - BSC_MIGREATION_UI
PACKAGE BODY - BSC_MO_DOC_PKG
PACKAGE BODY - BSC_MO_HELPER_PKG
PACKAGE BODY - BSC_MO_INDICATOR_PKG
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_OBJECTIVE_METADATA_SETUP
PACKAGE BODY - BSC_PERIODICITIES_PUB
PACKAGE BODY - BSC_PMF_UI_WRAPPER
PACKAGE BODY - BSC_SIMULATION_VIEW_PUB
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT
VIEW - BSC_TAB_IND_V
PACKAGE BODY - BSC_UPDATE
PACKAGE BODY - BSC_UPDATE_INC
PACKAGE BODY - BSC_UPDATE_LOCK
PACKAGE BODY - BSC_UPDATE_UTIL
PACKAGE BODY - BSC_UTILITY

[top of page]

View: BSC_KPI_ANALYSIS_MEASURES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_KPI_ANALYSIS_MEASURES_VL is a view that joins the translated, language specific values from BSC_KPI_ANALYSIS_MEASURES_TL with the non-displayed data from BSC_KPI_ANALYSIS_MEASURES_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
ANALYSIS_OPTION0 NUMBER (3) Y
ANALYSIS_OPTION1 NUMBER (3) Y
ANALYSIS_OPTION2 NUMBER (3) Y
SERIES_ID NUMBER (3) Y
NAME VARCHAR2 (255) Y
HELP VARCHAR2 (1024) Y
DATASET_ID NUMBER (5) Y
AXIS NUMBER (3) Y
SERIES_TYPE NUMBER (3) Y
STACK_SERIES_ID NUMBER (3)
BM_FLAG NUMBER (3) Y
BUDGET_FLAG NUMBER (3) Y
DEFAULT_VALUE NUMBER (3) Y
SERIES_COLOR NUMBER (11) Y
BM_COLOR NUMBER (11) Y
PROTOTYPE_FLAG NUMBER (3)
Base series identifier to stack
KPI_MEASURE_ID NUMBER

Unique key for the KPI Measure. Stands for the combination of AO1, AO2, AO3 and Data Series

[top of page]

APPS.BSC_KPI_ANALYSIS_MEASURES_VL references the following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_B
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_TL
APPS.BSC_KPI_ANALYSIS_MEASURES_VL is referenced by following:

APPS
PACKAGE BODY - BSC_ANALYSIS_OPTION_PUB
PACKAGE BODY - BSC_ANALYSIS_OPTION_PVT
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_DATASETS_PVT
VIEW - BSC_DB_DATASET_DIM_SETS_V
PACKAGE BODY - BSC_KPI_COLOR_PROPERTIES_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_OAF_VIEWS_PVT

[top of page]

View: BSC_KPI_ANALYSIS_OPTIONS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_KPI_ANALYSIS_OPTIONS_VL is a view that joins the translated, language specific values from BSC_KPI_ANALYSIS_OPTIONS_TL with the non-displayed data from BSC_KPI_ANALYSIS_OPTIONS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
ANALYSIS_GROUP_ID NUMBER (3) Y
OPTION_ID NUMBER (3) Y
PARENT_OPTION_ID NUMBER (3) Y
GRANDPARENT_OPTION_ID NUMBER (3) Y
NAME VARCHAR2 (255) Y
HELP VARCHAR2 (1024) Y
DIM_SET_ID NUMBER (3) Y
USER_LEVEL0 NUMBER (3)
USER_LEVEL1 NUMBER (3)
USER_LEVEL1_DEFAULT NUMBER (3)
USER_LEVEL2 NUMBER (3)
USER_LEVEL2_DEFAULT NUMBER (3)
SHORT_NAME VARCHAR2 (30)
Short name

[top of page]

APPS.BSC_KPI_ANALYSIS_OPTIONS_VL references the following:

APPS
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_B
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_TL
APPS.BSC_KPI_ANALYSIS_OPTIONS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_ANALYSIS_OPTION_PVT
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_KPI_SERIES_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_OAF_VIEWS_PVT
PACKAGE BODY - BSC_OBJ_ANALYSIS_OPTIONS_PUB
VIEW - BSC_PMF_MEAS_V
PACKAGE BODY - BSC_PMF_UI_API_PUB

[top of page]

View: BSC_KPI_DATA_TABLES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
PERIODICITY_ID NUMBER (5) Y
DIM_SET_ID NUMBER (3) Y
LEVEL_COMB VARCHAR2 (30) Y
TABLE_NAME VARCHAR2 (30)
FILTER_CONDITION VARCHAR2 (240)

[top of page]

APPS.BSC_KPI_DATA_TABLES_V references the following:

APPS
SYNONYM - BSC_KPIS_B
SYNONYM - BSC_KPI_DATA_TABLES
APPS.BSC_KPI_DATA_TABLES_V is referenced by following:

APPS
PACKAGE BODY - BSC_BSC_ADAPTER
PACKAGE BODY - BSC_MO_LOADER_CONFIG_PKG

[top of page]

View: BSC_KPI_DEFAULTS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_KPI_DEFAULTS_VL is a view that joins the translated, language specific values from BSC_KPI_DEFAULTS_TL with the non-displayed data from BSC_KPI_DEFAULTS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y
INDICATOR NUMBER (5) Y
ANALYSIS_OPTION0_NAME VARCHAR2 (255)
ANALYSIS_OPTION1_NAME VARCHAR2 (255)
ANALYSIS_OPTION2_NAME VARCHAR2 (255)
PERIOD_NAME VARCHAR2 (100)
SERIES_NAME VARCHAR2 (255)
FORMAT_MASK VARCHAR2 (20)
COLOR_METHOD NUMBER (3)
DIM_SET_ID NUMBER (5)
DIM_LEVEL1_NAME VARCHAR2 (255)
DIM_LEVEL2_NAME VARCHAR2 (255)
DIM_LEVEL3_NAME VARCHAR2 (255)
DIM_LEVEL4_NAME VARCHAR2 (255)
DIM_LEVEL5_NAME VARCHAR2 (255)
DIM_LEVEL6_NAME VARCHAR2 (255)
DIM_LEVEL7_NAME VARCHAR2 (255)
DIM_LEVEL8_NAME VARCHAR2 (255)
DIM_LEVEL1_VALUE VARCHAR2 (400)
DIM_LEVEL2_VALUE VARCHAR2 (400)
DIM_LEVEL3_VALUE VARCHAR2 (400)
DIM_LEVEL4_VALUE VARCHAR2 (400)
DIM_LEVEL5_VALUE VARCHAR2 (400)
DIM_LEVEL6_VALUE VARCHAR2 (400)
DIM_LEVEL7_VALUE VARCHAR2 (400)
DIM_LEVEL8_VALUE VARCHAR2 (400)
DIM_LEVEL1_TEXT VARCHAR2 (240)
DIM_LEVEL2_TEXT VARCHAR2 (240)
DIM_LEVEL3_TEXT VARCHAR2 (240)
DIM_LEVEL4_TEXT VARCHAR2 (240)
DIM_LEVEL5_TEXT VARCHAR2 (240)
DIM_LEVEL6_TEXT VARCHAR2 (240)
DIM_LEVEL7_TEXT VARCHAR2 (240)
DIM_LEVEL8_TEXT VARCHAR2 (240)
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
MEASURE_SOURCE VARCHAR2 (10)
Measure Source

[top of page]

APPS.BSC_KPI_DEFAULTS_VL references the following:

APPS
SYNONYM - BSC_KPI_DEFAULTS_B
SYNONYM - BSC_KPI_DEFAULTS_TL
SYNONYM - BSC_SYS_CALENDARS_B
SYNONYM - BSC_SYS_PERIODICITIES
APPS.BSC_KPI_DEFAULTS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_DESIGNER_PVT

[top of page]

View: BSC_KPI_DIM_LEVELS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_KPI_DIM_LEVELS_VL is a view that joins the translated, language specific values from BSC_KPI_DIM_LEVELS_TL with the non-displayed data from BSC_KPI_DIM_LEVELS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
DIM_SET_ID NUMBER (3) Y
DIM_LEVEL_INDEX NUMBER (3) Y
NAME VARCHAR2 (255) Y
HELP VARCHAR2 (1024) Y
TOTAL_DISP_NAME VARCHAR2 (45)
COMP_DISP_NAME VARCHAR2 (45)
LEVEL_TABLE_NAME VARCHAR2 (30) Y
LEVEL_VIEW_NAME VARCHAR2 (30)
FILTER_COLUMN VARCHAR2 (30)
FILTER_VALUE NUMBER (5)
DEFAULT_VALUE VARCHAR2 (2)
DEFAULT_TYPE NUMBER (5)
VALUE_ORDER_BY NUMBER (5) Y
COMP_ORDER_BY NUMBER (5) Y
LEVEL_PK_COL VARCHAR2 (30) Y
PARENT_LEVEL_INDEX NUMBER (3)
PARENT_LEVEL_REL VARCHAR2 (30)
TABLE_RELATION VARCHAR2 (30)
PARENT_LEVEL_INDEX2 NUMBER (3)
PARENT_LEVEL_REL2 VARCHAR2 (30)
STATUS NUMBER (3) Y
PARENT_IN_TOTAL NUMBER (3)
POSITION NUMBER (3) Y
TOTAL0 NUMBER (3)
LEVEL_DISPLAY NUMBER (3)
NO_ITEMS NUMBER (1)
DEFAULT_KEY_VALUE VARCHAR2 (400)
USER_LEVEL0 NUMBER (3)
USER_LEVEL1 NUMBER (3)
USER_LEVEL1_DEFAULT NUMBER (3)
USER_LEVEL2 NUMBER (3)
USER_LEVEL2_DEFAULT NUMBER (3)
DISP_KEY_SIZE NUMBER (5)
TARGET_LEVEL NUMBER (1)
Target Level
LEVEL_SHORTNAME VARCHAR2 (30)
Short name
LEVEL_SOURCE VARCHAR2 (10)
Source

[top of page]

APPS.BSC_KPI_DIM_LEVELS_VL references the following:

APPS
SYNONYM - BSC_KPI_DIM_LEVELS_B
SYNONYM - BSC_KPI_DIM_LEVELS_TL
SYNONYM - BSC_SYS_DIM_LEVELS_B
APPS.BSC_KPI_DIM_LEVELS_VL is referenced by following:

APPS
PACKAGE BODY - BIS_PMF_GET_DIMLEVELS_PVT
PACKAGE BODY - BSC_BIS_DIMENSION_PUB
PACKAGE BODY - BSC_BIS_DIM_OBJ_PUB
PACKAGE BODY - BSC_BIS_DIM_REL_PUB
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_COMMON_DIM_LEVELS_PUB
VIEW - BSC_DB_COLOR_KPI_V
PACKAGE BODY - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_DIMENSION_SETS_PUB
PACKAGE BODY - BSC_DIM_LEVEL_FILTERS_PUB
PACKAGE BODY - BSC_KPI_DIM_SETS_PKG
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_UPDATE_UTIL
PACKAGE BODY - BSC_UTILITY

[top of page]

View: BSC_KPI_DIM_SETS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_KPI_DIM_SETS_VL is a view of the translated, language specific values from BSC_KPI_DIM_SETS_TL . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
DIM_SET_ID NUMBER (3) Y
NAME VARCHAR2 (60) Y
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
SHORT_NAME VARCHAR2 (30)
Short name

[top of page]

APPS.BSC_KPI_DIM_SETS_VL references the following:

APPS
SYNONYM - BSC_KPI_DIM_SETS_TL
APPS.BSC_KPI_DIM_SETS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_COMMON_DIM_LEVELS_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_KPI_DIM_SETS_PKG
PACKAGE BODY - BSC_METADATA_DESC

[top of page]

View: BSC_KPI_SHELL_CMDS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_KPI_SHELL_CMDS_VL is a view of the translated, language specific values from BSC_KPI_SHELL_CMDS_TL . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
SHELL_CMD_ID NUMBER (3) Y
NAME VARCHAR2 (150) Y
COMMAND VARCHAR2 (320)

[top of page]

APPS.BSC_KPI_SHELL_CMDS_VL references the following:

APPS
SYNONYM - BSC_KPI_SHELL_CMDS_TL

APPS.BSC_KPI_SHELL_CMDS_VL is not referenced by any database object

[top of page]

View: BSC_KPI_SUBTITLES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_KPI_SUBTITLES_VL is a view of the translated, language specific values from BSC_KPI_SUBTITLES_TL . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
CALC_COMB NUMBER (3) Y
ANALYSIS_OPTION0 NUMBER (3) Y
ANALYSIS_OPTION1 NUMBER (3) Y
ANALYSIS_OPTION2 NUMBER (3) Y
SUBTITLE VARCHAR2 (240) Y

[top of page]

APPS.BSC_KPI_SUBTITLES_VL references the following:

APPS
SYNONYM - BSC_KPI_SUBTITLES_TL

APPS.BSC_KPI_SUBTITLES_VL is not referenced by any database object

[top of page]

View: BSC_KPI_TREE_NODES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_KPI_TREE_NODES_VL is a view that joins the translated, language specific values from BSC_KPI_TREE_NODES_TL with the non-displayed data from BSC_KPI_TREE_NODES_B. BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
NODE_ID NUMBER (5) Y
NAME VARCHAR2 (75) Y
HELP VARCHAR2 (240) Y
SIMULATE_FLAG NUMBER (3) Y
FORMAT_ID NUMBER (3) Y
COLOR_FLAG NUMBER (3) Y
COLOR_METHOD NUMBER (3) Y
NAVIGATES_TO_TREND NUMBER (3) Y
TOP_POSITION NUMBER (5) Y
LEFT_POSITION NUMBER (5) Y
WIDTH NUMBER (5) Y
HEIGHT NUMBER (5) Y
AUTOSCALE_FLAG NUMBER

Y_AXIS_TITLE VARCHAR2 (90)
Y axis title (max 30 chars)

[top of page]

APPS.BSC_KPI_TREE_NODES_VL references the following:

APPS
SYNONYM - BSC_KPI_TREE_NODES_B
SYNONYM - BSC_KPI_TREE_NODES_TL
APPS.BSC_KPI_TREE_NODES_VL is referenced by following:

APPS
PACKAGE BODY - BSC_SIMULATION_VIEW_PUB
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT
PACKAGE - BSC_SIMULATION_VIEW_PVT

[top of page]

View: BSC_LOOKUPS

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Y
LOOKUP_TYPE VARCHAR2 (30) Y
LOOKUP_CODE VARCHAR2 (30) Y
MEANING VARCHAR2 (80) Y
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

[top of page]

APPS.BSC_LOOKUPS references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
APPS.BSC_LOOKUPS is referenced by following:

APPS
PACKAGE BODY - BSC_APPS
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_LOCKS_PVT
PACKAGE - BSC_LOCKS_PVT
PACKAGE BODY - BSC_LOCKS_PVT
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_PERIODICITIES_PUB
PACKAGE BODY - BSC_PMA_DIAG_TEST
VIEW - BSC_SYS_PERIODICITIES_VL
VIEW - BSC_TAB_VIEWS_VL
PACKAGE BODY - BSC_TIME_DIM_TEST
PACKAGE BODY - BSC_UPDATE_UTIL
PACKAGE BODY - BSC_WEB_ADI_LOADER_PKG

[top of page]

View: BSC_MESSAGES

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER
Y
LANGUAGE_CODE VARCHAR2 (4) Y
MESSAGE_NUMBER NUMBER (9)
MESSAGE_NAME VARCHAR2 (30) Y
MESSAGE_TEXT VARCHAR2 (2000) Y
CREATION_DATE DATE
Y
CREATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_LOGIN NUMBER (15)
DESCRIPTION VARCHAR2 (240)
TYPE VARCHAR2 (30)
MAX_LENGTH NUMBER

[top of page]

APPS.BSC_MESSAGES references the following:

APPS
SYNONYM - FND_NEW_MESSAGES
APPS.BSC_MESSAGES is referenced by following:

APPS
PACKAGE BODY - BSC_APPS
PACKAGE BODY - BSC_PERIODICITIES_PUB
PACKAGE BODY - BSC_UPDATE_UTIL

[top of page]

View: BSC_OAF_ANALYSYS_OPT_COMB_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
ANALYSIS_OPTION0 NUMBER (3) Y
ANALYSIS_OPTION1 NUMBER (3) Y
ANALYSIS_OPTION2 NUMBER (3) Y
SERIES_ID NUMBER (3) Y
KPI_MEASURE_ID NUMBER

PROTOTYPE_FLAG NUMBER (3)
FULL_NAME VARCHAR2 (4000)
SOURCE VARCHAR2 (4000)
DISPLAY_FLAG NUMBER

MASTER_FLAG NUMBER (3) Y
DATASET_ID NUMBER (5) Y
DEFAULT_FLAG NUMBER

[top of page]

APPS.BSC_OAF_ANALYSYS_OPT_COMB_V references the following:

APPS
SYNONYM - BSC_KPIS_B
SYNONYM - BSC_KPI_ANALYSIS_MEASURES_B
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_B
PACKAGE - BSC_OAF_VIEWS_PVT
APPS.BSC_OAF_ANALYSYS_OPT_COMB_V is referenced by following:

APPS
PACKAGE - BSC_ANALYSIS_OPTION_PUB
PACKAGE BODY - BSC_ANALYSIS_OPTION_PUB
PACKAGE BODY - BSC_ANALYSIS_OPTION_PVT
PACKAGE - BSC_ANALYSIS_OPTION_PVT
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_PMF_UI_WRAPPER

[top of page]

View: BSC_OAF_DIM_LEVELS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DIM_LEVEL_ID NUMBER (5) Y
SHORT_NAME VARCHAR2 (30) Y
NAME VARCHAR2 (255) Y
LEVEL_VIEW_NAME VARCHAR2 (34)
PARENTS VARCHAR2 (4000)
SOURCE VARCHAR2 (10)
IMPORTED_FLAG NUMBER

[top of page]

APPS.BSC_OAF_DIM_LEVELS_V references the following:

APPS
VIEW - BSC_BIS_DIM_LEVELS_V
PACKAGE - BSC_OAF_VIEWS_PVT

APPS.BSC_OAF_DIM_LEVELS_V is not referenced by any database object

[top of page]

View: BSC_OPTS_PMF_MEAS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Y
OPTION_GROUP_ID NUMBER (3) Y
OPTION_ID NUMBER (3) Y
OPTION_NAME VARCHAR2 (255) Y
DESCRIPTION VARCHAR2 (1024) Y
DATASET_ID NUMBER

MEASURE_ID NUMBER (5) Y
MEAS_SHORT_NAME VARCHAR2 (30)
MEAS_SOURCE VARCHAR2 (10)
PMF_INDICATOR_ID NUMBER

PMF_MEAS_NAME VARCHAR2 (255)
DIM_SET_ID NUMBER (3) Y
DIM_LEVELS VARCHAR2 (4000)

[top of page]

APPS.BSC_OPTS_PMF_MEAS_V references the following:

APPS
SYNONYM - BIS_INDICATORS
SYNONYM - BIS_INDICATORS_TL
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_B
SYNONYM - BSC_KPI_ANALYSIS_OPTIONS_TL
SYNONYM - BSC_SYS_DATASETS_B
SYNONYM - BSC_SYS_MEASURES
PACKAGE - BSC_UTILITY

APPS.BSC_OPTS_PMF_MEAS_V is not referenced by any database object

[top of page]

View: BSC_PMF_MEAS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (255) Y
DESCRIPTION VARCHAR2 (1024) Y
SHORT_NAME VARCHAR2 (30)
SOURCE_NAME VARCHAR2 (255) Y
DIM_LEVELS VARCHAR2 (4000)
DIM_LEVEL_SHORT_NAMES VARCHAR2 (4000)

[top of page]

APPS.BSC_PMF_MEAS_V references the following:

APPS
VIEW - BIS_INDICATORS_VL
VIEW - BSC_KPI_ANALYSIS_OPTIONS_VL
SYNONYM - BSC_SYS_DATASETS_B
SYNONYM - BSC_SYS_MEASURES
PACKAGE - BSC_UTILITY

APPS.BSC_PMF_MEAS_V is not referenced by any database object

[top of page]

View: BSC_RESPONSIBILITY_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_RESPONSIBILITY_VL is a view of FND_RESPONSIBILITY_VL that filters BSC Responsibility.

Columns
Name Datatype Length Mandatory Comments
RESPONSIBILITY_ID NUMBER (15) Y
RESPONSIBILITY_NAME VARCHAR2 (100) Y

[top of page]

APPS.BSC_RESPONSIBILITY_VL references the following:

APPS
VIEW - FND_RESPONSIBILITY_VL
APPS.BSC_RESPONSIBILITY_VL is referenced by following:

APPS
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MIGREATION_UI
PACKAGE - BSC_MIGREATION_UI

[top of page]

View: BSC_SYS_BENCHMARKS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_SYS_BENCHMARKS_VL is a view that joins the translated, language specific values from BSC_SYS_BENCHMARKS_TL with the non-displayed data from BSC_SYS_BENCHMARKS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
BM_ID NUMBER (3) Y
NAME VARCHAR2 (60) Y
COLOR NUMBER (11) Y
DATA_TYPE NUMBER (3) Y
SOURCE_TYPE NUMBER (3) Y
PERIODICITY_ID NUMBER (5)
NO_DISPLAY_FLAG NUMBER (3)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.BSC_SYS_BENCHMARKS_VL references the following:

APPS
SYNONYM - BSC_SYS_BENCHMARKS_B
SYNONYM - BSC_SYS_BENCHMARKS_TL

APPS.BSC_SYS_BENCHMARKS_VL is not referenced by any database object

[top of page]

View: BSC_SYS_CALENDARS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_SYS_CALENDARS_VL is a view that joins the translated, language specific values from BSC_SYS_CALENDARS_TL with the non-displayed data from BSC_SYS_CALENDARS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
CALENDAR_ID NUMBER
Y
EDW_FLAG NUMBER (1) Y
EDW_CALENDAR_ID NUMBER

EDW_CALENDAR_TYPE_ID NUMBER

FISCAL_YEAR NUMBER (4) Y
FISCAL_CHANGE NUMBER (1) Y
RANGE_YR_MOD NUMBER (1) Y
CURRENT_YEAR NUMBER (4)
START_MONTH NUMBER (2)
START_DAY NUMBER (3)
NAME VARCHAR2 (150)
HELP VARCHAR2 (240)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
SHORT_NAME VARCHAR2 (30)

[top of page]

APPS.BSC_SYS_CALENDARS_VL references the following:

APPS
SYNONYM - BSC_SYS_CALENDARS_B
SYNONYM - BSC_SYS_CALENDARS_TL
APPS.BSC_SYS_CALENDARS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_LOCKS_PVT
PACKAGE BODY - BSC_CALENDAR_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MO_DOC_PKG
PACKAGE BODY - BSC_MO_HELPER_PKG
PACKAGE BODY - BSC_PERIODICITIES_PUB
PACKAGE BODY - BSC_PERIODS_UTILITY_PKG
PACKAGE BODY - BSC_UPDATE_UTIL

[top of page]

View: BSC_SYS_COLORS_VL

Comments
View to store all colors and related properties, mainly used for the Performance Bands.
Columns
Name Datatype Length Mandatory Comments
COLOR_ID NUMBER (8) Y Color Id
SHORT_NAME VARCHAR2 (30) Y Short Name
NAME VARCHAR2 (120)
System level color name
DESCRIPTION VARCHAR2 (240)
System level color description
PROTOTYPE_LABEL VARCHAR2 (120)
Label for the color in prototype mode
PERF_SEQUENCE NUMBER (2)
Denotes the significance of the color w.r.t. color calculations
COLOR NUMBER (10)
System level value
USER_COLOR NUMBER (10)
User customized value
FORECAST_COLOR NUMBER (10)
System level value for Forecast color
USER_FORECAST_COLOR NUMBER (10)
User customizedl value for Forecast color
NUMERIC_EQUIVALENT NUMBER (6)
Numeric equivalent to be used in Weighted Average calculations
USER_NUMERIC_EQUIVALENT NUMBER (6)
User customized value
USER_IMAGE_ID NUMBER (15)
Image icon for the color
CREATED_BY NUMBER (15) Y Created By
CREATION_DATE DATE
Y Creation Date
LAST_UPDATED_BY NUMBER (15) Y Last Updated By
LAST_UPDATE_DATE DATE
Y Last Update Date
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login

[top of page]

APPS.BSC_SYS_COLORS_VL references the following:

APPS
SYNONYM - BSC_SYS_COLORS_B
SYNONYM - BSC_SYS_COLORS_TL
APPS.BSC_SYS_COLORS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_COLOR_PVT

[top of page]

View: BSC_SYS_DATASETS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_SYS_DATASETS_VL is a view that joins the translated, language specific values from BSC_SYS_DATASETS_TL with the non-displayed data from BSC_SYS_DATASETS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
DATASET_ID NUMBER (5) Y
NAME VARCHAR2 (255) Y
HELP VARCHAR2 (1024) Y
MEASURE_ID1 NUMBER (5) Y
OPERATION VARCHAR2 (3)
MEASURE_ID2 NUMBER (5)
FORMAT_ID NUMBER (3) Y
COLOR_METHOD NUMBER (3) Y
PROJECTION_FLAG NUMBER (3)
EDW_FLAG NUMBER

AUTOSCALE_FLAG NUMBER

Y_AXIS_TITLE VARCHAR2 (90)
Y axis title (max 30 chars)
SOURCE VARCHAR2 (10)
Source
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

APPS.BSC_SYS_DATASETS_VL references the following:

APPS
SYNONYM - BSC_SYS_DATASETS_B
SYNONYM - BSC_SYS_DATASETS_TL
APPS.BSC_SYS_DATASETS_VL is referenced by following:

APPS
VIEW - BIS_APP_NAMES_RPTS_V
VIEW - BIS_DISPLAY_MEASURES_V
PACKAGE BODY - BSC_ANALYSIS_OPTION_PUB
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_BIS_MEASURE_PUB
PACKAGE BODY - BSC_COLOR_UPGRADE
PACKAGE BODY - BSC_DATASETS_PUB
PACKAGE BODY - BSC_DATASETS_PVT
VIEW - BSC_DB_MEASURE_BY_DIM_SET_V
PACKAGE BODY - BSC_KPI_SERIES_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_OBJ_ANALYSIS_OPTIONS_PUB
PACKAGE BODY - BSC_PMF_UI_WRAPPER
PACKAGE - BSC_SIMULATION_VIEW_PVT
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT
PACKAGE BODY - BSC_UPGRADES
PACKAGE - BSC_UTILITY
PACKAGE BODY - BSC_UTILITY

[top of page]

View: BSC_SYS_DIM_GROUPS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_SYS_DIM_GROUPS_VL is a view of the translated, language specific values from BSC_SYS_DIM_GROUPS_TL. BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
DIM_GROUP_ID NUMBER (5) Y
NAME VARCHAR2 (255) Y
SHORT_NAME VARCHAR2 (30)
Short name
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

APPS.BSC_SYS_DIM_GROUPS_VL references the following:

APPS
SYNONYM - BSC_SYS_DIM_GROUPS_TL
APPS.BSC_SYS_DIM_GROUPS_VL is referenced by following:

APPS
PACKAGE BODY - BIS_DIMENSION_PVT
PACKAGE BODY - BIS_REPORT_PUB
PACKAGE BODY - BIS_UTIL
PACKAGE BODY - BSC_BIS_DIMENSION_PUB
PACKAGE BODY - BSC_BIS_DIM_OBJ_PUB
VIEW - BSC_BIS_DIM_VL
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_DESIGNER_PVT
PACKAGE BODY - BSC_DIMENSION_GROUPS_PUB
PACKAGE BODY - BSC_DIMENSION_GROUPS_PVT
PACKAGE BODY - BSC_DIMENSION_LEVELS_PVT
PACKAGE BODY - BSC_DIMENSION_SETS_PUB
PACKAGE BODY - BSC_KPI_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MIGRATION
PACKAGE BODY - BSC_OBJ_ANALYSIS_OPTIONS_PUB
PACKAGE BODY - BSC_PMF_UI_API_PUB
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT
PACKAGE BODY - BSC_UPGRADES
PACKAGE BODY - BSC_UTILITY

[top of page]

View: BSC_SYS_DIM_LEVELS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_SYS_DIM_LEVELS_VL is a view that joins the translated, language specific values from BSC_SYS_DIM_LEVELS_TL with the non-displayed data from BSC_SYS_DIM_LEVELS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
DIM_LEVEL_ID NUMBER (5) Y
NAME VARCHAR2 (255) Y
HELP VARCHAR2 (1024) Y
TOTAL_DISP_NAME VARCHAR2 (45)
COMP_DISP_NAME VARCHAR2 (45)
LEVEL_TABLE_NAME VARCHAR2 (30) Y
TABLE_TYPE NUMBER (3) Y
LEVEL_PK_COL VARCHAR2 (30) Y
ABBREVIATION VARCHAR2 (24) Y
VALUE_ORDER_BY NUMBER (5) Y
COMP_ORDER_BY NUMBER (5) Y
CUSTOM_GROUP NUMBER (5) Y
USER_KEY_SIZE NUMBER (3) Y
DISP_KEY_SIZE NUMBER (5) Y
EDW_FLAG NUMBER

EDW_DIM_ID NUMBER

EDW_DIM_LEVEL_ID NUMBER

LEVEL_VIEW_NAME VARCHAR2 (30)
SHORT_NAME VARCHAR2 (30)
Short name
SOURCE VARCHAR2 (10)
Source
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column

[top of page]

APPS.BSC_SYS_DIM_LEVELS_VL references the following:

APPS
SYNONYM - BSC_SYS_DIM_LEVELS_B
SYNONYM - BSC_SYS_DIM_LEVELS_TL
APPS.BSC_SYS_DIM_LEVELS_VL is referenced by following:

APPS
PACKAGE BODY - BIS_DIMENSION_LEVEL_PUB
PACKAGE BODY - BIS_PMF_GET_DIMLEVELS_PVT
PACKAGE BODY - BIS_UTIL
PACKAGE BODY - BSC_BIS_DIMENSION_PUB
VIEW - BSC_BIS_DIM_OBJS_VL
VIEW - BSC_BIS_DIM_OBJ_BY_DIM_VL
PACKAGE BODY - BSC_BIS_DIM_OBJ_PUB
PACKAGE BODY - BSC_BIS_DIM_REL_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_CALENDAR_PVT
PACKAGE BODY - BSC_COMMON_DIM_LEVELS_PUB
PACKAGE BODY - BSC_DBGEN_BSC_READER
PACKAGE - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_DIMENSION_GROUPS_PUB
PACKAGE BODY - BSC_DIMENSION_LEVELS_PVT
PACKAGE BODY - BSC_DIMENSION_SETS_PUB
PACKAGE BODY - BSC_DIM_LEVEL_FILTERS_PUB
VIEW - BSC_DIM_OBJ_CHD_RELS_VL
VIEW - BSC_DIM_OBJ_PAR_RELS_VL
PACKAGE BODY - BSC_INVALID_DIM_LVLS_RPT
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MIGRATION
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_OAF_VIEWS_PVT
PACKAGE BODY - BSC_PMF_UI_API_PUB
PACKAGE BODY - BSC_SEC_UTILITY
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT
VIEW - BSC_SYS_DIM_LEVEL_RELS_V
PACKAGE BODY - BSC_UPGRADES
PACKAGE BODY - BSC_UTILITY

[top of page]

View: BSC_SYS_DIM_LEVEL_RELS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DIM_LEVEL_ID NUMBER (5) Y
SHORT_NAME VARCHAR2 (30)
Short name
SOURCE VARCHAR2 (10)
Source
PARENT_DIM_LEVEL_ID NUMBER (5) Y Parent dimension level identifier
PARENT_SHORT_NAME VARCHAR2 (30)
Short name
PARENT_NAME VARCHAR2 (255) Y
PARENT_SOURCE VARCHAR2 (10)
Parent source
RELATION_COL VARCHAR2 (50)
Relation field
DATA_SOURCE_TYPE VARCHAR2 (30)
Data source type
DATA_SOURCE VARCHAR2 (240)
Data source

[top of page]

APPS.BSC_SYS_DIM_LEVEL_RELS_V references the following:

APPS
VIEW - BSC_SYS_DIM_LEVELS_VL
SYNONYM - BSC_SYS_DIM_LEVEL_RELS
APPS.BSC_SYS_DIM_LEVEL_RELS_V is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_DIM_OBJ_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_DIMENSION_LEVELS_PUB
PACKAGE BODY - BSC_PMF_UI_WRAPPER

[top of page]

View: BSC_SYS_IMAGES_MAP_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_SYS_IMAGES_MAP_VL is a view of the translated, language specific values from BSC_SYS_IMAGES_MAP_TL . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
SOURCE_TYPE NUMBER (3) Y
SOURCE_CODE NUMBER (5) Y
TYPE NUMBER (15) Y
IMAGE_ID NUMBER (15) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.BSC_SYS_IMAGES_MAP_VL references the following:

APPS
SYNONYM - BSC_SYS_IMAGES_MAP_TL
APPS.BSC_SYS_IMAGES_MAP_VL is referenced by following:

APPS
PACKAGE BODY - BSC_CUSTOM_VIEW_UI_WRAPPER
PACKAGE BODY - BSC_PMF_UI_WRAPPER
PACKAGE BODY - BSC_PORTLET_UI_WRAPPER
PACKAGE BODY - BSC_SIMULATION_VIEW_PUB

[top of page]

View: BSC_SYS_LABELS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_SYS_LABELS_VL is a view that joins the translated, language specific values from BSC_SYS_LABELS_TL with the non-displayed data from BSC_SYS_LABELS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
SOURCE_TYPE NUMBER (3) Y
SOURCE_CODE NUMBER (5) Y
LABEL_ID NUMBER (3) Y
NAME VARCHAR2 (150) Y
LEFT_POSITION NUMBER (5)
TOP_POSITION NUMBER (5)
FONT_SIZE NUMBER (5)
FONT_STYLE NUMBER (5)

[top of page]

APPS.BSC_SYS_LABELS_VL references the following:

APPS
SYNONYM - BSC_SYS_LABELS_B
SYNONYM - BSC_SYS_LABELS_TL

APPS.BSC_SYS_LABELS_VL is not referenced by any database object

[top of page]

View: BSC_SYS_MM_CONTROLS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_SYS_CONTROLS_VL is a view of the translated, language specific values from BSC_SYS_CONTROLS_TL. BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
BUTTON_ID NUMBER (5) Y
NAME VARCHAR2 (150) Y
HELP VARCHAR2 (240) Y
COMMAND VARCHAR2 (320)

[top of page]

APPS.BSC_SYS_MM_CONTROLS_VL references the following:

APPS
SYNONYM - BSC_SYS_MM_CONTROLS_TL

APPS.BSC_SYS_MM_CONTROLS_VL is not referenced by any database object

[top of page]

View: BSC_SYS_PERIODICITIES_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_SYS_PERIODICITIES_VL is a view that joins the translated, language specific values from BSC_SYS_PERIODICITIES_TL with the non-displayed data from BSC_SYS_PERIODICITIES . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
PERIODICITY_ID NUMBER (5)
NUM_OF_PERIODS NUMBER (5)
SOURCE VARCHAR2 (200)
NUM_OF_SUBPERIODS NUMBER (5)
PERIOD_COL_NAME VARCHAR2 (15)
SUBPERIOD_COL_NAME VARCHAR2 (15)
YEARLY_FLAG NUMBER (1)
EDW_FLAG NUMBER (1)
CALENDAR_ID NUMBER

EDW_PERIODICITY_ID NUMBER

CUSTOM_CODE NUMBER (1)
DB_COLUMN_NAME VARCHAR2 (30)
PERIODICITY_TYPE NUMBER (3)
NAME VARCHAR2 (150)
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)

[top of page]

APPS.BSC_SYS_PERIODICITIES_VL references the following:

APPS
VIEW - BSC_LOOKUPS
SYNONYM - BSC_SYS_CALENDARS_B
SYNONYM - BSC_SYS_PERIODICITIES
SYNONYM - BSC_SYS_PERIODICITIES_TL
APPS.BSC_SYS_PERIODICITIES_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_LOCKS_PVT
PACKAGE BODY - BSC_CALENDAR_PUB
PACKAGE BODY - BSC_CALENDAR_PVT
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_DBGEN_BSC_READER
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_MO_DOC_PKG
PACKAGE BODY - BSC_MO_HELPER_PKG
PACKAGE BODY - BSC_MO_UI_PKG
PACKAGE BODY - BSC_PERIODICITIES_PUB
PACKAGE BODY - BSC_PERIODICITIES_PVT
PACKAGE BODY - BSC_PERIODS_UTILITY_PKG
PACKAGE BODY - BSC_PMF_UI_WRAPPER
PACKAGE BODY - BSC_UPDATE

[top of page]

View: BSC_SYS_PERIODS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_SYS_PERIODS_VL is a view of the translated, language specific values from BSC_SYS_PERIODS_TL . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
YEAR NUMBER (4) Y
PERIODICITY_ID NUMBER (5) Y
PERIOD_ID NUMBER (5) Y
MONTH NUMBER (5) Y
NAME VARCHAR2 (100)
SHORT_NAME VARCHAR2 (165)

[top of page]

APPS.BSC_SYS_PERIODS_VL references the following:

APPS
SYNONYM - BSC_SYS_CALENDARS_B
SYNONYM - BSC_SYS_PERIODICITIES
SYNONYM - BSC_SYS_PERIODS_TL
APPS.BSC_SYS_PERIODS_VL is referenced by following:

APPS
VIEW - BSC_P_BSC_PER_CAL1_PER2_V
VIEW - BSC_P_BSC_PER_CAL1_PER3_V
VIEW - BSC_P_BSC_PER_CAL1_PER4_V
VIEW - BSC_P_BSC_PER_CAL1_PER5_V
VIEW - BSC_P_BSC_PER_CAL1_PER7_V
VIEW - BSC_P_BSC_PER_CAL1_PER9_V

[top of page]

View: BSC_TABS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_TABS_VL is a view that joins the translated, language specific values from BSC_TABS_TL with the non-displayed data from BSC_TABS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y
NAME VARCHAR2 (105) Y
HELP VARCHAR2 (240)
KPI_MODEL NUMBER (1)
BSC_MODEL NUMBER (1)
CROSS_MODEL NUMBER (1)
DEFAULT_MODEL NUMBER (15)
ZOOM_FACTOR NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)
TAB_INDEX NUMBER

PARENT_TAB_ID NUMBER (5)
OWNER_ID NUMBER (15)
ADDITIONAL_INFO VARCHAR2 (150)
SHORT_NAME VARCHAR2 (30)
Short name

[top of page]

APPS.BSC_TABS_VL references the following:

APPS
SYNONYM - BSC_TABS_B
SYNONYM - BSC_TABS_TL
APPS.BSC_TABS_VL is referenced by following:

APPS
PACKAGE BODY - BIS_PAGE_PUB
PACKAGE BODY - BSC_BIS_CUSTOM_KPI_UTIL_PUB
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_BIS_KPI_MEAS_PUB
PACKAGE BODY - BSC_CUSTOM_VIEW_UI_WRAPPER
PACKAGE BODY - BSC_DEFAULT_KEY_ITEM_PUB
PACKAGE BODY - BSC_METADATA_DESC
PACKAGE BODY - BSC_OAF_VIEWS_PVT
PACKAGE - BSC_PMF_UI_WRAPPER
PACKAGE BODY - BSC_PMF_UI_WRAPPER
PACKAGE BODY - BSC_SCORECARD_PUB

[top of page]

View: BSC_TAB_CSF_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_TAB_CSF_VL is a view that joins the translated, language specific values from BSC_TAB_CSF_TL with the non-displayed data from BSC_TAB_CSF_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y
CSF_ID NUMBER (3) Y
NAME VARCHAR2 (90)
HELP VARCHAR2 (240)
CSF_TYPE NUMBER (5)
INTERMEDIATE_FLAG NUMBER (1) Y

[top of page]

APPS.BSC_TAB_CSF_VL references the following:

APPS
SYNONYM - BSC_TAB_CSF_B
SYNONYM - BSC_TAB_CSF_TL

APPS.BSC_TAB_CSF_VL is not referenced by any database object

[top of page]

View: BSC_TAB_IND_GROUPS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_TAB_IND_GROUPS_VL is a view that joins the translated, language specific values from BSC_TAB_IND_GROUPS_TL with the non-displayed data from BSC_TAB_IND_GROUPS_B . BSC uses this view to display translated information in languages instal

Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y
CSF_ID NUMBER (3) Y
IND_GROUP_ID NUMBER (5) Y
NAME VARCHAR2 (150)
HELP VARCHAR2 (240)
GROUP_TYPE NUMBER (3)
NAME_POSITION NUMBER (3)
NAME_JUSTIFICATION NUMBER (3)
LEFT_POSITION NUMBER (5)
TOP_POSITION NUMBER (5)
WIDTH NUMBER (5)
HEIGHT NUMBER (5)
SHORT_NAME VARCHAR2 (30)
Short name

[top of page]

APPS.BSC_TAB_IND_GROUPS_VL references the following:

APPS
SYNONYM - BSC_TAB_IND_GROUPS_B
SYNONYM - BSC_TAB_IND_GROUPS_TL
APPS.BSC_TAB_IND_GROUPS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_BIS_CUSTOM_KPI_UTIL_PUB
PACKAGE BODY - BSC_BIS_KPI_CRUD_PUB
PACKAGE BODY - BSC_COPY_INDICATOR_PUB
PACKAGE BODY - BSC_KPI_GROUP_PUB
PACKAGE BODY - BSC_METADATA_DESC

[top of page]

View: BSC_TAB_IND_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y Tab identifier
IND_GROUP_ID NUMBER (5) Y
INDICATOR NUMBER (5) Y Indicator code
NAME VARCHAR2 (150) Y
SHARE_FLAG NUMBER (3) Y
SOURCE_INDICATOR NUMBER (5)

[top of page]

APPS.BSC_TAB_IND_V references the following:

APPS
VIEW - BSC_KPIS_VL
SYNONYM - BSC_TAB_INDICATORS

APPS.BSC_TAB_IND_V is not referenced by any database object

[top of page]

View: BSC_TAB_VIEWS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_TAB_VIEWS_VL is a view that joins the translated, language specific values from BSC_TAB_VIEWS_TL with the non-displayed data from BSC_TAB_VIEWS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y
TAB_VIEW_ID NUMBER (15) Y
NAME VARCHAR2 (105)
HELP VARCHAR2 (240)
ENABLED_FLAG NUMBER (1) Y
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.BSC_TAB_VIEWS_VL references the following:

APPS
VIEW - BSC_LOOKUPS
SYNONYM - BSC_TAB_VIEWS_B
SYNONYM - BSC_TAB_VIEWS_TL
APPS.BSC_TAB_VIEWS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_CUSTOM_VIEW_UI_WRAPPER
PACKAGE BODY - BSC_PMF_UI_WRAPPER
VIEW - BSC_TAB_VIEW_LABELS_VL
PACKAGE BODY - BSC_UPGRADES_GENERIC

[top of page]

View: BSC_TAB_VIEW_KPI_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_TAB_VIEW_KPI_VL is a view of the translated, language specific values from BSC_TAB_VIEW_KPI_TL . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y
TAB_VIEW_ID NUMBER (15) Y
INDICATOR NUMBER (5) Y
TEXT_FLAG NUMBER (1) Y
LEFT_POSITION NUMBER (5)
TOP_POSITION NUMBER (5)
WIDTH NUMBER (5)
HEIGHT NUMBER (5)
FONT_SIZE NUMBER (5)
FONT_STYLE NUMBER (5)
FONT_COLOR NUMBER

COLOR_LEFT_POSITION NUMBER (5)
COLOR_TOP_POSITION NUMBER (5)
COLOR_WIDTH NUMBER (5)
COLOR_HEIGHT NUMBER (5)
COLOR_SIZE NUMBER (5)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.BSC_TAB_VIEW_KPI_VL references the following:

APPS
SYNONYM - BSC_TAB_VIEW_KPI_TL
APPS.BSC_TAB_VIEW_KPI_VL is referenced by following:

APPS
PACKAGE BODY - BSC_CUSTOM_VIEW_PVT
PACKAGE BODY - BSC_CUSTOM_VIEW_UI_WRAPPER

[top of page]

View: BSC_TAB_VIEW_LABELS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_TAB_VIEW_LABELS_VL is a view of the translated, language specific values from BSC_TAB_VIEW_LABELS_TL . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Y
TAB_VIEW_ID NUMBER (15) Y
LABEL_ID NUMBER (15) Y
LABEL_TYPE NUMBER (2) Y Label Type, 0=Normal Label, 1=Tab View Link , 2=App Menu
LINK_ID NUMBER

Link id holds Tab view Id or App Menu Id , depending on label Type
NAME VARCHAR2 (150)
NOTE VARCHAR2 (3000)
Note used by Launch Pad
TEXT_FLAG NUMBER (1) Y
LEFT_POSITION NUMBER (5)
TOP_POSITION NUMBER (5)
WIDTH NUMBER (5)
HEIGHT NUMBER (5)
FONT_SIZE NUMBER (5)
FONT_STYLE NUMBER (5)
FONT_COLOR NUMBER

URL VARCHAR2 (320)
FUNCTION_ID NUMBER

CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.BSC_TAB_VIEW_LABELS_VL references the following:

APPS
VIEW - BSC_TAB_VIEWS_VL
SYNONYM - BSC_TAB_VIEW_LABELS_B
SYNONYM - BSC_TAB_VIEW_LABELS_TL
VIEW - FND_MENUS_VL
APPS.BSC_TAB_VIEW_LABELS_VL is referenced by following:

APPS
PACKAGE BODY - BSC_CUSTOM_VIEW_UI_WRAPPER
PACKAGE BODY - BSC_LAUNCH_PAD_PUB
PACKAGE BODY - BSC_SIMULATION_VIEW_PUB
PACKAGE BODY - BSC_SIMULATION_VIEW_PVT

[top of page]

View: BSC_USER_PARAMETERS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

BSC_USER_PARAMETERS_VL is a view that joins the translated, language specific values from BSC_USER_PARAMETERS_TL with the non-displayed data from BSC_USER_PARAMETERS_B . BSC uses this view to display translated information in languages installed at your site.

Columns
Name Datatype Length Mandatory Comments
PARAM_LIST_ID NUMBER
Y
TITLE VARCHAR2 (100)
APPLICATION_ID NUMBER (5) Y
INDICATOR NUMBER
Y
VIEW_TYPE NUMBER (1)
VALID_FLAG NUMBER (1) Y
ANALYSIS_MEASURES VARCHAR2 (80)
DIMENSION1 VARCHAR2 (80)
DIMENSION2 VARCHAR2 (80)
DIMENSION3 VARCHAR2 (80)
DIMENSION4 VARCHAR2 (80)
DIMENSION5 VARCHAR2 (80)
DIMENSION6 VARCHAR2 (80)
DIMENSION7 VARCHAR2 (80)
DIMENSION8 VARCHAR2 (80)
DIMENSION9 VARCHAR2 (80)
DIMENSION10 VARCHAR2 (80)
TIME_PERIOD VARCHAR2 (80)
DATA_SERIES VARCHAR2 (80)
CALCULATIONS VARCHAR2 (80)
BENCHMARKS VARCHAR2 (80)
CREATED_BY NUMBER (15) Y
CREATION_DATE DATE
Y
LAST_UPDATED_BY NUMBER (15) Y
LAST_UPDATE_DATE DATE
Y
LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.BSC_USER_PARAMETERS_VL references the following:

APPS
SYNONYM - BSC_USER_PARAMETERS_B
SYNONYM - BSC_USER_PARAMETERS_TL

APPS.BSC_USER_PARAMETERS_VL is not referenced by any database object

[top of page]

View: BSC_USER_RESPONSIBILITY_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
USER_ID NUMBER (15) Y
RESPONSIBILITY_ID NUMBER

[top of page]

APPS.BSC_USER_RESPONSIBILITY_V references the following:

APPS
PACKAGE - FND_DATE
VIEW - FND_RESPONSIBILITY_VL
SYNONYM - FND_USER
VIEW - FND_USER_RESP_GROUPS
APPS.BSC_USER_RESPONSIBILITY_V is referenced by following:

APPS
PACKAGE BODY - BSC_PORTLET_GRAPH

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract