USP_BBNC_GETAUTOMATCHOPTIONS

Retrieves the auto-match options from the database.

Parameters

Parameter	Parameter Type	Mode
@USELASTNAME	bit	INOUT
@USEFIRSTNAME	bit	INOUT
@USEMIDDLENAME	bit	INOUT
@USEMAIDENNAME	bit	INOUT
@USEBIRTHDATE	bit	INOUT
@USEGENDER	bit	INOUT
@USEADDRESS	bit	INOUT
@USECITY	bit	INOUT
@USECOUNTRY	bit	INOUT
@USECOUNTY	bit	INOUT
@USENZCITY	bit	INOUT
@USENZSUBURB	bit	INOUT
@USESTATE	bit	INOUT
@USEZIP	bit	INOUT
@USEPHONE	bit	INOUT
@USELOOKUPID	bit	INOUT
@EXACTMATCH	bit	INOUT
@INCLUDEINACTIVE	bit	INOUT
@INCLUDEDECEASED	bit	INOUT
@USEEMAIL	bit	INOUT
@USESUFFIX	bit	INOUT

Definition

Copy



            CREATE procedure dbo.USP_BBNC_GETAUTOMATCHOPTIONS
            (
                @USELASTNAME bit = null output,
                @USEFIRSTNAME bit = null output,
                @USEMIDDLENAME bit = null output,
                @USEMAIDENNAME bit = null output,
                @USEBIRTHDATE bit = null output,
                @USEGENDER bit = null output,
                @USEADDRESS bit = null output,
                @USECITY bit = null output,
                @USECOUNTRY bit = null output,
                @USECOUNTY bit = null output,
                @USENZCITY bit = null output,
                @USENZSUBURB bit = null output,
                @USESTATE bit = null output,
                @USEZIP bit = null output,
                @USEPHONE bit = null output,                
                @USELOOKUPID bit = null output,
                @EXACTMATCH bit = null output,
                @INCLUDEINACTIVE bit = null output,
                @INCLUDEDECEASED bit = null output,
                @USEEMAIL bit = null output,
                @USESUFFIX bit = null output
            )
            as
            set nocount on;

            select top 1
                @USELASTNAME = AUTOMATCHUSELASTNAME,
                @USEFIRSTNAME = AUTOMATCHUSEFIRSTNAME,
                @USEMIDDLENAME = AUTOMATCHUSEMIDDLENAME,
                @USEMAIDENNAME = AUTOMATCHUSEMAIDENNAME,
                @USEBIRTHDATE = AUTOMATCHUSEBIRTHDATE,
                @USEGENDER = AUTOMATCHUSEGENDER,
                @USEADDRESS = AUTOMATCHUSEADDRESS,
                @USECITY= AUTOMATCHUSECITY,
                @USECOUNTRY = AUTOMATCHUSECOUNTRY,
                @USECOUNTY = AUTOMATCHUSECOUNTY,
                @USENZCITY = AUTOMATCHUSENZCITY,
                @USENZSUBURB = AUTOMATCHUSENZSUBURB,
                @USESTATE = AUTOMATCHUSESTATE,
                @USEZIP = AUTOMATCHUSEZIP,
                @USEPHONE = AUTOMATCHUSEPHONE,
                @USELOOKUPID = AUTOMATCHUSELOOKUPID,
                @EXACTMATCH = AUTOMATCHEXACTMATCHONLY,
                @INCLUDEINACTIVE = AUTOMATCHINCLUDEINACTIVE,
                @INCLUDEDECEASED = AUTOMATCHINCLUDEDECEASED,
                @USEEMAIL = AUTOMATCHUSEEMAIL,
                @USESUFFIX = AUTOMATCHUSESUFFIX
            from dbo.NETCOMMUNITYDEFAULTCODEMAP;

            return 0;