{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"DOMENU","type":"character","width":20},{"name":"NADPIS","type":"character","width":40},{"name":"DATUM","type":"logical","width":1},{"name":"CAS","type":"logical","width":1},{"name":"DETAIL1","type":"number","width":3,"decimals":0},{"name":"DETAIL2","type":"number","width":3,"decimals":0},{"name":"DETAIL3","type":"number","width":3,"decimals":0},{"name":"DETAIL4","type":"number","width":3,"decimals":0},{"name":"DETAIL5","type":"number","width":3,"decimals":0},{"name":"DETAIL6","type":"number","width":3,"decimals":0},{"name":"DETAIL7","type":"number","width":3,"decimals":0},{"name":"DETAIL8","type":"number","width":3,"decimals":0},{"name":"DETAIL9","type":"number","width":3,"decimals":0},{"name":"DETAIL10","type":"number","width":3,"decimals":0},{"name":"DETAIL11","type":"number","width":3,"decimals":0},{"name":"DETAIL12","type":"number","width":3,"decimals":0},{"name":"FILTR","type":"character","width":160},{"name":"HLAVNI","type":"character","width":12},{"name":"IDX","type":"character","width":10},{"name":"VSICHNI","type":"logical","width":1},{"name":"KLIC_SEST","type":"character","width":10}],"n_rows":35,"rows_kept":35,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"dbase_level_three","encoding_class":"enc_other","reader":"statdb_count/9"}
["1.Abecední seznam","Seznam zamêstnancû dle abecedy",true,true,6,1,2,3,154,22,0,0,0,0,0,0,"!inlist(kmen.pracp,0,12,13,14) and !inlist(kmen.vyjzes,1,5)","KMEN","PRIJ",false,"_RAB0LJ9WV"]
["2.Æivotní jubilea","Æivotní jubilea 50,55,60,65,70",true,true,6,1,2,3,154,22,0,0,0,0,0,0,"inlist(val(m.r)-val(left(kmen.rc1,2)),50,55,60,65,70)","KMEN","OC",false,"_RAB0LJ9WX"]
["3.Pracovní vÿroçí","Pracovní vÿroçí u a.s.",true,true,1,2,3,6,15,70,22,0,0,0,0,0,"inlist(val(m.r)-val(substr(dtos(kmen.datvp),3,2)),20,25,30,35,40,45,50)","KMEN",null,false,"_RAB0LJ9WZ"]
["4.Mladiství","Mladí zamêstnanci do 18 let vêku",true,true,6,1,2,3,154,15,22,0,0,0,0,0,"val(m.r)-val(left(kmen.rc1,2))<=18 and kmen.kat<>5","KMEN","OC",false,"_RAB0LJ9X1"]
["5.Dêti do 15 let","Dêti do 15 let",true,true,6,2,3,139,138,140,0,0,0,0,0,0,"val(substr(dtos(date()),3,2))-val(left(deti.rcd,2))<16","KMEN",null,false,"_RAB0LJ9X5"]
["6.Æeny na mat.dov.","Æeny na mate®ské dovolené",true,true,6,1,2,3,24,25,0,0,0,0,0,0,"kmen.vyjzes=5 and kmen.datup={}","KMEN","OC",false,"_RAB0LJ9X7"]
["7.Muæi na ZVS","Muæi na ZVS",true,true,6,1,2,3,24,25,0,0,0,0,0,0,"kmen.vyjzes=1","KMEN","OC",false,"_RAB0LJ9X9"]
["8.Z P S","Zamêstnanci se zmênênou pracovní schopn.",true,true,6,1,2,3,42,0,22,0,0,0,0,0,"kmen.invalida1 or kmen.invalida2 or kmen.invalida3 or left(kmen.poznamka,3)=='ZPS'","KMEN","OC",false,"_RAB0LJ9XB"]
["9.Prac.dûchodci","Pracující dûchodci",true,true,6,1,2,3,42,154,22,0,0,0,0,0,"kmen.dd=3 and !inlist (kmen.pracp,12,14)","KMEN",null,false,"_RAB0LJ9XD"]
["10.Typ pracovní doby","Seznam zamêst. dle typu pracovní doby",true,true,6,1,2,3,14,0,0,0,0,0,0,0,"kmen.kat<>5 and !inlist(kmen.pracp,0,12,14) and !inlist(kmen.vyjzes,5,1)","KMEN",null,false,"_RAB0LJ9XF"]
["11.Zkrácenÿ úvazek","Pracovníci se zkrácenÿm úvazkem",true,true,6,1,2,3,16,15,0,0,0,0,0,0,"kmen.uvaz<40 and kmen.kat<>5 and !inlist(kmen.pracp,12,14)","KMEN",null,false,"_RAB0LJ9XH"]
["12.Prac na dobu urç.","Pracovníci na dobu urçitou",true,true,1,2,3,6,15,16,22,23,0,0,0,0,"!empty(kmen.datup) and inlist(kmen.pracp,2,4,6) or inlist(kmen.pracp,2,4,6) and","KMEN",null,false,"_RAB0LJ9XJ"]
["13.Narozeniny","Narozeniny",true,true,154,2,3,6,0,0,0,0,0,0,0,0,"(substr(kmen.rc1,3,2)=substr(dtos(date()),5,2) or val(substr(kmen.rc1,3,2))-50=val(substr(dtos(date()),5,2))) and !inlist(kmen.pracp,13,14) and kmen.kat<>5","KMEN",null,false,"_RAB0LJ9XN"]
["14.Uçni","Uçni",true,true,1,2,3,77,0,0,0,0,0,0,0,0,"kmen.kat=5","KMEN","OC",false,"_RAB0LJ9XP"]
["15.VPP-cizí","VPP-cizí",true,true,1,2,3,6,15,22,23,0,0,0,0,0,"inlist(kmen.pracp,3,4)","KMEN",null,false,"_RAB0LJ9XR"]
["16.VPP-vlastní","VPP vlastní",true,true,1,2,3,6,15,22,0,0,0,0,0,0,"inlist(kmen.pracp,5,6)","KMEN",null,false,"_RAB0LJ9XT"]
["17.Kategorie","Pracovníci dle çinnosti v mêsíci",true,true,6,1,2,3,15,70,0,0,0,0,0,0,"!inlist(kmen.pracp,0,12,13,14) and !inlist(kmen.vyjzes,1,5)","KMEN",null,false,"_RAB0LJ9XV"]
["18.Bydli¿tê","Seznam zamêstnancû - bydli¿tê",true,true,6,1,2,3,11,12,13,0,0,0,0,0,"!inlist(kmen.pracp,0,12,13,14) and !inlist(kmen.vyjzes,1,5)","KMEN",null,false,"_RAB0LJ9Z4"]
["19a.Muæi v prod.vêku","Muæi v produktiv.vêku",false,false,2,3,8,9,12,11,70,0,0,0,0,0,"Kmen.duch_vek>date() and inlist(subst(kmen.rc1,3,1),\"0\",\"1\")","KMEN",null,false,"_RAM0J1EH8"]
["19b.Produkt.vêk","Muæi a æeny v produktivním vêku",true,true,1,2,3,6,285,0,0,0,0,0,0,0,"kmen.duch_vek>date()","KMEN",null,true,"_RAM0J1EHK"]
["19c.P®edstih.®ízení","P®edstihové ®ízení",true,true,6,1,2,3,286,154,0,0,0,0,0,0,"kmen.duch_vek<date()+1080 and !inlist(kmen.dd,3,7)","KMEN",null,false,"_RAB0LJ9Z6"]
["20.P®ekroçení dvojn.","P®ekroçení dvojnásobku",true,false,1,2,3,8,9,285,875,0,0,0,0,0,"kmen.dd=3 and mzdy.khm>5320 and between(DatKonM,kmen.duch_vek,GoMonth(kmen.duch_vek,24))","KMEN",null,false,"_RA70HLBX9"]
["21.Vÿpis pracovníkû","Pracovníci dle kategorií v mêsíci",true,true,1,2,3,6,15,26,0,0,0,0,0,0,null,"KMEN",null,false,"_RAM0J1EHS"]
["22.Vzdelani-SO","Vzdelani SO",true,true,6,1,2,3,78,0,0,0,0,0,0,0,"Left(kmen.vzdelani,2)=='SO'","KMEN",null,false,"_RAB0LJ9ZA"]
["23.Vzdêlání-vyuçení","Vzdêlání-vyuçení",true,true,6,1,2,3,78,0,0,0,0,0,0,0,"Left(kmen.vzdelani,6)=='vyuçen'and !inlist(kmen.pracp,0,12,13,14) and !inlist(kmen.vyjzes,1,5)","KMEN",null,false,"_RAB0LJ9ZC"]
["24.Vzdêlání základní","Vzdêlání základní",true,true,6,1,2,3,78,0,0,0,0,0,0,0,"Left(kmen.vzdelani,8)=='základní' and !inlist(kmen.pracp,0,12,13,14) and !inlist(kmen.vyjzes,1,5)","KMEN","PRIJ",false,"_RAB0LJ9ZE"]
["25.Kval.sloæení Vø","Kvalifikaçní sloæení pracovníkû Vø",true,true,1,2,3,6,78,0,0,0,0,0,0,0,"left(kmen.vzdelani,2)=='Vø'","KMEN",null,false,"_RAB0LJ9Z8"]
["26. 3 roky vêku","25. 3 roky vêku",true,false,1,2,3,47,138,140,0,0,0,0,0,0,"(kmen.vyjzes=5) and (val(left(deti.rcd,2))+3=96)","DETI",null,false,"_RAM0J1EHZ"]
["27.P®íplatky","P®íplatky",true,true,809,810,1,2,6,0,0,0,0,0,0,0,null,"KMEN",null,false,"_RAB0LJ9ZO"]
["28.Dojíædêjící zam.","Dojíædêjící zamêstnanci",true,false,1,2,3,6,12,0,0,0,0,0,0,0,"left(alltrim(upper(kmen.mesto)),17)#upper(alltrim(i_sidlo2))","KMEN","OC",true,"_RAM0J1EI4"]
["28.Prûmêry","Prûmêry",true,false,6,1,2,3,43,45,46,0,0,0,0,0,null,"KMEN",null,false,"_RAB0R38LI"]
["90.Nástupy neurçité","Nástupy pracovníkû na dobu neurçitou",true,true,1,2,3,6,15,22,0,0,0,0,0,0,"betw(kmen.datvp,ctod('01.'+m.m+'.'+m.r),ctod('15.'+m.m+'.'+m.r)) and !inlist(kmen.pracp,2,4,6) and empty(kmen.datup)","KMEN",null,false,"_RAB0LJ9ZG"]
["91.Nástupy urçité","Nástupy pracovníkû na dobu urçitou",true,true,1,2,3,6,22,23,70,0,0,0,0,0,"betw(kmen.datvp,ctod('01.'+m.m+'.'+m.r),ctod('05.'+m.m+'.'+m.r)) and inlist(kmen.pracp,2,4,6)","KMEN",null,false,"_RAB0LJ9ZI"]
["92.Ukonçení","Ukonçení prac. pomêru",true,true,1,2,3,6,70,23,0,0,0,0,0,0,"betw(kmen.datup,ctod('01.'+m.m+'.'+m.r),ctod('31.'+m.m+'.'+m.r))","KMEN",null,false,"_RAB0LJ9ZK"]
["93.Nástupy a vÿstupy","Nástupy a vÿstupy",true,true,6,1,2,3,77,22,23,0,0,0,0,0,null,"KMEN",null,false,"_RAB0LJ9ZM"]