SQL-030 Retrieve vocational reserve service types¶

Retrieves vocational reserve service-cost codes joined to their description codes for the Vocational branch of the service-type collection.

Classification¶

Field	Value
SQL ID	SQL-030
Operation type	Read
Execution method	Inline SQL (StringBuilder, Vocational branch)
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsServiceTypeCollection`
Criteria property	`SetRetrieveSQL(GetRetrieveSQL)`
Lifecycle method	`Criteria constructor → BeforeRetrieve`

Tables¶

Table	Access	Columns used
CL_RESERVE_VOC_SERV_COST_CODE	SELECT (JOIN)	CODE, CODE_DESCR
CL_RESERVE_VOC_SERV_DESCR_CODE	SELECT (JOIN)	RESERVE_VOC_SERV_COST_CODE, CODE, CODE_DESCR

Sample SQL¶

-- Retrieve vocational reserve service types (Vocational branch)
SELECT C.CODE        AS ServiceTypeCode,
       C.CODE_DESCR  AS ServiceTypeDescription,
       R.CODE        AS ServiceDescriptionCode,
       R.CODE_DESCR  AS ServiceDescription
  FROM CL_RESERVE_VOC_SERV_COST_CODE C
  LEFT OUTER JOIN CL_RESERVE_VOC_SERV_DESCR_CODE r
    ON R.RESERVE_VOC_SERV_COST_CODE = C.CODE
 ORDER BY ServiceTypeDescription, ServiceDescription

Sources¶

SAIF.Business.Claim/clsServiceTypeCollection.vb