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	Task insert	Stored Proc	TASK	clsTask

Read operations

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

| SQL-009 | Task priority code by code | Inline | TASK_PRIORITY_CODE | clsTaskPriorityCode | | SQL-010 | Task priority code list | Inline | TASK_PRIORITY_CODE | clsTaskPriorityCodeCollection | | SQL-011 | Task source code by code | Inline | TASK_SOURCE_CODE | clsTaskSourceCode | | SQL-012 | Task source code list | Inline | TASK_SOURCE_CODE | clsTaskSourceCodeCollection |

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-013	Task update	Stored Proc	TASK	clsTask

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-014	Task delete	Stored Proc	TASK	clsTask
SQL-015	Task purge	Stored Proc	TASK	clsTaskCollection

Related documentation

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

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