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 | SELECT | See sample SQL and source implementation. |
Sample SQL¶
Representative mdlCodeMaps queries:
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
CL_CLAIM_TYPE_GCODE or CL_CLAIM_STATUS_GCODE on Code plus UPPER(Glob.culture_code) = UPPER(:CultureCode).
Operations and processes¶
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