SAIF.Business.Tasks.Claim database tables¶
This page catalogs database tables accessed by this library.
Table catalog¶
| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
|---|---|---|---|---|---|
| LEGACY_TASK_CODE | Oracle | [unqualified]** |
R | Task templating reference data | clsLegacyTaskCodeCollection |
LEGACY_TASK_CODE¶
| Field | Value |
|---|---|
| Database | Oracle |
| Schema/Link | [unqualified]** — no owner prefix appears in the SQL, and the connecting Oracle user is supplied at runtime by the caller through IDataPortalInfo, so the owning schema cannot be resolved from this repository.** |
| Purpose | Task templating reference data — date offsets, notepad flag, category code, and text used when generating legacy-style tasks. |
| Access pattern | Direct inline SQL |
| CRUD operations | Read |
| Key columns used | CREATE_DATE, CREATE_USER, DATE_DAYS_NUM, LEGACY_TASK_CODE, NOTEPAD_FLAG, TASK_CATEGORY_CODE, TEXT_DAYS_NUM, TASK_TEXT, UPDATE_DATE, UPDATE_USER, USE_RUNDATE_FLAG |
| Sequence | N/A |
| Related tables | None discoverable — the query is an unjoined SELECT *.* |
| Business objects | clsLegacyTaskCode, clsLegacyTaskCodeCollection |
Operations referencing this table¶
Business rules referencing this table¶
SQL referencing this table¶
Table relationship diagram¶
No cross-table relationships were identified in this library's SQL. There is exactly one addressable table (LEGACY_TASK_CODE), accessed by a single unjoined SELECT *; no JOIN clause, subquery, or multi-table statement exists in any scanned file.* Candidate cross-library linkage (not evidenced by SQL here): LEGACY_TASK_CODE.TASK_CATEGORY_CODE appears to correspond to the task category code domain consumed via clsTaskCategoryCodeCollection, and LEGACY_TASK_CODE.LEGACY_TASK_CODE is the natural key used by clsLegacyTaskCodeCollection.Item(String).**
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- SQL catalog
- Security and authorization
- API reference
Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.
Sources¶
- SAIF.Business.Tasks.Claim/clsLegacyTaskCodeCollection.vb
- SAIF.Business.Tasks.Claim/clsLegacyTaskCode.vb