Схема загрузки

<EXPORT IDENT="DMSSxem" DATE="28.04.2020 17:01:46">
<T NAME="bookshemas" SQL="select * from bookshemas where coalesce(SHEMTYPE, 0) = 0 and (SHEMAID = 990006094) " CM="G" GF="SHEMAID" GN="BOOKSXEM_GEN" FK="BOOKSHEMADETAIL.SHEMAID">
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="USETITLE" VALUE="13"/>
<F NAME="SOURCETYPE" VALUE="1"/>
<F NAME="KEYTYPE" VALUE="4"/>
<F NAME="FINDRANGE" VALUE="5"/>
<F NAME="NEWAGR" VALUE="2"/>
<F NAME="SNAME" VALUE="'!Контур'"/>
<F NAME="CHECKEDIT" VALUE="0"/>
<F NAME="SHEMTYPE" VALUE="0"/>
<F NAME="HISTKEYTYPE" VALUE="1"/>
<F NAME="LOADTYPE" VALUE="0"/>
<F NAME="HISTUPDTYPE" VALUE="0"/>
</R>
</T>
<T NAME="BOOKSHEMADETAIL" SQL="select d.* from BOOKSHEMADETAIL d left join bookshemas s on (d.SHEMAID = s.SHEMAID) where coalesce(SHEMTYPE, 0) = 0 and (d.SHEMAID = 990006094) " CM="I">
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="1"/>
<F NAME="FNAME" VALUE="'Фамилия пациента'"/>
<F NAME="ACOLUMN" VALUE="2"/>
<F NAME="EDITTYPE" VALUE="0"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="2"/>
<F NAME="FNAME" VALUE="'Имя пациента'"/>
<F NAME="ACOLUMN" VALUE="3"/>
<F NAME="EDITTYPE" VALUE="0"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="3"/>
<F NAME="FNAME" VALUE="'Отчество пациента'"/>
<F NAME="ACOLUMN" VALUE="4"/>
<F NAME="EDITTYPE" VALUE="0"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="11"/>
<F NAME="FNAME" VALUE="'Дата рождения'"/>
<F NAME="ACOLUMN" VALUE="5"/>
<F NAME="EDITTYPE" VALUE="1"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="4"/>
<F NAME="FNAME" VALUE="'№ полиса'"/>
<F NAME="ACOLUMN" VALUE="6"/>
<F NAME="EDITTYPE" VALUE="0"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="8"/>
<F NAME="FNAME" VALUE="'Дата начала обслуживания'"/>
<F NAME="ACOLUMN" VALUE="7"/>
<F NAME="EDITTYPE" VALUE="1"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="9"/>
<F NAME="FNAME" VALUE="'Дата окончания обслуживания'"/>
<F NAME="ACOLUMN" VALUE="8"/>
<F NAME="EDITTYPE" VALUE="1"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="50"/>
<F NAME="FNAME" VALUE="'Дата аннулирования'"/>
<F NAME="ACOLUMN" VALUE="9"/>
<F NAME="EDITTYPE" VALUE="1"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="74"/>
<F NAME="FNAME" VALUE="'Адрес. Адрес регистрации'"/>
<F NAME="ACOLUMN" VALUE="14"/>
<F NAME="EDITTYPE" VALUE="0"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="20"/>
<F NAME="FNAME" VALUE="'Полный адрес. Адрес проживания'"/>
<F NAME="ACOLUMN" VALUE="15"/>
<F NAME="EDITTYPE" VALUE="0"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="14"/>
<F NAME="FNAME" VALUE="'Телефон (моб)'"/>
<F NAME="ACOLUMN" VALUE="16"/>
<F NAME="EDITTYPE" VALUE="0"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="92"/>
<F NAME="FNAME" VALUE="'Email пациента'"/>
<F NAME="ACOLUMN" VALUE="17"/>
<F NAME="EDITTYPE" VALUE="0"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="33"/>
<F NAME="FNAME" VALUE="'Место работы'"/>
<F NAME="ACOLUMN" VALUE="18"/>
<F NAME="EDITTYPE" VALUE="0"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="32"/>
<F NAME="FNAME" VALUE="'Программа прикрепления'"/>
<F NAME="ACOLUMN" VALUE="12"/>
<F NAME="EDITTYPE" VALUE="0"/>
</R>
<R>
<F NAME="SHEMAID" VALUE="990006094"/>
<F NAME="SHTYPEID" VALUE="30"/>
<F NAME="FNAME" VALUE="'№ договора'"/>
<F NAME="ACOLUMN" VALUE="10"/>
<F NAME="EDITTYPE" VALUE="0"/>
</R>
</T>
</EXPORT>

sql