Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GMPROTOCOL


                            GMPROTOCOL FILE

The Protocol file stores information about different committees that are
involved with monitoring research and clinical testing for institutions to
ensure proper and human treatment of participating subjects.  Examples of
these committees include:  IRB (Institutional Review Board), IACUC
(Institutional Animal Care and Use Committee) and IBC (Institutation
Bio-Safety  Committee).  This file is maintained via GM03.3 (Award Protocols).

UPDATED BY

AC110     AC300     AC310     AC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GMM-ACTIVITY           Alpha 15                                  AC110
Element: Activity      Grant or project activity.  Must exist
                       in the ACACTIVITY file.


GMM-PROT-CODE-PC       Alpha 15                                  AC110
Element: Gm Code

GMM-PROTOCOL-NBR       Alpha 22                                  AC110
Element: Protocol Nbr  The protocol or form number.

GMM-EXPIRE-DATE        Numeric 8  (yyyymmdd)                     AC110
Element: Expire Date   This field contains the expiration date
                       for this protocol number.

GMM-DATE               Numeric 8  (yyyymmdd)                     AC110
Element: Date          Date issued.

GMM-STAT-CODE-ST       Alpha 15                                  AC110
Element: Gm Code

GMM-APPROVER           Alpha 30                                  AC110
Element: Approver      Person or group who approved.

                         GMPROTOCOL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GMMSET1   ACTIVITY                                               AC10.1  AC110
          PROT-CODE-PC                                           AC300   AC310
          PROTOCOL-NBR
          EXPIRE-DATE

                         GMPROTOCOL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            GMM-ACTIVITY        -> ACV-ACTIVITY