text: 
  /*
  	The current full MRCM Attribute Range Refset file consists of the previously published full file and the changes for the current release
  */
  	insert into qa_result (runid, assertionuuid, concept_id, details)
  	select 
  	<RUNID>,
  	'<ASSERTIONUUID>',
  	a.referencedcomponentid,
  	concat('Mrcm Attribute Range Refset: id=',a.id, ' is in current full file, but not in prior full or current delta file.')
  	from curr_mrcmAttributeRangeRefset_f a
  	left join curr_mrcmAttributeRangeRefset_d 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.rangeconstraint = b.rangeconstraint
  		and a.attributerule = b.attributerule
  		and a.rulestrengthid = b.rulestrengthid
  		and a.contenttypeid = b.contenttypeid
  	left join prev_mrcmAttributeRangeRefset_f c
  		on a.id = c.id
  		and a.effectivetime = c.effectivetime
  		and a.active = c.active
  		and a.moduleid = c.moduleid
  		and a.refsetid = c.refsetid
  		and a.referencedcomponentid = c.referencedcomponentid
  		and a.rangeconstraint = c.rangeconstraint
  		and a.attributerule = c.attributerule
  		and a.rulestrengthid = c.rulestrengthid
  		and a.contenttypeid = c.contenttypeid
  	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.rangeconstraint is null
          or b.attributerule is null
          or b.rulestrengthid is null
          or b.contenttypeid is null)
  		and ( c.id is null
          or c.effectivetime is null
          or c.active is null
          or c.moduleid is null
          or c.refsetid is null
          or c.referencedcomponentid is null
          or c.rangeconstraint is null
          or c.attributerule is null
          or c.rulestrengthid is null
          or c.contenttypeid is null);
  commit;
  
  
  