SAIF.Business.Claim.Maintenance database tables

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

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
ATTENDING_PHYS_EXP_REASON_CODE	Oracle	[unqualified]**	R	Used by clsAttendingPhysician for persisted claim workflows.	clsAttendingPhysician
CBP_DIAGNOSIS	Oracle	[unqualified]**	R	Used by clsMedicalCondition for persisted claim workflows.	clsMedicalCondition
CL_BENEFIT_PAYMENT	Oracle	[unqualified]**	R	Used by clsWorkerClaimBenefitPayment for persisted claim workflows.	clsWorkerClaimBenefitPayment
CL_BENEFIT_PERIOD	Oracle	[unqualified]**	R	Used by clsClaimDetail for persisted claim workflows.	clsClaimDetail
CL_BENEFIT_SCHEDULE	Oracle	[unqualified]**	RU	Used by clsWorkerClaimBenefitSchedule for persisted claim workflows.	clsWorkerClaimBenefitSchedule
CL_CLAIM_DISABILITY_ACTIVITY	Oracle	[unqualified]**	CRU	Used by clsClaimDisabilityActivity, clsClaimDisabilityActivityCollection for persisted claim workflows.	clsClaimDisabilityActivity, clsClaimDisabilityActivityCollection
CL_CLAIM_LEGAL_REPRESENTATIVE	Oracle	[unqualified]**	RU	Used by clsClaimDetail for persisted claim workflows.	clsClaimDetail
CL_CLAIM_MCO_ELIGIBILITY	Oracle	[unqualified]**	CR	Used by clsClaimMcoEligibility, clsClaimMcoEligibilityCollection for persisted claim workflows.	clsClaimMcoEligibility, clsClaimMcoEligibilityCollection
CL_CLAIM_PERSON	Oracle	[unqualified]**	R	Used by clsClaimAdjustment, clsClaimDetail for persisted claim workflows.	clsClaimAdjustment, clsClaimDetail
CL_CLAIM_POLICY_HISTORY	Oracle	[unqualified]**	CR	Used by clsClaimPolicyHistory, clsClaimPolicyHistoryCollection for persisted claim workflows.	clsClaimPolicyHistory, clsClaimPolicyHistoryCollection
CL_CLAIM_REQUEST_DECISION	Oracle	[unqualified]**	CRU	Used by clsAccidentInjury, clsClaimRequestDecision, clsClaimRequestDecisionCollection for persisted claim workflows.	clsAccidentInjury, clsClaimRequestDecision, clsClaimRequestDecisionCollection
CL_CLAIM_STATUS_ACTIVITY	Oracle	[unqualified]**	CRU	Used by clsClaimStatusActivity, clsClaimStatusActivityCollection for persisted claim workflows.	clsClaimStatusActivity, clsClaimStatusActivityCollection
CL_CLAIM_SUPPORT_ORDER_CONN	Oracle	[unqualified]**	C	Used by clsClaimSupportOrderConn for persisted claim workflows.	clsClaimSupportOrderConn
CL_CLAIM_TD_THREE_DAY_WAIT	Oracle	[unqualified]**	CDRU	Used by clsAccidentInjury, clsTDThreeDayWait, clsTDThreeDayWaitCollection for persisted claim workflows.	clsAccidentInjury, clsTDThreeDayWait, clsTDThreeDayWaitCollection
CL_CLAIM_TYPE_ACTIVITY	Oracle	[unqualified]**	CRU	Used by clsClaimTypeActivity, clsClaimTypeActivityCollection for persisted claim workflows.	clsClaimTypeActivity, clsClaimTypeActivityCollection
CL_CLAIM_WORK_RELEASE_STATUS	Oracle	[unqualified]**	CRU	Used by clsAccidentInjury, clsWorkRelease, clsWorkReleaseCollection for persisted claim workflows.	clsAccidentInjury, clsWorkRelease, clsWorkReleaseCollection
CL_CLAIM_WORK_STATUS	Oracle	[unqualified]**	CRU	Used by clsWorkStatus, clsWorkStatusCollection for persisted claim workflows.	clsWorkStatus, clsWorkStatusCollection
CL_COND_COMPENSABILITY_DECISN	Oracle	[unqualified]**	CDRU	Used by clsConditionDecision, clsConditionDecisionCollection for persisted claim workflows.	clsConditionDecision, clsConditionDecisionCollection
CL_COVID19_TESTING_HISTORY	Oracle	[unqualified]**	CR	Used by clsCovid19TestingHistory, clsCovid19TestingHistoryCollection for persisted claim workflows.	clsCovid19TestingHistory, clsCovid19TestingHistoryCollection
CL_DISABILITY_AUTH_ACTIVITY	Oracle	[unqualified]**	CRU	Used by clsAccidentInjury, clsDisabilityAuthActivity, clsDisabilityAuthActivityCollection for persisted claim workflows.	clsAccidentInjury, clsDisabilityAuthActivity, clsDisabilityAuthActivityCollection
CL_INJURY_CLAIM	Oracle	[unqualified]**	RU	Used by clsAccidentInjury, clsClaimAdjustment, clsClaimDetail, clsClaimDisabilityActivityCollection, clsClaimPolicy, clsClaimSupportOrder, clsDisabilityAuthActivityCollection, clsWorkStatusInjuryClaim, clsWorkerInjuryClaim for persisted claim workflows.	clsAccidentInjury, clsClaimAdjustment, clsClaimDetail, clsClaimDisabilityActivityCollection, clsClaimPolicy, clsClaimSupportOrder, clsDisabilityAuthActivityCollection, clsWorkStatusInjuryClaim, clsWorkerInjuryClaim
CL_MEDICAL_CONDITION	Oracle	[unqualified]**	CDRU	Used by clsAccidentInjury, clsClaimDetail, clsMedicalCondition, clsMedicalConditionCollection for persisted claim workflows.	clsAccidentInjury, clsClaimDetail, clsMedicalCondition, clsMedicalConditionCollection
CL_MERGED_CLAIM	Oracle	[unqualified]**	R	Used by clsClaimDetail for persisted claim workflows.	clsClaimDetail
CL_OMITTED_COND_DENIED	Oracle	[unqualified]**	CDRU	Used by clsOmittedCondition, clsOmittedConditionCollection for persisted claim workflows.	clsOmittedCondition, clsOmittedConditionCollection
CL_PHARMACY_ELIGIBILITY_REPORT	Oracle	[unqualified]**	CRU	Used by clsWorkerPharmacyEligibilityReport for persisted claim workflows.	clsWorkerPharmacyEligibilityReport
DUAL	Oracle	[unqualified]**	S	Used by clsClaimSupportOrder for persisted claim workflows.	clsClaimSupportOrder
MCO_GSA_LOCATION	Oracle	[unqualified]**	R	Used by clsClaimDetail for persisted claim workflows.	clsClaimDetail
VOCATIONAL_DETAIL	Oracle	[unqualified]**	CU	Used by clsVocationalDetail for persisted claim workflows.	clsVocationalDetail
ZIP_MCO_COUNTY	Oracle	[unqualified]**	R	Used by clsAccidentInjury for persisted claim workflows.	clsAccidentInjury

