---
title: SAIF.Business.Policy database tables
summary: Database tables used by this library with relationships and usage context.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy
reference_type: package
---

# SAIF.Business.Policy database tables

This page catalogs the Oracle tables and pseudo-tables accessed by `SAIF.Business.Policy`.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [BENEFIT_JURISDICTION_CODE](#benefit_jurisdiction_code) | Oracle | `[unqualified]**` | R | Reference code table for benefit-jurisdiction mappings. | `clsBenefitJurisdictionCodeMap` |
| [MANUAL_CLASS_TYPE_CODE](#manual_class_type_code) | Oracle | `[unqualified]**` | R | Reference code table for manual-class-type mappings. | `clsManualClassTypeCodeMap` |
| [HAZARD_GROUP](#hazard_group) | Oracle | `[unqualified]**` | R | Effective-dated hazard-group reference table loaded into BOF business objects. | `clsHazardGroup`, `clsHazardGroupCollection` |
| [POLICY](#policy) | Oracle | `[unqualified]**` | R | Policy header table used for market-type lookup. | `PolicyInformation` |
| [POLICY_PERIOD](#policy_period) | Oracle | `[unqualified]**` | R | Primary policy-period table used by date and premium-history lookups. | `PolicyInformation` |
| [POLICY_PERIOD_NON_WCIS](#policy_period_non_wcis) | Oracle | `[unqualified]**` | R | Alternate policy-period table for non-WCIS periods. | `PolicyInformation` |
| [PREM_HIST_SUMMARY](#prem_hist_summary) | Oracle | `[unqualified]**` | R | Premium-history summary table used to locate current history sets and feed minimum-premium logic. | `PolicyInformation` |
| [ENDORSEMENT](#endorsement) | Oracle | `[unqualified]**` | R | Endorsement table used to detect printed P401 information pages. | `PolicyInformation` |
| [DUAL](#dual) | Oracle | N/A — Oracle pseudo-table | R | Oracle pseudo-table used to invoke scalar package functions. | `PolicyInformation` |

## BENEFIT_JURISDICTION_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Reference code table for benefit-jurisdiction mappings. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | `CODE`, `CODE_DESCR` |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram |
| **Business objects** | `clsBenefitJurisdictionCodeMap` |

### Operations referencing this table

- [Load Code Maps](operations/load-code-maps.md)

### Business rules referencing this table

- [BR-POL-013](business-rules.md#br-pol-013-code-maps-are-cached-until-refresh-is-requested)

### SQL referencing this table

- [SQL-001](sql/SQL-001-saif-business-policy.md)

---

## MANUAL_CLASS_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Reference code table for manual-class-type mappings. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | `CODE`, `CODE_DESCR` |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram |
| **Business objects** | `clsManualClassTypeCodeMap` |

### Operations referencing this table

- [Load Code Maps](operations/load-code-maps.md)

### Business rules referencing this table

- [BR-POL-014](business-rules.md#br-pol-014-only-recognized-database-codes-are-admitted-into-a-map)

### SQL referencing this table

- [SQL-003](sql/SQL-003-saif-business-policy.md)

---

## HAZARD_GROUP

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Effective-dated hazard-group reference table loaded into BOF business objects. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | `HAZARD_GROUP_ID`, dates, descriptions, `NCCI_HAZARD_GROUP_CODE` |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram |
| **Business objects** | `clsHazardGroup`, `clsHazardGroupCollection` |

### Operations referencing this table

- [Retrieve Hazard Groups Effective On A Date](operations/retrieve-hazard-groups-effective-on-a-date.md)

### Business rules referencing this table

- [BR-POL-011](business-rules.md#br-pol-011-hazard-group-data-is-read-only)

### SQL referencing this table

- [SQL-002](sql/SQL-002-saif-business-policy.md)

---

## POLICY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Policy header table used for market-type lookup. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | `POLICY_NUM`, `MARKET_TYPE_CODE` |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram |
| **Business objects** | `PolicyInformation` |

### Operations referencing this table

- [Determine Policy Market Type](operations/determine-policy-market-type.md)

### Business rules referencing this table

- [BR-POL-003](business-rules.md#br-pol-003-persisted-policy-codes-map-to-fixed-domain-enums)

### SQL referencing this table

- [SQL-007](sql/SQL-007-saif-business-policy.md)

---

## POLICY_PERIOD

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Primary policy-period table used by date and premium-history lookups. |
| **Access pattern** | direct SQL and stored procedure |
| **CRUD operations** | R |
| **Key columns used** | `POLICY_NUM`, effective/expiration dates, `ANNIVERSARY_RATE_DATE` |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram |
| **Business objects** | `PolicyInformation` |

### Operations referencing this table

- [Retrieve Latest Policy Period Effective Date](operations/retrieve-latest-policy-period-effective-date.md)

### Business rules referencing this table

- [BR-POL-001](business-rules.md#br-pol-001-latest-policy-period-date-comes-from-the-maximum-effective-date)

### SQL referencing this table

- [SQL-008](sql/SQL-008-saif-business-policy.md)

---

## POLICY_PERIOD_NON_WCIS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Alternate policy-period table for non-WCIS periods. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | `POLICY_NUM`, effective/expiration dates, `ANNIVERSARY_RATE_DATE` |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram |
| **Business objects** | `PolicyInformation` |

### Operations referencing this table

- [Retrieve Policy Period Expiration Date](operations/retrieve-policy-period-expiration-date.md)

### Business rules referencing this table

- [BR-POL-002](business-rules.md#br-pol-002-expiration-and-anniversary-lookups-search-both-wcis-and-non-wcis-period-tables)

### SQL referencing this table

- [SQL-011](sql/SQL-011-saif-business-policy.md)

---

## PREM_HIST_SUMMARY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Premium-history summary table used to locate current history sets and feed minimum-premium logic. |
| **Access pattern** | direct SQL and stored procedure |
| **CRUD operations** | R |
| **Key columns used** | `PREM_HIST_SET_ID`, `POLICY_NUM`, `POLICY_PERIOD_EFF_DATE`, `PREM_HIST_TYPE_CODE` |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram |
| **Business objects** | `PolicyInformation` |

### Operations referencing this table

- [Retrieve Maximum Premium History Set Id](operations/retrieve-maximum-premium-history-set-id.md)

### Business rules referencing this table

- [BR-POL-005](business-rules.md#br-pol-005-only-eligible-premium-history-types-contribute-to-the-max-set-id)

### SQL referencing this table

- [SQL-009](sql/SQL-009-saif-business-policy.md)

---

## ENDORSEMENT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Endorsement table used to detect printed P401 information pages. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | `POLICY_NUM`, `POLICY_PERIOD_EFF_DATE`, `ENDORSE_CODE`, `PRINTED_DATE` |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram |
| **Business objects** | `PolicyInformation` |

### Operations referencing this table

- [Determine Whether The Information Page Was Printed](operations/determine-whether-the-information-page-was-printed.md)

### Business rules referencing this table

- [BR-POL-009](business-rules.md#br-pol-009-only-printed-p401-endorsements-count-as-issued-information-pages)

### SQL referencing this table

- [SQL-006](sql/SQL-006-saif-business-policy.md)

---

## DUAL

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | N/A — Oracle pseudo-table |
| **Purpose** | Oracle pseudo-table used to invoke scalar package functions. |
| **Access pattern** | direct SQL |
| **CRUD operations** | R |
| **Key columns used** | Oracle scalar expression only |
| **Sequence** | N/A |
| **Related tables** | See relationship diagram |
| **Business objects** | `PolicyInformation` |

### Operations referencing this table

- [Determine Policy Ownership System](operations/determine-policy-ownership-system.md)

### Business rules referencing this table

- [BR-POL-010](business-rules.md#br-pol-010-ownership-comes-from-the-oracle-submission-ownership-function)

### SQL referencing this table

- [SQL-005](sql/SQL-005-saif-business-policy.md)

---

## Table relationship diagram

The following diagram shows the discoverable relationships between the tables referenced by this library and its Oracle procedures.

```mermaid

erDiagram

  POLICY ||--o{ POLICY_PERIOD : POLICY_NUM

  POLICY ||--o{ POLICY_PERIOD_NON_WCIS : POLICY_NUM

  POLICY_PERIOD ||--o{ ENDORSEMENT : POLICY_NUM+EFF_DATE

  POLICY_PERIOD ||--o{ PREM_HIST_SUMMARY : POLICY_NUM+EFF_DATE

```

## Related documentation

- [Index](index.md)
- [Overview](overview.md)
- [Architecture](architecture.md)
- [Dependencies](dependencies.md)
- [Operations and processes](operations-processes.md)
- [Business rules](business-rules.md)
- [SQL catalog](sql/index.md)
- [API reference](api/index.md)
- [Configuration](configuration.md)
- [Procedures](procedures/index.md)

> **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\PolicyInformation.vb`
- `Business\SAIF.Business.Policy\clsHazardGroupCollection.vb`
- `Business\SAIF.Business.Policy\CodeMaps\clsBenefitJurisdictionCodeMap.vb`
- `Business\SAIF.Business.Policy\CodeMaps\clsManualClassTypeCodeMap.vb`
- `Oracle DBA_SOURCE: WCIS_DBA.pk73069_rating_procs`
- `Oracle DBA_SOURCE: WCIS_DBA.pk73102_policy`