Determine the NCCI statistical class number

Statistical reporting requires the NCCI stat class for an adjustment

Field	Value
Operation ID	OP-009
Trigger	Statistical reporting requires the NCCI stat class for an adjustment
Inputs	Seven input parameters
Outputs	out_stat_class (4 chars, ParameterDirection.ReturnValue)
Primary components	clsPremiumSummaryAdjustment.GetStatClassNumber (clsPremiumSummaryAdjustment.vb:549-580)
Entry point	Business\SAIF.Business.Policy.Premium\clsPremiumSummaryAdjustment.vb

Steps

1. Build a CommandType.StoredProcedure command for sp72151_determine_ncci_stat.
2. Add the seven inputs and the return-value output parameter.
3. Execute through the data portal.
4. Return an empty string when the output is DBNull (BR-022).

Process flow

The following diagram visualizes this operation's control flow.

flowchart TD
    Start([Trigger]) --> S1[Step 1]
    S1 --> S2[Step 2]
    S2 --> EndOk([Outputs returned])

Failure and edge-case behavior

• See the linked rules and SQL references above for validation failures, null-handling, and persistence contention behavior.

Related documentation

• Operations and processes
• Business rules
• SQL catalog
• Database tables

Sources

• Business\SAIF.Business.Policy.Premium\clsPremiumSummaryAdjustment.vb