|
GMAWARD FILE
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
AC01.1 AC105 AC113 AC120 AC121 AC123
AC128 AC13.3 AC130 AC135 AC145 AC160
AC165 AC169 AC190 AC191 AC197 AC198
AC200 AC203 AC206 AC207 AC210 AC213
AC218 AC220 AC225 AC240 AC246 AC261
AC265 AC290 AC295 AC298 AC30.3 AC32.1
AC34.1 AC346 AC35.1 AC36.1 AC400 AC401
AC410 AC412 AC420 AC421 AC440 AC460
AC471 AC472 AC473 AC480 AC490 AC493
AC494 AC527 AC55.1 AC580 AC583 AC90.1
AC92.1 AC93.1 AC94.1 AC95.1 ACBA.1 ACDL.1
ACDM.2 ACDM.9 ACVW.1 SE90.1 AP211 AR21.2
AR237 AR239 AR250 AR257 AR27.2 AR29.1
AR296 AR30.5 AR32.1 AR33.2 AR38.5 AR39.3
AR39.4 AR42.1 AR42.2 AR42.7 AR43.1 AR502
AR503 AR55.1 AR560 AR575 AR800 AR91.1
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 BR254 BR265 BR300 BR400 BR405
BR422 BR430 BR450 BR521 BR530 BR580
MX123 MX500 SN02.1 SNAC.1
UPDATED BY
AC10.1 AC110 AC112 AC300 AC310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMG-ACTIVITY Alpha 15 AC10.1 AC110
Element: Activity Grant/Project Activity. Must exist in
the ACACTIVITY file.
GMG-INSTITUTION Numeric 4 AC110
Element: Institution Institution ID. Code identifying the
institution receiving the award.
GMG-INST-LOCALE Alpha 15 AC110
Element: Inst Locale Institution location. Code identifying
the institution's location that received
the award.
GMG-DIV-CODE-DI Alpha 15 AC110
Element: Gm Code
GMG-DEPT-CODE-DP Alpha 15 AC110
Element: Gm Code
GMG-DIR-SPONS-CO Numeric 4 AC110
Element: Company 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 Alpha 9 (Right Justified) AC110
Element: Customer This field contains the number that
represents a customer.
GMG-DIR-SPONS-NBR Alpha 30 AC110
Element: Dir Spons Nbr The direct sponsor's award number.
GMG-PROJ-CODE-PJ Alpha 15 AC110
Element: Gm Code
GMG-AWARD-CODE-AW Alpha 15 AC110
Element: Gm Code
GMG-BUSLIN-CODE-BU Alpha 15 AC110
Element: Gm Code
GMG-PRIME-SPONS-SP Alpha 15 AC110
Element: Gm Code
GMG-PRIME-SPONS-CO Numeric 4 AC110
Element: Prime Spons CoAR company associated with the prime
sponsor.
GMG-PRIME-SPONSOR Alpha 9 (Right Justified) AC110
Element: Prime Sponsor 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 Alpha 30 AC110
Element: Sponsor Awd NoThe sponsor's award number.
GMG-CFDA-NUMBER Alpha 30 AC110
Element: Cfda Number 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 Alpha 1 AC110
Element: Mta Flag 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 Numeric 8 (yyyymmdd) AC110
Element: Proposal Date Date the award proposal is submitted.
GMG-NOTICE-DATE Numeric 8 (yyyymmdd) AC110
Element: Notice Date Date the Notice of Grant Award (NOGA) is
received.
GMG-RECEIVE-DATE Numeric 8 (yyyymmdd) AC110
Element: Receive Date Date the Award is received.
GMG-EST-CLOSE-DATE Numeric 8 (yyyymmdd) AC110
Element: Est Close DateThe estimated or expected close date for
the grant.
GMG-ACT-CLOSE-DATE Numeric 8 (yyyymmdd) AC10.1 AC110
Element: Act Close DateThe actual close date for the grant. AC112
GMG-MAINT-DATE Numeric 8 (yyyymmdd) AC110
Element: Maint Date The date stamp from when the record is
added. It is not updated when a change
is made.
GMG-MAINT-TIME Numeric 6 (hhmmss) AC110
Element: Sys Time The time stamp from when the record was
added. It is not updated when a change
is made.
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
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
...
GMAWARD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|