| Check_ID | Data Category | Type | Error Message | Description |
|---|
| CEDEN_C_100 | Chemistry | LookUp; | DigestExtractMethod not found in DigestExtractLookUp table. | The DigestExtractMethod in the ChemResults tab did not have a match in the DigestExtractMethod column in the DigestExtractLookUp table. |
| CEDEN_C_112 | Chemistry | LookUp; | Datum not found in VariableCodesLookUp table. | The Datum in the Stations tab did not have a match in the ValueCode column in the VariableCodesLookUp table for the "DatumList" CodeList. |
| CEDEN_C_122 | Chemistry | LookUp; | Datum not found in VariableCodesLookUp table. | The Datum in the Locations tab did not have a match in the ValueCode column in the VariableCodesLookUp table for the "DatumList" CodeList. |
| CEDEN_C_128 | Chemistry | Size; | Field exceeded the maximum size. | The value in the GeometryShape exceeded the allowed maximum size. |
| CEDEN_C_13 | Chemistry | NULL; | Missing ActualLatitude, a required field. | ActualLatitude on the Locations worksheet is required. |
| CEDEN_C_133 | Chemistry | LookUp; | PositionWaterColumn name has expired. | The value is no longer available for use in CEDEN. |
| CEDEN_C_135 | Chemistry | NULL; | CoordinateSource in the Station tab cannot be left blank. | CoordinateSource may be populated with the default value NR if the actual value cannot be provided. |
| CEDEN_C_136 | Chemistry | NULL; | State cannot be left blank. | State should be populated to assit with mapping stations. |
| CEDEN_C_140 | Chemistry | NULL; | LocationCode cannot be left blank on the Locations tab. | The true value for LocationCode is strongly encouraged; however, if it is unknown, the field must be populated with NR. |
| CEDEN_C_141 | Chemistry | NULL; | CoordinateSource in the Locations tab cannot be left blank. | CoordinateSource may be populated with the default value NR if the actual value cannot be provided. |
| CEDEN_C_142 | Chemistry | NULL; | Missing LocalWaterBody, a required field | The LocalWaterBody is required on the Station tab. |
| CEDEN_C_147 | Chemistry | NULL; | CollectionDeviceName on the ChemResults tab cannot be left blank. | CollectionDeviceName may be populated with the default value of Not Recorded if the actual value cannot be provided. The default of None must be used for QA samples. |
| CEDEN_C_149 | Chemistry | NULL; | Missing ComplianceCode, a required field. | The ComplianceCode in the ChemResults worksheet is required to be filled out. |
| CEDEN_C_156 | Chemistry | NULL; | BatchVerificationCode cannot be left blank. | The BatchVerificationCode in the LabBatch tab cannot be left blank. It may be populated with the default value NR if the actual value cannot be provided. |
| CEDEN_C_162 | Chemistry | Size; | LabBatchComments exceeded maximum size of 255. | The length of the LabBatchComments in the ChemResults tab exceeded the maximum length allowed by the CEDEN Database, which is 255 characters. |
| CEDEN_C_171 | Chemistry | BR; | Collection Time must be a text field in the format of 00:00, check your template for the format type on the column. | Collection Time is in the wrong format. |
| CEDEN_C_192 | Chemistry | BR; | Blank results need an appropriate ResQualCode. | Blank results need an appropriate ResQualCode to qualify the result. Only ResQualCodes of 'ND', 'NR', 'NA', 'P', 'PA', or 'A' are allowed to be blank and help to explain why no result is recorded. |
| CEDEN_C_193 | Chemistry | BR; | CollectionDepth was not "-88" for a LABQA. | If the StationCode is "LABQA", the CollectionDepth should be "-88" since LABQA samples are created in a laboratory setting. |
| CEDEN_C_194 | Chemistry | BR; | CollectionMethodCode cannot be "Not Applicable" for a chemistry 000NONPJ. | If the StationCode is "000NONPJ", the CollectionMethodCode cannot equal "Not Applicable". The default CollectionMethodCode equals "Not Recorded". |
| CEDEN_C_196 | Chemistry | Duplicate; | Duplicate entry in LabBatch worksheet. The LabBatch must be unique for the worksheet. | Generates an error when there are two identical LabBatch values within the LabBatch worksheet. |
| CEDEN_C_197 | Chemistry | Duplicate; | Duplicate entry in Results worksheet. The combination of columns A-C, F, H, J-O and U-Z must be unique for environmental samples within worksheet. | Generates an error when StationCode does not equal LABQA or 000NONPJ and columns A-C, F, H, J-O and U-Z are not unique within the Results worksheet. |
| CEDEN_C_198 | Chemistry | Duplicate; | Duplicate LabBatch record already in database. LabBatch worksheet information was adjusted from what was previously submitted. | Generates when the LabBatch, within the LabBatch worksheet, is found within the database and the LabAgencyCode, LabSubmissionCode, BatchVerificationCode, SubmittingAgencyCode, and LabBatchComments, within the LabBatch worksheet, are not equal to the database. |
| CEDEN_C_199 | Chemistry | Duplicate; | Error: Duplicate record already in database. The combination of columns A-C, F,H,J-M,O,S and U-Z must be unique the database. | Generates an error when columns A-C, F,H,J-M,O,S and V-Z already match a sample within the database. |
| CEDEN_C_200 | Chemistry | BR; | Expected MatrixName to be either "labwater" or "blankwater" for water chemistry LABQAs, | Generates an error when the StationCode equals "LABQA" and the MatrixName does not equal "labwater" or "blankwater" for units that do not contain "dw", "ww", "nr", "na", "lw", "%" or "% Recovery". Or generates an error when the StationCode equals "LABQA" and the MatrixName does not equal "blankmatrix", "sediment" or "plankton" for units that do contain "dw", "ww", "nr", "na", "lw" or "%". |
| CEDEN_C_201 | Chemistry | BR; | ExpectedValue required for a(n) [SampleTypeCode]. | An ExpectedValue is required if the SampleTypeCode is one of the following: "MS1", "MS2", "LCS", "CRM" or "MSBLDup" and the unit is not "% recovery". |
| CEDEN_C_202 | Chemistry | BR; | If PrepPreservationName is "None", then the PrepPreservation Date should be the default date of "01/Jan/1950 00:00". | If PrepPreservationName is "None", then the PrepPreservation Date should be the default date of "01/Jan/1950 00:00". |
| CEDEN_C_203 | Chemistry | BR; | Incorrect MatrixName for field samples. | Generates an error when StationCode does not equal LABQA or FIELDQA and the associated SampleTypeCode does not equal "DIBlank", "EquipBlank", "FieldBlank", "FieldBLBlank", "FilterBlank", "MSBLBlank", "TravelBlank" or "MS1" and the MatrixName does not equal samplewater, sediment, groundwater or interstitialwater. This includes all matrices with samplewater or sediment within the name (e.g. "samplewater, particulate, 125 to 200 um"). |
| CEDEN_C_205 | Chemistry | BR; | Invalid DateTime value. AnalysisDate must be prior to today. | Generates an error when the AnalytsisDate is after the day your data is submitted to the data checker. |
| CEDEN_C_209 | Chemistry | BR; | Invalid DateTime value. DigestExtractDate must be prior to today. | Generates an error when the DigestExtractDate is after the day your data is submitted to the data checker. |
| CEDEN_C_210 | Chemistry | BR; | Invalid DateTime value. PrepPreservationDate must be prior to today. | Generates an error when the PrepPreservationDate is after the day your data is submitted to the data checker. |
| CEDEN_C_211 | Chemistry | BR; | Invalid DateTime value. SampleDate must be prior to today. | Generates an error when the SampleDate is after the day your data is submitted to the data checker. |
| CEDEN_C_212 | Chemistry | BR; | Invalid LABQA SampleTypeCode. | Generates an error when StationCode = LabQA and the SampleTypeCode does not equal "LabBlank", "LCS", "CRM", "EquipBlank", "FilterBlank", "CCB", "CCS", "CCV", "CHK", "Iblank", "ICB", "ICM", "ICV", "PreservBlank", "UnkAcc", "BlankSp", "LCM", "ERM" or "DIBlank". |
| CEDEN_C_213 | Chemistry | BR; | LabBatch not found within LabBatch worksheet but is within the Results worksheet. | Generates an error when a LabBatch within the Results worksheet is not within the LabBatch worksheet. |
| CEDEN_C_214 | Chemistry | BR; | LabBatch not found within Results worksheet but is within the LabBatch worksheet. | Generates an error when a LabBatch within the LabBatch worksheet is not found within the Results worksheet. |
| CEDEN_C_215 | Chemistry | BR; | LocationCode cannot be "Not Applicable" for a Chemistry 000NONPJ. | If the StationCode is "000NONPJ", the LocationCode cannot be "Not Applicable". The LocationCode default value for 000NONPJ samples is "Not Recorded". |
| CEDEN_C_216 | Chemistry | BR; | LocationCode was not "Not Applicable" for a LABQA. | If the StationCode is "000NONPJ", the LocationCode cannot be "Not Applicable". The LocationCode default value for 000NONPJ samples is "Not Recorded". |
| CEDEN_C_217 | Chemistry | BR; | MDL is negative but not "-88". | Generates an error when the MDL is any negative value except for "-88". |
| CEDEN_C_218 | Chemistry | BR; | Multiple 000NONPJ samples are not unique, conventions are to use Replicate or CollectionTime to make results unique. | There are situations within a batch when two identical sample types are used for QA reasons and the only way to differentiate between them is to give them each a different CollectionTime or Replicate. For example when more than one 000NONPJ, MS or LabDuplicate is digested, extracted or analyzed in the same batch on the same day but are not lab replicates of each other, one CollectionTime should be 0:00 and the other 0:15 or one should have a Replicate of 1 and the other a Replicate of 2. |
| CEDEN_C_219 | Chemistry | BR; | Multiple LabQA samples are not unique, conventions are to use Replicate or CollectionTime to make results unique. | There are situations within a batch when two identical sample types are used for QA reasons and the only way to differentiate between them is to give them each a different CollectionTime or Replicate. For example when more than one LabBlank, CRM or LCS is digested, extracted or analyzed in the same batch on the same day but are not lab replicates of each other, one CollectionTime should be 0:00 and the other 0:15 or one should have a Replicate of 1 and the other a Replicate of 2. |
| CEDEN_C_220 | Chemistry | BR; | No negative value other than -88 is accepted within the CollectionDepthColumn. | For the CollectionDepthColumn there should be no negative value except the null value of "-88". |
| CEDEN_C_221 | Chemistry | BR; | PrepPreservationDate should not be before SampleDate. | The PrepPreservationDate should be >= to the SampleDate. If there was no PrepPreservation, PrepPreservation equals "None" or "Not Recorded", then it should be the default PrepPreservationDate of "01/Jan/1950 00:00". 000NONPJ data is excluded. |
| CEDEN_C_222 | Chemistry | BR; | ProjectCode cannot be "Not Recorded" for a Chemistry 000NONPJ. | If the StationCode is "000NONPJ", the ProjectCode cannot be "Not Recorded". The default value for a 000NONPJ ProjectCode is "Not Applicable". |
| CEDEN_C_223 | Chemistry | BR; | ProjectCode cannot be "Not Recorded" for a LABQA. | If the StationCode is "LABQA", the ProjectCode cannot be "Not Recorded". The default value for a LabQA ProjectCode is "Not Applicable". |
| CEDEN_C_224 | Chemistry | BR; | ProtocolCode cannot be "Not Recorded" for a Chemistry 000NONPJ. | If the StationCode is "000NONPJ", the ProtocolCode cannot be "Not Recorded". The default value for a 000NONPJ ProjectCode is "Not Applicable". |
| CEDEN_C_225 | Chemistry | BR; | ProtocolCode cannot be "Not Recorded" for a LABQA. | If the StationCode is "LABQA", the ProtocolCode cannot be "Not Recorded". The default value for a LABQA ProjectCode is "Not Applicable". |
| CEDEN_C_226 | Chemistry | BR; | Result was not within the MDL and RL for a DNQ. | When the ResQualCode is "DNQ" the Result should be >= the MDL and < the RL. |
| CEDEN_C_230 | Chemistry | BR; | "-88" results need an appropriate ResQualCode. | "-88", i.e. null value, results need an appropriate ResQualCode to qualify the result. ResQualCodes help to explain why no result is recorded. |
| CEDEN_C_231 | Chemistry | BR; | RL is negative but not -88 | The RL default value is "-88". |
| CEDEN_C_232 | Chemistry | BR; | RL not >= MDL. | The RL (Reporting Limit) is expected to be greater than or equal to the MDL (Method Detection Limit). |
| CEDEN_C_233 | Chemistry | BR; | SampleDate must be equal to or before AnalysisDate for a 000NONPJ sample. | Generates an error when the SampleDate is greater than the AnalysisDate. Excludes null AnalysisDate of "01/Jan/1950 00:00". |
| CEDEN_C_234 | Chemistry | BR; | SampleDate must be equal to or before AnalysisDate for a LABQA sample. | Generates an error when the SampleDate is greater than the AnalysisDate. Excludes null AnalysisDate of "01/Jan/1950 00:00". |
| CEDEN_C_235 | Chemistry | BR; | CollectionTime was not "0:00" or in 15 min increments for a LABQA or 000NONPJ sample. | For two LABQA or 000NONPJ samples in the same LabBatch with the same SampleTypeCode, in most cases, the only way to differentiate between them is the SampleDate, CollectionTime, Replicate or the LabReplicate. If collection time is utilized to differentiate samples, to be comparable, a 15 min interval is utilized starting with 00:00. |
| CEDEN_C_236 | Chemistry | BR; | Could not find the MS this is a duplicate of. | For each matrix spike duplicate (MSD) there should be an associated matrix spike (MS). |
| CEDEN_C_237 | Chemistry | BR; | Could not find the native sample for this MS. | Generates error when columns A-F, H, J-K, O, P, S, U-Z, AI and AK for a SampleTypeCode containing MS does not match an associated original sample. 000NONPJ StationCodes and blank StationCodes are not included in this check. |
| CEDEN_C_238 | Chemistry | BR; | Default "-88" or -MDL result values with a ResQualCode of "NR", "NA" or "ND" are accepted by CEDEN but are stored as blank values with the associated ResQualCode. | Default "-88" or -MDL result values with a ResQualCode of "NR", "NA" or "ND" are accepted by CEDEN but are stored as blank values with the associated ResQualCode. |
| CEDEN_C_239 | Chemistry | BR; | Did not expect LabReplicate to be 2. | For each LabReplicate of 2 there should be an associated original sample. Exceptions for this are "000NONPJ" station codes where the original sample is not included and the LabReplicate of 2 is flagged with a QACode of "QAX". |
| CEDEN_C_240 | Chemistry | BR; | DigestExtractDate must be equal to default date or greater than SampleDate when DigestExtractMethod is "Not Recorded" or equal to default date when is "None" or DigestExtractDate > SampleDate. | DigestExtractDate must be equal to default date or greater than SampleDate when DigestExtractMethod is "Not Recorded" or DigestExtractDate must be equal to default date when DigestExtractMethod is "None" or DigestExtratDat must be greater than SampleDate for all other DigestExtractMethods. |
| CEDEN_C_241 | Chemistry | BR; | DilutionFactor was less than one. | Unless the sample is concentrated the result should be greater than one |
| CEDEN_C_243 | Chemistry | BR; | Duplicate LabBatch record already in database. The LabBatch must be unique within the CEDEN database. | Generates when the LabBatch, within the LabBatch worksheet, is found within the database and the LabAgencyCode, LabSubmissionCode, BatchVerificationCode, SubmittingAgencyCode and LabBatchComments, within the LabBatch worksheet, are equal to the database. |
| CEDEN_C_244 | Chemistry | BR; | Expected MatrixName of "blankwater" or "labwater" for a SampleTypeCode of [SampleTypeCode]. | The MatrixName is expected to be "blankwater" or "labwater" for the following SampleTypeCodes: "DIBlank", "EquipBlank", "FieldBlank", "FilterBlank" and "TravelBlank". |
| CEDEN_C_245 | Chemistry | BR; | FractionName was "Dissolved" with no filtration listed in the PrepPreservationName. | It is expected that the PrepPreservationName include "FieldFiltered" or "LabFiltered" if the FractionName is "Dissolved". This error SHOULD NOT be ignored. Dissolved fractions should be filtered. In some cases Laboratory QA have a different PrepPreservationName than the normal samples, e.g. the LABQA have a prep of "None", but the program keeps the fraction the same to match the normal samples. |
| CEDEN_C_246 | Chemistry | BR; | If PrepPreservationName is "Not Recorded", then the PrepPreservation Date should be the default date of "01/Jan/1950 00:00". | This error will come up when the PrepPreservationName is either "None" or "Not Recorded" and the PrepPreservationDate is not "01/Jan/1950 00:00". |
| CEDEN_C_247 | Chemistry | BR; | Warning: LabBatch already exists in database. | The LabBatch already exists in CEDEN. Check that your LabBatch is correct with the laboratory hard copy report. If you are not adding to previously submitted data then you need to make the LabBatch unique. By appending on your agency code or an acronym for your project to the LabBatch it can make your LabBatch unique. If you are intentionally adding to an already submitted batch then all values within the LabBatch worksheet must be equal to the previously submitted data. |
| CEDEN_C_300 | Chemistry | Numeric | Collection Time is not correct. It can not be blank and must be a text field in the format hh:mm not a date field. | The format for the field cannot be a "date/time" format. The template uses a defalut of "General" as the field type. |
| CEDEN_C_33 | Chemistry | NULL; | Missing Result, a required field. | The result can not be blank unless the ResQualCode is 'NA', 'NR' or 'ND'. |
| CEDEN_C_54 | Chemistry | LookUp; | ProjectCode not found in ProjectLookUp table. | The ProjectCode in the Locations tab did not have a match in the ProjectCode column in the ProjectLookUp table. |
| CEDEN_C_64 | Chemistry | LookUp; | StationCode not found in StationLookUp table. | The StationCode in the ChemResults tab did not have a match in the StationCode column of the StationLookUp table. |
| CEDEN_C_66 | Chemistry | LookUp; | ProjectCode not found in ProjectLookUp table. | The ProjectCode in the ChemResults tab did not have a match in the ProjectCode column of the ProjectLookUp table. |
| CEDEN_C_70 | Chemistry | LookUp; | ProtocolCode not found in ProtocolLookUp table. | The ProtocolCode in the ChemResults tab did not have a match in the ProtocolCode column in the ProtocolLookUp table. |
| CEDEN_C_84 | Chemistry | LookUp; | MethodName not found in MethodLookUp table. | The MethodName in the ChemResults tab did not have a match in the MethodName column of the MethodLookUp table. |
| CEDEN_C_86 | Chemistry | LookUp; | AnalyteName not found in AnalyteLookUp table. | The AnalyteName in the ChemResults tab did not have a match in the AnalyteName column of the AnalyteLookUp table. |
| CEDEN_C_88 | Chemistry | LookUp; | FractionName not found in FractionLookUp table. | The FractionName in the ChemResults tab did not have a match in the FractionName column of the FractionLookUp table. |
| CEDEN_C_94 | Chemistry | LookUp; | QACode not found in QALookUp table. | The QACode in the ChemResults tab did not have a match in the QACode column in the QALookUp table. |
