<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Title" content="">
<meta name="Keywords" content="">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.msoIns
{mso-style-type:export-only;
mso-style-name:"";
text-decoration:underline;
color:teal;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:595.0pt 842.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body bgcolor="white" lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt">Dag Kris, <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt">Als ik volgende query uitvoer in het IMJV zie ik nog 3576 aangifties die nog niet in DMS zitten.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">select count(*) from admin_aangifte where archivering_dms is false;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt">Als ik dit vergelijk met volgende query (die aangeeft in welke status de IMJV’s zitten) kom ik op het zelfde aantal die enkel VERS (verstuurd) zijn. Er zijn er echter wel 38206 in status ONTV
(ontvangen). <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt">select status_code_aangifte, count(*) from admin_aangifte group by status_code_aangifte;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt">Vraag is een beetje of dit normaal is.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt">Ik ga dit alleszinds ook eens bekijken voor vorige IMJV jaren.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt">Mvg<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt">Christophe<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="NL-BE" style="font-size:11.0pt"><o:p> </o:p></span></p>
</div>
</body>
</html>