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.

UPDATED BY

AC300     AC310     BR122     BR140     BRIP.1    AC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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


GMO-CS-ACTIVITY        Alpha 15
Element: 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

GMO-LAST-INV-NBR       Alpha 22                                  BR122   BR140
Element: Invoice Number                                          BRIP.1

GMO-LAST-INV-DATE      Numeric 8  (yyyymmdd)                     BR122   BR140
Element: Date                                                    BRIP.1

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                                   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  AC300
          CS-ACTIVITY                                            AC310   BR122
                                                                 BR140   BRIP.1

GMOSET2   PRINT-SF269-FLKeyChange
          ACTIVITY
          CS-ACTIVITY

GMOSET3   CS-ACTIVITY                                            AC10.1
          ACTIVITY

GMOSET4   PRINT-EFRT-FL KeyChange                                AC10.1
          EFFORT-ACTVY
          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