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	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	Oracle	[unqualified]**	R	Lookup of task action codes.	clsTaskActionCode
TASK_CATEGORY_CODE	Oracle	[unqualified]**	R	Lookup of task categories, defaults, and notepad requirements.	clsTaskCategoryCode
TASK_PRIORITY_CODE	Oracle	[unqualified]**	R	Lookup of task priorities.	clsTaskPriorityCode
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
• Task collection retrieval
• Purge deleted tasks

Business rules referencing this table

• BR-008: Task insert must affect one row
• BR-009: Task update requires a current row version
• BR-010: Task delete requires a current row version

SQL referencing this table

• SQL-001: Task insert
• SQL-002: Task select
• SQL-008: Task filtered collection select
• SQL-013: Task update
• SQL-014: Task delete
• SQL-015: Task purge

---

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

SQL referencing this table

• SQL-003: Task action code by code
• SQL-004: Task action code list

---

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
• Task record lifecycle

Business rules referencing this table

• BR-001: Valid source and category combination
• BR-011: Category notepad requirement is surfaced to callers

SQL referencing this table

• SQL-005: Task category combination validation
• SQL-006: Task category code by source and code
• SQL-007: Task category code list by source

---

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

SQL referencing this table

• SQL-009: Task priority code by code
• SQL-010: Task priority code list

---

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

SQL referencing this table

• SQL-011: Task source code by code
• SQL-012: Task source code list

---

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.*

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
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• 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
• 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