Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GMSALCAP


                             GMSALCAP FILE

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           Alpha 9
Element: Schedule      Identifies salary cap schedule.

GMC-CURRENCY-CODE      Alpha 5
Element: Currency Code Determines currency for salary cap
                       amounts in the salary cap schedule.

GMC-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   This field stores the description of
                       the salary cap schedule.

GMC-RECORD-TYPE        Alpha 1
Element: Record Type   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

                         GMSALCAP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GMCSET1   SCHEDULE                                               AC10.1  AC113
          CURRENCY-CODE                                          AC19.1  AC210
                                                                 AC50.1  AC500
                                                                 AC56.1  AC560
                                                                 AC71.1