SAIF.Business.Claim.ThirdParty database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
THRDPARTY_LIEN	Oracle	[unqualified]**	C, R, U	Supports Criteria data access in this library.	Criteria
WAIVER_DETAIL	Oracle	[unqualified]**	C, U	Supports Criteria data access in this library.	Criteria
THRDPARTY_PREDICTION_DETAIL	Oracle	[unqualified]**	C, R, U	Supports Criteria data access in this library.	Criteria
v_count	Oracle	[unqualified]**	C, R, U	Supports Criteria data access in this library.	Criteria
TP_CLAIM_COST_CATEGORY_CODE	Oracle	[unqualified]**	C, R, U	Supports Criteria data access in this library.	Criteria
thrdparty_claim_cost	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
THRDPARTY_LIEN_CATEGORY	Oracle	[unqualified]**	C, R, U	Supports Criteria data access in this library.	Criteria
THRDPARTY_CASE	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
v_claim_id	Oracle	[unqualified]**	C, R	Supports Criteria data access in this library.	Criteria
dual	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
v_LienSeq	Oracle	[unqualified]**	C	Supports Criteria data access in this library.	Criteria
v_amount	Oracle	[unqualified]**	C	Supports Criteria data access in this library.	Criteria
thrdparty_adjuster_code	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
THRDPARTY_BILL_SERVICE	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
THRDPARTY_COMPANION_CLAIM	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
v_emplid	Oracle	[unqualified]**	C, D, U	Supports Criteria data access in this library.	Criteria
THRDPARTY_PREDICTION	Oracle	[unqualified]**	C, R, U	Supports Criteria data access in this library.	Criteria
v_lienseqnum	Oracle	[unqualified]**	C, U	Supports Criteria data access in this library.	Criteria
thrdparty_distribution_refund	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
thrdparty_distribution	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
v_refundSeqNum	Oracle	[unqualified]**	C, D	Supports Criteria data access in this library.	Criteria
THRDPARTY_EXPENSE	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
v_firm_seq	Oracle	[unqualified]**	C, D, R	Supports Criteria data access in this library.	Criteria
COMPANY	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
THRDPARTY_FIRM	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
ADDRESS	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
company_address	Oracle	[unqualified]**	C, D	Supports Criteria data access in this library.	Criteria
v_person_seq	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
PERSON_ADDRESS	Oracle	[unqualified]**	C, D, R	Supports Criteria data access in this library.	Criteria
v_phone_seq	Oracle	[unqualified]**	C, D, U	Supports Criteria data access in this library.	Criteria
PHONE	Oracle	[unqualified]**	C, R, U	Supports Criteria data access in this library.	Criteria
person_phone	Oracle	[unqualified]**	C, D, U	Supports Criteria data access in this library.	Criteria
v_fax_seq	Oracle	[unqualified]**	C, D, U	Supports Criteria data access in this library.	Criteria
v_recoveryamount	Oracle	[unqualified]**	C, R	Supports Criteria data access in this library.	Criteria
v_status	Oracle	[unqualified]**	C, R	Supports Criteria data access in this library.	Criteria
thrdparty_note	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
thrdparty_settlement_detail	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
thrdparty_settlement	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
v_settlementDtlSeqNum	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
v_distributionSeqNum	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
THRDPARTY_TASK	Oracle	[unqualified]**	C, D, R, U	Supports Criteria data access in this library.	Criteria
CBP_AUDITED_SERVICE	Oracle	[unqualified]**	D, R, U	Supports Criteria data access in this library.	Criteria
person	Oracle	[unqualified]**	D, R	Supports Criteria data access in this library.	Criteria
LEGAL.ADP_EMPLOYEE	Oracle	LEGAL	R	Supports Criteria data access in this library.	Criteria
v_nonlien_amount	Oracle	[unqualified]**	R	Supports Criteria data access in this library.	Criteria
thrdpart_distribution_view	Oracle	[unqualified]**	R, U	Supports Criteria data access in this library.	Criteria
thrdparty_settlement_category	Oracle	[unqualified]**	D, R, U	Supports Criteria data access in this library.	Criteria
thrdparty_fund_category_code	Oracle	[unqualified]**	D, R, U	Supports Criteria data access in this library.	Criteria
CBP_CPT_SERVICE	Oracle	[unqualified]**	R	Supports Criteria data access in this library.	Criteria
THRDPARTY_CLOSURE_CODE	Oracle	[unqualified]**	R	Supports Criteria data access in this library.	Criteria
POLICY_ASSIGN	Oracle	[unqualified]**	R	Supports Criteria data access in this library.	Criteria
THRDPARTY_STATUS_HIST	Oracle	[unqualified]**	D, R, U	Supports Criteria data access in this library.	Criteria
v_select_count	Oracle	[unqualified]**	D, U	Supports Criteria data access in this library.	Criteria
company_phone	Oracle	[unqualified]**	D, U	Supports Criteria data access in this library.	Criteria
v_address_seq	Oracle	[unqualified]**	D	Supports Criteria data access in this library.	Criteria
v_company_seq	Oracle	[unqualified]**	D	Supports Criteria data access in this library.	Criteria
thrdparty_distribution_code	Oracle	[unqualified]**	D	Supports Criteria data access in this library.	Criteria
v_descr	Oracle	[unqualified]**	D	Supports Criteria data access in this library.	Criteria

THRDPARTY_LIEN

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	WAIVER_DETAIL, THRDPARTY_PREDICTION_DETAIL, v_count, TP_CLAIM_COST_CATEGORY_CODE, thrdparty_claim_cost, THRDPARTY_LIEN_CATEGORY, THRDPARTY_CASE, v_claim_id, THRDPARTY_PREDICTION, v_lienseqnum, THRDPARTY_PREDICTION, THRDPARTY_PREDICTION_DETAIL, THRDPARTY_PREDICTION, v_lienseqnum
Business objects	Criteria

Operations referencing this table

• Manage liens and settlements

SQL referencing this table

• SQL-001: Pk82033_ThirdParty.prediction_new_dtl_categories
• SQL-002: Pk82033_Thirdparty.thrdparty_clm_cost_cat_create
• SQL-021: Pk82033_ThirdParty.prediction_insert
• SQL-043: Pk82033_ThirdParty.prediction_detail_select
• SQL-075: Pk82033_ThirdParty.prediction_update

