---
title: "SQL-011: EOB MCO remittance advice insert (EbillEobRemittanceAdvice)"
summary: Builds the MCO-fee remittance-advice row for an EOB and adds it to the repository.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-09-24
library: SAIF.Domain
reference_type: package
---

# SQL-011: EOB MCO remittance advice insert (EbillEobRemittanceAdvice)

`EobBuilder.CreateMcoFeeRemittenceAdvice` builds the MCO-fee remittance-advice row for an EOB, grouped by service and RARC, and adds it to the repository.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-011 |
| **Operation type** | Create |
| **Execution method** | ORM (IRepository.Add) |
| **Database** | Oracle* |
| **Schema** | [unqualified]** |
| **Command type** | N/A — ORM (NHibernate generates SQL at runtime from the ClassMaps in `Data/SAIF.Data.NHibernate/Mappings/**`) |
| **Business object** | `EobBuilder` |
| **Criteria property** | N/A — ORM |
| **Lifecycle method** | `CreateMcoFeeRemittenceAdvice` |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [EBILL_EOB_REMITTANCE_ADVICE](../database-tables.md#ebill_eob_remittance_advice) | INSERT | `EBILL_EOB_REMIT_ADVICE_SEQ_NUM`, `EDI_REMITTANCE_ADVICE_CODE`, `EBILL_SEQ_NUM`, `AUDIT_SEQ_NUM`, `BILL_ID` |

## LINQ statement

Source: `Domain/SAIF.Domain/Claims/Ebilling/EobBuilder.cs:253`

```csharp
// Domain/SAIF.Domain/Claims/Ebilling/EobBuilder.cs:244-255
foreach (var auditService in auditedMcoServices)
{
    var advice = new EbillEobRemittanceAdvice()
    {
        Ebill = ebill,
        AuditedService = auditService,
        RemittanceAdviceCode = queryProvider.GetClearinghouse().McoRemittanceAdviceCode
    };

    factory.GetRepository<EbillEobRemittanceAdvice>().Add(advice);
    results.PaymentAdviceInserted++;
}
```

## Sample SQL

> **Inferred SQL:** This SQL was inferred from the LINQ statement above and the NHibernate mappings. It is not concrete SQL from source code; NHibernate generates the executed statement at runtime, so aliases, column order, join syntax, and bind-parameter names may differ.

```sql
-- Inferred from LINQ (NHibernate mapping translation); not concrete SQL
SELECT EBILL_EOB_REMIT_ADVICE_SEQ.NEXTVAL
FROM DUAL

INSERT INTO EBILL_EOB_REMITTANCE_ADVICE (
  EBILL_EOB_REMIT_ADVICE_SEQ_NUM,
  EDI_REMITTANCE_ADVICE_CODE,
  EBILL_SEQ_NUM,
  AUDIT_SEQ_NUM,
  BILL_ID)
VALUES (
  :Id,
  :RemittanceAdviceCode,
  :Ebill,
  :AuditedServiceId,
  :AuditedServiceAudit)
```

Translation notes:
- `:Id` is the value fetched from `EBILL_EOB_REMIT_ADVICE_SEQ` (`GeneratedBy.Native("EBILL_EOB_REMIT_ADVICE_SEQ")` on Oracle).
- No version column mapped.
- `:AuditedServiceId` / `:AuditedServiceAudit` → `AUDIT_SEQ_NUM` / `BILL_ID` (`CbpAuditedServiceMap.cs:17-19`).
- Executed once per element of `auditedMcoServices` (loop at line 244).

## Operations and processes
- OP-DOM-12 EobBuilder.GenerateEobs — builds the adjustments and remittance advices and inserts them (see [Operations and processes](../operations-processes.md))

## Business rules
- [DOM-BR-120](../business-rules.md#dom-br-120-eob-generation)
- [DOM-BR-121](../business-rules.md#dom-br-121-eob-generation)
- [DOM-BR-122](../business-rules.md#dom-br-122-eob-generation)
- [DOM-BR-123](../business-rules.md#dom-br-123-eob-generation)
- [DOM-BR-124](../business-rules.md#dom-br-124-eob-generation)
- [DOM-BR-125](../business-rules.md#dom-br-125-eob-generation)
- [DOM-BR-126](../business-rules.md#dom-br-126-eob-regenerate)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources
- Domain/SAIF.Domain/Claims/Ebilling/EobBuilder.cs