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_LOAN_LOSS

Object Details

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

Loan Loss

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_LOAN_LOSS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CAL_PERIOD_ID DATASET_CODE SOURCE_SYSTEM_CODE LEDGER_ID ID_NUMBER INSTRUMENT_TYPE_CODE CUSTOMER_ID
FEM_LOAN_LOSS_01	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATED_BY_REQUEST_ID CREATED_BY_OBJECT_ID ID_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
CAL_PERIOD_ID	NUMBER		Yes	Calendar Period
DATASET_CODE	NUMBER		Yes	Dataset Code (Production dataset or Test Data set or Development Data set)
SOURCE_SYSTEM_CODE	NUMBER		Yes	Source System Code (Identifies the source system from where the data is coming).
LEDGER_ID	NUMBER		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_ID	NUMBER		Yes	Unique numeric identifier of the Customer
CREATED_BY_OBJECT_ID	NUMBER	(9)	Yes	Object that created the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID
CREATED_BY_REQUEST_ID	NUMBER		Yes	Request that created the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID
LAST_UPDATED_BY_OBJECT_ID	NUMBER	(9)	Yes	Object that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID
LAST_UPDATED_BY_REQUEST_ID	NUMBER		Yes	Request that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID
COMPANY_COST_CENTER_ORG_ID	NUMBER			Org unique numeric identifier of the Company Cost Center
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency Code
NATURAL_ACCOUNT_ID	NUMBER			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_ID	NUMBER			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_ID	NUMBER			Geographic Location
LEGAL_EXPENSES	NUMBER			Legal Expenses associated with Recovery of Collateral
LINE_ITEM_ID	NUMBER			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_ID	NUMBER			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 CAL_PERIOD_ID
,      DATASET_CODE
,      SOURCE_SYSTEM_CODE
,      LEDGER_ID
,      ID_NUMBER
,      INSTRUMENT_TYPE_CODE
,      CUSTOMER_ID
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      COMPANY_COST_CENTER_ORG_ID
,      CURRENCY_CODE
,      NATURAL_ACCOUNT_ID
,      ACCRUED_INTEREST
,      COST_OF_RECOVERY_EXTERNAL
,      COST_OF_RECOVERY_INTERNAL
,      CREDIT_STATUS_ID
,      DEFAULT_DATE
,      DEFAULT_REASONS
,      DFLT_LGD_ACTUAL
,      EAD_ACTUAL
,      ECONOMIC_LOSS
,      ESTIMATED_LOSS
,      ESTIMATED_RECOVERY
,      GEOGRAPHY_ID
,      LEGAL_EXPENSES
,      LINE_ITEM_ID
,      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_ID
,      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;

Dependencies

[top of page]

FEM.FEM_LOAN_LOSS does not reference any database object

FEM.FEM_LOAN_LOSS is referenced by following:

APPS: FEM_LOAN_LOSS