Grant Salary Cap Schedule
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).
REFERENCED BY
AC10.1 | AC113 | AC19.1 | AC210 | AC50.1 | AC500 |
AC56.1 | AC560 | AC71.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | |
---|---|---|---|
GMC-SCHEDULE Element: Schedule | Alpha 9 Identifies salary cap schedule. |
|
|
GMC-CURRENCY-CODE Element: Currency Code | Alpha 5 Determines currency for salary cap amounts in the salary cap schedule. |
|
|
GMC-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field stores the description of the salary cap schedule. |
|
|
GMC-RECORD-TYPE Element: Record 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: F = Federal S = State N = Foundation P = Private O = Other D = Detail |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GMCSET1 |
SCHEDULE CURRENCY-CODE |
|
|
All trademarks and registered trademarks are the property of their
respective owners.