SAIF.Business.Policy database tables

This page catalogs database tables accessed by this library. All access is read-only; the library issues no INSERT, UPDATE, DELETE, or sequence (.NEXTVAL) statements from .NET code.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
BENEFIT_JURISDICTION_CODE	Oracle	[unqualified]**	R	Code-table source for benefit jurisdiction lookups	clsBenefitJurisdictionCodeMap
DUAL	Oracle	N/A — Oracle system pseudo-table	R	Vehicle for invoking the pk73102_policy.does_wcis_own_submission function	PolicyInformation
ENDORSEMENT	Oracle	[unqualified]**	R	Determine whether a policy period's information page was printed	PolicyInformation
HAZARD_GROUP	Oracle	[unqualified]**	R	Source of hazard-group reference data	clsHazardGroupCollection, clsHazardGroup
MANUAL_CLASS_TYPE_CODE	Oracle	[unqualified]**	R	Code-table source for manual class type lookups	clsManualClassTypeCodeMap
POLICY	Oracle	[unqualified]**	R	Source of policy market-type code	PolicyInformation
POLICY_PERIOD	Oracle	[unqualified]**	R	Source of policy period effective/expiration/anniversary dates (WCIS)	PolicyInformation
POLICY_PERIOD_NON_WCIS	Oracle	[unqualified]**	R	Source of policy period expiration/anniversary dates (non-WCIS)	PolicyInformation
PREM_HIST_SUMMARY	Oracle	[unqualified]**	R	Source of the current premium-history set id	PolicyInformation

BENEFIT_JURISDICTION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]** — no OWNER. prefix or DB link in the SQL text
Purpose	Reference code table for jurisdictions; mapped to the BenefitJurisdictions enum
Access pattern	Direct SQL (clsCodeTableBase.Fill)
CRUD operations	Read
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	None discovered
Business objects	clsBenefitJurisdictionCodeMap

Business rules referencing this table

• BR-POL-012: Benefit jurisdiction code recognition

SQL referencing this table

• SQL-001: Benefit jurisdiction code lookup

---

DUAL

Field	Value
Database	Oracle
Schema/Link	N/A — Oracle system pseudo-table
Purpose	Used to invoke the Oracle package function pk73102_policy.does_wcis_own_submission as a scalar SELECT
Access pattern	Direct SQL (function call via SELECT ... FROM DUAL)
CRUD operations	Read (function call)
Key columns used	N/A
Sequence	N/A
Related tables	None discovered
Business objects	PolicyInformation

Business rules referencing this table

• BR-POL-005: Policy ownership determination

SQL referencing this table

• SQL-005: Get policy ownership system

---

ENDORSEMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Source of endorsement rows used to determine whether a policy period's information page (P401) has been printed
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	POLICY_NUM, POLICY_PERIOD_EFF_DATE, ENDORSE_CODE, PRINTED_DATE
Sequence	N/A
Related tables	POLICY_PERIOD (inferred, composite key naming convention)*
Business objects	PolicyInformation

Business rules referencing this table

• BR-POL-006: Information page printed status

SQL referencing this table

• SQL-006: Is information page printed

---

HAZARD_GROUP

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Source of hazard-group reference data retrieved as read-only BOF business objects
Access pattern	Direct SQL, via BOF business-object data portal
CRUD operations	Read
Key columns used	HAZARD_GROUP_ID, HAZARD_GROUP_SHORT_DESCR, HAZARD_GROUP_LONG_DESCR, EFFECTIVE_DATE, EXPIRATION_DATE, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER, NCCI_HAZARD_GROUP_CODE
Sequence	N/A
Related tables	None discovered
Business objects	clsHazardGroup, clsHazardGroupCollection

Operations referencing this table

• OP-01 Retrieve hazard groups effective on a date (see Operations and processes)
• OP-02 Hydrate a hazard group from a reader (see Operations and processes)

Business rules referencing this table

• BR-POL-001: Hazard group effective-dating
• BR-POL-002: Hazard group data is read-only

SQL referencing this table

• SQL-002: Hazard group retrieve

---

MANUAL_CLASS_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Reference code table for manual class types; mapped to the ManualClassTypes enum
Access pattern	Direct SQL (clsCodeTableBase.Fill)
CRUD operations	Read
Key columns used	CODE, CODE_DESCR
Sequence	N/A
Related tables	None discovered
Business objects	clsManualClassTypeCodeMap

