**APPENDIX D-5**

Calculate Total Trihalomethane, Total Haloacetic Acid,

Combined Nitrate = Nitrite, IndividualNitrate, Individual Nitrite,

Combined Radium, and Adjusted Gross Alpha Results

This Page is intentionally left blank

**D-5. Calculate Total Trihalomethane, Total Haloacetic Acid, Combined
Nitrate = Nitrite, Individual Nitrate, Individual Nitrite, and Combined
Radium, and Gross Alpha Excluding Uranium Results** **(Section 9.2.5)**

Check-Point Restart Issues: This process will be driven by changes to
the TSASAR table.

Calculate Totals for New or Changed SARs.

> The driver for this subprocess is the TSASAR table.
>
> The record key for this subprocess is the composite of
> D_Last_Update_Timestamp and the TSASAR_IS_NUMBER columns.
>
> The sort order for this subprocess will be D_Last_Update_Timestamp
> ascending and TSASAR_IS_NUMBER ascending.

**The following logic is used to create a total trihalomethanes
result:**

1.  Create a log in the CDS Execution Log indicating the process start
    time.

2.  Read each sample where:

    a.  the Last Update Timestamp or related result=s Last Update
        Timestamp is greater than the last time the CDS Setup program
        was run; AND

    b.  Collection End Date is greater than or equal to the CDS History
        Date; AND

    c.  related Water System Facility Type Code is equal to "DS"; AND

    d.  Rejection Reason Code is blank; AND

    e.  Compliance Purpose Indicator Code is equal to "Y" AND

    f.  Sample Type is equal to routine (RT) or maximum residence time
        (MR); AND

    g.  it does not have a result where

        i.  the referenced analyte code is equal to "2950\" AND

        ii. the User ID is not equal to "CDSSETUP" AND

    h.  at least one result where:

        i.  the referenced analyte code is equal to any one of the four
            trihalomethane analytes (2941, 2942, 2943, or 2944); AND

        ii. the Data Quality Code is equal to accepted (A) or validated
            (V).

For each sample selected above:

3.  Read the Concentration, and UOM Code, Less Than Ind, and Detection
    Lim UOM Code for each result where:

    z.  the analyte code referenced is 2941 or 2942 or 2943 or 2944; AND

    ```{=html}
    <!-- -->
    ```
    a.  Data Quality Code is equal to accepted (A) or validated (V).

4.  If the Less Than Ind is "Y" for all, user-entered results:

    a.  If the **Detection Lim UOM Code** is not the same for all
        results,

        ?.  Convert the Detection Limit Num of the other results to the
            same Detection Lim UOM Code unit for the first result as
            follows:

+--------------------------+---------------------------+--------------+
| **Detectn Lim UOM Code** | **Detectn Lim UOM Code**  | **           |
|                          |                           | Multiplier** |
| **of Other Results**     | **of 1st Result**         |              |
+==========================+===========================+==============+
| MG/L                     | UG/L                      | 1000         |
+--------------------------+---------------------------+--------------+
| MG/L                     | NG/L                      | 1000000      |
+--------------------------+---------------------------+--------------+
| UG/L                     | MG/L                      | 0.001        |
+--------------------------+---------------------------+--------------+
| UG/L                     | NG/L                      | 1000         |
+--------------------------+---------------------------+--------------+
| NG/L                     | MG/L                      | 0.000001     |
+--------------------------+---------------------------+--------------+
| NG/L                     | UG/L                      | 0.001        |
+--------------------------+---------------------------+--------------+

i.  Create a (or revise the existing) result for total trihalomethanes
    as indicated in Table TTHM1 and associate it to the current sample.

ii. If conversion cannot be accomplished because one or more Detectn Lim
    UOM Codes do not correlate to the table, an advisory will be created
    referencing message number 14 and will record: the Water System No.,
    name, tinwsys_is_number, and tinwsys_st_code; the water system
    facility state assigned ID and name; the sampling point ID and
    description; the sample=s lab sample number and collection date; and
    the result=s analtye code. write the following message to the CDS
    Setup Processing Report and then go to the next sample:

> "Could not calculate a needed result for the following sample: Lab
> Sample No. \[sbs sample.lab assigned id number\], collected on
> \[collection-end_date\] from water system \[water system.number\] -
> \[water system.name\], water system facility \[water system
> facility.state asgn identification code\], and sampling point
> \[sampling point.identification code\] because encountered improper
> unit of measure for the result."

b.  If the Detection Lim UOM Code is the same for all results, create
    (or revise the existing) result for total trihalomethanes as
    indicated in Table TTHM1 and associate it to the current sample.

```{=html}
<!-- -->
```
5.  If the Less Than Ind is not "Y" for all, user-entered results:

```{=html}
<!-- -->
```
j.  If the UOM Code for all results where Less Than Ind does not equal
    "Y" are not equal, then convert to the same UOM Code as the UOM Code
    for the first individual result where Less Than Ind does not equal
    "Y" as follows (note that, for a less than detect result, the UOM
    Code is often left blank which is the reason for adding the clause
    Awhere Less Than Ind does not equal \>Y=@):

+------------------------+-----------------------+--------------------+
| **UOM Code**           | **UOM Code**          | **Multiplier**     |
|                        |                       |                    |
| **of Other Results**   | **of 1st Result**     |                    |
+========================+=======================+====================+
| MG/L                   | UG/L                  | 1000               |
+------------------------+-----------------------+--------------------+
| MG/L                   | NG/L                  | 1000000            |
+------------------------+-----------------------+--------------------+
| UG/L                   | MG/L                  | 0.001              |
+------------------------+-----------------------+--------------------+
| UG/L                   | NG/L                  | 1000               |
+------------------------+-----------------------+--------------------+
| NG/L                   | MG/L                  | 0.000001           |
+------------------------+-----------------------+--------------------+
| NG/L                   | UG/L                  | 0.001              |
+------------------------+-----------------------+--------------------+

If conversion cannot be accomplished because one or more UOM Codes do
not correlate to the table, an advisory will be created referencing
message number 14 and will record: the Water System No., name,
tinwsys_is_number, and tinwsys_st_code; the water system facility state
assigned ID and name; the sampling point ID and description; the
sample=s lab sample number and collection date; and the result=s analtye
code.

a.  Otherwise, create (or replace existing) result for Total
    Trihalomethanes (code 2950) as follows (only populate the fields
    indicated):

