Skip to content

Institutions

API reference for Institutions.

Purpose

  • Legacy machine-generated typed DataSet (from an Institutions.xsd schema, produced by the Visual Studio DataSet designer) representing institution and financial-institution rows through a single typed InstitutionDataTable and its nested InstitutionRow type.
  • Structurally separate from the BOF business-object pattern used elsewhere in this library; no consumer of this type was found within SAIF.Business.View.Provider.

Context

  • Namespace: SAIF.Business.View.Provider
  • Assembly/package: SAIF.BOF.Business.View.Provider

Public members

Institutions DataSet members

Member Signature Purpose
New Public Sub New() Constructs the typed Institutions dataset and initializes its single InstitutionDataTable.
Institution Public ReadOnly Property Institution() As InstitutionDataTable Returns the typed Institution table instance stored in the dataset.
SchemaSerializationMode Public Overrides Property SchemaSerializationMode() As Global.System.Data.SchemaSerializationMode Gets or sets whether the dataset serializes schema information with its XML payload.
Tables Public Shadows ReadOnly Property Tables() As Global.System.Data.DataTableCollection Returns the underlying DataTableCollection for the dataset.
Relations Public Shadows ReadOnly Property Relations() As Global.System.Data.DataRelationCollection Returns the dataset's relation collection.
Clone Public Overrides Function Clone() As Global.System.Data.DataSet Creates a typed clone of the dataset.
GetTypedDataSetSchema Public Shared Function GetTypedDataSetSchema(ByVal xs As Global.System.Xml.Schema.XmlSchemaSet) As Global.System.Xml.Schema.XmlSchemaComplexType Returns the XML schema metadata for the typed dataset.

InstitutionDataTable members

