| Check_ID | Data Category | Type | Error Message | Description |
| SW_C_1 | Chemistry | MS; | Replicate was not 1 for a matrix spike | For SampleTypeCodes of "MS1", "MS2", and "MSBLDup", the Replicate should be 1 in 99% of cases. |
| SW_C_10 | Chemistry | LABQA; | UnitCollectionDepth was not "m" or "cm" for a LABQA | If the StationCode is "LABQA" and the LabBatch contains either "_W_" or "_S_" then the UnitCollectionDepth should be either "m" or "cm". |
| SW_C_100 | Chemistry | Size; | LabCollectionComments exceeded maximum size of 255. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 255 characters. |
| SW_C_101 | Chemistry | Size; | SampleID exceeded maximum size of 40. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 40 characters. |
| SW_C_102 | Chemistry | Size; | PrepPreservationName exceeded maximum size of 50. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 50 characters. |
| SW_C_103 | Chemistry | Size; | PrepPreservationDate exceeded maximum size of 50. | Dates and times should be less than 50 characters. Perhaps something is wrong with the format. |
| SW_C_104 | Chemistry | Size; | DigestExtractMethod exceeded maximum size of 50. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 50 characters. |
| SW_C_105 | Chemistry | Size; | DigestExtractDate exceeded maximum size of 50. | Dates and times should be less than 50 characters. Perhaps something is wrong with the format. |
| SW_C_106 | Chemistry | Size; | LabBatch exceeded maximum size of 35. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 35 characters. |
| SW_C_107 | Chemistry | Size; | AnalysisDate exceeded maximum size of 50. | Dates and times should be less than 50 characters. Perhaps something is wrong with the format. |
| SW_C_108 | Chemistry | Size; | LabReplicate exceeded maximum size of 10. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 10 characters. |
| SW_C_109 | Chemistry | Size; | MatrixName exceeded maximum size of 50. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 50 characters. |
| SW_C_11 | Chemistry | LABQA; | ProjectCode was not "Not Applicable" for a LABQA | If the StationCode is "LABQA" and the LabBatch contains either "_W_" or "_S_" then the ProjectCode should be "Not Applicable". |
| SW_C_110 | Chemistry | Size; | MethodName exceeded maximum size of 50. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 50 characters. |
| SW_C_111 | Chemistry | Size; | AnalyteName exceeded maximum size of 255. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 255 characters. |
| SW_C_112 | Chemistry | Size; | FractionName exceeded maximum size of 50. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 50 characters. |
| SW_C_113 | Chemistry | Size; | UnitName exceeded maximum size of 50. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 50 characters. |
| SW_C_114 | Chemistry | Size; | DilutionFactor exceeded maximum size of 10. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 10 characters. |
| SW_C_115 | Chemistry | Size; | Result exceeded maximum size of 50. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 50 characters. |
| SW_C_116 | Chemistry | Size; | ResQualCode exceeded maximum size of 10. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 10 characters. |
| SW_C_117 | Chemistry | Size; | MDL exceeded maximum size of 10. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 10 characters. |
| SW_C_118 | Chemistry | Size; | RL exceeded maximum size of 10. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 10 characters. |
| SW_C_119 | Chemistry | Size; | QACode exceeded maximum size of 30. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 30 characters. |
| SW_C_12 | Chemistry | LABQA; | LABQA AgencyCode did not match LabAgencyCode | For LABQAs, the AgencyCode listed on the Results Worksheet must match the LabAgencyCode of the corresponding LabBatch on the LabBatch Worksheet. |
| SW_C_120 | Chemistry | Size; | ExpectedValue exceeded maximum size of 10. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 10 characters. |
| SW_C_121 | Chemistry | Size; | LabResultComments exceeded maximum size of 130. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 130 characters. The actual limit is 255 characters, but the extra space is reserved for DMT use. |
| SW_C_122 | Chemistry | Size; | LabBatch exceeded maximum size of 35. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 35 characters. |
| SW_C_123 | Chemistry | Size; | LabAgencyCode exceeded maximum size of 20. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 20 characters. |
| SW_C_124 | Chemistry | Size; | LabSubmissionCode exceeded maximum size of 10. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 10 characters. |
| SW_C_125 | Chemistry | Size; | SubmittingAgencyCode exceeded maximum size of 20. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 20 characters. |
| SW_C_126 | Chemistry | Size; | LabBatchComm exceeded maximum size of 130. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 130 characters. The actual limit is 255 characters, but the extra space is reserved for DMT use. |
| SW_C_127 | Chemistry | NULL; | Missing StationCode, a required field. | StationCode is required to be filled out. |
| SW_C_128 | Chemistry | NULL; | Missing EventCode, a required field. | EventCode is required to be filled out. |
| SW_C_129 | Chemistry | NULL; | Missing ProtocolCode, a required field. | ProtocolCode is required to be filled out. |
| SW_C_13 | Chemistry | LABQA; | Invalid LABQA SampleTypeCode | If the StationCode is "LABQA", the SampleTypeCode should be "LabBlank", "LCS", "CRM", "EquipBlank", or "FilterBlank" |
| SW_C_130 | Chemistry | NULL; | Missing LocationCode, a required field. | LocationCode is required to be filled out. |
| SW_C_131 | Chemistry | NULL; | Missing SampleDate, a required field. | SampleDate is required to be filled out. |
| SW_C_132 | Chemistry | NULL; | Missing CollectionTime, a required field. | CollectionTime is required to be filled out. |
| SW_C_133 | Chemistry | NULL; | Missing CollectionMethodCode, a required field. | CollectionMethodCode is required to be filled out. |
| SW_C_134 | Chemistry | NULL; | Missing SampleTypeCode, a required field. | SampleTypeCode is required to be filled out. |
| SW_C_135 | Chemistry | NULL; | Missing Replicate, a required field. | Replicate is required to be filled out. |
| SW_C_136 | Chemistry | NULL; | Missing CollectionDepth, a required field. | CollectionDepth is required to be filled out. |
| SW_C_137 | Chemistry | NULL; | Missing UnitCollectionDepth, a required field. | UnitCollectionDepth is required to be filled out. |
| SW_C_138 | Chemistry | NULL; | Missing ProjectCode, a required field. | ProjectCode is required to be filled out. |
| SW_C_139 | Chemistry | NULL; | Missing AgencyCode, a required field. | AgencyCode is required to be filled out. |
| SW_C_14 | Chemistry | LABQA; | Equal LabReplicates and CollectionTimes for two LABQAs of the same SampleTypeCode | For two LABQAs of the same analyte and fraction in the same LabBatch with the same SampleTypeCode the only way to differentiate between them is the CollectionTime/SampleDate or the LabReplicate. |
| SW_C_140 | Chemistry | NULL; | Missing PrepPreservationName, a required field. | PrepPreservationName is required to be filled out. |
| SW_C_141 | Chemistry | NULL; | Missing PrepPreservationDate, a required field. | PrepPreservationDate is required to be filled out. |
| SW_C_142 | Chemistry | NULL; | Missing DigestExtractMethod, a required field. | DigestExtractMethod is required to be filled out. |
| SW_C_143 | Chemistry | NULL; | Missing DigestExtractDate, a required field. | DigestExtractDate is required to be filled out. |
| SW_C_144 | Chemistry | NULL; | Missing LabBatch, a required field. | LabBatch is required to be filled out. |
| SW_C_145 | Chemistry | NULL; | Missing AnalysisDate, a required field. | AnalysisDate is required to be filled out. |
| SW_C_146 | Chemistry | NULL; | Missing LabReplicate, a required field. | LabReplicate is required to be filled out. |
| SW_C_147 | Chemistry | NULL; | Missing MatrixName, a required field. | MatrixName is required to be filled out. |
| SW_C_148 | Chemistry | NULL; | Missing MethodName, a required field. | MethodName is required to be filled out. |
| SW_C_149 | Chemistry | NULL; | Missing AnalyteName, a required field. | AnalyteName is required to be filled out. |
| SW_C_15 | Chemistry | LABQA; | MatrixName incorrect for a LABQA | We are expecting the MatrixName to be either "labwater" or "blankwater" for water chemistry LABQAs and "blankmatrix" or "sediment" for sediment LABQAs. If the AnalyteName is "Chlorophyll a" the row is excluded from the check. |
| SW_C_150 | Chemistry | NULL; | Missing FractionName, a required field. | FractionName is required to be filled out. |
| SW_C_151 | Chemistry | NULL; | Missing UnitName, a required field. | UnitName is required to be filled out. |
| SW_C_152 | Chemistry | NULL; | Missing DiutionlFactor, a required field. | DilutionFactor is required to be filled out. The default is 1. |
| SW_C_153 | Chemistry | NULL; | Missing Result, a required field. | Result is required to be filled out. |
| SW_C_154 | Chemistry | NULL; | Missing MDL, a required field. | MDL is required to be filled out. |
| SW_C_155 | Chemistry | NULL; | Missing RL, a required field. | RL is required to be filled out. |
| SW_C_156 | Chemistry | NULL; | Missing LabBatch, a required field. | LabBatch is required to be filled out. |
| SW_C_157 | Chemistry | NULL; | Missing LabAgencyCode, a required field. | LabAgencyCode is required to be filled out. |
| SW_C_158 | Chemistry | NULL; | Missing LabSubmissionCode, a required field. | LabSubmissionCode is required to be filled out. |
| SW_C_159 | Chemistry | NULL; | Missing SubmittingAgencyCode, a required field. | SubmittingAgencyCode is required to be filled out. |
| SW_C_16 | Chemistry | LABQA; | Incorrect SampleDate for a LABQA | For LABQAs the SampleDate should match the DigestExtractDate if there is one, and if not, it should match the AnalysisDate. FilterBlanks are excluded. |
| SW_C_160 | Chemistry | DateTime; | Invalid DateTime value | This error arises when SQL Server cannot convert the CollectionTime to a DateTime. Examples of values that cause this error are "13:30:00 AM" (the AM should be PM) and "abc" (because it is only text, not a date and/or time). |
| SW_C_161 | Chemistry | DateTime; | Invalid DateTime value | This error arises when SQL Server cannot convert the PrepPreservationDate to a DateTime. Examples of values that cause this error are "13:30:00 AM" (the AM should be PM) and "abc" (because it is only text, not a date and/or time). |
| SW_C_162 | Chemistry | DateTime; | Invalid DateTime value | This error arises when SQL Server cannot convert the DigestExtractDate to a DateTime. Examples of values that cause this error are "13:30:00 AM" (the AM should be PM) and "abc" (because it is only text, not a date and/or time). |
| SW_C_163 | Chemistry | DateTime; | Invalid DateTime value | This error arises when SQL Server cannot convert the AnalysisDate to a DateTime. Examples of values that cause this error are "13:30:00 AM" (the AM should be PM) and "abc" (because it is only text, not a date and/or time). |
| SW_C_164 | Chemistry | Numeric; | Invalid Numeric value | This error arises when SQL Server does not think the CollectionDepth is numeric data, or the value contains a '$', ',' or '\', or the value is '+', '.' or '-'. Blanks are exempt from this check. |
| SW_C_165 | Chemistry | Numeric; | Invalid Numeric value | This error arises when SQL Server does not think the LabReplicate is numeric data, or the value contains a '$', ',' or '\', or the value is '+', '.' or '-'. Blanks are exempt from this check. |
| SW_C_166 | Chemistry | Numeric; | Invalid Numeric value | This error arises when SQL Server does not think the DilutionFactor is numeric data, or the value contains a '$', ',' or '\', or the value is '+', '.' or '-'. Blanks are exempt from this check. |
| SW_C_167 | Chemistry | Numeric; | Invalid Numeric value | This error arises when SQL Server does not think the Result is numeric data, or the value contains a '$', ',' or '\', or the value is '+', '.' or '-'. Blanks are exempt from this check. |
| SW_C_168 | Chemistry | Numeric; | Invalid Numeric value | This error arises when SQL Server does not think the MDL is numeric data, or the value contains a '$', ',' or '\', or the value is '+', '.' or '-'. Blanks are exempt from this check. |
| SW_C_169 | Chemistry | Numeric; | Invalid Numeric value | This error arises when SQL Server does not think the RL is numeric data, or the value contains a '$', ',' or '\', or the value is '+', '.' or '-'. Blanks are exempt from this check. |
| SW_C_17 | Chemistry | BR; | Was the PrepPreservationDate's time correct? | This is just a warning if the time was not between 6:00AM and 7:59PM. |
| SW_C_170 | Chemistry | Numeric; | Invalid Numeric value | This error arises when SQL Server does not think the ExpectedValue is numeric data, or the value contains a '$', ',' or '\', or the value is '+', '.' or '-'. Blanks are exempt from this check. |
| SW_C_171 | Chemistry | BR; | Was the AnalysisDate's time correct? | If the time portion of AnalysisDate is not 00:00, then this error will come up unless the time was between 6:00 and 19:59. |
| SW_C_172 | Chemistry | BR; | Was the DigestExtractDate's time correct? | If the time portion of DigestExtractDate is not 00:00, then this error will come up unless the time was between 6:00 and 19:59. |
| SW_C_173 | Chemistry | BR; | Unmatched LabBatch in Results Worksheet | This error comes up when the LabBatch in the Results worksheet is not listed in the LabBatch column of the LabBatch worksheet. Blank LabBatches will not trigger this error. |
| SW_C_174 | Chemistry | BR; | Unmatched LabBatch in LabBatch Worksheet | This error comes up when the LabBatch in the LabBatch worksheet is not listed in the LabBatch column of the Results worksheet. Blank LabBatches will not trigger this error. |
| SW_C_175 | Chemistry | Constituent; LookUp; | Constituent has expired. | The Constituent constists of the MatrixName, MethodName, AnalyteName, FractionName, and UnitName. This error is generated when the combination of those fields is found in ConstituentLookUp but the EndDate has already passed. |
| SW_C_176 | Chemistry | BR; | Project does not appear to be SWAMP funded. | This error comes up when the ProjectCode is not found in the ProjectLookUp table and does not start with 'SWB', 'RWB', or 'ABL'. |
| SW_C_177 | Chemistry | LookUp; | CollectionMethodCode not found in CollectionMethodLookUp table. | The CollectionMethodCode in the Results tab did not have a match in the CollectionMethodCode column in the CollectionMethodLookUp table. |
| SW_C_178 | Chemistry | LookUp; | SampleTypeCode not found in SampleTypeLookUp table. | The SampleTypeCode in the Results tab did not have a match in the SampleTypeCode column in the SampleTypeLookUp table. |
| SW_C_179 | Chemistry | LookUp; | ProjectCode not found in ProjectLookUp table. | The ProjectCode in the Results tab did not have a match in the ProjectCode column in the ProjectLookUp table. |
| SW_C_18 | Chemistry | BR; | Was the CollectionTime correct? | This is a warning if the CollectionTime was not between 6:00AM and 7:59PM. LABQA and 000NONPJ Samples that require the CollectionTime Kludge are excluded. |
| SW_C_180 | Chemistry | LookUp; | AgencyCode not found in AgencyLookUp table. | The AgencyCode in the Results tab did not have a match in the AgencyCode column in the AgencyLookUp table. |
| SW_C_181 | Chemistry | LookUp; | PrepPreservationName not found in PrepPreservationLookUp table. | The PrepPreservationName in the Results tab did not have a match in the PrepPreservationName column in the PrepPreservationLookUp table. |
| SW_C_182 | Chemistry | LookUp; | DigestExtractMethod not found in DigestExtractLookUp table. | The DigestExtractMethod in the Results tab did not have a match in the DigestExtractMethod column in the DigestExtractLookUp table. |
| SW_C_183 | Chemistry | LookUp; | MatrixName not foud in MatrixLookUp table. | The MatrixName in the Results tab did not have a match in the MatrixName column in the MatrixLookUp table. |
| SW_C_184 | Chemistry | LookUp; | MethodName not found in MethodLookUp table. | The MethodName in the Results tab did not have a match in the MethodName column in the MethodLookUp table. |
| SW_C_185 | Chemistry | LookUp; | AnalyteName not found in AnalyteLookUp table. | The AnalyteName in the Results tab did not have a match in the AnalyteName column in the AnalyteLookUp table. |
| SW_C_186 | Chemistry | LookUp; | FractionName not found in FractionLookUp table. | The FractionName in the Results tab did not have a match in the FractionName column in the FractionLookUp table. |
| SW_C_187 | Chemistry | LookUp; | UnitName not found in UnitLookUp table. | The UnitName in the Results tab did not have a match in the UnitName column in the UnitLookUp table. |
| SW_C_188 | Chemistry | LookUp; | ResQualCode not foud in ResQualLookUp table. | The ResQualCode in the Results tab did not have a match in the ResQualCode column in the ResQualLookUp table. |
| SW_C_189 | Chemistry | LookUp; | QACode not found in QALookUp table. | The QACode in the Results tab did not have a match in the QACode column in the QALookUp table. |
| SW_C_19 | Chemistry | LABQA; | CollectionTime did not follow convention for similar LABQAs | 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. 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 replicates of each other, one CollectionTime should be 0:00 and the other 0:15. |
| SW_C_190 | Chemistry | LookUp; | StationCode not found in StationLookUp table. | The StationCode in the Results tab did not have a match in the StationCode column in the StationLookUp table. |
| SW_C_191 | Chemistry | LookUp; | UnitCollectionDepth not found in UnitLookUp table. | The UnitCollectionDepth in the Results tab did not have a match in the UnitName column in the UnitLookUp table. |
| SW_C_192 | Chemistry | LookUp; | LabAgencyCode not found in AgencyLookUp table. | The LabAgencyCode in the LabBatch tab did not have a match in the AgencyCode column in the AgencyLookUp table. |
| SW_C_193 | Chemistry | LookUp; | LabSubmissionCode not found in LabSubmissionLookUp table. | The LabSubmissionCode in the LabBatch tab did not have a match in the LabSubmissionCode column in the LabSubmissionLookUp table. |
| SW_C_194 | Chemistry | LookUp; | SubmittingAgencyCode not found in AgencyLookUp table. | The SubmittingAgencyCode in the LabBatch tab did not have a match in the AgencyCode column in the AgencyLookUp table. |
| SW_C_195 | Chemistry | LookUp; | EventCode has expired. | If the EventCode is found in the EventLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_196 | Chemistry | LookUp; | ProtocolCode has expired. | If the ProtocolCode is found in the ProtocolLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_197 | Chemistry | LookUp; | LocationCode has expired. | If the LocationCode is found in the LocationLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_198 | Chemistry | LookUp; | CollectionMethodCode has expired. | If the CollectionMethodCode is found in the CollectionMethodLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_199 | Chemistry | LookUp; | SampleTypeCode has expired. | If the SampleTypeCode is found in the SampleTypeLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_2 | Chemistry | Constituent; LookUp; | Constituent not found in ConstituentLookUp | The Constituent constists of the MatrixName, MethodName, AnalyteName, FractionName, and UnitName. This error is generated when the combination of those fields is not found in ConstituentLookUp. |
| SW_C_20 | Chemistry | 000NONPJ; | CollectionTime did not follow convention for similar 000NONPJs | 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. For example when more than one 000NONPJ sample is digested, extracted or analyzed in the same batch on the same day but are not replicates of each other and are not from the same native sample, one CollectionTime should be 0:00 and the other 0:15. |
| SW_C_200 | Chemistry | LookUp; | ProjectCode has expired. | If the ProjectCode is found in the ProjectLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_201 | Chemistry | LookUp; | AgencyCode has expired. | If the AgencyCode is found in the AgencyLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_202 | Chemistry | LookUp; | PrepPreservationName has expired. | If the PrepPreservationName is found in the PrepPreservationLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_203 | Chemistry | LookUp; | DigestExtractMethod has expired. | If the DigestExtractMethod is found in the DigestExtractLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_204 | Chemistry | LookUp; | MatrixName has expired. | If the MatrixName is found in the MatrixLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_205 | Chemistry | LookUp; | MethodName has expired. | If the MethodName is found in the MethodLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_206 | Chemistry | LookUp; | AnalyteName has expired. | If the AnalyteName is found in the AnalyteLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_207 | Chemistry | LookUp; | FractionName has expired. | If the FractionName is found in the FractionLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_208 | Chemistry | LookUp; | UnitName has expired. | If the UnitName is found in the UnitLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_209 | Chemistry | LookUp; | ResQualCode has expired. | If the ResQualCode is found in the ResQualLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_21 | Chemistry | 000NONPJ; | LabBatch was neither _W_, _S_, nor _B_ for a 000NONPJ | This is only a warning. When the StationCode is 000NONPJ, following the LabBatch naming convention of using "_W_", "_S_", or "_B_" is the only way to differentiate between water, sediment, and benthic samples. If the convention is not followed, the checks for 000NONPJs only will not be run. |
| SW_C_210 | Chemistry | LookUp; | QACode has expired. | If the QACode is found in the QALookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_211 | Chemistry | LookUp; | StationCode has expired. | If the StationCode is found in the StationLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_212 | Chemistry | LookUp; | UnitCollectionDepth has expired. | If the UnitCollectionDepth is found in the UnitLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_213 | Chemistry | LookUp; | LabAgencyCode has expired. | If the LabAgencyCode is found in the AgencyLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_214 | Chemistry | LookUp; | LabSubmissionCode has expired. | If the LabSubmissionCode is found in the LabsubmissionLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_215 | Chemistry | LookUp; | SubmittingAgencyCode has expired. | If the SubmittingAgencyCode is found in the AgencyLookUp table, this error will come up if it's EndDate is in the past. |
| SW_C_216 | Chemistry | LookUp; | LocationCode not found in LocationLookUp table. | The LocationCode in the Results tab did not have a match in the LocationCode column in the LocationLookUp table. |
| SW_C_217 | Chemistry | BR; LABQA; | CollectionTime was not "00:00" (nor "00:15", "00:30", etc.) or is missing a sample with a time 15 minutes prior for a LABQA sample. | This check makes sure that the CollectionTime is either "00:00" or that a multiple of 15 minutes has been added to it. If the CollectionTime is not "00:00" then there has to be another record with the same SampleTypeCode, LabBatch, StationCode, and SampleDate with a CollectionTime that is 15 minutes prior. |
| SW_C_218 | Chemistry | BR; 000NONPJ; | CollectionTime was not "00:00" (nor "00:15", "00:30", etc.) or is missing a sample with a time 15 minutes prior for a 000NONPJ sample. | This check makes sure that the CollectionTime is either "00:00" or that a multiple of 15 minutes has been added to it. If the CollectionTime is not "00:00" then there has to be another record with the same LabBatch, StationCode, and SampleDate with a CollectionTime that is 15 minutes prior. |
| SW_C_219 | Chemistry | BR; | Same MDL/RL reported for differing dilutions of an analyte within the same batch | This error should come up when two rows have the same LabBatch, AnalyteName, MDL, and RL but have different DilutionFactors. |
| SW_C_22 | Chemistry | 000NONPJ; | EventCode was not WQ for a Chemistry 000NONPJ | If the StationCode is "000NONPJ" and the LabBatch contains either "_W_" or "_S_" then the Eventcode should be "WQ". |
| SW_C_220 | Chemistry | Duplicate; | Duplicate entry in Results Worksheet | This error comes up when there are two rows with the same values for columns B-N and Q-AB (StationCode, EventCode, ProtocolCode, LocationCode, SampleDate, CollectionTime, CollectionMethodCode, SampleTypeCode, Replicate, CollectionDepth, UnitCollectionDepth, ProjectCode, AgencyCode, PrepPreservationName, PrepPreservationDate, DigestExtractMethod, DigestExtractDate, LabBatch, AnalysisDate, LabReplicate, MatrixName, MethodName, AnalyteName, FractionName, and UnitName). |
| SW_C_223 | Chemistry | BR: | Rlog expected for bacteria data. | This error comes up when the LabReplicate is 2, the AnalyteName is one of "Enterococcus", "Salmonella", or "Cryptosporidium", or it contains "coli", and the LabResultComments does not contain "Rlog". |
| SW_C_224 | Chemistry | BR; | Rlog not in expected format. | If the LabResultComments contains "Rlog" then it is expected to be in this format: Rlog # > #, Rlog # < #, Rlog # >= #, or Rlog # <= #, where # can be any number. The Rlog should always be calculable so this error will come up for "Rlog not calculable". |
| SW_C_225 | Chemistry | BR; | Rlog not less than or equal to criteria; QACode required. | This error comes up when "ILN" is not part of the QACode and the LabResultComments contained Rlog # > #. |
| SW_C_23 | Chemistry | 000NONPJ; | ProtocolCode should have been "Not Applicable" for a Chemistry 000NONPJ | If the StationCode is "000NONPJ" and the LabBatch contains either "_W_" or "_S_" then the ProtocolCode should be "Not Applicable". |
| SW_C_24 | Chemistry | 000NONPJ; | LocationCode should have been "Not Recorded" for a Chemistry 000NONPJ | If the StationCode is "000NONPJ" and the LabBatch contains either "_W_" or "_S_" then the LocationCode should be "Not Recorded". |
| SW_C_25 | Chemistry | 000NONPJ; | Invalid 000NONPJ SampleTypeCode | If the StationCode is "000NONPJ", the SampleTypeCode should be either "Grab or "MS1" |
| SW_C_26 | Chemistry | 000NONPJ; | Incorrect SampleDate for a 000NONPJ | For 000NONPJs the SampleDate should match the DigestExtractDate if there is one, and if not, it should match the AnalysisDate. LabBatches that do not contain either "_W_" or "_S_" are excluded from this check. |
| SW_C_27 | Chemistry | 000NONPJ; | CollectionMethodCode should be "Not Recorded" for a Chemistry 000NONPJ | If the StationCode is "000NONPJ", the CollectionMethodCode should be "Not Recorded". LabBatches that do not contain either "_W_" or "_S_" are excluded from this check. |
| SW_C_28 | Chemistry | 000NONPJ; | Replicate should have been "1" for a Chemistry 000NONPJ | If the StationCode is "000NONPJ", the Replicate should be "1". LabBatches that do not contain either "_W_" or "_S_" are excluded from this check. |
| SW_C_29 | Chemistry | 000NONPJ; | UnitCollectionDepth was neither "m" nor "cm" for a Chemistry 000NONPJ | If the StationCode is "000NONPJ", the UnitCollectionDepth should be either "m" or "cm". LabBatches that do not contain either "_W_" or "_S_" are excluded from this check. |
| SW_C_3 | Chemistry | LABQA; | LabBatch was neither _W_, _S_, nor _B_ for a LABQA | This is only a warning. For LABQAs, following the LabBatch naming convention of using "_W_", "_S_", or "_B_" is the only way to differentiate between water, benthic, and sediment samples. If the convention is not followed, the checks for LABQAs only will not be run. |
| SW_C_30 | Chemistry | 000NONPJ; | ProjectCode should have been "Not Applicable" for a Chemistry 000NONPJ | If the StationCode is "000NONPJ", the ProjectCode should be "Not Applicable". LabBatches that do not contain either "_W_" or "_S_" are excluded from this check. |
| SW_C_31 | Chemistry | 000NONPJ; | Incorrect LabReplicate for a Chemistry 000NONPJ | If the StationCode is "000NONPJ", the LabReplicate should be either "1" or "2". LabBatches that do not contain either "_W_" or "_S_" are excluded from this check. |
| SW_C_32 | Chemistry | 000NONPJ; | MatrixName was not "samplewater", "sediment", or ''benthic'' for a Chemistry 000NONPJ | If the StationCode is "000NONPJ", the MatrixName should be either "samplewater", "sediment", or ''benthic''. LabBatches that do not contain either "_W_", "_S_", or ''_B_'' are excluded from this check. |
| SW_C_33 | Chemistry | BR; | LabSampleID indicates a duplicate but SampleTypeCode does not. | If the LabSampleID ends in "ms" or "msd" then the SampleTypeCode should start with "MS". |
| SW_C_34 | Chemistry | BR; | This LabSampleID has multiple StationCode/SampleTypeCode/SampleDate combinations. | Each LabSampleID should correspond to only one StationCode, SampleTypeCode, and SampleDate. LABQAs can have multiple SampleDates. This error should not come up for blank LabSampleIDs or StationCodes of "000NONPJ". Please filter on the LabSampleID to see where the problem lies. |
| SW_C_35 | Chemistry | BR; | Incorrect PrepPreservationDate | The PrepPreservationDate should be >= the SampleDate if the PrepPreservationName is supplied, or if the PrepPreservationName was either blank or "None", then the date should be the default "01/Jan/1950 00:00". 000NONPJ and LABQA data are excluded. |
| SW_C_36 | Chemistry | BR; | Incorrect DigestExtractDate | If there was a DigestExtract then the DigestExtractDate needs to be >= the SampleDate. If the DigestExtractMethod was either blank or "None", then the DigestExtractDate should be the default "01/Jan/1950 00:00". |
| SW_C_37 | Chemistry | BR; | StationCode with multiple LabSampleIDs but matching Replicates and SampleTypes. | This error is generated when there is a StationCode with multiple LabSampleIDs that have the same LabBatch, SampleDate, CollectionTime, SampleTypeCode, Replicate, LabReplicate, CollectionMethodCode, AnalyteName, MatrixName, FractionName, and CollectionDepth. LABQAs are ignored by this check. |
| SW_C_38 | Chemistry | BR; | Differing dependent values for a StationCode/LabSampleID combination | For each unique StationCode/LabSampleID combination, the following fields are expected to be the same: SampleDate, CollectionTime, UnitCollectionDepth, EventCode, ProtocolCode, LocationCode, CollectionMethodCode, ProjectCode, and AgencyCode. StationCodes of "LABQA" and "000NONPJ" are excluded. |
| SW_C_39 | Chemistry | BR; | LabBatch with multiple UnitCollectionDepths | All entries with the same LabBatch should have the same UnitCollectionDepth. |
| SW_C_4 | Chemistry | LABQA; | EventCode was not WQ for a Chemistry LABQA | If the StationCode is "LABQA" and the LabBatch contains either "_W_" or "_S_" then the Eventcode should be "WQ". |
| SW_C_40 | Chemistry | BR; | AnalysisDate/Time was more than 24 hours after earliest AnalysisDate/Time in the LabBatch. | If the AnalysisDate for a row is more than 24 hours (coded as more than 1440 minutes) greater than the earliest AnalysisDate in the LabBatch, this error will come up. Analytes with Group of "Organics" are excluded. |
| SW_C_41 | Chemistry | BR; | Result was not -MDL for an ND | When the ResQualCode is "ND" the Result should be the negative of the MDL unless both the Result and MDL are "-88". |
| SW_C_42 | Chemistry | BR; | ResQualCode was not ND for a negative result | The only situation where the Result should be negative is if the ResQualCode is "ND" or "NR". If the Result is "-88" then a ResQualCode of "NA" is allowed. |
| SW_C_43 | Chemistry | BR; | Result was not -88 for a ResQualCode of NR | A Result of "-88" requires a ResQualCode of "NR". |
| SW_C_44 | Chemistry | BR; | LabResultComments expected when ResQualCode is NR | A ResQualCode of "NR" is required to be explained in the LabResultComments. |
| SW_C_45 | 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. |
| SW_C_46 | Chemistry | BR; | The MDL and RL cannot both be "-88" | Either the MDL or the RL may be "-88" but not both. The exceptions are if the UnitName is "%" or the AnalyteName is "Moisture", "Lipid", or ends with "(Surrogate)". |
| SW_C_47 | Chemistry | BR; | RL not >= MDL | The Reporting Limit is expected to be greater than or equal to the Method Detection Limit. |
| SW_C_48 | Chemistry | BR; | ExpectedValue required based on SampleTypeCode | A non-zero ExpectedValue is required if the SampleTypeCode is one of the following: "MS1", "MS2", "LCS", "CRM" or "MSBLDup" and the UnitName is not "%". |
| SW_C_49 | Chemistry | BR; | Incorrect UnitCollectionDepth | UnitCollectionDepth should be "m" for water chemistry samples and "cm" for sediment samples. LabBatches containing "_W_" indicate water chemistry samples, "_S_" denotes sediment samples. |
| SW_C_5 | Chemistry | LABQA; | ProtocolCode was not "Not Applicable" for a LABQA | If the StationCode is "LABQA" and the LabBatch contains either "_W_" or "_S_" then the ProtocolCode should be "Not Applicable". |
| SW_C_50 | Chemistry | BR; | Expected LabReplicate higher than 1 | This error is caused by a LabSampleID ending in "MSD", "D", or "dup", suggesting the entry is a Duplicate or Matrix Spike Duplicate while the Replicate and LabReplicate are both "1". StationCodes of "LABQA" and SampleTypeCodes of "FieldBLDup" are excluded, as are results that are the only one of it's analyte in the batch. |
| SW_C_51 | Chemistry | MS; | Could not find the MS this is a duplicate of | A SampleTypeCode beginning with "MS" along with a LabSampleID ending in "D", "MSD", or "Dup" denotes a Matrix Spike Duplicate. The matrix spike it is a duplicate of should have the same StationCode, EventCode, ProtocolCode, LocationCode, SampleDate, CollectionTime, CollectionMethodCode, SampleTypeCode, Replicate, CollectionDepth, UnitCollectionDepth, ProjectCode, and AgencyCode; It's LabSampleID should not end in "MSD", "D", or "Dup". |
| SW_C_52 | Chemistry | MS; | Could not find the native sample for this MS | If the SampleTypeCode begins with "MS" there should be another record with the same StationCode, EventCode, ProtocolCode, LocationCode, SampleDate, CollectionTime, CollectionMethodCode, CollectionDepth, UnitCollectionDepth, ProjectCode, AgencyCode, PrepPreservationName, PrepPreservationDate, DigestExtractMethod, DigestExtractDate, LabBatch, MatrixName, MethodName, AnalyteName, FractionName, and UnitName. "MS1" will only match a native with a Replicate of "1". "MS2" will only match a native with a Replicate of "2". "MSBLDup" will only match samples with a SampleTypeCode of "CompBLDup" or "FieldBLDup". Matches cannot have SampleTypeCodes beginning with "MS". StationCodes of "000NONPJ" or rows with a QACode of "QAX" are excluded. |
| SW_C_53 | Chemistry | MS; | Matrix spike matched multiple native samples | This error comes up when a Matrix Spike (Identified by a SampleTypeCode of 'MS1', 'MS2', or 'MSBLDup') matches multiple Native Samples by having columns B-H, J-N, Q-U, W-AB in common, while the match has a LabReplicate of '1' and a SampleTypeCode that does not begin with 'MS'. Additionally, an MS1 will only match rows with a Replicate of '1' where the SampleTypeCode is not 'FieldBLDup'; an MS2 will only match rows with a Replicate of '1' where the SampleTypeCode is not 'FieldBLDup'; an MSBLDup will only match rows where the SampleTypeCode is 'FieldBLDup'. |
| SW_C_54 | Chemistry | BR; | Did not expect LabReplicate to be 2 | This error arises when the LabReplicate is "2" but the StationCode is not "LABQA" and the LabSampleID does not suggest it is a Duplicate or a MSD (By ending in 'R2', 'D', '2', 'MS2', or containing 'MSD' or 'Dup'). |
| SW_C_55 | Chemistry | BR; | Sample not found in database | Columns B-N uniquely identify a sample. The sample is normally input prior to lab analysis. Without the sample in the database, the rest of the data cannot be loaded. StationCodes of "LABQA" and "000NONPJ" are excluded as are SampleTypeCodes of "MS*". |
| SW_C_56 | Chemistry | BR; | Incorrect MatrixName | The only MatrixNames currently accepted are "samplewater", "sediment, interstitialwater", "sediment", "sedimentsuspended", "sediment, <63 um", ''sediment, 63 um to 2 mm'', ''samplewater, particulate, >200 um'', ''samplewater, particulate, >125 to 200 um'', ''samplewater, particulate, >35 to 125 um'', ''samplewater, particulate, >5 to 35 um'', ''samplewater, particulate, >1.2 to 5 um'', ''samplewater, particulate, 63 um to 2 mm'', ''samplewater, particulate, <63 um'', ''samplewater, <200 um'', ''samplewater, <125 um'', ''samplewater, <35 um'', ''samplewater, <5 um'', ''samplewater, <1.2 um'', ''samplewater, <200 um'', ''benthic'', and ''effluent'' unless the StationCode is either "LABQA" or "FIELDQA" or the SampleTypeCode is "DIBlank", "EquipBlank", "FieldBlank", "FilterBlank" or "TravelBlank". |
| SW_C_58 | Chemistry | BR; | Possible Incorrect MatrixName for LABQA | If the StationCode is "LABQA" the MatrixName is not expected to be ''samplewater'', ''samplewater, particulate, >200 um'', ''samplewater, particulate, >125 to 200 um'', ''samplewater, particulate, >35 to 125 um'', ''samplewater, particulate, >5 to 35 um'', ''samplewater, particulate, >1.2 to 5 um'', ''samplewater, particulate, 63 um to 2 mm'', ''samplewater, particulate, <63 um'', ''samplewater, <200 um'', ''samplewater, <125 um'', ''samplewater, <35 um'', ''samplewater, <5 um'', ''samplewater, <1.2 um'', ''samplewater, <200 um'', ''effluent'', or ''benthic''. Additionally, if the LabBatch doesn't contain '_S_' then the MatrixName is not expected to be ''sediment, interstitialwater'', ''sediment'', ''sedimentsuspended'', ''sediment, <63 um'', ''sediment, 63 um to 2 mm'', or ''effluent''. |
| SW_C_59 | Chemistry | BR; | Expected MatrixName of "blankwater", "labwater", or "PBSWater" for a SampleTypeCode of [SampleTypeCode] | The MatrixName is expected to be "labwater", "PBSwater" or "blankwater" for the following SampleTypeCodes: "DIBlank", "EquipBlank", "FieldBlank", "FilterBlank" and "TravelBlank". |
| SW_C_6 | Chemistry | LABQA; | LocationCode was not "Not Applicable" for a LABQA | If the StationCode is "LABQA" and the LabBatch contains either "_W_" or "_S_" then the LocationCode should be "Not Applicable". |
| SW_C_60 | Chemistry | MDL; | Multiple MDLs for the same analyte in the same batch | For water chemistry batches (those with a '_W_' in the name), the MDL is expected to be the same for all rows with the same AnalyteName, DilutionFactor and LabBatch. |
| SW_C_61 | Chemistry | RL; | Multiple RLs for the same analyte in the same batch. | For water chemistry batches (those with a MatrixName ending in "water"), the RL is expected to be the same for all rows with the same AnalyteName, DilutionFactor and LabBatch. The same applies to MatrixNames of "benthic", except the following analytes are excluded "Chlorophyll a", "AFDM_Algae", and "Pheophytin a". A QACode of "RE" excludes the row from this check. This error will only come up once per LabBatch/AnalyteName combination. |
| SW_C_63 | Chemistry | BR; | Multiple UnitNames for the same analyte in the same batch | The UnitName is expected to remain the same for all rows with the same AnalyteName and LabBatch. |
| SW_C_64 | Chemistry | BR; | A,MD or QI LabSubmissionCode not explained in LabBatchComm | If the LabSubmissionCode is "A,MD" or "QI" then the LabBatchComm should not be blank. |
| SW_C_66 | Chemistry | PR; | Incorrectly formatted/missing PR | The LabResultComments should include the Percent Recovery in the format of PR XX.X for SampleTypeCodes of "MS1", "MS2", "LCS","CRM" and "MSBLDup". UnitNames of '% Recovery' are excluded, as are AnalyteNames of "Moisture" or containing 'Surrogate'. If the QACode contains "BB" then LabResultComments containing "not calculable" are excluded. |
| SW_C_67 | Chemistry | BR; | FractionName was "Dissolved" or "Particulate" with no filtration listed in the PrepPreservationName | It is expected that the PrepPreservationName contain "Filtered" if the FractionName is "Dissolved" or "Particulate". Rows with "OrthoPhosphate as P" or "Suspended Sediment Concentration" as the AnalyteName, or "LABQA" as the StationCode are excluded. |
| SW_C_68 | Chemistry | BR; | Incorrectly formatted/missing RPD | The LabResultComments should include the Relative Percent Difference in the format of RPD XX.X when the LabReplicate is 2. Rows with AnalyteNames of "Moisture" or containing 'surrogate', UnitNames of '% Recovery', SampleTypeCodes of 'LabBlank', or ResQualCodes of 'NR' are exempted. If the QACode contains "BB" then LabResultComments containing "not calculable" are excluded, as are all LabResultComments containing "Rlog". |
| SW_C_69 | Chemistry | BR; | Incorrectly formatted/missing RSD | The LabResultComments should include the Relative Standard Deviation in the form of RSD XX.X for SampleTypeCodes of "MS1", "MS2", "LCS","CRM" and "MSBLDup" when the highest LabReplicate is 3 or higher. Groups are rows that all have the same StationCode, ProtocolCode, EventCode, SampleTypeCode, Replicate, PrepPreservationName, DigestExtractMethod, LabBatch, MatrixName, MethodName, AnalyteName, FractionName, UnitName, CollectionTime, and SampleDate. Rows with a UnitName of '%' are exempted. |
| SW_C_7 | Chemistry | LABQA; | CollectionMethodCode should be "Not Applicable" for a LABQA | If the StationCode is "LABQA" and the LabBatch contains either "_W_" or "_S_" then the CollectionMethodCode should be "Not Applicable". |
| SW_C_70 | Chemistry | MDL; | MDL is negative but not -88 | This error is given when the MDL is less than 0, but not equal to -88. |
| SW_C_71 | Chemistry | RL; | RL is negative but not -88 | This error is given when the RL is less than 0, but not equal to -88. |
| SW_C_72 | Chemistry | LabBatch; | LabBatch data did not match what was already in the database. | If the LabBatch is already in the LabBatchLookUp table, this error will arise if the supplied AgencyCode, LabSubmissionCode, SubmittingAgency, or LabBatchComments differ from what is in the database. |
| SW_C_73 | Chemistry | BR; | Dilutionfactor > 1 without a QACode of "D" | This error comes up when the DilutionFactor is greater than 1, and the QACode is not "D". QACodes containing "D,", ",D," or ",D" will also prevent the error from arising. |
| SW_C_74 | Chemistry | BR; | Time portion of AnalysisDate required for this analyte. | If the minute and hour portion of the AnalysisDate are both 0, then this error will come up for certain analytes where the hold time is important. Those analytes are ''BOD'', ''BOD10day'', ''Nitrite as N'', ''OrthoPhosphate as P'', ''Turbidity'', ''E. coli'', ''E. Coli O157:H7'', ''Enterococcus'', ''Coliform'', ''Streptococcus', and "Color"'. If the PrepPreservationName does not contain "Acidified" then the following Analytes are also checked: ''Ammonia as N'', and ''Nitrate + Nitrite as N''. If the PrepPreservationName does not contain "Frozen" or "FreezeDried" then the following analytes are checked: ''Chlorophyll a'', and ''Pheophytin a'''. If the QACode does not contain "HT" then the analyte ''Nitrate as N'' is checked. StationCodes of "LABQA" are excepted. |
| SW_C_75 | Chemistry | BR; | Reporting effluent matrix; when submitting data please comment that effluent was intended to be submitted | If a MatrixName is "effluent" this error will come up once per file. The user is expected to add a comment in the comments box on the submittal page to let the SWAMP DMT know it was intentional. |
| SW_C_76 | Chemistry | BR; | Incorrect ResQualCode applied | If the Result is less than the RL or MDL, and is not "-88", this error will come up for ResQualCodes that are "%" or blank. |
| SW_C_77 | Chemistry | Size; | LabSampleID exceeded maximum size of 35. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 35 characters. |
| SW_C_78 | Chemistry | NULL; | Missing QACode, a required field. | QACode is required to be filled out. |
| SW_C_79 | Chemistry | DateTime; | Invalid DateTime value | This error arises when SQL Server cannot convert the SampleDate to a DateTime. Examples of values that cause this error are "13:30:00 AM" (the AM should be PM) and "abc" (because it is only text, not a date and/or time). |
| SW_C_8 | Chemistry | LABQA; | Replicate was not "1" for a LABQA | If the StationCode is "LABQA" and the LabBatch contains either "_W_" or "_S_" then the Replicate should be "1". |
| SW_C_80 | Chemistry | Numeric; | Invalid Numeric value | This error arises when SQL Server does not think the Replicate is numeric data, or the value contains a '$', ',' or '\', or the value is '+', '.' or '-'. Blanks are exempt from this check. |
| SW_C_81 | Chemistry | LookUp; | EventCode not found in EventLookUp table. | The value for the EventCode column in the Results tab did not have a match in the EventCode column in the EventLookUp table. |
| SW_C_82 | Chemistry | LookUp; | ProtocolCode not found in ProtocolLookUp table. | The ProtocolCode in the Results tab did not have a match in the ProtocolCode column in the ProtocolLookUp table. |
| SW_C_83 | Chemistry | LabBatch; | Unmatched LabBatch in [Excel_Tab] Worksheet | Each LabBatch listed in the Results worksheet must be listed in the LabBatch worksheet and vice versa. |
| SW_C_84 | Chemistry | Duplicate; | Duplicate entry in LabBatch Worksheet | Each LabBatch should be listed once and only once on the LabBatch tab. |
| SW_C_85 | Chemistry | Duplicate; | Duplicate entry in Results Worksheet | The Results Worksheet had two identical rows except for the LabSampleID, possibly. |
| SW_C_86 | Chemistry | Duplicate; | LabBatch already exists in database | The LabBatch was already found in the database. Data has already been submitted for it but it is not necessarily complete. This error is more of a warning. |
| SW_C_87 | Chemistry | Size; | StationCode exceeded maximum size of 9. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 9 characters. |
| SW_C_88 | Chemistry | Size; | EventCode exceeded maximum size of 20. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 20 characters. |
| SW_C_89 | Chemistry | Size; | ProtocolCode exceeded maximun size of 50. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 50 characters. |
| SW_C_9 | Chemistry | LABQA; 000NONPJ; | CollectionDepth was not "-88" for a QA or Non-Project Sample | If the StationCode is "LABQA", "FIELDQA", or "000NONPJ", the CollectionDepth should be "-88". FIELDQA SampleTypes of "Integrated", "Grab", "MSBLDup", "MS1", and "MS2" are excluded. |
| SW_C_90 | Chemistry | Size; | LocationCode exceeded maximum size of 50. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 50 characters. |
| SW_C_91 | Chemistry | Size; | SampleDate exceeded maximum size of 50. | Dates should be less than 50 characters. Perhaps something is wrong with the format. |
| SW_C_92 | Chemistry | Size; | CollectionTime exceeded maximum size of 50. | Dates and times should be less than 50 characters. Perhaps something is wrong with the format. |
| SW_C_93 | Chemistry | Size; | CollectionMethodCode exceeded maximum size of 50. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 50 characters. |
| SW_C_94 | Chemistry | Size; | SampleTypeCode exceeded maximum size of 20. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 20 characters. |
| SW_C_95 | Chemistry | Size; | Replicate exceeded maximum size of 10. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 10 characters. |
| SW_C_96 | Chemistry | Size; | CollectionDepth exceeded maximum size of 25. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 25 characters. |
| SW_C_97 | Chemistry | Size; | UnitCollectionDepth exceeded maximum size of 50. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 50 characters. |
| SW_C_98 | Chemistry | Size; | ProjectCode exceeded maximum size of 25. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 25 characters. |
| SW_C_99 | Chemistry | Size; | AgencyCode exceeded maximum size of 20. | The length of the value supplied in the excel file exceeded the maximum length allowed by the SWAMP Database, which is 20 characters. |