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	SELECT	BUS_SEQ_NUM, POLICY_NUM, TRADING_SEQ_NUM, FEID_NUM, TRADING_AS_NAME, TRADING_AS_CANCEL_DATE, TRADING_AS_TYPE_CODE

Sample 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

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