V_PROSPECTTEAM
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] as
SELECT
team.ID,
team.PROSPECTID,
team.MEMBERID,
NF.NAME,
team.DATEFROM,
team.DATETO,
team.PROSPECTTEAMROLECODEID,
code.DESCRIPTION AS ROLEDESCRIPTION,
dbo.UFN_FUNDRAISER_GETDEFAULTSITENAME(team.MEMBERID) AS SITENAME,
team.ADDEDBYID,
team.CHANGEDBYID,
team.DATEADDED,
team.DATECHANGED,
team.TSLONG,
dbo.UFN_FUNDRAISER_GETDEFAULTSITEID(team.MEMBERID) as SITEID
FROM dbo.PROSPECTTEAM AS team
outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(team.MEMBERID) NF
INNER JOIN dbo.PROSPECTTEAMROLECODE AS code ON team.PROSPECTTEAMROLECODEID = code.ID