SQL-028: Read CLAIM_ACTIVITY_CAT_TYPE_CODE¶
This SQL document describes how Criteria uses an inline Oracle query to support claim-domain read behavior.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-028 |
| Operation type | Read |
| Execution method | Inline |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | Criteria |
| Criteria property | retrievesql |
| Lifecycle method | Criteria read |
Parameters¶
This SQL statement exposes no explicit input parameters in the analyzed source.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| CLAIM_ACTIVITY_CAT_TYPE_CODE | SELECT | See sample SQL for referenced columns. |
Sample SQL¶
SELECT
XREF.CATEGORY_CODE AS CategoryCode,
XREF.TYPE_CODE AS Code,
TYP.CODE_DESCR AS Description
FROM CLAIM_ACTIVITY_CAT_TYPE_CODE XREF, CLAIM_ACTIVITY_TYPE_CODE TYP
WHERE
XREF.TYPE_CODE = TYP.CODE
Operations and processes¶
Sources¶
Business\SAIF.Business.View.Claim\clsClaimActivityTypeCodeCollection.vb