---
title: "SQL-040: Code-map lookup family*"
summary: Code-map lookup family*.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business
reference_type: package
---

# SQL-040: Code-map lookup family*

This document describes `SQL-040`, the code-map lookup family* statement or call used by `SAIF.Business`.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-040 |
| **Operation type** | Read |
| **Execution method** | Inline |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `mdlCodeMaps` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `static cache builders` |

## Parameters

This SQL statement has no explicit parameters in the provided findings.

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [Code/lookup tables](../database-tables.md#code-lookup-tables) | SELECT | See sample SQL and source implementation. |

## Sample SQL

Representative `mdlCodeMaps` queries:
```sql
SELECT code, code_descr FROM email_code ORDER BY code
SELECT code, code_descr FROM address_code ORDER BY code
SELECT code, code_descr FROM phone_code ORDER BY code
SELECT code, code_descr FROM company_code ORDER BY code
SELECT code, code_descr FROM relationship_code ORDER BY code
SELECT code, code_descr FROM ethnic_group_code ORDER BY code
SELECT code, code_descr FROM cl_language_preference_code
SELECT code, code_descr, code_descr_short FROM cl_benefit_type_code
SELECT code, code_descr, federal_data_flag AS federal, dol_authorization_num AS dolauthid FROM cl_jurisdiction_code
SELECT code, code_descr, iso_alpha_3_code FROM country_code
SELECT state AS code, state_name AS code_descr FROM all_states WHERE ncci_state_code BETWEEN '01' AND '54' ORDER BY code
SELECT code, code_descr FROM cl_relationship_to_worker_code ORDER BY code_descr
SELECT code, code_descr FROM claim_person_code
SELECT code, code_descr FROM cl_payment_category_code
SELECT code, code_descr FROM cl_reimb_program_code
SELECT code, code_descr FROM claim_decision_code
SELECT code, code_descr FROM cl_request_type_code
SELECT code, code_descr FROM own_motion_reason_code
SELECT code, code_descr, eaip_purchase_flag, limit_amount FROM eaip_expense_type_code
SELECT code, code_descr, reporting_rollup_name, location_name FROM rtw_load_code
SELECT code, code_descr FROM cl_wage_period_pay_unit_code
SELECT code, code_descr FROM cl_settlement_full_part_code
SELECT code, code_descr FROM cl_financial_trans_type_code
SELECT code, code_descr, code_descr_short, award_flag, first_issue_date, effective_date, cost_category_group_code, medical_indemnity_display_code FROM cl_claim_cost_category_code ORDER BY code
```
Globalized variants join `CL_CLAIM_TYPE_GCODE` or `CL_CLAIM_STATUS_GCODE` on `Code` plus `UPPER(Glob.culture_code) = UPPER(:CultureCode)`.

## Operations and processes
- [Lookup and reference-data hydration](../operations/lookup-and-reference-data-hydration.md)

> **Note:** Statements marked with `*` are inferred from code behavior rather than explicit documentation or comments; statements marked with `**` could not be confirmed and should be treated as unknown until verified.

## Sources
- `Business\SAIF.Business\mdlCodeMaps.vb`