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
AC113 AC120 AC121 AC123 AC128 AC130
AC135 AC145 AC147 AC160 AC165 AC169
AC190 AC191 AC196 AC197 AC198 AC200
AC203 AC206 AC207 AC210 AC213 AC218
AC220 AC225 AC240 AC246 AC247 AC256
AC261 AC265 AC290 AC295 AC297 AC298
AC30.3 AC310 AC311 AC32.1 AC346 AC400
AC401 AC410 AC412 AC420 AC421 AC440
AC460 AC471 AC472 AC473 AC480 AC490
AC493 AC494 AC527 AC580 AC583 AC90.1
AC92.1 AC93.1 AC94.1 AC95.1 AC97.1 SE90.1
AP211 ARLL.1 BR120 BR121 BR130 BR131
BR140 BR142 BR145 BR151 BR152 BR153
BR154 BR155 BR156 BR157 BR165 BR19.2
BR190 BR20.9 BR200 BR202 BR204 BR205
BR210 BR212 BR215 BR220 BR245 BR251
BR252 BR253 BR265 BR300 BR400 BR405
BR422 BR430 BR450 BR521 BR530 BR580
GL299 MX123 MX500 AC01.1 AC105 AC13.3
AC34.1 AC35.1 AC36.1 AC55.1 ACBA.1 ACDL.1
ACDM.2 ACDM.9 ACVW.1 BR254 SN02.1 SNAC.1


UPDATED BY
AC10.1 AC110 AC112 AC300

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMG-ACTIVITY
Element: Activity
Alpha 15
Grant/Project Activity. Must exist in the ACACTIVITY file.
AC10.1 AC110
GMG-INSTITUTION
Element: Institution
Numeric 4
Institution ID. Code identifying the institution receiving the award.
AC110
GMG-INST-LOCALE
Element: Inst Locale
Alpha 15
Institution location. Code identifying the institution's location that received the award.
AC110
GMG-DIV-CODE-DI
Element: Gm Code
Alpha 15
AC110
GMG-DEPT-CODE-DP
Element: Gm Code
Alpha 15
AC110
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.
AC110
GMG-DIR-SPONSOR
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
AC110
GMG-DIR-SPONS-NBR
Element: Dir Spons Nbr
Alpha 30
The direct sponsor's award number.
AC110
GMG-PROJ-CODE-PJ
Element: Gm Code
Alpha 15
AC110
GMG-AWARD-CODE-AW
Element: Gm Code
Alpha 15
AC110
GMG-BUSLIN-CODE-BU
Element: Gm Code
Alpha 15
AC110
GMG-PRIME-SPONS-SP
Element: Gm Code
Alpha 15
AC110
GMG-PRIME-SPONS-CO
Element: Prime Spons Co
Numeric 4
AR company associated with the prime sponsor.
AC110
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.
AC110
GMG-SPONSOR-AWD-NO
Element: Sponsor Awd No
Alpha 30
The sponsor's award number.
AC110
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.
AC110
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
AC110
GMG-PROPOSAL-DATE
Element: Proposal Date
Numeric 8 (yyyymmdd)
Date the award proposal is submitted.
AC110
GMG-NOTICE-DATE
Element: Notice Date
Numeric 8 (yyyymmdd)
Date the Notice of Grant Award (NOGA) is received.
AC110
GMG-RECEIVE-DATE
Element: Receive Date
Numeric 8 (yyyymmdd)
Date the Award is received.
AC110
GMG-EST-CLOSE-DATE
Element: Est Close Date
Numeric 8 (yyyymmdd)
The estimated or expected close date for the grant.
AC110
GMG-ACT-CLOSE-DATE
Element: Act Close Date
Numeric 8 (yyyymmdd)
The actual close date for the grant.
AC10.1 AC110
AC112
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.
AC110
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.
AC110
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
...
AC01.1 AC10.1
AC105 AC110
AC112 AC113
AC120 AC121
AC123 AC128
AC13.3 AC130
AC135 AC145
AC147 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218


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: Thu Jun 09 11:14:22 2016

Home
Contact Us



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