Help Exporting Correct Results from a T-SQL Script

Question

Post reply

Help Exporting Correct Results from a T-SQL Script

carlton 84646

Ten Centuries

Points: 1026

July 20, 2022 at 11:17 am

#4065875

Hi Community,

This question is pretty much a continuation of a previous question on help with a script. However, as I am often accused of not providing sufficient information I thougth I would submit this question but with sufficient detail to help find a solution.

I have a script that runs against the following tables:

GlobalOptionsetMetadata
account

After the script executes a view is created - a view called account.

The view contains the same fields as the original 'account' table but the values a replaced with some of the values in the GlobalOptionsetMetadata.

The fields in question are ts_easeofworking, and ts_companytype.

The script works perfectly fine on field ts_easeofworking, but fails on ts_companytype.

I have spoken to the authors of the script and they have informed me that the scripts need to be tweaked to work on field ts_companytype because that field contains what is called a multi-value field. This means the values in that field contain multi-values by virtue of it looks like the following 717750007;717750012

Whereas field ts_easeofworking just contains single values such as 717750007

I have attached a table showing the incorrect values in field ts_companytype, in column b, and the values I would like to see from the script in Column C - called ts_companytype_expected.

I have attached the table 'GlobalOptionsetMetadata' and the table called 'account' that the script runs against, which when run successfully produces a view called 'account' with the fields ts_easeofworking and ts_company.

To explain again the tables uploaded.

The table GlobalOtpionsetMeta is the table the script searches for comparisons with table account.

The table account_results is just the table that I am providing to show you that Column B should look like Column C

I hope I have done better at explaining myself.

--=================================================================================================
-- DESCRIPTION
--=================================================================================================
--  The purpose of this script is to create a set of database views in a database within your Synapse Analytics Serverless SQL Pool that will 
--  translate numeric codes for Option Sets, Status and States into human-readable descriptions for tables exported using Synapse Link for Dataverse.
--  See the following article for background: https://docs.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-choice-labels
--
-- PREREQUISITES
-- 1. You have configured Synapse Link for Dataverse to export to a Synapse Analytics Workspace
-- 2. You have sufficient read access to the lake database created by Synapse Link for Dataverse
-- 3. You have created an additional database in which views with enriched entities will be created
-- 4. You have sufficient permissions to create database objects in your newly-created database
--
-- IMPORTANT: please execute this script in the context of the Lake Database corresponding to your Synapse Link for Dataverse!
USE [SynapseLinkForDataverseDBName] --Specify the name of the database corresponding to your Synapse Link for Dataverse

--=================================================================================================
--PROVIDE INPUT PARAMETERS:
--=================================================================================================
DECLARE
@EnrichedViewDatabase sysname, --Specify the name of the database in which views with enriched entities will be created
@EnrichedViewSchema sysname, --Specify the name of the database schema in which views with enriched entities will be created
@EnrichedColumnSuffix varchar(50), --Specify the suffix for columns enriched with human-readable descriptions. For example, the suffix of "label" will change a statecode column in the base table to a statelabel column in the enriched view.
@LanguageCode varchar(10), --Specify the language code for localized labels. For example, English - United States is 1033 (https://docs.microsoft.com/en-us/openspecs/office_standards/ms-oe376/6c085406-a698-4e12-9d4d-c3b0ee3dbc4a)
@BaseTableSuffix varchar(50), --If applicable, specify the suffix in the names of the base tables or views (e.g., '_partitiond'). The default is an empty string.
@PreviewOnly bit --Indicate whether to preview the SQL Script (without creating the views) = 1 ; Create views = 0;

SET @EnrichedViewDatabase = 'MyEnrichedDatabase'
SET @EnrichedViewSchema = 'dbo'
SET @EnrichedColumnSuffix = 'label'
SET @LanguageCode = 1033
SET @BaseTableSuffix = ''
SET @PreviewOnly = 1 

--=================================================================================================
-- Do not edit the script below this point
--=================================================================================================

--Get column metadata from the Lake Database managed by Synapse Link for Dataverse
--The column metadata will be stored as a JSON document in a scalar variable
--This is needed as a workaround for the limitation of not allowing system objects to be used in distributed queries
DECLARE @ColumnMetadata nvarchar(MAX), @ColumnMetadataSQL nvarchar(MAX)

--Define the SQL statement to retrieve column metadata from the Lake Database managed by Synapse Link for Dataverse
--Results will be stored as a JSON document in a variable
SET @ColumnMetadataSQL = 'SET @ColumnMetadataOUT = (
SELECT TABLE_SCHEMA, 
TABLE_NAME, 
COLUMN_NAME, 
ORDINAL_POSITION, 
DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_SCHEMA = ''dbo''
AND TABLE_NAME NOT IN (''OptionsetMetadata'', ''GlobalOptionsetMetadata'',''StateMetadata'',''StatusMetadata'', ''TargetMetadata'')
AND TABLE_NAME LIKE ''%' + @BaseTableSuffix + '''
FOR JSON AUTO)'
DECLARE @ParmDefinition NVARCHAR(MAX);  
SET @ParmDefinition = N'@ColumnMetadataOUT NVARCHAR(MAX) OUTPUT';  
EXECUTE sp_executesql @ColumnMetadataSQL, @ParmDefinition, @ColumnMetadataOUT=@ColumnMetadata OUTPUT;  

--Declare a variable to store a SQL statement for creating enriched views
DECLARE @SQL nvarchar(MAX) = ''

; WITH CM AS (
--Parse column metadata variable and construct a table based on its content
SELECT JSON_VALUE(CM.value, '$.TABLE_SCHEMA') AS TableSchema,
 JSON_VALUE(CM.value, '$.TABLE_NAME') AS TableName,
 LEFT(JSON_VALUE(CM.value, '$.TABLE_NAME'), LEN(JSON_VALUE(CM.value, '$.TABLE_NAME'))-LEN(@BaseTableSuffix)) AS EntityName,
 JSON_VALUE(CM.value, '$.COLUMN_NAME') AS ColumnName,
 CAST(JSON_VALUE(CM.value, '$.ORDINAL_POSITION') AS INT) AS OrdinalPosition,
 JSON_VALUE(CM.value, '$.DATA_TYPE') AS DataType
FROM OPENJSON (@ColumnMetadata) AS CM
)

, OSM AS (
--Get Option Set Metadata
SELECT DISTINCT 
EntityName, 
OptionSetName, 
QUOTENAME(EntityName + '_' + OptionSetName) AS Alias
FROM dbo.[OptionsetMetadata]
WHERE LocalizedLabelLanguageCode = @LanguageCode
)

, GOSM AS (
--Get Global Option Set Metadata
SELECT DISTINCT 
OptionSetName, 
QUOTENAME('Global_' + OptionSetName) AS Alias
FROM dbo.[GlobalOptionsetMetadata]
WHERE LocalizedLabelLanguageCode = @LanguageCode
)

, StateM AS (
--Get State Metadata
SELECT DISTINCT 
EntityName, 
QUOTENAME(EntityName + '_State') AS Alias
FROM dbo.[StateMetadata]
WHERE LocalizedLabelLanguageCode = @LanguageCode
)

, StatusM AS (
--Get Status Metadata
SELECT DISTINCT 
EntityName,
QUOTENAME(EntityName + '_Status') AS Alias
FROM dbo.[StatusMetadata]
WHERE LocalizedLabelLanguageCode = @LanguageCode
)

, SQLStatement AS (
--Enumerate all lines in the source table and replace codes with labels where applicable
SELECT CM.EntityName,
--Before the first column of each table, construct a CREATE OR ALTER VIEW statement
CASE WHEN CM.OrdinalPosition = 1
THEN 'CREATE OR ALTER VIEW ' + QUOTENAME(@EnrichedViewSchema) + '.' + CM.EntityName + '
AS
SELECT '
ELSE ','
END
--For each column, check if it needs to be replaced with a suitable localized label
+ CASE 
WHEN OSM.OptionSetName IS NOT NULL THEN OSM.Alias + '.[LocalizedLabel] AS ' + REPLACE(QUOTENAME(CM.ColumnName), 'code]', @EnrichedColumnSuffix + ']')
WHEN GOSM.OptionSetName IS NOT NULL THEN GOSM.Alias + '.[LocalizedLabel] AS ' + REPLACE(QUOTENAME(CM.ColumnName), 'code]', @EnrichedColumnSuffix + ']')
WHEN StateM.EntityName IS NOT NULL THEN StateM.Alias + '.[LocalizedLabel] AS ' + REPLACE(QUOTENAME(CM.ColumnName), 'code]', @EnrichedColumnSuffix + ']')
WHEN StatusM.EntityName IS NOT NULL THEN StatusM.Alias + '.[LocalizedLabel] AS ' + REPLACE(QUOTENAME(CM.ColumnName), 'code]', @EnrichedColumnSuffix + ']')
ELSE '[Base].' + QUOTENAME(CM.ColumnName)
END AS [SQLLine],
CM.OrdinalPosition
FROM CM 
LEFT JOIN OSM
ON CM.EntityName = OSM.EntityName
AND CM.ColumnName = OSM.OptionSetName
AND CM.DataType LIKE '%int' --Only include columns with integer data type
LEFT JOIN GOSM
ON CM.ColumnName = GOSM.OptionSetName
AND CM.DataType LIKE '%int' --Only include columns with integer data type
LEFT JOIN StateM
ON CM.EntityName = StateM.EntityName
AND CM.ColumnName = 'statecode'
AND CM.DataType LIKE '%int' --Only include columns with integer data type
LEFT JOIN StatusM
ON CM.EntityName = StatusM.EntityName
AND CM.ColumnName = 'statuscode'
AND CM.DataType LIKE '%int' --Only include columns with integer data type

UNION ALL
--Construct the first line of the FROM clause, referencing external tables created by Synapse Link for Dataverse
SELECT DISTINCT
CM.EntityName,
'FROM ' + QUOTENAME(DB_NAME()) + '.' + QUOTENAME(CM.TableSchema) + '.' + QUOTENAME(CM.TableName) + ' AS Base' AS SQLLine,
10000 AS OrdinalPosition
FROM CM

UNION ALL 
--Construct LEFT JOIN statements for each relevant OptionSetMetadata field
SELECT DISTINCT OSM.EntityName AS EntityName,
'LEFT JOIN ' + QUOTENAME(DB_NAME()) + '.[dbo].[OptionSetMetadata] AS ' + OSM.Alias + ' 
ON ' + OSM.Alias + '.EntityName = ''' + OSM.EntityName + ''' 
AND ' + OSM.Alias + '.OptionSetName = ''' +  OSM.OptionSetName + '''
AND [Base].' + QUOTENAME(OSM.OptionSetName) + ' = ' + OSM.Alias + '.[Option]
AND ' + OSM.Alias + '.LocalizedLabelLanguageCode = ' + @LanguageCode + '' AS SQLLine,
20000 AS OrdinalPosition
FROM OSM
JOIN CM
ON CM.EntityName = OSM.EntityName
AND CM.ColumnName = OSM.OptionSetName
WHERE CM.DataType LIKE '%int' --Only capture columns with Integer Data Types

UNION ALL 
--Construct LEFT JOIN statements for each relevant GlobalOptionSetMetadata field
SELECT DISTINCT CM.EntityName AS EntityName,
'LEFT JOIN ' + QUOTENAME(DB_NAME()) + '.[dbo].[GlobalOptionSetMetadata] AS ' + Alias + ' 
ON ' + Alias + '.OptionSetName = ''' +  OptionSetName + '''
AND [Base].' + QUOTENAME(OptionSetName) + ' = ' + Alias + '.[Option]
AND ' + Alias + '.LocalizedLabelLanguageCode = ' + @LanguageCode + '' AS SQLLine,
30000 AS OrdinalPosition
FROM GOSM
JOIN CM
ON CM.ColumnName = GOSM.OptionSetName
WHERE CM.DataType LIKE '%int' --Only capture columns with Integer Data Types

UNION ALL 
--Construct LEFT JOIN statements for each relevant State Metadata field
SELECT DISTINCT CM.EntityName AS EntityName,
'LEFT JOIN ' + QUOTENAME(DB_NAME()) + '.[dbo].[StateMetadata] AS ' + StateM.Alias + ' 
ON ' + StateM.Alias + '.EntityName = ''' + StateM.EntityName + ''' 
AND [Base].statecode' + ' = ' + StateM.Alias + '.[State]
AND ' + StateM.Alias + '.LocalizedLabelLanguageCode = ' + @LanguageCode + '' AS SQLLine,
40000 AS OrdinalPosition
FROM StateM
JOIN CM
ON CM.EntityName = StateM.EntityName
AND CM.ColumnName = 'statecode'
WHERE CM.DataType LIKE '%int' --Only capture columns with Integer Data Types

UNION ALL
--Construct LEFT JOIN statements for each relevant Status Metadata field
SELECT DISTINCT CM.EntityName AS EntityName,
'LEFT JOIN ' + QUOTENAME(DB_NAME()) + '.[dbo].[StatusMetadata] AS ' + StatusM.Alias + ' 
ON ' + StatusM.Alias + '.EntityName = ''' + StatusM.EntityName + ''' 
AND [Base].statuscode' + ' = ' + StatusM.Alias + '.[Status]
AND ' + StatusM.Alias + '.LocalizedLabelLanguageCode = ' + @LanguageCode + '' AS SQLLine,
40000 AS OrdinalPosition
FROM StatusM
JOIN CM
ON CM.EntityName = StatusM.EntityName
AND CM.ColumnName = 'statuscode'
WHERE CM.DataType LIKE '%int' --Only capture columns with Integer Data Types

UNION ALL
--Add statement terminator
SELECT DISTINCT
EntityName,
'; ' + CHAR(10) AS SQLLine,
100000 AS OrdinalPosition
FROM CM
)

--Construct individual statements to create views (1 view per row)
--Since CREATE VIEW statement must be the first statement in a batch, assign each view definition to a variable 
--and use the EXEC(@variable) command to create view as part of its own, separate batch.
, ViewDefinitions AS (
SELECT 'DECLARE @' + EntityName + ' NVARCHAR(MAX) = ''
' + REPLACE(STRING_AGG(CAST(SQLLine as varchar(MAX)), CHAR(10)) WITHIN GROUP (ORDER BY EntityName, OrdinalPosition, SQLLine), '''', '''''') + ''' ' + CHAR(10) + 'EXEC [' + @EnrichedViewDatabase + '].dbo.sp_executesql @' + EntityName + CHAR(10) AS ViewDefinition
FROM SQLStatement
GROUP BY EntityName
)

--Construct a comprehensive SQL statement to create all views
SELECT @SQL = STRING_AGG(ViewDefinition, ';' + CHAR(10) + CHAR(10))
FROM ViewDefinitions

--Return a preview of the SQL Script to be generated or go ahead and create the views.
IF @PreviewOnly = 1
BEGIN
--Return the final SQL statement
SELECT '--================================================================================================='+ CHAR(10) +' ' + CHAR(10) AS [--SQL Statement]
UNION ALL 
SELECT '-- A preview of the script to generate enriched views is provided below.'  AS [--SQL Statement]
UNION ALL 
SELECT '-- No database objects have been created.' AS [--SQL Statement]
UNION ALL 
SELECT '-- Re-run this script with the @PreviewOnly parameter set to 0 to actually create the views.' AS [--SQL Statement]
UNION ALL 
SELECT '--================================================================================================='+ CHAR(10) +' ' + CHAR(10) AS [--SQL Statement]
UNION ALL 
SELECT VALUE AS [--SQL Statement] FROM STRING_SPLIT(@SQL, CHAR(10))
END
ELSE
BEGIN
--Execute the SQL statement
PRINT 'Beginning view creation'
EXEC sp_executesql @SQL
PRINT 'Completed view creation'
END

account.txt table

