--- title: SAIF.Business.Claim.Maintenance database tables summary: Database tables used by SAIF.Business.Claim.Maintenance. status: draft owner: SAIF Doc Gen last_reviewed: 2026-07-28 library: SAIF.Business.Claim.Maintenance reference_type: package --- # 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](#attending_phys_exp_reason_code) | Oracle | `[unqualified]`** | R | Used by clsAttendingPhysician for persisted claim workflows. | `clsAttendingPhysician` | | [CBP_DIAGNOSIS](#cbp_diagnosis) | Oracle | `[unqualified]`** | R | Used by clsMedicalCondition for persisted claim workflows. | `clsMedicalCondition` | | [CL_BENEFIT_PAYMENT](#cl_benefit_payment) | Oracle | `[unqualified]`** | R | Used by clsWorkerClaimBenefitPayment for persisted claim workflows. | `clsWorkerClaimBenefitPayment` | | [CL_BENEFIT_PERIOD](#cl_benefit_period) | Oracle | `[unqualified]`** | R | Used by clsClaimDetail for persisted claim workflows. | `clsClaimDetail` | | [CL_BENEFIT_SCHEDULE](#cl_benefit_schedule) | Oracle | `[unqualified]`** | RU | Used by clsWorkerClaimBenefitSchedule for persisted claim workflows. | `clsWorkerClaimBenefitSchedule` | | [CL_CLAIM_DISABILITY_ACTIVITY](#cl_claim_disability_activity) | Oracle | `[unqualified]`** | CRU | Used by clsClaimDisabilityActivity, clsClaimDisabilityActivityCollection for persisted claim workflows. | `clsClaimDisabilityActivity, clsClaimDisabilityActivityCollection` | | [CL_CLAIM_LEGAL_REPRESENTATIVE](#cl_claim_legal_representative) | Oracle | `[unqualified]`** | RU | Used by clsClaimDetail for persisted claim workflows. | `clsClaimDetail` | | [CL_CLAIM_MCO_ELIGIBILITY](#cl_claim_mco_eligibility) | Oracle | `[unqualified]`** | CR | Used by clsClaimMcoEligibility, clsClaimMcoEligibilityCollection for persisted claim workflows. | `clsClaimMcoEligibility, clsClaimMcoEligibilityCollection` | | [CL_CLAIM_PERSON](#cl_claim_person) | Oracle | `[unqualified]`** | R | Used by clsClaimAdjustment, clsClaimDetail for persisted claim workflows. | `clsClaimAdjustment, clsClaimDetail` | | [CL_CLAIM_POLICY_HISTORY](#cl_claim_policy_history) | Oracle | `[unqualified]`** | CR | Used by clsClaimPolicyHistory, clsClaimPolicyHistoryCollection for persisted claim workflows. | `clsClaimPolicyHistory, clsClaimPolicyHistoryCollection` | | [CL_CLAIM_REQUEST_DECISION](#cl_claim_request_decision) | Oracle | `[unqualified]`** | CRU | Used by clsAccidentInjury, clsClaimRequestDecision, clsClaimRequestDecisionCollection for persisted claim workflows. | `clsAccidentInjury, clsClaimRequestDecision, clsClaimRequestDecisionCollection` | | [CL_CLAIM_STATUS_ACTIVITY](#cl_claim_status_activity) | Oracle | `[unqualified]`** | CRU | Used by clsClaimStatusActivity, clsClaimStatusActivityCollection for persisted claim workflows. | `clsClaimStatusActivity, clsClaimStatusActivityCollection` | | [CL_CLAIM_SUPPORT_ORDER_CONN](#cl_claim_support_order_conn) | Oracle | `[unqualified]`** | C | Used by clsClaimSupportOrderConn for persisted claim workflows. | `clsClaimSupportOrderConn` | | [CL_CLAIM_TD_THREE_DAY_WAIT](#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](#cl_claim_type_activity) | Oracle | `[unqualified]`** | CRU | Used by clsClaimTypeActivity, clsClaimTypeActivityCollection for persisted claim workflows. | `clsClaimTypeActivity, clsClaimTypeActivityCollection` | | [CL_CLAIM_WORK_RELEASE_STATUS](#cl_claim_work_release_status) | Oracle | `[unqualified]`** | CRU | Used by clsAccidentInjury, clsWorkRelease, clsWorkReleaseCollection for persisted claim workflows. | `clsAccidentInjury, clsWorkRelease, clsWorkReleaseCollection` | | [CL_CLAIM_WORK_STATUS](#cl_claim_work_status) | Oracle | `[unqualified]`** | CRU | Used by clsWorkStatus, clsWorkStatusCollection for persisted claim workflows. | `clsWorkStatus, clsWorkStatusCollection` | | [CL_COND_COMPENSABILITY_DECISN](#cl_cond_compensability_decisn) | Oracle | `[unqualified]`** | CDRU | Used by clsConditionDecision, clsConditionDecisionCollection for persisted claim workflows. | `clsConditionDecision, clsConditionDecisionCollection` | | [CL_COVID19_TESTING_HISTORY](#cl_covid19_testing_history) | Oracle | `[unqualified]`** | CR | Used by clsCovid19TestingHistory, clsCovid19TestingHistoryCollection for persisted claim workflows. | `clsCovid19TestingHistory, clsCovid19TestingHistoryCollection` | | [CL_DISABILITY_AUTH_ACTIVITY](#cl_disability_auth_activity) | Oracle | `[unqualified]`** | CRU | Used by clsAccidentInjury, clsDisabilityAuthActivity, clsDisabilityAuthActivityCollection for persisted claim workflows. | `clsAccidentInjury, clsDisabilityAuthActivity, clsDisabilityAuthActivityCollection` | | [CL_INJURY_CLAIM](#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](#cl_medical_condition) | Oracle | `[unqualified]`** | CDRU | Used by clsAccidentInjury, clsClaimDetail, clsMedicalCondition, clsMedicalConditionCollection for persisted claim workflows. | `clsAccidentInjury, clsClaimDetail, clsMedicalCondition, clsMedicalConditionCollection` | | [CL_MERGED_CLAIM](#cl_merged_claim) | Oracle | `[unqualified]`** | R | Used by clsClaimDetail for persisted claim workflows. | `clsClaimDetail` | | [CL_OMITTED_COND_DENIED](#cl_omitted_cond_denied) | Oracle | `[unqualified]`** | CDRU | Used by clsOmittedCondition, clsOmittedConditionCollection for persisted claim workflows. | `clsOmittedCondition, clsOmittedConditionCollection` | | [CL_PHARMACY_ELIGIBILITY_REPORT](#cl_pharmacy_eligibility_report) | Oracle | `[unqualified]`** | CRU | Used by clsWorkerPharmacyEligibilityReport for persisted claim workflows. | `clsWorkerPharmacyEligibilityReport` | | [DUAL](#dual) | Oracle | `[unqualified]`** | S | Used by clsClaimSupportOrder for persisted claim workflows. | `clsClaimSupportOrder` | | [MCO_GSA_LOCATION](#mco_gsa_location) | Oracle | `[unqualified]`** | R | Used by clsClaimDetail for persisted claim workflows. | `clsClaimDetail` | | [VOCATIONAL_DETAIL](#vocational_detail) | Oracle | `[unqualified]`** | CU | Used by clsVocationalDetail for persisted claim workflows. | `clsVocationalDetail` | | [ZIP_MCO_COUNTY](#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](operations/attending-physician-retrieval.md) ### SQL referencing this table - [SQL-028: select code, code_descr from attending_phys_exp_reason_code order by code_descr](sql/SQL-028.md) --- ## 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](operations/medical-condition-management.md) - [clsMedicalCondition DiagnosisCodeIsMedicareReportable](operations/medical-condition-management.md) ### SQL referencing this table - [SQL-067: Select Count (*) From CBP_DIAGNOSIS Where CBP_DIAGNOSIS.DIAGNOSIS_CODE = :Diagno…](sql/SQL-067.md) - [SQL-068: Select Count (*) From CBP_DIAGNOSIS Where CBP_DIAGNOSIS.DIAGNOSIS_CODE = :Diagno…](sql/SQL-068.md) --- ## 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](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-077: Select CL_BENEFIT_PAYMENT.BENEFIT_PAYMENT_SEQ_NUM as BenefitPaymentSeqNum, CL_BE…](sql/SQL-077.md) --- ## 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](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-033: Select Count (*) From CL_BENEFIT_PERIOD Where CL_BENEFIT_PERIOD.CLAIM_ID = :Clai…](sql/SQL-033.md) --- ## 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](operations/claim-detail-crud.md) - [clsWorkerClaimBenefitSchedule BeforeUpdate](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-078: Select CL_BENEFIT_SCHEDULE.BENEFIT_PAYMENT_SUB_NUM as BenefitPaymentSubNum, CL_B…](sql/SQL-078.md) - [SQL-103: Update CL_BENEFIT_SCHEDULE Set REMAINING_PAYMENT_COUNT = 1, UPDATE_DATE = :Updat…](sql/SQL-103.md) --- ## 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](operations/disability-activity-tracking.md) - [clsClaimDisabilityActivityCollection BeforeRetrieve](operations/disability-activity-tracking.md) - [clsClaimDisabilityActivity BeforeUpdate](operations/disability-activity-tracking.md) ### SQL referencing this table - [SQL-003: Insert into CL_CLAIM_DISABILITY_ACTIVITY ( CLAIM_ID, DISABILITY_ACTIVITY_SUB_NUM…](sql/SQL-003.md) - [SQL-043: Select CL_CLAIM_DISABILITY_ACTIVITY.CLAIM_ID as ClaimID, CL_CLAIM_DISABILITY_ACT…](sql/SQL-043.md) - [SQL-088: Update CL_CLAIM_DISABILITY_ACTIVITY Set DISABILITY_DATE = TRUNC(:DisabilityDate)…](sql/SQL-088.md) --- ## 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](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-035: Select CL_CLAIM_LEGAL_REPRESENTATIVE.EFF_DATE as LegalRepEffDate From CL_CLAIM_L…](sql/SQL-035.md) - [SQL-086: Update CL_CLAIM_LEGAL_REPRESENTATIVE Set EXP_DATE = TRUNC(SYSDATE), LEGAL_REP_EN…](sql/SQL-086.md) --- ## 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](operations/claim-detail-crud.md) - [clsClaimMcoEligibilityCollection BeforeRetrieve](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-004: Insert into CL_CLAIM_MCO_ELIGIBILITY ( CLAIM_ID, MCO_ELIGIBILITY_REASON_CODE, MC…](sql/SQL-004.md) - [SQL-044: Select CL_CLAIM_MCO_ELIGIBILITY.CLAIM_ID as ClaimID, CL_CLAIM_MCO_ELIGIBILITY.MC…](sql/SQL-044.md) --- ## 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](operations/claim-adjustment.md) - [clsClaimDetail GetPMAWorkerNumberCount](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-030: SELECT PERSON_ID as PersonID, PRIMARY_TAX_ID as PrimaryTaxID, PRIMARY_FIRST_NAME…](sql/SQL-030.md) - [SQL-031: SELECT PERSON_ID as PersonID, PRIMARY_TAX_ID as PrimaryTaxID, PRIMARY_FIRST_NAME…](sql/SQL-031.md) - [SQL-039: Select Count (*) From CL_CLAIM_PERSON Where CL_CLAIM_PERSON.PMA_WORKER_NUM = :PM…](sql/SQL-039.md) --- ## 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](operations/policy-history-tracking.md) - [clsClaimPolicyHistoryCollection BeforeRetrieve](operations/policy-history-tracking.md) ### SQL referencing this table - [SQL-005: Insert into CL_CLAIM_POLICY_HISTORY ( CLAIM_ID, EFF_DATE, POLICY_NUM, POLICY_SUB…](sql/SQL-005.md) - [SQL-046: Select CLAIM_ID as ClaimID, EFF_DATE as EffDate, POLICY_NUM as PolicyNum, POLICY…](sql/SQL-046.md) --- ## 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](operations/claim-detail-crud.md) - [clsAccidentInjury GetReqDecDtGTInjDtCount](operations/accident-injury-management.md) - [clsClaimRequestDecisionCollection BeforeRetrieve](operations/claim-detail-crud.md) - [clsClaimRequestDecision BeforeUpdate](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-006: Insert into CL_CLAIM_REQUEST_DECISION ( CLAIM_ID, OWN_MOTION_BOARD_REF_DATE, OWN…](sql/SQL-006.md) - [SQL-025: Select Count (*) From CL_CLAIM_REQUEST_DECISION Where CL_CLAIM_REQUEST_DECISION.…](sql/SQL-025.md) - [SQL-047: Select CL_CLAIM_REQUEST_DECISION.CLAIM_ID as ClaimID, CL_CLAIM_REQUEST_DECISION.…](sql/SQL-047.md) - [SQL-090: Update CL_CLAIM_REQUEST_DECISION Set OWN_MOTION_BOARD_REF_DATE = TRUNC(:OwnMotio…](sql/SQL-090.md) --- ## 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](operations/claim-detail-crud.md) - [clsClaimStatusActivityCollection BeforeRetrieve](operations/claim-detail-crud.md) - [clsClaimStatusActivity BeforeUpdate](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-007: Insert into CL_CLAIM_STATUS_ACTIVITY ( CLAIM_ID, CLAIM_STATUS_ACTIVITY_SEQ_NUM, …](sql/SQL-007.md) - [SQL-048: Select CL_CLAIM_STATUS_ACTIVITY.CLAIM_ID as ClaimID, CL_CLAIM_STATUS_ACTIVITY.CL…](sql/SQL-048.md) - [SQL-091: Update CL_CLAIM_STATUS_ACTIVITY Set CLAIM_STATUS_CODE = :ClaimStatusCode, EFF_DA…](sql/SQL-091.md) --- ## 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](operations/support-order-management.md) ### SQL referencing this table - [SQL-009: Insert into CL_CLAIM_SUPPORT_ORDER_CONN ( CLAIM_ID, SUPPORT_ORDER_ID, UPDATE_DAT…](sql/SQL-009.md) --- ## 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](operations/claim-detail-crud.md) - [clsTDThreeDayWaitCollection BeforeRetrieve](operations/claim-detail-crud.md) - [clsTDThreeDayWait BeforeUpdate](operations/claim-detail-crud.md) - [clsAccidentInjury BeforeUpdate](operations/accident-injury-management.md) ### SQL referencing this table - [SQL-016: Insert into CL_CLAIM_TD_THREE_DAY_WAIT ( CLAIM_ID, CLAIM_TD_THREE_DA_WAIT_SEQ_NU…](sql/SQL-016.md) - [SQL-072: Select CLAIM_ID as ClaimID, CLAIM_TD_THREE_DA_WAIT_SEQ_NUM as ClaimTDThreeDaWait…](sql/SQL-072.md) - [SQL-098: Update CL_CLAIM_TD_THREE_DAY_WAIT Set UPDATE_DATE = SYSDATE, UPDATE_NUM = :Updat…](sql/SQL-098.md) - [SQL-106: Delete From CL_CLAIM_TD_THREE_DAY_WAIT Where CL_CLAIM_TD_THREE_DAY_WAIT.CLAIM_ID…](sql/SQL-106.md) --- ## 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](operations/claim-detail-crud.md) - [clsClaimTypeActivityCollection BeforeRetrieve](operations/claim-detail-crud.md) - [clsClaimTypeActivity BeforeUpdate](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-010: Insert into CL_CLAIM_TYPE_ACTIVITY ( CLAIM_ID, CLAIM_TYPE_ACTIVITY_NUM, CLAIM_TY…](sql/SQL-010.md) - [SQL-061: Select CL_CLAIM_TYPE_ACTIVITY.CLAIM_ID as ClaimID, CL_CLAIM_TYPE_ACTIVITY.CLAIM_…](sql/SQL-061.md) - [SQL-093: Update CL_CLAIM_TYPE_ACTIVITY Set CLAIM_TYPE_CODE = :ClaimTypeCode, EFF_DATE = T…](sql/SQL-093.md) --- ## 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](operations/work-release-status-management.md) - [clsAccidentInjury GetWrkRelDtGTInjDtCount](operations/accident-injury-management.md) - [clsWorkReleaseCollection BeforeRetrieve](operations/work-release-status-management.md) - [clsWorkRelease BeforeUpdate](operations/work-release-status-management.md) ### SQL referencing this table - [SQL-018: Insert into CL_CLAIM_WORK_RELEASE_STATUS ( CLAIM_ID, CLAIM_WORK_REL_STATUS_SEQ_N…](sql/SQL-018.md) - [SQL-027: Select Count (*) From CL_CLAIM_WORK_RELEASE_STATUS Where CL_CLAIM_WORK_RELEASE_S…](sql/SQL-027.md) - [SQL-074: Select CLAIM_ID as ClaimID, CLAIM_WORK_REL_STATUS_SEQ_NUM as ClaimWorkRelStatusS…](sql/SQL-074.md) - [SQL-100: Update CL_CLAIM_WORK_RELEASE_STATUS Set UPDATE_DATE = SYSDATE, UPDATE_NUM = :Upd…](sql/SQL-100.md) --- ## 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](operations/work-release-status-management.md) - [clsWorkStatusCollection BeforeRetrieve](operations/work-release-status-management.md) - [clsWorkStatus BeforeUpdate](operations/work-release-status-management.md) ### SQL referencing this table - [SQL-019: Insert into CL_CLAIM_WORK_STATUS ( CLAIM_ID, CLAIM_WORK_STATUS_SEQ_NUM, UPDATE_D…](sql/SQL-019.md) - [SQL-075: Select CLAIM_ID as ClaimID, CLAIM_WORK_STATUS_SEQ_NUM as ClaimWorkStatusSeqNum, …](sql/SQL-075.md) - [SQL-101: Update CL_CLAIM_WORK_STATUS Set UPDATE_DATE = SYSDATE, UPDATE_NUM = :UpdateNum +…](sql/SQL-101.md) --- ## 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](operations/medical-condition-management.md) - [clsConditionDecisionCollection BeforeRetrieve](operations/medical-condition-management.md) - [clsConditionDecision BeforeUpdate](operations/medical-condition-management.md) - [clsConditionDecision BeforeDelete](operations/medical-condition-management.md) ### SQL referencing this table - [SQL-011: Insert into CL_COND_COMPENSABILITY_DECISN (UPDATE_USER, UPDATE_NUM, UPDATE_DATE,…](sql/SQL-011.md) - [SQL-011: Insert into CL_COND_COMPENSABILITY_DECISN (UPDATE_USER, UPDATE_NUM, UPDATE_DATE,…](sql/SQL-011.md) - [SQL-062: Select UPDATE_USER as UpdateUser, UPDATE_NUM as UpdateNum, UPDATE_DATE as Update…](sql/SQL-062.md) - [SQL-094: Update CL_COND_COMPENSABILITY_DECISN Set UPDATE_USER = :UpdateUser, UPDATE_NUM =…](sql/SQL-094.md) - [SQL-113: Delete FROM CL_COND_COMPENSABILITY_DECISN Where CL_COND_COMPENSABILITY_DECISN.ME…](sql/SQL-113.md) --- ## 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](operations/covid-19-testing-history.md) - [clsCovid19TestingHistoryCollection BeforeRetrieve](operations/covid-19-testing-history.md) ### SQL referencing this table - [SQL-012: Insert into CL_COVID19_TESTING_HISTORY ( CLAIM_ID, CREATE_DATE, CREATE_USER, TES…](sql/SQL-012.md) - [SQL-063: Select CLAIM_ID as ClaimID, CREATE_DATE as CreateDate, CREATE_USER as CreateUser…](sql/SQL-063.md) --- ## 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](operations/disability-activity-tracking.md) - [clsAccidentInjury GetDisabAuthDtGTInjDtCount](operations/accident-injury-management.md) - [clsDisabilityAuthActivityCollection BeforeRetrieve](operations/disability-activity-tracking.md) - [clsDisabilityAuthActivity BeforeUpdate](operations/disability-activity-tracking.md) ### SQL referencing this table - [SQL-013: Insert into CL_DISABILITY_AUTH_ACTIVITY ( CLAIM_ID, DISABILITY_AUTH_REASON_CODE,…](sql/SQL-013.md) - [SQL-023: Select Count (*) From CL_DISABILITY_AUTH_ACTIVITY Where CL_DISABILITY_AUTH_ACTIV…](sql/SQL-023.md) - [SQL-065: Select CL_DISABILITY_AUTH_ACTIVITY.CLAIM_ID as ClaimID, CL_DISABILITY_AUTH_ACTIV…](sql/SQL-065.md) - [SQL-095: Update CL_DISABILITY_AUTH_ACTIVITY Set DISABILITY_AUTH_REASON_CODE = :Disability…](sql/SQL-095.md) --- ## 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](operations/accident-injury-management.md) - [clsAccidentInjury BeforeRetrieve](operations/accident-injury-management.md) - [clsClaimAdjustment NearbyClaimExists](operations/claim-adjustment.md) - [clsClaimDetail GetOWCPClaimNumberCount](operations/claim-detail-crud.md) - [clsClaimDetail BeforeRetrieve](operations/claim-detail-crud.md) - [clsClaimDetail GetWCDClaimNumberCount](operations/claim-detail-crud.md) - [clsClaimDisabilityActivityCollection GetInjuryDate](operations/disability-activity-tracking.md) - [clsClaimPolicy BeforeRetrieve](operations/policy-history-tracking.md) - [clsClaimSupportOrder CreateConnections](operations/support-order-management.md) - [clsDisabilityAuthActivityCollection GetInjuryDate](operations/disability-activity-tracking.md) - [clsWorkStatusInjuryClaim BeforeRetrieve](operations/work-release-status-management.md) - [clsWorkerInjuryClaim BeforeRetrieve](operations/claim-detail-crud.md) - [clsAccidentInjury BeforeUpdate](operations/accident-injury-management.md) - [clsClaimDetail BeforeUpdate](operations/claim-detail-crud.md) - [clsClaimPolicy BeforeUpdate](operations/policy-history-tracking.md) - [clsWorkStatusInjuryClaim BeforeUpdate](operations/work-release-status-management.md) - [clsWorkerInjuryClaim BeforeUpdate](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-021: SELECT SAIF_CLAIM_NUM FROM CL_INJURY_CLAIM clm WHERE clm.WORKER_ID = :WorkerID A…](sql/SQL-021.md) - [SQL-026: Select CLM.CLAIM_ID as ClaimID, CLM.CLAIM_STATUS_CODE as ClaimStatusCode, CLM.CL…](sql/SQL-026.md) - [SQL-029: select count(*) from cl_injury_claim clm, (select claim_id, trunc(injury_date - …](sql/SQL-029.md) - [SQL-038: Select Count (*) From CL_INJURY_CLAIM Where CL_INJURY_CLAIM.OWCP_CLAIM_NUM = :OW…](sql/SQL-038.md) - [SQL-040: Select CL_INJURY_CLAIM.ACTIVE_CLAIM_FLAG as ActiveClaimFlag, CL_INJURY_CLAIM.CDA…](sql/SQL-040.md) - [SQL-041: Select Count (*) From CL_INJURY_CLAIM Where CL_INJURY_CLAIM.WCD_CLAIM_NUM = :WCD…](sql/SQL-041.md) - [SQL-042: Select CL_INJURY_CLAIM.INJURY_DATE AS InjuryDate, CL_INJURY_CLAIM.INJ_OCCUPATION…](sql/SQL-042.md) - [SQL-045: Select CLAIM_ID as ClaimID, INJURY_DATE as InjuryDate, POLICY_NUM as PolicyNum, …](sql/SQL-045.md) - [SQL-054: select claim_id from cl_injury_claim clm where(clm.WORKER_ID = :WorkerID) and cl…](sql/SQL-054.md) - [SQL-064: Select CL_INJURY_CLAIM.INJURY_DATE AS InjuryDate From CL_INJURY_CLAIM Where CL_I…](sql/SQL-064.md) - [SQL-076: Select CL_INJURY_CLAIM.CLAIM_ID as ClaimID, CL_INJURY_CLAIM.INJ_OCCUPATIONAL_DIS…](sql/SQL-076.md) - [SQL-079: Select CL_INJURY_CLAIM.ACTIVE_CLAIM_FLAG as ActiveClaimFlag, CL_INJURY_CLAIM.AGE…](sql/SQL-079.md) - [SQL-081: Update CL_INJURY_CLAIM Set CITY_NAME = :CityName, COUNTY_CODE = :CountyCode, EXP…](sql/SQL-081.md) - [SQL-087: Update CL_INJURY_CLAIM Set ACTIVE_CLAIM_FLAG = :ActiveClaimFlag, CLAIM_RESP_CODE…](sql/SQL-087.md) - [SQL-089: Update CL_INJURY_CLAIM Set POLICY_NUM = :PolicyNum, POLICY_SUB_CODE = :PolicySub…](sql/SQL-089.md) - [SQL-102: Update CL_INJURY_CLAIM Set LEAVE_WORK_DATE = :LeaveWorkDate, LEAVE_WORK_TIME = :…](sql/SQL-102.md) - [SQL-104: Update CL_INJURY_CLAIM Set AGE_DOI_YEARS = :AgeDoiYears, EDUCATION_YEARS = :Educ…](sql/SQL-104.md) --- ## 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](operations/medical-condition-management.md) - [clsAccidentInjury GetMedStatDtGTInjDtCount](operations/accident-injury-management.md) - [clsClaimDetail GetAcceptCondMedStationaryCount](operations/claim-detail-crud.md) - [clsClaimDetail GetConditionsCount](operations/claim-detail-crud.md) - [clsMedicalCondition BeforeCreate](operations/medical-condition-management.md) - [clsMedicalConditionCollection BeforeRetrieve](operations/medical-condition-management.md) - [clsMedicalCondition BeforeUpdate](operations/medical-condition-management.md) - [clsMedicalCondition BeforeDelete](operations/medical-condition-management.md) ### SQL referencing this table - [SQL-014: Insert into CL_MEDICAL_CONDITION (UPDATE_USER, UPDATE_NUM, UPDATE_DATE, MEDICAL_…](sql/SQL-014.md) - [SQL-024: Select Count (*) From CL_MEDICAL_CONDITION Where CL_MEDICAL_CONDITION.CLAIM_ID =…](sql/SQL-024.md) - [SQL-032: Select Count (*) From CL_MEDICAL_CONDITION, CL_COND_COMPENSABILITY_DECISN Where …](sql/SQL-032.md) - [SQL-034: Select Count (*) From CL_MEDICAL_CONDITION Where CL_MEDICAL_CONDITION.CLAIM_ID =…](sql/SQL-034.md) - [SQL-066: select NVL(MAX(MEDICAL_CONDITION_ID),0) + 1 from cl_medical_condition where clai…](sql/SQL-066.md) - [SQL-069: Select UPDATE_USER as UpdateUser, UPDATE_NUM as UpdateNum, UPDATE_DATE as Update…](sql/SQL-069.md) - [SQL-096: Update CL_MEDICAL_CONDITION Set UPDATE_USER = :UpdateUser, UPDATE_NUM = UPDATE_N…](sql/SQL-096.md) - [SQL-115: Delete FROM CL_MEDICAL_CONDITION Where CLAIM_ID = :ClaimID AND MEDICAL_CONDITION…](sql/SQL-115.md) --- ## 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](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-037: Select CL_INJURY_CLAIM.SAIF_CLAIM_NUM as MergedClaimNum From CL_MERGED_CLAIM, CL…](sql/SQL-037.md) --- ## 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](operations/medical-condition-management.md) - [clsOmittedCondition BeforeCreate](operations/medical-condition-management.md) - [clsOmittedConditionCollection BeforeRetrieve](operations/medical-condition-management.md) - [clsOmittedCondition BeforeUpdate](operations/medical-condition-management.md) - [clsOmittedCondition BeforeDelete](operations/medical-condition-management.md) ### SQL referencing this table - [SQL-015: Insert into CL_OMITTED_COND_DENIED (UPDATE_USER, UPDATE_NUM, UPDATE_DATE, OMITTE…](sql/SQL-015.md) - [SQL-070: select NVL(MAX(OMITTED_CONDITION_ID),0) + 1 from CL_OMITTED_COND_DENIED where cl…](sql/SQL-070.md) - [SQL-071: Select UPDATE_USER as UpdateUser, UPDATE_NUM as UpdateNum, UPDATE_DATE as Update…](sql/SQL-071.md) - [SQL-097: Update CL_OMITTED_COND_DENIED Set UPDATE_USER = :UpdateUser, UPDATE_NUM = UPDATE…](sql/SQL-097.md) - [SQL-116: Delete FROM CL_OMITTED_COND_DENIED Where CL_OMITTED_COND_DENIED.OMITTED_CONDITIO…](sql/SQL-116.md) --- ## 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](operations/claim-detail-crud.md) - [clsWorkerPharmacyEligibilityReport BeforeRetrieve](operations/claim-detail-crud.md) - [clsWorkerPharmacyEligibilityReport BeforeUpdate](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-020: Insert into CL_PHARMACY_ELIGIBILITY_REPORT ( CLAIM_ID, ELIGIBILITY_STATUS_CODE, …](sql/SQL-020.md) - [SQL-080: Select CL_PHARMACY_ELIGIBILITY_REPORT.CLAIM_ID as ClaimID, CL_PHARMACY_ELIGIBILI…](sql/SQL-080.md) - [SQL-105: Update CL_PHARMACY_ELIGIBILITY_REPORT Set ELIGIBILITY_STATUS_CODE = :PharmacyEli…](sql/SQL-105.md) --- ## 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](operations/support-order-management.md) ### SQL referencing this table - [SQL-001: SELECT SUPPORT_ORDER_ID_SEQ.NEXTVAL FROM DUAL](sql/SQL-001.md) --- ## 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](operations/claim-detail-crud.md) ### SQL referencing this table - [SQL-036: SELECT MCO_PLAN_ID as McoPlanID FROM MCO_GSA_LOCATION WHERE MCO_ID = :McoID](sql/SQL-036.md) --- ## 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](operations/vocational-data-retrieval.md) - [clsVocationalDetail BeforeUpdate](operations/vocational-data-retrieval.md) ### SQL referencing this table - [SQL-017: Insert into VOCATIONAL_DETAIL ( CLAIM_ID, PARENT_PROVIDER_LOC_SEQ_NUM, PROVIDER_…](sql/SQL-017.md) - [SQL-099: Update VOCATIONAL_DETAIL Set CLAIM_ID = :ClaimID, PARENT_PROVIDER_LOC_SEQ_NUM = …](sql/SQL-099.md) --- ## 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](operations/accident-injury-management.md) ### SQL referencing this table - [SQL-022: SELECT unique(county_code) FROM ZIP_MCO_COUNTY WHERE ZIP_CODE = :ZipCode](sql/SQL-022.md) ## Table relationship diagram No cross-table relationships were identified in this library's SQL. ## Related documentation - [Index](index.md) - [Overview](overview.md) - [Architecture](architecture.md) - [Dependencies](dependencies.md) - [Operations and processes](operations-processes.md) - [Business rules](business-rules.md) - [SQL catalog](sql/index.md) - [Procedures](procedures/index.md) - [API reference](api/index.md) > **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`