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

# Institutions.InstitutionDataTable

`Institutions.InstitutionDataTable` is the generated typed table that exposes institution reference rows within the `Institutions` dataset.

## Purpose
- Provide typed table access to institution reference rows.
- Publish strongly typed row-creation, addition, removal, and schema helpers generated from the dataset definition.

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

## Public members
| Member | Signature | Purpose |
| --- | --- | --- |
| `Count` | `Public ReadOnly Property Count() As Integer` | Reports how many typed institution rows are present. |
| `Item` | `Public Default ReadOnly Property Item(ByVal index As Integer) As InstitutionRow` | Returns the typed institution row at the given zero-based position in the table. |
| `InstitutionRowChanging` | `Public Event InstitutionRowChanging As InstitutionRowChangeEventHandler` | Raised before a row change is applied, letting subscribers inspect or react to the pending change. |
| `InstitutionRowChanged` | `Public Event InstitutionRowChanged As InstitutionRowChangeEventHandler` | Raised after a row change has been applied. |
| `InstitutionRowDeleting` | `Public Event InstitutionRowDeleting As InstitutionRowChangeEventHandler` | Raised before a row deletion is applied. |
| `InstitutionRowDeleted` | `Public Event InstitutionRowDeleted As InstitutionRowChangeEventHandler` | Raised after a row deletion has been applied. |
| `AddInstitutionRow` (row) | `Public Overloads Sub AddInstitutionRow(ByVal row As InstitutionRow)` | Adds an existing typed institution row instance 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 and adds a new typed institution row populated from one value per table column, returning the new row. |
| `NewInstitutionRow` | `Public Function NewInstitutionRow() As InstitutionRow` | Creates a new detached typed institution row instance not yet added to the table. |
| `RemoveInstitutionRow` | `Public Sub RemoveInstitutionRow(ByVal row As InstitutionRow)` | Removes a typed institution row from the table. |
| `Clone` | `Public Overrides Function Clone() As DataTable` | Creates a schema-only copy of the typed table, re-applying typed column initialization. |
| `GetTypedTableSchema` | `Public Shared Function GetTypedTableSchema(ByVal xs As XmlSchemaSet) As XmlSchemaComplexType` | Publishes the generated XML schema metadata for the typed table. |
| `LYONS_IDColumn` | `Public ReadOnly Property LYONS_IDColumn() As DataColumn` | Exposes the generated `DataColumn` for the LYONS_ID field. Internal identifier used by the historical Lyons reference system to uniquely identify the institution row. |
| `LOCColumn` | `Public ReadOnly Property LOCColumn() As DataColumn` | Exposes the generated `DataColumn` for the LOC field. Location code distinguishing a specific branch or office of the institution. |
| `NAMEColumn` | `Public ReadOnly Property NAMEColumn() As DataColumn` | Exposes the generated `DataColumn` for the NAME field. Display name of the financial institution. |
| `MICRColumn` | `Public ReadOnly Property MICRColumn() As DataColumn` | Exposes the generated `DataColumn` for the MICR field. MICR routing/transit number used for check-processing identification of the institution. |
| `FRACColumn` | `Public ReadOnly Property FRACColumn() As DataColumn` | Exposes the generated `DataColumn` for the FRAC field. Fractional (check-routing) component of the institution MICR number. |
| `ACHColumn` | `Public ReadOnly Property ACHColumn() As DataColumn` | Exposes the generated `DataColumn` for the ACH field. ACH routing number used for electronic funds transfer to the institution. |
| `PHYS_ADDR1Column` | `Public ReadOnly Property PHYS_ADDR1Column() As DataColumn` | Exposes the generated `DataColumn` for the PHYS_ADDR1 field. Street address line of the institution physical location. |
| `PHYS_CITYColumn` | `Public ReadOnly Property PHYS_CITYColumn() As DataColumn` | Exposes the generated `DataColumn` for the PHYS_CITY field. City of the institution physical address. |
| `PHYS_STATEColumn` | `Public ReadOnly Property PHYS_STATEColumn() As DataColumn` | Exposes the generated `DataColumn` for the PHYS_STATE field. State of the institution physical address. |
| `PHYS_ZIPColumn` | `Public ReadOnly Property PHYS_ZIPColumn() As DataColumn` | Exposes the generated `DataColumn` for the PHYS_ZIP field. ZIP/postal code of the institution physical address. |
| `PHONEColumn` | `Public ReadOnly Property PHONEColumn() As DataColumn` | Exposes the generated `DataColumn` for the PHONE field. Primary phone number for the institution. |
| `FAXColumn` | `Public ReadOnly Property FAXColumn() As DataColumn` | Exposes the generated `DataColumn` for the FAX field. Fax number for the institution. |
| `FEDWIREColumn` | `Public ReadOnly Property FEDWIREColumn() As DataColumn` | Exposes the generated `DataColumn` for the FEDWIRE field. Fedwire routing number used for Federal Reserve wire transfers to the institution. |
| `CORR_RTNOColumn` | `Public ReadOnly Property CORR_RTNOColumn() As DataColumn` | Exposes the generated `DataColumn` for the CORR_RTNO field. Routing number of the institution correspondent bank. |
| `_RETURNColumn` | `Public ReadOnly Property _RETURNColumn() As DataColumn` | Exposes the generated `DataColumn` for the _RETURN field. Return-item routing/handling code recorded for the institution. |
| `RETURN_EXTColumn` | `Public ReadOnly Property RETURN_EXTColumn() As DataColumn` | Exposes the generated `DataColumn` for the RETURN_EXT field. Phone extension associated with the institution return-item contact. |
| `ADJUSTColumn` | `Public ReadOnly Property ADJUSTColumn() As DataColumn` | Exposes the generated `DataColumn` for the ADJUST field. Adjustment routing/handling code recorded for the institution. |
| `ADJUST_EXTColumn` | `Public ReadOnly Property ADJUST_EXTColumn() As DataColumn` | Exposes the generated `DataColumn` for the ADJUST_EXT field. Phone extension associated with the institution adjustments contact. |
| `WIREPHONEColumn` | `Public ReadOnly Property WIREPHONEColumn() As DataColumn` | Exposes the generated `DataColumn` for the WIREPHONE field. Phone number for the institution wire-transfer department. |
| `WIREPHONE_EXTColumn` | `Public ReadOnly Property WIREPHONE_EXTColumn() As DataColumn` | Exposes the generated `DataColumn` for the WIREPHONE_EXT field. Phone extension for the institution wire-transfer department. |
| `SWIFTColumn` | `Public ReadOnly Property SWIFTColumn() As DataColumn` | Exposes the generated `DataColumn` for the SWIFT field. SWIFT/BIC code used for international wire transfers to the institution. |
| `TELEXColumn` | `Public ReadOnly Property TELEXColumn() As DataColumn` | Exposes the generated `DataColumn` for the TELEX field. Telex number historically used for message routing to the institution. |
| `OLDMICRColumn` | `Public ReadOnly Property OLDMICRColumn() As DataColumn` | Exposes the generated `DataColumn` for the OLDMICR field. Prior/legacy MICR routing number retained for historical reference. |
| `HOMEPAGEColumn` | `Public ReadOnly Property HOMEPAGEColumn() As DataColumn` | Exposes the generated `DataColumn` for the HOMEPAGE field. URL of the institution website. |
| `EMAILColumn` | `Public ReadOnly Property EMAILColumn() As DataColumn` | Exposes the generated `DataColumn` for the EMAIL field. Contact email address for the institution. |
| `NOTESColumn` | `Public ReadOnly Property NOTESColumn() As DataColumn` | Exposes the generated `DataColumn` for the NOTES field. Free-text notes recorded about the institution. |
| `LYONS_NOTEColumn` | `Public ReadOnly Property LYONS_NOTEColumn() As DataColumn` | Exposes the generated `DataColumn` for the LYONS_NOTE field. Free-text note specific to the legacy Lyons reference system. |
| `CUST_SVCColumn` | `Public ReadOnly Property CUST_SVCColumn() As DataColumn` | Exposes the generated `DataColumn` for the CUST_SVC field. Customer-service phone number or contact information for the institution. |
| `UniWireColumn` | `Public ReadOnly Property UniWireColumn() As DataColumn` | Exposes the generated `DataColumn` for the UniWire field. Universal wire-routing identifier recorded for the institution. |
| `LABAOld2Column` | `Public ReadOnly Property LABAOld2Column() As DataColumn` | Exposes the generated `DataColumn` for the LABAOld2 field. Legacy ABA routing number (second historical variant) retained for reference. |
| `LABAOld3Column` | `Public ReadOnly Property LABAOld3Column() As DataColumn` | Exposes the generated `DataColumn` for the LABAOld3 field. Legacy ABA routing number (third historical variant) retained for reference. |
| `LACHOldColumn` | `Public ReadOnly Property LACHOldColumn() As DataColumn` | Exposes the generated `DataColumn` for the LACHOld field. Legacy ACH routing number retained for historical reference. |
| `LACHOld2Column` | `Public ReadOnly Property LACHOld2Column() As DataColumn` | Exposes the generated `DataColumn` for the LACHOld2 field. Legacy ACH routing number (second historical variant) retained for reference. |
| `LACHOld3Column` | `Public ReadOnly Property LACHOld3Column() As DataColumn` | Exposes the generated `DataColumn` for the LACHOld3 field. Legacy ACH routing number (third historical variant) retained for reference. |

## Behavioral notes
- The generated table exposes one typed row class, `InstitutionRow`, plus column accessors for every dataset field.
- Its surface follows the standard .NET typed-dataset pattern rather than BOF business-object conventions.
- Column purposes below 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 expect this type to change only when the underlying dataset definition changes.

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