SAIF.Business.View.Policy database tables

This page catalogs database tables directly accessed by SAIF.Business.View.Policy via inline SQL. Tables accessed only inside an Oracle package/procedure body (e.g., pk72846_view_policy.*, pk73094_policy_data.getpolicy) or a SQL Server cp_* stored procedure are not directly visible from this library's source and are not catalogued individually below — see the SQL catalog for the corresponding call signatures.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
NON_EMPR_ACCT	Oracle	[unqualified]**	R	Non-employer account address/contact record	clsNonEmployerAccount
TRADING_AS	Oracle	[unqualified]**	R	"Doing business as" trading names for a policy	clsTradingAsCollection
ASSOCIATION_TYPE_CODE	Oracle	[unqualified]**	R	Policy-association type code reference data	clsAssociationTypeCode, clsAssociationTypeCodeCollection
PA_AUDIT	Oracle	[unqualified]**	R	Fee-audit records used for last-audit-date lookup and auditor access checks	clsPolicyData, clsPolicySecurity
PA_AUDITOR	Oracle	[unqualified]**	R	Fee-auditor/vendor records used for auditor access checks	clsPolicySecurity
PA_POLICY_PERIOD	Oracle	[unqualified]**	R	Audit-period linkage used for auditor access checks	clsPolicySecurity
POLICY	Oracle	[unqualified]**	R	Policy header used for the fee-auditor policy list	clsPolicySecurity
CANCELLATION	Oracle	[unqualified]**	R	Future policy cancellation date lookup	clsPolicyData
BUSINESS_AFFILIATE	Oracle	[unqualified]**	R	Officer-of-Notice affiliate linkage	clsPolicyAddress
AFFILIATE	Oracle	[unqualified]**	R	Officer-of-Notice affiliate contact/address	clsPolicyAddress
POLICY_PERIOD_ALL	Oracle	[unqualified]**	R	Policy period dates used when resolving association periods	clsAssociationTypeCode
ENDORSEMENT	Oracle	[unqualified]**	R	Endorsement effective dates joined to policy periods	clsAssociationTypeCode
POLICY_PERIOD_NON_WCIS	Oracle	[unqualified]**	R	Non-WCIS-era policy period linkage (association periods and PMS payroll class detail)	clsAssociationTypeCode, clsPayrollClassInfoCollection
PPNW_CLASS_COVERAGE_DETAIL	Oracle	[unqualified]**	R	PMS-era manual classification/payroll detail lines	clsPayrollClassInfoCollection
MANUAL_CLASS_DESCRIPTION	Oracle	[unqualified]**	R	Manual class code descriptions	clsPayrollClassInfoCollection
MANUAL_CLASS_BASE	Oracle	[unqualified]**	R	Manual class base reference (WCIS-era)	clsPayrollClassInfoCollection
PREM_HIST_CLASS_COVERAGE	Oracle	[unqualified]**	R	WCIS-era premium-history class coverage detail	clsPayrollClassInfoCollection
PREM_HIST_ADJ_RATE_CLASS	Oracle	[unqualified]**	R	WCIS-era premium-history adjusted-rate class detail	clsPayrollClassInfoCollection
POLICY_PERIOD	Oracle	[unqualified]**	R	Policy period linkage for WCIS-era payroll class detail	clsPayrollClassInfoCollection
LOCATION	Oracle	[unqualified]**	R	Policy location used for WCIS-era payroll class detail and minimum-wage lookup	clsPayrollClassInfoCollection
FEDERAL_MINIMUM_WAGE	Oracle	[unqualified]**	R	Federal minimum-wage rate reference, joined by effective date range	clsPayrollClassInfoCollection
DUAL	Oracle	[unqualified]**	R	Oracle pseudo-table used to invoke scalar functions (sp72268_get_cancel_status, sp73089_get_policy_bound_flag)	clsPolicyData

NON_EMPR_ACCT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Non-employer account address/contact record, keyed by account number.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	ACCT_NUM, ACCT_NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, STATE_CODE, ZIP_CODE
Sequence	N/A
Related tables	None (standalone)
Business objects	clsNonEmployerAccount

Business rules referencing this table

• BR-VP-014: Non-employer account number must be non-zero

