Enrollment Status

Data Domain

Academic

Purpose

Returns Student Enrollment Type value based on PIDM and TERM

Explanation

This function finds the SGBSTDN_STYP_CODE based on PIDM and TERM code. It joins the validation table STVSTYP to find the associated description. This function returns the description and the code.

Sensitivity

Medium: Internal Use Only - Sensitive

Object Name

Activity

Pro tip: press M to comment

Jordan LambMay 5, 2023 at 9:27 PM

meeting thought “Enrollment Status” was better pending conversation in Data Governance.

·

Jordan LambMarch 14, 2023 at 10:37 PM

Consider changing name to something more descriptive. With final decision being up to data owner.

  • Student Enrollment Type

  • Student Classification

·

Jordan LambFebruary 28, 2023 at 7:15 PM

Changed Issue name after discussion we had about not recreating Banner functions.

·
Unresolved
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Server

Snowflake

Database

PROD_DB

Priority

Created February 24, 2023 at 12:42 AM
Updated March 31, 2025 at 5:15 PM