Skip to content

SAIF.Business.Policy.Rating SQL catalog

This page indexes the SQL statements, sequence reads, and stored-procedure calls used by SAIF.Business.Policy.Rating.

Read operations

SQL ID Description Type Tables Business object
SQL-010 Retrieve clsDTECRate data Inline DTEC_RATE clsDTECRate
SQL-011 Retrieve clsEmployeeRatingType data Inline EMPLOYEE_RATING_TYPE_CODE clsEmployeeRatingType
SQL-012 Retrieve clsFederalCoverageLiabilityLimit data Inline FED_COVERAGE_LIABILITY_LIMIT clsFederalCoverageLiabilityLimit
SQL-013 Retrieve clsFederalCoverageLiabilityLimitCollection data Inline FED_COVERAGE_LIABILITY_LIMIT clsFederalCoverageLiabilityLimitCollection
SQL-014 Retrieve clsFederalCoverageTypeCode data Inline FED_COVERAGE_TYPE_CODE clsFederalCoverageTypeCode
SQL-015 Retrieve clsManualClassAssociation data Inline MANUAL_CLASS_ASSOCIATION clsManualClassAssociation
SQL-016 Retrieve clsManualClassAssociationCollection data Inline MANUAL_CLASS_ASSOCIATION clsManualClassAssociationCollection
SQL-017 Check premium-history references before class delete Inline PREM_HIST_CLASS_COVERAGE clsManualClassBase
SQL-018 Retrieve active class paragraph text Inline MANUAL_CLASS_PARAGRAPH_USAGE, MANUAL_CLASS_PARAGRAPH clsManualClassBase
SQL-019 Resolve manual class and filing through stored procedure Stored Proc N/A clsManualClassBase
SQL-020 Retrieve clsManualClassBase data Inline MANUAL_CLASS_BASE clsManualClassBase
SQL-021 Resolve active rate file sequence number Stored Proc N/A clsManualClassBaseCollection
SQL-022 Retrieve clsManualClassBaseCollection data Inline MANUAL_CLASS_BASE, MANUAL_CLASS_DETAIL clsManualClassBaseCollection
SQL-023 Retrieve clsManualClassParagraph data Inline MANUAL_CLASS_PARAGRAPH clsManualClassParagraph
SQL-024 Retrieve clsManualClassParagraphUsage data Inline MANUAL_CLASS_PARAGRAPH_USAGE clsManualClassParagraphUsage
SQL-025 Retrieve clsManualClassParagraphUsageCollection data Inline MANUAL_CLASS_PARAGRAPH_USAGE clsManualClassParagraphUsageCollection
SQL-026 Retrieve clsManualClassType data Inline MANUAL_CLASS_TYPE_CODE clsManualClassType
SQL-027 Retrieve period rating context from WCIS and legacy tables Inline POLICY, POLICY_PERIOD, POLICY_PERIOD_NON_WCIS clsPeriodRatingInfo
SQL-028 Retrieve clsPremiumSizeDiscount data Inline PREMIUM_DISCOUNT_RANGE clsPremiumSizeDiscount
SQL-029 Retrieve clsPrepayDiscountFactor data Inline PREPAY_DISCOUNT_FACTOR clsPrepayDiscountFactor
SQL-030 Retrieve clsPrepayDiscountFactorCollection data Inline PREPAY_DISCOUNT_FACTOR clsPrepayDiscountFactorCollection
SQL-031 Retrieve clsPrepayFrequency data Inline PREPAY_FREQUENCY_CODE clsPrepayFrequency
SQL-032 Check whether rate file still has manual classes Inline MANUAL_CLASS_BASE clsRateFileMaster
SQL-033 Retrieve clsRateFileMaster data Inline RATE_FILE_MASTER clsRateFileMaster
SQL-034 Retrieve clsRateFileMasterCollection data Inline RATE_FILE_MASTER clsRateFileMasterCollection
SQL-035 Retrieve clsRateTier data Inline RISK_TYPE_CODE clsRateTier
SQL-036 Retrieve clsRateTierCollection data Inline RISK_TYPE_CODE clsRateTierCollection
SQL-037 Retrieve clsRateTierFactor data Inline RISK_TYPE_DESCRIPTION clsRateTierFactor
SQL-038 Retrieve clsRatingPlanCode data Inline RATING_PLAN_CODE clsRatingPlanCode
SQL-039 Retrieve clsRatingPlanFactor data Inline RATING_PLAN_FACTOR clsRatingPlanFactor
SQL-040 Retrieve clsRatingPlanFactorCollection data Inline RATING_PLAN_FACTOR clsRatingPlanFactorCollection
SQL-041 Retrieve clsRatingPlanTypeCode data Inline RATING_PLAN_TYPE_CODE clsRatingPlanTypeCode
SQL-042 Retrieve clsSAIFPlusDiscount data Inline SAIFPLUS_DISCOUNT clsSAIFPlusDiscount
SQL-043 Retrieve clsStatPremiumClass data Inline STAT_PREMIUM_CLASS clsStatPremiumClass
SQL-044 Retrieve clsStatPremiumClassCollection data Inline STAT_PREMIUM_CLASS clsStatPremiumClassCollection
SQL-045 Retrieve clsTerrorismRate data Inline TERRORISM_RATE clsTerrorismRate
SQL-046 Retrieve effective USL&HW compensation factor Inline USLHW_COMP_FACTOR clsUSLHWCompFactor

