USP_DATAFORMTEMPLATE_LOAD_REVENUEUPDATEBATCHCONSTITUENT

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

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.
@ISORGANIZATION	bit	INOUT	Is organization
@ISEXISTINGCONSTITUENT	bit	INOUT	Is existing constituent
@LASTNAME	nvarchar(100)	INOUT	Last name
@ORGANIZATIONNAME	nvarchar(100)	INOUT	Org name
@FIRSTNAME	nvarchar(50)	INOUT	First name
@MIDDLENAME	nvarchar(50)	INOUT	Middle name
@MAIDENNAME	nvarchar(100)	INOUT	Maiden name
@NICKNAME	nvarchar(50)	INOUT	Nickname
@TITLECODEID	nvarchar(50)	INOUT	Title
@SUFFIXCODEID	nvarchar(50)	INOUT	Suffix
@GENDERCODE	nvarchar(12)	INOUT	Gender
@BIRTHDATE	UDT_FUZZYDATE	INOUT	Birth date
@ADDRESS_ADDRESSTYPECODEID	nvarchar(50)	INOUT	Address type
@ADDRESS_DONOTMAIL	bit	INOUT	Do not send mail to this address
@ADDRESS_COUNTRYID	uniqueidentifier	INOUT	Country
@ADDRESS_COUNTRY	nvarchar(50)	INOUT	Country
@ADDRESS_STATEID	nvarchar(50)	INOUT	State
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@ADDRESS_CITY	nvarchar(50)	INOUT	City
@ADDRESS_POSTCODE	nvarchar(12)	INOUT	ZIP
@PHONE_PHONETYPECODEID	nvarchar(50)	INOUT	Phone type
@PHONE_NUMBER	nvarchar(100)	INOUT	Phone number
@EMAILADDRESS_EMAILADDRESSTYPECODEID	nvarchar(50)	INOUT	Email type
@EMAILADDRESS_EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Email address
@ORGANIZATION_ADDRESSTYPECODEID	nvarchar(50)	INOUT	Address type
@ORGANIZATION_DONOTMAIL	bit	INOUT	Do not send mail to this address
@ORGANIZATION_COUNTRYID	uniqueidentifier	INOUT	Country
@ORGANIZATION_COUNTRY	nvarchar(50)	INOUT	Country
@ORGANIZATION_STATEID	nvarchar(50)	INOUT	State
@ORGANIZATION_ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@ORGANIZATION_CITY	nvarchar(50)	INOUT	City
@ORGANIZATION_POSTCODE	nvarchar(12)	INOUT	ZIP
@ORGANIZATION_PHONETYPECODEID	nvarchar(50)	INOUT	Phone type
@ORGANIZATION_NUMBER	nvarchar(100)	INOUT	Phone number
@ORGANIZATION_EMAILADDRESSTYPECODEID	nvarchar(50)	INOUT	Email type
@ORGANIZATION_EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Email address
@MARITALSTATUS	nvarchar(50)	INOUT	Marital status
@WEBADDRESS	nvarchar(100)	INOUT	Website
@INDUSTRYCODEID	nvarchar(100)	INOUT	Industry
@NUMEMPLOYEES	int	INOUT	Number of employees
@NUMSUBSIDIARIES	int	INOUT	Number of subsidiaries
@PARENTCORPID	nvarchar(100)	INOUT	Parent org
@SPOUSEID	uniqueidentifier	INOUT	Name
@EXISTINGSPOUSE	bit	INOUT	Existing constituent
@SPOUSE_LASTNAME	nvarchar(100)	INOUT	Last name
@SPOUSE_FIRSTNAME	nvarchar(50)	INOUT	First name
@SPOUSE_MIDDLENAME	nvarchar(50)	INOUT	Middle name
@SPOUSE_MAIDENNAME	nvarchar(100)	INOUT	Maiden name
@SPOUSE_NICKNAME	nvarchar(50)	INOUT	Nickname
@SPOUSE_TITLECODEID	nvarchar(50)	INOUT	Title
@SPOUSE_SUFFIXCODEID	nvarchar(50)	INOUT	Suffix
@SPOUSE_GENDERCODE	nvarchar(50)	INOUT	Gender
@SPOUSE_BIRTHDATE	UDT_FUZZYDATE	INOUT	Birth date
@SPOUSE_RECIPROCALTYPECODEID	nvarchar(50)	INOUT	Reciprocal relationship type
@SPOUSE_RELATIONSHIPTYPECODEID	nvarchar(50)	INOUT	Relationship type
@COPYPRIMARYINFORMATION	bit	INOUT	Copy primary information
@SPOUSE_STARTDATE	datetime	INOUT	Start date
@PRIMARYRELATIONSHIPEXISTS	bit	INOUT	Apply recognition credit to individual for constituent's payments
@PRIMARYMATCHFACTOR	decimal(5, 2)	INOUT	Recognition credit match percentage
@RECIPROCALRELATIONSHIPEXISTS	bit	INOUT	Apply recognition credit to constituent for individual's payments
@RECIPROCALMATCHFACTOR	decimal(5, 2)	INOUT	Reciprocal recognition credit match percentage
@BUSINESSID	uniqueidentifier	INOUT	Org name
@EXISTINGBUSINESS	bit	INOUT	Existing constituent
@BUSINESS_NAME	nvarchar(100)	INOUT	Org name
@BUSINESS_ADDRESSTYPECODEID	nvarchar(50)	INOUT	Address type
@BUSINESS_COUNTRYID	uniqueidentifier	INOUT	Country
@BUSINESS_COUNTRY	nvarchar(50)	INOUT	Country
@BUSINESS_STATEID	nvarchar(50)	INOUT	State
@BUSINESS_ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@BUSINESS_CITY	nvarchar(50)	INOUT	City
@BUSINESS_POSTCODE	nvarchar(12)	INOUT	ZIP
@BUSINESS_DONOTMAIL	bit	INOUT	Do not send mail to this address
@BUSINESS_PHONETYPECODEID	nvarchar(50)	INOUT	Phone type
@BUSINESS_NUMBER	nvarchar(100)	INOUT	Phone number
@BUSINESS_RECIPROCALTYPECODEID	nvarchar(50)	INOUT	Reciprocal relationship type
@BUSINESS_RELATIONSHIPTYPECODEID	nvarchar(50)	INOUT	Relationship type
@BUSINESS_STARTDATE	datetime	INOUT	Start date
@ISCONTACT	bit	INOUT	Is contact
@ISPRIMARYCONTACT	bit	INOUT	Is primary contact
@CONTACTTYPECODEID	nvarchar(50)	INOUT	Contact type
@POSITION	nvarchar(100)	INOUT	Job title
@ISMATCHINGGIFTRELATIONSHIP	bit	INOUT	Matching gift relationship
@INDIVIDUALSHOUSEHOLDNAME	nvarchar(100)	INOUT	Household name
@ISGROUP	bit	INOUT	Is group
@GROUP_NAME	nvarchar(100)	INOUT	Group name
@GROUP_TYPE	nvarchar(150)	INOUT	Group type
@GROUP_NUMBERMEMBERS	int	INOUT	No. of members
@GROUP_PRIMARYCONTACT	nvarchar(154)	INOUT	Primary contact
@GROUP_ADDRESSTYPECODEID	nvarchar(50)	INOUT	Address type
@GROUP_COUNTRYID	uniqueidentifier	INOUT	Country
@GROUP_COUNTRY	nvarchar(50)	INOUT	Country
@GROUP_STATEID	nvarchar(50)	INOUT	State
@GROUP_ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@GROUP_CITY	nvarchar(50)	INOUT	City
@GROUP_POSTCODE	nvarchar(12)	INOUT	ZIP
@GROUP_PHONETYPECODEID	nvarchar(50)	INOUT	Phone type
@GROUP_NUMBER	nvarchar(100)	INOUT	Phone number
@GROUP_EMAILADDRESSTYPECODEID	nvarchar(50)	INOUT	Email type
@GROUP_EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Email address
@ISHOUSEHOLD	bit	INOUT	Is household
@HOUSEHOLD_NAME	nvarchar(100)	INOUT	Household name
@HOUSEHOLD_NUMBERMEMBERS	int	INOUT	No. of members
@HOUSEHOLD_PRIMARYCONTACT	nvarchar(154)	INOUT	Primary contact
@HOUSEHOLD_MEMBERS	xml	INOUT	Members
@HOUSEHOLD_ADDRESSTYPECODEID	nvarchar(50)	INOUT	Address type
@HOUSEHOLD_COUNTRYID	uniqueidentifier	INOUT	Country
@HOUSEHOLD_COUNTRY	nvarchar(50)	INOUT	Country
@HOUSEHOLD_STATEID	nvarchar(50)	INOUT	State
@HOUSEHOLD_ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@HOUSEHOLD_CITY	nvarchar(50)	INOUT	City
@HOUSEHOLD_POSTCODE	nvarchar(12)	INOUT	ZIP
@HOUSEHOLD_PHONETYPECODEID	nvarchar(50)	INOUT	Phone type
@HOUSEHOLD_NUMBER	nvarchar(100)	INOUT	Phone number
@HOUSEHOLD_EMAILADDRESSTYPECODEID	nvarchar(50)	INOUT	Email type
@HOUSEHOLD_EMAILADDRESS	UDT_EMAILADDRESS	INOUT	Email address
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent ID
@APPLICATIONS	xml	INOUT	Applications
@BALANCE	money	INOUT	Balance (gift amount)
@EXISTINGTAXDECLARATIONS	xml	INOUT	Existing declarations
@NEWTAXDECLARATIONS	xml	INOUT	New declarations
@JOBCATEGORYCODEID	nvarchar(50)	INOUT	Category
@CAREERLEVELCODEID	nvarchar(50)	INOUT	Career level
@MATCHINGGIFTS	xml	INOUT	Matching gifts
@GENDERCODEID	nvarchar(50)	INOUT
@SPOUSE_GENDERCODEID	nvarchar(50)	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_LOAD_REVENUEUPDATEBATCHCONSTITUENT
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ISORGANIZATION bit = null output,
    @ISEXISTINGCONSTITUENT bit = null output,
    @LASTNAME nvarchar(100) = null output,
    @ORGANIZATIONNAME nvarchar(100) = null output,
    @FIRSTNAME nvarchar(50) = null output,
    @MIDDLENAME nvarchar(50) = null output,
    @MAIDENNAME nvarchar(100) = null output,
    @NICKNAME nvarchar(50) = null output,
    @TITLECODEID nvarchar(50) = null output,
    @SUFFIXCODEID nvarchar(50) = null output,
    @GENDERCODE nvarchar(12) = null output,
    @BIRTHDATE dbo.UDT_FUZZYDATE = null output,
    @ADDRESS_ADDRESSTYPECODEID nvarchar(50) = null output,
    @ADDRESS_DONOTMAIL bit = null output,
    @ADDRESS_COUNTRYID uniqueidentifier = null output,
    @ADDRESS_COUNTRY nvarchar(50) = null output,
    @ADDRESS_STATEID nvarchar(50) = null output,
    @ADDRESS_ADDRESSBLOCK nvarchar(150) = null output,
    @ADDRESS_CITY nvarchar(50) = null output,
    @ADDRESS_POSTCODE nvarchar(12) = null output,
    @PHONE_PHONETYPECODEID nvarchar(50) = null output,
    @PHONE_NUMBER nvarchar(100) = null output,
    @EMAILADDRESS_EMAILADDRESSTYPECODEID nvarchar(50) = null output,
    @EMAILADDRESS_EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
    @ORGANIZATION_ADDRESSTYPECODEID nvarchar(50) = null output,
    @ORGANIZATION_DONOTMAIL bit = null output,
    @ORGANIZATION_COUNTRYID uniqueidentifier = null output,
    @ORGANIZATION_COUNTRY nvarchar(50) = null output,
    @ORGANIZATION_STATEID nvarchar(50) = null output,
    @ORGANIZATION_ADDRESSBLOCK nvarchar(150) = null output,
    @ORGANIZATION_CITY nvarchar(50) = null output,
    @ORGANIZATION_POSTCODE nvarchar(12) = null output,
    @ORGANIZATION_PHONETYPECODEID nvarchar(50) = null output,
    @ORGANIZATION_NUMBER nvarchar(100) = null output,
    @ORGANIZATION_EMAILADDRESSTYPECODEID nvarchar(50) = null output,
    @ORGANIZATION_EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,
    @MARITALSTATUS nvarchar(50) = null output,
    @WEBADDRESS nvarchar(100) = null output,
    @INDUSTRYCODEID nvarchar(100) = null output,
    @NUMEMPLOYEES int = null output,
    @NUMSUBSIDIARIES int = null output,
    @PARENTCORPID nvarchar(100) = null output,

    --Individual's Household Variables

    @SPOUSEID uniqueidentifier = null output,
    @EXISTINGSPOUSE bit = null output,
    @SPOUSE_LASTNAME nvarchar(100) = null output,
    @SPOUSE_FIRSTNAME nvarchar(50) = null output,
    @SPOUSE_MIDDLENAME nvarchar(50) = null output,
    @SPOUSE_MAIDENNAME nvarchar(100) = null output,
    @SPOUSE_NICKNAME nvarchar(50) = null output,
    @SPOUSE_TITLECODEID nvarchar(50) = null output,
    @SPOUSE_SUFFIXCODEID nvarchar(50) = null output,
    @SPOUSE_GENDERCODE nvarchar(50) = null output,
    @SPOUSE_BIRTHDATE dbo.UDT_FUZZYDATE = null output,
    @SPOUSE_RECIPROCALTYPECODEID nvarchar(50) = null output,
    @SPOUSE_RELATIONSHIPTYPECODEID nvarchar(50) = null output,
    @COPYPRIMARYINFORMATION bit = null output,
    @SPOUSE_STARTDATE datetime = null output,
    @PRIMARYRELATIONSHIPEXISTS bit = null output,
    @PRIMARYMATCHFACTOR decimal(5,2) = null output,
    @RECIPROCALRELATIONSHIPEXISTS bit = null output,
    @RECIPROCALMATCHFACTOR decimal(5,2) = null output,

    --Organization variables

    @BUSINESSID uniqueidentifier = null output,
    @EXISTINGBUSINESS bit = null output,
    @BUSINESS_NAME nvarchar(100) = null output,
    @BUSINESS_ADDRESSTYPECODEID nvarchar(50) = null output,
    @BUSINESS_COUNTRYID uniqueidentifier = null output,
    @BUSINESS_COUNTRY nvarchar(50) = null output,
    @BUSINESS_STATEID nvarchar(50) = null output,
    @BUSINESS_ADDRESSBLOCK nvarchar(150) = null output,
    @BUSINESS_CITY nvarchar(50) = null output,
    @BUSINESS_POSTCODE nvarchar(12) = null output,
    @BUSINESS_DONOTMAIL bit = null output,
    @BUSINESS_PHONETYPECODEID nvarchar(50) = null output,
    @BUSINESS_NUMBER nvarchar(100) = null output,
    @BUSINESS_RECIPROCALTYPECODEID nvarchar(50) = null output,
    @BUSINESS_RELATIONSHIPTYPECODEID nvarchar(50) = null output,
    @BUSINESS_STARTDATE datetime = null output,                        
    @ISCONTACT bit = null output,
    @ISPRIMARYCONTACT bit = null output,
    @CONTACTTYPECODEID nvarchar(50) = null output,
    @POSITION nvarchar(100) = null output,
    @ISMATCHINGGIFTRELATIONSHIP bit = null output,

    -- Individual's household variables continued

    @INDIVIDUALSHOUSEHOLDNAME nvarchar(100) = null output,

    --Group variables

    @ISGROUP bit = null output,
    @GROUP_NAME nvarchar(100) = null output,
    @GROUP_TYPE nvarchar(150) = null output,
    @GROUP_NUMBERMEMBERS int = null output,
    @GROUP_PRIMARYCONTACT nvarchar(154) = null output,
    @GROUP_ADDRESSTYPECODEID nvarchar(50) = null output,
    @GROUP_COUNTRYID uniqueidentifier = null output,
    @GROUP_COUNTRY nvarchar(50) = null output,
    @GROUP_STATEID nvarchar(50) = null output,
    @GROUP_ADDRESSBLOCK nvarchar(150) = null output,
    @GROUP_CITY nvarchar(50) = null output,
    @GROUP_POSTCODE nvarchar(12) = null output,
    @GROUP_PHONETYPECODEID nvarchar(50) = null output,
    @GROUP_NUMBER nvarchar(100) = null output,
    @GROUP_EMAILADDRESSTYPECODEID nvarchar(50) = null output,
    @GROUP_EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,

    --Household variables

    @ISHOUSEHOLD bit = null output,
    @HOUSEHOLD_NAME nvarchar(100) = null output,
    @HOUSEHOLD_NUMBERMEMBERS int = null output,
    @HOUSEHOLD_PRIMARYCONTACT nvarchar(154) = null output,
    @HOUSEHOLD_MEMBERS xml = null output,
    @HOUSEHOLD_ADDRESSTYPECODEID nvarchar(50) = null output,
    @HOUSEHOLD_COUNTRYID uniqueidentifier = null output,
    @HOUSEHOLD_COUNTRY nvarchar(50) = null output,
    @HOUSEHOLD_STATEID nvarchar(50) = null output,
    @HOUSEHOLD_ADDRESSBLOCK nvarchar(150) = null output,
    @HOUSEHOLD_CITY nvarchar(50) = null output,
    @HOUSEHOLD_POSTCODE nvarchar(12) = null output,
    @HOUSEHOLD_PHONETYPECODEID nvarchar(50) = null output,
    @HOUSEHOLD_NUMBER nvarchar(100) = null output,
    @HOUSEHOLD_EMAILADDRESSTYPECODEID nvarchar(50) = null output,
    @HOUSEHOLD_EMAILADDRESS dbo.UDT_EMAILADDRESS = null output,

    @CURRENTAPPUSERID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier = null output,
    @APPLICATIONS xml = null output,
    @BALANCE money = null output,
    @EXISTINGTAXDECLARATIONS xml = null output,
    @NEWTAXDECLARATIONS xml = null output,
    @JOBCATEGORYCODEID nvarchar(50) = null output,
    @CAREERLEVELCODEID nvarchar(50) = null output,
    @MATCHINGGIFTS xml = null output,
    @GENDERCODEID nvarchar(50) = null output,
    @SPOUSE_GENDERCODEID nvarchar(50) = null output
)
as
    set nocount on;

    begin try
        exec dbo.USP_DATAFORMTEMPLATE_LOAD_REVENUEBATCHCONSTITUENT_2
            @ID = @ID,
            @DATALOADED = @DATALOADED output,
            @ISORGANIZATION = @ISORGANIZATION output,
            @ISEXISTINGCONSTITUENT = @ISEXISTINGCONSTITUENT output,
            @LASTNAME = @LASTNAME output,
            @ORGANIZATIONNAME = @ORGANIZATIONNAME output,
            @FIRSTNAME = @FIRSTNAME output,
            @MIDDLENAME = @MIDDLENAME output,
            @MAIDENNAME = @MAIDENNAME output,
            @NICKNAME = @NICKNAME output,
            @TITLECODEID = @TITLECODEID output,
            @SUFFIXCODEID = @SUFFIXCODEID output,
            @GENDERCODE = @GENDERCODE output,
            @BIRTHDATE = @BIRTHDATE output,
            @ADDRESS_ADDRESSTYPECODEID = @ADDRESS_ADDRESSTYPECODEID output,
            @ADDRESS_DONOTMAIL = @ADDRESS_DONOTMAIL output,
            @ADDRESS_COUNTRYID = @ADDRESS_COUNTRYID output,
            @ADDRESS_COUNTRY = @ADDRESS_COUNTRY output,
            @ADDRESS_STATEID = @ADDRESS_STATEID output,
            @ADDRESS_ADDRESSBLOCK = @ADDRESS_ADDRESSBLOCK output,
            @ADDRESS_CITY = @ADDRESS_CITY output,
            @ADDRESS_POSTCODE = @ADDRESS_POSTCODE output,
            @PHONE_PHONETYPECODEID = @PHONE_PHONETYPECODEID output,
            @PHONE_NUMBER = @PHONE_NUMBER output,
            @EMAILADDRESS_EMAILADDRESSTYPECODEID = @EMAILADDRESS_EMAILADDRESSTYPECODEID output,
            @EMAILADDRESS_EMAILADDRESS = @EMAILADDRESS_EMAILADDRESS output,
            @ORGANIZATION_ADDRESSTYPECODEID = @ORGANIZATION_ADDRESSTYPECODEID output,
            @ORGANIZATION_DONOTMAIL = @ORGANIZATION_DONOTMAIL output,
            @ORGANIZATION_COUNTRYID = @ORGANIZATION_COUNTRYID output,
            @ORGANIZATION_COUNTRY = @ORGANIZATION_COUNTRY output,
            @ORGANIZATION_STATEID = @ORGANIZATION_STATEID output,
            @ORGANIZATION_ADDRESSBLOCK = @ORGANIZATION_ADDRESSBLOCK output,
            @ORGANIZATION_CITY = @ORGANIZATION_CITY output,
            @ORGANIZATION_POSTCODE = @ORGANIZATION_POSTCODE output,
            @ORGANIZATION_PHONETYPECODEID = @ORGANIZATION_PHONETYPECODEID output,
            @ORGANIZATION_NUMBER = @ORGANIZATION_NUMBER output,
            @ORGANIZATION_EMAILADDRESSTYPECODEID = @ORGANIZATION_EMAILADDRESSTYPECODEID output,
            @ORGANIZATION_EMAILADDRESS = @ORGANIZATION_EMAILADDRESS output,
            @MARITALSTATUS = @MARITALSTATUS output,
            @WEBADDRESS = @WEBADDRESS output,
            @INDUSTRYCODEID = @INDUSTRYCODEID output,
            @NUMEMPLOYEES = @NUMEMPLOYEES output,
            @NUMSUBSIDIARIES = @NUMSUBSIDIARIES output,
            @PARENTCORPID = @PARENTCORPID output,

            --Individual's Household Variables

            @SPOUSEID = @SPOUSEID output,
            @EXISTINGSPOUSE = @EXISTINGSPOUSE output,
            @SPOUSE_LASTNAME = @SPOUSE_LASTNAME output,
            @SPOUSE_FIRSTNAME = @SPOUSE_FIRSTNAME output,
            @SPOUSE_MIDDLENAME = @SPOUSE_MIDDLENAME output,
            @SPOUSE_MAIDENNAME = @SPOUSE_MAIDENNAME output,
            @SPOUSE_NICKNAME = @SPOUSE_NICKNAME output,
            @SPOUSE_TITLECODEID = @SPOUSE_TITLECODEID output,
            @SPOUSE_SUFFIXCODEID = @SPOUSE_SUFFIXCODEID output,
            @SPOUSE_GENDERCODE = @SPOUSE_GENDERCODE output,
            @SPOUSE_BIRTHDATE = @SPOUSE_BIRTHDATE output,
            @SPOUSE_RECIPROCALTYPECODEID = @SPOUSE_RECIPROCALTYPECODEID output,
            @SPOUSE_RELATIONSHIPTYPECODEID = @SPOUSE_RELATIONSHIPTYPECODEID output,
            @COPYPRIMARYINFORMATION = @COPYPRIMARYINFORMATION output,
            @SPOUSE_STARTDATE = @SPOUSE_STARTDATE output,
            @PRIMARYRELATIONSHIPEXISTS = @PRIMARYRELATIONSHIPEXISTS output,
            @PRIMARYMATCHFACTOR = @PRIMARYMATCHFACTOR output,
            @RECIPROCALRELATIONSHIPEXISTS = @RECIPROCALRELATIONSHIPEXISTS output,
            @RECIPROCALMATCHFACTOR = @RECIPROCALMATCHFACTOR output,

            --Organization variables

            @BUSINESSID = @BUSINESSID output,
            @EXISTINGBUSINESS = @EXISTINGBUSINESS output,
            @BUSINESS_NAME = @BUSINESS_NAME output,
            @BUSINESS_ADDRESSTYPECODEID = @BUSINESS_ADDRESSTYPECODEID output,
            @BUSINESS_COUNTRYID = @BUSINESS_COUNTRYID output,
            @BUSINESS_COUNTRY = @BUSINESS_COUNTRY output,
            @BUSINESS_STATEID = @BUSINESS_STATEID output,
            @BUSINESS_ADDRESSBLOCK = @BUSINESS_ADDRESSBLOCK output,
            @BUSINESS_CITY = @BUSINESS_CITY output,
            @BUSINESS_POSTCODE = @BUSINESS_POSTCODE output,
            @BUSINESS_DONOTMAIL = @BUSINESS_DONOTMAIL output,
            @BUSINESS_PHONETYPECODEID = @BUSINESS_PHONETYPECODEID output,
            @BUSINESS_NUMBER = @BUSINESS_NUMBER output,
            @BUSINESS_RECIPROCALTYPECODEID = @BUSINESS_RECIPROCALTYPECODEID output,
            @BUSINESS_RELATIONSHIPTYPECODEID = @BUSINESS_RELATIONSHIPTYPECODEID output,
            @BUSINESS_STARTDATE = @BUSINESS_STARTDATE output,                        
            @ISCONTACT = @ISCONTACT output,
            @ISPRIMARYCONTACT = @ISPRIMARYCONTACT output,
            @CONTACTTYPECODEID = @CONTACTTYPECODEID output,
            @POSITION = @POSITION output,
            @ISMATCHINGGIFTRELATIONSHIP = @ISMATCHINGGIFTRELATIONSHIP output,

            -- Individual's household variables continued

            @INDIVIDUALSHOUSEHOLDNAME = @INDIVIDUALSHOUSEHOLDNAME output,

            --Group variables

            @ISGROUP = @ISGROUP output,
            @GROUP_NAME = @GROUP_NAME output,
            @GROUP_TYPE = @GROUP_TYPE output,
            @GROUP_NUMBERMEMBERS = @GROUP_NUMBERMEMBERS output,
            @GROUP_PRIMARYCONTACT = @GROUP_PRIMARYCONTACT output,
            @GROUP_ADDRESSTYPECODEID = @GROUP_ADDRESSTYPECODEID output,
            @GROUP_COUNTRYID = @GROUP_COUNTRYID output,
            @GROUP_COUNTRY = @GROUP_COUNTRY output,
            @GROUP_STATEID = @GROUP_STATEID output,
            @GROUP_ADDRESSBLOCK = @GROUP_ADDRESSBLOCK output,
            @GROUP_CITY = @GROUP_CITY output,
            @GROUP_POSTCODE = @GROUP_POSTCODE output,
            @GROUP_PHONETYPECODEID = @GROUP_PHONETYPECODEID output,
            @GROUP_NUMBER = @GROUP_NUMBER output,
            @GROUP_EMAILADDRESSTYPECODEID = @GROUP_EMAILADDRESSTYPECODEID output,
            @GROUP_EMAILADDRESS = @GROUP_EMAILADDRESS output,

            --Household variables

            @ISHOUSEHOLD = @ISHOUSEHOLD output,
            @HOUSEHOLD_NAME = @HOUSEHOLD_NAME output,
            @HOUSEHOLD_NUMBERMEMBERS = @HOUSEHOLD_NUMBERMEMBERS output,
            @HOUSEHOLD_PRIMARYCONTACT = @HOUSEHOLD_PRIMARYCONTACT output,
            @HOUSEHOLD_MEMBERS = @HOUSEHOLD_MEMBERS output,
            @HOUSEHOLD_ADDRESSTYPECODEID = @HOUSEHOLD_ADDRESSTYPECODEID output,
            @HOUSEHOLD_COUNTRYID = @HOUSEHOLD_COUNTRYID output,
            @HOUSEHOLD_COUNTRY = @HOUSEHOLD_COUNTRY output,
            @HOUSEHOLD_STATEID = @HOUSEHOLD_STATEID output,
            @HOUSEHOLD_ADDRESSBLOCK = @HOUSEHOLD_ADDRESSBLOCK output,
            @HOUSEHOLD_CITY = @HOUSEHOLD_CITY output,
            @HOUSEHOLD_POSTCODE = @HOUSEHOLD_POSTCODE output,
            @HOUSEHOLD_PHONETYPECODEID = @HOUSEHOLD_PHONETYPECODEID output,
            @HOUSEHOLD_NUMBER = @HOUSEHOLD_NUMBER output,
            @HOUSEHOLD_EMAILADDRESSTYPECODEID = @HOUSEHOLD_EMAILADDRESSTYPECODEID output,
            @HOUSEHOLD_EMAILADDRESS = @HOUSEHOLD_EMAILADDRESS output,
            @CURRENTAPPUSERID = @CURRENTAPPUSERID,
            @CONSTITUENTID = @CONSTITUENTID output,
            @APPLICATIONS = @APPLICATIONS output,
            @BALANCE = @BALANCE output,
            @JOBCATEGORYCODEID = @JOBCATEGORYCODEID output,
            @CAREERLEVELCODEID = @CAREERLEVELCODEID output,
            @MATCHINGGIFTS = @MATCHINGGIFTS output,
            @GENDERCODEID = @GENDERCODEID output,
            @SPOUSE_GENDERCODEID = @SPOUSE_GENDERCODEID output

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

    return 0;