Skip to content

SAIF.Business.UnitStat SQL catalog

This page indexes all SQL statements used by this library, grouped by CRUD type.

Create operations

SQL ID Description Type Tables Business object
SQL-001 US_AUDIT_CONDITION insert Inline US_AUDIT_CONDITION clsAuditCondition
SQL-002 US_AUDIT_CONDITION_HISTORY insert Inline US_AUDIT_CONDITION_HISTORY clsAuditConditionHistory
SQL-003 US_CLAIM_UNIT insert Inline US_CLAIM_UNIT clsClaimUnit
SQL-004 US_POLICY_UNIT insert Inline US_POLICY_UNIT clsPolicyUnit

Read operations

SQL ID Description Type Tables Business object
SQL-005 US_AUDIT_CONDITION by sequence Inline US_AUDIT_CONDITION clsAuditCondition
SQL-006 US_AUDIT_CONDITION all rows Inline US_AUDIT_CONDITION clsAuditConditionCollection
SQL-007 US_AUDIT_CONDITION by policy period Inline US_AUDIT_CONDITION, US_POLICY_UNIT clsAuditConditionCollection
SQL-008 US_AUDIT_CONDITION by policy unit Inline US_AUDIT_CONDITION clsAuditConditionCollection
SQL-009 US_AUDIT_CONDITION by update user Inline US_AUDIT_CONDITION clsAuditConditionCollection
SQL-010 US_AUDIT_CONDITION_HISTORY by composite key Inline US_AUDIT_CONDITION_HISTORY clsAuditConditionHistory
SQL-011 US_AUDIT_CONDITION_HISTORY collection by composite key Inline US_AUDIT_CONDITION_HISTORY clsAuditConditionHistoryCollection
SQL-012 US_CLAIM_UNIT active row by claim Inline US_CLAIM_UNIT clsClaimUnit
SQL-013 US_CLAIM_UNIT row by claim and policy unit Inline US_CLAIM_UNIT clsClaimUnit
SQL-014 CL_INJURY_CLAIM denial-final lookup Inline CL_INJURY_CLAIM clsClaimUnit.IsDeniedFinal
SQL-015 US_CLAIM_UNIT / US_POLICY_UNIT fraud flag eligibility lookup Inline US_CLAIM_UNIT, US_POLICY_UNIT clsClaimUnit.IsFullyFraudulent
SQL-016 US_CLAIM_UNIT collection by policy unit Inline US_CLAIM_UNIT clsClaimUnitCollection
SQL-017 CALCULATION_TYPE_CODE code-table load Inline CALCULATION_TYPE_CODE CodeMappings.clsCalculationTypeMap
SQL-018 US_COST_TYPE_CODE code-table load Inline US_COST_TYPE_CODE CodeMappings.clsCostTypeMap
SQL-019 US_OFFSET_TYPE_CODE code-table load Inline US_OFFSET_TYPE_CODE CodeMappings.clsOffsetTypeMap
SQL-020 US_POLICY_UNIT active row by retrieve date Inline US_POLICY_UNIT clsPolicyUnit
SQL-021 US_POLICY_UNIT active row by natural key Inline US_POLICY_UNIT clsPolicyUnit
SQL-022 US_POLICY_UNIT row by sequence Inline US_POLICY_UNIT clsPolicyUnit
SQL-023 US_POLICY_UNIT rows requiring loss edits Inline US_POLICY_UNIT clsPolicyUnitCollection
SQL-024 US_POLICY_UNIT collection by policy Inline US_POLICY_UNIT clsPolicyUnitCollection
SQL-025 US_POLICY_UNIT collection by policy period Inline US_POLICY_UNIT clsPolicyUnitCollection

Update operations

SQL ID Description Type Tables Business object
SQL-026 US_AUDIT_CONDITION_HISTORY update last-update date Inline US_AUDIT_CONDITION_HISTORY clsAuditConditionHistory
SQL-027 US_AUDIT_CONDITION_HISTORY collection update Inline US_AUDIT_CONDITION_HISTORY clsAuditConditionHistoryCollection
SQL-028 US_CLAIM_UNIT update Inline US_CLAIM_UNIT clsClaimUnit
SQL-029 US_POLICY_UNIT update Inline US_POLICY_UNIT clsPolicyUnit

Delete operations

SQL ID Description Type Tables Business object
SQL-030 US_AUDIT_CONDITION delete by edit type Inline US_AUDIT_CONDITION clsAuditConditionCollection
SQL-031 US_AUDIT_CONDITION delete by policy period Inline US_AUDIT_CONDITION, US_POLICY_UNIT clsAuditConditionCollection
SQL-032 US_AUDIT_CONDITION delete by policy period and edit type Inline US_AUDIT_CONDITION, US_POLICY_UNIT clsAuditConditionCollection
SQL-033 US_AUDIT_CONDITION delete by policy unit and edit type Inline US_AUDIT_CONDITION clsAuditConditionCollection
SQL-034 US_CLAIM_UNIT delete Inline US_CLAIM_UNIT clsClaimUnit
SQL-035 US_POLICY_UNIT delete Inline US_POLICY_UNIT clsPolicyUnit

Sources

  • Business\SAIF.Business.UnitStat\App.config
  • Business\SAIF.Business.UnitStat\clsAuditCondition.vb
  • Business\SAIF.Business.UnitStat\clsAuditConditionCollection.vb
  • Business\SAIF.Business.UnitStat\clsAuditConditionHistory.vb
  • Business\SAIF.Business.UnitStat\clsAuditConditionHistoryCollection.vb
  • Business\SAIF.Business.UnitStat\clsClaimUnit.vb
  • Business\SAIF.Business.UnitStat\clsClaimUnitCollection.vb
  • Business\SAIF.Business.UnitStat\clsPolicyUnit.vb
  • Business\SAIF.Business.UnitStat\clsPolicyUnitCollection.vb
  • Business\SAIF.Business.UnitStat\mdlCodeMaps.vb