eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FEM.FEM_TRADING_VAR_T

Object Details

Object Name:	FEM_TRADING_VAR_T
Object Type:	TABLE
Owner:	FEM
Subobject Name:
Status:	VALID

FEM_TRADING_VAR_T is an interface table for loading and updating Analytic Trading Value At Risk data into the FEM_TRADING_VAR 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 Trading Value At Risk Data
Category: BUSINESS_ENTITY FEM_FACT_REPOSITORY

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_TRADING_VAR_T_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CALP_DIM_GRP_DISPLAY_CODE CAL_PERIOD_NUMBER CAL_PERIOD_END_DATE DATASET_DISPLAY_CODE SOURCE_SYSTEM_DISPLAY_CODE LEDGER_DISPLAY_CODE CCTR_ORG_DISPLAY_CODE CURRENCY_CODE EXTERNAL_PROCESS_ID PORTFOLIO_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
STATUS	VARCHAR2	(60)	Yes	Designates the Status of the row for loading. Records with a STATUS of "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 Code
SOURCE_SYSTEM_DISPLAY_CODE	VARCHAR2	(150)	Yes	Value at Risk Data Source Indicator
LEDGER_DISPLAY_CODE	VARCHAR2	(150)	Yes	Ledger
CCTR_ORG_DISPLAY_CODE	VARCHAR2	(150)	Yes	Organization unique numeric identifier of the Company Cost Center
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency Code
EXTERNAL_PROCESS_ID	NUMBER	(15)	Yes	Unique Process Unique numeric identifier that generated result
PORTFOLIO_NUM	NUMBER	(5)	Yes	Portfolio Number
ACTUAL_LOSS	NUMBER			Actual loss or amount for over the period described by the Value at Risk table
CAPITAL_MULTIPLIER	NUMBER			Multiplier used to determine the capital charge from Value at Risk inputs for the Market Risk
CAPITAL_REQUIREMENT_MR	NUMBER			Capital Required for Market Risk
CONFIDENCE_INTERVAL	NUMBER			Probability Factor for Results
VAR_AT_RISK_AMOUNT	NUMBER			Dollar Value that is at Risk
VAR_TERM	NUMBER			Value at Risk Term
VAR_TERM_MULT	VARCHAR2	(30)		Value at Risk Term Multiplier
ALPHANUMERIC_MEASURE01	VARCHAR2	(4000)		Alphanumeric Measure1
ALPHANUMERIC_MEASURE02	VARCHAR2	(4000)		Alphanumeric Measure2
ALPHANUMERIC_MEASURE03	VARCHAR2	(4000)		Alphanumeric Measure3
ALPHANUMERIC_MEASURE04	VARCHAR2	(4000)		Alphanumeric Measure4
ALPHANUMERIC_MEASURE05	VARCHAR2	(4000)		Alphanumeric Measure5
ALPHANUMERIC_MEASURE06	VARCHAR2	(4000)		Alphanumeric Measure6
ALPHANUMERIC_MEASURE07	VARCHAR2	(4000)		Alphanumeric Measure7
ALPHANUMERIC_MEASURE08	VARCHAR2	(4000)		Alphanumeric Measure8
ALPHANUMERIC_MEASURE09	VARCHAR2	(4000)		Alphanumeric Measure9
ALPHANUMERIC_MEASURE10	VARCHAR2	(4000)		Alphanumeric Measure10
DATE_MEASURE01	DATE			Date Measure1
DATE_MEASURE02	DATE			Date Measure2
DATE_MEASURE03	DATE			Date Measure3
DATE_MEASURE04	DATE			Date Measure4
DATE_MEASURE05	DATE			Date Measure5
DATE_MEASURE06	DATE			Date Measure6
DATE_MEASURE07	DATE			Date Measure7
DATE_MEASURE08	DATE			Date Measure8
DATE_MEASURE09	DATE			Date Measure9
DATE_MEASURE10	DATE			Date Measure10
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

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
,      SOURCE_SYSTEM_DISPLAY_CODE
,      LEDGER_DISPLAY_CODE
,      CCTR_ORG_DISPLAY_CODE
,      CURRENCY_CODE
,      EXTERNAL_PROCESS_ID
,      PORTFOLIO_NUM
,      ACTUAL_LOSS
,      CAPITAL_MULTIPLIER
,      CAPITAL_REQUIREMENT_MR
,      CONFIDENCE_INTERVAL
,      VAR_AT_RISK_AMOUNT
,      VAR_TERM
,      VAR_TERM_MULT
,      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
,      DATE_MEASURE05
,      DATE_MEASURE06
,      DATE_MEASURE07
,      DATE_MEASURE08
,      DATE_MEASURE09
,      DATE_MEASURE10
,      NUMERIC_MEASURE01
,      NUMERIC_MEASURE02
,      NUMERIC_MEASURE03
,      NUMERIC_MEASURE04
,      NUMERIC_MEASURE05
,      NUMERIC_MEASURE06
,      NUMERIC_MEASURE07
,      NUMERIC_MEASURE08
,      NUMERIC_MEASURE09
,      NUMERIC_MEASURE10
FROM FEM.FEM_TRADING_VAR_T;

Dependencies

[top of page]

FEM.FEM_TRADING_VAR_T does not reference any database object

FEM.FEM_TRADING_VAR_T is referenced by following:

APPS: FEM_TRADING_VAR_T