SAIF.Business.View.Policy SQL catalog¶
This page indexes all SQL statements and stored procedure calls in SAIF.Business.View.Policy,
grouped by CRUD type. This library is exclusively read-only — every Criteria.CreateSQL /
InsertSQL / UpdateSQL / DeleteSQL implementation returns empty or throws.
Read operations¶
| SQL ID | Description | Type | Tables | Business object | Notes |
|---|---|---|---|---|---|
| SQL-VP-001 | Retrieve agency/agent record for a policy | Stored Proc | not directly visible (Oracle package) | clsAgency |
— |
| SQL-VP-002 | Retrieve MCO assignments for a policy (MCO collection) | Stored Proc | not directly visible (Oracle package) | clsMCOCollection |
— |
| SQL-VP-003 | Retrieve MCO assignments for a policy (duplicate call) | Stored Proc | not directly visible (Oracle package) | clsPolicyMCOCollection |
— |
| SQL-VP-004 | Retrieve affiliated-policy list for a policy | Stored Proc | not directly visible (Oracle package) | clsAffiliatedPolicyCollection |
— |
| SQL-VP-005 | Retrieve policy address by type/contact type | Stored Proc | not directly visible (Oracle package) | clsPolicyAddress |
— |
| SQL-VP-006 | Retrieve policy address by location sequence number | Stored Proc | not directly visible (Oracle package) | clsPolicyAddress |
— |
| SQL-VP-007 | Retrieve Officer of Notice contact for a policy | Inline | BUSINESS_AFFILIATE, AFFILIATE | clsPolicyAddress |
— |
| SQL-VP-008 | Retrieve the main policy header record | Stored Proc | not directly visible (Oracle package) | clsPolicyData |
— |
| SQL-VP-009 | Retrieve coverage gaps for a policy | Stored Proc | not directly visible (Oracle package) | clsPolicyData |
— |
| SQL-VP-010 | Retrieve waiver count for a policy | Stored Proc | not directly visible (Oracle package) | clsPolicyData |
— |
| SQL-VP-011 | Retrieve additional policy view detail | Stored Proc | not directly visible (Oracle package) | clsPolicyData |
— |
| SQL-VP-012 | Retrieve the most recent audit date for a policy | Inline | PA_AUDIT | clsPolicyData |
— |
| SQL-VP-013 | Retrieve a future cancellation date for a policy | Inline | CANCELLATION | clsPolicyData |
— |
| SQL-VP-014 | Retrieve a policy's secondary cancel status | Inline (scalar function) | DUAL | clsPolicyData |
— |
| SQL-VP-015 | Retrieve whether coverage is bound for a policy period | Inline (scalar function) | DUAL | clsPolicyData |
— |
| SQL-VP-016 | Retrieve whether the information page has been printed | Stored Proc | not directly visible (Oracle procedure) | clsPolicyData |
— |
| SQL-VP-017 | Retrieve a policy's parent policy number | Stored Proc | not directly visible (Oracle package) | clsPolicyData |
Obsolete |
| SQL-VP-018 | Retrieve a policy's affiliate type | Stored Proc | not directly visible (Oracle package) | clsPolicyData |
Obsolete |
| SQL-VP-019 | Retrieve the wrapup legal name for a policy | Stored Proc | not directly visible (Oracle package) | clsPolicyData |
— |
| SQL-VP-021 | Retrieve employer-liability coverage limits for a period | Stored Proc | not directly visible (Oracle package) | clsPolicyPeriod |
— |
| SQL-VP-022 | Retrieve policy periods for a policy | Stored Proc | not directly visible (Oracle package) | clsPolicyPeriodCollection |
— |
| SQL-VP-023 | Retrieve trading-as names for a policy | Inline | TRADING_AS | clsTradingAsCollection |
— |
| SQL-VP-024 | Retrieve team-assignment roster for a policy | Stored Proc | not directly visible (Oracle package) | clsTeamAssignmentCollection |
— |
| SQL-VP-025 | Look up external client email address (SQL Server) | Stored Proc | not directly visible (SQL Server procedure) | clsTeamAssignment |
— |
| SQL-VP-026 | Look up external client email address by system user (Oracle) | Stored Proc | not directly visible (Oracle procedure) | clsTeamAssignment |
— |
| SQL-VP-027 | Retrieve all policy-association type codes | Inline | ASSOCIATION_TYPE_CODE | clsAssociationTypeCode / clsAssociationTypeCodeCollection |
— |
| SQL-VP-028 | Retrieve period dates for a set of policy numbers | Inline | POLICY_PERIOD_ALL, ENDORSEMENT, POLICY_PERIOD_NON_WCIS | clsAssociationTypeCode |
— |
| SQL-VP-029 | Retrieve non-typed associations via a dynamically named procedure | Stored Proc (dynamic name) | not directly visible (Oracle procedure) | clsAssociationTypeCode |
— |
| SQL-VP-030 | Retrieve PMS-era payroll classification detail | Inline | PPNW_CLASS_COVERAGE_DETAIL, MANUAL_CLASS_DESCRIPTION, POLICY_PERIOD_NON_WCIS | clsPayrollClassInfoCollection |
— |
| SQL-VP-031 | Retrieve WCIS-era payroll classification detail | Inline | PREM_HIST_CLASS_COVERAGE, MANUAL_CLASS_DESCRIPTION, PREM_HIST_ADJ_RATE_CLASS, POLICY_PERIOD, LOCATION, FEDERAL_MINIMUM_WAGE | clsPayrollClassInfoCollection |
— |
| SQL-VP-032 | Retrieve a non-employer account by account number | Inline | NON_EMPR_ACCT | clsNonEmployerAccount |
— |
| SQL-VP-033 | Check whether a policy belongs to a group/chapter (SQL Server) | Stored Proc | not directly visible (SQL Server procedure) | clsPolicySecurity |
— |
| SQL-VP-034 | Retrieve the group user's book of business (SQL Server) | Stored Proc | not directly visible (SQL Server procedure) | clsPolicySecurity |
— |
| SQL-VP-035 | Retrieve the loss-control consultant's book of business (SQL Server) | Stored Proc | not directly visible (SQL Server procedure) | clsPolicySecurity |
— |
| SQL-VP-036 | Retrieve an agent's online policy list (SQL Server) | Stored Proc | not directly visible (SQL Server procedure) | clsPolicySecurity |
— |
| SQL-VP-037 | Check whether a vendor auditor may access a policy | Inline | PA_AUDIT, PA_AUDITOR, PA_POLICY_PERIOD | clsPolicySecurity |
— |
| SQL-VP-038 | Retrieve the fee auditor's accessible policy list | Inline | PA_AUDIT, PA_AUDITOR, POLICY | clsPolicySecurity |
— |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Database tables
- Security and authorization
- API reference
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¶
SAIF.Business.View.Policy\clsAgency.vbSAIF.Business.View.Policy\clsMCOCollection.vbSAIF.Business.View.Policy\clsPolicyMCOCollection.vbSAIF.Business.View.Policy\clsAffiliatedPolicyCollection.vbSAIF.Business.View.Policy\clsPolicyAddress.vbSAIF.Business.View.Policy\clsPolicyData.vbSAIF.Business.View.Policy\clsPolicyPeriod.vbSAIF.Business.View.Policy\clsPolicyPeriodCollection.vbSAIF.Business.View.Policy\clsTradingAsCollection.vbSAIF.Business.View.Policy\clsTeamAssignmentCollection.vbSAIF.Business.View.Policy\clsTeamAssignment.vbSAIF.Business.View.Policy\Associations\clsAssociationTypeCode.vbSAIF.Business.View.Policy\clsPayrollClassInfo.vbSAIF.Business.View.Policy\clsPayrollClassInfoCollection.vbSAIF.Business.View.Policy\clsNonEmployerAccount.vbSAIF.Business.View.Policy\clsPolicySecurity.vb