---

WAIVER_DETAIL

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

SQL referencing this table

• SQL-001: Pk82033_ThirdParty.prediction_new_dtl_categories
• SQL-020: Pk82033_ThirdParty.prediction_detail_insert
• SQL-074: Pk82033_ThirdParty.prediction_detail_update

---

THRDPARTY_PREDICTION_DETAIL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	THRDPARTY_LIEN, WAIVER_DETAIL, v_count, WAIVER_DETAIL, v_count, THRDPARTY_PREDICTION, THRDPARTY_LIEN, WAIVER_DETAIL, thrdparty_distribution, thrdpart_distribution_view, thrdparty_distribution_refund, v_count
Business objects	Criteria

Operations referencing this table

• Run case search and predictions

SQL referencing this table

• SQL-001: Pk82033_ThirdParty.prediction_new_dtl_categories
• SQL-020: Pk82033_ThirdParty.prediction_detail_insert
• SQL-043: Pk82033_ThirdParty.prediction_detail_select
• SQL-074: Pk82033_ThirdParty.prediction_detail_update

---

v_count

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	THRDPARTY_LIEN, WAIVER_DETAIL, THRDPARTY_PREDICTION_DETAIL, WAIVER_DETAIL, THRDPARTY_PREDICTION_DETAIL, dual, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, thrdparty_adjuster_code, v_recoveryamount, v_status, dual, v_person_seq, PERSON_ADDRESS, thrdparty_case, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, CBP_CPT_SERVICE, v_recoveryamount, v_status, WAIVER_DETAIL, thrdparty_distribution, thrdpart_distribution_view, thrdparty_distribution_refund, THRDPARTY_PREDICTION_DETAIL
Business objects	Criteria

SQL referencing this table

• SQL-001: Pk82033_ThirdParty.prediction_new_dtl_categories
• SQL-020: Pk82033_ThirdParty.prediction_detail_insert
• SQL-047: Pk82033_ThirdParty.Statute_Date_List
• SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List
• SQL-074: Pk82033_ThirdParty.prediction_detail_update

---

TP_CLAIM_COST_CATEGORY_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	thrdparty_claim_cost, THRDPARTY_LIEN_CATEGORY, THRDPARTY_LIEN, THRDPARTY_CASE, v_claim_id, THRDPARTY_BILL_SERVICE, THRDPARTY_PREDICTION, THRDPARTY_CASE, thrdparty_lien_category, thrdparty_claim_cost, v_claim_id, thrdparty_lien, thrdparty_claim_cost, THRDPARTY_LIEN_CATEGORY, THRDPARTY_PREDICTION, THRDPARTY_BILL_SERVICE
Business objects	Criteria

Operations referencing this table

• Retrieve billed-cost and payment details

SQL referencing this table

• SQL-002: Pk82033_Thirdparty.thrdparty_clm_cost_cat_create
• SQL-017: Pk82033_ThirdParty.billservice_insert
• SQL-040: pk82033_thirdparty.cost_category_select
• SQL-056: Pk82033_Thirdparty.thrdparty_lien_cat_select
• SQL-058: Pk82033_Thirdparty.thrdparty_lien_select_by_Seq
• SQL-071: Pk82033_ThirdParty.billservice_update

---

thrdparty_claim_cost

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	TP_CLAIM_COST_CATEGORY_CODE, THRDPARTY_LIEN_CATEGORY, THRDPARTY_LIEN, THRDPARTY_CASE, v_claim_id, THRDPARTY_CASE, thrdparty_lien_category, TP_CLAIM_COST_CATEGORY_CODE, v_claim_id, thrdparty_lien, TP_CLAIM_COST_CATEGORY_CODE, THRDPARTY_LIEN_CATEGORY
Business objects	Criteria

SQL referencing this table

• SQL-002: Pk82033_Thirdparty.thrdparty_clm_cost_cat_create
• SQL-056: Pk82033_Thirdparty.thrdparty_lien_cat_select
• SQL-058: Pk82033_Thirdparty.thrdparty_lien_select_by_Seq

---

THRDPARTY_LIEN_CATEGORY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	TP_CLAIM_COST_CATEGORY_CODE, thrdparty_claim_cost, THRDPARTY_LIEN, THRDPARTY_CASE, v_claim_id, dual, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_adjuster_code, v_recoveryamount, v_status, thrdparty_lien, TP_CLAIM_COST_CATEGORY_CODE, thrdparty_claim_cost, v_person_seq, THRDPARTY_CASE, thrdparty_adjuster_code
Business objects	Criteria

Operations referencing this table

• Manage liens and settlements

SQL referencing this table

• SQL-002: Pk82033_Thirdparty.thrdparty_clm_cost_cat_create
• SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert
• SQL-058: Pk82033_Thirdparty.thrdparty_lien_select_by_Seq
• SQL-081: Pk82033_Thirdparty.thrdparty_lien_category_update

---

THRDPARTY_CASE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	TP_CLAIM_COST_CATEGORY_CODE, thrdparty_claim_cost, THRDPARTY_LIEN_CATEGORY, THRDPARTY_LIEN, v_claim_id, dual, thrdparty_lien, v_LienSeq, v_amount, dual, v_person_seq, thrdparty_distribution, thrdparty_adjuster_code, THRDPARTY_LIEN_CATEGORY, v_recoveryamount, v_status, THRDPARTY_EXPENSE, thrdparty_note, phone, address, dual, THRDPARTY_FIRM, company, v_firm_seq, dual, v_person_seq, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, thrdparty_adjuster_code, v_recoveryamount, v_status, v_count, THRDPARTY_EXPENSE, THRDPARTY_EXPENSE, THRDPARTY_EXPENSE, THRDPARTY_FIRM, phone, address, company, thrdparty_lien_category, thrdparty_claim_cost, TP_CLAIM_COST_CATEGORY_CODE, v_claim_id, v_person_seq, thrdparty_adjuster_code, THRDPARTY_LIEN_CATEGORY, THRDPARTY_EXPENSE, thrdparty_note, THRDPARTY_TASK, THRDPARTY_EXPENSE, thrdparty_note, THRDPARTY_TASK
Business objects	Criteria

