---
title: "SQL-005: Pk82001 claim getpersonaddress"
summary: Pk82001 claim getpersonaddress.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business
reference_type: package
---

# SQL-005: Pk82001 claim getpersonaddress

This document describes `SQL-005`, the pk82001 claim getpersonaddress statement or call used by `SAIF.Business`.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-005 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `WCIS_DBA` |
| **Command type** | StoredProcedure |
| **Business object** | `ClaimServices` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `GetPersonName` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:inPersonId`, `:inAddrType`, `:inDate`, `:recordset` | Input / Output | Decimal, String, Date, REF CURSOR | 1 / N/A | Person-address lookup |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CL_INJURY_CLAIM](../database-tables.md#cl-injury-claim-cl-claim-responsibility) | SELECT | See sample SQL and source implementation. |

## Sample SQL

```sql
pk82001_claim.getPersonAddress(:inPersonId, :inAddrType, :inDate, :recordset)
```

## Operations and processes
- [Claim authorization and visibility checks](../operations/claim-information-and-authorization-support.md)

## Business rules
- [PROC-RULE-005: The procedure uses the caller-supplied date when one is provided.](../business-rules.md#proc-rule-005-the-procedure-uses-the-caller-supplied-date-when-one-is-provided)
- [PROC-RULE-006: Default correspondence address lookup falls back from guardian to mailing to home address.](../business-rules.md#proc-rule-006-default-correspondence-address-lookup-falls-back-from-guardian-to-mailing-to-home-address)
- [PROC-RULE-007: Default payment address lookup falls back from guardian to payment to mailing to home address.](../business-rules.md#proc-rule-007-default-payment-address-lookup-falls-back-from-guardian-to-payment-to-mailing-to-home-address)
- [PROC-RULE-008: Explicit payment requests only use payment addresses.](../business-rules.md#proc-rule-008-explicit-payment-requests-only-use-payment-addresses)
- [PROC-RULE-009: Other requests use the requested address type directly.](../business-rules.md#proc-rule-009-other-requests-use-the-requested-address-type-directly)
- [PROC-RULE-010: Guardian correspondence resolves the guardian mailing address and inserts a `For:` line for the worker/beneficiary.](../business-rules.md#proc-rule-010-guardian-correspondence-resolves-the-guardian-mailing-address-and-inserts-a-for-line-for-the-worker-beneficiary)
- [PROC-RULE-011: Deceased people are addressed as estates.](../business-rules.md#proc-rule-011-deceased-people-are-addressed-as-estates)
- [PROC-RULE-012: Blank address lines are compacted upward to eliminate gaps.](../business-rules.md#proc-rule-012-blank-address-lines-are-compacted-upward-to-eliminate-gaps)
- [PROC-RULE-013: Addressee salutation is gender-based.](../business-rules.md#proc-rule-013-addressee-salutation-is-gender-based)
- [PROC-RULE-014: An address is valid only when it has a person name, two populated address lines, and either foreign-address status or a city/state pair.](../business-rules.md#proc-rule-014-an-address-is-valid-only-when-it-has-a-person-name-two-populated-address-lines-and-either-foreign-address-status-or-a-city-state-pair)
- [PROC-RULE-015: Requests with no qualifying address return no rows.](../business-rules.md#proc-rule-015-requests-with-no-qualifying-address-return-no-rows)

## Sources
- `Business\SAIF.Business\ClaimServices.vb`