SAIF.Business.Policy database tables

This page catalogs Oracle database tables accessed by SAIF.Business.Policy. All access is read-only — this library owns no INSERT/UPDATE/DELETE SQL.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
HAZARD_GROUP	Oracle	[unqualified]**	R	Hazard-group code/rate classification records	clsHazardGroupCollection
BENEFIT_JURISDICTION_CODE	Oracle	[unqualified]**	R	Benefit-jurisdiction code/description lookup	clsBenefitJurisdictionCodeMap
MANUAL_CLASS_TYPE_CODE	Oracle	[unqualified]**	R	Manual-class-type code/description lookup	clsManualClassTypeCodeMap
POLICY_PERIOD	Oracle	[unqualified]**	R	Policy-period effective/expiration/anniversary dates	PolicyInformation*
POLICY_PERIOD_NON_WCIS	Oracle	[unqualified]**	R	Policy-period dates for non-WCIS policies (parallel source)	PolicyInformation*
POLICY	Oracle	[unqualified]**	R	Policy header data (market type)	PolicyInformation*
PREM_HIST_SUMMARY	Oracle	[unqualified]**	R	Premium history summary set lookup	PolicyInformation*
ENDORSEMENT	Oracle	[unqualified]**	R	Endorsement records (information-page print check)	PolicyInformation*

HAZARD_GROUP

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores hazard-group code/rate classification records with effective/expiration date windows.
Access pattern	Direct SQL (BOF Criteria.RetrieveSQL)
CRUD operations	Read
Key columns used	HAZARD_GROUP_ID, NCCI_HAZARD_GROUP_CODE, EFFECTIVE_DATE, EXPIRATION_DATE, HAZARD_GROUP_SHORT_DESCR, HAZARD_GROUP_LONG_DESCR, CREATE_DATE, CREATE_USER, UPDATE_DATE, UPDATE_USER
Sequence	N/A
Related tables	None (standalone reference table)
Business objects	clsHazardGroup, clsHazardGroupCollection

Operations referencing this table

• Retrieve hazard groups effective on a date

Business rules referencing this table

None.

SQL referencing this table

• SQL-002: Hazard group retrieve

---

