SAIF.Business.UnitStat.Claim database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
DUAL	Oracle	[unqualified]**	C, R	Supports Criteria, clsLossSummary, clsThirdPartyPrediction data access in this library.	Criteria
US_COVERAGE_COMBINATION	Oracle	[unqualified]**	C, D, R, U	Supports Criteria, clsCurrentLoss data access in this library.	Criteria
US_LOSS_CATEGORY	Oracle	[unqualified]**	C, D, U	Supports Criteria data access in this library.	Criteria
US_LOSS_CATEGORY_OFFSET	Oracle	[unqualified]**	C, D, U	Supports Criteria data access in this library.	Criteria
US_LOSS_SUMMARY	Oracle	[unqualified]**	C, D, U	Supports Criteria data access in this library.	Criteria
us_policy_unit	Oracle	[unqualified]**	R	Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library.	clsCurrentLoss
us_claim_unit	Oracle	[unqualified]**	R	Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library.	clsCurrentLoss
cl_injury_claim	Oracle	[unqualified]**	R	Supports clsCurrentLoss data access in this library.	clsCurrentLoss
cl_injury_source_code	Oracle	[unqualified]**	R	Supports clsCurrentLoss data access in this library.	clsCurrentLoss
cl_injury_nature_code	Oracle	[unqualified]**	R	Supports clsCurrentLoss data access in this library.	clsCurrentLoss
cl_body_part_code	Oracle	[unqualified]**	R	Supports clsCurrentLoss data access in this library.	clsCurrentLoss
us_unit_report	Oracle	[unqualified]**	R	Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library.	clsCurrentLoss
us_report_batch	Oracle	[unqualified]**	R	Supports clsCurrentLoss data access in this library.	clsCurrentLoss
us_reported_loss	Oracle	[unqualified]**	R	Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library.	clsCurrentLoss
us_catastrophic_claim	Oracle	[unqualified]**	R	Supports clsCurrentLoss data access in this library.	clsCurrentLoss
us_catastrophe	Oracle	[unqualified]**	R	Supports clsCurrentLoss data access in this library.	clsCurrentLoss
settlement_exists	Oracle	[unqualified]**	R	Supports clsLossValuation, clsThirdPartyPrediction data access in this library.	clsLossValuation
thrdparty_case	Oracle	[unqualified]**	R	Supports clsThirdPartyPrediction data access in this library.	clsThirdPartyPrediction
thrdparty_prediction	Oracle	[unqualified]**	R	Supports clsThirdPartyPrediction data access in this library.	clsThirdPartyPrediction

DUAL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria, clsLossSummary, clsThirdPartyPrediction data access in this library.
Access pattern	Direct SQL
CRUD operations	C, R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	Criteria, clsLossSummary, clsThirdPartyPrediction

Operations referencing this table

• Coverage combination management
• Loss summary maintenance

Business rules referencing this table

• BR-004: Coverage-combination identifiers come from an Oracle sequence

SQL referencing this table

• SQL-001: SELECT COVERAGE_COMBINATION_SEQ_NUM_NEXTVAL FROM DUAL

---

US_COVERAGE_COMBINATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria, clsCurrentLoss data access in this library.
Access pattern	Direct SQL
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	Criteria, clsCurrentLoss

Operations referencing this table

• Coverage combination management

Business rules referencing this table

• BR-001: NCCI claim type derives from claim and coverage context
• BR-004: Coverage-combination identifiers come from an Oracle sequence

SQL referencing this table

