SAIF.Business.View.Claim database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
CL_CLAIM_COST_CATEGORY_CODE	Oracle	[unqualified]**	R	Stores claim cost category reference codes.	Criteria
CL_CLAIM_RESPONSIBILITY	Oracle	[unqualified]**	R	Stores claim responsibility assignments and related routing metadata.	Criteria
cl_claim_support_order	Oracle	[unqualified]**	R	Stores support-order rows used to determine whether a worker has active support orders.	clsClaimData
CL_CLOSURE_LOCATION_TYPE_CODE	Oracle	[unqualified]**	R	Stores closure-location type reference codes.	Criteria
CL_CLOSURE_TYPE_OF_ORDER_CODE	Oracle	[unqualified]**	R	Stores closure order-type reference codes.	Criteria
cl_cond_compensability_decisn	Oracle	[unqualified]**	R	Stores medical-condition compensability decision history.	Criteria
CL_MCO_STATUS_REASON_CODE	Oracle	[unqualified]**	R	Stores MCO status reason lookup values.	Criteria
cl_medical_condition	Oracle	[unqualified]**	R	Stores claim medical-condition records.	Criteria
CL_ORDER_TYPE_CODE	Oracle	[unqualified]**	R	Stores claim order-type reference codes.	Criteria
CL_PRISON_CODE	Oracle	[unqualified]**	R	Stores prison address and display metadata for claim-related prison lookups.	Criteria
CL_WORK_RELEASE_CODE	Oracle	[unqualified]**	R	Stores work-release reference codes.	Criteria
CL_WORK_STATUS_CODE	Oracle	[unqualified]**	R	Stores work-status reference codes.	Criteria
CLAIM_ACTIVITY_CAT_TYPE_CODE	Oracle	[unqualified]**	R	Stores claim activity category-to-type mappings.	Criteria
CLAIM_ACTIVITY_TYPE_CODE	Oracle	[unqualified]**	R	Stores claim activity type descriptions.	Criteria
claim_decision_code	Oracle	[unqualified]**	R	Stores claim decision descriptions.	Criteria
claim_denial_final_reas_cd	Oracle	[unqualified]**	R	Stores final denial reason descriptions.	Criteria
claim_denial_reason_code	Oracle	[unqualified]**	R	Stores denial reason descriptions.	Criteria
claim_denial_status_code	Oracle	[unqualified]**	R	Stores denial status descriptions.	Criteria
CLAIM_SUPERVISOR	Oracle	[unqualified]**	R	Stores supervisor metadata joined to claim responsibility records.	Criteria
condition_type_code	Oracle	[unqualified]**	R	Stores medical-condition type descriptions.	Criteria
MCO_PLAN	Oracle	[unqualified]**	R	Stores managed care organization plan descriptions resolved from claim data.	clsClaimData
VOCATIONAL_RESP_CODE	Oracle	[unqualified]**	R	Stores vocational responsibility user lookups.	Criteria

CL_CLAIM_COST_CATEGORY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores claim cost category reference codes.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	None identified
Business objects	Criteria

Operations referencing this table

• Reference code retrieval

SQL referencing this table

• SQL-012

---

CL_CLAIM_RESPONSIBILITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores claim responsibility assignments and related routing metadata.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	CLAIM_SUPERVISOR
Business objects	Criteria

Operations referencing this table

• Claim responsibility retrieval

SQL referencing this table

• SQL-013

---

cl_claim_support_order

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores support-order rows used to determine whether a worker has active support orders.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	None identified
Business objects	clsClaimData, may

Operations referencing this table

• Claim summary and detail retrieval

Business rules referencing this table

• BR-002

SQL referencing this table

• SQL-001
• SQL-030

---

CL_CLOSURE_LOCATION_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores closure-location type reference codes.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	None identified
Business objects	Criteria

Operations referencing this table

• Reference code retrieval

SQL referencing this table

• SQL-014
• SQL-015

---

CL_CLOSURE_TYPE_OF_ORDER_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores closure order-type reference codes.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	None identified
Business objects	Criteria

Operations referencing this table

• Reference code retrieval

SQL referencing this table

• SQL-016
• SQL-017

---

cl_cond_compensability_decisn

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores medical-condition compensability decision history.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	cl_medical_condition, claim_decision_code, claim_denial_final_reas_cd, claim_denial_reason_code, claim_denial_status_code
Business objects	Criteria

Operations referencing this table

• Medical condition retrieval

Business rules referencing this table

• BR-004

SQL referencing this table

• SQL-022

---

CL_MCO_STATUS_REASON_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores MCO status reason lookup values.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	None identified
Business objects	Criteria

Operations referencing this table

• Reference code retrieval

SQL referencing this table

• SQL-018
• SQL-019

---

cl_medical_condition

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores claim medical-condition records.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	cl_cond_compensability_decisn, condition_type_code
Business objects	Criteria

Operations referencing this table

• Medical condition retrieval

Business rules referencing this table

• BR-004

SQL referencing this table

• SQL-022

---

CL_ORDER_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores claim order-type reference codes.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	None identified
Business objects	Criteria

Operations referencing this table

• Reference code retrieval

SQL referencing this table

• SQL-020
• SQL-021

---

CL_PRISON_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores prison address and display metadata for claim-related prison lookups.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	None identified
Business objects	Criteria

Operations referencing this table

• Prison code retrieval

Business rules referencing this table

