SAIF.Business.Claim.Maintenance SQL catalog¶
This page indexes SQL statements and stored-procedure calls used by SAIF.Business.Claim.Maintenance.
Create operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-003 | Inline create used by clsClaimDisabilityActivity | Inline | CL_CLAIM_DISABILITY_ACTIVITY | clsClaimDisabilityActivity |
| SQL-004 | Inline create used by clsClaimMcoEligibility | Inline | CL_CLAIM_MCO_ELIGIBILITY | clsClaimMcoEligibility |
| SQL-005 | Inline create used by clsClaimPolicyHistory | Inline | CL_CLAIM_POLICY_HISTORY | clsClaimPolicyHistory |
| SQL-006 | Inline create used by clsClaimRequestDecision | Inline | CL_CLAIM_REQUEST_DECISION | clsClaimRequestDecision |
| SQL-007 | Inline create used by clsClaimStatusActivity | Inline | CL_CLAIM_STATUS_ACTIVITY | clsClaimStatusActivity |
| SQL-008 | StoredProc create used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-009 | Inline create used by clsClaimSupportOrderConn | Inline | CL_CLAIM_SUPPORT_ORDER_CONN | clsClaimSupportOrderConn |
| SQL-010 | Inline create used by clsClaimTypeActivity | Inline | CL_CLAIM_TYPE_ACTIVITY | clsClaimTypeActivity |
| SQL-011 | Inline create used by clsConditionDecision | Inline | CL_COND_COMPENSABILITY_DECISN, CL_COND_COMPENSABILITY_DECISN | clsConditionDecision |
| SQL-012 | Inline create used by clsCovid19TestingHistory | Inline | CL_COVID19_TESTING_HISTORY | clsCovid19TestingHistory |
| SQL-013 | Inline create used by clsDisabilityAuthActivity | Inline | CL_DISABILITY_AUTH_ACTIVITY | clsDisabilityAuthActivity |
| SQL-014 | Inline create used by clsMedicalCondition | Inline | CL_MEDICAL_CONDITION | clsMedicalCondition |
| SQL-015 | Inline create used by clsOmittedCondition | Inline | CL_OMITTED_COND_DENIED | clsOmittedCondition |
| SQL-016 | Inline create used by clsTDThreeDayWait | Inline | CL_CLAIM_TD_THREE_DAY_WAIT | clsTDThreeDayWait |
| SQL-017 | Inline create used by clsVocationalDetail | Inline | VOCATIONAL_DETAIL | clsVocationalDetail |
| SQL-018 | Inline create used by clsWorkRelease | Inline | CL_CLAIM_WORK_RELEASE_STATUS | clsWorkRelease |
| SQL-019 | Inline create used by clsWorkStatus | Inline | CL_CLAIM_WORK_STATUS | clsWorkStatus |
| SQL-020 | Inline create used by clsWorkerPharmacyEligibilityReport | Inline | CL_PHARMACY_ELIGIBILITY_REPORT | clsWorkerPharmacyEligibilityReport |
Read operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-021 | Inline read used by clsAccidentInjury | Inline | CL_INJURY_CLAIM | clsAccidentInjury |
| SQL-022 | Inline read used by clsAccidentInjury | Inline | ZIP_MCO_COUNTY | clsAccidentInjury |
| SQL-023 | Inline read used by clsAccidentInjury | Inline | CL_DISABILITY_AUTH_ACTIVITY | clsAccidentInjury |
| SQL-024 | Inline read used by clsAccidentInjury | Inline | CL_MEDICAL_CONDITION | clsAccidentInjury |
| SQL-025 | Inline read used by clsAccidentInjury | Inline | CL_CLAIM_REQUEST_DECISION | clsAccidentInjury |
| SQL-026 | Inline read used by clsAccidentInjury | Inline | CL_INJURY_CLAIM | clsAccidentInjury |
| SQL-027 | Inline read used by clsAccidentInjury | Inline | CL_CLAIM_WORK_RELEASE_STATUS | clsAccidentInjury |
| SQL-028 | Inline read used by clsAttendingPhysician | Inline | ATTENDING_PHYS_EXP_REASON_CODE | clsAttendingPhysician |
| SQL-029 | Inline read used by clsClaimAdjustment | Inline | CL_INJURY_CLAIM | clsClaimAdjustment |
| SQL-030 | Inline read used by clsClaimAdjustment | Inline | CL_CLAIM_PERSON | clsClaimAdjustment |
| SQL-031 | Inline read used by clsClaimAdjustment | Inline | CL_CLAIM_PERSON | clsClaimAdjustment |
| SQL-032 | Inline read used by clsClaimDetail | Inline | CL_MEDICAL_CONDITION | clsClaimDetail |
| SQL-033 | Inline read used by clsClaimDetail | Inline | CL_BENEFIT_PERIOD | clsClaimDetail |
| SQL-034 | Inline read used by clsClaimDetail | Inline | CL_MEDICAL_CONDITION | clsClaimDetail |
| SQL-035 | Inline read used by clsClaimDetail | Inline | CL_CLAIM_LEGAL_REPRESENTATIVE | clsClaimDetail |
| SQL-036 | Inline read used by clsClaimDetail | Inline | MCO_GSA_LOCATION | clsClaimDetail |
| SQL-037 | Inline read used by clsClaimDetail | Inline | CL_MERGED_CLAIM | clsClaimDetail |
| SQL-038 | Inline read used by clsClaimDetail | Inline | CL_INJURY_CLAIM | clsClaimDetail |
| SQL-039 | Inline read used by clsClaimDetail | Inline | CL_CLAIM_PERSON | clsClaimDetail |
| SQL-040 | Inline read used by clsClaimDetail | Inline | CL_INJURY_CLAIM | clsClaimDetail |
| SQL-041 | Inline read used by clsClaimDetail | Inline | CL_INJURY_CLAIM | clsClaimDetail |
| SQL-042 | Inline read used by clsClaimDisabilityActivityCollection | Inline | CL_INJURY_CLAIM | clsClaimDisabilityActivityCollection |
| SQL-043 | Inline read used by clsClaimDisabilityActivityCollection | Inline | CL_CLAIM_DISABILITY_ACTIVITY | clsClaimDisabilityActivityCollection |
| SQL-044 | Inline read used by clsClaimMcoEligibilityCollection | Inline | CL_CLAIM_MCO_ELIGIBILITY | clsClaimMcoEligibilityCollection |
| SQL-045 | Inline read used by clsClaimPolicy | Inline | CL_INJURY_CLAIM | clsClaimPolicy |
| SQL-046 | Inline read used by clsClaimPolicyHistoryCollection | Inline | CL_CLAIM_POLICY_HISTORY | clsClaimPolicyHistoryCollection |
| SQL-047 | Inline read used by clsClaimRequestDecisionCollection | Inline | CL_CLAIM_REQUEST_DECISION | clsClaimRequestDecisionCollection |
| SQL-048 | Inline read used by clsClaimStatusActivityCollection | Inline | CL_CLAIM_STATUS_ACTIVITY | clsClaimStatusActivityCollection |
| SQL-049 | StoredProc read used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-050 | StoredProc read used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-051 | StoredProc read used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-052 | StoredProc read used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-053 | StoredProc read used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-054 | Inline read used by clsClaimSupportOrder | Inline | CL_INJURY_CLAIM | clsClaimSupportOrder |
| SQL-055 | StoredProc read used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-056 | StoredProc read used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-057 | StoredProc read used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-058 | StoredProc read used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-059 | StoredProc read used by clsClaimSupportOrderCollection | StoredProc | N/A | clsClaimSupportOrderCollection |
| SQL-060 | StoredProc read used by clsClaimSupportOrderConnCollection | StoredProc | N/A | clsClaimSupportOrderConnCollection |
| SQL-061 | Inline read used by clsClaimTypeActivityCollection | Inline | CL_CLAIM_TYPE_ACTIVITY | clsClaimTypeActivityCollection |
| SQL-062 | Inline read used by clsConditionDecisionCollection | Inline | CL_COND_COMPENSABILITY_DECISN | clsConditionDecisionCollection |
| SQL-063 | Inline read used by clsCovid19TestingHistoryCollection | Inline | CL_COVID19_TESTING_HISTORY | clsCovid19TestingHistoryCollection |
| SQL-064 | Inline read used by clsDisabilityAuthActivityCollection | Inline | CL_INJURY_CLAIM | clsDisabilityAuthActivityCollection |
| SQL-065 | Inline read used by clsDisabilityAuthActivityCollection | Inline | CL_DISABILITY_AUTH_ACTIVITY | clsDisabilityAuthActivityCollection |
| SQL-066 | Inline read used by clsMedicalCondition | Inline | CL_MEDICAL_CONDITION | clsMedicalCondition |
| SQL-067 | Inline read used by clsMedicalCondition | Inline | CBP_DIAGNOSIS | clsMedicalCondition |
| SQL-068 | Inline read used by clsMedicalCondition | Inline | CBP_DIAGNOSIS | clsMedicalCondition |
| SQL-069 | Inline read used by clsMedicalConditionCollection | Inline | CL_MEDICAL_CONDITION | clsMedicalConditionCollection |
| SQL-070 | Inline read used by clsOmittedCondition | Inline | CL_OMITTED_COND_DENIED | clsOmittedCondition |
| SQL-071 | Inline read used by clsOmittedConditionCollection | Inline | CL_OMITTED_COND_DENIED | clsOmittedConditionCollection |
| SQL-072 | Inline read used by clsTDThreeDayWaitCollection | Inline | CL_CLAIM_TD_THREE_DAY_WAIT | clsTDThreeDayWaitCollection |
| SQL-073 | StoredProc read used by clsVocationalDetailCollection | StoredProc | N/A | clsVocationalDetailCollection |
| SQL-074 | Inline read used by clsWorkReleaseCollection | Inline | CL_CLAIM_WORK_RELEASE_STATUS | clsWorkReleaseCollection |
| SQL-075 | Inline read used by clsWorkStatusCollection | Inline | CL_CLAIM_WORK_STATUS | clsWorkStatusCollection |
| SQL-076 | Inline read used by clsWorkStatusInjuryClaim | Inline | CL_INJURY_CLAIM | clsWorkStatusInjuryClaim |
| SQL-077 | Inline read used by clsWorkerClaimBenefitPayment | Inline | CL_BENEFIT_PAYMENT | clsWorkerClaimBenefitPayment |
| SQL-078 | Inline read used by clsWorkerClaimBenefitSchedule | Inline | CL_BENEFIT_SCHEDULE | clsWorkerClaimBenefitSchedule |
| SQL-079 | Inline read used by clsWorkerInjuryClaim | Inline | CL_INJURY_CLAIM | clsWorkerInjuryClaim |
| SQL-080 | Inline read used by clsWorkerPharmacyEligibilityReport | Inline | CL_PHARMACY_ELIGIBILITY_REPORT | clsWorkerPharmacyEligibilityReport |
Update operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-081 | Inline update used by clsAccidentInjury | Inline | CL_INJURY_CLAIM | clsAccidentInjury |
| SQL-082 | StoredProc update used by clsClaimAdjustment | StoredProc | — | clsClaimAdjustment |
| SQL-083 | StoredProc update used by clsClaimAdjustment | StoredProc | — | clsClaimAdjustment |
| SQL-084 | StoredProc update used by clsClaimAdjustment | StoredProc | — | clsClaimAdjustment |
| SQL-085 | StoredProc update used by clsClaimAdjustment | StoredProc | — | clsClaimAdjustment |
| SQL-086 | Inline update used by clsClaimDetail | Inline | CL_CLAIM_LEGAL_REPRESENTATIVE | clsClaimDetail |
| SQL-087 | Inline update used by clsClaimDetail | Inline | CL_INJURY_CLAIM | clsClaimDetail |
| SQL-088 | Inline update used by clsClaimDisabilityActivity | Inline | CL_CLAIM_DISABILITY_ACTIVITY | clsClaimDisabilityActivity |
| SQL-089 | Inline update used by clsClaimPolicy | Inline | CL_INJURY_CLAIM | clsClaimPolicy |
| SQL-090 | Inline update used by clsClaimRequestDecision | Inline | CL_CLAIM_REQUEST_DECISION | clsClaimRequestDecision |
| SQL-091 | Inline update used by clsClaimStatusActivity | Inline | CL_CLAIM_STATUS_ACTIVITY | clsClaimStatusActivity |
| SQL-092 | StoredProc update used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-093 | Inline update used by clsClaimTypeActivity | Inline | CL_CLAIM_TYPE_ACTIVITY | clsClaimTypeActivity |
| SQL-094 | Inline update used by clsConditionDecision | Inline | CL_COND_COMPENSABILITY_DECISN | clsConditionDecision |
| SQL-095 | Inline update used by clsDisabilityAuthActivity | Inline | CL_DISABILITY_AUTH_ACTIVITY | clsDisabilityAuthActivity |
| SQL-096 | Inline update used by clsMedicalCondition | Inline | CL_MEDICAL_CONDITION | clsMedicalCondition |
| SQL-097 | Inline update used by clsOmittedCondition | Inline | CL_OMITTED_COND_DENIED | clsOmittedCondition |
| SQL-098 | Inline update used by clsTDThreeDayWait | Inline | CL_CLAIM_TD_THREE_DAY_WAIT | clsTDThreeDayWait |
| SQL-099 | Inline update used by clsVocationalDetail | Inline | VOCATIONAL_DETAIL | clsVocationalDetail |
| SQL-100 | Inline update used by clsWorkRelease | Inline | CL_CLAIM_WORK_RELEASE_STATUS | clsWorkRelease |
| SQL-101 | Inline update used by clsWorkStatus | Inline | CL_CLAIM_WORK_STATUS | clsWorkStatus |
| SQL-102 | Inline update used by clsWorkStatusInjuryClaim | Inline | CL_INJURY_CLAIM | clsWorkStatusInjuryClaim |
| SQL-103 | Inline update used by clsWorkerClaimBenefitSchedule | Inline | CL_BENEFIT_SCHEDULE | clsWorkerClaimBenefitSchedule |
| SQL-104 | Inline update used by clsWorkerInjuryClaim | Inline | CL_INJURY_CLAIM | clsWorkerInjuryClaim |
| SQL-105 | Inline update used by clsWorkerPharmacyEligibilityReport | Inline | CL_PHARMACY_ELIGIBILITY_REPORT | clsWorkerPharmacyEligibilityReport |
Delete operations¶
| SQL ID | Description | Type | Tables | Business object |
|---|---|---|---|---|
| SQL-106 | Inline delete used by clsAccidentInjury | Inline | CL_CLAIM_TD_THREE_DAY_WAIT | clsAccidentInjury |
| SQL-107 | Inline delete used by clsClaimDisabilityActivity | Inline | — | clsClaimDisabilityActivity |
| SQL-108 | Inline delete used by clsClaimRequestDecision | Inline | — | clsClaimRequestDecision |
| SQL-109 | Inline delete used by clsClaimStatusActivity | Inline | — | clsClaimStatusActivity |
| SQL-110 | StoredProc delete used by clsClaimSupportOrder | StoredProc | N/A | clsClaimSupportOrder |
| SQL-111 | Inline delete used by clsClaimSupportOrderConn | Inline | — | clsClaimSupportOrderConn |
| SQL-112 | Inline delete used by clsClaimTypeActivity | Inline | — | clsClaimTypeActivity |
| SQL-113 | Inline delete used by clsConditionDecision | Inline | CL_COND_COMPENSABILITY_DECISN | clsConditionDecision |
| SQL-114 | Inline delete used by clsDisabilityAuthActivity | Inline | — | clsDisabilityAuthActivity |
| SQL-115 | Inline delete used by clsMedicalCondition | Inline | CL_MEDICAL_CONDITION | clsMedicalCondition |
| SQL-116 | Inline delete used by clsOmittedCondition | Inline | CL_OMITTED_COND_DENIED | clsOmittedCondition |
| SQL-117 | Inline delete used by clsTDThreeDayWait | Inline | — | clsTDThreeDayWait |
| SQL-118 | Inline delete used by clsVocationalDetail | Inline | — | clsVocationalDetail |
| SQL-119 | Inline delete used by clsWorkRelease | Inline | — | clsWorkRelease |
| SQL-120 | Inline delete used by clsWorkStatus | Inline | — | clsWorkStatus |
| SQL-121 | Inline delete used by clsWorkerClaimBenefitPayment | Inline | — | clsWorkerClaimBenefitPayment |
| SQL-122 | Inline delete used by clsWorkerClaimBenefitSchedule | Inline | — | clsWorkerClaimBenefitSchedule |
Sequence operations¶
| SQL ID | Description | Sequence | Tables | Business object |
|---|---|---|---|---|
| SQL-001 | SELECT SUPPORT_ORDER_ID_SEQ.NEXTVAL FROM DUAL sequence used by clsClaimSupportOrder |
SELECT SUPPORT_ORDER_ID_SEQ.NEXTVAL FROM DUAL |
DUAL | clsClaimSupportOrder |
| SQL-002 | PK82141_SUPPORT_ORDER.DetermineTodoTasks | PK82141_SUPPORT_ORDER.DetermineTodoTasks |
N/A | clsClaimSupportOrder |
Related documentation¶
- Index
- Overview
- Architecture
- Dependencies
- Operations and processes
- Business rules
- Database tables
- Procedures
- API reference
Sources¶
Business\SAIF.Business.Claim.Maintenance\clsAccidentInjury.vbBusiness\SAIF.Business.Claim.Maintenance\clsAttendingPhysician.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimAdjustment.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimDetail.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimDisabilityActivity.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimDisabilityActivityCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimMcoEligibility.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimMcoEligibilityCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimPolicy.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimPolicyHistory.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimPolicyHistoryCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimRequestDecision.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimRequestDecisionCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimStatusActivity.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimStatusActivityCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimSupportOrder.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimSupportOrderCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimSupportOrderConn.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimSupportOrderConnCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimTypeActivity.vbBusiness\SAIF.Business.Claim.Maintenance\clsClaimTypeActivityCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsConditionDecision.vbBusiness\SAIF.Business.Claim.Maintenance\clsConditionDecisionCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsCovid19TestingHistory.vbBusiness\SAIF.Business.Claim.Maintenance\clsCovid19TestingHistoryCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsDisabilityAuthActivity.vbBusiness\SAIF.Business.Claim.Maintenance\clsDisabilityAuthActivityCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsMedicalCondition.vbBusiness\SAIF.Business.Claim.Maintenance\clsMedicalConditionCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsOmittedCondition.vbBusiness\SAIF.Business.Claim.Maintenance\clsOmittedConditionCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsTDThreeDayWait.vbBusiness\SAIF.Business.Claim.Maintenance\clsTDThreeDayWaitCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsVocationalDetail.vbBusiness\SAIF.Business.Claim.Maintenance\clsVocationalDetailCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsWorkRelease.vbBusiness\SAIF.Business.Claim.Maintenance\clsWorkReleaseCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsWorkStatus.vbBusiness\SAIF.Business.Claim.Maintenance\clsWorkStatusCollection.vbBusiness\SAIF.Business.Claim.Maintenance\clsWorkStatusInjuryClaim.vbBusiness\SAIF.Business.Claim.Maintenance\clsWorkerClaimBenefitPayment.vbBusiness\SAIF.Business.Claim.Maintenance\clsWorkerClaimBenefitSchedule.vbBusiness\SAIF.Business.Claim.Maintenance\clsWorkerInjuryClaim.vbBusiness\SAIF.Business.Claim.Maintenance\clsWorkerPharmacyEligibilityReport.vb