Operations referencing this table

• Maintain recovery case
• Manage recovery participants
• Manage expenses
• Manage liens and settlements
• Manage distributions and refunds
• Manage notes and tasks
• Run case search and predictions
• Retrieve billed-cost and payment details

Business rules referencing this table

• BR-006: Case closure loads a closure description

SQL referencing this table

• SQL-002: Pk82033_Thirdparty.thrdparty_clm_cost_cat_create
• SQL-003: Pk82033_Thirdparty.thrdparty_lien_create
• SQL-022: pk82033_thirdparty.thrdparty_case_insert
• SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert
• SQL-028: Pk82033_ThirdParty.thrdparty_note_insert
• SQL-035: Pk82033_ThirdParty.case_thrdparty_firm_select
• SQL-047: Pk82033_ThirdParty.Statute_Date_List
• SQL-049: pk82033_thirdparty.thrdparty_case_select
• SQL-052: Pk82033_ThirdParty.thrdparty_expApproval_select
• SQL-053: Pk82033_ThirdParty.thrdparty_expense_select
• SQL-054: Pk82033_ThirdParty.thrdparty_expense_select
• SQL-055: Pk82033_ThirdParty.thrdparty_firm_select
• SQL-056: Pk82033_Thirdparty.thrdparty_lien_cat_select
• SQL-081: Pk82033_Thirdparty.thrdparty_lien_category_update
• SQL-082: Pk82033_ThirdParty.thrdparty_note_update
• SQL-085: Pk82033_ThirdParty.thrdparty_task_update
• SQL-094: Pk82033_ThirdParty.thrdparty_note_delete
• SQL-097: Pk82033_ThirdParty.thrdparty_task_delete

---

v_claim_id

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	TP_CLAIM_COST_CATEGORY_CODE, thrdparty_claim_cost, THRDPARTY_LIEN_CATEGORY, THRDPARTY_LIEN, THRDPARTY_CASE, THRDPARTY_CASE, thrdparty_lien_category, thrdparty_claim_cost, TP_CLAIM_COST_CATEGORY_CODE
Business objects	Criteria

SQL referencing this table

• SQL-002: Pk82033_Thirdparty.thrdparty_clm_cost_cat_create
• SQL-056: Pk82033_Thirdparty.thrdparty_lien_cat_select

---

dual

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	THRDPARTY_CASE_SEQ, THRDPARTY_COMPANION_CLAIM_SEQ, THRDPARTY_EXPENSE_SEQ, THRDPARTY_NOTE_SEQ, THRDPARTY_PREDICTION_SEQ, THRDPARTY_PREDICT_DTL_SEQ, THRDPARTY_SEQ, THRDPARTY_SETTLEMENT_SEQ, THRDPARTY_SETTLE_DTL_SEQ, THRDPARTY_TASK_SEQ, thrdparty_distribution_seq
Related tables	THRDPARTY_CASE, thrdparty_lien, v_LienSeq, v_amount, thrdparty_distribution_refund, thrdparty_distribution, v_refundSeqNum, v_firm_seq, COMPANY, THRDPARTY_FIRM, ADDRESS, company_address, v_person_seq, PERSON_ADDRESS, v_phone_seq, PHONE, person_phone, v_fax_seq, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_adjuster_code, THRDPARTY_LIEN_CATEGORY, v_recoveryamount, v_status, THRDPARTY_CASE, phone, address, THRDPARTY_FIRM, company, v_firm_seq, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, thrdparty_adjuster_code, v_recoveryamount, v_status, v_count, v_person_seq, PERSON_ADDRESS, thrdparty_case, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, CBP_CPT_SERVICE, v_recoveryamount, v_status, v_count, thrdparty_distribution, company_phone, phone, v_phone_seq, v_fax_seq, THRDPARTY_FIRM, COMPANY, ADDRESS, person_phone, phone, v_phone_seq, v_fax_seq
Business objects	Criteria

SQL referencing this table

• SQL-003: Pk82033_Thirdparty.thrdparty_lien_create
• SQL-023: Pk82033_ThirdParty.thrdparty_distribution_insert
• SQL-025: Pk82033_ThirdParty.thrdparty_firm_insert
• SQL-026: Pk82033_ThirdParty.thrdparty_insert
• SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert
• SQL-035: Pk82033_ThirdParty.case_thrdparty_firm_select
• SQL-047: Pk82033_ThirdParty.Statute_Date_List
• SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List
• SQL-077: Pk82033_ThirdParty.thrdparty_distribution_update
• SQL-080: Pk82033_ThirdParty.thrdparty_firm_update
• SQL-086: Pk82033_ThirdParty.thrdparty_update

---

v_LienSeq

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

SQL referencing this table

• SQL-003: Pk82033_Thirdparty.thrdparty_lien_create

---

v_amount

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

SQL referencing this table

• SQL-003: Pk82033_Thirdparty.thrdparty_lien_create

---

thrdparty_adjuster_code

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Both
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, THRDPARTY_LIEN_CATEGORY, v_recoveryamount, v_status, dual, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, v_recoveryamount, v_status, v_count, v_person_seq, THRDPARTY_CASE, THRDPARTY_LIEN_CATEGORY
Business objects	Criteria

SQL referencing this table

• SQL-004: select low_claim_num as lowNum, high_claim_num as highNum, code as adj
• SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert
• SQL-047: Pk82033_ThirdParty.Statute_Date_List
• SQL-081: Pk82033_Thirdparty.thrdparty_lien_category_update

---

THRDPARTY_BILL_SERVICE

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

SQL referencing this table

• SQL-017: Pk82033_ThirdParty.billservice_insert
• SQL-018: Pk82033_ThirdParty.claimCost_insert
• SQL-071: Pk82033_ThirdParty.billservice_update
• SQL-072: Pk82033_ThirdParty.claimCost_update

---

THRDPARTY_COMPANION_CLAIM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	THRDPARTY_ADJUSTER_CODE, v_emplid, THRDPARTY_ADJUSTER_CODE, CBP_AUDITED_SERVICE, v_emplid, THRDPARTY_EXPENSE, v_select_count, thrdparty_case, THRDPARTY_ADJUSTER_CODE, CBP_AUDITED_SERVICE, thrdparty_bill_service, v_emplid, THRDPARTY_EXPENSE, v_select_count, Thrdparty_case
Business objects	Criteria

