Entity Peer Group Ranking Data Map Table

Element

Required/Optional

Value Type

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Required/Optional

Value Type

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

objectType

 

ObjectTypeEnum

 

not stored in DB

EagleML/entityTransaction/entityPeerGroupRanking/objectType

objectId

 

ObjectId

 

not stored in DB

EagleML/entityTransaction/entityPeerGroupRanking/objectId

objectDescription

 

FeedTypeEnum

 

not stored in DB

EagleML/entityTransaction/entityPeerGroupRanking/objectDescription

updateTimestamp

Required

dateTime

RULESDBO

ENTITY_PEER_GRP_RANKINGS

UPDATE_DATE

DATE

EagleML/entityTransaction/entityPeerGroupRanking/updateTimestamp

customElements

Not recommended

CustomElements - reserved for customizations

EagleML/entityTransaction/entityPeerGroupRanking/customElements/

updateSource

Required

string

RULESDBO

ENTITY_PEER_GRP_RANKINGS

UPDATE_SOURCE

VARCHAR2(255)

EagleML/entityTransaction/entityPeerGroupRanking/updateSource

accountingValidationFlag

 

YesNoOptionEnum

 

not stored in DB

EagleML/entityTransaction/entityPeerGroupRanking/accountingValidationFlag

mutualEntityType

 

MutualEntityTypeEnum

 

not stored in DB

EagleML/entityTransaction/entityPeerGroupRanking/mutualEntityType

Entity Common Id Model

EagleML/entityTransaction/entityPeerGroupRanking/

sourceName

 

string

PACE_MASTERDBO

INTERFACES

SHORT_DESC

NUMBER(38)

EagleML/entityTransaction/entityPeerGroupRanking/sourceName

effectiveDate

Required

date

RULESDBO

ENTITY_PEER_GRP_RANKINGS

EFFECTIVE_DATE

DATE

EagleML/entityTransaction/entityPeerGroupRanking/effectiveDate

timePeriod

Required

string

RULESDBO

ENTITY_PEER_GRP_RANKINGS

TIME_PERIOD

VARCHAR2(20)

EagleML/entityTransaction/entityPeerGroupRanking/timePeriod

peerGroupId

Required

Entity Common Id Model

EagleML/entityTransaction/entityPeerGroupRanking/peerGroupId/

returnRank

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

RETURN_RANK

NUMBER(38,12)

EagleML/entityTransaction/entityPeerGroupRanking/returnRank

stdDevRank

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

STD_DEV_RANK

NUMBER(38,12)

EagleML/entityTransaction/entityPeerGroupRanking/stdDevRank

expRatioRank

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

EXP_RATIO_RANK

NUMBER(38,12)

EagleML/entityTransaction/entityPeerGroupRanking/expRatioRank

userFloat1

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

USER_FLOAT1

NUMBER(38,12)

EagleML/entityTransaction/entityPeerGroupRanking/userFloat1

userFloat2

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

USER_FLOAT2

NUMBER(38,12)

EagleML/entityTransaction/entityPeerGroupRanking/userFloat2

userFloat3

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

USER_FLOAT3

NUMBER(38,12)

EagleML/entityTransaction/entityPeerGroupRanking/userFloat3

userFloat4

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

USER_FLOAT4

NUMBER(38,12)

EagleML/entityTransaction/entityPeerGroupRanking/userFloat4

userFloat5

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

USER_FLOAT5

NUMBER(38,12)

EagleML/entityTransaction/entityPeerGroupRanking/userFloat5

absRankNet
(available for DB v.)

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

ABS_RANK_NET

 

EagleML/entityTransaction/entityPeerGroupRanking/absRankNet

categorySizeNet
(available for DB v.)

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

CATEGORY_SIZE_NET

 

EagleML/entityTransaction/entityPeerGroupRanking/categorySizeNet

percentRank
(available for DB v.)

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

PERCENT_RANK

 

EagleML/entityTransaction/entityPeerGroupRanking/percentRank

medianReturn
(available for DB v.)

 

decimal

RULESDBO

ENTITY_PEER_GRP_RANKINGS

MEDIAN_RETURN

 

EagleML/entityTransaction/entityPeerGroupRanking/medianReturn

Â