---
title: "SQL-004: Non-employer account retrieval"
summary: Retrieve a non-employer account by account number.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-31
library: SAIF.Business.View.Policy
reference_type: package
---

# 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](../database-tables.md#non-empr-acct) | SELECT | ACCT_NUM, ACCT_NAM, ADDR_LINE1, ADDR_LINE2, CITY_NAM, STATE_CD, ZIP_CD, PHONE_NUM |

## Sample SQL

```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](../operations/retrieve-supporting-policy-aggregates.md)

## Business rules

- [BR-010: A non-employer account requires a non-zero account number](../business-rules.md#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`