Skip to content

Resolve a manual class key (rate lookup)

clsManualClassBase.GetManualClassBaseKey(inDataportal, inPeriodRatingInfo, inClassEffectiveDate, ByRef inoutManualClassNumberAndUsageCode, ByRef outRateFileSeqNum) (clsManualClassBase.vb:1225-1268)

Field Value
Operation ID OP-004
Trigger A class number must be resolved to the rate file and (possibly replaced) class number that actually applies
Inputs Class number/usage code (in-out), class effective date, period rating info
Outputs Updated class number/usage code and rate file sequence number (both ByRef)
Primary components `clsManualClassBase.GetManualClassBaseKey(inDataportal, inPeriodRatingInfo, inClassEffectiveDate, ByRef inoutManualClassNumberAndUsageCode, ByRef outRateFileSeqNum) (clsManualClassBase.vb:1225-1268)`
Entry point Business\SAIF.Business.Policy.Rating\clsManualClassBase.vb

Steps

  1. Create a new portal request and data request; set
  2. Convert inPeriodRatingInfo.IsARDExtended to a "Y"/"N" string via .ToY_N_String.
  3. Add the parameters: io_class_num (6, InputOutput), in_class_eff_date, in_ard
  4. inDataportal.ProcessPortalRequest(PortalRequest).
  5. If io_rate_file_seq is not DBNull, assign it to outRateFileSeqNum (BR-013).
  6. If io_class_num is not DBNull, assign it back to inoutManualClassNumberAndUsageCode — this
  7. Use the related data-access statements and tables for this operation: SQL-019, RATE_FILE_MASTER, MANUAL_CLASS_BASE.

Process flow

The following diagram visualizes this operation's control flow.

flowchart TD
  Start([Trigger: resolve rate file and class number that applies]) --> S1[Create portal request and data request]
  S1 --> S2[Convert IsARDExtended to Y/N string via ToY_N_String]
  S2 --> S3[Add parameters: io_class_num InputOutput, in_class_eff_date, in_ard]
  S3 --> S4[ProcessPortalRequest]
  S4 --> D1{io_rate_file_seq not DBNull?}
  D1 -->|Yes| S5[Assign to outRateFileSeqNum - BR-013]
  D1 -->|No| S6[Leave outRateFileSeqNum unset]
  S5 --> D2{io_class_num not DBNull?}
  S6 --> D2
  D2 -->|Yes| S7[Assign back to inoutManualClassNumberAndUsageCode - class substituted]
  D2 -->|No| S8[Leave class number unchanged]
  S7 --> Done([Resolved rate file and class number])
  S8 --> 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\clsManualClassBase.vb