Skip to main content
Skip table of contents

CST_PUBENROLLMENT_TMP (ver 15.7.0)

Operational table used for determining new and changed student enrollments for reporting.  Note: Data is not permanently stored in this table.

Column Name

Version

Data Type

Description

DCID

15.7.0

NUMBER(10,0)

The DCID for this enrollment.

RECORD_TYPE

15.7.0

CHAR(1)

The record type for this enrollment.

STUDENTID

15.7.0

NUMBER(10,0)

The student ID for this enrollment.

ENTRYDATE

15.7.0

DATE

The entry date for this enrollment.

REF_DCID

15.7.0

NUMBER(10,0)

The reference DCID for this enrollment.

REF_ENTRYDATE16.3.0DATEThe reference entry date for this enrollment.

ENTRYCODE

15.7.0

VARCHAR2(20)

The entry code for this enrollment.

ENDDATE

15.7.0

DATE

The end date for this enrollment.

EXITCODE

15.7.0

VARCHAR2(20)

The exit code for this enrollment.

EXITREASON16.3.0VARCHAR2(3)The exit reason for this enrollment.
GRADE_LEVEL

15.7.0

NUMBER(10,0)

The grade level for this enrollment.

ENROLLMENTTYPE15.8.0NUMBER(2,0)The type of enrollment.
DISTRICTOFRESIDENCE

15.7.0

VARCHAR2(20)

The district of residence for this enrollment.

ENROLLMENTCODE

15.7.0

NUMBER(10,0)

The enrollment code for this enrollment.

TUITIONPAYER

15.7.0

NUMBER(10,0)

The tuition payer for this enrollment.

FTE

15.7.0

VARCHAR2(10)

The FTE for this enrollment.

JTED_INDICATOR16.3.0NUMBER(1,0)Indicate whether enrollment is a JTED enrollment. (i.e. 0 - No, 1 - Yes)
JTED_ORGID16.3.0VARCHAR2(19)The organization ID related to this enrollment.

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.