The table `itgen_dataset_rows` holds: row within a dataset. Example: Code 123 with description ABC. It keeps history. Its natural key code is `drw`. ## Columns The table has these columns, besides the [[Invantive Studio/Repository/Concepts/Standard Columns|standard columns]]: - `documentation` (`varchar2(4000)`): Documentation. Documentation on the dataset row. - `dst_id` (`number`, required): Dataset Row. Reference to a dataset registered in ITGEN_DATASETS. - `payload_column1` (`varchar2(4000)`): {res:itgen_payload_column_nr?1}. Numbered column to contain payload of the dataset row. - `payload_column10` (`varchar2(4000)`): {res:itgen_payload_column_nr?10}. Numbered column to contain payload of the dataset row. - `payload_column100` (`varchar2(4000)`): {res:itgen_payload_column_nr?100}. Numbered column to contain payload of the dataset row. - `payload_column11` (`varchar2(4000)`): {res:itgen_payload_column_nr?11}. Numbered column to contain payload of the dataset row. - `payload_column12` (`varchar2(4000)`): {res:itgen_payload_column_nr?12}. Numbered column to contain payload of the dataset row. - `payload_column13` (`varchar2(4000)`): {res:itgen_payload_column_nr?13}. Numbered column to contain payload of the dataset row. - `payload_column14` (`varchar2(4000)`): {res:itgen_payload_column_nr?14}. Numbered column to contain payload of the dataset row. - `payload_column15` (`varchar2(4000)`): {res:itgen_payload_column_nr?15}. Numbered column to contain payload of the dataset row. - `payload_column16` (`varchar2(4000)`): {res:itgen_payload_column_nr?16}. Numbered column to contain payload of the dataset row. - `payload_column17` (`varchar2(4000)`): {res:itgen_payload_column_nr?17}. Numbered column to contain payload of the dataset row. - `payload_column18` (`varchar2(4000)`): {res:itgen_payload_column_nr?18}. Numbered column to contain payload of the dataset row. - `payload_column19` (`varchar2(4000)`): {res:itgen_payload_column_nr?19}. Numbered column to contain payload of the dataset row. - `payload_column2` (`varchar2(4000)`): {res:itgen_payload_column_nr?2}. Numbered column to contain payload of the dataset row. - `payload_column20` (`varchar2(4000)`): {res:itgen_payload_column_nr?20}. Numbered column to contain payload of the dataset row. - `payload_column21` (`varchar2(4000)`): {res:itgen_payload_column_nr?21}. Numbered column to contain payload of the dataset row. - `payload_column22` (`varchar2(4000)`): {res:itgen_payload_column_nr?22}. Numbered column to contain payload of the dataset row. - `payload_column23` (`varchar2(4000)`): {res:itgen_payload_column_nr?23}. Numbered column to contain payload of the dataset row. - `payload_column24` (`varchar2(4000)`): {res:itgen_payload_column_nr?24}. Numbered column to contain payload of the dataset row. - `payload_column25` (`varchar2(4000)`): {res:itgen_payload_column_nr?25}. Numbered column to contain payload of the dataset row. - `payload_column26` (`varchar2(4000)`): {res:itgen_payload_column_nr?26}. Numbered column to contain payload of the dataset row. - `payload_column27` (`varchar2(4000)`): {res:itgen_payload_column_nr?27}. Numbered column to contain payload of the dataset row. - `payload_column28` (`varchar2(4000)`): {res:itgen_payload_column_nr?28}. Numbered column to contain payload of the dataset row. - `payload_column29` (`varchar2(4000)`): {res:itgen_payload_column_nr?29}. Numbered column to contain payload of the dataset row. - `payload_column3` (`varchar2(4000)`): {res:itgen_payload_column_nr?3}. Numbered column to contain payload of the dataset row. - `payload_column30` (`varchar2(4000)`): {res:itgen_payload_column_nr?30}. Numbered column to contain payload of the dataset row. - `payload_column31` (`varchar2(4000)`): {res:itgen_payload_column_nr?31}. Numbered column to contain payload of the dataset row. - `payload_column32` (`varchar2(4000)`): {res:itgen_payload_column_nr?32}. Numbered column to contain payload of the dataset row. - `payload_column33` (`varchar2(4000)`): {res:itgen_payload_column_nr?33}. Numbered column to contain payload of the dataset row. - `payload_column34` (`varchar2(4000)`): {res:itgen_payload_column_nr?34}. Numbered column to contain payload of the dataset row. - `payload_column35` (`varchar2(4000)`): {res:itgen_payload_column_nr?35}. Numbered column to contain payload of the dataset row. - `payload_column36` (`varchar2(4000)`): {res:itgen_payload_column_nr?36}. Numbered column to contain payload of the dataset row. - `payload_column37` (`varchar2(4000)`): {res:itgen_payload_column_nr?37}. Numbered column to contain payload of the dataset row. - `payload_column38` (`varchar2(4000)`): {res:itgen_payload_column_nr?38}. Numbered column to contain payload of the dataset row. - `payload_column39` (`varchar2(4000)`): {res:itgen_payload_column_nr?39}. Numbered column to contain payload of the dataset row. - `payload_column4` (`varchar2(4000)`): {res:itgen_payload_column_nr?4}. Numbered column to contain payload of the dataset row. - `payload_column40` (`varchar2(4000)`): {res:itgen_payload_column_nr?40}. Numbered column to contain payload of the dataset row. - `payload_column41` (`varchar2(4000)`): {res:itgen_payload_column_nr?41}. Numbered column to contain payload of the dataset row. - `payload_column42` (`varchar2(4000)`): {res:itgen_payload_column_nr?42}. Numbered column to contain payload of the dataset row. - `payload_column43` (`varchar2(4000)`): {res:itgen_payload_column_nr?43}. Numbered column to contain payload of the dataset row. - `payload_column44` (`varchar2(4000)`): {res:itgen_payload_column_nr?44}. Numbered column to contain payload of the dataset row. - `payload_column45` (`varchar2(4000)`): {res:itgen_payload_column_nr?45}. Numbered column to contain payload of the dataset row. - `payload_column46` (`varchar2(4000)`): {res:itgen_payload_column_nr?46}. Numbered column to contain payload of the dataset row. - `payload_column47` (`varchar2(4000)`): {res:itgen_payload_column_nr?47}. Numbered column to contain payload of the dataset row. - `payload_column48` (`varchar2(4000)`): {res:itgen_payload_column_nr?48}. Numbered column to contain payload of the dataset row. - `payload_column49` (`varchar2(4000)`): {res:itgen_payload_column_nr?49}. Numbered column to contain payload of the dataset row. - `payload_column5` (`varchar2(4000)`): {res:itgen_payload_column_nr?5}. Numbered column to contain payload of the dataset row. - `payload_column50` (`varchar2(4000)`): {res:itgen_payload_column_nr?50}. Numbered column to contain payload of the dataset row. - `payload_column51` (`varchar2(4000)`): {res:itgen_payload_column_nr?51}. Numbered column to contain payload of the dataset row. - `payload_column52` (`varchar2(4000)`): {res:itgen_payload_column_nr?52}. Numbered column to contain payload of the dataset row. - `payload_column53` (`varchar2(4000)`): {res:itgen_payload_column_nr?53}. Numbered column to contain payload of the dataset row. - `payload_column54` (`varchar2(4000)`): {res:itgen_payload_column_nr?54}. Numbered column to contain payload of the dataset row. - `payload_column55` (`varchar2(4000)`): {res:itgen_payload_column_nr?55}. Numbered column to contain payload of the dataset row. - `payload_column56` (`varchar2(4000)`): {res:itgen_payload_column_nr?56}. Numbered column to contain payload of the dataset row. - `payload_column57` (`varchar2(4000)`): {res:itgen_payload_column_nr?57}. Numbered column to contain payload of the dataset row. - `payload_column58` (`varchar2(4000)`): {res:itgen_payload_column_nr?58}. Numbered column to contain payload of the dataset row. - `payload_column59` (`varchar2(4000)`): {res:itgen_payload_column_nr?59}. Numbered column to contain payload of the dataset row. - `payload_column6` (`varchar2(4000)`): {res:itgen_payload_column_nr?6}. Numbered column to contain payload of the dataset row. - `payload_column60` (`varchar2(4000)`): {res:itgen_payload_column_nr?60}. Numbered column to contain payload of the dataset row. - `payload_column61` (`varchar2(4000)`): {res:itgen_payload_column_nr?61}. Numbered column to contain payload of the dataset row. - `payload_column62` (`varchar2(4000)`): {res:itgen_payload_column_nr?62}. Numbered column to contain payload of the dataset row. - `payload_column63` (`varchar2(4000)`): {res:itgen_payload_column_nr?63}. Numbered column to contain payload of the dataset row. - `payload_column64` (`varchar2(4000)`): {res:itgen_payload_column_nr?64}. Numbered column to contain payload of the dataset row. - `payload_column65` (`varchar2(4000)`): {res:itgen_payload_column_nr?65}. Numbered column to contain payload of the dataset row. - `payload_column66` (`varchar2(4000)`): {res:itgen_payload_column_nr?66}. Numbered column to contain payload of the dataset row. - `payload_column67` (`varchar2(4000)`): {res:itgen_payload_column_nr?67}. Numbered column to contain payload of the dataset row. - `payload_column68` (`varchar2(4000)`): {res:itgen_payload_column_nr?68}. Numbered column to contain payload of the dataset row. - `payload_column69` (`varchar2(4000)`): {res:itgen_payload_column_nr?69}. Numbered column to contain payload of the dataset row. - `payload_column7` (`varchar2(4000)`): {res:itgen_payload_column_nr?7}. Numbered column to contain payload of the dataset row. - `payload_column70` (`varchar2(4000)`): {res:itgen_payload_column_nr?70}. Numbered column to contain payload of the dataset row. - `payload_column71` (`varchar2(4000)`): {res:itgen_payload_column_nr?71}. Numbered column to contain payload of the dataset row. - `payload_column72` (`varchar2(4000)`): {res:itgen_payload_column_nr?72}. Numbered column to contain payload of the dataset row. - `payload_column73` (`varchar2(4000)`): {res:itgen_payload_column_nr?73}. Numbered column to contain payload of the dataset row. - `payload_column74` (`varchar2(4000)`): {res:itgen_payload_column_nr?74}. Numbered column to contain payload of the dataset row. - `payload_column75` (`varchar2(4000)`): {res:itgen_payload_column_nr?75}. Numbered column to contain payload of the dataset row. - `payload_column76` (`varchar2(4000)`): {res:itgen_payload_column_nr?76}. Numbered column to contain payload of the dataset row. - `payload_column77` (`varchar2(4000)`): {res:itgen_payload_column_nr?77}. Numbered column to contain payload of the dataset row. - `payload_column78` (`varchar2(4000)`): {res:itgen_payload_column_nr?78}. Numbered column to contain payload of the dataset row. - `payload_column79` (`varchar2(4000)`): {res:itgen_payload_column_nr?79}. Numbered column to contain payload of the dataset row. - `payload_column8` (`varchar2(4000)`): {res:itgen_payload_column_nr?8}. Numbered column to contain payload of the dataset row. - `payload_column80` (`varchar2(4000)`): {res:itgen_payload_column_nr?80}. Numbered column to contain payload of the dataset row. - `payload_column81` (`varchar2(4000)`): {res:itgen_payload_column_nr?81}. Numbered column to contain payload of the dataset row. - `payload_column82` (`varchar2(4000)`): {res:itgen_payload_column_nr?82}. Numbered column to contain payload of the dataset row. - `payload_column83` (`varchar2(4000)`): {res:itgen_payload_column_nr?83}. Numbered column to contain payload of the dataset row. - `payload_column84` (`varchar2(4000)`): {res:itgen_payload_column_nr?84}. Numbered column to contain payload of the dataset row. - `payload_column85` (`varchar2(4000)`): {res:itgen_payload_column_nr?85}. Numbered column to contain payload of the dataset row. - `payload_column86` (`varchar2(4000)`): {res:itgen_payload_column_nr?86}. Numbered column to contain payload of the dataset row. - `payload_column87` (`varchar2(4000)`): {res:itgen_payload_column_nr?87}. Numbered column to contain payload of the dataset row. - `payload_column88` (`varchar2(4000)`): {res:itgen_payload_column_nr?88}. Numbered column to contain payload of the dataset row. - `payload_column89` (`varchar2(4000)`): {res:itgen_payload_column_nr?89}. Numbered column to contain payload of the dataset row. - `payload_column9` (`varchar2(4000)`): {res:itgen_payload_column_nr?9}. Numbered column to contain payload of the dataset row. - `payload_column90` (`varchar2(4000)`): {res:itgen_payload_column_nr?90}. Numbered column to contain payload of the dataset row. - `payload_column91` (`varchar2(4000)`): {res:itgen_payload_column_nr?91}. Numbered column to contain payload of the dataset row. - `payload_column92` (`varchar2(4000)`): {res:itgen_payload_column_nr?92}. Numbered column to contain payload of the dataset row. - `payload_column93` (`varchar2(4000)`): {res:itgen_payload_column_nr?93}. Numbered column to contain payload of the dataset row. - `payload_column94` (`varchar2(4000)`): {res:itgen_payload_column_nr?94}. Numbered column to contain payload of the dataset row. - `payload_column95` (`varchar2(4000)`): {res:itgen_payload_column_nr?95}. Numbered column to contain payload of the dataset row. - `payload_column96` (`varchar2(4000)`): {res:itgen_payload_column_nr?96}. Numbered column to contain payload of the dataset row. - `payload_column97` (`varchar2(4000)`): {res:itgen_payload_column_nr?97}. Numbered column to contain payload of the dataset row. - `payload_column98` (`varchar2(4000)`): {res:itgen_payload_column_nr?98}. Numbered column to contain payload of the dataset row. - `payload_column99` (`varchar2(4000)`): {res:itgen_payload_column_nr?99}. Numbered column to contain payload of the dataset row. - `phase` (`varchar2(30)`, required): Phase. Alphanumeric code to sequentially order the loading actions to ensure referential integrity. - `seq` (`number`, required): Sequence. It's numeric unique sequence number. - `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`). ## Indexes The table has these indexes: - `itgen_drw_dst_fk` on `dst_id`. - `itgen_drw_nk` (unique) on `seq`. - `itgen_drw_pk` (unique) on `id`. - `itgen_drw_uk_orig` (unique) on `orig_system_reference`. See also [[Invantive Studio/Repository/Reference/Tables of the Repository|Tables of the Repository]].