+----------------------+-----------------------------------------------+
| **Table TTHM1**      |                                               |
+======================+===============================================+
| **Field Name**       | **Specification for Populating**              |
+----------------------+-----------------------------------------------+
| LESS_THAN_CODE       | If every individual trihalomethane result for |
|                      | sample has "MRL," then set to 'MRL"; if every |
|                      | one has 'MDL," then set to "MDL"; otherwise   |
|                      | set to spaces.                                |
+----------------------+-----------------------------------------------+
| LESS_THAN_IND        | If every individual trihalomethane result for |
|                      | the sample has "Y," then set to "Y."          |
|                      | Otherwise set to "N".                         |
+----------------------+-----------------------------------------------+
| DATA_QUALITY_CODE    | Set to "A."                                   |
+----------------------+-----------------------------------------------+
| REPORTED_MSR         | Convert Concentration as calculated below to  |
|                      | text                                          |
+----------------------+-----------------------------------------------+
| CONCENTRATION_MSR    | Sum of the Concentration Measures for the     |
|                      | individual trihalomethane . If a result is    |
|                      | marked as less than detect, use zero for that |
|                      | result regardless of the value entered into   |
|                      | concentration_msr. Round to the least number  |
|                      | of significant figures used in the            |
|                      | calculation (excluding the significant        |
|                      | figures indicated by a result of zero).       |
|                      | (Note, the SSWr1 design did include these     |
|                      | rounding specifications but, apparently, they |
|                      | were not implemented in SSWr1.) (A.D-5.a)     |
+----------------------+-----------------------------------------------+
| UOM_CODE             | If LESS_THAN_IND of created record is Y, do   |
|                      | not value.                                    |
|                      |                                               |
|                      | Else, set to UOM_CODE of first individual     |
|                      | trihalomethane with a UOM Code.               |
+----------------------+-----------------------------------------------+
| DETECTN_LIMIT_NUM    | If LESS_THAN_IND is set to "Y" for the        |
|                      | created record,                               |
|                      |                                               |
|                      | > Then add the DETECTN_LIMIT_NUM from each of |
|                      | > the constituent results (after conversion   |
|                      | > and (A.D-5.b) rounding).                    |
|                      |                                               |
|                      | Else (if LESS_THAN_IND is set to "N" for the  |
|                      | created record),                              |
|                      |                                               |
|                      | > Do not value                                |
+----------------------+-----------------------------------------------+
| DETECTN_LIM_UOM_CD   | If LESS_THAN_IND is set to "Y" for the        |
|                      | created record,                               |
|                      |                                               |
|                      | > Then set in accordance with specification   |
|                      | > above.                                      |
|                      |                                               |
|                      | Else (if LESS_THAN_IND is set to "N" for the  |
|                      | created record),                              |
|                      |                                               |
|                      | > Do not value                                |
+----------------------+-----------------------------------------------+
| D_LAST_UPDT_TS       | Current Date and Time                         |
+----------------------+-----------------------------------------------+
| D_USERID_CODE        | CDSSETUP                                      |
+----------------------+-----------------------------------------------+
| TSAANLYT_IS_NUMBER   | 351                                           |
+----------------------+-----------------------------------------------+
| TSAANLYT_ST_CODE     | HQ                                            |
+----------------------+-----------------------------------------------+
| TSASMN_IS_NUMBER     | If every individual trihalomethane result for |
|                      | sample references same Method Number, then    |
|                      | set to same Method Number. Otherwise set to   |
|                      | null.                                         |
+----------------------+-----------------------------------------------+
| TSASMN_ST_CODE       |                                               |
+----------------------+-----------------------------------------------+
| TSASAMPL_IS_NUMBER   | Same Sample referenced by individual          |
|                      | trihalomethane result.                        |
+----------------------+-----------------------------------------------+
| TSASAMPL_ST_CODE     |                                               |
+----------------------+-----------------------------------------------+
| TMNMPRD_IS_NUMBER    | If all the individual trihalomethane results  |
|                      | reference the same Monitoring Period, then    |
|                      | reference the same. Otherwise set to null.    |
+----------------------+-----------------------------------------------+
| TMNMPRD_ST_CODE      |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_IS_NO    | Do not need to relate the new result to an    |
|                      | SSMPA because, if appropriate, this will be   |
|                      | done by a subsequent process.                 |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_ST_CO    |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_IS_NO     |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_ST_CO     |                                               |
+----------------------+-----------------------------------------------+

**The following logic is used to create a total haloacetic acid
result:**

1.  Read each sample where:

    n.  the Last Update Timestamp or related result=s Last Update
        Timestamp is greater than the last time the CDS Setup program
        was run; AND

    ```{=html}
    <!-- -->
    ```
    a.  Collection End Date is greater than or equal to the CDS History
        Date; AND

    b.  Rejection Reason Code is blank; AND

    c.  Compliance Purpose Indicator Code is equal to "Y" AND

    d.  Sample Type is equal to routine (RT) or maximum residence time
        (MR); AND

    e.  it does not have a result where

        ?.  the referenced analyte code is equal to "2456\" AND

        ```{=html}
        <!-- -->
        ```
        i.  the User ID is not equal to "CDSSETUP"

> AND

f.  at least one result where:

    ?.  the referenced analyte code is equal to any one of the five
        haloacetic acid analytes (2450, 2451, 2452, 2453, or 2454); AND

    ```{=html}
    <!-- -->
    ```
    i.  the Data Quality Code is equal to accepted (A) or validated (V).

For each sample selected above:

2.  Read the Concentration and UOM Code for each result where:

    a.  the analyte code referenced is 2450 or 2451 or 2452 or 2453 or
        2454

    b.  the Data Quality Code is equal to accepted (A) or validated (V).

```{=html}
<!-- -->
```
1.  If the Less Than Ind is "Y" for all, user-entered results:

    n.  If the **Detection Lim UOM Code** is not the same for all
        results,

        ?.  Convert the Detection Limit Num of the other results to the
            same Detection Lim UOM Code unit for the first result as
            follows:

+--------------------------+---------------------------+--------------+
| **Detectn Lim UOM Code** | **Detectn Lim UOM Code**  | **           |
|                          |                           | Multiplier** |
| **of Other Results**     | **of 1st Result**         |              |
+==========================+===========================+==============+
| MG/L                     | UG/L                      | 1000         |
+--------------------------+---------------------------+--------------+
| MG/L                     | NG/L                      | 1000000      |
+--------------------------+---------------------------+--------------+
| UG/L                     | MG/L                      | 0.001        |
+--------------------------+---------------------------+--------------+
| UG/L                     | NG/L                      | 1000         |
+--------------------------+---------------------------+--------------+
| NG/L                     | MG/L                      | 0.000001     |
+--------------------------+---------------------------+--------------+
| NG/L                     | UG/L                      | 0.001        |
+--------------------------+---------------------------+--------------+

