SAIF.Business.UnitStat.Claim SQL catalog

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

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-002	Inline create used by Criteria	Inline	US_COVERAGE_COMBINATION	Criteria
SQL-003	Inline create used by Criteria	Inline	us_coverage_combination	Criteria
SQL-004	Inline create used by Criteria	Inline	US_LOSS_CATEGORY	Criteria
SQL-005	Inline create used by Criteria	Inline	US_LOSS_CATEGORY_OFFSET	Criteria
SQL-006	Inline create used by Criteria	Inline	US_LOSS_SUMMARY	Criteria

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-007	Inline read used by clsCurrentLoss	Inline	us_policy_unit, us_claim_unit, cl_injury_claim, cl_injury_source_code, cl_injury_nature_code, cl_body_part_code, us_unit_report, us_report_batch, us_reported_loss, us_coverage_combination, us_catastrophic_claim, us_catastrophe	clsCurrentLoss
SQL-008	pk73304_loss_summary.get_denied_final_flag	StoredProc	—	clsDeniedFinal
SQL-009	pk73304_loss_summary.get_final_denial_date	StoredProc	—	clsFinalDenial
SQL-010	pk73304_loss_summary.get_fraud_recovery_date	StoredProc	—	clsFraudRecovery
SQL-011	Inline read used by clsLossSummary	Inline	dual	clsLossSummary
SQL-012	pk73304_loss_summary.get_final_denial_dates	StoredProc	settlement_exists, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report	clsLossValuation
SQL-013	pk73304_loss_summary.get_refund_dates	StoredProc	—	clsRefund
SQL-014	pk73304_loss_summary.get_thirdparty_prediction	StoredProc	settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report	clsThirdPartyPrediction
SQL-015	pk73304_loss_summary.get_thirdparty_prediction	StoredProc	settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report	clsThirdPartyPrediction
SQL-016	Inline read used by clsThirdPartyPrediction	Inline	dual	clsThirdPartyPrediction
SQL-017	Inline read used by Criteria	Inline	US_COVERAGE_COMBINATION	Criteria

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-018	Inline update used by Criteria	Inline	US_COVERAGE_COMBINATION	Criteria
SQL-019	Inline update used by Criteria	Inline	US_LOSS_CATEGORY	Criteria
SQL-020	Inline update used by Criteria	Inline	US_LOSS_CATEGORY_OFFSET	Criteria
SQL-021	Inline update used by Criteria	Inline	US_LOSS_SUMMARY	Criteria

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-022	Inline delete used by Criteria	Inline	US_COVERAGE_COMBINATION	Criteria
SQL-023	Inline delete used by Criteria	Inline	us_coverage_combination	Criteria
SQL-024	Inline delete used by Criteria	Inline	US_LOSS_CATEGORY	Criteria
SQL-025	Inline delete used by Criteria	Inline	US_LOSS_CATEGORY_OFFSET	Criteria
SQL-026	Inline delete used by Criteria	Inline	US_LOSS_SUMMARY	Criteria

Sequence operations

SQL ID	Description	Type	Tables	Business object
SQL-001	Inline sequence used by Criteria	Inline	DUAL	Criteria

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• Procedures
• API reference

Sources

• Business\SAIF.Business.UnitStat.Claim\Coverage Combination\clsCoverageCombination.vb
• Business\SAIF.Business.UnitStat.Claim\Coverage Combination\clsCoverageCombinationCollection.vb
• Business\SAIF.Business.UnitStat.Claim\Current Loss\clsCurrentLoss.vb
• Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsDeniedFinal.vb
• Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsFinalDenial.vb
• Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsFraudRecovery.vb
• Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsLossCategory.vb
• Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsLossCategoryOffset.vb
• Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsLossSummary.vb
• Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsLossValuation.vb
• Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsRefund.vb
• Business\SAIF.Business.UnitStat.Claim\Loss Summary\clsThirdPartyPrediction.vb