DED Table and #

STUDENT BASIC SB118

Name

LAST TERM STUDENT CONTACT MINUTES IN CE

Short Name

LAST TERM NCR

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: STRM3
Issue: This element indicates the last term the student was enrolled in a Continuing Education 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 last term (but < 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: LAST TERM NO NCR (SB58)

DED Entry Last Updated

7/2/2020

Record(s)

X_IR_STBA_DAT

Field Name

STRM3

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