Export/Import of Categories

Categories are automatically included in distribution if:

• Biofields are exported/imported: CCCATEGORY.ID = BIOFIELD_CATEGORY_ID
• Canned Comments are exported/imported: CCCATEGORY.ID = CCCANNEDCOMMENT.CANNED_COMMENT_CATEGORY_ID
• Canned Comment Groups are exported/imported: CCCATEGORY.ID = CCCANNEDCOMMENTGROUP.CANNED_COMMENT_GRP_CATEGORY_ID
• Container Types are exported/imported: CCCATEGORY.ID = CCCONTAINERTYPE.CONTAINER_TYPE_CATEGORY_ID
• Hazards are exported/imported:

  CCCATEGORY.ID = CCHAZARD.HAZARD_CATEGORY_ID

  CCCATEGORY.ID = CCHAZARD.HAZARD_LEVEL_CATEGORY_ID

• Instrument Groups are exported/imported: CCCATEGORY.ID = CCINSTRUMENTGROUP.INSTRUMENT_GROUP_CATEGORY_ID
• Template Jobs are exported/imported: CCCATEGORY.ID = CCJOB.JOB_CATEGORY_ID
• Methods are exported/imported: CCCATEGORY.ID = CCMETHOD.METHOD_CATEGORY_ID
• Products are exported/imported: CCCATEGORY.ID = CCPRODUCT.PRODUCT_CATEGORY_ID
• QC Masks are exported/imported: CCCATEGORY.ID = CCQCMASK.QC_MASK_CATEGORY_ID
• QC Types are exported/imported: CCCATEGORY.ID = CCQCTYPE.QC_TYPE_CATEGORY_ID
• Range Tables are exported/imported: CCCATEGORY.ID = CCRANGETABLE.RANGE_TABLE_CATEGORY_ID
• Rounding Tables are exported/imported: CCCATEGORY.ID = CCROUNDINGTABLE.ROUNDING_TABLE_CATEGORY_ID
• Sample Handlings are exported/imported:

  CCCATEGORY.ID = CCSAMPLEHANDLING.HANDLING_METHOD_CATEGORY_ID

  CCCATEGORY.ID = CCSAMPLEHANDLING.SAMPLE_HANDLING_CATEGORY_ID

• Schemes are exported/imported, then Categories are automatically included where:

  CCCATEGORY.ID = CCSCHEME.PRETREATMENT_CATEGORY.ID

  CCCATEGORY.ID = CCSCHEME.SCHEME_CATEGORY_ID

• Scripts are exported/imported: CCCATEGORY.ID = CCSCRIPT.SCRIPT_CATEGORY_ID
• Sections are exported/imported: CCCATEGORY.ID = CCSECTION.SECTION_CATEGORY_ID
• Specifications are exported/imported: CCCATEGORY.ID = CCSPECIFICATION.SPECIFICATION_CATEGORY_ID
• Specification Scheme Version Analytes are exported/imported: CCCATEGORY.ID = CCSPECSCHEMEVERANALYTE.CONFIDENCE_CATEGORY_ID
• Standards are exported/imported: CCCATEGORY.ID = CCSTANDARD.STANDARD_CATEGORY_ID
• Units are exported/imported: CCCATEGORY.ID = CCUNIT.UNIT_CATEGORY_ID
• User Groups are exported/imported: CCCATEGORY.ID = CCUSERGROUP.USER_GROUP_CATEGORY_ID

The following data is included when a Category record is exported/imported:

• All fields in the record, except for those specified as being cleared, and Creation User and Last Mod User which are cleared also.

  • Laboratory (should be empty anyway since only org-scope categories can be approved for export)

• Specific links to other records are maintained, and the linked record is exported/imported if it does not already exist in the destination organisation.
  • Owning category type, as Category Type record
• Related child or group member records are exported/imported.
• All related EFS files (for example, scripts, images) are exported/imported.
• All related custom attributes and related content are exported/imported.
• All related I18n records are exported/imported for all exported/imported records.