--- title: SAIF.Business.Claim.ThirdParty database tables summary: Database tables used by the SAIF.Business.Claim.ThirdParty library with relationships and usage context. status: draft owner: SAIF last_reviewed: 2026-07-28 library: SAIF.Business.Claim.ThirdParty reference_type: package --- # 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](#thrdparty_lien) | Oracle | [unqualified]** | C, R, U | Supports Criteria data access in this library. | `Criteria` | | [WAIVER_DETAIL](#waiver_detail) | Oracle | [unqualified]** | C, U | Supports Criteria data access in this library. | `Criteria` | | [THRDPARTY_PREDICTION_DETAIL](#thrdparty_prediction_detail) | Oracle | [unqualified]** | C, R, U | Supports Criteria data access in this library. | `Criteria` | | [v_count](#v_count) | Oracle | [unqualified]** | C, R, U | Supports Criteria data access in this library. | `Criteria` | | [TP_CLAIM_COST_CATEGORY_CODE](#tp_claim_cost_category_code) | Oracle | [unqualified]** | C, R, U | Supports Criteria data access in this library. | `Criteria` | | [thrdparty_claim_cost](#thrdparty_claim_cost) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [THRDPARTY_LIEN_CATEGORY](#thrdparty_lien_category) | Oracle | [unqualified]** | C, R, U | Supports Criteria data access in this library. | `Criteria` | | [THRDPARTY_CASE](#thrdparty_case) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [v_claim_id](#v_claim_id) | Oracle | [unqualified]** | C, R | Supports Criteria data access in this library. | `Criteria` | | [dual](#dual) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [v_LienSeq](#v_lienseq) | Oracle | [unqualified]** | C | Supports Criteria data access in this library. | `Criteria` | | [v_amount](#v_amount) | Oracle | [unqualified]** | C | Supports Criteria data access in this library. | `Criteria` | | [thrdparty_adjuster_code](#thrdparty_adjuster_code) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [THRDPARTY_BILL_SERVICE](#thrdparty_bill_service) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [THRDPARTY_COMPANION_CLAIM](#thrdparty_companion_claim) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [v_emplid](#v_emplid) | Oracle | [unqualified]** | C, D, U | Supports Criteria data access in this library. | `Criteria` | | [THRDPARTY_PREDICTION](#thrdparty_prediction) | Oracle | [unqualified]** | C, R, U | Supports Criteria data access in this library. | `Criteria` | | [v_lienseqnum](#v_lienseqnum) | Oracle | [unqualified]** | C, U | Supports Criteria data access in this library. | `Criteria` | | [thrdparty_distribution_refund](#thrdparty_distribution_refund) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [thrdparty_distribution](#thrdparty_distribution) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [v_refundSeqNum](#v_refundseqnum) | Oracle | [unqualified]** | C, D | Supports Criteria data access in this library. | `Criteria` | | [THRDPARTY_EXPENSE](#thrdparty_expense) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [v_firm_seq](#v_firm_seq) | Oracle | [unqualified]** | C, D, R | Supports Criteria data access in this library. | `Criteria` | | [COMPANY](#company) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [THRDPARTY_FIRM](#thrdparty_firm) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [ADDRESS](#address) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [company_address](#company_address) | Oracle | [unqualified]** | C, D | Supports Criteria data access in this library. | `Criteria` | | [v_person_seq](#v_person_seq) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [PERSON_ADDRESS](#person_address) | Oracle | [unqualified]** | C, D, R | Supports Criteria data access in this library. | `Criteria` | | [v_phone_seq](#v_phone_seq) | Oracle | [unqualified]** | C, D, U | Supports Criteria data access in this library. | `Criteria` | | [PHONE](#phone) | Oracle | [unqualified]** | C, R, U | Supports Criteria data access in this library. | `Criteria` | | [person_phone](#person_phone) | Oracle | [unqualified]** | C, D, U | Supports Criteria data access in this library. | `Criteria` | | [v_fax_seq](#v_fax_seq) | Oracle | [unqualified]** | C, D, U | Supports Criteria data access in this library. | `Criteria` | | [v_recoveryamount](#v_recoveryamount) | Oracle | [unqualified]** | C, R | Supports Criteria data access in this library. | `Criteria` | | [v_status](#v_status) | Oracle | [unqualified]** | C, R | Supports Criteria data access in this library. | `Criteria` | | [thrdparty_note](#thrdparty_note) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [thrdparty_settlement_detail](#thrdparty_settlement_detail) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [thrdparty_settlement](#thrdparty_settlement) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [v_settlementDtlSeqNum](#v_settlementdtlseqnum) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [v_distributionSeqNum](#v_distributionseqnum) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [THRDPARTY_TASK](#thrdparty_task) | Oracle | [unqualified]** | C, D, R, U | Supports Criteria data access in this library. | `Criteria` | | [CBP_AUDITED_SERVICE](#cbp_audited_service) | Oracle | [unqualified]** | D, R, U | Supports Criteria data access in this library. | `Criteria` | | [person](#person) | Oracle | [unqualified]** | D, R | Supports Criteria data access in this library. | `Criteria` | | [LEGAL.ADP_EMPLOYEE](#legal-adp-employee) | Oracle | LEGAL | R | Supports Criteria data access in this library. | `Criteria` | | [v_nonlien_amount](#v_nonlien_amount) | Oracle | [unqualified]** | R | Supports Criteria data access in this library. | `Criteria` | | [thrdpart_distribution_view](#thrdpart_distribution_view) | Oracle | [unqualified]** | R, U | Supports Criteria data access in this library. | `Criteria` | | [thrdparty_settlement_category](#thrdparty_settlement_category) | Oracle | [unqualified]** | D, R, U | Supports Criteria data access in this library. | `Criteria` | | [thrdparty_fund_category_code](#thrdparty_fund_category_code) | Oracle | [unqualified]** | D, R, U | Supports Criteria data access in this library. | `Criteria` | | [CBP_CPT_SERVICE](#cbp_cpt_service) | Oracle | [unqualified]** | R | Supports Criteria data access in this library. | `Criteria` | | [THRDPARTY_CLOSURE_CODE](#thrdparty_closure_code) | Oracle | [unqualified]** | R | Supports Criteria data access in this library. | `Criteria` | | [POLICY_ASSIGN](#policy_assign) | Oracle | [unqualified]** | R | Supports Criteria data access in this library. | `Criteria` | | [THRDPARTY_STATUS_HIST](#thrdparty_status_hist) | Oracle | [unqualified]** | D, R, U | Supports Criteria data access in this library. | `Criteria` | | [v_select_count](#v_select_count) | Oracle | [unqualified]** | D, U | Supports Criteria data access in this library. | `Criteria` | | [company_phone](#company_phone) | Oracle | [unqualified]** | D, U | Supports Criteria data access in this library. | `Criteria` | | [v_address_seq](#v_address_seq) | Oracle | [unqualified]** | D | Supports Criteria data access in this library. | `Criteria` | | [v_company_seq](#v_company_seq) | Oracle | [unqualified]** | D | Supports Criteria data access in this library. | `Criteria` | | [thrdparty_distribution_code](#thrdparty_distribution_code) | Oracle | [unqualified]** | D | Supports Criteria data access in this library. | `Criteria` | | [v_descr](#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](operations/manage-liens-and-settlements.md) ### SQL referencing this table - [SQL-001: Pk82033_ThirdParty.prediction_new_dtl_categories](sql/sql-001-pk82033_thirdparty-prediction_new_dtl_categories.md) - [SQL-002: Pk82033_Thirdparty.thrdparty_clm_cost_cat_create](sql/sql-002-pk82033_thirdparty-thrdparty_clm_cost_cat_create.md) - [SQL-021: Pk82033_ThirdParty.prediction_insert](sql/sql-021-pk82033_thirdparty-prediction_insert.md) - [SQL-043: Pk82033_ThirdParty.prediction_detail_select](sql/sql-043-pk82033_thirdparty-prediction_detail_select.md) - [SQL-075: Pk82033_ThirdParty.prediction_update](sql/sql-075-pk82033_thirdparty-prediction_update.md) --- ## 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/sql-001-pk82033_thirdparty-prediction_new_dtl_categories.md) - [SQL-020: Pk82033_ThirdParty.prediction_detail_insert](sql/sql-020-pk82033_thirdparty-prediction_detail_insert.md) - [SQL-074: Pk82033_ThirdParty.prediction_detail_update](sql/sql-074-pk82033_thirdparty-prediction_detail_update.md) --- ## 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](operations/run-case-search-and-predictions.md) ### SQL referencing this table - [SQL-001: Pk82033_ThirdParty.prediction_new_dtl_categories](sql/sql-001-pk82033_thirdparty-prediction_new_dtl_categories.md) - [SQL-020: Pk82033_ThirdParty.prediction_detail_insert](sql/sql-020-pk82033_thirdparty-prediction_detail_insert.md) - [SQL-043: Pk82033_ThirdParty.prediction_detail_select](sql/sql-043-pk82033_thirdparty-prediction_detail_select.md) - [SQL-074: Pk82033_ThirdParty.prediction_detail_update](sql/sql-074-pk82033_thirdparty-prediction_detail_update.md) --- ## 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/sql-001-pk82033_thirdparty-prediction_new_dtl_categories.md) - [SQL-020: Pk82033_ThirdParty.prediction_detail_insert](sql/sql-020-pk82033_thirdparty-prediction_detail_insert.md) - [SQL-047: Pk82033_ThirdParty.Statute_Date_List](sql/sql-047-pk82033_thirdparty-statute_date_list.md) - [SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List](sql/sql-067-pk82033_thirdparty-unit_stat_prediction_list.md) - [SQL-074: Pk82033_ThirdParty.prediction_detail_update](sql/sql-074-pk82033_thirdparty-prediction_detail_update.md) --- ## 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](operations/retrieve-billed-cost-and-payment-details.md) ### SQL referencing this table - [SQL-002: Pk82033_Thirdparty.thrdparty_clm_cost_cat_create](sql/sql-002-pk82033_thirdparty-thrdparty_clm_cost_cat_create.md) - [SQL-017: Pk82033_ThirdParty.billservice_insert](sql/sql-017-pk82033_thirdparty-billservice_insert.md) - [SQL-040: pk82033_thirdparty.cost_category_select](sql/sql-040-pk82033_thirdparty-cost_category_select.md) - [SQL-056: Pk82033_Thirdparty.thrdparty_lien_cat_select](sql/sql-056-pk82033_thirdparty-thrdparty_lien_cat_select.md) - [SQL-058: Pk82033_Thirdparty.thrdparty_lien_select_by_Seq](sql/sql-058-pk82033_thirdparty-thrdparty_lien_select_by_seq.md) - [SQL-071: Pk82033_ThirdParty.billservice_update](sql/sql-071-pk82033_thirdparty-billservice_update.md) --- ## 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/sql-002-pk82033_thirdparty-thrdparty_clm_cost_cat_create.md) - [SQL-056: Pk82033_Thirdparty.thrdparty_lien_cat_select](sql/sql-056-pk82033_thirdparty-thrdparty_lien_cat_select.md) - [SQL-058: Pk82033_Thirdparty.thrdparty_lien_select_by_Seq](sql/sql-058-pk82033_thirdparty-thrdparty_lien_select_by_seq.md) --- ## 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](operations/manage-liens-and-settlements.md) ### SQL referencing this table - [SQL-002: Pk82033_Thirdparty.thrdparty_clm_cost_cat_create](sql/sql-002-pk82033_thirdparty-thrdparty_clm_cost_cat_create.md) - [SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert](sql/sql-027-pk82033_thirdparty-thrdparty_lien_category_insert.md) - [SQL-058: Pk82033_Thirdparty.thrdparty_lien_select_by_Seq](sql/sql-058-pk82033_thirdparty-thrdparty_lien_select_by_seq.md) - [SQL-081: Pk82033_Thirdparty.thrdparty_lien_category_update](sql/sql-081-pk82033_thirdparty-thrdparty_lien_category_update.md) --- ## 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](operations/maintain-recovery-case.md) - [Manage recovery participants](operations/manage-recovery-participants.md) - [Manage expenses](operations/manage-expenses.md) - [Manage liens and settlements](operations/manage-liens-and-settlements.md) - [Manage distributions and refunds](operations/manage-distributions-and-refunds.md) - [Manage notes and tasks](operations/manage-notes-and-tasks.md) - [Run case search and predictions](operations/run-case-search-and-predictions.md) - [Retrieve billed-cost and payment details](operations/retrieve-billed-cost-and-payment-details.md) ### Business rules referencing this table - [BR-006: Case closure loads a closure description](business-rules.md#br-006-case-closure-loads-a-closure-description) ### SQL referencing this table - [SQL-002: Pk82033_Thirdparty.thrdparty_clm_cost_cat_create](sql/sql-002-pk82033_thirdparty-thrdparty_clm_cost_cat_create.md) - [SQL-003: Pk82033_Thirdparty.thrdparty_lien_create](sql/sql-003-pk82033_thirdparty-thrdparty_lien_create.md) - [SQL-022: pk82033_thirdparty.thrdparty_case_insert](sql/sql-022-pk82033_thirdparty-thrdparty_case_insert.md) - [SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert](sql/sql-027-pk82033_thirdparty-thrdparty_lien_category_insert.md) - [SQL-028: Pk82033_ThirdParty.thrdparty_note_insert](sql/sql-028-pk82033_thirdparty-thrdparty_note_insert.md) - [SQL-035: Pk82033_ThirdParty.case_thrdparty_firm_select](sql/sql-035-pk82033_thirdparty-case_thrdparty_firm_select.md) - [SQL-047: Pk82033_ThirdParty.Statute_Date_List](sql/sql-047-pk82033_thirdparty-statute_date_list.md) - [SQL-049: pk82033_thirdparty.thrdparty_case_select](sql/sql-049-pk82033_thirdparty-thrdparty_case_select.md) - [SQL-052: Pk82033_ThirdParty.thrdparty_expApproval_select](sql/sql-052-pk82033_thirdparty-thrdparty_expapproval_select.md) - [SQL-053: Pk82033_ThirdParty.thrdparty_expense_select](sql/sql-053-pk82033_thirdparty-thrdparty_expense_select.md) - [SQL-054: Pk82033_ThirdParty.thrdparty_expense_select](sql/sql-054-pk82033_thirdparty-thrdparty_expense_select.md) - [SQL-055: Pk82033_ThirdParty.thrdparty_firm_select](sql/sql-055-pk82033_thirdparty-thrdparty_firm_select.md) - [SQL-056: Pk82033_Thirdparty.thrdparty_lien_cat_select](sql/sql-056-pk82033_thirdparty-thrdparty_lien_cat_select.md) - [SQL-081: Pk82033_Thirdparty.thrdparty_lien_category_update](sql/sql-081-pk82033_thirdparty-thrdparty_lien_category_update.md) - [SQL-082: Pk82033_ThirdParty.thrdparty_note_update](sql/sql-082-pk82033_thirdparty-thrdparty_note_update.md) - [SQL-085: Pk82033_ThirdParty.thrdparty_task_update](sql/sql-085-pk82033_thirdparty-thrdparty_task_update.md) - [SQL-094: Pk82033_ThirdParty.thrdparty_note_delete](sql/sql-094-pk82033_thirdparty-thrdparty_note_delete.md) - [SQL-097: Pk82033_ThirdParty.thrdparty_task_delete](sql/sql-097-pk82033_thirdparty-thrdparty_task_delete.md) --- ## 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/sql-002-pk82033_thirdparty-thrdparty_clm_cost_cat_create.md) - [SQL-056: Pk82033_Thirdparty.thrdparty_lien_cat_select](sql/sql-056-pk82033_thirdparty-thrdparty_lien_cat_select.md) --- ## 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/sql-003-pk82033_thirdparty-thrdparty_lien_create.md) - [SQL-023: Pk82033_ThirdParty.thrdparty_distribution_insert](sql/sql-023-pk82033_thirdparty-thrdparty_distribution_insert.md) - [SQL-025: Pk82033_ThirdParty.thrdparty_firm_insert](sql/sql-025-pk82033_thirdparty-thrdparty_firm_insert.md) - [SQL-026: Pk82033_ThirdParty.thrdparty_insert](sql/sql-026-pk82033_thirdparty-thrdparty_insert.md) - [SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert](sql/sql-027-pk82033_thirdparty-thrdparty_lien_category_insert.md) - [SQL-035: Pk82033_ThirdParty.case_thrdparty_firm_select](sql/sql-035-pk82033_thirdparty-case_thrdparty_firm_select.md) - [SQL-047: Pk82033_ThirdParty.Statute_Date_List](sql/sql-047-pk82033_thirdparty-statute_date_list.md) - [SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List](sql/sql-067-pk82033_thirdparty-unit_stat_prediction_list.md) - [SQL-077: Pk82033_ThirdParty.thrdparty_distribution_update](sql/sql-077-pk82033_thirdparty-thrdparty_distribution_update.md) - [SQL-080: Pk82033_ThirdParty.thrdparty_firm_update](sql/sql-080-pk82033_thirdparty-thrdparty_firm_update.md) - [SQL-086: Pk82033_ThirdParty.thrdparty_update](sql/sql-086-pk82033_thirdparty-thrdparty_update.md) --- ## 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](sql/sql-003-pk82033_thirdparty-thrdparty_lien_create.md) --- ## 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](sql/sql-003-pk82033_thirdparty-thrdparty_lien_create.md) --- ## 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/sql-004-select.md) - [SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert](sql/sql-027-pk82033_thirdparty-thrdparty_lien_category_insert.md) - [SQL-047: Pk82033_ThirdParty.Statute_Date_List](sql/sql-047-pk82033_thirdparty-statute_date_list.md) - [SQL-081: Pk82033_Thirdparty.thrdparty_lien_category_update](sql/sql-081-pk82033_thirdparty-thrdparty_lien_category_update.md) --- ## 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/sql-017-pk82033_thirdparty-billservice_insert.md) - [SQL-018: Pk82033_ThirdParty.claimCost_insert](sql/sql-018-pk82033_thirdparty-claimcost_insert.md) - [SQL-071: Pk82033_ThirdParty.billservice_update](sql/sql-071-pk82033_thirdparty-billservice_update.md) - [SQL-072: Pk82033_ThirdParty.claimCost_update](sql/sql-072-pk82033_thirdparty-claimcost_update.md) --- ## 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/sql-019-pk82033_thirdparty-companion_claim_insert.md) - [SQL-039: Pk82033_ThirdParty.companion_claim_select](sql/sql-039-pk82033_thirdparty-companion_claim_select.md) - [SQL-073: Pk82033_ThirdParty.companion_claim_update](sql/sql-073-pk82033_thirdparty-companion_claim_update.md) - [SQL-078: Pk82033_ThirdParty.thrdparty_expApproval_update](sql/sql-078-pk82033_thirdparty-thrdparty_expapproval_update.md) - [SQL-088: Pk82033_ThirdParty.companion_claim_delete](sql/sql-088-pk82033_thirdparty-companion_claim_delete.md) - [SQL-092: Pk82033_ThirdParty.thrdparty_expense_delete](sql/sql-092-pk82033_thirdparty-thrdparty_expense_delete.md) --- ## 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/sql-019-pk82033_thirdparty-companion_claim_insert.md) - [SQL-073: Pk82033_ThirdParty.companion_claim_update](sql/sql-073-pk82033_thirdparty-companion_claim_update.md) - [SQL-088: Pk82033_ThirdParty.companion_claim_delete](sql/sql-088-pk82033_thirdparty-companion_claim_delete.md) --- ## 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/sql-021-pk82033_thirdparty-prediction_insert.md) - [SQL-040: pk82033_thirdparty.cost_category_select](sql/sql-040-pk82033_thirdparty-cost_category_select.md) - [SQL-043: Pk82033_ThirdParty.prediction_detail_select](sql/sql-043-pk82033_thirdparty-prediction_detail_select.md) - [SQL-044: Pk82033_ThirdParty.prediction_select](sql/sql-044-pk82033_thirdparty-prediction_select.md) - [SQL-071: Pk82033_ThirdParty.billservice_update](sql/sql-071-pk82033_thirdparty-billservice_update.md) - [SQL-075: Pk82033_ThirdParty.prediction_update](sql/sql-075-pk82033_thirdparty-prediction_update.md) --- ## 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/sql-021-pk82033_thirdparty-prediction_insert.md) - [SQL-075: Pk82033_ThirdParty.prediction_update](sql/sql-075-pk82033_thirdparty-prediction_update.md) --- ## 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/sql-023-pk82033_thirdparty-thrdparty_distribution_insert.md) - [SQL-051: Pk82033_ThirdParty.thrdparty_distribution_select](sql/sql-051-pk82033_thirdparty-thrdparty_distribution_select.md) - [SQL-074: Pk82033_ThirdParty.prediction_detail_update](sql/sql-074-pk82033_thirdparty-prediction_detail_update.md) - [SQL-091: Pk82033_ThirdParty.thrdparty_distribution_delete](sql/sql-091-pk82033_thirdparty-thrdparty_distribution_delete.md) --- ## 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/sql-023-pk82033_thirdparty-thrdparty_distribution_insert.md) - [SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert](sql/sql-027-pk82033_thirdparty-thrdparty_lien_category_insert.md) - [SQL-030: Pk82033_ThirdParty.thrdparty_settlement_insert](sql/sql-030-pk82033_thirdparty-thrdparty_settlement_insert.md) - [SQL-047: Pk82033_ThirdParty.Statute_Date_List](sql/sql-047-pk82033_thirdparty-statute_date_list.md) - [SQL-050: Pk82033_ThirdParty.thrdparty_dist_refundee_select](sql/sql-050-pk82033_thirdparty-thrdparty_dist_refundee_select.md) - [SQL-051: Pk82033_ThirdParty.thrdparty_distribution_select](sql/sql-051-pk82033_thirdparty-thrdparty_distribution_select.md) - [SQL-066: Pk82033_ThirdParty.thrdparty_settlement_select](sql/sql-066-pk82033_thirdparty-thrdparty_settlement_select.md) - [SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List](sql/sql-067-pk82033_thirdparty-unit_stat_prediction_list.md) - [SQL-074: Pk82033_ThirdParty.prediction_detail_update](sql/sql-074-pk82033_thirdparty-prediction_detail_update.md) - [SQL-077: Pk82033_ThirdParty.thrdparty_distribution_update](sql/sql-077-pk82033_thirdparty-thrdparty_distribution_update.md) - [SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update](sql/sql-084-pk82033_thirdparty-thrdparty_settlement_update.md) - [SQL-091: Pk82033_ThirdParty.thrdparty_distribution_delete](sql/sql-091-pk82033_thirdparty-thrdparty_distribution_delete.md) - [SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete](sql/sql-096-pk82033_thirdparty-thrdparty_settlement_delete.md) --- ## 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/sql-023-pk82033_thirdparty-thrdparty_distribution_insert.md) - [SQL-091: Pk82033_ThirdParty.thrdparty_distribution_delete](sql/sql-091-pk82033_thirdparty-thrdparty_distribution_delete.md) --- ## 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](operations/manage-expenses.md) ### SQL referencing this table - [SQL-024: Pk82033_ThirdParty.thrdparty_expense_insert](sql/sql-024-pk82033_thirdparty-thrdparty_expense_insert.md) - [SQL-028: Pk82033_ThirdParty.thrdparty_note_insert](sql/sql-028-pk82033_thirdparty-thrdparty_note_insert.md) - [SQL-052: Pk82033_ThirdParty.thrdparty_expApproval_select](sql/sql-052-pk82033_thirdparty-thrdparty_expapproval_select.md) - [SQL-053: Pk82033_ThirdParty.thrdparty_expense_select](sql/sql-053-pk82033_thirdparty-thrdparty_expense_select.md) - [SQL-054: Pk82033_ThirdParty.thrdparty_expense_select](sql/sql-054-pk82033_thirdparty-thrdparty_expense_select.md) - [SQL-059: Pk82033_ThirdParty.thrdparty_note_select](sql/sql-059-pk82033_thirdparty-thrdparty_note_select.md) - [SQL-078: Pk82033_ThirdParty.thrdparty_expApproval_update](sql/sql-078-pk82033_thirdparty-thrdparty_expapproval_update.md) - [SQL-079: Pk82033_ThirdParty.thrdparty_expense_update](sql/sql-079-pk82033_thirdparty-thrdparty_expense_update.md) - [SQL-082: Pk82033_ThirdParty.thrdparty_note_update](sql/sql-082-pk82033_thirdparty-thrdparty_note_update.md) - [SQL-092: Pk82033_ThirdParty.thrdparty_expense_delete](sql/sql-092-pk82033_thirdparty-thrdparty_expense_delete.md) - [SQL-094: Pk82033_ThirdParty.thrdparty_note_delete](sql/sql-094-pk82033_thirdparty-thrdparty_note_delete.md) --- ## 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/sql-025-pk82033_thirdparty-thrdparty_firm_insert.md) - [SQL-035: Pk82033_ThirdParty.case_thrdparty_firm_select](sql/sql-035-pk82033_thirdparty-case_thrdparty_firm_select.md) - [SQL-090: Pk82033_ThirdParty.thrdparty_delete](sql/sql-090-pk82033_thirdparty-thrdparty_delete.md) --- ## 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/sql-025-pk82033_thirdparty-thrdparty_firm_insert.md) - [SQL-080: Pk82033_ThirdParty.thrdparty_firm_update](sql/sql-080-pk82033_thirdparty-thrdparty_firm_update.md) --- ## 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/sql-025-pk82033_thirdparty-thrdparty_firm_insert.md) - [SQL-035: Pk82033_ThirdParty.case_thrdparty_firm_select](sql/sql-035-pk82033_thirdparty-case_thrdparty_firm_select.md) - [SQL-055: Pk82033_ThirdParty.thrdparty_firm_select](sql/sql-055-pk82033_thirdparty-thrdparty_firm_select.md) - [SQL-060: Pk82033_ThirdParty.thrdparty_select](sql/sql-060-pk82033_thirdparty-thrdparty_select.md) - [SQL-061: Pk82033_ThirdParty.thrdparty_select](sql/sql-061-pk82033_thirdparty-thrdparty_select.md) - [SQL-062: Pk82033_ThirdParty.thrdparty_select_firms](sql/sql-062-pk82033_thirdparty-thrdparty_select_firms.md) - [SQL-080: Pk82033_ThirdParty.thrdparty_firm_update](sql/sql-080-pk82033_thirdparty-thrdparty_firm_update.md) - [SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete](sql/sql-093-pk82033_thirdparty-thrdparty_firm_delete.md) --- ## 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/sql-025-pk82033_thirdparty-thrdparty_firm_insert.md) - [SQL-080: Pk82033_ThirdParty.thrdparty_firm_update](sql/sql-080-pk82033_thirdparty-thrdparty_firm_update.md) --- ## 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/sql-025-pk82033_thirdparty-thrdparty_firm_insert.md) - [SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete](sql/sql-093-pk82033_thirdparty-thrdparty_firm_delete.md) --- ## 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/sql-026-pk82033_thirdparty-thrdparty_insert.md) - [SQL-027: Pk82033_Thirdparty.thrdparty_lien_category_insert](sql/sql-027-pk82033_thirdparty-thrdparty_lien_category_insert.md) - [SQL-047: Pk82033_ThirdParty.Statute_Date_List](sql/sql-047-pk82033_thirdparty-statute_date_list.md) - [SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List](sql/sql-067-pk82033_thirdparty-unit_stat_prediction_list.md) - [SQL-081: Pk82033_Thirdparty.thrdparty_lien_category_update](sql/sql-081-pk82033_thirdparty-thrdparty_lien_category_update.md) - [SQL-090: Pk82033_ThirdParty.thrdparty_delete](sql/sql-090-pk82033_thirdparty-thrdparty_delete.md) --- ## 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/sql-026-pk82033_thirdparty-thrdparty_insert.md) - [SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List](sql/sql-067-pk82033_thirdparty-unit_stat_prediction_list.md) --- ## 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/sql-026-pk82033_thirdparty-thrdparty_insert.md) - [SQL-080: Pk82033_ThirdParty.thrdparty_firm_update](sql/sql-080-pk82033_thirdparty-thrdparty_firm_update.md) - [SQL-086: Pk82033_ThirdParty.thrdparty_update](sql/sql-086-pk82033_thirdparty-thrdparty_update.md) - [SQL-090: Pk82033_ThirdParty.thrdparty_delete](sql/sql-090-pk82033_thirdparty-thrdparty_delete.md) - [SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete](sql/sql-093-pk82033_thirdparty-thrdparty_firm_delete.md) --- ## 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](sql/sql-026-pk82033_thirdparty-thrdparty_insert.md) --- ## 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/sql-026-pk82033_thirdparty-thrdparty_insert.md) - [SQL-086: Pk82033_ThirdParty.thrdparty_update](sql/sql-086-pk82033_thirdparty-thrdparty_update.md) - [SQL-090: Pk82033_ThirdParty.thrdparty_delete](sql/sql-090-pk82033_thirdparty-thrdparty_delete.md) --- ## 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/sql-026-pk82033_thirdparty-thrdparty_insert.md) - [SQL-080: Pk82033_ThirdParty.thrdparty_firm_update](sql/sql-080-pk82033_thirdparty-thrdparty_firm_update.md) - [SQL-086: Pk82033_ThirdParty.thrdparty_update](sql/sql-086-pk82033_thirdparty-thrdparty_update.md) - [SQL-090: Pk82033_ThirdParty.thrdparty_delete](sql/sql-090-pk82033_thirdparty-thrdparty_delete.md) - [SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete](sql/sql-093-pk82033_thirdparty-thrdparty_firm_delete.md) --- ## 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/sql-027-pk82033_thirdparty-thrdparty_lien_category_insert.md) - [SQL-047: Pk82033_ThirdParty.Statute_Date_List](sql/sql-047-pk82033_thirdparty-statute_date_list.md) - [SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List](sql/sql-067-pk82033_thirdparty-unit_stat_prediction_list.md) --- ## 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/sql-027-pk82033_thirdparty-thrdparty_lien_category_insert.md) - [SQL-047: Pk82033_ThirdParty.Statute_Date_List](sql/sql-047-pk82033_thirdparty-statute_date_list.md) - [SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List](sql/sql-067-pk82033_thirdparty-unit_stat_prediction_list.md) --- ## 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/sql-028-pk82033_thirdparty-thrdparty_note_insert.md) - [SQL-059: Pk82033_ThirdParty.thrdparty_note_select](sql/sql-059-pk82033_thirdparty-thrdparty_note_select.md) - [SQL-076: pk82033_thirdparty.thrdparty_case_update](sql/sql-076-pk82033_thirdparty-thrdparty_case_update.md) - [SQL-082: Pk82033_ThirdParty.thrdparty_note_update](sql/sql-082-pk82033_thirdparty-thrdparty_note_update.md) - [SQL-089: pk82033_thirdparty.thrdparty_case_delete](sql/sql-089-pk82033_thirdparty-thrdparty_case_delete.md) - [SQL-094: Pk82033_ThirdParty.thrdparty_note_delete](sql/sql-094-pk82033_thirdparty-thrdparty_note_delete.md) --- ## 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/sql-029-pk82033_thirdparty-thrdparty_settl_dtl_insert.md) - [SQL-030: Pk82033_ThirdParty.thrdparty_settlement_insert](sql/sql-030-pk82033_thirdparty-thrdparty_settlement_insert.md) - [SQL-063: Pk82033_ThirdParty.thrdparty_settl_dtl_cd_select](sql/sql-063-pk82033_thirdparty-thrdparty_settl_dtl_cd_select.md) - [SQL-064: Pk82033_ThirdParty.thrdparty_settl_dtl_generate](sql/sql-064-pk82033_thirdparty-thrdparty_settl_dtl_generate.md) - [SQL-065: Pk82033_ThirdParty.thrdparty_settl_dtl_select](sql/sql-065-pk82033_thirdparty-thrdparty_settl_dtl_select.md) - [SQL-066: Pk82033_ThirdParty.thrdparty_settlement_select](sql/sql-066-pk82033_thirdparty-thrdparty_settlement_select.md) - [SQL-083: Pk82033_ThirdParty.thrdparty_settl_dtl_update](sql/sql-083-pk82033_thirdparty-thrdparty_settl_dtl_update.md) - [SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update](sql/sql-084-pk82033_thirdparty-thrdparty_settlement_update.md) - [SQL-095: Pk82033_ThirdParty.thrdparty_settl_dtl_delete](sql/sql-095-pk82033_thirdparty-thrdparty_settl_dtl_delete.md) - [SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete](sql/sql-096-pk82033_thirdparty-thrdparty_settlement_delete.md) --- ## 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/sql-030-pk82033_thirdparty-thrdparty_settlement_insert.md) - [SQL-038: Pk82033_ThirdParty.claim_pymt_letter_recip_select](sql/sql-038-pk82033_thirdparty-claim_pymt_letter_recip_select.md) - [SQL-065: Pk82033_ThirdParty.thrdparty_settl_dtl_select](sql/sql-065-pk82033_thirdparty-thrdparty_settl_dtl_select.md) - [SQL-066: Pk82033_ThirdParty.thrdparty_settlement_select](sql/sql-066-pk82033_thirdparty-thrdparty_settlement_select.md) - [SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update](sql/sql-084-pk82033_thirdparty-thrdparty_settlement_update.md) - [SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete](sql/sql-096-pk82033_thirdparty-thrdparty_settlement_delete.md) --- ## 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/sql-030-pk82033_thirdparty-thrdparty_settlement_insert.md) - [SQL-066: Pk82033_ThirdParty.thrdparty_settlement_select](sql/sql-066-pk82033_thirdparty-thrdparty_settlement_select.md) - [SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update](sql/sql-084-pk82033_thirdparty-thrdparty_settlement_update.md) - [SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete](sql/sql-096-pk82033_thirdparty-thrdparty_settlement_delete.md) --- ## 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/sql-030-pk82033_thirdparty-thrdparty_settlement_insert.md) - [SQL-066: Pk82033_ThirdParty.thrdparty_settlement_select](sql/sql-066-pk82033_thirdparty-thrdparty_settlement_select.md) - [SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update](sql/sql-084-pk82033_thirdparty-thrdparty_settlement_update.md) - [SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete](sql/sql-096-pk82033_thirdparty-thrdparty_settlement_delete.md) --- ## 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/sql-031-pk82033_thirdparty-thrdparty_task_insert.md) - [SQL-045: Pk82033_ThirdParty.selectTasks](sql/sql-045-pk82033_thirdparty-selecttasks.md) - [SQL-046: Pk82033_ThirdParty.selectTasksByCase](sql/sql-046-pk82033_thirdparty-selecttasksbycase.md) - [SQL-085: Pk82033_ThirdParty.thrdparty_task_update](sql/sql-085-pk82033_thirdparty-thrdparty_task_update.md) - [SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete](sql/sql-093-pk82033_thirdparty-thrdparty_firm_delete.md) - [SQL-097: Pk82033_ThirdParty.thrdparty_task_delete](sql/sql-097-pk82033_thirdparty-thrdparty_task_delete.md) --- ## 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/sql-034-pk82033_thirdparty-billed_cost_select.md) - [SQL-073: Pk82033_ThirdParty.companion_claim_update](sql/sql-073-pk82033_thirdparty-companion_claim_update.md) - [SQL-088: Pk82033_ThirdParty.companion_claim_delete](sql/sql-088-pk82033_thirdparty-companion_claim_delete.md) --- ## 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/sql-034-pk82033_thirdparty-billed_cost_select.md) - [SQL-038: Pk82033_ThirdParty.claim_pymt_letter_recip_select](sql/sql-038-pk82033_thirdparty-claim_pymt_letter_recip_select.md) - [SQL-090: Pk82033_ThirdParty.thrdparty_delete](sql/sql-090-pk82033_thirdparty-thrdparty_delete.md) --- ## 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/sql-047-pk82033_thirdparty-statute_date_list.md) - [SQL-067: Pk82033_ThirdParty.Unit_Stat_Prediction_List](sql/sql-067-pk82033_thirdparty-unit_stat_prediction_list.md) --- ## 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/sql-050-pk82033_thirdparty-thrdparty_dist_refundee_select.md) - [SQL-051: Pk82033_ThirdParty.thrdparty_distribution_select](sql/sql-051-pk82033_thirdparty-thrdparty_distribution_select.md) --- ## 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/sql-051-pk82033_thirdparty-thrdparty_distribution_select.md) - [SQL-074: Pk82033_ThirdParty.prediction_detail_update](sql/sql-074-pk82033_thirdparty-prediction_detail_update.md) --- ## 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/sql-063-pk82033_thirdparty-thrdparty_settl_dtl_cd_select.md) - [SQL-064: Pk82033_ThirdParty.thrdparty_settl_dtl_generate](sql/sql-064-pk82033_thirdparty-thrdparty_settl_dtl_generate.md) - [SQL-065: Pk82033_ThirdParty.thrdparty_settl_dtl_select](sql/sql-065-pk82033_thirdparty-thrdparty_settl_dtl_select.md) - [SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update](sql/sql-084-pk82033_thirdparty-thrdparty_settlement_update.md) - [SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete](sql/sql-096-pk82033_thirdparty-thrdparty_settlement_delete.md) --- ## 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/sql-064-pk82033_thirdparty-thrdparty_settl_dtl_generate.md) - [SQL-065: Pk82033_ThirdParty.thrdparty_settl_dtl_select](sql/sql-065-pk82033_thirdparty-thrdparty_settl_dtl_select.md) - [SQL-084: Pk82033_ThirdParty.thrdparty_settlement_update](sql/sql-084-pk82033_thirdparty-thrdparty_settlement_update.md) - [SQL-096: Pk82033_ThirdParty.thrdparty_settlement_delete](sql/sql-096-pk82033_thirdparty-thrdparty_settlement_delete.md) --- ## 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](sql/sql-067-pk82033_thirdparty-unit_stat_prediction_list.md) --- ## 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 = '](sql/sql-068-select.md) --- ## 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](sql/sql-069-select.md) --- ## 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](sql/sql-070-select.md) --- ## 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/sql-078-pk82033_thirdparty-thrdparty_expapproval_update.md) - [SQL-079: Pk82033_ThirdParty.thrdparty_expense_update](sql/sql-079-pk82033_thirdparty-thrdparty_expense_update.md) - [SQL-092: Pk82033_ThirdParty.thrdparty_expense_delete](sql/sql-092-pk82033_thirdparty-thrdparty_expense_delete.md) --- ## 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/sql-080-pk82033_thirdparty-thrdparty_firm_update.md) - [SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete](sql/sql-093-pk82033_thirdparty-thrdparty_firm_delete.md) --- ## 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/sql-090-pk82033_thirdparty-thrdparty_delete.md) - [SQL-093: Pk82033_ThirdParty.thrdparty_firm_delete](sql/sql-093-pk82033_thirdparty-thrdparty_firm_delete.md) --- ## 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](sql/sql-090-pk82033_thirdparty-thrdparty_delete.md) --- ## 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](sql/sql-091-pk82033_thirdparty-thrdparty_distribution_delete.md) --- ## 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](sql/sql-091-pk82033_thirdparty-thrdparty_distribution_delete.md) --- ## Table relationship diagram The following diagram shows relationships between tables used by this library. ```mermaid 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](index.md) - [Overview](overview.md) - [Architecture](architecture.md) - [Dependencies](dependencies.md) - [Operations and processes](operations-processes.md) - [Business rules](business-rules.md) - [SQL catalog](sql/index.md) - [Procedures](procedures/index.md) - [API reference](api/index.md) > **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`