SQL-006 Select a single task category code¶

Retrieves one TASK_CATEGORY_CODE reference row, scoped by both CODE and the owning TASK_SOURCE_CODE.

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` / `AfterRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	String	5	`TASK_CATEGORY_CODE.CODE` to retrieve
`:TaskSourceCode`	Input	String	5	Owning source system code

Tables¶

Table	Access	Columns used
TASK_CATEGORY_CODE	SELECT	`CODE`, `DEFAULT_ACTION_CODE`, `DEFAULT_PRIORITY_CODE`, `CODE_DESCR`, `NOTEPAD_REQUIRED_FLAG`, `TASK_SOURCE_CODE`

Sample 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

NVL(expr, ' ') substitutes a single blank when the default action/priority code is null.

Operations and processes¶

Load a code table

Business rules¶

BR-023: Code tables are read-only reference data

Sources¶

SAIF.Business.Tasks/clsTaskCategoryCode.vb