V_SEARCH_FINANCIALINSTITUTION
This search is used for finding constituent financial institutions.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| FINANCIALINSTITUTION | nvarchar(100) | ||
| BRANCHNAME | nvarchar(100) | ||
| ROUTINGNUMBER | nvarchar(9) | ||
| ADDRESS | nvarchar(150) | ||
| CITY | nvarchar(50) | ||
| STATE | nvarchar(100) | yes | |
| POSTALCODE | nvarchar(12) | ||
| SORTCODE | nvarchar(6) | ||
| BANKINGSYSTEMCONDITIONSETTINGNAME | nvarchar(50) | yes | |
| BANKINGSYSTEMNAME | nvarchar(50) | yes | |
| BIC | nvarchar(11) | ||
| BANKCODE | nvarchar(25) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/1/2024 11:54:01 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.3800.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SEARCH_FINANCIALINSTITUTION AS
select
FINANCIALINSTITUTION.ID,
FINANCIALINSTITUTION.FINANCIALINSTITUTION,
FINANCIALINSTITUTION.BRANCHNAME,
FINANCIALINSTITUTION.ROUTINGNUMBER,
FINANCIALINSTITUTION.ADDRESSBLOCK [ADDRESS],
FINANCIALINSTITUTION.CITY,
STATE.DESCRIPTION [STATE],
FINANCIALINSTITUTION.POSTCODE [POSTALCODE],
FINANCIALINSTITUTION.SORTCODE [SORTCODE],
BANKINGSYSTEM.CONDITIONSETTINGNAME [BANKINGSYSTEMCONDITIONSETTINGNAME],
BANKINGSYSTEM.NAME [BANKINGSYSTEMNAME],
FINANCIALINSTITUTION.BIC,
FINANCIALINSTITUTION.BANKCODE
from
dbo.FINANCIALINSTITUTION
left join dbo.BANKINGSYSTEM on BANKINGSYSTEM.ID = FINANCIALINSTITUTION.BANKINGSYSTEMID
left join dbo.STATE on FINANCIALINSTITUTION.STATEID = STATE.ID;