Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 AMOUNTREQUESTED money   Default = 0 The amount requested for a funding purpose.
 COMMENT nvarchar(500)   Default = '' Comments for the plan.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 FUNDINGREQUESTSTAGECODEID uniqueidentifier (Computed) dbo.UFN_FUNDINGREQUEST_CURRENTSTAGE(ID)
 DATESUBMITTED datetime The date the request was submitted.
 TRANSACTIONAMOUNTREQUESTED money   Default = 0 The transaction amount requested for a funding purpose.
 ORGANIZATIONAMOUNTREQUESTED money   Default = 0 The amount requested of the funding request in organization currency.
 AMOUNTAWARDED money (Computed) dbo.UFN_FUNDINGREQUEST_GETAMOUNTAWARDED(ID)
 TRANSACTIONAMOUNTAWARDED money (Computed) dbo.UFN_FUNDINGREQUEST_GETTRANSACTIONAMOUNTAWARDED(ID)
 ORGANIZATIONAMOUNTAWARDED money (Computed) dbo.UFN_FUNDINGREQUEST_GETORGANIZATIONAMOUNTAWARDED(ID)

Foreign Key Field Type Null Notes Description
 GRANTSID uniqueidentifier   GRANTS.ID A foreign key to the grant table.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 FUNDINGPLANID uniqueidentifier   FUNDINGPLAN.ID FK to FUNDINGPLAN
 PRIMARYMANAGERID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 SECONDARYMANAGERID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 FUNDINGREQUESTSTATUSCODEID uniqueidentifier   FUNDINGREQUESTSTATUSCODE.ID FK to FUNDINGREQUESTSTATUSCODE
 FUNDINGREQUESTTYPECODEID uniqueidentifier FUNDINGREQUESTTYPECODE.ID FK to FUNDINGREQUESTTYPECODE
 BASEEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to calculate the base amount.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this funding request.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from amount to organization amount.
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this record.

Index Name Field(s) Unique Primary Clustered
 IX_FUNDINGREQUEST_BASECURRENCYID BASECURRENCYID      
 IX_FUNDINGREQUEST_BASEEXCHANGERATEID BASEEXCHANGERATEID      
 IX_FUNDINGREQUEST_DATEADDED DATEADDED    
 IX_FUNDINGREQUEST_DATECHANGED DATECHANGED      
 IX_FUNDINGREQUEST_FUNDINGPLANID FUNDINGPLANID      
 IX_FUNDINGREQUEST_GRANTSID GRANTSID      
 IX_FUNDINGREQUEST_ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID      
 IX_FUNDINGREQUEST_PRIMARYMANAGERID PRIMARYMANAGERID      
 IX_FUNDINGREQUEST_SECONDARYMANAGERID SECONDARYMANAGERID      
 IX_FUNDINGREQUEST_TRANSACTIONCURRENCYID TRANSACTIONCURRENCYID      
 PK_FUNDINGREQUEST ID  

Trigger Name Description
 TR_FUNDINGREQUEST_INSERTUPDATE_CURRENCY
 TR_FUNDINGREQUEST_AUDIT_ETLDELETEDID
 TR_FUNDINGREQUEST_AUDIT_UPDATE
 TR_FUNDINGREQUEST_AUDIT_DELETE

Referenced by Field
 FUNDINGREQUESTATTACHMENT FUNDINGREQUESTID
 FUNDINGREQUESTDESIGNATION FUNDINGREQUESTID
 FUNDINGREQUESTMEDIALINK FUNDINGREQUESTID
 FUNDINGREQUESTNOTE FUNDINGREQUESTID
 FUNDINGREQUESTSPONSOR FUNDINGREQUESTID
 INTERACTION FUNDINGREQUESTID
 REVENUEFUNDINGREQUEST FUNDINGREQUESTID

Entity-Relationship diagram of this table