GMFNDACT

Grant Eligible Activities

REFERENCED BY
AC40.1 AC40.4 AC41.1 AC41.4 AC42.1 AC45.4
AC46.1 AC540 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 AP510 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
IC12.1 IC140 IC141 IC142 IC145 IC243
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
EX545 IFEB.1 MA180 MA278 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 MA53.1 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 PD570 PO04.1 PO04.2 PO10.1 PO10.2
PO100 PO101 PO115 PO120 PO122 PO131
PO132 PO136 PO15.1 PO15.2 PO15.4 PO150
PO17.1 PO190 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.3 PO22.4 PO220 PO222 PO224 PO225
PO229 PO23.1 PO230 PO234 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO251 PO26.2 PO26.3
PO26.4 PO26.5 PO26.6 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO28.2
PO280 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 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1
RQII.1 RQIJ.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


UPDATED BY
AC10.1 AC120

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GFC-CONTRACT
Element: Contract		Alpha 15
AC10.1 AC120
GFC-GRANT
Element: Grant		Alpha 30
AC10.1 AC120
GFC-ACTIVITY
Element: Activity		Alpha 15
AC10.1 AC120
GFC-ELIGIBLE
Element: Elig Flag		Alpha 1

Y = Eligible
N = Ineligible
AC10.1 AC120
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
AC10.1 AC120
GFCSET2 ELIGIBLE
ACTIVITY
CONTRACT
GRANT
KeyChange
AC10.1 AC120
GFCSET3 CONTRACT
ACTIVITY
GRANT
...
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.4
AC46.1 AC540
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
AP510 AP520


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 02:15:39 2016

Home
Contact Us



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