Entity Analytic Data Map Table

Owned by Dmitry Donosiyan (Unlicensed)
Last updated: Oct 29, 2024 by Kinga Huszno
1 min read

Element

Required/Optional

Value Type

Star Tag

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

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

 

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/

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

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

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

Â