OPPORTUNITY

Stores opportunity information for a plan.

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

Fields

Field	Change	Field Type	Null	Notes	Description
STATUS	Changed	nvarchar(16) (Computed)	yes	CASE [STATUSCODE] WHEN 0 THEN N'Unqualified' WHEN 1 THEN N'Qualified' WHEN 2 THEN N'Response pending' WHEN 3 THEN N'Accepted' WHEN 4 THEN N'Rejected' WHEN 5 THEN N'Cancelled' END	Expression changed from CASE [STATUSCODE] WHEN 0 THEN N'Unqualified' WHEN 1 THEN N'Qualified' WHEN 2 THEN N'Response pending' WHEN 3 THEN N'Accepted' WHEN 4 THEN N'Rejected' WHEN 5 THEN N'Canceled' END to CASE [STATUSCODE] WHEN 0 THEN N'Unqualified' WHEN 1 THEN N'Qualified' WHEN 2 THEN N'Response pending' WHEN 3 THEN N'Accepted' WHEN 4 THEN N'Rejected' WHEN 5 THEN N'Cancelled' END