USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPBATCHHOUSEHOLD

The save procedure used by the add dataform template "Sponsorship Batch Household Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(300)	IN	Description
@GIVESANONYMOUSLY	bit	IN	Household gives anonymously
@ADDRESS_ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@ADDRESS_COUNTRYID	uniqueidentifier	IN	Country
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN	Address
@ADDRESS_CITY	nvarchar(50)	IN	City
@ADDRESS_STATEID	uniqueidentifier	IN	State
@ADDRESS_POSTCODE	nvarchar(12)	IN	ZIP/Postal code
@PHONE_PHONETYPECODEID	uniqueidentifier	IN	Phone type
@PHONE_NUMBER	nvarchar(100)	IN	Phone number
@EMAIL_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Email type
@EMAIL_EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@WEBADDRESS	UDT_WEBADDRESS	IN	Website
@PRIMARYCONTACTID	uniqueidentifier	IN	Full name
@PRIMARYCONTACT_KEYNAME	nvarchar(100)	IN	Last name
@PRIMARYCONTACT_FIRSTNAME	nvarchar(50)	IN	First name
@PRIMARYCONTACT_MIDDLENAME	nvarchar(50)	IN	Middle name
@PRIMARYCONTACT_TITLECODEID	uniqueidentifier	IN	Title
@PRIMARYCONTACT_SUFFIXCODEID	uniqueidentifier	IN	Suffix
@PRIMARYCONTACT_COPYHOUSEHOLDCONTACT	bit	IN	Copy household contact information
@SECONDMEMBERID	uniqueidentifier	IN	Full name
@SECONDMEMBER_KEYNAME	nvarchar(100)	IN	Last name
@SECONDMEMBER_FIRSTNAME	nvarchar(50)	IN	First name
@SECONDMEMBER_MIDDLENAME	nvarchar(50)	IN	Middle name
@SECONDMEMBER_TITLECODEID	uniqueidentifier	IN	Title
@SECONDMEMBER_SUFFIXCODEID	uniqueidentifier	IN	Suffix
@SECONDMEMBER_COPYHOUSEHOLDCONTACT	bit	IN	Copy household contact information
@SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@SECONDMEMBER_RELATIONSHIP_STARTDATE	datetime	IN	Start date
@SECONDMEMBER_RELATIONSHIP_ISSPOUSE	bit	IN	This is the spouse relationship
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DONOTMAIL	bit	IN	Do not send mail to this address
@DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@OMITFROMVALIDATION	bit	IN	Omit this address from validation
@CART	nvarchar(10)	IN
@DPC	nvarchar(8)	IN
@LOT	nvarchar(5)	IN
@COUNTYCODEID	uniqueidentifier	IN
@CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@LASTVALIDATIONATTEMPTDATE	datetime	IN
@VALIDATIONMESSAGE	nvarchar(100)	IN
@CERTIFICATIONDATA	int	IN
@DONOTCALL	bit	IN	Do not call this phone number
@DONOTEMAIL	bit	IN	Do not send email to this address
@INFOSOURCECODEID	uniqueidentifier	IN

Definition

