SQL-005 Valid sourcecategory check

Runs a scalar count query against TASK_CATEGORY_CODE to validate that a task's source system and category code combination is a registered pairing (rule TASK1).

Classification

Field	Value
SQL ID	SQL-005
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	N/A (Application layer)
Criteria property	N/A
Lifecycle method	N/A
Application class	clsTaskBusinessRules

Parameters

Parameter	Direction	Type	Max length	Description
:Source	Input	String	5	Task source code being validated
:Category	Input	String	5	Task category code being validated

Tables

Table	Access	Columns used
TASK_CATEGORY_CODE	SELECT	TASK_SOURCE_CODE, CODE

Sample SQL

-- RequestType = Scalar; executed directly from the rule handler
SELECT
  COUNT(*)
FROM
  TASK_CATEGORY_CODE
WHERE
  TASK_SOURCE_CODE = :Source
  AND CODE = :Category

Operations and processes

• Create/insert a task
• Update a task

Business rules

• BR-005: The Task Source Code / Task Category Code combination must exist
• BR-026: Descendant task types may override common rule outcomes

Sources

• SAIF.Business.Tasks/clsTaskBusinessRules.vb