Institutions.InstitutionRow¶

Institutions.InstitutionRow is the generated typed row that exposes the bank and routing columns contained in the Institution typed table.

Purpose¶

Surface institution reference fields such as routing, address, and contact values as strongly typed properties.
Provide generated null-check and null-assignment helpers for optional dataset columns.

Context¶

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

Public members¶

Member	Signature	Purpose
`LYONS_ID`	`Public Property LYONS_ID() As String`	Internal identifier used by the historical Lyons reference system to uniquely identify the institution row.
`LOC`	`Public Property LOC() As String`	Location code distinguishing a specific branch or office of the institution.
`NAME`	`Public Property NAME() As String`	Display name of the financial institution.
`MICR`	`Public Property MICR() As String`	MICR routing/transit number used for check-processing identification of the institution.
`FRAC`	`Public Property FRAC() As String`	Fractional (check-routing) component of the institution MICR number.
`ACH`	`Public Property ACH() As String`	ACH routing number used for electronic funds transfer to the institution.
`PHYS_ADDR1`	`Public Property PHYS_ADDR1() As String`	Street address line of the institution physical location.
`PHYS_CITY`	`Public Property PHYS_CITY() As String`	City of the institution physical address.
`PHYS_STATE`	`Public Property PHYS_STATE() As String`	State of the institution physical address.
`PHYS_ZIP`	`Public Property PHYS_ZIP() As String`	ZIP/postal code of the institution physical address.
`PHONE`	`Public Property PHONE() As String`	Primary phone number for the institution.
`FAX`	`Public Property FAX() As String`	Fax number for the institution.
`FEDWIRE`	`Public Property FEDWIRE() As String`	Fedwire routing number used for Federal Reserve wire transfers to the institution.
`CORR_RTNO`	`Public Property CORR_RTNO() As String`	Routing number of the institution correspondent bank.
`_RETURN`	`Public Property _RETURN() As String`	Return-item routing/handling code recorded for the institution.
`RETURN_EXT`	`Public Property RETURN_EXT() As String`	Phone extension associated with the institution return-item contact.
`ADJUST`	`Public Property ADJUST() As String`	Adjustment routing/handling code recorded for the institution.
`ADJUST_EXT`	`Public Property ADJUST_EXT() As String`	Phone extension associated with the institution adjustments contact.
`WIREPHONE`	`Public Property WIREPHONE() As String`	Phone number for the institution wire-transfer department.
`WIREPHONE_EXT`	`Public Property WIREPHONE_EXT() As String`	Phone extension for the institution wire-transfer department.
`SWIFT`	`Public Property SWIFT() As String`	SWIFT/BIC code used for international wire transfers to the institution.
`TELEX`	`Public Property TELEX() As String`	Telex number historically used for message routing to the institution.
`OLDMICR`	`Public Property OLDMICR() As String`	Prior/legacy MICR routing number retained for historical reference.
`HOMEPAGE`	`Public Property HOMEPAGE() As String`	URL of the institution website.
`EMAIL`	`Public Property EMAIL() As String`	Contact email address for the institution.
`NOTES`	`Public Property NOTES() As String`	Free-text notes recorded about the institution.
`LYONS_NOTE`	`Public Property LYONS_NOTE() As String`	Free-text note specific to the legacy Lyons reference system.
`CUST_SVC`	`Public Property CUST_SVC() As String`	Customer-service phone number or contact information for the institution.
`UniWire`	`Public Property UniWire() As String`	Universal wire-routing identifier recorded for the institution.
`LABAOld2`	`Public Property LABAOld2() As String`	Legacy ABA routing number (second historical variant) retained for reference.
`LABAOld3`	`Public Property LABAOld3() As String`	Legacy ABA routing number (third historical variant) retained for reference.
`LACHOld`	`Public Property LACHOld() As String`	Legacy ACH routing number retained for historical reference.
`LACHOld2`	`Public Property LACHOld2() As String`	Legacy ACH routing number (second historical variant) retained for reference.
`LACHOld3`	`Public Property LACHOld3() As String`	Legacy ACH routing number (third historical variant) retained for reference.
`IsLYONS_IDNull`	`Public Function IsLYONS_IDNull() As Boolean`	Reports whether the LYONS_ID field currently holds a database null.
`SetLYONS_IDNull`	`Public Sub SetLYONS_IDNull()`	Clears the LYONS_ID field back to a database-null state.
`IsLOCNull`	`Public Function IsLOCNull() As Boolean`	Reports whether the LOC field currently holds a database null.
`SetLOCNull`	`Public Sub SetLOCNull()`	Clears the LOC field back to a database-null state.
`IsNAMENull`	`Public Function IsNAMENull() As Boolean`	Reports whether the NAME field currently holds a database null.
`SetNAMENull`	`Public Sub SetNAMENull()`	Clears the NAME field back to a database-null state.
`IsMICRNull`	`Public Function IsMICRNull() As Boolean`	Reports whether the MICR field currently holds a database null.
`SetMICRNull`	`Public Sub SetMICRNull()`	Clears the MICR field back to a database-null state.
`IsFRACNull`	`Public Function IsFRACNull() As Boolean`	Reports whether the FRAC field currently holds a database null.
`SetFRACNull`	`Public Sub SetFRACNull()`	Clears the FRAC field back to a database-null state.
`IsACHNull`	`Public Function IsACHNull() As Boolean`	Reports whether the ACH field currently holds a database null.
`SetACHNull`	`Public Sub SetACHNull()`	Clears the ACH field back to a database-null state.
`IsPHYS_ADDR1Null`	`Public Function IsPHYS_ADDR1Null() As Boolean`	Reports whether the PHYS_ADDR1 field currently holds a database null.
`SetPHYS_ADDR1Null`	`Public Sub SetPHYS_ADDR1Null()`	Clears the PHYS_ADDR1 field back to a database-null state.
`IsPHYS_CITYNull`	`Public Function IsPHYS_CITYNull() As Boolean`	Reports whether the PHYS_CITY field currently holds a database null.
`SetPHYS_CITYNull`	`Public Sub SetPHYS_CITYNull()`	Clears the PHYS_CITY field back to a database-null state.
`IsPHYS_STATENull`	`Public Function IsPHYS_STATENull() As Boolean`	Reports whether the PHYS_STATE field currently holds a database null.
`SetPHYS_STATENull`	`Public Sub SetPHYS_STATENull()`	Clears the PHYS_STATE field back to a database-null state.
`IsPHYS_ZIPNull`	`Public Function IsPHYS_ZIPNull() As Boolean`	Reports whether the PHYS_ZIP field currently holds a database null.
`SetPHYS_ZIPNull`	`Public Sub SetPHYS_ZIPNull()`	Clears the PHYS_ZIP field back to a database-null state.
`IsPHONENull`	`Public Function IsPHONENull() As Boolean`	Reports whether the PHONE field currently holds a database null.
`SetPHONENull`	`Public Sub SetPHONENull()`	Clears the PHONE field back to a database-null state.
`IsFAXNull`	`Public Function IsFAXNull() As Boolean`	Reports whether the FAX field currently holds a database null.
`SetFAXNull`	`Public Sub SetFAXNull()`	Clears the FAX field back to a database-null state.
`IsFEDWIRENull`	`Public Function IsFEDWIRENull() As Boolean`	Reports whether the FEDWIRE field currently holds a database null.
`SetFEDWIRENull`	`Public Sub SetFEDWIRENull()`	Clears the FEDWIRE field back to a database-null state.
`IsCORR_RTNONull`	`Public Function IsCORR_RTNONull() As Boolean`	Reports whether the CORR_RTNO field currently holds a database null.
`SetCORR_RTNONull`	`Public Sub SetCORR_RTNONull()`	Clears the CORR_RTNO field back to a database-null state.
`Is_RETURNNull`	`Public Function Is_RETURNNull() As Boolean`	Reports whether the _RETURN field currently holds a database null.
`Set_RETURNNull`	`Public Sub Set_RETURNNull()`	Clears the _RETURN field back to a database-null state.
`IsRETURN_EXTNull`	`Public Function IsRETURN_EXTNull() As Boolean`	Reports whether the RETURN_EXT field currently holds a database null.
`SetRETURN_EXTNull`	`Public Sub SetRETURN_EXTNull()`	Clears the RETURN_EXT field back to a database-null state.
`IsADJUSTNull`	`Public Function IsADJUSTNull() As Boolean`	Reports whether the ADJUST field currently holds a database null.
`SetADJUSTNull`	`Public Sub SetADJUSTNull()`	Clears the ADJUST field back to a database-null state.
`IsADJUST_EXTNull`	`Public Function IsADJUST_EXTNull() As Boolean`	Reports whether the ADJUST_EXT field currently holds a database null.
`SetADJUST_EXTNull`	`Public Sub SetADJUST_EXTNull()`	Clears the ADJUST_EXT field back to a database-null state.
`IsWIREPHONENull`	`Public Function IsWIREPHONENull() As Boolean`	Reports whether the WIREPHONE field currently holds a database null.
`SetWIREPHONENull`	`Public Sub SetWIREPHONENull()`	Clears the WIREPHONE field back to a database-null state.
`IsWIREPHONE_EXTNull`	`Public Function IsWIREPHONE_EXTNull() As Boolean`	Reports whether the WIREPHONE_EXT field currently holds a database null.
`SetWIREPHONE_EXTNull`	`Public Sub SetWIREPHONE_EXTNull()`	Clears the WIREPHONE_EXT field back to a database-null state.
`IsSWIFTNull`	`Public Function IsSWIFTNull() As Boolean`	Reports whether the SWIFT field currently holds a database null.
`SetSWIFTNull`	`Public Sub SetSWIFTNull()`	Clears the SWIFT field back to a database-null state.
`IsTELEXNull`	`Public Function IsTELEXNull() As Boolean`	Reports whether the TELEX field currently holds a database null.
`SetTELEXNull`	`Public Sub SetTELEXNull()`	Clears the TELEX field back to a database-null state.
`IsOLDMICRNull`	`Public Function IsOLDMICRNull() As Boolean`	Reports whether the OLDMICR field currently holds a database null.
`SetOLDMICRNull`	`Public Sub SetOLDMICRNull()`	Clears the OLDMICR field back to a database-null state.
`IsHOMEPAGENull`	`Public Function IsHOMEPAGENull() As Boolean`	Reports whether the HOMEPAGE field currently holds a database null.
`SetHOMEPAGENull`	`Public Sub SetHOMEPAGENull()`	Clears the HOMEPAGE field back to a database-null state.
`IsEMAILNull`	`Public Function IsEMAILNull() As Boolean`	Reports whether the EMAIL field currently holds a database null.
`SetEMAILNull`	`Public Sub SetEMAILNull()`	Clears the EMAIL field back to a database-null state.
`IsNOTESNull`	`Public Function IsNOTESNull() As Boolean`	Reports whether the NOTES field currently holds a database null.
`SetNOTESNull`	`Public Sub SetNOTESNull()`	Clears the NOTES field back to a database-null state.
`IsLYONS_NOTENull`	`Public Function IsLYONS_NOTENull() As Boolean`	Reports whether the LYONS_NOTE field currently holds a database null.
`SetLYONS_NOTENull`	`Public Sub SetLYONS_NOTENull()`	Clears the LYONS_NOTE field back to a database-null state.
`IsCUST_SVCNull`	`Public Function IsCUST_SVCNull() As Boolean`	Reports whether the CUST_SVC field currently holds a database null.
`SetCUST_SVCNull`	`Public Sub SetCUST_SVCNull()`	Clears the CUST_SVC field back to a database-null state.
`IsUniWireNull`	`Public Function IsUniWireNull() As Boolean`	Reports whether the UniWire field currently holds a database null.
`SetUniWireNull`	`Public Sub SetUniWireNull()`	Clears the UniWire field back to a database-null state.
`IsLABAOld2Null`	`Public Function IsLABAOld2Null() As Boolean`	Reports whether the LABAOld2 field currently holds a database null.
`SetLABAOld2Null`	`Public Sub SetLABAOld2Null()`	Clears the LABAOld2 field back to a database-null state.
`IsLABAOld3Null`	`Public Function IsLABAOld3Null() As Boolean`	Reports whether the LABAOld3 field currently holds a database null.
`SetLABAOld3Null`	`Public Sub SetLABAOld3Null()`	Clears the LABAOld3 field back to a database-null state.
`IsLACHOldNull`	`Public Function IsLACHOldNull() As Boolean`	Reports whether the LACHOld field currently holds a database null.
`SetLACHOldNull`	`Public Sub SetLACHOldNull()`	Clears the LACHOld field back to a database-null state.
`IsLACHOld2Null`	`Public Function IsLACHOld2Null() As Boolean`	Reports whether the LACHOld2 field currently holds a database null.
`SetLACHOld2Null`	`Public Sub SetLACHOld2Null()`	Clears the LACHOld2 field back to a database-null state.
`IsLACHOld3Null`	`Public Function IsLACHOld3Null() As Boolean`	Reports whether the LACHOld3 field currently holds a database null.
`SetLACHOld3Null`	`Public Sub SetLACHOld3Null()`	Clears the LACHOld3 field back to a database-null state.

Behavioral notes¶

The row surface is generated directly from the dataset schema and is not customized with agency-specific business logic.
The available properties mirror the routing, address, phone, and contact columns defined in the underlying dataset.
Column purposes above 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 treat the property set as schema-driven generated code.

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