Entity Security Lending Data Map Table
- Dmitry Donosiyan (Unlicensed)
- Kinga Huszno
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Eagle DB | DB Table | DB Field | Data Type | XPath |
|---|---|---|---|---|---|---|---|---|
objectType | Required | Required | ObjectTypeEnum | not stored in DB |
| EagleML/entityTransaction/entitySecurityLending/objectType | ||
objectId |
|
| ObjectId | not stored in DB |
| EagleML/entityTransaction/entitySecurityLending/objectId | ||
objectDescription |
|
| FeedTypeEnum | not stored in DB |
| EagleML/entityTransaction/entitySecurityLending/objectDescription | ||
updateTimestamp |
|
| dateTime |
|
|
|
| EagleML/entityTransaction/entitySecurityLending/updateTimestamp |
customElements | Not recommended | CustomElements - reserved for customizations | EagleML/entityTransaction/entitySecurityLending/customElements/ | |||||
updateSource |
|
| string |
|
|
|
| EagleML/entityTransaction/entitySecurityLending/updateSource |
accountingValidationFlag |
|
| YesNoOptionEnum | not stored in DB |
| EagleML/entityTransaction/entitySecurityLending/accountingValidationFlag | ||
mutualEntityType |
|
| MutualEntityTypeEnum | not stored in DB |
| EagleML/entityTransaction/entitySecurityLending/mutualEntityType | ||
Entity Common Id Model - see extra data map table | EagleML/entityTransaction/entitySecurityLending/ | |||||||
effectiveDate |
|
| date | RULESDBO | ENTITY_SEC_LENDING | EFFECTIVE_DATE | DATE | EagleML/entityTransaction/entitySecurityLending/effectiveDate |
sourceName |
| Required | string | RULESDBO | ENTITY_SEC_LENDING | SRC_INTFC_INST | NUMBER | EagleML/entityTransaction/entitySecurityLending/sourceName |
borrowerIssuer |
| Required | Issuer Identifiers Model - see extra data map table | EagleML/entityTransaction/entitySecurityLending/borrowerIssuer/ | ||||
agentIssuer |
|
| Issuer Identifiers Model - see extra data map table | EagleML/entityTransaction/entitySecurityLending/agentIssuer/ | ||||
cashCollateralManagerIssuer |
|
| Issuer Identifiers Model - see extra data map table | EagleML/entityTransaction/entitySecurityLending/cashCollateralManagerIssuer/ | ||||
indemnificationProviderIssuer |
|
| Issuer Identifiers Model - see extra data map table | EagleML/entityTransaction/entitySecurityLending/indemnificationProviderIssuer/ | ||||
grossIncome |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | GROSS_INCOME | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/grossIncome |
grossIncomeAgent |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | GROSS_INCOME_AGENT | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/grossIncomeAgent |
premiumIncome |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | PREMIUM_INCOME | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/premiumIncome |
agencyFee |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | AGENCY_FEE | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/agencyFee |
cashCollateralReinvestmentFee |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | CASH_COLLATERAL_REINVEST_FEE | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/cashCollateralReinvestmentFee |
administrativeFee |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | ADMINISTRATIVE_FEE | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/administrativeFee |
indemnificationFee |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | INDEMNIFICATION_FEE | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/indemnificationFee |
rebatePaidToBorrower |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | REBATE_PAID_TO_BORROWER | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/rebatePaidToBorrower |
otherFee |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | OTHER_FEE | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/otherFee |
otherFeeDescription |
|
| string | RULESDBO | ENTITY_SEC_LENDING | OTHER_FEE_DESCRIPTION | VARCHAR2(255) | EagleML/entityTransaction/entitySecurityLending/otherFeeDescription |
aggregateFees |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | AGGREGATE_FEES | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/aggregateFees |
netIncome |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | NET_INCOME | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/netIncome |
averageOnLoanValue |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | AVERAGE_ON_LOAN_VALUE | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/averageOnLoanValue |
netOpExpenseCashCollReinvestmentVehicle |
| decimal | RULESDBO | ENTITY_SEC_LENDING | NET_OP_EXP_CASH_COLLAT_RE_VEH | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/netOpExpenseCashCollReinvestmentVehicle | |
marketValueOnLoan |
|
| decimal | RULESDBO | ENTITY_SEC_LENDING | MARKET_VALUE_ON_LOAN | NUMBER(36,12) | EagleML/entityTransaction/entitySecurityLending/marketValueOnLoan |
defaultLiquidatedCollateral |
|
| YesNoOptionEnum | RULESDBO | ENTITY_SEC_LENDING | DEFAULT_LIQ_COLLAT | VARCHAR2(1) | EagleML/entityTransaction/entitySecurityLending/defaultLiquidatedCollateral |
adverseImpact |
|
| YesNoOptionEnum | RULESDBO | ENTITY_SEC_LENDING | ADVERSE_IMPACT | VARCHAR2(1) | EagleML/entityTransaction/entitySecurityLending/adverseImpact |
indemnificationOnBorrowerDefault |
|
| YesNoOptionEnum | RULESDBO | ENTITY_SEC_LENDING | INDEM_ON_BORROWER_DEFAULT | VARCHAR2(1) | EagleML/entityTransaction/entitySecurityLending/indemnificationOnBorrowerDefault |
exerciseIndemnificationRights |
|
| YesNoOptionEnum | RULESDBO | ENTITY_SEC_LENDING | EXERCISE_INDEM_RIGHTS | VARCHAR2(1) | EagleML/entityTransaction/entitySecurityLending/exerciseIndemnificationRights |
agencyFeeIndicator |
|
| YesNoOptionEnum | RULESDBO | ENTITY_SEC_LENDING | AGENCY_FEE_IND | VARCHAR2(1) | EagleML/entityTransaction/entitySecurityLending/agencyFeeIndicator |
nonRevenueShareSplitIndicator |
|
| YesNoOptionEnum | RULESDBO | ENTITY_SEC_LENDING | NON_REV_SHARE_SPLIT_IND | VARCHAR2(1) | EagleML/entityTransaction/entitySecurityLending/nonRevenueShareSplitIndicator |
administrativeFeeIndicator |
|
| YesNoOptionEnum | RULESDBO | ENTITY_SEC_LENDING | ADMIN_FEE_IND | VARCHAR2(1) | EagleML/entityTransaction/entitySecurityLending/administrativeFeeIndicator |
cashCollateralReinvestmentFeeIndicator |
|
| YesNoOptionEnum | RULESDBO | ENTITY_SEC_LENDING | CASH_COLLAT_REINVEST_FEE_IND | VARCHAR2(1) | EagleML/entityTransaction/entitySecurityLending/cashCollateralReinvestmentFeeIndicator |
indemnificationFeeIndicator |
|
| YesNoOptionEnum | RULESDBO | ENTITY_SEC_LENDING | INDEMNIFICATION_FEE_IND | VARCHAR2(1) | EagleML/entityTransaction/entitySecurityLending/indemnificationFeeIndicator |
otherFeeIndicator |
|
| YesNoOptionEnum | RULESDBO | ENTITY_SEC_LENDING | OTHER_FEE_IND | VARCHAR2(1) | EagleML/entityTransaction/entitySecurityLending/otherFeeIndicator |
fundLendIndicator |
|
| YesNoOptionEnum | RULESDBO | ENTITY_SEC_LENDING | FUND_LEND_INDICATOR | VARCHAR2(1) | EagleML/entityTransaction/entitySecurityLending/fundLendIndicator |