SAIF.Business.Claim.ThirdParty SQL catalog¶
This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.
Create operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-017 | Pk82033_ThirdParty.billservice_insert | StoredProc | TP_CLAIM_COST_CATEGORY_CODE, THRDPARTY_BILL_SERVICE | Criteria |
| SQL-018 | Pk82033_ThirdParty.claimCost_insert | StoredProc | THRDPARTY_CLAIM_COST, THRDPARTY_BILL_SERVICE | Criteria |
| SQL-019 | Pk82033_ThirdParty.companion_claim_insert | StoredProc | THRDPARTY_COMPANION_CLAIM, THRDPARTY_ADJUSTER_CODE, v_emplid | Criteria |
| SQL-020 | Pk82033_ThirdParty.prediction_detail_insert | StoredProc | WAIVER_DETAIL, THRDPARTY_PREDICTION_DETAIL, v_count | Criteria |
| SQL-021 | Pk82033_ThirdParty.prediction_insert | StoredProc | THRDPARTY_LIEN, THRDPARTY_PREDICTION, v_lienseqnum | Criteria |
| SQL-022 | pk82033_thirdparty.thrdparty_case_insert | StoredProc | THRDPARTY_CASE | Criteria |
| SQL-023 | Pk82033_ThirdParty.thrdparty_distribution_insert | StoredProc | dual, thrdparty_distribution_refund, thrdparty_distribution, v_refundSeqNum | Criteria |
| SQL-024 | Pk82033_ThirdParty.thrdparty_expense_insert | StoredProc | THRDPARTY_EXPENSE, thrdparty_case | Criteria |
| SQL-025 | Pk82033_ThirdParty.thrdparty_firm_insert | StoredProc | dual, v_firm_seq, COMPANY, THRDPARTY_FIRM, ADDRESS, company_address | Criteria |
| SQL-026 | Pk82033_ThirdParty.thrdparty_insert | StoredProc | dual, v_person_seq, PERSON_ADDRESS, v_phone_seq, PHONE, person_phone, v_fax_seq | Criteria |
| SQL-027 | Pk82033_Thirdparty.thrdparty_lien_category_insert | StoredProc | dual, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_adjuster_code, THRDPARTY_LIEN_CATEGORY, v_recoveryamount, v_status | Criteria |
| SQL-028 | Pk82033_ThirdParty.thrdparty_note_insert | StoredProc | THRDPARTY_EXPENSE, THRDPARTY_CASE, thrdparty_note | Criteria |
| SQL-029 | Pk82033_ThirdParty.thrdparty_settl_dtl_insert | StoredProc | thrdparty_case, thrdparty_settlement_detail, THRDPARTY_CLAIM_COST | Criteria |
| SQL-030 | Pk82033_ThirdParty.thrdparty_settlement_insert | StoredProc | thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement, v_settlementDtlSeqNum, v_distributionSeqNum | Criteria |
| SQL-031 | Pk82033_ThirdParty.thrdparty_task_insert | StoredProc | THRDPARTY_TASK | Criteria |
Read operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-032 | policy_pkg.get_team_mailid | StoredProc | — | clsPolicyNote |
| SQL-033 | sp72155_insert_memo_entry | StoredProc | — | clsPolicyNote |
| SQL-034 | pk82033_thirdparty.billed_cost_select | StoredProc | CBP_AUDITED_SERVICE, thrdparty_case, thrdparty_bill_service, thrdparty_firm, company, person | Criteria |
| SQL-035 | Pk82033_ThirdParty.case_thrdparty_firm_select | StoredProc | THRDPARTY_CASE, phone, address, dual, THRDPARTY_FIRM, company, v_firm_seq | Criteria |
| SQL-036 | Pk82033_ThirdParty.claim_condition_select | StoredProc | — | Criteria |
| SQL-037 | pk82033_thirdparty.claim_payment_select | StoredProc | — | Criteria |
| SQL-038 | Pk82033_ThirdParty.claim_pymt_letter_recip_select | StoredProc | thrdparty_case, thrdparty_settlement, thrdparty_firm, company, person | Criteria |
| SQL-039 | Pk82033_ThirdParty.companion_claim_select | StoredProc | THRDPARTY_COMPANION_CLAIM | Criteria |
| SQL-040 | pk82033_thirdparty.cost_category_select | StoredProc | TP_CLAIM_COST_CATEGORY_CODE, THRDPARTY_PREDICTION | Criteria |
| SQL-041 | Pk82033_ThirdParty.New_Claim_List | StoredProc | — | Criteria |
| SQL-042 | Pk82033_ThirdParty.Open_Case_List | StoredProc | — | Criteria |
| SQL-043 | Pk82033_ThirdParty.prediction_detail_select | StoredProc | THRDPARTY_PREDICTION, THRDPARTY_LIEN, THRDPARTY_PREDICTION_DETAIL | Criteria |
| SQL-044 | Pk82033_ThirdParty.prediction_select | StoredProc | THRDPARTY_PREDICTION | Criteria |
| SQL-045 | Pk82033_ThirdParty.selectTasks | StoredProc | THRDPARTY_TASK | Criteria |
| SQL-046 | Pk82033_ThirdParty.selectTasksByCase | StoredProc | THRDPARTY_TASK | Criteria |
| SQL-047 | Pk82033_ThirdParty.Statute_Date_List | StoredProc | dual, v_person_seq, THRDPARTY_CASE, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, thrdparty_adjuster_code, v_recoveryamount, v_status, v_count | Criteria |
| SQL-048 | Pk82033_ThirdParty.thrdparty_case_search_select | StoredProc | — | Criteria |
| SQL-049 | pk82033_thirdparty.thrdparty_case_select | StoredProc | THRDPARTY_CASE | Criteria |
| SQL-050 | Pk82033_ThirdParty.thrdparty_dist_refundee_select | StoredProc | thrdparty_case, thrdparty_lien_category, thrdparty_lien, thrdparty_firm, company, v_nonlien_amount, thrdparty_distribution | Criteria |
| SQL-051 | Pk82033_ThirdParty.thrdparty_distribution_select | StoredProc | thrdparty_distribution, thrdparty_case, thrdparty_lien_category, thrdparty_lien, thrdpart_distribution_view, thrdparty_distribution_refund, thrdparty_firm, company, v_nonlien_amount | Criteria |
| SQL-052 | Pk82033_ThirdParty.thrdparty_expApproval_select | StoredProc | THRDPARTY_CASE, THRDPARTY_EXPENSE | Criteria |
| SQL-053 | Pk82033_ThirdParty.thrdparty_expense_select | StoredProc | THRDPARTY_EXPENSE, THRDPARTY_CASE | Criteria |
| SQL-054 | Pk82033_ThirdParty.thrdparty_expense_select | StoredProc | THRDPARTY_EXPENSE, THRDPARTY_CASE | Criteria |
| SQL-055 | Pk82033_ThirdParty.thrdparty_firm_select | StoredProc | THRDPARTY_FIRM, THRDPARTY_CASE, phone, address, company | Criteria |
| SQL-056 | Pk82033_Thirdparty.thrdparty_lien_cat_select | StoredProc | THRDPARTY_CASE, thrdparty_lien_category, thrdparty_claim_cost, TP_CLAIM_COST_CATEGORY_CODE, v_claim_id | Criteria |
| SQL-057 | Pk82033_Thirdparty.thrdparty_Lien_select | StoredProc | thrdparty_lien | Criteria |
| SQL-058 | Pk82033_Thirdparty.thrdparty_lien_select_by_Seq | StoredProc | thrdparty_lien, TP_CLAIM_COST_CATEGORY_CODE, thrdparty_claim_cost, THRDPARTY_LIEN_CATEGORY | Criteria |
| SQL-059 | Pk82033_ThirdParty.thrdparty_note_select | StoredProc | thrdparty_note, THRDPARTY_EXPENSE, thrdparty_case | Criteria |
| SQL-060 | Pk82033_ThirdParty.thrdparty_select | StoredProc | phone, address, PERSON, THRDPARTY_FIRM, company | Criteria |
| SQL-061 | Pk82033_ThirdParty.thrdparty_select | StoredProc | phone, address, PERSON, THRDPARTY_FIRM, company | Criteria |
| SQL-062 | Pk82033_ThirdParty.thrdparty_select_firms | StoredProc | phone, address, THRDPARTY_FIRM, company | Criteria |
| SQL-063 | Pk82033_ThirdParty.thrdparty_settl_dtl_cd_select | StoredProc | thrdparty_settlement_category, thrdparty_case, thrdparty_settlement_detail | Criteria |
| SQL-064 | Pk82033_ThirdParty.thrdparty_settl_dtl_generate | StoredProc | thrdparty_settlement_category, thrdparty_fund_category_code, thrdparty_settlement_detail | Criteria |
| SQL-065 | Pk82033_ThirdParty.thrdparty_settl_dtl_select | StoredProc | thrdparty_settlement_detail, thrdparty_settlement_category, thrdparty_settlement, thrdparty_fund_category_code | Criteria |
| SQL-066 | Pk82033_ThirdParty.thrdparty_settlement_select | StoredProc | thrdparty_settlement, thrdparty_settlement_detail, thrdparty_distribution, DUAL, v_settlementDtlSeqNum, v_distributionSeqNum | Criteria |
| SQL-067 | Pk82033_ThirdParty.Unit_Stat_Prediction_List | StoredProc | dual, v_person_seq, PERSON_ADDRESS, thrdparty_case, thrdparty_distribution, thrdparty_task, LEGAL.ADP_EMPLOYEE, CBP_CPT_SERVICE, v_recoveryamount, v_status, v_count | Criteria |
| SQL-068 | Inline read used by Criteria | Inline | THRDPARTY_CLOSURE_CODE | Criteria |
| SQL-069 | Inline read used by Criteria | Inline | POLICY_ASSIGN | Criteria |
| SQL-070 | Inline read used by Criteria | Inline | THRDPARTY_STATUS_HIST | Criteria |
Update operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-071 | Pk82033_ThirdParty.billservice_update | StoredProc | TP_CLAIM_COST_CATEGORY_CODE, THRDPARTY_PREDICTION, THRDPARTY_BILL_SERVICE | Criteria |
| SQL-072 | Pk82033_ThirdParty.claimCost_update | StoredProc | THRDPARTY_BILL_SERVICE, THRDPARTY_CLAIM_COST | Criteria |
| SQL-073 | Pk82033_ThirdParty.companion_claim_update | StoredProc | THRDPARTY_COMPANION_CLAIM, THRDPARTY_ADJUSTER_CODE, CBP_AUDITED_SERVICE, v_emplid | Criteria |
| SQL-074 | Pk82033_ThirdParty.prediction_detail_update | StoredProc | WAIVER_DETAIL, thrdparty_distribution, thrdpart_distribution_view, thrdparty_distribution_refund, v_count, THRDPARTY_PREDICTION_DETAIL | Criteria |
| SQL-075 | Pk82033_ThirdParty.prediction_update | StoredProc | THRDPARTY_LIEN, THRDPARTY_PREDICTION, v_lienseqnum | Criteria |
| SQL-076 | pk82033_thirdparty.thrdparty_case_update | StoredProc | thrdparty_note, thrdparty_case, thrdparty_task, thrdparty_status_hist | Criteria |
| SQL-077 | Pk82033_ThirdParty.thrdparty_distribution_update | StoredProc | dual, thrdparty_distribution | Criteria |
| SQL-078 | Pk82033_ThirdParty.thrdparty_expApproval_update | StoredProc | THRDPARTY_EXPENSE, THRDPARTY_COMPANION_CLAIM, v_select_count, thrdparty_case | Criteria |
| SQL-079 | Pk82033_ThirdParty.thrdparty_expense_update | StoredProc | THRDPARTY_EXPENSE, v_select_count, thrdparty_case | Criteria |
| SQL-080 | Pk82033_ThirdParty.thrdparty_firm_update | StoredProc | dual, company_phone, phone, v_phone_seq, v_fax_seq, THRDPARTY_FIRM, COMPANY, ADDRESS | Criteria |
| SQL-081 | Pk82033_Thirdparty.thrdparty_lien_category_update | StoredProc | v_person_seq, THRDPARTY_CASE, thrdparty_adjuster_code, THRDPARTY_LIEN_CATEGORY | Criteria |
| SQL-082 | Pk82033_ThirdParty.thrdparty_note_update | StoredProc | THRDPARTY_EXPENSE, THRDPARTY_CASE, thrdparty_note | Criteria |
| SQL-083 | Pk82033_ThirdParty.thrdparty_settl_dtl_update | StoredProc | thrdparty_case, THRDPARTY_CLAIM_COST, thrdparty_settlement_detail | Criteria |
| SQL-084 | Pk82033_ThirdParty.thrdparty_settlement_update | StoredProc | thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement, thrdparty_fund_category_code, thrdparty_settlement_category, v_settlementDtlSeqNum, v_distributionSeqNum | Criteria |
| SQL-085 | Pk82033_ThirdParty.thrdparty_task_update | StoredProc | THRDPARTY_CASE, THRDPARTY_TASK | Criteria |
| SQL-086 | Pk82033_ThirdParty.thrdparty_update | StoredProc | dual, person_phone, phone, v_phone_seq, v_fax_seq | Criteria |
| SQL-087 | Pk82033_Thirdparty.Update_THRDPARTY_LIEN_CATEGORY | StoredProc | — | Criteria |
Delete operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-088 | Pk82033_ThirdParty.companion_claim_delete | StoredProc | THRDPARTY_COMPANION_CLAIM, THRDPARTY_ADJUSTER_CODE, CBP_AUDITED_SERVICE, thrdparty_bill_service, v_emplid | Criteria |
| SQL-089 | pk82033_thirdparty.thrdparty_case_delete | StoredProc | thrdparty_note, thrdparty_case, thrdparty_task, thrdparty_status_hist | Criteria |
| SQL-090 | Pk82033_ThirdParty.thrdparty_delete | StoredProc | 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, person | Criteria |
| SQL-091 | Pk82033_ThirdParty.thrdparty_distribution_delete | StoredProc | thrdparty_distribution_refund, DUAL, thrdparty_distribution_code, v_refundSeqNum, v_descr, thrdparty_distribution | Criteria |
| SQL-092 | Pk82033_ThirdParty.thrdparty_expense_delete | StoredProc | THRDPARTY_EXPENSE, THRDPARTY_COMPANION_CLAIM, v_select_count, Thrdparty_case | Criteria |
| SQL-093 | Pk82033_ThirdParty.thrdparty_firm_delete | StoredProc | company_phone, company_address, company, THRDPARTY_TASK, v_phone_seq, v_fax_seq, v_address_seq, THRDPARTY_FIRM | Criteria |
| SQL-094 | Pk82033_ThirdParty.thrdparty_note_delete | StoredProc | THRDPARTY_EXPENSE, THRDPARTY_CASE, thrdparty_note | Criteria |
| SQL-095 | Pk82033_ThirdParty.thrdparty_settl_dtl_delete | StoredProc | thrdparty_case, THRDPARTY_CLAIM_COST, thrdparty_settlement_detail | Criteria |
| SQL-096 | Pk82033_ThirdParty.thrdparty_settlement_delete | StoredProc | thrdparty_settlement_detail, thrdparty_distribution, DUAL, thrdparty_settlement_category, thrdparty_settlement, thrdparty_fund_category_code, v_settlementDtlSeqNum, v_distributionSeqNum | Criteria |
| SQL-097 | Pk82033_ThirdParty.thrdparty_task_delete | StoredProc | THRDPARTY_CASE, THRDPARTY_TASK | Criteria |
Sequence operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-001 | Pk82033_ThirdParty.prediction_new_dtl_categories | StoredProc | THRDPARTY_LIEN, WAIVER_DETAIL, THRDPARTY_PREDICTION_DETAIL, v_count | Criteria |
| SQL-002 | Pk82033_Thirdparty.thrdparty_clm_cost_cat_create | StoredProc | TP_CLAIM_COST_CATEGORY_CODE, thrdparty_claim_cost, THRDPARTY_LIEN_CATEGORY, THRDPARTY_LIEN, THRDPARTY_CASE, v_claim_id | Criteria |
| SQL-003 | Pk82033_Thirdparty.thrdparty_lien_create | StoredProc | THRDPARTY_CASE, dual, thrdparty_lien, v_LienSeq, v_amount | Criteria |
| SQL-004 | Inline sequence used by Criteria | Inline | thrdparty_adjuster_code | Criteria |
| SQL-005 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
| SQL-006 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
| SQL-007 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
| SQL-008 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
| SQL-009 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
| SQL-010 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
| SQL-011 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
| SQL-012 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
| SQL-013 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
| SQL-014 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
| SQL-015 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
| SQL-016 | Inline sequence used by Criteria | Inline | DUAL | Criteria |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Database tables
- Procedures
- API reference
Sources¶
Business\SAIF.Business.Claim.ThirdParty\clsAdjusterAssignment.vbBusiness\SAIF.Business.Claim.ThirdParty\clsBillAuditService.vbBusiness\SAIF.Business.Claim.ThirdParty\clsBillAuditServiceCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsClaimActivityManager.vbBusiness\SAIF.Business.Claim.ThirdParty\clsClaimCostCategoryCodeCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsClaimPaymentTransDetail.vbBusiness\SAIF.Business.Claim.ThirdParty\clsClaimPaymentTransDetailCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsPolicyNote.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdPartyCase.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdPartyNewClaim.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdPartyTaskCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdpartyClaimCostLetterRecipCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdpartyDistribution.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdpartyDistributionCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdpartyNote.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdpartyNoteCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdpartyRefundeeCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdpartySettlDtlTypeCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdpartyStatusHistCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdpartyStatuteDate.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdpartyTask.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThirdpartyUnitStatPrediction.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdPartyFirm.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdPartyFirmCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdparty.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyCaseSearchCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyClaimCondtionCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyCompanionClaim.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyCompanionClaimCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyExpense.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyExpenseApproval.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyExpenseCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyLien.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyLienCategory.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyLienCategoryCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyLienCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyPrediction.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyPredictionCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyPredictionDetail.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartyPredictionDetailCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartySettlement.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartySettlementCollection.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartySettlementDetail.vbBusiness\SAIF.Business.Claim.ThirdParty\clsThrdpartySettlementDetailCollection.vb