SQL referencing this table

• SQL-019: Pk82033_ThirdParty.companion_claim_insert
• SQL-039: Pk82033_ThirdParty.companion_claim_select
• SQL-073: Pk82033_ThirdParty.companion_claim_update
• SQL-078: Pk82033_ThirdParty.thrdparty_expApproval_update
• SQL-088: Pk82033_ThirdParty.companion_claim_delete
• SQL-092: Pk82033_ThirdParty.thrdparty_expense_delete

---

v_emplid

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

SQL referencing this table

• SQL-019: Pk82033_ThirdParty.companion_claim_insert
• SQL-073: Pk82033_ThirdParty.companion_claim_update
• SQL-088: Pk82033_ThirdParty.companion_claim_delete

---

THRDPARTY_PREDICTION

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

SQL referencing this table

• SQL-021: Pk82033_ThirdParty.prediction_insert
• SQL-040: pk82033_thirdparty.cost_category_select
• SQL-043: Pk82033_ThirdParty.prediction_detail_select
• SQL-044: Pk82033_ThirdParty.prediction_select
• SQL-071: Pk82033_ThirdParty.billservice_update
• SQL-075: Pk82033_ThirdParty.prediction_update

---

v_lienseqnum

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

SQL referencing this table

• SQL-021: Pk82033_ThirdParty.prediction_insert
• SQL-075: Pk82033_ThirdParty.prediction_update

---

thrdparty_distribution_refund

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, thrdparty_distribution, v_refundSeqNum, thrdparty_distribution, thrdparty_case, thrdparty_lien_category, thrdparty_lien, thrdpart_distribution_view, thrdparty_firm, company, v_nonlien_amount, WAIVER_DETAIL, thrdparty_distribution, thrdpart_distribution_view, v_count, THRDPARTY_PREDICTION_DETAIL, DUAL, thrdparty_distribution_code, v_refundSeqNum, v_descr, thrdparty_distribution
Business objects	Criteria

SQL referencing this table

• SQL-023: Pk82033_ThirdParty.thrdparty_distribution_insert
• SQL-051: Pk82033_ThirdParty.thrdparty_distribution_select
• SQL-074: Pk82033_ThirdParty.prediction_detail_update
• SQL-091: Pk82033_ThirdParty.thrdparty_distribution_delete

---

thrdparty_distribution

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, thrdparty_distribution_refund, v_refundSeqNum, dual, v_person_seq, THRDPARTY_CASE, thrdparty_adjuster_code, THRDPARTY_LIEN_CATEGORY, v_recoveryamount, v_status, thrdparty_settlement_detail, DUAL, thrdparty_settlement, v_settlementDtlSeqNum, v_distributionSeqNum, dual, v_person_seq, THRDPARTY_CASE, thrdparty_task, LEGAL.ADP_EMPLOYEE, thrdparty_adjuster_code, v_recoveryamount, v_status, v_count, thrdparty_case, thrdparty_lien_category, thrdparty_lien, thrdparty_firm, company, v_nonlien_amount, thrdparty_case, thrdparty_lien_category, thrdparty_lien, thrdpart_distribution_view, thrdparty_distribution_refund, thrdparty_firm, company, v_nonlien_amount, thrdparty_settlement, thrdparty_settlement_detail, DUAL, v_settlementDtlSeqNum, v_distributionSeqNum, dual, v_person_seq, PERSON_ADDRESS, thrdparty_case, thrdparty_task, LEGAL.ADP_EMPLOYEE, CBP_CPT_SERVICE, v_recoveryamount, v_status, v_count, WAIVER_DETAIL, thrdpart_distribution_view, thrdparty_distribution_refund, v_count, THRDPARTY_PREDICTION_DETAIL, dual, thrdparty_settlement_detail, DUAL, thrdparty_settlement, thrdparty_fund_category_code, thrdparty_settlement_category, v_settlementDtlSeqNum, v_distributionSeqNum, thrdparty_distribution_refund, DUAL, thrdparty_distribution_code, v_refundSeqNum, v_descr, thrdparty_settlement_detail, DUAL, thrdparty_settlement_category, thrdparty_settlement, thrdparty_fund_category_code, v_settlementDtlSeqNum, v_distributionSeqNum
Business objects	Criteria

SQL referencing this table

• SQL-023: Pk82033_ThirdParty.thrdparty_distribution_insert
• SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert
• SQL-030: Pk82033_ThirdParty.thrdparty_settlement_insert
• SQL-047: Pk82033_ThirdParty.Statute_Date_List
• SQL-050: Pk82033_ThirdParty.thrdparty_dist_refundee_select
• SQL-051: Pk82033_ThirdParty.thrdparty_distribution_select
• SQL-066: Pk82033_ThirdParty.thrdparty_settlement_select
• SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List
• SQL-074: Pk82033_ThirdParty.prediction_detail_update
• SQL-077: Pk82033_ThirdParty.thrdparty_distribution_update
• SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update
• SQL-091: Pk82033_ThirdParty.thrdparty_distribution_delete
• SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete

---

v_refundSeqNum

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

SQL referencing this table

• SQL-023: Pk82033_ThirdParty.thrdparty_distribution_insert
• SQL-091: Pk82033_ThirdParty.thrdparty_distribution_delete

---

THRDPARTY_EXPENSE

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

Operations referencing this table

• Manage expenses

SQL referencing this table

• SQL-024: Pk82033_ThirdParty.thrdparty_expense_insert
• SQL-028: Pk82033_ThirdParty.thrdparty_note_insert
• SQL-052: Pk82033_ThirdParty.thrdparty_expApproval_select
• SQL-053: Pk82033_ThirdParty.thrdparty_expense_select
• SQL-054: Pk82033_ThirdParty.thrdparty_expense_select
• SQL-059: Pk82033_ThirdParty.thrdparty_note_select
• SQL-078: Pk82033_ThirdParty.thrdparty_expApproval_update
• SQL-079: Pk82033_ThirdParty.thrdparty_expense_update
• SQL-082: Pk82033_ThirdParty.thrdparty_note_update
• SQL-092: Pk82033_ThirdParty.thrdparty_expense_delete
• SQL-094: Pk82033_ThirdParty.thrdparty_note_delete