Member Signature Purpose
InstitutionDataTable Partial Public Class InstitutionDataTable Inherits Global.System.Data.TypedTableBase(Of InstitutionRow) Typed table class that stores InstitutionRow instances.
New Public Sub New() Constructs an empty typed InstitutionDataTable.
LYONS_IDColumn Public ReadOnly Property LYONS_IDColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for LYONS_ID.
LOCColumn Public ReadOnly Property LOCColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for LOC.
NAMEColumn Public ReadOnly Property NAMEColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for NAME.
MICRColumn Public ReadOnly Property MICRColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for MICR.
FRACColumn Public ReadOnly Property FRACColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for FRAC.
ACHColumn Public ReadOnly Property ACHColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for ACH.
PHYS_ADDR1Column Public ReadOnly Property PHYS_ADDR1Column() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for PHYS_ADDR1.
PHYS_CITYColumn Public ReadOnly Property PHYS_CITYColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for PHYS_CITY.
PHYS_STATEColumn Public ReadOnly Property PHYS_STATEColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for PHYS_STATE.
PHYS_ZIPColumn Public ReadOnly Property PHYS_ZIPColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for PHYS_ZIP.
PHONEColumn Public ReadOnly Property PHONEColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for PHONE.
FAXColumn Public ReadOnly Property FAXColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for FAX.
FEDWIREColumn Public ReadOnly Property FEDWIREColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for FEDWIRE.
CORR_RTNOColumn Public ReadOnly Property CORR_RTNOColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for CORR_RTNO.
_RETURNColumn Public ReadOnly Property _RETURNColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for _RETURN.
RETURN_EXTColumn Public ReadOnly Property RETURN_EXTColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for RETURN_EXT.
ADJUSTColumn Public ReadOnly Property ADJUSTColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for ADJUST.
ADJUST_EXTColumn Public ReadOnly Property ADJUST_EXTColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for ADJUST_EXT.
WIREPHONEColumn Public ReadOnly Property WIREPHONEColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for WIREPHONE.
WIREPHONE_EXTColumn Public ReadOnly Property WIREPHONE_EXTColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for WIREPHONE_EXT.
SWIFTColumn Public ReadOnly Property SWIFTColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for SWIFT.
TELEXColumn Public ReadOnly Property TELEXColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for TELEX.
OLDMICRColumn Public ReadOnly Property OLDMICRColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for OLDMICR.
HOMEPAGEColumn Public ReadOnly Property HOMEPAGEColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for HOMEPAGE.
EMAILColumn Public ReadOnly Property EMAILColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for EMAIL.
NOTESColumn Public ReadOnly Property NOTESColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for NOTES.
LYONS_NOTEColumn Public ReadOnly Property LYONS_NOTEColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for LYONS_NOTE.
CUST_SVCColumn Public ReadOnly Property CUST_SVCColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for CUST_SVC.
UniWireColumn Public ReadOnly Property UniWireColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for UniWire.
LABAOld2Column Public ReadOnly Property LABAOld2Column() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for LABAOld2.
LABAOld3Column Public ReadOnly Property LABAOld3Column() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for LABAOld3.
LACHOldColumn Public ReadOnly Property LACHOldColumn() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for LACHOld.
LACHOld2Column Public ReadOnly Property LACHOld2Column() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for LACHOld2.
LACHOld3Column Public ReadOnly Property LACHOld3Column() As Global.System.Data.DataColumn Returns the typed DataColumn descriptor for LACHOld3.
Count Public ReadOnly Property Count() As Integer Returns the number of typed rows currently in the table.
Item(index) Public Default ReadOnly Property Item(ByVal index As Integer) As InstitutionRow Returns the typed row at the supplied zero-based index.
InstitutionRowChanging Public Event InstitutionRowChanging As InstitutionRowChangeEventHandler Raised before a row change is committed.
InstitutionRowChanged Public Event InstitutionRowChanged As InstitutionRowChangeEventHandler Raised after a row change is committed.
InstitutionRowDeleting Public Event InstitutionRowDeleting As InstitutionRowChangeEventHandler Raised before a row delete is committed.
InstitutionRowDeleted Public Event InstitutionRowDeleted As InstitutionRowChangeEventHandler Raised after a row delete is committed.
AddInstitutionRow(row) Public Overloads Sub AddInstitutionRow(ByVal row As InstitutionRow) Adds an existing typed row 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, populates, adds, and returns a new typed row using the full column set.
Clone Public Overrides Function Clone() As Global.System.Data.DataTable Creates a typed clone of the table.
NewInstitutionRow Public Function NewInstitutionRow() As InstitutionRow Creates a new detached typed row instance for this table.
RemoveInstitutionRow Public Sub RemoveInstitutionRow(ByVal row As InstitutionRow) Removes the supplied typed row from the table.
GetTypedTableSchema Public Shared Function GetTypedTableSchema(ByVal xs As Global.System.Xml.Schema.XmlSchemaSet) As Global.System.Xml.Schema.XmlSchemaComplexType Returns the XML schema metadata for the typed table.

InstitutionRow members

