USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_5

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
@INFOSOURCECOMMENTS	nvarchar(256)	IN	Comments
@COMMENTS	nvarchar(max)	IN	Comments

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_5
(
    @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,
    @INFOSOURCECOMMENTS nvarchar(256),
    @COMMENTS nvarchar(max)
)

as
    set nocount on;

    declare @RELATIONPHONEID uniqueidentifier;
    declare @ADDPHONE bit;
    declare @EDITPHONE bit;
    declare @PHONETYPECODEID uniqueidentifier;
    declare @NUMBER nvarchar(100);
    declare @PHONECOUNTRYID uniqueidentifier;
    declare @PHONESTARTTIME dbo.UDT_HOURMINUTE;
    declare @PHONEENDTIME dbo.UDT_HOURMINUTE;
    declare @PHONESTARTDATE date;
    declare @PHONEENDDATE date;
    declare @PHONEPRIMARY bit;
    declare @DONOTCALL bit;
    declare @DONOTCALLREASONCODEID uniqueidentifier;
    declare @PHONEISCONFIDENTIAL bit;
    declare @PHONEINFOSOURCECODEID uniqueidentifier;
    declare @PHONEINFOSOURCECOMMENTS nvarchar(256);
    declare @RELATIONEMAILADDRESSID uniqueidentifier;
    declare @ADDEMAILADDRESS bit;
    declare @EDITEMAILADDRESS bit;
    declare @EMAILADDRESSTYPECODEID uniqueidentifier;
    declare @EMAILADDRESS dbo.UDT_EMAILADDRESS;
    declare @EMAILADDRESSPRIMARY bit;
    declare @DONOTEMAIL bit;
    declare @EMAILADDRESSINFOSOURCECODEID uniqueidentifier;
    declare @EMAILADDRESSINFOSOURCECOMMENTS nvarchar(256);

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIP_INDTOORG_3
        @ID = @ID,
        @RELATIONPHONEID = @RELATIONPHONEID output,
        @ADDPHONE = @ADDPHONE output,
        @EDITPHONE = @EDITPHONE output,
        @PHONETYPECODEID = @PHONETYPECODEID output,
        @NUMBER = @NUMBER output,
        @PHONECOUNTRYID = @PHONECOUNTRYID output,
        @PHONESTARTTIME = @PHONESTARTTIME output,
        @PHONEENDTIME = @PHONEENDTIME output,
        @PHONESTARTDATE = @PHONESTARTDATE output,
        @PHONEENDDATE = @PHONEENDDATE output,
        @PHONEPRIMARY = @PHONEPRIMARY output,
        @DONOTCALL = @DONOTCALL output,
        @DONOTCALLREASONCODEID = @DONOTCALLREASONCODEID output,
        @PHONEISCONFIDENTIAL = @PHONEISCONFIDENTIAL output,
        @PHONEINFOSOURCECODEID = @PHONEINFOSOURCECODEID output,
        @PHONEINFOSOURCECOMMENTS = @PHONEINFOSOURCECOMMENTS output,
        @RELATIONEMAILADDRESSID = @RELATIONEMAILADDRESSID output,
        @ADDEMAILADDRESS = @ADDEMAILADDRESS output,
        @EDITEMAILADDRESS = @EDITEMAILADDRESS output,
        @EMAILADDRESSTYPECODEID = @EMAILADDRESSTYPECODEID output,
        @EMAILADDRESS = @EMAILADDRESS output,
        @EMAILADDRESSPRIMARY = @EMAILADDRESSPRIMARY output,
        @DONOTEMAIL = @DONOTEMAIL output,
        @EMAILADDRESSINFOSOURCECODEID = @EMAILADDRESSINFOSOURCECODEID output,
        @EMAILADDRESSINFOSOURCECOMMENTS = @EMAILADDRESSINFOSOURCECOMMENTS output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_6
        @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,
        @COMMENTS,
        @RELATIONPHONEID,
        @ADDPHONE,
        @EDITPHONE,
        @PHONETYPECODEID,
        @NUMBER,
        @PHONECOUNTRYID,
        @PHONESTARTTIME,
        @PHONEENDTIME,
        @PHONESTARTDATE,
        @PHONEENDDATE,
        @PHONEPRIMARY,
        @DONOTCALL,
        @DONOTCALLREASONCODEID,
        @PHONEISCONFIDENTIAL,
        @PHONEINFOSOURCECODEID,
        @PHONEINFOSOURCECOMMENTS,
        @RELATIONEMAILADDRESSID,
        @ADDEMAILADDRESS,
        @EDITEMAILADDRESS,
        @EMAILADDRESSTYPECODEID,
        @EMAILADDRESS,
        @EMAILADDRESSPRIMARY,
        @DONOTEMAIL,
        @EMAILADDRESSINFOSOURCECODEID,
        @EMAILADDRESSINFOSOURCECOMMENTS

    return 0;