ATTENDING_PHYS_EXP_REASON_CODE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsAttendingPhysician within the SAIF.Business.Claim.Maintenance 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	clsAttendingPhysician

Operations referencing this table

• clsAttendingPhysician GetTerminationReasonCodes

SQL referencing this table

• SQL-028: select code, code_descr from attending_phys_exp_reason_code order by code_descr

---

CBP_DIAGNOSIS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsMedicalCondition within the SAIF.Business.Claim.Maintenance 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	clsMedicalCondition

Operations referencing this table

• clsMedicalCondition DiagnosisCodeIsICD9
• clsMedicalCondition DiagnosisCodeIsMedicareReportable

SQL referencing this table

• SQL-067: Select Count (*) From CBP_DIAGNOSIS Where CBP_DIAGNOSIS.DIAGNOSIS_CODE = :Diagno…
• SQL-068: Select Count (*) From CBP_DIAGNOSIS Where CBP_DIAGNOSIS.DIAGNOSIS_CODE = :Diagno…

---

CL_BENEFIT_PAYMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsWorkerClaimBenefitPayment within the SAIF.Business.Claim.Maintenance 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	clsWorkerClaimBenefitPayment

Operations referencing this table

• clsWorkerClaimBenefitPayment BeforeRetrieve

SQL referencing this table

• SQL-077: Select CL_BENEFIT_PAYMENT.BENEFIT_PAYMENT_SEQ_NUM as BenefitPaymentSeqNum, CL_BE…

---

CL_BENEFIT_PERIOD

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimDetail within the SAIF.Business.Claim.Maintenance 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	clsClaimDetail

Operations referencing this table

• clsClaimDetail RetrieveClaimBenefitPeriodCountSQL

SQL referencing this table

