ADDSTEWARDSHIPPLANSPROCESS (4.0SP24)

Add stewardship plans process parameters.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

IDSETREGISTERID

uniqueidentifier

true

Selection of constituents to have plans and steps added.

PLANTYPECODEID

uniqueidentifier

true

The plan type for this stewardship plan.

PLANSUBTYPECODEID

uniqueidentifier

true

The plan subtype for this stewardship plan.

MANAGERID

uniqueidentifier

true

FK to CONSTITUENT

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

NAME

nvarchar(100)

false

''

The name of the parameter set.

DESCRIPTION

nvarchar(255)

false

''

Details describing this parameter set

PROSPECTPLANNAME

nvarchar(100)

false

''

STARTDATETYPECODE

tinyint

false

0

0=Date this process runs, 1=Specific date, 2=X days after this process runs, 3=X days before this process runs

STARTDATETYPE

nvarchar(31) (Computed)

true

Provides a translation for the 'STARTDATETYPECODE' field.

STARTDATE

date

true

DAYSBEFOREORAFTER

int

false

0

PLANSTEPS

xml

true

Contains the steps to be associated with the plan.

STEWARDS

xml

true

Contains the stewards to be associated with the plan.

SITES

xml

true

Contains the sites to be associated with the plan.

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.

MANAGERSTARTDATE

date

true

Indexes
Index Name Field(s) Unique Primary Clustered

IX_ADDSTEWARDSHIPPLANSPROCESS_DATEADDED

DATEADDED

False

False

True

IX_ADDSTEWARDSHIPPLANSPROCESS_DATECHANGED

DATECHANGED

False

False

False

IX_ADDSTEWARDSHIPPLANSPROCESS_IDSETREGISTERID

IDSETREGISTERID

False

False

False

IX_ADDSTEWARDSHIPPLANSPROCESS_MANAGERID

MANAGERID

False

False

False

IX_ADDSTEWARDSHIPPLANSPROCESS_PLANTYPECODEID

PLANTYPECODEID

False

False

False

PK_ADDSTEWARDSHIPPLANSPROCESS

ID

True

True

False

UC_ADDSTEWARDSHIPPLANSPROCESS_NAME

NAME

True

False

False
Triggers
Trigger Name Description

TR_ADDSTEWARDSHIPPLANSPROCESS_AUDIT_UPDATE

TR_ADDSTEWARDSHIPPLANSPROCESS_AUDIT_DELETE

Referenced by
Referenced by Field

ADDSTEWARDSHIPPLANSPROCESSSTATUS

PARAMETERSETID