---
title: "SQL-011: Trading-as collection retrieval by policy"
summary: Retrieve all trading-as names for a policy.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-31
library: SAIF.Business.View.Policy
reference_type: package
---

# SQL-011: Trading-as collection retrieval by policy

`clsTradingAsCollection` loads every registered trading-as (doing-business-as) record for a policy.

## Classification

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

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:PolicyNumber` | Input | Decimal | not specified | Policy number owning the trading-as (DBA) records. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [TRADING_AS](../database-tables.md#trading-as) | SELECT | BUS_SEQ_NUM, POLICY_NUM, TRADING_SEQ_NUM, FEID_NUM, TRADING_AS_NAME, TRADING_AS_CANCEL_DATE, TRADING_AS_TYPE_CODE |

## Sample SQL

```sql
Select
  TRADING_AS.BUS_SEQ_NUM as BusSeqNum,
  TRADING_AS.POLICY_NUM as PolicyNum,
  TRADING_AS.TRADING_SEQ_NUM as TradingSeqNum,
  TRADING_AS.FEID_NUM as FeidNum,
  TRADING_AS.TRADING_AS_CANCEL_DATE as TradingASCancelDate,
  TRADING_AS.TRADING_AS_NAME as TradingASName,
  TRADING_AS.UITR_NUMBER as UitrNumber,
  TRADING_AS.TRADING_AS_NAME_EFF_DATE as TradingASNameEffDate,
  TRADING_AS.AFFILIATE_SSN as AffiliateSsn,
  TRADING_AS.CREATE_USER as CreateUser,
  TRADING_AS.CREATE_DATE as CreateDate,
  TRADING_AS.UPDATE_USER as UpdateUser,
  TRADING_AS.UPDATE_DATE as UpdateDate,
  TRADING_AS.REGISTRATION_DATE as RegistrationDate,
  TRADING_AS.TRADING_AS_TYPE_CODE as TradingASTypeCode
From TRADING_AS
Where TRADING_AS.POLICY_NUM = :PolicyNumber
```

## Operations and processes

- [Retrieve supporting policy aggregates](../operations/retrieve-supporting-policy-aggregates.md)

> **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/clsTradingAsCollection.vb`