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

# SQL-048: Update clsManualClassBase row

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

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-048 |
| **Operation type** | Update |
| **Execution method** | Data portal — criteria SQL |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `clsManualClassBase` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate / AfterUpdate` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `: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. |
| `: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. |
| `:RateFileSeqNum` | Input | Not specified | not specified | Bound parameter. |
| `:ManualClassNum` | Input | Not specified | not specified | Bound parameter. |

## Tables

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

## Sample SQL

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

> **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:1617-1654`