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

TABLE: FEM.FEM_LOAN_LOSS_T

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


FEM_LOAN_LOSS_T is an interface table for loading and updating Analytic Loan Loss data into the FEM_LOAN_LOSS 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 Loan Loss 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_LOAN_LOSS_T_PK 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
ColumnLEDGER_DISPLAY_CODE
ColumnID_NUMBER
ColumnINSTRUMENT_TYPE_CODE
ColumnCUSTOMER_DISPLAY_CODE
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 (Production dataset or Test Data set or Development Data set)
SOURCE_SYSTEM_DISPLAY_CODE VARCHAR2 (150) Yes Source System Code (Identifies the source system from where the data is coming).
LEDGER_DISPLAY_CODE VARCHAR2 (150) Yes Unique numeric identifier of the Ledger
ID_NUMBER NUMBER
Yes Uniquely identifies an instrument.
INSTRUMENT_TYPE_CODE NUMBER
Yes Code of the Instrument Type.
CUSTOMER_DISPLAY_CODE VARCHAR2 (150) Yes Unique numeric identifier of the Customer
CCTR_ORG_DISPLAY_CODE VARCHAR2 (150)
Org unique numeric identifier of the Company Cost Center
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
NATURAL_ACCOUNT_DISPLAY_CODE VARCHAR2 (150)
Unique numeric identifier of the Natural Account
ACCRUED_INTEREST NUMBER

Accrued or Unpaid Interest
COST_OF_RECOVERY_EXTERNAL NUMBER

External Cost to effect recoveries
COST_OF_RECOVERY_INTERNAL NUMBER

Internal Cost to effect recoveries
CREDIT_STATUS_DISPLAY_CODE VARCHAR2 (150)
Current performance status of the loan.
DEFAULT_DATE DATE

Date of Default
DEFAULT_REASONS VARCHAR2 (255)
Reasons for Default
DFLT_LGD_ACTUAL NUMBER

Actual Loss Given Default value for an asset is in default
EAD_ACTUAL NUMBER

Exposure value at Default Date
ECONOMIC_LOSS NUMBER

Actual Exposure at Default + Legal Costs + Internal Collateral Costs + External Collateral Costs
ESTIMATED_LOSS NUMBER

Actual Exposure at Default - Total Expected Recoveries
ESTIMATED_RECOVERY NUMBER

Estimated Recovery Amount
GEOGRAPHY_DISPLAY_CODE VARCHAR2 (150)
Geographic Location
LEGAL_EXPENSES NUMBER

Legal Expenses associated with Recovery of Collateral
LINE_ITEM_DISPLAY_CODE VARCHAR2 (150)
Line Item
LOSS_AMT NUMBER

Actual Exposure at Default - Total Recoveries
MITIGANT_ID NUMBER

Unique numeric identifier for a mitigant record
MITIGANT_RECOVERY_AMOUNT NUMBER

Recovery Amount of Mitigant
MITIGANT_RECOVERY_DATE DATE

Date of Collateral Recovery
MITIGANT_RECOVERY_METHOD_CODE VARCHAR2 (30)
Method of Recovery
NET_ECONOMIC_LOSS NUMBER

Economic Loss - Total Expected Recoveries
ORIGINAL_ACCOUNT_ID VARCHAR2 (50)
Account unique numeric identifier of Original Loan
OTHER_RECOVERED_AMOUNT NUMBER

Amount of Loan Recovered (Non Mitigant)
OTHER_RECOVERY_DATE DATE

Date of Recovery of Others.
OTHER_RECOVERY_METHOD_CODE VARCHAR2 (30)
Source of Recovery (if not mitigant)
PD_PRCN_ONE_YR_PRI_DFLT_DT NUMBER

Probability of Default One Year Prior to Default Date
RECOVERY_EXPENSES NUMBER

Expenses incurred in Recovering Collateral
SIC_DISPLAY_CODE VARCHAR2 (150)
Standard Industrial Classification Code to identify each industry
SPECIFIC_PROVISION NUMBER

Provision expense specifically allocated for a given asset.
TOTAL_EXPECTED_RECOVERIES NUMBER

Mitigant Recovery Amount + Other Recovery Amount+ Estimated recovery
TOTAL_RECOVERIES NUMBER

Mitigant Recovery Amount + Other Recovery Amount
WRITE_OFF_AMOUNT NUMBER

Write-off amount for specific loan.
WRITE_OFF_DATE DATE

Date of the Write off.
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
SPECIFIC_PROVISION_CHARGE_OFF NUMBER

The charge_off to the Account Specific Provision for the given Calendar Period
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
,      ID_NUMBER
,      INSTRUMENT_TYPE_CODE
,      CUSTOMER_DISPLAY_CODE
,      CCTR_ORG_DISPLAY_CODE
,      CURRENCY_CODE
,      NATURAL_ACCOUNT_DISPLAY_CODE
,      ACCRUED_INTEREST
,      COST_OF_RECOVERY_EXTERNAL
,      COST_OF_RECOVERY_INTERNAL
,      CREDIT_STATUS_DISPLAY_CODE
,      DEFAULT_DATE
,      DEFAULT_REASONS
,      DFLT_LGD_ACTUAL
,      EAD_ACTUAL
,      ECONOMIC_LOSS
,      ESTIMATED_LOSS
,      ESTIMATED_RECOVERY
,      GEOGRAPHY_DISPLAY_CODE
,      LEGAL_EXPENSES
,      LINE_ITEM_DISPLAY_CODE
,      LOSS_AMT
,      MITIGANT_ID
,      MITIGANT_RECOVERY_AMOUNT
,      MITIGANT_RECOVERY_DATE
,      MITIGANT_RECOVERY_METHOD_CODE
,      NET_ECONOMIC_LOSS
,      ORIGINAL_ACCOUNT_ID
,      OTHER_RECOVERED_AMOUNT
,      OTHER_RECOVERY_DATE
,      OTHER_RECOVERY_METHOD_CODE
,      PD_PRCN_ONE_YR_PRI_DFLT_DT
,      RECOVERY_EXPENSES
,      SIC_DISPLAY_CODE
,      SPECIFIC_PROVISION
,      TOTAL_EXPECTED_RECOVERIES
,      TOTAL_RECOVERIES
,      WRITE_OFF_AMOUNT
,      WRITE_OFF_DATE
,      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
,      SPECIFIC_PROVISION_CHARGE_OFF
FROM FEM.FEM_LOAN_LOSS_T;

Dependencies

[top of page]

FEM.FEM_LOAN_LOSS_T does not reference any database object

FEM.FEM_LOAN_LOSS_T is referenced by following:

SchemaAPPS
SynonymFEM_LOAN_LOSS_T