text: /*  
  *	Content in the the current ExpressionAssociationRefset snapshot file must be in the current full file
  */
  	insert into qa_result (runid, assertionuuid, concept_id, details)
  	select 
  		<RUNID>,
  		'<ASSERTIONUUID>',
  		a.referencedcomponentid,
  		concat('ExpressionAssociationRefset: id=',a.id, ' is in SNAPSHOT file, but not in FULL file.') 	
  	from curr_expressionAssociationRefset_s a
  	left join curr_expressionAssociationRefset_f b
  		on a.id = b.id
  		and a.effectivetime = b.effectivetime
  		and a.active = b.active
  		and a.moduleid = b.moduleid
  		and a.refsetid = b.refsetid
  		and a.referencedcomponentid = b.referencedcomponentid
  		and a.mapTarget = b.mapTarget
  		and a.expression = b.expression
  		and a.definitionStatusId = b.definitionStatusId
  		and a.correlationId = b.correlationId
  		and a.contentOriginId = b.contentOriginId
  	where 
  		b.id is null
  		or b.effectivetime is null
  		or b.active is null
  		or b.moduleid is null
  		or b.refsetid is null
  		or b.referencedcomponentid is null
  		or b.mapTarget is null
  		or b.expression is null
  		or b.definitionStatusId is null
  		or b.correlationId is null
  		or b.contentOriginId is null;
  commit;
  
  
  insert into qa_result (runid, assertionuuid, concept_id, details)
  	select 
  		<RUNID>,
  		'<ASSERTIONUUID>',
  		a.referencedcomponentid,
  		concat('ExpressionAssociationRefset: id=',a.id, ' is in FULL file, but not in SNAPSHOT file.') 	
  	from curr_expressionAssociationRefset_f a
  	left join curr_expressionAssociationRefset_s b
  		on a.id = b.id
  		and a.effectivetime = b.effectivetime
  		and a.active = b.active
  		and a.moduleid = b.moduleid
  		and a.refsetid = b.refsetid
  		and a.referencedcomponentid = b.referencedcomponentid
  		and a.mapTarget = b.mapTarget
  		and a.expression = b.expression
  		and a.definitionStatusId = b.definitionStatusId
  		and a.correlationId = b.correlationId
  		and a.contentOriginId = b.contentOriginId
  	where 
  	 cast(a.effectivetime as datetime) = 
  		(select max(cast(z.effectivetime as datetime))
  		 from curr_expressionAssociationRefset_f z
  		 where z.id = a.id)
  	and
  		( b.id is null
  		or b.effectivetime is null
  		or b.active is null
  		or b.moduleid is null
  		or b.refsetid is null
  		or b.referencedcomponentid is null
  		or b.mapTarget is null
  		or b.expression is null
  		or b.definitionStatusId is null
  		or b.correlationId is null
  		or b.contentOriginId is null);
  commit;