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

TABLE: FEM.FEM_CUSTOMER_PROFIT

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


Customer Profit


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_CUSTOMER_PROFIT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAL_PERIOD_ID
ColumnDATASET_CODE
ColumnSOURCE_SYSTEM_CODE
ColumnID_NUMBER
ColumnCUSTOMER_ID
ColumnTABLE_ID
FEM_CUSTOMER_PROFIT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDATASET_CODE
ColumnCAL_PERIOD_ID
ColumnLEDGER_ID
ColumnCUSTOMER_ID
ColumnDATA_AGGREGATION_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
CAL_PERIOD_ID NUMBER
Yes Calendar Period
DATASET_CODE NUMBER
Yes Dataset
SOURCE_SYSTEM_CODE NUMBER
Yes Source System
ID_NUMBER NUMBER
Yes Instrument Identification Number
CUSTOMER_ID NUMBER
Yes Customer
CREATED_BY_OBJECT_ID NUMBER (9) Yes Created By Object
CREATED_BY_REQUEST_ID NUMBER
Yes Created By Request
NATURAL_ACCOUNT_ID NUMBER
Yes Natural Account
COMPANY_COST_CENTER_ORG_ID NUMBER
Yes Company Cost Center Organization
CURRENCY_CODE VARCHAR2 (15) Yes Currency
LEDGER_ID NUMBER
Yes Ledger
PRODUCT_ID NUMBER
Yes Product
CHANNEL_ID NUMBER
Yes Channel
RECORD_COUNT NUMBER
Yes Record Count
CONTRIB_AFTER_CAPITAL_CHG NUMBER

Contribution After Capital Charge
PRI_ACCOUNTS NUMBER

Primary Accounts
PROFIT_CONTRIB NUMBER

Profit Contribution
PROFIT_DECILE NUMBER

Profit Decile
PROFIT_PERCENTILE NUMBER

Profit Percentile
RELATIONSHIP_EXP NUMBER

Relationship Expense
RETURN_ON_EQUITY NUMBER

Return on Equity
SEC_ACCOUNTS NUMBER

SEC Accounts
TRANSACTIONS NUMBER

Transactions
EQUITY_CREDIT NUMBER

Equity Credit
INTEREST_CHARGE_CREDIT NUMBER

Interest Charge Credit
INTEREST_INC_EXP NUMBER

Interest Income/Expense
LOAN_LOSS_PROVISION NUMBER

Loan Loss Provision (LLP)
NET_FEE_INCOME NUMBER

Net Fee Income
NET_INT_MARGIN NUMBER

Net Interest Margin (NIM)
OPEN_ACCOUNT_FLAG VARCHAR2 (1)
Open Account Flag
ORIGINATION_DATE DATE

Origination Date
CUR_NET_BOOK_BAL NUMBER

Current Net Book Balance
VALUE_INDEX1 NUMBER

Value Index1
VALUE_INDEX2 NUMBER

Value Index2
VALUE_INDEX3 NUMBER

Value Index3
USER_DIM1_ID NUMBER

User Dimension01
USER_DIM2_ID NUMBER

User Dimension02
USER_DIM3_ID NUMBER

User Dimension03
USER_DIM4_ID NUMBER

User Dimension04
USER_DIM5_ID NUMBER

User Dimension05
USER_DIM6_ID NUMBER

User Dimension06
USER_DIM7_ID NUMBER

User Dimension07
USER_DIM8_ID NUMBER

User Dimension08
USER_DIM9_ID NUMBER

User Dimension09
USER_DIM10_ID NUMBER

User Dimension10
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
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
DATE_MEASURE01 DATE

Date Measure1
DATE_MEASURE02 DATE

Date Measure2
DATE_MEASURE03 DATE

Date Measure3
DATE_MEASURE04 DATE

