SQL-060: Read PROVIDER, PROVIDER_TAX_ID for mdlCustomerContact

This statement supports mdlCustomerContact by executing a read operation against PROVIDER, PROVIDER_TAX_ID.

Classification

Field	Value
SQL ID	SQL-060
Operation type	Read
Execution method	Inline via SqlHelper.ResultSetQuery
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	mdlCustomerContact
Criteria property	GetCustomerIDForProvider
Lifecycle method	GetCustomerIDForProvider

Parameters

Parameter	Direction	Type	Max length	Description
:ProviderID	Input	Decimal	N/A	Provider sequence number

Tables

Table	Access	Columns used
PROVIDER	SELECT / JOIN	See sample SQL**
PROVIDER_TAX_ID	SELECT / JOIN	See sample SQL**

Sample SQL

select p.provider_seq_num, p.primary_tax_id, t.registered_name, t.exp_date, t.eff_date, t.address_line1, t.address_line2, t.address_line3, t.address_line4, t.city_name, t.state_code, t.country_code, t.foreign_address_flag, t.zip_code, t.zip_code_ext from provider p join provider_tax_id t on t.provider_seq_num = p.provider_seq_num and t.tax_id = p.primary_tax_id where p.provider_seq_num = :ProviderID

Operations and processes

• Agency, agent, and provider customer resolution

Business rules

• BR-008: Generated agency, agent, and provider records can be forced inactive

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

Sources

• Business\SAIF.Business.CustomerContact\mdlCustomerContact.vb