USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_7

The save procedure used by the edit dataform template "Relationship Individual to Organization 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 dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_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 @HISTORICALSTARTDATE date;
    declare @HISTORICALENDDATE date;
    declare @EMAILSTARTDATE date;
    declare @EMAILENDDATE date;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIP_INDTOORG_3
        @ID = @ID,
        @HISTORICALSTARTDATE = @HISTORICALSTARTDATE output,
        @HISTORICALENDDATE = @HISTORICALENDDATE output,
        @EMAILSTARTDATE = @EMAILSTARTDATE output,
        @EMAILENDDATE = @EMAILENDDATE output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_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,
        @HISTORICALSTARTDATE,
        @HISTORICALENDDATE,
        @EMAILSTARTDATE,
        @EMAILENDDATE

  return 0;