This report pulls data from PROD_DB on Snowflake

This report is built off of two views. The refresh interval would be daily as that is how often Snowflake is updated.

The Two views are:

PROD_DB.ACADEMIC.V_ACAD_SG21_STUDENTS_NOT_IN_WEXP

PROD_DB.ACADEMIC.V_ACAD_SG21_WEXP_STUDENTS_WITHOUT_WBLN_CODE

Brittney Faulkner (Work Experience Coordinator), Daniel Rivas (Clerical Assistant - WEXP)

Jordan Lamb (Data Steward)

Academic

Yes

TERM

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.