Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GMCOSTSHR


                             GMCOSTSHR FILE

The cost share file stores a list of cost share activities that relate to a
grant/project.  Cost sharing refers to resources contributed or allocated by
an institution to a sponsored project over and above what is funded by the
sponsor. There are three types of cost sharing; Mandatory, Committed and
Uncommitted.  Cost share information is maintained via GM01.2 (Cost Sharing).

Cost share or program income information can be established for any activity.
It's not required that a GMAWARD record exist for the activity.  The actual
cost share activity must be a posting level activity.

REFERENCED BY

AC113     AC19.1    AC50.1    AC500     AC56.1    AC560
AC71.1

UPDATED BY

AC10.1    AC120     AC300     AC310     BR122     BR140
BRIP.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GMO-ACTIVITY           Alpha 15                                  AC10.1  AC120
Element: Activity      Identifies the contract activity to
                       which cost share activities are mapped.


GMO-CS-ACTIVITY        Alpha 15
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


GMO-RECORD-TYPE        Alpha 1
Element: Record Type   Identifies the type of cost sharing;
                       mandatory or committed (voluntary) or
                       uncommitted (also voluntary).

                       M = Mandatory
                       C = Committed
                       U = Uncommitted

GMO-PRINT-EFRT-FL      Alpha 1
Element: Print Efrt Fl Determines whether cost share activity
                       is presented and tracked within GM
                       effort reporting.
                       N = No
                       Y = Yes

GMO-PRINT-SF269-FL     Alpha 1
Element: Print Sf269 FlDetermines whether cost share activity
                       is eligible for calculating recipient
                       share of outlays on SF269 report
                       (Financial Status Report, standard form
                       269A prescribed by OMB Circulars A-102
                       and A110); GM269.
                       N = No
                       Y = Yes

GMO-EFFORT-ACTVY       Alpha 15
Element: Activity      Identifies sponsored (Grant) activity
                       associated with the cost share activity;
                       must be posting activity and must be a
                       child of the contract activity.

                       Required if PRINT-EFFORT is set to Y.

GMO-PERCENT            Signed 7.4
Element: Cost Percent  If this is mandatory or committed cost
                       share, the percent committed can be
                       stored here for informational purposes
                       only.

GMO-PRINT-INV-FL       Alpha 1
Element: Print Inv Fl  N = No
                       Y = Yes

GMO-LAST-INV-NBR       Alpha 22                                  BR122   BR140
Element: Invoice       Used to identify the invoice.             BRIP.1

GMO-LAST-INV-DATE      Numeric 8  (yyyymmdd)                     BR122   BR140
Element: Date          This field displays the system date       BRIP.1
                       when this was created.

GMO-INV-CS-AMT         Signed 18.2                               BR122   BR140
Element: Intl Amt                                                BRIP.1

GMO-LTD-CS-AMT         Signed 18.2                               BR122   BR140
Element: Intl Amt                                                BRIP.1

GMO-CURRENCY-CODE      Alpha 5                                   BR140   BRIP.1
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

                         GMCOSTSHR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GMOSET1   ACTIVITY                                               AC10.1  AC120
          CS-ACTIVITY                                            AC300   AC310
                                                                 BR122   BR140
                                                                 BRIP.1

GMOSET2   PRINT-SF269-FLKeyChange
          ACTIVITY
          CS-ACTIVITY

GMOSET3   CS-ACTIVITY                                            AC10.1  AC113
          ACTIVITY                                               AC19.1  AC50.1
                                                                 AC500   AC56.1
                                                                 AC560   AC71.1

GMOSET4   PRINT-EFRT-FL KeyChange                                AC10.1  AC120
          EFFORT-ACTVY                                           BR140
          ACTIVITY
          CS-ACTIVITY

                         GMCOSTSHR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            GMO-ACTIVITY        -> ACV-ACTIVITY

Acactivity Cs  ACACTIVITY   Required

                            GMO-CS-ACTIVITY     -> ACV-ACTIVITY

Acactivity Eft ACACTIVITY   Not Required

                            GMO-EFFORT-ACTVY    -> ACV-ACTIVITY