PIDM

This comes from different places depending on the issue type. If they have a WBLN code, then it comes from SVRWBLN. If they have course information but no WBLN Code, then it comes from SFRSTCR where the Course is a Work Experience Course.

LAST_NAME

This comes from the SPRIDEN Table based off the PIDM grabbed from the above field and the change indicator being NULL

FIRST_NAME

This comes from the SPRIDEN Table based off the PIDM grabbed from the above field and the change indicator being NULL

BANNER_ID

This comes from the SPRIDEN Table based off the PIDM grabbed from the above field and the change indicator being NULL

TERM_CODE

This comes from the Selection chosen in the Dropdown, but is used by the SFRSTCR and SVRWBLN tables to grab data for that term.

WBLN_CODE

This comes from the SVRWBLN table

Defines if a student is a Work Experience student for the term specified.

SUBJECT

This comes from the SFRSTCR table

COURSE

This comes from the SFRSTCR table

ISSUE

This is hard coded based off which query the data comes from.