SQL-035 Retrieve vocational service type code table

Retrieves the full vocational reserve service-type reference/code table.

Classification

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

Tables

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

Sample SQL

-- Retrieve vocational service type code table
select *
  from cl_reserve_voc_serv_type_code

Operations and processes

• Code-table caching

Sources

• SAIF.Business.Claim/clsVocationalServicesTypes.vb