Fields Copied from a Source Sample to Destination Production Sample

The following fields are copied from a source sample to a destination production sample. The fields copied from a source sample to a destination production sample are the same when the source sample is a production, proposal, internal or template sample, except for the Template Price Code field which is cleared when the source is a template sample and the destination is a production sample (this field is pushed to each sample scheme's and sample scheme analyte's Package Price Code when this sample is used to register those sample schemes and sample scheme analytes) and copied for all other source and destination samples' job types.

Table

Field

State of Field in the Destination Production Sample

Sample

Organisation Code

System-set according to destination job

Laboratory Code

System-set according to destination job

Job Code

System-set to new job code

Registration Sequence

Copied

Sample Code

System-set to new sample code

Sample Template

System-set to source sample

Sample Name

System-set to new sample name

Client Sample Name

Copied

Description

Copied (including multi-lingual fields)

Template?

As selected

Sample Record Type (unexpanded sample group or expanded individual sample)

Copied

Sample Status (transient draft or real sample)

Copied

Number of Samples to Expand

Copied

Portion Last Sequence Number

System-set to 1

Primary Analytical Type

Copied

Primary QC Type Code

Copied

Secondary Analytical Type

Copied

Secondary QC Type Code

Copied

Standard Code

Copied

Standard Lot Code

Copied

Product Code

Copied

Primary Product Specification

Copied

Dependent Related Samples

Cleared

Parent Sample

System-set to related new sample

Split Original Sample

System-set to related new sample

Duplicate Original Sample

System-set to related new sample

Spike Original Sample

System-set to related new sample

Client Group Code (relevant for template samples)

Copied

Client Code

Copied or new if changed

Client Submission Number

Copied (including multi-lingual fields)

Project Code

Copied or new if changed

Contact Code

Copied or new if changed

Order Number

Copied

Cost Centre Code

Copied

Contract

Copied (including multi-lingual fields)

Contract Submission Number

Copied (including multi-lingual fields)

Quote Number

Copied

Sample Type Code

Copied

Sample Point Code

Copied

Sampled By

Cleared (including multi-lingual fields)

Sampled Date

Cleared

Registration Date

System-set to current date-time

Registration User Code

System-set to current user

Registration Text

Copied

Priority

Copied

Required Date

System-set to sample's Registration Date + sample's Priority + holidays + non-working days

Possible Date

System-set to recalculated

Agreed Date

System-set to recalculated

Auto Receive?

Copied

Received Date

Defaulted to destination sample's Registration Date

Reception User Code

Defaulted to destination sample's Reception User Code

Delivered By

Cleared (including multi-lingual fields)

Number of Containers

Copied

Owner User Code

Copied (note, this is different to the job where it is cleared)

Owner Changed Date

Cleared

Generate Paperwork?

Copied

Generate Label?

Copied

Included in Job QC

System-set to cleared

Start New Rack?

Copied

QC Mask Code

Copied

Approved User Code (for export, relevant for template samples)

Cleared

Approved Date (for export, relevant for template samples)

Cleared

Activation User Code

Cleared

Last Activated Date

Cleared

Started Date

Cleared

Analysed Date

Cleared

Analysis Text

Copied

Released By User Code

Cleared

Released Date

Cleared

Completion User Code

Cleared

Completed Date

Cleared

Auto Validate?

Copied

Validation User Code

Cleared

Validated Date

Cleared

Product Specification Result Text

Cleared

Reportable

Copied

Report Text

Copied

Last Report Number

Cleared

First Reported Date

Cleared

Last Reported Date

Cleared

Invoiceable

Copied

Template Price Code

Cleared when the source sample is in a template job and the destination sample is in a production job (this field is pushed to each sample scheme's and sample scheme analyte's Package Price Code when this sample is used to register those sample schemes and sample scheme analytes)

Copied for all other source and destination job types

Last Invoice Number

Cleared

Last Invoiced Date

Cleared

Requires Authorisation?

Copied

Authorisation User Group Code

Copied

Authorisation User Code

Cleared

Authorised Date

Cleared

Finalisation User Code

Cleared

Finalised Date

Cleared

Archived?

System-set to cleared

Archive User Code

Cleared

Last Archived Date

Cleared

Composite QC Status

System-set to Not Tested

Composite Specification Status

System-set to Not Tested

Workflow Status

System-set to Registered

Sample Scheme

Organisation Code

System-set according to destination job

Laboratory Code

System-set according to destination job

Job Code

System-set to new job code

Sample Code

System-set to new sample code

Profile Sequence

Copied

Registration Sequence

Copied

Job Scheme

System-set to new job scheme

Scheme Laboratory Code + Scheme Code

Copied

Scheme Version

Copied

Source Sample Template

System-set to source sample

Rack Number

Copied

Sample Portion

System-set to new portion

Limit Specification Code

Copied

Registration Date

System-set to current date-time

Registration User Code

System-set to current user

Priority

Copied

Required Date

System-set to the sample's Registration Date + the sample scheme's Priority + holidays + non-working days

Scheme Duration

Copied

Possible Date

System-set to recalculated

Subcontract Laboratory Organisation Code

Copied

Subcontract Laboratory Code

Copied

Current Laboratory Batch Job

