DBA Data[Home] [Help] [Dependency Information]

TABLE: FEM.FEM_CUSTOMER_PROFIT_T

Object Details
Object Name: FEM_CUSTOMER_PROFIT_T
Object Type: TABLE
Owner: FEM
Subobject Name:
Status: VALID


FEM_CUSTOMER_PROFIT_T is an interface table for loading and updating Analytic Customer Profit data into the FEM_CUSTOMER_PROFIT 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.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Customer Profit Data
Category: BUSINESS_ENTITY FEM_FACT_REPOSITORY


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_CUSTOMER_PROFIT_T_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCALP_DIM_GRP_DISPLAY_CODE
ColumnCAL_PERIOD_NUMBER
ColumnCAL_PERIOD_END_DATE
ColumnDATASET_DISPLAY_CODE
ColumnSOURCE_SYSTEM_DISPLAY_CODE
ColumnID_NUMBER
ColumnCUSTOMER_DISPLAY_CODE
ColumnTABLE_ID
Columns
Name Datatype Length Mandatory Comments
STATUS VARCHAR2 (60) Yes Designates the Status of the row for loading. Records with a STATUS="LOAD" will be loaded by the Source Data Loader. All other STATUS codes designate some sort of error from the load. The user (translated) text description can be found in FND Messages using this error status code as the Message Name.
CALP_DIM_GRP_DISPLAY_CODE VARCHAR2 (150) Yes Calendar Period Dimension Group
CAL_PERIOD_NUMBER NUMBER (15) Yes Calendar Period Number. Provides alternate identification for the Calendar Period, together with Ledger ID, Calendar Period End Date, and Calendar Period Dimension Group Name.
CAL_PERIOD_END_DATE DATE
Yes The end date of the calendar period
DATASET_DISPLAY_CODE VARCHAR2 (150) Yes Dataset identifier.
LEDGER_DISPLAY_CODE VARCHAR2 (150) Yes Ledger identifier.
SOURCE_SYSTEM_DISPLAY_CODE VARCHAR2 (150) Yes Source System Identier.
CHANNEL_DISPLAY_CODE VARCHAR2 (150) Yes Channel
CCTR_ORG_DISPLAY_CODE VARCHAR2 (150) Yes Company Cost Center Organization
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
CUSTOMER_DISPLAY_CODE VARCHAR2 (150) Yes Unique numeric identifier of the Customer
DATA_AGGREGATION_TYPE_CODE VARCHAR2 (30) Yes Identifier if the data in the row is account
ID_NUMBER NUMBER
Yes Uniquely identifies an instrument.
MARKET_SEGMENT_DISPLAY_CODE VARCHAR2 (150) Yes This defines the segment of the market for a given customer.
NATURAL_ACCOUNT_DISPLAY_CODE VARCHAR2 (150) Yes This dimension column stores the unique identification for the natural accounting type of the related account.
PRODUCT_DISPLAY_CODE VARCHAR2 (150) Yes Product
RECORD_COUNT NUMBER
Yes The number of source transaction records represented by each record.
TABLE_ID NUMBER
Yes Account Table Identifier
ALLOCATED_EQUITY NUMBER

Allocated Equity
ALPHANUMERIC_MEASURE01 VARCHAR2 (100)
Alphanumeric Measure1
ALPHANUMERIC_MEASURE02 VARCHAR2 (100)
Alphanumeric Measure2
ALPHANUMERIC_MEASURE03 VARCHAR2 (100)
Alphanumeric Measure3
ALPHANUMERIC_MEASURE04 VARCHAR2 (100)
Alphanumeric Measure4
ALPHANUMERIC_MEASURE05 VARCHAR2 (100)
Alphanumeric Measure5
ALPHANUMERIC_MEASURE06 VARCHAR2 (100)
Alphanumeric Measure6
ALPHANUMERIC_MEASURE07 VARCHAR2 (100)
Alphanumeric Measure7
ALPHANUMERIC_MEASURE08 VARCHAR2 (100)
Alphanumeric Measure8
ALPHANUMERIC_MEASURE09 VARCHAR2 (100)
Alphanumeric Measure9
ALPHANUMERIC_MEASURE10 VARCHAR2 (100)
Alphanumeric Measure10
CONTRIB_AFTER_CAPITAL_CHG NUMBER

Contribution after capital charge; typically Account Contribution - Allocated Equity * hurdle rate
CUR_AVG_BOOK_BAL NUMBER

