PageRenderTime 35ms CodeModel.GetById 26ms app.highlight 5ms RepoModel.GetById 1ms app.codeStats 0ms

/HRManager/__history/APPOINTMENTEDITUnit.dfm.~28~

https://github.com/oista/NPO
Unknown | 861 lines | 861 code | 0 blank | 0 comment | 0 complexity | 5352e7de49e353aff5b1adc425ce62fb MD5 | raw file
  1inherited APPOINTMENTEDIT: TAPPOINTMENTEDIT
  2  Caption = #1054#1092#1086#1088#1084#1083#1077#1085#1080#1077' '#1087#1077#1088#1077#1074#1086#1076#1072
  3  ClientHeight = 596
  4  ClientWidth = 519
  5  OnShow = FormShow
  6  ExplicitWidth = 525
  7  ExplicitHeight = 620
  8  PixelsPerInch = 96
  9  TextHeight = 13
 10  inherited Panel1: TPanel
 11    Left = 428
 12    Height = 596
 13    ExplicitLeft = 428
 14    ExplicitHeight = 596
 15    inherited Button1: TButton
 16      OnClick = Button1Click
 17    end
 18    object PKDBDictEdit4: TPKDBDictEdit
 19      Left = 24
 20      Top = 156
 21      Width = 1
 22      Height = 1
 23      Connection = DataModule1.ADConnection1
 24      Table = PKDBTable1
 25      TableField = 'PREVIOUSID'
 26      WithoutTable = False
 27      DesignSize = (
 28        1
 29        1)
 30    end
 31    object PKDBDictEdit5: TPKDBDictEdit
 32      Left = 24
 33      Top = 183
 34      Width = 1
 35      Height = 1
 36      Connection = DataModule1.ADConnection1
 37      Table = PKDBTable1
 38      TableField = 'DESCR'
 39      WithoutTable = False
 40      DesignSize = (
 41        1
 42        1)
 43    end
 44    object PKDBDictEdit6: TPKDBDictEdit
 45      Left = 48
 46      Top = 192
 47      Width = 1
 48      Height = 1
 49      Connection = DataModule1.ADConnection1
 50      Table = PKDBTable1
 51      TableField = 'WORKCONTRACTID'
 52      WithoutTable = False
 53      DesignSize = (
 54        1
 55        1)
 56    end
 57    object PKDBDictEdit7: TPKDBDictEdit
 58      Left = 3
 59      Top = 199
 60      Width = 1
 61      Height = 1
 62      Connection = DataModule1.ADConnection1
 63      Table = PKDBTable3
 64      TableField = 'OLDSTRUCTUREID'
 65      LookUpRool = ' id'
 66      WithoutTable = False
 67      DesignSize = (
 68        1
 69        1)
 70    end
 71    object PKDBDictEdit8: TPKDBDictEdit
 72      Left = 3
 73      Top = 226
 74      Width = 1
 75      Height = 1
 76      Connection = DataModule1.ADConnection1
 77      Table = PKDBTable3
 78      TableField = 'NEWSTRUCTUREID'
 79      LookUpRool = ' id'
 80      WithoutTable = False
 81      DesignSize = (
 82        1
 83        1)
 84    end
 85    object PKDBDictEdit9: TPKDBDictEdit
 86      Left = 3
 87      Top = 233
 88      Width = 1
 89      Height = 1
 90      Connection = DataModule1.ADConnection1
 91      Table = PKDBTable3
 92      TableField = 'AGREEMENTTYPE'
 93      LookUpRool = ' id'
 94      WithoutTable = False
 95      DesignSize = (
 96        1
 97        1)
 98    end
 99    object PKDBDictEdit10: TPKDBDictEdit
