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, '') "V810_OVK_NAVN",  V117_STILKO, IFNULL(V218_STILKTXT, ''),                                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