SAIF.Business.Claim.Person database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
CL_AWARD_ELIGIBILITY	Oracle	[unqualified]	CDRU	Supports clsAwardEligibility, clsAwardEligibilityCollection data access in this library.	clsAwardEligibility
CL_CLAIM_PERSON	Oracle	[unqualified]	U	Supports clsClaimPersonName, clsPersonTaxIDHistory data access in this library.	clsClaimPersonName
CL_CLAIM_PERSON_NAME_HISTORY	Oracle	[unqualified]	CRU	Supports clsClaimPersonName, clsClaimPersonNameCollection data access in this library.	clsClaimPersonName
CL_PERSON_TAX_ID_HISTORY	Oracle	[unqualified]	CRU	Supports clsPersonTaxIDHistory, clsPersonTaxIDHistoryCollection data access in this library.	clsPersonTaxIDHistory
CL_WORKER_HEALTH_ISSUE	Oracle	[unqualified]	CR	Supports clsWorkerHealthIssue, clsWorkerHealthIssueCollection data access in this library.	clsWorkerHealthIssue
DUAL	Oracle	[unqualified]	R	Supports clsClaimPersonAddress, clsClaimPersonName data access in this library.	clsClaimPersonAddress

CL_AWARD_ELIGIBILITY

Field	Value
Database	Oracle
Schema/Link	[unqualified]
Purpose	Supports clsAwardEligibility, clsAwardEligibilityCollection data access in this library.
Access pattern	Direct SQL
CRUD operations	CDRU
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	clsAwardEligibility, clsAwardEligibilityCollection

Operations referencing this table

• Maintain award eligibility

SQL referencing this table

