Data Source	Oracle, PROD_DB.ReportsNet
Job/Process Source (Refresh Interval)	V_ACAD_STUDENT_SUCCESS (Live Data)
Report Domain	SFRSTCR, SERDTSR, SERDTGL
Functional User(s)	Michelle Gilbert (Director Student Success), Charlene Briggs-Woods (Senior Clerical Assistant), (Student Success Coordinators)
Constituent(s)	n/a
Report Owner	Michelle Gilbert (Director Student Success)
Data Domain(s)	Academic
Contains PII	Yes

🛠 What It’s Used For

Summarizes what students are part of the Student Success Program and how they are meeting/not meeting the program requirements.

This Confluence link details how the form primarily feeding this report should be utilized:

🔘 Options

Options	Description
Term	Returns data for the student records that exist on SEADETL for the selected term.
Coordinator	Initials of the Student Success Coordinator
Banner ID	Used to only show records for the Banner ID entered. Must use the '@' sign. Must be “ALL” (case sensitive) if no individual Banner ID is entered.

Field Name	Data Source/Logic	Description (sample)
Coordinator	Returns the Coordinator who most recently has an Orientation record (`SERDTSR_SSER_CODE` = ‘SSO’) for the student.	n/a
Orientation, Counseling, Meeting 1-6	Lists the date if entered and 💩 emoji if no data is entered.	n/a
Meeting Requirements	New SSP Students have to have 1 counseling and 6 meetings per term. Returning SSP Students have to have 1 counseling and 4 meetings per term. If the Result column on the Service Assignment tab of SEADETL is anything other than "Y" or Null (blank) then it doesn't count towards meeting the requirements.	n/a
Online SSP Meeting	Notates if a meeting occurred online.	n/a
Leave Reason	Why a student is no longer going to be a part of SSP.	n/a
Registered in Term	Y/N flag for if a student is registered for the term listed.	n/a
Campus	Concatenation of all campus codes of CRNs the student is registered in.	n/a
After Hours or Online	If a student is only taking online sections or if none of their in-person sections occur during M-F, 7-5pm.	n/a