SAIF.Business.Policy.Agency SQL catalog¶

This page indexes the inline SQL statements used by SAIF.Business.Policy.Agency.

Read operations¶

SQL ID	Description	Type	Tables	Business object
SQL-001	Retrieve one agency by sequence number	Inline	AGENCY	`clsAgency`
SQL-002	Retrieve agencies by FEID and contract criteria	Inline	AGENCY, AGENCY_CONTRACT	`clsAgencyCollection`
SQL-003	Retrieve one agency contract by sequence number	Inline	AGENCY_CONTRACT	`clsAgencyContract`
SQL-004	Retrieve agency contracts with optional agency scope	Inline	AGENCY_CONTRACT	`clsAgencyContractCollection`
SQL-005	Retrieve one agency office by agent number	Inline	AGENT	`clsAgencyOffice`
SQL-006	Retrieve agency offices for one agency	Inline	AGENT	`clsAgencyOfficeCollection`
SQL-007	Retrieve one producer by agent number	Inline	AGENT	`clsProducer`
SQL-008	Retrieve a policy's agent of record	Inline	POLICY	`N/A (Application layer)`
SQL-009	Retrieve producers with optional agency scope	Inline	AGENT	`clsProducerCollection`