Update operations

SQL ID Description Type Tables Business object
SQL-047 Update clsManualClassAssociation row Inline MANUAL_CLASS_ASSOCIATION clsManualClassAssociation
SQL-048 Update clsManualClassBase row Inline MANUAL_CLASS_BASE clsManualClassBase
SQL-049 Update clsManualClassDetail row Inline MANUAL_CLASS_DETAIL clsManualClassDetail
SQL-050 Update clsManualClassParagraph row Inline MANUAL_CLASS_PARAGRAPH clsManualClassParagraph
SQL-051 Update clsManualClassParagraphUsage row Inline MANUAL_CLASS_PARAGRAPH_USAGE clsManualClassParagraphUsage
SQL-052 Update prepay frequency code row (compiled SQL is incomplete) Inline PREPAY_FREQUENCY_CODE clsPrepayFrequencyCodeCollection
SQL-053 Update clsRateFileMaster row Inline RATE_FILE_MASTER clsRateFileMaster
SQL-054 Update clsStatPremiumClass row Inline STAT_PREMIUM_CLASS clsStatPremiumClass

Delete operations

SQL ID Description Type Tables Business object
SQL-055 Delete clsManualClassAssociation row Inline MANUAL_CLASS_ASSOCIATION clsManualClassAssociation
SQL-056 Delete clsManualClassBase row Inline MANUAL_CLASS_BASE clsManualClassBase
SQL-057 Bulk delete manual class bases by rate file Inline MANUAL_CLASS_BASE clsManualClassBaseCollection
SQL-058 Delete clsManualClassDetail row Inline MANUAL_CLASS_DETAIL clsManualClassDetail
SQL-059 Delete clsManualClassParagraph row Inline MANUAL_CLASS_PARAGRAPH clsManualClassParagraph
SQL-060 Delete clsManualClassParagraphUsage row Inline MANUAL_CLASS_PARAGRAPH_USAGE clsManualClassParagraphUsage
SQL-061 Delete clsRateFileMaster row Inline RATE_FILE_MASTER clsRateFileMaster
SQL-062 Delete clsStatPremiumClass row Inline STAT_PREMIUM_CLASS clsStatPremiumClass

Sequence operations

SQL ID Description Sequence Tables Business object
SQL-001 Fetch next manual class paragraph number token DUAL DUAL clsManualClassParagraph
SQL-002 Fetch next rate file sequence number DUAL DUAL clsRateFileMaster

Sources

  • Business\SAIF.Business.Policy.Rating\clsManualClassAssociation.vb
  • Business\SAIF.Business.Policy.Rating\clsManualClassBase.vb
  • Business\SAIF.Business.Policy.Rating\clsManualClassBaseCollection.vb
  • Business\SAIF.Business.Policy.Rating\clsManualClassDetail.vb
  • Business\SAIF.Business.Policy.Rating\clsManualClassParagraph.vb
  • Business\SAIF.Business.Policy.Rating\clsManualClassParagraphUsage.vb
  • Business\SAIF.Business.Policy.Rating\clsPeriodRatingInfo.vb
  • Business\SAIF.Business.Policy.Rating\clsPrepayFrequencyCollection.vb
  • Business\SAIF.Business.Policy.Rating\clsRateFileMaster.vb
  • Business\SAIF.Business.Policy.Rating\clsStatPremiumClass.vb