ts_easeofworking,ts_companytype
,717750007
,717750007
,717750007
,717750007
,717750001
,717750001
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,
,
,
,717750001
,717750001
,
,
,
,717750001
,717750001
,717750001
,717750001
,
,
,717750001
,717750001
,717750001
,
,717750001
,
,
,
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,717750007;717750012
,717750013
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,
,717750001
,717750001;717750005
,717750001
,
,
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,
,717750001
,717750001
,
,
,
,
,
,
,717750001
,717750001
,
,
,
,
,717750000
,
,
,717750001
,717750001
,717750001
,717750001
,717750000;717750001
,717750016
,717750001
,717750001
,
,
,
,
,717750001;717750003
,
,717750000
,717750001
,717750001
,
,
,717750001
,717750001
,
,717750001
,
,
,
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750009
,
,717750001
,
,717750001
,
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
717750000,717750007;717750012
,717750001
,717750007
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,
,717750007
,717750001
,
,717750013
,
,
,717750013
,
,717750003
,717750001
,717750000
,
,
,
,
,
,717750001
,717750000;717750005
,717750001
,717750001
,
,
,717750000
,
,
,
,717750001
,717750001
,717750001
,
,717750001
,
,
,
,
,
,
,
,
,
,
,
,717750007
,717750000;717750005
,717750007
,717750007
,717750007
,717750013
,717750005
,717750007
,717750007
,717750007
,717750002
,717750001
,717750001
,717750000
,717750001
,717750001
,717750013
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007;717750013
,717750001
,717750001
,717750001
,717750001
,717750000;717750002;717750010
,717750002
,717750001
,717750001
,717750001;717750002
,717750001;717750002
,717750001;717750002
,717750001
,717750001
,717750004
,717750002
,717750001;717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750013
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001;717750002;717750013
,717750001
,717750000
,717750000
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750003
,717750001
,717750001
,717750001
,717750000;717750001
,717750001
,717750001
,717750003
,717750002
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750003
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750000
,717750001
,717750003
,717750000
,717750001
,717750001
,717750001
,717750002
,717750013
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750002
,717750016
,717750001
,717750005
,717750001
,717750001
,717750001
,717750000;717750010
,717750000;717750010
,717750000;717750001
,717750000;717750010
,717750000;717750010
,717750000;717750010
,717750000;717750010
,717750000;717750002;717750010
,717750000;717750010
,717750000;717750010
,717750000;717750010
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750000
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750005
,717750016
,717750016
,717750000
,717750016
,717750001
,717750001
,717750000;717750005
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750000
,717750001
,717750001
,717750000;717750001
,717750001
,717750001
,717750000;717750001
,717750000;717750001
,717750013
,717750001
,717750004
,717750004
,717750007
,717750009
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750012
,717750001
,717750001
,717750001
,717750016
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750013
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750007;717750012
,717750001
,717750001
,717750001
,717750003
,717750003
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750004
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750005
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750000
,717750001
,717750000;717750003;717750010
,717750000;717750003
,717750001
,717750000;717750003;717750010
,717750001
,717750001
,717750003;717750004
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750012
,717750007
,717750007
,717750012
,717750007
,717750001
,717750009
,717750013
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750012
,717750001
,717750009
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007;717750012
,717750007;717750012
,717750012
,717750007
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750016
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750002
,717750007;717750014
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750001
,717750007
,717750007
,717750007
,717750001
,717750001
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750002
,717750007
,717750001
,717750007
,717750007
,717750007
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001;717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001
,717750001
,717750001
,717750001;717750008
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750016
,717750001
,717750002
,717750001
,717750008
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750003
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007;717750015
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750001
,717750007
,717750007;717750012
,717750001
,717750001
,717750001
,717750016
,717750001
,717750005
,717750001
,717750001
,717750001
,717750001
,930580000
,717750016
,717750004;717750009
,930580000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750000
,717750001
,930580000
,717750001
,717750001
,717750000
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750009
,717750001
,717750016
,717750013
,717750001
,717750001
,717750016
,717750001
,717750016
,717750001
,717750001
,717750001;717750005
,717750001
,717750001
,717750000
,717750016
,930580000
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750003;717750010
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,930580000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005;930580000
,717750001
,717750005
,717750005
,717750001
,717750005
,717750002
,717750005
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750005
,717750001
,717750001
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750001
,717750005
,717750005
,717750001
,717750005
,717750005
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750016
,717750016
,717750001
,717750005
,717750005
,717750001
,717750001
,717750016
,717750016
,717750001
,717750005
,717750005
,717750005
,717750005
,717750005
,717750002
,717750001
,717750001
,717750005
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750005
,717750016
,717750016
,717750001
,717750001
,717750016
,717750001
,717750005
,717750005
,717750005
,717750016
,717750016
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750010
,717750016
,717750005
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750013
,717750000
,717750000
,717750002
,717750001
,717750007
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750001
,717750001
,717750005
,717750009
,717750001
,717750005
,717750005
,717750001
,717750005
,717750005
,717750005
,717750005
,717750001
,717750005
,717750005
,717750002
,717750016
,717750016
,717750005
,717750005
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750005
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750001
,717750013
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750011
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750003
,717750001
,717750000
,717750001
,717750007
,717750001
,717750010
,717750003
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001
,717750010
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750001
,717750001
,717750002
,717750000;717750003
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,930580000
,717750016
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750007
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750005
,717750005
,717750016
,717750016
,717750016
,717750001
,717750001
,717750016
,717750001
,717750001
,717750016
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750013
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750001
,717750016
,717750013
,717750016
,717750001
,717750001
,717750001
,717750002;717750003
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750010
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750001
,717750001
,717750000
,717750016
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750005;930580000
,717750016
,717750016
,717750001
,717750001
,930580000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001
,717750016
,717750016
,717750001
,717750001
,717750006
,717750001
,717750001
,717750001
,717750001
,717750005;930580000
,717750007
,717750007
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750001;717750002
,717750001
,717750001
,717750007
,717750007
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750007
,717750001
,717750002
,717750000
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750007
,717750002
,717750001
,717750001
,717750001;717750002
,717750001
,717750002
,717750016
,717750001
,717750001
,717750001
,717750007
,717750007
,717750007
,717750001
,717750007
,717750016
,717750000
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750007
,717750001
,717750002
,717750001
,717750007
,717750007
,717750007
,717750001
,717750001
,717750000
,717750016
,717750001
,717750001
,930580000
,717750000
,717750001
,717750001
,717750001;717750002
,717750001
,717750001
,717750004
,717750004
,717750004
,717750004
,717750004
,717750004
,717750004
,717750004
,717750004
,717750007
,717750004
,717750002
,717750002
,717750007
,717750007;717750012
,
,
,
,
,717750001;717750002
,
,
,
,
,
,717750001
,
,
,
,
,
,
,
,
,717750007
,
,717750007
,
,717750007
,
,717750007
,717750007
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,717750000
,
,
,717750001
,
,
,
,
,
,
,717750007
,
,
,
,
,
,
,
,
,
,
,
,717750007
,
,
,
,
,
,
,
,
,
,
,
,717750001
,
,
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,
,
,
,717750004
,
,
,
,
,
,
,
,
,
,
,717750001
,
,
,
,
,
,
,717750001
,
,717750001
,
,
,
,
,
,
,
,
,717750007
,
,
,
,
,717750001
,
,
,
,
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750008
,717750001
,717750001
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,
,717750001
,
,717750001
,
,717750001
,
,
,717750001
,717750001
,717750001
,717750000
,
,
,
,717750001
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,717750001
,
,717750001
,717750001
,717750001
,717750001
,
,
,717750005
,717750001
,
,
,
,
,717750001
,
,717750001
,717750001
,
,
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,717750001
,
,717750001
,717750001
,717750001
,
,717750001
,717750001
,
,717750001
,717750001
,717750001
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,
,717750000
,717750001
,717750001
,717750001
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000;717750010
,717750001
,717750001
,717750001
,717750000;717750001;717750002
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,
,
,717750004
,
,
,
,
,
,717750004
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,
,
,
,717750001
,717750001
,717750001
,717750001
,717750011
,717750013
,717750001
,717750001
,717750001
,717750001
,717750001
,717750013
,717750013
,717750001
,717750000;717750005;717750010
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750004
,717750004
,717750004
,717750007
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750016
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750000
,717750000
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000;717750010
,717750000;717750010
,717750001
,717750001
,717750003;717750010
,717750016
,717750001
,717750003
,717750001
,717750001
,717750003
,717750001
,717750001
,717750013
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750006;717750011
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001;717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750009
,717750001
,717750001
,717750001
,717750010
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750004
,717750004
,717750004
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750000;717750010
,717750001
,717750001
,717750000
,717750005
,717750004
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750008
,717750004
,717750004
,717750004
,717750004
,717750001
,717750003
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750000;717750010
,717750001
,717750005;930580000
,717750001
,717750007
,717750001
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000;717750002
,717750013
,717750000
,717750000
,717750000
,717750007
,717750001
,717750001;717750002
,717750013
,717750001
,717750001
,717750000
,717750001
,717750001
,717750007
,717750001
,717750001
,717750000
,717750002
,717750001
,717750003
,717750001
,717750004
,717750004;717750010
,717750004
,717750001
,717750007
,717750001
,717750002;717750004
,717750004
,717750002;717750003;717750010
,717750005
,717750000
,717750001
,717750000
,717750001
,717750001
,717750000
,717750001
,717750000;717750010
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750009
,717750001
,717750001
,717750001
,930580000
,717750000
,717750009
,717750000
,717750001
,717750001
,717750007
,717750001
,930580000
,717750001
,717750001
,717750007
,717750010
,717750001
,717750001
,717750001
,717750001
,930580000
,717750000
,717750005
,717750004
,717750000
,717750000
,717750001
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750001
,717750001
,717750007
,717750007;717750012
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750009
,717750001
,717750003
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001;717750002
,717750001
,717750001
,717750002
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750005
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750007;717750015
,717750001
,717750009
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750013
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750010
,930580000
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750016
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750009;717750010
,717750016
,717750016
,717750010
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750009
,717750003
,717750001
,717750001
,717750002
,717750001
,717750001;717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750016
,717750016
,717750001
,717750001
,717750000
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750016
,717750016
,717750001
,717750016
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750000
,717750005
,717750016
,717750016
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750005
,717750005
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750001
,717750001
,717750001
,717750016
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,930580000
,717750000
,717750000
,717750000
,717750000
,717750000
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750016
,717750001
,717750001
,717750001
,717750016
,717750001
,717750016
,717750016
,717750016
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,930580000
,717750005
,930580000
,717750001;717750005
,717750016
,717750005
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750005
,717750005
,717750001
,717750016
,717750001
,717750005
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750003
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750016
,717750005
,717750001
,717750001
,717750016
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750001
,717750005
,717750005
,717750001
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750005
,717750005
,717750001
,717750005
,717750005
,717750001
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750001
,717750001
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750001
,717750001
,717750001
,717750001
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,930580000
,717750005
,717750005
,717750005
,717750016
,717750013
,717750001
,717750005
,717750005
,717750016
,717750016
,717750016
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750005
,717750001
,717750001
,717750001
,717750001
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750001
,717750001;717750002
,717750005
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750003;717750004
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750013
,717750013
,717750001
,717750016
,717750016
,717750016
,717750001
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001
,717750001
,717750001
,930580000
,717750001
,717750001
,717750001
,717750002
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750000;717750003
,717750001
,717750001
,717750001
,717750007
,717750016
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750007;717750013
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750001
,717750001
,717750016
,717750016
,717750016
,717750001
,717750016
,717750007
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750001
,717750005
,717750000
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750007
,717750016
,717750007
,717750016
,717750001
,717750001
,717750016
,930580000
,930580000
,717750001
,930580000
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750007
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750007
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750014
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750002
,717750001
,717750001
,717750013
,717750007
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750005
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750007
,717750016
,717750016
,717750016
,717750007
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750007
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750016
,717750002
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001
,717750001
,717750007
,717750016
,717750016
,717750001
,717750016
,717750002
,717750005
,717750005
,717750016
,717750005
,717750005
,717750016
,717750001
,717750014
,717750014
,717750001
,717750005
,717750005
,717750005
,717750005
,717750005
,717750001
,717750002
,717750007
,717750016
,717750016
,717750016
,717750005
,717750001
,717750001
,717750002
,717750002
,717750016
,717750001;717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750005
,717750005
,717750005
,717750005
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001
,717750016
,717750001
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750016
,717750001
,717750007
,717750001
,717750007
,717750016
,717750016
,717750007
,717750016
,717750016
,717750002
,717750001
,717750001
,717750001
,717750004
,717750003;717750004;717750005
,717750005
,717750005
,717750007;717750012
,717750013
,717750014
,717750001
,717750005
,717750001
,717750001
,717750005
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750005
,717750001
,717750001
,717750001
,717750002
,
,717750001
,717750001
,717750001
,717750001;717750002
,717750001;717750002;717750013
,717750007
,717750002;717750013
,717750002;717750013
,717750002;717750013
,717750001
,717750003
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750002;717750013
,717750002;717750013
,717750002;717750013
,717750002;717750013
,717750002;717750013
,717750002;717750013
,717750002;717750013
,717750002;717750013
,717750002;717750013
,717750001
,717750001
,717750000;717750005;717750010;717750014
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750004
,717750001
,717750013
,717750016
,717750001
,717750007
,717750009
,717750001
,717750001
,717750001
,717750009
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750009
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750007
,717750001
,717750001
,717750001
,717750004
,717750004
,717750004
,717750004
,717750004
,717750004
,717750004
,717750004
,717750000
,717750001
,717750001
,717750001
,717750001
,717750005
,717750004;717750005
,717750001
,717750005
,717750005
,717750005
,717750005
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750003
,717750003
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750011
,717750001
,717750001
,717750001
,717750001;717750002
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750003
,717750001
,717750001
,717750001
,717750001
,717750003
,717750002
,717750001
,717750004
,717750007
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750016
,717750001
,717750001
,717750011
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750001
,717750003
,717750016
,717750003;717750004
,717750001
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750010
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750014
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750002
,717750001
,930580000
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,930580000
,930580000
,717750013
,717750001
,717750001
,717750001
,930580000
,930580000
,930580000
,930580000
,717750001
,717750000
,717750001
,717750001
,717750007
,717750007
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000;717750010
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750000
,930580000
,930580000
,717750001
,717750001
,717750007
,717750007
,717750001
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750007
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750007
,717750001
,717750007
,930580000
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,930580000
,717750001
,717750005;930580000
,717750001;717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750000
,930580000
,717750005;930580000
,717750001
,717750001
,717750001
,717750001
,717750007
,717750007
,717750000
,717750001
,717750000
,717750007
,717750002;717750013
,717750001
,717750002
,717750001
,717750001
,717750002
,717750001
,717750001
,717750002
,717750007
,717750007
,717750007
,717750002
,717750007
,717750001
,717750002
,717750003
,717750010
,717750001
,717750002
,717750002
,717750004
,717750000
,717750001
,717750012
,717750004
,717750001
,717750001
,717750001
,717750001
,717750001
,717750011
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750001;717750002
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750007
,717750007
,717750007
,717750007
,717750001
,717750010
,717750001
,717750001
,930580000
,717750007
,930580000
,717750001
,930580000
,717750001
,717750001
,717750007
,717750007;717750012
,717750007;717750012
,717750007;717750012
,717750007;717750012
,717750001
,717750007
,717750007;717750012
,717750007;717750012
,717750007;717750012
,717750007;717750012
,717750001
,717750001
,717750010
,717750001
,717750001
,717750001
,930580000
,717750001
,717750001
,717750001
,717750001
,717750001
,930580000
,717750001
,717750001
,717750001
,717750000;717750010;717750011
,717750001
,930580000
,717750001
,717750004
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750007
,717750001
,717750001
,717750001
,717750000
,930580000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750002
,717750016
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750010
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750016
,717750001
,717750016
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750005
,717750001
,717750001
,717750001
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,930580000
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001
,717750001
,717750003
,717750001
,717750001;717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001;717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750016
,717750001
,717750001
,717750001
,717750001
,717750000
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750001;717750005
,717750001
,717750001
,717750016
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750005
,717750001;717750005
,717750001;717750005
,717750001;717750005
,717750001;717750005
,717750005
,717750005
,717750001
,717750000
,717750005
,717750005
,717750005
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750009
,717750001
,717750001
,717750005
,717750001
,717750001
,717750003
,717750016
,717750000
,717750001
,717750001
,717750001
,717750001
,717750016
,717750001
,717750016
,717750016
,717750001
,717750016
,717750013
,717750001
,717750007
,717750016
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750007
,717750016
,717750005
,717750005
,717750005
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000
,717750001
,717750001
,717750001
,717750000
,717750016
,717750005
,717750005
,717750001
,717750001;717750002
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750005
,717750001;717750015
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750000;717750002;717750013
,717750001
,717750001
,717750001
,717750001
,717750016
,717750016
,717750005
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750000
,717750001
,717750001
,717750001
,717750001
,717750005
,717750005
,717750005
,717750001
,717750016
,717750001
,930580000
,717750001
,930580000
,717750016
,717750016
,717750016
,717750016
,717750016
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750001
,717750007
,717750001
,717750001
,717750005
,717750005
,717750001
,717750005
,717750001
,930580000
,717750001
,717750001
,717750001
,717750005
,717750001
,717750001
,717750005
,717750005

GlobalOptionsetMetadata.txt table

