Skip to content

Determine standard premium for a period

Determine standard premium for a period describes the corresponding policy-core workflow and its BOF or Oracle touchpoints.

Field Value
Operation ID OP-005
Trigger premium display or rating calculation
Inputs data portal, period context
Outputs standard premium amount
Primary components `clsPolicyPeriodBase.GetStandardPremium(...) (clsPolicyPeriodBase.vb)`
Entry point Business\SAIF.Business.Policy.Core

Steps

  1. Inspect the period's FinancialSystem.
  2. WCIS → GetWCISStandardPremium, which calls Oracle procedure pk72846_view_policy.sp73111_get_wcis_std_premium.
  3. AR or WINS → GetARStandardPremium, which executes ARStandardPremiumSQL.
  4. Any other financial system → return 0 (BR-013).
  5. Consolidate supporting references.
  6. Related business rules: BR-010, BR-013, BR-014, BR-015, BR-016, BR-022, BR-023, BR-031, BR-032
  7. Related SQL statements: SQL-061, SQL-062, SQL-078, SQL-079, SQL-080, SQL-081, SQL-082, SQL-083, SQL-084, SQL-085, SQL-086, SQL-087, SQL-106, SQL-107, SQL-108, SQL-109, SQL-110, SQL-111, SQL-112, SQL-113, SQL-114, SQL-115, SQL-116, SQL-117, SQL-118, SQL-119, SQL-120, SQL-121
  8. Related tables: NON_WCIS_STAT_TRANS, SUB_CONSTANTS, POLICY_PERIOD, POLICY, WCIS_CONSTANTS

Process flow

The following diagram visualizes this operation's control flow.

flowchart TD
    Start([Trigger]) --> S1[Apply policy-core logic]
    S1 --> D{Validation or branch?}
    D -->|Continue| S2[Execute BOF SQL or Oracle call]
    D -->|Stop| EndErr([Return error or empty result])
    S2 --> EndOk([Return populated result])

Failure and edge-case behavior

  • Error, warning, and empty-result behavior follows the rules and SQL cited in the steps above.
  • Stored-procedure-backed paths depend on Oracle-side logic outside this repository.**

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.Core\clsPolicy.vb
  • Business\SAIF.Business.Policy.Core\clsPolicyPeriodBase.vb
  • Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb
  • Business\SAIF.Business.Policy.Core\clsLegacyPolicyPeriod.vb
  • Business\SAIF.Business.Policy.Core\clsCancelReasonOverride.vb
  • Business\SAIF.Business.Policy.Core\WCISInquiry.vb