Sequence of Deleting Configuration Records to Allow Laboratory Deletion

The following configuration records must be deleted to allow for laboratory deletion, in this suggested sequence:

  • Reports where CCREPORT.LABORATORY.ID = CCLABORATORY.ID

  • QC history observations where where CCQCHISTORY.LABORATORY.ID = CCLABORATORY.ID

  • Instrument schedules where CCINSTRUMENTSCHEDULE.LABORATORY.ID = CCLABORATORY.ID

  • Instrument file uploads where CCINSTFILEUPLOAD.LABORATORY.ID = CCLABORATORY.ID

  • Holidays where CCHOLIDAY.LABORATORY.ID = CCLABORATORY.ID

  • Products where CCPRODUCT.LABORATORY.ID = CCLABORATORY.ID

  • Quotes where CCQUOTE.LAB_CODE = CCLABORATORY.CODE

  • Client groups where CCCLIENTGROUP.LABORATORY.ID = CCLABORATORY.ID

  • Clients where CCCLIENT.LABORATORY.ID = CCLABORATORY.ID

  • Cost centres where CCCOSTCENTRE.LABORATORY.ID = CCLABORATORY.ID

  • Price catalogue groups where CCPRICECATGP.LAB_CODE = CCLABORATORY.CODE

  • Price catalogues where CCPRICECAT.LAB_CODE - CCLABORATORY.CODE

  • Price codes where CCPRICECODE.LABORATORY.ID = CCLABORATORY.ID

  • Price adjustments where CCPRICEADJUSTMENT.LABORATORY.ID = CCLABORATORY.ID

  • Taxes where CCTAX.LAB_CODE = CCLABORATORY.CODE

  • Scheme groups where CCSCHEMEGROUP.LABORATORY.ID = CCLABORATORY.ID

  • Schemes where CCSCHEME.LABORATORY.ID = CCLABORATORY.ID

  • Methods where CCMETHOD.LABORATORY.ID = CCLABORATORY.ID

  • Locations where CCLOCATION.LABORATORY.ID = CCLABORATORY.ID

  • Sample handling actions where CCSAMPLEHANDLING.LABORATORY.ID = CCLABORATORY.ID

  • Container types where CCCONTAINERTYPE.LABORATORY.ID = CCLABORATORY.ID

  • Instrument groups where CCINSTRUMENTGROUP.LABORATORY.ID = CCLABORATORY.ID

  • Instruments where CCINSTRUMENT.LABORATORY.ID = CCLABORATORY.ID

  • Standard groups where CCSTANDARDGROUP.LABORATORY.ID = CCLABORATORY.ID

  • Standards where CCSTANDARD.LABORATORY.ID = CCLABORATORY.ID

  • Specification groups where CCSPECGROUP.LABORATORY.ID = CCLABORATORY.ID

  • Specifications where CCSPECIFICATION.LABORATORY.ID = CCLABORATORY.ID

  • Hazards where CCHAZARD.LABORATORY.ID = CCLABORATORY.ID

  • QC masks where CCQCMASK.LABORATORY.ID = CCLABORATORY.ID

  • QC types where CCQCTYPE.LABORATORY.ID = CCLABORATORY.ID

  • Rounding tables where CCROUNDINGTABLE.LABORATORY.ID = CCLABORATORY.ID

  • Range tables where CCRANGETABLE.LABORATORY.ID = CCLABORATORY.ID

  • Units where CCUNIT.LABORATORY.ID = CCLABORATORY.ID

  • Section groups where CCSECTIONGROUP.LABORATORY.ID = CCLABORATORY.ID

  • Sections where CCSECTION.LABORATORY.ID = CCLABORATORY.ID

  • Sample points where CCSAMPLEPOINT.LABORATORY.ID = CCLABORATORY.ID

  • Sample types where CCSAMPLETYPE.LABORATORY.ID = CCLABORATORY.ID

  • Devices where CCDEVICE.LABORATORY.ID = CCLABORATORY.ID

  • Biofield groups where CCBIOFIELDGROUP.LABORATORY.ID = CCLABORATORY.ID

  • Biofields where CCBIOFIELD.LABORATORY.ID = CCLABORATORY.ID

  • Canned comment groups where CCCANNEDCOMMENTGROUP.LABORATORY.ID = CCLABORATORY.ID

  • Canned comments where CCCANNEDCOMMENT.LABORATORY.ID = CCLABORATORY.ID

  • Report templates where CCREPORTTEMPLATE.LABORATORY.ID = CCLABORATORY.ID

  • Scripts where CCSCRIPT.LABORATORY.ID = CCLABORATORY.ID

  • Syntaxes where CCSYNTAX.LABORATORY.ID = CCLABORATORY.ID

  • Categories where CCCATEGORY.LABORATORY.ID = CCLABORATORY.ID

  • Category types where CCCATEGORYTYPE.LABORATORY.ID = CCLABORATORY.ID

  • Laboratory groups where CCLABORATORYGROUPMEMBER.LABORATORY.ID = CCLABORATORY.ID

  • Preferences where CCPREFERENCE.LABORATORY.ID = CCLABORATORY.ID

  • Custom screen definitions where Scope=Laboratory and Scope Value=LabBeingDeleted

  • User groups where CCUSERGROUP.LABORATORY.ID = CCLABORATORY.ID

  • Users where CCUSER.LABORATORY.ID = CCLABORATORY.ID