DED Table and #

STUDENT BASIC SB116

Name

FIRST TERM STUDENT VALIDLY ENROLLED IN CE

Short Name

FIRST TERM NONCR

Definition for UGRD

This element indicates the first term the student was enrolled in a CE course

The following bug has been submitted and remains open:
Query: X_IR_STBA_DAT Field: STRM1
Issue: This element indicates the first term the student was enrolled in a CE course. It should return no matter what career the student basic information is tied to for the student. Currently, it is returning for students in UGRD and some students in CEHS, but not students with CAREER= CE. Lack of attendance hour data is also impacting accuracy of field.
Advisement: Return first term (if < current term) where student has STDNT_ENRL_STAT = E in career = CE or CEHS. 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: FIRST TERM NONCR (SB55)

DED Entry Last Updated

7/2/2020

Record(s)

X_IR_STBA_DAT

Field Name

STRM1

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