---
title: SAIF.Services 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-09-24
library: SAIF.Services
reference_type: package
---

# SAIF.Services SQL catalog

This page indexes all 395 SQL/ORM statements identified in SAIF.Services, grouped by CRUD type. This library is overwhelmingly NHibernate ORM-mediated — the sole exception is [SQL-214](SQL-214-get-claim-id-investigation.md), which documents hand-written native SQL (`Session.CreateSqlQuery`) executed from `InvestigationRepositoryExtensions`; its Sample SQL section shows the literal SQL text captured from source, not an ORM-inferred expression. Every other entry below represents a `GetRepository<T>()` / query-provider call site, and each linked document's Sample SQL section shows the actual ORM expression executed, per the established documentation precedent for ORM-only libraries.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-add-audited-service-override.md) | Create AuditedServiceOverride via `Add` | ORM | EDI_AUDITED_SERVICE_OVERRIDE | AuditedServiceOverride |
| [SQL-002](SQL-002-update-run-date-batch-process-log.md) | Create BatchProcessLog via `UpdateRunDate` | ORM | batch_process_log | BatchProcessLog |
| [SQL-003](SQL-003-insert-new-provider-address-batch-provider-address.md) | Create BatchProviderAddress via `InsertNewProviderAddress` | ORM | PROVIDER_ADDRESS | BatchProviderAddress |
| [SQL-004](SQL-004-add-bill-override.md) | Create BillOverride via `Add` | ORM | EDI_BILL_OVERRIDE | BillOverride |
| [SQL-005](SQL-005-save-request-case.md) | Create Case via `SaveRequest` | ORM | LEGAL_COLLECTION | Case |
| [SQL-006](SQL-006-create-authorization-cbp-authorization.md) | Create CbpAuthorization via `CreateAuthorization` | ORM | CBP_AUTHORIZATION | CbpAuthorization |
| [SQL-007](SQL-007-add-surgery-date-cbp-authorization-surgery.md) | Create CbpAuthorizationSurgery via `AddSurgeryDate` | ORM | CBP_AUTHORIZATION_SURGERY | CbpAuthorizationSurgery |
| [SQL-008](SQL-008-build-new-bill-record-cbp-bill.md) | Create CbpBill records | ORM | CBP_BILL | CbpBill |
| [SQL-009](SQL-009-insert-diagnosis-cbp-diagnosis.md) | Create CbpDiagnosis via `InsertDiagnosis` | ORM | CBP_DIAGNOSIS | CbpDiagnosis |
| [SQL-010](SQL-010-insert-procedure-cbp-procedure-code.md) | Create CbpProcedureCode via `InsertProcedure` | ORM | CBP_PROCEDURE_CODE | CbpProcedureCode |
| [SQL-011](SQL-011-insert-service-cbp-service-code-stateless.md) | Create CbpServiceCodeStateless via `InsertService` | ORM | CBP_SERVICE_CODE | CbpServiceCodeStateless |
| [SQL-012](SQL-012-insert-service-description-cbp-service-description-stateless.md) | Create CbpServiceDescriptionStateless via `InsertServiceDescription` | ORM | CBP_SERVICE_DESCRIPTION | CbpServiceDescriptionStateless |
| [SQL-013](SQL-013-add-certificate-certificate.md) | Create Certificate records | ORM | CERTIFICATE_DETAIL | Certificate |
| [SQL-014](SQL-014-add-preference-certificate-preference.md) | Create CertificatePreference via `AddPreference` | ORM | CERTIFICATE_PREFERENCE | CertificatePreference |
| [SQL-015](SQL-015-create-note-claim-note.md) | Create ClaimNote via `CreateNote` | ORM | CLAIM_ACTIVITY | ClaimNote |
| [SQL-016](SQL-016-create-task-note-claim-note.md) | Create ClaimNote via `CreateTaskNote` | ORM | CLAIM_ACTIVITY | ClaimNote |
| [SQL-017](SQL-017-create-task-note-claim-note-2.md) | Create ClaimNote via `CreateTaskNote` | ORM | CLAIM_ACTIVITY | ClaimNote |
| [SQL-018](SQL-018-create-debtor-debtor.md) | Create Debtor via `CreateDebtor` | ORM | LEGAL_COLLECTION_DEBTOR | Debtor |
| [SQL-019](SQL-019-insert-balance-records-dept-revenue-soil-balance.md) | Create DeptRevenueSoilBalance via `InsertBalanceRecords` | ORM | DEPT_REVENUE_SOIL_BALANCE | DeptRevenueSoilBalance |
| [SQL-020](SQL-020-create-document-distribution-record-document-distribution-log.md) | Create DocumentDistributionLog records | ORM | DOCUMENT_DISTRIBUTION_LOG | DocumentDistributionLog |
| [SQL-021](SQL-021-insert-error-image-document-imaging-error.md) | Create DocumentImagingError via `InsertErrorImage` | ORM | CLM_DBA.document_imaging_error | DocumentImagingError |
| [SQL-022](SQL-022-create-email-notification-document-notification.md) | Create DocumentNotification via `CreateEmailNotification` | ORM | EXT_USER_DOC_NOTIFY | DocumentNotification |
| [SQL-023](SQL-023-submit-document-request-document-request-log.md) | Create DocumentRequestLog via `SubmitDocumentRequest` | ORM | DOCUMENT_REQUEST_LOG | DocumentRequestLog |
| [SQL-024](SQL-024-store-original-document-request-parameters-document-request-parameter.md) | Create DocumentRequestParameter via `StoreOriginalDocumentRequestParameters` | ORM | DocumentRequestParameter** | DocumentRequestParameter |
| [SQL-025](SQL-025-create-template-document-template.md) | Create DocumentTemplate via `CreateTemplate` | ORM | DOCUMENT_TEMPLATE | DocumentTemplate |
| [SQL-026](SQL-026-add-template-options-document-template-option.md) | Create DocumentTemplateOption via `AddTemplateOptions` | ORM | DOCUMENT_TEMPLATE_OPTION | DocumentTemplateOption |
| [SQL-027](SQL-027-add-template-output-profiles-document-template-output-profile.md) | Create DocumentTemplateOutputProfile via `AddTemplateOutputProfiles` | ORM | DOCUMENT_TEMPLATE_OP | DocumentTemplateOutputProfile |
| [SQL-028](SQL-028-process-invoice-file-ebill-invoice.md) | Create EbillInvoice via `ProcessInvoiceFile` | ORM | EBILL_INVOICE | EbillInvoice |
| [SQL-029](SQL-029-load-file-edi-file.md) | Create EdiFile via `LoadFile` | ORM | OPS$JIMMIL.EDI_FILE | EdiFile |
| [SQL-030](SQL-030-add-authority-limit-employee-authority-limit.md) | Create EmployeeAuthorityLimit via `AddAuthorityLimit` | ORM | CL_CLAIM_EMP_BUS_FUNC_LIMIT | EmployeeAuthorityLimit |
| [SQL-031](SQL-031-add-limit-to-history-employee-authority-payment-limit-history.md) | Create EmployeeAuthorityPaymentLimitHistory via `AddLimitToHistory` | ORM | CL_CLAIM_EMP_BUS_FUNC_LIM_HIST | EmployeeAuthorityPaymentLimitHistory |
| [SQL-032](SQL-032-add-image-image-agency.md) | Create ImageAgency via `AddImage` | ORM | Image_Agency | ImageAgency |
| [SQL-033](SQL-033-save-legal-bill-legal-bill.md) | Create LegalBill via `SaveLegalBill` | ORM | LEGAL_BILL | LegalBill |
| [SQL-034](SQL-034-create-note-legal-note.md) | Create LegalNote via `CreateNote` | ORM | LEGAL.CASE_NOTE | LegalNote |
| [SQL-035](SQL-035-create-task-note-legal-note.md) | Create LegalNote via `CreateTaskNote` | ORM | LEGAL.CASE_NOTE | LegalNote |
| [SQL-036](SQL-036-create-new-legal-person-legal-person.md) | Create LegalPerson via `CreateNewLegalPerson` | ORM | LEGAL_PERSON | LegalPerson |
| [SQL-037](SQL-037-create-debtor-location.md) | Create Location records | ORM | LOCATION | Location |
| [SQL-038](SQL-038-insert-medicare-query-history-medicare-query-history.md) | Create MedicareQueryHistory via `InsertMedicareQueryHistory` | ORM | MEDICARE_QUERY_HISTORY | MedicareQueryHistory |
| [SQL-039](SQL-039-create-note-note.md) | Create Note via `CreateNote` | ORM | LEGAL_COLLECTION_NOTE | Note |
| [SQL-040](SQL-040-create-oregon-business-row-oregon-business.md) | Create OregonBusiness via `CreateOregonBusinessRow` | ORM | WCIS_DBA.DCBS_OREGON_BUSINESS | OregonBusiness |
| [SQL-041](SQL-041-add-policy-output-document-policy-output-document.md) | Create PolicyOutputDocument via `AddPolicyOutputDocument` | ORM | policy_output_document | PolicyOutputDocument |
| [SQL-042](SQL-042-save-preferences-preference.md) | Create Preference via `SavePreferences` | ORM | USER_PREFERENCE** | Preference |
| [SQL-043](SQL-043-load-rct-policy-staging-data-rct-location-staging-data.md) | Create RctLocationStagingData via `LoadRctPolicyStagingData` | ORM | RCT_STAGING_POLICY_LOCATION | RctLocationStagingData |
| [SQL-044](SQL-044-insert-rct-policy-selected-rct-policy-selected.md) | Create RctPolicySelected via `InsertRctPolicySelected` | ORM | RCT_POLICY_SELECTED | RctPolicySelected |
| [SQL-045](SQL-045-insert-service-plan-rct-policy-service-plan.md) | Create RctPolicyServicePlan via `InsertServicePlan` | ORM | LC_POLICY_SERVICE_PLAN | RctPolicyServicePlan |
| [SQL-046](SQL-046-load-rct-policy-staging-data-rct-policy-staging-data.md) | Create RctPolicyStagingData via `LoadRctPolicyStagingData` | ORM | RCT_STAGING_POLICY | RctPolicyStagingData |
| [SQL-047](SQL-047-insert-rct-policy-to-transmit-rct-policy-to-transmit.md) | Create RctPolicyToTransmit via `InsertRctPolicyToTransmit` | ORM | RCT_POLICIES_TO_TRANSMIT | RctPolicyToTransmit |
| [SQL-048](SQL-048-create-override-security-override.md) | Create SecurityOverride via `CreateOverride` | ORM | CL_SECURITY_OVERRIDE | SecurityOverride |
| [SQL-049](SQL-049-save-subpoena-subpoena.md) | Create Subpoena via `SaveSubpoena` | ORM | SUBPOENA | Subpoena |
| [SQL-050](SQL-050-create-task-task.md) | Create Task via `CreateTask` | ORM | TASK | Task |
| [SQL-051](SQL-051-add-expired-judgment-task-task.md) | Create Task records | ORM | TASK | Task |
| [SQL-052](SQL-052-create-task-task-2.md) | Create Task records | ORM | TASK | Task |
| [SQL-053](SQL-053-create-marketing-task-task.md) | Create Task records | ORM | TASK | Task |
| [SQL-054](SQL-054-create-task-task-3.md) | Create Task records | ORM | TASK | Task |
| [SQL-055](SQL-055-insert-temp-records-temp-data-person-address.md) | Create TempDataPersonAddress via `InsertTempRecords` | ORM | CLM_DBA.TEMP_DATA_PERSON_ADDRESS | TempDataPersonAddress |
| [SQL-056](SQL-056-insert-temp-records-temp-data-person-address-2.md) | Create TempDataPersonAddress via `InsertTempRecords` | ORM | CLM_DBA.TEMP_DATA_PERSON_ADDRESS | TempDataPersonAddress |
| [SQL-057](SQL-057-add-transaction-transaction.md) | Create Transaction via `AddTransaction` | ORM | LEGAL_COLLECTION_TRANSACTION | Transaction |
| [SQL-058](SQL-058-add-transaction-transaction-2.md) | Create Transaction via `AddTransaction` | ORM | LEGAL_COLLECTION_TRANSACTION | Transaction |
| [SQL-059](SQL-059-insert-transaction-transaction.md) | Create Transaction via `InsertTransaction` | ORM | LEGAL_COLLECTION_TRANSACTION | Transaction |
| [SQL-060](SQL-060-create-x-document-x-document.md) | Create XDocument via `CreateXDocument` | ORM | XDOCUMENT** | XDocument |
| [SQL-061](SQL-061-get-certificate-batch-report-by-cert-holder-x-document.md) | Create XDocument records | ORM | XDOCUMENT** | XDocument |
| [SQL-062](SQL-062-update-subpoena-status-x-document.md) | Create XDocument via `UpdateSubpoenaStatus` | ORM | XDOCUMENT** | XDocument |
| [SQL-063](SQL-063-generate-cash-disbursements-x-document.md) | Create XDocument via `GenerateCashDisbursements` | ORM | XDOCUMENT** | XDocument |
| [SQL-064](SQL-064-create-x-document-x-document-2.md) | Create XDocument via `CreateXDocument` | ORM | XDOCUMENT** | XDocument |
| [SQL-065](SQL-065-generate-zero-payment-letters-x-print-control.md) | Create XPrintControl via `GenerateZeroPaymentLetters` | ORM | XPRINT_CONTROL** | XPrintControl |
| [SQL-066](SQL-066-get-certificate-batch-report-xml-x-print-control.md) | Create XPrintControl records | ORM | XPRINT_CONTROL** | XPrintControl |
| [SQL-067](SQL-067-generate-opposing-counsel-documents-x-print-control.md) | Create XPrintControl via `GenerateOpposingCounselDocuments` | ORM | XPRINT_CONTROL** | XPrintControl |
| [SQL-068](SQL-068-generate-witness-cash-disbursement-request-x-print-control.md) | Create XPrintControl records | ORM | XPRINT_CONTROL** | XPrintControl |
| [SQL-069](SQL-069-create-x-print-control-x-print-control.md) | Create XPrintControl via `CreateXPrintControl` | ORM | XPRINT_CONTROL** | XPrintControl |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-070](SQL-070-get-activities-activity.md) | Retrieve Activity records | ORM | LEGAL_COLLECTION_ACTIVITY** | Activity |
| [SQL-071](SQL-071-get-activity-codes-activity-code.md) | Retrieve ActivityCode via `GetActivityCodes` | ORM | LEGAL_COLL_ACTIVITY_CODE | ActivityCode |
| [SQL-072](SQL-072-save-bill-services-adjustment-reason.md) | Retrieve AdjustmentReason via `SaveBillServices` | ORM | ADJUSTMENT_REASON_CODE | AdjustmentReason |
| [SQL-073](SQL-073-list-of-adjustment-reasons-adjustment-reason.md) | Retrieve AdjustmentReason via `ListOfAdjustmentReasons (property)` | ORM | ADJUSTMENT_REASON_CODE | AdjustmentReason |
| [SQL-074](SQL-074-extract-users-adp-employee-feed.md) | Retrieve AdpEmployeeFeed via `ExtractUsers` | ORM | ADP_EMPLOYEE_FEED | AdpEmployeeFeed |
| [SQL-075](SQL-075-agency-query-agency.md) | Retrieve Agency via `AgencyQuery (property)` | ORM | Agency | Agency |
| [SQL-076](SQL-076-get-agency-agency.md) | Retrieve Agency via `GetAgency` | ORM | Agency | Agency |
| [SQL-077](SQL-077-generate-direct-writer-notifications-agency.md) | Retrieve Agency via `GenerateDirectWriterNotifications` | ORM | Agency | Agency |
| [SQL-078](SQL-078-agency-paperless-query-agency-paperless.md) | Retrieve AgencyPaperless via `AgencyPaperlessQuery (property)` | ORM | AGENCY_PAPERLESS_UPDATE_VIEW | AgencyPaperless |
| [SQL-079](SQL-079-producer-query-agent.md) | Retrieve Agent via `ProducerQuery (property)` | ORM | Agent | Agent |
| [SQL-080](SQL-080-get-agent-data-agent.md) | Retrieve Agent via `GetAgentData` | ORM | AGENT | Agent |
| [SQL-081](SQL-081-agency-book-list-agent.md) | Retrieve Agent records | ORM | AGENT | Agent |
| [SQL-082](SQL-082-validate-application-code-application-code.md) | Retrieve ApplicationCode via `ValidateApplicationCode` | ORM | ONLINE_MESSAGE_APP_CODE | ApplicationCode |
| [SQL-083](SQL-083-get-attorneys-with-pending-legal-bills-attorney-profile.md) | Retrieve AttorneyProfile via `GetAttorneysWithPendingLegalBills` | ORM | ATTORNEY_PROFILE | AttorneyProfile |
| [SQL-084](SQL-084-legal-attorney-list-attorney-profile.md) | Retrieve AttorneyProfile via `LegalAttorneyList (property)` | ORM | ATTORNEY_PROFILE, ADP_EMPLOYEE** | AttorneyProfile |
| [SQL-085](SQL-085-set-attorney-info-attorney-profile.md) | Retrieve AttorneyProfile via `SetAttorneyInfo` | ORM | ATTORNEY_PROFILE | AttorneyProfile |
| [SQL-086](SQL-086-get-audited-service-override.md) | Retrieve AuditedServiceOverride records | ORM | EDI_AUDITED_SERVICE_OVERRIDE | AuditedServiceOverride |
| [SQL-087](SQL-087-create-new-authority-limit-from-edit-authority-business-process-code.md) | Retrieve AuthorityBusinessProcessCode via `CreateNewAuthorityLimitFromEdit` | ORM | CL_CLAIM_BUS_PROCESS_CODE | AuthorityBusinessProcessCode |
| [SQL-088](SQL-088-get-approval-type-list-authority-payment-approval-type-code.md) | Retrieve AuthorityPaymentApprovalTypeCode via `GetApprovalTypeList` | ORM | CL_CLAIM_AUTH_PURPOSE_CODE | AuthorityPaymentApprovalTypeCode |
| [SQL-089](SQL-089-create-new-authority-limit-from-edit-authority-payment-type-code.md) | Retrieve AuthorityPaymentTypeCode records | ORM | CL_CLAIM_BUS_FUNCTION_CODE | AuthorityPaymentTypeCode |
| [SQL-090](SQL-090-generate-idx-file-auto-import-index-defaults.md) | Retrieve AutoImportIndexDefaults via `GenerateIdxFile` | ORM | AUTO_IMPORT_INDEX_DEFAULTS | AutoImportIndexDefaults |
| [SQL-091](SQL-091-apply-cash-receipts-batch-control.md) | Retrieve BatchControl records | ORM | LEGAL_COLLECTION_BATCH_CONTROL | BatchControl |
| [SQL-092](SQL-092-get-single-record-batch-process-log.md) | Retrieve BatchProcessLog via `GetSingleRecord` | ORM | BATCH_PROCESS_LOG | BatchProcessLog |
| [SQL-093](SQL-093-get-last-insert-id-batch-provider-address.md) | Retrieve BatchProviderAddress records | ORM | PROVIDER_ADDRESS | BatchProviderAddress |
| [SQL-094](SQL-094-get-bill-override.md) | Retrieve BillOverride records | ORM | EDI_BILL_OVERRIDE | BillOverride |
| [SQL-095](SQL-095-save-bill-services-bill-service.md) | Retrieve BillService via `SaveBillServices` | ORM | BILL_SERVICE_CODE | BillService |
| [SQL-096](SQL-096-list-of-bill-service-codes-bill-service.md) | Retrieve BillService via `ListOfBillServiceCodes (property)` | ORM | BILL_SERVICE_CODE | BillService |
| [SQL-097](SQL-097-get-spend-category-bill-service.md) | Retrieve BillService via `GetSpendCategory` | ORM | BILL_SERVICE_CODE | BillService |
| [SQL-098](SQL-098-get-bill-service-fee-bill-service-fee.md) | Retrieve BillServiceFee via `GetBillServiceFee` | ORM | BILL_SERVICE_FEE | BillServiceFee |
| [SQL-099](SQL-099-get-ime-bill-service-fees-bill-service-fee.md) | Retrieve BillServiceFee records | ORM | BILL_SERVICE_FEE | BillServiceFee |
| [SQL-100](SQL-100-save-bill-services-bill-service-rate-type.md) | Retrieve BillServiceRateType via `SaveBillServices` | ORM | BILL_SERVICE_RATE_TYPE_CODE | BillServiceRateType |
| [SQL-101](SQL-101-list-of-bill-rate-type-codes-bill-service-rate-type.md) | Retrieve BillServiceRateType via `ListOfBillRateTypeCodes (property)` | ORM | BILL_SERVICE_RATE_TYPE_CODE | BillServiceRateType |
| [SQL-102](SQL-102-set-new-bill-status-bill-status.md) | Retrieve BillStatus via `SetNewBillStatus` | ORM | BILL_STATUS_CODE | BillStatus |
| [SQL-103](SQL-103-save-legal-bill-bill-status.md) | Retrieve BillStatus via `SaveLegalBill` | ORM | BILL_STATUS_CODE | BillStatus |
| [SQL-104](SQL-104-list-of-bill-status-codes-bill-status.md) | Retrieve BillStatus via `ListOfBillStatusCodes (property)` | ORM | BILL_STATUS_CODE | BillStatus |
| [SQL-105](SQL-105-get-pending-cancel-date-for-policy-cancellation.md) | Retrieve Cancellation via `GetPendingCancelDateForPolicy` | ORM | CANCELLATION | Cancellation |
| [SQL-106](SQL-106-add-transaction-case.md) | Retrieve Case records | ORM | LEGAL_COLLECTION | Case |
| [SQL-107](SQL-107-add-transaction-case-2.md) | Retrieve Case records | ORM | LEGAL_COLLECTION | Case |
| [SQL-108](SQL-108-get-case-data-by-id-case.md) | Retrieve Case records | ORM | LEGAL_COLLECTION | Case |
| [SQL-109](SQL-109-balance-at-minimum-tasks-case.md) | Retrieve Case records | ORM | LEGAL_COLLECTION | Case |
| [SQL-110](SQL-110-generate-report-cash-receipts.md) | Retrieve CashReceipts records | ORM | LEGAL_COLLECTION_CASH_RECEIPTS | CashReceipts |
| [SQL-111](SQL-111-get-bill-amounts-cbp-audited-service.md) | Retrieve CbpAuditedService via `GetBillAmounts` | ORM | CBP_BILL, CBP_AUDITED_SERVICE, CBP_AUDIT | CbpAuditedService |
| [SQL-112](SQL-112-delete-authorization-cbp-authorization.md) | Retrieve CbpAuthorization records | ORM | CBP_AUTHORIZATION | CbpAuthorization |
| [SQL-113](SQL-113-add-surgery-date-cbp-authorization-surgery-2.md) | Retrieve CbpAuthorizationSurgery records | ORM | CBP_AUTHORIZATION_SURGERY | CbpAuthorizationSurgery |
| [SQL-114](SQL-114-create-authorization-cbp-authorization-type-code.md) | Retrieve CbpAuthorizationTypeCode records | ORM | CBP_AUTHORIZATION_TYPE_CODE | CbpAuthorizationTypeCode |
| [SQL-115](SQL-115-check-for-duplicate-bill-cbp-bill.md) | Retrieve CbpBill records | ORM | CBP_BILL | CbpBill |
| [SQL-116](SQL-116-get-bill-entry-bills-by-criteria-cbp-bill.md) | Retrieve CbpBill records | ORM | CBP_BILL | CbpBill |
| [SQL-117](SQL-117-get-bill-amounts-cbp-bill.md) | Retrieve CbpBill via `GetBillAmounts` | ORM | CBP_BILL, CBP_AUDITED_SERVICE, CBP_AUDIT | CbpBill |
| [SQL-118](SQL-118-create-new-bill-cbp-bill-entry-source-code.md) | Retrieve CbpBillEntrySourceCode via `CreateNewBill` | ORM | CBP_BILL_ENTRY_SOURCE_CODE | CbpBillEntrySourceCode |
| [SQL-119](SQL-119-submit-bill-cbp-bill-service.md) | Retrieve CbpBillService via `SubmitBill` | ORM | CBP_BILL_SERVICE | CbpBillService |
| [SQL-120](SQL-120-get-charged-services-total-cbp-bill-service.md) | Retrieve CbpBillService records | ORM | CBP_BILL_SERVICE | CbpBillService |
| [SQL-121](SQL-121-create-new-bill-cbp-bill-status-code.md) | Retrieve CbpBillStatusCode records | ORM | CBP_BILL_STATUS_CODE | CbpBillStatusCode |
| [SQL-122](SQL-122-get-bill-status-codes-cbp-bill-status-code.md) | Retrieve CbpBillStatusCode via `GetBillStatusCodes` | ORM | CBP_BILL_STATUS_CODE | CbpBillStatusCode |
| [SQL-123](SQL-123-create-new-bill-cbp-bill-type-code.md) | Retrieve CbpBillTypeCode records | ORM | CBP_BILL_TYPE_CODE | CbpBillTypeCode |
| [SQL-124](SQL-124-get-bill-types-cbp-bill-type-code.md) | Retrieve CbpBillTypeCode via `GetBillTypes` | ORM | CBP_BILL_TYPE_CODE | CbpBillTypeCode |
| [SQL-125](SQL-125-get-bill-diagnosis-cbp-diagnosis.md) | Retrieve CbpDiagnosis via `GetBillDiagnosis` | ORM | CBP_DIAGNOSIS | CbpDiagnosis |
| [SQL-126](SQL-126-query-diagnosis-cbp-diagnosis.md) | Retrieve CbpDiagnosis via `QueryDiagnosis` | ORM | CBP_DIAGNOSIS | CbpDiagnosis |
| [SQL-127](SQL-127-create-diagnoses-cbp-diagnosis-type-code.md) | Retrieve CbpDiagnosisTypeCode records | ORM | CBP_DIAGNOSIS_TYPE_CODE | CbpDiagnosisTypeCode |
| [SQL-128](SQL-128-get-bill-notes-cbp-note.md) | Retrieve CbpNote via `GetBillNotes` | ORM | CBP_NOTE, CBP_NOTE_TYPE_CODE, CBP_NOTE_CATEGORY_CODE | CbpNote |
| [SQL-129](SQL-129-get-audit-note-category-codes-cbp-note-category-code.md) | Retrieve CbpNoteCategoryCode via `GetAuditNoteCategoryCodes` | ORM | CBP_NOTE_CATEGORY_CODE | CbpNoteCategoryCode |
| [SQL-130](SQL-130-get-prescribing-prescriber-codes-cbp-prescribing-provider-code.md) | Retrieve CbpPrescribingProviderCode via `GetPrescribingPrescriberCodes` | ORM | CBP_PRESCRIBING_PROVIDER_CODE | CbpPrescribingProviderCode |
| [SQL-131](SQL-131-create-procedures-cbp-primary-procedure-code.md) | Retrieve CbpPrimaryProcedureCode records | ORM | CBP_PRIMARY_PROCEDURE_CODE | CbpPrimaryProcedureCode |
| [SQL-132](SQL-132-query-procedure-cbp-procedure-code.md) | Retrieve CbpProcedureCode via `QueryProcedure` | ORM | CBP_PROCEDURE_CODE | CbpProcedureCode |
| [SQL-133](SQL-133-valid-cpt-code-cbp-service-code.md) | Retrieve CbpServiceCode via `ValidCptCode` | ORM | CBP_SERVICE_CODE | CbpServiceCode |
| [SQL-134](SQL-134-create-authorization-cbp-service-pm-group-code.md) | Retrieve CbpServicePmGroupCode records | ORM | CBP_SERVICE_PM_GROUP_CODE | CbpServicePmGroupCode |
| [SQL-135](SQL-135-get-certificate-data-by-id-certificate.md) | Retrieve Certificate records | ORM | CERTIFICATE_DETAIL | Certificate |
| [SQL-136](SQL-136-mark-certificate-as-printed-certificate.md) | Retrieve Certificate via `MarkCertificateAsPrinted` | ORM | CERTIFICATE_DETAIL | Certificate |
| [SQL-137](SQL-137-get-preference-by-policy-number-certificate-preference.md) | Retrieve CertificatePreference records | ORM | CERTIFICATE_PREFERENCE | CertificatePreference |
| [SQL-138](SQL-138-delete-note-claim-note.md) | Retrieve ClaimNote records | ORM | CLAIM_ACTIVITY | ClaimNote |
| [SQL-139](SQL-139-create-note-claim-note-category.md) | Retrieve ClaimNoteCategory records | ORM | CLAIM_ACTIVITY_CATEGORY_CODE | ClaimNoteCategory |
| [SQL-140](SQL-140-create-task-note-claim-note-category.md) | Retrieve ClaimNoteCategory via `CreateTaskNote` | ORM | CLAIM_ACTIVITY_CATEGORY_CODE | ClaimNoteCategory |
| [SQL-141](SQL-141-create-task-note-claim-note-category-2.md) | Retrieve ClaimNoteCategory via `CreateTaskNote` | ORM | CLAIM_ACTIVITY_CATEGORY_CODE | ClaimNoteCategory |
| [SQL-142](SQL-142-create-note-claim-note-type.md) | Retrieve ClaimNoteType records | ORM | CLAIM_ACTIVITY_TYPE_CODE | ClaimNoteType |
| [SQL-143](SQL-143-create-task-note-claim-note-type.md) | Retrieve ClaimNoteType via `CreateTaskNote` | ORM | CLAIM_ACTIVITY_TYPE_CODE | ClaimNoteType |
| [SQL-144](SQL-144-create-task-note-claim-note-type-2.md) | Retrieve ClaimNoteType via `CreateTaskNote` | ORM | CLAIM_ACTIVITY_TYPE_CODE | ClaimNoteType |
| [SQL-145](SQL-145-claim-severity-model-activity-query-claim-severity-model-activity.md) | Retrieve ClaimSeverityModelActivity via `ClaimSeverityModelActivityQuery (property)` | ORM | CSGSEV_CLM_SGMNTN_ACTIONS_SENT | ClaimSeverityModelActivity |
| [SQL-146](SQL-146-get-collection-codes-collection-code.md) | Retrieve CollectionCode via `GetCollectionCodes` | ORM | LEGAL_COLLECTION_CODE | CollectionCode |
| [SQL-147](SQL-147-get-context-types-context-code.md) | Retrieve ContextCode via `GetContextTypes` | ORM | CONTEXT_CODE | ContextCode |
| [SQL-148](SQL-148-get-county-codes-county.md) | Retrieve County via `GetCountyCodes` | ORM | COUNTY | County |
| [SQL-149](SQL-149-get-county-names-county.md) | Retrieve County via `GetCountyNames` | ORM | COUNTY | County |
| [SQL-150](SQL-150-get-credit-reps-credit-rep-user.md) | Retrieve CreditRepUser via `GetCreditReps` | ORM | CREDIT_REP_USER, ADP_EMPLOYEE** | CreditRepUser |
| [SQL-151](SQL-151-get-debtor-data-debtor.md) | Retrieve Debtor records | ORM | LEGAL_COLLECTION_DEBTOR | Debtor |
| [SQL-152](SQL-152-create-soil-file-dept-revenue-soil-adjustment.md) | Retrieve DeptRevenueSoilAdjustment records | ORM | DEPT_REVENUE_SOIL_ADJUSTMENT | DeptRevenueSoilAdjustment |
| [SQL-153](SQL-153-update-request-status-doc-request-log-status-code.md) | Retrieve DocRequestLogStatusCode via `UpdateRequestStatus` | ORM | DOC_REQUEST_LOG_STATUS_CODE | DocRequestLogStatusCode |
| [SQL-154](SQL-154-delete-request-distribution-by-id-document-distribution-log.md) | Retrieve DocumentDistributionLog records | ORM | DOCUMENT_DISTRIBUTION_LOG | DocumentDistributionLog |
| [SQL-155](SQL-155-delete-request-distributions-document-distribution-log.md) | Retrieve DocumentDistributionLog via `DeleteRequestDistributions` | ORM | DOCUMENT_DISTRIBUTION_LOG | DocumentDistributionLog |
| [SQL-156](SQL-156-get-document-distribution-logs-for-request-document-distribution-log-r.md) | Retrieve DocumentDistributionLogRequest records | ORM | DOCUMENT_DISTRIBUTION_LOG, DOCUMENT_REQUEST_LOG | DocumentDistributionLogRequest |
| [SQL-157](SQL-157-update-document-distribution-log-completed-document-distribution-log-s.md) | Retrieve DocumentDistributionLogStatusOnly records | ORM | DOCUMENT_DISTRIBUTION_LOG | DocumentDistributionLogStatusOnly |
| [SQL-158](SQL-158-get-request-log-x-element-document-image-type-code.md) | Retrieve DocumentImageTypeCode via `GetRequestLogXElement` | ORM | DocumentImageTypeCode** | DocumentImageTypeCode |
| [SQL-159](SQL-159-export-error-enrollment-documents-document-imaging-error.md) | Retrieve DocumentImagingError records | ORM | DOCUMENT_IMAGING_ERROR | DocumentImagingError |
| [SQL-160](SQL-160-document-notification-query-document-notification.md) | Retrieve DocumentNotification via `DocumentNotificationQuery (property)` | ORM | EXT_USER_DOC_NOTIFY | DocumentNotification |
| [SQL-161](SQL-161-get-document-option-codes-document-option-code.md) | Retrieve DocumentOptionCode via `GetDocumentOptionCodes` | ORM | DOCUMENT_OPTION_CODE | DocumentOptionCode |
| [SQL-162](SQL-162-get-document-output-profile-codes-document-output-profile-code.md) | Retrieve DocumentOutputProfileCode via `GetDocumentOutputProfileCodes` | ORM | DOCUMENT_OP_CODE | DocumentOutputProfileCode |
| [SQL-163](SQL-163-request-log-query-document-request-log.md) | Retrieve DocumentRequestLog via `RequestLogQuery (property)` | ORM | DOCUMENT_REQUEST_LOG, DOCUMENT_TEMPLATE | DocumentRequestLog |
| [SQL-164](SQL-164-delete-template-requests-document-request-log.md) | Retrieve DocumentRequestLog records | ORM | DOCUMENT_REQUEST_LOG | DocumentRequestLog |
| [SQL-165](SQL-165-get-document-request-parameters-document-request-parameter.md) | Retrieve DocumentRequestParameter records | ORM | DocumentRequestParameter** | DocumentRequestParameter |
| [SQL-166](SQL-166-template-query-document-template.md) | Retrieve DocumentTemplate via `TemplateQuery (property)` | ORM | DOCUMENT_TEMPLATE | DocumentTemplate |
| [SQL-167](SQL-167-template-query-document-template-2.md) | Retrieve DocumentTemplate records | ORM | DOCUMENT_TEMPLATE | DocumentTemplate |
| [SQL-168](SQL-168-get-request-log-x-element-document-template-option.md) | Retrieve DocumentTemplateOption via `GetRequestLogXElement` | ORM | DOCUMENT_TEMPLATE_OPTION | DocumentTemplateOption |
| [SQL-169](SQL-169-get-all-template-options-document-template-option.md) | Retrieve DocumentTemplateOption records | ORM | DOCUMENT_TEMPLATE_OPTION | DocumentTemplateOption |
| [SQL-170](SQL-170-get-request-log-x-element-document-template-output-profile.md) | Retrieve DocumentTemplateOutputProfile records | ORM | DOCUMENT_TEMPLATE_OP | DocumentTemplateOutputProfile |
| [SQL-171](SQL-171-get-all-template-output-profiles-document-template-output-profile.md) | Retrieve DocumentTemplateOutputProfile records | ORM | DOCUMENT_TEMPLATE_OP | DocumentTemplateOutputProfile |
| [SQL-172](SQL-172-get-document-template-parameters-document-template-parameter.md) | Retrieve DocumentTemplateParameter via `GetDocumentTemplateParameters` | ORM | DocumentTemplateParameter** | DocumentTemplateParameter |
| [SQL-173](SQL-173-delete-file-edi-file.md) | Retrieve EdiFile via `DeleteFile` | ORM | EDI_FILE | EdiFile |
| [SQL-174](SQL-174-is-active-employee-user-id-employee.md) | Retrieve Employee via `IsActiveEmployeeUserId` | ORM | ADP_EMPLOYEE** | Employee |
| [SQL-175](SQL-175-get-approver-mail-id-employee.md) | Retrieve Employee via `GetApproverMailId` | ORM | ADP_EMPLOYEE** | Employee |
| [SQL-176](SQL-176-get-pending-bills-employee.md) | Retrieve Employee records | ORM | ADP_EMPLOYEE** | Employee |
| [SQL-177](SQL-177-get-terminated-authorities-employee.md) | Retrieve Employee via `GetTerminatedAuthorities` | ORM | ADP_EMPLOYEE**, CL_CLAIM_EMP_BUS_FUNC_LIMIT, CL_CLAIM_BUS_PROCESS_CODE, CL_CLAIM_BUS_FUNCTION_CODE | Employee |
| [SQL-178](SQL-178-has-security-override-employee.md) | Retrieve Employee via `HasSecurityOverride` | ORM | ADP_EMPLOYEE** | Employee |
| [SQL-179](SQL-179-create-override-employee.md) | Retrieve Employee records | ORM | ADP_EMPLOYEE** | Employee |
| [SQL-180](SQL-180-validate-mail-id-employee.md) | Retrieve Employee via `ValidateMailId` | ORM | ADP_EMPLOYEE** | Employee |
| [SQL-181](SQL-181-generate-recipient-cash-request-employee.md) | Retrieve Employee records | ORM | ADP_EMPLOYEE** | Employee |
| [SQL-182](SQL-182-get-approver-email-address-employee.md) | Retrieve Employee records | ORM | ADP_EMPLOYEE** | Employee |
| [SQL-183](SQL-183-get-approver-mail-id-employee-2.md) | Retrieve Employee via `GetApproverMailId` | ORM | ADP_EMPLOYEE** | Employee |
| [SQL-184](SQL-184-get-inbox-items-employee.md) | Retrieve Employee records | ORM | ADP_EMPLOYEE** | Employee |
| [SQL-185](SQL-185-user-authority-level-employee-authority-limit.md) | Retrieve EmployeeAuthorityLimit via `UserAuthorityLevel` | ORM | CL_CLAIM_EMP_BUS_FUNC_LIMIT | EmployeeAuthorityLimit |
| [SQL-186](SQL-186-add-edit-authority-limit-employee-authority-limit.md) | Retrieve EmployeeAuthorityLimit records | ORM | CL_CLAIM_EMP_BUS_FUNC_LIMIT, CL_CLAIM_BUS_PROCESS_CODE, CL_CLAIM_BUS_FUNCTION_CODE, ADP_EMPLOYEE** | EmployeeAuthorityLimit |
| [SQL-187](SQL-187-initiate-employee-list-employee-authority-limit.md) | Retrieve EmployeeAuthorityLimit via `InitiateEmployeeList` | ORM | CL_CLAIM_EMP_BUS_FUNC_LIMIT | EmployeeAuthorityLimit |
| [SQL-188](SQL-188-get-claim-authority-limit-history-employee-authority-payment-limit-his.md) | Retrieve EmployeeAuthorityPaymentLimitHistory via `GetClaimAuthorityLimitHistory` | ORM | CL_CLAIM_EMP_BUS_FUNC_LIM_HIST, CL_CLAIM_BUS_FUNCTION_CODE | EmployeeAuthorityPaymentLimitHistory |
| [SQL-189](SQL-189-get-standard-limits-employer-liability-factors.md) | Retrieve EmployerLiabilityFactors via `GetStandardLimits` | ORM | EMPLOYERS_LIABILITY_FACTORS | EmployerLiabilityFactors |
| [SQL-190](SQL-190-get-specific-limit-employer-liability-limit.md) | Retrieve EmployerLiabilityLimit via `GetSpecificLimit` | ORM | EMPLOYERS_LIABILITY_LIMITS | EmployerLiabilityLimit |
| [SQL-191](SQL-191-get-standard-limits-employer-liability-limit.md) | Retrieve EmployerLiabilityLimit via `GetStandardLimits` | ORM | EMPLOYERS_LIABILITY_LIMITS | EmployerLiabilityLimit |
| [SQL-192](SQL-192-environments-error-environment.md) | Retrieve ErrorEnvironment via `Environments (property)` | ORM | ERROR_ENVIRONMENT | ErrorEnvironment |
| [SQL-193](SQL-193-environment-groups-error-group-code.md) | Retrieve ErrorGroupCode via `EnvironmentGroups (property)` | ORM | ERROR_GROUP_CODE | ErrorGroupCode |
| [SQL-194](SQL-194-environments-by-group-error-group-environment.md) | Retrieve ErrorGroupEnvironment records | ORM | ERROR_GROUP_ENVIRONMENT, ERROR_ENVIRONMENT, ERROR_GROUP_CODE | ErrorGroupEnvironment |
| [SQL-195](SQL-195-application-names-error-log.md) | Retrieve ErrorLog records | ORM | APP_ERROR | ErrorLog |
| [SQL-196](SQL-196-external-user-type-query-external-user-type.md) | Retrieve ExternalUserType via `ExternalUserTypeQuery (property)` | ORM | ext_user_type**, EXT_USER** | ExternalUserType |
| [SQL-197](SQL-197-load-task-mail-id-list-file-request.md) | Retrieve FileRequest via `LoadTaskMailIDList` | ORM | FILE_REQUEST, PAPER_FILE | FileRequest |
| [SQL-198](SQL-198-group-query-group-association.md) | Retrieve GroupAssociation via `GroupQuery` | ORM | GROUP_ASSOCIATION | GroupAssociation |
| [SQL-199](SQL-199-set-attorney-info-hearing-location.md) | Retrieve HearingLocation via `SetAttorneyInfo` | ORM | HEARING_LOCATION | HearingLocation |
| [SQL-200](SQL-200-initialize-label-hearing-location.md) | Retrieve HearingLocation via `InitializeLabel` | ORM | HEARING_LOCATION | HearingLocation |
| [SQL-201](SQL-201-set-subpoena-data-hearing-location.md) | Retrieve HearingLocation via `SetSubpoenaData` | ORM | HEARING_LOCATION | HearingLocation |
| [SQL-202](SQL-202-list-of-hearing-locations-hearing-location.md) | Retrieve HearingLocation via `ListOfHearingLocations (property)` | ORM | HEARING_LOCATION | HearingLocation |
| [SQL-203](SQL-203-create-override-hostile-worker-code.md) | Retrieve HostileWorkerCode via `CreateOverride` | ORM | CL_HOSTILE_WORKER_CODE | HostileWorkerCode |
| [SQL-204](SQL-204-get-data-image-image.md) | Retrieve Image via `GetDataImage` | ORM | image** | Image |
| [SQL-205](SQL-205-image-agency-query-image-agency.md) | Retrieve ImageAgency via `ImageAgencyQuery (property)` | ORM | IMAGE_AGENCY, image** | ImageAgency |
| [SQL-206](SQL-206-get-categories-image-category-code.md) | Retrieve ImageCategoryCode via `GetCategories` | ORM | image_category_code** | ImageCategoryCode |
| [SQL-207](SQL-207-get-document-type-image-document-type-code.md) | Retrieve ImageDocumentTypeCode via `GetDocumentType` | ORM | image_document_type_code** | ImageDocumentTypeCode |
| [SQL-208](SQL-208-get-claim-worker-name-injury-claim.md) | Retrieve InjuryClaim via `GetClaimWorkerName` | ORM | CL_INJURY_CLAIM | InjuryClaim |
| [SQL-209](SQL-209-create-task-injury-claim.md) | Retrieve InjuryClaim records | ORM | CL_INJURY_CLAIM | InjuryClaim |
| [SQL-210](SQL-210-get-claim-data-injury-claim.md) | Retrieve InjuryClaim records | ORM | CL_INJURY_CLAIM | InjuryClaim |
| [SQL-211](SQL-211-create-task-injury-claim-2.md) | Retrieve InjuryClaim records | ORM | CL_INJURY_CLAIM | InjuryClaim |
| [SQL-212](SQL-212-get-interest-calc-codes-interest-calc-code.md) | Retrieve InterestCalcCode via `GetInterestCalcCodes` | ORM | INTEREST_CALC_OPTION_CODE | InterestCalcCode |
| [SQL-213](SQL-213-get-interest-rates-interest-rate-value.md) | Retrieve InterestRateValue via `GetInterestRates` | ORM | INTEREST_RATE_VALUE | InterestRateValue |
| [SQL-214](SQL-214-get-claim-id-investigation.md) | Retrieve Investigation records | Inline SQL | INVESTIGATION, SUBJECT, PERSON, COMPANY, PROVIDER_LOCATION, POLICY | Investigation |
| [SQL-215](SQL-215-get-judgment-codes-judgment-code.md) | Retrieve JudgmentCode via `GetJudgmentCodes` | ORM | JUDGMENT_CODE | JudgmentCode |
| [SQL-216](SQL-216-get-judgment-years-judgment-years-value.md) | Retrieve JudgmentYearsValue via `GetJudgmentYears` | ORM | JUDGEMENT_YEARS_VALUE | JudgmentYearsValue |
| [SQL-217](SQL-217-create-gl-transfer-activity-legal-bill.md) | Retrieve LegalBill records | ORM | LEGAL_BILL, LEGAL_BILL_SERVICE | LegalBill |
| [SQL-218](SQL-218-delete-bill-legal-bill.md) | Retrieve LegalBill records | ORM | LEGAL_BILL | LegalBill |
| [SQL-219](SQL-219-get-inbox-items-legal-bill.md) | Retrieve LegalBill records | ORM | LEGAL_BILL, BILL_STATUS_CODE | LegalBill |
| [SQL-220](SQL-220-generate-check-transactions-async-legal-bill-service.md) | Retrieve LegalBillService via `GenerateCheckTransactionsAsync` | ORM | LEGAL_BILL_SERVICE | LegalBillService |
| [SQL-221](SQL-221-check-for-duplicate-service-legal-bill-service.md) | Retrieve LegalBillService via `CheckForDuplicateService` | ORM | LEGAL_BILL_SERVICE, LEGAL_BILL | LegalBillService |
| [SQL-222](SQL-222-prepare-adjusted-bill-for-save-legal-bill-service.md) | Retrieve LegalBillService records | ORM | LEGAL_BILL_SERVICE | LegalBillService |
| [SQL-223](SQL-223-save-legal-bill-legal-case.md) | Retrieve LegalCase via `SaveLegalBill` | ORM | LEGAL_CASE | LegalCase |
| [SQL-224](SQL-224-create-note-legal-case.md) | Retrieve LegalCase records | ORM | LEGAL_CASE | LegalCase |
| [SQL-225](SQL-225-get-opposing-counsel-info-legal-case.md) | Retrieve LegalCase records | ORM | LEGAL_CASE | LegalCase |
| [SQL-226](SQL-226-create-task-note-legal-case.md) | Retrieve LegalCase via `CreateTaskNote` | ORM | LEGAL_CASE | LegalCase |
| [SQL-227](SQL-227-save-subpoena-legal-case.md) | Retrieve LegalCase via `SaveSubpoena` | ORM | LEGAL_CASE | LegalCase |
| [SQL-228](SQL-228-delete-note-legal-note.md) | Retrieve LegalNote records | ORM | LEGAL.CASE_NOTE | LegalNote |
| [SQL-229](SQL-229-create-note-legal-note-category.md) | Retrieve LegalNoteCategory records | ORM | NOTE_CATEGORY_CODE | LegalNoteCategory |
| [SQL-230](SQL-230-create-task-note-legal-note-category.md) | Retrieve LegalNoteCategory records | ORM | NOTE_CATEGORY_CODE | LegalNoteCategory |
| [SQL-231](SQL-231-get-debtor-location-location.md) | Retrieve Location records | ORM | LOCATION | Location |
| [SQL-232](SQL-232-set-witness-recipients-location.md) | Retrieve Location via `SetWitnessRecipients` | ORM | LOCATION | Location |
| [SQL-233](SQL-233-get-notes-note.md) | Retrieve Note records | ORM | LEGAL_COLLECTION_NOTE | Note |
| [SQL-234](SQL-234-fill-policy-office-code.md) | Retrieve OfficeCode via `FillPolicy` | ORM | OFFICE_CODE | OfficeCode |
| [SQL-235](SQL-235-get-notification-matrix-rules-on-base-notification-rule-matrix.md) | Retrieve OnBaseNotificationRuleMatrix via `GetNotificationMatrixRules` | ORM | OB_NOTIFY_RULE_MATRX_X, OB_NOTIFICATION_MATRIX, ob_doc_type | OnBaseNotificationRuleMatrix |
| [SQL-236](SQL-236-get-message-priorities-online-message-priority.md) | Retrieve OnlineMessagePriority via `GetMessagePriorities` | ORM | ONLINE_MESSAGE_PRIORITY_CODE | OnlineMessagePriority |
| [SQL-237](SQL-237-get-all-active-messages-online-messages.md) | Retrieve OnlineMessages via `GetAllActiveMessages` | ORM | ONLINE_MESSAGE | OnlineMessages |
| [SQL-238](SQL-238-get-message-user-type-online-user-type.md) | Retrieve OnlineUserType records | ORM | ONLINE_USER_TYPE_CODE | OnlineUserType |
| [SQL-239](SQL-239-get-osc-policy-by-id-other-states-policy.md) | Retrieve OtherStatesPolicy via `GetOscPolicyById` | ORM | OSC_POLICY_VIEW | OtherStatesPolicy |
| [SQL-240](SQL-240-has-osc-period-for-policy-period-other-states-policy-period.md) | Retrieve OtherStatesPolicyPeriod via `HasOscPeriodForPolicyPeriod` | ORM | OSC_POLICY_PERIOD, OSC_POLICY_VIEW | OtherStatesPolicyPeriod |
| [SQL-241](SQL-241-fill-output-document-property-output-document.md) | Retrieve OutputDocument records | ORM | OUTPUT_DOCUMENT | OutputDocument |
| [SQL-242](SQL-242-fill-output-document-property-output-document-notify-text-code.md) | Retrieve OutputDocumentNotifyTextCode via `FillOutputDocumentProperty` | ORM | OUTPUT_DOC_NOTIFY_TEXT_CODE | OutputDocumentNotifyTextCode |
| [SQL-243](SQL-243-fill-output-document-property-output-document-type-code.md) | Retrieve OutputDocumentTypeCode via `FillOutputDocumentProperty` | ORM | OUTPUT_DOCUMENT_TYPE_CODE | OutputDocumentTypeCode |
| [SQL-244](SQL-244-release-documents-output-document-type-code-stateless.md) | Retrieve OutputDocumentTypeCodeStateless via `ReleaseDocuments` | ORM | OUTPUT_DOCUMENT_TYPE_CODE | OutputDocumentTypeCodeStateless |
| [SQL-245](SQL-245-replace-image-ids-in-output-log-output-log.md) | Retrieve OutputLog via `ReplaceImageIdsInOutputLog` | ORM | OUTPUT_LOG | OutputLog |
| [SQL-246](SQL-246-get-transactions-payment-ref.md) | Retrieve PaymentRef via `GetTransactions` | ORM | LEGAL_COLLECTION_PAYMENT_REF | PaymentRef |
| [SQL-247](SQL-247-determine-payment-issue-date-payment-transaction-type-code.md) | Retrieve PaymentTransactionTypeCode via `DeterminePaymentIssueDate` | ORM | PAYMENT_TRANSACTION_TYPE_CODE | PaymentTransactionTypeCode |
| [SQL-248](SQL-248-get-next-issue-date-payment-transaction-type-code.md) | Retrieve PaymentTransactionTypeCode via `GetNextIssueDate` | ORM | PAYMENT_TRANSACTION_TYPE_CODE | PaymentTransactionTypeCode |
| [SQL-249](SQL-249-validate-next-issue-date-payment-transaction-type-code.md) | Retrieve PaymentTransactionTypeCode via `ValidateNextIssueDate` | ORM | PAYMENT_TRANSACTION_TYPE_CODE | PaymentTransactionTypeCode |
| [SQL-250](SQL-250-get-issue-date-payment-transaction-type-code.md) | Retrieve PaymentTransactionTypeCode via `GetIssueDate` | ORM | PAYMENT_TRANSACTION_TYPE_CODE | PaymentTransactionTypeCode |
| [SQL-251](SQL-251-get-application-type-pdf-application-error-code.md) | Retrieve PDFApplicationErrorCode via `GetApplicationType` | ORM | `pdf_app_error_code`** | PDFApplicationErrorCode |
| [SQL-252](SQL-252-get-status-type-pdf-status-code.md) | Retrieve PDFStatusCode via `GetStatusType` | ORM | `pdf_cache_status_code`** | PDFStatusCode |
| [SQL-253](SQL-253-get-tracking-info-pdf-tracking.md) | Retrieve PDFTracking records | ORM | `pdf_tracking`**, `pdf_app_error_code`** | PDFTracking |
| [SQL-254](SQL-254-get-processing-type-pdf-tracking-code.md) | Retrieve PDFTrackingCode via `GetProcessingType` | ORM | `pdf_tracking_code`** | PDFTrackingCode |
| [SQL-255](SQL-255-create-service-pharmacy-dispense-as-written-code.md) | Retrieve PharmacyDispenseAsWrittenCode records | ORM | CL_PHARMACY_DAW_CODE | PharmacyDispenseAsWrittenCode |
| [SQL-256](SQL-256-get-eligible-claims-pharmacy-eligibility-report.md) | Retrieve PharmacyEligibilityReport records | ORM | CL_PHARMACY_ELIGIBILITY_REPORT | PharmacyEligibilityReport |
| [SQL-257](SQL-257-process-first-fill-reports-pharmacy-eligibility-status-code.md) | Retrieve PharmacyEligibilityStatusCode records | ORM | CL_PHARMACY_ELIG_STATUS_CODE | PharmacyEligibilityStatusCode |
| [SQL-258](SQL-258-get-policy-data-policy.md) | Retrieve Policy via `GetPolicyData` | ORM | POLICY | Policy |
| [SQL-259](SQL-259-create-task-policy.md) | Retrieve Policy records | ORM | POLICY | Policy |
| [SQL-260](SQL-260-policy-query-policy.md) | Retrieve Policy via `PolicyQuery (property)` | ORM | POLICY | Policy |
| [SQL-261](SQL-261-fill-task-data-policy.md) | Retrieve Policy records | ORM | POLICY | Policy |
| [SQL-262](SQL-262-get-experience-rating-policies-policy.md) | Retrieve Policy records | ORM | POLICY | Policy |
| [SQL-263](SQL-263-fill-policy-policy.md) | Retrieve Policy via `FillPolicy` | ORM | POLICY | Policy |
| [SQL-264](SQL-264-get-policy-name-policy.md) | Retrieve Policy records | ORM | POLICY | Policy |
| [SQL-265](SQL-265-agency-book-list-policy.md) | Retrieve Policy records | ORM | POLICY | Policy |
| [SQL-266](SQL-266-process-all-service-plans-policy.md) | Retrieve Policy via `ProcessAllServicePlans` | ORM | POLICY | Policy |
| [SQL-267](SQL-267-create-task-policy-2.md) | Retrieve Policy records | ORM | POLICY | Policy |
| [SQL-268](SQL-268-generate-all-external-agency-notifications-policy-output-document.md) | Retrieve PolicyOutputDocument records | ORM | POLICY_OUTPUT_DOCUMENT, OUTPUT_DOCUMENT, OUTPUT_DOCUMENT_TYPE_CODE | PolicyOutputDocument |
| [SQL-269](SQL-269-get-policy-period-coverage-bind-policy-period-coverage-bind.md) | Retrieve PolicyPeriodCoverageBind via `GetPolicyPeriodCoverageBind` | ORM | POLICY_PERIOD_COVERAGE_BIND | PolicyPeriodCoverageBind |
| [SQL-270](SQL-270-get-manual-affiliation-policies-policy-relationship.md) | Retrieve PolicyRelationship via `GetManualAffiliationPolicies` | ORM | POLICY_RELATIONSHIP, POLICY | PolicyRelationship |
| [SQL-271](SQL-271-get-saif-contact-data-policy-team-function.md) | Retrieve PolicyTeamFunction via `GetSaifContactData` | ORM | POLICY_TEAM_FUNCTION | PolicyTeamFunction |
| [SQL-272](SQL-272-create-notification-task-policy-team-function.md) | Retrieve PolicyTeamFunction via `CreateNotificationTask` | ORM | POLICY_TEAM_FUNCTION | PolicyTeamFunction |
| [SQL-273](SQL-273-positive-pay-view-query-positive-pay-view.md) | Retrieve PositivePayView via `PositivePayViewQuery (property)` | ORM | POSITIVE_PAY_VIEW | PositivePayView |
| [SQL-274](SQL-274-list-of-process-servers-process-server.md) | Retrieve ProcessServer via `ListOfProcessServers (property)` | ORM | PROCESS_SERVER | ProcessServer |
| [SQL-275](SQL-275-create-authorization-provider-location.md) | Retrieve ProviderLocation records | ORM | PROVIDER_LOCATION | ProviderLocation |
| [SQL-276](SQL-276-save-legal-bill-provider-location.md) | Retrieve ProviderLocation via `SaveLegalBill` | ORM | PROVIDER_LOCATION | ProviderLocation |
| [SQL-277](SQL-277-create-service-provider-location.md) | Retrieve ProviderLocation records | ORM | PROVIDER_LOCATION | ProviderLocation |
| [SQL-278](SQL-278-save-recipients-provider-location.md) | Retrieve ProviderLocation records | ORM | PROVIDER_LOCATION | ProviderLocation |
| [SQL-279](SQL-279-list-of-process-servers-provider-location.md) | Retrieve ProviderLocation records | ORM | PROVIDER_LOCATION | ProviderLocation |
| [SQL-280](SQL-280-retrieve-purchase-orders-purchase-order.md) | Retrieve PurchaseOrder via `RetrievePurchaseOrders` | ORM | PURCHASEORDERSVIEW | PurchaseOrder |
| [SQL-281](SQL-281-retrieve-purchase-order-comments-purchase-order-comment.md) | Retrieve PurchaseOrderComment via `RetrievePurchaseOrderComments` | ORM | PURCHASEORDERCOMMENTS | PurchaseOrderComment |
| [SQL-282](SQL-282-retrieve-purchase-order-line-comments-purchase-order-line-comment.md) | Retrieve PurchaseOrderLineComment via `RetrievePurchaseOrderLineComments` | ORM | PURCHASEORDERLINECOMMENTS | PurchaseOrderLineComment |
| [SQL-283](SQL-283-remove-all-rct-policy-staging-data-rct-location-staging-data.md) | Retrieve RctLocationStagingData via `RemoveAllRctPolicyStagingData` | ORM | RCT_STAGING_POLICY_LOCATION | RctLocationStagingData |
| [SQL-284](SQL-284-get-policy-staging-policies-rct-location-staging-data.md) | Retrieve RctLocationStagingData via `GetPolicyStagingPolicies` | ORM | RCT_STAGING_POLICY_LOCATION | RctLocationStagingData |
| [SQL-285](SQL-285-get-rct-policy-selected-rct-policy-selected.md) | Retrieve RctPolicySelected records | ORM | RCT_POLICY_SELECTED | RctPolicySelected |
| [SQL-286](SQL-286-process-one-service-plan-rct-policy-service-plan.md) | Retrieve RctPolicyServicePlan via `ProcessOneServicePlan` | ORM | LC_POLICY_SERVICE_PLAN | RctPolicyServicePlan |
| [SQL-287](SQL-287-get-policy-staging-policies-rct-policy-staging-data.md) | Retrieve RctPolicyStagingData records | ORM | RCT_STAGING_POLICY, RCT_STAGING_POLICY_LOCATION | RctPolicyStagingData |
| [SQL-288](SQL-288-get-policy-staging-policies-rct-policy-staging-data-2.md) | Retrieve RctPolicyStagingData via `GetPolicyStagingPolicies` | ORM | RCT_STAGING_POLICY | RctPolicyStagingData |
| [SQL-289](SQL-289-get-policies-to-transmit-rct-policy-to-transmit.md) | Retrieve RctPolicyToTransmit via `GetPoliciesToTransmit` | ORM | RCT_POLICIES_TO_TRANSMIT | RctPolicyToTransmit |
| [SQL-290](SQL-290-process-all-service-plans-rct-service-plan-code.md) | Retrieve RctServicePlanCode via `ProcessAllServicePlans` | ORM | LC_SERVICE_PLAN_CODE | RctServicePlanCode |
| [SQL-291](SQL-291-return-subpoena-payment-async-recipient.md) | Retrieve Recipient via `ReturnSubpoenaPaymentAsync` | ORM | SUBPOENA_RECIPIENT | Recipient |
| [SQL-292](SQL-292-save-recipients-recipient.md) | Retrieve Recipient via `SaveRecipients` | ORM | SUBPOENA_RECIPIENT | Recipient |
| [SQL-293](SQL-293-list-of-registered-agents-registered-agent.md) | Retrieve RegisteredAgent via `ListOfRegisteredAgents (property)` | ORM | REGISTERED_AGENT | RegisteredAgent |
| [SQL-294](SQL-294-can-access-rtw-claim-rtw-case.md) | Retrieve RTWCase via `CanAccessRTWClaim` | ORM | RTW_CASE | RTWCase |
| [SQL-295](SQL-295-get-rtw-load-code-rtw-load-assignment.md) | Retrieve RtwLoadAssignment via `GetRTWLoadCode` | ORM | RTW_LOAD_ASSIGNMENT | RtwLoadAssignment |
| [SQL-296](SQL-296-get-run-types-run-type-code.md) | Retrieve RunTypeCode via `GetRunTypes` | ORM | RUN_TYPE_CODE | RunTypeCode |
| [SQL-297](SQL-297-delete-override-security-override.md) | Retrieve SecurityOverride records | ORM | CL_SECURITY_OVERRIDE | SecurityOverride |
| [SQL-298](SQL-298-save-legal-bill-special-handling-code.md) | Retrieve SpecialHandlingCode via `SaveLegalBill` | ORM | CL_PAYMENT_SPCL_HANDLING_CODE | SpecialHandlingCode |
| [SQL-299](SQL-299-special-handling-code-list-special-handling-code.md) | Retrieve SpecialHandlingCode via `SpecialHandlingCodeList (property)` | ORM | CL_PAYMENT_SPCL_HANDLING_CODE | SpecialHandlingCode |
| [SQL-300](SQL-300-get-standard-other-coverage-texts-standard-other-coverage-text.md) | Retrieve StandardOtherCoverageText via `GetStandardOtherCoverageTexts` | ORM | CERTIFICATE_OTHER_COV_CODE | StandardOtherCoverageText |
| [SQL-301](SQL-301-get-state-codes-state-code.md) | Retrieve StateCode via `GetStateCodes` | ORM | ALL_STATES** | StateCode |
| [SQL-302](SQL-302-get-state-codes-state-code-2.md) | Retrieve StateCode via `GetStateCodes` | ORM | ALL_STATES** | StateCode |
| [SQL-303](SQL-303-get-status-codes-status-code.md) | Retrieve StatusCode via `GetStatusCodes` | ORM | LEGAL_COLLECTION_STATUS_CODE | StatusCode |
| [SQL-304](SQL-304-generate-opposing-counsel-documents-subpoena.md) | Retrieve Subpoena records | ORM | SUBPOENA | Subpoena |
| [SQL-305](SQL-305-add-subpoena-document-to-list-subpoena.md) | Retrieve Subpoena records | ORM | SUBPOENA | Subpoena |
| [SQL-306](SQL-306-generate-batch-labels-subpoena.md) | Retrieve Subpoena records | ORM | SUBPOENA, SUBPOENA_SPECIAL_HANDLING_CODE | Subpoena |
| [SQL-307](SQL-307-generate-check-transactions-async-subpoena.md) | Retrieve Subpoena records | ORM | SUBPOENA | Subpoena |
| [SQL-308](SQL-308-delete-subpoena-subpoena.md) | Retrieve Subpoena records | ORM | SUBPOENA | Subpoena |
| [SQL-309](SQL-309-get-inbox-items-subpoena.md) | Retrieve Subpoena records | ORM | SUBPOENA | Subpoena |
| [SQL-310](SQL-310-get-approved-subpoenas-subpoena.md) | Retrieve Subpoena via `GetApprovedSubpoenas` | ORM | SUBPOENA | Subpoena |
| [SQL-311](SQL-311-generate-zero-pay-documents-subpoena.md) | Retrieve Subpoena via `GenerateZeroPayDocuments` | ORM | SUBPOENA | Subpoena |
| [SQL-312](SQL-312-list-of-mailing-options-subpoena-special-handling.md) | Retrieve SubpoenaSpecialHandling via `ListOfMailingOptions (property)` | ORM | SUBPOENA_SPECIAL_HANDLING_CODE | SubpoenaSpecialHandling |
| [SQL-313](SQL-313-update-subpoena-status-subpoena-status.md) | Retrieve SubpoenaStatus via `UpdateSubpoenaStatus` | ORM | SUBPOENA_STATUS_CODE | SubpoenaStatus |
| [SQL-314](SQL-314-set-new-subpoena-status-subpoena-status.md) | Retrieve SubpoenaStatus via `SetNewSubpoenaStatus` | ORM | SUBPOENA_STATUS_CODE | SubpoenaStatus |
| [SQL-315](SQL-315-list-of-subpoena-status-subpoena-status.md) | Retrieve SubpoenaStatus via `ListOfSubpoenaStatus (property)` | ORM | SUBPOENA_STATUS_CODE | SubpoenaStatus |
| [SQL-316](SQL-316-list-of-subpoena-types-subpoena-type.md) | Retrieve SubpoenaType via `ListOfSubpoenaTypes (property)` | ORM | SUBPOENA_TYPE_CODE | SubpoenaType |
| [SQL-317](SQL-317-extract-users-system-user.md) | Retrieve SystemUser via `ExtractUsers` | ORM | SYSTEM_USER | SystemUser |
| [SQL-318](SQL-318-extract-users-system-user-ref.md) | Retrieve SystemUserRef records | ORM | SYSTEM_USER_XREF | SystemUserRef |
| [SQL-319](SQL-319-get-claim-bill-queue-remaining-count-task.md) | Retrieve Task via `GetClaimBillQueueRemainingCount` | ORM | TASK | Task |
| [SQL-320](SQL-320-get-task-data-task.md) | Retrieve Task records | ORM | TASK | Task |
| [SQL-321](SQL-321-remove-exiting-tasks-task.md) | Retrieve Task via `RemoveExitingTasks` | ORM | TASK | Task |
| [SQL-322](SQL-322-task-query-task.md) | Retrieve Task via `TaskQuery (property)` | ORM | TASK | Task |
| [SQL-323](SQL-323-task-query-task-2.md) | Retrieve Task via `TaskQuery (property)` | ORM | TASK | Task |
| [SQL-324](SQL-324-create-task-task-action.md) | Retrieve TaskAction via `CreateTask` | ORM | TASK_ACTION_CODE | TaskAction |
| [SQL-325](SQL-325-set-common-proptery-values-task-action.md) | Retrieve TaskAction via `SetCommonPropteryValues` | ORM | TASK_ACTION_CODE | TaskAction |
| [SQL-326](SQL-326-create-task-task-category.md) | Retrieve TaskCategory via `CreateTask` | ORM | TASK_CATEGORY_CODE | TaskCategory |
| [SQL-327](SQL-327-set-common-proptery-values-task-category.md) | Retrieve TaskCategory via `SetCommonPropteryValues` | ORM | TASK_CATEGORY_CODE | TaskCategory |
| [SQL-328](SQL-328-determine-category-task-category.md) | Retrieve TaskCategory records | ORM | TASK_CATEGORY_CODE | TaskCategory |
| [SQL-329](SQL-329-create-task-task-category-2.md) | Retrieve TaskCategory records | ORM | TASK_CATEGORY_CODE | TaskCategory |
| [SQL-330](SQL-330-get-task-groups-task-group.md) | Retrieve TaskGroup via `GetTaskGroups` | ORM | CLAIM_TASK_GROUP_CODE | TaskGroup |
| [SQL-331](SQL-331-create-task-task-group.md) | Retrieve TaskGroup records | ORM | CLAIM_TASK_GROUP_CODE | TaskGroup |
| [SQL-332](SQL-332-create-task-task-priority.md) | Retrieve TaskPriority via `CreateTask` | ORM | TASK_PRIORITY_CODE | TaskPriority |
| [SQL-333](SQL-333-set-common-proptery-values-task-priority.md) | Retrieve TaskPriority via `SetCommonPropteryValues` | ORM | TASK_PRIORITY_CODE | TaskPriority |
| [SQL-334](SQL-334-fill-task-data-task-priority.md) | Retrieve TaskPriority records | ORM | TASK_PRIORITY_CODE | TaskPriority |
| [SQL-335](SQL-335-create-task-task-priority-2.md) | Retrieve TaskPriority records | ORM | TASK_PRIORITY_CODE | TaskPriority |
| [SQL-336](SQL-336-create-task-task-source.md) | Retrieve TaskSource via `CreateTask` | ORM | TASK_SOURCE_CODE | TaskSource |
| [SQL-337](SQL-337-set-common-proptery-values-task-source.md) | Retrieve TaskSource via `SetCommonPropteryValues` | ORM | TASK_SOURCE_CODE | TaskSource |
| [SQL-338](SQL-338-delete-temp-records-temp-data-person-address.md) | Retrieve TempDataPersonAddress via `DeleteTempRecords` | ORM | TEMP_DATA_PERSON_ADDRESS | TempDataPersonAddress |
| [SQL-339](SQL-339-delete-temp-records-temp-data-person-address-2.md) | Retrieve TempDataPersonAddress via `DeleteTempRecords` | ORM | TEMP_DATA_PERSON_ADDRESS | TempDataPersonAddress |
| [SQL-340](SQL-340-generate-third-party-debtor-third-party.md) | Retrieve ThirdParty via `GenerateThirdPartyDebtor` | ORM | THRDPARTY | ThirdParty |
| [SQL-341](SQL-341-generate-third-party-debtor-third-party-case.md) | Retrieve ThirdPartyCase via `GenerateThirdPartyDebtor` | ORM | THRDPARTY_CASE | ThirdPartyCase |
| [SQL-342](SQL-342-get-trading-as-by-id-trading-as.md) | Retrieve TradingAs via `GetTradingAsById` | ORM | TRADING_AS | TradingAs |
| [SQL-343](SQL-343-get-transaction-transaction.md) | Retrieve Transaction records | ORM | LEGAL_COLLECTION_TRANSACTION | Transaction |
| [SQL-344](SQL-344-get-transaction-category-codes-transaction-category-code.md) | Retrieve TransactionCategoryCode via `GetTransactionCategoryCodes` | ORM | LC_TRAN_CATEGORY_CODE | TransactionCategoryCode |
| [SQL-345](SQL-345-get-transaction-codes-transaction-code.md) | Retrieve TransactionCode records | ORM | LEGAL_COLLECTION_TRAN_CODE | TransactionCode |
| [SQL-346](SQL-346-extract-users-wcis-employee.md) | Retrieve WcisEmployee via `ExtractUsers` | ORM | WCIS_EMPLOYEE** | WcisEmployee |
| [SQL-347](SQL-347-get-write-off-approval-users-write-off-approval-user.md) | Retrieve WriteOffApprovalUser via `GetWriteOffApprovalUsers` | ORM | WRITEOFF_APPROVAL_USER, ADP_EMPLOYEE** | WriteOffApprovalUser |
| [SQL-348](SQL-348-get-one-x-deferred-print-x-deferred-print.md) | Retrieve XDeferredPrint via `GetOneXDeferredPrint` | ORM | XDEFERRED_PRINT | XDeferredPrint |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-349](SQL-349-update-run-date-batch-process-log-2.md) | Update BatchProcessLog via `UpdateRunDate` | ORM | batch_process_log | BatchProcessLog |
| [SQL-350](SQL-350-stateless-process-provider-addresses-for-updates-batch-provider-addres.md) | Update BatchProviderAddress via `StatelessProcessProviderAddressesForUpdates` | ORM | PROVIDER_ADDRESS | BatchProviderAddress |
| [SQL-351](SQL-351-update-diagnosis-cbp-diagnosis.md) | Update CbpDiagnosis via `UpdateDiagnosis` | ORM | CBP_DIAGNOSIS | CbpDiagnosis |
| [SQL-352](SQL-352-update-procedure-cbp-procedure-code.md) | Update CbpProcedureCode via `UpdateProcedure` | ORM | CBP_PROCEDURE_CODE | CbpProcedureCode |
| [SQL-353](SQL-353-update-service-cbp-service-code-stateless.md) | Update CbpServiceCodeStateless via `UpdateService` | ORM | CBP_SERVICE_CODE | CbpServiceCodeStateless |
| [SQL-354](SQL-354-update-service-description-cbp-service-description-stateless.md) | Update CbpServiceDescriptionStateless via `UpdateServiceDescription` | ORM | CBP_SERVICE_DESCRIPTION | CbpServiceDescriptionStateless |
| [SQL-355](SQL-355-update-history-record-medicare-query-history.md) | Update MedicareQueryHistory via `UpdateHistoryRecord` | ORM | MEDICARE_QUERY_HISTORY | MedicareQueryHistory |
| [SQL-356](SQL-356-update-pharm-elig-pharmacy-eligibility-report.md) | Update PharmacyEligibilityReport via `UpdatePharmElig` | ORM | CL_PHARMACY_ELIGIBILITY_REPORT | PharmacyEligibilityReport |
| [SQL-357](SQL-357-modify-rct-policy-selected-rct-policy-selected.md) | Update RctPolicySelected via `ModifyRctPolicySelected` | ORM | RCT_POLICY_SELECTED | RctPolicySelected |
| [SQL-358](SQL-358-expire-service-plan-rct-policy-service-plan.md) | Update RctPolicyServicePlan via `ExpireServicePlan` | ORM | LC_POLICY_SERVICE_PLAN | RctPolicyServicePlan |
| [SQL-359](SQL-359-update-rct-policy-to-transmit-rct-policy-to-transmit.md) | Update RctPolicyToTransmit via `UpdateRctPolicyToTransmit` | ORM | RCT_POLICIES_TO_TRANSMIT | RctPolicyToTransmit |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-360](SQL-360-delete-activity-activity.md) | Delete Activity via `DeleteActivity` | ORM | LEGAL_COLLECTION_ACTIVITY | Activity |
| [SQL-361](SQL-361-delete-audited-service-override.md) | Delete AuditedServiceOverride via `Delete` | ORM | EDI_AUDITED_SERVICE_OVERRIDE | AuditedServiceOverride |
| [SQL-362](SQL-362-stateless-process-provider-addresses-for-updates-batch-provider-addres-2.md) | Delete BatchProviderAddress via `StatelessProcessProviderAddressesForUpdates` | ORM | PROVIDER_ADDRESS | BatchProviderAddress |
| [SQL-363](SQL-363-delete-bill-override.md) | Delete BillOverride via `Delete` | ORM | EDI_BILL_OVERRIDE | BillOverride |
| [SQL-364](SQL-364-delete-authorization-cbp-authorization-2.md) | Delete CbpAuthorization via `DeleteAuthorization` | ORM | CBP_AUTHORIZATION | CbpAuthorization |
| [SQL-365](SQL-365-delete-surgery-date-cbp-authorization-surgery.md) | Delete CbpAuthorizationSurgery via `DeleteSurgeryDate` | ORM | CBP_AUTHORIZATION_SURGERY | CbpAuthorizationSurgery |
| [SQL-366](SQL-366-delete-certificate-certificate.md) | Delete Certificate via `DeleteCertificate` | ORM | CERTIFICATE_DETAIL | Certificate |
| [SQL-367](SQL-367-delete-note-claim-note-2.md) | Delete ClaimNote via `DeleteNote` | ORM | CLAIM_ACTIVITY | ClaimNote |
| [SQL-368](SQL-368-delete-debtor-debtor.md) | Delete Debtor via `DeleteDebtor` | ORM | LEGAL_COLLECTION_DEBTOR | Debtor |
| [SQL-369](SQL-369-delete-request-distribution-by-id-document-distribution-log-2.md) | Delete DocumentDistributionLog via `DeleteRequestDistributionById` | ORM | DOCUMENT_DISTRIBUTION_LOG | DocumentDistributionLog |
| [SQL-370](SQL-370-delete-request-distributions-document-distribution-log-2.md) | Delete DocumentDistributionLog via `DeleteRequestDistributions` | ORM | DOCUMENT_DISTRIBUTION_LOG | DocumentDistributionLog |
| [SQL-371](SQL-371-export-error-enrollment-documents-document-imaging-error-2.md) | Delete DocumentImagingError via `ExportErrorEnrollmentDocuments` | ORM | DOCUMENT_IMAGING_ERROR | DocumentImagingError |
| [SQL-372](SQL-372-delete-email-notification-document-notification.md) | Delete DocumentNotification via `DeleteEmailNotification` | ORM | EXT_USER_DOC_NOTIFY | DocumentNotification |
| [SQL-373](SQL-373-delete-template-requests-document-request-log-2.md) | Delete DocumentRequestLog via `DeleteTemplateRequests` | ORM | DOCUMENT_REQUEST_LOG | DocumentRequestLog |
| [SQL-374](SQL-374-delete-template-document-template.md) | Delete DocumentTemplate via `DeleteTemplate` | ORM | DOCUMENT_TEMPLATE | DocumentTemplate |
| [SQL-375](SQL-375-delete-template-options-document-template-option.md) | Delete DocumentTemplateOption via `DeleteTemplateOptions` | ORM | DOCUMENT_TEMPLATE_OPTION | DocumentTemplateOption |
| [SQL-376](SQL-376-delete-template-output-profiles-document-template-output-profile.md) | Delete DocumentTemplateOutputProfile via `DeleteTemplateOutputProfiles` | ORM | DOCUMENT_TEMPLATE_OP | DocumentTemplateOutputProfile |
| [SQL-377](SQL-377-process-invoice-file-ebill-invoice-2.md) | Delete EbillInvoice via `ProcessInvoiceFile` | ORM | EBILL_INVOICE | EbillInvoice |
| [SQL-378](SQL-378-process-invoice-file-ebill-invoice-bill.md) | Delete EbillInvoiceBill via `ProcessInvoiceFile` | ORM | EBILL_INVOICE_BILL | EbillInvoiceBill |
| [SQL-379](SQL-379-process-invoice-file-ebill-invoice-error.md) | Delete EbillInvoiceError via `ProcessInvoiceFile` | ORM | EBILL_INVOICE_ERROR | EbillInvoiceError |
| [SQL-380](SQL-380-delete-file-edi-file-2.md) | Delete EdiFile via `DeleteFile` | ORM | EDI_FILE | EdiFile |
| [SQL-381](SQL-381-delete-authority-employee-authority-limit.md) | Delete EmployeeAuthorityLimit via `DeleteAuthority` | ORM | CL_CLAIM_EMP_BUS_FUNC_LIMIT | EmployeeAuthorityLimit |
| [SQL-382](SQL-382-delete-bill-legal-bill-2.md) | Delete LegalBill via `DeleteBill` | ORM | LEGAL_BILL | LegalBill |
| [SQL-383](SQL-383-delete-note-legal-note-2.md) | Delete LegalNote via `DeleteNote` | ORM | CASE_NOTE | LegalNote |
| [SQL-384](SQL-384-delete-debtor-location.md) | Delete Location via `DeleteDebtor` | ORM | LOCATION | Location |
| [SQL-385](SQL-385-process-delete-medicare-beneficiarys-for-batch-medicare-beneficiary-qu.md) | Delete MedicareBeneficiaryQuery via `ProcessDeleteMedicareBeneficiarysForBatch` | ORM | MEDICARE_BENEFICIARY_QUERY | MedicareBeneficiaryQuery |
| [SQL-386](SQL-386-process-delete-medicare-beneficiarys-for-batch-medicare-beneficiary-qu-2.md) | Delete MedicareBeneficiaryQueryBatch via `ProcessDeleteMedicareBeneficiarysForBatch` | ORM | MEDICARE_BENEFICIARY_QUERY_BAT | MedicareBeneficiaryQueryBatch |
| [SQL-387](SQL-387-delete-note-note.md) | Delete Note via `DeleteNote` | ORM | LEGAL_COLLECTION_NOTE | Note |
| [SQL-388](SQL-388-remove-all-rct-policy-staging-data-rct-location-staging-data-2.md) | Delete RctLocationStagingData via `RemoveAllRctPolicyStagingData` | ORM | RCT_STAGING_POLICY_LOCATION | RctLocationStagingData |
| [SQL-389](SQL-389-remove-all-rct-policy-staging-data-rct-policy-staging-data.md) | Delete RctPolicyStagingData via `RemoveAllRctPolicyStagingData` | ORM | RCT_STAGING_POLICY | RctPolicyStagingData |
| [SQL-390](SQL-390-remove-rct-policy-to-transmit-rct-policy-to-transmit.md) | Delete RctPolicyToTransmit via `RemoveRctPolicyToTransmit` | ORM | RCT_POLICIES_TO_TRANSMIT | RctPolicyToTransmit |
| [SQL-391](SQL-391-delete-override-security-override-2.md) | Delete SecurityOverride via `DeleteOverride` | ORM | CL_SECURITY_OVERRIDE | SecurityOverride |
| [SQL-392](SQL-392-delete-subpoena-subpoena-2.md) | Delete Subpoena via `DeleteSubpoena` | ORM | SUBPOENA | Subpoena |
| [SQL-393](SQL-393-delete-temp-records-temp-data-person-address-3.md) | Delete TempDataPersonAddress via `DeleteTempRecords` | ORM | TEMP_DATA_PERSON_ADDRESS | TempDataPersonAddress |
| [SQL-394](SQL-394-delete-temp-records-temp-data-person-address-4.md) | Delete TempDataPersonAddress via `DeleteTempRecords` | ORM | TEMP_DATA_PERSON_ADDRESS | TempDataPersonAddress |
| [SQL-395](SQL-395-delete-transaction-transaction.md) | Delete Transaction via `DeleteTransaction` | ORM | LEGAL_COLLECTION_TRANSACTION | Transaction |

## 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
- `Services/SAIF.Services/`