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 8 Current »

Data Source

Snowflake (Invoke)

Job/Process Source (Refresh Interval)

Day-old Data ingestion into Snowflake.

Functional User(s)

Velia Rodriguez

Stakeholder(s)

Richard Lubben

Report Owner

Arianna Kennedy

Data Domain(s)

Academic

Contains PII

No

🛠 What It’s Used For

Detailed grade distribution breakdown by CRN (and related fields) for a given term, division, and/or department. Any course that has been deemed ungradable* has been filtered out of the results.

🔘 Options

Options

Description

Term

Selectable terms ranging from the current term to past terms as early as Fall 2000.

Division

‘All’ or any specific division that the user wishes to filter the report data. Options are populated by the selected term.

Department

‘All’ or any specific department that the user wishes to filter the report data. Options are populated by the selected term.

📄 Results

Field Name

Data Source/Logic

Description (sample)

Faculty

SPRIDEN.SPRIDEN_LAST_NAME

SPRIDEN.SPRIDEN_FIRST_NAME

SPRIDEN.SPRIDEN_MI

Combination of the primary instructor’s last, first, and middle name.

Course Title

SCBCRSE.SCBCRSE_TITLE

The course title

Subject

SSBSECT.SSBSECT_SUBJ_CODE

SSBSECT.SSBSECT_CRSE_NUMB

Combination of the course subject and course number

CRN

SSBSECT.SSBSECT_CRN

CRN

Grades & Registration Codes (30 Columns)

Grades: SHRGRDE.SHRGRDE_CODE

Registration Codes: SFRSTCR.SFRSTCR_RSTS_CODE

This includes all standard grades including their + and - designations, pass/no-pass, incompletes (with grade), and specific registration codes.

A+, A, A-, … IB+, IB, IB-… P, NP… DR, W

Total Passed

SHRGRDE.SHRGRDE_PASSED_IND

A total containing the sum of all passing grades per CRN

Total Enrolled

SHRGRDE.SHRGRDE_ATTEMPTED_IND

A total containing the sum of all enrolled students per CRN, regardless of final grade outcome.

🗺 Report Domain

*Ungradable data source is determined by SSBSECT.SSBSECT_GRADABLE_IND per CRN

Version Date Comment
Current Version (v. 8) Apr 13, 2023 18:27 Michael Citi
v. 8 Apr 13, 2023 18:27 Michael Citi
v. 7 Apr 13, 2023 18:22 Michael Citi
v. 6 Apr 13, 2023 18:19 Michael Citi
v. 5 Apr 13, 2023 17:47 Michael Citi
v. 4 Apr 13, 2023 17:32 Michael Citi
v. 3 Apr 13, 2023 17:30 Michael Citi
v. 2 Apr 13, 2023 17:15 Michael Citi
v. 1 Apr 13, 2023 16:20 Michael Citi
  • No labels