USP_DATALIST_BBNCSIGNUPBATCH_GETBATCHIDBYTRANID
Gets the Batch ID associated with the specified BBIS Signup Transaction ID.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONTEXTID | int | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_BBNCSIGNUPBATCH_GETBATCHIDBYTRANID(@CONTEXTID int)
as
set nocount on;
select BATCHID
from dbo.BATCHCONSTITUENTUPDATE bcu
join dbo.BATCHCONSTITUENTUPDATEBBNCINFO bcui
on bcu.id = bcui.BATCHCONSTITUENTUPDATEID
where bcui.BBNCTRANID = @CONTEXTID