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