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.

REFERENCED BY
AC200 AC210 ACVW.1 AP211 GL299 MX123
MX500 SN02.1 SNAC.1


UPDATED BY
AC10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMG-ACTIVITY
Element: Activity
Alpha 15
Grant/Project Activity. Must exist in the ACACTIVITY file.
AC10.1
GMG-INSTITUTION
Element: Institution
Numeric 4
Institution ID. Code identifying the institution receiving the award.
GMG-INST-LOCALE
Element: Inst Locale
Alpha 15
Institution location. Code identifying the institution's location that received the award.
GMG-DIV-CODE-DI
Element: Gm Code
Alpha 15
GMG-DEPT-CODE-DP
Element: Gm Code
Alpha 15
GMG-DIR-SPONS-CO
Element: Company
Numeric 4
Identifies 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.
GMG-DIR-SPONSOR
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
GMG-DIR-SPONS-NBR
Element: Dir Spons Nbr
Alpha 30
The direct sponsor's award number.
GMG-PROJ-CODE-PJ
Element: Gm Code
Alpha 15
GMG-AWARD-CODE-AW
Element: Gm Code
Alpha 15
GMG-BUSLIN-CODE-BU
Element: Gm Code
Alpha 15
GMG-PRIME-SPONS-SP
Element: Gm Code
Alpha 15
GMG-PRIME-SPONS-CO
Element: Prime Spons Co
Numeric 4
AR company associated with the prime sponsor.
GMG-PRIME-SPONSOR
Element: 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.
GMG-SPONSOR-AWD-NO
Element: Sponsor Awd No
Alpha 30
The sponsor's award number.
GMG-CFDA-NUMBER
Element: Cfda Number
Alpha 30
The 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.
GMG-MTA-FLAG
Element: Mta Flag
Alpha 1
Material 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
GMG-PROPOSAL-DATE
Element: Proposal Date
Numeric 8 (yyyymmdd)
Date the award proposal is submitted.
GMG-NOTICE-DATE
Element: Notice Date
Numeric 8 (yyyymmdd)
Date the Notice of Grant Award (NOGA) is received.
GMG-RECEIVE-DATE
Element: Receive Date
Numeric 8 (yyyymmdd)
Date the Award is received.
GMG-EST-CLOSE-DATE
Element: Est Close Date
Numeric 8 (yyyymmdd)
The estimated or expected close date for the grant.
GMG-ACT-CLOSE-DATE
Element: Act Close Date
Numeric 8 (yyyymmdd)
The actual close date for the grant.
AC10.1
GMG-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date stamp from when the record is added. It is not updated when a change is made.
GMG-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
The time stamp from when the record was added. It is not updated when a change is made.
GMG-SOFA-REPORT-FL
Element: Flag Num
Numeric 1

0 = Do not include
1 = Include
GMG-MAJOR-CATEGORY
Element: Gm Code
Alpha 15


GMAWARD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMGSET1 ACTIVITY
AC10.1 AC200
AC210 ACVW.1
AP211 GL299
MX123 MX500
SN02.1 SNAC.1


GMAWARD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
GMG-ACTIVITY->ACV-ACTIVITY
Arcomp Ds ARCOMP Not Required
GMG-DIR-SPONS-CO->ACO-COMPANY
Arcomp Ps ARCOMP Not Required
GMG-PRIME-SPONS-CO->ACO-COMPANY
Arcustomer Ds ARCUSTOMER Not Required
GMG-DIR-SPONS-CO->ACM-COMPANY
GMG-DIR-SPONSOR->ACM-CUSTOMER
Arcustomer Ps ARCUSTOMER Not Required
GMG-PRIME-SPONS-CO->ACM-COMPANY
GMG-PRIME-SPONSOR->ACM-CUSTOMER


GMAWARD FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Gmdeliv GMDELIV
GMG-ACTIVITY->GLV-ACTIVITY
  GLV-DELIV-CODE-DE
Gmprotocol GMPROTOCOL
GMG-ACTIVITY->GMM-ACTIVITY
  GMM-PROT-CODE-PC
  GMM-PROTOCOL-NBR
  GMM-EXPIRE-DATE
Gmtranefrt GMTRANEFRT
GMG-ACTIVITY->GEF-ACTIVITY
  GEF-ACCT-CATEGORY
  GEF-OBJ-ID


File created: Wed Jun 08 20:49:00 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.