UFN_FINANCIALINSTITUTION_ISUNIQUE

Validates whether a constituent financial institution is unique.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@FINANCIALINSTITUTION	nvarchar(100)	IN
@BRANCHNAME	nvarchar(100)	IN
@ROUTINGNUMBER	nvarchar(9)	IN
@SORTCODE	nvarchar(8)	IN
@BSB	nvarchar(7)	IN
@INSTITUTIONID	nvarchar(8)	IN
@BANKNUMBER	nvarchar(7)	IN

Definition

Copy



        CREATE function dbo.UFN_FINANCIALINSTITUTION_ISUNIQUE
        (
            @FINANCIALINSTITUTION nvarchar(100),
            @BRANCHNAME nvarchar(100),
            @ROUTINGNUMBER nvarchar(9),
            @SORTCODE nvarchar(8),
            @BSB nvarchar(7),
            @INSTITUTIONID nvarchar(8),
            @BANKNUMBER nvarchar(7)
        )
        returns bit
        with execute as caller
        as begin

            return dbo.UFN_FINANCIALINSTITUTION_ISUNIQUE_2(@FINANCIALINSTITUTION,@BRANCHNAME,@ROUTINGNUMBER,@SORTCODE,@BSB,@INSTITUTIONID,@BANKNUMBER,'','')

        end