SAIF.Business.Claim.Payment SQL catalog¶
This page indexes SQL statements and stored-procedure calls used by SAIF.Business.Claim.Payment.
Create operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-007 | StoredProc create used by Criteria | StoredProc | N/A | Criteria |
| SQL-008 | StoredProc create used by Criteria | StoredProc | N/A | Criteria |
| SQL-009 | Inline create used by CriteriaBase | Inline | CL_AWARD | CriteriaBase |
| SQL-010 | Inline create used by CriteriaBase | Inline | CL_BENEFIT_PAYMENT | CriteriaBase |
| SQL-011 | Inline create used by clsAwardCollection | Inline | CL_AWARD | clsAwardCollection |
| SQL-012 | Inline create used by clsAwardPayeeInfo | Inline | CL_STATE_AWARD_MONTHLY_PAYEE | clsAwardPayeeInfo |
| SQL-013 | Inline create used by clsAwardSSOffset | Inline | CL_AWARD_SS_OFFSET | clsAwardSSOffset |
| SQL-014 | StoredProc create used by clsBenefitPeriod | StoredProc | N/A | clsBenefitPeriod |
| SQL-015 | StoredProc create used by clsBenefitRemark | StoredProc | N/A | clsBenefitRemark |
| SQL-016 | StoredProc create used by clsBenefitSchedule | StoredProc | N/A | clsBenefitSchedule |
| SQL-017 | Inline create used by clsBillPaymentAdjustment | Inline | CL_FINANCIAL_TRANS_BILL_ADJUST | clsBillPaymentAdjustment |
| SQL-018 | Inline create used by clsClaimTimelossCalculation | Inline | CL_CLAIM_TIMELOSS_CALCULATION | clsClaimTimelossCalculation |
| SQL-019 | StoredProc create used by clsFinancialTranRemark | StoredProc | N/A | clsFinancialTranRemark |
| SQL-020 | StoredProc create used by clsFinancialTransDtl | StoredProc | N/A | clsFinancialTransDtl |
| SQL-021 | Inline create used by clsOffsetWageCalcPeriod | Inline | CL_OFFSET_CALC_PERIOD | clsOffsetWageCalcPeriod |
| SQL-022 | Inline create used by clsOffsetWageCalculation | Inline | CL_OFFSET_WAGE_CALCULATION | clsOffsetWageCalculation |
| SQL-023 | StoredProc create used by clsPaymentPosting | StoredProc | N/A | clsPaymentPosting |
| SQL-024 | Inline create used by clsPaymentTotalManager | Inline | CL_PAYMENT_TOTAL | clsPaymentTotalManager |
| SQL-025 | Inline create used by clsSecTimelossCalculation | Inline | CL_SEC_TIMELOSS_CALCULATION | clsSecTimelossCalculation |
| SQL-026 | Inline create used by clsSecWageCalcPeriodEarnings | Inline | CL_SEC_WAGE_CALC_PER_EARNINGS | clsSecWageCalcPeriodEarnings |
| SQL-027 | Inline create used by clsSecWageCalculationPeriod | Inline | CL_SEC_WAGE_CALCULATION_PERIOD | clsSecWageCalculationPeriod |
| SQL-028 | Inline create used by clsSupplementalWagePeriod | Inline | CL_SEC_WAGE_EARNINGS | clsSupplementalWagePeriod |
| SQL-029 | Inline create used by clsWageCalcPeriodEarnings | Inline | CL_WAGE_CALC_PERIOD_EARNINGS | clsWageCalcPeriodEarnings |
| SQL-030 | Inline create used by clsWageCalculationPeriod | Inline | CL_WAGE_CALCULATION_PERIOD | clsWageCalculationPeriod |
Read operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-031 | StoredProc read used by Criteria | StoredProc | N/A | Criteria |
| SQL-032 | Inline read used by CriteriaBase | Inline | CL_AWARD | CriteriaBase |
| SQL-033 | Inline read used by CriteriaBase | Inline | CL_AWARD | CriteriaBase |
| SQL-034 | Inline read used by CriteriaBase | Inline | — | CriteriaBase |
| SQL-035 | Inline read used by FinancialTransTypeCodes | Inline | CL_FINANCIAL_TRANS_TYPE_CODE | FinancialTransTypeCodes |
| SQL-036 | Inline read used by PreviousPaidInfo | Inline | CBP_AUDITED_SERVICE_ADJUSTMENT | PreviousPaidInfo |
| SQL-037 | Inline read used by RecoveryTypeCodes | Inline | CL_RECOVERY_TYPE_CODE | RecoveryTypeCodes |
| SQL-038 | Inline read used by SpecialHandlingCodes | Inline | CL_PAYMENT_SPCL_HANDLING_CODE | SpecialHandlingCodes |
| SQL-039 | Inline read used by clsAward | Inline | CL_AWARD | clsAward |
| SQL-040 | Inline read used by clsAward | Inline | CL_BENEFIT_PAYMENT | clsAward |
| SQL-041 | Inline read used by clsAward | Inline | CL_CLAIM_CLOSURE_ORDER | clsAward |
| SQL-042 | Inline read used by clsAward | Inline | CL_FINANCIAL_TRANS | clsAward |
| SQL-043 | Inline read used by clsAward | Inline | CL_FINANCIAL_TRANS | clsAward |
| SQL-044 | Inline read used by clsAwardCollection | Inline | CL_AWARD | clsAwardCollection |
| SQL-045 | Inline read used by clsAwardPayeeInfo | Inline | CL_STATE_AWARD_MONTHLY_PAYEE | clsAwardPayeeInfo |
| SQL-046 | Inline read used by clsAwardSSOffsetCollection | Inline | CL_AWARD_SS_OFFSET | clsAwardSSOffsetCollection |
| SQL-047 | StoredProc read used by clsBenefitPeriodCollection | StoredProc | N/A | clsBenefitPeriodCollection |
| SQL-048 | Inline read used by clsBenefitRemark | Inline | — | clsBenefitRemark |
| SQL-049 | StoredProc read used by clsBenefitRemark | StoredProc | N/A | clsBenefitRemark |
| SQL-050 | StoredProc read used by clsBenefitSchedule | StoredProc | N/A | clsBenefitSchedule |
| SQL-051 | Inline read used by clsClaimTimelossCalculationCollection | Inline | CL_CLAIM_TIMELOSS_CALCULATION | clsClaimTimelossCalculationCollection |
| SQL-052 | Inline read used by clsClosureOrderInfo | Inline | — | clsClosureOrderInfo |
| SQL-053 | Inline read used by clsEmployerRefundPayment | Inline | CLAIM_NON_DISAB_REIMB_MAX | clsEmployerRefundPayment |
| SQL-054 | StoredProc read used by clsFinancialTranRemark | StoredProc | N/A | clsFinancialTranRemark |
| SQL-055 | Inline read used by clsFinancialTransCollection | Inline | CL_FINANCIAL_TRANS | clsFinancialTransCollection |
| SQL-056 | Inline read used by clsFinancialTransCollection | Inline | CL_FINANCIAL_TRANS | clsFinancialTransCollection |
| SQL-057 | Inline read used by clsFinancialTransCollection | Inline | CL_FINANCIAL_TRANS | clsFinancialTransCollection |
| SQL-058 | StoredProc read used by clsFinancialTransCollection | StoredProc | N/A | clsFinancialTransCollection |
| SQL-059 | StoredProc read used by clsFinancialTransCollection | StoredProc | N/A | clsFinancialTransCollection |
| SQL-060 | StoredProc read used by clsFinancialTransCollection | StoredProc | N/A | clsFinancialTransCollection |
| SQL-061 | StoredProc read used by clsFinancialTransCollection | StoredProc | N/A | clsFinancialTransCollection |
| SQL-062 | StoredProc read used by clsFinancialTransCollection | StoredProc | N/A | clsFinancialTransCollection |
| SQL-063 | StoredProc read used by clsFinancialTransCollection | StoredProc | N/A | clsFinancialTransCollection |
| SQL-064 | StoredProc read used by clsFinancialTransCollection | StoredProc | N/A | clsFinancialTransCollection |
| SQL-065 | Inline read used by clsFinancialTransCollection | Inline | CL_FINANCIAL_TRANS | clsFinancialTransCollection |
| SQL-066 | Inline read used by clsInjuryClaimWageAndJob | Inline | CL_INJURY_CLAIM | clsInjuryClaimWageAndJob |
| SQL-067 | Inline read used by clsNDRClaimAmountsResponse | Inline | CLAIM_NON_DISAB_REIMB_MAX, CL_FINANCIAL_TRANS_DTL, CL_INJURY_CLAIM | clsNDRClaimAmountsResponse |
| SQL-068 | Inline read used by clsOffsetWageCalcPeriods | Inline | CL_OFFSET_CALC_PERIOD | clsOffsetWageCalcPeriods |
| SQL-069 | Inline read used by clsOffsetWageCalculation | Inline | CL_OFFSET_WAGE_CALCULATION | clsOffsetWageCalculation |
| SQL-070 | Inline read used by clsPayeeCollection | Inline | CL_BENEFIT_PAYEE | clsPayeeCollection |
| SQL-071 | Inline read used by clsPaymentBase | Inline | CL_CLAIM_STATUS_ACTIVITY | clsPaymentBase |
| SQL-072 | Inline read used by clsPaymentBase | Inline | PAYMENT_TRANSACTION_TYPE_CODE | clsPaymentBase |
| SQL-073 | StoredProc read used by clsPaymentListCollection | StoredProc | N/A | clsPaymentListCollection |
| SQL-074 | StoredProc read used by clsPaymentListCollection | StoredProc | N/A | clsPaymentListCollection |
| SQL-075 | StoredProc read used by clsPaymentListCollection | StoredProc | N/A | clsPaymentListCollection |
| SQL-076 | Inline read used by clsPaymentPostingCollection | Inline | CL_PAYMENT_POSTING | clsPaymentPostingCollection |
| SQL-077 | StoredProc read used by clsPaymentPostingCollection | StoredProc | N/A | clsPaymentPostingCollection |
| SQL-078 | Inline read used by clsPaymentTotalManager | Inline | CL_PAYMENT_TOTAL | clsPaymentTotalManager |
| SQL-079 | Inline read used by clsSecTimelossCalculationCollection | Inline | CL_SEC_TIMELOSS_CALCULATION | clsSecTimelossCalculationCollection |
| SQL-080 | Inline read used by clsSecWageCalcPeriodEarningsCollection | Inline | CL_SEC_WAGE_CALC_PER_EARNINGS | clsSecWageCalcPeriodEarningsCollection |
| SQL-081 | Inline read used by clsSecWageCalculationPeriodCollection | Inline | CL_SEC_WAGE_CALCULATION_PERIOD | clsSecWageCalculationPeriodCollection |
| SQL-082 | Inline read used by clsSupplementalWagePeriods | Inline | CL_SEC_WAGE_EARNINGS | clsSupplementalWagePeriods |
| SQL-083 | Inline read used by clsSupplementalWages | Inline | CL_SEC_TIMELOSS_CALCULATION | clsSupplementalWages |
| SQL-084 | Inline read used by clsSupportPayee | Inline | CL_CLAIM_SUPPORT_ORDER | clsSupportPayee |
| SQL-085 | Inline read used by clsSupportPayee | Inline | CL_CLAIM_SUPPORT_ORDER | clsSupportPayee |
| SQL-086 | Inline read used by clsSupportPayee | Inline | CL_CLAIM_SUPPORT_ORDER | clsSupportPayee |
| SQL-087 | Inline read used by clsSupportPayee | Inline | CL_CLAIM_SUPPORT_ORDER | clsSupportPayee |
| SQL-088 | Inline read used by clsWageCalcPeriodEarningsCollection | Inline | CL_WAGE_CALC_PERIOD_EARNINGS | clsWageCalcPeriodEarningsCollection |
| SQL-089 | Inline read used by clsWageCalculationPeriodCollection | Inline | CL_WAGE_CALCULATION_PERIOD | clsWageCalculationPeriodCollection |
Update operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-090 | StoredProc update used by Criteria | StoredProc | N/A | Criteria |
| SQL-091 | StoredProc update used by Criteria | StoredProc | N/A | Criteria |
| SQL-092 | Inline update used by CriteriaBase | Inline | CL_AWARD | CriteriaBase |
| SQL-093 | Inline update used by CriteriaBase | Inline | CL_BENEFIT_PAYMENT | CriteriaBase |
| SQL-094 | Inline update used by clsAwardCollection | Inline | CL_AWARD | clsAwardCollection |
| SQL-095 | Inline update used by clsAwardPayeeInfo | Inline | CL_STATE_AWARD_MONTHLY_PAYEE | clsAwardPayeeInfo |
| SQL-096 | Inline update used by clsAwardSSOffset | Inline | CL_AWARD_SS_OFFSET | clsAwardSSOffset |
| SQL-097 | StoredProc update used by clsBenefitPeriod | StoredProc | N/A | clsBenefitPeriod |
| SQL-098 | StoredProc update used by clsBenefitRemark | StoredProc | N/A | clsBenefitRemark |
| SQL-099 | StoredProc update used by clsBenefitSchedule | StoredProc | N/A | clsBenefitSchedule |
| SQL-100 | Inline update used by clsClaimTimelossCalculation | Inline | CL_CLAIM_TIMELOSS_CALCULATION | clsClaimTimelossCalculation |
| SQL-101 | StoredProc update used by clsFinancialTranRemark | StoredProc | N/A | clsFinancialTranRemark |
| SQL-102 | StoredProc update used by clsFinancialTransCollection | StoredProc | N/A | clsFinancialTransCollection |
| SQL-103 | Inline update used by clsInjuryClaimWageAndJob | Inline | CL_INJURY_CLAIM | clsInjuryClaimWageAndJob |
| SQL-104 | Inline update used by clsOffsetWageCalcPeriod | Inline | CL_OFFSET_CALC_PERIOD | clsOffsetWageCalcPeriod |
| SQL-105 | Inline update used by clsOffsetWageCalculation | Inline | CL_OFFSET_WAGE_CALCULATION | clsOffsetWageCalculation |
| SQL-106 | Inline update used by clsSecTimelossCalculation | Inline | CL_SEC_TIMELOSS_CALCULATION | clsSecTimelossCalculation |
| SQL-107 | Inline update used by clsSecWageCalcPeriodEarnings | Inline | CL_SEC_WAGE_CALC_PER_EARNINGS | clsSecWageCalcPeriodEarnings |
| SQL-108 | Inline update used by clsSecWageCalculationPeriod | Inline | CL_SEC_WAGE_CALCULATION_PERIOD | clsSecWageCalculationPeriod |
| SQL-109 | Inline update used by clsSettlementPayment | Inline | CL_INJURY_CLAIM | clsSettlementPayment |
| SQL-110 | Inline update used by clsSettlementPayment | Inline | CL_INJURY_CLAIM | clsSettlementPayment |
| SQL-111 | Inline update used by clsSupplementalWagePeriod | Inline | CL_SEC_WAGE_EARNINGS | clsSupplementalWagePeriod |
| SQL-112 | Inline update used by clsWageCalcPeriodEarnings | Inline | CL_WAGE_CALC_PERIOD_EARNINGS | clsWageCalcPeriodEarnings |
| SQL-113 | Inline update used by clsWageCalculationPeriod | Inline | CL_WAGE_CALCULATION_PERIOD | clsWageCalculationPeriod |
Delete operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-114 | StoredProc delete used by Criteria | StoredProc | N/A | Criteria |
| SQL-115 | Inline delete used by CriteriaBase | Inline | — | CriteriaBase |
| SQL-116 | Inline delete used by CriteriaBase | Inline | — | CriteriaBase |
| SQL-117 | Inline delete used by clsAwardCollection | Inline | — | clsAwardCollection |
| SQL-118 | Inline delete used by clsAwardPayeeInfo | Inline | — | clsAwardPayeeInfo |
| SQL-119 | Inline delete used by clsAwardSSOffset | Inline | — | clsAwardSSOffset |
| SQL-120 | StoredProc delete used by clsBenefitPeriod | StoredProc | N/A | clsBenefitPeriod |
| SQL-121 | StoredProc delete used by clsBenefitRemark | StoredProc | N/A | clsBenefitRemark |
| SQL-122 | StoredProc delete used by clsBenefitSchedule | StoredProc | N/A | clsBenefitSchedule |
| SQL-123 | Inline delete used by clsClaimTimelossCalculation | Inline | — | clsClaimTimelossCalculation |
| SQL-124 | StoredProc delete used by clsFinancialTranRemark | StoredProc | N/A | clsFinancialTranRemark |
| SQL-125 | Inline delete used by clsFinancialTransDtl | Inline | — | clsFinancialTransDtl |
| SQL-126 | Inline delete used by clsOffsetWageCalcPeriod | Inline | — | clsOffsetWageCalcPeriod |
| SQL-127 | Inline delete used by clsOffsetWageCalculation | Inline | — | clsOffsetWageCalculation |
| SQL-128 | Inline delete used by clsSecTimelossCalculation | Inline | — | clsSecTimelossCalculation |
| SQL-129 | Inline delete used by clsSecWageCalcPeriodEarnings | Inline | — | clsSecWageCalcPeriodEarnings |
| SQL-130 | Inline delete used by clsSecWageCalculationPeriod | Inline | — | clsSecWageCalculationPeriod |
| SQL-131 | Inline delete used by clsSupplementalWagePeriod | Inline | — | clsSupplementalWagePeriod |
| SQL-132 | Inline delete used by clsWageCalcPeriodEarnings | Inline | — | clsWageCalcPeriodEarnings |
| SQL-133 | Inline delete used by clsWageCalculationPeriod | Inline | — | clsWageCalculationPeriod |
Sequence operations¶
| SQL ID | Description | Sequence | Tables | Business object |
|---|---|---|---|---|
| SQL-001 | SELECT BENEFIT_PAYEE_SEQ.NEXTVAL FROM DUAL sequence used by Criteria |
SELECT BENEFIT_PAYEE_SEQ.NEXTVAL FROM DUAL |
DUAL | Criteria |
| SQL-002 | SELECT BENEFIT_PAYMENT_SEQ.NEXTVAL FROM DUAL sequence used by CriteriaBase |
SELECT BENEFIT_PAYMENT_SEQ.NEXTVAL FROM DUAL |
DUAL | CriteriaBase |
| SQL-003 | SELECT SAIF_AWARD_NUM_NEXTVAL FROM DUAL sequence used by clsAwardCollection |
SELECT SAIF_AWARD_NUM_NEXTVAL FROM DUAL |
DUAL | clsAwardCollection |
| SQL-004 | SELECT Benefit_Period_Seq.nextval FROM DUAL sequence used by clsBenefitPeriod |
SELECT Benefit_Period_Seq.nextval FROM DUAL |
DUAL | clsBenefitPeriod |
| SQL-005 | SELECT OFFSET_CALC_PERIOD_SEQ_NUM.NEXTVAL FROM DUAL sequence used by clsOffsetWageCalcPeriod |
SELECT OFFSET_CALC_PERIOD_SEQ_NUM.NEXTVAL FROM DUAL |
DUAL | clsOffsetWageCalcPeriod |
| SQL-006 | SELECT OFFSET_WAGE_CALC_SEQ_NUM.NEXTVAL FROM DUAL sequence used by clsOffsetWageCalculation |
SELECT OFFSET_WAGE_CALC_SEQ_NUM.NEXTVAL FROM DUAL |
DUAL | clsOffsetWageCalculation |
Other operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-134 | Inline other used by clsBenefitScheduleCollection | Inline | — | clsBenefitScheduleCollection |
| SQL-135 | Inline other used by clsFinancialTransDtlCollection | Inline | — | clsFinancialTransDtlCollection |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Database tables
- Procedures
- API reference
Sources¶
Business\SAIF.Business.Claim.Payment\Adjustments\Refunds\clsNdRefund.vbBusiness\SAIF.Business.Claim.Payment\Adjustments\clsBillPaymentAdjustment.vbBusiness\SAIF.Business.Claim.Payment\FinancialTransaction\clsFinancialTranRemark.vbBusiness\SAIF.Business.Claim.Payment\FinancialTransaction\clsFinancialTrans.vbBusiness\SAIF.Business.Claim.Payment\FinancialTransaction\clsFinancialTransCollection.vbBusiness\SAIF.Business.Claim.Payment\FinancialTransaction\clsFinancialTransDtl.vbBusiness\SAIF.Business.Claim.Payment\FinancialTransaction\clsFinancialTransDtlCollection.vbBusiness\SAIF.Business.Claim.Payment\FinancialTransaction\clsPaymentPosting.vbBusiness\SAIF.Business.Claim.Payment\FinancialTransaction\clsPaymentPostingCollection.vbBusiness\SAIF.Business.Claim.Payment\FinancialTransaction\clsPaymentTotalManager.vbBusiness\SAIF.Business.Claim.Payment\Payees\clsAwardPayeeInfo.vbBusiness\SAIF.Business.Claim.Payment\Payees\clsPayeeBase.vbBusiness\SAIF.Business.Claim.Payment\Payees\clsPayeeCollection.vbBusiness\SAIF.Business.Claim.Payment\Payees\clsSupportPayee.vbBusiness\SAIF.Business.Claim.Payment\Payments\NonRecurringPayments\clsEmployerRefundPayment.vbBusiness\SAIF.Business.Claim.Payment\Payments\SettlementPayments\clsDCSPayment.vbBusiness\SAIF.Business.Claim.Payment\Payments\SettlementPayments\clsSettlementPayment.vbBusiness\SAIF.Business.Claim.Payment\Payments\StateAwardPayments\clsAward.vbBusiness\SAIF.Business.Claim.Payment\Payments\StateAwardPayments\clsAwardCollection.vbBusiness\SAIF.Business.Claim.Payment\Payments\StateAwardPayments\clsAwardSSOffset.vbBusiness\SAIF.Business.Claim.Payment\Payments\StateAwardPayments\clsAwardSSOffsetCollection.vbBusiness\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsBenefitSchedule.vbBusiness\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsBenefitScheduleCollection.vbBusiness\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsOffsetWageCalcPeriod.vbBusiness\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsOffsetWageCalcPeriods.vbBusiness\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsOffsetWageCalculation.vbBusiness\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsSupplementalWagePeriod.vbBusiness\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsSupplementalWagePeriods.vbBusiness\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsSupplementalWages.vbBusiness\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsTimelossPayment.vbBusiness\SAIF.Business.Claim.Payment\Payments\clsPaymentBase.vbBusiness\SAIF.Business.Claim.Payment\Periods\clsBenefitPeriod.vbBusiness\SAIF.Business.Claim.Payment\Periods\clsBenefitPeriodCollection.vbBusiness\SAIF.Business.Claim.Payment\Wage and Job\clsClaimTimelossCalculation.vbBusiness\SAIF.Business.Claim.Payment\Wage and Job\clsInjuryClaimWageAndJob.vbBusiness\SAIF.Business.Claim.Payment\Wage and Job\clsSecTimelossCalculation.vbBusiness\SAIF.Business.Claim.Payment\Wage and Job\clsSecWageCalcPeriodEarnings.vbBusiness\SAIF.Business.Claim.Payment\Wage and Job\clsSecWageCalculationPeriod.vbBusiness\SAIF.Business.Claim.Payment\Wage and Job\clsWageCalcPeriodEarnings.vbBusiness\SAIF.Business.Claim.Payment\Wage and Job\clsWageCalculationPeriod.vbBusiness\SAIF.Business.Claim.Payment\clsBenefitRemark.vbBusiness\SAIF.Business.Claim.Payment\clsPaymentListCollection.vb