tellingen IMJ database

BESCHIKKINGEN TELLEN
   -->tel Beschikkingen PGB vanuit WMONED;
   select   count(DISTINCT ZRM_FCT_BESCHIKKING_DAG_ARCH.fct_dim_beschikking_key) from ZRM_FCT_BESCHIKKING_DAG_ARCH where fct_datum_archief='02-05-2016'
   and FCT_PEILDATUM >='01-01-2016' and fct_peildatum< '01-05-2016'
   and fct_dim_leveringsvorm_key=2; 
  
  -->  tel Beschikkingen PGB vanuit WMONED met datum_beschikking erbij gejoined  alles van 2016

   select count( distinct a.fct_dim_beschikking_key) from ZRM_FCT_BESCHIKKING_DAG_ARCH a inner join zrm_dim_beschikking b on a.fct_dim_beschikking_key=b.bes_dim_beschikking_key
   where a.fct_datum_archief='02-05-2016' and a.FCT_PEILDATUM >='01-01-2016' and a.fct_peildatum< '01-05-2016'
   --pgb
   and a.fct_dim_leveringsvorm_key=2
   --
   and b.bes_datum_geldig_van >= '01-01-2016';
   --> 103
  
  
   -->  tel Beschikkingen ZIN vanuit WMONED met datum_beschikking erbij gejoined  alles van 2016
  
   select count( distinct a.fct_dim_beschikking_key) from ZRM_FCT_BESCHIKKING_DAG_ARCH a inner join zrm_dim_beschikking b on a.fct_dim_beschikking_key=b.bes_dim_beschikking_key
   where a.fct_datum_archief='02-05-2016' and a.FCT_PEILDATUM >='01-01-2016' and a.fct_peildatum< '01-05-2016'
   --pgb
   and a.fct_dim_leveringsvorm_key=1
   --
   and b.bes_datum_geldig_van >= '01-01-2016';
  

  
  
  
  
>>>>>   VOORZIENINGEN
   ZIN 2016
   select count( distinct a.FCT_VOORZIENINGSNUMMER) from ZRM_FCT_BESCHIKKING_DAG_ARCH a inner join zrm_dim_beschikking b on a.fct_dim_beschikking_key=b.bes_dim_beschikking_key
   where a.fct_datum_archief='02-05-2016' and a.FCT_PEILDATUM >='01-01-2016' and a.fct_peildatum< '01-05-2016'
   --pgb
   and a.fct_dim_leveringsvorm_key=1
   --
   and b.bes_datum_geldig_van >= '01-01-2016';
   --> 5266
  
   PGB2016
      select count( distinct a.FCT_VOORZIENINGSNUMMER) from ZRM_FCT_BESCHIKKING_DAG_ARCH a inner join zrm_dim_beschikking b on a.fct_dim_beschikking_key=b.bes_dim_beschikking_key
   where a.fct_datum_archief='02-05-2016' and a.FCT_PEILDATUM >='01-01-2016' and a.fct_peildatum< '01-05-2016'
   --pgb
   and a.fct_dim_leveringsvorm_key=2
   --
   and b.bes_datum_geldig_van >= '01-01-2016';
  
  
  
  
   HERKOMST PGB BESCHIKKINGEN  2016
   
   select count( distinct a.fct_dim_beschikking_key),c.hrk_herkomst_cd from
   ZRM_FCT_BESCHIKKING_DAG_ARCH a
    inner join zrm_dim_beschikking b
        on (a.fct_dim_beschikking_key=b.bes_dim_beschikking_key)
        left outer JOIN ZRM_DIM_HERKOMST c
        on ( c.hrk_dim_herkomst_key = a.FCT_DIM_HERKOMST_KEY)
   where a.fct_datum_archief='02-05-2016' and a.FCT_PEILDATUM >='01-01-2016' and a.fct_peildatum< '01-05-2016'
   --pgb
   and a.fct_dim_leveringsvorm_key=2
   --
   and b.bes_datum_geldig_van >= '01-01-2016' group by c.hrk_herkomst_cd;
  
    HERKOMST PGB voorzieniningen 2016
   
   select count( distinct a.FCT_VOORZIENINGSNUMMER),c.hrk_herkomst_cd from
   ZRM_FCT_BESCHIKKING_DAG_ARCH a
    inner join zrm_dim_beschikking b
        on (a.fct_dim_beschikking_key=b.bes_dim_beschikking_key)
        left outer JOIN ZRM_DIM_HERKOMST c
        on ( c.hrk_dim_herkomst_key = a.FCT_DIM_HERKOMST_KEY)
   where a.fct_datum_archief='02-05-2016' and a.FCT_PEILDATUM >='01-01-2016' and a.fct_peildatum< '01-05-2016'
   --pgb
   and a.fct_dim_leveringsvorm_key=2
   --
   and b.bes_datum_geldig_van >= '01-01-2016' group by c.hrk_herkomst_cd;
  
   HERKOMST ZIN voorzieniningen 2016
   
   select count( distinct a.FCT_VOORZIENINGSNUMMER),c.hrk_herkomst_cd from
   ZRM_FCT_BESCHIKKING_DAG_ARCH a
    inner join zrm_dim_beschikking b
        on (a.fct_dim_beschikking_key=b.bes_dim_beschikking_key)
        left outer JOIN ZRM_DIM_HERKOMST c
        on ( c.hrk_dim_herkomst_key = a.FCT_DIM_HERKOMST_KEY)
   where a.fct_datum_archief='02-05-2016' and a.FCT_PEILDATUM >='01-01-2016' and a.fct_peildatum< '01-05-2016'
   --pgb
   and a.fct_dim_leveringsvorm_key=1
   --
   and b.bes_datum_geldig_van >= '01-01-2016' group by c.hrk_herkomst_cd;
  
  
  
  
  
  
  
   tellingen okt voor OKT export guido pgb
       select count(distinct a.fct_dim_beschikking_key) from ZRM_FCT_BESCHIKKING_DAG_ARCH a
    inner join zrm_dim_beschikking b on a.fct_dim_beschikking_key=b.bes_dim_beschikking_key
    INNER JOIN ZRM_DIM_TEAM c ON (c.TEA_DIM_TEAM_KEY=a.FCT_DIM_TEAM_KEY)
   where a.fct_datum_archief='02-05-2016' and a.FCT_PEILDATUM >='01-01-2016' and a.fct_peildatum< '01-05-2016'
   --pgb
   and a.fct_dim_leveringsvorm_key=2
   --
   and b.bes_datum_geldig_van >= '01-01-2016'
   and
    replace(c.TEA_TEAM_OMS,', .', '')  LIKE  'OKT%';