PageRenderTime 20ms CodeModel.GetById 15ms app.highlight 3ms RepoModel.GetById 0ms app.codeStats 0ms

/HRManager/__history/APPOINTMENTEDITUnit.dfm.~21~

https://github.com/oista/NPO
Unknown | 719 lines | 719 code | 0 blank | 0 comment | 0 complexity | 55ad9187b8fc573ccc7a9ea071992ea0 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 = 498
  4  ClientWidth = 519
  5  OnShow = FormShow
  6  ExplicitWidth = 525
  7  ExplicitHeight = 522
  8  PixelsPerInch = 96
  9  TextHeight = 13
 10  inherited Panel1: TPanel
 11    Left = 428
 12    Height = 498
 13    ExplicitLeft = 428
 14    ExplicitHeight = 498
 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  end
100  inherited PageControl1: TPageControl
101    Width = 422
102    Height = 492
103    ExplicitWidth = 422
104    ExplicitHeight = 492
105    inherited TabSheet1: TTabSheet
106      Caption = #1054#1092#1086#1088#1084#1083#1077#1085#1080#1077' '#1087#1077#1088#1077#1074#1086#1076#1072
107      ExplicitLeft = 4
108      ExplicitTop = 24
109      ExplicitWidth = 414
110      ExplicitHeight = 464
111      object Label2: TLabel
112        Left = 15
113        Top = 52
114        Width = 57
115        Height = 13
116        Caption = #1044#1086#1083#1078#1085#1086#1089#1090#1100
117      end
118      object Label1: TLabel
119        Left = 15
120        Top = 187
121        Width = 243
122        Height = 13
123        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
124      end
125      object PKDBDictEdit2: TPKDBDictEdit
126        Left = 15
127        Top = 71
128        Width = 378
129        Height = 21
130        Connection = DataModule1.ADConnection1
131        Table = PKDBTable1
132        TableField = 'STRUCTUREID'
133        LookUpRool = #39#1055#1054#1044#1056'.'#8470#39'||DCODE||'#39' '#39'|| jobtitle||'#39' '#39'||qualification'
134        DictionaryClass = 'TVACANCY'
135        OnBeforeOpenButtonClick = PKDBDictEdit1BeforeOpenButtonClick
136        WithoutTable = False
137        DesignSize = (
138          378
139          21)
140      end
141      object PKDBLabelEdit3: TPKDBLabelEdit
142        Left = 15
143        Top = 115
144        Width = 178
145        Height = 21
146        TabOrder = 1
147        Text = #1058#1072#1073'.'#8470
148        Table = PKDBTable1
149        TableField = 'TABNUMB'
150        EditLabel.Width = 35
151        EditLabel.Height = 13
152        EditLabel.Caption = #1058#1072#1073'.'#8470
153      end
154      object PKDBLabelEdit4: TPKDBLabelEdit
155        Left = 15
156        Top = 160
157        Width = 178
158        Height = 21
159        TabOrder = 2
160        Text = #1044#1072#1090#1072' '#1087#1088#1080#1093#1086#1076#1072' '#1085#1072' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
161        EditKind = ekDateEdit
162        Table = PKDBTable1
163        TableField = 'INDATE'
164        EditLabel.Width = 146
165        EditLabel.Height = 13
166        EditLabel.Caption = #1044#1072#1090#1072' '#1087#1088#1080#1093#1086#1076#1072' '#1085#1072' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
167      end
168      object PKDBLabelEdit5: TPKDBLabelEdit
169        Left = 215
170        Top = 160
171        Width = 178
172        Height = 21
173        TabOrder = 3
174        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
175        Visible = False
176        EditKind = ekDateEdit
177        Table = PKDBTable1
178        TableField = 'OUTDATE'
179        EditLabel.Width = 156
180        EditLabel.Height = 13
181        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
182      end
183      object PKDBDictEdit3: TPKDBDictEdit
184        Left = 215
185        Top = 115
186        Width = 0
187        Height = 19
188        Table = PKDBTable1
189        TableField = 'WORKUNITTYPE'
190        LookUpRool = ' id'
191        WithoutTable = False
192        DesignSize = (
193          0
194          19)
195      end
196      object PKDBDictLabelEdit1: TPKDBDictLabelEdit
197        Left = 15
198        Top = 25
199        Width = 378
200        Height = 21
201        Connection = DataModule1.ADConnection1
202        Table = PKDBTable1
203        TableField = 'CITEZENID'
204        LookUpRool = 'lastname||'#39' '#39'||name||'#39' '#39'||fathership||'#39' '#1087#1072#1089#1087#1086#1088#1090' '#8470#39'||PASSPORTNUMB'
205        DictionaryClass = 'TEMPLOYEE'
206        WithoutTable = False
207        EditLabel.Width = 57
208        EditLabel.Height = 13
209        EditLabel.Caption = #1043#1088#1072#1078#1076#1072#1085#1080#1085
210        DesignSize = (
211          378
212          21)
213      end
214      object PKDBDictEdit1: TPKDBDictEdit
215        Left = 15
216        Top = 205
217        Width = 378
218        Height = 21
219        Connection = DataModule1.ADConnection1
220        Table = PKDBTable2
221        TableField = 'ID'
222        LookUpRool = #39#1055#1054#1044#1056'.'#8470#39'||DCODE||'#39' '#39'|| jobtitle||'#39' '#39'||qualification'
223        OnBeforeOpenButtonClick = PKDBDictEdit1BeforeOpenButtonClick
224        WithoutTable = False
225        DesignSize = (
226          378
227          21)
228      end
229      object GroupBox1: TGroupBox
230        Left = 3
231        Top = 248
232        Width = 406
233        Height = 213
234        Caption = '  '#1044#1086#1087'. '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1077' '
235        TabOrder = 7
236        object PKDBLabelEdit2: TPKDBLabelEdit
237          Left = 212
238          Top = 36
239          Width = 178
240          Height = 21
241          TabOrder = 0
242          Text = #1044#1072#1090#1072' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
243          EditKind = ekDateEdit
244          Table = EMPLOYEE.PKDBTable3
245          TableField = 'AGREEMENTDATE'
246          EditLabel.Width = 89
247          EditLabel.Height = 13
248          EditLabel.Caption = #1044#1072#1090#1072' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
249        end
250        object PKDBLabelEdit1: TPKDBLabelEdit
251          Left = 12
252          Top = 36
253          Width = 178
254          Height = 21
255          TabOrder = 1
256          Text = #1053#1086#1084#1077#1088' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
257          Table = PKDBTable3
258          TableField = 'AGREEMENTNUMB'
259          EditLabel.Width = 94
260          EditLabel.Height = 13
261          EditLabel.Caption = #1053#1086#1084#1077#1088' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
262        end
263        object PKDBLabelEdit6: TPKDBLabelEdit
264          Left = 12
265          Top = 80
266          Width = 178
267          Height = 21
268          Color = clWhite
269          TabOrder = 2
270          Text = #1044#1072#1090#1072' '#1085#1072#1095'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
271          EditKind = ekDateEdit
272          Table = EMPLOYEE.PKDBTable3
273          TableField = 'INDATE'
274          EditLabel.Width = 137
275          EditLabel.Height = 13
276          EditLabel.Caption = #1044#1072#1090#1072' '#1085#1072#1095'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
277        end
278        object CheckBox1: TCheckBox
279          AlignWithMargins = True
280          Left = 12
281          Top = 159
282          Width = 389
283          Height = 17
284          Margins.Left = 10
285          Margins.Bottom = 8
286          Caption = #1042#1099#1074#1077#1089#1090#1080' '#1092#1086#1088#1084#1091' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
287          TabOrder = 3
288        end
289        object PKDBLabelEdit7: TPKDBLabelEdit
290          Left = 12
291          Top = 126
292          Width = 178
293          Height = 21
294          TabOrder = 4
295          Text = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1086#1090#1087#1091#1089#1082#1072
296          EditKind = ekNumberEdit
297          Table = PKDBTable3
298          TableField = 'HOLIDAY_GEN'
299          EditLabel.Width = 102
300          EditLabel.Height = 13
301          EditLabel.Caption = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1086#1090#1087#1091#1089#1082#1072
302        end
303        object PKDBLabelEdit8: TPKDBLabelEdit
304          Left = 212
305          Top = 126
306          Width = 178
307          Height = 21
308          TabOrder = 5
309          Text = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1076#1086#1087'. '#1086#1090#1087#1091#1089#1082#1072
310          EditKind = ekNumberEdit
311          Table = PKDBTable3
312          TableField = 'HOLIDAY_EXT'
313          EditLabel.Width = 128
314          EditLabel.Height = 13
315          EditLabel.Caption = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1076#1086#1087'. '#1086#1090#1087#1091#1089#1082#1072
316        end
317        object PKDBLabelEdit9: TPKDBLabelEdit
318          Left = 212
319          Top = 80
320          Width = 178
321          Height = 21
322          TabOrder = 6
323          Text = #1044#1072#1090#1072' '#1086#1082#1086#1085'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
324          EditKind = ekDateEdit
325          Table = PKDBTable3
326          TableField = 'OUTDATE'
327          EditLabel.Width = 143
328          EditLabel.Height = 13
329          EditLabel.Caption = #1044#1072#1090#1072' '#1086#1082#1086#1085'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
330        end
331        object CheckBox2: TCheckBox
332          Left = 12
333          Top = 184
334          Width = 261
335          Height = 17
336          Caption = #1042#1099#1074#1077#1089#1090#1080' '#1087#1088#1080#1082#1072#1079' '#1086' '#1087#1077#1088#1077#1074#1086#1076#1077
337          TabOrder = 7
338        end
339      end
340    end
341  end
342  inherited PKDBTable1: TPKDBTable
343    Fields = <
344      item
345        FieldName = 'CITEZENID'
346        FieldLabel = #1043#1088#1072#1078#1076#1072#1085#1080#1085
347        Nullable = True
348        FieldType = ftsNumber
349        ReferencingTable = 'HR_V_CITEZEN'
350        ReferencingColumn = 'ID'
351        IsParentKey = True
352        DisplayName = 'CITEZENID'
353      end
354      item
355        FieldName = 'STRUCTUREID'
356        FieldLabel = #1044#1086#1083#1078#1085#1086#1089#1090#1100
357        Nullable = True
358        FieldType = ftsNumber
359        ReferencingTable = 'CS_V_SCHEDULE_STRUCTURE'
360        ReferencingColumn = 'ID'
361        DisplayName = 'STRUCTUREID'
362      end
363      item
364        FieldName = 'AGREEMENTNUMB'
365        FieldLabel = #8470' '#1058#1088#1091#1076#1086#1074#1086#1075#1086' '#1076#1086#1075#1086#1074#1086#1088#1072
366        Nullable = True
367        FieldType = ftsString
368        DisplayName = 'AGREEMENTNUMB'
369      end
370      item
371        FieldName = 'PREVIOUSID'
372        FieldLabel = #1055#1088#1077#1076#1080#1076#1091#1097#1072#1103' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
373        Nullable = True
374        FieldType = ftsNumber
375        DisplayName = 'PREVIOUSID'
376      end
377      item
378        FieldName = 'OUTDATE'
379        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
380        Nullable = True
381        FieldType = ftsDate
382        DisplayName = 'OUTDATE'
383      end
384      item
385        FieldName = 'CHANGESTATUSDATE'
386        FieldLabel = #1044#1072#1090#1072' '#1080#1079#1084#1077#1085#1077#1085#1080#1103' '#1089#1090#1072#1090#1091#1089#1072
387        Nullable = True
388        FieldType = ftsDate
389        DisplayName = 'CHANGESTATUSDATE'
390      end
391      item
392        FieldName = 'AGREEMENTDATE'
393        FieldLabel = #1044#1072#1090#1072' '#1090#1088#1091#1076#1086#1074#1086#1075#1086' '#1076#1086#1075#1086#1074#1086#1088#1072
394        Nullable = True
395        FieldType = ftsDate
396        DisplayName = 'AGREEMENTDATE'
397      end
398      item
399        FieldName = 'WORKUNITTYPE'
400        FieldLabel = #1058#1080#1087' '#1088#1072#1073#1086#1090#1099' ('#1086#1089#1085#1086#1074'./'#1089#1086#1074#1084'.)'
401        Nullable = True
402        FieldType = ftsNumber
403        DisplayName = 'WORKUNITTYPE'
404      end
405      item
406        FieldName = 'TABNUMB'
407        FieldLabel = #1058#1072#1073#1077#1083#1100#1085#1099#1081' '#1085#1086#1084#1077#1088
408        Nullable = True
409        FieldType = ftsString
410        DisplayName = 'TABNUMB'
411      end
412      item
413        FieldName = 'ID'
414        Nullable = False
415        FieldType = ftsNumber
416        IsPrimaryKey = True
417        DisplayName = 'ID'
418      end
419      item
420        FieldName = 'INDATE'
421        FieldLabel = #1044#1072#1090#1072' '#1087#1088#1080#1093#1086#1076#1072' '#1085#1072' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
422        Nullable = False
423        FieldType = ftsDate
424        DisplayName = 'INDATE'
425      end
426      item
427        FieldName = 'DESCR'
428        FieldLabel = #1054#1087#1080#1089#1072#1085#1080#1077
429        Nullable = True
430        FieldType = ftsString
431        DisplayName = 'DESCR'
432      end
433      item
434        FieldName = 'STATUS'
435        FieldLabel = #1057#1090#1072#1090#1091#1089
436        Nullable = True
437        FieldType = ftsNumber
438        DisplayName = 'STATUS'
439      end
440      item
441        FieldName = 'WORKCONTRACTID'
442        Nullable = False
443        FieldType = ftsString
444        ReferencingTable = 'HR_WORKCONTRACT'
445        ReferencingColumn = 'ID'
446        DisplayName = 'WORKCONTRACTID'
447      end>
448    TableName = 'HR_EMPLOYEE'
449    NeedGenPrimaryKey = True
450    Connection = DataModule1.ADConnection1
451    PrimaryKeySeq = 'AE_IDSEQ'
452    Left = 437
453    Top = 88
454  end
455  object ADStoredProc2: TADStoredProc
456    Connection = DataModule1.ADConnection1
457    StoredProcName = 'APPROOT.HR_CHANGE_STRUCTUREID'
458    Left = 437
459    Top = 120
460    ParamData = <
461      item
462        Position = 1
463        Name = 'OBJECTID'
464        DataType = ftFMTBcd
465        ADDataType = dtFmtBCD
466        Precision = 38
467        NumericScale = 38
468        ParamType = ptInput
469      end
470      item
471        Position = 2
472        Name = 'EVENTDATE'
473        DataType = ftDateTime
474        ADDataType = dtDateTime
475        ParamType = ptInput
476      end>
477  end
478  object ADQuery1: TADQuery
479    Connection = DataModule1.ADConnection1
480    SQL.Strings = (
481      '-- '#1090#1072#1097#1080#1084' '#1089#1090#1072#1088#1091#1102' '#1076#1086#1083#1078#1085#1086#1089#1090#1100'.'
482      'SELECT '
483      '     ee.id, ee.workcontractid from HR_EMPLOYEE ee '
484      'WHERE '
485      '    (ee.citezenid = :ID) '
486      '-- '#1086#1089#1085#1086#1074#1085#1072#1103' '#1080' '#1072#1082#1090#1080#1074#1085#1072#1103
487      'AND (ee.workunittype = 3009016)'
488      'AND (ee.status = 1806638)'
489      'ORDER BY ee.indate DESC'
490      '')
491    Left = 469
492    Top = 120
493    ParamData = <
494      item
495        Name = 'ID'
496        DataType = ftInteger
497        ParamType = ptInput
498        Value = Null
499      end>
500    object ADQuery1ID: TFMTBCDField
501      FieldName = 'ID'
502      Required = True
503    end
504    object ADQuery1WORKCONTRACTID: TFMTBCDField
505      FieldName = 'WORKCONTRACTID'
506      Precision = 38
507      Size = 38
508    end
509  end
510  object PKDBTable2: TPKDBTable
511    Fields = <
512      item
513        FieldName = 'CITEZENID'
514        FieldLabel = #1043#1088#1072#1078#1076#1072#1085#1080#1085
515        Nullable = False
516        FieldType = ftsNumber
517        ReferencingTable = 'HR_V_CITEZEN'
518        ReferencingColumn = 'ID'
519        IsParentKey = True
520        DisplayName = 'CITEZENID'
521      end
522      item
523        FieldName = 'STRUCTUREID'
524        FieldLabel = #1044#1086#1083#1078#1085#1086#1089#1090#1100
525        Nullable = False
526        FieldType = ftsNumber
527        ReferencingTable = 'CS_V_SCHEDULE_STRUCTURE'
528        ReferencingColumn = 'ID'
529        DisplayName = 'STRUCTUREID'
530      end
531      item
532        FieldName = 'AGREEMENTNUMB'
533        FieldLabel = #8470' '#1058#1088#1091#1076#1086#1074#1086#1075#1086' '#1076#1086#1075#1086#1074#1086#1088#1072
534        Nullable = True
535        FieldType = ftsString
536        DisplayName = 'AGREEMENTNUMB'
537      end
538      item
539        FieldName = 'OUTDATE'
540        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
541        Nullable = True
542        FieldType = ftsDate
543        DisplayName = 'OUTDATE'
544      end
545      item
546        FieldName = 'WORKUNITTYPE'
547        FieldLabel = #1058#1080#1087' '#1088#1072#1073#1086#1090#1099' ('#1086#1089#1085#1086#1074'./'#1089#1086#1074#1084'.)'
548        Nullable = False
549        FieldType = ftsNumber
550        ReferencingTable = 'HR_FACETCONTENT'
551        ReferencingColumn = 'ID'
552        LookUpRool = ' rowcontent'
553        DisplayName = 'WORKUNITTYPE'
554      end
555      item
556        FieldName = 'TABNUMB'
557        FieldLabel = #1058#1072#1073#1077#1083#1100#1085#1099#1081' '#1085#1086#1084#1077#1088
558        Nullable = True
559        FieldType = ftsString
560        DisplayName = 'TABNUMB'
561      end
562      item
563        FieldName = 'ID'
564        Nullable = True
565        FieldType = ftsNumber
566        ReferencingTable = 'HR_V_EMPLOYEE'
567        ReferencingColumn = 'ID'
568        LookUpRool = ' '#39#1055#1054#1044#1056'.'#8470#39'||DCODE||'#39' '#39'|| jobtitle||'#39' '#39'||qualification'
569        IsPrimaryKey = True
570        DisplayName = 'ID'
571      end
572      item
573        FieldName = 'CHANGESTATUSDATE'
574        FieldLabel = #1044#1072#1090#1072' '#1080#1079#1084#1077#1085#1077#1085#1080#1103' '#1089#1090#1072#1090#1091#1089#1072
575        Nullable = True
576        FieldType = ftsDate
577        DisplayName = 'CHANGESTATUSDATE'
578      end
579      item
580        FieldName = 'AGREEMENTDATE'
581        FieldLabel = #1044#1072#1090#1072' '#1090#1088#1091#1076#1086#1074#1086#1075#1086' '#1076#1086#1075#1086#1074#1086#1088#1072
582        Nullable = True
583        FieldType = ftsDate
584        DisplayName = 'AGREEMENTDATE'
585      end
586      item
587        FieldName = 'INDATE'
588        FieldLabel = #1044#1072#1090#1072' '#1087#1088#1080#1093#1086#1076#1072' '#1085#1072' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
589        Nullable = False
590        FieldType = ftsDate
591        DisplayName = 'INDATE'
592      end
593      item
594        FieldName = 'STATUS'
595        FieldLabel = #1057#1090#1072#1090#1091#1089
596        Nullable = True
597        FieldType = ftsNumber
598        DisplayName = 'STATUS'
599      end>
600    TableName = 'HR_EMPLOYEE'
601    Connection = DataModule1.ADConnection1
602    Left = 469
603    Top = 88
604  end
605  object PKDBTable3: TPKDBTable
606    Fields = <
607      item
608        FieldName = 'EMPLOYEEID'
609        FieldLabel = #1057#1086#1090#1088#1091#1076#1085#1080#1082
610        Nullable = True
611        FieldType = ftsNumber
612        ReferencingTable = 'HR_V_EMPLOYEE'
613        ReferencingColumn = 'ID'
614        IsParentKey = True
615        DisplayName = 'EMPLOYEEID'
616      end
617      item
618        FieldName = 'OLDSTRUCTUREID'
619        FieldLabel = #1057#1090#1072#1088#1072#1103' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
620        Nullable = True
621        FieldType = ftsNumber
622        ReferencingTable = 'CS_V_SCHEDULE_STRUCTURE'
623        ReferencingColumn = 'ID'
624        DisplayName = 'OLDSTRUCTUREID'
625      end
626      item
627        FieldName = 'AGREEMENTNUMB'
628        FieldLabel = #1053#1086#1084#1077#1088' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
629        Nullable = True
630        FieldType = ftsString
631        DisplayName = 'AGREEMENTNUMB'
632      end
633      item
634        FieldName = 'OUTDATE'
635        FieldLabel = #1044#1072#1090#1072' '#1086#1082#1086#1085'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
636        Nullable = True
637        FieldType = ftsDate
638        DisplayName = 'OUTDATE'
639      end
640      item
641        FieldName = 'EMPLOYERID'
642        FieldLabel = #1056#1072#1073#1086#1090#1086#1076#1072#1090#1077#1083#1100
643        Nullable = True
644        FieldType = ftsNumber
645        DisplayName = 'EMPLOYERID'
646      end
647      item
648        FieldName = 'AGREEMENTTYPE'
649        FieldLabel = #1058#1080#1087' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
650        Nullable = False
651        FieldType = ftsNumber
652        DisplayName = 'AGREEMENTTYPE'
653      end
654      item
655        FieldName = 'HOLIDAY_EXT'
656        FieldLabel = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1076#1086#1087'. '#1086#1090#1087#1091#1089#1082#1072
657        Nullable = True
658        FieldType = ftsNumber
659        DisplayName = 'HOLIDAY_EXT'
660      end
661      item
662        FieldName = 'HOLIDAY_GEN'
663        FieldLabel = #1063#1080#1089#1083#1086' '#1076#1085#1077#1081' '#1086#1090#1087#1091#1089#1082#1072
664        Nullable = True
665        FieldType = ftsNumber
666        DisplayName = 'HOLIDAY_GEN'
667      end
668      item
669        FieldName = 'STATUSID'
670        FieldLabel = #1057#1090#1072#1090#1091#1089
671        Nullable = True
672        FieldType = ftsNumber
673        DisplayName = 'STATUSID'
674      end
675      item
676        FieldName = 'CHANGESTATUSDATE'
677        FieldLabel = #1044#1072#1090#1072' '#1080#1079#1084#1077#1085#1077#1085#1080#1103' '#1089#1090#1072#1090#1091#1089#1072
678        Nullable = True
679        FieldType = ftsDate
680        DisplayName = 'CHANGESTATUSDATE'
681      end
682      item
683        FieldName = 'AGREEMENTDATE'
684        FieldLabel = #1044#1072#1090#1072' '#1089#1086#1075#1083#1072#1096#1077#1085#1080#1103
685        Nullable = True
686        FieldType = ftsDate
687        DisplayName = 'AGREEMENTDATE'
688      end
689      item
690        FieldName = 'ID'
691        Nullable = False
692        FieldType = ftsNumber
693        IsPrimaryKey = True
694        DisplayName = 'ID'
695      end
696      item
697        FieldName = 'INDATE'
698        FieldLabel = #1044#1072#1090#1072' '#1085#1072#1095'. '#1076#1077#1081#1089#1090#1074'. '#1089#1086#1075#1083#1072#1096'.'
699        Nullable = True
700        FieldType = ftsDate
701        DisplayName = 'INDATE'
702      end
703      item
704        FieldName = 'NEWSTRUCTUREID'
705        FieldLabel = #1053#1086#1074#1072#1103' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
706        Nullable = True
707        FieldType = ftsNumber
708        ReferencingTable = 'CS_V_SCHEDULE_STRUCTURE'
709        ReferencingColumn = 'ID'
710        DisplayName = 'NEWSTRUCTUREID'
711      end>
712    TableName = 'HR_EXTAGREEMENT'
713    NeedGenPrimaryKey = True
714    Connection = DataModule1.ADConnection1
715    PrimaryKeySeq = 'AE_IDSEQ'
716    Left = 438
717    Top = 159
718  end
719end