Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
NAME | nvarchar(100) | Default = '' | ||
DESCRIPTION | nvarchar(255) | Default = '' | ||
MODECODE | tinyint | Default = 0 | ||
MODE | nvarchar(58) (Computed) | CASE [MODECODE] WHEN 0 THEN N'Replace an officer on an existing stewardship plan' WHEN 1 THEN N'Assign an officer to roles on an existing stewardship plan' END | ||
TRANSFERPLANMANAGERASSIGNMENTS | bit | Default = 0 | ||
TRANSFERPLANSTEWARDASSIGNMENTS | bit | Default = 0 | ||
TRANSFERASSIGNEDSTEPRESPONSIBILITIES | bit | Default = 0 | ||
DATEADDED | datetime | Default = getdate() | ||
DATECHANGED | datetime | Default = getdate() | ||
TS | timestamp | |||
TSLONG | bigint (Computed) | CONVERT(bigint, TS) |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
OLDOFFICERID | uniqueidentifier | CONSTITUENT.LOCALID | ||
IDSETREGISTERID | uniqueidentifier | IDSETREGISTER.ID | ||
NEWOFFICERID | uniqueidentifier | CONSTITUENT.LOCALID | ||
ROLECODEID | uniqueidentifier | STEWARDSHIPSTEWARDROLECODE.ID | ||
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | ||
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_STEWARDSHIPPLANASSIGNMENTPROCESS_DATEADDED | DATEADDED | |||
IX_STEWARDSHIPPLANASSIGNMENTPROCESS_DATECHANGED | DATECHANGED | |||
IX_STEWARDSHIPPLANASSIGNMENTPROCESS_IDSETREGISTERID | IDSETREGISTERID | |||
IX_STEWARDSHIPPLANASSIGNMENTPROCESS_NEWOFFICERID | NEWOFFICERID | |||
IX_STEWARDSHIPPLANASSIGNMENTPROCESS_OLDOFFICERID | OLDOFFICERID | |||
PK_STEWARDSHIPPLANASSIGNMENTPROCESS | ID | |||
UC_STEWARDSHIPPLANASSIGNMENTPROCESS_NAME | NAME |
Trigger Name | Description |
---|---|
TR_STEWARDSHIPPLANASSIGNMENTPROCESS_AUDIT_UPDATE | |
TR_STEWARDSHIPPLANASSIGNMENTPROCESS_AUDIT_DELETE |
Referenced by | Field |
---|---|
STEWARDSHIPPLANASSIGNMENTPROCESSSTATUS | PARAMETERSETID |