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

Version 5 Next »

 

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

pledgeDetail Data Map

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