[Home] [Help] [Dependency Information]
Object Name: | FEM_DATA11_T |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
FEM_DATA11_T is an interface table for loading and updating Analytic Generic FEM Data11 data into the FEM_DATA11 table using the Detail Client Data Loader. With the exception of the information required for the Calendar Period dimension as well as the STATUS column, each column on the interface table maps to a column in the destination table. The mapping between the columns on the interface table and the destination table is stored as Table Registration metadata. Users can go to the Table Registration user interface to view and update the column mapping metadata. Most columns that have a one-to-one mapping between the interface and destination tables share the same column name. If the interface table column maps to a destination table column with a different name, then the column most likely represents a dimension that has both a user-defined non-translatable alphanumeric identifier (or "Display Code") and a system generated numeric identifier (or "ID") for its members. Users should always populate the interface table column with the dimension "Display Code" value. The Detail Client Data Loader transforms the member values in the interface table into the correct internal numeric identifiers for each member. For example, LEDGER_DISPLAY_CODE and LEDGER_ID are columns that represent the Ledger dimension on the interface table and destination table, respectively. Users just need to populate the LEDGER_DISPLAY_CODE with the "Display Code" value. The data loader transforms the "Display Code" value into an internal numeric identifier before storing into the LEDGER_ID column on the destination table.
As noted above, members for the Calendar Period dimension are not identified in this manner. Rather, they are identified by a combination of the following information:
Level (CALP_DIM_GRP_DISPLAY_CODE), End Date (CAL_PERIOD_END_DATE), and Period Number (CAL_PERIOD_NUMBER). The loader also uses the Ledger (LEDGER_DISPLAY_CODE) to identify the Calendar to be used to verify the existence of all of the Calendar Period members in the load.
The 3 measure columns (ALPHANUMERIC_MEASURE, DATE_MEASURE and NUMERIC_MEASURE) are used to store the piece of fact information that is being loaded.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Generic FEM Data11
Category: BUSINESS_ENTITY FEM_FACT_REPOSITORY
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATASET_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Non translatable alphanumeric identifier for the Dataset dimension member |
CAL_PERIOD_NUMBER | NUMBER | (15) | Yes | Period number of the calendar period |
SOURCE_SYSTEM_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Non translatable alphanumeric identifier for the Source System dimension member |
LEDGER_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Non translatable alphanumeric identifier for the Ledger dimension member |
CCTR_ORG_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier for the Company Cost Center Organization dimension member | |
CURRENCY_CODE | VARCHAR2 | (15) | Code that identifies the Currency | |
FINANCIAL_ELEM_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the Financial Element dimension member | |
PRODUCT_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the Product member | |
NATURAL_ACCOUNT_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the Natural Account member | |
CHANNEL_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric code that identifies the Channel member | |
LINE_ITEM_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the Line Item member | |
PROJECT_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the Project dimension member | |
CUSTOMER_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the customer dimension member | |
ENTITY_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the Entity dimension member | |
INTERCOMPANY_DISPLAY_CODE | VARCHAR2 | (150) | Intercompany dimension member alphanumeric code | |
USER_DIM1_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the dimension member | |
USER_DIM2_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the dimension member | |
USER_DIM3_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the dimension member | |
USER_DIM4_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the dimension member | |
USER_DIM5_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the dimension member | |
USER_DIM6_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the dimension member | |
USER_DIM7_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the dimension member | |
USER_DIM8_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the dimension member | |
USER_DIM9_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the dimension member | |
USER_DIM10_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier of the dimension member | |
NUMERIC_MEASURE | NUMBER | Generic column for numeric data | ||
ALPHANUMERIC_MEASURE | VARCHAR2 | (4000) | Generic column for alphanumeric data | |
DATE_MEASURE | DATE | Generic column for date data | ||
STATUS | VARCHAR2 | (60) | Yes | Load status of the record |
CALP_DIM_GRP_DISPLAY_CODE | VARCHAR2 | (150) | Yes | Non translatable alphanumeric identifier for the Calendar period Dimension Group |
GEOGRAPHY_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier for the Geography dimension member | |
TASK_DISPLAY_CODE | VARCHAR2 | (150) | Non translatable alphanumeric identifier for the Task dimension member | |
CAL_PERIOD_END_DATE | DATE | Yes | Calendar Period End Date |
Cut, paste (and edit) the following text to query this object:
SELECT DATASET_DISPLAY_CODE
, CAL_PERIOD_NUMBER
, SOURCE_SYSTEM_DISPLAY_CODE
, LEDGER_DISPLAY_CODE
, CCTR_ORG_DISPLAY_CODE
, CURRENCY_CODE
, FINANCIAL_ELEM_DISPLAY_CODE
, PRODUCT_DISPLAY_CODE
, NATURAL_ACCOUNT_DISPLAY_CODE
, CHANNEL_DISPLAY_CODE
, LINE_ITEM_DISPLAY_CODE
, PROJECT_DISPLAY_CODE
, CUSTOMER_DISPLAY_CODE
, ENTITY_DISPLAY_CODE
, INTERCOMPANY_DISPLAY_CODE
, USER_DIM1_DISPLAY_CODE
, USER_DIM2_DISPLAY_CODE
, USER_DIM3_DISPLAY_CODE
, USER_DIM4_DISPLAY_CODE
, USER_DIM5_DISPLAY_CODE
, USER_DIM6_DISPLAY_CODE
, USER_DIM7_DISPLAY_CODE
, USER_DIM8_DISPLAY_CODE
, USER_DIM9_DISPLAY_CODE
, USER_DIM10_DISPLAY_CODE
, NUMERIC_MEASURE
, ALPHANUMERIC_MEASURE
, DATE_MEASURE
, STATUS
, CALP_DIM_GRP_DISPLAY_CODE
, GEOGRAPHY_DISPLAY_CODE
, TASK_DISPLAY_CODE
, CAL_PERIOD_END_DATE
FROM FEM.FEM_DATA11_T;
FEM.FEM_DATA11_T does not reference any database object
FEM.FEM_DATA11_T is referenced by following:
|
|
|