USP_DATAFORMTEMPLATE_EDIT_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIP_CONSTITFROMEXEC

The save procedure used by the edit dataform template "Prospect Quick Search Business Ownership Constit From Exec Edit Data Form".

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.
@BUSINESSOPTIONCODE	tinyint	IN	For organization:
@BUSINESSID	uniqueidentifier	IN	Organization
@BUSINESSRELATIONSHIPTYPECODEID	uniqueidentifier	IN	Individual is the
@BUSINESSRECIPROCALTYPECODEID	uniqueidentifier	IN	Organization is the
@ADDRESSTYPECODE	tinyint	IN	Address to use
@LASTNAME	nvarchar(50)	IN	Last name
@FIRSTNAME	nvarchar(50)	IN	First name
@MIDDLENAME	nvarchar(50)	IN	Middle name
@PREFIXCODEID	uniqueidentifier	IN	Prefix
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@TITLE	nvarchar(30)	IN	Title
@YEAROFBIRTH	UDT_YEAR	IN	Year of birth
@GENDERCODE	tinyint	IN	Gender
@BUSINESSNAME	nvarchar(30)	IN	Name
@BUSINESS_COUNTRYID	uniqueidentifier	IN	Business country
@BUSINESS_ADDRESSBLOCK	nvarchar(100)	IN	Business address
@BUSINESS_CITY	nvarchar(50)	IN	Business city
@BUSINESS_STATEID	uniqueidentifier	IN	Business state
@BUSINESS_POSTCODE	nvarchar(10)	IN	Business zip
@MAILING_COUNTRYID	uniqueidentifier	IN	Mailing country
@MAILING_ADDRESSBLOCK	nvarchar(100)	IN	Mailing address
@MAILING_CITY	nvarchar(50)	IN	Mailing city
@MAILING_STATEID	uniqueidentifier	IN	Mailing state
@MAILING_POSTCODE	nvarchar(10)	IN	Mailing zip
@EXECUTIVE_COUNTRYID	uniqueidentifier	IN	Executive country
@EXECUTIVE_ADDRESSBLOCK	nvarchar(100)	IN	Executive address
@EXECUTIVE_CITY	nvarchar(50)	IN	Executive city
@EXECUTIVE_STATEID	uniqueidentifier	IN	Executive state
@EXECUTIVE_POSTCODE	nvarchar(10)	IN	Executive zip
@BUSINESS_PHONE	nvarchar(20)	IN	Phone
@ADDRESS_INFOSOURCECODEID	uniqueidentifier	IN	Information source

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIP_CONSTITFROMEXEC (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @BUSINESSOPTIONCODE tinyint,
                        @BUSINESSID uniqueidentifier,
                        @BUSINESSRELATIONSHIPTYPECODEID uniqueidentifier,
                        @BUSINESSRECIPROCALTYPECODEID uniqueidentifier,
                        @ADDRESSTYPECODE tinyint,
                        @LASTNAME nvarchar(50),
                        @FIRSTNAME nvarchar(50),
                        @MIDDLENAME nvarchar(50),
                        @PREFIXCODEID uniqueidentifier,
                        @SUFFIXCODEID uniqueidentifier,
                        @TITLE nvarchar(30),
                        @YEAROFBIRTH dbo.UDT_YEAR,
                        @GENDERCODE tinyint,
                        @BUSINESSNAME nvarchar(30),
                        @BUSINESS_COUNTRYID uniqueidentifier ,
                        @BUSINESS_ADDRESSBLOCK nvarchar(100),
                        @BUSINESS_CITY nvarchar(50),
                        @BUSINESS_STATEID uniqueidentifier,
                        @BUSINESS_POSTCODE nvarchar(10),
                        @MAILING_COUNTRYID uniqueidentifier ,
                        @MAILING_ADDRESSBLOCK nvarchar(100),
                        @MAILING_CITY nvarchar(50),
                        @MAILING_STATEID uniqueidentifier,
                        @MAILING_POSTCODE nvarchar(10),
                        @EXECUTIVE_COUNTRYID uniqueidentifier,
                        @EXECUTIVE_ADDRESSBLOCK nvarchar(100),
                        @EXECUTIVE_CITY nvarchar(50),
                        @EXECUTIVE_STATEID uniqueidentifier,
                        @EXECUTIVE_POSTCODE nvarchar(10),
                        @BUSINESS_PHONE nvarchar(20),
                        @ADDRESS_INFOSOURCECODEID uniqueidentifier
                    ) as
                        set nocount on;

                        --do nothing

                        return 0;