Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Current »


ElementOptional/RequiredValue TypeStar TagEagle DBDB TableDB FieldData TypeXPath
objectTypeOptionalobjectType
not stored in DBEagleML/warehouseTransaction/custodyRestrictionBalance/objectType
objectIdOptionalobjectId
not stored in DBEagleML/warehouseTransaction/custodyRestrictionBalance/objectId
objectDescriptionOptionalobjectDescription
not stored in DBEagleML/warehouseTransaction/custodyRestrictionBalance/objectDescription
updateTimestampOptionaldateTime
HOLDINGDBOCUSTODY_BALANCEUPDATE_DATEDATE(7)EagleML/warehouseTransactioncustodyRestrictionBalance/updateTimestamp
customElementsNot recommendedCustomElements
reserved for customizationsEagleML/warehouseTransaction/custodyRestrictionBalance/customElements
sourceNameOptionalstring1102PACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)EagleML/warehouseTransaction/custodyRestrictionBalance/sourceName
updateSourceOptionalstring
HOLDINGDBOCUSTODY_BALANCEUPDATE_SOURCEVARCHAR2(50)EagleML/warehouseTransaction/custodyRestrictionBalance/updateSource
batchCollectErrorsFlagOptionalYesNoOptionEnum
not stored in DBEagleML/warehouseTransaction/custodyRestrictionBalance/batchCollectErrorsFlag
singleRowCommitFlagOptionalYesNoOptionEnum
not stored in DBEagleML/warehouseTransaction/custodyRestrictionBalance/singleRowCommitFlag
Entity Common Id ModelEagleML/warehouseTransaction/custodyRestrictionBalance/
Entity Properties Model (extract only)EagleML/warehouseTransaction/custodyRestrictionBalance/
Asset Identifiers ModelEagleML/warehouseTransaction/custodyRestrictionBalance/
Extended Asset Properties Model (extract only)EagleML/warehouseTransaction/custodyRestrictionBalance/
maturityDateOptionaldate
not stored in DBEagleML/warehouseTransaction/custodyRestrictionBalance/maturityDate
pledgeDetailRequiredPledgeDetail - Complex type (see extra table below)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/
accountingBasisRequirednormalizedString
HOLDINGDBOCUSTODY_BALANCEACCT_BASISVARCHAR2(5)EagleML/warehouseTransaction/custodyRestrictionBalance/accountingBasis
longShortIndicatorRequirednormalizedString
HOLDINGDBOCUSTODY_BALANCELONG_SHORT_INDCHAR(2)EagleML/warehouseTransaction/custodyRestrictionBalance/longShortIndicator
quantityRequireddecimal
HOLDINGDBOCUSTODY_BALANCEUNITSNUMBER(28,12)EagleML/warehouseTransaction/custodyRestrictionBalance/quantity
custodyBankOptionalEntityBankRelationshipModel - Complex type (see extra table below)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/
batchEventIdOptionalstring
HOLDINGDBOCUSTODY_BALANCEBATCH_EVENT_IDVARCHAR2(55)EagleML/warehouseTransaction/custodyRestrictionBalance/batchEventId
instanceRequiredinteger
HOLDINGDBOCUSTODY_BALANCEINSTANCENUMBEREagleML/warehouseTransaction/custodyRestrictionBalance/instance

Pledge Detail Data Map

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

