---
title: "SQL catalog"
summary: Index of all SQL statements used by SAIF.Data, grouped by operation type
status: draft
owner: SAIF.Core documentation team
last_reviewed: 2026-09-24
library: SAIF.Data
reference_type: package
---

# SAIF.Data SQL catalog

This page indexes all 307 ORM-generated data access operations in this library, grouped by CRUD type. This library is 100% NHibernate ORM; there is no raw SQL text or stored procedures**, so every statement's page separates the verbatim C# ORM/LINQ expression, in its `## LINQ statement` section, from the inferred SQL fabricated from that expression and the NHibernate mappings, in its `## Sample SQL` section — the inferred SQL is not concrete SQL captured from source.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-241](SQL-241-claim-builder-claim-type.md) | Claim type | ORM (IRepository.Add) | `CL_CLAIM_TYPE_ACTIVITY` | `ClaimBuilder` |
| [SQL-242](SQL-242-claim-builder-claim-status.md) | Claim status | ORM (IRepository.Add) | `CL_CLAIM_STATUS_ACTIVITY` | `ClaimBuilder` |
| [SQL-243](SQL-243-claim-builder-policy.md) | Policy | ORM (IRepository.Add) | `POLICY` | `ClaimBuilder` |
| [SQL-244](SQL-244-claim-code-table-builder-claim-responsibility.md) | Claim responsibility | ORM (IRepository.Add) | `CL_CLAIM_RESPONSIBILITY` | `ClaimCodeTableBuilder` |
| [SQL-245](SQL-245-online-support-extensions-seed-for-online-support.md) | Seed for online support | ORM (IRepository.Add) | `ERROR_GROUP_ENVIRONMENT` | `OnlineSupportExtensions` |
| [SQL-246](SQL-246-policy-extensions-generate-agencies.md) | Generate agencies | ORM (IRepository.Add) | `Agency` | `PolicyExtensions` |
| [SQL-247](SQL-247-policy-extensions-generate-agencies.md) | Generate agencies | ORM (IRepository.Add) | `Agent` | `PolicyExtensions` |
| [SQL-248](SQL-248-policy-extensions-generate-default-policies.md) | Generate default policies | ORM (IRepository.Add) | `POLICY_TEAM_FUNCTION` | `PolicyExtensions` |
| [SQL-249](SQL-249-policy-extensions-generate-default-policies.md) | Generate default policies | ORM (IRepository.Add) | `POLICY` | `PolicyExtensions` |
| [SQL-250](SQL-250-policy-extensions-generate-relationship-policies.md) | Generate relationship policies | ORM (IRepository.Add) | `POLICY` | `PolicyExtensions` |
| [SQL-251](SQL-251-policy-output-document-extensions-seed-for-document-testing.md) | Seed for document testing | ORM (IRepository.Add) | `batch_process_log` | `PolicyOutputDocumentExtensions` |
| [SQL-252](SQL-252-policy-output-document-extensions-add-document.md) | Add document | ORM (IRepository.Add) | `output_document` | `PolicyOutputDocumentExtensions` |
| [SQL-253](SQL-253-policy-output-document-extensions-add-document.md) | Add document | ORM (IRepository.Add) | `policy_output_document` | `PolicyOutputDocumentExtensions` |
| [SQL-254](SQL-254-task-extensions-fill-task-category.md) | Fill task category | ORM (IRepository.Add) | `TASK_CATEGORY_CODE` | `TaskExtensions` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-address-verification-query-provider-get-location-verification-requests.md) | Get location verification requests | LINQ (inferred SQL) | `LOCATION_VERIFICATION_REQUEST`, `ADDRESS_VERIFICATION_REQUEST` | `AddressVerificationQueryProvider` |
| [SQL-002](SQL-002-address-verification-query-provider-get-address-verification-requests.md) | Get address verification requests | LINQ (inferred SQL) | `ADDRESS_VERIFICATION_REQUEST` | `AddressVerificationQueryProvider` |
| [SQL-003](SQL-003-address-verification-query-provider-get-verified-address.md) | Get verified address | LINQ (inferred SQL) | `VERIFIED_ADDRESS` | `AddressVerificationQueryProvider` |
| [SQL-004](SQL-004-audit-note-query-provider-get-audit-note.md) | Get audit note | LINQ (inferred SQL) | `CBP_NOTE` | `AuditNoteQueryProvider` |
| [SQL-005](SQL-005-audit-note-query-provider-get-audit-notes-for-claim.md) | Get audit notes for claim | LINQ (inferred SQL) | `CBP_NOTE` | `AuditNoteQueryProvider` |
| [SQL-006](SQL-006-audit-note-query-provider-get-audit-notes-for-bill.md) | Get audit notes for bill | LINQ (inferred SQL) | `CBP_NOTE` | `AuditNoteQueryProvider` |
| [SQL-007](SQL-007-audit-note-query-provider-get-all-audit-notes.md) | Get all audit notes | LINQ (inferred SQL) | `CBP_NOTE` | `AuditNoteQueryProvider` |
| [SQL-008](SQL-008-audit-note-query-provider-get-note-type-code.md) | Get note type code | LINQ (inferred SQL) | `CBP_NOTE_TYPE_CODE` | `AuditNoteQueryProvider` |
| [SQL-009](SQL-009-audit-note-query-provider-get-note-categories.md) | Get note categories | LINQ (inferred SQL) | `CBP_NOTE_CATEGORY_CODE` | `AuditNoteQueryProvider` |
| [SQL-010](SQL-010-audit-note-query-provider-get-note-types.md) | Get note types | LINQ (inferred SQL) | `CBP_NOTE_TYPE_CODE` | `AuditNoteQueryProvider` |
| [SQL-011](SQL-011-audit-note-query-provider-get-note-types-for-category.md) | Get note types for category | LINQ (inferred SQL) | `CBP_NOTE_TYPE_CODE` | `AuditNoteQueryProvider` |
| [SQL-012](SQL-012-audit-note-query-provider-is-audit-note-no-contention.md) | Is audit note no contention | LINQ (inferred SQL) | `CBP_NOTE` | `AuditNoteQueryProvider` |
| [SQL-013](SQL-013-audit-query-provider-get-audit.md) | Get audit | LINQ (inferred SQL) | `CBP_AUDIT` | `AuditQueryProvider` |
| [SQL-014](SQL-014-audit-query-provider-get-audit-for-bill.md) | Get audit for bill | LINQ (inferred SQL) | `CBP_AUDIT` | `AuditQueryProvider` |
| [SQL-015](SQL-015-audit-query-provider-get-national-drug-code.md) | Get national drug code | LINQ (inferred SQL) | `CBP_NATIONAL_DRUG` | `AuditQueryProvider` |
| [SQL-016](SQL-016-audit-query-provider-is-nurse-review-required.md) | Is nurse review required | LINQ (inferred SQL) | `CBP_SERVICE_CODE` | `AuditQueryProvider` |
| [SQL-017](SQL-017-audit-query-provider-is-nurse-review-required.md) | Is nurse review required | LINQ (inferred SQL) | `CBP_AUDITED_SERVICE`, `CBP_AUDIT` | `AuditQueryProvider` |
| [SQL-018](SQL-018-audit-query-provider-get-non-duplicate-service-count.md) | Get non duplicate service count | LINQ (inferred SQL) | `CBP_AUDITED_SERVICE`, `CBP_AUDIT` | `AuditQueryProvider` |
| [SQL-019](SQL-019-audit-query-provider-get-services.md) | Get services | LINQ (inferred SQL) | `CBP_AUDITED_SERVICE`, `CBP_AUDIT`, `CBP_BILL` | `AuditQueryProvider` |
| [SQL-020](SQL-020-audit-query-provider-get-original-bills.md) | Get original bills | LINQ (inferred SQL) | `CBP_AUDITED_SERVICE`, `CBP_AUDIT` | `AuditQueryProvider` |
| [SQL-021](SQL-021-audit-query-provider-get-physical-medicine-count.md) | Get physical medicine count | LINQ (inferred SQL) | `CBP_AUDITED_SERVICE`, `CBP_BILL`, `CBP_SERVICE_PHYSICAL_MEDICINE` | `AuditQueryProvider` |
| [SQL-022](SQL-022-audit-query-provider-get-physical-medicine-count.md) | Get physical medicine count | LINQ (inferred SQL) | `CBP_SERVICE_PHYSICAL_MEDICINE`, `CBP_AUDITED_SERVICE`, `CBP_BILL` | `AuditQueryProvider` |
| [SQL-023](SQL-023-audit-query-provider-get-adjustment-type.md) | Get adjustment type | LINQ (inferred SQL) | `CBP_AUDIT_ADJUSTMENT_TYPE` | `AuditQueryProvider` |
| [SQL-024](SQL-024-bill-query-provider-bill-exists.md) | Bill exists | LINQ (inferred SQL) | `CBP_BILL` | `BillQueryProvider` |
| [SQL-025](SQL-025-bill-query-provider-get-bill.md) | Get bill | LINQ (inferred SQL) | `CBP_BILL` | `BillQueryProvider` |
| [SQL-026](SQL-026-bill-query-provider-get-bills-for-claim.md) | Get bills for claim | LINQ (inferred SQL) | `CBP_BILL` | `BillQueryProvider` |
| [SQL-027](SQL-027-bill-query-provider-get-bill-ids-for-claim.md) | Get bill ids for claim | LINQ (inferred SQL) | `CBP_BILL` | `BillQueryProvider` |
| [SQL-028](SQL-028-bill-query-provider-get-bill-types.md) | Get bill types | LINQ (inferred SQL) | `CBP_BILL_TYPE_CODE` | `BillQueryProvider` |
| [SQL-029](SQL-029-bill-query-provider-get-bill-status-code.md) | Get bill status code | LINQ (inferred SQL) | `CBP_BILL_STATUS_CODE` | `BillQueryProvider` |
| [SQL-030](SQL-030-bill-query-provider-get-bill-status-history.md) | Get bill status history | LINQ (inferred SQL) | `CBP_BILL_STATUS` | `BillQueryProvider` |
| [SQL-031](SQL-031-bill-query-provider-get-regenerated-bill-entry-source-code.md) | Get regenerated bill entry source code | LINQ (inferred SQL) | `CBP_BILL_ENTRY_SOURCE_CODE` | `BillQueryProvider` |
| [SQL-032](SQL-032-bill-query-provider-get-bill-amounts.md) | Get bill amounts | LINQ (inferred SQL) | `CBP_BILL`, `CBP_AUDITED_SERVICE`, `CBP_AUDIT` | `BillQueryProvider` |
| [SQL-033](SQL-033-bill-query-provider-get-bill-amounts.md) | Get bill amounts | LINQ (inferred SQL) | `CBP_BILL`, `CBP_AUDITED_SERVICE`, `CBP_AUDIT` | `BillQueryProvider` |
| [SQL-034](SQL-034-bill-query-provider-get-stripped-cbp-diagnosis.md) | Get stripped cbp diagnosis | LINQ (inferred SQL) | `CBP_DIAGNOSIS` | `BillQueryProvider` |
| [SQL-035](SQL-035-bill-query-provider-get-cbp-diagnosis.md) | Get cbp diagnosis | LINQ (inferred SQL) | `CBP_DIAGNOSIS` | `BillQueryProvider` |
| [SQL-036](SQL-036-bill-query-provider-get-cbp-diagnosis-type-code.md) | Get cbp diagnosis type code | LINQ (inferred SQL) | `CBP_DIAGNOSIS_TYPE_CODE` | `BillQueryProvider` |
| [SQL-037](SQL-037-bill-query-provider-get-ebill-entry-source-code.md) | Get ebill entry source code | LINQ (inferred SQL) | `CBP_BILL_ENTRY_SOURCE_CODE` | `BillQueryProvider` |
| [SQL-038](SQL-038-bill-query-provider-get-cbp-bill-type-code.md) | Get cbp bill type code | LINQ (inferred SQL) | `CBP_BILL_TYPE_CODE` | `BillQueryProvider` |
| [SQL-039](SQL-039-bill-query-provider-get-cbp-service-code-not-expired.md) | Get cbp service code not expired | LINQ (inferred SQL) | `CBP_SERVICE_CODE` | `BillQueryProvider` |
| [SQL-040](SQL-040-bill-query-provider-get-cbp-service-code-expired.md) | Get cbp service code expired | LINQ (inferred SQL) | `CBP_SERVICE_CODE` | `BillQueryProvider` |
| [SQL-041](SQL-041-bill-query-provider-get-cbp-service-zcode.md) | Get cbp service z code | LINQ (inferred SQL) | `CBP_SERVICE_CODE` | `BillQueryProvider` |
| [SQL-042](SQL-042-bill-query-provider-get-cbp-service-zdec-description.md) | Get cbp service z dec description | LINQ (inferred SQL) | `CBP_SERVICE_DESCRIPTION` | `BillQueryProvider` |
| [SQL-043](SQL-043-bill-query-provider-get-cbp-service-zdec-description-stateless.md) | Get cbp service z dec description stateless | LINQ (inferred SQL) | `CBP_SERVICE_DESCRIPTION` | `BillQueryProvider` |
| [SQL-044](SQL-044-bill-query-provider-get-bill-service-type-code.md) | Get bill service type code | LINQ (inferred SQL) | `CBP_SERVICE_TYPE_CODE` | `BillQueryProvider` |
| [SQL-045](SQL-045-bill-query-provider-get-bill-service-code.md) | Get bill service code | LINQ (inferred SQL) | `CBP_SERVICE_CODE` | `BillQueryProvider` |
| [SQL-046](SQL-046-bill-query-provider-get-bill-service-code-stateless.md) | Get bill service code stateless | LINQ (inferred SQL) | `CBP_SERVICE_CODE` | `BillQueryProvider` |
| [SQL-047](SQL-047-bill-query-provider-get-national-drug.md) | Get national drug | LINQ (inferred SQL) | `CBP_NATIONAL_DRUG` | `BillQueryProvider` |
| [SQL-048](SQL-048-bill-query-provider-get-dispense-as-written.md) | Get dispense as written | LINQ (inferred SQL) | `CL_PHARMACY_DAW_CODE` | `BillQueryProvider` |
| [SQL-049](SQL-049-bill-query-provider-get-cbp-procedure-code.md) | Get cbp procedure code | LINQ (inferred SQL) | `CBP_PROCEDURE_CODE` | `BillQueryProvider` |
| [SQL-050](SQL-050-bill-query-provider-get-icd-version.md) | Get icd version | LINQ (inferred SQL) | `IcdVersionCode` | `BillQueryProvider` |
| [SQL-051](SQL-051-certificate-holder-query-provider-get-certificate-holder.md) | Get certificate holder | LINQ (inferred SQL) | `CERTIFICATE_HOLDER` | `CertificateHolderQueryProvider` |
| [SQL-052](SQL-052-certificate-holder-query-provider-get-certificate-holders.md) | Get certificate holders | LINQ (inferred SQL) | `CERTIFICATE_HOLDER` | `CertificateHolderQueryProvider` |
| [SQL-053](SQL-053-certificate-holder-query-provider-get-certificate-holders.md) | Get certificate holders | LINQ (inferred SQL) | `CERTIFICATE_HOLDER` | `CertificateHolderQueryProvider` |
| [SQL-054](SQL-054-claim-payment-query-provider-get-special-handling-codes.md) | Get special handling codes | LINQ (inferred SQL) | `CL_PAYMENT_SPCL_HANDLING_CODE` | `ClaimPaymentQueryProvider` |
| [SQL-055](SQL-055-claim-payment-query-provider-get-special-handling-code.md) | Get special handling code | LINQ (inferred SQL) | `CL_PAYMENT_SPCL_HANDLING_CODE` | `ClaimPaymentQueryProvider` |
| [SQL-056](SQL-056-claim-query-provider-get-claim-from-injury-claim-cross-reference.md) | Get claim from injury claim cross reference | LINQ (inferred SQL) | `LPT_CLAIM_CROSS_REFERENCE` | `ClaimQueryProvider` |
| [SQL-057](SQL-057-claim-query-provider-get-attending-physician.md) | Get attending physician | LINQ (inferred SQL) | `PROVIDER_LOCATION` | `ClaimQueryProvider` |
| [SQL-058](SQL-058-claim-query-provider-get-claim-status-date.md) | Get claim status date | LINQ (inferred SQL) | `CL_CLAIM_STATUS_ACTIVITY` | `ClaimQueryProvider` |
| [SQL-059](SQL-059-claim-query-provider-get-claim-person-addresses.md) | Get claim person addresses | LINQ (inferred SQL) | `CL_CLAIM_PERSON_ADDRESS` | `ClaimQueryProvider` |
| [SQL-060](SQL-060-claim-query-provider-get-claims-missing-tax-id.md) | Get claims missing tax id | LINQ (inferred SQL) | `CL_INJURY_CLAIM`, `CL_CLAIM_PERSON` | `ClaimQueryProvider` |
| [SQL-061](SQL-061-claim-query-provider-get-claim-status-activity.md) | Get claim status activity | LINQ (inferred SQL) | `CL_CLAIM_STATUS_ACTIVITY` | `ClaimQueryProvider` |
| [SQL-062](SQL-062-claim-query-provider-get-claim-request-decisions.md) | Get claim request decisions | LINQ (inferred SQL) | `CL_CLAIM_REQUEST_DECISION` | `ClaimQueryProvider` |
| [SQL-063](SQL-063-claim-query-provider-get-original-acceptance.md) | Get original acceptance | LINQ (inferred SQL) | `CL_CLAIM_REQUEST_DECISION` | `ClaimQueryProvider` |
| [SQL-064](SQL-064-claim-query-provider-get-claim-legal-representative.md) | Get claim legal representative | LINQ (inferred SQL) | `CL_CLAIM_LEGAL_REPRESENTATIVE` | `ClaimQueryProvider` |
| [SQL-065](SQL-065-claim-query-provider-get-conditions.md) | Get conditions | LINQ (inferred SQL) | `CL_MEDICAL_CONDITION` | `ClaimQueryProvider` |
| [SQL-066](SQL-066-claim-query-provider-get-active-claims-with-outstanding-reserves.md) | Get active claims with outstanding reserves | LINQ (inferred SQL) | `CL_INJURY_CLAIM` | `ClaimQueryProvider` |
| [SQL-067](SQL-067-claim-query-provider-get-pharmacy-eligibility-report.md) | Get pharmacy eligibility report | LINQ (inferred SQL) | `CL_PHARMACY_ELIGIBILITY_REPORT` | `ClaimQueryProvider` |
| [SQL-068](SQL-068-claim-query-provider-get-eaip-periods.md) | Get eaip periods | LINQ (inferred SQL) | `EAIP_PERIOD` | `ClaimQueryProvider` |
| [SQL-069](SQL-069-claim-query-provider-get-third-party-case.md) | Get third party case | LINQ (inferred SQL) | `THRDPARTY_CASE` | `ClaimQueryProvider` |
| [SQL-070](SQL-070-claim-query-provider-get-rtw-case.md) | Get rtw case | LINQ (inferred SQL) | `RTW_CASE` | `ClaimQueryProvider` |
| [SQL-071](SQL-071-claim-query-provider-get-claim-status-code.md) | Get claim status code | LINQ (inferred SQL) | `claim_status_code` | `ClaimQueryProvider` |
| [SQL-072](SQL-072-claim-query-provider-get-claim-type-code.md) | Get claim type code | LINQ (inferred SQL) | `CL_CLAIM_TYPE_CODE` | `ClaimQueryProvider` |
| [SQL-073](SQL-073-claim-security-override-provider-has-claim-security-override.md) | Has claim security override | LINQ (inferred SQL) | `CL_SECURITY_OVERRIDE` | `ClaimSecurityOverrideProvider` |
| [SQL-074](SQL-074-ebill-address-query-provider-get-address.md) | Get address | LINQ (inferred SQL) | `EBILL_ADDRESS` | `EbillAddressQueryProvider` |
| [SQL-075](SQL-075-ebill-address-query-provider-get-address-type-by-code.md) | Get address type by code | LINQ (inferred SQL) | `EBILL_ADDRESS_TYPE_CODE` | `EbillAddressQueryProvider` |
| [SQL-076](SQL-076-ebill-address-query-provider-get-address-by-batch-id.md) | Get address by batch id | LINQ (inferred SQL) | `EBILL_ADDRESS` | `EbillAddressQueryProvider` |
| [SQL-077](SQL-077-ebill-address-query-provider-get-addresses-to-override.md) | Get addresses to override | LINQ (inferred SQL) | `EBILL_ADDRESS_OVERRIDE` | `EbillAddressQueryProvider` |
| [SQL-078](SQL-078-ebill-batch-query-provider-get-batch.md) | Get batch | LINQ (inferred SQL) | `EBILL_BATCH` | `EbillBatchQueryProvider` |
| [SQL-079](SQL-079-ebill-batch-query-provider-get-batch.md) | Get batch | LINQ (inferred SQL) | `EBILL_BATCH` | `EbillBatchQueryProvider` |
| [SQL-080](SQL-080-ebill-batch-query-provider-get-batch.md) | Get batch | LINQ (inferred SQL) | `EBILL_BATCH` | `EbillBatchQueryProvider` |
| [SQL-081](SQL-081-ebill-batch-query-provider-get-batch.md) | Get batch | LINQ (inferred SQL) | `EBILL_BATCH` | `EbillBatchQueryProvider` |
| [SQL-082](SQL-082-ebill-batch-query-provider-get-first-batch.md) | Get first batch | LINQ (inferred SQL) | `EBILL_BATCH` | `EbillBatchQueryProvider` |
| [SQL-083](SQL-083-ebill-batch-query-provider-get-first-batch.md) | Get first batch | LINQ (inferred SQL) | `EBILL_BATCH` | `EbillBatchQueryProvider` |
| [SQL-084](SQL-084-ebill-batch-query-provider-get-last-batch.md) | Get last batch | LINQ (inferred SQL) | `EBILL_BATCH` | `EbillBatchQueryProvider` |
| [SQL-085](SQL-085-ebill-batch-query-provider-get-last-batch.md) | Get last batch | LINQ (inferred SQL) | `EBILL_BATCH` | `EbillBatchQueryProvider` |
| [SQL-086](SQL-086-ebill-batch-query-provider-get-last-batch.md) | Get last batch | LINQ (inferred SQL) | `EBILL_BATCH` | `EbillBatchQueryProvider` |
| [SQL-087](SQL-087-ebill-batch-query-provider-get-batch-type.md) | Get batch type | LINQ (inferred SQL) | `EBILL_BATCH_TYPE_CODE` | `EbillBatchQueryProvider` |
| [SQL-088](SQL-088-ebill-batch-query-provider-get-batch-type-code.md) | Get batch type code | LINQ (inferred SQL) | `EBILL_BATCH_TYPE_CODE` | `EbillBatchQueryProvider` |
| [SQL-089](SQL-089-ebill-batch-query-provider-get-batch-status.md) | Get batch status | LINQ (inferred SQL) | `EBILL_BATCH_STATUS_CODE` | `EbillBatchQueryProvider` |
| [SQL-090](SQL-090-ebill-clearinghouse-query-provider-get-clearinghouse-by-tax-id.md) | Get clearinghouse by tax id | LINQ (inferred SQL) | `EBILL_CLEARINGHOUSE` | `EbillClearinghouseQueryProvider` |
| [SQL-091](SQL-091-ebill-clearinghouse-query-provider-get-clearinghouse-by-clearinghouse-code.md) | Get clearinghouse by clearinghouse code | LINQ (inferred SQL) | `EBILL_CLEARINGHOUSE` | `EbillClearinghouseQueryProvider` |
| [SQL-092](SQL-092-ebill-document-query-provider-get-document.md) | Get document | LINQ (inferred SQL) | `EBILL_DOCUMENT` | `EbillDocumentQueryProvider` |
| [SQL-093](SQL-093-ebill-document-query-provider-get-non-imaged-documentsfor-batch.md) | Get non imaged documentsfor batch | LINQ (inferred SQL) | `EBILL_DOCUMENT`, `EBILL` | `EbillDocumentQueryProvider` |
| [SQL-094](SQL-094-ebill-document-query-provider-get-non-imaged-documentsfor-bill.md) | Get non imaged documentsfor bill | LINQ (inferred SQL) | `EBILL_DOCUMENT` | `EbillDocumentQueryProvider` |
| [SQL-095](SQL-095-ebill-document-query-provider-get-documentsfor-bill.md) | Get documentsfor bill | LINQ (inferred SQL) | `EBILL_DOCUMENT` | `EbillDocumentQueryProvider` |
| [SQL-096](SQL-096-ebill-document-query-provider-get-billing-parent-documents-imaged-by-batch-id.md) | Get billing parent documents imaged by batch id | LINQ (inferred SQL) | `EBILL_DOCUMENT`, `EBILL` | `EbillDocumentQueryProvider` |
| [SQL-097](SQL-097-ebill-document-query-provider-get-document-type-by-code.md) | Get document type by code | LINQ (inferred SQL) | `EBILL_DOCUMENT_TYPE_CODE` | `EbillDocumentQueryProvider` |
| [SQL-098](SQL-098-ebill-document-query-provider-get-document-type-by-set-type.md) | Get document type by set type | LINQ (inferred SQL) | `EBILL_DOCUMENT_TYPE_CODE` | `EbillDocumentQueryProvider` |
| [SQL-099](SQL-099-ebill-document-query-provider-get-document-override.md) | Get document override | LINQ (inferred SQL) | `EBILL_DOCUMENT_OVERRIDE` | `EbillDocumentQueryProvider` |
| [SQL-100](SQL-100-ebill-eob-query-provider-get-completed-zero-payment-bills-for-eob.md) | Get completed zero payment bills for eob | LINQ (inferred SQL) | `EBILL`, `CBP_BILL`, `CBP_AUDIT`, `EBILL_BATCH` | `EbillEobQueryProvider` |
| [SQL-101](SQL-101-ebill-eob-query-provider-get-completed-zero-payment-bills-for-eob.md) | Get completed zero payment bills for eob | LINQ (inferred SQL) | `EBILL`, `CBP_BILL`, `CBP_AUDIT` | `EbillEobQueryProvider` |
| [SQL-102](SQL-102-ebill-eob-query-provider-get-eobs-for-batch.md) | Get eobs for batch | LINQ (inferred SQL) | `EBILL_EOB` | `EbillEobQueryProvider` |
| [SQL-103](SQL-103-ebill-eob-query-provider-get-eob.md) | Get eob | LINQ (inferred SQL) | `EBILL_EOB` | `EbillEobQueryProvider` |
| [SQL-104](SQL-104-ebill-health-information-query-provider-get-health-information.md) | Get health information | LINQ (inferred SQL) | `EBILL_HEALTH_INFORMATION` | `EbillHealthInformationQueryProvider` |
| [SQL-105](SQL-105-ebill-health-information-query-provider-get-health-info-type-by-code.md) | Get health info type by code | LINQ (inferred SQL) | `EBILL_HEALTH_INFO_TYPE_CODE` | `EbillHealthInformationQueryProvider` |
| [SQL-106](SQL-106-ebill-health-information-query-provider-get-drg-code.md) | Get drg code | LINQ (inferred SQL) | `EBILL_HEALTH_INFORMATION` | `EbillHealthInformationQueryProvider` |
| [SQL-107](SQL-107-ebill-invoice-query-provider-get-invoice.md) | Get invoice | LINQ (inferred SQL) | `EBILL_INVOICE` | `EbillInvoiceQueryProvider` |
| [SQL-108](SQL-108-ebill-invoice-query-provider-get-invoice-bills.md) | Get invoice bills | LINQ (inferred SQL) | `EBILL_INVOICE_BILL` | `EbillInvoiceQueryProvider` |
| [SQL-109](SQL-109-ebill-invoice-query-provider-get-invoice-error.md) | Get invoice error | LINQ (inferred SQL) | `EBILL_INVOICE_ERROR` | `EbillInvoiceQueryProvider` |
| [SQL-110](SQL-110-ebill-patient-query-provider-get-patient.md) | Get patient | LINQ (inferred SQL) | `EBILL_PATIENT` | `EbillPatientQueryProvider` |
| [SQL-111](SQL-111-ebill-patient-query-provider-get-non-indexed-patients.md) | Get non indexed patients | LINQ (inferred SQL) | `EBILL_PATIENT`, `EBILL_PROVIDER` | `EbillPatientQueryProvider` |
| [SQL-112](SQL-112-ebill-provider-query-provider-get-provider.md) | Get provider | LINQ (inferred SQL) | `EBILL_PROVIDER` | `EbillProviderQueryProvider` |
| [SQL-113](SQL-113-ebill-provider-query-provider-get-non-indexed-providers.md) | Get non indexed providers | LINQ (inferred SQL) | `EBILL_PROVIDER` | `EbillProviderQueryProvider` |
| [SQL-114](SQL-114-ebill-query-provider-get-bill.md) | Get bill | LINQ (inferred SQL) | `EBILL` | `EbillQueryProvider` |
| [SQL-115](SQL-115-ebill-query-provider-get-bill-by-clearinghouse-and-control-number.md) | Get bill by clearinghouse and control number | LINQ (inferred SQL) | `EBILL`, `EBILL_BATCH` | `EbillQueryProvider` |
| [SQL-116](SQL-116-ebill-query-provider-get-bill-count-by-clearinghouse-control-number.md) | Get bill count by clearinghouse control number | LINQ (inferred SQL) | `EBILL` | `EbillQueryProvider` |
| [SQL-117](SQL-117-ebill-query-provider-get-bills-for-response-file-for-clearinghouse.md) | Get bills for response file for clearinghouse | LINQ (inferred SQL) | `EBILL`, `EBILL_BATCH`, `CBP_BILL` | `EbillQueryProvider` |
| [SQL-118](SQL-118-ebill-query-provider-get-bills-by-batch.md) | Get bills by batch | LINQ (inferred SQL) | `EBILL` | `EbillQueryProvider` |
| [SQL-119](SQL-119-ebill-query-provider-get-bills-by-eob.md) | Get bills by eob | LINQ (inferred SQL) | `EBILL` | `EbillQueryProvider` |
| [SQL-120](SQL-120-ebill-query-provider-get-bills-by-received-month.md) | Get bills by received month | LINQ (inferred SQL) | `EBILL`, `EBILL_BATCH` | `EbillQueryProvider` |
| [SQL-121](SQL-121-ebill-query-provider-get-ebill-response-set.md) | Get ebill response set | LINQ (inferred SQL) | `EBILL_RESPONSE_SET` | `EbillQueryProvider` |
| [SQL-122](SQL-122-ebill-query-provider-get-non-indexed-bills.md) | Get non indexed bills | LINQ (inferred SQL) | `EBILL`, `EBILL_PATIENT`, `EBILL_PROVIDER` | `EbillQueryProvider` |
| [SQL-123](SQL-123-ebill-query-provider-get-non-assigned-bills.md) | Get non assigned bills | LINQ (inferred SQL) | `EBILL`, `EBILL_PATIENT`, `EBILL_PROVIDER` | `EbillQueryProvider` |
| [SQL-124](SQL-124-ebill-query-provider-get-non-imaged-bills.md) | Get non imaged bills | LINQ (inferred SQL) | `EBILL` | `EbillQueryProvider` |
| [SQL-125](SQL-125-ebill-query-provider-get-indexed-bills.md) | Get indexed bills | LINQ (inferred SQL) | `EBILL`, `EBILL_PATIENT`, `EBILL_PROVIDER` | `EbillQueryProvider` |
| [SQL-126](SQL-126-ebill-query-provider-get-imaged-bills.md) | Get imaged bills | LINQ (inferred SQL) | `EBILL`, `EBILL_PATIENT`, `EBILL_PROVIDER` | `EbillQueryProvider` |
| [SQL-127](SQL-127-ebill-query-provider-get-ebill.md) | Get ebill | LINQ (inferred SQL) | `EBILL` | `EbillQueryProvider` |
| [SQL-128](SQL-128-ebill-query-provider-get-bill-status-code.md) | Get bill status code | LINQ (inferred SQL) | `EBILL_STATUS_CODE` | `EbillQueryProvider` |
| [SQL-129](SQL-129-ebill-query-provider-get-pended-provider-errors.md) | Get pended provider errors | LINQ (inferred SQL) | `EBILL_ERROR_CONDITION` | `EbillQueryProvider` |
| [SQL-130](SQL-130-ebill-query-provider-get-pended-patient-errors.md) | Get pended patient errors | LINQ (inferred SQL) | `EBILL_ERROR_CONDITION` | `EbillQueryProvider` |
| [SQL-131](SQL-131-ebill-query-provider-get-pended-bill-errors.md) | Get pended bill errors | LINQ (inferred SQL) | `EBILL_ERROR_CONDITION` | `EbillQueryProvider` |
| [SQL-132](SQL-132-ebill-query-provider-get-pended-errors.md) | Get pended errors | LINQ (inferred SQL) | `EBILL_ERROR_CONDITION` | `EbillQueryProvider` |
| [SQL-133](SQL-133-ebill-query-provider-get-bill-assignment-rule.md) | Get bill assignment rule | LINQ (inferred SQL) | `EBILL_ASSIGNMENT_RULE` | `EbillQueryProvider` |
| [SQL-134](SQL-134-ebill-query-provider-get-bill-set-type-code.md) | Get bill set type code | LINQ (inferred SQL) | `EBILL_SET_TYPE_CODE` | `EbillQueryProvider` |
| [SQL-135](SQL-135-ebill-query-provider-get-bill-set-type-code-by-code.md) | Get bill set type code by code | LINQ (inferred SQL) | `EBILL_SET_TYPE_CODE` | `EbillQueryProvider` |
| [SQL-136](SQL-136-ebill-query-provider-get-edi-place-of-service-code.md) | Get edi place of service code | LINQ (inferred SQL) | `EDI_PLACE_OF_SERVICE_CODE` | `EbillQueryProvider` |
| [SQL-137](SQL-137-ebill-query-provider-set-compound-drug-for-all-service-lines-for-the-bill.md) | Set compound drug for all service lines for the bill | LINQ (inferred SQL) | `EBILL_SERVICE` | `EbillQueryProvider` |
| [SQL-138](SQL-138-ebill-service-query-provider-get-maximum-service-date.md) | Get maximum service date | LINQ (inferred SQL) | `EBILL_SERVICE` | `EbillServiceQueryProvider` |
| [SQL-139](SQL-139-ebill-service-query-provider-get-minimum-service-date.md) | Get minimum service date | LINQ (inferred SQL) | `EBILL_SERVICE` | `EbillServiceQueryProvider` |
| [SQL-140](SQL-140-ebill-service-query-provider-get-ebill-service.md) | Get ebill service | LINQ (inferred SQL) | `EBILL` | `EbillServiceQueryProvider` |
| [SQL-141](SQL-141-ebill-service-query-provider-get-ebill-service.md) | Get ebill service | LINQ (inferred SQL) | `EBILL_SERVICE` | `EbillServiceQueryProvider` |
| [SQL-142](SQL-142-ebilling-query-provider-get-clearinghouse.md) | Get clearinghouse | LINQ (inferred SQL) | `EBILL_CLEARINGHOUSE` | `EbillingQueryProvider` |
| [SQL-143](SQL-143-edi-query-provider-get-bill-report.md) | Get bill report | LINQ (inferred SQL) | `EDI_BILL_REPORT` | `EdiQueryProvider` |
| [SQL-144](SQL-144-edi-query-provider-get-bill.md) | Get bill | LINQ (inferred SQL) | `EDI_BILL` | `EdiQueryProvider` |
| [SQL-145](SQL-145-edi-query-provider-get-bill-by-segment-count.md) | Get bill by segment count | LINQ (inferred SQL) | `EDI_BILL` | `EdiQueryProvider` |
| [SQL-146](SQL-146-employee-query-provider-get-wcis-employee.md) | Get wcis employee | LINQ (inferred SQL) | `WCIS_Employee` | `EmployeeQueryProvider` |
| [SQL-147](SQL-147-image-query-provider-get-image.md) | Get image | LINQ (inferred SQL) | `image` | `ImageQueryProvider` |
| [SQL-148](SQL-148-image-query-provider-get-affilliated-images.md) | Get affilliated images | LINQ (inferred SQL) | `image`, `IMAGE_AFFILIATION` | `ImageQueryProvider` |
| [SQL-149](SQL-149-image-query-provider-get-image-system.md) | Get image system | LINQ (inferred SQL) | `IMGSYS` | `ImageQueryProvider` |
| [SQL-150](SQL-150-image-query-provider-get-image-document-type.md) | Get image document type | LINQ (inferred SQL) | `image_document_type_code` | `ImageQueryProvider` |
| [SQL-151](SQL-151-image-query-provider-alert-legal.md) | Alert legal | LINQ (inferred SQL) | `LEGAL_CASE` | `ImageQueryProvider` |
| [SQL-152](SQL-152-legal-query-provider-get-legal-case.md) | Get legal case | LINQ (inferred SQL) | `LEGAL_CASE` | `LegalQueryProvider` |
| [SQL-153](SQL-153-legal-query-provider-get-legal-cases.md) | Get legal cases | LINQ (inferred SQL) | `LEGAL_CASE` | `LegalQueryProvider` |
| [SQL-154](SQL-154-legal-query-provider-get-claim-id-for-case.md) | Get claim id for case | LINQ (inferred SQL) | `LEGAL_CASE` | `LegalQueryProvider` |
| [SQL-155](SQL-155-legal-query-provider-get-case-cost.md) | Get case cost | LINQ (inferred SQL) | `CASE_COST` | `LegalQueryProvider` |
| [SQL-156](SQL-156-legal-query-provider-get-legal-bills.md) | Get legal bills | LINQ (inferred SQL) | `LEGAL_BILL` | `LegalQueryProvider` |
| [SQL-157](SQL-157-legal-query-provider-get-subpoenas.md) | Get subpoenas | LINQ (inferred SQL) | `SUBPOENA` | `LegalQueryProvider` |
| [SQL-158](SQL-158-legal-query-provider-get-appeal-assigned-attorney.md) | Get appeal assigned attorney | LINQ (inferred SQL) | `APPEAL` | `LegalQueryProvider` |
| [SQL-159](SQL-159-legal-query-provider-get-adp-employee-name.md) | Get adp employee name | LINQ (inferred SQL) | `ADP_EMPLOYEE` | `LegalQueryProvider` |
| [SQL-160](SQL-160-legal-query-provider-get-active-legal-cases.md) | Get active legal cases | LINQ (inferred SQL) | `LEGAL_CASE`, `CASE_STATUS_CODE` | `LegalQueryProvider` |
| [SQL-161](SQL-161-legal-query-provider-get-attorney-profile.md) | Get attorney profile | LINQ (inferred SQL) | `ATTORNEY_PROFILE` | `LegalQueryProvider` |
| [SQL-162](SQL-162-legal-query-provider-get-other-firm.md) | Get other firm | LINQ (inferred SQL) | `OTHER_FIRM` | `LegalQueryProvider` |
| [SQL-163](SQL-163-legal-query-provider-get-legal-person.md) | Get legal person | LINQ (inferred SQL) | `LEGAL_PERSON` | `LegalQueryProvider` |
| [SQL-164](SQL-164-legal-query-provider-get-legal-person-address.md) | Get legal person address | LINQ (inferred SQL) | `LEGAL_PERSON_ADDRESS` | `LegalQueryProvider` |
| [SQL-165](SQL-165-legal-query-provider-is-primary-case.md) | Is primary case | LINQ (inferred SQL) | `CONSOLIDATED_CASE` | `LegalQueryProvider` |
| [SQL-166](SQL-166-legal-query-provider-is-image-alert-needed.md) | Is image alert needed | LINQ (inferred SQL) | `LEGAL_CASE` | `LegalQueryProvider` |
| [SQL-167](SQL-167-location-query-provider-get-location.md) | Get location | LINQ (inferred SQL) | `LOCATION` | `LocationQueryProvider` |
| [SQL-168](SQL-168-location-query-provider-get-policy-locations.md) | Get policy locations | LINQ (inferred SQL) | `LOCATION` | `LocationQueryProvider` |
| [SQL-169](SQL-169-location-query-provider-get-primary-location.md) | Get primary location | LINQ (inferred SQL) | `LOCATION` | `LocationQueryProvider` |
| [SQL-170](SQL-170-location-query-provider-get-policy-mailing-location.md) | Get policy mailing location | LINQ (inferred SQL) | `LOCATION` | `LocationQueryProvider` |
| [SQL-171](SQL-171-location-query-provider-get-location-contacts.md) | Get location contacts | LINQ (inferred SQL) | `CONTACT` | `LocationQueryProvider` |
| [SQL-172](SQL-172-location-query-provider-get-polcy-claim-location-with-default.md) | Get polcy claim location with default | LINQ (inferred SQL) | `LOCATION` | `LocationQueryProvider` |
| [SQL-173](SQL-173-location-query-provider-get-claim-location-contact-with-default.md) | Get claim location contact with default | LINQ (inferred SQL) | `CONTACT` | `LocationQueryProvider` |
| [SQL-174](SQL-174-location-query-provider-get-office-code.md) | Get office code | LINQ (inferred SQL) | `OFFICE_CODE` | `LocationQueryProvider` |
| [SQL-175](SQL-175-location-query-provider-get-oregon-business-locations.md) | Get oregon business locations | LINQ (inferred SQL) | `LOCATION` | `LocationQueryProvider` |
| [SQL-176](SQL-176-medicare-query-provider-get-next-minumum-submission-batch.md) | Get next minumum submission batch | LINQ (inferred SQL) | `MEDICARE_BENEFICIARY_QUERY_BAT` | `MedicareQueryProvider` |
| [SQL-177](SQL-177-medicare-query-provider-find-medicare-history-match.md) | Find medicare history match | LINQ (inferred SQL) | `MEDICARE_QUERY_HISTORY` | `MedicareQueryProvider` |
| [SQL-178](SQL-178-medicare-query-provider-get-countfor-batch-of-medicare-beneficiary.md) | Get countfor batch of medicare beneficiary | LINQ (inferred SQL) | `MEDICARE_BENEFICIARY_QUERY` | `MedicareQueryProvider` |
| [SQL-179](SQL-179-medicare-query-provider-get-countfor-batch-of-medicare-history.md) | Get countfor batch of medicare history | LINQ (inferred SQL) | `MEDICARE_QUERY_HISTORY` | `MedicareQueryProvider` |
| [SQL-180](SQL-180-medicare-query-provider-get-beneficiaries.md) | Get beneficiaries | LINQ (inferred SQL) | `MEDICARE_BENEFICIARY_QUERY` | `MedicareQueryProvider` |
| [SQL-181](SQL-181-output-document-query-provider-get-released-status.md) | Get released status | LINQ (inferred SQL) | `document_status_code` | `OutputDocumentQueryProvider` |
| [SQL-182](SQL-182-output-document-query-provider-get-account-number.md) | Get account number | LINQ (inferred SQL) | `POLICY` | `OutputDocumentQueryProvider` |
| [SQL-183](SQL-183-output-document-query-provider-get-document-date.md) | Get document date | LINQ (inferred SQL) | `batch_process_log` | `OutputDocumentQueryProvider` |
| [SQL-184](SQL-184-output-document-query-provider-document-system-date.md) | Document system date | ORM (IRepository.SystemDate) |  | `OutputDocumentQueryProvider` |
| [SQL-185](SQL-185-output-document-query-provider-get-policy-output-document.md) | Get policy output document | LINQ (inferred SQL) | `policy_output_document` | `OutputDocumentQueryProvider` |
| [SQL-186](SQL-186-output-document-query-provider-policy-output-document-query.md) | Policy output document query | LINQ (inferred SQL) | `policy_output_document` | `OutputDocumentQueryProvider` |
| [SQL-187](SQL-187-output-document-query-provider-output-document-type-code-query.md) | Output document type code query | LINQ (inferred SQL) | `output_document_type_code` | `OutputDocumentQueryProvider` |
| [SQL-188](SQL-188-output-document-query-provider-get-category-codes.md) | Get category codes | LINQ (inferred SQL) | `output_document_category_code` | `OutputDocumentQueryProvider` |
| [SQL-189](SQL-189-output-document-query-provider-document-status-code-query.md) | Document status code query | LINQ (inferred SQL) | `document_status_code` | `OutputDocumentQueryProvider` |
| [SQL-190](SQL-190-overpayment-query-provider-get-recoverable-balance.md) | Get recoverable balance | LINQ (inferred SQL) | `CL_OVERPAYMENT` | `OverpaymentQueryProvider` |
| [SQL-191](SQL-191-payments-query-provider-get-payment-transaction-statisic.md) | Get payment transaction statisic | LINQ (inferred SQL) | `PAYMENT_TRANSACTION_STAT` | `PaymentsQueryProvider` |
| [SQL-192](SQL-192-payments-query-provider-get-last-payment-transaction-statisic.md) | Get last payment transaction statisic | LINQ (inferred SQL) | `PAYMENT_TRANSACTION_STAT` | `PaymentsQueryProvider` |
| [SQL-193](SQL-193-payments-query-provider-get-payment-type.md) | Get payment type | LINQ (inferred SQL) | `PAYMENT_TRANSACTION_TYPE_CODE` | `PaymentsQueryProvider` |
| [SQL-194](SQL-194-policy-query-provider-get-policy.md) | Get policy | LINQ (inferred SQL) | `POLICY` | `PolicyQueryProvider` |
| [SQL-195](SQL-195-policy-query-provider-get-non-policy-account.md) | Get non policy account | LINQ (inferred SQL) | `NON_EMPR_ACCT` | `PolicyQueryProvider` |
| [SQL-196](SQL-196-policy-query-provider-get-policy-team-function.md) | Get policy team function | LINQ (inferred SQL) | `POLICY_TEAM_FUNCTION` | `PolicyQueryProvider` |
| [SQL-197](SQL-197-policy-query-provider-get-business.md) | Get business | LINQ (inferred SQL) | `BUSINESS` | `PolicyQueryProvider` |
| [SQL-198](SQL-198-policy-query-provider-get-group-association.md) | Get group association | LINQ (inferred SQL) | `POLICY_PERIOD_GROUP_ASSOC` | `PolicyQueryProvider` |
| [SQL-199](SQL-199-policy-query-provider-get-payroll-report-for-report-id.md) | Get payroll report for report id | LINQ (inferred SQL) | `POLICY_PERIOD_PAYROLL_AUDIT` | `PolicyQueryProvider` |
| [SQL-200](SQL-200-provider-query-provider-get-provider-address-last-update-date.md) | Get provider address last update date | LINQ (inferred SQL) | `PROVIDER_ADDRESS` | `ProviderQueryProvider` |
| [SQL-201](SQL-201-provider-query-provider-get-all-active-provider-addresses-for-update-date.md) | Get all active provider addresses for update date | LINQ (inferred SQL) | `PROVIDER_ADDRESS` | `ProviderQueryProvider` |
| [SQL-202](SQL-202-provider-query-provider-get-provider.md) | Get provider | LINQ (inferred SQL) | `PROVIDER` | `ProviderQueryProvider` |
| [SQL-203](SQL-203-provider-query-provider-get-provider-by-tax-id.md) | Get provider by tax id | LINQ (inferred SQL) | `PROVIDER_TAX_ID` | `ProviderQueryProvider` |
| [SQL-204](SQL-204-provider-query-provider-get-provider-by-tax-id.md) | Get provider by tax id | LINQ (inferred SQL) | `PROVIDER` | `ProviderQueryProvider` |
| [SQL-205](SQL-205-provider-query-provider-get-location.md) | Get location | LINQ (inferred SQL) | `PROVIDER_LOCATION` | `ProviderQueryProvider` |
| [SQL-206](SQL-206-provider-query-provider-get-provider-addresses.md) | Get provider addresses | LINQ (inferred SQL) | `PROVIDER_ADDRESS`, `PROVIDER_LOCATION` | `ProviderQueryProvider` |
| [SQL-207](SQL-207-provider-query-provider-get-provider-addresses.md) | Get provider addresses | LINQ (inferred SQL) | `PROVIDER_ADDRESS`, `PROVIDER_LOCATION` | `ProviderQueryProvider` |
| [SQL-208](SQL-208-provider-query-provider-get-provider-location-addresses.md) | Get provider location addresses | LINQ (inferred SQL) | `PROVIDER_ADDRESS` | `ProviderQueryProvider` |
| [SQL-209](SQL-209-provider-query-provider-get-provider-location-addresses.md) | Get provider location addresses | LINQ (inferred SQL) | `PROVIDER_ADDRESS` | `ProviderQueryProvider` |
| [SQL-210](SQL-210-provider-query-provider-get-bill-provider-location-ids.md) | Get bill provider location ids | LINQ (inferred SQL) | `CBP_BILL` | `ProviderQueryProvider` |
| [SQL-211](SQL-211-provider-query-provider-get-provider-identities-by-npi.md) | Get provider identities by npi | LINQ (inferred SQL) | `PROVIDER_IDENTITY` | `ProviderQueryProvider` |
| [SQL-212](SQL-212-provider-query-provider-get-working-provider-relationships-by-parent-location.md) | Get working provider relationships by parent location | LINQ (inferred SQL) | `PROVIDER_RELATIONSHIP` | `ProviderQueryProvider` |
| [SQL-213](SQL-213-provider-query-provider-get-expired-relationships-on-or-after-date.md) | Get expired relationships on or after date | LINQ (inferred SQL) | `PROVIDER_RELATIONSHIP` | `ProviderQueryProvider` |
| [SQL-214](SQL-214-provider-query-provider-get-active-working-relationships-for-provider.md) | Get active working relationships for provider | LINQ (inferred SQL) | `PROVIDER_RELATIONSHIP` | `ProviderQueryProvider` |
| [SQL-215](SQL-215-provider-query-provider-get-provider-mcoplans.md) | Get provider m c o plans | LINQ (inferred SQL) | `MCO_PROVIDER` | `ProviderQueryProvider` |
| [SQL-216](SQL-216-provider-query-provider-is-provider-in-mco.md) | Is provider in mco | LINQ (inferred SQL) | `MCO_PROVIDER` | `ProviderQueryProvider` |
| [SQL-217](SQL-217-provider-query-provider-has-active-relationship.md) | Has active relationship | LINQ (inferred SQL) | `PROVIDER_RELATIONSHIP` | `ProviderQueryProvider` |
| [SQL-218](SQL-218-report-query-provider-get-attending-claims-with-relationship.md) | Get attending claims with relationship | LINQ (inferred SQL) | `ATTENDING_PHYSICIAN` | `ReportQueryProvider` |
| [SQL-219](SQL-219-report-query-provider-get-legal-rep-claims-with-relationship.md) | Get legal rep claims with relationship | LINQ (inferred SQL) | `CL_CLAIM_LEGAL_REPRESENTATIVE` | `ReportQueryProvider` |
| [SQL-220](SQL-220-report-query-provider-get-active-attending-physician-records-for-claim.md) | Get active attending physician records for claim | LINQ (inferred SQL) | `ATTENDING_PHYSICIAN` | `ReportQueryProvider` |
| [SQL-221](SQL-221-report-query-provider-get-active-legal-rep-records-for-claim.md) | Get active legal rep records for claim | LINQ (inferred SQL) | `CL_CLAIM_LEGAL_REPRESENTATIVE` | `ReportQueryProvider` |
| [SQL-222](SQL-222-reserve-query-provider-get-latest-incurred-cost.md) | Get latest incurred cost | LINQ (inferred SQL) | `CL_INCURRED_COST_HISTORY` | `ReserveQueryProvider` |
| [SQL-223](SQL-223-reserve-query-provider-get-incurred-cost-for-date.md) | Get incurred cost for date | LINQ (inferred SQL) | `CL_INCURRED_COST_HISTORY` | `ReserveQueryProvider` |
| [SQL-224](SQL-224-reserve-query-provider-get-total-paid-to-date-for-category.md) | Get total paid to date for category | LINQ (inferred SQL) | `CL_PAYMENT_TOTAL` | `ReserveQueryProvider` |
| [SQL-225](SQL-225-service-code-maintenance-query-provider-get-cpt-services.md) | Get cpt services | LINQ (inferred SQL) | `CBP_CPT_SERVICE` | `ServiceCodeMaintenanceQueryProvider` |
| [SQL-226](SQL-226-service-code-maintenance-query-provider-get-descriptions.md) | Get descriptions | LINQ (inferred SQL) | `CBP_SERVICE_DESCRIPTION` | `ServiceCodeMaintenanceQueryProvider` |
| [SQL-227](SQL-227-service-code-maintenance-query-provider-get-fee-schedules.md) | Get fee schedules | LINQ (inferred SQL) | `CBP_SERVICE_FEE` | `ServiceCodeMaintenanceQueryProvider` |
| [SQL-228](SQL-228-service-code-maintenance-query-provider-get-service-code.md) | Get service code | LINQ (inferred SQL) | `CBP_SERVICE_CODE` | `ServiceCodeMaintenanceQueryProvider` |
| [SQL-229](SQL-229-service-code-query-provider-get-service-code.md) | Get service code | LINQ (inferred SQL) | `CBP_SERVICE_CODE` | `ServiceCodeQueryProvider` |
| [SQL-230](SQL-230-service-code-query-provider-get-procedure-code.md) | Get procedure code | LINQ (inferred SQL) | `CBP_PROCEDURE_CODE` | `ServiceCodeQueryProvider` |
| [SQL-231](SQL-231-task-query-provider-get-source.md) | Get source | LINQ (inferred SQL) | `TASK_SOURCE_CODE` | `TaskQueryProvider` |
| [SQL-232](SQL-232-task-query-provider-get-action.md) | Get action | LINQ (inferred SQL) | `TASK_ACTION_CODE` | `TaskQueryProvider` |
| [SQL-233](SQL-233-task-query-provider-get-priroity.md) | Get priroity | LINQ (inferred SQL) | `TASK_PRIORITY_CODE` | `TaskQueryProvider` |
| [SQL-234](SQL-234-task-query-provider-get-category.md) | Get category | LINQ (inferred SQL) | `TASK_CATEGORY_CODE` | `TaskQueryProvider` |
| [SQL-235](SQL-235-task-query-provider-get-task.md) | Get task | LINQ (inferred SQL) | `TASK` | `TaskQueryProvider` |
| [SQL-236](SQL-236-task-query-provider-get-tasks-for-user.md) | Get tasks for user | LINQ (inferred SQL) | `TASK` | `TaskQueryProvider` |
| [SQL-237](SQL-237-worker-query-provider-get-active-support-order-count.md) | Get active support order count | LINQ (inferred SQL) | `CL_CLAIM_SUPPORT_ORDER` | `WorkerQueryProvider` |
| [SQL-238](SQL-238-worker-query-provider-get-preferred-contact-method.md) | Get preferred contact method | LINQ (inferred SQL) | `cl_pref_contact_method_code` | `WorkerQueryProvider` |
| [SQL-239](SQL-239-worker-query-provider-get-health-insurance-provider-name.md) | Get health insurance provider name | LINQ (inferred SQL) | `CL_INJURY_CLAIM` | `WorkerQueryProvider` |
| [SQL-255](SQL-255-address-builder-type.md) | Type | LINQ (inferred SQL) | `CLAIM_ADDRESS_TYPE_CODE` | `AddressBuilder` |
| [SQL-256](SQL-256-builder-repository.md) | Repository | N/A (no query executed) |  | `Builder` |
| [SQL-257](SQL-257-claim-builder-claim-type.md) | Claim type | LINQ (inferred SQL) | `CL_CLAIM_TYPE_CODE` | `ClaimBuilder` |
| [SQL-258](SQL-258-claim-builder-claim-status.md) | Claim status | LINQ (inferred SQL) | `claim_status_code` | `ClaimBuilder` |
| [SQL-259](SQL-259-claim-builder-claim-status.md) | Claim status | LINQ (inferred SQL) | `CL_CLAIM_STATUS_ACTIVITY` | `ClaimBuilder` |
| [SQL-260](SQL-260-claim-builder-policy.md) | Policy | LINQ (inferred SQL) | `POLICY` | `ClaimBuilder` |
| [SQL-261](SQL-261-claim-code-table-builder-jurisdiction.md) | Jurisdiction | LINQ (inferred SQL) | `CL_JURISDICTION_CODE` | `ClaimCodeTableBuilder` |
| [SQL-262](SQL-262-claim-code-table-builder-claim-type.md) | Claim type | LINQ (inferred SQL) | `CL_CLAIM_TYPE_CODE` | `ClaimCodeTableBuilder` |
| [SQL-263](SQL-263-claim-code-table-builder-claim-status.md) | Claim status | LINQ (inferred SQL) | `claim_status_code` | `ClaimCodeTableBuilder` |
| [SQL-264](SQL-264-claim-code-table-builder-address-type.md) | Address type | LINQ (inferred SQL) | `CLAIM_ADDRESS_TYPE_CODE` | `ClaimCodeTableBuilder` |
| [SQL-265](SQL-265-claim-code-table-builder-claim-responsibility.md) | Claim responsibility | LINQ (inferred SQL) | `CL_CLAIM_RESPONSIBILITY` | `ClaimCodeTableBuilder` |
| [SQL-266](SQL-266-ebilling-extensions-seed-for-ebilling.md) | Seed for ebilling | LINQ (inferred SQL) | `EBILL_BATCH_STATUS_CODE` | `EbillingExtensions` |
| [SQL-267](SQL-267-ebilling-extensions-seed-for-ebilling.md) | Seed for ebilling | LINQ (inferred SQL) | `EBILL_STATUS_CODE` | `EbillingExtensions` |
| [SQL-268](SQL-268-ebilling-extensions-seed-for-ebilling.md) | Seed for ebilling | LINQ (inferred SQL) | `EBILL_SET_TYPE_CODE` | `EbillingExtensions` |
| [SQL-269](SQL-269-ebilling-extensions-seed-for-ebilling.md) | Seed for ebilling | LINQ (inferred SQL) | `EBILL_ADDRESS_TYPE_CODE` | `EbillingExtensions` |
| [SQL-270](SQL-270-ebilling-extensions-seed-for-ebilling.md) | Seed for ebilling | LINQ (inferred SQL) | `EBILL_DOCUMENT_TYPE_CODE` | `EbillingExtensions` |
| [SQL-271](SQL-271-ebilling-extensions-seed-for-ebilling.md) | Seed for ebilling | LINQ (inferred SQL) | `EBILL_BATCH_TYPE_CODE` | `EbillingExtensions` |
| [SQL-272](SQL-272-ebilling-extensions-update-document-type-with-set-code.md) | Update document type with set code | LINQ (inferred SQL) | `EBILL_DOCUMENT_TYPE_CODE`, `EBILL_SET_TYPE_CODE` | `EbillingExtensions` |
| [SQL-273](SQL-273-ebilling-extensions-update-document-type-with-set-code.md) | Update document type with set code | LINQ (inferred SQL) | `EBILL_SET_TYPE_CODE` | `EbillingExtensions` |
| [SQL-274](SQL-274-online-support-extensions-seed-for-online-support.md) | Seed for online support | LINQ (inferred SQL) | `ERROR_GROUP_CODE` | `OnlineSupportExtensions` |
| [SQL-275](SQL-275-online-support-extensions-seed-for-online-support.md) | Seed for online support | LINQ (inferred SQL) | `ERROR_ENVIRONMENT` | `OnlineSupportExtensions` |
| [SQL-276](SQL-276-online-support-extensions-seed-for-online-support.md) | Seed for online support | LINQ (inferred SQL) | `App_Error` | `OnlineSupportExtensions` |
| [SQL-277](SQL-277-policy-extensions-seed-for-policy-testing.md) | Seed for policy testing | LINQ (inferred SQL) | `MARKET_TYPE_CODE` | `PolicyExtensions` |
| [SQL-278](SQL-278-policy-extensions-seed-for-policy-testing.md) | Seed for policy testing | LINQ (inferred SQL) | `POLICY_RELATIONSHIP_CODE` | `PolicyExtensions` |
| [SQL-279](SQL-279-policy-extensions-seed-for-policy-testing.md) | Seed for policy testing | LINQ (inferred SQL) | `OFFICE_CODE` | `PolicyExtensions` |
| [SQL-280](SQL-280-policy-extensions-generate-agencies.md) | Generate agencies | LINQ (inferred SQL) | `Agency` | `PolicyExtensions` |
| [SQL-281](SQL-281-policy-extensions-generate-default-policies.md) | Generate default policies | LINQ (inferred SQL) | `POLICY_TEAM_FUNCTION` | `PolicyExtensions` |
| [SQL-282](SQL-282-policy-extensions-generate-default-policies.md) | Generate default policies | LINQ (inferred SQL) | `MARKET_TYPE_CODE` | `PolicyExtensions` |
| [SQL-283](SQL-283-policy-extensions-generate-default-policies.md) | Generate default policies | LINQ (inferred SQL) | `OFFICE_CODE` | `PolicyExtensions` |
| [SQL-284](SQL-284-policy-extensions-generate-relationship-policies.md) | Generate relationship policies | LINQ (inferred SQL) | `MARKET_TYPE_CODE` | `PolicyExtensions` |
| [SQL-285](SQL-285-policy-extensions-generate-relationship-policies.md) | Generate relationship policies | LINQ (inferred SQL) | `POLICY_RELATIONSHIP_CODE` | `PolicyExtensions` |
| [SQL-286](SQL-286-policy-output-document-extensions-get-regional-policy-served-by-direct-writer.md) | Get regional policy served by direct writer | LINQ (inferred SQL) | `POLICY`, `Agent` | `PolicyOutputDocumentExtensions` |
| [SQL-287](SQL-287-policy-output-document-extensions-seed-with-documents-on-apolicy-served-by-an-external-agent.md) | Seed with documents on a policy served by an external agent | LINQ (inferred SQL) | `POLICY`, `Agent` | `PolicyOutputDocumentExtensions` |
| [SQL-288](SQL-288-policy-output-document-extensions-seed-for-document-testing.md) | Seed for document testing | LINQ (inferred SQL) | `document_status_code` | `PolicyOutputDocumentExtensions` |
| [SQL-289](SQL-289-policy-output-document-extensions-seed-for-document-testing.md) | Seed for document testing | LINQ (inferred SQL) | `output_document_category_code` | `PolicyOutputDocumentExtensions` |
| [SQL-290](SQL-290-policy-output-document-extensions-seed-for-document-testing.md) | Seed for document testing | LINQ (inferred SQL) | `image_category_code` | `PolicyOutputDocumentExtensions` |
| [SQL-291](SQL-291-policy-output-document-extensions-seed-for-document-testing.md) | Seed for document testing | LINQ (inferred SQL) | `image_category_code`, `image_document_type_code` | `PolicyOutputDocumentExtensions` |
| [SQL-292](SQL-292-policy-output-document-extensions-seed-for-document-testing.md) | Seed for document testing | LINQ (inferred SQL) | `output_doc_notify_text_code` | `PolicyOutputDocumentExtensions` |
| [SQL-293](SQL-293-policy-output-document-extensions-seed-for-document-testing.md) | Seed for document testing | LINQ (inferred SQL) | `output_doc_notify_text_code`, `output_document_category_code`, `image_document_type_code`, `output_document_type_code` | `PolicyOutputDocumentExtensions` |
| [SQL-294](SQL-294-policy-output-document-extensions-seed-for-document-testing.md) | Seed for document testing | LINQ (inferred SQL) | `output_document_type_code`, `ENDORSE_CODE` | `PolicyOutputDocumentExtensions` |
| [SQL-295](SQL-295-policy-output-document-extensions-get-doc-status.md) | Get doc status | LINQ (inferred SQL) | `document_status_code` | `PolicyOutputDocumentExtensions` |
| [SQL-296](SQL-296-policy-output-document-extensions-generate-packet.md) | Generate packet | LINQ (inferred SQL) | `POLICY` | `PolicyOutputDocumentExtensions` |
| [SQL-297](SQL-297-policy-output-document-extensions-generate-packet.md) | Generate packet | LINQ (inferred SQL) | `output_document_type_code` | `PolicyOutputDocumentExtensions` |
| [SQL-298](SQL-298-policy-output-document-extensions-generate-packet.md) | Generate packet | LINQ (inferred SQL) | `output_document_type_code` | `PolicyOutputDocumentExtensions` |
| [SQL-299](SQL-299-policy-output-document-extensions-get-document-type.md) | Get document type | LINQ (inferred SQL) | `output_document_type_code` | `PolicyOutputDocumentExtensions` |
| [SQL-300](SQL-300-policy-output-document-extensions-add-documents.md) | Add documents | LINQ (inferred SQL) | `output_document_type_code` | `PolicyOutputDocumentExtensions` |
| [SQL-301](SQL-301-policy-output-document-extensions-add-agency-viewable-documents.md) | Add agency viewable documents | LINQ (inferred SQL) | `output_document_type_code` | `PolicyOutputDocumentExtensions` |
| [SQL-302](SQL-302-task-extensions-seed-for-task-testing.md) | Seed for task testing | LINQ (inferred SQL) | `TASK_SOURCE_CODE` | `TaskExtensions` |
| [SQL-303](SQL-303-task-extensions-seed-for-task-testing.md) | Seed for task testing | LINQ (inferred SQL) | `TASK_ACTION_CODE` | `TaskExtensions` |
| [SQL-304](SQL-304-task-extensions-seed-for-task-testing.md) | Seed for task testing | LINQ (inferred SQL) | `TASK_PRIORITY_CODE` | `TaskExtensions` |
| [SQL-305](SQL-305-task-extensions-fill-task-category.md) | Fill task category | LINQ (inferred SQL) | `TASK_PRIORITY_CODE` | `TaskExtensions` |
| [SQL-306](SQL-306-task-extensions-fill-task-category.md) | Fill task category | LINQ (inferred SQL) | `TASK_ACTION_CODE` | `TaskExtensions` |
| [SQL-307](SQL-307-task-extensions-fill-task-category.md) | Fill task category | LINQ (inferred SQL) | `TASK_SOURCE_CODE` | `TaskExtensions` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-240](SQL-240-ebill-query-provider-set-compound-drug-for-all-service-lines-for-the-bill.md) | Set compound drug for all service lines for the bill | ORM (dirty-check flush*) | `EBILL_SERVICE` | `EbillQueryProvider` |

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

## Sources