SQL-026 Retrieve PPD body-part code table

Retrieves the full PPD body-part reference/code table used to populate the cached mdlPPD lookup.

Classification

Field	Value
SQL ID	SQL-026
Operation type	Read
Execution method	Inline SQL (SqlHelper.ResultSetQuery)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsPPDBodyParts
Criteria property	(none)
Lifecycle method	GetPPDBodyParts

Tables

Table	Access	Columns used
CL_PPD_BODY_PART_CODE	SELECT	* (full code table)

Sample SQL

-- Retrieve PPD body-part code table
select *
  from cl_ppd_body_part_code

Operations and processes

• Code-table caching

Sources

• SAIF.Business.Claim/clsPPDBodyParts.vb