SQL-119: Call NCCI stat procedure¶

Call NCCI stat procedure in the context of clsPremiumSummaryAdjustment.

Classification¶

Field	Value
SQL ID	SQL-119
Operation type	Read
Execution method	StoredProcedure
Database	Oracle
Command type	StoredProcedure
Schema	Oracle package / procedure
Business object	N/A (Application layer)
Criteria property	`GetStatisticalCodeSQL`
Lifecycle method	Application-layer method: clsPremiumSummaryAdjustment.GetStatClassNumber()

Parameters¶

Parameter	Direction	Type	Max length	Description
`:in_policy_num`	Input	Numeric	—	Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
`:in_pp_eff_date`	Input	Date	—	Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
`:in_rr_master_id`	Input	Numeric	—	Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
`:in_ps_eff_date`	Input	Date	—	Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
`:in_ps_exp_date`	Input	Date	—	Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
`:in_ph_set_id`	Input	Numeric	—	Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
`:in_pa_type_code`	Input	String	variable (PremiumAdjustmentTypeCode.Length)	Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.
`:out_stat_class`	ReturnValue	String	4	Verified from AddParm() call site in Business/SAIF.Business.Policy.Premium/clsPremiumSummaryAdjustment.vb.

Tables¶

Table	Access	Columns used
N/A	Stored procedure	Procedure body resides in Oracle; see sp72151_determine_ncci_stat.

Sample SQL¶

EXEC sp72151_determine_ncci_stat (
  in_policy_num,
  in_pp_eff_date,
  in_rr_master_id,
  in_ps_eff_date,
  in_ps_exp_date,
  in_ph_set_id,
  in_pa_type_code,
  out_stat_class
)

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.Premium/clsPremiumSummaryAdjustment.vb