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`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAudit`, `clsAuditCollection`
`COUNTY`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditCollection`, `clsZipCode`, `clsZipCodeCollection`
`DUAL`	Oracle	`[unqualified]`**	—	Usage inferred from SQL and source.*	`clsAudit`, `clsAuditEvent`
`ER_COMBINATION_POLICY`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditPolicyCollection`
`LF_APVENMAST`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditSelectionNotification`
`LOCATION`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditCollection`
`OFFICE_CODE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditCollection`, `clsZipCode`, `clsZipCodeCollection`
`PA_ASSIGN_OVERRIDE`	Oracle	`[unqualified]`**	CRU	Usage inferred from SQL and source.*	`clsAuditAssignmentOverride`
`PA_AUDIT`	Oracle	`[unqualified]`**	CRUD	Usage inferred from SQL and source.*	`clsAudit`, `clsAuditCollection`, `clsAuditReviewResult`, `clsAuditReviewResultCollection`
`PA_AUDITOR`	Oracle	`[unqualified]`**	CRU	Usage inferred from SQL and source.*	`clsAuditCollection`, `clsAuditor`, `clsAuditorCollection`
`PA_AUDITOR_ZIP_CODE`	Oracle	`[unqualified]`**	CRUD	Usage inferred from SQL and source.*	`clsAuditCollection`, `clsAuditorZipCode`, `clsAuditorZipCodeCollection`
`PA_EVENT`	Oracle	`[unqualified]`**	CRUD	Usage inferred from SQL and source.*	`clsAuditEvent`, `clsAuditEventCollection`
`PA_POLICY`	Oracle	`[unqualified]`**	CRU	Usage inferred from SQL and source.*	`clsAuditPolicySchedulingDetail`, `clsAuditSelectionOverride`
`PA_POLICY_PERIOD`	Oracle	`[unqualified]`**	CRUD	Usage inferred from SQL and source.*	`clsAudit`, `clsAuditCollection`, `clsAuditPolicyPeriod`
`PA_PREMIUM_AUDIT_RESULT`	Oracle	`[unqualified]`**	CRUD	Usage inferred from SQL and source.*	`clsPremiumAuditResult`
`PA_REASON_CODE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsPAReasonCode`, `clsPAReasonCodeCollection`
`PA_RESULT`	Oracle	`[unqualified]`**	CRUD	Usage inferred from SQL and source.*	`clsAuditResult`, `clsAuditResultCollection`
`PA_RESULT_TYPE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditResultCollection`, `clsAuditResultType`, `clsAuditResultTypeCollection`
`PA_REVIEW_REASON_CODE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditReviewReasonCode`, `clsAuditReviewReasonCodeCollection`
`PA_REVIEW_REASON_RESULT`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditReviewReasonCode`, `clsAuditReviewReasonCodeCollection`, `clsAuditReviewResultCode`, `clsAuditReviewResultCodeCollection`
`PA_REVIEW_RESULT`	Oracle	`[unqualified]`**	CRUD	Usage inferred from SQL and source.*	`clsAuditReviewResult`, `clsAuditReviewResultCollection`
`PA_REVIEW_RESULT_CODE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditReviewResultCode`, `clsAuditReviewResultCodeCollection`
`PA_SELECTION_CATEGORY_CODE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditSelectionCategoryCode`, `clsAuditSelectionCategoryCodeCollection`, `clsAuditSelectionCategoryCollection`
`PA_SELECTION_RULE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditSelectionTestResultCollection`, `clsAuditSelectionTester`, `clsAuditSelectionTesterValueCollection`, `clsWorkbookReviewTester`
`PA_SELECTION_RULE_THRESHOLD`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditSelectionTester`
`PA_SELECTION_RULE_VALUE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditSelectionTesterValue`, `clsAuditSelectionTesterValueCollection`
`PA_SELECTION_TEST`	Oracle	`[unqualified]`**	CRD	Usage inferred from SQL and source.*	`clsAuditSelectionTestResult`, `clsAuditSelectionTestResultCollection`
`PA_SLCTN_CATEGORY_GROUP_CODE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditSelectionCategoryCode`, `clsAuditSelectionCategoryCodeCollection`
`PA_SLCTN_CATEGORY_MARKET_TYPE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditSelectionCategoryCollection`, `clsAuditSelectionTester`, `clsAuditSelectionTesterValueCollection`, `clsWorkbookReviewTester`
`PA_SLCTN_CAT_MKT_TYPE_REASON`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditSelectionCategoryCollection`
`PA_SLCTN_CAT_MKT_TYPE_RSN_RULE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditSelectionTester`, `clsAuditSelectionTesterValueCollection`, `clsWorkbookReviewTester`
`PA_STATUS_CODE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsStatusCollection`
`PA_TYPE_CODE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsPremiumAuditTypeCode`, `clsPremiumAuditTypeCodeCollection`
`PA_TYPE_MARKET_TYPE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsPremiumAuditTypeCode`, `clsPremiumAuditTypeCodeCollection`
`PA_ZIP_CODE`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditCollection`, `clsZipCode`, `clsZipCodeCollection`
`POLICY`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAudit`, `clsAuditCollection`, `clsAuditPolicyCollection`
`POLICY_PERIOD`	Oracle	`[unqualified]`**	R	Usage inferred from SQL and source.*	`clsAuditCollection`
`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

