DED Table and #

STUDENT BASIC SB132

Name

CURRENT ENROLLMENT STATUS (ADMIT TYPE)

Short Name

CUR_ENRLSTAT

Definition for UGRD

This is the student's current enrollment status.

If the student has no application data in Campus Solutions, they are presumed to have attended SDCCD previously and are assigned a 4. Students under this condition will have a blank FIRST_ENRLSTAT, RECENT_ENRLSTAT, APP_FIRSTTERM, and APP_RECENTTERM.

Students also receive a 4 (continuing student) if they applied and have had at least 1 valid enrollment (ENROLL_STAT=E in CAREER = UGRD) in a term prior to the current one. For example, a student who applied as a 3 in 2195 and enrolled in a UGRD course would be a 4 when they enrolled in 2197.

The exception are students who were admitted as first-time (1/1R). They will only become a 4 if they have had a valid enrollment in a non-summer term (term ending in 3 or 7). For example, a student who applied as a 1 in 2195 and enrolled in a UGRD course would be a 1 when they enrolled in 2197. In 2203, the student would transition to a 4.

The following bug was submitted and remains open:
1. Query: X_IR_STBA_DAT Field: X_IR_CUR_ENRL_STAT
Issue: Most of the issues identified during our meeting 12/20/2019 were fixed. However, Patrick and I identified one outstanding issue.

See example below:

This student was admitted in 2195 as a 1R. In 2195 the student should remain a 1R. 1s and 1Rs should not change to a 4 until the student has had an enrollment in a non-summer term less than the current term. So this student would have to be enrolled in 2197 to then get a 4 in 2203.

Currently, the coding seems to be picking up enrollments the student had at SDCCD during high school (presumably, it can also be that the application entry was wrong, but I think we still need to rely on this for reporting) and switching them to a 4 in the same term they applied as first time to college.

Another example of this happening is EMPLID: 0000240564.

Advisement: For 1s and 1Rs, coding should be modified that the student needs a valid enrollment (STDNT_ENROLL_STAT = E) in UGRD career in a term ending in 3 or 7 (not 5) less than the current term but also = to or > the last term of application (X_IR_APP_LST_TRM).

Definition for CE

This element does not apply to CE.

Definition for CEHS

This element does not apply to CEHS.

Origin

Element existed in legacy Datamart: Along with RECENT_ENRLSTAT, FIRST_ENRLSTAT, AREG, APFT, AAPT, AJSD, and APRV, provides nuance to ENRLSTAT (SB32)

DED Entry Last Updated

7/2/2020

Record(s)

X_IR_STBA_DAT

Field Name

X_IR_CUR_ENRL_STAT

Heading Text

Enrl Stat

Front-End Path

Derived field (calculation specific to Datamart)

Format

Char3

Value Labels for UGRD

1 = First Time
1R = FirstTimeR
2 = Transfer
2R = Transfer R
3 = Returning
4 = Continuing
Y = SpecialAdm
YR = SpecAdmitR

Value Labels for CE

N/A

Value Labels for CEHS

N/A

Derived element?

Yes

Key element?

No