SQL-022: Address/state/country/zip validation family*¶
This document describes SQL-022, the address/state/country/zip validation family* statement or call used by SAIF.Business.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-022 |
| Operation type | Read |
| Execution method | Inline |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsAddress, clsAddressStructure, ObjectServices |
| Criteria property | N/A |
| Lifecycle method | validation helpers |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:State, :ZipCode, :Country, :StateCode |
Input | String | 2-5 | Address/state/country validation helpers |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| ALL_STATES | SELECT | See sample SQL and source implementation. |
| ZIP_CODE | SELECT | See sample SQL and source implementation. |
| COUNTRY | SELECT | See sample SQL and source implementation. |
| ZIP_MCO_COUNTY | SELECT | See sample SQL and source implementation. |
Sample SQL¶
Representative validation queries:
SELECT COUNT(*) FROM ALL_STATES WHERE STATE = :State
SELECT COUNT(*) FROM ZIP_CODE WHERE ZIP_CODE_STATE = :State AND :ZipCode BETWEEN ZIP_CODE_LOW AND ZIP_CODE_HIGH
SELECT COUNTRY_NAME FROM COUNTRY WHERE COUNTRY = :Country
SELECT COUNT(*) FROM ZIP_MCO_COUNTY WHERE ZIP_CODE = :ZipCode
Operations and processes¶
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\ContactInfo\clsAddress.vb