SAIF.Business.Claim.Payment database tables

This page catalogs database tables accessed by SAIF.Business.Claim.Payment.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
CBP_AUDITED_SERVICE_ADJUSTMENT	Oracle	[unqualified]**	R	Used by PreviousPaidInfo for persisted claim workflows.	PreviousPaidInfo
CLAIM_NON_DISAB_REIMB_MAX	Oracle	[unqualified]**	R	Used by clsEmployerRefundPayment, clsNDRClaimAmountsResponse for persisted claim workflows.	clsEmployerRefundPayment, clsNDRClaimAmountsResponse
CL_AWARD	Oracle	[unqualified]**	CRU	Used by CriteriaBase, clsAward, clsAwardCollection for persisted claim workflows.	CriteriaBase, clsAward, clsAwardCollection
CL_AWARD_SS_OFFSET	Oracle	[unqualified]**	CRU	Used by clsAwardSSOffset, clsAwardSSOffsetCollection for persisted claim workflows.	clsAwardSSOffset, clsAwardSSOffsetCollection
CL_BENEFIT_PAYEE	Oracle	[unqualified]**	R	Used by clsPayeeCollection for persisted claim workflows.	clsPayeeCollection
CL_BENEFIT_PAYMENT	Oracle	[unqualified]**	CRU	Used by CriteriaBase, clsAward for persisted claim workflows.	CriteriaBase, clsAward
CL_CLAIM_CLOSURE_ORDER	Oracle	[unqualified]**	R	Used by clsAward for persisted claim workflows.	clsAward
CL_CLAIM_STATUS_ACTIVITY	Oracle	[unqualified]**	R	Used by clsPaymentBase for persisted claim workflows.	clsPaymentBase
CL_CLAIM_SUPPORT_ORDER	Oracle	[unqualified]**	R	Used by clsSupportPayee for persisted claim workflows.	clsSupportPayee
CL_CLAIM_TIMELOSS_CALCULATION	Oracle	[unqualified]**	CRU	Used by clsClaimTimelossCalculation, clsClaimTimelossCalculationCollection for persisted claim workflows.	clsClaimTimelossCalculation, clsClaimTimelossCalculationCollection
CL_FINANCIAL_TRANS	Oracle	[unqualified]**	R	Used by clsAward, clsFinancialTransCollection for persisted claim workflows.	clsAward, clsFinancialTransCollection
CL_FINANCIAL_TRANS_BILL_ADJUST	Oracle	[unqualified]**	C	Used by clsBillPaymentAdjustment for persisted claim workflows.	clsBillPaymentAdjustment
CL_FINANCIAL_TRANS_DTL	Oracle	[unqualified]**	R	Used by clsNDRClaimAmountsResponse for persisted claim workflows.	clsNDRClaimAmountsResponse
CL_FINANCIAL_TRANS_TYPE_CODE	Oracle	[unqualified]**	R	Used by FinancialTransTypeCodes for persisted claim workflows.	FinancialTransTypeCodes
CL_INJURY_CLAIM	Oracle	[unqualified]**	RU	Used by clsInjuryClaimWageAndJob, clsNDRClaimAmountsResponse, clsSettlementPayment for persisted claim workflows.	clsInjuryClaimWageAndJob, clsNDRClaimAmountsResponse, clsSettlementPayment
CL_OFFSET_CALC_PERIOD	Oracle	[unqualified]**	CRU	Used by clsOffsetWageCalcPeriod, clsOffsetWageCalcPeriods for persisted claim workflows.	clsOffsetWageCalcPeriod, clsOffsetWageCalcPeriods
CL_OFFSET_WAGE_CALCULATION	Oracle	[unqualified]**	CRU	Used by clsOffsetWageCalculation for persisted claim workflows.	clsOffsetWageCalculation
CL_PAYMENT_POSTING	Oracle	[unqualified]**	R	Used by clsPaymentPostingCollection for persisted claim workflows.	clsPaymentPostingCollection
CL_PAYMENT_SPCL_HANDLING_CODE	Oracle	[unqualified]**	R	Used by SpecialHandlingCodes for persisted claim workflows.	SpecialHandlingCodes
CL_PAYMENT_TOTAL	Oracle	[unqualified]**	CR	Used by clsPaymentTotalManager for persisted claim workflows.	clsPaymentTotalManager
CL_RECOVERY_TYPE_CODE	Oracle	[unqualified]**	R	Used by RecoveryTypeCodes for persisted claim workflows.	RecoveryTypeCodes
CL_SEC_TIMELOSS_CALCULATION	Oracle	[unqualified]**	CRU	Used by clsSecTimelossCalculation, clsSecTimelossCalculationCollection, clsSupplementalWages for persisted claim workflows.	clsSecTimelossCalculation, clsSecTimelossCalculationCollection, clsSupplementalWages
CL_SEC_WAGE_CALCULATION_PERIOD	Oracle	[unqualified]**	CRU	Used by clsSecWageCalculationPeriod, clsSecWageCalculationPeriodCollection for persisted claim workflows.	clsSecWageCalculationPeriod, clsSecWageCalculationPeriodCollection
CL_SEC_WAGE_CALC_PER_EARNINGS	Oracle	[unqualified]**	CRU	Used by clsSecWageCalcPeriodEarnings, clsSecWageCalcPeriodEarningsCollection for persisted claim workflows.	clsSecWageCalcPeriodEarnings, clsSecWageCalcPeriodEarningsCollection
CL_SEC_WAGE_EARNINGS	Oracle	[unqualified]**	CRU	Used by clsSupplementalWagePeriod, clsSupplementalWagePeriods for persisted claim workflows.	clsSupplementalWagePeriod, clsSupplementalWagePeriods
CL_STATE_AWARD_MONTHLY_PAYEE	Oracle	[unqualified]**	CRU	Used by clsAwardPayeeInfo for persisted claim workflows.	clsAwardPayeeInfo
CL_WAGE_CALCULATION_PERIOD	Oracle	[unqualified]**	CRU	Used by clsWageCalculationPeriod, clsWageCalculationPeriodCollection for persisted claim workflows.	clsWageCalculationPeriod, clsWageCalculationPeriodCollection
CL_WAGE_CALC_PERIOD_EARNINGS	Oracle	[unqualified]**	CRU	Used by clsWageCalcPeriodEarnings, clsWageCalcPeriodEarningsCollection for persisted claim workflows.	clsWageCalcPeriodEarnings, clsWageCalcPeriodEarningsCollection
DUAL	Oracle	[unqualified]**	S	Used by Criteria, CriteriaBase, clsAwardCollection, clsBenefitPeriod, clsOffsetWageCalcPeriod, clsOffsetWageCalculation for persisted claim workflows.	Criteria, CriteriaBase, clsAwardCollection, clsBenefitPeriod, clsOffsetWageCalcPeriod, clsOffsetWageCalculation
PAYMENT_TRANSACTION_TYPE_CODE	Oracle	[unqualified]**	R	Used by clsPaymentBase for persisted claim workflows.	clsPaymentBase

