[Home] [Help] [Dependency Information]
Object Name: | FEM_DL_DIMENSIONS |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_DL_DIMENSIONS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
REQUEST_ID
OBJECT_ID LEDGER_ID CAL_PERIOD_ID DATASET_CODE SOURCE_SYSTEM_CODE TABLE_NAME |
FEM_DL_DIMENSIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LEDGER_ID
CAL_PERIOD_ID DATASET_CODE SOURCE_SYSTEM_CODE TABLE_NAME LAST_UPDATE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Yes | Identifies the request of the process that created the data locations entry | |
OBJECT_ID | NUMBER | (9) | Yes | Identifies the business object that created the data locations entry |
LEDGER_ID | NUMBER | Yes | Ledger member identifier | |
CAL_PERIOD_ID | NUMBER | Yes | Calendar Period member identifier | |
DATASET_CODE | NUMBER | Yes | Dataset member identifier | |
SOURCE_SYSTEM_CODE | NUMBER | Yes | Source System member identifier | |
BALANCE_TYPE_CODE | VARCHAR2 | (30) | Yes | Designates the Balance Type of the Dataset |
TABLE_NAME | VARCHAR2 | (30) | Yes | Name of the fact table where the dimension data resides |
LOAD_STATUS | VARCHAR2 | (30) | Status of the process or load that created the dimension data in the fact table | |
REPROCESS_ERRORS_FLAG | VARCHAR2 | (1) | Yes | Designates whether or not automatic error reprocessing for loads will occur for the dimension combination |
CREATION_DATE | DATE | Yes | Identifies the date on which the data was created | |
CREATED_BY | NUMBER | (15) | Yes | Identifies the user that created the data |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Identifies the user that last updated the data |
LAST_UPDATE_DATE | DATE | Yes | Identifies the data on which the data was last updated | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Identifies the login user that last updated the data | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object Version Number for stale data detection | |
AVG_BALANCES | NUMBER | (1) | Determines if Average Balances were loaded for a Request, Object, Ledger, Ledger, Calendar Period, Dataset Code and Source System Code: (1) if Average Balances were loaded, (0) if Average Balances were not loaded, null if not applicable. |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, OBJECT_ID
, LEDGER_ID
, CAL_PERIOD_ID
, DATASET_CODE
, SOURCE_SYSTEM_CODE
, BALANCE_TYPE_CODE
, TABLE_NAME
, LOAD_STATUS
, REPROCESS_ERRORS_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, AVG_BALANCES
FROM FEM.FEM_DL_DIMENSIONS;
FEM.FEM_DL_DIMENSIONS does not reference any database object
FEM.FEM_DL_DIMENSIONS is referenced by following:
|
|
|