GMAWARD – Grant Management Award

System
GM (GM)
Prefix
GMG
Primary key
ACTIVITY
Fields
27
Updated by
4 programs
Referenced by
126 programs

GMAWARD is the Grant Management Award table in Lawson GM (prefix GMG). It is indexed by ACTIVITY (GMGSET1). It is related 1:1 to ACACTIVITY, ARCOMP and ARCUSTOMER and 1:M to GMDELIV, GMPROTOCOL and GMTRANEFRT. It is updated by AC10.1, AC110, AC112 and AC300 and referenced by AC01.1, AC105, AC113, AC120, AC121, AC123, AC128, AC13.3 and 118 more. The table has 27 fields, 1 index and 8 documented relations.

About GMAWARD

The Award file contains general information about the Grant/Award. The data stored here is for informational purposes. Award information can be stored for any level of activity. Award information is maintained via GM01.1 (Award) and listed via GM201 (Award Listing). When looking for award type information, programs will incorporate logic to climb an activity's hierarchy until a record is found. This is similar to existing functionality used for Resource Assignment and Rates, Billing Structures, and Period of Performance dates.

Fields (27)

Column = COBOL field name without the GMG- 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
#GMG-ACTIVITY PK
ACTIVITY		Alpha 15Grant/Project Activity. Must exist in the ACACTIVITY file.AC110
#GMG-INSTITUTION
INSTITUTION		Numeric 4Institution ID. Code identifying the institution receiving the award.AC110
#GMG-INST-LOCALE
INST_LOCALE		Alpha 15Institution location. Code identifying the institution's location that received the award.AC110
#GMG-DIV-CODE-DI
DIV_CODE_DI		Alpha 15—AC110
#GMG-DEPT-CODE-DP
DEPT_CODE_DP		Alpha 15—AC110
#GMG-DIR-SPONS-CO
DIR_SPONS_CO		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AC110
#GMG-DIR-SPONSOR
DIR_SPONSOR		Alpha 9 (Right Justified)This field contains the number that represents a customer.AC110
#GMG-DIR-SPONS-NBR
DIR_SPONS_NBR		Alpha 30The direct sponsor's award number.AC110
#GMG-PROJ-CODE-PJ
PROJ_CODE_PJ		Alpha 15—AC110
#GMG-AWARD-CODE-AW
AWARD_CODE_AW		Alpha 15—AC110
#GMG-BUSLIN-CODE-BU
BUSLIN_CODE_BU		Alpha 15—AC110
#GMG-PRIME-SPONS-SP
PRIME_SPONS_SP		Alpha 15—AC110
#GMG-PRIME-SPONS-CO
PRIME_SPONS_CO		Numeric 4AR company associated with the prime sponsor.AC110
#GMG-PRIME-SPONSOR
PRIME_SPONSOR		Alpha 9 (Right Justified)AR Customer ID of the Prime Sponsor. This could be different than the Billing sponsor, which is attached to the contract.AC110
#GMG-SPONSOR-AWD-NO
SPONSOR_AWD_NO		Alpha 30The sponsor's award number.AC110
#GMG-CFDA-NUMBER
CFDA_NUMBER		Alpha 30The catalog of federal domestic assistance number. This catalog (CFDA) is a government-wide compilation of Federal programs, projects, services, and activities, which provides assistance or benefits to the American public.AC110
#GMG-MTA-FLAG
MTA_FLAG		Alpha 1Material Transfer Agreement flag. The MTA document defines the terms and conditions for transgerring proprietary material or information about a particular project either to or from the FDA.
  • Y Yes
  • N No
AC110
#GMG-PROPOSAL-DATE
PROPOSAL_DATE		Numeric 8 (yyyymmdd)Date the award proposal is submitted.AC110
#GMG-NOTICE-DATE
NOTICE_DATE		Numeric 8 (yyyymmdd)Date the Notice of Grant Award (NOGA) is received.AC110
#GMG-RECEIVE-DATE
RECEIVE_DATE		Numeric 8 (yyyymmdd)Date the Award is received.AC110
#GMG-EST-CLOSE-DATE
EST_CLOSE_DATE		Numeric 8 (yyyymmdd)The estimated or expected close date for the grant.AC110
#GMG-ACT-CLOSE-DATE
ACT_CLOSE_DATE		Numeric 8 (yyyymmdd)The actual close date for the grant.AC10.1, AC110, AC112
#GMG-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date stamp from when the record is added. It is not updated when a change is made.AC110
#GMG-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)The time stamp from when the record was added. It is not updated when a change is made.AC110
#GMG-SOFA-REPORT-FL
SOFA_REPORT_FL		Numeric 1—
  • 0 Do not include
  • 1 Include
—
#GMG-MAJOR-CATEGORY
MAJOR_CATEGORY		Alpha 15——
#GMG-PROGRAM-TITLE
PROGRAM_TITLE		Alpha 60 (Lower Case)——

Indexes (1)

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
GMGSET1
  1. ACTIVITY
PrimaryAC01.1, AC10.1, AC105, AC110, AC112, AC113, AC120, AC121 +22 more (list truncated in source)

Relations

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

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AcactivityACACTIVITYRequired
GMG-ACTIVITY→ACV-ACTIVITY
Arcomp DsARCOMPNot Required
GMG-DIR-SPONS-CO→ACO-COMPANY
Arcomp PsARCOMPNot Required
GMG-PRIME-SPONS-CO→ACO-COMPANY
Arcustomer DsARCUSTOMERNot Required
GMG-DIR-SPONS-CO→ACM-COMPANY
GMG-DIR-SPONSOR→ACM-CUSTOMER
Arcustomer PsARCUSTOMERNot Required
GMG-PRIME-SPONS-CO→ACM-COMPANY
GMG-PRIME-SPONSOR→ACM-CUSTOMER

One to many (3) — child tables

RelationTableRulesConditionField map
GmdelivGMDELIV
GMG-ACTIVITY→GLV-ACTIVITY
—→GLV-DELIV-CODE-DE
GmprotocolGMPROTOCOL
GMG-ACTIVITY→GMM-ACTIVITY
—→GMM-PROT-CODE-PC
—→GMM-PROTOCOL-NBR
—→GMM-EXPIRE-DATE
GmtranefrtGMTRANEFRT
GMG-ACTIVITY→GEF-ACTIVITY
—→GEF-ACCT-CATEGORY
—→GEF-OBJ-ID

Programs

Updated by (4)

Referenced by (126)