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