DM_SchoolEnrollment (ver7.0.0)
Data Mart table containing references to school enrollment records. This table is refreshed with data nightly from the PowerSchool core tables related to school enrollments. Table is used by ReportWorks as a source when creating school enrollment reports.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
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. Required. |
SchoolID | 7.0.0 | Number(10) | Source is Students table for current enrollments. Source is ReEnrollments table for past enrollments. |
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) | Contains the string ReEnrollments or Students. |
StudentID | 7.0.0 | Number(10) | Source is Students table for current enrollments. Source is ReEnrollments table for past enrollments. Required. |
TermDCID | 7.0.0 | Number(10) | Source is Terns table. Required. |