SQL-133: Retrieve CbpServiceCode via ValidCptCode¶

This ORM statement performs a read operation on CbpServiceCode via IUnitOfWork.GetRepository<T>(), executed from Services/SAIF.Services/Claims/Bills/AuthorizationService.cs (L75).

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`code`	Input	**	N/A	`x.Code == code` → column **
`"M"`	Input	**	N/A	`x.ServiceType.Code == "M"` → column **

Tables¶

Table	Access	Columns used
CBP_SERVICE_CODE	SELECT	`CODE`, `BILL_SERVICE_TYPE_CODE`, `UPDATE_NUM`, `EFF_DATE`, `EXP_DATE`, `RP_1099_REQ_FLAG`, `UPDATE_USER`, `UPDATE_DATE`, `NURSE_REVIEW_REQUIRED_FLAG`, `DCBS_REPORT_SERVICE_CODE`

LINQ statement¶

Source: Services/SAIF.Services/Claims/Bills/AuthorizationService.cs:75

// Services/SAIF.Services/Claims/Bills/AuthorizationService.cs:75
                unitOfWork.GetRepository<CbpServiceCode>().Query().Single(x => x.Code == code && x.ServiceType.Code == "M");

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
-- Services/SAIF.Services/Claims/Bills/AuthorizationService.cs:75
SELECT
  CSC.CODE,
  CSC.BILL_SERVICE_TYPE_CODE,
  CSC.UPDATE_NUM,
  CSC.EFF_DATE,
  CSC.EXP_DATE,
  CSC.RP_1099_REQ_FLAG,
  CSC.UPDATE_USER,
  CSC.UPDATE_DATE,
  CSC.NURSE_REVIEW_REQUIRED_FLAG,
  CSC.DCBS_REPORT_SERVICE_CODE
FROM CBP_SERVICE_CODE CSC
WHERE CSC.CODE = :code
  AND CSC.BILL_SERVICE_TYPE_CODE = 'M'
-- NHibernate expects at most one row

Operations and processes¶

AuthorizationService.ValidCptCode — see Operations and processes

Business rules¶

SVC-BR-BIL-140 Valid CPT = a CbpServiceCode with ServiceType 'M'

Sources¶

Services/SAIF.Services/Claims/Bills/AuthorizationService.cs (L75)