#qmd_batch.resultsText#

#utl_mergeMDMDuplicates_result.mergeCount# Duplicates Resolved

#utl_mergeMDMDuplicates_result.html# #qmd_batch.resultsText# select distinct affiliation_orgName from tbl_IMPORT_OperatorMasterData where ownerId = and ownerType = and eai_batchId = select oprCompanyType, operatorId, companyName from tbl_OPR_CLientOperators where ( companyName = or dbaName = ) and oprCompanyType in ( 'G', 'C' ) and ownerId = and crmActive = 'Y' and fsltablecode = and 1 = 2 select fieldid from tbl_OPR_Fields where ownerid = and ownertype = and name LIKE 'feast_id' select fieldid from tbl_OPR_Fields where ownerid = and ownertype = and name LIKE 'CBS_Thruputs' select eai_lineNumber, system_id, mdm_type, mdm_id, company_name, dba_name, company_address1, company_address2, company_city, company_state, company_zip, company_phone, company_fax, company_url, company_segment, affiliation_orgName, affiliate_nbr, affiliate_date, feast_id, cbs_thruputs from tbl_IMPORT_OperatorMasterData where ownerId = and ownerType = and eai_batchId = select clientSegId from tbl_OPR_ClientSegments where ownerId = and fsl_tablecode = and clientSegLevel = 2 and description = select cs.clientSegId from tbl_IMPORT_Aliases a inner join tbl_OPR_ClientSegments cs on cs.clientSegId = a.objectId and cs.ownerId = a.ownerId and cs.fsl_tablecode = a.ownerType and cs.clientSegLevel = 2 where a.objectType = 'ClientOperatorSegments' and a.ownerId = and a.ownerType = and a.alias = select clientSegId from tbl_OPR_ClientSegments where ownerId = and fsl_tablecode = and clientSegLevel = 1 and description = '#_unclassifiedDesc#' insert into tbl_OPR_ClientSegments ( ownerId, fsl_tablecode, segmentId, description, sortRank, clientSegLevel, commercial, segAbbrv ) values( #qmd_batch.ownerid#, '#qmd_batch.ownerType#', 0, '#_unclassifiedDesc#', 999, 1, 'Y', '#mdm_type#' ) insert into tbl_OPR_ClientSegments ( ownerId, fsl_tablecode, segmentId, description, sortRank, clientSegLevel, parentClientSegId, commercial ) values( #qmd_batch.ownerId#, '#qmd_batch.ownerType#', 0, , 999, 2, #_parentSegmentId#, 'Y' ) update tbl_OPR_ClientOperators set mdmId = , mdmDate = , mdmType = , mdmCompanyName = , lastUpdated = , address = , city = , state = , zipCode = , dbaName = , address2 = , phone = , URL = , oprSegment = where operatorId = update tbl_OPR_FieldValues set data = where fieldid = and partnerid = and partnerType = 'OPR' select ValueId from tbl_OPR_FieldValues where fieldid = and partnerid = and partnerType = 'OPR' insert into tbl_OPR_FieldValues (FieldID,partnerID,PartnerType,Data,ValueIndex) values(, ,'OPR', ,1) update tbl_OPR_FieldValues set data = where fieldid = and partnerid = and partnerType = 'OPR' insert into tbl_OPR_FieldValues (FieldID,partnerID,PartnerType,Data,ValueIndex) values(, ,'OPR', ,1) update tbl_CRM_Affiliations set affiliationStatus = 'A', deaffiliationDate = null, sourceId = , sourceType = 'MDM', affiliationDate = , partnerAffiliateNbr = , affiliationType = 'GPO''CMC' where orgId = and orgType = 'OPR' and partnerId = and partnerType = 'OPR' and ownerId = and ownerType = insert into tbl_CRM_Affiliations ( ownerId, ownertype, orgId, orgType, affiliationType, affiliationStatus, sourceId, sourceType, affiliationDate, partnerAffiliateNbr, partnerId, partnerType ) values ( , , , 'OPR', 'GPO''CMC', 'A', , 'MDM', , , , 'OPR' ) update tbl_IMPORT_OperatorMasterData set fseStatus = 'Y' where ownerType = and ownerId = and eai_batchId = and eai_lineNumber =

Affiliations
Affiliation	Status
#htmleditformat( affiliation_orgName )#	Contact Management CompanyGroup Purchasing Organization Not Found^***

^***When an affiliation is not found, it is ignored. The operator profile record is still updated but this affiliation reference is not made.