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

TABLE: FEM.FEM_COLLATERALS

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


Collaterals


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_COLLATERALS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAL_PERIOD_ID
ColumnDATASET_CODE
ColumnSOURCE_SYSTEM_CODE
ColumnID_NUMBER
ColumnINSTRUMENT_TYPE_CODE
ColumnMITIGANT_ID
ColumnCREATED_BY_OBJECT_ID
FEM_COLLATERALS_01 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATED_BY_REQUEST_ID
ColumnCREATED_BY_OBJECT_ID
ColumnID_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).
ID_NUMBER NUMBER
Yes Uniquely identifies an instrument.
INSTRUMENT_TYPE_CODE NUMBER
Yes Code of the Instrument Type.
MITIGANT_ID NUMBER
Yes Unique numeric identifier for a mitigant record
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
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
LEDGER_ID NUMBER
Yes Ledger
ACTUAL_HOLDING_PERIOD NUMBER (5)
Actual number of days bank holds certain financial transactions. Used in haircut calculation.
ACT_DAYS_REPR NUMBER (6)
Actual Days between remargining/repricing. Used in haircut calculation.
COUNTRY_GEOGRAPHY_ID NUMBER

Country Geography
CREDIT_RATING_ID NUMBER

Credit Rating Code and Agency for a given asset or issuer.
CUSIP_NUMBER VARCHAR2 (10)
Unique Committee on Uniform Security value that identifies a security
CUSTOMER_ID NUMBER

Unique numeric identifier of the Customer
GEOGRAPHY_ID NUMBER

Geographic Location
LGD_ADVANCED NUMBER

Loss Given Default value for banks electing to apply the Advanced Approach and import a value.
MITIGANT_VALUE NUMBER

Amount of mitigant allocated to an asset
ORG_TERM NUMBER

Original Term
ORG_TERM_MULT VARCHAR2 (30)
Original Term Multiplier
PROB_DFLT NUMBER (10)
Probability of Default
REMAIN_TERM NUMBER

Remaining Term of the Collateral
REMAIN_TERM_MULT VARCHAR2 (30)
Remaining Term Multiplier of the Collateral
SENIORITY_FLAG VARCHAR2 (30)
Identifies whether a credit facility is a senior or subordinate claim. Y means Senior (45 percentage Loss Given Default) and N means Subordinate (75 percentage Loss Given Default).
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 CAL_PERIOD_ID
,      DATASET_CODE
,      SOURCE_SYSTEM_CODE
,      ID_NUMBER
,      INSTRUMENT_TYPE_CODE
,      MITIGANT_ID
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      CURRENCY_CODE
,      LEDGER_ID
,      ACTUAL_HOLDING_PERIOD
,      ACT_DAYS_REPR
,      COUNTRY_GEOGRAPHY_ID
,      CREDIT_RATING_ID
,      CUSIP_NUMBER
,      CUSTOMER_ID
,      GEOGRAPHY_ID
,      LGD_ADVANCED
,      MITIGANT_VALUE
,      ORG_TERM
,      ORG_TERM_MULT
,      PROB_DFLT
,      REMAIN_TERM
,      REMAIN_TERM_MULT
,      SENIORITY_FLAG
,      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_COLLATERALS;

Dependencies

[top of page]

FEM.FEM_COLLATERALS does not reference any database object

FEM.FEM_COLLATERALS is referenced by following:

SchemaAPPS
SynonymFEM_COLLATERALS