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

# InstitutionRow

`InstitutionRow` is the designer-generated typed `DataRow` nested in `Institutions.InstitutionDataTable`, exposing a strongly-typed `String` property for every column of a single financial-institution reference record (routing/MICR/SWIFT codes, address, phone/fax, and related legacy/alternate-code fields), along with `Is<Column>Null`/`Set<Column>Null` helper pairs for each nullable column.

## Purpose
- Expose strongly-typed read/write access to each column of a single institution record (e.g., `LYONS_ID`, `LOC`, `NAME`, `MICR`, `SWIFT`, address/phone/fax fields).*
- Provide `Is<Column>Null()`/`Set<Column>Null()` method pairs for each column so callers can check for and set `DBNull` values without using ADO.NET's untyped API directly.

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

## Public members
| Member | Signature | Purpose |
| --- | --- | --- |
| `LYONS_ID` | `Public Property LYONS_ID() As String` | The institution's internal identifier (Lyons system ID).* |
| `LOC` | `Public Property LOC() As String` | The institution's location code.* |
| `NAME` | `Public Property NAME() As String` | The institution's name. |
| `MICR` | `Public Property MICR() As String` | The institution's MICR routing number. |
| `FRAC` | `Public Property FRAC() As String` | The institution's fractional routing designation.* |
| `ACH` | `Public Property ACH() As String` | The institution's ACH routing number. |
| `PHYS_ADDR1` | `Public Property PHYS_ADDR1() As String` | The institution's physical street address. |
| `PHYS_CITY` | `Public Property PHYS_CITY() As String` | The institution's city. |
| `PHYS_STATE` | `Public Property PHYS_STATE() As String` | The institution's state. |
| `PHYS_ZIP` | `Public Property PHYS_ZIP() As String` | The institution's ZIP code. |
| `PHONE` | `Public Property PHONE() As String` | The institution's phone number. |
| `FAX` | `Public Property FAX() As String` | The institution's fax number. |
| `FEDWIRE` | `Public Property FEDWIRE() As String` | The institution's Fedwire routing number. |
| `CORR_RTNO` | `Public Property CORR_RTNO() As String` | The institution's correspondent routing number.* |
| `_RETURN` | `Public Property _RETURN() As String` | The institution's return-item routing number, exposed via the `RETURN` column; renamed `_RETURN` in code because `RETURN` is a VB.NET reserved word.* |
| `RETURN_EXT` | `Public Property RETURN_EXT() As String` | Extension/suffix appended to the return-item routing number.* |
| `ADJUST` | `Public Property ADJUST() As String` | The institution's adjustment routing number.* |
| `ADJUST_EXT` | `Public Property ADJUST_EXT() As String` | Extension/suffix appended to the adjustment routing number.* |
| `WIREPHONE` | `Public Property WIREPHONE() As String` | Phone number used to confirm the institution's incoming wire transfers.* |
| `WIREPHONE_EXT` | `Public Property WIREPHONE_EXT() As String` | Extension for the wire-transfer confirmation phone number.* |
| `SWIFT` | `Public Property SWIFT() As String` | The institution's SWIFT code. |
| `TELEX` | `Public Property TELEX() As String` | The institution's telex identifier.* |
| `OLDMICR` | `Public Property OLDMICR() As String` | The institution's prior/legacy MICR routing number, retained for historical matching.* |
| `HOMEPAGE` | `Public Property HOMEPAGE() As String` | The institution's homepage URL. |
| `EMAIL` | `Public Property EMAIL() As String` | The institution's contact email address. |
| `NOTES` | `Public Property NOTES() As String` | Free-form notes about the institution. |
| `LYONS_NOTE` | `Public Property LYONS_NOTE() As String` | Free-form note field specific to the Lyons system.* |
| `CUST_SVC` | `Public Property CUST_SVC() As String` | The institution's customer-service phone/contact.* |
| `UniWire` | `Public Property UniWire() As String` | The institution's Universal Wire routing code.* |
| `LABAOld2` | `Public Property LABAOld2() As String` | A legacy ABA routing number retained as an alternate value (variant 2).* |
| `LABAOld3` | `Public Property LABAOld3() As String` | A legacy ABA routing number retained as an alternate value (variant 3).* |
| `LACHOld` | `Public Property LACHOld() As String` | A prior legacy ACH routing number.* |
| `LACHOld2` | `Public Property LACHOld2() As String` | A legacy ACH routing number retained as an alternate value (variant 2).* |
| `LACHOld3` | `Public Property LACHOld3() As String` | A legacy ACH routing number retained as an alternate value (variant 3).* |
| `IsLYONS_IDNull` / `SetLYONS_IDNull` | `Public Function IsLYONS_IDNull() As Boolean` / `Public Sub SetLYONS_IDNull()` | Checks for/sets a `DBNull` value in the `LYONS_ID` column. |
| `IsLOCNull` / `SetLOCNull` | `Public Function IsLOCNull() As Boolean` / `Public Sub SetLOCNull()` | Checks for/sets a `DBNull` value in the `LOC` column. |
| `IsNAMENull` / `SetNAMENull` | `Public Function IsNAMENull() As Boolean` / `Public Sub SetNAMENull()` | Checks for/sets a `DBNull` value in the `NAME` column. |
| `IsMICRNull` / `SetMICRNull` | `Public Function IsMICRNull() As Boolean` / `Public Sub SetMICRNull()` | Checks for/sets a `DBNull` value in the `MICR` column. |
| `IsFRACNull` / `SetFRACNull` | `Public Function IsFRACNull() As Boolean` / `Public Sub SetFRACNull()` | Checks for/sets a `DBNull` value in the `FRAC` column. |
| `IsACHNull` / `SetACHNull` | `Public Function IsACHNull() As Boolean` / `Public Sub SetACHNull()` | Checks for/sets a `DBNull` value in the `ACH` column. |
| `IsPHYS_ADDR1Null` / `SetPHYS_ADDR1Null` | `Public Function IsPHYS_ADDR1Null() As Boolean` / `Public Sub SetPHYS_ADDR1Null()` | Checks for/sets a `DBNull` value in the `PHYS_ADDR1` column. |
| `IsPHYS_CITYNull` / `SetPHYS_CITYNull` | `Public Function IsPHYS_CITYNull() As Boolean` / `Public Sub SetPHYS_CITYNull()` | Checks for/sets a `DBNull` value in the `PHYS_CITY` column. |
| `IsPHYS_STATENull` / `SetPHYS_STATENull` | `Public Function IsPHYS_STATENull() As Boolean` / `Public Sub SetPHYS_STATENull()` | Checks for/sets a `DBNull` value in the `PHYS_STATE` column. |
| `IsPHYS_ZIPNull` / `SetPHYS_ZIPNull` | `Public Function IsPHYS_ZIPNull() As Boolean` / `Public Sub SetPHYS_ZIPNull()` | Checks for/sets a `DBNull` value in the `PHYS_ZIP` column. |
| `IsPHONENull` / `SetPHONENull` | `Public Function IsPHONENull() As Boolean` / `Public Sub SetPHONENull()` | Checks for/sets a `DBNull` value in the `PHONE` column. |
| `IsFAXNull` / `SetFAXNull` | `Public Function IsFAXNull() As Boolean` / `Public Sub SetFAXNull()` | Checks for/sets a `DBNull` value in the `FAX` column. |
| `IsFEDWIRENull` / `SetFEDWIRENull` | `Public Function IsFEDWIRENull() As Boolean` / `Public Sub SetFEDWIRENull()` | Checks for/sets a `DBNull` value in the `FEDWIRE` column. |
| `IsCORR_RTNONull` / `SetCORR_RTNONull` | `Public Function IsCORR_RTNONull() As Boolean` / `Public Sub SetCORR_RTNONull()` | Checks for/sets a `DBNull` value in the `CORR_RTNO` column. |
| `Is_RETURNNull` / `Set_RETURNNull` | `Public Function Is_RETURNNull() As Boolean` / `Public Sub Set_RETURNNull()` | Checks for/sets a `DBNull` value in the `RETURN` column. |
| `IsRETURN_EXTNull` / `SetRETURN_EXTNull` | `Public Function IsRETURN_EXTNull() As Boolean` / `Public Sub SetRETURN_EXTNull()` | Checks for/sets a `DBNull` value in the `RETURN_EXT` column. |
| `IsADJUSTNull` / `SetADJUSTNull` | `Public Function IsADJUSTNull() As Boolean` / `Public Sub SetADJUSTNull()` | Checks for/sets a `DBNull` value in the `ADJUST` column. |
| `IsADJUST_EXTNull` / `SetADJUST_EXTNull` | `Public Function IsADJUST_EXTNull() As Boolean` / `Public Sub SetADJUST_EXTNull()` | Checks for/sets a `DBNull` value in the `ADJUST_EXT` column. |
| `IsWIREPHONENull` / `SetWIREPHONENull` | `Public Function IsWIREPHONENull() As Boolean` / `Public Sub SetWIREPHONENull()` | Checks for/sets a `DBNull` value in the `WIREPHONE` column. |
| `IsWIREPHONE_EXTNull` / `SetWIREPHONE_EXTNull` | `Public Function IsWIREPHONE_EXTNull() As Boolean` / `Public Sub SetWIREPHONE_EXTNull()` | Checks for/sets a `DBNull` value in the `WIREPHONE_EXT` column. |
| `IsSWIFTNull` / `SetSWIFTNull` | `Public Function IsSWIFTNull() As Boolean` / `Public Sub SetSWIFTNull()` | Checks for/sets a `DBNull` value in the `SWIFT` column. |
| `IsTELEXNull` / `SetTELEXNull` | `Public Function IsTELEXNull() As Boolean` / `Public Sub SetTELEXNull()` | Checks for/sets a `DBNull` value in the `TELEX` column. |
| `IsOLDMICRNull` / `SetOLDMICRNull` | `Public Function IsOLDMICRNull() As Boolean` / `Public Sub SetOLDMICRNull()` | Checks for/sets a `DBNull` value in the `OLDMICR` column. |
| `IsHOMEPAGENull` / `SetHOMEPAGENull` | `Public Function IsHOMEPAGENull() As Boolean` / `Public Sub SetHOMEPAGENull()` | Checks for/sets a `DBNull` value in the `HOMEPAGE` column. |
| `IsEMAILNull` / `SetEMAILNull` | `Public Function IsEMAILNull() As Boolean` / `Public Sub SetEMAILNull()` | Checks for/sets a `DBNull` value in the `EMAIL` column. |
| `IsNOTESNull` / `SetNOTESNull` | `Public Function IsNOTESNull() As Boolean` / `Public Sub SetNOTESNull()` | Checks for/sets a `DBNull` value in the `NOTES` column. |
| `IsLYONS_NOTENull` / `SetLYONS_NOTENull` | `Public Function IsLYONS_NOTENull() As Boolean` / `Public Sub SetLYONS_NOTENull()` | Checks for/sets a `DBNull` value in the `LYONS_NOTE` column. |
| `IsCUST_SVCNull` / `SetCUST_SVCNull` | `Public Function IsCUST_SVCNull() As Boolean` / `Public Sub SetCUST_SVCNull()` | Checks for/sets a `DBNull` value in the `CUST_SVC` column. |
| `IsUniWireNull` / `SetUniWireNull` | `Public Function IsUniWireNull() As Boolean` / `Public Sub SetUniWireNull()` | Checks for/sets a `DBNull` value in the `UniWire` column. |
| `IsLABAOld2Null` / `SetLABAOld2Null` | `Public Function IsLABAOld2Null() As Boolean` / `Public Sub SetLABAOld2Null()` | Checks for/sets a `DBNull` value in the `LABAOld2` column. |
| `IsLABAOld3Null` / `SetLABAOld3Null` | `Public Function IsLABAOld3Null() As Boolean` / `Public Sub SetLABAOld3Null()` | Checks for/sets a `DBNull` value in the `LABAOld3` column. |
| `IsLACHOldNull` / `SetLACHOldNull` | `Public Function IsLACHOldNull() As Boolean` / `Public Sub SetLACHOldNull()` | Checks for/sets a `DBNull` value in the `LACHOld` column. |
| `IsLACHOld2Null` / `SetLACHOld2Null` | `Public Function IsLACHOld2Null() As Boolean` / `Public Sub SetLACHOld2Null()` | Checks for/sets a `DBNull` value in the `LACHOld2` column. |
| `IsLACHOld3Null` / `SetLACHOld3Null` | `Public Function IsLACHOld3Null() As Boolean` / `Public Sub SetLACHOld3Null()` | Checks for/sets a `DBNull` value in the `LACHOld3` column. |

## Behavioral notes
- Source declaration: `Business\SAIF.Business.Policy\Institutions.Designer.vb`.
- Related operations, rules, and SQL are cross-referenced from the library-level documentation.

## Constraints and usage notes
- Consumers should rely on the declared public surface rather than internal implementation details.

> **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\Institutions.Designer.vb`