OptionSetName,Option,IsUserLocalizedLabel,LocalizedLabelLanguageCode,LocalizedLabel,GlobalOptionSetName,EntityName
ts_easeofworking,717750000,False,1033,"1 - Open, transparent, responsive",,
ts_easeofworking,717750001,False,1033,"2 - Open, transparent, not responsive",,
ts_easeofworking,717750002,False,1033,3 - Open or transparent or responsive,,
ts_easeofworking,717750003,False,1033,4 - Concerns,,
ts_easeofworking,717750004,False,1033,5 - No track record,,
ts_address1addresstype,717750001,False,1033,Business,,
ts_address1addresstype,717750002,False,1033,Mailing,,
ts_address1addresstype,717750003,False,1033,Registered Office,,
ts_address1addresstype,717750004,False,1033,Tax,,
ts_address1addresstype,717750000,False,1033,US Tax Office,,
xpd_relationshipstatus,930580001,False,1033,Relationship,,
xpd_relationshipstatus,930580002,False,1033,Future Star,,
xpd_relationshipstatus,930580003,False,1033,Hard to Reach,,
xpd_relationshipstatus,930580000,False,1033,None,,
ts_relationship,717750000,False,1033,1 - Conviction,,
ts_relationship,717750001,False,1033,2 - Warming,,
ts_relationship,717750002,False,1033,3 - Lukewarm,,
ts_relationship,717750003,False,1033,4 - Concern,,
ts_relationship,717750004,False,1033,5 - None,,
xpd_remindermonths,930580000,False,1033,3 Months,,
xpd_remindermonths,930580001,False,1033,6 Months,,
xpd_remindermonths,930580002,False,1033,9 Months,,
xpd_remindermonths,930580003,False,1033,12 Months,,
ts_importance,717750000,False,1033,1 - Priority,,
ts_importance,717750001,False,1033,2 - Focus,,
ts_importance,717750002,False,1033,3 - Relationship,,
ts_importance,717750003,False,1033,4 - Unsure,,
ts_importance,717750004,False,1033,5 - Low,,
ts_irrvsmomperformancemeasure,717750002,False,1033,Blended,,
ts_irrvsmomperformancemeasure,717750000,False,1033,IRR,,
ts_irrvsmomperformancemeasure,717750001,False,1033,MoM,,
ts_irrvsmomperformancemeasure,717750003,False,1033,Unknown,,
ts_sizeoffirm,717750000,False,1033,One man band,,
ts_sizeoffirm,717750001,False,1033,<10 staff,,
ts_sizeoffirm,717750002,False,1033,10-50 staff,,
ts_sizeoffirm,717750003,False,1033,>50 staff,,
ts_interaction,717750000,False,1033,1 - Direct dialogue 2 or more times per year,,
ts_interaction,717750001,False,1033,2 - Periodic dialogue with occasional issues,,
ts_interaction,717750002,False,1033,3 - Unresponsive day to day but we have dialogue,,
ts_interaction,717750003,False,1033,4 - Historic dialogue,,
ts_interaction,717750004,False,1033,5 - None,,
xpd_previousinvestorstatus,717750000,False,1033,Current,,
xpd_previousinvestorstatus,717750001,False,1033,Potential,,
xpd_previousinvestorstatus,922460000,False,1033,Potential - Distribution List,,
ts_recommendationoffirm,717750000,False,1033,Preferred supplier,,
ts_recommendationoffirm,717750001,False,1033,Consider for future projects,,
ts_recommendationoffirm,717750002,False,1033,Not suitable for future projects,,
ts_recommendationoffirm,717750003,False,1033,Don't know,,
ts_investorstatus,717750000,False,1033,Current,,
ts_investorstatus,717750001,False,1033,Potential,,
ts_investorstatus,922460000,False,1033,Potential - Distribution List,,
ts_capabilitiesoffirm,717750000,False,1033,Genuine Experts / Specialists,,
ts_capabilitiesoffirm,717750001,False,1033,Generalists,,
mpe_flowlastrunoutcome,922460000,False,1033,Succeeded,,
mpe_flowlastrunoutcome,922460001,False,1033,Failed,,
mpe_flowlastrunoutcome,922460002,False,1033,Retrying,,
ts_nextoriginationmeetingarranged,717750000,False,1033,Arranged,,
ts_nextoriginationmeetingarranged,717750001,False,1033,Being Arranged,,
ts_investortype,717750010,False,1033,Bank,,
ts_investortype,717750009,False,1033,Corporate,,
ts_investortype,717750008,False,1033,Endowments & Foundations,,
ts_investortype,717750007,False,1033,Family Office,,
ts_investortype,717750005,False,1033,Fund of Funds,,
ts_investortype,717750004,False,1033,Insurance,,
ts_investortype,717750013,False,1033,Other,,
ts_investortype,717750003,False,1033,Pension Fund,,
ts_investortype,717750001,False,1033,Service Provider,,
ts_investortype,717750002,False,1033,Sovereign Wealth Fund,,
ts_investortype,717750000,False,1033,Wealth Manager,,
ts_investorregion,717750001,False,1033,Asia,,
ts_investorregion,717750003,False,1033,Europe,,
ts_investorregion,717750005,False,1033,Latin America,,
ts_investorregion,717750002,False,1033,Middle East,,
ts_investorregion,717750000,False,1033,North America,,
ts_investorregion,717750004,False,1033,Other,,
xpd_function,930580008,False,1033,Corporate Dev & M&A,,
xpd_function,930580001,False,1033,Finance,,
xpd_function,930580000,False,1033,General management,,
xpd_function,930580006,False,1033,HR,,
xpd_function,930580009,False,1033,Legal,,
xpd_function,930580007,False,1033,Marketing & Comms,,
xpd_function,930580010,False,1033,Medical,,
xpd_function,930580003,False,1033,Operations,,
xpd_function,930580005,False,1033,Product & Innovation,,
xpd_function,930580002,False,1033,Sales,,
xpd_function,930580012,False,1033,Supply Chain,,
xpd_function,930580004,False,1033,Tech & IT,,
ts_quickcaptureuses,100000000,False,1033,Commercial Excellence,,
ts_quickcaptureuses,100000001,False,1033,CORRGI,,
ts_quickcaptureuses,100000002,False,1033,Data,,
ts_quickcaptureuses,100000003,False,1033,Digital,,
ts_quickcaptureuses,100000004,False,1033,Execution,,
ts_quickcaptureuses,100000005,False,1033,Finance,,
ts_quickcaptureuses,100000006,False,1033,Financial & Tax,,
ts_quickcaptureuses,100000007,False,1033,IT & Technology,,
ts_quickcaptureuses,100000008,False,1033,LEAN,,
ts_quickcaptureuses,100000009,False,1033,Legal,,
ts_quickcaptureuses,100000010,False,1033,Operational Excellence,,
ts_quickcaptureuses,100000011,False,1033,People & Organisation,,
ts_quickcaptureuses,100000012,False,1033,Product Development Hardware,,
ts_quickcaptureuses,100000013,False,1033,Product Development Software,,
ts_quickcaptureuses,100000014,False,1033,Product Management,,
ts_quickcaptureuses,100000015,False,1033,Strategy,,
xpd_montagulevel,930580012,False,1033,Capital Markets,,
xpd_montagulevel,930580013,False,1033,Compliance,,
xpd_montagulevel,930580002,False,1033,EA,,
xpd_montagulevel,930580014,False,1033,Finance,,
xpd_montagulevel,930580015,False,1033,HQ,,
xpd_montagulevel,930580016,False,1033,Human Resources,,
xpd_montagulevel,930580017,False,1033,Insights,,
xpd_montagulevel,930580018,False,1033,Investment,,
xpd_montagulevel,930580019,False,1033,Investor Relations,,
xpd_montagulevel,930580009,False,1033,IT,,
xpd_montagulevel,930580020,False,1033,LTSA,,
xpd_montagulevel,930580021,False,1033,Lux Team,,
xpd_montagulevel,930580022,False,1033,MFPP,,
xpd_montagulevel,930580023,False,1033,Origination,,
xpd_montagulevel,930580024,False,1033,Portfolio,,
xpd_montagulevel,930580025,False,1033,Tax & Company Secretarial,,
xpd_montagulevel,930580026,False,1033,Transformation,,
ts_permanentinterim,717750000,False,1033,Permanent - Full Time,,
ts_permanentinterim,930580001,False,1033,Permanent - Part Time,,
ts_permanentinterim,717750001,False,1033,Interim,,
ts_permanentinterim,930580000,False,1033,External Consultant,,
ts_permanentinterim,930580002,False,1033,Research,,
ts_quickcapturesectors,717750000,False,1033,Energy & Utilities,,
ts_quickcapturesectors,717750001,False,1033,Industrials & Materials,,
ts_quickcapturesectors,717750002,False,1033,Commercial & Professional Services,,
ts_quickcapturesectors,717750003,False,1033,Transport & Logistics,,
ts_quickcapturesectors,717750004,False,1033,Consumer Goods & Services,,
ts_quickcapturesectors,717750005,False,1033,Health Care,,
ts_quickcapturesectors,717750006,False,1033,Financials,,
ts_quickcapturesectors,717750007,False,1033,Software / IT,,
ts_quickcapturesectors,717750008,False,1033,Telecoms & Media,,
ts_roletypes,717750003,False,1033,CEO,,
ts_roletypes,717750004,False,1033,CFO,,
ts_roletypes,930580002,False,1033,Chairman,,
ts_roletypes,930580003,False,1033,Non-Executive,,
ts_roletypes,922460000,False,1033,Pre Deal Advisor,,
ts_roletypes,930580001,False,1033,Other,,
ts_companytype,717750000,False,1033,Deal Introducer,,
ts_companytype,717750006,False,1033,Debt Advisory,,
ts_companytype,717750011,False,1033,Debt Provider,,
ts_companytype,717750003,False,1033,Diligence,,
ts_companytype,717750016,False,1033,Excluded,,
ts_companytype,717750012,False,1033,Gatekeeper,,
ts_companytype,930580000,False,1033,HR Recruiter,,
ts_companytype,717750007,False,1033,Investor Group,,
ts_companytype,717750015,False,1033,Investor Reporting,,
ts_companytype,717750010,False,1033,M&A Advisory,,
ts_companytype,717750009,False,1033,Montagu Supplier,,
ts_companytype,717750013,False,1033,PE Firm,,
ts_companytype,717750014,False,1033,Placement Agent,,
ts_companytype,717750008,False,1033,Portfolio Company,,
ts_companytype,717750004,False,1033,Portfolio Support,,
ts_companytype,717750005,False,1033,Talent Source,,
ts_companytype,717750001,False,1033,Target,,
ts_companytype,717750002,False,1033,Vendor,,
xpd_level,930580002,False,1033,Non-Executive,,
xpd_level,930580000,False,1033,C (Executive team),,
xpd_level,930580001,False,1033,C-1,,
xpd_level,930580004,False,1033,C-2,,
xpd_level,930580005,False,1033,C-3,,
xpd_level,930580003,False,1033,Other mission critical,,
ts_indicativeclientbase,717750000,False,1033,PE,,
ts_indicativeclientbase,717750001,False,1033,SMEs,,
ts_indicativeclientbase,717750002,False,1033,Large Corporates,,
ts_indicativeclientbase,717750003,False,1033,MNCs,,
ts_indicativeclientbase,717750004,False,1033,Other,,
xpd_specialisms,930580009,False,1033,Business Process Re-engineering,,
xpd_specialisms,930580007,False,1033,Carve-out,,
xpd_specialisms,930580010,False,1033,Cyber Security,,
xpd_specialisms,930580011,False,1033,Data and Analytics,,
xpd_specialisms,930580012,False,1033,DevOps / Software Factory Productivity,,
xpd_specialisms,930580013,False,1033,Digital Marketing,,
xpd_specialisms,930580014,False,1033,ERP Implementation,,
xpd_specialisms,930580008,False,1033,Family Ownership or similar,,
xpd_specialisms,930580005,False,1033,Growth,,
xpd_specialisms,930580015,False,1033,LEAN / Agile,,
xpd_specialisms,930580004,False,1033,M&A - Post Acquisition Integration,,
xpd_specialisms,930580016,False,1033,Organisation Design,,
xpd_specialisms,930580003,False,1033,PE Exit,,
xpd_specialisms,930580001,False,1033,PE Large Cap,,
xpd_specialisms,930580000,False,1033,PE Mid Cap,,
xpd_specialisms,930580017,False,1033,Risk & Compliance,,
xpd_specialisms,930580018,False,1033,Sales Force Excellence,,
xpd_specialisms,930580006,False,1033,Turnaround,,
xpd_specialisms,930580002,False,1033,VC & PE Small Cap,,
ts_producttype,717750000,False,1033,Europe MMB,,
ts_producttype,717750001,False,1033,LTSA,,
ts_producttype,922460001,False,1033,EMM,,
ts_producttype,922460000,False,1033,Other,,
ts_montaguoffice,717750001,False,1033,Frankfurt,,
ts_montaguoffice,717750002,False,1033,London,,
ts_montaguoffice,717750003,False,1033,Luxembourg,,
ts_montaguoffice,717750004,False,1033,Netherlands,,
ts_montaguoffice,922460000,False,1033,New York,,
ts_montaguoffice,717750005,False,1033,Nordics,,
ts_montaguoffice,717750006,False,1033,Paris,,
ts_montaguoffice,717750007,False,1033,Warsaw,,
ts_quickcapturegeography,717750000,False,1033,British Isles,,
ts_quickcapturegeography,717750001,False,1033,France,,
ts_quickcapturegeography,717750002,False,1033,DACH,,
ts_quickcapturegeography,717750003,False,1033,Nordics,,
ts_quickcapturegeography,717750004,False,1033,Central & Eastern Europe (CEE),,
ts_quickcapturegeography,717750005,False,1033,Benelux,,
ts_quickcapturegeography,717750006,False,1033,Southwestern Europe,,
ts_quickcapturegeography,717750007,False,1033,Asia Pacific,,
ts_quickcapturegeography,717750008,False,1033,Americas,,
ts_quickcapturegeography,717750010,False,1033,MEA,,
ts_quickcapturegeography,717750009,False,1033,Other Territories,,
xpd_roletypes,717750003,False,1033,CEO,,
xpd_roletypes,717750004,False,1033,CFO,,
xpd_roletypes,930580002,False,1033,Chairman,,
xpd_roletypes,930580003,False,1033,Non-Executive,,
xpd_roletypes,922460000,False,1033,Pre Deal Advisor,,
xpd_roletypes,930580001,False,1033,Other,,
ts_talentmeetingtype,717750000,False,1033,General,,
ts_talentmeetingtype,717750001,False,1033,Interview,,
ts_talentmeetingtype,717750002,False,1033,Referencing,,
ts_talentmeetingtype,717750003,False,1033,Market Sounding,,
ts_talentmeetingtype,717750004,False,1033,Assessments,,
ts_talentmeetingtype,717750005,False,1033,SHL Assessments,,
ts_whooriginatedthemeeting,717750000,False,1033,Montagu,,
ts_whooriginatedthemeeting,717750001,False,1033,Client,,
ts_whooriginatedthemeeting,717750002,False,1033,3rd Party,,
onlinemeetingtype,1,False,1033,Teams Meeting,,
ts_meetingteam,717750002,False,1033,General,,
ts_meetingteam,930580000,False,1033,HR,,
ts_meetingteam,717750000,False,1033,Investor Relations,,
ts_meetingteam,717750003,False,1033,Origination,,
ts_meetingteam,717750001,False,1033,Talent,,
ts_othermeetingmethod,717750000,False,1033,MPE Office,,
ts_othermeetingmethod,717750001,False,1033,Other Venue,,
ts_othermeetingmethod,717750002,False,1033,Phone Call,,
ts_tone,717750000,False,1033,Positive,,
ts_tone,717750001,False,1033,Neutral,,
ts_tone,717750002,False,1033,Negative,,
ts_meetingmethod,717750000,False,1033,MPE Office,,
ts_meetingmethod,717750001,False,1033,Investor Office,,
ts_meetingmethod,717750002,False,1033,Other Venue,,
ts_meetingmethod,717750003,False,1033,VC / Phone Meeting,,
ts_meetingmethod,717750004,False,1033,Phone Call,,
ts_meetingmethod,717750005,False,1033,Event,,
ts_originationmeetingtype,717750005,False,1033,Corporate Meeting,,
ts_originationmeetingtype,717750002,False,1033,Deal Introducer,,
ts_originationmeetingtype,717750000,False,1033,First Management Meeting,,
ts_originationmeetingtype,717750004,False,1033,Follow-up Management Meeting,,
ts_originationmeetingtype,717750003,False,1033,General Executive,,
ts_originationmeetingtype,717750001,False,1033,Vendor,,
ts_eventtype,717750000,False,1033,AIM,,
ts_eventtype,717750001,False,1033,Conference,,
ts_eventtype,717750002,False,1033,LPAC,,
ts_eventtype,717750003,False,1033,Other,,
ts_talentmeetingmethod,717750000,False,1033,MPE Office,,
ts_talentmeetingmethod,717750001,False,1033,Other Venue,,
ts_talentmeetingmethod,717750002,False,1033,Phone Call,,
ts_productsdiscussed,930580000,False,1033,Co-invest,,
ts_productsdiscussed,930580001,False,1033,Continuation Vehicle,,
ts_productsdiscussed,717750004,False,1033,Debt,,
ts_productsdiscussed,717750000,False,1033,Europe MMB,,
ts_productsdiscussed,717750001,False,1033,Infrastructure,,
ts_productsdiscussed,717750002,False,1033,LTSA,,
ts_productsdiscussed,717750003,False,1033,Other Region MMB,,
ts_productsdiscussed,717750005,False,1033,Real Estate,,
ts_productsdiscussed,717750006,False,1033,Small-cap,,
ts_contentcovered,717750010,False,1033,Call-down,,
ts_contentcovered,717750000,False,1033,CORRGI,,
ts_contentcovered,717750001,False,1033,Elevator Pitch,,
ts_contentcovered,717750011,False,1033,LP Programme,,
ts_contentcovered,717750012,False,1033,LPA,,
ts_contentcovered,717750002,False,1033,Operations,,
ts_contentcovered,717750003,False,1033,Organisation,,
ts_contentcovered,717750004,False,1033,Origination,,
ts_contentcovered,717750005,False,1033,Performance,,
ts_contentcovered,717750006,False,1033,Portfolio,,
ts_contentcovered,717750007,False,1033,Region,,
ts_contentcovered,717750008,False,1033,Standard Pitch,,
ts_contentcovered,717750009,False,1033,Value Creation,,
isonlinemeeting,1,False,1033,Yes,,
isonlinemeeting,0,False,1033,No,,
isregularactivity,1,False,1033,Yes,,
isregularactivity,0,False,1033,No,,
deliveryprioritycode,0,False,1033,Low,,
deliveryprioritycode,1,False,1033,Normal,,
deliveryprioritycode,2,False,1033,High,,
isemailreminderset,1,False,1033,Yes,,
isemailreminderset,0,False,1033,No,,
isemailfollowed,1,False,1033,Yes,,
isemailfollowed,0,False,1033,No,,
isregularactivity,1,False,1033,Yes,,
isregularactivity,0,False,1033,No,,
ts_recommendationofindividual,930580000,False,1033,Preferred Supplier Contact,,
ts_recommendationofindividual,717750000,False,1033,Recommended,,
ts_recommendationofindividual,717750002,False,1033,Speak to Recommendation Owner,,
ts_recommendationofindividual,717750003,False,1033,Don't Know,,
ts_debtsubtype,717750000,False,1033,Debt Advisory,,
ts_debtsubtype,717750001,False,1033,Debt Provider,,
ts_suffix,717750014,False,1033,ACA,,
ts_suffix,717750016,False,1033,CBE,,
ts_suffix,717750000,False,1033,CFA,,
ts_suffix,717750001,False,1033,CPA,,
ts_suffix,717750010,False,1033,EFS,,
ts_suffix,717750002,False,1033,Esq,,
ts_suffix,717750011,False,1033,FreiHerr,,
ts_suffix,717750009,False,1033,IBD,,
ts_suffix,717750003,False,1033,II,,
ts_suffix,717750004,False,1033,III,,
ts_suffix,717750005,False,1033,Jr,,
ts_suffix,717750013,False,1033,MBA,,
ts_suffix,717750012,False,1033,MBE,,
ts_suffix,717750008,False,1033,OBE,,
ts_suffix,717750007,False,1033,PhD,,
ts_suffix,717750015,False,1033,QC,,
ts_suffix,717750006,False,1033,Sr,,
xpd_gender,930580000,False,1033,Male,,
xpd_gender,930580001,False,1033,Female,,
xpd_gender,930580002,False,1033,Other,,
xpd_gender,930580003,False,1033,Blank,,
ts_title,717750000,False,1033,Dr,,
ts_title,717750001,False,1033,Hon,,
ts_title,717750004,False,1033,Mr,,
ts_title,717750005,False,1033,Mrs,,
ts_title,717750006,False,1033,Ms,,
ts_title,717750002,False,1033,Lord,,
ts_title,717750010,False,1033,Prof,,
ts_title,717750018,False,1033,Prof Dr,,
ts_title,717750003,False,1033,Sir,,
ts_title,717750020,False,1033,Dr. Dr.,,
ts_title,717750019,False,1033,Dr med,,
ts_title,717750007,False,1033,Frau,,
ts_title,717750015,False,1033,Graf,,
ts_title,717750016,False,1033,Gräfin,,
ts_title,717750008,False,1033,Herr,,
ts_title,717750009,False,1033,Herrn,,
ts_title,717750012,False,1033,Madame (Mme),,
ts_title,717750011,False,1033,Monsieur (M),,
ts_title,717750014,False,1033,Prinz,,
ts_title,717750013,False,1033,Prinzessin,,
ts_title,717750017,False,1033,Sultan,,
ts_vendortargettrackingrole,717750000,False,1033,CEO,,
ts_vendortargettrackingrole,717750001,False,1033,CFO,,
ts_vendortargettrackingrole,717750002,False,1033,Corp Dev /Bus Dev,,
ts_vendortargettrackingrole,717750003,False,1033,Head of Strategy/M&A Strategy,,
ts_futurecontactmethod,717750000,False,1033,All contact through owner,,
ts_futurecontactmethod,717750001,False,1033,Only contact at home (not work),,
ts_futurecontactmethod,717750002,False,1033,Do not contact,,
mpe_flowlastrunoutcome,922460000,False,1033,Succeeded,,
mpe_flowlastrunoutcome,922460001,False,1033,Failed,,
mpe_flowlastrunoutcome,922460002,False,1033,Retrying,,
ts_capabilitiesofindividual,717750000,False,1033,Genuine Experts / Specialists,,
ts_capabilitiesofindividual,717750001,False,1033,Generalists,,
ts_quickcaptureuses,100000000,False,1033,Commercial Excellence,,
ts_quickcaptureuses,100000001,False,1033,CORRGI,,
ts_quickcaptureuses,100000002,False,1033,Data,,
ts_quickcaptureuses,100000003,False,1033,Digital,,
ts_quickcaptureuses,100000004,False,1033,Execution,,
ts_quickcaptureuses,100000005,False,1033,Finance,,
ts_quickcaptureuses,100000006,False,1033,Financial & Tax,,
ts_quickcaptureuses,100000007,False,1033,IT & Technology,,
ts_quickcaptureuses,100000008,False,1033,LEAN,,
ts_quickcaptureuses,100000009,False,1033,Legal,,
ts_quickcaptureuses,100000010,False,1033,Operational Excellence,,
ts_quickcaptureuses,100000011,False,1033,People & Organisation,,
ts_quickcaptureuses,100000012,False,1033,Product Development Hardware,,
ts_quickcaptureuses,100000013,False,1033,Product Development Software,,
ts_quickcaptureuses,100000014,False,1033,Product Management,,
ts_quickcaptureuses,100000015,False,1033,Strategy,,
xpd_montagulevel,930580012,False,1033,Capital Markets,,
xpd_montagulevel,930580013,False,1033,Compliance,,
xpd_montagulevel,930580002,False,1033,EA,,
xpd_montagulevel,930580014,False,1033,Finance,,
xpd_montagulevel,930580015,False,1033,HQ,,
xpd_montagulevel,930580016,False,1033,Human Resources,,
xpd_montagulevel,930580017,False,1033,Insights,,
xpd_montagulevel,930580018,False,1033,Investment,,
xpd_montagulevel,930580019,False,1033,Investor Relations,,
xpd_montagulevel,930580009,False,1033,IT,,
xpd_montagulevel,930580020,False,1033,LTSA,,
xpd_montagulevel,930580021,False,1033,Lux Team,,
xpd_montagulevel,930580022,False,1033,MFPP,,
xpd_montagulevel,930580023,False,1033,Origination,,
xpd_montagulevel,930580024,False,1033,Portfolio,,
xpd_montagulevel,930580025,False,1033,Tax & Company Secretarial,,
xpd_montagulevel,930580026,False,1033,Transformation,,
ts_permanentinterim,717750000,False,1033,Permanent - Full Time,,
ts_permanentinterim,930580001,False,1033,Permanent - Part Time,,
ts_permanentinterim,717750001,False,1033,Interim,,
ts_permanentinterim,930580000,False,1033,External Consultant,,
ts_permanentinterim,930580002,False,1033,Research,,
ts_ircontactrole,717750005,False,1033,AB,,
ts_ircontactrole,717750001,False,1033,Co-Investment,,
ts_ircontactrole,717750000,False,1033,Core Team,,
ts_ircontactrole,717750004,False,1033,DD Team (prior fundraise),,
ts_ircontactrole,717750002,False,1033,IC Member,,
ts_ircontactrole,717750003,False,1033,Influencer,,
xpd_level,930580002,False,1033,Non-Executive,,
xpd_level,930580000,False,1033,C (Executive team),,
xpd_level,930580001,False,1033,C-1,,
xpd_level,930580004,False,1033,C-2,,
xpd_level,930580005,False,1033,C-3,,
xpd_level,930580003,False,1033,Other mission critical,,
ts_languagesspokenwritten,717750000,False,1033,Danish,,
ts_languagesspokenwritten,717750001,False,1033,Dutch,,
ts_languagesspokenwritten,717750002,False,1033,English,,
ts_languagesspokenwritten,717750003,False,1033,Finnish,,
ts_languagesspokenwritten,717750004,False,1033,French,,
ts_languagesspokenwritten,717750005,False,1033,German,,
ts_languagesspokenwritten,717750006,False,1033,Hungarian,,
ts_languagesspokenwritten,717750007,False,1033,Italian,,
ts_languagesspokenwritten,717750008,False,1033,Mandarin,,
ts_languagesspokenwritten,717750009,False,1033,Norwegian,,
ts_languagesspokenwritten,717750010,False,1033,Polish,,
ts_languagesspokenwritten,717750011,False,1033,Portuguese,,
ts_languagesspokenwritten,717750012,False,1033,Russian,,
ts_languagesspokenwritten,717750013,False,1033,Spanish,,
ts_languagesspokenwritten,717750014,False,1033,Swedish,,
ts_contacttype,717750000,False,1033,Deal Introducer,,
ts_contacttype,717750006,False,1033,Debt Advisory,,
ts_contacttype,717750011,False,1033,Debt Provider,,
ts_contacttype,717750003,False,1033,Diligence,,
ts_contacttype,717750016,False,1033,Excluded,,
ts_contacttype,717750012,False,1033,Gatekeeper,,
ts_contacttype,930580000,False,1033,HR Candidate,,
ts_contacttype,930580001,False,1033,HR Recruiter,,
ts_contacttype,717750007,False,1033,Investor Group,,
ts_contacttype,717750015,False,1033,Investor Reporting,,
ts_contacttype,717750010,False,1033,M&A Advisory,,
ts_contacttype,717750009,False,1033,Montagu Supplier,,
ts_contacttype,717750013,False,1033,PE Firm,,
ts_contacttype,717750014,False,1033,Placement Agent,,
ts_contacttype,717750008,False,1033,Portfolio Company,,
ts_contacttype,717750004,False,1033,Portfolio Support,,
ts_contacttype,717750005,False,1033,Talent,,
ts_contacttype,717750017,False,1033,Talent Source,,
ts_contacttype,717750001,False,1033,Target Management,,
ts_contacttype,717750002,False,1033,Vendor,,
ts_montaguoffice,717750001,False,1033,Frankfurt,,
ts_montaguoffice,717750002,False,1033,London,,
ts_montaguoffice,717750003,False,1033,Luxembourg,,
ts_montaguoffice,717750004,False,1033,Netherlands,,
ts_montaguoffice,922460000,False,1033,New York,,
ts_montaguoffice,717750005,False,1033,Nordics,,
ts_montaguoffice,717750006,False,1033,Paris,,
ts_montaguoffice,717750007,False,1033,Warsaw,,
ts_roletypes,717750003,False,1033,CEO,,
ts_roletypes,717750004,False,1033,CFO,,
ts_roletypes,930580002,False,1033,Chairman,,
ts_roletypes,930580003,False,1033,Non-Executive,,
ts_roletypes,922460000,False,1033,Pre Deal Advisor,,
ts_roletypes,930580001,False,1033,Other,,
xpd_specialisms,930580009,False,1033,Business Process Re-engineering,,
xpd_specialisms,930580007,False,1033,Carve-out,,
xpd_specialisms,930580010,False,1033,Cyber Security,,
xpd_specialisms,930580011,False,1033,Data and Analytics,,
xpd_specialisms,930580012,False,1033,DevOps / Software Factory Productivity,,
xpd_specialisms,930580013,False,1033,Digital Marketing,,
xpd_specialisms,930580014,False,1033,ERP Implementation,,
xpd_specialisms,930580008,False,1033,Family Ownership or similar,,
xpd_specialisms,930580005,False,1033,Growth,,
xpd_specialisms,930580015,False,1033,LEAN / Agile,,
xpd_specialisms,930580004,False,1033,M&A - Post Acquisition Integration,,
xpd_specialisms,930580016,False,1033,Organisation Design,,
xpd_specialisms,930580003,False,1033,PE Exit,,
xpd_specialisms,930580001,False,1033,PE Large Cap,,
xpd_specialisms,930580000,False,1033,PE Mid Cap,,
xpd_specialisms,930580017,False,1033,Risk & Compliance,,
xpd_specialisms,930580018,False,1033,Sales Force Excellence,,
xpd_specialisms,930580006,False,1033,Turnaround,,
xpd_specialisms,930580002,False,1033,VC & PE Small Cap,,
ts_quickcapturesectors,717750000,False,1033,Energy & Utilities,,
ts_quickcapturesectors,717750001,False,1033,Industrials & Materials,,
ts_quickcapturesectors,717750002,False,1033,Commercial & Professional Services,,
ts_quickcapturesectors,717750003,False,1033,Transport & Logistics,,
ts_quickcapturesectors,717750004,False,1033,Consumer Goods & Services,,
ts_quickcapturesectors,717750005,False,1033,Health Care,,
ts_quickcapturesectors,717750006,False,1033,Financials,,
ts_quickcapturesectors,717750007,False,1033,Software / IT,,
ts_quickcapturesectors,717750008,False,1033,Telecoms & Media,,
xpd_function,930580008,False,1033,Corporate Dev & M&A,,
xpd_function,930580001,False,1033,Finance,,
xpd_function,930580000,False,1033,General management,,
xpd_function,930580006,False,1033,HR,,
xpd_function,930580009,False,1033,Legal,,
xpd_function,930580007,False,1033,Marketing & Comms,,
xpd_function,930580010,False,1033,Medical,,
xpd_function,930580003,False,1033,Operations,,
xpd_function,930580005,False,1033,Product & Innovation,,
xpd_function,930580002,False,1033,Sales,,
xpd_function,930580012,False,1033,Supply Chain,,
xpd_function,930580004,False,1033,Tech & IT,,
ts_producttype,717750000,False,1033,Europe MMB,,
ts_producttype,717750001,False,1033,LTSA,,
ts_producttype,922460001,False,1033,EMM,,
ts_producttype,922460000,False,1033,Other,,
ts_quickcapturegeography,717750000,False,1033,British Isles,,
ts_quickcapturegeography,717750001,False,1033,France,,
ts_quickcapturegeography,717750002,False,1033,DACH,,
ts_quickcapturegeography,717750003,False,1033,Nordics,,
ts_quickcapturegeography,717750004,False,1033,Central & Eastern Europe (CEE),,
ts_quickcapturegeography,717750005,False,1033,Benelux,,
ts_quickcapturegeography,717750006,False,1033,Southwestern Europe,,
ts_quickcapturegeography,717750007,False,1033,Asia Pacific,,
ts_quickcapturegeography,717750008,False,1033,Americas,,
ts_quickcapturegeography,717750010,False,1033,MEA,,
ts_quickcapturegeography,717750009,False,1033,Other Territories,,
ts_productsinterestedin,930580000,False,1033,Co-invest,,
ts_productsinterestedin,930580001,False,1033,Continuation Vehicle,,
ts_productsinterestedin,717750004,False,1033,Debt,,
ts_productsinterestedin,717750000,False,1033,Europe MMB,,
ts_productsinterestedin,717750001,False,1033,Infrastructure,,
ts_productsinterestedin,717750002,False,1033,LTSA,,
ts_productsinterestedin,717750003,False,1033,Other Region MMB,,
ts_productsinterestedin,717750005,False,1033,Real Estate,,
ts_productsinterestedin,717750006,False,1033,Small-cap,,
isregularactivity,1,False,1033,Yes,,
isregularactivity,0,False,1033,No,,
isregularactivity,1,False,1033,Yes,,
isregularactivity,0,False,1033,No,,
isregularactivity,1,False,1033,Yes,,
isregularactivity,0,False,1033,No,,
isregularactivity,1,False,1033,Yes,,
isregularactivity,0,False,1033,No,,
issastokenset,1,False,1033,Yes,,
issastokenset,0,False,1033,No,,
ts_boardmembertype,717750000,False,1033,Primary,,
ts_boardmembertype,717750001,False,1033,Observer/Non-voting,,
ts_addresstype,717750001,False,1033,Business,,
ts_addresstype,717750002,False,1033,Mailing,,
ts_addresstype,717750003,False,1033,Registered Office,,
ts_addresstype,717750004,False,1033,Tax,,
ts_addresstype,717750000,False,1033,US Tax Office,,
xpd_role,930580000,False,1033,Non-Executive Director,,
xpd_role,930580001,False,1033,Non-Executive Chair,,
xpd_role,930580002,False,1033,Executive Chair,,
xpd_role,930580003,False,1033,CEO,,
xpd_role,930580004,False,1033,CFO,,
ts_recruitmentstage,717750000,False,1033,Longlist,,
ts_recruitmentstage,717750001,False,1033,Shortlist,,
ts_recruitmentstage,717750002,False,1033,Interviews,,
ts_recruitmentstage,717750007,False,1033,1st Interview,,
ts_recruitmentstage,717750008,False,1033,2nd Interview,,
ts_recruitmentstage,717750009,False,1033,Final Interview,,
ts_recruitmentstage,717750003,False,1033,Referencing,,
ts_recruitmentstage,717750004,False,1033,External assessment,,
ts_recruitmentstage,717750005,False,1033,Offer sent,,
ts_recruitmentstage,717750006,False,1033,Contract signed,,
xpd_sourceofcandidate,930580000,False,1033,Referrer,,
xpd_sourceofcandidate,930580001,False,1033,Search Firm,,
xpd_sourceofcandidate,930580002,False,1033,Internal,,
xpd_sourceofcandidate,930580003,False,1033,Website; LinkedIn; Other,,
xpd_candidateoutcome,930580000,False,1033,Candidate Withdrawn,,
xpd_candidateoutcome,930580001,False,1033,Not Progressed,,
ts_closing,717750000,False,1033,1st,,
ts_closing,717750001,False,1033,2nd,,
ts_closing,717750002,False,1033,3rd,,
ts_closing,717750003,False,1033,4+,,
ts_closing,717750004,False,1033,Final,,
mpe_offeringstatus,717750000,False,1033,In Progress,,
mpe_offeringstatus,717750001,False,1033,Completed,,
mpe_offeringstatus,717750002,False,1033,Aborted,,
mpe_offeringstatus,717750003,False,1033,Aborted Deal,,
ts_offeringtype,717750000,False,1033,Co-Investment,,
ts_offeringtype,717750001,False,1033,Debt,,
mpe_coinvestmenttype,717750000,False,1033,Co-underwriting,,
mpe_coinvestmenttype,717750001,False,1033,Syndication,,
ts_product,930580000,False,1033,Co-invest,,
ts_product,930580001,False,1033,Continuation Vehicle,,
ts_product,717750004,False,1033,Debt,,
ts_product,717750000,False,1033,Europe MMB,,
ts_product,717750001,False,1033,Infrastructure,,
ts_product,717750002,False,1033,LTSA,,
ts_product,717750003,False,1033,Other Region MMB,,
ts_product,717750005,False,1033,Real Estate,,
ts_product,717750006,False,1033,Small-cap,,
ts_offeringstatus,717750000,False,1033,In Progress,,
ts_offeringstatus,717750001,False,1033,Completed,,
ts_offeringstatus,717750002,False,1033,Aborted,,
ts_offeringstatus,717750003,False,1033,Aborted Deal,,
ts_offeringtype,717750000,False,1033,Co-Investment,,
ts_offeringtype,717750001,False,1033,Debt,,
ts_coinvestmenttype,717750000,False,1033,Co-underwriting,,
ts_coinvestmenttype,717750001,False,1033,Syndication,,
ts_preferredpaymentmethod,717750000,False,1033,Wire Transfer,,
ts_preferredpaymentmethod,717750001,False,1033,IBAN,,
ts_preferredpaymentmethod,717750002,False,1033,xx,,
ts_advisoryboardrights,717750000,False,1033,Voting,,
ts_advisoryboardrights,717750001,False,1033,Non-Voting,,
ts_lptransfertype,717750003,False,1033,Commitment Reduction,,
ts_lptransfertype,717750000,False,1033,Name Change Only,,
ts_lptransfertype,717750002,False,1033,Transfer (change of beneficial owner),,
ts_lptransfertype,717750001,False,1033,Transfer (no change of beneficial owner),,
xpd_level,930580002,False,1033,Non-Executive,,
xpd_level,930580000,False,1033,C (Executive team),,
xpd_level,930580001,False,1033,C-1,,
xpd_level,930580004,False,1033,C-2,,
xpd_level,930580005,False,1033,C-3,,
xpd_level,930580003,False,1033,Other mission critical,,
xpd_roletype,717750003,False,1033,CEO,,
xpd_roletype,717750004,False,1033,CFO,,
xpd_roletype,930580002,False,1033,Chairman,,
xpd_roletype,930580003,False,1033,Non-Executive,,
xpd_roletype,922460000,False,1033,Pre Deal Advisor,,
xpd_roletype,930580001,False,1033,Other,,
xpd_employmenthistoryroletype,930580000,False,1033,CEO,,
xpd_employmenthistoryroletype,930580001,False,1033,CFO,,
xpd_employmenthistoryroletype,930580002,False,1033,Other,,
xpd_function,930580008,False,1033,Corporate Dev & M&A,,
xpd_function,930580001,False,1033,Finance,,
xpd_function,930580000,False,1033,General management,,
xpd_function,930580006,False,1033,HR,,
xpd_function,930580009,False,1033,Legal,,
xpd_function,930580007,False,1033,Marketing & Comms,,
xpd_function,930580010,False,1033,Medical,,
xpd_function,930580003,False,1033,Operations,,
xpd_function,930580005,False,1033,Product & Innovation,,
xpd_function,930580002,False,1033,Sales,,
xpd_function,930580012,False,1033,Supply Chain,,
xpd_function,930580004,False,1033,Tech & IT,,
xpd_appointeesuccessrating,930580002,False,1033,Below,,
xpd_appointeesuccessrating,930580004,False,1033,Somewhat Below,,
xpd_appointeesuccessrating,930580001,False,1033,Meets,,
xpd_appointeesuccessrating,930580000,False,1033,Somewhat exceeds,,
xpd_appointeesuccessrating,930580005,False,1033,Exceeds,,
xpd_appointeesuccessrating,930580006,False,1033,New in position,,
xpd_appointeesuccessrating,930580007,False,1033,Not assessed by Montagu,,
xpd_appointeesuccessrating,930580003,False,1033,Has left role,,
xpd_function,930580008,False,1033,Corporate Dev & M&A,,
xpd_function,930580001,False,1033,Finance,,
xpd_function,930580000,False,1033,General management,,
xpd_function,930580006,False,1033,HR,,
xpd_function,930580009,False,1033,Legal,,
xpd_function,930580007,False,1033,Marketing & Comms,,
xpd_function,930580010,False,1033,Medical,,
xpd_function,930580003,False,1033,Operations,,
xpd_function,930580005,False,1033,Product & Innovation,,
xpd_function,930580002,False,1033,Sales,,
xpd_function,930580012,False,1033,Supply Chain,,
xpd_function,930580004,False,1033,Tech & IT,,
xpd_externalhireorinternalpromotion,930580000,False,1033,Internal,,
xpd_externalhireorinternalpromotion,930580001,False,1033,External,,
xpd_montagulevel,930580012,False,1033,Capital Markets,,
xpd_montagulevel,930580013,False,1033,Compliance,,
xpd_montagulevel,930580002,False,1033,EA,,
xpd_montagulevel,930580014,False,1033,Finance,,
xpd_montagulevel,930580015,False,1033,HQ,,
xpd_montagulevel,930580016,False,1033,Human Resources,,
xpd_montagulevel,930580017,False,1033,Insights,,
xpd_montagulevel,930580018,False,1033,Investment,,
xpd_montagulevel,930580019,False,1033,Investor Relations,,
xpd_montagulevel,930580009,False,1033,IT,,
xpd_montagulevel,930580020,False,1033,LTSA,,
xpd_montagulevel,930580021,False,1033,Lux Team,,
xpd_montagulevel,930580022,False,1033,MFPP,,
xpd_montagulevel,930580023,False,1033,Origination,,
xpd_montagulevel,930580024,False,1033,Portfolio,,
xpd_montagulevel,930580025,False,1033,Tax & Company Secretarial,,
xpd_montagulevel,930580026,False,1033,Transformation,,
ts_recruitmentstage,717750012,False,1033,Docs Prepared,,
ts_recruitmentstage,717750013,False,1033,Docs Sent,,
ts_recruitmentstage,717750014,False,1033,Docs Signed,,
ts_recruitmentstage,717750015,False,1033,Offer Accepted,,
ts_recruitmentstage,717750016,False,1033,Candidate resigned / confirmed joining,,
ts_recruitmentstage,717750000,False,1033,Search Started,,
ts_recruitmentstage,717750001,False,1033,Write Job Spec,,
ts_recruitmentstage,717750002,False,1033,Job Spec Agreed,,
ts_recruitmentstage,717750003,False,1033,Search Firm Chosen,,
ts_recruitmentstage,717750004,False,1033,Long List,,
ts_recruitmentstage,717750005,False,1033,Short List,,
ts_recruitmentstage,717750006,False,1033,Interviews,,
ts_recruitmentstage,717750007,False,1033,External Assessment,,
ts_recruitmentstage,717750008,False,1033,Package Sign-off,,
ts_recruitmentstage,717750009,False,1033,Verbal Offer Made,,
ts_recruitmentstage,717750010,False,1033,Terms Agreed,,
ts_recruitmentstage,717750011,False,1033,References Taken,,
ts_interimpermanent,717750000,False,1033,Permanent - Full Time,,
ts_interimpermanent,930580001,False,1033,Permanent - Part Time,,
ts_interimpermanent,717750001,False,1033,Interim,,
ts_interimpermanent,930580000,False,1033,External Consultant,,
ts_interimpermanent,930580002,False,1033,Research,,
mpe_flowlastrunoutcome,922460000,False,1033,Succeeded,,
mpe_flowlastrunoutcome,922460001,False,1033,Failed,,
mpe_flowlastrunoutcome,922460002,False,1033,Retrying,,
xpd_employentity,930580000,False,1033,LLP,,
xpd_employentity,930580001,False,1033,GmbH,,
xpd_employentity,930580002,False,1033,MFPP,,
xpd_employentity,930580003,False,1033,Sarl,,
xpd_employentity,930580004,False,1033,SAS,,
xpd_employentity,930580005,False,1033,Zo o,,
xpd_level,930580002,False,1033,Non-Executive,,
xpd_level,930580000,False,1033,C (Executive team),,
xpd_level,930580001,False,1033,C-1,,
xpd_level,930580004,False,1033,C-2,,
xpd_level,930580005,False,1033,C-3,,
xpd_level,930580003,False,1033,Other mission critical,,
xpd_talentteaminvolvement,930580000,False,1033,Montagu not involved,,
xpd_talentteaminvolvement,930580001,False,1033,Montagu involved,,
xpd_talentteaminvolvement,930580002,False,1033,Talent team not involved,,
xpd_talentteaminvolvement,930580003,False,1033,Start: Full involvement,,
xpd_talentteaminvolvement,930580004,False,1033,Start: Limited,,
xpd_talentteaminvolvement,930580005,False,1033,Start: Final interview + referencing,,
xpd_talentteaminvolvement,930580006,False,1033,Midway: When issues encountered,,
xpd_talentteaminvolvement,930580007,False,1033,Latter: Final interviews,,
xpd_talentteaminvolvement,930580008,False,1033,Latter: Final interviews & referencing,,
xpd_talentteaminvolvement,930580009,False,1033,Latter: Referencing and/or assessment,,
ts_roletype,717750003,False,1033,CEO,,
ts_roletype,717750004,False,1033,CFO,,
ts_roletype,930580002,False,1033,Chairman,,
ts_roletype,930580003,False,1033,Non-Executive,,
ts_roletype,922460000,False,1033,Pre Deal Advisor,,
ts_roletype,930580001,False,1033,Other,,
xpd_montaguoffice,717750001,False,1033,Frankfurt,,
xpd_montaguoffice,717750002,False,1033,London,,
xpd_montaguoffice,717750003,False,1033,Luxembourg,,
xpd_montaguoffice,717750004,False,1033,Netherlands,,
xpd_montaguoffice,922460000,False,1033,New York,,
xpd_montaguoffice,717750005,False,1033,Nordics,,
xpd_montaguoffice,717750006,False,1033,Paris,,
xpd_montaguoffice,717750007,False,1033,Warsaw,,
ts_levelofrecommendation,717750000,False,1033,1 - Highly Recommended,,
ts_levelofrecommendation,717750001,False,1033,2 - Recommended,,
ts_levelofrecommendation,717750002,False,1033,3 - Recommended with caveats,,
ts_levelofrecommendation,717750003,False,1033,4 - Not Recommended,,
ts_engagementtype,930580001,False,1033,Carve-out support,,
ts_engagementtype,717750003,False,1033,Diligence,,
ts_engagementtype,930580000,False,1033,HR,,
ts_engagementtype,717750000,False,1033,M&A Advisory,,
ts_engagementtype,717750001,False,1033,Portfolio Support,,
ts_engagementtype,930580003,False,1033,Project,,
ts_engagementtype,717750002,False,1033,Talent,,
ts_engagementtype,930580002,False,1033,Transformation Team,,
xpd_vacancystatus,930580000,False,1033,New Role,,
xpd_vacancystatus,930580001,False,1033,Replacement,,
xpd_employentity,930580006,False,1033,LLC,,
ts_product,930580000,False,1033,Co-invest,,
ts_product,930580001,False,1033,Continuation Vehicle,,
ts_product,717750004,False,1033,Debt,,
ts_product,717750000,False,1033,Europe MMB,,
ts_product,717750001,False,1033,Infrastructure,,
ts_product,717750002,False,1033,LTSA,,
ts_product,717750003,False,1033,Other Region MMB,,
ts_product,717750005,False,1033,Real Estate,,
ts_product,717750006,False,1033,Small-cap,,
ts_vintageyear,717750000,False,1033,2000,,
ts_vintageyear,717750001,False,1033,2001,,
ts_vintageyear,717750002,False,1033,2002,,
ts_vintageyear,717750003,False,1033,2003,,
ts_vintageyear,717750004,False,1033,2004,,
ts_vintageyear,717750005,False,1033,2005,,
ts_vintageyear,717750006,False,1033,2006,,
ts_vintageyear,717750007,False,1033,2007,,
ts_vintageyear,717750008,False,1033,2008,,
ts_vintageyear,717750009,False,1033,2009,,
ts_vintageyear,717750010,False,1033,2010,,
ts_vintageyear,717750011,False,1033,2011,,
ts_vintageyear,717750012,False,1033,2012,,
ts_vintageyear,717750013,False,1033,2013,,
ts_vintageyear,717750014,False,1033,2014,,
ts_vintageyear,717750015,False,1033,2015,,
ts_vintageyear,717750016,False,1033,2016,,
ts_vintageyear,717750017,False,1033,2017,,
ts_vintageyear,717750018,False,1033,2018,,
ts_vintageyear,717750019,False,1033,2019,,
ts_vintageyear,717750020,False,1033,2020,,
ts_vintageyear,717750021,False,1033,2021,,
ts_vintageyear,717750022,False,1033,2022,,
ts_vintageyear,717750023,False,1033,2023,,
ts_vintageyear,717750024,False,1033,2024,,
ts_vintageyear,717750025,False,1033,2025,,
ts_vintageyear,717750026,False,1033,2026,,
ts_vintageyear,717750027,False,1033,2027,,
ts_vintageyear,717750028,False,1033,2028,,
ts_vintageyear,717750029,False,1033,2029,,
ts_vintageyear,717750030,False,1033,2030,,
ts_fundtype,717750000,False,1033,PE,,
ts_fundtype,717750001,False,1033,Co-Invest,,
ts_fundtype,717750002,False,1033,Other,,
ts_domicile,717750000,False,1033,United Kingdom,,
ts_domicile,717750001,False,1033,Luxembourg,,
ts_openclosedended,717750000,False,1033,Open Ended,,
ts_openclosedended,717750001,False,1033,Closed Ended,,
ts_portalaccess,717750000,False,1033,Invited,,
ts_portalaccess,717750001,False,1033,Active,,
ts_ppmsent,717750000,False,1033,Yes,,
ts_ppmsent,717750001,False,1033,No,,
ts_ppmsent,717750002,False,1033,N/A,,
ts_fundraisingstage,717750000,False,1033,1 - Introduction,,
ts_fundraisingstage,717750001,False,1033,2 - Initial Diligence,,
ts_fundraisingstage,717750002,False,1033,3 - Decision,,
ts_fundraisingstage,717750003,False,1033,Completed,,
ts_processletter,717750000,False,1033,Yes,,
ts_processletter,717750001,False,1033,No,,
ts_sidelettersignoffstatus,717750001,False,1033,In progress,,
ts_sidelettersignoffstatus,717750002,False,1033,Potential issues,,
ts_sidelettersignoffstatus,717750003,False,1033,Signed-off,,
ts_acceptedaim,717750000,False,1033,Yes,,
ts_acceptedaim,717750001,False,1033,No,,
ts_oddonsitesstatus,717750000,False,1033,Not Requested,,
ts_oddonsitesstatus,717750001,False,1033,Requested,,
ts_oddonsitesstatus,717750002,False,1033,Scheduled,,
ts_oddonsitesstatus,717750003,False,1033,Completed,,
ts_oddonsitesstatus,717750004,False,1033,n/a,,
ts_amlcompletestatus,717750001,False,1033,In progress,,
ts_amlcompletestatus,717750002,False,1033,Potential issues,,
ts_amlcompletestatus,717750003,False,1033,Signed-off,,
ts_amldocumentsstatus,717750003,False,1033,Not provided,,
ts_amldocumentsstatus,717750000,False,1033,With us,,
ts_amldocumentsstatus,717750001,False,1033,With them,,
ts_amldocumentsstatus,717750002,False,1033,n/a,,
ts_oddquestionnaire,717750003,False,1033,Not Provided,,
ts_oddquestionnaire,717750000,False,1033,With us,,
ts_oddquestionnaire,717750001,False,1033,With them,,
ts_oddquestionnaire,717750002,False,1033,n/a,,
ts_ddonsitesstatus,717750000,False,1033,Not Requested,,
ts_ddonsitesstatus,717750001,False,1033,Requested,,
ts_ddonsitesstatus,717750002,False,1033,Scheduled,,
ts_ddonsitesstatus,717750003,False,1033,Completed,,
ts_ddonsitesstatus,717750004,False,1033,n/a,,
ts_diligencerequeststemplates,717750003,False,1033,Not provided,,
ts_diligencerequeststemplates,717750000,False,1033,With us,,
ts_diligencerequeststemplates,717750001,False,1033,With them,,
ts_diligencerequeststemplates,717750002,False,1033,n/a,,
ts_draftsubbookstatus,717750000,False,1033,Not provided,,
ts_draftsubbookstatus,717750001,False,1033,Provided,,
ts_signedsubbookstatus,717750001,False,1033,In progress,,
ts_signedsubbookstatus,717750002,False,1033,Potential issues,,
ts_signedsubbookstatus,717750003,False,1033,Signed-off,,
ts_icdecision,717750000,False,1033,Initial,,
ts_icdecision,717750001,False,1033,Mid,,
ts_icdecision,717750002,False,1033,Final,,
ts_sideletterstatus,717750003,False,1033,Not provided,,
ts_sideletterstatus,717750000,False,1033,With us,,
ts_sideletterstatus,717750001,False,1033,With them,,
ts_sideletterstatus,717750002,False,1033,n/a,,
ts_legalcommentsstatus,717750003,False,1033,Not provided,,
ts_legalcommentsstatus,717750000,False,1033,With us,,
ts_legalcommentsstatus,717750001,False,1033,With them,,
ts_legalcommentsstatus,717750002,False,1033,n/a,,
ts_dataroomprovided,717750000,False,1033,Yes,,
ts_dataroomprovided,717750001,False,1033,No,,
ts_dataroomprovided,717750002,False,1033,N/A,,
ts_icdecisiondropdown,717750000,False,1033,Yes,,
ts_icdecisiondropdown,717750001,False,1033,No,,
ts_associatedclose,717750000,False,1033,First,,
ts_associatedclose,717750001,False,1033,Second,,
ts_associatedclose,717750002,False,1033,Third,,
ts_associatedclose,717750003,False,1033,Final,,
ts_invitedtoaim,717750000,False,1033,Yes,,
ts_invitedtoaim,717750001,False,1033,No,,
ts_lpasignoffstatus,717750001,False,1033,In progress,,
ts_lpasignoffstatus,717750002,False,1033,Potential issues,,
ts_lpasignoffstatus,717750003,False,1033,Signed-off,,
ts_followondiligence,717750003,False,1033,Not provided,,
ts_followondiligence,717750000,False,1033,With us,,
ts_followondiligence,717750001,False,1033,With them,,
ts_followondiligence,717750002,False,1033,n/a,,
ts_gatekeeperrelationship,717750005,False,1033,Advisory,,
ts_gatekeeperrelationship,717750001,False,1033,Approval,,
ts_gatekeeperrelationship,717750003,False,1033,Co-investment,,
ts_gatekeeperrelationship,717750000,False,1033,Discretionary,,
ts_gatekeeperrelationship,717750004,False,1033,Fund of Funds,,
ts_gatekeeperrelationship,717750002,False,1033,Monitoring,,
ts_gatekeeperstatus,717750000,False,1033,Current,,
ts_gatekeeperstatus,717750001,False,1033,Former,,
ts_assetclassadvising,930580000,False,1033,Co-invest,,
ts_assetclassadvising,930580001,False,1033,Continuation Vehicle,,
ts_assetclassadvising,717750004,False,1033,Debt,,
ts_assetclassadvising,717750000,False,1033,Europe MMB,,
ts_assetclassadvising,717750001,False,1033,Infrastructure,,
ts_assetclassadvising,717750002,False,1033,LTSA,,
ts_assetclassadvising,717750003,False,1033,Other Region MMB,,
ts_assetclassadvising,717750005,False,1033,Real Estate,,
ts_assetclassadvising,717750006,False,1033,Small-cap,,
ts_category,717750002,False,1033,Audit,,
ts_category,717750014,False,1033,Bank Changes,,
ts_category,717750006,False,1033,Basel III,,
ts_category,717750004,False,1033,Bespoke template,,
ts_category,717750005,False,1033,Capital Account,,
ts_category,717750010,False,1033,Cashflow forecast,,
ts_category,717750009,False,1033,Compliance,,
ts_category,717750013,False,1033,Contact Changes,,
ts_category,717750003,False,1033,General,,
ts_category,717750001,False,1033,ILPA Fee Reporting,,
ts_category,717750011,False,1033,Industry survey,,
ts_category,717750012,False,1033,LP transfer,,
ts_category,717750008,False,1033,Portfolio Company figures,,
ts_category,717750000,False,1033,Reporting,,
ts_category,717750007,False,1033,Tax,,
ts_recurring,717750000,False,1033,Annually,,
ts_recurring,717750001,False,1033,Quarterly,,
ts_recurring,717750002,False,1033,Monthly,,
ts_recurring,717750003,False,1033,Yes,,
ts_recurring,717750004,False,1033,No,,
ts_querystatus,717750000,False,1033,In Progress,,
ts_querystatus,717750001,False,1033,Complete,,
ts_teamresponsible,717750002,False,1033,Compliance Team,,
ts_teamresponsible,717750000,False,1033,Fund Team,,
ts_teamresponsible,717750005,False,1033,HR,,
ts_teamresponsible,717750004,False,1033,Investor Relations Team,,
ts_teamresponsible,717750001,False,1033,Portfolio Team,,
ts_teamresponsible,717750003,False,1033,Tax Team,,
ts_aifmdgrouptype,717750001,False,1033,Bank,,
ts_aifmdgrouptype,717750006,False,1033,General Government,,
ts_aifmdgrouptype,717750007,False,1033,Households,,
ts_aifmdgrouptype,717750004,False,1033,Insurance Corporations,,
ts_aifmdgrouptype,717750000,False,1033,Non-financial Corporations,,
ts_aifmdgrouptype,717750002,False,1033,Other Collective Investment Undertaking,,
ts_aifmdgrouptype,717750003,False,1033,Other Financial Institutions,,
ts_aifmdgrouptype,717750005,False,1033,Pension Funds,,
ts_aifmdgrouptype,717750008,False,1033,Unknown,,
ts_aifmdgrouptype,717750009,False,1033,None,,
ts_debtstatus,717750000,False,1033,In Progress,,
ts_debtstatus,717750001,False,1033,Invested,,
ts_debtstatus,717750002,False,1033,Rejected,,
ts_relationship,717750000,False,1033,Outlook Sync,,
ts_relationship,717750001,False,1033,Has Met,,
mpe_targetrelationshipstatus,930580001,False,1033,Relationship,,
mpe_targetrelationshipstatus,930580002,False,1033,Future Star,,
mpe_targetrelationshipstatus,930580003,False,1033,Hard to Reach,,
mpe_targetrelationshipstatus,930580000,False,1033,None,,
mpe_carveout,717750000,False,1033,Yes,,
mpe_carveout,717750001,False,1033,No,,
ts_producttype,717750000,False,1033,Europe MMB,,
ts_producttype,717750001,False,1033,LTSA,,
ts_producttype,922460001,False,1033,EMM,,
ts_producttype,922460000,False,1033,Other,,
mpe_flowlastrunoutcome,922460000,False,1033,Succeeded,,
mpe_flowlastrunoutcome,922460001,False,1033,Failed,,
mpe_flowlastrunoutcome,922460002,False,1033,Retrying,,
ts_montaguprimaryoffice,717750001,False,1033,Frankfurt,,
ts_montaguprimaryoffice,717750002,False,1033,London,,
ts_montaguprimaryoffice,717750003,False,1033,Luxembourg,,
ts_montaguprimaryoffice,717750004,False,1033,Netherlands,,
ts_montaguprimaryoffice,922460000,False,1033,New York,,
ts_montaguprimaryoffice,717750005,False,1033,Nordics,,
ts_montaguprimaryoffice,717750006,False,1033,Paris,,
ts_montaguprimaryoffice,717750007,False,1033,Warsaw,,
ts_choppedreason,717750000,False,1033,Business Concerns,,
ts_choppedreason,717750002,False,1033,ESG Concerns,,
ts_choppedreason,717750003,False,1033,Industry Concerns,,
ts_choppedreason,717750004,False,1033,Lack of Angle,,
ts_choppedreason,717750005,False,1033,Management Concerns,,
ts_choppedreason,717750008,False,1033,No Deal,,
ts_choppedreason,717750010,False,1033,Price,,
ts_choppedreason,717750011,False,1033,Terms,,
ts_choppedreason,717750007,False,1033,Unsuitable Size,,
deliveryprioritycode,0,False,1033,Low,,
deliveryprioritycode,1,False,1033,Normal,,
deliveryprioritycode,2,False,1033,High,,
ts_activitytype,930580000,False,1033,HR: Note,,
ts_activitytype,717750005,False,1033,IR: LP Survey,,
ts_activitytype,717750001,False,1033,IR: Note,,
ts_activitytype,717750002,False,1033,Origination: Letter,,
ts_activitytype,717750004,False,1033,Origination: Note,,
ts_activitytype,930580001,False,1033,Talent: Note,,
ts_eventtype,717750000,False,1033,AIM,,
ts_eventtype,717750001,False,1033,Conference,,
ts_eventtype,717750002,False,1033,LPAC,,
ts_eventtype,717750003,False,1033,Other,,
ts_notetype,717750000,False,1033,News Article,,
ts_notetype,717750001,False,1033,Team Change,,
ts_notetype,717750002,False,1033,Strategy Change,,
ts_notetype,717750003,False,1033,Change of Consultant,,
community,1,False,1033,Facebook,,
community,2,False,1033,Twitter,,
community,0,False,1033,Other,,
ts_productsdiscussed,930580000,False,1033,Co-invest,,
ts_productsdiscussed,930580001,False,1033,Continuation Vehicle,,
ts_productsdiscussed,717750004,False,1033,Debt,,
ts_productsdiscussed,717750000,False,1033,Europe MMB,,
ts_productsdiscussed,717750001,False,1033,Infrastructure,,
ts_productsdiscussed,717750002,False,1033,LTSA,,
ts_productsdiscussed,717750003,False,1033,Other Region MMB,,
ts_productsdiscussed,717750005,False,1033,Real Estate,,
ts_productsdiscussed,717750006,False,1033,Small-cap,,
isregularactivity,1,False,1033,Yes,,
isregularactivity,0,False,1033,No,,
ts_segment,717750000,False,1033,1: Core,,
ts_segment,717750001,False,1033,2: Hub,,
ts_segment,717750002,False,1033,3: Mega,,
ts_segment,717750003,False,1033,4: Excluded,,
ts_segment,717750004,False,1033,5: Unclassified,,
ts_competition,717750000,False,1033,Red,,
ts_competition,717750001,False,1033,Green,,
ts_competition,717750002,False,1033,-,,
ts_competition,717750003,False,1033,?,,
xpd_canprovideunderwritingwarehousingfac,717750000,False,1033,Yes,,
xpd_canprovideunderwritingwarehousingfac,717750001,False,1033,No,,
ts_relationshipstability,717750000,False,1033,Red,,
ts_relationshipstability,717750001,False,1033,Green,,
ts_relationshipstability,717750002,False,1033,-,,
ts_relationshipstability,717750003,False,1033,?,,
ts_notablemontagufactorsothercomments,717750000,False,1033,Red,,
ts_notablemontagufactorsothercomments,717750001,False,1033,Green,,
ts_notablemontagufactorsothercomments,717750002,False,1033,-,,
ts_notablemontagufactorsothercomments,717750003,False,1033,?,,
ts_speedofexecutiondecisions,717750000,False,1033,5 - Very Fast,,
ts_speedofexecutiondecisions,717750001,False,1033,4 - Fast,,
ts_speedofexecutiondecisions,717750002,False,1033,3 - Medium,,
ts_speedofexecutiondecisions,717750003,False,1033,2 - Slow,,
ts_speedofexecutiondecisions,717750004,False,1033,1 - Very Slow,,
mpe_dedicatedcoinvestmentteam,717750000,False,1033,Yes,,
mpe_dedicatedcoinvestmentteam,717750001,False,1033,No,,
ts_europeanallocationgrowth,717750000,False,1033,Red,,
ts_europeanallocationgrowth,717750001,False,1033,Green,,
ts_europeanallocationgrowth,717750002,False,1033,-,,
ts_europeanallocationgrowth,717750003,False,1033,?,,
ts_relationshipwarmth,717750000,False,1033,Red,,
ts_relationshipwarmth,717750001,False,1033,Green,,
ts_relationshipwarmth,717750002,False,1033,-,,
ts_relationshipwarmth,717750003,False,1033,?,,
ts_lpteamstability,717750000,False,1033,Red,,
ts_lpteamstability,717750001,False,1033,Green,,
ts_lpteamstability,717750002,False,1033,-,,
ts_lpteamstability,717750003,False,1033,?,,
ts_fundraisingstyle,717750000,False,1033,Red,,
ts_fundraisingstyle,717750001,False,1033,Green,,
ts_fundraisingstyle,717750002,False,1033,-,,
ts_fundraisingstyle,717750003,False,1033,?,,
ts_relationship,717750000,False,1033,1: Warm,,
ts_relationship,717750001,False,1033,2: Warming,,
ts_relationship,717750002,False,1033,3: Lukewarm,,
ts_relationship,717750003,False,1033,4: Concern,,
ts_relationship,717750004,False,1033,5: None,,
ts_strategychange,717750000,False,1033,Red,,
ts_strategychange,717750001,False,1033,Green,,
ts_strategychange,717750002,False,1033,-,,
ts_strategychange,717750003,False,1033,?,,
ts_product,930580000,False,1033,Co-invest,,
ts_product,930580001,False,1033,Continuation Vehicle,,
ts_product,717750004,False,1033,Debt,,
ts_product,717750000,False,1033,Europe MMB,,
ts_product,717750001,False,1033,Infrastructure,,
ts_product,717750002,False,1033,LTSA,,
ts_product,717750003,False,1033,Other Region MMB,,
ts_product,717750005,False,1033,Real Estate,,
ts_product,717750006,False,1033,Small-cap,,
ts_growingaum,717750000,False,1033,Red,,
ts_growingaum,717750001,False,1033,Green,,
ts_growingaum,717750002,False,1033,-,,
ts_growingaum,717750003,False,1033,?,,
ts_relationshipinteraction,717750000,False,1033,Red,,
ts_relationshipinteraction,717750001,False,1033,Green,,
ts_relationshipinteraction,717750002,False,1033,-,,
ts_relationshipinteraction,717750003,False,1033,?,,
xpd_interestedincoinvest,717750000,False,1033,Yes,,
xpd_interestedincoinvest,717750001,False,1033,No,,
ts_coinvestimportance,717750000,False,1033,Must have,,
ts_coinvestimportance,717750001,False,1033,High importance,,
ts_coinvestimportance,717750002,False,1033,Medium importance,,
ts_coinvestimportance,717750004,False,1033,Nice to have,,
ts_coinvestimportance,717750003,False,1033,Not relevant,,
ts_lpresourcing,717750000,False,1033,Red,,
ts_lpresourcing,717750001,False,1033,Green,,
ts_lpresourcing,717750002,False,1033,-,,
ts_lpresourcing,717750003,False,1033,?,,
ts_productcommitment,717750000,False,1033,Red,,
ts_productcommitment,717750001,False,1033,Green,,
ts_productcommitment,717750002,False,1033,-,,
ts_productcommitment,717750003,False,1033,?,,
ts_onboarding,717750000,False,1033,Red,,
ts_onboarding,717750001,False,1033,Green,,
ts_onboarding,717750002,False,1033,-,,
ts_onboarding,717750003,False,1033,?,,
ts_understandsmontagu,717750000,False,1033,Red,,
ts_understandsmontagu,717750001,False,1033,Green,,
ts_understandsmontagu,717750002,False,1033,-,,
ts_understandsmontagu,717750003,False,1033,?,,
xpd_managementaccessrequiredaspartofdd,717750000,False,1033,Yes,,
xpd_managementaccessrequiredaspartofdd,717750001,False,1033,No,,
xpd_boardobserverseatrequired,717750000,False,1033,Yes,,
xpd_boardobserverseatrequired,717750001,False,1033,No,,
ts_riskreturnprofile,717750000,False,1033,Red,,
ts_riskreturnprofile,717750001,False,1033,Green,,
ts_riskreturnprofile,717750002,False,1033,-,,
ts_riskreturnprofile,717750003,False,1033,?,,
ts_managerstrategy,717750000,False,1033,Red,,
ts_managerstrategy,717750001,False,1033,Green,,
ts_managerstrategy,717750002,False,1033,-,,
ts_managerstrategy,717750003,False,1033,?,,
ts_productstrategy,717750000,False,1033,Red,,
ts_productstrategy,717750001,False,1033,Green,,
ts_productstrategy,717750002,False,1033,-,,
ts_productstrategy,717750003,False,1033,?,,
ts_lptransparency,717750000,False,1033,Red,,
ts_lptransparency,717750001,False,1033,Green,,
ts_lptransparency,717750002,False,1033,-,,
ts_lptransparency,717750003,False,1033,?,,
xpd_canprovidecounderwritingsupport,717750000,False,1033,Yes,,
xpd_canprovidecounderwritingsupport,717750001,False,1033,No,,
ts_stablecapital,717750000,False,1033,Red,,
ts_stablecapital,717750001,False,1033,Green,,
ts_stablecapital,717750002,False,1033,-,,
ts_stablecapital,717750003,False,1033,?,,
ts_importance,717750000,False,1033,1: Priority,,
ts_importance,717750001,False,1033,2: Focus,,
ts_importance,717750002,False,1033,3: Relationship,,
ts_importance,717750003,False,1033,4: Unsure,,
ts_importance,717750004,False,1033,5: Low,,
ts_potentialconcerns,717750000,False,1033,Red,,
ts_potentialconcerns,717750001,False,1033,Green,,
ts_potentialconcerns,717750002,False,1033,-,,
ts_potentialconcerns,717750003,False,1033,?,,
ts_coinvestmentapproach,717750000,False,1033,Active,,
ts_coinvestmentapproach,717750001,False,1033,Opportunistic,,
ts_coinvestmentapproach,717750002,False,1033,Low interest,,
ts_coinvestmentapproach,717750003,False,1033,Not of interest,,
ts_coinvestmentapproach,717750004,False,1033,Unknown,,
ts_otherclientupdate,717750000,False,1033,Red,,
ts_otherclientupdate,717750001,False,1033,Green,,
ts_otherclientupdate,717750002,False,1033,-,,
ts_otherclientupdate,717750003,False,1033,?,,
xpd_cansharecounderwritingdealcostsprior,717750000,False,1033,Yes,,
xpd_cansharecounderwritingdealcostsprior,717750001,False,1033,No,,
ts_interaction,717750001,False,1033,1: High,,
ts_interaction,717750000,False,1033,2: Low,,
ts_interaction,717750002,False,1033,3: Contact Established,,
ts_interaction,717750003,False,1033,4: Historic,,
ts_interaction,717750004,False,1033,5: None,,
ts_loyaltytoexistinggps,717750000,False,1033,Red,,
ts_loyaltytoexistinggps,717750001,False,1033,Green,,
ts_loyaltytoexistinggps,717750002,False,1033,-,,
ts_loyaltytoexistinggps,717750003,False,1033,?,,
ts_europeancommitment,717750000,False,1033,Red,,
ts_europeancommitment,717750001,False,1033,Green,,
ts_europeancommitment,717750002,False,1033,-,,
ts_europeancommitment,717750003,False,1033,?,,
ts_sidelettercoinvestmentinterest,717750002,False,1033,No,,
ts_sidelettercoinvestmentinterest,717750000,False,1033,Yes,,
ts_sidelettercoinvestmentinterest,717750001,False,1033,Expressed interest outside of side letter,,
mpe_aretheyinterestedindebt,717750000,False,1033,Yes,,
mpe_aretheyinterestedindebt,717750001,False,1033,No,,
ts_fundterms,717750000,False,1033,Red,,
ts_fundterms,717750001,False,1033,Green,,
ts_fundterms,717750002,False,1033,-,,
ts_fundterms,717750003,False,1033,?,,
ts_lpautonomy,717750000,False,1033,Red,,
ts_lpautonomy,717750001,False,1033,Green,,
ts_lpautonomy,717750002,False,1033,-,,
ts_lpautonomy,717750003,False,1033,?,,
ts_productallocationgrowth,717750000,False,1033,Red,,
ts_productallocationgrowth,717750001,False,1033,Green,,
ts_productallocationgrowth,717750002,False,1033,-,,
ts_productallocationgrowth,717750003,False,1033,?,,
ts_offeringstatus,717750000,False,1033,In Progress,,
ts_offeringstatus,717750001,False,1033,Completed,,
ts_offeringstatus,717750002,False,1033,Aborted,,
ts_offeringstatus,717750003,False,1033,Aborted Deal,,
ts_typeoftransactioninterestedin,717750000,False,1033,Pre syndication,,
ts_typeoftransactioninterestedin,717750001,False,1033,Post syndication,,
ts_typeoftransactioninterestedin,717750002,False,1033,Syndicated,,
ts_typeoftransactioninterestedin,717750003,False,1033,Co-underwriting,,
ts_typeoftransactioninterestedin,717750004,False,1033,Hybrid,,
ts_importance,717750000,False,1033,1: Priority,,
ts_importance,717750001,False,1033,2: Focus,,
ts_importance,717750002,False,1033,3: Relationship,,
ts_importance,717750003,False,1033,4: Unsure,,
ts_importance,717750004,False,1033,5: Low,,
ts_segment,717750000,False,1033,1: Core,,
ts_segment,717750001,False,1033,2: Hub,,
ts_segment,717750002,False,1033,3: Mega,,
ts_segment,717750003,False,1033,4: Excluded,,
ts_segment,717750004,False,1033,5: Unclassified,,
ts_interaction,717750001,False,1033,1: High,,
ts_interaction,717750000,False,1033,2: Low,,
ts_interaction,717750002,False,1033,3: Contact Established,,
ts_interaction,717750003,False,1033,4: Historic,,
ts_interaction,717750004,False,1033,5: None,,
ts_investorstatus,717750000,False,1033,Current,,
ts_investorstatus,717750001,False,1033,Potential,,
ts_investorstatus,922460000,False,1033,Potential - Distribution List,,
ts_relationship,717750000,False,1033,1: Warm,,
ts_relationship,717750001,False,1033,2: Warming,,
ts_relationship,717750002,False,1033,3: Lukewarm,,
ts_relationship,717750003,False,1033,4: Concern,,
ts_relationship,717750004,False,1033,5: None,,
ts_managerstatus,717750000,False,1033,Current,,
ts_managerstatus,717750001,False,1033,Lapsed,,
ts_productinterestedin,930580000,False,1033,Co-invest,,
ts_productinterestedin,930580001,False,1033,Continuation Vehicle,,
ts_productinterestedin,717750004,False,1033,Debt,,
ts_productinterestedin,717750000,False,1033,Europe MMB,,
ts_productinterestedin,717750001,False,1033,Infrastructure,,
ts_productinterestedin,717750002,False,1033,LTSA,,
ts_productinterestedin,717750003,False,1033,Other Region MMB,,
ts_productinterestedin,717750005,False,1033,Real Estate,,
ts_productinterestedin,717750006,False,1033,Small-cap,,
ts_productsinterestedin,930580000,False,1033,Co-invest,,
ts_productsinterestedin,930580001,False,1033,Continuation Vehicle,,
ts_productsinterestedin,717750004,False,1033,Debt,,
ts_productsinterestedin,717750000,False,1033,Europe MMB,,
ts_productsinterestedin,717750001,False,1033,Infrastructure,,
ts_productsinterestedin,717750002,False,1033,LTSA,,
ts_productsinterestedin,717750003,False,1033,Other Region MMB,,
ts_productsinterestedin,717750005,False,1033,Real Estate,,
ts_productsinterestedin,717750006,False,1033,Small-cap,,
ts_geography,717750001,False,1033,Asia,,
ts_geography,717750003,False,1033,Europe,,
ts_geography,717750005,False,1033,Latin America,,
ts_geography,717750002,False,1033,Middle East,,
ts_geography,717750000,False,1033,North America,,
ts_geography,717750004,False,1033,Other,,
ts_engagementtype,930580001,False,1033,Carve-out support,,
ts_engagementtype,717750003,False,1033,Diligence,,
ts_engagementtype,930580000,False,1033,HR,,
ts_engagementtype,717750000,False,1033,M&A Advisory,,
ts_engagementtype,717750001,False,1033,Portfolio Support,,
ts_engagementtype,930580003,False,1033,Project,,
ts_engagementtype,717750002,False,1033,Talent,,
ts_engagementtype,930580002,False,1033,Transformation Team,,
xpd_firmtype,930580000,False,1033,Search Firm,,
xpd_firmtype,930580001,False,1033,Referencing Supplier,,
xpd_firmtype,930580002,False,1033,Assessment Provider,,
xpd_invitationresponse,930580000,False,1033,Invited,,
xpd_invitationresponse,930580001,False,1033,Accepted,,
xpd_invitationresponse,930580002,False,1033,Declined,,
xpd_invitationresponse,930580003,False,1033,Tentative,,
xpd_invitationresponse,930580004,False,1033,Responded,,
xpd_invitationresponse,930580005,False,1033,No Response,,
xpd_eventattendance,930580000,False,1033,Attended,,
xpd_eventattendance,930580001,False,1033,Not Attended,,
xpd_invitationround,930580000,False,1033,First,,
xpd_invitationround,930580001,False,1033,Second,,
xpd_invitationround,930580002,False,1033,Third,,
xpd_invitationround,930580003,False,1033,Fourth,,
xpd_invitationround,930580004,False,1033,Fifth,,
xpd_invitationroundmultiselect,930580000,False,1033,First,,
xpd_invitationroundmultiselect,930580001,False,1033,Second,,
xpd_invitationroundmultiselect,930580002,False,1033,Third,,
xpd_invitationroundmultiselect,930580003,False,1033,Fourth,,
xpd_invitationroundmultiselect,930580004,False,1033,Fifth,,
xpd_recommendation,930580000,False,1033,Preferred Supplier,,
xpd_recommendation,930580001,False,1033,Recommended,,

