Snowflake (Invoke)

Day-old Data ingestion into Snowflake.

Velia Rodriguez

Richard Lubben

No

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.

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.