SQL referencing this table

• SQL-VP-032

---

TRADING_AS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	"Doing business as" trading name records linked to a policy/business.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	POLICY_NUM, BUS_SEQ_NUM, TRADING_SEQ_NUM, TRADING_AS_NAME, FEID_NUM
Sequence	N/A
Related tables	None (standalone)
Business objects	clsTradingAsCollection, clsTradingAs

SQL referencing this table

• SQL-VP-023

---

ASSOCIATION_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Reference data describing policy-association type codes (manual affiliation, wrapup, leasing, sub-account, state agency, experience/discount combination) and the source procedure used to resolve each type's related policies.
Access pattern	Direct inline SQL (full table scan, no filter)
CRUD operations	Read
Key columns used	CODE, DESCRIPTION, ASSOCIATION_TYPE_CATEGORY_CODE, SOURCE_PROCEDURE_NAME, SECURITY_GROUP_NAME, SORT_ORDER, POLICY_HEADER_DEFAULT_FLAG
Sequence	N/A
Related tables	None directly joined; SOURCE_PROCEDURE_NAME drives a dynamic procedure dispatch (SQL-VP-029)
Business objects	clsAssociationTypeCode, clsAssociationTypeCodeCollection

SQL referencing this table

• SQL-VP-027

---

PA_AUDIT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Fee-audit records used to determine last audit date and to gate fee-auditor policy access.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	POLICY_NUM, AUDIT_DATE, AUDITOR_SEQ_NUM, POLICY_PERIOD_SEQ_NUM, CANCEL_DATE, COMPLETED_DATE
Sequence	N/A
Related tables	PA_AUDITOR, PA_POLICY_PERIOD, POLICY
Business objects	clsPolicyData, clsPolicySecurity

Business rules referencing this table

• BR-VP-009: Fee-auditor vendor/policy audit-record match required

SQL referencing this table

• SQL-VP-012
• SQL-VP-037
• SQL-VP-038

---

PA_AUDITOR

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Fee-auditor/vendor records joined to audit records to gate auditor policy access.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	AUDITOR_SEQ_NUM, VENDOR_NUM
Sequence	N/A
Related tables	PA_AUDIT, POLICY
Business objects	clsPolicySecurity

Business rules referencing this table

• BR-VP-009: Fee-auditor vendor/policy audit-record match required

SQL referencing this table

• SQL-VP-037
• SQL-VP-038

---

PA_POLICY_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Audit-period linkage used to gate auditor policy access by policy number.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	POLICY_PERIOD_SEQ_NUM, POLICY_NUM
Sequence	N/A
Related tables	PA_AUDIT
Business objects	clsPolicySecurity

Business rules referencing this table

• BR-VP-009: Fee-auditor vendor/policy audit-record match required

SQL referencing this table

• SQL-VP-037

---

POLICY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy header (number/name) used to build the fee-auditor's accessible policy list.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	POLICY_NUM, POLICY_NAME
Sequence	N/A
Related tables	PA_AUDIT, PA_AUDITOR
Business objects	clsPolicySecurity

SQL referencing this table

• SQL-VP-038

---

CANCELLATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Future cancellation date lookup for a policy.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	POLICY_NUM, CANCEL_DATE
Sequence	N/A
Related tables	None (standalone)
Business objects	clsPolicyData

SQL referencing this table

• SQL-VP-013

---

BUSINESS_AFFILIATE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Links a policy to its Officer-of-Notice affiliate record.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	POLICY_NUM, AFFILIATE_SEQ_NUM, AFFILIATE_TYPE_CODE
Sequence	N/A
Related tables	AFFILIATE
Business objects	clsPolicyAddress

Business rules referencing this table

• BR-VP-011: Demo-user address/contact data masking

SQL referencing this table

• SQL-VP-007

---

AFFILIATE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Affiliate contact/address details for the Officer of Notice.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	AFFILIATE_SEQ_NUM, AFFILIATE_NAME, ADDRESS_LINE_1, ADDRESS_LINE_2, CITY, STATE_CODE, ZIP_CODE
Sequence	N/A
Related tables	BUSINESS_AFFILIATE
Business objects	clsPolicyAddress

