GMPROTOCOL – Grant Management Protocol
- System
- GM (GM)
- Prefix
GMM- Primary key
ACTIVITY,PROT-CODE-PC,PROTOCOL-NBR,EXPIRE-DATE- Fields
- 7
- Updated by
- 3 programs
- Referenced by
- 0 programs
GMPROTOCOL is the Grant Management Protocol table in Lawson GM (prefix GMM). It is indexed by ACTIVITY, PROT-CODE-PC, PROTOCOL-NBR, EXPIRE-DATE (GMMSET1). It is related 1:1 to ACACTIVITY. It is updated by AC10.1, AC110 and AC300. The table has 7 fields, 1 index and 1 documented relation.
About GMPROTOCOL
No description in the Lawson data dictionary.
Fields (7)
Column = COBOL field name without the GMM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GMM-ACTIVITY PKACTIVITY | Alpha 15 | Grant or project activity. Must exist in the ACACTIVITY file. | AC110 |
GMM-PROT-CODE-PC PKPROT_CODE_PC | Alpha 15 | — | AC110 |
GMM-PROTOCOL-NBR PKPROTOCOL_NBR | Alpha 22 | The protocol or form number. | AC110 |
GMM-EXPIRE-DATE PKEXPIRE_DATE | Numeric 8 (yyyymmdd) | This field contains the expiration date for this protocol number. | AC110 |
GMM-DATEDATE | Numeric 8 (yyyymmdd) | Date issued. | AC110 |
GMM-STAT-CODE-STSTAT_CODE_ST | Alpha 15 | — | AC110 |
GMM-APPROVERAPPROVER | Alpha 30 | Person or group who approved. | AC110 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GMMSET1 | ACTIVITY, PROT-CODE-PC, PROTOCOL-NBR, EXPIRE-DATE | Primary | AC10.1, AC110, AC300 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acactivity | ACACTIVITY | Required | GMM-ACTIVITY → ACV-ACTIVITY |