• SQL-002: Insert into US_COVERAGE_COMBINATION ( COVERAGE_COMBINATION_SEQ_NUM, PA
• SQL-017: Select US_COVERAGE_COMBINATION.COVERAGE_COMBINATION_SEQ_NUM as Coverag
• SQL-018: Update US_COVERAGE_COMBINATION Set COVERAGE_COMBINATION_SEQ_NUM = :Cov
• SQL-022: Delete US_COVERAGE_COMBINATION Where

---

US_LOSS_CATEGORY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Direct SQL
CRUD operations	C, D, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	Criteria

Operations referencing this table

• Loss category and offset maintenance

SQL referencing this table

• SQL-004: Insert into US_LOSS_CATEGORY ( US_LOSS_CATEGORY_SEQ_NUM, US_LOSS_SUMMA
• SQL-019: Update US_LOSS_CATEGORY Set US_LOSS_CATEGORY_SEQ_NUM = :LossCategorySe
• SQL-024: Delete US_LOSS_CATEGORY Where US_LOSS_CATEGORY.US_LOSS_CATEGORY_SEQ_NU

---

US_LOSS_CATEGORY_OFFSET

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Direct SQL
CRUD operations	C, D, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	Criteria

Operations referencing this table

• Loss category and offset maintenance

SQL referencing this table

• SQL-005: Insert into US_LOSS_CATEGORY_OFFSET ( US_LOSS_CAT_OFFSET_SEQ_NUM, US_L
• SQL-020: Update US_LOSS_CATEGORY_OFFSET Set US_LOSS_CAT_OFFSET_SEQ_NUM = :LossC
• SQL-025: Delete US_LOSS_CATEGORY_OFFSET Where US_LOSS_CATEGORY_OFFSET.US_LOSS_C

---

US_LOSS_SUMMARY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Direct SQL
CRUD operations	C, D, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	Criteria

Operations referencing this table

• Loss summary maintenance

SQL referencing this table

• SQL-006: Insert into US_LOSS_SUMMARY ( US_LOSS_SUMMARY_SEQ_NUM, CLAIM_ID, US_PO
• SQL-021: Update US_LOSS_SUMMARY Set US_LOSS_SUMMARY_SEQ_NUM = :LossSummarySeqNu
• SQL-026: Delete US_LOSS_SUMMARY Where US_LOSS_SUMMARY.US_LOSS_SUMMARY_SEQ_NUM =

---

us_policy_unit

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library.
Access pattern	Both
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	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, settlement_exists, us_reported_loss, us_claim_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_unit_report
Business objects	clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction

SQL referencing this table

• SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a
• SQL-012: pk73304_loss_summary.get_final_denial_dates
• SQL-014: pk73304_loss_summary.get_thirdparty_prediction
• SQL-015: pk73304_loss_summary.get_thirdparty_prediction

---

us_claim_unit

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library.
Access pattern	Both
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	us_policy_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, settlement_exists, us_reported_loss, us_policy_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_policy_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_policy_unit, us_unit_report
Business objects	clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction

SQL referencing this table

• SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a
• SQL-012: pk73304_loss_summary.get_final_denial_dates
• SQL-014: pk73304_loss_summary.get_thirdparty_prediction
• SQL-015: pk73304_loss_summary.get_thirdparty_prediction

---

cl_injury_claim

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsCurrentLoss data access in this library.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	us_policy_unit, us_claim_unit, 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
Business objects	clsCurrentLoss

SQL referencing this table

• SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a

---

cl_injury_source_code

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsCurrentLoss data access in this library.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	us_policy_unit, us_claim_unit, cl_injury_claim, 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
Business objects	clsCurrentLoss

SQL referencing this table

• SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a

---

cl_injury_nature_code

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsCurrentLoss data access in this library.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	us_policy_unit, us_claim_unit, cl_injury_claim, cl_injury_source_code, cl_body_part_code, us_unit_report, us_report_batch, us_reported_loss, us_coverage_combination, us_catastrophic_claim, us_catastrophe
Business objects	clsCurrentLoss

SQL referencing this table

• SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a

---

cl_body_part_code

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsCurrentLoss data access in this library.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	us_policy_unit, us_claim_unit, cl_injury_claim, cl_injury_source_code, cl_injury_nature_code, us_unit_report, us_report_batch, us_reported_loss, us_coverage_combination, us_catastrophic_claim, us_catastrophe
Business objects	clsCurrentLoss

SQL referencing this table

• SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a

---

us_unit_report

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library.
Access pattern	Both
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	us_policy_unit, us_claim_unit, cl_injury_claim, cl_injury_source_code, cl_injury_nature_code, cl_body_part_code, us_report_batch, us_reported_loss, us_coverage_combination, us_catastrophic_claim, us_catastrophe, settlement_exists, us_reported_loss, us_claim_unit, us_policy_unit, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, settlement_exists, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit
Business objects	clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction

SQL referencing this table

• SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a
• SQL-012: pk73304_loss_summary.get_final_denial_dates
• SQL-014: pk73304_loss_summary.get_thirdparty_prediction
• SQL-015: pk73304_loss_summary.get_thirdparty_prediction

---

us_report_batch

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsCurrentLoss data access in this library.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	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_reported_loss, us_coverage_combination, us_catastrophic_claim, us_catastrophe
Business objects	clsCurrentLoss

SQL referencing this table

• SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a

---

us_reported_loss

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction data access in this library.
Access pattern	Both
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	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_coverage_combination, us_catastrophic_claim, us_catastrophe, settlement_exists, us_claim_unit, us_policy_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_claim_unit, us_policy_unit, us_unit_report, settlement_exists, thrdparty_case, thrdparty_prediction, us_claim_unit, us_policy_unit, us_unit_report
Business objects	clsCurrentLoss, clsLossValuation, clsThirdPartyPrediction

SQL referencing this table

• SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a
• SQL-012: pk73304_loss_summary.get_final_denial_dates
• SQL-014: pk73304_loss_summary.get_thirdparty_prediction
• SQL-015: pk73304_loss_summary.get_thirdparty_prediction

---

us_catastrophic_claim

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsCurrentLoss data access in this library.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	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_catastrophe
Business objects	clsCurrentLoss

SQL referencing this table

• SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a

---

us_catastrophe

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsCurrentLoss data access in this library.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	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
Business objects	clsCurrentLoss

SQL referencing this table

• SQL-007: SELECT ic.injury_date as InjuryDate, ic.saif_prov_payroll_class_code a

---

settlement_exists

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsLossValuation, clsThirdPartyPrediction data access in this library.
Access pattern	Stored procedure
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report, thrdparty_case, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report
Business objects	clsLossValuation, clsThirdPartyPrediction

SQL referencing this table

• SQL-012: pk73304_loss_summary.get_final_denial_dates
• SQL-014: pk73304_loss_summary.get_thirdparty_prediction
• SQL-015: pk73304_loss_summary.get_thirdparty_prediction

---

thrdparty_case

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsThirdPartyPrediction data access in this library.
Access pattern	Stored procedure
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	settlement_exists, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report, settlement_exists, thrdparty_prediction, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report
Business objects	clsThirdPartyPrediction

SQL referencing this table

• SQL-014: pk73304_loss_summary.get_thirdparty_prediction
• SQL-015: pk73304_loss_summary.get_thirdparty_prediction

---

thrdparty_prediction

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports clsThirdPartyPrediction data access in this library.
Access pattern	Stored procedure
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	settlement_exists, thrdparty_case, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report, settlement_exists, thrdparty_case, us_reported_loss, us_claim_unit, us_policy_unit, us_unit_report
Business objects	clsThirdPartyPrediction

SQL referencing this table

• SQL-014: pk73304_loss_summary.get_thirdparty_prediction
• SQL-015: pk73304_loss_summary.get_thirdparty_prediction

---

Table relationship diagram

The following diagram shows relationships between tables used by this library.

erDiagram
    US_POLICY_UNIT ||--o{ US_CLAIM_UNIT : "policy unit"
    US_CLAIM_UNIT ||--o{ US_REPORTED_LOSS : "claim_id"
    US_LOSS_SUMMARY ||--o{ US_LOSS_CATEGORY : "summary seq"
    US_LOSS_CATEGORY ||--o{ US_LOSS_CATEGORY_OFFSET : "category seq"

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• Procedures
• API reference

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.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\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\clsThirdPartyPrediction.vb