Copy



    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPBATCHHOUSEHOLD
    (
        @ID uniqueidentifier output,
        @NAME nvarchar(100) = null,
        @DESCRIPTION nvarchar(300) = '',
        @GIVESANONYMOUSLY bit = 0,
        @ADDRESS_ADDRESSTYPECODEID uniqueidentifier = null,
        @ADDRESS_COUNTRYID uniqueidentifier = null,
        @ADDRESS_ADDRESSBLOCK nvarchar(150) = '',
        @ADDRESS_CITY nvarchar(50) = '',
        @ADDRESS_STATEID uniqueidentifier = null,
        @ADDRESS_POSTCODE nvarchar(12) = '',
        @PHONE_PHONETYPECODEID uniqueidentifier = null,
        @PHONE_NUMBER nvarchar(100) = '',
        @EMAIL_EMAILADDRESSTYPECODEID uniqueidentifier = null,
        @EMAIL_EMAILADDRESS dbo.UDT_EMAILADDRESS = '',
        @WEBADDRESS dbo.UDT_WEBADDRESS = '',

        -- Primary member fields

        @PRIMARYCONTACTID uniqueidentifier = null,
        @PRIMARYCONTACT_KEYNAME nvarchar(100) = '',
        @PRIMARYCONTACT_FIRSTNAME nvarchar(50) = '',
        @PRIMARYCONTACT_MIDDLENAME nvarchar(50) = '',
        @PRIMARYCONTACT_TITLECODEID uniqueidentifier = null,
        @PRIMARYCONTACT_SUFFIXCODEID uniqueidentifier = null,
        @PRIMARYCONTACT_COPYHOUSEHOLDCONTACT bit = 0,

        -- Secondary member fields

        @SECONDMEMBERID uniqueidentifier = null,
        @SECONDMEMBER_KEYNAME nvarchar(100) = '',
        @SECONDMEMBER_FIRSTNAME nvarchar(50) = '',
        @SECONDMEMBER_MIDDLENAME nvarchar(50) = '',
        @SECONDMEMBER_TITLECODEID uniqueidentifier = null,
        @SECONDMEMBER_SUFFIXCODEID uniqueidentifier = null,
        @SECONDMEMBER_COPYHOUSEHOLDCONTACT bit = 0,
        @SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID uniqueidentifier = null,
        @SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID uniqueidentifier = null,
        @SECONDMEMBER_RELATIONSHIP_STARTDATE datetime = null,
        @SECONDMEMBER_RELATIONSHIP_ISSPOUSE bit = 0,

        @CHANGEAGENTID uniqueidentifier = null,
        @CURRENTAPPUSERID uniqueidentifier,
        @DONOTMAIL bit = 0,
        @DONOTMAILREASONCODEID uniqueidentifier = null,
        @OMITFROMVALIDATION bit = 0,
        @CART nvarchar(10) = '',
        @DPC nvarchar(8) = '',
        @LOT nvarchar(5) = '',
        @COUNTYCODEID uniqueidentifier = null,
        @CONGRESSIONALDISTRICTCODEID uniqueidentifier = null,
        @LASTVALIDATIONATTEMPTDATE datetime = null,
        @VALIDATIONMESSAGE nvarchar(100) = '',
        @CERTIFICATIONDATA integer = 0,
        @DONOTCALL bit = 0,
        @DONOTEMAIL bit = 0,
        @INFOSOURCECODEID uniqueidentifier = null

        ) 
        as
            set nocount on;

            declare @CURRENTDATE datetime;
            set @CURRENTDATE = getdate();

            if @ID is null
                set @ID = newid();

            if @DONOTMAIL = 0 
                set @DONOTMAILREASONCODEID = null

            begin try
                exec dbo.USP_BATCHSPONSORSHIP_ADDHOUSEHOLD @ID output, @NAME, @DESCRIPTION, @GIVESANONYMOUSLY, @ADDRESS_ADDRESSTYPECODEID, @ADDRESS_COUNTRYID, @ADDRESS_ADDRESSBLOCK, 
                    @ADDRESS_CITY, @ADDRESS_STATEID, @ADDRESS_POSTCODE, @PHONE_PHONETYPECODEID, @PHONE_NUMBER, 
                    @EMAIL_EMAILADDRESSTYPECODEID, @EMAIL_EMAILADDRESS, @WEBADDRESS, @PRIMARYCONTACTID, @PRIMARYCONTACT_KEYNAME, 
                    @PRIMARYCONTACT_FIRSTNAME, @PRIMARYCONTACT_MIDDLENAME, @PRIMARYCONTACT_TITLECODEID, @PRIMARYCONTACT_SUFFIXCODEID, 
                    @PRIMARYCONTACT_COPYHOUSEHOLDCONTACT, @SECONDMEMBERID, @SECONDMEMBER_KEYNAME, @SECONDMEMBER_FIRSTNAME, 
                    @SECONDMEMBER_MIDDLENAME, @SECONDMEMBER_TITLECODEID, @SECONDMEMBER_SUFFIXCODEID, @SECONDMEMBER_COPYHOUSEHOLDCONTACT, 
                    @SECONDMEMBER_RELATIONSHIP_RECIPROCALTYPECODEID, @SECONDMEMBER_RELATIONSHIP_RELATIONSHIPTYPECODEID, @SECONDMEMBER_RELATIONSHIP_STARTDATE, 
                    @SECONDMEMBER_RELATIONSHIP_ISSPOUSE, @CHANGEAGENTID, @CURRENTAPPUSERID, @DONOTMAIL, @DONOTMAILREASONCODEID,
                    @OMITFROMVALIDATION, @CART, @DPC, @LOT, @COUNTYCODEID, @CONGRESSIONALDISTRICTCODEID,
                    @LASTVALIDATIONATTEMPTDATE, @VALIDATIONMESSAGE, @CERTIFICATIONDATA, @DONOTCALL, @DONOTEMAIL

            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;