Skip to content

SAIF.Business.View.Policy SQL catalog

This page indexes every SQL statement and stored procedure call issued by SAIF.Business.View.Policy. All twenty-nine statements are reads: the library implements no create, update, delete, or sequence path (BR-021).

Every statement executes through the SAIF BOF data portal rather than through a directly constructed command object. The first eleven statements, SQL-001 to SQL-011, are the standard RetrieveSQL reads that back one business object each; the remainder, SQL-012 to SQL-029, are additional reads issued by helper members outside the standard criteria pattern.

Read operations

SQL ID Description Type Tables Business object
SQL-001 Retrieve affiliated policies for a policy and affiliate type Stored Proc N/A — stored procedure clsAffiliatedPolicyCollection
SQL-002 Retrieve agency and producer details for a policy Stored Proc N/A — stored procedure clsAgency
SQL-003 Load the association type code table Inline ASSOCIATION_TYPE_CODE clsAssociationTypeCodeCollection
SQL-004 Retrieve a non-employer account by account number Inline NON_EMPR_ACCT clsNonEmployerAccount
SQL-005 Retrieve a policy address by address and contact type Stored Proc N/A — stored procedure clsPolicyAddress
SQL-006 Retrieve a policy address by location sequence number Stored Proc N/A — stored procedure clsPolicyAddress
SQL-007 Retrieve the policy header for a policy number Stored Proc N/A — stored procedure clsPolicyData
SQL-008 Retrieve policy periods, optionally the most recent N Stored Proc N/A — stored procedure clsPolicyPeriodCollection
SQL-009 Retrieve staff team assignments for a policy Stored Proc N/A — stored procedure clsTeamAssignmentCollection
SQL-010 Retrieve a trading-as name by sequence number Inline TRADING_AS clsTradingAs
SQL-011 Retrieve all trading-as names for a policy Inline TRADING_AS clsTradingAsCollection
SQL-012 Retrieve the officer-of-notice name for a policy Inline BUSINESS_AFFILIATE, AFFILIATE clsPolicyAddress
SQL-013 Classify a policy's affiliate type (superseded path) Stored Proc N/A — stored procedure clsPolicyData
SQL-014 Determine whether coverage is bound for a period Inline N/A — stored procedure clsPolicyData
SQL-015 Retrieve the pending future cancellation date Inline CANCELLATION clsPolicyData
SQL-016 Retrieve coverage gap date ranges for a policy Stored Proc N/A — stored procedure clsPolicyData
SQL-017 Check whether the information page has printed Stored Proc N/A — stored procedure clsPolicyData
SQL-018 Retrieve the most recent completed final audit date Inline PA_AUDIT clsPolicyData
SQL-019 Resolve the parent policy number (superseded path) Stored Proc N/A — stored procedure clsPolicyData
SQL-020 Derive the secondary cancellation and collection status Inline N/A — stored procedure clsPolicyData
SQL-021 Retrieve the wrap-up legal name for a policy Stored Proc N/A — stored procedure clsPolicyData
SQL-022 Count waiver records to detect waiver existence Stored Proc N/A — stored procedure clsPolicyData
SQL-023 Retrieve employer-liability limits for a policy period Stored Proc N/A — stored procedure clsPolicyPeriod
SQL-024 Look up an external client e-mail address (legacy path) Stored Proc N/A — stored procedure clsTeamAssignment
SQL-025 Look up a system user's e-mail address Stored Proc N/A — stored procedure clsTeamAssignment
SQL-026 Retrieve all policy associations across four association families Inline POLICY_RELATIONSHIP, POLICY, COMBO_POLICY_PERIOD, POLICY_PERIOD, ER_COMBINATION_POLICY PolicyAssociationList
SQL-027 Retrieve the latest policy-period effective date Inline POLICY_PERIOD PolicyAssociationList
SQL-028 Retrieve effective and expiration dates for issued periods Inline POLICY_PERIOD_ALL, ENDORSEMENT, POLICY_PERIOD_NON_WCIS clsAssociationTypeCode
SQL-029 Retrieve untyped associations from a data-driven procedure Stored Proc N/A — stored procedure clsAssociationTypeCode

Nine of these statements call procedures or functions whose bodies live in the Oracle database. Those bodies are documented on the Procedures pages.

Sources

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