> ii\. Create a (or revise the existing) result for total haloacetic
> acid as indicated in Table HAA1 and associate it to the current
> sample.
>
> iii\. If conversion cannot be accomplished because one or more Detectn
> Lim UOM Codes do not correlate to the table an advisory will be
> created referencing message number 14 and will record: the Water
> System No., name, tinwsys_is_number, and tinwsys_st_code; the water
> system facility state assigned ID and name; the sampling point ID and
> description; the sample=s lab sample number and collection date; and
> the result=s analtye code.
>
> b\. If the Detection Lim UOM Code is the same for all results, create
> (or revise the existing) result for total haloacetic acids as
> indicated in Table HAA1 and associate it to the current sample.

4\. If the Less Than Ind is not "Y" for all, user-entered results:

d.  If the UOM Code for all results where Less Than Ind does not equal
    "Y" are not equal, then convert to the same UOM Code as the UOM Code
    for the first individual result where Less Than Ind does not equal
    "Y" as follows:

+------------------------+-----------------------+--------------------+
| **UOM Code**           | **UOM Code**          | **Multiplier**     |
|                        |                       |                    |
| **of Other Results**   | **of 1st Result**     |                    |
+========================+=======================+====================+
| MG/L                   | UG/L                  | 1000               |
+------------------------+-----------------------+--------------------+
| MG/L                   | NG/L                  | 1000000            |
+------------------------+-----------------------+--------------------+
| UG/L                   | MG/L                  | 0.001              |
+------------------------+-----------------------+--------------------+
| UG/L                   | NG/L                  | 1000               |
+------------------------+-----------------------+--------------------+
| NG/L                   | MG/L                  | 0.000001           |
+------------------------+-----------------------+--------------------+
| NG/L                   | UG/L                  | 0.001              |
+------------------------+-----------------------+--------------------+

> If conversion cannot be accomplished because one or more UOM Codes do
> not correlate to the table an advisory will be created referencing
> message number 14 and will record: the Water System No., name,
> tinwsys_is_number, and tinwsys_st_code; the water system facility
> state assigned ID and name; the sampling point ID and description; the
> sample=s lab sample number and collection date; and the result=s
> analtye code.

a.  Otherwise, create (or replace existing) result for Total Haloacetic
    Acids (code 2456) as follows (only populate the fields indicated):

+----------------------+-----------------------------------------------+
| **Table HAA1**       |                                               |
+======================+===============================================+
| **Field Name**       | **Specification for Populating**              |
+----------------------+-----------------------------------------------+
| LESS_THAN_CODE       | If every individual haloacetic acid result    |
|                      | for sample has "MRL," then set to "MRL"; if   |
|                      | every one has "MDL," then set to "MDL";       |
|                      | otherwise set to spaces.                      |
+----------------------+-----------------------------------------------+
| LESS_THAN_IND        | If every individual haloacetic acid result    |
|                      | for the sample has "Y," then set to "Y."      |
|                      | Otherwise set to "N."                         |
+----------------------+-----------------------------------------------+
| DATA_QUALITY_CODE    | Set to "A"                                    |
+----------------------+-----------------------------------------------+
| REPORTED_MSR         | Convert Concentration as calculated below to  |
|                      | text.                                         |
+----------------------+-----------------------------------------------+
| CONCENTRATION_MSR    | Sum of the Concentration Measures for the     |
|                      | individual haloacetic acids. If a result is   |
|                      | marked as less than detect, use zero for that |
|                      | result regardless of the value entered into   |
|                      | concentration_msr. Round to the least number  |
|                      | of significant figures used in the            |
|                      | calculation (excluding the significant        |
|                      | figures indicated by a result of zero).       |
|                      | (Note, the SSWr1 design did include these     |
|                      | rounding specifications but, apparently, they |
|                      | were not implemented in SSWr1.) (A.D-5.c)     |
+----------------------+-----------------------------------------------+
| UOM_CODE             | Set to UOM_CODE of first individual           |
|                      | haloacetic acid with a UOM Code.              |
+----------------------+-----------------------------------------------+
| DETECTN_LIMIT_NUM    | If LESS_THAN_IND is set to "Y" for the        |
|                      | created record,                               |
|                      |                                               |
|                      | > Then add the DETECTN_LIMIT_NUM from each of |
|                      | > the constituent results (after conversion   |
|                      | > and (A.D-5.d) rounding).                    |
|                      |                                               |
|                      | Else (if LESS_THAN_IND is set to "N" for the  |
|                      | created record),                              |
|                      |                                               |
|                      | > Do not value                                |
+----------------------+-----------------------------------------------+
| DETECTN_LIM_UOM_CD   | If LESS_THAN_IND is set to "Y" for the        |
|                      | created record,                               |
|                      |                                               |
|                      | > Then set in accordance with specification   |
|                      | > above.                                      |
|                      |                                               |
|                      | Else (if LESS_THAN_IND is set to "N" for the  |
|                      | created record),                              |
|                      |                                               |
|                      | > Do not value                                |
+----------------------+-----------------------------------------------+
| D_LAST_UPDT_TS       | Current Date and Time                         |
+----------------------+-----------------------------------------------+
| D_USERID_CODE        | CDSSETUP                                      |
+----------------------+-----------------------------------------------+
| TSAANLYT_IS_NUMBER   | 812                                           |
+----------------------+-----------------------------------------------+
| TSAANLYT_ST_CODE     | HQ                                            |
+----------------------+-----------------------------------------------+
| TSASMN_IS_NUMBER     | Set to null.                                  |
+----------------------+-----------------------------------------------+
| TSASMN_ST_CODE       |                                               |
+----------------------+-----------------------------------------------+
| TSASAMPL_IS_NUMBER   | Same Sample referenced by individual          |
|                      | haloacetic acid result.                       |
+----------------------+-----------------------------------------------+
| TSASAMPL_ST_CODE     |                                               |
+----------------------+-----------------------------------------------+
| TMNMPRD_IS_NUMBER    | If all the individual haloacetic acid results |
|                      | reference the same Monitoring Period, then    |
|                      | reference the same. Otherwise set to null.    |
+----------------------+-----------------------------------------------+
| TMNMPRD_ST_CODE      |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_IS_NO    | Do not need to relate the new result to an    |
|                      | SSMPA because, if appropriate, this will be   |
|                      | done by a subsequent process.                 |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_ST_CO    |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_IS_NO     |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_ST_CO     |                                               |
+----------------------+-----------------------------------------------+

**The following logic is used to create a combine nitrate + nitrite
result:**

