SAIF.Business.Claim.Entry database tables

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

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
CL_801_DOCUMENT	Oracle	[unqualified]**	CU	Used by cls801Document for persisted claim workflows.	cls801Document
CL_801_SUBMISSION	Oracle	[unqualified]**	CDU	Used by cls801Submission for persisted claim workflows.	cls801Submission
CL_801_SUBMISSION_DATA	Oracle	[unqualified]**	CDRU	Used by cls801SubmissionData for persisted claim workflows.	cls801SubmissionData
CL_CLAIM_MCO_ELIGIBILITY	Oracle	[unqualified]**	C	Used by CriteriaBase for persisted claim workflows.	CriteriaBase
CL_CLAIM_POLICY_HISTORY	Oracle	[unqualified]**	C	Used by CriteriaBase for persisted claim workflows.	CriteriaBase
CL_CLAIM_REQUEST_DECISION	Oracle	[unqualified]**	C	Used by CriteriaBase for persisted claim workflows.	CriteriaBase
CL_CLAIM_STATUS_ACTIVITY	Oracle	[unqualified]**	C	Used by CriteriaBase for persisted claim workflows.	CriteriaBase
CL_CLAIM_TYPE_ACTIVITY	Oracle	[unqualified]**	C	Used by CriteriaBase for persisted claim workflows.	CriteriaBase
CL_INJURY_CLAIM	Oracle	[unqualified]**	CRU	Used by CriteriaBase for persisted claim workflows.	CriteriaBase
CL_MULT_EMPLOYER_LETTER_REQ	Oracle	[unqualified]**	C	Used by clsStateClaimEntry for persisted claim workflows.	clsStateClaimEntry
CL_PHARMACY_ELIGIBILITY_REPORT	Oracle	[unqualified]**	CU	Used by clsPharmacyEligibilityReport for persisted claim workflows.	clsPharmacyEligibilityReport
DUAL	Oracle	[unqualified]**	S	Used by CriteriaBase, cls801Document, cls801Submission for persisted claim workflows.	CriteriaBase, cls801Document, cls801Submission
ZIP_MCO_COUNTY	Oracle	[unqualified]**	R	Used by clsStateClaimEntry for persisted claim workflows.	clsStateClaimEntry

CL_801_DOCUMENT

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by cls801Document within the SAIF.Business.Claim.Entry workflow.
Access pattern	Stored procedure
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	cls801Document

Operations referencing this table

• cls801Document BeforeInsert
• cls801Document BeforeUpdate

SQL referencing this table

• SQL-011: PK82538_ONLINE_801_CLAIM.Document_insert
• SQL-023: PK82538_ONLINE_801_CLAIM.Document_update

---

CL_801_SUBMISSION

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

Operations referencing this table

• cls801Submission BeforeInsert
• cls801Submission BeforeUpdate
• cls801Submission BeforeDelete

SQL referencing this table

• SQL-012: PK82538_ONLINE_801_CLAIM.submission_insert
• SQL-024: PK82538_ONLINE_801_CLAIM.submission_update
• SQL-028: PK82538_ONLINE_801_CLAIM.submission_delete

---

CL_801_SUBMISSION_DATA

Field	Value
Database	Oracle
Schema/Link	[unqualified]**
Purpose	Used by cls801SubmissionData within the SAIF.Business.Claim.Entry workflow.
Access pattern	Stored procedure
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	cls801SubmissionData

Operations referencing this table

• cls801SubmissionData BeforeInsert
• cls801SubmissionData BeforeRetrieve
• cls801SubmissionData BeforeUpdate
• cls801SubmissionData BeforeDelete

SQL referencing this table

• SQL-013: pk82538_online_801_claim.submission_data_insert
• SQL-018: pk82538_online_801_claim.submission_data_select
• SQL-025: pk82538_online_801_claim.submission_data_update
• SQL-029: pk82538_online_801_claim.submission_data_delete

---

CL_CLAIM_MCO_ELIGIBILITY

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

Operations referencing this table

• CriteriaBase AddNewStatusData

SQL referencing this table

