SQL-018: Read N/A — Stored Procedure Data

This statement supports the premium-audit library by read N/A — Stored Procedure Data.

Classification

Field	Value
SQL ID	SQL-018
Operation type	Read
Execution method	CommandType.StoredProcedure / DataRequestType.NonQuery
Database	Oracle
Schema	WCIS_DBA
Command type	StoredProcedure
Business object	clsAudit
Criteria property	n/a — application layer
Lifecycle method	clsAudit.AuditLocationSeqNum (application layer)

Parameters

Parameter	Direction	Type	Max length	Description
—	—	—	—	No bound parameters detected in source.

Tables

Table	Access	Columns used
N/A	Stored procedure	N/A

Sample SQL

-- SQL text unavailable**

Operations and processes

• Assign an audit to an auditor
• Synchronize an audit with WCIS policy-period changes
• Save a premium audit
• Audit lifecycle status transitions

Business rules

• BR-020
• BR-021
• BR-032
• BR-035
• BR-036
• BR-037
• BR-057

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.Audit.Premium/clsAudit.vb:2686-2703, 5016-5020