SQL-131: Update policy location

Update policy location in the context of clsPolicyLocation.

Classification

Field	Value
SQL ID	SQL-131
Operation type	Update
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsPolicyLocation
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate / AfterUpdate

Parameters

Parameter	Direction	Type	Max length	Description
:AddressLine1	Input	bound from m_AddressLine1	40	Bound in clsPolicyLocation.BeforeUpdate (line 597)
:AddressLine2	Input	bound from m_AddressLine2	40	Bound in clsPolicyLocation.BeforeUpdate (line 598)
:City	Input	bound from m_City	30	Bound in clsPolicyLocation.BeforeUpdate (line 599)
:StateCode	Input	bound from m_StateCode	2	Bound in clsPolicyLocation.BeforeUpdate (line 600)
:ZipCode	Input	bound from m_ZipCode	5	Bound in clsPolicyLocation.BeforeUpdate (line 601)
:ZipCodeExtension	Input	bound from m_ZipCodeExtension	4	Bound in clsPolicyLocation.BeforeUpdate (line 602)
:UpdateUser	Input	bound from m_UpdateUser	30	Bound in clsPolicyLocation.BeforeUpdate (line 603)
:UpdateDate	Input	bound from m_UpdateDate	-	Bound in clsPolicyLocation.BeforeUpdate (line 604)
:LocationSequenceNumber	Input	bound from MyCriteria.LocationSequenceNumber	-	Bound in clsPolicyLocation.BeforeUpdate (line 607)

Tables

Table	Access	Columns used
LOCATION_VIEW	UPDATE	See sample SQL

Sample SQL

UPDATE
  LOCATION_VIEW
SET
  LOC_ADDR1 = :AddressLine1,
  LOC_ADDR2 = :AddressLine2,
  LOC_CITY = :City,
  LOC_STATE = :StateCode,
  LOC_ZIP = :ZipCode,
  LOC_ZIP4 = :ZipCodeExtension,
  UPDATE_USER = :UpdateUser,
  UPDATE_DATE = :UpdateDate
WHERE
  LOCATION_VIEW.LOC_SEQ_NUM = :LocationSequenceNumber

Operations and processes

• Filter policy locations for a view

Business rules

• BR-017: A location is active as of a date
• BR-018: Summary locations are active locations of type Business
• BR-020: When masking is requested, policyholder names, contact identity/contact-method

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\clsPolicyLocation.vb