Skip to content

SQL-054: Retrieve policyperiodfederalcoverage

Retrieve policyperiodfederalcoverage in the context of clsPolicyPeriodFederalCoverage.

Classification

Field Value
SQL ID SQL-054
Operation type Read
Execution method Reader/Scalar
Database Oracle
Command type Text
Schema [unqualified]
Business object clsPolicyPeriodFederalCoverage
Criteria property RetrieveSQL
Lifecycle method BeforeRetrieve / AfterRetrieve

Parameters

Parameter Direction Type Max length Description
:PolicyNum Input Numeric* inferred/unknown Bind variable in clsPolicyPeriodFederalCoverage.RetrieveSQL.
:PolicyPeriodEffDate Input Date inferred/unknown Bind variable in clsPolicyPeriodFederalCoverage.RetrieveSQL.
:FedCoverageTypeCode Input String* inferred/unknown Bind variable in clsPolicyPeriodFederalCoverage.RetrieveSQL.
:FedCoverageEffDate Input Date inferred/unknown Bind variable in clsPolicyPeriodFederalCoverage.RetrieveSQL.

Tables

Table Access Columns used
POLICY_PERIOD_FED_COVERAGE SELECT See sample SQL
FED_COVERAGE_TYPE_CODE SELECT See sample SQL

Sample SQL

SELECT
  POLICY_PERIOD_FED_COVERAGE.POLICY_NUM as PolicyNum,
  POLICY_PERIOD_FED_COVERAGE.POLICY_PERIOD_EFF_DATE as PolicyPeriodEffDate,
  POLICY_PERIOD_FED_COVERAGE.FED_COVERAGE_TYPE_CODE as FedCoverageTypeCode,
  FED_COVERAGE_TYPE_CODE.CODE_DESCR as CodeDescr,
  POLICY_PERIOD_FED_COVERAGE.FED_COVERAGE_EFF_DATE as FedCoverageEffDate,
  POLICY_PERIOD_FED_COVERAGE.FED_COVERAGE_EXP_DATE as FedCoverageExpDate,
  POLICY_PERIOD_FED_COVERAGE.FED_LIABILITY_LIMIT_SEQ_NUM as FedLiabilityLimitSeqNum,
  POLICY_PERIOD_FED_COVERAGE.OPERATIONS_DESCR as OperationsDescr,
  POLICY_PERIOD_FED_COVERAGE.EMPLOYEES_DESCR as EmployeesDescr,
  POLICY_PERIOD_FED_COVERAGE.CREATE_DATE as CreateDate,
  POLICY_PERIOD_FED_COVERAGE.CREATE_USER as CreateUser,
  POLICY_PERIOD_FED_COVERAGE.UPDATE_DATE as UpdateDate,
  POLICY_PERIOD_FED_COVERAGE.UPDATE_USER as UpdateUser
FROM POLICY_PERIOD_FED_COVERAGE, FED_COVERAGE_TYPE_CODE
WHERE
  POLICY_PERIOD_FED_COVERAGE.POLICY_NUM = :PolicyNum
  AND POLICY_PERIOD_FED_COVERAGE.POLICY_PERIOD_EFF_DATE = :PolicyPeriodEffDate
  AND POLICY_PERIOD_FED_COVERAGE.FED_COVERAGE_TYPE_CODE = :FedCoverageTypeCode
  AND POLICY_PERIOD_FED_COVERAGE.FED_COVERAGE_EFF_DATE = :FedCoverageEffDate

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

  • Business/SAIF.Business.Policy.Premium/clsPolicyPeriodFederalCoverage.vb