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 Falkner |
Stakeholder(s) | |
Report Owner | Jordan Lamb |
Data Domain(s) | Academic |
Contains PII | No |
🛠 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.
🔘 Options
Options | Description |
|---|---|
TERM | This determines what term the data should look at to determine who to report on. |
📄 Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
🗺 Report Domain
| Version | Date | Comment |
|---|---|---|
| Current Version (v. 1) | Jul 28, 2023 18:05 | Joshua Metry |
| v. 7 | Apr 25, 2024 16:16 | Jordan Lamb |
| v. 6 | Apr 25, 2024 15:46 | Jordan Lamb |
| v. 5 | Nov 29, 2023 19:24 | Jordan Lamb |
| v. 4 | Jul 31, 2023 20:53 | Jordan Lamb |
| v. 3 | Jul 31, 2023 17:46 | Joshua Metry |
| v. 2 | Jul 31, 2023 17:33 | Joshua Metry |
| v. 1 | Jul 28, 2023 18:05 | Joshua Metry |
Add Comment