Export/Import of Range Tables

Range Tables are automatically included in distribution if:

  • Scheme Version Analytes are exported/imported:

    CCRANGETABLE.ORGANISATION_CODE+CODE = CCSCHEMEVERSIONANALYTE.ORGANISATION_CODE+REPEAT_RANGE_TABLE_CODE

    CCRANGETABLE.ORGANISATION_CODE+CODE = CCSCHEMEVERSIONANALYTE.ORGANISATION_CODE+REPROD_RANGE_TABLE_CODE

    CCRANGETABLE.ID = CCSCHEMEVERSIONANALYTE.UNCERTAINTY_RANGE_TABLE_ID

The following data is included when a Range Table 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 range tables 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.
    • Range table category, as Category 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.