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