GMGRANT

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GRNSET1 GRANT
AC04.1 AC10.1
AC10.3 AC210
GRNSET2 FUND-TYPE
GRANT
GRNSET3 FUND-SOURCE
GRANT
KeyChange
GRNSET4 GRANTOR-CO
GRANTOR
GRANT
KeyChange
GRNSET5 MANAGER-COMP
MANAGER
GRANT
KeyChange


GMGRANT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accustomer ACCUSTOMER Not Required
GRN-GRANTOR-CO->CMR-COMPANY (CMRSET1)
GRN-GRANTOR->CMR-CUSTOMER
GRN-INVOICE-OPTION->CMR-AC-CUSTOMER-ID
Dfrrevacctcat ACACCTCAT Not Required
GRN-DFR-ACCT-CAT->AAX-ACCT-CATEGORY
Dfrrevenueglcd ACGLCODE Not Required
GRN-DFR-REV-GL-CD->AGC-AC-GL-CODE
Duefrglcode ACGLCODE Required
GRN-DUE-FR-GL-CODE->AGC-AC-GL-CODE
Duetoglcode ACGLCODE Required
GRN-DUE-TO-GL-CODE->AGC-AC-GL-CODE
Fundglcode ACGLCODE Required
When GRN-FUND-TYPE ="F"
GRN-FUND-GL-CODE->AGC-AC-GL-CODE
Grantor ARCUSTOMER Not Required
GRN-GRANTOR-CO->ACM-COMPANY
GRN-GRANTOR->ACM-CUSTOMER
Manager EMPLOYEE Not Required
GRN-MANAGER-COMP->EMP-COMPANY
GRN-MANAGER->EMP-EMPLOYEE
Prime ARCUSTOMER Not Required
GRN-PRIME-CO->ACM-COMPANY
GRN-PRIME-GRANTOR->ACM-CUSTOMER
Revacctcat ACACCTCAT Required
GRN-REV-ACCT-CAT->AAX-ACCT-CATEGORY
Revenueglcode ACGLCODE Required
GRN-REVENUE-GL-CD->AGC-AC-GL-CODE


GMGRANT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Achisthdr ACHISTHDR
GRN-GRANT->HIH-GRANT
  HIH-CONTRACT
  HIH-OBJ-ID
Gmcctmpdtl GMCCTMPDTL
GRN-CSTCL-TEMPLATE->GTD-TEMPLATE
  GTD-COST-CLASS
  GTD-ACCT-CAT
Gmcntrfnd GMCNTRFND
GRN-GRANT->GCF-GRANT
  GCF-CONTRACT


File created: Thu Jun 09 11:14:23 2016

Home
Contact Us



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