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:
|
Functional User(s) | Brittney Faulkner (Work Experience Coordinator), Daniel Rivas (Clerical Assistant - WEXP) |
Report Owner | Jordan Lamb (Data Steward) |
Data Domain(s) | Academic |
Contains PII | Yes |
🛠 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 | Common alias for Sequoias CCD has a preceding Summer Academic Calendar. 7% was used for Community Education 999999 is the 000000, conversely, represents “The Beginning of Time” (The beginning of time has a Start Date at 01/01/1900. Nothing existed prior to this date. 🙃 ) |
📄 Results
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 they have course information but no WBLN Code, then it comes from SFRSTCR where the Course is a Work Experience Course. | Personal Identification Master Key is a unique ID number per person/non-person in Banner. This is PII. Each person/entity should have only one PIDM. Duplicate PIDMs are resolved in Applications and documented in technical resources. Is not display on Banner forms and is not normally visible to users. |
LAST_NAME | This comes from the SPRIDEN Table based off the PIDM grabbed from the above field and the change indicator being NULL | Common Definitions
A person’s legal surname. Often populated off CCCApply Application or manual entry by Human Resources. Allowed null for both persons and non-persons. |
FIRST_NAME | This comes from the SPRIDEN Table based off the PIDM grabbed from the above field and the change indicator being NULL | A person’s legal first name. Often populated off CCCApply Application or manual entry by Human Resources. Allowed null for both persons and non-persons. |
BANNER_ID | This comes from the SPRIDEN Table based off the PIDM grabbed from the above field and the change indicator being NULL | Commonly Referred to as Banner ID. This is a unique ID per person/non-person that begins with the “@” symbol. This is PII, but widely used as the least bad option where COS Employees have “legitimate educational interest.” |
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. | Common alias for Sequoias CCD has a preceding Summer Academic Calendar. 7% was used for Community Education 999999 is the 000000, conversely, represents “The Beginning of Time” (The beginning of time has a Start Date at 01/01/1900. Nothing existed prior to this date. 🙃 ) |
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. |
🗺 Report Domain
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.
| Version | Date | Comment |
|---|---|---|
| Current Version (v. 5) | Nov 29, 2023 19:24 | Jordan Lamb |
| 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 |
0 Comments