Data Source | This report pulls data from PROD_DB on Snowflake |
|---|---|
Job/Process Source (Refresh Interval) | 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 |
Functional User(s) | Daniel Rivas and Brittney Faulkner |
Stakeholder(s) | |
Report Owner | Jordan Lamb |
Data Domain(s) | Academic |
Contains PII | NoYes |
🛠 What It’s Used For
SG21 is the Work Experience reporting. Sometimes students are in a Work experience class, but do not have the code to be counted as a work experience student. And some people have the code to designate them as a work experience student, but are not in any work experience classes. This report will help identify those individuals so they can be corrected for reporting.
...
Field Name | Data Source/Logic | Description (sample) | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
PIDM | This comes from different places depending on the issue type. If they have a WBLN code then it comes from SVRWBLN. If the 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 | |||||||||
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. | |||||||||
🗺 Report Domain
This comes from different places depending on the issue type. If they have a WBLN code then it comes from SVRWBLN. If the have course information but no WBLN Code then it comes from SFRSTCR where the Course is a Work Experience Course.
...
| Change History |
|---|