Dynamický dotaz - Mzdy - Mzdový list (po obdobích)

ID:
MB0IUGNDXQM4PDDJCTPPXTK4LO

Datasety

MAIN

Popis:
Pracovní poměr
SQL definice:
SELECT {FIELDS}
FROM WorkingRelations A
{JOIN}
{WHERE}
{ORDERBY}
Aliasy:
Alias CLSID objektu Prefix Popis
A RFW3EQ50IEVOF2F5F33OWL1GXC
EMP CPP5AZU1CVF13JXS00KEZYD5AW EMP Zaměstnanec
PER WEC02QYERNCL35CH000ILPWJF4 PER Osoba
PAT 4TLNCJ4XS3BOBHD4SQGQQFIHHK EP Druh pracovního poměru
Fields:
Jméno Typ Velikost Výraz CLSID Popis
NumPersonalNumber dtInteger 10 
ib_convchartoint(PER.PersonalNumber)
 Osobní číslo numericky

WAGELISTPARTIAL

Popis:
Mzdový list díčí
SQL definice:
SELECT {FIELDS}
FROM WagelistPartial A
{JOIN}
WHERE A.WorkingRelation_ID = :ID
{ANDWHERE}
ORDER BY WP.DateFrom$DATE
Aliasy:
Alias CLSID objektu Prefix Popis
A W1ZICXOZCBF13JXS00KEZYD5AW Mzdový list dílčí
EMP CPP5AZU1CVF13JXS00KEZYD5AW EMP Zaměstnanec
WLC G2POM1Q3C3F13JXS00KEZYD5AW WLC Mzdový list souhrnný
WP QUCSC0QN3JF13FG501C0C2VN0K WP Mzdové období
WR RFW3EQ50IEVOF2F5F33OWL1GXC WR Pracovní poměr

WAGELISTCOMMON

Popis:
Mzdový list společný
SQL definice:
SELECT {FIELDS}
FROM WageListCommon A
{JOIN}
WHERE A.EMPLOYEE_ID = :EMP_ID
{ANDWHERE}
ORDER BY WP.DateFrom$DATE
Aliasy:
Alias CLSID objektu Prefix Popis
A G2POM1Q3C3F13JXS00KEZYD5AW Mzdový list souhrnný
WP QUCSC0QN3JF13FG501C0C2VN0K WP Mzdové období
Fields:
Jméno Typ Velikost Výraz CLSID Popis
WLC_DateTo dtFloat 10 
WP.DateTo$DATE
 Datum ukončení MLS (Datum do)
WLC_EmployeeID dtString 10 
A.EMPLOYEE_ID
 ID zaměstnance z MLS

FAMILYMEMBERS

Popis:
Rodinní příslušníci
SQL definice:
SELECT {FIELDS}
FROM FAMILYMEMBERS A
{JOIN}
WHERE A.Parent_ID = :EMPLOYEE_ID
{ANDWHERE}
{ORDERBY}
Aliasy:
Alias CLSID objektu Prefix Popis
A YJ0OWQFW31YOFC542RPMTF23Q0 Rodinný příslušník
WP QUCSC0QN3JF13FG501C0C2VN0K WP Mzdové období

COUNTOFFDEFINITIONS

Popis:
Definice odpočtů
SQL definice:
SELECT {FIELDS}
FROM CountOffDefinitions A
WHERE A.Parent_ID = :EMPLOYEE_ID
{ANDWHERE}
Aliasy:
Alias CLSID objektu Prefix Popis
A 0SJ50I1FTIY4BAQ3UX02NLBLCK Definice odpočtu

WRCOUNTSFOREMPLOYEE

Popis:
Počty PP za zaměstnance
SQL definice:
SELECT {FIELDS}
FROM WorkingRelations A
JOIN Employees EMP ON A.Employee_ID = EMP.ID
JOIN Persons PER ON EMP.Person_ID = PER.ID
JOIN EmployPatterns PAT ON PAT.ID = A.EmployPattern_ID
WHERE Employee_ID=:EMPLOYEE_ID
{ANDWHERE}
{ORDERBY}
GROUP BY Employee_ID
Fields:
Jméno Typ Velikost Výraz CLSID Popis
Employee_ID dtString 10 
A.Employee_ID
 CPP5AZU1CVF13JXS00KEZYD5AW ID zaměstnance