• SQL-006: INSERT INTO CL_CLAIM_MCO_ELIGIBILITY (CLAIM_ID, MCO_ID, UPDATE_DATE, UPDATE_USER…

---

CL_CLAIM_POLICY_HISTORY

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

Operations referencing this table

• CriteriaBase AddNewStatusData

SQL referencing this table

• SQL-005: INSERT INTO CL_CLAIM_POLICY_HISTORY (CLAIM_ID, POLICY_NUM, POLICY_SUB_CODE, UPDA…

---

CL_CLAIM_REQUEST_DECISION

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

Operations referencing this table

• CriteriaBase AddNewStatusData

SQL referencing this table

• SQL-007: INSERT INTO CL_CLAIM_REQUEST_DECISION (CLAIM_ID, PRIMARY_KEY_SEQ_NUM, REQUEST_DA…

---

CL_CLAIM_STATUS_ACTIVITY

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

Operations referencing this table

• CriteriaBase AddNewStatusData

SQL referencing this table

• SQL-008: INSERT INTO CL_CLAIM_STATUS_ACTIVITY (CLAIM_ID, CLAIM_STATUS_CODE, CLAIM_STATUS_…

---

CL_CLAIM_TYPE_ACTIVITY

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

Operations referencing this table

• CriteriaBase AddNewStatusData

SQL referencing this table

• SQL-009: INSERT INTO CL_CLAIM_TYPE_ACTIVITY (CLAIM_ID, CLAIM_TYPE_CODE, CLAIM_TYPE_ACTIVI…

---

CL_INJURY_CLAIM

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

Operations referencing this table

• CriteriaBase BeforeInsert
• CriteriaBase CheckForMultipleClaimsForWorker
• CriteriaBase BeforeRetrieve
• CriteriaBase BeforeUpdate

SQL referencing this table

• SQL-010: Insert into CL_INJURY_CLAIM ( ACTIVE_CLAIM_FLAG, AGE_DOI_YEARS, AWARD_AUTO_RECAL…
• SQL-016: SELECT SAIF_CLAIM_NUM FROM CL_INJURY_CLAIM clm WHERE clm.WORKER_ID = :WorkerID A…
• SQL-017: Select AGE_DOI_YEARS as AgeDoiYears, CITY_NAME as CityName, CLAIM_ID as ClaimID,…
• SQL-022: Update CL_INJURY_CLAIM Set ACTIVE_CLAIM_FLAG = :ActiveClaimFlag, AGE_DOI_YEARS =…

---

CL_MULT_EMPLOYER_LETTER_REQ

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

Operations referencing this table

• clsStateClaimEntry AddNewStatusData

SQL referencing this table

• SQL-015: INSERT INTO CL_MULT_EMPLOYER_LETTER_REQ ( SAIF_CLAIM_NUM, UPDATE_NUM, UPDATE_DAT…

---

CL_PHARMACY_ELIGIBILITY_REPORT

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

Operations referencing this table

• clsPharmacyEligibilityReport BeforeInsert
• clsPharmacyEligibilityReport BeforeUpdate

SQL referencing this table

• SQL-014: INSERT INTO CL_PHARMACY_ELIGIBILITY_REPORT (CLAIM_ID, ELIGIBILITY_STATUS_CODE, E…
• SQL-026: Update CL_PHARMACY_ELIGIBILITY_REPORT Set ELIGIBILITY_STATUS_CODE = :Eligibility…

---

DUAL

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

Operations referencing this table

• CriteriaBase identity/sequence generation
• cls801Document identity/sequence generation
• cls801Submission identity/sequence generation

SQL referencing this table

• SQL-001: SELECT CLAIM_ID_SEQ.NEXTVAL FROM DUAL
• SQL-002: SELECT SAIF_CLAIM_NUM_SEQ.NEXTVAL FROM DUAL
• SQL-003: select cl_801_Document_seq.nextval from dual
• SQL-004: select cl_801_submission_seq.nextval from dual

---

ZIP_MCO_COUNTY

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

Operations referencing this table

• clsStateClaimEntry DetermineCountyCode

SQL referencing this table

• SQL-019: 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 ** could not be confirmed; treat them as unknown until verified.

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