• SQL-001: INSERT INTO CL_AWARD_ELIGIBILITY (PERSON_ID, AWARD_ELIG_EFF_DATE, AWAR
• SQL-005: SELECT PERSON_ID as PersonID, AWARD_ELIG_EFF_DATE as AwardEligEffDate,
• SQL-015: UPDATE CL_AWARD_ELIGIBILITY SET AWARD_ELIG_EFF_DATE = TRUNC(:AwardElig
• SQL-020: Delete FROM CL_AWARD_ELIGIBILITY Where PERSON_ID = :PersonID and AWARD

---

CL_CLAIM_PERSON

Field	Value
Database	Oracle
Schema/Link	[unqualified]
Purpose	Supports clsClaimPersonName, clsPersonTaxIDHistory data access in this library.
Access pattern	Direct SQL
CRUD operations	U
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	clsClaimPersonName, clsPersonTaxIDHistory

Operations referencing this table

• Manage person names
• Maintain tax ID history

Business rules referencing this table

• BR-PER-002: Phonetic name generation is required for name maintenance

SQL referencing this table

• SQL-016: Update CL_CLAIM_PERSON Set PRIMARY_LAST_NAME = :PrimaryLastName, PRIMA
• SQL-018: Update CL_CLAIM_PERSON Set PRIMARY_TAX_ID = :TaxID, UPDATE_DATE = SYSD

---

CL_CLAIM_PERSON_NAME_HISTORY

Field	Value
Database	Oracle
Schema/Link	[unqualified]
Purpose	Supports clsClaimPersonName, clsClaimPersonNameCollection data access in this library.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	clsClaimPersonName, clsClaimPersonNameCollection

Operations referencing this table

• Manage person names

Business rules referencing this table

• BR-PER-002: Phonetic name generation is required for name maintenance

SQL referencing this table

• SQL-002: Insert into CL_CLAIM_PERSON_NAME_HISTORY ( FIRST_NAME, FIRST_NAME_UPPE
• SQL-009: Select FIRST_NAME as FirstName, FIRST_NAME_UPPER_CASE as FirstNameUppe
• SQL-017: Update CL_CLAIM_PERSON_NAME_HISTORY Set PRIMARY_FLAG = :PrimaryFlag, U

---

CL_PERSON_TAX_ID_HISTORY

Field	Value
Database	Oracle
Schema/Link	[unqualified]
Purpose	Supports clsPersonTaxIDHistory, clsPersonTaxIDHistoryCollection data access in this library.
Access pattern	Direct SQL
CRUD operations	CRU
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	clsPersonTaxIDHistory, clsPersonTaxIDHistoryCollection

Operations referencing this table

• Maintain tax ID history

SQL referencing this table

• SQL-003: Insert into CL_PERSON_TAX_ID_HISTORY ( PERSON_ID, PRIMARY_FLAG, PRIMAR
• SQL-010: Select Count(*) From CL_PERSON_TAX_ID_HISTORY Where TAX_ID = :TaxID AN
• SQL-011: SELECT COUNT(*) FROM CL_PERSON_TAX_ID_HISTORY h, CL_CLAIM_PERSON p WHE
• SQL-012: Select Count(*) From CL_PERSON_TAX_ID_HISTORY Where TAX_ID = :TaxID AN
• SQL-013: Select PERSON_ID as PersonID, PRIMARY_FLAG as PrimaryFlag, PRIMARY_KEY
• SQL-019: Update CL_PERSON_TAX_ID_HISTORY Set PRIMARY_FLAG = :PrimaryFlag, UPDAT

---

CL_WORKER_HEALTH_ISSUE

Field	Value
Database	Oracle
Schema/Link	[unqualified]
Purpose	Supports clsWorkerHealthIssue, clsWorkerHealthIssueCollection data access in this library.
Access pattern	Direct SQL
CRUD operations	CR
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	clsWorkerHealthIssue, clsWorkerHealthIssueCollection

Operations referencing this table

• Track worker health issues

SQL referencing this table

• SQL-004: Insert into CL_WORKER_HEALTH_ISSUE ( EXPOSURE_CODE, UPDATE_DATE, UPDAT
• SQL-014: Select CL_WORKER_HEALTH_ISSUE.EXPOSURE_CODE as ExposureCode, CL_WORKER

---

DUAL

Field	Value
Database	Oracle
Schema/Link	[unqualified]
Purpose	Supports clsClaimPersonAddress, clsClaimPersonName data access in this library.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See linked SQL documents.*
Sequence	N/A
Related tables	N/A
Business objects	clsClaimPersonAddress, clsClaimPersonName

Operations referencing this table

• Manage person names
• Manage claim-person addresses

Business rules referencing this table

• BR-PER-002: Phonetic name generation is required for name maintenance

SQL referencing this table

• SQL-006: SELECT 1 FROM DUAL
• SQL-007: SELECT 1 FROM DUAL
• SQL-008: Select pk82028_phonetic_name.createPhoneticName(:LastName, :FirstName,

---

Table relationship diagram

The following diagram shows relationships between tables used by this library.

erDiagram
    CL_CLAIM_PERSON ||--o{ CL_CLAIM_PERSON_NAME_HISTORY : "PERSON_ID"
    CL_CLAIM_PERSON ||--o{ CL_PERSON_TAX_ID_HISTORY : "PERSON_ID"
    CL_CLAIM_PERSON ||--o{ CL_AWARD_ELIGIBILITY : "PERSON_ID"

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 or contextual evidence.

Sources

• Business\SAIF.Business.Claim.Person\clsAwardEligibility.vb
• Business\SAIF.Business.Claim.Person\clsAwardEligibilityCollection.vb
• Business\SAIF.Business.Claim.Person\clsClaimPersonAddress.vb
• Business\SAIF.Business.Claim.Person\clsClaimPersonName.vb
• Business\SAIF.Business.Claim.Person\clsClaimPersonNameCollection.vb
• Business\SAIF.Business.Claim.Person\clsPersonTaxIDHistory.vb
• Business\SAIF.Business.Claim.Person\clsPersonTaxIDHistoryCollection.vb
• Business\SAIF.Business.Claim.Person\clsWorkerHealthIssue.vb
• Business\SAIF.Business.Claim.Person\clsWorkerHealthIssueCollection.vb