Skip to content

SQL-125: EbillQueryProvider.GetIndexedBills

This statement is a read operation invoked through ORM (NHibernate LINQ). Executed by EbillQueryProvider.GetIndexedBills.

Classification

Field Value
SQL ID SQL-125
Operation type Read
Execution method ORM (NHibernate LINQ)
Database Oracle*
Schema [unqualified]**
Command type N/A (ORM-generated)
Business object EbillQueryProvider
Criteria property N/A — ORM
Lifecycle method GetIndexedBills

Parameters

Parameter Direction Type Max length Description
batchId Input long N/A Method argument of EbillQueryProvider.GetIndexedBills bound into the ORM expression; NHibernate generates the bind variable at runtime

Tables

Table Access Columns used
EBILL SELECT EBILL_SEQ_NUM, EBILL_PATIENT_SEQ_NUM, EBILL_STATUS_CODE
EBILL_PATIENT JOIN EBILL_PATIENT_SEQ_NUM, EBILL_PROVIDER_SEQ_NUM
EBILL_PROVIDER JOIN EBILL_PROVIDER_SEQ_NUM, EBILL_BATCH_SEQ_NUM

LINQ statement

Source: Data/SAIF.Data/Queries/Claims/Ebilling/EbillQueryProvider.cs:140. The repository is obtained at Data/SAIF.Data/Queries/Claims/Ebilling/EbillQueryProvider.cs:29.

// Data/SAIF.Data/Queries/Claims/Ebilling/EbillQueryProvider.cs:29
billRepository = Factory.GetRepository<Ebill>().Query();

// Data/SAIF.Data/Queries/Claims/Ebilling/EbillQueryProvider.cs:140
return billRepository
    .Where(b => b.Patient.Provider.Batch.Id == batchId &&
                b.Status.Code == "INDEX")
    .Select(x => x.Id)
    .ToList();

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
  E.EBILL_SEQ_NUM
FROM EBILL E
  INNER JOIN EBILL_PATIENT EP
    ON EP.EBILL_PATIENT_SEQ_NUM = E.EBILL_PATIENT_SEQ_NUM
  INNER JOIN EBILL_PROVIDER EP2
    ON EP2.EBILL_PROVIDER_SEQ_NUM = EP.EBILL_PROVIDER_SEQ_NUM
WHERE EP2.EBILL_BATCH_SEQ_NUM = :batchId
  AND E.EBILL_STATUS_CODE = 'INDEX'

Translation notes:

  • b.Patient.Provider is a non-identifier property of EbillPatient, so EBILL_PATIENT is joined. .Batch is a non-identifier property of EbillProvider, so EBILL_PROVIDER is joined (alias EP2).
  • Select(x => x.Id) is a projection, so only E.EBILL_SEQ_NUM is selected.

Operations and processes

Business rules

Sources

  • Data/SAIF.Data/Queries/Claims/Ebilling/EbillQueryProvider.cs:140