Export/Import of Sample Scheme Analytes

Sample Scheme Analytes are automatically included in distribution if:

• Sample Schemes are exported/imported: CCSAMPLESCHEMEANALYTE.ORGANISATION_CODE+SAMPLE_CODE+SCHEME_CODE = CCSAMPLESCHEME.ORGANISATION_CODE+SAMPLE_CODE+SCHEME_CODE

The following data is included when a Sample Scheme Analyte 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 template sample scheme analytes can be approved for export)

  • Job

  • Job scheme analyte

  • Laboratory batch job

  • Laboratory batch sample

  • Required date

  • Possible date

  • Expiry date

  • Latest reading

  • User QC status

  • User workflow status

  • Weight

  • Volume

  • Dilution factor

  • Boolean value

  • Date-time value

  • Formatted final value

  • Numeric final value

  • Numeric raw value

  • Text value

  • Percentage difference

  • RPD

  • Uncertainty value

  • Price code

  • Package price code

  • Last activated date

  • Activated by user

  • Started date

  • Analysed by user

  • Analysed date

  • Released date

  • Released by user

  • QC ignored date

  • QC ignored by user

  • Validated date

  • Validated by user

  • First reported date

  • Last reported date

  • Last invoiced date

• Specific links to other records are maintained, and the linked record is exported/imported if it does not already exist in the destination organisation.

  • Sample, as Sample record

  • Sample scheme, as Sample Scheme record

  • Scheme, as Scheme record

  • Scheme version, as Scheme Version record

  • Scheme version analyte, as Scheme Version Analyte record

  • Analysis unit, report unit, as Unit record

  • Rounding table, as Rounding Table record

  • Report text, as Text record

  • Organisation, as Organisation record

• Related child or group member records are exported/imported.
  • Job scheme analyte, as Job Scheme Analyte record
• 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.