WRCount dtInteger 10 
COUNT(A.ID)
 Počet PP k zaměstnanci

MAINALL

Popis:
Pracovní poměr - všechny za zaměstnance
SQL definice:
SELECT {FIELDS}
FROM WorkingRelations A
{JOIN}
WHERE A.Employee_ID = :EMP_ID
{ANDWHERE}
{ORDERBY}
Aliasy:
Alias CLSID objektu Prefix Popis
A RFW3EQ50IEVOF2F5F33OWL1GXC
EMP CPP5AZU1CVF13JXS00KEZYD5AW EMP Zaměstnanec
PER WEC02QYERNCL35CH000ILPWJF4 PER Osoba
PAT 4TLNCJ4XS3BOBHD4SQGQQFIHHK EP Druh pracovního poměru
Fields:
Jméno Typ Velikost Výraz CLSID Popis
NumPersonalNumber dtInteger 10 
ib_convchartoint(PER.PersonalNumber)
 Osobní číslo numericky

SickBenefits

Popis:
Nemocenské dávky - všechny za zaměstnance
SQL definice:
SELECT {FIELDS} 
FROM
  SickBenefits A
WHERE A.WorkingRelation_ID = :ID
{ANDWHERE}
ORDER BY A.DateFrom$DATE
Aliasy:
Alias CLSID objektu Prefix Popis
A WGY0I0KF1NEL3JB401C0C2VN0K Nemocenské dávky

SickBenefitsRows

Popis:
Nemocenské dávky - řádky
SQL definice:
SELECT {FIELDS} 
FROM
  SickBenefits2 A
{JOIN}
WHERE A.Parent_ID = :ID
{ANDWHERE}
ORDER BY WP.DateFrom$DATE
Aliasy:
Alias CLSID objektu Prefix Popis
A 0RR0MBBO1FYOLJVJKJEJY5AWBK Nemocenské dávky - řádky
WP QUCSC0QN3JF13FG501C0C2VN0K WP Mzdové období

AnnualClearingsForWLC

Popis:
Roční zúčtování pro daný mzdový list
SQL definice:
SELECT {FIELDS}
FROM AnnualClearings A
WHERE (A.Transferred_ID=:ID) OR
((A.DateOfClosing$DATE = :WLC_DateTo) AND
(A.EMPLOYEE_ID = :WLC_EmployeeID))
Aliasy:
Alias CLSID objektu Prefix Popis
A NRGKP3OPYD0OPEDC1UPCRTTDMC
Fields:
Jméno Typ Velikost Výraz CLSID Popis
ChildrenTaxAdvantage dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 1) and

  (COT.TaxAdvantage = 'A')

)
 Slevy na dítě (Daňový bonus)
PaidInterest dtFloat 10 
(select sum(ACCOffs.Amount + ACCOffs.Correction)

from

  AnnualClearingCountOffs ACCOffs, AnnualClearingRows ACR, CountOffTypes COT

where

  (A.ID = ACR.Parent_ID) and

  (ACR.ID = ACCOffs.Parent_ID) and

  (ACCOffs.CountOffType_ID = COT.ID) and

  (COT.CountOffKind = 12) and

  (COT.TaxAdvantage = 'A')

)
 Zaplacené úroky (Daňový bonus)

Podmínky

RecordStatus

Popiska:
Evidenční stav
Typ/Subtyp:
ctSpecial/1
ckSingle:
##CASEOR {:VALUE} #
##1#(A.RecordedStatus = 'A' AND
     NOT 'A' IN (SELECT AB.NOEVIDENCESTATE FROM Absences AB
              WHERE AB.WorkingRelation_ID = A.ID AND
              AB.AbsentFrom$DATE <= {$HistoryDate} AND
             ((AB.AbsentTo$DATE = 0) OR (AB.AbsentTo$DATE >= {$HistoryDate}))))
##2#(A.RecordedStatus = 'N' OR
      'A' IN (SELECT AB.NOEVIDENCESTATE FROM Absences AB
              WHERE AB.WorkingRelation_ID = A.ID AND
              AB.AbsentFrom$DATE <= {$HistoryDate} AND
             ((AB.AbsentTo$DATE = 0) OR (AB.AbsentTo$DATE >= {$HistoryDate}))))
