/HRManager/__history/APPOINTMENTEDITUnit.dfm.~28~
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