---

v_firm_seq

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, COMPANY, THRDPARTY_FIRM, ADDRESS, company_address, THRDPARTY_CASE, phone, address, dual, THRDPARTY_FIRM, company, person_phone, person_address, address, thrdparty_firm, v_person_seq, v_phone_seq, v_fax_seq, v_address_seq, v_company_seq, person
Business objects	Criteria

SQL referencing this table

• SQL-025: Pk82033_ThirdParty.thrdparty_firm_insert
• SQL-035: Pk82033_ThirdParty.case_thrdparty_firm_select
• SQL-090: Pk82033_ThirdParty.thrdparty_delete

---

COMPANY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_firm_seq, THRDPARTY_FIRM, ADDRESS, company_address, dual, company_phone, phone, v_phone_seq, v_fax_seq, THRDPARTY_FIRM, ADDRESS
Business objects	Criteria

SQL referencing this table

• SQL-025: Pk82033_ThirdParty.thrdparty_firm_insert
• SQL-080: Pk82033_ThirdParty.thrdparty_firm_update

---

THRDPARTY_FIRM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_firm_seq, COMPANY, ADDRESS, company_address, THRDPARTY_CASE, phone, address, dual, company, v_firm_seq, THRDPARTY_CASE, phone, address, company, phone, address, PERSON, company, phone, address, PERSON, company, phone, address, company, dual, company_phone, phone, v_phone_seq, v_fax_seq, COMPANY, ADDRESS, company_phone, company_address, company, THRDPARTY_TASK, v_phone_seq, v_fax_seq, v_address_seq
Business objects	Criteria

SQL referencing this table

• SQL-025: Pk82033_ThirdParty.thrdparty_firm_insert
• SQL-035: Pk82033_ThirdParty.case_thrdparty_firm_select
• SQL-055: Pk82033_ThirdParty.thrdparty_firm_select
• SQL-060: Pk82033_ThirdParty.thrdparty_select
• SQL-061: Pk82033_ThirdParty.thrdparty_select
• SQL-062: Pk82033_ThirdParty.thrdparty_select_firms
• SQL-080: Pk82033_ThirdParty.thrdparty_firm_update
• SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete

---

ADDRESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_firm_seq, COMPANY, THRDPARTY_FIRM, company_address, dual, company_phone, phone, v_phone_seq, v_fax_seq, THRDPARTY_FIRM, COMPANY
Business objects	Criteria

SQL referencing this table

• SQL-025: Pk82033_ThirdParty.thrdparty_firm_insert
• SQL-080: Pk82033_ThirdParty.thrdparty_firm_update

---

company_address

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_firm_seq, COMPANY, THRDPARTY_FIRM, ADDRESS, company_phone, company, THRDPARTY_TASK, v_phone_seq, v_fax_seq, v_address_seq, THRDPARTY_FIRM
Business objects	Criteria

SQL referencing this table

• SQL-025: Pk82033_ThirdParty.thrdparty_firm_insert
• SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete

---

v_person_seq

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, PERSON_ADDRESS, v_phone_seq, PHONE, person_phone, v_fax_seq, dual, THRDPARTY_CASE, thrdparty_distribution, thrdparty_adjuster_code, THRDPARTY_LIEN_CATEGORY, v_recoveryamount, v_status, dual, THRDPARTY_CASE, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, thrdparty_adjuster_code, v_recoveryamount, v_status, v_count, dual, PERSON_ADDRESS, thrdparty_case, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, CBP_CPT_SERVICE, v_recoveryamount, v_status, v_count, THRDPARTY_CASE, thrdparty_adjuster_code, THRDPARTY_LIEN_CATEGORY, person_phone, person_address, address, thrdparty_firm, v_phone_seq, v_fax_seq, v_address_seq, v_firm_seq, v_company_seq, person
Business objects	Criteria

SQL referencing this table

• SQL-026: Pk82033_ThirdParty.thrdparty_insert
• SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert
• SQL-047: Pk82033_ThirdParty.Statute_Date_List
• SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List
• SQL-081: Pk82033_Thirdparty.thrdparty_lien_category_update
• SQL-090: Pk82033_ThirdParty.thrdparty_delete

---

PERSON_ADDRESS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_person_seq, v_phone_seq, PHONE, person_phone, v_fax_seq, dual, v_person_seq, thrdparty_case, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, CBP_CPT_SERVICE, v_recoveryamount, v_status, v_count
Business objects	Criteria

SQL referencing this table

• SQL-026: Pk82033_ThirdParty.thrdparty_insert
• SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List

---

v_phone_seq

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_person_seq, PERSON_ADDRESS, PHONE, person_phone, v_fax_seq, dual, company_phone, phone, v_fax_seq, THRDPARTY_FIRM, COMPANY, ADDRESS, dual, person_phone, phone, v_fax_seq, person_phone, person_address, address, thrdparty_firm, v_person_seq, v_fax_seq, v_address_seq, v_firm_seq, v_company_seq, person, company_phone, company_address, company, THRDPARTY_TASK, v_fax_seq, v_address_seq, THRDPARTY_FIRM
Business objects	Criteria

SQL referencing this table

• SQL-026: Pk82033_ThirdParty.thrdparty_insert
• SQL-080: Pk82033_ThirdParty.thrdparty_firm_update
• SQL-086: Pk82033_ThirdParty.thrdparty_update
• SQL-090: Pk82033_ThirdParty.thrdparty_delete
• SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete

---

PHONE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_person_seq, PERSON_ADDRESS, v_phone_seq, person_phone, v_fax_seq
Business objects	Criteria

SQL referencing this table

• SQL-026: Pk82033_ThirdParty.thrdparty_insert

---

person_phone

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_person_seq, PERSON_ADDRESS, v_phone_seq, PHONE, v_fax_seq, dual, phone, v_phone_seq, v_fax_seq, person_address, address, thrdparty_firm, v_person_seq, v_phone_seq, v_fax_seq, v_address_seq, v_firm_seq, v_company_seq, person
Business objects	Criteria

SQL referencing this table

