<?xml version="1.0" encoding="utf-8"?>
<Entity 
Schema="AKUZ" 
Name="DLO_ACCESSED_POSTS" 
Description="Врачи, имеющие право выписки рецептов по ДЛО" 
PrimaryKey="DloAccessedPostsID" 
DNAttributes="{PostCode};{LastName};{FirstName};{FatherName}" 
DisplayName="{0} {1} {2} {3}">
  <Fields>
    <Attribute Name="DloAccessedPostsID" Index="7110001" Type="guid" Description="Идентификатор" />
    <Attribute Name="PostCode" Index="7110004" Type="string" Description="Код врача с кодом МО" Required="1" />
    <Attribute Name="LastName" Index="7110005" Type="string" Description="Фамилия" CharacterMaximumLength="40" Required="1" />
    <Attribute Name="FirstName" Index="7110006" Type="string" Description="Имя" CharacterMaximumLength="40" Required="1" />
    <Attribute Name="FatherName" Index="7110007" Type="string" Description="Отчество" CharacterMaximumLength="40" />
    <Attribute Name="Category" Index="7110010" Type="int" Description="Категория" />
    <Attribute Name="BeginAccessDate" Index="7110011" Type="datetime" DefaultFormat="{0:dd.MM.yyyy}" Description="Дата начала доступа" />
    <Attribute Name="EndAccessDate" Index="7110012" Type="datetime" DefaultFormat="{0:dd.MM.yyyy}" Description="Дата отмены доступа" />
    <Attribute Name="UpdateInfoDate" Index="7110013" Type="datetime" DefaultFormat="{0:dd.MM.yyyy}" Description="Дата обновления информации по данному врачу" />
    <Attribute Name="BeginWorkDate" Index="7110014" Type="date" Description="Дата приема на работу" Required="1" />
    <Attribute Name="CertificateDate" Index="7110015" Type="date" Description="Дата выдачи сертификата" />
    <Attribute Name="MedicalSpecialityCode" Index="7110016" Type="string" Description="Код мед.специальности" CharacterMaximumLength="16" />
    <Attribute Name="ExpulsionDate" Index="7110018" Type="date" Description="Дата исключения из реестра" />
    <Parent Name="LpuMain" Index="7110003" Type="AKUZ.LPU_MAIN" Description="МО" />
    <Parent Name="Speciality" Index="7110008" Type="AKUZ.SPECIALITY" Description="Специальность" />
    <Parent Name="PostType" Index="7110009" Type="AKUZ.POST_TYPE" Description="Тип должности" />
    <Attribute Name="Snils" Type="string" Description="СНИЛС" CharacterMaximumLength="14" />
    <Parent Name="EhrRus7pjsam6gjm" Type="EHR.EHR_RUS_7PJSAM6GJM" Description="Должности работников организаций медицинского и фармацевтического профиля" />
    <Parent Name="EhrRusLs9r0q4vr4" Type="EHR.EHR_RUS_LS9R0Q4VR4" Description="Номенклатура специальностей медработников с высшим и средним образованием " />
  </Fields>
  <DbMapping>
    <Table name="T_DLO_ACCESSED_POSTS">
      <Map Name="DloAccessedPostsID" Column="DloAccessedPostsID" />
      <Map Name="PostCode" Column="PostCode" />
      <Map Name="LastName" Column="LastName" />
      <Map Name="FirstName" Column="FirstName" />
      <Map Name="FatherName" Column="FatherName" />
      <Map Name="Category" Column="Category" />
      <Map Name="BeginAccessDate" Column="BeginAccessDate" />
      <Map Name="EndAccessDate" Column="EndAccessDate" />
      <Map Name="UpdateInfoDate" Column="UpdateInfoDate" />
      <Map Name="BeginWorkDate" Column="BeginWorkDate" />
      <Map Name="CertificateDate" Column="CertificateDate" />
      <Map Name="MedicalSpecialityCode" Column="MedicalSpecialityCode" />
      <Map Name="ExpulsionDate" Column="ExpulsionDate" />
      <Map Name="LpuMain" Column="LpuMain" />
      <Map Name="Speciality" Column="Speciality" />
      <Map Name="PostType" Column="PostType" />
      <Map Name="Snils" Column="Snils" />
      <Map Name="EhrRus7pjsam6gjm" Column="EhrRus7pjsam6gjm" />
      <Map Name="EhrRusLs9r0q4vr4" Column="EhrRusLs9r0q4vr4" />
    </Table>
  </DbMapping>
</Entity>