/*2025.8*/ UPDATE OR INSERT INTO XML_STRUCTURE (ID, NAME, CAPTION, VERS, PARENT_ID, USER_ID, USE_IN_TRAINING, IS_SHOW, OKATO_REG, STRUCT_TYPE, FORMAT_TYPE, MED_DOC_CODE) VALUES (132, 'Эпикриз по законченному случаю амбулаторный CDA (Release 2) уровень 3', '', 'Редакция 5', NULL, 1, 0, 0, NULL, 7, 0, 322) MATCHING (ID); COMMIT WORK; UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648686, 132, 'ClinicalDocument', '', ' ', NULL, 'О', NULL, NULL, NULL, 1, 1648686, 2, 'select * from v_emk_zs zs where zs.id = :hdr_id', 0, NULL, 1, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''V_EMK_ZS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648687, 132, 'xmlns', '', ' ', 1648686, 'О', 2, 50, 0, 2, 1648686, 1, 'urn:hl7-org:v3', 0, NULL, 2, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648688, 132, 'realmCode', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 8, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648689, 132, 'code', '', ' ', 1648688, 'О', 2, 2, 0, 2, 1648686, 1, 'RU', 0, NULL, 9, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648690, 132, 'typeId', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 10, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648691, 132, 'root', '', ' ', 1648690, 'О', 2, 100, 0, 2, 1648686, 1, '2.16.840.1.113883.1.3', 0, NULL, 11, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648692, 132, 'extension', '', ' ', 1648690, 'О', 2, 50, 0, 2, 1648686, 1, 'POCD_MT000040', 0, NULL, 12, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648693, 132, 'recordTarget', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 46, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648694, 132, 'patientRole', '', ' ', 1648693, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 47, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648695, 132, 'patient', '', ' ', 1648694, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 60, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648696, 132, 'name', '', ' ', 1648695, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 61, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648697, 132, 'family', '', ' ', 1648696, 'О', 2, 40, 0, 1, 1648686, 0, 'ZS.PAT_FAM', 0, NULL, 62, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648698, 132, 'given', '', ' ', 1648696, 'О', 2, 40, 0, 1, 1648686, 0, 'ZS.PAT_IM', 0, NULL, 63, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649021, 132, 'code', '', ' ', 1649018, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 256, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649022, 132, 'code', '', ' ', 1649021, 'О', 2, 5, 0, 2, 1648686, 1, '809', 0, NULL, 257, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649023, 132, 'codeSystem', '', ' ', 1649021, 'О', 2, 100, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.99.2.166', 0, NULL, 258, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649024, 132, 'codeSystemName', '', ' ', 1649021, 'О', 2, 100, 0, 2, 1648686, 1, 'Кодируемые поля CDA документов', 0, NULL, 259, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648699, 132, 'xmlns:xsi', '', ' ', 1648686, 'О', 2, 250, 0, 2, 1648686, 1, 'http://www.w3.org/2001/XMLSchema-instance', 0, NULL, 5, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648700, 132, 'xmlns:identity', '', ' ', 1648686, 'О', 2, 100, 0, 2, 1648686, 1, 'urn:hl7-ru:identity', 0, NULL, 6, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648701, 132, 'xmlns:address', '', ' ', 1648686, 'О', 2, 100, 0, 2, 1648686, 1, 'urn:hl7-ru:address', 0, NULL, 7, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1650387, 132, 'extension', '', ' ', 1648759, 'У', 2, 100, 0, 2, 1648686, 0, 'ZS.LPU_1', 0, NULL, 76, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1650388, 132, 'identity:Dept', '', ' ', 1648758, 'У', 2, 500, 0, 1, 1648686, 0, 'ZS.LPU_1_NAME', 0, NULL, 79, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648702, 132, 'xmlns:medService', '', ' ', 1648686, 'О', 2, 100, 0, 2, 1648686, 1, 'urn:hl7-ru:medService', 0, NULL, 4, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648703, 132, 'xmlns:fias', '', ' ', 1648686, 'О', 2, 100, 0, 2, 1648686, 1, 'urn:hl7-ru:fias', 0, NULL, 3, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648706, 132, 'id', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 15, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648707, 132, 'extension', '', ' ', 1648706, 'О', 2, 50, 0, 2, 1648686, 0, 'ZS.PROT_ID', 0, NULL, 17, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649025, 132, 'displayName', '', ' ', 1649021, 'О', 2, 100, 0, 2, 1648686, 1, 'Шифр по МКБ-10', 0, NULL, 260, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649026, 132, 'codeSystemVersion', '', ' ', 1649021, 'О', 2, 10, 0, 2, 1648686, 1, '5.35', 0, NULL, 261, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648708, 132, 'root', '', ' ', 1648706, 'О', 2, 50, 0, 2, 1648686, 0, '(select oid from contragents where type_id = 1) || ''.100.1.1.51''', 0, NULL, 16, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648704, 132, 'templateId', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 13, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648705, 132, 'root', '', ' ', 1648704, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.15.26.5', 0, NULL, 14, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649027, 132, 'value', '', ' ', 1649018, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 262, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649028, 132, 'xsi:type', '', ' ', 1649027, 'О', 2, 2, 0, 2, 1648686, 1, 'CD', 0, NULL, 263, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649029, 132, 'code', '', ' ', 1649027, 'О', 2, 10, 0, 2, 1648686, 0, 'ZS.DS', 0, NULL, 264, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649030, 132, 'codeSystem', '', ' ', 1649027, 'О', 2, 100, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.11.1005', 0, NULL, 265, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648709, 132, 'code', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 18, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648710, 132, 'code', '', ' ', 1648709, 'О', 1, 4, 0, 2, 1648686, 1, '233', 0, NULL, 19, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648711, 132, 'codeSystem', '', ' ', 1648709, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.11.1520', 0, NULL, 20, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648712, 132, 'codeSystemName', '', ' ', 1648709, 'О', 2, 100, 0, 2, 1648686, 1, 'Электронные медицинские документы', 0, NULL, 21, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648713, 132, 'displayName', '', ' ', 1648709, 'О', 2, 200, 0, 2, 1648686, 1, 'Эпикриз по законченному случаю амбулаторный (CDA) Редакция 5', 0, NULL, 22, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648714, 132, 'codeSystemVersion', '', ' ', 1648709, 'О', 2, 20, 0, 2, 1648686, 1, '12.32', 0, NULL, 23, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648715, 132, 'translation', '', ' ', 1648709, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 24, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648716, 132, 'code', '', ' ', 1648715, 'О', 1, 0, 0, 2, 1648686, 1, '26', 0, NULL, 25, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648717, 132, 'codeSystem', '', ' ', 1648715, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.99.2.1079', 0, NULL, 26, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648718, 132, 'codeSystemName', '', ' ', 1648715, 'О', 2, 100, 0, 2, 1648686, 1, 'Виды структурированных электронных медицинских документов', 0, NULL, 27, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648719, 132, 'displayName', '', ' ', 1648715, 'О', 2, 200, 0, 2, 1648686, 1, 'Эпикриз по законченному случаю амбулаторный', 0, NULL, 28, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648720, 132, 'codeSystemVersion', '', ' ', 1648715, 'О', 2, 20, 0, 2, 1648686, 1, '1.21', 0, NULL, 29, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648721, 132, 'title', '', ' ', 1648686, 'О', 2, 250, 0, 1, 1648686, 0, 'zs.prot_header', 0, NULL, 30, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648722, 132, 'effectiveTime', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 31, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648723, 132, 'value', '', ' ', 1648722, 'О', 3, 0, 0, 2, 1648686, 0, 'zs.prot_date', 0, NULL, 32, NULL, 'YYYYMMDD', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648724, 132, 'confidentialityCode', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 33, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648725, 132, 'code', '', ' ', 1648724, 'О', 2, 3, 0, 2, 1648686, 1, 'N', 0, NULL, 34, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648726, 132, 'codeSystem', '', ' ', 1648724, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.99.2.285', 0, NULL, 35, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648727, 132, 'codeSystemName', '', ' ', 1648724, 'О', 2, 200, 0, 2, 1648686, 1, 'Уровень конфиденциальности медицинского документа', 0, NULL, 36, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648728, 132, 'displayName', '', ' ', 1648724, 'О', 2, 100, 0, 2, 1648686, 1, 'Обычный', 0, NULL, 37, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648729, 132, 'codeSystemVersion', '', ' ', 1648724, 'О', 2, 10, 0, 2, 1648686, 1, '1.2', 0, NULL, 38, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648730, 132, 'languageCode', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 39, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648731, 132, 'code', '', ' ', 1648730, 'О', 2, 10, 0, 2, 1648686, 1, 'ru-RU', 0, NULL, 40, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649031, 132, 'codeSystemName', '', ' ', 1649027, 'О', 2, 250, 0, 2, 1648686, 1, 'Международная статистическая классификация болезней и проблем, связанных со здоровьем (10-й пересмотр)', 0, NULL, 266, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648732, 132, 'setId', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 41, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648733, 132, 'root', '', ' ', 1648732, 'О', 2, 100, 0, 2, 1648686, 0, '(select oid from contragents where type_id = 1) || ''.100.1.1.50''', 0, NULL, 42, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649032, 132, 'displayName', '', ' ', 1649027, 'О', 2, 250, 0, 2, 1648686, 0, 'ZS.DS_NAME', 0, NULL, 267, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648734, 132, 'extension', '', ' ', 1648732, 'О', 1, 3, 0, 2, 1648686, 0, 'ZS.NUM', 0, NULL, 43, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648735, 132, 'versionNumber', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 44, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648736, 132, 'value', '', ' ', 1648735, 'О', 1, 1, 0, 2, 1648686, 0, 'VERS', 0, NULL, 45, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648737, 132, 'id', '', ' ', 1648694, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 48, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648738, 132, 'root', '', ' ', 1648737, 'О', 2, 100, 0, 2, 1648686, 0, '(select oid from contragents where type_id = 1) || ''.100.1.1.10''', 0, NULL, 49, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648739, 132, 'extension', '', ' ', 1648737, 'О', 1, 6, 0, 2, 1648686, 0, 'ZS.patient_id', 0, NULL, 50, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648740, 132, 'id', '', ' ', 1648694, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 51, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648741, 132, 'root', '', ' ', 1648740, 'О', 2, 20, 0, 2, 1648686, 1, '1.2.643.100.3', 0, NULL, 52, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648742, 132, 'extension', '', ' ', 1648740, 'О', 2, 20, 0, 2, 1648686, 0, 'replace(replace(zs.pat_ss,'' '',''''),''-'','''')', 0, NULL, 53, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648743, 132, 'identity:IdentityDoc', '', ' ', 1648694, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 54, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648744, 132, 'nullFlavor', '', ' ', 1648743, 'О', 2, 2, 0, 2, 1648686, 1, 'NI', 0, NULL, 55, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648745, 132, 'identity:InsurancePolicy', '', ' ', 1648694, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 56, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648746, 132, 'nullFlavor', '', ' ', 1648745, 'О', 2, 2, 0, 2, 1648686, 1, 'NI', 0, NULL, 57, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648747, 132, 'addr', '', ' ', 1648694, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 58, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648748, 132, 'nullFlavor', '', ' ', 1648747, 'О', 2, 2, 0, 2, 1648686, 1, 'NI', 0, NULL, 59, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649033, 132, 'codeSystemVersion', '', ' ', 1649027, 'О', 2, 10, 0, 2, 1648686, 1, '2.24', 0, NULL, 268, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649034, 132, 'entry', '', ' ', 1649010, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 235, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649035, 132, 'observation', '', ' ', 1649034, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 236, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649036, 132, 'code', '', ' ', 1649035, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 239, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649037, 132, 'code', '', ' ', 1649036, 'О', 2, 5, 0, 2, 1648686, 1, '817', 0, NULL, 240, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649038, 132, 'codeSystem', '', ' ', 1649036, 'О', 2, 100, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.99.2.166', 0, NULL, 241, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649039, 132, 'codeSystemName', '', ' ', 1649036, 'О', 2, 100, 0, 2, 1648686, 1, 'Кодируемые поля CDA документов', 0, NULL, 242, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649040, 132, 'displayName', '', ' ', 1649036, 'О', 2, 200, 0, 2, 1648686, 1, 'Порядок случаев госпитализации или обращения', 0, NULL, 243, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648749, 132, 'identity:Patronymic', '', ' ', 1648696, 'У', 2, 40, 0, 1, 1648686, 0, 'ZS.PAT_OT', 0, NULL, 64, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648750, 132, 'administrativeGenderCode', '', ' ', 1648695, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 65, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648751, 132, 'code', '', ' ', 1648750, 'О', 1, 1, 0, 2, 1648686, 0, 'iif(zs.pat_sex = ''М'',1,2)', 0, NULL, 66, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648752, 132, 'codeSystem', '', ' ', 1648750, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.11.1040', 0, NULL, 67, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648753, 132, 'codeSystemName', '', ' ', 1648750, 'О', 2, 50, 0, 2, 1648686, 1, 'Пол пациента', 0, NULL, 68, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648754, 132, 'displayName', '', ' ', 1648750, 'О', 2, 20, 0, 2, 1648686, 0, 'iif(zs.pat_sex = ''М'',''Мужской'',''Женский'')', 0, NULL, 69, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648755, 132, 'codeSystemVersion', '', ' ', 1648750, 'О', 2, 3, 0, 2, 1648686, 1, '2.1', 0, NULL, 70, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648756, 132, 'birthTime', '', ' ', 1648695, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 71, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648757, 132, 'value', '', ' ', 1648756, 'О', 3, 0, 0, 2, 1648686, 0, 'ZS.PAT_DR', 0, NULL, 72, NULL, 'YYYYMMDD', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648758, 132, 'providerOrganization', '', ' ', 1648694, 'О', NULL, NULL, NULL, 1, 1648686, 3, 'select * from contragents con where type_id = 1', 0, NULL, 73, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''CONTRAGENTS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649041, 132, 'codeSystemVersion', '', ' ', 1649036, 'О', 2, 10, 0, 2, 1648686, 1, '5.35', 0, NULL, 244, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649042, 132, 'value', '', ' ', 1649035, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 245, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649043, 132, 'xsi:type', '', ' ', 1649042, 'О', 2, 2, 0, 2, 1648686, 1, 'CD', 0, NULL, 246, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649044, 132, 'code', '', ' ', 1649042, 'О', 2, 10, 0, 2, 1648686, 1, '1', 0, NULL, 247, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649045, 132, 'codeSystem', '', ' ', 1649042, 'О', 2, 100, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.11.1007', 0, NULL, 248, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649046, 132, 'codeSystemName', '', ' ', 1649042, 'О', 2, 250, 0, 2, 1648686, 1, 'Вид случая госпитализации или обращения (первичный, повторный)', 0, NULL, 249, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648759, 132, 'id', '', ' ', 1648758, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 74, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648760, 132, 'root', '', ' ', 1648759, 'О', 2, 100, 0, 2, 1648686, 0, 'con_oid', 0, NULL, 75, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648762, 132, 'identity:Props', '', ' ', 1648758, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 77, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648763, 132, 'identity:Ogrn', '', ' ', 1648762, 'О', 2, 20, 0, 1, 1648686, 0, 'CON_OGRN', 0, NULL, 78, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648764, 132, 'name', '', ' ', 1648758, 'О', 2, 250, 0, 1, 1648686, 0, 'CON_FULL_NAME', 0, NULL, 80, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648765, 132, 'addr', '', ' ', 1648758, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 81, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648766, 132, 'streetAddressLine', '', ' ', 1648765, 'О', 2, 250, 0, 1, 1648686, 0, 'CON_ADRES', 0, NULL, 82, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648767, 132, 'address:stateCode', '', ' ', 1648765, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 83, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648768, 132, 'code', '', ' ', 1648767, 'О', 2, 2, 0, 2, 1648686, 0, 'substring(CON_INN from 1 for 2)', 0, NULL, 84, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648769, 132, 'codeSystem', '', ' ', 1648767, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.99.2.206', 0, NULL, 85, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648770, 132, 'codeSystemName', '', ' ', 1648767, 'О', 2, 100, 0, 2, 1648686, 1, 'Субъекты Российской Федерации', 0, NULL, 86, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648771, 132, 'displayName', '', ' ', 1648767, 'О', 2, 250, 0, 2, 1648686, 0, 'case when substring(CON_INN from 1 for 2) = ''89'' then ''Ямало-Ненецкий автономный округ'' else (select first 1 subj from h_LPU where inn = CON_INN) end', 0, NULL, 87, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648772, 132, 'codeSystemVersion', '', ' ', 1648767, 'О', 2, 5, 0, 2, 1648686, 1, '6.5', 0, NULL, 88, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648773, 132, 'postalCode', '', ' ', 1648765, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 89, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648774, 132, 'nullFlavor', '', ' ', 1648773, 'О', 2, 2, 0, 2, 1648686, 3, 'NI', 0, NULL, 90, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648775, 132, 'fias:Address', '', ' ', 1648765, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 91, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648776, 132, 'nullFlavor', '', ' ', 1648775, 'О', 2, 2, 0, 2, 1648686, 1, 'NI', 0, NULL, 92, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648777, 132, 'author', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 94, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''V_EMK_DOCTORS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648778, 132, 'time', '', ' ', 1648777, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 95, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648779, 132, 'nullFlavor', '', ' ', 1648778, 'О', 2, 2, 0, 2, 1648686, 1, 'NI', 0, NULL, 96, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648780, 132, 'assignedAuthor', '', ' ', 1648777, 'О', NULL, NULL, NULL, 1, 1648686, 2, 'select * from v_emk_doctors v_e where id = :MAS_ZS.DOC_ID', 0, NULL, 97, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''V_EMK_DOCTORS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648781, 132, 'id', '', ' ', 1648780, 'О', NULL, NULL, NULL, 1, 1648780, 3, '', 0, NULL, 98, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648782, 132, 'root', '', ' ', 1648781, 'О', 2, 100, 0, 2, 1648780, 0, '(select oid from contragents where type_id = 1) || ''.100.1.1.70''', 0, NULL, 99, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648783, 132, 'extension', '', ' ', 1648781, 'О', 2, 20, 0, 2, 1648780, 0, 'v_e.ss', 0, NULL, 100, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649047, 132, 'displayName', '', ' ', 1649042, 'О', 2, 250, 0, 2, 1648686, 1, 'Первичный', 0, NULL, 250, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649048, 132, 'codeSystemVersion', '', ' ', 1649042, 'О', 2, 10, 0, 2, 1648686, 1, '2.1', 0, NULL, 251, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649049, 132, 'classCode', '', ' ', 1649035, 'О', 2, 10, 0, 2, 1648686, 1, 'OBS', 0, NULL, 237, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649050, 132, 'moodCode', '', ' ', 1649035, 'О', 2, 10, 0, 2, 1648686, 1, 'EVN', 0, NULL, 238, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649051, 132, 'entry', '', ' ', 1649010, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 269, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649052, 132, 'observation', '', ' ', 1649051, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 270, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649053, 132, 'code', '', ' ', 1649052, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 273, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649054, 132, 'code', '', ' ', 1649053, 'О', 2, 5, 0, 2, 1648686, 1, '818', 0, NULL, 274, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649055, 132, 'codeSystem', '', ' ', 1649053, 'О', 2, 100, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.99.2.166', 0, NULL, 275, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649056, 132, 'codeSystemName', '', ' ', 1649053, 'О', 2, 100, 0, 2, 1648686, 1, 'Кодируемые поля CDA документов', 0, NULL, 276, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649057, 132, 'displayName', '', ' ', 1649053, 'О', 2, 100, 0, 2, 1648686, 1, 'Результаты обращения (госпитализации)', 0, NULL, 277, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649058, 132, 'codeSystemVersion', '', ' ', 1649053, 'О', 2, 10, 0, 2, 1648686, 1, '5.35', 0, NULL, 278, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649059, 132, 'value', '', ' ', 1649052, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 279, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649060, 132, 'xsi:type', '', ' ', 1649059, 'О', 2, 2, 0, 2, 1648686, 1, 'CD', 0, NULL, 280, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649061, 132, 'code', '', ' ', 1649059, 'О', 1, 3, 0, 2, 1648686, 0, 'ZS.IDCASERESULT', 0, NULL, 281, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649062, 132, 'codeSystem', '', ' ', 1649059, 'О', 2, 100, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.11.1046', 0, NULL, 282, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649063, 132, 'codeSystemName', '', ' ', 1649059, 'О', 2, 250, 0, 2, 1648686, 1, 'Результаты обращения', 0, NULL, 283, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649064, 132, 'displayName', '', ' ', 1649059, 'О', 2, 250, 0, 2, 1648686, 0, '(select name from emk_handbooks_data where handbook_id = (select first 1 id from emk_handbooks where code = ''1.2.643.5.1.13.13.11.1046'' and parent_id = id) and code = ZS.IDCASERESULT)', 0, NULL, 284, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649065, 132, 'codeSystemVersion', '', ' ', 1649059, 'О', 2, 10, 0, 2, 1648686, 1, '5.1', 0, NULL, 285, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649066, 132, 'classCode', '', ' ', 1649052, 'О', 2, 10, 0, 2, 1648686, 1, 'OBS', 0, NULL, 271, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649067, 132, 'moodCode', '', ' ', 1649052, 'О', 2, 10, 0, 2, 1648686, 1, 'EVN', 0, NULL, 272, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1650389, 132, 'component', '', ' ', 1650390, 'О', NULL, NULL, NULL, 1, 1650389, 3, '', 0, NULL, 294, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (144, 132, 'observation', '', ' ', 143, 'О', NULL, NULL, NULL, 1, 1650389, 3, '', 0, NULL, 295, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (145, 132, 'classCode', '', ' ', 144, 'О', 2, 10, 0, 2, 1650389, 1, 'OBS', 0, NULL, 296, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (146, 132, 'moodCode', '', ' ', 144, 'О', 2, 10, 0, 2, 1650389, 1, 'EVN', 0, NULL, 297, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (147, 132, 'code', '', ' ', 144, 'О', NULL, NULL, NULL, 1, 1650389, 3, '', 0, NULL, 298, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (148, 132, 'code', '', ' ', 147, 'О', 2, 5, 0, 2, 1650389, 1, '807', 0, NULL, 299, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (149, 132, 'codeSystem', '', ' ', 147, 'О', 2, 100, 0, 2, 1650389, 1, '1.2.643.5.1.13.13.99.2.166', 0, NULL, 300, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (150, 132, 'codeSystemName', '', ' ', 147, 'О', 2, 100, 0, 2, 1650389, 1, 'Кодируемые поля CDA документов', 0, NULL, 301, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (151, 132, 'displayName', '', ' ', 147, 'О', 2, 200, 0, 2, 1650389, 1, 'Рекомендации ', 0, NULL, 302, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (152, 132, 'codeSystemVersion', '', ' ', 147, 'О', 2, 10, 0, 2, 1650389, 1, '5.35', 0, NULL, 303, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (153, 132, 'value', '', ' ', 144, 'О', 2, 1000, 0, 1, 1650389, 0, 'PAT.MEANING_NAME', 0, NULL, 304, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (154, 132, 'xsi:type', '', ' ', 153, 'О', 2, 2, 0, 2, 1650389, 1, 'ST', 0, NULL, 305, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (160, 132, 'component', '', ' ', 161, 'О', NULL, NULL, NULL, 1, 160, 3, '', 0, NULL, 294, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (169, 132, 'observation', '', ' ', 168, 'О', NULL, NULL, NULL, 1, 160, 3, '', 0, NULL, 295, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (170, 132, 'classCode', '', ' ', 169, 'О', 2, 10, 0, 2, 160, 1, 'OBS', 0, NULL, 296, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (171, 132, 'moodCode', '', ' ', 169, 'О', 2, 10, 0, 2, 160, 1, 'EVN', 0, NULL, 297, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (172, 132, 'code', '', ' ', 169, 'О', NULL, NULL, NULL, 1, 160, 3, '', 0, NULL, 298, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (173, 132, 'code', '', ' ', 172, 'О', 2, 5, 0, 2, 160, 1, '4102', 0, NULL, 299, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (174, 132, 'codeSystem', '', ' ', 172, 'О', 2, 100, 0, 2, 160, 1, '1.2.643.5.1.13.13.99.2.166', 0, NULL, 300, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (175, 132, 'codeSystemName', '', ' ', 172, 'О', 2, 100, 0, 2, 160, 1, 'Кодируемые поля CDA документов', 0, NULL, 301, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (176, 132, 'displayName', '', ' ', 172, 'О', 2, 200, 0, 2, 160, 1, 'Анамнез заболевания', 0, NULL, 302, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (177, 132, 'codeSystemVersion', '', ' ', 172, 'О', 2, 10, 0, 2, 160, 1, '5.35', 0, NULL, 303, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (178, 132, 'value', '', ' ', 169, 'О', 2, 1000, 0, 1, 160, 0, 'PAT.MEANING_NAME', 0, NULL, 304, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (179, 132, 'xsi:type', '', ' ', 178, 'О', 2, 2, 0, 2, 160, 1, 'ST', 0, NULL, 305, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (180, 132, 'component', '', ' ', 181, 'О', NULL, NULL, NULL, 1, 180, 3, '', 0, NULL, 294, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (189, 132, 'observation', '', ' ', 188, 'О', NULL, NULL, NULL, 1, 180, 3, '', 0, NULL, 295, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (190, 132, 'classCode', '', ' ', 189, 'О', 2, 10, 0, 2, 180, 1, 'OBS', 0, NULL, 296, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (191, 132, 'moodCode', '', ' ', 189, 'О', 2, 10, 0, 2, 180, 1, 'EVN', 0, NULL, 297, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (192, 132, 'code', '', ' ', 189, 'О', NULL, NULL, NULL, 1, 180, 3, '', 0, NULL, 298, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (193, 132, 'code', '', ' ', 192, 'О', 2, 5, 0, 2, 180, 1, '4103', 0, NULL, 299, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (194, 132, 'codeSystem', '', ' ', 192, 'О', 2, 100, 0, 2, 180, 1, '1.2.643.5.1.13.13.99.2.166', 0, NULL, 300, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (195, 132, 'codeSystemName', '', ' ', 192, 'О', 2, 100, 0, 2, 180, 1, 'Кодируемые поля CDA документов', 0, NULL, 301, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (196, 132, 'displayName', '', ' ', 192, 'О', 2, 200, 0, 2, 180, 1, 'Анамнез жизни', 0, NULL, 302, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (197, 132, 'codeSystemVersion', '', ' ', 192, 'О', 2, 10, 0, 2, 180, 1, '5.35', 0, NULL, 303, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (198, 132, 'value', '', ' ', 189, 'О', 2, 1000, 0, 1, 180, 0, 'PAT.MEANING_NAME', 0, NULL, 304, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (199, 132, 'xsi:type', '', ' ', 198, 'О', 2, 2, 0, 2, 180, 1, 'ST', 0, NULL, 305, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648798, 132, 'DOC_ID', '', ' ', 1648686, 'Н', 1, 10, 0, 1, 1648686, 0, 'doc_id', 1, NULL, 93, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648799, 132, 'id', '', ' ', 1648780, 'О', NULL, NULL, NULL, 1, 1648780, 3, '', 0, NULL, 101, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''V_EMK_DOCTORS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648800, 132, 'root', '', ' ', 1648799, 'О', 2, 50, 0, 2, 1648780, 1, '1.2.643.100.3', 0, NULL, 102, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648801, 132, 'extension', '', ' ', 1648799, 'О', 2, 20, 0, 2, 1648780, 0, 'v_e.ss', 0, NULL, 103, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648802, 132, 'code', '', ' ', 1648780, 'О', NULL, NULL, NULL, 1, 1648780, 3, '', 0, NULL, 104, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''V_EMK_DOCTORS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648803, 132, 'code', '', ' ', 1648802, 'О', 2, 10, 0, 2, 1648780, 0, 'v_e.post', 0, NULL, 105, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648804, 132, 'codeSystem', '', ' ', 1648802, 'О', 2, 50, 0, 2, 1648780, 1, '1.2.643.5.1.13.13.11.1002', 0, NULL, 106, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648805, 132, 'codeSystemName', '', ' ', 1648802, 'О', 2, 150, 0, 2, 1648780, 1, 'Должности медицинских и фармацевтических работников', 0, NULL, 107, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648806, 132, 'displayName', '', ' ', 1648802, 'О', 2, 150, 0, 2, 1648780, 0, 'v_e.post_name', 0, NULL, 108, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648807, 132, 'codeSystemVersion', '', ' ', 1648802, 'О', 2, 5, 0, 2, 1648780, 1, '9.3', 0, NULL, 109, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648808, 132, 'assignedPerson', '', ' ', 1648780, 'О', NULL, NULL, NULL, 1, 1648780, 3, '', 0, NULL, 110, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648809, 132, 'name', '', ' ', 1648808, 'О', NULL, NULL, NULL, 1, 1648780, 3, '', 0, NULL, 111, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648810, 132, 'family', '', ' ', 1648809, 'О', 2, 40, 0, 1, 1648780, 0, 'v_e.FAM', 0, NULL, 112, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648811, 132, 'given', '', ' ', 1648809, 'О', 2, 40, 0, 1, 1648780, 0, 'v_e.IM', 0, NULL, 113, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648812, 132, 'identity:Patronymic', '', ' ', 1648809, 'О', 2, 40, 0, 1, 1648780, 0, 'v_e.OT', 0, NULL, 114, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648851, 132, 'custodian', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 115, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648852, 132, 'assignedCustodian', '', ' ', 1648851, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 116, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''CONTRAGENTS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648853, 132, 'representedCustodianOrganization', '', ' ', 1648852, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 117, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648854, 132, 'classCode', '', ' ', 1648853, 'О', 2, 10, 0, 2, 1648686, 1, 'ORG', 0, NULL, 118, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648855, 132, 'id', '', ' ', 1648853, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 119, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648856, 132, 'root', '', ' ', 1648855, 'О', 2, 100, 0, 2, 1648686, 0, 'con_oid', 0, NULL, 120, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648860, 132, 'name', '', ' ', 1648853, 'О', 2, 250, 0, 1, 1648686, 0, 'CON_FULL_NAME', 0, NULL, 121, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648861, 132, 'addr', '', ' ', 1648853, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 122, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648862, 132, 'streetAddressLine', '', ' ', 1648861, 'О', 2, 250, 0, 1, 1648686, 0, 'CON_ADRES', 0, NULL, 123, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648863, 132, 'address:stateCode', '', ' ', 1648861, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 124, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648864, 132, 'code', '', ' ', 1648863, 'О', 2, 2, 0, 2, 1648686, 0, 'substring(CON_INN from 1 for 2)', 0, NULL, 125, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648865, 132, 'codeSystem', '', ' ', 1648863, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.99.2.206', 0, NULL, 126, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648866, 132, 'codeSystemName', '', ' ', 1648863, 'О', 2, 100, 0, 2, 1648686, 1, 'Субъекты Российской Федерации', 0, NULL, 127, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648867, 132, 'displayName', '', ' ', 1648863, 'О', 2, 250, 0, 2, 1648686, 0, 'case when substring(CON_INN from 1 for 2) = ''89'' then ''Ямало-Ненецкий автономный округ'' else (select first 1 subj from h_LPU where inn = CON_INN) end', 0, NULL, 128, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648868, 132, 'codeSystemVersion', '', ' ', 1648863, 'О', 2, 5, 0, 2, 1648686, 1, '6.5', 0, NULL, 129, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648869, 132, 'postalCode', '', ' ', 1648861, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 130, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648870, 132, 'nullFlavor', '', ' ', 1648869, 'О', 2, 2, 0, 2, 1648686, 3, 'NI', 0, NULL, 131, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648871, 132, 'fias:Address', '', ' ', 1648861, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 132, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648872, 132, 'nullFlavor', '', ' ', 1648871, 'О', 2, 2, 0, 2, 1648686, 1, 'NI', 0, NULL, 133, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648873, 132, 'informationRecipient', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 134, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648874, 132, 'intendedRecipient', '', ' ', 1648873, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 135, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648875, 132, 'receivedOrganization', '', ' ', 1648874, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 136, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648876, 132, 'id', '', ' ', 1648875, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 137, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648877, 132, 'root', '', ' ', 1648876, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13', 0, NULL, 138, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648878, 132, 'name', '', ' ', 1648875, 'О', 2, 250, 0, 1, 1648686, 1, 'Министерство здравоохранения Российской Федерации', 0, NULL, 139, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648879, 132, 'legalAuthenticator', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 140, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648880, 132, 'time', '', ' ', 1648879, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 141, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648881, 132, 'nullFlavor', '', ' ', 1648880, 'О', 2, 2, 0, 2, 1648686, 1, 'NI', 0, NULL, 142, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648882, 132, 'assignedEntity', '', ' ', 1648879, 'О', NULL, NULL, NULL, 1, 1648686, 2, 'select * from v_emk_doctors v_e where id = :MAS_ZS.DOC_ID', 0, NULL, 145, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''V_EMK_DOCTORS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648883, 132, 'id', '', ' ', 1648882, 'О', NULL, NULL, NULL, 1, 1648882, 3, '', 0, NULL, 146, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648884, 132, 'root', '', ' ', 1648883, 'О', 2, 100, 0, 2, 1648882, 0, '(select oid from contragents where type_id = 1) || ''.100.1.1.70''', 0, NULL, 147, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648885, 132, 'extension', '', ' ', 1648883, 'О', 2, 20, 0, 2, 1648882, 0, 'v_e.ss', 0, NULL, 148, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648886, 132, 'id', '', ' ', 1648882, 'О', NULL, NULL, NULL, 1, 1648882, 3, '', 0, NULL, 149, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''V_EMK_DOCTORS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648887, 132, 'root', '', ' ', 1648886, 'О', 2, 50, 0, 2, 1648882, 1, '1.2.643.100.3', 0, NULL, 150, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648888, 132, 'extension', '', ' ', 1648886, 'О', 2, 20, 0, 2, 1648882, 0, 'v_e.ss', 0, NULL, 151, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648889, 132, 'code', '', ' ', 1648882, 'О', NULL, NULL, NULL, 1, 1648882, 3, '', 0, NULL, 152, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''V_EMK_DOCTORS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648890, 132, 'code', '', ' ', 1648889, 'О', 2, 10, 0, 2, 1648882, 0, 'v_e.post', 0, NULL, 153, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648891, 132, 'codeSystem', '', ' ', 1648889, 'О', 2, 50, 0, 2, 1648882, 1, '1.2.643.5.1.13.13.11.1002', 0, NULL, 154, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648892, 132, 'codeSystemName', '', ' ', 1648889, 'О', 2, 150, 0, 2, 1648882, 1, 'Должности медицинских и фармацевтических работников', 0, NULL, 155, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648893, 132, 'displayName', '', ' ', 1648889, 'О', 2, 150, 0, 2, 1648882, 0, 'v_e.post_name', 0, NULL, 156, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648894, 132, 'codeSystemVersion', '', ' ', 1648889, 'О', 2, 5, 0, 2, 1648882, 1, '9.3', 0, NULL, 157, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648895, 132, 'assignedPerson', '', ' ', 1648882, 'О', NULL, NULL, NULL, 1, 1648882, 3, '', 0, NULL, 158, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648896, 132, 'name', '', ' ', 1648895, 'О', NULL, NULL, NULL, 1, 1648882, 3, '', 0, NULL, 159, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648897, 132, 'family', '', ' ', 1648896, 'О', 2, 40, 0, 1, 1648882, 0, 'v_e.FAM', 0, NULL, 160, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648898, 132, 'given', '', ' ', 1648896, 'О', 2, 40, 0, 1, 1648882, 0, 'v_e.IM', 0, NULL, 161, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648899, 132, 'identity:Patronymic', '', ' ', 1648896, 'О', 2, 40, 0, 1, 1648882, 0, 'v_e.OT', 0, NULL, 162, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648920, 132, 'signatureCode', '', ' ', 1648879, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 143, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648921, 132, 'nullFlavor', '', ' ', 1648920, 'О', 2, 2, 0, 2, 1648686, 1, 'NI', 0, NULL, 144, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648922, 132, 'documentationOf', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 163, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648923, 132, 'serviceEvent', '', ' ', 1648922, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 164, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648924, 132, 'code', '', ' ', 1648923, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 165, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648925, 132, 'code', '', ' ', 1648924, 'О', 1, 4, 0, 2, 1648686, 1, '51', 0, NULL, 166, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648926, 132, 'codeSystem', '', ' ', 1648924, 'О', 2, 100, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.99.2.726', 0, NULL, 167, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648927, 132, 'codeSystemName', '', ' ', 1648924, 'О', 2, 200, 0, 2, 1648686, 1, 'Типы документированных событий', 0, NULL, 168, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648928, 132, 'displayName', '', ' ', 1648924, 'О', 2, 250, 0, 2, 1648686, 1, 'Случай оказания медицинской помощи', 0, NULL, 169, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648929, 132, 'codeSystemVersion', '', ' ', 1648924, 'О', 2, 10, 0, 2, 1648686, 1, '3.37', 0, NULL, 170, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648930, 132, 'effectiveTime', '', ' ', 1648923, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 171, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648931, 132, 'low', '', ' ', 1648930, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 172, NULL, 'YYYYMMDD', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648932, 132, 'value', '', ' ', 1648931, 'О', 3, 0, 0, 2, 1648686, 0, 'ZS.DATE_1', 0, NULL, 173, NULL, 'YYYYMMDD', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648933, 132, 'high', '', ' ', 1648930, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 174, NULL, 'YYYYMMDD', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648934, 132, 'value', '', ' ', 1648933, 'О', 3, 0, 0, 2, 1648686, 0, 'ZS.DATE_2', 0, NULL, 175, NULL, 'YYYYMMDD', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648935, 132, 'medService:serviceForm', '', ' ', 1648923, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 176, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648936, 132, 'code', '', ' ', 1648935, 'О', 1, 1, 0, 2, 1648686, 0, 'zs.for_pom_code', 0, NULL, 177, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648937, 132, 'codeSystem', '', ' ', 1648935, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.11.1551', 0, NULL, 178, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648938, 132, 'codeSystemName', '', ' ', 1648935, 'О', 2, 150, 0, 2, 1648686, 1, 'Формы оказания медицинской помощи', 0, NULL, 179, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648939, 132, 'displayName', '', ' ', 1648935, 'О', 2, 100, 0, 2, 1648686, 0, 'ZS.FOR_POM_NAME', 0, NULL, 180, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648940, 132, 'codeSystemVersion', '', ' ', 1648935, 'О', 2, 10, 0, 2, 1648686, 1, '1.1', 0, NULL, 181, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648941, 132, 'medService:serviceType', '', ' ', 1648923, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 182, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648942, 132, 'code', '', ' ', 1648941, 'О', 1, 1, 0, 2, 1648686, 0, 'zs.vid_mp_code', 0, NULL, 183, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648943, 132, 'codeSystem', '', ' ', 1648941, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.11.1034', 0, NULL, 184, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648944, 132, 'codeSystemName', '', ' ', 1648941, 'О', 2, 150, 0, 2, 1648686, 1, 'Виды медицинской помощи', 0, NULL, 185, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648945, 132, 'displayName', '', ' ', 1648941, 'О', 2, 100, 0, 2, 1648686, 0, 'ZS.vid_mp_name', 0, NULL, 186, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648946, 132, 'codeSystemVersion', '', ' ', 1648941, 'О', 2, 10, 0, 2, 1648686, 1, '4.2', 0, NULL, 187, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648947, 132, 'medService:serviceCond', '', ' ', 1648923, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 188, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648948, 132, 'code', '', ' ', 1648947, 'О', 1, 1, 0, 2, 1648686, 1, '2', 0, NULL, 189, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648949, 132, 'codeSystem', '', ' ', 1648947, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.99.2.322', 0, NULL, 190, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648950, 132, 'codeSystemName', '', ' ', 1648947, 'О', 2, 150, 0, 2, 1648686, 1, 'Условия оказания медицинской помощи', 0, NULL, 191, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648951, 132, 'displayName', '', ' ', 1648947, 'О', 2, 200, 0, 2, 1648686, 1, 'Амбулаторно, в том числе на дому при вызове медицинского работника', 0, NULL, 192, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648952, 132, 'codeSystemVersion', '', ' ', 1648947, 'О', 2, 10, 0, 2, 1648686, 1, '2.1', 0, NULL, 193, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648953, 132, 'performer', '!-- R [1..*] Сведения об участнике документируемого события -->', ' ', 1648923, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 194, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648954, 132, 'assignedEntity', '', ' ', 1648953, 'О', NULL, NULL, NULL, 1, 1648686, 2, 'select * from v_emk_doctors doc where doc.id = :MAS_ZS.DOC_ID', 0, NULL, 196, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''V_EMK_DOCTORS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649001, 132, 'code', '', ' ', 1648994, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 219, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649002, 132, 'code', '', ' ', 1649001, 'О', 1, 3, 0, 2, 1648686, 1, '1', 0, NULL, 220, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649003, 132, 'codeSystem', '', ' ', 1649001, 'О', 2, 100, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.99.2.723', 0, NULL, 221, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649004, 132, 'codeSystemName', '', ' ', 1649001, 'О', 2, 200, 0, 2, 1648686, 1, 'Типы медицинских карт', 0, NULL, 222, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649005, 132, 'displayName', '', ' ', 1649001, 'О', 2, 200, 0, 2, 1648686, 1, 'Амбулаторная медицинская карта', 0, NULL, 223, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649006, 132, 'codeSystemVersion', '', ' ', 1649001, 'О', 2, 10, 0, 2, 1648686, 1, '1.1', 0, NULL, 224, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649007, 132, 'component', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 225, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649008, 132, 'structuredBody', '', ' ', 1649007, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 226, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649009, 132, 'component', '', ' ', 1649008, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 227, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649010, 132, 'section', '', ' ', 1649009, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 228, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649011, 132, 'code', '', ' ', 1649010, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 229, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649012, 132, 'code', '', ' ', 1649011, 'О', 2, 10, 0, 2, 1648686, 1, 'AMBS', 0, NULL, 230, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649013, 132, 'codeSystem', '', ' ', 1649011, 'О', 2, 50, 0, 2, 1648686, 1, '1.2.643.5.1.13.13.99.2.197', 0, NULL, 231, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649014, 132, 'codeSystemName', '', ' ', 1649011, 'О', 2, 200, 0, 2, 1648686, 1, 'Секции электронных медицинских документов', 0, NULL, 232, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649015, 132, 'displayName', '', ' ', 1649011, 'О', 2, 200, 0, 2, 1648686, 1, 'Сведения амбулаторно-поликлинического обращения', 0, NULL, 233, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649016, 132, 'codeSystemVersion', '', ' ', 1649011, 'О', 2, 10, 0, 2, 1648686, 1, '4.26', 0, NULL, 234, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649017, 132, 'entry', '', ' ', 1649010, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 252, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649018, 132, 'observation', '', ' ', 1649017, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 253, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649019, 132, 'classCode', '', ' ', 1649018, 'О', 2, 10, 0, 2, 1648686, 1, 'OBS', 0, NULL, 254, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649020, 132, 'moodCode', '', ' ', 1649018, 'О', 2, 10, 0, 2, 1648686, 1, 'EVN', 0, NULL, 255, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648955, 132, 'id', '', ' ', 1648954, 'О', NULL, NULL, NULL, 1, 1648954, 3, '', 0, NULL, 197, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648956, 132, 'root', '', ' ', 1648955, 'О', 2, 100, 0, 2, 1648954, 0, '(select oid from contragents where type_id = 1) || ''.100.1.1.70''', 0, NULL, 198, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648957, 132, 'extension', '', ' ', 1648955, 'О', 2, 20, 0, 2, 1648954, 0, 'doc.ss', 0, NULL, 199, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648961, 132, 'code', '', ' ', 1648954, 'О', NULL, NULL, NULL, 1, 1648954, 3, '', 0, NULL, 200, 'select F.RDB$FIELD_ID ID, R.RDB$RELATION_NAME RELATION_NAME, replace(substring(R.RDB$RELATION_NAME from 1 for 3),'' '', '''') || ''.'' || F.RDB$FIELD_NAME as fn, cast(f.rdb$description as varchar(250)) as fd from RDB$RELATIONS R JOIN RDB$RELATION_FIELDS F ON F.RDB$RELATION_NAME = R.RDB$RELATION_NAME where (F.RDB$SYSTEM_FLAG = 0) AND (R.RDB$RELATION_TYPE = 0) and (R.RDB$RELATION_NAME in (''V_EMK_DOCTORS'')) and f.rdb$description <> '' '' order by fd', NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648962, 132, 'code', '', ' ', 1648961, 'О', 2, 10, 0, 2, 1648954, 0, 'doc.post', 0, NULL, 201, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648963, 132, 'codeSystem', '', ' ', 1648961, 'О', 2, 50, 0, 2, 1648954, 1, '1.2.643.5.1.13.13.11.1002', 0, NULL, 202, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648964, 132, 'codeSystemName', '', ' ', 1648961, 'О', 2, 150, 0, 2, 1648954, 1, 'Должности медицинских и фармацевтических работников', 0, NULL, 203, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648965, 132, 'displayName', '', ' ', 1648961, 'О', 2, 150, 0, 2, 1648954, 0, 'doc.post_name', 0, NULL, 204, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648966, 132, 'codeSystemVersion', '', ' ', 1648961, 'О', 2, 5, 0, 2, 1648954, 1, '9.3', 0, NULL, 205, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648967, 132, 'assignedPerson', '', ' ', 1648954, 'О', NULL, NULL, NULL, 1, 1648954, 3, '', 0, NULL, 206, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648968, 132, 'name', '', ' ', 1648967, 'О', NULL, NULL, NULL, 1, 1648954, 3, '', 0, NULL, 207, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648969, 132, 'family', '', ' ', 1648968, 'О', 2, 40, 0, 1, 1648954, 0, 'DOC.FAM', 0, NULL, 208, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648970, 132, 'given', '', ' ', 1648968, 'О', 2, 40, 0, 1, 1648954, 0, 'DOC.IM', 0, NULL, 209, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648971, 132, 'identity:Patronymic', '', ' ', 1648968, 'О', 2, 40, 0, 1, 1648954, 0, 'DOC.OT', 0, NULL, 210, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648992, 132, 'typeCode', '', ' ', 1648953, 'О', 2, 10, 0, 2, 1648686, 1, 'PPRF', 0, NULL, 195, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648993, 132, 'componentOf', '', ' ', 1648686, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 211, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648994, 132, 'encompassingEncounter', '', ' ', 1648993, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 212, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648995, 132, 'id', '', ' ', 1648994, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 213, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648996, 132, 'root', '', ' ', 1648995, 'О', 2, 100, 0, 2, 1648686, 0, '(select oid from contragents where type_id = 1) || ''.100.1.1.15''', 0, NULL, 214, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648997, 132, 'extension', '', ' ', 1648995, 'О', 1, 10, 0, 2, 1648686, 0, 'ZS.ID', 0, NULL, 215, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648998, 132, 'id', '', ' ', 1648994, 'О', NULL, NULL, NULL, 1, 1648686, 3, '', 0, NULL, 216, NULL, NULL, NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1648999, 132, 'extension', '', ' ', 1648998, 'О', 2, 50, 0, 2, 1648686, 0, 'ZS.N_HIST', 0, NULL, 218, NULL, '', NULL) MATCHING (ID); UPDATE OR INSERT INTO XML_ITEMS (ID, XML_STRUCTURE_ID, NAME, CAPTION, NOTE, PARENT_ID, ITEM_TYPE, DATA_ID, DATA_LENGTH, DATA_PRECISION, FORM, CONDITION_SELECT_ID, VAL_TYPE, VAL, IS_NO_SHOW, VAL_PREFIX, NPP, FIELDS_CONDITION, DATA_DATE_FORMAT, IS_EXPORT_EMPTY) VALUES (1649000, 132, 'root', '', ' ', 1648998, 'О', 2, 100, 0, 2, 1648686, 0, '(select oid from contragents where type_id = 1) || ''.100.1.1.17''', 0, NULL, 217, NULL, '', NULL) MATCHING (ID); COMMIT WORK; update xml_items set id = id where xml_structure_id in (132);