Business rules referencing this table

• BR-VP-011: Demo-user address/contact data masking

SQL referencing this table

• SQL-VP-007

---

POLICY_PERIOD_ALL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy period effective/expiration dates used when resolving association periods for grouping/experience-combination association types.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	POLICY_NUM, POLICY_PERIOD_ALL_ID, POLICY_PERIOD_EFF_DATE, POLICY_PERIOD_EXP_DATE
Sequence	N/A
Related tables	ENDORSEMENT, POLICY_PERIOD_NON_WCIS
Business objects	clsAssociationTypeCode

SQL referencing this table

• SQL-VP-028

---

ENDORSEMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Endorsement effective dates joined to policy periods for association-period resolution.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	POLICY_PERIOD_ALL_ID, ENDORSEMENT_EFF_DATE
Sequence	N/A
Related tables	POLICY_PERIOD_ALL
Business objects	clsAssociationTypeCode

SQL referencing this table

• SQL-VP-028

---

POLICY_PERIOD_NON_WCIS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Non-WCIS-era policy period linkage used both for association-period resolution and PMS-era payroll classification detail.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	POLICY_PERIOD_ALL_ID, POLICY_PERIOD_NON_WCIS_ID
Sequence	N/A
Related tables	POLICY_PERIOD_ALL, PPNW_CLASS_COVERAGE_DETAIL
Business objects	clsAssociationTypeCode, clsPayrollClassInfoCollection

SQL referencing this table

• SQL-VP-028
• SQL-VP-030

---

PPNW_CLASS_COVERAGE_DETAIL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	PMS-era manual classification/payroll detail lines for a policy period.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	CLASS_COVERAGE_SET_ID, MANUAL_CLASS_CODE, PAYROLL_AMOUNT, RATE, POLICY_PERIOD_NON_WCIS_ID
Sequence	N/A
Related tables	MANUAL_CLASS_DESCRIPTION, POLICY_PERIOD_NON_WCIS
Business objects	clsPayrollClassInfoCollection

SQL referencing this table

• SQL-VP-030

---

MANUAL_CLASS_DESCRIPTION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Manual class code descriptions shared by both PMS-era and WCIS-era payroll classification detail.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	MANUAL_CLASS_CODE, MANUAL_CLASS_DESCRIPTION
Sequence	N/A
Related tables	PPNW_CLASS_COVERAGE_DETAIL, PREM_HIST_CLASS_COVERAGE
Business objects	clsPayrollClassInfoCollection

SQL referencing this table

• SQL-VP-030
• SQL-VP-031

---

MANUAL_CLASS_BASE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Manual class base reference used in the WCIS-era payroll classification query.*
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	Not directly confirmed**
Sequence	N/A
Related tables	PREM_HIST_CLASS_COVERAGE (inferred)*
Business objects	clsPayrollClassInfoCollection

SQL referencing this table

• SQL-VP-031

---

PREM_HIST_CLASS_COVERAGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	WCIS-era premium-history class coverage detail lines for a policy period.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	PREM_HIST_SET_ID, MANUAL_CLASS_CODE, PAYROLL_AMOUNT
Sequence	N/A
Related tables	MANUAL_CLASS_DESCRIPTION, PREM_HIST_ADJ_RATE_CLASS, POLICY_PERIOD
Business objects	clsPayrollClassInfoCollection

SQL referencing this table

• SQL-VP-031

---

PREM_HIST_ADJ_RATE_CLASS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	WCIS-era premium-history adjusted-rate class detail joined by premium-history set ID.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	PREM_HIST_SET_ID, RATE
Sequence	N/A
Related tables	PREM_HIST_CLASS_COVERAGE
Business objects	clsPayrollClassInfoCollection

SQL referencing this table

• SQL-VP-031

---

POLICY_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy period linkage for WCIS-era payroll classification detail, joined to LOCATION.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	PREM_HIST_SET_ID, POLICY_NUM, PERIOD_START_DATE, PERIOD_END_DATE, POLICY_PERIOD_EFF_DATE
Sequence	N/A
Related tables	PREM_HIST_CLASS_COVERAGE, LOCATION, FEDERAL_MINIMUM_WAGE
Business objects	clsPayrollClassInfoCollection

