---
title: "SAIF.Business.Policy.Core SQL catalog"
summary: "Index of all SQL statements used by this library, grouped by operation type."
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Core
reference_type: package
---

# SAIF.Business.Policy.Core SQL catalog

This page indexes every SQL statement and stored-procedure invocation identified in this library.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-022](SQL-022-saif-business-policy-core.md) | Insert cancellation reason | Inline | [CANCEL_REASON_CODE](../database-tables.md#cancel_reason_code) | `clsCancellationReason` |
| [SQL-023](SQL-023-saif-business-policy-core.md) | Insert cancellation reason collection | Inline | [CANCEL_REASON_CODE](../database-tables.md#cancel_reason_code) | `clsCancellationReasonCollection` |
| [SQL-024](SQL-024-saif-business-policy-core.md) | Insert cancellation warning | Inline | [CANCELLATION](../database-tables.md#cancellation) | `clsCancellationWarning` |
| [SQL-025](SQL-025-saif-business-policy-core.md) | Insert cancellation warning collection | Inline | [CANCELLATION](../database-tables.md#cancellation) | `clsCancellationWarningCollection` |
| [SQL-026](SQL-026-saif-business-policy-core.md) | Insert cancel reason override | Inline | [CANCEL_REASON_OVERRIDE](../database-tables.md#cancel_reason_override) | `clsCancelReasonOverride` |
| [SQL-027](SQL-027-saif-business-policy-core.md) | Insert county | Inline | [COUNTY](../database-tables.md#county) | `clsCounty` |
| [SQL-028](SQL-028-saif-business-policy-core.md) | Insert county collection | Inline | [COUNTY](../database-tables.md#county) | `clsCountyCollection` |
| [SQL-029](SQL-029-saif-business-policy-core.md) | Insert insurance carrier | Inline | [CARRIER_CODE](../database-tables.md#carrier_code) | `clsInsuranceCarrier` |
| [SQL-030](SQL-030-saif-business-policy-core.md) | Insert location collection | Inline | [LOCATION](../database-tables.md#location) | `clsLocationCollection` |
| [SQL-031](SQL-031-saif-business-policy-core.md) | Insert policy period employer liability limits | Inline | [POLICY_PERIOD_EMP_LIAB](../database-tables.md#policy_period_emp_liab) | `clsPolicyPeriodEmployerLiabilityLimits` |
| [SQL-032](SQL-032-saif-business-policy-core.md) | Insert policy period employer liability limits collection | Inline | [POLICY_PERIOD_EMP_LIAB](../database-tables.md#policy_period_emp_liab) | `clsPolicyPeriodEmployerLiabilityLimitsCollection` |
| [SQL-033](SQL-033-saif-business-policy-core.md) | Insert policy period master | Inline | [POLICY_PERIOD_MASTER](../database-tables.md#policy_period_master) | `clsPolicyPeriodMaster` |
| [SQL-034](SQL-034-saif-business-policy-core.md) | Insert policy team function | Inline | [TEAM_FUNCTION_CODE](../database-tables.md#team_function_code) | `clsPolicyTeamFunction` |
| [SQL-035](SQL-035-saif-business-policy-core.md) | Insert policy team function collection | Inline | [TEAM_FUNCTION_CODE](../database-tables.md#team_function_code) | `clsPolicyTeamFunctionCollection` |
| [SQL-036](SQL-036-saif-business-policy-core.md) | Insert policy team member | Inline | [POLICY_TEAM_FUNCTION](../database-tables.md#policy_team_function) | `clsPolicyTeamMember` |
| [SQL-037](SQL-037-saif-business-policy-core.md) | Insert policy team member collection | Inline | [POLICY_TEAM_FUNCTION](../database-tables.md#policy_team_function) | `clsPolicyTeamMemberCollection` |
| [SQL-038](SQL-038-saif-business-policy-core.md) | Insert prior coverage | Inline | [PRIOR_COVERAGE](../database-tables.md#prior_coverage) | `clsPriorCoverage` |
| [SQL-039](SQL-039-saif-business-policy-core.md) | Insert prior coverage collection | Inline | [PRIOR_COVERAGE](../database-tables.md#prior_coverage) | `clsPriorCoverageCollection` |
| [SQL-040](SQL-040-saif-business-policy-core.md) | Insert s a i f office | Inline | [OFFICE_CODE](../database-tables.md#office_code) | `clsSAIFOffice` |
| [SQL-041](SQL-041-saif-business-policy-core.md) | Insert s a i f office collection | Inline | [OFFICE_CODE](../database-tables.md#office_code) | `clsSAIFOfficeCollection` |
| [SQL-042](SQL-042-saif-business-policy-core.md) | Insert w c i s employee | Inline | [WCIS_EMPLOYEE](../database-tables.md#wcis_employee) | `clsWCISEmployee` |
| [SQL-043](SQL-043-saif-business-policy-core.md) | Insert w c i s employee collection | Inline | [WCIS_EMPLOYEE](../database-tables.md#wcis_employee) | `clsWCISEmployeeCollection` |
| [SQL-044](SQL-044-saif-business-policy-core.md) | Call pk72899_production_error.sp72900_post_production_error | Stored Proc | N/A | `clsWCISInterfacer` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-045](SQL-045-saif-business-policy-core.md) | Retrieve cancellation reason | Inline | [CANCEL_REASON_CODE](../database-tables.md#cancel_reason_code) | `clsCancellationReason` |
| [SQL-046](SQL-046-saif-business-policy-core.md) | Retrieve cancellation reason collection | Inline | [CANCEL_REASON_CODE](../database-tables.md#cancel_reason_code) | `clsCancellationReasonCollection` |
| [SQL-047](SQL-047-saif-business-policy-core.md) | Retrieve cancellation warning | Inline | [CANCELLATION](../database-tables.md#cancellation) | `clsCancellationWarning` |
| [SQL-048](SQL-048-saif-business-policy-core.md) | Retrieve cancellation warning collection | Inline | [CANCELLATION](../database-tables.md#cancellation) | `clsCancellationWarningCollection` |
| [SQL-049](SQL-049-saif-business-policy-core.md) | Retrieve cancel reason override | Inline | [CANCELLATION](../database-tables.md#cancellation) | `clsCancelReasonOverride` |
| [SQL-050](SQL-050-saif-business-policy-core.md) | Retrieve cancel reason override | Inline | [CANCELLATION](../database-tables.md#cancellation), [CANCEL_REASON_CODE](../database-tables.md#cancel_reason_code) | `clsCancelReasonOverride` |
| [SQL-051](SQL-051-saif-business-policy-core.md) | Retrieve cancel reason override | Inline | [CANCELLATION](../database-tables.md#cancellation), [CARRIER_CHANGE_REASON_CODE](../database-tables.md#carrier_change_reason_code) | `clsCancelReasonOverride` |
| [SQL-052](SQL-052-saif-business-policy-core.md) | Retrieve cancel reason override | Inline | [CANCELLATION](../database-tables.md#cancellation), [CARRIER_CODE](../database-tables.md#carrier_code) | `clsCancelReasonOverride` |
| [SQL-053](SQL-053-saif-business-policy-core.md) | Retrieve cancel reason override | Inline | [CANCEL_REASON_OVERRIDE](../database-tables.md#cancel_reason_override) | `clsCancelReasonOverride` |
| [SQL-054](SQL-054-saif-business-policy-core.md) | Retrieve county | Inline | [COUNTY](../database-tables.md#county) | `clsCounty` |
| [SQL-055](SQL-055-saif-business-policy-core.md) | Retrieve county collection | Inline | [COUNTY](../database-tables.md#county) | `clsCountyCollection` |
| [SQL-056](SQL-056-saif-business-policy-core.md) | Retrieve employer liability limits | Inline | N/A | `clsEmployerLiabilityLimits` |
| [SQL-057](SQL-057-saif-business-policy-core.md) | Retrieve employer liability limits collection | Inline | [EMPLOYERS_LIABILITY_LIMITS](../database-tables.md#employers_liability_limits), [EMPLOYERS_LIABILITY_FACTORS](../database-tables.md#employers_liability_factors) | `clsEmployerLiabilityLimitsCollection` |
| [SQL-058](SQL-058-saif-business-policy-core.md) | Retrieve entity type | Inline | [ENTITY_CODE](../database-tables.md#entity_code) | `clsEntityType` |
| [SQL-059](SQL-059-saif-business-policy-core.md) | Retrieve entity type collection | Inline | [ENTITY_CODE](../database-tables.md#entity_code) | `clsEntityTypeCollection` |
| [SQL-060](SQL-060-saif-business-policy-core.md) | Retrieve insurance carrier | Inline | [CARRIER_CODE](../database-tables.md#carrier_code) | `clsInsuranceCarrier` |
| [SQL-061](SQL-061-saif-business-policy-core.md) | Call SP73029_GET_NONWCIS_GOV_CLASS | Stored Proc | N/A | `clsLegacyPolicyPeriod` |
| [SQL-062](SQL-062-saif-business-policy-core.md) | Retrieve legacy policy period | Inline | N/A | `clsLegacyPolicyPeriod` |
| [SQL-063](SQL-063-saif-business-policy-core.md) | Retrieve legacy policy period collection | Inline | [POLICY_PERIOD_NON_WCIS](../database-tables.md#policy_period_non_wcis) | `clsLegacyPolicyPeriodCollection` |
| [SQL-064](SQL-064-saif-business-policy-core.md) | Retrieve location | Inline | [LOCATION](../database-tables.md#location) | `clsLocation` |
| [SQL-065](SQL-065-saif-business-policy-core.md) | Retrieve location collection | Inline | [LOCATION](../database-tables.md#location) | `clsLocationCollection` |
| [SQL-066](SQL-066-saif-business-policy-core.md) | Retrieve location contact | Inline | [CONTACT](../database-tables.md#contact) | `clsLocationContact` |
| [SQL-067](SQL-067-saif-business-policy-core.md) | Retrieve location contact collection | Inline | [CONTACT](../database-tables.md#contact) | `clsLocationContactCollection` |
| [SQL-068](SQL-068-saif-business-policy-core.md) | Retrieve location type | Inline | [LOCATION_CODE](../database-tables.md#location_code) | `clsLocationType` |
| [SQL-069](SQL-069-saif-business-policy-core.md) | Retrieve location type collection | Inline | [LOCATION_CODE](../database-tables.md#location_code) | `clsLocationTypeCollection` |
| [SQL-070](SQL-070-saif-business-policy-core.md) | Retrieve policy | Inline | [CANCELLATION](../database-tables.md#cancellation) | `clsPolicy` |
| [SQL-071](SQL-071-saif-business-policy-core.md) | Retrieve policy | Inline | [POLICY_PERIOD_MASTER](../database-tables.md#policy_period_master) | `clsPolicy` |
| [SQL-072](SQL-072-saif-business-policy-core.md) | Retrieve policy | Inline | [BUSINESS](../database-tables.md#business) | `clsPolicy` |
| [SQL-073](SQL-073-saif-business-policy-core.md) | Retrieve policy | Inline | [POLICY](../database-tables.md#policy) | `clsPolicy` |
| [SQL-074](SQL-074-saif-business-policy-core.md) | Retrieve policy collection | Inline | [POLICY](../database-tables.md#policy) | `clsPolicyCollection` |
| [SQL-075](SQL-075-saif-business-policy-core.md) | Retrieve policy location | Inline | [CONTACT](../database-tables.md#contact) | `clsPolicyLocation` |
| [SQL-076](SQL-076-saif-business-policy-core.md) | Retrieve policy location | Inline | [LOCATION](../database-tables.md#location) | `clsPolicyLocation` |
| [SQL-077](SQL-077-saif-business-policy-core.md) | Retrieve policy location collection | Inline | [LOCATION](../database-tables.md#location) | `clsPolicyLocationCollection` |
| [SQL-078](SQL-078-saif-business-policy-core.md) | Call PK73059_prem_hist_summary.get_6_digit_gov_class | Stored Proc | N/A | `clsPolicyPeriod` |
| [SQL-079](SQL-079-saif-business-policy-core.md) | Call SP72658_GET_GOV_CLASS | Stored Proc | N/A | `clsPolicyPeriod` |
| [SQL-080](SQL-080-saif-business-policy-core.md) | Call Pk72195_Renewal.sp72187_get_standard_prem | Stored Proc | N/A | `clsPolicyPeriod` |
| [SQL-081](SQL-081-saif-business-policy-core.md) | Call pk72195_renewal.sp72190_calc_weighted_freq | Stored Proc | N/A | `clsPolicyPeriod` |
| [SQL-082](SQL-082-saif-business-policy-core.md) | Call sp73089_get_policy_bound_flag | Stored Proc | N/A | `clsPolicyPeriod` |
| [SQL-083](SQL-083-saif-business-policy-core.md) | Retrieve policy period | Inline | N/A | `clsPolicyPeriod` |
| [SQL-084](SQL-084-saif-business-policy-core.md) | Retrieve policy period base | Inline | [NON_WCIS_STAT_TRANS](../database-tables.md#non_wcis_stat_trans) | `clsPolicyPeriodBase` |
| [SQL-085](SQL-085-saif-business-policy-core.md) | Call pk72846_view_policy.sp73111_get_wcis_std_premium | Stored Proc | N/A | `clsPolicyPeriodBase` |
| [SQL-086](SQL-086-saif-business-policy-core.md) | Call pk73057_billing_master.is_on_arrears_plan | Stored Proc | N/A | `clsPolicyPeriodBase` |
| [SQL-087](SQL-087-saif-business-policy-core.md) | Call pk73057_billing_master.bm_report_schedule_flag_yn | Stored Proc | N/A | `clsPolicyPeriodBase` |
| [SQL-088](SQL-088-saif-business-policy-core.md) | Retrieve policy period collection | Inline | [POLICY_PERIOD](../database-tables.md#policy_period) | `clsPolicyPeriodCollection` |
| [SQL-089](SQL-089-saif-business-policy-core.md) | Retrieve policy period employer liability limits | Inline | [POLICY_PERIOD_EMP_LIAB](../database-tables.md#policy_period_emp_liab) | `clsPolicyPeriodEmployerLiabilityLimits` |
| [SQL-090](SQL-090-saif-business-policy-core.md) | Retrieve policy period employer liability limits collection | Inline | [POLICY_PERIOD_EMP_LIAB](../database-tables.md#policy_period_emp_liab) | `clsPolicyPeriodEmployerLiabilityLimitsCollection` |
| [SQL-091](SQL-091-saif-business-policy-core.md) | Retrieve policy period master | Inline | [POLICY_PERIOD_MASTER](../database-tables.md#policy_period_master) | `clsPolicyPeriodMaster` |
| [SQL-092](SQL-092-saif-business-policy-core.md) | Retrieve policy period status | Inline | [POLICY_PERIOD_STATUS_CODE](../database-tables.md#policy_period_status_code) | `clsPolicyPeriodStatus` |
| [SQL-093](SQL-093-saif-business-policy-core.md) | Retrieve policy period status collection | Inline | [POLICY_PERIOD_STATUS_CODE](../database-tables.md#policy_period_status_code) | `clsPolicyPeriodStatusCollection` |
| [SQL-094](SQL-094-saif-business-policy-core.md) | Retrieve policy status code | Inline | [POLICY_STATUS_CODE](../database-tables.md#policy_status_code) | `clsPolicyStatusCode` |
| [SQL-095](SQL-095-saif-business-policy-core.md) | Retrieve policy status code collection | Inline | [POLICY_STATUS_CODE](../database-tables.md#policy_status_code) | `clsPolicyStatusCodeCollection` |
| [SQL-096](SQL-096-saif-business-policy-core.md) | Retrieve policy team function | Inline | [TEAM_FUNCTION_CODE](../database-tables.md#team_function_code) | `clsPolicyTeamFunction` |
| [SQL-097](SQL-097-saif-business-policy-core.md) | Retrieve policy team function collection | Inline | [TEAM_FUNCTION_CODE](../database-tables.md#team_function_code) | `clsPolicyTeamFunctionCollection` |
| [SQL-098](SQL-098-saif-business-policy-core.md) | Retrieve policy team member | Inline | [POLICY_TEAM_FUNCTION](../database-tables.md#policy_team_function) | `clsPolicyTeamMember` |
| [SQL-099](SQL-099-saif-business-policy-core.md) | Retrieve policy team member collection | Inline | [POLICY_TEAM_FUNCTION](../database-tables.md#policy_team_function) | `clsPolicyTeamMemberCollection` |
| [SQL-100](SQL-100-saif-business-policy-core.md) | Retrieve prior coverage | Inline | [PRIOR_COVERAGE](../database-tables.md#prior_coverage) | `clsPriorCoverage` |
| [SQL-101](SQL-101-saif-business-policy-core.md) | Retrieve prior coverage collection | Inline | [PRIOR_COVERAGE](../database-tables.md#prior_coverage) | `clsPriorCoverageCollection` |
| [SQL-102](SQL-102-saif-business-policy-core.md) | Retrieve s a i f office | Inline | [OFFICE_CODE](../database-tables.md#office_code) | `clsSAIFOffice` |
| [SQL-103](SQL-103-saif-business-policy-core.md) | Retrieve s a i f office collection | Inline | [OFFICE_CODE](../database-tables.md#office_code) | `clsSAIFOfficeCollection` |
| [SQL-104](SQL-104-saif-business-policy-core.md) | Retrieve w c i s employee | Inline | [WCIS_EMPLOYEE](../database-tables.md#wcis_employee) | `clsWCISEmployee` |
| [SQL-105](SQL-105-saif-business-policy-core.md) | Retrieve w c i s employee collection | Inline | [WCIS_EMPLOYEE](../database-tables.md#wcis_employee) | `clsWCISEmployeeCollection` |
| [SQL-106](SQL-106-saif-business-policy-core.md) | Retrieve w c i s inquiry | Inline | [SUB_CONSTANTS](../database-tables.md#sub_constants) | `WCISInquiry` |
| [SQL-107](SQL-107-saif-business-policy-core.md) | Call Pk73190_Quoteprint.Get_Billing_Master_Count | Stored Proc | N/A | `WCISInquiry` |
| [SQL-108](SQL-108-saif-business-policy-core.md) | Call sp72814_get_cont_cov_date | Stored Proc | N/A | `WCISInquiry` |
| [SQL-109](SQL-109-saif-business-policy-core.md) | Retrieve w c i s inquiry | Inline | [POLICY_PERIOD](../database-tables.md#policy_period) | `WCISInquiry` |
| [SQL-110](SQL-110-saif-business-policy-core.md) | Call pk73059_prem_hist_summary.determine_manual_premium | Stored Proc | N/A | `WCISInquiry` |
| [SQL-111](SQL-111-saif-business-policy-core.md) | Retrieve w c i s inquiry | Inline | [POLICY](../database-tables.md#policy) | `WCISInquiry` |
| [SQL-112](SQL-112-saif-business-policy-core.md) | Retrieve w c i s inquiry | Inline | [POLICY_PERIOD](../database-tables.md#policy_period) | `WCISInquiry` |
| [SQL-113](SQL-113-saif-business-policy-core.md) | Retrieve w c i s inquiry | Inline | [SUB_CONSTANTS](../database-tables.md#sub_constants) | `WCISInquiry` |
| [SQL-114](SQL-114-saif-business-policy-core.md) | Retrieve w c i s inquiry | Inline | [POLICY](../database-tables.md#policy) | `WCISInquiry` |
| [SQL-115](SQL-115-saif-business-policy-core.md) | Retrieve w c i s inquiry | Inline | [POLICY](../database-tables.md#policy) | `WCISInquiry` |
| [SQL-116](SQL-116-saif-business-policy-core.md) | Call Pk73190_Quoteprint.Get_Premium_History_Count | Stored Proc | N/A | `WCISInquiry` |
| [SQL-117](SQL-117-saif-business-policy-core.md) | Call Pk73190_Quoteprint.Get_Rating_Plan_Count | Stored Proc | N/A | `WCISInquiry` |
| [SQL-118](SQL-118-saif-business-policy-core.md) | Retrieve w c i s inquiry | Inline | [WCIS_CONSTANTS](../database-tables.md#wcis_constants) | `WCISInquiry` |
| [SQL-119](SQL-119-saif-business-policy-core.md) | Call SP72347_INFO_PAGE_PRINTED_YN | Stored Proc | N/A | `WCISInquiry` |
| [SQL-120](SQL-120-saif-business-policy-core.md) | Call Sp72803_Edit_Prelim_Audit | Stored Proc | N/A | `WCISInquiry` |
| [SQL-121](SQL-121-saif-business-policy-core.md) | Call pk72226_team_assignment.regional_office_yn | Stored Proc | N/A | `WCISInquiry` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-122](SQL-122-saif-business-policy-core.md) | Update cancellation reason | Inline | [CANCEL_REASON_CODE](../database-tables.md#cancel_reason_code) | `clsCancellationReason` |
| [SQL-123](SQL-123-saif-business-policy-core.md) | Update cancellation reason collection | Inline | [CANCEL_REASON_CODE](../database-tables.md#cancel_reason_code) | `clsCancellationReasonCollection` |
| [SQL-124](SQL-124-saif-business-policy-core.md) | Update cancellation warning | Inline | [CANCELLATION](../database-tables.md#cancellation) | `clsCancellationWarning` |
| [SQL-125](SQL-125-saif-business-policy-core.md) | Update cancellation warning collection | Inline | [CANCELLATION](../database-tables.md#cancellation) | `clsCancellationWarningCollection` |
| [SQL-126](SQL-126-saif-business-policy-core.md) | Update county | Inline | [COUNTY](../database-tables.md#county) | `clsCounty` |
| [SQL-127](SQL-127-saif-business-policy-core.md) | Update county collection | Inline | [COUNTY](../database-tables.md#county) | `clsCountyCollection` |
| [SQL-128](SQL-128-saif-business-policy-core.md) | Update insurance carrier | Inline | [CARRIER_CODE](../database-tables.md#carrier_code) | `clsInsuranceCarrier` |
| [SQL-129](SQL-129-saif-business-policy-core.md) | Update location | Inline | [LOCATION](../database-tables.md#location) | `clsLocation` |
| [SQL-130](SQL-130-saif-business-policy-core.md) | Update location collection | Inline | [LOCATION](../database-tables.md#location) | `clsLocationCollection` |
| [SQL-131](SQL-131-saif-business-policy-core.md) | Update policy location | Inline | [LOCATION_VIEW](../database-tables.md#location_view) | `clsPolicyLocation` |
| [SQL-132](SQL-132-saif-business-policy-core.md) | Update policy period employer liability limits | Inline | [POLICY_PERIOD_EMP_LIAB](../database-tables.md#policy_period_emp_liab) | `clsPolicyPeriodEmployerLiabilityLimits` |
| [SQL-133](SQL-133-saif-business-policy-core.md) | Update policy period employer liability limits collection | Inline | [POLICY_PERIOD_EMP_LIAB](../database-tables.md#policy_period_emp_liab) | `clsPolicyPeriodEmployerLiabilityLimitsCollection` |
| [SQL-134](SQL-134-saif-business-policy-core.md) | Update policy period master | Inline | [POLICY_PERIOD_MASTER](../database-tables.md#policy_period_master) | `clsPolicyPeriodMaster` |
| [SQL-135](SQL-135-saif-business-policy-core.md) | Update policy team function | Inline | [TEAM_FUNCTION_CODE](../database-tables.md#team_function_code) | `clsPolicyTeamFunction` |
| [SQL-136](SQL-136-saif-business-policy-core.md) | Update policy team function collection | Inline | [TEAM_FUNCTION_CODE](../database-tables.md#team_function_code) | `clsPolicyTeamFunctionCollection` |
| [SQL-137](SQL-137-saif-business-policy-core.md) | Update policy team member | Inline | [POLICY_TEAM_FUNCTION](../database-tables.md#policy_team_function) | `clsPolicyTeamMember` |
| [SQL-138](SQL-138-saif-business-policy-core.md) | Update policy team member collection | Inline | [POLICY_TEAM_FUNCTION](../database-tables.md#policy_team_function) | `clsPolicyTeamMemberCollection` |
| [SQL-139](SQL-139-saif-business-policy-core.md) | Update prior coverage | Inline | [PRIOR_COVERAGE](../database-tables.md#prior_coverage) | `clsPriorCoverage` |
| [SQL-140](SQL-140-saif-business-policy-core.md) | Update prior coverage collection | Inline | [PRIOR_COVERAGE](../database-tables.md#prior_coverage) | `clsPriorCoverageCollection` |
| [SQL-141](SQL-141-saif-business-policy-core.md) | Update s a i f office | Inline | [OFFICE_CODE](../database-tables.md#office_code) | `clsSAIFOffice` |
| [SQL-142](SQL-142-saif-business-policy-core.md) | Update s a i f office collection | Inline | [OFFICE_CODE](../database-tables.md#office_code) | `clsSAIFOfficeCollection` |
| [SQL-143](SQL-143-saif-business-policy-core.md) | Update w c i s employee | Inline | [WCIS_EMPLOYEE](../database-tables.md#wcis_employee) | `clsWCISEmployee` |
| [SQL-144](SQL-144-saif-business-policy-core.md) | Update w c i s employee collection | Inline | [WCIS_EMPLOYEE](../database-tables.md#wcis_employee) | `clsWCISEmployeeCollection` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-145](SQL-145-saif-business-policy-core.md) | Delete cancellation reason | Inline | [CANCEL_REASON_CODE](../database-tables.md#cancel_reason_code) | `clsCancellationReason` |
| [SQL-146](SQL-146-saif-business-policy-core.md) | Delete cancellation reason collection | Inline | [CANCEL_REASON_CODE](../database-tables.md#cancel_reason_code) | `clsCancellationReasonCollection` |
| [SQL-147](SQL-147-saif-business-policy-core.md) | Delete cancellation warning | Inline | [CANCELLATION](../database-tables.md#cancellation) | `clsCancellationWarning` |
| [SQL-148](SQL-148-saif-business-policy-core.md) | Delete cancellation warning collection | Inline | [CANCELLATION](../database-tables.md#cancellation) | `clsCancellationWarningCollection` |
| [SQL-149](SQL-149-saif-business-policy-core.md) | Delete county | Inline | [COUNTY](../database-tables.md#county) | `clsCounty` |
| [SQL-150](SQL-150-saif-business-policy-core.md) | Delete county collection | Inline | [COUNTY](../database-tables.md#county) | `clsCountyCollection` |
| [SQL-151](SQL-151-saif-business-policy-core.md) | Delete insurance carrier | Inline | [CARRIER_CODE](../database-tables.md#carrier_code) | `clsInsuranceCarrier` |
| [SQL-152](SQL-152-saif-business-policy-core.md) | Delete location collection | Inline | [LOCATION](../database-tables.md#location) | `clsLocationCollection` |
| [SQL-153](SQL-153-saif-business-policy-core.md) | Delete policy period employer liability limits | Inline | [POLICY_PERIOD_EMP_LIAB](../database-tables.md#policy_period_emp_liab) | `clsPolicyPeriodEmployerLiabilityLimits` |
| [SQL-154](SQL-154-saif-business-policy-core.md) | Delete policy period employer liability limits collection | Inline | [POLICY_PERIOD_EMP_LIAB](../database-tables.md#policy_period_emp_liab) | `clsPolicyPeriodEmployerLiabilityLimitsCollection` |
| [SQL-155](SQL-155-saif-business-policy-core.md) | Delete policy period master | Inline | [POLICY_PERIOD_MASTER](../database-tables.md#policy_period_master) | `clsPolicyPeriodMaster` |
| [SQL-156](SQL-156-saif-business-policy-core.md) | Delete policy team function | Inline | [TEAM_FUNCTION_CODE](../database-tables.md#team_function_code) | `clsPolicyTeamFunction` |
| [SQL-157](SQL-157-saif-business-policy-core.md) | Delete policy team function collection | Inline | [TEAM_FUNCTION_CODE](../database-tables.md#team_function_code) | `clsPolicyTeamFunctionCollection` |
| [SQL-158](SQL-158-saif-business-policy-core.md) | Delete policy team member | Inline | [POLICY_TEAM_FUNCTION](../database-tables.md#policy_team_function) | `clsPolicyTeamMember` |
| [SQL-159](SQL-159-saif-business-policy-core.md) | Delete policy team member collection | Inline | [POLICY_TEAM_FUNCTION](../database-tables.md#policy_team_function) | `clsPolicyTeamMemberCollection` |
| [SQL-160](SQL-160-saif-business-policy-core.md) | Delete prior coverage | Inline | [PRIOR_COVERAGE](../database-tables.md#prior_coverage) | `clsPriorCoverage` |
| [SQL-161](SQL-161-saif-business-policy-core.md) | Delete prior coverage collection | Inline | [PRIOR_COVERAGE](../database-tables.md#prior_coverage) | `clsPriorCoverageCollection` |
| [SQL-162](SQL-162-saif-business-policy-core.md) | Delete s a i f office | Inline | [OFFICE_CODE](../database-tables.md#office_code) | `clsSAIFOffice` |
| [SQL-163](SQL-163-saif-business-policy-core.md) | Delete s a i f office collection | Inline | [OFFICE_CODE](../database-tables.md#office_code) | `clsSAIFOfficeCollection` |
| [SQL-164](SQL-164-saif-business-policy-core.md) | Delete w c i s employee | Inline | [WCIS_EMPLOYEE](../database-tables.md#wcis_employee) | `clsWCISEmployee` |
| [SQL-165](SQL-165-saif-business-policy-core.md) | Delete w c i s employee collection | Inline | [WCIS_EMPLOYEE](../database-tables.md#wcis_employee) | `clsWCISEmployeeCollection` |

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-business-policy-core.md) | Fetch next cancellation reason sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsCancellationReason` |
| [SQL-002](SQL-002-saif-business-policy-core.md) | Fetch next cancellation reason collection sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsCancellationReasonCollection` |
| [SQL-003](SQL-003-saif-business-policy-core.md) | Fetch next cancellation warning sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsCancellationWarning` |
| [SQL-004](SQL-004-saif-business-policy-core.md) | Fetch next cancellation warning collection sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsCancellationWarningCollection` |
| [SQL-005](SQL-005-saif-business-policy-core.md) | Fetch next county sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsCounty` |
| [SQL-006](SQL-006-saif-business-policy-core.md) | Fetch next county collection sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsCountyCollection` |
| [SQL-007](SQL-007-saif-business-policy-core.md) | Fetch next insurance carrier sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsInsuranceCarrier` |
| [SQL-008](SQL-008-saif-business-policy-core.md) | Fetch next location sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsLocation` |
| [SQL-009](SQL-009-saif-business-policy-core.md) | Fetch next location collection sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsLocationCollection` |
| [SQL-010](SQL-010-saif-business-policy-core.md) | Fetch next policy period employer liability limits sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsPolicyPeriodEmployerLiabilityLimits` |
| [SQL-011](SQL-011-saif-business-policy-core.md) | Fetch next policy period employer liability limits collection sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsPolicyPeriodEmployerLiabilityLimitsCollection` |
| [SQL-012](SQL-012-saif-business-policy-core.md) | Fetch next policy period master sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsPolicyPeriodMaster` |
| [SQL-013](SQL-013-saif-business-policy-core.md) | Fetch next policy team function sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsPolicyTeamFunction` |
| [SQL-014](SQL-014-saif-business-policy-core.md) | Fetch next policy team function collection sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsPolicyTeamFunctionCollection` |
| [SQL-015](SQL-015-saif-business-policy-core.md) | Fetch next policy team member collection sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsPolicyTeamMemberCollection` |
| [SQL-016](SQL-016-saif-business-policy-core.md) | Fetch next prior coverage sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsPriorCoverage` |
| [SQL-017](SQL-017-saif-business-policy-core.md) | Fetch next prior coverage collection sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsPriorCoverageCollection` |
| [SQL-018](SQL-018-saif-business-policy-core.md) | Fetch next s a i f office sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsSAIFOffice` |
| [SQL-019](SQL-019-saif-business-policy-core.md) | Fetch next s a i f office collection sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsSAIFOfficeCollection` |
| [SQL-020](SQL-020-saif-business-policy-core.md) | Fetch next w c i s employee sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsWCISEmployee` |
| [SQL-021](SQL-021-saif-business-policy-core.md) | Fetch next w c i s employee collection sequence value | `DUAL` | [DUAL](../database-tables.md#dual) | `clsWCISEmployeeCollection` |

## 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)
- [Database tables](../database-tables.md)
- [Procedures](../procedures/index.md)
- [Configuration](../configuration.md)
- [API reference](../api/index.md)

## 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\WCISInquiry.vb`
- `Business\SAIF.Business.Policy.Core\clsWCISInterfacer.vb`