Open topic with navigation

FUNDINGREQUESTOUTLINESTEP (4.0SP17)

Each funding request outline step is represented by a row in the funding request outline step table.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

FUNDINGREQUESTOUTLINEID

uniqueidentifier

false

FK to FUNDINGREQUESTOUTLINE

INTERACTIONTYPECODEID

uniqueidentifier

true

FK to INTERACTIONTYPECODE

FUNDINGREQUESTSTAGECODEID

uniqueidentifier

false

Indicates which stage of the funding request outline this step belongs to.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

OBJECTIVE

nvarchar(100)

false

''

FUNDRAISERROLECODE

tinyint

false

0

Indicates which fundraiser should be responsible for this step.

FUNDRAISERROLE

nvarchar(19) (Computed)

true

Provides a translation for the 'FUNDRAISERROLECODE' field.

DATEOFFSET

int

false

0

The step date will be this number of days after the first step.

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_FUNDINGREQUESTOUTLINESTEP_DATEADDED

DATEADDED

False

False

True

IX_FUNDINGREQUESTOUTLINESTEP_DATECHANGED

DATECHANGED

False

False

False

IX_FUNDINGREQUESTOUTLINESTEP_FUNDINGREQUESTOUTLINEID

FUNDINGREQUESTOUTLINEID

False

False

False

PK_FUNDINGREQUESTOUTLINESTEP

ID

True

True

False
Triggers
Trigger Name Description

TR_FUNDINGREQUESTOUTLINESTEP_AUDIT_UPDATE

TR_FUNDINGREQUESTOUTLINESTEP_AUDIT_DELETE

TR_FUNDINGREQUESTOUTLINESTEP_AUDIT_ETLDELETEDID

Referenced by
Referenced by Field

INTERACTION

FUNDINGREQUESTOUTLINESTEPID