• BR-003

SQL referencing this table

• SQL-010
• SQL-011

---

CL_WORK_RELEASE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores work-release reference codes.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	None identified
Business objects	Criteria

Operations referencing this table

• Reference code retrieval

SQL referencing this table

• SQL-025
• SQL-026

---

CL_WORK_STATUS_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores work-status reference codes.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	None identified
Business objects	Criteria

Operations referencing this table

• Reference code retrieval

SQL referencing this table

• SQL-023
• SQL-024

---

CLAIM_ACTIVITY_CAT_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores claim activity category-to-type mappings.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	CLAIM_ACTIVITY_TYPE_CODE
Business objects	Criteria

Operations referencing this table

• Reference code retrieval

SQL referencing this table

• SQL-028

---

CLAIM_ACTIVITY_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores claim activity type descriptions.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	CLAIM_ACTIVITY_CAT_TYPE_CODE
Business objects	Criteria

Operations referencing this table

• Reference code retrieval

SQL referencing this table

• SQL-028

---

claim_decision_code

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores claim decision descriptions.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	cl_cond_compensability_decisn
Business objects	Criteria

Operations referencing this table

• Medical condition retrieval

SQL referencing this table

• SQL-022

---

claim_denial_final_reas_cd

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores final denial reason descriptions.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	cl_cond_compensability_decisn
Business objects	Criteria

Operations referencing this table

• Medical condition retrieval

SQL referencing this table

• SQL-022

---

claim_denial_reason_code

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores denial reason descriptions.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	cl_cond_compensability_decisn
Business objects	Criteria

Operations referencing this table

• Medical condition retrieval

SQL referencing this table

• SQL-022

---

claim_denial_status_code

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores denial status descriptions.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	cl_cond_compensability_decisn
Business objects	Criteria

Operations referencing this table

• Medical condition retrieval

SQL referencing this table

• SQL-022

---

CLAIM_SUPERVISOR

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores supervisor metadata joined to claim responsibility records.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	CL_CLAIM_RESPONSIBILITY
Business objects	Criteria

Operations referencing this table

• Claim responsibility retrieval

SQL referencing this table

• SQL-013

---

condition_type_code

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores medical-condition type descriptions.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	cl_medical_condition
Business objects	Criteria

Operations referencing this table

• Medical condition retrieval

SQL referencing this table

• SQL-022

---

MCO_PLAN

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores managed care organization plan descriptions resolved from claim data.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	None identified
Business objects	clsClaimData, may

Operations referencing this table

• Claim summary and detail retrieval

SQL referencing this table

• SQL-002
• SQL-031

---

VOCATIONAL_RESP_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Stores vocational responsibility user lookups.
Access pattern	direct SQL
CRUD operations	R
Key columns used	Derived from inline SQL where visible; see linked SQL pages for column-level detail.*
Sequence	N/A
Related tables	None identified
Business objects	Criteria

Operations referencing this table

• Reference code retrieval

SQL referencing this table

• SQL-027

---

Table relationship diagram

The following diagram shows the cross-table relationships explicitly visible in this library's SQL.

erDiagram
    cl_medical_condition ||--o{ cl_cond_compensability_decisn : "claim_id + medical_condition_id"
    cl_medical_condition }o--|| condition_type_code : "condition_type_code"
    cl_cond_compensability_decisn }o--|| claim_decision_code : "decision code"
    cl_cond_compensability_decisn }o--|| claim_denial_final_reas_cd : "final denial reason"
    cl_cond_compensability_decisn }o--|| claim_denial_reason_code : "denial reason"
    cl_cond_compensability_decisn }o--|| claim_denial_status_code : "denial status"
    CL_CLAIM_RESPONSIBILITY }o--|| CLAIM_SUPERVISOR : "claim_supervisor_code"
    CLAIM_ACTIVITY_CAT_TYPE_CODE }o--|| CLAIM_ACTIVITY_TYPE_CODE : "type_code"

Related documentation

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

Note: Statements marked with * were inferred from code structure or contextual evidence. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.View.Claim\clsClaimActivityTypeCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsClaimCostCategoryCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsClaimData.vb
• Business\SAIF.Business.View.Claim\clsClaimResponsibilityData.vb
• Business\SAIF.Business.View.Claim\clsClosureLocationTypeCode.vb
• Business\SAIF.Business.View.Claim\clsClosureLocationTypeCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsClosureTypeOfOrderCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsClosureTypeofOrderCode.vb
• Business\SAIF.Business.View.Claim\clsMcoStatusReasonCode.vb
• Business\SAIF.Business.View.Claim\clsMcoStatusReasonCodeTable.vb
• Business\SAIF.Business.View.Claim\clsMedicalConditionData.vb
• Business\SAIF.Business.View.Claim\clsOrderTypeCode.vb
• Business\SAIF.Business.View.Claim\clsOrderTypeCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsPrisonCode.vb
• Business\SAIF.Business.View.Claim\clsPrisonCodeCollection.vb
• Business\SAIF.Business.View.Claim\clsVocResponsibilityData.vb
• Business\SAIF.Business.View.Claim\clsWorkReleaseCode.vb
• Business\SAIF.Business.View.Claim\clsWorkReleaseCodeTable.vb
• Business\SAIF.Business.View.Claim\clsWorkStatusCode.vb
• Business\SAIF.Business.View.Claim\clsWorkStatusCodeTable.vb