SQL-VP-032 Retrieve a non-employer account by account number¶

The primary retrieval path for clsNonEmployerAccount. Enforces BR-VP-014 at the business-object level.

Classification¶

Field	Value
SQL ID	SQL-VP-032
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsNonEmployerAccount`
Criteria property	`RetrieveSQL` (inline)
Lifecycle method	`BeforeRetrieve` / `AfterRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:AccountNumber`	Input	Decimal	N/A	Non-employer account number to retrieve.

Tables¶

Table	Access	Columns used
NON_EMPR_ACCT	SELECT	`ACCT_NUM`, `ACCT_NAME`, `ADDRESS_LINE_1`, `ADDRESS_LINE_2`, `CITY`, `STATE_CODE`, `ZIP_CODE`

Sample SQL¶

SELECT
  NON_EMPR_ACCT.ACCT_NUM,
  NON_EMPR_ACCT.ACCT_NAME,
  NON_EMPR_ACCT.ADDRESS_LINE_1,
  NON_EMPR_ACCT.ADDRESS_LINE_2,
  NON_EMPR_ACCT.CITY,
  NON_EMPR_ACCT.STATE_CODE,
  NON_EMPR_ACCT.ZIP_CODE,
  NON_EMPR_ACCT.CREATE_USER,
  NON_EMPR_ACCT.CREATE_DATE,
  NON_EMPR_ACCT.UPDATE_USER,
  NON_EMPR_ACCT.UPDATE_DATE
FROM
  NON_EMPR_ACCT
WHERE
  NON_EMPR_ACCT.ACCT_NUM = :AccountNumber

Full column list reconstructed from clsNonEmployerAccount.vb's inline SELECT; some column names beyond the primary key are inferred from typical naming conventions in this codebase and should be spot-checked against the live source.

Business rules¶

BR-VP-014: Non-employer account number must be non-zero

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¶

SAIF.Business.View.Policy\clsNonEmployerAccount.vb