CBP_AUDITED_SERVICE_ADJUSTMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by PreviousPaidInfo within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	PreviousPaidInfo

Operations referencing this table

• PreviousPaidInfo IssueDate

SQL referencing this table

• SQL-036: SELECT provider_location_seq_num, NVL (SUM (audit_adjustment_amt) * -1, 0) audit…

---

CLAIM_NON_DISAB_REIMB_MAX

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsEmployerRefundPayment, clsNDRClaimAmountsResponse within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsEmployerRefundPayment, clsNDRClaimAmountsResponse

Operations referencing this table

• clsEmployerRefundPayment GetMaxPaymentAmount
• clsNDRClaimAmountsResponse TotalAmtPaidBefReimbPeriod

SQL referencing this table

• SQL-053: select max_nd_reimb_amt from claim_non_disab_reimb_max where rownum = 1 order by…
• SQL-067: SELECT NDTODAY.AMOUNT currentAmt, NDRMAX.MAX_ND_REIMB_AMT ndmax FROM CLAIM_NON_D…

---

CL_AWARD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by CriteriaBase, clsAward, clsAwardCollection within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	CriteriaBase, clsAward, clsAwardCollection

Operations referencing this table

• CriteriaBase BeforeInsert
• clsAwardCollection BeforeInsert
• CriteriaBase BeforeRetrieve
• clsAward GetAwardCount
• clsAwardCollection BeforeRetrieve
• CriteriaBase BeforeUpdate
• clsAwardCollection BeforeUpdate

