Apr 22 1998

                                        "quality_control" Virtual DB Description Report

                                              quality_control.criteria_subjects_conn Table

                          This table connects a magnet subject or series with a criteria set at a
                          particular point in time.

    column_name               units       datatype        null  pri  alt  description
                                                                key  key
    ------------------------- ---------   --------------- ----  ---  ---  ---------------------------------------------------------
 1  qc_criteria_set_sn                    sntype            0     1    0  pointer to the qc criteria set for this magnet or magnet
                                                                          series

 2  subject_or_series_sn                  sntype            0     1    0  pointer to the subject or series for this qc criteria set

 3  responsible_person_sn                 sntype            0     0    0  pointer to the person who connected this magnet/series
                                                                          with this qc criteria set

 4  entry_dt                              datetime          0     1    0  date/time of this entry

        Foreign Keys from criteria_subjects_conn                                PRIMARY KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      primary_dataowner_name        primary_table_name          primary_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------
           qc_criteria_set_sn               quality_control               qc_criteria_sets            qc_criteria_set_sn
           responsible_person_sn            admin                         serials                     serial

        Foreign Keys to criteria_subjects_conn                                  FOREIGN KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      foreign_dataowner_name        foreign_table_name          foreign_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------

Page 1

Apr 22 1998

                                              quality_control.qc_conditions_ascii Table

                          All conditions the ascii condition varible from the data set must meet before
                          the actual test will be performed

    column_name               units       datatype        null  pri  alt  description
                                                                key  key
    ------------------------- ---------   --------------- ----  ---  ---  ---------------------------------------------------------
 1  qc_criterion_sn                       sntype            0     1    0  pointer to criterion for which this condition applies

 2  condition_variable                    descstr           0     1    0  a

 3  type_of_condition_test                namestr           0     0    0  b

 4  condition_value                       namestr           0     0    0  c

        Foreign Keys from qc_conditions_ascii                                   PRIMARY KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      primary_dataowner_name        primary_table_name          primary_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------
           qc_criterion_sn                  quality_control               qc_criteria                 qc_criterion_sn

        Foreign Keys to qc_conditions_ascii                                     FOREIGN KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      foreign_dataowner_name        foreign_table_name          foreign_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------

Page 2

Apr 22 1998

                                              quality_control.qc_conditions_float Table

                          All conditions the float condition varible from the data set must meet before
                          the actual test will be performed

    column_name               units       datatype        null  pri  alt  description
                                                                key  key
    ------------------------- ---------   --------------- ----  ---  ---  ---------------------------------------------------------
 1  qc_criterion_sn                       sntype            0     1    0  pointer to the criterion for which this condition should
                                                                          be applied

 2  condition_variable                    descstr           0     1    0  a

 3  type_of_condition_test                namestr           0     0    0  b

 4  condition_value_1                     float             0     0    0  c

 5  condition_value_2                     float             1     0    0  d

        Foreign Keys from qc_conditions_float                                   PRIMARY KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      primary_dataowner_name        primary_table_name          primary_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------
           qc_criterion_sn                  quality_control               qc_criteria                 qc_criterion_sn

        Foreign Keys to qc_conditions_float                                     FOREIGN KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      foreign_dataowner_name        foreign_table_name          foreign_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------

Page 3

Apr 22 1998

                                              quality_control.qc_criteria Table

                          Information on a single qc test to be performed, including the limit this set
                          represents, what variables the test is performed on, and documentation on this
                          test.

    column_name               units       datatype        null  pri  alt  description
                                                                key  key
    ------------------------- ---------   --------------- ----  ---  ---  ---------------------------------------------------------
 1  qc_criterion_sn                       sntype            1     1    0  unique sn for this entry

 2  criterion_label                       namestr           0     0    1  a

 3  subject_type                          aliasstr          0     0    1  b

 4  severity                              namestr           0     0    1  c

 5  dependent_variable                    descstr           0     0    0  d

 6  independent_variable                  descstr           0     0    0  e

 7  type_of_value_test                    namestr           0     0    0  f

 8  description                           descstr           0     0    0  g

 9  document_sn                           sntype            1     0    0  pointer to the document ...

10  responsible_person_sn                 sntype            0     0    0  pointer to the person responsible for ...

11  entry_dt                              datetimestamp     0     0    1  date/time of this entry

        Foreign Keys from qc_criteria                                           PRIMARY KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      primary_dataowner_name        primary_table_name          primary_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------
           qc_criterion_sn                  admin                         serials                     serial
           document_sn                      admin                         documents                   document_sn
           responsible_person_sn            admin                         personnel                   personnel_sn

        Foreign Keys to qc_criteria                                             FOREIGN KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      foreign_dataowner_name        foreign_table_name          foreign_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------
           qc_criterion_sn                  quality_control               qc_conditions_ascii         qc_criterion_sn
           qc_criterion_sn                  quality_control               qc_conditions_float         qc_criterion_sn
           qc_criterion_sn                  quality_control               qc_criteria_set_parts       qc_criterion_sn
           qc_criterion_sn                  quality_control               qc_test_values              qc_criterion_sn

