USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_ORGTOIND_7

The save procedure used by the edit dataform template "Relationship Organization to Individual Edit Form 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(100)	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
@RELATIONPHONEID	uniqueidentifier	IN
@ADDPHONE	bit	IN
@EDITPHONE	bit	IN
@PHONETYPECODEID	uniqueidentifier	IN	Type
@NUMBER	nvarchar(100)	IN	Number
@PHONECOUNTRYID	uniqueidentifier	IN	Country
@PHONESTARTTIME	UDT_HOURMINUTE	IN	Call after
@PHONEENDTIME	UDT_HOURMINUTE	IN	Call before
@PHONESTARTDATE	date	IN	Start date
@PHONEENDDATE	date	IN	End date
@PHONEPRIMARY	bit	IN	Set as primary phone number
@DONOTCALL	bit	IN	Do not call this phone number
@DONOTCALLREASONCODEID	uniqueidentifier	IN	Reason
@PHONEISCONFIDENTIAL	bit	IN	This phone number is confidential
@PHONEINFOSOURCECODEID	uniqueidentifier	IN	Information source
@PHONEINFOSOURCECOMMENTS	nvarchar(256)	IN	Comments
@RELATIONEMAILADDRESSID	uniqueidentifier	IN
@ADDEMAILADDRESS	bit	IN
@EDITEMAILADDRESS	bit	IN
@EMAILADDRESSTYPECODEID	uniqueidentifier	IN	Type
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Email address
@EMAILADDRESSPRIMARY	bit	IN	Set as primary email address
@DONOTEMAIL	bit	IN	Do not send email to this address
@EMAILADDRESSINFOSOURCECODEID	uniqueidentifier	IN	Information source
@EMAILADDRESSINFOSOURCECOMMENTS	nvarchar(256)	IN	Comments
@PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply to constituent for revenue from organization
@PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition credit match percent
@RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	IN	Apply to organization for revenue from constituent
@RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN	Recognition credit match percent
@PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition credit type
@RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition credit type

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_ORGTOIND_7
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @RELATIONSHIPTYPECODEID uniqueidentifier,
    @RECIPROCALTYPECODEID uniqueidentifier,
    @RELATIONSHIPSTARTDATE datetime,
    @RELATIONSHIPENDDATE datetime,
    @ISCONTACT bit,
    @ISPRIMARYCONTACT bit,
    @CONTACTTYPECODEID uniqueidentifier,
    @POSITION nvarchar(100),
    @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),
    @RELATIONPHONEID uniqueidentifier,
    @ADDPHONE bit,
    @EDITPHONE bit,
    @PHONETYPECODEID uniqueidentifier,
    @NUMBER nvarchar(100),
    @PHONECOUNTRYID uniqueidentifier,
    @PHONESTARTTIME dbo.UDT_HOURMINUTE,
    @PHONEENDTIME dbo.UDT_HOURMINUTE,
    @PHONESTARTDATE date,
    @PHONEENDDATE date,
    @PHONEPRIMARY bit,
    @DONOTCALL bit,
    @DONOTCALLREASONCODEID uniqueidentifier,
    @PHONEISCONFIDENTIAL bit,
    @PHONEINFOSOURCECODEID uniqueidentifier,
    @PHONEINFOSOURCECOMMENTS nvarchar(256),
    @RELATIONEMAILADDRESSID uniqueidentifier,
    @ADDEMAILADDRESS bit,
    @EDITEMAILADDRESS bit,
    @EMAILADDRESSTYPECODEID uniqueidentifier,
    @EMAILADDRESS dbo.UDT_EMAILADDRESS,
    @EMAILADDRESSPRIMARY bit,
    @DONOTEMAIL bit,
    @EMAILADDRESSINFOSOURCECODEID uniqueidentifier,
    @EMAILADDRESSINFOSOURCECOMMENTS nvarchar(256),
    @PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit,
    @PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2),
    @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit,
    @RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2),
    @PRIMARYRECOGNITIONTYPECODEID uniqueidentifier,
    @RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier
)

as
    set nocount on;

    declare @SYNCENDDATETOHISTORY bit;

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

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_ORGTOIND_8
    @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,
    @PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
    @PRIMARYSOFTCREDITMATCHFACTOR,
    @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
    @RECIPROCALSOFTCREDITMATCHFACTOR,
    @PRIMARYRECOGNITIONTYPECODEID,
    @RECIPROCALRECOGNITIONTYPECODEID,
    @SYNCENDDATETOHISTORY;

    return 0;