WKPROJGF

Project Grant Funding

Field Name

Caption

Mask

Description

Field Type

GF_AMOUNT

Grant Amount

nnnnnnnn.nnnn

Grant Amount

Double

GF_CRT_BY

Created By

25x

Created By

Text

GF_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

GF_DOC_FLG

Document Available

 

Document Available

Boolean

GF_DUE_DT

Current Deadline

mm/dd/yyyy

Current Deadline Date

Date/Time

GF_FYEAR

Fiscal Year

nnnn

Fiscal Year

Integer

GF_FYR_CD

Fiscal Year

nnn

Fiscal Year

Integer

GF_FYR_TY

Fiscal Year Text

25x

Fiscal Year Text

Text

GF_ID

Proj Grant Rec #

nnnnnnnn

Proj Grant Rec #

Long Integer

GF_MAMOUNT

Match Amount

nnnnnnnn.nnnn

Match Amount

Double

GF_MOD_BY

Last Modified By

25x

Last Modified By

Text

GF_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

GF_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

GF_MRATE

Match Rate

nnnnnnnn.nn

Match Rate

Double

GF_MTCH_CD

Match Source

5x

Match Source

Text

GF_MTCH_TY

Match Source Text

60x

Match Source Text

Text

GF_NUMBER

Grant Number

30x

Grant Number

Text

GF_PJ_ID

Project Rec #

nnnnnnnn

Link to WKPROJ.PJ_ID

Long Integer

GF_PYEAR

Prior Year Grant

 

Prior Year Project

Boolean

GF_ROWVER

 

 

Rowversion for optimistic locking

Date/Time

GF_USER10

User 10

mm/dd/yyyy

User 10

Date/Time

GF_USER11

User 11

mm/dd/yyyy

User 11

Date/Time

GF_USER12

User 12

mm/dd/yyyy

User 12

Date/Time

GF_USER13

User 13

 

User 13

Boolean

GF_USER14

User 14

 

User 14

Boolean

GF_USER15

User 15

 

User 15

Boolean

GF_USER1CD

User 1

nnn

User 1

Integer

GF_USER1TY

User 1 Text

25x

User 1 Text

Text

GF_USER2CD

User 2

nnn

User 2

Integer

GF_USER2TY

User 2 Text

25x

User 2 Text

Text

GF_USER3CD

User 3

nnn

User 3

Integer

GF_USER3TY

User 3 Text

25x

User 3 Text

Text

GF_USER4

User 4

30x

User 4

Text

GF_USER5

User 5

30x

User 5

Text

GF_USER6

User 6

30x

User 6

Text

GF_USER7

User 7

-nnnnnnnn.nn

User 7

Double

GF_USER8

User 8

-nnnnnnnn.nn

User 8

Double

GF_USER9

User 9

-nnnnnnnn.nn

User 9

Double