pledgeIdOptionalnormalizedString14SECURITYDBOSECURITY_MASTERPRIMARY_ASSET_IDCHAR(100)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeId
pledgeNameOptionalnormalizedString961SECURITYDBOSECURITY_MASTERISSUE_NAMEVARCHAR2(255)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeName
pledgeTypeOptionalnormalizedString82SECURITYDBOSECURITY_MASTERSECURITY_TYPECHAR(15)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeType
pledgeAmountOptionaldecimal1485SECURITYDBOSECURITY_MASTER_DETAILUSER_GROUP_FLOAT1NUMBER(28,12)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeAmount
marginToleranceOptionaldecimal1487SECURITYDBOSECURITY_MASTER_DETAILUSER_GROUP_FLOAT3NUMBER(28,12)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/marginTolerance
pledgeDateOptionaldate1495SECURITYDBOSECURITY_MASTER_DETAILUSER_GROUP_DATE1DATE(7)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeDate
releaseDateOptionaldate1496SECURITYDBOSECURITY_MASTER_DETAILUSER_GROUP_DATE2DATE(7)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/releaseDate
counterPartyOptionalnormalizedString1413not stored in DBEagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/counterParty
notesOptionalstring962SECURITYDBOSECURITY_MASTERISSUE_DESCCHAR(15)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/notes
pledgeSecurityAliasOptionalinteger14SECURITYDBOSECURITY_MASTERSECURITY_ALIASCHAR(100)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/pledgeSecurityAlias
accountIdOptionalAccountId
RULESDBOCUST_CHARTCUST_ACCOUNTCHAR(55)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/accountId
accountNameOptionalaccountName
RULESDBOCUST_CHARTCUST_ACCOUNT_DESCVARCHAR2(100)EagleML/warehouseTransaction/custodyRestrictionBalance/pledgeDetail/accountName

EntityBankRelationshipModel Data Map

The custody bank group is related via HOLDINGDBO.CUSTODY_BALANCE.ENTITY_CUSTODY_ALIAS and CUST_BANK_ALIAS fields
bankAccountStatusRequiredstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPSTATUSVARCHAR2(10)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/bankAccountStatus
custodyBankAccountNameOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPCUSTODY_BANK_ACCOUNT_NAMEVARCHAR2(50)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankAccountName
custodyBankAccountNumberOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPCUSTODY_BANK_ACCT_NUMVARCHAR2(30)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankAccountNumber
custodyBankCodeOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPCUSTODY_BANK_CODECHAR(20)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankCode
custodyBankDescOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPCUSTODY_BANK_DESCCHAR(50)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankDesc
custodyBankSubAcctOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPCUSTODY_BANK_SUB_ACCTVARCHAR2(30)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankSubAcct
custodyBankSubAccountTypeRequiredstring
not stored in DBEagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/custodyBankSubAccountType
dtcBankIdOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPDTC_BANK_IDVARCHAR2(30)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/dtcBankId
entityBankAliasOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPENTITY_BANK_ALIASVARCHAR2(25)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/entityBankAlias
interestedPartyIdOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPINTERESTED_PARTY_IDVARCHAR2(30)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/interestedPartyId
interestedPartyAcctOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPINTERESTED_PARTY_ACCTVARCHAR2(30)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/interestedPartyAcct
interestedPartyId2Optinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPINTERESTED_PARTY_ID2VARCHAR2(30)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/interestedPartyId2
interestedPartyAcct2Optinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPINTERESTED_PARTY_ACCT2VARCHAR2(30)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/interestedPartyAcct2
originalCustodyBankCodeOptinalstring
not stored in DBEagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/originalCustodyBankCode
originalCustodyBankStatusOptinalstring
not stored in DBEagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/originalCustodyBankStatus
primaryContactOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPPRIMARY_CONTACTVARCHAR2(50)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/primaryContact
phoneOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPPHONEVARCHAR2(20)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/phone
faxOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPFAXVARCHAR2(20)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/fax
settlementMethodOptinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPSETTLEMENT_METHODVARCHAR2(30)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/settlementMethod
userDate1Optinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPUSER_DATE1DATEEagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userDate1
userDate2Optinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPUSER_DATE2DATEEagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userDate2
userField1Optinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPUSER_FIELD1VARCHAR2(10)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userField1
userField2Optinalstring
RULESDBOENTITY_CUSTODY_RELATIONSHIPUSER_FIELD2VARCHAR2(10)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userField2
userFloat1Optinaldecimal
RULESDBOENTITY_CUSTODY_RELATIONSHIPUSER_FLOAT1NUMBER(28,12)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userFloat1
userFloat2Optinaldecimal
RULESDBOENTITY_CUSTODY_RELATIONSHIPUSER_FLOAT2NUMBER(28,12)EagleML/warehouseTransaction/custodyRestrictionBalance/custodyBank/userFloat2
  • No labels