USP_DATAFORMTEMPLATE_ADD_INDIVIDUALSPOUSEBUSINESS_WRAPPED3

The save procedure used by the add dataform template "Individual, Spouse, Business Add Form (Wrapped - Assessee Name, Assessee Address)".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@RESULTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@LASTNAME	nvarchar(100)	IN	Last name
@FIRSTNAME	nvarchar(50)	IN	First name
@MIDDLENAME	nvarchar(50)	IN	Middle name
@MAIDENNAME	nvarchar(100)	IN	Maiden name
@NICKNAME	nvarchar(50)	IN	Nickname
@TITLECODEID	uniqueidentifier	IN	Title
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@GENDERCODE	tinyint	IN	Gender
@BIRTHDATE	UDT_FUZZYDATE	IN	Birth date
@ADDRESS_ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@ADDRESS_DONOTMAIL	bit	IN	Do not send mail to this address
@ADDRESS_COUNTRYID	uniqueidentifier	IN	Country
@ADDRESS_STATEID	uniqueidentifier	IN	State
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN	Address
@ADDRESS_CITY	nvarchar(50)	IN	City
@ADDRESS_POSTCODE	nvarchar(12)	IN	ZIP
@PHONE_PHONETYPECODEID	uniqueidentifier	IN	Phone type
@PHONE_NUMBER	nvarchar(100)	IN	Phone number
@EMAILADDRESS_EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Email type
@EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@MARITALSTATUSCODEID	uniqueidentifier	IN	Marital status
@SKIP_ADDING_SECURITYGROUPS	bit	IN	Skip adding security groups
@SPOUSEID	uniqueidentifier	IN	Full name
@EXISTINGSPOUSE	bit	IN	Search existing constituents
@SPOUSE_LASTNAME	nvarchar(100)	IN	Last name
@SPOUSE_FIRSTNAME	nvarchar(50)	IN	First name
@SPOUSE_MIDDLENAME	nvarchar(50)	IN	Middle name
@SPOUSE_MAIDENNAME	nvarchar(100)	IN	Maiden name
@SPOUSE_NICKNAME	nvarchar(50)	IN	Nickname
@SPOUSE_TITLECODEID	uniqueidentifier	IN	Title
@SPOUSE_SUFFIXCODEID	uniqueidentifier	IN	Suffix
@SPOUSE_GENDERCODE	tinyint	IN	Gender
@SPOUSE_BIRTHDATE	UDT_FUZZYDATE	IN	Birth date
@SPOUSE_RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@SPOUSE_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@COPYPRIMARYINFORMATION	bit	IN	Copy primary information
@SPOUSE_STARTDATE	datetime	IN	Start date
@PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Soft credit individual for constituent's payments
@PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition match percent
@RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Soft credit constituent for individual's payments
@RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition match percent
@ORGANIZATIONID	uniqueidentifier	IN	Org. name
@EXISTINGORGANIZATION	bit	IN	Search existing constituents
@ORGANIZATION_NAME	nvarchar(100)	IN	Org. name
@ORGANIZATION_ADDRESSTYPECODEID	uniqueidentifier	IN	Address type
@ORGANIZATION_COUNTRYID	uniqueidentifier	IN	Country
@ORGANIZATION_STATEID	uniqueidentifier	IN	State
@ORGANIZATION_ADDRESSBLOCK	nvarchar(150)	IN	Address
@ORGANIZATION_CITY	nvarchar(50)	IN	City
@ORGANIZATION_POSTCODE	nvarchar(12)	IN	ZIP
@ORGANIZATION_DONOTMAIL	bit	IN	Do not send mail to this address
@ORGANIZATION_PHONETYPECODEID	uniqueidentifier	IN	Phone type
@ORGANIZATION_NUMBER	nvarchar(100)	IN	Phone number
@ORGANIZATION_RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@ORGANIZATION_RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@ORGANIZATION_STARTDATE	datetime	IN	Start date
@ORGANIZATION_ENDDATE	datetime	IN	End date
@ISCONTACT	bit	IN
@ISPRIMARYCONTACT	bit	IN	Primary contact
@CONTACTTYPECODEID	uniqueidentifier	IN	Contact type
@POSITION	nvarchar(50)	IN	Job title
@ISMATCHINGGIFTRELATIONSHIP	bit	IN	This organization will match individual's contributions
@RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition credit type
@PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition credit type
@ADDRESS_OMITFROMVALIDATION	bit	IN	Omit from validation
@ADDRESS_CART	nvarchar(10)	IN
@ADDRESS_DPC	nvarchar(8)	IN
@ADDRESS_LOT	nvarchar(5)	IN
@ADDRESS_COUNTYCODEID	uniqueidentifier	IN
@ADDRESS_CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@ADDRESS_LASTVALIDATIONATTEMPTDATE	datetime	IN
@ADDRESS_VALIDATIONMESSAGE	nvarchar(200)	IN
@ADDRESS_CERTIFICATIONDATA	int	IN
@ORGANIZATION_OMITFROMVALIDATION	bit	IN	Omit from validation
@ORGANIZATION_CART	nvarchar(10)	IN
@ORGANIZATION_DPC	nvarchar(8)	IN
@ORGANIZATION_LOT	nvarchar(5)	IN
@ORGANIZATION_COUNTYCODEID	uniqueidentifier	IN
@ORGANIZATION_CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@ORGANIZATION_LASTVALIDATIONATTEMPTDATE	datetime	IN
@ORGANIZATION_VALIDATIONMESSAGE	nvarchar(200)	IN
@ORGANIZATION_CERTIFICATIONDATA	int	IN
@ISSPOUSERELATIONSHIP	bit	IN	This is the spouse relationship for individual
@HOUSEHOLDCOPYPRIMARYCONTACTINFO	bit	IN	Copy individual's primary contact information
@ADDRESS_DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@ORGANIZATION_DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@JOBCATEGORYCODEID	uniqueidentifier	IN	Category
@CAREERLEVELCODEID	uniqueidentifier	IN	Career level
@ADDRESS_INFOSOURCECODEID	uniqueidentifier	IN	Information source
@ORGANIZATION_INFOSOURCECODEID	uniqueidentifier	IN	Information source
@TITLE2CODEID	uniqueidentifier	IN	Title 2
@SUFFIX2CODEID	uniqueidentifier	IN	Suffix 2
@SPOUSE_TITLE2CODEID	uniqueidentifier	IN	Title 2
@SPOUSE_SUFFIX2CODEID	uniqueidentifier	IN	Suffix 2
@SKIP_ADDING_SITES	bit	IN	Skip adding sites
@ORGANIZATION_PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply to individual for revenue from organization
@ORGANIZATION_PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition credit match percent
@ORGANIZATION_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply to organization for revenue from individual
@ORGANIZATION_RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition credit match percent
@ORGANIZATION_PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition credit type
@ORGANIZATION_RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition credit type

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_INDIVIDUALSPOUSEBUSINESS_WRAPPED3 
(
    @ID                                        uniqueidentifier = null output,
    @RESULTID                                uniqueidentifier,
    @CURRENTAPPUSERID                        uniqueidentifier,
    @CHANGEAGENTID                            uniqueidentifier = null,
    @LASTNAME                                nvarchar(100),
    @FIRSTNAME                                nvarchar(50) = '',
    @MIDDLENAME                                nvarchar(50) = '',
    @MAIDENNAME                                nvarchar(100) = '',
    @NICKNAME                                nvarchar(50) = '',
    @TITLECODEID                            uniqueidentifier = null,
    @SUFFIXCODEID                            uniqueidentifier = null,
    @GENDERCODE                                tinyint = 0,
    @BIRTHDATE                                dbo.UDT_FUZZYDATE = '00000000',
    @ADDRESS_ADDRESSTYPECODEID                uniqueidentifier = null,
    @ADDRESS_DONOTMAIL                        bit = 0,
    @ADDRESS_COUNTRYID                        uniqueidentifier = null,
    @ADDRESS_STATEID                        uniqueidentifier = null,
    @ADDRESS_ADDRESSBLOCK                    nvarchar(150) = '',
    @ADDRESS_CITY                            nvarchar(50) = '',
    @ADDRESS_POSTCODE                        nvarchar(12) = '',
    @PHONE_PHONETYPECODEID                    uniqueidentifier = null,
    @PHONE_NUMBER                            nvarchar(100) = '',
    @EMAILADDRESS_EMAILADDRESSTYPECODEID    uniqueidentifier = null,
    @EMAILADDRESS_EMAILADDRESS                dbo.UDT_EMAILADDRESS = '',
    @MARITALSTATUSCODEID                    uniqueidentifier = null,
    @SKIP_ADDING_SECURITYGROUPS                bit=0,
    @SPOUSEID                                uniqueidentifier = null,
    @EXISTINGSPOUSE                            bit = 0,
    @SPOUSE_LASTNAME                        nvarchar(100) = '',
    @SPOUSE_FIRSTNAME                        nvarchar(50) = '',
    @SPOUSE_MIDDLENAME                        nvarchar(50) = '',
    @SPOUSE_MAIDENNAME                        nvarchar(100) = '',
    @SPOUSE_NICKNAME                        nvarchar(50) = '',
    @SPOUSE_TITLECODEID                        uniqueidentifier = null,
    @SPOUSE_SUFFIXCODEID                    uniqueidentifier = null,
    @SPOUSE_GENDERCODE                        tinyint = 0,
    @SPOUSE_BIRTHDATE                        dbo.UDT_FUZZYDATE = '00000000',
    @SPOUSE_RECIPROCALTYPECODEID            uniqueidentifier = null,
    @SPOUSE_RELATIONSHIPTYPECODEID            uniqueidentifier = null,
    @COPYPRIMARYINFORMATION                    bit = 1,
    @SPOUSE_STARTDATE                        datetime = null,
    @PRIMARYSOFTCREDITRELATIONSHIPEXISTS    bit = 0,
    @PRIMARYSOFTCREDITMATCHFACTOR            decimal(5,
    2) = 100,
    @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit = 0,
    @RECIPROCALSOFTCREDITMATCHFACTOR        decimal(5,
    2) = 100,
    @ORGANIZATIONID                            uniqueidentifier = null,
    @EXISTINGORGANIZATION                    bit = 0,
    @ORGANIZATION_NAME                        nvarchar(100) = '',
    @ORGANIZATION_ADDRESSTYPECODEID            uniqueidentifier = null,
    @ORGANIZATION_COUNTRYID                    uniqueidentifier = null,
    @ORGANIZATION_STATEID                    uniqueidentifier = null,
    @ORGANIZATION_ADDRESSBLOCK                nvarchar(150) = '',
    @ORGANIZATION_CITY                        nvarchar(50) = '',
    @ORGANIZATION_POSTCODE                    nvarchar(12) = '',
    @ORGANIZATION_DONOTMAIL                    bit = 0,
    @ORGANIZATION_PHONETYPECODEID            uniqueidentifier = null,
    @ORGANIZATION_NUMBER                    nvarchar(100) = '',
    @ORGANIZATION_RECIPROCALTYPECODEID        uniqueidentifier = null,
    @ORGANIZATION_RELATIONSHIPTYPECODEID    uniqueidentifier = null,
    @ORGANIZATION_STARTDATE                    datetime = null,
    @ORGANIZATION_ENDDATE                    datetime = null,
    @ISCONTACT                                bit = 0,
    @ISPRIMARYCONTACT                        bit = 0,
    @CONTACTTYPECODEID                        uniqueidentifier = null,
    @POSITION                                nvarchar(50) = '',
    @ISMATCHINGGIFTRELATIONSHIP                bit = 0,
    @RECIPROCALRECOGNITIONTYPECODEID        uniqueidentifier = null,
    @PRIMARYRECOGNITIONTYPECODEID        uniqueidentifier = null,
    @ADDRESS_OMITFROMVALIDATION bit = 0,
    @ADDRESS_CART nvarchar(10) = '',
    @ADDRESS_DPC nvarchar(8) = '',
    @ADDRESS_LOT nvarchar(5) = '',
    @ADDRESS_COUNTYCODEID uniqueidentifier = null,
    @ADDRESS_CONGRESSIONALDISTRICTCODEID uniqueidentifier = null,
    @ADDRESS_LASTVALIDATIONATTEMPTDATE datetime = null,
    @ADDRESS_VALIDATIONMESSAGE nvarchar(200) = '',
    @ADDRESS_CERTIFICATIONDATA integer = 0,
    @ORGANIZATION_OMITFROMVALIDATION bit = 0,
    @ORGANIZATION_CART nvarchar(10) = '',
    @ORGANIZATION_DPC nvarchar(8) = '',
    @ORGANIZATION_LOT nvarchar(5) = '',
    @ORGANIZATION_COUNTYCODEID uniqueidentifier = null,
    @ORGANIZATION_CONGRESSIONALDISTRICTCODEID uniqueidentifier = null,
    @ORGANIZATION_LASTVALIDATIONATTEMPTDATE datetime = null,
    @ORGANIZATION_VALIDATIONMESSAGE nvarchar(200) = '',
    @ORGANIZATION_CERTIFICATIONDATA integer = 0,
    @ISSPOUSERELATIONSHIP bit = 1,
    @HOUSEHOLDCOPYPRIMARYCONTACTINFO bit = 0,
    @ADDRESS_DONOTMAILREASONCODEID uniqueidentifier = null,
    @ORGANIZATION_DONOTMAILREASONCODEID uniqueidentifier = null,
    @JOBCATEGORYCODEID uniqueidentifier = null,
    @CAREERLEVELCODEID uniqueidentifier = null,
    @ADDRESS_INFOSOURCECODEID uniqueidentifier = null,
    @ORGANIZATION_INFOSOURCECODEID uniqueidentifier = null,
    @TITLE2CODEID                            uniqueidentifier = null,
    @SUFFIX2CODEID                            uniqueidentifier = null,
    @SPOUSE_TITLE2CODEID                    uniqueidentifier = null,
    @SPOUSE_SUFFIX2CODEID                    uniqueidentifier = null,
    @SKIP_ADDING_SITES bit=0,
    @ORGANIZATION_PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit = 0,
    @ORGANIZATION_PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2) = 100,
    @ORGANIZATION_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit = 0,
    @ORGANIZATION_RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2) = 100,
    @ORGANIZATION_PRIMARYRECOGNITIONTYPECODEID uniqueidentifier = null,
    @ORGANIZATION_RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier = null
)