##3#(A.CalcWage = 'A' AND NOT 'A' IN (SELECT AB.NOCALCULATION FROM Absences AB
              WHERE AB.WorkingRelation_ID = A.ID AND
              AB.NOCALCULATION='A' AND
              AB.AbsentFrom$DATE <= {$HistoryDate} AND
             ((AB.AbsentTo$DATE = 0) OR (AB.AbsentTo$DATE >= {$HistoryDate}))))
##4#(A.CalcWage = 'N' OR
     'A' IN (SELECT AB.NOCALCULATION FROM Absences AB
              WHERE AB.WorkingRelation_ID = A.ID AND
              AB.NOCALCULATION='A' AND
              AB.AbsentFrom$DATE <= {$HistoryDate} AND
             ((AB.AbsentTo$DATE = 0) OR (AB.AbsentTo$DATE >= {$HistoryDate}))))
##5#(0=0)
##END#
Dataset:
MAIN
Speciální parametry:
Names=V evidenčním stavu;Mimo evidenční stav;Zaměstnanci pobírající mzdu;Zaměstnanci nepobírající mzdu;Bez omezení
Values=1;2;3;4;5

ID

Šablona:
ID
Dataset:
MAIN
Speciální parametry:
CLASSID=W1ZICXOZCBF13JXS00KEZYD5AW

WagePeriod_ID

Šablona:
WagePeriod_ID
Dataset:
WAGELISTPARTIAL
Speciální parametry:

WagePeriod_ID2

Popiska:
Mzdové období
Typ/Subtyp:
ctSpecial/16
ckList:
A.ID in (SELECT X.WorkingRelation_ID FROM WagelistPartial X WHERE X.WorkingRelation_ID = A.ID AND X.WagePeriod_ID IN ({:LIST}))
ckSingle:
A.ID in (SELECT X.WorkingRelation_ID FROM WagelistPartial X WHERE X.WorkingRelation_ID = A.ID AND X.WagePeriod_ID = {:VALUE})
Dataset:
MAIN
Speciální parametry:
CLASSID=C4V2JMR03JF13FG501C0C2VN0K
TextField=Code
Hidden=True
AssignedFrom=WagePeriod_ID

WagePeriod_ID4

Šablona:
WagePeriod_ID
Dataset:
WAGELISTCOMMON
Speciální parametry:
Hidden=True
AssignedFrom=WagePeriod_ID

WagePeriod_ID3

Popiska:
Mzdové období
Typ/Subtyp:
ctSpecial/16
ckSingle:
X.WagePeriod_ID = {:VALUE}
ckList:
X.WagePeriod_ID IN ({:LIST})
Dataset:
WRCOUNTSFOREMPLOYEE
Speciální parametry:
CLASSID=C4V2JMR03JF13FG501C0C2VN0K
TextField=Code
Hidden=True
AssignedFrom=WagePeriod_ID
ReplacementLink=True
AlwaysList=True
{$WagePeriodsSelID}=SELECTIONID;''

WagePeriod_ID5

Popiska:
Mzdové období
Typ/Subtyp:
ctSpecial/16
ckSingle:
X.WagePeriod_ID = {:VALUE}
ckList:
X.WagePeriod_ID IN ({:LIST})
Dataset:
MAIN
Speciální parametry:
CLASSID=C4V2JMR03JF13FG501C0C2VN0K
TextField=Code
Hidden=True
AssignedFrom=WagePeriod_ID
ReplacementLink=True
AlwaysList=True
{$WagePeriodsSelID}=SELECTIONID;''

WagePeriod_ID6

Popiska:
Mzdové období
Typ/Subtyp:
ctSpecial/16
ckSingle:
A.ID in (SELECT X.WorkingRelation_ID FROM WagelistPartial X WHERE X.WorkingRelation_ID = A.ID AND X.WagePeriod_ID = {:VALUE})
ckList:
A.ID in (SELECT X.WorkingRelation_ID FROM WagelistPartial X WHERE X.WorkingRelation_ID = A.ID AND X.WagePeriod_ID IN ({:LIST}))
Dataset:
WRCOUNTSFOREMPLOYEE
Speciální parametry:
CLASSID=C4V2JMR03JF13FG501C0C2VN0K
TextField=Code
Hidden=True
AssignedFrom=WagePeriod_ID

Employee_ID

Šablona:
Employee_ID
Dataset:
MAIN

WorkingRelation_ID

