InstitutionRow¶

InstitutionRow is the designer-generated typed DataRow nested in Institutions.InstitutionDataTable, exposing a strongly-typed String property for every column of a single financial-institution reference record (routing/MICR/SWIFT codes, address, phone/fax, and related legacy/alternate-code fields), along with Is<Column>Null/Set<Column>Null helper pairs for each nullable column.

Purpose¶

Expose strongly-typed read/write access to each column of a single institution record (e.g., LYONS_ID, LOC, NAME, MICR, SWIFT, address/phone/fax fields).*
Provide Is<Column>Null()/Set<Column>Null() method pairs for each column so callers can check for and set DBNull values without using ADO.NET's untyped API directly.

Context¶

Namespace: SAIF.Business.Policy
Assembly/package: SAIF.Business.Policy

Public members¶

Member	Signature	Purpose
`LYONS_ID`	`Public Property LYONS_ID() As String`	The institution's internal identifier (Lyons system ID).*
`LOC`	`Public Property LOC() As String`	The institution's location code.*
`NAME`	`Public Property NAME() As String`	The institution's name.
`MICR`	`Public Property MICR() As String`	The institution's MICR routing number.
`FRAC`	`Public Property FRAC() As String`	The institution's fractional routing designation.*
`ACH`	`Public Property ACH() As String`	The institution's ACH routing number.
`PHYS_ADDR1`	`Public Property PHYS_ADDR1() As String`	The institution's physical street address.
`PHYS_CITY`	`Public Property PHYS_CITY() As String`	The institution's city.
`PHYS_STATE`	`Public Property PHYS_STATE() As String`	The institution's state.
`PHYS_ZIP`	`Public Property PHYS_ZIP() As String`	The institution's ZIP code.
`PHONE`	`Public Property PHONE() As String`	The institution's phone number.
`FAX`	`Public Property FAX() As String`	The institution's fax number.
`FEDWIRE`	`Public Property FEDWIRE() As String`	The institution's Fedwire routing number.
`CORR_RTNO`	`Public Property CORR_RTNO() As String`	The institution's correspondent routing number.*
`_RETURN`	`Public Property _RETURN() As String`	The institution's return-item routing number, exposed via the `RETURN` column; renamed `_RETURN` in code because `RETURN` is a VB.NET reserved word.*
`RETURN_EXT`	`Public Property RETURN_EXT() As String`	Extension/suffix appended to the return-item routing number.*
`ADJUST`	`Public Property ADJUST() As String`	The institution's adjustment routing number.*
`ADJUST_EXT`	`Public Property ADJUST_EXT() As String`	Extension/suffix appended to the adjustment routing number.*
`WIREPHONE`	`Public Property WIREPHONE() As String`	Phone number used to confirm the institution's incoming wire transfers.*
`WIREPHONE_EXT`	`Public Property WIREPHONE_EXT() As String`	Extension for the wire-transfer confirmation phone number.*
`SWIFT`	`Public Property SWIFT() As String`	The institution's SWIFT code.
`TELEX`	`Public Property TELEX() As String`	The institution's telex identifier.*
`OLDMICR`	`Public Property OLDMICR() As String`	The institution's prior/legacy MICR routing number, retained for historical matching.*
`HOMEPAGE`	`Public Property HOMEPAGE() As String`	The institution's homepage URL.
`EMAIL`	`Public Property EMAIL() As String`	The institution's contact email address.
`NOTES`	`Public Property NOTES() As String`	Free-form notes about the institution.
`LYONS_NOTE`	`Public Property LYONS_NOTE() As String`	Free-form note field specific to the Lyons system.*
`CUST_SVC`	`Public Property CUST_SVC() As String`	The institution's customer-service phone/contact.*
`UniWire`	`Public Property UniWire() As String`	The institution's Universal Wire routing code.*
`LABAOld2`	`Public Property LABAOld2() As String`	A legacy ABA routing number retained as an alternate value (variant 2).*
`LABAOld3`	`Public Property LABAOld3() As String`	A legacy ABA routing number retained as an alternate value (variant 3).*
`LACHOld`	`Public Property LACHOld() As String`	A prior legacy ACH routing number.*
`LACHOld2`	`Public Property LACHOld2() As String`	A legacy ACH routing number retained as an alternate value (variant 2).*
`LACHOld3`	`Public Property LACHOld3() As String`	A legacy ACH routing number retained as an alternate value (variant 3).*
`IsLYONS_IDNull` / `SetLYONS_IDNull`	`Public Function IsLYONS_IDNull() As Boolean` / `Public Sub SetLYONS_IDNull()`	Checks for/sets a `DBNull` value in the `LYONS_ID` column.
`IsLOCNull` / `SetLOCNull`	`Public Function IsLOCNull() As Boolean` / `Public Sub SetLOCNull()`	Checks for/sets a `DBNull` value in the `LOC` column.
`IsNAMENull` / `SetNAMENull`	`Public Function IsNAMENull() As Boolean` / `Public Sub SetNAMENull()`	Checks for/sets a `DBNull` value in the `NAME` column.
`IsMICRNull` / `SetMICRNull`	`Public Function IsMICRNull() As Boolean` / `Public Sub SetMICRNull()`	Checks for/sets a `DBNull` value in the `MICR` column.
`IsFRACNull` / `SetFRACNull`	`Public Function IsFRACNull() As Boolean` / `Public Sub SetFRACNull()`	Checks for/sets a `DBNull` value in the `FRAC` column.
`IsACHNull` / `SetACHNull`	`Public Function IsACHNull() As Boolean` / `Public Sub SetACHNull()`	Checks for/sets a `DBNull` value in the `ACH` column.
`IsPHYS_ADDR1Null` / `SetPHYS_ADDR1Null`	`Public Function IsPHYS_ADDR1Null() As Boolean` / `Public Sub SetPHYS_ADDR1Null()`	Checks for/sets a `DBNull` value in the `PHYS_ADDR1` column.
`IsPHYS_CITYNull` / `SetPHYS_CITYNull`	`Public Function IsPHYS_CITYNull() As Boolean` / `Public Sub SetPHYS_CITYNull()`	Checks for/sets a `DBNull` value in the `PHYS_CITY` column.
`IsPHYS_STATENull` / `SetPHYS_STATENull`	`Public Function IsPHYS_STATENull() As Boolean` / `Public Sub SetPHYS_STATENull()`	Checks for/sets a `DBNull` value in the `PHYS_STATE` column.
`IsPHYS_ZIPNull` / `SetPHYS_ZIPNull`	`Public Function IsPHYS_ZIPNull() As Boolean` / `Public Sub SetPHYS_ZIPNull()`	Checks for/sets a `DBNull` value in the `PHYS_ZIP` column.
`IsPHONENull` / `SetPHONENull`	`Public Function IsPHONENull() As Boolean` / `Public Sub SetPHONENull()`	Checks for/sets a `DBNull` value in the `PHONE` column.
`IsFAXNull` / `SetFAXNull`	`Public Function IsFAXNull() As Boolean` / `Public Sub SetFAXNull()`	Checks for/sets a `DBNull` value in the `FAX` column.
`IsFEDWIRENull` / `SetFEDWIRENull`	`Public Function IsFEDWIRENull() As Boolean` / `Public Sub SetFEDWIRENull()`	Checks for/sets a `DBNull` value in the `FEDWIRE` column.
`IsCORR_RTNONull` / `SetCORR_RTNONull`	`Public Function IsCORR_RTNONull() As Boolean` / `Public Sub SetCORR_RTNONull()`	Checks for/sets a `DBNull` value in the `CORR_RTNO` column.
`Is_RETURNNull` / `Set_RETURNNull`	`Public Function Is_RETURNNull() As Boolean` / `Public Sub Set_RETURNNull()`	Checks for/sets a `DBNull` value in the `RETURN` column.
`IsRETURN_EXTNull` / `SetRETURN_EXTNull`	`Public Function IsRETURN_EXTNull() As Boolean` / `Public Sub SetRETURN_EXTNull()`	Checks for/sets a `DBNull` value in the `RETURN_EXT` column.
`IsADJUSTNull` / `SetADJUSTNull`	`Public Function IsADJUSTNull() As Boolean` / `Public Sub SetADJUSTNull()`	Checks for/sets a `DBNull` value in the `ADJUST` column.
`IsADJUST_EXTNull` / `SetADJUST_EXTNull`	`Public Function IsADJUST_EXTNull() As Boolean` / `Public Sub SetADJUST_EXTNull()`	Checks for/sets a `DBNull` value in the `ADJUST_EXT` column.
`IsWIREPHONENull` / `SetWIREPHONENull`	`Public Function IsWIREPHONENull() As Boolean` / `Public Sub SetWIREPHONENull()`	Checks for/sets a `DBNull` value in the `WIREPHONE` column.
`IsWIREPHONE_EXTNull` / `SetWIREPHONE_EXTNull`	`Public Function IsWIREPHONE_EXTNull() As Boolean` / `Public Sub SetWIREPHONE_EXTNull()`	Checks for/sets a `DBNull` value in the `WIREPHONE_EXT` column.
`IsSWIFTNull` / `SetSWIFTNull`	`Public Function IsSWIFTNull() As Boolean` / `Public Sub SetSWIFTNull()`	Checks for/sets a `DBNull` value in the `SWIFT` column.
`IsTELEXNull` / `SetTELEXNull`	`Public Function IsTELEXNull() As Boolean` / `Public Sub SetTELEXNull()`	Checks for/sets a `DBNull` value in the `TELEX` column.
`IsOLDMICRNull` / `SetOLDMICRNull`	`Public Function IsOLDMICRNull() As Boolean` / `Public Sub SetOLDMICRNull()`	Checks for/sets a `DBNull` value in the `OLDMICR` column.
`IsHOMEPAGENull` / `SetHOMEPAGENull`	`Public Function IsHOMEPAGENull() As Boolean` / `Public Sub SetHOMEPAGENull()`	Checks for/sets a `DBNull` value in the `HOMEPAGE` column.
`IsEMAILNull` / `SetEMAILNull`	`Public Function IsEMAILNull() As Boolean` / `Public Sub SetEMAILNull()`	Checks for/sets a `DBNull` value in the `EMAIL` column.
`IsNOTESNull` / `SetNOTESNull`	`Public Function IsNOTESNull() As Boolean` / `Public Sub SetNOTESNull()`	Checks for/sets a `DBNull` value in the `NOTES` column.
`IsLYONS_NOTENull` / `SetLYONS_NOTENull`	`Public Function IsLYONS_NOTENull() As Boolean` / `Public Sub SetLYONS_NOTENull()`	Checks for/sets a `DBNull` value in the `LYONS_NOTE` column.
`IsCUST_SVCNull` / `SetCUST_SVCNull`	`Public Function IsCUST_SVCNull() As Boolean` / `Public Sub SetCUST_SVCNull()`	Checks for/sets a `DBNull` value in the `CUST_SVC` column.
`IsUniWireNull` / `SetUniWireNull`	`Public Function IsUniWireNull() As Boolean` / `Public Sub SetUniWireNull()`	Checks for/sets a `DBNull` value in the `UniWire` column.
`IsLABAOld2Null` / `SetLABAOld2Null`	`Public Function IsLABAOld2Null() As Boolean` / `Public Sub SetLABAOld2Null()`	Checks for/sets a `DBNull` value in the `LABAOld2` column.
`IsLABAOld3Null` / `SetLABAOld3Null`	`Public Function IsLABAOld3Null() As Boolean` / `Public Sub SetLABAOld3Null()`	Checks for/sets a `DBNull` value in the `LABAOld3` column.
`IsLACHOldNull` / `SetLACHOldNull`	`Public Function IsLACHOldNull() As Boolean` / `Public Sub SetLACHOldNull()`	Checks for/sets a `DBNull` value in the `LACHOld` column.
`IsLACHOld2Null` / `SetLACHOld2Null`	`Public Function IsLACHOld2Null() As Boolean` / `Public Sub SetLACHOld2Null()`	Checks for/sets a `DBNull` value in the `LACHOld2` column.
`IsLACHOld3Null` / `SetLACHOld3Null`	`Public Function IsLACHOld3Null() As Boolean` / `Public Sub SetLACHOld3Null()`	Checks for/sets a `DBNull` value in the `LACHOld3` column.

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