DED Table and #

COURSE SECTION CS045

Name

ENROLLMENT AT SECOND CENSUS

Short Name

ENROLLSECONDC

Definition for UGRD

Enrollment at second census is captured mainly for the purpose of deriving enrollments for CE online classes in order to calculate student FTES. If this date is populated for a UGRD section, we believe it communicates the number of students who were enrolled as of the last date to drop a course with a withdraw. Use with caution.

Due to issues with the calculation of the Sixty Percent Date, this field could not be tested. See below for how this field should be programmed:
Sum enrollment for CLASS_NUM and TERM if
(((A_ENRL_ADD_DT < B_SIXTY_PCT_DT) AND (A_ENRL_DROP_DT > B_SIXTY_PCT_DT))
OR
((A_ENRL_ADD_DT < B_SIXTY_PCT_DT) AND (A_ENRL_DROP_DT == null))

Definition for CE

Enrollment at the second census for online CE courses.

Course FTEs for courses with CAREER= CE and LOCATION = online should use the following equation:

FTES = ((WSCH1+ WSCH2)/2)/525

WSCH1 (aka First census)
((TOTALHRS/54) *Enrl_CX)*17.5

WSCH2 (aka Second census)
((TOTALHRS/54)*Enrl_CX2)*17.5

Definition for CEHS

Same as UGRD

Origin

New element

DED Entry Last Updated

7/2/2020

Record(s)

X_IR_CRSE_DAT

Field Name

X_IR_ENR_SIXTY_PCT

Heading Text

Enrl Sixty Pct

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