The grant file is one of the primary files used to support Multi-Funded Projects for Grant Management Billing. The file stores both grant and non-grant funding sources and accumulated balance amounts at the grant/funding level. The grant file also contains information about the grant including grantor, prime grantor, billing address, contact information, pay request option and reporting information. Use GM15.1 (Grant) to create and maintain grant funds. Grant records added via GM15 will create records in the GMGRANT file with the GRN-FUND-TYPE = "G" Grant. Contracts funded by grants are invoiced by running GM121 (Grant Request for Reimbursement). Use GM16.1 (Non-Grant Funds) to create and maintain non-grant funds. Non-Grant recrods added via GM16 will create records in the GMGRANT file with GRN-FUND-TYPE = "F" Non-grant Fund. Non-grant funds are local funds, specifically, tax funds or appropriations used to fund a project. Non-Grant Funds are internal funds (related to a GL Company, Accounting Unit and Account). Non-Grant Funds do not have a sponsor. Nor can you bill or request reimbursement for non-grant funds. A non-grant fund may fund a single project or may fund multiple projects.

REFERENCED BY

AC10.1

AC10.3

AC210

AC04.1

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) Long description for the grant or non-grant fund.
GRN-BEGIN-DATE Element: Date	Numeric 8 (yyyymmdd) Grant begin date.
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 Fund type is either "G" Grant or "F" Non-grant fund. A grant represents money received from a government department or agency, corporation, foundation or trust. A non-grant fund represents internal or local funds (tax or appropriation funds) used to fund a project. G = Grant F = Non-Grant Fund
GRN-FUND-SOURCE Element: Alpha 15	Alpha 15 A funding source represents an agency awarding grant funding or a non-grant fund. A funding source is assigned to grants and non-grant funds for reporting.
GRN-FUND-GL-CODE Element: Gl Code	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 non-grant fund revenue offset account. The fund GL code is a revenue offset account. This account will be debited when project expenditures are paid using match or non-grant funding. Offsetting entry to local or non-grant (match) revenue.
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 Grant status. Valid values include: 1 - Active, and 2 - Inactive. The default is 1 - Active. 1 = Active 2 = Inactive
GRN-GRANTOR-CO Element: Company	Numeric 4 Grantor or grant sponsor AR Company.
GRN-GRANTOR Element: Customer	Alpha 9 (Right Justified) Grantor or grant sponsor AR customer number.
GRN-PRIME-CO Element: Company	Numeric 4 Prime sponsor AR company number.
GRN-PRIME-GRANTOR Element: Customer	Alpha 9 (Right Justified) Prime grantor or grant sponsor AR customer number.
GRN-PRIME-GRNT-NO Element: Grant	Alpha 30 The prime sponsors grant number.
GRN-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 of benefits to the American public. If the grant is subject to federal regulations, the number assigned to the appropriate federal program in the Catalog of Federal Domestic Assistance (CFDA) is maintained in this field.
GRN-SUBMIT-DATE Element: Date	Numeric 8 (yyyymmdd) The date the grant proposal is submitted.
GRN-NOTICE-DATE Element: Date	Numeric 8 (yyyymmdd) The date the Notice of Grant Award (NOGA) is received.
GRN-RECEIVE-DATE Element: Date	Numeric 8 (yyyymmdd) The date the grant award is received.
GRN-EST-CLOSE-DATE Element: Date	Numeric 8 (yyyymmdd) The estimated or expected close date for the grant.
GRN-ACT-CLOSE-DATE Element: Date	Numeric 8 (yyyymmdd) The actual close date for the grant.
GRN-ARRA-FLAG Element: Flag	Alpha 1 American Recovery and Reinvestment Act of 2009 (ARRA). Flags a grant as ARRA money. Valid values include: Y - Yes, ARRA grant, N - No, not an ARRA grant. Y = Yes N = No
GRN-INVOICE-OPTION Element: Ac Customer Id	Alpha 5 Grantor or grant sponsor Pay Request Invoice Option. Represents a grouping of parameters for invoicing including invoice format, AR interface summarization, pay request and credit memo prefix, grantor bill to address and contact information.
GRN-PO-NUMBER Element: Cust Po Nbr	Alpha 22 PO number represents a customer purchase order number that is assigned to this grant. This number will print on the request for reimbursement (invoice) for customer cross reference. This field is required for interface to AR when a grant is pre-funded. Automatic Payment Apply uses the PO number to match to the prepayment.
GRN-LETTER-CREDIT Element: Letter Credit	Alpha 20 Represents the letter of credit number the contract is paid through. This number prints on the request for reimbursement (invoice).
GRN-DOCUMENT-NBR Element: Document Nbr	Alpha 27 The document number for the letter of credit. The document number identifies the hierarchy under the letter of credit number and is unique for different contracts. The document number prints on the request for reimbursement (invoice).
GRN-PROGRAM-TITLE Element: Description 60	Alpha 60 (Lower Case) A program title or major category for the grant. This will be used for sorting and totalling in the Schedule of Expenditures of Federal Awards (GM270).
GRN-MANAGER-COMP Element: Company	Numeric 4 The manager of the project. The selections are limited to HR resources (HR company and employee) set up in the HR system.
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) Project managers email address.
GRN-FUND-AMOUNT Element: Intl Amt	Signed 18.2 The grant award amount that has been allocated to contracts. This field is updated by GM20 when the grant is assigned to contracts as a funding source. Ensures allocated amount to contracts does not exceed the grant award amount.
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 Grant receivable or requested amount. Updated by Grant Request for Reimbursement (GM121). Sum of receivable amounts on the GMCNTRFND records for the grant.
GRN-RECEIPTS Element: Intl Amt	Signed 18.2 Grant cash receipts. This field is currently not used.
GRN-REMAINING Element: Intl Amt	Signed 18.2 Grant remaining balance. Amount is calculated and stored in grant currency. Equals grant budget less eligible expenditures equals remaining balance.
GRN-AMT-TO-CLAIM Element: Intl Amt	Signed 18.2 Grant amount to claim. This field is not used currently.
GRN-ADMIN-COMP Element: Company	Numeric 4 Grant Administor HR company. The selections are limited to HR resources (HR company and employee) set up in the HR system.
GRN-ADMINISTRATOR Element: Employee	Numeric 9 Grant Administor employee number. The selections are limited to HR resources (HR company and employee) set up in the HR system.
GRN-ADMIN-EMAIL Element: Email Address	Alpha 60 (Lower Case) Grant Administrator email address.
GRN-MATCH Element: Record Type	Alpha 1 Indicate if the grant requires a match or cost share. Valid values are "Y" - Yes the grant requires the grantee receipent to match or cost share the project expenditures. "N" - No the grant does not require the grantee receipent to match or cost share the project expenditures. Y = Yes N = No
GRN-MATCH-INELIG Element: Record Type	Alpha 1 Match ineligible flag. If the grant requires match or cost share this flag designates if the match or cost share covers grant ineligible expenditures. Valid values are "Y" Yes the match reimburses grant ineligible expenditures. "N" No the match does not reimburse grant ineligible expenditures. Y = Yes N = No
GRN-CSTCL-TEMPLATE Element: Template	Alpha 15 Grant Cost Classification Template. The cost classification template defines the relationship between grant cost classification summarization codes and account categories. The template is assigned to the grant and loads valid cost classifications to the budget and grant eligible account categories for pay request summarization.
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

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.