SQL-004: Non-employer account retrieval

clsNonEmployerAccount loads a single non-employer account by account number. Non-employer accounts carry name, address, and phone data in the same shape as a policy but are not backed by a policy number.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:AccountNumber	Input	Decimal	not specified	Non-employer account number (ACCT_NUM) primary-key lookup.

Tables

Table	Access	Columns used
NON_EMPR_ACCT	SELECT	ACCT_NUM, ACCT_NAM, ADDR_LINE1, ADDR_LINE2, CITY_NAM, STATE_CD, ZIP_CD, PHONE_NUM

Sample SQL

Select
  NON_EMPR_ACCT.ACCT_NUM as AccountNumber,
  NON_EMPR_ACCT.ACCT_NAM as Name,
  NON_EMPR_ACCT.UPDT_SEQ_NUM as UpdateSeqNum,
  NON_EMPR_ACCT.UPDR_ID as UpdateUser,
  NON_EMPR_ACCT.UPDT_TS as UpdateDate,
  NON_EMPR_ACCT.ADDR_LINE1 as AddressLine1,
  NON_EMPR_ACCT.ADDR_LINE2 as AddressLine2,
  NON_EMPR_ACCT.CITY_NAM as CityName,
  NON_EMPR_ACCT.STATE_CD as StateCode,
  NON_EMPR_ACCT.ZIP_CD as ZipCode,
  NON_EMPR_ACCT.ZIP_CD_EXT as ZipCodeExtension,
  NON_EMPR_ACCT.PHONE_NUM as PhoneNumber
From
  NON_EMPR_ACCT
Where
  NON_EMPR_ACCT.ACCT_NUM = :AccountNumber

Operations and processes

• Retrieve supporting policy aggregates

Business rules

• BR-010: A non-employer account requires a non-zero account number

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.View.Policy/clsNonEmployerAccount.vb