Member Signature Purpose
InstitutionRow Partial Public Class InstitutionRow Inherits Global.System.Data.DataRow Typed row class for one Institution record.
LYONS_ID Public Property LYONS_ID() As String Gets or sets the LYONS_ID column value for the current row.
LOC Public Property LOC() As String Gets or sets the LOC column value for the current row.
NAME Public Property NAME() As String Gets or sets the NAME column value for the current row.
MICR Public Property MICR() As String Gets or sets the MICR column value for the current row.
FRAC Public Property FRAC() As String Gets or sets the FRAC column value for the current row.
ACH Public Property ACH() As String Gets or sets the ACH column value for the current row.
PHYS_ADDR1 Public Property PHYS_ADDR1() As String Gets or sets the PHYS_ADDR1 column value for the current row.
PHYS_CITY Public Property PHYS_CITY() As String Gets or sets the PHYS_CITY column value for the current row.
PHYS_STATE Public Property PHYS_STATE() As String Gets or sets the PHYS_STATE column value for the current row.
PHYS_ZIP Public Property PHYS_ZIP() As String Gets or sets the PHYS_ZIP column value for the current row.
PHONE Public Property PHONE() As String Gets or sets the PHONE column value for the current row.
FAX Public Property FAX() As String Gets or sets the FAX column value for the current row.
FEDWIRE Public Property FEDWIRE() As String Gets or sets the FEDWIRE column value for the current row.
CORR_RTNO Public Property CORR_RTNO() As String Gets or sets the CORR_RTNO column value for the current row.
_RETURN Public Property _RETURN() As String Gets or sets the _RETURN column value for the current row.
RETURN_EXT Public Property RETURN_EXT() As String Gets or sets the RETURN_EXT column value for the current row.
ADJUST Public Property ADJUST() As String Gets or sets the ADJUST column value for the current row.
ADJUST_EXT Public Property ADJUST_EXT() As String Gets or sets the ADJUST_EXT column value for the current row.
WIREPHONE Public Property WIREPHONE() As String Gets or sets the WIREPHONE column value for the current row.
WIREPHONE_EXT Public Property WIREPHONE_EXT() As String Gets or sets the WIREPHONE_EXT column value for the current row.
SWIFT Public Property SWIFT() As String Gets or sets the SWIFT column value for the current row.
TELEX Public Property TELEX() As String Gets or sets the TELEX column value for the current row.
OLDMICR Public Property OLDMICR() As String Gets or sets the OLDMICR column value for the current row.
HOMEPAGE Public Property HOMEPAGE() As String Gets or sets the HOMEPAGE column value for the current row.
EMAIL Public Property EMAIL() As String Gets or sets the EMAIL column value for the current row.
NOTES Public Property NOTES() As String Gets or sets the NOTES column value for the current row.
LYONS_NOTE Public Property LYONS_NOTE() As String Gets or sets the LYONS_NOTE column value for the current row.
CUST_SVC Public Property CUST_SVC() As String Gets or sets the CUST_SVC column value for the current row.
UniWire Public Property UniWire() As String Gets or sets the UniWire column value for the current row.
LABAOld2 Public Property LABAOld2() As String Gets or sets the LABAOld2 column value for the current row.
LABAOld3 Public Property LABAOld3() As String Gets or sets the LABAOld3 column value for the current row.
LACHOld Public Property LACHOld() As String Gets or sets the LACHOld column value for the current row.
LACHOld2 Public Property LACHOld2() As String Gets or sets the LACHOld2 column value for the current row.
LACHOld3 Public Property LACHOld3() As String Gets or sets the LACHOld3 column value for the current row.
IsLYONS_IDNull Public Function IsLYONS_IDNull() As Boolean Returns whether LYONS_ID currently contains DBNull.
SetLYONS_IDNull Public Sub SetLYONS_IDNull() Sets LYONS_ID to DBNull.
IsLOCNull Public Function IsLOCNull() As Boolean Returns whether LOC currently contains DBNull.
SetLOCNull Public Sub SetLOCNull() Sets LOC to DBNull.
IsNAMENull Public Function IsNAMENull() As Boolean Returns whether NAME currently contains DBNull.
SetNAMENull Public Sub SetNAMENull() Sets NAME to DBNull.
IsMICRNull Public Function IsMICRNull() As Boolean Returns whether MICR currently contains DBNull.
SetMICRNull Public Sub SetMICRNull() Sets MICR to DBNull.
IsFRACNull Public Function IsFRACNull() As Boolean Returns whether FRAC currently contains DBNull.
SetFRACNull Public Sub SetFRACNull() Sets FRAC to DBNull.
IsACHNull Public Function IsACHNull() As Boolean Returns whether ACH currently contains DBNull.
SetACHNull Public Sub SetACHNull() Sets ACH to DBNull.
IsPHYS_ADDR1Null Public Function IsPHYS_ADDR1Null() As Boolean Returns whether PHYS_ADDR1 currently contains DBNull.
SetPHYS_ADDR1Null Public Sub SetPHYS_ADDR1Null() Sets PHYS_ADDR1 to DBNull.
IsPHYS_CITYNull Public Function IsPHYS_CITYNull() As Boolean Returns whether PHYS_CITY currently contains DBNull.
SetPHYS_CITYNull Public Sub SetPHYS_CITYNull() Sets PHYS_CITY to DBNull.
IsPHYS_STATENull Public Function IsPHYS_STATENull() As Boolean Returns whether PHYS_STATE currently contains DBNull.
SetPHYS_STATENull Public Sub SetPHYS_STATENull() Sets PHYS_STATE to DBNull.
IsPHYS_ZIPNull Public Function IsPHYS_ZIPNull() As Boolean Returns whether PHYS_ZIP currently contains DBNull.
SetPHYS_ZIPNull Public Sub SetPHYS_ZIPNull() Sets PHYS_ZIP to DBNull.
IsPHONENull Public Function IsPHONENull() As Boolean Returns whether PHONE currently contains DBNull.
SetPHONENull Public Sub SetPHONENull() Sets PHONE to DBNull.
IsFAXNull Public Function IsFAXNull() As Boolean Returns whether FAX currently contains DBNull.
SetFAXNull Public Sub SetFAXNull() Sets FAX to DBNull.
IsFEDWIRENull Public Function IsFEDWIRENull() As Boolean Returns whether FEDWIRE currently contains DBNull.
SetFEDWIRENull Public Sub SetFEDWIRENull() Sets FEDWIRE to DBNull.
IsCORR_RTNONull Public Function IsCORR_RTNONull() As Boolean Returns whether CORR_RTNO currently contains DBNull.
SetCORR_RTNONull Public Sub SetCORR_RTNONull() Sets CORR_RTNO to DBNull.
Is_RETURNNull Public Function Is_RETURNNull() As Boolean Returns whether _RETURN currently contains DBNull.
Set_RETURNNull Public Sub Set_RETURNNull() Sets _RETURN to DBNull.
IsRETURN_EXTNull Public Function IsRETURN_EXTNull() As Boolean Returns whether RETURN_EXT currently contains DBNull.
SetRETURN_EXTNull Public Sub SetRETURN_EXTNull() Sets RETURN_EXT to DBNull.
IsADJUSTNull Public Function IsADJUSTNull() As Boolean Returns whether ADJUST currently contains DBNull.
SetADJUSTNull Public Sub SetADJUSTNull() Sets ADJUST to DBNull.
IsADJUST_EXTNull Public Function IsADJUST_EXTNull() As Boolean Returns whether ADJUST_EXT currently contains DBNull.
SetADJUST_EXTNull Public Sub SetADJUST_EXTNull() Sets ADJUST_EXT to DBNull.
IsWIREPHONENull Public Function IsWIREPHONENull() As Boolean Returns whether WIREPHONE currently contains DBNull.
SetWIREPHONENull Public Sub SetWIREPHONENull() Sets WIREPHONE to DBNull.
IsWIREPHONE_EXTNull Public Function IsWIREPHONE_EXTNull() As Boolean Returns whether WIREPHONE_EXT currently contains DBNull.
SetWIREPHONE_EXTNull Public Sub SetWIREPHONE_EXTNull() Sets WIREPHONE_EXT to DBNull.
IsSWIFTNull Public Function IsSWIFTNull() As Boolean Returns whether SWIFT currently contains DBNull.
SetSWIFTNull Public Sub SetSWIFTNull() Sets SWIFT to DBNull.
IsTELEXNull Public Function IsTELEXNull() As Boolean Returns whether TELEX currently contains DBNull.
SetTELEXNull Public Sub SetTELEXNull() Sets TELEX to DBNull.
IsOLDMICRNull Public Function IsOLDMICRNull() As Boolean Returns whether OLDMICR currently contains DBNull.
SetOLDMICRNull Public Sub SetOLDMICRNull() Sets OLDMICR to DBNull.
IsHOMEPAGENull Public Function IsHOMEPAGENull() As Boolean Returns whether HOMEPAGE currently contains DBNull.
SetHOMEPAGENull Public Sub SetHOMEPAGENull() Sets HOMEPAGE to DBNull.
IsEMAILNull Public Function IsEMAILNull() As Boolean Returns whether EMAIL currently contains DBNull.
SetEMAILNull Public Sub SetEMAILNull() Sets EMAIL to DBNull.
IsNOTESNull Public Function IsNOTESNull() As Boolean Returns whether NOTES currently contains DBNull.
SetNOTESNull Public Sub SetNOTESNull() Sets NOTES to DBNull.
IsLYONS_NOTENull Public Function IsLYONS_NOTENull() As Boolean Returns whether LYONS_NOTE currently contains DBNull.
SetLYONS_NOTENull Public Sub SetLYONS_NOTENull() Sets LYONS_NOTE to DBNull.
IsCUST_SVCNull Public Function IsCUST_SVCNull() As Boolean Returns whether CUST_SVC currently contains DBNull.
SetCUST_SVCNull Public Sub SetCUST_SVCNull() Sets CUST_SVC to DBNull.
IsUniWireNull Public Function IsUniWireNull() As Boolean Returns whether UniWire currently contains DBNull.
SetUniWireNull Public Sub SetUniWireNull() Sets UniWire to DBNull.
IsLABAOld2Null Public Function IsLABAOld2Null() As Boolean Returns whether LABAOld2 currently contains DBNull.
SetLABAOld2Null Public Sub SetLABAOld2Null() Sets LABAOld2 to DBNull.
IsLABAOld3Null Public Function IsLABAOld3Null() As Boolean Returns whether LABAOld3 currently contains DBNull.
SetLABAOld3Null Public Sub SetLABAOld3Null() Sets LABAOld3 to DBNull.
IsLACHOldNull Public Function IsLACHOldNull() As Boolean Returns whether LACHOld currently contains DBNull.
SetLACHOldNull Public Sub SetLACHOldNull() Sets LACHOld to DBNull.
IsLACHOld2Null Public Function IsLACHOld2Null() As Boolean Returns whether LACHOld2 currently contains DBNull.
SetLACHOld2Null Public Sub SetLACHOld2Null() Sets LACHOld2 to DBNull.
IsLACHOld3Null Public Function IsLACHOld3Null() As Boolean Returns whether LACHOld3 currently contains DBNull.
SetLACHOld3Null Public Sub SetLACHOld3Null() Sets LACHOld3 to DBNull.

