PROSPECTRESEARCHREQUESTCONSTITUENT

This table contains information about prospect research request constituents.

For the full definition of the PROSPECTRESEARCHREQUESTCONSTITUENT table, see PROSPECTRESEARCHREQUESTCONSTITUENT.

Fields

Field	Change	Field Type	Null	Notes	Description
STATUS	Changed	nvarchar(11) (Computed)	yes	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'Cancelled' END	Expression changed from 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 to 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'Cancelled' END