SQL-029 Retrieve medical reserve service types¶

Retrieves medical reserve service-type codes joined to their description codes for the Medical branch of the service-type collection.

Classification¶

Field	Value
SQL ID	SQL-029
Operation type	Read
Execution method	Inline SQL (StringBuilder, Medical 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_MED_SERV_TYPE_CODE	SELECT (JOIN)	CODE, CODE_DESCR
CL_RESERVE_MED_SERV_DESCR_CODE	SELECT (JOIN)	RESERVE_MED_SERV_TYPE_CODE, CODE, CODE_DESCR

Sample SQL¶

-- Retrieve medical reserve service types (Medical branch)
SELECT C.CODE        AS ServiceTypeCode,
       C.CODE_DESCR  AS ServiceTypeDescription,
       R.CODE        AS ServiceDescriptionCode,
       R.CODE_DESCR  AS ServiceDescription
  FROM CL_RESERVE_MED_SERV_TYPE_CODE C
  LEFT OUTER JOIN CL_RESERVE_MED_SERV_DESCR_CODE r
    ON R.RESERVE_MED_SERV_TYPE_CODE = C.CODE
 ORDER BY ServiceTypeDescription, ServiceDescription

Sources¶

SAIF.Business.Claim/clsServiceTypeCollection.vb