---
title: "SQL-004: Insert clsManualClassBase row"
summary: Insert clsManualClassBase row
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Rating
reference_type: package
---

# SQL-004: Insert clsManualClassBase row

This document records the SQL used by `clsManualClassBase` in `SAIF.Business.Policy.Rating`.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-004 |
| **Operation type** | Insert |
| **Execution method** | Data portal — criteria SQL |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `clsManualClassBase` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | `BeforeInsert / AfterInsert` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:RateFileSeqNum` | Input | Not specified | not specified | Bound parameter. |
| `:ManualClassNum` | Input | Not specified | not specified | Bound parameter. |
| `:ManualClassRateEffDate` | Input | Not specified | not specified | Bound parameter. |
| `:ManualClassRateExpDate` | Input | Not specified | not specified | Bound parameter. |
| `:DiseaseRatio` | Input | Not specified | not specified | Bound parameter. |
| `:ExpectedLossRate1` | Input | Not specified | not specified | Bound parameter. |
| `:ExpectedLossRate2` | Input | Not specified | not specified | Bound parameter. |
| `:ExposureBaseCode` | Input | Not specified | not specified | Bound parameter. |
| `:HazardGroup` | Input | Not specified | not specified | Bound parameter. |
| `:IndustryGroupCode` | Input | Not specified | not specified | Bound parameter. |
| `:LossConstant` | Input | Not specified | not specified | Bound parameter. |
| `:ManualClassDescr` | Input | Not specified | not specified | Bound parameter. |
| `:ManualClassRate` | Input | Not specified | not specified | Bound parameter. |
| `:ManualClassTypeCode` | Input | Not specified | not specified | Bound parameter. |
| `:MinPremium` | Input | Not specified | not specified | Bound parameter. |
| `:EmodRatableFlag` | Input | Not specified | not specified | Bound parameter. |
| `:RateTypeCode` | Input | Not specified | not specified | Bound parameter. |
| `:AuditAdditionalClassFlag` | Input | Not specified | not specified | Bound parameter. |
| `:CreateUserName` | Input | Not specified | not specified | Bound parameter. |
| `:CreateDate` | Input | Not specified | not specified | Bound parameter. |
| `:UpdateUserName` | Input | Not specified | not specified | Bound parameter. |
| `:UpdateDate` | Input | Not specified | not specified | Bound parameter. |
| `:NcciLossCost` | Input | Not specified | not specified | Bound parameter. |
| `:ReplacementManualClassNum` | Input | Not specified | not specified | Bound parameter. |
| `:ConstructionFlag` | Input | Not specified | not specified | Bound parameter. |
| `:ClaimFrequency` | Input | Not specified | not specified | Bound parameter. |
| `:StatCredibility` | Input | Not specified | not specified | Bound parameter. |
| `:BenefitJurisdictionCode` | Input | Not specified | not specified | Bound parameter. |
| `:PayInclAnotherClassFlag` | Input | Not specified | not specified | Bound parameter. |
| `:NonRateableElementFlag` | Input | Not specified | not specified | Bound parameter. |
| `:TimeLossFrequencyNum` | Input | Not specified | not specified | Bound parameter. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [MANUAL_CLASS_BASE](../database-tables.md#manual_class_base) | INSERT | See sample SQL and source for column usage. |

## Sample SQL

```sql
Insert into MANUAL_CLASS_BASE (
  RATE_FILE_SEQ_NUM,
  MANUAL_CLASS_NUM,
  MANUAL_CLASS_RATE_EFF_DATE,
  MANUAL_CLASS_RATE_EXP_DATE,
  DISEASE_RATIO,
  EXPECTED_LOSS_RATE_1,
  EXPECTED_LOSS_RATE_2,
  EXPOSURE_BASE_CODE,
  HAZARD_GROUP,
  INDUSTRY_GROUP_CODE,
  LOSS_CONSTANT,
  MANUAL_CLASS_DESCR,
  MANUAL_CLASS_RATE,
  MANUAL_CLASS_TYPE_CODE,
  MIN_PREMIUM,
  EMOD_RATABLE_FLAG,
  RATE_TYPE_CODE,
  AUDIT_ADDITIONAL_CLASS_FLAG,
  CREATE_USER_NAME,
  CREATE_DATE,
  UPDATE_USER_NAME,
  UPDATE_DATE,
  NCCI_LOSS_COST,
  REPLACEMENT_MANUAL_CLASS_NUM,
  CONSTRUCTION_FLAG,
  CLAIM_FREQUENCY,
  STAT_CREDIBILITY,
  BENEFIT_JURISDICTION_CODE,
  PAY_INCL_ANOTHER_CLASS_FLAG,
  NON_RATEABLE_ELEMENT_FLAG,
  TIME_LOSS_FREQUENCY_NUM)
Values (
  :RateFileSeqNum,
  :ManualClassNum,
  :ManualClassRateEffDate,
  :ManualClassRateExpDate,
  :DiseaseRatio,
  :ExpectedLossRate1,
  :ExpectedLossRate2,
  :ExposureBaseCode,
  :HazardGroup,
  :IndustryGroupCode,
  :LossConstant,
  :ManualClassDescr,
  :ManualClassRate,
  :ManualClassTypeCode,
  :MinPremium,
  :EmodRatableFlag,
  :RateTypeCode,
  :AuditAdditionalClassFlag,
  :CreateUserName,
  :CreateDate,
  :UpdateUserName,
  :UpdateDate,
  :NcciLossCost,
  :ReplacementManualClassNum,
  :ConstructionFlag,
  :ClaimFrequency,
  :StatCredibility,
  :BenefitJurisdictionCode,
  :PayInclAnotherClassFlag,
  :NonRateableElementFlag,
  :TimeLossFrequencyNum)
```

> **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:1513-1584`