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	UPDATE	See sample SQL and source for column usage.

Sample 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