[Home] [Help] [Dependency Information]
Object Name: | QPR_DIM_SOURCES |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table contains the operational data store dimension source mapping information. Contains data related to the instance source table/view from which data will be sourced and target columns to which data will be populated. This mapping information is used to populate the data from application instance to dimension table QPR_DIMENSION_VALUES, which inturn forms the source for creating data marts.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_DIM_SOURCES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | DIM_SOURCE_ID |
QPR_DIM_SOURCES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INSTANCE_ID
DIM_CODE HIER_CODE LEVEL_NUMBER INSTANCE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIM_SOURCE_ID | NUMBER | Yes | Unique Identifier for dimension source mapping values. | |
INSTANCE_ID | NUMBER | Yes | Unique identifier of the application instance from which the data is sourced. | |
INSTANCE_TYPE | VARCHAR2 | (30) | Yes | Type to identify whether it refers to Oracle Applications 11i or R 12. |
DIM_CODE | VARCHAR2 | (30) | Yes | Unique code to identify the dimension for which the mapping is defined. |
HIER_CODE | VARCHAR2 | (30) | Unique code to identify the dimension hierarchy for which the mapping is defined. | |
SEEDED_FLAG | VARCHAR2 | (1) | Indicates if the value is seeded data or not.Takes values 'Y'/'N'. | |
VIEW_NAME | VARCHAR2 | (30) | Indicates the source table/view name from which the data is sourced. | |
LEVEL_NUMBER | NUMBER | Yes | Indicates the level in the dimension hierarchy for which the mapping is defined. | |
DESC_COLUMN | VARCHAR2 | (30) | Indicates the target column name to which level description will be populated. | |
VALUE_COLUMN | VARCHAR2 | (30) | Indicates the target column name to which the level member values will be populated. | |
ATTR_NUMBER | NUMBER | Indicates the attribute number of the level for which the mapping is defined. | ||
ATTR_COLUMN | VARCHAR2 | (30) | Indicates the target column name to which the attribute value will be populated. | |
USER_VIEW_NAME | VARCHAR2 | (30) | Indicates the source table/view name from which the data is sourced. | |
USER_LEVEL_NUMBER | NUMBER | Indicates the level in the dimension hierarchy for which the mapping is defined. | ||
USER_DESC_COLUMN | VARCHAR2 | (30) | Indicates the target column name to which level description will be populated. | |
USER_VALUE_COLUMN | VARCHAR2 | (30) | Indicates the target column name to which the level member values will be populated. | |
USER_ATTR_NUMBER | NUMBER | Indicates the attribute number of the level for which the mapping is defined. | ||
USER_ATTR_COLUMN | VARCHAR2 | (30) | Indicates the target column name to which the attribute value will be populated. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
PROGRAM_ID | NUMBER | Identifies the concurrent program | ||
PROGRAM_LOGIN_ID | NUMBER | Identifies the Oracle Applicaitons Consurrent Program Login ID | ||
PROGRAM_APPLICATION_ID | NUMBER | Identifies the Oracle Application that spawned the consurrent program | ||
REQUEST_ID | NUMBER | Identifies the concurrent request instance that spawned the concurrent program |
Cut, paste (and edit) the following text to query this object:
SELECT DIM_SOURCE_ID
, INSTANCE_ID
, INSTANCE_TYPE
, DIM_CODE
, HIER_CODE
, SEEDED_FLAG
, VIEW_NAME
, LEVEL_NUMBER
, DESC_COLUMN
, VALUE_COLUMN
, ATTR_NUMBER
, ATTR_COLUMN
, USER_VIEW_NAME
, USER_LEVEL_NUMBER
, USER_DESC_COLUMN
, USER_VALUE_COLUMN
, USER_ATTR_NUMBER
, USER_ATTR_COLUMN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM QPR.QPR_DIM_SOURCES;
QPR.QPR_DIM_SOURCES does not reference any database object
QPR.QPR_DIM_SOURCES is referenced by following:
|
|
|