USP_DATAFORMTEMPLATE_EDIT_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIP_CONSTITFROMBIO

The save procedure used by the edit dataform template "Prospect Quick Search Business Ownership Constit From Bio 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
@FULLNAME	nvarchar(100)	IN	Full name
@LASTNAME	nvarchar(30)	IN	Last name
@FIRSTNAME	nvarchar(25)	IN	First name
@MIDDLENAME	nvarchar(10)	IN	Middle name
@SUFFIXCODEID	uniqueidentifier	IN	Suffix
@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
@BUSINESS_PHONE	nvarchar(20)	IN	Phone
@ADDRESS_INFOSOURCECODEID	uniqueidentifier	IN	Information source

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIP_CONSTITFROMBIO (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @BUSINESSOPTIONCODE tinyint,
                        @BUSINESSID uniqueidentifier,
                        @BUSINESSRELATIONSHIPTYPECODEID uniqueidentifier,
                        @BUSINESSRECIPROCALTYPECODEID uniqueidentifier,
                        @ADDRESSTYPECODE tinyint,
                        @FULLNAME nvarchar(100),
                        @LASTNAME nvarchar(30),
                        @FIRSTNAME nvarchar(25),
                        @MIDDLENAME nvarchar(10),
                        @SUFFIXCODEID uniqueidentifier,
                        @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),
                        @BUSINESS_PHONE nvarchar(20),
                        @ADDRESS_INFOSOURCECODEID uniqueidentifier
                    ) as
                        set nocount on;

                        --do nothing

                        return 0;