as

set nocount on;

/*
begin try
    -- Handle any custom "before-save" logic here
end try
begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
end catch
*/

/* invoke the default implementation */
declare @r int
exec @r = dbo.USP_DATAFORMTEMPLATE_ADD_INDIVIDUALSPOUSEBUSINESS 
  @ID = @ID output, 
  @CURRENTAPPUSERID = @CURRENTAPPUSERID, 
  @CHANGEAGENTID = @CHANGEAGENTID, 
  @LASTNAME = @LASTNAME, 
  @FIRSTNAME = @FIRSTNAME, 
  @MIDDLENAME = @MIDDLENAME, 
  @MAIDENNAME = @MAIDENNAME, 
  @NICKNAME = @NICKNAME, 
  @TITLECODEID = @TITLECODEID, 
  @SUFFIXCODEID = @SUFFIXCODEID, 
  @GENDERCODE = @GENDERCODE, 
  @BIRTHDATE = @BIRTHDATE, 
  @ADDRESS_ADDRESSTYPECODEID = @ADDRESS_ADDRESSTYPECODEID, 
  @ADDRESS_DONOTMAIL = @ADDRESS_DONOTMAIL, 
  @ADDRESS_COUNTRYID = @ADDRESS_COUNTRYID, 
  @ADDRESS_STATEID = @ADDRESS_STATEID, 
  @ADDRESS_ADDRESSBLOCK = @ADDRESS_ADDRESSBLOCK, 
  @ADDRESS_CITY = @ADDRESS_CITY, 
  @ADDRESS_POSTCODE = @ADDRESS_POSTCODE, 
  @PHONE_PHONETYPECODEID = @PHONE_PHONETYPECODEID, 
  @PHONE_NUMBER = @PHONE_NUMBER, 
  @EMAILADDRESS_EMAILADDRESSTYPECODEID = @EMAILADDRESS_EMAILADDRESSTYPECODEID, 
  @EMAILADDRESS_EMAILADDRESS = @EMAILADDRESS_EMAILADDRESS, 
  @MARITALSTATUSCODEID = @MARITALSTATUSCODEID, 
  @SKIP_ADDING_SECURITYGROUPS = @SKIP_ADDING_SECURITYGROUPS, 
  @SPOUSEID = @SPOUSEID, 
  @EXISTINGSPOUSE = @EXISTINGSPOUSE, 
  @SPOUSE_LASTNAME = @SPOUSE_LASTNAME, 
  @SPOUSE_FIRSTNAME = @SPOUSE_FIRSTNAME, 
  @SPOUSE_MIDDLENAME = @SPOUSE_MIDDLENAME, 
  @SPOUSE_MAIDENNAME = @SPOUSE_MAIDENNAME, 
  @SPOUSE_NICKNAME = @SPOUSE_NICKNAME, 
  @SPOUSE_TITLECODEID = @SPOUSE_TITLECODEID, 
  @SPOUSE_SUFFIXCODEID = @SPOUSE_SUFFIXCODEID, 
  @SPOUSE_GENDERCODE = @SPOUSE_GENDERCODE, 
  @SPOUSE_BIRTHDATE = @SPOUSE_BIRTHDATE, 
  @SPOUSE_RECIPROCALTYPECODEID = @SPOUSE_RECIPROCALTYPECODEID, 
  @SPOUSE_RELATIONSHIPTYPECODEID = @SPOUSE_RELATIONSHIPTYPECODEID, 
  @COPYPRIMARYINFORMATION = @COPYPRIMARYINFORMATION, 
  @SPOUSE_STARTDATE = @SPOUSE_STARTDATE, 
  @PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @PRIMARYSOFTCREDITRELATIONSHIPEXISTS, 
  @PRIMARYSOFTCREDITMATCHFACTOR = @PRIMARYSOFTCREDITMATCHFACTOR, 
  @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS, 
  @RECIPROCALSOFTCREDITMATCHFACTOR = @RECIPROCALSOFTCREDITMATCHFACTOR, 
  @ORGANIZATIONID = @ORGANIZATIONID, 
  @EXISTINGORGANIZATION = @EXISTINGORGANIZATION, 
  @ORGANIZATION_NAME = @ORGANIZATION_NAME, 
  @ORGANIZATION_ADDRESSTYPECODEID = @ORGANIZATION_ADDRESSTYPECODEID, 
  @ORGANIZATION_COUNTRYID = @ORGANIZATION_COUNTRYID, 
  @ORGANIZATION_STATEID = @ORGANIZATION_STATEID, 
  @ORGANIZATION_ADDRESSBLOCK = @ORGANIZATION_ADDRESSBLOCK, 
  @ORGANIZATION_CITY = @ORGANIZATION_CITY, 
  @ORGANIZATION_POSTCODE = @ORGANIZATION_POSTCODE, 
  @ORGANIZATION_DONOTMAIL = @ORGANIZATION_DONOTMAIL, 
  @ORGANIZATION_PHONETYPECODEID = @ORGANIZATION_PHONETYPECODEID, 
  @ORGANIZATION_NUMBER = @ORGANIZATION_NUMBER, 
  @ORGANIZATION_RECIPROCALTYPECODEID = @ORGANIZATION_RECIPROCALTYPECODEID, 
  @ORGANIZATION_RELATIONSHIPTYPECODEID = @ORGANIZATION_RELATIONSHIPTYPECODEID, 
  @ORGANIZATION_STARTDATE = @ORGANIZATION_STARTDATE, 
  @ORGANIZATION_ENDDATE = @ORGANIZATION_ENDDATE, 
  @ISCONTACT = @ISCONTACT, 
  @ISPRIMARYCONTACT = @ISPRIMARYCONTACT, 
  @CONTACTTYPECODEID = @CONTACTTYPECODEID, 
  @POSITION = @POSITION, 
  @ISMATCHINGGIFTRELATIONSHIP = @ISMATCHINGGIFTRELATIONSHIP, 
  @RECIPROCALRECOGNITIONTYPECODEID = @RECIPROCALRECOGNITIONTYPECODEID, 
  @PRIMARYRECOGNITIONTYPECODEID = @PRIMARYRECOGNITIONTYPECODEID, 
  @ADDRESS_OMITFROMVALIDATION = @ADDRESS_OMITFROMVALIDATION, 
  @ADDRESS_CART = @ADDRESS_CART, 
  @ADDRESS_DPC = @ADDRESS_DPC, 
  @ADDRESS_LOT = @ADDRESS_LOT, 
  @ADDRESS_COUNTYCODEID = @ADDRESS_COUNTYCODEID, 
  @ADDRESS_CONGRESSIONALDISTRICTCODEID = @ADDRESS_CONGRESSIONALDISTRICTCODEID, 
  @ADDRESS_LASTVALIDATIONATTEMPTDATE = @ADDRESS_LASTVALIDATIONATTEMPTDATE, 
  @ADDRESS_VALIDATIONMESSAGE = @ADDRESS_VALIDATIONMESSAGE, 
  @ADDRESS_CERTIFICATIONDATA = @ADDRESS_CERTIFICATIONDATA, 
  @ORGANIZATION_OMITFROMVALIDATION = @ORGANIZATION_OMITFROMVALIDATION, 
  @ORGANIZATION_CART = @ORGANIZATION_CART, 
  @ORGANIZATION_DPC = @ORGANIZATION_DPC, 
  @ORGANIZATION_LOT = @ORGANIZATION_LOT, 
  @ORGANIZATION_COUNTYCODEID = @ORGANIZATION_COUNTYCODEID, 
  @ORGANIZATION_CONGRESSIONALDISTRICTCODEID = @ORGANIZATION_CONGRESSIONALDISTRICTCODEID, 
  @ORGANIZATION_LASTVALIDATIONATTEMPTDATE = @ORGANIZATION_LASTVALIDATIONATTEMPTDATE, 
  @ORGANIZATION_VALIDATIONMESSAGE = @ORGANIZATION_VALIDATIONMESSAGE, 
  @ORGANIZATION_CERTIFICATIONDATA = @ORGANIZATION_CERTIFICATIONDATA, 
  @ISSPOUSERELATIONSHIP = @ISSPOUSERELATIONSHIP, 
  @HOUSEHOLDCOPYPRIMARYCONTACTINFO = @HOUSEHOLDCOPYPRIMARYCONTACTINFO, 
  @ADDRESS_DONOTMAILREASONCODEID = @ADDRESS_DONOTMAILREASONCODEID, 
  @ORGANIZATION_DONOTMAILREASONCODEID = @ORGANIZATION_DONOTMAILREASONCODEID, 
  @JOBCATEGORYCODEID = @JOBCATEGORYCODEID, 
  @CAREERLEVELCODEID = @CAREERLEVELCODEID, 
  @ADDRESS_INFOSOURCECODEID = @ADDRESS_INFOSOURCECODEID, 
  @ORGANIZATION_INFOSOURCECODEID = @ORGANIZATION_INFOSOURCECODEID, 
  @TITLE2CODEID = @TITLE2CODEID, 
  @SUFFIX2CODEID = @SUFFIX2CODEID, 
  @SPOUSE_TITLE2CODEID = @SPOUSE_TITLE2CODEID, 
  @SPOUSE_SUFFIX2CODEID = @SPOUSE_SUFFIX2CODEID, 
  @SKIP_ADDING_SITES = @SKIP_ADDING_SITES,
  @ORGANIZATION_PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @ORGANIZATION_PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
  @ORGANIZATION_PRIMARYSOFTCREDITMATCHFACTOR = @ORGANIZATION_PRIMARYSOFTCREDITMATCHFACTOR,
  @ORGANIZATION_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @ORGANIZATION_RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
  @ORGANIZATION_RECIPROCALSOFTCREDITMATCHFACTOR = @ORGANIZATION_RECIPROCALSOFTCREDITMATCHFACTOR,
  @ORGANIZATION_PRIMARYRECOGNITIONTYPECODEID = @ORGANIZATION_PRIMARYRECOGNITIONTYPECODEID,
  @ORGANIZATION_RECIPROCALRECOGNITIONTYPECODEID = @ORGANIZATION_RECIPROCALRECOGNITIONTYPECODEID;

if @@error <> 0 
    begin
        if @r <> 0 return @r
        return 1;
    end

/*
begin try
    -- Handle any custom "after-save" logic here 
end try
begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
end catch
*/

return @r;