---
title: Institutions.InstitutionRow
summary: API reference for Institutions.InstitutionRow.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Agency
reference_type: package
---

# Institutions.InstitutionRow

`Institutions.InstitutionRow` is the generated typed row that exposes the bank and routing columns contained in the `Institution` typed table.

## Purpose
- Surface institution reference fields such as routing, address, and contact values as strongly typed properties.
- Provide generated null-check and null-assignment helpers for optional dataset columns.

## Context
- Namespace: `SAIF.Business.Policy.Agency`
- Assembly/package: `SAIF.Business.Policy.Agency`

## Public members
| Member | Signature | Purpose |
| --- | --- | --- |
| `LYONS_ID` | `Public Property LYONS_ID() As String` | Internal identifier used by the historical Lyons reference system to uniquely identify the institution row. |
| `LOC` | `Public Property LOC() As String` | Location code distinguishing a specific branch or office of the institution. |
| `NAME` | `Public Property NAME() As String` | Display name of the financial institution. |
| `MICR` | `Public Property MICR() As String` | MICR routing/transit number used for check-processing identification of the institution. |
| `FRAC` | `Public Property FRAC() As String` | Fractional (check-routing) component of the institution MICR number. |
| `ACH` | `Public Property ACH() As String` | ACH routing number used for electronic funds transfer to the institution. |
| `PHYS_ADDR1` | `Public Property PHYS_ADDR1() As String` | Street address line of the institution physical location. |
| `PHYS_CITY` | `Public Property PHYS_CITY() As String` | City of the institution physical address. |
| `PHYS_STATE` | `Public Property PHYS_STATE() As String` | State of the institution physical address. |
| `PHYS_ZIP` | `Public Property PHYS_ZIP() As String` | ZIP/postal code of the institution physical address. |
| `PHONE` | `Public Property PHONE() As String` | Primary phone number for the institution. |
| `FAX` | `Public Property FAX() As String` | Fax number for the institution. |
| `FEDWIRE` | `Public Property FEDWIRE() As String` | Fedwire routing number used for Federal Reserve wire transfers to the institution. |
| `CORR_RTNO` | `Public Property CORR_RTNO() As String` | Routing number of the institution correspondent bank. |
| `_RETURN` | `Public Property _RETURN() As String` | Return-item routing/handling code recorded for the institution. |
| `RETURN_EXT` | `Public Property RETURN_EXT() As String` | Phone extension associated with the institution return-item contact. |
| `ADJUST` | `Public Property ADJUST() As String` | Adjustment routing/handling code recorded for the institution. |
| `ADJUST_EXT` | `Public Property ADJUST_EXT() As String` | Phone extension associated with the institution adjustments contact. |
| `WIREPHONE` | `Public Property WIREPHONE() As String` | Phone number for the institution wire-transfer department. |
| `WIREPHONE_EXT` | `Public Property WIREPHONE_EXT() As String` | Phone extension for the institution wire-transfer department. |
| `SWIFT` | `Public Property SWIFT() As String` | SWIFT/BIC code used for international wire transfers to the institution. |
| `TELEX` | `Public Property TELEX() As String` | Telex number historically used for message routing to the institution. |
| `OLDMICR` | `Public Property OLDMICR() As String` | Prior/legacy MICR routing number retained for historical reference. |
| `HOMEPAGE` | `Public Property HOMEPAGE() As String` | URL of the institution website. |
| `EMAIL` | `Public Property EMAIL() As String` | Contact email address for the institution. |
| `NOTES` | `Public Property NOTES() As String` | Free-text notes recorded about the institution. |
| `LYONS_NOTE` | `Public Property LYONS_NOTE() As String` | Free-text note specific to the legacy Lyons reference system. |
| `CUST_SVC` | `Public Property CUST_SVC() As String` | Customer-service phone number or contact information for the institution. |
| `UniWire` | `Public Property UniWire() As String` | Universal wire-routing identifier recorded for the institution. |
| `LABAOld2` | `Public Property LABAOld2() As String` | Legacy ABA routing number (second historical variant) retained for reference. |
| `LABAOld3` | `Public Property LABAOld3() As String` | Legacy ABA routing number (third historical variant) retained for reference. |
| `LACHOld` | `Public Property LACHOld() As String` | Legacy ACH routing number retained for historical reference. |
| `LACHOld2` | `Public Property LACHOld2() As String` | Legacy ACH routing number (second historical variant) retained for reference. |
| `LACHOld3` | `Public Property LACHOld3() As String` | Legacy ACH routing number (third historical variant) retained for reference. |
| `IsLYONS_IDNull` | `Public Function IsLYONS_IDNull() As Boolean` | Reports whether the LYONS_ID field currently holds a database null. |
| `SetLYONS_IDNull` | `Public Sub SetLYONS_IDNull()` | Clears the LYONS_ID field back to a database-null state. |
| `IsLOCNull` | `Public Function IsLOCNull() As Boolean` | Reports whether the LOC field currently holds a database null. |
| `SetLOCNull` | `Public Sub SetLOCNull()` | Clears the LOC field back to a database-null state. |
| `IsNAMENull` | `Public Function IsNAMENull() As Boolean` | Reports whether the NAME field currently holds a database null. |
| `SetNAMENull` | `Public Sub SetNAMENull()` | Clears the NAME field back to a database-null state. |
| `IsMICRNull` | `Public Function IsMICRNull() As Boolean` | Reports whether the MICR field currently holds a database null. |
| `SetMICRNull` | `Public Sub SetMICRNull()` | Clears the MICR field back to a database-null state. |
| `IsFRACNull` | `Public Function IsFRACNull() As Boolean` | Reports whether the FRAC field currently holds a database null. |
| `SetFRACNull` | `Public Sub SetFRACNull()` | Clears the FRAC field back to a database-null state. |
| `IsACHNull` | `Public Function IsACHNull() As Boolean` | Reports whether the ACH field currently holds a database null. |
| `SetACHNull` | `Public Sub SetACHNull()` | Clears the ACH field back to a database-null state. |
| `IsPHYS_ADDR1Null` | `Public Function IsPHYS_ADDR1Null() As Boolean` | Reports whether the PHYS_ADDR1 field currently holds a database null. |
| `SetPHYS_ADDR1Null` | `Public Sub SetPHYS_ADDR1Null()` | Clears the PHYS_ADDR1 field back to a database-null state. |
| `IsPHYS_CITYNull` | `Public Function IsPHYS_CITYNull() As Boolean` | Reports whether the PHYS_CITY field currently holds a database null. |
| `SetPHYS_CITYNull` | `Public Sub SetPHYS_CITYNull()` | Clears the PHYS_CITY field back to a database-null state. |
| `IsPHYS_STATENull` | `Public Function IsPHYS_STATENull() As Boolean` | Reports whether the PHYS_STATE field currently holds a database null. |
| `SetPHYS_STATENull` | `Public Sub SetPHYS_STATENull()` | Clears the PHYS_STATE field back to a database-null state. |
| `IsPHYS_ZIPNull` | `Public Function IsPHYS_ZIPNull() As Boolean` | Reports whether the PHYS_ZIP field currently holds a database null. |
| `SetPHYS_ZIPNull` | `Public Sub SetPHYS_ZIPNull()` | Clears the PHYS_ZIP field back to a database-null state. |
| `IsPHONENull` | `Public Function IsPHONENull() As Boolean` | Reports whether the PHONE field currently holds a database null. |
| `SetPHONENull` | `Public Sub SetPHONENull()` | Clears the PHONE field back to a database-null state. |
| `IsFAXNull` | `Public Function IsFAXNull() As Boolean` | Reports whether the FAX field currently holds a database null. |
| `SetFAXNull` | `Public Sub SetFAXNull()` | Clears the FAX field back to a database-null state. |
| `IsFEDWIRENull` | `Public Function IsFEDWIRENull() As Boolean` | Reports whether the FEDWIRE field currently holds a database null. |
| `SetFEDWIRENull` | `Public Sub SetFEDWIRENull()` | Clears the FEDWIRE field back to a database-null state. |
| `IsCORR_RTNONull` | `Public Function IsCORR_RTNONull() As Boolean` | Reports whether the CORR_RTNO field currently holds a database null. |
| `SetCORR_RTNONull` | `Public Sub SetCORR_RTNONull()` | Clears the CORR_RTNO field back to a database-null state. |
| `Is_RETURNNull` | `Public Function Is_RETURNNull() As Boolean` | Reports whether the _RETURN field currently holds a database null. |
| `Set_RETURNNull` | `Public Sub Set_RETURNNull()` | Clears the _RETURN field back to a database-null state. |
| `IsRETURN_EXTNull` | `Public Function IsRETURN_EXTNull() As Boolean` | Reports whether the RETURN_EXT field currently holds a database null. |
| `SetRETURN_EXTNull` | `Public Sub SetRETURN_EXTNull()` | Clears the RETURN_EXT field back to a database-null state. |
| `IsADJUSTNull` | `Public Function IsADJUSTNull() As Boolean` | Reports whether the ADJUST field currently holds a database null. |
| `SetADJUSTNull` | `Public Sub SetADJUSTNull()` | Clears the ADJUST field back to a database-null state. |
| `IsADJUST_EXTNull` | `Public Function IsADJUST_EXTNull() As Boolean` | Reports whether the ADJUST_EXT field currently holds a database null. |
| `SetADJUST_EXTNull` | `Public Sub SetADJUST_EXTNull()` | Clears the ADJUST_EXT field back to a database-null state. |
| `IsWIREPHONENull` | `Public Function IsWIREPHONENull() As Boolean` | Reports whether the WIREPHONE field currently holds a database null. |
| `SetWIREPHONENull` | `Public Sub SetWIREPHONENull()` | Clears the WIREPHONE field back to a database-null state. |
| `IsWIREPHONE_EXTNull` | `Public Function IsWIREPHONE_EXTNull() As Boolean` | Reports whether the WIREPHONE_EXT field currently holds a database null. |
| `SetWIREPHONE_EXTNull` | `Public Sub SetWIREPHONE_EXTNull()` | Clears the WIREPHONE_EXT field back to a database-null state. |
| `IsSWIFTNull` | `Public Function IsSWIFTNull() As Boolean` | Reports whether the SWIFT field currently holds a database null. |
| `SetSWIFTNull` | `Public Sub SetSWIFTNull()` | Clears the SWIFT field back to a database-null state. |
| `IsTELEXNull` | `Public Function IsTELEXNull() As Boolean` | Reports whether the TELEX field currently holds a database null. |
| `SetTELEXNull` | `Public Sub SetTELEXNull()` | Clears the TELEX field back to a database-null state. |
| `IsOLDMICRNull` | `Public Function IsOLDMICRNull() As Boolean` | Reports whether the OLDMICR field currently holds a database null. |
| `SetOLDMICRNull` | `Public Sub SetOLDMICRNull()` | Clears the OLDMICR field back to a database-null state. |
| `IsHOMEPAGENull` | `Public Function IsHOMEPAGENull() As Boolean` | Reports whether the HOMEPAGE field currently holds a database null. |
| `SetHOMEPAGENull` | `Public Sub SetHOMEPAGENull()` | Clears the HOMEPAGE field back to a database-null state. |
| `IsEMAILNull` | `Public Function IsEMAILNull() As Boolean` | Reports whether the EMAIL field currently holds a database null. |
| `SetEMAILNull` | `Public Sub SetEMAILNull()` | Clears the EMAIL field back to a database-null state. |
| `IsNOTESNull` | `Public Function IsNOTESNull() As Boolean` | Reports whether the NOTES field currently holds a database null. |
| `SetNOTESNull` | `Public Sub SetNOTESNull()` | Clears the NOTES field back to a database-null state. |
| `IsLYONS_NOTENull` | `Public Function IsLYONS_NOTENull() As Boolean` | Reports whether the LYONS_NOTE field currently holds a database null. |
| `SetLYONS_NOTENull` | `Public Sub SetLYONS_NOTENull()` | Clears the LYONS_NOTE field back to a database-null state. |
| `IsCUST_SVCNull` | `Public Function IsCUST_SVCNull() As Boolean` | Reports whether the CUST_SVC field currently holds a database null. |
| `SetCUST_SVCNull` | `Public Sub SetCUST_SVCNull()` | Clears the CUST_SVC field back to a database-null state. |
| `IsUniWireNull` | `Public Function IsUniWireNull() As Boolean` | Reports whether the UniWire field currently holds a database null. |
| `SetUniWireNull` | `Public Sub SetUniWireNull()` | Clears the UniWire field back to a database-null state. |
| `IsLABAOld2Null` | `Public Function IsLABAOld2Null() As Boolean` | Reports whether the LABAOld2 field currently holds a database null. |
| `SetLABAOld2Null` | `Public Sub SetLABAOld2Null()` | Clears the LABAOld2 field back to a database-null state. |
| `IsLABAOld3Null` | `Public Function IsLABAOld3Null() As Boolean` | Reports whether the LABAOld3 field currently holds a database null. |
| `SetLABAOld3Null` | `Public Sub SetLABAOld3Null()` | Clears the LABAOld3 field back to a database-null state. |
| `IsLACHOldNull` | `Public Function IsLACHOldNull() As Boolean` | Reports whether the LACHOld field currently holds a database null. |
| `SetLACHOldNull` | `Public Sub SetLACHOldNull()` | Clears the LACHOld field back to a database-null state. |
| `IsLACHOld2Null` | `Public Function IsLACHOld2Null() As Boolean` | Reports whether the LACHOld2 field currently holds a database null. |
| `SetLACHOld2Null` | `Public Sub SetLACHOld2Null()` | Clears the LACHOld2 field back to a database-null state. |
| `IsLACHOld3Null` | `Public Function IsLACHOld3Null() As Boolean` | Reports whether the LACHOld3 field currently holds a database null. |
| `SetLACHOld3Null` | `Public Sub SetLACHOld3Null()` | Clears the LACHOld3 field back to a database-null state. |

## Behavioral notes
- The row surface is generated directly from the dataset schema and is not customized with agency-specific business logic.
- The available properties mirror the routing, address, phone, and contact columns defined in the underlying dataset.
- Column purposes above are inferred from field naming conventions in the underlying `Institutions.xsd`-generated schema; no separate business-rules documentation exists for this reference dataset.*

## Constraints and usage notes
- Consumers should treat the property set as schema-driven generated code.

> **Note:** Statements marked with * were inferred from code structure, naming conventions, or
> contextual evidence where direct confirmation was not available in source artifacts. Statements
> marked with ** could not be confirmed; treat as unknown until verified.

## Sources
- `Business\SAIF.Business.Policy.Agency\Institutions.Designer.vb`