GMFNDACTX

Grant Eligible Acct Categories
UPDATED BY
AC10.1 AC120

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GFX-CONTRACT
Element: Contract
Alpha 15
AC10.1 AC120
GFX-GRANT
Element: Grant
Alpha 30
AC10.1 AC120
GFX-ACTIVITY
Element: Activity
Alpha 15
AC10.1 AC120
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 AC120
GFX-COST-CLASS
Element: Alpha 15
Alpha 15
A cost classification represents a summarization for grant budgeting and pay request summarization.
AC10.1 AC120
GFX-INVOICE-AMT
Element: Intl Amt
Signed 18.2
GFX-ELIGIBLE
Element: Elig Flag
Alpha 1

Y = Eligible
N = Ineligible
AC10.1 AC120
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
AC10.1 AC120
GFXSET2 GRANT
COST-CLASS
CONTRACT
ACTIVITY
ACCT-CATEGORY
KeyChange
GFXSET3 ACTIVITY
ACCT-CATEGORY
CONTRACT
GRANT
AC10.1 AC120
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: Thu Jun 09 02:15:39 2016

Home
Contact Us



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