Skip to content

Delete all manual class bases for a rate file

clsManualClassBaseCollection.DeleteManualClassBasebyRateFileSeqNum (clsManualClassBaseCollection.vb:327-365)

Field Value
Operation ID OP-007
Trigger A rate file is being withdrawn or reloaded
Inputs WCIS rate file sequence number
Outputs Boolean success
Primary components `clsManualClassBaseCollection.DeleteManualClassBasebyRateFileSeqNum (clsManualClassBaseCollection.vb:327-365)`
Entry point Business\SAIF.Business.Policy.Rating\clsManualClassBaseCollection.vb

Steps

  1. Build the text statement
  2. Execute through the data portal.
  3. Return True on success.
  4. On any exception, swallow it and return False — no message is surfaced and no exception is
  5. Use the related data-access statements and tables for this operation: SQL-057, MANUAL_CLASS_BASE.

Process flow

The following diagram visualizes this operation's control flow.

flowchart TD
  Start([Trigger: rate file being withdrawn or reloaded]) --> S1[Build delete text statement]
  S1 --> S2[Execute through the data portal]
  S2 --> D1{Exception thrown?}
  D1 -->|No| S3[Return True]
  D1 -->|Yes, swallowed| S4[Return False - no message surfaced, no exception rethrown]
  S3 --> Done([Boolean success])
  S4 --> Done

Failure and edge-case behavior

  • Review the linked business rules and SQL documents for the validation or data-access conditions that can block this operation.

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\clsManualClassBaseCollection.vb