Popiska:
Pracovní poměr
Typ/Subtyp:
ctSpecial/0
ckList:
A.ID IN ({:LIST})
ckSingle:
A.ID = {:VALUE}
Dataset:
MAIN
Speciální parametry:
CLASSID=USTGJ04DFYFORHLKG0BFOD2VUK
TextField=ShortName

SuperiorWR_ID

Šablona:
SuperiorWR_ID
Dataset:
MAIN

Division_ID

Popiska:
Středisko
Typ/Subtyp:
ctSpecial/8
ckList:
/* Omezeni za strediska s moznosti vsech podrizenych krome skrytych */
(
  /* timhle omezime vsechny prime nadrizene */
  ((SELECT XX.SID FROM StringValueOfDivisionForWR(WR.ID, WP.DateFrom$DATE) XX) in (select Bx.ID from Divisions Bx where Bx.ID in ({:LIST}) and Bx.Hidden = 'N'))
  or
  /* a jestli mame omezeit za podrizene tak to udelame takhle */
  ({WithChildren} = 1 AND
    (
    (SELECT XX.SID FROM StringValueOfDivisionForWR(WR.ID, WP.DateFrom$DATE) XX)
    in
      (select Bx.ID from Divisions Bx where
        Bx.ID in (select B2x.ID from SYS$Divisions2 B2x where B2x.Superior_ID in ({:LIST})) and
        Bx.Hidden = 'N'
      )
    )
  )
)
ckSingle:
/* Omezeni za strediska s moznosti vsech podrizenych krome skrytych */
(
  /* timhle omezime vsechny prime nadrizene */
  ((SELECT XX.SID FROM StringValueOfDivisionForWR(WR.ID, WP.DateFrom$DATE) XX) in (select Bx.ID from Divisions Bx where Bx.ID = {:VALUE} and Bx.Hidden = 'N'))
  or
  /* a jestli mame omezeit za podrizene tak to udelame takhle */
  ({WithChildren} = 1 AND
    (
    (SELECT XX.SID FROM StringValueOfDivisionForWR(WR.ID, WP.DateFrom$DATE) XX)
    in
      (select Bx.ID from Divisions Bx where
        Bx.ID in (select B2x.ID from SYS$Divisions2 B2x where B2x.Superior_ID = {:VALUE}) and
        Bx.Hidden = 'N'
      )
    )
  )
)
Dataset:
WAGELISTPARTIAL
Speciální parametry:
CLASSID=OA5JMX4J2FD135CH000ILPWJF4
TextField=Code
Hidden=True
AssignedFrom=Division_ID2

Division_ID2

Popiska:
Středisko
Typ/Subtyp:
ctSpecial/8
ckList:
A.ID in 
(SELECT X.WorkingRelation_ID 
 FROM WagelistPartial X
 LEFT JOIN WagePeriods XWP on XWP.ID = X.WagePeriod_ID 
 WHERE X.WorkingRelation_ID = A.ID AND 
 ({$WagePeriodsSelID}='' OR (X.WagePeriod_ID IN (SELECT OBJ_ID FROM SELDAT WHERE SEL_ID={$WagePeriodsSelID}))) AND
 /* Omezeni za strediska s moznosti vsech podrizenych krome skrytych */
 (
  /* timhle omezime vsechny prime nadrizene */
  ((SELECT XX.SID FROM StringValueOfDivisionForWR(X.WorkingRelation_ID, XWP.DateFrom$DATE) XX) in (select Bx.ID from Divisions Bx where Bx.ID in ({:LIST}) and Bx.Hidden = 'N'))
  or
  /* a jestli mame omezeit za podrizene tak to udelame takhle */
  ({WithChildren} = 1 AND
    (
    (SELECT XX.SID FROM StringValueOfDivisionForWR(X.WorkingRelation_ID, XWP.DateFrom$DATE) XX)
    in
      (select Bx.ID from Divisions Bx where
        Bx.ID in (select B2x.ID from SYS$Divisions2 B2x where B2x.Superior_ID in ({:LIST})) and
        Bx.Hidden = 'N'
      )
    )
  )
 )
)
ckSingle:
A.ID in 
(SELECT X.WorkingRelation_ID 
 FROM WagelistPartial X 
 LEFT JOIN WagePeriods XWP on XWP.ID = X.WagePeriod_ID
 WHERE X.WorkingRelation_ID = A.ID AND 
 ({$WagePeriodsSelID}='' OR (X.WagePeriod_ID IN (SELECT OBJ_ID FROM SELDAT WHERE SEL_ID={$WagePeriodsSelID}))) AND 
 /* Omezeni za strediska s moznosti vsech podrizenych krome skrytych */
 (
  /* timhle omezime vsechny prime nadrizene */
  ((SELECT XX.SID FROM StringValueOfDivisionForWR(X.WorkingRelation_ID, XWP.DateFrom$DATE) XX) in (select Bx.ID from Divisions Bx where Bx.ID = {:VALUE} and Bx.Hidden = 'N'))
  or
  /* a jestli mame omezeit za podrizene tak to udelame takhle */
  ({WithChildren} = 1 AND
    (
    (SELECT XX.SID FROM StringValueOfDivisionForWR(X.WorkingRelation_ID, XWP.DateFrom$DATE) XX)
    in
      (select Bx.ID from Divisions Bx where
        Bx.ID in (select B2x.ID from SYS$Divisions2 B2x where B2x.Superior_ID = {:VALUE}) and
        Bx.Hidden = 'N'
      )
    )
  )
 )
)
Dataset:
MAIN
Speciální parametry:
CLASSID=OA5JMX4J2FD135CH000ILPWJF4
TextField=Code