Generated event and event-args types

Member Signature Purpose
InstitutionRowChangeEventHandler Public Delegate Sub InstitutionRowChangeEventHandler(ByVal sender As Object, ByVal e As InstitutionRowChangeEvent) Delegate signature used by the table's row-change events.
InstitutionRowChangeEvent Public Class InstitutionRowChangeEvent Inherits Global.System.EventArgs Event-args type carrying the changed row and DataRowAction.
New Public Sub New(ByVal row As InstitutionRow, ByVal action As Global.System.Data.DataRowAction) Creates a typed row-change event instance.
Row Public ReadOnly Property Row() As InstitutionRow Returns the affected row.
Action Public ReadOnly Property Action() As Global.System.Data.DataRowAction Returns the DataRowAction that triggered the event.

Behavioral notes

  • This is a designer-generated typed DataSet/DataTable/DataRow triad, not a BOF business object: it does not inherit clsBusinessBase/clsBusinessCollection, has no IBusinessCriteria, and performs no data-portal or SQL retrieval of its own.
  • No consumer of this type was found elsewhere in SAIF.Business.View.Provider; it remains a standalone generated artifact in this assembly.

Constraints and usage notes

  • As with all Visual Studio designer typed DataSet files, Institutions.Designer.vb should be treated as generated output; schema changes belong in the underlying .xsd and should then be regenerated.

Sources

  • Business\SAIF.Business.View.Provider\Institutions.Designer.vb