SAIF.Business.Claim.Person SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.

Create operations

SQL ID	Description	Type	Tables	Business object
SQL-001	Inline create used by clsAwardEligibility	Inline	CL_AWARD_ELIGIBILITY	clsAwardEligibility
SQL-002	Inline create used by clsClaimPersonName	Inline	CL_CLAIM_PERSON_NAME_HISTORY	clsClaimPersonName
SQL-003	Inline create used by clsPersonTaxIDHistory	Inline	CL_PERSON_TAX_ID_HISTORY	clsPersonTaxIDHistory
SQL-004	Inline create used by clsWorkerHealthIssue	Inline	CL_WORKER_HEALTH_ISSUE	clsWorkerHealthIssue

Read operations

SQL ID	Description	Type	Tables	Business object
SQL-005	Inline read used by clsAwardEligibilityCollection	Inline	CL_AWARD_ELIGIBILITY	clsAwardEligibilityCollection
SQL-006	Inline read used by clsClaimPersonAddress	Inline	DUAL	clsClaimPersonAddress
SQL-007	Inline read used by clsClaimPersonAddress	Inline	DUAL	clsClaimPersonAddress
SQL-008	Inline read used by clsClaimPersonName	Inline	DUAL	clsClaimPersonName
SQL-009	Inline read used by clsClaimPersonNameCollection	Inline	CL_CLAIM_PERSON_NAME_HISTORY	clsClaimPersonNameCollection
SQL-010	Inline read used by clsPersonTaxIDHistory	Inline	CL_PERSON_TAX_ID_HISTORY	clsPersonTaxIDHistory
SQL-011	Inline read used by clsPersonTaxIDHistory	Inline	CL_PERSON_TAX_ID_HISTORY	clsPersonTaxIDHistory
SQL-012	Inline read used by clsPersonTaxIDHistory	Inline	CL_PERSON_TAX_ID_HISTORY	clsPersonTaxIDHistory
SQL-013	Inline read used by clsPersonTaxIDHistoryCollection	Inline	CL_PERSON_TAX_ID_HISTORY	clsPersonTaxIDHistoryCollection
SQL-014	Inline read used by clsWorkerHealthIssueCollection	Inline	CL_WORKER_HEALTH_ISSUE	clsWorkerHealthIssueCollection

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-015	Inline update used by clsAwardEligibility	Inline	CL_AWARD_ELIGIBILITY	clsAwardEligibility
SQL-016	Inline update used by clsClaimPersonName	Inline	CL_CLAIM_PERSON	clsClaimPersonName
SQL-017	Inline update used by clsClaimPersonName	Inline	CL_CLAIM_PERSON_NAME_HISTORY	clsClaimPersonName
SQL-018	Inline update used by clsPersonTaxIDHistory	Inline	CL_CLAIM_PERSON	clsPersonTaxIDHistory
SQL-019	Inline update used by clsPersonTaxIDHistory	Inline	CL_PERSON_TAX_ID_HISTORY	clsPersonTaxIDHistory

Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-020	Inline delete used by clsAwardEligibility	Inline	CL_AWARD_ELIGIBILITY	clsAwardEligibility
SQL-021	Inline delete used by clsClaimPersonName	Inline	—	clsClaimPersonName
SQL-022	Inline delete used by clsPersonTaxIDHistory	Inline	—	clsPersonTaxIDHistory
SQL-023	Inline delete used by clsWorkerHealthIssue	Inline	—	clsWorkerHealthIssue

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• Procedures
• API reference

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