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 |
