DED Table and #

COURSE SECTION CS043

Name

START DATE ENROLLMENT

Short Name

STARTENRL

Definition for UGRD

This element identifies the number of students enrolled on the START DATE. The interpretation of opening enrollment is dependent on accounting method and session type. For example, opening enrollment is less meaningful for open-entry/open-exit courses and courses in which start date and census date overlap. Always cross-reference/utilize accounting method when using any calculations involving start date.

The following bug has been submitted and remains open:
Query: X_IR_CRSE_DAT Field: X_IR_ENR_OPEN_DAY
Issue: This is supposed to be a count of students enrolled on the START_DATE. Currently, X_IR_ENR_OPEN_DAY is returning the incorrect data. It is always double what should be reported, based on my calculations.
Advisement: Check why the number is consistently double what it should be. Re-check to see if the following logic was followed:

Sum enrollment for CLASS_NUM and TERM if
if (((A_ENRL_ADD_DT <= B_START_DT) AND (A_ENRL_DROP_DT > B_START_DT))
OR
((A_ENRL_ADD_DT <= B_START_DT) AND (A_ENRL_DROP_DT == null)))

Definition for CE

Proceed with caution in using this field, as all CE courses are positive attendance and many course sections are open-entry, open exit.

Definition for CEHS

Interpret with caution based on the course structure (managed enrollment vs. OE/OE).

Origin

Element existed in legacy Datamart: OPENING ENRL (CS42)

DED Entry Last Updated

7/2/2020

Record(s)

X_IR_CRSE_DAT

Field Name

X_ENRL_OPEN_DAY

Heading Text

Enrl Open Day

Front-End Path

Derived field (calculation specific to Datamart)

Format

Num4.0

Value Labels for UGRD

No value labels needed

Example: 27

Value Labels for CE

Same as UGRD

Value Labels for CEHS

Same as UGRD

Derived element?

Yes

Key element?

No