Skip to content

SAIF.Business.Claim.Entry SQL catalog

This page indexes SQL statements and stored-procedure calls used by SAIF.Business.Claim.Entry.

Create operations

SQL ID Description Type Tables Business object
SQL-005 Inline create used by CriteriaBase Inline CL_CLAIM_POLICY_HISTORY CriteriaBase
SQL-006 Inline create used by CriteriaBase Inline CL_CLAIM_MCO_ELIGIBILITY CriteriaBase
SQL-007 Inline create used by CriteriaBase Inline CL_CLAIM_REQUEST_DECISION CriteriaBase
SQL-008 Inline create used by CriteriaBase Inline CL_CLAIM_STATUS_ACTIVITY CriteriaBase
SQL-009 Inline create used by CriteriaBase Inline CL_CLAIM_TYPE_ACTIVITY CriteriaBase
SQL-010 Inline create used by CriteriaBase Inline CL_INJURY_CLAIM CriteriaBase
SQL-011 StoredProc create used by cls801Document StoredProc CL_801_DOCUMENT cls801Document
SQL-012 StoredProc create used by cls801Submission StoredProc CL_801_SUBMISSION cls801Submission
SQL-013 StoredProc create used by cls801SubmissionData StoredProc CL_801_SUBMISSION_DATA cls801SubmissionData
SQL-014 Inline create used by clsPharmacyEligibilityReport Inline CL_PHARMACY_ELIGIBILITY_REPORT clsPharmacyEligibilityReport
SQL-015 Inline create used by clsStateClaimEntry Inline CL_MULT_EMPLOYER_LETTER_REQ clsStateClaimEntry

Read operations

SQL ID Description Type Tables Business object
SQL-016 Inline read used by CriteriaBase Inline CL_INJURY_CLAIM CriteriaBase
SQL-017 Inline read used by CriteriaBase Inline CL_INJURY_CLAIM CriteriaBase
SQL-018 StoredProc read used by cls801SubmissionData StoredProc CL_801_SUBMISSION_DATA cls801SubmissionData
SQL-019 Inline read used by clsStateClaimEntry Inline ZIP_MCO_COUNTY clsStateClaimEntry
SQL-020 StoredProc read used by clsSubmissionResult StoredProc — clsSubmissionResult
SQL-021 StoredProc read used by clsSubmissionResult StoredProc — clsSubmissionResult

Update operations

SQL ID Description Type Tables Business object
SQL-022 Inline update used by CriteriaBase Inline CL_INJURY_CLAIM CriteriaBase
SQL-023 StoredProc update used by cls801Document StoredProc CL_801_DOCUMENT cls801Document
SQL-024 StoredProc update used by cls801Submission StoredProc CL_801_SUBMISSION cls801Submission
SQL-025 StoredProc update used by cls801SubmissionData StoredProc CL_801_SUBMISSION_DATA cls801SubmissionData
SQL-026 Inline update used by clsPharmacyEligibilityReport Inline CL_PHARMACY_ELIGIBILITY_REPORT clsPharmacyEligibilityReport

Delete operations

SQL ID Description Type Tables Business object
SQL-027 Inline delete used by CriteriaBase Inline — CriteriaBase
SQL-028 StoredProc delete used by cls801Submission StoredProc CL_801_SUBMISSION cls801Submission
SQL-029 StoredProc delete used by cls801SubmissionData StoredProc CL_801_SUBMISSION_DATA cls801SubmissionData

Sequence operations

SQL ID Description Sequence Tables Business object
SQL-001 SELECT CLAIM_ID_SEQ.NEXTVAL FROM DUAL sequence used by CriteriaBase SELECT CLAIM_ID_SEQ.NEXTVAL FROM DUAL DUAL CriteriaBase
SQL-002 SELECT SAIF_CLAIM_NUM_SEQ.NEXTVAL FROM DUAL sequence used by CriteriaBase SELECT SAIF_CLAIM_NUM_SEQ.NEXTVAL FROM DUAL DUAL CriteriaBase
SQL-003 select cl_801_Document_seq.nextval from dual sequence used by cls801Document select cl_801_Document_seq.nextval from dual DUAL cls801Document
SQL-004 select cl_801_submission_seq.nextval from dual sequence used by cls801Submission select cl_801_submission_seq.nextval from dual DUAL cls801Submission

Other operations

SQL ID Description Type Tables Business object
SQL-030 Inline other used by cls801Submission Inline — cls801Submission

Sources

  • Business\SAIF.Business.Claim.Entry\Online801\Submission\cls801Document.vb
  • Business\SAIF.Business.Claim.Entry\Online801\Submission\cls801Submission.vb
  • Business\SAIF.Business.Claim.Entry\Online801\Submission\cls801SubmissionData.vb
  • Business\SAIF.Business.Claim.Entry\clsClaimEntry.vb
  • Business\SAIF.Business.Claim.Entry\clsPharmacyEligibility.vb
  • Business\SAIF.Business.Claim.Entry\clsStateClaimEntry.vb