SAIF.Business.Policy.Rating database tables

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

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
DUAL	Oracle	[unqualified]**	R	Provides Oracle sequence reads for generated keys.	clsManualClassParagraph
MANUAL_CLASS_ASSOCIATION	Oracle	[unqualified]**	C/R/U/D	Stores associations between manual classes.	clsManualClassAssociation
MANUAL_CLASS_BASE	Oracle	[unqualified]**	C/R/U/D	Stores published manual-class attributes for a rate file.	clsManualClassBase
MANUAL_CLASS_DETAIL	Oracle	[unqualified]**	C/R/U/D	Stores non-rate-file manual-class attributes such as default usage codes and flags.	clsManualClassDetail
MANUAL_CLASS_PARAGRAPH	Oracle	[unqualified]**	C/R/U/D	Stores paragraph text used in class descriptions.	clsManualClassParagraph
MANUAL_CLASS_PARAGRAPH_USAGE	Oracle	[unqualified]**	C/R/U/D	Stores effective-dated paragraph assignments for classes and market types.	clsManualClassParagraphUsage
RATE_FILE_MASTER	Oracle	[unqualified]**	C/R/U/D	Stores published rate-file headers and outstanding-filing linkage.	clsRateFileMaster
STAT_PREMIUM_CLASS	Oracle	[unqualified]**	C/R/U/D	Stores NCCI statistical premium class attributes.	clsStatPremiumClass
DTEC_RATE	Oracle	[unqualified]**	R	Stores effective DTEC rates by market type.	clsDTECRate
EMPLOYEE_RATING_TYPE_CODE	Oracle	[unqualified]**	R	Stores employee rating type codes and endorsement metadata.	clsEmployeeRatingType
FED_COVERAGE_LIABILITY_LIMIT	Oracle	[unqualified]**	R	Stores effective-dated federal coverage liability limits.	clsFederalCoverageLiabilityLimit
FED_COVERAGE_TYPE_CODE	Oracle	[unqualified]**	R	Stores federal coverage type codes and manual-class mappings.	clsFederalCoverageTypeCode
PREM_HIST_CLASS_COVERAGE	Oracle	[unqualified]**	R	Stores premium-history class coverage rows used by delete guards.	clsManualClassBase
MANUAL_CLASS_TYPE_CODE	Oracle	[unqualified]**	R	Stores manual-class type codes.	clsManualClassType
POLICY	Oracle	[unqualified]**	R	Supplies policy-level market-type context for period rating info.	clsPeriodRatingInfo
POLICY_PERIOD	Oracle	[unqualified]**	R	Supplies current WCIS policy-period rating context.	clsPeriodRatingInfo
POLICY_PERIOD_NON_WCIS	Oracle	[unqualified]**	R	Supplies legacy non-WCIS policy-period rating context.	clsPeriodRatingInfo
PREMIUM_DISCOUNT_RANGE	Oracle	[unqualified]**	R	Stores premium-size discount bands.	clsPremiumSizeDiscount
PREPAY_DISCOUNT_FACTOR	Oracle	[unqualified]**	R	Stores effective-dated discount factors for prepay frequencies.	clsPrepayDiscountFactor
PREPAY_FREQUENCY_CODE	Oracle	[unqualified]**	R/U	Stores prepay frequency code rows.	clsPrepayFrequency
RISK_TYPE_CODE	Oracle	[unqualified]**	R	Stores rate-tier or risk-type codes.	clsRateTier
RISK_TYPE_DESCRIPTION	Oracle	[unqualified]**	R	Stores effective-dated state and federal risk-type factors.	clsRateTierFactor
RATING_PLAN_CODE	Oracle	[unqualified]**	R	Stores rating-plan codes.	clsRatingPlanCode
RATING_PLAN_FACTOR	Oracle	[unqualified]**	R	Stores effective-dated rating-plan factor ranges.	clsRatingPlanFactor
RATING_PLAN_TYPE_CODE	Oracle	[unqualified]**	R	Stores rating-plan-type codes.	clsRatingPlanTypeCode
SAIFPLUS_DISCOUNT	Oracle	[unqualified]**	R	Stores effective-dated SAIF Plus discount rates and caps.	clsSAIFPlusDiscount
TERRORISM_RATE	Oracle	[unqualified]**	R	Stores effective terrorism rates by market type.	clsTerrorismRate
USLHW_COMP_FACTOR	Oracle	[unqualified]**	R	Stores effective USL&HW compensation factors.	clsUSLHWCompFactor

DUAL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Provides Oracle sequence reads for generated keys.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	PARAGRAPH_NUM_NEXTVAL placeholder / RATE_FILE_SEQ_NUM.NEXTVAL
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsManualClassParagraph, clsRateFileMaster

SQL referencing this table

• SQL-001: clsManualClassParagraph
• SQL-002: clsRateFileMaster