Page 4

Apr 22 1998

                                              quality_control.qc_criteria_set_parts Table

                          The detail table that links a single quality criteria into a criteria set

    column_name               units       datatype        null  pri  alt  description
                                                                key  key
    ------------------------- ---------   --------------- ----  ---  ---  ---------------------------------------------------------
 1  qc_criteria_set_sn                    sntype            0     1    0  pointer to the set the below criterion belongs to

 2  qc_criterion_sn                       sntype            0     1    0  pointer to the criterion for the above set

        Foreign Keys from qc_criteria_set_parts                                 PRIMARY KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      primary_dataowner_name        primary_table_name          primary_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------
           qc_criteria_set_sn               quality_control               qc_criteria_sets            qc_criteria_set_sn
           qc_criterion_sn                  quality_control               qc_criteria                 qc_criterion_sn

        Foreign Keys to qc_criteria_set_parts                                   FOREIGN KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      foreign_dataowner_name        foreign_table_name          foreign_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------

Page 5

Apr 22 1998

                                              quality_control.qc_criteria_sets Table

                          Master table for a collection of criteria that should all be applied to
                          magnets/series data that have been analyzed with the same algorithm

    column_name               units       datatype        null  pri  alt  description
                                                                key  key
    ------------------------- ---------   --------------- ----  ---  ---  ---------------------------------------------------------
 1  qc_criteria_set_sn                    sntype            1     1    0  the unique serial for this entry

 2  analysis_algorithm                    namestr           0     0    1  name of the analysis algorithm for which the data in this
                                                                          criteria set will apply

 3  document_sn                           sntype            1     0    0  pointer to the document that describes how this criteris
                                                                          set was devised

 4  responsible_person_sn                 sntype            0     0    0  pointer to the person responsible for compiling this
                                                                          criteria set

 5  entry_dt                              datetimestamp     0     0    1  date/time this entry was made

        Foreign Keys from qc_criteria_sets                                      PRIMARY KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      primary_dataowner_name        primary_table_name          primary_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------
           qc_criteria_set_sn               admin                         serials                     serial
           document_sn                      admin                         documents                   document_sn
           responsible_person_sn            admin                         personnel                   personnel_sn

        Foreign Keys to qc_criteria_sets                                        FOREIGN KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      foreign_dataowner_name        foreign_table_name          foreign_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------
           qc_criteria_set_sn               quality_control               criteria_subjects_conn      qc_criteria_set_sn
           qc_criteria_set_sn               quality_control               qc_criteria_set_parts       qc_criteria_set_sn

Page 6

Apr 22 1998

                                              quality_control.qc_test_values Table

                          The values with which to test one criterion's independant variable.

    column_name               units       datatype        null  pri  alt  description
                                                                key  key
    ------------------------- ---------   --------------- ----  ---  ---  ---------------------------------------------------------
 1  qc_criterion_sn                       sntype            0     1    0  pointer to the criterion for which these test values will
                                                                          be applied

 2  independent_value                     float             0     1    0  a

 3  test_value_1                          float             0     0    0  b

 4  test_value_2                          float             1     0    0  c

 5  test_value_3                          float             1     0    0  d

        Foreign Keys from qc_test_values                                        PRIMARY KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      primary_dataowner_name        primary_table_name          primary_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------
           qc_criterion_sn                  quality_control               qc_criteria                 qc_criterion_sn

        Foreign Keys to qc_test_values                                          FOREIGN KEY
                                            - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
           column_name                      foreign_dataowner_name        foreign_table_name          foreign_column_name
           -------------------------        ---------------------------   -------------------------   -------------------------

Page 7

Apr 22 1998

                            Rules for Datatypes in the "quality_control" Database

       rule name                                rule text
       ------------------------------           ----------------------------------------

                            Defaults for Datatypes in the "quality_control" Database

       default name                             default text
       ------------------------------           ----------------------------------------
       datetimestamp_default                    create default datetimestamp_default as getdate()

       Tables.Columns with this Datatype Default:
                                                qc_criteria.entry_dt
                                                qc_criteria_sets.entry_dt

                                      End of "quality_control" Report

Page 8

<BR>
<HR>
<A HREF="http://www.fnal.gov/pub/disclaim.html">Legal Notices</A>