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