`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

Table relationship diagram¶

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

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)"

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.

SAIF.Business.Policy.Audit.Premium database tables¶

Table catalog¶

BUSINESS¶

SQL referencing this table¶

COUNTY¶

SQL referencing this table¶

DUAL¶

SQL referencing this table¶

ER_COMBINATION_POLICY¶

SQL referencing this table¶

LF_APVENMAST¶

SQL referencing this table¶

LOCATION¶

SQL referencing this table¶

OFFICE_CODE¶

SQL referencing this table¶

PA_ASSIGN_OVERRIDE¶

SQL referencing this table¶

PA_AUDIT¶

SQL referencing this table¶

PA_AUDITOR¶

SQL referencing this table¶

PA_AUDITOR_ZIP_CODE¶

SQL referencing this table¶

PA_EVENT¶

SQL referencing this table¶

PA_POLICY¶

SQL referencing this table¶

PA_POLICY_PERIOD¶

SQL referencing this table¶

PA_PREMIUM_AUDIT_RESULT¶

SQL referencing this table¶

PA_REASON_CODE¶

SQL referencing this table¶

PA_RESULT¶

SQL referencing this table¶

PA_RESULT_TYPE¶

SQL referencing this table¶

PA_REVIEW_REASON_CODE¶

SQL referencing this table¶

PA_REVIEW_REASON_RESULT¶

SQL referencing this table¶

PA_REVIEW_RESULT¶

SQL referencing this table¶

PA_REVIEW_RESULT_CODE¶

SQL referencing this table¶

PA_SELECTION_CATEGORY_CODE¶

SQL referencing this table¶

PA_SELECTION_RULE¶

SQL referencing this table¶

PA_SELECTION_RULE_THRESHOLD¶

SQL referencing this table¶

PA_SELECTION_RULE_VALUE¶

SQL referencing this table¶

PA_SELECTION_TEST¶

SQL referencing this table¶

PA_SLCTN_CATEGORY_GROUP_CODE¶

SQL referencing this table¶

PA_SLCTN_CATEGORY_MARKET_TYPE¶

SQL referencing this table¶

PA_SLCTN_CAT_MKT_TYPE_REASON¶

SQL referencing this table¶

PA_SLCTN_CAT_MKT_TYPE_RSN_RULE¶

SQL referencing this table¶

PA_STATUS_CODE¶

SQL referencing this table¶

PA_TYPE_CODE¶

SQL referencing this table¶

PA_TYPE_MARKET_TYPE¶

SQL referencing this table¶

PA_ZIP_CODE¶

SQL referencing this table¶

POLICY¶

SQL referencing this table¶

POLICY_PERIOD¶

SQL referencing this table¶

TRADING_AS¶

SQL referencing this table¶

Table relationship diagram¶

Related documentation¶

`BUSINESS`¶

`COUNTY`¶

`DUAL`¶

`ER_COMBINATION_POLICY`¶

`LF_APVENMAST`¶

`LOCATION`¶

`OFFICE_CODE`¶

`PA_ASSIGN_OVERRIDE`¶

`PA_AUDIT`¶

`PA_AUDITOR`¶

`PA_AUDITOR_ZIP_CODE`¶

`PA_EVENT`¶

`PA_POLICY`¶

`PA_POLICY_PERIOD`¶

`PA_PREMIUM_AUDIT_RESULT`¶

`PA_REASON_CODE`¶

`PA_RESULT`¶

`PA_RESULT_TYPE`¶

`PA_REVIEW_REASON_CODE`¶

`PA_REVIEW_REASON_RESULT`¶

`PA_REVIEW_RESULT`¶

`PA_REVIEW_RESULT_CODE`¶

`PA_SELECTION_CATEGORY_CODE`¶

`PA_SELECTION_RULE`¶

`PA_SELECTION_RULE_THRESHOLD`¶

`PA_SELECTION_RULE_VALUE`¶

`PA_SELECTION_TEST`¶

`PA_SLCTN_CATEGORY_GROUP_CODE`¶

`PA_SLCTN_CATEGORY_MARKET_TYPE`¶

`PA_SLCTN_CAT_MKT_TYPE_REASON`¶

`PA_SLCTN_CAT_MKT_TYPE_RSN_RULE`¶

`PA_STATUS_CODE`¶

`PA_TYPE_CODE`¶

`PA_TYPE_MARKET_TYPE`¶

`PA_ZIP_CODE`¶

`POLICY`¶

`POLICY_PERIOD`¶

`TRADING_AS`¶