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 | ||||||
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 | |||||||||
Entity Analytic Data Map Table#entityAnalyticModel - see extra table below | EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/ | |||||||
entityPeerGroupAnalyticModel | ||||||||
Entity Analytic Data Map Table#entityPeerGroupAnalyticModel - see extra table below | EagleML/entityTransaction/entityAnalytic/entityPeerGroupAnalyticModel/ | ||||||||||||||
| |||||||||||||||
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 | |||||||||
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 | |||||||||
| |||||||||||||||
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 | |||||||