USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_8

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN
@RECIPROCALTYPECODEID	uniqueidentifier	IN
@RELATIONSHIPSTARTDATE	datetime	IN
@RELATIONSHIPENDDATE	datetime	IN
@ISCONTACT	bit	IN
@ISPRIMARYCONTACT	bit	IN
@CONTACTTYPECODEID	uniqueidentifier	IN
@POSITION	nvarchar(100)	IN
@ISPRIMARYBUSINESS	bit	IN
@ISMATCHINGGIFTRELATIONSHIP	bit	IN
@RELATIONADDRESSID	uniqueidentifier	IN
@ADDADDRESS	bit	IN
@EDITADDRESS	bit	IN
@ADDRESSTYPECODEID	uniqueidentifier	IN
@PRIMARY	bit	IN
@DONOTMAIL	bit	IN
@STARTDATE	UDT_MONTHDAY	IN
@ENDDATE	UDT_MONTHDAY	IN
@COUNTRYID	uniqueidentifier	IN
@STATEID	uniqueidentifier	IN
@ADDRESSBLOCK	nvarchar(150)	IN
@CITY	nvarchar(50)	IN
@POSTCODE	nvarchar(12)	IN
@CART	nvarchar(10)	IN
@DPC	nvarchar(8)	IN
@LOT	nvarchar(5)	IN
@UPDATEMATCHINGSPOUSEADDRESSES	bit	IN
@OMITFROMVALIDATION	bit	IN
@COUNTYCODEID	uniqueidentifier	IN
@CONGRESSIONALDISTRICTCODEID	uniqueidentifier	IN
@STATEHOUSEDISTRICTCODEID	uniqueidentifier	IN
@STATESENATEDISTRICTCODEID	uniqueidentifier	IN
@LOCALPRECINCTCODEID	uniqueidentifier	IN
@INFOSOURCECODEID	uniqueidentifier	IN
@REGIONCODEID	uniqueidentifier	IN
@LASTVALIDATIONATTEMPTDATE	datetime	IN
@VALIDATIONMESSAGE	nvarchar(200)	IN
@CERTIFICATIONDATA	int	IN
@UPDATECONTACTS	bit	IN
@DONOTMAILREASONCODEID	uniqueidentifier	IN
@INFOSOURCECOMMENTS	nvarchar(256)	IN
@COMMENTS	nvarchar(max)	IN
@RELATIONPHONEID	uniqueidentifier	IN
@ADDPHONE	bit	IN
@EDITPHONE	bit	IN
@PHONETYPECODEID	uniqueidentifier	IN
@NUMBER	nvarchar(100)	IN
@PHONECOUNTRYID	uniqueidentifier	IN
@PHONESTARTTIME	UDT_HOURMINUTE	IN
@PHONEENDTIME	UDT_HOURMINUTE	IN
@PHONESTARTDATE	date	IN
@PHONEENDDATE	date	IN
@PHONEPRIMARY	bit	IN
@DONOTCALL	bit	IN
@DONOTCALLREASONCODEID	uniqueidentifier	IN
@PHONEISCONFIDENTIAL	bit	IN
@PHONEINFOSOURCECODEID	uniqueidentifier	IN
@PHONEINFOSOURCECOMMENTS	nvarchar(256)	IN
@RELATIONEMAILADDRESSID	uniqueidentifier	IN
@ADDEMAILADDRESS	bit	IN
@EDITEMAILADDRESS	bit	IN
@EMAILADDRESSTYPECODEID	uniqueidentifier	IN
@EMAILADDRESS	UDT_EMAILADDRESS	IN
@EMAILADDRESSPRIMARY	bit	IN
@DONOTEMAIL	bit	IN
@EMAILADDRESSINFOSOURCECODEID	uniqueidentifier	IN
@EMAILADDRESSINFOSOURCECOMMENTS	nvarchar(256)	IN
@PRIMARYSOFTCREDITRELATIONSHIPEXISTS	bit	IN
@PRIMARYSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN
@RECIPROCALSOFTCREDITRELATIONSHIPEXISTS	bit	IN
@RECIPROCALSOFTCREDITMATCHFACTOR	decimal(5, 2)	IN
@PRIMARYRECOGNITIONTYPECODEID	uniqueidentifier	IN
@RECIPROCALRECOGNITIONTYPECODEID	uniqueidentifier	IN
@HISTORICALSTARTDATE	date	IN
@HISTORICALENDDATE	date	IN
@EMAILSTARTDATE	date	IN
@EMAILENDDATE	date	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_8
(
    @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,
    @HISTORICALSTARTDATE date,
    @HISTORICALENDDATE date,
    @EMAILSTARTDATE date,
    @EMAILENDDATE date
)

as
    set nocount on;

    declare @SYNCENDDATETOHISTORY bit;

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

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_INDTOORG_9
        @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,
        @SYNCENDDATETOHISTORY

    return 0;