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       The protocol code.  For example, IRB,
                       IACUC, IBC, etc.  It must be valid in
                       the GMCODES file for type PC.

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

GMM-EXPIRE-DATE        Numeric 8  (yyyymmdd)                     AC110
Element: Expiration DatThis 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       Status as to whether approved or not.
                       Could be pendeing if waiting for certain
                       additional criteria to be met.  Must be
                       valid in the GMCODES file for type ST.

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

Gmcodes Pc     GMCODES      Required

                            "PC"                -> GMF-TYPE
                            GMM-PROT-CODE-PC    -> GMF-CODE

Gmcodes St     GMCODES      Required

                            "ST"                -> GMF-TYPE
                            GMM-STAT-CODE-ST    -> GMF-CODE