---
title: "SQL-006: Task category code by source and code"
summary: Reads one category lookup row within a source-system partition.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.Tasks
reference_type: package
---

# SQL-006: Task category code by source and code

Reads one category lookup row within a source-system partition.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-006 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | `[unqualified]**` |
| **Command type** | Text |
| **Business object** | `clsTaskCategoryCode` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:Code` | Input | String | 5 | Requested category code. |
| `:TaskSourceCode` | Input | String | 5 | Source-system partition. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [TASK_CATEGORY_CODE](../database-tables.md#task_category_code) | SELECT | CODE, DEFAULT_ACTION_CODE, DEFAULT_PRIORITY_CODE, CODE_DESCR, NOTEPAD_REQUIRED_FLAG, TASK_SOURCE_CODE |

## Sample SQL

```sql
SELECT TASK_CATEGORY_CODE.CODE AS Code
     , NVL(TASK_CATEGORY_CODE.DEFAULT_ACTION_CODE,' ' ) AS DefaultActionCode
     , NVL(TASK_CATEGORY_CODE.DEFAULT_PRIORITY_CODE,' ' ) AS DefaultPriorityCode
     , TASK_CATEGORY_CODE.CODE_DESCR AS Description
     , TASK_CATEGORY_CODE.NOTEPAD_REQUIRED_FLAG AS NotepadRequiredFlag
     , TASK_CATEGORY_CODE.TASK_SOURCE_CODE AS TaskSourceCode
FROM TASK_CATEGORY_CODE
WHERE TASK_CATEGORY_CODE.CODE = :Code
  AND TASK_CATEGORY_CODE.TASK_SOURCE_CODE = :TaskSourceCode
```

## Operations and processes
- [Task reference code lookups](../operations/task-reference-code-lookups.md)

## Business rules
- [BR-011](../business-rules.md#br-011-category-notepad-requirement-is-surfaced-to-callers)

> **Note:** Statements marked with ** could not be confirmed; treat as unknown until verified.

## Sources
- `Business\SAIF.Business.Tasks\clsTaskCategoryCode.vb`