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 | SELECT | See sample SQL and source implementation. |
Sample SQL¶
Operations and processes¶
Business rules¶
- 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.
- 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.
- 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. - PROC-RULE-011: Deceased people are addressed as estates.
- PROC-RULE-012: Blank address lines are compacted upward to eliminate gaps.
- 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.
- PROC-RULE-015: Requests with no qualifying address return no rows.
Sources¶
Business\SAIF.Business\ClaimServices.vb