Current book balance- average of participations.
CUR_NET_BOOK_BAL NUMBER

Current book balance- net of participations.
DATE_MEASURE01 DATE

Date Measure1
DATE_MEASURE02 DATE

Date Measure2
DATE_MEASURE03 DATE

Date Measure3
DATE_MEASURE04 DATE

Date Measure4
EQUITY_CREDIT NUMBER

Equity credit for the account; typically Allocated Equity * equity credit rate
INTEREST_CHARGE_CREDIT NUMBER

Interest Charge Credit
INTEREST_INC_EXP NUMBER

Interest income/expense; typically average balance * interest rate
LOAN_LOSS_PROVISION NUMBER

Loan loss provision for the account; typically average balance * product-specific rate
LTD_BALANCE NUMBER

Life to Date Balance
NET_FEE_INCOME NUMBER

Gross Fee Income - Waived Fees
NET_INT_MARGIN NUMBER

Net interest margin; typically Transfer Charge/Credit + Interest Income/Expense - Loan Loss Provision
NUMERIC_MEASURE01 NUMBER

Numeric Measure1
NUMERIC_MEASURE02 NUMBER

Numeric Measure2
NUMERIC_MEASURE03 NUMBER

Numeric Measure3
NUMERIC_MEASURE04 NUMBER

Numeric Measure4
NUMERIC_MEASURE05 NUMBER

Numeric Measure5
NUMERIC_MEASURE06 NUMBER

Numeric Measure6
NUMERIC_MEASURE07 NUMBER

Numeric Measure7
NUMERIC_MEASURE08 NUMBER

Numeric Measure8
NUMERIC_MEASURE09 NUMBER

Numeric Measure9
NUMERIC_MEASURE10 NUMBER

Numeric Measure10
NUMERIC_MEASURE11 NUMBER

NUMERIC_MEASURE11
NUMERIC_MEASURE12 NUMBER

NUMERIC_MEASURE12
NUMERIC_MEASURE13 NUMBER

NUMERIC_MEASURE13
NUMERIC_MEASURE14 NUMBER

NUMERIC_MEASURE14
NUMERIC_MEASURE15 NUMBER

NUMERIC_MEASURE15
NUMERIC_MEASURE16 NUMBER

NUMERIC_MEASURE16
NUMERIC_MEASURE17 NUMBER

NUMERIC_MEASURE17
NUMERIC_MEASURE18 NUMBER

NUMERIC_MEASURE18
NUMERIC_MEASURE19 NUMBER

NUMERIC_MEASURE19
NUMERIC_MEASURE20 NUMBER

NUMERIC_MEASURE20
OPEN_ACCOUNT_FLAG VARCHAR2 (1)
Open Account Flag
ORIGINATION_DATE DATE

Date the current institution originated or acquired the instrument. For rolled instruments the greater of date last rolled or date acquired.
PRI_ACCOUNTS NUMBER

Primary Accounts
PROFIT_CONTRIB NUMBER

The current net profit contribution for the account
PROFIT_DECILE NUMBER

The decile associated with the net profit contribution
PROFIT_PERCENTILE NUMBER

The percentile associated with the net profit contribution
PTD_BALANCE NUMBER

Period to Date Balance
RELATIONSHIP_EXP NUMBER

Expense related to the customer relationship
RETURN_ON_EQUITY NUMBER

Return on equity for the account; typically Account Contribution / Allocated Equity (annualized by 12)
SEC_ACCOUNTS NUMBER

SEC Accounts
TOTAL_EXPENSE NUMBER

The total or gross expense
TOTAL_REVENUE NUMBER

The total or gross revenue
TRANSACTIONS NUMBER

Transactions
USER_DIM10_DISPLAY_CODE VARCHAR2 (150)
User Dimension10
USER_DIM1_DISPLAY_CODE VARCHAR2 (150)
User Dimension1
USER_DIM2_DISPLAY_CODE VARCHAR2 (150)
User Dimension2
USER_DIM3_DISPLAY_CODE VARCHAR2 (150)
User Dimension3
USER_DIM4_DISPLAY_CODE VARCHAR2 (150)
User Dimension4
USER_DIM5_DISPLAY_CODE VARCHAR2 (150)
User Dimension5
USER_DIM6_DISPLAY_CODE VARCHAR2 (150)
User Dimension6
USER_DIM7_DISPLAY_CODE VARCHAR2 (150)
User Dimension7
USER_DIM8_DISPLAY_CODE VARCHAR2 (150)
User Dimension8
USER_DIM9_DISPLAY_CODE VARCHAR2 (150)
User Dimension9
VALUE_INDEX1 NUMBER

