{"notepadname":"SVCL432RFCADMIN\n","content":[{"cellid":"202009041246140670005","type":"text","data":"Bearbeitung der Regelwerke und Strukturen zu SVCLEAR-43.2 - Auswertungen Top-Clearingfälle für Lohnsoftware","attribs":{"cell_cdiv":{"width":"100%","height":"100%"},"dinput":{"width":"80%","height":"100%"}}},{"cellid":"202201051745140930005","type":"sql","data":"/* SVCL432RCA.001 - neues Regelwerk mit Rückfragecodes */\n/* das alte RW ist in der Tabelle SVCLRWRFC */\n/* dort sind aber nicht alle, deshalb hat die Auswertung Beispieltexte aus der Tabelle CCMVBRFAUSW gezogen, was nicht mehr geht, da CCMVBRFAUSW so groß ist */\n/* deshalb hat schon 2019 das CC-MVB eine neue CF-RW-Tabelle in der Version 2.0 bereitgestellt. Die wird nun eingebunden */\nselect * from CCMFILES where MFILETYPE like 'mvbrfcodes'","attribs":{"cell_cdiv":{"width":"1820px","height":"317px"},"dinput":{"width":"1410px","height":"131px"},"rcdiv":{"width":"1554px","height":"139px"}}},{"cellid":"202009041246140710006","type":"text","data":"Das DQUERY repLSWtopCF ermitelt die top-CF-Anzahlen für eine Lohnsoftware. Ab 05.01.2022 wurde diese Auswertung überarbeitet, da die Laufzeit schon bei mehreren Tagen lag.\n","attribs":{"cell_cdiv":{"width":"100%","height":"100%"},"dinput":{"width":"80%","height":"100%"}}},{"cellid":"202009041246140750007","type":"sql","data":"/* SVCL432RCA.001.002 - neue Regelwerks-Tabelle wegen der neuen Form der MVB-Tabelle */\n/* */ -- describe SVCLRWRFC\n/* */ describe SVCLRWRFCM\n/* */ -- create table SVCLRWRFCM(CODE varchar(32), RUECKFRAGETEXT varchar(256), DRINGLICHKEIT varchar(70), VARIABLEFELDER varchar(2048), OBJEKT varchar(70), BEISPIELTEXT varchar(2048))","attribs":{"cell_cdiv":{"width":"1823px","height":"414px"},"dinput":{"width":"1723px","height":"171px"},"rcdiv":{"width":"1538px","height":"215px"}}},{"cellid":"202201051800502350006","type":"query","data":"{\n/* SVCL432RCA.001.003 - neue datei 2.0 in neue Tabelle laden */\ndataname: \"LOADTABLE\",\nmfileid: \"mvbrfcodes_20220105172859801\",\ntablename: \"SVCLRWRFCM\"\n}","attribs":{"cell_cdiv":{"width":"1777px","height":"513px"},"dinput":{"width":"1464px","height":"154px"},"rcdiv":{"width":"1678px","height":"262px"}}},{"cellid":"202201051838153820007","type":"sql","data":"/* SVCL432RCA.002.001 - Auswertungs-Kern-SQL */\nselect LSWID,RUECKFRAGETYPCODE,SUM(RFCOUNT) as ANZAHL_RUECKFRAGEN, rfc.RUECKFRAGETEXT as TEXT_DER_RUECKFRAGE, rfc.BEISPIELTEXT as BEISPIEL_RUECKFRAGETEXT\n\t\t  from TOPCF_TEMP_202201051556058481257 aw\n\t\t  left outer join SVCLRWRFCMX rfc on rfc.CODE = aw.RUECKFRAGETYPCODE\n\t\t where (RUECKFRAGETYPCODE is not null and ((RUECKFRAGETYPCODE!='') and (RUECKFRAGETYPCODE!='MW2022') and (RUECKFRAGETYPCODE!='MW0120')))\n\t\t group by LSWID,RUECKFRAGETYPCODE, TEXT_DER_RUECKFRAGE, BEISPIEL_RUECKFRAGETEXT\n\t\t having ANZAHL_RUECKFRAGEN>10\n\t\t order by ANZAHL_RUECKFRAGEN desc\nlimit 1,200\n/* => auch die RW-Tabelle V 2.0 beinhaltet noch nicht alle Rückfragecodes, die in MVBRFAUSW kommen */","attribs":{"cell_cdiv":{"width":"1817px","height":"939px"},"dinput":{"width":"1505px","height":"237px"},"rcdiv":{"width":"1789px","height":"637px"}}},{"cellid":"202201051857349940009","type":"sql","data":"/* SVCL432RCA.002.002 - eine neue RW-Tabelle SVCLRWRFCMX mit Erweiterung der V 2.0 aus SVCLRWRFCM um Beispieltexte aus CCMVBRFAUSW anlegen */\n-- create temptable_svclear432_rfcnorw as select * from CCMVBRFAUSW aw join SVCLRWRFCM rfc on rfc.RUECKFRAGECODE=aw.RUECKFRAGETYPCODE\n-- select * from CCMVBRFAUSW where rueckfragetypcode!='' limit 1,20\n-- create table temptable_svclear432_rfc as select distinct RUECKFRAGETYPCODE, RUECKFRAGETEXTGESAMTSABE from CCMVBRFAUSW\n-- select * from temptable_svclear432_rfc limit 1,2000\n-- create table temptable_svlcear432_rfcdc as select distinct RUECKFRAGETYPCODE from temptable_svclear432_rfc\n-- create table temptable_svclear432_rfcdc as\n--   select rd.RUECKFRAGETYPCODE,(select rtt.RUECKFRAGETEXTGESAMTSABE from temptable_svclear432_rfc rtt where rtt.RUECKFRAGETYPCODE=rd.RUECKFRAGETYPCODE limit 1) as BEISPIELTEXT from temptable_svlcear432_rfcdc rd \n-- select * from temptable_svclear432_rfcdc \n-- select * from SVCLRWRFCM limit 1,20\n/*\ncreate table SVCLRWRFCMX as \nselect CODE,RUECKFRAGETEXT,DRINGLICHKEIT,VARIABLEFELDER, OBJEKT, BEISPIELTEXT from SVCLRWRFCM\nunion\nselect RUECKFRAGETYPCODE as CODE, BEISPIELTEXT as RUECKFGRAGETEXT, 'unbekannt' as DRINGLICHKEIT, 'unbekannt' as VARIABLEFELDER, 'Alle' as OBJEKT, BEISPIELTEXT as BEISPIELTEXT from temptable_svclear432_rfcdc\n*/\nselect * from SVCLRWRFCMX\n/* danach kann SVCL432RCA.002.001 getestet werden und sollte keine leeren Texte mehr liefern","attribs":{"cell_cdiv":{"width":"1821px","height":"1103px"},"dinput":{"width":"1779px","height":"470px"},"rcdiv":{"width":"1760px","height":"564px"}}}],"attribs":{"width":"1864px","height":"4430px"}}