Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Queries:

    • Registered Students

    • Newly Admit Students

      • Term Code parameter used

    • Active SGASTDN Record

    • UH Username exists

    • Active UH email address type

  • Data Columns:

    • column#1: UHSYS Student ID

    • column#2: Username (UH username) NOTE: as per Amy & Tara, is also Banner Student ID

    • column#3: UHSYS Email Address

    • column#4: Last Name

    • column#5: First Name

    • column#6: Home campus(based on the term code)

      • Term Code parameter used + 100, Fall term

    • column#7: Student class (based on the term code)

      • Term Code parameter used + 100, Fall term

    • column#8: UG Institutional credits earned

    • column#9: UG Institutional GPA

    • column#10: Institutional GPA (based on student's class on SGASTDN)

      • Term Code parameter used + 100, Fall term

    • column#11: UG Overall Attempted hours

    • column#12: UG Overall Passed hours

    • column#13: UG Overall GPA Hours

    • column#14: UG Overall Quality Points

    • column#15: UG Overall GPA

    • column#16: Home Campus(with the highest SGASTDN term code)

    • column#17: Gender

    • column#18: Citizenship

    • column#19: EFC

    • column#20: Student Type Code

    • column#21: Degree

    • column#22: Level

    • column#23: Major Code

    • column#24: Major Code Desc

    • column#25: Student Concentration Code 1 for Major 1

    • column#26: Student Concentration Description 1 for Major 1

    • column#27: Student Concentration Code 2 for Major 1

    • column#28: Student Concentration Description 2 for Major 1

    • column#29: Residency Code

    • column#30: Ethnicity

    • column#31: Legacy Code

...