DED Table and #

STUDENT BASIC SB117

Name

LAST TERM VALIDLY ENROLLED IN CREDIT COLLEGE

Short Name

LAST TERM CREDIT

Definition for UGRD

This element indicates the last term the student was enrolled at the credit colleges.

The following bug has been submitted and remains open:
Query: X_IR_STBA_DAT Field: STRM2
Issue: This element indicates the last term the student was enrolled at the credit colleges. It should return no matter what career the student basic information is tied to for the student. Currently, it is returning for students in CE and some students in CEHS, but not students with CAREER= UGRD.
Advisement: Return last term (but < current term) where student has STDNT_ENRL_STAT = E in career = UGRD. Return no matter if student basic information is for EMPLID in CAREER = UGRD, CE, or CEHS.

Definition for CE

Same as UGRD

Definition for CEHS

Same as UGRD

Origin

Element existed in legacy Datamart: LAST TERM CREDIT (SB57)

DED Entry Last Updated

7/2/2020

Record(s)

X_IR_STBA_DAT

Field Name

STRM2

Heading Text

Term

Front-End Path

Derived field (calculation specific to Datamart)

Format

Char4

Value Labels for UGRD

The term in MYYT format abbreviates the four-digit year by removing the hundred's place and T identifies the term.

First character: Millennium (M)
Second, Third : two - digit Year (YY)
Fourth: Term Identifier (T)

Term Identifiers:
Spring = 3
Summer = 5
Fall = 7

Example: 2197 = Fall 2019

Value Labels for CE

Same as UGRD

Value Labels for CEHS

Same as UGRD

Derived element?

Yes

Key element?

No