---
title: "SQL-129: Update location"
summary: "Update location"
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Core
reference_type: package
---

# SQL-129: Update location

Update location in the context of `clsLocation`.

## Classification

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

## Parameters

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

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [LOCATION](../database-tables.md#location) | UPDATE | See sample SQL |

## Sample SQL

```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](../operations/filter-policy-locations-for-a-view.md)

## Business rules
- [BR-017: A location is active as of a date](../business-rules.md#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\clsLocation.vb`