SAIF.Business.Policy.Premium database tables¶
This page catalogs the Oracle tables accessed directly by this library.
Table catalog¶
| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
|---|---|---|---|---|---|
| BILLING_DEFAULTS | Oracle | [unqualified] | RCUD | Stores default billing-plan/installment templates. | clsPaymentPlanDefaultValues |
| BILLING_DETAIL_TYPE_CODE | Oracle | [unqualified] | RCUD | Stores billing-detail type definitions. | clsBillingDetailTypeCode |
| BILLING_MASTER | Oracle | [unqualified] | RCUD | Stores billing-plan selections linked to a policy period and premium set. | clsPaymentPlan |
| FED_COVERAGE_TYPE_CODE | Oracle | [unqualified] | R | Stores federal coverage type reference values. | clsPolicyPeriodFederalCoverage |
| LC_POLICY_SERVICE_PLAN | Oracle | [unqualified] | RCUD | Stores loss-control service plan selections. | clsLossControlPolicyServicePlan |
| LOCATION | Oracle | [unqualified] | R | Stores policy location identity values for reporting projections. | clsPremiumPolicyLocation |
| PAYMENT_PLAN_TYPE_CODE | Oracle | [unqualified] | RCUD | Stores payment-plan type metadata and flags. | clsPaymentPlanType |
| PLAN_CODE | Oracle | [unqualified] | RCUD | Stores sales-plan metadata. | clsSalesPlan |
| POLICY_FINANCIAL_TRANS | Oracle | [unqualified] | RCUD | Stores premium financial transactions such as invoices, payments, and offsets. | clsFinancialTransaction |
| POLICY_FINANCIAL_TRANS_CODE | Oracle | [unqualified] | RCUD | Stores financial transaction code metadata and flags. | clsFinancialTransactionCode |
| POLICY_PERIOD_EMP_LIAB | Oracle | [unqualified] | R | Stores employer-liability rows used to infer ELCB behavior. | clsPremiumSummaryAdjustment |
| POLICY_PERIOD_FED_COVERAGE | Oracle | [unqualified] | R | Stores federal coverage rows scoped to policy periods. | clsPolicyPeriodFederalCoverage |
| POLICY_PERIOD_OCCPAP | Oracle | [unqualified] | R | Stores OCCPAP factors applied to policy periods. | clsPolicyPeriodOCCPAP |
| POLICY_PERIOD_RATING_PLAN | Oracle | N/A — accessed via DB link @POLDB (Policy database) | RCUD | Stores effective-dated rating plans applied directly to policy periods. | clsPolicyPeriodRatingPlan |
| POLICY_RENEWAL_RATING_PLAN | Oracle | [unqualified] | RCUD | Stores renewal-level rating plans merged with policy-period plans in memory. | clsPolicyRenewalRatingPlan |
| PREM_ADJUSTMENT_TYPE_CODE | Oracle | [unqualified] | R | Stores premium adjustment type definitions and rating metadata. | clsPremiumAdjustmentTypeCode |
| PREM_HIST_ADJ_RATE_CLASS | Oracle | N/A — accessed via DB link @POLDB (Policy database) | RC | Stores per-class adjusted-rate detail used for reported-payroll and rate-adjustment calculations. | clsClassCoverageRateAdjustment |
| PREM_HIST_CLASS_COVERAGE | Oracle | N/A — accessed via DB link @POLDB (Policy database) | RC | Stores the class-level premium history rows that identify manual class, usage, payroll, and rates. | clsClassCoverage |
| PREM_HIST_PREM_ADJUSTMENT | Oracle | N/A — accessed via DB link @POLDB (Policy database) | RC | Stores rating-rule-driven premium adjustments for a premium set and period slice. | clsPolicyPeriodRateAdjustment |
| PREM_HIST_PREM_ADJ_RATE | Oracle | N/A — accessed via DB link @POLDB (Policy database) | RC | Stores reporting-period rate-adjustment rows. | clsReportingPeriodRateAdjustment |
| PREM_HIST_PREM_SUMMARY | Oracle | N/A — accessed via DB link @POLDB (Policy database) | RC | Stores summarized premium adjustment amounts used for subtotaling and premium display. | clsPremiumSummaryAdjustment |
| PREM_HIST_SUMMARY | Oracle | N/A — accessed via DB link @POLDB (Policy database) | RC | Stores premium-set headers and processing metadata for a policy period. | clsPremiumSet |
| PREM_HIST_TYPE_CODE | Oracle | [unqualified] | R | Stores premium-set type reference values. | clsPremiumSetType |
| PREM_RATING_RULE_BASIS | Oracle | [unqualified] | R | Stores which premium adjustment codes participate in each rating-rule basis. | clsPremiumRatingRuleBasis |
| PREM_RATING_RULE_MASTER | Oracle | [unqualified] | R | Stores effective-dated premium rating-rule master records. | clsRatingRuleMaster |
| PREM_RATING_RULE_PRIORITY | Oracle | [unqualified] | R | Stores rating-rule priority ordering and function metadata. | clsPremiumRatingRulePriority |
| PREPAY_POLICY_PERIOD | Oracle | [unqualified] | RCUD | Stores prepay frequency and discount data for a policy period. | clsPolicyPeriodPrepay |
BILLING_DEFAULTS¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores default billing-plan/installment templates. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert, Update, Delete |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | BILLING_MASTER, PAYMENT_PLAN_TYPE_CODE |
| Business objects | clsPaymentPlanDefaultValues, clsPaymentPlanDefaultValuesCollection, clsPremiumSummaryAdjustment |
Operations referencing this table¶
SQL referencing this table¶
- SQL-026: Insert paymentplandefaultvalues
- SQL-027: Insert paymentplandefaultvalues collection
- SQL-051: Retrieve paymentplandefaultvalues
- SQL-052: Retrieve paymentplandefaultvalues collection
- SQL-090: Update paymentplandefaultvalues
- SQL-091: Update paymentplandefaultvalues collection
- SQL-107: Delete paymentplandefaultvalues
- SQL-108: Delete paymentplandefaultvalues collection
- SQL-116: Retrieve adjusted-rate billing flag
BILLING_DETAIL_TYPE_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores billing-detail type definitions. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert, Update, Delete |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | N/A |
| Business objects | clsBillingDetailTypeCode |
SQL referencing this table¶
- SQL-016: Insert billingdetailtypecode
- SQL-039: Retrieve billingdetailtypecode
- SQL-082: Update billingdetailtypecode
- SQL-099: Delete billingdetailtypecode
BILLING_MASTER¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores billing-plan selections linked to a policy period and premium set. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert, Update, Delete |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | BILLING_DEFAULTS |
| Business objects | clsPaymentPlan, clsPaymentPlanCollection, clsPremiumSummaryAdjustment |
Operations referencing this table¶
SQL referencing this table¶
- SQL-024: Insert paymentplan
- SQL-025: Insert paymentplan collection
- SQL-049: Retrieve paymentplan
- SQL-050: Retrieve paymentplan collection
- SQL-088: Update paymentplan
- SQL-089: Update paymentplan collection
- SQL-105: Delete paymentplan
- SQL-106: Delete paymentplan collection
- SQL-116: Retrieve adjusted-rate billing flag
FED_COVERAGE_TYPE_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores federal coverage type reference values. |
| Access pattern | Direct SQL |
| CRUD operations | Read |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | POLICY_PERIOD_FED_COVERAGE |
| Business objects | clsPolicyPeriodFederalCoverage, clsPolicyPeriodFederalCoverageCollection |
SQL referencing this table¶
- SQL-054: Retrieve policyperiodfederalcoverage
- SQL-055: Retrieve policyperiodfederalcoverage collection
LC_POLICY_SERVICE_PLAN¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores loss-control service plan selections. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert, Update, Delete |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | N/A |
| Business objects | clsLossControlPolicyServicePlan |
SQL referencing this table¶
- SQL-023: Insert losscontrolpolicyserviceplan
- SQL-048: Retrieve losscontrolpolicyserviceplan
- SQL-087: Update losscontrolpolicyserviceplan
- SQL-104: Delete losscontrolpolicyserviceplan
LOCATION¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores policy location identity values for reporting projections. |
| Access pattern | Direct SQL |
| CRUD operations | Read |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | N/A |
| Business objects | clsPremiumPolicyLocation |
SQL referencing this table¶
PAYMENT_PLAN_TYPE_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores payment-plan type metadata and flags. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert, Update, Delete |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | BILLING_DEFAULTS |
| Business objects | clsPaymentPlanType, clsPaymentPlanTypeCollection, clsPremiumSummaryAdjustment |
Operations referencing this table¶
SQL referencing this table¶
- SQL-028: Insert paymentplantype
- SQL-029: Insert paymentplantype collection
- SQL-053: Retrieve paymentplantype
- SQL-092: Update paymentplantype
- SQL-093: Update paymentplantype collection
- SQL-109: Delete paymentplantype
- SQL-110: Delete paymentplantype collection
- SQL-116: Retrieve adjusted-rate billing flag
PLAN_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores sales-plan metadata. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert, Update, Delete |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | N/A |
| Business objects | clsSalesPlan, clsSalesPlanCollection |
SQL referencing this table¶
- SQL-037: Insert salesplan
- SQL-038: Insert salesplan collection
- SQL-080: Retrieve salesplan
- SQL-081: Retrieve salesplan collection
- SQL-097: Update salesplan
- SQL-098: Update salesplan collection
- SQL-114: Delete salesplan
- SQL-115: Delete salesplan collection
POLICY_FINANCIAL_TRANS¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores premium financial transactions such as invoices, payments, and offsets. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert, Update, Delete |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | POLICY_FINANCIAL_TRANS_CODE |
| Business objects | clsFinancialTransaction, clsFinancialTransactionCollection |
SQL referencing this table¶
- SQL-019: Insert financialtransaction
- SQL-022: Insert financialtransaction collection
- SQL-044: Retrieve financialtransaction
- SQL-047: Retrieve financialtransaction collection
- SQL-083: Update financialtransaction
- SQL-086: Update financialtransaction collection
- SQL-100: Delete financialtransaction
- SQL-103: Delete financialtransaction collection
POLICY_FINANCIAL_TRANS_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores financial transaction code metadata and flags. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert, Update, Delete |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | POLICY_FINANCIAL_TRANS |
| Business objects | clsFinancialTransactionCode, clsFinancialTransactionCodeCollection |
SQL referencing this table¶
- SQL-020: Insert financialtransactioncode
- SQL-021: Insert financialtransactioncode collection
- SQL-045: Retrieve financialtransactioncode
- SQL-046: Retrieve financialtransactioncode collection
- SQL-084: Update financialtransactioncode
- SQL-085: Update financialtransactioncode collection
- SQL-101: Delete financialtransactioncode
- SQL-102: Delete financialtransactioncode collection
POLICY_PERIOD_EMP_LIAB¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores employer-liability rows used to infer ELCB behavior. |
| Access pattern | Direct SQL |
| CRUD operations | Read |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | N/A |
| Business objects | clsPremiumSummaryAdjustment |
Operations referencing this table¶
SQL referencing this table¶
POLICY_PERIOD_FED_COVERAGE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores federal coverage rows scoped to policy periods. |
| Access pattern | Direct SQL |
| CRUD operations | Read |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | FED_COVERAGE_TYPE_CODE |
| Business objects | clsPolicyPeriodFederalCoverage, clsPolicyPeriodFederalCoverageCollection |
SQL referencing this table¶
- SQL-054: Retrieve policyperiodfederalcoverage
- SQL-055: Retrieve policyperiodfederalcoverage collection
POLICY_PERIOD_OCCPAP¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores OCCPAP factors applied to policy periods. |
| Access pattern | Direct SQL |
| CRUD operations | Read |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | N/A |
| Business objects | clsPolicyPeriodOCCPAP, clsPolicyPeriodOCCPAPCollection |
SQL referencing this table¶
POLICY_PERIOD_RATING_PLAN¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | N/A — accessed via DB link @POLDB (Policy database) |
| Purpose | Stores effective-dated rating plans applied directly to policy periods. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert, Update, Delete |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | N/A |
| Business objects | clsPolicyPeriodRatingPlan, clsPolicyPeriodRatingPlanCollection |
Operations referencing this table¶
SQL referencing this table¶
- SQL-032: Insert policyperiodratingplan
- SQL-061: Retrieve policyperiodratingplan
- SQL-062: Retrieve policyperiodratingplan collection
- SQL-095: Update policyperiodratingplan
- SQL-112: Delete policyperiodratingplan
POLICY_RENEWAL_RATING_PLAN¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores renewal-level rating plans merged with policy-period plans in memory. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert, Update, Delete |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | N/A |
| Business objects | clsPolicyRenewalRatingPlan |
Operations referencing this table¶
SQL referencing this table¶
- SQL-033: Insert policyrenewalratingplan
- SQL-063: Retrieve policyrenewalratingplan
- SQL-096: Update policyrenewalratingplan
- SQL-113: Delete policyrenewalratingplan
PREM_ADJUSTMENT_TYPE_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores premium adjustment type definitions and rating metadata. |
| Access pattern | Direct SQL |
| CRUD operations | Read |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | PREM_RATING_RULE_MASTER |
| Business objects | clsPremiumAdjustmentTypeCode, clsPremiumAdjustmentTypeCodeCollection |
SQL referencing this table¶
PREM_HIST_ADJ_RATE_CLASS¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | N/A — accessed via DB link @POLDB (Policy database) |
| Purpose | Stores per-class adjusted-rate detail used for reported-payroll and rate-adjustment calculations. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | PREM_HIST_CLASS_COVERAGE |
| Business objects | clsClassCoverageRateAdjustment, clsClassCoverageRateAdjustmentCollection |
SQL referencing this table¶
- SQL-018: Insert classcoveragerateadjustment
- SQL-042: Retrieve classcoveragerateadjustment
- SQL-043: Retrieve classcoveragerateadjustment collection
PREM_HIST_CLASS_COVERAGE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | N/A — accessed via DB link @POLDB (Policy database) |
| Purpose | Stores the class-level premium history rows that identify manual class, usage, payroll, and rates. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert |
| Key columns used | See linked SQL documents** |
| Sequence | CLASS_COVERAGE_SEQ |
| Related tables | PREM_HIST_ADJ_RATE_CLASS, PREM_HIST_SUMMARY |
| Business objects | clsClassCoverage, clsClassCoverageCollection, clsClassCoverageRateAdjustment, clsClassCoverageRateAdjustmentCollection |
Operations referencing this table¶
- Retrieve class coverages for a premium set
- Save (insert/update) a class coverage line
- Retrieve reported payroll for premium history
SQL referencing this table¶
- SQL-017: Insert classcoverage
- SQL-040: Retrieve classcoverage
- SQL-041: Retrieve classcoverage collection
- SQL-042: Retrieve classcoveragerateadjustment
- SQL-043: Retrieve classcoveragerateadjustment collection
PREM_HIST_PREM_ADJUSTMENT¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | N/A — accessed via DB link @POLDB (Policy database) |
| Purpose | Stores rating-rule-driven premium adjustments for a premium set and period slice. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | PREM_HIST_SUMMARY |
| Business objects | clsPolicyPeriodRateAdjustment, clsPolicyPeriodRateAdjustmentCollection, clsPremiumSet |
Operations referencing this table¶
SQL referencing this table¶
- SQL-031: Insert policyperiodrateadjustment
- SQL-059: Retrieve policyperiodrateadjustment
- SQL-060: Retrieve policyperiodrateadjustment collection
- SQL-124: Count DCBS split rows
PREM_HIST_PREM_ADJ_RATE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | N/A — accessed via DB link @POLDB (Policy database) |
| Purpose | Stores reporting-period rate-adjustment rows. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | N/A |
| Business objects | clsReportingPeriodRateAdjustment, clsReportingPeriodRateAdjustmentCollection |
SQL referencing this table¶
- SQL-036: Insert reportingperiodrateadjustment
- SQL-078: Retrieve reportingperiodrateadjustment
- SQL-079: Retrieve reportingperiodrateadjustment collection
PREM_HIST_PREM_SUMMARY¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | N/A — accessed via DB link @POLDB (Policy database) |
| Purpose | Stores summarized premium adjustment amounts used for subtotaling and premium display. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | PREM_HIST_SUMMARY |
| Business objects | clsPremiumSummaryAdjustment, clsPremiumSummaryAdjustmentCollection |
SQL referencing this table¶
- SQL-035: Insert premiumsummaryadjustment
- SQL-074: Retrieve premiumsummaryadjustment
- SQL-075: Retrieve premiumsummaryadjustment collection
PREM_HIST_SUMMARY¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | N/A — accessed via DB link @POLDB (Policy database) |
| Purpose | Stores premium-set headers and processing metadata for a policy period. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert |
| Key columns used | See linked SQL documents** |
| Sequence | PREMIUM_HIST_SUMMARY_SEQ |
| Related tables | PREM_HIST_CLASS_COVERAGE, PREM_HIST_PREM_ADJUSTMENT, PREM_HIST_PREM_SUMMARY |
| Business objects | clsPremiumSet, clsPremiumSetCollection |
Operations referencing this table¶
SQL referencing this table¶
PREM_HIST_TYPE_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores premium-set type reference values. |
| Access pattern | Direct SQL |
| CRUD operations | Read |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | N/A |
| Business objects | clsPremiumSetType |
SQL referencing this table¶
PREM_RATING_RULE_BASIS¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores which premium adjustment codes participate in each rating-rule basis. |
| Access pattern | Direct SQL |
| CRUD operations | Read |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | PREM_RATING_RULE_MASTER |
| Business objects | clsPremiumRatingRuleBasis, clsPremiumRatingRuleBasisCollection |
SQL referencing this table¶
PREM_RATING_RULE_MASTER¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores effective-dated premium rating-rule master records. |
| Access pattern | Direct SQL |
| CRUD operations | Read |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | PREM_ADJUSTMENT_TYPE_CODE, PREM_RATING_RULE_BASIS, PREM_RATING_RULE_PRIORITY |
| Business objects | clsRatingRuleMaster, clsRatingRuleMasterCollection |
SQL referencing this table¶
PREM_RATING_RULE_PRIORITY¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores rating-rule priority ordering and function metadata. |
| Access pattern | Direct SQL |
| CRUD operations | Read |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | PREM_RATING_RULE_MASTER |
| Business objects | clsPremiumRatingRulePriority, clsPremiumRatingRulePriorityCollection, clsPremiumSummaryAdjustmentCollection |
SQL referencing this table¶
- SQL-069: Retrieve premiumratingrulepriority
- SQL-070: Retrieve premiumratingrulepriority collection
- SQL-075: Retrieve premiumsummaryadjustment collection
PREPAY_POLICY_PERIOD¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified] |
| Purpose | Stores prepay frequency and discount data for a policy period. |
| Access pattern | Direct SQL |
| CRUD operations | Read, Insert, Update, Delete |
| Key columns used | See linked SQL documents** |
| Sequence | N/A |
| Related tables | N/A |
| Business objects | clsPolicyPeriodPrepay |
SQL referencing this table¶
- SQL-030: Insert policyperiodprepay
- SQL-058: Retrieve policyperiodprepay
- SQL-094: Update policyperiodprepay
- SQL-111: Delete policyperiodprepay
Table relationship diagram¶
The following diagram shows the inferred or SQL-observed relationships between tables used directly by this library.
erDiagram
PREM_HIST_SUMMARY ||--o{ PREM_HIST_CLASS_COVERAGE : "PREM_HIST_SET_ID"
PREM_HIST_CLASS_COVERAGE ||--o{ PREM_HIST_ADJ_RATE_CLASS : "CLASS_COV_SEQ_NUM"
PREM_HIST_SUMMARY ||--o{ PREM_HIST_PREM_ADJUSTMENT : "PREM_HIST_SET_ID"
PREM_HIST_SUMMARY ||--o{ PREM_HIST_PREM_SUMMARY : "PREM_HIST_SET_ID"
PREM_RATING_RULE_MASTER ||--o{ PREM_RATING_RULE_PRIORITY : "RATING_RULE_MASTER_ID"
PREM_RATING_RULE_MASTER ||--o{ PREM_RATING_RULE_BASIS : "RATING_RULE_MASTER_ID"
PREM_RATING_RULE_MASTER ||--o{ PREM_ADJUSTMENT_TYPE_CODE : "RATING_RULE_MASTER_ID"
PAYMENT_PLAN_TYPE_CODE ||--o{ BILLING_DEFAULTS : "PAYMENT_PLAN_TYPE / CODE"
FED_COVERAGE_TYPE_CODE ||--o{ POLICY_PERIOD_FED_COVERAGE : "FED_COVERAGE_TYPE_CODE / CODE"
POLICY_FINANCIAL_TRANS_CODE ||--o{ POLICY_FINANCIAL_TRANS : "CODE / TRANS_TYPE_CODE"
BILLING_MASTER ||--o{ BILLING_DEFAULTS : "BILLING_DEFAULT_CODE"Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- SQL catalog
- API reference
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/Billing/clsBillingDetailTypeCode.vbBusiness/SAIF.Business.Policy.Premium/Billing/clsFinancialTransaction.vbBusiness/SAIF.Business.Policy.Premium/Billing/clsFinancialTransactionCode.vbBusiness/SAIF.Business.Policy.Premium/Billing/clsFinancialTransactionCodeCollection.vbBusiness/SAIF.Business.Policy.Premium/Billing/clsFinancialTransactionCollection.vbBusiness/SAIF.Business.Policy.Premium/Billing/clsPaymentPlanDefaultValues.vbBusiness/SAIF.Business.Policy.Premium/Billing/clsPaymentPlanDefaultValuesCollection.vbBusiness/SAIF.Business.Policy.Premium/Billing/clsPaymentPlanType.vbBusiness/SAIF.Business.Policy.Premium/Billing/clsPaymentPlanTypeCollection.vbBusiness/SAIF.Business.Policy.Premium/Billing/clsSalesPlan.vbBusiness/SAIF.Business.Policy.Premium/Billing/clsSalesPlanCollection.vbBusiness/SAIF.Business.Policy.Premium/Rating/clsPremiumAdjustmentTypeCode.vbBusiness/SAIF.Business.Policy.Premium/Rating/clsPremiumAdjustmentTypeCodeCollection.vbBusiness/SAIF.Business.Policy.Premium/Rating/clsPremiumRatingRuleBasis.vbBusiness/SAIF.Business.Policy.Premium/Rating/clsPremiumRatingRuleBasisCollection.vbBusiness/SAIF.Business.Policy.Premium/Rating/clsPremiumRatingRulePriority.vbBusiness/SAIF.Business.Policy.Premium/Rating/clsPremiumRatingRulePriorityCollection.vbBusiness/SAIF.Business.Policy.Premium/Rating/clsRatingRuleMaster.vbBusiness/SAIF.Business.Policy.Premium/Rating/clsRatingRuleMasterCollection.vbBusiness/SAIF.Business.Policy.Premium/Reporting/clsPremiumPolicyLocation.vbBusiness/SAIF.Business.Policy.Premium/clsClassCoverage.vbBusiness/SAIF.Business.Policy.Premium/clsClassCoverageCollection.vbBusiness/SAIF.Business.Policy.Premium/clsClassCoverageRateAdjustment.vbBusiness/SAIF.Business.Policy.Premium/clsClassCoverageRateAdjustmentCollection.vbBusiness/SAIF.Business.Policy.Premium/clsLossControlPolicyServicePlan.vbBusiness/SAIF.Business.Policy.Premium/clsPaymentPlan.vbBusiness/SAIF.Business.Policy.Premium/clsPaymentPlanCollection.vbBusiness/SAIF.Business.Policy.Premium/clsPolicyPeriodFederalCoverage.vbBusiness/SAIF.Business.Policy.Premium/clsPolicyPeriodFederalCoverageCollection.vbBusiness/SAIF.Business.Policy.Premium/clsPolicyPeriodOccpap.vbBusiness/SAIF.Business.Policy.Premium/clsPolicyPeriodOccpapCollection.vbBusiness/SAIF.Business.Policy.Premium/clsPolicyPeriodPrepay.vbBusiness/SAIF.Business.Policy.Premium/clsPolicyPeriodRateAdjustment.vbBusiness/SAIF.Business.Policy.Premium/clsPolicyPeriodRateAdjustmentCollection.vbBusiness/SAIF.Business.Policy.Premium/clsPolicyPeriodRatingPlan.vbBusiness/SAIF.Business.Policy.Premium/clsPolicyPeriodRatingPlanCollection.vbBusiness/SAIF.Business.Policy.Premium/clsPolicyRenewalRatingPlan.vbBusiness/SAIF.Business.Policy.Premium/clsPremiumSet.vbBusiness/SAIF.Business.Policy.Premium/clsPremiumSetCollection.vbBusiness/SAIF.Business.Policy.Premium/clsPremiumSetType.vbBusiness/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vbBusiness/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustmentCollection.vbBusiness/SAIF.Business.Policy.Premium/clsReportingPeriodRateAdjustment.vbBusiness/SAIF.Business.Policy.Premium/clsReportingPeriodRateAdjustmentCollection.vb