---
title: "SAIF.Business.Policy.Core 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.Core
reference_type: package
---

# SAIF.Business.Policy.Core database tables

This page catalogs database tables accessed by this library.

## Table catalog
| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [BUSINESS](#business) | Oracle | [unqualified]** | R | Policy data* | `clsPolicy` |
| [CANCELLATION](#cancellation) | Oracle | [unqualified]** | CRUD | Cancel Reason Override data* | `clsCancelReasonOverride`, `clsCancellationWarning`, `clsCancellationWarningCollection`, `clsPolicy` |
| [CANCEL_REASON_CODE](#cancel_reason_code) | Oracle | [unqualified]** | CRUD | Cancel Reason Override data* | `clsCancelReasonOverride`, `clsCancellationReason`, `clsCancellationReasonCollection` |
| [CANCEL_REASON_OVERRIDE](#cancel_reason_override) | Oracle | [unqualified]** | CR | Cancel Reason Override data* | `clsCancelReasonOverride` |
| [CARRIER_CHANGE_REASON_CODE](#carrier_change_reason_code) | Oracle | [unqualified]** | R | Cancel Reason Override data* | `clsCancelReasonOverride` |
| [CARRIER_CODE](#carrier_code) | Oracle | [unqualified]** | CRUD | Cancel Reason Override data* | `clsCancelReasonOverride`, `clsInsuranceCarrier` |
| [CONTACT](#contact) | Oracle | [unqualified]** | R | Location Contact data* | `clsLocationContact`, `clsLocationContactCollection`, `clsPolicyLocation` |
| [COUNTY](#county) | Oracle | [unqualified]** | CRUD | County data* | `clsCounty`, `clsCountyCollection` |
| [DUAL](#dual) | Oracle | [unqualified]** | - | Cancellation Reason data* | `clsCancellationReason`, `clsCancellationReasonCollection`, `clsCancellationWarning`, `clsCancellationWarningCollection`, `clsCounty`, `clsCountyCollection`, `clsInsuranceCarrier`, `clsLocation`, `clsLocationCollection`, `clsPolicyPeriodEmployerLiabilityLimits`, `clsPolicyPeriodEmployerLiabilityLimitsCollection`, `clsPolicyPeriodMaster`, `clsPolicyTeamFunction`, `clsPolicyTeamFunctionCollection`, `clsPolicyTeamMemberCollection`, `clsPriorCoverage`, `clsPriorCoverageCollection`, `clsSAIFOffice`, `clsSAIFOfficeCollection`, `clsWCISEmployee`, `clsWCISEmployeeCollection` |
| [EMPLOYERS_LIABILITY_FACTORS](#employers_liability_factors) | Oracle | [unqualified]** | R | Employer Liability Limits Collection data* | `clsEmployerLiabilityLimitsCollection` |
| [EMPLOYERS_LIABILITY_LIMITS](#employers_liability_limits) | Oracle | [unqualified]** | R | Employer Liability Limits Collection data* | `clsEmployerLiabilityLimitsCollection` |
| [ENTITY_CODE](#entity_code) | Oracle | [unqualified]** | R | Entity Type data* | `clsEntityType`, `clsEntityTypeCollection` |
| [LOCATION](#location) | Oracle | [unqualified]** | CRUD | Location data* | `clsLocation`, `clsLocationCollection`, `clsPolicyLocation`, `clsPolicyLocationCollection` |
| [LOCATION_CODE](#location_code) | Oracle | [unqualified]** | R | Location Type data* | `clsLocationType`, `clsLocationTypeCollection` |
| [LOCATION_VIEW](#location_view) | Oracle | [unqualified]** | U | Policy Location data* | `clsPolicyLocation` |
| [NON_WCIS_STAT_TRANS](#non_wcis_stat_trans) | Oracle | [unqualified]** | R | Policy Period Base data* | `clsPolicyPeriodBase` |
| [OFFICE_CODE](#office_code) | Oracle | [unqualified]** | CRUD | S A I F Office data* | `clsSAIFOffice`, `clsSAIFOfficeCollection` |
| [POLICY](#policy) | Oracle | [unqualified]** | R | W C I S Inquiry data* | `WCISInquiry`, `clsPolicy`, `clsPolicyCollection` |
| [POLICY_PERIOD](#policy_period) | Oracle | [unqualified]** | R | W C I S Inquiry data* | `WCISInquiry`, `clsPolicyPeriodCollection` |
| [POLICY_PERIOD_EMP_LIAB](#policy_period_emp_liab) | Oracle | [unqualified]** | CRUD | Policy Period Employer Liability Limits data* | `clsPolicyPeriodEmployerLiabilityLimits`, `clsPolicyPeriodEmployerLiabilityLimitsCollection` |
| [POLICY_PERIOD_MASTER](#policy_period_master) | Oracle | [unqualified]** | CRUD | Policy data* | `clsPolicy`, `clsPolicyPeriodMaster` |
| [POLICY_PERIOD_NON_WCIS](#policy_period_non_wcis) | Oracle | [unqualified]** | R | Legacy Policy Period Collection data* | `clsLegacyPolicyPeriodCollection` |
| [POLICY_PERIOD_STATUS_CODE](#policy_period_status_code) | Oracle | [unqualified]** | R | Policy Period Status data* | `clsPolicyPeriodStatus`, `clsPolicyPeriodStatusCollection` |
| [POLICY_STATUS_CODE](#policy_status_code) | Oracle | [unqualified]** | R | Policy Status Code data* | `clsPolicyStatusCode`, `clsPolicyStatusCodeCollection` |
| [POLICY_TEAM_FUNCTION](#policy_team_function) | Oracle | [unqualified]** | CRUD | Policy Team Member data* | `clsPolicyTeamMember`, `clsPolicyTeamMemberCollection` |
| [PRIOR_COVERAGE](#prior_coverage) | Oracle | [unqualified]** | CRUD | Prior Coverage data* | `clsPriorCoverage`, `clsPriorCoverageCollection` |
| [SUB_CONSTANTS](#sub_constants) | Oracle | [unqualified]** | R | W C I S Inquiry data* | `WCISInquiry` |
| [TEAM_FUNCTION_CODE](#team_function_code) | Oracle | [unqualified]** | CRUD | Policy Team Function data* | `clsPolicyTeamFunction`, `clsPolicyTeamFunctionCollection` |
| [WCIS_CONSTANTS](#wcis_constants) | Oracle | [unqualified]** | R | W C I S Inquiry data* | `WCISInquiry` |
| [WCIS_EMPLOYEE](#wcis_employee) | Oracle | [unqualified]** | CRUD | W C I S Employee data* | `clsWCISEmployee`, `clsWCISEmployeeCollection` |

## BUSINESS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Policy data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY |
| **Business objects** | `clsPolicy` |

### Operations referencing this table
- [Retrieve a policy (optionally masked)](operations/retrieve-a-policy-optionally-masked.md)

### Business rules referencing this table
- [BR-020: When masking is requested, policyholder names, contact identity/contact-method](business-rules.md#br-020-when-masking-is-requested-policyholder-names-contact-identitycontact-method)

### SQL referencing this table
- [SQL-072: Policy](sql/SQL-072-saif-business-policy-core.md)

---

## CANCELLATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Cancel Reason Override data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY, CANCEL_REASON_OVERRIDE, CANCEL_REASON_CODE, CARRIER_CODE, CARRIER_CHANGE_REASON_CODE |
| **Business objects** | `clsCancelReasonOverride`, `clsCancellationWarning`, `clsCancellationWarningCollection`, `clsPolicy` |

### Operations referencing this table
- [Record a cancellation reason override](operations/record-a-cancellation-reason-override.md)
- [Retrieve a policy (optionally masked)](operations/retrieve-a-policy-optionally-masked.md)

### Business rules referencing this table
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)
- [BR-009: A cancellation reason override must carry a valid](business-rules.md#br-009-a-cancellation-reason-override-must-carry-a-valid)
- [BR-020: When masking is requested, policyholder names, contact identity/contact-method](business-rules.md#br-020-when-masking-is-requested-policyholder-names-contact-identitycontact-method)

### SQL referencing this table
- [SQL-024: Cancellation Warning](sql/SQL-024-saif-business-policy-core.md)
- [SQL-025: Cancellation Warning Collection](sql/SQL-025-saif-business-policy-core.md)
- [SQL-047: Cancellation Warning](sql/SQL-047-saif-business-policy-core.md)
- [SQL-048: Cancellation Warning Collection](sql/SQL-048-saif-business-policy-core.md)
- [SQL-049: Cancel Reason Override](sql/SQL-049-saif-business-policy-core.md)
- [SQL-050: Cancel Reason Override](sql/SQL-050-saif-business-policy-core.md)
- [SQL-051: Cancel Reason Override](sql/SQL-051-saif-business-policy-core.md)
- [SQL-052: Cancel Reason Override](sql/SQL-052-saif-business-policy-core.md)
- [SQL-070: Policy](sql/SQL-070-saif-business-policy-core.md)
- [SQL-124: Cancellation Warning](sql/SQL-124-saif-business-policy-core.md)
- [SQL-125: Cancellation Warning Collection](sql/SQL-125-saif-business-policy-core.md)
- [SQL-147: Cancellation Warning](sql/SQL-147-saif-business-policy-core.md)
- [SQL-148: Cancellation Warning Collection](sql/SQL-148-saif-business-policy-core.md)

---

## CANCEL_REASON_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Cancel Reason Override data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | CANCELLATION, CANCEL_REASON_OVERRIDE |
| **Business objects** | `clsCancelReasonOverride`, `clsCancellationReason`, `clsCancellationReasonCollection` |

### Operations referencing this table
- [Record a cancellation reason override](operations/record-a-cancellation-reason-override.md)

### Business rules referencing this table
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)
- [BR-009: A cancellation reason override must carry a valid](business-rules.md#br-009-a-cancellation-reason-override-must-carry-a-valid)

### SQL referencing this table
- [SQL-022: Cancellation Reason](sql/SQL-022-saif-business-policy-core.md)
- [SQL-023: Cancellation Reason Collection](sql/SQL-023-saif-business-policy-core.md)
- [SQL-045: Cancellation Reason](sql/SQL-045-saif-business-policy-core.md)
- [SQL-046: Cancellation Reason Collection](sql/SQL-046-saif-business-policy-core.md)
- [SQL-050: Cancel Reason Override](sql/SQL-050-saif-business-policy-core.md)
- [SQL-122: Cancellation Reason](sql/SQL-122-saif-business-policy-core.md)
- [SQL-123: Cancellation Reason Collection](sql/SQL-123-saif-business-policy-core.md)
- [SQL-145: Cancellation Reason](sql/SQL-145-saif-business-policy-core.md)
- [SQL-146: Cancellation Reason Collection](sql/SQL-146-saif-business-policy-core.md)

---

## CANCEL_REASON_OVERRIDE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Cancel Reason Override data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CR |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | CANCELLATION, CANCEL_REASON_CODE |
| **Business objects** | `clsCancelReasonOverride` |

### Operations referencing this table
- [Record a cancellation reason override](operations/record-a-cancellation-reason-override.md)

### Business rules referencing this table
- [BR-009: A cancellation reason override must carry a valid](business-rules.md#br-009-a-cancellation-reason-override-must-carry-a-valid)
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)

### SQL referencing this table
- [SQL-026: Cancel Reason Override](sql/SQL-026-saif-business-policy-core.md)
- [SQL-053: Cancel Reason Override](sql/SQL-053-saif-business-policy-core.md)

---

## CARRIER_CHANGE_REASON_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Cancel Reason Override data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | CANCELLATION |
| **Business objects** | `clsCancelReasonOverride` |

### Operations referencing this table
- [Record a cancellation reason override](operations/record-a-cancellation-reason-override.md)

### Business rules referencing this table
- [BR-009: A cancellation reason override must carry a valid](business-rules.md#br-009-a-cancellation-reason-override-must-carry-a-valid)
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)

### SQL referencing this table
- [SQL-051: Cancel Reason Override](sql/SQL-051-saif-business-policy-core.md)

---

## CARRIER_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Cancel Reason Override data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | CANCELLATION |
| **Business objects** | `clsCancelReasonOverride`, `clsInsuranceCarrier` |

### Operations referencing this table
- [Record a cancellation reason override](operations/record-a-cancellation-reason-override.md)

### Business rules referencing this table
- [BR-029: SAIF's own carrier identity is represented by fixed](business-rules.md#br-029-saifs-own-carrier-identity-is-represented-by-fixed)
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)
- [BR-009: A cancellation reason override must carry a valid](business-rules.md#br-009-a-cancellation-reason-override-must-carry-a-valid)

### SQL referencing this table
- [SQL-029: Insurance Carrier](sql/SQL-029-saif-business-policy-core.md)
- [SQL-052: Cancel Reason Override](sql/SQL-052-saif-business-policy-core.md)
- [SQL-060: Insurance Carrier](sql/SQL-060-saif-business-policy-core.md)
- [SQL-128: Insurance Carrier](sql/SQL-128-saif-business-policy-core.md)
- [SQL-151: Insurance Carrier](sql/SQL-151-saif-business-policy-core.md)

---

## CONTACT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Location Contact data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | LOCATION |
| **Business objects** | `clsLocationContact`, `clsLocationContactCollection`, `clsPolicyLocation` |

### Operations referencing this table
- [Filter policy locations for a view](operations/filter-policy-locations-for-a-view.md)

### Business rules referencing this table
- [BR-020: When masking is requested, policyholder names, contact identity/contact-method](business-rules.md#br-020-when-masking-is-requested-policyholder-names-contact-identitycontact-method)
- [BR-017: A location is active as of a date](business-rules.md#br-017-a-location-is-active-as-of-a-date)
- [BR-018: Summary locations are active locations of type Business](business-rules.md#br-018-summary-locations-are-active-locations-of-type-business)

### SQL referencing this table
- [SQL-066: Location Contact](sql/SQL-066-saif-business-policy-core.md)
- [SQL-067: Location Contact Collection](sql/SQL-067-saif-business-policy-core.md)
- [SQL-075: Policy Location](sql/SQL-075-saif-business-policy-core.md)

---

## COUNTY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | County data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | OFFICE_CODE |
| **Business objects** | `clsCounty`, `clsCountyCollection` |

### Business rules referencing this table
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)

### SQL referencing this table
- [SQL-027: County](sql/SQL-027-saif-business-policy-core.md)
- [SQL-028: County Collection](sql/SQL-028-saif-business-policy-core.md)
- [SQL-054: County](sql/SQL-054-saif-business-policy-core.md)
- [SQL-055: County Collection](sql/SQL-055-saif-business-policy-core.md)
- [SQL-126: County](sql/SQL-126-saif-business-policy-core.md)
- [SQL-127: County Collection](sql/SQL-127-saif-business-policy-core.md)
- [SQL-149: County](sql/SQL-149-saif-business-policy-core.md)
- [SQL-150: County Collection](sql/SQL-150-saif-business-policy-core.md)

---

## DUAL

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Cancellation Reason data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | - |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | N/A |
| **Business objects** | `clsCancellationReason`, `clsCancellationReasonCollection`, `clsCancellationWarning`, `clsCancellationWarningCollection`, `clsCounty`, `clsCountyCollection`, `clsInsuranceCarrier`, `clsLocation`, `clsLocationCollection`, `clsPolicyPeriodEmployerLiabilityLimits`, `clsPolicyPeriodEmployerLiabilityLimitsCollection`, `clsPolicyPeriodMaster`, `clsPolicyTeamFunction`, `clsPolicyTeamFunctionCollection`, `clsPolicyTeamMemberCollection`, `clsPriorCoverage`, `clsPriorCoverageCollection`, `clsSAIFOffice`, `clsSAIFOfficeCollection`, `clsWCISEmployee`, `clsWCISEmployeeCollection` |

### Operations referencing this table
- [Record a cancellation reason override](operations/record-a-cancellation-reason-override.md)
- [Filter policy locations for a view](operations/filter-policy-locations-for-a-view.md)
- [Retrieve employers-liability limits](operations/retrieve-employers-liability-limits.md)
- [Build a unified policy period timeline](operations/build-a-unified-policy-period-timeline.md)

### Business rules referencing this table
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)
- [BR-029: SAIF's own carrier identity is represented by fixed](business-rules.md#br-029-saifs-own-carrier-identity-is-represented-by-fixed)
- [BR-017: A location is active as of a date](business-rules.md#br-017-a-location-is-active-as-of-a-date)
- [BR-025: Per-period employers-liability limits must carry a valid statistical](business-rules.md#br-025-per-period-employers-liability-limits-must-carry-a-valid-statistical)
- [BR-010: A policy's period history is the union of](business-rules.md#br-010-a-policys-period-history-is-the-union-of)
- [BR-030: The service centre office is identified by office](business-rules.md#br-030-the-service-centre-office-is-identified-by-office)

### SQL referencing this table
- [SQL-001: Cancellation Reason](sql/SQL-001-saif-business-policy-core.md)
- [SQL-002: Cancellation Reason Collection](sql/SQL-002-saif-business-policy-core.md)
- [SQL-003: Cancellation Warning](sql/SQL-003-saif-business-policy-core.md)
- [SQL-004: Cancellation Warning Collection](sql/SQL-004-saif-business-policy-core.md)
- [SQL-005: County](sql/SQL-005-saif-business-policy-core.md)
- [SQL-006: County Collection](sql/SQL-006-saif-business-policy-core.md)
- [SQL-007: Insurance Carrier](sql/SQL-007-saif-business-policy-core.md)
- [SQL-008: Location](sql/SQL-008-saif-business-policy-core.md)
- [SQL-009: Location Collection](sql/SQL-009-saif-business-policy-core.md)
- [SQL-010: Policy Period Employer Liability Limits](sql/SQL-010-saif-business-policy-core.md)
- [SQL-011: Policy Period Employer Liability Limits Collection](sql/SQL-011-saif-business-policy-core.md)
- [SQL-012: Policy Period Master](sql/SQL-012-saif-business-policy-core.md)
- [SQL-013: Policy Team Function](sql/SQL-013-saif-business-policy-core.md)
- [SQL-014: Policy Team Function Collection](sql/SQL-014-saif-business-policy-core.md)
- [SQL-015: Policy Team Member Collection](sql/SQL-015-saif-business-policy-core.md)
- [SQL-016: Prior Coverage](sql/SQL-016-saif-business-policy-core.md)
- [SQL-017: Prior Coverage Collection](sql/SQL-017-saif-business-policy-core.md)
- [SQL-018: S A I F Office](sql/SQL-018-saif-business-policy-core.md)
- [SQL-019: S A I F Office Collection](sql/SQL-019-saif-business-policy-core.md)
- [SQL-020: W C I S Employee](sql/SQL-020-saif-business-policy-core.md)
- [SQL-021: W C I S Employee Collection](sql/SQL-021-saif-business-policy-core.md)

---

## EMPLOYERS_LIABILITY_FACTORS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Employer Liability Limits Collection data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | N/A |
| **Business objects** | `clsEmployerLiabilityLimitsCollection` |

### Operations referencing this table
- [Retrieve employers-liability limits](operations/retrieve-employers-liability-limits.md)

### Business rules referencing this table
- [BR-021: Employers-liability limits may be retrieved by statistical code](business-rules.md#br-021-employers-liability-limits-may-be-retrieved-by-statistical-code)

### SQL referencing this table
- [SQL-057: Employer Liability Limits Collection](sql/SQL-057-saif-business-policy-core.md)

---

## EMPLOYERS_LIABILITY_LIMITS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Employer Liability Limits Collection data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY_PERIOD_EMP_LIAB |
| **Business objects** | `clsEmployerLiabilityLimitsCollection` |

### Operations referencing this table
- [Retrieve employers-liability limits](operations/retrieve-employers-liability-limits.md)

### Business rules referencing this table
- [BR-021: Employers-liability limits may be retrieved by statistical code](business-rules.md#br-021-employers-liability-limits-may-be-retrieved-by-statistical-code)

### SQL referencing this table
- [SQL-057: Employer Liability Limits Collection](sql/SQL-057-saif-business-policy-core.md)

---

## ENTITY_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Entity Type data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY |
| **Business objects** | `clsEntityType`, `clsEntityTypeCollection` |

### Operations referencing this table
- [Determine ownership requirements for an entity type](operations/determine-ownership-requirements-for-an-entity-type.md)

### Business rules referencing this table
- [BR-006: Ownership information is required for all entity types](business-rules.md#br-006-ownership-information-is-required-for-all-entity-types)
- [BR-007: Sole proprietors require exactly one owner; partnerships, limited](business-rules.md#br-007-sole-proprietors-require-exactly-one-owner-partnerships-limited)
- [BR-008: For the Guidewire path, joint ventures require one](business-rules.md#br-008-for-the-guidewire-path-joint-ventures-require-one)
- [BR-026: An entity type must have a valid code](business-rules.md#br-026-an-entity-type-must-have-a-valid-code)

### SQL referencing this table
- [SQL-058: Entity Type](sql/SQL-058-saif-business-policy-core.md)
- [SQL-059: Entity Type Collection](sql/SQL-059-saif-business-policy-core.md)

---

## LOCATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Location data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | CONTACT, LOCATION_CODE |
| **Business objects** | `clsLocation`, `clsLocationCollection`, `clsPolicyLocation`, `clsPolicyLocationCollection` |

### Operations referencing this table
- [Filter policy locations for a view](operations/filter-policy-locations-for-a-view.md)

### Business rules referencing this table
- [BR-017: A location is active as of a date](business-rules.md#br-017-a-location-is-active-as-of-a-date)
- [BR-018: Summary locations are active locations of type Business](business-rules.md#br-018-summary-locations-are-active-locations-of-type-business)
- [BR-020: When masking is requested, policyholder names, contact identity/contact-method](business-rules.md#br-020-when-masking-is-requested-policyholder-names-contact-identitycontact-method)
- [BR-019: Only location types flagged PolicyLocationFlag = "Y" are](business-rules.md#br-019-only-location-types-flagged-policylocationflag-y-are)

### SQL referencing this table
- [SQL-030: Location Collection](sql/SQL-030-saif-business-policy-core.md)
- [SQL-064: Location](sql/SQL-064-saif-business-policy-core.md)
- [SQL-065: Location Collection](sql/SQL-065-saif-business-policy-core.md)
- [SQL-076: Policy Location](sql/SQL-076-saif-business-policy-core.md)
- [SQL-077: Policy Location Collection](sql/SQL-077-saif-business-policy-core.md)
- [SQL-129: Location](sql/SQL-129-saif-business-policy-core.md)
- [SQL-130: Location Collection](sql/SQL-130-saif-business-policy-core.md)
- [SQL-152: Location Collection](sql/SQL-152-saif-business-policy-core.md)

---

## LOCATION_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Location Type data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | LOCATION |
| **Business objects** | `clsLocationType`, `clsLocationTypeCollection` |

### Operations referencing this table
- [Filter policy locations for a view](operations/filter-policy-locations-for-a-view.md)

### Business rules referencing this table
- [BR-019: Only location types flagged PolicyLocationFlag = "Y" are](business-rules.md#br-019-only-location-types-flagged-policylocationflag-y-are)

### SQL referencing this table
- [SQL-068: Location Type](sql/SQL-068-saif-business-policy-core.md)
- [SQL-069: Location Type Collection](sql/SQL-069-saif-business-policy-core.md)

---

## LOCATION_VIEW

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Policy Location data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | U |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | N/A |
| **Business objects** | `clsPolicyLocation` |

### Operations referencing this table
- [Filter policy locations for a view](operations/filter-policy-locations-for-a-view.md)

### Business rules referencing this table
- [BR-017: A location is active as of a date](business-rules.md#br-017-a-location-is-active-as-of-a-date)
- [BR-018: Summary locations are active locations of type Business](business-rules.md#br-018-summary-locations-are-active-locations-of-type-business)
- [BR-020: When masking is requested, policyholder names, contact identity/contact-method](business-rules.md#br-020-when-masking-is-requested-policyholder-names-contact-identitycontact-method)

### SQL referencing this table
- [SQL-131: Policy Location](sql/SQL-131-saif-business-policy-core.md)

---

## NON_WCIS_STAT_TRANS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Policy Period Base data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY |
| **Business objects** | `clsPolicyPeriodBase` |

### Operations referencing this table
- [Determine standard premium for a period](operations/determine-standard-premium-for-a-period.md)

### Business rules referencing this table
- [BR-013: Standard premium is sourced from WCIS for WCIS](business-rules.md#br-013-standard-premium-is-sourced-from-wcis-for-wcis)
- [BR-022: A policy period must have a non-zero policy](business-rules.md#br-022-a-policy-period-must-have-a-non-zero-policy)
- [BR-023: A policy period must have an effective date](business-rules.md#br-023-a-policy-period-must-have-an-effective-date)

### SQL referencing this table
- [SQL-084: Policy Period Base](sql/SQL-084-saif-business-policy-core.md)

---

## OFFICE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | S A I F Office data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | COUNTY, POLICY |
| **Business objects** | `clsSAIFOffice`, `clsSAIFOfficeCollection` |

### Business rules referencing this table
- [BR-030: The service centre office is identified by office](business-rules.md#br-030-the-service-centre-office-is-identified-by-office)
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)

### SQL referencing this table
- [SQL-040: S A I F Office](sql/SQL-040-saif-business-policy-core.md)
- [SQL-041: S A I F Office Collection](sql/SQL-041-saif-business-policy-core.md)
- [SQL-102: S A I F Office](sql/SQL-102-saif-business-policy-core.md)
- [SQL-103: S A I F Office Collection](sql/SQL-103-saif-business-policy-core.md)
- [SQL-141: S A I F Office](sql/SQL-141-saif-business-policy-core.md)
- [SQL-142: S A I F Office Collection](sql/SQL-142-saif-business-policy-core.md)
- [SQL-162: S A I F Office](sql/SQL-162-saif-business-policy-core.md)
- [SQL-163: S A I F Office Collection](sql/SQL-163-saif-business-policy-core.md)

---

## POLICY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | W C I S Inquiry data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY_PERIOD, POLICY_PERIOD_NON_WCIS, POLICY_PERIOD_MASTER, CANCELLATION, BUSINESS, LOCATION`, NON_WCIS_STAT_TRANS, POLICY_TEAM_FUNCTION, PRIOR_COVERAGE, POLICY_STATUS_CODE, OFFICE_CODE, ENTITY_CODE |
| **Business objects** | `WCISInquiry`, `clsPolicy`, `clsPolicyCollection` |

### Operations referencing this table
- [Retrieve a policy (optionally masked)](operations/retrieve-a-policy-optionally-masked.md)
- [Retrieve affiliated policies / policies for an account](operations/retrieve-affiliated-policies-policies-for-an-account.md)
- [Determine standard premium for a period](operations/determine-standard-premium-for-a-period.md)
- [Determine whether a period is issued](operations/determine-whether-a-period-is-issued.md)

### Business rules referencing this table
- [BR-020: When masking is requested, policyholder names, contact identity/contact-method](business-rules.md#br-020-when-masking-is-requested-policyholder-names-contact-identitycontact-method)
- [BR-032: Preliminary audit is required when the WCIS edit](business-rules.md#br-032-preliminary-audit-is-required-when-the-wcis-edit)

### SQL referencing this table
- [SQL-073: Policy](sql/SQL-073-saif-business-policy-core.md)
- [SQL-074: Policy Collection](sql/SQL-074-saif-business-policy-core.md)
- [SQL-111: W C I S Inquiry](sql/SQL-111-saif-business-policy-core.md)
- [SQL-114: W C I S Inquiry](sql/SQL-114-saif-business-policy-core.md)
- [SQL-115: W C I S Inquiry](sql/SQL-115-saif-business-policy-core.md)

---

## POLICY_PERIOD

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | W C I S Inquiry data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY, POLICY_PERIOD_STATUS_CODE, POLICY_PERIOD_EMP_LIAB |
| **Business objects** | `WCISInquiry`, `clsPolicyPeriodCollection` |

### Operations referencing this table
- [Build a unified policy period timeline](operations/build-a-unified-policy-period-timeline.md)
- [Configure dynamic period retrieval SQL](operations/configure-dynamic-period-retrieval-sql.md)
- [Select the relevant period from a set](operations/select-the-relevant-period-from-a-set.md)
- [Determine standard premium for a period](operations/determine-standard-premium-for-a-period.md)
- [Determine whether a period is issued](operations/determine-whether-a-period-is-issued.md)

### Business rules referencing this table
- [BR-004: The current period is the first period flagged](business-rules.md#br-004-the-current-period-is-the-first-period-flagged)
- [BR-005: Experience-rating base periods are those whose begin date](business-rules.md#br-005-experience-rating-base-periods-are-those-whose-begin-date)
- [BR-010: A policy's period history is the union of](business-rules.md#br-010-a-policys-period-history-is-the-union-of)
- [BR-011: Association-based period retrieval uses a different predicate per](business-rules.md#br-011-association-based-period-retrieval-uses-a-different-predicate-per)
- [BR-012: An association type outside the supported set is](business-rules.md#br-012-an-association-type-outside-the-supported-set-is)
- [BR-032: Preliminary audit is required when the WCIS edit](business-rules.md#br-032-preliminary-audit-is-required-when-the-wcis-edit)

### SQL referencing this table
- [SQL-088: Policy Period Collection](sql/SQL-088-saif-business-policy-core.md)
- [SQL-109: W C I S Inquiry](sql/SQL-109-saif-business-policy-core.md)
- [SQL-112: W C I S Inquiry](sql/SQL-112-saif-business-policy-core.md)

---

## POLICY_PERIOD_EMP_LIAB

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Policy Period Employer Liability Limits data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY_PERIOD, EMPLOYERS_LIABILITY_LIMITS |
| **Business objects** | `clsPolicyPeriodEmployerLiabilityLimits`, `clsPolicyPeriodEmployerLiabilityLimitsCollection` |

### Operations referencing this table
- [Retrieve employers-liability limits](operations/retrieve-employers-liability-limits.md)

### Business rules referencing this table
- [BR-025: Per-period employers-liability limits must carry a valid statistical](business-rules.md#br-025-per-period-employers-liability-limits-must-carry-a-valid-statistical)
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)

### SQL referencing this table
- [SQL-031: Policy Period Employer Liability Limits](sql/SQL-031-saif-business-policy-core.md)
- [SQL-032: Policy Period Employer Liability Limits Collection](sql/SQL-032-saif-business-policy-core.md)
- [SQL-089: Policy Period Employer Liability Limits](sql/SQL-089-saif-business-policy-core.md)
- [SQL-090: Policy Period Employer Liability Limits Collection](sql/SQL-090-saif-business-policy-core.md)
- [SQL-132: Policy Period Employer Liability Limits](sql/SQL-132-saif-business-policy-core.md)
- [SQL-133: Policy Period Employer Liability Limits Collection](sql/SQL-133-saif-business-policy-core.md)
- [SQL-153: Policy Period Employer Liability Limits](sql/SQL-153-saif-business-policy-core.md)
- [SQL-154: Policy Period Employer Liability Limits Collection](sql/SQL-154-saif-business-policy-core.md)

---

## POLICY_PERIOD_MASTER

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Policy data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY |
| **Business objects** | `clsPolicy`, `clsPolicyPeriodMaster` |

### Operations referencing this table
- [Build a unified policy period timeline](operations/build-a-unified-policy-period-timeline.md)
- [Retrieve a policy (optionally masked)](operations/retrieve-a-policy-optionally-masked.md)

### Business rules referencing this table
- [BR-010: A policy's period history is the union of](business-rules.md#br-010-a-policys-period-history-is-the-union-of)
- [BR-020: When masking is requested, policyholder names, contact identity/contact-method](business-rules.md#br-020-when-masking-is-requested-policyholder-names-contact-identitycontact-method)

### SQL referencing this table
- [SQL-033: Policy Period Master](sql/SQL-033-saif-business-policy-core.md)
- [SQL-071: Policy](sql/SQL-071-saif-business-policy-core.md)
- [SQL-091: Policy Period Master](sql/SQL-091-saif-business-policy-core.md)
- [SQL-134: Policy Period Master](sql/SQL-134-saif-business-policy-core.md)
- [SQL-155: Policy Period Master](sql/SQL-155-saif-business-policy-core.md)

---

## POLICY_PERIOD_NON_WCIS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Legacy Policy Period Collection data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY |
| **Business objects** | `clsLegacyPolicyPeriodCollection` |

### Operations referencing this table
- [Build a unified policy period timeline](operations/build-a-unified-policy-period-timeline.md)

### Business rules referencing this table
- [BR-010: A policy's period history is the union of](business-rules.md#br-010-a-policys-period-history-is-the-union-of)

### SQL referencing this table
- [SQL-063: Legacy Policy Period Collection](sql/SQL-063-saif-business-policy-core.md)

---

## POLICY_PERIOD_STATUS_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Policy Period Status data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY_PERIOD |
| **Business objects** | `clsPolicyPeriodStatus`, `clsPolicyPeriodStatusCollection` |

### Operations referencing this table
- [Classify period status](operations/classify-period-status.md)

### Business rules referencing this table
- [BR-001: Policy period status codes map to a fixed](business-rules.md#br-001-policy-period-status-codes-map-to-a-fixed)
- [BR-002: An unrecognised status code yields Statuses.Unknown; an unrecognised](business-rules.md#br-002-an-unrecognised-status-code-yields-statusesunknown-an-unrecognised)
- [BR-003: Statuses roll up into six status groups Application](business-rules.md#br-003-statuses-roll-up-into-six-status-groups-application)

### SQL referencing this table
- [SQL-092: Policy Period Status](sql/SQL-092-saif-business-policy-core.md)
- [SQL-093: Policy Period Status Collection](sql/SQL-093-saif-business-policy-core.md)

---

## POLICY_STATUS_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Policy Status Code data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY |
| **Business objects** | `clsPolicyStatusCode`, `clsPolicyStatusCodeCollection` |

### Operations referencing this table
- [Classify period status](operations/classify-period-status.md)

### Business rules referencing this table
- [BR-027: A policy status code must be non-empty](business-rules.md#br-027-a-policy-status-code-must-be-non-empty)
- [BR-028: A policy in application status raises a warning](business-rules.md#br-028-a-policy-in-application-status-raises-a-warning)

### SQL referencing this table
- [SQL-094: Policy Status Code](sql/SQL-094-saif-business-policy-core.md)
- [SQL-095: Policy Status Code Collection](sql/SQL-095-saif-business-policy-core.md)

---

## POLICY_TEAM_FUNCTION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Policy Team Member data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY, TEAM_FUNCTION_CODE, WCIS_EMPLOYEE |
| **Business objects** | `clsPolicyTeamMember`, `clsPolicyTeamMemberCollection` |

### Business rules referencing this table
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)

### SQL referencing this table
- [SQL-036: Policy Team Member](sql/SQL-036-saif-business-policy-core.md)
- [SQL-037: Policy Team Member Collection](sql/SQL-037-saif-business-policy-core.md)
- [SQL-098: Policy Team Member](sql/SQL-098-saif-business-policy-core.md)
- [SQL-099: Policy Team Member Collection](sql/SQL-099-saif-business-policy-core.md)
- [SQL-137: Policy Team Member](sql/SQL-137-saif-business-policy-core.md)
- [SQL-138: Policy Team Member Collection](sql/SQL-138-saif-business-policy-core.md)
- [SQL-158: Policy Team Member](sql/SQL-158-saif-business-policy-core.md)
- [SQL-159: Policy Team Member Collection](sql/SQL-159-saif-business-policy-core.md)

---

## PRIOR_COVERAGE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Prior Coverage data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY |
| **Business objects** | `clsPriorCoverage`, `clsPriorCoverageCollection` |

### Business rules referencing this table
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)

### SQL referencing this table
- [SQL-038: Prior Coverage](sql/SQL-038-saif-business-policy-core.md)
- [SQL-039: Prior Coverage Collection](sql/SQL-039-saif-business-policy-core.md)
- [SQL-100: Prior Coverage](sql/SQL-100-saif-business-policy-core.md)
- [SQL-101: Prior Coverage Collection](sql/SQL-101-saif-business-policy-core.md)
- [SQL-139: Prior Coverage](sql/SQL-139-saif-business-policy-core.md)
- [SQL-140: Prior Coverage Collection](sql/SQL-140-saif-business-policy-core.md)
- [SQL-160: Prior Coverage](sql/SQL-160-saif-business-policy-core.md)
- [SQL-161: Prior Coverage Collection](sql/SQL-161-saif-business-policy-core.md)

---

## SUB_CONSTANTS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | W C I S Inquiry data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | N/A |
| **Business objects** | `WCISInquiry` |

### Operations referencing this table
- [Determine standard premium for a period](operations/determine-standard-premium-for-a-period.md)
- [Determine whether a period is issued](operations/determine-whether-a-period-is-issued.md)

### Business rules referencing this table
- [BR-032: Preliminary audit is required when the WCIS edit](business-rules.md#br-032-preliminary-audit-is-required-when-the-wcis-edit)

### SQL referencing this table
- [SQL-106: W C I S Inquiry](sql/SQL-106-saif-business-policy-core.md)
- [SQL-113: W C I S Inquiry](sql/SQL-113-saif-business-policy-core.md)

---

## TEAM_FUNCTION_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Policy Team Function data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY_TEAM_FUNCTION |
| **Business objects** | `clsPolicyTeamFunction`, `clsPolicyTeamFunctionCollection` |

### Business rules referencing this table
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)

### SQL referencing this table
- [SQL-034: Policy Team Function](sql/SQL-034-saif-business-policy-core.md)
- [SQL-035: Policy Team Function Collection](sql/SQL-035-saif-business-policy-core.md)
- [SQL-096: Policy Team Function](sql/SQL-096-saif-business-policy-core.md)
- [SQL-097: Policy Team Function Collection](sql/SQL-097-saif-business-policy-core.md)
- [SQL-135: Policy Team Function](sql/SQL-135-saif-business-policy-core.md)
- [SQL-136: Policy Team Function Collection](sql/SQL-136-saif-business-policy-core.md)
- [SQL-156: Policy Team Function](sql/SQL-156-saif-business-policy-core.md)
- [SQL-157: Policy Team Function Collection](sql/SQL-157-saif-business-policy-core.md)

---

## WCIS_CONSTANTS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | W C I S Inquiry data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | R |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | N/A |
| **Business objects** | `WCISInquiry` |

### Operations referencing this table
- [Determine standard premium for a period](operations/determine-standard-premium-for-a-period.md)
- [Determine whether a period is issued](operations/determine-whether-a-period-is-issued.md)

### Business rules referencing this table
- [BR-032: Preliminary audit is required when the WCIS edit](business-rules.md#br-032-preliminary-audit-is-required-when-the-wcis-edit)

### SQL referencing this table
- [SQL-118: W C I S Inquiry](sql/SQL-118-saif-business-policy-core.md)

---

## WCIS_EMPLOYEE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | W C I S Employee data used by policy-core SQL.* |
| **Access pattern** | Direct SQL |
| **CRUD operations** | CRUD |
| **Key columns used** | See linked SQL documents* |
| **Sequence** | N/A |
| **Related tables** | POLICY_TEAM_FUNCTION |
| **Business objects** | `clsWCISEmployee`, `clsWCISEmployeeCollection` |

### Business rules referencing this table
- [BR-033: New sequence values for writable entities are obtained](business-rules.md#br-033-new-sequence-values-for-writable-entities-are-obtained)

### SQL referencing this table
- [SQL-042: W C I S Employee](sql/SQL-042-saif-business-policy-core.md)
- [SQL-043: W C I S Employee Collection](sql/SQL-043-saif-business-policy-core.md)
- [SQL-104: W C I S Employee](sql/SQL-104-saif-business-policy-core.md)
- [SQL-105: W C I S Employee Collection](sql/SQL-105-saif-business-policy-core.md)
- [SQL-143: W C I S Employee](sql/SQL-143-saif-business-policy-core.md)
- [SQL-144: W C I S Employee Collection](sql/SQL-144-saif-business-policy-core.md)
- [SQL-164: W C I S Employee](sql/SQL-164-saif-business-policy-core.md)
- [SQL-165: W C I S Employee Collection](sql/SQL-165-saif-business-policy-core.md)

## Table relationship diagram

The following diagram shows inferred relationships between tables used by this library.

```mermaid
erDiagram
    POLICY ||--o{ POLICY-PERIOD : "One-to-many"
    POLICY ||--o{ POLICY-PERIOD-NON-WCIS : "One-to-many"
    POLICY ||--o{ POLICY-PERIOD-MASTER : "One-to-many"
    POLICY ||--o{ CANCELLATION : "One-to-many"
    POLICY ||--o{ BUSINESS : "One-to-many"
    POLICY ||--o{ LOCATION : "One-to-many"
    POLICY ||--o{ NON-WCIS-STAT-TRANS : "One-to-many"
    POLICY ||--o{ POLICY-TEAM-FUNCTION : "One-to-many"
    POLICY ||--o{ PRIOR-COVERAGE : "One-to-many"
    POLICY-STATUS-CODE ||--o{ POLICY : "Lookup (one-to-many)"
    POLICY-PERIOD-STATUS-CODE ||--o{ POLICY-PERIOD : "Lookup (one-to-many)"
    POLICY-PERIOD ||--o{ POLICY-PERIOD-EMP-LIAB : "One-to-many"
    EMPLOYERS-LIABILITY-LIMITS ||--o{ POLICY-PERIOD-EMP-LIAB : "Lookup (one-to-many)"
    EMPLOYERS-LIABILITY-LIMITS-ELL ||--o{ EMPLOYERS-LIABILITY-LIMITS-FACTOR-ROWS-ELF : "One-to-many"
    LOCATION ||--o{ CONTACT : "One-to-many"
    LOCATION-CODE ||--o{ LOCATION : "Lookup (one-to-many)"
    OFFICE-CODE ||--o{ COUNTY : "Lookup (one-to-many)"
    OFFICE-CODE ||--o{ POLICY : "Lookup (one-to-many)"
    ENTITY-CODE ||--o{ POLICY : "Lookup (one-to-many)"
    CANCELLATION ||--o{ CANCEL-REASON-OVERRIDE : "One-to-many"
    CANCEL-REASON-CODE ||--o{ CANCELLATION : "Lookup (one-to-many)"
    CANCEL-REASON-CODE ||--o{ CANCEL-REASON-OVERRIDE : "Lookup (one-to-many)"
    CARRIER-CODE ||--o{ CANCELLATION : "Lookup (one-to-many)"
    CARRIER-CHANGE-REASON-CODE ||--o{ CANCELLATION : "Lookup (one-to-many)"
    TEAM-FUNCTION-CODE ||--o{ POLICY-TEAM-FUNCTION : "Lookup (one-to-many)"
    WCIS-EMPLOYEE ||--o{ POLICY-TEAM-FUNCTION : "Lookup (one-to-many)"
```

## 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)
- [Procedures](procedures/index.md)
- [Configuration](configuration.md)
- [API reference](api/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.Core\clsPolicy.vb`
- `Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb`
- `Business\SAIF.Business.Policy.Core\clsLegacyPolicyPeriod.vb`
- `Business\SAIF.Business.Policy.Core\clsPolicyLocation.vb`
- `Business\SAIF.Business.Policy.Core\clsLocationContact.vb`
- `Business\SAIF.Business.Policy.Core\WCISInquiry.vb`