Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
TYPECODE | tinyint | Default = 0 | The type of request. | |
STATUSCODE | tinyint | Default = 0 | The status of request. | |
REVIEWDATE | datetime | Date request was reviewed. | ||
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. | |
TYPE | nvarchar(20) (Computed) | CASE [TYPECODE] WHEN 0 THEN N'Prospect manager' WHEN 1 THEN N'Prospect team member' WHEN 2 THEN N'Primary manager' WHEN 3 THEN N'Secondary manager' WHEN 4 THEN N'Secondary solicitor' END | Provides a translation for the 'TYPECODE' field. | |
STATUS | nvarchar(8) (Computed) | CASE [STATUSCODE] WHEN 0 THEN N'Pending' WHEN 1 THEN N'Approved' WHEN 2 THEN N'Denied' WHEN 3 THEN N'Canceled' END | Provides a translation for the 'STATUSCODE' field. | |
STARTDATE | datetime | Requested start date for the fundraiser. |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
NEWFUNDRAISERID | uniqueidentifier | CONSTITUENT.LOCALID | A foreign key to the proposed fundraiser ID. | |
REVIEWEDBYID | uniqueidentifier | APPUSER.ID | App user who reviewed request. | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
SUBMITTEDBYID | uniqueidentifier | APPUSER.ID | App user who requested the change. |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_PROSPECTASSIGNMENTREQUEST_DATEADDED | DATEADDED | |||
IX_PROSPECTASSIGNMENTREQUEST_DATECHANGED | DATECHANGED | |||
IX_PROSPECTASSIGNMENTREQUEST_NEWFUNDRAISERID | NEWFUNDRAISERID | |||
PK_PROSPECTASSIGNMENTREQUEST | ID |
Trigger Name | Description |
---|---|
TR_PROSPECTASSIGNMENTREQUEST_AUDIT_UPDATE | |
TR_PROSPECTASSIGNMENTREQUEST_AUDIT_DELETE |
Referenced by | Field |
---|---|
PROSPECTASSIGNMENTREQUESTPROSPECT | ID |
PROSPECTASSIGNMENTREQUESTPROSPECTPLAN | ID |