SQL-033 Calculate statutory weekly wage
Calls the Oracle stored procedure that calculates the statutory weekly wage from injury date, wages, pay period, and hours/days worked.
Classification
| Field |
Value |
| SQL ID |
SQL-033 |
| Operation type |
Read |
| Execution method |
Stored procedure |
| Database |
Oracle |
| Schema |
[unqualified]** |
| Command type |
StoredProcedure |
| Business object |
clsStatutoryWeeklyWageCalculation |
| Criteria property |
(procedure) |
| Lifecycle method |
BeforeRetrieve |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
inInjuryDate |
Input |
String |
10 |
Date of injury (string form) |
inWages |
Input |
Decimal |
— |
Reported wages |
inPayPeriod |
Input |
String |
1 |
Pay period code |
inHoursWorkedPerDay |
Input |
Decimal |
— |
Hours worked per day |
inDaysWorkedPerWeek |
Input |
Decimal |
— |
Days worked per week |
recordset |
Output (Cursor) |
REF CURSOR |
N/A |
Result cursor |
Tables
| Table |
Access |
Columns used |
|
|
|
Sample SQL
-- Stored procedure call — sp82286_statutoryweeklywage
CALL sp82286_statutoryweeklywage(
:inInjuryDate,
:inWages,
:inPayPeriod,
:inHoursWorkedPerDay,
:inDaysWorkedPerWeek,
:recordset)
Procedure body resides in the Oracle database and could not be retrieved in this environment.
Operations and processes
Sources
- SAIF.Business.Claim/clsStatutoryWeeklyWageCalculation.vb