The table `itgen_dataset_mappings` holds: mapping from column positions to column names. Example: Column 1 is mapped to cde_code. It keeps history. Its natural key code is `dmg`. ## Columns The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]: - `code` (`varchar2(30)`, required): Code. Unique alphanumeric code. - `column_name` (`varchar2(30)`, required): Column Name. Name of the target column in the view. - `column_position` (`number`, required): Column Position. Numeric position of the source column in the dataset. - `description` (`varchar2(240)`, required): Description. Description in natural language for display on reports and screens. - `documentation` (`varchar2(4000)`): Documentation. Documentation on the dataset mapping. - `dst_id` (`number`, required): {res:itgen_some_table_id?{res:itgen_dataset}&{res:itgen_id}}. Reference to a dataset registered in ITGEN_DATASETS. - `string2datatype_sql` (`varchar2(250)`): String to Data Type SQL. SQL expression to convert a string in the dataset to the intended datatype. - `viw_id` (`number`, required): View ID. Reference to a view registered in ITGEN_VIEWS. - `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: - `dst_id` refers to Datasets (`id`). - `viw_id` refers to Business Objects (`id`). ## Indexes The table has these indexes: - `itgen_dmg_dst_fk` on `dst_id`. - `itgen_dmg_nk` (unique) on `dst_id`, `code`, `column_position`. - `itgen_dmg_pk` (unique) on `id`. - `itgen_dmg_uk_orig` (unique) on `orig_system_reference`. - `itgen_dmg_viw_fk` on `viw_id`. See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].