• SQL-026: Pk82033_ThirdParty.thrdparty_insert
• SQL-086: Pk82033_ThirdParty.thrdparty_update
• SQL-090: Pk82033_ThirdParty.thrdparty_delete

---

v_fax_seq

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_person_seq, PERSON_ADDRESS, v_phone_seq, PHONE, person_phone, dual, company_phone, phone, v_phone_seq, THRDPARTY_FIRM, COMPANY, ADDRESS, dual, person_phone, phone, v_phone_seq, person_phone, person_address, address, thrdparty_firm, v_person_seq, v_phone_seq, v_address_seq, v_firm_seq, v_company_seq, person, company_phone, company_address, company, THRDPARTY_TASK, v_phone_seq, v_address_seq, THRDPARTY_FIRM
Business objects	Criteria

SQL referencing this table

• SQL-026: Pk82033_ThirdParty.thrdparty_insert
• SQL-080: Pk82033_ThirdParty.thrdparty_firm_update
• SQL-086: Pk82033_ThirdParty.thrdparty_update
• SQL-090: Pk82033_ThirdParty.thrdparty_delete
• SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete

---

v_recoveryamount

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_adjuster_code, THRDPARTY_LIEN_CATEGORY, v_status, dual, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, thrdparty_adjuster_code, v_status, v_count, dual, v_person_seq, PERSON_ADDRESS, thrdparty_case, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, CBP_CPT_SERVICE, v_status, v_count
Business objects	Criteria

SQL referencing this table

• SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert
• SQL-047: Pk82033_ThirdParty.Statute_Date_List
• SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List

---

v_status

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_adjuster_code, THRDPARTY_LIEN_CATEGORY, v_recoveryamount, dual, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, thrdparty_adjuster_code, v_recoveryamount, v_count, dual, v_person_seq, PERSON_ADDRESS, thrdparty_case, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, CBP_CPT_SERVICE, v_recoveryamount, v_count
Business objects	Criteria

SQL referencing this table

• SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert
• SQL-047: Pk82033_ThirdParty.Statute_Date_List
• SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List

---

thrdparty_note

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

SQL referencing this table

• SQL-028: Pk82033_ThirdParty.thrdparty_note_insert
• SQL-059: Pk82033_ThirdParty.thrdparty_note_select
• SQL-076: pk82033_thirdparty.thrdparty_case_update
• SQL-082: Pk82033_ThirdParty.thrdparty_note_update
• SQL-089: pk82033_thirdparty.thrdparty_case_delete
• SQL-094: Pk82033_ThirdParty.thrdparty_note_delete

---

thrdparty_settlement_detail

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	thrdparty_case, THRDPARTY_CLAIM_COST, thrdparty_distribution, DUAL, thrdparty_settlement, v_settlementDtlSeqNum, v_distributionSeqNum, thrdparty_settlement_category, thrdparty_case, thrdparty_settlement_category, thrdparty_fund_category_code, thrdparty_settlement_category, thrdparty_settlement, thrdparty_fund_category_code, thrdparty_settlement, thrdparty_distribution, DUAL, v_settlementDtlSeqNum, v_distributionSeqNum, thrdparty_case, THRDPARTY_CLAIM_COST, thrdparty_distribution, DUAL, thrdparty_settlement, thrdparty_fund_category_code, thrdparty_settlement_category, v_settlementDtlSeqNum, v_distributionSeqNum, thrdparty_case, THRDPARTY_CLAIM_COST, thrdparty_distribution, DUAL, thrdparty_settlement_category, thrdparty_settlement, thrdparty_fund_category_code, v_settlementDtlSeqNum, v_distributionSeqNum
Business objects	Criteria

SQL referencing this table

• SQL-029: Pk82033_ThirdParty.thrdparty_settl_dtl_insert
• SQL-030: Pk82033_ThirdParty.thrdparty_settlement_insert
• SQL-063: Pk82033_ThirdParty.thrdparty_settl_dtl_cd_select
• SQL-064: Pk82033_ThirdParty.thrdparty_settl_dtl_generate
• SQL-065: Pk82033_ThirdParty.thrdparty_settl_dtl_select
• SQL-066: Pk82033_ThirdParty.thrdparty_settlement_select
• SQL-083: Pk82033_ThirdParty.thrdparty_settl_dtl_update
• SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update
• SQL-095: Pk82033_ThirdParty.thrdparty_settl_dtl_delete
• SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete

---

thrdparty_settlement

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	thrdparty_settlement_detail, thrdparty_distribution, DUAL, v_settlementDtlSeqNum, v_distributionSeqNum, thrdparty_case, thrdparty_firm, company, person, thrdparty_settlement_detail, thrdparty_settlement_category, thrdparty_fund_category_code, thrdparty_settlement_detail, thrdparty_distribution, DUAL, v_settlementDtlSeqNum, v_distributionSeqNum, thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_fund_category_code, thrdparty_settlement_category, v_settlementDtlSeqNum, v_distributionSeqNum, thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement_category, thrdparty_fund_category_code, v_settlementDtlSeqNum, v_distributionSeqNum
Business objects	Criteria

SQL referencing this table

• SQL-030: Pk82033_ThirdParty.thrdparty_settlement_insert
• SQL-038: Pk82033_ThirdParty.claim_pymt_letter_recip_select
• SQL-065: Pk82033_ThirdParty.thrdparty_settl_dtl_select
• SQL-066: Pk82033_ThirdParty.thrdparty_settlement_select
• SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update
• SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete

---

v_settlementDtlSeqNum

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement, v_distributionSeqNum, thrdparty_settlement, thrdparty_settlement_detail, thrdparty_distribution, DUAL, v_distributionSeqNum, thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement, thrdparty_fund_category_code, thrdparty_settlement_category, v_distributionSeqNum, thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement_category, thrdparty_settlement, thrdparty_fund_category_code, v_distributionSeqNum
Business objects	Criteria

SQL referencing this table

• SQL-030: Pk82033_ThirdParty.thrdparty_settlement_insert
• SQL-066: Pk82033_ThirdParty.thrdparty_settlement_select
• SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update
• SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete

---

