Editing AQT

Download AQT software from Software Center (If AQT is not found in Software Center, contact IT support: support.eg.dk).

Use same username and password (max 8 sign) as the "Hosten" (de hvide sider).

Follow the AQT config guide:

SQL scripts:

See Onedrive

Task (SDP-53557):

We like to request extract from Fredensborg with top inst.: '''9U''' and inst.: '''EA''' with the following information:

* Work agreement (Overenskomst)
* Salary grade (lønklasse)
* Position (stilling)

And only from units that are using Optima.

Sebastian Pawski save all he's SQL scripts here: \\egdk.it-corp.net\DFS-Division$\DIV_700\BUS_765\Data\SD\71 Payroll\Tid - KONS\Projekter\Optima\Miljøopsætning\1.1 Prod Done\

SQL call:

--aqt queryparm, parm=tinst, desc=Top Inst, value=9U, parm=inst, desc=Inst, value=EA, parm=base, desc=Base,select=(db2p.lprod, lg, lupd), value=db2p.lprod

WITH
 instlist (inst, stilkoinst, orgid) as (select v127_inst, v127_stilkoinst, v127_orgid
                                      from   $base.syv1271
                                      where  v127_inst = '$inst' 
                                      and    v127_amtinst = '$tinst'
                                      )
SELECT instlist.inst "INST", V106_OVK, IFNULL(V810_OVK_NAVN, <nowiki>''</nowiki>) "V810_OVK_NAVN",  V117_STILKO, IFNULL(V218_STILKTXT, <nowiki>''</nowiki>), 
                              V106_LK
              FROM $base.SYV1511 A
              JOIN instlist 
                ON A.V151_INST = instlist.inst
              JOIN $base.SYV1071 B 
                ON B.V107_INST = A.V151_INST 
               AND B.V107_TJNR = A.V151_TJNR  
              JOIN $base.SYV1411 E 
                ON E.V141_INST = A.V151_INST 
               AND E.V141_TJNR = A.V151_TJNR 
               AND E.V141_SLTDATO >= '2018-01-01'  
              AND  E.V141_STKO IN ('1', '3', '0', '4')
              JOIN $base.SYV1061 O 
                ON O.V106_INST = A.V151_INST 
               AND O.V106_TJNR = A.V151_TJNR 
               AND O.V106_SLTDATO >= '2018-01-01'  
              JOIN $base.SYV1171 S 
                ON S.V117_INST = A.V151_INST 
               AND S.V117_TJNR = A.V151_TJNR 
               AND S.V117_SLTDATO >= '2018-01-01'  
              JOIN $base.SYV6111 
                ON V611_ORGID_EJER = instlist.orgid
               AND CURRENT DATE BETWEEN V611_STRDATO AND V611_SLTDATO 
               AND V611_NIVID = 1
               AND V611_ORGKODE = V107_AFD
              JOIN $base.SYV6371 
                ON V637_ORGID = V611_ORGID
               AND V637_AP_TJTID_MRK = 'O'
               AND V141_SLTDATO >= V637_STRDATO 
               AND V141_STRDATO <= V637_SLTDATO
              LEFT OUTER JOIN $base.SYV8101
                ON V810_OVK = V106_OVK
              LEFT OUTER JOIN $base.SYV2181
                ON V218_INST = instlist.stilkoinst
                and V218_STILKOD = V117_STILKO
GROUP by "INST", V106_OVK, V810_OVK_NAVN, V117_STILKO, V218_STILKTXT, V106_LK