1\. Read each sample where:

d.  the Last Update Timestamp or related result=s Last Update Timestamp
    is greater than the last time the CDS Setup program was run; AND

```{=html}
<!-- -->
```
b.  Collection End Date is greater than or equal to the CDS History
    Date; AND

c.  Rejection Reason Code is blank; AND

d.  Compliance Purpose Indicator Code is equal to "Y" AND

e.  Sample Type is equal to routine (RT) or confirmation (CO); AND

f.  A result for both analyte code 1041 and 1040 where the Data Quality
    Code is equal to accepted (A) or validated (V) for both; AND

g.  Either:

    ?.  it does not have a result for analyte code "1038" or

    ```{=html}
    <!-- -->
    ```
    i.  it does have a result for analyte code "1038" where the User ID
        is equal to "CDSSETUP."

For each sample selected above:

2\. Read the Concentration, UOM Code, Less Than Ind, Detection Limit
Num, Detection Lim UOM Code for each result where:

> the analyte code referenced is 1041 or 1040
>
> the Data Quality Code is equal to accepted (A) or validated (V).

If the Less Than Ind is "Y" for both results:

> If the Detection Lim UOM Code is not the same for both results,
>
> Convert the Detection Limit Num of the second result to the same
> Detection Lim UOM Code unit for the first result as follows:

+--------------------------+---------------------------+--------------+
| **Detectn Lim UOM Code** | **Detectn Lim UOM Code**  | **           |
|                          |                           | Multiplier** |
| **of 2^nd^ Result**      | **of 1^st^ Result**       |              |
+==========================+===========================+==============+
| MG/L                     | UG/L                      | 1000         |
+--------------------------+---------------------------+--------------+
| MG/L                     | NG/L                      | 1000000      |
+--------------------------+---------------------------+--------------+
| UG/L                     | MG/L                      | 0.001        |
+--------------------------+---------------------------+--------------+
| UG/L                     | NG/L                      | 1000         |
+--------------------------+---------------------------+--------------+
| NG/L                     | MG/L                      | 0.000001     |
+--------------------------+---------------------------+--------------+
| NG/L                     | UG/L                      | 0.001        |
+--------------------------+---------------------------+--------------+

> ii\. Create a (or revise the existing) result for 1038 as indicated in
> Table N1 and associate it to the current sample.
>
> iii\. If conversion cannot be accomplished because one or both Detectn
> Lim UOM Codes do not correlate to the table an advisory will be
> created referencing message number 14 and will record: the Water
> System No., name, tinwsys_is_number, and tinwsys_st_code; the water
> system facility state assigned ID and name; the sampling point ID and
> description; the sample=s lab sample number and collection date; and
> the result=s analtye code.
>
> b\. If the Detection Lim UOM Code is the same for both results, create
> (or revise the existing) result for 1038 as indicated in Table N1 and
> associate it to the current sample.

If the Less Than Ind is "Y" for one of the results and not "Y" for the
other, create (or revise the existing) result for 1038 as indicated in
Table N2 and associate it to the current sample.

If the LESS_THAN_IND is not "Y" for either 1041 or 1040.

> If the UOM Code is not the same for both results,
>
> Convert the Concentration_Msr of the second result to the same units
> as the first as follows:

+-----------------------+--------------------------+-------------------+
| **UOM Code**          | **UOM Code**             | **Multiplier**    |
|                       |                          |                   |
| **of 2^nd^ Result**   | **of 1^st^ Result**      |                   |
+=======================+==========================+===================+
| MG/L                  | UG/L                     | 1000              |
+-----------------------+--------------------------+-------------------+
| MG/L                  | NG/L                     | 1000000           |
+-----------------------+--------------------------+-------------------+
| UG/L                  | MG/L                     | 0.001             |
+-----------------------+--------------------------+-------------------+
| UG/L                  | NG/L                     | 1000              |
+-----------------------+--------------------------+-------------------+
| NG/L                  | MG/L                     | 0.000001          |
+-----------------------+--------------------------+-------------------+
| NG/L                  | UG/L                     | 0.001             |
+-----------------------+--------------------------+-------------------+

> ii\. Create a (or revise the existing) result for 1038 as indicated in
> Table N3 and associate it to the current sample.

ii. If conversion cannot be accomplished because one or both UOM Codes
    do not correlate to the table an advisory will be created
    referencing message number 14 and will record: the Water System No.,
    name, tinwsys_is_number, and tinwsys_st_code; the water system
    facility state assigned ID and name; the sampling point ID and
    description; the sample=s lab sample number and collection date; and
    the result=s analtye code.

> If the UOM Code is the same for both units, create a (or revise the
> existing) result for 1038 as indicated in Table N3 and associate it to
> the current sample.

Use the same general logic as described above to create a result for
nitrate (1040) except replace references to 1040 with 1038 references to
1038 with 1040.

Use the same general logic as described above to create a result for
nitrite (1041) except replace references to 1041 with 1038 and
references to 1038 with 1041.

  -----------------------------------------------------------------------
  **Table N1 (**Less Than 
  Ind is "Y" for both     
  results)                
  ----------------------- -----------------------------------------------
  **Field Name**          **Specification for Populating**

  LESS_THAN_CODE          If the results for the two, user-entered
                          results have "MRL," then set to "MRL"; if both
                          have "MDL," then set to "MDL"; otherwise set to
                          "MDL"

  LESS_THAN_IND           Set to "Y"

  DETECTN_LIMIT_NUM       Set to the larger of the DETECTN_LIMIT_NUM for
                          the two user-entered results

  DETECTN_LIM_UOM_CD      Set to DETECTN_LIM_UOM_CD of first,
                          user-entered result.

  DATA_QUALITY_CODE       Set to "A"

  REPORTED_MSR            Set to "0"

  CONCENTRATION_MSR       Set to 0

  UOM_CODE                Set to UOM_CODE of the first, user-entered,
                          result

  D_LAST_UPDT_TS          Current Date and Time

  D_USERID_CODE           CDSSETUP

  TMNMPRD_IS_NUMBER       If both user-entered results reference the same
                          Monitoring Period, then reference the same.
                          Otherwise set to null.

  TMNMPRD_ST_CODE         

  SSMPA_SASCH_IS_NO       Do not need to relate the new result to an
                          SSMPA because, if appropriate, this will be
                          done by a subsequent process.

  SSMPA_SASCH_ST_CO       

  SSMPA_MPRD_IS_NO        

  SSMPA_MPRD_ST_CO        
  -----------------------------------------------------------------------

