Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GMAWARD


                              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