SAIF.Business.Claim SQL catalog

This page indexes the SQL statements used by SAIF.Business.Claim.

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-004	Inline create used by Criteria	Inline	CL_1502_DCBS_TRANSFER	Criteria
SQL-005	Inline create used by Criteria	Inline	CL_CLAIM_EMPLOYEE_WORK_ADDRESS	Criteria
SQL-006	Inline create used by Criteria	Inline	CL_CLAIM_WORK_RELEASE_STATUS	Criteria
SQL-007	Inline create used by Criteria	Inline	CL_CLAIM_WORK_STATUS	Criteria
SQL-008	Inline create used by Criteria	Inline	CL_WORKER_INJURED_BODY_PART	Criteria

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-009	Inline read used by clsPPDBodyParts	Inline	CL_PPD_BODY_PART_CODE	clsPPDBodyParts
SQL-010	StringBuilder read used by clsPPDScheduledDegreeAwards	StringBuilder	CL_PPD_SCHED_DEGREE_AWARD	clsPPDScheduledDegreeAwards
SQL-011	StringBuilder read used by clsPPDUnscheduledDegreeAwards	StringBuilder	CL_PPD_UNSCHED_DEGREE_AWARD	clsPPDUnscheduledDegreeAwards
SQL-012	Inline read used by clsVocationalServiceTypes	Inline	CL_RESERVE_VOC_SERV_TYPE_CODE	clsVocationalServiceTypes
SQL-013	Inline read used by Criteria	Inline	CL_BENEFIT_SCHEDULE	Criteria
SQL-014	sp82046_CalcAggRightDates	StoredProc	N/A	Criteria
SQL-015	Inline read used by Criteria	Inline	CL_BENEFIT_PAYMENT	Criteria
SQL-016	Inline read used by Criteria	Inline	CL_BENEFIT_PAYMENT	Criteria
SQL-017	Inline read used by Criteria	Inline	CL_BENEFIT_SCHEDULE	Criteria
SQL-018	Inline read used by Criteria	Inline	CL_CLAIM_EMPLOYEE_WORK_ADDRESS	Criteria
SQL-019	Inline read used by Criteria	Inline	CL_CLAIM_WORK_RELEASE_STATUS	Criteria
SQL-020	Inline read used by Criteria	Inline	CL_CLAIM_WORK_STATUS	Criteria
SQL-021	Inline read used by Criteria	Inline	CL_FEDERAL_AWARD	Criteria
SQL-022	Inline read used by Criteria	Inline	CL_BENEFIT_SCHEDULE	Criteria
SQL-023	sp82067_TimelinessOf1stPayment	StoredProc	N/A	Criteria
SQL-024	sp82289_medicallystationarydt	StoredProc	N/A	Criteria
SQL-025	Inline read used by Criteria	Inline	CL_AWARD	Criteria
SQL-026	sp82286_statutoryweeklywage	StoredProc	N/A	Criteria
SQL-027	Inline read used by Criteria	Inline	CL_WORKER_INJURED_BODY_PART	Criteria

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-028	Inline update used by Criteria	Inline	CLM_DBA.CL_1502_DCBS_TRANSFER	Criteria
SQL-029	Inline update used by Criteria	Inline	CL_BENEFIT_SCHEDULE	Criteria
SQL-030	Inline update used by Criteria	Inline	CL_BENEFIT_PAYMENT	Criteria
SQL-031	Inline update used by Criteria	Inline	CL_BENEFIT_SCHEDULE	Criteria
SQL-032	Inline update used by Criteria	Inline	CL_CLAIM_EMPLOYEE_WORK_ADDRESS	Criteria
SQL-033	Inline update used by Criteria	Inline	CL_CLAIM_WORK_RELEASE_STATUS	Criteria
SQL-034	Inline update used by Criteria	Inline	CL_CLAIM_WORK_STATUS	Criteria
SQL-035	Inline update used by Criteria	Inline	CL_FEDERAL_AWARD	Criteria
SQL-036	Inline update used by Criteria	Inline	CL_BENEFIT_SCHEDULE	Criteria
SQL-037	Inline update used by Criteria	Inline	CL_AWARD	Criteria
SQL-038	Inline update used by Criteria	Inline	CL_WORKER_INJURED_BODY_PART	Criteria

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-039	Inline delete used by Criteria	Inline	CL_1502_DCBS_TRANSFER	Criteria
SQL-040	Inline delete used by Criteria	Inline	CL_BENEFIT_SCHEDULE	Criteria
SQL-041	Inline delete used by Criteria	Inline	CL_BENEFIT_PAYMENT	Criteria
SQL-042	Inline delete used by Criteria	Inline	CL_BENEFIT_SCHEDULE	Criteria
SQL-043	Inline delete used by Criteria	Inline	CL_CLAIM_EMPLOYEE_WORK_ADDRESS	Criteria
SQL-044	Inline delete used by Criteria	Inline	CL_CLAIM_WORK_RELEASE_STATUS	Criteria
SQL-045	Inline delete used by Criteria	Inline	CL_CLAIM_WORK_STATUS	Criteria
SQL-046	Inline delete used by Criteria	Inline	CL_BENEFIT_SCHEDULE	Criteria
SQL-047	Inline delete used by Criteria	Inline	CL_WORKER_INJURED_BODY_PART	Criteria

Sequence operations

SQL ID	Description	Type	Tables	Business object
SQL-001	Inline sequence used by Criteria	Inline	N/A	Criteria
SQL-002	Inline sequence used by Criteria	Inline	N/A	Criteria
SQL-003	Inline sequence used by Criteria	Inline	N/A	Criteria

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• Procedures
• API reference

Sources

• Business\SAIF.Business.Claim\cls1502Transfer.vb
• Business\SAIF.Business.Claim\clsClaimWorkReleaseStatus.vb
• Business\SAIF.Business.Claim\clsClaimWorkStatus.vb
• Business\SAIF.Business.Claim\clsClaimEmployeeWorkAddress.vb
• Business\SAIF.Business.Claim\clsWorkerInjuredBodyPart.vb
• Business\SAIF.Business.Claim\clsPPDBodyParts.vb
• Business\SAIF.Business.Claim\clsPPDScheduledDegreeAwards.vb
• Business\SAIF.Business.Claim\clsPPDUnscheduledDegreeAwards.vb
• Business\SAIF.Business.Claim\clsVocationalServicesTypes.vb
• Business\SAIF.Business.Claim\clsActiveBenefitSchedule.vb
• Business\SAIF.Business.Claim\clsAggRightDates.vb
• Business\SAIF.Business.Claim\clsAwardBenefitPayment.vb
• Business\SAIF.Business.Claim\clsAwardBenefitPaymentCollection.vb
• Business\SAIF.Business.Claim\clsBenefitSchedule.vb
• Business\SAIF.Business.Claim\clsFederalAwardStatusCollection.vb
• Business\SAIF.Business.Claim\clsFederalBenefitSchedule.vb
• Business\SAIF.Business.Claim\clsITimelinessOfFirstPayment.vb
• Business\SAIF.Business.Claim\clsMedicallyStationaryDate.vb
• Business\SAIF.Business.Claim\clsSetAwardPaymentPending.vb
• Business\SAIF.Business.Claim\clsStatutoryWeeklyWageCalculation.vb
• Business\SAIF.Business.Claim\clsWorkerInjuredBodyPartCollection.vb
• Business\SAIF.Business.Claim\clsFederalAwardStatus.vb