SAIF.Business.Claim.SupportOrder database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
CL_CLAIM_SUPPORT_ORDER	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
CL_CLAIM_SUPPORT_ORDER_CONN	Oracle	[unqualified]**	C, D, R	Supports Criteria data access in this library.	Criteria

CL_CLAIM_SUPPORT_ORDER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Direct SQL
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	Criteria

Operations referencing this table

• Support order retrieval and maintenance

Business rules referencing this table

• BR-001: Support-order updates require a current row version
• BR-002: Support-order inserts and updates must affect one row

SQL referencing this table

• SQL-001: Insert into CL_CLAIM_SUPPORT_ORDER ( ALL_CLAIM_FLAG, ARREARAGE_FLAG, D
• SQL-003: Select CL_CLAIM_SUPPORT_ORDER.ALL_CLAIM_FLAG as AllClaimFlag, CL_CLAIM
• SQL-004: Select CL_CLAIM_SUPPORT_ORDER.ALL_CLAIM_FLAG as AllClaimFlag, CL_CLAIM
• SQL-006: Update CL_CLAIM_SUPPORT_ORDER Set ALL_CLAIM_FLAG = :AllClaimFlag, ARRE
• SQL-007: Delete CL_CLAIM_SUPPORT_ORDER Where CL_CLAIM_SUPPORT_ORDER.WORKER_ID =

---

CL_CLAIM_SUPPORT_ORDER_CONN

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Direct SQL
CRUD operations	C, D, R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	Criteria

Operations referencing this table

• Support order connection management

Business rules referencing this table

• BR-003: Connection deletes must affect one row
• BR-004: Connection inserts must affect one row

SQL referencing this table

• SQL-002: Insert into CL_CLAIM_SUPPORT_ORDER_CONN ( CLAIM_ID, SUPPORT_ORDER_ID,
• SQL-005: Select CL_CLAIM_SUPPORT_ORDER_CONN.CLAIM_ID as ClaimID, CL_CLAIM_SUPPO
• SQL-008: Delete CL_CLAIM_SUPPORT_ORDER_CONN Where CL_CLAIM_SUPPORT_ORDER_CONN.C

---

Table relationship diagram

The following diagram shows relationships between tables used by this library.

erDiagram
    CL_CLAIM_SUPPORT_ORDER ||--o{ CL_CLAIM_SUPPORT_ORDER_CONN : "SUPPORT_ORDER_ID"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• API reference

Note: Statements marked with * were inferred from code structure or contextual evidence.

Sources

• Business\SAIF.Business.Claim.SupportOrder\clsClaimSupportOrder.vb
• Business\SAIF.Business.Claim.SupportOrder\clsClaimSupportOrderCollection.vb
• Business\SAIF.Business.Claim.SupportOrder\clsClaimSupportOrderConnection.vb
• Business\SAIF.Business.Claim.SupportOrder\clsClaimSupportOrderConnectionCollection.vb