---

MANUAL_CLASS_ASSOCIATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores associations between manual classes.
Access pattern	direct SQL
CRUD operations	C/R/U/D
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsManualClassAssociation, clsManualClassAssociationCollection

SQL referencing this table

• SQL-003: clsManualClassAssociation
• SQL-015: clsManualClassAssociation
• SQL-016: clsManualClassAssociationCollection
• SQL-047: clsManualClassAssociation
• SQL-055: clsManualClassAssociation

---

MANUAL_CLASS_BASE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores published manual-class attributes for a rate file.
Access pattern	direct SQL / stored procedure
CRUD operations	C/R/U/D
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsManualClassBase, clsManualClassBaseCollection, clsRateFileMaster

SQL referencing this table

• SQL-004: clsManualClassBase
• SQL-020: clsManualClassBase
• SQL-022: clsManualClassBaseCollection
• SQL-032: clsRateFileMaster
• SQL-048: clsManualClassBase
• SQL-056: clsManualClassBase
• SQL-057: clsManualClassBaseCollection

---

MANUAL_CLASS_DETAIL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores non-rate-file manual-class attributes such as default usage codes and flags.
Access pattern	direct SQL
CRUD operations	C/R/U/D
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsManualClassBaseCollection, clsManualClassDetail

SQL referencing this table

• SQL-005: clsManualClassDetail
• SQL-022: clsManualClassBaseCollection
• SQL-049: clsManualClassDetail
• SQL-058: clsManualClassDetail

---

MANUAL_CLASS_PARAGRAPH

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores paragraph text used in class descriptions.
Access pattern	direct SQL
CRUD operations	C/R/U/D
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsManualClassBase, clsManualClassParagraph

SQL referencing this table

• SQL-006: clsManualClassParagraph
• SQL-018: clsManualClassBase
• SQL-023: clsManualClassParagraph
• SQL-050: clsManualClassParagraph
• SQL-059: clsManualClassParagraph

---

MANUAL_CLASS_PARAGRAPH_USAGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores effective-dated paragraph assignments for classes and market types.
Access pattern	direct SQL
CRUD operations	C/R/U/D
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsManualClassBase, clsManualClassParagraphUsage, clsManualClassParagraphUsageCollection

SQL referencing this table

• SQL-007: clsManualClassParagraphUsage
• SQL-018: clsManualClassBase
• SQL-024: clsManualClassParagraphUsage
• SQL-025: clsManualClassParagraphUsageCollection
• SQL-051: clsManualClassParagraphUsage
• SQL-060: clsManualClassParagraphUsage

---

RATE_FILE_MASTER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores published rate-file headers and outstanding-filing linkage.
Access pattern	direct SQL / stored procedure
CRUD operations	C/R/U/D
Key columns used	See linked SQL documents for column-level usage.
Sequence	RATE_FILE_SEQ_NUM
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsRateFileMaster, clsRateFileMasterCollection

SQL referencing this table

• SQL-008: clsRateFileMaster
• SQL-033: clsRateFileMaster
• SQL-034: clsRateFileMasterCollection
• SQL-053: clsRateFileMaster
• SQL-061: clsRateFileMaster

---

STAT_PREMIUM_CLASS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores NCCI statistical premium class attributes.
Access pattern	direct SQL
CRUD operations	C/R/U/D
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsStatPremiumClass, clsStatPremiumClassCollection

SQL referencing this table

• SQL-009: clsStatPremiumClass
• SQL-043: clsStatPremiumClass
• SQL-044: clsStatPremiumClassCollection
• SQL-054: clsStatPremiumClass
• SQL-062: clsStatPremiumClass

---

DTEC_RATE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores effective DTEC rates by market type.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsDTECRate

SQL referencing this table

• SQL-010: clsDTECRate

---

EMPLOYEE_RATING_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores employee rating type codes and endorsement metadata.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsEmployeeRatingType

SQL referencing this table

• SQL-011: clsEmployeeRatingType

---

FED_COVERAGE_LIABILITY_LIMIT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores effective-dated federal coverage liability limits.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsFederalCoverageLiabilityLimit, clsFederalCoverageLiabilityLimitCollection

SQL referencing this table

• SQL-012: clsFederalCoverageLiabilityLimit
• SQL-013: clsFederalCoverageLiabilityLimitCollection

---

FED_COVERAGE_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores federal coverage type codes and manual-class mappings.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsFederalCoverageTypeCode

SQL referencing this table

• SQL-014: clsFederalCoverageTypeCode

---

PREM_HIST_CLASS_COVERAGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores premium-history class coverage rows used by delete guards.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsManualClassBase

SQL referencing this table

• SQL-017: clsManualClassBase

---

MANUAL_CLASS_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores manual-class type codes.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsManualClassType

SQL referencing this table

• SQL-026: clsManualClassType

---

POLICY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies policy-level market-type context for period rating info.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsPeriodRatingInfo

SQL referencing this table

• SQL-027: clsPeriodRatingInfo

---

POLICY_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies current WCIS policy-period rating context.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsPeriodRatingInfo

SQL referencing this table

• SQL-027: clsPeriodRatingInfo

---

POLICY_PERIOD_NON_WCIS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supplies legacy non-WCIS policy-period rating context.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsPeriodRatingInfo

SQL referencing this table

• SQL-027: clsPeriodRatingInfo

---

PREMIUM_DISCOUNT_RANGE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores premium-size discount bands.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsPremiumSizeDiscount

SQL referencing this table

• SQL-028: clsPremiumSizeDiscount

---

PREPAY_DISCOUNT_FACTOR

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores effective-dated discount factors for prepay frequencies.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsPrepayDiscountFactor, clsPrepayDiscountFactorCollection

SQL referencing this table

• SQL-029: clsPrepayDiscountFactor
• SQL-030: clsPrepayDiscountFactorCollection

---

PREPAY_FREQUENCY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores prepay frequency code rows.
Access pattern	direct SQL
CRUD operations	R/U
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsPrepayFrequency, clsPrepayFrequencyCodeCollection

SQL referencing this table

• SQL-031: clsPrepayFrequency
• SQL-052: clsPrepayFrequencyCodeCollection

---

RISK_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores rate-tier or risk-type codes.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsRateTier, clsRateTierCollection

SQL referencing this table

• SQL-035: clsRateTier
• SQL-036: clsRateTierCollection

---

RISK_TYPE_DESCRIPTION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores effective-dated state and federal risk-type factors.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsRateTierFactor

SQL referencing this table

• SQL-037: clsRateTierFactor

---

RATING_PLAN_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores rating-plan codes.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsRatingPlanCode

SQL referencing this table

• SQL-038: clsRatingPlanCode

---

RATING_PLAN_FACTOR

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores effective-dated rating-plan factor ranges.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsRatingPlanFactor, clsRatingPlanFactorCollection

SQL referencing this table

• SQL-039: clsRatingPlanFactor
• SQL-040: clsRatingPlanFactorCollection

---

RATING_PLAN_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores rating-plan-type codes.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsRatingPlanTypeCode

SQL referencing this table

• SQL-041: clsRatingPlanTypeCode

---

SAIFPLUS_DISCOUNT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores effective-dated SAIF Plus discount rates and caps.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsSAIFPlusDiscount

SQL referencing this table

• SQL-042: clsSAIFPlusDiscount

---

TERRORISM_RATE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores effective terrorism rates by market type.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsTerrorismRate

SQL referencing this table

• SQL-045: clsTerrorismRate

---

USLHW_COMP_FACTOR

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores effective USL&HW compensation factors.
Access pattern	direct SQL
CRUD operations	R
Key columns used	See linked SQL documents for column-level usage.
Sequence	N/A
Related tables	See relationship diagram and linked SQL pages.
Business objects	clsUSLHWCompFactor

SQL referencing this table

• SQL-046: clsUSLHWCompFactor

---

Table relationship diagram

The following diagram shows relationships identified in the library's SQL.

erDiagram
  RATE_FILE_MASTER ||--o{ MANUAL_CLASS_BASE : rate_file_seq_num
  MANUAL_CLASS_BASE ||--o{ MANUAL_CLASS_ASSOCIATION : manual_class_num
  MANUAL_CLASS_BASE ||--o{ MANUAL_CLASS_PARAGRAPH_USAGE : manual_class_num
  MANUAL_CLASS_PARAGRAPH ||--o{ MANUAL_CLASS_PARAGRAPH_USAGE : paragraph_num
  FED_COVERAGE_TYPE_CODE ||--o{ FED_COVERAGE_LIABILITY_LIMIT : code
  RATING_PLAN_CODE ||--o{ RATING_PLAN_FACTOR : code
  PREPAY_FREQUENCY_CODE ||--o{ PREPAY_DISCOUNT_FACTOR : code
  POLICY ||--o{ POLICY_PERIOD : policy_num
  POLICY ||--o{ POLICY_PERIOD_NON_WCIS : policy_num

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

• Business\SAIF.Business.Policy.Rating\clsManualClassBase.vb
• Business\SAIF.Business.Policy.Rating\clsManualClassBaseCollection.vb
• Business\SAIF.Business.Policy.Rating\clsManualClassParagraph.vb
• Business\SAIF.Business.Policy.Rating\clsManualClassParagraphUsage.vb
• Business\SAIF.Business.Policy.Rating\clsPeriodRatingInfo.vb
• Business\SAIF.Business.Policy.Rating\clsRateFileMaster.vb