GMFNDACTX

This file contains the grant eligible account categories (expenditures). The file stores the eligible activity/cost account category combination or eligible uses of funds for the grant. If a posting activity and detail cost account category record exists with an eligible = "Y" for the contract/grant combination, it is eligible for expenditure allocation for the grant by GM120 (Grant Expenditure Allocation). Only valid for "G" (Grant) type funding. The file also maintains the pay request summarization or pay request cost classification required for the grant pay request and the cumulative totals (LTD Pay Request amounts). Use GM20.3 (Grant Eligible Account Categories) to define eligible expenditures by grant. GMFNDACTX records are created (added) automatically via GM20.1 (Multi-funded Contract) when the grant is added as a funding source. Addition of the grant funding source will add all the valid posting activity/cost account categories flagged as billable = Y. Records are added with a default as eligible "Y". Ineligible is the exception. The user can use the change function via GM20.4 to override ineligible account categories. If new cost account categories are added via AC08.3 (Account Category Detail) or AC06 (Override Account Categories) records will automatically be created in GM20.4.
UPDATED BY
AC10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GFX-CONTRACT
Element: Contract
Alpha 15
The contract number or identifier for the grant project. The GMFNDACTX file contains the eligible cost account categories for grant contracts defined as "F" Revenue Method contracts via GM20 (Multi-Funded Contract).
AC10.1
GFX-GRANT
Element: Grant
Alpha 30
Grant or non-grant fund code or identifier. Must be a valid grant defined via GM15 (Grant). 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; and some sort of definition of eligible expenditures reimbursed by the grant.
AC10.1
GFX-ACTIVITY
Element: Activity
Alpha 15
Posting level activities for the contract. The GMFNDACTX file contains records for all of the posting activities valid cost account categories. Activity/cost account category records flagged as eligible "Y" are eligible for grant reimbursement. Activity/account category records flagged as eligible "N" will not be allocated or reimbursed by the grant. GMFNDACTX records only exist for "G" Grant Type funds.
AC10.1
GFX-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Cost account categories for the contract. The GMFNDACTX file contains records for all of the activities valid cost account categories. Cost account categories flagged as eligible "Y" are eligible for grant reimbursement. Account categories flagged as eligible "N" will not be allocated or reimbursed by the grant. GMFNDACTX records only exist for "G" Grant Type funds.
AC10.1
GFX-COST-CLASS
Element: Alpha 15
Alpha 15
A cost classification represents a summarization for grant budgeting and pay request summarization.
AC10.1
GFX-INVOICE-AMT
Element: Intl Amt
Signed 18.2
LTD invoice or requested amount for the contract, grant, posting activity, cost account category, and cost classification summary.
GFX-ELIGIBLE
Element: Elig Flag
Alpha 1
Eligible cost account category flag. Valid values include "Y" (Yes) eligible expenditure for grant reimbursement. "N" (No) not an eligible expenditure for grant reimbursement. GM20 (Multi-Funded Contracts), AC08 (Category Structure) and AC06 (Override Account Categories) automatically update this file. Cost account categories flagged as Billable "Y" will be added as Eligible "Y". The user can override eligible account categories to ineligible by changing the eligible flag on GM20.4 (Grant Eligible Account Categories).
Y = Eligible
N = Ineligible
AC10.1
GFX-FUND-AMOUNT
Element: Intl Amt
Signed 18.2
GFX-FUND-PERCENT
Element: Percent
Signed 7.3


GMFNDACTX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GFXSET1 CONTRACT
GRANT
ACTIVITY
ACCT-CATEGORY
GFXSET2 GRANT
COST-CLASS
CONTRACT
ACTIVITY
ACCT-CATEGORY
KeyChange
GFXSET3 ACTIVITY
ACCT-CATEGORY
CONTRACT
GRANT
AC10.1
GFXSET4 ELIGIBLE
ACTIVITY
ACCT-CATEGORY
CONTRACT
GRANT
KeyChange


GMFNDACTX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
GFX-ACCT-CATEGORY->AAX-ACCT-CATEGORY (AAXSET1)
Acactivity ACACTIVITY Required
GFX-ACTIVITY->ACV-ACTIVITY
Accntract ACCNTRACT Required
GFX-CONTRACT->CNT-CONTRACT
Gmfndact GMFNDACT Required
GFX-CONTRACT->GFC-CONTRACT
GFX-GRANT->GFC-GRANT
GFX-ACTIVITY->GFC-ACTIVITY
Gmgrant GMGRANT Required
GFX-GRANT->GRN-GRANT


File created: Wed Jun 08 20:49:00 2016

Home
Contact Us



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