Skip to content

SAIF.Business.Claim SQL catalog

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

Create operations

SQL ID Description Type Tables Business object
SQL-004 Insert a new 1502 DCBS transfer record Inline CL_1502_DCBS_TRANSFER cls1502Transfer
SQL-005 Insert a new claim employee work address Inline CL_CLAIM_EMPLOYEE_WORK_ADDRESS clsClaimEmployeeWorkAddress
SQL-006 Insert a new claim work-release-status record Inline CL_CLAIM_WORK_RELEASE_STATUS clsClaimWorkReleaseStatus
SQL-007 Insert a new claim work-status record Inline CL_CLAIM_WORK_STATUS clsClaimWorkStatus
SQL-008 Insert a new injured body-part record Inline CL_WORKER_INJURED_BODY_PART clsWorkerInjuredBodyPart

Read operations

SQL ID Description Type Tables Business object
SQL-009 Retrieve unprocessed 1502 transfers for a claim Inline CL_1502_DCBS_TRANSFER cls1502Transfer
SQL-010 Retrieve all unprocessed 1502 transfers Inline CL_1502_DCBS_TRANSFER cls1502Transfer
SQL-011 Retrieve an active benefit schedule row Inline CL_BENEFIT_SCHEDULE clsActiveBenefitSchedule
SQL-012 Retrieve the benefit payment for an active schedule Inline CL_BENEFIT_PAYMENT clsActiveBenefitSchedule
SQL-013 Calculate aggravation-rights dates Stored Proc N/A clsAggRightDates
SQL-014 Retrieve an in-progress award benefit payment Inline CL_BENEFIT_PAYMENT clsAwardBenefitPayment
SQL-015 Retrieve award benefit payments by benefit type Inline CL_BENEFIT_PAYMENT clsAwardBenefitPaymentCollection
SQL-016 Retrieve a benefit schedule row (twin class) Inline CL_BENEFIT_SCHEDULE clsBenefitSchedule
SQL-017 Retrieve benefit payment for schedule (twin class) Inline CL_BENEFIT_PAYMENT clsBenefitSchedule
SQL-018 Retrieve a claim employee work address Inline CL_CLAIM_EMPLOYEE_WORK_ADDRESS clsClaimEmployeeWorkAddress
SQL-019 Execute caller-supplied dynamic claim-list SQL Inline (caller-determined) clsClaimListGenerator
SQL-020 Retrieve the latest claim work-release-status row Inline CL_CLAIM_WORK_RELEASE_STATUS clsClaimWorkReleaseStatus
SQL-021 Retrieve the latest claim work-status row Inline CL_CLAIM_WORK_STATUS clsClaimWorkStatus
SQL-022 Retrieve federal awards by claim and status Inline CL_FEDERAL_AWARD clsFederalAwardStatusCollection
SQL-023 Retrieve federal awards by worker and status Inline CL_FEDERAL_AWARD, CL_INJURY_CLAIM clsFederalAwardStatusCollection
SQL-024 Retrieve a federal benefit schedule row Inline CL_BENEFIT_SCHEDULE clsFederalBenefitSchedule
SQL-025 Retrieve medically-stationary date Stored Proc N/A clsMedicallyStationaryDate
SQL-026 Retrieve PPD body-part code table Inline CL_PPD_BODY_PART_CODE clsPPDBodyParts
SQL-027 Retrieve PPD scheduled degree-award table Inline CL_PPD_SCHED_DEGREE_AWARD clsPPDScheduledDegreeAwards
SQL-028 Retrieve PPD unscheduled degree-award bands Inline CL_PPD_UNSCHED_DEGREE_AWARD clsPPDUnscheduledDegreeAwards
SQL-029 Retrieve medical reserve service types Inline CL_RESERVE_MED_SERV_TYPE_CODE, CL_RESERVE_MED_SERV_DESCR_CODE clsServiceTypeCollection
SQL-030 Retrieve vocational reserve service types Inline CL_RESERVE_VOC_SERV_COST_CODE, CL_RESERVE_VOC_SERV_DESCR_CODE clsServiceTypeCollection
SQL-031 Retrieve an active award for pending processing Inline CL_AWARD clsSetAwardPaymentPending
SQL-032 Retrieve benefit payments for an award Inline CL_BENEFIT_PAYMENT clsSetAwardPaymentPending
SQL-033 Calculate statutory weekly wage Stored Proc N/A clsStatutoryWeeklyWageCalculation
SQL-034 Calculate timeliness of first payment Stored Proc N/A clsTimelinessOfFirstPayment
SQL-035 Retrieve vocational service type code table Inline CL_RESERVE_VOC_SERV_TYPE_CODE clsVocationalServiceTypes
SQL-036 Retrieve injured body parts for a claim Inline CL_WORKER_INJURED_BODY_PART clsWorkerInjuredBodyPartCollection

