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

# SQL-020: Retrieve clsManualClassBase data

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

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-020 |
| **Operation type** | Read |
| **Execution method** | Data portal — criteria SQL |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `clsManualClassBase` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve / AfterRetrieve` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `: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) | SELECT | See sample SQL and source for column usage. |

## Sample SQL

```sql
Select
  MANUAL_CLASS_BASE.AUDIT_ADDITIONAL_CLASS_FLAG as AuditAdditionalClassFlag,
  MANUAL_CLASS_BASE.BENEFIT_JURISDICTION_CODE as BenefitJurisdictionCode,
  MANUAL_CLASS_BASE.CLAIM_FREQUENCY as ClaimFrequency,
  MANUAL_CLASS_BASE.CONSTRUCTION_FLAG as ConstructionFlag,
  MANUAL_CLASS_BASE.CREATE_DATE as CreateDate,
  MANUAL_CLASS_BASE.CREATE_USER_NAME as CreateUserName,
  MANUAL_CLASS_BASE.DISEASE_RATIO as DiseaseRatio,
  MANUAL_CLASS_BASE.EMOD_RATABLE_FLAG as EmodRatableFlag,
  MANUAL_CLASS_BASE.EXPECTED_LOSS_RATE_1 as ExpectedLossRate1,
  MANUAL_CLASS_BASE.EXPECTED_LOSS_RATE_2 as ExpectedLossRate2,
  MANUAL_CLASS_BASE.EXPOSURE_BASE_CODE as ExposureBaseCode,
  MANUAL_CLASS_BASE.HAZARD_GROUP as HazardGroup,
  MANUAL_CLASS_BASE.INDUSTRY_GROUP_CODE as IndustryGroupCode,
  MANUAL_CLASS_BASE.LOSS_CONSTANT as LossConstant,
  MANUAL_CLASS_BASE.MANUAL_CLASS_DESCR as ManualClassDescr,
  MANUAL_CLASS_BASE.MANUAL_CLASS_NUM as ManualClassNum,
  MANUAL_CLASS_BASE.MANUAL_CLASS_RATE as ManualClassRate,
  MANUAL_CLASS_BASE.MANUAL_CLASS_RATE_EFF_DATE as ManualClassRateEffDate,
  MANUAL_CLASS_BASE.MANUAL_CLASS_RATE_EXP_DATE as ManualClassRateExpDate,
  MANUAL_CLASS_BASE.MANUAL_CLASS_TYPE_CODE as ManualClassTypeCode,
  MANUAL_CLASS_BASE.MIN_PREMIUM as MinPremium,
  MANUAL_CLASS_BASE.NCCI_LOSS_COST as NcciLossCost,
  MANUAL_CLASS_BASE.NON_RATEABLE_ELEMENT_FLAG as NonRateableElementFlag,
  MANUAL_CLASS_BASE.PAY_INCL_ANOTHER_CLASS_FLAG as PayInclAnotherClassFlag,
  MANUAL_CLASS_BASE.RATE_FILE_SEQ_NUM as RateFileSeqNum,
  MANUAL_CLASS_BASE.RATE_TYPE_CODE as RateTypeCode,
  MANUAL_CLASS_BASE.REPLACEMENT_MANUAL_CLASS_NUM as ReplacementManualClassNum,
  MANUAL_CLASS_BASE.STAT_CREDIBILITY as StatCredibility,
  MANUAL_CLASS_BASE.UPDATE_DATE as UpdateDate,
  MANUAL_CLASS_BASE.time_loss_frequency_num as TimeLossFrequency,
  MANUAL_CLASS_BASE.UPDATE_USER_NAME as UpdateUserName,
  DECODE(mcdIsDefault.manual_class_num, NULL, 'N', 'Y') as IsDefaultClassFlag,
  NVL(mcdismunicipal.MUNICIPAL_CLASS_FLAG, 'N') as IsMunicipalClassFlag
from
  MANUAL_CLASS_BASE
Where
  MANUAL_CLASS_BASE.RATE_FILE_SEQ_NUM = :RateFileSeqNum
  AND MANUAL_CLASS_BASE.MANUAL_CLASS_RATE_EFF_DATE <>
    NVL(MANUAL_CLASS_BASE.MANUAL_CLASS_RATE_EXP_DATE,
      MANUAL_CLASS_BASE.MANUAL_CLASS_RATE_EFF_DATE + 1)
  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:1586-1604`