USP_DATAFORMTEMPLATE_ADD_EDUINSTTOIND_RELATIONSHIP

The save procedure used by the add dataform template "Relationship Educational Institution to Individual Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@RECIPROCALCONSTITUENTID	uniqueidentifier	IN	Related individual
@RECIPROCALTYPECODEID	uniqueidentifier	IN	Individual is the
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Constituent is the
@RELATIONSHIPSTARTDATE	datetime	IN	Start date
@RELATIONSHIPENDDATE	datetime	IN	End date
@ISCONTACT	bit	IN	Individual is a contact
@ISPRIMARYCONTACT	bit	IN	Primary contact
@CONTACTTYPECODEID	uniqueidentifier	IN	Contact type
@POSITION	nvarchar(50)	IN	Job title
@ISPRIMARYBUSINESS	bit	IN	This is the primary business for the individual
@ADDADDRESS	bit	IN	Add 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(100)	IN	Validation message
@CERTIFICATIONDATA	int	IN
@DONOTMAILREASONCODEID	uniqueidentifier	IN	Reason
@JOBCATEGORYCODEID	uniqueidentifier	IN	Category
@CAREERLEVELCODEID	uniqueidentifier	IN	Career level
@REPLACERELATIONSHIP	bit	IN	This replaces the relationship with:
@REPLACEMENTRELATIONSHIPID	uniqueidentifier	IN	Replacement relationship
@INFOSOURCECOMMENTS	nvarchar(256)	IN	Comments
@COMMENTS	nvarchar(256)	IN	Comments
@JOBSCHEDULECODEID	uniqueidentifier	IN	Schedule
@JOBDEPARTMENT	nvarchar(100)	IN	Department
@JOBDIVISION	nvarchar(100)	IN	Division
@ADDPHONE	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
@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
@ADDEMAILADDRESS	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

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EDUINSTTOIND_RELATIONSHIP
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,    
                        @CONSTITUENTID uniqueidentifier,
                        @RECIPROCALCONSTITUENTID uniqueidentifier,
                        @RECIPROCALTYPECODEID uniqueidentifier,
                        @RELATIONSHIPTYPECODEID uniqueidentifier,                
                        @RELATIONSHIPSTARTDATE datetime = null,
                        @RELATIONSHIPENDDATE datetime = null,
                        @ISCONTACT bit = 0,
                        @ISPRIMARYCONTACT bit = 0,
                        @CONTACTTYPECODEID uniqueidentifier = null,
                        @POSITION nvarchar(50) = '',
                        @ISPRIMARYBUSINESS bit = 0,
                        @ADDADDRESS bit = 0,
                        @ADDRESSTYPECODEID uniqueidentifier = null,
                        @PRIMARY bit = 0,
                        @DONOTMAIL bit = 0,
                        @STARTDATE dbo.UDT_MONTHDAY = '0000',
                        @ENDDATE dbo.UDT_MONTHDAY = '0000',
                        @COUNTRYID uniqueidentifier = null,
                        @STATEID uniqueidentifier = null,
                        @ADDRESSBLOCK nvarchar(150) = '',
                        @CITY nvarchar(50) = '',
                        @POSTCODE nvarchar(12) = '',
                        @CART nvarchar(10) = '',
                        @DPC nvarchar(8) = '',
                        @LOT nvarchar(5) = '',
                        @UPDATEMATCHINGSPOUSEADDRESSES bit = 0,
                        @OMITFROMVALIDATION bit = 0,                        
                        @COUNTYCODEID uniqueidentifier = null,
                        @CONGRESSIONALDISTRICTCODEID uniqueidentifier = null,
                        @STATEHOUSEDISTRICTCODEID uniqueidentifier = null,
                        @STATESENATEDISTRICTCODEID uniqueidentifier = null,
                        @LOCALPRECINCTCODEID uniqueidentifier = null,
                        @INFOSOURCECODEID uniqueidentifier = null,
                        @REGIONCODEID uniqueidentifier = null,                    
                        @LASTVALIDATIONATTEMPTDATE datetime = null,
                        @VALIDATIONMESSAGE nvarchar(100) = '',
                        @CERTIFICATIONDATA integer = 0,
                        @DONOTMAILREASONCODEID uniqueidentifier = null,
                        @JOBCATEGORYCODEID uniqueidentifier = null,
                        @CAREERLEVELCODEID uniqueidentifier = null,
                        @REPLACERELATIONSHIP bit = 0,
                        @REPLACEMENTRELATIONSHIPID uniqueidentifier = null,
                        @INFOSOURCECOMMENTS nvarchar(256) = '',
                        @COMMENTS nvarchar(256) = '',
                        @JOBSCHEDULECODEID uniqueidentifier = null,
                        @JOBDEPARTMENT nvarchar(100) = '',
                        @JOBDIVISION nvarchar(100) = '',
                        @ADDPHONE bit = 0,
                        @PHONETYPECODEID uniqueidentifier = null,
                        @NUMBER nvarchar(100) = '',
                        @PHONECOUNTRYID uniqueidentifier = null,
                        @PHONESTARTTIME dbo.UDT_HOURMINUTE = '',
                        @PHONEENDTIME dbo.UDT_HOURMINUTE = '',
                        @PHONESTARTDATE date = null,
                        @PHONEPRIMARY bit = 0,
                        @DONOTCALL bit = 0,
                        @DONOTCALLREASONCODEID uniqueidentifier = null,
                        @PHONEISCONFIDENTIAL bit = 0,
                        @PHONEINFOSOURCECODEID uniqueidentifier = null,
                        @PHONEINFOSOURCECOMMENTS nvarchar(256) = '',
                        @ADDEMAILADDRESS bit = 0,
                        @EMAILADDRESSTYPECODEID uniqueidentifier = null,
                        @EMAILADDRESS dbo.UDT_EMAILADDRESS = '',
                        @EMAILADDRESSPRIMARY bit = 0,
                        @DONOTEMAIL bit = 0,
                        @EMAILADDRESSINFOSOURCECODEID uniqueidentifier = null,
                        @EMAILADDRESSINFOSOURCECOMMENTS nvarchar(256) = ''
                    )
                    as
                        set nocount on;

                        exec dbo.USP_DATAFORMTEMPLATE_ADD_ORGTOIND_RELATIONSHIP_2 
                            @ID,
                            @CHANGEAGENTID,
                            @CONSTITUENTID,
                            @RECIPROCALCONSTITUENTID,
                            @RECIPROCALTYPECODEID,
                            @RELATIONSHIPTYPECODEID,
                            @RELATIONSHIPSTARTDATE,
                            @RELATIONSHIPENDDATE,
                            @ISCONTACT,
                            @ISPRIMARYCONTACT,
                            @CONTACTTYPECODEID,
                            @POSITION,
                            @ISPRIMARYBUSINESS,
                            0,
                            @ADDADDRESS,
                            @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,
                            @DONOTMAILREASONCODEID,
                            @JOBCATEGORYCODEID,
                            @CAREERLEVELCODEID,
                            @REPLACERELATIONSHIP,
                            @REPLACEMENTRELATIONSHIPID,
                            @INFOSOURCECOMMENTS,
                            @COMMENTS,
                            @JOBSCHEDULECODEID,
                            @JOBDEPARTMENT,
                            @JOBDIVISION,
                            @ADDPHONE,
                            @PHONETYPECODEID,
                            @NUMBER,
                            @PHONECOUNTRYID,
                            @PHONESTARTTIME,
                            @PHONEENDTIME,
                            @PHONESTARTDATE,
                            @PHONEPRIMARY,
                            @DONOTCALL,
                            @DONOTCALLREASONCODEID,
                            @PHONEISCONFIDENTIAL,
                            @PHONEINFOSOURCECODEID,
                            @PHONEINFOSOURCECOMMENTS,
                            @ADDEMAILADDRESS,
                            @EMAILADDRESSTYPECODEID,
                            @EMAILADDRESS,
                            @EMAILADDRESSPRIMARY,
                            @DONOTEMAIL,
                            @EMAILADDRESSINFOSOURCECODEID,
                            @EMAILADDRESSINFOSOURCECOMMENTS;

                        return 0;