<?xml version="1.0" encoding="iso-8859-1"?>
<FORM>
  <TSQD>
    <Properties>
      <Descryption>Umowy d&#xB3;ugoterminowe</Descryption>
      <Title>Umowy d&#xB3;ugoterminowe</Title>
      <InternalId>{C85B3EBF-D390-42AD-9F28-4A397E0928Ez}</InternalId>
      <UseDefaultDataBase>True</UseDefaultDataBase>
      <UseFilters>True</UseFilters>
      <ShowFilters>True</ShowFilters>
      <ShowParams>True</ShowParams>
      <SQBReadOnly>False</SQBReadOnly>
      <SQBType>sqtQuery</SQBType>
      <SQL>&quot;select o.nazwisko, o.imiona, o.nrpesel, o.info2 as nr_przepustki, &quot;,&quot; t.* &quot;,&quot;from tt_um t&quot;,&quot;inner join osoby o on o.GUID = t.GUID_pracownika   &quot;,&quot;order by o.nazwisko, o.imiona, t.DataUmowy, t.DataZawarcia&quot;,&quot;limit 3000&quot;,</SQL>
      <SQLInit>&quot;CALL fr_pl_zest(&apos;UMZLEC_DL_SQD&apos;,&apos;&apos;,&apos;&apos;,&apos;&apos;,&apos;&apos;,&apos;&apos;,&apos;akt&apos;)&quot;,</SQLInit>
    </Properties>
    <FieldDefsCollection>
      <CollectionItems.>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>Nazwisko</FieldName>
          <FieldIndex>0</FieldIndex>
          <DisplayLabel>Nazwisko</DisplayLabel>
          <DisplayWidth>20</DisplayWidth>
          <Size>30</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>Imiona</FieldName>
          <FieldIndex>1</FieldIndex>
          <DisplayLabel>Imiona</DisplayLabel>
          <DisplayWidth>20</DisplayWidth>
          <Size>45</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>NrEwidencyjny</FieldName>
          <FieldIndex>2</FieldIndex>
          <DisplayLabel>N eEwid.</DisplayLabel>
          <DisplayWidth>10</DisplayWidth>
          <Size>100</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>NrPesel</FieldName>
          <FieldIndex>3</FieldIndex>
          <DisplayLabel>Nr Pesel</DisplayLabel>
          <DisplayWidth>11</DisplayWidth>
          <Size>11</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>nr_przepustki</FieldName>
          <FieldIndex>4</FieldIndex>
          <DisplayLabel>Nr przepustki</DisplayLabel>
          <DisplayWidth>10</DisplayWidth>
          <Size>255</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>aneksStr</FieldName>
          <FieldIndex>5</FieldIndex>
          <DisplayLabel>UM/AN</DisplayLabel>
          <DisplayWidth>10</DisplayWidth>
          <Size>1</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>stanowisko</FieldName>
          <FieldIndex>6</FieldIndex>
          <DisplayLabel>Stanowisko</DisplayLabel>
          <DisplayWidth>20</DisplayWidth>
          <Size>100</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>kierownik</FieldName>
          <FieldIndex>7</FieldIndex>
          <DisplayLabel>Kierownik</DisplayLabel>
          <DisplayWidth>20</DisplayWidth>
          <Size>100</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftString</DataType>
          <FieldName>dzial</FieldName>
          <FieldIndex>8</FieldIndex>
          <DisplayLabel>Dzia&#xB3;</DisplayLabel>
          <DisplayWidth>20</DisplayWidth>
          <Size>100</Size>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftMemo</DataType>
          <FieldName>PracaStr</FieldName>
          <FieldIndex>9</FieldIndex>
          <DisplayLabel>Zakres prac umowy</DisplayLabel>
          <DisplayWidth>50</DisplayWidth>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftDate</DataType>
          <FieldName>DataUmowy</FieldName>
          <FieldIndex>10</FieldIndex>
          <DisplayLabel>Data umowy</DisplayLabel>
          <DisplayFormat>YYYY-MM-DD</DisplayFormat>
          <DisplayWidth>10</DisplayWidth>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftDate</DataType>
          <FieldName>DataZawarcia</FieldName>
          <FieldIndex>11</FieldIndex>
          <DisplayLabel>Data od</DisplayLabel>
          <DisplayFormat>YYYY-MM-DD</DisplayFormat>
          <DisplayWidth>10</DisplayWidth>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftDate</DataType>
          <FieldName>DataDo</FieldName>
          <FieldIndex>12</FieldIndex>
          <DisplayLabel>Data do</DisplayLabel>
          <DisplayFormat>YYYY-MM-DD</DisplayFormat>
          <DisplayWidth>10</DisplayWidth>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftFloat</DataType>
          <FieldName>stawka_rgb_netto</FieldName>
          <FieldIndex>13</FieldIndex>
          <Alignment>taRightJustify</Alignment>
          <DisplayLabel>Stawka RGB netto</DisplayLabel>
          <DisplayFormat>###,##0.00;-###,##0.00;&quot;&quot;</DisplayFormat>
          <DisplayWidth>10</DisplayWidth>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftFloat</DataType>
          <FieldName>stawka_rgb_brutto</FieldName>
          <FieldIndex>14</FieldIndex>
          <Alignment>taRightJustify</Alignment>
          <DisplayLabel>Stawka RGB brutto</DisplayLabel>
          <DisplayFormat>###,##0.00;-###,##0.00;&quot;&quot;</DisplayFormat>
          <DisplayWidth>10</DisplayWidth>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftFloat</DataType>
          <FieldName>wynag_netto</FieldName>
          <FieldIndex>15</FieldIndex>
          <Alignment>taRightJustify</Alignment>
          <DisplayLabel>Wynag sta&#xB3;e netto</DisplayLabel>
          <DisplayFormat>###,##0.00;-###,##0.00;&quot;&quot;</DisplayFormat>
          <DisplayWidth>10</DisplayWidth>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
        <TFieldDefsItem>
          <DataType>ftFloat</DataType>
          <FieldName>wynag_brutto</FieldName>
          <FieldIndex>16</FieldIndex>
          <Alignment>taRightJustify</Alignment>
          <DisplayLabel>Wynag sta&#xB3;e brutto</DisplayLabel>
          <DisplayFormat>###,##0.00;-###,##0.00;&quot;&quot;</DisplayFormat>
          <DisplayWidth>10</DisplayWidth>
          <TimeOptions>
            <TimeFormat>TH</TimeFormat>
          </TimeOptions>
          <NumericCalculator>
            <DisplayFormatWithUnits>False</DisplayFormatWithUnits>
          </NumericCalculator>
        </TFieldDefsItem>
      </CollectionItems.>
    </FieldDefsCollection>
    <Params/>
    <ParamsHash/>
    <FilterConteners>
      <Stored_Name>&amp;lt;domy&#x9C;lny&amp;gt;</Stored_Name>
      <Stored_Type>200</Stored_Type>
      <Stored_Version>6.0</Stored_Version>
      <Filters>
        <CollectionItems.>
          <TFilterItem>
            <Name>datado</Name>
            <ValueDown>46127D</ValueDown>
            <ValueUp>45819D</ValueUp>
            <AvaibleFlags>ffEqu,ffLess,ffGreater,ffBetween</AvaibleFlags>
            <FieldName>DataDo</FieldName>
            <DisplayLabel>Data do</DisplayLabel>
            <AliasName>t</AliasName>
            <Flag>ffGreater</Flag>
            <FieldType>ftDate</FieldType>
          </TFilterItem>
          <TFilterItem>
            <Name>dataod</Name>
            <ValueDown>46157D</ValueDown>
            <ValueUp>45819D</ValueUp>
            <FieldName>DataZawarcia</FieldName>
            <DisplayLabel>Data od</DisplayLabel>
            <AliasName>t</AliasName>
            <Flag>ffLess</Flag>
            <FieldType>ftDate</FieldType>
          </TFilterItem>
          <TFilterItem>
            <Name>umowa_aneks</Name>
            <ValueDown>U</ValueDown>
            <AvaibleFlags>ffEqu</AvaibleFlags>
            <FieldName>aneksStr</FieldName>
            <DisplayLabel>umowa/aneks</DisplayLabel>
            <AliasName>t</AliasName>
            <LookUpFieldName>aneksStr</LookUpFieldName>
            <LookUpResultFieldName>aneksStr</LookUpResultFieldName>
            <LookUpSQL>select distinct aneksStr from tt_um order by aneksStr;
