USP_DATAFORMTEMPLATE_ADD_PROSPECTTEAMMEMBER
The save procedure used by the add dataform template "ProspectTeam Add Data Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @PROSPECTID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @MEMBERID | uniqueidentifier | IN | Team member |
| @PROSPECTTEAMROLECODEID | uniqueidentifier | IN | Role |
| @DATEFROM | datetime | IN | Start date |
| @DATETO | datetime | IN | End date |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PROSPECTTEAMMEMBER
(
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@PROSPECTID uniqueidentifier,
@MEMBERID uniqueidentifier,
@PROSPECTTEAMROLECODEID uniqueidentifier,
@DATEFROM datetime,
@DATETO datetime = null
)
as
exec dbo.USP_PROSPECTTEAMMEMBER_ADD @ID, @CHANGEAGENTID, @PROSPECTID, @MEMBERID, @PROSPECTTEAMROLECODEID, @DATEFROM, @DATETO