Business rules referencing this table

• BR-POL-013: Manual class type code recognition

SQL referencing this table

• SQL-003: Manual class type code lookup

---

POLICY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Source of the policy's market-type code
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	POLICY_NUM, MARKET_TYPE_CODE
Sequence	N/A
Related tables	POLICY_PERIOD (inferred, shared POLICY_NUM key; no explicit JOIN)*
Business objects	PolicyInformation

Business rules referencing this table

• BR-POL-004: Market type code classification

SQL referencing this table

• SQL-004: Get market type

---

POLICY_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Source of a policy's period effective date, expiration date, and anniversary rate date
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	POLICY_NUM, POLICY_PERIOD_EFF_DATE, POLICY_PERIOD_EXP_DATE, ANNIVERSARY_RATE_DATE
Sequence	N/A
Related tables	POLICY (inferred), POLICY_PERIOD_NON_WCIS (parallel/alternate-source partition, inferred), ENDORSEMENT (inferred), PREM_HIST_SUMMARY (inferred)
Business objects	PolicyInformation

Business rules referencing this table

• BR-POL-009: Policy effective date derivation
• BR-POL-010: Dual-source period date resolution

SQL referencing this table

• SQL-008: Policy effective date
• SQL-009: Policy period anniversary rate date
• SQL-010: Policy period expiration date

---

POLICY_PERIOD_NON_WCIS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Alternate (non-WCIS) source of policy period expiration date and anniversary rate date, unioned with POLICY_PERIOD
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	POLICY_NUM, POLICY_PERIOD_EFF_DATE, POLICY_PERIOD_EXP_DATE, ANNIVERSARY_RATE_DATE
Sequence	N/A
Related tables	POLICY_PERIOD (parallel/alternate-source partition, inferred)*
Business objects	PolicyInformation

Business rules referencing this table

• BR-POL-010: Dual-source period date resolution

SQL referencing this table

• SQL-009: Policy period anniversary rate date
• SQL-010: Policy period expiration date

---

PREM_HIST_SUMMARY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Source of premium-history summary rows used to determine the current premium-history set id
Access pattern	Direct SQL
CRUD operations	Read
Key columns used	PREM_HIST_SET_ID, POLICY_NUM, POLICY_PERIOD_EFF_DATE, PREM_HIST_TYPE_CODE
Sequence	N/A
Related tables	POLICY_PERIOD (inferred, composite key naming convention)*
Business objects	PolicyInformation

Business rules referencing this table

• BR-POL-007: Current premium history set selection

SQL referencing this table

• SQL-007: Max prem hist set id

---

Table relationship diagram

The following diagram shows relationships between tables used by this library, inferred from shared key columns and UNION structure (no explicit JOIN clauses exist in this library's SQL, apart from a correlated self-reference).

erDiagram
    POLICY ||--o{ POLICY_PERIOD : "POLICY_NUM (inferred)"
    POLICY_PERIOD ||--|| POLICY_PERIOD_NON_WCIS : "POLICY_NUM, POLICY_PERIOD_EFF_DATE (parallel source)"
    POLICY_PERIOD ||--o{ ENDORSEMENT : "POLICY_NUM, POLICY_PERIOD_EFF_DATE (inferred)"
    POLICY_PERIOD ||--o{ PREM_HIST_SUMMARY : "POLICY_NUM, POLICY_PERIOD_EFF_DATE (inferred)"
    POLICY_PERIOD {
        NUMBER POLICY_NUM
        DATE POLICY_PERIOD_EFF_DATE
        DATE POLICY_PERIOD_EXP_DATE
        DATE ANNIVERSARY_RATE_DATE
    }
    POLICY {
        NUMBER POLICY_NUM
        VARCHAR2 MARKET_TYPE_CODE
    }

HAZARD_GROUP, MANUAL_CLASS_TYPE_CODE, and BENEFIT_JURISDICTION_CODE are standalone reference/code tables with no discoverable relationships in this library's SQL.

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.

Related documentation

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

Sources

• SAIF.Business.Policy/PolicyInformation.vb
• SAIF.Business.Policy/clsHazardGroup.vb
• SAIF.Business.Policy/clsHazardGroupCollection.vb
• SAIF.Business.Policy/CodeMaps/clsBenefitJurisdictionCodeMap.vb
• SAIF.Business.Policy/CodeMaps/clsManualClassTypeCodeMap.vb