100      Left = 16
101      Top = 256
102      Width = 1
103      Height = 1
104      Connection = DataModule1.ADConnection1
105      Table = PKDBTable4
106      TableField = 'ORDERTYPE'
107      WithoutTable = False
108      DesignSize = (
109        1
110        1)
111    end
112    object PKDBDictEdit11: TPKDBDictEdit
113      Left = 10
114      Top = 1
115      Width = 185
116      Height = 1
117      Connection = DataModule1.ADConnection1
118      Table = PKDBTable4
119      TableField = 'AGREEMENTID'
120      WithoutTable = False
121      DesignSize = (
122        185
123        1)
124    end
125    object PKDBDictEdit12: TPKDBDictEdit
126      Left = 40
127      Top = 256
128      Width = 1
129      Height = 1
130      Connection = DataModule1.ADConnection1
131      Table = PKDBTable4
132      TableField = 'NEWEMPLOEEID'
133      WithoutTable = False
134      DesignSize = (
135        1
136        1)
137    end
138  end
139  inherited PageControl1: TPageControl
140    Width = 422
141    Height = 590
142    ExplicitWidth = 422
143    ExplicitHeight = 590
144    inherited TabSheet1: TTabSheet
145      Caption = #1054#1092#1086#1088#1084#1083#1077#1085#1080#1077' '#1087#1077#1088#1077#1074#1086#1076#1072
146      ExplicitLeft = 4
147      ExplicitTop = 24
148      ExplicitWidth = 414
149      ExplicitHeight = 562
150      object Label2: TLabel
151        Left = 15
152        Top = 52
153        Width = 57
154        Height = 13
155        Caption = #1044#1086#1083#1078#1085#1086#1089#1090#1100
156      end
157      object Label1: TLabel
158        Left = 15
159        Top = 187
160        Width = 243
161        Height = 13
162        Caption = #1044#1086#1083#1078#1085#1086#1089#1090#1100' '#1089' '#1082#1086#1090#1086#1088#1086#1081' '#1086#1089#1091#1097#1077#1089#1090#1074#1083#1103#1077#1090#1089#1103' '#1087#1077#1088#1077#1093#1086#1076
163      end
164      object PKDBDictEdit2: TPKDBDictEdit
165        Left = 15
166        Top = 71
167        Width = 378
168        Height = 21
169        Connection = DataModule1.ADConnection1
170        Table = PKDBTable1
171        TableField = 'STRUCTUREID'
172        LookUpRool = #39#1055#1054#1044#1056'.'#8470#39'||DCODE||'#39' '#39'|| jobtitle||'#39' '#39'||qualification'
173        DictionaryClass = 'TVACANCY'
174        OnBeforeOpenButtonClick = PKDBDictEdit1BeforeOpenButtonClick
175        WithoutTable = False
176        DesignSize = (
177          378
178          21)
179      end
180      object PKDBLabelEdit3: TPKDBLabelEdit
181        Left = 15
182        Top = 115
183        Width = 178
184        Height = 21
185        TabOrder = 1
186        Text = #1058#1072#1073'.'#8470
187        Table = PKDBTable1
188        TableField = 'TABNUMB'
189        EditLabel.Width = 35
190        EditLabel.Height = 13
191        EditLabel.Caption = #1058#1072#1073'.'#8470
192      end
193      object PKDBLabelEdit4: TPKDBLabelEdit
194        Left = 15
195        Top = 160
196        Width = 178
197        Height = 21
198        TabOrder = 2
199        Text = #1044#1072#1090#1072' '#1087#1088#1080#1093#1086#1076#1072' '#1085#1072' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
200        EditKind = ekDateEdit
201        Table = PKDBTable1
202        TableField = 'INDATE'
203        EditLabel.Width = 146
204        EditLabel.Height = 13
205        EditLabel.Caption = #1044#1072#1090#1072' '#1087#1088#1080#1093#1086#1076#1072' '#1085#1072' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
206      end
207      object PKDBLabelEdit5: TPKDBLabelEdit
208        Left = 215
209        Top = 160
210        Width = 178
211        Height = 21
212        TabOrder = 3
213        Text = #1044#1072#1090#1072' '#1091#1074#1086#1083#1100#1085#1077#1085#1080#1103' '#1089' '#1076#1086#1083#1078#1085#1086#1089#1090#1080
214        Visible = False
215        EditKind = ekDateEdit
216        Table = PKDBTable1
217        TableField = 'OUTDATE'
218        EditLabel.Width = 156
219        EditLabel.Height = 13
220        EditLabel.Caption = #1044#1072#1090#1072' '#1091#1074#1086#1083#1100#1085#1077#1085#1080#1103' '#1089' '#1076#1086#1083#1078#1085#1086#1089#1090#1080
221      end
222      object PKDBDictEdit3: TPKDBDictEdit
223        Left = 215
224        Top = 115
225        Width = 0
226        Height = 19
227        Table = PKDBTable1
228        TableField = 'WORKUNITTYPE'
229        LookUpRool = ' id'
230        WithoutTable = False
231        DesignSize = (
232          0
233          19)
234      end
235      object PKDBDictLabelEdit1: TPKDBDictLabelEdit
236        Left = 15
237        Top = 25
238        Width = 378
239        Height = 21
240        Connection = DataModule1.ADConnection1
241        Table = PKDBTable1
242        TableField = 'CITEZENID'
243        LookUpRool = 'lastname||'#39' '#39'||name||'#39' '#39'||fathership||'#39' '#1087#1072#1089#1087#1086#1088#1090' '#8470#39'||PASSPORTNUMB'
244        DictionaryClass = 'TEMPLOYEE'
245        WithoutTable = False
246        EditLabel.Width = 57
247        EditLabel.Height = 13
248        EditLabel.Caption = #1043#1088#1072#1078#1076#1072#1085#1080#1085
249        DesignSize = (
250          378
251          21)
252      end
253      object PKDBDictEdit1: TPKDBDictEdit
254        Left = 15
255        Top = 205
256        Width = 378
257        Height = 21
258        Connection = DataModule1.ADConnection1
259        Table = PKDBTable2
260        TableField = 'ID'
261        LookUpRool = #39#1055#1054#1044#1056'.'#8470#39'||DCODE||'#39' '#39'|| jobtitle||'#39' '#39'||qualification'
262        OnBeforeOpenButtonClick = PKDBDictEdit1BeforeOpenButtonClick
263        WithoutTable = False
264        DesignSize = (
265          378
266          21)
267      end
268      object GroupBox1: TGroupBox
269        Left = 3
270        Top = 248
271        Width = 406
272        Height = 169
273        Caption = '  '#1044#1086#1087'. '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1077' '
274        TabOrder = 7
275        object PKDBLabelEdit2: TPKDBLabelEdit
276          Left = 212
277          Top = 36
278          Width = 178
279          Height = 21
280          TabOrder = 0
281          Text = #1044#1072#1090#1072' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
282          EditKind = ekDateEdit
283          Table = PKDBTable3
284          TableField = 'AGREEMENTDATE'
285          EditLabel.Width = 89
286          EditLabel.Height = 13
287          EditLabel.Caption = #1044#1072#1090#1072' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
288        end
289        object PKDBLabelEdit1: TPKDBLabelEdit
290          Left = 12
291          Top = 36
292          Width = 178
293          Height = 21
294          TabOrder = 1
295          Text = #1053#1086#1084#1077#1088' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
296          Table = PKDBTable3
297          TableField = 'AGREEMENTNUMB'
298          EditLabel.Width = 94
299          EditLabel.Height = 13
300          EditLabel.Caption = #1053#1086#1084#1077#1088' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
301        end
302        object PKDBLabelEdit6: TPKDBLabelEdit
303          Left = 12
304          Top = 80
305          Width = 178
306          Height = 21
307          Color = clWhite
308          TabOrder = 2
309          Text = #1044#1072#1090#1072' '#1085#1072#1095'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
310          EditKind = ekDateEdit
311          Table = PKDBTable3
312          TableField = 'INDATE'
313          EditLabel.Width = 137
314          EditLabel.Height = 13
315          EditLabel.Caption = #1044#1072#1090#1072' '#1085#1072#1095'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
316        end
317        object PKDBLabelEdit7: TPKDBLabelEdit
318          Left = 12
319          Top = 126
320          Width = 178
321          Height = 21
322          TabOrder = 3
323          Text = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1086#1090#1087#1091#1089#1082#1072
324          EditKind = ekNumberEdit
325          Table = PKDBTable3
326          TableField = 'HOLIDAY_GEN'
327          EditLabel.Width = 102
328          EditLabel.Height = 13
329          EditLabel.Caption = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1086#1090#1087#1091#1089#1082#1072
330        end
331        object PKDBLabelEdit8: TPKDBLabelEdit
332          Left = 212
333          Top = 126
334          Width = 178
335          Height = 21
336          TabOrder = 4
337          Text = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1076#1086#1087'. '#1086#1090#1087#1091#1089#1082#1072
338          EditKind = ekNumberEdit
339          Table = PKDBTable3
340          TableField = 'HOLIDAY_EXT'
341          EditLabel.Width = 128
342          EditLabel.Height = 13
343          EditLabel.Caption = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1076#1086#1087'. '#1086#1090#1087#1091#1089#1082#1072
344        end
345        object PKDBLabelEdit9: TPKDBLabelEdit
346          Left = 212
347          Top = 80
348          Width = 178
349          Height = 21
350          TabOrder = 5
351          Text = #1044#1072#1090#1072' '#1086#1082#1086#1085'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
352          EditKind = ekDateEdit
353          Table = PKDBTable3
354          TableField = 'OUTDATE'
355          EditLabel.Width = 143
356          EditLabel.Height = 13
357          EditLabel.Caption = #1044#1072#1090#1072' '#1086#1082#1086#1085'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
358        end
359      end
360      object CheckBox1: TCheckBox
361        AlignWithMargins = True
362        Left = 3
363        Top = 511
364        Width = 389
365        Height = 17
366        Margins.Left = 10
367        Margins.Bottom = 8
368        Caption = #1042#1099#1074#1077#1089#1090#1080' '#1092#1086#1088#1084#1091' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
369        TabOrder = 8
370      end
371      object CheckBox2: TCheckBox
372        Left = 3
373        Top = 536
374        Width = 261
375        Height = 17
376        Caption = #1042#1099#1074#1077#1089#1090#1080' '#1087#1088#1080#1082#1072#1079' '#1086' '#1087#1077#1088#1077#1074#1086#1076#1077
377        TabOrder = 9
378      end
379      object GroupBox2: TGroupBox
380        Left = 3
381        Top = 425
382        Width = 406
383        Height = 77
384        Caption = '  '#1055#1088#1080#1082#1072#1079' '#1086' '#1087#1077#1088#1077#1074#1086#1076#1077' '
385        TabOrder = 10
386        object PKDBLabelEdit10: TPKDBLabelEdit
387          Left = 12
388          Top = 35
389          Width = 178
390          Height = 21
391          TabOrder = 0
392          Text = #1053#1086#1084#1077#1088' '#1087#1088#1080#1082#1072#1079#1072
393          Table = PKDBTable4
394          TableField = 'ORDERNUMB'
395          EditLabel.Width = 75
396          EditLabel.Height = 13
397          EditLabel.Caption = #1053#1086#1084#1077#1088' '#1087#1088#1080#1082#1072#1079#1072
398        end
399        object PKDBLabelEdit11: TPKDBLabelEdit
400          Left = 212
401          Top = 35
402          Width = 178
403          Height = 21
404          TabOrder = 1
405          Text = #1044#1072#1090#1072' '#1087#1088#1080#1082#1072#1079#1072
406          EditKind = ekDateEdit
407          Table = PKDBTable4
408          TableField = 'ORDERDATE'
409          EditLabel.Width = 70
410          EditLabel.Height = 13
411          EditLabel.Caption = #1044#1072#1090#1072' '#1087#1088#1080#1082#1072#1079#1072
412        end
413      end
414    end
415  end
416  inherited PKDBTable1: TPKDBTable
417    Fields = <
418      item
419        FieldName = 'CITEZENID'
420        FieldLabel = #1043#1088#1072#1078#1076#1072#1085#1080#1085
421        Nullable = True
422        FieldType = ftsNumber
423        ReferencingTable = 'HR_V_CITEZEN'
424        ReferencingColumn = 'ID'
425        IsParentKey = True
426        DisplayName = 'CITEZENID'
427      end
428      item
429        FieldName = 'STRUCTUREID'
430        FieldLabel = #1044#1086#1083#1078#1085#1086#1089#1090#1100
431        Nullable = True
432        FieldType = ftsNumber
433        ReferencingTable = 'CS_V_SCHEDULE_STRUCTURE'
434        ReferencingColumn = 'ID'
435        DisplayName = 'STRUCTUREID'
436      end
437      item
438        FieldName = 'AGREEMENTNUMB'
439        FieldLabel = #8470' '#1058#1088#1091#1076#1086#1074#1086#1075#1086' '#1076#1086#1075#1086#1074#1086#1088#1072
440        Nullable = True
441        FieldType = ftsString
442        DisplayName = 'AGREEMENTNUMB'
443      end
444      item
445        FieldName = 'PREVIOUSID'
446        FieldLabel = #1055#1088#1077#1076#1080#1076#1091#1097#1072#1103' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
447        Nullable = True
448        FieldType = ftsNumber
449        DisplayName = 'PREVIOUSID'
450      end
451      item
452        FieldName = 'OUTDATE'
453        FieldLabel = #1044#1072#1090#1072' '#1091#1074#1086#1083#1100#1085#1077#1085#1080#1103' '#1089' '#1076#1086#1083#1078#1085#1086#1089#1090#1080
454        Nullable = True
455        FieldType = ftsDate
456        DisplayName = 'OUTDATE'
457      end
458      item
459        FieldName = 'CHANGESTATUSDATE'
460        FieldLabel = #1044#1072#1090#1072' '#1080#1079#1084#1077#1085#1077#1085#1080#1103' '#1089#1090#1072#1090#1091#1089#1072
461        Nullable = True
462        FieldType = ftsDate
463        DisplayName = 'CHANGESTATUSDATE'
464      end
465      item
466        FieldName = 'AGREEMENTDATE'
467        FieldLabel = #1044#1072#1090#1072' '#1090#1088#1091#1076#1086#1074#1086#1075#1086' '#1076#1086#1075#1086#1074#1086#1088#1072
468        Nullable = True
469        FieldType = ftsDate
470        DisplayName = 'AGREEMENTDATE'
471      end
472      item
473        FieldName = 'WORKUNITTYPE'
474        FieldLabel = #1058#1080#1087' '#1088#1072#1073#1086#1090#1099' ('#1086#1089#1085#1086#1074'./'#1089#1086#1074#1084'.)'
475        Nullable = True
476        FieldType = ftsNumber
477        DisplayName = 'WORKUNITTYPE'
478      end
479      item
480        FieldName = 'TABNUMB'
481        FieldLabel = #1058#1072#1073#1077#1083#1100#1085#1099#1081' '#1085#1086#1084#1077#1088
482        Nullable = True
483        FieldType = ftsString
484        DisplayName = 'TABNUMB'
485      end
486      item
487        FieldName = 'ID'
488        Nullable = False
489        FieldType = ftsNumber
490        IsPrimaryKey = True
491        DisplayName = 'ID'
492      end
493      item
494        FieldName = 'INDATE'
495        FieldLabel = #1044#1072#1090#1072' '#1087#1088#1080#1093#1086#1076#1072' '#1085#1072' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
496        Nullable = False
497        FieldType = ftsDate
498        DisplayName = 'INDATE'
499      end
500      item
501        FieldName = 'DESCR'
502        FieldLabel = #1054#1087#1080#1089#1072#1085#1080#1077
503        Nullable = True
504        FieldType = ftsString
505        DisplayName = 'DESCR'
506      end
507      item
508        FieldName = 'STATUS'
509        FieldLabel = #1057#1090#1072#1090#1091#1089
510        Nullable = True
511        FieldType = ftsNumber
512        DisplayName = 'STATUS'
513      end
514      item
515        FieldName = 'WORKCONTRACTID'
516        Nullable = False
517        FieldType = ftsString
518        ReferencingTable = 'HR_WORKCONTRACT'
519        ReferencingColumn = 'ID'
520        DisplayName = 'WORKCONTRACTID'
521      end>
522    TableName = 'HR_EMPLOYEE'
523    NeedGenPrimaryKey = True
524    Connection = DataModule1.ADConnection1
525    PrimaryKeySeq = 'AE_IDSEQ'
526    Left = 437
527    Top = 88
528  end
529  object ADStoredProc2: TADStoredProc
530    Connection = DataModule1.ADConnection1
531    StoredProcName = 'APPROOT.HR_CHANGE_STRUCTUREID'
532    Left = 437
533    Top = 120
534    ParamData = <
535      item
536        Position = 1
537        Name = 'OBJECTID'
538        DataType = ftFMTBcd
539        ADDataType = dtFmtBCD
540        Precision = 38
541        NumericScale = 38
542        ParamType = ptInput
543      end
544      item
545        Position = 2
546        Name = 'EVENTDATE'
547        DataType = ftDateTime
548        ADDataType = dtDateTime
549        ParamType = ptInput
550      end>
551  end
552  object ADQuery1: TADQuery
553    Connection = DataModule1.ADConnection1
554    SQL.Strings = (
555      '-- '#1090#1072#1097#1080#1084' '#1089#1090#1072#1088#1091#1102' '#1076#1086#1083#1078#1085#1086#1089#1090#1100'.'
556      'SELECT '
557      '     ee.id, ee.workcontractid from HR_EMPLOYEE ee '
558      'WHERE '
559      '    (ee.citezenid = :ID) '
560      '-- '#1086#1089#1085#1086#1074#1085#1072#1103' '#1080' '#1072#1082#1090#1080#1074#1085#1072#1103
561      'AND (ee.workunittype = 3009016)'
562      'AND (ee.status = 1806638)'
563      'ORDER BY ee.indate DESC'
564      '')
565    Left = 469
566    Top = 120
567    ParamData = <
568      item
569        Name = 'ID'
570        DataType = ftInteger
571        ParamType = ptInput
572        Value = Null
573      end>
574    object ADQuery1ID: TFMTBCDField
575      FieldName = 'ID'
576      Required = True
577    end
578    object ADQuery1WORKCONTRACTID: TFMTBCDField
579      FieldName = 'WORKCONTRACTID'
580      Precision = 38
581      Size = 38
582    end
583  end
584  object PKDBTable2: TPKDBTable
585    Fields = <
586      item
587        FieldName = 'CITEZENID'
588        FieldLabel = #1043#1088#1072#1078#1076#1072#1085#1080#1085
589        Nullable = False
590        FieldType = ftsNumber
591        ReferencingTable = 'HR_V_CITEZEN'
592        ReferencingColumn = 'ID'
593        IsParentKey = True
594        DisplayName = 'CITEZENID'
595      end
596      item
597        FieldName = 'STRUCTUREID'
598        FieldLabel = #1044#1086#1083#1078#1085#1086#1089#1090#1100
599        Nullable = False
600        FieldType = ftsNumber
601        ReferencingTable = 'CS_V_SCHEDULE_STRUCTURE'
602        ReferencingColumn = 'ID'
603        DisplayName = 'STRUCTUREID'
604      end
605      item
606        FieldName = 'AGREEMENTNUMB'
607        FieldLabel = #8470' '#1058#1088#1091#1076#1086#1074#1086#1075#1086' '#1076#1086#1075#1086#1074#1086#1088#1072
608        Nullable = True
609        FieldType = ftsString
610        DisplayName = 'AGREEMENTNUMB'
611      end
612      item
613        FieldName = 'OUTDATE'
614        FieldLabel = #1044#1072#1090#1072' '#1091#1074#1086#1083#1100#1085#1077#1085#1080#1103' '#1089' '#1076#1086#1083#1078#1085#1086#1089#1090#1080
615        Nullable = True
616        FieldType = ftsDate
617        DisplayName = 'OUTDATE'
618      end
619      item
620        FieldName = 'WORKUNITTYPE'
621        FieldLabel = #1058#1080#1087' '#1088#1072#1073#1086#1090#1099' ('#1086#1089#1085#1086#1074'./'#1089#1086#1074#1084'.)'
622        Nullable = False
623        FieldType = ftsNumber
624        ReferencingTable = 'HR_FACETCONTENT'
625        ReferencingColumn = 'ID'
626        LookUpRool = ' rowcontent'
627        DisplayName = 'WORKUNITTYPE'
628      end
629      item
630        FieldName = 'TABNUMB'
631        FieldLabel = #1058#1072#1073#1077#1083#1100#1085#1099#1081' '#1085#1086#1084#1077#1088
632        Nullable = True
633        FieldType = ftsString
634        DisplayName = 'TABNUMB'
635      end
636      item
637        FieldName = 'ID'
638        Nullable = True
639        FieldType = ftsNumber
640        ReferencingTable = 'HR_V_EMPLOYEE'
641        ReferencingColumn = 'ID'
642        LookUpRool = ' '#39#1055#1054#1044#1056'.'#8470#39'||DCODE||'#39' '#39'|| jobtitle||'#39' '#39'||qualification'
643        IsPrimaryKey = True
644        DisplayName = 'ID'
645      end
646      item
647        FieldName = 'CHANGESTATUSDATE'
648        FieldLabel = #1044#1072#1090#1072' '#1080#1079#1084#1077#1085#1077#1085#1080#1103' '#1089#1090#1072#1090#1091#1089#1072
649        Nullable = True
650        FieldType = ftsDate
651        DisplayName = 'CHANGESTATUSDATE'
652      end
653      item
654        FieldName = 'AGREEMENTDATE'
655        FieldLabel = #1044#1072#1090#1072' '#1090#1088#1091#1076#1086#1074#1086#1075#1086' '#1076#1086#1075#1086#1074#1086#1088#1072
656        Nullable = True
657        FieldType = ftsDate
658        DisplayName = 'AGREEMENTDATE'
659      end
660      item
661        FieldName = 'INDATE'
662        FieldLabel = #1044#1072#1090#1072' '#1087#1088#1080#1093#1086#1076#1072' '#1085#1072' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
663        Nullable = False
664        FieldType = ftsDate
665        DisplayName = 'INDATE'
666      end
667      item
668        FieldName = 'STATUS'
669        FieldLabel = #1057#1090#1072#1090#1091#1089
670        Nullable = True
671        FieldType = ftsNumber
672        DisplayName = 'STATUS'
673      end>
674    TableName = 'HR_EMPLOYEE'
675    Connection = DataModule1.ADConnection1
676    Left = 469
677    Top = 88
678  end
679  object PKDBTable3: TPKDBTable
680    Fields = <
681      item
682        FieldName = 'EMPLOYEEID'
683        FieldLabel = #1057#1086#1090#1088#1091#1076#1085#1080#1082
684        Nullable = True
685        FieldType = ftsNumber
686        ReferencingTable = 'HR_V_EMPLOYEE'
687        ReferencingColumn = 'ID'
688        IsParentKey = True
689        DisplayName = 'EMPLOYEEID'
690      end
691      item
692        FieldName = 'OLDSTRUCTUREID'
693        FieldLabel = #1057#1090#1072#1088#1072#1103' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
694        Nullable = True
695        FieldType = ftsNumber
696        ReferencingTable = 'CS_V_SCHEDULE_STRUCTURE'
697        ReferencingColumn = 'ID'
698        DisplayName = 'OLDSTRUCTUREID'
699      end
700      item
701        FieldName = 'AGREEMENTNUMB'
702        FieldLabel = #1053#1086#1084#1077#1088' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
703        Nullable = True
704        FieldType = ftsString
705        DisplayName = 'AGREEMENTNUMB'
706      end
707      item
708        FieldName = 'OUTDATE'
709        FieldLabel = #1044#1072#1090#1072' '#1086#1082#1086#1085'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
710        Nullable = True
711        FieldType = ftsDate
712        DisplayName = 'OUTDATE'
713      end
714      item
715        FieldName = 'EMPLOYERID'
716        FieldLabel = #1056#1072#1073#1086#1090#1086#1076#1072#1090#1077#1083#1100
717        Nullable = True
718        FieldType = ftsNumber
719        DisplayName = 'EMPLOYERID'
720      end
721      item
722        FieldName = 'AGREEMENTTYPE'
723        FieldLabel = #1058#1080#1087' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
724        Nullable = False
725        FieldType = ftsNumber
726        DisplayName = 'AGREEMENTTYPE'
727      end
728      item
729        FieldName = 'HOLIDAY_EXT'
730        FieldLabel = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1076#1086#1087'. '#1086#1090#1087#1091#1089#1082#1072
731        Nullable = True
732        FieldType = ftsNumber
733        DisplayName = 'HOLIDAY_EXT'
734      end
735      item
736        FieldName = 'HOLIDAY_GEN'
737        FieldLabel = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1086#1090#1087#1091#1089#1082#1072
738        Nullable = True
739        FieldType = ftsNumber
740        DisplayName = 'HOLIDAY_GEN'
741      end
742      item
743        FieldName = 'STATUSID'
744        FieldLabel = #1057#1090#1072#1090#1091#1089
745        Nullable = True
746        FieldType = ftsNumber
747        DisplayName = 'STATUSID'
748      end
749      item
750        FieldName = 'CHANGESTATUSDATE'
751        FieldLabel = #1044#1072#1090#1072' '#1080#1079#1084#1077#1085#1077#1085#1080#1103' '#1089#1090#1072#1090#1091#1089#1072
752        Nullable = True
753        FieldType = ftsDate
754        DisplayName = 'CHANGESTATUSDATE'
755      end
756      item
757        FieldName = 'AGREEMENTDATE'
758        FieldLabel = #1044#1072#1090#1072' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
759        Nullable = True
760        FieldType = ftsDate
761        DisplayName = 'AGREEMENTDATE'
762      end
763      item
764        FieldName = 'ID'
765        Nullable = False
766        FieldType = ftsNumber
767        IsPrimaryKey = True
768        DisplayName = 'ID'
769      end
770      item
771        FieldName = 'INDATE'
772        FieldLabel = #1044#1072#1090#1072' '#1085#1072#1095'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
773        Nullable = True
774        FieldType = ftsDate
775        DisplayName = 'INDATE'
776      end
777      item
778        FieldName = 'NEWSTRUCTUREID'
779        FieldLabel = #1053#1086#1074#1072#1103' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
780        Nullable = True
781        FieldType = ftsNumber
782        ReferencingTable = 'CS_V_SCHEDULE_STRUCTURE'
783        ReferencingColumn = 'ID'
784        DisplayName = 'NEWSTRUCTUREID'
785      end>
786    TableName = 'HR_EXTAGREEMENT'
787    NeedGenPrimaryKey = True
788    Connection = DataModule1.ADConnection1
789    PrimaryKeySeq = 'AE_IDSEQ'
790    Left = 438
791    Top = 159
792  end
793  object PKDBTable4: TPKDBTable
794    Fields = <
795      item
796        FieldName = 'EMPLOYEEID'
797        FieldLabel = #1057#1086#1090#1088#1091#1076#1085#1080#1082
798        Nullable = True
799        FieldType = ftsNumber
800        ReferencingTable = 'HR_EMPLOYEE'
801        ReferencingColumn = 'ID'
802        IsParentKey = True
803        DisplayName = 'EMPLOYEEID'
804      end
805      item
806        FieldName = 'NEWEMPLOEEID'
807        FieldLabel = #1053#1086#1074#1099#1081' '#1089#1086#1090#1088#1091#1076#1085#1080#1082
808        Nullable = True
809        FieldType = ftsString
810        DisplayName = 'NEWEMPLOEEID'
811      end
812      item
813        FieldName = 'AGREEMENTID'
814        FieldLabel = #1057#1086#1075#1083#1072#1096#1077#1085#1080#1077
815        Nullable = True
816        FieldType = ftsNumber
817        DisplayName = 'AGREEMENTID'
818      end
819      item
820        FieldName = 'ID'
821        Nullable = False
822        FieldType = ftsNumber
823        IsPrimaryKey = True
824        DisplayName = 'ID'
825      end
826      item
827        FieldName = 'ORDERNUMB'
828        FieldLabel = #1053#1086#1084#1077#1088' '#1087#1088#1080#1082#1072#1079#1072
829        Nullable = True
830        FieldType = ftsString
831        DisplayName = 'ORDERNUMB'
832      end
833      item
834        FieldName = 'STATUSID'
835        FieldLabel = #1057#1090#1072#1090#1091#1089
836        Nullable = True
837        FieldType = ftsString
838        DisplayName = 'STATUSID'
839      end
840      item
841        FieldName = 'CHANGESTATUSDATE'
842        FieldLabel = #1044#1072#1090#1072' '#1089#1084#1077#1085#1099' '#1089#1090#1072#1090#1091#1089#1072
843        Nullable = True
844        FieldType = ftsDate
845        DisplayName = 'CHANGESTATUSDATE'
846      end
847      item
848        FieldName = 'ORDERDATE'
849        FieldLabel = #1044#1072#1090#1072' '#1087#1088#1080#1082#1072#1079#1072
850        Nullable = True
851        FieldType = ftsDate
852        DisplayName = 'ORDERDATE'
853      end>
854    TableName = 'HR_APPOINT_ORDER'
855    NeedGenPrimaryKey = True
856    Connection = DataModule1.ADConnection1
857    PrimaryKeySeq = 'AE_IDSEQ'
858    Left = 470
859    Top = 159
860  end
861end