DED Table and #

COURSE SECTION CS038

Name

CENSUS DATE

Short Name

CENSUS

Definition for UGRD

The date on which a census of enrollment in the section is taken. 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.

Definition for CE

First census is an important date for CE online course sections. Enrollment is captured at first 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

Definition for CEHS

Same as UGRD

Origin

Element existed in legacy Datamart: CENSUS DATE (CS14)

DED Entry Last Updated

7/2/2020

Record(s)

X_IR_CRSE_DAT

Field Name

CENSUS_DT

Heading Text

Census Dt

Front-End Path

Derived field (calculation specific to Datamart)

Format

Date

Value Labels for UGRD

Date format is MM/DD/YYYY

Example: 09/03/2019

Value Labels for CE

Same as UGRD

Value Labels for CEHS

Same as UGRD

Derived element?

Yes

Key element?

No