V_PROSPECTTEAM_FORINSERT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| PROSPECTID | uniqueidentifier | ||
| MEMBERID | uniqueidentifier | ||
| NAME | nvarchar(154) | yes | |
| DATEFROM | datetime | ||
| DATETO | datetime | yes | |
| PROSPECTTEAMROLECODEID | uniqueidentifier | ||
| ROLEDESCRIPTION | nvarchar(100) | ||
| SITENAME | nvarchar(1024) | yes | |
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TSLONG | bigint | yes | |
| SITEID | uniqueidentifier | yes |
Definition
Copy
CREATE view [dbo].[V_PROSPECTTEAM_FORINSERT]
as
select *
from dbo.V_PROSPECTTEAM
where
(dbo.UFN_CONSTITUENT_ISFUNDRAISER(MEMBERID) = 1) and
(dbo.UFN_CONSTITUENT_ISPROSPECT(PROSPECTID) = 1) and
((DATETO is null) or (dbo.UFN_DATE_GETLATESTTIME(DATETO) >= GETDATE()))
with check option