SAIF.Business.Tasks SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-001	Insert a new task record	Stored Proc	N/A — stored procedure (writes TASK)**	clsTask

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-002	Retrieve a single task by sequence number	Stored Proc	N/A — stored procedure (reads TASK)**	clsTask
SQL-003	Retrieve one action code by code value	Inline	TASK_ACTION_CODE	clsTaskActionCode
SQL-004	Retrieve all action codes	Inline	TASK_ACTION_CODE	clsTaskActionCodeCollection
SQL-005	Count matching source/category combinations for validation	Inline	TASK_CATEGORY_CODE	clsTaskBusinessRules
SQL-006	Retrieve one category code by code and source system	Inline	TASK_CATEGORY_CODE	clsTaskCategoryCode
SQL-007	Retrieve all category codes for a source system	Inline	TASK_CATEGORY_CODE	clsTaskCategoryCodeCollection
SQL-008	Retrieve tasks matching dynamic search criteria	StringBuilder-assembled	TASK	clsTaskCollection
SQL-009	Retrieve one priority code by code value	Inline	TASK_PRIORITY_CODE	clsTaskPriorityCode
SQL-010	Retrieve all priority codes	Inline	TASK_PRIORITY_CODE	clsTaskPriorityCodeCollection
SQL-011	Retrieve one source code by code value	Inline	TASK_SOURCE_CODE	clsTaskSourceCode
SQL-012	Retrieve all source codes	Inline	TASK_SOURCE_CODE	clsTaskSourceCodeCollection

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-013	Update an existing task's mutable fields	Stored Proc	N/A — stored procedure (writes TASK)**	clsTask

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-014	Complete (soft-delete) a task	Stored Proc	N/A — stored procedure (writes TASK)**	clsTask
SQL-015	Purge completed tasks past the retention window	Stored Proc	N/A — stored procedure (deletes from TASK)**	clsTaskCollection

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• Procedures
• API reference

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

• SAIF.Business.Tasks/clsTask.vb
• SAIF.Business.Tasks/clsTaskCollection.vb
• SAIF.Business.Tasks/clsTaskBusinessRules.vb
• SAIF.Business.Tasks/clsTaskActionCode.vb
• SAIF.Business.Tasks/clsTaskActionCodeCollection.vb
• SAIF.Business.Tasks/clsTaskCategoryCode.vb
• SAIF.Business.Tasks/clsTaskCategoryCodeCollection.vb
• SAIF.Business.Tasks/clsTaskPriorityCode.vb
• SAIF.Business.Tasks/clsTaskPriorityCodeCollection.vb
• SAIF.Business.Tasks/clsTaskSourceCode.vb
• SAIF.Business.Tasks/clsTaskSourceCodeCollection.vb