SAIF.Business.Policy database tables

This page catalogs the Oracle tables and pseudo-tables accessed by SAIF.Business.Policy.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
BENEFIT_JURISDICTION_CODE	Oracle	[unqualified]**	R	Reference code table for benefit-jurisdiction mappings.	clsBenefitJurisdictionCodeMap
MANUAL_CLASS_TYPE_CODE	Oracle	[unqualified]**	R	Reference code table for manual-class-type mappings.	clsManualClassTypeCodeMap
HAZARD_GROUP	Oracle	[unqualified]**	R	Effective-dated hazard-group reference table loaded into BOF business objects.	clsHazardGroup, clsHazardGroupCollection
POLICY	Oracle	[unqualified]**	R	Policy header table used for market-type lookup.	PolicyInformation
POLICY_PERIOD	Oracle	[unqualified]**	R	Primary policy-period table used by date and premium-history lookups.	PolicyInformation
POLICY_PERIOD_NON_WCIS	Oracle	[unqualified]**	R	Alternate policy-period table for non-WCIS periods.	PolicyInformation
PREM_HIST_SUMMARY	Oracle	[unqualified]**	R	Premium-history summary table used to locate current history sets and feed minimum-premium logic.	PolicyInformation
ENDORSEMENT	Oracle	[unqualified]**	R	Endorsement table used to detect printed P401 information pages.	PolicyInformation
DUAL	Oracle	N/A — Oracle pseudo-table	R	Oracle pseudo-table used to invoke scalar package functions.	PolicyInformation

BENEFIT_JURISDICTION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Reference code table for benefit-jurisdiction mappings.
Access pattern	direct SQL
CRUD operations	R
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	See relationship diagram
Business objects	clsBenefitJurisdictionCodeMap

Operations referencing this table

• Load Code Maps

Business rules referencing this table

• BR-POL-013

SQL referencing this table

• SQL-001

---

MANUAL_CLASS_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Reference code table for manual-class-type mappings.
Access pattern	direct SQL
CRUD operations	R
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	See relationship diagram
Business objects	clsManualClassTypeCodeMap

Operations referencing this table

• Load Code Maps

Business rules referencing this table

• BR-POL-014

SQL referencing this table

• SQL-003

---

HAZARD_GROUP

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Effective-dated hazard-group reference table loaded into BOF business objects.
Access pattern	direct SQL
CRUD operations	R
Key columns used	HAZARD_GROUP_ID, dates, descriptions, NCCI_HAZARD_GROUP_CODE
Sequence	N/A
Related tables	See relationship diagram
Business objects	clsHazardGroup, clsHazardGroupCollection

Operations referencing this table

• Retrieve Hazard Groups Effective On A Date

Business rules referencing this table

• BR-POL-011

SQL referencing this table

• SQL-002

---

POLICY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy header table used for market-type lookup.
Access pattern	direct SQL
CRUD operations	R
Key columns used	POLICY_NUM, MARKET_TYPE_CODE
Sequence	N/A
Related tables	See relationship diagram
Business objects	PolicyInformation

Operations referencing this table

• Determine Policy Market Type

Business rules referencing this table

• BR-POL-003

SQL referencing this table

• SQL-007

---

POLICY_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Primary policy-period table used by date and premium-history lookups.
Access pattern	direct SQL and stored procedure
CRUD operations	R
Key columns used	POLICY_NUM, effective/expiration dates, ANNIVERSARY_RATE_DATE
Sequence	N/A
Related tables	See relationship diagram
Business objects	PolicyInformation

Operations referencing this table

• Retrieve Latest Policy Period Effective Date

Business rules referencing this table

• BR-POL-001

SQL referencing this table

• SQL-008

---

POLICY_PERIOD_NON_WCIS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Alternate policy-period table for non-WCIS periods.
Access pattern	direct SQL
CRUD operations	R
Key columns used	POLICY_NUM, effective/expiration dates, ANNIVERSARY_RATE_DATE
Sequence	N/A
Related tables	See relationship diagram
Business objects	PolicyInformation

Operations referencing this table

• Retrieve Policy Period Expiration Date

Business rules referencing this table

• BR-POL-002

SQL referencing this table

• SQL-011

---

PREM_HIST_SUMMARY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Premium-history summary table used to locate current history sets and feed minimum-premium logic.
Access pattern	direct SQL and stored procedure
CRUD operations	R
Key columns used	PREM_HIST_SET_ID, POLICY_NUM, POLICY_PERIOD_EFF_DATE, PREM_HIST_TYPE_CODE
Sequence	N/A
Related tables	See relationship diagram
Business objects	PolicyInformation

Operations referencing this table

• Retrieve Maximum Premium History Set Id

Business rules referencing this table

• BR-POL-005

SQL referencing this table

• SQL-009

---

ENDORSEMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Endorsement table used to detect printed P401 information pages.
Access pattern	direct SQL
CRUD operations	R
Key columns used	POLICY_NUM, POLICY_PERIOD_EFF_DATE, ENDORSE_CODE, PRINTED_DATE
Sequence	N/A
Related tables	See relationship diagram
Business objects	PolicyInformation

Operations referencing this table

• Determine Whether The Information Page Was Printed

Business rules referencing this table

• BR-POL-009

SQL referencing this table

• SQL-006

---

DUAL

Field	Value
Database	Oracle
Schema/Link	N/A — Oracle pseudo-table
Purpose	Oracle pseudo-table used to invoke scalar package functions.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Oracle scalar expression only
Sequence	N/A
Related tables	See relationship diagram
Business objects	PolicyInformation

Operations referencing this table

• Determine Policy Ownership System

Business rules referencing this table

• BR-POL-010

SQL referencing this table

• SQL-005

---

Table relationship diagram

The following diagram shows the discoverable relationships between the tables referenced by this library and its Oracle procedures.

erDiagram

  POLICY ||--o{ POLICY_PERIOD : POLICY_NUM

  POLICY ||--o{ POLICY_PERIOD_NON_WCIS : POLICY_NUM

  POLICY_PERIOD ||--o{ ENDORSEMENT : POLICY_NUM+EFF_DATE

  POLICY_PERIOD ||--o{ PREM_HIST_SUMMARY : POLICY_NUM+EFF_DATE

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• API reference
• Configuration
• Procedures

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.Policy\PolicyInformation.vb
• Business\SAIF.Business.Policy\clsHazardGroupCollection.vb
• Business\SAIF.Business.Policy\CodeMaps\clsBenefitJurisdictionCodeMap.vb
• Business\SAIF.Business.Policy\CodeMaps\clsManualClassTypeCodeMap.vb
• Oracle DBA_SOURCE: WCIS_DBA.pk73069_rating_procs
• Oracle DBA_SOURCE: WCIS_DBA.pk73102_policy