/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

  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 = 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
  719. end