Division_ID3

Popiska:
Středisko
Typ/Subtyp:
ctSpecial/8
ckSingle:
A.ID in 
(SELECT X.WorkingRelation_ID 
 FROM WagelistPartial X 
 LEFT JOIN WagePeriods XWP on XWP.ID = X.WagePeriod_ID
 WHERE X.WorkingRelation_ID = A.ID AND 
 ({$WagePeriodsSelID}='' OR (X.WagePeriod_ID IN (SELECT OBJ_ID FROM SELDAT WHERE SEL_ID={$WagePeriodsSelID}))) AND 
 /* Omezeni za strediska s moznosti vsech podrizenych krome skrytych */
 (
  /* timhle omezime vsechny prime nadrizene */
  ((SELECT XX.SID FROM StringValueOfDivisionForWR(X.WorkingRelation_ID, XWP.DateFrom$DATE) XX) in (select Bx.ID from Divisions Bx where Bx.ID = {:VALUE} and Bx.Hidden = 'N'))
  or
  /* a jestli mame omezeit za podrizene tak to udelame takhle */
  ({WithChildren} = 1 AND
    (
    (SELECT XX.SID FROM StringValueOfDivisionForWR(X.WorkingRelation_ID, XWP.DateFrom$DATE) XX)
    in
      (select Bx.ID from Divisions Bx where
        Bx.ID in (select B2x.ID from SYS$Divisions2 B2x where B2x.Superior_ID = {:VALUE}) and
        Bx.Hidden = 'N'
      )
    )
  )
 )
)
ckList:
A.ID in 
(SELECT X.WorkingRelation_ID 
 FROM WagelistPartial X
 LEFT JOIN WagePeriods XWP on XWP.ID = X.WagePeriod_ID 
 WHERE X.WorkingRelation_ID = A.ID AND 
 ({$WagePeriodsSelID}='' OR (X.WagePeriod_ID IN (SELECT OBJ_ID FROM SELDAT WHERE SEL_ID={$WagePeriodsSelID}))) AND 
 /* Omezeni za strediska s moznosti vsech podrizenych krome skrytych */
 (
  /* timhle omezime vsechny prime nadrizene */
  ((SELECT XX.SID FROM StringValueOfDivisionForWR(X.WorkingRelation_ID, XWP.DateFrom$DATE) XX) in (select Bx.ID from Divisions Bx where Bx.ID in ({:LIST}) and Bx.Hidden = 'N'))
  or
  /* a jestli mame omezeit za podrizene tak to udelame takhle */
  ({WithChildren} = 1 AND
    (
    (SELECT XX.SID FROM StringValueOfDivisionForWR(X.WorkingRelation_ID, XWP.DateFrom$DATE) XX)
    in
      (select Bx.ID from Divisions Bx where
        Bx.ID in (select B2x.ID from SYS$Divisions2 B2x where B2x.Superior_ID in ({:LIST})) and
        Bx.Hidden = 'N'
      )
    )
  )
 )
)
Dataset:
WRCOUNTSFOREMPLOYEE
Speciální parametry:
CLASSID=OA5JMX4J2FD135CH000ILPWJF4
TextField=Code
Hidden=True
AssignedFrom=Division_ID2

