SQL-028: Read COMPANY_PERSON, COMPANY for clsContact

This statement supports clsContact by executing a read operation against COMPANY_PERSON, COMPANY.

Classification

Field	Value
SQL ID	SQL-028
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsContact
Criteria property	GetRelationships
Lifecycle method	GetRelationships

Parameters

Parameter	Direction	Type	Max length	Description
:ContactID	Input	Decimal	N/A	Contact primary key

Tables

Table	Access	Columns used
COMPANY_PERSON	SELECT / JOIN	COMPANY_SEQ_NUM, PERSON_SEQ_NUM, RELATIONSHIP_CODE, TITLE
COMPANY	SELECT / JOIN	COMPANY_NAME, COMPANY_SEQ_NUM

Sample SQL

Select COMPANY_PERSON.COMPANY_SEQ_NUM as CustomerID, COMPANY.COMPANY_NAME as CustomerName, COMPANY_PERSON.RELATIONSHIP_CODE as RelationshipCode, COMPANY_PERSON.TITLE as Title FROM COMPANY_PERSON, COMPANY WHERE COMPANY_PERSON.COMPANY_SEQ_NUM = COMPANY.COMPANY_SEQ_NUM AND COMPANY_PERSON.PERSON_SEQ_NUM = :ContactID

Operations and processes

• Customer-contact relationship CRUD

Business rules

• BR-003: Contacts with customer relationships cannot be deleted

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.CustomerContact\Contact\clsContact.vb