DED Table and #

COURSE SECTION CS044

Name

ENROLLMENT AT DYNAMIC ("ROLLING") CENSUS

Short Name

ENRLCX

Definition for UGRD

This element identifies the number of students enrolled in a class section at its census (session 1 or otherwise). Always cross-reference/utilize accounting method and session type when using any calculations involving census date. Some course sections may populate with census date even when this date is functionally meaningless.

The following bug has been submitted and remains open:
Query: X_IR_CRSE_DAT Field: X_IR_ENR_DYN_CNSUS
Issue: This is supposed to be a count of students enrolled at census (dynamic or regular). Currently, X_IR_ENR_DYN_CNSUS 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
(((A_ENRL_ADD_DT < B_CENSUS_DT) AND (A_ENRL_DROP_DT > B_CENSUS_DT))
OR
((A_ENRL_ADD_DT < B_CENSUS_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

Proceed with caution in using this field, as all CEHS courses are positive attendance.

Origin

This is an improvement of element of ENRL C1 (CS31).

DED Entry Last Updated

7/2/2020

Record(s)

X_IR_CRSE_DAT

Field Name

X_IR_ENR_DYN_CNSUS

Heading Text

Enrl Dyn Cen Dt

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