Useful for working with the GETALLSTUDENTSTATUS function.

student_status_id.sql

CASE STUDENT_STATUS_ID
  WHEN 1 THEN 'Application Cancelled'
  WHEN 2 THEN 'Alumni'
  WHEN 3 THEN 'Past Enrolment'
  WHEN 4 THEN 'Returning Enrolment'
  WHEN 5 THEN 'Current Enrolment'
  WHEN 6 THEN 'Place Accepted'
  WHEN 7 THEN 'Offered Place'
  WHEN 8 THEN 'Interview Pending'
  WHEN 9 THEN 'Wait Listed'
  WHEN 10 THEN 'Application Received'
  WHEN 11 THEN 'Information Sent'
  WHEN 12 THEN 'Enquiry'
  WHEN 13 THEN 'Interview Complete'
  WHEN 14 THEN 'Expired Offer'
  WHEN 15 THEN 'Expired Application'
  ELSE 'No Status'
END AS "STATUS"