TU_PR_DATE_ALL_CONT_PAY_W_JOB

Steps:

  1. Click the Query Manager link.   Step 1
  2. Click the Create New Query link.   Step 2
  3. Enter the desired information into the begins with field. Enter "PAY_E".   Step 3
  4. Click the Search button.   Step 4
  5. Click an entry in the Add Record column.   Step 5
  6. Click the option.   Step 6
  7. Click the option.   Step 7
  8. Click the option.   Step 8
  9. Click the option.   Step 9
  10. Click the option.   Step 10
  11. Click the option.   Step 11
  12. Click the option.   Step 12
  13. Release the mouse button.   Step 13
  14. Click the option.   Step 14
  15. Click the option.   Step 15
  16. Click the option.   Step 16
  17. Release the mouse button.   Step 17
  18. Click the Records tab.   Step 18
  19. Enter the desired information into the begins with field. Enter "PAY_O".   Step 19
  20. Click the Search button.   Step 20
  21. Click an entry in the Join Record column.   Step 21
  22. Click the A = PAY_EARNINGS - Payroll Earnings link.   Step 22
  23. Click the Add Criteria button.   Step 23
  24. Click the option.   Step 24
  25. Click the option.   Step 25
  26. Click the option.   Step 26
  27. Click the Records tab.   Step 27
  28. Enter the desired information into the begins with field. Enter "JOB".   Step 28
  29. Click the Search button.   Step 29
  30. Click an entry in the Join Record column.   Step 30
  31. Click the A = PAY_EARNINGS - Payroll Earnings link.   Step 31
  32. Click the Add Criteria button.   Step 32
  33. Click the OK button.   Step 33
  34. Click the option.   Step 34
  35. Release the mouse button.   Step 35
  36. Click the option.   Step 36
  37. Click the option.   Step 37
  38. Scroll the object with the mouse wheel.   Step 38
  39. Click the option.   Step 39
  40. Release the mouse button.   Step 40
  41. Click the Show next row (Alt+.) button.   Step 41
  42. Click the option.   Step 42
  43. Click the Records tab.   Step 43
  44. Enter the desired information into the begins with field. Enter "compen".   Step 44
  45. Click the Search button.   Step 45
  46. Click an entry in the Join Record column.   Step 46
  47. Click the C = JOB - EE Job History link.   Step 47
  48. Click the Add Criteria button.   Step 48
  49. Click the OK button.   Step 49
  50. Click the option.   Step 50
  51. Click the option.   Step 51
  52. Click the Fields tab.   Step 52
  53. Click the Add Criteria button.   Step 53
  54. Click the Condition Type list.   Step 54
  55. Click the in list list item.   Step 55
  56. Click the Select List Members button.   Step 56
  57. Click the Search button.   Step 57
  58. Enter the desired information into the Earnings Code field. Enter "CRG".   Step 58
  59. Click the OK button.   Step 59
  60. Enter the desired information into the Earnings Code field. Enter "ENP".   Step 60
  61. Click the OK button.   Step 61
  62. Click the OK button.   Step 62
  63. Click the OK button.   Step 63
  64. Release the mouse button.   Step 64
  65. Click the Criteria tab.   Step 65
  66. Click the Delete button.   Step 66
  67. Click the Delete button.   Step 67
  68. Release the mouse button.   Step 68
  69. Click the Add Criteria button.   Step 69
  70. Click the Select Record and Field button.   Step 70
  71. Click the Show Fields button.   Step 71
  72. Click the B.PAY_END_DT - Pay Period End Date link.   Step 72
  73. Enter the desired information into the Date field. Enter "09/15/2006".   Step 73
  74. Click the OK button.   Step 74
  75. Click the View SQL tab.   Step 75
  76. Release the mouse button.   Step 76
  77. Click the Save Query button.   Step 77
  78. Enter the desired information into the Query field. Enter "TU_DATE_ALL_CONT_PAY_W_JOB".   Step 78
  79. Click the Owner list.   Step 79
  80. Click the Public list item.   Step 80
  81. Enter the desired information into the Query Definition field. Enter "Locates employees for a certain date who have either CRG or ENP contract earnin".   Step 81
  82. Click the OK button.   Step 82
  83. Release the mouse button.   Step 83
  84. Click the Run tab.   Step 84

Table of Contents   Start Topic