Custom Table: saturn.szbscho
As of 09-MAR-2023:
SZBSCHO_TERM_CODE: 202310
SZBSCHO_AID_YR: 2324
SZBSCHO_TERM_BEGIN: 02-MAR-2023
SZBSCHO_ACTIVITY_DATE: 02-MAR-2023
SZBSCHO_SURROGATE_ID
SZBSCHO_VERSION
SZBSCHO_USER_ID: TROYMTAK
SZBSCHO_DATA_ORIGIN
SZBSCHO_VPDI_CODE
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
column#7: Student class (based on the term code)
Term Code parameter used
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
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.