USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTUPDATEBATCH_BUSINESS

The load procedure used by the view dataform template "Constituent Update Batch Business View"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@BUSINESS_ADDRESSBLOCK	nvarchar(150)	INOUT	Business address
@BUSINESS_ADDRESSTYPECODEID	uniqueidentifier	INOUT	Business address type
@BUSINESS_CART	nvarchar(10)	INOUT	Business CART
@BUSINESS_CITY	nvarchar(50)	INOUT	Business city
@BUSINESS_COUNTRYID	uniqueidentifier	INOUT	Business country
@BUSINESS_DONOTMAIL	bit	INOUT	Business do not mail
@BUSINESS_DONOTMAILREASONCODEID	uniqueidentifier	INOUT	Business do not mail reason
@BUSINESS_DPC	nvarchar(8)	INOUT	Business DPC
@BUSINESS_EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Business email address
@BUSINESS_EMAILADDRESSTYPECODEID	uniqueidentifier	INOUT	Business email type
@BUSINESS_INDUSTRYCODEID	uniqueidentifier	INOUT	Industry
@BUSINESS_LOOKUPID	nvarchar(100)	INOUT	Business lookup ID
@BUSINESS_LOT	nvarchar(5)	INOUT	Business LOT
@BUSINESS_NAME	nvarchar(100)	INOUT	Business name
@BUSINESS_NUMEMPLOYEES	int	INOUT	Business number of employees
@BUSINESS_NUMSUBSIDIARIES	int	INOUT	Business number of subsidiaries
@BUSINESS_PARENTCORPID	uniqueidentifier	INOUT	Business parent organization
@BUSINESS_PHONENUMBER	nvarchar(100)	INOUT	Business phone number
@BUSINESS_PHONETYPECODEID	uniqueidentifier	INOUT	Business phone type
@BUSINESS_STATEID	uniqueidentifier	INOUT	Business state
@BUSINESS_WEBADDRESS	UDT_WEBADDRESS	INOUT	Business website
@BUSINESS_POSTCODE	nvarchar(12)	INOUT	Business ZIP
@BUSINESS_PHONE_COUNTRYID	uniqueidentifier	INOUT	Business phone number country

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTUPDATEBATCH_BUSINESS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @BUSINESS_ADDRESSBLOCK nvarchar(150) = null output,
    @BUSINESS_ADDRESSTYPECODEID uniqueidentifier = null output,
    @BUSINESS_CART nvarchar(10) = null output,
    @BUSINESS_CITY nvarchar(50) = null output,
    @BUSINESS_COUNTRYID uniqueidentifier = null output,
    @BUSINESS_DONOTMAIL bit = null output,
    @BUSINESS_DONOTMAILREASONCODEID uniqueidentifier = null output,
    @BUSINESS_DPC nvarchar(8) = null output,
    @BUSINESS_EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
    @BUSINESS_EMAILADDRESSTYPECODEID uniqueidentifier = null output,
    @BUSINESS_INDUSTRYCODEID uniqueidentifier = null output,
    @BUSINESS_LOOKUPID nvarchar(100) = null output,
    @BUSINESS_LOT nvarchar(5) = null output,
    @BUSINESS_NAME nvarchar(100) = null output,
    @BUSINESS_NUMEMPLOYEES int = null output,
    @BUSINESS_NUMSUBSIDIARIES int = null output,
    @BUSINESS_PARENTCORPID uniqueidentifier = null output,
    @BUSINESS_PHONENUMBER nvarchar(100) = null output,
    @BUSINESS_PHONETYPECODEID uniqueidentifier = null output,
    @BUSINESS_STATEID uniqueidentifier = null output,
    @BUSINESS_WEBADDRESS dbo.UDT_WEBADDRESS = null output,
    @BUSINESS_POSTCODE nvarchar(12) = null output,
    @BUSINESS_PHONE_COUNTRYID uniqueidentifier = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @BUSINESS_ADDRESSBLOCK = A.ADDRESSBLOCK,
        @BUSINESS_ADDRESSTYPECODEID = A.ADDRESSTYPECODEID,
        @BUSINESS_CART = A.CART,
        @BUSINESS_CITY = A.CITY,
        @BUSINESS_COUNTRYID = A.COUNTRYID,
        @BUSINESS_DONOTMAIL = A.DONOTMAIL,
        @BUSINESS_DONOTMAILREASONCODEID = A.DONOTMAILREASONCODEID,
        @BUSINESS_DPC = A.DPC,
        @BUSINESS_EMAILADDRESS = E.EMAILADDRESS,
        @BUSINESS_EMAILADDRESSTYPECODEID = E.EMAILADDRESSTYPECODEID,
        @BUSINESS_INDUSTRYCODEID = O.INDUSTRYCODEID,
        @BUSINESS_LOOKUPID = B.LOOKUPID,
        @BUSINESS_LOT = A.LOT,
        @BUSINESS_NAME = B.KEYNAME,
        @BUSINESS_NUMEMPLOYEES = O.NUMEMPLOYEES,
        @BUSINESS_NUMSUBSIDIARIES = O.NUMSUBSIDIARIES,
        @BUSINESS_PARENTCORPID = O.PARENTCORPID,
        @BUSINESS_PHONENUMBER = P.NUMBER,
        @BUSINESS_PHONETYPECODEID = P.PHONETYPECODEID,
        @BUSINESS_STATEID = A.STATEID,
        @BUSINESS_WEBADDRESS = B.WEBADDRESS,
        @BUSINESS_POSTCODE = A.POSTCODE,
        @BUSINESS_PHONE_COUNTRYID = P.COUNTRYID
    from 
        dbo.CONSTITUENT B
        left join dbo.ADDRESS A on A.CONSTITUENTID = B.ID and A.ISPRIMARY = 1
        left join dbo.EMAILADDRESS E on E.CONSTITUENTID = B.ID and E.ISPRIMARY = 1
        left join dbo.PHONE P on P.CONSTITUENTID = B.ID and P.ISPRIMARY = 1
        left join dbo.ORGANIZATIONDATA O on O.ID = B.ID
    where 
        B.ID = @ID

    return 0;