---
title: SAIF.Business.Tasks database tables
summary: Database tables used by the SAIF.Business.Tasks library with relationships and usage context.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.Tasks
reference_type: package
---

# SAIF.Business.Tasks database tables

This page catalogs database tables accessed by this library.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [TASK](#task) | Oracle | [unqualified]** | C/R/U/D | Core task rows persisted through the task package and queried by the collection criteria. | `clsTask`, `clsTaskCollection` |
| [TASK_ACTION_CODE](#task_action_code) | Oracle | [unqualified]** | R | Lookup of task action codes. | `clsTaskActionCode` |
| [TASK_CATEGORY_CODE](#task_category_code) | Oracle | [unqualified]** | R | Lookup of task categories, defaults, and notepad requirements. | `clsTaskCategoryCode` |
| [TASK_PRIORITY_CODE](#task_priority_code) | Oracle | [unqualified]** | R | Lookup of task priorities. | `clsTaskPriorityCode` |
| [TASK_SOURCE_CODE](#task_source_code) | Oracle | [unqualified]** | R | Lookup of task source systems. | `clsTaskSourceCode` |

## TASK

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Store task rows, task context values, audit columns, and optimistic-concurrency state. |
| **Access pattern** | Both |
| **CRUD operations** | Create, Read, Update, Delete |
| **Key columns used** | `TASK_SEQ_NUM`, `TASK_DATE`, `TASK_TEXT`, `TASK_USER`, `TASK_PRIORITY_CODE`, `TASK_CATEGORY_CODE`, `TASK_SOURCE_CODE`, `TASK_ACTION_CODE`, `DELETE_FLAG`, `CLAIM_ID`, `POLICY_NUM`, `IMAGE_SEQ_NUM`, `CONTEXT_*`, `UPDATE_DATE`, `UPDATE_SEQ_NUM`, `UPDATE_USER`, `TASK_SECURITY` |
| **Sequence** | `TASK_SEQ` |
| **Related tables** | `TASK_ACTION_CODE`, `TASK_CATEGORY_CODE`, `TASK_PRIORITY_CODE`, `TASK_SOURCE_CODE` |
| **Business objects** | `clsTask`, `clsTaskCollection` |

### Operations referencing this table
- [Task record lifecycle](operations/task-record-lifecycle.md)
- [Task collection retrieval](operations/task-collection-retrieval.md)
- [Purge deleted tasks](operations/task-purge.md)

### Business rules referencing this table
- [BR-008](business-rules.md#br-008-task-insert-must-affect-one-row): Task insert must affect one row
- [BR-009](business-rules.md#br-009-task-update-requires-a-current-row-version): Task update requires a current row version
- [BR-010](business-rules.md#br-010-task-delete-requires-a-current-row-version): Task delete requires a current row version

### SQL referencing this table
- [SQL-001: Task insert](sql/SQL-001-task-insert.md)
- [SQL-002: Task select](sql/SQL-002-task-select.md)
- [SQL-008: Task filtered collection select](sql/SQL-008-task-filtered-collection-select.md)
- [SQL-013: Task update](sql/SQL-013-task-update.md)
- [SQL-014: Task delete](sql/SQL-014-task-delete.md)
- [SQL-015: Task purge](sql/SQL-015-task-purge.md)

---

## TASK_ACTION_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Store the valid task action-code lookup set. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | `CODE`, `CODE_DESCR` |
| **Sequence** | N/A |
| **Related tables** | `TASK` |
| **Business objects** | `clsTaskActionCode`, `clsTaskActionCodeCollection` |

### Operations referencing this table
- [Task reference code lookups](operations/task-reference-code-lookups.md)

### SQL referencing this table
- [SQL-003: Task action code by code](sql/SQL-003-task-action-code-by-code.md)
- [SQL-004: Task action code list](sql/SQL-004-task-action-code-list.md)

---

## TASK_CATEGORY_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Store task category metadata including source partition, default action/priority codes, and notepad requirements. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | `TASK_SOURCE_CODE`, `CODE`, `DEFAULT_ACTION_CODE`, `DEFAULT_PRIORITY_CODE`, `NOTEPAD_REQUIRED_FLAG`, `CODE_DESCR` |
| **Sequence** | N/A |
| **Related tables** | `TASK`, `TASK_SOURCE_CODE` |
| **Business objects** | `clsTaskCategoryCode`, `clsTaskCategoryCodeCollection`, `clsTaskBusinessRules` |

### Operations referencing this table
- [Task reference code lookups](operations/task-reference-code-lookups.md)
- [Task record lifecycle](operations/task-record-lifecycle.md)

### Business rules referencing this table
- [BR-001](business-rules.md#br-001-valid-source-and-category-combination): Valid source and category combination
- [BR-011](business-rules.md#br-011-category-notepad-requirement-is-surfaced-to-callers): Category notepad requirement is surfaced to callers

### SQL referencing this table
- [SQL-005: Task category combination validation](sql/SQL-005-task-category-code-count.md)
- [SQL-006: Task category code by source and code](sql/SQL-006-task-category-code-by-source-and-code.md)
- [SQL-007: Task category code list by source](sql/SQL-007-task-category-code-list-by-source.md)

---

## TASK_PRIORITY_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Store the task priority-code lookup set. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | `CODE`, `CODE_DESCR` |
| **Sequence** | N/A |
| **Related tables** | `TASK` |
| **Business objects** | `clsTaskPriorityCode`, `clsTaskPriorityCodeCollection` |

### Operations referencing this table
- [Task reference code lookups](operations/task-reference-code-lookups.md)

### SQL referencing this table
- [SQL-009: Task priority code by code](sql/SQL-009-task-priority-code-by-code.md)
- [SQL-010: Task priority code list](sql/SQL-010-task-priority-code-list.md)

---

## TASK_SOURCE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Store the task source-system lookup set. |
| **Access pattern** | Direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | `CODE`, `CODE_DESCR` |
| **Sequence** | N/A |
| **Related tables** | `TASK`, `TASK_CATEGORY_CODE` |
| **Business objects** | `clsTaskSourceCode`, `clsTaskSourceCodeCollection` |

### Operations referencing this table
- [Task reference code lookups](operations/task-reference-code-lookups.md)

### SQL referencing this table
- [SQL-011: Task source code by code](sql/SQL-011-task-source-code-by-code.md)
- [SQL-012: Task source code list](sql/SQL-012-task-source-code-list.md)

---

## Table relationship diagram

The following diagram shows code-level relationships inferred from shared code values and query predicates rather than from confirmed database foreign-key metadata.*

```mermaid
erDiagram
    TASK_SOURCE_CODE ||--o{ TASK_CATEGORY_CODE : "TASK_SOURCE_CODE"
    TASK_SOURCE_CODE ||--o{ TASK : "TASK_SOURCE_CODE"
    TASK_CATEGORY_CODE ||--o{ TASK : "CATEGORY + SOURCE"
    TASK_ACTION_CODE ||--o{ TASK : "TASK_ACTION_CODE"
    TASK_PRIORITY_CODE ||--o{ TASK : "TASK_PRIORITY_CODE"
```

> **Note:** Statements marked with `*` are inferred from code behavior rather than explicit documentation or comments; statements marked with `**` could not be confirmed and should be treated as unknown until verified.

## 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)
- [SQL catalog](sql/index.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`
- `Business\SAIF.Business.Tasks\clsTaskPriorityCode.vb`
- `Business\SAIF.Business.Tasks\clsTaskPriorityCodeCollection.vb`
- `Business\SAIF.Business.Tasks\clsTaskSourceCode.vb`
- `Business\SAIF.Business.Tasks\clsTaskSourceCodeCollection.vb`
- `Business\SAIF.Business.Tasks\app.config`
- `Business\SAIF.Business.Tasks\Web.config`