</LookUpSQL>
            <SQLLookUp>&quot;select distinct aneksStr from tt_um order by aneksStr;&quot;</SQLLookUp>
          </TFilterItem>
          <TFilterItem>
            <Name>dataumowy</Name>
            <ValueDown>45819D</ValueDown>
            <ValueUp>45819D</ValueUp>
            <AvaibleFlags>ffEqu,ffLess,ffGreater,ffBetween</AvaibleFlags>
            <FieldName>DataUmowy</FieldName>
            <DisplayLabel>Data umowy</DisplayLabel>
            <AliasName>t</AliasName>
            <FieldType>ftDate</FieldType>
          </TFilterItem>
          <TFilterItem>
            <Name>Field4</Name>
            <AvaibleFlags>ffEqu,ffLike,ffLikeBegin</AvaibleFlags>
            <FieldName>dzial</FieldName>
            <DisplayLabel>Dzia&#xB3;</DisplayLabel>
            <AliasName>t</AliasName>
          </TFilterItem>
          <TFilterItem>
            <Name>kierownik</Name>
            <AvaibleFlags>ffEqu,ffLike,ffLikeBegin</AvaibleFlags>
            <FieldName>kierownik</FieldName>
            <DisplayLabel>Kierownik</DisplayLabel>
            <AliasName>t</AliasName>
          </TFilterItem>
        </CollectionItems.>
      </Filters>
      <SaveProfileAfterDlg>False</SaveProfileAfterDlg>
      <ExtraValues>
        <Test>0</Test>
      </ExtraValues>
    </FilterConteners>
  </TSQD>
</FORM>
