Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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)

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 %TERM_CODE. The first 4 digits are determined by the Academic Calendar end year. The last 2 digits refer to the semester/intersession where "10" represents Fall, "20" - Spring, and "30" - Summer.

Sequoias CCD has a preceding Summer Academic Calendar.

7% was used for Community Education

999999 is the STVTERM_TERM_CODE value used to represent “The End of Time” (The “End of Time” has an End Date of 05/15/2999. So, if you are reading this around that time plan accordingly. ⏲)

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.”

Error rendering macro 'excerpt-include' : No location was provided.

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 %TERM_CODE. The first 4 digits are determined by the Academic Calendar end year. The last 2 digits refer to the semester/intersession where "10" represents Fall, "20" - Spring, and "30" - Summer.

Sequoias CCD has a preceding Summer Academic Calendar.

7% was used for Community Education

999999 is the STVTERM_TERM_CODE value used to represent “The End of Time” (The “End of Time” has an End Date of 05/15/2999. So, if you are reading this around that time plan accordingly. ⏲)

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.

https://sequoias.atlassian.net/issues/?jql=type%20in%20(%22Database%20Object%22)%20ORDER%20BY%20created%20DESChttps://sequoias.atlassian.net/browse/GOVPUB-79

🗺 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. 6) Apr 25, 2024 15:46 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
  • No labels