GMCOSTSHR – Grant Management Cost Share

System
GM (GM)
Prefix
GMO
Primary key
ACTIVITY, CS-ACTIVITY
Fields
13
Updated by
12 programs
Referenced by
1 program

GMCOSTSHR is the Grant Management Cost Share table in Lawson GM (prefix GMO). It is indexed by ACTIVITY, CS-ACTIVITY (GMOSET1); alternate indexes: GMOSET2, GMOSET3 and GMOSET4. It is related 1:1 to ACACTIVITY. It is updated by AC10.1, AC120, AC19.1, AC300, AC50.1, AC500, AC56.1, AC560 and 4 more and referenced by AC113. The table has 13 fields, 4 indexes and 3 documented relations.

About GMCOSTSHR

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.

Fields (13)

Column = COBOL field name without the GMO- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#GMO-ACTIVITY PK
ACTIVITY		Alpha 15Identifies the contract activity to which cost share activities are mapped.AC10.1, AC120
#GMO-CS-ACTIVITY PK
CS_ACTIVITY		Alpha 15Activities 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
RECORD_TYPE		Alpha 1Identifies the type of cost sharing; mandatory or committed (voluntary) or uncommitted (also voluntary).
  • M Mandatory
  • C Committed
  • U Uncommitted
—
#GMO-PRINT-EFRT-FL SET4
PRINT_EFRT_FL		Alpha 1Determines whether cost share activity is presented and tracked within GM effort reporting.
  • N No
  • Y Yes
—
#GMO-PRINT-SF269-FL SET2
PRINT_SF269_FL		Alpha 1Determines 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 SET4
EFFORT_ACTVY		Alpha 15Identifies 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
PERCENT		Signed 7.4If this is mandatory or committed cost share, the percent committed can be stored here for informational purposes only.—
#GMO-PRINT-INV-FL
PRINT_INV_FL		Alpha 1—
  • N No
  • Y Yes
—
#GMO-LAST-INV-NBR
LAST_INV_NBR		Alpha 22Used to identify the invoice.BR122, BR140, BRIP.1
#GMO-LAST-INV-DATE
LAST_INV_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.BR122, BR140, BRIP.1
#GMO-INV-CS-AMT
INV_CS_AMT		Signed 18.2—BR122, BR140, BRIP.1
#GMO-LTD-CS-AMT
LTD_CS_AMT		Signed 18.2—BR122, BR140, BRIP.1
#GMO-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BR140, BRIP.1

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GMOSET1
  1. ACTIVITY
  2. CS-ACTIVITY
PrimaryAC10.1, AC120, AC300, BR122, BR140, BRIP.1
GMOSET2
  1. PRINT-SF269-FL
  2. ACTIVITY
  3. CS-ACTIVITY
KeyChange—
GMOSET3
  1. CS-ACTIVITY
  2. ACTIVITY
AC10.1, AC113, AC19.1, AC50.1, AC500, AC56.1, AC560, AC71.1
GMOSET4
  1. PRINT-EFRT-FL
  2. EFFORT-ACTVY
  3. ACTIVITY
  4. CS-ACTIVITY
KeyChangeAC10.1, AC120, BR140

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACACTIVITYGMCOSTSHR

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequired
GMO-ACTIVITY→ACV-ACTIVITY
Acactivity CsACACTIVITYRequired
GMO-CS-ACTIVITY→ACV-ACTIVITY
Acactivity EftACACTIVITYNot Required
GMO-EFFORT-ACTVY→ACV-ACTIVITY

Programs

Updated by (12)

Referenced by (1)