SQL-019: Resolve manual class and filing through stored procedure
This document records the SQL used by clsManualClassBase in SAIF.Business.Policy.Rating.
Classification
| Field |
Value |
| SQL ID |
SQL-019 |
| Operation type |
Read |
| Execution method |
Application method — stored procedure |
| Database |
Oracle |
| Schema |
N/A |
| Command type |
StoredProcedure |
| Business object |
clsManualClassBase |
| Criteria property |
N/A — non-Criteria method |
| Lifecycle method |
GetManualClassBaseKey |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
:io_class_num |
Input |
Not specified |
not specified |
Bound parameter. |
:in_class_eff_date |
Input |
Not specified |
not specified |
Bound parameter. |
:in_ard |
Input |
Not specified |
not specified |
Bound parameter. |
:in_risk_type_code |
Input |
Not specified |
not specified |
Bound parameter. |
:in_policy_period_eff_date |
Input |
Not specified |
not specified |
Bound parameter. |
:in_policy_period_exp_date |
Input |
Not specified |
not specified |
Bound parameter. |
:in_ard_extension_flag |
Input |
Not specified |
not specified |
Bound parameter. |
:io_rate |
Input |
Not specified |
not specified |
Bound parameter. |
:io_descr |
Input |
Not specified |
not specified |
Bound parameter. |
:io_rate_file_seq |
Input |
Not specified |
not specified |
Bound parameter. |
:io_exposure_base |
Input |
Not specified |
not specified |
Bound parameter. |
Tables
| Table |
Access |
Columns used |
| N/A |
N/A |
N/A |
Sample SQL
pk73059_prem_hist_summary.sp62005_retrieve_rate(
:io_class_num,
:in_class_eff_date,
:in_ard,
:in_risk_type_code,
:in_policy_period_eff_date,
:in_policy_period_exp_date,
:in_ard_extension_flag,
:io_rate,
:io_descr,
:io_rate_file_seq,
:io_exposure_base
)
Operations and processes
Business rules
Sources
Business\SAIF.Business.Policy.Rating\clsManualClassBase.vb:1225-1268