EmployPattern

Popiska:
Druh pracovního poměru
Typ/Subtyp:
ctSpecial/0
ckSingle:
A.EmployPattern_ID = {:VALUE}
ckList:
A.EmployPattern_ID IN ({:LIST})
Dataset:
MAIN
Speciální parametry:
CLASSID=BNGQ5XMLMQVOD0J3OTQJR12DN4
TextField=Code

IsComputed

Popiska:
Mzdový list je spočten
Typ/Subtyp:
ctBoolean/0
ckSingle:
((A.IsComputed = 'A') AND (WLC.IsComputed = 'A') AND ({:VALUE} = 'A')) OR
 (((A.IsComputed = 'N') OR (WLC.IsComputed = 'N')) AND ({:VALUE} = 'N'))
Dataset:
WAGELISTPARTIAL

Employee_ID_WRC

Popiska:
Zaměstnanec
Typ/Subtyp:
ctSpecial/0
ckList:
A.Employee_ID IN ({:LIST})
ckSingle:
A.Employee_ID = {:VALUE}
Dataset:
WRCOUNTSFOREMPLOYEE
Speciální parametry:
CLASSID=O3MRVA1EEFF13JXS00KEZYD5AW
TextField=PersonalNumber
Hidden=True
AssignedFrom=Employee_ID

WorkingRelation_ID_WRC

Popiska:
Typ/Subtyp:
ctSpecial/0
ckSingle:
A.ID = {:VALUE}
ckList:
A.ID IN ({:LIST})
Dataset:
MAIN
Speciální parametry:
CLASSID=USTGJ04DFYFORHLKG0BFOD2VUK
TextField=ShortName
Hidden=True
AssignedFrom=WorkingRelation_ID

SuperiorWR_ID_WRC

Šablona:
SuperiorWR_ID
Dataset:
WRCOUNTSFOREMPLOYEE
Speciální parametry:
Hidden=True
AssignedFrom=SuperiorWR_ID

EmployPattern_WRC

Popiska:
Druh pracovního poměru
Typ/Subtyp:
ctSpecial/0
ckSingle:
A.EmployPattern_ID = {:VALUE}
ckList:
A.EmployPattern_ID IN ({:LIST})
Dataset:
WRCOUNTSFOREMPLOYEE
Speciální parametry:
CLASSID=BNGQ5XMLMQVOD0J3OTQJR12DN4
TextField=Code
Hidden=True
AssignedFrom=EmployPattern

RecordStatus_WRC

Popiska:
Evidenční stav
Typ/Subtyp:
ctSpecial/1
ckSingle:
##CASEOR {:VALUE} #
##1#(A.RecordedStatus = 'A' AND
     NOT 'A' IN (SELECT AB.NOEVIDENCESTATE FROM Absences AB
              WHERE AB.WorkingRelation_ID = A.ID AND
              AB.AbsentFrom$DATE <= {$HistoryDate} AND
             ((AB.AbsentTo$DATE = 0) OR (AB.AbsentTo$DATE >= {$HistoryDate}))))
##2#(A.RecordedStatus = 'N' OR
      'A' IN (SELECT AB.NOEVIDENCESTATE FROM Absences AB
              WHERE AB.WorkingRelation_ID = A.ID AND
              AB.AbsentFrom$DATE <= {$HistoryDate} AND
             ((AB.AbsentTo$DATE = 0) OR (AB.AbsentTo$DATE >= {$HistoryDate}))))
##3#(A.CalcWage = 'A' AND NOT 'A' IN (SELECT AB.NOCALCULATION FROM Absences AB
              WHERE AB.WorkingRelation_ID = A.ID AND
              AB.NOCALCULATION='A' AND
              AB.AbsentFrom$DATE <= {$HistoryDate} AND
             ((AB.AbsentTo$DATE = 0) OR (AB.AbsentTo$DATE >= {$HistoryDate}))))
##4#(A.CalcWage = 'N' OR
     'A' IN (SELECT AB.NOCALCULATION FROM Absences AB
              WHERE AB.WorkingRelation_ID = A.ID AND
              AB.NOCALCULATION='A' AND
              AB.AbsentFrom$DATE <= {$HistoryDate} AND
             ((AB.AbsentTo$DATE = 0) OR (AB.AbsentTo$DATE >= {$HistoryDate}))))
