Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
REQUESTNO | int | Default = 0 | ||
STATUSCODE | tinyint | Default = 0 | 0=New, 1=Pending, 2=Assigned, 3=In progress, 4=Completed, 5=Rejected, 6=Canceled | |
RECORDTYPECODE | tinyint | Default = 0 | 0=Individual, 1=Event, 2=Research Group, 3=Organization | |
DUEDATE | datetime | |||
NOTES | nvarchar(max) | Default = '' | ||
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. | |
STATUS | nvarchar(11) (Computed) | CASE [STATUSCODE] WHEN 0 THEN N'New' WHEN 1 THEN N'Pending' WHEN 2 THEN N'Assigned' WHEN 3 THEN N'In progress' WHEN 4 THEN N'Completed' WHEN 5 THEN N'Rejected' WHEN 6 THEN N'Canceled' END | Provides a translation for the 'STATUSCODE' field. | |
STATUSCHANGENOTES | nvarchar(max) | Default = '' | ||
RECORDTYPE | nvarchar(14) (Computed) | CASE [RECORDTYPECODE] WHEN 0 THEN N'Individual' WHEN 1 THEN N'Event' WHEN 2 THEN N'Research Group' WHEN 3 THEN N'Organization' END | Provides a translation for the 'RECORDTYPECODE' field. |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
EVENTID | uniqueidentifier | EVENT.ID | FK to EVENT | |
RESEARCHGROUPID | uniqueidentifier | RESEARCHGROUP.ID | FK to RESEARCHGROUP | |
PROSPECTRESEARCHREQUESTPRIORITYCODEID | uniqueidentifier | PROSPECTRESEARCHREQUESTPRIORITYCODE.ID | FK to PROSPECTRESEARCHREQUESTPRIORITYCODE | |
PROSPECTRESEARCHREQUESTTYPECODEID | uniqueidentifier | PROSPECTRESEARCHREQUESTTYPECODE.ID | FK to PROSPECTRESEARCHREQUESTTYPECODE | |
PROSPECTRESEARCHREQUESTREASONCODEID | uniqueidentifier | PROSPECTRESEARCHREQUESTREASONCODE.ID | FK to PROSPECTRESEARCHREQUESTREASONCODE | |
REQUESTEDBYID | uniqueidentifier | CONSTITUENT.LOCALID | FK to CONSTITUENT | |
SUBMITTEDBYID | uniqueidentifier | CONSTITUENT.LOCALID | FK to CONSTITUENT | |
ASSIGNEDTOID | uniqueidentifier | CONSTITUENT.LOCALID | FK to CONSTITUENT | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
PROSPECTRESEARCHREQUESTSTATUSCHANGECODEID | uniqueidentifier | PROSPECTRESEARCHREQUESTSTATUSCHANGECODE.ID | FK to PROSPECTRESEARCHREQUESTSTATUSCHANGECODE |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_PROSPECTRESEARCHREQUEST_ASSIGNEDTOID | ASSIGNEDTOID | |||
IX_PROSPECTRESEARCHREQUEST_DATEADDED | DATEADDED | |||
IX_PROSPECTRESEARCHREQUEST_DATECHANGED | DATECHANGED | |||
IX_PROSPECTRESEARCHREQUEST_REQUESTEDBYID | REQUESTEDBYID | |||
IX_PROSPECTRESEARCHREQUEST_SUBMITTEDBYID | SUBMITTEDBYID | |||
PK_PROSPECTRESEARCHREQUEST | ID | |||
UIX_PROSPECTRESEARCHREQUEST_REQUESTNO | REQUESTNO |
Trigger Name | Description |
---|---|
TR_PROSPECTRESEARCHREQUEST_AUDIT_UPDATE | |
TR_PROSPECTRESEARCHREQUEST_AUDIT_DELETE |
Referenced by | Field |
---|---|
PROSPECTRESEARCHREQUESTATTACHMENT | PROSPECTRESEARCHREQUESTID |
PROSPECTRESEARCHREQUESTCONSTITUENT | PROSPECTRESEARCHREQUESTID |
PROSPECTRESEARCHREQUESTMEDIALINK | PROSPECTRESEARCHREQUESTID |
PROSPECTRESEARCHREQUESTNOTE | PROSPECTRESEARCHREQUESTID |
PROSPECTRESEARCHREQUESTSITE | PROSPECTRESEARCHREQUESTID |