---
title: "SQL-186: OutputDocumentQueryProvider.PolicyOutputDocumentQuery"
summary: Read operation for `OutputDocumentQueryProvider.PolicyOutputDocumentQuery`
status: draft
owner: SAIF.Core documentation team
last_reviewed: 2026-09-24
library: SAIF.Data
reference_type: package
---

# SQL-186: OutputDocumentQueryProvider.PolicyOutputDocumentQuery

This statement is a read operation invoked through ORM (NHibernate LINQ). Executed by `OutputDocumentQueryProvider.PolicyOutputDocumentQuery`.

## Classification

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


## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [policy_output_document](../database-tables.md#policy_output_document) | SELECT | output_document_seq_num, update_num, policy_period_eff_date, agency_seq_num, agent_num, agency_viewed_flag, agency_delivery_flag, agency_delete_date, create_user, create_date, update_user, update_date, release_date, hold_task_seq_num, task_user, source_key_text, ACCOUNT_NUM, policy_num, document_status_code |

## LINQ statement

Source: `Data/SAIF.Data/Queries/OutputDocuments/OutputDocumentQueryProvider.cs:123`.

```csharp
private IQueryable<PolicyOutputDocument> PolicyOutputDocumentQuery()
{
    return Factory.GetRepository<PolicyOutputDocument>().Query();
}
```

## 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
-- Base query only: callers (e.g. lines 30, 60, 66, 82, 113, 118, 177, 190) compose
-- extension filters (Pending/Held/Released/AgencyViewable/ForPolicyOrAccount/...) on top of it
SELECT
  POD.output_document_seq_num,
  POD.update_num,
  POD.policy_period_eff_date,
  POD.agency_seq_num,
  POD.agent_num,
  POD.agency_viewed_flag,
  POD.agency_delivery_flag,
  POD.agency_delete_date,
  POD.create_user,
  POD.create_date,
  POD.update_user,
  POD.update_date,
  POD.release_date,
  POD.hold_task_seq_num,
  POD.task_user,
  POD.source_key_text,
  POD.ACCOUNT_NUM,
  POD.policy_num,
  POD.document_status_code
FROM policy_output_document POD
```

Translation notes:
- The private helper returns `IQueryable<PolicyOutputDocument>`. On its own it has no WHERE clause, and it never executes as written. Each caller's extension methods append predicates (and possibly joins) before materialization. Those composed statements are not part of this SQL ID.

## Operations and processes

- [Output document queries](../operations/output-document-queries.md)

## Business rules

- [SD-BR-070 Output document status code set](../business-rules.md#sd-br-070-output-document-status-code-set)
- [SD-BR-071 Document date defaults from batch process log](../business-rules.md#sd-br-071-document-date-defaults-from-batch-process-log)
- [SD-BR-075 Child documents only retrievable for a released parent](../business-rules.md#sd-br-075-child-documents-only-retrievable-for-a-released-parent)

## Sources
- `Data/SAIF.Data/Queries/OutputDocuments/OutputDocumentQueryProvider.cs:123`