v_distributionSeqNum

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement, v_settlementDtlSeqNum, thrdparty_settlement, thrdparty_settlement_detail, thrdparty_distribution, DUAL, v_settlementDtlSeqNum, thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement, thrdparty_fund_category_code, thrdparty_settlement_category, v_settlementDtlSeqNum, thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement_category, thrdparty_settlement, thrdparty_fund_category_code, v_settlementDtlSeqNum
Business objects	Criteria

SQL referencing this table

• SQL-030: Pk82033_ThirdParty.thrdparty_settlement_insert
• SQL-066: Pk82033_ThirdParty.thrdparty_settlement_select
• SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update
• SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete

---

THRDPARTY_TASK

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	C, D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	THRDPARTY_CASE, company_phone, company_address, company, v_phone_seq, v_fax_seq, v_address_seq, THRDPARTY_FIRM, THRDPARTY_CASE
Business objects	Criteria

SQL referencing this table

• SQL-031: Pk82033_ThirdParty.thrdparty_task_insert
• SQL-045: Pk82033_ThirdParty.selectTasks
• SQL-046: Pk82033_ThirdParty.selectTasksByCase
• SQL-085: Pk82033_ThirdParty.thrdparty_task_update
• SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete
• SQL-097: Pk82033_ThirdParty.thrdparty_task_delete

---

CBP_AUDITED_SERVICE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	thrdparty_case, thrdparty_bill_service, thrdparty_firm, company, person, THRDPARTY_COMPANION_CLAIM, THRDPARTY_ADJUSTER_CODE, v_emplid, THRDPARTY_COMPANION_CLAIM, THRDPARTY_ADJUSTER_CODE, thrdparty_bill_service, v_emplid
Business objects	Criteria

SQL referencing this table

• SQL-034: pk82033_thirdparty.billed_cost_select
• SQL-073: Pk82033_ThirdParty.companion_claim_update
• SQL-088: Pk82033_ThirdParty.companion_claim_delete

---

person

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	D, R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	CBP_AUDITED_SERVICE, thrdparty_case, thrdparty_bill_service, thrdparty_firm, company, thrdparty_case, thrdparty_settlement, thrdparty_firm, company, person_phone, person_address, address, thrdparty_firm, v_person_seq, v_phone_seq, v_fax_seq, v_address_seq, v_firm_seq, v_company_seq
Business objects	Criteria

SQL referencing this table

• SQL-034: pk82033_thirdparty.billed_cost_select
• SQL-038: Pk82033_ThirdParty.claim_pymt_letter_recip_select
• SQL-090: Pk82033_ThirdParty.thrdparty_delete

---

LEGAL ADP EMPLOYEE

Field	Value
Database	Oracle
Schema/Link	LEGAL
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_task, thrdparty_adjuster_code, v_recoveryamount, v_status, v_count, dual, v_person_seq, PERSON_ADDRESS, thrdparty_case, thrdparty_distribution, thrdparty_task, CBP_CPT_SERVICE, v_recoveryamount, v_status, v_count
Business objects	Criteria

SQL referencing this table

• SQL-047: Pk82033_ThirdParty.Statute_Date_List
• SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List

---

v_nonlien_amount

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	thrdparty_case, thrdparty_lien_category, thrdparty_lien, thrdparty_firm, company, thrdparty_distribution, thrdparty_distribution, thrdparty_case, thrdparty_lien_category, thrdparty_lien, thrdpart_distribution_view, thrdparty_distribution_refund, thrdparty_firm, company
Business objects	Criteria

SQL referencing this table

• SQL-050: Pk82033_ThirdParty.thrdparty_dist_refundee_select
• SQL-051: Pk82033_ThirdParty.thrdparty_distribution_select

---

thrdpart_distribution_view

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	thrdparty_distribution, thrdparty_case, thrdparty_lien_category, thrdparty_lien, thrdparty_distribution_refund, thrdparty_firm, company, v_nonlien_amount, WAIVER_DETAIL, thrdparty_distribution, thrdparty_distribution_refund, v_count, THRDPARTY_PREDICTION_DETAIL
Business objects	Criteria

SQL referencing this table

• SQL-051: Pk82033_ThirdParty.thrdparty_distribution_select
• SQL-074: Pk82033_ThirdParty.prediction_detail_update

---

thrdparty_settlement_category

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	thrdparty_case, thrdparty_settlement_detail, thrdparty_fund_category_code, thrdparty_settlement_detail, thrdparty_settlement_detail, thrdparty_settlement, thrdparty_fund_category_code, thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement, thrdparty_fund_category_code, v_settlementDtlSeqNum, v_distributionSeqNum, thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement, thrdparty_fund_category_code, v_settlementDtlSeqNum, v_distributionSeqNum
Business objects	Criteria

SQL referencing this table

• SQL-063: Pk82033_ThirdParty.thrdparty_settl_dtl_cd_select
• SQL-064: Pk82033_ThirdParty.thrdparty_settl_dtl_generate
• SQL-065: Pk82033_ThirdParty.thrdparty_settl_dtl_select
• SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update
• SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete

---

thrdparty_fund_category_code

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	D, R, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	thrdparty_settlement_category, thrdparty_settlement_detail, thrdparty_settlement_detail, thrdparty_settlement_category, thrdparty_settlement, thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement, thrdparty_settlement_category, v_settlementDtlSeqNum, v_distributionSeqNum, thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement_category, thrdparty_settlement, v_settlementDtlSeqNum, v_distributionSeqNum
Business objects	Criteria

SQL referencing this table

• SQL-064: Pk82033_ThirdParty.thrdparty_settl_dtl_generate
• SQL-065: Pk82033_ThirdParty.thrdparty_settl_dtl_select
• SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update
• SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete

---

CBP_CPT_SERVICE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, v_person_seq, PERSON_ADDRESS, thrdparty_case, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, v_recoveryamount, v_status, v_count
Business objects	Criteria

SQL referencing this table

• SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List

---

THRDPARTY_CLOSURE_CODE

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

SQL referencing this table

• SQL-068: SELECT CODE_LONG_DESCR FROM THRDPARTY_CLOSURE_CODE WHERE CODE = '

---

POLICY_ASSIGN

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

SQL referencing this table