+----------------------+-----------------------------------------------+
| **Table N2 (**Less   |                                               |
| Than Ind is "Y" for  |                                               |
| one of the results   |                                               |
| and not "Y" for the  |                                               |
| other)               |                                               |
+======================+===============================================+
| **Field Name**       | **Specification for Populating**              |
+----------------------+-----------------------------------------------+
| LESS_THAN_CODE       | If the results for the two, user-entered,     |
|                      | results have "MRL," then set to "MRL"; if     |
|                      | both have "MDL," then set to "MDL"; otherwise |
|                      | set to null                                   |
+----------------------+-----------------------------------------------+
| LESS_THAN_IND        | Set to null                                   |
+----------------------+-----------------------------------------------+
| DETECTN_LIMIT_NUM    | Set to 0                                      |
+----------------------+-----------------------------------------------+
| DETECTN_LIM_UOM_CD   | Set to null                                   |
+----------------------+-----------------------------------------------+
| DATA_QUALITY_CODE    | Set to "A"                                    |
+----------------------+-----------------------------------------------+
| REPORTED_MSR         |                                               |
+----------------------+-----------------------------------------------+
| CONCENTRATION_MSR    | Use zero for concentration msr for the result |
|                      | that is less than detection.                  |
|                      |                                               |
|                      | If calculating a result for 1038,             |
|                      |                                               |
|                      | > then = sum of the Concentration Msr for     |
|                      | > 1040 and 1041                               |
|                      |                                               |
|                      | If calculating a result for 1040,             |
|                      |                                               |
|                      | > then = Concentration Msr for 1038 -         |
|                      | > Concentration Msr for 1041                  |
|                      |                                               |
|                      | If calculating a result for 1041,             |
|                      |                                               |
|                      | > then = Concentration Msr for 1038 -         |
|                      | > Concentration Msr for 1040                  |
|                      | >                                             |
|                      | > Round to the least number of significant    |
|                      | > figures used in the calculation (excluding  |
|                      | > the significant figures indicated by a      |
|                      | > result of zero). (Note, the SSWr1 design    |
|                      | > did include these rounding specifications   |
|                      | > but, apparently, they were not implemented  |
|                      | > in SSWr1.) (A.D-5.e)                        |
+----------------------+-----------------------------------------------+
| UOM_CODE             | Set to UOM_CODE of the user-entered result    |
|                      | where its LESS_THAN_IND is NOT equal to Y.    |
+----------------------+-----------------------------------------------+
| D_LAST_UPDT_TS       | Current Date and Time                         |
+----------------------+-----------------------------------------------+
| D_USERID_CODE        | CDSSETUP                                      |
+----------------------+-----------------------------------------------+
| TMNMPRD_IS_NUMBER    | If both user-entered results reference the    |
|                      | same Monitoring Period, then reference the    |
|                      | same. Otherwise set to null.                  |
+----------------------+-----------------------------------------------+
| TMNMPRD_ST_CODE      |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_IS_NO    | Do not need to relate the new result to an    |
|                      | SSMPA because, if appropriate, this will be   |
|                      | done by a subsequent process.                 |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_ST_CO    |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_IS_NO     |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_ST_CO     |                                               |
+----------------------+-----------------------------------------------+

+----------------------+-----------------------------------------------+
| **Table N3           |                                               |
| (**LESS_THAN_IND is  |                                               |
| not "Y" for either   |                                               |
| result)              |                                               |
+======================+===============================================+
| **Field Name**       | **Specification for Populating**              |
+----------------------+-----------------------------------------------+
| LESS_THAN_CODE       | If the results for the two, user-entered,     |
|                      | results have "MRL," then set to "MRL"; if     |
|                      | both have "MDL," then set to "MDL"; otherwise |
|                      | set to null                                   |
+----------------------+-----------------------------------------------+
| LESS_THAN_IND        | Set to null                                   |
+----------------------+-----------------------------------------------+
| DETECTN_LIMIT_NUM    | Set to 0                                      |
+----------------------+-----------------------------------------------+
| DETECTN_LIM_UOM_CD   | Set to null                                   |
+----------------------+-----------------------------------------------+
| DATA_QUALITY_CODE    | Set to "A"                                    |
+----------------------+-----------------------------------------------+
| REPORTED_MSR         | Convert Concentration as calculated below to  |
|                      | text                                          |
+----------------------+-----------------------------------------------+
| CONCENTRATION_MSR    | If calculating a result for 1038,             |
|                      |                                               |
|                      | > then = sum of the Concentration Msr for     |
|                      | > 1040 and 1041                               |
|                      |                                               |
|                      | If calculating a result for 1040,             |
|                      |                                               |
|                      | > then = Concentration Msr for 1038 -         |
|                      | > Concentration Msr for 1041                  |
|                      |                                               |
|                      | If calculating a result for 1041,             |
|                      |                                               |
|                      | > then = Concentration Msr for 1038 -         |
|                      | > Concentration Msr for 1040                  |
|                      |                                               |
|                      | Round to the least number of significant      |
|                      | figures used in the calculation (excluding    |
|                      | the significant figures indicated by a result |
|                      | of zero). (Note, the SSWr1 design did include |
|                      | these rounding specifications but,            |
|                      | apparently, they were not implemented in      |
|                      | SSWr1.) (A.D-5.f)                             |
+----------------------+-----------------------------------------------+
| UOM_CODE             | Set to UOM_CODE of the user-entered result    |
+----------------------+-----------------------------------------------+
| D_LAST_UPDT_TS       | Current Date and Time                         |
+----------------------+-----------------------------------------------+
| D_USERID_CODE        | CDSSETUP                                      |
+----------------------+-----------------------------------------------+
| TMNMPRD_IS_NUMBER    | If both results reference the same Monitoring |
|                      | Period, then reference the same. Otherwise    |
|                      | set to null.                                  |
+----------------------+-----------------------------------------------+
| TMNMPRD_ST_CODE      |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_IS_NO    | Do not need to relate the new result to an    |
|                      | SSMPA because, if appropriate, this will be   |
|                      | done by a subsequent process.                 |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_ST_CO    |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_IS_NO     |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_ST_CO     |                                               |
+----------------------+-----------------------------------------------+

**The following logic is used to create a combined radium result (i.e.,
analyte code 4010):**

1\. Read each sample where:

v.  the Last Update Timestamp or related result=s Last Update Timestamp
    is greater than the last time the CDS Setup program was run; AND

```{=html}
<!-- -->
```
h.  Collection End Date is greater than or equal to the CDS History
    Date; AND

i.  Rejection Reason Code is blank; AND

j.  Compliance Purpose Indicator Code is equal to "Y" AND

