--- title: SAIF.Services database tables summary: Database tables used by this library with relationships and usage context. status: draft owner: SAIF Doc Gen last_reviewed: 2026-09-24 library: SAIF.Services reference_type: package --- # SAIF.Services database tables This page catalogs the 183 Oracle database tables reached by SAIF.Services through NHibernate-mapped business objects (`GetRepository()`), plus 17 generic-repository entity types whose backing table could not be resolved to a `ClassMap` from static analysis alone (marked `**` below and listed in [Unmapped entities](#unmapped-entities)). This library declares no `ClassMap`s of its own, executes no raw SQL/ADO.NET, and holds no connection strings — every table below is reached indirectly through SAIF.Data / SAIF.Data.NHibernate repositories and query providers. ## Table catalog | Table | Database | Schema/Link | CRUD | Purpose | Primary business object | | --- | --- | --- | --- | --- | --- | | [ADJUSTMENT_REASON_CODE](#adjustment_reason_code) | Oracle | [unqualified]** | R | Backing store for `AdjustmentReason` | `AdjustmentReason` | | [ADP_EMPLOYEE](#adp_employee) | Oracle | [unqualified]** | R | Backing store for `Employee`, accessed via non-identifier navigation from `AttorneyProfile`, `CreditRepUser`, `WriteOffApprovalUser`, and `EmployeeAuthorityLimit`/`EmployeeAuthorityPaymentLimitHistory`, and directly via `IUnitOfWork.GetRepository()` | `Employee` | | [ADP_EMPLOYEE_FEED](#adp_employee_feed) | Oracle | [unqualified]** | R | Backing store for `AdpEmployeeFeed` | `AdpEmployeeFeed` | | [AGENCY](#agency) | Oracle | [unqualified]** | R | Backing store for `Agency` | `Agency` | | [AGENCY_PAPERLESS_UPDATE_VIEW](#agency_paperless_update_view) | Oracle | [unqualified]** | R | Backing store for `AgencyPaperless` | `AgencyPaperless` | | [AGENT](#agent) | Oracle | [unqualified]** | R | Backing store for `Agent` | `Agent` | | [APP_ERROR](#app_error) | Oracle | [unqualified]** | R | Backing store for `ErrorLog` | `ErrorLog` | | [ATTORNEY_PROFILE](#attorney_profile) | Oracle | [unqualified]** | R | Backing store for `AttorneyProfile` | `AttorneyProfile` | | [AUTO_IMPORT_INDEX_DEFAULTS](#auto_import_index_defaults) | Oracle | [unqualified]** | R | Backing store for `AutoImportIndexDefaults` | `AutoImportIndexDefaults` | | [BATCH_PROCESS_LOG](#batch_process_log) | Oracle | [unqualified]** | C/R/U | Backing store for `BatchProcessLog` | `BatchProcessLog` | | [BILL_SERVICE_CODE](#bill_service_code) | Oracle | [unqualified]** | R | Backing store for `BillService` | `BillService` | | [BILL_SERVICE_FEE](#bill_service_fee) | Oracle | [unqualified]** | R | Backing store for `BillServiceFee` | `BillServiceFee` | | [BILL_SERVICE_RATE_TYPE_CODE](#bill_service_rate_type_code) | Oracle | [unqualified]** | R | Backing store for `BillServiceRateType` | `BillServiceRateType` | | [BILL_STATUS_CODE](#bill_status_code) | Oracle | [unqualified]** | R | Backing store for `BillStatus` | `BillStatus` | | [CANCELLATION](#cancellation) | Oracle | [unqualified]** | R | Backing store for `Cancellation` | `Cancellation` | | [CASE_NOTE](#case_note) | Oracle | LEGAL | C/R/D | Backing store for `LegalNote` | `LegalNote` | | [CBP_AUDIT](#cbp_audit) | Oracle | [unqualified]** | R | Backing store for `CbpAudit`, reached via non-identifier navigation from `CbpAuditedService`/`CbpBill` | `CbpAudit` | | [CBP_AUDITED_SERVICE](#cbp_audited_service) | Oracle | [unqualified]** | R | Backing store for `CbpAuditedService` | `CbpAuditedService` | | [CBP_AUTHORIZATION](#cbp_authorization) | Oracle | [unqualified]** | C/R/D | Backing store for `CbpAuthorization` | `CbpAuthorization` | | [CBP_AUTHORIZATION_SURGERY](#cbp_authorization_surgery) | Oracle | [unqualified]** | C/R/D | Backing store for `CbpAuthorizationSurgery` | `CbpAuthorizationSurgery` | | [CBP_AUTHORIZATION_TYPE_CODE](#cbp_authorization_type_code) | Oracle | [unqualified]** | R | Backing store for `CbpAuthorizationTypeCode` | `CbpAuthorizationTypeCode` | | [CBP_BILL](#cbp_bill) | Oracle | [unqualified]** | C/R | Backing store for `CbpBill` | `CbpBill` | | [CBP_BILL_ENTRY_SOURCE_CODE](#cbp_bill_entry_source_code) | Oracle | [unqualified]** | R | Backing store for `CbpBillEntrySourceCode` | `CbpBillEntrySourceCode` | | [CBP_BILL_SERVICE](#cbp_bill_service) | Oracle | [unqualified]** | R | Backing store for `CbpBillService` | `CbpBillService` | | [CBP_BILL_STATUS_CODE](#cbp_bill_status_code) | Oracle | [unqualified]** | R | Backing store for `CbpBillStatusCode` | `CbpBillStatusCode` | | [CBP_BILL_TYPE_CODE](#cbp_bill_type_code) | Oracle | [unqualified]** | R | Backing store for `CbpBillTypeCode` | `CbpBillTypeCode` | | [CBP_DIAGNOSIS](#cbp_diagnosis) | Oracle | [unqualified]** | C/R/U | Backing store for `CbpDiagnosis` | `CbpDiagnosis` | | [CBP_DIAGNOSIS_TYPE_CODE](#cbp_diagnosis_type_code) | Oracle | [unqualified]** | R | Backing store for `CbpDiagnosisTypeCode` | `CbpDiagnosisTypeCode` | | [CBP_NOTE](#cbp_note) | Oracle | [unqualified]** | R | Backing store for `CbpNote` | `CbpNote` | | [CBP_NOTE_CATEGORY_CODE](#cbp_note_category_code) | Oracle | [unqualified]** | R | Backing store for `CbpNoteCategoryCode` | `CbpNoteCategoryCode` | | [CBP_NOTE_TYPE_CODE](#cbp_note_type_code) | Oracle | [unqualified]** | R | Backing store for `CbpNoteTypeCode`, reached via non-identifier navigation from `CbpNote` | `CbpNoteTypeCode` | | [CBP_PRESCRIBING_PROVIDER_CODE](#cbp_prescribing_provider_code) | Oracle | [unqualified]** | R | Backing store for `CbpPrescribingProviderCode` | `CbpPrescribingProviderCode` | | [CBP_PRIMARY_PROCEDURE_CODE](#cbp_primary_procedure_code) | Oracle | [unqualified]** | R | Backing store for `CbpPrimaryProcedureCode` | `CbpPrimaryProcedureCode` | | [CBP_PROCEDURE_CODE](#cbp_procedure_code) | Oracle | [unqualified]** | C/R/U | Backing store for `CbpProcedureCode` | `CbpProcedureCode` | | [CBP_SERVICE_CODE](#cbp_service_code) | Oracle | [unqualified]** | C/R/U | Backing store for `CbpServiceCode`, `CbpServiceCodeStateless` | `CbpServiceCode`, `CbpServiceCodeStateless` | | [CBP_SERVICE_DESCRIPTION](#cbp_service_description) | Oracle | [unqualified]** | C/U | Backing store for `CbpServiceDescriptionStateless` | `CbpServiceDescriptionStateless` | | [CBP_SERVICE_PM_GROUP_CODE](#cbp_service_pm_group_code) | Oracle | [unqualified]** | R | Backing store for `CbpServicePmGroupCode` | `CbpServicePmGroupCode` | | [CERTIFICATE_DETAIL](#certificate_detail) | Oracle | [unqualified]** | C/R/D | Backing store for `Certificate` | `Certificate` | | [CERTIFICATE_OTHER_COV_CODE](#certificate_other_cov_code) | Oracle | [unqualified]** | R | Backing store for `StandardOtherCoverageText` | `StandardOtherCoverageText` | | [CERTIFICATE_PREFERENCE](#certificate_preference) | Oracle | [unqualified]** | C/R | Backing store for `CertificatePreference` | `CertificatePreference` | | [CLAIM_ACTIVITY](#claim_activity) | Oracle | [unqualified]** | C/R/D | Backing store for `ClaimNote` | `ClaimNote` | | [CLAIM_ACTIVITY_CATEGORY_CODE](#claim_activity_category_code) | Oracle | [unqualified]** | R | Backing store for `ClaimNoteCategory` | `ClaimNoteCategory` | | [CLAIM_ACTIVITY_TYPE_CODE](#claim_activity_type_code) | Oracle | [unqualified]** | R | Backing store for `ClaimNoteType` | `ClaimNoteType` | | [CLAIM_TASK_GROUP_CODE](#claim_task_group_code) | Oracle | [unqualified]** | R | Backing store for `TaskGroup` | `TaskGroup` | | [CL_CLAIM_AUTH_PURPOSE_CODE](#cl_claim_auth_purpose_code) | Oracle | [unqualified]** | R | Backing store for `AuthorityPaymentApprovalTypeCode` | `AuthorityPaymentApprovalTypeCode` | | [CL_CLAIM_BUS_FUNCTION_CODE](#cl_claim_bus_function_code) | Oracle | [unqualified]** | R | Backing store for `AuthorityPaymentTypeCode` | `AuthorityPaymentTypeCode` | | [CL_CLAIM_BUS_PROCESS_CODE](#cl_claim_bus_process_code) | Oracle | [unqualified]** | R | Backing store for `AuthorityBusinessProcessCode` | `AuthorityBusinessProcessCode` | | [CL_CLAIM_EMP_BUS_FUNC_LIMIT](#cl_claim_emp_bus_func_limit) | Oracle | [unqualified]** | C/R/D | Backing store for `EmployeeAuthorityLimit` | `EmployeeAuthorityLimit` | | [CL_CLAIM_EMP_BUS_FUNC_LIM_HIST](#cl_claim_emp_bus_func_lim_hist) | Oracle | [unqualified]** | C/R | Backing store for `EmployeeAuthorityPaymentLimitHistory` | `EmployeeAuthorityPaymentLimitHistory` | | [CL_HOSTILE_WORKER_CODE](#cl_hostile_worker_code) | Oracle | [unqualified]** | R | Backing store for `HostileWorkerCode` | `HostileWorkerCode` | | [CL_INJURY_CLAIM](#cl_injury_claim) | Oracle | [unqualified]** | R | Backing store for `InjuryClaim` | `InjuryClaim` | | [CL_PAYMENT_SPCL_HANDLING_CODE](#cl_payment_spcl_handling_code) | Oracle | [unqualified]** | R | Backing store for `SpecialHandlingCode` | `SpecialHandlingCode` | | [CL_PHARMACY_DAW_CODE](#cl_pharmacy_daw_code) | Oracle | [unqualified]** | R | Backing store for `PharmacyDispenseAsWrittenCode` | `PharmacyDispenseAsWrittenCode` | | [CL_PHARMACY_ELIGIBILITY_REPORT](#cl_pharmacy_eligibility_report) | Oracle | [unqualified]** | R/U | Backing store for `PharmacyEligibilityReport` | `PharmacyEligibilityReport` | | [CL_PHARMACY_ELIG_STATUS_CODE](#cl_pharmacy_elig_status_code) | Oracle | [unqualified]** | R | Backing store for `PharmacyEligibilityStatusCode` | `PharmacyEligibilityStatusCode` | | [CL_SECURITY_OVERRIDE](#cl_security_override) | Oracle | [unqualified]** | C/R/D | Backing store for `SecurityOverride` | `SecurityOverride` | | [COMPANY](#company) | Oracle | [unqualified]** | R | Referenced via native SQL join in `InvestigationRepositoryExtensions.GetSubjectName` (no NHibernate `ClassMap`; accessed only through hand-written `CreateSqlQuery` text) | `FraudInvestigationService` | | [CONTEXT_CODE](#context_code) | Oracle | [unqualified]** | R | Backing store for `ContextCode` | `ContextCode` | | [COUNTY](#county) | Oracle | [unqualified]** | R | Backing store for `County` | `County` | | [CREDIT_REP_USER](#credit_rep_user) | Oracle | [unqualified]** | R | Backing store for `CreditRepUser` | `CreditRepUser` | | [CSGSEV_CLM_SGMNTN_ACTIONS_SENT](#csgsev_clm_sgmntn_actions_sent) | Oracle | [unqualified]** | R | Backing store for `ClaimSeverityModelActivity` | `ClaimSeverityModelActivity` | | [DCBS_OREGON_BUSINESS](#dcbs_oregon_business) | Oracle | WCIS_DBA (explicit qualifier in Table()) | C | Backing store for `OregonBusiness` | `OregonBusiness` | | [DEPT_REVENUE_SOIL_ADJUSTMENT](#dept_revenue_soil_adjustment) | Oracle | [unqualified]** | R | Backing store for `DeptRevenueSoilAdjustment` | `DeptRevenueSoilAdjustment` | | [DEPT_REVENUE_SOIL_BALANCE](#dept_revenue_soil_balance) | Oracle | [unqualified]** | C | Backing store for `DeptRevenueSoilBalance` | `DeptRevenueSoilBalance` | | [DOCUMENT_DISTRIBUTION_LOG](#document_distribution_log) | Oracle | [unqualified]** | C/R/D | Backing store for `DocumentDistributionLog`, `DocumentDistributionLogRequest`, `DocumentDistributionLogStatusOnly` | `DocumentDistributionLog`, `DocumentDistributionLogRequest`, `DocumentDistributionLogStatusOnly` | | [DOCUMENT_IMAGING_ERROR](#document_imaging_error) | Oracle | CLM_DBA | C/R/D | Backing store for `DocumentImagingError` | `DocumentImagingError` | | [DOCUMENT_OPTION_CODE](#document_option_code) | Oracle | [unqualified]** | R | Backing store for `DocumentOptionCode` | `DocumentOptionCode` | | [DOCUMENT_OP_CODE](#document_op_code) | Oracle | [unqualified]** | R | Backing store for `DocumentOutputProfileCode` | `DocumentOutputProfileCode` | | [DOCUMENT_REQUEST_LOG](#document_request_log) | Oracle | [unqualified]** | C/R/D | Backing store for `DocumentRequestLog` | `DocumentRequestLog` | | [DOCUMENT_TEMPLATE](#document_template) | Oracle | [unqualified]** | C/R/D | Backing store for `DocumentTemplate` | `DocumentTemplate` | | [DOCUMENT_TEMPLATE_OP](#document_template_op) | Oracle | [unqualified]** | C/R/D | Backing store for `DocumentTemplateOutputProfile` | `DocumentTemplateOutputProfile` | | [DOCUMENT_TEMPLATE_OPTION](#document_template_option) | Oracle | [unqualified]** | C/R/D | Backing store for `DocumentTemplateOption` | `DocumentTemplateOption` | | [DOC_REQUEST_LOG_STATUS_CODE](#doc_request_log_status_code) | Oracle | [unqualified]** | R | Backing store for `DocRequestLogStatusCode` | `DocRequestLogStatusCode` | | [DocumentImageTypeCode](#documentimagetypecode) | Oracle | [unqualified]** | R | Backing store for `DocumentImageTypeCode`, accessed via `IUnitOfWork.GetRepository()`; the backing table name itself could not be confirmed by static analysis or Legends — the C# entity name is used in its place per the translation skill's "never invent a table name" rule | `DocumentImageTypeCode` | | [DocumentRequestParameter](#documentrequestparameter) | Oracle | [unqualified]** | C/R | Backing store for `DocumentRequestParameter`, accessed via `IUnitOfWork.GetRepository()`; no `ClassMap` exists in this repository or the external mapping package queried via Legends, so the backing table name is unconfirmed and the C# entity name is used in its place | `DocumentRequestParameter` | | [DocumentTemplateParameter](#documenttemplateparameter) | Oracle | [unqualified]** | R | Backing store for `DocumentTemplateParameter`, accessed via `IUnitOfWork.GetRepository()`; no `ClassMap` exists in this repository or the external mapping package queried via Legends, so the backing table name is unconfirmed and the C# entity name is used in its place | `DocumentTemplateParameter` | | [EBILL_INVOICE](#ebill_invoice) | Oracle | [unqualified]** | C/D | Backing store for `EbillInvoice` | `EbillInvoice` | | [EBILL_INVOICE_BILL](#ebill_invoice_bill) | Oracle | [unqualified]** | D | Backing store for `EbillInvoiceBill` | `EbillInvoiceBill` | | [EBILL_INVOICE_ERROR](#ebill_invoice_error) | Oracle | [unqualified]** | D | Backing store for `EbillInvoiceError` | `EbillInvoiceError` | | [EDI_AUDITED_SERVICE_OVERRIDE](#edi_audited_service_override) | Oracle | [unqualified]** | C/R/D | Backing store for `AuditedServiceOverride` | `AuditedServiceOverride` | | [EDI_BILL_OVERRIDE](#edi_bill_override) | Oracle | [unqualified]** | C/R/D | Backing store for `BillOverride` | `BillOverride` | | [EDI_FILE](#edi_file) | Oracle | OPS$JIMMIL | C/R/D | Backing store for `EdiFile` | `EdiFile` | | [EMPLOYERS_LIABILITY_FACTORS](#employers_liability_factors) | Oracle | [unqualified]** | R | Backing store for `EmployerLiabilityFactors` | `EmployerLiabilityFactors` | | [EMPLOYERS_LIABILITY_LIMITS](#employers_liability_limits) | Oracle | [unqualified]** | R | Backing store for `EmployerLiabilityLimit` | `EmployerLiabilityLimit` | | [ERROR_ENVIRONMENT](#error_environment) | Oracle | [unqualified]** | R | Backing store for `ErrorEnvironment` | `ErrorEnvironment` | | [ERROR_GROUP_CODE](#error_group_code) | Oracle | [unqualified]** | R | Backing store for `ErrorGroupCode` | `ErrorGroupCode` | | [ERROR_GROUP_ENVIRONMENT](#error_group_environment) | Oracle | [unqualified]** | R | Backing store for `ErrorGroupEnvironment` | `ErrorGroupEnvironment` | | [EXT_USER_DOC_NOTIFY](#ext_user_doc_notify) | Oracle | [unqualified]** | C/R/D | Backing store for `DocumentNotification` | `DocumentNotification` | | [FILE_REQUEST](#file_request) | Oracle | [unqualified]** | R | Backing store for `FileRequest` | `FileRequest` | | [GROUP_ASSOCIATION](#group_association) | Oracle | [unqualified]** | R | Backing store for `GroupAssociation` | `GroupAssociation` | | [HEARING_LOCATION](#hearing_location) | Oracle | [unqualified]** | R | Backing store for `HearingLocation` | `HearingLocation` | | [IMAGE](#image) | Oracle | [unqualified]** | R | Backing store for `Image`, accessed via `IUnitOfWork.GetRepository()` | `Image` | | [IMAGE_AGENCY](#image_agency) | Oracle | [unqualified]** | C/R | Backing store for `ImageAgency` | `ImageAgency` | | [IMAGE_CATEGORY_CODE](#image_category_code) | Oracle | [unqualified]** | R | Backing store for `ImageCategoryCode`, accessed via `IUnitOfWork.GetRepository()` | `ImageCategoryCode` | | [IMAGE_DOCUMENT_TYPE_CODE](#image_document_type_code) | Oracle | [unqualified]** | R | Backing store for `ImageDocumentTypeCode`, accessed via `IUnitOfWork.GetRepository()` | `ImageDocumentTypeCode` | | [INTEREST_CALC_OPTION_CODE](#interest_calc_option_code) | Oracle | [unqualified]** | R | Backing store for `InterestCalcCode` | `InterestCalcCode` | | [INTEREST_RATE_VALUE](#interest_rate_value) | Oracle | [unqualified]** | R | Backing store for `InterestRateValue` | `InterestRateValue` | | [INVESTIGATION](#investigation) | Oracle | [unqualified]** | R | Backing store for `Investigation` | `Investigation` | | [JUDGEMENT_YEARS_VALUE](#judgement_years_value) | Oracle | [unqualified]** | R | Backing store for `JudgmentYearsValue` | `JudgmentYearsValue` | | [JUDGMENT_CODE](#judgment_code) | Oracle | [unqualified]** | R | Backing store for `JudgmentCode` | `JudgmentCode` | | [LC_POLICY_SERVICE_PLAN](#lc_policy_service_plan) | Oracle | [unqualified]** | C/R/U | Backing store for `RctPolicyServicePlan` | `RctPolicyServicePlan` | | [LC_SERVICE_PLAN_CODE](#lc_service_plan_code) | Oracle | [unqualified]** | R | Backing store for `RctServicePlanCode` | `RctServicePlanCode` | | [LC_TRAN_CATEGORY_CODE](#lc_tran_category_code) | Oracle | [unqualified]** | R | Backing store for `TransactionCategoryCode` | `TransactionCategoryCode` | | [LEGAL_BILL](#legal_bill) | Oracle | [unqualified]** | C/R/D | Backing store for `LegalBill` | `LegalBill` | | [LEGAL_BILL_SERVICE](#legal_bill_service) | Oracle | [unqualified]** | R | Backing store for `LegalBillService` | `LegalBillService` | | [LEGAL_CASE](#legal_case) | Oracle | [unqualified]** | R | Backing store for `LegalCase` | `LegalCase` | | [LEGAL_COLLECTION](#legal_collection) | Oracle | [unqualified]** | C/R | Backing store for `Case` | `Case` | | [LEGAL_COLLECTION_ACTIVITY](#legal_collection_activity) | Oracle | [unqualified]** | R/D | Backing store for `Activity` | `Activity` | | [LEGAL_COLLECTION_BATCH_CONTROL](#legal_collection_batch_control) | Oracle | [unqualified]** | R | Backing store for `BatchControl` | `BatchControl` | | [LEGAL_COLLECTION_CASH_RECEIPTS](#legal_collection_cash_receipts) | Oracle | [unqualified]** | R | Backing store for `CashReceipts` | `CashReceipts` | | [LEGAL_COLLECTION_CODE](#legal_collection_code) | Oracle | [unqualified]** | R | Backing store for `CollectionCode` | `CollectionCode` | | [LEGAL_COLLECTION_DEBTOR](#legal_collection_debtor) | Oracle | [unqualified]** | C/R/D | Backing store for `Debtor` | `Debtor` | | [LEGAL_COLLECTION_NOTE](#legal_collection_note) | Oracle | [unqualified]** | C/R/D | Backing store for `Note` | `Note` | | [LEGAL_COLLECTION_PAYMENT_REF](#legal_collection_payment_ref) | Oracle | [unqualified]** | R | Backing store for `PaymentRef` | `PaymentRef` | | [LEGAL_COLLECTION_STATUS_CODE](#legal_collection_status_code) | Oracle | [unqualified]** | R | Backing store for `StatusCode` | `StatusCode` | | [LEGAL_COLLECTION_TRANSACTION](#legal_collection_transaction) | Oracle | [unqualified]** | C/R/D | Backing store for `Transaction` | `Transaction` | | [LEGAL_COLLECTION_TRAN_CODE](#legal_collection_tran_code) | Oracle | [unqualified]** | R | Backing store for `TransactionCode` | `TransactionCode` | | [LEGAL_COLL_ACTIVITY_CODE](#legal_coll_activity_code) | Oracle | [unqualified]** | R | Backing store for `ActivityCode` | `ActivityCode` | | [LEGAL_PERSON](#legal_person) | Oracle | [unqualified]** | C | Backing store for `LegalPerson` | `LegalPerson` | | [LOCATION](#location) | Oracle | [unqualified]** | C/R/D | Backing store for `Location` | `Location` | | [MEDICARE_BENEFICIARY_QUERY](#medicare_beneficiary_query) | Oracle | [unqualified]** | D | Backing store for `MedicareBeneficiaryQuery` | `MedicareBeneficiaryQuery` | | [MEDICARE_BENEFICIARY_QUERY_BAT](#medicare_beneficiary_query_bat) | Oracle | [unqualified]** | D | Backing store for `MedicareBeneficiaryQueryBatch` | `MedicareBeneficiaryQueryBatch` | | [MEDICARE_QUERY_HISTORY](#medicare_query_history) | Oracle | [unqualified]** | C/U | Backing store for `MedicareQueryHistory` | `MedicareQueryHistory` | | [NOTE_CATEGORY_CODE](#note_category_code) | Oracle | [unqualified]** | R | Backing store for `LegalNoteCategory` | `LegalNoteCategory` | | [OB_DOC_TYPE](#ob_doc_type) | Oracle | [unqualified]** | R | Backing store for `DocType`, reached via non-identifier navigation from `OnBaseNotificationRuleMatrix` | `OnBaseNotificationRuleMatrix` | | [OB_NOTIFICATION_MATRIX](#ob_notification_matrix) | Oracle | [unqualified]** | R | Backing store for `NotificationMatrix`, reached via non-identifier navigation from `OnBaseNotificationRuleMatrix` | `OnBaseNotificationRuleMatrix` | | [OB_NOTIFY_RULE_MATRX_X](#ob_notify_rule_matrx_x) | Oracle | [unqualified]** | R | Backing store for `OnBaseNotificationRuleMatrix` | `OnBaseNotificationRuleMatrix` | | [OFFICE_CODE](#office_code) | Oracle | [unqualified]** | R | Backing store for `OfficeCode` | `OfficeCode` | | [ONLINE_MESSAGE](#online_message) | Oracle | [unqualified]** | R | Backing store for `OnlineMessages` | `OnlineMessages` | | [ONLINE_MESSAGE_APP_CODE](#online_message_app_code) | Oracle | [unqualified]** | R | Backing store for `ApplicationCode` | `ApplicationCode` | | [ONLINE_MESSAGE_PRIORITY_CODE](#online_message_priority_code) | Oracle | [unqualified]** | R | Backing store for `OnlineMessagePriority` | `OnlineMessagePriority` | | [ONLINE_USER_TYPE_CODE](#online_user_type_code) | Oracle | [unqualified]** | R | Backing store for `OnlineUserType` | `OnlineUserType` | | [OSC_POLICY_PERIOD](#osc_policy_period) | Oracle | [unqualified]** | R | Backing store for `OtherStatesPolicyPeriod` | `OtherStatesPolicyPeriod` | | [OSC_POLICY_VIEW](#osc_policy_view) | Oracle | [unqualified]** | R | Backing store for `OtherStatesPolicy` | `OtherStatesPolicy` | | [OUTPUT_DOCUMENT](#output_document) | Oracle | [unqualified]** | R | Backing store for `OutputDocument` | `OutputDocument` | | [OUTPUT_DOCUMENT_TYPE_CODE](#output_document_type_code) | Oracle | [unqualified]** | R | Backing store for `OutputDocumentTypeCode`, `OutputDocumentTypeCodeStateless` | `OutputDocumentTypeCode`, `OutputDocumentTypeCodeStateless` | | [OUTPUT_DOC_NOTIFY_TEXT_CODE](#output_doc_notify_text_code) | Oracle | [unqualified]** | R | Backing store for `OutputDocumentNotifyTextCode` | `OutputDocumentNotifyTextCode` | | [OUTPUT_LOG](#output_log) | Oracle | [unqualified]** | R | Backing store for `OutputLog` | `OutputLog` | | [PAYMENT_TRANSACTION_TYPE_CODE](#payment_transaction_type_code) | Oracle | [unqualified]** | R | Backing store for `PaymentTransactionTypeCode` | `PaymentTransactionTypeCode` | | [PERSON](#person) | Oracle | [unqualified]** | R | Referenced via native SQL join in `InvestigationRepositoryExtensions.GetSubjectName` (no NHibernate `ClassMap`; accessed only through hand-written `CreateSqlQuery` text) | `FraudInvestigationService` | | [POLICY](#policy) | Oracle | [unqualified]** | R | Backing store for `Policy` | `Policy` | | [POLICY_OUTPUT_DOCUMENT](#policy_output_document) | Oracle | [unqualified]** | C/R | Backing store for `PolicyOutputDocument` | `PolicyOutputDocument` | | [POLICY_PERIOD_COVERAGE_BIND](#policy_period_coverage_bind) | Oracle | [unqualified]** | R | Backing store for `PolicyPeriodCoverageBind` | `PolicyPeriodCoverageBind` | | [POLICY_RELATIONSHIP](#policy_relationship) | Oracle | [unqualified]** | R | Backing store for `PolicyRelationship` | `PolicyRelationship` | | [POLICY_TEAM_FUNCTION](#policy_team_function) | Oracle | [unqualified]** | R | Backing store for `PolicyTeamFunction` | `PolicyTeamFunction` | | [POSITIVE_PAY_VIEW](#positive_pay_view) | Oracle | WCIS_DBA (explicit qualifier in Table()) | R | Backing store for `PositivePayView` | `PositivePayView` | | [PROCESS_SERVER](#process_server) | Oracle | [unqualified]** | R | Backing store for `ProcessServer` | `ProcessServer` | | [PROVIDER_ADDRESS](#provider_address) | Oracle | [unqualified]** | C/R/U/D | Backing store for `BatchProviderAddress` | `BatchProviderAddress` | | [PROVIDER_LOCATION](#provider_location) | Oracle | [unqualified]** | R | Backing store for `ProviderLocation` | `ProviderLocation` | | [PURCHASEORDERCOMMENTS](#purchaseordercomments) | Oracle | [unqualified]** | R | Backing store for `PurchaseOrderComment` | `PurchaseOrderComment` | | [PURCHASEORDERLINECOMMENTS](#purchaseorderlinecomments) | Oracle | INFR_DBA (explicit qualifier in Table()) | R | Backing store for `PurchaseOrderLineComment` | `PurchaseOrderLineComment` | | [PURCHASEORDERSVIEW](#purchaseordersview) | Oracle | [unqualified]** | R | Backing store for `PurchaseOrder` | `PurchaseOrder` | | [RCT_POLICIES_TO_TRANSMIT](#rct_policies_to_transmit) | Oracle | [unqualified]** | C/R/U/D | Backing store for `RctPolicyToTransmit` | `RctPolicyToTransmit` | | [RCT_POLICY_SELECTED](#rct_policy_selected) | Oracle | [unqualified]** | C/R/U | Backing store for `RctPolicySelected` | `RctPolicySelected` | | [RCT_STAGING_POLICY](#rct_staging_policy) | Oracle | [unqualified]** | C/R/D | Backing store for `RctPolicyStagingData` | `RctPolicyStagingData` | | [RCT_STAGING_POLICY_LOCATION](#rct_staging_policy_location) | Oracle | [unqualified]** | C/R/D | Backing store for `RctLocationStagingData` | `RctLocationStagingData` | | [REGISTERED_AGENT](#registered_agent) | Oracle | [unqualified]** | R | Backing store for `RegisteredAgent` | `RegisteredAgent` | | [RTW_CASE](#rtw_case) | Oracle | [unqualified]** | R | Backing store for `RTWCase` | `RTWCase` | | [RTW_LOAD_ASSIGNMENT](#rtw_load_assignment) | Oracle | [unqualified]** | R | Backing store for `RtwLoadAssignment` | `RtwLoadAssignment` | | [RUN_TYPE_CODE](#run_type_code) | Oracle | [unqualified]** | R | Backing store for `RunTypeCode` | `RunTypeCode` | | [SUBJECT](#subject) | Oracle | [unqualified]** | R | Referenced via native SQL join in `InvestigationRepositoryExtensions.GetSubjectName`/`GetClaimId` (no NHibernate `ClassMap`; accessed only through hand-written `CreateSqlQuery` text) | `FraudInvestigationService` | | [SUBPOENA](#subpoena) | Oracle | [unqualified]** | C/R/D | Backing store for `Subpoena` | `Subpoena` | | [SUBPOENA_RECIPIENT](#subpoena_recipient) | Oracle | [unqualified]** | R | Backing store for `Recipient` | `Recipient` | | [SUBPOENA_SPECIAL_HANDLING_CODE](#subpoena_special_handling_code) | Oracle | [unqualified]** | R | Backing store for `SubpoenaSpecialHandling` | `SubpoenaSpecialHandling` | | [SUBPOENA_STATUS_CODE](#subpoena_status_code) | Oracle | [unqualified]** | R | Backing store for `SubpoenaStatus` | `SubpoenaStatus` | | [SUBPOENA_TYPE_CODE](#subpoena_type_code) | Oracle | [unqualified]** | R | Backing store for `SubpoenaType` | `SubpoenaType` | | [SYSTEM_USER](#system_user) | Oracle | [unqualified]** | R | Backing store for `SystemUser` | `SystemUser` | | [SYSTEM_USER_XREF](#system_user_xref) | Oracle | [unqualified]** | R | Backing store for `SystemUserRef` | `SystemUserRef` | | [TASK](#task) | Oracle | [unqualified]** | C/R | Backing store for `Task` | `Task` | | [TASK_ACTION_CODE](#task_action_code) | Oracle | [unqualified]** | R | Backing store for `TaskAction` | `TaskAction` | | [TASK_CATEGORY_CODE](#task_category_code) | Oracle | [unqualified]** | R | Backing store for `TaskCategory` | `TaskCategory` | | [TASK_PRIORITY_CODE](#task_priority_code) | Oracle | [unqualified]** | R | Backing store for `TaskPriority` | `TaskPriority` | | [TASK_SOURCE_CODE](#task_source_code) | Oracle | [unqualified]** | R | Backing store for `TaskSource` | `TaskSource` | | [TEMP_DATA_PERSON_ADDRESS](#temp_data_person_address) | Oracle | CLM_DBA (explicit qualifier in Table()) | C/R/D | Backing store for `TempDataPersonAddress` | `TempDataPersonAddress` | | [THRDPARTY](#thrdparty) | Oracle | [unqualified]** | R | Backing store for `ThirdParty` | `ThirdParty` | | [THRDPARTY_CASE](#thrdparty_case) | Oracle | [unqualified]** | R | Backing store for `ThirdPartyCase` | `ThirdPartyCase` | | [TRADING_AS](#trading_as) | Oracle | [unqualified]** | R | Backing store for `TradingAs` | `TradingAs` | | [USER_PREFERENCE](#user_preference) | Oracle | [unqualified]** | C | Backing store for `Preference`, accessed via `IUnitOfWork.GetRepository()` | `Preference` | | [WCIS_EMPLOYEE](#wcis_employee) | Oracle | [unqualified]** | R | Backing store for `WcisEmployee`, accessed via `IUnitOfWork.GetRepository()` | `WcisEmployee` | | [WRITEOFF_APPROVAL_USER](#writeoff_approval_user) | Oracle | [unqualified]** | R | Backing store for `WriteOffApprovalUser` | `WriteOffApprovalUser` | | [XDEFERRED_PRINT](#xdeferred_print) | Oracle | [unqualified]** | R | Backing store for `XDeferredPrint` | `XDeferredPrint` | | [XDOCUMENT](#xdocument) | Oracle | [unqualified]** | C | Backing store for `XDocument`, accessed via `IUnitOfWork.GetRepository()` | `XDocument` | | [XPRINT_CONTROL](#xprint_control) | Oracle | [unqualified]** | C | Backing store for `XPrintControl`, accessed via `IUnitOfWork.GetRepository()` | `XPrintControl` | ## ADJUSTMENT_REASON_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `AdjustmentReason`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_BILL_SERVICE | | **Business objects** | `AdjustmentReason` | ### SQL referencing ADJUSTMENT_REASON_CODE - [SQL-072: SaveBillServices](sql/SQL-072-save-bill-services-adjustment-reason.md) - [SQL-073: ListOfAdjustmentReasons (property)](sql/SQL-073-list-of-adjustment-reasons-adjustment-reason.md) --- ## ADP_EMPLOYEE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Employee`, accessed via non-identifier navigation from `AttorneyProfile`, `CreditRepUser`, `WriteOffApprovalUser`, and `EmployeeAuthorityLimit`/`EmployeeAuthorityPaymentLimitHistory`, and directly via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (external `EmployeeMap` in `SAIF.Framework.Data.NHibernate`) — table name confirmed via Legends CLI; most column mappings unresolved | | **CRUD operations** | Read | | **Key columns used** | EMPLID, RPT_MGR_EMPLID (confirmed); remaining columns unresolved — see linked SQL documents** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `Employee` | ### SQL referencing ADP_EMPLOYEE - [SQL-084: LegalAttorneyList (property)](sql/SQL-084-legal-attorney-list-attorney-profile.md) - [SQL-150: GetCreditReps](sql/SQL-150-get-credit-reps-credit-rep-user.md) - [SQL-174: IsActiveEmployeeUserId](sql/SQL-174-is-active-employee-user-id-employee.md) - [SQL-175: GetApproverMailId](sql/SQL-175-get-approver-mail-id-employee.md) - [SQL-176: GetPendingBills, LegalSupportEmployeeList](sql/SQL-176-get-pending-bills-employee.md) - [SQL-177: GetTerminatedAuthorities](sql/SQL-177-get-terminated-authorities-employee.md) - [SQL-178: HasSecurityOverride](sql/SQL-178-has-security-override-employee.md) - [SQL-179: SetAdditionalProperties, CreateOverride](sql/SQL-179-create-override-employee.md) - [SQL-180: ValidateMailId](sql/SQL-180-validate-mail-id-employee.md) - [SQL-181: GenerateRecipientCashRequest, SetAttorneyInfo, SetCurrentUserValues](sql/SQL-181-generate-recipient-cash-request-employee.md) - [SQL-182: GetApproverEmailAddress, InitializeLabel](sql/SQL-182-get-approver-email-address-employee.md) - [SQL-183: GetApproverMailId](sql/SQL-183-get-approver-mail-id-employee-2.md) - [SQL-184: GetInboxItems, InitiateEmployeeList](sql/SQL-184-get-inbox-items-employee.md) - [SQL-186: AddEditAuthorityLimit, GetAuthorityLimits, GetExpiredAuthorities, GetTerminatedAuthorities, TryGetEmployeeAuthorityLimit](sql/SQL-186-add-edit-authority-limit-employee-authority-limit.md) - [SQL-347: GetWriteOffApprovalUsers](sql/SQL-347-get-write-off-approval-users-write-off-approval-user.md) --- ## ADP_EMPLOYEE_FEED | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `AdpEmployeeFeed`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `AdpEmployeeFeed` | ### SQL referencing ADP_EMPLOYEE_FEED - [SQL-074: ExtractUsers](sql/SQL-074-extract-users-adp-employee-feed.md) --- ## AGENCY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Agency`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | AGENCY_SEQ | | **Related tables** | AGENCY_CONTRACT, AGENT, EXT_USER_DOC_NOTIFY, IMAGE_AGENCY, TEAM_FUNCTION_AGENCY | | **Business objects** | `Agency` | ### SQL referencing AGENCY - [SQL-075: AgencyQuery (property)](sql/SQL-075-agency-query-agency.md) - [SQL-076: GetAgency](sql/SQL-076-get-agency-agency.md) - [SQL-077: GenerateDirectWriterNotifications](sql/SQL-077-generate-direct-writer-notifications-agency.md) --- ## AGENCY_PAPERLESS_UPDATE_VIEW | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `AgencyPaperless`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | AGENCY_SEQ | | **Related tables** | None identified | | **Business objects** | `AgencyPaperless` | ### SQL referencing AGENCY_PAPERLESS_UPDATE_VIEW - [SQL-078: AgencyPaperlessQuery (property)](sql/SQL-078-agency-paperless-query-agency-paperless.md) --- ## AGENT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Agent`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | AGENCY, LOCATION, OSC_POLICY_VIEW, POLICY | | **Business objects** | `Agent` | ### SQL referencing AGENT - [SQL-079: ProducerQuery (property)](sql/SQL-079-producer-query-agent.md) - [SQL-080: GetAgentData](sql/SQL-080-get-agent-data-agent.md) - [SQL-081: AgencyBookList (property), GetAgencyIdForProducer](sql/SQL-081-agency-book-list-agent.md) --- ## APP_ERROR | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ErrorLog`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ErrorLog` | ### SQL referencing APP_ERROR - [SQL-195: ApplicationNames (property), GetErrorLogEntry, GetErrorLogs](sql/SQL-195-application-names-error-log.md) --- ## ATTORNEY_PROFILE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `AttorneyProfile`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `AttorneyProfile` | ### SQL referencing ATTORNEY_PROFILE - [SQL-083: GetAttorneysWithPendingLegalBills](sql/SQL-083-get-attorneys-with-pending-legal-bills-attorney-profile.md) - [SQL-084: LegalAttorneyList (property)](sql/SQL-084-legal-attorney-list-attorney-profile.md) - [SQL-085: SetAttorneyInfo](sql/SQL-085-set-attorney-info-attorney-profile.md) --- ## AUTO_IMPORT_INDEX_DEFAULTS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `AutoImportIndexDefaults`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `AutoImportIndexDefaults` | ### SQL referencing AUTO_IMPORT_INDEX_DEFAULTS - [SQL-090: GenerateIdxFile](sql/SQL-090-generate-idx-file-auto-import-index-defaults.md) --- ## BATCH_PROCESS_LOG | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `BatchProcessLog`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Update | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `BatchProcessLog` | ### SQL referencing BATCH_PROCESS_LOG - [SQL-002: UpdateRunDate](sql/SQL-002-update-run-date-batch-process-log.md) - [SQL-092: GetSingleRecord](sql/SQL-092-get-single-record-batch-process-log.md) - [SQL-349: UpdateRunDate](sql/SQL-349-update-run-date-batch-process-log-2.md) --- ## BILL_SERVICE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `BillService`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_BILL_SERVICE | | **Business objects** | `BillService` | ### SQL referencing BILL_SERVICE_CODE - [SQL-095: SaveBillServices](sql/SQL-095-save-bill-services-bill-service.md) - [SQL-096: ListOfBillServiceCodes (property)](sql/SQL-096-list-of-bill-service-codes-bill-service.md) - [SQL-097: GetSpendCategory](sql/SQL-097-get-spend-category-bill-service.md) --- ## BILL_SERVICE_FEE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `BillServiceFee`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `BillServiceFee` | ### SQL referencing BILL_SERVICE_FEE - [SQL-098: GetBillServiceFee](sql/SQL-098-get-bill-service-fee-bill-service-fee.md) - [SQL-099: GetImeBillServiceFees, GetMcoBillServiceFees](sql/SQL-099-get-ime-bill-service-fees-bill-service-fee.md) --- ## BILL_SERVICE_RATE_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `BillServiceRateType`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_BILL_SERVICE | | **Business objects** | `BillServiceRateType` | ### SQL referencing BILL_SERVICE_RATE_TYPE_CODE - [SQL-100: SaveBillServices](sql/SQL-100-save-bill-services-bill-service-rate-type.md) - [SQL-101: ListOfBillRateTypeCodes (property)](sql/SQL-101-list-of-bill-rate-type-codes-bill-service-rate-type.md) --- ## BILL_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `BillStatus`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_BILL | | **Business objects** | `BillStatus` | ### SQL referencing BILL_STATUS_CODE - [SQL-102: SetNewBillStatus](sql/SQL-102-set-new-bill-status-bill-status.md) - [SQL-103: SaveLegalBill](sql/SQL-103-save-legal-bill-bill-status.md) - [SQL-104: ListOfBillStatusCodes (property)](sql/SQL-104-list-of-bill-status-codes-bill-status.md) --- ## CANCELLATION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Cancellation`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `Cancellation` | ### SQL referencing CANCELLATION - [SQL-105: GetPendingCancelDateForPolicy](sql/SQL-105-get-pending-cancel-date-for-policy-cancellation.md) --- ## CASE_NOTE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | LEGAL | | **Purpose** | Backing store for `LegalNote`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | CASE_NOTE_SEQ | | **Related tables** | LEGAL_CASE, NOTE_CATEGORY_CODE | | **Business objects** | `LegalNote` | ### SQL referencing CASE_NOTE - [SQL-034: CreateNote](sql/SQL-034-create-note-legal-note.md) - [SQL-035: CreateTaskNote](sql/SQL-035-create-task-note-legal-note.md) - [SQL-228: DeleteNote, GetNoteData, GetNotes](sql/SQL-228-delete-note-legal-note.md) - [SQL-383: DeleteNote](sql/SQL-383-delete-note-legal-note-2.md) --- ## CBP_AUDIT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpAudit`, reached via non-identifier navigation from `CbpAuditedService`/`CbpBill` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | BILL_ID | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `CbpAudit` | ### SQL referencing CBP_AUDIT - [SQL-111: GetBillAmounts](sql/SQL-111-get-bill-amounts-cbp-audited-service.md) - [SQL-117: GetBillAmounts](sql/SQL-117-get-bill-amounts-cbp-bill.md) --- ## CBP_AUDITED_SERVICE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpAuditedService`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CBP_AUDITED_SERVICE_ADJUSTMENT, CBP_BILL, CBP_ORIGINAL_BILL_CODE, CL_PAYMENT_CATEGORY_CODE, EBILL_EOB_ADJUSTMENT, EBILL_EOB_REMITTANCE_ADVICE, PROVIDER_LOCATION | | **Business objects** | `CbpAuditedService` | ### SQL referencing CBP_AUDITED_SERVICE - [SQL-111: GetBillAmounts](sql/SQL-111-get-bill-amounts-cbp-audited-service.md) --- ## CBP_AUTHORIZATION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpAuthorization`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | CBP_AUTHORIZATION_SEQ | | **Related tables** | CBP_AUTHORIZATION_CPT, CBP_AUTHORIZATION_TYPE_CODE, CBP_SERVICE_PM_GROUP_CODE, PROVIDER_LOCATION | | **Business objects** | `CbpAuthorization` | ### SQL referencing CBP_AUTHORIZATION - [SQL-006: CreateAuthorization](sql/SQL-006-create-authorization-cbp-authorization.md) - [SQL-112: DeleteAuthorization, GetAuthorizations, UpdateAuthorization](sql/SQL-112-delete-authorization-cbp-authorization.md) - [SQL-364: DeleteAuthorization](sql/SQL-364-delete-authorization-cbp-authorization-2.md) --- ## CBP_AUTHORIZATION_SURGERY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpAuthorizationSurgery`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `CbpAuthorizationSurgery` | ### SQL referencing CBP_AUTHORIZATION_SURGERY - [SQL-007: AddSurgeryDate](sql/SQL-007-add-surgery-date-cbp-authorization-surgery.md) - [SQL-113: AddSurgeryDate, DeleteSurgeryDate, GetSurgeryDates](sql/SQL-113-add-surgery-date-cbp-authorization-surgery-2.md) - [SQL-365: DeleteSurgeryDate](sql/SQL-365-delete-surgery-date-cbp-authorization-surgery.md) --- ## CBP_AUTHORIZATION_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpAuthorizationTypeCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CBP_AUTHORIZATION | | **Business objects** | `CbpAuthorizationTypeCode` | ### SQL referencing CBP_AUTHORIZATION_TYPE_CODE - [SQL-114: CreateAuthorization, GetAuthorizationTypeCodes, UpdateAuthorization](sql/SQL-114-create-authorization-cbp-authorization-type-code.md) --- ## CBP_BILL | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpBill`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | CBP_BILL_SEQ | | **Related tables** | CBP_AUDIT, CBP_AUDITED_SERVICE, CBP_BILL_DIAGNOSIS, CBP_BILL_ENTRY_SOURCE_CODE, CBP_BILL_PROCEDURE, CBP_BILL_SERVICE, CBP_BILL_STATUS, CBP_BILL_STATUS_CODE, CBP_BILL_TYPE_CODE, CBP_NOTE, PROVIDER_LOCATION | | **Business objects** | `CbpBill` | ### SQL referencing CBP_BILL - [SQL-008: BuildNewBillRecord, SaveBill](sql/SQL-008-build-new-bill-record-cbp-bill.md) - [SQL-115: CheckForDuplicateBill, GetInboxBillsByResponsiblePartyId, SaveBill, UpdateBillStatus](sql/SQL-115-check-for-duplicate-bill-cbp-bill.md) - [SQL-116: GetBillEntryBillsByCriteria, SearchByCriteria, SearchByResponsiblePartyId](sql/SQL-116-get-bill-entry-bills-by-criteria-cbp-bill.md) - [SQL-117: GetBillAmounts](sql/SQL-117-get-bill-amounts-cbp-bill.md) --- ## CBP_BILL_ENTRY_SOURCE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpBillEntrySourceCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CBP_BILL | | **Business objects** | `CbpBillEntrySourceCode` | ### SQL referencing CBP_BILL_ENTRY_SOURCE_CODE - [SQL-118: CreateNewBill](sql/SQL-118-create-new-bill-cbp-bill-entry-source-code.md) --- ## CBP_BILL_SERVICE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpBillService`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CBP_BILL, CBP_MSRP_INVOICE_CODE, CL_PHARMACY_DAW_CODE, PROVIDER_LOCATION | | **Business objects** | `CbpBillService` | ### SQL referencing CBP_BILL_SERVICE - [SQL-119: SubmitBill](sql/SQL-119-submit-bill-cbp-bill-service.md) - [SQL-120: GetChargedServicesTotal, GetServices](sql/SQL-120-get-charged-services-total-cbp-bill-service.md) --- ## CBP_BILL_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpBillStatusCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CBP_BILL | | **Business objects** | `CbpBillStatusCode` | ### SQL referencing CBP_BILL_STATUS_CODE - [SQL-121: CreateNewBill, GetBillStatusCodes, UpdateBillStatus](sql/SQL-121-create-new-bill-cbp-bill-status-code.md) - [SQL-122: GetBillStatusCodes](sql/SQL-122-get-bill-status-codes-cbp-bill-status-code.md) --- ## CBP_BILL_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpBillTypeCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CBP_BILL | | **Business objects** | `CbpBillTypeCode` | ### SQL referencing CBP_BILL_TYPE_CODE - [SQL-123: CreateNewBill, GetBillTypeCodes, UpdateBillTypeAndServices](sql/SQL-123-create-new-bill-cbp-bill-type-code.md) - [SQL-124: GetBillTypes](sql/SQL-124-get-bill-types-cbp-bill-type-code.md) --- ## CBP_DIAGNOSIS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpDiagnosis`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Update | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `CbpDiagnosis` | ### SQL referencing CBP_DIAGNOSIS - [SQL-009: InsertDiagnosis](sql/SQL-009-insert-diagnosis-cbp-diagnosis.md) - [SQL-125: GetBillDiagnosis](sql/SQL-125-get-bill-diagnosis-cbp-diagnosis.md) - [SQL-126: QueryDiagnosis](sql/SQL-126-query-diagnosis-cbp-diagnosis.md) - [SQL-351: UpdateDiagnosis](sql/SQL-351-update-diagnosis-cbp-diagnosis.md) --- ## CBP_DIAGNOSIS_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpDiagnosisTypeCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `CbpDiagnosisTypeCode` | ### SQL referencing CBP_DIAGNOSIS_TYPE_CODE - [SQL-127: CreateDiagnoses, GetDiagnosisTypeCodes, UpdateDiagnoses](sql/SQL-127-create-diagnoses-cbp-diagnosis-type-code.md) --- ## CBP_NOTE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpNote`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | CBP_NOTE_SEQ | | **Related tables** | CBP_BILL, CBP_NOTE_TYPE_CODE | | **Business objects** | `CbpNote` | ### SQL referencing CBP_NOTE - [SQL-128: GetBillNotes](sql/SQL-128-get-bill-notes-cbp-note.md) --- ## CBP_NOTE_CATEGORY_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpNoteCategoryCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CBP_NOTE_TYPE_CODE | | **Business objects** | `CbpNoteCategoryCode` | ### SQL referencing CBP_NOTE_CATEGORY_CODE - [SQL-129: GetAuditNoteCategoryCodes](sql/SQL-129-get-audit-note-category-codes-cbp-note-category-code.md) --- ## CBP_NOTE_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpNoteTypeCode`, reached via non-identifier navigation from `CbpNote` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | CODE, CBP_NOTE_CATEGORY_CODE | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `CbpNoteTypeCode` | ### SQL referencing CBP_NOTE_TYPE_CODE - [SQL-128: GetBillNotes](sql/SQL-128-get-bill-notes-cbp-note.md) --- ## CBP_PRESCRIBING_PROVIDER_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpPrescribingProviderCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `CbpPrescribingProviderCode` | ### SQL referencing CBP_PRESCRIBING_PROVIDER_CODE - [SQL-130: GetPrescribingPrescriberCodes](sql/SQL-130-get-prescribing-prescriber-codes-cbp-prescribing-provider-code.md) --- ## CBP_PRIMARY_PROCEDURE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpPrimaryProcedureCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `CbpPrimaryProcedureCode` | ### SQL referencing CBP_PRIMARY_PROCEDURE_CODE - [SQL-131: CreateProcedures, GetPrimaryProcedureCodes, UpdateProcedures](sql/SQL-131-create-procedures-cbp-primary-procedure-code.md) --- ## CBP_PROCEDURE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpProcedureCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Update | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `CbpProcedureCode` | ### SQL referencing CBP_PROCEDURE_CODE - [SQL-010: InsertProcedure](sql/SQL-010-insert-procedure-cbp-procedure-code.md) - [SQL-132: QueryProcedure](sql/SQL-132-query-procedure-cbp-procedure-code.md) - [SQL-352: UpdateProcedure](sql/SQL-352-update-procedure-cbp-procedure-code.md) --- ## CBP_SERVICE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpServiceCode`, `CbpServiceCodeStateless`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Update | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CBP_SERVICE_DESCRIPTION | | **Business objects** | `CbpServiceCode`, `CbpServiceCodeStateless` | ### SQL referencing CBP_SERVICE_CODE - [SQL-011: InsertService](sql/SQL-011-insert-service-cbp-service-code-stateless.md) - [SQL-133: ValidCptCode](sql/SQL-133-valid-cpt-code-cbp-service-code.md) - [SQL-353: UpdateService](sql/SQL-353-update-service-cbp-service-code-stateless.md) --- ## CBP_SERVICE_DESCRIPTION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpServiceDescriptionStateless`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Update | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CBP_SERVICE_CODE | | **Business objects** | `CbpServiceDescriptionStateless` | ### SQL referencing CBP_SERVICE_DESCRIPTION - [SQL-012: InsertServiceDescription](sql/SQL-012-insert-service-description-cbp-service-description-stateless.md) - [SQL-354: UpdateServiceDescription](sql/SQL-354-update-service-description-cbp-service-description-stateless.md) --- ## CBP_SERVICE_PM_GROUP_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CbpServicePmGroupCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CBP_AUTHORIZATION | | **Business objects** | `CbpServicePmGroupCode` | ### SQL referencing CBP_SERVICE_PM_GROUP_CODE - [SQL-134: CreateAuthorization, GetServiceTypeCodes, UpdateAuthorization](sql/SQL-134-create-authorization-cbp-service-pm-group-code.md) --- ## CERTIFICATE_DETAIL | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Certificate`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | CERTIFICATE_SEQUENCE | | **Related tables** | CERTIFICATE_HOLDER, EMPLOYERS_LIABILITY_LIMITS, OSC_POLICY_PERIOD, OSC_POLICY_VIEW, TRADING_AS | | **Business objects** | `Certificate` | ### SQL referencing CERTIFICATE_DETAIL - [SQL-013: AddCertificate, RenewCertificate](sql/SQL-013-add-certificate-certificate.md) - [SQL-135: GetCertificateDataById, GetCertificates, GetCertificatesReadyForBatchDistribution, GetEditableCertificates](sql/SQL-135-get-certificate-data-by-id-certificate.md) - [SQL-136: MarkCertificateAsPrinted](sql/SQL-136-mark-certificate-as-printed-certificate.md) - [SQL-366: DeleteCertificate](sql/SQL-366-delete-certificate-certificate.md) --- ## CERTIFICATE_OTHER_COV_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `StandardOtherCoverageText`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `StandardOtherCoverageText` | ### SQL referencing CERTIFICATE_OTHER_COV_CODE - [SQL-300: GetStandardOtherCoverageTexts](sql/SQL-300-get-standard-other-coverage-texts-standard-other-coverage-text.md) --- ## CERTIFICATE_PREFERENCE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CertificatePreference`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `CertificatePreference` | ### SQL referencing CERTIFICATE_PREFERENCE - [SQL-014: AddPreference](sql/SQL-014-add-preference-certificate-preference.md) - [SQL-137: GetPreferenceByPolicyNumber, GetPreferences, HasPreference](sql/SQL-137-get-preference-by-policy-number-certificate-preference.md) --- ## CLAIM_ACTIVITY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ClaimNote`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | CLAIM_ACTIVITY_SEQ | | **Related tables** | CLAIM_ACTIVITY_CATEGORY_CODE, CLAIM_ACTIVITY_TYPE_CODE | | **Business objects** | `ClaimNote` | ### SQL referencing CLAIM_ACTIVITY - [SQL-015: CreateNote](sql/SQL-015-create-note-claim-note.md) - [SQL-016: CreateTaskNote](sql/SQL-016-create-task-note-claim-note.md) - [SQL-017: CreateTaskNote](sql/SQL-017-create-task-note-claim-note-2.md) - [SQL-138: DeleteNote, GetNoteData, GetNotes](sql/SQL-138-delete-note-claim-note.md) - [SQL-367: DeleteNote](sql/SQL-367-delete-note-claim-note-2.md) --- ## CLAIM_ACTIVITY_CATEGORY_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ClaimNoteCategory`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CLAIM_ACTIVITY, CLAIM_ACTIVITY_TYPE_CODE | | **Business objects** | `ClaimNoteCategory` | ### SQL referencing CLAIM_ACTIVITY_CATEGORY_CODE - [SQL-139: CreateNote, GetCategories, GetCategoryDesc, SaveNote](sql/SQL-139-create-note-claim-note-category.md) - [SQL-140: CreateTaskNote](sql/SQL-140-create-task-note-claim-note-category.md) - [SQL-141: CreateTaskNote](sql/SQL-141-create-task-note-claim-note-category-2.md) --- ## CLAIM_ACTIVITY_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ClaimNoteType`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CLAIM_ACTIVITY, CLAIM_ACTIVITY_CATEGORY_CODE | | **Business objects** | `ClaimNoteType` | ### SQL referencing CLAIM_ACTIVITY_TYPE_CODE - [SQL-142: CreateNote, GetNoteTypeDesc, GetTypes, SaveNote](sql/SQL-142-create-note-claim-note-type.md) - [SQL-143: CreateTaskNote](sql/SQL-143-create-task-note-claim-note-type.md) - [SQL-144: CreateTaskNote](sql/SQL-144-create-task-note-claim-note-type-2.md) --- ## CLAIM_TASK_GROUP_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `TaskGroup`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | TASK | | **Business objects** | `TaskGroup` | ### SQL referencing CLAIM_TASK_GROUP_CODE - [SQL-330: GetTaskGroups](sql/SQL-330-get-task-groups-task-group.md) - [SQL-331: CreateTask, CreateTaskStateless, GetTaskGroups, ReassignTasks, UpdateTask](sql/SQL-331-create-task-task-group.md) --- ## CL_CLAIM_AUTH_PURPOSE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `AuthorityPaymentApprovalTypeCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CL_CLAIM_BUS_PROCESS_CODE | | **Business objects** | `AuthorityPaymentApprovalTypeCode` | ### SQL referencing CL_CLAIM_AUTH_PURPOSE_CODE - [SQL-088: GetApprovalTypeList](sql/SQL-088-get-approval-type-list-authority-payment-approval-type-code.md) --- ## CL_CLAIM_BUS_FUNCTION_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `AuthorityPaymentTypeCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CL_CLAIM_BUS_PROCESS_CODE, CL_CLAIM_EMP_BUS_FUNC_LIMIT, CL_CLAIM_EMP_BUS_FUNC_LIM_HIST | | **Business objects** | `AuthorityPaymentTypeCode` | ### SQL referencing CL_CLAIM_BUS_FUNCTION_CODE - [SQL-089: CreateNewAuthorityLimitFromEdit, GetFunctionTypeList](sql/SQL-089-create-new-authority-limit-from-edit-authority-payment-type-code.md) --- ## CL_CLAIM_BUS_PROCESS_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `AuthorityBusinessProcessCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CL_CLAIM_AUTH_PURPOSE_CODE, CL_CLAIM_BUS_FUNCTION_CODE, CL_CLAIM_EMP_BUS_FUNC_LIMIT, CL_CLAIM_EMP_BUS_FUNC_LIM_HIST | | **Business objects** | `AuthorityBusinessProcessCode` | ### SQL referencing CL_CLAIM_BUS_PROCESS_CODE - [SQL-087: CreateNewAuthorityLimitFromEdit](sql/SQL-087-create-new-authority-limit-from-edit-authority-business-process-code.md) --- ## CL_CLAIM_EMP_BUS_FUNC_LIMIT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `EmployeeAuthorityLimit`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | CL_CLM_EMP_BUS_FUN_LIM_SEQ | | **Related tables** | CL_CLAIM_BUS_FUNCTION_CODE, CL_CLAIM_BUS_PROCESS_CODE | | **Business objects** | `EmployeeAuthorityLimit` | ### SQL referencing CL_CLAIM_EMP_BUS_FUNC_LIMIT - [SQL-030: AddAuthorityLimit](sql/SQL-030-add-authority-limit-employee-authority-limit.md) - [SQL-185: UserAuthorityLevel](sql/SQL-185-user-authority-level-employee-authority-limit.md) - [SQL-186: AddEditAuthorityLimit, GetAuthorityLimits, GetExpiredAuthorities, GetTerminatedAuthorities, TryGetEmployeeAuthorityLimit](sql/SQL-186-add-edit-authority-limit-employee-authority-limit.md) - [SQL-187: InitiateEmployeeList](sql/SQL-187-initiate-employee-list-employee-authority-limit.md) - [SQL-381: DeleteAuthority](sql/SQL-381-delete-authority-employee-authority-limit.md) --- ## CL_CLAIM_EMP_BUS_FUNC_LIM_HIST | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `EmployeeAuthorityPaymentLimitHistory`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | CL_CLM_EMPBUSFUNLIMHIST_SEQ | | **Related tables** | CL_CLAIM_BUS_FUNCTION_CODE, CL_CLAIM_BUS_PROCESS_CODE | | **Business objects** | `EmployeeAuthorityPaymentLimitHistory` | ### SQL referencing CL_CLAIM_EMP_BUS_FUNC_LIM_HIST - [SQL-031: AddLimitToHistory](sql/SQL-031-add-limit-to-history-employee-authority-payment-limit-history.md) - [SQL-188: GetClaimAuthorityLimitHistory](sql/SQL-188-get-claim-authority-limit-history-employee-authority-payment-limit-his.md) --- ## CL_HOSTILE_WORKER_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `HostileWorkerCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CL_SECURITY_OVERRIDE | | **Business objects** | `HostileWorkerCode` | ### SQL referencing CL_HOSTILE_WORKER_CODE - [SQL-203: CreateOverride](sql/SQL-203-create-override-hostile-worker-code.md) --- ## CL_INJURY_CLAIM | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `InjuryClaim`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | CLAIM_ID_SEQ | | **Related tables** | ATTENDING_PHYSICIAN, BODY_SIDE_CODE, CLAIM_STATUS_CODE, CL_BODY_PART_CODE, CL_CLAIM_DISABILITY_ACTIVITY, CL_CLAIM_PERSON, CL_CLAIM_TYPE_CODE, CL_DCS_FULL_PART_CODE, CL_FEDERAL_INJURY_LOCATION_CD, CL_FORM_CODE, CL_INJURED_ON_PREMISES_CODE, CL_INJURY_EVENT_CODE, CL_INJURY_NATURE_CODE, CL_INJURY_SOURCE_CODE, CL_JURISDICTION_CODE, CL_MCO_STATUS_REASON_CODE, CL_MEDICAL_CONDITION, CL_OWCP_ADDRESS, CL_REQUEST_TYPE_CODE, COVERAGE_CODE, MCO_GSA_LOCATION, OCCUPATIONAL_DISEASE_CODE, VOCATIONAL_RESP_CODE | | **Business objects** | `InjuryClaim` | ### SQL referencing CL_INJURY_CLAIM - [SQL-208: GetClaimWorkerName](sql/SQL-208-get-claim-worker-name-injury-claim.md) - [SQL-209: CreateTask, GetClaimId](sql/SQL-209-create-task-injury-claim.md) - [SQL-210: GetClaimData, IsValidClaim](sql/SQL-210-get-claim-data-injury-claim.md) - [SQL-211: CreateTask, CreateTaskStateless, GetAdditionalInfoTask, GetClaimId, IsValidClaim, UpdateTask](sql/SQL-211-create-task-injury-claim-2.md) --- ## CL_PAYMENT_SPCL_HANDLING_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `SpecialHandlingCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_BILL | | **Business objects** | `SpecialHandlingCode` | ### SQL referencing CL_PAYMENT_SPCL_HANDLING_CODE - [SQL-298: SaveLegalBill](sql/SQL-298-save-legal-bill-special-handling-code.md) - [SQL-299: SpecialHandlingCodeList (property)](sql/SQL-299-special-handling-code-list-special-handling-code.md) --- ## CL_PHARMACY_DAW_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `PharmacyDispenseAsWrittenCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CBP_BILL_SERVICE | | **Business objects** | `PharmacyDispenseAsWrittenCode` | ### SQL referencing CL_PHARMACY_DAW_CODE - [SQL-255: CreateService, UpdateService](sql/SQL-255-create-service-pharmacy-dispense-as-written-code.md) --- ## CL_PHARMACY_ELIGIBILITY_REPORT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `PharmacyEligibilityReport`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read, Update | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CL_PHARMACY_ELIG_STATUS_CODE | | **Business objects** | `PharmacyEligibilityReport` | ### SQL referencing CL_PHARMACY_ELIGIBILITY_REPORT - [SQL-256: GetEligibleClaims, GetFirstFillClaims](sql/SQL-256-get-eligible-claims-pharmacy-eligibility-report.md) - [SQL-356: UpdatePharmElig](sql/SQL-356-update-pharm-elig-pharmacy-eligibility-report.md) --- ## CL_PHARMACY_ELIG_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `PharmacyEligibilityStatusCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CL_PHARMACY_ELIGIBILITY_REPORT | | **Business objects** | `PharmacyEligibilityStatusCode` | ### SQL referencing CL_PHARMACY_ELIG_STATUS_CODE - [SQL-257: ProcessFirstFillReports, UpdatePharmElig](sql/SQL-257-process-first-fill-reports-pharmacy-eligibility-status-code.md) --- ## CL_SECURITY_OVERRIDE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `SecurityOverride`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | CL_OVERRIDE_SECURITY_SEQ | | **Related tables** | CL_HOSTILE_WORKER_CODE | | **Business objects** | `SecurityOverride` | ### SQL referencing CL_SECURITY_OVERRIDE - [SQL-048: CreateOverride](sql/SQL-048-create-override-security-override.md) - [SQL-297: DeleteOverride, GetSecurityOverrideById, GetSecurityOverrides, UpdateOverride](sql/SQL-297-delete-override-security-override.md) - [SQL-391: DeleteOverride](sql/SQL-391-delete-override-security-override-2.md) --- ## COMPANY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Referenced via native SQL join in `InvestigationRepositoryExtensions.GetSubjectName` (no NHibernate `ClassMap`; accessed only through hand-written `CreateSqlQuery` text) | | **Access pattern** | Inline SQL (NHibernate `CreateSqlQuery`) — literal SQL text, not ORM-mediated | | **CRUD operations** | Read | | **Key columns used** | COMPANY_SEQ_NUM, COMPANY_NAME | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `FraudInvestigationService` | ### SQL referencing COMPANY - [SQL-214: GetClaimId, GetSubjectNameAsync](sql/SQL-214-get-claim-id-investigation.md) --- ## CONTEXT_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ContextCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | DOCUMENT_TEMPLATE | | **Business objects** | `ContextCode` | ### SQL referencing CONTEXT_CODE - [SQL-147: GetContextTypes](sql/SQL-147-get-context-types-context-code.md) --- ## COUNTY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `County`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LOCATION | | **Business objects** | `County` | ### SQL referencing COUNTY - [SQL-148: GetCountyCodes](sql/SQL-148-get-county-codes-county.md) - [SQL-149: GetCountyNames](sql/SQL-149-get-county-names-county.md) --- ## CREDIT_REP_USER | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CreditRepUser`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_COLLECTION | | **Business objects** | `CreditRepUser` | ### SQL referencing CREDIT_REP_USER - [SQL-150: GetCreditReps](sql/SQL-150-get-credit-reps-credit-rep-user.md) --- ## CSGSEV_CLM_SGMNTN_ACTIONS_SENT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ClaimSeverityModelActivity`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimSeverityModelActivity` | ### SQL referencing CSGSEV_CLM_SGMNTN_ACTIONS_SENT - [SQL-145: ClaimSeverityModelActivityQuery (property)](sql/SQL-145-claim-severity-model-activity-query-claim-severity-model-activity.md) --- ## DCBS_OREGON_BUSINESS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | WCIS_DBA (explicit qualifier in Table()) | | **Purpose** | Backing store for `OregonBusiness`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | WCIS_DBA.DCBS_OREGON_BUSINESS_SEQ_NUM | | **Related tables** | None identified | | **Business objects** | `OregonBusiness` | ### SQL referencing DCBS_OREGON_BUSINESS - [SQL-040: CreateOregonBusinessRow](sql/SQL-040-create-oregon-business-row-oregon-business.md) --- ## DEPT_REVENUE_SOIL_ADJUSTMENT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DeptRevenueSoilAdjustment`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `DeptRevenueSoilAdjustment` | ### SQL referencing DEPT_REVENUE_SOIL_ADJUSTMENT - [SQL-152: CreateSoilFile, GenerateSoilAdjustments](sql/SQL-152-create-soil-file-dept-revenue-soil-adjustment.md) --- ## DEPT_REVENUE_SOIL_BALANCE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DeptRevenueSoilBalance`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `DeptRevenueSoilBalance` | ### SQL referencing DEPT_REVENUE_SOIL_BALANCE - [SQL-019: InsertBalanceRecords](sql/SQL-019-insert-balance-records-dept-revenue-soil-balance.md) --- ## DOCUMENT_DISTRIBUTION_LOG | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocumentDistributionLog`, `DocumentDistributionLogRequest`, `DocumentDistributionLogStatusOnly`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | DOCUMENT_DISTRIBUTION_LOG_SEQ, DOCUMENT_DIST_LOG_SEQ | | **Related tables** | DOCUMENT_REQUEST_LOG | | **Business objects** | `DocumentDistributionLog`, `DocumentDistributionLogRequest`, `DocumentDistributionLogStatusOnly` | ### SQL referencing DOCUMENT_DISTRIBUTION_LOG - [SQL-020: CreateDocumentDistributionRecord, GetNextDistributionRecordKey](sql/SQL-020-create-document-distribution-record-document-distribution-log.md) - [SQL-154: DeleteRequestDistributionById, GetDocumentDistributionLogById, GetPendingRequests, UpdateDocumentDistributionLogXmlField, UpdateDocumentDistributionRecord](sql/SQL-154-delete-request-distribution-by-id-document-distribution-log.md) - [SQL-155: DeleteRequestDistributions](sql/SQL-155-delete-request-distributions-document-distribution-log.md) - [SQL-156: GetDocumentDistributionLogsForRequest, GetPendingDocuments, GetProcessingDocuments, MarkDocumentRequestsInProcess, UpdateDocumentRequestAndDistribution](sql/SQL-156-get-document-distribution-logs-for-request-document-distribution-log-r.md) - [SQL-157: UpdateDocumentDistributionLogCompleted, UpdateDocumentDistributionLogStatus, UpdateDocumentDistributionLogStatusForRequest](sql/SQL-157-update-document-distribution-log-completed-document-distribution-log-s.md) - [SQL-369: DeleteRequestDistributionById](sql/SQL-369-delete-request-distribution-by-id-document-distribution-log-2.md) - [SQL-370: DeleteRequestDistributions](sql/SQL-370-delete-request-distributions-document-distribution-log-2.md) --- ## DOCUMENT_IMAGING_ERROR | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | CLM_DBA | | **Purpose** | Backing store for `DocumentImagingError`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `DocumentImagingError` | ### SQL referencing DOCUMENT_IMAGING_ERROR - [SQL-021: InsertErrorImage](sql/SQL-021-insert-error-image-document-imaging-error.md) - [SQL-159: ExportErrorEnrollmentDocuments, InsertErrorImage](sql/SQL-159-export-error-enrollment-documents-document-imaging-error.md) - [SQL-371: ExportErrorEnrollmentDocuments](sql/SQL-371-export-error-enrollment-documents-document-imaging-error-2.md) --- ## DOCUMENT_OPTION_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocumentOptionCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | DOCUMENT_TEMPLATE_OPTION | | **Business objects** | `DocumentOptionCode` | ### SQL referencing DOCUMENT_OPTION_CODE - [SQL-161: GetDocumentOptionCodes](sql/SQL-161-get-document-option-codes-document-option-code.md) --- ## DOCUMENT_OP_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocumentOutputProfileCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | DOCUMENT_TEMPLATE_OP | | **Business objects** | `DocumentOutputProfileCode` | ### SQL referencing DOCUMENT_OP_CODE - [SQL-162: GetDocumentOutputProfileCodes](sql/SQL-162-get-document-output-profile-codes-document-output-profile-code.md) --- ## DOCUMENT_REQUEST_LOG | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocumentRequestLog`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | DOCUMENT_REQUEST_LOG_SEQ | | **Related tables** | DOCUMENT_DISTRIBUTION_LOG, DOCUMENT_TEMPLATE | | **Business objects** | `DocumentRequestLog` | ### SQL referencing DOCUMENT_REQUEST_LOG - [SQL-023: SubmitDocumentRequest](sql/SQL-023-submit-document-request-document-request-log.md) - [SQL-163: RequestLogQuery (property)](sql/SQL-163-request-log-query-document-request-log.md) - [SQL-164: DeleteTemplateRequests, GetRecentRequests](sql/SQL-164-delete-template-requests-document-request-log.md) - [SQL-373: DeleteTemplateRequests](sql/SQL-373-delete-template-requests-document-request-log-2.md) --- ## DOCUMENT_TEMPLATE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocumentTemplate`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | DOCUMENT_TEMPLATE_SEQ | | **Related tables** | CONTEXT_CODE, DOCUMENT_REQUEST_LOG, DOCUMENT_TEMPLATE_OP, DOCUMENT_TEMPLATE_OPTION, RUN_TYPE_CODE | | **Business objects** | `DocumentTemplate` | ### SQL referencing DOCUMENT_TEMPLATE - [SQL-025: CreateTemplate](sql/SQL-025-create-template-document-template.md) - [SQL-166: TemplateQuery (property)](sql/SQL-166-template-query-document-template.md) - [SQL-167: TemplateQuery (property), TemplateQueryFiltered (property)](sql/SQL-167-template-query-document-template-2.md) - [SQL-374: DeleteTemplate](sql/SQL-374-delete-template-document-template.md) --- ## DOCUMENT_TEMPLATE_OP | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocumentTemplateOutputProfile`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | DOCUMENT_TEMPLATE_OP_SEQ | | **Related tables** | DOCUMENT_OP_CODE, DOCUMENT_TEMPLATE | | **Business objects** | `DocumentTemplateOutputProfile` | ### SQL referencing DOCUMENT_TEMPLATE_OP - [SQL-027: AddTemplateOutputProfiles](sql/SQL-027-add-template-output-profiles-document-template-output-profile.md) - [SQL-170: GetRequestLogXElement, IsWordDocument](sql/SQL-170-get-request-log-x-element-document-template-output-profile.md) - [SQL-171: GetAllTemplateOutputProfiles, GetDocumentSqlLines, GetOuputProfilesForOneTemplate](sql/SQL-171-get-all-template-output-profiles-document-template-output-profile.md) - [SQL-376: DeleteTemplateOutputProfiles](sql/SQL-376-delete-template-output-profiles-document-template-output-profile.md) --- ## DOCUMENT_TEMPLATE_OPTION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocumentTemplateOption`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | DOCUMENT_OPTION_SEQ | | **Related tables** | DOCUMENT_OPTION_CODE, DOCUMENT_TEMPLATE | | **Business objects** | `DocumentTemplateOption` | ### SQL referencing DOCUMENT_TEMPLATE_OPTION - [SQL-026: AddTemplateOptions](sql/SQL-026-add-template-options-document-template-option.md) - [SQL-168: GetRequestLogXElement](sql/SQL-168-get-request-log-x-element-document-template-option.md) - [SQL-169: GetAllTemplateOptions, GetDocumentSqlLines, GetOptionsForOneTemplate](sql/SQL-169-get-all-template-options-document-template-option.md) - [SQL-375: DeleteTemplateOptions](sql/SQL-375-delete-template-options-document-template-option.md) --- ## DOC_REQUEST_LOG_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocRequestLogStatusCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `DocRequestLogStatusCode` | ### SQL referencing DOC_REQUEST_LOG_STATUS_CODE - [SQL-153: UpdateRequestStatus](sql/SQL-153-update-request-status-doc-request-log-status-code.md) --- ## DocumentImageTypeCode | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocumentImageTypeCode`, accessed via `IUnitOfWork.GetRepository()`; the backing table name itself could not be confirmed by static analysis or Legends — the C# entity name is used in its place per the translation skill's "never invent a table name" rule | | **Access pattern** | NHibernate ORM (`GetRepository()`) — external mapping, table name unconfirmed** | | **CRUD operations** | Read | | **Key columns used** | Not enumerable — table and column names both unresolved; see linked SQL document for C# property names** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `DocumentImageTypeCode` | ### SQL referencing DocumentImageTypeCode - [SQL-158: GetRequestLogXElement](sql/SQL-158-get-request-log-x-element-document-image-type-code.md) --- ## DocumentRequestParameter | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocumentRequestParameter`, accessed via `IUnitOfWork.GetRepository()`; no `ClassMap` exists in this repository or the external mapping package queried via Legends, so the backing table name is unconfirmed and the C# entity name is used in its place | | **Access pattern** | NHibernate ORM (`GetRepository()`) — external mapping, table name unconfirmed** | | **CRUD operations** | Create, Read | | **Key columns used** | Not enumerable — table and column names both unresolved; see linked SQL documents for C# property names** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `DocumentRequestParameter` | ### SQL referencing DocumentRequestParameter - [SQL-024: StoreOriginalDocumentRequestParameters](sql/SQL-024-store-original-document-request-parameters-document-request-parameter.md) - [SQL-165: GetDocumentRequestParameters, NeedVocCoordinators, SaveChangedDocumentRequestParameters, StoreOriginalDocumentRequestParameters](sql/SQL-165-get-document-request-parameters-document-request-parameter.md) --- ## DocumentTemplateParameter | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocumentTemplateParameter`, accessed via `IUnitOfWork.GetRepository()`; no `ClassMap` exists in this repository or the external mapping package queried via Legends, so the backing table name is unconfirmed and the C# entity name is used in its place | | **Access pattern** | NHibernate ORM (`GetRepository()`) — external mapping, table name unconfirmed** | | **CRUD operations** | Read | | **Key columns used** | Not enumerable — table and column names both unresolved; see linked SQL document for C# property names** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `DocumentTemplateParameter` | ### SQL referencing DocumentTemplateParameter - [SQL-172: GetDocumentTemplateParameters](sql/SQL-172-get-document-template-parameters-document-template-parameter.md) --- ## EBILL_INVOICE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `EbillInvoice`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | EBILL_INVOICE_SEQ | | **Related tables** | EBILL_CLEARINGHOUSE, EBILL_INVOICE_BILL, EBILL_INVOICE_ERROR | | **Business objects** | `EbillInvoice` | ### SQL referencing EBILL_INVOICE - [SQL-028: ProcessInvoiceFile](sql/SQL-028-process-invoice-file-ebill-invoice.md) - [SQL-377: ProcessInvoiceFile](sql/SQL-377-process-invoice-file-ebill-invoice-2.md) --- ## EBILL_INVOICE_BILL | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `EbillInvoiceBill`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | EBILL_INVOICE_BILL_SEQ | | **Related tables** | EBILL, EBILL_INVOICE | | **Business objects** | `EbillInvoiceBill` | ### SQL referencing EBILL_INVOICE_BILL - [SQL-378: ProcessInvoiceFile](sql/SQL-378-process-invoice-file-ebill-invoice-bill.md) --- ## EBILL_INVOICE_ERROR | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `EbillInvoiceError`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | EBILL_INVOICE_ERROR_SEQ | | **Related tables** | EBILL, EBILL_INVOICE | | **Business objects** | `EbillInvoiceError` | ### SQL referencing EBILL_INVOICE_ERROR - [SQL-379: ProcessInvoiceFile](sql/SQL-379-process-invoice-file-ebill-invoice-error.md) --- ## EDI_AUDITED_SERVICE_OVERRIDE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `AuditedServiceOverride`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `AuditedServiceOverride` | ### SQL referencing EDI_AUDITED_SERVICE_OVERRIDE - [SQL-001: Add](sql/SQL-001-add-audited-service-override.md) - [SQL-086: Get, GetOverrideById](sql/SQL-086-get-audited-service-override.md) - [SQL-361: Delete](sql/SQL-361-delete-audited-service-override.md) --- ## EDI_BILL_OVERRIDE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `BillOverride`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `BillOverride` | ### SQL referencing EDI_BILL_OVERRIDE - [SQL-004: Add](sql/SQL-004-add-bill-override.md) - [SQL-094: Get, GetOverrideById](sql/SQL-094-get-bill-override.md) - [SQL-363: Delete](sql/SQL-363-delete-bill-override.md) --- ## EDI_FILE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | OPS$JIMMIL | | **Purpose** | Backing store for `EdiFile`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | EDI_FILE_SEQ | | **Related tables** | EDI_SEGMENT | | **Business objects** | `EdiFile` | ### SQL referencing EDI_FILE - [SQL-029: LoadFile](sql/SQL-029-load-file-edi-file.md) - [SQL-173: DeleteFile](sql/SQL-173-delete-file-edi-file.md) - [SQL-380: DeleteFile](sql/SQL-380-delete-file-edi-file-2.md) --- ## EMPLOYERS_LIABILITY_FACTORS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `EmployerLiabilityFactors`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `EmployerLiabilityFactors` | ### SQL referencing EMPLOYERS_LIABILITY_FACTORS - [SQL-189: GetStandardLimits](sql/SQL-189-get-standard-limits-employer-liability-factors.md) --- ## EMPLOYERS_LIABILITY_LIMITS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `EmployerLiabilityLimit`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CERTIFICATE_DETAIL | | **Business objects** | `EmployerLiabilityLimit` | ### SQL referencing EMPLOYERS_LIABILITY_LIMITS - [SQL-190: GetSpecificLimit](sql/SQL-190-get-specific-limit-employer-liability-limit.md) - [SQL-191: GetStandardLimits](sql/SQL-191-get-standard-limits-employer-liability-limit.md) --- ## ERROR_ENVIRONMENT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ErrorEnvironment`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | ERROR_GROUP_ENVIRONMENT | | **Business objects** | `ErrorEnvironment` | ### SQL referencing ERROR_ENVIRONMENT - [SQL-192: Environments (property)](sql/SQL-192-environments-error-environment.md) --- ## ERROR_GROUP_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ErrorGroupCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | ERROR_GROUP_ENVIRONMENT | | **Business objects** | `ErrorGroupCode` | ### SQL referencing ERROR_GROUP_CODE - [SQL-193: EnvironmentGroups (property)](sql/SQL-193-environment-groups-error-group-code.md) --- ## ERROR_GROUP_ENVIRONMENT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ErrorGroupEnvironment`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | ERROR_ENVIRONMENT, ERROR_GROUP_CODE | | **Business objects** | `ErrorGroupEnvironment` | ### SQL referencing ERROR_GROUP_ENVIRONMENT - [SQL-194: EnvironmentsByGroup (property), GetEnvironmentsForGroup](sql/SQL-194-environments-by-group-error-group-environment.md) --- ## EXT_USER_DOC_NOTIFY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocumentNotification`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | EXT_USER_DOC_NOTIFY_SEQ | | **Related tables** | AGENCY | | **Business objects** | `DocumentNotification` | ### SQL referencing EXT_USER_DOC_NOTIFY - [SQL-022: CreateEmailNotification](sql/SQL-022-create-email-notification-document-notification.md) - [SQL-160: DocumentNotificationQuery (property)](sql/SQL-160-document-notification-query-document-notification.md) - [SQL-372: DeleteEmailNotification](sql/SQL-372-delete-email-notification-document-notification.md) --- ## FILE_REQUEST | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `FileRequest`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | PAPER_FILE | | **Business objects** | `FileRequest` | ### SQL referencing FILE_REQUEST - [SQL-197: LoadTaskMailIDList](sql/SQL-197-load-task-mail-id-list-file-request.md) --- ## GROUP_ASSOCIATION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `GroupAssociation`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | GROUP_ASSOCIATION, GROUP_TYPE_CODE | | **Business objects** | `GroupAssociation` | ### SQL referencing GROUP_ASSOCIATION - [SQL-198: GroupQuery](sql/SQL-198-group-query-group-association.md) --- ## HEARING_LOCATION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `HearingLocation`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | HEARING_LOCATION_SEQ | | **Related tables** | HEARING_LOCATION_CODE, SUBPOENA | | **Business objects** | `HearingLocation` | ### SQL referencing HEARING_LOCATION - [SQL-199: SetAttorneyInfo](sql/SQL-199-set-attorney-info-hearing-location.md) - [SQL-200: InitializeLabel](sql/SQL-200-initialize-label-hearing-location.md) - [SQL-201: SetSubpoenaData](sql/SQL-201-set-subpoena-data-hearing-location.md) - [SQL-202: ListOfHearingLocations (property)](sql/SQL-202-list-of-hearing-locations-hearing-location.md) --- ## IMAGE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Image`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (external `ImageMap` in `SAIF.Framework.Data.NHibernate`) — table name (`image`) confirmed via Legends CLI; column mappings unresolved | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `Image` | ### SQL referencing IMAGE - [SQL-204: GetDataImage](sql/SQL-204-get-data-image-image.md) - [SQL-205: ImageAgencyQuery (property)](sql/SQL-205-image-agency-query-image-agency.md) --- ## IMAGE_AGENCY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ImageAgency`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | IMAGE_AGENCY_SEQ | | **Related tables** | AGENCY | | **Business objects** | `ImageAgency` | ### SQL referencing IMAGE_AGENCY - [SQL-032: AddImage](sql/SQL-032-add-image-image-agency.md) - [SQL-205: ImageAgencyQuery (property)](sql/SQL-205-image-agency-query-image-agency.md) --- ## IMAGE_CATEGORY_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ImageCategoryCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (external `ImageCategoryCodeMap` in `SAIF.Framework.Data.NHibernate`) — table name and composite-key columns confirmed via Legends CLI; remaining columns unresolved | | **CRUD operations** | Read | | **Key columns used** | image_file_code, code (composite key, confirmed); remaining columns unresolved** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ImageCategoryCode` | ### SQL referencing IMAGE_CATEGORY_CODE - [SQL-206: GetCategories](sql/SQL-206-get-categories-image-category-code.md) --- ## IMAGE_DOCUMENT_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ImageDocumentTypeCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (external `ImageDocumentTypeCodeMap` in `SAIF.Framework.Data.NHibernate`) — table name and key column confirmed via Legends CLI; remaining columns unresolved | | **CRUD operations** | Read | | **Key columns used** | code (confirmed); remaining columns and FK columns unresolved** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ImageDocumentTypeCode` | ### SQL referencing IMAGE_DOCUMENT_TYPE_CODE - [SQL-207: GetDocumentType](sql/SQL-207-get-document-type-image-document-type-code.md) --- ## INTEREST_CALC_OPTION_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `InterestCalcCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_COLLECTION | | **Business objects** | `InterestCalcCode` | ### SQL referencing INTEREST_CALC_OPTION_CODE - [SQL-212: GetInterestCalcCodes](sql/SQL-212-get-interest-calc-codes-interest-calc-code.md) --- ## INTEREST_RATE_VALUE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `InterestRateValue`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_COLLECTION | | **Business objects** | `InterestRateValue` | ### SQL referencing INTEREST_RATE_VALUE - [SQL-213: GetInterestRates](sql/SQL-213-get-interest-rates-interest-rate-value.md) --- ## INVESTIGATION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Investigation`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | INVESTIGATION_SEQ | | **Related tables** | None identified | | **Business objects** | `Investigation` | ### SQL referencing INVESTIGATION - [SQL-214: GetClaimId, GetSubjectNameAsync](sql/SQL-214-get-claim-id-investigation.md) --- ## JUDGEMENT_YEARS_VALUE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `JudgmentYearsValue`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_COLLECTION | | **Business objects** | `JudgmentYearsValue` | ### SQL referencing JUDGEMENT_YEARS_VALUE - [SQL-216: GetJudgmentYears](sql/SQL-216-get-judgment-years-judgment-years-value.md) --- ## JUDGMENT_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `JudgmentCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_COLLECTION | | **Business objects** | `JudgmentCode` | ### SQL referencing JUDGMENT_CODE - [SQL-215: GetJudgmentCodes](sql/SQL-215-get-judgment-codes-judgment-code.md) --- ## LC_POLICY_SERVICE_PLAN | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `RctPolicyServicePlan`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Update | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `RctPolicyServicePlan` | ### SQL referencing LC_POLICY_SERVICE_PLAN - [SQL-045: InsertServicePlan](sql/SQL-045-insert-service-plan-rct-policy-service-plan.md) - [SQL-286: ProcessOneServicePlan](sql/SQL-286-process-one-service-plan-rct-policy-service-plan.md) - [SQL-358: ExpireServicePlan](sql/SQL-358-expire-service-plan-rct-policy-service-plan.md) --- ## LC_SERVICE_PLAN_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `RctServicePlanCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `RctServicePlanCode` | ### SQL referencing LC_SERVICE_PLAN_CODE - [SQL-290: ProcessAllServicePlans](sql/SQL-290-process-all-service-plans-rct-service-plan-code.md) --- ## LC_TRAN_CATEGORY_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `TransactionCategoryCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_COLLECTION_TRAN_CODE | | **Business objects** | `TransactionCategoryCode` | ### SQL referencing LC_TRAN_CATEGORY_CODE - [SQL-344: GetTransactionCategoryCodes](sql/SQL-344-get-transaction-category-codes-transaction-category-code.md) --- ## LEGAL_BILL | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `LegalBill`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LEGAL_BILL_SEQ | | **Related tables** | BILL_STATUS_CODE, CL_PAYMENT_SPCL_HANDLING_CODE, LEGAL_BILL_SERVICE, LEGAL_BILL_STATUS_HISTORY, LEGAL_CASE, PROVIDER_LOCATION | | **Business objects** | `LegalBill` | ### SQL referencing LEGAL_BILL - [SQL-033: SaveLegalBill](sql/SQL-033-save-legal-bill-legal-bill.md) - [SQL-217: CreateGlTransferActivity, GenerateCheckTransactionAsync, GenerateCheckTransactionsAsync, GenerateTransactionsForAdjustedBillAsync, GenerateZeroPaymentLetters, GetAttorneysWithPendingLegalBills, ReturnBillPayment, UpdateBillStatus](sql/SQL-217-create-gl-transfer-activity-legal-bill.md) - [SQL-218: DeleteBill, ResetParentBill, SaveLegalBill](sql/SQL-218-delete-bill-legal-bill.md) - [SQL-219: GetInboxItems, GetLegalBill, GetPendingBills](sql/SQL-219-get-inbox-items-legal-bill.md) - [SQL-382: DeleteBill](sql/SQL-382-delete-bill-legal-bill-2.md) --- ## LEGAL_BILL_SERVICE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `LegalBillService`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LEGAL_BILL_SERVICE_SEQ | | **Related tables** | ADJUSTMENT_REASON_CODE, BILL_SERVICE_CODE, BILL_SERVICE_RATE_TYPE_CODE, LEGAL_BILL | | **Business objects** | `LegalBillService` | ### SQL referencing LEGAL_BILL_SERVICE - [SQL-220: GenerateCheckTransactionsAsync](sql/SQL-220-generate-check-transactions-async-legal-bill-service.md) - [SQL-221: CheckForDuplicateService](sql/SQL-221-check-for-duplicate-service-legal-bill-service.md) - [SQL-222: PrepareAdjustedBillForSave, SaveBillServices](sql/SQL-222-prepare-adjusted-bill-for-save-legal-bill-service.md) --- ## LEGAL_CASE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `LegalCase`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LEGAL_CASE_SEQ | | **Related tables** | APPEAL, CASE_NOTE, CASE_STATUS_CODE, LEGAL_BILL, PROVIDER_LOCATION, SCHEDULE, SUBPOENA | | **Business objects** | `LegalCase` | ### SQL referencing LEGAL_CASE - [SQL-223: SaveLegalBill](sql/SQL-223-save-legal-bill-legal-case.md) - [SQL-224: CreateNote, FormatCaseHeader](sql/SQL-224-create-note-legal-case.md) - [SQL-225: GetOpposingCounselInfo, LegalCaseExistsAndHasImageAlertsFlag](sql/SQL-225-get-opposing-counsel-info-legal-case.md) - [SQL-226: CreateTaskNote](sql/SQL-226-create-task-note-legal-case.md) - [SQL-227: SaveSubpoena](sql/SQL-227-save-subpoena-legal-case.md) --- ## LEGAL_COLLECTION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Case`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LEGAL_COLLECTION_SEQ | | **Related tables** | CREDIT_REP_USER, INTEREST_CALC_OPTION_CODE, INTEREST_RATE_VALUE, JUDGEMENT_YEARS_VALUE, JUDGMENT_CODE, LEGAL_COLLECTION_ACTIVITY, LEGAL_COLLECTION_CODE, LEGAL_COLLECTION_DEBTOR, LEGAL_COLLECTION_PAYMENT_REF, LEGAL_COLLECTION_STATUS_CODE, LEGAL_COLLECTION_TRANSACTION | | **Business objects** | `Case` | ### SQL referencing LEGAL_COLLECTION - [SQL-005: SaveRequest](sql/SQL-005-save-request-case.md) - [SQL-106: AddTransaction, GetCaseInterest](sql/SQL-106-add-transaction-case.md) - [SQL-107: AddTransaction, GenerateReport](sql/SQL-107-add-transaction-case-2.md) - [SQL-108: GetCaseDataById, GetCaseSummaryById, GetRequestById, SaveRequest](sql/SQL-108-get-case-data-by-id-case.md) - [SQL-109: BalanceAtMinimumTasks, JudgmentExpiringTasks, PolicyPaymentTasks, ThirdPartyPaymentTasks](sql/SQL-109-balance-at-minimum-tasks-case.md) --- ## LEGAL_COLLECTION_ACTIVITY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Activity`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LEGAL_COLL_ACTIVITY_SEQ | | **Related tables** | LEGAL_COLLECTION, LEGAL_COLL_ACTIVITY_CODE | | **Business objects** | `Activity` | ### SQL referencing LEGAL_COLLECTION_ACTIVITY - [SQL-070: GetActivities, GetActivityData](sql/SQL-070-get-activities-activity.md) - [SQL-360: DeleteActivity](sql/SQL-360-delete-activity-activity.md) --- ## LEGAL_COLLECTION_BATCH_CONTROL | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `BatchControl`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LC_BATCH_CONTROL_SEQ | | **Related tables** | None identified | | **Business objects** | `BatchControl` | ### SQL referencing LEGAL_COLLECTION_BATCH_CONTROL - [SQL-091: ApplyCashReceipts, ProcessBatch](sql/SQL-091-apply-cash-receipts-batch-control.md) --- ## LEGAL_COLLECTION_CASH_RECEIPTS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CashReceipts`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LC_CASH_RECEIPTS_SEQ | | **Related tables** | None identified | | **Business objects** | `CashReceipts` | ### SQL referencing LEGAL_COLLECTION_CASH_RECEIPTS - [SQL-110: GenerateReport, ProcessBatch](sql/SQL-110-generate-report-cash-receipts.md) --- ## LEGAL_COLLECTION_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `CollectionCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_COLLECTION | | **Business objects** | `CollectionCode` | ### SQL referencing LEGAL_COLLECTION_CODE - [SQL-146: GetCollectionCodes](sql/SQL-146-get-collection-codes-collection-code.md) --- ## LEGAL_COLLECTION_DEBTOR | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Debtor`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LEGAL_COLL_DEBTOR_SEQ | | **Related tables** | LEGAL_COLLECTION | | **Business objects** | `Debtor` | ### SQL referencing LEGAL_COLLECTION_DEBTOR - [SQL-018: CreateDebtor](sql/SQL-018-create-debtor-debtor.md) - [SQL-151: GetDebtorData, GetDebtorDataList, GetDebtors, GetTransactions](sql/SQL-151-get-debtor-data-debtor.md) - [SQL-368: DeleteDebtor](sql/SQL-368-delete-debtor-debtor.md) --- ## LEGAL_COLLECTION_NOTE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Note`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LEGAL_COLLECTION_NOTE_SEQ | | **Related tables** | None identified | | **Business objects** | `Note` | ### SQL referencing LEGAL_COLLECTION_NOTE - [SQL-039: CreateNote](sql/SQL-039-create-note-note.md) - [SQL-233: GetNotes, GetdataNote](sql/SQL-233-get-notes-note.md) - [SQL-387: DeleteNote](sql/SQL-387-delete-note-note.md) --- ## LEGAL_COLLECTION_PAYMENT_REF | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `PaymentRef`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_COLLECTION, LEGAL_COLLECTION_TRANSACTION | | **Business objects** | `PaymentRef` | ### SQL referencing LEGAL_COLLECTION_PAYMENT_REF - [SQL-246: GetTransactions](sql/SQL-246-get-transactions-payment-ref.md) --- ## LEGAL_COLLECTION_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `StatusCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_COLLECTION | | **Business objects** | `StatusCode` | ### SQL referencing LEGAL_COLLECTION_STATUS_CODE - [SQL-303: GetStatusCodes](sql/SQL-303-get-status-codes-status-code.md) --- ## LEGAL_COLLECTION_TRANSACTION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Transaction`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LEGAL_COLL_TRAN_SEQ | | **Related tables** | LEGAL_COLLECTION, LEGAL_COLLECTION_PAYMENT_REF, LEGAL_COLLECTION_TRAN_CODE, WRITEOFF_APPROVAL_USER | | **Business objects** | `Transaction` | ### SQL referencing LEGAL_COLLECTION_TRANSACTION - [SQL-057: AddTransaction](sql/SQL-057-add-transaction-transaction.md) - [SQL-058: AddTransaction](sql/SQL-058-add-transaction-transaction-2.md) - [SQL-059: InsertTransaction](sql/SQL-059-insert-transaction-transaction.md) - [SQL-343: GetTransaction, GetTransactionData, GetTransactions](sql/SQL-343-get-transaction-transaction.md) - [SQL-395: DeleteTransaction](sql/SQL-395-delete-transaction-transaction.md) --- ## LEGAL_COLLECTION_TRAN_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `TransactionCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LC_TRAN_CATEGORY_CODE, LEGAL_COLLECTION_TRANSACTION | | **Business objects** | `TransactionCode` | ### SQL referencing LEGAL_COLLECTION_TRAN_CODE - [SQL-345: GetTransactionCodes, InsertTransaction](sql/SQL-345-get-transaction-codes-transaction-code.md) --- ## LEGAL_COLL_ACTIVITY_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ActivityCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_COLLECTION_ACTIVITY | | **Business objects** | `ActivityCode` | ### SQL referencing LEGAL_COLL_ACTIVITY_CODE - [SQL-071: GetActivityCodes](sql/SQL-071-get-activity-codes-activity-code.md) --- ## LEGAL_PERSON | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `LegalPerson`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LEGAL_PERSON_SEQ | | **Related tables** | SUBPOENA_RECIPIENT | | **Business objects** | `LegalPerson` | ### SQL referencing LEGAL_PERSON - [SQL-036: CreateNewLegalPerson](sql/SQL-036-create-new-legal-person-legal-person.md) --- ## LOCATION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Location`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | LOCATION_SEQ | | **Related tables** | AGENT, COUNTY, SUBPOENA_RECIPIENT | | **Business objects** | `Location` | ### SQL referencing LOCATION - [SQL-037: CreateDebtor, SaveDebtor](sql/SQL-037-create-debtor-location.md) - [SQL-231: GetDebtorLocation, GetPolicyLocations, GetPolicyMailingLocation](sql/SQL-231-get-debtor-location-location.md) - [SQL-232: SetWitnessRecipients](sql/SQL-232-set-witness-recipients-location.md) - [SQL-384: DeleteDebtor](sql/SQL-384-delete-debtor-location.md) --- ## MEDICARE_BENEFICIARY_QUERY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `MedicareBeneficiaryQuery`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | MEDICARE_QUERY_SEQ | | **Related tables** | None identified | | **Business objects** | `MedicareBeneficiaryQuery` | ### SQL referencing MEDICARE_BENEFICIARY_QUERY - [SQL-385: ProcessDeleteMedicareBeneficiarysForBatch](sql/SQL-385-process-delete-medicare-beneficiarys-for-batch-medicare-beneficiary-qu.md) --- ## MEDICARE_BENEFICIARY_QUERY_BAT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `MedicareBeneficiaryQueryBatch`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `MedicareBeneficiaryQueryBatch` | ### SQL referencing MEDICARE_BENEFICIARY_QUERY_BAT - [SQL-386: ProcessDeleteMedicareBeneficiarysForBatch](sql/SQL-386-process-delete-medicare-beneficiarys-for-batch-medicare-beneficiary-qu-2.md) --- ## MEDICARE_QUERY_HISTORY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `MedicareQueryHistory`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Update | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | MEDICARE_QUERY_HISTORY_SEQ | | **Related tables** | None identified | | **Business objects** | `MedicareQueryHistory` | ### SQL referencing MEDICARE_QUERY_HISTORY - [SQL-038: InsertMedicareQueryHistory](sql/SQL-038-insert-medicare-query-history-medicare-query-history.md) - [SQL-355: UpdateHistoryRecord](sql/SQL-355-update-history-record-medicare-query-history.md) --- ## NOTE_CATEGORY_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `LegalNoteCategory`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CASE_NOTE, TASK | | **Business objects** | `LegalNoteCategory` | ### SQL referencing NOTE_CATEGORY_CODE - [SQL-229: CreateNote, GetCategories, GetCategoryDesc, UpdateNote](sql/SQL-229-create-note-legal-note-category.md) - [SQL-230: CreateTaskNote, FillTaskData, GetNoteCategories, UpdateTask](sql/SQL-230-create-task-note-legal-note-category.md) --- ## OB_DOC_TYPE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `DocType`, reached via non-identifier navigation from `OnBaseNotificationRuleMatrix` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | ob_doc_type_seq_num, ob_doc_type | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OnBaseNotificationRuleMatrix` | ### SQL referencing OB_DOC_TYPE - [SQL-235: GetNotificationMatrixRules](sql/SQL-235-get-notification-matrix-rules-on-base-notification-rule-matrix.md) --- ## OB_NOTIFICATION_MATRIX | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `NotificationMatrix`, reached via non-identifier navigation from `OnBaseNotificationRuleMatrix` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | OB_NOTIFICATION_MATRIX_SEQ_NUM, OB_DOC_TYPE_SEQ_NUM | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OnBaseNotificationRuleMatrix` | ### SQL referencing OB_NOTIFICATION_MATRIX - [SQL-235: GetNotificationMatrixRules](sql/SQL-235-get-notification-matrix-rules-on-base-notification-rule-matrix.md) --- ## OB_NOTIFY_RULE_MATRX_X | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `OnBaseNotificationRuleMatrix`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | OB_NOTIFICATION_MATRIX, OB_NOTIFICATION_RULE | | **Business objects** | `OnBaseNotificationRuleMatrix` | ### SQL referencing OB_NOTIFY_RULE_MATRX_X - [SQL-235: GetNotificationMatrixRules](sql/SQL-235-get-notification-matrix-rules-on-base-notification-rule-matrix.md) --- ## OFFICE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `OfficeCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | POLICY | | **Business objects** | `OfficeCode` | ### SQL referencing OFFICE_CODE - [SQL-234: FillPolicy](sql/SQL-234-fill-policy-office-code.md) --- ## ONLINE_MESSAGE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `OnlineMessages`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | ONLINE_MESSAGE_SEQ | | **Related tables** | ONLINE_MESSAGE_PERMISSION, ONLINE_MESSAGE_PRIORITY_CODE | | **Business objects** | `OnlineMessages` | ### SQL referencing ONLINE_MESSAGE - [SQL-237: GetAllActiveMessages](sql/SQL-237-get-all-active-messages-online-messages.md) --- ## ONLINE_MESSAGE_APP_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ApplicationCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ApplicationCode` | ### SQL referencing ONLINE_MESSAGE_APP_CODE - [SQL-082: ValidateApplicationCode](sql/SQL-082-validate-application-code-application-code.md) --- ## ONLINE_MESSAGE_PRIORITY_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `OnlineMessagePriority`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | ONLINE_MESSAGE | | **Business objects** | `OnlineMessagePriority` | ### SQL referencing ONLINE_MESSAGE_PRIORITY_CODE - [SQL-236: GetMessagePriorities](sql/SQL-236-get-message-priorities-online-message-priority.md) --- ## ONLINE_USER_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `OnlineUserType`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OnlineUserType` | ### SQL referencing ONLINE_USER_TYPE_CODE - [SQL-238: GetMessageUserType, ValidateUserType](sql/SQL-238-get-message-user-type-online-user-type.md) --- ## OSC_POLICY_PERIOD | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `OtherStatesPolicyPeriod`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CERTIFICATE_DETAIL, OSC_POLICY_VIEW | | **Business objects** | `OtherStatesPolicyPeriod` | ### SQL referencing OSC_POLICY_PERIOD - [SQL-240: HasOscPeriodForPolicyPeriod](sql/SQL-240-has-osc-period-for-policy-period-other-states-policy-period.md) --- ## OSC_POLICY_VIEW | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `OtherStatesPolicy`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | AGENT, CERTIFICATE_DETAIL, OSC_POLICY_PERIOD, POLICY, POLICY_STATUS_CODE | | **Business objects** | `OtherStatesPolicy` | ### SQL referencing OSC_POLICY_VIEW - [SQL-239: GetOscPolicyById](sql/SQL-239-get-osc-policy-by-id-other-states-policy.md) --- ## OUTPUT_DOCUMENT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `OutputDocument`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | OUTPUT_DOCUMENT_SEQ | | **Related tables** | OUTPUT_DOCUMENT_TYPE_CODE | | **Business objects** | `OutputDocument` | ### SQL referencing OUTPUT_DOCUMENT - [SQL-241: FillOutputDocumentProperty, ReleaseDocuments](sql/SQL-241-fill-output-document-property-output-document.md) --- ## OUTPUT_DOCUMENT_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `OutputDocumentTypeCode`, `OutputDocumentTypeCodeStateless`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | **, OUTPUT_DOCUMENT, OUTPUT_DOCUMENT_CATEGORY_CODE, OUTPUT_DOC_NOTIFY_TEXT_CODE | | **Business objects** | `OutputDocumentTypeCode`, `OutputDocumentTypeCodeStateless` | ### SQL referencing OUTPUT_DOCUMENT_TYPE_CODE - [SQL-243: FillOutputDocumentProperty](sql/SQL-243-fill-output-document-property-output-document-type-code.md) - [SQL-244: ReleaseDocuments](sql/SQL-244-release-documents-output-document-type-code-stateless.md) --- ## OUTPUT_DOC_NOTIFY_TEXT_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `OutputDocumentNotifyTextCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | OUTPUT_DOCUMENT_TYPE_CODE | | **Business objects** | `OutputDocumentNotifyTextCode` | ### SQL referencing OUTPUT_DOC_NOTIFY_TEXT_CODE - [SQL-242: FillOutputDocumentProperty](sql/SQL-242-fill-output-document-property-output-document-notify-text-code.md) --- ## OUTPUT_LOG | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `OutputLog`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OutputLog` | ### SQL referencing OUTPUT_LOG - [SQL-245: ReplaceImageIdsInOutputLog](sql/SQL-245-replace-image-ids-in-output-log-output-log.md) --- ## PAYMENT_TRANSACTION_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `PaymentTransactionTypeCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PaymentTransactionTypeCode` | ### SQL referencing PAYMENT_TRANSACTION_TYPE_CODE - [SQL-247: DeterminePaymentIssueDate](sql/SQL-247-determine-payment-issue-date-payment-transaction-type-code.md) - [SQL-248: GetNextIssueDate](sql/SQL-248-get-next-issue-date-payment-transaction-type-code.md) - [SQL-249: ValidateNextIssueDate](sql/SQL-249-validate-next-issue-date-payment-transaction-type-code.md) - [SQL-250: GetIssueDate](sql/SQL-250-get-issue-date-payment-transaction-type-code.md) --- ## PERSON | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Referenced via native SQL join in `InvestigationRepositoryExtensions.GetSubjectName` (no NHibernate `ClassMap`; accessed only through hand-written `CreateSqlQuery` text) | | **Access pattern** | Inline SQL (NHibernate `CreateSqlQuery`) — literal SQL text, not ORM-mediated | | **CRUD operations** | Read | | **Key columns used** | PERSON_SEQ_NUM, NAME | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `FraudInvestigationService` | ### SQL referencing PERSON - [SQL-214: GetClaimId, GetSubjectNameAsync](sql/SQL-214-get-claim-id-investigation.md) --- ## POLICY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Policy`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | AGENT, BUSINESS_AFFILIATE, CUSTOMER_SERVICE_TEAM_CODE, ENTITY_CODE, MARKET_TYPE_CODE, OFFICE_CODE, OSC_POLICY_VIEW, POLICY, POLICY_OUTPUT_DOCUMENT, POLICY_PERIOD, POLICY_RELATIONSHIP_CODE, POLICY_STATUS_CODE, POLICY_TEAM_FUNCTION, RTW_CASE, SUB_POLICY, TASK, TRADING_AS | | **Business objects** | `Policy` | ### SQL referencing POLICY - [SQL-258: GetPolicyData](sql/SQL-258-get-policy-data-policy.md) - [SQL-259: CreateTask, GeneratePolicyDebtor, GetMarketType, ValidateContext](sql/SQL-259-create-task-policy.md) - [SQL-260: PolicyQuery (property)](sql/SQL-260-policy-query-policy.md) - [SQL-261: FillTaskData, UpdateTask](sql/SQL-261-fill-task-data-policy.md) - [SQL-262: GetExperienceRatingPolicies, GetRelationshipPolicies](sql/SQL-262-get-experience-rating-policies-policy.md) - [SQL-263: FillPolicy](sql/SQL-263-fill-policy-policy.md) - [SQL-264: GetPolicyName, IsPolicyStateEntity](sql/SQL-264-get-policy-name-policy.md) - [SQL-265: AgencyBookList (property), IsValidForAgent, ProducerBookList (property), SaifCorpSecurePolicies](sql/SQL-265-agency-book-list-policy.md) - [SQL-266: ProcessAllServicePlans](sql/SQL-266-process-all-service-plans-policy.md) - [SQL-267: CreateTask, CreateTaskStateless, UpdateTask](sql/SQL-267-create-task-policy-2.md) --- ## POLICY_OUTPUT_DOCUMENT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `PolicyOutputDocument`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | DOCUMENT_STATUS_CODE, POLICY | | **Business objects** | `PolicyOutputDocument` | ### SQL referencing POLICY_OUTPUT_DOCUMENT - [SQL-041: AddPolicyOutputDocument](sql/SQL-041-add-policy-output-document-policy-output-document.md) - [SQL-268: GenerateAllExternalAgencyNotifications, ReleaseDocuments](sql/SQL-268-generate-all-external-agency-notifications-policy-output-document.md) --- ## POLICY_PERIOD_COVERAGE_BIND | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `PolicyPeriodCoverageBind`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PolicyPeriodCoverageBind` | ### SQL referencing POLICY_PERIOD_COVERAGE_BIND - [SQL-269: GetPolicyPeriodCoverageBind](sql/SQL-269-get-policy-period-coverage-bind-policy-period-coverage-bind.md) --- ## POLICY_RELATIONSHIP | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `PolicyRelationship`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PolicyRelationship` | ### SQL referencing POLICY_RELATIONSHIP - [SQL-270: GetManualAffiliationPolicies](sql/SQL-270-get-manual-affiliation-policies-policy-relationship.md) --- ## POLICY_TEAM_FUNCTION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `PolicyTeamFunction`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | POLICY | | **Business objects** | `PolicyTeamFunction` | ### SQL referencing POLICY_TEAM_FUNCTION - [SQL-271: GetSaifContactData](sql/SQL-271-get-saif-contact-data-policy-team-function.md) - [SQL-272: CreateNotificationTask](sql/SQL-272-create-notification-task-policy-team-function.md) --- ## POSITIVE_PAY_VIEW | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | WCIS_DBA (explicit qualifier in Table()) | | **Purpose** | Backing store for `PositivePayView`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PositivePayView` | ### SQL referencing POSITIVE_PAY_VIEW - [SQL-273: PositivePayViewQuery (property)](sql/SQL-273-positive-pay-view-query-positive-pay-view.md) --- ## PROCESS_SERVER | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ProcessServer`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | PROVIDER_LOCATION | | **Business objects** | `ProcessServer` | ### SQL referencing PROCESS_SERVER - [SQL-274: ListOfProcessServers (property)](sql/SQL-274-list-of-process-servers-process-server.md) --- ## PROVIDER_ADDRESS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `BatchProviderAddress`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Update, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | PROVIDER_ADDRESS_SEQ | | **Related tables** | PROVIDER_LOCATION | | **Business objects** | `BatchProviderAddress` | ### SQL referencing PROVIDER_ADDRESS - [SQL-003: InsertNewProviderAddress](sql/SQL-003-insert-new-provider-address-batch-provider-address.md) - [SQL-093: GetLastInsertId, StatelessProcessProviderAddressesForUpdates](sql/SQL-093-get-last-insert-id-batch-provider-address.md) - [SQL-350: StatelessProcessProviderAddressesForUpdates](sql/SQL-350-stateless-process-provider-addresses-for-updates-batch-provider-addres.md) - [SQL-362: StatelessProcessProviderAddressesForUpdates](sql/SQL-362-stateless-process-provider-addresses-for-updates-batch-provider-addres-2.md) --- ## PROVIDER_LOCATION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ProviderLocation`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | PROVIDER_LOCATION_SEQ | | **Related tables** | CBP_AUDITED_SERVICE, CBP_AUTHORIZATION, CBP_BILL, CBP_BILL_SERVICE, LEGAL_BILL, LEGAL_CASE, PROCESS_SERVER, PROVIDER, PROVIDER_ADDRESS, PROVIDER_IDENTITY, PROVIDER_SERVICE, PROVIDER_TYPE_CODE, REGISTERED_AGENT, SUBPOENA, SUBPOENA_RECIPIENT | | **Business objects** | `ProviderLocation` | ### SQL referencing PROVIDER_LOCATION - [SQL-275: CreateAuthorization, UpdateAuthorization](sql/SQL-275-create-authorization-provider-location.md) - [SQL-276: SaveLegalBill](sql/SQL-276-save-legal-bill-provider-location.md) - [SQL-277: CreateService, UpdateService](sql/SQL-277-create-service-provider-location.md) - [SQL-278: SaveRecipients, SetSubpoenaData](sql/SQL-278-save-recipients-provider-location.md) - [SQL-279: ListOfProcessServers (property), ListOfRegisteredAgents (property)](sql/SQL-279-list-of-process-servers-provider-location.md) --- ## PURCHASEORDERCOMMENTS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `PurchaseOrderComment`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PurchaseOrderComment` | ### SQL referencing PURCHASEORDERCOMMENTS - [SQL-281: RetrievePurchaseOrderComments](sql/SQL-281-retrieve-purchase-order-comments-purchase-order-comment.md) --- ## PURCHASEORDERLINECOMMENTS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | INFR_DBA (explicit qualifier in Table()) | | **Purpose** | Backing store for `PurchaseOrderLineComment`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PurchaseOrderLineComment` | ### SQL referencing PURCHASEORDERLINECOMMENTS - [SQL-282: RetrievePurchaseOrderLineComments](sql/SQL-282-retrieve-purchase-order-line-comments-purchase-order-line-comment.md) --- ## PURCHASEORDERSVIEW | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `PurchaseOrder`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | PURCHASEORDERLINESVIEW | | **Business objects** | `PurchaseOrder` | ### SQL referencing PURCHASEORDERSVIEW - [SQL-280: RetrievePurchaseOrders](sql/SQL-280-retrieve-purchase-orders-purchase-order.md) --- ## RCT_POLICIES_TO_TRANSMIT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `RctPolicyToTransmit`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Update, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `RctPolicyToTransmit` | ### SQL referencing RCT_POLICIES_TO_TRANSMIT - [SQL-047: InsertRctPolicyToTransmit](sql/SQL-047-insert-rct-policy-to-transmit-rct-policy-to-transmit.md) - [SQL-289: GetPoliciesToTransmit](sql/SQL-289-get-policies-to-transmit-rct-policy-to-transmit.md) - [SQL-359: UpdateRctPolicyToTransmit](sql/SQL-359-update-rct-policy-to-transmit-rct-policy-to-transmit.md) - [SQL-390: RemoveRctPolicyToTransmit](sql/SQL-390-remove-rct-policy-to-transmit-rct-policy-to-transmit.md) --- ## RCT_POLICY_SELECTED | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `RctPolicySelected`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Update | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `RctPolicySelected` | ### SQL referencing RCT_POLICY_SELECTED - [SQL-044: InsertRctPolicySelected](sql/SQL-044-insert-rct-policy-selected-rct-policy-selected.md) - [SQL-285: GetRctPolicySelected, ModifyRctPolicySelected](sql/SQL-285-get-rct-policy-selected-rct-policy-selected.md) - [SQL-357: ModifyRctPolicySelected](sql/SQL-357-modify-rct-policy-selected-rct-policy-selected.md) --- ## RCT_STAGING_POLICY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `RctPolicyStagingData`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | RCT_STAGING_POLICY_SEQ | | **Related tables** | RCT_STAGING_POLICY_LOCATION | | **Business objects** | `RctPolicyStagingData` | ### SQL referencing RCT_STAGING_POLICY - [SQL-046: LoadRctPolicyStagingData](sql/SQL-046-load-rct-policy-staging-data-rct-policy-staging-data.md) - [SQL-287: GetPolicyStagingPolicies, RemoveAllRctPolicyStagingData](sql/SQL-287-get-policy-staging-policies-rct-policy-staging-data.md) - [SQL-288: GetPolicyStagingPolicies](sql/SQL-288-get-policy-staging-policies-rct-policy-staging-data-2.md) - [SQL-389: RemoveAllRctPolicyStagingData](sql/SQL-389-remove-all-rct-policy-staging-data-rct-policy-staging-data.md) --- ## RCT_STAGING_POLICY_LOCATION | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `RctLocationStagingData`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | RCT_STAGING_LOCATION_SEQ | | **Related tables** | RCT_STAGING_POLICY | | **Business objects** | `RctLocationStagingData` | ### SQL referencing RCT_STAGING_POLICY_LOCATION - [SQL-043: LoadRctPolicyStagingData](sql/SQL-043-load-rct-policy-staging-data-rct-location-staging-data.md) - [SQL-283: RemoveAllRctPolicyStagingData](sql/SQL-283-remove-all-rct-policy-staging-data-rct-location-staging-data.md) - [SQL-284: GetPolicyStagingPolicies](sql/SQL-284-get-policy-staging-policies-rct-location-staging-data.md) - [SQL-388: RemoveAllRctPolicyStagingData](sql/SQL-388-remove-all-rct-policy-staging-data-rct-location-staging-data-2.md) --- ## REGISTERED_AGENT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `RegisteredAgent`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | PROVIDER, PROVIDER_LOCATION | | **Business objects** | `RegisteredAgent` | ### SQL referencing REGISTERED_AGENT - [SQL-293: ListOfRegisteredAgents (property)](sql/SQL-293-list-of-registered-agents-registered-agent.md) --- ## RTW_CASE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `RTWCase`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | POLICY, RTW_LOAD_CODE | | **Business objects** | `RTWCase` | ### SQL referencing RTW_CASE - [SQL-294: CanAccessRTWClaim](sql/SQL-294-can-access-rtw-claim-rtw-case.md) --- ## RTW_LOAD_ASSIGNMENT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `RtwLoadAssignment`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | RTW_LOAD_CODE | | **Business objects** | `RtwLoadAssignment` | ### SQL referencing RTW_LOAD_ASSIGNMENT - [SQL-295: GetRTWLoadCode](sql/SQL-295-get-rtw-load-code-rtw-load-assignment.md) --- ## RUN_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `RunTypeCode`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | DOCUMENT_TEMPLATE | | **Business objects** | `RunTypeCode` | ### SQL referencing RUN_TYPE_CODE - [SQL-296: GetRunTypes](sql/SQL-296-get-run-types-run-type-code.md) --- ## SUBJECT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Referenced via native SQL join in `InvestigationRepositoryExtensions.GetSubjectName`/`GetClaimId` (no NHibernate `ClassMap`; accessed only through hand-written `CreateSqlQuery` text) | | **Access pattern** | Inline SQL (NHibernate `CreateSqlQuery`) — literal SQL text, not ORM-mediated | | **CRUD operations** | Read | | **Key columns used** | SUBJECT_SEQ_NUM, PERSON_SEQ_NUM, COMPANY_SEQ_NUM, WORKER_ID | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `FraudInvestigationService` | ### SQL referencing SUBJECT - [SQL-214: GetClaimId, GetSubjectNameAsync](sql/SQL-214-get-claim-id-investigation.md) --- ## SUBPOENA | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Subpoena`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | SUBPOENA_SEQ | | **Related tables** | HEARING_LOCATION, LEGAL_CASE, PROVIDER_LOCATION, SUBPOENA_RECIPIENT, SUBPOENA_SPECIAL_HANDLING_CODE, SUBPOENA_STATUS_CODE, SUBPOENA_TYPE_CODE | | **Business objects** | `Subpoena` | ### SQL referencing SUBPOENA - [SQL-049: SaveSubpoena](sql/SQL-049-save-subpoena-subpoena.md) - [SQL-304: GenerateOpposingCounselDocuments, UpdateSubpoenaStatus](sql/SQL-304-generate-opposing-counsel-documents-subpoena.md) - [SQL-305: AddSubpoenaDocumentToList, GenerateCashDisbursement, GetPreviewSubpoena, GetProcessServerEmailSubpoena, PrintSubpoena](sql/SQL-305-add-subpoena-document-to-list-subpoena.md) - [SQL-306: GenerateBatchLabels, GetSubpoena](sql/SQL-306-generate-batch-labels-subpoena.md) - [SQL-307: GenerateCheckTransactionsAsync, GetSubpoenas, UpdateSubpoenaStatus](sql/SQL-307-generate-check-transactions-async-subpoena.md) - [SQL-308: DeleteSubpoena, SaveSubpoena](sql/SQL-308-delete-subpoena-subpoena.md) - [SQL-309: GetInboxItems, GetSubpoena](sql/SQL-309-get-inbox-items-subpoena.md) - [SQL-310: GetApprovedSubpoenas](sql/SQL-310-get-approved-subpoenas-subpoena.md) - [SQL-311: GenerateZeroPayDocuments](sql/SQL-311-generate-zero-pay-documents-subpoena.md) - [SQL-392: DeleteSubpoena](sql/SQL-392-delete-subpoena-subpoena-2.md) --- ## SUBPOENA_RECIPIENT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Recipient`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | SUBPOENA_RECIPIENT_SEQ | | **Related tables** | LEGAL_PERSON, LOCATION, PROVIDER_LOCATION, SUBPOENA | | **Business objects** | `Recipient` | ### SQL referencing SUBPOENA_RECIPIENT - [SQL-291: ReturnSubpoenaPaymentAsync](sql/SQL-291-return-subpoena-payment-async-recipient.md) - [SQL-292: SaveRecipients](sql/SQL-292-save-recipients-recipient.md) --- ## SUBPOENA_SPECIAL_HANDLING_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `SubpoenaSpecialHandling`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | SUBPOENA | | **Business objects** | `SubpoenaSpecialHandling` | ### SQL referencing SUBPOENA_SPECIAL_HANDLING_CODE - [SQL-312: ListOfMailingOptions (property)](sql/SQL-312-list-of-mailing-options-subpoena-special-handling.md) --- ## SUBPOENA_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `SubpoenaStatus`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | SUBPOENA | | **Business objects** | `SubpoenaStatus` | ### SQL referencing SUBPOENA_STATUS_CODE - [SQL-313: UpdateSubpoenaStatus](sql/SQL-313-update-subpoena-status-subpoena-status.md) - [SQL-314: SetNewSubpoenaStatus](sql/SQL-314-set-new-subpoena-status-subpoena-status.md) - [SQL-315: ListOfSubpoenaStatus (property)](sql/SQL-315-list-of-subpoena-status-subpoena-status.md) --- ## SUBPOENA_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `SubpoenaType`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | SUBPOENA | | **Business objects** | `SubpoenaType` | ### SQL referencing SUBPOENA_TYPE_CODE - [SQL-316: ListOfSubpoenaTypes (property)](sql/SQL-316-list-of-subpoena-types-subpoena-type.md) --- ## SYSTEM_USER | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `SystemUser`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | SYSTEM_USER_TYPE_CODE | | **Business objects** | `SystemUser` | ### SQL referencing SYSTEM_USER - [SQL-317: ExtractUsers](sql/SQL-317-extract-users-system-user.md) --- ## SYSTEM_USER_XREF | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `SystemUserRef`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | SYSTEM_USER_XREF_SEQ | | **Related tables** | None identified | | **Business objects** | `SystemUserRef` | ### SQL referencing SYSTEM_USER_XREF - [SQL-318: ExtractUsers, UpdateUserAccess](sql/SQL-318-extract-users-system-user-ref.md) --- ## TASK | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Task`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | TASK_SEQ | | **Related tables** | CLAIM_TASK_GROUP_CODE, NOTE_CATEGORY_CODE, POLICY, TASK_ACTION_CODE, TASK_CATEGORY_CODE, TASK_PRIORITY_CODE, TASK_SOURCE_CODE | | **Business objects** | `Task` | ### SQL referencing TASK - [SQL-050: CreateTask](sql/SQL-050-create-task-task.md) - [SQL-051: AddExpiredJudgmentTask, AddExpiredLocationTask, AddPaymentTask](sql/SQL-051-add-expired-judgment-task-task.md) - [SQL-052: CreateTask, CreateTaskStateless](sql/SQL-052-create-task-task-2.md) - [SQL-053: CreateMarketingTask, CreateUnderwritingTask](sql/SQL-053-create-marketing-task-task.md) - [SQL-054: CreateTask, CreateTaskStateless](sql/SQL-054-create-task-task-3.md) - [SQL-319: GetClaimBillQueueRemainingCount](sql/SQL-319-get-claim-bill-queue-remaining-count-task.md) - [SQL-320: GetTaskData, GetTasks](sql/SQL-320-get-task-data-task.md) - [SQL-321: RemoveExitingTasks](sql/SQL-321-remove-exiting-tasks-task.md) - [SQL-322: TaskQuery (property)](sql/SQL-322-task-query-task.md) - [SQL-323: TaskQuery (property)](sql/SQL-323-task-query-task-2.md) --- ## TASK_ACTION_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `TaskAction`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | TASK, TASK_CATEGORY_CODE | | **Business objects** | `TaskAction` | ### SQL referencing TASK_ACTION_CODE - [SQL-324: CreateTask](sql/SQL-324-create-task-task-action.md) - [SQL-325: SetCommonPropteryValues](sql/SQL-325-set-common-proptery-values-task-action.md) --- ## TASK_CATEGORY_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `TaskCategory`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | TASK, TASK_ACTION_CODE, TASK_PRIORITY_CODE, TASK_SOURCE_CODE | | **Business objects** | `TaskCategory` | ### SQL referencing TASK_CATEGORY_CODE - [SQL-326: CreateTask](sql/SQL-326-create-task-task-category.md) - [SQL-327: SetCommonPropteryValues](sql/SQL-327-set-common-proptery-values-task-category.md) - [SQL-328: DetermineCategory, GetManualEntryCategories, ReassignTasks](sql/SQL-328-determine-category-task-category.md) - [SQL-329: CreateTask, CreateTaskStateless, ReassignTasks](sql/SQL-329-create-task-task-category-2.md) --- ## TASK_PRIORITY_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `TaskPriority`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | TASK, TASK_CATEGORY_CODE | | **Business objects** | `TaskPriority` | ### SQL referencing TASK_PRIORITY_CODE - [SQL-332: CreateTask](sql/SQL-332-create-task-task-priority.md) - [SQL-333: SetCommonPropteryValues](sql/SQL-333-set-common-proptery-values-task-priority.md) - [SQL-334: FillTaskData, ReassignTasks](sql/SQL-334-fill-task-data-task-priority.md) - [SQL-335: CreateTask, CreateTaskStateless, GetAdditionalInfoTask, ReassignTasks](sql/SQL-335-create-task-task-priority-2.md) --- ## TASK_SOURCE_CODE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `TaskSource`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | TASK, TASK_CATEGORY_CODE | | **Business objects** | `TaskSource` | ### SQL referencing TASK_SOURCE_CODE - [SQL-336: CreateTask](sql/SQL-336-create-task-task-source.md) - [SQL-337: SetCommonPropteryValues](sql/SQL-337-set-common-proptery-values-task-source.md) --- ## TEMP_DATA_PERSON_ADDRESS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | CLM_DBA (explicit qualifier in Table()) | | **Purpose** | Backing store for `TempDataPersonAddress`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Create, Read, Delete | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `TempDataPersonAddress` | ### SQL referencing TEMP_DATA_PERSON_ADDRESS - [SQL-055: InsertTempRecords](sql/SQL-055-insert-temp-records-temp-data-person-address.md) - [SQL-056: InsertTempRecords](sql/SQL-056-insert-temp-records-temp-data-person-address-2.md) - [SQL-338: DeleteTempRecords](sql/SQL-338-delete-temp-records-temp-data-person-address.md) - [SQL-339: DeleteTempRecords](sql/SQL-339-delete-temp-records-temp-data-person-address-2.md) - [SQL-393: DeleteTempRecords](sql/SQL-393-delete-temp-records-temp-data-person-address-3.md) - [SQL-394: DeleteTempRecords](sql/SQL-394-delete-temp-records-temp-data-person-address-4.md) --- ## THRDPARTY | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ThirdParty`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | THRDPARTY_SEQ | | **Related tables** | THRDPARTY_CASE, THRDPARTY_FIRM | | **Business objects** | `ThirdParty` | ### SQL referencing THRDPARTY - [SQL-340: GenerateThirdPartyDebtor](sql/SQL-340-generate-third-party-debtor-third-party.md) --- ## THRDPARTY_CASE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `ThirdPartyCase`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | THRDPARTY_CASE_SEQ | | **Related tables** | CAUSE_OF_ACTION_CODE, THRDPARTY, THRDPARTY_ADJUSTER_CODE, THRDPARTY_COMPANION_CLAIM, THRDPARTY_FIRM, THRDPARTY_STATUS_CODE, THRDPARTY_STATUS_HIST, THRDPARTY_TYPE_CODE | | **Business objects** | `ThirdPartyCase` | ### SQL referencing THRDPARTY_CASE - [SQL-341: GenerateThirdPartyDebtor](sql/SQL-341-generate-third-party-debtor-third-party-case.md) --- ## TRADING_AS | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `TradingAs`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | CERTIFICATE_DETAIL, POLICY | | **Business objects** | `TradingAs` | ### SQL referencing TRADING_AS - [SQL-342: GetTradingAsById](sql/SQL-342-get-trading-as-by-id-trading-as.md) --- ## USER_PREFERENCE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `Preference`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (external `PreferencesMap` in `SAIF.Framework.Data.NHibernate`) — table name confirmed via Legends CLI; some column pairings unresolved | | **CRUD operations** | Create | | **Key columns used** | USER_PREFERENCE_SEQ_NUM, USER_ID, APP_NAME, PAGE_NAME, PREFERENCE_TEXT, UPDATE_DATE, UPDATE_USER | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `Preference` | ### SQL referencing USER_PREFERENCE - [SQL-042: SavePreferences](sql/SQL-042-save-preferences-preference.md) --- ## WCIS_EMPLOYEE | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `WcisEmployee`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (external `WcisEmployeeMap` in `SAIF.Framework.Data.NHibernate`) — table name confirmed via Legends CLI; column mappings unresolved | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL document for C# property names** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `WcisEmployee` | ### SQL referencing WCIS_EMPLOYEE - [SQL-346: ExtractUsers](sql/SQL-346-extract-users-wcis-employee.md) --- ## WRITEOFF_APPROVAL_USER | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `WriteOffApprovalUser`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | N/A | | **Related tables** | LEGAL_COLLECTION_TRANSACTION | | **Business objects** | `WriteOffApprovalUser` | ### SQL referencing WRITEOFF_APPROVAL_USER - [SQL-347: GetWriteOffApprovalUsers](sql/SQL-347-get-write-off-approval-users-write-off-approval-user.md) --- ## XDEFERRED_PRINT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `XDeferredPrint`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (`GetRepository()`) — no direct SQL or stored procedures | | **CRUD operations** | Read | | **Key columns used** | Not enumerable from ORM mapping alone; see linked SQL documents for parameter-level detail** | | **Sequence** | XDEFERRED_SEQ | | **Related tables** | None identified | | **Business objects** | `XDeferredPrint` | ### SQL referencing XDEFERRED_PRINT - [SQL-348: GetOneXDeferredPrint](sql/SQL-348-get-one-x-deferred-print-x-deferred-print.md) --- ## XDOCUMENT | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `XDocument`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (external `XDocumentMap` in `SAIF.Framework.Data.NHibernate`) — table name and native sequence confirmed via Legends CLI; some column pairings unresolved | | **CRUD operations** | Create | | **Key columns used** | XDOCUMENT_SEQ_NUM, XPRINT_CONTROL_SEQ_NUM, XBIN_TYPE_CODE, DOCUMENT_TYPE_CODE, DUPLEX_CODE, FILE_NAME, EMAIL_ADDRESS, FAX_NUM, IDX_CONTENTS_TEXT, PRINT_GROUP_TEXT, START_VALUE, COPIES_COUNT, SORT0_VALUE-SORT9_VALUE | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `XDocument` | ### SQL referencing XDOCUMENT - [SQL-060: CreateXDocument](sql/SQL-060-create-x-document-x-document.md) - [SQL-061: GetCertificateBatchReportByCertHolder, GetCertificateBatchReportByPolicy, GetSummaryReportForPolicy](sql/SQL-061-get-certificate-batch-report-by-cert-holder-x-document.md) - [SQL-062: UpdateSubpoenaStatus](sql/SQL-062-update-subpoena-status-x-document.md) - [SQL-063: GenerateCashDisbursements](sql/SQL-063-generate-cash-disbursements-x-document.md) - [SQL-064: CreateXDocument](sql/SQL-064-create-x-document-x-document-2.md) --- ## XPRINT_CONTROL | Field | Value | | --- | --- | | **Database** | Oracle | | **Schema/Link** | [unqualified]** | | **Purpose** | Backing store for `XPrintControl`, accessed via `IUnitOfWork.GetRepository()` | | **Access pattern** | NHibernate ORM (external `XPrintControlMap` in `SAIF.Framework.Data.NHibernate`) — table name and identifier column confirmed via Legends CLI; some column pairings unresolved | | **CRUD operations** | Create | | **Key columns used** | XPRINT_CONTROL_SEQ_NUM; remaining columns per linked SQL documents** | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `XPrintControl` | ### SQL referencing XPRINT_CONTROL - [SQL-065: GenerateZeroPaymentLetters](sql/SQL-065-generate-zero-payment-letters-x-print-control.md) - [SQL-066: GetCertificateBatchReportXml, GetCertificateSummaryReport](sql/SQL-066-get-certificate-batch-report-xml-x-print-control.md) - [SQL-067: GenerateOpposingCounselDocuments](sql/SQL-067-generate-opposing-counsel-documents-x-print-control.md) - [SQL-068: GenerateWitnessCashDisbursementRequest, GenerateWitnessDocuments](sql/SQL-068-generate-witness-cash-disbursement-request-x-print-control.md) - [SQL-069: CreateXPrintControl](sql/SQL-069-create-x-print-control-x-print-control.md) --- ## Unmapped entities The following 17 generic-repository type arguments were passed to `IUnitOfWork.GetRepository()` / `GetSystemRepository()` but could not be resolved to a specific `ClassMap`/backing table from static analysis; they are marked `**` throughout this documentation set. | Type argument | Resolved entity | Entity class | CRUD | Call sites | | --- | --- | --- | --- | --- | | `DocumentImageTypeCode` | `SAIF.Data.Model.Documents.DocumentImageTypeCode` | Data/SAIF.Data/Model/Documents/DocumentImageTypeCode.cs | R | Services/SAIF.Services/Documents/DocumentRequestService.cs | | `DataModel.DocumentRequestParameter` | `SAIF.Data.Model.Documents.DocumentRequestParameter` | Data/SAIF.Data/Model/Documents/DocumentRequestParameter.cs | C/R | Services/SAIF.Services/Documents/DocumentParameterService.cs | | `DataModel.DocumentTemplateParameter` | `SAIF.Data.Model.Documents.DocumentTemplateParameter` | Data/SAIF.Data/Model/Documents/DocumentTemplateParameter.cs | R | Services/SAIF.Services/Documents/DocumentParameterService.cs | | `Data.Model.Employees.Employee`, `Employee`, `EmployeeData.Employee` | `SAIF.Data.Model.Employees.Employee`* | not found** | R | Services/SAIF.Services/Claims/Authority/ClaimAuthorityService.cs; Services/SAIF.Services/Claims/Bills/Validators/SendPendRequestValidator.cs; Services/SAIF.Services/Claims/Information/ClaimInformationService.cs; Services/SAIF.Services/Claims/SecurityOverride/SecurityOverrideService.cs; Services/SAIF.Services/Imaging/AutoImportHelperService.cs; Services/SAIF.Services/Legal/Bills/BillPaymentService.cs; Services/SAIF.Services/Legal/Bills/BillService.cs; Services/SAIF.Services/Legal/Subpoenas/SubpoenaDocumentService.cs; Services/SAIF.Services/Legal/Subpoenas/SubpoenaLabelService.cs; Services/SAIF.Services/Legal/Subpoenas/SubpoenaPaymentService.cs; Services/SAIF.Services/Legal/Subpoenas/SubpoenaService.cs | | `ExternalUserType` | `SAIF.Data.Model.Users.ExternalUserType` | not found** | R | Services/SAIF.Services/Agencies/AgencyService.cs | | `Data.Model.Imaging.Image` | `SAIF.Data.Model.Imaging.Image` | not found** | R | Services/SAIF.Services/Agencies/Imaging/ImageService.cs | | `imagingDataModel.ImageCategoryCode` | `SAIF.Data.Model.Imaging.ImageCategoryCode` | not found** | R | Services/SAIF.Services/Agencies/Imaging/ImageService.cs | | `imagingDataModel.ImageDocumentTypeCode` | `SAIF.Data.Model.Imaging.ImageDocumentTypeCode` | not found** | R | Services/SAIF.Services/Agencies/Imaging/ImageService.cs | | `SAIF.Data.Model.PDF.PDFApplicationErrorCode` | `SAIF.Data.Model.PDF.PDFApplicationErrorCode` | not found** | R | Services/SAIF.Services/Utilities/Pdf/PdfTrackingService.cs | | `SAIF.Data.Model.PDF.PDFStatusCode` | `SAIF.Data.Model.PDF.PDFStatusCode` | not found** | R | Services/SAIF.Services/Utilities/Pdf/PdfTrackingService.cs | | `SAIF.Data.Model.PDF.PDFTracking` | `SAIF.Data.Model.PDF.PDFTracking` | not found** | R | Services/SAIF.Services/Utilities/Pdf/PdfTrackingService.cs | | `SAIF.Data.Model.PDF.PDFTrackingCode` | `SAIF.Data.Model.PDF.PDFTrackingCode` | not found** | R | Services/SAIF.Services/Utilities/Pdf/PdfTrackingService.cs | | `Preference` | `SAIF.Data.Model.Preferences.Preference`* | not found** | C | Services/SAIF.Services/Claims/Notes/NotePreferenceConversionService.cs | | `ContactDataModel.StateCode`, `Data.Model.Contacts.StateCode` | `SAIF.Data.Model.Contacts.StateCode` | not found** | R | Services/SAIF.Services/Collections/CollectionsService.cs; Services/SAIF.Services/Policies/Certificates/Information/CertificateInformationService.cs | | `WcisEmployee` | `SAIF.Data.Model.Employees.WcisEmployee`* | not found** | R | Services/SAIF.Services/SystemUsers/UserExtractService.cs | | `PrintData.XDocument` | `SAIF.Data.Model.Printing.XDocument` | not found** | C | Services/SAIF.Services/Legal/Bills/BillPaymentService.cs; Services/SAIF.Services/Legal/Subpoenas/OpposingCounselService.cs; Services/SAIF.Services/Legal/Subpoenas/WitnessSubpoenaProcess.cs; Services/SAIF.Services/Legal/Subpoenas/ZeroPaySubpoenaProcess.cs; Services/SAIF.Services/Policies/Certificates/DocumentService.cs | | `PrintData.XPrintControl` | `SAIF.Data.Model.Printing.XPrintControl` | not found** | C | Services/SAIF.Services/Legal/Bills/BillPaymentService.cs; Services/SAIF.Services/Legal/Subpoenas/OpposingCounselService.cs; Services/SAIF.Services/Legal/Subpoenas/WitnessSubpoenaProcess.cs; Services/SAIF.Services/Legal/Subpoenas/ZeroPaySubpoenaProcess.cs; Services/SAIF.Services/Policies/Certificates/DocumentService.cs | ## Table relationship diagram The following diagram shows a representative subset of the 205 table relationships discovered across this library's NHibernate mappings (foreign-key associations verified via `ClassMap` `References`/`HasMany` declarations). The full relationship list is enumerated per-table above; showing all 205 edges in one diagram is not legible, so this diagram illustrates the most-connected tables. ```mermaid erDiagram CBP_BILL ||--o{ CBP_AUDITED_SERVICE : "one-to-many" CBP_BILL ||--o{ CBP_BILL_SERVICE : "one-to-many" LEGAL_CASE ||--o{ LEGAL_BILL : "one-to-many" LEGAL_CASE ||--o{ SUBPOENA : "one-to-many" OSC_POLICY_VIEW ||--o{ CERTIFICATE_DETAIL : "one-to-many" POLICY ||--o{ OSC_POLICY_VIEW : "one-to-many" POLICY ||--o{ POLICY : "one-to-many" POLICY ||--o{ TASK : "one-to-many" PROVIDER_LOCATION ||--o{ CBP_AUDITED_SERVICE : "one-to-many" PROVIDER_LOCATION ||--o{ CBP_BILL : "one-to-many" PROVIDER_LOCATION ||--o{ CBP_BILL_SERVICE : "one-to-many" PROVIDER_LOCATION ||--o{ LEGAL_BILL : "one-to-many" PROVIDER_LOCATION ||--o{ LEGAL_CASE : "one-to-many" PROVIDER_LOCATION ||--o{ SUBPOENA : "one-to-many" PROVIDER_LOCATION ||--o{ SUBPOENA_RECIPIENT : "one-to-many" SUBPOENA ||--o{ SUBPOENA_RECIPIENT : "one-to-many" THRDPARTY_FIRM ||--o{ THRDPARTY_CASE : "one-to-many" ``` ## 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) - [SQL catalog](sql/index.md) - [API reference](api/index.md) ## Sources - `Data/SAIF.Data.NHibernate/Mappings/` - `Services/SAIF.Services/`