spUserSolicitorRecords
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientUsersID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spUserSolicitorRecords]
(
@ClientUsersID int
)
AS
SELECT [ID],
[BackOfficeID] ,
[ClientUsersID] ,
[FundRaiserID] ,
[TeamID] ,
[ReportsToID] ,
dbo.fnFundRaiserPageID([ID],1) [FundRaiserPageID] ,
[Goal] ,
[RecruiterID] ,
[Inactive] ,
[Dirty] ,
[AthonUnits],
[AthonLocked],
[Personalization],
[ConfirmationCode]
FROM FundRaiserSolicitors WHERE ClientUsersID = @ClientUsersID
RETURN