GMFNDACT

This file contains the grant eligible activities (expenditures). The file stores the eligible activities (tasks) or eligible uses of funds for the grant. If a posting activity 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 sources. Use GM20.2 (Grant Eligible Activities) to maintain eligible activities (expenditures) by Grant Fund Source. GMFNDACT 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 level activities for the Multi-funded contract. Valid activities include all posting level activity for the Multi-funded contract are flagged on AC10 (Activity) as billable = Y (billable) or H (hold). Records are added with a default as eligible "Y". Ineligible is the exception. The user can use the change function via GM20.2 to override ineligible activities (exception activities). If new posting level activities are added via AC10 (Activity), after the Multi-funded Contract already exists, AC10 will automatically add the posting activity to GM20.2. Note: Billable "H" will have no impact on GM120 (Expenditure Allocation) and GM121 (Request for reimbursement). The assumption is that all of the posting activities under a "F" Multi-funded Contract will be flagged as billable "Y". The expenditures will be either funded by a grant (billed externally) or funded by a non-grant fund (funded internally). Activities stored in this file with Eligible = "Y" (yes) are considered eligible activities for Grant expenditure allocation /invoicing. Activities flagged as Eligible = "N" are not eligible for Grant reimbursement and therefore expenditures will not be allocated from the grant.
UPDATED BY
AC10.1 AC40.1 AC40.4 AC41.1 AC41.4 AC42.1
AC45.4 AC46.1 ACAC.1 AP125 AP126 AP131
AP170 AP193 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP520 API1.1
API2.1 BR41.1 BR41.4 BR43.1 CB10.1 CB15.1
CB15.2 CB150 CB191 CB20.1 CB30.1 CB45.1
CB46.1 CB500 CB543 CB544 CB55.1 CB554
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 EE11.1 EE135
EE20.3 EE35.1 EE35.2 EE520 GL146 GL165
GL170 GL197 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL70.1 GL70.2 GL70.3
GL70.5 GL70.6 GL75.1 GL76.1 DR100 IC140
IC66.1 IC83.1 EX545 IFEB.1 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO136
PO150 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO28.2 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POI3.1
POID.1 POIG.1 POII.1 POIJ.1 POIK.1 RQ10.1
RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQIF.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GFC-CONTRACT
Element: Contract
Alpha 15
The contract number or identifier for the grant project. The GMFNDACT file contains the eligible posting activities for the grant contracts defined as "F" Revenue Method contracts created via GM20 (Multi-Funded Contract).
AC10.1
GFC-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
GFC-ACTIVITY
Element: Activity
Alpha 15
Posting level activities for the contract. The GMFNDACT file contains records for all of the posting level activities under the contract activity. Activities flagged as eligible "Y" are eligible for grant reimbursement. Activities flagged as eligible "N" will not be allocated or reimbursed by the grant. GMFNDACT records only exist for "G" Grant Type funds.
AC10.1
GFC-ELIGIBLE
Element: Elig Flag
Alpha 1
Eligible activity flag. Valid values include "Y" (Yes) eligible expenditure for grant reimbursement, "N" (No) not an eligible expenditure for grant reimbursement. GM20 (Multi-Funded Contracts) and AC10 (Activity) automatically update this file. Posting activities for the contract flagged as Billable "Y" and "H" will be added as Eligible "Y". The user can override eligible activities to ineligible by changing the eligible flag on GM20.2 (Grant Eligible Activities).
Y = Eligible
N = Ineligible
AC10.1
GFC-FUND-AMOUNT
Element: Intl Amt
Signed 18.2
GFC-FUND-PERCENT
Element: Percent
Signed 7.3


GMFNDACT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GFCSET1 CONTRACT
GRANT
ACTIVITY
GFCSET2 ELIGIBLE
ACTIVITY
CONTRACT
GRANT
KeyChange
AC10.1
GFCSET3 CONTRACT
ACTIVITY
GRANT
...
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.4
AC46.1 ACAC.1
AP125 AP126
AP131 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1


GMFNDACT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
GFC-ACTIVITY->ACV-ACTIVITY
Accntract ACCNTRACT Required
GFC-CONTRACT->CNT-CONTRACT
Gmcntrfnd GMCNTRFND Required
GFC-CONTRACT->GCF-CONTRACT
GFC-GRANT->GCF-GRANT
Gmgrant GMGRANT Required
GFC-GRANT->GRN-GRANT


GMFNDACT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Gmfndactx GMFNDACTX
GFC-CONTRACT->GFX-CONTRACT
GFC-GRANT->GFX-GRANT
GFC-ACTIVITY->GFX-ACTIVITY
  GFX-ACCT-CATEGORY


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

Home
Contact Us



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