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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GMGSET1ACTIVITYPrimaryAC01.1, AC10.1, AC105, AC110, AC112, AC113, AC120, AC121 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

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

One to many (3) — child tables

RelationTableRulesConditionField map
GmdelivGMDELIVGMG-ACTIVITY → GLV-ACTIVITY, → GLV-DELIV-CODE-DE
GmprotocolGMPROTOCOLGMG-ACTIVITY → GMM-ACTIVITY, → GMM-PROT-CODE-PC, → GMM-PROTOCOL-NBR, → GMM-EXPIRE-DATE
GmtranefrtGMTRANEFRTGMG-ACTIVITY → GEF-ACTIVITY, → GEF-ACCT-CATEGORY, → GEF-OBJ-ID

Programs

Updated by (4)

Referenced by (126)