insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
null,
'Территориальные счета',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'OMS_SCHET'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'OMS_SCHET'),
0

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'SignatureReturnedAct',
'Возвращенный акт с подписью',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'SIGNED_ACT_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'SIGNED_ACT_FILE'),
101

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
null,
'Регистр',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = null),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = null),
21

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'ExpertiseResultFile',
'Результат экспертизы',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'EXPERT_REQUEST'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'EXPERT_REQUEST'),
34

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'AttachmentInfo',
'Прикрепления',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'ATTACHMENT_INFO'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'ATTACHMENT_INFO'),
8

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode)
select newid(),
null,
'Счета-реестры ФМО',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'FMO_SCHET'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'FMO_SCHET'),
29

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
null,
'МТР от ТФОМС',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'MTR_SCHET_IN'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'MTR_SCHET_IN'),
3

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'ExpertiseResultTat',
'Результаты отбора на экспертизу(татарстан)',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = null),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = null),
17

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'VmpDirectList',
'Направление на ВМП',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'VMP_DIRECT_LIST_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'VMP_DIRECT_LIST_FILE'),
11

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
null,
'Исходящие счета-реестры из ГИС',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'MTR_SCHET_OUT'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'MTR_SCHET_OUT'),
31

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode)
select newid(),
null,
'Временные счета',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'TEMP_SCHET'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'TEMP_SCHET'),
1

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'InfoAdmissionTfoms',
'СМЭВ Сведения для приема в ТФОМС обращений по оказанным медицинским услугам',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = null),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = null),
24

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid()
,null,
'Еженедельные счета по диспансеризации',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'DISP_SCHET'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'DISP_SCHET'),
28

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'RequestCertificateCost',
'Запрос справки о стоимости',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = null),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = null),
100

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'SmoExpertiseAct',
'Акты МЭЭ и ЭКМП',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'SMO_EXPERTISE_ACT_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'SMO_EXPERTISE_ACT_FILE'),
4

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
null,
'Счета-реестры COVID-19',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'COVID_SCHET'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'COVID_SCHET'),
30

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'SmevTransferStatementTfoms',
'Передача заявления о выборе СМО в ТФОМС',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = null),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = null),
32

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
null,
'Загрузка нарушений из ИСЗЛ',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'VIOLATION_FROM_ISZL'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'VIOLATION_FROM_ISZL'),
26

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
null,
'МТР от МО',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'MTR_SCHET_LPU'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'MTR_SCHET_LPU'),
2

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'FomsPayment',
'Сведения об оплате от ТФОМС',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'PAYMENT_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'PAYMENT_FILE'),
19

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'PolicyPackImport',
'Пакеты полисов',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'POLICY_PACK'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'POLICY_PACK'),
13

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'RodImport',
'Сведения о лицах, взятых на учет с 3-4 стадией онкологических заболеваний',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'ROD_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'ROD_FILE'),
16

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'MtrZapError',
'Ошибки записей о счетах МТР',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'MTR_SCHET_ZAP_ERROR'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'MTR_SCHET_ZAP_ERROR'),
33

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'DispDirect',
'Направления на диспансеризацию',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'DISP_DIRECT_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'DISP_DIRECT_FILE'),
14

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
null,
'Прикрепления на загрузку',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'ATTACHMENT_INFO_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'ATTACHMENT_INFO_FILE'),
23

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode)
select newid(),
'GisProtocolDownload',
'Загрузка протокола ГИС',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'MTR_SCHET_PROTOCOL'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'MTR_SCHET_PROTOCOL'),
25

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'SmoExpertiseBank',
'Сведения об исполнении по банку результатов экспертиз',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'SMO_EXPERTISE_BANK_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'SMO_EXPERTISE_BANK_FILE'),
12

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'DnList',
'Сведения о диспансерном наблюдении',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'DN_LIST_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'DN_LIST_FILE'),
15

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'ProtocolProcessingPolicy',
'???????? ????????? ?????? ???????',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'POLICY_PACK'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'POLICY_PACK'),
20

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'TreasuryPayments',
'Протокол обработки пакета полисов',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'PAYMENT_TREASURE_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'PAYMENT_TREASURE_FILE'),
27

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'PaymentOrderPack',
'Платежные поручения от бухгалтерии',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'PAYMENT_ORDER_PACK_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'PAYMENT_ORDER_PACK_FILE'),
10

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'RfSchet',
'Акты RF',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'RF_SCHET_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'RF_SCHET_FILE'),
6

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'OuterAct',
'Акты МТР',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'OUTER_ACT_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'OUTER_ACT_FILE'),
5

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'FomsUecMessage',
'Изменение статуса УЭК',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'MESSAGE_PACK_UPRMES_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'MESSAGE_PACK_UPRMES_FILE'),
9

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'SmevInfoServicesCost',
'СМЭВ сведения об оказанных медицинских услугах и их стоимости',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = null),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = null),
22

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'InsuredRightProtect',
'Файлы ЗПЗ',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'INSURED_RIGTH_PROTECT_FILE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'INSURED_RIGTH_PROTECT_FILE'),
7

insert into IES.T_IMPORT_RECORD (importrecordid,processname,processdescription,entities,answerentities,loadmode) 
select newid(),
'DownloadFederalReference',
'Справочники ФФОМС',
(select top 1 e.EntityID from vclib.T_ENTITIES e where e.EntName = 'NSI_UPDATE'),
(select top 1 ea.EntityID from vclib.T_ENTITIES ea where ea.EntName = 'NSI_UPDATE'),
18