--- title: SAIF.Data database tables summary: Database tables used by SAIF.Data's query providers, with relationships and usage context. status: draft owner: SAIF.Core documentation team last_reviewed: 2026-09-24 library: SAIF.Data reference_type: package --- # SAIF.Data database tables This page catalogs the 141 database tables accessed by this library's query providers via NHibernate LINQ (`saif-data-db-analysis.md`). All access is ORM-based; there are no raw SQL statements or stored procedures**. ## Table catalog | Table | Database | Schema/Link | CRUD | Purpose | Primary business object | | --- | --- | --- | --- | --- | --- | | [ADDRESS_VERIFICATION_REQUEST](#address_verification_request) | Oracle* | [unqualified]** | R | Accessed by `AddressVerificationQueryProvider` | `AddressVerificationQueryProvider` | | [ADP_EMPLOYEE](#adp_employee) | Unknown** | Unknown** | R | Accessed by `LegalQueryProvider` | `LegalQueryProvider` | | [APPEAL](#appeal) | Oracle* | [unqualified]** | R | Accessed by `LegalQueryProvider` | `LegalQueryProvider` | | [ATTENDING_PHYSICIAN](#attending_physician) | Oracle* | [unqualified]** | R | Accessed by `ReportQueryProvider` | `ReportQueryProvider` | | [ATTORNEY_PROFILE](#attorney_profile) | Oracle* | [unqualified]** | R | Accessed by `LegalQueryProvider` | `LegalQueryProvider` | | [Agency](#agency) | Oracle* | [unqualified]** | CR | Accessed by `PolicyExtensions` | `PolicyExtensions` | | [Agent](#agent) | Oracle* | [unqualified]** | CR | Accessed by `PolicyExtensions`, `PolicyOutputDocumentExtensions` | `PolicyExtensions`, `PolicyOutputDocumentExtensions` | | [App_Error](#app_error) | Oracle* | [unqualified]** | R | Accessed by `OnlineSupportExtensions` | `OnlineSupportExtensions` | | [BUSINESS](#business) | Oracle* | [unqualified]** | R | Accessed by `PolicyQueryProvider` | `PolicyQueryProvider` | | [CASE_COST](#case_cost) | Oracle* | [unqualified]** | R | Accessed by `LegalQueryProvider` | `LegalQueryProvider` | | [CASE_STATUS_CODE](#case_status_code) | Oracle* | [unqualified]** | R | Accessed by `LegalQueryProvider` | `LegalQueryProvider` | | [CBP_AUDIT](#cbp_audit) | Oracle* | [unqualified]** | R | Accessed by `AuditQueryProvider`, `BillQueryProvider`, `EbillEobQueryProvider` | `AuditQueryProvider`, `BillQueryProvider`, `EbillEobQueryProvider` | | [CBP_AUDITED_SERVICE](#cbp_audited_service) | Oracle* | [unqualified]** | R | Accessed by `AuditQueryProvider`, `BillQueryProvider` | `AuditQueryProvider`, `BillQueryProvider` | | [CBP_AUDIT_ADJUSTMENT_TYPE](#cbp_audit_adjustment_type) | Oracle* | [unqualified]** | R | Accessed by `AuditQueryProvider` | `AuditQueryProvider` | | [CBP_BILL](#cbp_bill) | Oracle* | [unqualified]** | R | Accessed by `AuditQueryProvider`, `BillQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider`, `ProviderQueryProvider` | `AuditQueryProvider`, `BillQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider`, `ProviderQueryProvider` | | [CBP_BILL_ENTRY_SOURCE_CODE](#cbp_bill_entry_source_code) | Oracle* | [unqualified]** | R | Accessed by `BillQueryProvider` | `BillQueryProvider` | | [CBP_BILL_STATUS](#cbp_bill_status) | Oracle* | [unqualified]** | R | Accessed by `BillQueryProvider` | `BillQueryProvider` | | [CBP_BILL_STATUS_CODE](#cbp_bill_status_code) | Oracle* | [unqualified]** | R | Accessed by `BillQueryProvider` | `BillQueryProvider` | | [CBP_BILL_TYPE_CODE](#cbp_bill_type_code) | Oracle* | [unqualified]** | R | Accessed by `BillQueryProvider` | `BillQueryProvider` | | [CBP_CPT_SERVICE](#cbp_cpt_service) | Oracle* | [unqualified]** | R | Accessed by `ServiceCodeMaintenanceQueryProvider` | `ServiceCodeMaintenanceQueryProvider` | | [CBP_DIAGNOSIS](#cbp_diagnosis) | Oracle* | [unqualified]** | R | Accessed by `BillQueryProvider` | `BillQueryProvider` | | [CBP_DIAGNOSIS_TYPE_CODE](#cbp_diagnosis_type_code) | Oracle* | [unqualified]** | R | Accessed by `BillQueryProvider` | `BillQueryProvider` | | [CBP_NATIONAL_DRUG](#cbp_national_drug) | Oracle* | [unqualified]** | R | Accessed by `AuditQueryProvider`, `BillQueryProvider` | `AuditQueryProvider`, `BillQueryProvider` | | [CBP_NOTE](#cbp_note) | Oracle* | [unqualified]** | R | Accessed by `AuditNoteQueryProvider` | `AuditNoteQueryProvider` | | [CBP_NOTE_CATEGORY_CODE](#cbp_note_category_code) | Oracle* | [unqualified]** | R | Accessed by `AuditNoteQueryProvider` | `AuditNoteQueryProvider` | | [CBP_NOTE_TYPE_CODE](#cbp_note_type_code) | Oracle* | [unqualified]** | R | Accessed by `AuditNoteQueryProvider` | `AuditNoteQueryProvider` | | [CBP_PROCEDURE_CODE](#cbp_procedure_code) | Oracle* | [unqualified]** | R | Accessed by `BillQueryProvider`, `ServiceCodeQueryProvider` | `BillQueryProvider`, `ServiceCodeQueryProvider` | | [CBP_SERVICE_CODE](#cbp_service_code) | Oracle* | [unqualified]** | R | Accessed by `AuditQueryProvider`, `BillQueryProvider`, `ServiceCodeMaintenanceQueryProvider`, `ServiceCodeQueryProvider` | `AuditQueryProvider`, `BillQueryProvider`, `ServiceCodeMaintenanceQueryProvider`, `ServiceCodeQueryProvider` | | [CBP_SERVICE_DESCRIPTION](#cbp_service_description) | Oracle* | [unqualified]** | R | Accessed by `BillQueryProvider`, `ServiceCodeMaintenanceQueryProvider` | `BillQueryProvider`, `ServiceCodeMaintenanceQueryProvider` | | [CBP_SERVICE_FEE](#cbp_service_fee) | Unknown** | Unknown** | R | Accessed by `ServiceCodeMaintenanceQueryProvider` | `ServiceCodeMaintenanceQueryProvider` | | [CBP_SERVICE_PHYSICAL_MEDICINE](#cbp_service_physical_medicine) | Oracle* | [unqualified]** | R | Accessed by `AuditQueryProvider` | `AuditQueryProvider` | | [CBP_SERVICE_TYPE_CODE](#cbp_service_type_code) | Oracle* | [unqualified]** | R | Accessed by `BillQueryProvider` | `BillQueryProvider` | | [CERTIFICATE_HOLDER](#certificate_holder) | Oracle* | [unqualified]** | R | Accessed by `CertificateHolderQueryProvider` | `CertificateHolderQueryProvider` | | [CLAIM_ADDRESS_TYPE_CODE](#claim_address_type_code) | Oracle* | [unqualified]** | R | Accessed by `AddressBuilder`, `ClaimCodeTableBuilder` | `AddressBuilder`, `ClaimCodeTableBuilder` | | [CL_CLAIM_LEGAL_REPRESENTATIVE](#cl_claim_legal_representative) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider`, `ReportQueryProvider` | `ClaimQueryProvider`, `ReportQueryProvider` | | [CL_CLAIM_PERSON](#cl_claim_person) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider` | `ClaimQueryProvider` | | [CL_CLAIM_PERSON_ADDRESS](#cl_claim_person_address) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider` | `ClaimQueryProvider` | | [CL_CLAIM_REQUEST_DECISION](#cl_claim_request_decision) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider` | `ClaimQueryProvider` | | [CL_CLAIM_RESPONSIBILITY](#cl_claim_responsibility) | Oracle* | [unqualified]** | CR | Accessed by `ClaimCodeTableBuilder` | `ClaimCodeTableBuilder` | | [CL_CLAIM_STATUS_ACTIVITY](#cl_claim_status_activity) | Oracle* | [unqualified]** | CR | Accessed by `ClaimBuilder`, `ClaimQueryProvider` | `ClaimBuilder`, `ClaimQueryProvider` | | [CL_CLAIM_SUPPORT_ORDER](#cl_claim_support_order) | Oracle* | [unqualified]** | R | Accessed by `WorkerQueryProvider` | `WorkerQueryProvider` | | [CL_CLAIM_TYPE_ACTIVITY](#cl_claim_type_activity) | Oracle* | [unqualified]** | C | Accessed by `ClaimBuilder` | `ClaimBuilder` | | [CL_CLAIM_TYPE_CODE](#cl_claim_type_code) | Oracle* | [unqualified]** | R | Accessed by `ClaimBuilder`, `ClaimCodeTableBuilder`, `ClaimQueryProvider` | `ClaimBuilder`, `ClaimCodeTableBuilder`, `ClaimQueryProvider` | | [CL_INCURRED_COST_HISTORY](#cl_incurred_cost_history) | Oracle* | [unqualified]** | R | Accessed by `ReserveQueryProvider` | `ReserveQueryProvider` | | [CL_INJURY_CLAIM](#cl_injury_claim) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider`, `WorkerQueryProvider` | `ClaimQueryProvider`, `WorkerQueryProvider` | | [CL_JURISDICTION_CODE](#cl_jurisdiction_code) | Oracle* | [unqualified]** | R | Accessed by `ClaimCodeTableBuilder` | `ClaimCodeTableBuilder` | | [CL_MEDICAL_CONDITION](#cl_medical_condition) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider` | `ClaimQueryProvider` | | [CL_OVERPAYMENT](#cl_overpayment) | Oracle* | [unqualified]** | R | Accessed by `OverpaymentQueryProvider` | `OverpaymentQueryProvider` | | [CL_PAYMENT_SPCL_HANDLING_CODE](#cl_payment_spcl_handling_code) | Oracle* | [unqualified]** | R | Accessed by `ClaimPaymentQueryProvider` | `ClaimPaymentQueryProvider` | | [CL_PAYMENT_TOTAL](#cl_payment_total) | Oracle* | [unqualified]** | R | Accessed by `ReserveQueryProvider` | `ReserveQueryProvider` | | [CL_PHARMACY_DAW_CODE](#cl_pharmacy_daw_code) | Oracle* | [unqualified]** | R | Accessed by `BillQueryProvider` | `BillQueryProvider` | | [CL_PHARMACY_ELIGIBILITY_REPORT](#cl_pharmacy_eligibility_report) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider` | `ClaimQueryProvider` | | [CL_SECURITY_OVERRIDE](#cl_security_override) | Oracle* | [unqualified]** | R | Accessed by `ClaimSecurityOverrideProvider` | `ClaimSecurityOverrideProvider` | | [CONSOLIDATED_CASE](#consolidated_case) | Oracle* | [unqualified]** | R | Accessed by `LegalQueryProvider` | `LegalQueryProvider` | | [CONTACT](#contact) | Oracle* | [unqualified]** | R | Accessed by `LocationQueryProvider` | `LocationQueryProvider` | | [EAIP_PERIOD](#eaip_period) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider` | `ClaimQueryProvider` | | [EBILL](#ebill) | Oracle* | [unqualified]** | R | Accessed by `EbillDocumentQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider`, `EbillServiceQueryProvider` | `EbillDocumentQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider`, `EbillServiceQueryProvider` | | [EBILL_ADDRESS](#ebill_address) | Oracle* | [unqualified]** | R | Accessed by `EbillAddressQueryProvider` | `EbillAddressQueryProvider` | | [EBILL_ADDRESS_OVERRIDE](#ebill_address_override) | Oracle* | [unqualified]** | R | Accessed by `EbillAddressQueryProvider` | `EbillAddressQueryProvider` | | [EBILL_ADDRESS_TYPE_CODE](#ebill_address_type_code) | Oracle* | [unqualified]** | R | Accessed by `EbillAddressQueryProvider`, `EbillingExtensions` | `EbillAddressQueryProvider`, `EbillingExtensions` | | [EBILL_ASSIGNMENT_RULE](#ebill_assignment_rule) | Oracle* | [unqualified]** | R | Accessed by `EbillQueryProvider` | `EbillQueryProvider` | | [EBILL_BATCH](#ebill_batch) | Oracle* | [unqualified]** | R | Accessed by `EbillBatchQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider` | `EbillBatchQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider` | | [EBILL_BATCH_STATUS_CODE](#ebill_batch_status_code) | Oracle* | [unqualified]** | CR | Accessed by `EbillBatchQueryProvider`, `EbillingExtensions` | `EbillBatchQueryProvider`, `EbillingExtensions` | | [EBILL_BATCH_TYPE_CODE](#ebill_batch_type_code) | Oracle* | [unqualified]** | CR | Accessed by `EbillBatchQueryProvider`, `EbillingExtensions` | `EbillBatchQueryProvider`, `EbillingExtensions` | | [EBILL_CLEARINGHOUSE](#ebill_clearinghouse) | Oracle* | [unqualified]** | R | Accessed by `EbillClearinghouseQueryProvider`, `EbillingQueryProvider` | `EbillClearinghouseQueryProvider`, `EbillingQueryProvider` | | [EBILL_DOCUMENT](#ebill_document) | Oracle* | [unqualified]** | R | Accessed by `EbillDocumentQueryProvider` | `EbillDocumentQueryProvider` | | [EBILL_DOCUMENT_OVERRIDE](#ebill_document_override) | Oracle* | [unqualified]** | R | Accessed by `EbillDocumentQueryProvider` | `EbillDocumentQueryProvider` | | [EBILL_DOCUMENT_TYPE_CODE](#ebill_document_type_code) | Oracle* | [unqualified]** | R | Accessed by `EbillDocumentQueryProvider`, `EbillingExtensions` | `EbillDocumentQueryProvider`, `EbillingExtensions` | | [EBILL_EOB](#ebill_eob) | Oracle* | [unqualified]** | R | Accessed by `EbillEobQueryProvider` | `EbillEobQueryProvider` | | [EBILL_ERROR_CONDITION](#ebill_error_condition) | Oracle* | [unqualified]** | R | Accessed by `EbillQueryProvider` | `EbillQueryProvider` | | [EBILL_HEALTH_INFORMATION](#ebill_health_information) | Oracle* | [unqualified]** | R | Accessed by `EbillHealthInformationQueryProvider` | `EbillHealthInformationQueryProvider` | | [EBILL_HEALTH_INFO_TYPE_CODE](#ebill_health_info_type_code) | Oracle* | [unqualified]** | R | Accessed by `EbillHealthInformationQueryProvider` | `EbillHealthInformationQueryProvider` | | [EBILL_INVOICE](#ebill_invoice) | Oracle* | [unqualified]** | R | Accessed by `EbillInvoiceQueryProvider` | `EbillInvoiceQueryProvider` | | [EBILL_INVOICE_BILL](#ebill_invoice_bill) | Oracle* | [unqualified]** | R | Accessed by `EbillInvoiceQueryProvider` | `EbillInvoiceQueryProvider` | | [EBILL_INVOICE_ERROR](#ebill_invoice_error) | Oracle* | [unqualified]** | R | Accessed by `EbillInvoiceQueryProvider` | `EbillInvoiceQueryProvider` | | [EBILL_PATIENT](#ebill_patient) | Oracle* | [unqualified]** | R | Accessed by `EbillPatientQueryProvider`, `EbillQueryProvider` | `EbillPatientQueryProvider`, `EbillQueryProvider` | | [EBILL_PROVIDER](#ebill_provider) | Oracle* | [unqualified]** | R | Accessed by `EbillPatientQueryProvider`, `EbillProviderQueryProvider`, `EbillQueryProvider` | `EbillPatientQueryProvider`, `EbillProviderQueryProvider`, `EbillQueryProvider` | | [EBILL_RESPONSE_SET](#ebill_response_set) | Oracle* | [unqualified]** | R | Accessed by `EbillQueryProvider` | `EbillQueryProvider` | | [EBILL_SERVICE](#ebill_service) | Oracle* | [unqualified]** | RU | Accessed by `EbillQueryProvider`, `EbillServiceQueryProvider` | `EbillQueryProvider`, `EbillServiceQueryProvider` | | [EBILL_SET_TYPE_CODE](#ebill_set_type_code) | Oracle* | [unqualified]** | CR | Accessed by `EbillQueryProvider`, `EbillingExtensions` | `EbillQueryProvider`, `EbillingExtensions` | | [EBILL_STATUS_CODE](#ebill_status_code) | Oracle* | [unqualified]** | CR | Accessed by `EbillQueryProvider`, `EbillingExtensions` | `EbillQueryProvider`, `EbillingExtensions` | | [EDI_BILL](#edi_bill) | Oracle* | [unqualified]** | R | Accessed by `EdiQueryProvider` | `EdiQueryProvider` | | [EDI_BILL_REPORT](#edi_bill_report) | Oracle* | [unqualified]** | R | Accessed by `EdiQueryProvider` | `EdiQueryProvider` | | [EDI_PLACE_OF_SERVICE_CODE](#edi_place_of_service_code) | Oracle* | [unqualified]** | R | Accessed by `EbillQueryProvider` | `EbillQueryProvider` | | [ENDORSE_CODE](#endorse_code) | Oracle* | [unqualified]** | R | Accessed by `PolicyOutputDocumentExtensions` | `PolicyOutputDocumentExtensions` | | [ERROR_ENVIRONMENT](#error_environment) | Oracle* | [unqualified]** | R | Accessed by `OnlineSupportExtensions` | `OnlineSupportExtensions` | | [ERROR_GROUP_CODE](#error_group_code) | Oracle* | [unqualified]** | R | Accessed by `OnlineSupportExtensions` | `OnlineSupportExtensions` | | [ERROR_GROUP_ENVIRONMENT](#error_group_environment) | Oracle* | [unqualified]** | C | Accessed by `OnlineSupportExtensions` | `OnlineSupportExtensions` | | [IMAGE_AFFILIATION](#image_affiliation) | Oracle* | Unknown** | R | Accessed by `ImageQueryProvider` | `ImageQueryProvider` | | [IMGSYS](#imgsys) | Oracle* | Unknown** | R | Accessed by `ImageQueryProvider` | `ImageQueryProvider` | | [IcdVersionCode](#icdversioncode) | Unknown** | Unknown** | R | Accessed by `BillQueryProvider` | `BillQueryProvider` | | [LEGAL_BILL](#legal_bill) | Oracle* | [unqualified]** | R | Accessed by `LegalQueryProvider` | `LegalQueryProvider` | | [LEGAL_CASE](#legal_case) | Oracle* | [unqualified]** | R | Accessed by `ImageQueryProvider`, `LegalQueryProvider` | `ImageQueryProvider`, `LegalQueryProvider` | | [LEGAL_PERSON](#legal_person) | Oracle* | [unqualified]** | R | Accessed by `LegalQueryProvider` | `LegalQueryProvider` | | [LEGAL_PERSON_ADDRESS](#legal_person_address) | Oracle* | [unqualified]** | R | Accessed by `LegalQueryProvider` | `LegalQueryProvider` | | [LOCATION](#location) | Oracle* | [unqualified]** | R | Accessed by `LocationQueryProvider` | `LocationQueryProvider` | | [LOCATION_VERIFICATION_REQUEST](#location_verification_request) | Oracle* | [unqualified]** | R | Accessed by `AddressVerificationQueryProvider` | `AddressVerificationQueryProvider` | | [LPT_CLAIM_CROSS_REFERENCE](#lpt_claim_cross_reference) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider` | `ClaimQueryProvider` | | [MARKET_TYPE_CODE](#market_type_code) | Oracle* | [unqualified]** | R | Accessed by `PolicyExtensions` | `PolicyExtensions` | | [MCO_PROVIDER](#mco_provider) | Oracle* | [unqualified]** | R | Accessed by `ProviderQueryProvider` | `ProviderQueryProvider` | | [MEDICARE_BENEFICIARY_QUERY](#medicare_beneficiary_query) | Oracle* | [unqualified]** | R | Accessed by `MedicareQueryProvider` | `MedicareQueryProvider` | | [MEDICARE_BENEFICIARY_QUERY_BAT](#medicare_beneficiary_query_bat) | Oracle* | [unqualified]** | R | Accessed by `MedicareQueryProvider` | `MedicareQueryProvider` | | [MEDICARE_QUERY_HISTORY](#medicare_query_history) | Oracle* | [unqualified]** | R | Accessed by `MedicareQueryProvider` | `MedicareQueryProvider` | | [NON_EMPR_ACCT](#non_empr_acct) | Oracle* | [unqualified]** | R | Accessed by `PolicyQueryProvider` | `PolicyQueryProvider` | | [OFFICE_CODE](#office_code) | Oracle* | [unqualified]** | CR | Accessed by `LocationQueryProvider`, `PolicyExtensions` | `LocationQueryProvider`, `PolicyExtensions` | | [OTHER_FIRM](#other_firm) | Oracle* | [unqualified]** | R | Accessed by `LegalQueryProvider` | `LegalQueryProvider` | | [PAYMENT_TRANSACTION_STAT](#payment_transaction_stat) | Oracle* | [unqualified]** | R | Accessed by `PaymentsQueryProvider` | `PaymentsQueryProvider` | | [PAYMENT_TRANSACTION_TYPE_CODE](#payment_transaction_type_code) | Oracle* | [unqualified]** | R | Accessed by `PaymentsQueryProvider` | `PaymentsQueryProvider` | | [POLICY](#policy) | Oracle* | [unqualified]** | CRU | Accessed by `OutputDocumentQueryProvider`, `PolicyQueryProvider`, `ClaimBuilder`, `PolicyExtensions`, `PolicyOutputDocumentExtensions` | `OutputDocumentQueryProvider`, `PolicyQueryProvider`, `ClaimBuilder`, `PolicyExtensions`, `PolicyOutputDocumentExtensions` | | [POLICY_PERIOD_GROUP_ASSOC](#policy_period_group_assoc) | Oracle* | [unqualified]** | R | Accessed by `PolicyQueryProvider` | `PolicyQueryProvider` | | [POLICY_PERIOD_PAYROLL_AUDIT](#policy_period_payroll_audit) | Oracle* | [unqualified]** | R | Accessed by `PolicyQueryProvider` | `PolicyQueryProvider` | | [POLICY_RELATIONSHIP_CODE](#policy_relationship_code) | Oracle* | [unqualified]** | R | Accessed by `PolicyExtensions` | `PolicyExtensions` | | [POLICY_TEAM_FUNCTION](#policy_team_function) | Oracle* | [unqualified]** | CR | Accessed by `PolicyExtensions`, `PolicyQueryProvider` | `PolicyExtensions`, `PolicyQueryProvider` | | [PROVIDER](#provider) | Oracle* | [unqualified]** | R | Accessed by `ProviderQueryProvider` | `ProviderQueryProvider` | | [PROVIDER_ADDRESS](#provider_address) | Oracle* | [unqualified]** | R | Accessed by `ProviderQueryProvider` | `ProviderQueryProvider` | | [PROVIDER_IDENTITY](#provider_identity) | Oracle* | [unqualified]** | R | Accessed by `ProviderQueryProvider` | `ProviderQueryProvider` | | [PROVIDER_LOCATION](#provider_location) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider`, `ProviderQueryProvider` | `ClaimQueryProvider`, `ProviderQueryProvider` | | [PROVIDER_RELATIONSHIP](#provider_relationship) | Oracle* | [unqualified]** | R | Accessed by `ProviderQueryProvider` | `ProviderQueryProvider` | | [PROVIDER_TAX_ID](#provider_tax_id) | Oracle* | [unqualified]** | R | Accessed by `ProviderQueryProvider` | `ProviderQueryProvider` | | [RTW_CASE](#rtw_case) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider` | `ClaimQueryProvider` | | [SUBPOENA](#subpoena) | Oracle* | [unqualified]** | R | Accessed by `LegalQueryProvider` | `LegalQueryProvider` | | [TASK](#task) | Oracle* | [unqualified]** | R | Accessed by `TaskQueryProvider` | `TaskQueryProvider` | | [TASK_ACTION_CODE](#task_action_code) | Oracle* | [unqualified]** | R | Accessed by `TaskExtensions`, `TaskQueryProvider` | `TaskExtensions`, `TaskQueryProvider` | | [TASK_CATEGORY_CODE](#task_category_code) | Oracle* | [unqualified]** | CR | Accessed by `TaskExtensions`, `TaskQueryProvider` | `TaskExtensions`, `TaskQueryProvider` | | [TASK_PRIORITY_CODE](#task_priority_code) | Oracle* | [unqualified]** | R | Accessed by `TaskExtensions`, `TaskQueryProvider` | `TaskExtensions`, `TaskQueryProvider` | | [TASK_SOURCE_CODE](#task_source_code) | Oracle* | [unqualified]** | R | Accessed by `TaskExtensions`, `TaskQueryProvider` | `TaskExtensions`, `TaskQueryProvider` | | [THRDPARTY_CASE](#thrdparty_case) | Oracle* | [unqualified]** | R | Accessed by `ClaimQueryProvider` | `ClaimQueryProvider` | | [VERIFIED_ADDRESS](#verified_address) | Oracle* | [unqualified]** | R | Accessed by `AddressVerificationQueryProvider` | `AddressVerificationQueryProvider` | | [WCIS_Employee](#wcis_employee) | Oracle* | Unknown** | R | Accessed by `EmployeeQueryProvider` | `EmployeeQueryProvider` | | [batch_process_log](#batch_process_log) | Oracle* | [unqualified]** | CR | Accessed by `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | | [cl_pref_contact_method_code](#cl_pref_contact_method_code) | Oracle* | [unqualified]** | R | Accessed by `WorkerQueryProvider` | `WorkerQueryProvider` | | [claim_status_code](#claim_status_code) | Oracle* | [unqualified]** | R | Accessed by `ClaimBuilder`, `ClaimCodeTableBuilder`, `ClaimQueryProvider` | `ClaimBuilder`, `ClaimCodeTableBuilder`, `ClaimQueryProvider` | | [document_status_code](#document_status_code) | Oracle* | [unqualified]** | R | Accessed by `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | | [image](#image) | Oracle* | Unknown** | R | Accessed by `ImageQueryProvider` | `ImageQueryProvider` | | [image_category_code](#image_category_code) | Oracle* | [unqualified]** | CR | Accessed by `PolicyOutputDocumentExtensions` | `PolicyOutputDocumentExtensions` | | [image_document_type_code](#image_document_type_code) | Oracle* | [unqualified]** | CR | Accessed by `ImageQueryProvider`, `PolicyOutputDocumentExtensions` | `ImageQueryProvider`, `PolicyOutputDocumentExtensions` | | [output_doc_notify_text_code](#output_doc_notify_text_code) | Oracle* | [unqualified]** | CR | Accessed by `PolicyOutputDocumentExtensions` | `PolicyOutputDocumentExtensions` | | [output_document](#output_document) | Oracle* | [unqualified]** | C | Accessed by `PolicyOutputDocumentExtensions` | `PolicyOutputDocumentExtensions` | | [output_document_category_code](#output_document_category_code) | Oracle* | [unqualified]** | CR | Accessed by `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | | [output_document_type_code](#output_document_type_code) | Oracle* | [unqualified]** | CR | Accessed by `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | | [policy_output_document](#policy_output_document) | Oracle* | [unqualified]** | CR | Accessed by `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | ## ADDRESS_VERIFICATION_REQUEST | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AddressVerificationQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped ADDR_VERIFICATION_REQ_SEQ; no insert in this library) | | **Related tables** | LOCATION_VERIFICATION_REQUEST, VERIFIED_ADDRESS | | **Business objects** | `AddressVerificationQueryProvider` | ### Operations referencing ADDRESS_VERIFICATION_REQUEST - [Other query providers](operations/other-query-providers.md) ### SQL referencing ADDRESS_VERIFICATION_REQUEST - [SQL-001: `GetRepository().Query()`](sql/SQL-001-address-verification-query-provider-get-location-verification-requests.md) - [SQL-002: `GetRepository().Query()`](sql/SQL-002-address-verification-query-provider-get-address-verification-requests.md) --- ## ADP_EMPLOYEE | Field | Value | | --- | --- | | **Database** | Unknown** | | **Schema/Link** | Unknown** | | **Purpose** | Accessed by `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `LegalQueryProvider` | ### SQL referencing ADP_EMPLOYEE - [SQL-159: `GetRepository().Query()`](sql/SQL-159-legal-query-provider-get-adp-employee-name.md) --- ## APPEAL | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped APPEAL_SEQ; no insert in this library) | | **Related tables** | LEGAL_CASE | | **Business objects** | `LegalQueryProvider` | ### Operations referencing APPEAL - [Legal case queries](operations/legal-case-queries.md) ### Business rules referencing APPEAL - [SD-BR-060 Case-to-claim resolution precedence](business-rules.md#sd-br-060-case-to-claim-resolution-precedence) - [SD-BR-061 Preferred employee name takes precedence](business-rules.md#sd-br-061-preferred-employee-name-takes-precedence) ### SQL referencing APPEAL - [SQL-158: `GetRepository().Query()`](sql/SQL-158-legal-query-provider-get-appeal-assigned-attorney.md) --- ## ATTENDING_PHYSICIAN | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ReportQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped ATTENDING_PHYSICIAN_SEQ; no insert in this library) | | **Related tables** | CL_INJURY_CLAIM, PROVIDER_LOCATION | | **Business objects** | `ReportQueryProvider` | ### Operations referencing ATTENDING_PHYSICIAN - [Other query providers](operations/other-query-providers.md) ### Business rules referencing ATTENDING_PHYSICIAN - [SD-BR-093 Active report record has a null expiration date](business-rules.md#sd-br-093-active-report-record-has-a-null-expiration-date) ### SQL referencing ATTENDING_PHYSICIAN - [SQL-218: `GetRepository().Query()`](sql/SQL-218-report-query-provider-get-attending-claims-with-relationship.md) - [SQL-220: `GetRepository().Query()`](sql/SQL-220-report-query-provider-get-active-attending-physician-records-for-claim.md) --- ## ATTORNEY_PROFILE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `LegalQueryProvider` | ### Operations referencing ATTORNEY_PROFILE - [Legal case queries](operations/legal-case-queries.md) ### Business rules referencing ATTORNEY_PROFILE - [SD-BR-060 Case-to-claim resolution precedence](business-rules.md#sd-br-060-case-to-claim-resolution-precedence) - [SD-BR-061 Preferred employee name takes precedence](business-rules.md#sd-br-061-preferred-employee-name-takes-precedence) ### SQL referencing ATTORNEY_PROFILE - [SQL-161: `GetRepository().Query()`](sql/SQL-161-legal-query-provider-get-attorney-profile.md) --- ## Agency | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | agency_seq | | **Related tables** | Agent | | **Business objects** | `PolicyExtensions` | ### SQL referencing Agency - [SQL-246: `GetRepository().Add(entity)`](sql/SQL-246-policy-extensions-generate-agencies.md) - [SQL-280: `GetRepository().Query()`](sql/SQL-280-policy-extensions-generate-agencies.md) --- ## Agent | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyExtensions`, `PolicyOutputDocumentExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | Agency, POLICY | | **Business objects** | `PolicyExtensions`, `PolicyOutputDocumentExtensions` | ### SQL referencing Agent - [SQL-247: `GetRepository().Add(entity)`](sql/SQL-247-policy-extensions-generate-agencies.md) - [SQL-286: `GetRepository().Query()`](sql/SQL-286-policy-output-document-extensions-get-regional-policy-served-by-direct-writer.md) - [SQL-287: `GetRepository().Query()`](sql/SQL-287-policy-output-document-extensions-seed-with-documents-on-apolicy-served-by-an-external-agent.md) --- ## App_Error | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `OnlineSupportExtensions` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OnlineSupportExtensions` | ### SQL referencing App_Error - [SQL-276: `GetRepository().Query()`](sql/SQL-276-online-support-extensions-seed-for-online-support.md) --- ## BUSINESS | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PolicyQueryProvider` | ### Operations referencing BUSINESS - [Other query providers](operations/other-query-providers.md) ### SQL referencing BUSINESS - [SQL-197: `GetRepository().Query()`](sql/SQL-197-policy-query-provider-get-business.md) --- ## CASE_COST | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped CASE_COST_SEQ; no insert in this library) | | **Related tables** | LEGAL_CASE | | **Business objects** | `LegalQueryProvider` | ### Operations referencing CASE_COST - [Legal case queries](operations/legal-case-queries.md) ### Business rules referencing CASE_COST - [SD-BR-060 Case-to-claim resolution precedence](business-rules.md#sd-br-060-case-to-claim-resolution-precedence) - [SD-BR-061 Preferred employee name takes precedence](business-rules.md#sd-br-061-preferred-employee-name-takes-precedence) ### SQL referencing CASE_COST - [SQL-155: `GetRepository().Query()`](sql/SQL-155-legal-query-provider-get-case-cost.md) --- ## CASE_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | LEGAL_CASE | | **Business objects** | `LegalQueryProvider` | ### Operations referencing CASE_STATUS_CODE - [Legal case queries](operations/legal-case-queries.md) ### Business rules referencing CASE_STATUS_CODE - [SD-BR-060 Case-to-claim resolution precedence](business-rules.md#sd-br-060-case-to-claim-resolution-precedence) - [SD-BR-061 Preferred employee name takes precedence](business-rules.md#sd-br-061-preferred-employee-name-takes-precedence) ### SQL referencing CASE_STATUS_CODE - [SQL-160: `GetRepository().Query()`](sql/SQL-160-legal-query-provider-get-active-legal-cases.md) --- ## CBP_AUDIT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AuditQueryProvider`, `BillQueryProvider`, `EbillEobQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CBP_AUDITED_SERVICE, CBP_BILL | | **Business objects** | `AuditQueryProvider`, `BillQueryProvider`, `EbillEobQueryProvider` | ### Operations referencing CBP_AUDIT - [Bill audit evaluation](operations/bill-audit-evaluation.md) - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing CBP_AUDIT - [SD-BR-030 Nurse review required if any audited service code flags it](business-rules.md#sd-br-030-nurse-review-required-if-any-audited-service-code-flags-it) - [SD-BR-031 Duplicate services excluded from count](business-rules.md#sd-br-031-duplicate-services-excluded-from-count) - [SD-BR-032 Unset thru-date treated as open-ended](business-rules.md#sd-br-032-unset-thru-date-treated-as-open-ended) - [SD-BR-054 Zero-pay EOB candidate criteria](business-rules.md#sd-br-054-zero-pay-eob-candidate-criteria) ### SQL referencing CBP_AUDIT - [SQL-013: `GetRepository().Query()`](sql/SQL-013-audit-query-provider-get-audit.md) - [SQL-014: `GetRepository().Query()`](sql/SQL-014-audit-query-provider-get-audit-for-bill.md) - [SQL-017: `GetRepository().Query()`](sql/SQL-017-audit-query-provider-is-nurse-review-required.md) - [SQL-018: `GetRepository().Query()`](sql/SQL-018-audit-query-provider-get-non-duplicate-service-count.md) - [SQL-019: `GetRepository().Query()`](sql/SQL-019-audit-query-provider-get-services.md) - [SQL-020: `GetRepository().Query()`](sql/SQL-020-audit-query-provider-get-original-bills.md) - [SQL-032: `GetRepository().Query()`](sql/SQL-032-bill-query-provider-get-bill-amounts.md) - [SQL-033: `GetRepository().Query()`](sql/SQL-033-bill-query-provider-get-bill-amounts.md) - [SQL-100: `GetRepository().Query()`](sql/SQL-100-ebill-eob-query-provider-get-completed-zero-payment-bills-for-eob.md) - [SQL-101: `GetRepository().Query()`](sql/SQL-101-ebill-eob-query-provider-get-completed-zero-payment-bills-for-eob.md) --- ## CBP_AUDITED_SERVICE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AuditQueryProvider`, `BillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CBP_AUDIT, CBP_BILL | | **Business objects** | `AuditQueryProvider`, `BillQueryProvider` | ### Operations referencing CBP_AUDITED_SERVICE - [Bill audit evaluation](operations/bill-audit-evaluation.md) - [Bill queries](operations/bill-queries.md) ### Business rules referencing CBP_AUDITED_SERVICE - [SD-BR-030 Nurse review required if any audited service code flags it](business-rules.md#sd-br-030-nurse-review-required-if-any-audited-service-code-flags-it) - [SD-BR-031 Duplicate services excluded from count](business-rules.md#sd-br-031-duplicate-services-excluded-from-count) - [SD-BR-032 Unset thru-date treated as open-ended](business-rules.md#sd-br-032-unset-thru-date-treated-as-open-ended) - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CBP_AUDITED_SERVICE - [SQL-017: `GetRepository().Query()`](sql/SQL-017-audit-query-provider-is-nurse-review-required.md) - [SQL-018: `GetRepository().Query()`](sql/SQL-018-audit-query-provider-get-non-duplicate-service-count.md) - [SQL-019: `GetRepository().Query()`](sql/SQL-019-audit-query-provider-get-services.md) - [SQL-020: `GetRepository().Query()`](sql/SQL-020-audit-query-provider-get-original-bills.md) - [SQL-021: `GetRepository().Query()`](sql/SQL-021-audit-query-provider-get-physical-medicine-count.md) - [SQL-022: `GetRepository().Query()`](sql/SQL-022-audit-query-provider-get-physical-medicine-count.md) - [SQL-032: `GetRepository().Query()`](sql/SQL-032-bill-query-provider-get-bill-amounts.md) - [SQL-033: `GetRepository().Query()`](sql/SQL-033-bill-query-provider-get-bill-amounts.md) --- ## CBP_AUDIT_ADJUSTMENT_TYPE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AuditQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `AuditQueryProvider` | ### Operations referencing CBP_AUDIT_ADJUSTMENT_TYPE - [Bill audit evaluation](operations/bill-audit-evaluation.md) ### Business rules referencing CBP_AUDIT_ADJUSTMENT_TYPE - [SD-BR-030 Nurse review required if any audited service code flags it](business-rules.md#sd-br-030-nurse-review-required-if-any-audited-service-code-flags-it) - [SD-BR-031 Duplicate services excluded from count](business-rules.md#sd-br-031-duplicate-services-excluded-from-count) - [SD-BR-032 Unset thru-date treated as open-ended](business-rules.md#sd-br-032-unset-thru-date-treated-as-open-ended) ### SQL referencing CBP_AUDIT_ADJUSTMENT_TYPE - [SQL-023: `GetRepository().Query()`](sql/SQL-023-audit-query-provider-get-adjustment-type.md) --- ## CBP_BILL | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AuditQueryProvider`, `BillQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider`, `ProviderQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped CBP_BILL_SEQ; no insert in this library) | | **Related tables** | CBP_AUDIT, CBP_AUDITED_SERVICE, CBP_BILL_STATUS, CBP_NOTE, EBILL, CBP_BILL_STATUS_CODE, PROVIDER_LOCATION | | **Business objects** | `AuditQueryProvider`, `BillQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider`, `ProviderQueryProvider` | ### Operations referencing CBP_BILL - [Bill audit evaluation](operations/bill-audit-evaluation.md) - [Audit note concurrency check](operations/audit-note-concurrency-check.md) - [Bill queries](operations/bill-queries.md) - [E-bill processing queries](operations/e-bill-processing-queries.md) - [Provider queries](operations/provider-queries.md) ### Business rules referencing CBP_BILL - [SD-BR-030 Nurse review required if any audited service code flags it](business-rules.md#sd-br-030-nurse-review-required-if-any-audited-service-code-flags-it) - [SD-BR-031 Duplicate services excluded from count](business-rules.md#sd-br-031-duplicate-services-excluded-from-count) - [SD-BR-032 Unset thru-date treated as open-ended](business-rules.md#sd-br-032-unset-thru-date-treated-as-open-ended) - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) - [SD-BR-054 Zero-pay EOB candidate criteria](business-rules.md#sd-br-054-zero-pay-eob-candidate-criteria) - [SD-BR-080 Provider identity relationship and address code sets](business-rules.md#sd-br-080-provider-identity-relationship-and-address-code-sets) - [SD-BR-082 Dismissed bills excluded from provider location ids](business-rules.md#sd-br-082-dismissed-bills-excluded-from-provider-location-ids) - [SD-BR-083 Provider in MCO only within date window](business-rules.md#sd-br-083-provider-in-mco-only-within-date-window) ### SQL referencing CBP_BILL - [SQL-019: `GetRepository().Query()`](sql/SQL-019-audit-query-provider-get-services.md) - [SQL-021: `GetRepository().Query()`](sql/SQL-021-audit-query-provider-get-physical-medicine-count.md) - [SQL-022: `GetRepository().Query()`](sql/SQL-022-audit-query-provider-get-physical-medicine-count.md) - [SQL-024: `GetRepository().Query()`](sql/SQL-024-bill-query-provider-bill-exists.md) - [SQL-025: `GetRepository().Query()`](sql/SQL-025-bill-query-provider-get-bill.md) - [SQL-026: `GetRepository().Query()`](sql/SQL-026-bill-query-provider-get-bills-for-claim.md) - [SQL-027: `GetRepository().Query()`](sql/SQL-027-bill-query-provider-get-bill-ids-for-claim.md) - [SQL-032: `GetRepository().Query()`](sql/SQL-032-bill-query-provider-get-bill-amounts.md) - [SQL-033: `GetRepository().Query()`](sql/SQL-033-bill-query-provider-get-bill-amounts.md) - [SQL-100: `GetRepository().Query()`](sql/SQL-100-ebill-eob-query-provider-get-completed-zero-payment-bills-for-eob.md) - [SQL-101: `GetRepository().Query()`](sql/SQL-101-ebill-eob-query-provider-get-completed-zero-payment-bills-for-eob.md) - [SQL-117: `GetRepository().Query()`](sql/SQL-117-ebill-query-provider-get-bills-for-response-file-for-clearinghouse.md) - [SQL-210: `GetRepository().Query()`](sql/SQL-210-provider-query-provider-get-bill-provider-location-ids.md) --- ## CBP_BILL_ENTRY_SOURCE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `BillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `BillQueryProvider` | ### Operations referencing CBP_BILL_ENTRY_SOURCE_CODE - [Bill queries](operations/bill-queries.md) ### Business rules referencing CBP_BILL_ENTRY_SOURCE_CODE - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CBP_BILL_ENTRY_SOURCE_CODE - [SQL-031: `GetRepository().Query()`](sql/SQL-031-bill-query-provider-get-regenerated-bill-entry-source-code.md) - [SQL-037: `GetRepository().Query()`](sql/SQL-037-bill-query-provider-get-ebill-entry-source-code.md) --- ## CBP_BILL_STATUS | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `BillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped BILL_STATUS_SEQ; no insert in this library) | | **Related tables** | CBP_BILL | | **Business objects** | `BillQueryProvider` | ### Operations referencing CBP_BILL_STATUS - [Bill queries](operations/bill-queries.md) ### Business rules referencing CBP_BILL_STATUS - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CBP_BILL_STATUS - [SQL-030: `GetRepository().Query()`](sql/SQL-030-bill-query-provider-get-bill-status-history.md) --- ## CBP_BILL_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `BillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CBP_BILL | | **Business objects** | `BillQueryProvider` | ### Operations referencing CBP_BILL_STATUS_CODE - [Bill queries](operations/bill-queries.md) - [E-bill processing queries](operations/e-bill-processing-queries.md) - [Provider queries](operations/provider-queries.md) ### Business rules referencing CBP_BILL_STATUS_CODE - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) - [SD-BR-054 Zero-pay EOB candidate criteria](business-rules.md#sd-br-054-zero-pay-eob-candidate-criteria) - [SD-BR-080 Provider identity relationship and address code sets](business-rules.md#sd-br-080-provider-identity-relationship-and-address-code-sets) - [SD-BR-082 Dismissed bills excluded from provider location ids](business-rules.md#sd-br-082-dismissed-bills-excluded-from-provider-location-ids) - [SD-BR-083 Provider in MCO only within date window](business-rules.md#sd-br-083-provider-in-mco-only-within-date-window) ### SQL referencing CBP_BILL_STATUS_CODE - [SQL-029: `GetRepository().Query()`](sql/SQL-029-bill-query-provider-get-bill-status-code.md) --- ## CBP_BILL_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `BillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `BillQueryProvider` | ### Operations referencing CBP_BILL_TYPE_CODE - [Bill queries](operations/bill-queries.md) ### Business rules referencing CBP_BILL_TYPE_CODE - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CBP_BILL_TYPE_CODE - [SQL-028: `GetRepository().Query()`](sql/SQL-028-bill-query-provider-get-bill-types.md) - [SQL-038: `GetRepository().Query()`](sql/SQL-038-bill-query-provider-get-cbp-bill-type-code.md) --- ## CBP_CPT_SERVICE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ServiceCodeMaintenanceQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CBP_SERVICE_CODE | | **Business objects** | `ServiceCodeMaintenanceQueryProvider` | ### Operations referencing CBP_CPT_SERVICE - [Other query providers](operations/other-query-providers.md) ### SQL referencing CBP_CPT_SERVICE - [SQL-225: `GetRepository().Query()`](sql/SQL-225-service-code-maintenance-query-provider-get-cpt-services.md) --- ## CBP_DIAGNOSIS | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `BillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `BillQueryProvider` | ### Operations referencing CBP_DIAGNOSIS - [Bill queries](operations/bill-queries.md) ### Business rules referencing CBP_DIAGNOSIS - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CBP_DIAGNOSIS - [SQL-034: `GetRepository().Query()`](sql/SQL-034-bill-query-provider-get-stripped-cbp-diagnosis.md) - [SQL-035: `GetRepository().Query()`](sql/SQL-035-bill-query-provider-get-cbp-diagnosis.md) --- ## CBP_DIAGNOSIS_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `BillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `BillQueryProvider` | ### Operations referencing CBP_DIAGNOSIS_TYPE_CODE - [Bill queries](operations/bill-queries.md) ### Business rules referencing CBP_DIAGNOSIS_TYPE_CODE - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CBP_DIAGNOSIS_TYPE_CODE - [SQL-036: `GetRepository().Query()`](sql/SQL-036-bill-query-provider-get-cbp-diagnosis-type-code.md) --- ## CBP_NATIONAL_DRUG | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AuditQueryProvider`, `BillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `AuditQueryProvider`, `BillQueryProvider` | ### Operations referencing CBP_NATIONAL_DRUG - [Bill audit evaluation](operations/bill-audit-evaluation.md) - [Bill queries](operations/bill-queries.md) ### Business rules referencing CBP_NATIONAL_DRUG - [SD-BR-030 Nurse review required if any audited service code flags it](business-rules.md#sd-br-030-nurse-review-required-if-any-audited-service-code-flags-it) - [SD-BR-031 Duplicate services excluded from count](business-rules.md#sd-br-031-duplicate-services-excluded-from-count) - [SD-BR-032 Unset thru-date treated as open-ended](business-rules.md#sd-br-032-unset-thru-date-treated-as-open-ended) - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CBP_NATIONAL_DRUG - [SQL-015: `GetRepository().Query()`](sql/SQL-015-audit-query-provider-get-national-drug-code.md) - [SQL-047: `GetRepository().Query()`](sql/SQL-047-bill-query-provider-get-national-drug.md) --- ## CBP_NOTE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AuditNoteQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped CBP_NOTE_SEQ; no insert in this library) | | **Related tables** | CBP_BILL | | **Business objects** | `AuditNoteQueryProvider` | ### Operations referencing CBP_NOTE - [Audit note concurrency check](operations/audit-note-concurrency-check.md) ### Business rules referencing CBP_NOTE - [SD-BR-033 Audit note save allowed only under optimistic concurrency match](business-rules.md#sd-br-033-audit-note-save-allowed-only-under-optimistic-concurrency-match) ### SQL referencing CBP_NOTE - [SQL-004: `GetRepository().Query()`](sql/SQL-004-audit-note-query-provider-get-audit-note.md) - [SQL-005: `GetRepository().Query()`](sql/SQL-005-audit-note-query-provider-get-audit-notes-for-claim.md) - [SQL-006: `GetRepository().Query()`](sql/SQL-006-audit-note-query-provider-get-audit-notes-for-bill.md) - [SQL-007: `GetRepository().Query()`](sql/SQL-007-audit-note-query-provider-get-all-audit-notes.md) - [SQL-012: `GetRepository().Query()`](sql/SQL-012-audit-note-query-provider-is-audit-note-no-contention.md) --- ## CBP_NOTE_CATEGORY_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AuditNoteQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CBP_NOTE_TYPE_CODE | | **Business objects** | `AuditNoteQueryProvider` | ### Operations referencing CBP_NOTE_CATEGORY_CODE - [Audit note concurrency check](operations/audit-note-concurrency-check.md) ### SQL referencing CBP_NOTE_CATEGORY_CODE - [SQL-009: `GetRepository().Query()`](sql/SQL-009-audit-note-query-provider-get-note-categories.md) --- ## CBP_NOTE_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AuditNoteQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CBP_NOTE_CATEGORY_CODE | | **Business objects** | `AuditNoteQueryProvider` | ### Operations referencing CBP_NOTE_TYPE_CODE - [Audit note concurrency check](operations/audit-note-concurrency-check.md) ### SQL referencing CBP_NOTE_TYPE_CODE - [SQL-008: `GetRepository().Query()`](sql/SQL-008-audit-note-query-provider-get-note-type-code.md) - [SQL-010: `GetRepository().Query()`](sql/SQL-010-audit-note-query-provider-get-note-types.md) - [SQL-011: `GetRepository().Query()`](sql/SQL-011-audit-note-query-provider-get-note-types-for-category.md) --- ## CBP_PROCEDURE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `BillQueryProvider`, `ServiceCodeQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `BillQueryProvider`, `ServiceCodeQueryProvider` | ### Operations referencing CBP_PROCEDURE_CODE - [Bill queries](operations/bill-queries.md) - [Other query providers](operations/other-query-providers.md) ### Business rules referencing CBP_PROCEDURE_CODE - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CBP_PROCEDURE_CODE - [SQL-049: `GetRepository().Query()`](sql/SQL-049-bill-query-provider-get-cbp-procedure-code.md) - [SQL-230: `GetRepository().Query()`](sql/SQL-230-service-code-query-provider-get-procedure-code.md) --- ## CBP_SERVICE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AuditQueryProvider`, `BillQueryProvider`, `ServiceCodeMaintenanceQueryProvider`, `ServiceCodeQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CBP_CPT_SERVICE, CBP_SERVICE_DESCRIPTION, CBP_SERVICE_TYPE_CODE | | **Business objects** | `AuditQueryProvider`, `BillQueryProvider`, `ServiceCodeMaintenanceQueryProvider`, `ServiceCodeQueryProvider` | ### Operations referencing CBP_SERVICE_CODE - [Bill audit evaluation](operations/bill-audit-evaluation.md) - [Bill queries](operations/bill-queries.md) - [Other query providers](operations/other-query-providers.md) ### Business rules referencing CBP_SERVICE_CODE - [SD-BR-030 Nurse review required if any audited service code flags it](business-rules.md#sd-br-030-nurse-review-required-if-any-audited-service-code-flags-it) - [SD-BR-031 Duplicate services excluded from count](business-rules.md#sd-br-031-duplicate-services-excluded-from-count) - [SD-BR-032 Unset thru-date treated as open-ended](business-rules.md#sd-br-032-unset-thru-date-treated-as-open-ended) - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CBP_SERVICE_CODE - [SQL-016: `GetRepository().Query()`](sql/SQL-016-audit-query-provider-is-nurse-review-required.md) - [SQL-039: `GetRepository().Query()`](sql/SQL-039-bill-query-provider-get-cbp-service-code-not-expired.md) - [SQL-040: `GetRepository().Query()`](sql/SQL-040-bill-query-provider-get-cbp-service-code-expired.md) - [SQL-041: `GetRepository().Query()`](sql/SQL-041-bill-query-provider-get-cbp-service-zcode.md) - [SQL-045: `GetRepository().Query()`](sql/SQL-045-bill-query-provider-get-bill-service-code.md) - [SQL-046: `GetRepository().Query()`](sql/SQL-046-bill-query-provider-get-bill-service-code-stateless.md) - [SQL-228: `GetRepository().Query()`](sql/SQL-228-service-code-maintenance-query-provider-get-service-code.md) - [SQL-229: `GetRepository().Query()`](sql/SQL-229-service-code-query-provider-get-service-code.md) --- ## CBP_SERVICE_DESCRIPTION | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `BillQueryProvider`, `ServiceCodeMaintenanceQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CBP_SERVICE_CODE | | **Business objects** | `BillQueryProvider`, `ServiceCodeMaintenanceQueryProvider` | ### Operations referencing CBP_SERVICE_DESCRIPTION - [Bill queries](operations/bill-queries.md) - [Other query providers](operations/other-query-providers.md) ### Business rules referencing CBP_SERVICE_DESCRIPTION - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CBP_SERVICE_DESCRIPTION - [SQL-042: `GetRepository().Query()`](sql/SQL-042-bill-query-provider-get-cbp-service-zdec-description.md) - [SQL-043: `GetRepository().Query()`](sql/SQL-043-bill-query-provider-get-cbp-service-zdec-description-stateless.md) - [SQL-226: `GetRepository().Query()`](sql/SQL-226-service-code-maintenance-query-provider-get-descriptions.md) --- ## CBP_SERVICE_FEE | Field | Value | | --- | --- | | **Database** | Unknown** | | **Schema/Link** | Unknown** | | **Purpose** | Accessed by `ServiceCodeMaintenanceQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ServiceCodeMaintenanceQueryProvider` | ### SQL referencing CBP_SERVICE_FEE - [SQL-227: `GetRepository().Query()`](sql/SQL-227-service-code-maintenance-query-provider-get-fee-schedules.md) --- ## CBP_SERVICE_PHYSICAL_MEDICINE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AuditQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `AuditQueryProvider` | ### Operations referencing CBP_SERVICE_PHYSICAL_MEDICINE - [Bill audit evaluation](operations/bill-audit-evaluation.md) ### Business rules referencing CBP_SERVICE_PHYSICAL_MEDICINE - [SD-BR-030 Nurse review required if any audited service code flags it](business-rules.md#sd-br-030-nurse-review-required-if-any-audited-service-code-flags-it) - [SD-BR-031 Duplicate services excluded from count](business-rules.md#sd-br-031-duplicate-services-excluded-from-count) - [SD-BR-032 Unset thru-date treated as open-ended](business-rules.md#sd-br-032-unset-thru-date-treated-as-open-ended) ### SQL referencing CBP_SERVICE_PHYSICAL_MEDICINE - [SQL-021: `GetRepository().Query()`](sql/SQL-021-audit-query-provider-get-physical-medicine-count.md) - [SQL-022: `GetRepository().Query()`](sql/SQL-022-audit-query-provider-get-physical-medicine-count.md) --- ## CBP_SERVICE_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `BillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CBP_SERVICE_CODE | | **Business objects** | `BillQueryProvider` | ### Operations referencing CBP_SERVICE_TYPE_CODE - [Bill queries](operations/bill-queries.md) - [Other query providers](operations/other-query-providers.md) ### Business rules referencing CBP_SERVICE_TYPE_CODE - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CBP_SERVICE_TYPE_CODE - [SQL-044: `GetRepository().Query()`](sql/SQL-044-bill-query-provider-get-bill-service-type-code.md) --- ## CERTIFICATE_HOLDER | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `CertificateHolderQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped CERT_HOLD_SEQUENCE; no insert in this library) | | **Related tables** | None identified | | **Business objects** | `CertificateHolderQueryProvider` | ### Operations referencing CERTIFICATE_HOLDER - [Other query providers](operations/other-query-providers.md) ### Business rules referencing CERTIFICATE_HOLDER - [SD-BR-090 Superseded certificate holders excluded from search](business-rules.md#sd-br-090-superseded-certificate-holders-excluded-from-search) ### SQL referencing CERTIFICATE_HOLDER - [SQL-051: `GetRepository().Query()`](sql/SQL-051-certificate-holder-query-provider-get-certificate-holder.md) - [SQL-052: `GetRepository().Query()`](sql/SQL-052-certificate-holder-query-provider-get-certificate-holders.md) - [SQL-053: `GetRepository().Query()`](sql/SQL-053-certificate-holder-query-provider-get-certificate-holders.md) --- ## CLAIM_ADDRESS_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AddressBuilder`, `ClaimCodeTableBuilder` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `AddressBuilder`, `ClaimCodeTableBuilder` | ### SQL referencing CLAIM_ADDRESS_TYPE_CODE - [SQL-255: `GetRepository().Query()`](sql/SQL-255-address-builder-type.md) - [SQL-264: `GetRepository().Query()`](sql/SQL-264-claim-code-table-builder-address-type.md) --- ## CL_CLAIM_LEGAL_REPRESENTATIVE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider`, `ReportQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | PROVIDER_LOCATION | | **Business objects** | `ClaimQueryProvider`, `ReportQueryProvider` | ### Operations referencing CL_CLAIM_LEGAL_REPRESENTATIVE - [Claim status and compensability](operations/claim-status-and-compensability.md) - [Other query providers](operations/other-query-providers.md) ### Business rules referencing CL_CLAIM_LEGAL_REPRESENTATIVE - [SD-BR-093 Active report record has a null expiration date](business-rules.md#sd-br-093-active-report-record-has-a-null-expiration-date) ### SQL referencing CL_CLAIM_LEGAL_REPRESENTATIVE - [SQL-064: `GetRepository().Query()`](sql/SQL-064-claim-query-provider-get-claim-legal-representative.md) - [SQL-219: `GetRepository().Query()`](sql/SQL-219-report-query-provider-get-legal-rep-claims-with-relationship.md) - [SQL-221: `GetRepository().Query()`](sql/SQL-221-report-query-provider-get-active-legal-rep-records-for-claim.md) --- ## CL_CLAIM_PERSON | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CL_CLAIM_SUPPORT_ORDER, CL_INJURY_CLAIM, CL_OVERPAYMENT | | **Business objects** | `ClaimQueryProvider` | ### Operations referencing CL_CLAIM_PERSON - [Recoverable overpayment balance](operations/recoverable-overpayment-balance.md) - [Claim data-quality queries](operations/claim-data-quality-queries.md) - [Other query providers](operations/other-query-providers.md) ### Business rules referencing CL_CLAIM_PERSON - [SD-BR-021 Recoverable balance sums outstanding amount for non-amended overpayments](business-rules.md#sd-br-021-recoverable-balance-sums-outstanding-amount-for-non-amended-overpayments) - [SD-BR-049 Missing tax id identified by a single space](business-rules.md#sd-br-049-missing-tax-id-identified-by-a-single-space) - [SD-BR-092 Active support order has no termination date](business-rules.md#sd-br-092-active-support-order-has-no-termination-date) ### SQL referencing CL_CLAIM_PERSON - [SQL-060: `GetRepository().Query()`](sql/SQL-060-claim-query-provider-get-claims-missing-tax-id.md) --- ## CL_CLAIM_PERSON_ADDRESS | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimQueryProvider` | ### Operations referencing CL_CLAIM_PERSON_ADDRESS - [Claim status and compensability](operations/claim-status-and-compensability.md) ### SQL referencing CL_CLAIM_PERSON_ADDRESS - [SQL-059: `GetRepository().Query()`](sql/SQL-059-claim-query-provider-get-claim-person-addresses.md) --- ## CL_CLAIM_REQUEST_DECISION | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimQueryProvider` | ### Operations referencing CL_CLAIM_REQUEST_DECISION - [Claim status and compensability](operations/claim-status-and-compensability.md) ### Business rules referencing CL_CLAIM_REQUEST_DECISION - [SD-BR-041 Latest claim status falls back to WCD status when no history](business-rules.md#sd-br-041-latest-claim-status-falls-back-to-wcd-status-when-no-history) - [SD-BR-042 Compensability status mapping](business-rules.md#sd-br-042-compensability-status-mapping) - [SD-BR-043 Original acceptance requires request type I with decision A](business-rules.md#sd-br-043-original-acceptance-requires-request-type-i-with-decision-a) ### SQL referencing CL_CLAIM_REQUEST_DECISION - [SQL-062: `GetRepository().Query()`](sql/SQL-062-claim-query-provider-get-claim-request-decisions.md) - [SQL-063: `GetRepository().Query()`](sql/SQL-063-claim-query-provider-get-original-acceptance.md) --- ## CL_CLAIM_RESPONSIBILITY | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimCodeTableBuilder` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimCodeTableBuilder` | ### SQL referencing CL_CLAIM_RESPONSIBILITY - [SQL-244: `GetRepository().Add(entity)`](sql/SQL-244-claim-code-table-builder-claim-responsibility.md) - [SQL-265: `GetRepository().Query()`](sql/SQL-265-claim-code-table-builder-claim-responsibility.md) --- ## CL_CLAIM_STATUS_ACTIVITY | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimBuilder`, `ClaimQueryProvider` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimBuilder`, `ClaimQueryProvider` | ### Operations referencing CL_CLAIM_STATUS_ACTIVITY - [Claim status and compensability](operations/claim-status-and-compensability.md) ### Business rules referencing CL_CLAIM_STATUS_ACTIVITY - [SD-BR-041 Latest claim status falls back to WCD status when no history](business-rules.md#sd-br-041-latest-claim-status-falls-back-to-wcd-status-when-no-history) - [SD-BR-042 Compensability status mapping](business-rules.md#sd-br-042-compensability-status-mapping) - [SD-BR-043 Original acceptance requires request type I with decision A](business-rules.md#sd-br-043-original-acceptance-requires-request-type-i-with-decision-a) ### SQL referencing CL_CLAIM_STATUS_ACTIVITY - [SQL-058: `GetRepository().Query()`](sql/SQL-058-claim-query-provider-get-claim-status-date.md) - [SQL-061: `GetRepository().Query()`](sql/SQL-061-claim-query-provider-get-claim-status-activity.md) - [SQL-242: `GetRepository().Add(entity)`](sql/SQL-242-claim-builder-claim-status.md) - [SQL-259: `GetRepository().Query()`](sql/SQL-259-claim-builder-claim-status.md) --- ## CL_CLAIM_SUPPORT_ORDER | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `WorkerQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped SUPPORT_ORDER_ID_SEQ; no insert in this library) | | **Related tables** | CL_CLAIM_PERSON | | **Business objects** | `WorkerQueryProvider` | ### Operations referencing CL_CLAIM_SUPPORT_ORDER - [Other query providers](operations/other-query-providers.md) ### Business rules referencing CL_CLAIM_SUPPORT_ORDER - [SD-BR-092 Active support order has no termination date](business-rules.md#sd-br-092-active-support-order-has-no-termination-date) ### SQL referencing CL_CLAIM_SUPPORT_ORDER - [SQL-237: `GetRepository().Query()`](sql/SQL-237-worker-query-provider-get-active-support-order-count.md) --- ## CL_CLAIM_TYPE_ACTIVITY | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimBuilder` for C-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimBuilder` | ### SQL referencing CL_CLAIM_TYPE_ACTIVITY - [SQL-241: `GetRepository().Add(entity)`](sql/SQL-241-claim-builder-claim-type.md) --- ## CL_CLAIM_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimBuilder`, `ClaimCodeTableBuilder`, `ClaimQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimBuilder`, `ClaimCodeTableBuilder`, `ClaimQueryProvider` | ### Operations referencing CL_CLAIM_TYPE_CODE - [Claim status and compensability](operations/claim-status-and-compensability.md) ### SQL referencing CL_CLAIM_TYPE_CODE - [SQL-072: `GetRepository().Query()`](sql/SQL-072-claim-query-provider-get-claim-type-code.md) - [SQL-257: `GetRepository().Query()`](sql/SQL-257-claim-builder-claim-type.md) - [SQL-262: `GetRepository().Query()`](sql/SQL-262-claim-code-table-builder-claim-type.md) --- ## CL_INCURRED_COST_HISTORY | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ReserveQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped CL_INCURRED_COST_HIST_SEQ; no insert in this library) | | **Related tables** | CL_INJURY_CLAIM | | **Business objects** | `ReserveQueryProvider` | ### Operations referencing CL_INCURRED_COST_HISTORY - [Other query providers](operations/other-query-providers.md) ### SQL referencing CL_INCURRED_COST_HISTORY - [SQL-222: `GetRepository().Query()`](sql/SQL-222-reserve-query-provider-get-latest-incurred-cost.md) - [SQL-223: `GetRepository().Query()`](sql/SQL-223-reserve-query-provider-get-incurred-cost-for-date.md) --- ## CL_INJURY_CLAIM | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider`, `WorkerQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped CLAIM_ID_SEQ; no insert in this library) | | **Related tables** | CL_CLAIM_PERSON, ATTENDING_PHYSICIAN, CL_INCURRED_COST_HISTORY, CL_MEDICAL_CONDITION, CL_PAYMENT_TOTAL, EAIP_PERIOD | | **Business objects** | `ClaimQueryProvider`, `WorkerQueryProvider` | ### Operations referencing CL_INJURY_CLAIM - [Claim status and compensability](operations/claim-status-and-compensability.md) - [Claim data-quality queries](operations/claim-data-quality-queries.md) - [Other query providers](operations/other-query-providers.md) ### Business rules referencing CL_INJURY_CLAIM - [SD-BR-049 Missing tax id identified by a single space](business-rules.md#sd-br-049-missing-tax-id-identified-by-a-single-space) - [SD-BR-092 Active support order has no termination date](business-rules.md#sd-br-092-active-support-order-has-no-termination-date) - [SD-BR-093 Active report record has a null expiration date](business-rules.md#sd-br-093-active-report-record-has-a-null-expiration-date) ### SQL referencing CL_INJURY_CLAIM - [SQL-060: `GetRepository().Query()`](sql/SQL-060-claim-query-provider-get-claims-missing-tax-id.md) - [SQL-066: `GetRepository().Query()`](sql/SQL-066-claim-query-provider-get-active-claims-with-outstanding-reserves.md) - [SQL-239: `GetRepository().Query()`](sql/SQL-239-worker-query-provider-get-health-insurance-provider-name.md) --- ## CL_JURISDICTION_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimCodeTableBuilder` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimCodeTableBuilder` | ### SQL referencing CL_JURISDICTION_CODE - [SQL-261: `GetRepository().Query()`](sql/SQL-261-claim-code-table-builder-jurisdiction.md) --- ## CL_MEDICAL_CONDITION | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CL_INJURY_CLAIM | | **Business objects** | `ClaimQueryProvider` | ### Operations referencing CL_MEDICAL_CONDITION - [Claim status and compensability](operations/claim-status-and-compensability.md) ### SQL referencing CL_MEDICAL_CONDITION - [SQL-065: `GetRepository().Query()`](sql/SQL-065-claim-query-provider-get-conditions.md) --- ## CL_OVERPAYMENT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `OverpaymentQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped CL_OVERPAYMENT_SEQ; no insert in this library) | | **Related tables** | CL_CLAIM_PERSON | | **Business objects** | `OverpaymentQueryProvider` | ### Operations referencing CL_OVERPAYMENT - [Recoverable overpayment balance](operations/recoverable-overpayment-balance.md) ### Business rules referencing CL_OVERPAYMENT - [SD-BR-021 Recoverable balance sums outstanding amount for non-amended overpayments](business-rules.md#sd-br-021-recoverable-balance-sums-outstanding-amount-for-non-amended-overpayments) ### SQL referencing CL_OVERPAYMENT - [SQL-190: `GetRepository().Query()`](sql/SQL-190-overpayment-query-provider-get-recoverable-balance.md) --- ## CL_PAYMENT_SPCL_HANDLING_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimPaymentQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimPaymentQueryProvider` | ### Operations referencing CL_PAYMENT_SPCL_HANDLING_CODE - [Other query providers](operations/other-query-providers.md) ### SQL referencing CL_PAYMENT_SPCL_HANDLING_CODE - [SQL-054: `GetRepository().Query()`](sql/SQL-054-claim-payment-query-provider-get-special-handling-codes.md) - [SQL-055: `GetRepository().Query()`](sql/SQL-055-claim-payment-query-provider-get-special-handling-code.md) --- ## CL_PAYMENT_TOTAL | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ReserveQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | CL_INJURY_CLAIM | | **Business objects** | `ReserveQueryProvider` | ### Operations referencing CL_PAYMENT_TOTAL - [Other query providers](operations/other-query-providers.md) ### SQL referencing CL_PAYMENT_TOTAL - [SQL-224: `GetRepository().Query()`](sql/SQL-224-reserve-query-provider-get-total-paid-to-date-for-category.md) --- ## CL_PHARMACY_DAW_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `BillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `BillQueryProvider` | ### Operations referencing CL_PHARMACY_DAW_CODE - [Bill queries](operations/bill-queries.md) ### Business rules referencing CL_PHARMACY_DAW_CODE - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing CL_PHARMACY_DAW_CODE - [SQL-048: `GetRepository().Query()`](sql/SQL-048-bill-query-provider-get-dispense-as-written.md) --- ## CL_PHARMACY_ELIGIBILITY_REPORT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimQueryProvider` | ### Operations referencing CL_PHARMACY_ELIGIBILITY_REPORT - [Claim status and compensability](operations/claim-status-and-compensability.md) ### SQL referencing CL_PHARMACY_ELIGIBILITY_REPORT - [SQL-067: `GetRepository().Query()`](sql/SQL-067-claim-query-provider-get-pharmacy-eligibility-report.md) --- ## CL_SECURITY_OVERRIDE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimSecurityOverrideProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped CL_OVERRIDE_SECURITY_SEQ; no insert in this library) | | **Related tables** | None identified | | **Business objects** | `ClaimSecurityOverrideProvider` | ### Operations referencing CL_SECURITY_OVERRIDE - [Claim security override check](operations/claim-security-override-check.md) ### Business rules referencing CL_SECURITY_OVERRIDE - [SD-BR-020 Employee has claim security override only when override row matches claim and employee within EffDate to ExpDate window](business-rules.md#sd-br-020-employee-has-claim-security-override-only-when-override-row-matches-claim-and-employee-within-effdate-to-expdate-window) ### SQL referencing CL_SECURITY_OVERRIDE - [SQL-073: `GetRepository().Query()`](sql/SQL-073-claim-security-override-provider-has-claim-security-override.md) --- ## CONSOLIDATED_CASE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped CONSOLIDATED_CASE_SEQ; no insert in this library) | | **Related tables** | LEGAL_CASE | | **Business objects** | `LegalQueryProvider` | ### Operations referencing CONSOLIDATED_CASE - [Legal case queries](operations/legal-case-queries.md) ### Business rules referencing CONSOLIDATED_CASE - [SD-BR-060 Case-to-claim resolution precedence](business-rules.md#sd-br-060-case-to-claim-resolution-precedence) - [SD-BR-061 Preferred employee name takes precedence](business-rules.md#sd-br-061-preferred-employee-name-takes-precedence) ### SQL referencing CONSOLIDATED_CASE - [SQL-165: `GetRepository().Query()`](sql/SQL-165-legal-query-provider-is-primary-case.md) --- ## CONTACT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LocationQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `LocationQueryProvider` | ### Operations referencing CONTACT - [Location lookups](operations/location-lookups.md) ### Business rules referencing CONTACT - [SD-BR-062 Location code and contact-type precedence](business-rules.md#sd-br-062-location-code-and-contact-type-precedence) ### SQL referencing CONTACT - [SQL-171: `GetRepository().Query()`](sql/SQL-171-location-query-provider-get-location-contacts.md) - [SQL-173: `GetRepository().Query()`](sql/SQL-173-location-query-provider-get-claim-location-contact-with-default.md) --- ## EAIP_PERIOD | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EAIP_PERIOD_SEQ; no insert in this library) | | **Related tables** | CL_INJURY_CLAIM | | **Business objects** | `ClaimQueryProvider` | ### Operations referencing EAIP_PERIOD - [Claim status and compensability](operations/claim-status-and-compensability.md) ### SQL referencing EAIP_PERIOD - [SQL-068: `GetRepository().Query()`](sql/SQL-068-claim-query-provider-get-eaip-periods.md) --- ## EBILL | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillDocumentQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider`, `EbillServiceQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_SEQ; no insert in this library) | | **Related tables** | CBP_BILL, EBILL_DOCUMENT, EBILL_ERROR_CONDITION, EBILL_HEALTH_INFORMATION, EBILL_SERVICE, EBILL_BATCH, EBILL_EOB, EBILL_PATIENT, EBILL_STATUS_CODE | | **Business objects** | `EbillDocumentQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider`, `EbillServiceQueryProvider` | ### Operations referencing EBILL - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) - [SD-BR-054 Zero-pay EOB candidate criteria](business-rules.md#sd-br-054-zero-pay-eob-candidate-criteria) - [SD-BR-055 DRG code identified by health information type](business-rules.md#sd-br-055-drg-code-identified-by-health-information-type) ### SQL referencing EBILL - [SQL-093: `GetRepository().Query()`](sql/SQL-093-ebill-document-query-provider-get-non-imaged-documentsfor-batch.md) - [SQL-096: `GetRepository().Query()`](sql/SQL-096-ebill-document-query-provider-get-billing-parent-documents-imaged-by-batch-id.md) - [SQL-100: `GetRepository().Query()`](sql/SQL-100-ebill-eob-query-provider-get-completed-zero-payment-bills-for-eob.md) - [SQL-101: `GetRepository().Query()`](sql/SQL-101-ebill-eob-query-provider-get-completed-zero-payment-bills-for-eob.md) - [SQL-114: `GetRepository().Query()`](sql/SQL-114-ebill-query-provider-get-bill.md) - [SQL-115: `GetRepository().Query()`](sql/SQL-115-ebill-query-provider-get-bill-by-clearinghouse-and-control-number.md) - [SQL-116: `GetRepository().Query()`](sql/SQL-116-ebill-query-provider-get-bill-count-by-clearinghouse-control-number.md) - [SQL-117: `GetRepository().Query()`](sql/SQL-117-ebill-query-provider-get-bills-for-response-file-for-clearinghouse.md) - [SQL-118: `GetRepository().Query()`](sql/SQL-118-ebill-query-provider-get-bills-by-batch.md) - [SQL-119: `GetRepository().Query()`](sql/SQL-119-ebill-query-provider-get-bills-by-eob.md) - [SQL-120: `GetRepository().Query()`](sql/SQL-120-ebill-query-provider-get-bills-by-received-month.md) - [SQL-122: `GetRepository().Query()`](sql/SQL-122-ebill-query-provider-get-non-indexed-bills.md) - [SQL-123: `GetRepository().Query()`](sql/SQL-123-ebill-query-provider-get-non-assigned-bills.md) - [SQL-124: `GetRepository().Query()`](sql/SQL-124-ebill-query-provider-get-non-imaged-bills.md) - [SQL-125: `GetRepository().Query()`](sql/SQL-125-ebill-query-provider-get-indexed-bills.md) - [SQL-126: `GetRepository().Query()`](sql/SQL-126-ebill-query-provider-get-imaged-bills.md) - [SQL-127: `GetRepository().Query()`](sql/SQL-127-ebill-query-provider-get-ebill.md) - [SQL-140: `GetRepository().Query()`](sql/SQL-140-ebill-service-query-provider-get-ebill-service.md) --- ## EBILL_ADDRESS | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillAddressQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_ADDRESS_SEQ; no insert in this library) | | **Related tables** | EBILL_BATCH | | **Business objects** | `EbillAddressQueryProvider` | ### Operations referencing EBILL_ADDRESS - [E-bill processing queries](operations/e-bill-processing-queries.md) ### SQL referencing EBILL_ADDRESS - [SQL-074: `GetRepository().Query()`](sql/SQL-074-ebill-address-query-provider-get-address.md) - [SQL-076: `GetRepository().Query()`](sql/SQL-076-ebill-address-query-provider-get-address-by-batch-id.md) --- ## EBILL_ADDRESS_OVERRIDE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillAddressQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `EbillAddressQueryProvider` | ### Operations referencing EBILL_ADDRESS_OVERRIDE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### SQL referencing EBILL_ADDRESS_OVERRIDE - [SQL-077: `GetRepository().Query()`](sql/SQL-077-ebill-address-query-provider-get-addresses-to-override.md) --- ## EBILL_ADDRESS_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillAddressQueryProvider`, `EbillingExtensions` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `EbillAddressQueryProvider`, `EbillingExtensions` | ### Operations referencing EBILL_ADDRESS_TYPE_CODE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### SQL referencing EBILL_ADDRESS_TYPE_CODE - [SQL-075: `GetRepository().Query()`](sql/SQL-075-ebill-address-query-provider-get-address-type-by-code.md) - [SQL-269: `GetRepository().Query()`](sql/SQL-269-ebilling-extensions-seed-for-ebilling.md) --- ## EBILL_ASSIGNMENT_RULE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_ASSIGNMENT_RULE_SEQ; no insert in this library) | | **Related tables** | None identified | | **Business objects** | `EbillQueryProvider` | ### Operations referencing EBILL_ASSIGNMENT_RULE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_ASSIGNMENT_RULE - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) ### SQL referencing EBILL_ASSIGNMENT_RULE - [SQL-133: `GetRepository().Query()`](sql/SQL-133-ebill-query-provider-get-bill-assignment-rule.md) --- ## EBILL_BATCH | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillBatchQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_BATCH_SEQ; no insert in this library) | | **Related tables** | EBILL, EBILL_ADDRESS, EBILL_EOB, EBILL_PROVIDER, EBILL_BATCH_STATUS_CODE, EBILL_BATCH_TYPE_CODE, EBILL_CLEARINGHOUSE | | **Business objects** | `EbillBatchQueryProvider`, `EbillEobQueryProvider`, `EbillQueryProvider` | ### Operations referencing EBILL_BATCH - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_BATCH - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) - [SD-BR-053 E-bill batch type classification](business-rules.md#sd-br-053-e-bill-batch-type-classification) - [SD-BR-054 Zero-pay EOB candidate criteria](business-rules.md#sd-br-054-zero-pay-eob-candidate-criteria) ### SQL referencing EBILL_BATCH - [SQL-078: `GetRepository().Query()`](sql/SQL-078-ebill-batch-query-provider-get-batch.md) - [SQL-079: `GetRepository().Query()`](sql/SQL-079-ebill-batch-query-provider-get-batch.md) - [SQL-080: `GetRepository().Query()`](sql/SQL-080-ebill-batch-query-provider-get-batch.md) - [SQL-081: `GetRepository().Query()`](sql/SQL-081-ebill-batch-query-provider-get-batch.md) - [SQL-082: `GetRepository().Query()`](sql/SQL-082-ebill-batch-query-provider-get-first-batch.md) - [SQL-083: `GetRepository().Query()`](sql/SQL-083-ebill-batch-query-provider-get-first-batch.md) - [SQL-084: `GetRepository().Query()`](sql/SQL-084-ebill-batch-query-provider-get-last-batch.md) - [SQL-085: `GetRepository().Query()`](sql/SQL-085-ebill-batch-query-provider-get-last-batch.md) - [SQL-086: `GetRepository().Query()`](sql/SQL-086-ebill-batch-query-provider-get-last-batch.md) - [SQL-100: `GetRepository().Query()`](sql/SQL-100-ebill-eob-query-provider-get-completed-zero-payment-bills-for-eob.md) - [SQL-115: `GetRepository().Query()`](sql/SQL-115-ebill-query-provider-get-bill-by-clearinghouse-and-control-number.md) - [SQL-117: `GetRepository().Query()`](sql/SQL-117-ebill-query-provider-get-bills-for-response-file-for-clearinghouse.md) - [SQL-120: `GetRepository().Query()`](sql/SQL-120-ebill-query-provider-get-bills-by-received-month.md) --- ## EBILL_BATCH_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillBatchQueryProvider`, `EbillingExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | EBILL_BATCH | | **Business objects** | `EbillBatchQueryProvider`, `EbillingExtensions` | ### Operations referencing EBILL_BATCH_STATUS_CODE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_BATCH_STATUS_CODE - [SD-BR-053 E-bill batch type classification](business-rules.md#sd-br-053-e-bill-batch-type-classification) ### SQL referencing EBILL_BATCH_STATUS_CODE - [SQL-089: `GetRepository().Query()`](sql/SQL-089-ebill-batch-query-provider-get-batch-status.md) - [SQL-266: `GetRepository().Query()`](sql/SQL-266-ebilling-extensions-seed-for-ebilling.md) --- ## EBILL_BATCH_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillBatchQueryProvider`, `EbillingExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | EBILL_BATCH | | **Business objects** | `EbillBatchQueryProvider`, `EbillingExtensions` | ### Operations referencing EBILL_BATCH_TYPE_CODE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_BATCH_TYPE_CODE - [SD-BR-053 E-bill batch type classification](business-rules.md#sd-br-053-e-bill-batch-type-classification) ### SQL referencing EBILL_BATCH_TYPE_CODE - [SQL-087: `GetRepository().Query()`](sql/SQL-087-ebill-batch-query-provider-get-batch-type.md) - [SQL-088: `GetRepository().Query()`](sql/SQL-088-ebill-batch-query-provider-get-batch-type-code.md) - [SQL-271: `GetRepository().Query()`](sql/SQL-271-ebilling-extensions-seed-for-ebilling.md) --- ## EBILL_CLEARINGHOUSE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillClearinghouseQueryProvider`, `EbillingQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_CLEARINGHOUSE_SEQ; no insert in this library) | | **Related tables** | EBILL_BATCH | | **Business objects** | `EbillClearinghouseQueryProvider`, `EbillingQueryProvider` | ### Operations referencing EBILL_CLEARINGHOUSE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_CLEARINGHOUSE - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) - [SD-BR-053 E-bill batch type classification](business-rules.md#sd-br-053-e-bill-batch-type-classification) - [SD-BR-054 Zero-pay EOB candidate criteria](business-rules.md#sd-br-054-zero-pay-eob-candidate-criteria) - [SD-BR-056 Active clearinghouse has a null end date](business-rules.md#sd-br-056-active-clearinghouse-has-a-null-end-date) ### SQL referencing EBILL_CLEARINGHOUSE - [SQL-090: `GetRepository().Query()`](sql/SQL-090-ebill-clearinghouse-query-provider-get-clearinghouse-by-tax-id.md) - [SQL-091: `GetRepository().Query()`](sql/SQL-091-ebill-clearinghouse-query-provider-get-clearinghouse-by-clearinghouse-code.md) - [SQL-142: `GetRepository().Query()`](sql/SQL-142-ebilling-query-provider-get-clearinghouse.md) --- ## EBILL_DOCUMENT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillDocumentQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_DOCUMENT_SEQ; no insert in this library) | | **Related tables** | EBILL | | **Business objects** | `EbillDocumentQueryProvider` | ### Operations referencing EBILL_DOCUMENT - [E-bill processing queries](operations/e-bill-processing-queries.md) ### SQL referencing EBILL_DOCUMENT - [SQL-092: `GetRepository().Query()`](sql/SQL-092-ebill-document-query-provider-get-document.md) - [SQL-093: `GetRepository().Query()`](sql/SQL-093-ebill-document-query-provider-get-non-imaged-documentsfor-batch.md) - [SQL-094: `GetRepository().Query()`](sql/SQL-094-ebill-document-query-provider-get-non-imaged-documentsfor-bill.md) - [SQL-095: `GetRepository().Query()`](sql/SQL-095-ebill-document-query-provider-get-documentsfor-bill.md) - [SQL-096: `GetRepository().Query()`](sql/SQL-096-ebill-document-query-provider-get-billing-parent-documents-imaged-by-batch-id.md) --- ## EBILL_DOCUMENT_OVERRIDE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillDocumentQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `EbillDocumentQueryProvider` | ### Operations referencing EBILL_DOCUMENT_OVERRIDE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### SQL referencing EBILL_DOCUMENT_OVERRIDE - [SQL-099: `GetRepository().Query()`](sql/SQL-099-ebill-document-query-provider-get-document-override.md) --- ## EBILL_DOCUMENT_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillDocumentQueryProvider`, `EbillingExtensions` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | EBILL_SET_TYPE_CODE | | **Business objects** | `EbillDocumentQueryProvider`, `EbillingExtensions` | ### Operations referencing EBILL_DOCUMENT_TYPE_CODE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### SQL referencing EBILL_DOCUMENT_TYPE_CODE - [SQL-097: `GetRepository().Query()`](sql/SQL-097-ebill-document-query-provider-get-document-type-by-code.md) - [SQL-098: `GetRepository().Query()`](sql/SQL-098-ebill-document-query-provider-get-document-type-by-set-type.md) - [SQL-270: `GetRepository().Query()`](sql/SQL-270-ebilling-extensions-seed-for-ebilling.md) - [SQL-272: `GetRepository().Query()`](sql/SQL-272-ebilling-extensions-update-document-type-with-set-code.md) --- ## EBILL_EOB | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillEobQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_EOB_SEQ; no insert in this library) | | **Related tables** | EBILL_BATCH, EBILL | | **Business objects** | `EbillEobQueryProvider` | ### Operations referencing EBILL_EOB - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_EOB - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) - [SD-BR-054 Zero-pay EOB candidate criteria](business-rules.md#sd-br-054-zero-pay-eob-candidate-criteria) ### SQL referencing EBILL_EOB - [SQL-102: `GetRepository().Query()`](sql/SQL-102-ebill-eob-query-provider-get-eobs-for-batch.md) - [SQL-103: `GetRepository().Query()`](sql/SQL-103-ebill-eob-query-provider-get-eob.md) --- ## EBILL_ERROR_CONDITION | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_ERROR_CONDITION_SEQ; no insert in this library) | | **Related tables** | EBILL, EBILL_PATIENT, EBILL_PROVIDER | | **Business objects** | `EbillQueryProvider` | ### Operations referencing EBILL_ERROR_CONDITION - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_ERROR_CONDITION - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) ### SQL referencing EBILL_ERROR_CONDITION - [SQL-129: `GetRepository().Query()`](sql/SQL-129-ebill-query-provider-get-pended-provider-errors.md) - [SQL-130: `GetRepository().Query()`](sql/SQL-130-ebill-query-provider-get-pended-patient-errors.md) - [SQL-131: `GetRepository().Query()`](sql/SQL-131-ebill-query-provider-get-pended-bill-errors.md) - [SQL-132: `GetRepository().Query()`](sql/SQL-132-ebill-query-provider-get-pended-errors.md) --- ## EBILL_HEALTH_INFORMATION | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillHealthInformationQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_HEALTH_INFORMATION_SEQ; no insert in this library) | | **Related tables** | EBILL, EBILL_HEALTH_INFO_TYPE_CODE | | **Business objects** | `EbillHealthInformationQueryProvider` | ### Operations referencing EBILL_HEALTH_INFORMATION - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_HEALTH_INFORMATION - [SD-BR-055 DRG code identified by health information type](business-rules.md#sd-br-055-drg-code-identified-by-health-information-type) ### SQL referencing EBILL_HEALTH_INFORMATION - [SQL-104: `GetRepository().Query()`](sql/SQL-104-ebill-health-information-query-provider-get-health-information.md) - [SQL-106: `GetRepository().Query()`](sql/SQL-106-ebill-health-information-query-provider-get-drg-code.md) --- ## EBILL_HEALTH_INFO_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillHealthInformationQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | EBILL_HEALTH_INFORMATION | | **Business objects** | `EbillHealthInformationQueryProvider` | ### Operations referencing EBILL_HEALTH_INFO_TYPE_CODE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_HEALTH_INFO_TYPE_CODE - [SD-BR-055 DRG code identified by health information type](business-rules.md#sd-br-055-drg-code-identified-by-health-information-type) ### SQL referencing EBILL_HEALTH_INFO_TYPE_CODE - [SQL-105: `GetRepository().Query()`](sql/SQL-105-ebill-health-information-query-provider-get-health-info-type-by-code.md) --- ## EBILL_INVOICE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillInvoiceQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_INVOICE_SEQ; no insert in this library) | | **Related tables** | EBILL_INVOICE_BILL, EBILL_INVOICE_ERROR | | **Business objects** | `EbillInvoiceQueryProvider` | ### Operations referencing EBILL_INVOICE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### SQL referencing EBILL_INVOICE - [SQL-107: `GetRepository().Query()`](sql/SQL-107-ebill-invoice-query-provider-get-invoice.md) --- ## EBILL_INVOICE_BILL | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillInvoiceQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_INVOICE_BILL_SEQ; no insert in this library) | | **Related tables** | EBILL_INVOICE | | **Business objects** | `EbillInvoiceQueryProvider` | ### Operations referencing EBILL_INVOICE_BILL - [E-bill processing queries](operations/e-bill-processing-queries.md) ### SQL referencing EBILL_INVOICE_BILL - [SQL-108: `GetRepository().Query()`](sql/SQL-108-ebill-invoice-query-provider-get-invoice-bills.md) --- ## EBILL_INVOICE_ERROR | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillInvoiceQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_INVOICE_ERROR_SEQ; no insert in this library) | | **Related tables** | EBILL_INVOICE | | **Business objects** | `EbillInvoiceQueryProvider` | ### Operations referencing EBILL_INVOICE_ERROR - [E-bill processing queries](operations/e-bill-processing-queries.md) ### SQL referencing EBILL_INVOICE_ERROR - [SQL-109: `GetRepository().Query()`](sql/SQL-109-ebill-invoice-query-provider-get-invoice-error.md) --- ## EBILL_PATIENT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillPatientQueryProvider`, `EbillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_PATIENT_SEQ; no insert in this library) | | **Related tables** | EBILL, EBILL_ERROR_CONDITION, EBILL_PROVIDER | | **Business objects** | `EbillPatientQueryProvider`, `EbillQueryProvider` | ### Operations referencing EBILL_PATIENT - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_PATIENT - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) ### SQL referencing EBILL_PATIENT - [SQL-110: `GetRepository().Query()`](sql/SQL-110-ebill-patient-query-provider-get-patient.md) - [SQL-111: `GetRepository().Query()`](sql/SQL-111-ebill-patient-query-provider-get-non-indexed-patients.md) - [SQL-122: `GetRepository().Query()`](sql/SQL-122-ebill-query-provider-get-non-indexed-bills.md) - [SQL-123: `GetRepository().Query()`](sql/SQL-123-ebill-query-provider-get-non-assigned-bills.md) - [SQL-125: `GetRepository().Query()`](sql/SQL-125-ebill-query-provider-get-indexed-bills.md) - [SQL-126: `GetRepository().Query()`](sql/SQL-126-ebill-query-provider-get-imaged-bills.md) --- ## EBILL_PROVIDER | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillPatientQueryProvider`, `EbillProviderQueryProvider`, `EbillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_PROVIDER_SEQ; no insert in this library) | | **Related tables** | EBILL_BATCH, EBILL_ERROR_CONDITION, EBILL_PATIENT, PROVIDER_LOCATION | | **Business objects** | `EbillPatientQueryProvider`, `EbillProviderQueryProvider`, `EbillQueryProvider` | ### Operations referencing EBILL_PROVIDER - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_PROVIDER - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) ### SQL referencing EBILL_PROVIDER - [SQL-111: `GetRepository().Query()`](sql/SQL-111-ebill-patient-query-provider-get-non-indexed-patients.md) - [SQL-112: `GetRepository().Query()`](sql/SQL-112-ebill-provider-query-provider-get-provider.md) - [SQL-113: `GetRepository().Query()`](sql/SQL-113-ebill-provider-query-provider-get-non-indexed-providers.md) - [SQL-122: `GetRepository().Query()`](sql/SQL-122-ebill-query-provider-get-non-indexed-bills.md) - [SQL-123: `GetRepository().Query()`](sql/SQL-123-ebill-query-provider-get-non-assigned-bills.md) - [SQL-125: `GetRepository().Query()`](sql/SQL-125-ebill-query-provider-get-indexed-bills.md) - [SQL-126: `GetRepository().Query()`](sql/SQL-126-ebill-query-provider-get-imaged-bills.md) --- ## EBILL_RESPONSE_SET | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_RESPONSE_SEQ; no insert in this library) | | **Related tables** | None identified | | **Business objects** | `EbillQueryProvider` | ### Operations referencing EBILL_RESPONSE_SET - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_RESPONSE_SET - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) ### SQL referencing EBILL_RESPONSE_SET - [SQL-121: `GetRepository().Query()`](sql/SQL-121-ebill-query-provider-get-ebill-response-set.md) --- ## EBILL_SERVICE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillQueryProvider`, `EbillServiceQueryProvider` for RU-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read, Update | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EBILL_SERVICE_SEQ; no insert in this library) | | **Related tables** | EBILL | | **Business objects** | `EbillQueryProvider`, `EbillServiceQueryProvider` | ### Operations referencing EBILL_SERVICE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_SERVICE - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) ### SQL referencing EBILL_SERVICE - [SQL-137: `GetRepository().Query()`](sql/SQL-137-ebill-query-provider-set-compound-drug-for-all-service-lines-for-the-bill.md) - [SQL-138: `GetRepository().Query()`](sql/SQL-138-ebill-service-query-provider-get-maximum-service-date.md) - [SQL-139: `GetRepository().Query()`](sql/SQL-139-ebill-service-query-provider-get-minimum-service-date.md) - [SQL-141: `GetRepository().Query()`](sql/SQL-141-ebill-service-query-provider-get-ebill-service.md) - [SQL-240: `EbillService` property change (flush)*](sql/SQL-240-ebill-query-provider-set-compound-drug-for-all-service-lines-for-the-bill.md) --- ## EBILL_SET_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillQueryProvider`, `EbillingExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | EBILL_DOCUMENT_TYPE_CODE | | **Business objects** | `EbillQueryProvider`, `EbillingExtensions` | ### Operations referencing EBILL_SET_TYPE_CODE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_SET_TYPE_CODE - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) ### SQL referencing EBILL_SET_TYPE_CODE - [SQL-134: `GetRepository().Query()`](sql/SQL-134-ebill-query-provider-get-bill-set-type-code.md) - [SQL-135: `GetRepository().Query()`](sql/SQL-135-ebill-query-provider-get-bill-set-type-code-by-code.md) - [SQL-268: `GetRepository().Query()`](sql/SQL-268-ebilling-extensions-seed-for-ebilling.md) - [SQL-272: `GetRepository().Query()`](sql/SQL-272-ebilling-extensions-update-document-type-with-set-code.md) - [SQL-273: `GetRepository().Query()`](sql/SQL-273-ebilling-extensions-update-document-type-with-set-code.md) --- ## EBILL_STATUS_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillQueryProvider`, `EbillingExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | EBILL | | **Business objects** | `EbillQueryProvider`, `EbillingExtensions` | ### Operations referencing EBILL_STATUS_CODE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EBILL_STATUS_CODE - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) ### SQL referencing EBILL_STATUS_CODE - [SQL-128: `GetRepository().Query()`](sql/SQL-128-ebill-query-provider-get-bill-status-code.md) - [SQL-267: `GetRepository().Query()`](sql/SQL-267-ebilling-extensions-seed-for-ebilling.md) --- ## EDI_BILL | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EdiQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EDI_BILL_SEQ; no insert in this library) | | **Related tables** | EDI_BILL_REPORT | | **Business objects** | `EdiQueryProvider` | ### Operations referencing EDI_BILL - [Other query providers](operations/other-query-providers.md) ### SQL referencing EDI_BILL - [SQL-144: `GetRepository().Query()`](sql/SQL-144-edi-query-provider-get-bill.md) - [SQL-145: `GetRepository().Query()`](sql/SQL-145-edi-query-provider-get-bill-by-segment-count.md) --- ## EDI_BILL_REPORT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EdiQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped EDI_BILL_REPORT_SEQ; no insert in this library) | | **Related tables** | EDI_BILL | | **Business objects** | `EdiQueryProvider` | ### Operations referencing EDI_BILL_REPORT - [Other query providers](operations/other-query-providers.md) ### SQL referencing EDI_BILL_REPORT - [SQL-143: `GetRepository().Query()`](sql/SQL-143-edi-query-provider-get-bill-report.md) --- ## EDI_PLACE_OF_SERVICE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `EbillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `EbillQueryProvider` | ### Operations referencing EDI_PLACE_OF_SERVICE_CODE - [E-bill processing queries](operations/e-bill-processing-queries.md) ### Business rules referencing EDI_PLACE_OF_SERVICE_CODE - [SD-BR-050 E-bill status and assignment-rule code sets](business-rules.md#sd-br-050-e-bill-status-and-assignment-rule-code-sets) - [SD-BR-051 Bill included in clearinghouse response file by response-batch state](business-rules.md#sd-br-051-bill-included-in-clearinghouse-response-file-by-response-batch-state) - [SD-BR-052 Multiple prescription numbers mark all NDC lines as compound drug](business-rules.md#sd-br-052-multiple-prescription-numbers-mark-all-ndc-lines-as-compound-drug) ### SQL referencing EDI_PLACE_OF_SERVICE_CODE - [SQL-136: `GetRepository().Query()`](sql/SQL-136-ebill-query-provider-get-edi-place-of-service-code.md) --- ## ENDORSE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyOutputDocumentExtensions` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PolicyOutputDocumentExtensions` | ### SQL referencing ENDORSE_CODE - [SQL-294: `GetRepository().Query()`](sql/SQL-294-policy-output-document-extensions-seed-for-document-testing.md) --- ## ERROR_ENVIRONMENT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `OnlineSupportExtensions` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OnlineSupportExtensions` | ### SQL referencing ERROR_ENVIRONMENT - [SQL-275: `GetRepository().Query()`](sql/SQL-275-online-support-extensions-seed-for-online-support.md) --- ## ERROR_GROUP_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `OnlineSupportExtensions` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OnlineSupportExtensions` | ### SQL referencing ERROR_GROUP_CODE - [SQL-274: `GetRepository().Query()`](sql/SQL-274-online-support-extensions-seed-for-online-support.md) --- ## ERROR_GROUP_ENVIRONMENT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `OnlineSupportExtensions` for C-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OnlineSupportExtensions` | ### SQL referencing ERROR_GROUP_ENVIRONMENT - [SQL-245: `GetRepository().Add(entity)`](sql/SQL-245-online-support-extensions-seed-for-online-support.md) --- ## IMAGE_AFFILIATION | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | Unknown** | | **Purpose** | Accessed by `ImageQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | image | | **Business objects** | `ImageQueryProvider` | ### SQL referencing IMAGE_AFFILIATION - [SQL-148: `GetRepository().Query()`](sql/SQL-148-image-query-provider-get-affilliated-images.md) --- ## IMGSYS | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | Unknown** | | **Purpose** | Accessed by `ImageQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ImageQueryProvider` | ### SQL referencing IMGSYS - [SQL-149: `GetRepository().Query()`](sql/SQL-149-image-query-provider-get-image-system.md) --- ## IcdVersionCode | Field | Value | | --- | --- | | **Database** | Unknown** | | **Schema/Link** | Unknown** | | **Purpose** | Accessed by `BillQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `BillQueryProvider` | ### Operations referencing IcdVersionCode - [Bill queries](operations/bill-queries.md) ### Business rules referencing IcdVersionCode - [SD-BR-034 Bill entry source classification](business-rules.md#sd-br-034-bill-entry-source-classification) - [SD-BR-035 Bill allowed total treats null as zero](business-rules.md#sd-br-035-bill-allowed-total-treats-null-as-zero) - [SD-BR-036 Service code current only when expiration date is null](business-rules.md#sd-br-036-service-code-current-only-when-expiration-date-is-null) ### SQL referencing IcdVersionCode - [SQL-050: `GetRepository().Query()`](sql/SQL-050-bill-query-provider-get-icd-version.md) --- ## LEGAL_BILL | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped LEGAL_BILL_SEQ; no insert in this library) | | **Related tables** | LEGAL_CASE | | **Business objects** | `LegalQueryProvider` | ### Operations referencing LEGAL_BILL - [Legal case queries](operations/legal-case-queries.md) ### Business rules referencing LEGAL_BILL - [SD-BR-060 Case-to-claim resolution precedence](business-rules.md#sd-br-060-case-to-claim-resolution-precedence) - [SD-BR-061 Preferred employee name takes precedence](business-rules.md#sd-br-061-preferred-employee-name-takes-precedence) ### SQL referencing LEGAL_BILL - [SQL-156: `GetRepository().Query()`](sql/SQL-156-legal-query-provider-get-legal-bills.md) --- ## LEGAL_CASE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ImageQueryProvider`, `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped LEGAL_CASE_SEQ; no insert in this library) | | **Related tables** | CASE_STATUS_CODE, APPEAL, CASE_COST, CONSOLIDATED_CASE, LEGAL_BILL, SUBPOENA | | **Business objects** | `ImageQueryProvider`, `LegalQueryProvider` | ### Operations referencing LEGAL_CASE - [Legal case queries](operations/legal-case-queries.md) - [Other query providers](operations/other-query-providers.md) ### Business rules referencing LEGAL_CASE - [SD-BR-060 Case-to-claim resolution precedence](business-rules.md#sd-br-060-case-to-claim-resolution-precedence) - [SD-BR-061 Preferred employee name takes precedence](business-rules.md#sd-br-061-preferred-employee-name-takes-precedence) ### SQL referencing LEGAL_CASE - [SQL-151: `GetRepository().Query()`](sql/SQL-151-image-query-provider-alert-legal.md) - [SQL-152: `GetRepository().Query()`](sql/SQL-152-legal-query-provider-get-legal-case.md) - [SQL-153: `GetRepository().Query()`](sql/SQL-153-legal-query-provider-get-legal-cases.md) - [SQL-154: `GetRepository().Query()`](sql/SQL-154-legal-query-provider-get-claim-id-for-case.md) - [SQL-160: `GetRepository().Query()`](sql/SQL-160-legal-query-provider-get-active-legal-cases.md) - [SQL-166: `GetRepository().Query()`](sql/SQL-166-legal-query-provider-is-image-alert-needed.md) --- ## LEGAL_PERSON | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped LEGAL_PERSON_SEQ; no insert in this library) | | **Related tables** | LEGAL_PERSON_ADDRESS | | **Business objects** | `LegalQueryProvider` | ### Operations referencing LEGAL_PERSON - [Legal case queries](operations/legal-case-queries.md) ### Business rules referencing LEGAL_PERSON - [SD-BR-060 Case-to-claim resolution precedence](business-rules.md#sd-br-060-case-to-claim-resolution-precedence) - [SD-BR-061 Preferred employee name takes precedence](business-rules.md#sd-br-061-preferred-employee-name-takes-precedence) ### SQL referencing LEGAL_PERSON - [SQL-163: `GetRepository().Query()`](sql/SQL-163-legal-query-provider-get-legal-person.md) --- ## LEGAL_PERSON_ADDRESS | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | LEGAL_PERSON | | **Business objects** | `LegalQueryProvider` | ### Operations referencing LEGAL_PERSON_ADDRESS - [Legal case queries](operations/legal-case-queries.md) ### Business rules referencing LEGAL_PERSON_ADDRESS - [SD-BR-060 Case-to-claim resolution precedence](business-rules.md#sd-br-060-case-to-claim-resolution-precedence) - [SD-BR-061 Preferred employee name takes precedence](business-rules.md#sd-br-061-preferred-employee-name-takes-precedence) ### SQL referencing LEGAL_PERSON_ADDRESS - [SQL-164: `GetRepository().Query()`](sql/SQL-164-legal-query-provider-get-legal-person-address.md) --- ## LOCATION | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LocationQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped LOCATION_SEQ; no insert in this library) | | **Related tables** | None identified | | **Business objects** | `LocationQueryProvider` | ### Operations referencing LOCATION - [Location lookups](operations/location-lookups.md) ### Business rules referencing LOCATION - [SD-BR-062 Location code and contact-type precedence](business-rules.md#sd-br-062-location-code-and-contact-type-precedence) ### SQL referencing LOCATION - [SQL-167: `GetRepository().Query()`](sql/SQL-167-location-query-provider-get-location.md) - [SQL-168: `GetRepository().Query()`](sql/SQL-168-location-query-provider-get-policy-locations.md) - [SQL-169: `GetRepository().Query()`](sql/SQL-169-location-query-provider-get-primary-location.md) - [SQL-170: `GetRepository().Query()`](sql/SQL-170-location-query-provider-get-policy-mailing-location.md) - [SQL-172: `GetRepository().Query()`](sql/SQL-172-location-query-provider-get-polcy-claim-location-with-default.md) - [SQL-175: `GetRepository().Query()`](sql/SQL-175-location-query-provider-get-oregon-business-locations.md) --- ## LOCATION_VERIFICATION_REQUEST | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AddressVerificationQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | ADDRESS_VERIFICATION_REQUEST | | **Business objects** | `AddressVerificationQueryProvider` | ### Operations referencing LOCATION_VERIFICATION_REQUEST - [Other query providers](operations/other-query-providers.md) ### SQL referencing LOCATION_VERIFICATION_REQUEST - [SQL-001: `GetRepository().Query()`](sql/SQL-001-address-verification-query-provider-get-location-verification-requests.md) --- ## LPT_CLAIM_CROSS_REFERENCE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimQueryProvider` | ### Operations referencing LPT_CLAIM_CROSS_REFERENCE - [Claim status and compensability](operations/claim-status-and-compensability.md) ### SQL referencing LPT_CLAIM_CROSS_REFERENCE - [SQL-056: `GetRepository().Query()`](sql/SQL-056-claim-query-provider-get-claim-from-injury-claim-cross-reference.md) --- ## MARKET_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyExtensions` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PolicyExtensions` | ### SQL referencing MARKET_TYPE_CODE - [SQL-277: `GetRepository().Query()`](sql/SQL-277-policy-extensions-seed-for-policy-testing.md) - [SQL-282: `GetRepository().Query()`](sql/SQL-282-policy-extensions-generate-default-policies.md) - [SQL-284: `GetRepository().Query()`](sql/SQL-284-policy-extensions-generate-relationship-policies.md) --- ## MCO_PROVIDER | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ProviderQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ProviderQueryProvider` | ### Operations referencing MCO_PROVIDER - [Provider queries](operations/provider-queries.md) ### Business rules referencing MCO_PROVIDER - [SD-BR-080 Provider identity relationship and address code sets](business-rules.md#sd-br-080-provider-identity-relationship-and-address-code-sets) - [SD-BR-082 Dismissed bills excluded from provider location ids](business-rules.md#sd-br-082-dismissed-bills-excluded-from-provider-location-ids) - [SD-BR-083 Provider in MCO only within date window](business-rules.md#sd-br-083-provider-in-mco-only-within-date-window) ### SQL referencing MCO_PROVIDER - [SQL-215: `GetRepository().Query()`](sql/SQL-215-provider-query-provider-get-provider-mcoplans.md) - [SQL-216: `GetRepository().Query()`](sql/SQL-216-provider-query-provider-is-provider-in-mco.md) --- ## MEDICARE_BENEFICIARY_QUERY | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `MedicareQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped MEDICARE_QUERY_SEQ; no insert in this library) | | **Related tables** | None identified | | **Business objects** | `MedicareQueryProvider` | ### Operations referencing MEDICARE_BENEFICIARY_QUERY - [Other query providers](operations/other-query-providers.md) ### Business rules referencing MEDICARE_BENEFICIARY_QUERY - [SD-BR-095 Medicare history match requires all fields equal](business-rules.md#sd-br-095-medicare-history-match-requires-all-fields-equal) ### SQL referencing MEDICARE_BENEFICIARY_QUERY - [SQL-178: `GetRepository().Query()`](sql/SQL-178-medicare-query-provider-get-countfor-batch-of-medicare-beneficiary.md) - [SQL-180: `GetRepository().Query()`](sql/SQL-180-medicare-query-provider-get-beneficiaries.md) --- ## MEDICARE_BENEFICIARY_QUERY_BAT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `MedicareQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `MedicareQueryProvider` | ### Operations referencing MEDICARE_BENEFICIARY_QUERY_BAT - [Other query providers](operations/other-query-providers.md) ### Business rules referencing MEDICARE_BENEFICIARY_QUERY_BAT - [SD-BR-095 Medicare history match requires all fields equal](business-rules.md#sd-br-095-medicare-history-match-requires-all-fields-equal) ### SQL referencing MEDICARE_BENEFICIARY_QUERY_BAT - [SQL-176: `GetRepository().Query()`](sql/SQL-176-medicare-query-provider-get-next-minumum-submission-batch.md) --- ## MEDICARE_QUERY_HISTORY | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `MedicareQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped MEDICARE_QUERY_HISTORY_SEQ; no insert in this library) | | **Related tables** | None identified | | **Business objects** | `MedicareQueryProvider` | ### Operations referencing MEDICARE_QUERY_HISTORY - [Other query providers](operations/other-query-providers.md) ### Business rules referencing MEDICARE_QUERY_HISTORY - [SD-BR-095 Medicare history match requires all fields equal](business-rules.md#sd-br-095-medicare-history-match-requires-all-fields-equal) ### SQL referencing MEDICARE_QUERY_HISTORY - [SQL-177: `GetRepository().Query()`](sql/SQL-177-medicare-query-provider-find-medicare-history-match.md) - [SQL-179: `GetRepository().Query()`](sql/SQL-179-medicare-query-provider-get-countfor-batch-of-medicare-history.md) --- ## NON_EMPR_ACCT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PolicyQueryProvider` | ### Operations referencing NON_EMPR_ACCT - [Other query providers](operations/other-query-providers.md) ### SQL referencing NON_EMPR_ACCT - [SQL-195: `GetRepository().Query()`](sql/SQL-195-policy-query-provider-get-non-policy-account.md) --- ## OFFICE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LocationQueryProvider`, `PolicyExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | POLICY | | **Business objects** | `LocationQueryProvider`, `PolicyExtensions` | ### Operations referencing OFFICE_CODE - [Location lookups](operations/location-lookups.md) ### Business rules referencing OFFICE_CODE - [SD-BR-062 Location code and contact-type precedence](business-rules.md#sd-br-062-location-code-and-contact-type-precedence) ### SQL referencing OFFICE_CODE - [SQL-174: `GetRepository().Query()`](sql/SQL-174-location-query-provider-get-office-code.md) - [SQL-279: `GetRepository().Query()`](sql/SQL-279-policy-extensions-seed-for-policy-testing.md) - [SQL-283: `GetRepository().Query()`](sql/SQL-283-policy-extensions-generate-default-policies.md) --- ## OTHER_FIRM | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped LEGAL_PERSON_SEQ; no insert in this library) | | **Related tables** | None identified | | **Business objects** | `LegalQueryProvider` | ### Operations referencing OTHER_FIRM - [Legal case queries](operations/legal-case-queries.md) ### Business rules referencing OTHER_FIRM - [SD-BR-060 Case-to-claim resolution precedence](business-rules.md#sd-br-060-case-to-claim-resolution-precedence) - [SD-BR-061 Preferred employee name takes precedence](business-rules.md#sd-br-061-preferred-employee-name-takes-precedence) ### SQL referencing OTHER_FIRM - [SQL-162: `GetRepository().Query()`](sql/SQL-162-legal-query-provider-get-other-firm.md) --- ## PAYMENT_TRANSACTION_STAT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PaymentsQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped PAYMENT_TRANSACTION_STAT_SEQ; no insert in this library) | | **Related tables** | PAYMENT_TRANSACTION_TYPE_CODE | | **Business objects** | `PaymentsQueryProvider` | ### Operations referencing PAYMENT_TRANSACTION_STAT - [Other query providers](operations/other-query-providers.md) ### Business rules referencing PAYMENT_TRANSACTION_STAT - [SD-BR-094 MA code identifies medical audit payment type](business-rules.md#sd-br-094-ma-code-identifies-medical-audit-payment-type) ### SQL referencing PAYMENT_TRANSACTION_STAT - [SQL-191: `GetRepository().Query()`](sql/SQL-191-payments-query-provider-get-payment-transaction-statisic.md) - [SQL-192: `GetRepository().Query()`](sql/SQL-192-payments-query-provider-get-last-payment-transaction-statisic.md) --- ## PAYMENT_TRANSACTION_TYPE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PaymentsQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | PAYMENT_TRANSACTION_STAT | | **Business objects** | `PaymentsQueryProvider` | ### Operations referencing PAYMENT_TRANSACTION_TYPE_CODE - [Other query providers](operations/other-query-providers.md) ### Business rules referencing PAYMENT_TRANSACTION_TYPE_CODE - [SD-BR-094 MA code identifies medical audit payment type](business-rules.md#sd-br-094-ma-code-identifies-medical-audit-payment-type) ### SQL referencing PAYMENT_TRANSACTION_TYPE_CODE - [SQL-193: `GetRepository().Query()`](sql/SQL-193-payments-query-provider-get-payment-type.md) --- ## POLICY | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `OutputDocumentQueryProvider`, `PolicyQueryProvider`, `ClaimBuilder`, `PolicyExtensions`, `PolicyOutputDocumentExtensions` for CRU-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read, Update | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | Agent, OFFICE_CODE, POLICY_PERIOD_GROUP_ASSOC | | **Business objects** | `OutputDocumentQueryProvider`, `PolicyQueryProvider`, `ClaimBuilder`, `PolicyExtensions`, `PolicyOutputDocumentExtensions` | ### Operations referencing POLICY - [Output document queries](operations/output-document-queries.md) - [Other query providers](operations/other-query-providers.md) ### Business rules referencing POLICY - [SD-BR-070 Output document status code set](business-rules.md#sd-br-070-output-document-status-code-set) - [SD-BR-071 Document date defaults from batch process log](business-rules.md#sd-br-071-document-date-defaults-from-batch-process-log) - [SD-BR-075 Child documents only retrievable for a released parent](business-rules.md#sd-br-075-child-documents-only-retrievable-for-a-released-parent) ### SQL referencing POLICY - [SQL-182: `GetRepository().Query()`](sql/SQL-182-output-document-query-provider-get-account-number.md) - [SQL-194: `GetRepository().Query()`](sql/SQL-194-policy-query-provider-get-policy.md) - [SQL-243: `GetRepository().Add(entity)`](sql/SQL-243-claim-builder-policy.md) - [SQL-249: `GetRepository().Add(entity)`](sql/SQL-249-policy-extensions-generate-default-policies.md) - [SQL-250: `GetRepository().Add(entity)`](sql/SQL-250-policy-extensions-generate-relationship-policies.md) - [SQL-260: `GetRepository().Query()`](sql/SQL-260-claim-builder-policy.md) - [SQL-286: `GetRepository().Query()`](sql/SQL-286-policy-output-document-extensions-get-regional-policy-served-by-direct-writer.md) - [SQL-287: `GetRepository().Query()`](sql/SQL-287-policy-output-document-extensions-seed-with-documents-on-apolicy-served-by-an-external-agent.md) - [SQL-296: `GetRepository().Query()`](sql/SQL-296-policy-output-document-extensions-generate-packet.md) --- ## POLICY_PERIOD_GROUP_ASSOC | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | POLICY | | **Business objects** | `PolicyQueryProvider` | ### Operations referencing POLICY_PERIOD_GROUP_ASSOC - [Other query providers](operations/other-query-providers.md) ### SQL referencing POLICY_PERIOD_GROUP_ASSOC - [SQL-198: `GetRepository().Query()`](sql/SQL-198-policy-query-provider-get-group-association.md) --- ## POLICY_PERIOD_PAYROLL_AUDIT | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PolicyQueryProvider` | ### Operations referencing POLICY_PERIOD_PAYROLL_AUDIT - [Other query providers](operations/other-query-providers.md) ### SQL referencing POLICY_PERIOD_PAYROLL_AUDIT - [SQL-199: `GetRepository().Query()`](sql/SQL-199-policy-query-provider-get-payroll-report-for-report-id.md) --- ## POLICY_RELATIONSHIP_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyExtensions` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PolicyExtensions` | ### SQL referencing POLICY_RELATIONSHIP_CODE - [SQL-278: `GetRepository().Query()`](sql/SQL-278-policy-extensions-seed-for-policy-testing.md) - [SQL-285: `GetRepository().Query()`](sql/SQL-285-policy-extensions-generate-relationship-policies.md) --- ## POLICY_TEAM_FUNCTION | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyExtensions`, `PolicyQueryProvider` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `PolicyExtensions`, `PolicyQueryProvider` | ### Operations referencing POLICY_TEAM_FUNCTION - [Other query providers](operations/other-query-providers.md) ### SQL referencing POLICY_TEAM_FUNCTION - [SQL-196: `GetRepository().Query()`](sql/SQL-196-policy-query-provider-get-policy-team-function.md) - [SQL-248: `GetRepository().Add(entity)`](sql/SQL-248-policy-extensions-generate-default-policies.md) - [SQL-281: `GetRepository().Query()`](sql/SQL-281-policy-extensions-generate-default-policies.md) --- ## PROVIDER | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ProviderQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped PROVIDER_SEQ; no insert in this library) | | **Related tables** | PROVIDER_LOCATION | | **Business objects** | `ProviderQueryProvider` | ### Operations referencing PROVIDER - [Provider queries](operations/provider-queries.md) ### Business rules referencing PROVIDER - [SD-BR-080 Provider identity relationship and address code sets](business-rules.md#sd-br-080-provider-identity-relationship-and-address-code-sets) - [SD-BR-082 Dismissed bills excluded from provider location ids](business-rules.md#sd-br-082-dismissed-bills-excluded-from-provider-location-ids) - [SD-BR-083 Provider in MCO only within date window](business-rules.md#sd-br-083-provider-in-mco-only-within-date-window) ### SQL referencing PROVIDER - [SQL-202: `GetRepository().Query()`](sql/SQL-202-provider-query-provider-get-provider.md) - [SQL-204: `GetRepository().Query()`](sql/SQL-204-provider-query-provider-get-provider-by-tax-id.md) --- ## PROVIDER_ADDRESS | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ProviderQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped PROVIDER_ADDRESS_SEQ; no insert in this library) | | **Related tables** | PROVIDER_LOCATION | | **Business objects** | `ProviderQueryProvider` | ### Operations referencing PROVIDER_ADDRESS - [Provider queries](operations/provider-queries.md) ### Business rules referencing PROVIDER_ADDRESS - [SD-BR-080 Provider identity relationship and address code sets](business-rules.md#sd-br-080-provider-identity-relationship-and-address-code-sets) - [SD-BR-082 Dismissed bills excluded from provider location ids](business-rules.md#sd-br-082-dismissed-bills-excluded-from-provider-location-ids) - [SD-BR-083 Provider in MCO only within date window](business-rules.md#sd-br-083-provider-in-mco-only-within-date-window) ### SQL referencing PROVIDER_ADDRESS - [SQL-200: `GetRepository().Query()`](sql/SQL-200-provider-query-provider-get-provider-address-last-update-date.md) - [SQL-201: `GetRepository().Query()`](sql/SQL-201-provider-query-provider-get-all-active-provider-addresses-for-update-date.md) - [SQL-206: `GetRepository().Query()`](sql/SQL-206-provider-query-provider-get-provider-addresses.md) - [SQL-207: `GetRepository().Query()`](sql/SQL-207-provider-query-provider-get-provider-addresses.md) - [SQL-208: `GetRepository().Query()`](sql/SQL-208-provider-query-provider-get-provider-location-addresses.md) - [SQL-209: `GetRepository().Query()`](sql/SQL-209-provider-query-provider-get-provider-location-addresses.md) --- ## PROVIDER_IDENTITY | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ProviderQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ProviderQueryProvider` | ### Operations referencing PROVIDER_IDENTITY - [Provider queries](operations/provider-queries.md) ### Business rules referencing PROVIDER_IDENTITY - [SD-BR-080 Provider identity relationship and address code sets](business-rules.md#sd-br-080-provider-identity-relationship-and-address-code-sets) - [SD-BR-082 Dismissed bills excluded from provider location ids](business-rules.md#sd-br-082-dismissed-bills-excluded-from-provider-location-ids) - [SD-BR-083 Provider in MCO only within date window](business-rules.md#sd-br-083-provider-in-mco-only-within-date-window) ### SQL referencing PROVIDER_IDENTITY - [SQL-211: `GetRepository().Query()`](sql/SQL-211-provider-query-provider-get-provider-identities-by-npi.md) --- ## PROVIDER_LOCATION | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider`, `ProviderQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped PROVIDER_LOCATION_SEQ; no insert in this library) | | **Related tables** | PROVIDER, ATTENDING_PHYSICIAN, CBP_BILL, CL_CLAIM_LEGAL_REPRESENTATIVE, EBILL_PROVIDER, PROVIDER_ADDRESS, PROVIDER_RELATIONSHIP | | **Business objects** | `ClaimQueryProvider`, `ProviderQueryProvider` | ### Operations referencing PROVIDER_LOCATION - [Attending physician resolution](operations/attending-physician-resolution.md) - [E-bill processing queries](operations/e-bill-processing-queries.md) - [Provider queries](operations/provider-queries.md) - [Other query providers](operations/other-query-providers.md) ### Business rules referencing PROVIDER_LOCATION - [SD-BR-040 Physician without facility is invalid](business-rules.md#sd-br-040-physician-without-facility-is-invalid) - [SD-BR-080 Provider identity relationship and address code sets](business-rules.md#sd-br-080-provider-identity-relationship-and-address-code-sets) - [SD-BR-082 Dismissed bills excluded from provider location ids](business-rules.md#sd-br-082-dismissed-bills-excluded-from-provider-location-ids) - [SD-BR-083 Provider in MCO only within date window](business-rules.md#sd-br-083-provider-in-mco-only-within-date-window) - [SD-BR-093 Active report record has a null expiration date](business-rules.md#sd-br-093-active-report-record-has-a-null-expiration-date) ### SQL referencing PROVIDER_LOCATION - [SQL-057: `GetRepository().Query()`](sql/SQL-057-claim-query-provider-get-attending-physician.md) - [SQL-205: `GetRepository().Query()`](sql/SQL-205-provider-query-provider-get-location.md) - [SQL-206: `GetRepository().Query()`](sql/SQL-206-provider-query-provider-get-provider-addresses.md) - [SQL-207: `GetRepository().Query()`](sql/SQL-207-provider-query-provider-get-provider-addresses.md) --- ## PROVIDER_RELATIONSHIP | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ProviderQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | PROVIDER_LOCATION | | **Business objects** | `ProviderQueryProvider` | ### Operations referencing PROVIDER_RELATIONSHIP - [Provider queries](operations/provider-queries.md) ### Business rules referencing PROVIDER_RELATIONSHIP - [SD-BR-080 Provider identity relationship and address code sets](business-rules.md#sd-br-080-provider-identity-relationship-and-address-code-sets) - [SD-BR-082 Dismissed bills excluded from provider location ids](business-rules.md#sd-br-082-dismissed-bills-excluded-from-provider-location-ids) - [SD-BR-083 Provider in MCO only within date window](business-rules.md#sd-br-083-provider-in-mco-only-within-date-window) ### SQL referencing PROVIDER_RELATIONSHIP - [SQL-212: `GetRepository().Query()`](sql/SQL-212-provider-query-provider-get-working-provider-relationships-by-parent-location.md) - [SQL-213: `GetRepository().Query()`](sql/SQL-213-provider-query-provider-get-expired-relationships-on-or-after-date.md) - [SQL-214: `GetRepository().Query()`](sql/SQL-214-provider-query-provider-get-active-working-relationships-for-provider.md) - [SQL-217: `GetRepository().Query()`](sql/SQL-217-provider-query-provider-has-active-relationship.md) --- ## PROVIDER_TAX_ID | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ProviderQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ProviderQueryProvider` | ### Operations referencing PROVIDER_TAX_ID - [Provider queries](operations/provider-queries.md) ### Business rules referencing PROVIDER_TAX_ID - [SD-BR-080 Provider identity relationship and address code sets](business-rules.md#sd-br-080-provider-identity-relationship-and-address-code-sets) - [SD-BR-082 Dismissed bills excluded from provider location ids](business-rules.md#sd-br-082-dismissed-bills-excluded-from-provider-location-ids) - [SD-BR-083 Provider in MCO only within date window](business-rules.md#sd-br-083-provider-in-mco-only-within-date-window) ### SQL referencing PROVIDER_TAX_ID - [SQL-203: `GetRepository().Query()`](sql/SQL-203-provider-query-provider-get-provider-by-tax-id.md) --- ## RTW_CASE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimQueryProvider` | ### Operations referencing RTW_CASE - [Claim status and compensability](operations/claim-status-and-compensability.md) ### SQL referencing RTW_CASE - [SQL-070: `GetRepository().Query()`](sql/SQL-070-claim-query-provider-get-rtw-case.md) --- ## SUBPOENA | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `LegalQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped SUBPOENA_SEQ; no insert in this library) | | **Related tables** | LEGAL_CASE | | **Business objects** | `LegalQueryProvider` | ### Operations referencing SUBPOENA - [Legal case queries](operations/legal-case-queries.md) ### Business rules referencing SUBPOENA - [SD-BR-060 Case-to-claim resolution precedence](business-rules.md#sd-br-060-case-to-claim-resolution-precedence) - [SD-BR-061 Preferred employee name takes precedence](business-rules.md#sd-br-061-preferred-employee-name-takes-precedence) ### SQL referencing SUBPOENA - [SQL-157: `GetRepository().Query()`](sql/SQL-157-legal-query-provider-get-subpoenas.md) --- ## TASK | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `TaskQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped TASK_SEQ; no insert in this library) | | **Related tables** | None identified | | **Business objects** | `TaskQueryProvider` | ### Operations referencing TASK - [Other query providers](operations/other-query-providers.md) ### Business rules referencing TASK - [SD-BR-091 Task codes compared case-insensitively](business-rules.md#sd-br-091-task-codes-compared-case-insensitively) ### SQL referencing TASK - [SQL-235: `GetRepository().Query()`](sql/SQL-235-task-query-provider-get-task.md) - [SQL-236: `GetRepository().Query()`](sql/SQL-236-task-query-provider-get-tasks-for-user.md) --- ## TASK_ACTION_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `TaskExtensions`, `TaskQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `TaskExtensions`, `TaskQueryProvider` | ### Operations referencing TASK_ACTION_CODE - [Other query providers](operations/other-query-providers.md) ### Business rules referencing TASK_ACTION_CODE - [SD-BR-091 Task codes compared case-insensitively](business-rules.md#sd-br-091-task-codes-compared-case-insensitively) ### SQL referencing TASK_ACTION_CODE - [SQL-232: `GetRepository().Query()`](sql/SQL-232-task-query-provider-get-action.md) - [SQL-303: `GetRepository().Query()`](sql/SQL-303-task-extensions-seed-for-task-testing.md) - [SQL-306: `GetRepository().Query()`](sql/SQL-306-task-extensions-fill-task-category.md) --- ## TASK_CATEGORY_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `TaskExtensions`, `TaskQueryProvider` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `TaskExtensions`, `TaskQueryProvider` | ### Operations referencing TASK_CATEGORY_CODE - [Other query providers](operations/other-query-providers.md) ### Business rules referencing TASK_CATEGORY_CODE - [SD-BR-091 Task codes compared case-insensitively](business-rules.md#sd-br-091-task-codes-compared-case-insensitively) ### SQL referencing TASK_CATEGORY_CODE - [SQL-234: `GetRepository().Query()`](sql/SQL-234-task-query-provider-get-category.md) - [SQL-254: `GetRepository().Add(entity)`](sql/SQL-254-task-extensions-fill-task-category.md) --- ## TASK_PRIORITY_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `TaskExtensions`, `TaskQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `TaskExtensions`, `TaskQueryProvider` | ### Operations referencing TASK_PRIORITY_CODE - [Other query providers](operations/other-query-providers.md) ### Business rules referencing TASK_PRIORITY_CODE - [SD-BR-091 Task codes compared case-insensitively](business-rules.md#sd-br-091-task-codes-compared-case-insensitively) ### SQL referencing TASK_PRIORITY_CODE - [SQL-233: `GetRepository().Query()`](sql/SQL-233-task-query-provider-get-priroity.md) - [SQL-304: `GetRepository().Query()`](sql/SQL-304-task-extensions-seed-for-task-testing.md) - [SQL-305: `GetRepository().Query()`](sql/SQL-305-task-extensions-fill-task-category.md) --- ## TASK_SOURCE_CODE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `TaskExtensions`, `TaskQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `TaskExtensions`, `TaskQueryProvider` | ### Operations referencing TASK_SOURCE_CODE - [Other query providers](operations/other-query-providers.md) ### Business rules referencing TASK_SOURCE_CODE - [SD-BR-091 Task codes compared case-insensitively](business-rules.md#sd-br-091-task-codes-compared-case-insensitively) ### SQL referencing TASK_SOURCE_CODE - [SQL-231: `GetRepository().Query()`](sql/SQL-231-task-query-provider-get-source.md) - [SQL-302: `GetRepository().Query()`](sql/SQL-302-task-extensions-seed-for-task-testing.md) - [SQL-307: `GetRepository().Query()`](sql/SQL-307-task-extensions-fill-task-category.md) --- ## THRDPARTY_CASE | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped THRDPARTY_CASE_SEQ; no insert in this library) | | **Related tables** | None identified | | **Business objects** | `ClaimQueryProvider` | ### Operations referencing THRDPARTY_CASE - [Claim status and compensability](operations/claim-status-and-compensability.md) ### SQL referencing THRDPARTY_CASE - [SQL-069: `GetRepository().Query()`](sql/SQL-069-claim-query-provider-get-third-party-case.md) --- ## VERIFIED_ADDRESS | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `AddressVerificationQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A (mapped VERIFIED_ADDRESS_SEQ; no insert in this library) | | **Related tables** | ADDRESS_VERIFICATION_REQUEST | | **Business objects** | `AddressVerificationQueryProvider` | ### Operations referencing VERIFIED_ADDRESS - [Other query providers](operations/other-query-providers.md) ### SQL referencing VERIFIED_ADDRESS - [SQL-003: `GetRepository().Query()`](sql/SQL-003-address-verification-query-provider-get-verified-address.md) --- ## WCIS_Employee | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | Unknown** | | **Purpose** | Accessed by `EmployeeQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `EmployeeQueryProvider` | ### SQL referencing WCIS_Employee - [SQL-146: `GetRepository().Query()`](sql/SQL-146-employee-query-provider-get-wcis-employee.md) --- ## batch_process_log | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | ### Operations referencing batch_process_log - [Output document queries](operations/output-document-queries.md) ### Business rules referencing batch_process_log - [SD-BR-070 Output document status code set](business-rules.md#sd-br-070-output-document-status-code-set) - [SD-BR-071 Document date defaults from batch process log](business-rules.md#sd-br-071-document-date-defaults-from-batch-process-log) - [SD-BR-075 Child documents only retrievable for a released parent](business-rules.md#sd-br-075-child-documents-only-retrievable-for-a-released-parent) ### SQL referencing batch_process_log - [SQL-183: `GetRepository().Query()`](sql/SQL-183-output-document-query-provider-get-document-date.md) - [SQL-251: `GetRepository().Add(entity)`](sql/SQL-251-policy-output-document-extensions-seed-for-document-testing.md) --- ## cl_pref_contact_method_code | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `WorkerQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `WorkerQueryProvider` | ### Operations referencing cl_pref_contact_method_code - [Other query providers](operations/other-query-providers.md) ### Business rules referencing cl_pref_contact_method_code - [SD-BR-092 Active support order has no termination date](business-rules.md#sd-br-092-active-support-order-has-no-termination-date) ### SQL referencing cl_pref_contact_method_code - [SQL-238: `GetRepository().Query()`](sql/SQL-238-worker-query-provider-get-preferred-contact-method.md) --- ## claim_status_code | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ClaimBuilder`, `ClaimCodeTableBuilder`, `ClaimQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `ClaimBuilder`, `ClaimCodeTableBuilder`, `ClaimQueryProvider` | ### Operations referencing claim_status_code - [Claim status and compensability](operations/claim-status-and-compensability.md) ### Business rules referencing claim_status_code - [SD-BR-041 Latest claim status falls back to WCD status when no history](business-rules.md#sd-br-041-latest-claim-status-falls-back-to-wcd-status-when-no-history) - [SD-BR-042 Compensability status mapping](business-rules.md#sd-br-042-compensability-status-mapping) - [SD-BR-043 Original acceptance requires request type I with decision A](business-rules.md#sd-br-043-original-acceptance-requires-request-type-i-with-decision-a) ### SQL referencing claim_status_code - [SQL-071: `GetRepository().Query()`](sql/SQL-071-claim-query-provider-get-claim-status-code.md) - [SQL-258: `GetRepository().Query()`](sql/SQL-258-claim-builder-claim-status.md) - [SQL-263: `GetRepository().Query()`](sql/SQL-263-claim-code-table-builder-claim-status.md) --- ## document_status_code | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | ### Operations referencing document_status_code - [Output document queries](operations/output-document-queries.md) ### Business rules referencing document_status_code - [SD-BR-070 Output document status code set](business-rules.md#sd-br-070-output-document-status-code-set) - [SD-BR-071 Document date defaults from batch process log](business-rules.md#sd-br-071-document-date-defaults-from-batch-process-log) - [SD-BR-075 Child documents only retrievable for a released parent](business-rules.md#sd-br-075-child-documents-only-retrievable-for-a-released-parent) ### SQL referencing document_status_code - [SQL-181: `GetRepository().Query()`](sql/SQL-181-output-document-query-provider-get-released-status.md) - [SQL-189: `GetRepository().Query()`](sql/SQL-189-output-document-query-provider-document-status-code-query.md) - [SQL-288: `GetRepository().Query()`](sql/SQL-288-policy-output-document-extensions-seed-for-document-testing.md) - [SQL-295: `GetRepository().Query()`](sql/SQL-295-policy-output-document-extensions-get-doc-status.md) --- ## image | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | Unknown** | | **Purpose** | Accessed by `ImageQueryProvider` for R-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | IMAGE_AFFILIATION | | **Business objects** | `ImageQueryProvider` | ### SQL referencing image - [SQL-147: `GetRepository().Query()`](sql/SQL-147-image-query-provider-get-image.md) - [SQL-148: `GetRepository().Query()`](sql/SQL-148-image-query-provider-get-affilliated-images.md) --- ## image_category_code | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyOutputDocumentExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | image_document_type_code | | **Business objects** | `PolicyOutputDocumentExtensions` | ### SQL referencing image_category_code - [SQL-290: `GetRepository().Query()`](sql/SQL-290-policy-output-document-extensions-seed-for-document-testing.md) - [SQL-291: `GetRepository().Query()`](sql/SQL-291-policy-output-document-extensions-seed-for-document-testing.md) --- ## image_document_type_code | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `ImageQueryProvider`, `PolicyOutputDocumentExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | image_category_code, output_doc_notify_text_code, output_document_category_code, output_document_type_code | | **Business objects** | `ImageQueryProvider`, `PolicyOutputDocumentExtensions` | ### SQL referencing image_document_type_code - [SQL-150: `GetRepository().Query()`](sql/SQL-150-image-query-provider-get-image-document-type.md) - [SQL-291: `GetRepository().Query()`](sql/SQL-291-policy-output-document-extensions-seed-for-document-testing.md) - [SQL-293: `GetRepository().Query()`](sql/SQL-293-policy-output-document-extensions-seed-for-document-testing.md) --- ## output_doc_notify_text_code | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyOutputDocumentExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | output_document_type_code | | **Business objects** | `PolicyOutputDocumentExtensions` | ### SQL referencing output_doc_notify_text_code - [SQL-292: `GetRepository().Query()`](sql/SQL-292-policy-output-document-extensions-seed-for-document-testing.md) - [SQL-293: `GetRepository().Query()`](sql/SQL-293-policy-output-document-extensions-seed-for-document-testing.md) --- ## output_document | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `PolicyOutputDocumentExtensions` for C-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | output_document_seq | | **Related tables** | None identified | | **Business objects** | `PolicyOutputDocumentExtensions` | ### SQL referencing output_document - [SQL-252: `GetRepository().Add(entity)`](sql/SQL-252-policy-output-document-extensions-add-document.md) --- ## output_document_category_code | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | ### Operations referencing output_document_category_code - [Output document queries](operations/output-document-queries.md) ### Business rules referencing output_document_category_code - [SD-BR-070 Output document status code set](business-rules.md#sd-br-070-output-document-status-code-set) - [SD-BR-071 Document date defaults from batch process log](business-rules.md#sd-br-071-document-date-defaults-from-batch-process-log) - [SD-BR-075 Child documents only retrievable for a released parent](business-rules.md#sd-br-075-child-documents-only-retrievable-for-a-released-parent) ### SQL referencing output_document_category_code - [SQL-188: `GetRepository().Query()`](sql/SQL-188-output-document-query-provider-get-category-codes.md) - [SQL-289: `GetRepository().Query()`](sql/SQL-289-policy-output-document-extensions-seed-for-document-testing.md) - [SQL-293: `GetRepository().Query()`](sql/SQL-293-policy-output-document-extensions-seed-for-document-testing.md) --- ## output_document_type_code | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | ENDORSE_CODE, image_document_type_code, output_doc_notify_text_code, output_document_category_code | | **Business objects** | `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | ### SQL referencing output_document_type_code - [SQL-187: `GetRepository().Query()`](sql/SQL-187-output-document-query-provider-output-document-type-code-query.md) - [SQL-293: `GetRepository().Query()`](sql/SQL-293-policy-output-document-extensions-seed-for-document-testing.md) - [SQL-294: `GetRepository().Query()`](sql/SQL-294-policy-output-document-extensions-seed-for-document-testing.md) - [SQL-297: `GetRepository().Query()`](sql/SQL-297-policy-output-document-extensions-generate-packet.md) - [SQL-298: `GetRepository().Query()`](sql/SQL-298-policy-output-document-extensions-generate-packet.md) - [SQL-299: `GetRepository().Query()`](sql/SQL-299-policy-output-document-extensions-get-document-type.md) - [SQL-300: `GetRepository().Query()`](sql/SQL-300-policy-output-document-extensions-add-documents.md) - [SQL-301: `GetRepository().Query()`](sql/SQL-301-policy-output-document-extensions-add-agency-viewable-documents.md) --- ## policy_output_document | Field | Value | | --- | --- | | **Database** | Oracle* | | **Schema/Link** | [unqualified]** | | **Purpose** | Accessed by `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` for CR-type operations* | | **Access pattern** | ORM (NHibernate LINQ) | | **CRUD operations** | Create, Read | | **Key columns used** | See individual SQL documents for bound parameters and predicates | | **Sequence** | N/A | | **Related tables** | None identified | | **Business objects** | `OutputDocumentQueryProvider`, `PolicyOutputDocumentExtensions` | ### Operations referencing policy_output_document - [Output document queries](operations/output-document-queries.md) ### Business rules referencing policy_output_document - [SD-BR-070 Output document status code set](business-rules.md#sd-br-070-output-document-status-code-set) - [SD-BR-071 Document date defaults from batch process log](business-rules.md#sd-br-071-document-date-defaults-from-batch-process-log) - [SD-BR-075 Child documents only retrievable for a released parent](business-rules.md#sd-br-075-child-documents-only-retrievable-for-a-released-parent) ### SQL referencing policy_output_document - [SQL-185: `GetRepository().Query()`](sql/SQL-185-output-document-query-provider-get-policy-output-document.md) - [SQL-186: `GetRepository().Query()`](sql/SQL-186-output-document-query-provider-policy-output-document-query.md) - [SQL-253: `GetRepository().Add(entity)`](sql/SQL-253-policy-output-document-extensions-add-document.md) --- ## Table relationship diagram The following diagram shows relationships between tables used by this library, derived from 68 verified ORM mapping join pairs. ```mermaid erDiagram ADDRESS_VERIFICATION_REQUEST ||--o{ LOCATION_VERIFICATION_REQUEST : "one-to-many" Agency ||--o{ Agent : "one-to-many" Agent ||--o{ POLICY : "one-to-many" CASE_STATUS_CODE ||--o{ LEGAL_CASE : "one-to-many" CBP_AUDIT ||--o{ CBP_AUDITED_SERVICE : "one-to-many" CBP_BILL ||--o{ CBP_AUDIT : "one-to-many" CBP_BILL ||--o{ CBP_AUDITED_SERVICE : "one-to-many" CBP_BILL ||--o{ CBP_BILL_STATUS : "one-to-many" CBP_BILL ||--o{ CBP_NOTE : "one-to-many" CBP_BILL ||--o{ EBILL : "one-to-many" CBP_BILL_STATUS_CODE ||--o{ CBP_BILL : "one-to-many" CBP_NOTE_CATEGORY_CODE ||--o{ CBP_NOTE_TYPE_CODE : "one-to-many" CBP_SERVICE_CODE ||--o{ CBP_CPT_SERVICE : "one-to-many" CBP_SERVICE_CODE ||--o{ CBP_SERVICE_DESCRIPTION : "one-to-many" CBP_SERVICE_TYPE_CODE ||--o{ CBP_SERVICE_CODE : "one-to-many" CL_CLAIM_PERSON ||--o{ CL_CLAIM_SUPPORT_ORDER : "one-to-many" CL_CLAIM_PERSON ||--o{ CL_INJURY_CLAIM : "one-to-many" CL_CLAIM_PERSON ||--o{ CL_OVERPAYMENT : "one-to-many" CL_INJURY_CLAIM ||--o{ ATTENDING_PHYSICIAN : "one-to-many" CL_INJURY_CLAIM ||--o{ CL_INCURRED_COST_HISTORY : "one-to-many" CL_INJURY_CLAIM ||--o{ CL_MEDICAL_CONDITION : "one-to-many" CL_INJURY_CLAIM ||--o{ CL_PAYMENT_TOTAL : "one-to-many" CL_INJURY_CLAIM ||--o{ EAIP_PERIOD : "one-to-many" EBILL ||--o{ EBILL_DOCUMENT : "one-to-many" EBILL ||--o{ EBILL_ERROR_CONDITION : "one-to-many" EBILL ||--o{ EBILL_HEALTH_INFORMATION : "one-to-many" EBILL ||--o{ EBILL_SERVICE : "one-to-many" EBILL_BATCH ||--o{ EBILL : "one-to-many" EBILL_BATCH ||--o{ EBILL_ADDRESS : "one-to-many" EBILL_BATCH ||--o{ EBILL_EOB : "one-to-many" EBILL_BATCH ||--o{ EBILL_PROVIDER : "one-to-many" EBILL_BATCH_STATUS_CODE ||--o{ EBILL_BATCH : "one-to-many" EBILL_BATCH_TYPE_CODE ||--o{ EBILL_BATCH : "one-to-many" EBILL_CLEARINGHOUSE ||--o{ EBILL_BATCH : "one-to-many" EBILL_EOB ||--o{ EBILL : "one-to-many" EBILL_HEALTH_INFO_TYPE_CODE ||--o{ EBILL_HEALTH_INFORMATION : "one-to-many" EBILL_INVOICE ||--o{ EBILL_INVOICE_BILL : "one-to-many" EBILL_INVOICE ||--o{ EBILL_INVOICE_ERROR : "one-to-many" EBILL_PATIENT ||--o{ EBILL : "one-to-many" EBILL_PATIENT ||--o{ EBILL_ERROR_CONDITION : "one-to-many" EBILL_PROVIDER ||--o{ EBILL_ERROR_CONDITION : "one-to-many" EBILL_PROVIDER ||--o{ EBILL_PATIENT : "one-to-many" EBILL_SET_TYPE_CODE ||--o{ EBILL_DOCUMENT_TYPE_CODE : "one-to-many" EBILL_STATUS_CODE ||--o{ EBILL : "one-to-many" EDI_BILL_REPORT ||--o{ EDI_BILL : "one-to-many" LEGAL_CASE ||--o{ APPEAL : "one-to-many" LEGAL_CASE ||--o{ CASE_COST : "one-to-many" LEGAL_CASE ||--o{ CONSOLIDATED_CASE : "one-to-many" LEGAL_CASE ||--o{ LEGAL_BILL : "one-to-many" LEGAL_CASE ||--o{ SUBPOENA : "one-to-many" LEGAL_PERSON_ADDRESS ||--o{ LEGAL_PERSON : "one-to-many" OFFICE_CODE ||--o{ POLICY : "one-to-many" PAYMENT_TRANSACTION_TYPE_CODE ||--o{ PAYMENT_TRANSACTION_STAT : "one-to-many" POLICY ||--o{ POLICY_PERIOD_GROUP_ASSOC : "one-to-many" PROVIDER ||--o{ PROVIDER_LOCATION : "one-to-many" PROVIDER_LOCATION ||--o{ ATTENDING_PHYSICIAN : "one-to-many" PROVIDER_LOCATION ||--o{ CBP_BILL : "one-to-many" PROVIDER_LOCATION ||--o{ CL_CLAIM_LEGAL_REPRESENTATIVE : "one-to-many" PROVIDER_LOCATION ||--o{ EBILL_PROVIDER : "one-to-many" PROVIDER_LOCATION ||--o{ PROVIDER_ADDRESS : "one-to-many" PROVIDER_LOCATION ||--o{ PROVIDER_RELATIONSHIP : "one-to-many" VERIFIED_ADDRESS ||--o{ ADDRESS_VERIFICATION_REQUEST : "one-to-many" image ||--o{ IMAGE_AFFILIATION : "one-to-many" image_category_code ||--o{ image_document_type_code : "one-to-many" image_category_code ||--o{ output_document_type_code : "one-to-many" image_document_type_code ||--o{ output_document_type_code : "one-to-many" output_doc_notify_text_code ||--o{ output_document_type_code : "one-to-many" output_document_category_code ||--o{ output_document_type_code : "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/**`