SQL-130: Update location collection¶

Update location collection in the context of clsLocationCollection.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:LocSeqNum`	Input	bound from `LocSeqNum`	-	Bound in `clsLocationCollection.BeforeUpdate` (line 480)
`:PolicyNum`	Input	bound from `m_PolicyNum`	-	Bound in `clsLocationCollection.BeforeUpdate` (line 486)
`:BusSeqNum`	Input	bound from `m_BusSeqNum`	-	Bound in `clsLocationCollection.BeforeUpdate` (line 487)
`:AgentNum`	Input	bound from `m_AgentNum`	-	Bound in `clsLocationCollection.BeforeUpdate` (line 488)
`:ParentLocSeqNum`	Input	bound from `m_ParentLocSeqNum`	-	Bound in `clsLocationCollection.BeforeUpdate` (line 489)
`:LocEffDate`	Input	bound from `LocEffDate`	-	Bound in `clsLocationCollection.BeforeUpdate` (line 481)
`:LocExpDate`	Input	bound from `m_LocExpDate`	-	Bound in `clsLocationCollection.BeforeUpdate` (line 490)
`:LocationCode`	Input	bound from `LocationCode`	5	Bound in `clsLocationCollection.BeforeUpdate` (line 482)
`:LocationName`	Input	bound from `m_LocationName`	40	Bound in `clsLocationCollection.BeforeUpdate` (line 491)
`:LocAddr1`	Input	bound from `m_LocAddr1`	40	Bound in `clsLocationCollection.BeforeUpdate` (line 492)
`:LocAddr2`	Input	bound from `m_LocAddr2`	40	Bound in `clsLocationCollection.BeforeUpdate` (line 493)
`:LocCity`	Input	bound from `m_LocCity`	30	Bound in `clsLocationCollection.BeforeUpdate` (line 494)
`:LocCountry`	Input	bound from `m_LocCountry`	3	Bound in `clsLocationCollection.BeforeUpdate` (line 495)
`:LocCounty`	Input	bound from `m_LocCounty`	5	Bound in `clsLocationCollection.BeforeUpdate` (line 496)
`:LocPhone`	Input	bound from `m_LocPhone`	12	Bound in `clsLocationCollection.BeforeUpdate` (line 497)
`:LocPhoneExt`	Input	bound from `m_LocPhoneExt`	4	Bound in `clsLocationCollection.BeforeUpdate` (line 498)
`:LocFax`	Input	bound from `m_LocFax`	12	Bound in `clsLocationCollection.BeforeUpdate` (line 499)
`:LocState`	Input	bound from `m_LocState`	2	Bound in `clsLocationCollection.BeforeUpdate` (line 500)
`:LocZip`	Input	bound from `m_LocZip`	5	Bound in `clsLocationCollection.BeforeUpdate` (line 501)
`:LocZip4`	Input	bound from `m_LocZip4`	4	Bound in `clsLocationCollection.BeforeUpdate` (line 502)
`:ProviderNum`	Input	bound from `m_ProviderNum`	-	Bound in `clsLocationCollection.BeforeUpdate` (line 504)
`:MailAddrFlag`	Input	bound from `m_MailAddrFlag`	1	Bound in `clsLocationCollection.BeforeUpdate` (line 505)
`:CreateUser`	Input	bound from `CreateUser`	30	Bound in `clsLocationCollection.BeforeUpdate` (line 651)
`:CreateDate`	Input	bound from `CreateDate`	-	Bound in `clsLocationCollection.BeforeUpdate` (line 650)
`:UpdateUser`	Input	bound from `m_UpdateUser`	30	Bound in `clsLocationCollection.BeforeUpdate` (line 663)
`:UpdateDate`	Input	bound from `m_UpdateDate`	-	Bound in `clsLocationCollection.BeforeUpdate` (line 673)
`:DivertTTFlag`	Input	bound from `m_DivertTTFlag`	1	Bound in `clsLocationCollection.BeforeUpdate` (line 508)
`:UspsBarcode`	Input	bound from `m_UspsBarcode`	11	Bound in `clsLocationCollection.BeforeUpdate` (line 509)
`:EmailAddr`	Input	bound from `m_EmailAddr`	60	Bound in `clsLocationCollection.BeforeUpdate` (line 510)
`:EmployeeCount`	Input	bound from `m_EmployeeCount`	-	Bound in `clsLocationCollection.BeforeUpdate` (line 511)
`:LocAddr3`	Input	bound from `m_LocAddr3`	40	Bound in `clsLocationCollection.BeforeUpdate` (line 512)
`:PrimaryLocationFlag`	Input	bound from `PrimaryLocationFlag`	1	Bound in `clsLocationCollection.BeforeUpdate` (line 485)
`:CellPhone`	Input	bound from `m_CellPhone`	12	Bound in `clsLocationCollection.BeforeUpdate` (line 513)

Tables¶

Table	Access	Columns used
LOCATION	UPDATE	See sample SQL

Sample SQL¶

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