/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

  1. inherited 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
  861. end