account_results table

ts_easeofworking,ts_companytype,ts_companytype_expected
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007;717750012,Investor Group;Gatekeeper
,717750013,PE Firm
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,,
,,
,,
,717750001,Target
,717750001,Target
,,
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,,
,,
,,
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750007;717750012,Investor Group;Gatekeeper
,717750013,PE Firm
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001;717750005,Target;Talent Source
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,,
,,
,,
,,
,,
,,
,717750001,Target
,717750001,Target
,,
,,
,,
,,
,717750000,Deal Introducer
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000;717750001,Deal Introducer;Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,,
,,
,,
,,
,717750001;717750003,Target;Diligence
,,
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,,
,717750001,Target
,,
,,
,,
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750009,Corporate
,,
,717750001,Target
,,
,717750001,Target
,,
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
"1 - Open, transparent, responsive",717750007;717750012,Investor Group;Gatekeeper
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,,
,717750007,Investor Group
,717750001,Target
,,
,717750013,PE Firm
,,
,,
,717750013,PE Firm
,,
,717750003,Diligence
,717750001,Target
,717750000,Deal Introducer
,,
,,
,,
,717750007,Investor Group
,,
,,
,717750001,Target
,717750000;717750005,Deal Introducer;Talent Source
,717750001,Target
,717750001,Target
,,
,,
,717750000,Deal Introducer
,,
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750000;717750005,Deal Introducer;Talent Source
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750013,PE Firm
,717750005,Talent Source
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750002,Vendor
,717750007;717750013,Investor Group;PE Firm
,717750001;717750007,Target;Investor Group
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007;717750013,Investor Group;PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000;717750002;717750010,Deal Introducer;Vendor;M&A Advisory
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001;717750002,Target;Vendor
,717750001;717750002,Target;Vendor
,717750001,Target
,717750001,Target
,717750004,Portfolio Support
,717750002,Vendor
,717750001;717750007,Target;Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001;717750002;717750013,Target;Vendor;PE Firm
,717750001,Target
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750001,Target
,717750000;717750001,Deal Introducer;Target
,717750001,Target
,717750001,Target
,717750003,Diligence
,717750002,Vendor
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750003,Diligence
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750002,Vendor
,717750016,Excluded
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750000;717750010,Deal Introducer;M&A Advisory
,717750000;717750010,Deal Introducer;M&A Advisory
,717750000;717750001,Deal Introducer;Target
,717750000;717750010,Deal Introducer;M&A Advisory
,717750000;717750010,Deal Introducer;M&A Advisory
,717750000;717750010,Deal Introducer;M&A Advisory
,717750000;717750010,Deal Introducer;M&A Advisory
,717750000;717750002;717750010,Deal Introducer;Vendor;M&A Advisory
,717750000;717750010,Deal Introducer;M&A Advisory
,717750000;717750010,Deal Introducer;M&A Advisory
,717750000;717750010,Deal Introducer;M&A Advisory
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750000,Deal Introducer
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750016,Excluded
,717750016,Excluded
,717750000,Deal Introducer
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750000;717750005,Deal Introducer;Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750000;717750001,Deal Introducer;Target
,717750001,Target
,717750001,Target
,717750000;717750001,Deal Introducer;Target
,717750000;717750001,Deal Introducer;Target
,717750007,Investor Group
,717750007;717750012,Investor Group;Gatekeeper
,717750013,PE Firm
,717750001,Target
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750007,Investor Group
,717750009,Corporate
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750012,Gatekeeper
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750013,PE Firm
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750007;717750012,Investor Group;Gatekeeper
,717750001,Target
,717750001,Target
,717750001,Target
,717750003,Diligence
,717750003,Diligence
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750004,Portfolio Support
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750005,Talent Source
,717750002,Vendor
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750001,Target
,717750000;717750003;717750010,Deal Introducer;Diligence;M&A Advisory
,717750000;717750003,Deal Introducer;Diligence
,717750001,Target
,717750000;717750003;717750010,Deal Introducer;Diligence;M&A Advisory
,717750001,Target
,717750001,Target
,717750003;717750004,Diligence;Portfolio Support
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750012,Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750012,Gatekeeper
,717750007,Investor Group
,717750001,Target
,717750009,Corporate
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750012,Gatekeeper
,717750001,Target
,717750009,Corporate
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007;717750012,Investor Group;Gatekeeper
,717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007;717750012,Investor Group;Gatekeeper
,717750007;717750012,Investor Group;Gatekeeper
,717750012,Gatekeeper
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007;717750014,Investor Group;Placement Agent
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750002,Vendor
,717750007;717750014,Investor Group;Placement Agent
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750002,Vendor
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001;717750007,Target;Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001;717750007,Target;Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750008,Target;Portfolio Company
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007;717750012,Investor Group;Gatekeeper
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750008,Portfolio Company
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007;717750015,Investor Group;Investor Reporting
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007;717750012,Investor Group;Gatekeeper
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,930580000,HR Recruiter
,717750016,Excluded
,717750004;717750009,Portfolio Support;Corporate
,930580000,HR Recruiter
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,930580000,HR Recruiter
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750009,Corporate
,717750001,Target
,717750016,Excluded
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001;717750005,Target;Talent Source
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750016,Excluded
,930580000,HR Recruiter
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750003;717750010,Diligence;M&A Advisory
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,930580000,HR Recruiter
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005;930580000,Talent Source;HR Recruiter
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750005,Talent Source
,717750002,Vendor
,717750005,Talent Source
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750005,Talent Source
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750010,M&A Advisory
,717750016,Excluded
,717750005,Talent Source
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750013,PE Firm
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750002,Vendor
,717750001,Target
,717750007,Investor Group
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750009,Corporate
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750002,Vendor
,717750016,Excluded
,717750016,Excluded
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750011,Debt Provider
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750003,Diligence
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750010,M&A Advisory
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750010,M&A Advisory
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750000;717750003,Deal Introducer;Diligence
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,930580000,HR Recruiter
,717750016,Excluded
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750005,Talent Source
,717750005,Talent Source
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750013,PE Firm
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750002;717750003,Vendor;Diligence
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750010,M&A Advisory
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750005;930580000,Talent Source;HR Recruiter
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,930580000,HR Recruiter
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750006,717750006
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005;930580000,Talent Source;HR Recruiter
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750007,Investor Group
,717750001,Target
,717750002,Vendor
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750007,Investor Group
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750002,Vendor
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750016,Excluded
,717750000,Deal Introducer
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750016,Excluded
,717750001,Target
,717750001,Target
,930580000,HR Recruiter
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750001,Target
,717750007;717750012,Investor Group;Gatekeeper
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750007,Investor Group
,717750004,Portfolio Support
,717750002,Vendor
,717750002,Vendor
,717750007,Investor Group
,717750007;717750012,Investor Group;Gatekeeper
,,
,,
,,
,,
,717750001;717750002,Target;Vendor
,,
,,
,,
,,
,,
,717750001,Target
,,
,,
,,
,,
,,
,,
,,
,,
,717750007,Investor Group
,,
,717750007,Investor Group
,,
,717750007,Investor Group
,,
,717750007,Investor Group
,717750007,Investor Group
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,717750000,Deal Introducer
,,
,,
,717750001,Target
,,
,,
,,
,717750007,Investor Group
,717750007,Investor Group
,,
,,
,,
,717750007,Investor Group
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,717750007,Investor Group
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,717750001,Target
,,
,,
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,,
,,
,,
,717750004,Portfolio Support
,,
,,
,,
,,
,,
,,
,,
,,
,,
,,
,717750001,Target
,,
,,
,,
,,
,,
,,
,717750001,Target
,,
,717750001,Target
,,
,,
,,
,,
,,
,,
,,
,,
,717750001;717750008,Target;Portfolio Company
,717750001;717750008,Target;Portfolio Company
,717750001;717750008,Target;Portfolio Company
,717750007,Investor Group
,717750007,Investor Group
,,
,,
,,
,,
,717750001,Target
,,
,,
,,
,,
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750008,Target;Portfolio Company
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,,
,717750001,Target
,,
,717750001,Target
,,
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,,
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750005,Talent Source
,717750001,Target
,,
,,
,,
,,
,717750001,Target
,,
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000;717750010,Deal Introducer;M&A Advisory
,717750001,Target
,717750001,Target
,717750001,Target
,717750000;717750001;717750002,Deal Introducer;Target;Vendor
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,,
,,
,717750004,Portfolio Support
,,
,,
,,
,,
,,
,717750004,Portfolio Support
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,,
,,
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750011,Debt Provider
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750013,PE Firm
,717750013,PE Firm
,717750001,Target
,717750000;717750005;717750010,Deal Introducer;Talent Source;M&A Advisory
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000;717750010,Deal Introducer;M&A Advisory
,717750000;717750010,Deal Introducer;M&A Advisory
,717750001,Target
,717750001,Target
,717750003;717750010,Diligence;M&A Advisory
,717750016,Excluded
,717750001,Target
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750006;717750011,717750006;Debt Provider
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001;717750007,Target;Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001;717750007,Target;Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750009,Corporate
,717750001,Target
,717750001,Target
,717750001,Target
,717750010,M&A Advisory
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000;717750010,Deal Introducer;M&A Advisory
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750005,Talent Source
,717750004,Portfolio Support
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750008,Target;Portfolio Company
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750001,Target
,717750003,Diligence
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750000;717750010,Deal Introducer;M&A Advisory
,717750001,Target
,717750005;930580000,Talent Source;HR Recruiter
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000;717750002,Deal Introducer;Vendor
,717750013,PE Firm
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750007,Investor Group
,717750001,Target
,717750001;717750002,Target;Vendor
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750002,Vendor
,717750001,Target
,717750003,Diligence
,717750001,Target
,717750004,Portfolio Support
,717750004;717750010,Portfolio Support;M&A Advisory
,717750004,Portfolio Support
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750002;717750004,Vendor;Portfolio Support
,717750004,Portfolio Support
,717750002;717750003;717750010,Vendor;Diligence;M&A Advisory
,717750005,Talent Source
,717750000,Deal Introducer
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750000;717750010,Deal Introducer;M&A Advisory
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007;717750012,Investor Group;Gatekeeper
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750009,Corporate
,717750001,Target
,717750001,Target
,717750001,Target
,930580000,HR Recruiter
,717750000,Deal Introducer
,717750009,Corporate
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,930580000,HR Recruiter
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750010,M&A Advisory
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,930580000,HR Recruiter
,717750000,Deal Introducer
,717750005,Talent Source
,717750004,Portfolio Support
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007;717750012,Investor Group;Gatekeeper
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750009,Corporate
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750005,Target;Talent Source
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007;717750015,Investor Group;Investor Reporting
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750007;717750015,Investor Group;Investor Reporting
,717750001,Target
,717750009,Corporate
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750007,Target;Investor Group
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750010,M&A Advisory
,930580000,HR Recruiter
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750009;717750010,Corporate;M&A Advisory
,717750016,Excluded
,717750016,Excluded
,717750010,M&A Advisory
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750009,Corporate
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001;717750007,Target;Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750000,Deal Introducer
,717750005,Talent Source
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,930580000,HR Recruiter
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750000,Deal Introducer
,717750001;717750005,Target;Talent Source
,717750001;717750005,Target;Talent Source
,717750001;717750005,Target;Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,930580000,HR Recruiter
,717750005,Talent Source
,930580000,HR Recruiter
,717750001;717750005,Target;Talent Source
,717750016,Excluded
,717750005,Talent Source
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750005,Talent Source
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,930580000,HR Recruiter
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750016,Excluded
,717750013,PE Firm
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750001;717750002,Target;Vendor
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750003;717750004,Diligence;Portfolio Support
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750013,PE Firm
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,930580000,HR Recruiter
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750000;717750003,Deal Introducer;Diligence
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007;717750013,Investor Group;PE Firm
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750016,Excluded
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750007;717750013,Investor Group;PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750000,Deal Introducer
,717750016,Excluded
,717750016,Excluded
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750016,Excluded
,717750007,Investor Group
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750016,Excluded
,930580000,HR Recruiter
,930580000,HR Recruiter
,717750001,Target
,930580000,HR Recruiter
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750007,Investor Group
,717750007,Investor Group
,717750014,Placement Agent
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750013,PE Firm
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750005,Talent Source
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750007,Investor Group
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750002,Vendor
,717750005,Talent Source
,717750005,Talent Source
,717750016,Excluded
,717750005,Talent Source
,717750005,Talent Source
,717750016,Excluded
,717750001,Target
,717750014,Placement Agent
,717750014,Placement Agent
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750002,Vendor
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750002,Vendor
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750007,Investor Group
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750007,Investor Group
,717750016,Excluded
,717750016,Excluded
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750004,Portfolio Support
,717750003;717750004;717750005,Diligence;Portfolio Support;Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750007;717750012,Investor Group;Gatekeeper
,717750007;717750012,Investor Group;Gatekeeper
,717750013,PE Firm
,717750014,Placement Agent
,717750001,Target
,717750005,Talent Source
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750005,Target;Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,,
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001;717750002;717750013,Target;Vendor;PE Firm
,717750007,Investor Group
,717750002;717750013,Vendor;PE Firm
,717750002;717750013,Vendor;PE Firm
,717750002;717750013,Vendor;PE Firm
,717750001,Target
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750002;717750013,Vendor;PE Firm
,717750002;717750013,Vendor;PE Firm
,717750002;717750013,Vendor;PE Firm
,717750002;717750013,Vendor;PE Firm
,717750002;717750013,Vendor;PE Firm
,717750002;717750013,Vendor;PE Firm
,717750002;717750013,Vendor;PE Firm
,717750002;717750013,Vendor;PE Firm
,717750002;717750013,Vendor;PE Firm
,717750001,Target
,717750001,Target
,717750000;717750005;717750010;717750014,Deal Introducer;Talent Source;M&A Advisory;Placement Agent
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750004,Portfolio Support
,717750001,Target
,717750013,PE Firm
,717750016,Excluded
,717750007,Investor Group
,717750001,Target
,717750007,Investor Group
,717750009,Corporate
,717750001,Target
,717750001,Target
,717750001,Target
,717750009,Corporate
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750009,Corporate
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750004,Portfolio Support
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750005,Talent Source
,717750004;717750005,Portfolio Support;Talent Source
,717750001,Target
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750005,Talent Source
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750003,Diligence
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750011,Debt Provider
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750003,Diligence
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750003,Diligence
,717750002,Vendor
,717750001,Target
,717750004,Portfolio Support
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750016,Excluded
,717750016,Excluded
,717750016,Excluded
,717750001,Target
,717750001,Target
,717750011,Debt Provider
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750001,Target
,717750003,Diligence
,717750016,Excluded
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750003;717750004,Diligence;Portfolio Support
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750010,M&A Advisory
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750001,Target
,717750014,Placement Agent
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001;717750002,Target;Vendor
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750002,Vendor
,717750001,Target
,930580000,HR Recruiter
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,930580000,HR Recruiter
,930580000,HR Recruiter
,717750013,PE Firm
,717750001,Target
,717750001,Target
,717750001,Target
,930580000,HR Recruiter
,930580000,HR Recruiter
,930580000,HR Recruiter
,930580000,HR Recruiter
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750007,Investor Group
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750002,Vendor
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000;717750010,Deal Introducer;M&A Advisory
,717750007,Investor Group
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750001,Target
,717750000,Deal Introducer
,717750000,Deal Introducer
,930580000,HR Recruiter
,930580000,HR Recruiter

