PS_SchoolEnrollment (ver6.0.0)
This view provides information from the enrollment view for PowerSchool application for both current as well as past school enrollments.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
UniqueID | 6.0.0 | Longint | Sequential number generated by the view for uniqueness. |
SouceID | 6.0.0 | Longint | [From Students or Reenrollments] ID of students table or unique ID of the reenrollment view. |
SourceDCID | 6.0.0 | Longint | [From Students or Reenrollments] DCID of students table. |
SourceTable | 6.0.0 | String13 | [From Students or Reenrollments] Name of the source of the data can be either "Students" table for current enrollment or "Reenrollments" for past enrollments. |
StudentID | 6.0.0 | Longint | [From Students or Reenrollments] ID of students table. |
SchoolID | 6.0.0 | Longint | [From Students or Reenrollments] ID of the School for the school enrollment record. |
SchoolName | 6.0.0 | String60 | [From Schools] Name of the School for the school enrollment record. |
EntryDate | 6.0.0 | Date | [From Students or Reenrollments] Start/entry date of the school enrollment. |
EntryCode | 6.0.0 | String20 | [From Students or Reenrollments] Code for school enrollment entry. |
ExitDate | 6.0.0 | Date | [From Students or Reenrollments] End/Exit date of the school enrollment. |
ExitCode | 6.0.0 | String10 | [From Students or Reenrollments] Code for school enrollment exit. |
Grade_Level | 6.0.0 | Longint | [From Students or Reenrollments] Grade level of the Student for this enrollment record. |
YearID | 6.0.0 | Integer | [From Students or Reenrollments] Year ID of the term for this enrollment record. |