<dataSource>

            <tables>
                <table name="SourceTable" uniqueRef="Master_ID" />
            </tables>

			
            <fieldMappings>
			
                <fieldMapping DefaultField="FullName" databaseField="" />
                <fieldMapping DefaultField="Prefix" databaseField="" />
                <fieldMapping DefaultField="LastName" databaseField="Surname" />
                <fieldMapping DefaultField="FirstNames" databaseField="Forename" />
                <fieldMapping DefaultField="Initials" databaseField="" />
                <fieldMapping DefaultField="Qualification" databaseField="Title" />
                <fieldMapping DefaultField="Suffix" databaseField="" />
                <fieldMapping DefaultField="Organization" databaseField="OrganisationName" />
                <fieldMapping DefaultField="Department" databaseField="" />
                <fieldMapping DefaultField="JobTitle" databaseField="" />
                <fieldMapping DefaultField="Address1" databaseField="Address_Line1" />
                <fieldMapping DefaultField="Address2" databaseField="Address_Line2" />

            </fieldMappings>

        </dataSource>

<fieldMapping DefaultField="Lastname" databaseField="Surname" IsPartOfUniqueCriteria="true">

DECLARE @mkNameKeySELECTString NVARCHAR(100)
		DECLARE @mkName1SELECTString NVARCHAR(100)
		DECLARE @mkName2SELECTString NVARCHAR(100)
		DECLARE @mkName3SELECTString NVARCHAR(100)
		
		
		-- If we already have First and Last names then there is no need to split the names
		IF EXISTS (SELECT 1 FROM dbo.FieldMappings WHERE StagingColumn = 'FirstNames')
		AND EXISTS (SELECT 1 FROM dbo.FieldMappings WHERE StagingColumn =  'LastName')
			BEGIN
			
				SET @mkNameKeySELECTString = 'dbo.NYSIISPhoneticEncoder(dbo.GetLastWord(' + dbo.GetSourceColumnName('LastName') + ')) + LEFT(' + dbo.GetSourceColumnName('FirstNames') + ', 1)'
				SELECT @mkNameKeySELECTString as mkName1
				
				SET @mkName1SELECTString = 'dbo.NYSIISPhoneticEncoder(dbo.GetFirstWord(' + dbo.GetSourceColumnName('Firstnames') + '))'
				SELECT @mkName1SELECTString as mkName2
				
				SET @mkName2SELECTString = 'dbo.NYSIISPhoneticEncoder(dbo.GetSecondWord(' + dbo.GetSourceColumnName('FirstNames') + '))'
				SELECT @mkName2SELECTString as mkName3
				
			END