I hope I have covered everything to make it easy for someone to help me

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135368 More actions · Answer 1

did you try adding an OUTER APPLY ( with e.g. DelimitedSplit8K or string_split ) to your queries to handle the multi valued column ?

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

carlton 84646 Ten Centuries Points: 1026 More actions · Answer 2

Hi Johan Bijnens,

Thanks for reaching out.

Can you provide a sample of where I would add your code to the script?

Johan Bijnens SSC Guru Points: 135368 More actions · Answer 3

Read this:

Author Jeff Moden - Article: Tally OH! An Improved SQL 8K “CSV Splitter” Function, http://www.sqlservercentral.com/articles/Tally+Table/72993/

Example query:

SELECT ACC.ts_easeofworking
      , GOM.ts_easeofworking
      , ACC.ts_companytype 
      , GOM.ts_companytype [ts_companytype_multi_valued_string]
      , Splitter.ItemNumber
      , Splitter.Item
   FROM GlobalOptionsetMetadata GOM

  CROSS APPLY dbo.DelimitedSplit8k(GOM.ts_companytype,';') Splitter

   INNER JOIN account ACC
     ON ACC.ts_easeofworking = GOM.ts_easeofworking
      AND ACC.ts_companytype = Splitter.Item

This reply was modified 2 years, 4 months ago by Johan Bijnens.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

