SQL-030: Count active support orders

This SQL document describes how may uses an inline Oracle query to support claim-domain read behavior.

Classification

Field	Value
SQL ID	SQL-030
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	may
Criteria property	RetrieveActiveSupportOrderCount
Lifecycle method	May read

Parameters

Parameter	Direction	Type	Max length	Description
:WorkerID	Input	N/A	N/A	Worker identifier used to filter support-order rows.

Tables

Table	Access	Columns used
cl_claim_support_order	SELECT	See sample SQL for referenced columns.

Sample SQL

select count(*) from cl_claim_support_order where term_date is null and worker_id = :WorkerID

Operations and processes

• Claim summary and detail retrieval

Business rules

• BR-002: Active support orders exclude terminated rows

Sources

• Business\SAIF.Business.View.Claim\clsClaimData.vb