SQL referencing this table

• SQL-009: Insert into CL_AWARD ( SAIF_AWARD_NUM, CLAIM_ID, AWARD_STATUS_CODE, ORDER_SEQ_NU…
• SQL-011: Insert into CL_AWARD ( SAIF_AWARD_NUM, CLAIM_ID, AWARD_STATUS_CODE, ORDER_SEQ_NU…
• SQL-032: Select DISTINCT CL_AWARD.SAIF_AWARD_NUM as AwardNum, PAY.BENEFIT_PAYMENT_SEQ_NUM…
• SQL-033: Select DISTINCT CL_AWARD.SAIF_AWARD_NUM as AwardNum, PAY.BENEFIT_PAYMENT_SEQ_NUM…
• SQL-039: Select Count(*) FROM CL_AWARD where CLAIM_ID = :ClaimID and AWARD_STATUS_CODE = …
• SQL-044: Select CL_AWARD.SAIF_AWARD_NUM as AwardNum, CL_AWARD.CLAIM_ID as ClaimID, CL_AWA…
• SQL-092: Update CL_AWARD Set AWARD_STATUS_CODE = :AwardStatusCode, ORDER_SEQ_NUM = :Order…
• SQL-094: Update CL_AWARD Set SAIF_AWARD_NUM = :AwardNum, CLAIM_ID = :ClaimID, AWARD_STATU…

---

CL_AWARD_SS_OFFSET

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsAwardSSOffset, clsAwardSSOffsetCollection within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsAwardSSOffset, clsAwardSSOffsetCollection

Operations referencing this table

• clsAwardSSOffset BeforeInsert
• clsAwardSSOffsetCollection BeforeRetrieve
• clsAwardSSOffset BeforeUpdate

SQL referencing this table

• SQL-013: Insert into CL_AWARD_SS_OFFSET ( AWARD_SS_OFFSET_SEQ_NUM, SAIF_AWARD_NUM, PERSON…
• SQL-046: Select CL_AWARD_SS_OFFSET.AWARD_SS_OFFSET_SEQ_NUM as AwardSSOffsetID, CL_AWARD_S…
• SQL-096: Update CL_AWARD_SS_OFFSET Set EFF_DATE = :EffectiveDate, SOC_SEC_STATUS_CODE = :…

---

CL_BENEFIT_PAYEE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsPayeeCollection within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsPayeeCollection

Operations referencing this table

• clsPayeeCollection BeforeRetrieve

SQL referencing this table

• SQL-070: SELECT CL_BENEFIT_PAYEE.BENEFIT_PAYEE_SEQ_NUM as BenefitPayeeID, CL_BENEFIT_PAYE…

---

CL_BENEFIT_PAYMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by CriteriaBase, clsAward within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	CriteriaBase, clsAward

Operations referencing this table

• CriteriaBase BeforeInsert
• clsAward GetAwardType
• CriteriaBase BeforeUpdate

SQL referencing this table

• SQL-010: Insert into CL_BENEFIT_PAYMENT ( BENEFIT_PAYMENT_SEQ_NUM, CLAIM_ID, SAIF_AWARD_N…
• SQL-040: Select distinct benefit_type_code from cl_benefit_payment where saif_award_num =…
• SQL-093: Update CL_BENEFIT_PAYMENT Set ISSUE_DATE = :IssueDate, INITIATOR_USER = :Initiat…

---

CL_CLAIM_CLOSURE_ORDER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsAward within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsAward

Operations referencing this table

• clsAward GetOrderDate

SQL referencing this table

• SQL-041: Select order_date from cl_claim_closure_order where claim_id = :ClaimID and clos…

---

CL_CLAIM_STATUS_ACTIVITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsPaymentBase within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsPaymentBase

Operations referencing this table

• clsPaymentBase GetClosedClaimCount

SQL referencing this table

• SQL-071: Select count(*) from cl_claim_status_activity

---

CL_CLAIM_SUPPORT_ORDER

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsSupportPayee within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsSupportPayee

Operations referencing this table

• clsSupportPayee GetSEDNumber
• clsSupportPayee GetSupportOrderID
• clsSupportPayee ValidateActiveSupportOrderID
• clsSupportPayee ValidateSupportOrderID

SQL referencing this table

• SQL-084: select sed_account_num from cl_claim_support_order where support_order_id = :Sup…
• SQL-085: select * from cl_claim_support_order where term_date is null and worker_id = :Wo…
• SQL-086: select count(*) from cl_claim_support_order where term_date is null and worker_i…
• SQL-087: select count(*) from cl_claim_support_order where worker_id = :WorkerID and supp…

---

CL_CLAIM_TIMELOSS_CALCULATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimTimelossCalculation, clsClaimTimelossCalculationCollection within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsClaimTimelossCalculation, clsClaimTimelossCalculationCollection

Operations referencing this table

• clsClaimTimelossCalculation BeforeInsert
• clsClaimTimelossCalculationCollection BeforeRetrieve
• clsClaimTimelossCalculation BeforeUpdate

SQL referencing this table

• SQL-018: Insert into CL_CLAIM_TIMELOSS_CALCULATION ( AUDIT_REVIEWER_USER, AVERAGE_WAGE_FL…
• SQL-051: Select CL_CLAIM_TIMELOSS_CALCULATION.AUDIT_REVIEWER_USER as AuditReviewerUser, C…
• SQL-100: Update CL_CLAIM_TIMELOSS_CALCULATION Set AUDIT_REVIEWER_USER = :AuditReviewerUse…

---

CL_FINANCIAL_TRANS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsAward, clsFinancialTransCollection within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsAward, clsFinancialTransCollection

Operations referencing this table

• clsAward GetPreviousAwardPaymentCount
• clsAward PaymentsInProgressCount
• clsFinancialTransCollection LatestTranDateSQL
• clsFinancialTransCollection OverLapSQL
• clsFinancialTransCollection GetPreviousAmts
• clsFinancialTransCollection TranExistsSQL

SQL referencing this table

• SQL-042: Select count(*) from cl_financial_trans where saif_award_num = :AwardNumber and …
• SQL-043: Select count(*) from cl_financial_trans where financial_trans_status_code in ('1…
• SQL-055: Select max(dt.TRANSACTION_THRU_DATE) ThruDate From CL_FINANCIAL_TRANS FT, CL_INJ…
• SQL-056: select sum(dt.TRANSACTION_AMT) from cl_financial_trans ft, cl_financial_trans_dt…
• SQL-057: select sum(dt.Transaction_Amt) PmtAmt, sum(dt.TD_DAY_QTY) DayQty from cl_financi…
• SQL-065: select count(*) from cl_financial_trans ft, cl_financial_trans_dtl dt where ft.C…

---

CL_FINANCIAL_TRANS_BILL_ADJUST

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsBillPaymentAdjustment within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	C
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsBillPaymentAdjustment

Operations referencing this table

• clsBillPaymentAdjustment BeforeInsert

SQL referencing this table

• SQL-017: INSERT INTO CL_FINANCIAL_TRANS_BILL_ADJUST ( CLAIM_FINANCIAL_TRANS_SEQ_NUM, FINA…

---

CL_FINANCIAL_TRANS_DTL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsNDRClaimAmountsResponse within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsNDRClaimAmountsResponse

Operations referencing this table

• clsNDRClaimAmountsResponse TotalAmtPaidBefReimbPeriod

SQL referencing this table

• SQL-067: SELECT NDTODAY.AMOUNT currentAmt, NDRMAX.MAX_ND_REIMB_AMT ndmax FROM CLAIM_NON_D…

---

CL_FINANCIAL_TRANS_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by FinancialTransTypeCodes within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	FinancialTransTypeCodes

Operations referencing this table

• FinancialTransTypeCodes New

SQL referencing this table

• SQL-035: Select code, code_descr FROM CL_FINANCIAL_TRANS_TYPE_CODE order by code_descr

---

CL_INJURY_CLAIM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsInjuryClaimWageAndJob, clsNDRClaimAmountsResponse, clsSettlementPayment within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	RU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsInjuryClaimWageAndJob, clsNDRClaimAmountsResponse, clsSettlementPayment

Operations referencing this table

• clsInjuryClaimWageAndJob BeforeRetrieve
• clsNDRClaimAmountsResponse TotalAmtPaidBefReimbPeriod
• clsInjuryClaimWageAndJob BeforeUpdate
• clsSettlementPayment UpdateCDAInformation
• clsSettlementPayment UpdateDCSInformation

SQL referencing this table

• SQL-066: Select CL_INJURY_CLAIM.CLAIM_ID as ClaimID, CL_INJURY_CLAIM.EMPR_PROV_PAYROLL_CL…
• SQL-067: SELECT NDTODAY.AMOUNT currentAmt, NDRMAX.MAX_ND_REIMB_AMT ndmax FROM CLAIM_NON_D…
• SQL-103: Update CL_INJURY_CLAIM Set EMPR_PROV_PAYROLL_CLASS_CODE = :EmprProvPayrollClassC…
• SQL-109: Update CL_INJURY_CLAIM
• SQL-110: Update CL_INJURY_CLAIM

---

CL_OFFSET_CALC_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsOffsetWageCalcPeriod, clsOffsetWageCalcPeriods within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsOffsetWageCalcPeriod, clsOffsetWageCalcPeriods

Operations referencing this table

• clsOffsetWageCalcPeriod BeforeInsert
• clsOffsetWageCalcPeriods BeforeRetrieve
• clsOffsetWageCalcPeriod BeforeUpdate

SQL referencing this table

• SQL-021: INSERT INTO CL_OFFSET_CALC_PERIOD ( OFFSET_CALC_PERIOD_SEQ_NUM, OFFSET_WAGE_CALC…
• SQL-068: SELECT CL_OFFSET_CALC_PERIOD.OFFSET_CALC_PERIOD_SEQ_NUM AS OffsetWageCalcPeriodI…
• SQL-104: UPDATE CL_OFFSET_CALC_PERIOD SET OFFSET_CALC_PERIOD_SEQ_NUM = :OffsetWageCalcPer…

---

CL_OFFSET_WAGE_CALCULATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsOffsetWageCalculation within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsOffsetWageCalculation

Operations referencing this table

• clsOffsetWageCalculation BeforeInsert
• clsOffsetWageCalculation BeforeRetrieve
• clsOffsetWageCalculation BeforeUpdate

SQL referencing this table

• SQL-022: Insert Into CL_OFFSET_WAGE_CALCULATION ( OFFSET_WAGE_CALC_SEQ_NUM, BENEFIT_PAYME…
• SQL-069: Select CL_OFFSET_WAGE_CALCULATION.OFFSET_WAGE_CALC_SEQ_NUM as OffsetWageCalculat…
• SQL-105: Update CL_OFFSET_WAGE_CALCULATION Set OFFSET_WAGE_CALC_SEQ_NUM = :OffsetWageCalc…

---

CL_PAYMENT_POSTING

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsPaymentPostingCollection within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsPaymentPostingCollection

Operations referencing this table

• clsPaymentPostingCollection BeforeRetrieve

SQL referencing this table

• SQL-076: SELECT PP.CLAIM_FINANCIAL_TRANS_SEQ_NUM AS ClaimFinancialTransSeqNum, PP.CLAIM_I…

---

CL_PAYMENT_SPCL_HANDLING_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by SpecialHandlingCodes within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	SpecialHandlingCodes

Operations referencing this table

• SpecialHandlingCodes New

SQL referencing this table

• SQL-038: Select * FROM CL_PAYMENT_SPCL_HANDLING_CODE order by code_descr

---

CL_PAYMENT_TOTAL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsPaymentTotalManager within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CR
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsPaymentTotalManager

Operations referencing this table

• clsPaymentTotalManager BeforeInsert
• clsPaymentTotalManager BeforeRetrieve

SQL referencing this table

• SQL-024: Insert into CL_PAYMENT_TOTAL ( CL_PAYMENT_TOTAL_SEQ_NUM, CLAIM_ID, PAYMENT_TOTAL…
• SQL-078: Select CL_PAYMENT_TOTAL.CL_PAYMENT_TOTAL_SEQ_NUM as PaymentTotalID, CL_PAYMENT_T…

---

CL_RECOVERY_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by RecoveryTypeCodes within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	RecoveryTypeCodes

Operations referencing this table

• RecoveryTypeCodes New

SQL referencing this table

• SQL-037: select code, code_descr from cl_recovery_type_code order by code_descr

---

CL_SEC_TIMELOSS_CALCULATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsSecTimelossCalculation, clsSecTimelossCalculationCollection, clsSupplementalWages within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsSecTimelossCalculation, clsSecTimelossCalculationCollection, clsSupplementalWages

Operations referencing this table

• clsSecTimelossCalculation BeforeInsert
• clsSecTimelossCalculationCollection BeforeRetrieve
• clsSupplementalWages GetSecondaryEmployers
• clsSecTimelossCalculation BeforeUpdate

SQL referencing this table

• SQL-025: Insert into CL_SEC_TIMELOSS_CALCULATION ( CALCULATION_NOTE_TEXT, CLAIM_ID, EARNI…
• SQL-079: Select CALCULATION_NOTE_TEXT as CalculationNoteText, CLAIM_ID as ClaimID, EARNIN…
• SQL-083: select timeloss_calculation_sub_num as TlCalcID, secondary_employer_name as Name…
• SQL-106: Update CL_SEC_TIMELOSS_CALCULATION Set CALCULATION_NOTE_TEXT = :CalculationNoteT…

---

CL_SEC_WAGE_CALCULATION_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsSecWageCalculationPeriod, clsSecWageCalculationPeriodCollection within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsSecWageCalculationPeriod, clsSecWageCalculationPeriodCollection

Operations referencing this table

• clsSecWageCalculationPeriod BeforeInsert
• clsSecWageCalculationPeriodCollection BeforeRetrieve
• clsSecWageCalculationPeriod BeforeUpdate

SQL referencing this table

• SQL-027: Insert into CL_SEC_WAGE_CALCULATION_PERIOD ( CLAIM_ID, EARNINGS_PERIOD_FROM_DATE…
• SQL-081: Select CL_SEC_WAGE_CALCULATION_PERIOD.CLAIM_ID as ClaimID, CL_SEC_WAGE_CALCULATI…
• SQL-108: Update CL_SEC_WAGE_CALCULATION_PERIOD Set EARNINGS_PERIOD_FROM_DATE = :EarningsP…

---

CL_SEC_WAGE_CALC_PER_EARNINGS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsSecWageCalcPeriodEarnings, clsSecWageCalcPeriodEarningsCollection within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsSecWageCalcPeriodEarnings, clsSecWageCalcPeriodEarningsCollection

Operations referencing this table

• clsSecWageCalcPeriodEarnings BeforeInsert
• clsSecWageCalcPeriodEarningsCollection BeforeRetrieve
• clsSecWageCalcPeriodEarnings BeforeUpdate

SQL referencing this table

• SQL-026: Insert into CL_SEC_WAGE_CALC_PER_EARNINGS ( CLAIM_ID, EARNINGS_TYPE_SUB_NUM, EAR…
• SQL-080: Select CL_SEC_WAGE_CALC_PER_EARNINGS.CLAIM_ID as ClaimID, CL_SEC_WAGE_CALC_PER_E…
• SQL-107: Update CL_SEC_WAGE_CALC_PER_EARNINGS Set EARNINGS_TYPE_DESCR = :EarningsTypeDesc…

---

CL_SEC_WAGE_EARNINGS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsSupplementalWagePeriod, clsSupplementalWagePeriods within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsSupplementalWagePeriod, clsSupplementalWagePeriods

Operations referencing this table

• clsSupplementalWagePeriod BeforeInsert
• clsSupplementalWagePeriods BeforeRetrieve
• clsSupplementalWagePeriod BeforeUpdate

SQL referencing this table

• SQL-028: INSERT INTO CL_SEC_WAGE_EARNINGS ( CLAIM_ID , TIMELOSS_CALCULATION_SUB_NUM, BENE…
• SQL-082: SELECT CL.CLAIM_ID AS ClaimID , CL.TIMELOSS_CALCULATION_SUB_NUM AS TimelossCalcu…
• SQL-111: UPDATE CL_SEC_WAGE_EARNINGS SET CLAIM_ID = :ClaimID , TIMELOSS_CALCULATION_SUB_N…

---

CL_STATE_AWARD_MONTHLY_PAYEE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsAwardPayeeInfo within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsAwardPayeeInfo

Operations referencing this table

• clsAwardPayeeInfo BeforeInsert
• clsAwardPayeeInfo BeforeRetrieve
• clsAwardPayeeInfo BeforeUpdate

SQL referencing this table

• SQL-012: Insert into CL_STATE_AWARD_MONTHLY_PAYEE ( BENEFIT_PAYEE_SEQ_NUM, CURRENT_BALANC…
• SQL-045: Select CL_STATE_AWARD_MONTHLY_PAYEE.BENEFIT_PAYEE_SEQ_NUM as BenefitPayeeID, CL_…
• SQL-095: Update CL_STATE_AWARD_MONTHLY_PAYEE Set CURRENT_BALANCE_DUE_AMT = :CurrentBalanc…

---

CL_WAGE_CALCULATION_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsWageCalculationPeriod, clsWageCalculationPeriodCollection within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsWageCalculationPeriod, clsWageCalculationPeriodCollection

Operations referencing this table

• clsWageCalculationPeriod BeforeInsert
• clsWageCalculationPeriodCollection BeforeRetrieve
• clsWageCalculationPeriod BeforeUpdate

SQL referencing this table

• SQL-030: Insert into CL_WAGE_CALCULATION_PERIOD ( CLAIM_ID, EARNINGS_PERIOD_FROM_DATE, EA…
• SQL-089: Select CL_WAGE_CALCULATION_PERIOD.CLAIM_ID as ClaimID, CL_WAGE_CALCULATION_PERIO…
• SQL-113: Update CL_WAGE_CALCULATION_PERIOD Set EARNINGS_PERIOD_FROM_DATE = :EarningsPerio…

---

CL_WAGE_CALC_PERIOD_EARNINGS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsWageCalcPeriodEarnings, clsWageCalcPeriodEarningsCollection within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsWageCalcPeriodEarnings, clsWageCalcPeriodEarningsCollection

Operations referencing this table

• clsWageCalcPeriodEarnings BeforeInsert
• clsWageCalcPeriodEarningsCollection BeforeRetrieve
• clsWageCalcPeriodEarnings BeforeUpdate

SQL referencing this table

• SQL-029: Insert into CL_WAGE_CALC_PERIOD_EARNINGS ( CLAIM_ID, EARNINGS_TYPE_SUB_NUM, EARN…
• SQL-088: Select CL_WAGE_CALC_PERIOD_EARNINGS.CLAIM_ID as ClaimID, CL_WAGE_CALC_PERIOD_EAR…
• SQL-112: Update CL_WAGE_CALC_PERIOD_EARNINGS Set EARNINGS_TYPE_DESCR = :EarningsTypeDescr…

---

DUAL

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by Criteria, CriteriaBase, clsAwardCollection, clsBenefitPeriod, clsOffsetWageCalcPeriod, clsOffsetWageCalculation within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	S
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	OFFSET_WAGE_CALC_SEQ_NUM
Related tables	None identified
Business objects	Criteria, CriteriaBase, clsAwardCollection, clsBenefitPeriod, clsOffsetWageCalcPeriod, clsOffsetWageCalculation

Operations referencing this table

• Criteria identity/sequence generation
• CriteriaBase identity/sequence generation
• clsAwardCollection identity/sequence generation
• clsBenefitPeriod identity/sequence generation
• clsOffsetWageCalcPeriod identity/sequence generation
• clsOffsetWageCalculation identity/sequence generation

SQL referencing this table

• SQL-001: SELECT BENEFIT_PAYEE_SEQ.NEXTVAL FROM DUAL
• SQL-002: SELECT BENEFIT_PAYMENT_SEQ.NEXTVAL FROM DUAL
• SQL-003: SELECT SAIF_AWARD_NUM_NEXTVAL FROM DUAL
• SQL-004: SELECT Benefit_Period_Seq.nextval FROM DUAL
• SQL-005: SELECT OFFSET_CALC_PERIOD_SEQ_NUM.NEXTVAL FROM DUAL
• SQL-006: SELECT OFFSET_WAGE_CALC_SEQ_NUM.NEXTVAL FROM DUAL

---

PAYMENT_TRANSACTION_TYPE_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsPaymentBase within the SAIF.Business.Claim.Payment workflow.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	Not enumerated directly in the stage findings for every statement.**
Sequence	N/A
Related tables	None identified
Business objects	clsPaymentBase

Operations referencing this table

• clsPaymentBase GetNextIssueDate

SQL referencing this table

• SQL-072: select next_issue_date from payment_transaction_type_code where code = :PaymentT…

Table relationship diagram

No cross-table relationships were identified in this library's SQL.

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• Procedures
• API reference

Note: Statements marked with ** could not be confirmed; treat them as unknown until verified.

Sources

• Business\SAIF.Business.Claim.Payment\Adjustments\Refunds\clsNdRefund.vb
• Business\SAIF.Business.Claim.Payment\Adjustments\clsBillPaymentAdjustment.vb
• Business\SAIF.Business.Claim.Payment\FinancialTransaction\clsFinancialTranRemark.vb
• Business\SAIF.Business.Claim.Payment\FinancialTransaction\clsFinancialTrans.vb
• Business\SAIF.Business.Claim.Payment\FinancialTransaction\clsFinancialTransCollection.vb
• Business\SAIF.Business.Claim.Payment\FinancialTransaction\clsFinancialTransDtl.vb
• Business\SAIF.Business.Claim.Payment\FinancialTransaction\clsFinancialTransDtlCollection.vb
• Business\SAIF.Business.Claim.Payment\FinancialTransaction\clsPaymentPosting.vb
• Business\SAIF.Business.Claim.Payment\FinancialTransaction\clsPaymentPostingCollection.vb
• Business\SAIF.Business.Claim.Payment\FinancialTransaction\clsPaymentTotalManager.vb
• Business\SAIF.Business.Claim.Payment\Payees\clsAwardPayeeInfo.vb
• Business\SAIF.Business.Claim.Payment\Payees\clsPayeeBase.vb
• Business\SAIF.Business.Claim.Payment\Payees\clsPayeeCollection.vb
• Business\SAIF.Business.Claim.Payment\Payees\clsSupportPayee.vb
• Business\SAIF.Business.Claim.Payment\Payments\NonRecurringPayments\clsEmployerRefundPayment.vb
• Business\SAIF.Business.Claim.Payment\Payments\SettlementPayments\clsDCSPayment.vb
• Business\SAIF.Business.Claim.Payment\Payments\SettlementPayments\clsSettlementPayment.vb
• Business\SAIF.Business.Claim.Payment\Payments\StateAwardPayments\clsAward.vb
• Business\SAIF.Business.Claim.Payment\Payments\StateAwardPayments\clsAwardCollection.vb
• Business\SAIF.Business.Claim.Payment\Payments\StateAwardPayments\clsAwardSSOffset.vb
• Business\SAIF.Business.Claim.Payment\Payments\StateAwardPayments\clsAwardSSOffsetCollection.vb
• Business\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsBenefitSchedule.vb
• Business\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsBenefitScheduleCollection.vb
• Business\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsOffsetWageCalcPeriod.vb
• Business\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsOffsetWageCalcPeriods.vb
• Business\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsOffsetWageCalculation.vb
• Business\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsSupplementalWagePeriod.vb
• Business\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsSupplementalWagePeriods.vb
• Business\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsSupplementalWages.vb
• Business\SAIF.Business.Claim.Payment\Payments\TimelossPayments\clsTimelossPayment.vb
• Business\SAIF.Business.Claim.Payment\Payments\clsPaymentBase.vb
• Business\SAIF.Business.Claim.Payment\Periods\clsBenefitPeriod.vb
• Business\SAIF.Business.Claim.Payment\Periods\clsBenefitPeriodCollection.vb
• Business\SAIF.Business.Claim.Payment\Wage and Job\clsClaimTimelossCalculation.vb
• Business\SAIF.Business.Claim.Payment\Wage and Job\clsInjuryClaimWageAndJob.vb
• Business\SAIF.Business.Claim.Payment\Wage and Job\clsSecTimelossCalculation.vb
• Business\SAIF.Business.Claim.Payment\Wage and Job\clsSecWageCalcPeriodEarnings.vb
• Business\SAIF.Business.Claim.Payment\Wage and Job\clsSecWageCalculationPeriod.vb
• Business\SAIF.Business.Claim.Payment\Wage and Job\clsWageCalcPeriodEarnings.vb
• Business\SAIF.Business.Claim.Payment\Wage and Job\clsWageCalculationPeriod.vb
• Business\SAIF.Business.Claim.Payment\clsBenefitRemark.vb
• Business\SAIF.Business.Claim.Payment\clsPaymentListCollection.vb