carlton 84646 Ten Centuries Points: 1026 More actions · Answer 4

Hi Johan Bijnens

I have been reading Jeff Moden's article for over an hour, and I must say I'm struggling to understand it.

I'm also struggling getting to grips with your sample code.

carlton 84646 Ten Centuries Points: 1026 More actions · Answer 5

I am essentially asking for help modifying the script to achieve the results I have set out above

carlton 84646 Ten Centuries Points: 1026 More actions · Answer 6

You're sample focuses on a table 'account' whereas the only tables the script focuses on are

'OptionsetMetadata'', ''GlobalOptionsetMetadata'',''StateMetadata'',''StatusMetadata'', ''TargetMetadata'

However, in order to make things simple, I am just referring to GlobalOptionsetMetadata. The script would automatically run on any table in the database.

Am I making sense?

carlton 84646 Ten Centuries Points: 1026 More actions · Answer 7

I really don't think it's as easy as modifying the script with CROSS APPLY - not that I would know where to make the amendment on the script

carlton 84646 Ten Centuries Points: 1026 More actions · Answer 8

Hi Community,

What I'm about to ask might sound a little crass, as I know members of this forum provide their time free-of-charge, however I'm a little desperate to find solution for this request. Therefore, I'm willing to donate funds to a charity of your choice if you could put in a little extra effort to help me resolve this issue.