Date Measure4
LAST_UPDATED_BY_REQUEST_ID NUMBER
Yes Last Updated By Request
LAST_UPDATED_BY_OBJECT_ID NUMBER (9) Yes Last Updated By Object
DATA_AGGREGATION_TYPE_CODE VARCHAR2 (30) Yes Identifier if the data in the row is account
MARKET_SEGMENT_ID NUMBER
Yes This defines the segment of the market for a given customer.
TABLE_ID NUMBER
Yes Account Table Identifier
ALLOCATED_EQUITY NUMBER

Allocated Equity
CUR_AVG_BOOK_BAL NUMBER

Current book balance- average of participations.
LTD_BALANCE NUMBER

Life to Date Balance
PTD_BALANCE NUMBER

Period to Date Balance
TOTAL_EXPENSE NUMBER

The total or gross expense
TOTAL_REVENUE NUMBER

The total or gross revenue
BUS_REL_ID NUMBER
Yes Business Relationship
ACCT_OWNERSHIP_ID NUMBER
Yes Account Ownership numeric identifier
Query Text

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


SELECT CAL_PERIOD_ID
,      DATASET_CODE
,      SOURCE_SYSTEM_CODE
,      ID_NUMBER
,      CUSTOMER_ID
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      NATURAL_ACCOUNT_ID
,      COMPANY_COST_CENTER_ORG_ID
,      CURRENCY_CODE
,      LEDGER_ID
,      PRODUCT_ID
,      CHANNEL_ID
,      RECORD_COUNT
,      CONTRIB_AFTER_CAPITAL_CHG
,      PRI_ACCOUNTS
,      PROFIT_CONTRIB
,      PROFIT_DECILE
,      PROFIT_PERCENTILE
,      RELATIONSHIP_EXP
,      RETURN_ON_EQUITY
,      SEC_ACCOUNTS
,      TRANSACTIONS
,      EQUITY_CREDIT
,      INTEREST_CHARGE_CREDIT
,      INTEREST_INC_EXP
,      LOAN_LOSS_PROVISION
,      NET_FEE_INCOME
,      NET_INT_MARGIN
,      OPEN_ACCOUNT_FLAG
,      ORIGINATION_DATE
,      CUR_NET_BOOK_BAL
,      VALUE_INDEX1
,      VALUE_INDEX2
,      VALUE_INDEX3
,      USER_DIM1_ID
,      USER_DIM2_ID
,      USER_DIM3_ID
,      USER_DIM4_ID
,      USER_DIM5_ID
,      USER_DIM6_ID
,      USER_DIM7_ID
,      USER_DIM8_ID
,      USER_DIM9_ID
,      USER_DIM10_ID
,      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
,      ALPHANUMERIC_MEASURE01
,      ALPHANUMERIC_MEASURE02
,      ALPHANUMERIC_MEASURE03
,      ALPHANUMERIC_MEASURE04
,      ALPHANUMERIC_MEASURE05
,      ALPHANUMERIC_MEASURE06
,      ALPHANUMERIC_MEASURE07
,      ALPHANUMERIC_MEASURE08
,      ALPHANUMERIC_MEASURE09
,      ALPHANUMERIC_MEASURE10
,      DATE_MEASURE01
,      DATE_MEASURE02
,      DATE_MEASURE03
,      DATE_MEASURE04
,      LAST_UPDATED_BY_REQUEST_ID
,      LAST_UPDATED_BY_OBJECT_ID
,      DATA_AGGREGATION_TYPE_CODE
,      MARKET_SEGMENT_ID
,      TABLE_ID
,      ALLOCATED_EQUITY
,      CUR_AVG_BOOK_BAL
,      LTD_BALANCE
,      PTD_BALANCE
,      TOTAL_EXPENSE
,      TOTAL_REVENUE
,      BUS_REL_ID
,      ACCT_OWNERSHIP_ID
FROM FEM.FEM_CUSTOMER_PROFIT;

Dependencies

[top of page]

FEM.FEM_CUSTOMER_PROFIT does not reference any database object

FEM.FEM_CUSTOMER_PROFIT is referenced by following:

SchemaAPPS
SynonymFEM_CUSTOMER_PROFIT