Skip to content

SAIF.Business.View.Policy SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.

Read operations

SQL ID Description Type Tables Business object
SQL-001 Retrieve affiliated policies by affiliate type Stored Proc N/A — stored procedure clsAffiliatedPolicyCollection
SQL-002 Retrieve agency for a policy Stored Proc N/A — stored procedure clsAgency
SQL-003 Retrieve latest issued policy period dates Inline POLICY_PERIOD_ALL, ENDORSEMENT, POLICY_PERIOD_NON_WCIS clsAssociationTypeCode
SQL-004 Retrieve non-typed policy associations Stored Proc N/A — stored procedure clsAssociationTypeCode
SQL-005 Retrieve association type code definitions Inline ASSOCIATION_TYPE_CODE clsAssociationTypeCodeCollection
SQL-006 Retrieve non-employer account by number Inline NON_EMPR_ACCT clsNonEmployerAccount
SQL-007 Retrieve policy address by type Stored Proc N/A — stored procedure clsPolicyAddress
SQL-008 Retrieve policy address by location Stored Proc N/A — stored procedure clsPolicyAddress
SQL-009 Retrieve officer of notice name Inline BUSINESS_AFFILIATE, AFFILIATE clsPolicyAddress
SQL-010 Retrieve core policy data Stored Proc N/A — stored procedure clsPolicyData
SQL-011 Retrieve lazy-loaded policy detail Stored Proc N/A — stored procedure clsPolicyData
SQL-012 Retrieve policy waiver count Stored Proc N/A — stored procedure clsPolicyData
SQL-013 Retrieve parent policy number Stored Proc N/A — stored procedure clsPolicyData
SQL-014 Retrieve policy affiliate type Stored Proc N/A — stored procedure clsPolicyData
SQL-015 Retrieve secondary policy status Inline DUAL clsPolicyData
SQL-016 Retrieve coverage bound flag Inline DUAL clsPolicyData
SQL-017 Retrieve information-page printed flag Stored Proc N/A — stored procedure clsPolicyData
SQL-018 Retrieve policy gaps Stored Proc N/A — stored procedure clsPolicyData
SQL-019 Retrieve last completed final-audit date Inline PA_AUDIT clsPolicyData
SQL-020 Retrieve latest future cancel date Inline CANCELLATION clsPolicyData
SQL-021 Retrieve employer liability limits Stored Proc N/A — stored procedure clsPolicyPeriod
SQL-022 Retrieve policy periods Stored Proc N/A — stored procedure clsPolicyPeriodCollection
SQL-023 Check group access for policy Stored Proc (SQL Server) N/A — stored procedure clsPolicySecurity
SQL-024 Count auditor access matches Inline PA_AUDIT, PA_AUDITOR, PA_POLICY_PERIOD clsPolicySecurity
SQL-025 Retrieve accessible policies for group Stored Proc (SQL Server) N/A — stored procedure clsPolicySecurity
SQL-026 Retrieve accessible policies for safety consultant Stored Proc (SQL Server) N/A — stored procedure clsPolicySecurity
SQL-027 Retrieve accessible policies for agent Stored Proc (SQL Server) N/A — stored procedure clsPolicySecurity
SQL-028 Retrieve accessible policies for fee auditor Inline PA_AUDIT, PA_AUDITOR, POLICY clsPolicySecurity
SQL-029 Retrieve external client email Stored Proc (SQL Server) N/A — stored procedure clsTeamAssignment
SQL-030 Retrieve external email by system user Stored Proc N/A — stored procedure clsTeamAssignment
SQL-031 Retrieve policy service team Stored Proc N/A — stored procedure clsTeamAssignmentCollection
SQL-032 Retrieve trading-as by sequence number Inline TRADING_AS clsTradingAs
SQL-033 Retrieve trading-as by policy number Inline TRADING_AS clsTradingAsCollection
SQL-034 Retrieve policy association list Inline POLICY_RELATIONSHIP, POLICY, COMBO_POLICY_PERIOD, POLICY_PERIOD, ER_COMBINATION_POLICY PolicyAssociationList
SQL-035 Retrieve maximum policy effective date Inline POLICY_PERIOD PolicyAssociationList

Sources

  • SAIF.Business.View.Policy/Associations/clsAssociationTypeCode.vb
  • SAIF.Business.View.Policy/Associations/clsAssociationTypeCodeCollection.vb
  • SAIF.Business.View.Policy/PolicyAssociations.vb
  • SAIF.Business.View.Policy/clsAffiliatedPolicyCollection.vb
  • SAIF.Business.View.Policy/clsAgency.vb
  • SAIF.Business.View.Policy/clsNonEmployerAccount.vb
  • SAIF.Business.View.Policy/clsPolicyAddress.vb
  • SAIF.Business.View.Policy/clsPolicyData.vb
  • SAIF.Business.View.Policy/clsPolicyPeriod.vb
  • SAIF.Business.View.Policy/clsPolicyPeriodCollection.vb
  • SAIF.Business.View.Policy/clsPolicySecurity.vb
  • SAIF.Business.View.Policy/clsTeamAssignment.vb
  • SAIF.Business.View.Policy/clsTeamAssignmentCollection.vb
  • SAIF.Business.View.Policy/clsTradingAs.vb
  • SAIF.Business.View.Policy/clsTradingAsCollection.vb