Scholarship Manager (NextGen)

Custom Table: saturn.szbscho

As of 09-MAR-2023:

Package: szksch1.sql

• 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

szkscho.shl

File to create the extract and place in sFTP.