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	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

// 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.

-- 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)

Business rules

• DOM-BR-120
• DOM-BR-121
• DOM-BR-122
• DOM-BR-123
• DOM-BR-124
• DOM-BR-125
• DOM-BR-126

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