Child pages
  • SSP Special Service Group Advisor Email Notification on Course Withdrawal

Versions Compared

Key

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

...

Code Block
1. SELECT formatted_course, term_code, section_code, status_code, previous_status_code FROM person_course_status WHERE person_id IN (SELECT id FROM person WHERE school_id = 'school_id_here'); --If previous_status_code contains something, the student was added to the summary email for coach

2. SELECT school_id, formatted_course, term_code, section_code, status_code FROM external_student_transcript_course WHERE school_id = 'school_id_here';

3. SELECT first_name, last_name, school_id, username, primary_email_address, coach_school_id, coach_first_name, coach_last_name FROM mv_directory_person WHERE school_id = 'school_id_here';

...