|
|
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
AC13.3 AC130 AC135 AC145 AC160 AC165
AC190 AC191 AC197 AC198 AC200 AC203
AC206 AC207 AC210 AC213 AC218 AC220
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 AC55.1 AC580
AC583 AC90.1 AC92.1 AC93.1 AC94.1 AC95.1
ACBA.1 ACDL.1 ACDM.2 ACVW.1 SE90.1 AP211
AR250 AR30.5 AR33.2 BR120 BR121 BR130
BR131 BR140 BR142 BR145 BR165 BR19.2
BR190 BR20.9 BR200 BR202 BR204 BR205
BR210 BR212 BR215 BR220 BR245 BR265
BR300 BR400 BR405 BR430 BR450 BR521
BR530 BR580 BRCC.1 MX123 MX500
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 Code for the division. This is user
defined and must be valid in the GMCODES
file for DI.
GMG-DEPT-CODE-DP Alpha 15 AC110
Element: Gm Code Code for the department. This is user
defined and must be valid in the GMCODES
file for type DP.
GMG-DIR-SPONS-CO Numeric 4 AC110
Element: Company
GMG-DIR-SPONSOR Alpha 9 (Right Justified) AC110
Element: Customer Number
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 Code for the type of project/activity.
This must be valid in the GMCODES file
for type PJ.
GMG-AWARD-CODE-AW Alpha 15 AC110
Element: Gm Code Code idenfifying the type of award. This
must be valid in the GMCODES file for
type AW.
GMG-BUSLIN-CODE-BU Alpha 15 AC110
Element: Gm Code Code identifying line of business. This
must be valid in the GMCODES file for
type BU.
GMG-PRIME-SPONS-SP Alpha 15 AC110
Element: Gm Code Code identifying the prime sponsor if
the prime sponsor is not an AR customer.
This code must be valid in the GMCODES
file for type SP.
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: Maintenance DaThe 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 AC13.3
AC130 AC135
AC145 AC160
AC165 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC246 AC261
...
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 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
Gmcodes Aw GMCODES Not Required
"AW" -> GMF-TYPE
GMG-AWARD-CODE-AW -> GMF-CODE
Gmcodes Bu GMCODES Not Required
"BU" -> GMF-TYPE
GMG-BUSLIN-CODE-BU -> GMF-CODE
Gmcodes Di GMCODES Not Required
"DI" -> GMF-TYPE
GMG-DIV-CODE-DI -> GMF-CODE
Gmcodes Dp GMCODES Not Required
"DP" -> GMF-TYPE
GMG-DEPT-CODE-DP -> GMF-CODE
Gmcodes Pj GMCODES Not Required
"PJ" -> GMF-TYPE
GMG-PROJ-CODE-PJ -> GMF-CODE
Gmcodes Sp GMCODES Not Required
"SP" -> GMF-TYPE
GMG-PRIME-SPONS-SP -> GMF-CODE
Gmsystem Inst GMSYSTEM Required
GMG-INSTITUTION -> GMB-INSTITUTION
Spaces -> GMB-INST-LOCALE
Gmsystem Loc GMSYSTEM Not Required
GMG-INSTITUTION -> GMB-INSTITUTION
GMG-INST-LOCALE -> GMB-INST-LOCALE
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
|
