Skip to content

SAIF.Business.Policy.Premium SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.

Create operations

SQL ID Description Type Tables Business object
SQL-016 Insert a billing detail type code row Inline BILLING_DETAIL_TYPE_CODE clsBillingDetailTypeCode
SQL-017 Insert a class coverage row Inline PREM_HIST_CLASS_COVERAGE clsClassCoverage
SQL-018 Insert a class coverage rate adjustment row Inline PREM_HIST_ADJ_RATE_CLASS clsClassCoverageRateAdjustment
SQL-019 Insert a financial transaction row Inline POLICY_FINANCIAL_TRANS clsFinancialTransaction
SQL-020 Insert a financial transaction code row Inline POLICY_FINANCIAL_TRANS_CODE clsFinancialTransactionCode
SQL-021 Insert financial transaction code rows Inline POLICY_FINANCIAL_TRANS_CODE clsFinancialTransactionCodeCollection
SQL-022 Insert financial transaction rows Inline POLICY_FINANCIAL_TRANS clsFinancialTransactionCollection
SQL-023 Insert a loss control policy service plan row Inline LC_POLICY_SERVICE_PLAN clsLossControlPolicyServicePlan
SQL-024 Insert a payment plan row Inline BILLING_MASTER clsPaymentPlan
SQL-025 Insert payment plan rows Inline BILLING_MASTER clsPaymentPlanCollection
SQL-026 Insert a payment plan defaults row Inline BILLING_DEFAULTS clsPaymentPlanDefaultValues
SQL-027 Insert payment plan defaults rows Inline BILLING_DEFAULTS clsPaymentPlanDefaultValuesCollection
SQL-028 Insert a payment plan type row Inline PAYMENT_PLAN_TYPE_CODE clsPaymentPlanType
SQL-029 Insert payment plan type rows Inline PAYMENT_PLAN_TYPE_CODE clsPaymentPlanTypeCollection
SQL-030 Insert a policy period prepay row Inline PREPAY_POLICY_PERIOD clsPolicyPeriodPrepay
SQL-031 Insert a policy period rate adjustment row Inline PREM_HIST_PREM_ADJUSTMENT clsPolicyPeriodRateAdjustment
SQL-032 Insert a policy period rating plan row Inline POLICY_PERIOD_RATING_PLAN clsPolicyPeriodRatingPlan
SQL-033 Insert a policy renewal rating plan row Inline POLICY_RENEWAL_RATING_PLAN clsPolicyRenewalRatingPlan
SQL-034 Insert a premium set row Inline PREM_HIST_SUMMARY clsPremiumSet
SQL-035 Insert a premium summary adjustment row Inline PREM_HIST_PREM_SUMMARY clsPremiumSummaryAdjustment
SQL-036 Insert a reporting-period rate adjustment row Inline PREM_HIST_PREM_ADJ_RATE clsReportingPeriodRateAdjustment
SQL-037 Insert a sales plan row Inline PLAN_CODE clsSalesPlan
SQL-038 Insert sales plan rows Inline PLAN_CODE clsSalesPlanCollection
## Read operations
SQL ID Description Type Tables Business object
SQL-039 Retrieve a billing detail type code row Inline BILLING_DETAIL_TYPE_CODE clsBillingDetailTypeCode
SQL-040 Retrieve a class coverage row Inline PREM_HIST_CLASS_COVERAGE clsClassCoverage
SQL-041 Retrieve class coverage rows Inline PREM_HIST_CLASS_COVERAGE clsClassCoverageCollection
SQL-042 Retrieve a class coverage rate adjustment row Inline PREM_HIST_ADJ_RATE_CLASS, PREM_HIST_CLASS_COVERAGE clsClassCoverageRateAdjustment
SQL-043 Retrieve class coverage rate adjustment rows Inline PREM_HIST_ADJ_RATE_CLASS, PREM_HIST_CLASS_COVERAGE clsClassCoverageRateAdjustmentCollection
SQL-044 Retrieve a financial transaction row Inline POLICY_FINANCIAL_TRANS clsFinancialTransaction
SQL-045 Retrieve a financial transaction code row Inline POLICY_FINANCIAL_TRANS_CODE clsFinancialTransactionCode
SQL-046 Retrieve financial transaction code rows Inline POLICY_FINANCIAL_TRANS_CODE clsFinancialTransactionCodeCollection
SQL-047 Retrieve financial transaction rows Inline POLICY_FINANCIAL_TRANS clsFinancialTransactionCollection
SQL-048 Retrieve a loss control policy service plan row Inline LC_POLICY_SERVICE_PLAN clsLossControlPolicyServicePlan
SQL-049 Retrieve a payment plan row Inline BILLING_MASTER clsPaymentPlan
SQL-050 Retrieve payment plan rows Inline BILLING_MASTER clsPaymentPlanCollection
SQL-051 Retrieve a payment plan defaults row Inline BILLING_DEFAULTS clsPaymentPlanDefaultValues
SQL-052 Retrieve payment plan defaults rows Inline BILLING_DEFAULTS clsPaymentPlanDefaultValuesCollection
SQL-053 Retrieve a payment plan type row Inline PAYMENT_PLAN_TYPE_CODE clsPaymentPlanType
SQL-054 Retrieve a policy period federal coverage row Inline POLICY_PERIOD_FED_COVERAGE, FED_COVERAGE_TYPE_CODE clsPolicyPeriodFederalCoverage
SQL-055 Retrieve policy period federal coverage rows Inline FED_COVERAGE_TYPE_CODE, POLICY_PERIOD_FED_COVERAGE clsPolicyPeriodFederalCoverageCollection
SQL-056 Retrieve a policy period OCCPAP row Inline POLICY_PERIOD_OCCPAP clsPolicyPeriodOCCPAP
SQL-057 Retrieve policy period OCCPAP rows Inline POLICY_PERIOD_OCCPAP clsPolicyPeriodOCCPAPCollection
SQL-058 Retrieve a policy period prepay row Inline PREPAY_POLICY_PERIOD clsPolicyPeriodPrepay
SQL-059 Retrieve a policy period rate adjustment row Inline PREM_HIST_PREM_ADJUSTMENT clsPolicyPeriodRateAdjustment
SQL-060 Retrieve policy period rate adjustment rows Inline PREM_HIST_PREM_ADJUSTMENT clsPolicyPeriodRateAdjustmentCollection
SQL-061 Retrieve a policy period rating plan row Inline POLICY_PERIOD_RATING_PLAN clsPolicyPeriodRatingPlan
SQL-062 Retrieve policy period rating plan rows Inline POLICY_PERIOD_RATING_PLAN clsPolicyPeriodRatingPlanCollection
SQL-063 Retrieve a policy renewal rating plan row Inline POLICY_RENEWAL_RATING_PLAN clsPolicyRenewalRatingPlan
SQL-064 Retrieve a premium adjustment type code row Inline PREM_ADJUSTMENT_TYPE_CODE clsPremiumAdjustmentTypeCode
SQL-065 Retrieve premium adjustment type code rows Inline PREM_ADJUSTMENT_TYPE_CODE clsPremiumAdjustmentTypeCodeCollection
SQL-066 Retrieve a premium policy location row Inline LOCATION clsPremiumPolicyLocation
SQL-067 Retrieve a premium rating rule basis row Inline PREM_RATING_RULE_BASIS clsPremiumRatingRuleBasis
SQL-068 Retrieve premium rating rule basis rows Inline PREM_RATING_RULE_BASIS clsPremiumRatingRuleBasisCollection
SQL-069 Retrieve a premium rating rule priority row Inline PREM_RATING_RULE_PRIORITY clsPremiumRatingRulePriority
SQL-070 Retrieve premium rating rule priority rows Inline PREM_RATING_RULE_PRIORITY clsPremiumRatingRulePriorityCollection
SQL-071 Retrieve a premium set row Inline PREM_HIST_SUMMARY clsPremiumSet
SQL-072 Retrieve premium set rows Inline PREM_HIST_SUMMARY clsPremiumSetCollection
SQL-073 Retrieve a premium set type row Inline PREM_HIST_TYPE_CODE clsPremiumSetType
SQL-074 Retrieve a premium summary adjustment row Inline PREM_HIST_PREM_SUMMARY clsPremiumSummaryAdjustment
SQL-075 Retrieve premium summary adjustment rows Inline PREM_HIST_PREM_SUMMARY, PREM_RATING_RULE_PRIORITY clsPremiumSummaryAdjustmentCollection
SQL-076 Retrieve a rating rule master row Inline PREM_RATING_RULE_MASTER clsRatingRuleMaster
SQL-077 Retrieve rating rule master rows Inline PREM_RATING_RULE_MASTER clsRatingRuleMasterCollection
SQL-078 Retrieve a reporting-period rate adjustment row Inline PREM_HIST_PREM_ADJ_RATE clsReportingPeriodRateAdjustment
SQL-079 Retrieve reporting-period rate adjustment rows Inline PREM_HIST_PREM_ADJ_RATE clsReportingPeriodRateAdjustmentCollection
SQL-080 Retrieve a sales plan row Inline PLAN_CODE clsSalesPlan
SQL-081 Retrieve sales plan rows Inline PLAN_CODE clsSalesPlanCollection
SQL-116 Retrieve the adjusted-rate billing flag Inline BILLING_MASTER, BILLING_DEFAULTS, PAYMENT_PLAN_TYPE_CODE clsPremiumSummaryAdjustment
SQL-117 Determine ELCB status from liability rows Inline POLICY_PERIOD_EMP_LIAB clsPremiumSummaryAdjustment
SQL-118 Retrieve SAIF Plus discount details Stored Proc N/A — Stored procedure / sequence clsPremiumSummaryAdjustment
SQL-119 Determine the NCCI statistical class Stored Proc N/A — Stored procedure / sequence clsPremiumSummaryAdjustment
SQL-120 Recalculate manual premium for a rate tier Stored Proc N/A — Stored procedure / sequence clsPremiumSet
SQL-122 Fetch the next class coverage key Inline N/A — Stored procedure / sequence clsClassCoverage
SQL-123 Fetch the next premium set key Inline N/A — Stored procedure / sequence clsPremiumSet
SQL-124 Count DCBS split adjustment rows Inline PREM_HIST_PREM_ADJUSTMENT clsPremiumSet
## Update operations
SQL ID Description Type Tables Business object
SQL-082 Update a billing detail type code row Inline BILLING_DETAIL_TYPE_CODE clsBillingDetailTypeCode
SQL-083 Update a financial transaction row Inline POLICY_FINANCIAL_TRANS clsFinancialTransaction
SQL-084 Update a financial transaction code row Inline POLICY_FINANCIAL_TRANS_CODE clsFinancialTransactionCode
SQL-085 Update financial transaction code rows Inline POLICY_FINANCIAL_TRANS_CODE clsFinancialTransactionCodeCollection
SQL-086 Update financial transaction rows Inline POLICY_FINANCIAL_TRANS clsFinancialTransactionCollection
SQL-087 Update a loss control policy service plan row Inline LC_POLICY_SERVICE_PLAN clsLossControlPolicyServicePlan
SQL-088 Update a payment plan row Inline BILLING_MASTER clsPaymentPlan
SQL-089 Update payment plan rows Inline BILLING_MASTER clsPaymentPlanCollection
SQL-090 Update a payment plan defaults row Inline BILLING_DEFAULTS clsPaymentPlanDefaultValues
SQL-091 Update payment plan defaults rows Inline BILLING_DEFAULTS clsPaymentPlanDefaultValuesCollection
SQL-092 Update a payment plan type row Inline PAYMENT_PLAN_TYPE_CODE clsPaymentPlanType
SQL-093 Update payment plan type rows Inline PAYMENT_PLAN_TYPE_CODE clsPaymentPlanTypeCollection
SQL-094 Update a policy period prepay row Inline PREPAY_POLICY_PERIOD clsPolicyPeriodPrepay
SQL-095 Update a policy period rating plan row Inline POLICY_PERIOD_RATING_PLAN clsPolicyPeriodRatingPlan
SQL-096 Update a policy renewal rating plan row Inline POLICY_RENEWAL_RATING_PLAN clsPolicyRenewalRatingPlan
SQL-097 Update a sales plan row Inline PLAN_CODE clsSalesPlan
SQL-098 Update sales plan rows Inline PLAN_CODE clsSalesPlanCollection
## Delete operations
SQL ID Description Type Tables Business object
SQL-099 Delete a billing detail type code row Inline BILLING_DETAIL_TYPE_CODE clsBillingDetailTypeCode
SQL-100 Delete a financial transaction row Inline POLICY_FINANCIAL_TRANS clsFinancialTransaction
SQL-101 Delete a financial transaction code row Inline POLICY_FINANCIAL_TRANS_CODE clsFinancialTransactionCode
SQL-102 Delete financial transaction code rows Inline POLICY_FINANCIAL_TRANS_CODE clsFinancialTransactionCodeCollection
SQL-103 Delete financial transaction rows Inline POLICY_FINANCIAL_TRANS clsFinancialTransactionCollection
SQL-104 Delete a loss control policy service plan row Inline LC_POLICY_SERVICE_PLAN clsLossControlPolicyServicePlan
SQL-105 Delete a payment plan row Inline BILLING_MASTER clsPaymentPlan
SQL-106 Delete payment plan rows Inline BILLING_MASTER clsPaymentPlanCollection
SQL-107 Delete a payment plan defaults row Inline BILLING_DEFAULTS clsPaymentPlanDefaultValues
SQL-108 Delete payment plan defaults rows Inline BILLING_DEFAULTS clsPaymentPlanDefaultValuesCollection
SQL-109 Delete a payment plan type row Inline PAYMENT_PLAN_TYPE_CODE clsPaymentPlanType
SQL-110 Delete payment plan type rows Inline PAYMENT_PLAN_TYPE_CODE clsPaymentPlanTypeCollection
SQL-111 Delete a policy period prepay row Inline PREPAY_POLICY_PERIOD clsPolicyPeriodPrepay
SQL-112 Delete a policy period rating plan row Inline POLICY_PERIOD_RATING_PLAN clsPolicyPeriodRatingPlan
SQL-113 Delete a policy renewal rating plan row Inline POLICY_RENEWAL_RATING_PLAN clsPolicyRenewalRatingPlan
SQL-114 Delete a sales plan row Inline PLAN_CODE clsSalesPlan
SQL-115 Delete sales plan rows Inline PLAN_CODE clsSalesPlanCollection
## Sequence operations
SQL ID Description Sequence Tables Business object
SQL-001 Fetch the next financial transaction key Sequence N/A clsFinancialTransaction
SQL-002 Fetch the next financial transaction code key Sequence N/A clsFinancialTransactionCode
SQL-003 Fetch the next financial transaction code key Sequence N/A clsFinancialTransactionCodeCollection
SQL-004 Fetch the next financial transaction key Sequence N/A clsFinancialTransactionCollection
SQL-005 Fetch the next loss control policy service plan key Sequence N/A clsLossControlPolicyServicePlan
SQL-006 Fetch the next payment plan key Sequence N/A clsPaymentPlan
SQL-007 Fetch the next payment plan key Sequence N/A clsPaymentPlanCollection
SQL-008 Fetch the next payment plan defaults key Sequence N/A clsPaymentPlanDefaultValues
SQL-009 Fetch the next payment plan defaults key Sequence N/A clsPaymentPlanDefaultValuesCollection
SQL-010 Fetch the next payment plan type key Sequence N/A clsPaymentPlanType
SQL-011 Fetch the next payment plan type key Sequence N/A clsPaymentPlanTypeCollection
SQL-012 Fetch the next policy period prepay key Sequence N/A clsPolicyPeriodPrepay
SQL-013 Fetch the next policy renewal rating plan key Sequence N/A clsPolicyRenewalRatingPlan
SQL-014 Fetch the next sales plan key Sequence N/A clsSalesPlan
SQL-015 Fetch the next sales plan key Sequence N/A clsSalesPlanCollection

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.Premium\SAIF.BOF.Business.Policy.Premium.vbproj