---
title: SAIF.Business.View.Claim SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-28
library: SAIF.Business.View.Claim
reference_type: package
---

# SAIF.Business.View.Claim SQL catalog

This page indexes all SQL statements and stored procedure calls used by this library.

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001.md) | Count active support orders | Inline | [cl_claim_support_order](../database-tables.md#cl-claim-support-order) | `clsClaimData` |
| [SQL-002](SQL-002.md) | Retrieve MCO short description | Inline | [MCO_PLAN](../database-tables.md#mco-plan) | `clsClaimData` |
| [SQL-003](SQL-003.md) | Read via sp83411_Calc_Total_Paid | StoredProc | Stored procedure-owned tables not available | `clsClaimData` |
| [SQL-004](SQL-004.md) | Read via pk83407_payment_hist_trans.getPayRemarks | StoredProc | Stored procedure-owned tables not available | `clsFinancialTransaction` |
| [SQL-005](SQL-005.md) | Read via pk83407_payment_hist_trans.getPayRemarks | StoredProc | Stored procedure-owned tables not available | `clsFinancialTransaction` |
| [SQL-006](SQL-006.md) | Read via pk82281_claim_note.select_by_claimnum | StoredProc | Stored procedure-owned tables not available | `Criteria` |
| [SQL-007](SQL-007.md) | Read via pk83407_payment_hist_trans.SelectFinTranByClaimId | StoredProc | Stored procedure-owned tables not available | `Criteria` |
| [SQL-008](SQL-008.md) | Read via pk83407_payment_hist_trans.SelectFinTranByPolicyNum | StoredProc | Stored procedure-owned tables not available | `Criteria` |
| [SQL-009](SQL-009.md) | Read via pk83407_payment_hist_trans.SelectReimbFinTranByIssueDate | StoredProc | Stored procedure-owned tables not available | `Criteria` |
| [SQL-010](SQL-010.md) | Retrieve prison-code list with blank option | Inline | [CL_PRISON_CODE](../database-tables.md#cl-prison-code) | `Criteria` |
| [SQL-011](SQL-011.md) | Retrieve prison-code list with blank option | Inline | [CL_PRISON_CODE](../database-tables.md#cl-prison-code) | `Criteria` |
| [SQL-012](SQL-012.md) | Read CL_CLAIM_COST_CATEGORY_CODE | Inline | [CL_CLAIM_COST_CATEGORY_CODE](../database-tables.md#cl-claim-cost-category-code) | `Criteria` |
| [SQL-013](SQL-013.md) | Read CL_CLAIM_RESPONSIBILITY | Inline | [CL_CLAIM_RESPONSIBILITY](../database-tables.md#cl-claim-responsibility) | `Criteria` |
| [SQL-014](SQL-014.md) | Read CL_CLOSURE_LOCATION_TYPE_CODE | Inline | [CL_CLOSURE_LOCATION_TYPE_CODE](../database-tables.md#cl-closure-location-type-code) | `Criteria` |
| [SQL-015](SQL-015.md) | Read CL_CLOSURE_LOCATION_TYPE_CODE | Inline | [CL_CLOSURE_LOCATION_TYPE_CODE](../database-tables.md#cl-closure-location-type-code) | `Criteria` |
| [SQL-016](SQL-016.md) | Read CL_CLOSURE_TYPE_OF_ORDER_CODE | Inline | [CL_CLOSURE_TYPE_OF_ORDER_CODE](../database-tables.md#cl-closure-type-of-order-code) | `Criteria` |
| [SQL-017](SQL-017.md) | Read CL_CLOSURE_TYPE_OF_ORDER_CODE | Inline | [CL_CLOSURE_TYPE_OF_ORDER_CODE](../database-tables.md#cl-closure-type-of-order-code) | `Criteria` |
| [SQL-018](SQL-018.md) | Read CL_MCO_STATUS_REASON_CODE | Inline | [CL_MCO_STATUS_REASON_CODE](../database-tables.md#cl-mco-status-reason-code) | `Criteria` |
| [SQL-019](SQL-019.md) | Read CL_MCO_STATUS_REASON_CODE | Inline | [CL_MCO_STATUS_REASON_CODE](../database-tables.md#cl-mco-status-reason-code) | `Criteria` |
| [SQL-020](SQL-020.md) | Read CL_ORDER_TYPE_CODE | Inline | [CL_ORDER_TYPE_CODE](../database-tables.md#cl-order-type-code) | `Criteria` |
| [SQL-021](SQL-021.md) | Read CL_ORDER_TYPE_CODE | Inline | [CL_ORDER_TYPE_CODE](../database-tables.md#cl-order-type-code) | `Criteria` |
| [SQL-022](SQL-022.md) | Retrieve medical condition detail with latest decision | Inline | [cl_medical_condition](../database-tables.md#cl-medical-condition), [cl_cond_compensability_decisn](../database-tables.md#cl-cond-compensability-decisn), [condition_type_code](../database-tables.md#condition-type-code), [claim_decision_code](../database-tables.md#claim-decision-code), [claim_denial_final_reas_cd](../database-tables.md#claim-denial-final-reas-cd), [claim_denial_reason_code](../database-tables.md#claim-denial-reason-code), [claim_denial_status_code](../database-tables.md#claim-denial-status-code) | `Criteria` |
| [SQL-023](SQL-023.md) | Read CL_WORK_STATUS_CODE | Inline | [CL_WORK_STATUS_CODE](../database-tables.md#cl-work-status-code) | `Criteria` |
| [SQL-024](SQL-024.md) | Read CL_WORK_STATUS_CODE | Inline | [CL_WORK_STATUS_CODE](../database-tables.md#cl-work-status-code) | `Criteria` |
| [SQL-025](SQL-025.md) | Read CL_WORK_RELEASE_CODE | Inline | [CL_WORK_RELEASE_CODE](../database-tables.md#cl-work-release-code) | `Criteria` |
| [SQL-026](SQL-026.md) | Read CL_WORK_RELEASE_CODE | Inline | [CL_WORK_RELEASE_CODE](../database-tables.md#cl-work-release-code) | `Criteria` |
| [SQL-027](SQL-027.md) | Read VOCATIONAL_RESP_CODE | Inline | [VOCATIONAL_RESP_CODE](../database-tables.md#vocational-resp-code) | `Criteria` |
| [SQL-028](SQL-028.md) | Read CLAIM_ACTIVITY_CAT_TYPE_CODE | Inline | [CLAIM_ACTIVITY_CAT_TYPE_CODE](../database-tables.md#claim-activity-cat-type-code) | `Criteria` |
| [SQL-029](SQL-029.md) | Read via sp83411_Calc_Total_Paid | StoredProc | Stored procedure-owned tables not available | `Criteria` |
| [SQL-030](SQL-030.md) | Count active support orders | Inline | [cl_claim_support_order](../database-tables.md#cl-claim-support-order) | `may` |
| [SQL-031](SQL-031.md) | Retrieve MCO short description | Inline | [MCO_PLAN](../database-tables.md#mco-plan) | `may` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [Procedures](../procedures/index.md)
- [API reference](../api/index.md)

> **Note:** Statements marked with `**` could not be confirmed; treat as unknown until verified.

## Sources
- `Business\SAIF.Business.View.Claim\clsClaimData.vb`
- `Business\SAIF.Business.View.Claim\clsClaimData.vb`
- `Business\SAIF.Business.View.Claim\clsClaimData.vb`
- `Business\SAIF.Business.View.Claim\clsFinancialTransaction.vb`
- `Business\SAIF.Business.View.Claim\clsFinancialTransaction.vb`
- `Business\SAIF.Business.View.Claim\clsClaimNoteData.vb`
- `Business\SAIF.Business.View.Claim\clsFinancialTransactionCollection.vb`
- `Business\SAIF.Business.View.Claim\clsFinancialTransactionCollection.vb`
- `Business\SAIF.Business.View.Claim\clsFinancialTransactionCollection.vb`
- `Business\SAIF.Business.View.Claim\clsPrisonCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsPrisonCode.vb`
- `Business\SAIF.Business.View.Claim\clsClaimCostCategoryCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsClaimResponsibilityData.vb`
- `Business\SAIF.Business.View.Claim\clsClosureLocationTypeCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsClosureLocationTypeCode.vb`
- `Business\SAIF.Business.View.Claim\clsClosureTypeOfOrderCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsClosureTypeofOrderCode.vb`
- `Business\SAIF.Business.View.Claim\clsMcoStatusReasonCodeTable.vb`
- `Business\SAIF.Business.View.Claim\clsMcoStatusReasonCode.vb`
- `Business\SAIF.Business.View.Claim\clsOrderTypeCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsOrderTypeCode.vb`
- `Business\SAIF.Business.View.Claim\clsMedicalConditionData.vb`
- `Business\SAIF.Business.View.Claim\clsWorkStatusCodeTable.vb`
- `Business\SAIF.Business.View.Claim\clsWorkStatusCode.vb`
- `Business\SAIF.Business.View.Claim\clsWorkReleaseCodeTable.vb`
- `Business\SAIF.Business.View.Claim\clsWorkReleaseCode.vb`
- `Business\SAIF.Business.View.Claim\clsVocResponsibilityData.vb`
- `Business\SAIF.Business.View.Claim\clsClaimActivityTypeCodeCollection.vb`
- `Business\SAIF.Business.View.Claim\clsClaimData.vb`
- `Business\SAIF.Business.View.Claim\clsClaimData.vb`
- `Business\SAIF.Business.View.Claim\clsClaimData.vb`