SPEnrollments, 41 (ver3.6.1)
Tracks students enrolled in student programs.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Code1 | 3.6.1 | Varchar(15) | SEOP self-contained code. |
Code2 | 3.6.1 | Varchar(15) | SEOP setting code. |
SP_Comment | 3.6.1 renamed in 5.2.0 | CLOB | Comment value. Populated when modified by a system process. Mass Create, Import, Drop. |
Custom | 3.6.1 | CLOB | This field holds all the SPEnrollments custom fields and their values. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Enter_Date | 3.6.1 | Date | The date the student enters a program. |
ExitCode | 3.6.1 | Varchar(15) | The reason the student left the program. |
Exit_Date | 3.6.1 | Date | The date the student left the program |
GradeLevel | 3.6.1 | Number(10,0) | Grade level of the student in this special program. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
ProgramID | 3.6.1 | Number(10,0) | Program ID from GEN table (cat=specprog) that is associated to this record. Indexed. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |