---
title: SAIF.Business.Tasks SQL catalog
summary: Index of all SQL statements used by the SAIF.Business.Tasks library, grouped by operation type.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.Tasks
reference_type: package
---

# 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](SQL-001-task-insert.md) | Task insert | Stored Proc | TASK | `clsTask` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-002](SQL-002-task-select.md) | Task select | Stored Proc | TASK | `clsTask` |
| [SQL-003](SQL-003-task-action-code-by-code.md) | Task action code by code | Inline | TASK_ACTION_CODE | `clsTaskActionCode` |
| [SQL-004](SQL-004-task-action-code-list.md) | Task action code list | Inline | TASK_ACTION_CODE | `clsTaskActionCodeCollection` |
| [SQL-005](SQL-005-task-category-code-count.md) | Task category combination validation | Inline | TASK_CATEGORY_CODE | `clsTaskBusinessRules` |
| [SQL-006](SQL-006-task-category-code-by-source-and-code.md) | Task category code by source and code | Inline | TASK_CATEGORY_CODE | `clsTaskCategoryCode` |
| [SQL-007](SQL-007-task-category-code-list-by-source.md) | Task category code list by source | Inline | TASK_CATEGORY_CODE | `clsTaskCategoryCodeCollection` |
| [SQL-008](SQL-008-task-filtered-collection-select.md) | Task filtered collection select | StringBuilder | TASK | `clsTaskCollection` |

| [SQL-009](SQL-009-task-priority-code-by-code.md) | Task priority code by code | Inline | TASK_PRIORITY_CODE | `clsTaskPriorityCode` |
| [SQL-010](SQL-010-task-priority-code-list.md) | Task priority code list | Inline | TASK_PRIORITY_CODE | `clsTaskPriorityCodeCollection` |
| [SQL-011](SQL-011-task-source-code-by-code.md) | Task source code by code | Inline | TASK_SOURCE_CODE | `clsTaskSourceCode` |
| [SQL-012](SQL-012-task-source-code-list.md) | Task source code list | Inline | TASK_SOURCE_CODE | `clsTaskSourceCodeCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-013](SQL-013-task-update.md) | Task update | Stored Proc | TASK | `clsTask` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-014](SQL-014-task-delete.md) | Task delete | Stored Proc | TASK | `clsTask` |
| [SQL-015](SQL-015-task-purge.md) | Task purge | Stored Proc | TASK | `clsTaskCollection` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [Procedures](../procedures/index.md)
- [API reference](../api/index.md)
- [Configuration](../configuration.md)

## Sources
- `Business\SAIF.Business.Tasks\clsTask.vb`
- `Business\SAIF.Business.Tasks\clsTaskCollection.vb`
- `Business\SAIF.Business.Tasks\clsTaskBusinessRules.vb`
- `Business\SAIF.Business.Tasks\clsTaskActionCode.vb`
- `Business\SAIF.Business.Tasks\clsTaskActionCodeCollection.vb`
- `Business\SAIF.Business.Tasks\clsTaskCategoryCode.vb`
- `Business\SAIF.Business.Tasks\clsTaskCategoryCodeCollection.vb`