One of three customer value index result columns
VALUE_INDEX2 NUMBER

One of three customer value index result columns
VALUE_INDEX3 NUMBER

One of three customer value index result columns
BUS_REL_DISPLAY_CODE VARCHAR2 (150) Yes Business Relationship
ACCT_OWNERSHIP_DISPLAY_CODE VARCHAR2 (150) Yes Account Ownership text identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT STATUS
,      CALP_DIM_GRP_DISPLAY_CODE
,      CAL_PERIOD_NUMBER
,      CAL_PERIOD_END_DATE
,      DATASET_DISPLAY_CODE
,      LEDGER_DISPLAY_CODE
,      SOURCE_SYSTEM_DISPLAY_CODE
,      CHANNEL_DISPLAY_CODE
,      CCTR_ORG_DISPLAY_CODE
,      CURRENCY_CODE
,      CUSTOMER_DISPLAY_CODE
,      DATA_AGGREGATION_TYPE_CODE
,      ID_NUMBER
,      MARKET_SEGMENT_DISPLAY_CODE
,      NATURAL_ACCOUNT_DISPLAY_CODE
,      PRODUCT_DISPLAY_CODE
,      RECORD_COUNT
,      TABLE_ID
,      ALLOCATED_EQUITY
,      ALPHANUMERIC_MEASURE01
,      ALPHANUMERIC_MEASURE02
,      ALPHANUMERIC_MEASURE03
,      ALPHANUMERIC_MEASURE04
,      ALPHANUMERIC_MEASURE05
,      ALPHANUMERIC_MEASURE06
,      ALPHANUMERIC_MEASURE07
,      ALPHANUMERIC_MEASURE08
,      ALPHANUMERIC_MEASURE09
,      ALPHANUMERIC_MEASURE10
,      CONTRIB_AFTER_CAPITAL_CHG
,      CUR_AVG_BOOK_BAL
,      CUR_NET_BOOK_BAL
,      DATE_MEASURE01
,      DATE_MEASURE02
,      DATE_MEASURE03
,      DATE_MEASURE04
,      EQUITY_CREDIT
,      INTEREST_CHARGE_CREDIT
,      INTEREST_INC_EXP
,      LOAN_LOSS_PROVISION
,      LTD_BALANCE
,      NET_FEE_INCOME
,      NET_INT_MARGIN
,      NUMERIC_MEASURE01
,      NUMERIC_MEASURE02
,      NUMERIC_MEASURE03
,      NUMERIC_MEASURE04
,      NUMERIC_MEASURE05
,      NUMERIC_MEASURE06
,      NUMERIC_MEASURE07
,      NUMERIC_MEASURE08
,      NUMERIC_MEASURE09
,      NUMERIC_MEASURE10
,      NUMERIC_MEASURE11
,      NUMERIC_MEASURE12
,      NUMERIC_MEASURE13
,      NUMERIC_MEASURE14
,      NUMERIC_MEASURE15
,      NUMERIC_MEASURE16
,      NUMERIC_MEASURE17
,      NUMERIC_MEASURE18
,      NUMERIC_MEASURE19
,      NUMERIC_MEASURE20
,      OPEN_ACCOUNT_FLAG
,      ORIGINATION_DATE
,      PRI_ACCOUNTS
,      PROFIT_CONTRIB
,      PROFIT_DECILE
,      PROFIT_PERCENTILE
,      PTD_BALANCE
,      RELATIONSHIP_EXP
,      RETURN_ON_EQUITY
,      SEC_ACCOUNTS
,      TOTAL_EXPENSE
,      TOTAL_REVENUE
,      TRANSACTIONS
,      USER_DIM10_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
,      VALUE_INDEX1
,      VALUE_INDEX2
,      VALUE_INDEX3
,      BUS_REL_DISPLAY_CODE
,      ACCT_OWNERSHIP_DISPLAY_CODE
FROM FEM.FEM_CUSTOMER_PROFIT_T;

Dependencies

[top of page]

FEM.FEM_CUSTOMER_PROFIT_T does not reference any database object

FEM.FEM_CUSTOMER_PROFIT_T is referenced by following:

SchemaAPPS
SynonymFEM_CUSTOMER_PROFIT_T