• SQL-033: Select Count (*) From CL_BENEFIT_PERIOD Where CL_BENEFIT_PERIOD.CLAIM_ID = :Clai…

---

CL_BENEFIT_SCHEDULE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsWorkerClaimBenefitSchedule within the SAIF.Business.Claim.Maintenance 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	clsWorkerClaimBenefitSchedule

Operations referencing this table

• clsWorkerClaimBenefitSchedule BeforeRetrieve
• clsWorkerClaimBenefitSchedule BeforeUpdate

SQL referencing this table

• SQL-078: Select CL_BENEFIT_SCHEDULE.BENEFIT_PAYMENT_SUB_NUM as BenefitPaymentSubNum, CL_B…
• SQL-103: Update CL_BENEFIT_SCHEDULE Set REMAINING_PAYMENT_COUNT = 1, UPDATE_DATE = :Updat…

---

CL_CLAIM_DISABILITY_ACTIVITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimDisabilityActivity, clsClaimDisabilityActivityCollection within the SAIF.Business.Claim.Maintenance 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	clsClaimDisabilityActivity, clsClaimDisabilityActivityCollection

Operations referencing this table

• clsClaimDisabilityActivity BeforeInsert
• clsClaimDisabilityActivityCollection BeforeRetrieve
• clsClaimDisabilityActivity BeforeUpdate

SQL referencing this table

