DED Table and #

COURSE SECTION CS039

Name

SECOND CENSUS

Short Name

SECONDCENSUS

Definition for UGRD

This date 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, it functions as the last day a student can drop the section and receive a withdraw status.

Definition for CE

The second census is an important date for CE online course sections. Enrollment is captured at second census as part of the student FTES calculation.

Course FTEs for courses with a 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

If this date is populated for a UGRD section, we believe it functions as the last day a student can drop the section and receive a withdraw status.

For all other CE sections, this date is irrelevant if populated.

Definition for CEHS

This date 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 CEHS section, we believe it functions as the last day a student can drop the section and receive a withdraw status. Use with caution.

Origin

New element

DED Entry Last Updated

3/31/2021

Record(s)

X_IR_CRSE_DAT

Field Name

SIXTY_PCT_DT

Heading Text

60 Pct Dt

Front-End Path

Derived field (calculation specific to Datamart)

Format

Date

Value Labels for UGRD

Date format is MM/DD/YYYY

Example: 11/12/2019

Value Labels for CE

Same as UGRD

Value Labels for CEHS

Same as UGRD

Derived element?

Yes

Key element?

No