Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
NAME | nvarchar(150) | Default = '' | The name of the funding plan. | |
DESCRIPTION | nvarchar(500) | Default = '' | The description of the funding plan. | |
FUNDINGNEED | money | Default = 0 | The amount that needs to be funded. | |
DATENEEDED | datetime | The date by which the funding is needed. | ||
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. | |
INACTIVE | bit | Default = 0 | ||
ORGANIZATIONFUNDINGNEED | money | Default = 0 | The amount that needs to be funded in the organizations base. |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
SITEID | uniqueidentifier | SITE.ID | The site associated with this funding plan. | |
FUNDINGPLANDEPARTMENTCODEID | uniqueidentifier | FUNDINGPLANDEPARTMENTCODE.ID | The funding plan department. | |
FUNDINGPLANPROGRAMCODEID | uniqueidentifier | FUNDINGPLANPROGRAMCODE.ID | The funding plan program. | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
FUNDINGPLANMANAGERID | uniqueidentifier | CONSTITUENT.LOCALID | The constituent that acts as the funding plan manager. | |
BASECURRENCYID | uniqueidentifier | CURRENCY.ID | The base currency associated with this funding plan. | |
ORGANIZATIONEXCHANGERATEID | uniqueidentifier | CURRENCYEXCHANGERATE.ID | The organization exchange rate associated with this funding plan. |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_FUNDINGPLAN_BASECURRENCYID | BASECURRENCYID | |||
IX_FUNDINGPLAN_DATEADDED | DATEADDED | |||
IX_FUNDINGPLAN_DATECHANGED | DATECHANGED | |||
IX_FUNDINGPLAN_FUNDINGPLANMANAGERID | FUNDINGPLANMANAGERID | |||
IX_FUNDINGPLAN_ORGANIZATIONEXCHANGERATEID | ORGANIZATIONEXCHANGERATEID | |||
IX_FUNDINGPLAN_SITEID | SITEID | |||
PK_FUNDINGPLAN | ID | |||
UIX_FUNDINGPLAN_NAME | NAME |
Trigger Name | Description |
---|---|
TR_FUNDINGPLAN_AUDIT_UPDATE | |
TR_FUNDINGPLAN_AUDIT_DELETE | |
TR_FUNDINGPLAN_INSERT_BASECURRENCYID |
Referenced by | Field |
---|---|
FUNDINGPLANATTACHMENT | FUNDINGPLANID |
FUNDINGPLANMEDIALINK | FUNDINGPLANID |
FUNDINGPLANNOTE | FUNDINGPLANID |
FUNDINGREQUEST | FUNDINGPLANID |