##5#(0=0)
##END#
Dataset:
MAIN
Speciální parametry:
Names=V evidenčním stavu;Mimo evidenční stav;Zaměstnanci pobírající mzdu;Zaměstnanci nepobírající mzdu;Bez omezení
Values=1;2;3;4;5
Hidden=True
AssignedFrom=RecordStatus

InsuranceComp_ID

Popiska:
Zdravotní pojišťovna
Typ/Subtyp:
ctSpecial/0
ckSingle:
(SELECT XX.SID FROM StringValueOfInsCompForEMP(EMP.ID, WP.DateFrom$DATE) XX) = {:VALUE}
ckList:
(SELECT XX.SID FROM StringValueOfInsCompForEMP(EMP.ID, WP.DateFrom$DATE) XX) IN ({:LIST})
Dataset:
WAGELISTPARTIAL
Speciální parametry:
CLASSID=4NN354URZJE13EYM00KEZYD5AW
TextField=Code

InsuranceComp_ID2

Popiska:
Zdravotní pojišťovna
Typ/Subtyp:
ctSpecial/0
ckSingle:
(SELECT XXX.SID FROM StringValueOfInsCompForEMP(A.Employee_ID, WP.DateFrom$DATE) XXX) = {:VALUE}
ckList:
(SELECT XXX.SID FROM StringValueOfInsCompForEMP(A.Employee_ID, WP.DateFrom$DATE) XXX) IN ({:LIST})
Dataset:
WAGELISTCOMMON
Speciální parametry:
CLASSID=4NN354URZJE13EYM00KEZYD5AW
TextField=Code
Hidden=True
AssignedFrom=InsuranceComp_ID

InsuranceComp_ID_WR

Popiska:
Zdravotní pojišťovna
Typ/Subtyp:
ctSpecial/0
ckSingle:
A.ID in (SELECT Z.WorkingRelation_ID FROM WagelistPartial Z LEFT JOIN WagePeriods XWP on XWP.ID = Z.WagePeriod_ID WHERE Z.WorkingRelation_ID = A.ID AND (SELECT XXXX.SID FROM StringValueOfInsCompForEMP(EMP.ID, XWP.DateFrom$DATE) XXXX) = {:VALUE})
ckList:
A.ID in (SELECT Z.WorkingRelation_ID FROM WagelistPartial Z LEFT JOIN WagePeriods XWP on XWP.ID = Z.WagePeriod_ID WHERE Z.WorkingRelation_ID = A.ID AND (SELECT XXXX.SID FROM StringValueOfInsCompForEMP(EMP.ID, XWP.DateFrom$DATE) XXXX) IN ({:LIST}))
Dataset:
MAIN
Speciální parametry:
CLASSID=4NN354URZJE13EYM00KEZYD5AW
TextField=Code
Hidden=True
AssignedFrom=InsuranceComp_ID

Klíče

Employee name

Popiska:
Jméno
SQL:
PER.FirstName Collate PXW_CSY {DIR}, EMP.ID
Dataset:
MAIN

Employee surname

Popiska:
Příjmení
SQL:
PER.LastName Collate PXW_CSY {DIR}, EMP.ID
Dataset:
MAIN

Employee InsuranceCompany

Popiska:
Zdravotní pojišťovna
SQL:
EMP.InsuranceComp_ID
Dataset:
MAIN

WorkingRelation

Popiska:
Pracovní poměr
SQL:
PAT.Code Collate PXW_CSY {DIR}, PER.LastName Collate PXW_CSY {DIR}, PER.FirstName Collate PXW_CSY {DIR}, PAT.CalcPriority {DIR},  A.ID
Dataset:
MAIN

PersonalNumber

Popiska:
Osobní číslo
SQL:
PER.PersonalNumber
Dataset:
MAIN

NumPersonalNumber

Popiska:
Osobní číslo numericky
SQL:
%NumPersonalNumber%
Dataset:
MAIN

DateOfBegin

Popiska:
Datum nástupu do pracovního poměru
SQL:
A.DateOfBegin$DATE
Dataset:
MAIN

FAMILYMEMBERS.ValidFrom_ID.DateFrom

Popiska:
Rodinní příslušníci - Platí od
SQL:
WP.DateFrom$DATE
Dataset:
FAMILYMEMBERS

Generated by ABRA Software a.s. 27.10.2021 16:36