---
title: "SQL-255: Retrieve PharmacyDispenseAsWrittenCode"
summary: Read operation against PharmacyDispenseAsWrittenCode via NHibernate ORM.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-09-24
library: SAIF.Services
reference_type: package
---

# SQL-255: Retrieve PharmacyDispenseAsWrittenCode

`BillServiceService.CreateService` and `UpdateService` look up a single `PharmacyDispenseAsWrittenCode` row by its code, using a LINQ query over an NHibernate-backed repository. NHibernate translates this expression into the row-limited `SELECT` shown below at execution time.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-255 |
| **Operation type** | Read |
| **Execution method** | ORM (NHibernate LINQ) |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | N/A (ORM-generated) |
| **Business object** | `BillServiceService` |
| **Criteria property** | N/A — ORM |
| **Lifecycle method** | `CreateService`, `UpdateService` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:PharmacyDispenseAsWrittenCode` | Input | string | N/A | `newService.PharmacyDispenseAsWrittenCode` (CreateService) / `updatedServiceLine.PharmacyDispenseAsWrittenCode` (UpdateService) — the DAW code to look up |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CL_PHARMACY_DAW_CODE](../database-tables.md#cl_pharmacy_daw_code) | SELECT | `CODE`, `UPDATE_NUM`, `CODE_DESCR`, `UPDATE_DATE`, `UPDATE_USER` |

## LINQ statement

Source: `Services/SAIF.Services/Claims/Bills/BillServiceService.cs:59`

```csharp
// Services/SAIF.Services/Claims/Bills/BillServiceService.cs:59
newServiceLine.PharmacyDispenseAsWrittenCode = unitOfWork.GetRepository<PharmacyDispenseAsWrittenCode>().Query().FirstOrDefault(x => x.Code == newService.PharmacyDispenseAsWrittenCode);

// Services/SAIF.Services/Claims/Bills/BillServiceService.cs:126-127
dataServiceLine.PharmacyDispenseAsWrittenCode = updatedServiceLine.PharmacyDispenseAsWrittenCode.IsNull() ? null : unitOfWork.GetRepository<PharmacyDispenseAsWrittenCode>()
    .Query().FirstOrDefault(x => x.Code == updatedServiceLine.PharmacyDispenseAsWrittenCode);
```

## 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 *
FROM (
  SELECT
  CPDC.CODE,
  CPDC.UPDATE_NUM,
  CPDC.CODE_DESCR,
  CPDC.UPDATE_DATE,
  CPDC.UPDATE_USER
  FROM CL_PHARMACY_DAW_CODE CPDC
  WHERE CPDC.CODE = :PharmacyDispenseAsWrittenCode
)
WHERE ROWNUM <= 1
```

Translation notes:
- Both call sites have the same shape; L126 only runs when the incoming code is not null (ternary in C#, not a SQL predicate).

## Operations and processes
- BillServiceService.CreateService — see [Operations and processes](../operations-processes.md)
- BillServiceService.UpdateService — see [Operations and processes](../operations-processes.md)

## Business rules
- [SVC-BR-BIL-120 ProviderServiceCode NotNull, length 1-11 - 'Error - Invalid Primary service code, value is too long.'](../business-rules.md#svc-br-bil-120-providerservicecode-notnull%2C-length-1-11---'error---invalid-primary-service-code%2C-value-is-too-long.')
- [SVC-BR-BIL-121 SecondaryProvServiceCode ≤11 - 'Error - Invalid Secondary service code, value is too long.'](../business-rules.md#svc-br-bil-121-secondaryprovservicecode-%E2%89%A411---'error---invalid-secondary-service-code%2C-value-is-too-long.')
- [SVC-BR-BIL-122 DiagnosisPointerCode1-4 ≤1 char - 'Error - Invalid Diagnosis Pointer Code.'](../business-rules.md#svc-br-bil-122-diagnosispointercode1-4-%E2%89%A41-char---'error---invalid-diagnosis-pointer-code.')
- [SVC-BR-BIL-123 Pointers unique - 'Error - Diagnosis Pointers must be unique.'](../business-rules.md#svc-br-bil-123-pointers-unique---'error---diagnosis-pointers-must-be-unique.')
- [SVC-BR-BIL-124](../business-rules.md#svc-br-bil-124-servicedate-%E2%89%A4-today%2B30%3A-%22error%3A-service-date-must-be-no-more-than-30-days-in-the-future.%22)
- [SVC-BR-BIL-125 EndDate ≥ ServiceDate - 'Error - Service End date must be a valid date.'](../business-rules.md#svc-br-bil-125-enddate-%E2%89%A5-servicedate---'error---service-end-date-must-be-a-valid-date.')
- [SVC-BR-BIL-126 PrescriptionWrittenDate > MinValue - 'Error - Prescription Written date must be a valid date.'](../business-rules.md#svc-br-bil-126-prescriptionwrittendate-%3E-minvalue---'error---prescription-written-date-must-be-a-valid-date.')
- [SVC-BR-BIL-127 Modifiers 1-4 ≤2 - 'Error - Modifiers can only be up to two characters.'](../business-rules.md#svc-br-bil-127-modifiers-1-4-%E2%89%A42---'error---modifiers-can-only-be-up-to-two-characters.')
- [SVC-BR-BIL-128 ServiceLocationCode ≤2 - 'Error - Service location code must be 2 digits long.'](../business-rules.md#svc-br-bil-128-servicelocationcode-%E2%89%A42---'error---service-location-code-must-be-2-digits-long.')
- [SVC-BR-BIL-129 Quantity ≥0 - 'Error - Service quantity can not be negative.'](../business-rules.md#svc-br-bil-129-quantity-%E2%89%A50---'error---service-quantity-can-not-be-negative.')
- [SVC-BR-BIL-130 ToothNumber 0-32 - 'Error - Invalid tooth number.'](../business-rules.md#svc-br-bil-130-toothnumber-0-32---'error---invalid-tooth-number.')
- [SVC-BR-BIL-131 DaysSupply 0-99999 - 'Error - Days supply quantity must be a number.'](../business-rules.md#svc-br-bil-131-dayssupply-0-99999---'error---days-supply-quantity-must-be-a-number.')
- [SVC-BR-BIL-132 DAW length 1 - 'Error - Invalid DAW, can only be 1 character long.'](../business-rules.md#svc-br-bil-132-daw-length-1---'error---invalid-daw%2C-can-only-be-1-character-long.')
- [SVC-BR-BIL-133 PrescribingProviderId ≤10 - 'Error - Invalid Prescriber ID, can only be up to 10 characters.'](../business-rules.md#svc-br-bil-133-prescribingproviderid-%E2%89%A410---'error---invalid-prescriber-id%2C-can-only-be-up-to-10-characters.')

## Sources
- `Services/SAIF.Services/Claims/Bills/BillServiceService.cs (L59, L126)`