SQL referencing this table

• SQL-VP-031

---

LOCATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy location detail joined for WCIS-era payroll classification reporting.
Access pattern	Direct inline SQL
CRUD operations	Read
Key columns used	POLICY_NUM, LOCATION_SEQ_NUM
Sequence	N/A
Related tables	POLICY_PERIOD
Business objects	clsPayrollClassInfoCollection

SQL referencing this table

• SQL-VP-031

---

FEDERAL_MINIMUM_WAGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Federal minimum-wage rate reference, joined by effective date range to the policy period for WCIS-era payroll classification.
Access pattern	Direct inline SQL (left join; one UNION branch omits this table entirely)
CRUD operations	Read
Key columns used	EFF_DATE, EXP_DATE, MINIMUM_WAGE_RATE
Sequence	N/A
Related tables	POLICY_PERIOD
Business objects	clsPayrollClassInfoCollection

SQL referencing this table

• SQL-VP-031

---

DUAL

Field	Value
Database	Oracle
Schema/Link	[unqualified]** (Oracle system pseudo-table)
Purpose	Oracle pseudo-table used solely to invoke scalar functions sp72268_get_cancel_status and sp73089_get_policy_bound_flag.
Access pattern	Direct inline SQL (scalar function invocation)
CRUD operations	Read
Key columns used	N/A
Sequence	N/A
Related tables	None
Business objects	clsPolicyData

SQL referencing this table

• SQL-VP-014
• SQL-VP-015

---

Table relationship diagram

The following diagram shows relationships between tables discoverable from this library's inline SQL joins. Relationships internal to Oracle package/SQL Server stored-procedure bodies are unknown** and are not shown.

erDiagram
    BUSINESS_AFFILIATE ||--o{ AFFILIATE : "AFFILIATE_SEQ_NUM"
    PA_AUDIT ||--o{ PA_AUDITOR : "AUDITOR_SEQ_NUM"
    PA_AUDIT ||--o{ PA_POLICY_PERIOD : "POLICY_PERIOD_SEQ_NUM"
    PA_AUDIT ||--o{ POLICY : "POLICY_NUM (via PA_AUDITOR)"
    POLICY_PERIOD_ALL ||--o{ ENDORSEMENT : "POLICY_PERIOD_ALL_ID"
    POLICY_PERIOD_ALL ||--o{ POLICY_PERIOD_NON_WCIS : "POLICY_PERIOD_ALL_ID"
    POLICY_PERIOD_NON_WCIS ||--o{ PPNW_CLASS_COVERAGE_DETAIL : "POLICY_PERIOD_NON_WCIS_ID"
    PPNW_CLASS_COVERAGE_DETAIL ||--o{ MANUAL_CLASS_DESCRIPTION : "MANUAL_CLASS_CODE"
    PREM_HIST_CLASS_COVERAGE ||--o{ MANUAL_CLASS_DESCRIPTION : "MANUAL_CLASS_CODE"
    PREM_HIST_CLASS_COVERAGE ||--o{ PREM_HIST_ADJ_RATE_CLASS : "PREM_HIST_SET_ID"
    PREM_HIST_CLASS_COVERAGE ||--o{ POLICY_PERIOD : "PREM_HIST_SET_ID"
    POLICY_PERIOD ||--o{ LOCATION : "POLICY_NUM"
    POLICY_PERIOD ||--o{ FEDERAL_MINIMUM_WAGE : "POLICY_PERIOD_EFF_DATE between EFF_DATE and EXP_DATE"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• Security and authorization
• API reference

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

• SAIF.Business.View.Policy\clsNonEmployerAccount.vb
• SAIF.Business.View.Policy\clsTradingAsCollection.vb
• SAIF.Business.View.Policy\Associations\clsAssociationTypeCode.vb
• SAIF.Business.View.Policy\clsPolicyData.vb
• SAIF.Business.View.Policy\clsPolicySecurity.vb
• SAIF.Business.View.Policy\clsPolicyAddress.vb
• SAIF.Business.View.Policy\clsPayrollClassInfo.vb
• SAIF.Business.View.Policy\clsPayrollClassInfoCollection.vb