The table `itgen_code_values` holds: a discrete code value of a code domain. Example: The code value 'M' stands for 'Male' within the code domain 'sexe'. It keeps history. Its natural key code is `cve`. ## Columns The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]: - `cde_id` (`number`, required): {res:itgen_some_table_id?{res:itgen_code}&{res:itgen_id}}. Reference to a code range registered in ITGEN_CODES. - `code` (`varchar2(30)`, required): Code. Unique alphanumeric code. - `description` (`varchar2(240)`, required): Description. Description in natural language for display on reports and screens. - `documentation` (`varchar2(4000)`): Documentation. Documentation on the code value. - `icon_url` (`varchar2(240)`): Icon (URL). URL for the icon of this value. - `sorting_order` (`number`, required): Sort Order. Numeric value that determines the ordering of the records in this table in a drop-down box. - `column1` to `column10` and `column_type`: free text columns to extend the data model with fields only available at one site. ## Referential Constraints The table is related to other tables as follows: - `cde_id` refers to Codes (`id`). ## Indexes The table has these indexes: - `itgen_cve_cde_fk` on `cde_id`. - `itgen_cve_nk` (unique) on `cde_id`, `code`. - `itgen_cve_pk` (unique) on `id`. - `itgen_cve_uk_orig` (unique) on `orig_system_reference`. See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].