• SQL-069: Select POLICY_ASSIGN.EMPLOYEE_CODE as AdjusterCode, POLICY_ASSIGN.POLI

---

THRDPARTY_STATUS_HIST

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

SQL referencing this table

• SQL-070: Select THRDPARTY_STATUS_HIST.CREATE_DATE as CreateDate, THRDPARTY_STAT

---

v_select_count

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

SQL referencing this table

• SQL-078: Pk82033_ThirdParty.thrdparty_expApproval_update
• SQL-079: Pk82033_ThirdParty.thrdparty_expense_update
• SQL-092: Pk82033_ThirdParty.thrdparty_expense_delete

---

company_phone

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	D, U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	dual, phone, v_phone_seq, v_fax_seq, THRDPARTY_FIRM, COMPANY, ADDRESS, company_address, company, THRDPARTY_TASK, v_phone_seq, v_fax_seq, v_address_seq, THRDPARTY_FIRM
Business objects	Criteria

SQL referencing this table

• SQL-080: Pk82033_ThirdParty.thrdparty_firm_update
• SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete

---

v_address_seq

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	D
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	person_phone, person_address, address, thrdparty_firm, v_person_seq, v_phone_seq, v_fax_seq, v_firm_seq, v_company_seq, person, company_phone, company_address, company, THRDPARTY_TASK, v_phone_seq, v_fax_seq, THRDPARTY_FIRM
Business objects	Criteria

SQL referencing this table

• SQL-090: Pk82033_ThirdParty.thrdparty_delete
• SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete

---

v_company_seq

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Supports Criteria data access in this library.
Access pattern	Stored procedure
CRUD operations	D
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	person_phone, person_address, address, thrdparty_firm, v_person_seq, v_phone_seq, v_fax_seq, v_address_seq, v_firm_seq, person
Business objects	Criteria

SQL referencing this table

• SQL-090: Pk82033_ThirdParty.thrdparty_delete

---

thrdparty_distribution_code

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

SQL referencing this table

• SQL-091: Pk82033_ThirdParty.thrdparty_distribution_delete

---

v_descr

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

SQL referencing this table

• SQL-091: Pk82033_ThirdParty.thrdparty_distribution_delete

---

Table relationship diagram

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

erDiagram
    THRDPARTY_CASE ||--o{ thrdparty_note : "case seq"
    THRDPARTY_CASE ||--o{ THRDPARTY_TASK : "case seq"
    THRDPARTY_CASE ||--o{ THRDPARTY_EXPENSE : "case seq"
    THRDPARTY_CASE ||--o{ thrdparty_settlement : "case seq"
    THRDPARTY_CASE ||--o{ THRDPARTY_PREDICTION : "case seq"
    THRDPARTY_CASE ||--o{ THRDPARTY_LIEN : "case seq"
    THRDPARTY_CASE ||--o{ THRDPARTY_LIEN_CATEGORY : "case seq"
    THRDPARTY_CASE ||--o{ THRDPARTY_COMPANION_CLAIM : "case seq"
    THRDPARTY_CASE ||--o{ THRDPARTY_FIRM : "case seq"
    THRDPARTY_CASE ||--o{ thrdparty_claim_cost : "case seq"
    THRDPARTY_CASE ||--o{ TP_CLAIM_COST_CATEGORY_CODE : "case seq"
    THRDPARTY_CASE ||--o{ thrdparty_distribution : "case seq"
    THRDPARTY_CASE ||--o{ thrdparty_distribution_refund : "case seq"
    THRDPARTY_CASE ||--o{ thrdparty_settlement_category : "case seq"
    THRDPARTY_CASE ||--o{ thrdparty_settlement_detail : "case seq"
    THRDPARTY_CASE ||--o{ thrdpart_distribution_view : "case seq"
    THRDPARTY_CASE ||--o{ thrdparty_adjuster_code : "case seq"
    THRDPARTY_CASE }o--o{ ADDRESS : "referenced by case data"
    THRDPARTY_CASE }o--o{ PHONE : "referenced by case data"
    THRDPARTY_CASE }o--o{ COMPANY : "referenced by case data"
    THRDPARTY_CASE }o--o{ PERSON_ADDRESS : "referenced by case data"
    THRDPARTY_CASE }o--o{ person : "referenced by case data"
    THRDPARTY_CASE }o--o{ CBP_AUDITED_SERVICE : "referenced by case data"
    THRDPARTY_CASE }o--o{ CBP_CPT_SERVICE : "referenced by case data"
    THRDPARTY_CASE }o--o{ LEGAL_ADP_EMPLOYEE : "referenced by case data"

The diagram above reflects every relationship documented against THRDPARTY_CASE — the central recovery-case entity — in each table's Related tables field below. Tables that are only cross-referenced with each other (not directly with THRDPARTY_CASE), such as the lien/prediction/settlement/distribution detail tables and shared contact-info tables (ADDRESS, PHONE, COMPANY), are catalogued above with their own Related tables entries but are omitted from this diagram to keep it legible; those pairings largely reflect tables co-referenced within the same stored procedure rather than confirmed foreign-key relationships.

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.Claim.ThirdParty\clsAdjusterAssignment.vb
• Business\SAIF.Business.Claim.ThirdParty\clsBillAuditService.vb
• Business\SAIF.Business.Claim.ThirdParty\clsBillAuditServiceCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsClaimCostCategoryCodeCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsClaimPaymentTransDetail.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdPartyCase.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdPartyTaskCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdpartyClaimCostLetterRecipCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdpartyDistribution.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdpartyDistributionCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdpartyNote.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdpartyNoteCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdpartyRefundeeCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdpartySettlDtlTypeCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdpartyStatusHistCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdpartyStatuteDate.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdpartyTask.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThirdpartyUnitStatPrediction.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdPartyFirm.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdPartyFirmCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdparty.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyCompanionClaim.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyCompanionClaimCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyExpense.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyExpenseApproval.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyExpenseCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyLien.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyLienCategory.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyLienCategoryCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyLienCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyPrediction.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyPredictionCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyPredictionDetail.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartyPredictionDetailCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartySettlement.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartySettlementCollection.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartySettlementDetail.vb
• Business\SAIF.Business.Claim.ThirdParty\clsThrdpartySettlementDetailCollection.vb