SQL-008: Retrieve agent of record for a policy¶

This application-layer statement is used by clsProducer.GetAgent to bypass the normal BOF criteria path and resolve the producer key stored on a policy row.

Classification¶

Field	Value
SQL ID	SQL-008
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]`
Command type	Text
Business object	`N/A (Application layer)`
Criteria property	`N/A`
Lifecycle method	`N/A`
Application class	`clsProducer`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PolicyNum`	Input	Decimal (`NUMBER`)	N/A	Policy number whose agent-of-record key should be returned.

Tables¶

Table	Access	Columns used
POLICY	SELECT	`POLICY_NUM`, `AGENT_NUM`

Sample SQL¶

SELECT
  agent_num
FROM policy
WHERE policy_num = :PolicyNum

Operations and processes¶

Look up the agent of record for a policy

Business rules¶

BR-017: Agent of record is read from POLICY.AGENT_NUM

Sources¶

Business\SAIF.Business.Policy.Agency\clsProducer.vb