USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_ORGTOIND_3

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@RELATIONSHIPSTARTDATE	datetime	IN	Start date
@RELATIONSHIPENDDATE	datetime	IN	End date
@ISCONTACT	bit	IN	The individual is a contact for this organization
@ISPRIMARYCONTACT	bit	IN	Primary contact
@CONTACTTYPECODEID	uniqueidentifier	IN	Contact type
@POSITION	nvarchar(50)	IN	Position
@ISPRIMARYBUSINESS	bit	IN	This is the primary business
@ISMATCHINGGIFTRELATIONSHIP	bit	IN	The organization will match contributions for this relationship
@RELATIONADDRESSID	uniqueidentifier	IN	Address ID
@ADDADDRESS	bit	IN	Add Address
@EDITADDRESS	bit	IN	Edit Address
@ADDRESSTYPECODEID	uniqueidentifier	IN	Type
@PRIMARY	bit	IN	Set as primary address
@DONOTMAIL	bit	IN	Do not send mail to this address
@STARTDATE	UDT_MONTHDAY	IN	Start date
@ENDDATE	UDT_MONTHDAY	IN	End date
@COUNTRYID	uniqueidentifier	IN	Country
@STATEID	uniqueidentifier	IN	State
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@CITY	nvarchar(50)	IN	City
@POSTCODE	nvarchar(12)	IN	ZIP
@CART	nvarchar(10)	IN	CART
@DPC	nvarchar(8)	IN	DPC
@LOT	nvarchar(5)	IN	LOT
@UPDATEMATCHINGSPOUSEADDRESSES	bit	IN	Update matching address information for spouse
@OMITFROMVALIDATION	bit	IN	Omit this address from validation
@COUNTYCODEID	uniqueidentifier	IN	County
@CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN	Congressional district
@STATEHOUSEDISTRICTCODEID	uniqueidentifier	IN	State house district
@STATESENATEDISTRICTCODEID	uniqueidentifier	IN	State senate district
@LOCALPRECINCTCODEID	uniqueidentifier	IN	Local precinct
@INFOSOURCECODEID	uniqueidentifier	IN	Info source
@REGIONCODEID	uniqueidentifier	IN	Region
@LASTVALIDATIONATTEMPTDATE	datetime	IN	Last attempt
@VALIDATIONMESSAGE	nvarchar(200)	IN	Validation message
@CERTIFICATIONDATA	int	IN
@UPDATECONTACTS	bit	IN	Update contacts that use this address
@DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_ORGTOIND_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @RELATIONSHIPTYPECODEID uniqueidentifier,
    @RECIPROCALTYPECODEID uniqueidentifier,
    @RELATIONSHIPSTARTDATE datetime,
    @RELATIONSHIPENDDATE datetime,
    @ISCONTACT bit,
    @ISPRIMARYCONTACT bit,
    @CONTACTTYPECODEID uniqueidentifier,
    @POSITION nvarchar(50),
    @ISPRIMARYBUSINESS bit,
    @ISMATCHINGGIFTRELATIONSHIP bit,
    @RELATIONADDRESSID uniqueidentifier,
    @ADDADDRESS bit,
    @EDITADDRESS bit,
    @ADDRESSTYPECODEID uniqueidentifier,
    @PRIMARY bit,
    @DONOTMAIL bit,
    @STARTDATE dbo.UDT_MONTHDAY,
    @ENDDATE dbo.UDT_MONTHDAY,
    @COUNTRYID uniqueidentifier,
    @STATEID uniqueidentifier,
    @ADDRESSBLOCK nvarchar(150),
    @CITY nvarchar(50),
    @POSTCODE nvarchar(12),
    @CART nvarchar(10),
    @DPC nvarchar(8),
    @LOT nvarchar(5),
    @UPDATEMATCHINGSPOUSEADDRESSES bit,
    @OMITFROMVALIDATION bit,                    
    @COUNTYCODEID uniqueidentifier,
    @CONGRESSIONALDISTRICTCODEID uniqueidentifier,
    @STATEHOUSEDISTRICTCODEID uniqueidentifier,
    @STATESENATEDISTRICTCODEID uniqueidentifier,
    @LOCALPRECINCTCODEID uniqueidentifier,
    @INFOSOURCECODEID uniqueidentifier,
    @REGIONCODEID uniqueidentifier,                    
    @LASTVALIDATIONATTEMPTDATE datetime,
    @VALIDATIONMESSAGE nvarchar(200),
    @CERTIFICATIONDATA integer,
    @UPDATECONTACTS bit,
    @DONOTMAILREASONCODEID uniqueidentifier
)
as
    set nocount on;

    declare @INFOSOURCECOMMENTS nvarchar(256);

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIP_ORGTOIND_3 
        @ID = @ID,
        @INFOSOURCECOMMENTS = @INFOSOURCECOMMENTS output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_ORGTOIND_4 @ID, @CHANGEAGENTID, @RELATIONSHIPTYPECODEID, @RECIPROCALTYPECODEID,
        @RELATIONSHIPSTARTDATE, @RELATIONSHIPENDDATE, @ISCONTACT, @ISPRIMARYCONTACT, @CONTACTTYPECODEID, @POSITION,
        @ISPRIMARYBUSINESS, @ISMATCHINGGIFTRELATIONSHIP, @RELATIONADDRESSID, @ADDADDRESS, @EDITADDRESS, @ADDRESSTYPECODEID,
        @PRIMARY, @DONOTMAIL, @STARTDATE, @ENDDATE, @COUNTRYID, @STATEID, @ADDRESSBLOCK, @CITY, @POSTCODE, @CART,
        @DPC, @LOT, @UPDATEMATCHINGSPOUSEADDRESSES, @OMITFROMVALIDATION, @COUNTYCODEID, @CONGRESSIONALDISTRICTCODEID,
        @STATEHOUSEDISTRICTCODEID, @STATESENATEDISTRICTCODEID, @LOCALPRECINCTCODEID, @INFOSOURCECODEID, @REGIONCODEID,
        @LASTVALIDATIONATTEMPTDATE, @VALIDATIONMESSAGE, @CERTIFICATIONDATA, @UPDATECONTACTS, @DONOTMAILREASONCODEID,
        @INFOSOURCECOMMENTS;

    return 0;