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_ENTRYDATE | 16.3.0 | DATE | The 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. |
| EXITREASON | 16.3.0 | VARCHAR2(3) | The exit reason for this enrollment. |
| GRADE_LEVEL | 15.7.0 | NUMBER(10,0) | The grade level for this enrollment. |
| ENROLLMENTTYPE | 15.8.0 | NUMBER(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_INDICATOR | 16.3.0 | NUMBER(1,0) | Indicate whether enrollment is a JTED enrollment. (i.e. 0 - No, 1 - Yes) |
| JTED_ORGID | 16.3.0 | VARCHAR2(19) | The organization ID related to this enrollment. |