Skip to content

Resolve the rate file sequence number for a period

clsManualClassBaseCollection.GetRateFileSeqNum(inDataPortalInfo, inPeriodRatingInfo) (clsManualClassBaseCollection.vb:188-211)

Field Value
Operation ID OP-003
Trigger Rating needs to know which published rate file governs a policy period
Inputs IDataPortalInfo, iPeriodRatingInfo (supplies anniversary rating date and rate tier code)
Outputs Decimal rate file sequence number
Primary components `clsManualClassBaseCollection.GetRateFileSeqNum(inDataPortalInfo, inPeriodRatingInfo) (clsManualClassBaseCollection.vb:188-211)`
Entry point Business\SAIF.Business.Policy.Rating\clsManualClassBaseCollection.vb

Steps

  1. Obtain a portal request via DAL.GetPortalRequest(inDataPortalInfo.PortalID).
  2. Set CommandType = StoredProcedure, RequestType = NonQuery, and the statement to
  3. Add parameters inARD (anniversary rating date), inRiskTypeCode (rate tier code, 5 chars) and
  4. DAL.ProcessPortalRequest(PortalRequest).
  5. Read back ParmValue("RateFileSeqNum"), convert with CDec, and return it.
  6. Use the related data-access statements and tables for this operation: SQL-021, RATE_FILE_MASTER.

Process flow

The following diagram visualizes this operation's control flow.

flowchart TD
  Start([Trigger: rating needs to know the governing rate file]) --> S1[Get portal request via DAL.GetPortalRequest]
  S1 --> S2[Set CommandType=StoredProcedure, RequestType=NonQuery]
  S2 --> S3[Add parameters: inARD, inRiskTypeCode, output RateFileSeqNum]
  S3 --> S4[DAL.ProcessPortalRequest]
  S4 --> S5[Read ParmValue RateFileSeqNum, convert with CDec]
  S5 --> Done([Return rate file sequence number])

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