Update operations

SQL ID Description Type Tables Business object
SQL-037 Update a 1502 DCBS transfer as processed Inline CL_1502_DCBS_TRANSFER cls1502Transfer
SQL-038 Update an active benefit schedule Inline CL_BENEFIT_SCHEDULE clsActiveBenefitSchedule
SQL-039 Update remaining payment count on a benefit payment (stop processing) Inline CL_BENEFIT_PAYMENT clsActiveBenefitSchedule
SQL-040 Update an award benefit payment issue date Inline CL_BENEFIT_PAYMENT clsAwardBenefitPayment
SQL-041 Update a benefit schedule (twin class) Inline CL_BENEFIT_SCHEDULE clsBenefitSchedule
SQL-042 Update remaining payment count on a benefit payment (twin class) Inline CL_BENEFIT_PAYMENT clsBenefitSchedule
SQL-043 Update a claim employee work address Inline CL_CLAIM_EMPLOYEE_WORK_ADDRESS clsClaimEmployeeWorkAddress
SQL-044 Update a claim work-release-status row Inline CL_CLAIM_WORK_RELEASE_STATUS clsClaimWorkReleaseStatus
SQL-045 Update a claim work-status row Inline CL_CLAIM_WORK_STATUS clsClaimWorkStatus
SQL-046 Update a federal award status Inline CL_FEDERAL_AWARD clsFederalAwardStatus
SQL-047 Update a federal benefit schedule Inline CL_BENEFIT_SCHEDULE clsFederalBenefitSchedule
SQL-048 Set an award status to Pending Inline CL_AWARD clsSetAwardPaymentPending
SQL-049 Move an award's benefit payment to In Progress Inline CL_BENEFIT_PAYMENT clsSetAwardPaymentPending
SQL-050 Update an injured body-part record Inline CL_WORKER_INJURED_BODY_PART clsWorkerInjuredBodyPart
SQL-051 Propagate the primary body part to the injury claim Inline CL_INJURY_CLAIM clsWorkerInjuredBodyPart

Delete operations

SQL ID Description Type Tables Business object
SQL-052 Delete a 1502 DCBS transfer record Inline CL_1502_DCBS_TRANSFER cls1502Transfer
SQL-053 Delete an active benefit schedule Inline CL_BENEFIT_SCHEDULE clsActiveBenefitSchedule
SQL-054 Delete a benefit payment (stop processing) Inline CL_BENEFIT_PAYMENT clsActiveBenefitSchedule
SQL-055 Delete an award benefit payment Inline CL_BENEFIT_PAYMENT clsAwardBenefitPayment
SQL-056 Delete a benefit schedule (twin class) Inline CL_BENEFIT_SCHEDULE clsBenefitSchedule
SQL-057 Delete a benefit payment (twin class stop processing) Inline CL_BENEFIT_PAYMENT clsBenefitSchedule
SQL-058 Delete a claim employee work address Inline CL_CLAIM_EMPLOYEE_WORK_ADDRESS clsClaimEmployeeWorkAddress
SQL-059 Delete a claim work-release-status row Inline CL_CLAIM_WORK_RELEASE_STATUS clsClaimWorkReleaseStatus
SQL-060 Delete a claim work-status row Inline CL_CLAIM_WORK_STATUS clsClaimWorkStatus
SQL-061 Delete a federal benefit schedule Inline CL_BENEFIT_SCHEDULE clsFederalBenefitSchedule
SQL-062 Delete an injured body-part record Inline CL_WORKER_INJURED_BODY_PART clsWorkerInjuredBodyPart

Sequence operations

SQL ID Description Sequence Tables Business object
SQL-001 Get next 1502 transfer sequence value CL_1502_DCBS_TRANSFER_SEQ CL_1502_DCBS_TRANSFER cls1502Transfer
SQL-002 Get next claim work-release-status sequence value CLAIM_WORK_REL_STATUS_SEQ_NUM CL_CLAIM_WORK_RELEASE_STATUS clsClaimWorkReleaseStatus
SQL-003 Get next claim work-status sequence value CLAIM_WORK_STATUS_SEQ CL_CLAIM_WORK_STATUS clsClaimWorkStatus

Sources

  • SAIF.Business.Claim/cls1502Transfer.vb
  • SAIF.Business.Claim/clsActiveBenefitSchedule.vb
  • SAIF.Business.Claim/clsBenefitSchedule.vb