BENEFIT_JURISDICTION_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Code/description reference table mapped to the BenefitJurisdictions enum (State/Federal).
Access pattern	Direct SQL (constructor literal, executed via the framework's Fill(inDPI, sql) helper)
CRUD operations	Read
Key columns used	code, code_descr
Sequence	N/A
Related tables	None
Business objects	clsBenefitJurisdictionCodeMap

Operations referencing this table

• Resolve or cache benefit-jurisdiction code table

Business rules referencing this table

None.

SQL referencing this table

• SQL-001: Benefit jurisdiction code lookup

---

MANUAL_CLASS_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Code/description reference table mapped to the ManualClassTypes enum. Only 5 of ~15 codes are actively mapped in this library's code; the remainder are dead code (commented out) and excluded from findings.
Access pattern	Direct SQL (constructor literal, executed via the framework's Fill(inDPI, sql) helper)
CRUD operations	Read
Key columns used	code, code_descr
Sequence	N/A
Related tables	None
Business objects	clsManualClassTypeCodeMap

Operations referencing this table

• Resolve or cache manual-class-type code table

Business rules referencing this table

None.

SQL referencing this table

• SQL-003: Manual class type code lookup

---

POLICY_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy period records used to derive anniversary rate date, effective date, and expiration date.
Access pattern	Direct SQL (PolicyInformation.SQL inline/string-concatenated statements)
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_NON_WCIS (parallel/alternative source via UNION), POLICY (inferred one-to-many via POLICY_NUM)
Business objects	PolicyInformation*

Operations referencing this table

• Determine anniversary rate date
• Determine maximum policy effective date
• Determine policy-period expiration date

Business rules referencing this table

None.

SQL referencing this table

• SQL-004: Policy period anniversary rate date
• SQL-008: Max policy effective date
• SQL-011: Policy period expiration date

---

POLICY_PERIOD_NON_WCIS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Parallel policy-period source for non-WCIS policies, unioned with POLICY_PERIOD in scalar lookups.
Access pattern	Direct SQL (UNION counterpart of POLICY_PERIOD statements)
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/alternative source, same shape, not a join)
Business objects	PolicyInformation*

Operations referencing this table

• Determine anniversary rate date
• Determine policy-period expiration date

Business rules referencing this table

None.

SQL referencing this table

• SQL-004: Policy period anniversary rate date
• SQL-011: Policy period expiration date

---

POLICY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Policy header table used to look up the market type code for a policy.
Access pattern	Direct SQL (PolicyInformation.SQL.GetMarketType)
CRUD operations	Read
Key columns used	POLICY_NUM, MARKET_TYPE_CODE
Sequence	N/A
Related tables	POLICY_PERIOD (inferred one-to-many via POLICY_NUM, no JOIN present), PREM_HIST_SUMMARY (inferred), ENDORSEMENT (inferred)
Business objects	PolicyInformation*

Operations referencing this table

• Determine market type

Business rules referencing this table

None.

SQL referencing this table

• SQL-005: Policy market type lookup

---

PREM_HIST_SUMMARY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Premium history summary records used to determine the maximum premium-history set ID for a policy period.
Access pattern	Direct SQL (PolicyInformation.MaxPremiumHistorySetId)
CRUD operations	Read
Key columns used	POLICY_NUM, POLICY_PERIOD_EFF_DATE, PREM_HIST_TYPE_CODE, PREM_HIST_SET_ID
Sequence	N/A
Related tables	POLICY (inferred one-to-many via POLICY_NUM, no JOIN present)
Business objects	PolicyInformation*

Operations referencing this table

• Determine maximum premium-history set ID

Business rules referencing this table

None.

SQL referencing this table

• SQL-009: Max premium history set ID

---

ENDORSEMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Endorsement records used to check whether the policy information page (P401) was printed.
Access pattern	Direct SQL (PolicyInformation.IsInformationPagePrinted)
CRUD operations	Read
Key columns used	POLICY_NUM, POLICY_PERIOD_EFF_DATE, ENDORSE_CODE, PRINTED_DATE
Sequence	N/A
Related tables	POLICY (inferred one-to-many via POLICY_NUM, no JOIN present)
Business objects	PolicyInformation*

Operations referencing this table

• Determine whether the information page was printed

Business rules referencing this table

None.

SQL referencing this table

• SQL-007: Information page printed check

---

Table relationship diagram

No explicit JOIN clauses were found anywhere in this library's SQL — all multi-table statements are either a correlated subquery or a UNION of two structurally parallel tables. The relationships below are inferred from shared POLICY_NUM column naming, not confirmed by JOIN syntax.*

erDiagram
    POLICY ||--o{ POLICY_PERIOD : "POLICY_NUM (inferred)"
    POLICY ||--o{ PREM_HIST_SUMMARY : "POLICY_NUM (inferred)"
    POLICY ||--o{ ENDORSEMENT : "POLICY_NUM (inferred)"
    POLICY_PERIOD ||--|| POLICY_PERIOD_NON_WCIS : "UNION (parallel source)"
    POLICY {
        NUMBER POLICY_NUM PK
        VARCHAR2 MARKET_TYPE_CODE
    }
    POLICY_PERIOD {
        NUMBER POLICY_NUM FK
        DATE POLICY_PERIOD_EFF_DATE
        DATE POLICY_PERIOD_EXP_DATE
        DATE ANNIVERSARY_RATE_DATE
    }
    POLICY_PERIOD_NON_WCIS {
        NUMBER POLICY_NUM FK
        DATE POLICY_PERIOD_EFF_DATE
        DATE POLICY_PERIOD_EXP_DATE
        DATE ANNIVERSARY_RATE_DATE
    }
    PREM_HIST_SUMMARY {
        NUMBER POLICY_NUM FK
        DATE POLICY_PERIOD_EFF_DATE
        VARCHAR2 PREM_HIST_TYPE_CODE
        NUMBER PREM_HIST_SET_ID
    }
    ENDORSEMENT {
        NUMBER POLICY_NUM FK
        DATE POLICY_PERIOD_EFF_DATE
        VARCHAR2 ENDORSE_CODE
        DATE PRINTED_DATE
    }

HAZARD_GROUP, BENEFIT_JURISDICTION_CODE, and MANUAL_CLASS_TYPE_CODE are standalone code/reference tables with no relationship evidence to any other table referenced in this library.

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• 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.Policy\clsHazardGroup.vb
• SAIF.Business.Policy\clsHazardGroupCollection.vb
• SAIF.Business.Policy\PolicyInformation.vb
• SAIF.Business.Policy\CodeMaps\clsBenefitJurisdictionCodeMap.vb
• SAIF.Business.Policy\CodeMaps\clsManualClassTypeCodeMap.vb