Warehouse Custody Restriction Activity Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Nov 07, 2024 by Kinga Huszno
1 min read

Element

Optional/Required

Value Type

Star Tag

Eagle DB

DB Table

DB Field

Data Type

XPath

Element

Optional/Required

Value Type

Star Tag

Eagle DB

DB Table

DB Field

Data Type

XPath

objectType

Optional

objectType

 

not stored in DB

EagleML/warehouseTransaction/custodyRestrictionActivity/objectType

objectId

Optional

objectId

 

not stored in DB

EagleML/warehouseTransaction/custodyRestrictionActivity/objectId

objectDescription

Optional

objectDescription

 

not stored in DB

EagleML/warehouseTransaction/custodyRestrictionActivity/objectDescription

updateTimestamp

Optional

dateTime

 

HOLDINGDBO

CUSTODY_ACTIVITY

UPDATE_DATE

DATE(7)

EagleML/warehouseTransaction/custodyRestrictionActivity/updateTimestamp

customElements

Not recommended

CustomElements

 

reserved for customizations

EagleML/warehouseTransaction/custodyRestrictionActivity/customElements

sourceName

Optional

string

1102

PACE_MASTERDBO

INTERFACES

SHORT_DESC

CHAR(15)

EagleML/warehouseTransaction/custodyRestrictionActivity/sourceName

updateSource

Optional

string

 

HOLDINGDBO

CUSTODY_ACTIVITY

UPDATE_SOURCE

VARCHAR(50)

EagleML/warehouseTransaction/custodyRestrictionActivity/updateSource

batchCollectErrorsFlag

Optional

YesNoOptionEnum

 

not stored in DB

EagleML/warehouseTransaction/custodyRestrictionActivity/batchCollectErrorsFlag

singleRowCommitFlag

Optional

YesNoOptionEnum

 

not stored in DB

EagleML/warehouseTransaction/custodyRestrictionActivity/singleRowCommitFlag

Entity Common Id Model

EagleML/warehouseTransaction/custodyRestrictionActivity/

Entity Properties Model (extract only)

EagleML/warehouseTransaction/custodyRestrictionActivity/

Asset Identifiers Model

EagleML/warehouseTransaction/custodyRestrictionActivity/

Extended Asset Properties Model (extract only)

EagleML/warehouseTransaction/custodyRestrictionActivity/

maturityDate

Optional

date

 

not stored in DB

EagleML/warehouseTransaction/custodyRestrictionActivity/maturityDate

pledgeDetail

Pledge Detail - Complex type (see extra table below)

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/

effectiveDate

Required

date

1109

HOLDINGDBO

CUSTODY_ACTIVITY

EFFECTIVE_DATE

DATE(7)

EagleML/warehouseTransaction/custodyRestrictionActivity/effectiveDate

action

Required

string

153

HOLDINGDBO

CUSTODY_ACTIVITY

ACTION

VARCHAR(10)

EagleML/warehouseTransaction/custodyRestrictionActivity/action

units

Required

decimal

903

HOLDINGDBO

CUSTODY_ACTIVITY

UNITS

NUMBER(28,12)

EagleML/warehouseTransaction/custodyRestrictionActivity/units

userNotes

Optional

string

 

HOLDINGDBO

CUSTODY_ACTIVITY

USER_NOTES

VARCHAR(30)

EagleML/warehouseTransaction/custodyRestrictionActivity/userNotes

balanceInstance

Required

integer

 

HOLDINGDBO

CUSTODY_ACTIVITY

BAL_INSTANCE

NUMBER

EagleML/warehouseTransaction/custodyRestrictionActivity/balanceInstance

instance

Required

integer

 

HOLDINGDBO

CUSTODY_ACTIVITY

INSTANCE

NUMBER

EagleML/warehouseTransaction/custodyRestrictionActivity/instance

Pledge Detail Data Map Table

The pledge asset group is related via security alias elements HOLDINGDBO.CUSTODY_BALANCE.PL_SECURITY_ALIAS
and via Pledge reason account and accountId elements HOLDINGDBO.CUSTODY_BALANCE.PLEDGE_REASON_ACCT

Element

Optional/Required

Value Type

Star Tag

Eagle DB

DB Table

DB Field

Data Type

XPath

pledgeId

Optional

normalizedString

14

SECURITYDBO

SECURITY_MASTER

PRIMARY_ASSET_ID

CHAR(100)

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeId

pledgeName

Optional

normalizedString

961

SECURITYDBO

SECURITY_MASTER

ISSUE_NAME

VARCHAR2(255)

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeName

pledgeType

Optional

normalizedString

82

SECURITYDBO

SECURITY_MASTER

SECURITY_TYPE

CHAR(15)

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeType

pledgeAmount

Optional

decimal

1485

SECURITYDBO

SECURITY_MASTER_DETAIL

USER_GROUP_FLOAT1

NUMBER

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeAmount

marginTolerance

Optional

decimal

1487

SECURITYDBO

SECURITY_MASTER_DETAIL

USER_GROUP_FLOAT3

NUMBER

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/marginTolerance

pledgeDate

Optional

date

1495

SECURITYDBO

SECURITY_MASTER_DETAIL

USER_GROUP_DATE1

DATE(7)

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeDate

releaseDate

Optional

date

1496

SECURITYDBO

SECURITY_MASTER_DETAIL

USER_GROUP_DATE2

DATE(7)

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/releaseDate

counterParty

Optional

normalizedString

1413

not stored in DB

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/counterParty

notes

Optional

string

962

SECURITYDBO

SECURITY_MASTER

ISSUE_DESC

CHAR(15)

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/notes

pledgeSecurityAlias

Optional

integer

14

SECURITYDBO

SECURITY_MASTER

SECURITY_ALIAS

NUMBER

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/pledgeSecurityAlias

accountId

Optional

AccountId

 

RULESDBO

CUST_CHART

CUST_ACCOUNT

CHAR(55)

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/accountId

accountName

Optional

accountName

 

RULESDBO

CUST_CHART

CUST_ACCOUNT_DESC

VARCHAR2(100)

EagleML/warehouseTransaction/custodyRestrictionActivity/pledgeDetail/accountName

Â