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

# InstitutionDataTable

`InstitutionDataTable` is the designer-generated typed `DataTable` nested in `Institutions`, exposing strongly-typed `DataColumn` accessors for every column of the financial-institution reference table (routing/MICR/SWIFT codes, address, phone/fax, and related legacy/alternate-code columns), row-level change events, and helpers to create/add/remove `InstitutionRow` instances.

## Purpose
- Expose a strongly-typed `DataColumn` property for each column in the `Institution` reference table (e.g., `LYONS_IDColumn`, `LOCColumn`, `NAMEColumn`, `MICRColumn`, `SWIFTColumn`, address/phone/fax columns), so consumers can reference columns without magic strings.*
- Raise `InstitutionRowChanging`/`InstitutionRowChanged`/`InstitutionRowDeleting`/`InstitutionRowDeleted` events as rows are modified, per the standard typed-DataTable pattern.
- Provide `NewInstitutionRow`/`AddInstitutionRow`/`RemoveInstitutionRow` helpers to create and manage `InstitutionRow` instances in the table.

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

## Public members
| Member | Signature | Purpose |
| --- | --- | --- |
| `LYONS_IDColumn` | `Public ReadOnly Property LYONS_IDColumn() As DataColumn` | Typed accessor for the `LYONS_ID` column, the institution's internal identifier.* |
| `LOCColumn` | `Public ReadOnly Property LOCColumn() As DataColumn` | Typed accessor for the `LOC` (location code) column.* |
| `NAMEColumn` | `Public ReadOnly Property NAMEColumn() As DataColumn` | Typed accessor for the `NAME` (institution name) column. |
| `MICRColumn` | `Public ReadOnly Property MICRColumn() As DataColumn` | Typed accessor for the `MICR` (routing number) column. |
| `FRACColumn` | `Public ReadOnly Property FRACColumn() As DataColumn` | Typed accessor for the `FRAC` (fractional routing designation) column.* |
| `ACHColumn` | `Public ReadOnly Property ACHColumn() As DataColumn` | Typed accessor for the `ACH` routing-number column. |
| `PHYS_ADDR1Column` | `Public ReadOnly Property PHYS_ADDR1Column() As DataColumn` | Typed accessor for the institution's physical street-address column. |
| `PHYS_CITYColumn` | `Public ReadOnly Property PHYS_CITYColumn() As DataColumn` | Typed accessor for the institution's city column. |
| `PHYS_STATEColumn` | `Public ReadOnly Property PHYS_STATEColumn() As DataColumn` | Typed accessor for the institution's state column. |
| `PHYS_ZIPColumn` | `Public ReadOnly Property PHYS_ZIPColumn() As DataColumn` | Typed accessor for the institution's ZIP code column. |
| `PHONEColumn` | `Public ReadOnly Property PHONEColumn() As DataColumn` | Typed accessor for the institution's phone-number column. |
| `FAXColumn` | `Public ReadOnly Property FAXColumn() As DataColumn` | Typed accessor for the institution's fax-number column. |
| `FEDWIREColumn` | `Public ReadOnly Property FEDWIREColumn() As DataColumn` | Typed accessor for the institution's Fedwire routing-number column. |
| `CORR_RTNOColumn` | `Public ReadOnly Property CORR_RTNOColumn() As DataColumn` | Typed accessor for the institution's correspondent routing-number column.* |
| `_RETURNColumn` | `Public ReadOnly Property _RETURNColumn() As DataColumn` | Typed accessor for the `RETURN` (return-item routing number) column; renamed `_RETURN` in code because `RETURN` is a VB.NET reserved word.* |
| `RETURN_EXTColumn` | `Public ReadOnly Property RETURN_EXTColumn() As DataColumn` | Typed accessor for the extension/suffix appended to the return-item routing number.* |
| `ADJUSTColumn` | `Public ReadOnly Property ADJUSTColumn() As DataColumn` | Typed accessor for the institution's adjustment routing-number column.* |
| `ADJUST_EXTColumn` | `Public ReadOnly Property ADJUST_EXTColumn() As DataColumn` | Typed accessor for the extension/suffix appended to the adjustment routing number.* |
| `WIREPHONEColumn` | `Public ReadOnly Property WIREPHONEColumn() As DataColumn` | Typed accessor for the institution's wire-transfer confirmation phone-number column.* |
| `WIREPHONE_EXTColumn` | `Public ReadOnly Property WIREPHONE_EXTColumn() As DataColumn` | Typed accessor for the extension of the wire-transfer confirmation phone number.* |
| `SWIFTColumn` | `Public ReadOnly Property SWIFTColumn() As DataColumn` | Typed accessor for the institution's SWIFT code column. |
| `TELEXColumn` | `Public ReadOnly Property TELEXColumn() As DataColumn` | Typed accessor for the institution's telex-identifier column.* |
| `OLDMICRColumn` | `Public ReadOnly Property OLDMICRColumn() As DataColumn` | Typed accessor for the institution's prior/legacy MICR routing number, retained for historical matching.* |
| `HOMEPAGEColumn` | `Public ReadOnly Property HOMEPAGEColumn() As DataColumn` | Typed accessor for the institution's homepage URL column. |
| `EMAILColumn` | `Public ReadOnly Property EMAILColumn() As DataColumn` | Typed accessor for the institution's contact-email column. |
| `NOTESColumn` | `Public ReadOnly Property NOTESColumn() As DataColumn` | Typed accessor for the free-form notes column. |
| `LYONS_NOTEColumn` | `Public ReadOnly Property LYONS_NOTEColumn() As DataColumn` | Typed accessor for a free-form note field specific to the Lyons system.* |
| `CUST_SVCColumn` | `Public ReadOnly Property CUST_SVCColumn() As DataColumn` | Typed accessor for the institution's customer-service phone/contact column.* |
| `UniWireColumn` | `Public ReadOnly Property UniWireColumn() As DataColumn` | Typed accessor for the institution's Universal Wire routing-code column.* |
| `LABAOld2Column` | `Public ReadOnly Property LABAOld2Column() As DataColumn` | Typed accessor for a legacy ABA routing number retained as an alternate value (variant 2).* |
| `LABAOld3Column` | `Public ReadOnly Property LABAOld3Column() As DataColumn` | Typed accessor for a legacy ABA routing number retained as an alternate value (variant 3).* |
| `LACHOldColumn` | `Public ReadOnly Property LACHOldColumn() As DataColumn` | Typed accessor for a prior legacy ACH routing number.* |
| `LACHOld2Column` | `Public ReadOnly Property LACHOld2Column() As DataColumn` | Typed accessor for a legacy ACH routing number retained as an alternate value (variant 2).* |
| `LACHOld3Column` | `Public ReadOnly Property LACHOld3Column() As DataColumn` | Typed accessor for a legacy ACH routing number retained as an alternate value (variant 3).* |
| `Count` | `Public ReadOnly Property Count() As Integer` | The number of rows currently in the table. |
| `Item(index)` | `Public Default ReadOnly Property Item(ByVal index As Integer) As InstitutionRow` | Default indexer that returns the strongly-typed `InstitutionRow` at the given row index. |
| `InstitutionRowChanging` | `Public Event InstitutionRowChanging As InstitutionRowChangeEventHandler` | Raised before a row in the table changes. |
| `InstitutionRowChanged` | `Public Event InstitutionRowChanged As InstitutionRowChangeEventHandler` | Raised after a row in the table has changed. |
| `InstitutionRowDeleting` | `Public Event InstitutionRowDeleting As InstitutionRowChangeEventHandler` | Raised before a row in the table is deleted. |
| `InstitutionRowDeleted` | `Public Event InstitutionRowDeleted As InstitutionRowChangeEventHandler` | Raised after a row in the table has been deleted. |
| `NewInstitutionRow` | `Public Function NewInstitutionRow() As InstitutionRow` | Creates a new, unattached `InstitutionRow` with the table's schema. |
| `AddInstitutionRow(row)` | `Public Overloads Sub AddInstitutionRow(ByVal row As InstitutionRow)` | Adds an existing `InstitutionRow` to the table. |
| `AddInstitutionRow(values)` | `Public Overloads Function AddInstitutionRow(ByVal LYONS_ID As String, ByVal LOC As String, ByVal NAME As String, ByVal MICR As String, ByVal FRAC As String, ByVal ACH As String, ByVal PHYS_ADDR1 As String, ByVal PHYS_CITY As String, ByVal PHYS_STATE As String, ByVal PHYS_ZIP As String, ByVal PHONE As String, ByVal FAX As String, ByVal FEDWIRE As String, ByVal CORR_RTNO As String, ByVal _RETURN As String, ByVal RETURN_EXT As String, ByVal ADJUST As String, ByVal ADJUST_EXT As String, ByVal WIREPHONE As String, ByVal WIREPHONE_EXT As String, ByVal SWIFT As String, ByVal TELEX As String, ByVal OLDMICR As String, ByVal HOMEPAGE As String, ByVal EMAIL As String, ByVal NOTES As String, ByVal LYONS_NOTE As String, ByVal CUST_SVC As String, ByVal UniWire As String, ByVal LABAOld2 As String, ByVal LABAOld3 As String, ByVal LACHOld As String, ByVal LACHOld2 As String, ByVal LACHOld3 As String) As InstitutionRow` | Creates a new `InstitutionRow`, populates all 34 columns from the supplied positional values, adds it to the table, and returns it. |
| `RemoveInstitutionRow` | `Public Sub RemoveInstitutionRow(ByVal row As InstitutionRow)` | Removes the specified `InstitutionRow` from the table. |

## 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`