PSRW_SchoolEnrollment (ver7.0.0)
This view returns school enrollment records. The main source table for this view is DM_SchoolEnrollment, which is refreshed with data nightly from the PowerSchool core tables related to school enrollments.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AsstPrincipal | 7.0.0 | Varchar2(79) | Source is Schools table. |
AsstPrincipalEmail | 7.0.0 | Varchar2(79) | Source is Schools table. |
AsstPrincipalPhone | 7.0.0 | Varchar2(31) | Source is Schools table. |
CountyName | 7.0.0 | Varchar2(79) | Source is Schools table. |
EntryCode | 7.0.0 | Varchar2(20) | Source is Students table for current enrollments. Source is ReEnrollments table for past enrollments. |
EntryDate | 7.0.0 | Date | Source is Students table for current enrollments. Source is ReEnrollments table for past enrollments. |
ExitCode | 7.0.0 | Varchar2(60) | Source is Students table for current enrollments. Source is ReEnrollments table for past enrollments. |
ExitDate | 7.0.0 | Date | Source is Students table for current enrollments. Source is ReEnrollments table for past enrollments. |
Grade_Level | 7.0.0 | Number(10) | Source is Students table for current enrollments. Source is ReEnrollments table for past enrollments. |
ID | 7.0.0 | Number(19) | Source is a sequence. |
Principal | 7.0.0 | Varchar2(79) | Source is Schools table. |
PrincipalEmail | 7.0.0 | Varchar2(79) | Source is Schools table. |
PrincipalPhone | 7.0.0 | Varchar2(31) | Source is Schools table. |
SchoolAddress | 7.0.0 | Varchar2(79) | Source is Schools table. |
SchoolCity | 7.0.0 | Varchar2(79) | Source is Schools table. |
SchoolCountry | 7.0.0 | Varchar2(79) | Source is Schools table. |
SchoolFax | 7.0.0 | Varchar2(31) | Source is Schools table. |
SchoolID | 7.0.0 | Number(10) | Source is Students table for current enrollments. Source is ReEnrollments table for past enrollments. |
SchoolName | 7.0.0 | Varchar2(60) | Source is Schools table for current enrollments and past enrollments. Required. |
SchoolPhone | 7.0.0 | Varchar2(31) | Source is Schools table. |
SchoolState | 7.0.0 | Varchar2(79) | Source is Schools table. |
SchoolYear | 7.0.0 | Varchar2(30) | Source is Terms table. |
SchoolZip | 7.0.0 | Varchar2(79) | Source is Schools table. |
SourceDCID | 7.0.0 | Number(10) | Source is Students table for current enrollments. Source is ReEnrollments table for past enrollments. |
SourceID | 7.0.0 | Number(10) | Source is Students table for current enrollments. Source is ReEnrollments table for past enrollments. |
SourceTable | 7.0.0 | Varchar2(13) | The string STUDENTS or REENROLLMENTS. |
StudentID | 7.0.0 | Number(10) | Source is Students table for current enrollments. Source is ReEnrollments table for past enrollments. Required. |
TermID | 7.0.0 | Number(10) | Source is Terms table. |
YearID | 7.0.0 | Number(10) | Source is Terms table. |