| Element | Required/Optional | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|
| objectType |
| ObjectTypeEnum |
|
| not stored in DB |
| EagleML/entityTransaction/entityAnalytic/objectType |
| objectId |
| ObjectId |
|
| not stored in DB |
| EagleML/entityTransaction/entityAnalytic/objectId |
| objectDescription |
| FeedTypeEnum |
|
| not stored in DB |
| EagleML/entityTransaction/entityAnalytic/objectDescription |
| updateTimestamp | Required | dateTime |
|
| RULESDBO | ENTITY_ANALYTICS | UPDATE_DATE | DATE | EagleML/entityTransaction/entityAnalytic/updateTimestamp |
| ENTITY_PEER_GRP_ANALYTICS |
| customElements | Not recommended | CustomElements - reserved for customizations | EagleML/entityTransaction/entityAnalytic/customElements/ |
| updateSource | Required | string | 944 | in_update_source | RULESDBO | ENTITY_ANALYTICS | UPDATE_SOURCE | VARCHAR2(255) | EagleML/entityTransaction/entityAnalytic/updateSource |
| ENTITY_PEER_GRP_ANALYTICS |
| accountingValidationFlag |
| YesNoOptionEnum |
|
| not stored in DB |
| EagleML/entityTransaction/entityAnalytic/accountingValidationFlag |
| mutualEntityType |
| MutualEntityTypeEnum |
|
| not stored in DB |
| EagleML/entityTransaction/entityAnalytic/mutualEntityType |
| Entity Common Id Model | EagleML/entityTransaction/entityAnalytic/ |
| sourceName |
| string | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC |
| EagleML/entityTransaction/entityAnalytic/sourceName |
| effectiveDate | Required | date |
| in_effective_date | RULESDBO | ENTITY_ANALYTICS | EFFECTIVE_DATE | DATE | EagleML/entityTransaction/entityAnalytic/effectiveDate |
| ENTITY_PEER_GRP_ANALYTICS |
| timePeriod | Required | string |
|
| RULESDBO | ENTITY_ANALYTICS | TIME_PERIOD | VARCHAR2(20) | EagleML/entityTransaction/entityAnalytic/timePeriod |
| ENTITY_PEER_GRP_ANALYTICS |
| entityAnalyticModel |
| 796229698 - see extra table below | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/ |
| entityPeerGroupAnalyticModel |
| 796229698 - see extra table below | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/ |
| Anchor |
|---|
| entityAnalyticModel |
|---|
| entityAnalyticModel |
|---|
|
entityAnalyticModel Data Map Table |
| expRatio |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | EXP_RATIO | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/expRatio |
| fundReturn |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | FUND_RETURN | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/fundReturn |
| secYield |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | SEC_YIELD | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/secYield |
| sharpeRatio |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | SHARPE_RATIO | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/sharpeRatio |
| srriVar |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | SRRI_VAR | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/srriVar |
| srriVarPeriods |
| integer |
|
| RULESDBO | ENTITY_ANALYTICS | SRRI_VAR_PERIODS | NUMBER(38) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/srriVarPeriods |
| stdDev |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | STD_DEV | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/stdDev |
| turnoverRatio |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | TURNOVER_RATIO | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/turnoverRatio | returnNet | decimal | RULESDBO | ENTITY_ANALYTICS | RETURN_NET | NUMBER(38,12) |
| EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/returnNet | userFloat1 |
| decimal | 1324 | in_user_float1 | RULESDBO | ENTITY_ANALYTICS | USER_FLOAT1 | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/userFloat1 |
| userFloat2 |
| decimal | 193 | in_user_float2 | RULESDBO | ENTITY_ANALYTICS | USER_FLOAT2 | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/userFloat2 |
| userFloat3 |
| decimal | 1326 | in_user_float3 | RULESDBO | ENTITY_ANALYTICS | USER_FLOAT3 | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/userFloat3 |
| stdDevNet |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | STD_DEV_NET | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/stdDevNet |
| netReturn |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | NET_RETURN | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/netReturn |
| marketValue |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | MARKET_VALUE | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/marketValue |
| derivativeExposure |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | DERV_EXPOSURE | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/derivativeExposure |
| currencyDerivativeExposure |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | CURR_DERV_EXPOSURE | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/currencyDerivativeExposure |
| interestDerivativeExposure |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | INT_DERV_EXPOSURE | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/interestDerivativeExposure |
| derivativeExposureBreachDays |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | DERV_EXP_BREACH_DAYS | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/derivativeExposureBreachDays |
| valueAtRiskExceptions |
| decimal |
|
| RULESDBO | ENTITY_ANALYTICS | VAR_EXCEPTIONS | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/valueAtRiskExceptions |
| Anchor |
|---|
| entityPeerGroupAnalyticModel |
|---|
| entityPeerGroupAnalyticModel |
|---|
|
entityPeerGroupAnalyticModel Data Map Table |
| returnMax |
| decimal |
|
| RULESDBO | ENTITY_PEER_GRP_ANALYTICS | RETURN_MAX | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/returnMax |
| returnMin |
| decimal |
|
| RULESDBO | ENTITY_PEER_GRP_ANALYTICS | RETURN_MIN | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/returnMin |
| return25P |
| decimal |
|
| RULESDBO | ENTITY_PEER_GRP_ANALYTICS | RETURN_25P | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/return25P |
| return50P |
| decimal |
|
| RULESDBO | ENTITY_PEER_GRP_ANALYTICS | RETURN_50P | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/return50P |
| return75P |
| decimal |
|
| RULESDBO | ENTITY_PEER_GRP_ANALYTICS | RETURN_75P | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/return75P |
| userFloat1 |
| decimal | 1324 | in_user_float1 | RULESDBO | ENTITY_PEER_GRP_ANALYTICS | USER_FLOAT1 | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/userFloat1 |
| userFloat2 |
| decimal | 193 | in_user_float2 | RULESDBO | ENTITY_PEER_GRP_ANALYTICS | USER_FLOAT2 | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/userFloat2 |
| userFloat3 |
| decimal | 1326 | in_user_float3 | RULESDBO | ENTITY_PEER_GRP_ANALYTICS | USER_FLOAT3 | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/userFloat3 |
| userFloat4 |
| decimal | 1327 | in_user_float4 | RULESDBO | ENTITY_PEER_GRP_ANALYTICS | USER_FLOAT4 | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/userFloat4 |
| userFloat5 |
| decimal | 1328 | in_user_float5 | RULESDBO | ENTITY_PEER_GRP_ANALYTICS | USER_FLOAT5 | NUMBER(38,12) | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/userFloat5 |