Cleared

Number of Analytes

Copied

Analytes Remain?

Copied

Included in Job QC

System-set to checked

QC Mask Code

Copied

Scheme Script Code

Copied

Activation User Code

Cleared

Last Activated Date

Cleared

Holding Time

Copied

Expiry Date

System-set to recalculated

Started Date

Cleared

Analysed Date

Cleared

Analysis Text

Cleared (including multi-lingual fields; note that this field is copied at higher levels)

Released By User Code

Cleared

Released Date

Cleared

Completion User Code

Cleared

Completed Date

Cleared

Validation User Code

Cleared

Validated Date

Cleared

Reportable

Copied

Report Sequence

Copied

Report Header Text

Copied

Report Footer Text

Copied

Result Header Text

Copied

Report Text

Copied

First Reported Date

Cleared

Last Reported Date

Cleared

Internal Cost

Copied

Package Price Code Laboratory Code + Package Price Code

System-set to the sample's Template Price Code when the source sample is in a template job and the destination sample is in a production job

Copy for all other source and destination job types

Composite QC Status

System-set to Not Tested

Composite Specification Status

System-set to Not Tested

Workflow Status

System-set to Not Started

Sample Scheme Analyte

Organisation Code

System-set according to destination job

Laboratory Code

System-set according to destination job

Job Code

System-set to new job code

Sample Code

System-set to new sample code

Profile Sequence

Copied

Registration Sequence

Copied

Sample Scheme

System-set to new sample scheme

Scheme Laboratory Code + Scheme Code

Copied

Scheme Version

Copied

Job Scheme Analyte

System-set to new job scheme analyte

Analyte Code

Copied

Source Sample Template

System-set to source sample

Required Date

System-set to the sample scheme's Required Date

Include on Worksheet?

Copied

Laboratory Batch Job Code

Cleared

Laboratory Batch Sample Code

Cleared

Activation User Code

Cleared

Last Activated Date

Cleared

Holding Time

Copied

Expiry Date

System-set to recalculated

Unit Code

Copied

Spreadsheet Formula

Copied

Internal Lower Detection Limit

Copied

Internal Lower Limit Critical?

Copied

Internal Upper Detection Limit

Copied

Internal Upper Limit Critical?

Copied

Started Date

Cleared

Analysed By User Code

Cleared

Analysed Date

Cleared

Latest Reading

Cleared

Current Data Type

Copied

Weight

Cleared

Volume

Cleared

Dilution Factor

System-set to 1.0

Composite Correction Factor

System-set to 1.0

Numeric Raw Value

Cleared

Numeric Final Value

Cleared

Date Time Value

Cleared

Boolean Value

Cleared

Text Value

Cleared (including multi-lingual fields)

Document File

Cleared

Image File

Cleared

Notes Available?

System-set to cleared

Used in Aggregate?

System-set to cleared

QC Ignored User Code

Cleared

QC Ignored Date

Cleared

Released Date

Cleared

Released By User Code

Cleared

Validation User Code

Cleared

Validated Date

Cleared

Reportable

Copied

Report Sequence

Copied

Report Unit Code

Copied

Report Lower Detection Limit

Copied

Report Upper Detection Limit

Copied

Rounding Table Code

Copied

First Reported Date

Cleared

Last Reported Date

Cleared

Report Text

Cleared

Corrected Internal Lower Detection Limit

System-set to scheme version analyte's Internal Lower Detection Limit

Corrected Internal Upper Detection Limit

System-set to scheme version analyte's Internal Upper Detection Limit

Formatted Final Value

Cleared

Recovery

Cleared

Percentage Difference

Cleared

RPD

Cleared

Uncertainty Value

Cleared

Package Price Code Laboratory Code + Package Price Code

System-set to the sample's Template Price Code when the source sample is in a template job and the destination sample is in a production job

Copied for all other source and destination job types

Internal Detection Limit Status

System-set to Not Tested

Limit Status

System-set to Not Tested

Precision Status

System-set to Not Tested

Standard Status

System-set to Not Tested

Specification Status

System-set to Not Tested

User QC Status

Cleared

Composite QC Status

System-set to Not Tested

Composite Specification Status

System-set to Not Tested

User Workflow Status

Cleared

Workflow Status

System-set to Not Tested

Sample Biofield

 

All copied with links to new samples updated

Sample Specification

Sample

System-set to new sample

Product

Copied

Specification

Copied

Reportable

Copied

Specification Status

System-set to Not Tested

Sample Specification Group

Sample

System-set to new sample

Product

Copied

Specification Group

Copied

Reportable

Copied

Specification Status

System-set to Not Tested

Sample Scheme Link

Owner Job Scheme

System-set to related new sample scheme

Linked Job Scheme

System-set to related new sample scheme

Sample Scheme Analyte Specification

Sample Scheme Analyte

System-set to related new sample scheme analyte

Sample Specification

System-set to related new sample specification

Specification Scheme Version Analyte

Copied

Reportable

Copied

Lower Report Text Limit

Copied

Lower Report Numeric Limit

Copied

Upper Report Text Limit

Copied

Upper Report Numeric Limit

Copied

Specification Status

System-set to Not Tested

Portion

 

All copied with links to new samples updated