SQL-021: Resolve active rate file sequence number

This document records the SQL used by clsManualClassBaseCollection in SAIF.Business.Policy.Rating.

Classification

Field	Value
SQL ID	SQL-021
Operation type	Read
Execution method	Application method — stored procedure
Database	Oracle
Schema	N/A
Command type	StoredProcedure
Business object	clsManualClassBaseCollection
Criteria property	N/A — non-Criteria method
Lifecycle method	GetRateFileSeqNum

Parameters

Parameter	Direction	Type	Max length	Description
:inARD	Input	Not specified	not specified	Bound parameter.
:inRiskTypeCode	Input	Not specified	not specified	Bound parameter.
:RateFileSeqNum	Input	Not specified	not specified	Bound parameter.

Tables

Table	Access	Columns used
N/A	N/A	N/A

Sample SQL

PK73193_submission.get_rate_file_seq_num(
  :inARD,
  :inRiskTypeCode,
  :RateFileSeqNum
)

Operations and processes

• Resolve the rate file sequence number for a period

Sources

• Business\SAIF.Business.Policy.Rating\clsManualClassBaseCollection.vb:188-211