---
title: SAIF.Application.Policy database tables
summary: Database tables touched indirectly by the policy application's direct cancellation-status function call.
status: draft
owner: SAIF Documentation Generation
last_reviewed: 2026-07-31
library: SAIF.Application.Policy
reference_type: package
---

# SAIF.Application.Policy database tables

This library does not author table SQL directly. The tables below are reached only through the Oracle function invoked by [SQL-001](sql/SQL-001-cancellation-status-derivation.md), so they are documented here as delegated, read-only dependencies of the application's one direct database call.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [POLICY](#policy) | Oracle | `[unqualified]`** | R | Supplies policy status, current balance, and cancel-status branching context | `clsStandardPolicyHeaderDataProvider`* |
| [POLICY_STATUS_CODE](#policy_status_code) | Oracle | `[unqualified]`** | R | Maps policy status code to status-group branching values | `clsStandardPolicyHeaderDataProvider`* |
| [POLICY_DEMAND](#policy_demand) | Oracle | `[unqualified]`** | R | Determines defaulted and demanded collection states | `clsStandardPolicyHeaderDataProvider`* |
| [POLICY_PERIOD_PAYROLL_AUDIT](#policy_period_payroll_audit) | Oracle | `[unqualified]`** | R | Determines pending-audit and pending-payroll-report conditions | `clsStandardPolicyHeaderDataProvider`* |
| [AUDIT_CODE](#audit_code) | Oracle | `[unqualified]`** | R | Distinguishes physical audit rows from other audit rows | `clsStandardPolicyHeaderDataProvider`* |
| [CANCELLATION](#cancellation) | Oracle | `[unqualified]`** | R | Supplies the latest cancel date used by audit and payroll-report checks | `clsStandardPolicyHeaderDataProvider`* |
| [COLLECTION_LEGAL_ACTION](#collection_legal_action) | Oracle | `[unqualified]`** | R | Detects open judgment and lien collection actions | `clsStandardPolicyHeaderDataProvider`* |

<a id="policy"></a>
## POLICY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]`** |
| **Purpose** | Supplies `POLICY_STATUS_CODE` and `CURRENT_BALANCE` to the cancellation-status function. |
| **Access pattern** | Stored function call via [SQL-001](sql/SQL-001-cancellation-status-derivation.md) |
| **CRUD operations** | Read |
| **Key columns used** | `POLICY_NUM`, `POLICY_STATUS_CODE`, `CURRENT_BALANCE` |
| **Sequence** | N/A |
| **Related tables** | `POLICY_STATUS_CODE`, `POLICY_DEMAND`, `POLICY_PERIOD_PAYROLL_AUDIT`, `CANCELLATION`, `COLLECTION_LEGAL_ACTION` |
| **Business objects** | `clsStandardPolicyHeaderDataProvider`* |

### Operations referencing this table
- [Assemble the policy header payload](operations/assemble-the-policy-header-payload.md)

### Business rules referencing this table
- [BR-119: Coverage-bound indicator requires bound status and period](business-rules.md#br-119-coverage-bound-indicator-requires-bound-status-and-period)
- [BR-120: Cancellation status is for SAIF employees only](business-rules.md#br-120-cancellation-status-is-for-saif-employees-only)
- [BR-121: Null cancellation status becomes empty](business-rules.md#br-121-null-cancellation-status-becomes-empty)

### SQL referencing this table
- [SQL-001: Cancellation status derivation](sql/SQL-001-cancellation-status-derivation.md)

---

<a id="policy_status_code"></a>
## POLICY_STATUS_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]`** |
| **Purpose** | Supplies `POLICY_STATUS_GROUP_CODE` so the function can branch into pending-cancel, cancelled, or application logic. |
| **Access pattern** | Stored function call via [SQL-001](sql/SQL-001-cancellation-status-derivation.md) |
| **CRUD operations** | Read |
| **Key columns used** | `CODE`, `POLICY_STATUS_GROUP_CODE` |
| **Sequence** | N/A |
| **Related tables** | `POLICY` |
| **Business objects** | `clsStandardPolicyHeaderDataProvider`* |

### Operations referencing this table
- [Assemble the policy header payload](operations/assemble-the-policy-header-payload.md)

### SQL referencing this table
- [SQL-001: Cancellation status derivation](sql/SQL-001-cancellation-status-derivation.md)

---

<a id="policy_demand"></a>
## POLICY_DEMAND

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]`** |
| **Purpose** | Determines whether the policy is `Defaulted` or `Demanded`. |
| **Access pattern** | Stored function call via [SQL-001](sql/SQL-001-cancellation-status-derivation.md) |
| **CRUD operations** | Read |
| **Key columns used** | `POLICY_NUM`, `COLLECTION_ACT_RESPONSE_CODE` |
| **Sequence** | N/A |
| **Related tables** | `POLICY` |
| **Business objects** | `clsStandardPolicyHeaderDataProvider`* |

### Operations referencing this table
- [Assemble the policy header payload](operations/assemble-the-policy-header-payload.md)

### SQL referencing this table
- [SQL-001: Cancellation status derivation](sql/SQL-001-cancellation-status-derivation.md)

---

<a id="policy_period_payroll_audit"></a>
## POLICY_PERIOD_PAYROLL_AUDIT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]`** |
| **Purpose** | Determines whether outstanding audits or payroll reports exist before the latest cancel date. |
| **Access pattern** | Stored function call via [SQL-001](sql/SQL-001-cancellation-status-derivation.md) |
| **CRUD operations** | Read |
| **Key columns used** | `POLICY_NUM`, `AUDIT_STATUS_CODE`, `AUDIT_PERIOD_START_DATE`, `AUDIT_CODE`, `PAYROLL_SEQ_NUM` |
| **Sequence** | N/A |
| **Related tables** | `AUDIT_CODE`, `CANCELLATION`, `POLICY` |
| **Business objects** | `clsStandardPolicyHeaderDataProvider`* |

### Operations referencing this table
- [Assemble the policy header payload](operations/assemble-the-policy-header-payload.md)

### SQL referencing this table
- [SQL-001: Cancellation status derivation](sql/SQL-001-cancellation-status-derivation.md)

---

<a id="audit_code"></a>
## AUDIT_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]`** |
| **Purpose** | Labels pending audit rows as physical or non-physical audit work. |
| **Access pattern** | Stored function call via [SQL-001](sql/SQL-001-cancellation-status-derivation.md) |
| **CRUD operations** | Read |
| **Key columns used** | `CODE`, `AUDIT_TYPE_CODE` |
| **Sequence** | N/A |
| **Related tables** | `POLICY_PERIOD_PAYROLL_AUDIT` |
| **Business objects** | `clsStandardPolicyHeaderDataProvider`* |

### Operations referencing this table
- [Assemble the policy header payload](operations/assemble-the-policy-header-payload.md)

### SQL referencing this table
- [SQL-001: Cancellation status derivation](sql/SQL-001-cancellation-status-derivation.md)

---

<a id="cancellation"></a>
## CANCELLATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]`** |
| **Purpose** | Supplies the latest cancel date used to qualify audit and payroll-report checks. |
| **Access pattern** | Stored function call via [SQL-001](sql/SQL-001-cancellation-status-derivation.md) |
| **CRUD operations** | Read |
| **Key columns used** | `POLICY_NUM`, `CANCELLATION_SEQ_NUM`, `CANCEL_DATE` |
| **Sequence** | N/A |
| **Related tables** | `POLICY`, `POLICY_PERIOD_PAYROLL_AUDIT` |
| **Business objects** | `clsStandardPolicyHeaderDataProvider`* |

### Operations referencing this table
- [Assemble the policy header payload](operations/assemble-the-policy-header-payload.md)

### SQL referencing this table
- [SQL-001: Cancellation status derivation](sql/SQL-001-cancellation-status-derivation.md)

---

<a id="collection_legal_action"></a>
## COLLECTION_LEGAL_ACTION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | `[unqualified]`** |
| **Purpose** | Detects open judgment and lien collection actions for cancelled policies. |
| **Access pattern** | Stored function call via [SQL-001](sql/SQL-001-cancellation-status-derivation.md) |
| **CRUD operations** | Read |
| **Key columns used** | `POLICY_NUM`, `COLLECTION_ACTION_CODE`, `CANCEL_DATE` |
| **Sequence** | N/A |
| **Related tables** | `POLICY` |
| **Business objects** | `clsStandardPolicyHeaderDataProvider`* |

### Operations referencing this table
- [Assemble the policy header payload](operations/assemble-the-policy-header-payload.md)

### SQL referencing this table
- [SQL-001: Cancellation status derivation](sql/SQL-001-cancellation-status-derivation.md)

## Table relationship diagram

The following diagram shows relationships inferred from the Oracle function behind the application's direct SQL call.

```mermaid
erDiagram
    POLICY_STATUS_CODE ||--o{ POLICY : status_code
    POLICY ||--o{ POLICY_DEMAND : policy_num
    POLICY ||--o{ POLICY_PERIOD_PAYROLL_AUDIT : policy_num
    AUDIT_CODE ||--o{ POLICY_PERIOD_PAYROLL_AUDIT : audit_code
    POLICY ||--o{ CANCELLATION : policy_num
    POLICY ||--o{ COLLECTION_LEGAL_ACTION : policy_num
    POLICY_PERIOD_PAYROLL_AUDIT ||--|| POLICY_PERIOD_PAYROLL_AUDIT : payroll_seq_num
```

> **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.

## 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)
- [Security and authorization](security-authorization.md)
- [SQL catalog](sql/index.md)
- [Configuration](configuration.md)
- [API reference](api/index.md)

## Sources
- `Application\SAIF.Application.Policy\PolicyHeader\clsStandardPolicyHeaderDataProvider.vb`