Versions Compared

Old Version 1

changes.mady.by.user Jordan Lamb

Saved on

compared with

New Version Current

changes.mady.by.user Jordan Lamb

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Data Source

Snowflake

Job/Process Source (Refresh Interval)

Snowflake is populated nightly from Banner tables.

Report Domain

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:

https://sequoias.atlassian.net/wiki/spaces/BF/pages/863305736/Banner+320+Calculation+of+Contact+Hours#Reporting-Date-Procedures

Functional User(s)

Vanessa Escobar (Scheduling Coordinator/Administrative Assistant)

StakeholderConstituent(s)

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

Report Owner

Kristin Robinson (Dean of Enrollment Management)

Data Domain(s)

Academic

Contains PII

No

...