SQL-065: Retrieve location collection

Retrieve location collection in the context of clsLocationCollection.

Classification

Field	Value
SQL ID	SQL-065
Operation type	Read
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsLocationCollection
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve / AfterRetrieve

Parameters

Parameter	Direction	Type	Max length	Description
:LocSeqNum	Input	bound from MyCriteria.LocSeqNum	-	Bound in clsLocationCollection.BeforeRetrieve (line 456)

Tables

Table	Access	Columns used
LOCATION	SELECT	See sample SQL

Sample SQL

SELECT
  LOCATION.LOC_SEQ_NUM as LocSeqNum,
  LOCATION.POLICY_NUM as PolicyNum,
  LOCATION.BUS_SEQ_NUM as BusSeqNum,
  LOCATION.AGENT_NUM as AgentNum,
  LOCATION.PARENT_LOC_SEQ_NUM as ParentLocSeqNum,
  LOCATION.LOC_EFF_DATE as LocEffDate,
  LOCATION.LOC_EXP_DATE as LocExpDate,
  LOCATION.LOCATION_CODE as LocationCode,
  LOCATION.LOCATION_NAME as LocationName,
  LOCATION.LOC_ADDR1 as LocAddr1,
  LOCATION.LOC_ADDR2 as LocAddr2,
  LOCATION.LOC_CITY as LocCity,
  LOCATION.LOC_COUNTRY as LocCountry,
  LOCATION.LOC_COUNTY as LocCounty,
  LOCATION.LOC_PHONE as LocPhone,
  LOCATION.LOC_PHONE_EXT as LocPhoneExt,
  LOCATION.LOC_FAX as LocFax,
  LOCATION.LOC_STATE as LocState,
  LOCATION.LOC_ZIP as LocZip,
  LOCATION.LOC_ZIP4 as LocZip4,
  LOCATION.PROVIDER_NUM as ProviderNum,
  LOCATION.MAIL_ADDR_FLAG as MailAddrFlag,
  LOCATION.CREATE_USER as CreateUser,
  LOCATION.CREATE_DATE as CreateDate,
  LOCATION.UPDATE_USER as UpdateUser,
  LOCATION.UPDATE_DATE as UpdateDate,
  LOCATION.DIVERT_TT_FLAG as DivertTTFlag,
  LOCATION.USPS_BARCODE as UspsBarcode,
  LOCATION.EMAIL_ADDR as EmailAddr,
  LOCATION.EMPLOYEE_COUNT as EmployeeCount,
  LOCATION.LOC_ADDR3 as LocAddr3,
  LOCATION.PRIMARY_LOCATION_FLAG as PrimaryLocationFlag,
  LOCATION.CELL_PHONE as CellPhone
FROM
  LOCATION
WHERE
  LOCATION.LOC_SEQ_NUM = :LocSeqNum

Operations and processes

• Filter policy locations for a view

Business rules

• BR-017: A location is active as of a date

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.Policy.Core\clsLocationCollection.vb