Snowflake

Snowflake is populated nightly from Banner tables.

The report focuses on term and section-related information, specifically targeting reporting years and fiscal years. It gathers and processes data from four primary tables: COSBANNERPROD_SATURN_SSBSECT, COSBANNERPROD_SATURN_STVACCT, COSBANNERPROD_FIMSMGR_FTVFSYR, and COSBANNERPROD_SATURN_STVTERM. It applies the logic detailed here by Accounting Method:

Banner 320 Calculation of Contact Hours | Reporting Date Procedures

Vanessa Escobar (Scheduling Coordinator/Administrative Assistant)

@Jordan Lamb (Data Steward), @Joshua Metry (Programmer Analyst)

Kristin Robinson (Dean of Enrollment Management)

Academic

No

Minimum Term

Allows user to choose a term code from the current term or before. Uses that term code to decide what term and greater data should be returned for.

TERM

SSBSECT_TERM_CODE

CRN

SSBSECT_CRN

SUBJECT

SSBSECT_SUBJ_CODE

COURSE

SSBSECT_CRSE_NUMB

CENSUS_ENROLLMENT

SSBSECT_CENSUS_ENRL

PART OF TERM

SSBSECT_PTRM_CODE

Does not exist for Open Learning Sections

ACCOUNTING METHOD

SSBSECT_ACCT_CODE

PART OF TERM START DATE

Calculated from SSBSECT_PTRM_START_DATE or SSBSECT_LEARNER_REGSTART_FDATE if SSBSECT_PTRM_START_DATE is null

Grabs the Open Learning Start Date if no Part of Term Start Date exists.

PART OF TERM END DATE

Calculated from SSBSECT_PTRM_END_DATE or SSBSECT_LEARNER_REGSTART_TDATE if SSBSECT_PTRM_END_DATE is null

Grabs the Open Learning End Date if no Part of Term End Date exists.

CENSUS ENROLL DATE

SSBSECT_CENSUS_ENRL_DATE

Census Enrollment Date as Banner calculated from other processes and pages.

REPORTING YEAR

SSBSECT_ACYR_CODE

Reporting year as calculated or entered on Banner, SSASECT

CALCULATED REPORTING YEAR

Calculated based on Accounting Method (Banner 320 Calculation of Contact Hours | Reporting Date Procedures).

In order to validate if REPORTING YEAR is incorrect.