k.  Sample Type is equal to routine (RT) or confirmation (CO); AND

l.  There are results for both analyte code 4020 (radium 226) and 4030
    (radium 228) where the Data Quality Code is equal to accepted (A) or
    validated (V) for both; AND

m.  Either:

    ?.  There is not a result for analyte code 4010 (combined radium) or

    ```{=html}
    <!-- -->
    ```
    i.  There is a result for analyte code 4010 where the User ID is
        equal to "CDSSETUP."

For each sample selected above:

2\. Read the Concentration, UOM Code, Less Than Ind, Detection Limit
Num, Detection Lim UOM Code for each result where:

> the analyte code referenced is 4020 or 4030
>
> the Data Quality Code is equal to accepted (A) or validated (V).

If the Less Than Ind is "Y" for both results:

> If the Detection Lim UOM Code is not the same for both results, write
> the following message to the CDS Setup Processing Report and then go
> to the next sample:
>
> "Could not calculate a needed result for the following sample: Lab
> Sample No. \[sbs sample.lab assigned id number\], collected on
> \[collection-end_date\] from water system \[water system.number\] -
> \[water system.name\], water system facility \[water system
> facility.state asgn identification code\], and sampling point
> \[sampling point.identification code\] because encountered improper
> unit of measure for the result."
>
> b\. If the Detection Lim UOM Code is the same for both results, create
> (or revise the existing) result for 4010 as indicated in Table RA1 and
> associate it to the current sample.

If the Less Than Ind is "Y" for one of the results and not "Y" for the
other, create (or revise the existing) result for 4010 as indicated in
Table RA2 and associate it to the current sample.

If the LESS_THAN_IND is not "Y" for either result.

> If the UOM Code is not the same for both results an advisory will be
> created referencing message number 14 and will record: the Water
> System No., name, tinwsys_is_number, and tinwsys_st_code; the water
> system facility state assigned ID and name; the sampling point ID and
> description; the sample=s lab sample number and collection date; and
> the result=s analtye code.
>
> If the UOM Code is the same for both units, create a (or revise the
> existing) result for 4010 as indicated in Table RA3 and associate it
> to the current sample.

  -----------------------------------------------------------------------
  **Table RA1** (Less     
  Than Ind is "Y" for     
  both results)           
  ----------------------- -----------------------------------------------
  **Field Name**          **Specification for Populating**

  LESS_THAN_CODE          If the results for the two, user-entered
                          results have "MRL," then set to "MRL"; if both
                          have "MDL," then set to "MDL"; otherwise set to
                          "MDL"

  LESS_THAN_IND           Set to "Y"

  DETECTN_LIMIT_NUM       Set to the larger of the DETECTN_LIMIT_NUM for
                          the two user-entered results

  DETECTN_LIM_UOM_CD      Set to DETECTN_LIM_UOM_CD of first,
                          user-entered result.

  DATA_QUALITY_CODE       Set to "A"

  REPORTED_MSR            Set to "0"

  CONCENTRATION_MSR       Set to 0

  UOM_CODE                Set to UOM_CODE of the first, user-entered,
                          result

  D_LAST_UPDT_TS          Current Date and Time

  D_USERID_CODE           CDSSETUP

  TMNMPRD_IS_NUMBER       If both user-entered results reference the same
                          Monitoring Period, then reference the same.
                          Otherwise set to null.

  TMNMPRD_ST_CODE         

  SSMPA_SASCH_IS_NO       Do not need to relate the new result to an
                          SSMPA because, if appropriate, this will be
                          done by a subsequent process.

  SSMPA_SASCH_ST_CO       

  SSMPA_MPRD_IS_NO        

  SSMPA_MPRD_ST_CO        
  -----------------------------------------------------------------------

  -----------------------------------------------------------------------
  **Table RA2 (**Less     
  Than Ind is "Y" for one 
  of the results and not  
  the other)              
  ----------------------- -----------------------------------------------
  **Field Name**          **Specification for Populating**

  LESS_THAN_CODE          If the results for the two, user-entered,
                          results have "MRL," then set to "MRL"; if both
                          have "MDL," then set to "MDL"; otherwise set to
                          null

  LESS_THAN_IND           Set to null

  DETECTN_LIMIT_NUM       Set to 0

  DETECTN_LIM_UOM_CD      Set to null

  DATA_QUALITY_CODE       Set to "A"

  REPORTED_MSR            Set to the REPORTED_MSR of the user-entered
                          result where its LESS_THAN_IND is NOT equal to
                          Y.

  CONCENTRATION_MSR       Set to the CONCENTRATION_MSR of the
                          user-entered result where its LESS_THAN_IND is
                          NOT equal to Y.

  UOM_CODE                Set to UOM_CODE of the user-entered result
                          where its LESS_THAN_IND is NOT equal to Y.

  D_LAST_UPDT_TS          Current Date and Time

  D_USERID_CODE           CDSSETUP

  TMNMPRD_IS_NUMBER       If both user-entered results reference the same
                          Monitoring Period, then reference the same.
                          Otherwise set to null.

  TMNMPRD_ST_CODE         

  SSMPA_SASCH_IS_NO       Do not need to relate the new result to an
                          SSMPA because, if appropriate, this will be
                          done by a subsequent process.

  SSMPA_SASCH_ST_CO       

  SSMPA_MPRD_IS_NO        

  SSMPA_MPRD_ST_CO        
  -----------------------------------------------------------------------

