GMSALCAP – Grant Salary Cap Schedule
- System
- GM (GM)
- Prefix
GMC- Primary key
SCHEDULE,CURRENCY-CODE- Fields
- 4
- Updated by
- 0 programs
- Referenced by
- 0 programs
GMSALCAP is the Grant Salary Cap Schedule table in Lawson GM (prefix GMC). It is indexed by SCHEDULE, CURRENCY-CODE (GMCSET1). The table has 4 fields, 1 index and 0 documented relations.
About GMSALCAP
The salary cap schedule file stores salary caps required by various grant funding agencies. If an employee works on research funded by a grant subject to salary cap, and the employee's annual salary is greater than the cap, the grant recipient must cover the excess salary. Salary cap information is stored by salary cap schedule and currency in a header file (GMSALCAP) with effective dates and salary cap amounts stored in an associated detail file (GMSALCAPX). Salary cap schedules are assigned to posting activities and are used to adjust percentages in labor distribution templates. Salary cap schedules are also used by the Salary Cap Alert Report (GM412).
Fields (4)
Column = COBOL field name without the GMC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GMC-SCHEDULE PKSCHEDULE | Alpha 9 | Identifies salary cap schedule. | — |
GMC-CURRENCY-CODE PKCURRENCY_CODE | Alpha 5 | Determines currency for salary cap amounts in the salary cap schedule. | — |
GMC-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field stores the description of the salary cap schedule. | — |
GMC-RECORD-TYPERECORD_TYPE | Alpha 1 | Identifies the type of salary cap schedule. For example, Fedral identifies Executive Level 1 schedules that apply to federal grants and Private might apply to salary caps imposed by a pharmaceutical company that funds research. Valid values are:
| — |
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 |
|---|---|---|---|---|
GMCSET1 | SCHEDULE, CURRENCY-CODE | Primary | AC10.1, AC113, AC19.1, AC210, AC50.1, AC500, AC56.1, AC560 +1 more |
Programs
No Lawson programs are documented as updating or referencing this table.