Conditional Checks, 4-File (EFWEDD)

<< Click to Display Table of Contents >>

EQuIS 7  >>  EDP > EDP Format Files, Open, Data Review, Tools, EDP Professional and EDP Enterprise > EDP Format Files >

Conditional Checks, 4-File (EFWEDD)

This is a summary of the conditional checks included in the EFWEDD format.

 

Format Versions – This document was created based on the following EFWEDD versions:

EFWEDD.xsd version 42

EFWEDD.vb version 37

 

Key to Reading this Document

 

Key fields are fields that make up the unique key for that section of the format. These are defined in the xsd.

Crosschecks are checks that are made between sections of the format. These are defined in the xsd.

Pattern formatting is a set of restrictions on the field, which will allow specific formatting of the data. These are defined in the xsd.

Conditional checks are checks, methods or functions that are defined in the vb file.

 

EFW2FSample

 

Key fields: sys_sample_code

Crosschecks: parent_sample_code against sys_sample_code

Pattern formatting: none

Conditional check on sample_type_code - ERR-21: Parent_sample_code is required where sample_type_code=BD, FD, FR, FS, LR, MS, SD, or MSD.

Conditional check on parent_sample_code - ERR-21: Parent_sample_code is required where sample_type_code=BD, FD, FR, FS, LR, MS, SD, or MSD.

Conditional check on sample_type_code - ERR-24: sample_date cannot be null when when sample_type_code=TB, N, MB, FD, FB, EB, AB.

Conditional check on sample_type_code - DQM01: Percent_Moisture is required where sample_matrix_code=SO or SE and sample_type_code is an N, FD, F, FS, LR, MS, SD, or MSD.

Conditional check on sample_type_code - DQM02: Sub-sample_amount is required where sample_type_code is an N, FD, FR, FS, LR, MS, SD, or MSD.

Conditional check on matrix_code - DQM01: Percent_Moisture is required where sample_matrix_code=SO or SE and sample_type_code is an N, FD, FR, FS, LR, MS, SD, or MSD.

Conditional check on sample_date - ERR-24: sample_date cannot be null when when sample_type_code=TB, N, MB, FD, FB, EB, AB.

Conditional check on start_depth - ERR-25: Start_depth cannot be null when sample_matrix_code=SO or SE.

Conditional check on start_depth - ERR-26: If start_depth is not null, end_depth must be greater than start_depth.

Conditional check on end_depth - ERR-26: If start_depth is not null, end_depth must be greater than start_depth.

 

EFW2LabSMP

 

Key fields: sys_sample_code

Crosschecks: parent_sample_code against sys_sample_code

Pattern formatting: none

Conditional check on sample_type_code - ERR-21: Parent_sample_code is required where sample_type_code=BD, FD, FR, FS, LR, MS, SD, or MSD.

Conditional check on parent_sample_code - ERR-21: Parent_sample_code is required where sample_type_code=BD, FD, FR, FS, LR, MS, SD, or MSD.

Conditional check on sample_type_code - ERR-24: sample_date cannot be null when when sample_type_code=TB, N, MB, FD, FB, EB, AB.

Conditional check on sample_date - ERR-24: sample_date cannot be null when when sample_type_code=TB, N, MB, FD, FB, EB, AB.

 

EFW2LabTST

 

Key fields: sys_sample_code, lab_anl_method_name, analysis_date, analysis_time, total_or_dissolved, test_type, column_number

Crosschecks: sys_sample_code against EFW2FSample.sys_sample_code and EFW2LabSMP.sys_sample_code

Pattern formatting: none

Conditional check on analysis_date - ERR -08: Analysis_date cannot precede sample_date. Sample_date and analysis_date cells will indicate errors.

Conditional check on prep_date - ERR -09: Prep date precedes sample date. Sample_date and prep_date cells will indicate errors.

Conditional check on percent_moisture - DQM01: Percent_Moisture is required where sample_matrix_code=SO or SE and sample_type_code is an N, FD, FR, FS, LR, MS, SD, or MSD.

Conditional check on subsample_amount - DQM02: Sub-sample_amount is required where sample_type_code is an N, FD, FR, FS, LR, MS, SD, or MSD.

Conditional check on subsample_amount - DQM03: DQM03: Subsample_amount_unit cannot be null when Subsample_amount is not null.

Conditional check on subsample_amount_unit - DQM03: DQM03: Subsample_amount_unit cannot be null when Subsample_amount is not null.

Conditional check on analysis_location - ERR-28: Lab_sample_id cannot be null when analysis_location=LB.

Conditional check on lab_sample_id - ERR-28: Lab_sample_id cannot be null when analysis_location=LB.

 

EFW2LabRES

 

Key fields: sys_sample_code, lab_anl_method_name, analysis_date, analysis_time, total_or_dissolved, test_type, column_number, cas_rn

Crosschecks: 1) sys_sample_code, lab_anl_method_name, analysis_date, analysis_time, total_or_dissolved, test_type, column_number against EFW2LabTST. sys_sample_code, lab_anl_method_name, analysis_date, analysis_time, total_or_dissolved, test_type, column_number 2) sys_sample_code against EFW2LabSMP.sys_sample_code

Pattern formatting: none

Conditional check on result_value - ERR-22: Result_value is required where detect_flag=Y.

Conditional check on detect_flag - ERR-22: Result_value is required where detect_flag=Y.

Conditional check on detect_flag - ERR-23: Reporting_detection_limit cannot be null when detect_flag=N.

Conditional check on reporting_detection_limit - ERR-23: Reporting_detection_limit cannot be null when detect_flag=N.

Conditional check on reporting_detection_limit - ERR 30: Detection_limit_unit cannot be null when reporting_detection_limit is not null.

 

EFW2LabBCH

 

Key fields: sys_sample_code, lab_anl_method_name, analysis_date, analysis_time, total_or_dissolved, test_type, column_number, cas_rn, test_batch_type

Crosschecks: sys_sample_code, lab_anl_method_name, analysis_date, analysis_time, total_or_dissolved, test_type, column_number against EFW2LabTST. sys_sample_code, lab_anl_method_name, analysis_date, analysis_time, total_or_dissolved, test_type, column_number

Pattern formatting: none