Again, sorry if the above statement is inappropriate for a free members site.

Ed B Hall of Fame Points: 3665 More actions · Answer 9

I had a go at creating some sample data based on your text files dumps. Please correct the script so that it has the right columns with the right data, then I imagine someone will be able to help you.

I'm not sure whether it is the account table or the options table that has the multi-value column. Whichever it it, it seems like you need to parse that out into separate rows to create a one to one to many, and then use that to join the two tables. I think this is what Johan illustrated above.

CREATE TABLE dbo.GlobalOptionsetMetadata
(
  OptionSetName VARCHAR(100),
  [Option] VARCHAR(100),
  IsUserLocalizedLabel VARCHAR(100),
  LocalizedLabelLanguageCode VARCHAR(100),
  LocalizedLabel VARCHAR(100),
  GlobalOptionSetName VARCHAR(100),
  EntityName VARCHAR(100)
)

INSERT dbo.GlobalOptionsetMetadata VALUES 
('ts_companytype','717750000','False','1033','Deal Introducer','',''),
('ts_companytype','717750006','False','1033','Debt Advisory','',''),
('ts_companytype','717750011','False','1033','Debt Provider','',''),
('ts_companytype','717750003','False','1033','Diligence','',''),
('ts_companytype','717750016','False','1033','Excluded','',''),
('ts_companytype','717750012','False','1033','Gatekeeper','',''),
('ts_companytype','930580000','False','1033','HR Recruiter','',''),
('ts_companytype','717750007','False','1033','Investor Group','',''),
('ts_companytype','717750015','False','1033','Investor Reporting','',''),
('ts_companytype','717750010','False','1033','M&A Advisory','',''),
('ts_companytype','717750009','False','1033','Montagu Supplier','',''),
('ts_companytype','717750013','False','1033','PE Firm','',''),
('ts_companytype','717750014','False','1033','Placement Agent','',''),
('ts_companytype','717750008','False','1033','Portfolio Company','',''),
('ts_companytype','717750004','False','1033','Portfolio Support','',''),
('ts_companytype','717750005','False','1033','Talent Source','',''),
('ts_companytype','717750001','False','1033','Target','',''),
('ts_companytype','717750002','False','1033','Vendor','','')