• SQL-003: Insert into CL_CLAIM_DISABILITY_ACTIVITY ( CLAIM_ID, DISABILITY_ACTIVITY_SUB_NUM…
• SQL-043: Select CL_CLAIM_DISABILITY_ACTIVITY.CLAIM_ID as ClaimID, CL_CLAIM_DISABILITY_ACT…
• SQL-088: Update CL_CLAIM_DISABILITY_ACTIVITY Set DISABILITY_DATE = TRUNC(:DisabilityDate)…

---

CL_CLAIM_LEGAL_REPRESENTATIVE

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimDetail within the SAIF.Business.Claim.Maintenance 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	clsClaimDetail

Operations referencing this table

• clsClaimDetail ProcessLegalRep

SQL referencing this table

• SQL-035: Select CL_CLAIM_LEGAL_REPRESENTATIVE.EFF_DATE as LegalRepEffDate From CL_CLAIM_L…
• SQL-086: Update CL_CLAIM_LEGAL_REPRESENTATIVE Set EXP_DATE = TRUNC(SYSDATE), LEGAL_REP_EN…

---

CL_CLAIM_MCO_ELIGIBILITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimMcoEligibility, clsClaimMcoEligibilityCollection within the SAIF.Business.Claim.Maintenance 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	clsClaimMcoEligibility, clsClaimMcoEligibilityCollection

Operations referencing this table

• clsClaimMcoEligibility BeforeInsert
• clsClaimMcoEligibilityCollection BeforeRetrieve

SQL referencing this table

• SQL-004: Insert into CL_CLAIM_MCO_ELIGIBILITY ( CLAIM_ID, MCO_ELIGIBILITY_REASON_CODE, MC…
• SQL-044: Select CL_CLAIM_MCO_ELIGIBILITY.CLAIM_ID as ClaimID, CL_CLAIM_MCO_ELIGIBILITY.MC…

---

CL_CLAIM_PERSON

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimAdjustment, clsClaimDetail within the SAIF.Business.Claim.Maintenance 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	clsClaimAdjustment, clsClaimDetail

Operations referencing this table

• clsClaimAdjustment RetrieveWorker
• clsClaimDetail GetPMAWorkerNumberCount

SQL referencing this table

• SQL-030: SELECT PERSON_ID as PersonID, PRIMARY_TAX_ID as PrimaryTaxID, PRIMARY_FIRST_NAME…
• SQL-031: SELECT PERSON_ID as PersonID, PRIMARY_TAX_ID as PrimaryTaxID, PRIMARY_FIRST_NAME…
• SQL-039: Select Count (*) From CL_CLAIM_PERSON Where CL_CLAIM_PERSON.PMA_WORKER_NUM = :PM…

---

CL_CLAIM_POLICY_HISTORY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimPolicyHistory, clsClaimPolicyHistoryCollection within the SAIF.Business.Claim.Maintenance 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	clsClaimPolicyHistory, clsClaimPolicyHistoryCollection

Operations referencing this table

• clsClaimPolicyHistory BeforeInsert
• clsClaimPolicyHistoryCollection BeforeRetrieve

SQL referencing this table

• SQL-005: Insert into CL_CLAIM_POLICY_HISTORY ( CLAIM_ID, EFF_DATE, POLICY_NUM, POLICY_SUB…
• SQL-046: Select CLAIM_ID as ClaimID, EFF_DATE as EffDate, POLICY_NUM as PolicyNum, POLICY…

---

CL_CLAIM_REQUEST_DECISION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsAccidentInjury, clsClaimRequestDecision, clsClaimRequestDecisionCollection within the SAIF.Business.Claim.Maintenance 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	clsAccidentInjury, clsClaimRequestDecision, clsClaimRequestDecisionCollection

Operations referencing this table

• clsClaimRequestDecision BeforeInsert
• clsAccidentInjury GetReqDecDtGTInjDtCount
• clsClaimRequestDecisionCollection BeforeRetrieve
• clsClaimRequestDecision BeforeUpdate

SQL referencing this table

• SQL-006: Insert into CL_CLAIM_REQUEST_DECISION ( CLAIM_ID, OWN_MOTION_BOARD_REF_DATE, OWN…
• SQL-025: Select Count (*) From CL_CLAIM_REQUEST_DECISION Where CL_CLAIM_REQUEST_DECISION.…
• SQL-047: Select CL_CLAIM_REQUEST_DECISION.CLAIM_ID as ClaimID, CL_CLAIM_REQUEST_DECISION.…
• SQL-090: Update CL_CLAIM_REQUEST_DECISION Set OWN_MOTION_BOARD_REF_DATE = TRUNC(:OwnMotio…

---

CL_CLAIM_STATUS_ACTIVITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimStatusActivity, clsClaimStatusActivityCollection within the SAIF.Business.Claim.Maintenance 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	clsClaimStatusActivity, clsClaimStatusActivityCollection

Operations referencing this table

• clsClaimStatusActivity BeforeInsert
• clsClaimStatusActivityCollection BeforeRetrieve
• clsClaimStatusActivity BeforeUpdate

SQL referencing this table

• SQL-007: Insert into CL_CLAIM_STATUS_ACTIVITY ( CLAIM_ID, CLAIM_STATUS_ACTIVITY_SEQ_NUM, …
• SQL-048: Select CL_CLAIM_STATUS_ACTIVITY.CLAIM_ID as ClaimID, CL_CLAIM_STATUS_ACTIVITY.CL…
• SQL-091: Update CL_CLAIM_STATUS_ACTIVITY Set CLAIM_STATUS_CODE = :ClaimStatusCode, EFF_DA…

---

CL_CLAIM_SUPPORT_ORDER_CONN

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimSupportOrderConn within the SAIF.Business.Claim.Maintenance 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	clsClaimSupportOrderConn

Operations referencing this table

• clsClaimSupportOrderConn BeforeInsert

SQL referencing this table

• SQL-009: Insert into CL_CLAIM_SUPPORT_ORDER_CONN ( CLAIM_ID, SUPPORT_ORDER_ID, UPDATE_DAT…

---

CL_CLAIM_TD_THREE_DAY_WAIT

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

Operations referencing this table

• clsTDThreeDayWait BeforeInsert
• clsTDThreeDayWaitCollection BeforeRetrieve
• clsTDThreeDayWait BeforeUpdate
• clsAccidentInjury BeforeUpdate

SQL referencing this table

• SQL-016: Insert into CL_CLAIM_TD_THREE_DAY_WAIT ( CLAIM_ID, CLAIM_TD_THREE_DA_WAIT_SEQ_NU…
• SQL-072: Select CLAIM_ID as ClaimID, CLAIM_TD_THREE_DA_WAIT_SEQ_NUM as ClaimTDThreeDaWait…
• SQL-098: Update CL_CLAIM_TD_THREE_DAY_WAIT Set UPDATE_DATE = SYSDATE, UPDATE_NUM = :Updat…
• SQL-106: Delete From CL_CLAIM_TD_THREE_DAY_WAIT Where CL_CLAIM_TD_THREE_DAY_WAIT.CLAIM_ID…

---

CL_CLAIM_TYPE_ACTIVITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimTypeActivity, clsClaimTypeActivityCollection within the SAIF.Business.Claim.Maintenance 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	clsClaimTypeActivity, clsClaimTypeActivityCollection

Operations referencing this table

• clsClaimTypeActivity BeforeInsert
• clsClaimTypeActivityCollection BeforeRetrieve
• clsClaimTypeActivity BeforeUpdate

SQL referencing this table

• SQL-010: Insert into CL_CLAIM_TYPE_ACTIVITY ( CLAIM_ID, CLAIM_TYPE_ACTIVITY_NUM, CLAIM_TY…
• SQL-061: Select CL_CLAIM_TYPE_ACTIVITY.CLAIM_ID as ClaimID, CL_CLAIM_TYPE_ACTIVITY.CLAIM_…
• SQL-093: Update CL_CLAIM_TYPE_ACTIVITY Set CLAIM_TYPE_CODE = :ClaimTypeCode, EFF_DATE = T…

---

CL_CLAIM_WORK_RELEASE_STATUS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsAccidentInjury, clsWorkRelease, clsWorkReleaseCollection within the SAIF.Business.Claim.Maintenance 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	clsAccidentInjury, clsWorkRelease, clsWorkReleaseCollection

Operations referencing this table

• clsWorkRelease BeforeInsert
• clsAccidentInjury GetWrkRelDtGTInjDtCount
• clsWorkReleaseCollection BeforeRetrieve
• clsWorkRelease BeforeUpdate

SQL referencing this table

• SQL-018: Insert into CL_CLAIM_WORK_RELEASE_STATUS ( CLAIM_ID, CLAIM_WORK_REL_STATUS_SEQ_N…
• SQL-027: Select Count (*) From CL_CLAIM_WORK_RELEASE_STATUS Where CL_CLAIM_WORK_RELEASE_S…
• SQL-074: Select CLAIM_ID as ClaimID, CLAIM_WORK_REL_STATUS_SEQ_NUM as ClaimWorkRelStatusS…
• SQL-100: Update CL_CLAIM_WORK_RELEASE_STATUS Set UPDATE_DATE = SYSDATE, UPDATE_NUM = :Upd…

---

CL_CLAIM_WORK_STATUS

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsWorkStatus, clsWorkStatusCollection within the SAIF.Business.Claim.Maintenance 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	clsWorkStatus, clsWorkStatusCollection

Operations referencing this table

• clsWorkStatus BeforeInsert
• clsWorkStatusCollection BeforeRetrieve
• clsWorkStatus BeforeUpdate

SQL referencing this table

• SQL-019: Insert into CL_CLAIM_WORK_STATUS ( CLAIM_ID, CLAIM_WORK_STATUS_SEQ_NUM, UPDATE_D…
• SQL-075: Select CLAIM_ID as ClaimID, CLAIM_WORK_STATUS_SEQ_NUM as ClaimWorkStatusSeqNum, …
• SQL-101: Update CL_CLAIM_WORK_STATUS Set UPDATE_DATE = SYSDATE, UPDATE_NUM = :UpdateNum +…

---

CL_COND_COMPENSABILITY_DECISN

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

Operations referencing this table

• clsConditionDecision BeforeInsert
• clsConditionDecisionCollection BeforeRetrieve
• clsConditionDecision BeforeUpdate
• clsConditionDecision BeforeDelete

SQL referencing this table

• SQL-011: Insert into CL_COND_COMPENSABILITY_DECISN (UPDATE_USER, UPDATE_NUM, UPDATE_DATE,…
• SQL-011: Insert into CL_COND_COMPENSABILITY_DECISN (UPDATE_USER, UPDATE_NUM, UPDATE_DATE,…
• SQL-062: Select UPDATE_USER as UpdateUser, UPDATE_NUM as UpdateNum, UPDATE_DATE as Update…
• SQL-094: Update CL_COND_COMPENSABILITY_DECISN Set UPDATE_USER = :UpdateUser, UPDATE_NUM =…
• SQL-113: Delete FROM CL_COND_COMPENSABILITY_DECISN Where CL_COND_COMPENSABILITY_DECISN.ME…

---

CL_COVID19_TESTING_HISTORY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsCovid19TestingHistory, clsCovid19TestingHistoryCollection within the SAIF.Business.Claim.Maintenance 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	clsCovid19TestingHistory, clsCovid19TestingHistoryCollection

Operations referencing this table

• clsCovid19TestingHistory BeforeInsert
• clsCovid19TestingHistoryCollection BeforeRetrieve

SQL referencing this table

• SQL-012: Insert into CL_COVID19_TESTING_HISTORY ( CLAIM_ID, CREATE_DATE, CREATE_USER, TES…
• SQL-063: Select CLAIM_ID as ClaimID, CREATE_DATE as CreateDate, CREATE_USER as CreateUser…

---

CL_DISABILITY_AUTH_ACTIVITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsAccidentInjury, clsDisabilityAuthActivity, clsDisabilityAuthActivityCollection within the SAIF.Business.Claim.Maintenance 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	clsAccidentInjury, clsDisabilityAuthActivity, clsDisabilityAuthActivityCollection

Operations referencing this table

• clsDisabilityAuthActivity BeforeInsert
• clsAccidentInjury GetDisabAuthDtGTInjDtCount
• clsDisabilityAuthActivityCollection BeforeRetrieve
• clsDisabilityAuthActivity BeforeUpdate

SQL referencing this table

• SQL-013: Insert into CL_DISABILITY_AUTH_ACTIVITY ( CLAIM_ID, DISABILITY_AUTH_REASON_CODE,…
• SQL-023: Select Count (*) From CL_DISABILITY_AUTH_ACTIVITY Where CL_DISABILITY_AUTH_ACTIV…
• SQL-065: Select CL_DISABILITY_AUTH_ACTIVITY.CLAIM_ID as ClaimID, CL_DISABILITY_AUTH_ACTIV…
• SQL-095: Update CL_DISABILITY_AUTH_ACTIVITY Set DISABILITY_AUTH_REASON_CODE = :Disability…

---

CL_INJURY_CLAIM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsAccidentInjury, clsClaimAdjustment, clsClaimDetail, clsClaimDisabilityActivityCollection, clsClaimPolicy, clsClaimSupportOrder, clsDisabilityAuthActivityCollection, clsWorkStatusInjuryClaim, clsWorkerInjuryClaim within the SAIF.Business.Claim.Maintenance 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	clsAccidentInjury, clsClaimAdjustment, clsClaimDetail, clsClaimDisabilityActivityCollection, clsClaimPolicy, clsClaimSupportOrder, clsDisabilityAuthActivityCollection, clsWorkStatusInjuryClaim, clsWorkerInjuryClaim

Operations referencing this table

• clsAccidentInjury CheckForMultipleClaimsForWorker
• clsAccidentInjury BeforeRetrieve
• clsClaimAdjustment NearbyClaimExists
• clsClaimDetail GetOWCPClaimNumberCount
• clsClaimDetail BeforeRetrieve
• clsClaimDetail GetWCDClaimNumberCount
• clsClaimDisabilityActivityCollection GetInjuryDate
• clsClaimPolicy BeforeRetrieve
• clsClaimSupportOrder CreateConnections
• clsDisabilityAuthActivityCollection GetInjuryDate
• clsWorkStatusInjuryClaim BeforeRetrieve
• clsWorkerInjuryClaim BeforeRetrieve
• clsAccidentInjury BeforeUpdate
• clsClaimDetail BeforeUpdate
• clsClaimPolicy BeforeUpdate
• clsWorkStatusInjuryClaim BeforeUpdate
• clsWorkerInjuryClaim BeforeUpdate

SQL referencing this table

• SQL-021: SELECT SAIF_CLAIM_NUM FROM CL_INJURY_CLAIM clm WHERE clm.WORKER_ID = :WorkerID A…
• SQL-026: Select CLM.CLAIM_ID as ClaimID, CLM.CLAIM_STATUS_CODE as ClaimStatusCode, CLM.CL…
• SQL-029: select count(*) from cl_injury_claim clm, (select claim_id, trunc(injury_date - …
• SQL-038: Select Count (*) From CL_INJURY_CLAIM Where CL_INJURY_CLAIM.OWCP_CLAIM_NUM = :OW…
• SQL-040: Select CL_INJURY_CLAIM.ACTIVE_CLAIM_FLAG as ActiveClaimFlag, CL_INJURY_CLAIM.CDA…
• SQL-041: Select Count (*) From CL_INJURY_CLAIM Where CL_INJURY_CLAIM.WCD_CLAIM_NUM = :WCD…
• SQL-042: Select CL_INJURY_CLAIM.INJURY_DATE AS InjuryDate, CL_INJURY_CLAIM.INJ_OCCUPATION…
• SQL-045: Select CLAIM_ID as ClaimID, INJURY_DATE as InjuryDate, POLICY_NUM as PolicyNum, …
• SQL-054: select claim_id from cl_injury_claim clm where(clm.WORKER_ID = :WorkerID) and cl…
• SQL-064: Select CL_INJURY_CLAIM.INJURY_DATE AS InjuryDate From CL_INJURY_CLAIM Where CL_I…
• SQL-076: Select CL_INJURY_CLAIM.CLAIM_ID as ClaimID, CL_INJURY_CLAIM.INJ_OCCUPATIONAL_DIS…
• SQL-079: Select CL_INJURY_CLAIM.ACTIVE_CLAIM_FLAG as ActiveClaimFlag, CL_INJURY_CLAIM.AGE…
• SQL-081: Update CL_INJURY_CLAIM Set CITY_NAME = :CityName, COUNTY_CODE = :CountyCode, EXP…
• SQL-087: Update CL_INJURY_CLAIM Set ACTIVE_CLAIM_FLAG = :ActiveClaimFlag, CLAIM_RESP_CODE…
• SQL-089: Update CL_INJURY_CLAIM Set POLICY_NUM = :PolicyNum, POLICY_SUB_CODE = :PolicySub…
• SQL-102: Update CL_INJURY_CLAIM Set LEAVE_WORK_DATE = :LeaveWorkDate, LEAVE_WORK_TIME = :…
• SQL-104: Update CL_INJURY_CLAIM Set AGE_DOI_YEARS = :AgeDoiYears, EDUCATION_YEARS = :Educ…

---

CL_MEDICAL_CONDITION

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

Operations referencing this table

• clsMedicalCondition BeforeInsert
• clsAccidentInjury GetMedStatDtGTInjDtCount
• clsClaimDetail GetAcceptCondMedStationaryCount
• clsClaimDetail GetConditionsCount
• clsMedicalCondition BeforeCreate
• clsMedicalConditionCollection BeforeRetrieve
• clsMedicalCondition BeforeUpdate
• clsMedicalCondition BeforeDelete

SQL referencing this table

• SQL-014: Insert into CL_MEDICAL_CONDITION (UPDATE_USER, UPDATE_NUM, UPDATE_DATE, MEDICAL_…
• SQL-024: Select Count (*) From CL_MEDICAL_CONDITION Where CL_MEDICAL_CONDITION.CLAIM_ID =…
• SQL-032: Select Count (*) From CL_MEDICAL_CONDITION, CL_COND_COMPENSABILITY_DECISN Where …
• SQL-034: Select Count (*) From CL_MEDICAL_CONDITION Where CL_MEDICAL_CONDITION.CLAIM_ID =…
• SQL-066: select NVL(MAX(MEDICAL_CONDITION_ID),0) + 1 from cl_medical_condition where clai…
• SQL-069: Select UPDATE_USER as UpdateUser, UPDATE_NUM as UpdateNum, UPDATE_DATE as Update…
• SQL-096: Update CL_MEDICAL_CONDITION Set UPDATE_USER = :UpdateUser, UPDATE_NUM = UPDATE_N…
• SQL-115: Delete FROM CL_MEDICAL_CONDITION Where CLAIM_ID = :ClaimID AND MEDICAL_CONDITION…

---

CL_MERGED_CLAIM

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimDetail within the SAIF.Business.Claim.Maintenance 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	clsClaimDetail

Operations referencing this table

• clsClaimDetail GetMergedClaim

SQL referencing this table

• SQL-037: Select CL_INJURY_CLAIM.SAIF_CLAIM_NUM as MergedClaimNum From CL_MERGED_CLAIM, CL…

---

CL_OMITTED_COND_DENIED

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

Operations referencing this table

• clsOmittedCondition BeforeInsert
• clsOmittedCondition BeforeCreate
• clsOmittedConditionCollection BeforeRetrieve
• clsOmittedCondition BeforeUpdate
• clsOmittedCondition BeforeDelete

SQL referencing this table

• SQL-015: Insert into CL_OMITTED_COND_DENIED (UPDATE_USER, UPDATE_NUM, UPDATE_DATE, OMITTE…
• SQL-070: select NVL(MAX(OMITTED_CONDITION_ID),0) + 1 from CL_OMITTED_COND_DENIED where cl…
• SQL-071: Select UPDATE_USER as UpdateUser, UPDATE_NUM as UpdateNum, UPDATE_DATE as Update…
• SQL-097: Update CL_OMITTED_COND_DENIED Set UPDATE_USER = :UpdateUser, UPDATE_NUM = UPDATE…
• SQL-116: Delete FROM CL_OMITTED_COND_DENIED Where CL_OMITTED_COND_DENIED.OMITTED_CONDITIO…

---

CL_PHARMACY_ELIGIBILITY_REPORT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsWorkerPharmacyEligibilityReport within the SAIF.Business.Claim.Maintenance 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	clsWorkerPharmacyEligibilityReport

Operations referencing this table

• clsWorkerPharmacyEligibilityReport BeforeInsert
• clsWorkerPharmacyEligibilityReport BeforeRetrieve
• clsWorkerPharmacyEligibilityReport BeforeUpdate

SQL referencing this table

• SQL-020: Insert into CL_PHARMACY_ELIGIBILITY_REPORT ( CLAIM_ID, ELIGIBILITY_STATUS_CODE, …
• SQL-080: Select CL_PHARMACY_ELIGIBILITY_REPORT.CLAIM_ID as ClaimID, CL_PHARMACY_ELIGIBILI…
• SQL-105: Update CL_PHARMACY_ELIGIBILITY_REPORT Set ELIGIBILITY_STATUS_CODE = :PharmacyEli…

---

DUAL

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

Operations referencing this table

• clsClaimSupportOrder identity/sequence generation

SQL referencing this table

• SQL-001: SELECT SUPPORT_ORDER_ID_SEQ.NEXTVAL FROM DUAL

---

MCO_GSA_LOCATION

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsClaimDetail within the SAIF.Business.Claim.Maintenance 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	clsClaimDetail

Operations referencing this table

• clsClaimDetail RetrieveMCOPlanID

SQL referencing this table

• SQL-036: SELECT MCO_PLAN_ID as McoPlanID FROM MCO_GSA_LOCATION WHERE MCO_ID = :McoID

---

VOCATIONAL_DETAIL

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

Operations referencing this table

• clsVocationalDetail BeforeInsert
• clsVocationalDetail BeforeUpdate

SQL referencing this table

• SQL-017: Insert into VOCATIONAL_DETAIL ( CLAIM_ID, PARENT_PROVIDER_LOC_SEQ_NUM, PROVIDER_…
• SQL-099: Update VOCATIONAL_DETAIL Set CLAIM_ID = :ClaimID, PARENT_PROVIDER_LOC_SEQ_NUM = …

---

ZIP_MCO_COUNTY

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by clsAccidentInjury within the SAIF.Business.Claim.Maintenance 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	clsAccidentInjury

Operations referencing this table

• clsAccidentInjury DetermineCountyCode

SQL referencing this table

• SQL-022: SELECT unique(county_code) FROM ZIP_MCO_COUNTY WHERE ZIP_CODE = :ZipCode

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 * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.Claim.Maintenance\clsAccidentInjury.vb
• Business\SAIF.Business.Claim.Maintenance\clsAttendingPhysician.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimAdjustment.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimDetail.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimDisabilityActivity.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimDisabilityActivityCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimMcoEligibility.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimMcoEligibilityCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimPolicy.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimPolicyHistory.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimPolicyHistoryCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimRequestDecision.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimRequestDecisionCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimStatusActivity.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimStatusActivityCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimSupportOrder.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimSupportOrderCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimSupportOrderConn.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimSupportOrderConnCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimTypeActivity.vb
• Business\SAIF.Business.Claim.Maintenance\clsClaimTypeActivityCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsConditionDecision.vb
• Business\SAIF.Business.Claim.Maintenance\clsConditionDecisionCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsCovid19TestingHistory.vb
• Business\SAIF.Business.Claim.Maintenance\clsCovid19TestingHistoryCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsDisabilityAuthActivity.vb
• Business\SAIF.Business.Claim.Maintenance\clsDisabilityAuthActivityCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsMedicalCondition.vb
• Business\SAIF.Business.Claim.Maintenance\clsMedicalConditionCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsOmittedCondition.vb
• Business\SAIF.Business.Claim.Maintenance\clsOmittedConditionCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsTDThreeDayWait.vb
• Business\SAIF.Business.Claim.Maintenance\clsTDThreeDayWaitCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsVocationalDetail.vb
• Business\SAIF.Business.Claim.Maintenance\clsVocationalDetailCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsWorkRelease.vb
• Business\SAIF.Business.Claim.Maintenance\clsWorkReleaseCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsWorkStatus.vb
• Business\SAIF.Business.Claim.Maintenance\clsWorkStatusCollection.vb
• Business\SAIF.Business.Claim.Maintenance\clsWorkStatusInjuryClaim.vb
• Business\SAIF.Business.Claim.Maintenance\clsWorkerClaimBenefitPayment.vb
• Business\SAIF.Business.Claim.Maintenance\clsWorkerClaimBenefitSchedule.vb
• Business\SAIF.Business.Claim.Maintenance\clsWorkerInjuryClaim.vb
• Business\SAIF.Business.Claim.Maintenance\clsWorkerPharmacyEligibilityReport.vb