+----------------------+-----------------------------------------------+
| **Table RA3          |                                               |
| (**LESS_THAN_IND is  |                                               |
| not "Y" for either   |                                               |
| result)              |                                               |
+======================+===============================================+
| **Field Name**       | **Specification for Populating**              |
+----------------------+-----------------------------------------------+
| LESS_THAN_CODE       | If the results for the two, user-entered,     |
|                      | results have "MRL," then set to "MRL"; if     |
|                      | both have "MDL," then set to "MDL"; otherwise |
|                      | set to null                                   |
+----------------------+-----------------------------------------------+
| LESS_THAN_IND        | Set to null                                   |
+----------------------+-----------------------------------------------+
| DETECTN_LIMIT_NUM    | Set to 0                                      |
+----------------------+-----------------------------------------------+
| DETECTN_LIM_UOM_CD   | Set to null                                   |
+----------------------+-----------------------------------------------+
| DATA_QUALITY_CODE    | Set to "A"                                    |
+----------------------+-----------------------------------------------+
| REPORTED_MSR         | Convert Concentration as calculated below to  |
|                      | text                                          |
+----------------------+-----------------------------------------------+
| CONCENTRATION_MSR    | Equal to the sum of the Concentration Msr for |
|                      | 4020 and 4030.                                |
|                      |                                               |
|                      | Round to the least number of significant      |
|                      | figures used in the calculation (excluding    |
|                      | the significant figures indicated by a result |
|                      | of zero). (Note, the SSWr1 design did include |
|                      | these rounding specifications but,            |
|                      | apparently, they were not implemented in      |
|                      | SSWr1.) (A.D-5.g)                             |
+----------------------+-----------------------------------------------+
| UOM_CODE             | Set to UOM_CODE of the first, user-entered    |
|                      | result                                        |
+----------------------+-----------------------------------------------+
| D_LAST_UPDT_TS       | Current Date and Time                         |
+----------------------+-----------------------------------------------+
| D_USERID_CODE        | CDSSETUP                                      |
+----------------------+-----------------------------------------------+
| TMNMPRD_IS_NUMBER    | If both results reference the same Monitoring |
|                      | Period, then reference the same. Otherwise    |
|                      | set to null.                                  |
+----------------------+-----------------------------------------------+
| TMNMPRD_ST_CODE      |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_IS_NO    | Do not need to relate the new result to an    |
|                      | SSMPA because, if appropriate, this will be   |
|                      | done by a subsequent process.                 |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_ST_CO    |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_IS_NO     |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_ST_CO     |                                               |
+----------------------+-----------------------------------------------+

**The following logic is used to create an adjusted gross alpha result
(i.e., gross alpha excluding uranium - analyte code 4000):**

1\. Read each sample where:

n.  the Last Update Timestamp or related result=s Last Update Timestamp
    is greater than the last time the CDS Setup program was run; AND

o.  Collection End Date is greater than or equal to the CDS History
    Date; AND

p.  Rejection Reason Code is blank; AND

q.  Compliance Purpose Indicator Code is equal to "Y" AND

r.  Sample Type is equal to routine (RT) or confirmation (CO); AND

s.  There are results for (analyte code 4002 (gross alpha including
    uranium) or analyte code 4109 (gross alpha, total)) and 4006
    (combined uranium) where the Data Quality Code is equal to
    accepted (A) or validated (V) for both; AND

t.  Either:

    i.  There is not a result for analyte code 4000 (gross alpha
        excluding uranium) or

    ii. There is a result for analyte code 4000 where the User ID is
        equal to "CDSSETUP."

For each sample selected above:

2\. Read the Concentration, UOM Code, Less Than Ind, Detection Limit
Num, Detection Lim UOM Code for each result where:

> the analyte code referenced is 4002, 4109 or 4006.

the Data Quality Code is equal to accepted (A) or validated (V).

If the Less Than Ind is "Y" for both results, create (or revise the
existing) result for 4000 as indicated in Table GA1 and associate it to
the current sample.

If the Less Than Ind is "Y" for one of the results and not "Y" for the
other, create (or revise the existing) result for 4000 as indicated in
Table GA2 and associate it to the current sample.

If the LESS_THAN_IND is not "Y" for either result.

> If the gross alpha result=s less_than_ind is not "Y" and its UOM is
> not pCi/L, an advisory will be created referencing message number 14
> and will record: the Water System No., name, tinwsys_is_number, and
> tinwsys_st_code; the water system facility state assigned ID and name;
> the sampling point ID and description; the sample=s lab sample number
> and collection date; and the result=s analtye code. The process will
> then move on to the next result.
>
> If the uranium result=s less_than_ind is not "Y" and its UOM is not
> pCi/L or ug/L or mg/L, an advisory will be created referencing message
> number 14 and will record: the Water System No., name,
> tinwsys_is_number, and tinwsys_st_code; the water system facility
> state assigned ID and name; the sampling point ID and description; the
> sample=s lab sample number and collection date; and the result=s
> analtye code. The process will then move on to the next result.
>
> Else (i.e., if the results are in the UOMs indicated above), create a
> (or revise the existing) result for 4000 as indicated in Table GA3 and
> associate it to the current sample.

  -----------------------------------------------------------------------
  **Table GA1** - If      
  Created Result is Less  
  Than Detect             
  ----------------------- -----------------------------------------------
  **Field Name**          **Specification for Populating**

  LESS_THAN_CODE          If the results for the two, user-entered
                          results have "MRL," then set to "MRL"; if both
                          have "MDL," then set to "MDL"; otherwise set to
                          "MDL"

  LESS_THAN_IND           Set to "Y"

  DETECTN_LIMIT_NUM       Set to the larger of the DETECTN_LIMIT_NUM for
                          the two user-entered results

  DETECTN_LIM_UOM_CD      Set to DETECTN_LIM_UOM_CD of the result with
                          the larger DETECTN_LIMIT_NUM.

  DATA_QUALITY_CODE       Set to "A"

  REPORTED_MSR            Set to "0"

  CONCENTRATION_MSR       Set to 0

  UOM_CODE                Set to spaces.

  D_LAST_UPDT_TS          Current Date and Time

  D_USERID_CODE           CDSSETUP

  TMNMPRD_IS_NUMBER       If both user-entered results reference the same
                          Monitoring Period, then reference the same.
                          Otherwise set to null.

  TMNMPRD_ST_CODE         

  SSMPA_SASCH_IS_NO       Do not need to relate the new result to an
                          SSMPA because, if appropriate, this will be
                          done by a subsequent process.

  SSMPA_SASCH_ST_CO       

  SSMPA_MPRD_IS_NO        

  SSMPA_MPRD_ST_CO        
  -----------------------------------------------------------------------

