--- title: SAIF.Business.Policy.Audit.Premium 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.Audit.Premium reference_type: package --- # SAIF.Business.Policy.Audit.Premium 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 | Usage inferred from SQL and source.* | `clsAudit`, `clsAuditCollection` | | [`COUNTY`](#county) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditCollection`, `clsZipCode`, `clsZipCodeCollection` | | [`DUAL`](#dual) | Oracle | `[unqualified]`** | — | Usage inferred from SQL and source.* | `clsAudit`, `clsAuditEvent` | | [`ER_COMBINATION_POLICY`](#er_combination_policy) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditPolicyCollection` | | [`LF_APVENMAST`](#lf_apvenmast) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditSelectionNotification` | | [`LOCATION`](#location) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditCollection` | | [`OFFICE_CODE`](#office_code) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditCollection`, `clsZipCode`, `clsZipCodeCollection` | | [`PA_ASSIGN_OVERRIDE`](#pa_assign_override) | Oracle | `[unqualified]`** | CRU | Usage inferred from SQL and source.* | `clsAuditAssignmentOverride` | | [`PA_AUDIT`](#pa_audit) | Oracle | `[unqualified]`** | CRUD | Usage inferred from SQL and source.* | `clsAudit`, `clsAuditCollection`, `clsAuditReviewResult`, `clsAuditReviewResultCollection` | | [`PA_AUDITOR`](#pa_auditor) | Oracle | `[unqualified]`** | CRU | Usage inferred from SQL and source.* | `clsAuditCollection`, `clsAuditor`, `clsAuditorCollection` | | [`PA_AUDITOR_ZIP_CODE`](#pa_auditor_zip_code) | Oracle | `[unqualified]`** | CRUD | Usage inferred from SQL and source.* | `clsAuditCollection`, `clsAuditorZipCode`, `clsAuditorZipCodeCollection` | | [`PA_EVENT`](#pa_event) | Oracle | `[unqualified]`** | CRUD | Usage inferred from SQL and source.* | `clsAuditEvent`, `clsAuditEventCollection` | | [`PA_POLICY`](#pa_policy) | Oracle | `[unqualified]`** | CRU | Usage inferred from SQL and source.* | `clsAuditPolicySchedulingDetail`, `clsAuditSelectionOverride` | | [`PA_POLICY_PERIOD`](#pa_policy_period) | Oracle | `[unqualified]`** | CRUD | Usage inferred from SQL and source.* | `clsAudit`, `clsAuditCollection`, `clsAuditPolicyPeriod` | | [`PA_PREMIUM_AUDIT_RESULT`](#pa_premium_audit_result) | Oracle | `[unqualified]`** | CRUD | Usage inferred from SQL and source.* | `clsPremiumAuditResult` | | [`PA_REASON_CODE`](#pa_reason_code) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsPAReasonCode`, `clsPAReasonCodeCollection` | | [`PA_RESULT`](#pa_result) | Oracle | `[unqualified]`** | CRUD | Usage inferred from SQL and source.* | `clsAuditResult`, `clsAuditResultCollection` | | [`PA_RESULT_TYPE`](#pa_result_type) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditResultCollection`, `clsAuditResultType`, `clsAuditResultTypeCollection` | | [`PA_REVIEW_REASON_CODE`](#pa_review_reason_code) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditReviewReasonCode`, `clsAuditReviewReasonCodeCollection` | | [`PA_REVIEW_REASON_RESULT`](#pa_review_reason_result) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditReviewReasonCode`, `clsAuditReviewReasonCodeCollection`, `clsAuditReviewResultCode`, `clsAuditReviewResultCodeCollection` | | [`PA_REVIEW_RESULT`](#pa_review_result) | Oracle | `[unqualified]`** | CRUD | Usage inferred from SQL and source.* | `clsAuditReviewResult`, `clsAuditReviewResultCollection` | | [`PA_REVIEW_RESULT_CODE`](#pa_review_result_code) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditReviewResultCode`, `clsAuditReviewResultCodeCollection` | | [`PA_SELECTION_CATEGORY_CODE`](#pa_selection_category_code) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditSelectionCategoryCode`, `clsAuditSelectionCategoryCodeCollection`, `clsAuditSelectionCategoryCollection` | | [`PA_SELECTION_RULE`](#pa_selection_rule) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditSelectionTestResultCollection`, `clsAuditSelectionTester`, `clsAuditSelectionTesterValueCollection`, `clsWorkbookReviewTester` | | [`PA_SELECTION_RULE_THRESHOLD`](#pa_selection_rule_threshold) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditSelectionTester` | | [`PA_SELECTION_RULE_VALUE`](#pa_selection_rule_value) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditSelectionTesterValue`, `clsAuditSelectionTesterValueCollection` | | [`PA_SELECTION_TEST`](#pa_selection_test) | Oracle | `[unqualified]`** | CRD | Usage inferred from SQL and source.* | `clsAuditSelectionTestResult`, `clsAuditSelectionTestResultCollection` | | [`PA_SLCTN_CATEGORY_GROUP_CODE`](#pa_slctn_category_group_code) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditSelectionCategoryCode`, `clsAuditSelectionCategoryCodeCollection` | | [`PA_SLCTN_CATEGORY_MARKET_TYPE`](#pa_slctn_category_market_type) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditSelectionCategoryCollection`, `clsAuditSelectionTester`, `clsAuditSelectionTesterValueCollection`, `clsWorkbookReviewTester` | | [`PA_SLCTN_CAT_MKT_TYPE_REASON`](#pa_slctn_cat_mkt_type_reason) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditSelectionCategoryCollection` | | [`PA_SLCTN_CAT_MKT_TYPE_RSN_RULE`](#pa_slctn_cat_mkt_type_rsn_rule) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditSelectionTester`, `clsAuditSelectionTesterValueCollection`, `clsWorkbookReviewTester` | | [`PA_STATUS_CODE`](#pa_status_code) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsStatusCollection` | | [`PA_TYPE_CODE`](#pa_type_code) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsPremiumAuditTypeCode`, `clsPremiumAuditTypeCodeCollection` | | [`PA_TYPE_MARKET_TYPE`](#pa_type_market_type) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsPremiumAuditTypeCode`, `clsPremiumAuditTypeCodeCollection` | | [`PA_ZIP_CODE`](#pa_zip_code) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditCollection`, `clsZipCode`, `clsZipCodeCollection` | | [`POLICY`](#policy) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAudit`, `clsAuditCollection`, `clsAuditPolicyCollection` | | [`POLICY_PERIOD`](#policy_period) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAuditCollection` | | [`TRADING_AS`](#trading_as) | Oracle | `[unqualified]`** | R | Usage inferred from SQL and source.* | `clsAudit`, `clsAuditPolicyCollection` | ## `BUSINESS` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAudit`, `clsAuditCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `COUNTY` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditCollection`, `clsZipCode`, `clsZipCodeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `DUAL` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | — | | **Key columns used** | See linked SQL documents. | | **Sequence** | Yes | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAudit`, `clsAuditEvent` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `ER_COMBINATION_POLICY` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditPolicyCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `LF_APVENMAST` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditSelectionNotification` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `LOCATION` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `OFFICE_CODE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditCollection`, `clsZipCode`, `clsZipCodeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_ASSIGN_OVERRIDE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | CRU | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditAssignmentOverride` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_AUDIT` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | CRUD | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAudit`, `clsAuditCollection`, `clsAuditReviewResult`, `clsAuditReviewResultCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_AUDITOR` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | CRU | | **Key columns used** | See linked SQL documents. | | **Sequence** | Yes | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditCollection`, `clsAuditor`, `clsAuditorCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_AUDITOR_ZIP_CODE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | CRUD | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditCollection`, `clsAuditorZipCode`, `clsAuditorZipCodeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_EVENT` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | CRUD | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditEvent`, `clsAuditEventCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_POLICY` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | CRU | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditPolicySchedulingDetail`, `clsAuditSelectionOverride` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_POLICY_PERIOD` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | CRUD | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAudit`, `clsAuditCollection`, `clsAuditPolicyPeriod` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_PREMIUM_AUDIT_RESULT` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | CRUD | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsPremiumAuditResult` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_REASON_CODE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsPAReasonCode`, `clsPAReasonCodeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_RESULT` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | CRUD | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditResult`, `clsAuditResultCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_RESULT_TYPE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditResultCollection`, `clsAuditResultType`, `clsAuditResultTypeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_REVIEW_REASON_CODE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditReviewReasonCode`, `clsAuditReviewReasonCodeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_REVIEW_REASON_RESULT` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditReviewReasonCode`, `clsAuditReviewReasonCodeCollection`, `clsAuditReviewResultCode`, `clsAuditReviewResultCodeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_REVIEW_RESULT` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | CRUD | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditReviewResult`, `clsAuditReviewResultCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_REVIEW_RESULT_CODE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditReviewResultCode`, `clsAuditReviewResultCodeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_SELECTION_CATEGORY_CODE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditSelectionCategoryCode`, `clsAuditSelectionCategoryCodeCollection`, `clsAuditSelectionCategoryCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_SELECTION_RULE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditSelectionTestResultCollection`, `clsAuditSelectionTester`, `clsAuditSelectionTesterValueCollection`, `clsWorkbookReviewTester` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_SELECTION_RULE_THRESHOLD` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditSelectionTester` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_SELECTION_RULE_VALUE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditSelectionTesterValue`, `clsAuditSelectionTesterValueCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_SELECTION_TEST` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | CRD | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditSelectionTestResult`, `clsAuditSelectionTestResultCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_SLCTN_CATEGORY_GROUP_CODE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditSelectionCategoryCode`, `clsAuditSelectionCategoryCodeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_SLCTN_CATEGORY_MARKET_TYPE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditSelectionCategoryCollection`, `clsAuditSelectionTester`, `clsAuditSelectionTesterValueCollection`, `clsWorkbookReviewTester` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_SLCTN_CAT_MKT_TYPE_REASON` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditSelectionCategoryCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_SLCTN_CAT_MKT_TYPE_RSN_RULE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditSelectionTester`, `clsAuditSelectionTesterValueCollection`, `clsWorkbookReviewTester` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_STATUS_CODE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsStatusCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_TYPE_CODE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsPremiumAuditTypeCode`, `clsPremiumAuditTypeCodeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_TYPE_MARKET_TYPE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsPremiumAuditTypeCode`, `clsPremiumAuditTypeCodeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `PA_ZIP_CODE` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditCollection`, `clsZipCode`, `clsZipCodeCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `POLICY` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAudit`, `clsAuditCollection`, `clsAuditPolicyCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `POLICY_PERIOD` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAuditCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## `TRADING_AS` | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | `[unqualified]`** | | **Purpose** | Usage inferred from SQL and source.* | | **Access pattern** | direct SQL / stored procedure | | **CRUD operations** | R | | **Key columns used** | See linked SQL documents. | | **Sequence** | No | | **Related tables** | See relationship diagram below. | | **Business objects** | `clsAudit`, `clsAuditPolicyCollection` | ### SQL referencing this table - See [SQL catalog](sql/index.md) --- ## Table relationship diagram The following diagram shows relationships between tables used by this library. ```mermaid erDiagram POLICY ||--o{ PA_AUDIT : "One-to-many" PA_AUDIT ||--o{ PA_AUDIT : "Self-referencing, zero-or-one" PA_AUDIT ||--o{ PA_POLICY_PERIOD : "One-to-many" PA_AUDIT ||--o{ PA_EVENT : "One-to-many" PA_AUDIT ||--o{ PA_RESULT : "One-to-many" PA_AUDIT ||--o{ PA_REVIEW_RESULT : "One-to-many" PA_AUDIT ||--o{ PA_SELECTION_TEST : "One-to-many" PA_AUDIT ||--o{ PA_PREMIUM_AUDIT_RESULT : "One-to-many" PA_TYPE_CODE ||--o{ PA_AUDIT : "Lookup (one-to-many)" PA_STATUS_CODE ||--o{ PA_AUDIT : "Lookup (one-to-many)" PA_REASON_CODE ||--o{ PA_AUDIT : "Lookup (one-to-many)" PA_AUDITOR ||--o{ PA_AUDIT : "Lookup (one-to-many)" OFFICE_CODE ||--o{ PA_AUDIT : "Lookup (one-to-many)" PA_TYPE_CODE ||--o{ PA_TYPE_MARKET_TYPE : "One-to-many" PA_RESULT_TYPE ||--o{ PA_RESULT : "Lookup (one-to-many)" PA_TYPE_CODE ||--o{ PA_RESULT_TYPE : "Lookup (one-to-many)" PA_REVIEW_RESULT_CODE ||--o{ PA_REVIEW_RESULT : "Lookup (one-to-many)" PA_REVIEW_REASON_CODE ||--o{ PA_REVIEW_REASON_RESULT : "One-to-many (bridge)" PA_REVIEW_RESULT_CODE ||--o{ PA_REVIEW_REASON_RESULT : "One-to-many (bridge)" PA_SLCTN_CATEGORY_GROUP_CODE ||--o{ PA_SELECTION_CATEGORY_CODE : "Lookup (one-to-many)" PA_SELECTION_CATEGORY_CODE ||--o{ PA_SLCTN_CATEGORY_MARKET_TYPE : "One-to-many" PA_SLCTN_CATEGORY_MARKET_TYPE ||--o{ PA_SLCTN_CAT_MKT_TYPE_REASON : "One-to-many" PA_SLCTN_CATEGORY_MARKET_TYPE ||--o{ PA_SLCTN_CAT_MKT_TYPE_RSN_RULE : "One-to-many" PA_SELECTION_RULE ||--o{ PA_SLCTN_CAT_MKT_TYPE_RSN_RULE : "One-to-many (bridge)" PA_SELECTION_RULE ||--o{ PA_SELECTION_RULE_VALUE : "One-to-many" PA_SELECTION_RULE ||--o{ PA_SELECTION_TEST : "One-to-many" PA_AUDITOR ||--o{ PA_AUDITOR_ZIP_CODE : "One-to-many (auditor territory)" PA_ZIP_CODE ||--o{ PA_AUDITOR_ZIP_CODE : "One-to-many" LOCATION ||--o{ PA_AUDITOR_ZIP_CODE : "Many-to-one (address → territory)" COUNTY ||--o{ PA_ZIP_CODE : "Lookup (one-to-many)" OFFICE_CODE ||--o{ COUNTY : "Lookup (one-to-many)" OFFICE_CODE ||--o{ PA_ZIP_CODE : "Lookup (one-to-many)" POLICY ||--o{ LOCATION : "One-to-many" POLICY ||--o{ PA_POLICY : "One-to-one (per-policy audit settings)" POLICY ||--o{ PA_ASSIGN_OVERRIDE : "One-to-one (per-policy assignment override)" POLICY ||--o{ TRADING_AS : "One-to-many (assumed business names)" POLICY ||--o{ BUSINESS : "One-to-many" POLICY ||--o{ POLICY_PERIOD : "One-to-many" POLICY ||--o{ ER_COMBINATION_POLICY : "One-to-many" ER_COMBINATION_POLICY ||--o{ ER_COMBINATION_POLICY : "Self-referencing many-to-many (combination membership)" ``` ## 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) > **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