CREATE TABLE dbo.account
( 
  ts_easeofworking VARCHAR(100),
  ts_companytype VARCHAR(100)
)

INSERT dbo.account VALUES
('', '717750000;717750002;717750013'),
('', '717750007;717750012'),
('', '717750001;717750005'),
('', '717750001;717750003'),
('', '717750001')

carlton 84646 Ten Centuries Points: 1026 More actions · Answer 10

Ed B, thanks for creating the tables.

Not sure what you mean "Please correct the script so that it has the right columns with the right data"

The script is untouched...

carlton 84646 Ten Centuries Points: 1026 More actions · Answer 11

Ed B,

Now, that you have provided sample data, I'm really hoping someone can help out - this is a tough request

carlton 84646 Ten Centuries Points: 1026 More actions · Answer 12

Ed B

I just realised that the following additonal sample tables will be required in order for someone to help me, because if someone executes the script it will be looking for the following tables.

CREATE TABLE StateMetadata (
    EntityName varchar(100),
    State int,
    IsUserLocalizedLabel bit,
    LocalizedLabelLanguageCode int,
    LocalizedLabel varchar(50))

INSERT StateMetadata VALUES
('account',0,CONVERT(bit, 'False'),1033,'Active'),
('account',1,CONVERT(bit, 'False'),1033,'Inactive'),
('connection',0,CONVERT(bit, 'False'),1033,'Active'),
('connection',1,CONVERT(bit, 'False'),1033,'Inactive'),
('appointment',0,CONVERT(bit, 'False'),1033,'Open'),
('appointment',1,CONVERT(bit, 'False'),1033,'Completed')

CREATE TABLE StatusMetadata (
    EntityName varchar(50),
    State int,
    Status int,
    IsUserLocalizedLabel bit,
    LocalizedLabelLanguageCode int,
    LocalizedLabel varchar(50))

INSERT StatusMetadata VALUES
('account',0,1,CONVERT(bit, 'False'),1033,'Active'),
('account',1,2,CONVERT(bit, 'False'),1033,'Inactive'),
('connection',0,1,CONVERT(bit, 'False'),1033,'Active'),
('connection',1,2,CONVERT(bit, 'False'),1033,'Inactive'),
('appointment',0,1,CONVERT(bit, 'False'),1033,'Free'),
('appointment',0,2,CONVERT(bit, 'False'),1033,'Tentative'),
('appointment',1,3,CONVERT(bit, 'False'),1033,'Completed'),
('appointment',2,4,CONVERT(bit, 'False'),1033,'Canceled'),
('appointment',3,5,CONVERT(bit, 'False'),1033,'Busy'),
('appointment',3,6,CONVERT(bit, 'False'),1033,'Out of Office'),
('email',0,1,CONVERT(bit, 'False'),1033,'Draft'),
('email',1,2,CONVERT(bit, 'False'),1033,'Completed'),
('email',1,3,CONVERT(bit, 'False'),1033,'Sent')

SELECT * FROM StatusMetadata

CREATE TABLE TargetMetadata (
    EntityName varchar(50),
    AttributeName varchar(50),
    ReferencedEntity varchar(50),
    ReferencedAttribute varchar(50))

INSERT TargetMetadata VALUES
('activityparty','partyid','ts_boardmember','ts_boardmemberid'),
('activityparty','activityid','activitypointer','activityid'),
('activityparty','ownerid','systemuser',NULL),
('activityparty','ownerid','team',NULL),
('account','parentaccountid','account',NULL),
('account','ts_recommendedby','systemuser','systemuserid'),
('account','ts_countryofeconomicoriginforthecapital','ts_country','ts_countryid'),
('account','xpd_reminderto','systemuser','systemuserid'),
('account','preferredserviceid','service','serviceid'),
('account','msdyn_segmentid','msdyn_segment','msdyn_segmentid')

SELECT * FROM TargetMetadata

This reply was modified 2 years, 4 months ago by carlton 84646. Reason: update

Ed B Hall of Fame Points: 3665 More actions · Answer 13

carlton 84646 wrote:

Not sure what you mean "Please correct the script so that it has the right columns with the right data"
.

I meant correct any mistakes I may have made in the create table script, like should there be values in the ts_easeofworking column of the account table? or should there be more columns? or should any of the columns be integers? if it matters.

The Account view resolves to just this. What is it that you want it to do? if it has ts_companytype = '717750001;717750002' do you want to see ''Target;Vendor'?

SELECT [Base].[ts_easeofworking]
,[Base].[ts_companytype]
FROM [dbo].[account] AS Base

carlton 84646 Ten Centuries Points: 1026 More actions · Answer 14

ED B

"What is it that you want it to do? if it has ts_companytype = '717750001;717750002' do you want to see ''Target;Vendor'?"

Yes, yes, yes, yes .... Ed B, you understand. This is great. If you understand then it means others in this community will understand too.

I'm starting to feel encouraged 🙂