Grant

REFERENCED BY

AC04.1	AC10.1	AC10.3	AC120	AC135	AC210
MX123	MX500	MX202

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
GRN-GRANT Element: Grant	Alpha 30 Grant or non-grant fund code or identifier. Grants are funds disbursed by one party (grantor) often a government department or agency to a recipient (grantee). Most grants are made to fund a specific project and require some level of compliance and reporting. Non-grant funds are internal or local funding the grantee contributes towards the project.
GRN-DESCRIPTION Element: Description	Alpha 30 (Lower Case) Description for the grant or non-grant fund.
GRN-LONG-DESC Element: Long Desc	Alpha 60 (Lower Case)
GRN-BEGIN-DATE Element: Date	Numeric 8 (yyyymmdd)
GRN-END-DATE Element: Date	Numeric 8 (yyyymmdd) Grant end date.
GRN-AMOUNT Element: Intl Amt	Signed 18.2 Grant awarded amount.
GRN-CURRENCY-CODE Element: Currency Code	Alpha 5 Currency code for the grant award amount.
GRN-FUND-TYPE Element: Record Type	Alpha 1 G = Grant F = Non-Grant Fund
GRN-FUND-SOURCE Element: Alpha 15	Alpha 15
GRN-FUND-GL-CODE Element: Gl Code	Alpha 4
GRN-REVENUE-GL-CD Element: Revenue Gl Cd	Alpha 4 A GL code is a short cut code which represents a general ledger account for posting to the General Ledger system. This field maintains the default revenue account for the grant or non-grant fund. This account will be credited when project expenditures are invoiced. The offset entry for grants is a debit to AR. The offsetting entry for non-grant funds is revenue offset.
GRN-REV-ACCT-CAT Element: Acct Category	Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. Select a revenue type account category for posting grant and non-grant fund revenue to activities.
GRN-DFR-REV-GL-CD Element: Revenue Gl Cd	Alpha 4 Deferred Revenue GL Code. This field is not currently used.
GRN-DFR-ACCT-CAT Element: Acct Category	Alpha 5 Deferred Revenue Account Category. This field is not currently used.
GRN-STATUS Element: Status	Numeric 1 1 = Active 2 = Inactive
GRN-GRANTOR-CO Element: Company	Numeric 4
GRN-GRANTOR Element: Customer	Alpha 9 (Right Justified)
GRN-PRIME-CO Element: Company	Numeric 4
GRN-PRIME-GRANTOR Element: Customer	Alpha 9 (Right Justified)
GRN-PRIME-GRNT-NO Element: Grant	Alpha 30
GRN-CFDA-NUMBER Element: Cfda Number	Alpha 30
GRN-SUBMIT-DATE Element: Date	Numeric 8 (yyyymmdd)
GRN-NOTICE-DATE Element: Date	Numeric 8 (yyyymmdd)
GRN-RECEIVE-DATE Element: Date	Numeric 8 (yyyymmdd)
GRN-EST-CLOSE-DATE Element: Date	Numeric 8 (yyyymmdd)
GRN-ACT-CLOSE-DATE Element: Date	Numeric 8 (yyyymmdd)
GRN-ARRA-FLAG Element: Flag	Alpha 1 Y = Yes N = No
GRN-INVOICE-OPTION Element: Ac Customer Id	Alpha 5
GRN-PO-NUMBER Element: Cust Po Nbr	Alpha 22
GRN-LETTER-CREDIT Element: Letter Credit	Alpha 20
GRN-DOCUMENT-NBR Element: Document Nbr	Alpha 27
GRN-PROGRAM-TITLE Element: Description 60	Alpha 60 (Lower Case)
GRN-MANAGER-COMP Element: Company	Numeric 4
GRN-MANAGER Element: Employee	Numeric 9 The manager of the project. The selections are limited to HR resources (HR company and employee) set up in the HR system.
GRN-MANAGER-EMAIL Element: Email Address	Alpha 60 (Lower Case)
GRN-FUND-AMOUNT Element: Intl Amt	Signed 18.2
GRN-EXPENDITURES Element: Intl Amt	Signed 18.2 Grant Eligible Expenditures is updated by Grant Expenditure Allocation (GM120). This amount represents the sum of eligible expenditures for all contracts the grant funds. The amount is stored in grant fund currency. Sum of eligible expenditures from GMCNTRFND records for the grant.
GRN-RECEIVABLE Element: Intl Amt	Signed 18.2
GRN-RECEIPTS Element: Intl Amt	Signed 18.2
GRN-REMAINING Element: Intl Amt	Signed 18.2
GRN-AMT-TO-CLAIM Element: Intl Amt	Signed 18.2
GRN-ADMIN-COMP Element: Company	Numeric 4
GRN-ADMINISTRATOR Element: Employee	Numeric 9
GRN-ADMIN-EMAIL Element: Email Address	Alpha 60 (Lower Case)
GRN-MATCH Element: Record Type	Alpha 1 Y = Yes N = No
GRN-MATCH-INELIG Element: Record Type	Alpha 1 Y = Yes N = No
GRN-CSTCL-TEMPLATE Element: Template	Alpha 15
GRN-GRANT-BUD-AMT Element: Intl Amt	Signed 18.2
GRN-MATCH-BUD-AMT Element: Intl Amt	Signed 18.2
GRN-MATCH-PERC Element: Percent	Signed 7.3
GRN-DUE-TO-GL-CODE Element: Gl Code	Alpha 4
GRN-DUE-FR-GL-CODE Element: Gl Code	Alpha 4
GRN-OBJ-ID Element: Obj Id	Numeric 12
GRN-PRE-AWARD Element: Flag	Alpha 1 Y = Yes N = No

GMGRANT FILE INDEX

GMGRANT FILE RELATIONS

ONE TO ONE RELATIONS

GMGRANT FILE RELATIONS

ONE TO MANY RELATIONS

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