TU_SR_DD_AUDIT

Steps:

  1. Click the Reporting Tools link.   Step 1
  2. Click the Query link.   Step 2
  3. Click the Query Manager link.   Step 3
  4. Click the Create New Query link.   Step 4
  5. Enter the desired information into the begins with field. Enter "ENRL_".   Step 5
  6. Click the Search button.   Step 6
  7. Click an entry in the Add Record column.   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. Click the option.   Step 17
  18. Click the option.   Step 18
  19. Click the option.   Step 19
  20. Click the option.   Step 20
  21. Click the option.   Step 21
  22. Click the option.   Step 22
  23. Release the mouse button.   Step 23
  24. Click the option.   Step 24
  25. Click the option.   Step 25
  26. Click the option.   Step 26
  27. Release the mouse button.   Step 27
  28. Click the Records tab.   Step 28
  29. Enter the desired information into the begins with field. Enter "NAMES".   Step 29
  30. Click the Search button.   Step 30
  31. Click an entry in the Join Record column.   Step 31
  32. Click the A = ENRL_REQ_DETAIL - Enrollment Request Detail Line link.   Step 32
  33. Click the Add Criteria button.   Step 33
  34. Click the OK button.   Step 34
  35. Click the option.   Step 35
  36. Click the option.   Step 36
  37. Click the Records tab.   Step 37
  38. Enter the desired information into the begins with field. Enter "CLASS_T".   Step 38
  39. Click the Search button.   Step 39
  40. Click an entry in the Join Record column.   Step 40
  41. Click the A = ENRL_REQ_DETAIL - Enrollment Request Detail Line link.   Step 41
  42. Click the Add Criteria button.   Step 42
  43. Click the option.   Step 43
  44. Click the option.   Step 44
  45. Click the option.   Step 45
  46. Release the mouse button.   Step 46
  47. Click the option.   Step 47
  48. Release the mouse button.   Step 48
  49. Click the Fields tab.   Step 49
  50. Click the Add Criteria button.   Step 50
  51. Click the Prompt option.   Step 51
  52. Click the New Prompt link.   Step 52
  53. Click the Heading Type list.   Step 53
  54. Click the Text list item.   Step 54
  55. Enter the desired information into the Heading Text field. Enter "Enter ".   Step 55
  56. Enter the desired information into the Length field. Enter "4".   Step 56
  57. Click the Edit Type list.   Step 57
  58. Click the No Table Edit list item.   Step 58
  59. Click the OK button.   Step 59
  60. Click the OK button.   Step 60
  61. Click the Fields tab.   Step 61
  62. Click the Add Criteria button.   Step 62
  63. Click the Prompt option.   Step 63
  64. Click the New Prompt link.   Step 64
  65. Click the Text list item.   Step 65
  66. Enter the desired information into the Heading Text field. Enter "Enter ID".   Step 66
  67. Enter the desired information into the Length field. Enter "7".   Step 67
  68. Click the Edit Type list.   Step 68
  69. Click the No Table Edit list item.   Step 69
  70. Click the OK button.   Step 70
  71. Click the OK button.   Step 71
  72. Click the Add Criteria button.   Step 72
  73. Click the Field option.   Step 73
  74. Click the Select Record and Field button.   Step 74
  75. Click the Show Fields button.   Step 75
  76. Click the C.CLASS_NBR - Class Nbr link.   Step 76
  77. Click the OK button.   Step 77
  78. Release the mouse button.   Step 78
  79. Click the Add Criteria button.   Step 79
  80. Enter the desired information into the Constant field. Enter "PRI".   Step 80
  81. Click the OK button.   Step 81
  82. Click the Edit button.   Step 82
  83. Click the Long option.   Step 83
  84. Click the OK button.   Step 84
  85. Click the Edit button.   Step 85
  86. Click the Long option.   Step 86
  87. Click the OK button.   Step 87
  88. Click the Reorder / Sort button.   Step 88
  89. Release the mouse button.   Step 89
  90. Enter the desired information into the New Column field. Enter "1".   Step 90
  91. Scroll the Vertical Scroll Bar object with the mouse wheel.   Step 91
  92. Enter the desired information into the New Column field. Enter "2".   Step 92
  93. Scroll the Vertical Scroll Bar object with the mouse wheel.   Step 93
  94. Enter the desired information into the New Column field. Enter "3".   Step 94
  95. Release the mouse button.   Step 95
  96. Click the OK button.   Step 96
  97. Release the mouse button.   Step 97
  98. Click the Properties link.   Step 98
  99. Enter the desired information into the Query field. Enter "NQ_TU_SR_DD_AUDIT".   Step 99
  100. Enter the desired information into the Description field. Enter "Enrollment Transaction Audit".   Step 100
  101. Click the Owner list.   Step 101
  102. Click the Public list item.   Step 102
  103. Click the Distinct option.   Step 103
  104. Click the OK button.   Step 104
  105. Click the Save Query button.   Step 105
  106. Click the View SQL tab.   Step 106
  107. Click the Run tab.   Step 107
  108. Enter the desired information into the ENTER TERM field. Enter "1064".   Step 108
  109. Enter the desired information into the Enter ID field. Enter "0123834".   Step 109
  110. Click the OK button.   Step 110

Table of Contents   Start Topic