Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

NUMBER

VARCHAR2(

38

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

entityAnalyticModel

Entity Analytic Data Map Table#entityAnalyticModel - see extra table below

EagleML/entityTransaction/entityAnalytic/entityAnalyticModel/

entityPeerGroupAnalyticModel

entityPeerGroupAnalyticModel

Entity Analytic Data Map Table#entityPeerGroupAnalyticModel - 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

decimalRULESDBOENTITY_ANALYTICSRETURN_NETNUMBER(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