Type Mandates
Type category Entity
Description The Mandates table contains data for MMD mandates.
Timeseries key id, mandateDateavailable from 2001-01-01
Fields
Name Type Filters Description
key id string(500)* = The id field uniquely identifies the entity record.
timeline mandateDate date* =< >= Date of Mandate.
assetType string(120) Asset Type of the Mandate.
assetTypeCollective string(6) Retrieving data. Wait a few seconds and try to cut or copy again.
assetTypeCollectiveText string(100) Collective allocation of the mandate.
assetTypeOther string(50) Additional investment allocation type.
assetTypeRegion string(6) Region allocation code of the Mandate.
assetTypeRegionText string(100) Region allocation of the mandate.
assetTypeStyle string(6) Style allocation code of the Mandate.
assetTypeStyleText string(80) Style allocation of the Mandate.
assetTypeType string(6) Type allocation code of mandate.
assetTypeTypeText string(80) Type allocation of the mandate.
attributeSlant string(50) Attribute tied to specific mandate.
link batch Batch = The batch that provided the data
link batchRun BatchRun = The batchRun that provided the data
benchmarks string(500) Benchmarks tied to specific mandate.
link company Company MMD Company id, foreign key that links to the Company entity.
consultantCompanyId long Consultant Entity relationship with mandate.
consultantContactEmail string(120) Email of consultant related to mandate.
consultantContactId long MMD contact id of Consultant related to mandate.
consultantName string(150) Consultant Name.
currencyCode string(3) Currency short name.
currentDescription string(4000) Current description of the mandate.
finalistInterviewDate date Date the Finalists are interviewed for the mandate.
mandateId long Mandate Unique ID.
planContact string(500) Contact Name for the individual related to the pension fund within mandate.
planContactEmail string(120) Email of contact related to pension fund within mandate.
planContactId long Contact ID for the individual related to the pension fund within mandate.
rfpDueDate date Date the Request For Proposal is due for the mandate.
rfpLink string(400) Link to Request For Proposal Web Page of mandate.
serviceType string(50) Type of Service the Investor is seeking.
serviceTypeSeqNo long Sequence Number of the service type.
size long Size of mandate (USD).
sizeLoc long Size of mandate in local currency.
startDate date Date the mandate event begun.
status string(24) Search Status of the Mandate.
targetAwardDate date Target Award Date for the mandate.
updateDate dateTime Most recent update status of mandate.
38 rows of 38 total
API Open API Specification