+----------------------+-----------------------------------------------+
| **Table GA2** - One  |                                               |
| is LTD the Other is  |                                               |
| Not                  |                                               |
+======================+===============================================+
| **Field Name**       | **Specification for Populating**              |
+----------------------+-----------------------------------------------+
| LESS_THAN_CODE       | If the results for the two, user-entered,     |
|                      | results have "MRL," then set to "MRL"; if     |
|                      | both have "MDL," then set to "MDL"; otherwise |
|                      | set to null                                   |
+----------------------+-----------------------------------------------+
| LESS_THAN_IND        | If the 4002 or 4109 result=s LESS_THAN_IND is |
|                      | NOT equal to Y,                               |
|                      |                                               |
|                      | > Set to null.                                |
|                      |                                               |
|                      | If the 4002 or 4109 result=s LESS_THAN_IND is |
|                      | equal to Y,                                   |
|                      |                                               |
|                      | > set to Y.                                   |
|                      |                                               |
|                      | Note: there should only be a result for one   |
|                      | or the other, not both. If there is a result  |
|                      | for both, use the first selected.             |
+----------------------+-----------------------------------------------+
| DETECTN_LIMIT_NUM    | If the 4002 or 4109 result=s LESS_THAN_IND is |
|                      | equal to Y, set to the DETECTN_LIMIT_NUM of   |
|                      | the 4002 or 4109 result.                      |
|                      |                                               |
|                      | Otherwise, set to the larger of the           |
|                      | DETECTN_LIMIT_NUM for the two user-entered    |
|                      | results.                                      |
+----------------------+-----------------------------------------------+
| DETECTN_LIM_UOM_CD   | If the 4002 or 4109 result=s LESS_THAN_IND is |
|                      | equal to Y, set to the DETECTN_LIM_UOM_CD of  |
|                      | the 4002 or 4109 result.                      |
|                      |                                               |
|                      | Otherwise, set to DETECTN_LIM_UOM_CD of the   |
|                      | result with the larger DETECTN_LIMIT_NUM.     |
+----------------------+-----------------------------------------------+
| DATA_QUALITY_CODE    | Set to "A"                                    |
+----------------------+-----------------------------------------------+
| REPORTED_MSR         | Set to Concentration Msr after calculation.   |
+----------------------+-----------------------------------------------+
| CONCENTRATION_MSR    | If the 4002 or 4109 result=s LESS_THAN_IND is |
|                      | NOT equal to Y, set to the CONCENTRATION_MSR  |
|                      | of the 4002 or 4109 result                    |
|                      |                                               |
|                      | If the 4002 or 4109 result=s LESS_THAN_IND is |
|                      | equal to Y, set to zero.                      |
|                      |                                               |
|                      | Note: there should only be a result for one   |
|                      | or the other, not both. If there is a result  |
|                      | for both, use the first selected.             |
+----------------------+-----------------------------------------------+
| UOM_CODE             | Set to UOM_CODE of the gross alpha result.    |
+----------------------+-----------------------------------------------+
| D_LAST_UPDT_TS       | Current Date and Time                         |
+----------------------+-----------------------------------------------+
| D_USERID_CODE        | CDSSETUP                                      |
+----------------------+-----------------------------------------------+
| TMNMPRD_IS_NUMBER    | If both user-entered results reference the    |
|                      | same Monitoring Period, then reference the    |
|                      | same. Otherwise set to null.                  |
+----------------------+-----------------------------------------------+
| TMNMPRD_ST_CODE      |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_IS_NO    | Do not need to relate the new result to an    |
|                      | SSMPA because, if appropriate, this will be   |
|                      | done by a subsequent process.                 |
+----------------------+-----------------------------------------------+
| SSMPA_SASCH_ST_CO    |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_IS_NO     |                                               |
+----------------------+-----------------------------------------------+
| SSMPA_MPRD_ST_CO     |                                               |
+----------------------+-----------------------------------------------+

+----------------------+-----------------------------------------------+
| **Table GA3** -      |                                               |
| Neither Result is    |                                               |
| LTD                  |                                               |
+======================+===============================================+
| **Field Name**       | **Specification for Populating**              |
+----------------------+-----------------------------------------------+
| LESS_THAN_CODE       | If the results for the two, user-entered,     |
|                      | results have "MRL," then set to "MRL"; if     |
|                      | both have "MDL," then set to "MDL"; otherwise |
|                      | set to null                                   |
+----------------------+-----------------------------------------------+
| LESS_THAN_IND        | Set to null                                   |
+----------------------+-----------------------------------------------+
| DETECTN_LIMIT_NUM    | Set to null                                   |
+----------------------+-----------------------------------------------+
| DETECTN_LIM_UOM_CD   | Set to null                                   |
+----------------------+-----------------------------------------------+
| DATA_QUALITY_CODE    | Set to AA@                                    |
+----------------------+-----------------------------------------------+
| REPORTED_MSR         | Convert Concentration as calculated below to  |
|                      | text                                          |
+----------------------+-----------------------------------------------+
| CONCENTRATION_MSR    | If the uranium result is in ug/L, it will be  |
|                      | converted to pCi/L by multiplying it by 0.67  |
|                      | pCi/ug.                                       |
|                      |                                               |
|                      | If the uranium result is in mg/L, it will be  |
|                      | converted to pCi/L by multiplying it by 670   |
|                      | pCi/mg.                                       |
|                      |                                               |
|                      | If the uranium result is in pCi/L, no         |
|                      | conversion is necessary.                      |
|                      |                                               |
|                      | If uranium is in any other UOM, an advisory   |
|                      | will created referencing message number 14    |
|                      | and will record: the Water System No., name,  |
|                      | tinwsys_is_number, and tinwsys_st_code; the   |
|                      | water system facility state assigned ID and   |
|                      | name; the sampling point ID and description;  |
|                      | the sample=s lab sample number and collection |
|                      | date; and the result=s analtye code.          |
|                      |                                               |
|                      | Concentration_msr = gross alpha               |
|                      | concentration - converted uranium             |
|                      | concentration, rounded to significant         |
|                      | figures.                                      |
|                      |                                               |
|                      | Round to the least number of significant      |
|                      | figures used in the calculation (excluding    |
|                      | the significant figures indicated by a result |
|                      | of zero). (Note, the SSWr1 design did include |
|                      | these rounding specifications but,            |
|                      | apparently, they were not implemented in      |
|                      | SSWr1.) (A.D-5.h)                             |
+----------------------+-----------------------------------------------+
| UOM_CODE             | Set to UOM_CODE of the gross alpha result.    |
+----------------------+-----------------------------------------------+
| D_LAST_UPDT_TS       | Current Date and Time                         |
+----------------------+-----------------------------------------------+
| D_USERID_CODE        | CDSSETUP                                      |
+----------------------+-----------------------------------------------+
| TMNMPRD_IS_NUMBER    | If both results reference the same Monitoring |
|                      | Period, then reference the same. Otherwise    |
|                      | set to null.                                  |
+----------------------+-----------------------------------------------+
| TMNMPRD_ST_CODE      |                                               |
+----------------------+-----------------------------------------------+
| TMNSASCH_IS_NUMBER   | Do not need to relate the new result to an    |
|                      | SSMPA because, if appropriate, this will be   |
|                      | done by a subsequent process.                 |
+----------------------+-----------------------------------------------+
| TMNSASCH_ST_CODE     |                                               |
+----------------------+-----------------------------------------------+
| TMNMPRD0IS_NUMBER    |                                               |
+----------------------+-----------------------------------------------+
| TMNPRPD0ST_CODE      |                                               |
+----------------------+-----------------------------------------------+